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 154: fnd_file.put_line(fnd_file.log,fnd_message.get);

150: EXCEPTION
151: WHEN OTHERS THEN
152: IF p_str2 = 'DFN' THEN
153: fnd_message.set_name('JE', 'JE_IL_INVALID_DFN');
154: fnd_file.put_line(fnd_file.log,fnd_message.get);
155: ELSIF p_str2 = 'CTPID' THEN
156: fnd_message.set_name('JE', 'JE_IL_INVALID_TAXPAYER_ID');
157: fnd_file.put_line(fnd_file.log,fnd_message.get);
158: ELSE

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

153: fnd_message.set_name('JE', 'JE_IL_INVALID_DFN');
154: fnd_file.put_line(fnd_file.log,fnd_message.get);
155: ELSIF p_str2 = 'CTPID' THEN
156: fnd_message.set_name('JE', 'JE_IL_INVALID_TAXPAYER_ID');
157: fnd_file.put_line(fnd_file.log,fnd_message.get);
158: ELSE
159: fnd_message.set_name('JE', 'JE_IL_INVALID_SUP_TAXPAYER_ID');
160: fnd_message.set_token('P_VENDOR_NUM',p_str2);
161: fnd_file.put_line(fnd_file.log,fnd_message.get);

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

157: fnd_file.put_line(fnd_file.log,fnd_message.get);
158: ELSE
159: fnd_message.set_name('JE', 'JE_IL_INVALID_SUP_TAXPAYER_ID');
160: fnd_message.set_token('P_VENDOR_NUM',p_str2);
161: fnd_file.put_line(fnd_file.log,fnd_message.get);
162: END IF;
163:
164: RETURN NULL;
165:

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

208: EXCEPTION
209: WHEN OTHERS THEN
210: l_primary_ledger_id := 0;
211: IF fnd_debug_log = 'Y' THEN
212: fnd_file.put_line(fnd_file.log,'Error Message:'||SQLERRM||'Error Code:'||SQLCODE);
213: END IF;
214: return FALSE;
215: END;
216:

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

231:
232: WHEN OTHERS THEN
233: l_currency_code := NULL;
234: IF fnd_debug_log = 'Y' THEN
235: fnd_file.put_line(fnd_file.log,'Error Message:'||SQLERRM||'Error Code:'||SQLCODE);
236: END IF;
237: return FALSE;
238: END;
239:

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

554: EXCEPTION
555: WHEN OTHERS THEN
556: l_period_set_name := NULL;
557: IF fnd_debug_log = 'Y' THEN
558: fnd_file.put_line(fnd_file.log,'Error Message:'||SQLERRM||'Error Code:'||SQLCODE);
559: END IF;
560: RETURN FALSE;
561: END;
562:

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

782: EXCEPTION
783: WHEN others THEN
784: ln_invoice_amount := 0;
785: IF fnd_debug_log = 'Y' THEN
786: fnd_file.put_line(fnd_file.log,'Error Message:'||SQLERRM||'Error Code:'||SQLCODE);
787: END IF;
788: END;
789:
790: FOR rec_invevent_awt IN c_get_invevent_awt(ln_invoice_id)

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

794: ln_gross_amount := ln_gross_amount + NVL(ln_awt_amount,0);
795: END LOOP;
796:
797: IF fnd_debug_log = 'Y' THEN
798: fnd_file.put_line(fnd_file.log,'Return from Cursor c_get_invevent_awt:Invoice ID:'||ln_invoice_id||'Amount:'||ln_gross_amount);
799: END IF;
800:
801: END IF;
802:

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

848:
849: gn_awt_amount := NVL(ln_awt_amount,0);
850: gn_invoice_id := NVL(ln_invoice_id,-99);
851: IF fnd_debug_log = 'Y' THEN
852: fnd_file.put_line(fnd_file.log,'Return 1:'||ln_gross_amount);
853: fnd_file.put_line(fnd_file.log,'Return 2:'||gn_awt_amount);
854: END IF;
855: RETURN ln_gross_amount;
856: END get_amounts;

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

849: gn_awt_amount := NVL(ln_awt_amount,0);
850: gn_invoice_id := NVL(ln_invoice_id,-99);
851: IF fnd_debug_log = 'Y' THEN
852: fnd_file.put_line(fnd_file.log,'Return 1:'||ln_gross_amount);
853: fnd_file.put_line(fnd_file.log,'Return 2:'||gn_awt_amount);
854: END IF;
855: RETURN ln_gross_amount;
856: END get_amounts;
857: /*

Line 897: fnd_file.put_line(fnd_file.log,'pn_check_id :'||pn_check_id);

893:
894: BEGIN
895:
896: IF fnd_debug_log = 'Y' THEN
897: fnd_file.put_line(fnd_file.log,'pn_check_id :'||pn_check_id);
898: fnd_file.put_line(fnd_file.log,'pn_invoice_id :'||pn_invoice_id);
899: END IF;
900:
901: BEGIN

Line 898: fnd_file.put_line(fnd_file.log,'pn_invoice_id :'||pn_invoice_id);

894: BEGIN
895:
896: IF fnd_debug_log = 'Y' THEN
897: fnd_file.put_line(fnd_file.log,'pn_check_id :'||pn_check_id);
898: fnd_file.put_line(fnd_file.log,'pn_invoice_id :'||pn_invoice_id);
899: END IF;
900:
901: BEGIN
902: --- Verify if the check is related to Bank AWT

Line 932: fnd_file.put_line(fnd_file.log,'Error in get_gross_amount:');

928: END IF;
929:
930: EXCEPTION
931: WHEN others THEN
932: fnd_file.put_line(fnd_file.log,'Error in get_gross_amount:');
933: END;
934:
935: BEGIN
936:

Line 969: fnd_file.put_line(fnd_file.log,'pn_check_id :'||pn_check_id);

965:
966:
967: IF ln_pay_invoice_id = pn_invoice_id THEN
968: IF fnd_debug_log = 'Y' THEN
969: fnd_file.put_line(fnd_file.log,'pn_check_id :'||pn_check_id);
970: fnd_file.put_line(fnd_file.log,'gn_check_id :'||gn_check_id);
971: fnd_file.put_line(fnd_file.log,'pn_invoice_id :'||pn_invoice_id);
972: fnd_file.put_line(fnd_file.log,'gn_invoice_id :'||gn_invoice_id);
973: END IF;

Line 970: fnd_file.put_line(fnd_file.log,'gn_check_id :'||gn_check_id);

966:
967: IF ln_pay_invoice_id = pn_invoice_id THEN
968: IF fnd_debug_log = 'Y' THEN
969: fnd_file.put_line(fnd_file.log,'pn_check_id :'||pn_check_id);
970: fnd_file.put_line(fnd_file.log,'gn_check_id :'||gn_check_id);
971: fnd_file.put_line(fnd_file.log,'pn_invoice_id :'||pn_invoice_id);
972: fnd_file.put_line(fnd_file.log,'gn_invoice_id :'||gn_invoice_id);
973: END IF;
974: IF ( (NVL(ln_check_id,-99) = pn_check_id ) and (nvl(ln_invoice_id,-99) <> pn_invoice_id)) THEN

Line 971: fnd_file.put_line(fnd_file.log,'pn_invoice_id :'||pn_invoice_id);

967: IF ln_pay_invoice_id = pn_invoice_id THEN
968: IF fnd_debug_log = 'Y' THEN
969: fnd_file.put_line(fnd_file.log,'pn_check_id :'||pn_check_id);
970: fnd_file.put_line(fnd_file.log,'gn_check_id :'||gn_check_id);
971: fnd_file.put_line(fnd_file.log,'pn_invoice_id :'||pn_invoice_id);
972: fnd_file.put_line(fnd_file.log,'gn_invoice_id :'||gn_invoice_id);
973: END IF;
974: IF ( (NVL(ln_check_id,-99) = pn_check_id ) and (nvl(ln_invoice_id,-99) <> pn_invoice_id)) THEN
975: gn_awt_amount :=0;

Line 972: fnd_file.put_line(fnd_file.log,'gn_invoice_id :'||gn_invoice_id);

968: IF fnd_debug_log = 'Y' THEN
969: fnd_file.put_line(fnd_file.log,'pn_check_id :'||pn_check_id);
970: fnd_file.put_line(fnd_file.log,'gn_check_id :'||gn_check_id);
971: fnd_file.put_line(fnd_file.log,'pn_invoice_id :'||pn_invoice_id);
972: fnd_file.put_line(fnd_file.log,'gn_invoice_id :'||gn_invoice_id);
973: END IF;
974: IF ( (NVL(ln_check_id,-99) = pn_check_id ) and (nvl(ln_invoice_id,-99) <> pn_invoice_id)) THEN
975: gn_awt_amount :=0;
976: IF fnd_debug_log = 'Y' THEN

Line 977: fnd_file.put_line(fnd_file.log,'Returning gross amt as 0 for second ');

973: END IF;
974: IF ( (NVL(ln_check_id,-99) = pn_check_id ) and (nvl(ln_invoice_id,-99) <> pn_invoice_id)) THEN
975: gn_awt_amount :=0;
976: IF fnd_debug_log = 'Y' THEN
977: fnd_file.put_line(fnd_file.log,'Returning gross amt as 0 for second ');
978: END IF;
979: RETURN 0;
980: END IF;
981: END IF;

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

1031: EXCEPTION
1032: WHEN others THEN -- Don't Error out the report. Display 0
1033: vn_ret_gross := 0;
1034: IF fnd_debug_log = 'Y' THEN
1035: fnd_file.put_line(fnd_file.log,'Error Message:'||SQLERRM||'Error Code:'||SQLCODE);
1036: END IF;
1037: END;
1038: IF fnd_debug_log = 'Y' THEN
1039: fnd_file.put_line(fnd_file.log,'Return gross:'||vn_ret_gross);

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

1035: fnd_file.put_line(fnd_file.log,'Error Message:'||SQLERRM||'Error Code:'||SQLCODE);
1036: END IF;
1037: END;
1038: IF fnd_debug_log = 'Y' THEN
1039: fnd_file.put_line(fnd_file.log,'Return gross:'||vn_ret_gross);
1040: END IF;
1041: RETURN vn_ret_gross;
1042: END get_gross_amount;
1043: /*

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

1059: vn_ret_awt NUMBER;
1060: BEGIN
1061: vn_ret_awt := NVL(gn_awt_amount,0);
1062: IF fnd_debug_log = 'Y' THEN
1063: fnd_file.put_line(fnd_file.log,'Return awt:'||vn_ret_awt);
1064: END IF;
1065: RETURN vn_ret_awt;
1066: End Get_Awt_Amount;
1067:

Line 1100: fnd_file.put_line(fnd_file.log,'Return Get_Awt_Amt:'||vn_ret_awt);

1096:
1097: Vn_Ret_Awt := Nvl(Gn_Awt_Amount,0);
1098:
1099: IF fnd_debug_log = 'Y' THEN
1100: fnd_file.put_line(fnd_file.log,'Return Get_Awt_Amt:'||vn_ret_awt);
1101: End If;
1102:
1103: RETURN Vn_Ret_Awt;
1104:

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

1123: vn_ret_invoice_id NUMBER;
1124: BEGIN
1125: vn_ret_invoice_id := NVL(gn_invoice_id,-99);
1126: IF fnd_debug_log = 'Y' THEN
1127: fnd_file.put_line(fnd_file.log,'Return Invoice:'||vn_ret_invoice_id);
1128: END IF;
1129: RETURN vn_ret_invoice_id;
1130: End Get_Invoice_Id;
1131:

Line 1172: fnd_file.put_line(fnd_file.log,'Return awt amount paid by bank:'||nvl(vn_ret_awt,0));

1168: LOOP
1169: vn_ret_awt := rec_bank_wht.bank_wht_amount;
1170: END LOOP;
1171: IF fnd_debug_log = 'Y' THEN
1172: fnd_file.put_line(fnd_file.log,'Return awt amount paid by bank:'||nvl(vn_ret_awt,0));
1173: END IF;
1174: RETURN nvl(vn_ret_awt,0);
1175: EXCEPTION
1176: WHEN others THEN

Line 1179: fnd_file.put_line(fnd_file.log,'Error Message:'||SQLERRM||'Error

1175: EXCEPTION
1176: WHEN others THEN
1177: vn_ret_awt := 0;
1178: IF fnd_debug_log = 'Y' THEN
1179: fnd_file.put_line(fnd_file.log,'Error Message:'||SQLERRM||'Error
1180: Code:'||SQLCODE);
1181: END IF;
1182: Return Vn_Ret_Awt;
1183: End get_awt_bank_amt;