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

Line 310: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Account derivation: ' || l_account_derivation || '. Distribution set id: ' || l_PAY_DIST_SET_ID);

306: l_account_derivation,
307: l_PAY_DIST_SET_ID;
308: CLOSE c_account_derivation;
309:
310: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Account derivation: ' || l_account_derivation || '. Distribution set id: ' || l_PAY_DIST_SET_ID);
311: IF l_account_derivation = 'AMB' THEN
312: IF l_PAY_DIST_SET_ID IS NULL THEN
313: -- log error message
314: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Distribution set id is missing, please setup accordingly.');

Line 314: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Distribution set id is missing, please setup accordingly.');

310: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Account derivation: ' || l_account_derivation || '. Distribution set id: ' || l_PAY_DIST_SET_ID);
311: IF l_account_derivation = 'AMB' THEN
312: IF l_PAY_DIST_SET_ID IS NULL THEN
313: -- log error message
314: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Distribution set id is missing, please setup accordingly.');
315: RAISE G_EXCEPTION_HALT_VALIDATION;
316: END IF;
317: END IF;
318: --end:| 16-Oct-2007 cklee -- Fixed bug:6502786 |

Line 339: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '==================================================================');

335: CLOSE v_id_csr;*/
336:
337:
338: BEGIN
339: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '==================================================================');
340: -- FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Processing Contract: '||l_contract_number|| 'Vendor Id: ' || r_invoice_hdr.vendor_id); -- removed by 12/04/2007 cklee
341: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Processing Vendor Id: ' || r_invoice_hdr.vendor_id);
342: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++ Invoice #: '||r_invoice_hdr.INVOICE_NUM||' Vendor Invoice Number: '||r_invoice_hdr.VENDOR_INVOICE_NUMBER);
343: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++ Invoice Date: '||r_invoice_hdr.INVOICE_DATE||' Invoice Amount: '||r_invoice_hdr.INVOICE_AMOUNT);

Line 340: -- FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Processing Contract: '||l_contract_number|| 'Vendor Id: ' || r_invoice_hdr.vendor_id); -- removed by 12/04/2007 cklee

336:
337:
338: BEGIN
339: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '==================================================================');
340: -- FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Processing Contract: '||l_contract_number|| 'Vendor Id: ' || r_invoice_hdr.vendor_id); -- removed by 12/04/2007 cklee
341: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Processing Vendor Id: ' || r_invoice_hdr.vendor_id);
342: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++ Invoice #: '||r_invoice_hdr.INVOICE_NUM||' Vendor Invoice Number: '||r_invoice_hdr.VENDOR_INVOICE_NUMBER);
343: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++ Invoice Date: '||r_invoice_hdr.INVOICE_DATE||' Invoice Amount: '||r_invoice_hdr.INVOICE_AMOUNT);
344: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '==================================================================');

Line 341: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Processing Vendor Id: ' || r_invoice_hdr.vendor_id);

337:
338: BEGIN
339: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '==================================================================');
340: -- FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Processing Contract: '||l_contract_number|| 'Vendor Id: ' || r_invoice_hdr.vendor_id); -- removed by 12/04/2007 cklee
341: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Processing Vendor Id: ' || r_invoice_hdr.vendor_id);
342: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++ Invoice #: '||r_invoice_hdr.INVOICE_NUM||' Vendor Invoice Number: '||r_invoice_hdr.VENDOR_INVOICE_NUMBER);
343: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++ Invoice Date: '||r_invoice_hdr.INVOICE_DATE||' Invoice Amount: '||r_invoice_hdr.INVOICE_AMOUNT);
344: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '==================================================================');
345:

Line 342: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++ Invoice #: '||r_invoice_hdr.INVOICE_NUM||' Vendor Invoice Number: '||r_invoice_hdr.VENDOR_INVOICE_NUMBER);

338: BEGIN
339: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '==================================================================');
340: -- FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Processing Contract: '||l_contract_number|| 'Vendor Id: ' || r_invoice_hdr.vendor_id); -- removed by 12/04/2007 cklee
341: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Processing Vendor Id: ' || r_invoice_hdr.vendor_id);
342: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++ Invoice #: '||r_invoice_hdr.INVOICE_NUM||' Vendor Invoice Number: '||r_invoice_hdr.VENDOR_INVOICE_NUMBER);
343: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++ Invoice Date: '||r_invoice_hdr.INVOICE_DATE||' Invoice Amount: '||r_invoice_hdr.INVOICE_AMOUNT);
344: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '==================================================================');
345:
346: INSERT INTO AP_INVOICES_INTERFACE(

Line 343: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++ Invoice Date: '||r_invoice_hdr.INVOICE_DATE||' Invoice Amount: '||r_invoice_hdr.INVOICE_AMOUNT);

339: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '==================================================================');
340: -- FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Processing Contract: '||l_contract_number|| 'Vendor Id: ' || r_invoice_hdr.vendor_id); -- removed by 12/04/2007 cklee
341: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Processing Vendor Id: ' || r_invoice_hdr.vendor_id);
342: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++ Invoice #: '||r_invoice_hdr.INVOICE_NUM||' Vendor Invoice Number: '||r_invoice_hdr.VENDOR_INVOICE_NUMBER);
343: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++ Invoice Date: '||r_invoice_hdr.INVOICE_DATE||' Invoice Amount: '||r_invoice_hdr.INVOICE_AMOUNT);
344: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '==================================================================');
345:
346: INSERT INTO AP_INVOICES_INTERFACE(
347: Invoice_type_lookup_code

Line 344: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '==================================================================');

340: -- FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Processing Contract: '||l_contract_number|| 'Vendor Id: ' || r_invoice_hdr.vendor_id); -- removed by 12/04/2007 cklee
341: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Processing Vendor Id: ' || r_invoice_hdr.vendor_id);
342: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++ Invoice #: '||r_invoice_hdr.INVOICE_NUM||' Vendor Invoice Number: '||r_invoice_hdr.VENDOR_INVOICE_NUMBER);
343: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++ Invoice Date: '||r_invoice_hdr.INVOICE_DATE||' Invoice Amount: '||r_invoice_hdr.INVOICE_AMOUNT);
344: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '==================================================================');
345:
346: INSERT INTO AP_INVOICES_INTERFACE(
347: Invoice_type_lookup_code
348: ,accts_pay_code_combination_id

Line 552: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'install_location_type_code is other than HZ_LOCATIONS or HZ_PARTY_SITES');

548: CLOSE location_csr;
549: ELSE
550: -- error log
551: l_ship_to := null;
552: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'install_location_type_code is other than HZ_LOCATIONS or HZ_PARTY_SITES');
553: END IF;
554: -- end: 07-May-2008 cklee -- Fixed bug:7015970
555: END IF;
556: --end:| 06-Jul-2007 cklee -- Fixed ship to issue |

Line 579: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '--Contract id: ' || l_khr_id || ' Line id: ' || l_top_kle_id);

575: OPEN get_inv_item_id(l_top_kle_id);
576: FETCH get_inv_item_id INTO l_inventory_item_id, l_inventory_org_id; --21-Oct-2011 sechawla Bug 12888543 : added inv org id
577: CLOSE get_inv_item_id;
578:
579: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '--Contract id: ' || l_khr_id || ' Line id: ' || l_top_kle_id);
580: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '--Install location id: ' || l_install_location_id || ' Location id: ' || l_location_id || ' Ship to id: ' || l_ship_to);
581: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '--Inventory item id: ' || l_inventory_item_id);
582: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '--Inventory org id: ' || l_inventory_org_id);
583:

Line 580: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '--Install location id: ' || l_install_location_id || ' Location id: ' || l_location_id || ' Ship to id: ' || l_ship_to);

576: FETCH get_inv_item_id INTO l_inventory_item_id, l_inventory_org_id; --21-Oct-2011 sechawla Bug 12888543 : added inv org id
577: CLOSE get_inv_item_id;
578:
579: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '--Contract id: ' || l_khr_id || ' Line id: ' || l_top_kle_id);
580: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '--Install location id: ' || l_install_location_id || ' Location id: ' || l_location_id || ' Ship to id: ' || l_ship_to);
581: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '--Inventory item id: ' || l_inventory_item_id);
582: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '--Inventory org id: ' || l_inventory_org_id);
583:
584: --Call to the Tax API to get the tax determinants.

Line 581: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '--Inventory item id: ' || l_inventory_item_id);

577: CLOSE get_inv_item_id;
578:
579: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '--Contract id: ' || l_khr_id || ' Line id: ' || l_top_kle_id);
580: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '--Install location id: ' || l_install_location_id || ' Location id: ' || l_location_id || ' Ship to id: ' || l_ship_to);
581: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '--Inventory item id: ' || l_inventory_item_id);
582: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '--Inventory org id: ' || l_inventory_org_id);
583:
584: --Call to the Tax API to get the tax determinants.
585: -- Trx Business Category, Product Fiscal Classification, Product Type, Ship To Location Id

Line 582: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '--Inventory org id: ' || l_inventory_org_id);

578:
579: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '--Contract id: ' || l_khr_id || ' Line id: ' || l_top_kle_id);
580: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '--Install location id: ' || l_install_location_id || ' Location id: ' || l_location_id || ' Ship to id: ' || l_ship_to);
581: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '--Inventory item id: ' || l_inventory_item_id);
582: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '--Inventory org id: ' || l_inventory_org_id);
583:
584: --Call to the Tax API to get the tax determinants.
585: -- Trx Business Category, Product Fiscal Classification, Product Type, Ship To Location Id
586: -- This code has been commented since this API is not available yet. This will be uncommented once eb Tax impacts are coded.

Line 604: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Tax call failed for invoice line id: ' || r_invoice_lines.invoice_line_id || ' of invoice id: ' || r_invoice_hdr.invoice_id);

600:
601:
602: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
603: l_tax_call_success_flag := 'N';
604: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Tax call failed for invoice line id: ' || r_invoice_lines.invoice_line_id || ' of invoice id: ' || r_invoice_hdr.invoice_id);
605: --start| 20-Sep-2007 cklee -- Fixed error message display issue for tax call |
606: FOR j in 1..x_msg_count
607: LOOP
608: FND_MSG_PUB.GET(

Line 615: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Tax call failed:' || to_char(j)||': '||x_msg_data);

611: p_data => x_msg_data,
612: p_msg_index_out => x_msg_index_out
613: );
614:
615: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Tax call failed:' || to_char(j)||': '||x_msg_data);
616: END LOOP;
617: --end| 20-Sep-2007 cklee -- Fixed error message display issue for tax call |
618:
619: --deleting invoice lines

Line 744: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Processing Contract: '||l_contract_number|| '/Asset or Fee: ' ||

740: ,l_inventory_item_id
741: ,l_PAY_DIST_SET_ID --:| 16-Oct-2007 cklee -- Fixed bug:6502786
742: );
743: -- added 12/04/2007 cklee
744: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Processing Contract: '||l_contract_number|| '/Asset or Fee: ' ||
745: l_asset_number || '/Stream Type Purpose: ' || l_stream_type_purpose);
746:
747: END LOOP;
748:

Line 766: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);

762:
763: EXCEPTION
764:
765: WHEN OTHERS THEN
766: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
767: ROLLBACK TO C_INVOICE_POINT;
768: END;
769: END LOOP;
770:

Line 777: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);

773: ------------------------------------------------------------
774: -- Exception handling
775: ------------------------------------------------------------
776: WHEN OKL_API.G_EXCEPTION_ERROR THEN
777: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
778: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
779: p_api_name => l_api_name,
780: p_pkg_name => G_PKG_NAME,
781: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 787: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);

783: x_msg_data => x_msg_data,
784: p_api_type => '_PVT');
785:
786: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
787: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
788: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
789: p_api_name => l_api_name,
790: p_pkg_name => G_PKG_NAME,
791: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 797: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);

793: x_msg_data => x_msg_data,
794: p_api_type => '_PVT');
795:
796: WHEN OTHERS THEN
797: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
798: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
799: p_api_name => l_api_name,
800: p_pkg_name => G_PKG_NAME,
801: p_exc_name => 'OTHERS',