DBA Data[Home] [Help]

APPS.PAY_US_MMRF_PRINT_REC_HEADER dependencies on HR_UTILITY

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

79: IS
80: -- Local Variables
81: header_string varchar2(3000);
82: BEGIN
83: hr_utility.trace('Formatting RA record header');
84: -- This is fix for bug # 2510920
85: -- Column heading which used to be 'Resub TLCN' now its going to be 'Resub WFID'
86: --
87: header_string := 'Record Identifier'

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

122: ||','||'Contact FAX'
123: ||','||'Preferred Method Of Problem Notification Code'
124: ||','||'Preparer Code'
125: ||','||'Blank';
126: hr_utility.trace('value of header string = '||header_string);
127: return header_String;
128: END mmrf_format_ra_record_header;
129:
130: --

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

140: -- Local Variables
141: header_string varchar2(6000);
142: l_header_9 varchar2(3000);
143: BEGIN
144: hr_utility.trace('Formatting RE record header');
145: If ((p_report_qualifier = 'PA') OR
146: (p_report_qualifier = 'PA_PHILA')) THEN
147: l_header_9 := 'Third Party Sick Pay Indicator'
148: ||','||'PA 8-digit Account Number';

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

199: ||','||'Country Code'
200: ||','||'Employment Code'
201: ||','||'Tax Jurisdiction Code'
202: ||','||l_header_9;
203: hr_utility.trace('value of header string = '||header_string);
204: return header_string;
205: END mmrf_format_re_record_header;
206:
207: --

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

216: IS
217: -- Local Variables
218: header_string varchar2(3000);
219: BEGIN
220: hr_utility.trace('Formatting RW record header');
221: header_string :=
222: 'Record Identifier'
223: ||','||'Social Security Number'
224: ||','||'Employee First Name'

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

270: ||','||'Blank'
271: ||','||'Retirement Plan Indicator'
272: ||','||'Third-Party Sick Pay Indicator'
273: ||','||'Blank';
274: hr_utility.trace('value of formatted header string = '||header_string);
275: return header_string;
276: END mmrf_format_rw_record_header;
277:
278: --

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

287: IS
288: -- Local Variables
289: header_string varchar2(3000);
290: BEGIN
291: hr_utility.trace('Formatting RO record header');
292: header_string :=
293: 'Record Identifier'
294: ||','||'Blank'
295: ||','||'Allocated Tips'

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

314: ||','||'Blank'
315: ||','||'Total Wages Tips and other Compensation Subject to Virgin Islands or Guam or American Samoa or Northern Mariana Islands Income Tax'
316: ||','||'Virgin Islands or Guam or American Samoa or Northern Mariana Islands Income Tax Withheld'
317: ||','||'Blank';
318: hr_utility.trace('value of formatted header string = '||header_string);
319: return header_string;
320: END mmrf_format_ro_record_header;
321:
322: --

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

346: --Bug 3180532
347: l_header_17 varchar2(900);
348:
349: BEGIN
350: hr_utility.trace('Formatting W2 RS record header');
351: l_report_format := p_input_1;
352: l_name_header := 'Employee First Name'
353: ||','||'Employee Middle Name or Initial'
354: ||','||'Employee Last Name';

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

468: ||','||'Local Taxable Wages'
469: ||','||'Local Income Tax Withheld'
470: ||','||'State Control Number'
471: ||','||l_header_34;
472: hr_utility.trace('value of formatted W2 RS Record header string = '||header_string);
473: return header_string;
474: END mmrf_format_w2_rs_rec_header;
475:
476: --

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

494: l_header_34 varchar2(900);
495: l_name_header varchar2(900);
496:
497: BEGIN
498: hr_utility.trace('Formatting SQWL RS record header');
499: hr_utility.trace('p_report_qualifier = '|| p_report_qualifier);
500: l_report_format := p_input_1;
501: IF p_report_qualifier in ( 'LA_SQWL','AK_SQWL') THEN /*Bug:2337613 */
502: l_name_header := 'Employee Last Name'||','||'Employee First Name'

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

495: l_name_header varchar2(900);
496:
497: BEGIN
498: hr_utility.trace('Formatting SQWL RS record header');
499: hr_utility.trace('p_report_qualifier = '|| p_report_qualifier);
500: l_report_format := p_input_1;
501: IF p_report_qualifier in ( 'LA_SQWL','AK_SQWL') THEN /*Bug:2337613 */
502: l_name_header := 'Employee Last Name'||','||'Employee First Name'
503: ||','||'Employee Middle Name or Initial';

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

537: ||','||'SIT Withheld';
538:
539: END IF;
540:
541: hr_utility.trace('l_header_28 = '|| l_header_28);
542:
543: IF p_report_qualifier = 'WA_SQWL' THEN
544: header_string:=
545: 'Employer Identification Number(EIN)'

Line 550: hr_utility.trace(header_string);

546: ||','||'Social Security Number (SSN)'
547: ||','||'Name'
548: ||','||'Quarterly Hours'
549: ||','||'Quarterly Gross Wages';
550: hr_utility.trace(header_string);
551: ELSIF p_report_qualifier = 'AK_SQWL' THEN
552: header_string:=
553: 'Transaction Code'
554: ||','||'Employer Account Number'

Line 568: hr_utility.trace(header_string);

564: /* Bug # 4554387
565: ||','||'Batch Number'
566: ||','||'Batch Item';
567: */
568: hr_utility.trace(header_string);
569: ELSIF p_report_qualifier = 'NM_SQWL' THEN
570: header_string:=
571: 'Social Security Number (SSN)'
572: ||','||'Quater Gross Wages'

Line 577: hr_utility.trace(header_string);

573: ||','||'Quarter Excess Wages'
574: ||','||'Withholding'
575: ||','||'WorkersComp' ;
576:
577: hr_utility.trace(header_string);
578: ELSE
579: header_string:=
580: 'Record Identifier'
581: ||','||'State Code'

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

611: ||','||'Local Income Tax Withheld'
612: ||','||'State Control Number'
613: ||','||l_header_34;
614: END IF;
615: hr_utility.trace('value of formatted SQWL RS Record header string = '||header_string);
616: return header_string;
617: END mmrf_format_sqwl_rs_rec_header;
618:
619:

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

638: l_records varchar2(900);
639: l_name_header varchar2(900);
640:
641: BEGIN
642: hr_utility.trace('Formatting RSSSUMM record header');
643:
644: IF (p_report_qualifier = 'NV') THEN
645: l_records := 'Number of RS Records';
646: l_header_3 := 'State Taxable Wages';

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

694: ||','||'Blank'
695: ||','||'No Workers/No Wages Indicator'
696: ||','||'Blank';
697: return header_String;
698: hr_utility.trace('value of header string = '||header_string);
699: END mmrf_format_rssumm_rec_header;
700:
701: --
702: -- This function formats Total Wage Record (i.e. RT) record header

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

719: l_records varchar2(900);
720: l_name_header varchar2(900);
721:
722: BEGIN
723: hr_utility.trace('Formatting RT record header');
724:
725: IF ( (p_report_qualifier = 'CT') OR
726: (p_report_qualifier = 'MA') ) THEN
727: l_records := 'Number of RS Records';

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

783: ||','||'Designated Roth Contrib. To Sec. 401(k) Plan'
784: ||','||'Designated Roth Contrib. Und Sec. 403(b) Salary Reduction Agreement'
785: ||','||'Blank';
786: return header_String;
787: hr_utility.trace('value of header string = '||header_string);
788: END mmrf_format_rt_record_header;
789:
790: --
791: -- This function formats Total Puertorico Wage Record (i.e. RU) record header

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

800: -- Local Variables
801: header_string varchar2(3000);
802:
803: BEGIN
804: hr_utility.trace('Formatting RU record header');
805: header_string:=
806: 'Record Identifier'
807: ||','||'Number of RO Records'
808: ||','||'Allocated Tips'

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

824: ||','||'Retirement Fund Annual Contributions'
825: ||','||'Total Wages Tips And Other Compensation Subject to Virgin Islands or Guam or American Samoa or Northern Mariana Islands Income Tax'
826: ||','||'Virgin Islands or Guam Or American Samoa or Northern Mariana Islands Income Tax Withheld'
827: ||','||'Blank';
828: hr_utility.trace('value of formatted header string = '||header_string);
829: return header_string;
830: END mmrf_format_ru_record_header;
831:
832: --

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

843: l_records varchar2(900);
844: header_string varchar2(3000);
845:
846: BEGIN
847: hr_utility.trace('Formatting RF record header');
848: IF p_report_qualifier = 'PA' THEN
849: l_records := 'Blank'
850: ||','||'Number of RS Records'
851: ||','||'PA Taxable Wages'

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

872: END IF;
873: header_string:= 'Record Identifier'
874: ||','||l_records;
875:
876: hr_utility.trace('value of header string = '||header_string);
877: return header_string;
878: END mmrf_format_rf_record_header;
879:
880: --

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

890: -- Local Variables
891: header_string varchar2(2500);
892: BEGIN
893:
894: hr_utility.trace('Formatting RCW record header');
895: header_string :=
896: 'Record Identifier'
897: ||','||'(Orig) SSN'
898: ||','||'(Correct) SSN'

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

970: ||','||'(Correct) Retirement Plan Indicator'
971: ||','||'(Orig) Third-Party Sick Pay Indicator'
972: ||','||'(Correct) Third-Party Sick Pay Indicator'
973: ||','||'Blank';
974: hr_utility.trace('length of formatted header string = '|| to_char(length(header_string)) );
975: --hr_utility.trace('value of formatted header string = '||header_string);
976: return header_string;
977: END mmrf2_format_rcw_record_header;
978:

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

971: ||','||'(Orig) Third-Party Sick Pay Indicator'
972: ||','||'(Correct) Third-Party Sick Pay Indicator'
973: ||','||'Blank';
974: hr_utility.trace('length of formatted header string = '|| to_char(length(header_string)) );
975: --hr_utility.trace('value of formatted header string = '||header_string);
976: return header_string;
977: END mmrf2_format_rcw_record_header;
978:
979:

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

989: IS
990: -- Local Variables
991: header_string varchar2(3000);
992: BEGIN
993: hr_utility.trace('Formatting RCO record header');
994: header_string :=
995: 'Record Identifier'
996: ||','||'Blank'
997: ||','||'(Orig) Allocated Tips'

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

1010: ||','||'(Correct) Uncollected Medicare Tax on GTL > $50k'
1011: ||','||'(Orig) Income Under 409A'
1012: ||','||'(Correct) Income Under 409A';
1013: -- ||','||'Blank';
1014: --hr_utility.trace('value of formatted header string = '||header_string);
1015: return header_string;
1016: END mmrf2_format_rco_record_header;
1017:
1018: --

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

1016: END mmrf2_format_rco_record_header;
1017:
1018: --
1019: --BEGIN
1020: --hr_utility.trace_on(null,'PRINTHEADER');
1021: END pay_us_mmrf_print_rec_header;
1022: --End of Package Body