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

Line 1243: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Contract Number :'||chr_dtls_rec.contract_number);

1239:
1240: IF l_instrument_payment_use_id IS NULL THEN
1241: -- Write Contract Number in the log so that user can identify
1242: --for which contract it is failing
1243: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Contract Number :'||chr_dtls_rec.contract_number);
1244: fnd_message.set_name('AR', 'AR_RAXTRX-1763');
1245: fnd_msg_pub.add;
1246: RAISE FND_API.G_EXC_ERROR;
1247: END IF;

Line 1339: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Contract Number :'||chr_dtls_rec.contract_number);

1335:
1336: ELSE
1337: -- Write Contract Number in the log so that user can identify
1338: --for which contract it is failing
1339: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Contract Number :'||chr_dtls_rec.contract_number);
1340: fnd_message.set_name('AR', 'AR_RAXTRX-1763');
1341: fnd_msg_pub.add;
1342: RAISE FND_API.G_EXC_ERROR;
1343: END IF;

Line 1397: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Contract Number :'||chr_dtls_rec.contract_number);

1393: END IF;
1394: IF l_instrument_payment_use_id IS NULL THEN
1395: -- Write Contract Number in the log so that user can identify
1396: --for which contract it is failing
1397: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Contract Number :'||chr_dtls_rec.contract_number);
1398: fnd_message.set_name('AR', 'AR_RAXTRX-1763');
1399: fnd_msg_pub.add;
1400: RAISE FND_API.G_EXC_ERROR;
1401: END IF;

Line 1769: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Contract Number :'||chr_dtls_rec.contract_number);

1765: -- If Bank account is not defined at AR Customer Setup also, then throw error
1766: IF l_instrument_payment_use_id IS NULL THEN
1767: -- Write Contract Number in the log so that user can identify
1768: -- for which contract it is failing
1769: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Contract Number :'||chr_dtls_rec.contract_number);
1770: fnd_message.set_name('AR', 'AR_RAXTRX-1763');
1771: fnd_msg_pub.add;
1772: RAISE FND_API.G_EXC_ERROR;
1773: END IF;

Line 2572: FND_FILE.PUT_LINE(FND_FILE.LOG,

2568: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','l_memo_line_id:'||l_memo_line_id);
2569: END IF;
2570:
2571: if l_memo_line_id is null then
2572: FND_FILE.PUT_LINE(FND_FILE.LOG,
2573: 'WARNING: A memo line with name -- Lease Upfront Tax,
2574: must exist to import tax-only invoices.');
2575: end if;
2576: */

Line 2658: FND_FILE.PUT_LINE (FND_FILE.LOG, 'l_xfer_tbl count is: '||l_xfer_tbl.COUNT);

2654: LOOP
2655: l_xfer_tbl.delete;
2656: FETCH xfer_csr BULK COLLECT INTO l_xfer_tbl LIMIT L_FETCH_SIZE;
2657:
2658: FND_FILE.PUT_LINE (FND_FILE.LOG, 'l_xfer_tbl count is: '||l_xfer_tbl.COUNT);
2659: -- --------------------------------------
2660: -- Process bulk-fetched records
2661: -- --------------------------------------
2662: IF l_xfer_tbl.COUNT > 0 THEN

Line 4211: FND_FILE.put_line(fnd_file.log,

4207: EXCEPTION
4208: WHEN OTHERS THEN
4209: l_error_tai_tbl(l_error_tai_cnt) := l_xfer_tbl(k).tai_id;
4210:
4211: FND_FILE.put_line(fnd_file.log,
4212: '--------- ERROR LOG START ---------------' );
4213: FND_FILE.put_line(fnd_file.log,
4214: 'CONTRACT_NUMBER : ' || l_xfer_tbl(k).CONTRACT_NUMBER);
4215: FND_FILE.put_line(fnd_file.log,

Line 4213: FND_FILE.put_line(fnd_file.log,

4209: l_error_tai_tbl(l_error_tai_cnt) := l_xfer_tbl(k).tai_id;
4210:
4211: FND_FILE.put_line(fnd_file.log,
4212: '--------- ERROR LOG START ---------------' );
4213: FND_FILE.put_line(fnd_file.log,
4214: 'CONTRACT_NUMBER : ' || l_xfer_tbl(k).CONTRACT_NUMBER);
4215: FND_FILE.put_line(fnd_file.log,
4216: 'ASSET_NUMBER : ' || l_xfer_tbl(k).ASSET_NUMBER);
4217:

Line 4215: FND_FILE.put_line(fnd_file.log,

4211: FND_FILE.put_line(fnd_file.log,
4212: '--------- ERROR LOG START ---------------' );
4213: FND_FILE.put_line(fnd_file.log,
4214: 'CONTRACT_NUMBER : ' || l_xfer_tbl(k).CONTRACT_NUMBER);
4215: FND_FILE.put_line(fnd_file.log,
4216: 'ASSET_NUMBER : ' || l_xfer_tbl(k).ASSET_NUMBER);
4217:
4218: FND_MSG_PUB.Count_And_Get
4219: (p_count => x_msg_count,

Line 4229: -- FND_FILE.put_line(fnd_file.log,

4225: fnd_msg_pub.get (p_msg_index => i,
4226: p_encoded => 'F',
4227: p_data => lx_msg_data,
4228: p_msg_index_out => l_msg_index_out);
4229: -- FND_FILE.put_line(fnd_file.log,
4230: -- 'ERROR (OKL_ARIntf_Pvt.Get_REC_FEEDER): ' || lx_msg_data);
4231: END LOOP;
4232: FND_FILE.put_line(fnd_file.log,
4233: 'ERROR (OKL_ARIntf_Pvt.Get_REC_FEEDER): ' || lx_msg_data);

Line 4232: FND_FILE.put_line(fnd_file.log,

4228: p_msg_index_out => l_msg_index_out);
4229: -- FND_FILE.put_line(fnd_file.log,
4230: -- 'ERROR (OKL_ARIntf_Pvt.Get_REC_FEEDER): ' || lx_msg_data);
4231: END LOOP;
4232: FND_FILE.put_line(fnd_file.log,
4233: 'ERROR (OKL_ARIntf_Pvt.Get_REC_FEEDER): ' || lx_msg_data);
4234:
4235: END IF;
4236: FND_FILE.put_line(fnd_file.log,

Line 4236: FND_FILE.put_line(fnd_file.log,

4232: FND_FILE.put_line(fnd_file.log,
4233: 'ERROR (OKL_ARIntf_Pvt.Get_REC_FEEDER): ' || lx_msg_data);
4234:
4235: END IF;
4236: FND_FILE.put_line(fnd_file.log,
4237: '--------- ERROR LOG END ---------------' );
4238:
4239: l_error_tai_cnt := l_error_tai_cnt + 1;
4240: END;

Line 4648: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 54, ' ')||'Oracle Leasing and Finance Management'||lpad(' ', 55, ' '));

4644: FETCH op_unit_csr INTO l_op_unit_name;
4645: CLOSE op_unit_csr;
4646:
4647: -- Start New Out File stmathew 15-OCT-2004
4648: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 54, ' ')||'Oracle Leasing and Finance Management'||lpad(' ', 55, ' '));
4649: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
4650: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 49, ' ')||'Receivables Invoice Transfer To AR'||lpad(' ', 49, ' '));
4651: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 49, ' ')||'----------------------------------'||lpad(' ', 49, ' '));
4652: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));

Line 4649: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));

4645: CLOSE op_unit_csr;
4646:
4647: -- Start New Out File stmathew 15-OCT-2004
4648: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 54, ' ')||'Oracle Leasing and Finance Management'||lpad(' ', 55, ' '));
4649: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
4650: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 49, ' ')||'Receivables Invoice Transfer To AR'||lpad(' ', 49, ' '));
4651: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 49, ' ')||'----------------------------------'||lpad(' ', 49, ' '));
4652: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
4653: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));

Line 4650: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 49, ' ')||'Receivables Invoice Transfer To AR'||lpad(' ', 49, ' '));

4646:
4647: -- Start New Out File stmathew 15-OCT-2004
4648: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 54, ' ')||'Oracle Leasing and Finance Management'||lpad(' ', 55, ' '));
4649: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
4650: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 49, ' ')||'Receivables Invoice Transfer To AR'||lpad(' ', 49, ' '));
4651: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 49, ' ')||'----------------------------------'||lpad(' ', 49, ' '));
4652: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
4653: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
4654: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Operating Unit: '||l_op_unit_name);

Line 4651: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 49, ' ')||'----------------------------------'||lpad(' ', 49, ' '));

4647: -- Start New Out File stmathew 15-OCT-2004
4648: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 54, ' ')||'Oracle Leasing and Finance Management'||lpad(' ', 55, ' '));
4649: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
4650: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 49, ' ')||'Receivables Invoice Transfer To AR'||lpad(' ', 49, ' '));
4651: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 49, ' ')||'----------------------------------'||lpad(' ', 49, ' '));
4652: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
4653: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
4654: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Operating Unit: '||l_op_unit_name);
4655: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Request Id: '||l_request_id||lpad(' ',74,' ') ||'Run Date: '||to_char(sysdate));

Line 4652: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));

4648: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 54, ' ')||'Oracle Leasing and Finance Management'||lpad(' ', 55, ' '));
4649: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
4650: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 49, ' ')||'Receivables Invoice Transfer To AR'||lpad(' ', 49, ' '));
4651: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 49, ' ')||'----------------------------------'||lpad(' ', 49, ' '));
4652: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
4653: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
4654: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Operating Unit: '||l_op_unit_name);
4655: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Request Id: '||l_request_id||lpad(' ',74,' ') ||'Run Date: '||to_char(sysdate));
4656: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Currency: '||Okl_Accounting_Util.get_func_curr_code);

Line 4653: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));

4649: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
4650: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 49, ' ')||'Receivables Invoice Transfer To AR'||lpad(' ', 49, ' '));
4651: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 49, ' ')||'----------------------------------'||lpad(' ', 49, ' '));
4652: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
4653: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
4654: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Operating Unit: '||l_op_unit_name);
4655: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Request Id: '||l_request_id||lpad(' ',74,' ') ||'Run Date: '||to_char(sysdate));
4656: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Currency: '||Okl_Accounting_Util.get_func_curr_code);
4657: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad('-', 132, '-'));

Line 4654: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Operating Unit: '||l_op_unit_name);

4650: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 49, ' ')||'Receivables Invoice Transfer To AR'||lpad(' ', 49, ' '));
4651: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 49, ' ')||'----------------------------------'||lpad(' ', 49, ' '));
4652: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
4653: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
4654: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Operating Unit: '||l_op_unit_name);
4655: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Request Id: '||l_request_id||lpad(' ',74,' ') ||'Run Date: '||to_char(sysdate));
4656: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Currency: '||Okl_Accounting_Util.get_func_curr_code);
4657: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad('-', 132, '-'));
4658: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'From Bill Date : ' ||p_trx_date_from);

Line 4655: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Request Id: '||l_request_id||lpad(' ',74,' ') ||'Run Date: '||to_char(sysdate));

4651: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 49, ' ')||'----------------------------------'||lpad(' ', 49, ' '));
4652: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
4653: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
4654: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Operating Unit: '||l_op_unit_name);
4655: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Request Id: '||l_request_id||lpad(' ',74,' ') ||'Run Date: '||to_char(sysdate));
4656: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Currency: '||Okl_Accounting_Util.get_func_curr_code);
4657: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad('-', 132, '-'));
4658: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'From Bill Date : ' ||p_trx_date_from);
4659: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'To Bill Date : ' ||p_trx_date_to);

Line 4656: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Currency: '||Okl_Accounting_Util.get_func_curr_code);

4652: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
4653: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
4654: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Operating Unit: '||l_op_unit_name);
4655: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Request Id: '||l_request_id||lpad(' ',74,' ') ||'Run Date: '||to_char(sysdate));
4656: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Currency: '||Okl_Accounting_Util.get_func_curr_code);
4657: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad('-', 132, '-'));
4658: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'From Bill Date : ' ||p_trx_date_from);
4659: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'To Bill Date : ' ||p_trx_date_to);
4660: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad('-', 132, '-'));

Line 4657: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad('-', 132, '-'));

4653: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
4654: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Operating Unit: '||l_op_unit_name);
4655: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Request Id: '||l_request_id||lpad(' ',74,' ') ||'Run Date: '||to_char(sysdate));
4656: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Currency: '||Okl_Accounting_Util.get_func_curr_code);
4657: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad('-', 132, '-'));
4658: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'From Bill Date : ' ||p_trx_date_from);
4659: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'To Bill Date : ' ||p_trx_date_to);
4660: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad('-', 132, '-'));
4661: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));

Line 4658: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'From Bill Date : ' ||p_trx_date_from);

4654: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Operating Unit: '||l_op_unit_name);
4655: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Request Id: '||l_request_id||lpad(' ',74,' ') ||'Run Date: '||to_char(sysdate));
4656: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Currency: '||Okl_Accounting_Util.get_func_curr_code);
4657: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad('-', 132, '-'));
4658: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'From Bill Date : ' ||p_trx_date_from);
4659: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'To Bill Date : ' ||p_trx_date_to);
4660: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad('-', 132, '-'));
4661: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
4662: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));

Line 4659: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'To Bill Date : ' ||p_trx_date_to);

4655: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Request Id: '||l_request_id||lpad(' ',74,' ') ||'Run Date: '||to_char(sysdate));
4656: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Currency: '||Okl_Accounting_Util.get_func_curr_code);
4657: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad('-', 132, '-'));
4658: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'From Bill Date : ' ||p_trx_date_from);
4659: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'To Bill Date : ' ||p_trx_date_to);
4660: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad('-', 132, '-'));
4661: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
4662: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
4663:

Line 4660: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad('-', 132, '-'));

4656: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Currency: '||Okl_Accounting_Util.get_func_curr_code);
4657: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad('-', 132, '-'));
4658: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'From Bill Date : ' ||p_trx_date_from);
4659: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'To Bill Date : ' ||p_trx_date_to);
4660: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad('-', 132, '-'));
4661: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
4662: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
4663:
4664: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Processing Details:'||lpad(' ', 113, ' '));

Line 4661: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));

4657: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad('-', 132, '-'));
4658: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'From Bill Date : ' ||p_trx_date_from);
4659: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'To Bill Date : ' ||p_trx_date_to);
4660: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad('-', 132, '-'));
4661: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
4662: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
4663:
4664: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Processing Details:'||lpad(' ', 113, ' '));
4665: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));

Line 4662: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));

4658: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'From Bill Date : ' ||p_trx_date_from);
4659: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'To Bill Date : ' ||p_trx_date_to);
4660: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad('-', 132, '-'));
4661: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
4662: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
4663:
4664: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Processing Details:'||lpad(' ', 113, ' '));
4665: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
4666: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Number of Invoice Lines Selected: '||l_selected_count);

Line 4664: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Processing Details:'||lpad(' ', 113, ' '));

4660: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad('-', 132, '-'));
4661: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
4662: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
4663:
4664: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Processing Details:'||lpad(' ', 113, ' '));
4665: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
4666: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Number of Invoice Lines Selected: '||l_selected_count);
4667: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Number of Invoice Lines Transferred: '||l_succ_cnt);
4668: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Number of Invoice Lines Errored: '||(l_selected_count - l_succ_cnt));

Line 4665: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));

4661: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
4662: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
4663:
4664: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Processing Details:'||lpad(' ', 113, ' '));
4665: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
4666: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Number of Invoice Lines Selected: '||l_selected_count);
4667: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Number of Invoice Lines Transferred: '||l_succ_cnt);
4668: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Number of Invoice Lines Errored: '||(l_selected_count - l_succ_cnt));
4669:

Line 4666: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Number of Invoice Lines Selected: '||l_selected_count);

4662: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
4663:
4664: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Processing Details:'||lpad(' ', 113, ' '));
4665: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
4666: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Number of Invoice Lines Selected: '||l_selected_count);
4667: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Number of Invoice Lines Transferred: '||l_succ_cnt);
4668: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Number of Invoice Lines Errored: '||(l_selected_count - l_succ_cnt));
4669:
4670: -- START of code added as part of Bankruptcy changes - Bug#: 15953012, 15953954

Line 4667: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Number of Invoice Lines Transferred: '||l_succ_cnt);

4663:
4664: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Processing Details:'||lpad(' ', 113, ' '));
4665: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
4666: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Number of Invoice Lines Selected: '||l_selected_count);
4667: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Number of Invoice Lines Transferred: '||l_succ_cnt);
4668: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Number of Invoice Lines Errored: '||(l_selected_count - l_succ_cnt));
4669:
4670: -- START of code added as part of Bankruptcy changes - Bug#: 15953012, 15953954
4671: IF (l_cust_bkrpt_cnt >0 OR l_vndr_bkrpt_cnt >0)

Line 4668: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Number of Invoice Lines Errored: '||(l_selected_count - l_succ_cnt));

4664: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Processing Details:'||lpad(' ', 113, ' '));
4665: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
4666: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Number of Invoice Lines Selected: '||l_selected_count);
4667: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Number of Invoice Lines Transferred: '||l_succ_cnt);
4668: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Number of Invoice Lines Errored: '||(l_selected_count - l_succ_cnt));
4669:
4670: -- START of code added as part of Bankruptcy changes - Bug#: 15953012, 15953954
4671: IF (l_cust_bkrpt_cnt >0 OR l_vndr_bkrpt_cnt >0)
4672: THEN

Line 4674: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));

4670: -- START of code added as part of Bankruptcy changes - Bug#: 15953012, 15953954
4671: IF (l_cust_bkrpt_cnt >0 OR l_vndr_bkrpt_cnt >0)
4672: THEN
4673:
4674: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
4675: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,' Invoice Lines of below contracts are not Transferred because of Bankruptcy');
4676: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,' --------------------------------------------------------------------------');
4677:
4678: END IF;

Line 4675: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,' Invoice Lines of below contracts are not Transferred because of Bankruptcy');

4671: IF (l_cust_bkrpt_cnt >0 OR l_vndr_bkrpt_cnt >0)
4672: THEN
4673:
4674: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
4675: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,' Invoice Lines of below contracts are not Transferred because of Bankruptcy');
4676: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,' --------------------------------------------------------------------------');
4677:
4678: END IF;
4679:

Line 4676: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,' --------------------------------------------------------------------------');

4672: THEN
4673:
4674: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
4675: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,' Invoice Lines of below contracts are not Transferred because of Bankruptcy');
4676: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,' --------------------------------------------------------------------------');
4677:
4678: END IF;
4679:
4680:

Line 4684: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));

4680:
4681: IF (l_cust_bkrpt_cnt >0)
4682: THEN
4683:
4684: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
4685: FOR cust_bankrupt_cnt_rec IN cust_bankrupt_cnt_csr
4686: LOOP
4687:
4688: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rpad(' LESSEE : '||cust_bankrupt_cnt_rec.name,80,' ')||rpad('Contract# : '||cust_bankrupt_cnt_rec.khr_number,35,' ')||'No. of Lines not Transferred : '||cust_bankrupt_cnt_rec.cust_rec_cnt);

Line 4688: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rpad(' LESSEE : '||cust_bankrupt_cnt_rec.name,80,' ')||rpad('Contract# : '||cust_bankrupt_cnt_rec.khr_number,35,' ')||'No. of Lines not Transferred : '||cust_bankrupt_cnt_rec.cust_rec_cnt);

4684: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
4685: FOR cust_bankrupt_cnt_rec IN cust_bankrupt_cnt_csr
4686: LOOP
4687:
4688: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rpad(' LESSEE : '||cust_bankrupt_cnt_rec.name,80,' ')||rpad('Contract# : '||cust_bankrupt_cnt_rec.khr_number,35,' ')||'No. of Lines not Transferred : '||cust_bankrupt_cnt_rec.cust_rec_cnt);
4689:
4690: END LOOP;
4691:
4692: END IF;

Line 4697: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));

4693:
4694:
4695: IF (l_vndr_bkrpt_cnt >0)
4696: THEN
4697: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
4698: FOR vndr_bankrupt_cnt_rec IN vndr_bankrupt_cnt_csr
4699: LOOP
4700:
4701: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rpad(' LEASE VENDOR : '||vndr_bankrupt_cnt_rec.name,80,' ')||rpad('Contract# : '||vndr_bankrupt_cnt_rec.khr_number,35,' ')||'No. of Lines not Transferred : '||vndr_bankrupt_cnt_rec.vndr_rec_cnt);

Line 4701: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rpad(' LEASE VENDOR : '||vndr_bankrupt_cnt_rec.name,80,' ')||rpad('Contract# : '||vndr_bankrupt_cnt_rec.khr_number,35,' ')||'No. of Lines not Transferred : '||vndr_bankrupt_cnt_rec.vndr_rec_cnt);

4697: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
4698: FOR vndr_bankrupt_cnt_rec IN vndr_bankrupt_cnt_csr
4699: LOOP
4700:
4701: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rpad(' LEASE VENDOR : '||vndr_bankrupt_cnt_rec.name,80,' ')||rpad('Contract# : '||vndr_bankrupt_cnt_rec.khr_number,35,' ')||'No. of Lines not Transferred : '||vndr_bankrupt_cnt_rec.vndr_rec_cnt);
4702:
4703: END LOOP;
4704:
4705: END IF;

Line 4708: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));

4704:
4705: END IF;
4706: -- END of code added as part of Bankruptcy changes - Bug#: 15953012, 15953954
4707:
4708: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
4709:
4710:
4711: -- Start added as part of Bug#: 15953012, 15953954
4712: UPDATE okl_trx_ar_invoices_b

Line 4725: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Details of Errored Invoice Lines:'||lpad(' ', 97, ' '));

4721: -- End New Out File stmathew 15-OCT-2004
4722: IF x_msg_count > 0 THEN
4723: FOR i IN 1..x_msg_count LOOP
4724: IF i = 1 THEN
4725: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Details of Errored Invoice Lines:'||lpad(' ', 97, ' '));
4726: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
4727: END IF;
4728: fnd_msg_pub.get (p_msg_index => i,
4729: p_encoded => 'F',

Line 4726: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));

4722: IF x_msg_count > 0 THEN
4723: FOR i IN 1..x_msg_count LOOP
4724: IF i = 1 THEN
4725: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Details of Errored Invoice Lines:'||lpad(' ', 97, ' '));
4726: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
4727: END IF;
4728: fnd_msg_pub.get (p_msg_index => i,
4729: p_encoded => 'F',
4730: p_data => lx_msg_data,

Line 4733: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,TO_CHAR(i) || ': ' || lx_msg_data);

4729: p_encoded => 'F',
4730: p_data => lx_msg_data,
4731: p_msg_index_out => l_msg_index_out);
4732:
4733: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,TO_CHAR(i) || ': ' || lx_msg_data);
4734:
4735: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4736: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'okl_arintf_pvt',
4737: TO_CHAR(i) || ': ' || lx_msg_data);

Line 4812: FND_FILE.put_line(fnd_file.log,'ERROR (OKL_ARIntf_Pvt.Get_REC_FEEDER): ' || lx_msg_data);

4808: p_encoded => 'F',
4809: p_data => lx_msg_data,
4810: p_msg_index_out => l_msg_index_out);
4811:
4812: FND_FILE.put_line(fnd_file.log,'ERROR (OKL_ARIntf_Pvt.Get_REC_FEEDER): ' || lx_msg_data);
4813: END LOOP;
4814: END IF;
4815:
4816: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4830: FND_FILE.put_line(fnd_file.log,'ERROR (OKL_ARIntf_Pvt.Get_REC_FEEDER): ' || lx_msg_data);

4826: p_encoded => 'F',
4827: p_data => lx_msg_data,
4828: p_msg_index_out => l_msg_index_out);
4829:
4830: FND_FILE.put_line(fnd_file.log,'ERROR (OKL_ARIntf_Pvt.Get_REC_FEEDER): ' || lx_msg_data);
4831: END LOOP;
4832: END IF;
4833:
4834: WHEN OTHERS THEN