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_AEI_INFO dependencies on HR_GENERAL

Line 56: l_end_of_time :=hr_general.end_of_time;

52: l_proc:=g_package||'CREATE_PL_PAYMENT_CONDITIONS';
53: hr_utility.set_location(l_proc,10);
54: l_date_from :=fnd_date.canonical_to_date(p_AEI_INFORMATION1);
55: l_date_to :=fnd_date.canonical_to_date(p_AEI_INFORMATION2);
56: l_end_of_time :=hr_general.end_of_time;
57:
58: if (l_date_from >l_date_to ) then
59: hr_utility.set_message(800,'HR_ORG_START_DATE_PL');
60: hr_utility.raise_error;

Line 85: hr_utility.set_message_token('WORKCOND',hr_general.decode_lookup('PL_TYPE_OF_SALARY',p_aei_information3));

81: close csr_payment_condition_ins;
82: if l_payment_cond_row.aei_information2 is not null then
83: --there exists an end date for the record...display both start and end dates
84: hr_utility.set_message(800,'HR_375854_OTHER_EIT_OVERLAP');
85: hr_utility.set_message_token('WORKCOND',hr_general.decode_lookup('PL_TYPE_OF_SALARY',p_aei_information3));
86: hr_utility.set_message_token('STARTDATE',fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_payment_cond_row.aei_information1)));
87: hr_utility.set_message_token('ENDDATE',fnd_date.date_to_displaydate(nvl(fnd_date.canonical_to_date(l_payment_cond_row.aei_information2),l_end_of_time)));
88: hr_utility.raise_error;
89: else

Line 93: hr_utility.set_message_token('WORKCOND',hr_general.decode_lookup('PL_TYPE_OF_SALARY',p_aei_information3));

89: else
90: --there doesnt exist a end date for this record...hence display only the start date
91: --new message being used as we cannot display 31-dec-4712 to user---
92: hr_utility.set_message(800,'HR_375870_OTHER_EIT_EXISTS');
93: hr_utility.set_message_token('WORKCOND',hr_general.decode_lookup('PL_TYPE_OF_SALARY',p_aei_information3));
94: hr_utility.set_message_token('STARTDATE',fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_payment_cond_row.aei_information1)));
95: hr_utility.raise_error;
96: end if; --aei information2 is not null
97: end if; --csr_payment_condition_ins found

Line 155: l_end_of_time :=hr_general.end_of_time;

151: l_proc:= g_package||'UPDATE_PL_PAYMENT_CONITIONS';
152: hr_utility.set_location('Entering '||l_proc,10);
153: l_date_from :=fnd_date.canonical_to_date(p_AEI_INFORMATION1);
154: l_date_to :=fnd_date.canonical_to_date(p_AEI_INFORMATION2);
155: l_end_of_time :=hr_general.end_of_time;
156:
157: if (l_date_from >l_date_to ) then
158: hr_utility.set_message(800,'HR_ORG_START_DATE_PL');
159: hr_utility.raise_error;

Line 186: hr_utility.set_message_token('WORKCOND',hr_general.decode_lookup('PL_TYPE_OF_SALARY',p_aei_information3));

182: close csr_payment_condition_upd;
183: if l_payment_cond_row.aei_information2 is not null then
184: --there exists an end date for the record...display both start and end dates
185: hr_utility.set_message(800,'HR_375854_OTHER_EIT_OVERLAP');
186: hr_utility.set_message_token('WORKCOND',hr_general.decode_lookup('PL_TYPE_OF_SALARY',p_aei_information3));
187: hr_utility.set_message_token('STARTDATE',fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_payment_cond_row.aei_information1)));
188: hr_utility.set_message_token('ENDDATE',fnd_date.date_to_displaydate(nvl(fnd_date.canonical_to_date(l_payment_cond_row.aei_information2),l_end_of_time)));
189: hr_utility.raise_error;
190: else

Line 194: hr_utility.set_message_token('WORKCOND',hr_general.decode_lookup('PL_TYPE_OF_SALARY',p_aei_information3));

190: else
191: --there doesnt exist a end date for this record...hence display only the start date
192: --new message being used as we cannot display 31-dec-4712 to user---
193: hr_utility.set_message(800,'HR_375870_OTHER_EIT_EXISTS');
194: hr_utility.set_message_token('WORKCOND',hr_general.decode_lookup('PL_TYPE_OF_SALARY',p_aei_information3));
195: hr_utility.set_message_token('STARTDATE',fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_payment_cond_row.aei_information1)));
196: hr_utility.raise_error;
197: end if; --aei information2 is not null
198: end if;--csr_payment_condition_upd found

Line 236: and nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)

232: and AEI_INFORMATION3=p_AEI_INFORMATION3
233: and (
234: fnd_date.canonical_to_date(p_aei_information1)
235: between fnd_date.canonical_to_date(aei_information1)
236: and nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
237: or nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)
238: between fnd_date.canonical_to_date(aei_information1)
239: and nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
240: or fnd_date.canonical_to_date( aei_information1)

Line 237: or nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)

233: and (
234: fnd_date.canonical_to_date(p_aei_information1)
235: between fnd_date.canonical_to_date(aei_information1)
236: and nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
237: or nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)
238: between fnd_date.canonical_to_date(aei_information1)
239: and nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
240: or fnd_date.canonical_to_date( aei_information1)
241: between fnd_date.canonical_to_date(p_aei_information1)

Line 239: and nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)

235: between fnd_date.canonical_to_date(aei_information1)
236: and nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
237: or nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)
238: between fnd_date.canonical_to_date(aei_information1)
239: and nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
240: or fnd_date.canonical_to_date( aei_information1)
241: between fnd_date.canonical_to_date(p_aei_information1)
242: and nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)
243: or nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)

Line 242: and nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)

238: between fnd_date.canonical_to_date(aei_information1)
239: and nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
240: or fnd_date.canonical_to_date( aei_information1)
241: between fnd_date.canonical_to_date(p_aei_information1)
242: and nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)
243: or nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
244: between fnd_date.canonical_to_date(p_aei_information1)
245: and fnd_date.canonical_to_date(p_aei_information2)
246: );

Line 243: or nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)

239: and nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
240: or fnd_date.canonical_to_date( aei_information1)
241: between fnd_date.canonical_to_date(p_aei_information1)
242: and nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)
243: or nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
244: between fnd_date.canonical_to_date(p_aei_information1)
245: and fnd_date.canonical_to_date(p_aei_information2)
246: );
247: l_work_cond_row csr_work_condition_date_ins%rowtype;

Line 285: nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)>l_assignment_end_date then

281:
282: hr_utility.set_location(g_package||l_proc,30);
283:
284: if (fnd_date.canonical_to_date(p_aei_information1) 285: nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)>l_assignment_end_date then
286: hr_utility.set_message(800,'HR_375865_ASSGT_START_END_DATE');
287: hr_utility.raise_error;
288: end if;
289:

Line 304: hr_utility.set_message_token('WORKCOND',hr_general.decode_lookup('PL_OTHER_WORK_CONDS',p_aei_information3));

300: close csr_work_condition_date_ins;
301: if l_work_cond_row.aei_information2 is not null then
302: --there exists an end date for the record...display both start and end dates
303: hr_utility.set_message(800,'HR_375854_OTHER_EIT_OVERLAP');
304: hr_utility.set_message_token('WORKCOND',hr_general.decode_lookup('PL_OTHER_WORK_CONDS',p_aei_information3));
305: hr_utility.set_message_token('STARTDATE',fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_work_cond_row.aei_information1)));
306: hr_utility.set_message_token('ENDDATE',fnd_date.date_to_displaydate(nvl(fnd_date.canonical_to_date(l_work_cond_row.aei_information2),hr_general.end_of_time)));
307: hr_utility.raise_error;
308: else

Line 306: hr_utility.set_message_token('ENDDATE',fnd_date.date_to_displaydate(nvl(fnd_date.canonical_to_date(l_work_cond_row.aei_information2),hr_general.end_of_time)));

302: --there exists an end date for the record...display both start and end dates
303: hr_utility.set_message(800,'HR_375854_OTHER_EIT_OVERLAP');
304: hr_utility.set_message_token('WORKCOND',hr_general.decode_lookup('PL_OTHER_WORK_CONDS',p_aei_information3));
305: hr_utility.set_message_token('STARTDATE',fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_work_cond_row.aei_information1)));
306: hr_utility.set_message_token('ENDDATE',fnd_date.date_to_displaydate(nvl(fnd_date.canonical_to_date(l_work_cond_row.aei_information2),hr_general.end_of_time)));
307: hr_utility.raise_error;
308: else
309: --there doesnt exist a end date for this record...hence display only the start date
310: --new message being used as we cannot display 31-dec-4712 to user---

Line 312: hr_utility.set_message_token('WORKCOND',hr_general.decode_lookup('PL_OTHER_WORK_CONDS',p_aei_information3));

308: else
309: --there doesnt exist a end date for this record...hence display only the start date
310: --new message being used as we cannot display 31-dec-4712 to user---
311: hr_utility.set_message(800,'HR_375870_OTHER_EIT_EXISTS');
312: hr_utility.set_message_token('WORKCOND',hr_general.decode_lookup('PL_OTHER_WORK_CONDS',p_aei_information3));
313: hr_utility.set_message_token('STARTDATE',fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_work_cond_row.aei_information1)));
314: hr_utility.raise_error;
315: end if; --aei information2 is not null
316: end if; --csr_work_condition_date_ins found

Line 377: and nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)

373: and ASSIGNMENT_EXTRA_INFO_ID<>P_ASSIGNMENT_EXTRA_INFO_ID
374: and (
375: fnd_date.canonical_to_date(p_aei_information1)
376: between fnd_date.canonical_to_date(aei_information1)
377: and nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
378: or nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)
379: between fnd_date.canonical_to_date(aei_information1)
380: and nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
381: or fnd_date.canonical_to_date(aei_information1)

Line 378: or nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)

374: and (
375: fnd_date.canonical_to_date(p_aei_information1)
376: between fnd_date.canonical_to_date(aei_information1)
377: and nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
378: or nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)
379: between fnd_date.canonical_to_date(aei_information1)
380: and nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
381: or fnd_date.canonical_to_date(aei_information1)
382: between fnd_date.canonical_to_date(p_aei_information1)

Line 380: and nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)

376: between fnd_date.canonical_to_date(aei_information1)
377: and nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
378: or nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)
379: between fnd_date.canonical_to_date(aei_information1)
380: and nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
381: or fnd_date.canonical_to_date(aei_information1)
382: between fnd_date.canonical_to_date(p_aei_information1)
383: and nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)
384: or nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)

Line 383: and nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)

379: between fnd_date.canonical_to_date(aei_information1)
380: and nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
381: or fnd_date.canonical_to_date(aei_information1)
382: between fnd_date.canonical_to_date(p_aei_information1)
383: and nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)
384: or nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
385: between fnd_date.canonical_to_date(p_aei_information1)
386: and fnd_date.canonical_to_date(p_aei_information2)
387: );

Line 384: or nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)

380: and nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
381: or fnd_date.canonical_to_date(aei_information1)
382: between fnd_date.canonical_to_date(p_aei_information1)
383: and nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)
384: or nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
385: between fnd_date.canonical_to_date(p_aei_information1)
386: and fnd_date.canonical_to_date(p_aei_information2)
387: );
388: l_assignment_id number;

Line 428: nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)>l_assignment_end_date then

424: fetch csr_assgt_start_date into l_assignment_start_date,l_assignment_end_date;
425: close csr_assgt_start_date;
426:
427: if (fnd_date.canonical_to_date(p_aei_information1) 428: nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)>l_assignment_end_date then
429: hr_utility.set_message(800,'HR_375865_ASSGT_START_END_DATE');
430: hr_utility.raise_error;
431: end if;
432:

Line 442: hr_utility.set_message_token('WORKCOND',hr_general.decode_lookup('PL_OTHER_WORK_CONDS',p_aei_information3));

438: close csr_work_condition_date_upd;
439: if l_work_cond_row.aei_information2 is not null then
440: --there exists an end date for the record...display both start and end dates
441: hr_utility.set_message(800,'HR_375854_OTHER_EIT_OVERLAP');
442: hr_utility.set_message_token('WORKCOND',hr_general.decode_lookup('PL_OTHER_WORK_CONDS',p_aei_information3));
443: hr_utility.set_message_token('STARTDATE',fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_work_cond_row.aei_information1)));
444: hr_utility.set_message_token('ENDDATE',fnd_date.date_to_displaydate(nvl(fnd_date.canonical_to_date(l_work_cond_row.aei_information2),hr_general.end_of_time)));
445: hr_utility.raise_error;
446: else

Line 444: hr_utility.set_message_token('ENDDATE',fnd_date.date_to_displaydate(nvl(fnd_date.canonical_to_date(l_work_cond_row.aei_information2),hr_general.end_of_time)));

440: --there exists an end date for the record...display both start and end dates
441: hr_utility.set_message(800,'HR_375854_OTHER_EIT_OVERLAP');
442: hr_utility.set_message_token('WORKCOND',hr_general.decode_lookup('PL_OTHER_WORK_CONDS',p_aei_information3));
443: hr_utility.set_message_token('STARTDATE',fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_work_cond_row.aei_information1)));
444: hr_utility.set_message_token('ENDDATE',fnd_date.date_to_displaydate(nvl(fnd_date.canonical_to_date(l_work_cond_row.aei_information2),hr_general.end_of_time)));
445: hr_utility.raise_error;
446: else
447: --there doesnt exist a end date for this record...hence display only the start date
448: --new message being used as we cannot display 31-dec-4712 to user---

Line 450: hr_utility.set_message_token('WORKCOND',hr_general.decode_lookup('PL_OTHER_WORK_CONDS',p_aei_information3));

446: else
447: --there doesnt exist a end date for this record...hence display only the start date
448: --new message being used as we cannot display 31-dec-4712 to user---
449: hr_utility.set_message(800,'HR_375870_OTHER_EIT_EXISTS');
450: hr_utility.set_message_token('WORKCOND',hr_general.decode_lookup('PL_OTHER_WORK_CONDS',p_aei_information3));
451: hr_utility.set_message_token('STARTDATE',fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_work_cond_row.aei_information1)));
452: hr_utility.raise_error;
453: end if; --aei information2 is not null
454: end if;--csr_work_condition_date_upd found