DBA Data[Home] [Help]

APPS.PER_ES_ADDRESS dependencies on HR_UTILITY

Line 13: IF hr_utility.chk_product_install('Oracle Human Resources', 'ES') THEN

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:

Line 19: hr_utility.set_message(800,'HR_ES_INVALID_VALUE');

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;

Line 20: hr_utility.set_message_token(800,'FIELD',hr_general.decode_lookup('ES_FORM_LABELS','POSTAL_CODE'));

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: --

Line 21: hr_utility.raise_error;

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;

Line 34: IF hr_utility.chk_product_install('Oracle Human Resources', 'ES') THEN

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

Line 65: IF hr_utility.chk_product_install('Oracle Human Resources', 'ES') 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

Line 113: IF hr_utility.chk_product_install('Oracle Human Resources', 'ES') 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