DBA Data[Home] [Help]

APPS.HR_RU_LOCATION_HOOK dependencies on HR_UTILITY

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

13: BEGIN
14: --
15: -- Added for GSI Bug 5472781
16: --
17: IF hr_utility.chk_product_install('Oracle Human Resources', 'RU') THEN
18: --
19: IF p_style = 'RU'
20: THEN
21: IF (p_loc_information13 = 'RES')

Line 25: hr_utility.set_message (800, 'HR_RU_ZIPCODE_REQUIRED');

21: IF (p_loc_information13 = 'RES')
22: THEN
23: IF (p_postal_code IS NULL)
24: THEN
25: hr_utility.set_message (800, 'HR_RU_ZIPCODE_REQUIRED');
26: hr_utility.raise_error;
27: END IF;
28: END IF;
29: END IF;

Line 26: hr_utility.raise_error;

22: THEN
23: IF (p_postal_code IS NULL)
24: THEN
25: hr_utility.set_message (800, 'HR_RU_ZIPCODE_REQUIRED');
26: hr_utility.raise_error;
27: END IF;
28: END IF;
29: END IF;
30: END IF;

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

53: BEGIN
54: --
55: -- Added for GSI Bug 5472781
56: --
57: IF hr_utility.chk_product_install('Oracle Human Resources', 'RU') THEN
58: --
59: OPEN csr_get_location_details (p_location_id);
60:
61: FETCH csr_get_location_details

Line 94: hr_utility.set_message (800, 'HR_RU_ZIPCODE_REQUIRED');

90: IF (l_loc_information13 = 'RES')
91: THEN
92: IF (l_postal_code IS NULL)
93: THEN
94: hr_utility.set_message (800, 'HR_RU_ZIPCODE_REQUIRED');
95: hr_utility.raise_error;
96: END IF;
97: END IF;
98: END IF;

Line 95: hr_utility.raise_error;

91: THEN
92: IF (l_postal_code IS NULL)
93: THEN
94: hr_utility.set_message (800, 'HR_RU_ZIPCODE_REQUIRED');
95: hr_utility.raise_error;
96: END IF;
97: END IF;
98: END IF;
99: END IF;