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_COSTING_SUMMARY_REP_PKG dependencies on HR_UTILITY

Line 80: hr_utility.set_location(gv_package_name || '.formated_title_page.',10);

76: lv_sort_order2:=' ';
77: ELSE lv_sort_order2:=p_sort_order2;
78: END IF;
79: END IF;
80: hr_utility.set_location(gv_package_name || '.formated_title_page.',10);
81: FND_FILE.PUT_LINE(fnd_file.output,pay_us_payroll_utils.formated_data_string(
82: p_input_string=>'Business Group: '
83: ,p_output_file_type=>p_output_file_type
84: ,p_bold=>'N')||

Line 227: hr_utility.set_location(gv_package_name || '.formated_title_page.',20);

223:
224: IF p_output_file_type ='HTML' THEN
225: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
226: END IF;
227: hr_utility.set_location(gv_package_name || '.formated_title_page.',20);
228:
229: END formated_title_page;
230:
231: /************************************************************

Line 251: hr_utility.set_location(gv_package_name || '.formated_static_header.',10);

247: lv_format1 VARCHAR2(32000);
248: lv_format2 VARCHAR2(32000);
249:
250: BEGIN
251: hr_utility.set_location(gv_package_name || '.formated_static_header.',10);
252: lv_format1:= pay_us_payroll_utils.formated_data_string(p_input_string=>'Payroll'
253: ,p_output_file_type=>p_output_file_type
254: ,p_bold=>'Y')||
255: pay_us_payroll_utils.formated_data_string(p_input_string=>'GRE'

Line 278: hr_utility.trace('Static Label1 = ' || lv_format1);

274: ,p_bold=>'Y');
275:
276: p_static_label1 := lv_format1;
277: p_static_label2 := lv_format2;
278: hr_utility.trace('Static Label1 = ' || lv_format1);
279: hr_utility.trace('Static Label2 = ' || lv_format2);
280: hr_utility.set_location(gv_package_name || '.formated_static_header', 20);
281:
282: END formated_static_header;

Line 279: hr_utility.trace('Static Label2 = ' || lv_format2);

275:
276: p_static_label1 := lv_format1;
277: p_static_label2 := lv_format2;
278: hr_utility.trace('Static Label1 = ' || lv_format1);
279: hr_utility.trace('Static Label2 = ' || lv_format2);
280: hr_utility.set_location(gv_package_name || '.formated_static_header', 20);
281:
282: END formated_static_header;
283:

Line 280: hr_utility.set_location(gv_package_name || '.formated_static_header', 20);

276: p_static_label1 := lv_format1;
277: p_static_label2 := lv_format2;
278: hr_utility.trace('Static Label1 = ' || lv_format1);
279: hr_utility.trace('Static Label2 = ' || lv_format2);
280: hr_utility.set_location(gv_package_name || '.formated_static_header', 20);
281:
282: END formated_static_header;
283:
284: /************************************************************

Line 307: hr_utility.set_location(gv_package_name || '.formated_totals_header', 20);

303: lv_gre_or_payroll VARCHAR2(240);
304:
305: BEGIN
306:
307: hr_utility.set_location(gv_package_name || '.formated_totals_header', 20);
308: IF upper(p_sort_order1)='PAYROLL NAME' THEN
309: lv_gre_or_payroll:='Payroll Name';
310: ELSE lv_gre_or_payroll:='GRE Name';
311: END IF;

Line 331: hr_utility.trace('Static Label1 = ' || lv_format1);

327: ,p_bold=>'Y');
328:
329: p_static_label1 := lv_format1;
330: p_static_label2 := lv_format2;
331: hr_utility.trace('Static Label1 = ' || lv_format1);
332: hr_utility.trace('Static Label2 = ' || lv_format2);
333: hr_utility.set_location(gv_package_name || '.formated_totals_header', 20);
334:
335: END formated_totals_header;

Line 332: hr_utility.trace('Static Label2 = ' || lv_format2);

328:
329: p_static_label1 := lv_format1;
330: p_static_label2 := lv_format2;
331: hr_utility.trace('Static Label1 = ' || lv_format1);
332: hr_utility.trace('Static Label2 = ' || lv_format2);
333: hr_utility.set_location(gv_package_name || '.formated_totals_header', 20);
334:
335: END formated_totals_header;
336:

Line 333: hr_utility.set_location(gv_package_name || '.formated_totals_header', 20);

329: p_static_label1 := lv_format1;
330: p_static_label2 := lv_format2;
331: hr_utility.trace('Static Label1 = ' || lv_format1);
332: hr_utility.trace('Static Label2 = ' || lv_format2);
333: hr_utility.set_location(gv_package_name || '.formated_totals_header', 20);
334:
335: END formated_totals_header;
336:
337: /************************************************************

Line 358: hr_utility.set_location(gv_package_name || '.formated_cons_totals_header1', 10);

354: lv_format VARCHAR2(32000);
355: lv_gre_or_payroll VARCHAR2(240);
356:
357: BEGIN
358: hr_utility.set_location(gv_package_name || '.formated_cons_totals_header1', 10);
359: IF upper(p_sort_order1)='PAYROLL NAME' THEN
360: lv_gre_or_payroll:='Payroll Name';
361: ELSE lv_gre_or_payroll:='GRE Name';
362: END IF;

Line 378: hr_utility.trace('Static Label = ' || lv_format);

374: ,p_output_file_type=>p_output_file_type
375: ,p_bold=>'Y');
376:
377: p_static_label := lv_format;
378: hr_utility.trace('Static Label = ' || lv_format);
379: hr_utility.set_location(gv_package_name || '.formated_cons_total_header1', 20);
380:
381: END formated_cons_totals_header1;
382:

Line 379: hr_utility.set_location(gv_package_name || '.formated_cons_total_header1', 20);

375: ,p_bold=>'Y');
376:
377: p_static_label := lv_format;
378: hr_utility.trace('Static Label = ' || lv_format);
379: hr_utility.set_location(gv_package_name || '.formated_cons_total_header1', 20);
380:
381: END formated_cons_totals_header1;
382:
383: /************************************************************

Line 402: hr_utility.set_location(gv_package_name || '.formated_cons_totals_header2', 10);

398:
399: lv_format VARCHAR2(32000);
400:
401: BEGIN
402: hr_utility.set_location(gv_package_name || '.formated_cons_totals_header2', 10);
403: lv_format:= pay_us_payroll_utils.formated_data_string(p_input_string=>'Credit Amount'
404: ,p_output_file_type=>p_output_file_type
405: ,p_bold=>'Y')||
406: pay_us_payroll_utils.formated_data_string(p_input_string=>'Debit Amount'

Line 415: hr_utility.trace('Static Label = ' || lv_format);

411: ,p_bold=>'Y') ;
412:
413:
414: p_static_label := lv_format;
415: hr_utility.trace('Static Label = ' || lv_format);
416: hr_utility.set_location(gv_package_name || '.formated_cons_total_header2', 20);
417:
418: END formated_cons_totals_header2;
419:

Line 416: hr_utility.set_location(gv_package_name || '.formated_cons_total_header2', 20);

412:
413:
414: p_static_label := lv_format;
415: hr_utility.trace('Static Label = ' || lv_format);
416: hr_utility.set_location(gv_package_name || '.formated_cons_total_header2', 20);
417:
418: END formated_cons_totals_header2;
419:
420: /************************************************************

Line 441: hr_utility.set_location(gv_package_name || '.formated_grand_totals_header', 10);

437:
438:
439: BEGIN
440:
441: hr_utility.set_location(gv_package_name || '.formated_grand_totals_header', 10);
442: lv_format:= pay_us_payroll_utils.formated_data_string(p_input_string=>'Unit of Measure'
443: ,p_output_file_type=>p_output_file_type
444: ,p_bold=>'Y')||
445: pay_us_payroll_utils.formated_data_string(p_input_string=>'Credit Amount'

Line 453: hr_utility.trace('Static Label1 = ' || lv_format);

449: ,p_output_file_type=>p_output_file_type
450: ,p_bold=>'Y');
451:
452: p_static_label1 := lv_format;
453: hr_utility.trace('Static Label1 = ' || lv_format);
454: hr_utility.set_location(gv_package_name || '.formated_grand_totals_header', 20);
455:
456: END formated_grand_totals_header;
457:

Line 454: hr_utility.set_location(gv_package_name || '.formated_grand_totals_header', 20);

450: ,p_bold=>'Y');
451:
452: p_static_label1 := lv_format;
453: hr_utility.trace('Static Label1 = ' || lv_format);
454: hr_utility.set_location(gv_package_name || '.formated_grand_totals_header', 20);
455:
456: END formated_grand_totals_header;
457:
458: /************************************************************

Line 487: hr_utility.set_location(gv_package_name || '.formated_data_row', 10);

483:
484:
485: BEGIN
486:
487: hr_utility.set_location(gv_package_name || '.formated_data_row', 10);
488:
489: lv_format1 :=
490: pay_us_payroll_utils.formated_data_string (p_input_string=>p_payroll_name
491: ,p_output_file_type=>p_output_file_type

Line 520: hr_utility.set_location(gv_package_name || '.formated_data_row', 20);

516: ,p_output_file_type=>p_output_file_type
517: ,p_bold=>'N'
518: );
519:
520: hr_utility.set_location(gv_package_name || '.formated_data_row', 20);
521:
522: p_static_data1 := lv_format1;
523: p_static_data2 := lv_format2;
524: hr_utility.trace('Static Data1 = ' || lv_format1);

Line 524: hr_utility.trace('Static Data1 = ' || lv_format1);

520: hr_utility.set_location(gv_package_name || '.formated_data_row', 20);
521:
522: p_static_data1 := lv_format1;
523: p_static_data2 := lv_format2;
524: hr_utility.trace('Static Data1 = ' || lv_format1);
525: hr_utility.trace('Static Data2 = ' || lv_format2);
526: hr_utility.set_location(gv_package_name || '.formated_static_data', 30);
527:
528: END formated_data_row;

Line 525: hr_utility.trace('Static Data2 = ' || lv_format2);

521:
522: p_static_data1 := lv_format1;
523: p_static_data2 := lv_format2;
524: hr_utility.trace('Static Data1 = ' || lv_format1);
525: hr_utility.trace('Static Data2 = ' || lv_format2);
526: hr_utility.set_location(gv_package_name || '.formated_static_data', 30);
527:
528: END formated_data_row;
529:

Line 526: hr_utility.set_location(gv_package_name || '.formated_static_data', 30);

522: p_static_data1 := lv_format1;
523: p_static_data2 := lv_format2;
524: hr_utility.trace('Static Data1 = ' || lv_format1);
525: hr_utility.trace('Static Data2 = ' || lv_format2);
526: hr_utility.set_location(gv_package_name || '.formated_static_data', 30);
527:
528: END formated_data_row;
529:
530: /************************************************************

Line 552: hr_utility.set_location(gv_package_name || '.formated_totals', 10);

548: lv_format1 VARCHAR2(32000);
549: lv_format2 VARCHAR2(32000);
550:
551: BEGIN
552: hr_utility.set_location(gv_package_name || '.formated_totals', 10);
553: lv_format1:=
554: pay_us_payroll_utils.formated_data_string (p_input_string=>p_gre_or_payroll
555: ,p_output_file_type=>p_output_file_type
556: ,p_bold=>'N'

Line 573: hr_utility.trace('Static Data1 = ' || lv_format1);

569: ,p_bold=>'N'
570: );
571: p_static_data1 := lv_format1;
572: p_static_data2 := lv_format2;
573: hr_utility.trace('Static Data1 = ' || lv_format1);
574: hr_utility.trace('Static Data2 = ' || lv_format2);
575: hr_utility.set_location(gv_package_name || '.formated_totals', 20);
576:
577: END formated_totals;

Line 574: hr_utility.trace('Static Data2 = ' || lv_format2);

570: );
571: p_static_data1 := lv_format1;
572: p_static_data2 := lv_format2;
573: hr_utility.trace('Static Data1 = ' || lv_format1);
574: hr_utility.trace('Static Data2 = ' || lv_format2);
575: hr_utility.set_location(gv_package_name || '.formated_totals', 20);
576:
577: END formated_totals;
578:

Line 575: hr_utility.set_location(gv_package_name || '.formated_totals', 20);

571: p_static_data1 := lv_format1;
572: p_static_data2 := lv_format2;
573: hr_utility.trace('Static Data1 = ' || lv_format1);
574: hr_utility.trace('Static Data2 = ' || lv_format2);
575: hr_utility.set_location(gv_package_name || '.formated_totals', 20);
576:
577: END formated_totals;
578:
579: /************************************************************

Line 601: hr_utility.set_location(gv_package_name || '.formated_cons_totals1', 10);

597: lv_format VARCHAR2(32000);
598:
599:
600: BEGIN
601: hr_utility.set_location(gv_package_name || '.formated_cons_totals1', 10);
602: lv_format:=
603: pay_us_payroll_utils.formated_data_string (p_input_string=>p_gre_or_payroll
604: ,p_output_file_type=>p_output_file_type
605: ,p_bold=>'N'

Line 621: hr_utility.trace('Static Data = ' || lv_format);

617: ,p_output_file_type=>p_output_file_type
618: ,p_bold=>'N'
619: );
620: p_static_data := lv_format;
621: hr_utility.trace('Static Data = ' || lv_format);
622: hr_utility.set_location(gv_package_name || '.formated_cons_totals1', 10);
623:
624: END formated_cons_totals1;
625:

Line 622: hr_utility.set_location(gv_package_name || '.formated_cons_totals1', 10);

618: ,p_bold=>'N'
619: );
620: p_static_data := lv_format;
621: hr_utility.trace('Static Data = ' || lv_format);
622: hr_utility.set_location(gv_package_name || '.formated_cons_totals1', 10);
623:
624: END formated_cons_totals1;
625:
626: /************************************************************

Line 645: hr_utility.set_location(gv_package_name || '.formated_cons_totals2', 10);

641: lv_format VARCHAR2(32000);
642:
643:
644: BEGIN
645: hr_utility.set_location(gv_package_name || '.formated_cons_totals2', 10);
646: lv_format:= pay_us_payroll_utils.formated_data_string(p_input_string=>p_credit_amount
647: ,p_output_file_type=>p_output_file_type
648: ,p_bold=>'N'
649: )||

Line 659: hr_utility.trace('Static Data = ' || lv_format);

655: ,p_output_file_type=>p_output_file_type
656: ,p_bold=>'N'
657: );
658: p_static_data := lv_format;
659: hr_utility.trace('Static Data = ' || lv_format);
660: hr_utility.set_location(gv_package_name || '.formated_cons_totals2', 20);
661:
662: END formated_cons_totals2;
663:

Line 660: hr_utility.set_location(gv_package_name || '.formated_cons_totals2', 20);

656: ,p_bold=>'N'
657: );
658: p_static_data := lv_format;
659: hr_utility.trace('Static Data = ' || lv_format);
660: hr_utility.set_location(gv_package_name || '.formated_cons_totals2', 20);
661:
662: END formated_cons_totals2;
663:
664: /************************************************************

Line 683: hr_utility.set_location(gv_package_name || '.formated_grand_totals', 10);

679: ) IS
680: lv_format VARCHAR2(32000);
681:
682: BEGIN
683: hr_utility.set_location(gv_package_name || '.formated_grand_totals', 10);
684: lv_format:=
685: pay_us_payroll_utils.formated_data_string(p_input_string=>p_uom
686: ,p_output_file_type=>p_output_file_type
687: ,p_bold=>'N'

Line 698: hr_utility.trace('Static Data1 = ' || lv_format);

694: ,p_output_file_type=>p_output_file_type
695: ,p_bold=>'N'
696: );
697: p_static_data1 := lv_format;
698: hr_utility.trace('Static Data1 = ' || lv_format);
699: hr_utility.set_location(gv_package_name || '.formated_grand_totals', 20);
700:
701: END formated_grand_totals;
702:

Line 699: hr_utility.set_location(gv_package_name || '.formated_grand_totals', 20);

695: ,p_bold=>'N'
696: );
697: p_static_data1 := lv_format;
698: hr_utility.trace('Static Data1 = ' || lv_format);
699: hr_utility.set_location(gv_package_name || '.formated_grand_totals', 20);
700:
701: END formated_grand_totals;
702:
703: /******************************************************************

Line 1190: hr_utility.set_location(gv_package_name || '.costing_summary', 10);

1186: /*sackumar testing*/
1187: i_sackumar number;
1188: BEGIN
1189:
1190: hr_utility.set_location(gv_package_name || '.costing_summary', 10);
1191: hr_utility.trace('Start Date = ' || p_start_date);
1192: hr_utility.trace('End Date = ' || p_END_date);
1193: hr_utility.trace('Business Group ID = '|| p_business_group_id);
1194: hr_utility.trace('Costing Process = ' || p_costing);

Line 1191: hr_utility.trace('Start Date = ' || p_start_date);

1187: i_sackumar number;
1188: BEGIN
1189:
1190: hr_utility.set_location(gv_package_name || '.costing_summary', 10);
1191: hr_utility.trace('Start Date = ' || p_start_date);
1192: hr_utility.trace('End Date = ' || p_END_date);
1193: hr_utility.trace('Business Group ID = '|| p_business_group_id);
1194: hr_utility.trace('Costing Process = ' || p_costing);
1195: hr_utility.trace('Payroll ID = ' || p_payroll_id);

Line 1192: hr_utility.trace('End Date = ' || p_END_date);

1188: BEGIN
1189:
1190: hr_utility.set_location(gv_package_name || '.costing_summary', 10);
1191: hr_utility.trace('Start Date = ' || p_start_date);
1192: hr_utility.trace('End Date = ' || p_END_date);
1193: hr_utility.trace('Business Group ID = '|| p_business_group_id);
1194: hr_utility.trace('Costing Process = ' || p_costing);
1195: hr_utility.trace('Payroll ID = ' || p_payroll_id);
1196: hr_utility.trace('Consolidation Set ID = ' || p_consolidation_set_id);

Line 1193: hr_utility.trace('Business Group ID = '|| p_business_group_id);

1189:
1190: hr_utility.set_location(gv_package_name || '.costing_summary', 10);
1191: hr_utility.trace('Start Date = ' || p_start_date);
1192: hr_utility.trace('End Date = ' || p_END_date);
1193: hr_utility.trace('Business Group ID = '|| p_business_group_id);
1194: hr_utility.trace('Costing Process = ' || p_costing);
1195: hr_utility.trace('Payroll ID = ' || p_payroll_id);
1196: hr_utility.trace('Consolidation Set ID = ' || p_consolidation_set_id);
1197: hr_utility.trace('Tax unit ID = ' || p_tax_unit_id);

Line 1194: hr_utility.trace('Costing Process = ' || p_costing);

1190: hr_utility.set_location(gv_package_name || '.costing_summary', 10);
1191: hr_utility.trace('Start Date = ' || p_start_date);
1192: hr_utility.trace('End Date = ' || p_END_date);
1193: hr_utility.trace('Business Group ID = '|| p_business_group_id);
1194: hr_utility.trace('Costing Process = ' || p_costing);
1195: hr_utility.trace('Payroll ID = ' || p_payroll_id);
1196: hr_utility.trace('Consolidation Set ID = ' || p_consolidation_set_id);
1197: hr_utility.trace('Tax unit ID = ' || p_tax_unit_id);
1198: hr_utility.trace('Cost Type = ' || p_cost_type);

Line 1195: hr_utility.trace('Payroll ID = ' || p_payroll_id);

1191: hr_utility.trace('Start Date = ' || p_start_date);
1192: hr_utility.trace('End Date = ' || p_END_date);
1193: hr_utility.trace('Business Group ID = '|| p_business_group_id);
1194: hr_utility.trace('Costing Process = ' || p_costing);
1195: hr_utility.trace('Payroll ID = ' || p_payroll_id);
1196: hr_utility.trace('Consolidation Set ID = ' || p_consolidation_set_id);
1197: hr_utility.trace('Tax unit ID = ' || p_tax_unit_id);
1198: hr_utility.trace('Cost Type = ' || p_cost_type);
1199: hr_utility.trace('Sort Order 1 = ' || p_sort_order1);

Line 1196: hr_utility.trace('Consolidation Set ID = ' || p_consolidation_set_id);

1192: hr_utility.trace('End Date = ' || p_END_date);
1193: hr_utility.trace('Business Group ID = '|| p_business_group_id);
1194: hr_utility.trace('Costing Process = ' || p_costing);
1195: hr_utility.trace('Payroll ID = ' || p_payroll_id);
1196: hr_utility.trace('Consolidation Set ID = ' || p_consolidation_set_id);
1197: hr_utility.trace('Tax unit ID = ' || p_tax_unit_id);
1198: hr_utility.trace('Cost Type = ' || p_cost_type);
1199: hr_utility.trace('Sort Order 1 = ' || p_sort_order1);
1200: hr_utility.trace('Sort Order 2 = ' || p_sort_order2);

Line 1197: hr_utility.trace('Tax unit ID = ' || p_tax_unit_id);

1193: hr_utility.trace('Business Group ID = '|| p_business_group_id);
1194: hr_utility.trace('Costing Process = ' || p_costing);
1195: hr_utility.trace('Payroll ID = ' || p_payroll_id);
1196: hr_utility.trace('Consolidation Set ID = ' || p_consolidation_set_id);
1197: hr_utility.trace('Tax unit ID = ' || p_tax_unit_id);
1198: hr_utility.trace('Cost Type = ' || p_cost_type);
1199: hr_utility.trace('Sort Order 1 = ' || p_sort_order1);
1200: hr_utility.trace('Sort Order 2 = ' || p_sort_order2);
1201: hr_utility.trace('Output File Type = ' || p_output_file_type);

Line 1198: hr_utility.trace('Cost Type = ' || p_cost_type);

1194: hr_utility.trace('Costing Process = ' || p_costing);
1195: hr_utility.trace('Payroll ID = ' || p_payroll_id);
1196: hr_utility.trace('Consolidation Set ID = ' || p_consolidation_set_id);
1197: hr_utility.trace('Tax unit ID = ' || p_tax_unit_id);
1198: hr_utility.trace('Cost Type = ' || p_cost_type);
1199: hr_utility.trace('Sort Order 1 = ' || p_sort_order1);
1200: hr_utility.trace('Sort Order 2 = ' || p_sort_order2);
1201: hr_utility.trace('Output File Type = ' || p_output_file_type);
1202:

Line 1199: hr_utility.trace('Sort Order 1 = ' || p_sort_order1);

1195: hr_utility.trace('Payroll ID = ' || p_payroll_id);
1196: hr_utility.trace('Consolidation Set ID = ' || p_consolidation_set_id);
1197: hr_utility.trace('Tax unit ID = ' || p_tax_unit_id);
1198: hr_utility.trace('Cost Type = ' || p_cost_type);
1199: hr_utility.trace('Sort Order 1 = ' || p_sort_order1);
1200: hr_utility.trace('Sort Order 2 = ' || p_sort_order2);
1201: hr_utility.trace('Output File Type = ' || p_output_file_type);
1202:
1203: formated_static_header(p_output_file_type,

Line 1200: hr_utility.trace('Sort Order 2 = ' || p_sort_order2);

1196: hr_utility.trace('Consolidation Set ID = ' || p_consolidation_set_id);
1197: hr_utility.trace('Tax unit ID = ' || p_tax_unit_id);
1198: hr_utility.trace('Cost Type = ' || p_cost_type);
1199: hr_utility.trace('Sort Order 1 = ' || p_sort_order1);
1200: hr_utility.trace('Sort Order 2 = ' || p_sort_order2);
1201: hr_utility.trace('Output File Type = ' || p_output_file_type);
1202:
1203: formated_static_header(p_output_file_type,
1204: lv_header_label1,

Line 1201: hr_utility.trace('Output File Type = ' || p_output_file_type);

1197: hr_utility.trace('Tax unit ID = ' || p_tax_unit_id);
1198: hr_utility.trace('Cost Type = ' || p_cost_type);
1199: hr_utility.trace('Sort Order 1 = ' || p_sort_order1);
1200: hr_utility.trace('Sort Order 2 = ' || p_sort_order2);
1201: hr_utility.trace('Output File Type = ' || p_output_file_type);
1202:
1203: formated_static_header(p_output_file_type,
1204: lv_header_label1,
1205: lv_header_label2);

Line 1206: hr_utility.trace('Header Label 1 = ' || lv_header_label1);

1202:
1203: formated_static_header(p_output_file_type,
1204: lv_header_label1,
1205: lv_header_label2);
1206: hr_utility.trace('Header Label 1 = ' || lv_header_label1);
1207: hr_utility.trace('Header Label 2 = ' || lv_header_label2);
1208:
1209: lv_header_label:=lv_header_label1;
1210: OPEN c_costing_flex_id (p_business_group_id);

Line 1207: hr_utility.trace('Header Label 2 = ' || lv_header_label2);

1203: formated_static_header(p_output_file_type,
1204: lv_header_label1,
1205: lv_header_label2);
1206: hr_utility.trace('Header Label 1 = ' || lv_header_label1);
1207: hr_utility.trace('Header Label 2 = ' || lv_header_label2);
1208:
1209: lv_header_label:=lv_header_label1;
1210: OPEN c_costing_flex_id (p_business_group_id);
1211: FETCH c_costing_flex_id into ln_costing_id_flex_num;

Line 1213: hr_utility.set_location(gv_package_name || '.costing_summary', 20);

1209: lv_header_label:=lv_header_label1;
1210: OPEN c_costing_flex_id (p_business_group_id);
1211: FETCH c_costing_flex_id into ln_costing_id_flex_num;
1212: IF c_costing_flex_id%found THEN
1213: hr_utility.set_location(gv_package_name || '.costing_summary', 20);
1214: OPEN c_costing_flex_segments (ln_costing_id_flex_num);
1215: LOOP
1216: FETCH c_costing_flex_segments into lv_segment_name, lv_column_name;
1217: IF c_costing_flex_segments%notfound THEN

Line 1236: hr_utility.trace('data from cursor c_costing_flex_segments stored in ltr_costing_segment PL/SQL table');

1232: CLOSE c_costing_flex_segments;
1233:
1234: /*sackumar testing */
1235: i_sackumar :=0;
1236: hr_utility.trace('data from cursor c_costing_flex_segments stored in ltr_costing_segment PL/SQL table');
1237: for i_sackumar in ltr_costing_segment.first .. ltr_costing_segment.last LOOP
1238: hr_utility.trace(ltr_costing_segment(i_sackumar).segment_label||'='||ltr_costing_segment(i_sackumar).column_name);
1239: end loop;
1240: hr_utility.trace('ends data from cursor c_costing_flex_segments ');

Line 1238: hr_utility.trace(ltr_costing_segment(i_sackumar).segment_label||'='||ltr_costing_segment(i_sackumar).column_name);

1234: /*sackumar testing */
1235: i_sackumar :=0;
1236: hr_utility.trace('data from cursor c_costing_flex_segments stored in ltr_costing_segment PL/SQL table');
1237: for i_sackumar in ltr_costing_segment.first .. ltr_costing_segment.last LOOP
1238: hr_utility.trace(ltr_costing_segment(i_sackumar).segment_label||'='||ltr_costing_segment(i_sackumar).column_name);
1239: end loop;
1240: hr_utility.trace('ends data from cursor c_costing_flex_segments ');
1241: /*end of sac kumar testing */
1242:

Line 1240: hr_utility.trace('ends data from cursor c_costing_flex_segments ');

1236: hr_utility.trace('data from cursor c_costing_flex_segments stored in ltr_costing_segment PL/SQL table');
1237: for i_sackumar in ltr_costing_segment.first .. ltr_costing_segment.last LOOP
1238: hr_utility.trace(ltr_costing_segment(i_sackumar).segment_label||'='||ltr_costing_segment(i_sackumar).column_name);
1239: end loop;
1240: hr_utility.trace('ends data from cursor c_costing_flex_segments ');
1241: /*end of sac kumar testing */
1242:
1243: END IF;
1244: CLOSE c_costing_flex_id;

Line 1267: hr_utility.set_location(gv_package_name || '.costing_summary', 30);

1263: OPEN c_get_consolidation_set_name(p_consolidation_set_id);
1264: FETCH c_get_consolidation_set_name into lv_consolidation_set_name;
1265: CLOSE c_get_consolidation_set_name;
1266:
1267: hr_utility.set_location(gv_package_name || '.costing_summary', 30);
1268:
1269: lv_include_accruals:= nvl(hr_general.decode_lookup('PAY_PAYRPCBR',p_cost_type),' ');
1270: IF p_output_file_type='HTML' AND lv_include_accruals = ' ' THEN
1271: lv_include_accruals:=' ';

Line 1275: hr_utility.trace('to_NUMBER(p_costing)='||to_NUMBER(p_costing));

1271: lv_include_accruals:=' ';
1272: END IF;
1273:
1274: IF p_costing IS not NULL THEN
1275: hr_utility.trace('to_NUMBER(p_costing)='||to_NUMBER(p_costing));
1276: OPEN c_get_effective_date(to_NUMBER(p_costing));
1277: FETCH c_get_effective_date into lv_start_date;
1278: CLOSE c_get_effective_date;
1279: lv_end_date := lv_start_date;

Line 1287: hr_utility.set_location(gv_package_name || '.costing_summary', 40);

1283: lv_end_date :=to_date(p_end_date, 'YYYY/MM/DD HH24:MI:SS');
1284: lv_costing_process_flag:='N';
1285: END IF;
1286:
1287: hr_utility.set_location(gv_package_name || '.costing_summary', 40);
1288:
1289: formated_title_page(p_output_file_type=> p_output_file_type
1290: ,p_business_group => lv_business_group_name
1291: ,p_start_date =>lv_start_date

Line 1302: hr_utility.set_location(gv_package_name || '.costing_summary', 50);

1298: ,p_sort_order1 =>p_sort_order1
1299: ,p_sort_order2 =>p_sort_order2
1300: );
1301:
1302: hr_utility.set_location(gv_package_name || '.costing_summary', 50);
1303:
1304: /****************************************************************
1305: ** Print the Header Information. If the format IS HTML THEN OPEN
1306: ** the body and table before printing the header info, otherwISe

Line 1323: hr_utility.trace('Sort Option 1 = ' || p_sort_order1);

1319:
1320: OPEN c_get_session_id;
1321: FETCH c_get_session_id into lv_session_id;
1322: CLOSE c_get_session_id;
1323: hr_utility.trace('Sort Option 1 = ' || p_sort_order1);
1324: hr_utility.trace('Sort Option 2 = ' || p_sort_order2);
1325:
1326: /************* changed to ref cursor 3946996 */
1327:

Line 1324: hr_utility.trace('Sort Option 2 = ' || p_sort_order2);

1320: OPEN c_get_session_id;
1321: FETCH c_get_session_id into lv_session_id;
1322: CLOSE c_get_session_id;
1323: hr_utility.trace('Sort Option 1 = ' || p_sort_order1);
1324: hr_utility.trace('Sort Option 2 = ' || p_sort_order2);
1325:
1326: /************* changed to ref cursor 3946996 */
1327:
1328: c_clause1 :=get_optional_where_clause(p_payroll_id,

Line 1335: hr_utility.trace('c_clause1 = ' || c_clause1);

1331: lv_costing_process_flag,
1332: p_costing,
1333: p_cost_type);
1334:
1335: hr_utility.trace('c_clause1 = ' || c_clause1);
1336:
1337: c_query := 'SELECT
1338: pcd.payroll_name
1339: ,pcd.gre_name

Line 1459: hr_utility.trace('Start Date for Query = '||lv_start_date);

1455: ,p_business_group_id
1456: ,p_sort_order1
1457: ,p_sort_order2;
1458:
1459: hr_utility.trace('Start Date for Query = '||lv_start_date);
1460: hr_utility.trace('End Date for Query = '||lv_end_date);
1461: hr_utility.trace('Bussiness Group for Query = '||p_business_group_id);
1462: hr_utility.trace('Short Order 1 for Query = '||p_sort_order1);
1463: hr_utility.trace('Short Order 2 for Query = '||p_sort_order2);

Line 1460: hr_utility.trace('End Date for Query = '||lv_end_date);

1456: ,p_sort_order1
1457: ,p_sort_order2;
1458:
1459: hr_utility.trace('Start Date for Query = '||lv_start_date);
1460: hr_utility.trace('End Date for Query = '||lv_end_date);
1461: hr_utility.trace('Bussiness Group for Query = '||p_business_group_id);
1462: hr_utility.trace('Short Order 1 for Query = '||p_sort_order1);
1463: hr_utility.trace('Short Order 2 for Query = '||p_sort_order2);
1464:

Line 1461: hr_utility.trace('Bussiness Group for Query = '||p_business_group_id);

1457: ,p_sort_order2;
1458:
1459: hr_utility.trace('Start Date for Query = '||lv_start_date);
1460: hr_utility.trace('End Date for Query = '||lv_end_date);
1461: hr_utility.trace('Bussiness Group for Query = '||p_business_group_id);
1462: hr_utility.trace('Short Order 1 for Query = '||p_sort_order1);
1463: hr_utility.trace('Short Order 2 for Query = '||p_sort_order2);
1464:
1465: LOOP

Line 1462: hr_utility.trace('Short Order 1 for Query = '||p_sort_order1);

1458:
1459: hr_utility.trace('Start Date for Query = '||lv_start_date);
1460: hr_utility.trace('End Date for Query = '||lv_end_date);
1461: hr_utility.trace('Bussiness Group for Query = '||p_business_group_id);
1462: hr_utility.trace('Short Order 1 for Query = '||p_sort_order1);
1463: hr_utility.trace('Short Order 2 for Query = '||p_sort_order2);
1464:
1465: LOOP
1466: FETCH c_asg_costing_details into

Line 1463: hr_utility.trace('Short Order 2 for Query = '||p_sort_order2);

1459: hr_utility.trace('Start Date for Query = '||lv_start_date);
1460: hr_utility.trace('End Date for Query = '||lv_end_date);
1461: hr_utility.trace('Bussiness Group for Query = '||p_business_group_id);
1462: hr_utility.trace('Short Order 1 for Query = '||p_sort_order1);
1463: hr_utility.trace('Short Order 2 for Query = '||p_sort_order2);
1464:
1465: LOOP
1466: FETCH c_asg_costing_details into
1467: lv_payroll_name

Line 1507: hr_utility.set_location(gv_package_name || '.costing_summary', 60);

1503: ,lv_segment29
1504: ,lv_segment30;
1505:
1506: IF c_asg_costing_details%notfound THEN
1507: hr_utility.set_location(gv_package_name || '.costing_summary', 60);
1508: exit;
1509: END IF;
1510:
1511: hr_utility.trace('Record No (After Main Query) - '||c_asg_costing_details%rowcount);

Line 1511: hr_utility.trace('Record No (After Main Query) - '||c_asg_costing_details%rowcount);

1507: hr_utility.set_location(gv_package_name || '.costing_summary', 60);
1508: exit;
1509: END IF;
1510:
1511: hr_utility.trace('Record No (After Main Query) - '||c_asg_costing_details%rowcount);
1512:
1513: lv_accrual_type:=nvl(hr_general.decode_lookup('PAY_PAYRPCBR',lv_cost_mode),' ');
1514: IF p_output_file_type='HTML' AND lv_accrual_type = ' ' THEN
1515: lv_accrual_type:=' ';

Line 1575: hr_utility.set_location(gv_package_name || '.costing_summary', 70);

1571: ,lv_concatenated_segments --attribute33
1572: ,lv_uom --attribute34
1573: );
1574:
1575: hr_utility.set_location(gv_package_name || '.costing_summary', 70);
1576:
1577:
1578: formated_data_row(p_payroll_name => lv_payroll_name
1579: ,p_gre_name => lv_gre_name

Line 1589: hr_utility.set_location(gv_package_name || '.costing_summary', 80);

1585: ,p_output_file_type=> p_output_file_type
1586: ,p_static_data1 => lv_data_row1
1587: ,p_static_data2 => lv_data_row2
1588: ) ;
1589: hr_utility.set_location(gv_package_name || '.costing_summary', 80);
1590: hr_utility.trace('lv_data_row1 = ' || lv_data_row1);
1591: hr_utility.trace('lv_data_row2 = ' || lv_data_row2);
1592:
1593:

Line 1590: hr_utility.trace('lv_data_row1 = ' || lv_data_row1);

1586: ,p_static_data1 => lv_data_row1
1587: ,p_static_data2 => lv_data_row2
1588: ) ;
1589: hr_utility.set_location(gv_package_name || '.costing_summary', 80);
1590: hr_utility.trace('lv_data_row1 = ' || lv_data_row1);
1591: hr_utility.trace('lv_data_row2 = ' || lv_data_row2);
1592:
1593:
1594: lv_data_row:= lv_data_row1;

Line 1591: hr_utility.trace('lv_data_row2 = ' || lv_data_row2);

1587: ,p_static_data2 => lv_data_row2
1588: ) ;
1589: hr_utility.set_location(gv_package_name || '.costing_summary', 80);
1590: hr_utility.trace('lv_data_row1 = ' || lv_data_row1);
1591: hr_utility.trace('lv_data_row2 = ' || lv_data_row2);
1592:
1593:
1594: lv_data_row:= lv_data_row1;
1595:

Line 1669: hr_utility.trace('lv_data_row = ' || lv_data_row);

1665: END LOOP ;
1666:
1667: lv_data_row:=lv_data_row||lv_data_row2;
1668:
1669: hr_utility.trace('lv_data_row = ' || lv_data_row);
1670:
1671: IF p_output_file_type ='HTML' THEN
1672: lv_data_row := '' || lv_data_row || '' ;
1673: END IF;

Line 1715: hr_utility.set_location(gv_package_name || '.costing_summary', 90);

1711: formated_totals_header(p_sort_order1,p_output_file_type,lv_header_label1,lv_header_label2);
1712: lv_header_label1:=lv_header_label1 || lv_cost_flex_header;
1713: lv_header_label2:=lv_header_label1 || lv_header_label2;
1714:
1715: hr_utility.set_location(gv_package_name || '.costing_summary', 90);
1716:
1717: FND_FILE.PUT_LINE(fnd_file.output, lv_header_label2);
1718:
1719:

Line 1763: hr_utility.set_location(gv_package_name || '.costing_summary', 100);

1759: ,lv_segment28
1760: ,lv_segment29
1761: ,lv_segment30;
1762: IF c_costing_summary_rpt_details%notfound THEN
1763: hr_utility.set_location(gv_package_name || '.costing_summary', 100);
1764: exit;
1765: END IF;
1766:
1767: formated_totals(p_gre_or_payroll => lv_gre_or_payroll

Line 1851: hr_utility.trace('lv_data_row = ' || lv_data_row);

1847: END LOOP ;
1848:
1849: lv_data_row:=lv_data_row||lv_data_row2;
1850:
1851: hr_utility.trace('lv_data_row = ' || lv_data_row);
1852:
1853: IF p_output_file_type ='HTML' THEN
1854: lv_data_row := '' || lv_data_row || '' ;
1855: END IF;

Line 1887: hr_utility.set_location(gv_package_name || '.costing_summary', 110);

1883: END IF;
1884:
1885:
1886: formated_cons_totals_header1(p_sort_order1,p_output_file_type,lv_header_label);
1887: hr_utility.set_location(gv_package_name || '.costing_summary', 110);
1888:
1889: FND_FILE.PUT_LINE(fnd_file.output, lv_header_label);
1890:
1891: OPEN c_get_gre_or_payroll_totals (lv_session_id

Line 1903: hr_utility.set_location(gv_package_name || '.costing_summary', 90);

1899: ,lv_uom
1900: ,ln_credit_amount
1901: ,ln_debit_amount;
1902: IF c_get_gre_or_payroll_totals%notfound THEN
1903: hr_utility.set_location(gv_package_name || '.costing_summary', 90);
1904: exit;
1905: END IF;
1906:
1907: formated_cons_totals1(p_gre_or_payroll => lv_gre_or_payroll

Line 1915: hr_utility.trace('lv_data_row = ' || lv_data_row);

1911: ,p_output_file_type => p_output_file_type
1912: ,p_static_data => lv_data_row
1913: );
1914:
1915: hr_utility.trace('lv_data_row = ' || lv_data_row);
1916: IF p_output_file_type ='HTML' THEN
1917: lv_data_row := '' || lv_data_row || '' ;
1918: END IF;
1919:

Line 1993: hr_utility.set_location(gv_package_name || '.costing_summary', 120);

1989: lv_credit_sum:= lv_credit_sum + ln_credit_amount;
1990: lv_debit_sum:= lv_debit_sum + ln_debit_amount;
1991:
1992: IF c_costing_grand_totals%notfound THEN
1993: hr_utility.set_location(gv_package_name || '.costing_summary', 120);
1994: exit;
1995: END IF;
1996:
1997: formated_grand_totals(p_uom => lv_uom

Line 2078: hr_utility.trace('lv_data_row = ' || lv_data_row);

2074:
2075: END LOOP ;
2076:
2077: lv_data_row:=lv_data_row||lv_data_row1;
2078: hr_utility.trace('lv_data_row = ' || lv_data_row);
2079: IF p_output_file_type ='HTML' THEN
2080: lv_data_row := '' || lv_data_row || '' ;
2081: END IF;
2082:

Line 2110: hr_utility.set_location(gv_package_name || '.costing_summary', 140);

2106: ,p_bold=>'N'));
2107: END IF;
2108:
2109: formated_cons_totals_header2(p_output_file_type,lv_header_label);
2110: hr_utility.set_location(gv_package_name || '.costing_summary', 140);
2111:
2112: FND_FILE.PUT_LINE(fnd_file.output, lv_header_label);
2113:
2114:

Line 2122: hr_utility.set_location(gv_package_name || '.costing_summary', 150);

2118: lv_uom
2119: ,lv_credit_sum
2120: ,lv_debit_sum;
2121: IF c_get_report_totals%notfound THEN
2122: hr_utility.set_location(gv_package_name || '.costing_summary', 150);
2123: exit;
2124: END IF;
2125:
2126: formated_cons_totals2 (p_uom => lv_uom

Line 2133: hr_utility.trace(lv_data_row);

2129: ,p_output_file_type => p_output_file_type
2130: ,p_static_data => lv_data_row
2131: );
2132:
2133: hr_utility.trace(lv_data_row);
2134:
2135: IF p_output_file_type ='HTML' THEN
2136: lv_data_row := '' || lv_data_row || '' ;
2137: END IF;

Line 2149: hr_utility.trace('Concurrent Request ID = ' || FND_GLOBAL.CONC_REQUEST_ID);

2145: END LOOP;
2146: CLOSE c_get_report_totals;
2147:
2148: DELETE FROM pay_us_rpt_totals where attribute31='CSR';
2149: hr_utility.trace('Concurrent Request ID = ' || FND_GLOBAL.CONC_REQUEST_ID);
2150: END costing_summary;
2151: --begin
2152: --hr_utility.trace_on(null, 'COSTING');
2153: END pay_costing_summary_rep_pkg;

Line 2152: --hr_utility.trace_on(null, 'COSTING');

2148: DELETE FROM pay_us_rpt_totals where attribute31='CSR';
2149: hr_utility.trace('Concurrent Request ID = ' || FND_GLOBAL.CONC_REQUEST_ID);
2150: END costing_summary;
2151: --begin
2152: --hr_utility.trace_on(null, 'COSTING');
2153: END pay_costing_summary_rep_pkg;