DBA Data[Home] [Help]

APPS.PAY_IE_TAX_VAL dependencies on STANDARD

Line 636: fnd_file.put_line(fnd_file.output,'Tax1 :- Standard Rate of Tax');

632: -- This is called only once to set the report fields.
633: fnd_file.put_line(fnd_file.output,'Index');
634: fnd_file.put_line(fnd_file.output,'I :- Week1/Month1 Indicator');
635: fnd_file.put_line(fnd_file.output,'F :- Exemption Flag');
636: fnd_file.put_line(fnd_file.output,'Tax1 :- Standard Rate of Tax');
637: fnd_file.put_line(fnd_file.output,'Tax2 :- Higher Rate of Tax');
638: fnd_file.put_line(fnd_file.output,' ');
639:
640: fnd_file.put_line(fnd_file.output,lpad('PAYE Details in Oracle Payroll',70,' ')||lpad('PAYE Details from Revenue',105,' '));

Line 756: -- checks for standard rate tax to be mandatory

752: ppsno_cnt := ppsno_cnt+1;
753: l_pps_number(ppsno_cnt) :=r_pay.pps_number_hr;
754: --fnd_file.put_line(l_pps_number(ppsno_cnt));
755: hr_utility.set_location('PPS Number..'||l_pps_number_hr,420);
756: -- checks for standard rate tax to be mandatory
757: IF l_std_rate_of_tax IS NULL THEN
758: raise std_rate_of_tax_is_null;
759: END IF; --l_std_rate_of_tax
760: -- checks for higher rate of tax to be mandatory

Line 1175: l_error := 'Standard Rate of Tax cannot be Null';--SQLERRM;

1171: , sysdate);
1172: COMMIT;*/
1173:
1174: WHEN std_rate_of_tax_is_null THEN
1175: l_error := 'Standard Rate of Tax cannot be Null';--SQLERRM;
1176: retcode := 1;
1177: FND_FILE.PUT_LINE(fnd_file.log, 'Standard Rate of Tax cannot be Null');
1178:
1179: FND_FILE.NEW_LINE(fnd_file.log, 1);

Line 1177: FND_FILE.PUT_LINE(fnd_file.log, 'Standard Rate of Tax cannot be Null');

1173:
1174: WHEN std_rate_of_tax_is_null THEN
1175: l_error := 'Standard Rate of Tax cannot be Null';--SQLERRM;
1176: retcode := 1;
1177: FND_FILE.PUT_LINE(fnd_file.log, 'Standard Rate of Tax cannot be Null');
1178:
1179: FND_FILE.NEW_LINE(fnd_file.log, 1);
1180: /*FND_FILE.PUT_LINE(fnd_file.output, r_pay.pps_number_hr ||','||
1181: r_pay.employee_no_hr ||', '||

Line 1189: l_err_tab(err_cnt).p_err_msg := 'Failed : Standard Rate of Tax cannot be Null';

1185: );*/
1186: --IF p_validate_mode in ('IE_VALIDATE') THEN
1187: l_err_tab(err_cnt).p_pps_number := r_pay.pps_number_int;
1188: l_err_tab(err_cnt).p_works_number := substr(r_pay.employee_no_int,1,12);
1189: l_err_tab(err_cnt).p_err_msg := 'Failed : Standard Rate of Tax cannot be Null';
1190: err_cnt := err_cnt + 1;
1191: --ELSE
1192: -- fnd_file.put_line(fnd_file.output,lpad(r_pay.pps_number_int,11,' ')||lpad(substr(r_pay.employee_no_int,1,12),13,' ')||lpad(' ',20,' ')||'Failed : Standard Rate of Tax cannot be Null');
1193: --END IF;

Line 1192: -- fnd_file.put_line(fnd_file.output,lpad(r_pay.pps_number_int,11,' ')||lpad(substr(r_pay.employee_no_int,1,12),13,' ')||lpad(' ',20,' ')||'Failed : Standard Rate of Tax cannot be Null');

1188: l_err_tab(err_cnt).p_works_number := substr(r_pay.employee_no_int,1,12);
1189: l_err_tab(err_cnt).p_err_msg := 'Failed : Standard Rate of Tax cannot be Null';
1190: err_cnt := err_cnt + 1;
1191: --ELSE
1192: -- fnd_file.put_line(fnd_file.output,lpad(r_pay.pps_number_int,11,' ')||lpad(substr(r_pay.employee_no_int,1,12),13,' ')||lpad(' ',20,' ')||'Failed : Standard Rate of Tax cannot be Null');
1193: --END IF;
1194: -- The exception details are written to an error table
1195:
1196: INSERT INTO pay_ie_tax_error ( pps_number