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_IE_TAX_VAL dependencies on PAY_IE_TAX_ERROR

Line 87: Delete from pay_ie_tax_error;

83: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
84:
85:
86: Begin
87: Delete from pay_ie_tax_error;
88: if sql%rowcount > 0 then
89: commit;
90: end if;
91: exception

Line 94: PAY_IE_TAX_ERROR table');

90: end if;
91: exception
92: when others then
93: FND_FILE.PUT_LINE(fnd_file.log,'Error occured while deleting exisiting rows in
94: PAY_IE_TAX_ERROR table');
95: end;
96:
97: UPDATE PAY_IE_TAX_BODY_INTERFACE
98: SET EMPLOYER_NUMBER =

Line 225: INSERT INTO pay_ie_tax_error ( pps_number

221: FND_FILE.PUT_LINE(fnd_file.log,
222: 'does not match the total weekly credit in pay_ie_tax_trailer_interface.total_wk_tax_credit');
223: END IF;
224:
225: INSERT INTO pay_ie_tax_error ( pps_number
226: , employee_number
227: , full_name
228: , payroll_name
229: , error_stack_message

Line 251: INSERT INTO pay_ie_tax_error ( pps_number

247: retcode := 2;
248: FND_FILE.PUT_LINE (fnd_file.log, 'Error raised in loading data into one or all of the follo
249: wing tables: pay_ie_tax_header_interface, pay_ie_tax_body_interface, pay_ie_tax_trailer_interface');
250:
251: INSERT INTO pay_ie_tax_error ( pps_number
252: , employee_number
253: , full_name
254: , payroll_name
255: , error_stack_message

Line 1082: -- INSERT INTO pay_ie_tax_error ( pps_number

1078: -- );
1079: --
1080: -- -- The exception details are written to an error table
1081: --
1082: -- INSERT INTO pay_ie_tax_error ( pps_number
1083: -- , employee_number
1084: -- , full_name
1085: -- , payroll_name
1086: -- , tax_district

Line 1120: -- INSERT INTO pay_ie_tax_error ( pps_number

1116: -- );
1117: --
1118: -- -- The exception details are written to an error table
1119: --
1120: -- INSERT INTO pay_ie_tax_error ( pps_number
1121: -- , employee_number
1122: -- , full_name
1123: -- , payroll_name
1124: -- , tax_district

Line 1154: INSERT INTO pay_ie_tax_error ( pps_number

1150: r_pay.payroll_name_hr
1151: );
1152: -- The exception details are written to an error table
1153:
1154: INSERT INTO pay_ie_tax_error ( pps_number
1155: , employee_number
1156: , full_name
1157: , payroll_name
1158: , tax_district

Line 1196: INSERT INTO pay_ie_tax_error ( pps_number

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
1197: , employee_number
1198: , full_name
1199: , payroll_name
1200: , tax_district

Line 1239: INSERT INTO pay_ie_tax_error ( pps_number

1235: -- 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 : Higher Rate of Tax cannot be Null');
1236: --END IF;
1237:
1238: -- The exception details are written to an error table
1239: INSERT INTO pay_ie_tax_error ( pps_number
1240: , employee_number
1241: , full_name
1242: , payroll_name
1243: , tax_district

Line 1283: INSERT INTO pay_ie_tax_error ( pps_number

1279: -- 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 : Exemption Indicator cannot be Null');
1280: --END IF;
1281:
1282: -- The exception details are written to an error table
1283: INSERT INTO pay_ie_tax_error ( pps_number
1284: , employee_number
1285: , full_name
1286: , payroll_name
1287: , tax_district

Line 1326: INSERT INTO pay_ie_tax_error ( pps_number

1322: -- 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 : The higher rate of tax for Exemption should be '||l_tax_rate_exempt||'%');
1323: --END IF;
1324:
1325: -- The exception details are written to an error table
1326: INSERT INTO pay_ie_tax_error ( pps_number
1327: , employee_number
1328: , full_name
1329: , payroll_name
1330: , tax_district

Line 1369: INSERT INTO pay_ie_tax_error ( pps_number

1365: -- 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 : The higher rate of tax for Cumulative or Week1/Month1 Tax Basis should be '||l_tax_rate_high||'%');
1366: --END IF;
1367:
1368: -- The exception details are written to an error table
1369: INSERT INTO pay_ie_tax_error ( pps_number
1370: , employee_number
1371: , full_name
1372: , payroll_name
1373: , tax_district

Line 1412: INSERT INTO pay_ie_tax_error ( pps_number

1408: -- 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 : Total Pay to Date and Total Tax to Date can be null only for Week1/Month1 basis');
1409: --END IF;
1410:
1411: -- The exception details are written to an error table
1412: INSERT INTO pay_ie_tax_error ( pps_number
1413: , employee_number
1414: , full_name
1415: , payroll_name
1416: , tax_district

Line 1467: INSERT INTO pay_ie_tax_error ( pps_number

1463: -- 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 : '||l_error);
1464: --END IF;
1465: -- The exception details are written to an error table
1466:
1467: INSERT INTO pay_ie_tax_error ( pps_number
1468: , employee_number
1469: , full_name
1470: , payroll_name
1471: , tax_district

Line 1555: INSERT INTO pay_ie_tax_error ( pps_number

1551: l_error := SQLERRM;
1552: retcode := 1;
1553: FND_FILE.PUT_LINE(fnd_file.log, 'No data found');
1554:
1555: INSERT INTO pay_ie_tax_error ( pps_number
1556: , employee_number
1557: , full_name
1558: , payroll_name
1559: , tax_district

Line 1602: INSERT INTO pay_ie_tax_error ( pps_number

1598: --ELSE
1599: -- fnd_file.put_line(fnd_file.output,lpad(l_pps_number_int,20,' ')||lpad(substr(l_employee_number_int,1,12),13,' ')||lpad(' ',20,' ')||'Failed : OTHER in Main..'||l_error);
1600: --END IF;
1601: /* The exception details are written to an error table */
1602: INSERT INTO pay_ie_tax_error ( pps_number
1603: , employee_number
1604: , full_name
1605: , payroll_name
1606: , tax_district