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.2 2006/09/28 06:04:57 zrehman noship $ */
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 1341: x_return_status := OKL_API.G_RET_STS_SUCCESS;

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

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

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

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

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

Line 1349: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

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

Line 1351: RAISE OKL_API.G_EXCEPTION_ERROR;

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

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

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

Line 1370: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

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

Line 1372: RAISE OKL_API.G_EXCEPTION_ERROR;

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

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

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

Line 1385: RAISE OKL_API.G_EXCEPTION_ERROR;

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

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

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

Line 1398: RAISE OKL_API.G_EXCEPTION_ERROR;

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

Line 1422: RAISE OKL_API.G_EXCEPTION_ERROR;

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

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

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

Line 1457: WHEN OKL_API.G_EXCEPTION_ERROR THEN

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

Line 1458: x_return_status := OKL_API.G_RET_STS_ERROR;

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

Line 1459: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

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

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

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

Line 1466: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 1467: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

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

Line 1468: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

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

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

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

Line 1477: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

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

Line 1549: x_return_status := OKL_API.G_RET_STS_SUCCESS;

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

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

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

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

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

Line 1557: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

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

Line 1559: RAISE OKL_API.G_EXCEPTION_ERROR;

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

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

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

Line 1578: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

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

Line 1580: RAISE OKL_API.G_EXCEPTION_ERROR;

1576:
1577: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1578: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1579: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1580: RAISE OKL_API.G_EXCEPTION_ERROR;
1581: END IF;
1582:
1583: l_approval_option := fnd_profile.value('OKL_SUBSIDY_POOL_APPROVAL_PROCESS');
1584: IF(l_approval_option = G_SUBSIDY_POOL_APPROVAL_AME)THEN

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

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

Line 1593: RAISE OKL_API.G_EXCEPTION_ERROR;

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

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

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

Line 1606: RAISE OKL_API.G_EXCEPTION_ERROR;

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

Line 1630: RAISE OKL_API.G_EXCEPTION_ERROR;

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

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

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

Line 1668: WHEN OKL_API.G_EXCEPTION_ERROR THEN

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

Line 1669: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1665: END IF;
1666:
1667: EXCEPTION
1668: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1669: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1670: p_api_name => l_api_name,
1671: p_pkg_name => G_PKG_NAME,
1672: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1673: x_msg_count => x_msg_count,

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

1668: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1669: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1670: p_api_name => l_api_name,
1671: p_pkg_name => G_PKG_NAME,
1672: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1673: x_msg_count => x_msg_count,
1674: x_msg_data => x_msg_data,
1675: p_api_type => G_API_TYPE);
1676: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1676: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 1677: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

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

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

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

Line 1686: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

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