eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_US_GEOCODE_ENGINE_PKG dependencies on HR_UTILITY

Line 163: hr_utility.trace('Call User Defined City Upgrade Process ');

159:
160:
161: begin
162:
163: hr_utility.trace('Call User Defined City Upgrade Process ');
164:
165: -- initialise variable - 0 is SRS Success, 1 is SRS Warning, 2 is SRS Error
166: retcode := 0;
167:

Line 198: hr_utility.trace('Calling set print options');

194: else
195: save_buffer:=NULL;
196: end if;
197:
198: hr_utility.trace('Calling set print options');
199:
200: -- loop round from both ends working inwards
201: -- set print options
202: x:=FND_REQUEST.set_print_options(

Line 231: HR_UTILITY.TRACE('SQLERRM = ' || SQLERRM);

227:
228: EXCEPTION
229:
230: WHEN OTHERS THEN
231: HR_UTILITY.TRACE('SQLERRM = ' || SQLERRM);
232:
233: END ;
234:
235: COMMIT;

Line 244: hr_utility.trace('Done with User Defined City Upgrade Process ');

240: dev_phase => l_dev_phase,
241: dev_status => l_dev_status,
242: message => l_message);
243:
244: hr_utility.trace('Done with User Defined City Upgrade Process ');
245:
246: open c_max_geocode_patch_name;
247: fetch c_max_geocode_patch_name into
248: l_max_patch_name,

Line 257: --hr_utility.trace_on(null,'ORACLE');

253: open c_geocode_patch_name;
254:
255: loop
256:
257: --hr_utility.trace_on(null,'ORACLE');
258:
259: fetch c_geocode_patch_name
260: into l_patch_name,
261: l_year;

Line 265: hr_utility.trace('l_patch_name = ' || l_patch_name);

261: l_year;
262:
263: exit when c_geocode_patch_name%NOTFOUND;
264:
265: hr_utility.trace('l_patch_name = ' || l_patch_name);
266: hr_utility.trace('l_year = ' || l_year);
267:
268: --place the log info into the concurrent log file generated by application
269: fnd_file.put_line(fnd_file.log, l_patch_name||' '|| l_year);

Line 266: hr_utility.trace('l_year = ' || l_year);

262:
263: exit when c_geocode_patch_name%NOTFOUND;
264:
265: hr_utility.trace('l_patch_name = ' || l_patch_name);
266: hr_utility.trace('l_year = ' || l_year);
267:
268: --place the log info into the concurrent log file generated by application
269: fnd_file.put_line(fnd_file.log, l_patch_name||' '|| l_year);
270:

Line 279: hr_utility.trace('l_patch_status = ' || l_patch_status);

275: open c_geocode_patch_status (l_patch_name);
276: fetch c_geocode_patch_status
277: into l_patch_status;
278:
279: hr_utility.trace('l_patch_status = ' || l_patch_status);
280:
281:
282: --place the log info into the concurrent log file generated by application
283: --fnd_file.put_line(fnd_file.log, 'status = '|| nvl(l_patch_status,'null'));

Line 314: hr_utility.trace('Inside ');

310: close c_geo_check_ca_assignments;
311:
312: IF l_ca_count >0 or l_us_count > 0 THEN -- Bug 5599273
313:
314: hr_utility.trace('Inside ');
315: -- initialise variable - 0 is SRS Success, 1 is SRS Warning, 2 is SRS Error
316: retcode := 0;
317: -- get printing info
318: req_id:=fnd_profile.value('CONC_REQUEST_ID');

Line 344: hr_utility.trace(' call set print options');

340: else
341: save_buffer:=NULL;
342: end if;
343:
344: hr_utility.trace(' call set print options');
345:
346: -- get start of list
347: start_index:=1;
348: -- get end of list

Line 385: HR_UTILITY.TRACE('SQLERRM = ' || SQLERRM);

381: EXCEPTION
382:
383: WHEN OTHERS THEN
384:
385: HR_UTILITY.TRACE('SQLERRM = ' || SQLERRM);
386:
387: END ;
388:
389: commit;

Line 402: hr_utility.trace(' in ELSE');

398:
399:
400:
401: ELSE
402: hr_utility.trace(' in ELSE');
403:
404: select PAY_PATCH_STATUS_S.nextval into l_id
405: from dual;
406:

Line 467: hr_utility.trace(' status complete patch_name = ' || l_patch_name );

463:
464: END IF;
465:
466: END IF; --l_us_count IF
467: hr_utility.trace(' status complete patch_name = ' || l_patch_name );
468: open c_geo_patch_comp_stat(l_patch_name);
469:
470: fetch c_geo_patch_comp_stat
471: into l_completion_patch_status;

Line 473: hr_utility.trace('l_completion_patch_status = ' || l_completion_patch_status);

469:
470: fetch c_geo_patch_comp_stat
471: into l_completion_patch_status;
472:
473: hr_utility.trace('l_completion_patch_status = ' || l_completion_patch_status);
474:
475:
476: --place the log info into the concurrent log file generated by application
477: fnd_file.put_line(fnd_file.log, 'completion status = '|| l_completion_patch_status);

Line 503: hr_utility.trace('JIT patch has not been applied prior to running upgrade');

499: close c_geocode_patch_name;
500:
501: else -- max_geocode_patch_name%FOUND
502: -- Skip processing as the PREREQUSITE JIT patch has not been applied
503: hr_utility.trace('JIT patch has not been applied prior to running upgrade');
504:
505: end if;
506:
507: close c_max_geocode_patch_name;

Line 525: errbuf := hr_utility.get_message;

521: fnd_message.set_name('PAY', 'HR_75258_GEOCODE_PATCH_ERROR');
522: fnd_message.set_token('PATCH_NAME', l_patch_name);
523: fnd_message.set_token('REQ_ID', ('o' || l_req_id || '.out') );
524:
525: errbuf := hr_utility.get_message;
526: retcode := 2;
527: RAISE;
528: --
529:

Line 535: hr_utility.trace('sqlerrm = ' || sqlerrm);

531: WHEN others THEN
532: --
533: -- Set up error message and return code.
534: --
535: hr_utility.trace('sqlerrm = ' || sqlerrm);
536: errbuf := sqlerrm;
537: retcode := 2;
538:
539: end GEOCODE_UPGRADE;