APPS.HR_RU_ADDRESS_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_add_information13 = 'RES')

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

21: IF (p_add_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 54: IF hr_utility.chk_product_install('Oracle Human Resources', 'RU') THEN

50: BEGIN
51: --
52: -- Added for GSI Bug 5472781
53: --
54: IF hr_utility.chk_product_install('Oracle Human Resources', 'RU') THEN
55: --
56: OPEN csr_get_address_details (p_address_id);
57:
58: FETCH csr_get_address_details

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

80: IF (l_add_information13 = 'RES')
81: THEN
82: IF (l_postal_code IS NULL)
83: THEN
84: hr_utility.set_message (800, 'HR_RU_ZIPCODE_REQUIRED');
85: hr_utility.raise_error;
86: END IF;
87: END IF;
88: END IF;

Line 85: hr_utility.raise_error;

81: THEN
82: IF (l_postal_code IS NULL)
83: THEN
84: hr_utility.set_message (800, 'HR_RU_ZIPCODE_REQUIRED');
85: hr_utility.raise_error;
86: END IF;
87: END IF;
88: END IF;
89: END IF;

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

110: BEGIN
111: --
112: -- Added for GSI Bug 5472781
113: --
114: IF hr_utility.chk_product_install('Oracle Human Resources', 'RU') THEN
115: --
116: OPEN csr_get_address_details (p_address_id);
117:
118: FETCH csr_get_address_details

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

140: IF (l_add_information13 = 'RES')
141: THEN
142: IF (l_postal_code IS NULL)
143: THEN
144: hr_utility.set_message (800, 'HR_RU_ZIPCODE_REQUIRED');
145: hr_utility.raise_error;
146: END IF;
147: END IF;
148: END IF;

Line 145: hr_utility.raise_error;

141: THEN
142: IF (l_postal_code IS NULL)
143: THEN
144: hr_utility.set_message (800, 'HR_RU_ZIPCODE_REQUIRED');
145: hr_utility.raise_error;
146: END IF;
147: END IF;
148: END IF;
149: END IF;