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

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

194: --
195: OPEN c_costing_flex_id (p_business_group_id);
196: FETCH c_costing_flex_id INTO ln_costing_id_flex_num;
197: IF c_costing_flex_id%found THEN
198: hr_utility.set_location(gv_package_name || '.costing_summary', 20);
199: OPEN c_costing_flex_segments (ln_costing_id_flex_num);
200: LOOP
201: FETCH c_costing_flex_segments INTO lv_segment_name, lv_column_name;
202: IF c_costing_flex_segments%NOTFOUND THEN

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

514: --
515: BEGIN
516: --
517: gv_package_name :='pay_costing_summary_x_rep_pkg';
518: hr_utility.set_location(gv_package_name || '.costing_summary', 10);
519: hr_utility.trace('Start Date = ' || p_start_date);
520: hr_utility.trace('End Date = ' || p_END_date);
521: hr_utility.trace('Business Group ID = '|| p_business_group_id);
522: hr_utility.trace('Costing Process = ' || p_costing);

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

515: BEGIN
516: --
517: gv_package_name :='pay_costing_summary_x_rep_pkg';
518: hr_utility.set_location(gv_package_name || '.costing_summary', 10);
519: hr_utility.trace('Start Date = ' || p_start_date);
520: hr_utility.trace('End Date = ' || p_END_date);
521: hr_utility.trace('Business Group ID = '|| p_business_group_id);
522: hr_utility.trace('Costing Process = ' || p_costing);
523: hr_utility.trace('Payroll ID = ' || p_payroll_id);

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

516: --
517: gv_package_name :='pay_costing_summary_x_rep_pkg';
518: hr_utility.set_location(gv_package_name || '.costing_summary', 10);
519: hr_utility.trace('Start Date = ' || p_start_date);
520: hr_utility.trace('End Date = ' || p_END_date);
521: hr_utility.trace('Business Group ID = '|| p_business_group_id);
522: hr_utility.trace('Costing Process = ' || p_costing);
523: hr_utility.trace('Payroll ID = ' || p_payroll_id);
524: hr_utility.trace('Consolidation Set ID = ' || p_consolidation_set_id);

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

517: gv_package_name :='pay_costing_summary_x_rep_pkg';
518: hr_utility.set_location(gv_package_name || '.costing_summary', 10);
519: hr_utility.trace('Start Date = ' || p_start_date);
520: hr_utility.trace('End Date = ' || p_END_date);
521: hr_utility.trace('Business Group ID = '|| p_business_group_id);
522: hr_utility.trace('Costing Process = ' || p_costing);
523: hr_utility.trace('Payroll ID = ' || p_payroll_id);
524: hr_utility.trace('Consolidation Set ID = ' || p_consolidation_set_id);
525: hr_utility.trace('Tax unit ID = ' || p_tax_unit_id);

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

518: hr_utility.set_location(gv_package_name || '.costing_summary', 10);
519: hr_utility.trace('Start Date = ' || p_start_date);
520: hr_utility.trace('End Date = ' || p_END_date);
521: hr_utility.trace('Business Group ID = '|| p_business_group_id);
522: hr_utility.trace('Costing Process = ' || p_costing);
523: hr_utility.trace('Payroll ID = ' || p_payroll_id);
524: hr_utility.trace('Consolidation Set ID = ' || p_consolidation_set_id);
525: hr_utility.trace('Tax unit ID = ' || p_tax_unit_id);
526: hr_utility.trace('Cost Type = ' || p_cost_type);

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

519: hr_utility.trace('Start Date = ' || p_start_date);
520: hr_utility.trace('End Date = ' || p_END_date);
521: hr_utility.trace('Business Group ID = '|| p_business_group_id);
522: hr_utility.trace('Costing Process = ' || p_costing);
523: hr_utility.trace('Payroll ID = ' || p_payroll_id);
524: hr_utility.trace('Consolidation Set ID = ' || p_consolidation_set_id);
525: hr_utility.trace('Tax unit ID = ' || p_tax_unit_id);
526: hr_utility.trace('Cost Type = ' || p_cost_type);
527: hr_utility.trace('Sort Order 1 = ' || p_sort_order1);

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

520: hr_utility.trace('End Date = ' || p_END_date);
521: hr_utility.trace('Business Group ID = '|| p_business_group_id);
522: hr_utility.trace('Costing Process = ' || p_costing);
523: hr_utility.trace('Payroll ID = ' || p_payroll_id);
524: hr_utility.trace('Consolidation Set ID = ' || p_consolidation_set_id);
525: hr_utility.trace('Tax unit ID = ' || p_tax_unit_id);
526: hr_utility.trace('Cost Type = ' || p_cost_type);
527: hr_utility.trace('Sort Order 1 = ' || p_sort_order1);
528: hr_utility.trace('Sort Order 2 = ' || p_sort_order2);

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

521: hr_utility.trace('Business Group ID = '|| p_business_group_id);
522: hr_utility.trace('Costing Process = ' || p_costing);
523: hr_utility.trace('Payroll ID = ' || p_payroll_id);
524: hr_utility.trace('Consolidation Set ID = ' || p_consolidation_set_id);
525: hr_utility.trace('Tax unit ID = ' || p_tax_unit_id);
526: hr_utility.trace('Cost Type = ' || p_cost_type);
527: hr_utility.trace('Sort Order 1 = ' || p_sort_order1);
528: hr_utility.trace('Sort Order 2 = ' || p_sort_order2);
529:

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

522: hr_utility.trace('Costing Process = ' || p_costing);
523: hr_utility.trace('Payroll ID = ' || p_payroll_id);
524: hr_utility.trace('Consolidation Set ID = ' || p_consolidation_set_id);
525: hr_utility.trace('Tax unit ID = ' || p_tax_unit_id);
526: hr_utility.trace('Cost Type = ' || p_cost_type);
527: hr_utility.trace('Sort Order 1 = ' || p_sort_order1);
528: hr_utility.trace('Sort Order 2 = ' || p_sort_order2);
529:
530: lv_costing_process_flag := 'N';

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

523: hr_utility.trace('Payroll ID = ' || p_payroll_id);
524: hr_utility.trace('Consolidation Set ID = ' || p_consolidation_set_id);
525: hr_utility.trace('Tax unit ID = ' || p_tax_unit_id);
526: hr_utility.trace('Cost Type = ' || p_cost_type);
527: hr_utility.trace('Sort Order 1 = ' || p_sort_order1);
528: hr_utility.trace('Sort Order 2 = ' || p_sort_order2);
529:
530: lv_costing_process_flag := 'N';
531: --Clearing the PL/SQL table of package pay_prl_xml_utils

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

524: hr_utility.trace('Consolidation Set ID = ' || p_consolidation_set_id);
525: hr_utility.trace('Tax unit ID = ' || p_tax_unit_id);
526: hr_utility.trace('Cost Type = ' || p_cost_type);
527: hr_utility.trace('Sort Order 1 = ' || p_sort_order1);
528: hr_utility.trace('Sort Order 2 = ' || p_sort_order2);
529:
530: lv_costing_process_flag := 'N';
531: --Clearing the PL/SQL table of package pay_prl_xml_utils
532: pay_prl_xml_utils.gXMLTable.DELETE;

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

563: OPEN c_get_consolidation_set_name(p_consolidation_set_id);
564: FETCH c_get_consolidation_set_name INTO lv_consolidation_set_name;
565: CLOSE c_get_consolidation_set_name;
566:
567: hr_utility.set_location(gv_package_name || '.costing_summary', 30);
568:
569: lv_include_accruals:= nvl(hr_general.decode_lookup('PAY_PAYRPCBR',
570: p_cost_type),' ');
571:

Line 578: hr_utility.trace('lv_start_date'|| lv_start_date);

574: FETCH c_get_effective_date INTO lv_start_date;
575: CLOSE c_get_effective_date;
576: lv_END_date := lv_start_date;
577: lv_costing_process_flag:='Y';
578: hr_utility.trace('lv_start_date'|| lv_start_date);
579: ELSE
580: lv_start_date:=to_date(p_start_date, 'YYYY/MM/DD HH24:MI:SS');
581: lv_END_date:=to_date(p_END_date, 'YYYY/MM/DD HH24:MI:SS');
582: lv_costing_process_flag:='N';

Line 700: hr_utility.trace('Query is : '||c_query );

696: pcd.gre_name)
697: ,decode(upper(:cp_sort_order2), ''GRE'', pcd.gre_name,
698: ''PAYROLL NAME'',
699: pcd.payroll_name,''X'')';
700: hr_utility.trace('Query is : '||c_query );
701: --
702: --Opening the REFCURSOR for getting and populating into the XML variable.
703: OPEN c_asg_costing_details
704: FOR c_query USING TO_DATE(NVL(p_start_date,'0001/01/01 00:00:00'), 'YYYY/MM/DD HH24:MI:SS')

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

736: ,lv_segment18
737: ,lv_segment19
738: ,lv_segment20 ;
739: IF c_asg_costing_details%NOTFOUND THEN
740: hr_utility.set_location(gv_package_name || '.costing_summary', 60);
741:
742: --If no data is returned from the cursor then need to populate the
743: --XML data with no values.
744: IF(l_nodata_flag = TRUE) THEN

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

823: ,lv_segment20
824: ,lv_concatenated_segments
825: ,lv_uom);
826:
827: hr_utility.set_location(gv_package_name || '.costing_summary', 70);
828:
829: --Filling the data along with the XML tags into the local XML
830: --data variable.
831: l_tag := '';

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

961: ,lv_segment18
962: ,lv_segment19
963: ,lv_segment20;
964: IF c_costing_summary_rpt_details % NOTFOUND THEN
965: hr_utility.set_location(gv_package_name || '.costing_summary', 100);
966:
967: --If no data is returned from the cursor then need to populate the
968: --XML data with no values.
969: IF(l_nodata_flag = TRUE) THEN

Line 1119: hr_utility.set_location(gv_package_name ||

1115: ,lv_uom
1116: ,ln_credit_amount
1117: ,ln_debit_amount;
1118: IF c_get_gre_or_payroll_totals%NOTFOUND THEN
1119: hr_utility.set_location(gv_package_name ||
1120: '.costing_summary', 90);
1121:
1122: --If no data is returned from the cursor then need to populate the
1123: --XML data with no values.

Line 1229: hr_utility.set_location(gv_package_name ||

1225: lv_credit_sum:= lv_credit_sum + ln_credit_amount;
1226: lv_debit_sum:= lv_debit_sum + ln_debit_amount;
1227:
1228: IF c_costing_grand_totals%NOTFOUND THEN
1229: hr_utility.set_location(gv_package_name ||
1230: '.costing_summary', 120);
1231:
1232: IF (l_nodata_flag = TRUE)THEN
1233: lv_tagged_parameters := lv_tagged_parameters||

Line 1353: hr_utility.trace('Session id : '||lv_session_id);

1349:
1350: l_tag := '';
1351: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);
1352:
1353: hr_utility.trace('Session id : '||lv_session_id);
1354: OPEN c_get_report_totals(lv_session_id,p_business_group_id,'CSR');
1355: LOOP
1356: FETCH c_get_report_totals INTO
1357: lv_uom

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

1358: ,lv_credit_sum
1359: ,lv_debit_sum;
1360:
1361: IF c_get_report_totals%NOTFOUND THEN
1362: hr_utility.set_location(gv_package_name || '.costing_summary', 150);
1363: IF (l_nodata_flag = TRUE) THEN
1364: lv_tagged_parameters := lv_tagged_parameters||
1365: pay_prl_xml_utils.getTag(
1366: 'C_G_REPORT_TOTAL_NODATA',