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;
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;
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;
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;