DBA Data[Home] [Help]

APPS.PER_ES_LOCATION dependencies on HR_UTILITY

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

13: IF p_style='ES' THEN
14: IF p_postal_code IS NOT NULL THEN
15: l_province_code := substr(p_postal_code,1,2);
16: IF l_province_code <> p_region_2 THEN
17: hr_utility.set_message(800,'HR_ES_INVALID_VALUE');
18: hr_utility.set_message_token(800,'FIELD',hr_general.decode_lookup('ES_FORM_LABELS','POSTAL_CODE'));
19: hr_utility.raise_error;
20: END IF;
21: END IF;

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

14: IF p_postal_code IS NOT NULL THEN
15: l_province_code := substr(p_postal_code,1,2);
16: IF l_province_code <> p_region_2 THEN
17: hr_utility.set_message(800,'HR_ES_INVALID_VALUE');
18: hr_utility.set_message_token(800,'FIELD',hr_general.decode_lookup('ES_FORM_LABELS','POSTAL_CODE'));
19: hr_utility.raise_error;
20: END IF;
21: END IF;
22: END IF;

Line 19: hr_utility.raise_error;

15: l_province_code := substr(p_postal_code,1,2);
16: IF l_province_code <> p_region_2 THEN
17: hr_utility.set_message(800,'HR_ES_INVALID_VALUE');
18: hr_utility.set_message_token(800,'FIELD',hr_general.decode_lookup('ES_FORM_LABELS','POSTAL_CODE'));
19: hr_utility.raise_error;
20: END IF;
21: END IF;
22: END IF;
23: --

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

29: BEGIN
30: --
31: -- Added for GSI Bug 5472781
32: --
33: IF hr_utility.chk_product_install('Oracle Human Resources', 'ES') THEN
34: --
35: per_es_location.check_es_location(p_style => p_style
36: ,p_postal_code => p_postal_code
37: ,p_region_2 => p_region_2);

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

47: BEGIN
48: --
49: -- Added for GSI Bug 5472781
50: --
51: IF hr_utility.chk_product_install('Oracle Human Resources', 'ES') THEN
52: --
53: per_es_location.check_es_location(p_style => p_style
54: ,p_postal_code => p_postal_code
55: ,p_region_2 => p_region_2);