421: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
422: X_MSG_COUNT => X_MSG_COUNT,
423: X_MSG_DATA => X_MSG_DATA,
424: X_RETURN_STATUS => X_RETURN_STATUS);
425: --APP_EXCEPTION.RAISE_EXCEPTION;
426:
427: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
428: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
429: P_API_NAME => L_API_NAME,
432: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
433: X_MSG_COUNT => X_MSG_COUNT,
434: X_MSG_DATA => X_MSG_DATA,
435: X_RETURN_STATUS => X_RETURN_STATUS);
436: --APP_EXCEPTION.RAISE_EXCEPTION;
437:
438: WHEN OTHERS THEN
439: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
440: P_API_NAME => L_API_NAME,
443: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
444: X_MSG_COUNT => X_MSG_COUNT,
445: X_MSG_DATA => X_MSG_DATA,
446: X_RETURN_STATUS => X_RETURN_STATUS);
447: --APP_EXCEPTION.RAISE_EXCEPTION;
448:
449: End Create_cust_plans;
450:
451: /*** Overloaded proc. that accepts a detailed parameter list, converts the list
657: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
658: X_MSG_COUNT => X_MSG_COUNT,
659: X_MSG_DATA => X_MSG_DATA,
660: X_RETURN_STATUS => X_RETURN_STATUS);
661: --APP_EXCEPTION.RAISE_EXCEPTION;
662:
663: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
664: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
665: P_API_NAME => L_API_NAME,
668: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
669: X_MSG_COUNT => X_MSG_COUNT,
670: X_MSG_DATA => X_MSG_DATA,
671: X_RETURN_STATUS => X_RETURN_STATUS);
672: --APP_EXCEPTION.RAISE_EXCEPTION;
673:
674: WHEN OTHERS THEN
675: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
676: P_API_NAME => L_API_NAME,
679: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
680: X_MSG_COUNT => X_MSG_COUNT,
681: X_MSG_DATA => X_MSG_DATA,
682: X_RETURN_STATUS => X_RETURN_STATUS);
683: --APP_EXCEPTION.RAISE_EXCEPTION;
684:
685: End Update_cust_plans;
686:
687: PROCEDURE ENABLE_PLAN (
741: X_Msg_Count => x_msg_count,
742: X_Msg_Data => x_msg_data );
743:
744: if ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) then
745: APP_EXCEPTION.RAISE_EXCEPTION;
746: end if;
747:
748: -- Standard check for p_commit
749: IF FND_API.to_Boolean( p_commit )
811: X_Msg_Count => x_msg_count,
812: X_Msg_Data => x_msg_data );
813:
814: if ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) then
815: APP_EXCEPTION.RAISE_EXCEPTION;
816: end if;
817:
818: -- Standard check for p_commit
819: IF FND_API.to_Boolean( p_commit )
886: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
887: X_MSG_COUNT => X_MSG_COUNT,
888: X_MSG_DATA => X_MSG_DATA,
889: X_RETURN_STATUS => X_RETURN_STATUS);
890: --APP_EXCEPTION.RAISE_EXCEPTION;
891:
892: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
893: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
894: P_API_NAME => L_API_NAME,
897: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
898: X_MSG_COUNT => X_MSG_COUNT,
899: X_MSG_DATA => X_MSG_DATA,
900: X_RETURN_STATUS => X_RETURN_STATUS);
901: --APP_EXCEPTION.RAISE_EXCEPTION;
902:
903: WHEN OTHERS THEN
904: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
905: P_API_NAME => L_API_NAME,
908: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
909: X_MSG_COUNT => X_MSG_COUNT,
910: X_MSG_DATA => X_MSG_DATA,
911: X_RETURN_STATUS => X_RETURN_STATUS);
912: --APP_EXCEPTION.RAISE_EXCEPTION;
913:
914: End Delete_cust_plans;
915:
916: End CSC_CUST_PLANS_PUB;