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.

[Home] [Help]

APPS.PAY_US_MMRF2_W2C_FORMAT_RECORD dependencies on HR_UTILITY

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

212: r_input_38 varchar2(300);
213: r_input_39 varchar2(300);
214:
215: BEGIN
216: hr_utility.set_location(gv_package || '.format_W2C_RCA_record', 10);
217: hr_utility.trace('RCA Record Formatting started for W-2c');
218: hr_utility.trace(' Format_W2_RA_Record Begin for Company '|| p_input_5);
219: -- Initializing local variables with parameter value
220: --{

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

213: r_input_39 varchar2(300);
214:
215: BEGIN
216: hr_utility.set_location(gv_package || '.format_W2C_RCA_record', 10);
217: hr_utility.trace('RCA Record Formatting started for W-2c');
218: hr_utility.trace(' Format_W2_RA_Record Begin for Company '|| p_input_5);
219: -- Initializing local variables with parameter value
220: --{
221: r_input_2 := p_input_2;

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

214:
215: BEGIN
216: hr_utility.set_location(gv_package || '.format_W2C_RCA_record', 10);
217: hr_utility.trace('RCA Record Formatting started for W-2c');
218: hr_utility.trace(' Format_W2_RA_Record Begin for Company '|| p_input_5);
219: -- Initializing local variables with parameter value
220: --{
221: r_input_2 := p_input_2;
222: r_input_3 := p_input_3;

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

259: --}
260: -- Validation Starts
261: IF p_input_40 = 'FLAT' THEN
262: -- EIN Validation and format
263: hr_utility.set_location(gv_package || '.format_W2C_RCA_record', 20);
264: l_emp_ein :=
265: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
266: p_report_type,
267: p_format,

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

280: IF p_exclude_from_output = 'Y' THEN
281: l_exclude_from_output_chk := TRUE;
282: END IF;
283: l_emp_ein := rpad(substr(l_emp_ein,1,9),9);
284: hr_utility.trace('After Validation formatted EIN '||l_emp_ein);
285: -- EIN Validation Ends
286: --
287: hr_utility.set_location(gv_package || '.format_W2C_RCA_record', 30);
288:

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

283: l_emp_ein := rpad(substr(l_emp_ein,1,9),9);
284: hr_utility.trace('After Validation formatted EIN '||l_emp_ein);
285: -- EIN Validation Ends
286: --
287: hr_utility.set_location(gv_package || '.format_W2C_RCA_record', 30);
288:
289: -- Formatiing Starts
290:
291: -- Formating PIN which is of 17 char long

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

290:
291: -- Formating PIN which is of 17 char long
292:
293: l_pin := rpad(substr(nvl(p_input_3,' '),1,17),17);
294: hr_utility.trace('Formatted PIN = '||l_pin);
295:
296: /* Checking for preferred method of problem notification code which is
297: 1=email, 2=USPS */
298: IF ((p_input_20 = '1' ) OR

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

296: /* Checking for preferred method of problem notification code which is
297: 1=email, 2=USPS */
298: IF ((p_input_20 = '1' ) OR
299: (p_input_20 = '2' ) ) THEN
300: hr_utility.trace('Preferred method of code is correct. it is '||p_input_20);
301: l_pblm_code:= lpad(p_input_20,1);
302: ELSE
303: hr_utility.trace('Preferred method of code is incorrect. it is '||p_input_20);
304: l_pblm_code:= lpad(' ',1);

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

299: (p_input_20 = '2' ) ) THEN
300: hr_utility.trace('Preferred method of code is correct. it is '||p_input_20);
301: l_pblm_code:= lpad(p_input_20,1);
302: ELSE
303: hr_utility.trace('Preferred method of code is incorrect. it is '||p_input_20);
304: l_pblm_code:= lpad(' ',1);
305: END IF;
306:
307: If( (p_input_21 = 'A' )OR

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

309: (p_input_21 = 'L' )OR
310: (p_input_21 = 'P' )OR
311: (p_input_21 = 'O' )) THEN
312: l_preparer_code:= lpad(p_input_21,1);
313: hr_utility.trace('l_preparer_code is correct. it is '||p_input_21);
314: ELSE
315: l_preparer_code:= lpad(' ',1);
316: hr_utility.trace('l_preparer_code is incorrect. it is '||p_input_21);
317: END IF;

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

312: l_preparer_code:= lpad(p_input_21,1);
313: hr_utility.trace('l_preparer_code is correct. it is '||p_input_21);
314: ELSE
315: l_preparer_code:= lpad(' ',1);
316: hr_utility.trace('l_preparer_code is incorrect. it is '||p_input_21);
317: END IF;
318:
319: -- Formatiing Ends
320: --

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

317: END IF;
318:
319: -- Formatiing Ends
320: --
321: hr_utility.set_location(gv_package || '.format_W2C_RCA_record', 40);
322:
323: -- RA Record of Flat Type
324: --
325: return_value:='RCA'

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

352: pay_us_w2c_in_mmref2_format.number_of_error_rcw_rcf := 0;
353: pay_us_w2c_in_mmref2_format.number_of_error_rco_rcf := 0;
354:
355: --
356: hr_utility.set_location(gv_package || '.format_W2C_RCA_record', 50);
357: hr_utility.trace('RCA Record of FLAT Type -----');
358: ret_str_len:=length(return_value);
359: END IF;
360: p_error := l_exclude_from_output_chk;

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

353: pay_us_w2c_in_mmref2_format.number_of_error_rco_rcf := 0;
354:
355: --
356: hr_utility.set_location(gv_package || '.format_W2C_RCA_record', 50);
357: hr_utility.trace('RCA Record of FLAT Type -----');
358: ret_str_len:=length(return_value);
359: END IF;
360: p_error := l_exclude_from_output_chk;
361: ret_str_len:=length(return_value);

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

480: r_input_38 varchar2(300);
481: r_input_39 varchar2(300);
482:
483: BEGIN
484: hr_utility.set_location(gv_package || '.format_W2C_RCE_record', 10);
485: hr_utility.trace('RCE Record Formatting started ');
486: hr_utility.trace('Format Record Type '|| p_input_40);
487: -- Initializing local variables with parameter value
488: --{

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

481: r_input_39 varchar2(300);
482:
483: BEGIN
484: hr_utility.set_location(gv_package || '.format_W2C_RCE_record', 10);
485: hr_utility.trace('RCE Record Formatting started ');
486: hr_utility.trace('Format Record Type '|| p_input_40);
487: -- Initializing local variables with parameter value
488: --{
489: r_input_2 := p_input_2;

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

482:
483: BEGIN
484: hr_utility.set_location(gv_package || '.format_W2C_RCE_record', 10);
485: hr_utility.trace('RCE Record Formatting started ');
486: hr_utility.trace('Format Record Type '|| p_input_40);
487: -- Initializing local variables with parameter value
488: --{
489: r_input_2 := p_input_2;
490: r_input_3 := p_input_3;

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

524: r_input_37 := p_input_37;
525: r_input_38 := p_input_38;
526: r_input_39 := p_input_39;
527: --}
528: hr_utility.set_location(gv_package || '.format_W2C_RCE_record', 20);
529:
530: -- Validation for RCE Record starts
531: -- These validation are used only for mf file only.
532: -- not for any of the audit report

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

532: -- not for any of the audit report
533: --
534: IF p_input_40 = 'FLAT' THEN
535: --{
536: hr_utility.set_location(gv_package || '.format_W2C_RCE_record', 30);
537: hr_utility.trace('before data_validation of EIN is '||p_input_3);
538: l_emp_ein :=
539: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
540: p_report_type,

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

533: --
534: IF p_input_40 = 'FLAT' THEN
535: --{
536: hr_utility.set_location(gv_package || '.format_W2C_RCE_record', 30);
537: hr_utility.trace('before data_validation of EIN is '||p_input_3);
538: l_emp_ein :=
539: pay_us_reporting_utils_pkg.data_validation(p_effective_date,
540: p_report_type,
541: p_format,

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

552: sp_out_2);
553: IF p_exclude_from_output = 'Y' THEN
554: l_exclude_from_output_chk := TRUE;
555: END IF;
556: hr_utility.trace('after data_validation of EIN value is '||l_emp_ein);
557: hr_utility.trace('Exclude from output '||p_exclude_from_output);
558: return_value := 'RCE'
559: ||rpad(substr(nvl(r_input_2,' '),1,4),13)
560: ||l_emp_ein

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

553: IF p_exclude_from_output = 'Y' THEN
554: l_exclude_from_output_chk := TRUE;
555: END IF;
556: hr_utility.trace('after data_validation of EIN value is '||l_emp_ein);
557: hr_utility.trace('Exclude from output '||p_exclude_from_output);
558: return_value := 'RCE'
559: ||rpad(substr(nvl(r_input_2,' '),1,4),13)
560: ||l_emp_ein
561: ||lpad(' ',197)

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

614: l_taxes varchar2(100);
615: sp_out_1 varchar2(100);
616: sp_out_2 varchar2(100);
617: BEGIN
618: hr_utility.trace('Formatting RCF Record');
619: l_total_rcw_records := lpad(nvl(p_total_no_of_record,'0'),9,0);
620: return_value := 'RCF'
621: ||l_total_rcw_records
622: ||lpad(' ',1012);

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

678: ln_no_of_rcw_wages number := 20;
679: lv_no_of_rcw_records varchar2(10) := ' ';
680:
681: BEGIN
682: hr_utility.set_location(gv_package || '.format_W2C_RCT_record', 10);
683: hr_utility.trace('Formatting RCT Record');
684:
685: parameter_record.delete;
686: parameter_record(1).p_parameter_name := 'Wages,Tips And Other Compensation';

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

679: lv_no_of_rcw_records varchar2(10) := ' ';
680:
681: BEGIN
682: hr_utility.set_location(gv_package || '.format_W2C_RCT_record', 10);
683: hr_utility.trace('Formatting RCT Record');
684:
685: parameter_record.delete;
686: parameter_record(1).p_parameter_name := 'Wages,Tips And Other Compensation';
687: parameter_record(2).p_parameter_name := 'Federal Income Tax Withheld';

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

711:
712:
713:
714:
715: hr_utility.set_location(gv_package || '.format_W2C_RCT_record', 20);
716: ln_no_of_rcw_wages := 25; /* 5358272 */
717:
718: FOR i IN 1..ln_no_of_rcw_wages
719: LOOP

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

716: ln_no_of_rcw_wages := 25; /* 5358272 */
717:
718: FOR i IN 1..ln_no_of_rcw_wages
719: LOOP
720: hr_utility.trace(parameter_record(i).p_parameter_name||' OLD-> '
721: || pay_us_w2c_in_mmref2_format.ltr_rct_info(i).rct_wage_old_formated
722: || ' NEW-> '|| pay_us_w2c_in_mmref2_format.ltr_rct_info(i).rct_wage_new_formated);
723: END LOOP;
724:

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

721: || pay_us_w2c_in_mmref2_format.ltr_rct_info(i).rct_wage_old_formated
722: || ' NEW-> '|| pay_us_w2c_in_mmref2_format.ltr_rct_info(i).rct_wage_new_formated);
723: END LOOP;
724:
725: hr_utility.set_location(gv_package || '.format_W2C_RCT_record', 30);
726:
727: lv_no_of_rcw_records := lpad(pay_us_w2c_in_mmref2_format.number_of_valid_rcw_rct,7,0);
728: return_value := 'RCT'
729: ||lv_no_of_rcw_records

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

781: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(25).rct_wage_old_formated
782: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(25).rct_wage_new_formated
783: ||lpad(' ',234);
784:
785: hr_utility.set_location(gv_package || '.format_W2C_RCT_record', 40);
786: p_error := l_exclude_from_output_chk;
787: ret_str_len:=length(return_value);
788: return return_value;
789: END format_W2C_RCT_record; -- End of Formatting RCT Record for W-2c Reporting

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

842: ln_no_of_rco_wages number := 8;
843: lv_no_of_rco_records varchar2(10) := ' ';
844:
845: BEGIN
846: hr_utility.set_location(gv_package || '.format_W2C_RCU_record', 10);
847: hr_utility.trace('Formatting RCU Record');
848: parameter_record.delete;
849: parameter_record(1).p_parameter_name:= ' Allocated Tips';
850: parameter_record(2).p_parameter_name:= 'Uncollected employee tax on tips';

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

843: lv_no_of_rco_records varchar2(10) := ' ';
844:
845: BEGIN
846: hr_utility.set_location(gv_package || '.format_W2C_RCU_record', 10);
847: hr_utility.trace('Formatting RCU Record');
848: parameter_record.delete;
849: parameter_record(1).p_parameter_name:= ' Allocated Tips';
850: parameter_record(2).p_parameter_name:= 'Uncollected employee tax on tips';
851: parameter_record(3).p_parameter_name:= 'medical savings a/c';

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

854: parameter_record(6).p_parameter_name:= 'Uncollected SS tax';
855: parameter_record(7).p_parameter_name:= 'Uncollected medicare tax';
856: parameter_record(8).p_parameter_name:= 'Income under 409A';
857:
858: hr_utility.set_location(gv_package || '.format_W2C_RCU_record', 20);
859: ln_no_of_rco_wages := 8;
860: FOR i IN 1..ln_no_of_rco_wages
861: LOOP
862: hr_utility.trace(parameter_record(i).p_parameter_name||' OLD-> '

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

858: hr_utility.set_location(gv_package || '.format_W2C_RCU_record', 20);
859: ln_no_of_rco_wages := 8;
860: FOR i IN 1..ln_no_of_rco_wages
861: LOOP
862: hr_utility.trace(parameter_record(i).p_parameter_name||' OLD-> '
863: || pay_us_w2c_in_mmref2_format.ltr_rcu_info(i).rcu_wage_old_formated
864: || ' NEW-> '|| pay_us_w2c_in_mmref2_format.ltr_rcu_info(i).rcu_wage_new_formated);
865: END LOOP;
866: hr_utility.set_location(gv_package || '.format_W2C_RCU_record', 30);

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

862: hr_utility.trace(parameter_record(i).p_parameter_name||' OLD-> '
863: || pay_us_w2c_in_mmref2_format.ltr_rcu_info(i).rcu_wage_old_formated
864: || ' NEW-> '|| pay_us_w2c_in_mmref2_format.ltr_rcu_info(i).rcu_wage_new_formated);
865: END LOOP;
866: hr_utility.set_location(gv_package || '.format_W2C_RCU_record', 30);
867: lv_no_of_rco_records := lpad(pay_us_w2c_in_mmref2_format.number_of_valid_rco_rcu,7,0);
868: return_value := 'RCU'
869: ||lv_no_of_rco_records
870: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(1).rcu_wage_old_formated

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

885: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(8).rcu_wage_old_formated
886: ||pay_us_w2c_in_mmref2_format.ltr_rcu_info(8).rcu_wage_new_formated
887: ||lpad(' ',774);
888:
889: hr_utility.set_location(gv_package || '.format_W2C_RCU_record', 40);
890: p_error := l_exclude_from_output_chk;
891: ret_str_len:=length(return_value);
892: return return_value;
893: END format_W2C_RCU_record; -- End of Formatting RCU Record for W-2c Reporting

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

984: TYPE input_parameter_record IS TABLE OF function_parameter_rec%TYPE
985: INDEX BY BINARY_INTEGER;
986: parameter_record input_parameter_record;
987: BEGIN
988: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 10);
989: --{
990:
991: l_first_name_old := pay_us_reporting_utils_pkg.Character_check(rpad(nvl(
992: substr(p_first_name_old,1,15),' '),15));

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

1009: l_emp_number := replace(p_employee_number,' ');
1010:
1011: IF l_emp_number IS NULL THEN
1012: l_emp_name_or_number := l_full_name_new;
1013: hr_utility.trace('Employee Name or Number = '||l_emp_name_or_number);
1014: ELSE
1015: l_emp_name_or_number:= l_emp_number;
1016: hr_utility.trace('Employee Name or Number = '||l_emp_name_or_number);
1017: END IF;

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

1012: l_emp_name_or_number := l_full_name_new;
1013: hr_utility.trace('Employee Name or Number = '||l_emp_name_or_number);
1014: ELSE
1015: l_emp_name_or_number:= l_emp_number;
1016: hr_utility.trace('Employee Name or Number = '||l_emp_name_or_number);
1017: END IF;
1018: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 20);
1019: --
1020: -- Validation for RCW Record Start

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

1014: ELSE
1015: l_emp_name_or_number:= l_emp_number;
1016: hr_utility.trace('Employee Name or Number = '||l_emp_name_or_number);
1017: END IF;
1018: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 20);
1019: --
1020: -- Validation for RCW Record Start
1021: --
1022: -- Originally reported SSN validation and formatting

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

1040: IF p_exclude_from_output = 'Y' THEN
1041: l_exclude_from_output_chk := TRUE;
1042: END IF;
1043: END IF;
1044: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 30);
1045: -- Corrected SSN validation and formatting
1046: l_ssn_new := lpad(' ',9);
1047: l_ssn_new :=
1048: pay_us_reporting_utils_pkg.data_validation( p_effective_date,

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

1061: sp_out_2);
1062: IF p_exclude_from_output = 'Y' THEN
1063: l_exclude_from_output_chk := TRUE;
1064: END IF;
1065: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 40);
1066:
1067: parameter_record(1).p_parameter_name := 'Wages,Tips And Other Compensation';
1068: parameter_record(2).p_parameter_name := 'Federal Income Tax Withheld';
1069: parameter_record(3).p_parameter_name := 'Social Security Wages';

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

1098: -- Negative Value validation for Originally reported wages
1099: -- if Originally reported and coreected values are identical validation and
1100: -- formating are avoided with this check
1101: --
1102: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 50);
1103: if (rcw_wage_rec(i).identical_flag = 'N') then
1104: --{
1105: if rcw_wage_rec(i).wage_old_value <> 0 then
1106: --{

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

1124: IF p_exclude_from_output = 'Y' THEN
1125: l_exclude_from_output_chk := TRUE;
1126: l_err := TRUE;
1127: END IF;
1128: hr_utility.trace(parameter_record(i).p_parameter_name||'Old = '||
1129: rcw_wage_rec(i).wage_old_value_formated);
1130: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
1131: --}
1132: else

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

1126: l_err := TRUE;
1127: END IF;
1128: hr_utility.trace(parameter_record(i).p_parameter_name||'Old = '||
1129: rcw_wage_rec(i).wage_old_value_formated);
1130: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
1131: --}
1132: else
1133: rcw_wage_rec(i).wage_old_value_formated := lpad('0',11,'0');
1134: end if;

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

1131: --}
1132: else
1133: rcw_wage_rec(i).wage_old_value_formated := lpad('0',11,'0');
1134: end if;
1135: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 60);
1136: -- Validation and formating of Corrected Value
1137: --
1138: if rcw_wage_rec(i).wage_new_value <> 0 then
1139: --{

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

1157: IF p_exclude_from_output = 'Y' THEN
1158: l_exclude_from_output_chk := TRUE;
1159: l_err := TRUE;
1160: END IF;
1161: hr_utility.trace(parameter_record(i).p_parameter_name||'New = '||
1162: rcw_wage_rec(i).wage_new_value_formated);
1163: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
1164: --}
1165: else

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

1159: l_err := TRUE;
1160: END IF;
1161: hr_utility.trace(parameter_record(i).p_parameter_name||'New = '||
1162: rcw_wage_rec(i).wage_new_value_formated);
1163: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
1164: --}
1165: else
1166: rcw_wage_rec(i).wage_new_value_formated := lpad('0',11,'0');
1167: end if;

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

1167: end if;
1168: --}
1169: end if;
1170: END LOOP;
1171: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 70);
1172: hr_utility.trace('SS Wage and Tax limit Checking begins.' );
1173: OPEN get_ss_limit(p_effective_date);
1174: LOOP
1175: FETCH get_ss_limit INTO l_ss_wage_limit,

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

1168: --}
1169: end if;
1170: END LOOP;
1171: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 70);
1172: hr_utility.trace('SS Wage and Tax limit Checking begins.' );
1173: OPEN get_ss_limit(p_effective_date);
1174: LOOP
1175: FETCH get_ss_limit INTO l_ss_wage_limit,
1176: l_ss_tax_limit;

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

1173: OPEN get_ss_limit(p_effective_date);
1174: LOOP
1175: FETCH get_ss_limit INTO l_ss_wage_limit,
1176: l_ss_tax_limit;
1177: hr_utility.trace('SS Wage Limit '||to_char(l_ss_wage_limit));
1178: l_ss_count:= get_ss_limit%ROWCOUNT;
1179: EXIT WHEN get_ss_limit%NOTFOUND ;
1180: END LOOP;
1181: CLOSE get_ss_limit;

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

1178: l_ss_count:= get_ss_limit%ROWCOUNT;
1179: EXIT WHEN get_ss_limit%NOTFOUND ;
1180: END LOOP;
1181: CLOSE get_ss_limit;
1182: hr_utility.trace('No. rows exist for limit '||to_char(l_ss_count));
1183:
1184: IF l_ss_count = 0 THEN
1185: hr_utility.trace('No data found on PAY_US_FEDERAL_TAX_INFO_F '||
1186: 'for Social security wage limits.');

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

1181: CLOSE get_ss_limit;
1182: hr_utility.trace('No. rows exist for limit '||to_char(l_ss_count));
1183:
1184: IF l_ss_count = 0 THEN
1185: hr_utility.trace('No data found on PAY_US_FEDERAL_TAX_INFO_F '||
1186: 'for Social security wage limits.');
1187: ELSIF l_ss_count >1 THEN
1188: hr_utility.trace('Too many rows on PAY_US_FEDERAL_TAX_INFO_F '||
1189: 'for Social security wage limits.');

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

1184: IF l_ss_count = 0 THEN
1185: hr_utility.trace('No data found on PAY_US_FEDERAL_TAX_INFO_F '||
1186: 'for Social security wage limits.');
1187: ELSIF l_ss_count >1 THEN
1188: hr_utility.trace('Too many rows on PAY_US_FEDERAL_TAX_INFO_F '||
1189: 'for Social security wage limits.');
1190: ELSIF l_ss_count=1 THEN
1191: --{
1192: hr_utility.trace('SS Wage (Box-3 '||to_char(rcw_wage_rec(3).wage_new_value));

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

1188: hr_utility.trace('Too many rows on PAY_US_FEDERAL_TAX_INFO_F '||
1189: 'for Social security wage limits.');
1190: ELSIF l_ss_count=1 THEN
1191: --{
1192: hr_utility.trace('SS Wage (Box-3 '||to_char(rcw_wage_rec(3).wage_new_value));
1193: hr_utility.trace('SS Tax w/h (Box-4) '||to_char(rcw_wage_rec(4).wage_new_value));
1194: hr_utility.trace('SS Tips (Box-7) '||to_char(rcw_wage_rec(7).wage_new_value));
1195:
1196: IF (rcw_wage_rec(3).wage_new_value > 0 OR

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

1189: 'for Social security wage limits.');
1190: ELSIF l_ss_count=1 THEN
1191: --{
1192: hr_utility.trace('SS Wage (Box-3 '||to_char(rcw_wage_rec(3).wage_new_value));
1193: hr_utility.trace('SS Tax w/h (Box-4) '||to_char(rcw_wage_rec(4).wage_new_value));
1194: hr_utility.trace('SS Tips (Box-7) '||to_char(rcw_wage_rec(7).wage_new_value));
1195:
1196: IF (rcw_wage_rec(3).wage_new_value > 0 OR
1197: rcw_wage_rec(4).wage_new_value > 0 OR

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

1190: ELSIF l_ss_count=1 THEN
1191: --{
1192: hr_utility.trace('SS Wage (Box-3 '||to_char(rcw_wage_rec(3).wage_new_value));
1193: hr_utility.trace('SS Tax w/h (Box-4) '||to_char(rcw_wage_rec(4).wage_new_value));
1194: hr_utility.trace('SS Tips (Box-7) '||to_char(rcw_wage_rec(7).wage_new_value));
1195:
1196: IF (rcw_wage_rec(3).wage_new_value > 0 OR
1197: rcw_wage_rec(4).wage_new_value > 0 OR
1198: rcw_wage_rec(7).wage_new_value > 0 )

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

1197: rcw_wage_rec(4).wage_new_value > 0 OR
1198: rcw_wage_rec(7).wage_new_value > 0 )
1199: THEN
1200: --{
1201: hr_utility.trace('SS Tax w/h, SS Tips, SS Wages are >0 ');
1202: IF (rcw_wage_rec(3).wage_new_value+
1203: rcw_wage_rec(7).wage_new_value) > l_ss_wage_limit
1204: THEN
1205: hr_utility.trace('Sum of SS_Tips and SS_Wages is > '||

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

1201: hr_utility.trace('SS Tax w/h, SS Tips, SS Wages are >0 ');
1202: IF (rcw_wage_rec(3).wage_new_value+
1203: rcw_wage_rec(7).wage_new_value) > l_ss_wage_limit
1204: THEN
1205: hr_utility.trace('Sum of SS_Tips and SS_Wages is > '||
1206: to_char(l_ss_wage_limit));
1207: l_field_description:='the sum of '||
1208: parameter_record(3).p_parameter_name
1209: ||' and '||

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

1221: END IF;
1222: IF rcw_wage_rec(4).wage_new_value > l_ss_tax_limit
1223: THEN
1224: --{
1225: hr_utility.trace('SS Tax w/h is > '||
1226: to_char(l_ss_tax_limit));
1227: l_err := TRUE;
1228: l_amount:=l_ss_tax_limit/100;
1229: l_description:=' It is greater than '||to_char(l_amount);

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

1240: --}
1241: END IF; -- negative check
1242: --}
1243: END IF; --l_ss_count
1244: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 80);
1245: hr_utility.trace('After SS Wage/ Tax limit checking ');
1246: IF l_err THEN
1247: IF p_validate = 'Y' THEN
1248: p_exclude_from_output := 'Y';

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

1241: END IF; -- negative check
1242: --}
1243: END IF; --l_ss_count
1244: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 80);
1245: hr_utility.trace('After SS Wage/ Tax limit checking ');
1246: IF l_err THEN
1247: IF p_validate = 'Y' THEN
1248: p_exclude_from_output := 'Y';
1249: END IF;

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

1256: END IF;
1257: --
1258: -- Validation for RCW record Ends here
1259: --
1260: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 90);
1261: hr_utility.trace('Formating RCW record in MMREF-2 format ');
1262: -- Formatting Wage Record (RCW) for .mf reporting file
1263: --
1264: return_value_mf := 'RCW'

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

1257: --
1258: -- Validation for RCW record Ends here
1259: --
1260: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 90);
1261: hr_utility.trace('Formating RCW record in MMREF-2 format ');
1262: -- Formatting Wage Record (RCW) for .mf reporting file
1263: --
1264: return_value_mf := 'RCW'
1265: ||l_ssn_old

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

1343: ||lpad(p_sickpay_indicator_old,1)
1344: ||lpad(p_sickpay_indicator_new,1)
1345: ||lpad(' ',16);
1346: pay_us_w2c_in_mmref2_format.rcw_mf_record := return_value_mf;
1347: hr_utility.trace('Formating RCW record completed ');
1348: hr_utility.trace('mf Format RCW Record '||pay_us_w2c_in_mmref2_format.rcw_mf_record);
1349: hr_utility.trace('Length of FLAT Format RCW Record '||to_char(length(pay_us_w2c_in_mmref2_format.rcw_mf_record)));
1350: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 100);
1351: --}

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

1344: ||lpad(p_sickpay_indicator_new,1)
1345: ||lpad(' ',16);
1346: pay_us_w2c_in_mmref2_format.rcw_mf_record := return_value_mf;
1347: hr_utility.trace('Formating RCW record completed ');
1348: hr_utility.trace('mf Format RCW Record '||pay_us_w2c_in_mmref2_format.rcw_mf_record);
1349: hr_utility.trace('Length of FLAT Format RCW Record '||to_char(length(pay_us_w2c_in_mmref2_format.rcw_mf_record)));
1350: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 100);
1351: --}
1352: -- Formatting CSV format of RCW record

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

1345: ||lpad(' ',16);
1346: pay_us_w2c_in_mmref2_format.rcw_mf_record := return_value_mf;
1347: hr_utility.trace('Formating RCW record completed ');
1348: hr_utility.trace('mf Format RCW Record '||pay_us_w2c_in_mmref2_format.rcw_mf_record);
1349: hr_utility.trace('Length of FLAT Format RCW Record '||to_char(length(pay_us_w2c_in_mmref2_format.rcw_mf_record)));
1350: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 100);
1351: --}
1352: -- Formatting CSV format of RCW record
1353: --{

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

1346: pay_us_w2c_in_mmref2_format.rcw_mf_record := return_value_mf;
1347: hr_utility.trace('Formating RCW record completed ');
1348: hr_utility.trace('mf Format RCW Record '||pay_us_w2c_in_mmref2_format.rcw_mf_record);
1349: hr_utility.trace('Length of FLAT Format RCW Record '||to_char(length(pay_us_w2c_in_mmref2_format.rcw_mf_record)));
1350: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 100);
1351: --}
1352: -- Formatting CSV format of RCW record
1353: --{
1354: hr_utility.trace('Formating RCW record in CSV format');

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

1350: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 100);
1351: --}
1352: -- Formatting CSV format of RCW record
1353: --{
1354: hr_utility.trace('Formating RCW record in CSV format');
1355:
1356: if l_exclude_from_output_chk then
1357: -- {
1358: -- This will be used for a02 record because this gets the actual values

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

1519:
1520: end if; /* l_exclude_from_output_chk */
1521:
1522: pay_us_w2c_in_mmref2_format.rcw_csv_record := return_value_csv;
1523: hr_utility.trace('CSV Format RCW Record '||pay_us_w2c_in_mmref2_format.rcw_csv_record);
1524: hr_utility.trace('Length of CSV Format RCW Record '||to_char(length(pay_us_w2c_in_mmref2_format.rcw_csv_record)));
1525: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 110);
1526: --}
1527: -- Format Blank RCW record in MMREF-2 format

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

1520: end if; /* l_exclude_from_output_chk */
1521:
1522: pay_us_w2c_in_mmref2_format.rcw_csv_record := return_value_csv;
1523: hr_utility.trace('CSV Format RCW Record '||pay_us_w2c_in_mmref2_format.rcw_csv_record);
1524: hr_utility.trace('Length of CSV Format RCW Record '||to_char(length(pay_us_w2c_in_mmref2_format.rcw_csv_record)));
1525: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 110);
1526: --}
1527: -- Format Blank RCW record in MMREF-2 format
1528: -- This Blank record would be used when RCO record is moved to .a02 for error

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

1521:
1522: pay_us_w2c_in_mmref2_format.rcw_csv_record := return_value_csv;
1523: hr_utility.trace('CSV Format RCW Record '||pay_us_w2c_in_mmref2_format.rcw_csv_record);
1524: hr_utility.trace('Length of CSV Format RCW Record '||to_char(length(pay_us_w2c_in_mmref2_format.rcw_csv_record)));
1525: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 110);
1526: --}
1527: -- Format Blank RCW record in MMREF-2 format
1528: -- This Blank record would be used when RCO record is moved to .a02 for error
1529: --{

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

1527: -- Format Blank RCW record in MMREF-2 format
1528: -- This Blank record would be used when RCO record is moved to .a02 for error
1529: --{
1530:
1531: hr_utility.trace('Formatting BLANK RCW Record ');
1532: return_value_blank :=
1533: ' '
1534: ||','||' '
1535: ||','||' '

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

1600: ||','||' '
1601: ||','||' '
1602: ||','||' ';
1603: pay_us_w2c_in_mmref2_format.rcw_blank_csv_record := return_value_blank;
1604: hr_utility.trace('CSV Blank Format RCW Record '||pay_us_w2c_in_mmref2_format.rcw_blank_csv_record);
1605: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 120);
1606: --}
1607:
1608: hr_utility.trace('p_exclude_from_output ->'||p_exclude_from_output);

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

1601: ||','||' '
1602: ||','||' ';
1603: pay_us_w2c_in_mmref2_format.rcw_blank_csv_record := return_value_blank;
1604: hr_utility.trace('CSV Blank Format RCW Record '||pay_us_w2c_in_mmref2_format.rcw_blank_csv_record);
1605: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 120);
1606: --}
1607:
1608: hr_utility.trace('p_exclude_from_output ->'||p_exclude_from_output);
1609: p_error := l_exclude_from_output_chk;

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

1604: hr_utility.trace('CSV Blank Format RCW Record '||pay_us_w2c_in_mmref2_format.rcw_blank_csv_record);
1605: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 120);
1606: --}
1607:
1608: hr_utility.trace('p_exclude_from_output ->'||p_exclude_from_output);
1609: p_error := l_exclude_from_output_chk;
1610: ret_str_len:=length(return_value_mf);
1611: return return_value_mf;
1612: END format_W2C_RCW_record;

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

1661: INDEX BY BINARY_INTEGER;
1662: parameter_record input_parameter_record;
1663:
1664: BEGIN
1665: hr_utility.set_location(gv_package || '.format_W2C_RCO_record', 10);
1666: --{
1667:
1668: l_full_name_new := substr(pay_us_reporting_utils_pkg.Character_check(ltrim(rtrim(p_first_name_new)||' '||
1669: rtrim(p_last_name_new))),1,50);

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

1671: l_emp_number := replace(p_employee_number,' ');
1672:
1673: IF l_emp_number IS NULL THEN
1674: l_emp_name_or_number := l_full_name_new;
1675: hr_utility.trace('Employee Name or Number = '||l_emp_name_or_number);
1676: ELSE
1677: l_emp_name_or_number:= l_emp_number;
1678: hr_utility.trace('Employee Name or Number = '||l_emp_name_or_number);
1679: END IF;

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

1674: l_emp_name_or_number := l_full_name_new;
1675: hr_utility.trace('Employee Name or Number = '||l_emp_name_or_number);
1676: ELSE
1677: l_emp_name_or_number:= l_emp_number;
1678: hr_utility.trace('Employee Name or Number = '||l_emp_name_or_number);
1679: END IF;
1680: hr_utility.set_location(gv_package || '.format_W2C_RCO_record', 20);
1681: --
1682: -- Validation for RCO Record Start

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

1676: ELSE
1677: l_emp_name_or_number:= l_emp_number;
1678: hr_utility.trace('Employee Name or Number = '||l_emp_name_or_number);
1679: END IF;
1680: hr_utility.set_location(gv_package || '.format_W2C_RCO_record', 20);
1681: --
1682: -- Validation for RCO Record Start
1683: --
1684: parameter_record(1).p_parameter_name:= ' allocated tips';

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

1696: -- Negative Value validation for Originally reported wages
1697: -- if Originally reported and coreected values are identical validation and
1698: -- formating are avoided with this check
1699: --
1700: hr_utility.set_location(gv_package || '.format_W2C_RCO_record', 30);
1701: if (rco_wage_rec(i).identical_flag = 'N') then
1702: --{
1703: if rco_wage_rec(i).wage_old_value <> 0 then
1704: --{

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

1722: IF p_exclude_from_output = 'Y' THEN
1723: l_exclude_from_output_chk := TRUE;
1724: l_err := TRUE;
1725: END IF;
1726: hr_utility.trace(parameter_record(i).p_parameter_name||'Old = '||
1727: rco_wage_rec(i).wage_old_value_formated);
1728: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
1729: --}
1730: else

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

1724: l_err := TRUE;
1725: END IF;
1726: hr_utility.trace(parameter_record(i).p_parameter_name||'Old = '||
1727: rco_wage_rec(i).wage_old_value_formated);
1728: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
1729: --}
1730: else
1731: rco_wage_rec(i).wage_old_value_formated := lpad('0',11,'0');
1732: end if;

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

1729: --}
1730: else
1731: rco_wage_rec(i).wage_old_value_formated := lpad('0',11,'0');
1732: end if;
1733: hr_utility.set_location(gv_package || '.format_W2C_RCW_record', 40);
1734: -- Validation and formating of Corrected Value
1735: --
1736: if rco_wage_rec(i).wage_new_value <> 0 then
1737: --{

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

1755: IF p_exclude_from_output = 'Y' THEN
1756: l_exclude_from_output_chk := TRUE;
1757: l_err := TRUE;
1758: END IF;
1759: hr_utility.trace(parameter_record(i).p_parameter_name||'New = '||
1760: rco_wage_rec(i).wage_new_value_formated);
1761: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
1762: --}
1763: else

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

1757: l_err := TRUE;
1758: END IF;
1759: hr_utility.trace(parameter_record(i).p_parameter_name||'New = '||
1760: rco_wage_rec(i).wage_new_value_formated);
1761: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
1762: --}
1763: else
1764: rco_wage_rec(i).wage_new_value_formated := lpad('0',11,'0');
1765: end if;

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

1765: end if;
1766: --}
1767: end if;
1768: END LOOP;
1769: hr_utility.set_location(gv_package || '.format_W2C_RCO_record', 50);
1770: if l_err then
1771: p_exclude_from_output := 'Y';
1772: end if;
1773:

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

1778: END IF;
1779: --
1780: -- Validation for RCO record Ends here
1781: --
1782: hr_utility.set_location(gv_package || '.format_W2C_RCO_record', 60);
1783: hr_utility.trace('Formating RCO record in MMREF-2 format ');
1784: -- Formatting Wage Record (RCO) for .mf reporting file
1785: --
1786: return_value_mf := 'RCO'

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

1779: --
1780: -- Validation for RCO record Ends here
1781: --
1782: hr_utility.set_location(gv_package || '.format_W2C_RCO_record', 60);
1783: hr_utility.trace('Formating RCO record in MMREF-2 format ');
1784: -- Formatting Wage Record (RCO) for .mf reporting file
1785: --
1786: return_value_mf := 'RCO'
1787: ||lpad(' ',9)

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

1802: ||rco_wage_rec(8).wage_old_value_formated
1803: ||rco_wage_rec(8).wage_new_value_formated
1804: ||lpad(' ',836);
1805: pay_us_w2c_in_mmref2_format.rco_mf_record := return_value_mf;
1806: hr_utility.trace('Formating RCO record completed ');
1807: hr_utility.trace('mf Format RCO Record '||pay_us_w2c_in_mmref2_format.rco_mf_record);
1808: hr_utility.trace('Length of FLAT Format RCO Record '||to_char(length(pay_us_w2c_in_mmref2_format.rco_mf_record)));
1809: hr_utility.set_location(gv_package || '.format_W2C_RCO_record', 70);
1810: --}

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

1803: ||rco_wage_rec(8).wage_new_value_formated
1804: ||lpad(' ',836);
1805: pay_us_w2c_in_mmref2_format.rco_mf_record := return_value_mf;
1806: hr_utility.trace('Formating RCO record completed ');
1807: hr_utility.trace('mf Format RCO Record '||pay_us_w2c_in_mmref2_format.rco_mf_record);
1808: hr_utility.trace('Length of FLAT Format RCO Record '||to_char(length(pay_us_w2c_in_mmref2_format.rco_mf_record)));
1809: hr_utility.set_location(gv_package || '.format_W2C_RCO_record', 70);
1810: --}
1811: -- Formatting CSV format of RCO record

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

1804: ||lpad(' ',836);
1805: pay_us_w2c_in_mmref2_format.rco_mf_record := return_value_mf;
1806: hr_utility.trace('Formating RCO record completed ');
1807: hr_utility.trace('mf Format RCO Record '||pay_us_w2c_in_mmref2_format.rco_mf_record);
1808: hr_utility.trace('Length of FLAT Format RCO Record '||to_char(length(pay_us_w2c_in_mmref2_format.rco_mf_record)));
1809: hr_utility.set_location(gv_package || '.format_W2C_RCO_record', 70);
1810: --}
1811: -- Formatting CSV format of RCO record
1812: --{

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

1805: pay_us_w2c_in_mmref2_format.rco_mf_record := return_value_mf;
1806: hr_utility.trace('Formating RCO record completed ');
1807: hr_utility.trace('mf Format RCO Record '||pay_us_w2c_in_mmref2_format.rco_mf_record);
1808: hr_utility.trace('Length of FLAT Format RCO Record '||to_char(length(pay_us_w2c_in_mmref2_format.rco_mf_record)));
1809: hr_utility.set_location(gv_package || '.format_W2C_RCO_record', 70);
1810: --}
1811: -- Formatting CSV format of RCO record
1812: --{
1813: hr_utility.trace('Formating RCO record in CSV format');

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

1809: hr_utility.set_location(gv_package || '.format_W2C_RCO_record', 70);
1810: --}
1811: -- Formatting CSV format of RCO record
1812: --{
1813: hr_utility.trace('Formating RCO record in CSV format');
1814:
1815: if l_exclude_from_output_chk then
1816: -- {
1817: -- This will be used for a02 record because this gets the actual values

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

1872: end if;
1873:
1874: /* Bug 4097321 - Commented following code. The Assignment is done inside the IF..ELSE above
1875: pay_us_w2c_in_mmref2_format.rco_csv_record := return_value_csv; */
1876: hr_utility.trace('CSV Format RCO Record '||pay_us_w2c_in_mmref2_format.rco_csv_record);
1877: hr_utility.set_location(gv_package || '.format_W2C_RCO_record', 80);
1878: --}
1879: -- Format Blank RCO record in MMREF-2 format
1880: -- This Blank record would be used when RCO record is moved to .a02 for error

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

1873:
1874: /* Bug 4097321 - Commented following code. The Assignment is done inside the IF..ELSE above
1875: pay_us_w2c_in_mmref2_format.rco_csv_record := return_value_csv; */
1876: hr_utility.trace('CSV Format RCO Record '||pay_us_w2c_in_mmref2_format.rco_csv_record);
1877: hr_utility.set_location(gv_package || '.format_W2C_RCO_record', 80);
1878: --}
1879: -- Format Blank RCO record in MMREF-2 format
1880: -- This Blank record would be used when RCO record is moved to .a02 for error
1881: --{

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

1879: -- Format Blank RCO record in MMREF-2 format
1880: -- This Blank record would be used when RCO record is moved to .a02 for error
1881: --{
1882:
1883: hr_utility.trace('Formatting BLANK RCO Record ');
1884: return_value_blank := ','
1885: ||' '
1886: ||','||lpad(' ',9)
1887: ||','||' '

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

1899: ||','||' '
1900: ||','||' '
1901: ||','||' ';
1902: pay_us_w2c_in_mmref2_format.rco_blank_csv_record := return_value_blank;
1903: hr_utility.trace('CSV Blank Format RCO Record '||pay_us_w2c_in_mmref2_format.rcw_blank_csv_record);
1904: hr_utility.set_location(gv_package || '.format_W2C_RCO_record', 90);
1905: --}
1906:
1907: hr_utility.trace('p_exclude_from_output ->'||p_exclude_from_output);

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

1900: ||','||' '
1901: ||','||' ';
1902: pay_us_w2c_in_mmref2_format.rco_blank_csv_record := return_value_blank;
1903: hr_utility.trace('CSV Blank Format RCO Record '||pay_us_w2c_in_mmref2_format.rcw_blank_csv_record);
1904: hr_utility.set_location(gv_package || '.format_W2C_RCO_record', 90);
1905: --}
1906:
1907: hr_utility.trace('p_exclude_from_output ->'||p_exclude_from_output);
1908: p_error := l_exclude_from_output_chk;

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

1903: hr_utility.trace('CSV Blank Format RCO Record '||pay_us_w2c_in_mmref2_format.rcw_blank_csv_record);
1904: hr_utility.set_location(gv_package || '.format_W2C_RCO_record', 90);
1905: --}
1906:
1907: hr_utility.trace('p_exclude_from_output ->'||p_exclude_from_output);
1908: p_error := l_exclude_from_output_chk;
1909: ret_str_len:=length(return_value_mf);
1910: hr_utility.trace('format W2C RCO return_value_mf ->'||return_value_mf);
1911: return return_value_mf;

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

1906:
1907: hr_utility.trace('p_exclude_from_output ->'||p_exclude_from_output);
1908: p_error := l_exclude_from_output_chk;
1909: ret_str_len:=length(return_value_mf);
1910: hr_utility.trace('format W2C RCO return_value_mf ->'||return_value_mf);
1911: return return_value_mf;
1912: END format_W2C_RCO_record;
1913: -- End of Formatting RCW in MMREF-2 format
1914:

Line 1916: --hr_utility.trace_on(null,'W2CFMTREC');

1912: END format_W2C_RCO_record;
1913: -- End of Formatting RCW in MMREF-2 format
1914:
1915: --BEGIN
1916: --hr_utility.trace_on(null,'W2CFMTREC');
1917: END pay_us_mmrf2_w2c_format_record; -- End of Package Body