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_LLA_UTIL_PVT dependencies on OKL_API

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

7: G_EXCEPTION_STOP_VALIDATION EXCEPTION;
8:
9:
10: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_LLA_UTIL_PVT';
11: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
12: G_API_TYPE CONSTANT VARCHAR2(4) := '_PVT';
13: l_api_name VARCHAR2(35) := 'LLA_UTIL';
14:
15: FUNCTION get_number

Line 108: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

104: x_amount := OKL_ACCOUNTING_UTIL.cc_round_format_amount(p_amount => TO_NUMBER(get_number(p_amount)),
105: p_currency_code => p_currency_code);
106:
107:
108: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
109: x_msg_data => x_msg_data);
110:
111: EXCEPTION
112: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 184: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

180: x_amount := OKL_ACCOUNTING_UTIL.cc_round_format_amount(p_amount => TO_NUMBER(get_number(p_amount)),
181: p_currency_code => p_currency_code);
182:
183:
184: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
185: x_msg_data => x_msg_data);
186:
187: EXCEPTION
188: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 260: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

256: p_amount => TO_NUMBER(get_number(p_amount)),
257: p_currency_code => p_currency_code);
258:
259:
260: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
261: x_msg_data => x_msg_data);
262:
263: EXCEPTION
264: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 337: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

333: p_amount => TO_NUMBER(get_number(p_amount)),
334: p_currency_code => p_currency_code);
335:
336:
337: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
338: x_msg_data => x_msg_data);
339:
340: EXCEPTION
341: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 429: RETURN(OKL_API.G_FALSE);

425: END IF;
426: RETURN p_date_out;
427: EXCEPTION
428: WHEN OTHERS THEN
429: RETURN(OKL_API.G_FALSE);
430: END;
431:
432:
433: FUNCTION get_display_date

Line 525: l_ret_value VARCHAR2(1) := OKL_API.G_FALSE;

521: WHERE rbk_khr.khr_id = chrb.id
522: AND rbk_khr.status <> 'PROCESSED');
523:
524:
525: l_ret_value VARCHAR2(1) := OKL_API.G_FALSE;
526:
527: BEGIN
528:
529: FOR l_chk_mass_rbk_rec IN l_chk_mass_rbk_csr

Line 531: l_ret_value := OKL_API.G_TRUE;

527: BEGIN
528:
529: FOR l_chk_mass_rbk_rec IN l_chk_mass_rbk_csr
530: LOOP
531: l_ret_value := OKL_API.G_TRUE;
532: EXIT WHEN l_ret_value = OKL_API.G_TRUE;
533: END LOOP;
534:
535: RETURN l_ret_value;

Line 532: EXIT WHEN l_ret_value = OKL_API.G_TRUE;

528:
529: FOR l_chk_mass_rbk_rec IN l_chk_mass_rbk_csr
530: LOOP
531: l_ret_value := OKL_API.G_TRUE;
532: EXIT WHEN l_ret_value = OKL_API.G_TRUE;
533: END LOOP;
534:
535: RETURN l_ret_value;
536:

Line 563: l_ret_value VARCHAR2(1) := OKL_API.G_FALSE;

559: --
560: AND chrb.id = p_chr_id
561: AND chrb.orig_system_source_codE = 'OKL_REBOOK';
562:
563: l_ret_value VARCHAR2(1) := OKL_API.G_FALSE;
564:
565: BEGIN
566:
567: FOR l_chk_rbk_rec IN l_chk_rbk_csr

Line 569: l_ret_value := OKL_API.G_TRUE;

565: BEGIN
566:
567: FOR l_chk_rbk_rec IN l_chk_rbk_csr
568: LOOP
569: l_ret_value := OKL_API.G_TRUE;
570: EXIT WHEN l_ret_value = OKL_API.G_TRUE;
571: END LOOP;
572:
573: RETURN l_ret_value;

Line 570: EXIT WHEN l_ret_value = OKL_API.G_TRUE;

566:
567: FOR l_chk_rbk_rec IN l_chk_rbk_csr
568: LOOP
569: l_ret_value := OKL_API.G_TRUE;
570: EXIT WHEN l_ret_value = OKL_API.G_TRUE;
571: END LOOP;
572:
573: RETURN l_ret_value;
574:

Line 593: l_ret_value VARCHAR2(1) := OKL_API.G_FALSE;

589: FROM okc_k_headers_b chrb
590: WHERE chrb.id = p_chr_id
591: AND NVL(chrb.orig_system_source_code,'XXXX') = 'OKL_RELEASE';
592:
593: l_ret_value VARCHAR2(1) := OKL_API.G_FALSE;
594:
595: BEGIN
596:
597: FOR l_chk_rel_khr_rec IN l_chk_rel_khr_csr

Line 599: l_ret_value := OKL_API.G_TRUE;

595: BEGIN
596:
597: FOR l_chk_rel_khr_rec IN l_chk_rel_khr_csr
598: LOOP
599: l_ret_value := OKL_API.G_TRUE;
600: EXIT WHEN l_ret_value = OKL_API.G_TRUE;
601: END LOOP;
602:
603: RETURN l_ret_value;

Line 600: EXIT WHEN l_ret_value = OKL_API.G_TRUE;

596:
597: FOR l_chk_rel_khr_rec IN l_chk_rel_khr_csr
598: LOOP
599: l_ret_value := OKL_API.G_TRUE;
600: EXIT WHEN l_ret_value = OKL_API.G_TRUE;
601: END LOOP;
602:
603: RETURN l_ret_value;
604:

Line 628: l_ret_value VARCHAR2(1) := OKL_API.G_FALSE;

624: AND rul.rule_information_category = 'LARLES'
625: AND NVL(rule_information1,'N') = 'Y');
626:
627:
628: l_ret_value VARCHAR2(1) := OKL_API.G_FALSE;
629:
630: BEGIN
631:
632: FOR l_chk_rel_ast_rec IN l_chk_rel_ast_csr

Line 634: l_ret_value := OKL_API.G_TRUE;

630: BEGIN
631:
632: FOR l_chk_rel_ast_rec IN l_chk_rel_ast_csr
633: LOOP
634: l_ret_value := OKL_API.G_TRUE;
635: EXIT WHEN l_ret_value = OKL_API.G_TRUE;
636: END LOOP;
637:
638: RETURN l_ret_value;

Line 635: EXIT WHEN l_ret_value = OKL_API.G_TRUE;

631:
632: FOR l_chk_rel_ast_rec IN l_chk_rel_ast_csr
633: LOOP
634: l_ret_value := OKL_API.G_TRUE;
635: EXIT WHEN l_ret_value = OKL_API.G_TRUE;
636: END LOOP;
637:
638: RETURN l_ret_value;
639:

Line 652: RETURN OKL_API.G_FALSE;

648: AS
649: l_ret_value VARCHAR2(1) DEFAULT '0';
650: BEGIN
651: -- NEED TO CODE LATER ??
652: RETURN OKL_API.G_FALSE;
653: EXCEPTION
654: WHEN OTHERS THEN
655: RETURN(NULL);
656: END check_split_contract;

Line 666: IF (l_ret_value IS NOT NULL) AND (l_ret_value = OKL_API.G_TRUE) THEN

662: l_ret_value VARCHAR2(1) DEFAULT '0';
663: BEGIN
664:
665: l_ret_value := check_mass_rebook_contract(p_chr_id);
666: IF (l_ret_value IS NOT NULL) AND (l_ret_value = OKL_API.G_TRUE) THEN
667: RETURN OKL_API.G_FALSE;
668: -- not a mass rebook
669: ELSIF (l_ret_value=OKL_API.G_FALSE) THEN
670: l_ret_value := check_rebook_contract(p_chr_id);

Line 667: RETURN OKL_API.G_FALSE;

663: BEGIN
664:
665: l_ret_value := check_mass_rebook_contract(p_chr_id);
666: IF (l_ret_value IS NOT NULL) AND (l_ret_value = OKL_API.G_TRUE) THEN
667: RETURN OKL_API.G_FALSE;
668: -- not a mass rebook
669: ELSIF (l_ret_value=OKL_API.G_FALSE) THEN
670: l_ret_value := check_rebook_contract(p_chr_id);
671: IF (l_ret_value IS NOT NULL) AND (l_ret_value = OKL_API.G_TRUE) THEN

Line 669: ELSIF (l_ret_value=OKL_API.G_FALSE) THEN

665: l_ret_value := check_mass_rebook_contract(p_chr_id);
666: IF (l_ret_value IS NOT NULL) AND (l_ret_value = OKL_API.G_TRUE) THEN
667: RETURN OKL_API.G_FALSE;
668: -- not a mass rebook
669: ELSIF (l_ret_value=OKL_API.G_FALSE) THEN
670: l_ret_value := check_rebook_contract(p_chr_id);
671: IF (l_ret_value IS NOT NULL) AND (l_ret_value = OKL_API.G_TRUE) THEN
672: RETURN OKL_API.G_FALSE;
673: -- not a rebook

Line 671: IF (l_ret_value IS NOT NULL) AND (l_ret_value = OKL_API.G_TRUE) THEN

667: RETURN OKL_API.G_FALSE;
668: -- not a mass rebook
669: ELSIF (l_ret_value=OKL_API.G_FALSE) THEN
670: l_ret_value := check_rebook_contract(p_chr_id);
671: IF (l_ret_value IS NOT NULL) AND (l_ret_value = OKL_API.G_TRUE) THEN
672: RETURN OKL_API.G_FALSE;
673: -- not a rebook
674: ELSIF (l_ret_value=OKL_API.G_FALSE) THEN
675: l_ret_value := check_release_contract(p_chr_id);

Line 672: RETURN OKL_API.G_FALSE;

668: -- not a mass rebook
669: ELSIF (l_ret_value=OKL_API.G_FALSE) THEN
670: l_ret_value := check_rebook_contract(p_chr_id);
671: IF (l_ret_value IS NOT NULL) AND (l_ret_value = OKL_API.G_TRUE) THEN
672: RETURN OKL_API.G_FALSE;
673: -- not a rebook
674: ELSIF (l_ret_value=OKL_API.G_FALSE) THEN
675: l_ret_value := check_release_contract(p_chr_id);
676: IF (l_ret_value IS NOT NULL) AND (l_ret_value = OKL_API.G_TRUE) THEN

Line 674: ELSIF (l_ret_value=OKL_API.G_FALSE) THEN

670: l_ret_value := check_rebook_contract(p_chr_id);
671: IF (l_ret_value IS NOT NULL) AND (l_ret_value = OKL_API.G_TRUE) THEN
672: RETURN OKL_API.G_FALSE;
673: -- not a rebook
674: ELSIF (l_ret_value=OKL_API.G_FALSE) THEN
675: l_ret_value := check_release_contract(p_chr_id);
676: IF (l_ret_value IS NOT NULL) AND (l_ret_value = OKL_API.G_TRUE) THEN
677: RETURN OKL_API.G_FALSE;
678: -- not a release contract

Line 676: IF (l_ret_value IS NOT NULL) AND (l_ret_value = OKL_API.G_TRUE) THEN

672: RETURN OKL_API.G_FALSE;
673: -- not a rebook
674: ELSIF (l_ret_value=OKL_API.G_FALSE) THEN
675: l_ret_value := check_release_contract(p_chr_id);
676: IF (l_ret_value IS NOT NULL) AND (l_ret_value = OKL_API.G_TRUE) THEN
677: RETURN OKL_API.G_FALSE;
678: -- not a release contract
679: ELSIF (l_ret_value=OKL_API.G_FALSE) THEN
680: l_ret_value := check_release_assets(p_chr_id);

Line 677: RETURN OKL_API.G_FALSE;

673: -- not a rebook
674: ELSIF (l_ret_value=OKL_API.G_FALSE) THEN
675: l_ret_value := check_release_contract(p_chr_id);
676: IF (l_ret_value IS NOT NULL) AND (l_ret_value = OKL_API.G_TRUE) THEN
677: RETURN OKL_API.G_FALSE;
678: -- not a release contract
679: ELSIF (l_ret_value=OKL_API.G_FALSE) THEN
680: l_ret_value := check_release_assets(p_chr_id);
681: IF (l_ret_value IS NOT NULL) AND (l_ret_value = OKL_API.G_TRUE) THEN

Line 679: ELSIF (l_ret_value=OKL_API.G_FALSE) THEN

675: l_ret_value := check_release_contract(p_chr_id);
676: IF (l_ret_value IS NOT NULL) AND (l_ret_value = OKL_API.G_TRUE) THEN
677: RETURN OKL_API.G_FALSE;
678: -- not a release contract
679: ELSIF (l_ret_value=OKL_API.G_FALSE) THEN
680: l_ret_value := check_release_assets(p_chr_id);
681: IF (l_ret_value IS NOT NULL) AND (l_ret_value = OKL_API.G_TRUE) THEN
682: RETURN OKL_API.G_FALSE;
683: ELSIF (l_ret_value=OKL_API.G_FALSE) THEN

Line 681: IF (l_ret_value IS NOT NULL) AND (l_ret_value = OKL_API.G_TRUE) THEN

677: RETURN OKL_API.G_FALSE;
678: -- not a release contract
679: ELSIF (l_ret_value=OKL_API.G_FALSE) THEN
680: l_ret_value := check_release_assets(p_chr_id);
681: IF (l_ret_value IS NOT NULL) AND (l_ret_value = OKL_API.G_TRUE) THEN
682: RETURN OKL_API.G_FALSE;
683: ELSIF (l_ret_value=OKL_API.G_FALSE) THEN
684: l_ret_value := check_split_contract(p_chr_id);
685: IF (l_ret_value IS NOT NULL) AND (l_ret_value = OKL_API.G_TRUE) THEN

Line 682: RETURN OKL_API.G_FALSE;

678: -- not a release contract
679: ELSIF (l_ret_value=OKL_API.G_FALSE) THEN
680: l_ret_value := check_release_assets(p_chr_id);
681: IF (l_ret_value IS NOT NULL) AND (l_ret_value = OKL_API.G_TRUE) THEN
682: RETURN OKL_API.G_FALSE;
683: ELSIF (l_ret_value=OKL_API.G_FALSE) THEN
684: l_ret_value := check_split_contract(p_chr_id);
685: IF (l_ret_value IS NOT NULL) AND (l_ret_value = OKL_API.G_TRUE) THEN
686: RETURN OKL_API.G_FALSE;

Line 683: ELSIF (l_ret_value=OKL_API.G_FALSE) THEN

679: ELSIF (l_ret_value=OKL_API.G_FALSE) THEN
680: l_ret_value := check_release_assets(p_chr_id);
681: IF (l_ret_value IS NOT NULL) AND (l_ret_value = OKL_API.G_TRUE) THEN
682: RETURN OKL_API.G_FALSE;
683: ELSIF (l_ret_value=OKL_API.G_FALSE) THEN
684: l_ret_value := check_split_contract(p_chr_id);
685: IF (l_ret_value IS NOT NULL) AND (l_ret_value = OKL_API.G_TRUE) THEN
686: RETURN OKL_API.G_FALSE;
687: ELSE

Line 685: IF (l_ret_value IS NOT NULL) AND (l_ret_value = OKL_API.G_TRUE) THEN

681: IF (l_ret_value IS NOT NULL) AND (l_ret_value = OKL_API.G_TRUE) THEN
682: RETURN OKL_API.G_FALSE;
683: ELSIF (l_ret_value=OKL_API.G_FALSE) THEN
684: l_ret_value := check_split_contract(p_chr_id);
685: IF (l_ret_value IS NOT NULL) AND (l_ret_value = OKL_API.G_TRUE) THEN
686: RETURN OKL_API.G_FALSE;
687: ELSE
688: -- not a release asset contract
689: RETURN OKL_API.G_TRUE;

Line 686: RETURN OKL_API.G_FALSE;

682: RETURN OKL_API.G_FALSE;
683: ELSIF (l_ret_value=OKL_API.G_FALSE) THEN
684: l_ret_value := check_split_contract(p_chr_id);
685: IF (l_ret_value IS NOT NULL) AND (l_ret_value = OKL_API.G_TRUE) THEN
686: RETURN OKL_API.G_FALSE;
687: ELSE
688: -- not a release asset contract
689: RETURN OKL_API.G_TRUE;
690: END IF;

Line 689: RETURN OKL_API.G_TRUE;

685: IF (l_ret_value IS NOT NULL) AND (l_ret_value = OKL_API.G_TRUE) THEN
686: RETURN OKL_API.G_FALSE;
687: ELSE
688: -- not a release asset contract
689: RETURN OKL_API.G_TRUE;
690: END IF;
691: END IF;
692: END IF;
693: END IF;

Line 711: IF (l_ret_value IS NOT NULL) AND (l_ret_value = OKL_API.G_TRUE) THEN

707:
708: BEGIN
709:
710: l_ret_value := check_mass_rebook_contract(p_chr_id);
711: IF (l_ret_value IS NOT NULL) AND (l_ret_value = OKL_API.G_TRUE) THEN
712: RETURN G_KHR_PROCESS_MASS_REBOOK;
713: -- not a mass rebook
714: ELSIF (l_ret_value=OKL_API.G_FALSE) THEN
715: l_ret_value := check_rebook_contract(p_chr_id);

Line 714: ELSIF (l_ret_value=OKL_API.G_FALSE) THEN

710: l_ret_value := check_mass_rebook_contract(p_chr_id);
711: IF (l_ret_value IS NOT NULL) AND (l_ret_value = OKL_API.G_TRUE) THEN
712: RETURN G_KHR_PROCESS_MASS_REBOOK;
713: -- not a mass rebook
714: ELSIF (l_ret_value=OKL_API.G_FALSE) THEN
715: l_ret_value := check_rebook_contract(p_chr_id);
716: IF (l_ret_value IS NOT NULL) AND (l_ret_value = OKL_API.G_TRUE) THEN
717: RETURN G_KHR_PROCESS_REBOOK;
718: -- not a rebook

Line 716: IF (l_ret_value IS NOT NULL) AND (l_ret_value = OKL_API.G_TRUE) THEN

712: RETURN G_KHR_PROCESS_MASS_REBOOK;
713: -- not a mass rebook
714: ELSIF (l_ret_value=OKL_API.G_FALSE) THEN
715: l_ret_value := check_rebook_contract(p_chr_id);
716: IF (l_ret_value IS NOT NULL) AND (l_ret_value = OKL_API.G_TRUE) THEN
717: RETURN G_KHR_PROCESS_REBOOK;
718: -- not a rebook
719: ELSIF (l_ret_value=OKL_API.G_FALSE) THEN
720: l_ret_value := check_release_contract(p_chr_id);

Line 719: ELSIF (l_ret_value=OKL_API.G_FALSE) THEN

715: l_ret_value := check_rebook_contract(p_chr_id);
716: IF (l_ret_value IS NOT NULL) AND (l_ret_value = OKL_API.G_TRUE) THEN
717: RETURN G_KHR_PROCESS_REBOOK;
718: -- not a rebook
719: ELSIF (l_ret_value=OKL_API.G_FALSE) THEN
720: l_ret_value := check_release_contract(p_chr_id);
721: IF (l_ret_value IS NOT NULL) AND (l_ret_value = OKL_API.G_TRUE) THEN
722: RETURN G_KHR_PROCESS_RELEASE_CONTRACT;
723: -- not a release contract

Line 721: IF (l_ret_value IS NOT NULL) AND (l_ret_value = OKL_API.G_TRUE) THEN

717: RETURN G_KHR_PROCESS_REBOOK;
718: -- not a rebook
719: ELSIF (l_ret_value=OKL_API.G_FALSE) THEN
720: l_ret_value := check_release_contract(p_chr_id);
721: IF (l_ret_value IS NOT NULL) AND (l_ret_value = OKL_API.G_TRUE) THEN
722: RETURN G_KHR_PROCESS_RELEASE_CONTRACT;
723: -- not a release contract
724: ELSIF (l_ret_value=OKL_API.G_FALSE) THEN
725: l_ret_value := check_release_assets(p_chr_id);

Line 724: ELSIF (l_ret_value=OKL_API.G_FALSE) THEN

720: l_ret_value := check_release_contract(p_chr_id);
721: IF (l_ret_value IS NOT NULL) AND (l_ret_value = OKL_API.G_TRUE) THEN
722: RETURN G_KHR_PROCESS_RELEASE_CONTRACT;
723: -- not a release contract
724: ELSIF (l_ret_value=OKL_API.G_FALSE) THEN
725: l_ret_value := check_release_assets(p_chr_id);
726: IF (l_ret_value IS NOT NULL) AND (l_ret_value = OKL_API.G_TRUE) THEN
727: RETURN G_KHR_PROCESS_RELEASE_ASSETS;
728: ELSIF (l_ret_value=OKL_API.G_FALSE) THEN

Line 726: IF (l_ret_value IS NOT NULL) AND (l_ret_value = OKL_API.G_TRUE) THEN

722: RETURN G_KHR_PROCESS_RELEASE_CONTRACT;
723: -- not a release contract
724: ELSIF (l_ret_value=OKL_API.G_FALSE) THEN
725: l_ret_value := check_release_assets(p_chr_id);
726: IF (l_ret_value IS NOT NULL) AND (l_ret_value = OKL_API.G_TRUE) THEN
727: RETURN G_KHR_PROCESS_RELEASE_ASSETS;
728: ELSIF (l_ret_value=OKL_API.G_FALSE) THEN
729: l_ret_value := check_split_contract(p_chr_id);
730: IF (l_ret_value IS NOT NULL) AND (l_ret_value = OKL_API.G_TRUE) THEN

Line 728: ELSIF (l_ret_value=OKL_API.G_FALSE) THEN

724: ELSIF (l_ret_value=OKL_API.G_FALSE) THEN
725: l_ret_value := check_release_assets(p_chr_id);
726: IF (l_ret_value IS NOT NULL) AND (l_ret_value = OKL_API.G_TRUE) THEN
727: RETURN G_KHR_PROCESS_RELEASE_ASSETS;
728: ELSIF (l_ret_value=OKL_API.G_FALSE) THEN
729: l_ret_value := check_split_contract(p_chr_id);
730: IF (l_ret_value IS NOT NULL) AND (l_ret_value = OKL_API.G_TRUE) THEN
731: RETURN G_KHR_PROCESS_SPLIT_CONTRACT;
732: ELSE

Line 730: IF (l_ret_value IS NOT NULL) AND (l_ret_value = OKL_API.G_TRUE) THEN

726: IF (l_ret_value IS NOT NULL) AND (l_ret_value = OKL_API.G_TRUE) THEN
727: RETURN G_KHR_PROCESS_RELEASE_ASSETS;
728: ELSIF (l_ret_value=OKL_API.G_FALSE) THEN
729: l_ret_value := check_split_contract(p_chr_id);
730: IF (l_ret_value IS NOT NULL) AND (l_ret_value = OKL_API.G_TRUE) THEN
731: RETURN G_KHR_PROCESS_SPLIT_CONTRACT;
732: ELSE
733: -- not a release asset contract
734: RETURN G_KHR_PROCESS_NEW;

Line 757: l_return_value VARCHAR2(1):= OKL_API.G_FALSE;

753: FROM okc_k_headers_b
754: WHERE id = p_chr_id;
755:
756: l_scs_code okc_k_headers_b.scs_code%TYPE := NULL;
757: l_return_value VARCHAR2(1):= OKL_API.G_FALSE;
758: BEGIN
759: FOR l_okl_chr_scs_rec IN l_okl_chr_scs_csr
760: LOOP
761: IF (l_okl_chr_scs_rec.scs_code IS NOT NULL AND l_okl_chr_scs_rec.scs_code = 'LEASE') THEN

Line 762: l_return_value := OKL_API.G_TRUE;

758: BEGIN
759: FOR l_okl_chr_scs_rec IN l_okl_chr_scs_csr
760: LOOP
761: IF (l_okl_chr_scs_rec.scs_code IS NOT NULL AND l_okl_chr_scs_rec.scs_code = 'LEASE') THEN
762: l_return_value := OKL_API.G_TRUE;
763: END IF;
764: END LOOP;
765:
766: RETURN l_return_value;

Line 822: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

818: p_months_after => p_months,
819: x_date => l_end_date,
820: x_return_status => l_return_status);
821:
822: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
823: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
824: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
825: RAISE OKL_API.G_EXCEPTION_ERROR;
826: END IF;

Line 823: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

819: x_date => l_end_date,
820: x_return_status => l_return_status);
821:
822: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
823: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
824: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
825: RAISE OKL_API.G_EXCEPTION_ERROR;
826: END IF;
827: --end Bug 6007644

Line 824: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

820: x_return_status => l_return_status);
821:
822: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
823: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
824: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
825: RAISE OKL_API.G_EXCEPTION_ERROR;
826: END IF;
827: --end Bug 6007644
828:

Line 825: RAISE OKL_API.G_EXCEPTION_ERROR;

821:
822: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
823: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
824: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
825: RAISE OKL_API.G_EXCEPTION_ERROR;
826: END IF;
827: --end Bug 6007644
828:
829: IF p_start_day IS NOT NULL THEN

Line 878: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

874: x_msg_count OUT NOCOPY NUMBER,
875: x_msg_data OUT NOCOPY VARCHAR2,
876: p_cle_id IN NUMBER) IS
877:
878: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
879: l_api_name CONSTANT VARCHAR2(30) := 'CHECK_LINE_UPDATE_ALLOWED';
880: l_api_version CONSTANT NUMBER := 1.0;
881:
882: --cursor to check line status

Line 894: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

890: l_cle_rec l_cle_csr%ROWTYPE;
891: l_chk_rebook_chr VARCHAR2(1);
892:
893: BEGIN
894: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
895: -- Call start_activity to create savepoint, check compatibility
896: -- and initialize message list
897: l_return_status := Okl_Api.START_ACTIVITY(
898: p_api_name => l_api_name,

Line 897: l_return_status := Okl_Api.START_ACTIVITY(

893: BEGIN
894: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
895: -- Call start_activity to create savepoint, check compatibility
896: -- and initialize message list
897: l_return_status := Okl_Api.START_ACTIVITY(
898: p_api_name => l_api_name,
899: p_pkg_name => g_pkg_name,
900: p_init_msg_list => p_init_msg_list,
901: l_api_version => l_api_version,

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

902: p_api_version => p_api_version,
903: p_api_type => '_PVT',
904: x_return_status => x_return_status);
905: -- Check if activity started successfully
906: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
907: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
908: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
909: RAISE Okl_Api.G_EXCEPTION_ERROR;
910: END IF;

Line 907: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

903: p_api_type => '_PVT',
904: x_return_status => x_return_status);
905: -- Check if activity started successfully
906: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
907: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
908: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
909: RAISE Okl_Api.G_EXCEPTION_ERROR;
910: END IF;
911:

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

904: x_return_status => x_return_status);
905: -- Check if activity started successfully
906: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
907: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
908: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
909: RAISE Okl_Api.G_EXCEPTION_ERROR;
910: END IF;
911:
912: OPEN l_cle_csr(p_cle_id => p_cle_id);

Line 909: RAISE Okl_Api.G_EXCEPTION_ERROR;

905: -- Check if activity started successfully
906: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
907: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
908: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
909: RAISE Okl_Api.G_EXCEPTION_ERROR;
910: END IF;
911:
912: OPEN l_cle_csr(p_cle_id => p_cle_id);
913: FETCH l_cle_csr INTO l_cle_rec;

Line 918: IF (l_chk_rebook_chr = OKL_API.G_TRUE AND l_cle_rec.sts_code = 'TERMINATED') THEN

914: CLOSE l_cle_csr;
915:
916: l_chk_rebook_chr := OKL_LLA_UTIL_PVT.check_rebook_contract(p_chr_id => l_cle_rec.dnz_chr_id);
917:
918: IF (l_chk_rebook_chr = OKL_API.G_TRUE AND l_cle_rec.sts_code = 'TERMINATED') THEN
919: OKL_API.set_message(p_app_name => G_APP_NAME,
920: p_msg_name => 'OKL_LA_RBK_TER_LINE_UPDATE');
921: RAISE OKL_API.G_EXCEPTION_ERROR;
922: END IF;

Line 919: OKL_API.set_message(p_app_name => G_APP_NAME,

915:
916: l_chk_rebook_chr := OKL_LLA_UTIL_PVT.check_rebook_contract(p_chr_id => l_cle_rec.dnz_chr_id);
917:
918: IF (l_chk_rebook_chr = OKL_API.G_TRUE AND l_cle_rec.sts_code = 'TERMINATED') THEN
919: OKL_API.set_message(p_app_name => G_APP_NAME,
920: p_msg_name => 'OKL_LA_RBK_TER_LINE_UPDATE');
921: RAISE OKL_API.G_EXCEPTION_ERROR;
922: END IF;
923:

Line 921: RAISE OKL_API.G_EXCEPTION_ERROR;

917:
918: IF (l_chk_rebook_chr = OKL_API.G_TRUE AND l_cle_rec.sts_code = 'TERMINATED') THEN
919: OKL_API.set_message(p_app_name => G_APP_NAME,
920: p_msg_name => 'OKL_LA_RBK_TER_LINE_UPDATE');
921: RAISE OKL_API.G_EXCEPTION_ERROR;
922: END IF;
923:
924: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
925: x_msg_data => x_msg_data);

Line 924: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

920: p_msg_name => 'OKL_LA_RBK_TER_LINE_UPDATE');
921: RAISE OKL_API.G_EXCEPTION_ERROR;
922: END IF;
923:
924: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
925: x_msg_data => x_msg_data);
926:
927: EXCEPTION
928: when OKL_API.G_EXCEPTION_ERROR then

Line 928: when OKL_API.G_EXCEPTION_ERROR then

924: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
925: x_msg_data => x_msg_data);
926:
927: EXCEPTION
928: when OKL_API.G_EXCEPTION_ERROR then
929:
930: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
931: p_api_name => l_api_name,
932: p_pkg_name => G_PKG_NAME,

Line 930: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

926:
927: EXCEPTION
928: when OKL_API.G_EXCEPTION_ERROR then
929:
930: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
931: p_api_name => l_api_name,
932: p_pkg_name => G_PKG_NAME,
933: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
934: x_msg_count => x_msg_count,

Line 933: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

929:
930: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
931: p_api_name => l_api_name,
932: p_pkg_name => G_PKG_NAME,
933: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
934: x_msg_count => x_msg_count,
935: x_msg_data => x_msg_data,
936: p_api_type => G_API_TYPE);
937:

Line 938: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

934: x_msg_count => x_msg_count,
935: x_msg_data => x_msg_data,
936: p_api_type => G_API_TYPE);
937:
938: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
939:
940: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
941: p_api_name => l_api_name,
942: p_pkg_name => G_PKG_NAME,

Line 940: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

936: p_api_type => G_API_TYPE);
937:
938: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
939:
940: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
941: p_api_name => l_api_name,
942: p_pkg_name => G_PKG_NAME,
943: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
944: x_msg_count => x_msg_count,

Line 943: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

939:
940: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
941: p_api_name => l_api_name,
942: p_pkg_name => G_PKG_NAME,
943: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
944: x_msg_count => x_msg_count,
945: x_msg_data => x_msg_data,
946: p_api_type => G_API_TYPE);
947:

Line 950: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

946: p_api_type => G_API_TYPE);
947:
948: when OTHERS then
949:
950: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
951: p_api_name => l_api_name,
952: p_pkg_name => G_PKG_NAME,
953: p_exc_name => 'OTHERS',
954: x_msg_count => x_msg_count,

Line 1268: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1264: l_party_site_id NUMBER;
1265: l_location_id NUMBER;
1266: l_vendor_id NUMBER;
1267: l_party_site_number VARCHAR2(30);
1268: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1269: l_msg_count NUMBER;
1270: l_msg_data VARCHAR2(200);
1271: l_address_line1 VARCHAR2(240);
1272: l_city VARCHAR2(60);

Line 1331: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1327: and party_site_id = p_party_site_id
1328: and hzps.location_id = hzl.location_id;
1329:
1330: BEGIN
1331: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1332: -- call START_ACTIVITY to create savepoint, check compatibility
1333: -- and initialize message list
1334: x_return_status := OKL_API.START_ACTIVITY(
1335: p_api_name => l_api_name,

Line 1334: x_return_status := OKL_API.START_ACTIVITY(

1330: BEGIN
1331: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1332: -- call START_ACTIVITY to create savepoint, check compatibility
1333: -- and initialize message list
1334: x_return_status := OKL_API.START_ACTIVITY(
1335: p_api_name => l_api_name,
1336: p_pkg_name => G_PKG_NAME,
1337: p_init_msg_list => p_init_msg_list,
1338: l_api_version => l_api_version,

Line 1344: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1340: p_api_type => G_API_TYPE,
1341: x_return_status => l_return_status);
1342:
1343: -- check if activity started successfully
1344: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1345: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1346: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1347: RAISE OKL_API.G_EXCEPTION_ERROR;
1348: END IF;

Line 1345: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1341: x_return_status => l_return_status);
1342:
1343: -- check if activity started successfully
1344: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1345: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1346: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1347: RAISE OKL_API.G_EXCEPTION_ERROR;
1348: END IF;
1349:

Line 1346: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1342:
1343: -- check if activity started successfully
1344: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1345: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1346: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1347: RAISE OKL_API.G_EXCEPTION_ERROR;
1348: END IF;
1349:
1350: IF(party_site_id IS NOT NULL AND party_site_id <> OKL_API.G_MISS_NUM) THEN

Line 1347: RAISE OKL_API.G_EXCEPTION_ERROR;

1343: -- check if activity started successfully
1344: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1345: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1346: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1347: RAISE OKL_API.G_EXCEPTION_ERROR;
1348: END IF;
1349:
1350: IF(party_site_id IS NOT NULL AND party_site_id <> OKL_API.G_MISS_NUM) THEN
1351: l_party_site_id := party_site_id;

Line 1350: IF(party_site_id IS NOT NULL AND party_site_id <> OKL_API.G_MISS_NUM) THEN

1346: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1347: RAISE OKL_API.G_EXCEPTION_ERROR;
1348: END IF;
1349:
1350: IF(party_site_id IS NOT NULL AND party_site_id <> OKL_API.G_MISS_NUM) THEN
1351: l_party_site_id := party_site_id;
1352: OPEN get_location_id(l_party_site_id);
1353: FETCH get_location_id
1354: INTO l_location_id, l_party_site_number, l_vendor_id, l_address_line1,

Line 1385: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1381: x_vendor_site_id => l_vendor_site_id,
1382: x_party_site_id => l_party_site_id,
1383: x_location_id => l_location_id
1384: );
1385: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1386: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1387: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1388: RAISE OKL_API.G_EXCEPTION_ERROR;
1389: END IF;

Line 1386: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1382: x_party_site_id => l_party_site_id,
1383: x_location_id => l_location_id
1384: );
1385: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1386: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1387: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1388: RAISE OKL_API.G_EXCEPTION_ERROR;
1389: END IF;
1390:

Line 1387: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1383: x_location_id => l_location_id
1384: );
1385: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1386: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1387: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1388: RAISE OKL_API.G_EXCEPTION_ERROR;
1389: END IF;
1390:
1391: l_vendor_site_rec_upd.vendor_site_id := l_vendor_site_id;

Line 1388: RAISE OKL_API.G_EXCEPTION_ERROR;

1384: );
1385: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1386: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1387: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1388: RAISE OKL_API.G_EXCEPTION_ERROR;
1389: END IF;
1390:
1391: l_vendor_site_rec_upd.vendor_site_id := l_vendor_site_id;
1392: l_vendor_site_rec_upd.party_site_id := l_party_site_id;

Line 1411: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1407: x_msg_count => l_msg_count,
1408: x_msg_data => l_msg_data
1409: );
1410:
1411: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1412: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1413: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1414: RAISE OKL_API.G_EXCEPTION_ERROR;
1415: END IF;

Line 1412: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1408: x_msg_data => l_msg_data
1409: );
1410:
1411: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1412: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1413: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1414: RAISE OKL_API.G_EXCEPTION_ERROR;
1415: END IF;
1416:

Line 1413: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1409: );
1410:
1411: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1412: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1413: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1414: RAISE OKL_API.G_EXCEPTION_ERROR;
1415: END IF;
1416:
1417:

Line 1414: RAISE OKL_API.G_EXCEPTION_ERROR;

1410:
1411: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1412: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1413: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1414: RAISE OKL_API.G_EXCEPTION_ERROR;
1415: END IF;
1416:
1417:
1418: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 1418: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

1414: RAISE OKL_API.G_EXCEPTION_ERROR;
1415: END IF;
1416:
1417:
1418: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1419: x_msg_data => x_msg_data);
1420: EXCEPTION
1421: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1422: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 1421: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1417:
1418: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1419: x_msg_data => x_msg_data);
1420: EXCEPTION
1421: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1422: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1423: p_api_name => l_api_name,
1424: p_pkg_name => G_PKG_NAME,
1425: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 1422: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1418: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1419: x_msg_data => x_msg_data);
1420: EXCEPTION
1421: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1422: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1423: p_api_name => l_api_name,
1424: p_pkg_name => G_PKG_NAME,
1425: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1426: x_msg_count => x_msg_count,

Line 1425: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

1421: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1422: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1423: p_api_name => l_api_name,
1424: p_pkg_name => G_PKG_NAME,
1425: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1426: x_msg_count => x_msg_count,
1427: x_msg_data => x_msg_data,
1428: p_api_type => G_API_TYPE);
1429:

Line 1430: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1426: x_msg_count => x_msg_count,
1427: x_msg_data => x_msg_data,
1428: p_api_type => G_API_TYPE);
1429:
1430: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1431: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1432: p_api_name => l_api_name,
1433: p_pkg_name => G_PKG_NAME,
1434: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1431: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1427: x_msg_data => x_msg_data,
1428: p_api_type => G_API_TYPE);
1429:
1430: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1431: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1432: p_api_name => l_api_name,
1433: p_pkg_name => G_PKG_NAME,
1434: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1435: x_msg_count => x_msg_count,

Line 1434: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

1430: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1431: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1432: p_api_name => l_api_name,
1433: p_pkg_name => G_PKG_NAME,
1434: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1435: x_msg_count => x_msg_count,
1436: x_msg_data => x_msg_data,
1437: p_api_type => G_API_TYPE);
1438:

Line 1440: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1436: x_msg_data => x_msg_data,
1437: p_api_type => G_API_TYPE);
1438:
1439: WHEN OTHERS THEN
1440: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1441: p_api_name => l_api_name,
1442: p_pkg_name => G_PKG_NAME,
1443: p_exc_name => 'OTHERS',
1444: x_msg_count => x_msg_count,

Line 1471: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1467: l_vendor_id NUMBER;
1468: l_party_id NUMBER;
1469: l_party_site_id NUMBER;
1470: l_org_id NUMBER;
1471: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1472: l_init_msg_list VARCHAR2(1) DEFAULT OKL_API.G_FALSE;
1473: l_msg_count NUMBER;
1474: l_msg_data VARCHAR2(200);
1475:

Line 1472: l_init_msg_list VARCHAR2(1) DEFAULT OKL_API.G_FALSE;

1468: l_party_id NUMBER;
1469: l_party_site_id NUMBER;
1470: l_org_id NUMBER;
1471: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1472: l_init_msg_list VARCHAR2(1) DEFAULT OKL_API.G_FALSE;
1473: l_msg_count NUMBER;
1474: l_msg_data VARCHAR2(200);
1475:
1476:

Line 1478: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1474: l_msg_data VARCHAR2(200);
1475:
1476:
1477: BEGIN
1478: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1479: -- call START_ACTIVITY to create savepoint, check compatibility
1480: -- and initialize message list
1481: x_return_status := OKL_API.START_ACTIVITY(
1482: p_api_name => l_api_name,

Line 1481: x_return_status := OKL_API.START_ACTIVITY(

1477: BEGIN
1478: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1479: -- call START_ACTIVITY to create savepoint, check compatibility
1480: -- and initialize message list
1481: x_return_status := OKL_API.START_ACTIVITY(
1482: p_api_name => l_api_name,
1483: p_pkg_name => G_PKG_NAME,
1484: p_init_msg_list => p_init_msg_list,
1485: l_api_version => l_api_version,

Line 1491: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1487: p_api_type => G_API_TYPE,
1488: x_return_status => x_return_status);
1489:
1490: -- check if activity started successfully
1491: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1492: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1493: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1494: RAISE OKL_API.G_EXCEPTION_ERROR;
1495: END IF;

Line 1492: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1488: x_return_status => x_return_status);
1489:
1490: -- check if activity started successfully
1491: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1492: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1493: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1494: RAISE OKL_API.G_EXCEPTION_ERROR;
1495: END IF;
1496:

Line 1493: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

1489:
1490: -- check if activity started successfully
1491: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1492: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1493: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1494: RAISE OKL_API.G_EXCEPTION_ERROR;
1495: END IF;
1496:
1497: l_party_site_id := party_site_id;

Line 1494: RAISE OKL_API.G_EXCEPTION_ERROR;

1490: -- check if activity started successfully
1491: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1492: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1493: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1494: RAISE OKL_API.G_EXCEPTION_ERROR;
1495: END IF;
1496:
1497: l_party_site_id := party_site_id;
1498: l_org_id := p_org_id;

Line 1509: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1505: x_msg_data => l_msg_data ,
1506: x_vendor_id => l_vendor_id,
1507: x_party_id => l_party_id);
1508:
1509: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1510: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1511: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1512: RAISE OKL_API.G_EXCEPTION_ERROR;
1513: END IF;

Line 1510: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1506: x_vendor_id => l_vendor_id,
1507: x_party_id => l_party_id);
1508:
1509: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1510: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1511: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1512: RAISE OKL_API.G_EXCEPTION_ERROR;
1513: END IF;
1514:

Line 1511: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1507: x_party_id => l_party_id);
1508:
1509: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1510: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1511: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1512: RAISE OKL_API.G_EXCEPTION_ERROR;
1513: END IF;
1514:
1515: create_pay_site(

Line 1512: RAISE OKL_API.G_EXCEPTION_ERROR;

1508:
1509: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1510: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1511: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1512: RAISE OKL_API.G_EXCEPTION_ERROR;
1513: END IF;
1514:
1515: create_pay_site(
1516: party_id => l_party_id,

Line 1526: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1522: x_msg_count => l_msg_count,
1523: x_msg_data => l_msg_data
1524: );
1525:
1526: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1527: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1528: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1529: RAISE OKL_API.G_EXCEPTION_ERROR;
1530: END IF;

Line 1527: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1523: x_msg_data => l_msg_data
1524: );
1525:
1526: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1527: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1528: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1529: RAISE OKL_API.G_EXCEPTION_ERROR;
1530: END IF;
1531:

Line 1528: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1524: );
1525:
1526: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1527: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1528: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1529: RAISE OKL_API.G_EXCEPTION_ERROR;
1530: END IF;
1531:
1532: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 1529: RAISE OKL_API.G_EXCEPTION_ERROR;

1525:
1526: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1527: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1528: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1529: RAISE OKL_API.G_EXCEPTION_ERROR;
1530: END IF;
1531:
1532: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1533: x_msg_data => x_msg_data);

Line 1532: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

1528: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1529: RAISE OKL_API.G_EXCEPTION_ERROR;
1530: END IF;
1531:
1532: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1533: x_msg_data => x_msg_data);
1534:
1535:
1536:

Line 1538: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1534:
1535:
1536:
1537: EXCEPTION
1538: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1539: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1540: p_api_name => l_api_name,
1541: p_pkg_name => G_PKG_NAME,
1542: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 1539: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1535:
1536:
1537: EXCEPTION
1538: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1539: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1540: p_api_name => l_api_name,
1541: p_pkg_name => G_PKG_NAME,
1542: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1543: x_msg_count => x_msg_count,

Line 1542: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

1538: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1539: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1540: p_api_name => l_api_name,
1541: p_pkg_name => G_PKG_NAME,
1542: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1543: x_msg_count => x_msg_count,
1544: x_msg_data => x_msg_data,
1545: p_api_type => G_API_TYPE);
1546:

Line 1547: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1543: x_msg_count => x_msg_count,
1544: x_msg_data => x_msg_data,
1545: p_api_type => G_API_TYPE);
1546:
1547: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1548: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1549: p_api_name => l_api_name,
1550: p_pkg_name => G_PKG_NAME,
1551: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1548: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1544: x_msg_data => x_msg_data,
1545: p_api_type => G_API_TYPE);
1546:
1547: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1548: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1549: p_api_name => l_api_name,
1550: p_pkg_name => G_PKG_NAME,
1551: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1552: x_msg_count => x_msg_count,

Line 1551: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

1547: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1548: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1549: p_api_name => l_api_name,
1550: p_pkg_name => G_PKG_NAME,
1551: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1552: x_msg_count => x_msg_count,
1553: x_msg_data => x_msg_data,
1554: p_api_type => G_API_TYPE);
1555:

Line 1557: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1553: x_msg_data => x_msg_data,
1554: p_api_type => G_API_TYPE);
1555:
1556: WHEN OTHERS THEN
1557: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1558: p_api_name => l_api_name,
1559: p_pkg_name => G_PKG_NAME,
1560: p_exc_name => 'OTHERS',
1561: x_msg_count => x_msg_count,

Line 1639: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1635:
1636: TYPE EXTR_ID_TBL is table of number index by binary_integer;
1637: T_EXTR_ID_TBL EXTR_ID_TBL;
1638: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_EXTERNAL_ID';
1639: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1640: l_init_msg_list VARCHAR2(1) DEFAULT OKL_API.G_FALSE;
1641: l_msg_count NUMBER;
1642: l_msg_data VARCHAR2(200);
1643: BEGIN

Line 1640: l_init_msg_list VARCHAR2(1) DEFAULT OKL_API.G_FALSE;

1636: TYPE EXTR_ID_TBL is table of number index by binary_integer;
1637: T_EXTR_ID_TBL EXTR_ID_TBL;
1638: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_EXTERNAL_ID';
1639: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1640: l_init_msg_list VARCHAR2(1) DEFAULT OKL_API.G_FALSE;
1641: l_msg_count NUMBER;
1642: l_msg_data VARCHAR2(200);
1643: BEGIN
1644: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 1644: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1640: l_init_msg_list VARCHAR2(1) DEFAULT OKL_API.G_FALSE;
1641: l_msg_count NUMBER;
1642: l_msg_data VARCHAR2(200);
1643: BEGIN
1644: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1645: -- Call start_activity to create savepoint, check compatibility
1646: -- and initialize message list
1647: x_return_status := OKL_API.START_ACTIVITY (
1648: l_api_name

Line 1647: x_return_status := OKL_API.START_ACTIVITY (

1643: BEGIN
1644: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1645: -- Call start_activity to create savepoint, check compatibility
1646: -- and initialize message list
1647: x_return_status := OKL_API.START_ACTIVITY (
1648: l_api_name
1649: ,l_init_msg_list
1650: ,'_PVT'
1651: ,x_return_status);

Line 1653: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1649: ,l_init_msg_list
1650: ,'_PVT'
1651: ,x_return_status);
1652: -- Check if activity started successfully
1653: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1654: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1655: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1656: RAISE OKL_API.G_EXCEPTION_ERROR;
1657: END IF;

Line 1654: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1650: ,'_PVT'
1651: ,x_return_status);
1652: -- Check if activity started successfully
1653: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1654: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1655: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1656: RAISE OKL_API.G_EXCEPTION_ERROR;
1657: END IF;
1658:

Line 1655: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

1651: ,x_return_status);
1652: -- Check if activity started successfully
1653: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1654: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1655: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1656: RAISE OKL_API.G_EXCEPTION_ERROR;
1657: END IF;
1658:
1659: OPEN get_line_details_csr(p_chr_id);

Line 1656: RAISE OKL_API.G_EXCEPTION_ERROR;

1652: -- Check if activity started successfully
1653: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1654: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1655: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1656: RAISE OKL_API.G_EXCEPTION_ERROR;
1657: END IF;
1658:
1659: OPEN get_line_details_csr(p_chr_id);
1660: FETCH get_line_details_csr bulk collect into t_extr_id_tbl;

Line 1688: WHEN OKL_API.G_EXCEPTION_ERROR then

1684:
1685: t_extr_id_tbl.delete;
1686:
1687: exception
1688: WHEN OKL_API.G_EXCEPTION_ERROR then
1689: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1690: l_api_name,
1691: G_PKG_NAME,
1692: 'OKL_API.G_RET_STS_ERROR',

Line 1689: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1685: t_extr_id_tbl.delete;
1686:
1687: exception
1688: WHEN OKL_API.G_EXCEPTION_ERROR then
1689: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1690: l_api_name,
1691: G_PKG_NAME,
1692: 'OKL_API.G_RET_STS_ERROR',
1693: l_msg_count,

Line 1692: 'OKL_API.G_RET_STS_ERROR',

1688: WHEN OKL_API.G_EXCEPTION_ERROR then
1689: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1690: l_api_name,
1691: G_PKG_NAME,
1692: 'OKL_API.G_RET_STS_ERROR',
1693: l_msg_count,
1694: l_msg_data,
1695: '_PVT');
1696: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

Line 1696: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

1692: 'OKL_API.G_RET_STS_ERROR',
1693: l_msg_count,
1694: l_msg_data,
1695: '_PVT');
1696: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
1697: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1698: l_api_name,
1699: G_PKG_NAME,
1700: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1697: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

1693: l_msg_count,
1694: l_msg_data,
1695: '_PVT');
1696: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
1697: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1698: l_api_name,
1699: G_PKG_NAME,
1700: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1701: l_msg_count,

Line 1700: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1696: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
1697: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1698: l_api_name,
1699: G_PKG_NAME,
1700: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1701: l_msg_count,
1702: l_msg_data,
1703: '_PVT');
1704: WHEN OTHERS then

Line 1705: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

1701: l_msg_count,
1702: l_msg_data,
1703: '_PVT');
1704: WHEN OTHERS then
1705: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1706: l_api_name,
1707: G_PKG_NAME,
1708: 'OTHERS',
1709: l_msg_count,

Line 1805: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1801:
1802: l_rbk_in_progress VARCHAR2(1);
1803:
1804: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_EXTERNAL_ID';
1805: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1806: l_init_msg_list VARCHAR2(1) DEFAULT OKL_API.G_FALSE;
1807: l_msg_count NUMBER;
1808: l_msg_data VARCHAR2(200);
1809: BEGIN

Line 1806: l_init_msg_list VARCHAR2(1) DEFAULT OKL_API.G_FALSE;

1802: l_rbk_in_progress VARCHAR2(1);
1803:
1804: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_EXTERNAL_ID';
1805: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1806: l_init_msg_list VARCHAR2(1) DEFAULT OKL_API.G_FALSE;
1807: l_msg_count NUMBER;
1808: l_msg_data VARCHAR2(200);
1809: BEGIN
1810: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 1810: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1806: l_init_msg_list VARCHAR2(1) DEFAULT OKL_API.G_FALSE;
1807: l_msg_count NUMBER;
1808: l_msg_data VARCHAR2(200);
1809: BEGIN
1810: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1811: -- Call start_activity to create savepoint, check compatibility
1812: -- and initialize message list
1813: x_return_status := OKL_API.START_ACTIVITY (
1814: l_api_name

Line 1813: x_return_status := OKL_API.START_ACTIVITY (

1809: BEGIN
1810: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1811: -- Call start_activity to create savepoint, check compatibility
1812: -- and initialize message list
1813: x_return_status := OKL_API.START_ACTIVITY (
1814: l_api_name
1815: ,l_init_msg_list
1816: ,'_PVT'
1817: ,x_return_status);

Line 1819: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1815: ,l_init_msg_list
1816: ,'_PVT'
1817: ,x_return_status);
1818: -- Check if activity started successfully
1819: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1820: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1821: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1822: RAISE OKL_API.G_EXCEPTION_ERROR;
1823: END IF;

Line 1820: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1816: ,'_PVT'
1817: ,x_return_status);
1818: -- Check if activity started successfully
1819: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1820: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1821: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1822: RAISE OKL_API.G_EXCEPTION_ERROR;
1823: END IF;
1824:

Line 1821: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

1817: ,x_return_status);
1818: -- Check if activity started successfully
1819: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1820: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1821: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1822: RAISE OKL_API.G_EXCEPTION_ERROR;
1823: END IF;
1824:
1825: -- find out if an online rebook process is in progress

Line 1822: RAISE OKL_API.G_EXCEPTION_ERROR;

1818: -- Check if activity started successfully
1819: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1820: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1821: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1822: RAISE OKL_API.G_EXCEPTION_ERROR;
1823: END IF;
1824:
1825: -- find out if an online rebook process is in progress
1826: -- if the call is coming from the 'Price' button, the processing is different.

Line 1966: WHEN OKL_API.G_EXCEPTION_ERROR then

1962: t_orig_chr_id_tbl.delete;
1963: t_vendor_id_tbl.delete;
1964:
1965: exception
1966: WHEN OKL_API.G_EXCEPTION_ERROR then
1967: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1968: l_api_name,
1969: G_PKG_NAME,
1970: 'OKL_API.G_RET_STS_ERROR',

Line 1967: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1963: t_vendor_id_tbl.delete;
1964:
1965: exception
1966: WHEN OKL_API.G_EXCEPTION_ERROR then
1967: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1968: l_api_name,
1969: G_PKG_NAME,
1970: 'OKL_API.G_RET_STS_ERROR',
1971: l_msg_count,

Line 1970: 'OKL_API.G_RET_STS_ERROR',

1966: WHEN OKL_API.G_EXCEPTION_ERROR then
1967: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1968: l_api_name,
1969: G_PKG_NAME,
1970: 'OKL_API.G_RET_STS_ERROR',
1971: l_msg_count,
1972: l_msg_data,
1973: '_PVT');
1974: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

Line 1974: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

1970: 'OKL_API.G_RET_STS_ERROR',
1971: l_msg_count,
1972: l_msg_data,
1973: '_PVT');
1974: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
1975: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1976: l_api_name,
1977: G_PKG_NAME,
1978: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1975: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

1971: l_msg_count,
1972: l_msg_data,
1973: '_PVT');
1974: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
1975: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1976: l_api_name,
1977: G_PKG_NAME,
1978: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1979: l_msg_count,

Line 1978: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1974: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
1975: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1976: l_api_name,
1977: G_PKG_NAME,
1978: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1979: l_msg_count,
1980: l_msg_data,
1981: '_PVT');
1982: WHEN OTHERS then

Line 1983: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

1979: l_msg_count,
1980: l_msg_data,
1981: '_PVT');
1982: WHEN OTHERS then
1983: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1984: l_api_name,
1985: G_PKG_NAME,
1986: 'OTHERS',
1987: l_msg_count,

Line 2001: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1997: x_msg_data OUT NOCOPY VARCHAR2,
1998: p_chr_id IN NUMBER,
1999: p_rbk_chr_id IN NUMBER DEFAULT NULL) IS
2000:
2001: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2002: l_api_name CONSTANT VARCHAR2(30) := 'CHECK_REBOOK_UPGRADE';
2003: l_api_version CONSTANT NUMBER := 1.0;
2004:
2005:

Line 2035: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

2031: l_amort_inc_adj_rev_dt_yn okl_sys_acct_opts.amort_inc_adj_rev_dt_yn%TYPE;
2032: l_contract_number okc_k_headers_all_b.contract_number%TYPE;
2033:
2034: BEGIN
2035: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
2036: -- Call start_activity to create savepoint, check compatibility
2037: -- and initialize message list
2038: l_return_status := Okl_Api.START_ACTIVITY(
2039: p_api_name => l_api_name,

Line 2038: l_return_status := Okl_Api.START_ACTIVITY(

2034: BEGIN
2035: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
2036: -- Call start_activity to create savepoint, check compatibility
2037: -- and initialize message list
2038: l_return_status := Okl_Api.START_ACTIVITY(
2039: p_api_name => l_api_name,
2040: p_pkg_name => g_pkg_name,
2041: p_init_msg_list => p_init_msg_list,
2042: l_api_version => l_api_version,

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

2043: p_api_version => p_api_version,
2044: p_api_type => '_PVT',
2045: x_return_status => x_return_status);
2046: -- Check if activity started successfully
2047: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2048: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2049: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2050: RAISE Okl_Api.G_EXCEPTION_ERROR;
2051: END IF;

Line 2048: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2044: p_api_type => '_PVT',
2045: x_return_status => x_return_status);
2046: -- Check if activity started successfully
2047: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2048: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2049: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2050: RAISE Okl_Api.G_EXCEPTION_ERROR;
2051: END IF;
2052:

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

2045: x_return_status => x_return_status);
2046: -- Check if activity started successfully
2047: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2048: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2049: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2050: RAISE Okl_Api.G_EXCEPTION_ERROR;
2051: END IF;
2052:
2053: l_amort_inc_adj_rev_dt_yn := 'N';

Line 2050: RAISE Okl_Api.G_EXCEPTION_ERROR;

2046: -- Check if activity started successfully
2047: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2048: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2049: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2050: RAISE Okl_Api.G_EXCEPTION_ERROR;
2051: END IF;
2052:
2053: l_amort_inc_adj_rev_dt_yn := 'N';
2054: OPEN l_acct_sys_op_csr;

Line 2064: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

2060: OKL_STREAMS_UTIL.get_pricing_engine(p_khr_id => p_chr_id,
2061: x_pricing_engine => l_pricing_engine,
2062: x_return_status => x_return_status);
2063:
2064: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
2065: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2066: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
2067: raise OKL_API.G_EXCEPTION_ERROR;
2068: END IF;

Line 2065: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2061: x_pricing_engine => l_pricing_engine,
2062: x_return_status => x_return_status);
2063:
2064: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
2065: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2066: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
2067: raise OKL_API.G_EXCEPTION_ERROR;
2068: END IF;
2069:

Line 2066: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

2062: x_return_status => x_return_status);
2063:
2064: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
2065: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2066: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
2067: raise OKL_API.G_EXCEPTION_ERROR;
2068: END IF;
2069:
2070: IF (l_pricing_engine = 'EXTERNAL') THEN

Line 2067: raise OKL_API.G_EXCEPTION_ERROR;

2063:
2064: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
2065: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2066: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
2067: raise OKL_API.G_EXCEPTION_ERROR;
2068: END IF;
2069:
2070: IF (l_pricing_engine = 'EXTERNAL') THEN
2071:

Line 2083: OKL_API.set_message(p_app_name => G_APP_NAME,

2079: OPEN l_chr_csr(p_chr_id => p_chr_id);
2080: FETCH l_chr_csr INTO l_contract_number;
2081: CLOSE l_chr_csr;
2082:
2083: OKL_API.set_message(p_app_name => G_APP_NAME,
2084: p_msg_name => 'OKL_LA_CONTRACT_NOT_UPGRADED',
2085: p_token1 => 'CONTRACT_NUMBER',
2086: p_token1_value => l_contract_number);
2087: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 2087: RAISE OKL_API.G_EXCEPTION_ERROR;

2083: OKL_API.set_message(p_app_name => G_APP_NAME,
2084: p_msg_name => 'OKL_LA_CONTRACT_NOT_UPGRADED',
2085: p_token1 => 'CONTRACT_NUMBER',
2086: p_token1_value => l_contract_number);
2087: RAISE OKL_API.G_EXCEPTION_ERROR;
2088:
2089: ELSE
2090:
2091: IF p_rbk_chr_id IS NOT NULL THEN

Line 2103: OKL_API.set_message(p_app_name => G_APP_NAME,

2099: OPEN l_chr_csr(p_chr_id => p_chr_id);
2100: FETCH l_chr_csr INTO l_contract_number;
2101: CLOSE l_chr_csr;
2102:
2103: OKL_API.set_message(p_app_name => G_APP_NAME,
2104: p_msg_name => 'OKL_LA_RBK_NOT_PRICED_UPG',
2105: p_token1 => 'CONTRACT_NUMBER',
2106: p_token1_value => l_contract_number);
2107: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 2107: RAISE OKL_API.G_EXCEPTION_ERROR;

2103: OKL_API.set_message(p_app_name => G_APP_NAME,
2104: p_msg_name => 'OKL_LA_RBK_NOT_PRICED_UPG',
2105: p_token1 => 'CONTRACT_NUMBER',
2106: p_token1_value => l_contract_number);
2107: RAISE OKL_API.G_EXCEPTION_ERROR;
2108: END IF;
2109: END IF;
2110:
2111: END IF;

Line 2116: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

2112:
2113: END IF;
2114: END IF;
2115:
2116: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
2117: x_msg_data => x_msg_data);
2118:
2119: EXCEPTION
2120: when OKL_API.G_EXCEPTION_ERROR then

Line 2120: when OKL_API.G_EXCEPTION_ERROR then

2116: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
2117: x_msg_data => x_msg_data);
2118:
2119: EXCEPTION
2120: when OKL_API.G_EXCEPTION_ERROR then
2121:
2122: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2123: p_api_name => l_api_name,
2124: p_pkg_name => G_PKG_NAME,

Line 2122: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2118:
2119: EXCEPTION
2120: when OKL_API.G_EXCEPTION_ERROR then
2121:
2122: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2123: p_api_name => l_api_name,
2124: p_pkg_name => G_PKG_NAME,
2125: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2126: x_msg_count => x_msg_count,

Line 2125: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

2121:
2122: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2123: p_api_name => l_api_name,
2124: p_pkg_name => G_PKG_NAME,
2125: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2126: x_msg_count => x_msg_count,
2127: x_msg_data => x_msg_data,
2128: p_api_type => G_API_TYPE);
2129:

Line 2130: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

2126: x_msg_count => x_msg_count,
2127: x_msg_data => x_msg_data,
2128: p_api_type => G_API_TYPE);
2129:
2130: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
2131:
2132: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2133: p_api_name => l_api_name,
2134: p_pkg_name => G_PKG_NAME,

Line 2132: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2128: p_api_type => G_API_TYPE);
2129:
2130: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
2131:
2132: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2133: p_api_name => l_api_name,
2134: p_pkg_name => G_PKG_NAME,
2135: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2136: x_msg_count => x_msg_count,

Line 2135: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

2131:
2132: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2133: p_api_name => l_api_name,
2134: p_pkg_name => G_PKG_NAME,
2135: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2136: x_msg_count => x_msg_count,
2137: x_msg_data => x_msg_data,
2138: p_api_type => G_API_TYPE);
2139:

Line 2142: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2138: p_api_type => G_API_TYPE);
2139:
2140: when OTHERS then
2141:
2142: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2143: p_api_name => l_api_name,
2144: p_pkg_name => G_PKG_NAME,
2145: p_exc_name => 'OTHERS',
2146: x_msg_count => x_msg_count,