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

Line 223: hr_utility.set_location(gv_package || '.format_W2C_RCA_record', 10);

219: r_input_38 varchar2(300);
220: r_input_39 varchar2(300);
221:
222: BEGIN
223: hr_utility.set_location(gv_package || '.format_W2C_RCA_record', 10);
224: hr_utility.trace('RCA Record Formatting started for W-2c');
225: hr_utility.trace(' Format_W2_RA_Record Begin for Company '|| p_input_5);
226: -- Initializing local variables with parameter value
227: --{

Line 224: hr_utility.trace('RCA Record Formatting started for W-2c');

220: r_input_39 varchar2(300);
221:
222: BEGIN
223: hr_utility.set_location(gv_package || '.format_W2C_RCA_record', 10);
224: hr_utility.trace('RCA Record Formatting started for W-2c');
225: hr_utility.trace(' Format_W2_RA_Record Begin for Company '|| p_input_5);
226: -- Initializing local variables with parameter value
227: --{
228: r_input_2 := p_input_2;

Line 225: hr_utility.trace(' Format_W2_RA_Record Begin for Company '|| p_input_5);

221:
222: BEGIN
223: hr_utility.set_location(gv_package || '.format_W2C_RCA_record', 10);
224: hr_utility.trace('RCA Record Formatting started for W-2c');
225: hr_utility.trace(' Format_W2_RA_Record Begin for Company '|| p_input_5);
226: -- Initializing local variables with parameter value
227: --{
228: r_input_2 := p_input_2;
229: r_input_3 := p_input_3;

Line 270: hr_utility.set_location(gv_package || '.format_W2C_RCA_record', 20);

266: --}
267: -- Validation Starts
268: IF p_input_40 = 'FLAT' THEN
269: -- EIN Validation and format
270: hr_utility.set_location(gv_package || '.format_W2C_RCA_record', 20);
271: l_emp_ein :=
272: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
273: p_report_type,
274: p_format,

Line 291: hr_utility.trace('After Validation formatted EIN '||l_emp_ein);

287: IF p_exclude_from_output = 'Y' THEN
288: l_exclude_from_output_chk := TRUE;
289: END IF;
290: l_emp_ein := rpad(substr(l_emp_ein,1,9),9);
291: hr_utility.trace('After Validation formatted EIN '||l_emp_ein);
292: -- EIN Validation Ends
293: --
294: hr_utility.set_location(gv_package || '.format_W2C_RCA_record', 30);
295:

Line 294: hr_utility.set_location(gv_package || '.format_W2C_RCA_record', 30);

290: l_emp_ein := rpad(substr(l_emp_ein,1,9),9);
291: hr_utility.trace('After Validation formatted EIN '||l_emp_ein);
292: -- EIN Validation Ends
293: --
294: hr_utility.set_location(gv_package || '.format_W2C_RCA_record', 30);
295:
296: -- Formatiing Starts
297:
298: -- Formating PIN which is of 17 char long

Line 301: hr_utility.trace('Formatted PIN = '||l_pin);

297:
298: -- Formating PIN which is of 17 char long
299:
300: l_pin := rpad(substr(nvl(p_input_3,' '),1,17),17);
301: hr_utility.trace('Formatted PIN = '||l_pin);
302:
303: --Commenting the below code for the Bug 14799562
304: /* Checking for preferred method of problem notification code which is
305: 1=email, 2=USPS

Line 308: hr_utility.trace('Preferred method of code is correct. it is '||p_input_20);

304: /* Checking for preferred method of problem notification code which is
305: 1=email, 2=USPS
306: IF ((p_input_20 = '1' ) OR
307: (p_input_20 = '2' ) ) THEN
308: hr_utility.trace('Preferred method of code is correct. it is '||p_input_20);
309: l_pblm_code:= lpad(p_input_20,1);
310: ELSE
311: hr_utility.trace('Preferred method of code is incorrect. it is '||p_input_20);
312: l_pblm_code:= lpad(' ',1);

Line 311: hr_utility.trace('Preferred method of code is incorrect. it is '||p_input_20);

307: (p_input_20 = '2' ) ) THEN
308: hr_utility.trace('Preferred method of code is correct. it is '||p_input_20);
309: l_pblm_code:= lpad(p_input_20,1);
310: ELSE
311: hr_utility.trace('Preferred method of code is incorrect. it is '||p_input_20);
312: l_pblm_code:= lpad(' ',1);
313: END IF; */
314:
315: l_pblm_code:= lpad(' ',1);

Line 323: hr_utility.trace('l_preparer_code is correct. it is '||p_input_21);

319: (p_input_21 = 'L' )OR
320: (p_input_21 = 'P' )OR
321: (p_input_21 = 'O' )) THEN
322: l_preparer_code:= lpad(p_input_21,1);
323: hr_utility.trace('l_preparer_code is correct. it is '||p_input_21);
324: ELSE
325: l_preparer_code:= lpad(' ',1);
326: hr_utility.trace('l_preparer_code is incorrect. it is '||p_input_21);
327: END IF;

Line 326: hr_utility.trace('l_preparer_code is incorrect. it is '||p_input_21);

322: l_preparer_code:= lpad(p_input_21,1);
323: hr_utility.trace('l_preparer_code is correct. it is '||p_input_21);
324: ELSE
325: l_preparer_code:= lpad(' ',1);
326: hr_utility.trace('l_preparer_code is incorrect. it is '||p_input_21);
327: END IF;
328:
329: -- Formatiing Ends
330: --

Line 331: hr_utility.set_location(gv_package || '.format_W2C_RCA_record', 40);

327: END IF;
328:
329: -- Formatiing Ends
330: --
331: hr_utility.set_location(gv_package || '.format_W2C_RCA_record', 40);
332:
333: -- RA Record of Flat Type
334: --
335: return_value:='RCA'

Line 366: hr_utility.set_location(gv_package || '.format_W2C_RCA_record', 50);

362: pay_us_w2c_in_mmref2_format.number_of_error_rcw_rcf := 0;
363: pay_us_w2c_in_mmref2_format.number_of_error_rco_rcf := 0;
364:
365: --
366: hr_utility.set_location(gv_package || '.format_W2C_RCA_record', 50);
367: hr_utility.trace('RCA Record of FLAT Type -----');
368: ret_str_len:=length(return_value);
369: END IF;
370: p_error := l_exclude_from_output_chk;

Line 367: hr_utility.trace('RCA Record of FLAT Type -----');

363: pay_us_w2c_in_mmref2_format.number_of_error_rco_rcf := 0;
364:
365: --
366: hr_utility.set_location(gv_package || '.format_W2C_RCA_record', 50);
367: hr_utility.trace('RCA Record of FLAT Type -----');
368: ret_str_len:=length(return_value);
369: END IF;
370: p_error := l_exclude_from_output_chk;
371: ret_str_len:=length(return_value);

Line 494: hr_utility.set_location(gv_package || '.format_W2C_RCE_record', 10);

490: r_input_38 varchar2(300);
491: r_input_39 varchar2(300);
492:
493: BEGIN
494: hr_utility.set_location(gv_package || '.format_W2C_RCE_record', 10);
495: hr_utility.trace('RCE Record Formatting started ');
496: hr_utility.trace('Format Record Type '|| p_input_40);
497: -- Initializing local variables with parameter value
498: --{

Line 495: hr_utility.trace('RCE Record Formatting started ');

491: r_input_39 varchar2(300);
492:
493: BEGIN
494: hr_utility.set_location(gv_package || '.format_W2C_RCE_record', 10);
495: hr_utility.trace('RCE Record Formatting started ');
496: hr_utility.trace('Format Record Type '|| p_input_40);
497: -- Initializing local variables with parameter value
498: --{
499: r_input_2 := p_input_2;

Line 496: hr_utility.trace('Format Record Type '|| p_input_40);

492:
493: BEGIN
494: hr_utility.set_location(gv_package || '.format_W2C_RCE_record', 10);
495: hr_utility.trace('RCE Record Formatting started ');
496: hr_utility.trace('Format Record Type '|| p_input_40);
497: -- Initializing local variables with parameter value
498: --{
499: r_input_2 := p_input_2;
500: r_input_3 := p_input_3;

Line 538: hr_utility.set_location(gv_package || '.format_W2C_RCE_record', 20);

534: r_input_37 := p_input_37;
535: r_input_38 := p_input_38;
536: r_input_39 := p_input_39;
537: --}
538: hr_utility.set_location(gv_package || '.format_W2C_RCE_record', 20);
539:
540: -- Validation for RCE Record starts
541: -- These validation are used only for mf file only.
542: -- not for any of the audit report

Line 546: hr_utility.set_location(gv_package || '.format_W2C_RCE_record', 30);

542: -- not for any of the audit report
543: --
544: IF p_input_40 = 'FLAT' THEN
545: --{
546: hr_utility.set_location(gv_package || '.format_W2C_RCE_record', 30);
547: hr_utility.trace('before data_validation of EIN is '||p_input_3);
548: l_emp_ein :=
549: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
550: p_report_type,

Line 547: hr_utility.trace('before data_validation of EIN is '||p_input_3);

543: --
544: IF p_input_40 = 'FLAT' THEN
545: --{
546: hr_utility.set_location(gv_package || '.format_W2C_RCE_record', 30);
547: hr_utility.trace('before data_validation of EIN is '||p_input_3);
548: l_emp_ein :=
549: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
550: p_report_type,
551: p_format,

Line 566: hr_utility.trace('after data_validation of EIN value is '||l_emp_ein);

562: sp_out_2);
563: IF p_exclude_from_output = 'Y' THEN
564: l_exclude_from_output_chk := TRUE;
565: END IF;
566: hr_utility.trace('after data_validation of EIN value is '||l_emp_ein);
567: hr_utility.trace('Exclude from output '||p_exclude_from_output);
568: return_value := 'RCE'
569: ||rpad(substr(nvl(r_input_2,' '),1,4),13)
570: ||l_emp_ein

Line 567: hr_utility.trace('Exclude from output '||p_exclude_from_output);

563: IF p_exclude_from_output = 'Y' THEN
564: l_exclude_from_output_chk := TRUE;
565: END IF;
566: hr_utility.trace('after data_validation of EIN value is '||l_emp_ein);
567: hr_utility.trace('Exclude from output '||p_exclude_from_output);
568: return_value := 'RCE'
569: ||rpad(substr(nvl(r_input_2,' '),1,4),13)
570: ||l_emp_ein
571: ||lpad(' ',197)

Line 628: hr_utility.trace('Formatting RCF Record');

624: l_taxes varchar2(100);
625: sp_out_1 varchar2(100);
626: sp_out_2 varchar2(100);
627: BEGIN
628: hr_utility.trace('Formatting RCF Record');
629: l_total_rcw_records := lpad(nvl(p_total_no_of_record,'0'),9,0);
630: return_value := 'RCF'
631: ||l_total_rcw_records
632: ||lpad(' ',1012);

Line 692: hr_utility.set_location(gv_package || '.format_W2C_RCT_record', 10);

688: ln_no_of_rcw_wages number := 20;
689: lv_no_of_rcw_records varchar2(10) := ' ';
690:
691: BEGIN
692: hr_utility.set_location(gv_package || '.format_W2C_RCT_record', 10);
693: hr_utility.trace('Formatting RCT Record');
694:
695: parameter_record.delete;
696: parameter_record(1).p_parameter_name := 'Wages,Tips And Other Compensation';

Line 693: hr_utility.trace('Formatting RCT Record');

689: lv_no_of_rcw_records varchar2(10) := ' ';
690:
691: BEGIN
692: hr_utility.set_location(gv_package || '.format_W2C_RCT_record', 10);
693: hr_utility.trace('Formatting RCT Record');
694:
695: parameter_record.delete;
696: parameter_record(1).p_parameter_name := 'Wages,Tips And Other Compensation';
697: parameter_record(2).p_parameter_name := 'Federal Income Tax Withheld';

Line 725: hr_utility.set_location(gv_package || '.format_W2C_RCT_record', 20);

721: parameter_record(26).p_parameter_name:= 'Cost of Employer-Sponsored Health Coverage'; --13255427
722:
723:
724:
725: hr_utility.set_location(gv_package || '.format_W2C_RCT_record', 20);
726: ln_no_of_rcw_wages := 26; --13255427 /* 5358272 */
727:
728: FOR i IN 1..ln_no_of_rcw_wages
729: LOOP

Line 730: hr_utility.trace(parameter_record(i).p_parameter_name||' OLD-> '

726: ln_no_of_rcw_wages := 26; --13255427 /* 5358272 */
727:
728: FOR i IN 1..ln_no_of_rcw_wages
729: LOOP
730: hr_utility.trace(parameter_record(i).p_parameter_name||' OLD-> '
731: || pay_us_w2c_in_mmref2_format.ltr_rct_info(i).rct_wage_old_formated
732: || ' NEW-> '|| pay_us_w2c_in_mmref2_format.ltr_rct_info(i).rct_wage_new_formated);
733: END LOOP;
734:

Line 735: hr_utility.set_location(gv_package || '.format_W2C_RCT_record', 30);

731: || pay_us_w2c_in_mmref2_format.ltr_rct_info(i).rct_wage_old_formated
732: || ' NEW-> '|| pay_us_w2c_in_mmref2_format.ltr_rct_info(i).rct_wage_new_formated);
733: END LOOP;
734:
735: hr_utility.set_location(gv_package || '.format_W2C_RCT_record', 30);
736:
737: lv_no_of_rcw_records := lpad(pay_us_w2c_in_mmref2_format.number_of_valid_rcw_rct,7,0);
738: return_value := 'RCT'
739: ||lv_no_of_rcw_records

Line 799: hr_utility.set_location(gv_package || '.format_W2C_RCT_record', 40);

795: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(26).rct_wage_old_formated --Bug 13255427
796: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(26).rct_wage_new_formated --Bug 13255427
797: ||lpad(' ',204); --Changed from 234 for 13255427
798:
799: hr_utility.set_location(gv_package || '.format_W2C_RCT_record', 40);
800: p_error := l_exclude_from_output_chk;
801: ret_str_len:=length(return_value);
802: return return_value;
803: END format_W2C_RCT_record; -- End of Formatting RCT Record for W-2c Reporting

Line 860: hr_utility.set_location(gv_package || '.format_W2C_RCU_record', 10);

856: ln_no_of_rco_wages number := 9;--9783383
857: lv_no_of_rco_records varchar2(10) := ' ';
858:
859: BEGIN
860: hr_utility.set_location(gv_package || '.format_W2C_RCU_record', 10);
861: hr_utility.trace('Formatting RCU Record');
862: parameter_record.delete;
863: parameter_record(1).p_parameter_name:= ' Allocated Tips';
864: parameter_record(2).p_parameter_name:= 'Uncollected employee tax on tips';

Line 861: hr_utility.trace('Formatting RCU Record');

857: lv_no_of_rco_records varchar2(10) := ' ';
858:
859: BEGIN
860: hr_utility.set_location(gv_package || '.format_W2C_RCU_record', 10);
861: hr_utility.trace('Formatting RCU Record');
862: parameter_record.delete;
863: parameter_record(1).p_parameter_name:= ' Allocated Tips';
864: parameter_record(2).p_parameter_name:= 'Uncollected employee tax on tips';
865: parameter_record(3).p_parameter_name:= 'medical savings a/c';

Line 874: hr_utility.set_location(gv_package || '.format_W2C_RCU_record', 20);

870: parameter_record(8).p_parameter_name:= 'Income under 409A';
871: parameter_record(9).p_parameter_name:= 'Hire Exempt Wages and Tips';--9783383
872: parameter_record(10).p_parameter_name:= 'Desig. Roth Contributions Under 457b Plan'; --13255427
873:
874: hr_utility.set_location(gv_package || '.format_W2C_RCU_record', 20);
875: ln_no_of_rco_wages := 10;--13255427
876: FOR i IN 1..ln_no_of_rco_wages
877: LOOP
878: hr_utility.trace(parameter_record(i).p_parameter_name||' OLD-> '

Line 878: hr_utility.trace(parameter_record(i).p_parameter_name||' OLD-> '

874: hr_utility.set_location(gv_package || '.format_W2C_RCU_record', 20);
875: ln_no_of_rco_wages := 10;--13255427
876: FOR i IN 1..ln_no_of_rco_wages
877: LOOP
878: hr_utility.trace(parameter_record(i).p_parameter_name||' OLD-> '
879: || pay_us_w2c_in_mmref2_format.ltr_rcu_info(i).rcu_wage_old_formated
880: || ' NEW-> '|| pay_us_w2c_in_mmref2_format.ltr_rcu_info(i).rcu_wage_new_formated);
881: END LOOP;
882: hr_utility.set_location(gv_package || '.format_W2C_RCU_record', 30);

Line 882: hr_utility.set_location(gv_package || '.format_W2C_RCU_record', 30);

878: hr_utility.trace(parameter_record(i).p_parameter_name||' OLD-> '
879: || pay_us_w2c_in_mmref2_format.ltr_rcu_info(i).rcu_wage_old_formated
880: || ' NEW-> '|| pay_us_w2c_in_mmref2_format.ltr_rcu_info(i).rcu_wage_new_formated);
881: END LOOP;
882: hr_utility.set_location(gv_package || '.format_W2C_RCU_record', 30);
883: lv_no_of_rco_records := lpad(pay_us_w2c_in_mmref2_format.number_of_valid_rco_rcu,7,0);
884: return_value := 'RCU'
885: ||lv_no_of_rco_records
886: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(1).rcu_wage_old_formated

Line 909: hr_utility.set_location(gv_package || '.format_W2C_RCU_record', 40);

905: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(10).rcu_wage_old_formated --13255427
906: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(10).rcu_wage_new_formated --13255427
907: ||lpad(' ',714);--old value 744 for the Bug 13255427
908:
909: hr_utility.set_location(gv_package || '.format_W2C_RCU_record', 40);
910: p_error := l_exclude_from_output_chk;
911: ret_str_len:=length(return_value);
912: return return_value;
913: END format_W2C_RCU_record; -- End of Formatting RCU Record for W-2c Reporting

Line 1008: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 10);

1004: TYPE input_parameter_record IS TABLE OF function_parameter_rec%TYPE
1005: INDEX BY BINARY_INTEGER;
1006: parameter_record input_parameter_record;
1007: BEGIN
1008: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 10);
1009: --{
1010:
1011: l_first_name_old := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(
1012: substr(p_first_name_old,1,15),' '),15));

Line 1033: hr_utility.trace('Employee Name or Number = '||l_emp_name_or_number);

1029: l_emp_number := replace(p_employee_number,' ');
1030:
1031: IF l_emp_number IS NULL THEN
1032: l_emp_name_or_number := l_full_name_new;
1033: hr_utility.trace('Employee Name or Number = '||l_emp_name_or_number);
1034: ELSE
1035: l_emp_name_or_number:= l_emp_number;
1036: hr_utility.trace('Employee Name or Number = '||l_emp_name_or_number);
1037: END IF;

Line 1036: hr_utility.trace('Employee Name or Number = '||l_emp_name_or_number);

1032: l_emp_name_or_number := l_full_name_new;
1033: hr_utility.trace('Employee Name or Number = '||l_emp_name_or_number);
1034: ELSE
1035: l_emp_name_or_number:= l_emp_number;
1036: hr_utility.trace('Employee Name or Number = '||l_emp_name_or_number);
1037: END IF;
1038: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 20);
1039: --
1040: -- Validation for RCW Record Start

Line 1038: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 20);

1034: ELSE
1035: l_emp_name_or_number:= l_emp_number;
1036: hr_utility.trace('Employee Name or Number = '||l_emp_name_or_number);
1037: END IF;
1038: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 20);
1039: --
1040: -- Validation for RCW Record Start
1041: --
1042: -- Originally reported SSN validation and formatting

Line 1064: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 30);

1060: IF p_exclude_from_output = 'Y' THEN
1061: l_exclude_from_output_chk := TRUE;
1062: END IF;
1063: END IF;
1064: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 30);
1065: -- Corrected SSN validation and formatting
1066: l_ssn_new := lpad(' ',9);
1067: l_ssn_new :=
1068: pay_us_reporting_utils_pkg.data_validation( p_effective_date,

Line 1085: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 40);

1081: sp_out_2);
1082: IF p_exclude_from_output = 'Y' THEN
1083: l_exclude_from_output_chk := TRUE;
1084: END IF;
1085: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 40);
1086:
1087: parameter_record(1).p_parameter_name := 'Wages,Tips And Other Compensation';
1088: parameter_record(2).p_parameter_name := 'Federal Income Tax Withheld';
1089: parameter_record(3).p_parameter_name := 'Social Security Wages';

Line 1123: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 50);

1119: -- Negative Value validation for Originally reported wages
1120: -- if Originally reported and coreected values are identical validation and
1121: -- formating are avoided with this check
1122: --
1123: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 50);
1124: if (rcw_wage_rec(i).identical_flag = 'N') then
1125: --{
1126: if rcw_wage_rec(i).wage_old_value <> 0 then
1127: --{

Line 1149: hr_utility.trace(parameter_record(i).p_parameter_name||'Old = '||

1145: IF p_exclude_from_output = 'Y' THEN
1146: l_exclude_from_output_chk := TRUE;
1147: l_err := TRUE;
1148: END IF;
1149: hr_utility.trace(parameter_record(i).p_parameter_name||'Old = '||
1150: rcw_wage_rec(i).wage_old_value_formated);
1151: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
1152: --}
1153: else

Line 1151: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);

1147: l_err := TRUE;
1148: END IF;
1149: hr_utility.trace(parameter_record(i).p_parameter_name||'Old = '||
1150: rcw_wage_rec(i).wage_old_value_formated);
1151: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
1152: --}
1153: else
1154: rcw_wage_rec(i).wage_old_value_formated := lpad('0',11,'0');
1155: end if;

Line 1156: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 60);

1152: --}
1153: else
1154: rcw_wage_rec(i).wage_old_value_formated := lpad('0',11,'0');
1155: end if;
1156: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 60);
1157: -- Validation and formating of Corrected Value
1158: --
1159: if rcw_wage_rec(i).wage_new_value <> 0 then
1160: --{

Line 1182: hr_utility.trace(parameter_record(i).p_parameter_name||'New = '||

1178: IF p_exclude_from_output = 'Y' THEN
1179: l_exclude_from_output_chk := TRUE;
1180: l_err := TRUE;
1181: END IF;
1182: hr_utility.trace(parameter_record(i).p_parameter_name||'New = '||
1183: rcw_wage_rec(i).wage_new_value_formated);
1184: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
1185: --}
1186: else

Line 1184: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);

1180: l_err := TRUE;
1181: END IF;
1182: hr_utility.trace(parameter_record(i).p_parameter_name||'New = '||
1183: rcw_wage_rec(i).wage_new_value_formated);
1184: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
1185: --}
1186: else
1187: rcw_wage_rec(i).wage_new_value_formated := lpad('0',11,'0');
1188: end if;

Line 1192: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 70);

1188: end if;
1189: --}
1190: end if;
1191: END LOOP;
1192: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 70);
1193: hr_utility.trace('SS Wage and Tax limit Checking begins.' );
1194: OPEN get_ss_limit(p_effective_date);
1195: LOOP
1196: FETCH get_ss_limit INTO l_ss_wage_limit,

Line 1193: hr_utility.trace('SS Wage and Tax limit Checking begins.' );

1189: --}
1190: end if;
1191: END LOOP;
1192: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 70);
1193: hr_utility.trace('SS Wage and Tax limit Checking begins.' );
1194: OPEN get_ss_limit(p_effective_date);
1195: LOOP
1196: FETCH get_ss_limit INTO l_ss_wage_limit,
1197: l_ss_tax_limit;

Line 1198: hr_utility.trace('SS Wage Limit '||to_char(l_ss_wage_limit));

1194: OPEN get_ss_limit(p_effective_date);
1195: LOOP
1196: FETCH get_ss_limit INTO l_ss_wage_limit,
1197: l_ss_tax_limit;
1198: hr_utility.trace('SS Wage Limit '||to_char(l_ss_wage_limit));
1199: l_ss_count:= get_ss_limit%ROWCOUNT;
1200: EXIT WHEN get_ss_limit%NOTFOUND ;
1201: END LOOP;
1202: CLOSE get_ss_limit;

Line 1203: hr_utility.trace('No. rows exist for limit '||to_char(l_ss_count));

1199: l_ss_count:= get_ss_limit%ROWCOUNT;
1200: EXIT WHEN get_ss_limit%NOTFOUND ;
1201: END LOOP;
1202: CLOSE get_ss_limit;
1203: hr_utility.trace('No. rows exist for limit '||to_char(l_ss_count));
1204:
1205: IF l_ss_count = 0 THEN
1206: hr_utility.trace('No data found on PAY_US_FEDERAL_TAX_INFO_F '||
1207: 'for Social security wage limits.');

Line 1206: hr_utility.trace('No data found on PAY_US_FEDERAL_TAX_INFO_F '||

1202: CLOSE get_ss_limit;
1203: hr_utility.trace('No. rows exist for limit '||to_char(l_ss_count));
1204:
1205: IF l_ss_count = 0 THEN
1206: hr_utility.trace('No data found on PAY_US_FEDERAL_TAX_INFO_F '||
1207: 'for Social security wage limits.');
1208: ELSIF l_ss_count >1 THEN
1209: hr_utility.trace('Too many rows on PAY_US_FEDERAL_TAX_INFO_F '||
1210: 'for Social security wage limits.');

Line 1209: hr_utility.trace('Too many rows on PAY_US_FEDERAL_TAX_INFO_F '||

1205: IF l_ss_count = 0 THEN
1206: hr_utility.trace('No data found on PAY_US_FEDERAL_TAX_INFO_F '||
1207: 'for Social security wage limits.');
1208: ELSIF l_ss_count >1 THEN
1209: hr_utility.trace('Too many rows on PAY_US_FEDERAL_TAX_INFO_F '||
1210: 'for Social security wage limits.');
1211: ELSIF l_ss_count=1 THEN
1212: --{
1213: hr_utility.trace('SS Wage (Box-3 '||to_char(rcw_wage_rec(3).wage_new_value));

Line 1213: hr_utility.trace('SS Wage (Box-3 '||to_char(rcw_wage_rec(3).wage_new_value));

1209: hr_utility.trace('Too many rows on PAY_US_FEDERAL_TAX_INFO_F '||
1210: 'for Social security wage limits.');
1211: ELSIF l_ss_count=1 THEN
1212: --{
1213: hr_utility.trace('SS Wage (Box-3 '||to_char(rcw_wage_rec(3).wage_new_value));
1214: hr_utility.trace('SS Tax w/h (Box-4) '||to_char(rcw_wage_rec(4).wage_new_value));
1215: hr_utility.trace('SS Tips (Box-7) '||to_char(rcw_wage_rec(7).wage_new_value));
1216:
1217: IF (rcw_wage_rec(3).wage_new_value > 0 OR

Line 1214: hr_utility.trace('SS Tax w/h (Box-4) '||to_char(rcw_wage_rec(4).wage_new_value));

1210: 'for Social security wage limits.');
1211: ELSIF l_ss_count=1 THEN
1212: --{
1213: hr_utility.trace('SS Wage (Box-3 '||to_char(rcw_wage_rec(3).wage_new_value));
1214: hr_utility.trace('SS Tax w/h (Box-4) '||to_char(rcw_wage_rec(4).wage_new_value));
1215: hr_utility.trace('SS Tips (Box-7) '||to_char(rcw_wage_rec(7).wage_new_value));
1216:
1217: IF (rcw_wage_rec(3).wage_new_value > 0 OR
1218: rcw_wage_rec(4).wage_new_value > 0 OR

Line 1215: hr_utility.trace('SS Tips (Box-7) '||to_char(rcw_wage_rec(7).wage_new_value));

1211: ELSIF l_ss_count=1 THEN
1212: --{
1213: hr_utility.trace('SS Wage (Box-3 '||to_char(rcw_wage_rec(3).wage_new_value));
1214: hr_utility.trace('SS Tax w/h (Box-4) '||to_char(rcw_wage_rec(4).wage_new_value));
1215: hr_utility.trace('SS Tips (Box-7) '||to_char(rcw_wage_rec(7).wage_new_value));
1216:
1217: IF (rcw_wage_rec(3).wage_new_value > 0 OR
1218: rcw_wage_rec(4).wage_new_value > 0 OR
1219: rcw_wage_rec(7).wage_new_value > 0 )

Line 1222: hr_utility.trace('SS Tax w/h, SS Tips, SS Wages are >0 ');

1218: rcw_wage_rec(4).wage_new_value > 0 OR
1219: rcw_wage_rec(7).wage_new_value > 0 )
1220: THEN
1221: --{
1222: hr_utility.trace('SS Tax w/h, SS Tips, SS Wages are >0 ');
1223: IF (rcw_wage_rec(3).wage_new_value+
1224: rcw_wage_rec(7).wage_new_value) > l_ss_wage_limit
1225: THEN
1226: hr_utility.trace('Sum of SS_Tips and SS_Wages is > '||

Line 1226: hr_utility.trace('Sum of SS_Tips and SS_Wages is > '||

1222: hr_utility.trace('SS Tax w/h, SS Tips, SS Wages are >0 ');
1223: IF (rcw_wage_rec(3).wage_new_value+
1224: rcw_wage_rec(7).wage_new_value) > l_ss_wage_limit
1225: THEN
1226: hr_utility.trace('Sum of SS_Tips and SS_Wages is > '||
1227: to_char(l_ss_wage_limit));
1228: l_field_description:='the sum of '||
1229: parameter_record(3).p_parameter_name
1230: ||' and '||

Line 1246: hr_utility.trace('SS Tax w/h is > '||

1242: END IF;
1243: IF rcw_wage_rec(4).wage_new_value > l_ss_tax_limit
1244: THEN
1245: --{
1246: hr_utility.trace('SS Tax w/h is > '||
1247: to_char(l_ss_tax_limit));
1248: l_err := TRUE;
1249: l_amount:=l_ss_tax_limit/100;
1250: l_description:=' It is greater than '||to_char(l_amount);

Line 1265: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 80);

1261: --}
1262: END IF; -- negative check
1263: --}
1264: END IF; --l_ss_count
1265: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 80);
1266: hr_utility.trace('After SS Wage/ Tax limit checking ');
1267: IF l_err THEN
1268: IF p_validate = 'Y' THEN
1269: p_exclude_from_output := 'Y';

Line 1266: hr_utility.trace('After SS Wage/ Tax limit checking ');

1262: END IF; -- negative check
1263: --}
1264: END IF; --l_ss_count
1265: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 80);
1266: hr_utility.trace('After SS Wage/ Tax limit checking ');
1267: IF l_err THEN
1268: IF p_validate = 'Y' THEN
1269: p_exclude_from_output := 'Y';
1270: END IF;

Line 1281: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 90);

1277: END IF;
1278: --
1279: -- Validation for RCW record Ends here
1280: --
1281: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 90);
1282: hr_utility.trace('Formating RCW record in MMREF-2 format ');
1283: -- Formatting Wage Record (RCW) for .mf reporting file
1284: --
1285: return_value_mf := 'RCW'

Line 1282: hr_utility.trace('Formating RCW record in MMREF-2 format ');

1278: --
1279: -- Validation for RCW record Ends here
1280: --
1281: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 90);
1282: hr_utility.trace('Formating RCW record in MMREF-2 format ');
1283: -- Formatting Wage Record (RCW) for .mf reporting file
1284: --
1285: return_value_mf := 'RCW'
1286: ||l_ssn_old

Line 1372: hr_utility.trace('Formating RCW record completed ');

1368: ||lpad(p_sickpay_indicator_old,1)
1369: ||lpad(p_sickpay_indicator_new,1)
1370: ||lpad(' ',16);
1371: pay_us_w2c_in_mmref2_format.rcw_mf_record := return_value_mf;
1372: hr_utility.trace('Formating RCW record completed ');
1373: hr_utility.trace('mf Format RCW Record '||pay_us_w2c_in_mmref2_format.rcw_mf_record);
1374: hr_utility.trace('Length of FLAT Format RCW Record '||to_char(length(pay_us_w2c_in_mmref2_format.rcw_mf_record)));
1375: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 100);
1376: --}

Line 1373: hr_utility.trace('mf Format RCW Record '||pay_us_w2c_in_mmref2_format.rcw_mf_record);

1369: ||lpad(p_sickpay_indicator_new,1)
1370: ||lpad(' ',16);
1371: pay_us_w2c_in_mmref2_format.rcw_mf_record := return_value_mf;
1372: hr_utility.trace('Formating RCW record completed ');
1373: hr_utility.trace('mf Format RCW Record '||pay_us_w2c_in_mmref2_format.rcw_mf_record);
1374: hr_utility.trace('Length of FLAT Format RCW Record '||to_char(length(pay_us_w2c_in_mmref2_format.rcw_mf_record)));
1375: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 100);
1376: --}
1377: -- Formatting CSV format of RCW record

Line 1374: hr_utility.trace('Length of FLAT Format RCW Record '||to_char(length(pay_us_w2c_in_mmref2_format.rcw_mf_record)));

1370: ||lpad(' ',16);
1371: pay_us_w2c_in_mmref2_format.rcw_mf_record := return_value_mf;
1372: hr_utility.trace('Formating RCW record completed ');
1373: hr_utility.trace('mf Format RCW Record '||pay_us_w2c_in_mmref2_format.rcw_mf_record);
1374: hr_utility.trace('Length of FLAT Format RCW Record '||to_char(length(pay_us_w2c_in_mmref2_format.rcw_mf_record)));
1375: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 100);
1376: --}
1377: -- Formatting CSV format of RCW record
1378: --{

Line 1375: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 100);

1371: pay_us_w2c_in_mmref2_format.rcw_mf_record := return_value_mf;
1372: hr_utility.trace('Formating RCW record completed ');
1373: hr_utility.trace('mf Format RCW Record '||pay_us_w2c_in_mmref2_format.rcw_mf_record);
1374: hr_utility.trace('Length of FLAT Format RCW Record '||to_char(length(pay_us_w2c_in_mmref2_format.rcw_mf_record)));
1375: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 100);
1376: --}
1377: -- Formatting CSV format of RCW record
1378: --{
1379: hr_utility.trace('Formating RCW record in CSV format');

Line 1379: hr_utility.trace('Formating RCW record in CSV format');

1375: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 100);
1376: --}
1377: -- Formatting CSV format of RCW record
1378: --{
1379: hr_utility.trace('Formating RCW record in CSV format');
1380:
1381: if l_exclude_from_output_chk then
1382: -- {
1383: -- This will be used for a02 record because this gets the actual values

Line 1560: hr_utility.trace('CSV Format RCW Record '||pay_us_w2c_in_mmref2_format.rcw_csv_record);

1556:
1557: end if; /* l_exclude_from_output_chk */
1558:
1559: pay_us_w2c_in_mmref2_format.rcw_csv_record := return_value_csv;
1560: hr_utility.trace('CSV Format RCW Record '||pay_us_w2c_in_mmref2_format.rcw_csv_record);
1561: hr_utility.trace('Length of CSV Format RCW Record '||to_char(length(pay_us_w2c_in_mmref2_format.rcw_csv_record)));
1562: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 110);
1563: --}
1564: -- Format Blank RCW record in MMREF-2 format

Line 1561: hr_utility.trace('Length of CSV Format RCW Record '||to_char(length(pay_us_w2c_in_mmref2_format.rcw_csv_record)));

1557: end if; /* l_exclude_from_output_chk */
1558:
1559: pay_us_w2c_in_mmref2_format.rcw_csv_record := return_value_csv;
1560: hr_utility.trace('CSV Format RCW Record '||pay_us_w2c_in_mmref2_format.rcw_csv_record);
1561: hr_utility.trace('Length of CSV Format RCW Record '||to_char(length(pay_us_w2c_in_mmref2_format.rcw_csv_record)));
1562: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 110);
1563: --}
1564: -- Format Blank RCW record in MMREF-2 format
1565: -- This Blank record would be used when RCO record is moved to .a02 for error

Line 1562: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 110);

1558:
1559: pay_us_w2c_in_mmref2_format.rcw_csv_record := return_value_csv;
1560: hr_utility.trace('CSV Format RCW Record '||pay_us_w2c_in_mmref2_format.rcw_csv_record);
1561: hr_utility.trace('Length of CSV Format RCW Record '||to_char(length(pay_us_w2c_in_mmref2_format.rcw_csv_record)));
1562: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 110);
1563: --}
1564: -- Format Blank RCW record in MMREF-2 format
1565: -- This Blank record would be used when RCO record is moved to .a02 for error
1566: --{

Line 1568: hr_utility.trace('Formatting BLANK RCW Record ');

1564: -- Format Blank RCW record in MMREF-2 format
1565: -- This Blank record would be used when RCO record is moved to .a02 for error
1566: --{
1567:
1568: hr_utility.trace('Formatting BLANK RCW Record ');
1569: return_value_blank :=
1570: ' '
1571: ||','||' '
1572: ||','||' '

Line 1643: hr_utility.trace('CSV Blank Format RCW Record '||pay_us_w2c_in_mmref2_format.rcw_blank_csv_record);

1639: ||','||' '
1640: ||','||' ' --Added two columns for the Bug 13255427
1641: ||','||' ';
1642: pay_us_w2c_in_mmref2_format.rcw_blank_csv_record := return_value_blank;
1643: hr_utility.trace('CSV Blank Format RCW Record '||pay_us_w2c_in_mmref2_format.rcw_blank_csv_record);
1644: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 120);
1645: --}
1646:
1647: hr_utility.trace('p_exclude_from_output ->'||p_exclude_from_output);

Line 1644: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 120);

1640: ||','||' ' --Added two columns for the Bug 13255427
1641: ||','||' ';
1642: pay_us_w2c_in_mmref2_format.rcw_blank_csv_record := return_value_blank;
1643: hr_utility.trace('CSV Blank Format RCW Record '||pay_us_w2c_in_mmref2_format.rcw_blank_csv_record);
1644: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 120);
1645: --}
1646:
1647: hr_utility.trace('p_exclude_from_output ->'||p_exclude_from_output);
1648: p_error := l_exclude_from_output_chk;

Line 1647: hr_utility.trace('p_exclude_from_output ->'||p_exclude_from_output);

1643: hr_utility.trace('CSV Blank Format RCW Record '||pay_us_w2c_in_mmref2_format.rcw_blank_csv_record);
1644: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 120);
1645: --}
1646:
1647: hr_utility.trace('p_exclude_from_output ->'||p_exclude_from_output);
1648: p_error := l_exclude_from_output_chk;
1649: ret_str_len:=length(return_value_mf);
1650: return return_value_mf;
1651: END format_W2C_RCW_record;

Line 1704: hr_utility.set_location(gv_package || '.format_W2C_RCO_record', 10);

1700: INDEX BY BINARY_INTEGER;
1701: parameter_record input_parameter_record;
1702:
1703: BEGIN
1704: hr_utility.set_location(gv_package || '.format_W2C_RCO_record', 10);
1705: --{
1706:
1707: l_full_name_new := substr(pay_us_reporting_utils_pkg.Character_check(ltrim(rtrim(p_first_name_new)||' '||
1708: rtrim(p_last_name_new))),1,50);

Line 1714: hr_utility.trace('Employee Name or Number = '||l_emp_name_or_number);

1710: l_emp_number := replace(p_employee_number,' ');
1711:
1712: IF l_emp_number IS NULL THEN
1713: l_emp_name_or_number := l_full_name_new;
1714: hr_utility.trace('Employee Name or Number = '||l_emp_name_or_number);
1715: ELSE
1716: l_emp_name_or_number:= l_emp_number;
1717: hr_utility.trace('Employee Name or Number = '||l_emp_name_or_number);
1718: END IF;

Line 1717: hr_utility.trace('Employee Name or Number = '||l_emp_name_or_number);

1713: l_emp_name_or_number := l_full_name_new;
1714: hr_utility.trace('Employee Name or Number = '||l_emp_name_or_number);
1715: ELSE
1716: l_emp_name_or_number:= l_emp_number;
1717: hr_utility.trace('Employee Name or Number = '||l_emp_name_or_number);
1718: END IF;
1719: hr_utility.set_location(gv_package || '.format_W2C_RCO_record', 20);
1720: --
1721: -- Validation for RCO Record Start

Line 1719: hr_utility.set_location(gv_package || '.format_W2C_RCO_record', 20);

1715: ELSE
1716: l_emp_name_or_number:= l_emp_number;
1717: hr_utility.trace('Employee Name or Number = '||l_emp_name_or_number);
1718: END IF;
1719: hr_utility.set_location(gv_package || '.format_W2C_RCO_record', 20);
1720: --
1721: -- Validation for RCO Record Start
1722: --
1723: parameter_record(1).p_parameter_name:= ' allocated tips';

Line 1741: hr_utility.set_location(gv_package || '.format_W2C_RCO_record', 30);

1737: -- Negative Value validation for Originally reported wages
1738: -- if Originally reported and coreected values are identical validation and
1739: -- formating are avoided with this check
1740: --
1741: hr_utility.set_location(gv_package || '.format_W2C_RCO_record', 30);
1742: if (rco_wage_rec(i).identical_flag = 'N') then
1743: --{
1744: if rco_wage_rec(i).wage_old_value <> 0 then
1745: --{

Line 1767: hr_utility.trace(parameter_record(i).p_parameter_name||'Old = '||

1763: IF p_exclude_from_output = 'Y' THEN
1764: l_exclude_from_output_chk := TRUE;
1765: l_err := TRUE;
1766: END IF;
1767: hr_utility.trace(parameter_record(i).p_parameter_name||'Old = '||
1768: rco_wage_rec(i).wage_old_value_formated);
1769: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
1770: --}
1771: else

Line 1769: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);

1765: l_err := TRUE;
1766: END IF;
1767: hr_utility.trace(parameter_record(i).p_parameter_name||'Old = '||
1768: rco_wage_rec(i).wage_old_value_formated);
1769: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
1770: --}
1771: else
1772: rco_wage_rec(i).wage_old_value_formated := lpad('0',11,'0');
1773: end if;

Line 1774: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 40);

1770: --}
1771: else
1772: rco_wage_rec(i).wage_old_value_formated := lpad('0',11,'0');
1773: end if;
1774: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 40);
1775: -- Validation and formating of Corrected Value
1776: --
1777: if rco_wage_rec(i).wage_new_value <> 0 then
1778: --{

Line 1800: hr_utility.trace(parameter_record(i).p_parameter_name||'New = '||

1796: IF p_exclude_from_output = 'Y' THEN
1797: l_exclude_from_output_chk := TRUE;
1798: l_err := TRUE;
1799: END IF;
1800: hr_utility.trace(parameter_record(i).p_parameter_name||'New = '||
1801: rco_wage_rec(i).wage_new_value_formated);
1802: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
1803: --}
1804: else

Line 1802: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);

1798: l_err := TRUE;
1799: END IF;
1800: hr_utility.trace(parameter_record(i).p_parameter_name||'New = '||
1801: rco_wage_rec(i).wage_new_value_formated);
1802: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
1803: --}
1804: else
1805: rco_wage_rec(i).wage_new_value_formated := lpad('0',11,'0');
1806: end if;

Line 1810: hr_utility.set_location(gv_package || '.format_W2C_RCO_record', 50);

1806: end if;
1807: --}
1808: end if;
1809: END LOOP;
1810: hr_utility.set_location(gv_package || '.format_W2C_RCO_record', 50);
1811: if l_err then
1812: p_exclude_from_output := 'Y';
1813: end if;
1814:

Line 1823: hr_utility.set_location(gv_package || '.format_W2C_RCO_record', 60);

1819: END IF;
1820: --
1821: -- Validation for RCO record Ends here
1822: --
1823: hr_utility.set_location(gv_package || '.format_W2C_RCO_record', 60);
1824: hr_utility.trace('Formating RCO record in MMREF-2 format ');
1825: -- Formatting Wage Record (RCO) for .mf reporting file
1826: --
1827: return_value_mf := 'RCO'

Line 1824: hr_utility.trace('Formating RCO record in MMREF-2 format ');

1820: --
1821: -- Validation for RCO record Ends here
1822: --
1823: hr_utility.set_location(gv_package || '.format_W2C_RCO_record', 60);
1824: hr_utility.trace('Formating RCO record in MMREF-2 format ');
1825: -- Formatting Wage Record (RCO) for .mf reporting file
1826: --
1827: return_value_mf := 'RCO'
1828: ||lpad(' ',9)

Line 1852: hr_utility.trace('Formating RCO record completed ');

1848: ||rco_wage_rec(10).wage_old_value_formated --13255427
1849: ||rco_wage_rec(10).wage_new_value_formated --13255427
1850: ||lpad(' ',792); --13255427
1851: pay_us_w2c_in_mmref2_format.rco_mf_record := return_value_mf;
1852: hr_utility.trace('Formating RCO record completed ');
1853: hr_utility.trace('mf Format RCO Record '||pay_us_w2c_in_mmref2_format.rco_mf_record);
1854: hr_utility.trace('Length of FLAT Format RCO Record '||to_char(length(pay_us_w2c_in_mmref2_format.rco_mf_record)));
1855: hr_utility.set_location(gv_package || '.format_W2C_RCO_record', 70);
1856: --}

Line 1853: hr_utility.trace('mf Format RCO Record '||pay_us_w2c_in_mmref2_format.rco_mf_record);

1849: ||rco_wage_rec(10).wage_new_value_formated --13255427
1850: ||lpad(' ',792); --13255427
1851: pay_us_w2c_in_mmref2_format.rco_mf_record := return_value_mf;
1852: hr_utility.trace('Formating RCO record completed ');
1853: hr_utility.trace('mf Format RCO Record '||pay_us_w2c_in_mmref2_format.rco_mf_record);
1854: hr_utility.trace('Length of FLAT Format RCO Record '||to_char(length(pay_us_w2c_in_mmref2_format.rco_mf_record)));
1855: hr_utility.set_location(gv_package || '.format_W2C_RCO_record', 70);
1856: --}
1857: -- Formatting CSV format of RCO record

Line 1854: hr_utility.trace('Length of FLAT Format RCO Record '||to_char(length(pay_us_w2c_in_mmref2_format.rco_mf_record)));

1850: ||lpad(' ',792); --13255427
1851: pay_us_w2c_in_mmref2_format.rco_mf_record := return_value_mf;
1852: hr_utility.trace('Formating RCO record completed ');
1853: hr_utility.trace('mf Format RCO Record '||pay_us_w2c_in_mmref2_format.rco_mf_record);
1854: hr_utility.trace('Length of FLAT Format RCO Record '||to_char(length(pay_us_w2c_in_mmref2_format.rco_mf_record)));
1855: hr_utility.set_location(gv_package || '.format_W2C_RCO_record', 70);
1856: --}
1857: -- Formatting CSV format of RCO record
1858: --{

Line 1855: hr_utility.set_location(gv_package || '.format_W2C_RCO_record', 70);

1851: pay_us_w2c_in_mmref2_format.rco_mf_record := return_value_mf;
1852: hr_utility.trace('Formating RCO record completed ');
1853: hr_utility.trace('mf Format RCO Record '||pay_us_w2c_in_mmref2_format.rco_mf_record);
1854: hr_utility.trace('Length of FLAT Format RCO Record '||to_char(length(pay_us_w2c_in_mmref2_format.rco_mf_record)));
1855: hr_utility.set_location(gv_package || '.format_W2C_RCO_record', 70);
1856: --}
1857: -- Formatting CSV format of RCO record
1858: --{
1859: hr_utility.trace('Formating RCO record in CSV format');

Line 1859: hr_utility.trace('Formating RCO record in CSV format');

1855: hr_utility.set_location(gv_package || '.format_W2C_RCO_record', 70);
1856: --}
1857: -- Formatting CSV format of RCO record
1858: --{
1859: hr_utility.trace('Formating RCO record in CSV format');
1860:
1861: if l_exclude_from_output_chk then
1862: -- {
1863: -- This will be used for a02 record because this gets the actual values

Line 1930: hr_utility.trace('CSV Format RCO Record '||pay_us_w2c_in_mmref2_format.rco_csv_record);

1926: end if;
1927:
1928: /* Bug 4097321 - Commented following code. The Assignment is done inside the IF..ELSE above
1929: pay_us_w2c_in_mmref2_format.rco_csv_record := return_value_csv; */
1930: hr_utility.trace('CSV Format RCO Record '||pay_us_w2c_in_mmref2_format.rco_csv_record);
1931: hr_utility.set_location(gv_package || '.format_W2C_RCO_record', 80);
1932: --}
1933: -- Format Blank RCO record in MMREF-2 format
1934: -- This Blank record would be used when RCO record is moved to .a02 for error

Line 1931: hr_utility.set_location(gv_package || '.format_W2C_RCO_record', 80);

1927:
1928: /* Bug 4097321 - Commented following code. The Assignment is done inside the IF..ELSE above
1929: pay_us_w2c_in_mmref2_format.rco_csv_record := return_value_csv; */
1930: hr_utility.trace('CSV Format RCO Record '||pay_us_w2c_in_mmref2_format.rco_csv_record);
1931: hr_utility.set_location(gv_package || '.format_W2C_RCO_record', 80);
1932: --}
1933: -- Format Blank RCO record in MMREF-2 format
1934: -- This Blank record would be used when RCO record is moved to .a02 for error
1935: --{

Line 1937: hr_utility.trace('Formatting BLANK RCO Record ');

1933: -- Format Blank RCO record in MMREF-2 format
1934: -- This Blank record would be used when RCO record is moved to .a02 for error
1935: --{
1936:
1937: hr_utility.trace('Formatting BLANK RCO Record ');
1938: return_value_blank := ','
1939: ||' '
1940: ||','||lpad(' ',9)
1941: ||','||' '

Line 1962: hr_utility.trace('CSV Blank Format RCO Record '||pay_us_w2c_in_mmref2_format.rcw_blank_csv_record);

1958: ||','||' '
1959: ||','||' ' --Added 2 commas to meet the RCO record stucture --13255427
1960: ||','||' ';
1961: pay_us_w2c_in_mmref2_format.rco_blank_csv_record := return_value_blank;
1962: hr_utility.trace('CSV Blank Format RCO Record '||pay_us_w2c_in_mmref2_format.rcw_blank_csv_record);
1963: hr_utility.set_location(gv_package || '.format_W2C_RCO_record', 90);
1964: --}
1965:
1966: hr_utility.trace('p_exclude_from_output ->'||p_exclude_from_output);

Line 1963: hr_utility.set_location(gv_package || '.format_W2C_RCO_record', 90);

1959: ||','||' ' --Added 2 commas to meet the RCO record stucture --13255427
1960: ||','||' ';
1961: pay_us_w2c_in_mmref2_format.rco_blank_csv_record := return_value_blank;
1962: hr_utility.trace('CSV Blank Format RCO Record '||pay_us_w2c_in_mmref2_format.rcw_blank_csv_record);
1963: hr_utility.set_location(gv_package || '.format_W2C_RCO_record', 90);
1964: --}
1965:
1966: hr_utility.trace('p_exclude_from_output ->'||p_exclude_from_output);
1967: p_error := l_exclude_from_output_chk;

Line 1966: hr_utility.trace('p_exclude_from_output ->'||p_exclude_from_output);

1962: hr_utility.trace('CSV Blank Format RCO Record '||pay_us_w2c_in_mmref2_format.rcw_blank_csv_record);
1963: hr_utility.set_location(gv_package || '.format_W2C_RCO_record', 90);
1964: --}
1965:
1966: hr_utility.trace('p_exclude_from_output ->'||p_exclude_from_output);
1967: p_error := l_exclude_from_output_chk;
1968: ret_str_len:=length(return_value_mf);
1969: hr_utility.trace('format W2C RCO return_value_mf ->'||return_value_mf);
1970: return return_value_mf;

Line 1969: hr_utility.trace('format W2C RCO return_value_mf ->'||return_value_mf);

1965:
1966: hr_utility.trace('p_exclude_from_output ->'||p_exclude_from_output);
1967: p_error := l_exclude_from_output_chk;
1968: ret_str_len:=length(return_value_mf);
1969: hr_utility.trace('format W2C RCO return_value_mf ->'||return_value_mf);
1970: return return_value_mf;
1971: END format_W2C_RCO_record;
1972: END pay_us_mmrf2_w2c_format_record; -- End of Package Body