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 251: hr_utility.oracle_error(sqlcode);

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

Line 279: hr_utility.oracle_error(sqlcode);

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