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.HR_DK_VALIDATE_PKG dependencies on FND_DATE

Line 237: l_curr_sec27_sd := fnd_date.canonical_to_date(p_org_information2);

233:
234: /* Bug Fix 4994922 */
235: IF p_org_info_type_code = 'DK_SICKPAY_DEFAULTS' THEN
236:
237: l_curr_sec27_sd := fnd_date.canonical_to_date(p_org_information2);
238: l_curr_sec27_ed := fnd_date.canonical_to_date(p_org_information3);
239:
240: /* Check if Section 27 Registration start date is before end date */
241: IF l_curr_sec27_sd > l_curr_sec27_ed THEN

Line 238: l_curr_sec27_ed := fnd_date.canonical_to_date(p_org_information3);

234: /* Bug Fix 4994922 */
235: IF p_org_info_type_code = 'DK_SICKPAY_DEFAULTS' THEN
236:
237: l_curr_sec27_sd := fnd_date.canonical_to_date(p_org_information2);
238: l_curr_sec27_ed := fnd_date.canonical_to_date(p_org_information3);
239:
240: /* Check if Section 27 Registration start date is before end date */
241: IF l_curr_sec27_sd > l_curr_sec27_ed THEN
242: fnd_message.set_name('PER','HR_377068_DK_SECTION27_DATES_E');

Line 257: l_sec27_sd := fnd_date.canonical_to_date(l_sickpay_records(l_index).date1);

253: ELSE
254: FOR l_index IN 1 .. l_no_records LOOP
255:
256: l_sec27_reg := l_sickpay_records(l_index).value;
257: l_sec27_sd := fnd_date.canonical_to_date(l_sickpay_records(l_index).date1);
258: l_sec27_ed := fnd_date.canonical_to_date(l_sickpay_records(l_index).date2);
259:
260: IF l_curr_sec27_sd BETWEEN l_sec27_sd AND l_sec27_ed THEN
261: fnd_message.set_name('PER','HR_377069_DK_SECTION27_OVERLAP');

Line 258: l_sec27_ed := fnd_date.canonical_to_date(l_sickpay_records(l_index).date2);

254: FOR l_index IN 1 .. l_no_records LOOP
255:
256: l_sec27_reg := l_sickpay_records(l_index).value;
257: l_sec27_sd := fnd_date.canonical_to_date(l_sickpay_records(l_index).date1);
258: l_sec27_ed := fnd_date.canonical_to_date(l_sickpay_records(l_index).date2);
259:
260: IF l_curr_sec27_sd BETWEEN l_sec27_sd AND l_sec27_ed THEN
261: fnd_message.set_name('PER','HR_377069_DK_SECTION27_OVERLAP');
262: fnd_message.raise_error;

Line 376: l_curr_sec27_sd := fnd_date.canonical_to_date(p_org_information2);

372:
373: /* Bug Fix 4994922 */
374: IF p_org_info_type_code = 'DK_SICKPAY_DEFAULTS' THEN
375:
376: l_curr_sec27_sd := fnd_date.canonical_to_date(p_org_information2);
377: l_curr_sec27_ed := fnd_date.canonical_to_date(p_org_information3);
378:
379: /* Check if Section 27 Registration start date is before end date */
380: IF l_curr_sec27_sd > l_curr_sec27_ed THEN

Line 377: l_curr_sec27_ed := fnd_date.canonical_to_date(p_org_information3);

373: /* Bug Fix 4994922 */
374: IF p_org_info_type_code = 'DK_SICKPAY_DEFAULTS' THEN
375:
376: l_curr_sec27_sd := fnd_date.canonical_to_date(p_org_information2);
377: l_curr_sec27_ed := fnd_date.canonical_to_date(p_org_information3);
378:
379: /* Check if Section 27 Registration start date is before end date */
380: IF l_curr_sec27_sd > l_curr_sec27_ed THEN
381: fnd_message.set_name('PER','HR_377068_DK_SECTION27_DATES_E');

Line 396: l_sec27_sd := fnd_date.canonical_to_date(l_sickpay_records(l_index).date1);

392: ELSE
393: FOR l_index IN 1 .. l_no_records LOOP
394:
395: l_sec27_reg := l_sickpay_records(l_index).value;
396: l_sec27_sd := fnd_date.canonical_to_date(l_sickpay_records(l_index).date1);
397: l_sec27_ed := fnd_date.canonical_to_date(l_sickpay_records(l_index).date2);
398:
399: IF l_curr_sec27_sd BETWEEN l_sec27_sd AND l_sec27_ed THEN
400: fnd_message.set_name('PER','HR_377069_DK_SECTION27_OVERLAP');

Line 397: l_sec27_ed := fnd_date.canonical_to_date(l_sickpay_records(l_index).date2);

393: FOR l_index IN 1 .. l_no_records LOOP
394:
395: l_sec27_reg := l_sickpay_records(l_index).value;
396: l_sec27_sd := fnd_date.canonical_to_date(l_sickpay_records(l_index).date1);
397: l_sec27_ed := fnd_date.canonical_to_date(l_sickpay_records(l_index).date2);
398:
399: IF l_curr_sec27_sd BETWEEN l_sec27_sd AND l_sec27_ed THEN
400: fnd_message.set_name('PER','HR_377069_DK_SECTION27_OVERLAP');
401: fnd_message.raise_error;

Line 514: if fnd_date.canonical_to_date(p_segment7) < fnd_date.canonical_to_date(l_asg_start_date) then

510:
511: -- Validation rule : notified date > assignment start date --
512: if p_segment7 <> hr_api.g_varchar2 -- GSI Bug 4585094
513: and l_asg_start_date is not NULL then
514: if fnd_date.canonical_to_date(p_segment7) < fnd_date.canonical_to_date(l_asg_start_date) then
515: fnd_message.set_name('PER', 'HR_377006_DK_NOTIFIED_DATE');
516: hr_utility.raise_error;
517: end if;
518: end if;

Line 522: if fnd_date.canonical_to_date(p_segment8) < fnd_date.canonical_to_date(p_segment7) then

518: end if;
519: -- Validation rule : Termination date >= notified date --
520: if p_segment8 <> hr_api.g_varchar2 -- GSI Bug 4585094
521: and p_segment7 <> hr_api.g_varchar2 then
522: if fnd_date.canonical_to_date(p_segment8) < fnd_date.canonical_to_date(p_segment7) then
523: fnd_message.set_name('PER', 'HR_377007_DK_TERM_DATE_ERR');
524: hr_utility.raise_error;
525: end if;
526: end if;

Line 530: if fnd_date.canonical_to_date(p_segment9) >= fnd_date.canonical_to_date(p_segment7) then

526: end if;
527: -- Validation rule : Adjusted seniority date < notified date --
528: if p_segment9 <> hr_api.g_varchar2 -- GSI Bug 4585094
529: and p_segment7 <> hr_api.g_varchar2 then
530: if fnd_date.canonical_to_date(p_segment9) >= fnd_date.canonical_to_date(p_segment7) then
531: fnd_message.set_name('PER', 'HR_377008_DK_ASD_ERR');
532: hr_utility.raise_error;
533: end if;
534: end if;