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

Line 1838: --fnd_file.PUT_LINE(fnd_file.LOG,'Invoice_Id='||pn_invoice_id||',ln_paid_amount='||ln_paid_amount||',ln_inv_amount='||ln_inv_amount);

1834: FOR v_paid_amount_row IN paid_amount_cur LOOP
1835: ln_paid_amount := v_paid_amount_row.Paid_Amount;
1836: EXIT;
1837: END LOOP;
1838: --fnd_file.PUT_LINE(fnd_file.LOG,'Invoice_Id='||pn_invoice_id||',ln_paid_amount='||ln_paid_amount||',ln_inv_amount='||ln_inv_amount);
1839: IF ln_inv_amount = NVL(ln_paid_amount, 0) THEN
1840: lv_clear_flag := '1'; --cleared
1841: ELSE
1842: lv_clear_flag := '0'; --unclear

Line 2501: FND_FILE.PUT_LINE(FND_FILE.LOG,'Is_Void_Invoice:'|| sqlerrm);

2497: END IF; -- (ln_proc_level>=ln_dbg_level)
2498: return true;
2499: exception
2500: when others then
2501: FND_FILE.PUT_LINE(FND_FILE.LOG,'Is_Void_Invoice:'|| sqlerrm);
2502: end Is_Void_Invoice;
2503:
2504:
2505: --==========================================================================

Line 2576: FND_FILE.PUT_LINE(FND_FILE.LOG,'Is_Different_Period:'|| sqlerrm);

2572:
2573: return true;
2574: Exception
2575: when others then
2576: FND_FILE.PUT_LINE(FND_FILE.LOG,'Is_Different_Period:'|| sqlerrm);
2577: end Is_Different_Period;
2578:
2579: --==========================================================================
2580: -- PROCEDURE NAME:

Line 3108: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Start********');

3104: --End: add for fixing bug 10041443
3105:
3106: --Step 1: Fetching basic journal information of posted invoice with accounting class 'Liability'
3107: FOR v_gl_sla_row IN gl_sla_cur LOOP
3108: FND_FILE.PUT_LINE(FND_FILE.LOG, '**************Start**********************');
3109: FND_FILE.PUT_LINE(FND_FILE.LOG, 'step1: Supplier_Id='||v_gl_sla_row.Supplier_Id||',Ae_Header_Id='||v_gl_sla_row.Ae_Header_Id);
3110: --Step 2: Fetching invoice id
3111: FOR v_inv_id_row IN inv_id_cur(v_gl_sla_row.Ae_Header_Id) LOOP
3112: FND_FILE.PUT_LINE(FND_FILE.LOG, 'step2: Invoice_Id='||v_inv_id_row.Invoice_Id);

Line 3109: FND_FILE.PUT_LINE(FND_FILE.LOG, 'step1: Supplier_Id='||v_gl_sla_row.Supplier_Id||',Ae_Header_Id='||v_gl_sla_row.Ae_Header_Id);

3105:
3106: --Step 1: Fetching basic journal information of posted invoice with accounting class 'Liability'
3107: FOR v_gl_sla_row IN gl_sla_cur LOOP
3108: FND_FILE.PUT_LINE(FND_FILE.LOG, '**************Start**********************');
3109: FND_FILE.PUT_LINE(FND_FILE.LOG, 'step1: Supplier_Id='||v_gl_sla_row.Supplier_Id||',Ae_Header_Id='||v_gl_sla_row.Ae_Header_Id);
3110: --Step 2: Fetching invoice id
3111: FOR v_inv_id_row IN inv_id_cur(v_gl_sla_row.Ae_Header_Id) LOOP
3112: FND_FILE.PUT_LINE(FND_FILE.LOG, 'step2: Invoice_Id='||v_inv_id_row.Invoice_Id);
3113: lv_invoice_exported_flag := 'N'; --indicate invoice information has not been exported yet

Line 3112: FND_FILE.PUT_LINE(FND_FILE.LOG, 'step2: Invoice_Id='||v_inv_id_row.Invoice_Id);

3108: FND_FILE.PUT_LINE(FND_FILE.LOG, '**************Start**********************');
3109: FND_FILE.PUT_LINE(FND_FILE.LOG, 'step1: Supplier_Id='||v_gl_sla_row.Supplier_Id||',Ae_Header_Id='||v_gl_sla_row.Ae_Header_Id);
3110: --Step 2: Fetching invoice id
3111: FOR v_inv_id_row IN inv_id_cur(v_gl_sla_row.Ae_Header_Id) LOOP
3112: FND_FILE.PUT_LINE(FND_FILE.LOG, 'step2: Invoice_Id='||v_inv_id_row.Invoice_Id);
3113: lv_invoice_exported_flag := 'N'; --indicate invoice information has not been exported yet
3114: lv_prepay_export_flag := 'Y'; --indicate prepaid line for prepayment should be exported
3115: --Step 3: Fetching accounting period for invoice and its payments based on invoice id
3116: FOR v_period_name_row IN period_name_cur(v_gl_sla_row.Inv_Period_Name,

Line 3118: FND_FILE.PUT_LINE(FND_FILE.LOG, 'step3: period_name='||v_period_name_row.period_name||', Start_Date='||v_period_name_row.Start_Date);

3114: lv_prepay_export_flag := 'Y'; --indicate prepaid line for prepayment should be exported
3115: --Step 3: Fetching accounting period for invoice and its payments based on invoice id
3116: FOR v_period_name_row IN period_name_cur(v_gl_sla_row.Inv_Period_Name,
3117: v_inv_id_row.Invoice_Id) LOOP
3118: FND_FILE.PUT_LINE(FND_FILE.LOG, 'step3: period_name='||v_period_name_row.period_name||', Start_Date='||v_period_name_row.Start_Date);
3119: --Step 4: Fetching information about invoice based on accounting period
3120: FOR v_inv_row IN inv_cur(v_inv_id_row.Invoice_Id,
3121: v_gl_sla_row.Ae_Header_Id,
3122: v_period_name_row.period_name) LOOP

Line 3125: FND_FILE.PUT_LINE(FND_FILE.LOG, 'step4: Invoice_Number='||v_inv_row.Transaction_Number);

3121: v_gl_sla_row.Ae_Header_Id,
3122: v_period_name_row.period_name) LOOP
3123: ln_row_count := ln_row_count + 1;
3124: l_reversal_flag:=0;
3125: FND_FILE.PUT_LINE(FND_FILE.LOG, 'step4: Invoice_Number='||v_inv_row.Transaction_Number);
3126: --Step 5: Fetching information about payments based on accounting period
3127: FOR v_pay_row IN pay_cur(v_inv_id_row.Invoice_Id,
3128: v_gl_sla_row.Ae_Header_Id,
3129: v_period_name_row.period_name) LOOP

Line 3130: FND_FILE.PUT_LINE(FND_FILE.LOG, 'step5: Check_Id='||v_pay_row.Check_Id);

3126: --Step 5: Fetching information about payments based on accounting period
3127: FOR v_pay_row IN pay_cur(v_inv_id_row.Invoice_Id,
3128: v_gl_sla_row.Ae_Header_Id,
3129: v_period_name_row.period_name) LOOP
3130: FND_FILE.PUT_LINE(FND_FILE.LOG, 'step5: Check_Id='||v_pay_row.Check_Id);
3131: --indicate invoice information has been exported,
3132: --and would not be exported again if there is no payments for it posted to GL
3133: lv_invoice_exported_flag := 'Y';
3134:

Line 3397: --fnd_file.PUT_LINE(fnd_file.log,'--Step6: v_prepay_inv_row.Prepay_Invoice_Id='||v_prepay_inv_id_row.Prepay_Invoice_Id);

3393: lv_invoice_exported_flag := 'Y'; --indicate invioce information has been exported with its payment
3394: --Step6: Fetching information about prepayment application
3395: FOR v_prepay_inv_id_row IN prepay_inv_id_cur(v_inv_id_row.Invoice_Id,
3396: v_gl_sla_row.ae_header_id) LOOP
3397: --fnd_file.PUT_LINE(fnd_file.log,'--Step6: v_prepay_inv_row.Prepay_Invoice_Id='||v_prepay_inv_id_row.Prepay_Invoice_Id);
3398:
3399: /*--For prepaid account number
3400: IF lv_prepaid_account_num IS NULL
3401: THEN

Line 3411: --fnd_file.PUT_LINE(fnd_file.log,'--Step6.1: v_prepay_inv_row.Prepay_Invoice_Id='||v_prepay_inv_id_row.Prepay_Invoice_Id||',v_gl_sla_row.je_header_id='||v_gl_sla_row.je_header_id);

3407: ln_prepaid_je_header_id := NULL;
3408: ln_prepaid_journal_date := NULL;
3409:
3410: FOR v_prepaid_line_row IN prepay_cur(v_prepay_inv_id_row.Prepay_Invoice_Id) LOOP
3411: --fnd_file.PUT_LINE(fnd_file.log,'--Step6.1: v_prepay_inv_row.Prepay_Invoice_Id='||v_prepay_inv_id_row.Prepay_Invoice_Id||',v_gl_sla_row.je_header_id='||v_gl_sla_row.je_header_id);
3412: ln_prepaid_je_header_id := v_prepaid_line_row.je_header_id;
3413: ln_prepaid_journal_date := v_prepaid_line_row.journal_date;
3414:
3415: FOR v_prepaid_account_num_row IN prepaid_account_num_cur(v_prepaid_line_row.Ae_Header_Id) LOOP

Line 3489: --fnd_file.PUT_LINE(fnd_file.log,'--Step6.2:v_inv_id_row.Invoice_Id='||v_inv_id_row.Invoice_Id);

3485: END LOOP; --prepay_cur: add prepaid line for prepayment
3486:
3487: --Step6.2: Add invoice line for invoice
3488: FOR v_inv_line_row IN prepay_cur(v_inv_id_row.Invoice_Id) LOOP
3489: --fnd_file.PUT_LINE(fnd_file.log,'--Step6.2:v_inv_id_row.Invoice_Id='||v_inv_id_row.Invoice_Id);
3490: Add_XML_Node(pv_supplier_number => Get_Supplier_Number(v_gl_sla_row.Supplier_Number,
3491: v_inv_id_row.Invoice_Id),
3492: pv_account_number => v_gl_sla_row.account_number,
3493: pv_journal_created_date => v_inv_line_row.Journal_Created_Date,

Line 3852: FND_FILE.PUT_LINE(FND_FILE.LOG, 'End********');

3848: END LOOP; --Step4: inv_cur
3849: END LOOP; --Step3: period_name_cur
3850: EXIT;
3851: END LOOP; --Step2: inv_id_cur
3852: FND_FILE.PUT_LINE(FND_FILE.LOG, '**************End**********************');
3853: END LOOP; --Step1: gl_sla_cur
3854:
3855: -- if the row count is 0
3856: -- no need to handle if minOccurs=0 specified in xml schema

Line 3908: FND_FILE.put_line(FND_FILE.log,

3904: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
3905: '.Other_Exception ',
3906: SQLCODE || SQLERRM);
3907: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3908: FND_FILE.put_line(FND_FILE.log,
3909: lv_procedure_name || SQLCODE || SQLERRM);
3910: RAISE;
3911: END Add_Payables_Balance_Detail;
3912: