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

Line 589: Fnd_File.PUT_LINE (Fnd_File.LOG,'(Exception): When resolving request_id'||SQLERRM );

585: WHEN OTHERS THEN
586: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
587: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'(Exception): When resolving request_id'||SQLERRM );
588: END IF;
589: Fnd_File.PUT_LINE (Fnd_File.LOG,'(Exception): When resolving request_id'||SQLERRM );
590: END;
591:
592: --------------------------------------------------
593: -- Bulk insert TAI, TIL, TLD, XSI and XLS records

Line 603: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Transfering TAI records to TAI table...');

599: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
600: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inserting into okl_trx_ar_invoices_b');
601:
602: END IF;
603: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Transfering TAI records to TAI table...');
604:
605: Fnd_File.PUT_LINE (Fnd_File.LOG, 'tai_tbl.COUNT : ' || tai_tbl.COUNT);
606:
607: IF tai_tbl.COUNT > 0 THEN

Line 605: Fnd_File.PUT_LINE (Fnd_File.LOG, 'tai_tbl.COUNT : ' || tai_tbl.COUNT);

601:
602: END IF;
603: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Transfering TAI records to TAI table...');
604:
605: Fnd_File.PUT_LINE (Fnd_File.LOG, 'tai_tbl.COUNT : ' || tai_tbl.COUNT);
606:
607: IF tai_tbl.COUNT > 0 THEN
608: FORALL indx IN tai_tbl.first..tai_tbl.LAST
609: INSERT INTO OKL_TRX_AR_INVOICES_B

Line 620: FND_FILE.PUT_LINE (FND_FILE.LOG, 'tai_tbl(i).khr_id: '||tai_tbl(i).khr_id);

616: dist_khr_id_tbl.delete;
617:
618: for i in tai_tbl.first..tai_tbl.last loop
619:
620: FND_FILE.PUT_LINE (FND_FILE.LOG, 'tai_tbl(i).khr_id: '||tai_tbl(i).khr_id);
621:
622: if dist_khr_id_tbl.count = 0 then
623:
624: FND_FILE.PUT_LINE (FND_FILE.LOG, 'dist_khr_id_tbl.count: '||dist_khr_id_tbl.count);

Line 624: FND_FILE.PUT_LINE (FND_FILE.LOG, 'dist_khr_id_tbl.count: '||dist_khr_id_tbl.count);

620: FND_FILE.PUT_LINE (FND_FILE.LOG, 'tai_tbl(i).khr_id: '||tai_tbl(i).khr_id);
621:
622: if dist_khr_id_tbl.count = 0 then
623:
624: FND_FILE.PUT_LINE (FND_FILE.LOG, 'dist_khr_id_tbl.count: '||dist_khr_id_tbl.count);
625:
626: dist_khr_indx := dist_khr_id_tbl.count + 1;
627: dist_khr_id_tbl(dist_khr_indx) := tai_tbl(i).khr_id;
628:

Line 631: FND_FILE.PUT_LINE (FND_FILE.LOG, 'dist_khr_id_tbl(dist_khr_indx): '||dist_khr_id_tbl(dist_khr_indx));

627: dist_khr_id_tbl(dist_khr_indx) := tai_tbl(i).khr_id;
628:
629: else
630:
631: FND_FILE.PUT_LINE (FND_FILE.LOG, 'dist_khr_id_tbl(dist_khr_indx): '||dist_khr_id_tbl(dist_khr_indx));
632: FND_FILE.PUT_LINE (FND_FILE.LOG, 'tai_tbl(i).khr_id: '||tai_tbl(i).khr_id);
633:
634: if ( dist_khr_id_tbl(dist_khr_indx) <> tai_tbl(i).khr_id ) then
635:

Line 632: FND_FILE.PUT_LINE (FND_FILE.LOG, 'tai_tbl(i).khr_id: '||tai_tbl(i).khr_id);

628:
629: else
630:
631: FND_FILE.PUT_LINE (FND_FILE.LOG, 'dist_khr_id_tbl(dist_khr_indx): '||dist_khr_id_tbl(dist_khr_indx));
632: FND_FILE.PUT_LINE (FND_FILE.LOG, 'tai_tbl(i).khr_id: '||tai_tbl(i).khr_id);
633:
634: if ( dist_khr_id_tbl(dist_khr_indx) <> tai_tbl(i).khr_id ) then
635:
636: FND_FILE.PUT_LINE (FND_FILE.LOG, 'dist_khr_id_tbl(dist_khr_indx) <> tai_tbl(i).khr_id');

Line 636: FND_FILE.PUT_LINE (FND_FILE.LOG, 'dist_khr_id_tbl(dist_khr_indx) <> tai_tbl(i).khr_id');

632: FND_FILE.PUT_LINE (FND_FILE.LOG, 'tai_tbl(i).khr_id: '||tai_tbl(i).khr_id);
633:
634: if ( dist_khr_id_tbl(dist_khr_indx) <> tai_tbl(i).khr_id ) then
635:
636: FND_FILE.PUT_LINE (FND_FILE.LOG, 'dist_khr_id_tbl(dist_khr_indx) <> tai_tbl(i).khr_id');
637:
638: dist_khr_indx := dist_khr_id_tbl.count + 1;
639: dist_khr_id_tbl(dist_khr_indx) := tai_tbl(i).khr_id;
640:

Line 652: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Done transfering TAI records to TAI table...');

648: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
649: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Done Inserting into okl_trx_ar_invoices_b');
650:
651: END IF;
652: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Done transfering TAI records to TAI table...');
653: -- --------------------------------------
654: -- Transfer TaiTl records to the TaiTl table
655: -- --------------------------------------
656: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 660: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Transfering TAI_TL records to TAI_TL table...');

656: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
657: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inserting into okl_trx_ar_invoices_tl');
658:
659: END IF;
660: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Transfering TAI_TL records to TAI_TL table...');
661:
662: Fnd_File.PUT_LINE (Fnd_File.LOG, 'taitl_tbl.COUNT : ' || taitl_tbl.COUNT);
663:
664: IF taitl_tbl.COUNT > 0 THEN

Line 662: Fnd_File.PUT_LINE (Fnd_File.LOG, 'taitl_tbl.COUNT : ' || taitl_tbl.COUNT);

658:
659: END IF;
660: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Transfering TAI_TL records to TAI_TL table...');
661:
662: Fnd_File.PUT_LINE (Fnd_File.LOG, 'taitl_tbl.COUNT : ' || taitl_tbl.COUNT);
663:
664: IF taitl_tbl.COUNT > 0 THEN
665: FORALL indx IN taitl_tbl.first..taitl_tbl.LAST
666: INSERT INTO OKL_TRX_AR_INVOICES_TL

Line 674: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Done transfering TAI_TL records to TAI_TL table...');

670: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
671: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Done Inserting into okl_trx_ar_invoices_tl');
672:
673: END IF;
674: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Done transfering TAI_TL records to TAI_TL table...');
675: -- --------------------------------------
676: -- Transfer Til records to the Til table
677: -- --------------------------------------
678: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 682: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Transfering TIL records to TIL table...');

678: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
679: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inserting into okl_txl_ar_inv_lns_b');
680:
681: END IF;
682: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Transfering TIL records to TIL table...');
683:
684: Fnd_File.PUT_LINE (Fnd_File.LOG, 'til_tbl.COUNT : ' || til_tbl.COUNT);
685:
686: IF til_tbl.COUNT > 0 THEN

Line 684: Fnd_File.PUT_LINE (Fnd_File.LOG, 'til_tbl.COUNT : ' || til_tbl.COUNT);

680:
681: END IF;
682: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Transfering TIL records to TIL table...');
683:
684: Fnd_File.PUT_LINE (Fnd_File.LOG, 'til_tbl.COUNT : ' || til_tbl.COUNT);
685:
686: IF til_tbl.COUNT > 0 THEN
687: FORALL indx IN til_tbl.first..til_tbl.LAST
688: INSERT INTO OKL_TXL_AR_INV_LNS_B

Line 696: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Done transfering TIL records to TIL table...');

692: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
693: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Done Inserting into okl_txl_ar_inv_lns_b');
694:
695: END IF;
696: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Done transfering TIL records to TIL table...');
697: -- --------------------------------------
698: -- Transfer TilTl records to the TilTl table
699: -- --------------------------------------
700: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 704: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Transfering TIL_TL records to TIL_TL table...');

700: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
701: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inserting into okl_txl_ar_inv_lns_tl');
702:
703: END IF;
704: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Transfering TIL_TL records to TIL_TL table...');
705:
706: Fnd_File.PUT_LINE (Fnd_File.LOG, 'tiltl_tbl.COUNT : ' || tiltl_tbl.COUNT);
707:
708: IF tiltl_tbl.COUNT > 0 THEN

Line 706: Fnd_File.PUT_LINE (Fnd_File.LOG, 'tiltl_tbl.COUNT : ' || tiltl_tbl.COUNT);

702:
703: END IF;
704: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Transfering TIL_TL records to TIL_TL table...');
705:
706: Fnd_File.PUT_LINE (Fnd_File.LOG, 'tiltl_tbl.COUNT : ' || tiltl_tbl.COUNT);
707:
708: IF tiltl_tbl.COUNT > 0 THEN
709: FORALL indx IN tiltl_tbl.first..tiltl_tbl.LAST
710: INSERT INTO OKL_TXL_AR_INV_LNS_TL

Line 718: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Done transfering TIL_TL records to TIL_TL table...');

714: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
715: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Done Inserting into okl_txl_ar_inv_lns_tl');
716:
717: END IF;
718: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Done transfering TIL_TL records to TIL_TL table...');
719: -- --------------------------------------
720: -- Transfer Tld records to the Tld table
721: -- --------------------------------------
722: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 726: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Transfering TLD records to TLD table...');

722: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
723: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inserting into okl_txd_ar_ln_dtls_b');
724:
725: END IF;
726: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Transfering TLD records to TLD table...');
727:
728: Fnd_File.PUT_LINE (Fnd_File.LOG, 'tld_tbl.COUNT : ' || tld_tbl.COUNT);
729:
730: IF tld_tbl.COUNT > 0 THEN

Line 728: Fnd_File.PUT_LINE (Fnd_File.LOG, 'tld_tbl.COUNT : ' || tld_tbl.COUNT);

724:
725: END IF;
726: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Transfering TLD records to TLD table...');
727:
728: Fnd_File.PUT_LINE (Fnd_File.LOG, 'tld_tbl.COUNT : ' || tld_tbl.COUNT);
729:
730: IF tld_tbl.COUNT > 0 THEN
731: FORALL indx IN tld_tbl.first..tld_tbl.LAST
732: INSERT INTO OKL_TXD_AR_LN_DTLS_B

Line 740: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Done transfering TLD records to TLD table...');

736: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
737: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Done Inserting into okl_txd_ar_ln_dtls_b');
738:
739: END IF;
740: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Done transfering TLD records to TLD table...');
741: -- --------------------------------------
742: -- Transfer TldTl records to the TldTl table
743: -- --------------------------------------
744: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 748: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Transfering TLD_TL records to TLD_TL table...');

744: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
745: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inserting into okl_txd_ar_ln_dtls_tl');
746:
747: END IF;
748: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Transfering TLD_TL records to TLD_TL table...');
749:
750: Fnd_File.PUT_LINE (Fnd_File.LOG, 'tldtl_tbl.COUNT : ' || tldtl_tbl.COUNT);
751:
752: IF tldtl_tbl.COUNT > 0 THEN

Line 750: Fnd_File.PUT_LINE (Fnd_File.LOG, 'tldtl_tbl.COUNT : ' || tldtl_tbl.COUNT);

746:
747: END IF;
748: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Transfering TLD_TL records to TLD_TL table...');
749:
750: Fnd_File.PUT_LINE (Fnd_File.LOG, 'tldtl_tbl.COUNT : ' || tldtl_tbl.COUNT);
751:
752: IF tldtl_tbl.COUNT > 0 THEN
753: FORALL indx IN tldtl_tbl.first..tldtl_tbl.LAST
754: INSERT INTO OKL_TXD_AR_LN_DTLS_TL

Line 762: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Done transfering TLD_TL records to TLD_TL table...');

758: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
759: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Done Inserting into okl_txd_ar_ln_dtls_tl');
760:
761: END IF;
762: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Done transfering TLD_TL records to TLD_TL table...');
763: -- --------------------------------------
764: -- Transfer Xsi records to the Xsi table
765: -- --------------------------------------
766: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 774: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Creating Acct Distributions...'); -- and XTD, XTD_TL records...'); -- rmunjulu R12 Fixes commented

770: -- ---------------------------------------------
771: -- Create distributions using Accounting Enginge
772: -- ---------------------------------------------
773:
774: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Creating Acct Distributions...'); -- and XTD, XTD_TL records...'); -- rmunjulu R12 Fixes commented
775:
776: IF tld_tbl.COUNT > 0 THEN -- rmunjulu R12 Fixes changed to tld
777: ---- Added by Vpanwar --- Code for new accounting API uptake
778: l_curr_til_counter := til_tbl.FIRST;

Line 890: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Done creating Acct Distributions...'); -- and XTD, XTD_TL records...'); -- rmunjulu R12 Fixes commented

886: ---- End Added by Vpanwar --- Code for new accounting API uptake
887:
888: END IF;
889:
890: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Done creating Acct Distributions...'); -- and XTD, XTD_TL records...'); -- rmunjulu R12 Fixes commented
891:
892: -----------------------------------------------------
893: -- Move tai, xsi and sel records to different tables
894: -- for bulk updates

Line 1007: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Done updating status of records in tai and sel database tables'); -- rmunjulu R12 Fixes REMOVED XSI FROM COMMENTS

1003: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1004: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Done updating status of records in tai and sel database tables'); -- rmunjulu R12 Fixes REMOVED XSI FROM COMMENTS
1005:
1006: END IF;
1007: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Done updating status of records in tai and sel database tables'); -- rmunjulu R12 Fixes REMOVED XSI FROM COMMENTS
1008:
1009: -----------------------
1010: -- Commit
1011: -----------------------

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

1055: -- Exception handling
1056: ------------------------------------------------------------
1057:
1058: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1059: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (EXCP) => '||SQLERRM);
1060:
1061: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
1062: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',
1063: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');

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

1071: x_msg_data => x_msg_data,
1072: p_api_type => '_PVT');
1073:
1074: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1075: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
1076:
1077: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
1078: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',
1079: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');

Line 1091: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (OTHERS 1) => '||SQLERRM);

1087: x_msg_data => x_msg_data,
1088: p_api_type => '_PVT');
1089:
1090: WHEN OTHERS THEN
1091: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (OTHERS 1) => '||SQLERRM);
1092:
1093: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
1094: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',
1095: 'EXCEPTION :'||'OTHERS');

Line 1605: Fnd_File.PUT_LINE (Fnd_File.LOG, ' Done building TAI, TIL, TLD, XSI and XLS records ...');

1601: -- If all records are processd, do bulk insert and update
1602: ------------------------------------------------------------
1603: IF p_end_of_records = 'Y' THEN
1604:
1605: Fnd_File.PUT_LINE (Fnd_File.LOG, ' Done building TAI, TIL, TLD, XSI and XLS records ...');
1606:
1607: bulk_process
1608: (p_api_version
1609: ,p_init_msg_list

Line 1616: Fnd_File.PUT_LINE (Fnd_File.LOG, '=========================================================================================');

1612: ,x_msg_data
1613: ,p_commit
1614: ,p_source);
1615:
1616: Fnd_File.PUT_LINE (Fnd_File.LOG, '=========================================================================================');
1617: Fnd_File.PUT_LINE (Fnd_File.LOG, ' ** End Processing. Please See Error Log for any errored transactions ** ');
1618: Fnd_File.PUT_LINE (Fnd_File.LOG, '=========================================================================================');
1619:
1620: ELSE

Line 1617: Fnd_File.PUT_LINE (Fnd_File.LOG, ' End Processing. Please See Error Log for any errored transactions ');

1613: ,p_commit
1614: ,p_source);
1615:
1616: Fnd_File.PUT_LINE (Fnd_File.LOG, '=========================================================================================');
1617: Fnd_File.PUT_LINE (Fnd_File.LOG, ' ** End Processing. Please See Error Log for any errored transactions ** ');
1618: Fnd_File.PUT_LINE (Fnd_File.LOG, '=========================================================================================');
1619:
1620: ELSE
1621:

Line 1618: Fnd_File.PUT_LINE (Fnd_File.LOG, '=========================================================================================');

1614: ,p_source);
1615:
1616: Fnd_File.PUT_LINE (Fnd_File.LOG, '=========================================================================================');
1617: Fnd_File.PUT_LINE (Fnd_File.LOG, ' ** End Processing. Please See Error Log for any errored transactions ** ');
1618: Fnd_File.PUT_LINE (Fnd_File.LOG, '=========================================================================================');
1619:
1620: ELSE
1621:
1622: ------------------------------------

Line 1650: Fnd_File.PUT_LINE (Fnd_File.LOG,'(Exception): When resolving request_id'||SQLERRM );

1646: WHEN OTHERS THEN
1647: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1648: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'(Exception): When resolving request_id'||SQLERRM );
1649: END IF;
1650: Fnd_File.PUT_LINE (Fnd_File.LOG,'(Exception): When resolving request_id'||SQLERRM );
1651: END;
1652:
1653: ------------------------------------------------------------
1654: -- Initialise table Index for error tables

Line 1663: Fnd_File.PUT_LINE (Fnd_File.LOG, '=========================================================================================');

1659: ------------------------------------------------------------
1660: -- Process every stream to be billed
1661: ------------------------------------------------------------
1662:
1663: Fnd_File.PUT_LINE (Fnd_File.LOG, '=========================================================================================');
1664: Fnd_File.PUT_LINE (Fnd_File.LOG, ' ** Start Processing. Please See Error Log for any errored transactions ** ');
1665: Fnd_File.PUT_LINE (Fnd_File.LOG, '=========================================================================================');
1666:
1667: --check if invoicing is to be turned off if a party is bankrupt

Line 1664: Fnd_File.PUT_LINE (Fnd_File.LOG, ' Start Processing. Please See Error Log for any errored transactions ');

1660: -- Process every stream to be billed
1661: ------------------------------------------------------------
1662:
1663: Fnd_File.PUT_LINE (Fnd_File.LOG, '=========================================================================================');
1664: Fnd_File.PUT_LINE (Fnd_File.LOG, ' ** Start Processing. Please See Error Log for any errored transactions ** ');
1665: Fnd_File.PUT_LINE (Fnd_File.LOG, '=========================================================================================');
1666:
1667: --check if invoicing is to be turned off if a party is bankrupt
1668: Fnd_Profile.get('IEX_TURNOFF_INVOICE_BANKRUPTCY' , l_turnoff_inv_on_bankruptcy);

Line 1665: Fnd_File.PUT_LINE (Fnd_File.LOG, '=========================================================================================');

1661: ------------------------------------------------------------
1662:
1663: Fnd_File.PUT_LINE (Fnd_File.LOG, '=========================================================================================');
1664: Fnd_File.PUT_LINE (Fnd_File.LOG, ' ** Start Processing. Please See Error Log for any errored transactions ** ');
1665: Fnd_File.PUT_LINE (Fnd_File.LOG, '=========================================================================================');
1666:
1667: --check if invoicing is to be turned off if a party is bankrupt
1668: Fnd_Profile.get('IEX_TURNOFF_INVOICE_BANKRUPTCY' , l_turnoff_inv_on_bankruptcy);
1669: l_turnoff_inv_on_bankruptcy := NVL(l_turnoff_inv_on_bankruptcy, 'N');

Line 1676: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Building TAI, TIL, TLD, XSI and XLS records ...');

1672: END IF;
1673:
1674: -- Build table records for bulk processing
1675:
1676: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Building TAI, TIL, TLD, XSI and XLS records ...');
1677:
1678: FOR k IN p_bill_tbl.FIRST..p_bill_tbl.LAST LOOP
1679: -- ******************************************************
1680: IF (l_turnoff_inv_on_bankruptcy = 'Y') THEN

Line 1692: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Invoices of contract => ' || p_bill_tbl(k).contract_number || ' not billed due to bankruptcy.');

1688: IF (l_bankruptcy_flag = 'Y') THEN
1689: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1690: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Invoices of contract => ' || p_bill_tbl(k).contract_number || ' not billed due to bankruptcy.');
1691: END IF;
1692: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Invoices of contract => ' || p_bill_tbl(k).contract_number || ' not billed due to bankruptcy.');
1693: END IF;
1694: END IF;
1695: END IF;
1696:

Line 1711: Fnd_File.PUT_LINE (Fnd_File.LOG, ' Contract Number : '||p_bill_tbl(k).contract_number||', Bill Date : '||p_bill_tbl(k).bill_date);

1707:
1708: IF l_khr_id <> p_bill_tbl(k).khr_id
1709: OR l_bill_date <> p_bill_tbl(k).bill_date THEN
1710:
1711: Fnd_File.PUT_LINE (Fnd_File.LOG, ' Contract Number : '||p_bill_tbl(k).contract_number||', Bill Date : '||p_bill_tbl(k).bill_date);
1712:
1713: l_tai_cnt := l_tai_cnt + 1;
1714:
1715: -- Check if commit point reached

Line 1718: Fnd_File.PUT_LINE (Fnd_File.LOG, ' Done building TAI, TIL, TLD, XSI and XLS records ...');

1714:
1715: -- Check if commit point reached
1716: IF l_commit_cnt > l_max_commit_cnt THEN
1717:
1718: Fnd_File.PUT_LINE (Fnd_File.LOG, ' Done building TAI, TIL, TLD, XSI and XLS records ...');
1719:
1720: -- Bulk insert/update records, Commit and restart
1721: bulk_process
1722: (p_api_version

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

2301: -- Exception handling
2302: ------------------------------------------------------------
2303:
2304: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2305: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (EXCP) => '||SQLERRM);
2306:
2307: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
2308: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',
2309: 'EXCEPTION (Process_bill_tbl):'||'OKL_API.G_EXCEPTION_ERROR');

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

2317: x_msg_data => x_msg_data,
2318: p_api_type => '_PVT');
2319:
2320: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2321: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
2322:
2323: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
2324: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',
2325: 'EXCEPTION (Process_bill_tbl):'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');

Line 2337: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (OTHERS 3) => '||SQLERRM);

2333: x_msg_data => x_msg_data,
2334: p_api_type => '_PVT');
2335:
2336: WHEN OTHERS THEN
2337: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (OTHERS 3) => '||SQLERRM);
2338:
2339: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
2340: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',
2341: 'EXCEPTION (Process_bill_tbl):'||'OTHERS');

Line 3133: Fnd_File.PUT_LINE (Fnd_File.LOG, 'C7 Bill_Tbl count is: '||bill_tbl.COUNT);

3129: -- Clear table contents
3130: -- ----------------------------
3131: bill_tbl.DELETE;
3132: FETCH C7 BULK COLLECT INTO bill_tbl LIMIT L_FETCH_SIZE;
3133: Fnd_File.PUT_LINE (Fnd_File.LOG, 'C7 Bill_Tbl count is: '||bill_tbl.COUNT);
3134: IF bill_tbl.COUNT > 0 THEN
3135: Process_bill_tbl
3136: (p_api_version
3137: ,p_init_msg_list

Line 3160: Fnd_File.PUT_LINE (Fnd_File.LOG, 'C8 Bill_Tbl count is: '||bill_tbl.COUNT);

3156: -- Clear table contents
3157: -- ----------------------------
3158: bill_tbl.DELETE;
3159: FETCH C8 BULK COLLECT INTO bill_tbl LIMIT L_FETCH_SIZE;
3160: Fnd_File.PUT_LINE (Fnd_File.LOG, 'C8 Bill_Tbl count is: '||bill_tbl.COUNT);
3161: IF bill_tbl.COUNT > 0 THEN
3162: Process_bill_tbl
3163: (p_api_version
3164: ,p_init_msg_list

Line 3187: Fnd_File.PUT_LINE (Fnd_File.LOG, 'C9 Bill_Tbl count is: '||bill_tbl.COUNT);

3183: -- Clear table contents
3184: -- ----------------------------
3185: bill_tbl.DELETE;
3186: FETCH C9 BULK COLLECT INTO bill_tbl LIMIT L_FETCH_SIZE;
3187: Fnd_File.PUT_LINE (Fnd_File.LOG, 'C9 Bill_Tbl count is: '||bill_tbl.COUNT);
3188: IF bill_tbl.COUNT > 0 THEN
3189: Process_bill_tbl
3190: (p_api_version
3191: ,p_init_msg_list

Line 3220: Fnd_File.PUT_LINE (Fnd_File.LOG, 'C1 Bill_Tbl count is: '||bill_tbl.COUNT);

3216: -- Clear table contents
3217: -- ----------------------------
3218: bill_tbl.DELETE;
3219: FETCH C1 BULK COLLECT INTO bill_tbl LIMIT L_FETCH_SIZE;
3220: Fnd_File.PUT_LINE (Fnd_File.LOG, 'C1 Bill_Tbl count is: '||bill_tbl.COUNT);
3221: IF bill_tbl.COUNT > 0 THEN
3222: Process_bill_tbl
3223: (p_api_version
3224: ,p_init_msg_list

Line 3247: Fnd_File.PUT_LINE (Fnd_File.LOG, 'C2 Bill_Tbl count is: '||bill_tbl.COUNT);

3243: -- Clear table contents
3244: -- ----------------------------
3245: bill_tbl.DELETE;
3246: FETCH C2 BULK COLLECT INTO bill_tbl LIMIT L_FETCH_SIZE;
3247: Fnd_File.PUT_LINE (Fnd_File.LOG, 'C2 Bill_Tbl count is: '||bill_tbl.COUNT);
3248: IF bill_tbl.COUNT > 0 THEN
3249: Process_bill_tbl
3250: (p_api_version
3251: ,p_init_msg_list

Line 3274: Fnd_File.PUT_LINE (Fnd_File.LOG, 'C3 Bill_Tbl count is: '||bill_tbl.COUNT);

3270: -- Clear table contents
3271: -- ----------------------------
3272: bill_tbl.DELETE;
3273: FETCH C3 BULK COLLECT INTO bill_tbl LIMIT L_FETCH_SIZE;
3274: Fnd_File.PUT_LINE (Fnd_File.LOG, 'C3 Bill_Tbl count is: '||bill_tbl.COUNT);
3275: IF bill_tbl.COUNT > 0 THEN
3276: Process_bill_tbl
3277: (p_api_version
3278: ,p_init_msg_list

Line 3305: Fnd_File.PUT_LINE (Fnd_File.LOG, 'C4 Bill_Tbl count is: '||bill_tbl.COUNT);

3301: -- Clear table contents
3302: -- ----------------------------
3303: bill_tbl.DELETE;
3304: FETCH C4 BULK COLLECT INTO bill_tbl LIMIT L_FETCH_SIZE;
3305: Fnd_File.PUT_LINE (Fnd_File.LOG, 'C4 Bill_Tbl count is: '||bill_tbl.COUNT);
3306: IF bill_tbl.COUNT > 0 THEN
3307: Process_bill_tbl
3308: (p_api_version
3309: ,p_init_msg_list

Line 3332: Fnd_File.PUT_LINE (Fnd_File.LOG, 'C5 Bill_Tbl count is: '||bill_tbl.COUNT);

3328: -- Clear table contents
3329: -- ----------------------------
3330: bill_tbl.DELETE;
3331: FETCH C5 BULK COLLECT INTO bill_tbl LIMIT L_FETCH_SIZE;
3332: Fnd_File.PUT_LINE (Fnd_File.LOG, 'C5 Bill_Tbl count is: '||bill_tbl.COUNT);
3333: IF bill_tbl.COUNT > 0 THEN
3334: Process_bill_tbl
3335: (p_api_version
3336: ,p_init_msg_list

Line 3359: Fnd_File.PUT_LINE (Fnd_File.LOG, 'C6 Bill_Tbl count is: '||bill_tbl.COUNT);

3355: -- Clear table contents
3356: -- ----------------------------
3357: bill_tbl.DELETE;
3358: FETCH C6 BULK COLLECT INTO bill_tbl LIMIT L_FETCH_SIZE;
3359: Fnd_File.PUT_LINE (Fnd_File.LOG, 'C6 Bill_Tbl count is: '||bill_tbl.COUNT);
3360: IF bill_tbl.COUNT > 0 THEN
3361: Process_bill_tbl
3362: (p_api_version
3363: ,p_init_msg_list

Line 3475: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'Oracle Leasing and Finance Management'||LPAD(' ', 55, ' '));

3471: FETCH op_unit_csr INTO l_op_unit_name;
3472: CLOSE op_unit_csr;
3473:
3474: -- Start New Out File stmathew 15-OCT-2004
3475: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'Oracle Leasing and Finance Management'||LPAD(' ', 55, ' '));
3476: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3477: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'Process Billable Streams'||LPAD(' ', 54, ' '));
3478: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'------------------------'||LPAD(' ', 54, ' '));
3479: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));

Line 3476: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));

3472: CLOSE op_unit_csr;
3473:
3474: -- Start New Out File stmathew 15-OCT-2004
3475: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'Oracle Leasing and Finance Management'||LPAD(' ', 55, ' '));
3476: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3477: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'Process Billable Streams'||LPAD(' ', 54, ' '));
3478: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'------------------------'||LPAD(' ', 54, ' '));
3479: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3480: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));

Line 3477: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'Process Billable Streams'||LPAD(' ', 54, ' '));

3473:
3474: -- Start New Out File stmathew 15-OCT-2004
3475: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'Oracle Leasing and Finance Management'||LPAD(' ', 55, ' '));
3476: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3477: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'Process Billable Streams'||LPAD(' ', 54, ' '));
3478: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'------------------------'||LPAD(' ', 54, ' '));
3479: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3480: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3481: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Operating Unit: '||l_op_unit_name);

Line 3478: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'------------------------'||LPAD(' ', 54, ' '));

3474: -- Start New Out File stmathew 15-OCT-2004
3475: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'Oracle Leasing and Finance Management'||LPAD(' ', 55, ' '));
3476: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3477: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'Process Billable Streams'||LPAD(' ', 54, ' '));
3478: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'------------------------'||LPAD(' ', 54, ' '));
3479: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3480: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3481: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Operating Unit: '||l_op_unit_name);
3482: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Request Id: '||l_request_id||LPAD(' ',74,' ') ||'Run Date: '||TO_CHAR(SYSDATE));

Line 3479: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));

3475: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'Oracle Leasing and Finance Management'||LPAD(' ', 55, ' '));
3476: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3477: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'Process Billable Streams'||LPAD(' ', 54, ' '));
3478: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'------------------------'||LPAD(' ', 54, ' '));
3479: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3480: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3481: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Operating Unit: '||l_op_unit_name);
3482: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Request Id: '||l_request_id||LPAD(' ',74,' ') ||'Run Date: '||TO_CHAR(SYSDATE));
3483: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Currency: '||Okl_Accounting_Util.get_func_curr_code);

Line 3480: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));

3476: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3477: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'Process Billable Streams'||LPAD(' ', 54, ' '));
3478: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'------------------------'||LPAD(' ', 54, ' '));
3479: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3480: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3481: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Operating Unit: '||l_op_unit_name);
3482: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Request Id: '||l_request_id||LPAD(' ',74,' ') ||'Run Date: '||TO_CHAR(SYSDATE));
3483: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Currency: '||Okl_Accounting_Util.get_func_curr_code);
3484: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));

Line 3481: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Operating Unit: '||l_op_unit_name);

3477: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'Process Billable Streams'||LPAD(' ', 54, ' '));
3478: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'------------------------'||LPAD(' ', 54, ' '));
3479: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3480: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3481: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Operating Unit: '||l_op_unit_name);
3482: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Request Id: '||l_request_id||LPAD(' ',74,' ') ||'Run Date: '||TO_CHAR(SYSDATE));
3483: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Currency: '||Okl_Accounting_Util.get_func_curr_code);
3484: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));
3485: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'From Bill Date : ' ||p_from_bill_date);

Line 3482: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Request Id: '||l_request_id||LPAD(' ',74,' ') ||'Run Date: '||TO_CHAR(SYSDATE));

3478: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'------------------------'||LPAD(' ', 54, ' '));
3479: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3480: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3481: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Operating Unit: '||l_op_unit_name);
3482: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Request Id: '||l_request_id||LPAD(' ',74,' ') ||'Run Date: '||TO_CHAR(SYSDATE));
3483: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Currency: '||Okl_Accounting_Util.get_func_curr_code);
3484: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));
3485: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'From Bill Date : ' ||p_from_bill_date);
3486: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'To Bill Date : ' ||p_to_bill_date);

Line 3483: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Currency: '||Okl_Accounting_Util.get_func_curr_code);

3479: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3480: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3481: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Operating Unit: '||l_op_unit_name);
3482: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Request Id: '||l_request_id||LPAD(' ',74,' ') ||'Run Date: '||TO_CHAR(SYSDATE));
3483: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Currency: '||Okl_Accounting_Util.get_func_curr_code);
3484: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));
3485: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'From Bill Date : ' ||p_from_bill_date);
3486: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'To Bill Date : ' ||p_to_bill_date);
3487: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Contract Number : ' ||p_contract_number);

Line 3484: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));

3480: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3481: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Operating Unit: '||l_op_unit_name);
3482: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Request Id: '||l_request_id||LPAD(' ',74,' ') ||'Run Date: '||TO_CHAR(SYSDATE));
3483: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Currency: '||Okl_Accounting_Util.get_func_curr_code);
3484: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));
3485: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'From Bill Date : ' ||p_from_bill_date);
3486: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'To Bill Date : ' ||p_to_bill_date);
3487: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Contract Number : ' ||p_contract_number);
3488: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));

Line 3485: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'From Bill Date : ' ||p_from_bill_date);

3481: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Operating Unit: '||l_op_unit_name);
3482: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Request Id: '||l_request_id||LPAD(' ',74,' ') ||'Run Date: '||TO_CHAR(SYSDATE));
3483: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Currency: '||Okl_Accounting_Util.get_func_curr_code);
3484: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));
3485: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'From Bill Date : ' ||p_from_bill_date);
3486: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'To Bill Date : ' ||p_to_bill_date);
3487: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Contract Number : ' ||p_contract_number);
3488: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));
3489: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));

Line 3486: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'To Bill Date : ' ||p_to_bill_date);

3482: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Request Id: '||l_request_id||LPAD(' ',74,' ') ||'Run Date: '||TO_CHAR(SYSDATE));
3483: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Currency: '||Okl_Accounting_Util.get_func_curr_code);
3484: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));
3485: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'From Bill Date : ' ||p_from_bill_date);
3486: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'To Bill Date : ' ||p_to_bill_date);
3487: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Contract Number : ' ||p_contract_number);
3488: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));
3489: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3490: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));

Line 3487: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Contract Number : ' ||p_contract_number);

3483: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Currency: '||Okl_Accounting_Util.get_func_curr_code);
3484: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));
3485: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'From Bill Date : ' ||p_from_bill_date);
3486: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'To Bill Date : ' ||p_to_bill_date);
3487: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Contract Number : ' ||p_contract_number);
3488: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));
3489: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3490: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3491:

Line 3488: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));

3484: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));
3485: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'From Bill Date : ' ||p_from_bill_date);
3486: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'To Bill Date : ' ||p_to_bill_date);
3487: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Contract Number : ' ||p_contract_number);
3488: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));
3489: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3490: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3491:
3492: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Processing Details:'||LPAD(' ', 113, ' '));

Line 3489: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));

3485: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'From Bill Date : ' ||p_from_bill_date);
3486: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'To Bill Date : ' ||p_to_bill_date);
3487: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Contract Number : ' ||p_contract_number);
3488: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));
3489: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3490: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3491:
3492: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Processing Details:'||LPAD(' ', 113, ' '));
3493: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));

Line 3490: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));

3486: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'To Bill Date : ' ||p_to_bill_date);
3487: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Contract Number : ' ||p_contract_number);
3488: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));
3489: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3490: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3491:
3492: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Processing Details:'||LPAD(' ', 113, ' '));
3493: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3494: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Successful Stream Elements: '||l_succ_cnt);

Line 3492: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Processing Details:'||LPAD(' ', 113, ' '));

3488: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));
3489: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3490: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3491:
3492: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Processing Details:'||LPAD(' ', 113, ' '));
3493: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3494: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Successful Stream Elements: '||l_succ_cnt);
3495: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Errored Stream Elements: '||l_err_cnt);
3496: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Total: '||(l_succ_cnt+l_err_cnt));

Line 3493: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));

3489: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3490: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3491:
3492: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Processing Details:'||LPAD(' ', 113, ' '));
3493: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3494: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Successful Stream Elements: '||l_succ_cnt);
3495: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Errored Stream Elements: '||l_err_cnt);
3496: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Total: '||(l_succ_cnt+l_err_cnt));
3497: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));

Line 3494: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Successful Stream Elements: '||l_succ_cnt);

3490: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3491:
3492: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Processing Details:'||LPAD(' ', 113, ' '));
3493: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3494: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Successful Stream Elements: '||l_succ_cnt);
3495: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Errored Stream Elements: '||l_err_cnt);
3496: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Total: '||(l_succ_cnt+l_err_cnt));
3497: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3498:

Line 3495: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Errored Stream Elements: '||l_err_cnt);

3491:
3492: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Processing Details:'||LPAD(' ', 113, ' '));
3493: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3494: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Successful Stream Elements: '||l_succ_cnt);
3495: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Errored Stream Elements: '||l_err_cnt);
3496: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Total: '||(l_succ_cnt+l_err_cnt));
3497: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3498:
3499: -- End New Out File stmathew 15-OCT-2004

Line 3496: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Total: '||(l_succ_cnt+l_err_cnt));

3492: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Processing Details:'||LPAD(' ', 113, ' '));
3493: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3494: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Successful Stream Elements: '||l_succ_cnt);
3495: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Errored Stream Elements: '||l_err_cnt);
3496: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Total: '||(l_succ_cnt+l_err_cnt));
3497: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3498:
3499: -- End New Out File stmathew 15-OCT-2004
3500: IF x_msg_count > 0 THEN

Line 3497: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));

3493: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3494: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Successful Stream Elements: '||l_succ_cnt);
3495: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Errored Stream Elements: '||l_err_cnt);
3496: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Total: '||(l_succ_cnt+l_err_cnt));
3497: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3498:
3499: -- End New Out File stmathew 15-OCT-2004
3500: IF x_msg_count > 0 THEN
3501: FOR i IN 1..x_msg_count LOOP

Line 3503: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Details of Errored Stream Elements:'||LPAD(' ', 97, ' '));

3499: -- End New Out File stmathew 15-OCT-2004
3500: IF x_msg_count > 0 THEN
3501: FOR i IN 1..x_msg_count LOOP
3502: IF i = 1 THEN
3503: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Details of Errored Stream Elements:'||LPAD(' ', 97, ' '));
3504: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3505: END IF;
3506: Fnd_Msg_Pub.get (p_msg_index => i,
3507: p_encoded => 'F',

Line 3504: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));

3500: IF x_msg_count > 0 THEN
3501: FOR i IN 1..x_msg_count LOOP
3502: IF i = 1 THEN
3503: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Details of Errored Stream Elements:'||LPAD(' ', 97, ' '));
3504: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3505: END IF;
3506: Fnd_Msg_Pub.get (p_msg_index => i,
3507: p_encoded => 'F',
3508: p_data => lx_msg_data,

Line 3511: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,TO_CHAR(i) || ': ' || lx_msg_data);

3507: p_encoded => 'F',
3508: p_data => lx_msg_data,
3509: p_msg_index_out => l_msg_index_out);
3510:
3511: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,TO_CHAR(i) || ': ' || lx_msg_data);
3512:
3513: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
3514: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',
3515: TO_CHAR(i) || ': ' || lx_msg_data);

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

3527: ------------------------------------------------------------
3528: -- Exception handling
3529: ------------------------------------------------------------
3530: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
3531: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (EXCP) => '||SQLERRM);
3532:
3533: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
3534: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',
3535: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');

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

3543: x_msg_data => x_msg_data,
3544: p_api_type => '_PVT');
3545:
3546: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
3547: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
3548:
3549: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
3550: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',
3551: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');

Line 3563: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (OTHERS 2) => '||SQLERRM);

3559: x_msg_data => x_msg_data,
3560: p_api_type => '_PVT');
3561:
3562: WHEN OTHERS THEN
3563: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (OTHERS 2) => '||SQLERRM);
3564:
3565: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
3566: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',
3567: 'EXCEPTION :'||'OTHERS');

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

3695: -- Exception handling
3696: ------------------------------------------------------------
3697:
3698: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
3699: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (EXCP) => '||SQLERRM);
3700:
3701: IF p_assigned_process IS NOT NULL THEN
3702: DELETE OKL_PARALLEL_PROCESSES
3703: WHERE assigned_process = p_assigned_process;

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

3717: x_msg_data => x_msg_data,
3718: p_api_type => '_PVT');
3719:
3720: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
3721: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
3722:
3723: IF p_assigned_process IS NOT NULL THEN
3724: DELETE OKL_PARALLEL_PROCESSES
3725: WHERE assigned_process = p_assigned_process;

Line 3743: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (OTHERS 1) => '||SQLERRM);

3739: x_msg_data => x_msg_data,
3740: p_api_type => '_PVT');
3741:
3742: WHEN OTHERS THEN
3743: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (OTHERS 1) => '||SQLERRM);
3744:
3745: IF p_assigned_process IS NOT NULL THEN
3746: DELETE OKL_PARALLEL_PROCESSES
3747: WHERE assigned_process = p_assigned_process;