APPS.PER_HU_PERSON_EXTRA_INFO dependencies on FND_DATE

Line 10: IF fnd_date.canonical_to_date(p_pei_information3) > fnd_date.canonical_to_date(p_pei_information4) THEN

6: ,p_pei_information4 VARCHAR2
7: ) IS
8: BEGIN
9: IF p_pei_information3 IS NOT NULL AND p_pei_information4 IS NOT NULL THEN
10: IF fnd_date.canonical_to_date(p_pei_information3) > fnd_date.canonical_to_date(p_pei_information4) THEN
11: hr_utility.set_message(800,'HR_HU_START_END_DATES');
12: hr_utility.set_message_token(800,'VALUE2',hr_general.decode_lookup('HU_FORM_LABELS','DL_EXPIRY_DATE'));
13: hr_utility.set_message_token(800,'VALUE1',hr_general.decode_lookup('HU_FORM_LABELS','START_DATE'));
14: hr_utility.raise_error;

Line 24: IF fnd_date.canonical_to_date(p_pei_information3) > fnd_date.canonical_to_date(p_pei_information4) THEN

20: ,p_pei_information4 VARCHAR2
21: ) IS
22: BEGIN
23: IF p_pei_information3 IS NOT NULL AND p_pei_information4 IS NOT NULL THEN
24: IF fnd_date.canonical_to_date(p_pei_information3) > fnd_date.canonical_to_date(p_pei_information4) THEN
25: hr_utility.set_message(800,'HR_HU_START_END_DATES');
26: hr_utility.set_message_token(800,'VALUE2',hr_general.decode_lookup('HU_FORM_LABELS','PASSPORT_EXPIRY_DATE'));
27: hr_utility.set_message_token(800,'VALUE1',hr_general.decode_lookup('HU_FORM_LABELS','ISSUE_DATE'));
28: hr_utility.raise_error;

Line 38: IF fnd_date.canonical_to_date(p_pei_information3) > fnd_date.canonical_to_date(p_pei_information4) THEN

34: ,p_pei_information4 VARCHAR2
35: ) IS
36: BEGIN
37: IF p_pei_information3 IS NOT NULL AND p_pei_information4 IS NOT NULL THEN
38: IF fnd_date.canonical_to_date(p_pei_information3) > fnd_date.canonical_to_date(p_pei_information4) THEN
39: hr_utility.set_message(800,'HR_HU_START_END_DATES');
40: hr_utility.set_message_token(800,'VALUE2',hr_general.decode_lookup('HU_FORM_LABELS','RESIDENCY_EXPIRY_DATE'));
41: hr_utility.set_message_token(800,'VALUE1',hr_general.decode_lookup('HU_FORM_LABELS','ISSUE_DATE'));
42: hr_utility.raise_error;

Line 52: IF fnd_date.canonical_to_date(p_pei_information3) > fnd_date.canonical_to_date(p_pei_information4) THEN

48: ,p_pei_information4 VARCHAR2
49: ) IS
50: BEGIN
51: IF p_pei_information3 IS NOT NULL AND p_pei_information4 IS NOT NULL THEN
52: IF fnd_date.canonical_to_date(p_pei_information3) > fnd_date.canonical_to_date(p_pei_information4) THEN
53: hr_utility.set_message(800,'HR_HU_START_END_DATES');
54: hr_utility.set_message_token(800,'VALUE2',hr_general.decode_lookup('HU_FORM_LABELS','PERMIT_EXPIRY_DATE'));
55: hr_utility.set_message_token(800,'VALUE1',hr_general.decode_lookup('HU_FORM_LABELS','ISSUE_DATE'));
56: hr_utility.raise_error;