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

Line 564: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '=========================================================================================');

560: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
561: RAISE Okl_Api.G_EXCEPTION_ERROR;
562: END IF;
563:
564: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '=========================================================================================');
565: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ******* Start Evergreen Processing *******');
566: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '=========================================================================================');
567:
568: -- Start of code added by Venkatho as part of Bug# 14119181

Line 565: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' * Start Evergreen Processing *');

561: RAISE Okl_Api.G_EXCEPTION_ERROR;
562: END IF;
563:
564: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '=========================================================================================');
565: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ******* Start Evergreen Processing *******');
566: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '=========================================================================================');
567:
568: -- Start of code added by Venkatho as part of Bug# 14119181
569: -- Below FOR LOOP distinct_evergreen_khrs is added by venkatho as part of Bankruptcy check

Line 566: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '=========================================================================================');

562: END IF;
563:
564: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '=========================================================================================');
565: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ******* Start Evergreen Processing *******');
566: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '=========================================================================================');
567:
568: -- Start of code added by Venkatho as part of Bug# 14119181
569: -- Below FOR LOOP distinct_evergreen_khrs is added by venkatho as part of Bankruptcy check
570: FOR distinct_evergreen_khrs IN distinct_evergreen_contracts ( p_contract_number ) -- Added by Venkatho as part of Bug# 14119181

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

580:
581: IF (G_IS_DEBUG_STATEMENT_ON = TRUE) THEN
582: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Invoices of contract => ' || distinct_evergreen_khrs.contract_number || ' not billed due to bankruptcy.');
583: END IF;
584: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Invoices of contract => ' || distinct_evergreen_khrs.contract_number || ' not billed due to bankruptcy.');
585: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Invoices of contract => ' || distinct_evergreen_khrs.contract_number || ' not billed due to bankruptcy.');
586:
587: ELSIF (distinct_evergreen_khrs.bkrpcy_sts = 'N' AND distinct_evergreen_khrs.contract_number IS NOT NULL)
588: THEN

Line 585: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Invoices of contract => ' || distinct_evergreen_khrs.contract_number || ' not billed due to bankruptcy.');

581: IF (G_IS_DEBUG_STATEMENT_ON = TRUE) THEN
582: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Invoices of contract => ' || distinct_evergreen_khrs.contract_number || ' not billed due to bankruptcy.');
583: END IF;
584: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Invoices of contract => ' || distinct_evergreen_khrs.contract_number || ' not billed due to bankruptcy.');
585: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Invoices of contract => ' || distinct_evergreen_khrs.contract_number || ' not billed due to bankruptcy.');
586:
587: ELSIF (distinct_evergreen_khrs.bkrpcy_sts = 'N' AND distinct_evergreen_khrs.contract_number IS NOT NULL)
588: THEN
589:

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

589:
590: --FOR evergreen_contracts IN evergreen_contracts_csr ( p_contract_number ) LOOP -- Commented by venkatho as part of Bug# 14119181
591: FOR evergreen_contracts IN evergreen_contracts_csr ( distinct_evergreen_khrs.contract_number ) LOOP -- Added by venkatho as part of Bug# 14119181
592: -- End of code added by Venkatho as part of Bug# 14119181
593: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-----------------------------------------------------------------------------------------');
594: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Processing Contract: '||evergreen_contracts.contract_number);
595: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-----------------------------------------------------------------------------------------');
596:
597: l_khr_id := NULL;

Line 594: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Processing Contract: '||evergreen_contracts.contract_number);

590: --FOR evergreen_contracts IN evergreen_contracts_csr ( p_contract_number ) LOOP -- Commented by venkatho as part of Bug# 14119181
591: FOR evergreen_contracts IN evergreen_contracts_csr ( distinct_evergreen_khrs.contract_number ) LOOP -- Added by venkatho as part of Bug# 14119181
592: -- End of code added by Venkatho as part of Bug# 14119181
593: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-----------------------------------------------------------------------------------------');
594: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Processing Contract: '||evergreen_contracts.contract_number);
595: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-----------------------------------------------------------------------------------------');
596:
597: l_khr_id := NULL;
598: l_kle_id := NULL;

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

591: FOR evergreen_contracts IN evergreen_contracts_csr ( distinct_evergreen_khrs.contract_number ) LOOP -- Added by venkatho as part of Bug# 14119181
592: -- End of code added by Venkatho as part of Bug# 14119181
593: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-----------------------------------------------------------------------------------------');
594: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Processing Contract: '||evergreen_contracts.contract_number);
595: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-----------------------------------------------------------------------------------------');
596:
597: l_khr_id := NULL;
598: l_kle_id := NULL;
599: l_khr_id := evergreen_contracts.khr_id;

Line 621: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ' || cns_evergreen_rent || ' Streams exist for this contract.');

617: FETCH c_sty_count_csr INTO l_evergreen_rent_count;
618: CLOSE c_sty_count_csr;
619:
620: IF l_evergreen_rent_count > 0 THEN
621: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ' || cns_evergreen_rent || ' Streams exist for this contract.');
622: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Proceeding to creation of stream elements.');
623: ELSE
624: l_contract_rent_count := 0;
625:

Line 622: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Proceeding to creation of stream elements.');

618: CLOSE c_sty_count_csr;
619:
620: IF l_evergreen_rent_count > 0 THEN
621: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ' || cns_evergreen_rent || ' Streams exist for this contract.');
622: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Proceeding to creation of stream elements.');
623: ELSE
624: l_contract_rent_count := 0;
625:
626: --change for User Defined Streams, by pjgomes, on 18 Oct 2004

Line 654: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Sty id for RENT: ' || l_primary_sty_id);

650: ------------------------------------------------------
651: OPEN get_prim_sty_id_csr(l_khr_id, l_kle_id, cns_rent);
652: FETCH get_prim_sty_id_csr INTO l_primary_sty_id;
653: CLOSE get_prim_sty_id_csr;
654: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Sty id for RENT: ' || l_primary_sty_id);
655:
656: --change for User Defined Streams, by pjgomes, on 18 Oct 2004
657: OKL_STREAMS_UTIL.get_dependent_stream_type(p_khr_id => l_khr_id
658: ,p_primary_sty_id => l_primary_sty_id

Line 664: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Obtaining sty id for: ' || cns_evergreen_rent);

660: ,x_return_status => l_return_status
661: ,x_dependent_sty_id => l_sty_id);
662:
663: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
664: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Obtaining sty id for: ' || cns_evergreen_rent);
665: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
666: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
667: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Obtaining sty id for: ' || cns_evergreen_rent);
668: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 667: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Obtaining sty id for: ' || cns_evergreen_rent);

663: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
664: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Obtaining sty id for: ' || cns_evergreen_rent);
665: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
666: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
667: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Obtaining sty id for: ' || cns_evergreen_rent);
668: RAISE Okl_Api.G_EXCEPTION_ERROR;
669: END IF;
670: --OPEN get_stm_attrs_csr ( l_khr_id , 'RENT' );
671: --LOOP

Line 698: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Creating EVERGREEN RENT Streams');

694: l_stmv_rec.active_yn := 'Y';
695: l_stmv_rec.date_current := sysdate;
696: l_stmv_rec.comments := 'Evergreen Billing';
697:
698: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Creating EVERGREEN RENT Streams');
699:
700: Okl_Streams_Pub.create_streams(
701: p_api_version => p_api_version,
702: p_init_msg_list => p_init_msg_list,

Line 710: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Creating Streams for EVERGREEN RENT');

706: p_stmv_rec => l_stmv_rec,
707: x_stmv_rec => lx_stmv_rec);
708:
709: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
710: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Creating Streams for EVERGREEN RENT');
711: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
712: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
713: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Creating Streams for EVERGREEN RENT');
714: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 713: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Creating Streams for EVERGREEN RENT');

709: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
710: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Creating Streams for EVERGREEN RENT');
711: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
712: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
713: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Creating Streams for EVERGREEN RENT');
714: RAISE Okl_Api.G_EXCEPTION_ERROR;
715: END IF;
716: /*END LOOP;
717: CLOSE get_stm_attrs_csr;*/

Line 731: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ' || cns_sm_evergreen || ' Streams exist for this contract.');

727: FETCH c_sty_count_csr INTO l_evergreen_sm_count;
728: CLOSE c_sty_count_csr;
729:
730: IF l_evergreen_sm_count > 0 THEN
731: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ' || cns_sm_evergreen || ' Streams exist for this contract.');
732: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Proceeding to creation of stream elements.');
733: ELSE
734: l_contract_sm_count := 0;
735:

Line 732: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Proceeding to creation of stream elements.');

728: CLOSE c_sty_count_csr;
729:
730: IF l_evergreen_sm_count > 0 THEN
731: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ' || cns_sm_evergreen || ' Streams exist for this contract.');
732: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Proceeding to creation of stream elements.');
733: ELSE
734: l_contract_sm_count := 0;
735:
736: --change for User Defined Streams, by pjgomes, on 18 Oct 2004

Line 765: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Sty id for SERVICE AND MAINTENANCE: ' || l_primary_sty_id);

761: ------------------------------------------------------
762: OPEN get_prim_sty_id_csr(l_khr_id, l_kle_id, cns_sm);
763: FETCH get_prim_sty_id_csr INTO l_primary_sty_id;
764: CLOSE get_prim_sty_id_csr;
765: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Sty id for SERVICE AND MAINTENANCE: ' || l_primary_sty_id);
766:
767: --change for User Defined Streams, by pjgomes, on 18 Oct 2004
768: OKL_STREAMS_UTIL.get_dependent_stream_type(p_khr_id => l_khr_id
769: ,p_primary_sty_id => l_primary_sty_id

Line 775: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Obtaining sty id for: ' || cns_sm_evergreen);

771: ,x_return_status => l_return_status
772: ,x_dependent_sty_id => l_sty_id);
773:
774: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
775: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Obtaining sty id for: ' || cns_sm_evergreen);
776: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
777: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
778: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Obtaining sty id for: ' || cns_sm_evergreen);
779: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 778: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Obtaining sty id for: ' || cns_sm_evergreen);

774: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
775: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Obtaining sty id for: ' || cns_sm_evergreen);
776: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
777: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
778: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Obtaining sty id for: ' || cns_sm_evergreen);
779: RAISE Okl_Api.G_EXCEPTION_ERROR;
780: END IF;
781:
782: /*OPEN get_stm_attrs_csr ( l_khr_id , 'SERVICE AND MAINTENANCE' );

Line 810: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Creating SERVICE AND MAINTENANCE EVERGREEN Streams');

806: l_stmv_rec.date_current := sysdate;
807: l_stmv_rec.comments := 'Evergreen Billing';
808:
809:
810: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Creating SERVICE AND MAINTENANCE EVERGREEN Streams');
811: Okl_Streams_Pub.create_streams(
812: p_api_version => p_api_version,
813: p_init_msg_list => p_init_msg_list,
814: x_return_status => x_return_status,

Line 821: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Creating Streams for SERVICE AND MAINTENANCE EVERGREEN');

817: p_stmv_rec => l_stmv_rec,
818: x_stmv_rec => lx_stmv_rec);
819:
820: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
821: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Creating Streams for SERVICE AND MAINTENANCE EVERGREEN');
822: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
823: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
824: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Creating Streams for SERVICE AND MAINTENANCE EVERGREEN');
825: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 824: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Creating Streams for SERVICE AND MAINTENANCE EVERGREEN');

820: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
821: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Creating Streams for SERVICE AND MAINTENANCE EVERGREEN');
822: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
823: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
824: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Creating Streams for SERVICE AND MAINTENANCE EVERGREEN');
825: RAISE Okl_Api.G_EXCEPTION_ERROR;
826: END IF;
827: /*END LOOP;
828: CLOSE c_tran_num_csr;*/

Line 842: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ' || cns_ept_evergreen || ' Streams exist for this contract.');

838: FETCH c_sty_count_csr INTO l_evergreen_ept_count;
839: CLOSE c_sty_count_csr;
840:
841: IF l_evergreen_ept_count > 0 THEN
842: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ' || cns_ept_evergreen || ' Streams exist for this contract.');
843: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Proceeding to creation of stream elements.');
844: ELSE
845: l_contract_ept_count := 0;
846:

Line 843: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Proceeding to creation of stream elements.');

839: CLOSE c_sty_count_csr;
840:
841: IF l_evergreen_ept_count > 0 THEN
842: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ' || cns_ept_evergreen || ' Streams exist for this contract.');
843: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Proceeding to creation of stream elements.');
844: ELSE
845: l_contract_ept_count := 0;
846:
847: --change for User Defined Streams, by pjgomes, on 18 Oct 2004

Line 875: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Sty id for ESTIMATED PROPERTY TAX: ' || l_primary_sty_id);

871: ------------------------------------------------------
872: OPEN get_prim_sty_id_csr(l_khr_id, l_kle_id, cns_ept);
873: FETCH get_prim_sty_id_csr INTO l_primary_sty_id;
874: CLOSE get_prim_sty_id_csr;
875: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Sty id for ESTIMATED PROPERTY TAX: ' || l_primary_sty_id);
876:
877:
878: --change for User Defined Streams, by pjgomes, on 18 Oct 2004
879: OKL_STREAMS_UTIL.get_dependent_stream_type(p_khr_id => l_khr_id

Line 886: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Obtaining sty id for: ' || cns_ept_evergreen);

882: ,x_return_status => l_return_status
883: ,x_dependent_sty_id => l_sty_id);
884:
885: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
886: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Obtaining sty id for: ' || cns_ept_evergreen);
887: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
888: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
889: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Obtaining sty id for: ' || cns_ept_evergreen);
890: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 889: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Obtaining sty id for: ' || cns_ept_evergreen);

885: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
886: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Obtaining sty id for: ' || cns_ept_evergreen);
887: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
888: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
889: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Obtaining sty id for: ' || cns_ept_evergreen);
890: RAISE Okl_Api.G_EXCEPTION_ERROR;
891: END IF;
892:
893: OPEN c_tran_num_csr;

Line 912: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Creating ESTIMATED PERSONAL PROPERTY TAX EVERGREEN Streams');

908: l_stmv_rec.active_yn := 'Y';
909: l_stmv_rec.date_current := sysdate;
910: l_stmv_rec.comments := 'Evergreen Billing';
911:
912: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Creating ESTIMATED PERSONAL PROPERTY TAX EVERGREEN Streams');
913:
914: Okl_Streams_Pub.create_streams(
915: p_api_version => p_api_version,
916: p_init_msg_list => p_init_msg_list,

Line 924: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Creating Streams for ESTIMATED PERSONAL PROPERTY TAX EVERGREEN');

920: p_stmv_rec => l_stmv_rec,
921: x_stmv_rec => lx_stmv_rec);
922:
923: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
924: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Creating Streams for ESTIMATED PERSONAL PROPERTY TAX EVERGREEN');
925: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
926: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
927: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Creating Streams for ESTIMATED PERSONAL PROPERTY TAX EVERGREEN');
928: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 927: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Creating Streams for ESTIMATED PERSONAL PROPERTY TAX EVERGREEN');

923: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
924: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Creating Streams for ESTIMATED PERSONAL PROPERTY TAX EVERGREEN');
925: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
926: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
927: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Creating Streams for ESTIMATED PERSONAL PROPERTY TAX EVERGREEN');
928: RAISE Okl_Api.G_EXCEPTION_ERROR;
929: END IF;
930: /*END LOOP;
931: CLOSE get_stm_attrs_csr;*/

Line 945: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ' || cns_fee_evergreen || ' Streams exist for this contract.');

941: FETCH c_sty_count_csr INTO l_evergreen_fee_count;
942: CLOSE c_sty_count_csr;
943:
944: IF l_evergreen_fee_count > 0 THEN
945: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ' || cns_fee_evergreen || ' Streams exist for this contract.');
946: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Proceeding to creation of stream elements.');
947: ELSE
948: l_contract_fee_count := 0;
949:

Line 946: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Proceeding to creation of stream elements.');

942: CLOSE c_sty_count_csr;
943:
944: IF l_evergreen_fee_count > 0 THEN
945: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ' || cns_fee_evergreen || ' Streams exist for this contract.');
946: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Proceeding to creation of stream elements.');
947: ELSE
948: l_contract_fee_count := 0;
949:
950: OPEN c_sty_count_csr ( l_khr_id, l_kle_id, cns_fee );

Line 963: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-- ERROR: Checking evergreen billing eligibility for: ' || l_kle_id);

959: p_kle_id => l_kle_id,
960: x_gen_streams => l_gen_streams);
961:
962: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
963: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-- ERROR: Checking evergreen billing eligibility for: ' || l_kle_id);
964: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
965: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
966: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-- ERROR: Checking evergreen billing eligibility for: ' || l_kle_id);
967: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 966: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-- ERROR: Checking evergreen billing eligibility for: ' || l_kle_id);

962: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
963: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-- ERROR: Checking evergreen billing eligibility for: ' || l_kle_id);
964: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
965: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
966: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-- ERROR: Checking evergreen billing eligibility for: ' || l_kle_id);
967: RAISE Okl_Api.G_EXCEPTION_ERROR;
968: END IF;
969:
970: if l_gen_streams = 'Y' then -- { Bug# 11787205: end

Line 991: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Sty id for FEE: ' || l_primary_sty_id);

987: ------------------------------------------------------
988: OPEN get_prim_sty_id_csr(l_khr_id, l_kle_id, cns_fee);
989: FETCH get_prim_sty_id_csr INTO l_primary_sty_id;
990: CLOSE get_prim_sty_id_csr;
991: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Sty id for FEE: ' || l_primary_sty_id);
992:
993: --change for User Defined Streams, by pjgomes, on 18 Oct 2004
994: OKL_STREAMS_UTIL.get_dependent_stream_type(p_khr_id => l_khr_id
995: ,p_primary_sty_id => l_primary_sty_id

Line 1001: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Obtaining sty id for: ' || cns_fee_evergreen);

997: ,x_return_status => l_return_status
998: ,x_dependent_sty_id => l_sty_id);
999:
1000: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1001: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Obtaining sty id for: ' || cns_fee_evergreen);
1002: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1003: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1004: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Obtaining sty id for: ' || cns_fee_evergreen);
1005: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 1004: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Obtaining sty id for: ' || cns_fee_evergreen);

1000: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1001: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Obtaining sty id for: ' || cns_fee_evergreen);
1002: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1003: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1004: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Obtaining sty id for: ' || cns_fee_evergreen);
1005: RAISE Okl_Api.G_EXCEPTION_ERROR;
1006: END IF;
1007:
1008:

Line 1028: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Creating FEE EVERGREEN Streams');

1024: l_stmv_rec.date_current := sysdate;
1025: l_stmv_rec.comments := 'Evergreen Billing';
1026:
1027:
1028: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Creating FEE EVERGREEN Streams');
1029: Okl_Streams_Pub.create_streams(
1030: p_api_version => p_api_version,
1031: p_init_msg_list => p_init_msg_list,
1032: x_return_status => x_return_status,

Line 1039: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Creating Streams for FEE EVERGREEN');

1035: p_stmv_rec => l_stmv_rec,
1036: x_stmv_rec => lx_stmv_rec);
1037:
1038: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1039: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Creating Streams for FEE EVERGREEN');
1040: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1041: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1042: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Creating Streams for FEE EVERGREEN');
1043: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 1042: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Creating Streams for FEE EVERGREEN');

1038: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1039: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Creating Streams for FEE EVERGREEN');
1040: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1041: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1042: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Creating Streams for FEE EVERGREEN');
1043: RAISE Okl_Api.G_EXCEPTION_ERROR;
1044: END IF;
1045: /*END LOOP;
1046: CLOSE c_tran_num_csr;*/

Line 1056: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Streams for Evergreen Billing exist for this contract.');

1052: END IF;
1053: END IF;
1054:
1055: ELSE
1056: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Streams for Evergreen Billing exist for this contract.');
1057: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Proceeding to creation of stream elements for Evergreen Billing.');
1058: END IF;
1059:
1060: FOR stms IN c_stm_id( l_khr_id, l_kle_id ) LOOP

Line 1057: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Proceeding to creation of stream elements for Evergreen Billing.');

1053: END IF;
1054:
1055: ELSE
1056: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Streams for Evergreen Billing exist for this contract.');
1057: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Proceeding to creation of stream elements for Evergreen Billing.');
1058: END IF;
1059:
1060: FOR stms IN c_stm_id( l_khr_id, l_kle_id ) LOOP
1061:

Line 1106: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Contract id: ' || l_khr_id || ' Line id: ' || l_kle_id);

1102: l_evrgrn_strm_purpose := null;
1103: l_evrgrn_prim_strm_purpose := null;
1104: l_investor_agrmt_id := null;
1105:
1106: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Contract id: ' || l_khr_id || ' Line id: ' || l_kle_id);
1107: --change for User Defined Streams, by pjgomes, on 18 Oct 2004
1108: FOR cur_last_strm IN c_last_strm_csr ( l_khr_id , l_kle_id, cns_rent) LOOP
1109: ----------------------------------------------------------------
1110: --CHECK IF THE LAST RENT STREAM WAS SECURITIZED

Line 1149: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Contract id: ' || l_khr_id || ' Line id: ' || l_kle_id);

1145: create_payable_flag := 'N';
1146: l_evrgrn_strm_purpose := null;
1147: l_evrgrn_prim_strm_purpose := null;
1148: l_investor_agrmt_id := null;
1149: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Contract id: ' || l_khr_id || ' Line id: ' || l_kle_id);
1150: --change for User Defined Streams, by pjgomes, on 18 Oct 2004
1151: FOR cur_last_strm IN c_last_strm_csr ( l_khr_id , l_kle_id, cns_sm) LOOP
1152: ----------------------------------------------------------------
1153: --CHECK IF THE LAST SERVICE AND MAINTENANCE STREAM WAS SECURITIZED

Line 1186: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Contract id: ' || l_khr_id || ' Line id: ' || l_kle_id);

1182: OPEN bill_amt_csr ( l_khr_id , l_kle_id, cns_ept );
1183: FETCH bill_amt_csr INTO l_amount;
1184: CLOSE bill_amt_csr;
1185:
1186: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Contract id: ' || l_khr_id || ' Line id: ' || l_kle_id);
1187:
1188: create_payable_flag := 'N';
1189: l_evrgrn_strm_purpose := null;
1190: l_evrgrn_prim_strm_purpose := null;

Line 1208: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Contract id: ' || l_khr_id || ' Line id: ' || l_kle_id);

1204: OPEN bill_amt_csr ( l_khr_id , l_kle_id, cns_fee );
1205: FETCH bill_amt_csr INTO l_amount;
1206: CLOSE bill_amt_csr;
1207:
1208: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Contract id: ' || l_khr_id || ' Line id: ' || l_kle_id);
1209:
1210: create_payable_flag := 'N';
1211: l_evrgrn_strm_purpose := null;
1212: l_evrgrn_prim_strm_purpose := null;

Line 1260: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: '||l_error_message);

1256: l_billing_frequency := 1;
1257: ELSE
1258: l_error_message := 'Invalid Billing Frequency. ';
1259: l_error_status := Okl_Api.G_RET_STS_ERROR;
1260: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: '||l_error_message);
1261: END IF;
1262: IF l_billing_frequency IS NOT NULL THEN
1263: OKL_STREAM_GENERATOR_PVT.add_months_new(p_start_date => l_last_Stream_bill_date,
1264: p_months_after => l_billing_frequency,

Line 1271: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' => Last Billed: '||l_last_Stream_bill_date);

1267: END IF;
1268: --dkagrawa BUG#4604842 end
1269:
1270:
1271: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' => Last Billed: '||l_last_Stream_bill_date);
1272: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' => Next Determined: '||l_Stream_bill_date);
1273:
1274: ------------------------------------------------------------
1275: -- If the program has a from and to date supplied the

Line 1272: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' => Next Determined: '||l_Stream_bill_date);

1268: --dkagrawa BUG#4604842 end
1269:
1270:
1271: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' => Last Billed: '||l_last_Stream_bill_date);
1272: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' => Next Determined: '||l_Stream_bill_date);
1273:
1274: ------------------------------------------------------------
1275: -- If the program has a from and to date supplied the
1276: -- evergreen stream element must be between the two

Line 1282: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Bill_DATE is less than supplied From Date.');

1278: create_flag := 'Y';
1279:
1280: IF p_from_bill_date IS NOT NULL THEN
1281: IF (l_Stream_bill_date < p_from_bill_date) THEN
1282: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Bill_DATE is less than supplied From Date.');
1283: create_flag := 'N';
1284: END IF;
1285: END IF;
1286:

Line 1289: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Bill_DATE is greater than supplied To Date.');

1285: END IF;
1286:
1287: IF p_to_bill_date IS NOT NULL THEN
1288: IF (l_Stream_bill_date > p_to_bill_date) THEN
1289: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Bill_DATE is greater than supplied To Date.');
1290: create_flag := 'N';
1291: END IF;
1292: END IF;
1293:

Line 1306: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Previously Unbilled Stream Elements Exist.');

1302: CLOSE prev_unbilled_csr;
1303: -- CHEck if an unbilled stream element exists for the same date
1304: -- and set the create flag
1305: IF l_prev_unbilled_cnt > 0 THEN
1306: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Previously Unbilled Stream Elements Exist.');
1307: create_flag := 'N';
1308: END IF;
1309: END IF;
1310:

Line 1323: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Duplicate Stream Element.');

1319: CLOSE stm_rec_exists_csr;
1320: -- CHEck if an unbilled stream element exists for the same date
1321: -- and set the create flag
1322: IF l_rec_exists_cnt > 0 THEN
1323: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Duplicate Stream Element.');
1324: create_flag := 'N';
1325: END IF;
1326: END IF;
1327:

Line 1362: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' --Evergreen Stream Element id: ' || l_sel_id);

1358: x_selv_rec);
1359:
1360: l_sel_id := x_selv_rec.id;
1361:
1362: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' --Evergreen Stream Element id: ' || l_sel_id);
1363: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1364: l_error_message := 'Error Creating Stream Element for Contract: '
1365: ||stms.contract_number
1366: ||' Stream: '||stms.sty_name

Line 1381: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Created Evergreen Stream Element for Contract: '

1377: l_error_status := Okl_Api.G_RET_STS_ERROR;
1378: --RAISE Okl_Api.G_EXCEPTION_ERROR;
1379: ELSE
1380:
1381: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Created Evergreen Stream Element for Contract: '
1382: ||stms.contract_number
1383: ||' Stream: '||stms.sty_name
1384: ||' Bill Date: '||l_Stream_bill_date
1385: ||' Amount: '||l_amount

Line 1405: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- EVERGREEN PAYABLE STREAM TYPE: ' || l_evrgrn_strm_purpose);

1401: -- end fmiao for bug 4961860
1402:
1403: IF(l_evrgrn_psthrgh_flg = 0) THEN
1404: -- Added by fmiao for bug 4961860
1405: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- EVERGREEN PAYABLE STREAM TYPE: ' || l_evrgrn_strm_purpose);
1406: ----------------------------------------------------------------
1407: --PROCESSING FOR EVERGREEN STREAM TYPE PAYABLE TO INVESTOR
1408: ----------------------------------------------------------------
1409: --get stream type id

Line 1423: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Sty id for ' || l_evrgrn_prim_strm_purpose || ': ' || l_primary_sty_id); */

1419: ------------------------------------------------------
1420: /*OPEN get_prim_sty_id_csr(l_khr_id, l_kle_id, l_evrgrn_prim_strm_purpose);
1421: FETCH get_prim_sty_id_csr INTO l_primary_sty_id;
1422: CLOSE get_prim_sty_id_csr;
1423: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Sty id for ' || l_evrgrn_prim_strm_purpose || ': ' || l_primary_sty_id); */
1424:
1425: --change for User Defined Streams, by pjgomes, on 18 Oct 2004
1426: OKL_STREAMS_UTIL.get_primary_stream_type(p_khr_id => l_investor_agrmt_id
1427: ,p_primary_sty_purpose => l_evrgrn_strm_purpose

Line 1432: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Obtaining sty id for: ' || l_evrgrn_strm_purpose);

1428: ,x_return_status => l_return_status
1429: ,x_primary_sty_id => l_sty_id);
1430:
1431: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1432: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Obtaining sty id for: ' || l_evrgrn_strm_purpose);
1433: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1434: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1435: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Obtaining sty id for: ' || l_evrgrn_strm_purpose);
1436: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 1435: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Obtaining sty id for: ' || l_evrgrn_strm_purpose);

1431: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1432: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Obtaining sty id for: ' || l_evrgrn_strm_purpose);
1433: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1434: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1435: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Obtaining sty id for: ' || l_evrgrn_strm_purpose);
1436: RAISE Okl_Api.G_EXCEPTION_ERROR;
1437: END IF;
1438:
1439: --check for stream

Line 1473: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Creating ' || l_evrgrn_strm_purpose || ' Stream');

1469: l_stmv_rec.source_id := l_investor_agrmt_id;
1470: l_stmv_rec.source_table := 'OKL_K_HEADERS';
1471: END IF;
1472:
1473: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Creating ' || l_evrgrn_strm_purpose || ' Stream');
1474:
1475: Okl_Streams_Pub.create_streams(
1476: p_api_version => p_api_version,
1477: p_init_msg_list => p_init_msg_list,

Line 1487: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Stream element line number => ' || l_se_line_number);

1483:
1484: l_stm_id := lx_stmv_rec.id;
1485: l_se_line_number := 1;
1486:
1487: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Stream element line number => ' || l_se_line_number);
1488: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1489: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Creating Stream for ' || l_evrgrn_strm_purpose);
1490: RAISE Okl_Api.G_EXCEPTION_ERROR;
1491: ELSE

Line 1489: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Creating Stream for ' || l_evrgrn_strm_purpose);

1485: l_se_line_number := 1;
1486:
1487: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Stream element line number => ' || l_se_line_number);
1488: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1489: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Creating Stream for ' || l_evrgrn_strm_purpose);
1490: RAISE Okl_Api.G_EXCEPTION_ERROR;
1491: ELSE
1492: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- SUCCESS: Creating Stream for ' || l_evrgrn_strm_purpose);
1493: END IF;

Line 1492: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- SUCCESS: Creating Stream for ' || l_evrgrn_strm_purpose);

1488: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1489: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Creating Stream for ' || l_evrgrn_strm_purpose);
1490: RAISE Okl_Api.G_EXCEPTION_ERROR;
1491: ELSE
1492: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- SUCCESS: Creating Stream for ' || l_evrgrn_strm_purpose);
1493: END IF;
1494: ELSE
1495: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Stream for ' || l_evrgrn_strm_purpose || ' found');
1496: open l_stream_line_nbr_csr(l_stm_id);

Line 1495: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Stream for ' || l_evrgrn_strm_purpose || ' found');

1491: ELSE
1492: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- SUCCESS: Creating Stream for ' || l_evrgrn_strm_purpose);
1493: END IF;
1494: ELSE
1495: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Stream for ' || l_evrgrn_strm_purpose || ' found');
1496: open l_stream_line_nbr_csr(l_stm_id);
1497: fetch l_stream_line_nbr_csr into l_se_line_number;
1498: close l_stream_line_nbr_csr;
1499: l_se_line_number := l_se_line_number + 1;

Line 1500: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Stream element line number => ' || l_se_line_number);

1496: open l_stream_line_nbr_csr(l_stm_id);
1497: fetch l_stream_line_nbr_csr into l_se_line_number;
1498: close l_stream_line_nbr_csr;
1499: l_se_line_number := l_se_line_number + 1;
1500: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Stream element line number => ' || l_se_line_number);
1501: END IF;
1502:
1503: --create stream element for evergreen stream payable
1504: IF (l_stm_id IS NOT NULL) THEN

Line 1529: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Error Creating Payable Stream Element for Contract: '

1525: l_selv_rec,
1526: lx_selv_rec);
1527:
1528: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1529: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Error Creating Payable Stream Element for Contract: '
1530: || evergreen_contracts.contract_number
1531: ||' Stream: '||l_evrgrn_strm_purpose
1532: ||' Bill Date: '||l_selv_rec.STREAM_ELEMENT_DATE
1533: ||' Amount: '||l_amount);

Line 1537: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Created Investor Payable Stream Element for Contract: '

1533: ||' Amount: '||l_amount);
1534: RAISE Okl_Api.G_EXCEPTION_ERROR;
1535: ELSE
1536:
1537: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Created Investor Payable Stream Element for Contract: '
1538: || evergreen_contracts.contract_number
1539: ||' Stream: '||l_evrgrn_strm_purpose
1540: ||' Bill Date: '||l_selv_rec.STREAM_ELEMENT_DATE
1541: ||' Amount: '||l_amount

Line 1552: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: '||l_error_message);

1548: END IF;
1549: END IF;
1550:
1551: IF l_error_status <> OKL_API.G_RET_STS_SUCCESS THEN
1552: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: '||l_error_message);
1553: END IF;
1554:
1555: END LOOP;
1556: --dkagrawa bug# 4728636 changes start

Line 1579: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '=========================================================================================');

1575:
1576: END; -- Added as part of Bug# 14119181
1577: END LOOP; -- FOR distinct_evergreen_khrs added as part of Bug# 14119181
1578:
1579: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '=========================================================================================');
1580: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ******* End Evergreen Processing *******');
1581: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '=========================================================================================');
1582:
1583: ------------------------------------------------------------

Line 1580: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' * End Evergreen Processing *');

1576: END; -- Added as part of Bug# 14119181
1577: END LOOP; -- FOR distinct_evergreen_khrs added as part of Bug# 14119181
1578:
1579: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '=========================================================================================');
1580: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ******* End Evergreen Processing *******');
1581: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '=========================================================================================');
1582:
1583: ------------------------------------------------------------
1584: -- End processing

Line 1581: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '=========================================================================================');

1577: END LOOP; -- FOR distinct_evergreen_khrs added as part of Bug# 14119181
1578:
1579: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '=========================================================================================');
1580: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ******* End Evergreen Processing *******');
1581: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '=========================================================================================');
1582:
1583: ------------------------------------------------------------
1584: -- End processing
1585: ------------------------------------------------------------