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 515: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '=========================================================================================');

511: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
512: RAISE Okl_Api.G_EXCEPTION_ERROR;
513: END IF;
514:
515: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '=========================================================================================');
516: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ******* Start Evergreen Processing *******');
517: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '=========================================================================================');
518:
519:

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

512: RAISE Okl_Api.G_EXCEPTION_ERROR;
513: END IF;
514:
515: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '=========================================================================================');
516: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ******* Start Evergreen Processing *******');
517: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '=========================================================================================');
518:
519:
520: FOR evergreen_contracts IN evergreen_contracts_csr ( p_contract_number ) LOOP

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

513: END IF;
514:
515: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '=========================================================================================');
516: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ******* Start Evergreen Processing *******');
517: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '=========================================================================================');
518:
519:
520: FOR evergreen_contracts IN evergreen_contracts_csr ( p_contract_number ) LOOP
521: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-----------------------------------------------------------------------------------------');

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

517: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '=========================================================================================');
518:
519:
520: FOR evergreen_contracts IN evergreen_contracts_csr ( p_contract_number ) LOOP
521: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-----------------------------------------------------------------------------------------');
522: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Processing Contract: '||evergreen_contracts.contract_number);
523: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-----------------------------------------------------------------------------------------');
524:
525: l_khr_id := NULL;

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

518:
519:
520: FOR evergreen_contracts IN evergreen_contracts_csr ( p_contract_number ) LOOP
521: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-----------------------------------------------------------------------------------------');
522: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Processing Contract: '||evergreen_contracts.contract_number);
523: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-----------------------------------------------------------------------------------------');
524:
525: l_khr_id := NULL;
526: l_kle_id := NULL;

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

519:
520: FOR evergreen_contracts IN evergreen_contracts_csr ( p_contract_number ) LOOP
521: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-----------------------------------------------------------------------------------------');
522: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Processing Contract: '||evergreen_contracts.contract_number);
523: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '-----------------------------------------------------------------------------------------');
524:
525: l_khr_id := NULL;
526: l_kle_id := NULL;
527: l_khr_id := evergreen_contracts.khr_id;

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

545: FETCH c_sty_count_csr INTO l_evergreen_rent_count;
546: CLOSE c_sty_count_csr;
547:
548: IF l_evergreen_rent_count > 0 THEN
549: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ' || cns_evergreen_rent || ' Streams exist for this contract.');
550: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Proceeding to creation of stream elements.');
551: ELSE
552: l_contract_rent_count := 0;
553:

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

546: CLOSE c_sty_count_csr;
547:
548: IF l_evergreen_rent_count > 0 THEN
549: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ' || cns_evergreen_rent || ' Streams exist for this contract.');
550: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Proceeding to creation of stream elements.');
551: ELSE
552: l_contract_rent_count := 0;
553:
554: --change for User Defined Streams, by pjgomes, on 18 Oct 2004

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

578: ------------------------------------------------------
579: OPEN get_prim_sty_id_csr(l_khr_id, l_kle_id, cns_rent);
580: FETCH get_prim_sty_id_csr INTO l_primary_sty_id;
581: CLOSE get_prim_sty_id_csr;
582: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Sty id for RENT: ' || l_primary_sty_id);
583:
584: --change for User Defined Streams, by pjgomes, on 18 Oct 2004
585: OKL_STREAMS_UTIL.get_dependent_stream_type(p_khr_id => l_khr_id
586: ,p_primary_sty_id => l_primary_sty_id

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

588: ,x_return_status => l_return_status
589: ,x_dependent_sty_id => l_sty_id);
590:
591: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
592: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Obtaining sty id for: ' || cns_evergreen_rent);
593: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
594: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
595: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Obtaining sty id for: ' || cns_evergreen_rent);
596: RAISE Okl_Api.G_EXCEPTION_ERROR;

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

591: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
592: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Obtaining sty id for: ' || cns_evergreen_rent);
593: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
594: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
595: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Obtaining sty id for: ' || cns_evergreen_rent);
596: RAISE Okl_Api.G_EXCEPTION_ERROR;
597: END IF;
598: --OPEN get_stm_attrs_csr ( l_khr_id , 'RENT' );
599: --LOOP

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

622: l_stmv_rec.active_yn := 'Y';
623: l_stmv_rec.date_current := sysdate;
624: l_stmv_rec.comments := 'Evergreen Billing';
625:
626: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Creating EVERGREEN RENT Streams');
627:
628: Okl_Streams_Pub.create_streams(
629: p_api_version => p_api_version,
630: p_init_msg_list => p_init_msg_list,

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

634: p_stmv_rec => l_stmv_rec,
635: x_stmv_rec => lx_stmv_rec);
636:
637: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
638: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Creating Streams for EVERGREEN RENT');
639: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
640: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
641: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Creating Streams for EVERGREEN RENT');
642: RAISE Okl_Api.G_EXCEPTION_ERROR;

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

637: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
638: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Creating Streams for EVERGREEN RENT');
639: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
640: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
641: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Creating Streams for EVERGREEN RENT');
642: RAISE Okl_Api.G_EXCEPTION_ERROR;
643: END IF;
644: /*END LOOP;
645: CLOSE get_stm_attrs_csr;*/

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

655: FETCH c_sty_count_csr INTO l_evergreen_sm_count;
656: CLOSE c_sty_count_csr;
657:
658: IF l_evergreen_sm_count > 0 THEN
659: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ' || cns_sm_evergreen || ' Streams exist for this contract.');
660: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Proceeding to creation of stream elements.');
661: ELSE
662: l_contract_sm_count := 0;
663:

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

656: CLOSE c_sty_count_csr;
657:
658: IF l_evergreen_sm_count > 0 THEN
659: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ' || cns_sm_evergreen || ' Streams exist for this contract.');
660: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Proceeding to creation of stream elements.');
661: ELSE
662: l_contract_sm_count := 0;
663:
664: --change for User Defined Streams, by pjgomes, on 18 Oct 2004

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

689: ------------------------------------------------------
690: OPEN get_prim_sty_id_csr(l_khr_id, l_kle_id, cns_sm);
691: FETCH get_prim_sty_id_csr INTO l_primary_sty_id;
692: CLOSE get_prim_sty_id_csr;
693: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Sty id for SERVICE AND MAINTENANCE: ' || l_primary_sty_id);
694:
695: --change for User Defined Streams, by pjgomes, on 18 Oct 2004
696: OKL_STREAMS_UTIL.get_dependent_stream_type(p_khr_id => l_khr_id
697: ,p_primary_sty_id => l_primary_sty_id

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

699: ,x_return_status => l_return_status
700: ,x_dependent_sty_id => l_sty_id);
701:
702: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
703: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Obtaining sty id for: ' || cns_sm_evergreen);
704: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
705: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
706: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Obtaining sty id for: ' || cns_sm_evergreen);
707: RAISE Okl_Api.G_EXCEPTION_ERROR;

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

702: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
703: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Obtaining sty id for: ' || cns_sm_evergreen);
704: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
705: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
706: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Obtaining sty id for: ' || cns_sm_evergreen);
707: RAISE Okl_Api.G_EXCEPTION_ERROR;
708: END IF;
709:
710: /*OPEN get_stm_attrs_csr ( l_khr_id , 'SERVICE AND MAINTENANCE' );

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

734: l_stmv_rec.date_current := sysdate;
735: l_stmv_rec.comments := 'Evergreen Billing';
736:
737:
738: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Creating SERVICE AND MAINTENANCE EVERGREEN Streams');
739: Okl_Streams_Pub.create_streams(
740: p_api_version => p_api_version,
741: p_init_msg_list => p_init_msg_list,
742: x_return_status => x_return_status,

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

745: p_stmv_rec => l_stmv_rec,
746: x_stmv_rec => lx_stmv_rec);
747:
748: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
749: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Creating Streams for SERVICE AND MAINTENANCE EVERGREEN');
750: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
751: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
752: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Creating Streams for SERVICE AND MAINTENANCE EVERGREEN');
753: RAISE Okl_Api.G_EXCEPTION_ERROR;

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

748: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
749: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Creating Streams for SERVICE AND MAINTENANCE EVERGREEN');
750: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
751: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
752: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Creating Streams for SERVICE AND MAINTENANCE EVERGREEN');
753: RAISE Okl_Api.G_EXCEPTION_ERROR;
754: END IF;
755: /*END LOOP;
756: CLOSE c_tran_num_csr;*/

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

766: FETCH c_sty_count_csr INTO l_evergreen_ept_count;
767: CLOSE c_sty_count_csr;
768:
769: IF l_evergreen_ept_count > 0 THEN
770: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ' || cns_ept_evergreen || ' Streams exist for this contract.');
771: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Proceeding to creation of stream elements.');
772: ELSE
773: l_contract_ept_count := 0;
774:

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

767: CLOSE c_sty_count_csr;
768:
769: IF l_evergreen_ept_count > 0 THEN
770: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ' || cns_ept_evergreen || ' Streams exist for this contract.');
771: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Proceeding to creation of stream elements.');
772: ELSE
773: l_contract_ept_count := 0;
774:
775: --change for User Defined Streams, by pjgomes, on 18 Oct 2004

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

799: ------------------------------------------------------
800: OPEN get_prim_sty_id_csr(l_khr_id, l_kle_id, cns_ept);
801: FETCH get_prim_sty_id_csr INTO l_primary_sty_id;
802: CLOSE get_prim_sty_id_csr;
803: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Sty id for ESTIMATED PROPERTY TAX: ' || l_primary_sty_id);
804:
805:
806: --change for User Defined Streams, by pjgomes, on 18 Oct 2004
807: OKL_STREAMS_UTIL.get_dependent_stream_type(p_khr_id => l_khr_id

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

810: ,x_return_status => l_return_status
811: ,x_dependent_sty_id => l_sty_id);
812:
813: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
814: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Obtaining sty id for: ' || cns_ept_evergreen);
815: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
816: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
817: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Obtaining sty id for: ' || cns_ept_evergreen);
818: RAISE Okl_Api.G_EXCEPTION_ERROR;

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

813: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
814: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Obtaining sty id for: ' || cns_ept_evergreen);
815: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
816: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
817: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Obtaining sty id for: ' || cns_ept_evergreen);
818: RAISE Okl_Api.G_EXCEPTION_ERROR;
819: END IF;
820:
821: OPEN c_tran_num_csr;

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

836: l_stmv_rec.active_yn := 'Y';
837: l_stmv_rec.date_current := sysdate;
838: l_stmv_rec.comments := 'Evergreen Billing';
839:
840: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Creating ESTIMATED PERSONAL PROPERTY TAX EVERGREEN Streams');
841:
842: Okl_Streams_Pub.create_streams(
843: p_api_version => p_api_version,
844: p_init_msg_list => p_init_msg_list,

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

848: p_stmv_rec => l_stmv_rec,
849: x_stmv_rec => lx_stmv_rec);
850:
851: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
852: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Creating Streams for ESTIMATED PERSONAL PROPERTY TAX EVERGREEN');
853: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
854: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
855: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Creating Streams for ESTIMATED PERSONAL PROPERTY TAX EVERGREEN');
856: RAISE Okl_Api.G_EXCEPTION_ERROR;

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

851: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
852: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Creating Streams for ESTIMATED PERSONAL PROPERTY TAX EVERGREEN');
853: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
854: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
855: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Creating Streams for ESTIMATED PERSONAL PROPERTY TAX EVERGREEN');
856: RAISE Okl_Api.G_EXCEPTION_ERROR;
857: END IF;
858: /*END LOOP;
859: CLOSE get_stm_attrs_csr;*/

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

869: FETCH c_sty_count_csr INTO l_evergreen_fee_count;
870: CLOSE c_sty_count_csr;
871:
872: IF l_evergreen_fee_count > 0 THEN
873: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ' || cns_fee_evergreen || ' Streams exist for this contract.');
874: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Proceeding to creation of stream elements.');
875: ELSE
876: l_contract_fee_count := 0;
877:

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

870: CLOSE c_sty_count_csr;
871:
872: IF l_evergreen_fee_count > 0 THEN
873: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ' || cns_fee_evergreen || ' Streams exist for this contract.');
874: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Proceeding to creation of stream elements.');
875: ELSE
876: l_contract_fee_count := 0;
877:
878: OPEN c_sty_count_csr ( l_khr_id, l_kle_id, cns_fee );

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

899: ------------------------------------------------------
900: OPEN get_prim_sty_id_csr(l_khr_id, l_kle_id, cns_fee);
901: FETCH get_prim_sty_id_csr INTO l_primary_sty_id;
902: CLOSE get_prim_sty_id_csr;
903: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Sty id for FEE: ' || l_primary_sty_id);
904:
905: --change for User Defined Streams, by pjgomes, on 18 Oct 2004
906: OKL_STREAMS_UTIL.get_dependent_stream_type(p_khr_id => l_khr_id
907: ,p_primary_sty_id => l_primary_sty_id

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

909: ,x_return_status => l_return_status
910: ,x_dependent_sty_id => l_sty_id);
911:
912: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
913: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Obtaining sty id for: ' || cns_fee_evergreen);
914: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
915: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
916: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Obtaining sty id for: ' || cns_fee_evergreen);
917: RAISE Okl_Api.G_EXCEPTION_ERROR;

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

912: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
913: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Obtaining sty id for: ' || cns_fee_evergreen);
914: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
915: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
916: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Obtaining sty id for: ' || cns_fee_evergreen);
917: RAISE Okl_Api.G_EXCEPTION_ERROR;
918: END IF;
919:
920:

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

936: l_stmv_rec.date_current := sysdate;
937: l_stmv_rec.comments := 'Evergreen Billing';
938:
939:
940: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Creating FEE EVERGREEN Streams');
941: Okl_Streams_Pub.create_streams(
942: p_api_version => p_api_version,
943: p_init_msg_list => p_init_msg_list,
944: x_return_status => x_return_status,

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

947: p_stmv_rec => l_stmv_rec,
948: x_stmv_rec => lx_stmv_rec);
949:
950: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
951: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Creating Streams for FEE EVERGREEN');
952: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
953: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
954: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Creating Streams for FEE EVERGREEN');
955: RAISE Okl_Api.G_EXCEPTION_ERROR;

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

950: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
951: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Creating Streams for FEE EVERGREEN');
952: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
953: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
954: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Creating Streams for FEE EVERGREEN');
955: RAISE Okl_Api.G_EXCEPTION_ERROR;
956: END IF;
957: /*END LOOP;
958: CLOSE c_tran_num_csr;*/

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

961: END IF;
962: END IF;
963:
964: ELSE
965: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Streams for Evergreen Billing exist for this contract.');
966: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Proceeding to creation of stream elements for Evergreen Billing.');
967: END IF;
968:
969: FOR stms IN c_stm_id( l_khr_id, l_kle_id ) LOOP

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

962: END IF;
963:
964: ELSE
965: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Streams for Evergreen Billing exist for this contract.');
966: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Proceeding to creation of stream elements for Evergreen Billing.');
967: END IF;
968:
969: FOR stms IN c_stm_id( l_khr_id, l_kle_id ) LOOP
970:

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

1011: l_evrgrn_strm_purpose := null;
1012: l_evrgrn_prim_strm_purpose := null;
1013: l_investor_agrmt_id := null;
1014:
1015: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Contract id: ' || l_khr_id || ' Line id: ' || l_kle_id);
1016: --change for User Defined Streams, by pjgomes, on 18 Oct 2004
1017: FOR cur_last_strm IN c_last_strm_csr ( l_khr_id , l_kle_id, cns_rent) LOOP
1018: ----------------------------------------------------------------
1019: --CHECK IF THE LAST RENT STREAM WAS SECURITIZED

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

1054: create_payable_flag := 'N';
1055: l_evrgrn_strm_purpose := null;
1056: l_evrgrn_prim_strm_purpose := null;
1057: l_investor_agrmt_id := null;
1058: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Contract id: ' || l_khr_id || ' Line id: ' || l_kle_id);
1059: --change for User Defined Streams, by pjgomes, on 18 Oct 2004
1060: FOR cur_last_strm IN c_last_strm_csr ( l_khr_id , l_kle_id, cns_sm) LOOP
1061: ----------------------------------------------------------------
1062: --CHECK IF THE LAST SERVICE AND MAINTENANCE STREAM WAS SECURITIZED

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

1091: OPEN bill_amt_csr ( l_khr_id , l_kle_id, cns_ept );
1092: FETCH bill_amt_csr INTO l_amount;
1093: CLOSE bill_amt_csr;
1094:
1095: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Contract id: ' || l_khr_id || ' Line id: ' || l_kle_id);
1096:
1097: create_payable_flag := 'N';
1098: l_evrgrn_strm_purpose := null;
1099: l_evrgrn_prim_strm_purpose := null;

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

1113: OPEN bill_amt_csr ( l_khr_id , l_kle_id, cns_fee );
1114: FETCH bill_amt_csr INTO l_amount;
1115: CLOSE bill_amt_csr;
1116:
1117: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Contract id: ' || l_khr_id || ' Line id: ' || l_kle_id);
1118:
1119: create_payable_flag := 'N';
1120: l_evrgrn_strm_purpose := null;
1121: l_evrgrn_prim_strm_purpose := null;

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

1165: l_billing_frequency := 1;
1166: ELSE
1167: l_error_message := 'Invalid Billing Frequency. ';
1168: l_error_status := Okl_Api.G_RET_STS_ERROR;
1169: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: '||l_error_message);
1170: END IF;
1171: IF l_billing_frequency IS NOT NULL THEN
1172: OKL_STREAM_GENERATOR_PVT.add_months_new(p_start_date => l_last_Stream_bill_date,
1173: p_months_after => l_billing_frequency,

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

1176: END IF;
1177: --dkagrawa BUG#4604842 end
1178:
1179:
1180: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' => Last Billed: '||l_last_Stream_bill_date);
1181: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' => Next Determined: '||l_Stream_bill_date);
1182:
1183: ------------------------------------------------------------
1184: -- If the program has a from and to date supplied the

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

1177: --dkagrawa BUG#4604842 end
1178:
1179:
1180: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' => Last Billed: '||l_last_Stream_bill_date);
1181: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' => Next Determined: '||l_Stream_bill_date);
1182:
1183: ------------------------------------------------------------
1184: -- If the program has a from and to date supplied the
1185: -- evergreen stream element must be between the two

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

1187: create_flag := 'Y';
1188:
1189: IF p_from_bill_date IS NOT NULL THEN
1190: IF (l_Stream_bill_date < p_from_bill_date) THEN
1191: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Bill_DATE is less than supplied From Date.');
1192: create_flag := 'N';
1193: END IF;
1194: END IF;
1195:

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

1194: END IF;
1195:
1196: IF p_to_bill_date IS NOT NULL THEN
1197: IF (l_Stream_bill_date > p_to_bill_date) THEN
1198: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Bill_DATE is greater than supplied To Date.');
1199: create_flag := 'N';
1200: END IF;
1201: END IF;
1202:

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

1211: CLOSE prev_unbilled_csr;
1212: -- CHEck if an unbilled stream element exists for the same date
1213: -- and set the create flag
1214: IF l_prev_unbilled_cnt > 0 THEN
1215: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Previously Unbilled Stream Elements Exist.');
1216: create_flag := 'N';
1217: END IF;
1218: END IF;
1219:

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

1228: CLOSE stm_rec_exists_csr;
1229: -- CHEck if an unbilled stream element exists for the same date
1230: -- and set the create flag
1231: IF l_rec_exists_cnt > 0 THEN
1232: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Duplicate Stream Element.');
1233: create_flag := 'N';
1234: END IF;
1235: END IF;
1236:

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

1267: x_selv_rec);
1268:
1269: l_sel_id := x_selv_rec.id;
1270:
1271: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' --Evergreen Stream Element id: ' || l_sel_id);
1272: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1273: l_error_message := 'Error Creating Stream Element for Contract: '
1274: ||stms.contract_number
1275: ||' Stream: '||stms.sty_name

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

1286: l_error_status := Okl_Api.G_RET_STS_ERROR;
1287: --RAISE Okl_Api.G_EXCEPTION_ERROR;
1288: ELSE
1289:
1290: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Created Evergreen Stream Element for Contract: '
1291: ||stms.contract_number
1292: ||' Stream: '||stms.sty_name
1293: ||' Bill Date: '||l_Stream_bill_date
1294: ||' Amount: '||l_amount

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

1310: -- end fmiao for bug 4961860
1311:
1312: IF(l_evrgrn_psthrgh_flg = 0) THEN
1313: -- Added by fmiao for bug 4961860
1314: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- EVERGREEN PAYABLE STREAM TYPE: ' || l_evrgrn_strm_purpose);
1315: ----------------------------------------------------------------
1316: --PROCESSING FOR EVERGREEN STREAM TYPE PAYABLE TO INVESTOR
1317: ----------------------------------------------------------------
1318: --get stream type id

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

1328: ------------------------------------------------------
1329: /*OPEN get_prim_sty_id_csr(l_khr_id, l_kle_id, l_evrgrn_prim_strm_purpose);
1330: FETCH get_prim_sty_id_csr INTO l_primary_sty_id;
1331: CLOSE get_prim_sty_id_csr;
1332: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Sty id for ' || l_evrgrn_prim_strm_purpose || ': ' || l_primary_sty_id); */
1333:
1334: --change for User Defined Streams, by pjgomes, on 18 Oct 2004
1335: OKL_STREAMS_UTIL.get_primary_stream_type(p_khr_id => l_investor_agrmt_id
1336: ,p_primary_sty_purpose => l_evrgrn_strm_purpose

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

1337: ,x_return_status => l_return_status
1338: ,x_primary_sty_id => l_sty_id);
1339:
1340: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1341: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Obtaining sty id for: ' || l_evrgrn_strm_purpose);
1342: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1343: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1344: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Obtaining sty id for: ' || l_evrgrn_strm_purpose);
1345: RAISE Okl_Api.G_EXCEPTION_ERROR;

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

1340: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1341: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Obtaining sty id for: ' || l_evrgrn_strm_purpose);
1342: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1343: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1344: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Obtaining sty id for: ' || l_evrgrn_strm_purpose);
1345: RAISE Okl_Api.G_EXCEPTION_ERROR;
1346: END IF;
1347:
1348: --check for stream

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

1378: l_stmv_rec.source_id := l_investor_agrmt_id;
1379: l_stmv_rec.source_table := 'OKL_K_HEADERS';
1380: END IF;
1381:
1382: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Creating ' || l_evrgrn_strm_purpose || ' Stream');
1383:
1384: Okl_Streams_Pub.create_streams(
1385: p_api_version => p_api_version,
1386: p_init_msg_list => p_init_msg_list,

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

1392:
1393: l_stm_id := lx_stmv_rec.id;
1394: l_se_line_number := 1;
1395:
1396: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Stream element line number => ' || l_se_line_number);
1397: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1398: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Creating Stream for ' || l_evrgrn_strm_purpose);
1399: RAISE Okl_Api.G_EXCEPTION_ERROR;
1400: ELSE

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

1394: l_se_line_number := 1;
1395:
1396: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Stream element line number => ' || l_se_line_number);
1397: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1398: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Creating Stream for ' || l_evrgrn_strm_purpose);
1399: RAISE Okl_Api.G_EXCEPTION_ERROR;
1400: ELSE
1401: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- SUCCESS: Creating Stream for ' || l_evrgrn_strm_purpose);
1402: END IF;

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

1397: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1398: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: Creating Stream for ' || l_evrgrn_strm_purpose);
1399: RAISE Okl_Api.G_EXCEPTION_ERROR;
1400: ELSE
1401: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- SUCCESS: Creating Stream for ' || l_evrgrn_strm_purpose);
1402: END IF;
1403: ELSE
1404: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Stream for ' || l_evrgrn_strm_purpose || ' found');
1405: open l_stream_line_nbr_csr(l_stm_id);

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

1400: ELSE
1401: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- SUCCESS: Creating Stream for ' || l_evrgrn_strm_purpose);
1402: END IF;
1403: ELSE
1404: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Stream for ' || l_evrgrn_strm_purpose || ' found');
1405: open l_stream_line_nbr_csr(l_stm_id);
1406: fetch l_stream_line_nbr_csr into l_se_line_number;
1407: close l_stream_line_nbr_csr;
1408: l_se_line_number := l_se_line_number + 1;

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

1405: open l_stream_line_nbr_csr(l_stm_id);
1406: fetch l_stream_line_nbr_csr into l_se_line_number;
1407: close l_stream_line_nbr_csr;
1408: l_se_line_number := l_se_line_number + 1;
1409: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Stream element line number => ' || l_se_line_number);
1410: END IF;
1411:
1412: --create stream element for evergreen stream payable
1413: IF (l_stm_id IS NOT NULL) THEN

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

1434: l_selv_rec,
1435: lx_selv_rec);
1436:
1437: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1438: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Error Creating Payable Stream Element for Contract: '
1439: || evergreen_contracts.contract_number
1440: ||' Stream: '||l_evrgrn_strm_purpose
1441: ||' Bill Date: '||l_selv_rec.STREAM_ELEMENT_DATE
1442: ||' Amount: '||l_amount);

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

1442: ||' Amount: '||l_amount);
1443: RAISE Okl_Api.G_EXCEPTION_ERROR;
1444: ELSE
1445:
1446: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Created Investor Payable Stream Element for Contract: '
1447: || evergreen_contracts.contract_number
1448: ||' Stream: '||l_evrgrn_strm_purpose
1449: ||' Bill Date: '||l_selv_rec.STREAM_ELEMENT_DATE
1450: ||' Amount: '||l_amount

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

1457: END IF;
1458: END IF;
1459:
1460: IF l_error_status <> OKL_API.G_RET_STS_SUCCESS THEN
1461: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- ERROR: '||l_error_message);
1462: END IF;
1463:
1464: END LOOP;
1465: --dkagrawa bug# 4728636 changes start

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

1479: END IF;
1480: END IF;
1481: --dkagrawa bug# 4728636 changes end
1482:
1483: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '=========================================================================================');
1484: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ******* End Evergreen Processing *******');
1485: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '=========================================================================================');
1486:
1487: ------------------------------------------------------------

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

1480: END IF;
1481: --dkagrawa bug# 4728636 changes end
1482:
1483: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '=========================================================================================');
1484: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ******* End Evergreen Processing *******');
1485: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '=========================================================================================');
1486:
1487: ------------------------------------------------------------
1488: -- End processing

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

1481: --dkagrawa bug# 4728636 changes end
1482:
1483: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '=========================================================================================');
1484: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ******* End Evergreen Processing *******');
1485: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '=========================================================================================');
1486:
1487: ------------------------------------------------------------
1488: -- End processing
1489: ------------------------------------------------------------