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