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

Line 107: hr_utility.trace('Formatting RA record header');

103: IS
104: -- Local Variables
105: header_string varchar2(3000);
106: BEGIN
107: hr_utility.trace('Formatting RA record header');
108: -- This is fix for bug # 2510920
109: -- Column heading which used to be 'Resub TLCN' now its going to be 'Resub WFID'
110: --
111: header_string := 'Record Identifier'

Line 150: hr_utility.trace('value of header string = '||header_string);

146: ||','||'Contact FAX'
147: ||','||'Preferred Method Of Problem Notification Code'
148: ||','||'Preparer Code'
149: ||','||'Blank';
150: hr_utility.trace('value of header string = '||header_string);
151: return header_String;
152: END mmrf_format_ra_record_header;
153:
154: --

Line 168: hr_utility.trace('Formatting RE record header');

164: -- Local Variables
165: header_string varchar2(6000);
166: l_header_9 varchar2(3000);
167: BEGIN
168: hr_utility.trace('Formatting RE record header');
169: If ((p_report_qualifier = 'PA') OR
170: (p_report_qualifier = 'PA_PHILA')) THEN
171: l_header_9 := 'Third Party Sick Pay Indicator'
172: ||','||'PA 8-digit Account Number';

Line 228: hr_utility.trace('value of header string = '||header_string);

224: ||','||'Country Code'
225: ||','||'Employment Code'
226: ||','||'Tax Jurisdiction Code'
227: ||','||l_header_9;
228: hr_utility.trace('value of header string = '||header_string);
229: return header_string;
230: END mmrf_format_re_record_header;
231:
232: --

Line 245: hr_utility.trace('Formatting RW record header');

241: IS
242: -- Local Variables
243: header_string varchar2(3000);
244: BEGIN
245: hr_utility.trace('Formatting RW record header');
246: header_string :=
247: 'Record Identifier'
248: ||','||'Social Security Number'
249: ||','||'Employee First Name'

Line 300: hr_utility.trace('value of formatted header string = '||header_string);

296: ||','||'Blank'
297: ||','||'Retirement Plan Indicator'
298: ||','||'Third-Party Sick Pay Indicator'
299: ||','||'Blank';
300: hr_utility.trace('value of formatted header string = '||header_string);
301: return header_string;
302: END mmrf_format_rw_record_header;
303:
304: --

Line 317: hr_utility.trace('Formatting RO record header');

313: IS
314: -- Local Variables
315: header_string varchar2(3000);
316: BEGIN
317: hr_utility.trace('Formatting RO record header');
318: header_string :=
319: 'Record Identifier'
320: ||','||'Blank'
321: ||','||'Allocated Tips'

Line 346: hr_utility.trace('value of formatted header string = '||header_string);

342: ||','||'Blank'
343: ||','||'Total Wages Tips and other Compensation Subject to Virgin Islands or Guam or American Samoa or Northern Mariana Islands Income Tax'
344: ||','||'Virgin Islands or Guam or American Samoa or Northern Mariana Islands Income Tax Withheld'
345: ||','||'Blank';
346: hr_utility.trace('value of formatted header string = '||header_string);
347: return header_string;
348: END mmrf_format_ro_record_header;
349:
350: --

Line 378: hr_utility.trace('Formatting W2 RS record header');

374: --Bug 3180532
375: l_header_17 varchar2(900);
376:
377: BEGIN
378: hr_utility.trace('Formatting W2 RS record header');
379: l_report_format := p_input_1;
380: l_name_header := 'Employee First Name'
381: ||','||'Employee Middle Name or Initial'
382: ||','||'Employee Last Name';

Line 512: hr_utility.trace('value of formatted W2 RS Record header string = '||header_string);

508: ||','||'Local Taxable Wages'
509: ||','||'Local Income Tax Withheld'
510: ||','||'State Control Number'
511: ||','||l_header_34;
512: hr_utility.trace('value of formatted W2 RS Record header string = '||header_string);
513: return header_string;
514: END mmrf_format_w2_rs_rec_header;
515:
516: --

Line 538: hr_utility.trace('Formatting SQWL RS record header');

534: l_header_34 varchar2(900);
535: l_name_header varchar2(900);
536:
537: BEGIN
538: hr_utility.trace('Formatting SQWL RS record header');
539: hr_utility.trace('p_report_qualifier = '|| p_report_qualifier);
540: l_report_format := p_input_1;
541: IF p_report_qualifier in ( 'LA_SQWL','AK_SQWL') THEN /*Bug:2337613 */
542: l_name_header := 'Employee Last Name'||','||'Employee First Name'

Line 539: hr_utility.trace('p_report_qualifier = '|| p_report_qualifier);

535: l_name_header varchar2(900);
536:
537: BEGIN
538: hr_utility.trace('Formatting SQWL RS record header');
539: hr_utility.trace('p_report_qualifier = '|| p_report_qualifier);
540: l_report_format := p_input_1;
541: IF p_report_qualifier in ( 'LA_SQWL','AK_SQWL') THEN /*Bug:2337613 */
542: l_name_header := 'Employee Last Name'||','||'Employee First Name'
543: ||','||'Employee Middle Name or Initial';

Line 581: hr_utility.trace('l_header_28 = '|| l_header_28);

577: ||','||'SIT Withheld';
578:
579: END IF;
580:
581: hr_utility.trace('l_header_28 = '|| l_header_28);
582:
583: IF p_report_qualifier = 'WA_SQWL' THEN
584: header_string:=
585: 'Employer Identification Number(EIN)'

Line 590: hr_utility.trace(header_string);

586: ||','||'Social Security Number (SSN)'
587: ||','||'Name'
588: ||','||'Quarterly Hours'
589: ||','||'Quarterly Gross Wages';
590: hr_utility.trace(header_string);
591: ELSIF p_report_qualifier = 'AK_SQWL' THEN
592: header_string:=
593: 'Transaction Code'
594: ||','||'Employer Account Number'

Line 608: hr_utility.trace(header_string);

604: /* Bug # 4554387
605: ||','||'Batch Number'
606: ||','||'Batch Item';
607: */
608: hr_utility.trace(header_string);
609:
610: ELSIF p_report_qualifier = 'NM_SQWL' AND p_format = 'CUSTOM' THEN /*bug 14802774 */
611: header_string:=
612: 'Social Security Number (SSN)'

Line 663: hr_utility.trace(header_string);

659: ||','||'Hours Worked'
660: ||','||'Officer Code'
661: ||','||'Blank';
662:
663: hr_utility.trace(header_string);
664: ELSIF p_report_qualifier = 'FL_SQWL' THEN --Added for Bug#9356178
665: header_string:=
666: 'Record Identifier'
667: ||','||'State Code'

Line 739: hr_utility.trace('value of formatted SQWL RS Record header string = '||header_string);

735: ||','||'Local Income Tax Withheld'
736: ||','||'State Control Number'
737: ||','||l_header_34;
738: END IF;
739: hr_utility.trace('value of formatted SQWL RS Record header string = '||header_string);
740: return header_string;
741: END mmrf_format_sqwl_rs_rec_header;
742:
743:

Line 766: hr_utility.trace('Formatting RSSSUMM record header');

762: l_records varchar2(900);
763: l_name_header varchar2(900);
764:
765: BEGIN
766: hr_utility.trace('Formatting RSSSUMM record header');
767:
768: IF (p_report_qualifier = 'NV') THEN
769: l_records := 'Number of RS Records';
770: l_header_3 := 'State Taxable Wages';

Line 822: hr_utility.trace('value of header string = '||header_string);

818: ||','||'Blank'
819: ||','||'No Workers/No Wages Indicator'
820: ||','||'Blank';
821: return header_String;
822: hr_utility.trace('value of header string = '||header_string);
823: END mmrf_format_rssumm_rec_header;
824:
825: --
826: -- This function formats Total Wage Record (i.e. RT) record header

Line 847: hr_utility.trace('Formatting RT record header');

843: l_records varchar2(900);
844: l_name_header varchar2(900);
845:
846: BEGIN
847: hr_utility.trace('Formatting RT record header');
848:
849: IF ( (p_report_qualifier = 'CT') OR
850: (p_report_qualifier = 'MA') ) THEN
851: l_records := 'Number of RS Records';

Line 912: hr_utility.trace('value of header string = '||header_string);

908: ||','||'Designated Roth Contrib. To Sec. 401(k) Plan'
909: ||','||'Designated Roth Contrib. Und Sec. 403(b) Salary Reduction Agreement'
910: ||','||'Blank';
911: return header_String;
912: hr_utility.trace('value of header string = '||header_string);
913: END mmrf_format_rt_record_header;
914:
915: --
916: -- This function formats Total Puertorico Wage Record (i.e. RU) record header

Line 929: hr_utility.trace('Formatting RU record header');

925: -- Local Variables
926: header_string varchar2(3000);
927:
928: BEGIN
929: hr_utility.trace('Formatting RU record header');
930: header_string:=
931: 'Record Identifier'
932: ||','||'Number of RO Records'
933: ||','||'Allocated Tips'

Line 953: hr_utility.trace('value of formatted header string = '||header_string);

949: ||','||'Retirement Fund Annual Contributions'
950: ||','||'Total Wages Tips And Other Compensation Subject to Virgin Islands or Guam or American Samoa or Northern Mariana Islands Income Tax'
951: ||','||'Virgin Islands or Guam Or American Samoa or Northern Mariana Islands Income Tax Withheld'
952: ||','||'Blank';
953: hr_utility.trace('value of formatted header string = '||header_string);
954: return header_string;
955: END mmrf_format_ru_record_header;
956:
957: --

Line 972: hr_utility.trace('Formatting RF record header');

968: l_records varchar2(900);
969: header_string varchar2(3000);
970:
971: BEGIN
972: hr_utility.trace('Formatting RF record header');
973: IF p_report_qualifier = 'PA' THEN
974: l_records := 'Blank'
975: ||','||'Number of RS Records'
976: ||','||'PA Taxable Wages'

Line 1001: hr_utility.trace('value of header string = '||header_string);

997: END IF;
998: header_string:= 'Record Identifier'
999: ||','||l_records;
1000:
1001: hr_utility.trace('value of header string = '||header_string);
1002: return header_string;
1003: END mmrf_format_rf_record_header;
1004:
1005: --

Line 1019: hr_utility.trace('Formatting RCW record header');

1015: -- Local Variables
1016: header_string varchar2(3500); --Bug 13255427
1017: BEGIN
1018:
1019: hr_utility.trace('Formatting RCW record header');
1020: header_string :=
1021: 'Record Identifier'
1022: ||','||'(Orig) SSN'
1023: ||','||'(Correct) SSN'

Line 1101: hr_utility.trace('length of formatted header string = '|| to_char(length(header_string)) );

1097: ||','||'(Correct) Retirement Plan Indicator'
1098: ||','||'(Orig) Third-Party Sick Pay Indicator'
1099: ||','||'(Correct) Third-Party Sick Pay Indicator'
1100: ||','||'Blank';
1101: hr_utility.trace('length of formatted header string = '|| to_char(length(header_string)) );
1102: --hr_utility.trace('value of formatted header string = '||header_string);
1103: return header_string;
1104: END mmrf2_format_rcw_record_header;
1105:

Line 1102: --hr_utility.trace('value of formatted header string = '||header_string);

1098: ||','||'(Orig) Third-Party Sick Pay Indicator'
1099: ||','||'(Correct) Third-Party Sick Pay Indicator'
1100: ||','||'Blank';
1101: hr_utility.trace('length of formatted header string = '|| to_char(length(header_string)) );
1102: --hr_utility.trace('value of formatted header string = '||header_string);
1103: return header_string;
1104: END mmrf2_format_rcw_record_header;
1105:
1106:

Line 1120: hr_utility.trace('Formatting RCO record header');

1116: IS
1117: -- Local Variables
1118: header_string varchar2(3000);
1119: BEGIN
1120: hr_utility.trace('Formatting RCO record header');
1121: header_string :=
1122: 'Record Identifier'
1123: ||','||'Blank'
1124: ||','||'(Orig) Allocated Tips'

Line 1145: --hr_utility.trace('value of formatted header string = '||header_string);

1141: ||','||'(Correct) Hire Exempt Wages and Tips' --9483383
1142: ||','||'(Orig) Desig. Roth Contributions Under Roth 457b Plan' -- Bug 13255427
1143: ||','||'(Correct) Desig. Roth Contributions Under Roth 457b Plan';
1144: -- ||','||'Blank';
1145: --hr_utility.trace('value of formatted header string = '||header_string);
1146: return header_string;
1147: END mmrf2_format_rco_record_header;
1148:
1149: --

Line 1151: --hr_utility.trace_on(null,'PRINTHEADER');

1147: END mmrf2_format_rco_record_header;
1148:
1149: --
1150: --BEGIN
1151: --hr_utility.trace_on(null,'PRINTHEADER');
1152: END pay_us_mmrf_print_rec_header;
1153: --End of Package Body