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.JE_IL_TAX_PKG dependencies on FND_FILE

Line 33: fnd_file.put_line(fnd_file.log,fnd_message.get);

29: EXCEPTION
30: WHEN OTHERS THEN
31: IF p_str2 = 'DFN' THEN
32: fnd_message.set_name('JE', 'JE_IL_INVALID_DFN');
33: fnd_file.put_line(fnd_file.log,fnd_message.get);
34: ELSIF p_str2 = 'CTPID' THEN
35: fnd_message.set_name('JE', 'JE_IL_INVALID_TAXPAYER_ID');
36: fnd_file.put_line(fnd_file.log,fnd_message.get);
37: ELSE

Line 36: fnd_file.put_line(fnd_file.log,fnd_message.get);

32: fnd_message.set_name('JE', 'JE_IL_INVALID_DFN');
33: fnd_file.put_line(fnd_file.log,fnd_message.get);
34: ELSIF p_str2 = 'CTPID' THEN
35: fnd_message.set_name('JE', 'JE_IL_INVALID_TAXPAYER_ID');
36: fnd_file.put_line(fnd_file.log,fnd_message.get);
37: ELSE
38: fnd_message.set_name('JE', 'JE_IL_INVALID_SUP_TAXPAYER_ID');
39: fnd_message.set_token('P_VENDOR_NUM',p_str2);
40: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 40: fnd_file.put_line(fnd_file.log,fnd_message.get);

36: fnd_file.put_line(fnd_file.log,fnd_message.get);
37: ELSE
38: fnd_message.set_name('JE', 'JE_IL_INVALID_SUP_TAXPAYER_ID');
39: fnd_message.set_token('P_VENDOR_NUM',p_str2);
40: fnd_file.put_line(fnd_file.log,fnd_message.get);
41: END IF;
42:
43: RAISE;
44:

Line 258: fnd_file.put_line(fnd_file.log,'Error Message:'||SQLERRM||'Error Code:'||SQLCODE);

254: AND xlah.accounting_entry_status_code = 'F';
255: EXCEPTION
256: WHEN others THEN
257: ln_invoice_amount := 0;
258: fnd_file.put_line(fnd_file.log,'Error Message:'||SQLERRM||'Error Code:'||SQLCODE);
259: END;
260: FOR rec_invevent_awt IN c_get_invevent_awt(ln_invoice_id)
261: LOOP
262: ln_awt_amount := (rec_invevent_awt.pay_amount*ln_gross_amount)/(ln_invoice_amount-rec_invevent_awt.pay_amount);

Line 266: fnd_file.put_line(fnd_file.log,'Return from Cursor c_get_invevent_awt:Invoice ID:'||ln_invoice_id||'Amount:'||ln_gross_amount);

262: ln_awt_amount := (rec_invevent_awt.pay_amount*ln_gross_amount)/(ln_invoice_amount-rec_invevent_awt.pay_amount);
263: ln_awt_event := rec_invevent_awt.event;
264: ln_gross_amount := ln_gross_amount + NVL(ln_awt_amount,0);
265: END LOOP;
266: fnd_file.put_line(fnd_file.log,'Return from Cursor c_get_invevent_awt:Invoice ID:'||ln_invoice_id||'Amount:'||ln_gross_amount);
267: END IF;
268: BEGIN
269: SELECT SIGN(NVL(aip.payment_base_amount,aip.amount)) INTO ln_sign
270: FROM ap_invoice_payments aip

Line 296: fnd_file.put_line(fnd_file.log,'Return 1:'||ln_gross_amount);

292: END IF;
293: END IF;
294: gn_awt_amount := NVL(ln_awt_amount,0);
295: gn_invoice_id := NVL(ln_invoice_id,-99);
296: fnd_file.put_line(fnd_file.log,'Return 1:'||ln_gross_amount);
297: fnd_file.put_line(fnd_file.log,'Return 2:'||gn_awt_amount);
298: RETURN ln_gross_amount;
299: END get_amounts;
300: /*

Line 297: fnd_file.put_line(fnd_file.log,'Return 2:'||gn_awt_amount);

293: END IF;
294: gn_awt_amount := NVL(ln_awt_amount,0);
295: gn_invoice_id := NVL(ln_invoice_id,-99);
296: fnd_file.put_line(fnd_file.log,'Return 1:'||ln_gross_amount);
297: fnd_file.put_line(fnd_file.log,'Return 2:'||gn_awt_amount);
298: RETURN ln_gross_amount;
299: END get_amounts;
300: /*
301: REM +======================================================================+

Line 320: fnd_file.put_line(fnd_file.log,'Error Message:'||SQLERRM||'Error Code:'||SQLCODE);

316: vn_ret_gross := NVL(get_amounts(pn_invoice_id,pn_check_id, pd_start_date, pd_end_date,pv_void),0);
317: EXCEPTION
318: WHEN others THEN -- Don't Error out the report. Display 0
319: vn_ret_gross := 0;
320: fnd_file.put_line(fnd_file.log,'Error Message:'||SQLERRM||'Error Code:'||SQLCODE);
321: END;
322: fnd_file.put_line(fnd_file.log,'Return gross:'||vn_ret_gross);
323: RETURN vn_ret_gross;
324: END get_gross_amount;

Line 322: fnd_file.put_line(fnd_file.log,'Return gross:'||vn_ret_gross);

318: WHEN others THEN -- Don't Error out the report. Display 0
319: vn_ret_gross := 0;
320: fnd_file.put_line(fnd_file.log,'Error Message:'||SQLERRM||'Error Code:'||SQLCODE);
321: END;
322: fnd_file.put_line(fnd_file.log,'Return gross:'||vn_ret_gross);
323: RETURN vn_ret_gross;
324: END get_gross_amount;
325: /*
326: REM +======================================================================+

Line 344: fnd_file.put_line(fnd_file.log,'Return awt:'||vn_ret_awt);

340: IS
341: vn_ret_awt NUMBER;
342: BEGIN
343: vn_ret_awt := NVL(gn_awt_amount,0);
344: fnd_file.put_line(fnd_file.log,'Return awt:'||vn_ret_awt);
345: RETURN vn_ret_awt;
346: END get_awt_amount;
347: /*
348: REM +======================================================================+

Line 364: fnd_file.put_line(fnd_file.log,'Return Invoice:'||vn_ret_invoice_id);

360: IS
361: vn_ret_invoice_id NUMBER;
362: BEGIN
363: vn_ret_invoice_id := NVL(gn_invoice_id,-99);
364: fnd_file.put_line(fnd_file.log,'Return Invoice:'||vn_ret_invoice_id);
365: RETURN vn_ret_invoice_id;
366: END get_invoice_id;
367:
368: END JE_IL_TAX_PKG;