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

Line 366: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Fetching Batch Source');

362: x_return_status := OKL_API.G_RET_STS_SUCCESS;
363: -------------------------------------------
364: -- Fetch Batch Source Id for OKL_CONTRACTS
365: -------------------------------------------
366: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Fetching Batch Source');
367: -- Establish Savepoint for rollback
368: DBMS_TRANSACTION.SAVEPOINT('PREPARE_BATCH_SOURCE_REC_PVT');
369: -- Savepoint established
370:

Line 375: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Error: Unable to retrieve Batch Source');

371: OPEN batch_src_csr( p_trx_date );
372: FETCH batch_src_csr INTO l_batch_source_rec.batch_source_id;
373: IF (batch_src_csr%NOTFOUND) THEN
374: CLOSE batch_src_csr;
375: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Error: Unable to retrieve Batch Source');
376: RAISE Okl_Api.G_EXCEPTION_ERROR;
377: END IF;
378: CLOSE batch_src_csr;
379: l_batch_source_rec.default_date := p_trx_date;

Line 381: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PREPARE_BATCH_SOURCE_REC, p_trx_date: '||p_trx_date

377: END IF;
378: CLOSE batch_src_csr;
379: l_batch_source_rec.default_date := p_trx_date;
380:
381: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PREPARE_BATCH_SOURCE_REC, p_trx_date: '||p_trx_date
382: ||' l_batch_source_rec.default_date: '||l_batch_source_rec.default_date);
383:
384: EXCEPTION
385: WHEN OTHERS THEN

Line 727: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '.... l_ship_to '||l_ship_to);

723: l_trx_header_tbl(1).ship_to_account_number := NULL;
724: l_trx_header_tbl(1).ship_to_customer_name := NULL;
725: l_trx_header_tbl(1).ship_to_contact_id := NULL;
726: l_trx_header_tbl(1).ship_to_address_id := NVL(l_ship_to , lxfer_rec.CUSTOMER_ADDRESS_ID);
727: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '.... l_ship_to '||l_ship_to);
728: l_trx_header_tbl(1).ship_to_site_use_id := NULL;
729: l_trx_header_tbl(1).sold_to_customer_id := NULL;
730: -- l_trx_header_tbl(1).term_id := r_xsiv_rec.TERM_ID;
731: -- l_trx_header_tbl(1).LEGAL_ENTITY_ID := r_xsiv_rec.LEGAL_ENTITY_ID; -- for LE Uptake project 08-11-2006

Line 821: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Source : '|| p_source);

817: l_trx_header_tbl(1).fob_point := NULL;
818: --start: 02-APR-07 cklee R12 Billing enhancement project |
819: -- l_trx_header_tbl(1).customer_bank_account_id := r_xsiv_rec.CUSTOMER_BANK_ACCOUNT_ID;
820: --rkuttiya added for bug # 7558039
821: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Source : '|| p_source);
822: IF p_source <> 'PRINCIPAL_PAYDOWN' THEN
823: l_trx_header_tbl(1).customer_bank_account_id := lxfer_rec.CUSTOMER_BANK_ACCOUNT_ID;
824: ELSE
825: l_trx_header_tbl(1).payment_trxn_extension_id := NULL;

Line 1118: FND_FILE.PUT_LINE(FND_FILE.LOG,

1114: FETCH get_memo_line_id_csr INTO l_memo_line_id;
1115: CLOSE get_memo_line_id_csr;
1116:
1117: if l_memo_line_id is null then
1118: FND_FILE.PUT_LINE(FND_FILE.LOG,
1119: 'WARNING: A memo line with name -- Lease Upfront Tax,
1120: must exist to import tax-only invoices.');
1121: end if;
1122: --end: 02-APR-07 cklee R12 Billing enhancement project |

Line 1255: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '.... Inventory_Item Id '||l_inv_id);

1251: l_trx_lines_tbl(1).REASON_CODE := NULL;
1252: --start: 02-APR-07 cklee R12 Billing enhancement project |
1253: -- l_trx_lines_tbl(1).INVENTORY_ITEM_ID :=l_inv_id;
1254: l_trx_lines_tbl(1).INVENTORY_ITEM_ID := lxfer_rec.INVENTORY_ITEM_ID;
1255: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '.... Inventory_Item Id '||l_inv_id);
1256: l_trx_lines_tbl(1).DESCRIPTION
1257: -- := NVL (NVL (r_xlsv_rec.DESCRIPTION, r_xsiv_rec.DESCRIPTION), 'OKL Billing');
1258: := NVL (NVL (lxfer_rec.LINE_DESCRIPTION, lxfer_rec.HDR_DESCRIPTION), 'OKL Billing');
1259: -- l_trx_lines_tbl(1).QUANTITY_ORDERED := r_xlsv_rec.QUANTITY;

Line 2164: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Invoices of contract# ' || l_contract_number || ' not billed due to bankruptcy.');

2160:
2161: IF (G_IS_DEBUG_STATEMENT_ON = TRUE) THEN
2162: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Invoices of contract# ' || l_contract_number || ' not billed due to bankruptcy.');
2163: END IF;
2164: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Invoices of contract# ' || l_contract_number || ' not billed due to bankruptcy.');
2165:
2166: END IF;
2167:
2168: END;

Line 2332: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Preparing Batch rec '||l_num_cnt);

2328: -- Prepare batch_source rec
2329: ---------------------------------------
2330: l_batch_source_rec := l_init_batch_source_rec;
2331:
2332: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Preparing Batch rec '||l_num_cnt);
2333: PREPARE_BATCH_SOURCE_REC(
2334: x_return_status
2335: --start: | 02-APR-07 cklee R12 Billing enhancement project |
2336: ,xfer_rec.TRX_DATE

Line 2340: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Done Preparing Batch rec '||l_num_cnt);

2336: ,xfer_rec.TRX_DATE
2337: -- ,xsi_rec.TRX_DATE
2338: --end: | 02-APR-07 cklee R12 Billing enhancement project |
2339: ,l_batch_source_rec );
2340: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Done Preparing Batch rec '||l_num_cnt);
2341:
2342: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2343: OKL_API.SET_MESSAGE(p_app_name => 'OKL',
2344: p_msg_name => 'OKL_BPD_RTA_REC_ERR',

Line 2483: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Preparing Trx Hdr tbl '||l_num_cnt);

2479: END LOOP;
2480: */
2481: --end: | 02-APR-07 cklee R12 Billing enhancement project |
2482:
2483: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Preparing Trx Hdr tbl '||l_num_cnt);
2484: PREPARE_TRX_HDR_TBL(
2485: x_return_status
2486: --start: | 02-APR-07 cklee R12 Billing enhancement project |
2487: ,lxfer_rec

Line 2494: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Done Preparing Trx Hdr tbl '||l_num_cnt);

2490: --end: | 02-APR-07 cklee R12 Billing enhancement project |
2491: ,p_source
2492: ,l_trx_header_tbl );
2493:
2494: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Done Preparing Trx Hdr tbl '||l_num_cnt);
2495:
2496:
2497: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2498: OKL_API.SET_MESSAGE(p_app_name => 'OKL',

Line 2511: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Preparing Trx Lines tbl '||l_num_cnt);

2507: -- Prepare trx lines tbl
2508: ---------------------------------------
2509: l_trx_lines_tbl := l_init_trx_lines_tbl;
2510:
2511: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Preparing Trx Lines tbl '||l_num_cnt);
2512: PREPARE_TRX_LNS_TBL(
2513: x_return_status
2514: ,l_num_cnt
2515: --start: | 02-APR-07 cklee R12 Billing enhancement project |

Line 2521: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Done Preparing Trx Lines tbl '||l_num_cnt);

2517: -- ,r_xsiv_rec
2518: -- ,r_xlsv_rec
2519: --end: | 02-APR-07 cklee R12 Billing enhancement project |
2520: ,l_trx_lines_tbl );
2521: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Done Preparing Trx Lines tbl '||l_num_cnt);
2522:
2523: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2524: OKL_API.SET_MESSAGE(p_app_name => 'OKL',
2525: p_msg_name => 'OKL_BPD_RTA_REC_ERR',

Line 2549: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Preparing Trx Tax Lines tbl '||(l_num_cnt + l_tax_line_number));

2545:
2546: l_tax_indx := l_trx_lines_tbl.count + 1;
2547: l_tax_line_number := l_tax_line_number + 1;
2548:
2549: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Preparing Trx Tax Lines tbl '||(l_num_cnt + l_tax_line_number));
2550: --
2551: l_trx_lines_tbl(l_tax_indx).trx_header_id := 110;
2552: l_trx_lines_tbl(l_tax_indx).trx_line_id := (l_num_cnt + l_tax_line_number);
2553: l_trx_lines_tbl(l_tax_indx).link_to_trx_line_id := l_num_cnt;

Line 2584: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Done Preparing Trx Tax Lines tbl '||(l_num_cnt + l_tax_line_number));

2580: l_trx_lines_tbl(l_tax_indx).TAX_EXEMPTION_ID := NULL;
2581: l_trx_lines_tbl(l_tax_indx).VAT_TAX_ID := xfer_tax_rec.TAX_RATE_ID;
2582: --
2583:
2584: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Done Preparing Trx Tax Lines tbl '||(l_num_cnt + l_tax_line_number));
2585: END LOOP;
2586: --Bug# 4488818: Sales Tax Billing
2587: */
2588: --end: | 02-APR-07 cklee R12 Billing enhancement project |

Line 2595: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Preparing Trx Dist tbl '||l_num_cnt);

2591: -- Prepare trx distributions tbl
2592: ---------------------------------------
2593: l_trx_dist_tbl := l_init_trx_dist_tbl;
2594:
2595: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Preparing Trx Dist tbl '||l_num_cnt);
2596: PREPARE_TRX_DIST_TBL(
2597: x_return_status
2598: ,l_num_cnt
2599: --start: | 02-APR-07 cklee R12 Billing enhancement project |

Line 2605: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Done Preparing trx dist tbl '||l_num_cnt);

2601: -- ,r_xsiv_rec
2602: -- ,r_xlsv_rec
2603: --end: | 02-APR-07 cklee R12 Billing enhancement project |
2604: ,l_trx_dist_tbl );
2605: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Done Preparing trx dist tbl '||l_num_cnt);
2606:
2607: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2608: OKL_API.SET_MESSAGE(p_app_name => 'OKL',
2609: p_msg_name => 'OKL_BPD_RTA_REC_ERR',

Line 2639: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Invoking Invoice API for'

2635:
2636: -----------------------------
2637: -- Create AR Invoice
2638: -----------------------------
2639: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Invoking Invoice API for'
2640: ||' Contract Number '||xfer_rec.CONTRACT_NUMBER
2641: ||',Stream Type '||xfer_rec.STREAM_TYPE
2642: ||',Invoice Date '||xfer_rec.TRX_DATE
2643: ||',Currency Code '||xfer_rec.CURRENCY_CODE);

Line 2644: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Before calling invoice Api ');

2640: ||' Contract Number '||xfer_rec.CONTRACT_NUMBER
2641: ||',Stream Type '||xfer_rec.STREAM_TYPE
2642: ||',Invoice Date '||xfer_rec.TRX_DATE
2643: ||',Currency Code '||xfer_rec.CURRENCY_CODE);
2644: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Before calling invoice Api ');
2645:
2646: -- Establish Savepoint for rollback
2647: DBMS_TRANSACTION.SAVEPOINT('AR_INVOICE_API_PVT');
2648: -- Savepoint established

Line 2717: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Batch Source Id '||l_batch_source_rec.batch_source_id);

2713: -- End comment
2714:
2715: --rkuttiya adding debug messages for getting values of attributes passed to
2716: --
2717: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Batch Source Id '||l_batch_source_rec.batch_source_id);
2718: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Default Date '||
2719: l_batch_source_rec.default_date);
2720:
2721: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Trx Header Id :

Line 2718: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Default Date '||

2714:
2715: --rkuttiya adding debug messages for getting values of attributes passed to
2716: --
2717: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Batch Source Id '||l_batch_source_rec.batch_source_id);
2718: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Default Date '||
2719: l_batch_source_rec.default_date);
2720:
2721: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Trx Header Id :
2722: '||l_trx_header_tbl(1).trx_header_id);

Line 2721: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Trx Header Id :

2717: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Batch Source Id '||l_batch_source_rec.batch_source_id);
2718: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Default Date '||
2719: l_batch_source_rec.default_date);
2720:
2721: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Trx Header Id :
2722: '||l_trx_header_tbl(1).trx_header_id);
2723: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Trx_Number :
2724: '||l_trx_header_tbl(1).trx_number);
2725: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Trx Date :'||l_trx_header_tbl(1).trx_date);

Line 2723: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Trx_Number :

2719: l_batch_source_rec.default_date);
2720:
2721: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Trx Header Id :
2722: '||l_trx_header_tbl(1).trx_header_id);
2723: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Trx_Number :
2724: '||l_trx_header_tbl(1).trx_number);
2725: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Trx Date :'||l_trx_header_tbl(1).trx_date);
2726: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Trx_Currency
2727: :'||l_trx_header_tbl(1).trx_currency);

Line 2725: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Trx Date :'||l_trx_header_tbl(1).trx_date);

2721: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Trx Header Id :
2722: '||l_trx_header_tbl(1).trx_header_id);
2723: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Trx_Number :
2724: '||l_trx_header_tbl(1).trx_number);
2725: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Trx Date :'||l_trx_header_tbl(1).trx_date);
2726: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Trx_Currency
2727: :'||l_trx_header_tbl(1).trx_currency);
2728: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Receipt Method Id : '||
2729: l_trx_header_tbl(1).receipt_method_id);

Line 2726: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Trx_Currency

2722: '||l_trx_header_tbl(1).trx_header_id);
2723: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Trx_Number :
2724: '||l_trx_header_tbl(1).trx_number);
2725: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Trx Date :'||l_trx_header_tbl(1).trx_date);
2726: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Trx_Currency
2727: :'||l_trx_header_tbl(1).trx_currency);
2728: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Receipt Method Id : '||
2729: l_trx_header_tbl(1).receipt_method_id);
2730: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Payment Trxn Extn Id :

Line 2728: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Receipt Method Id : '||

2724: '||l_trx_header_tbl(1).trx_number);
2725: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Trx Date :'||l_trx_header_tbl(1).trx_date);
2726: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Trx_Currency
2727: :'||l_trx_header_tbl(1).trx_currency);
2728: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Receipt Method Id : '||
2729: l_trx_header_tbl(1).receipt_method_id);
2730: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Payment Trxn Extn Id :
2731: '||l_trx_header_tbl(1).payment_trxn_extension_id);
2732: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Customer Bank Account Id

Line 2730: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Payment Trxn Extn Id :

2726: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Trx_Currency
2727: :'||l_trx_header_tbl(1).trx_currency);
2728: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Receipt Method Id : '||
2729: l_trx_header_tbl(1).receipt_method_id);
2730: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Payment Trxn Extn Id :
2731: '||l_trx_header_tbl(1).payment_trxn_extension_id);
2732: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Customer Bank Account Id
2733: :'||l_trx_header_tbl(1).customer_bank_account_id);
2734: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Bill to Customer Id:

Line 2732: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Customer Bank Account Id

2728: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Receipt Method Id : '||
2729: l_trx_header_tbl(1).receipt_method_id);
2730: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Payment Trxn Extn Id :
2731: '||l_trx_header_tbl(1).payment_trxn_extension_id);
2732: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Customer Bank Account Id
2733: :'||l_trx_header_tbl(1).customer_bank_account_id);
2734: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Bill to Customer Id:
2735: '||l_trx_header_tbl(1).bill_to_customer_id);
2736: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Bill to Address Id:

Line 2734: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Bill to Customer Id:

2730: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Payment Trxn Extn Id :
2731: '||l_trx_header_tbl(1).payment_trxn_extension_id);
2732: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Customer Bank Account Id
2733: :'||l_trx_header_tbl(1).customer_bank_account_id);
2734: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Bill to Customer Id:
2735: '||l_trx_header_tbl(1).bill_to_customer_id);
2736: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Bill to Address Id:
2737: '||l_trx_header_tbl(1).bill_to_address_id);
2738: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Ship to customer id:

Line 2736: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Bill to Address Id:

2732: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Customer Bank Account Id
2733: :'||l_trx_header_tbl(1).customer_bank_account_id);
2734: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Bill to Customer Id:
2735: '||l_trx_header_tbl(1).bill_to_customer_id);
2736: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Bill to Address Id:
2737: '||l_trx_header_tbl(1).bill_to_address_id);
2738: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Ship to customer id:
2739: '||l_trx_header_tbl(1).ship_to_customer_id);
2740: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Ship to address id:

Line 2738: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Ship to customer id:

2734: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Bill to Customer Id:
2735: '||l_trx_header_tbl(1).bill_to_customer_id);
2736: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Bill to Address Id:
2737: '||l_trx_header_tbl(1).bill_to_address_id);
2738: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Ship to customer id:
2739: '||l_trx_header_tbl(1).ship_to_customer_id);
2740: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Ship to address id:
2741: '||l_trx_header_tbl(1).ship_to_address_id);
2742: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Org Id: '||l_trx_header_tbl(1).org_id);

Line 2740: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Ship to address id:

2736: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Bill to Address Id:
2737: '||l_trx_header_tbl(1).bill_to_address_id);
2738: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Ship to customer id:
2739: '||l_trx_header_tbl(1).ship_to_customer_id);
2740: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Ship to address id:
2741: '||l_trx_header_tbl(1).ship_to_address_id);
2742: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Org Id: '||l_trx_header_tbl(1).org_id);
2743: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Legal Entity Id:
2744: '||l_trx_header_tbl(1).legal_entity_id);

Line 2742: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Org Id: '||l_trx_header_tbl(1).org_id);

2738: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Ship to customer id:
2739: '||l_trx_header_tbl(1).ship_to_customer_id);
2740: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Ship to address id:
2741: '||l_trx_header_tbl(1).ship_to_address_id);
2742: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Org Id: '||l_trx_header_tbl(1).org_id);
2743: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Legal Entity Id:
2744: '||l_trx_header_tbl(1).legal_entity_id);
2745: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Billing Date
2746: :'||l_trx_header_tbl(1).billing_date);

Line 2743: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Legal Entity Id:

2739: '||l_trx_header_tbl(1).ship_to_customer_id);
2740: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Ship to address id:
2741: '||l_trx_header_tbl(1).ship_to_address_id);
2742: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Org Id: '||l_trx_header_tbl(1).org_id);
2743: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Legal Entity Id:
2744: '||l_trx_header_tbl(1).legal_entity_id);
2745: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Billing Date
2746: :'||l_trx_header_tbl(1).billing_date);
2747: fnd_file.put_line(fnd_file.output,'Term Id: '||l_trx_header_tbl(1).term_id);

Line 2745: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Billing Date

2741: '||l_trx_header_tbl(1).ship_to_address_id);
2742: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Org Id: '||l_trx_header_tbl(1).org_id);
2743: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Legal Entity Id:
2744: '||l_trx_header_tbl(1).legal_entity_id);
2745: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Billing Date
2746: :'||l_trx_header_tbl(1).billing_date);
2747: fnd_file.put_line(fnd_file.output,'Term Id: '||l_trx_header_tbl(1).term_id);
2748: fnd_file.put_line(fnd_file.output,'Comments" '||l_trx_header_tbl(1).comments);
2749:

Line 2747: fnd_file.put_line(fnd_file.output,'Term Id: '||l_trx_header_tbl(1).term_id);

2743: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Legal Entity Id:
2744: '||l_trx_header_tbl(1).legal_entity_id);
2745: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Billing Date
2746: :'||l_trx_header_tbl(1).billing_date);
2747: fnd_file.put_line(fnd_file.output,'Term Id: '||l_trx_header_tbl(1).term_id);
2748: fnd_file.put_line(fnd_file.output,'Comments" '||l_trx_header_tbl(1).comments);
2749:
2750: fnd_file.put_line(fnd_file.output,'Lines Table');
2751:

Line 2748: fnd_file.put_line(fnd_file.output,'Comments" '||l_trx_header_tbl(1).comments);

2744: '||l_trx_header_tbl(1).legal_entity_id);
2745: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Billing Date
2746: :'||l_trx_header_tbl(1).billing_date);
2747: fnd_file.put_line(fnd_file.output,'Term Id: '||l_trx_header_tbl(1).term_id);
2748: fnd_file.put_line(fnd_file.output,'Comments" '||l_trx_header_tbl(1).comments);
2749:
2750: fnd_file.put_line(fnd_file.output,'Lines Table');
2751:
2752: FOR i in l_trx_lines_tbl.FIRST..l_trx_lines_tbl.LAST LOOP

Line 2750: fnd_file.put_line(fnd_file.output,'Lines Table');

2746: :'||l_trx_header_tbl(1).billing_date);
2747: fnd_file.put_line(fnd_file.output,'Term Id: '||l_trx_header_tbl(1).term_id);
2748: fnd_file.put_line(fnd_file.output,'Comments" '||l_trx_header_tbl(1).comments);
2749:
2750: fnd_file.put_line(fnd_file.output,'Lines Table');
2751:
2752: FOR i in l_trx_lines_tbl.FIRST..l_trx_lines_tbl.LAST LOOP
2753: fnd_file.put_line(fnd_file.output,'Trx Header Id :'||
2754: l_trx_lines_tbl(i).trx_header_id);

Line 2753: fnd_file.put_line(fnd_file.output,'Trx Header Id :'||

2749:
2750: fnd_file.put_line(fnd_file.output,'Lines Table');
2751:
2752: FOR i in l_trx_lines_tbl.FIRST..l_trx_lines_tbl.LAST LOOP
2753: fnd_file.put_line(fnd_file.output,'Trx Header Id :'||
2754: l_trx_lines_tbl(i).trx_header_id);
2755: fnd_file.put_line(fnd_file.output,'Trx Line Id
2756: :'||l_trx_lines_tbl(i).trx_line_id);
2757: fnd_file.put_line(fnd_file.output,'Line

Line 2755: fnd_file.put_line(fnd_file.output,'Trx Line Id

2751:
2752: FOR i in l_trx_lines_tbl.FIRST..l_trx_lines_tbl.LAST LOOP
2753: fnd_file.put_line(fnd_file.output,'Trx Header Id :'||
2754: l_trx_lines_tbl(i).trx_header_id);
2755: fnd_file.put_line(fnd_file.output,'Trx Line Id
2756: :'||l_trx_lines_tbl(i).trx_line_id);
2757: fnd_file.put_line(fnd_file.output,'Line
2758: Number:'||l_trx_lines_tbl(i).line_number);
2759: fnd_file.put_line(fnd_file.output,'Inventory Item

Line 2757: fnd_file.put_line(fnd_file.output,'Line

2753: fnd_file.put_line(fnd_file.output,'Trx Header Id :'||
2754: l_trx_lines_tbl(i).trx_header_id);
2755: fnd_file.put_line(fnd_file.output,'Trx Line Id
2756: :'||l_trx_lines_tbl(i).trx_line_id);
2757: fnd_file.put_line(fnd_file.output,'Line
2758: Number:'||l_trx_lines_tbl(i).line_number);
2759: fnd_file.put_line(fnd_file.output,'Inventory Item
2760: Id:'||l_trx_lines_tbl(i).inventory_item_id);
2761: fnd_file.put_line(fnd_file.output,'Quantity Ordered

Line 2759: fnd_file.put_line(fnd_file.output,'Inventory Item

2755: fnd_file.put_line(fnd_file.output,'Trx Line Id
2756: :'||l_trx_lines_tbl(i).trx_line_id);
2757: fnd_file.put_line(fnd_file.output,'Line
2758: Number:'||l_trx_lines_tbl(i).line_number);
2759: fnd_file.put_line(fnd_file.output,'Inventory Item
2760: Id:'||l_trx_lines_tbl(i).inventory_item_id);
2761: fnd_file.put_line(fnd_file.output,'Quantity Ordered
2762: :'||l_trx_lines_tbl(i).quantity_ordered);
2763: fnd_file.put_line(fnd_file.output,'unit standard

Line 2761: fnd_file.put_line(fnd_file.output,'Quantity Ordered

2757: fnd_file.put_line(fnd_file.output,'Line
2758: Number:'||l_trx_lines_tbl(i).line_number);
2759: fnd_file.put_line(fnd_file.output,'Inventory Item
2760: Id:'||l_trx_lines_tbl(i).inventory_item_id);
2761: fnd_file.put_line(fnd_file.output,'Quantity Ordered
2762: :'||l_trx_lines_tbl(i).quantity_ordered);
2763: fnd_file.put_line(fnd_file.output,'unit standard
2764: price:'||l_trx_lines_tbl(i).unit_standard_price);
2765: fnd_file.put_line(fnd_file.output,'unit selling price

Line 2763: fnd_file.put_line(fnd_file.output,'unit standard

2759: fnd_file.put_line(fnd_file.output,'Inventory Item
2760: Id:'||l_trx_lines_tbl(i).inventory_item_id);
2761: fnd_file.put_line(fnd_file.output,'Quantity Ordered
2762: :'||l_trx_lines_tbl(i).quantity_ordered);
2763: fnd_file.put_line(fnd_file.output,'unit standard
2764: price:'||l_trx_lines_tbl(i).unit_standard_price);
2765: fnd_file.put_line(fnd_file.output,'unit selling price
2766: '||l_trx_lines_tbl(i).unit_selling_price);
2767: fnd_file.put_line(fnd_file.output,'line type:'||l_trx_lines_tbl(i).line_type);

Line 2765: fnd_file.put_line(fnd_file.output,'unit selling price

2761: fnd_file.put_line(fnd_file.output,'Quantity Ordered
2762: :'||l_trx_lines_tbl(i).quantity_ordered);
2763: fnd_file.put_line(fnd_file.output,'unit standard
2764: price:'||l_trx_lines_tbl(i).unit_standard_price);
2765: fnd_file.put_line(fnd_file.output,'unit selling price
2766: '||l_trx_lines_tbl(i).unit_selling_price);
2767: fnd_file.put_line(fnd_file.output,'line type:'||l_trx_lines_tbl(i).line_type);
2768: fnd_file.put_line(fnd_file.output,'Interface Line
2769: Context:'||l_trx_lines_tbl(i).interface_line_context);

Line 2767: fnd_file.put_line(fnd_file.output,'line type:'||l_trx_lines_tbl(i).line_type);

2763: fnd_file.put_line(fnd_file.output,'unit standard
2764: price:'||l_trx_lines_tbl(i).unit_standard_price);
2765: fnd_file.put_line(fnd_file.output,'unit selling price
2766: '||l_trx_lines_tbl(i).unit_selling_price);
2767: fnd_file.put_line(fnd_file.output,'line type:'||l_trx_lines_tbl(i).line_type);
2768: fnd_file.put_line(fnd_file.output,'Interface Line
2769: Context:'||l_trx_lines_tbl(i).interface_line_context);
2770: fnd_file.put_line(fnd_file.output,'Interface Line Attribute6
2771: :'||l_trx_lines_tbl(i).interface_line_attribute6);

Line 2768: fnd_file.put_line(fnd_file.output,'Interface Line

2764: price:'||l_trx_lines_tbl(i).unit_standard_price);
2765: fnd_file.put_line(fnd_file.output,'unit selling price
2766: '||l_trx_lines_tbl(i).unit_selling_price);
2767: fnd_file.put_line(fnd_file.output,'line type:'||l_trx_lines_tbl(i).line_type);
2768: fnd_file.put_line(fnd_file.output,'Interface Line
2769: Context:'||l_trx_lines_tbl(i).interface_line_context);
2770: fnd_file.put_line(fnd_file.output,'Interface Line Attribute6
2771: :'||l_trx_lines_tbl(i).interface_line_attribute6);
2772: fnd_file.put_line(fnd_file.output,'Interface Line Attribute7

Line 2770: fnd_file.put_line(fnd_file.output,'Interface Line Attribute6

2766: '||l_trx_lines_tbl(i).unit_selling_price);
2767: fnd_file.put_line(fnd_file.output,'line type:'||l_trx_lines_tbl(i).line_type);
2768: fnd_file.put_line(fnd_file.output,'Interface Line
2769: Context:'||l_trx_lines_tbl(i).interface_line_context);
2770: fnd_file.put_line(fnd_file.output,'Interface Line Attribute6
2771: :'||l_trx_lines_tbl(i).interface_line_attribute6);
2772: fnd_file.put_line(fnd_file.output,'Interface Line Attribute7
2773: :'||l_trx_lines_tbl(i).interface_line_attribute7);
2774: fnd_file.put_line(fnd_file.output,'Interface Line

Line 2772: fnd_file.put_line(fnd_file.output,'Interface Line Attribute7

2768: fnd_file.put_line(fnd_file.output,'Interface Line
2769: Context:'||l_trx_lines_tbl(i).interface_line_context);
2770: fnd_file.put_line(fnd_file.output,'Interface Line Attribute6
2771: :'||l_trx_lines_tbl(i).interface_line_attribute6);
2772: fnd_file.put_line(fnd_file.output,'Interface Line Attribute7
2773: :'||l_trx_lines_tbl(i).interface_line_attribute7);
2774: fnd_file.put_line(fnd_file.output,'Interface Line
2775: Attribute9:'||l_trx_lines_tbl(i).interface_line_Attribute9);
2776: fnd_file.put_line(fnd_file.output,'Interface Line

Line 2774: fnd_file.put_line(fnd_file.output,'Interface Line

2770: fnd_file.put_line(fnd_file.output,'Interface Line Attribute6
2771: :'||l_trx_lines_tbl(i).interface_line_attribute6);
2772: fnd_file.put_line(fnd_file.output,'Interface Line Attribute7
2773: :'||l_trx_lines_tbl(i).interface_line_attribute7);
2774: fnd_file.put_line(fnd_file.output,'Interface Line
2775: Attribute9:'||l_trx_lines_tbl(i).interface_line_Attribute9);
2776: fnd_file.put_line(fnd_file.output,'Interface Line
2777: Attribute10:'||l_trx_lines_tbl(i).interfacE_line_attribute10);
2778: fnd_file.put_line(fnd_file.output,'Interface Line Attribute

Line 2776: fnd_file.put_line(fnd_file.output,'Interface Line

2772: fnd_file.put_line(fnd_file.output,'Interface Line Attribute7
2773: :'||l_trx_lines_tbl(i).interface_line_attribute7);
2774: fnd_file.put_line(fnd_file.output,'Interface Line
2775: Attribute9:'||l_trx_lines_tbl(i).interface_line_Attribute9);
2776: fnd_file.put_line(fnd_file.output,'Interface Line
2777: Attribute10:'||l_trx_lines_tbl(i).interfacE_line_attribute10);
2778: fnd_file.put_line(fnd_file.output,'Interface Line Attribute
2779: 13:'||l_trx_lines_tbl(i).interfacE_line_Attribute13);
2780: fnd_file.put_line(fnd_file.output,'Interface Line Atribute14

Line 2778: fnd_file.put_line(fnd_file.output,'Interface Line Attribute

2774: fnd_file.put_line(fnd_file.output,'Interface Line
2775: Attribute9:'||l_trx_lines_tbl(i).interface_line_Attribute9);
2776: fnd_file.put_line(fnd_file.output,'Interface Line
2777: Attribute10:'||l_trx_lines_tbl(i).interfacE_line_attribute10);
2778: fnd_file.put_line(fnd_file.output,'Interface Line Attribute
2779: 13:'||l_trx_lines_tbl(i).interfacE_line_Attribute13);
2780: fnd_file.put_line(fnd_file.output,'Interface Line Atribute14
2781: :'||l_trx_lines_tbl(i).interface_line_attribute14);
2782: fnd_file.put_line(fnd_file.output,'Amount :'||l_trx_lines_tbl(i).amount);

Line 2780: fnd_file.put_line(fnd_file.output,'Interface Line Atribute14

2776: fnd_file.put_line(fnd_file.output,'Interface Line
2777: Attribute10:'||l_trx_lines_tbl(i).interfacE_line_attribute10);
2778: fnd_file.put_line(fnd_file.output,'Interface Line Attribute
2779: 13:'||l_trx_lines_tbl(i).interfacE_line_Attribute13);
2780: fnd_file.put_line(fnd_file.output,'Interface Line Atribute14
2781: :'||l_trx_lines_tbl(i).interface_line_attribute14);
2782: fnd_file.put_line(fnd_file.output,'Amount :'||l_trx_lines_tbl(i).amount);
2783: fnd_file.put_line(fnd_file.output,'UOM Code :'||l_trx_lines_tbl(i).UOM_CODE);
2784: fnd_file.put_line(fnd_file.output,'Tax Exempt Flag

Line 2782: fnd_file.put_line(fnd_file.output,'Amount :'||l_trx_lines_tbl(i).amount);

2778: fnd_file.put_line(fnd_file.output,'Interface Line Attribute
2779: 13:'||l_trx_lines_tbl(i).interfacE_line_Attribute13);
2780: fnd_file.put_line(fnd_file.output,'Interface Line Atribute14
2781: :'||l_trx_lines_tbl(i).interface_line_attribute14);
2782: fnd_file.put_line(fnd_file.output,'Amount :'||l_trx_lines_tbl(i).amount);
2783: fnd_file.put_line(fnd_file.output,'UOM Code :'||l_trx_lines_tbl(i).UOM_CODE);
2784: fnd_file.put_line(fnd_file.output,'Tax Exempt Flag
2785: :'||l_trx_lines_tbl(i).tax_exempt_flag);
2786:

Line 2783: fnd_file.put_line(fnd_file.output,'UOM Code :'||l_trx_lines_tbl(i).UOM_CODE);

2779: 13:'||l_trx_lines_tbl(i).interfacE_line_Attribute13);
2780: fnd_file.put_line(fnd_file.output,'Interface Line Atribute14
2781: :'||l_trx_lines_tbl(i).interface_line_attribute14);
2782: fnd_file.put_line(fnd_file.output,'Amount :'||l_trx_lines_tbl(i).amount);
2783: fnd_file.put_line(fnd_file.output,'UOM Code :'||l_trx_lines_tbl(i).UOM_CODE);
2784: fnd_file.put_line(fnd_file.output,'Tax Exempt Flag
2785: :'||l_trx_lines_tbl(i).tax_exempt_flag);
2786:
2787: End LOOP;

Line 2784: fnd_file.put_line(fnd_file.output,'Tax Exempt Flag

2780: fnd_file.put_line(fnd_file.output,'Interface Line Atribute14
2781: :'||l_trx_lines_tbl(i).interface_line_attribute14);
2782: fnd_file.put_line(fnd_file.output,'Amount :'||l_trx_lines_tbl(i).amount);
2783: fnd_file.put_line(fnd_file.output,'UOM Code :'||l_trx_lines_tbl(i).UOM_CODE);
2784: fnd_file.put_line(fnd_file.output,'Tax Exempt Flag
2785: :'||l_trx_lines_tbl(i).tax_exempt_flag);
2786:
2787: End LOOP;
2788:

Line 2789: fnd_file.put_line(fnd_file.output,'Distributions Table');

2785: :'||l_trx_lines_tbl(i).tax_exempt_flag);
2786:
2787: End LOOP;
2788:
2789: fnd_file.put_line(fnd_file.output,'Distributions Table');
2790:
2791: FOR j in L_TRX_DIST_TBL.FIRST..L_TRX_DIST_TBL.LAST LOOP
2792: fnd_file.put_line(fnd_file.output,'Trx Dist Id :'||
2793: l_trx_dist_tbl(j).trx_dist_id);

Line 2792: fnd_file.put_line(fnd_file.output,'Trx Dist Id :'||

2788:
2789: fnd_file.put_line(fnd_file.output,'Distributions Table');
2790:
2791: FOR j in L_TRX_DIST_TBL.FIRST..L_TRX_DIST_TBL.LAST LOOP
2792: fnd_file.put_line(fnd_file.output,'Trx Dist Id :'||
2793: l_trx_dist_tbl(j).trx_dist_id);
2794: fnd_file.put_line(fnd_file.output,'Trx Header Id
2795: :'||l_trx_dist_tbl(j).trx_line_id);
2796: fnd_file.put_line(fnd_file.output,'Trx Line Id

Line 2794: fnd_file.put_line(fnd_file.output,'Trx Header Id

2790:
2791: FOR j in L_TRX_DIST_TBL.FIRST..L_TRX_DIST_TBL.LAST LOOP
2792: fnd_file.put_line(fnd_file.output,'Trx Dist Id :'||
2793: l_trx_dist_tbl(j).trx_dist_id);
2794: fnd_file.put_line(fnd_file.output,'Trx Header Id
2795: :'||l_trx_dist_tbl(j).trx_line_id);
2796: fnd_file.put_line(fnd_file.output,'Trx Line Id
2797: :'||l_trx_dist_tbl(j).trx_line_id);
2798: fnd_file.put_line(fnd_file.output,'Account class

Line 2796: fnd_file.put_line(fnd_file.output,'Trx Line Id

2792: fnd_file.put_line(fnd_file.output,'Trx Dist Id :'||
2793: l_trx_dist_tbl(j).trx_dist_id);
2794: fnd_file.put_line(fnd_file.output,'Trx Header Id
2795: :'||l_trx_dist_tbl(j).trx_line_id);
2796: fnd_file.put_line(fnd_file.output,'Trx Line Id
2797: :'||l_trx_dist_tbl(j).trx_line_id);
2798: fnd_file.put_line(fnd_file.output,'Account class
2799: :'||l_trx_dist_tbl(j).account_class);
2800: fnd_file.put_line(fnd_file.output,'Amount

Line 2798: fnd_file.put_line(fnd_file.output,'Account class

2794: fnd_file.put_line(fnd_file.output,'Trx Header Id
2795: :'||l_trx_dist_tbl(j).trx_line_id);
2796: fnd_file.put_line(fnd_file.output,'Trx Line Id
2797: :'||l_trx_dist_tbl(j).trx_line_id);
2798: fnd_file.put_line(fnd_file.output,'Account class
2799: :'||l_trx_dist_tbl(j).account_class);
2800: fnd_file.put_line(fnd_file.output,'Amount
2801: :'||l_trx_dist_tbl(j).amount);
2802: fnd_file.put_line(fnd_file.output,'acctd_amount

Line 2800: fnd_file.put_line(fnd_file.output,'Amount

2796: fnd_file.put_line(fnd_file.output,'Trx Line Id
2797: :'||l_trx_dist_tbl(j).trx_line_id);
2798: fnd_file.put_line(fnd_file.output,'Account class
2799: :'||l_trx_dist_tbl(j).account_class);
2800: fnd_file.put_line(fnd_file.output,'Amount
2801: :'||l_trx_dist_tbl(j).amount);
2802: fnd_file.put_line(fnd_file.output,'acctd_amount
2803: :'||l_trx_dist_tbl(j).acctd_amount);
2804: fnd_file.put_line(fnd_file.output,'Percent

Line 2802: fnd_file.put_line(fnd_file.output,'acctd_amount

2798: fnd_file.put_line(fnd_file.output,'Account class
2799: :'||l_trx_dist_tbl(j).account_class);
2800: fnd_file.put_line(fnd_file.output,'Amount
2801: :'||l_trx_dist_tbl(j).amount);
2802: fnd_file.put_line(fnd_file.output,'acctd_amount
2803: :'||l_trx_dist_tbl(j).acctd_amount);
2804: fnd_file.put_line(fnd_file.output,'Percent
2805: '||l_trx_dist_tbl(j).percent);
2806: fnd_file.put_line(fnd_file.output,'Code Combination Id

Line 2804: fnd_file.put_line(fnd_file.output,'Percent

2800: fnd_file.put_line(fnd_file.output,'Amount
2801: :'||l_trx_dist_tbl(j).amount);
2802: fnd_file.put_line(fnd_file.output,'acctd_amount
2803: :'||l_trx_dist_tbl(j).acctd_amount);
2804: fnd_file.put_line(fnd_file.output,'Percent
2805: '||l_trx_dist_tbl(j).percent);
2806: fnd_file.put_line(fnd_file.output,'Code Combination Id
2807: :'||l_trx_dist_tbl(j).code_combination_id);
2808: End LOOP;

Line 2806: fnd_file.put_line(fnd_file.output,'Code Combination Id

2802: fnd_file.put_line(fnd_file.output,'acctd_amount
2803: :'||l_trx_dist_tbl(j).acctd_amount);
2804: fnd_file.put_line(fnd_file.output,'Percent
2805: '||l_trx_dist_tbl(j).percent);
2806: fnd_file.put_line(fnd_file.output,'Code Combination Id
2807: :'||l_trx_dist_tbl(j).code_combination_id);
2808: End LOOP;
2809:
2810: AR_INVOICE_API_PUB.create_single_invoice(

Line 2823: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'After calling Invoice API'||

2819: x_return_status => l_return_status,
2820: x_msg_count => l_msg_count,
2821: x_msg_data => l_msg_data);
2822:
2823: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'After calling Invoice API'||
2824: l_return_status);
2825:
2826: x_ar_inv_tbl(l_num_cnt).receivables_invoice_id := l_customer_trx_id;
2827:

Line 2833: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'After calling Invoice API '||l_num_cnt

2829: -- cklee 4/4/07 note: set a proper error message!
2830: l_overall_err_sts := 'E';
2831: END IF;
2832:
2833: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'After calling Invoice API '||l_num_cnt
2834: ||'.. Assigned l_customer_trx_id = '||l_customer_trx_id|| ' ret sts '||l_return_status);
2835:
2836:
2837: -- Post Call Processing Block

Line 2839: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error_message: '||err_rec.error_message);

2835:
2836:
2837: -- Post Call Processing Block
2838: FOR err_rec IN err_csr LOOP
2839: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error_message: '||err_rec.error_message);
2840: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Invalid_value: '||err_rec.Invalid_value);
2841: END LOOP;
2842:
2843: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

Line 2840: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Invalid_value: '||err_rec.Invalid_value);

2836:
2837: -- Post Call Processing Block
2838: FOR err_rec IN err_csr LOOP
2839: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error_message: '||err_rec.error_message);
2840: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Invalid_value: '||err_rec.Invalid_value);
2841: END LOOP;
2842:
2843: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2844: x_msg_count := l_msg_count;

Line 2857: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Count is : '||l_cnt);

2853:
2854: SELECT count(*) INTO l_cnt
2855: FROM ar_trx_errors_gt;
2856:
2857: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Count is : '||l_cnt);
2858: IF l_cnt > 0 THEN
2859: l_err_cnt := 0;
2860: FOR ar_trx_rec IN ar_trx_errs_csr( 110 ) LOOP
2861: l_err_cnt := l_err_cnt + 1;

Line 2938: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Assigned Invoice Numbers: '||l_ar_inv_disp_num);

2934: --end: | 02-APR-07 cklee R12 Billing enhancement project |
2935:
2936: END LOOP; -- For each rec in XSI loop
2937:
2938: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Assigned Invoice Numbers: '||l_ar_inv_disp_num);
2939:
2940: -- -------------------------------------------------------
2941: -- Invoke Advance Receipts
2942: -- -------------------------------------------------------

Line 2944: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Begin: Apply Advance Receipts');

2940: -- -------------------------------------------------------
2941: -- Invoke Advance Receipts
2942: -- -------------------------------------------------------
2943: IF p_source = 'ADVANCE_RECEIPTS' THEN
2944: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Begin: Apply Advance Receipts');
2945: OKL_BPD_ADVANCED_CASH_APP_PUB.ADVANCED_CASH_APP
2946: ( p_api_version => p_api_version
2947: ,p_init_msg_list => p_init_msg_list
2948: ,x_return_status => x_return_status

Line 2958: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'End: Apply Advance Receipts');

2954: -- ,p_contract_num => p_contract_number
2955: ,p_cross_currency_allowed => 'Y'
2956: );
2957:
2958: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'End: Apply Advance Receipts');
2959: END IF;
2960:
2961: IF p_source = 'PRINCIPAL_PAYDOWN' THEN
2962: x_return_status := l_overall_err_sts;

Line 2987: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (EXCP) => '||SQLERRM);

2983: -- Exception handling
2984: ------------------------------------------------------------
2985:
2986: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2987: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (EXCP) => '||SQLERRM);
2988: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
2989: p_api_name => l_api_name,
2990: p_pkg_name => G_PKG_NAME,
2991: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',

Line 2997: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (UNEXP) => '||SQLERRM);

2993: x_msg_data => x_msg_data,
2994: p_api_type => '_PVT');
2995:
2996: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2997: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
2998: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
2999: p_api_name => l_api_name,
3000: p_pkg_name => G_PKG_NAME,
3001: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',

Line 3006: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (AR_API_CALL_EXCP) => '||SQLERRM);

3002: x_msg_count => x_msg_count,
3003: x_msg_data => x_msg_data,
3004: p_api_type => '_PVT');
3005: WHEN AR_API_CALL_EXCP THEN
3006: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (AR_API_CALL_EXCP) => '||SQLERRM);
3007: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3008: p_api_name => 'AR_INVOICE_API',
3009: p_pkg_name => G_PKG_NAME,
3010: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',

Line 3016: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (OTHERS) => '||SQLERRM);

3012: x_msg_data => x_msg_data,
3013: p_api_type => '_PVT');
3014:
3015: WHEN OTHERS THEN
3016: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (OTHERS) => '||SQLERRM);
3017: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
3018: p_api_name => l_api_name,
3019: p_pkg_name => G_PKG_NAME,
3020: p_exc_name => 'OTHERS',