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 227: l_curr_sec27_sd := fnd_date.canonical_to_date(p_org_information2);

223:
224: /* Bug Fix 4994922 */
225: IF p_org_info_type_code = 'DK_SICKPAY_DEFAULTS' THEN
226:
227: l_curr_sec27_sd := fnd_date.canonical_to_date(p_org_information2);
228: l_curr_sec27_ed := fnd_date.canonical_to_date(p_org_information3);
229:
230: /* Check if Section 27 Registration start date is before end date */
231: IF l_curr_sec27_sd > l_curr_sec27_ed THEN

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

224: /* Bug Fix 4994922 */
225: IF p_org_info_type_code = 'DK_SICKPAY_DEFAULTS' THEN
226:
227: l_curr_sec27_sd := fnd_date.canonical_to_date(p_org_information2);
228: l_curr_sec27_ed := fnd_date.canonical_to_date(p_org_information3);
229:
230: /* Check if Section 27 Registration start date is before end date */
231: IF l_curr_sec27_sd > l_curr_sec27_ed THEN
232: fnd_message.set_name('PER','HR_377068_DK_SECTION27_DATES_E');

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

243: ELSE
244: FOR l_index IN 1 .. l_no_records LOOP
245:
246: l_sec27_reg := l_sickpay_records(l_index).value;
247: l_sec27_sd := fnd_date.canonical_to_date(l_sickpay_records(l_index).date1);
248: l_sec27_ed := fnd_date.canonical_to_date(l_sickpay_records(l_index).date2);
249:
250: IF l_curr_sec27_sd BETWEEN l_sec27_sd AND l_sec27_ed THEN
251: fnd_message.set_name('PER','HR_377069_DK_SECTION27_OVERLAP');

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

244: FOR l_index IN 1 .. l_no_records LOOP
245:
246: l_sec27_reg := l_sickpay_records(l_index).value;
247: l_sec27_sd := fnd_date.canonical_to_date(l_sickpay_records(l_index).date1);
248: l_sec27_ed := fnd_date.canonical_to_date(l_sickpay_records(l_index).date2);
249:
250: IF l_curr_sec27_sd BETWEEN l_sec27_sd AND l_sec27_ed THEN
251: fnd_message.set_name('PER','HR_377069_DK_SECTION27_OVERLAP');
252: fnd_message.raise_error;

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

340:
341: /* Bug Fix 4994922 */
342: IF p_org_info_type_code = 'DK_SICKPAY_DEFAULTS' THEN
343:
344: l_curr_sec27_sd := fnd_date.canonical_to_date(p_org_information2);
345: l_curr_sec27_ed := fnd_date.canonical_to_date(p_org_information3);
346:
347: /* Check if Section 27 Registration start date is before end date */
348: IF l_curr_sec27_sd > l_curr_sec27_ed THEN

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

341: /* Bug Fix 4994922 */
342: IF p_org_info_type_code = 'DK_SICKPAY_DEFAULTS' THEN
343:
344: l_curr_sec27_sd := fnd_date.canonical_to_date(p_org_information2);
345: l_curr_sec27_ed := fnd_date.canonical_to_date(p_org_information3);
346:
347: /* Check if Section 27 Registration start date is before end date */
348: IF l_curr_sec27_sd > l_curr_sec27_ed THEN
349: fnd_message.set_name('PER','HR_377068_DK_SECTION27_DATES_E');

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

360: ELSE
361: FOR l_index IN 1 .. l_no_records LOOP
362:
363: l_sec27_reg := l_sickpay_records(l_index).value;
364: l_sec27_sd := fnd_date.canonical_to_date(l_sickpay_records(l_index).date1);
365: l_sec27_ed := fnd_date.canonical_to_date(l_sickpay_records(l_index).date2);
366:
367: IF l_curr_sec27_sd BETWEEN l_sec27_sd AND l_sec27_ed THEN
368: fnd_message.set_name('PER','HR_377069_DK_SECTION27_OVERLAP');

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

361: FOR l_index IN 1 .. l_no_records LOOP
362:
363: l_sec27_reg := l_sickpay_records(l_index).value;
364: l_sec27_sd := fnd_date.canonical_to_date(l_sickpay_records(l_index).date1);
365: l_sec27_ed := fnd_date.canonical_to_date(l_sickpay_records(l_index).date2);
366:
367: IF l_curr_sec27_sd BETWEEN l_sec27_sd AND l_sec27_ed THEN
368: fnd_message.set_name('PER','HR_377069_DK_SECTION27_OVERLAP');
369: fnd_message.raise_error;

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

461:
462: -- Validation rule : notified date > assignment start date --
463: if p_segment7 <> hr_api.g_varchar2 -- GSI Bug 4585094
464: and l_asg_start_date is not NULL then
465: if fnd_date.canonical_to_date(p_segment7) < fnd_date.canonical_to_date(l_asg_start_date) then
466: fnd_message.set_name('PER', 'HR_377006_DK_NOTIFIED_DATE');
467: hr_utility.raise_error;
468: end if;
469: end if;

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

469: end if;
470: -- Validation rule : Termination date >= notified date --
471: if p_segment8 <> hr_api.g_varchar2 -- GSI Bug 4585094
472: and p_segment7 <> hr_api.g_varchar2 then
473: if fnd_date.canonical_to_date(p_segment8) < fnd_date.canonical_to_date(p_segment7) then
474: fnd_message.set_name('PER', 'HR_377007_DK_TERM_DATE_ERR');
475: hr_utility.raise_error;
476: end if;
477: end if;

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

477: end if;
478: -- Validation rule : Adjusted seniority date < notified date --
479: if p_segment9 <> hr_api.g_varchar2 -- GSI Bug 4585094
480: and p_segment7 <> hr_api.g_varchar2 then
481: if fnd_date.canonical_to_date(p_segment9) >= fnd_date.canonical_to_date(p_segment7) then
482: fnd_message.set_name('PER', 'HR_377008_DK_ASD_ERR');
483: hr_utility.raise_error;
484: end if;
485: end if;