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.PQP_EXCP_RPT dependencies on HR_UTILITY

Line 276: -- hr_utility.trace_on(NULL,'YYY');

272: l_header_printed boolean;
273: i number;
274:
275: begin
276: -- hr_utility.trace_on(NULL,'YYY');
277: hr_utility.trace('Entering Procedure PQP_EXR_CSV_FORMAT....');
278: hr_utility.trace('Fnd_log.output :'||fnd_file.output);
279: hr_utility.trace('Fnd_log.Log :'||fnd_file.log);
280: hr_utility.trace('ppa_finder :'||p_ppa_finder);

Line 277: hr_utility.trace('Entering Procedure PQP_EXR_CSV_FORMAT....');

273: i number;
274:
275: begin
276: -- hr_utility.trace_on(NULL,'YYY');
277: hr_utility.trace('Entering Procedure PQP_EXR_CSV_FORMAT....');
278: hr_utility.trace('Fnd_log.output :'||fnd_file.output);
279: hr_utility.trace('Fnd_log.Log :'||fnd_file.log);
280: hr_utility.trace('ppa_finder :'||p_ppa_finder);
281: hr_utility.trace('report_date :'||p_report_date);

Line 278: hr_utility.trace('Fnd_log.output :'||fnd_file.output);

274:
275: begin
276: -- hr_utility.trace_on(NULL,'YYY');
277: hr_utility.trace('Entering Procedure PQP_EXR_CSV_FORMAT....');
278: hr_utility.trace('Fnd_log.output :'||fnd_file.output);
279: hr_utility.trace('Fnd_log.Log :'||fnd_file.log);
280: hr_utility.trace('ppa_finder :'||p_ppa_finder);
281: hr_utility.trace('report_date :'||p_report_date);
282:

Line 279: hr_utility.trace('Fnd_log.Log :'||fnd_file.log);

275: begin
276: -- hr_utility.trace_on(NULL,'YYY');
277: hr_utility.trace('Entering Procedure PQP_EXR_CSV_FORMAT....');
278: hr_utility.trace('Fnd_log.output :'||fnd_file.output);
279: hr_utility.trace('Fnd_log.Log :'||fnd_file.log);
280: hr_utility.trace('ppa_finder :'||p_ppa_finder);
281: hr_utility.trace('report_date :'||p_report_date);
282:
283: --

Line 280: hr_utility.trace('ppa_finder :'||p_ppa_finder);

276: -- hr_utility.trace_on(NULL,'YYY');
277: hr_utility.trace('Entering Procedure PQP_EXR_CSV_FORMAT....');
278: hr_utility.trace('Fnd_log.output :'||fnd_file.output);
279: hr_utility.trace('Fnd_log.Log :'||fnd_file.log);
280: hr_utility.trace('ppa_finder :'||p_ppa_finder);
281: hr_utility.trace('report_date :'||p_report_date);
282:
283: --
284: -- Get the output format

Line 281: hr_utility.trace('report_date :'||p_report_date);

277: hr_utility.trace('Entering Procedure PQP_EXR_CSV_FORMAT....');
278: hr_utility.trace('Fnd_log.output :'||fnd_file.output);
279: hr_utility.trace('Fnd_log.Log :'||fnd_file.log);
280: hr_utility.trace('ppa_finder :'||p_ppa_finder);
281: hr_utility.trace('report_date :'||p_report_date);
282:
283: --
284: -- Get the output format
285: --

Line 294: hr_utility.trace('Exited the Conc. Proc. when OutputFormat = TXT');

290: --
291: -- If the output Format type is TXT then exit
292: --
293: IF l_output_format = 'TXT' THEN
294: hr_utility.trace('Exited the Conc. Proc. when OutputFormat = TXT');
295: RAISE NO_DATA_FOUND;
296: END IF;
297:
298:

Line 317: hr_utility.trace('report_id :'|| r_excp_rpt_data.report_id);

313: FOR r_excp_rpt_data IN c_exception_report_data
314: LOOP
315:
316:
317: hr_utility.trace('report_id :'|| r_excp_rpt_data.report_id);
318: hr_utility.trace('group_id :'|| r_excp_rpt_data.group_id);
319: hr_utility.trace('Payroll id : ' || r_excp_rpt_data.payroll_id);
320: hr_utility.trace('Con Set id : ' || r_excp_rpt_data.consolidation_set_id);
321: hr_utility.trace('Bg ID : ' || r_excp_rpt_data.business_group_id);

Line 318: hr_utility.trace('group_id :'|| r_excp_rpt_data.group_id);

314: LOOP
315:
316:
317: hr_utility.trace('report_id :'|| r_excp_rpt_data.report_id);
318: hr_utility.trace('group_id :'|| r_excp_rpt_data.group_id);
319: hr_utility.trace('Payroll id : ' || r_excp_rpt_data.payroll_id);
320: hr_utility.trace('Con Set id : ' || r_excp_rpt_data.consolidation_set_id);
321: hr_utility.trace('Bg ID : ' || r_excp_rpt_data.business_group_id);
322:

Line 319: hr_utility.trace('Payroll id : ' || r_excp_rpt_data.payroll_id);

315:
316:
317: hr_utility.trace('report_id :'|| r_excp_rpt_data.report_id);
318: hr_utility.trace('group_id :'|| r_excp_rpt_data.group_id);
319: hr_utility.trace('Payroll id : ' || r_excp_rpt_data.payroll_id);
320: hr_utility.trace('Con Set id : ' || r_excp_rpt_data.consolidation_set_id);
321: hr_utility.trace('Bg ID : ' || r_excp_rpt_data.business_group_id);
322:
323:

Line 320: hr_utility.trace('Con Set id : ' || r_excp_rpt_data.consolidation_set_id);

316:
317: hr_utility.trace('report_id :'|| r_excp_rpt_data.report_id);
318: hr_utility.trace('group_id :'|| r_excp_rpt_data.group_id);
319: hr_utility.trace('Payroll id : ' || r_excp_rpt_data.payroll_id);
320: hr_utility.trace('Con Set id : ' || r_excp_rpt_data.consolidation_set_id);
321: hr_utility.trace('Bg ID : ' || r_excp_rpt_data.business_group_id);
322:
323:
324: IF r_excp_rpt_data.payroll_id <> l_payroll_id_old THEN

Line 321: hr_utility.trace('Bg ID : ' || r_excp_rpt_data.business_group_id);

317: hr_utility.trace('report_id :'|| r_excp_rpt_data.report_id);
318: hr_utility.trace('group_id :'|| r_excp_rpt_data.group_id);
319: hr_utility.trace('Payroll id : ' || r_excp_rpt_data.payroll_id);
320: hr_utility.trace('Con Set id : ' || r_excp_rpt_data.consolidation_set_id);
321: hr_utility.trace('Bg ID : ' || r_excp_rpt_data.business_group_id);
322:
323:
324: IF r_excp_rpt_data.payroll_id <> l_payroll_id_old THEN
325: --

Line 337: hr_utility.trace('Payroll Name : ' || l_payroll_name);

333: FETCH c_get_payroll_name INTO l_payroll_name;
334: CLOSE c_get_payroll_name;
335: -- Close cursor
336:
337: hr_utility.trace('Payroll Name : ' || l_payroll_name);
338: l_payroll_id_old := r_excp_rpt_data.payroll_id;
339: END IF;
340:
341:

Line 535: hr_utility.trace('Changing the Name Format.....');

531: -- Check if the Legislation Code is US/GB,
532: -- Change the fullname format to 'Last_name,First_Name'
533: --
534: IF l_legislation_code = 'US' OR l_legislation_code = 'GB' THEN
535: hr_utility.trace('Changing the Name Format.....');
536: l_full_name := r_excp_rpt_data.last_name || ',' ||
537: r_excp_rpt_data.first_name || ' ' || r_excp_rpt_data.middle_name;
538: ELSE
539: l_full_name := r_excp_rpt_data.full_name;

Line 570: hr_utility.trace('Deleted the rows from the pay_us_rpt_totals');

566: DELETE FROM pay_us_rpt_totals
567: WHERE organization_id =p_ppa_finder
568: AND attribute12 = p_ppa_finder;
569: commit;
570: hr_utility.trace('Deleted the rows from the pay_us_rpt_totals');
571: END IF;
572:
573: EXCEPTION
574: WHEN NO_DATA_FOUND THEN

Line 575: hr_utility.trace('Final Exit!');

571: END IF;
572:
573: EXCEPTION
574: WHEN NO_DATA_FOUND THEN
575: hr_utility.trace('Final Exit!');
576: null;
577: hr_utility.trace('Leaving Procedure PQP_EXR_CSV_FORMAT....');
578: -- hr_utility.trace_off;
579:

Line 577: hr_utility.trace('Leaving Procedure PQP_EXR_CSV_FORMAT....');

573: EXCEPTION
574: WHEN NO_DATA_FOUND THEN
575: hr_utility.trace('Final Exit!');
576: null;
577: hr_utility.trace('Leaving Procedure PQP_EXR_CSV_FORMAT....');
578: -- hr_utility.trace_off;
579:
580: -- Added by tmehra for nocopy changes Feb'03
581:

Line 578: -- hr_utility.trace_off;

574: WHEN NO_DATA_FOUND THEN
575: hr_utility.trace('Final Exit!');
576: null;
577: hr_utility.trace('Leaving Procedure PQP_EXR_CSV_FORMAT....');
578: -- hr_utility.trace_off;
579:
580: -- Added by tmehra for nocopy changes Feb'03
581:
582: WHEN OTHERS THEN

Line 583: hr_utility.trace('Entering exception when others:');

579:
580: -- Added by tmehra for nocopy changes Feb'03
581:
582: WHEN OTHERS THEN
583: hr_utility.trace('Entering exception when others:');
584: retcode := null;
585: raise;
586:
587: