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_TRAILER_INTERFACE

Line 60: , PAY_IE_TAX_TRAILER_INTERFACE pts

56: , NVL(PTS.TOTAL_WK_RATE_CUTOFF,0) total_wk_cutoff
57: , NVL(PTS.TOTAL_MTH_TAX_CREDIT,0) total_mth_credit
58: , NVL(PTS.TOTAL_WK_TAX_CREDIT,0) total_wk_credit
59: FROM PAY_IE_TAX_HEADER_INTERFACE phs
60: , PAY_IE_TAX_TRAILER_INTERFACE pts
61: WHERE PTS.EMPLOYER_NUMBER = p_employer_number
62: AND PHS.TAX_YEAR = p_tax_year;
63:
64: l_error_stack VARCHAR2 (2000);

Line 164: 'The value in pay_ie_tax_trailer_interface.record_no is '

160: FND_FILE.PUT_LINE(fnd_file.log,
161: 'The total number of record in pay_ie_tax_body_interface is '
162: || TO_CHAR (l_count_mth_taxcredit));
163: FND_FILE.PUT_LINE (fnd_file.log,
164: 'The value in pay_ie_tax_trailer_interface.record_no is '
165: || TO_CHAR(l_count_emp_recno));
166: FND_FILE.PUT_LINE(fnd_file.log,
167: 'Error - Retcode = 2, total number of record in pay_ie_tax_body_interface');
168: FND_FILE.PUT_LINE(fnd_file.log,

Line 169: 'does not match the value in pay_ie_tax_trailer_interface.record_no');

165: || TO_CHAR(l_count_emp_recno));
166: FND_FILE.PUT_LINE(fnd_file.log,
167: 'Error - Retcode = 2, total number of record in pay_ie_tax_body_interface');
168: FND_FILE.PUT_LINE(fnd_file.log,
169: 'does not match the value in pay_ie_tax_trailer_interface.record_no');
170: END IF;
171:
172: IF l_sum_mth_rate_cutoff <> l_total_mth_cutoff THEN
173: FND_FILE.NEW_LINE(fnd_file.log, 1);

Line 178: 'The total monthly cutoff in pay_ie_tax_trailer_interface.total_mth_rate_cutoff is '

174: FND_FILE.PUT_LINE(fnd_file.log,
175: 'The sum of pay_ie_tax_body_interface.mth_rate_cutoff is '
176: || TO_CHAR (l_sum_mth_rate_cutoff));
177: FND_FILE.PUT_LINE (fnd_file.log,
178: 'The total monthly cutoff in pay_ie_tax_trailer_interface.total_mth_rate_cutoff is '
179: || TO_CHAR(l_total_mth_cutoff));
180: FND_FILE.PUT_LINE(fnd_file.log,
181: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.mth_rate_cutoff');
182: FND_FILE.PUT_LINE(fnd_file.log,

Line 183: 'does not match the total monthly cutoff in pay_ie_tax_trailer_interface.total_mth_rate_cutoff');

179: || TO_CHAR(l_total_mth_cutoff));
180: FND_FILE.PUT_LINE(fnd_file.log,
181: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.mth_rate_cutoff');
182: FND_FILE.PUT_LINE(fnd_file.log,
183: 'does not match the total monthly cutoff in pay_ie_tax_trailer_interface.total_mth_rate_cutoff');
184: END IF;
185: IF l_sum_wk_rate_cutoff <> l_total_wk_cutoff THEN
186: FND_FILE.NEW_LINE(fnd_file.log, 1);
187: FND_FILE.PUT_LINE(fnd_file.log,

Line 191: 'The total weekly cutoff in pay_ie_tax_trailer_interface.total_wk_rate_cutoff is '

187: FND_FILE.PUT_LINE(fnd_file.log,
188: 'The sum of pay_ie_tax_body_interface.wk_rate_cutoff is '
189: || TO_CHAR(l_sum_wk_rate_cutoff));
190: FND_FILE.PUT_LINE(fnd_file.log,
191: 'The total weekly cutoff in pay_ie_tax_trailer_interface.total_wk_rate_cutoff is '
192: || TO_CHAR(l_total_wk_cutoff));
193: FND_FILE.PUT_LINE(fnd_file.log,
194: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.wk_rate_cutoff');
195: FND_FILE.PUT_LINE(fnd_file.log,

Line 196: 'does not match the the total weekly cutoff in pay_ie_tax_trailer_interface.total_wk_rate_cutoff');

192: || TO_CHAR(l_total_wk_cutoff));
193: FND_FILE.PUT_LINE(fnd_file.log,
194: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.wk_rate_cutoff');
195: FND_FILE.PUT_LINE(fnd_file.log,
196: 'does not match the the total weekly cutoff in pay_ie_tax_trailer_interface.total_wk_rate_cutoff');
197: END IF;
198: IF l_sum_mth_tax_credit <> l_total_mth_credit THEN
199: FND_FILE.NEW_LINE(fnd_file.log, 1);
200: FND_FILE.PUT_LINE(fnd_file.log,

Line 204: 'The total monthly credit in pay_ie_tax_trailer_interface.total_mth_tax_credit is '

200: FND_FILE.PUT_LINE(fnd_file.log,
201: 'The sum of pay_ie_tax_body_interface.mth_tax_credit is '
202: || TO_CHAR(l_sum_mth_tax_credit));
203: FND_FILE.PUT_LINE(fnd_file.log,
204: 'The total monthly credit in pay_ie_tax_trailer_interface.total_mth_tax_credit is '
205: || TO_CHAR(l_total_mth_credit));
206: FND_FILE.PUT_LINE(fnd_file.log,
207: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.mth_tax_credit');
208: FND_FILE.PUT_LINE(fnd_file.log,

Line 209: 'does not match the total monthly credit in pay_ie_tax_trailer_interface.total_mth_tax_credit');

205: || TO_CHAR(l_total_mth_credit));
206: FND_FILE.PUT_LINE(fnd_file.log,
207: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.mth_tax_credit');
208: FND_FILE.PUT_LINE(fnd_file.log,
209: 'does not match the total monthly credit in pay_ie_tax_trailer_interface.total_mth_tax_credit');
210: END IF;
211: IF BodyRec.sum_wk_tax_credit <> TrailRec.total_wk_credit THEN
212: FND_FILE.NEW_LINE(fnd_file.log, 1);
213: FND_FILE.PUT_LINE(fnd_file.log,

Line 217: 'The total weekly credit in pay_ie_tax_trailer_interface.total_wk_tax_credit is '

213: FND_FILE.PUT_LINE(fnd_file.log,
214: 'The sum of pay_ie_tax_body_interface.wk_tax_credit is '
215: || TO_CHAR(l_sum_wk_tax_credit));
216: FND_FILE.PUT_LINE(fnd_file.log,
217: 'The total weekly credit in pay_ie_tax_trailer_interface.total_wk_tax_credit is '
218: || TO_CHAR(l_total_wk_credit));
219: FND_FILE.PUT_LINE(fnd_file.log,
220: 'Error - Retcode = 2 because the sum of pay_ie_tax_body_interface.wk_tax_credit');
221: FND_FILE.PUT_LINE(fnd_file.log,

Line 222: 'does not match the total weekly credit in pay_ie_tax_trailer_interface.total_wk_tax_credit');

218: || TO_CHAR(l_total_wk_credit));
219: FND_FILE.PUT_LINE(fnd_file.log,
220: 'Error - Retcode = 2 because the sum of pay_ie_tax_body_interface.wk_tax_credit');
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

Line 249: wing tables: pay_ie_tax_header_interface, pay_ie_tax_body_interface, pay_ie_tax_trailer_interface');

245: l_error_stack := errbuf;
246: l_error := SQLERRM;
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