APPS.HR_DE_EXTRA_API_CHECKS dependencies on FND_DATE

Line 321: l_lower_date := TRUNC(fnd_date.canonical_to_date(p_pei_information1));

317: --
318: -- Convert parameters to dates.
319: --
320: IF p_pei_information1 IS NOT NULL THEN
321: l_lower_date := TRUNC(fnd_date.canonical_to_date(p_pei_information1));
322: END IF;
323: IF p_pei_information2 IS NOT NULL THEN
324: l_upper_date := TRUNC(fnd_date.canonical_to_date(p_pei_information2));
325: END IF;

Line 324: l_upper_date := TRUNC(fnd_date.canonical_to_date(p_pei_information2));

320: IF p_pei_information1 IS NOT NULL THEN
321: l_lower_date := TRUNC(fnd_date.canonical_to_date(p_pei_information1));
322: END IF;
323: IF p_pei_information2 IS NOT NULL THEN
324: l_upper_date := TRUNC(fnd_date.canonical_to_date(p_pei_information2));
325: END IF;
326: --
327: --
328: -- Date From > Date To so error.

Line 343: l_lower_date := TRUNC(fnd_date.canonical_to_date(p_pei_information6));

339: --
340: -- Convert parameters to dates.
341: --
342: IF p_pei_information6 IS NOT NULL THEN
343: l_lower_date := TRUNC(fnd_date.canonical_to_date(p_pei_information6));
344: END IF;
345: IF p_pei_information7 IS NOT NULL THEN
346: l_upper_date := TRUNC(fnd_date.canonical_to_date(p_pei_information7));
347: END IF;

Line 346: l_upper_date := TRUNC(fnd_date.canonical_to_date(p_pei_information7));

342: IF p_pei_information6 IS NOT NULL THEN
343: l_lower_date := TRUNC(fnd_date.canonical_to_date(p_pei_information6));
344: END IF;
345: IF p_pei_information7 IS NOT NULL THEN
346: l_upper_date := TRUNC(fnd_date.canonical_to_date(p_pei_information7));
347: END IF;
348: --
349: --
350: -- Effective Date > Expiry Date so error.

Line 365: l_lower_date := TRUNC(fnd_date.canonical_to_date(p_pei_information6));

361: --
362: -- Convert parameters to dates.
363: --
364: IF p_pei_information6 IS NOT NULL THEN
365: l_lower_date := TRUNC(fnd_date.canonical_to_date(p_pei_information6));
366: END IF;
367: IF p_pei_information7 IS NOT NULL THEN
368: l_upper_date := TRUNC(fnd_date.canonical_to_date(p_pei_information7));
369: END IF;

Line 368: l_upper_date := TRUNC(fnd_date.canonical_to_date(p_pei_information7));

364: IF p_pei_information6 IS NOT NULL THEN
365: l_lower_date := TRUNC(fnd_date.canonical_to_date(p_pei_information6));
366: END IF;
367: IF p_pei_information7 IS NOT NULL THEN
368: l_upper_date := TRUNC(fnd_date.canonical_to_date(p_pei_information7));
369: END IF;
370: --
371: --
372: -- Effective Date > Expiry Date so error.

Line 436: IF p_incident_date > TRUNC(fnd_date.canonical_to_date(p_inc_information10)) THEN

432: --
433: -- The Work Stop Date must be on or after Work Incident Date.
434: --
435: IF p_inc_information10 IS NOT NULL THEN
436: IF p_incident_date > TRUNC(fnd_date.canonical_to_date(p_inc_information10)) THEN
437: RAISE work_stop_date_too_early;
438: END IF;
439: END IF;
440: --

Line 445: IF p_incident_date > TRUNC(fnd_date.canonical_to_date(p_inc_information9)) THEN

441: --
442: -- The Payment End Date must be on or after Work Incident Date.
443: --
444: IF p_inc_information9 IS NOT NULL THEN
445: IF p_incident_date > TRUNC(fnd_date.canonical_to_date(p_inc_information9)) THEN
446: RAISE payment_end_date_too_early;
447: END IF;
448: END IF;
449: --

Line 454: IF p_incident_date > TRUNC(fnd_date.canonical_to_date(p_inc_information11)) THEN

450: --
451: -- The Work Resumption Date must be on or after Work Incident Date.
452: --
453: IF p_inc_information11 IS NOT NULL THEN
454: IF p_incident_date > TRUNC(fnd_date.canonical_to_date(p_inc_information11)) THEN
455: RAISE work_resump_date_too_early;
456: END IF;
457: END IF;
458: --

Line 463: IF p_incident_date < TRUNC(fnd_date.canonical_to_date(p_inc_information3)) THEN

459: --
460: -- The Job Start Date must be on or before Work Incident Date.
461: --
462: IF p_inc_information3 IS NOT NULL THEN
463: IF p_incident_date < TRUNC(fnd_date.canonical_to_date(p_inc_information3)) THEN
464: RAISE job_start_date_too_late;
465: END IF;
466: END IF;
467: --

Line 472: IF TRUNC(fnd_date.canonical_to_date(p_inc_information11)) < TRUNC(fnd_date.canonical_to_date(p_inc_information10)) THEN

468: --
469: -- The Work Stop Date must be on or before Work Resumption Date.
470: --
471: IF p_inc_information10 IS NOT NULL AND p_inc_information11 IS NOT NULL THEN
472: IF TRUNC(fnd_date.canonical_to_date(p_inc_information11)) < TRUNC(fnd_date.canonical_to_date(p_inc_information10)) THEN
473: RAISE resump_date_before_stop_date;
474: END IF;
475: END IF;
476: EXCEPTION