881: );
882:
883: EXCEPTION
884: WHEN FND_API.G_EXC_ERROR THEN
885: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
886: P_API_NAME => L_API_NAME
887: ,P_PKG_NAME => G_PKG_NAME
888: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
889: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
885: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
886: P_API_NAME => L_API_NAME
887: ,P_PKG_NAME => G_PKG_NAME
888: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
889: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
890: ,P_SQLCODE => SQLCODE
891: ,P_SQLERRM => SQLERRM
892: ,X_MSG_COUNT => X_MSG_COUNT
893: ,X_MSG_DATA => X_MSG_DATA
893: ,X_MSG_DATA => X_MSG_DATA
894: ,X_RETURN_STATUS => X_RETURN_STATUS);
895:
896: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
897: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
898: P_API_NAME => L_API_NAME
899: ,P_PKG_NAME => G_PKG_NAME
900: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
901: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
897: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
898: P_API_NAME => L_API_NAME
899: ,P_PKG_NAME => G_PKG_NAME
900: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
901: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
902: ,P_SQLCODE => SQLCODE
903: ,P_SQLERRM => SQLERRM
904: ,X_MSG_COUNT => X_MSG_COUNT
905: ,X_MSG_DATA => X_MSG_DATA
905: ,X_MSG_DATA => X_MSG_DATA
906: ,X_RETURN_STATUS => X_RETURN_STATUS);
907:
908: WHEN OTHERS THEN
909: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
910: P_API_NAME => L_API_NAME
911: ,P_PKG_NAME => G_PKG_NAME
912: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
913: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
908: WHEN OTHERS THEN
909: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
910: P_API_NAME => L_API_NAME
911: ,P_PKG_NAME => G_PKG_NAME
912: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
913: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
914: ,P_SQLCODE => SQLCODE
915: ,P_SQLERRM => SQLERRM
916: ,X_MSG_COUNT => X_MSG_COUNT
909: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
910: P_API_NAME => L_API_NAME
911: ,P_PKG_NAME => G_PKG_NAME
912: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
913: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
914: ,P_SQLCODE => SQLCODE
915: ,P_SQLERRM => SQLERRM
916: ,X_MSG_COUNT => X_MSG_COUNT
917: ,X_MSG_DATA => X_MSG_DATA