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 1125: hr_utility.set_location(gv_package_name || '.costing_summary', 10);

1121: /*sackumar testing*/
1122: i_sackumar number;
1123: BEGIN
1124:
1125: hr_utility.set_location(gv_package_name || '.costing_summary', 10);
1126: hr_utility.trace('Start Date = ' || p_start_date);
1127: hr_utility.trace('End Date = ' || p_END_date);
1128: hr_utility.trace('Business Group ID = '|| p_business_group_id);
1129: hr_utility.trace('Costing Process = ' || p_costing);

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

1122: i_sackumar number;
1123: BEGIN
1124:
1125: hr_utility.set_location(gv_package_name || '.costing_summary', 10);
1126: hr_utility.trace('Start Date = ' || p_start_date);
1127: hr_utility.trace('End Date = ' || p_END_date);
1128: hr_utility.trace('Business Group ID = '|| p_business_group_id);
1129: hr_utility.trace('Costing Process = ' || p_costing);
1130: hr_utility.trace('Payroll ID = ' || p_payroll_id);

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

1123: BEGIN
1124:
1125: hr_utility.set_location(gv_package_name || '.costing_summary', 10);
1126: hr_utility.trace('Start Date = ' || p_start_date);
1127: hr_utility.trace('End Date = ' || p_END_date);
1128: hr_utility.trace('Business Group ID = '|| p_business_group_id);
1129: hr_utility.trace('Costing Process = ' || p_costing);
1130: hr_utility.trace('Payroll ID = ' || p_payroll_id);
1131: hr_utility.trace('Consolidation Set ID = ' || p_consolidation_set_id);

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

1124:
1125: hr_utility.set_location(gv_package_name || '.costing_summary', 10);
1126: hr_utility.trace('Start Date = ' || p_start_date);
1127: hr_utility.trace('End Date = ' || p_END_date);
1128: hr_utility.trace('Business Group ID = '|| p_business_group_id);
1129: hr_utility.trace('Costing Process = ' || p_costing);
1130: hr_utility.trace('Payroll ID = ' || p_payroll_id);
1131: hr_utility.trace('Consolidation Set ID = ' || p_consolidation_set_id);
1132: hr_utility.trace('Tax unit ID = ' || p_tax_unit_id);

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

1125: hr_utility.set_location(gv_package_name || '.costing_summary', 10);
1126: hr_utility.trace('Start Date = ' || p_start_date);
1127: hr_utility.trace('End Date = ' || p_END_date);
1128: hr_utility.trace('Business Group ID = '|| p_business_group_id);
1129: hr_utility.trace('Costing Process = ' || p_costing);
1130: hr_utility.trace('Payroll ID = ' || p_payroll_id);
1131: hr_utility.trace('Consolidation Set ID = ' || p_consolidation_set_id);
1132: hr_utility.trace('Tax unit ID = ' || p_tax_unit_id);
1133: hr_utility.trace('Cost Type = ' || p_cost_type);

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

1126: hr_utility.trace('Start Date = ' || p_start_date);
1127: hr_utility.trace('End Date = ' || p_END_date);
1128: hr_utility.trace('Business Group ID = '|| p_business_group_id);
1129: hr_utility.trace('Costing Process = ' || p_costing);
1130: hr_utility.trace('Payroll ID = ' || p_payroll_id);
1131: hr_utility.trace('Consolidation Set ID = ' || p_consolidation_set_id);
1132: hr_utility.trace('Tax unit ID = ' || p_tax_unit_id);
1133: hr_utility.trace('Cost Type = ' || p_cost_type);
1134: hr_utility.trace('Sort Order 1 = ' || p_sort_order1);

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

1127: hr_utility.trace('End Date = ' || p_END_date);
1128: hr_utility.trace('Business Group ID = '|| p_business_group_id);
1129: hr_utility.trace('Costing Process = ' || p_costing);
1130: hr_utility.trace('Payroll ID = ' || p_payroll_id);
1131: hr_utility.trace('Consolidation Set ID = ' || p_consolidation_set_id);
1132: hr_utility.trace('Tax unit ID = ' || p_tax_unit_id);
1133: hr_utility.trace('Cost Type = ' || p_cost_type);
1134: hr_utility.trace('Sort Order 1 = ' || p_sort_order1);
1135: hr_utility.trace('Sort Order 2 = ' || p_sort_order2);

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

1128: hr_utility.trace('Business Group ID = '|| p_business_group_id);
1129: hr_utility.trace('Costing Process = ' || p_costing);
1130: hr_utility.trace('Payroll ID = ' || p_payroll_id);
1131: hr_utility.trace('Consolidation Set ID = ' || p_consolidation_set_id);
1132: hr_utility.trace('Tax unit ID = ' || p_tax_unit_id);
1133: hr_utility.trace('Cost Type = ' || p_cost_type);
1134: hr_utility.trace('Sort Order 1 = ' || p_sort_order1);
1135: hr_utility.trace('Sort Order 2 = ' || p_sort_order2);
1136: hr_utility.trace('Output File Type = ' || p_output_file_type);

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

1129: hr_utility.trace('Costing Process = ' || p_costing);
1130: hr_utility.trace('Payroll ID = ' || p_payroll_id);
1131: hr_utility.trace('Consolidation Set ID = ' || p_consolidation_set_id);
1132: hr_utility.trace('Tax unit ID = ' || p_tax_unit_id);
1133: hr_utility.trace('Cost Type = ' || p_cost_type);
1134: hr_utility.trace('Sort Order 1 = ' || p_sort_order1);
1135: hr_utility.trace('Sort Order 2 = ' || p_sort_order2);
1136: hr_utility.trace('Output File Type = ' || p_output_file_type);
1137:

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

1130: hr_utility.trace('Payroll ID = ' || p_payroll_id);
1131: hr_utility.trace('Consolidation Set ID = ' || p_consolidation_set_id);
1132: hr_utility.trace('Tax unit ID = ' || p_tax_unit_id);
1133: hr_utility.trace('Cost Type = ' || p_cost_type);
1134: hr_utility.trace('Sort Order 1 = ' || p_sort_order1);
1135: hr_utility.trace('Sort Order 2 = ' || p_sort_order2);
1136: hr_utility.trace('Output File Type = ' || p_output_file_type);
1137:
1138: formated_static_header(p_output_file_type,

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

1131: hr_utility.trace('Consolidation Set ID = ' || p_consolidation_set_id);
1132: hr_utility.trace('Tax unit ID = ' || p_tax_unit_id);
1133: hr_utility.trace('Cost Type = ' || p_cost_type);
1134: hr_utility.trace('Sort Order 1 = ' || p_sort_order1);
1135: hr_utility.trace('Sort Order 2 = ' || p_sort_order2);
1136: hr_utility.trace('Output File Type = ' || p_output_file_type);
1137:
1138: formated_static_header(p_output_file_type,
1139: lv_header_label1,

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

1132: hr_utility.trace('Tax unit ID = ' || p_tax_unit_id);
1133: hr_utility.trace('Cost Type = ' || p_cost_type);
1134: hr_utility.trace('Sort Order 1 = ' || p_sort_order1);
1135: hr_utility.trace('Sort Order 2 = ' || p_sort_order2);
1136: hr_utility.trace('Output File Type = ' || p_output_file_type);
1137:
1138: formated_static_header(p_output_file_type,
1139: lv_header_label1,
1140: lv_header_label2);

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

1137:
1138: formated_static_header(p_output_file_type,
1139: lv_header_label1,
1140: lv_header_label2);
1141: hr_utility.trace('Header Label 1 = ' || lv_header_label1);
1142: hr_utility.trace('Header Label 2 = ' || lv_header_label2);
1143:
1144: lv_header_label:=lv_header_label1;
1145: OPEN c_costing_flex_id (p_business_group_id);

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

1138: formated_static_header(p_output_file_type,
1139: lv_header_label1,
1140: lv_header_label2);
1141: hr_utility.trace('Header Label 1 = ' || lv_header_label1);
1142: hr_utility.trace('Header Label 2 = ' || lv_header_label2);
1143:
1144: lv_header_label:=lv_header_label1;
1145: OPEN c_costing_flex_id (p_business_group_id);
1146: FETCH c_costing_flex_id into ln_costing_id_flex_num;

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

1144: lv_header_label:=lv_header_label1;
1145: OPEN c_costing_flex_id (p_business_group_id);
1146: FETCH c_costing_flex_id into ln_costing_id_flex_num;
1147: IF c_costing_flex_id%found THEN
1148: hr_utility.set_location(gv_package_name || '.costing_summary', 20);
1149: OPEN c_costing_flex_segments (ln_costing_id_flex_num);
1150: LOOP
1151: FETCH c_costing_flex_segments into lv_segment_name, lv_column_name;
1152: IF c_costing_flex_segments%notfound THEN

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

1167: CLOSE c_costing_flex_segments;
1168:
1169: /*sackumar testing */
1170: i_sackumar :=0;
1171: hr_utility.trace('data from cursor c_costing_flex_segments stored in ltr_costing_segment PL/SQL table');
1172: for i_sackumar in ltr_costing_segment.first .. ltr_costing_segment.last LOOP
1173: hr_utility.trace(ltr_costing_segment(i_sackumar).segment_label||'='||ltr_costing_segment(i_sackumar).column_name);
1174: end loop;
1175: hr_utility.trace('ends data from cursor c_costing_flex_segments ');

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

1169: /*sackumar testing */
1170: i_sackumar :=0;
1171: hr_utility.trace('data from cursor c_costing_flex_segments stored in ltr_costing_segment PL/SQL table');
1172: for i_sackumar in ltr_costing_segment.first .. ltr_costing_segment.last LOOP
1173: hr_utility.trace(ltr_costing_segment(i_sackumar).segment_label||'='||ltr_costing_segment(i_sackumar).column_name);
1174: end loop;
1175: hr_utility.trace('ends data from cursor c_costing_flex_segments ');
1176: /*end of sac kumar testing */
1177:

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

1171: hr_utility.trace('data from cursor c_costing_flex_segments stored in ltr_costing_segment PL/SQL table');
1172: for i_sackumar in ltr_costing_segment.first .. ltr_costing_segment.last LOOP
1173: hr_utility.trace(ltr_costing_segment(i_sackumar).segment_label||'='||ltr_costing_segment(i_sackumar).column_name);
1174: end loop;
1175: hr_utility.trace('ends data from cursor c_costing_flex_segments ');
1176: /*end of sac kumar testing */
1177:
1178: END IF;
1179: CLOSE c_costing_flex_id;

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

1198: OPEN c_get_consolidation_set_name(p_consolidation_set_id);
1199: FETCH c_get_consolidation_set_name into lv_consolidation_set_name;
1200: CLOSE c_get_consolidation_set_name;
1201:
1202: hr_utility.set_location(gv_package_name || '.costing_summary', 30);
1203:
1204: lv_include_accruals:= nvl(hr_general.decode_lookup('PAY_PAYRPCBR',p_cost_type),' ');
1205: IF p_output_file_type='HTML' AND lv_include_accruals = ' ' THEN
1206: lv_include_accruals:=' ';

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

1206: lv_include_accruals:=' ';
1207: END IF;
1208:
1209: IF p_costing IS not NULL THEN
1210: hr_utility.trace('to_NUMBER(p_costing)='||to_NUMBER(p_costing));
1211: OPEN c_get_effective_date(to_NUMBER(p_costing));
1212: FETCH c_get_effective_date into lv_start_date;
1213: CLOSE c_get_effective_date;
1214: lv_end_date := lv_start_date;

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

1218: lv_end_date :=to_date(p_end_date, 'YYYY/MM/DD HH24:MI:SS');
1219: lv_costing_process_flag:='N';
1220: END IF;
1221:
1222: hr_utility.set_location(gv_package_name || '.costing_summary', 40);
1223:
1224: formated_title_page(p_output_file_type=> p_output_file_type
1225: ,p_business_group => lv_business_group_name
1226: ,p_start_date =>lv_start_date

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

1233: ,p_sort_order1 =>p_sort_order1
1234: ,p_sort_order2 =>p_sort_order2
1235: );
1236:
1237: hr_utility.set_location(gv_package_name || '.costing_summary', 50);
1238:
1239: /****************************************************************
1240: ** Print the Header Information. If the format IS HTML THEN OPEN
1241: ** the body and table before printing the header info, otherwISe

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

1254:
1255: OPEN c_get_session_id;
1256: FETCH c_get_session_id into lv_session_id;
1257: CLOSE c_get_session_id;
1258: hr_utility.trace('Sort Option 1 = ' || p_sort_order1);
1259: hr_utility.trace('Sort Option 2 = ' || p_sort_order2);
1260:
1261: /************* changed to ref cursor 3946996 */
1262:

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

1255: OPEN c_get_session_id;
1256: FETCH c_get_session_id into lv_session_id;
1257: CLOSE c_get_session_id;
1258: hr_utility.trace('Sort Option 1 = ' || p_sort_order1);
1259: hr_utility.trace('Sort Option 2 = ' || p_sort_order2);
1260:
1261: /************* changed to ref cursor 3946996 */
1262:
1263: c_clause1 :=get_optional_where_clause(p_payroll_id,

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

1266: lv_costing_process_flag,
1267: p_costing,
1268: p_cost_type);
1269:
1270: hr_utility.trace('c_clause1 = ' || c_clause1);
1271:
1272: c_query := 'SELECT
1273: pcd.payroll_name
1274: ,pcd.gre_name

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

1360: ,p_business_group_id
1361: ,p_sort_order1
1362: ,p_sort_order2;
1363:
1364: hr_utility.trace('Start Date for Query = '||lv_start_date);
1365: hr_utility.trace('End Date for Query = '||lv_end_date);
1366: hr_utility.trace('Bussiness Group for Query = '||p_business_group_id);
1367: hr_utility.trace('Short Order 1 for Query = '||p_sort_order1);
1368: hr_utility.trace('Short Order 2 for Query = '||p_sort_order2);

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

1361: ,p_sort_order1
1362: ,p_sort_order2;
1363:
1364: hr_utility.trace('Start Date for Query = '||lv_start_date);
1365: hr_utility.trace('End Date for Query = '||lv_end_date);
1366: hr_utility.trace('Bussiness Group for Query = '||p_business_group_id);
1367: hr_utility.trace('Short Order 1 for Query = '||p_sort_order1);
1368: hr_utility.trace('Short Order 2 for Query = '||p_sort_order2);
1369:

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

1362: ,p_sort_order2;
1363:
1364: hr_utility.trace('Start Date for Query = '||lv_start_date);
1365: hr_utility.trace('End Date for Query = '||lv_end_date);
1366: hr_utility.trace('Bussiness Group for Query = '||p_business_group_id);
1367: hr_utility.trace('Short Order 1 for Query = '||p_sort_order1);
1368: hr_utility.trace('Short Order 2 for Query = '||p_sort_order2);
1369:
1370: LOOP

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

1363:
1364: hr_utility.trace('Start Date for Query = '||lv_start_date);
1365: hr_utility.trace('End Date for Query = '||lv_end_date);
1366: hr_utility.trace('Bussiness Group for Query = '||p_business_group_id);
1367: hr_utility.trace('Short Order 1 for Query = '||p_sort_order1);
1368: hr_utility.trace('Short Order 2 for Query = '||p_sort_order2);
1369:
1370: LOOP
1371: FETCH c_asg_costing_details into

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

1364: hr_utility.trace('Start Date for Query = '||lv_start_date);
1365: hr_utility.trace('End Date for Query = '||lv_end_date);
1366: hr_utility.trace('Bussiness Group for Query = '||p_business_group_id);
1367: hr_utility.trace('Short Order 1 for Query = '||p_sort_order1);
1368: hr_utility.trace('Short Order 2 for Query = '||p_sort_order2);
1369:
1370: LOOP
1371: FETCH c_asg_costing_details into
1372: lv_payroll_name

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

1408: ,lv_segment29
1409: ,lv_segment30;
1410:
1411: IF c_asg_costing_details%notfound THEN
1412: hr_utility.set_location(gv_package_name || '.costing_summary', 60);
1413: exit;
1414: END IF;
1415:
1416: hr_utility.trace('Record No (After Main Query) - '||c_asg_costing_details%rowcount);

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

1412: hr_utility.set_location(gv_package_name || '.costing_summary', 60);
1413: exit;
1414: END IF;
1415:
1416: hr_utility.trace('Record No (After Main Query) - '||c_asg_costing_details%rowcount);
1417:
1418: lv_accrual_type:=nvl(hr_general.decode_lookup('PAY_PAYRPCBR',lv_cost_mode),' ');
1419: IF p_output_file_type='HTML' AND lv_accrual_type = ' ' THEN
1420: lv_accrual_type:=' ';

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

1476: ,lv_concatenated_segments --attribute33
1477: ,lv_uom --attribute34
1478: );
1479:
1480: hr_utility.set_location(gv_package_name || '.costing_summary', 70);
1481:
1482:
1483: formated_data_row(p_payroll_name => lv_payroll_name
1484: ,p_gre_name => lv_gre_name

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

1490: ,p_output_file_type=> p_output_file_type
1491: ,p_static_data1 => lv_data_row1
1492: ,p_static_data2 => lv_data_row2
1493: ) ;
1494: hr_utility.set_location(gv_package_name || '.costing_summary', 80);
1495: hr_utility.trace('lv_data_row1 = ' || lv_data_row1);
1496: hr_utility.trace('lv_data_row2 = ' || lv_data_row2);
1497:
1498:

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

1491: ,p_static_data1 => lv_data_row1
1492: ,p_static_data2 => lv_data_row2
1493: ) ;
1494: hr_utility.set_location(gv_package_name || '.costing_summary', 80);
1495: hr_utility.trace('lv_data_row1 = ' || lv_data_row1);
1496: hr_utility.trace('lv_data_row2 = ' || lv_data_row2);
1497:
1498:
1499: lv_data_row:= lv_data_row1;

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

1492: ,p_static_data2 => lv_data_row2
1493: ) ;
1494: hr_utility.set_location(gv_package_name || '.costing_summary', 80);
1495: hr_utility.trace('lv_data_row1 = ' || lv_data_row1);
1496: hr_utility.trace('lv_data_row2 = ' || lv_data_row2);
1497:
1498:
1499: lv_data_row:= lv_data_row1;
1500:

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

1570: END LOOP ;
1571:
1572: lv_data_row:=lv_data_row||lv_data_row2;
1573:
1574: hr_utility.trace('lv_data_row = ' || lv_data_row);
1575:
1576: IF p_output_file_type ='HTML' THEN
1577: lv_data_row := '' || lv_data_row || '' ;
1578: END IF;

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

1616: formated_totals_header(p_sort_order1,p_output_file_type,lv_header_label1,lv_header_label2);
1617: lv_header_label1:=lv_header_label1 || lv_cost_flex_header;
1618: lv_header_label2:=lv_header_label1 || lv_header_label2;
1619:
1620: hr_utility.set_location(gv_package_name || '.costing_summary', 90);
1621:
1622: FND_FILE.PUT_LINE(fnd_file.output, lv_header_label2);
1623:
1624:

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

1664: ,lv_segment28
1665: ,lv_segment29
1666: ,lv_segment30;
1667: IF c_costing_summary_rpt_details%notfound THEN
1668: hr_utility.set_location(gv_package_name || '.costing_summary', 100);
1669: exit;
1670: END IF;
1671:
1672: formated_totals(p_gre_or_payroll => lv_gre_or_payroll

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

1752: END LOOP ;
1753:
1754: lv_data_row:=lv_data_row||lv_data_row2;
1755:
1756: hr_utility.trace('lv_data_row = ' || lv_data_row);
1757:
1758: IF p_output_file_type ='HTML' THEN
1759: lv_data_row := '' || lv_data_row || '' ;
1760: END IF;

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

1788: END IF;
1789:
1790:
1791: formated_cons_totals_header1(p_sort_order1,p_output_file_type,lv_header_label);
1792: hr_utility.set_location(gv_package_name || '.costing_summary', 110);
1793:
1794: FND_FILE.PUT_LINE(fnd_file.output, lv_header_label);
1795:
1796: OPEN c_get_gre_or_payroll_totals (lv_session_id

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

1804: ,lv_uom
1805: ,ln_credit_amount
1806: ,ln_debit_amount;
1807: IF c_get_gre_or_payroll_totals%notfound THEN
1808: hr_utility.set_location(gv_package_name || '.costing_summary', 90);
1809: exit;
1810: END IF;
1811:
1812: formated_cons_totals1(p_gre_or_payroll => lv_gre_or_payroll

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

1816: ,p_output_file_type => p_output_file_type
1817: ,p_static_data => lv_data_row
1818: );
1819:
1820: hr_utility.trace('lv_data_row = ' || lv_data_row);
1821: IF p_output_file_type ='HTML' THEN
1822: lv_data_row := '' || lv_data_row || '' ;
1823: END IF;
1824:

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

1894: lv_credit_sum:= lv_credit_sum + ln_credit_amount;
1895: lv_debit_sum:= lv_debit_sum + ln_debit_amount;
1896:
1897: IF c_costing_grand_totals%notfound THEN
1898: hr_utility.set_location(gv_package_name || '.costing_summary', 120);
1899: exit;
1900: END IF;
1901:
1902: formated_grand_totals(p_uom => lv_uom

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

1979:
1980: END LOOP ;
1981:
1982: lv_data_row:=lv_data_row||lv_data_row1;
1983: hr_utility.trace('lv_data_row = ' || lv_data_row);
1984: IF p_output_file_type ='HTML' THEN
1985: lv_data_row := '' || lv_data_row || '' ;
1986: END IF;
1987:

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

2011: ,p_bold=>'N'));
2012: END IF;
2013:
2014: formated_cons_totals_header2(p_output_file_type,lv_header_label);
2015: hr_utility.set_location(gv_package_name || '.costing_summary', 140);
2016:
2017: FND_FILE.PUT_LINE(fnd_file.output, lv_header_label);
2018:
2019:

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

2023: lv_uom
2024: ,lv_credit_sum
2025: ,lv_debit_sum;
2026: IF c_get_report_totals%notfound THEN
2027: hr_utility.set_location(gv_package_name || '.costing_summary', 150);
2028: exit;
2029: END IF;
2030:
2031: formated_cons_totals2 (p_uom => lv_uom

Line 2038: hr_utility.trace(lv_data_row);

2034: ,p_output_file_type => p_output_file_type
2035: ,p_static_data => lv_data_row
2036: );
2037:
2038: hr_utility.trace(lv_data_row);
2039:
2040: IF p_output_file_type ='HTML' THEN
2041: lv_data_row := '' || lv_data_row || '' ;
2042: END IF;

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

2050: END LOOP;
2051: CLOSE c_get_report_totals;
2052:
2053: DELETE FROM pay_us_rpt_totals where attribute31='CSR';
2054: hr_utility.trace('Concurrent Request ID = ' || FND_GLOBAL.CONC_REQUEST_ID);
2055: END costing_summary;
2056: --begin
2057: --hr_utility.trace_on(null, 'COSTING');
2058: END pay_costing_summary_rep_pkg;

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

2053: DELETE FROM pay_us_rpt_totals where attribute31='CSR';
2054: hr_utility.trace('Concurrent Request ID = ' || FND_GLOBAL.CONC_REQUEST_ID);
2055: END costing_summary;
2056: --begin
2057: --hr_utility.trace_on(null, 'COSTING');
2058: END pay_costing_summary_rep_pkg;