202: BEGIN
203: IF TO_DATE (p_effective_start_date, 'YYYY/MM/DD HH24:MI:SS') >
204: TO_DATE (p_effective_end_date, 'YYYY/MM/DD HH24:MI:SS')
205: THEN
206: fnd_message.set_name ('PAY', p_message_name);
207: fnd_message.raise_error;
208: END IF;
209: END check_date;
210:
203: IF TO_DATE (p_effective_start_date, 'YYYY/MM/DD HH24:MI:SS') >
204: TO_DATE (p_effective_end_date, 'YYYY/MM/DD HH24:MI:SS')
205: THEN
206: fnd_message.set_name ('PAY', p_message_name);
207: fnd_message.raise_error;
208: END IF;
209: END check_date;
210:
211: ---------------------------------------------------------------------------