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 466: FND_FILE.PUT_LINE (Fnd_File.LOG,'(Exception): When retrieving Customer ACCT Details.'||SQLERRM );

462: THEN
463: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'(Exception): When retrieving Customer ACCT Details.'||SQLERRM );
464: END IF;
465:
466: FND_FILE.PUT_LINE (Fnd_File.LOG,'(Exception): When retrieving Customer ACCT Details.'||SQLERRM );
467: p_cust_party_id := NULL;
468: p_cust_acct_id := NULL;
469:
470: END get_customer_dtls;

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

644: WHEN OTHERS THEN
645: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
646: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'(Exception): When resolving request_id'||SQLERRM );
647: END IF;
648: Fnd_File.PUT_LINE (Fnd_File.LOG,'(Exception): When resolving request_id'||SQLERRM );
649: END;
650:
651: --------------------------------------------------
652: -- Bulk insert TAI, TIL, TLD, XSI and XLS records

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

658: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
659: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inserting into okl_trx_ar_invoices_b');
660:
661: END IF;
662: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Transfering TAI records to TAI table...');
663:
664: Fnd_File.PUT_LINE (Fnd_File.LOG, 'tai_tbl.COUNT : ' || tai_tbl.COUNT);
665:
666: IF tai_tbl.COUNT > 0 THEN

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

660:
661: END IF;
662: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Transfering TAI records to TAI table...');
663:
664: Fnd_File.PUT_LINE (Fnd_File.LOG, 'tai_tbl.COUNT : ' || tai_tbl.COUNT);
665:
666: IF tai_tbl.COUNT > 0 THEN
667: FORALL indx IN tai_tbl.first..tai_tbl.LAST
668: INSERT INTO OKL_TRX_AR_INVOICES_B

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

675: dist_khr_id_tbl.delete;
676:
677: for i in tai_tbl.first..tai_tbl.last loop
678:
679: FND_FILE.PUT_LINE (FND_FILE.LOG, 'tai_tbl(i).khr_id: '||tai_tbl(i).khr_id);
680:
681: if dist_khr_id_tbl.count = 0 then
682:
683: FND_FILE.PUT_LINE (FND_FILE.LOG, 'dist_khr_id_tbl.count: '||dist_khr_id_tbl.count);

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

679: FND_FILE.PUT_LINE (FND_FILE.LOG, 'tai_tbl(i).khr_id: '||tai_tbl(i).khr_id);
680:
681: if dist_khr_id_tbl.count = 0 then
682:
683: FND_FILE.PUT_LINE (FND_FILE.LOG, 'dist_khr_id_tbl.count: '||dist_khr_id_tbl.count);
684:
685: dist_khr_indx := dist_khr_id_tbl.count + 1;
686: dist_khr_id_tbl(dist_khr_indx) := tai_tbl(i).khr_id;
687:

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

686: dist_khr_id_tbl(dist_khr_indx) := tai_tbl(i).khr_id;
687:
688: else
689:
690: FND_FILE.PUT_LINE (FND_FILE.LOG, 'dist_khr_id_tbl(dist_khr_indx): '||dist_khr_id_tbl(dist_khr_indx));
691: FND_FILE.PUT_LINE (FND_FILE.LOG, 'tai_tbl(i).khr_id: '||tai_tbl(i).khr_id);
692:
693: if ( dist_khr_id_tbl(dist_khr_indx) <> tai_tbl(i).khr_id ) then
694:

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

687:
688: else
689:
690: FND_FILE.PUT_LINE (FND_FILE.LOG, 'dist_khr_id_tbl(dist_khr_indx): '||dist_khr_id_tbl(dist_khr_indx));
691: FND_FILE.PUT_LINE (FND_FILE.LOG, 'tai_tbl(i).khr_id: '||tai_tbl(i).khr_id);
692:
693: if ( dist_khr_id_tbl(dist_khr_indx) <> tai_tbl(i).khr_id ) then
694:
695: FND_FILE.PUT_LINE (FND_FILE.LOG, 'dist_khr_id_tbl(dist_khr_indx) <> tai_tbl(i).khr_id');

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

691: FND_FILE.PUT_LINE (FND_FILE.LOG, 'tai_tbl(i).khr_id: '||tai_tbl(i).khr_id);
692:
693: if ( dist_khr_id_tbl(dist_khr_indx) <> tai_tbl(i).khr_id ) then
694:
695: FND_FILE.PUT_LINE (FND_FILE.LOG, 'dist_khr_id_tbl(dist_khr_indx) <> tai_tbl(i).khr_id');
696:
697: dist_khr_indx := dist_khr_id_tbl.count + 1;
698: dist_khr_id_tbl(dist_khr_indx) := tai_tbl(i).khr_id;
699:

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

707: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
708: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Done Inserting into okl_trx_ar_invoices_b');
709:
710: END IF;
711: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Done transfering TAI records to TAI table...');
712: -- --------------------------------------
713: -- Transfer TaiTl records to the TaiTl table
714: -- --------------------------------------
715: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

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

715: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
716: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inserting into okl_trx_ar_invoices_tl');
717:
718: END IF;
719: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Transfering TAI_TL records to TAI_TL table...');
720:
721: Fnd_File.PUT_LINE (Fnd_File.LOG, 'taitl_tbl.COUNT : ' || taitl_tbl.COUNT);
722:
723: IF taitl_tbl.COUNT > 0 THEN

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

717:
718: END IF;
719: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Transfering TAI_TL records to TAI_TL table...');
720:
721: Fnd_File.PUT_LINE (Fnd_File.LOG, 'taitl_tbl.COUNT : ' || taitl_tbl.COUNT);
722:
723: IF taitl_tbl.COUNT > 0 THEN
724: FORALL indx IN taitl_tbl.first..taitl_tbl.LAST
725: INSERT INTO OKL_TRX_AR_INVOICES_TL

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

729: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
730: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Done Inserting into okl_trx_ar_invoices_tl');
731:
732: END IF;
733: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Done transfering TAI_TL records to TAI_TL table...');
734: -- --------------------------------------
735: -- Transfer Til records to the Til table
736: -- --------------------------------------
737: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

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

737: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
738: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inserting into okl_txl_ar_inv_lns_b');
739:
740: END IF;
741: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Transfering TIL records to TIL table...');
742:
743: Fnd_File.PUT_LINE (Fnd_File.LOG, 'til_tbl.COUNT : ' || til_tbl.COUNT);
744:
745: IF til_tbl.COUNT > 0 THEN

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

739:
740: END IF;
741: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Transfering TIL records to TIL table...');
742:
743: Fnd_File.PUT_LINE (Fnd_File.LOG, 'til_tbl.COUNT : ' || til_tbl.COUNT);
744:
745: IF til_tbl.COUNT > 0 THEN
746: FORALL indx IN til_tbl.first..til_tbl.LAST
747: INSERT INTO OKL_TXL_AR_INV_LNS_B

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

751: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
752: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Done Inserting into okl_txl_ar_inv_lns_b');
753:
754: END IF;
755: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Done transfering TIL records to TIL table...');
756: -- --------------------------------------
757: -- Transfer TilTl records to the TilTl table
758: -- --------------------------------------
759: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

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

759: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
760: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inserting into okl_txl_ar_inv_lns_tl');
761:
762: END IF;
763: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Transfering TIL_TL records to TIL_TL table...');
764:
765: Fnd_File.PUT_LINE (Fnd_File.LOG, 'tiltl_tbl.COUNT : ' || tiltl_tbl.COUNT);
766:
767: IF tiltl_tbl.COUNT > 0 THEN

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

761:
762: END IF;
763: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Transfering TIL_TL records to TIL_TL table...');
764:
765: Fnd_File.PUT_LINE (Fnd_File.LOG, 'tiltl_tbl.COUNT : ' || tiltl_tbl.COUNT);
766:
767: IF tiltl_tbl.COUNT > 0 THEN
768: FORALL indx IN tiltl_tbl.first..tiltl_tbl.LAST
769: INSERT INTO OKL_TXL_AR_INV_LNS_TL

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

773: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
774: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Done Inserting into okl_txl_ar_inv_lns_tl');
775:
776: END IF;
777: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Done transfering TIL_TL records to TIL_TL table...');
778: -- --------------------------------------
779: -- Transfer Tld records to the Tld table
780: -- --------------------------------------
781: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

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

781: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
782: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inserting into okl_txd_ar_ln_dtls_b');
783:
784: END IF;
785: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Transfering TLD records to TLD table...');
786:
787: Fnd_File.PUT_LINE (Fnd_File.LOG, 'tld_tbl.COUNT : ' || tld_tbl.COUNT);
788:
789: IF tld_tbl.COUNT > 0 THEN

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

783:
784: END IF;
785: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Transfering TLD records to TLD table...');
786:
787: Fnd_File.PUT_LINE (Fnd_File.LOG, 'tld_tbl.COUNT : ' || tld_tbl.COUNT);
788:
789: IF tld_tbl.COUNT > 0 THEN
790: FORALL indx IN tld_tbl.first..tld_tbl.LAST
791: INSERT INTO OKL_TXD_AR_LN_DTLS_B

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

795: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
796: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Done Inserting into okl_txd_ar_ln_dtls_b');
797:
798: END IF;
799: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Done transfering TLD records to TLD table...');
800: -- --------------------------------------
801: -- Transfer TldTl records to the TldTl table
802: -- --------------------------------------
803: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

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

803: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
804: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inserting into okl_txd_ar_ln_dtls_tl');
805:
806: END IF;
807: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Transfering TLD_TL records to TLD_TL table...');
808:
809: Fnd_File.PUT_LINE (Fnd_File.LOG, 'tldtl_tbl.COUNT : ' || tldtl_tbl.COUNT);
810:
811: IF tldtl_tbl.COUNT > 0 THEN

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

805:
806: END IF;
807: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Transfering TLD_TL records to TLD_TL table...');
808:
809: Fnd_File.PUT_LINE (Fnd_File.LOG, 'tldtl_tbl.COUNT : ' || tldtl_tbl.COUNT);
810:
811: IF tldtl_tbl.COUNT > 0 THEN
812: FORALL indx IN tldtl_tbl.first..tldtl_tbl.LAST
813: INSERT INTO OKL_TXD_AR_LN_DTLS_TL

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

817: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
818: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Done Inserting into okl_txd_ar_ln_dtls_tl');
819:
820: END IF;
821: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Done transfering TLD_TL records to TLD_TL table...');
822: -- --------------------------------------
823: -- Transfer Xsi records to the Xsi table
824: -- --------------------------------------
825: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

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

829: -- ---------------------------------------------
830: -- Create distributions using Accounting Enginge
831: -- ---------------------------------------------
832:
833: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Creating Acct Distributions...'); -- and XTD, XTD_TL records...'); -- rmunjulu R12 Fixes commented
834:
835: IF tld_tbl.COUNT > 0 THEN -- rmunjulu R12 Fixes changed to tld
836: ---- Added by Vpanwar --- Code for new accounting API uptake
837: l_curr_til_counter := til_tbl.FIRST;

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

945: ---- End Added by Vpanwar --- Code for new accounting API uptake
946:
947: END IF;
948:
949: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Done creating Acct Distributions...'); -- and XTD, XTD_TL records...'); -- rmunjulu R12 Fixes commented
950:
951: -----------------------------------------------------
952: -- Move tai, xsi and sel records to different tables
953: -- for bulk updates

Line 1069: 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

1065: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1066: 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
1067:
1068: END IF;
1069: 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
1070:
1071: -----------------------
1072: -- Commit
1073: -----------------------

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

1117: -- Exception handling
1118: ------------------------------------------------------------
1119:
1120: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1121: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (EXCP) => '||SQLERRM);
1122:
1123: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
1124: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',
1125: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');

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

1133: x_msg_data => x_msg_data,
1134: p_api_type => '_PVT');
1135:
1136: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1137: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
1138:
1139: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
1140: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',
1141: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');

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

1149: x_msg_data => x_msg_data,
1150: p_api_type => '_PVT');
1151:
1152: WHEN OTHERS THEN
1153: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (OTHERS 1) => '||SQLERRM);
1154:
1155: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
1156: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',
1157: 'EXCEPTION :'||'OTHERS');

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

1672: -- If all records are processd, do bulk insert and update
1673: ------------------------------------------------------------
1674: IF p_end_of_records = 'Y' THEN
1675:
1676: Fnd_File.PUT_LINE (Fnd_File.LOG, ' Done building TAI, TIL, TLD, XSI and XLS records ...');
1677:
1678: bulk_process
1679: (p_api_version
1680: ,p_init_msg_list

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

1683: ,x_msg_data
1684: ,p_commit
1685: ,p_source);
1686:
1687: Fnd_File.PUT_LINE (Fnd_File.LOG, '=========================================================================================');
1688: Fnd_File.PUT_LINE (Fnd_File.LOG, ' ** End Processing. Please See Error Log for any errored transactions ** ');
1689: Fnd_File.PUT_LINE (Fnd_File.LOG, '=========================================================================================');
1690:
1691: ELSE

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

1684: ,p_commit
1685: ,p_source);
1686:
1687: Fnd_File.PUT_LINE (Fnd_File.LOG, '=========================================================================================');
1688: Fnd_File.PUT_LINE (Fnd_File.LOG, ' ** End Processing. Please See Error Log for any errored transactions ** ');
1689: Fnd_File.PUT_LINE (Fnd_File.LOG, '=========================================================================================');
1690:
1691: ELSE
1692:

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

1685: ,p_source);
1686:
1687: Fnd_File.PUT_LINE (Fnd_File.LOG, '=========================================================================================');
1688: Fnd_File.PUT_LINE (Fnd_File.LOG, ' ** End Processing. Please See Error Log for any errored transactions ** ');
1689: Fnd_File.PUT_LINE (Fnd_File.LOG, '=========================================================================================');
1690:
1691: ELSE
1692:
1693: ------------------------------------

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

1717: WHEN OTHERS THEN
1718: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1719: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'(Exception): When resolving request_id'||SQLERRM );
1720: END IF;
1721: Fnd_File.PUT_LINE (Fnd_File.LOG,'(Exception): When resolving request_id'||SQLERRM );
1722: END;
1723:
1724: ------------------------------------------------------------
1725: -- Initialise table Index for error tables

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

1730: ------------------------------------------------------------
1731: -- Process every stream to be billed
1732: ------------------------------------------------------------
1733:
1734: Fnd_File.PUT_LINE (Fnd_File.LOG, '=========================================================================================');
1735: Fnd_File.PUT_LINE (Fnd_File.LOG, ' ** Start Processing. Please See Error Log for any errored transactions ** ');
1736: Fnd_File.PUT_LINE (Fnd_File.LOG, '=========================================================================================');
1737:
1738: -- Start of code commmented by Venkatho as part of Bug# 14119181

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

1731: -- Process every stream to be billed
1732: ------------------------------------------------------------
1733:
1734: Fnd_File.PUT_LINE (Fnd_File.LOG, '=========================================================================================');
1735: Fnd_File.PUT_LINE (Fnd_File.LOG, ' ** Start Processing. Please See Error Log for any errored transactions ** ');
1736: Fnd_File.PUT_LINE (Fnd_File.LOG, '=========================================================================================');
1737:
1738: -- Start of code commmented by Venkatho as part of Bug# 14119181
1739:

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

1732: ------------------------------------------------------------
1733:
1734: Fnd_File.PUT_LINE (Fnd_File.LOG, '=========================================================================================');
1735: Fnd_File.PUT_LINE (Fnd_File.LOG, ' ** Start Processing. Please See Error Log for any errored transactions ** ');
1736: Fnd_File.PUT_LINE (Fnd_File.LOG, '=========================================================================================');
1737:
1738: -- Start of code commmented by Venkatho as part of Bug# 14119181
1739:
1740: /* --check if invoicing is to be turned off if a party is bankrupt

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

1748:
1749:
1750: -- Build table records for bulk processing
1751:
1752: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Building TAI, TIL, TLD, XSI and XLS records ...');
1753:
1754: FOR k IN p_bill_tbl.FIRST..p_bill_tbl.LAST LOOP
1755: -- ******************************************************
1756: -- Below IF logic is commented by Venkatho as part of Bug# 14119181

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

1766: IF (l_bankruptcy_flag = 'Y') THEN
1767: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1768: 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.');
1769: END IF;
1770: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Invoices of contract => ' || p_bill_tbl(k).contract_number || ' not billed due to bankruptcy.');
1771: END IF;
1772: END IF;
1773: END IF; */
1774:

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

1835:
1836: IF (G_IS_DEBUG_STATEMENT_ON = TRUE) THEN
1837: 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.');
1838: END IF;
1839: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Invoices of contract => ' || p_bill_tbl(k).contract_number || ' not billed due to bankruptcy.');
1840:
1841: END IF;
1842:
1843: -- Added as part of Bug: 15959293 -- START

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

1851:
1852: IF (G_IS_DEBUG_STATEMENT_ON = TRUE) THEN
1853: 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 of Investor.');
1854: END IF;
1855: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Invoices of contract => ' || p_bill_tbl(k).contract_number || ' not billed due to bankruptcy of Investor.');
1856:
1857: END IF;
1858:
1859: END IF;

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

1879: OR l_bill_date <> p_bill_tbl(k).bill_date
1880: --Bug# 9690217
1881: OR SIGN(l_bill_amount) <> SIGN(p_bill_tbl(k).amount) THEN
1882:
1883: Fnd_File.PUT_LINE (Fnd_File.LOG, ' Contract Number : '||p_bill_tbl(k).contract_number||', Bill Date : '||p_bill_tbl(k).bill_date);
1884:
1885: l_tai_cnt := l_tai_cnt + 1;
1886:
1887: -- Check if commit point reached

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

1886:
1887: -- Check if commit point reached
1888: IF l_commit_cnt > l_max_commit_cnt THEN
1889:
1890: Fnd_File.PUT_LINE (Fnd_File.LOG, ' Done building TAI, TIL, TLD, XSI and XLS records ...');
1891:
1892: -- Bulk insert/update records, Commit and restart
1893: bulk_process
1894: (p_api_version

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

2482: -- Exception handling
2483: ------------------------------------------------------------
2484:
2485: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2486: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (EXCP) => '||SQLERRM);
2487:
2488: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
2489: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',
2490: 'EXCEPTION (Process_bill_tbl):'||'OKL_API.G_EXCEPTION_ERROR');

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

2498: x_msg_data => x_msg_data,
2499: p_api_type => '_PVT');
2500:
2501: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2502: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
2503:
2504: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
2505: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',
2506: 'EXCEPTION (Process_bill_tbl):'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');

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

2514: x_msg_data => x_msg_data,
2515: p_api_type => '_PVT');
2516:
2517: WHEN OTHERS THEN
2518: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (OTHERS 3) => '||SQLERRM);
2519:
2520: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
2521: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',
2522: 'EXCEPTION (Process_bill_tbl):'||'OTHERS');

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

3319: -- Clear table contents
3320: -- ----------------------------
3321: bill_tbl.DELETE;
3322: FETCH C7 BULK COLLECT INTO bill_tbl LIMIT L_FETCH_SIZE;
3323: Fnd_File.PUT_LINE (Fnd_File.LOG, 'C7 Bill_Tbl count is: '||bill_tbl.COUNT);
3324: IF bill_tbl.COUNT > 0 THEN
3325: Process_bill_tbl
3326: (p_api_version
3327: ,p_init_msg_list

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

3346: -- Clear table contents
3347: -- ----------------------------
3348: bill_tbl.DELETE;
3349: FETCH C8 BULK COLLECT INTO bill_tbl LIMIT L_FETCH_SIZE;
3350: Fnd_File.PUT_LINE (Fnd_File.LOG, 'C8 Bill_Tbl count is: '||bill_tbl.COUNT);
3351: IF bill_tbl.COUNT > 0 THEN
3352: Process_bill_tbl
3353: (p_api_version
3354: ,p_init_msg_list

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

3373: -- Clear table contents
3374: -- ----------------------------
3375: bill_tbl.DELETE;
3376: FETCH C9 BULK COLLECT INTO bill_tbl LIMIT L_FETCH_SIZE;
3377: Fnd_File.PUT_LINE (Fnd_File.LOG, 'C9 Bill_Tbl count is: '||bill_tbl.COUNT);
3378: IF bill_tbl.COUNT > 0 THEN
3379: Process_bill_tbl
3380: (p_api_version
3381: ,p_init_msg_list

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

3406: -- Clear table contents
3407: -- ----------------------------
3408: bill_tbl.DELETE;
3409: FETCH C1 BULK COLLECT INTO bill_tbl LIMIT L_FETCH_SIZE;
3410: Fnd_File.PUT_LINE (Fnd_File.LOG, 'C1 Bill_Tbl count is: '||bill_tbl.COUNT);
3411: IF bill_tbl.COUNT > 0 THEN
3412: Process_bill_tbl
3413: (p_api_version
3414: ,p_init_msg_list

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

3433: -- Clear table contents
3434: -- ----------------------------
3435: bill_tbl.DELETE;
3436: FETCH C2 BULK COLLECT INTO bill_tbl LIMIT L_FETCH_SIZE;
3437: Fnd_File.PUT_LINE (Fnd_File.LOG, 'C2 Bill_Tbl count is: '||bill_tbl.COUNT);
3438: IF bill_tbl.COUNT > 0 THEN
3439: Process_bill_tbl
3440: (p_api_version
3441: ,p_init_msg_list

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

3460: -- Clear table contents
3461: -- ----------------------------
3462: bill_tbl.DELETE;
3463: FETCH C3 BULK COLLECT INTO bill_tbl LIMIT L_FETCH_SIZE;
3464: Fnd_File.PUT_LINE (Fnd_File.LOG, 'C3 Bill_Tbl count is: '||bill_tbl.COUNT);
3465: IF bill_tbl.COUNT > 0 THEN
3466: Process_bill_tbl
3467: (p_api_version
3468: ,p_init_msg_list

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

3491: -- Clear table contents
3492: -- ----------------------------
3493: bill_tbl.DELETE;
3494: FETCH C4 BULK COLLECT INTO bill_tbl LIMIT L_FETCH_SIZE;
3495: Fnd_File.PUT_LINE (Fnd_File.LOG, 'C4 Bill_Tbl count is: '||bill_tbl.COUNT);
3496: IF bill_tbl.COUNT > 0 THEN
3497: Process_bill_tbl
3498: (p_api_version
3499: ,p_init_msg_list

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

3518: -- Clear table contents
3519: -- ----------------------------
3520: bill_tbl.DELETE;
3521: FETCH C5 BULK COLLECT INTO bill_tbl LIMIT L_FETCH_SIZE;
3522: Fnd_File.PUT_LINE (Fnd_File.LOG, 'C5 Bill_Tbl count is: '||bill_tbl.COUNT);
3523: IF bill_tbl.COUNT > 0 THEN
3524: Process_bill_tbl
3525: (p_api_version
3526: ,p_init_msg_list

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

3545: -- Clear table contents
3546: -- ----------------------------
3547: bill_tbl.DELETE;
3548: FETCH C6 BULK COLLECT INTO bill_tbl LIMIT L_FETCH_SIZE;
3549: Fnd_File.PUT_LINE (Fnd_File.LOG, 'C6 Bill_Tbl count is: '||bill_tbl.COUNT);
3550: IF bill_tbl.COUNT > 0 THEN
3551: Process_bill_tbl
3552: (p_api_version
3553: ,p_init_msg_list

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

3661: FETCH op_unit_csr INTO l_op_unit_name;
3662: CLOSE op_unit_csr;
3663:
3664: -- Start New Out File stmathew 15-OCT-2004
3665: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'Oracle Leasing and Finance Management'||LPAD(' ', 55, ' '));
3666: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3667: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'Process Billable Streams'||LPAD(' ', 54, ' '));
3668: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'------------------------'||LPAD(' ', 54, ' '));
3669: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));

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

3662: CLOSE op_unit_csr;
3663:
3664: -- Start New Out File stmathew 15-OCT-2004
3665: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'Oracle Leasing and Finance Management'||LPAD(' ', 55, ' '));
3666: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3667: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'Process Billable Streams'||LPAD(' ', 54, ' '));
3668: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'------------------------'||LPAD(' ', 54, ' '));
3669: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3670: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));

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

3663:
3664: -- Start New Out File stmathew 15-OCT-2004
3665: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'Oracle Leasing and Finance Management'||LPAD(' ', 55, ' '));
3666: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3667: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'Process Billable Streams'||LPAD(' ', 54, ' '));
3668: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'------------------------'||LPAD(' ', 54, ' '));
3669: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3670: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3671: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Operating Unit: '||l_op_unit_name);

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

3664: -- Start New Out File stmathew 15-OCT-2004
3665: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'Oracle Leasing and Finance Management'||LPAD(' ', 55, ' '));
3666: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3667: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'Process Billable Streams'||LPAD(' ', 54, ' '));
3668: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'------------------------'||LPAD(' ', 54, ' '));
3669: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3670: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3671: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Operating Unit: '||l_op_unit_name);
3672: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Request Id: '||l_request_id||LPAD(' ',74,' ') ||'Run Date: '||TO_CHAR(SYSDATE));

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

3665: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'Oracle Leasing and Finance Management'||LPAD(' ', 55, ' '));
3666: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3667: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'Process Billable Streams'||LPAD(' ', 54, ' '));
3668: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'------------------------'||LPAD(' ', 54, ' '));
3669: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3670: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3671: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Operating Unit: '||l_op_unit_name);
3672: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Request Id: '||l_request_id||LPAD(' ',74,' ') ||'Run Date: '||TO_CHAR(SYSDATE));
3673: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Currency: '||Okl_Accounting_Util.get_func_curr_code);

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

3666: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3667: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'Process Billable Streams'||LPAD(' ', 54, ' '));
3668: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'------------------------'||LPAD(' ', 54, ' '));
3669: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3670: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3671: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Operating Unit: '||l_op_unit_name);
3672: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Request Id: '||l_request_id||LPAD(' ',74,' ') ||'Run Date: '||TO_CHAR(SYSDATE));
3673: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Currency: '||Okl_Accounting_Util.get_func_curr_code);
3674: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));

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

3667: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'Process Billable Streams'||LPAD(' ', 54, ' '));
3668: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'------------------------'||LPAD(' ', 54, ' '));
3669: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3670: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3671: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Operating Unit: '||l_op_unit_name);
3672: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Request Id: '||l_request_id||LPAD(' ',74,' ') ||'Run Date: '||TO_CHAR(SYSDATE));
3673: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Currency: '||Okl_Accounting_Util.get_func_curr_code);
3674: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));
3675: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'From Bill Date : ' ||p_from_bill_date);

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

3668: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'------------------------'||LPAD(' ', 54, ' '));
3669: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3670: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3671: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Operating Unit: '||l_op_unit_name);
3672: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Request Id: '||l_request_id||LPAD(' ',74,' ') ||'Run Date: '||TO_CHAR(SYSDATE));
3673: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Currency: '||Okl_Accounting_Util.get_func_curr_code);
3674: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));
3675: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'From Bill Date : ' ||p_from_bill_date);
3676: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'To Bill Date : ' ||p_to_bill_date);

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

3669: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3670: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3671: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Operating Unit: '||l_op_unit_name);
3672: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Request Id: '||l_request_id||LPAD(' ',74,' ') ||'Run Date: '||TO_CHAR(SYSDATE));
3673: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Currency: '||Okl_Accounting_Util.get_func_curr_code);
3674: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));
3675: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'From Bill Date : ' ||p_from_bill_date);
3676: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'To Bill Date : ' ||p_to_bill_date);
3677: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Contract Number : ' ||p_contract_number);

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

3670: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3671: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Operating Unit: '||l_op_unit_name);
3672: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Request Id: '||l_request_id||LPAD(' ',74,' ') ||'Run Date: '||TO_CHAR(SYSDATE));
3673: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Currency: '||Okl_Accounting_Util.get_func_curr_code);
3674: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));
3675: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'From Bill Date : ' ||p_from_bill_date);
3676: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'To Bill Date : ' ||p_to_bill_date);
3677: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Contract Number : ' ||p_contract_number);
3678: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));

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

3671: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Operating Unit: '||l_op_unit_name);
3672: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Request Id: '||l_request_id||LPAD(' ',74,' ') ||'Run Date: '||TO_CHAR(SYSDATE));
3673: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Currency: '||Okl_Accounting_Util.get_func_curr_code);
3674: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));
3675: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'From Bill Date : ' ||p_from_bill_date);
3676: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'To Bill Date : ' ||p_to_bill_date);
3677: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Contract Number : ' ||p_contract_number);
3678: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));
3679: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));

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

3672: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Request Id: '||l_request_id||LPAD(' ',74,' ') ||'Run Date: '||TO_CHAR(SYSDATE));
3673: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Currency: '||Okl_Accounting_Util.get_func_curr_code);
3674: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));
3675: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'From Bill Date : ' ||p_from_bill_date);
3676: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'To Bill Date : ' ||p_to_bill_date);
3677: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Contract Number : ' ||p_contract_number);
3678: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));
3679: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3680: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));

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

3673: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Currency: '||Okl_Accounting_Util.get_func_curr_code);
3674: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));
3675: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'From Bill Date : ' ||p_from_bill_date);
3676: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'To Bill Date : ' ||p_to_bill_date);
3677: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Contract Number : ' ||p_contract_number);
3678: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));
3679: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3680: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3681:

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

3674: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));
3675: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'From Bill Date : ' ||p_from_bill_date);
3676: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'To Bill Date : ' ||p_to_bill_date);
3677: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Contract Number : ' ||p_contract_number);
3678: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));
3679: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3680: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3681:
3682: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Processing Details:'||LPAD(' ', 113, ' '));

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

3675: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'From Bill Date : ' ||p_from_bill_date);
3676: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'To Bill Date : ' ||p_to_bill_date);
3677: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Contract Number : ' ||p_contract_number);
3678: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));
3679: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3680: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3681:
3682: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Processing Details:'||LPAD(' ', 113, ' '));
3683: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));

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

3676: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'To Bill Date : ' ||p_to_bill_date);
3677: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Contract Number : ' ||p_contract_number);
3678: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));
3679: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3680: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3681:
3682: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Processing Details:'||LPAD(' ', 113, ' '));
3683: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3684: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Successful Stream Elements: '||l_succ_cnt);

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

3678: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));
3679: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3680: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3681:
3682: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Processing Details:'||LPAD(' ', 113, ' '));
3683: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3684: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Successful Stream Elements: '||l_succ_cnt);
3685: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Errored Stream Elements: '||l_err_cnt);
3686: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Total: '||(l_succ_cnt+l_err_cnt));

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

3679: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3680: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3681:
3682: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Processing Details:'||LPAD(' ', 113, ' '));
3683: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3684: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Successful Stream Elements: '||l_succ_cnt);
3685: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Errored Stream Elements: '||l_err_cnt);
3686: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Total: '||(l_succ_cnt+l_err_cnt));
3687: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));

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

3680: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3681:
3682: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Processing Details:'||LPAD(' ', 113, ' '));
3683: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3684: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Successful Stream Elements: '||l_succ_cnt);
3685: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Errored Stream Elements: '||l_err_cnt);
3686: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Total: '||(l_succ_cnt+l_err_cnt));
3687: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3688:

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

3681:
3682: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Processing Details:'||LPAD(' ', 113, ' '));
3683: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3684: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Successful Stream Elements: '||l_succ_cnt);
3685: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Errored Stream Elements: '||l_err_cnt);
3686: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Total: '||(l_succ_cnt+l_err_cnt));
3687: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3688:
3689: -- End New Out File stmathew 15-OCT-2004

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

3682: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Processing Details:'||LPAD(' ', 113, ' '));
3683: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3684: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Successful Stream Elements: '||l_succ_cnt);
3685: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Errored Stream Elements: '||l_err_cnt);
3686: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Total: '||(l_succ_cnt+l_err_cnt));
3687: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3688:
3689: -- End New Out File stmathew 15-OCT-2004
3690: IF x_msg_count > 0 THEN

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

3683: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3684: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Successful Stream Elements: '||l_succ_cnt);
3685: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Errored Stream Elements: '||l_err_cnt);
3686: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Total: '||(l_succ_cnt+l_err_cnt));
3687: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3688:
3689: -- End New Out File stmathew 15-OCT-2004
3690: IF x_msg_count > 0 THEN
3691: FOR i IN 1..x_msg_count LOOP

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

3689: -- End New Out File stmathew 15-OCT-2004
3690: IF x_msg_count > 0 THEN
3691: FOR i IN 1..x_msg_count LOOP
3692: IF i = 1 THEN
3693: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Details of Errored Stream Elements:'||LPAD(' ', 97, ' '));
3694: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3695: END IF;
3696: Fnd_Msg_Pub.get (p_msg_index => i,
3697: p_encoded => 'F',

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

3690: IF x_msg_count > 0 THEN
3691: FOR i IN 1..x_msg_count LOOP
3692: IF i = 1 THEN
3693: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Details of Errored Stream Elements:'||LPAD(' ', 97, ' '));
3694: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
3695: END IF;
3696: Fnd_Msg_Pub.get (p_msg_index => i,
3697: p_encoded => 'F',
3698: p_data => lx_msg_data,

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

3697: p_encoded => 'F',
3698: p_data => lx_msg_data,
3699: p_msg_index_out => l_msg_index_out);
3700:
3701: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,TO_CHAR(i) || ': ' || lx_msg_data);
3702:
3703: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
3704: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',
3705: TO_CHAR(i) || ': ' || lx_msg_data);

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

3717: ------------------------------------------------------------
3718: -- Exception handling
3719: ------------------------------------------------------------
3720: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
3721: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (EXCP) => '||SQLERRM);
3722:
3723: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
3724: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',
3725: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');

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

3733: x_msg_data => x_msg_data,
3734: p_api_type => '_PVT');
3735:
3736: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
3737: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
3738:
3739: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
3740: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',
3741: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');

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

3749: x_msg_data => x_msg_data,
3750: p_api_type => '_PVT');
3751:
3752: WHEN OTHERS THEN
3753: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (OTHERS 2) => '||SQLERRM);
3754:
3755: IF (Fnd_Log.LEVEL_EXCEPTION >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
3756: Fnd_Log.STRING(Fnd_Log.LEVEL_EXCEPTION,'okl_stream_billing_pvt',
3757: 'EXCEPTION :'||'OTHERS');

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

3885: -- Exception handling
3886: ------------------------------------------------------------
3887:
3888: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
3889: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (EXCP) => '||SQLERRM);
3890:
3891: IF p_assigned_process IS NOT NULL THEN
3892: DELETE OKL_PARALLEL_PROCESSES
3893: WHERE assigned_process = p_assigned_process;

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

3907: x_msg_data => x_msg_data,
3908: p_api_type => '_PVT');
3909:
3910: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
3911: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
3912:
3913: IF p_assigned_process IS NOT NULL THEN
3914: DELETE OKL_PARALLEL_PROCESSES
3915: WHERE assigned_process = p_assigned_process;

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

3929: x_msg_data => x_msg_data,
3930: p_api_type => '_PVT');
3931:
3932: WHEN OTHERS THEN
3933: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (OTHERS 1) => '||SQLERRM);
3934:
3935: IF p_assigned_process IS NOT NULL THEN
3936: DELETE OKL_PARALLEL_PROCESSES
3937: WHERE assigned_process = p_assigned_process;