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_W2_FORMAT_RECORD dependencies on PAY_US_REPORTING_UTILS_PKG

Line 18: Referenced By: Package pay_us_reporting_utils_pkg

14: The purpose of this package is to format reacord to support the
15: generation of W2 magnetic tape for US legilsative requirements.
16:
17: Notes
18: Referenced By: Package pay_us_reporting_utils_pkg
19:
20: History
21:
22: 14-Jul-03 ppanda 115.0 Created

Line 203: -- from DAT_VALIDATION function in package pay_us_reporting_utils_pkg

199: */
200:
201: -- This function determines the required length for fields
202: -- in various data record. This function is being referenced
203: -- from DAT_VALIDATION function in package pay_us_reporting_utils_pkg
204: --
205: FUNCTION set_req_field_length (p_report_type IN varchar2,
206: p_format IN varchar2,
207: p_report_qualifier IN varchar2,

Line 481: sp_out_10:= pay_us_reporting_utils_pkg.Character_check(p_emp_number);

477: IF ((p_item_name = 'ER_ADDRESS') and (p_local_code = 'PHILA')) THEN
478: sp_out_8:= lpad(NVL(p_locality_company_id,' '),15);
479: END IF;
480: ELSIF p_item_name = 'EE_ADDRESS' THEN
481: sp_out_10:= pay_us_reporting_utils_pkg.Character_check(p_emp_number);
482: END IF;
483: --}
484: --
485: -- when address is Invalid

Line 740: pay_us_reporting_utils_pkg.data_validation(p_effective_date,

736: -- Validation Starts
737: -- EIN Validation
738: IF p_input_40 = 'FLAT' THEN
739: l_emp_ein :=
740: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
741: p_report_type,
742: p_format,
743: p_report_qualifier,
744: p_record_name,

Line 1629: pay_us_reporting_utils_pkg.data_validation(p_effective_date,

1625: IF p_input_40 = 'FLAT' THEN
1626: --{
1627: hr_utility.trace('before data_validation of ein');
1628: l_emp_ein :=
1629: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
1630: p_report_type,
1631: p_format,
1632: p_report_qualifier,
1633: p_record_name,

Line 1649: l_agent_ein := pay_us_reporting_utils_pkg.data_validation(p_effective_date,

1645: END IF;
1646:
1647: IF l_agent_indicator = '1' THEN
1648: --{
1649: l_agent_ein := pay_us_reporting_utils_pkg.data_validation(p_effective_date,
1650: p_report_type,
1651: p_format,
1652: p_report_qualifier,
1653: p_record_name,

Line 1675: l_other_ein:= pay_us_reporting_utils_pkg.data_validation(p_effective_date,

1671:
1672: IF l_input_8 IS NOT NULL THEN --Checking Other EIN for validation
1673: --{
1674: hr_utility.trace('before data_validation of other EIN');
1675: l_other_ein:= pay_us_reporting_utils_pkg.data_validation(p_effective_date,
1676: p_report_type,
1677: p_format,
1678: p_report_qualifier,
1679: p_record_name,

Line 2513: l_first_name := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(

2509:
2510: parameter_record(23).p_parameter_name:= 'Roth Contributions Und Sec 403(b) Plan';
2511: parameter_record(23).p_parameter_value:=r_input_43 ; -- Bug # 5256745
2512:
2513: l_first_name := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(
2514: substr(p_input_3,1,15),' '),15));
2515: l_middle_name := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(
2516: substr(p_input_4,1,15),' '),15));
2517: l_last_name := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(

Line 2515: l_middle_name := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(

2511: parameter_record(23).p_parameter_value:=r_input_43 ; -- Bug # 5256745
2512:
2513: l_first_name := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(
2514: substr(p_input_3,1,15),' '),15));
2515: l_middle_name := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(
2516: substr(p_input_4,1,15),' '),15));
2517: l_last_name := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(
2518: substr(p_input_5,1,20),' '),20));
2519: l_suffix := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(

Line 2517: l_last_name := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(

2513: l_first_name := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(
2514: substr(p_input_3,1,15),' '),15));
2515: l_middle_name := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(
2516: substr(p_input_4,1,15),' '),15));
2517: l_last_name := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(
2518: substr(p_input_5,1,20),' '),20));
2519: l_suffix := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(
2520: substr(p_input_6,1,4),' '),4));
2521: l_full_name := substr(ltrim(rtrim(p_input_3)||' '||

Line 2519: l_suffix := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(

2515: l_middle_name := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(
2516: substr(p_input_4,1,15),' '),15));
2517: l_last_name := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(
2518: substr(p_input_5,1,20),' '),20));
2519: l_suffix := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(
2520: substr(p_input_6,1,4),' '),4));
2521: l_full_name := substr(ltrim(rtrim(p_input_3)||' '||
2522: rtrim(p_input_5)),1,50);
2523:

Line 2538: pay_us_reporting_utils_pkg.data_validation( p_effective_date,

2534: -- Validation for RW Record Start
2535: --
2536: -- SSN Validation
2537: l_ssn :=
2538: pay_us_reporting_utils_pkg.data_validation( p_effective_date,
2539: p_report_type,
2540: p_format,
2541: p_report_qualifier,
2542: p_record_name,

Line 2561: pay_us_reporting_utils_pkg.data_validation(

2557: -- is marked for exclusion
2558: FOR i in 1..23
2559: LOOP
2560: parameter_record(i).p_output_value :=
2561: pay_us_reporting_utils_pkg.data_validation(
2562: p_effective_date,
2563: p_report_type,
2564: p_format,
2565: p_report_qualifier,

Line 3222: pay_us_reporting_utils_pkg.data_validation( p_effective_date,

3218: hr_utility.trace('Input '||parameter_record(i).p_parameter_name||' = '
3219: ||parameter_record(i).p_parameter_value);
3220:
3221: parameter_record(i).p_output_value :=
3222: pay_us_reporting_utils_pkg.data_validation( p_effective_date,
3223: p_report_type,
3224: p_format,
3225: p_report_qualifier,
3226: p_record_name,

Line 3255: pay_us_reporting_utils_pkg.data_validation(p_effective_date,

3251: IF l_ssn IS NULL THEN
3252: l_ssn:='000000000';
3253: ELSE
3254: l_ssn :=
3255: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
3256: p_report_type,
3257: p_format,
3258: p_report_qualifier,
3259: p_record_name,

Line 3284: pay_us_reporting_utils_pkg.data_validation(

3280: IF p_input_21 IS NULL THEN
3281: l_emp_ssn:=lpad(' ',9);
3282: ELSE
3283: l_emp_ssn :=
3284: pay_us_reporting_utils_pkg.data_validation(
3285: p_effective_date,
3286: p_report_type,
3287: p_format,
3288: p_report_qualifier,

Line 3902: l_ssn := pay_us_reporting_utils_pkg.data_validation(

3898:
3899: /* Pos:10 - 18 Social security number */
3900:
3901: IF p_input_40 = 'FLAT' THEN
3902: l_ssn := pay_us_reporting_utils_pkg.data_validation(
3903: p_effective_date,
3904: p_report_type,
3905: p_format,
3906: p_report_qualifier,

Line 3931: l_first_name := pay_us_reporting_utils_pkg.Character_check(rpad(

3927: Pos:34 - 48 Middle name
3928: Pos:49 - 68 Last name
3929: Pos:69 - 72 suffix */
3930:
3931: l_first_name := pay_us_reporting_utils_pkg.Character_check(rpad(
3932: nvl(substr(r_input_5,1,15),' '),15));
3933: l_middle_name := pay_us_reporting_utils_pkg.Character_check(rpad(
3934: nvl(substr(r_input_6,1,15),' '),15));
3935: l_last_name := pay_us_reporting_utils_pkg.Character_check(rpad(

Line 3933: l_middle_name := pay_us_reporting_utils_pkg.Character_check(rpad(

3929: Pos:69 - 72 suffix */
3930:
3931: l_first_name := pay_us_reporting_utils_pkg.Character_check(rpad(
3932: nvl(substr(r_input_5,1,15),' '),15));
3933: l_middle_name := pay_us_reporting_utils_pkg.Character_check(rpad(
3934: nvl(substr(r_input_6,1,15),' '),15));
3935: l_last_name := pay_us_reporting_utils_pkg.Character_check(rpad(
3936: nvl(substr(r_input_7,1,20),' '),20));
3937: l_suffix := pay_us_reporting_utils_pkg.Character_check(rpad(

Line 3935: l_last_name := pay_us_reporting_utils_pkg.Character_check(rpad(

3931: l_first_name := pay_us_reporting_utils_pkg.Character_check(rpad(
3932: nvl(substr(r_input_5,1,15),' '),15));
3933: l_middle_name := pay_us_reporting_utils_pkg.Character_check(rpad(
3934: nvl(substr(r_input_6,1,15),' '),15));
3935: l_last_name := pay_us_reporting_utils_pkg.Character_check(rpad(
3936: nvl(substr(r_input_7,1,20),' '),20));
3937: l_suffix := pay_us_reporting_utils_pkg.Character_check(rpad(
3938: nvl(substr(r_input_8,1,4),' '),4));
3939: hr_utility.trace('l_suffix = '||l_suffix);

Line 3937: l_suffix := pay_us_reporting_utils_pkg.Character_check(rpad(

3933: l_middle_name := pay_us_reporting_utils_pkg.Character_check(rpad(
3934: nvl(substr(r_input_6,1,15),' '),15));
3935: l_last_name := pay_us_reporting_utils_pkg.Character_check(rpad(
3936: nvl(substr(r_input_7,1,20),' '),20));
3937: l_suffix := pay_us_reporting_utils_pkg.Character_check(rpad(
3938: nvl(substr(r_input_8,1,4),' '),4));
3939: hr_utility.trace('l_suffix = '||l_suffix);
3940:
3941: /* Suffix blank for MD,OH_RC,MD_SQWL,MN_SQWL,OH_SQWL */

Line 4143: pay_us_reporting_utils_pkg.data_validation(p_effective_date,

4139: Pos:287 - 297 SIT withheld. */
4140:
4141: IF p_input_40 = 'FLAT' THEN
4142: r_input_27:=
4143: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
4144: p_report_type,
4145: p_format,
4146: p_report_qualifier,
4147: p_record_name,

Line 4161: pay_us_reporting_utils_pkg.data_validation( p_effective_date,

4157: IF p_exclude_from_output = 'Y' THEN
4158: l_exclude_from_output_chk := TRUE;
4159: END IF;
4160: r_input_28 :=
4161: pay_us_reporting_utils_pkg.data_validation( p_effective_date,
4162: p_report_type,
4163: p_format,
4164: p_report_qualifier,
4165: p_record_name,

Line 4210: pay_us_reporting_utils_pkg.data_validation(p_effective_date,

4206: --{
4207: If p_input_40 = 'FLAT' THEN
4208: hr_utility.trace(' Other state data AL, OH, MD, MS ');
4209: r_input_29 :=
4210: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
4211: p_report_type,
4212: p_format,
4213: p_report_qualifier,
4214: p_record_name,

Line 4273: pay_us_reporting_utils_pkg.data_validation(p_effective_date,

4269: --{
4270: IF p_input_40 = 'FLAT' THEN
4271: -- Validating Local Taxable Wages
4272: r_input_31 :=
4273: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
4274: p_report_type,
4275: p_format,
4276: p_report_qualifier,
4277: p_record_name,

Line 4291: r_input_32 := pay_us_reporting_utils_pkg.data_validation( p_effective_date,

4287: IF p_exclude_from_output = 'Y' THEN
4288: l_exclude_from_output_chk := TRUE;
4289: END IF;
4290: -- Validating Local Income Tax withheld
4291: r_input_32 := pay_us_reporting_utils_pkg.data_validation( p_effective_date,
4292: p_report_type,
4293: p_format,
4294: p_report_qualifier,
4295: p_record_name,

Line 4349: pay_us_reporting_utils_pkg.data_validation(p_effective_date,

4345: Pos: 358 - 512 Blank fill */
4346: ELSIF p_report_qualifier = 'IN' THEN
4347: IF p_input_40 = 'FLAT' THEN
4348: r_input_17:=
4349: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
4350: p_report_type,
4351: p_format,
4352: p_report_qualifier,
4353: p_record_name,

Line 4368: pay_us_reporting_utils_pkg.data_validation(p_effective_date,

4364: l_exclude_from_output_chk := TRUE;
4365: END IF;
4366:
4367: r_input_34:=
4368: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
4369: p_report_type,
4370: p_format,
4371: p_report_qualifier,
4372: p_record_name,

Line 4428: pay_us_reporting_utils_pkg.data_validation(p_effective_date,

4424: ELSIF p_report_qualifier = 'MA' THEN
4425: r_input_33 := lpad(' ',7);
4426: IF p_input_40 = 'FLAT' THEN
4427: l_fica_mcr_wh :=
4428: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
4429: p_report_type,
4430: p_format,
4431: p_report_qualifier,
4432: p_record_name,

Line 4443: pay_us_reporting_utils_pkg.data_validation(p_effective_date,

4439: p_exclude_from_output,
4440: sp_out_1,
4441: sp_out_2);
4442: l_w2_govt_ee_contrib :=
4443: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
4444: p_report_type,
4445: p_format,
4446: p_report_qualifier,
4447: p_record_name,

Line 4458: pay_us_reporting_utils_pkg.data_validation(p_effective_date,

4454: p_exclude_from_output,
4455: sp_out_1,
4456: sp_out_2);
4457: l_w2_fed_wages :=
4458: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
4459: p_report_type,
4460: p_format,
4461: p_report_qualifier,
4462: p_record_name,

Line 4489: pay_us_reporting_utils_pkg.data_validation(p_effective_date,

4485: r_input_33 := lpad(' ',7);
4486: IF p_input_40 = 'FLAT' THEN
4487:
4488: l_mif :=
4489: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
4490: p_report_type,
4491: p_format,
4492: p_report_qualifier,
4493: p_record_name,

Line 4508: pay_us_reporting_utils_pkg.data_validation(p_effective_date,

4504: l_exclude_from_output_chk := TRUE;
4505: END IF;
4506:
4507: l_unemp_insurance :=
4508: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
4509: p_report_type,
4510: p_format,
4511: p_report_qualifier,
4512: p_record_name,

Line 4523: pay_us_reporting_utils_pkg.data_validation( p_effective_date,

4519: p_exclude_from_output,
4520: sp_out_1,
4521: sp_out_2);
4522: l_sdi_wh :=
4523: pay_us_reporting_utils_pkg.data_validation( p_effective_date,
4524: p_report_type,
4525: p_format,
4526: p_report_qualifier,
4527: p_record_name,

Line 4538: pay_us_reporting_utils_pkg.data_validation(p_effective_date,

4534: p_exclude_from_output,
4535: sp_out_1,
4536: sp_out_2);
4537: l_deferred_comp :=
4538: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
4539: p_report_type,
4540: p_format,
4541: p_report_qualifier,
4542: p_record_name,

Line 4584: pay_us_reporting_utils_pkg.data_validation(p_effective_date,

4580: ELSIF p_report_qualifier = 'KY' THEN
4581: r_input_33 := rpad(nvl(r_input_33,' '),7);
4582: IF p_input_40 = 'FLAT' THEN
4583: l_tax_ct_rural :=
4584: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
4585: p_report_type,
4586: p_format,
4587: p_report_qualifier,
4588: p_record_name,

Line 4599: pay_us_reporting_utils_pkg.data_validation(p_effective_date,

4595: p_exclude_from_output,
4596: sp_out_1,
4597: sp_out_2);
4598: l_tax_ct_job_dev :=
4599: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
4600: p_report_type,
4601: p_format,
4602: p_report_qualifier,
4603: p_record_name,

Line 4614: pay_us_reporting_utils_pkg.data_validation(p_effective_date,

4610: p_exclude_from_output,
4611: sp_out_1,
4612: sp_out_2);
4613: l_tax_ct_ind_revit :=
4614: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
4615: p_report_type,
4616: p_format,
4617: p_report_qualifier,
4618: p_record_name,

Line 4629: pay_us_reporting_utils_pkg.data_validation(p_effective_date,

4625: p_exclude_from_output,
4626: sp_out_1,
4627: sp_out_2);
4628: l_tax_ct_ind_dev :=
4629: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
4630: p_report_type,
4631: p_format,
4632: p_report_qualifier,
4633: p_record_name,

Line 4655: pay_us_reporting_utils_pkg.data_validation(p_effective_date,

4651: --{
4652: r_input_33 := lpad(' ',7);
4653: IF p_input_40 = 'FLAT' THEN
4654: l_wages_tips :=
4655: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
4656: p_report_type,
4657: p_format,
4658: p_report_qualifier,
4659: p_record_name,

Line 4670: pay_us_reporting_utils_pkg.data_validation(p_effective_date,

4666: p_exclude_from_output,
4667: sp_out_1,
4668: sp_out_2);
4669: l_fit_wh :=
4670: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
4671: p_report_type,
4672: p_format,
4673: p_report_qualifier,
4674: p_record_name,

Line 4715: pay_us_reporting_utils_pkg.data_validation(p_effective_date,

4711:
4712: r_input_33 := lpad(' ',7);
4713: IF p_input_40 = 'FLAT' THEN
4714: l_pension_annuity :=
4715: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
4716: p_report_type,
4717: p_format,
4718: p_report_qualifier,
4719: p_record_name,

Line 4730: pay_us_reporting_utils_pkg.data_validation(p_effective_date,

4726: p_exclude_from_output,
4727: sp_out_1,
4728: sp_out_2);
4729: l_contribution_plan :=
4730: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
4731: p_report_type,
4732: p_format,
4733: p_report_qualifier,
4734: p_record_name,

Line 4745: pay_us_reporting_utils_pkg.data_validation(p_effective_date,

4741: p_exclude_from_output,
4742: sp_out_1,
4743: sp_out_2);
4744: l_cost_reimbursement :=
4745: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
4746: p_report_type,
4747: p_format,
4748: p_report_qualifier,
4749: p_record_name,

Line 4760: pay_us_reporting_utils_pkg.data_validation(p_effective_date,

4756: p_exclude_from_output,
4757: sp_out_1,
4758: sp_out_2);
4759: l_uncollected_ss_tax_on_tips :=
4760: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
4761: p_report_type,
4762: p_format,
4763: p_report_qualifier,
4764: p_record_name,

Line 4775: pay_us_reporting_utils_pkg.data_validation(p_effective_date,

4771: p_exclude_from_output,
4772: sp_out_1,
4773: sp_out_2);
4774: l_uncollected_med_tax_on_tips :=
4775: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
4776: p_report_type,
4777: p_format,
4778: p_report_qualifier,
4779: p_record_name,

Line 4845: pay_us_reporting_utils_pkg.data_validation(p_effective_date,

4841: r_input_2 := '20';
4842: r_input_26 := '20';
4843: r_input_33 := lpad(' ',7);
4844: l_ee_contrib_pub_retire_system :=
4845: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
4846: p_report_type,
4847: p_format,
4848: p_report_qualifier,
4849: p_record_name,

Line 5560: pay_us_reporting_utils_pkg.data_validation( p_effective_date,

5556: --
5557: FOR i in 1..l_records
5558: LOOP
5559: parameter_record(i).p_output_value :=
5560: pay_us_reporting_utils_pkg.data_validation( p_effective_date,
5561: p_report_type,
5562: p_format,
5563: p_report_qualifier,
5564: p_record_name,

Line 5982: pay_us_reporting_utils_pkg.data_validation(

5978: -- Validation and Formatting for above fields done in this loop
5979: FOR i in 1..17
5980: LOOP
5981: parameter_record(i).p_output_value :=
5982: pay_us_reporting_utils_pkg.data_validation(
5983: p_effective_date,
5984: p_report_type,
5985: p_format,
5986: p_report_qualifier,

Line 6145: pay_us_reporting_utils_pkg.data_validation(p_effective_date,

6141: --{
6142: -- Validating Total Wage for Negative Value
6143: --
6144: l_wages :=
6145: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
6146: p_report_type,
6147: p_format,
6148: p_report_qualifier,
6149: p_record_name,

Line 6166: pay_us_reporting_utils_pkg.data_validation( p_effective_date,

6162: END IF;
6163: -- Validating Total Tax for Negative Value
6164: --
6165: l_taxes :=
6166: pay_us_reporting_utils_pkg.data_validation( p_effective_date,
6167: p_report_type,
6168: p_format,
6169: p_report_qualifier,
6170: p_record_name,