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 307: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Account derivation: ' || l_account_derivation || '. Distribution set id: ' || l_PAY_DIST_SET_ID);

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

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

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

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

332: CLOSE v_id_csr;*/
333:
334:
335: BEGIN
336: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '==================================================================');
337: -- 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
338: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Processing Vendor Id: ' || r_invoice_hdr.vendor_id);
339: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++ Invoice #: '||r_invoice_hdr.INVOICE_NUM||' Vendor Invoice Number: '||r_invoice_hdr.VENDOR_INVOICE_NUMBER);
340: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++ Invoice Date: '||r_invoice_hdr.INVOICE_DATE||' Invoice Amount: '||r_invoice_hdr.INVOICE_AMOUNT);

Line 337: -- 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

333:
334:
335: BEGIN
336: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '==================================================================');
337: -- 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
338: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Processing Vendor Id: ' || r_invoice_hdr.vendor_id);
339: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++ Invoice #: '||r_invoice_hdr.INVOICE_NUM||' Vendor Invoice Number: '||r_invoice_hdr.VENDOR_INVOICE_NUMBER);
340: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++ Invoice Date: '||r_invoice_hdr.INVOICE_DATE||' Invoice Amount: '||r_invoice_hdr.INVOICE_AMOUNT);
341: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '==================================================================');

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

334:
335: BEGIN
336: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '==================================================================');
337: -- 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
338: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Processing Vendor Id: ' || r_invoice_hdr.vendor_id);
339: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++ Invoice #: '||r_invoice_hdr.INVOICE_NUM||' Vendor Invoice Number: '||r_invoice_hdr.VENDOR_INVOICE_NUMBER);
340: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++ Invoice Date: '||r_invoice_hdr.INVOICE_DATE||' Invoice Amount: '||r_invoice_hdr.INVOICE_AMOUNT);
341: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '==================================================================');
342:

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

335: BEGIN
336: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '==================================================================');
337: -- 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
338: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Processing Vendor Id: ' || r_invoice_hdr.vendor_id);
339: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++ Invoice #: '||r_invoice_hdr.INVOICE_NUM||' Vendor Invoice Number: '||r_invoice_hdr.VENDOR_INVOICE_NUMBER);
340: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++ Invoice Date: '||r_invoice_hdr.INVOICE_DATE||' Invoice Amount: '||r_invoice_hdr.INVOICE_AMOUNT);
341: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '==================================================================');
342:
343: INSERT INTO AP_INVOICES_INTERFACE(

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

336: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '==================================================================');
337: -- 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
338: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Processing Vendor Id: ' || r_invoice_hdr.vendor_id);
339: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++ Invoice #: '||r_invoice_hdr.INVOICE_NUM||' Vendor Invoice Number: '||r_invoice_hdr.VENDOR_INVOICE_NUMBER);
340: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++ Invoice Date: '||r_invoice_hdr.INVOICE_DATE||' Invoice Amount: '||r_invoice_hdr.INVOICE_AMOUNT);
341: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '==================================================================');
342:
343: INSERT INTO AP_INVOICES_INTERFACE(
344: Invoice_type_lookup_code

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

337: -- 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
338: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Processing Vendor Id: ' || r_invoice_hdr.vendor_id);
339: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++ Invoice #: '||r_invoice_hdr.INVOICE_NUM||' Vendor Invoice Number: '||r_invoice_hdr.VENDOR_INVOICE_NUMBER);
340: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++ Invoice Date: '||r_invoice_hdr.INVOICE_DATE||' Invoice Amount: '||r_invoice_hdr.INVOICE_AMOUNT);
341: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '==================================================================');
342:
343: INSERT INTO AP_INVOICES_INTERFACE(
344: Invoice_type_lookup_code
345: ,accts_pay_code_combination_id

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

538: CLOSE location_csr;
539: ELSE
540: -- error log
541: l_ship_to := null;
542: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'install_location_type_code is other than HZ_LOCATIONS or HZ_PARTY_SITES');
543: END IF;
544: -- end: 07-May-2008 cklee -- Fixed bug:7015970
545: END IF;
546: --end:| 06-Jul-2007 cklee -- Fixed ship to issue |

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

565: OPEN get_inv_item_id(l_top_kle_id);
566: FETCH get_inv_item_id INTO l_inventory_item_id;
567: CLOSE get_inv_item_id;
568:
569: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '--Contract id: ' || l_khr_id || ' Line id: ' || l_top_kle_id);
570: 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);
571: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '--Inventory item id: ' || l_inventory_item_id);
572:
573: --Call to the Tax API to get the tax determinants.

Line 570: 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);

566: FETCH get_inv_item_id INTO l_inventory_item_id;
567: CLOSE get_inv_item_id;
568:
569: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '--Contract id: ' || l_khr_id || ' Line id: ' || l_top_kle_id);
570: 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);
571: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '--Inventory item id: ' || l_inventory_item_id);
572:
573: --Call to the Tax API to get the tax determinants.
574: -- Trx Business Category, Product Fiscal Classification, Product Type, Ship To Location Id

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

567: CLOSE get_inv_item_id;
568:
569: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '--Contract id: ' || l_khr_id || ' Line id: ' || l_top_kle_id);
570: 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);
571: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '--Inventory item id: ' || l_inventory_item_id);
572:
573: --Call to the Tax API to get the tax determinants.
574: -- Trx Business Category, Product Fiscal Classification, Product Type, Ship To Location Id
575: -- This code has been commented since this API is not available yet. This will be uncommented once eb Tax impacts are coded.

Line 593: 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);

589:
590:
591: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
592: l_tax_call_success_flag := 'N';
593: 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);
594: --start| 20-Sep-2007 cklee -- Fixed error message display issue for tax call |
595: FOR j in 1..x_msg_count
596: LOOP
597: FND_MSG_PUB.GET(

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

600: p_data => x_msg_data,
601: p_msg_index_out => x_msg_index_out
602: );
603:
604: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Tax call failed:' || to_char(j)||': '||x_msg_data);
605: END LOOP;
606: --end| 20-Sep-2007 cklee -- Fixed error message display issue for tax call |
607:
608: --deleting invoice lines

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

727: ,l_inventory_item_id
728: ,l_PAY_DIST_SET_ID --:| 16-Oct-2007 cklee -- Fixed bug:6502786
729: );
730: -- added 12/04/2007 cklee
731: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Processing Contract: '||l_contract_number|| '/Asset or Fee: ' ||
732: l_asset_number || '/Stream Type Purpose: ' || l_stream_type_purpose);
733:
734: END LOOP;
735:

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

749:
750: EXCEPTION
751:
752: WHEN OTHERS THEN
753: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
754: ROLLBACK TO C_INVOICE_POINT;
755: END;
756: END LOOP;
757:

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

760: ------------------------------------------------------------
761: -- Exception handling
762: ------------------------------------------------------------
763: WHEN OKL_API.G_EXCEPTION_ERROR THEN
764: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
765: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
766: p_api_name => l_api_name,
767: p_pkg_name => G_PKG_NAME,
768: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

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

770: x_msg_data => x_msg_data,
771: p_api_type => '_PVT');
772:
773: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
774: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
775: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
776: p_api_name => l_api_name,
777: p_pkg_name => G_PKG_NAME,
778: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

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

780: x_msg_data => x_msg_data,
781: p_api_type => '_PVT');
782:
783: WHEN OTHERS THEN
784: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
785: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
786: p_api_name => l_api_name,
787: p_pkg_name => G_PKG_NAME,
788: p_exc_name => 'OTHERS',