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

628: --
629: BEGIN
630: --
631: gv_package_name :='pay_costing_summary_x_rep_pkg';
632: hr_utility.set_location(gv_package_name || '.costing_summary', 10);
633: hr_utility.trace('Start Date = ' || p_start_date);
634: hr_utility.trace('End Date = ' || p_END_date);
635: hr_utility.trace('Business Group ID = '|| p_business_group_id);
636: hr_utility.trace('Costing Process = ' || p_costing);

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

629: BEGIN
630: --
631: gv_package_name :='pay_costing_summary_x_rep_pkg';
632: hr_utility.set_location(gv_package_name || '.costing_summary', 10);
633: hr_utility.trace('Start Date = ' || p_start_date);
634: hr_utility.trace('End Date = ' || p_END_date);
635: hr_utility.trace('Business Group ID = '|| p_business_group_id);
636: hr_utility.trace('Costing Process = ' || p_costing);
637: hr_utility.trace('Payroll ID = ' || p_payroll_id);

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

630: --
631: gv_package_name :='pay_costing_summary_x_rep_pkg';
632: hr_utility.set_location(gv_package_name || '.costing_summary', 10);
633: hr_utility.trace('Start Date = ' || p_start_date);
634: hr_utility.trace('End Date = ' || p_END_date);
635: hr_utility.trace('Business Group ID = '|| p_business_group_id);
636: hr_utility.trace('Costing Process = ' || p_costing);
637: hr_utility.trace('Payroll ID = ' || p_payroll_id);
638: hr_utility.trace('Consolidation Set ID = ' || p_consolidation_set_id);

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

631: gv_package_name :='pay_costing_summary_x_rep_pkg';
632: hr_utility.set_location(gv_package_name || '.costing_summary', 10);
633: hr_utility.trace('Start Date = ' || p_start_date);
634: hr_utility.trace('End Date = ' || p_END_date);
635: hr_utility.trace('Business Group ID = '|| p_business_group_id);
636: hr_utility.trace('Costing Process = ' || p_costing);
637: hr_utility.trace('Payroll ID = ' || p_payroll_id);
638: hr_utility.trace('Consolidation Set ID = ' || p_consolidation_set_id);
639: hr_utility.trace('Tax unit ID = ' || p_tax_unit_id);

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

632: hr_utility.set_location(gv_package_name || '.costing_summary', 10);
633: hr_utility.trace('Start Date = ' || p_start_date);
634: hr_utility.trace('End Date = ' || p_END_date);
635: hr_utility.trace('Business Group ID = '|| p_business_group_id);
636: hr_utility.trace('Costing Process = ' || p_costing);
637: hr_utility.trace('Payroll ID = ' || p_payroll_id);
638: hr_utility.trace('Consolidation Set ID = ' || p_consolidation_set_id);
639: hr_utility.trace('Tax unit ID = ' || p_tax_unit_id);
640: hr_utility.trace('Cost Type = ' || p_cost_type);

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

633: hr_utility.trace('Start Date = ' || p_start_date);
634: hr_utility.trace('End Date = ' || p_END_date);
635: hr_utility.trace('Business Group ID = '|| p_business_group_id);
636: hr_utility.trace('Costing Process = ' || p_costing);
637: hr_utility.trace('Payroll ID = ' || p_payroll_id);
638: hr_utility.trace('Consolidation Set ID = ' || p_consolidation_set_id);
639: hr_utility.trace('Tax unit ID = ' || p_tax_unit_id);
640: hr_utility.trace('Cost Type = ' || p_cost_type);
641: hr_utility.trace('Sort Order 1 = ' || p_sort_order1);

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

634: hr_utility.trace('End Date = ' || p_END_date);
635: hr_utility.trace('Business Group ID = '|| p_business_group_id);
636: hr_utility.trace('Costing Process = ' || p_costing);
637: hr_utility.trace('Payroll ID = ' || p_payroll_id);
638: hr_utility.trace('Consolidation Set ID = ' || p_consolidation_set_id);
639: hr_utility.trace('Tax unit ID = ' || p_tax_unit_id);
640: hr_utility.trace('Cost Type = ' || p_cost_type);
641: hr_utility.trace('Sort Order 1 = ' || p_sort_order1);
642: hr_utility.trace('Sort Order 2 = ' || p_sort_order2);

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

635: hr_utility.trace('Business Group ID = '|| p_business_group_id);
636: hr_utility.trace('Costing Process = ' || p_costing);
637: hr_utility.trace('Payroll ID = ' || p_payroll_id);
638: hr_utility.trace('Consolidation Set ID = ' || p_consolidation_set_id);
639: hr_utility.trace('Tax unit ID = ' || p_tax_unit_id);
640: hr_utility.trace('Cost Type = ' || p_cost_type);
641: hr_utility.trace('Sort Order 1 = ' || p_sort_order1);
642: hr_utility.trace('Sort Order 2 = ' || p_sort_order2);
643:

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

636: hr_utility.trace('Costing Process = ' || p_costing);
637: hr_utility.trace('Payroll ID = ' || p_payroll_id);
638: hr_utility.trace('Consolidation Set ID = ' || p_consolidation_set_id);
639: hr_utility.trace('Tax unit ID = ' || p_tax_unit_id);
640: hr_utility.trace('Cost Type = ' || p_cost_type);
641: hr_utility.trace('Sort Order 1 = ' || p_sort_order1);
642: hr_utility.trace('Sort Order 2 = ' || p_sort_order2);
643:
644: lv_costing_process_flag := 'N';

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

637: hr_utility.trace('Payroll ID = ' || p_payroll_id);
638: hr_utility.trace('Consolidation Set ID = ' || p_consolidation_set_id);
639: hr_utility.trace('Tax unit ID = ' || p_tax_unit_id);
640: hr_utility.trace('Cost Type = ' || p_cost_type);
641: hr_utility.trace('Sort Order 1 = ' || p_sort_order1);
642: hr_utility.trace('Sort Order 2 = ' || p_sort_order2);
643:
644: lv_costing_process_flag := 'N';
645: --Clearing the PL/SQL table of package pay_prl_xml_utils

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

638: hr_utility.trace('Consolidation Set ID = ' || p_consolidation_set_id);
639: hr_utility.trace('Tax unit ID = ' || p_tax_unit_id);
640: hr_utility.trace('Cost Type = ' || p_cost_type);
641: hr_utility.trace('Sort Order 1 = ' || p_sort_order1);
642: hr_utility.trace('Sort Order 2 = ' || p_sort_order2);
643:
644: lv_costing_process_flag := 'N';
645: --Clearing the PL/SQL table of package pay_prl_xml_utils
646: pay_prl_xml_utils.gXMLTable.DELETE;

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

677: OPEN c_get_consolidation_set_name(p_consolidation_set_id);
678: FETCH c_get_consolidation_set_name INTO lv_consolidation_set_name;
679: CLOSE c_get_consolidation_set_name;
680:
681: hr_utility.set_location(gv_package_name || '.costing_summary', 30);
682:
683: lv_include_accruals:= nvl(hr_general.decode_lookup('PAY_PAYRPCBR',
684: p_cost_type),' ');
685:

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

688: FETCH c_get_effective_date INTO lv_start_date;
689: CLOSE c_get_effective_date;
690: lv_END_date := lv_start_date;
691: lv_costing_process_flag:='Y';
692: hr_utility.trace('lv_start_date'|| lv_start_date);
693: ELSE
694: lv_start_date:=to_date(p_start_date, 'YYYY/MM/DD HH24:MI:SS');
695: lv_END_date:=to_date(p_END_date, 'YYYY/MM/DD HH24:MI:SS');
696: lv_costing_process_flag:='N';

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

858: ,pcd.segment27
859: ,pcd.segment28
860: ,pcd.segment29
861: ,pcd.segment30';
862: hr_utility.trace('Query is : '||c_query );
863: --
864: --Opening the REFCURSOR for getting and populating into the XML variable.
865: OPEN c_asg_costing_details
866: FOR c_query USING TO_DATE(NVL(p_start_date,'0001/01/01 00:00:00'), 'YYYY/MM/DD HH24:MI:SS')

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

909: ,lv_segment29
910: ,lv_segment30;
911:
912: IF c_asg_costing_details%NOTFOUND THEN
913: hr_utility.set_location(gv_package_name || '.costing_summary', 60);
914:
915: --If no data is returned from the cursor then need to populate the
916: --XML data with no values.
917: IF(l_nodata_flag = TRUE) THEN

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

1007: ,lv_uom --attribute34
1008: );
1009:
1010:
1011: hr_utility.set_location(gv_package_name || '.costing_summary', 70);
1012:
1013: --Filling the data along with the XML tags into the local XML
1014: --data variable.
1015: l_tag := '';

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

1175: ,lv_segment28
1176: ,lv_segment29
1177: ,lv_segment30;
1178: IF c_costing_summary_rpt_details % NOTFOUND THEN
1179: hr_utility.set_location(gv_package_name || '.costing_summary', 100);
1180:
1181: --If no data is returned from the cursor then need to populate the
1182: --XML data with no values.
1183: IF(l_nodata_flag = TRUE) THEN

Line 1353: hr_utility.set_location(gv_package_name ||

1349: ,lv_uom
1350: ,ln_credit_amount
1351: ,ln_debit_amount;
1352: IF c_get_gre_or_payroll_totals%NOTFOUND THEN
1353: hr_utility.set_location(gv_package_name ||
1354: '.costing_summary', 90);
1355:
1356: --If no data is returned from the cursor then need to populate the
1357: --XML data with no values.

Line 1473: hr_utility.set_location(gv_package_name ||

1469: lv_credit_sum:= lv_credit_sum + ln_credit_amount;
1470: lv_debit_sum:= lv_debit_sum + ln_debit_amount;
1471:
1472: IF c_costing_grand_totals%NOTFOUND THEN
1473: hr_utility.set_location(gv_package_name ||
1474: '.costing_summary', 120);
1475:
1476: IF (l_nodata_flag = TRUE)THEN
1477: lv_tagged_parameters := lv_tagged_parameters||

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

1613:
1614: l_tag := '';
1615: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);
1616:
1617: hr_utility.trace('Session id : '||lv_session_id);
1618: OPEN c_get_report_totals(lv_session_id,p_business_group_id,'CSR');
1619: LOOP
1620: FETCH c_get_report_totals INTO
1621: lv_uom

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

1622: ,lv_credit_sum
1623: ,lv_debit_sum;
1624:
1625: IF c_get_report_totals%NOTFOUND THEN
1626: hr_utility.set_location(gv_package_name || '.costing_summary', 150);
1627: IF (l_nodata_flag = TRUE) THEN
1628: lv_tagged_parameters := lv_tagged_parameters||
1629: pay_prl_xml_utils.getTag(
1630: 'C_G_REPORT_TOTAL_NODATA',