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

Line 1059: -- INSERT INTO pay_ie_tax_error ( pps_number

1055: -- );
1056: --
1057: -- -- The exception details are written to an error table
1058: --
1059: -- INSERT INTO pay_ie_tax_error ( pps_number
1060: -- , employee_number
1061: -- , full_name
1062: -- , payroll_name
1063: -- , tax_district

Line 1097: -- INSERT INTO pay_ie_tax_error ( pps_number

1093: -- );
1094: --
1095: -- -- The exception details are written to an error table
1096: --
1097: -- INSERT INTO pay_ie_tax_error ( pps_number
1098: -- , employee_number
1099: -- , full_name
1100: -- , payroll_name
1101: -- , tax_district

Line 1131: INSERT INTO pay_ie_tax_error ( pps_number

1127: r_pay.payroll_name_hr
1128: );
1129: -- The exception details are written to an error table
1130:
1131: INSERT INTO pay_ie_tax_error ( pps_number
1132: , employee_number
1133: , full_name
1134: , payroll_name
1135: , tax_district

Line 1173: INSERT INTO pay_ie_tax_error ( pps_number

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
1174: , employee_number
1175: , full_name
1176: , payroll_name
1177: , tax_district

Line 1216: INSERT INTO pay_ie_tax_error ( pps_number

1212: -- 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');
1213: --END IF;
1214:
1215: -- The exception details are written to an error table
1216: INSERT INTO pay_ie_tax_error ( pps_number
1217: , employee_number
1218: , full_name
1219: , payroll_name
1220: , tax_district

Line 1260: INSERT INTO pay_ie_tax_error ( pps_number

1256: -- 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');
1257: --END IF;
1258:
1259: -- The exception details are written to an error table
1260: INSERT INTO pay_ie_tax_error ( pps_number
1261: , employee_number
1262: , full_name
1263: , payroll_name
1264: , tax_district

Line 1303: INSERT INTO pay_ie_tax_error ( pps_number

1299: -- 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||'%');
1300: --END IF;
1301:
1302: -- The exception details are written to an error table
1303: INSERT INTO pay_ie_tax_error ( pps_number
1304: , employee_number
1305: , full_name
1306: , payroll_name
1307: , tax_district

Line 1346: INSERT INTO pay_ie_tax_error ( pps_number

1342: -- 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||'%');
1343: --END IF;
1344:
1345: -- The exception details are written to an error table
1346: INSERT INTO pay_ie_tax_error ( pps_number
1347: , employee_number
1348: , full_name
1349: , payroll_name
1350: , tax_district

Line 1389: INSERT INTO pay_ie_tax_error ( pps_number

1385: -- 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');
1386: --END IF;
1387:
1388: -- The exception details are written to an error table
1389: INSERT INTO pay_ie_tax_error ( pps_number
1390: , employee_number
1391: , full_name
1392: , payroll_name
1393: , tax_district

Line 1444: INSERT INTO pay_ie_tax_error ( pps_number

1440: -- 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);
1441: --END IF;
1442: -- The exception details are written to an error table
1443:
1444: INSERT INTO pay_ie_tax_error ( pps_number
1445: , employee_number
1446: , full_name
1447: , payroll_name
1448: , tax_district

Line 1532: INSERT INTO pay_ie_tax_error ( pps_number

1528: l_error := SQLERRM;
1529: retcode := 1;
1530: FND_FILE.PUT_LINE(fnd_file.log, 'No data found');
1531:
1532: INSERT INTO pay_ie_tax_error ( pps_number
1533: , employee_number
1534: , full_name
1535: , payroll_name
1536: , tax_district

Line 1579: INSERT INTO pay_ie_tax_error ( pps_number

1575: --ELSE
1576: -- 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);
1577: --END IF;
1578: /* The exception details are written to an error table */
1579: INSERT INTO pay_ie_tax_error ( pps_number
1580: , employee_number
1581: , full_name
1582: , payroll_name
1583: , tax_district

Line 1728: Delete from pay_ie_tax_error;

1724: BEGIN
1725: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
1726:
1727: Begin
1728: Delete from pay_ie_tax_error;
1729: if sql%rowcount > 0 then
1730: commit;
1731: end if;
1732: exception

Line 1734: FND_FILE.PUT_LINE(fnd_file.log,'Error occured while deleting exisiting rows in PAY_IE_TAX_ERROR table.');

1730: commit;
1731: end if;
1732: exception
1733: when others then
1734: FND_FILE.PUT_LINE(fnd_file.log,'Error occured while deleting exisiting rows in PAY_IE_TAX_ERROR table.');
1735: end;
1736:
1737: OPEN c_body;
1738: FETCH c_body into BodyRec;

Line 2126: INSERT INTO pay_ie_tax_error ( pps_number

2122: END IF;
2123:
2124: --
2125:
2126: INSERT INTO pay_ie_tax_error ( pps_number
2127: , employee_number
2128: , full_name
2129: , payroll_name
2130: , error_stack_message

Line 2152: INSERT INTO pay_ie_tax_error ( pps_number

2148: retcode := 2;
2149: FND_FILE.PUT_LINE (fnd_file.log, 'Error raised in loading data into one or all of the follo
2150: wing tables: pay_ie_tax_header_interface, pay_ie_tax_body_interface, pay_ie_tax_trailer_interface');
2151:
2152: INSERT INTO pay_ie_tax_error ( pps_number
2153: , employee_number
2154: , full_name
2155: , payroll_name
2156: , error_stack_message

Line 3055: Delete from pay_ie_tax_error;

3051: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
3052:
3053:
3054: Begin
3055: Delete from pay_ie_tax_error;
3056: if sql%rowcount > 0 then
3057: commit;
3058: end if;
3059: exception

Line 3062: PAY_IE_TAX_ERROR table');

3058: end if;
3059: exception
3060: when others then
3061: FND_FILE.PUT_LINE(fnd_file.log,'Error occured while deleting exisiting rows in
3062: PAY_IE_TAX_ERROR table');
3063: end;
3064:
3065: UPDATE PAY_IE_TAX_BODY_INTERFACE
3066: SET EMPLOYER_NUMBER =

Line 3193: INSERT INTO pay_ie_tax_error ( pps_number

3189: FND_FILE.PUT_LINE(fnd_file.log,
3190: 'does not match the total weekly credit in pay_ie_tax_trailer_interface.total_wk_tax_credit');
3191: END IF;
3192:
3193: INSERT INTO pay_ie_tax_error ( pps_number
3194: , employee_number
3195: , full_name
3196: , payroll_name
3197: , error_stack_message

Line 3219: INSERT INTO pay_ie_tax_error ( pps_number

3215: retcode := 2;
3216: FND_FILE.PUT_LINE (fnd_file.log, 'Error raised in loading data into one or all of the follo
3217: wing tables: pay_ie_tax_header_interface, pay_ie_tax_body_interface, pay_ie_tax_trailer_interface');
3218:
3219: INSERT INTO pay_ie_tax_error ( pps_number
3220: , employee_number
3221: , full_name
3222: , payroll_name
3223: , error_stack_message

Line 4050: -- INSERT INTO pay_ie_tax_error ( pps_number

4046: -- );
4047: --
4048: -- -- The exception details are written to an error table
4049: --
4050: -- INSERT INTO pay_ie_tax_error ( pps_number
4051: -- , employee_number
4052: -- , full_name
4053: -- , payroll_name
4054: -- , tax_district

Line 4088: -- INSERT INTO pay_ie_tax_error ( pps_number

4084: -- );
4085: --
4086: -- -- The exception details are written to an error table
4087: --
4088: -- INSERT INTO pay_ie_tax_error ( pps_number
4089: -- , employee_number
4090: -- , full_name
4091: -- , payroll_name
4092: -- , tax_district

Line 4122: INSERT INTO pay_ie_tax_error ( pps_number

4118: r_pay.payroll_name_hr
4119: );
4120: -- The exception details are written to an error table
4121:
4122: INSERT INTO pay_ie_tax_error ( pps_number
4123: , employee_number
4124: , full_name
4125: , payroll_name
4126: , tax_district

Line 4164: INSERT INTO pay_ie_tax_error ( pps_number

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
4165: , employee_number
4166: , full_name
4167: , payroll_name
4168: , tax_district

Line 4207: INSERT INTO pay_ie_tax_error ( pps_number

4203: -- 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');
4204: --END IF;
4205:
4206: -- The exception details are written to an error table
4207: INSERT INTO pay_ie_tax_error ( pps_number
4208: , employee_number
4209: , full_name
4210: , payroll_name
4211: , tax_district

Line 4251: INSERT INTO pay_ie_tax_error ( pps_number

4247: -- 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');
4248: --END IF;
4249:
4250: -- The exception details are written to an error table
4251: INSERT INTO pay_ie_tax_error ( pps_number
4252: , employee_number
4253: , full_name
4254: , payroll_name
4255: , tax_district

Line 4294: INSERT INTO pay_ie_tax_error ( pps_number

4290: -- 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||'%');
4291: --END IF;
4292:
4293: -- The exception details are written to an error table
4294: INSERT INTO pay_ie_tax_error ( pps_number
4295: , employee_number
4296: , full_name
4297: , payroll_name
4298: , tax_district

Line 4337: INSERT INTO pay_ie_tax_error ( pps_number

4333: -- 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||'%');
4334: --END IF;
4335:
4336: -- The exception details are written to an error table
4337: INSERT INTO pay_ie_tax_error ( pps_number
4338: , employee_number
4339: , full_name
4340: , payroll_name
4341: , tax_district

Line 4380: INSERT INTO pay_ie_tax_error ( pps_number

4376: -- 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');
4377: --END IF;
4378:
4379: -- The exception details are written to an error table
4380: INSERT INTO pay_ie_tax_error ( pps_number
4381: , employee_number
4382: , full_name
4383: , payroll_name
4384: , tax_district

Line 4435: INSERT INTO pay_ie_tax_error ( pps_number

4431: -- 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);
4432: --END IF;
4433: -- The exception details are written to an error table
4434:
4435: INSERT INTO pay_ie_tax_error ( pps_number
4436: , employee_number
4437: , full_name
4438: , payroll_name
4439: , tax_district

Line 4523: INSERT INTO pay_ie_tax_error ( pps_number

4519: l_error := SQLERRM;
4520: retcode := 1;
4521: FND_FILE.PUT_LINE(fnd_file.log, 'No data found');
4522:
4523: INSERT INTO pay_ie_tax_error ( pps_number
4524: , employee_number
4525: , full_name
4526: , payroll_name
4527: , tax_district

Line 4570: INSERT INTO pay_ie_tax_error ( pps_number

4566: --ELSE
4567: -- 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);
4568: --END IF;
4569: /* The exception details are written to an error table */
4570: INSERT INTO pay_ie_tax_error ( pps_number
4571: , employee_number
4572: , full_name
4573: , payroll_name
4574: , tax_district