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

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

329:
330: -- ----------------------------------------------------------
331: -- Property Tax Header lines for the report
332: -- ----------------------------------------------------------
333: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 54, ' ')||'Oracle Lease and Finance Management'||lpad(' ', 55, ' '));
334:
335: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
336:
337: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 48, ' ')||'Property Tax Reconciliation Program'||lpad(' ', 49, ' '));

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

331: -- Property Tax Header lines for the report
332: -- ----------------------------------------------------------
333: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 54, ' ')||'Oracle Lease and Finance Management'||lpad(' ', 55, ' '));
334:
335: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
336:
337: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 48, ' ')||'Property Tax Reconciliation Program'||lpad(' ', 49, ' '));
338: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 48, ' ')||'-----------------------------------'||lpad(' ', 49, ' '));
339:

Line 337: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 48, ' ')||'Property Tax Reconciliation Program'||lpad(' ', 49, ' '));

333: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 54, ' ')||'Oracle Lease and Finance Management'||lpad(' ', 55, ' '));
334:
335: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
336:
337: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 48, ' ')||'Property Tax Reconciliation Program'||lpad(' ', 49, ' '));
338: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 48, ' ')||'-----------------------------------'||lpad(' ', 49, ' '));
339:
340: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
341: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));

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

334:
335: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
336:
337: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 48, ' ')||'Property Tax Reconciliation Program'||lpad(' ', 49, ' '));
338: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 48, ' ')||'-----------------------------------'||lpad(' ', 49, ' '));
339:
340: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
341: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
342:

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

336:
337: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 48, ' ')||'Property Tax Reconciliation Program'||lpad(' ', 49, ' '));
338: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 48, ' ')||'-----------------------------------'||lpad(' ', 49, ' '));
339:
340: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
341: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
342:
343: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Operating Unit: '||l_op_unit_name);
344: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Request Id: '||l_request_id||lpad(' ',74,' ') ||'Run Date: '||to_char(sysdate));

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

337: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 48, ' ')||'Property Tax Reconciliation Program'||lpad(' ', 49, ' '));
338: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 48, ' ')||'-----------------------------------'||lpad(' ', 49, ' '));
339:
340: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
341: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
342:
343: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Operating Unit: '||l_op_unit_name);
344: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Request Id: '||l_request_id||lpad(' ',74,' ') ||'Run Date: '||to_char(sysdate));
345: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Contract Number: '||p_contract_number);

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

339:
340: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
341: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
342:
343: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Operating Unit: '||l_op_unit_name);
344: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Request Id: '||l_request_id||lpad(' ',74,' ') ||'Run Date: '||to_char(sysdate));
345: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Contract Number: '||p_contract_number);
346: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Asset Number : '||p_asset_number);
347:

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

340: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
341: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
342:
343: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Operating Unit: '||l_op_unit_name);
344: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Request Id: '||l_request_id||lpad(' ',74,' ') ||'Run Date: '||to_char(sysdate));
345: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Contract Number: '||p_contract_number);
346: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Asset Number : '||p_asset_number);
347:
348: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));

Line 345: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Contract Number: '||p_contract_number);

341: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
342:
343: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Operating Unit: '||l_op_unit_name);
344: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Request Id: '||l_request_id||lpad(' ',74,' ') ||'Run Date: '||to_char(sysdate));
345: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Contract Number: '||p_contract_number);
346: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Asset Number : '||p_asset_number);
347:
348: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
349:

Line 346: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Asset Number : '||p_asset_number);

342:
343: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Operating Unit: '||l_op_unit_name);
344: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Request Id: '||l_request_id||lpad(' ',74,' ') ||'Run Date: '||to_char(sysdate));
345: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Contract Number: '||p_contract_number);
346: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Asset Number : '||p_asset_number);
347:
348: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
349:
350: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad('-', 132, '-'));

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

344: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Request Id: '||l_request_id||lpad(' ',74,' ') ||'Run Date: '||to_char(sysdate));
345: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Contract Number: '||p_contract_number);
346: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Asset Number : '||p_asset_number);
347:
348: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
349:
350: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad('-', 132, '-'));
351:
352: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Contract Number'||RPAD(' ',25,' ')||

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

346: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Asset Number : '||p_asset_number);
347:
348: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
349:
350: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad('-', 132, '-'));
351:
352: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Contract Number'||RPAD(' ',25,' ')||
353: 'Asset Number'||RPAD(' ',20,' ')||
354: 'Actual Property Tax'||RPAD(' ',7,' ')||

Line 352: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Contract Number'||RPAD(' ',25,' ')||

348: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
349:
350: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad('-', 132, '-'));
351:
352: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Contract Number'||RPAD(' ',25,' ')||
353: 'Asset Number'||RPAD(' ',20,' ')||
354: 'Actual Property Tax'||RPAD(' ',7,' ')||
355: 'Property Tax'||RPAD(' ',12,' ')||
356: 'Adjustment');

Line 357: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,' '||RPAD(' ',25,' ')||

353: 'Asset Number'||RPAD(' ',20,' ')||
354: 'Actual Property Tax'||RPAD(' ',7,' ')||
355: 'Property Tax'||RPAD(' ',12,' ')||
356: 'Adjustment');
357: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,' '||RPAD(' ',25,' ')||
358: ' '||RPAD(' ',24,' ')||
359: ' '||RPAD(' ',10,' ')||
360: ' Billed '||RPAD(' ',11,' ')||
361: ' Amount ');

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

358: ' '||RPAD(' ',24,' ')||
359: ' '||RPAD(' ',10,' ')||
360: ' Billed '||RPAD(' ',11,' ')||
361: ' Amount ');
362: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad('=', 132, '='));
363:
364: ------------------------------------------------------------
365: -- For each Contract and Asset
366: ------------------------------------------------------------

Line 384: FND_FILE.PUT_LINE (FND_FILE.LOG,'Processing Contract :'||term_contracts_rec.contract_number);

380: x_return_status,
381: l_sty_id);
382:
383:
384: FND_FILE.PUT_LINE (FND_FILE.LOG,'Processing Contract :'||term_contracts_rec.contract_number);
385:
386: ---------------------------------------------
387: -- Reset error message and error status for
388: -- each record

Line 413: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Creating Contract Transaction.');

409: l_trxH_in_rec.try_id := l_try_id;
410: l_trxH_in_rec.SOURCE_TRX_ID := term_contracts_rec.kle_id;
411: l_trxH_in_rec.SOURCE_TRX_TYPE := 'KLE';
412:
413: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Creating Contract Transaction.');
414: Okl_Trx_Contracts_Pub.create_trx_contracts(
415: p_api_version => l_api_version
416: ,p_init_msg_list => p_init_msg_list
417: ,x_return_status => l_return_status

Line 426: FND_FILE.PUT_LINE (FND_FILE.LOG,'Error: Creating header record in OKL_TRX_CONTRACTS');

422:
423: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
424: l_error_status := 'E';
425: l_error_message := 'Error: Creating header record in OKL_TRX_CONTRACTS';
426: FND_FILE.PUT_LINE (FND_FILE.LOG,'Error: Creating header record in OKL_TRX_CONTRACTS');
427: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
428: l_error_status := 'E';
429: l_error_message := 'Error: Creating header record in OKL_TRX_CONTRACTS';
430: FND_FILE.PUT_LINE (FND_FILE.LOG,'Error: Creating header record in OKL_TRX_CONTRACTS');

Line 430: FND_FILE.PUT_LINE (FND_FILE.LOG,'Error: Creating header record in OKL_TRX_CONTRACTS');

426: FND_FILE.PUT_LINE (FND_FILE.LOG,'Error: Creating header record in OKL_TRX_CONTRACTS');
427: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
428: l_error_status := 'E';
429: l_error_message := 'Error: Creating header record in OKL_TRX_CONTRACTS';
430: FND_FILE.PUT_LINE (FND_FILE.LOG,'Error: Creating header record in OKL_TRX_CONTRACTS');
431: END IF;
432:
433:
434: -- -------------------------------------------------

Line 474: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Creating Adjusted Property Tax Streams.');

470: OPEN c_sty_count_csr ( term_contracts_rec.ID, asset_rec.id, 'ADJUSTED_PROPERTY_TAX' );
471: FETCH c_sty_count_csr INTO l_actual_tax_count;
472: CLOSE c_sty_count_csr;
473:
474: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Creating Adjusted Property Tax Streams.');
475:
476: IF l_actual_tax_count > 0 THEN -- check for ADJUSTED property tax stream
477: NULL;
478: ELSE -- check for ADJUSTED property tax stream

Line 498: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Creating Adjusted Property Tax Streams');

494: l_stmv_rec.active_yn := 'Y';
495: l_stmv_rec.date_current := sysdate;
496: l_stmv_rec.comments := 'Adjusted Property Tax';
497:
498: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Creating Adjusted Property Tax Streams');
499:
500: Okl_Streams_Pub.create_streams(
501: p_api_version => p_api_version,
502: p_init_msg_list => p_init_msg_list,

Line 512: FND_FILE.PUT_LINE (FND_FILE.LOG,'Error: Creating Streams for Adjusted Property Tax');

508:
509: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
510: l_error_status := 'E';
511: l_error_message := 'Error: Creating header record in OKL_TRX_CONTRACTS';
512: FND_FILE.PUT_LINE (FND_FILE.LOG,'Error: Creating Streams for Adjusted Property Tax');
513: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
514: l_error_status := 'E';
515: l_error_message := 'Error: Creating Streams for Adjusted Property Tax';
516: FND_FILE.PUT_LINE (FND_FILE.LOG,'Error: Creating Streams for Adjusted Property Tax');

Line 516: FND_FILE.PUT_LINE (FND_FILE.LOG,'Error: Creating Streams for Adjusted Property Tax');

512: FND_FILE.PUT_LINE (FND_FILE.LOG,'Error: Creating Streams for Adjusted Property Tax');
513: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
514: l_error_status := 'E';
515: l_error_message := 'Error: Creating Streams for Adjusted Property Tax';
516: FND_FILE.PUT_LINE (FND_FILE.LOG,'Error: Creating Streams for Adjusted Property Tax');
517: END IF;
518: END IF; -- check for adjusted property tax stream
519: -- --------------------------------------------------------
520: -- Create stream elements, if there were no error messages

Line 543: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Creating Adjustment Stream Element.');

539: p_selv_rec.STREAM_ELEMENT_DATE := SYSDATE;
540: p_selv_rec.AMOUNT := l_adjusted_amt;
541: p_selv_rec.COMMENTS := 'Adjusted Property Tax';
542:
543: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Creating Adjustment Stream Element.');
544:
545: -- Create adjustment stream element only if the adjustment
546: -- amount is non-zero
547: IF l_adjusted_amt <> 0 THEN

Line 557: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Adjustment Stream Element not created because adjustment amount is zero.');

553: x_msg_data,
554: p_selv_rec,
555: x_selv_rec);
556: ELSE
557: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Adjustment Stream Element not created because adjustment amount is zero.');
558: END IF;
559:
560: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
561: l_error_status := 'E';

Line 563: FND_FILE.PUT_LINE (FND_FILE.LOG,'Error: Creating Adjusted Property Tax stream element');

559:
560: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
561: l_error_status := 'E';
562: l_error_message := 'Error: Creating Adjusted Property Tax stream element';
563: FND_FILE.PUT_LINE (FND_FILE.LOG,'Error: Creating Adjusted Property Tax stream element');
564: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
565: l_error_status := 'E';
566: l_error_message := 'Error: Creating Adjusted Property Tax stream element';
567: FND_FILE.PUT_LINE (FND_FILE.LOG,'Error: Creating Adjusted Property Tax stream element');

Line 567: FND_FILE.PUT_LINE (FND_FILE.LOG,'Error: Creating Adjusted Property Tax stream element');

563: FND_FILE.PUT_LINE (FND_FILE.LOG,'Error: Creating Adjusted Property Tax stream element');
564: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
565: l_error_status := 'E';
566: l_error_message := 'Error: Creating Adjusted Property Tax stream element';
567: FND_FILE.PUT_LINE (FND_FILE.LOG,'Error: Creating Adjusted Property Tax stream element');
568: END IF;
569: END IF; -- Process Error
570: END IF; -- Check if Bill Property Tax is 'ESTIMATED_ACTUAL'
571:

Line 575: FND_FILE.PUT_LINE (FND_FILE.LOG, 'l_actual_tax_amt: '||l_actual_tax_amt);

571:
572: -- -----------------------------------------------------
573: -- Get currency precision
574: -- -----------------------------------------------------
575: FND_FILE.PUT_LINE (FND_FILE.LOG, 'l_actual_tax_amt: '||l_actual_tax_amt);
576: FND_FILE.PUT_LINE (FND_FILE.LOG, 'l_estimated_tax_amt: '||l_estimated_tax_amt);
577: FND_FILE.PUT_LINE (FND_FILE.LOG, 'l_adjusted_amt: '||l_adjusted_amt);
578:
579: l_f_actual_tax_amt := okl_accounting_util.format_amount(l_actual_tax_amt, term_contracts_rec.currency_code);

Line 576: FND_FILE.PUT_LINE (FND_FILE.LOG, 'l_estimated_tax_amt: '||l_estimated_tax_amt);

572: -- -----------------------------------------------------
573: -- Get currency precision
574: -- -----------------------------------------------------
575: FND_FILE.PUT_LINE (FND_FILE.LOG, 'l_actual_tax_amt: '||l_actual_tax_amt);
576: FND_FILE.PUT_LINE (FND_FILE.LOG, 'l_estimated_tax_amt: '||l_estimated_tax_amt);
577: FND_FILE.PUT_LINE (FND_FILE.LOG, 'l_adjusted_amt: '||l_adjusted_amt);
578:
579: l_f_actual_tax_amt := okl_accounting_util.format_amount(l_actual_tax_amt, term_contracts_rec.currency_code);
580: l_f_estimated_tax_amt := okl_accounting_util.format_amount(l_estimated_tax_amt, term_contracts_rec.currency_code);

Line 577: FND_FILE.PUT_LINE (FND_FILE.LOG, 'l_adjusted_amt: '||l_adjusted_amt);

573: -- Get currency precision
574: -- -----------------------------------------------------
575: FND_FILE.PUT_LINE (FND_FILE.LOG, 'l_actual_tax_amt: '||l_actual_tax_amt);
576: FND_FILE.PUT_LINE (FND_FILE.LOG, 'l_estimated_tax_amt: '||l_estimated_tax_amt);
577: FND_FILE.PUT_LINE (FND_FILE.LOG, 'l_adjusted_amt: '||l_adjusted_amt);
578:
579: l_f_actual_tax_amt := okl_accounting_util.format_amount(l_actual_tax_amt, term_contracts_rec.currency_code);
580: l_f_estimated_tax_amt := okl_accounting_util.format_amount(l_estimated_tax_amt, term_contracts_rec.currency_code);
581: l_f_adjusted_amt := okl_accounting_util.format_amount(l_adjusted_amt, term_contracts_rec.currency_code);

Line 588: FND_FILE.PUT_LINE (FND_FILE.LOG, 'l_display_contract: '||l_display_contract);

584: l_display_contract := ' ';
585: ELSE
586: l_display_contract := term_contracts_rec.contract_number;
587: END IF;
588: FND_FILE.PUT_LINE (FND_FILE.LOG, 'l_display_contract: '||l_display_contract);
589: -- --------------------------
590: -- Record successful records
591: -- --------------------------
592: succ_tbl(succ_tbl_idx).l_display_contract := l_display_contract;

Line 600: FND_FILE.PUT_LINE (FND_FILE.LOG, 'asset_rec.name: '||asset_rec.name);

596: succ_tbl(succ_tbl_idx).adj_tax := l_f_adjusted_amt;
597:
598: succ_tbl_idx := succ_tbl_idx + 1;
599:
600: FND_FILE.PUT_LINE (FND_FILE.LOG, 'asset_rec.name: '||asset_rec.name);
601: /* FND_FILE.PUT_LINE (FND_FILE.OUTPUT, RPAD(SUBSTR(l_display_contract,1,25),25,' ' )|| */
602: /* RPAD(' ',15,' ')|| */
603: /* RPAD(SUBSTR(asset_rec.name,1,20),20,' ')|| */
604: /* RPAD(' ',6,' ')|| */

Line 601: /* FND_FILE.PUT_LINE (FND_FILE.OUTPUT, RPAD(SUBSTR(l_display_contract,1,25),25,' ' )|| */

597:
598: succ_tbl_idx := succ_tbl_idx + 1;
599:
600: FND_FILE.PUT_LINE (FND_FILE.LOG, 'asset_rec.name: '||asset_rec.name);
601: /* FND_FILE.PUT_LINE (FND_FILE.OUTPUT, RPAD(SUBSTR(l_display_contract,1,25),25,' ' )|| */
602: /* RPAD(' ',15,' ')|| */
603: /* RPAD(SUBSTR(asset_rec.name,1,20),20,' ')|| */
604: /* RPAD(' ',6,' ')|| */
605: /* lpad(SUBSTR(l_f_actual_tax_amt,1,22),22,' ')|| */

Line 641: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, RPAD(SUBSTR(succ_tbl(i).l_display_contract,1,25),25,' ' )||

637: -- -------------------------------
638: -- Loop thru the success records
639: -- -------------------------------
640: FOR i IN succ_tbl.FIRST..succ_tbl.LAST LOOP
641: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, RPAD(SUBSTR(succ_tbl(i).l_display_contract,1,25),25,' ' )||
642: RPAD(' ',15,' ')||
643: RPAD(SUBSTR(succ_tbl(i).asset_name,1,20),20,' ')||
644: RPAD(' ',6,' ')||
645: lpad(SUBSTR(succ_tbl(i).actual_tax,1,22),22,' ')||

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

651: UPDATE OKL_TRX_CONTRACTS
652: SET TSU_CODE = 'ERROR'
653: WHERE ID = l_trxH_out_rec.ID;
654: END IF;
655: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad(' ', 132, ' '));
656:
657: -- Start Bug 4520466
658: OKL_BILLING_CONTROLLER_PVT.track_next_bill_date( term_contracts_rec.id );
659: -- End Bug 4520466

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

659: -- End Bug 4520466
660:
661: END LOOP; -- loop for each contract
662:
663: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,rpad('=', 132, '='));
664: ------------------------------------------------------------
665: -- End processing
666: ------------------------------------------------------------
667: Okl_Api.END_ACTIVITY (

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

674: -- Exception handling
675: ------------------------------------------------------------
676:
677: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
678: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Error (EXCP) => '||SQLERRM);
679: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
680: p_api_name => l_api_name,
681: p_pkg_name => G_PKG_NAME,
682: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',

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

684: x_msg_data => x_msg_data,
685: p_api_type => '_PVT');
686:
687: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
688: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Error (UNEXP) => '||SQLERRM);
689: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
690: p_api_name => l_api_name,
691: p_pkg_name => G_PKG_NAME,
692: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',

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

694: x_msg_data => x_msg_data,
695: p_api_type => '_PVT');
696:
697: WHEN OTHERS THEN
698: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Error (OTHERS) => '||SQLERRM);
699: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
700: p_api_name => l_api_name,
701: p_pkg_name => G_PKG_NAME,
702: p_exc_name => 'OTHERS',