2126: hr_utility.set_location(l_proc, 2);
2127: --
2128: -- Check if GEOCODES is installed for a US legislation
2129: --
2130: if p_style = 'US' and hr_general.chk_geocodes_installed = 'Y' then
2131: --
2132: -- Check that the zip code is set
2133: --
2134: if p_postal_code is null then
2431: hr_utility.set_location(l_proc, 2);
2432: --
2433: -- Check if GEOCODES is installed for a US legislation
2434: --
2435: if p_style = 'US' and hr_general.chk_geocodes_installed = 'Y'
2436: then
2437: --
2438: -- Check that the US postal code is either 5 or 10 character
2439: --
2616: --
2617: -- Check for GEOCODES in a US legislation
2618: --
2619: if p_style = 'US'
2620: and hr_general.chk_geocodes_installed = 'Y'
2621: and p_validate_county then
2622: --
2623: -- Check that the county is set
2624: --
2770: --
2771: -- Check for GEOCODES in a US legislation
2772: --
2773: if p_style = 'US'
2774: and hr_general.chk_geocodes_installed = 'Y'
2775: then
2776: open csr_valid_us_county;
2777: fetch csr_valid_us_county into l_exists;
2778: if csr_valid_us_county%notfound then
2895: hr_utility.set_location(l_proc, 2);
2896: --
2897: -- Check if GEOCODES is installed under a US legislation
2898: --
2899: if p_style = 'US' and hr_general.chk_geocodes_installed = 'Y'
2900: then
2901: hr_utility.set_location(l_proc, 5);
2902: --
2903: -- Check if the state is set
3057: hr_utility.set_location(l_proc, 2);
3058: --
3059: -- Check if GEOCODES is installed under a US legislation
3060: --
3061: if hr_general.chk_geocodes_installed = 'Y'
3062: then
3063: hr_utility.set_location(l_proc, 5);
3064: open csr_valid_state;
3065: fetch csr_valid_state into l_exists;
3183: (NOT l_api_updating))
3184: then
3185: hr_utility.set_location(l_proc, 2);
3186: --
3187: if p_style = 'US' and hr_general.chk_geocodes_installed = 'Y' then
3188: --
3189: -- Check that the city is set
3190: --
3191: if p_town_or_city is null then
3300: (NOT l_api_updating))
3301: then
3302: hr_utility.set_location(l_proc, 2);
3303: --
3304: if hr_general.chk_geocodes_installed = 'Y' then
3305: open csr_valid_tax_city;
3306: fetch csr_valid_tax_city into l_exists;
3307: if csr_valid_tax_city%notfound then
3308: close csr_valid_tax_city;
3467: hr_utility.set_location(l_proc, 20);
3468: --
3469: -- Check if US payroll installed.
3470: --
3471: l_geocodes_installed := hr_general.chk_geocodes_installed;
3472: --
3473: --
3474: -- If US address style and GEOCODES is installed, validate for right combination of
3475: -- city, state and county.
3773: hr_utility.set_location(l_proc, 20);
3774: --
3775: -- Check if US payroll installed.
3776: --
3777: l_geocodes_installed := hr_general.chk_geocodes_installed;
3778: --
3779: --
3780: -- If US address style and GEOCODES is installed, validate for right combination of
3781: -- city, state and county.