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 OKL_API

Line 438: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

434: ------------------------------------------------------------
435:
436: l_api_version CONSTANT NUMBER := 1;
437: l_api_name CONSTANT VARCHAR2(30) := 'BILL_EVERGREEN_STREAMS';
438: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
439:
440: -- Streams Record
441: l_stmv_rec Okl_Streams_Pub.stmv_rec_type;
442: lx_stmv_rec Okl_Streams_Pub.stmv_rec_type;

Line 469: l_error_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

465: -----------------------------------------------------
466: -- Error Processing Variables
467: -----------------------------------------------------
468: l_error_message VARCHAR2(1000);
469: l_error_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
470:
471: -- fmiao for bug 4961860
472: -- Cursor to check if the residual value exists in the pool or not
473: CURSOR check_res_in_pool(p_khr_id NUMBER) IS

Line 498: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

494: ------------------------------------------------------------
495: -- Start processing
496: ------------------------------------------------------------
497:
498: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
499:
500: l_return_status := Okl_Api.START_ACTIVITY(
501: p_api_name => l_api_name,
502: p_pkg_name => G_PKG_NAME,

Line 500: l_return_status := Okl_Api.START_ACTIVITY(

496: ------------------------------------------------------------
497:
498: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
499:
500: l_return_status := Okl_Api.START_ACTIVITY(
501: p_api_name => l_api_name,
502: p_pkg_name => G_PKG_NAME,
503: p_init_msg_list => p_init_msg_list,
504: l_api_version => l_api_version,

Line 509: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

505: p_api_version => p_api_version,
506: p_api_type => '_PVT',
507: x_return_status => l_return_status);
508:
509: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
510: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
511: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
512: RAISE Okl_Api.G_EXCEPTION_ERROR;
513: END IF;

Line 510: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

506: p_api_type => '_PVT',
507: x_return_status => l_return_status);
508:
509: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
510: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
511: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
512: RAISE Okl_Api.G_EXCEPTION_ERROR;
513: END IF;
514:

Line 511: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

507: x_return_status => l_return_status);
508:
509: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
510: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
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, '=========================================================================================');

Line 512: RAISE Okl_Api.G_EXCEPTION_ERROR;

508:
509: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
510: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
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 *******');

Line 591: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

587: ,p_dependent_sty_purpose => 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);

Line 593: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

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;
597: END IF;

Line 594: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

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;
597: END IF;
598: --OPEN get_stm_attrs_csr ( l_khr_id , 'RENT' );

Line 596: RAISE Okl_Api.G_EXCEPTION_ERROR;

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
600: -- FETCH get_stm_attrs_csr INTO l_kle_id;

Line 637: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

633: x_msg_data => x_msg_data,
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');

Line 639: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

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;
643: END IF;

Line 640: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

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;
643: END IF;
644: /*END LOOP;

Line 642: RAISE Okl_Api.G_EXCEPTION_ERROR;

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;*/
646: ELSE

Line 702: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

698: ,p_dependent_sty_purpose => 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);

Line 704: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

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;
708: END IF;

Line 705: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

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;
708: END IF;
709:

Line 707: RAISE Okl_Api.G_EXCEPTION_ERROR;

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' );
711: LOOP

Line 748: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

744: x_msg_data => x_msg_data,
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');

Line 750: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

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;
754: END IF;

Line 751: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

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;
754: END IF;
755: /*END LOOP;

Line 753: RAISE Okl_Api.G_EXCEPTION_ERROR;

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;*/
757: ELSE

Line 813: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

809: ,p_dependent_sty_purpose => 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);

Line 815: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

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;
819: END IF;

Line 816: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

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;
819: END IF;
820:

Line 818: RAISE Okl_Api.G_EXCEPTION_ERROR;

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;
822: FETCH c_tran_num_csr INTO l_stmv_rec.transaction_number;

Line 851: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

847: x_msg_data => x_msg_data,
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');

Line 853: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

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;
857: END IF;

Line 854: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

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;
857: END IF;
858: /*END LOOP;

Line 856: RAISE Okl_Api.G_EXCEPTION_ERROR;

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;*/
860: ELSE

Line 912: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

908: ,p_dependent_sty_purpose => 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);

Line 914: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

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;
918: END IF;

Line 915: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

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;
918: END IF;
919:

Line 917: RAISE Okl_Api.G_EXCEPTION_ERROR;

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:
921: OPEN c_tran_num_csr;

Line 950: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

946: x_msg_data => x_msg_data,
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');

Line 952: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

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;
956: END IF;

Line 953: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

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;
956: END IF;
957: /*END LOOP;

Line 955: RAISE Okl_Api.G_EXCEPTION_ERROR;

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;*/
959: ELSE

Line 972: l_error_status := Okl_Api.G_RET_STS_SUCCESS;

968:
969: FOR stms IN c_stm_id( l_khr_id, l_kle_id ) LOOP
970:
971: l_error_message := NULL;
972: l_error_status := Okl_Api.G_RET_STS_SUCCESS;
973:
974: -----------------------------------------
975: -- Initialize the date fields to null
976: -----------------------------------------

Line 1168: l_error_status := Okl_Api.G_RET_STS_ERROR;

1164: ELSIF l_bill_freq = 'M' THEN
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,

Line 1272: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

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
1276: ||' Bill Date: '||l_Stream_bill_date

Line 1278: l_error_status := Okl_Api.G_RET_STS_ERROR;

1274: ||stms.contract_number
1275: ||' Stream: '||stms.sty_name
1276: ||' Bill Date: '||l_Stream_bill_date
1277: ||' Amount: '||l_amount;
1278: l_error_status := Okl_Api.G_RET_STS_ERROR;
1279: --RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1280: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1281: l_error_message := 'Error Creating Stream Element for Contract: '
1282: ||stms.contract_number

Line 1279: --RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1275: ||' Stream: '||stms.sty_name
1276: ||' Bill Date: '||l_Stream_bill_date
1277: ||' Amount: '||l_amount;
1278: l_error_status := Okl_Api.G_RET_STS_ERROR;
1279: --RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1280: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1281: l_error_message := 'Error Creating Stream Element for Contract: '
1282: ||stms.contract_number
1283: ||' Stream: '||stms.sty_name

Line 1280: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1276: ||' Bill Date: '||l_Stream_bill_date
1277: ||' Amount: '||l_amount;
1278: l_error_status := Okl_Api.G_RET_STS_ERROR;
1279: --RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1280: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1281: l_error_message := 'Error Creating Stream Element for Contract: '
1282: ||stms.contract_number
1283: ||' Stream: '||stms.sty_name
1284: ||' Bill Date: '||l_Stream_bill_date

Line 1286: l_error_status := Okl_Api.G_RET_STS_ERROR;

1282: ||stms.contract_number
1283: ||' Stream: '||stms.sty_name
1284: ||' Bill Date: '||l_Stream_bill_date
1285: ||' Amount: '||l_amount;
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: '

Line 1287: --RAISE Okl_Api.G_EXCEPTION_ERROR;

1283: ||' Stream: '||stms.sty_name
1284: ||' Bill Date: '||l_Stream_bill_date
1285: ||' Amount: '||l_amount;
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

Line 1298: IF l_evrgrn_strm_purpose IS NOT NULL AND l_error_status = Okl_Api.G_RET_STS_SUCCESS THEN

1294: ||' Amount: '||l_amount
1295: );
1296: END IF;
1297:
1298: IF l_evrgrn_strm_purpose IS NOT NULL AND l_error_status = Okl_Api.G_RET_STS_SUCCESS THEN
1299:
1300: -- Added by fmiao for bug 4961860
1301: l_evrgrn_psthrgh_flg := 0;
1302: IF(l_evrgrn_strm_purpose = 'INVESTOR_EVERGREEN_RENT_PAY') THEN

Line 1340: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1336: ,p_primary_sty_purpose => 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);

Line 1342: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

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;
1346: END IF;

Line 1343: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

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;
1346: END IF;
1347:

Line 1345: RAISE Okl_Api.G_EXCEPTION_ERROR;

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
1349: l_stm_id := null;

Line 1397: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

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
1401: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- SUCCESS: Creating Stream for ' || l_evrgrn_strm_purpose);

Line 1399: RAISE Okl_Api.G_EXCEPTION_ERROR;

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;
1403: ELSE

Line 1437: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

1433: x_msg_data,
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

Line 1443: RAISE Okl_Api.G_EXCEPTION_ERROR;

1439: || evergreen_contracts.contract_number
1440: ||' Stream: '||l_evrgrn_strm_purpose
1441: ||' Bill Date: '||l_selv_rec.STREAM_ELEMENT_DATE
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

Line 1460: IF l_error_status <> OKL_API.G_RET_STS_SUCCESS THEN

1456:
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;

Line 1470: IF (l_error_status = OKL_API.G_RET_STS_SUCCESS) THEN

1466: IF l_prev_khr_id IS NULL THEN
1467: l_prev_khr_id := evergreen_contracts.khr_id;
1468: END IF;
1469: IF l_prev_khr_id <> evergreen_contracts.khr_id THEN
1470: IF (l_error_status = OKL_API.G_RET_STS_SUCCESS) THEN
1471: OKL_BILLING_CONTROLLER_PVT.track_next_bill_date ( l_prev_khr_id );
1472: END IF;
1473: l_prev_khr_id := evergreen_contracts.khr_id;
1474: END IF;

Line 1477: IF (l_error_status = OKL_API.G_RET_STS_SUCCESS) THEN

1473: l_prev_khr_id := evergreen_contracts.khr_id;
1474: END IF;
1475: END LOOP;
1476: IF l_prev_khr_id IS NOT NULL THEN
1477: IF (l_error_status = OKL_API.G_RET_STS_SUCCESS) THEN
1478: OKL_BILLING_CONTROLLER_PVT.track_next_bill_date ( l_prev_khr_id );
1479: END IF;
1480: END IF;
1481: --dkagrawa bug# 4728636 changes end

Line 1493: Okl_Api.END_ACTIVITY (

1489: ------------------------------------------------------------
1490:
1491:
1492: x_return_status := l_return_status;
1493: Okl_Api.END_ACTIVITY (
1494: x_msg_count => x_msg_count,
1495: x_msg_data => x_msg_data);
1496:
1497:

Line 1504: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

1500: ------------------------------------------------------------
1501: -- Exception handling
1502: ------------------------------------------------------------
1503:
1504: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1505:
1506: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1507: p_api_name => l_api_name,
1508: p_pkg_name => G_PKG_NAME,

Line 1506: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

1502: ------------------------------------------------------------
1503:
1504: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1505:
1506: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1507: p_api_name => l_api_name,
1508: p_pkg_name => G_PKG_NAME,
1509: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',
1510: x_msg_count => x_msg_count,

Line 1509: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',

1505:
1506: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1507: p_api_name => l_api_name,
1508: p_pkg_name => G_PKG_NAME,
1509: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',
1510: x_msg_count => x_msg_count,
1511: x_msg_data => x_msg_data,
1512: p_api_type => '_PVT');
1513:

Line 1514: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1510: x_msg_count => x_msg_count,
1511: x_msg_data => x_msg_data,
1512: p_api_type => '_PVT');
1513:
1514: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1515:
1516: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1517: p_api_name => l_api_name,
1518: p_pkg_name => G_PKG_NAME,

Line 1516: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

1512: p_api_type => '_PVT');
1513:
1514: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1515:
1516: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1517: p_api_name => l_api_name,
1518: p_pkg_name => G_PKG_NAME,
1519: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',
1520: x_msg_count => x_msg_count,

Line 1519: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',

1515:
1516: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1517: p_api_name => l_api_name,
1518: p_pkg_name => G_PKG_NAME,
1519: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',
1520: x_msg_count => x_msg_count,
1521: x_msg_data => x_msg_data,
1522: p_api_type => '_PVT');
1523:

Line 1526: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

1522: p_api_type => '_PVT');
1523:
1524: WHEN OTHERS THEN
1525:
1526: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1527: p_api_name => l_api_name,
1528: p_pkg_name => G_PKG_NAME,
1529: p_exc_name => 'OTHERS',
1530: x_msg_count => x_msg_count,