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

Line 125: Purpose : Log a message, either using fnd_file, or hr_utility.trace

121: g_debug_flag VARCHAR2(1) ;
122:
123: /*****************************************************************************
124: Name : msg
125: Purpose : Log a message, either using fnd_file, or hr_utility.trace
126: *****************************************************************************/
127:
128: PROCEDURE msg(p_text VARCHAR2)
129: IS

Line 139: Purpose : Log a message, either using fnd_file, or hr_utility.trace

135: END msg;
136:
137: /*****************************************************************************
138: Name : dbg
139: Purpose : Log a message, either using fnd_file, or hr_utility.trace
140: IF debuggging is enabled
141: *****************************************************************************/
142: PROCEDURE dbg(p_text VARCHAR2) IS
143:

Line 156: hr_utility.trace(p_text);

152:
153: ELSE
154:
155: -- Use HR trace
156: hr_utility.trace(p_text);
157:
158: END IF;
159:
160: END IF;

Line 784: hr_utility.set_location(g_package || l_procedure_name, 10);

780: END IF;
781:
782: dbg('Get the Defined balance Ids');
783: l_step := 1;
784: hr_utility.set_location(g_package || l_procedure_name, 10);
785:
786: -- Get the defined balance Id for Gross Earnings AND GRE_PYDATE
787:
788: l_gross_ctd_def_bal_id := fetch_define_bal ('Gross Earnings',

Line 793: hr_utility.set_location(g_package || l_procedure_name, 20);

789: l_database_suffix );
790:
791: dbg('Gross Earnings '|| l_database_suffix || ' : '||l_gross_ctd_def_bal_id);
792: l_step := 2;
793: hr_utility.set_location(g_package || l_procedure_name, 20);
794:
795: -- Get the defined balance Id for Gross Earnings AND dimension
796:
797: l_gross_dtd_def_bal_id := NULL ;

Line 813: hr_utility.set_location(g_package || l_procedure_name, 30);

809:
810: IF p_show_isr = 'Y' THEN
811:
812: l_step := 3;
813: hr_utility.set_location(g_package || l_procedure_name, 30);
814:
815: -- Get defined balance Id for ISR WIthheld AND ISR Subject
816:
817: l_isr_withheld_ctd_def_bal_id := fetch_define_bal ('ISR Withheld',

Line 829: hr_utility.set_location(g_package || l_procedure_name, 40);

825:
826: IF l_dim_database_item_suffix is not null THEN
827:
828: l_step := 4;
829: hr_utility.set_location(g_package || l_procedure_name, 40);
830:
831: l_isr_withheld_dtd_def_bal_id := fetch_define_bal ('ISR Withheld',
832: l_dim_database_item_suffix );
833: l_isr_subj_dtd_def_bal_id := fetch_define_bal ('ISR Subject',

Line 855: hr_utility.set_location(g_package || l_procedure_name, 50);

851: -- Get defined balance Id for Social Security Quota EE
852: -- AND Social Security Quota ER
853:
854: l_step := 5;
855: hr_utility.set_location(g_package || l_procedure_name, 50);
856:
857: l_ss_ee_ctd_def_bal_id := fetch_define_bal ('Social Security Quota EE',
858: l_database_suffix );
859: l_ss_er_ctd_def_bal_id := fetch_define_bal ('Social Security Quota ER',

Line 867: hr_utility.set_location(g_package || l_procedure_name, 60);

863: l_ss_er_dtd_def_bal_id := NULL;
864:
865: IF l_dim_database_item_suffix is not null THEN
866: l_step := 6;
867: hr_utility.set_location(g_package || l_procedure_name, 60);
868:
869: l_ss_ee_dtd_def_bal_id := fetch_define_bal('Social Security Quota EE'
870: ,l_dim_database_item_suffix );
871: l_ss_er_dtd_def_bal_id := fetch_define_bal('Social Security Quota ER'

Line 887: hr_utility.set_location(g_package || l_procedure_name, 70);

883:
884:
885: dbg('Get Social Security Insurance Types ');
886: l_step := 7;
887: hr_utility.set_location(g_package || l_procedure_name, 70);
888:
889: -- get the social security ins types
890:
891: OPEN get_soc_sec_quota_details(p_start_date_earned);

Line 895: hr_utility.trace('IN LOOP...');

891: OPEN get_soc_sec_quota_details(p_start_date_earned);
892:
893: LOOP
894:
895: hr_utility.trace('IN LOOP...');
896:
897: FETCH get_soc_sec_quota_details INTO
898: l_bal_name, -- with EE or ER at the end
899: l_report_name, -- same as l_bal_name

Line 907: hr_utility.trace('l_prev_bal_name: ' ||nvl(l_prev_bal_name,'NULL'));

903: lv_soc_sec_tax_per_er;
904:
905: EXIT WHEN get_soc_sec_quota_details%notfound;
906:
907: hr_utility.trace('l_prev_bal_name: ' ||nvl(l_prev_bal_name,'NULL'));
908: hr_utility.trace('l_balance_name: ' ||l_balance_name);
909: hr_utility.trace('lv_soc_sec_tax_per_ee: ' ||lv_soc_sec_tax_per_ee);
910: hr_utility.trace('lv_soc_sec_tax_per_er: ' ||lv_soc_sec_tax_per_er);
911:

Line 908: hr_utility.trace('l_balance_name: ' ||l_balance_name);

904:
905: EXIT WHEN get_soc_sec_quota_details%notfound;
906:
907: hr_utility.trace('l_prev_bal_name: ' ||nvl(l_prev_bal_name,'NULL'));
908: hr_utility.trace('l_balance_name: ' ||l_balance_name);
909: hr_utility.trace('lv_soc_sec_tax_per_ee: ' ||lv_soc_sec_tax_per_ee);
910: hr_utility.trace('lv_soc_sec_tax_per_er: ' ||lv_soc_sec_tax_per_er);
911:
912: l_soc_sec_tax_per_ee :=

Line 909: hr_utility.trace('lv_soc_sec_tax_per_ee: ' ||lv_soc_sec_tax_per_ee);

905: EXIT WHEN get_soc_sec_quota_details%notfound;
906:
907: hr_utility.trace('l_prev_bal_name: ' ||nvl(l_prev_bal_name,'NULL'));
908: hr_utility.trace('l_balance_name: ' ||l_balance_name);
909: hr_utility.trace('lv_soc_sec_tax_per_ee: ' ||lv_soc_sec_tax_per_ee);
910: hr_utility.trace('lv_soc_sec_tax_per_er: ' ||lv_soc_sec_tax_per_er);
911:
912: l_soc_sec_tax_per_ee :=
913: fnd_number.canonical_to_number(lv_soc_sec_tax_per_ee);

Line 910: hr_utility.trace('lv_soc_sec_tax_per_er: ' ||lv_soc_sec_tax_per_er);

906:
907: hr_utility.trace('l_prev_bal_name: ' ||nvl(l_prev_bal_name,'NULL'));
908: hr_utility.trace('l_balance_name: ' ||l_balance_name);
909: hr_utility.trace('lv_soc_sec_tax_per_ee: ' ||lv_soc_sec_tax_per_ee);
910: hr_utility.trace('lv_soc_sec_tax_per_er: ' ||lv_soc_sec_tax_per_er);
911:
912: l_soc_sec_tax_per_ee :=
913: fnd_number.canonical_to_number(lv_soc_sec_tax_per_ee);
914:

Line 915: hr_utility.trace('l_soc_sec_tax_per_ee: ' ||l_soc_sec_tax_per_ee);

911:
912: l_soc_sec_tax_per_ee :=
913: fnd_number.canonical_to_number(lv_soc_sec_tax_per_ee);
914:
915: hr_utility.trace('l_soc_sec_tax_per_ee: ' ||l_soc_sec_tax_per_ee);
916:
917: l_soc_sec_tax_per_er :=
918: fnd_number.canonical_to_number(lv_soc_sec_tax_per_er);
919:

Line 920: hr_utility.trace('l_soc_sec_tax_per_er: ' ||l_soc_sec_tax_per_er);

916:
917: l_soc_sec_tax_per_er :=
918: fnd_number.canonical_to_number(lv_soc_sec_tax_per_er);
919:
920: hr_utility.trace('l_soc_sec_tax_per_er: ' ||l_soc_sec_tax_per_er);
921:
922: IF ( l_prev_bal_name IS NULL OR l_prev_bal_name <> l_balance_name )
923: THEN
924:

Line 927: hr_utility.trace('l_counter1: ' ||l_counter1);

923: THEN
924:
925: l_counter1:= l_counter1+ 1;
926:
927: hr_utility.trace('l_counter1: ' ||l_counter1);
928: dbg('The Counter value '||l_counter1);
929: dbg('The Balance Name '||l_balance_name);
930: dbg('The Balance Name '||l_bal_name);
931:

Line 932: hr_utility.trace('l_bal_name: ' ||l_bal_name);

928: dbg('The Counter value '||l_counter1);
929: dbg('The Balance Name '||l_balance_name);
930: dbg('The Balance Name '||l_bal_name);
931:
932: hr_utility.trace('l_bal_name: ' ||l_bal_name);
933:
934: soc_sec_det_tab(l_counter1).balance_name := l_balance_name;
935: soc_sec_det_tab(l_counter1).soc_sec_tax_pct_ee :=
936: l_soc_sec_tax_per_ee;

Line 946: hr_utility.trace('Balances are same: ');

942: END IF;
943:
944: IF l_prev_bal_name = l_balance_name THEN
945:
946: hr_utility.trace('Balances are same: ');
947: hr_utility.trace('l_bal_name: '||l_bal_name);
948: hr_utility.trace('l_database_suffix: '||l_database_suffix);
949:
950: l_ins_type_ctd_id := fetch_define_bal (l_bal_name,

Line 947: hr_utility.trace('l_bal_name: '||l_bal_name);

943:
944: IF l_prev_bal_name = l_balance_name THEN
945:
946: hr_utility.trace('Balances are same: ');
947: hr_utility.trace('l_bal_name: '||l_bal_name);
948: hr_utility.trace('l_database_suffix: '||l_database_suffix);
949:
950: l_ins_type_ctd_id := fetch_define_bal (l_bal_name,
951: l_database_suffix );

Line 948: hr_utility.trace('l_database_suffix: '||l_database_suffix);

944: IF l_prev_bal_name = l_balance_name THEN
945:
946: hr_utility.trace('Balances are same: ');
947: hr_utility.trace('l_bal_name: '||l_bal_name);
948: hr_utility.trace('l_database_suffix: '||l_database_suffix);
949:
950: l_ins_type_ctd_id := fetch_define_bal (l_bal_name,
951: l_database_suffix );
952:

Line 953: hr_utility.trace('l_ins_type_ctd_id: '||

949:
950: l_ins_type_ctd_id := fetch_define_bal (l_bal_name,
951: l_database_suffix );
952:
953: hr_utility.trace('l_ins_type_ctd_id: '||
954: l_ins_type_ctd_id);
955:
956: hr_utility.trace('l_dim_database_item_suffix: '||
957: l_dim_database_item_suffix);

Line 956: hr_utility.trace('l_dim_database_item_suffix: '||

952:
953: hr_utility.trace('l_ins_type_ctd_id: '||
954: l_ins_type_ctd_id);
955:
956: hr_utility.trace('l_dim_database_item_suffix: '||
957: l_dim_database_item_suffix);
958:
959: IF l_dim_database_item_suffix IS NOT NULL THEN
960:

Line 963: hr_utility.trace('l_ins_type_dtd_id: '||

959: IF l_dim_database_item_suffix IS NOT NULL THEN
960:
961: l_ins_type_dtd_id := fetch_define_bal (l_bal_name,
962: l_dim_database_item_suffix);
963: hr_utility.trace('l_ins_type_dtd_id: '||
964: l_ins_type_dtd_id);
965: END IF;
966:
967: hr_utility.trace('l_ee_or_er: '||l_ee_or_er);

Line 967: hr_utility.trace('l_ee_or_er: '||l_ee_or_er);

963: hr_utility.trace('l_ins_type_dtd_id: '||
964: l_ins_type_dtd_id);
965: END IF;
966:
967: hr_utility.trace('l_ee_or_er: '||l_ee_or_er);
968:
969: IF l_ee_or_er ='EE' THEN
970:
971: soc_sec_det_tab(l_counter1).soc_sec_ee_ctd_id :=

Line 1005: hr_utility.set_location(g_package || l_procedure_name, 80);

1001: END LOOP;
1002:
1003: dbg('The value of the PLSQl table counter '||l_counter1);
1004: l_step := 8;
1005: hr_utility.set_location(g_package || l_procedure_name, 80);
1006:
1007: FOR m IN 1 ..soc_sec_det_tab.count LOOP
1008:
1009: dbg(soc_sec_det_tab(m).balance_name ||' '||

Line 1025: hr_utility.set_location(g_package || l_procedure_name, 85);

1021: END IF; -- p_show_soc_security
1022:
1023: IF p_show_state = 'Y' THEN
1024:
1025: hr_utility.set_location(g_package || l_procedure_name, 85);
1026:
1027: -- Get defined balance Id for Employer State Tax WIthheld AND
1028: -- Employer State Tax Subject
1029:

Line 1060: hr_utility.set_location(g_package || l_procedure_name, 90);

1056:
1057: END IF; -- p_show_state
1058:
1059: l_step := 9;
1060: hr_utility.set_location(g_package || l_procedure_name, 90);
1061:
1062: dbg('Get Legal Employer Name ');
1063:
1064: OPEN get_legal_employer_details(p_legal_employer_id);

Line 1109: hr_utility.set_location(g_package || l_procedure_name, 100);

1105:
1106: dbg('Insert parameters to plsql table ');
1107:
1108: l_step := 10;
1109: hr_utility.set_location(g_package || l_procedure_name, 100);
1110:
1111: /* insert parameter records IN pl/sql table */
1112:
1113: insert_xml_plsql_table( p_xml_data,'START_DATE_EARNED',

Line 1142: hr_utility.set_location(g_package || l_procedure_name, 110);

1138:
1139: END IF;
1140:
1141: l_step := 11;
1142: hr_utility.set_location(g_package || l_procedure_name, 110);
1143:
1144: FOR l_cnt1 IN get_states_for_legal_emp(p_business_group_id,
1145: p_legal_employer_id,
1146: p_state_code,p_gre_id)

Line 2294: hr_utility.set_location(g_package || l_procedure_name, 120);

2290:
2291: END LOOP; /* For the Outer Distinct State Loop */
2292:
2293: l_step := 12;
2294: hr_utility.set_location(g_package || l_procedure_name, 120);
2295:
2296: /* Writing the Legal Employer Level Totals into the PL/SQL data */
2297: /* Legal Employer Gross Earning Data */
2298:

Line 2390: hr_utility.set_location(g_package || l_procedure_name, 130);

2386:
2387: IF p_show_soc_security = 'Y' THEN
2388:
2389: l_step := 13;
2390: hr_utility.set_location(g_package || l_procedure_name, 130);
2391:
2392: /* Legal Employer social security Quota details */
2393:
2394: FOR m IN 1 .. le_soc_sec_det_tab.COUNT

Line 2434: hr_utility.raise_error;

2430: when others THEN
2431: l_error_message := 'Error at step ' || l_step || ' IN ' ||
2432: g_package || l_procedure_name;
2433: dbg(l_error_message || '-' || sqlerrm);
2434: hr_utility.raise_error;
2435:
2436: END populate_plsql_table ;
2437:
2438: /*****************************************************************************

Line 2527: hr_utility.set_location(g_package || l_procedure_name, 10);

2523: FROM fnd_sessions fs
2524: WHERE fs.session_id = userenv('sessionid')) ;
2525:
2526: l_step := 1;
2527: hr_utility.set_location(g_package || l_procedure_name, 10);
2528: dbg('Calling Populate plsql table');
2529:
2530: populate_plsql_table(fnd_date.canonical_to_date(p_start_date_earned) ,
2531: fnd_date.canonical_to_date(p_end_date_earned) ,

Line 2545: hr_utility.set_location(g_package || l_procedure_name, 20);

2541:
2542: dbg('After Populate PlSql table procedure');
2543:
2544: l_step := 2;
2545: hr_utility.set_location(g_package || l_procedure_name, 20);
2546:
2547: dbg('The total records IN PLsql Table is '||xml_data_table.count);
2548:
2549: FOR m IN 1 ..xml_data_table.COUNT LOOP

Line 2560: hr_utility.set_location(g_package || l_procedure_name, 30);

2556: -- Write XML header line
2557: dbg('Write XML header line');
2558:
2559: l_step := 3;
2560: hr_utility.set_location(g_package || l_procedure_name, 30);
2561:
2562: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2563:
2564: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'

Line 2568: hr_utility.set_location(g_package || l_procedure_name, 40);

2564: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' 2565: hr_mx_utility.get_IANA_charset || '"?>' ) ;
2566:
2567: l_step := 4;
2568: hr_utility.set_location(g_package || l_procedure_name, 40);
2569:
2570: -- Write XML data FROM plsql table
2571: dbg('Convert AND Write XML data IN the output file');
2572:

Line 2585: hr_utility.set_location(g_package || l_procedure_name, 50);

2581: END LOOP ;
2582:
2583:
2584: l_step := 5;
2585: hr_utility.set_location(g_package || l_procedure_name, 50);
2586:
2587: dbg('cleaning up the plsql table');
2588:
2589: xml_data_table.delete;

Line 2672: hr_utility.set_location(g_package || l_procedure_name, 10);

2668:
2669: dbg('Submitting concurrent request for Payroll Tax Remittance Report');
2670:
2671: l_step := 1;
2672: hr_utility.set_location(g_package || l_procedure_name, 10);
2673:
2674: l_program := 'PYMXTRRXML';
2675: l_req_id := Fnd_request.submit_request(
2676: application => 'PAY',

Line 2696: hr_utility.raise_error;

2692: If l_req_id = 0 THEN
2693:
2694: fnd_message.retrieve(l_errbuf);
2695: dbg('Error when submitting request: ' || SQLERRM || ' ' || SQLCODE);
2696: hr_utility.raise_error;
2697:
2698: ELSE
2699:
2700: dbg('Waiting for the First Request to get complete');

Line 2705: hr_utility.set_location(g_package || l_procedure_name, 20);

2701: COMMIT;
2702: dbg('Commited the First Request');
2703:
2704: l_step := 2;
2705: hr_utility.set_location(g_package || l_procedure_name, 20);
2706:
2707: l_wait_outcome := fnd_concurrent.WAIT_FOR_REQUEST(
2708: request_id => l_req_id,
2709: interval => 15,

Line 2735: hr_utility.set_location(g_package || l_procedure_name, 30);

2731:
2732: dbg('Submitting XML Report Publisher concurrent request');
2733:
2734: l_step := 3;
2735: hr_utility.set_location(g_package || l_procedure_name, 30);
2736:
2737: l_program := 'XDOREPPB';
2738:
2739: /* assigning the argument1 value to l_sql_arg1 */

Line 2785: hr_utility.raise_error;

2781: when others THEN
2782: l_error_message := 'Error at step ' || l_step || ' IN ' ||
2783: g_package || l_procedure_name;
2784: dbg(l_error_message || '-' || sqlerrm);
2785: hr_utility.raise_error;
2786:
2787: End trr_report_wrapper ; -- End Of Procedure TRR_Report_wrapper
2788:
2789: --begin

Line 2790: --hr_utility.trace_on (null, 'MXTRR');

2786:
2787: End trr_report_wrapper ; -- End Of Procedure TRR_Report_wrapper
2788:
2789: --begin
2790: --hr_utility.trace_on (null, 'MXTRR');
2791:
2792: END pay_mx_trr_pkg; -- End Of Package Body