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.OKE_DELIVERABLE_UTILS_PUB dependencies on OKE_API

Line 537: L_Return_Status := OKE_API.Start_Activity (

533:
534:
535: BEGIN
536:
537: L_Return_Status := OKE_API.Start_Activity (
538: P_Api_Name => L_Api_Name,
539: P_Init_Msg_List => L_Init_Msg_List,
540: P_API_Type => G_API_Type,
541: X_Return_Status => X_Return_Status );

Line 542: IF ( L_Return_Status = OKE_API.G_RET_STS_ERROR ) THEN

538: P_Api_Name => L_Api_Name,
539: P_Init_Msg_List => L_Init_Msg_List,
540: P_API_Type => G_API_Type,
541: X_Return_Status => X_Return_Status );
542: IF ( L_Return_Status = OKE_API.G_RET_STS_ERROR ) THEN
543: RAISE OKE_API.G_Exception_Error;
544: ELSIF ( L_Return_Status = OKE_API.G_RET_STS_UNEXP_ERROR ) THEN
545: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
546: END IF;

Line 543: RAISE OKE_API.G_Exception_Error;

539: P_Init_Msg_List => L_Init_Msg_List,
540: P_API_Type => G_API_Type,
541: X_Return_Status => X_Return_Status );
542: IF ( L_Return_Status = OKE_API.G_RET_STS_ERROR ) THEN
543: RAISE OKE_API.G_Exception_Error;
544: ELSIF ( L_Return_Status = OKE_API.G_RET_STS_UNEXP_ERROR ) THEN
545: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
546: END IF;
547:

Line 544: ELSIF ( L_Return_Status = OKE_API.G_RET_STS_UNEXP_ERROR ) THEN

540: P_API_Type => G_API_Type,
541: X_Return_Status => X_Return_Status );
542: IF ( L_Return_Status = OKE_API.G_RET_STS_ERROR ) THEN
543: RAISE OKE_API.G_Exception_Error;
544: ELSIF ( L_Return_Status = OKE_API.G_RET_STS_UNEXP_ERROR ) THEN
545: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
546: END IF;
547:
548: IF P_Source_Project_ID IS NULL

Line 545: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

541: X_Return_Status => X_Return_Status );
542: IF ( L_Return_Status = OKE_API.G_RET_STS_ERROR ) THEN
543: RAISE OKE_API.G_Exception_Error;
544: ELSIF ( L_Return_Status = OKE_API.G_RET_STS_UNEXP_ERROR ) THEN
545: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
546: END IF;
547:
548: IF P_Source_Project_ID IS NULL
549: OR P_Target_Project_ID IS NULL

Line 555: RAISE OKE_API.G_Exception_Error;

551: OR P_Target_Deliverable_ID IS NULL THEN
552:
553: FND_MESSAGE.Set_Name ( 'OKE', 'OKE_REQ_PARAMETER');
554: FND_MSG_PUB.Add;
555: RAISE OKE_API.G_Exception_Error;
556:
557: END IF;
558:
559: SELECT oke_k_deliverables_s.nextval

Line 680: OKE_API.End_Activity ( X_Msg_Count => X_Msg_Count

676: where T.DELIVERABLE_ID = l_id
677: and T.LANGUAGE = L.LANGUAGE_CODE);
678:
679:
680: OKE_API.End_Activity ( X_Msg_Count => X_Msg_Count
681: , X_Msg_Data => X_Msg_Data );
682:
683: EXCEPTION
684: when OKE_API.G_EXCEPTION_ERROR then

Line 684: when OKE_API.G_EXCEPTION_ERROR then

680: OKE_API.End_Activity ( X_Msg_Count => X_Msg_Count
681: , X_Msg_Data => X_Msg_Data );
682:
683: EXCEPTION
684: when OKE_API.G_EXCEPTION_ERROR then
685: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
686: p_api_name => l_api_name,
687: p_pkg_name => g_pkg_name,
688: p_exc_name => 'OKE_API.G_RET_STS_ERROR',

Line 685: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

681: , X_Msg_Data => X_Msg_Data );
682:
683: EXCEPTION
684: when OKE_API.G_EXCEPTION_ERROR then
685: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
686: p_api_name => l_api_name,
687: p_pkg_name => g_pkg_name,
688: p_exc_name => 'OKE_API.G_RET_STS_ERROR',
689: x_msg_count => x_msg_count,

Line 688: p_exc_name => 'OKE_API.G_RET_STS_ERROR',

684: when OKE_API.G_EXCEPTION_ERROR then
685: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
686: p_api_name => l_api_name,
687: p_pkg_name => g_pkg_name,
688: p_exc_name => 'OKE_API.G_RET_STS_ERROR',
689: x_msg_count => x_msg_count,
690: x_msg_data => x_msg_data,
691: p_api_type => g_api_type);
692:

Line 693: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then

689: x_msg_count => x_msg_count,
690: x_msg_data => x_msg_data,
691: p_api_type => g_api_type);
692:
693: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
694: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
695: p_api_name => l_api_name,
696: p_pkg_name => g_pkg_name,
697: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',

Line 694: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

690: x_msg_data => x_msg_data,
691: p_api_type => g_api_type);
692:
693: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
694: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
695: p_api_name => l_api_name,
696: p_pkg_name => g_pkg_name,
697: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',
698: x_msg_count => x_msg_count,

Line 697: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',

693: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
694: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
695: p_api_name => l_api_name,
696: p_pkg_name => g_pkg_name,
697: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',
698: x_msg_count => x_msg_count,
699: x_msg_data => x_msg_data,
700: p_api_type => g_api_type);
701:

Line 703: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

699: x_msg_data => x_msg_data,
700: p_api_type => g_api_type);
701:
702: when OTHERS then
703: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
704: p_api_name => l_api_name,
705: p_pkg_name => g_pkg_name,
706: p_exc_name => 'OTHERS',
707: x_msg_count => x_msg_count,

Line 747: L_Return_Status := OKE_API.Start_Activity (

743: AND source_deliverable_id = p_target_deliverable_id;
744:
745: BEGIN
746:
747: L_Return_Status := OKE_API.Start_Activity (
748: P_Api_Name => L_Api_Name,
749: P_Init_Msg_List => L_Init_Msg_List,
750: P_API_Type => G_API_Type,
751: X_Return_Status => X_Return_Status );

Line 752: IF ( L_Return_Status = OKE_API.G_RET_STS_ERROR ) THEN

748: P_Api_Name => L_Api_Name,
749: P_Init_Msg_List => L_Init_Msg_List,
750: P_API_Type => G_API_Type,
751: X_Return_Status => X_Return_Status );
752: IF ( L_Return_Status = OKE_API.G_RET_STS_ERROR ) THEN
753: RAISE OKE_API.G_Exception_Error;
754: ELSIF ( L_Return_Status = OKE_API.G_RET_STS_UNEXP_ERROR ) THEN
755: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
756: END IF;

Line 753: RAISE OKE_API.G_Exception_Error;

749: P_Init_Msg_List => L_Init_Msg_List,
750: P_API_Type => G_API_Type,
751: X_Return_Status => X_Return_Status );
752: IF ( L_Return_Status = OKE_API.G_RET_STS_ERROR ) THEN
753: RAISE OKE_API.G_Exception_Error;
754: ELSIF ( L_Return_Status = OKE_API.G_RET_STS_UNEXP_ERROR ) THEN
755: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
756: END IF;
757:

Line 754: ELSIF ( L_Return_Status = OKE_API.G_RET_STS_UNEXP_ERROR ) THEN

750: P_API_Type => G_API_Type,
751: X_Return_Status => X_Return_Status );
752: IF ( L_Return_Status = OKE_API.G_RET_STS_ERROR ) THEN
753: RAISE OKE_API.G_Exception_Error;
754: ELSIF ( L_Return_Status = OKE_API.G_RET_STS_UNEXP_ERROR ) THEN
755: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
756: END IF;
757:
758: IF P_Source_Project_ID IS NULL

Line 755: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

751: X_Return_Status => X_Return_Status );
752: IF ( L_Return_Status = OKE_API.G_RET_STS_ERROR ) THEN
753: RAISE OKE_API.G_Exception_Error;
754: ELSIF ( L_Return_Status = OKE_API.G_RET_STS_UNEXP_ERROR ) THEN
755: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
756: END IF;
757:
758: IF P_Source_Project_ID IS NULL
759: OR P_Target_Project_ID IS NULL

Line 767: RAISE OKE_API.G_Exception_Error;

763: OR P_Target_Action_ID IS NULL THEN
764:
765: FND_MESSAGE.Set_Name ( 'OKE', 'OKE_REQ_PARAMETER');
766: FND_MSG_PUB.Add;
767: RAISE OKE_API.G_Exception_Error;
768:
769: END IF;
770:
771: OPEN c;

Line 855: OKE_API.End_Activity ( X_Msg_Count => X_Msg_Count

851: , Decode( l_Item_Based_YN, 'Y', l_uom_code, uom_code)
852: FROM oke_deliverable_actions
853: WHERE pa_action_id = p_source_action_id;
854:
855: OKE_API.End_Activity ( X_Msg_Count => X_Msg_Count
856: , X_Msg_Data => X_Msg_Data );
857:
858: EXCEPTION
859: when OKE_API.G_EXCEPTION_ERROR then

Line 859: when OKE_API.G_EXCEPTION_ERROR then

855: OKE_API.End_Activity ( X_Msg_Count => X_Msg_Count
856: , X_Msg_Data => X_Msg_Data );
857:
858: EXCEPTION
859: when OKE_API.G_EXCEPTION_ERROR then
860: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
861: p_api_name => l_api_name,
862: p_pkg_name => g_pkg_name,
863: p_exc_name => 'OKE_API.G_RET_STS_ERROR',

Line 860: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

856: , X_Msg_Data => X_Msg_Data );
857:
858: EXCEPTION
859: when OKE_API.G_EXCEPTION_ERROR then
860: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
861: p_api_name => l_api_name,
862: p_pkg_name => g_pkg_name,
863: p_exc_name => 'OKE_API.G_RET_STS_ERROR',
864: x_msg_count => x_msg_count,

Line 863: p_exc_name => 'OKE_API.G_RET_STS_ERROR',

859: when OKE_API.G_EXCEPTION_ERROR then
860: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
861: p_api_name => l_api_name,
862: p_pkg_name => g_pkg_name,
863: p_exc_name => 'OKE_API.G_RET_STS_ERROR',
864: x_msg_count => x_msg_count,
865: x_msg_data => x_msg_data,
866: p_api_type => g_api_type);
867:

Line 868: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then

864: x_msg_count => x_msg_count,
865: x_msg_data => x_msg_data,
866: p_api_type => g_api_type);
867:
868: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
869: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
870: p_api_name => l_api_name,
871: p_pkg_name => g_pkg_name,
872: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',

Line 869: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

865: x_msg_data => x_msg_data,
866: p_api_type => g_api_type);
867:
868: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
869: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
870: p_api_name => l_api_name,
871: p_pkg_name => g_pkg_name,
872: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',
873: x_msg_count => x_msg_count,

Line 872: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',

868: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
869: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
870: p_api_name => l_api_name,
871: p_pkg_name => g_pkg_name,
872: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',
873: x_msg_count => x_msg_count,
874: x_msg_data => x_msg_data,
875: p_api_type => g_api_type);
876:

Line 878: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

874: x_msg_data => x_msg_data,
875: p_api_type => g_api_type);
876:
877: when OTHERS then
878: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
879: p_api_name => l_api_name,
880: p_pkg_name => g_pkg_name,
881: p_exc_name => 'OTHERS',
882: x_msg_count => x_msg_count,

Line 899: L_Return_Status := OKE_API.Start_Activity (

895: L_Return_Status VARCHAR2(1);
896:
897: BEGIN
898:
899: L_Return_Status := OKE_API.Start_Activity (
900: P_Api_Name => L_Api_Name,
901: P_Init_Msg_List => L_Init_Msg_List,
902: P_API_Type => G_API_Type,
903: X_Return_Status => X_Return_Status );

Line 904: IF ( L_Return_Status = OKE_API.G_RET_STS_ERROR ) THEN

900: P_Api_Name => L_Api_Name,
901: P_Init_Msg_List => L_Init_Msg_List,
902: P_API_Type => G_API_Type,
903: X_Return_Status => X_Return_Status );
904: IF ( L_Return_Status = OKE_API.G_RET_STS_ERROR ) THEN
905: RAISE OKE_API.G_Exception_Error;
906: ELSIF ( L_Return_Status = OKE_API.G_RET_STS_UNEXP_ERROR ) THEN
907: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
908: END IF;

Line 905: RAISE OKE_API.G_Exception_Error;

901: P_Init_Msg_List => L_Init_Msg_List,
902: P_API_Type => G_API_Type,
903: X_Return_Status => X_Return_Status );
904: IF ( L_Return_Status = OKE_API.G_RET_STS_ERROR ) THEN
905: RAISE OKE_API.G_Exception_Error;
906: ELSIF ( L_Return_Status = OKE_API.G_RET_STS_UNEXP_ERROR ) THEN
907: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
908: END IF;
909:

Line 906: ELSIF ( L_Return_Status = OKE_API.G_RET_STS_UNEXP_ERROR ) THEN

902: P_API_Type => G_API_Type,
903: X_Return_Status => X_Return_Status );
904: IF ( L_Return_Status = OKE_API.G_RET_STS_ERROR ) THEN
905: RAISE OKE_API.G_Exception_Error;
906: ELSIF ( L_Return_Status = OKE_API.G_RET_STS_UNEXP_ERROR ) THEN
907: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
908: END IF;
909:
910: OKE_DELIVERABLE_ACTIONS_PKG.Delete_Action ( P_Action_ID );

Line 907: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

903: X_Return_Status => X_Return_Status );
904: IF ( L_Return_Status = OKE_API.G_RET_STS_ERROR ) THEN
905: RAISE OKE_API.G_Exception_Error;
906: ELSIF ( L_Return_Status = OKE_API.G_RET_STS_UNEXP_ERROR ) THEN
907: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
908: END IF;
909:
910: OKE_DELIVERABLE_ACTIONS_PKG.Delete_Action ( P_Action_ID );
911:

Line 913: OKE_API.End_Activity ( X_Msg_Count => X_Msg_Count

909:
910: OKE_DELIVERABLE_ACTIONS_PKG.Delete_Action ( P_Action_ID );
911:
912: X_Return_Status := L_Return_Status;
913: OKE_API.End_Activity ( X_Msg_Count => X_Msg_Count
914: , X_Msg_Data => X_Msg_Data );
915: EXCEPTION
916: when OKE_API.G_EXCEPTION_ERROR then
917: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

Line 916: when OKE_API.G_EXCEPTION_ERROR then

912: X_Return_Status := L_Return_Status;
913: OKE_API.End_Activity ( X_Msg_Count => X_Msg_Count
914: , X_Msg_Data => X_Msg_Data );
915: EXCEPTION
916: when OKE_API.G_EXCEPTION_ERROR then
917: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
918: p_api_name => l_api_name,
919: p_pkg_name => g_pkg_name,
920: p_exc_name => 'OKE_API.G_RET_STS_ERROR',

Line 917: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

913: OKE_API.End_Activity ( X_Msg_Count => X_Msg_Count
914: , X_Msg_Data => X_Msg_Data );
915: EXCEPTION
916: when OKE_API.G_EXCEPTION_ERROR then
917: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
918: p_api_name => l_api_name,
919: p_pkg_name => g_pkg_name,
920: p_exc_name => 'OKE_API.G_RET_STS_ERROR',
921: x_msg_count => x_msg_count,

Line 920: p_exc_name => 'OKE_API.G_RET_STS_ERROR',

916: when OKE_API.G_EXCEPTION_ERROR then
917: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
918: p_api_name => l_api_name,
919: p_pkg_name => g_pkg_name,
920: p_exc_name => 'OKE_API.G_RET_STS_ERROR',
921: x_msg_count => x_msg_count,
922: x_msg_data => x_msg_data,
923: p_api_type => g_api_type);
924:

Line 925: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then

921: x_msg_count => x_msg_count,
922: x_msg_data => x_msg_data,
923: p_api_type => g_api_type);
924:
925: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
926: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
927: p_api_name => l_api_name,
928: p_pkg_name => g_pkg_name,
929: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',

Line 926: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

922: x_msg_data => x_msg_data,
923: p_api_type => g_api_type);
924:
925: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
926: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
927: p_api_name => l_api_name,
928: p_pkg_name => g_pkg_name,
929: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',
930: x_msg_count => x_msg_count,

Line 929: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',

925: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
926: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
927: p_api_name => l_api_name,
928: p_pkg_name => g_pkg_name,
929: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',
930: x_msg_count => x_msg_count,
931: x_msg_data => x_msg_data,
932: p_api_type => g_api_type);
933:

Line 935: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

931: x_msg_data => x_msg_data,
932: p_api_type => g_api_type);
933:
934: when OTHERS then
935: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
936: p_api_name => l_api_name,
937: p_pkg_name => g_pkg_name,
938: p_exc_name => 'OTHERS',
939: x_msg_count => x_msg_count,

Line 956: L_Return_Status := OKE_API.Start_Activity (

952: L_Return_Status VARCHAR2(1);
953:
954: BEGIN
955:
956: L_Return_Status := OKE_API.Start_Activity (
957: P_Api_Name => L_Api_Name,
958: P_Init_Msg_List => L_Init_Msg_List,
959: P_API_Type => G_API_Type,
960: X_Return_Status => X_Return_Status );

Line 961: IF ( L_Return_Status = OKE_API.G_RET_STS_ERROR ) THEN

957: P_Api_Name => L_Api_Name,
958: P_Init_Msg_List => L_Init_Msg_List,
959: P_API_Type => G_API_Type,
960: X_Return_Status => X_Return_Status );
961: IF ( L_Return_Status = OKE_API.G_RET_STS_ERROR ) THEN
962: RAISE OKE_API.G_Exception_Error;
963: ELSIF ( L_Return_Status = OKE_API.G_RET_STS_UNEXP_ERROR ) THEN
964: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
965: END IF;

Line 962: RAISE OKE_API.G_Exception_Error;

958: P_Init_Msg_List => L_Init_Msg_List,
959: P_API_Type => G_API_Type,
960: X_Return_Status => X_Return_Status );
961: IF ( L_Return_Status = OKE_API.G_RET_STS_ERROR ) THEN
962: RAISE OKE_API.G_Exception_Error;
963: ELSIF ( L_Return_Status = OKE_API.G_RET_STS_UNEXP_ERROR ) THEN
964: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
965: END IF;
966:

Line 963: ELSIF ( L_Return_Status = OKE_API.G_RET_STS_UNEXP_ERROR ) THEN

959: P_API_Type => G_API_Type,
960: X_Return_Status => X_Return_Status );
961: IF ( L_Return_Status = OKE_API.G_RET_STS_ERROR ) THEN
962: RAISE OKE_API.G_Exception_Error;
963: ELSIF ( L_Return_Status = OKE_API.G_RET_STS_UNEXP_ERROR ) THEN
964: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
965: END IF;
966:
967: OKE_DELIVERABLE_ACTIONS_PKG.Delete_Row ( P_Action_ID );

Line 964: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

960: X_Return_Status => X_Return_Status );
961: IF ( L_Return_Status = OKE_API.G_RET_STS_ERROR ) THEN
962: RAISE OKE_API.G_Exception_Error;
963: ELSIF ( L_Return_Status = OKE_API.G_RET_STS_UNEXP_ERROR ) THEN
964: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
965: END IF;
966:
967: OKE_DELIVERABLE_ACTIONS_PKG.Delete_Row ( P_Action_ID );
968:

Line 970: OKE_API.End_Activity ( X_Msg_Count => X_Msg_Count

966:
967: OKE_DELIVERABLE_ACTIONS_PKG.Delete_Row ( P_Action_ID );
968:
969: X_Return_Status := L_Return_Status;
970: OKE_API.End_Activity ( X_Msg_Count => X_Msg_Count
971: , X_Msg_Data => X_Msg_Data );
972: EXCEPTION
973: when OKE_API.G_EXCEPTION_ERROR then
974: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

Line 973: when OKE_API.G_EXCEPTION_ERROR then

969: X_Return_Status := L_Return_Status;
970: OKE_API.End_Activity ( X_Msg_Count => X_Msg_Count
971: , X_Msg_Data => X_Msg_Data );
972: EXCEPTION
973: when OKE_API.G_EXCEPTION_ERROR then
974: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
975: p_api_name => l_api_name,
976: p_pkg_name => g_pkg_name,
977: p_exc_name => 'OKE_API.G_RET_STS_ERROR',

Line 974: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

970: OKE_API.End_Activity ( X_Msg_Count => X_Msg_Count
971: , X_Msg_Data => X_Msg_Data );
972: EXCEPTION
973: when OKE_API.G_EXCEPTION_ERROR then
974: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
975: p_api_name => l_api_name,
976: p_pkg_name => g_pkg_name,
977: p_exc_name => 'OKE_API.G_RET_STS_ERROR',
978: x_msg_count => x_msg_count,

Line 977: p_exc_name => 'OKE_API.G_RET_STS_ERROR',

973: when OKE_API.G_EXCEPTION_ERROR then
974: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
975: p_api_name => l_api_name,
976: p_pkg_name => g_pkg_name,
977: p_exc_name => 'OKE_API.G_RET_STS_ERROR',
978: x_msg_count => x_msg_count,
979: x_msg_data => x_msg_data,
980: p_api_type => g_api_type);
981:

Line 982: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then

978: x_msg_count => x_msg_count,
979: x_msg_data => x_msg_data,
980: p_api_type => g_api_type);
981:
982: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
983: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
984: p_api_name => l_api_name,
985: p_pkg_name => g_pkg_name,
986: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',

Line 983: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

979: x_msg_data => x_msg_data,
980: p_api_type => g_api_type);
981:
982: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
983: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
984: p_api_name => l_api_name,
985: p_pkg_name => g_pkg_name,
986: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',
987: x_msg_count => x_msg_count,

Line 986: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',

982: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
983: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
984: p_api_name => l_api_name,
985: p_pkg_name => g_pkg_name,
986: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',
987: x_msg_count => x_msg_count,
988: x_msg_data => x_msg_data,
989: p_api_type => g_api_type);
990:

Line 992: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

988: x_msg_data => x_msg_data,
989: p_api_type => g_api_type);
990:
991: when OTHERS then
992: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
993: p_api_name => l_api_name,
994: p_pkg_name => g_pkg_name,
995: p_exc_name => 'OTHERS',
996: x_msg_count => x_msg_count,

Line 1013: L_Return_Status := OKE_API.Start_Activity (

1009: L_Return_Status VARCHAR2(1);
1010:
1011: BEGIN
1012:
1013: L_Return_Status := OKE_API.Start_Activity (
1014: P_Api_Name => L_Api_Name,
1015: P_Init_Msg_List => L_Init_Msg_List,
1016: P_API_Type => G_API_Type,
1017: X_Return_Status => X_Return_Status );

Line 1018: IF ( L_Return_Status = OKE_API.G_RET_STS_ERROR ) THEN

1014: P_Api_Name => L_Api_Name,
1015: P_Init_Msg_List => L_Init_Msg_List,
1016: P_API_Type => G_API_Type,
1017: X_Return_Status => X_Return_Status );
1018: IF ( L_Return_Status = OKE_API.G_RET_STS_ERROR ) THEN
1019: RAISE OKE_API.G_Exception_Error;
1020: ELSIF ( L_Return_Status = OKE_API.G_RET_STS_UNEXP_ERROR ) THEN
1021: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1022: END IF;

Line 1019: RAISE OKE_API.G_Exception_Error;

1015: P_Init_Msg_List => L_Init_Msg_List,
1016: P_API_Type => G_API_Type,
1017: X_Return_Status => X_Return_Status );
1018: IF ( L_Return_Status = OKE_API.G_RET_STS_ERROR ) THEN
1019: RAISE OKE_API.G_Exception_Error;
1020: ELSIF ( L_Return_Status = OKE_API.G_RET_STS_UNEXP_ERROR ) THEN
1021: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1022: END IF;
1023:

Line 1020: ELSIF ( L_Return_Status = OKE_API.G_RET_STS_UNEXP_ERROR ) THEN

1016: P_API_Type => G_API_Type,
1017: X_Return_Status => X_Return_Status );
1018: IF ( L_Return_Status = OKE_API.G_RET_STS_ERROR ) THEN
1019: RAISE OKE_API.G_Exception_Error;
1020: ELSIF ( L_Return_Status = OKE_API.G_RET_STS_UNEXP_ERROR ) THEN
1021: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1022: END IF;
1023:
1024: OKE_DELIVERABLE_ACTIONS_PKG.Delete_Deliverable ( P_Deliverable_ID );

Line 1021: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

1017: X_Return_Status => X_Return_Status );
1018: IF ( L_Return_Status = OKE_API.G_RET_STS_ERROR ) THEN
1019: RAISE OKE_API.G_Exception_Error;
1020: ELSIF ( L_Return_Status = OKE_API.G_RET_STS_UNEXP_ERROR ) THEN
1021: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1022: END IF;
1023:
1024: OKE_DELIVERABLE_ACTIONS_PKG.Delete_Deliverable ( P_Deliverable_ID );
1025:

Line 1027: OKE_API.End_Activity ( X_Msg_Count => X_Msg_Count

1023:
1024: OKE_DELIVERABLE_ACTIONS_PKG.Delete_Deliverable ( P_Deliverable_ID );
1025:
1026: X_Return_Status := L_Return_Status;
1027: OKE_API.End_Activity ( X_Msg_Count => X_Msg_Count
1028: , X_Msg_Data => X_Msg_Data );
1029: EXCEPTION
1030: when OKE_API.G_EXCEPTION_ERROR then
1031: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

Line 1030: when OKE_API.G_EXCEPTION_ERROR then

1026: X_Return_Status := L_Return_Status;
1027: OKE_API.End_Activity ( X_Msg_Count => X_Msg_Count
1028: , X_Msg_Data => X_Msg_Data );
1029: EXCEPTION
1030: when OKE_API.G_EXCEPTION_ERROR then
1031: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
1032: p_api_name => l_api_name,
1033: p_pkg_name => g_pkg_name,
1034: p_exc_name => 'OKE_API.G_RET_STS_ERROR',

Line 1031: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

1027: OKE_API.End_Activity ( X_Msg_Count => X_Msg_Count
1028: , X_Msg_Data => X_Msg_Data );
1029: EXCEPTION
1030: when OKE_API.G_EXCEPTION_ERROR then
1031: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
1032: p_api_name => l_api_name,
1033: p_pkg_name => g_pkg_name,
1034: p_exc_name => 'OKE_API.G_RET_STS_ERROR',
1035: x_msg_count => x_msg_count,

Line 1034: p_exc_name => 'OKE_API.G_RET_STS_ERROR',

1030: when OKE_API.G_EXCEPTION_ERROR then
1031: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
1032: p_api_name => l_api_name,
1033: p_pkg_name => g_pkg_name,
1034: p_exc_name => 'OKE_API.G_RET_STS_ERROR',
1035: x_msg_count => x_msg_count,
1036: x_msg_data => x_msg_data,
1037: p_api_type => g_api_type);
1038:

Line 1039: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then

1035: x_msg_count => x_msg_count,
1036: x_msg_data => x_msg_data,
1037: p_api_type => g_api_type);
1038:
1039: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
1040: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
1041: p_api_name => l_api_name,
1042: p_pkg_name => g_pkg_name,
1043: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',

Line 1040: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

1036: x_msg_data => x_msg_data,
1037: p_api_type => g_api_type);
1038:
1039: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
1040: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
1041: p_api_name => l_api_name,
1042: p_pkg_name => g_pkg_name,
1043: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',
1044: x_msg_count => x_msg_count,

Line 1043: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',

1039: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
1040: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
1041: p_api_name => l_api_name,
1042: p_pkg_name => g_pkg_name,
1043: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',
1044: x_msg_count => x_msg_count,
1045: x_msg_data => x_msg_data,
1046: p_api_type => g_api_type);
1047:

Line 1049: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

1045: x_msg_data => x_msg_data,
1046: p_api_type => g_api_type);
1047:
1048: when OTHERS then
1049: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
1050: p_api_name => l_api_name,
1051: p_pkg_name => g_pkg_name,
1052: p_exc_name => 'OTHERS',
1053: x_msg_count => x_msg_count,

Line 1163: L_Return_Status VARCHAR2(1) := OKE_API.G_Ret_Sts_Success;

1159: AND a.expected_date >= sysdate;
1160:
1161: c3rec c1%ROWTYPE;
1162:
1163: L_Return_Status VARCHAR2(1) := OKE_API.G_Ret_Sts_Success;
1164: L_API_Version CONSTANT NUMBER := 1;
1165: L_API_Name CONSTANT VARCHAR2(30) := 'BATCH_DEMAND';
1166: L_ID NUMBER;
1167: L_Msg_Count NUMBER;

Line 1173: L_Return_Status := OKE_API.Start_Activity ( L_Api_Name

1169:
1170:
1171: BEGIN
1172:
1173: L_Return_Status := OKE_API.Start_Activity ( L_Api_Name
1174: , P_Init_Msg_List
1175: , '_PKG'
1176: , X_Return_Status );
1177:

Line 1178: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

1174: , P_Init_Msg_List
1175: , '_PKG'
1176: , X_Return_Status );
1177:
1178: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1179: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1180: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
1181: RAISE OKE_API.G_EXCEPTION_ERROR;
1182: END IF;

Line 1179: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

1175: , '_PKG'
1176: , X_Return_Status );
1177:
1178: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1179: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1180: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
1181: RAISE OKE_API.G_EXCEPTION_ERROR;
1182: END IF;
1183:

Line 1180: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN

1176: , X_Return_Status );
1177:
1178: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1179: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1180: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
1181: RAISE OKE_API.G_EXCEPTION_ERROR;
1182: END IF;
1183:
1184: IF P_Project_ID IS NULL THEN

Line 1181: RAISE OKE_API.G_EXCEPTION_ERROR;

1177:
1178: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1179: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1180: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
1181: RAISE OKE_API.G_EXCEPTION_ERROR;
1182: END IF;
1183:
1184: IF P_Project_ID IS NULL THEN
1185: FOR c1rec IN c1 LOOP

Line 1223: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

1219: END IF;
1220: END LOOP;
1221: END IF;
1222:
1223: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1224: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1225: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
1226: RAISE OKE_API.G_EXCEPTION_ERROR;
1227: END IF;

Line 1224: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

1220: END LOOP;
1221: END IF;
1222:
1223: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1224: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1225: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
1226: RAISE OKE_API.G_EXCEPTION_ERROR;
1227: END IF;
1228:

Line 1225: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN

1221: END IF;
1222:
1223: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1224: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1225: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
1226: RAISE OKE_API.G_EXCEPTION_ERROR;
1227: END IF;
1228:
1229: OKE_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1226: RAISE OKE_API.G_EXCEPTION_ERROR;

1222:
1223: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1224: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1225: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
1226: RAISE OKE_API.G_EXCEPTION_ERROR;
1227: END IF;
1228:
1229: OKE_API.END_ACTIVITY(x_msg_count, x_msg_data);
1230:

Line 1229: OKE_API.END_ACTIVITY(x_msg_count, x_msg_data);

1225: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
1226: RAISE OKE_API.G_EXCEPTION_ERROR;
1227: END IF;
1228:
1229: OKE_API.END_ACTIVITY(x_msg_count, x_msg_data);
1230:
1231: EXCEPTION
1232: WHEN OKE_API.G_EXCEPTION_ERROR THEN
1233:

Line 1232: WHEN OKE_API.G_EXCEPTION_ERROR THEN

1228:
1229: OKE_API.END_ACTIVITY(x_msg_count, x_msg_data);
1230:
1231: EXCEPTION
1232: WHEN OKE_API.G_EXCEPTION_ERROR THEN
1233:
1234: x_return_status := OKE_API.HANDLE_EXCEPTIONS
1235: (
1236: l_api_name,

Line 1234: x_return_status := OKE_API.HANDLE_EXCEPTIONS

1230:
1231: EXCEPTION
1232: WHEN OKE_API.G_EXCEPTION_ERROR THEN
1233:
1234: x_return_status := OKE_API.HANDLE_EXCEPTIONS
1235: (
1236: l_api_name,
1237: G_PKG_NAME,
1238: 'OKE_API.G_RET_STS_ERROR',

Line 1238: 'OKE_API.G_RET_STS_ERROR',

1234: x_return_status := OKE_API.HANDLE_EXCEPTIONS
1235: (
1236: l_api_name,
1237: G_PKG_NAME,
1238: 'OKE_API.G_RET_STS_ERROR',
1239: x_msg_count,
1240: x_msg_data,
1241: '_PKG');
1242: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1242: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1238: 'OKE_API.G_RET_STS_ERROR',
1239: x_msg_count,
1240: x_msg_data,
1241: '_PKG');
1242: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1243: x_return_status := OKE_API.HANDLE_EXCEPTIONS
1244: (
1245: l_api_name,
1246: G_PKG_NAME,

Line 1243: x_return_status := OKE_API.HANDLE_EXCEPTIONS

1239: x_msg_count,
1240: x_msg_data,
1241: '_PKG');
1242: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1243: x_return_status := OKE_API.HANDLE_EXCEPTIONS
1244: (
1245: l_api_name,
1246: G_PKG_NAME,
1247: 'OKE_API.G_RET_STS_UNEXP_ERROR',

Line 1247: 'OKE_API.G_RET_STS_UNEXP_ERROR',

1243: x_return_status := OKE_API.HANDLE_EXCEPTIONS
1244: (
1245: l_api_name,
1246: G_PKG_NAME,
1247: 'OKE_API.G_RET_STS_UNEXP_ERROR',
1248: x_msg_count,
1249: x_msg_data,
1250: '_PKG');
1251:

Line 1253: x_return_status := OKE_API.HANDLE_EXCEPTIONS

1249: x_msg_data,
1250: '_PKG');
1251:
1252: WHEN OTHERS THEN
1253: x_return_status := OKE_API.HANDLE_EXCEPTIONS
1254: (
1255: l_api_name,
1256: G_PKG_NAME,
1257: 'OTHERS',

Line 1327: L_Return_Status VARCHAR2(1) := OKE_API.G_Ret_Sts_Success;

1323: AND a.expected_date >= sysdate;
1324:
1325: c3rec c1%ROWTYPE;
1326:
1327: L_Return_Status VARCHAR2(1) := OKE_API.G_Ret_Sts_Success;
1328: L_API_Version CONSTANT NUMBER := 1;
1329: L_API_Name CONSTANT VARCHAR2(30) := 'BATCH_REQ';
1330: L_ID NUMBER;
1331: L_Msg_Count NUMBER;

Line 1337: L_Return_Status := OKE_API.Start_Activity ( L_Api_Name

1333:
1334:
1335: BEGIN
1336:
1337: L_Return_Status := OKE_API.Start_Activity ( L_Api_Name
1338: , P_Init_Msg_List
1339: , '_PKG'
1340: , X_Return_Status );
1341:

Line 1342: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

1338: , P_Init_Msg_List
1339: , '_PKG'
1340: , X_Return_Status );
1341:
1342: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1343: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1344: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
1345: RAISE OKE_API.G_EXCEPTION_ERROR;
1346: END IF;

Line 1343: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

1339: , '_PKG'
1340: , X_Return_Status );
1341:
1342: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1343: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1344: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
1345: RAISE OKE_API.G_EXCEPTION_ERROR;
1346: END IF;
1347:

Line 1344: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN

1340: , X_Return_Status );
1341:
1342: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1343: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1344: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
1345: RAISE OKE_API.G_EXCEPTION_ERROR;
1346: END IF;
1347:
1348: IF P_Project_ID IS NULL THEN

Line 1345: RAISE OKE_API.G_EXCEPTION_ERROR;

1341:
1342: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1343: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1344: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
1345: RAISE OKE_API.G_EXCEPTION_ERROR;
1346: END IF;
1347:
1348: IF P_Project_ID IS NULL THEN
1349: FOR c1rec IN c1 LOOP

Line 1387: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

1383: END IF;
1384: END LOOP;
1385: END IF;
1386:
1387: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1388: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1389: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
1390: RAISE OKE_API.G_EXCEPTION_ERROR;
1391: END IF;

Line 1388: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

1384: END LOOP;
1385: END IF;
1386:
1387: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1388: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1389: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
1390: RAISE OKE_API.G_EXCEPTION_ERROR;
1391: END IF;
1392:

Line 1389: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN

1385: END IF;
1386:
1387: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1388: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1389: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
1390: RAISE OKE_API.G_EXCEPTION_ERROR;
1391: END IF;
1392:
1393: OKE_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1390: RAISE OKE_API.G_EXCEPTION_ERROR;

1386:
1387: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1388: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1389: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
1390: RAISE OKE_API.G_EXCEPTION_ERROR;
1391: END IF;
1392:
1393: OKE_API.END_ACTIVITY(x_msg_count, x_msg_data);
1394:

Line 1393: OKE_API.END_ACTIVITY(x_msg_count, x_msg_data);

1389: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
1390: RAISE OKE_API.G_EXCEPTION_ERROR;
1391: END IF;
1392:
1393: OKE_API.END_ACTIVITY(x_msg_count, x_msg_data);
1394:
1395: EXCEPTION
1396: WHEN OKE_API.G_EXCEPTION_ERROR THEN
1397:

Line 1396: WHEN OKE_API.G_EXCEPTION_ERROR THEN

1392:
1393: OKE_API.END_ACTIVITY(x_msg_count, x_msg_data);
1394:
1395: EXCEPTION
1396: WHEN OKE_API.G_EXCEPTION_ERROR THEN
1397:
1398: x_return_status := OKE_API.HANDLE_EXCEPTIONS
1399: (
1400: l_api_name,

Line 1398: x_return_status := OKE_API.HANDLE_EXCEPTIONS

1394:
1395: EXCEPTION
1396: WHEN OKE_API.G_EXCEPTION_ERROR THEN
1397:
1398: x_return_status := OKE_API.HANDLE_EXCEPTIONS
1399: (
1400: l_api_name,
1401: G_PKG_NAME,
1402: 'OKE_API.G_RET_STS_ERROR',

Line 1402: 'OKE_API.G_RET_STS_ERROR',

1398: x_return_status := OKE_API.HANDLE_EXCEPTIONS
1399: (
1400: l_api_name,
1401: G_PKG_NAME,
1402: 'OKE_API.G_RET_STS_ERROR',
1403: x_msg_count,
1404: x_msg_data,
1405: '_PKG');
1406: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1406: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1402: 'OKE_API.G_RET_STS_ERROR',
1403: x_msg_count,
1404: x_msg_data,
1405: '_PKG');
1406: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1407: x_return_status := OKE_API.HANDLE_EXCEPTIONS
1408: (
1409: l_api_name,
1410: G_PKG_NAME,

Line 1407: x_return_status := OKE_API.HANDLE_EXCEPTIONS

1403: x_msg_count,
1404: x_msg_data,
1405: '_PKG');
1406: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1407: x_return_status := OKE_API.HANDLE_EXCEPTIONS
1408: (
1409: l_api_name,
1410: G_PKG_NAME,
1411: 'OKE_API.G_RET_STS_UNEXP_ERROR',

Line 1411: 'OKE_API.G_RET_STS_UNEXP_ERROR',

1407: x_return_status := OKE_API.HANDLE_EXCEPTIONS
1408: (
1409: l_api_name,
1410: G_PKG_NAME,
1411: 'OKE_API.G_RET_STS_UNEXP_ERROR',
1412: x_msg_count,
1413: x_msg_data,
1414: '_PKG');
1415:

Line 1417: x_return_status := OKE_API.HANDLE_EXCEPTIONS

1413: x_msg_data,
1414: '_PKG');
1415:
1416: WHEN OTHERS THEN
1417: x_return_status := OKE_API.HANDLE_EXCEPTIONS
1418: (
1419: l_api_name,
1420: G_PKG_NAME,
1421: 'OTHERS',

Line 1478: L_Return_Status VARCHAR2(1) := OKE_API.G_Ret_Sts_Success;

1474: AND a.expected_date >= sysdate;
1475:
1476: c3rec c1%ROWTYPE;
1477:
1478: L_Return_Status VARCHAR2(1) := OKE_API.G_Ret_Sts_Success;
1479: L_API_Version CONSTANT NUMBER := 1;
1480: L_API_Name CONSTANT VARCHAR2(30) := 'BATCH_WSH';
1481: L_ID NUMBER;
1482: L_Msg_Count NUMBER;

Line 1488: L_Return_Status := OKE_API.Start_Activity ( L_Api_Name

1484:
1485:
1486: BEGIN
1487:
1488: L_Return_Status := OKE_API.Start_Activity ( L_Api_Name
1489: , P_Init_Msg_List
1490: , '_PKG'
1491: , X_Return_Status );
1492:

Line 1493: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

1489: , P_Init_Msg_List
1490: , '_PKG'
1491: , X_Return_Status );
1492:
1493: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1494: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1495: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
1496: RAISE OKE_API.G_EXCEPTION_ERROR;
1497: END IF;

Line 1494: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

1490: , '_PKG'
1491: , X_Return_Status );
1492:
1493: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1494: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1495: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
1496: RAISE OKE_API.G_EXCEPTION_ERROR;
1497: END IF;
1498:

Line 1495: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN

1491: , X_Return_Status );
1492:
1493: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1494: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1495: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
1496: RAISE OKE_API.G_EXCEPTION_ERROR;
1497: END IF;
1498:
1499: IF P_Project_ID IS NULL THEN

Line 1496: RAISE OKE_API.G_EXCEPTION_ERROR;

1492:
1493: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1494: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1495: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
1496: RAISE OKE_API.G_EXCEPTION_ERROR;
1497: END IF;
1498:
1499: IF P_Project_ID IS NULL THEN
1500: FOR c1rec IN c1 LOOP

Line 1538: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

1534: END IF;
1535: END LOOP;
1536: END IF;
1537:
1538: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1539: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1540: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
1541: RAISE OKE_API.G_EXCEPTION_ERROR;
1542: END IF;

Line 1539: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

1535: END LOOP;
1536: END IF;
1537:
1538: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1539: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1540: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
1541: RAISE OKE_API.G_EXCEPTION_ERROR;
1542: END IF;
1543:

Line 1540: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN

1536: END IF;
1537:
1538: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1539: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1540: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
1541: RAISE OKE_API.G_EXCEPTION_ERROR;
1542: END IF;
1543:
1544: OKE_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1541: RAISE OKE_API.G_EXCEPTION_ERROR;

1537:
1538: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1539: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1540: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
1541: RAISE OKE_API.G_EXCEPTION_ERROR;
1542: END IF;
1543:
1544: OKE_API.END_ACTIVITY(x_msg_count, x_msg_data);
1545:

Line 1544: OKE_API.END_ACTIVITY(x_msg_count, x_msg_data);

1540: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
1541: RAISE OKE_API.G_EXCEPTION_ERROR;
1542: END IF;
1543:
1544: OKE_API.END_ACTIVITY(x_msg_count, x_msg_data);
1545:
1546: EXCEPTION
1547: WHEN OKE_API.G_EXCEPTION_ERROR THEN
1548:

Line 1547: WHEN OKE_API.G_EXCEPTION_ERROR THEN

1543:
1544: OKE_API.END_ACTIVITY(x_msg_count, x_msg_data);
1545:
1546: EXCEPTION
1547: WHEN OKE_API.G_EXCEPTION_ERROR THEN
1548:
1549: x_return_status := OKE_API.HANDLE_EXCEPTIONS
1550: (
1551: l_api_name,

Line 1549: x_return_status := OKE_API.HANDLE_EXCEPTIONS

1545:
1546: EXCEPTION
1547: WHEN OKE_API.G_EXCEPTION_ERROR THEN
1548:
1549: x_return_status := OKE_API.HANDLE_EXCEPTIONS
1550: (
1551: l_api_name,
1552: G_PKG_NAME,
1553: 'OKE_API.G_RET_STS_ERROR',

Line 1553: 'OKE_API.G_RET_STS_ERROR',

1549: x_return_status := OKE_API.HANDLE_EXCEPTIONS
1550: (
1551: l_api_name,
1552: G_PKG_NAME,
1553: 'OKE_API.G_RET_STS_ERROR',
1554: x_msg_count,
1555: x_msg_data,
1556: '_PKG');
1557: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1557: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1553: 'OKE_API.G_RET_STS_ERROR',
1554: x_msg_count,
1555: x_msg_data,
1556: '_PKG');
1557: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1558: x_return_status := OKE_API.HANDLE_EXCEPTIONS
1559: (
1560: l_api_name,
1561: G_PKG_NAME,

Line 1558: x_return_status := OKE_API.HANDLE_EXCEPTIONS

1554: x_msg_count,
1555: x_msg_data,
1556: '_PKG');
1557: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1558: x_return_status := OKE_API.HANDLE_EXCEPTIONS
1559: (
1560: l_api_name,
1561: G_PKG_NAME,
1562: 'OKE_API.G_RET_STS_UNEXP_ERROR',

Line 1562: 'OKE_API.G_RET_STS_UNEXP_ERROR',

1558: x_return_status := OKE_API.HANDLE_EXCEPTIONS
1559: (
1560: l_api_name,
1561: G_PKG_NAME,
1562: 'OKE_API.G_RET_STS_UNEXP_ERROR',
1563: x_msg_count,
1564: x_msg_data,
1565: '_PKG');
1566:

Line 1568: x_return_status := OKE_API.HANDLE_EXCEPTIONS

1564: x_msg_data,
1565: '_PKG');
1566:
1567: WHEN OTHERS THEN
1568: x_return_status := OKE_API.HANDLE_EXCEPTIONS
1569: (
1570: l_api_name,
1571: G_PKG_NAME,
1572: 'OTHERS',