DBA Data[Home] [Help]

APPS.PAY_IE_TAX_VAL dependencies on STANDARD

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

453: -- This is called only once to set the report fields.
454: fnd_file.put_line(fnd_file.output,'Index');
455: fnd_file.put_line(fnd_file.output,'I :- Week1/Month1 Indicator');
456: fnd_file.put_line(fnd_file.output,'F :- Exemption Flag');
457: fnd_file.put_line(fnd_file.output,'Tax1 :- Standard Rate of Tax');
458: fnd_file.put_line(fnd_file.output,'Tax2 :- Higher Rate of Tax');
459: fnd_file.put_line(fnd_file.output,'U :- USC Exemption Flag');
460: fnd_file.put_line(fnd_file.output,' ');
461:

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

593: ppsno_cnt := ppsno_cnt+1;
594: l_pps_number(ppsno_cnt) :=r_pay.pps_number_hr;
595: --fnd_file.put_line(l_pps_number(ppsno_cnt));
596: hr_utility.set_location('PPS Number..'||l_pps_number_hr,420);
597: -- checks for standard rate tax to be mandatory
598: IF l_std_rate_of_tax IS NULL THEN
599: raise std_rate_of_tax_is_null;
600: END IF; --l_std_rate_of_tax
601: -- checks for higher rate of tax to be mandatory

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

1148: , sysdate);
1149: COMMIT;*/
1150:
1151: WHEN std_rate_of_tax_is_null THEN
1152: l_error := 'Standard Rate of Tax cannot be Null';--SQLERRM;
1153: retcode := 1;
1154: FND_FILE.PUT_LINE(fnd_file.log, 'Standard Rate of Tax cannot be Null');
1155:
1156: FND_FILE.NEW_LINE(fnd_file.log, 1);

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

1150:
1151: WHEN std_rate_of_tax_is_null THEN
1152: l_error := 'Standard Rate of Tax cannot be Null';--SQLERRM;
1153: retcode := 1;
1154: FND_FILE.PUT_LINE(fnd_file.log, 'Standard Rate of Tax cannot be Null');
1155:
1156: FND_FILE.NEW_LINE(fnd_file.log, 1);
1157: /*FND_FILE.PUT_LINE(fnd_file.output, r_pay.pps_number_hr ||','||
1158: r_pay.employee_no_hr ||', '||

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

1162: );*/
1163: --IF p_validate_mode in ('IE_VALIDATE') THEN
1164: l_err_tab(err_cnt).p_pps_number := r_pay.pps_number_int;
1165: l_err_tab(err_cnt).p_works_number := substr(r_pay.employee_no_int,1,12);
1166: l_err_tab(err_cnt).p_err_msg := 'Failed : Standard Rate of Tax cannot be Null';
1167: err_cnt := err_cnt + 1;
1168: --ELSE
1169: -- 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');
1170: --END IF;

Line 1169: -- 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');

1165: l_err_tab(err_cnt).p_works_number := substr(r_pay.employee_no_int,1,12);
1166: l_err_tab(err_cnt).p_err_msg := 'Failed : Standard Rate of Tax cannot be Null';
1167: err_cnt := err_cnt + 1;
1168: --ELSE
1169: -- 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');
1170: --END IF;
1171: -- The exception details are written to an error table
1172:
1173: INSERT INTO pay_ie_tax_error ( pps_number

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

3600: -- This is called only once to set the report fields.
3601: fnd_file.put_line(fnd_file.output,'Index');
3602: fnd_file.put_line(fnd_file.output,'I :- Week1/Month1 Indicator');
3603: fnd_file.put_line(fnd_file.output,'F :- Exemption Flag');
3604: fnd_file.put_line(fnd_file.output,'Tax1 :- Standard Rate of Tax');
3605: fnd_file.put_line(fnd_file.output,'Tax2 :- Higher Rate of Tax');
3606: fnd_file.put_line(fnd_file.output,' ');
3607:
3608: fnd_file.put_line(fnd_file.output,lpad('PAYE Details in Oracle Payroll',70,' ')||lpad('PAYE Details from Revenue',105,' '));

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

3720: ppsno_cnt := ppsno_cnt+1;
3721: l_pps_number(ppsno_cnt) :=r_pay.pps_number_hr;
3722: --fnd_file.put_line(l_pps_number(ppsno_cnt));
3723: hr_utility.set_location('PPS Number..'||l_pps_number_hr,420);
3724: -- checks for standard rate tax to be mandatory
3725: IF l_std_rate_of_tax IS NULL THEN
3726: raise std_rate_of_tax_is_null;
3727: END IF; --l_std_rate_of_tax
3728: -- checks for higher rate of tax to be mandatory

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

4139: , sysdate);
4140: COMMIT;*/
4141:
4142: WHEN std_rate_of_tax_is_null THEN
4143: l_error := 'Standard Rate of Tax cannot be Null';--SQLERRM;
4144: retcode := 1;
4145: FND_FILE.PUT_LINE(fnd_file.log, 'Standard Rate of Tax cannot be Null');
4146:
4147: FND_FILE.NEW_LINE(fnd_file.log, 1);

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

4141:
4142: WHEN std_rate_of_tax_is_null THEN
4143: l_error := 'Standard Rate of Tax cannot be Null';--SQLERRM;
4144: retcode := 1;
4145: FND_FILE.PUT_LINE(fnd_file.log, 'Standard Rate of Tax cannot be Null');
4146:
4147: FND_FILE.NEW_LINE(fnd_file.log, 1);
4148: /*FND_FILE.PUT_LINE(fnd_file.output, r_pay.pps_number_hr ||','||
4149: r_pay.employee_no_hr ||', '||

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

4153: );*/
4154: --IF p_validate_mode in ('IE_VALIDATE') THEN
4155: l_err_tab(err_cnt).p_pps_number := r_pay.pps_number_int;
4156: l_err_tab(err_cnt).p_works_number := substr(r_pay.employee_no_int,1,12);
4157: l_err_tab(err_cnt).p_err_msg := 'Failed : Standard Rate of Tax cannot be Null';
4158: err_cnt := err_cnt + 1;
4159: --ELSE
4160: -- 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');
4161: --END IF;

Line 4160: -- 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');

4156: l_err_tab(err_cnt).p_works_number := substr(r_pay.employee_no_int,1,12);
4157: l_err_tab(err_cnt).p_err_msg := 'Failed : Standard Rate of Tax cannot be Null';
4158: err_cnt := err_cnt + 1;
4159: --ELSE
4160: -- 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');
4161: --END IF;
4162: -- The exception details are written to an error table
4163:
4164: INSERT INTO pay_ie_tax_error ( pps_number