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

Line 398: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,l_output_var);

394: l_output_var := NULL;
395: l_output_var := l_output_var||rPAD(' ', 63, ' ');
396: l_output_var := l_output_var||' Oracle Lease and Finance Management';
397: l_output_var := l_output_var||rPAD(' ', 63, ' ');
398: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,l_output_var);
399:
400: l_output_var := NULL;
401: l_output_var := l_output_var||rPAD(' ', 150, ' ');
402: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,l_output_var);

Line 402: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,l_output_var);

398: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,l_output_var);
399:
400: l_output_var := NULL;
401: l_output_var := l_output_var||rPAD(' ', 150, ' ');
402: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,l_output_var);
403:
404: l_output_var := NULL;
405: l_output_var := l_output_var||rPAD(' ', 60, ' ');
406: l_output_var := l_output_var||' Billing Reconciliation Report';

Line 408: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,l_output_var);

404: l_output_var := NULL;
405: l_output_var := l_output_var||rPAD(' ', 60, ' ');
406: l_output_var := l_output_var||' Billing Reconciliation Report';
407: l_output_var := l_output_var||rPAD(' ', 60, ' ');
408: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,l_output_var);
409:
410: l_output_var := NULL;
411: l_output_var := l_output_var||rPAD(' ', 150, ' ');
412: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,l_output_var);

Line 412: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,l_output_var);

408: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,l_output_var);
409:
410: l_output_var := NULL;
411: l_output_var := l_output_var||rPAD(' ', 150, ' ');
412: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,l_output_var);
413:
414: l_output_var := NULL;
415: l_output_var := l_output_var||'Run Date: ';
416: l_output_var := l_output_var||to_char(sysdate,'DD-MON-YYYY');

Line 420: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,l_output_var);

416: l_output_var := l_output_var||to_char(sysdate,'DD-MON-YYYY');
417: l_output_var := l_output_var||rPAD(' ', 107, ' ');
418: l_output_var := l_output_var||'Request Id: ';
419: l_output_var := l_output_var||SUBSTR(lpad(Fnd_Global.CONC_REQUEST_ID,10,' '),1,10);
420: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,l_output_var);
421:
422: l_output_var := NULL;
423: l_output_var := l_output_var||'Operating Unit: ';
424: l_output_var := l_output_var||rpad(l_op_unit_name,134,' ');

Line 425: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,l_output_var);

421:
422: l_output_var := NULL;
423: l_output_var := l_output_var||'Operating Unit: ';
424: l_output_var := l_output_var||rpad(l_op_unit_name,134,' ');
425: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,l_output_var);
426:
427: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('-', 150, '-'));
428:
429:

Line 427: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('-', 150, '-'));

423: l_output_var := l_output_var||'Operating Unit: ';
424: l_output_var := l_output_var||rpad(l_op_unit_name,134,' ');
425: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,l_output_var);
426:
427: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('-', 150, '-'));
428:
429:
430: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));
431:

Line 430: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));

426:
427: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('-', 150, '-'));
428:
429:
430: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));
431:
432: l_output_var := NULL;
433: l_output_var := l_output_var||'Parameters ';
434: l_output_var := l_output_var||rpad(' ',139,' ');

Line 435: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,l_output_var);

431:
432: l_output_var := NULL;
433: l_output_var := l_output_var||'Parameters ';
434: l_output_var := l_output_var||rpad(' ',139,' ');
435: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,l_output_var);
436: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));
437:
438: l_output_var := NULL;
439: l_output_var := l_output_var||'From Date: ';

Line 436: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));

432: l_output_var := NULL;
433: l_output_var := l_output_var||'Parameters ';
434: l_output_var := l_output_var||rpad(' ',139,' ');
435: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,l_output_var);
436: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));
437:
438: l_output_var := NULL;
439: l_output_var := l_output_var||'From Date: ';
440: l_output_var := l_output_var||rpad(NVL(to_char(p_from_bill_date,'DD-MON-YYYY'),'Not Supplied'),12,' ');

Line 444: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,l_output_var);

440: l_output_var := l_output_var||rpad(NVL(to_char(p_from_bill_date,'DD-MON-YYYY'),'Not Supplied'),12,' ');
441: l_output_var := l_output_var||rPAD(' ', 106, ' ');
442: l_output_var := l_output_var||'To Date: ';
443: l_output_var := l_output_var||rpad(NVL(to_char(p_to_bill_date,'DD-MON-YYYY'),'Not Supplied'),12,' ');
444: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,l_output_var);
445:
446: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('Contract Number: '||NVL(p_contract_number,'Not Supplied'), 150, ' '));
447: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('-', 150, '-'));
448:

Line 446: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('Contract Number: '||NVL(p_contract_number,'Not Supplied'), 150, ' '));

442: l_output_var := l_output_var||'To Date: ';
443: l_output_var := l_output_var||rpad(NVL(to_char(p_to_bill_date,'DD-MON-YYYY'),'Not Supplied'),12,' ');
444: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,l_output_var);
445:
446: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('Contract Number: '||NVL(p_contract_number,'Not Supplied'), 150, ' '));
447: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('-', 150, '-'));
448:
449: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));
450:

Line 447: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('-', 150, '-'));

443: l_output_var := l_output_var||rpad(NVL(to_char(p_to_bill_date,'DD-MON-YYYY'),'Not Supplied'),12,' ');
444: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,l_output_var);
445:
446: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('Contract Number: '||NVL(p_contract_number,'Not Supplied'), 150, ' '));
447: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('-', 150, '-'));
448:
449: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));
450:
451: l_output_var := NULL;

Line 449: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));

445:
446: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('Contract Number: '||NVL(p_contract_number,'Not Supplied'), 150, ' '));
447: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('-', 150, '-'));
448:
449: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));
450:
451: l_output_var := NULL;
452: l_output_var := l_output_var||'Invoice Summary';
453: l_output_var := l_output_var||rPAD(' ', 135, ' ');

Line 454: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,l_output_var);

450:
451: l_output_var := NULL;
452: l_output_var := l_output_var||'Invoice Summary';
453: l_output_var := l_output_var||rPAD(' ', 135, ' ');
454: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,l_output_var);
455: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));
456:
457: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('Summary Currency Streams Billed Bill w/o Streams Billed in Oracle Receivables Difference', 150, ' '));
458: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('--------------- -------- in Lease and Finance Management in Lease and Finance Management Receivables Interface -------------', 150, ' '));

Line 455: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));

451: l_output_var := NULL;
452: l_output_var := l_output_var||'Invoice Summary';
453: l_output_var := l_output_var||rPAD(' ', 135, ' ');
454: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,l_output_var);
455: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));
456:
457: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('Summary Currency Streams Billed Bill w/o Streams Billed in Oracle Receivables Difference', 150, ' '));
458: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('--------------- -------- in Lease and Finance Management in Lease and Finance Management Receivables Interface -------------', 150, ' '));
459: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ------------------- -------------------- ---------------- -------------- ', 150, ' '));

Line 457: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('Summary Currency Streams Billed Bill w/o Streams Billed in Oracle Receivables Difference', 150, ' '));

453: l_output_var := l_output_var||rPAD(' ', 135, ' ');
454: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,l_output_var);
455: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));
456:
457: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('Summary Currency Streams Billed Bill w/o Streams Billed in Oracle Receivables Difference', 150, ' '));
458: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('--------------- -------- in Lease and Finance Management in Lease and Finance Management Receivables Interface -------------', 150, ' '));
459: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ------------------- -------------------- ---------------- -------------- ', 150, ' '));
460:
461: -- --------------------------------------

Line 458: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('--------------- -------- in Lease and Finance Management in Lease and Finance Management Receivables Interface -------------', 150, ' '));

454: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,l_output_var);
455: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));
456:
457: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('Summary Currency Streams Billed Bill w/o Streams Billed in Oracle Receivables Difference', 150, ' '));
458: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('--------------- -------- in Lease and Finance Management in Lease and Finance Management Receivables Interface -------------', 150, ' '));
459: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ------------------- -------------------- ---------------- -------------- ', 150, ' '));
460:
461: -- --------------------------------------
462: -- OKL Invoice Summary

Line 459: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ------------------- -------------------- ---------------- -------------- ', 150, ' '));

455: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));
456:
457: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('Summary Currency Streams Billed Bill w/o Streams Billed in Oracle Receivables Difference', 150, ' '));
458: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('--------------- -------- in Lease and Finance Management in Lease and Finance Management Receivables Interface -------------', 150, ' '));
459: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ------------------- -------------------- ---------------- -------------- ', 150, ' '));
460:
461: -- --------------------------------------
462: -- OKL Invoice Summary
463: -- --------------------------------------

Line 580: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,l_output_var);

576: l_output_var := l_output_var||LPAD(to_char(l_cnt_diff,l_number_format),20,' ');
577: -- -------------------------------------------------------
578: -- Print out the Count of Invoices
579: -- -------------------------------------------------------
580: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,l_output_var);
581:
582: l_output_var := NULL;
583:
584: l_output_var := l_output_var||'Value of Invoices : ';

Line 600: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,l_output_var);

596:
597: -- -------------------------------------------------------
598: -- Print out the Value of Invoices
599: -- -------------------------------------------------------
600: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,l_output_var);
601:
602: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));
603:
604: END LOOP;

Line 602: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));

598: -- Print out the Value of Invoices
599: -- -------------------------------------------------------
600: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,l_output_var);
601:
602: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));
603:
604: END LOOP;
605:
606:

Line 607: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('-', 150, '-'));

603:
604: END LOOP;
605:
606:
607: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('-', 150, '-'));
608:
609: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));
610:
611: l_output_var := NULL;

Line 609: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));

605:
606:
607: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('-', 150, '-'));
608:
609: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));
610:
611: l_output_var := NULL;
612: l_output_var := l_output_var||'Details of Contract having Reconciliation Difference';
613: l_output_var := l_output_var||rPAD(' ', 98, ' ');

Line 614: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,l_output_var);

610:
611: l_output_var := NULL;
612: l_output_var := l_output_var||'Details of Contract having Reconciliation Difference';
613: l_output_var := l_output_var||rPAD(' ', 98, ' ');
614: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,l_output_var);
615: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));
616:
617: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('Contract Number Currency Streams Billed Bill w/o Streams Billed in Oracle Receivables Difference', 150, ' '));
618: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('--------------- -------- in Lease and Finance Management in Lease and Finance Management Receivables Interface -------------', 150, ' '));

Line 615: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));

611: l_output_var := NULL;
612: l_output_var := l_output_var||'Details of Contract having Reconciliation Difference';
613: l_output_var := l_output_var||rPAD(' ', 98, ' ');
614: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,l_output_var);
615: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));
616:
617: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('Contract Number Currency Streams Billed Bill w/o Streams Billed in Oracle Receivables Difference', 150, ' '));
618: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('--------------- -------- in Lease and Finance Management in Lease and Finance Management Receivables Interface -------------', 150, ' '));
619: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ------------------- -------------------- ---------------- -------------- ', 150, ' '));

Line 617: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('Contract Number Currency Streams Billed Bill w/o Streams Billed in Oracle Receivables Difference', 150, ' '));

613: l_output_var := l_output_var||rPAD(' ', 98, ' ');
614: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,l_output_var);
615: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));
616:
617: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('Contract Number Currency Streams Billed Bill w/o Streams Billed in Oracle Receivables Difference', 150, ' '));
618: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('--------------- -------- in Lease and Finance Management in Lease and Finance Management Receivables Interface -------------', 150, ' '));
619: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ------------------- -------------------- ---------------- -------------- ', 150, ' '));
620:
621:

Line 618: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('--------------- -------- in Lease and Finance Management in Lease and Finance Management Receivables Interface -------------', 150, ' '));

614: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,l_output_var);
615: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));
616:
617: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('Contract Number Currency Streams Billed Bill w/o Streams Billed in Oracle Receivables Difference', 150, ' '));
618: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('--------------- -------- in Lease and Finance Management in Lease and Finance Management Receivables Interface -------------', 150, ' '));
619: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ------------------- -------------------- ---------------- -------------- ', 150, ' '));
620:
621:
622: FOR khr_rec IN khr_csr( p_contract_number ) LOOP

Line 619: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ------------------- -------------------- ---------------- -------------- ', 150, ' '));

615: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));
616:
617: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('Contract Number Currency Streams Billed Bill w/o Streams Billed in Oracle Receivables Difference', 150, ' '));
618: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('--------------- -------- in Lease and Finance Management in Lease and Finance Management Receivables Interface -------------', 150, ' '));
619: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ------------------- -------------------- ---------------- -------------- ', 150, ' '));
620:
621:
622: FOR khr_rec IN khr_csr( p_contract_number ) LOOP
623:

Line 747: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(khr_rec.contract_number||':', 150, ' '));

743:
744:
745: IF (l_cnt_diff <> 0 OR l_amt_diff <> 0) THEN
746:
747: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(khr_rec.contract_number||':', 150, ' '));
748:
749: l_output_var := NULL;
750:
751: l_output_var := l_output_var||' Number of Invoices : ';

Line 766: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,l_output_var);

762: l_output_var := l_output_var||LPAD(to_char(l_cnt_diff,l_number_format),20,' ');
763: -- -------------------------------------------------------
764: -- Print out the Count of Invoices
765: -- -------------------------------------------------------
766: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,l_output_var);
767:
768: l_output_var := NULL;
769:
770: l_output_var := l_output_var||' Value of Invoices : ';

Line 785: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,l_output_var);

781: l_output_var := l_output_var||LPAD(to_char(l_amt_diff,l_amount_format),20,' ');
782: -- -------------------------------------------------------
783: -- Print out the Value of Invoices
784: -- -------------------------------------------------------
785: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,l_output_var);
786:
787: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));
788: END IF;
789:

Line 787: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));

783: -- Print out the Value of Invoices
784: -- -------------------------------------------------------
785: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,l_output_var);
786:
787: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));
788: END IF;
789:
790: END LOOP;
791:

Line 793: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('-', 150, '-'));

789:
790: END LOOP;
791:
792: END LOOP;
793: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('-', 150, '-'));
794:
795: l_output_var := NULL;
796: l_output_var := l_output_var||'Note: Above contracts may be reconciled by running following reports';
797: l_output_var := l_output_var||rPAD(' ', 82, ' ');

Line 798: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,l_output_var);

794:
795: l_output_var := NULL;
796: l_output_var := l_output_var||'Note: Above contracts may be reconciled by running following reports';
797: l_output_var := l_output_var||rPAD(' ', 82, ' ');
798: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,l_output_var);
799:
800: l_output_var := NULL;
801: l_output_var := l_output_var||'1) Prepare Receivables Bills';
802: l_output_var := l_output_var||rPAD(' ', 122, ' ');

Line 803: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,l_output_var);

799:
800: l_output_var := NULL;
801: l_output_var := l_output_var||'1) Prepare Receivables Bills';
802: l_output_var := l_output_var||rPAD(' ', 122, ' ');
803: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,l_output_var);
804:
805: l_output_var := NULL;
806: l_output_var := l_output_var||'2) Receivables Bills Consolidation';
807: l_output_var := l_output_var||rPAD(' ', 116, ' ');

Line 808: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,l_output_var);

804:
805: l_output_var := NULL;
806: l_output_var := l_output_var||'2) Receivables Bills Consolidation';
807: l_output_var := l_output_var||rPAD(' ', 116, ' ');
808: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,l_output_var);
809:
810: l_output_var := NULL;
811: l_output_var := l_output_var||'3) Receivables Invoices Transfer to AR';
812: l_output_var := l_output_var||rPAD(' ', 112, ' ');

Line 813: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,l_output_var);

809:
810: l_output_var := NULL;
811: l_output_var := l_output_var||'3) Receivables Invoices Transfer to AR';
812: l_output_var := l_output_var||rPAD(' ', 112, ' ');
813: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,l_output_var);
814:
815: -- --------------------------------------------
816: -- Print Interface Errors
817: -- --------------------------------------------

Line 818: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));

814:
815: -- --------------------------------------------
816: -- Print Interface Errors
817: -- --------------------------------------------
818: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));
819:
820: l_output_var := NULL;
821: l_output_var := l_output_var||'Details of Contracts not processed from Receivables Interface';
822: l_output_var := l_output_var||rPAD(' ', 89, ' ');

Line 823: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,l_output_var);

819:
820: l_output_var := NULL;
821: l_output_var := l_output_var||'Details of Contracts not processed from Receivables Interface';
822: l_output_var := l_output_var||rPAD(' ', 89, ' ');
823: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,l_output_var);
824:
825: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));
826:
827: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('Contract Number Asset Invoice Date Amount Stream Type Remarks ', 150, ' '));

Line 825: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));

821: l_output_var := l_output_var||'Details of Contracts not processed from Receivables Interface';
822: l_output_var := l_output_var||rPAD(' ', 89, ' ');
823: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,l_output_var);
824:
825: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));
826:
827: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('Contract Number Asset Invoice Date Amount Stream Type Remarks ', 150, ' '));
828: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('--------------- -------- ------------- ------------- ------------- -------------', 150, ' '));
829:

Line 827: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('Contract Number Asset Invoice Date Amount Stream Type Remarks ', 150, ' '));

823: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,l_output_var);
824:
825: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));
826:
827: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('Contract Number Asset Invoice Date Amount Stream Type Remarks ', 150, ' '));
828: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('--------------- -------- ------------- ------------- ------------- -------------', 150, ' '));
829:
830: FOR khr_rec IN khr_csr( p_contract_number ) LOOP
831:

Line 828: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('--------------- -------- ------------- ------------- ------------- -------------', 150, ' '));

824:
825: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));
826:
827: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('Contract Number Asset Invoice Date Amount Stream Type Remarks ', 150, ' '));
828: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('--------------- -------- ------------- ------------- ------------- -------------', 150, ' '));
829:
830: FOR khr_rec IN khr_csr( p_contract_number ) LOOP
831:
832: FOR interface_rec IN int_err_csr( khr_rec.contract_number

Line 867: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, l_output_var);

863: l_output_var := l_output_var||SUBSTR(NVL(interface_rec.stream_type,'None'),1,25);
864: l_output_var := l_output_var||RPAD(' ',17,' ');
865: l_output_var := l_output_var||NVL(interface_rec.remarks,'None');
866:
867: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, l_output_var);
868: END LOOP;
869: END LOOP;
870: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('-', 150, '-'));
871:

Line 870: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('-', 150, '-'));

866:
867: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, l_output_var);
868: END LOOP;
869: END LOOP;
870: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('-', 150, '-'));
871:
872: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));
873: l_output_var := NULL;
874: l_output_var := l_output_var||'NOTE: Invoices in Receivables interfaces can be cleared by resolving errors in the interface,';

Line 872: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));

868: END LOOP;
869: END LOOP;
870: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD('-', 150, '-'));
871:
872: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));
873: l_output_var := NULL;
874: l_output_var := l_output_var||'NOTE: Invoices in Receivables interfaces can be cleared by resolving errors in the interface,';
875: l_output_var := l_output_var||' if any, and running Autoinvoice program.';
876: l_output_var := l_output_var||rPAD(' ', 16, ' ');

Line 877: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,l_output_var);

873: l_output_var := NULL;
874: l_output_var := l_output_var||'NOTE: Invoices in Receivables interfaces can be cleared by resolving errors in the interface,';
875: l_output_var := l_output_var||' if any, and running Autoinvoice program.';
876: l_output_var := l_output_var||rPAD(' ', 16, ' ');
877: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,l_output_var);
878:
879:
880: ------------------------------------------------------------
881: -- End processing

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

891: -- Exception handling
892: ------------------------------------------------------------
893:
894: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
895: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (EXCP) => '||SQLERRM);
896: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
897: p_api_name => l_api_name,
898: p_pkg_name => G_PKG_NAME,
899: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',

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

901: x_msg_data => x_msg_data,
902: p_api_type => '_PVT');
903:
904: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
905: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
906: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
907: p_api_name => l_api_name,
908: p_pkg_name => G_PKG_NAME,
909: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',

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

911: x_msg_data => x_msg_data,
912: p_api_type => '_PVT');
913:
914: WHEN OTHERS THEN
915: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (OTHERS) => '||SQLERRM);
916: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
917: p_api_name => l_api_name,
918: p_pkg_name => G_PKG_NAME,
919: p_exc_name => 'OTHERS',

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

959: p_to_bill_date => l_to_bill_date);
960:
961: EXCEPTION
962: WHEN OTHERS THEN
963: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (OTHERS) => '||SQLERRM);
964: END recon_report_conc;
965:
966:
967: END OKL_BILLING_RECON_RPT_PVT;