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 108: Purpose : Log a message, either using fnd_file, or hr_utility.trace

104: g_debug_flag VARCHAR2(1) ;
105:
106: /*****************************************************************************
107: Name : msg
108: Purpose : Log a message, either using fnd_file, or hr_utility.trace
109: *****************************************************************************/
110:
111: PROCEDURE msg(p_text VARCHAR2)
112: IS

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

118: END msg;
119:
120: /*****************************************************************************
121: Name : dbg
122: Purpose : Log a message, either using fnd_file, or hr_utility.trace
123: IF debuggging is enabled
124: *****************************************************************************/
125: PROCEDURE dbg(p_text VARCHAR2) IS
126:

Line 139: hr_utility.trace(p_text);

135:
136: ELSE
137:
138: -- Use HR trace
139: hr_utility.trace(p_text);
140:
141: END IF;
142:
143: END IF;

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

753: END IF;
754:
755: dbg('Get the Defined balance Ids');
756: l_step := 1;
757: hr_utility.set_location(g_package || l_procedure_name, 10);
758:
759: -- Get the defined balance Id for Gross Earnings AND GRE_PYDATE
760:
761: l_gross_ctd_def_bal_id := fetch_define_bal ('Gross Earnings',

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

762: l_database_suffix );
763:
764: dbg('Gross Earnings '|| l_database_suffix || ' : '||l_gross_ctd_def_bal_id);
765: l_step := 2;
766: hr_utility.set_location(g_package || l_procedure_name, 20);
767:
768: -- Get the defined balance Id for Gross Earnings AND dimension
769:
770: l_gross_dtd_def_bal_id := NULL ;

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

782:
783: IF p_show_isr = 'Y' THEN
784:
785: l_step := 3;
786: hr_utility.set_location(g_package || l_procedure_name, 30);
787:
788: -- Get defined balance Id for ISR WIthheld AND ISR Subject
789:
790: l_isr_withheld_ctd_def_bal_id := fetch_define_bal ('ISR Withheld',

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

798:
799: IF l_dim_database_item_suffix is not null THEN
800:
801: l_step := 4;
802: hr_utility.set_location(g_package || l_procedure_name, 40);
803:
804: l_isr_withheld_dtd_def_bal_id := fetch_define_bal ('ISR Withheld',
805: l_dim_database_item_suffix );
806: l_isr_subj_dtd_def_bal_id := fetch_define_bal ('ISR Subject',

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

824: -- Get defined balance Id for Social Security Quota EE
825: -- AND Social Security Quota ER
826:
827: l_step := 5;
828: hr_utility.set_location(g_package || l_procedure_name, 50);
829:
830: l_ss_ee_ctd_def_bal_id := fetch_define_bal ('Social Security Quota EE',
831: l_database_suffix );
832: l_ss_er_ctd_def_bal_id := fetch_define_bal ('Social Security Quota ER',

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

836: l_ss_er_dtd_def_bal_id := NULL;
837:
838: IF l_dim_database_item_suffix is not null THEN
839: l_step := 6;
840: hr_utility.set_location(g_package || l_procedure_name, 60);
841:
842: l_ss_ee_dtd_def_bal_id := fetch_define_bal('Social Security Quota EE'
843: ,l_dim_database_item_suffix );
844: l_ss_er_dtd_def_bal_id := fetch_define_bal('Social Security Quota ER'

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

856:
857:
858: dbg('Get Social Security Insurance Types ');
859: l_step := 7;
860: hr_utility.set_location(g_package || l_procedure_name, 70);
861:
862: -- get the social security ins types
863:
864: OPEN get_soc_sec_quota_details(p_start_date_earned);

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

864: OPEN get_soc_sec_quota_details(p_start_date_earned);
865:
866: LOOP
867:
868: hr_utility.trace('IN LOOP...');
869:
870: FETCH get_soc_sec_quota_details INTO
871: l_bal_name, -- with EE or ER at the end
872: l_report_name, -- same as l_bal_name

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

876: lv_soc_sec_tax_per_er;
877:
878: EXIT WHEN get_soc_sec_quota_details%notfound;
879:
880: hr_utility.trace('l_prev_bal_name: ' ||nvl(l_prev_bal_name,'NULL'));
881: hr_utility.trace('l_balance_name: ' ||l_balance_name);
882: hr_utility.trace('lv_soc_sec_tax_per_ee: ' ||lv_soc_sec_tax_per_ee);
883: hr_utility.trace('lv_soc_sec_tax_per_er: ' ||lv_soc_sec_tax_per_er);
884:

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

877:
878: EXIT WHEN get_soc_sec_quota_details%notfound;
879:
880: hr_utility.trace('l_prev_bal_name: ' ||nvl(l_prev_bal_name,'NULL'));
881: hr_utility.trace('l_balance_name: ' ||l_balance_name);
882: hr_utility.trace('lv_soc_sec_tax_per_ee: ' ||lv_soc_sec_tax_per_ee);
883: hr_utility.trace('lv_soc_sec_tax_per_er: ' ||lv_soc_sec_tax_per_er);
884:
885: l_soc_sec_tax_per_ee :=

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

878: EXIT WHEN get_soc_sec_quota_details%notfound;
879:
880: hr_utility.trace('l_prev_bal_name: ' ||nvl(l_prev_bal_name,'NULL'));
881: hr_utility.trace('l_balance_name: ' ||l_balance_name);
882: hr_utility.trace('lv_soc_sec_tax_per_ee: ' ||lv_soc_sec_tax_per_ee);
883: hr_utility.trace('lv_soc_sec_tax_per_er: ' ||lv_soc_sec_tax_per_er);
884:
885: l_soc_sec_tax_per_ee :=
886: fnd_number.canonical_to_number(lv_soc_sec_tax_per_ee);

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

879:
880: hr_utility.trace('l_prev_bal_name: ' ||nvl(l_prev_bal_name,'NULL'));
881: hr_utility.trace('l_balance_name: ' ||l_balance_name);
882: hr_utility.trace('lv_soc_sec_tax_per_ee: ' ||lv_soc_sec_tax_per_ee);
883: hr_utility.trace('lv_soc_sec_tax_per_er: ' ||lv_soc_sec_tax_per_er);
884:
885: l_soc_sec_tax_per_ee :=
886: fnd_number.canonical_to_number(lv_soc_sec_tax_per_ee);
887:

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

884:
885: l_soc_sec_tax_per_ee :=
886: fnd_number.canonical_to_number(lv_soc_sec_tax_per_ee);
887:
888: hr_utility.trace('l_soc_sec_tax_per_ee: ' ||l_soc_sec_tax_per_ee);
889:
890: l_soc_sec_tax_per_er :=
891: fnd_number.canonical_to_number(lv_soc_sec_tax_per_er);
892:

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

889:
890: l_soc_sec_tax_per_er :=
891: fnd_number.canonical_to_number(lv_soc_sec_tax_per_er);
892:
893: hr_utility.trace('l_soc_sec_tax_per_er: ' ||l_soc_sec_tax_per_er);
894:
895: IF ( l_prev_bal_name IS NULL OR l_prev_bal_name <> l_balance_name )
896: THEN
897:

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

896: THEN
897:
898: l_counter1:= l_counter1+ 1;
899:
900: hr_utility.trace('l_counter1: ' ||l_counter1);
901: dbg('The Counter value '||l_counter1);
902: dbg('The Balance Name '||l_balance_name);
903: dbg('The Balance Name '||l_bal_name);
904:

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

901: dbg('The Counter value '||l_counter1);
902: dbg('The Balance Name '||l_balance_name);
903: dbg('The Balance Name '||l_bal_name);
904:
905: hr_utility.trace('l_bal_name: ' ||l_bal_name);
906:
907: soc_sec_det_tab(l_counter1).balance_name := l_balance_name;
908: soc_sec_det_tab(l_counter1).soc_sec_tax_pct_ee :=
909: l_soc_sec_tax_per_ee;

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

915: END IF;
916:
917: IF l_prev_bal_name = l_balance_name THEN
918:
919: hr_utility.trace('Balances are same: ');
920: hr_utility.trace('l_bal_name: '||l_bal_name);
921: hr_utility.trace('l_database_suffix: '||l_database_suffix);
922:
923: l_ins_type_ctd_id := fetch_define_bal (l_bal_name,

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

916:
917: IF l_prev_bal_name = l_balance_name THEN
918:
919: hr_utility.trace('Balances are same: ');
920: hr_utility.trace('l_bal_name: '||l_bal_name);
921: hr_utility.trace('l_database_suffix: '||l_database_suffix);
922:
923: l_ins_type_ctd_id := fetch_define_bal (l_bal_name,
924: l_database_suffix );

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

917: IF l_prev_bal_name = l_balance_name THEN
918:
919: hr_utility.trace('Balances are same: ');
920: hr_utility.trace('l_bal_name: '||l_bal_name);
921: hr_utility.trace('l_database_suffix: '||l_database_suffix);
922:
923: l_ins_type_ctd_id := fetch_define_bal (l_bal_name,
924: l_database_suffix );
925:

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

922:
923: l_ins_type_ctd_id := fetch_define_bal (l_bal_name,
924: l_database_suffix );
925:
926: hr_utility.trace('l_ins_type_ctd_id: '||
927: l_ins_type_ctd_id);
928:
929: hr_utility.trace('l_dim_database_item_suffix: '||
930: l_dim_database_item_suffix);

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

925:
926: hr_utility.trace('l_ins_type_ctd_id: '||
927: l_ins_type_ctd_id);
928:
929: hr_utility.trace('l_dim_database_item_suffix: '||
930: l_dim_database_item_suffix);
931:
932: IF l_dim_database_item_suffix IS NOT NULL THEN
933:

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

932: IF l_dim_database_item_suffix IS NOT NULL THEN
933:
934: l_ins_type_dtd_id := fetch_define_bal (l_bal_name,
935: l_dim_database_item_suffix);
936: hr_utility.trace('l_ins_type_dtd_id: '||
937: l_ins_type_dtd_id);
938: END IF;
939:
940: hr_utility.trace('l_ee_or_er: '||l_ee_or_er);

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

936: hr_utility.trace('l_ins_type_dtd_id: '||
937: l_ins_type_dtd_id);
938: END IF;
939:
940: hr_utility.trace('l_ee_or_er: '||l_ee_or_er);
941:
942: IF l_ee_or_er ='EE' THEN
943:
944: soc_sec_det_tab(l_counter1).soc_sec_ee_ctd_id :=

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

974: END LOOP;
975:
976: dbg('The value of the PLSQl table counter '||l_counter1);
977: l_step := 8;
978: hr_utility.set_location(g_package || l_procedure_name, 80);
979:
980: FOR m IN 1 ..soc_sec_det_tab.count LOOP
981:
982: dbg(soc_sec_det_tab(m).balance_name ||' '||

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

994: END IF; -- p_show_soc_security
995:
996: IF p_show_state = 'Y' THEN
997:
998: hr_utility.set_location(g_package || l_procedure_name, 85);
999:
1000: -- Get defined balance Id for Employer State Tax WIthheld AND
1001: -- Employer State Tax Subject
1002:

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

1029:
1030: END IF; -- p_show_state
1031:
1032: l_step := 9;
1033: hr_utility.set_location(g_package || l_procedure_name, 90);
1034:
1035: dbg('Get Legal Employer Name ');
1036:
1037: OPEN get_legal_employer_details(p_legal_employer_id);

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

1078:
1079: dbg('Insert parameters to plsql table ');
1080:
1081: l_step := 10;
1082: hr_utility.set_location(g_package || l_procedure_name, 100);
1083:
1084: /* insert parameter records IN pl/sql table */
1085:
1086: insert_xml_plsql_table( p_xml_data,'START_DATE_EARNED',

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

1111:
1112: END IF;
1113:
1114: l_step := 11;
1115: hr_utility.set_location(g_package || l_procedure_name, 110);
1116:
1117: FOR l_cnt1 IN get_states_for_legal_emp(p_business_group_id,
1118: p_legal_employer_id,
1119: p_state_code,p_gre_id)

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

2170:
2171: END LOOP; /* For the Outer Distinct State Loop */
2172:
2173: l_step := 12;
2174: hr_utility.set_location(g_package || l_procedure_name, 120);
2175:
2176: /* Writing the Legal Employer Level Totals into the PL/SQL data */
2177: /* Legal Employer Gross Earning Data */
2178:

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

2266:
2267: IF p_show_soc_security = 'Y' THEN
2268:
2269: l_step := 13;
2270: hr_utility.set_location(g_package || l_procedure_name, 130);
2271:
2272: /* Legal Employer social security Quota details */
2273:
2274: FOR m IN 1 .. le_soc_sec_det_tab.COUNT

Line 2314: hr_utility.raise_error;

2310: when others THEN
2311: l_error_message := 'Error at step ' || l_step || ' IN ' ||
2312: g_package || l_procedure_name;
2313: dbg(l_error_message || '-' || sqlerrm);
2314: hr_utility.raise_error;
2315:
2316: END populate_plsql_table ;
2317:
2318: /*****************************************************************************

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

2403: FROM fnd_sessions fs
2404: WHERE fs.session_id = userenv('sessionid')) ;
2405:
2406: l_step := 1;
2407: hr_utility.set_location(g_package || l_procedure_name, 10);
2408: dbg('Calling Populate plsql table');
2409:
2410: populate_plsql_table(fnd_date.canonical_to_date(p_start_date_earned) ,
2411: fnd_date.canonical_to_date(p_end_date_earned) ,

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

2421:
2422: dbg('After Populate PlSql table procedure');
2423:
2424: l_step := 2;
2425: hr_utility.set_location(g_package || l_procedure_name, 20);
2426:
2427: dbg('The total records IN PLsql Table is '||xml_data_table.count);
2428:
2429: FOR m IN 1 ..xml_data_table.COUNT LOOP

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

2436: -- Write XML header line
2437: dbg('Write XML header line');
2438:
2439: l_step := 3;
2440: hr_utility.set_location(g_package || l_procedure_name, 30);
2441:
2442: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
2443:
2444: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'

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

2444: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' 2445: hr_mx_utility.get_IANA_charset || '"?>' ) ;
2446:
2447: l_step := 4;
2448: hr_utility.set_location(g_package || l_procedure_name, 40);
2449:
2450: -- Write XML data FROM plsql table
2451: dbg('Convert AND Write XML data IN the output file');
2452:

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

2461: END LOOP ;
2462:
2463:
2464: l_step := 5;
2465: hr_utility.set_location(g_package || l_procedure_name, 50);
2466:
2467: dbg('cleaning up the plsql table');
2468:
2469: xml_data_table.delete;

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

2548:
2549: dbg('Submitting concurrent request for Payroll Tax Remittance Report');
2550:
2551: l_step := 1;
2552: hr_utility.set_location(g_package || l_procedure_name, 10);
2553:
2554: l_program := 'PYMXTRRXML';
2555: l_req_id := Fnd_request.submit_request(
2556: application => 'PAY',

Line 2576: hr_utility.raise_error;

2572: If l_req_id = 0 THEN
2573:
2574: fnd_message.retrieve(l_errbuf);
2575: dbg('Error when submitting request: ' || SQLERRM || ' ' || SQLCODE);
2576: hr_utility.raise_error;
2577:
2578: ELSE
2579:
2580: dbg('Waiting for the First Request to get complete');

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

2581: COMMIT;
2582: dbg('Commited the First Request');
2583:
2584: l_step := 2;
2585: hr_utility.set_location(g_package || l_procedure_name, 20);
2586:
2587: l_wait_outcome := fnd_concurrent.WAIT_FOR_REQUEST(
2588: request_id => l_req_id,
2589: interval => 15,

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

2611:
2612: dbg('Submitting XML Report Publisher concurrent request');
2613:
2614: l_step := 3;
2615: hr_utility.set_location(g_package || l_procedure_name, 30);
2616:
2617: l_program := 'XDOREPPB';
2618:
2619: /* assigning the argument1 value to l_sql_arg1 */

Line 2665: hr_utility.raise_error;

2661: when others THEN
2662: l_error_message := 'Error at step ' || l_step || ' IN ' ||
2663: g_package || l_procedure_name;
2664: dbg(l_error_message || '-' || sqlerrm);
2665: hr_utility.raise_error;
2666:
2667: End trr_report_wrapper ; -- End Of Procedure TRR_Report_wrapper
2668:
2669: --begin

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

2666:
2667: End trr_report_wrapper ; -- End Of Procedure TRR_Report_wrapper
2668:
2669: --begin
2670: --hr_utility.trace_on (null, 'MXTRR');
2671:
2672: END pay_mx_trr_pkg; -- End Of Package Body