921:
922: EXCEPTION
923:
924: WHEN FND_API.G_EXC_ERROR THEN
925: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
926: P_API_NAME => L_API_NAME,
927: P_PKG_NAME => G_PKG_NAME,
928: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
929: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
925: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
926: P_API_NAME => L_API_NAME,
927: P_PKG_NAME => G_PKG_NAME,
928: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
929: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
930: P_SQLCODE => SQLCODE,
931: P_SQLERRM => SQLERRM,
932: X_MSG_COUNT => X_MSG_COUNT,
933: X_MSG_DATA => X_MSG_DATA,
934: X_RETURN_STATUS => X_RETURN_STATUS
935: );
936:
937: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
938: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
939: P_API_NAME => L_API_NAME,
940: P_PKG_NAME => G_PKG_NAME,
941: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
942: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
938: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
939: P_API_NAME => L_API_NAME,
940: P_PKG_NAME => G_PKG_NAME,
941: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
942: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
943: P_SQLCODE => SQLCODE,
944: P_SQLERRM => SQLERRM,
945: X_MSG_COUNT => X_MSG_COUNT,
946: X_MSG_DATA => X_MSG_DATA,
947: X_RETURN_STATUS => X_RETURN_STATUS
948: );
949:
950: WHEN OTHERS THEN
951: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
952: P_API_NAME => L_API_NAME,
953: P_PKG_NAME => G_PKG_NAME,
954: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
955: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
950: WHEN OTHERS THEN
951: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
952: P_API_NAME => L_API_NAME,
953: P_PKG_NAME => G_PKG_NAME,
954: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
955: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
956: P_SQLCODE => SQLCODE,
957: P_SQLERRM => SQLERRM,
958: X_MSG_COUNT => X_MSG_COUNT,
951: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
952: P_API_NAME => L_API_NAME,
953: P_PKG_NAME => G_PKG_NAME,
954: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
955: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
956: P_SQLCODE => SQLCODE,
957: P_SQLERRM => SQLERRM,
958: X_MSG_COUNT => X_MSG_COUNT,
959: X_MSG_DATA => X_MSG_DATA,