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_AR_RBD_EXPORT_PKG dependencies on FND_FILE

Line 2470: /*FND_FILE.put_line(FND_FILE.log, lv_procedure_name ||

2466: ,pa_receivable_account_num => la_receivable_acc_num_array);
2467: END IF; --if it is period from is selected as first period
2468: --End: add for fixing bug 10041443
2469:
2470: /*FND_FILE.put_line(FND_FILE.log, lv_procedure_name ||
2471: '.parameters:' ||
2472: 'pn_legal_entity_id=' || pn_legal_entity_id || ',' ||
2473: 'pn_ledger_id=' || pn_ledger_id || ',' ||
2474: 'pv_accounting_year=' || pv_accounting_year || ',' ||

Line 2523: /*FND_FILE.put_line(FND_FILE.log, lv_procedure_name ||

2519: lv_procedure_name,
2520: 'ld_start_date=' || ld_start_date || ',' ||
2521: 'ld_end_date=' || ld_end_date);
2522: END IF; --(ln_statement_level >= ln_dbg_level)
2523: /*FND_FILE.put_line(FND_FILE.log, lv_procedure_name ||
2524: '.variable:' ||
2525: 'ld_start_date=' || ld_start_date || ',' ||
2526: 'ld_end_date=' || ld_end_date);*/
2527:

Line 2551: /*FND_FILE.put_line(FND_FILE.log, lv_procedure_name ||

2547: FND_LOG.STRING(ln_statement_level,
2548: lv_procedure_name,
2549: 'ln_flex_value_set_id=' || ln_flex_value_set_id);
2550: END IF; --(ln_statement_level >= ln_dbg_level)
2551: /*FND_FILE.put_line(FND_FILE.log, lv_procedure_name ||
2552: '.variable:' ||
2553: 'ln_flex_value_set_id=' || ln_flex_value_set_id);*/
2554:
2555: --Fetch functional currency

Line 2571: /*FND_FILE.put_line(FND_FILE.log, lv_procedure_name ||

2567: FND_LOG.STRING(ln_statement_level,
2568: lv_procedure_name,
2569: 'lv_functional_currency=' || lv_functional_currency);
2570: END IF; --(ln_statement_level >= ln_dbg_level)
2571: /*FND_FILE.put_line(FND_FILE.log, lv_procedure_name ||
2572: '.variable:' ||
2573: 'lv_functional_currency=' || lv_functional_currency);*/
2574:
2575: --Fetch the attribute column for storing Remittance Bill Number and Balance Side

Line 2598: /*FND_FILE.put_line(FND_FILE.log, lv_procedure_name ||

2594: lv_procedure_name,
2595: 'lv_attribute_column4bal_side=' || lv_attribute_column4bal_side || ',' ||
2596: 'lv_attribute_column4bill_num=' || lv_attribute_column4bill_num);
2597: END IF; --(ln_statement_level >= ln_dbg_level)
2598: /*FND_FILE.put_line(FND_FILE.log, lv_procedure_name ||
2599: '.variable:' ||
2600: 'lv_attribute_column4bal_side=' || lv_attribute_column4bal_side || ',' ||
2601: 'lv_attribute_column4bill_num=' || lv_attribute_column4bill_num);*/
2602:

Line 2616: /*FND_FILE.put_line(FND_FILE.log, lv_procedure_name ||

2612: FND_LOG.STRING(ln_statement_level,
2613: lv_procedure_name,
2614: 'lv_contract_number_column=' || lv_contract_number_column);
2615: END IF; --(ln_statement_level >= ln_dbg_level)
2616: /*FND_FILE.put_line(FND_FILE.log, lv_procedure_name ||
2617: '.variable:' ||
2618: 'lv_contract_number_column=' || lv_contract_number_column);*/
2619:
2620: --Add data to XML

Line 2625: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'Loop ar_gl_sla_cur: Ae_Header_Id='||v_gl_sla_row.ae_header_id);

2621: --Loop the Cursor for fetching AR Transaction data when the accounting class
2622: --is 'Receivable' in the accounting line in SLA, and data posted to GL.
2623: FOR v_gl_sla_row IN ar_gl_sla_cur
2624: LOOP
2625: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'Loop ar_gl_sla_cur: Ae_Header_Id='||v_gl_sla_row.ae_header_id);
2626:
2627: --Fetch the balance Side of account
2628: IF NVL(lv_current_account_number,'****') <> v_gl_sla_row.account_number THEN
2629: lv_current_account_number := v_gl_sla_row.account_number;

Line 2638: --FND_FILE.PUT_LINE(FND_FILE.LOG, ' Loop customer_trx_id_cur: Customer_Trx_Id='

2634:
2635: --Loop the Cursor for getting Transaction ID based on ae_header_id
2636: FOR v_customer_trx_id_row IN customer_trx_id_cur(v_gl_sla_row.ae_header_id)
2637: LOOP
2638: --FND_FILE.PUT_LINE(FND_FILE.LOG, ' Loop customer_trx_id_cur: Customer_Trx_Id='
2639: -- || v_customer_trx_id_row.customer_trx_id);
2640:
2641: lv_transaction_exported_flag := 'N'; --Indicate transaction information has not been exported
2642:

Line 2646: --FND_FILE.PUT_LINE(FND_FILE.LOG, ' Loop period_name_cur: period_name='||v_period_name_row.period_name);

2642:
2643: --Loop the Cursor for getting accounting period for each Transaction and related Receipts
2644: FOR v_period_name_row IN period_name_cur(v_customer_trx_id_row.customer_trx_id)
2645: LOOP
2646: --FND_FILE.PUT_LINE(FND_FILE.LOG, ' Loop period_name_cur: period_name='||v_period_name_row.period_name);
2647:
2648: --Loop the Cursor for getting the Transaction information based on the Transaction Id
2649: FOR v_transaction_row IN transaction_cur(v_customer_trx_id_row.customer_trx_id,
2650: v_period_name_row.period_name)

Line 2652: --FND_FILE.PUT_LINE(FND_FILE.LOG, ' Loop transaction_cur: Transaction_Number='||v_transaction_row.Transaction_Number);

2648: --Loop the Cursor for getting the Transaction information based on the Transaction Id
2649: FOR v_transaction_row IN transaction_cur(v_customer_trx_id_row.customer_trx_id,
2650: v_period_name_row.period_name)
2651: LOOP
2652: --FND_FILE.PUT_LINE(FND_FILE.LOG, ' Loop transaction_cur: Transaction_Number='||v_transaction_row.Transaction_Number);
2653:
2654: --Fetch the VAT Inovice Number for transaction from Golden Tax Invoice
2655: lv_vat_invoice_number := Get_VAT_Invoice_Number(v_customer_trx_id_row.customer_trx_id,
2656: v_period_name_row.period_name);

Line 2679: --FND_FILE.PUT_LINE(FND_FILE.LOG, ' Loop receipt_cur: Receipt_Number='||v_receipt_row.transaction_number);

2675: THEN
2676: ln_current_receipt_id := v_receipt_row.cash_receipt_id;
2677: ln_current_ae_header_id := v_receipt_row.ae_header_id;
2678:
2679: --FND_FILE.PUT_LINE(FND_FILE.LOG, ' Loop receipt_cur: Receipt_Number='||v_receipt_row.transaction_number);
2680: --FND_FILE.PUT_LINE(FND_FILE.LOG, ' ==>Export Transaction......for Receipt '||v_receipt_row.transaction_number);
2681:
2682: ln_row_count := ln_row_count + 2; --one line for transaction and one line for receipt
2683: lv_transaction_exported_flag := 'Y';--Transaction information exported

Line 2680: --FND_FILE.PUT_LINE(FND_FILE.LOG, ' ==>Export Transaction......for Receipt '||v_receipt_row.transaction_number);

2676: ln_current_receipt_id := v_receipt_row.cash_receipt_id;
2677: ln_current_ae_header_id := v_receipt_row.ae_header_id;
2678:
2679: --FND_FILE.PUT_LINE(FND_FILE.LOG, ' Loop receipt_cur: Receipt_Number='||v_receipt_row.transaction_number);
2680: --FND_FILE.PUT_LINE(FND_FILE.LOG, ' ==>Export Transaction......for Receipt '||v_receipt_row.transaction_number);
2681:
2682: ln_row_count := ln_row_count + 2; --one line for transaction and one line for receipt
2683: lv_transaction_exported_flag := 'Y';--Transaction information exported
2684:

Line 2756: --FND_FILE.PUT_LINE(FND_FILE.LOG, ' ==>Export Receipt......for Receipt '||v_receipt_row.transaction_number);

2752: ,pv_clear_flag => lv_clear_flag
2753: ,pv_remittance_bill_number => v_transaction_row.Remittance_Bill_Number);
2754:
2755: --Add Receipt Information
2756: --FND_FILE.PUT_LINE(FND_FILE.LOG, ' ==>Export Receipt......for Receipt '||v_receipt_row.transaction_number);
2757:
2758: ln_journal_number := NULL;
2759: ln_functional_amount := NULL;
2760: ln_entered_amount := NULL;

Line 2838: --FND_FILE.PUT_LINE(FND_FILE.LOG, ' Loop credit_memo_cur: Credit_Memo_Id='

2834: FOR v_credit_memo_row IN credit_memo_cur(v_customer_trx_id_row.customer_trx_id,
2835: v_gl_sla_row.ae_header_id,
2836: v_period_name_row.period_name)
2837: LOOP
2838: --FND_FILE.PUT_LINE(FND_FILE.LOG, ' Loop credit_memo_cur: Credit_Memo_Id='
2839: -- ||v_credit_memo_row.Customer_Trx_Id||',Ae_Line_Num='||v_credit_memo_row.Ae_Line_Num);
2840:
2841: ln_row_count := ln_row_count + 4; --one line for transaction and three line for Credit Memo
2842: lv_transaction_exported_flag := 'Y';--Transaction information exported

Line 2849: --FND_FILE.PUT_LINE(FND_FILE.LOG, ' ==>Export Transaction......for Credit Memo '||v_credit_memo_row.Transaction_Number);

2845: IF ln_cm_customer_trx_id <> v_credit_memo_row.customer_trx_id
2846: THEN
2847: ln_cm_customer_trx_id := v_credit_memo_row.customer_trx_id;
2848:
2849: --FND_FILE.PUT_LINE(FND_FILE.LOG, ' ==>Export Transaction......for Credit Memo '||v_credit_memo_row.Transaction_Number);
2850:
2851: --Add the correspondance Transaction information line of the reciept
2852: ln_journal_number := NULL;
2853: ln_functional_amount := NULL;

Line 2922: --FND_FILE.PUT_LINE(FND_FILE.LOG, ' ==>Export Credit Memo......for Credit Memo '||',Ae_Line_Num='||v_credit_memo_row.Ae_Line_Num);

2918: ,pv_clear_flag => lv_clear_flag
2919: ,pv_remittance_bill_number => v_transaction_row.Remittance_Bill_Number);
2920: END IF; --ln_cm_customer_trx_id <> v_credit_memo_row.customer_trx_id
2921:
2922: --FND_FILE.PUT_LINE(FND_FILE.LOG, ' ==>Export Credit Memo......for Credit Memo '||',Ae_Line_Num='||v_credit_memo_row.Ae_Line_Num);
2923: --Add Credit Memo Information
2924: ln_journal_number := NULL;
2925: ln_functional_amount := NULL;
2926: ln_entered_amount := NULL;

Line 3005: --FND_FILE.PUT_LINE(FND_FILE.LOG, ' ==>Export Transaction separately......Transaction_Number='||v_transaction_row.Transaction_Number);

3001: BETWEEN v_period_name_row.Start_Date AND v_period_name_row.End_Date)
3002: THEN
3003: ln_row_count := ln_row_count + 1;
3004:
3005: --FND_FILE.PUT_LINE(FND_FILE.LOG, ' ==>Export Transaction separately......Transaction_Number='||v_transaction_row.Transaction_Number);
3006:
3007: ln_journal_number := NULL;
3008: ln_functional_amount := NULL;
3009: ln_entered_amount := NULL;

Line 3075: --FND_FILE.PUT_LINE(FND_FILE.LOG, ' Loop trx_adjustment_cur: Adjustment_Id='||v_trx_adjustment_row.Adjustment_Id);

3071: FOR v_trx_adjustment_row IN trx_adjustment_cur(v_customer_trx_id_row.customer_trx_id,
3072: v_gl_sla_row.ae_header_id,
3073: v_period_name_row.period_name)
3074: LOOP
3075: --FND_FILE.PUT_LINE(FND_FILE.LOG, ' Loop trx_adjustment_cur: Adjustment_Id='||v_trx_adjustment_row.Adjustment_Id);
3076: --FND_FILE.PUT_LINE(FND_FILE.LOG, ' ==>Export Adjustment ......Adjustment_Id='||v_trx_adjustment_row.Adjustment_Id);
3077:
3078: ln_row_count := ln_row_count + 1;
3079:

Line 3076: --FND_FILE.PUT_LINE(FND_FILE.LOG, ' ==>Export Adjustment ......Adjustment_Id='||v_trx_adjustment_row.Adjustment_Id);

3072: v_gl_sla_row.ae_header_id,
3073: v_period_name_row.period_name)
3074: LOOP
3075: --FND_FILE.PUT_LINE(FND_FILE.LOG, ' Loop trx_adjustment_cur: Adjustment_Id='||v_trx_adjustment_row.Adjustment_Id);
3076: --FND_FILE.PUT_LINE(FND_FILE.LOG, ' ==>Export Adjustment ......Adjustment_Id='||v_trx_adjustment_row.Adjustment_Id);
3077:
3078: ln_row_count := ln_row_count + 1;
3079:
3080: ln_journal_number := NULL;

Line 3212: FND_FILE.put_line(FND_FILE.log, lv_procedure_name || SQLCODE || SQLERRM);

3208: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
3209: '.Other_Exception ',
3210: SQLCODE || SQLERRM);
3211: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3212: FND_FILE.put_line(FND_FILE.log, lv_procedure_name || SQLCODE || SQLERRM);
3213: RAISE;
3214:
3215: END Add_Receivables_Balance_Detail;
3216: