42: BEGIN
43: --
44: --
45: -- Check if DE is installed
46: IF hr_utility.chk_product_install('Oracle Human Resources', 'DE') THEN
47:
48: -- Military Service validation.
49: --
50: IF p_pei_information_category = 'DE_MILITARY_SERVICE' THEN
117: --
118: -- Date From is not on or before Date To.
119: --
120: WHEN military_service_dates THEN
121: hr_utility.set_message(800, 'HR_DE_MILITARY_SERVICE_DATES');
122: hr_utility.raise_error;
123: --
124: --
125: -- Effective Date is not on or before Expiry Date.
118: -- Date From is not on or before Date To.
119: --
120: WHEN military_service_dates THEN
121: hr_utility.set_message(800, 'HR_DE_MILITARY_SERVICE_DATES');
122: hr_utility.raise_error;
123: --
124: --
125: -- Effective Date is not on or before Expiry Date.
126: --
124: --
125: -- Effective Date is not on or before Expiry Date.
126: --
127: WHEN permit_dates THEN
128: hr_utility.set_message(800, 'HR_DE_PERMIT_DATES');
129: hr_utility.raise_error;
130: END person_information_checks;
131: END hr_de_extra_person_checks;
125: -- Effective Date is not on or before Expiry Date.
126: --
127: WHEN permit_dates THEN
128: hr_utility.set_message(800, 'HR_DE_PERMIT_DATES');
129: hr_utility.raise_error;
130: END person_information_checks;
131: END hr_de_extra_person_checks;