eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_PL_ASSIGNMENT dependencies on FND_DATE

Line 218: if fnd_date.canonical_to_date(p_scl_segment11) < p_effective_date then

214: -----other validations like value set comparison will be taken
215: -----care by core when they validate the flexfields.
216: -----what we need to check are the dates being entered.
217: hr_utility.set_location(l_proc,30);
218: if fnd_date.canonical_to_date(p_scl_segment11) < p_effective_date then
219: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
220: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
221: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','ASSIGNMENT_START_DATE'));
222: hr_utility.raise_error;

Line 224: elsif fnd_date.canonical_to_date(p_scl_segment12) < fnd_date.canonical_to_date(p_scl_segment11) then

220: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
221: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','ASSIGNMENT_START_DATE'));
222: hr_utility.raise_error;
223:
224: elsif fnd_date.canonical_to_date(p_scl_segment12) < fnd_date.canonical_to_date(p_scl_segment11) then
225: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
226: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','PLANNED_VALID_TO_DATE'));
227: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
228: hr_utility.raise_error;

Line 230: elsif fnd_date.canonical_to_date(p_scl_segment13) < fnd_date.canonical_to_date(p_scl_segment11) then

226: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','PLANNED_VALID_TO_DATE'));
227: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
228: hr_utility.raise_error;
229:
230: elsif fnd_date.canonical_to_date(p_scl_segment13) < fnd_date.canonical_to_date(p_scl_segment11) then
231: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
232: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE'));
233: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
234: hr_utility.raise_error;

Line 237: elsif fnd_date.canonical_to_date(p_scl_segment13) < fnd_date.canonical_to_date(p_scl_segment14) then

233: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
234: hr_utility.raise_error;
235:
236: /* Bug4504375 :Contract type Change Date should not be before Date Contract Signed.*/
237: elsif fnd_date.canonical_to_date(p_scl_segment13) < fnd_date.canonical_to_date(p_scl_segment14) then
238: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
239: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE'));
240: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','DATE_CONTRACT_SIGNED'));
241: hr_utility.raise_error;

Line 249: elsif fnd_date.canonical_to_date(p_scl_segment14) < fnd_date.canonical_to_date(p_scl_segment11) then

245: This check has been removed because of bug 4504312 DATE CONTRACT SIGNED1 ACCEPTS DATES EVEN AFTER THE CONTRACT START DATE
246: Hence Date Contract Signed must be before or same as Contract Start Date. ie)(p_scl_segment14)<(p_scl_segment11)is the condition
247: to be held correct.Otherwise a note message is to be thrown.Since note messages cannot be thrown from api's there wont be any check for
248: Date contract Signed.
249: elsif fnd_date.canonical_to_date(p_scl_segment14) < fnd_date.canonical_to_date(p_scl_segment11) then
250: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
251: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','DATE_CONTRACT_SIGNED'));
252: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
253: hr_utility.raise_error;

Line 256: elsif fnd_date.canonical_to_date(p_scl_segment15) < fnd_date.canonical_to_date(p_scl_segment11) then

252: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
253: hr_utility.raise_error;
254: */
255:
256: elsif fnd_date.canonical_to_date(p_scl_segment15) < fnd_date.canonical_to_date(p_scl_segment11) then
257: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
258: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_DATE'));
259: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
260: hr_utility.raise_error;

Line 261: elsif fnd_date.canonical_to_date(p_scl_segment16) < fnd_date.canonical_to_date(p_scl_segment15) then

257: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
258: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_DATE'));
259: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
260: hr_utility.raise_error;
261: elsif fnd_date.canonical_to_date(p_scl_segment16) < fnd_date.canonical_to_date(p_scl_segment15) then
262: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
263: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_END_DATE'));
264: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=>hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_DATE'));
265: hr_utility.raise_error;

Line 366: select kyflx.segment3,kyflx.segment4,kyflx.segment6,fnd_date.canonical_to_date(segment13)

362: where assignment_id=P_ASSIGNMENT_ID
363: and P_EFFECTIVE_DATE between effective_start_date and effective_end_date;
364:
365: cursor csr_get_contract_details(r_date date) is
366: select kyflx.segment3,kyflx.segment4,kyflx.segment6,fnd_date.canonical_to_date(segment13)
367: from hr_soft_coding_keyflex kyflx , per_all_assignments_f paaf
368: where paaf.assignment_id = P_ASSIGNMENT_ID
369: and paaf.soft_coding_keyflex_id= kyflx.soft_coding_keyflex_id
370: and r_date between effective_start_date and effective_end_date;

Line 570: if fnd_date.canonical_to_date(p_segment11) < l_asg_min_start_date THEN --Bug 7041296 p_effective_date then

566: close csr_effective_start_date;
567:
568: --hr_utility.trace('Bug 7041296 : p_segment11 :'||p_segment11||'l_asg_min_start_date:'||l_asg_min_start_date);
569:
570: if fnd_date.canonical_to_date(p_segment11) < l_asg_min_start_date THEN --Bug 7041296 p_effective_date then
571: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
572: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
573: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','ASSIGNMENT_START_DATE'));
574: hr_utility.raise_error;

Line 576: elsif fnd_date.canonical_to_date(p_segment12) < fnd_date.canonical_to_date(p_segment11) then

572: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
573: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','ASSIGNMENT_START_DATE'));
574: hr_utility.raise_error;
575:
576: elsif fnd_date.canonical_to_date(p_segment12) < fnd_date.canonical_to_date(p_segment11) then
577: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
578: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','PLANNED_VALID_TO_DATE'));
579: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
580: hr_utility.raise_error;

Line 582: elsif fnd_date.canonical_to_date(p_segment13) < fnd_date.canonical_to_date(p_segment11) then

578: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','PLANNED_VALID_TO_DATE'));
579: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
580: hr_utility.raise_error;
581:
582: elsif fnd_date.canonical_to_date(p_segment13) < fnd_date.canonical_to_date(p_segment11) then
583: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
584: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE'));
585: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
586: hr_utility.raise_error;

Line 589: elsif fnd_date.canonical_to_date(p_segment13) < fnd_date.canonical_to_date(p_segment14) then

585: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
586: hr_utility.raise_error;
587:
588: /* Bug4504375 :Contract type Change Date should not be before Date Contract Signed.*/
589: elsif fnd_date.canonical_to_date(p_segment13) < fnd_date.canonical_to_date(p_segment14) then
590: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
591: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_TYPE_CHANGE_DATE'));
592: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','DATE_CONTRACT_SIGNED'));
593: hr_utility.raise_error;

Line 600: elsif fnd_date.canonical_to_date(p_segment14) < fnd_date.canonical_to_date(p_segment11) then

596: This check has been removed because of bug 4504312 DATE CONTRACT SIGNE D ACCEPTS DATES EVEN AFTER THE CONTRACT START DATE
597: Hence Date Contract Signed must be before or same as Contract Start Date. ie)(p_scl_segment14)<(p_scl_segment11)is the condition
598: to be held correct.Otherwise a note message is to be thrown.Since note messages cannot be thrown from api's there wont be any check for
599: Date contract Signed.
600: elsif fnd_date.canonical_to_date(p_segment14) < fnd_date.canonical_to_date(p_segment11) then
601: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
602: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','DATE_CONTRACT_SIGNED'));
603: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
604: hr_utility.raise_error;

Line 607: elsif fnd_date.canonical_to_date(p_segment15) < fnd_date.canonical_to_date(p_segment11) then

603: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
604: hr_utility.raise_error;
605: */
606:
607: elsif fnd_date.canonical_to_date(p_segment15) < fnd_date.canonical_to_date(p_segment11) then
608: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
609: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_DATE'));
610: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
611: hr_utility.raise_error;

Line 612: elsif fnd_date.canonical_to_date(p_segment16) < fnd_date.canonical_to_date(p_segment15) then

608: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
609: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_DATE'));
610: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_START_DATE'));
611: hr_utility.raise_error;
612: elsif fnd_date.canonical_to_date(p_segment16) < fnd_date.canonical_to_date(p_segment15) then
613: hr_utility.set_message(800,'HR_375853_DATE1_AFTER_DATE2');
614: hr_utility.set_message_token(l_token_name=>'DATE1',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_END_DATE'));
615: hr_utility.set_message_token(l_token_name=>'DATE2',l_token_value=> hr_general.decode_lookup('PL_FORM_LABELS','NOTICE_PERIOD_DATE'));
616: hr_utility.raise_error;