APPS.HR_US_PYZIPCHK dependencies on HR_UTILITY

Line 62: --hr_utility.trace('p_address_id: '||p_address_id);

58: */
59:
60: --
61: begin
62: --hr_utility.trace('p_address_id: '||p_address_id);
63: --hr_utility.trace('p_state_abbrev: '||p_state_abbrev);
64: --hr_utility.trace('p_county_name: '||p_county_name);
65: --hr_utility.trace('p_city_name: '||p_city_name);
66: --hr_utility.trace('p_zip_code: '||p_zip_code);

Line 63: --hr_utility.trace('p_state_abbrev: '||p_state_abbrev);

59:
60: --
61: begin
62: --hr_utility.trace('p_address_id: '||p_address_id);
63: --hr_utility.trace('p_state_abbrev: '||p_state_abbrev);
64: --hr_utility.trace('p_county_name: '||p_county_name);
65: --hr_utility.trace('p_city_name: '||p_city_name);
66: --hr_utility.trace('p_zip_code: '||p_zip_code);
67:

Line 64: --hr_utility.trace('p_county_name: '||p_county_name);

60: --
61: begin
62: --hr_utility.trace('p_address_id: '||p_address_id);
63: --hr_utility.trace('p_state_abbrev: '||p_state_abbrev);
64: --hr_utility.trace('p_county_name: '||p_county_name);
65: --hr_utility.trace('p_city_name: '||p_city_name);
66: --hr_utility.trace('p_zip_code: '||p_zip_code);
67:
68: IF length(p_zip_code) <> 7 THEN -- US addresses

Line 65: --hr_utility.trace('p_city_name: '||p_city_name);

61: begin
62: --hr_utility.trace('p_address_id: '||p_address_id);
63: --hr_utility.trace('p_state_abbrev: '||p_state_abbrev);
64: --hr_utility.trace('p_county_name: '||p_county_name);
65: --hr_utility.trace('p_city_name: '||p_city_name);
66: --hr_utility.trace('p_zip_code: '||p_zip_code);
67:
68: IF length(p_zip_code) <> 7 THEN -- US addresses
69: l_per_addr := hr_us_ff_udfs.addr_val (p_state_abbrev

Line 66: --hr_utility.trace('p_zip_code: '||p_zip_code);

62: --hr_utility.trace('p_address_id: '||p_address_id);
63: --hr_utility.trace('p_state_abbrev: '||p_state_abbrev);
64: --hr_utility.trace('p_county_name: '||p_county_name);
65: --hr_utility.trace('p_city_name: '||p_city_name);
66: --hr_utility.trace('p_zip_code: '||p_zip_code);
67:
68: IF length(p_zip_code) <> 7 THEN -- US addresses
69: l_per_addr := hr_us_ff_udfs.addr_val (p_state_abbrev
70: ,p_county_name

Line 253: hr_utility.oracle_error(sqlcode);

249: ,l_hrlocs.postal_code);
250: --
251: exception
252: when others then
253: hr_utility.oracle_error(sqlcode);
254: --
255: end;
256: end loop;
257: close hrzipcur;

Line 281: hr_utility.oracle_error(sqlcode);

277: ,l_peraddr.postal_code);
278:
279: exception
280: when others then
281: hr_utility.oracle_error(sqlcode);
282:
283: end;
284: end loop;
285: close perzipcur;