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 484: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

480: ------------------------------------------------------------
481:
482: l_api_version CONSTANT NUMBER := 1;
483: l_api_name CONSTANT VARCHAR2(30) := 'BILL_EVERGREEN_STREAMS';
484: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
485:
486: -- Streams Record
487: l_stmv_rec Okl_Streams_Pub.stmv_rec_type;
488: lx_stmv_rec Okl_Streams_Pub.stmv_rec_type;

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

511: -----------------------------------------------------
512: -- Error Processing Variables
513: -----------------------------------------------------
514: l_error_message VARCHAR2(1000);
515: l_error_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
516:
517: -- fmiao for bug 4961860
518: -- Cursor to check if the residual value exists in the pool or not
519: CURSOR check_res_in_pool(p_khr_id NUMBER) IS

Line 547: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

543: ------------------------------------------------------------
544: -- Start processing
545: ------------------------------------------------------------
546:
547: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
548:
549: l_return_status := Okl_Api.START_ACTIVITY(
550: p_api_name => l_api_name,
551: p_pkg_name => G_PKG_NAME,

Line 549: l_return_status := Okl_Api.START_ACTIVITY(

545: ------------------------------------------------------------
546:
547: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
548:
549: l_return_status := Okl_Api.START_ACTIVITY(
550: p_api_name => l_api_name,
551: p_pkg_name => G_PKG_NAME,
552: p_init_msg_list => p_init_msg_list,
553: l_api_version => l_api_version,

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

554: p_api_version => p_api_version,
555: p_api_type => '_PVT',
556: x_return_status => l_return_status);
557:
558: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
559: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
560: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
561: RAISE Okl_Api.G_EXCEPTION_ERROR;
562: END IF;

Line 559: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

555: p_api_type => '_PVT',
556: x_return_status => l_return_status);
557:
558: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
559: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
560: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
561: RAISE Okl_Api.G_EXCEPTION_ERROR;
562: END IF;
563:

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

556: x_return_status => l_return_status);
557:
558: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
559: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
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, '=========================================================================================');

Line 561: RAISE Okl_Api.G_EXCEPTION_ERROR;

557:
558: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
559: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
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 *******');

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

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

Line 665: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

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

Line 668: RAISE Okl_Api.G_EXCEPTION_ERROR;

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

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

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

Line 711: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

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;
715: END IF;
716: /*END LOOP;

Line 714: RAISE Okl_Api.G_EXCEPTION_ERROR;

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

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

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

Line 776: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

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

Line 779: RAISE Okl_Api.G_EXCEPTION_ERROR;

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

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

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

Line 822: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

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;
826: END IF;
827: /*END LOOP;

Line 825: RAISE Okl_Api.G_EXCEPTION_ERROR;

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

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

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

Line 887: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

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

Line 890: RAISE Okl_Api.G_EXCEPTION_ERROR;

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

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

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

Line 925: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

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;
929: END IF;
930: /*END LOOP;

Line 928: RAISE Okl_Api.G_EXCEPTION_ERROR;

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

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

958: p_chr_id => l_khr_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);

Line 964: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

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

Line 967: RAISE Okl_Api.G_EXCEPTION_ERROR;

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
971:

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

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

Line 1002: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

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

Line 1005: RAISE Okl_Api.G_EXCEPTION_ERROR;

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

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

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

Line 1040: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

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;
1044: END IF;
1045: /*END LOOP;

Line 1043: RAISE Okl_Api.G_EXCEPTION_ERROR;

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;*/
1047: -- Bug# 11787205: start

Line 1063: l_error_status := Okl_Api.G_RET_STS_SUCCESS;

1059:
1060: FOR stms IN c_stm_id( l_khr_id, l_kle_id ) LOOP
1061:
1062: l_error_message := NULL;
1063: l_error_status := Okl_Api.G_RET_STS_SUCCESS;
1064:
1065: -----------------------------------------
1066: -- Initialize the date fields to null
1067: -----------------------------------------

Line 1259: l_error_status := Okl_Api.G_RET_STS_ERROR;

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

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

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

Line 1369: l_error_status := Okl_Api.G_RET_STS_ERROR;

1365: ||stms.contract_number
1366: ||' Stream: '||stms.sty_name
1367: ||' Bill Date: '||l_Stream_bill_date
1368: ||' Amount: '||l_amount;
1369: l_error_status := Okl_Api.G_RET_STS_ERROR;
1370: --RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1371: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1372: l_error_message := 'Error Creating Stream Element for Contract: '
1373: ||stms.contract_number

Line 1370: --RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1366: ||' Stream: '||stms.sty_name
1367: ||' Bill Date: '||l_Stream_bill_date
1368: ||' Amount: '||l_amount;
1369: l_error_status := Okl_Api.G_RET_STS_ERROR;
1370: --RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1371: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1372: l_error_message := 'Error Creating Stream Element for Contract: '
1373: ||stms.contract_number
1374: ||' Stream: '||stms.sty_name

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

1367: ||' Bill Date: '||l_Stream_bill_date
1368: ||' Amount: '||l_amount;
1369: l_error_status := Okl_Api.G_RET_STS_ERROR;
1370: --RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1371: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1372: l_error_message := 'Error Creating Stream Element for Contract: '
1373: ||stms.contract_number
1374: ||' Stream: '||stms.sty_name
1375: ||' Bill Date: '||l_Stream_bill_date

Line 1377: l_error_status := Okl_Api.G_RET_STS_ERROR;

1373: ||stms.contract_number
1374: ||' Stream: '||stms.sty_name
1375: ||' Bill Date: '||l_Stream_bill_date
1376: ||' Amount: '||l_amount;
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: '

Line 1378: --RAISE Okl_Api.G_EXCEPTION_ERROR;

1374: ||' Stream: '||stms.sty_name
1375: ||' Bill Date: '||l_Stream_bill_date
1376: ||' Amount: '||l_amount;
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

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

1385: ||' Amount: '||l_amount
1386: );
1387: END IF;
1388:
1389: IF l_evrgrn_strm_purpose IS NOT NULL AND l_error_status = Okl_Api.G_RET_STS_SUCCESS THEN
1390:
1391: -- Added by fmiao for bug 4961860
1392: l_evrgrn_psthrgh_flg := 0;
1393: IF(l_evrgrn_strm_purpose = 'INVESTOR_EVERGREEN_RENT_PAY') THEN

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

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

Line 1433: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

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

Line 1436: RAISE Okl_Api.G_EXCEPTION_ERROR;

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

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

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

Line 1490: RAISE Okl_Api.G_EXCEPTION_ERROR;

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

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

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

Line 1534: RAISE Okl_Api.G_EXCEPTION_ERROR;

1530: || evergreen_contracts.contract_number
1531: ||' Stream: '||l_evrgrn_strm_purpose
1532: ||' Bill Date: '||l_selv_rec.STREAM_ELEMENT_DATE
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

Line 1551: IF l_error_status <> OKL_API.G_RET_STS_SUCCESS THEN

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

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

1557: IF l_prev_khr_id IS NULL THEN
1558: l_prev_khr_id := evergreen_contracts.khr_id;
1559: END IF;
1560: IF l_prev_khr_id <> evergreen_contracts.khr_id THEN
1561: IF (l_error_status = OKL_API.G_RET_STS_SUCCESS) THEN
1562: OKL_BILLING_CONTROLLER_PVT.track_next_bill_date ( l_prev_khr_id );
1563: END IF;
1564: l_prev_khr_id := evergreen_contracts.khr_id;
1565: END IF;

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

1564: l_prev_khr_id := evergreen_contracts.khr_id;
1565: END IF;
1566: END LOOP;
1567: IF l_prev_khr_id IS NOT NULL THEN
1568: IF (l_error_status = OKL_API.G_RET_STS_SUCCESS) THEN
1569: OKL_BILLING_CONTROLLER_PVT.track_next_bill_date ( l_prev_khr_id );
1570: END IF;
1571: END IF;
1572: --dkagrawa bug# 4728636 changes end

Line 1589: Okl_Api.END_ACTIVITY (

1585: ------------------------------------------------------------
1586:
1587:
1588: x_return_status := l_return_status;
1589: Okl_Api.END_ACTIVITY (
1590: x_msg_count => x_msg_count,
1591: x_msg_data => x_msg_data);
1592:
1593:

Line 1600: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

1596: ------------------------------------------------------------
1597: -- Exception handling
1598: ------------------------------------------------------------
1599:
1600: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1601:
1602: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1603: p_api_name => l_api_name,
1604: p_pkg_name => G_PKG_NAME,

Line 1602: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

1598: ------------------------------------------------------------
1599:
1600: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1601:
1602: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1603: p_api_name => l_api_name,
1604: p_pkg_name => G_PKG_NAME,
1605: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',
1606: x_msg_count => x_msg_count,

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

1601:
1602: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1603: p_api_name => l_api_name,
1604: p_pkg_name => G_PKG_NAME,
1605: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',
1606: x_msg_count => x_msg_count,
1607: x_msg_data => x_msg_data,
1608: p_api_type => '_PVT');
1609:

Line 1610: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1606: x_msg_count => x_msg_count,
1607: x_msg_data => x_msg_data,
1608: p_api_type => '_PVT');
1609:
1610: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1611:
1612: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1613: p_api_name => l_api_name,
1614: p_pkg_name => G_PKG_NAME,

Line 1612: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

1608: p_api_type => '_PVT');
1609:
1610: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1611:
1612: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1613: p_api_name => l_api_name,
1614: p_pkg_name => G_PKG_NAME,
1615: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',
1616: x_msg_count => x_msg_count,

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

1611:
1612: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1613: p_api_name => l_api_name,
1614: p_pkg_name => G_PKG_NAME,
1615: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',
1616: x_msg_count => x_msg_count,
1617: x_msg_data => x_msg_data,
1618: p_api_type => '_PVT');
1619:

Line 1622: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

1618: p_api_type => '_PVT');
1619:
1620: WHEN OTHERS THEN
1621:
1622: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1623: p_api_name => l_api_name,
1624: p_pkg_name => G_PKG_NAME,
1625: p_exc_name => 'OTHERS',
1626: x_msg_count => x_msg_count,

Line 1804: l_app_name CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;

1800: l_calling_module varchar2(15);
1801: l_generate_streams varchar2(1);
1802: l_return_status varchar2(1);
1803: l_evergreen_eligible VARCHAR2(1);
1804: l_app_name CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
1805:
1806: BEGIN
1807:
1808: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 1808: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

1804: l_app_name CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
1805:
1806: BEGIN
1807:
1808: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1809:
1810: if p_kle_id is null then
1811: l_calling_module := 'QA CHECKER';
1812: else

Line 1916: OKL_API.set_message(

1912: l_found := 'Y';
1913: l_found_fee := t_fee_name_tbl(i);
1914: if l_calling_module = 'QA CHECKER' then
1915: -- set error message here for QA checker
1916: OKL_API.set_message(
1917: p_app_name => L_APP_NAME,
1918: p_msg_name => 'OKL_QA_EVERGREEN_STRM_WRN',
1919: p_token1 => 'FEE_LINE_NAME',
1920: p_token1_value => l_found_fee);

Line 1921: x_return_status := OKL_API.G_RET_STS_ERROR;

1917: p_app_name => L_APP_NAME,
1918: p_msg_name => 'OKL_QA_EVERGREEN_STRM_WRN',
1919: p_token1 => 'FEE_LINE_NAME',
1920: p_token1_value => l_found_fee);
1921: x_return_status := OKL_API.G_RET_STS_ERROR;
1922: /*else
1923: exit;*/ -- bug 13627069
1924: end if;
1925: exit; -- bug 13627069

Line 1942: --x_return_status := Okl_Api.G_RET_STS_SUCCESS;

1938: t_fee_end_date_tbl.delete;
1939:
1940: end if; --> if contract is eligible for evergreen}
1941:
1942: --x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1943:
1944: EXCEPTION
1945: WHEN OTHERS THEN
1946: -- store SQL error message on message stack

Line 1947: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (

1943:
1944: EXCEPTION
1945: WHEN OTHERS THEN
1946: -- store SQL error message on message stack
1947: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1948: p_api_name => l_api_name,
1949: p_pkg_name => G_PKG_NAME,
1950: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',
1951: x_msg_count => x_msg_count,

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

1946: -- store SQL error message on message stack
1947: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1948: p_api_name => l_api_name,
1949: p_pkg_name => G_PKG_NAME,
1950: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',
1951: x_msg_count => x_msg_count,
1952: x_msg_data => x_msg_data,
1953: p_api_type => '_PVT');
1954: