Special Value Set Restrict Date To Field
Special Value Set Restrict Date To Field
Special Value Set Restrict Date To Field
date_to_chardate(TO_DATE(ADD_MONTHS(LAST_DAY(TRUNC(SYSDATE)),
2)+1,'DDMMRRRR'))FROMdual
FND PLSQL " DECLARE
l_count NUMBER := 0;
l_value date := :!value ;
BEGIN
INTO l_count
FROM dual;
fnd_message.set_token( 'MESSAGE', 'You can run report max for 3 months period. Please change from
date and to date.' );
fnd_message.raise_error ;
END IF;
END;"
FND PLSQL " DECLARE
l_date DATE := :!value;
BEGIN
IF l_date > SYSDATE
THEN
fnd_message.set_name( 'FND', 'FND_GENERIC_MESSAGE') ;
fnd_message.set_token( 'MESSAGE', 'Date should be sysdate or less than sysdate.' );
fnd_message.raise_error ;
END IF;
END;"