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

Line 1643: Fnd_File.put_line(Fnd_File.LOG, 'Exiting with warning as parent request not completed with normal status');

1639: IF v_dev_phase = 'COMPLETE' THEN
1640:
1641: IF v_dev_status <> 'NORMAL' THEN
1642:
1643: Fnd_File.put_line(Fnd_File.LOG, 'Exiting with warning as parent request not completed with normal status');
1644: Fnd_File.put_line(Fnd_File.LOG, 'Message from parent request :' || v_message);
1645: retcode := 1;
1646: errbuf := 'Exiting with warningr as parent request not completed with normal status';
1647: RETURN;

Line 1644: Fnd_File.put_line(Fnd_File.LOG, 'Message from parent request :' || v_message);

1640:
1641: IF v_dev_status <> 'NORMAL' THEN
1642:
1643: Fnd_File.put_line(Fnd_File.LOG, 'Exiting with warning as parent request not completed with normal status');
1644: Fnd_File.put_line(Fnd_File.LOG, 'Message from parent request :' || v_message);
1645: retcode := 1;
1646: errbuf := 'Exiting with warningr as parent request not completed with normal status';
1647: RETURN;
1648:

Line 1684: Fnd_File.put_line(Fnd_File.LOG, 'Exiting with warning as the PLA/BOE invoice has not got imported ');

1680: '', to_char(p_set_of_books_id), 'N',
1681: '' ); -- commit size
1682: exception
1683: when no_data_found then
1684: Fnd_File.put_line(Fnd_File.LOG, 'Exiting with warning as the PLA/BOE invoice has not got imported ');
1685: Fnd_File.put_line(Fnd_File.LOG, 'PLA/BOE invoice num :' || p_boe_id );
1686: retcode := 1;
1687: errbuf := 'Exiting with warning as the PLA/BOE invoice to approve has not been imported ';
1688: RETURN;

Line 1685: Fnd_File.put_line(Fnd_File.LOG, 'PLA/BOE invoice num :' || p_boe_id );

1681: '' ); -- commit size
1682: exception
1683: when no_data_found then
1684: Fnd_File.put_line(Fnd_File.LOG, 'Exiting with warning as the PLA/BOE invoice has not got imported ');
1685: Fnd_File.put_line(Fnd_File.LOG, 'PLA/BOE invoice num :' || p_boe_id );
1686: retcode := 1;
1687: errbuf := 'Exiting with warning as the PLA/BOE invoice to approve has not been imported ';
1688: RETURN;
1689: end;

Line 1696: Fnd_File.put_line(Fnd_File.LOG, 'PLA/BOE invoice num :' || p_boe_id || ', approval request submitted ');

1692:
1693:
1694: End If;
1695:
1696: Fnd_File.put_line(Fnd_File.LOG, 'PLA/BOE invoice num :' || p_boe_id || ', approval request submitted ');
1697:
1698: exception
1699: when others then
1700: Fnd_File.put_line(Fnd_File.LOG, 'Exception encountered in procedure jai_ap_utils_pkg.submit_pla_boe_for_approval');

Line 1700: Fnd_File.put_line(Fnd_File.LOG, 'Exception encountered in procedure jai_ap_utils_pkg.submit_pla_boe_for_approval');

1696: Fnd_File.put_line(Fnd_File.LOG, 'PLA/BOE invoice num :' || p_boe_id || ', approval request submitted ');
1697:
1698: exception
1699: when others then
1700: Fnd_File.put_line(Fnd_File.LOG, 'Exception encountered in procedure jai_ap_utils_pkg.submit_pla_boe_for_approval');
1701: Fnd_File.put_line(Fnd_File.LOG, SQLERRM);
1702: retcode := 2;
1703: errbuf := SQLERRM;
1704: RETURN;

Line 1701: Fnd_File.put_line(Fnd_File.LOG, SQLERRM);

1697:
1698: exception
1699: when others then
1700: Fnd_File.put_line(Fnd_File.LOG, 'Exception encountered in procedure jai_ap_utils_pkg.submit_pla_boe_for_approval');
1701: Fnd_File.put_line(Fnd_File.LOG, SQLERRM);
1702: retcode := 2;
1703: errbuf := SQLERRM;
1704: RETURN;
1705: End submit_pla_boe_for_approval;

Line 1793: fnd_file.put_line(FND_FILE.LOG, stemp);

1789: WHILE(length(P_string) >= nlength)
1790: LOOP
1791:
1792: stemp := substrb(P_string, nlength, 80);
1793: fnd_file.put_line(FND_FILE.LOG, stemp);
1794: nlength := (nlength + 80);
1795:
1796: END LOOP;
1797: END IF;

Line 1873: fnd_file.put_line(FND_FILE.LOG, 'START OF Procedure ');

1869: lv_vendor_site_id_updated := '';
1870: lv_thhold_grp_id_updated := '';
1871: lv_thhold_xcep_id_updated := '';
1872:
1873: fnd_file.put_line(FND_FILE.LOG, 'START OF Procedure ');
1874:
1875: ln_request_id := FND_GLOBAL.conc_request_id;
1876:
1877: lv_debug_msg := ' A. Report Parameters';

Line 2233: fnd_file.put_line(FND_FILE.LOG, ' inside procedure ');

2229:
2230: Begin
2231:
2232:
2233: fnd_file.put_line(FND_FILE.LOG, ' inside procedure ');
2234:
2235: lv_base_curr_code := 'INR';
2236:
2237: Begin

Line 2266: fnd_file.put_line(FND_FILE.LOG, ' invoice id '|| p_invoice_id);

2262: Close get_prec;
2263:
2264: End if;
2265:
2266: fnd_file.put_line(FND_FILE.LOG, ' invoice id '|| p_invoice_id);
2267: fnd_file.put_line(FND_FILE.LOG, ' po dist id '|| p_po_dist_id);
2268:
2269: for Misc_loop in ( select *
2270: from JAI_AP_MATCH_INV_TAXES

Line 2267: fnd_file.put_line(FND_FILE.LOG, ' po dist id '|| p_po_dist_id);

2263:
2264: End if;
2265:
2266: fnd_file.put_line(FND_FILE.LOG, ' invoice id '|| p_invoice_id);
2267: fnd_file.put_line(FND_FILE.LOG, ' po dist id '|| p_po_dist_id);
2268:
2269: for Misc_loop in ( select *
2270: from JAI_AP_MATCH_INV_TAXES
2271: where invoice_id = p_invoice_id

Line 2277: fnd_file.put_line(FND_FILE.LOG,' inside loop -- 2 ' );

2273: )
2274: loop
2275:
2276:
2277: fnd_file.put_line(FND_FILE.LOG,' inside loop -- 2 ' );
2278:
2279: /* For later use if necessary to check the tax type. now education cess will not be
2280: created at invoice level if it is available in PO/Receipt level
2281:

Line 2300: fnd_file.put_line(FND_FILE.LOG,' Inside item amount not zero ' || p_amount);

2296: Close get_misc_lines;
2297:
2298: If nvl(p_amount ,0) <> 0 Then
2299:
2300: fnd_file.put_line(FND_FILE.LOG,' Inside item amount not zero ' || p_amount);
2301:
2302: If nvl(r_get_misc_lines.amount , 0 ) <> 0 Then
2303:
2304: fnd_file.put_line(FND_FILE.LOG,' Inside Tax amount not zero ' || r_get_misc_lines.amount);

Line 2304: fnd_file.put_line(FND_FILE.LOG,' Inside Tax amount not zero ' || r_get_misc_lines.amount);

2300: fnd_file.put_line(FND_FILE.LOG,' Inside item amount not zero ' || p_amount);
2301:
2302: If nvl(r_get_misc_lines.amount , 0 ) <> 0 Then
2303:
2304: fnd_file.put_line(FND_FILE.LOG,' Inside Tax amount not zero ' || r_get_misc_lines.amount);
2305:
2306: IF nvl(p_invoice_price_variance,0 ) <> 0 Then
2307:
2308: ln_tax_ipv := r_get_misc_lines.amount * (nvl(p_invoice_price_variance,0) /p_amount);

Line 2318: fnd_file.put_line(FND_FILE.LOG,' IPV '|| ln_tax_ipv);

2314: ln_tax_erv := r_get_misc_lines.amount * (nvl(p_exchange_rate_variance,0)/p_amount);
2315:
2316: End if;
2317:
2318: fnd_file.put_line(FND_FILE.LOG,' IPV '|| ln_tax_ipv);
2319: fnd_file.put_line(FND_FILE.LOG,' ERV '|| ln_tax_erv);
2320:
2321: /* IPV */
2322:

Line 2319: fnd_file.put_line(FND_FILE.LOG,' ERV '|| ln_tax_erv);

2315:
2316: End if;
2317:
2318: fnd_file.put_line(FND_FILE.LOG,' IPV '|| ln_tax_ipv);
2319: fnd_file.put_line(FND_FILE.LOG,' ERV '|| ln_tax_erv);
2320:
2321: /* IPV */
2322:
2323: If nvl(ln_tax_ipv,0) <> 0 then

Line 2325: fnd_file.put_line(FND_FILE.LOG,' Inside IPV not zero '|| ln_tax_ipv);

2321: /* IPV */
2322:
2323: If nvl(ln_tax_ipv,0) <> 0 then
2324:
2325: fnd_file.put_line(FND_FILE.LOG,' Inside IPV not zero '|| ln_tax_ipv);
2326:
2327: ln_tax_bipv := ln_tax_ipv * nvl(r_get_misc_lines.exchange_rate,1);
2328:
2329: update ap_invoice_distributions_all

Line 2341: fnd_file.put_line(FND_FILE.LOG,' Inside ERV not zero '|| ln_tax_erv);

2337:
2338:
2339: If nvl(ln_tax_erv,0) <> 0 then
2340:
2341: fnd_file.put_line(FND_FILE.LOG,' Inside ERV not zero '|| ln_tax_erv);
2342: fnd_file.put_line(FND_FILE.LOG,' rate var CCID '|| P_rate_var_ccid);
2343:
2344: update ap_invoice_distributions_all
2345: set exchange_rate_variance = round(ln_tax_erv,ln_inv_pre),

Line 2342: fnd_file.put_line(FND_FILE.LOG,' rate var CCID '|| P_rate_var_ccid);

2338:
2339: If nvl(ln_tax_erv,0) <> 0 then
2340:
2341: fnd_file.put_line(FND_FILE.LOG,' Inside ERV not zero '|| ln_tax_erv);
2342: fnd_file.put_line(FND_FILE.LOG,' rate var CCID '|| P_rate_var_ccid);
2343:
2344: update ap_invoice_distributions_all
2345: set exchange_rate_variance = round(ln_tax_erv,ln_inv_pre),
2346: rate_var_code_combination_id = P_rate_var_ccid

Line 2376: Fnd_File.put_line(Fnd_File.LOG, 'EXCEPTION END PROCEDURE - JAI_CALC_IPV ');

2372: Exception
2373: When others then
2374: P_errmsg := SQLERRM;
2375: P_retcode := 2;
2376: Fnd_File.put_line(Fnd_File.LOG, 'EXCEPTION END PROCEDURE - JAI_CALC_IPV ');
2377: Fnd_File.put_line(Fnd_File.LOG, 'Error : ' || P_errmsg);
2378: End jai_calc_ipv_erv;
2379:
2380: -- added, Harshita for Bug 5553150

Line 2377: Fnd_File.put_line(Fnd_File.LOG, 'Error : ' || P_errmsg);

2373: When others then
2374: P_errmsg := SQLERRM;
2375: P_retcode := 2;
2376: Fnd_File.put_line(Fnd_File.LOG, 'EXCEPTION END PROCEDURE - JAI_CALC_IPV ');
2377: Fnd_File.put_line(Fnd_File.LOG, 'Error : ' || P_errmsg);
2378: End jai_calc_ipv_erv;
2379:
2380: -- added, Harshita for Bug 5553150
2381: