9: BEGIN
10: --
11: -- Added for GSI Bug 5472781
12: --
13: IF hr_utility.chk_product_install('Oracle Human Resources', 'ES') THEN
14: --
15: --
16: l_province_code := substr(p_postal_code,1,2);
17:
15: --
16: l_province_code := substr(p_postal_code,1,2);
17:
18: IF l_province_code <> p_region_2 THEN
19: hr_utility.set_message(800,'HR_ES_INVALID_VALUE');
20: hr_utility.set_message_token(800,'FIELD',hr_general.decode_lookup('ES_FORM_LABELS','POSTAL_CODE'));
21: hr_utility.raise_error;
22: END IF;
23: END IF;
16: l_province_code := substr(p_postal_code,1,2);
17:
18: IF l_province_code <> p_region_2 THEN
19: hr_utility.set_message(800,'HR_ES_INVALID_VALUE');
20: hr_utility.set_message_token(800,'FIELD',hr_general.decode_lookup('ES_FORM_LABELS','POSTAL_CODE'));
21: hr_utility.raise_error;
22: END IF;
23: END IF;
24: --
17:
18: IF l_province_code <> p_region_2 THEN
19: hr_utility.set_message(800,'HR_ES_INVALID_VALUE');
20: hr_utility.set_message_token(800,'FIELD',hr_general.decode_lookup('ES_FORM_LABELS','POSTAL_CODE'));
21: hr_utility.raise_error;
22: END IF;
23: END IF;
24: --
25: END check_es_address;
30: BEGIN
31: --
32: -- Added for GSI Bug 5472781
33: --
34: IF hr_utility.chk_product_install('Oracle Human Resources', 'ES') THEN
35: --
36: --
37: IF p_style = 'ES' THEN
38: IF p_postal_code IS NOT NULL THEN
61: BEGIN
62: --
63: -- Added for GSI Bug 5472781
64: --
65: IF hr_utility.chk_product_install('Oracle Human Resources', 'ES') THEN
66: --
67: --
68: IF p_postal_code <> hr_api.g_varchar2
69: OR p_region_2 <> hr_api.g_varchar2 THEN
109: BEGIN
110: --
111: -- Added for GSI Bug 5472781
112: --
113: IF hr_utility.chk_product_install('Oracle Human Resources', 'ES') THEN
114: --
115: --
116: IF p_postal_code IS NOT NULL THEN
117: IF p_style = 'ES' THEN