APPS.PAY_CA_CITY_UPD dependencies on HR_UTILITY

Line 142: -- hr_utility.trace_on(1,'Oracle');

138: v_errortext varchar2(512);
139: v_errorcode number;
140:
141: BEGIN
142: -- hr_utility.trace_on(1,'Oracle');
143:
144: hr_utility.trace('Starting cityname_bulk_upd ');
145:
146: OPEN duplicate_cities;

Line 144: hr_utility.trace('Starting cityname_bulk_upd ');

140:
141: BEGIN
142: -- hr_utility.trace_on(1,'Oracle');
143:
144: hr_utility.trace('Starting cityname_bulk_upd ');
145:
146: OPEN duplicate_cities;
147: FETCH duplicate_cities BULK COLLECT INTO
148: v_dup_new_city,

Line 156: hr_utility.trace('Loaded all duplicate city name mappings from pay_ca_display_cities');

152: v_dup_primary_flag;
153:
154: CLOSE duplicate_cities;
155:
156: hr_utility.trace('Loaded all duplicate city name mappings from pay_ca_display_cities');
157:
158: IF v_dup_new_city.COUNT > 0 THEN
159:
160: FOR j IN v_dup_new_city.first..v_dup_new_city.last LOOP

Line 179: hr_utility.trace('Completed deletion of duplicate cities from pay_us_city_names ');

175: END LOOP;
176:
177: END IF;
178:
179: hr_utility.trace('Completed deletion of duplicate cities from pay_us_city_names ');
180:
181: OPEN translation_exists;
182: FETCH translation_exists BULK COLLECT INTO
183: v_exists_city,

Line 189: hr_utility.trace('Loaded all existing city name translations');

185: v_exists_city_code;
186:
187: CLOSE translation_exists;
188:
189: hr_utility.trace('Loaded all existing city name translations');
190:
191: IF v_exists_city.COUNT > 0 THEN
192:
193: FORALL j IN v_exists_city.first..v_exists_city.last

Line 202: hr_utility.trace('Completed bulk deletion of cities which have existing translations ');

198: AND state_code = '70';
199:
200: END IF;
201:
202: hr_utility.trace('Completed bulk deletion of cities which have existing translations ');
203:
204: OPEN city_mappings;
205: LOOP
206: FETCH city_mappings BULK COLLECT INTO

Line 220: hr_utility.trace('Loaded batch of city name mappings from pay_ca_display_cities');

216: v_rows_in_collect := v_new_row_count - v_old_row_count;
217:
218: EXIT WHEN (v_rows_in_collect = 0);
219:
220: hr_utility.trace('Loaded batch of city name mappings from pay_ca_display_cities');
221:
222: IF v_old_city.COUNT > 0 THEN
223:
224: FOR j IN v_old_city.first..v_old_city.last LOOP

Line 228: hr_utility.trace('Starting bulk update on per_addresses ');

224: FOR j IN v_old_city.first..v_old_city.last LOOP
225: v_prov(j) := prov_abbrev(v_county_code(j));
226: END LOOP;
227:
228: hr_utility.trace('Starting bulk update on per_addresses ');
229:
230: FORALL j IN v_old_city.first..v_old_city.last
231: UPDATE per_addresses
232: SET town_or_city = substrb(v_new_city(j),1,30),

Line 241: hr_utility.trace('Starting bulk update on hr_locations_all ');

237: AND style = 'CA';
238:
239: COMMIT;
240:
241: hr_utility.trace('Starting bulk update on hr_locations_all ');
242:
243: FORALL j IN v_old_city.first..v_old_city.last
244: UPDATE hr_locations_all
245: SET town_or_city = substrb(v_new_city(j),1,30),

Line 254: hr_utility.trace('Starting bulk update on pay_us_city_names ');

250: AND style = 'CA';
251:
252: COMMIT;
253:
254: hr_utility.trace('Starting bulk update on pay_us_city_names ');
255:
256: FORALL j IN v_old_city.first..v_old_city.last
257: UPDATE pay_us_city_names
258: SET city_name = substrb(v_new_city(j),1,30)

Line 270: hr_utility.trace('Completed update on per_addresses,hr_locations_all and pay_us_city_names');

266: END IF;
267:
268: END LOOP;
269:
270: hr_utility.trace('Completed update on per_addresses,hr_locations_all and pay_us_city_names');
271:
272: CLOSE city_mappings;
273:
274: EXCEPTION

Line 278: hr_utility.trace('Error during update process: ' || v_errortext || ' ' || v_errorcode);

274: EXCEPTION
275: WHEN OTHERS THEN
276: v_errorcode := SQLCODE;
277: v_errortext := SQLERRM;
278: hr_utility.trace('Error during update process: ' || v_errortext || ' ' || v_errorcode);
279: errbuf := v_errortext;
280: retcode := v_errorcode;
281: ROLLBACK;
282: