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

Line 5: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;

1: PACKAGE BODY okl_subsidy_pool_wf AS
2: /* $Header: OKLRSWFB.pls 120.4 2011/07/27 11:35:11 rgooty ship $ */
3:
4: G_NO_MATCHING_RECORD CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_LLA_NO_MATCHING_RECORD';
5: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
6: G_SUBSIDY_POOL_APPROVAL_WF CONSTANT VARCHAR2(2) DEFAULT 'WF';
7: G_SUBSIDY_POOL_APPROVAL_AME CONSTANT VARCHAR2(3) DEFAULT 'AME';
8: G_ITEM_TYPE_WF CONSTANT VARCHAR2(10) DEFAULT 'OKLSPAPP';
9: G_POOL_APPROVAL_PROCESS_WF CONSTANT VARCHAR2(30) DEFAULT 'SUBSIDY_POOL_APPROVAL_WF';

Line 73: x_return_status := OKL_API.G_RET_STS_SUCCESS;

69: SELECT USER_NAME, DESCRIPTION
70: FROM FND_USER
71: WHERE user_id = c_user_id;
72: BEGIN
73: x_return_status := OKL_API.G_RET_STS_SUCCESS;
74: OPEN wf_users_csr(p_user_id);
75: FETCH wf_users_csr INTO x_name, x_description;
76: CLOSE wf_users_csr;
77: IF x_name IS NULL THEN

Line 88: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

84: END IF;
85: END IF;
86: EXCEPTION
87: WHEN OTHERS THEN
88: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
89: END l_get_agent;
90:
91: FUNCTION get_item_key_wf RETURN NUMBER IS
92: CURSOR c_wf_item_key_csr IS

Line 503: ,p_init_msg_list => OKL_API.G_TRUE

499: lv_total_budget := wf_engine.GetItemAttrText(itemtype => itemtype,
500: itemkey => itemkey,
501: aname => G_WF_ITM_TOTAL_BUDGETS);
502: okl_subsidy_pool_pvt.update_total_budget(p_api_version => '1.0'
503: ,p_init_msg_list => OKL_API.G_TRUE
504: ,x_return_status => x_return_status
505: ,x_msg_count => x_msg_count
506: ,x_msg_data => x_msg_data
507: ,p_subsidy_pool_id => lv_subsidy_pool_id

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

515: ' returned with status '||x_return_status ||' x_msg_data '||x_msg_data
516: );
517: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
518:
519: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
520: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
521: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
522: RAISE OKL_API.G_EXCEPTION_ERROR;
523: END IF;

Line 520: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

516: );
517: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
518:
519: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
520: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
521: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
522: RAISE OKL_API.G_EXCEPTION_ERROR;
523: END IF;
524: lv_decision_status_code := 'ACTIVE';

Line 521: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN

517: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
518:
519: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
520: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
521: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
522: RAISE OKL_API.G_EXCEPTION_ERROR;
523: END IF;
524: lv_decision_status_code := 'ACTIVE';
525: okl_subsidy_pool_budget_pvt.set_decision_status_code(p_api_version => '1.0'

Line 522: RAISE OKL_API.G_EXCEPTION_ERROR;

518:
519: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
520: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
521: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
522: RAISE OKL_API.G_EXCEPTION_ERROR;
523: END IF;
524: lv_decision_status_code := 'ACTIVE';
525: okl_subsidy_pool_budget_pvt.set_decision_status_code(p_api_version => '1.0'
526: ,p_init_msg_list => OKL_API.G_TRUE

Line 526: ,p_init_msg_list => OKL_API.G_TRUE

522: RAISE OKL_API.G_EXCEPTION_ERROR;
523: END IF;
524: lv_decision_status_code := 'ACTIVE';
525: okl_subsidy_pool_budget_pvt.set_decision_status_code(p_api_version => '1.0'
526: ,p_init_msg_list => OKL_API.G_TRUE
527: ,x_return_status => x_return_status
528: ,x_msg_count => x_msg_count
529: ,x_msg_data => x_msg_data
530: ,p_sub_pool_budget_id => lv_budget_line_id

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

538: ' returned with status '||x_return_status ||' x_msg_data '||x_msg_data
539: );
540: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
541:
542: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
543: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
544: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
545: RAISE OKL_API.G_EXCEPTION_ERROR;
546: END IF;

Line 543: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

539: );
540: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
541:
542: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
543: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
544: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
545: RAISE OKL_API.G_EXCEPTION_ERROR;
546: END IF;
547:

Line 544: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN

540: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
541:
542: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
543: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
544: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
545: RAISE OKL_API.G_EXCEPTION_ERROR;
546: END IF;
547:
548: okl_subsidy_pool_pvt.set_decision_status_code(p_api_version => '1.0'

Line 545: RAISE OKL_API.G_EXCEPTION_ERROR;

541:
542: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
543: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
544: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
545: RAISE OKL_API.G_EXCEPTION_ERROR;
546: END IF;
547:
548: okl_subsidy_pool_pvt.set_decision_status_code(p_api_version => '1.0'
549: ,p_init_msg_list => OKL_API.G_TRUE

Line 549: ,p_init_msg_list => OKL_API.G_TRUE

545: RAISE OKL_API.G_EXCEPTION_ERROR;
546: END IF;
547:
548: okl_subsidy_pool_pvt.set_decision_status_code(p_api_version => '1.0'
549: ,p_init_msg_list => OKL_API.G_TRUE
550: ,x_return_status => x_return_status
551: ,x_msg_count => x_msg_count
552: ,x_msg_data => x_msg_data
553: ,p_subsidy_pool_id => lv_subsidy_pool_id

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

560: ' returned with status '||x_return_status ||' x_msg_data '||x_msg_data
561: );
562: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
563:
564: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
565: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
566: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
567: RAISE OKL_API.G_EXCEPTION_ERROR;
568: END IF;

Line 565: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

561: );
562: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
563:
564: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
565: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
566: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
567: RAISE OKL_API.G_EXCEPTION_ERROR;
568: END IF;
569: resultout := 'COMPLETE:';

Line 566: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN

562: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
563:
564: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
565: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
566: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
567: RAISE OKL_API.G_EXCEPTION_ERROR;
568: END IF;
569: resultout := 'COMPLETE:';
570: ELSIF(G_WF_ITM_APPROVED_YN_NO = lv_approval_status OR lv_approval_status_ame = 'N')THEN

Line 567: RAISE OKL_API.G_EXCEPTION_ERROR;

563:
564: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
565: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
566: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
567: RAISE OKL_API.G_EXCEPTION_ERROR;
568: END IF;
569: resultout := 'COMPLETE:';
570: ELSIF(G_WF_ITM_APPROVED_YN_NO = lv_approval_status OR lv_approval_status_ame = 'N')THEN
571: lv_decision_status_code := 'REJECTED';

Line 573: ,p_init_msg_list => OKL_API.G_TRUE

569: resultout := 'COMPLETE:';
570: ELSIF(G_WF_ITM_APPROVED_YN_NO = lv_approval_status OR lv_approval_status_ame = 'N')THEN
571: lv_decision_status_code := 'REJECTED';
572: okl_subsidy_pool_budget_pvt.set_decision_status_code(p_api_version => '1.0'
573: ,p_init_msg_list => OKL_API.G_TRUE
574: ,x_return_status => x_return_status
575: ,x_msg_count => x_msg_count
576: ,x_msg_data => x_msg_data
577: ,p_sub_pool_budget_id => lv_budget_line_id

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

585: ' returned with status '||x_return_status ||' x_msg_data '||x_msg_data
586: );
587: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
588:
589: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
590: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
591: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
592: RAISE OKL_API.G_EXCEPTION_ERROR;
593: END IF;

Line 590: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

586: );
587: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
588:
589: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
590: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
591: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
592: RAISE OKL_API.G_EXCEPTION_ERROR;
593: END IF;
594: okl_subsidy_pool_pvt.set_decision_status_code(p_api_version => '1.0'

Line 591: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN

587: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
588:
589: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
590: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
591: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
592: RAISE OKL_API.G_EXCEPTION_ERROR;
593: END IF;
594: okl_subsidy_pool_pvt.set_decision_status_code(p_api_version => '1.0'
595: ,p_init_msg_list => OKL_API.G_TRUE

Line 592: RAISE OKL_API.G_EXCEPTION_ERROR;

588:
589: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
590: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
591: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
592: RAISE OKL_API.G_EXCEPTION_ERROR;
593: END IF;
594: okl_subsidy_pool_pvt.set_decision_status_code(p_api_version => '1.0'
595: ,p_init_msg_list => OKL_API.G_TRUE
596: ,x_return_status => x_return_status

Line 595: ,p_init_msg_list => OKL_API.G_TRUE

591: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
592: RAISE OKL_API.G_EXCEPTION_ERROR;
593: END IF;
594: okl_subsidy_pool_pvt.set_decision_status_code(p_api_version => '1.0'
595: ,p_init_msg_list => OKL_API.G_TRUE
596: ,x_return_status => x_return_status
597: ,x_msg_count => x_msg_count
598: ,x_msg_data => x_msg_data
599: ,p_subsidy_pool_id => lv_subsidy_pool_id

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

606: ' returned with status '||x_return_status ||' x_msg_data '||x_msg_data
607: );
608: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
609:
610: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
611: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
612: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
613: RAISE OKL_API.G_EXCEPTION_ERROR;
614: END IF;

Line 611: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

607: );
608: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
609:
610: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
611: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
612: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
613: RAISE OKL_API.G_EXCEPTION_ERROR;
614: END IF;
615: resultout := 'COMPLETE:';

Line 612: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN

608: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
609:
610: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
611: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
612: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
613: RAISE OKL_API.G_EXCEPTION_ERROR;
614: END IF;
615: resultout := 'COMPLETE:';
616: ELSE

Line 613: RAISE OKL_API.G_EXCEPTION_ERROR;

609:
610: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
611: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
612: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
613: RAISE OKL_API.G_EXCEPTION_ERROR;
614: END IF;
615: resultout := 'COMPLETE:';
616: ELSE
617: NULL;

Line 636: WHEN OKL_API.G_EXCEPTION_ERROR THEN

632: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRBWFB.pls call update_pool_approval_status');
633: END IF;
634:
635: EXCEPTION
636: WHEN OKL_API.G_EXCEPTION_ERROR THEN
637: wf_core.context(G_PKG_NAME,
638: l_api_name,
639: itemtype,
640: itemkey,

Line 644: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

640: itemkey,
641: TO_CHAR(actid),
642: funcmode);
643: RAISE;
644: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
645: wf_core.context(G_PKG_NAME,
646: l_api_name,
647: itemtype,
648: itemkey,

Line 733: ,p_init_msg_list => OKL_API.G_TRUE

729: -- for all other cases in approval, do not do nuthing
730: IF(lv_budget_type_code = 'ADDITION')THEN
731: lv_total_budget := lv_total_budget + lv_line_amount;
732: okl_subsidy_pool_pvt.update_total_budget(p_api_version => '1.0'
733: ,p_init_msg_list => OKL_API.G_TRUE
734: ,x_return_status => x_return_status
735: ,x_msg_count => x_msg_count
736: ,x_msg_data => x_msg_data
737: ,p_subsidy_pool_id => lv_subsidy_pool_id

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

745: ' x_msg_data '||x_msg_data
746: );
747: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
748:
749: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
750: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
751: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
752: RAISE OKL_API.G_EXCEPTION_ERROR;
753: END IF;

Line 750: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

746: );
747: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
748:
749: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
750: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
751: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
752: RAISE OKL_API.G_EXCEPTION_ERROR;
753: END IF;
754: END IF; -- end of lv_budget_type_code = 'ADDITION'

Line 751: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN

747: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
748:
749: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
750: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
751: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
752: RAISE OKL_API.G_EXCEPTION_ERROR;
753: END IF;
754: END IF; -- end of lv_budget_type_code = 'ADDITION'
755: lv_decision_status_code := 'ACTIVE';

Line 752: RAISE OKL_API.G_EXCEPTION_ERROR;

748:
749: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
750: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
751: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
752: RAISE OKL_API.G_EXCEPTION_ERROR;
753: END IF;
754: END IF; -- end of lv_budget_type_code = 'ADDITION'
755: lv_decision_status_code := 'ACTIVE';
756: okl_subsidy_pool_budget_pvt.set_decision_status_code(p_api_version => '1.0'

Line 757: ,p_init_msg_list => OKL_API.G_TRUE

753: END IF;
754: END IF; -- end of lv_budget_type_code = 'ADDITION'
755: lv_decision_status_code := 'ACTIVE';
756: okl_subsidy_pool_budget_pvt.set_decision_status_code(p_api_version => '1.0'
757: ,p_init_msg_list => OKL_API.G_TRUE
758: ,x_return_status => x_return_status
759: ,x_msg_count => x_msg_count
760: ,x_msg_data => x_msg_data
761: ,p_sub_pool_budget_id => lv_budget_line_id

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

769: ' x_msg_data '||x_msg_data
770: );
771: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
772:
773: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
774: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
775: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
776: RAISE OKL_API.G_EXCEPTION_ERROR;
777: END IF;

Line 774: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

770: );
771: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
772:
773: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
774: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
775: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
776: RAISE OKL_API.G_EXCEPTION_ERROR;
777: END IF;
778: resultout := 'COMPLETE:';

Line 775: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN

771: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
772:
773: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
774: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
775: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
776: RAISE OKL_API.G_EXCEPTION_ERROR;
777: END IF;
778: resultout := 'COMPLETE:';
779: ELSIF(G_WF_ITM_APPROVED_YN_NO = lv_approval_status OR lv_approval_status_ame = 'N')THEN

Line 776: RAISE OKL_API.G_EXCEPTION_ERROR;

772:
773: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
774: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
775: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
776: RAISE OKL_API.G_EXCEPTION_ERROR;
777: END IF;
778: resultout := 'COMPLETE:';
779: ELSIF(G_WF_ITM_APPROVED_YN_NO = lv_approval_status OR lv_approval_status_ame = 'N')THEN
780: IF(lv_budget_type_code = 'REDUCTION')THEN

Line 783: ,p_init_msg_list => OKL_API.G_TRUE

779: ELSIF(G_WF_ITM_APPROVED_YN_NO = lv_approval_status OR lv_approval_status_ame = 'N')THEN
780: IF(lv_budget_type_code = 'REDUCTION')THEN
781: lv_total_budget := lv_total_budget + lv_line_amount;
782: okl_subsidy_pool_pvt.update_total_budget(p_api_version => '1.0'
783: ,p_init_msg_list => OKL_API.G_TRUE
784: ,x_return_status => x_return_status
785: ,x_msg_count => x_msg_count
786: ,x_msg_data => x_msg_data
787: ,p_subsidy_pool_id => lv_subsidy_pool_id

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

795: ' x_msg_data '||x_msg_data
796: );
797: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
798:
799: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
800: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
801: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
802: RAISE OKL_API.G_EXCEPTION_ERROR;
803: END IF;

Line 800: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

796: );
797: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
798:
799: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
800: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
801: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
802: RAISE OKL_API.G_EXCEPTION_ERROR;
803: END IF;
804: END IF; -- end of lv_budget_type_code = 'REDUCTION'

Line 801: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN

797: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
798:
799: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
800: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
801: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
802: RAISE OKL_API.G_EXCEPTION_ERROR;
803: END IF;
804: END IF; -- end of lv_budget_type_code = 'REDUCTION'
805: lv_decision_status_code := 'REJECTED';

Line 802: RAISE OKL_API.G_EXCEPTION_ERROR;

798:
799: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
800: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
801: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
802: RAISE OKL_API.G_EXCEPTION_ERROR;
803: END IF;
804: END IF; -- end of lv_budget_type_code = 'REDUCTION'
805: lv_decision_status_code := 'REJECTED';
806: okl_subsidy_pool_budget_pvt.set_decision_status_code(p_api_version => '1.0'

Line 807: ,p_init_msg_list => OKL_API.G_TRUE

803: END IF;
804: END IF; -- end of lv_budget_type_code = 'REDUCTION'
805: lv_decision_status_code := 'REJECTED';
806: okl_subsidy_pool_budget_pvt.set_decision_status_code(p_api_version => '1.0'
807: ,p_init_msg_list => OKL_API.G_TRUE
808: ,x_return_status => x_return_status
809: ,x_msg_count => x_msg_count
810: ,x_msg_data => x_msg_data
811: ,p_sub_pool_budget_id => lv_budget_line_id

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

819: ' x_msg_data '||x_msg_data
820: );
821: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
822:
823: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
824: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
825: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
826: RAISE OKL_API.G_EXCEPTION_ERROR;
827: END IF;

Line 824: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

820: );
821: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
822:
823: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
824: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
825: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
826: RAISE OKL_API.G_EXCEPTION_ERROR;
827: END IF;
828: resultout := 'COMPLETE:';

Line 825: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN

821: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
822:
823: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
824: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
825: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
826: RAISE OKL_API.G_EXCEPTION_ERROR;
827: END IF;
828: resultout := 'COMPLETE:';
829: ELSE

Line 826: RAISE OKL_API.G_EXCEPTION_ERROR;

822:
823: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
824: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
825: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
826: RAISE OKL_API.G_EXCEPTION_ERROR;
827: END IF;
828: resultout := 'COMPLETE:';
829: ELSE
830: NULL;

Line 851: WHEN OKL_API.G_EXCEPTION_ERROR THEN

847: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRBWFB.pls call update_line_approval_status');
848: END IF;
849:
850: EXCEPTION
851: WHEN OKL_API.G_EXCEPTION_ERROR THEN
852: wf_core.context(G_PKG_NAME,
853: l_api_name,
854: itemtype,
855: itemkey,

Line 859: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

855: itemkey,
856: TO_CHAR(actid),
857: funcmode);
858: RAISE;
859: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
860: wf_core.context(G_PKG_NAME,
861: l_api_name,
862: itemtype,
863: itemkey,

Line 1343: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1339: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
1340: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRBWFB.pls call raise_pool_event_approval');
1341: END IF;
1342:
1343: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1344: -- Call start_activity to create savepoint, check compatibility and initialize message list
1345: x_return_status := OKL_API.START_ACTIVITY(l_api_name,
1346: p_init_msg_list,
1347: '_PVT',

Line 1345: x_return_status := OKL_API.START_ACTIVITY(l_api_name,

1341: END IF;
1342:
1343: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1344: -- Call start_activity to create savepoint, check compatibility and initialize message list
1345: x_return_status := OKL_API.START_ACTIVITY(l_api_name,
1346: p_init_msg_list,
1347: '_PVT',
1348: x_return_status);
1349: -- Check if activity started successfully

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

1346: p_init_msg_list,
1347: '_PVT',
1348: x_return_status);
1349: -- Check if activity started successfully
1350: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1351: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1352: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1353: RAISE OKL_API.G_EXCEPTION_ERROR;
1354: END IF;

Line 1351: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1347: '_PVT',
1348: x_return_status);
1349: -- Check if activity started successfully
1350: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1351: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1352: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1353: RAISE OKL_API.G_EXCEPTION_ERROR;
1354: END IF;
1355:

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

1348: x_return_status);
1349: -- Check if activity started successfully
1350: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1351: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1352: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1353: RAISE OKL_API.G_EXCEPTION_ERROR;
1354: END IF;
1355:
1356: -- check for logging on STATEMENT level

Line 1353: RAISE OKL_API.G_EXCEPTION_ERROR;

1349: -- Check if activity started successfully
1350: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1351: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1352: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1353: RAISE OKL_API.G_EXCEPTION_ERROR;
1354: END IF;
1355:
1356: -- check for logging on STATEMENT level
1357: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

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

1367: 'l_get_agent return staus '||x_return_status||' l_requester '||l_requester||' l_name '||l_name
1368: );
1369: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
1370:
1371: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1372: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1373: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1374: RAISE OKL_API.G_EXCEPTION_ERROR;
1375: END IF;

Line 1372: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1368: );
1369: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
1370:
1371: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1372: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1373: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1374: RAISE OKL_API.G_EXCEPTION_ERROR;
1375: END IF;
1376:

Line 1373: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN

1369: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
1370:
1371: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1372: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1373: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1374: RAISE OKL_API.G_EXCEPTION_ERROR;
1375: END IF;
1376:
1377: l_approval_option := fnd_profile.value('OKL_SUBSIDY_POOL_APPROVAL_PROCESS');

Line 1374: RAISE OKL_API.G_EXCEPTION_ERROR;

1370:
1371: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1372: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1373: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1374: RAISE OKL_API.G_EXCEPTION_ERROR;
1375: END IF;
1376:
1377: l_approval_option := fnd_profile.value('OKL_SUBSIDY_POOL_APPROVAL_PROCESS');
1378: IF(l_approval_option = G_SUBSIDY_POOL_APPROVAL_AME)THEN

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

1379: -- Get the Application ID
1380: OPEN c_get_app_id_csr;
1381: FETCH c_get_app_id_csr INTO l_application_id;
1382: IF c_get_app_id_csr%NOTFOUND THEN
1383: OKL_API.set_message(p_app_name => G_APP_NAME,
1384: p_msg_name => G_NO_MATCHING_RECORD,
1385: p_token1 => G_COL_NAME_TOKEN,
1386: p_token1_value => 'Application id');
1387: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1387: RAISE OKL_API.G_EXCEPTION_ERROR;

1383: OKL_API.set_message(p_app_name => G_APP_NAME,
1384: p_msg_name => G_NO_MATCHING_RECORD,
1385: p_token1 => G_COL_NAME_TOKEN,
1386: p_token1_value => 'Application id');
1387: RAISE OKL_API.G_EXCEPTION_ERROR;
1388: END IF;
1389: CLOSE c_get_app_id_csr;
1390:
1391: -- Get the Transaction Type ID

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

1392: OPEN c_get_trx_type_csr(G_TRANS_APP_NAME_POOL);
1393: FETCH c_get_trx_type_csr INTO l_trans_type_id,
1394: l_trans_appl_id;
1395: IF c_get_trx_type_csr%NOTFOUND THEN
1396: OKL_API.set_message(p_app_name => G_APP_NAME,
1397: p_msg_name => G_NO_MATCHING_RECORD,
1398: p_token1 => G_COL_NAME_TOKEN,
1399: p_token1_value => 'AME Transcation TYPE id, Application id');
1400: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1400: RAISE OKL_API.G_EXCEPTION_ERROR;

1396: OKL_API.set_message(p_app_name => G_APP_NAME,
1397: p_msg_name => G_NO_MATCHING_RECORD,
1398: p_token1 => G_COL_NAME_TOKEN,
1399: p_token1_value => 'AME Transcation TYPE id, Application id');
1400: RAISE OKL_API.G_EXCEPTION_ERROR;
1401: END IF;
1402: CLOSE c_get_trx_type_csr;
1403: IF l_application_id = l_trans_appl_id THEN
1404: wf_event.AddParameterToList(G_WF_ITM_APPLICATION_ID,l_application_id,l_parameter_list);

Line 1424: RAISE OKL_API.G_EXCEPTION_ERROR;

1420: 'l_approval_option '||l_approval_option||' raising budget line approval event '
1421: );
1422: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
1423: ELSE
1424: RAISE OKL_API.G_EXCEPTION_ERROR;
1425: END IF;
1426:
1427: IF(l_approval_option IN (G_SUBSIDY_POOL_APPROVAL_WF, G_SUBSIDY_POOL_APPROVAL_AME))THEN
1428: OPEN c_get_pool_info_csr (cp_subsidy_pool_id => p_subsidy_pool_id);

Line 1452: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,x_msg_data => x_msg_data);

1448: p_parameters => l_parameter_list);
1449: l_parameter_list.DELETE;
1450: END IF;
1451:
1452: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,x_msg_data => x_msg_data);
1453:
1454: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
1455: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRBWFB.pls call raise_pool_event_approval');
1456: END IF;

Line 1459: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1455: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRBWFB.pls call raise_pool_event_approval');
1456: END IF;
1457:
1458: EXCEPTION
1459: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1460: x_return_status := OKL_API.G_RET_STS_ERROR;
1461: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1462: p_api_name => l_api_name,
1463: p_pkg_name => G_PKG_NAME,

Line 1460: x_return_status := OKL_API.G_RET_STS_ERROR;

1456: END IF;
1457:
1458: EXCEPTION
1459: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1460: x_return_status := OKL_API.G_RET_STS_ERROR;
1461: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1462: p_api_name => l_api_name,
1463: p_pkg_name => G_PKG_NAME,
1464: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 1461: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1457:
1458: EXCEPTION
1459: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1460: x_return_status := OKL_API.G_RET_STS_ERROR;
1461: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1462: p_api_name => l_api_name,
1463: p_pkg_name => G_PKG_NAME,
1464: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1465: x_msg_count => x_msg_count,

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

1460: x_return_status := OKL_API.G_RET_STS_ERROR;
1461: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1462: p_api_name => l_api_name,
1463: p_pkg_name => G_PKG_NAME,
1464: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1465: x_msg_count => x_msg_count,
1466: x_msg_data => x_msg_data,
1467: p_api_type => G_API_TYPE);
1468: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1468: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1464: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1465: x_msg_count => x_msg_count,
1466: x_msg_data => x_msg_data,
1467: p_api_type => G_API_TYPE);
1468: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1469: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1470: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1471: p_api_name => l_api_name,
1472: p_pkg_name => G_PKG_NAME,

Line 1469: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1465: x_msg_count => x_msg_count,
1466: x_msg_data => x_msg_data,
1467: p_api_type => G_API_TYPE);
1468: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1469: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1470: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1471: p_api_name => l_api_name,
1472: p_pkg_name => G_PKG_NAME,
1473: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1470: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1466: x_msg_data => x_msg_data,
1467: p_api_type => G_API_TYPE);
1468: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1469: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1470: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1471: p_api_name => l_api_name,
1472: p_pkg_name => G_PKG_NAME,
1473: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1474: x_msg_count => x_msg_count,

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

1469: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1470: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1471: p_api_name => l_api_name,
1472: p_pkg_name => G_PKG_NAME,
1473: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1474: x_msg_count => x_msg_count,
1475: x_msg_data => x_msg_data,
1476: p_api_type => G_API_TYPE);
1477: WHEN OTHERS THEN

Line 1479: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1475: x_msg_data => x_msg_data,
1476: p_api_type => G_API_TYPE);
1477: WHEN OTHERS THEN
1478: -- store SQL error message on message stack
1479: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1480: p_api_name => l_api_name,
1481: p_pkg_name => G_PKG_NAME,
1482: p_exc_name => 'OTHERS',
1483: x_msg_count => x_msg_count,

Line 1553: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1549: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
1550: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
1551: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRBWFB.pls call raise_budget_event_approval');
1552: END IF;
1553: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1554: -- Call start_activity to create savepoint, check compatibility and initialize message list
1555: x_return_status := OKL_API.START_ACTIVITY(l_api_name,
1556: p_init_msg_list,
1557: '_PVT',

Line 1555: x_return_status := OKL_API.START_ACTIVITY(l_api_name,

1551: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRBWFB.pls call raise_budget_event_approval');
1552: END IF;
1553: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1554: -- Call start_activity to create savepoint, check compatibility and initialize message list
1555: x_return_status := OKL_API.START_ACTIVITY(l_api_name,
1556: p_init_msg_list,
1557: '_PVT',
1558: x_return_status);
1559: -- Check if activity started successfully

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

1556: p_init_msg_list,
1557: '_PVT',
1558: x_return_status);
1559: -- Check if activity started successfully
1560: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1561: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1562: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1563: RAISE OKL_API.G_EXCEPTION_ERROR;
1564: END IF;

Line 1561: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1557: '_PVT',
1558: x_return_status);
1559: -- Check if activity started successfully
1560: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1561: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1562: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1563: RAISE OKL_API.G_EXCEPTION_ERROR;
1564: END IF;
1565:

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

1558: x_return_status);
1559: -- Check if activity started successfully
1560: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1561: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1562: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1563: RAISE OKL_API.G_EXCEPTION_ERROR;
1564: END IF;
1565:
1566: -- check for logging on STATEMENT level

Line 1563: RAISE OKL_API.G_EXCEPTION_ERROR;

1559: -- Check if activity started successfully
1560: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1561: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1562: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1563: RAISE OKL_API.G_EXCEPTION_ERROR;
1564: END IF;
1565:
1566: -- check for logging on STATEMENT level
1567: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

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

1577: 'l_get_agent return staus '||x_return_status||' l_requester '||l_requester||' l_name '||l_name
1578: );
1579: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
1580:
1581: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1582: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1583: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1584: RAISE OKL_API.G_EXCEPTION_ERROR;
1585: END IF;

Line 1582: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1578: );
1579: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
1580:
1581: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1582: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1583: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1584: RAISE OKL_API.G_EXCEPTION_ERROR;
1585: END IF;
1586:

Line 1583: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN

1579: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
1580:
1581: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1582: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1583: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1584: RAISE OKL_API.G_EXCEPTION_ERROR;
1585: END IF;
1586:
1587: l_approval_option := fnd_profile.value('OKL_SUBSIDY_POOL_APPROVAL_PROCESS');

Line 1584: RAISE OKL_API.G_EXCEPTION_ERROR;

1580:
1581: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1582: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1583: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1584: RAISE OKL_API.G_EXCEPTION_ERROR;
1585: END IF;
1586:
1587: l_approval_option := fnd_profile.value('OKL_SUBSIDY_POOL_APPROVAL_PROCESS');
1588: IF(l_approval_option = G_SUBSIDY_POOL_APPROVAL_AME)THEN

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

1589: -- Get the Application ID
1590: OPEN c_get_app_id_csr;
1591: FETCH c_get_app_id_csr INTO l_application_id;
1592: IF c_get_app_id_csr%NOTFOUND THEN
1593: OKL_API.set_message(p_app_name => G_APP_NAME,
1594: p_msg_name => G_NO_MATCHING_RECORD,
1595: p_token1 => G_COL_NAME_TOKEN,
1596: p_token1_value => 'Application id');
1597: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1597: RAISE OKL_API.G_EXCEPTION_ERROR;

1593: OKL_API.set_message(p_app_name => G_APP_NAME,
1594: p_msg_name => G_NO_MATCHING_RECORD,
1595: p_token1 => G_COL_NAME_TOKEN,
1596: p_token1_value => 'Application id');
1597: RAISE OKL_API.G_EXCEPTION_ERROR;
1598: END IF;
1599: CLOSE c_get_app_id_csr;
1600:
1601: -- Get the Transaction Type ID

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

1602: OPEN c_get_trx_type_csr(G_TRANS_APP_NAME_LINE);
1603: FETCH c_get_trx_type_csr INTO l_trans_type_id,
1604: l_trans_appl_id;
1605: IF c_get_trx_type_csr%NOTFOUND THEN
1606: OKL_API.set_message(p_app_name => G_APP_NAME,
1607: p_msg_name => G_NO_MATCHING_RECORD,
1608: p_token1 => G_COL_NAME_TOKEN,
1609: p_token1_value => 'AME Transcation TYPE id, Application id');
1610: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1610: RAISE OKL_API.G_EXCEPTION_ERROR;

1606: OKL_API.set_message(p_app_name => G_APP_NAME,
1607: p_msg_name => G_NO_MATCHING_RECORD,
1608: p_token1 => G_COL_NAME_TOKEN,
1609: p_token1_value => 'AME Transcation TYPE id, Application id');
1610: RAISE OKL_API.G_EXCEPTION_ERROR;
1611: END IF;
1612: CLOSE c_get_trx_type_csr;
1613: IF l_application_id = l_trans_appl_id THEN
1614: wf_event.AddParameterToList(G_WF_ITM_APPLICATION_ID,l_application_id,l_parameter_list);

Line 1634: RAISE OKL_API.G_EXCEPTION_ERROR;

1630: 'l_approval_option '||l_approval_option||' raising budget line approval event '
1631: );
1632: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
1633: ELSE
1634: RAISE OKL_API.G_EXCEPTION_ERROR;
1635: END IF;
1636: IF(l_approval_option IN (G_SUBSIDY_POOL_APPROVAL_WF, G_SUBSIDY_POOL_APPROVAL_AME))THEN
1637: OPEN c_get_budget_info_csr(cp_pool_budget_id => p_subsidy_pool_budget_id);
1638: FETCH c_get_budget_info_csr INTO cv_get_budget_info;

Line 1666: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,x_msg_data => x_msg_data);

1662: p_parameters => l_parameter_list);
1663: l_parameter_list.DELETE;
1664: END IF;
1665:
1666: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,x_msg_data => x_msg_data);
1667: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
1668: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRBWFB.pls call raise_budget_event_approval');
1669: END IF;
1670:

Line 1672: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1668: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRBWFB.pls call raise_budget_event_approval');
1669: END IF;
1670:
1671: EXCEPTION
1672: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1673: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1674: p_api_name => l_api_name,
1675: p_pkg_name => G_PKG_NAME,
1676: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 1673: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1669: END IF;
1670:
1671: EXCEPTION
1672: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1673: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1674: p_api_name => l_api_name,
1675: p_pkg_name => G_PKG_NAME,
1676: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1677: x_msg_count => x_msg_count,

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

1672: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1673: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1674: p_api_name => l_api_name,
1675: p_pkg_name => G_PKG_NAME,
1676: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1677: x_msg_count => x_msg_count,
1678: x_msg_data => x_msg_data,
1679: p_api_type => G_API_TYPE);
1680: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1680: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1676: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1677: x_msg_count => x_msg_count,
1678: x_msg_data => x_msg_data,
1679: p_api_type => G_API_TYPE);
1680: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1681: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1682: p_api_name => l_api_name,
1683: p_pkg_name => G_PKG_NAME,
1684: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1681: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1677: x_msg_count => x_msg_count,
1678: x_msg_data => x_msg_data,
1679: p_api_type => G_API_TYPE);
1680: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1681: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1682: p_api_name => l_api_name,
1683: p_pkg_name => G_PKG_NAME,
1684: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1685: x_msg_count => x_msg_count,

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

1680: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1681: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1682: p_api_name => l_api_name,
1683: p_pkg_name => G_PKG_NAME,
1684: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1685: x_msg_count => x_msg_count,
1686: x_msg_data => x_msg_data,
1687: p_api_type => G_API_TYPE);
1688: WHEN OTHERS THEN

Line 1690: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1686: x_msg_data => x_msg_data,
1687: p_api_type => G_API_TYPE);
1688: WHEN OTHERS THEN
1689: -- store SQL error message on message stack
1690: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1691: p_api_name => l_api_name,
1692: p_pkg_name => G_PKG_NAME,
1693: p_exc_name => 'OTHERS',
1694: x_msg_count => x_msg_count,