APPS.PER_RU_VEH_REPOS_EXTRA_INFO dependencies on HR_UTILITY

Line 49: IF hr_utility.chk_product_install('Oracle Human Resources', 'RU') THEN

45: BEGIN
46: --
47: -- Added for GSI Bug 5472781
48: --
49: IF hr_utility.chk_product_install('Oracle Human Resources', 'RU') THEN
50: --
51: IF p_vrei_information_category IN ('RU_VEHICLE_INSURANCE_INFO') THEN
52: --
53: IF p_vrei_information2 IS NOT NULL AND p_vrei_information3 IS NOT NULL AND fnd_date.canonical_to_date(p_vrei_information2) >= fnd_date.canonical_to_date(p_vrei_information3) THEN

Line 54: hr_utility.set_message(800,'HR_RU_INVALID_INSURANCE_DATES');

50: --
51: IF p_vrei_information_category IN ('RU_VEHICLE_INSURANCE_INFO') THEN
52: --
53: IF p_vrei_information2 IS NOT NULL AND p_vrei_information3 IS NOT NULL AND fnd_date.canonical_to_date(p_vrei_information2) >= fnd_date.canonical_to_date(p_vrei_information3) THEN
54: hr_utility.set_message(800,'HR_RU_INVALID_INSURANCE_DATES');
55: hr_utility.raise_error;
56: End if;
57: End if;
58: --

Line 55: hr_utility.raise_error;

51: IF p_vrei_information_category IN ('RU_VEHICLE_INSURANCE_INFO') THEN
52: --
53: IF p_vrei_information2 IS NOT NULL AND p_vrei_information3 IS NOT NULL AND fnd_date.canonical_to_date(p_vrei_information2) >= fnd_date.canonical_to_date(p_vrei_information3) THEN
54: hr_utility.set_message(800,'HR_RU_INVALID_INSURANCE_DATES');
55: hr_utility.raise_error;
56: End if;
57: End if;
58: --
59: END IF;

Line 108: IF hr_utility.chk_product_install('Oracle Human Resources', 'RU') THEN

104: Begin
105: --
106: -- Added for GSI Bug 5472781
107: --
108: IF hr_utility.chk_product_install('Oracle Human Resources', 'RU') THEN
109: --
110: IF p_vrei_information_category IN ('RU_VEHICLE_INSURANCE_INFO') THEN
111: IF p_vrei_information2 IS NOT NULL AND p_vrei_information3 IS NOT NULL AND fnd_date.canonical_to_date(p_vrei_information2) >= fnd_date.canonical_to_date(p_vrei_information3) THEN
112: hr_utility.set_message(800,'HR_RU_INVALID_INSURANCE_DATES');

Line 112: hr_utility.set_message(800,'HR_RU_INVALID_INSURANCE_DATES');

108: IF hr_utility.chk_product_install('Oracle Human Resources', 'RU') THEN
109: --
110: IF p_vrei_information_category IN ('RU_VEHICLE_INSURANCE_INFO') THEN
111: IF p_vrei_information2 IS NOT NULL AND p_vrei_information3 IS NOT NULL AND fnd_date.canonical_to_date(p_vrei_information2) >= fnd_date.canonical_to_date(p_vrei_information3) THEN
112: hr_utility.set_message(800,'HR_RU_INVALID_INSURANCE_DATES');
113: hr_utility.raise_error;
114: End if;
115: End if;
116: END IF;

Line 113: hr_utility.raise_error;

109: --
110: IF p_vrei_information_category IN ('RU_VEHICLE_INSURANCE_INFO') THEN
111: IF p_vrei_information2 IS NOT NULL AND p_vrei_information3 IS NOT NULL AND fnd_date.canonical_to_date(p_vrei_information2) >= fnd_date.canonical_to_date(p_vrei_information3) THEN
112: hr_utility.set_message(800,'HR_RU_INVALID_INSURANCE_DATES');
113: hr_utility.raise_error;
114: End if;
115: End if;
116: END IF;
117: End update_ru_veh_repos_extra_info;