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;
15: END IF;
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;
15: END IF;
16: END IF;
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;
15: END IF;
16: END IF;
17: END chk_dl_date;
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;
15: END IF;
16: END IF;
17: END chk_dl_date;
18: --
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;
29: END IF;
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;
29: END IF;
30: END IF;
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;
29: END IF;
30: END IF;
31: END chk_passport_date;
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;
29: END IF;
30: END IF;
31: END chk_passport_date;
32: --
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;
43: END IF;
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;
43: END IF;
44: END IF;
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;
43: END IF;
44: END IF;
45: END chk_residency_date;
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;
43: END IF;
44: END IF;
45: END chk_residency_date;
46: --
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;
57: END IF;
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;
57: END IF;
58: END IF;
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;
57: END IF;
58: END IF;
59: END chk_permit_date;
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;
57: END IF;
58: END IF;
59: END chk_permit_date;
60:
70: BEGIN
71: --
72: -- Added for GSI Bug 5472781
73: --
74: IF hr_utility.chk_product_install('Oracle Human Resources', 'HU') THEN
75: --
76: IF p_information_type='HU_DRIVING_LICENSE' THEN
77: per_hu_person_extra_info.chk_dl_date(p_pei_information3 => p_pei_information3
78: ,p_pei_information4 => p_pei_information4);
102: BEGIN
103: --
104: -- Added for GSI Bug 5472781
105: --
106: IF hr_utility.chk_product_install('Oracle Human Resources', 'HU') THEN
107: --
108: IF p_pei_information_category='HU_DRIVING_LICENSE' THEN
109: per_hu_person_extra_info.chk_dl_date(p_pei_information3 => p_pei_information3
110: ,p_pei_information4 => p_pei_information4);