253: );
254:
255: EXCEPTION
256: WHEN FND_API.G_EXC_ERROR THEN
257: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
258: P_API_NAME => L_API_NAME
259: ,P_PKG_NAME => G_PKG_NAME
260: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
261: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
257: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
258: P_API_NAME => L_API_NAME
259: ,P_PKG_NAME => G_PKG_NAME
260: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
261: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
262: ,P_SQLCODE => SQLCODE
263: ,P_SQLERRM => SQLERRM
264: ,X_MSG_COUNT => X_MSG_COUNT
265: ,X_MSG_DATA => X_MSG_DATA
265: ,X_MSG_DATA => X_MSG_DATA
266: ,X_RETURN_STATUS => X_RETURN_STATUS);
267:
268: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
269: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
270: P_API_NAME => L_API_NAME
271: ,P_PKG_NAME => G_PKG_NAME
272: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
273: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
269: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
270: P_API_NAME => L_API_NAME
271: ,P_PKG_NAME => G_PKG_NAME
272: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
273: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
274: ,P_SQLCODE => SQLCODE
275: ,P_SQLERRM => SQLERRM
276: ,X_MSG_COUNT => X_MSG_COUNT
277: ,X_MSG_DATA => X_MSG_DATA
277: ,X_MSG_DATA => X_MSG_DATA
278: ,X_RETURN_STATUS => X_RETURN_STATUS);
279:
280: WHEN OTHERS THEN
281: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
282: P_API_NAME => L_API_NAME
283: ,P_PKG_NAME => G_PKG_NAME
284: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
285: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
280: WHEN OTHERS THEN
281: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
282: P_API_NAME => L_API_NAME
283: ,P_PKG_NAME => G_PKG_NAME
284: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
285: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
286: ,P_SQLCODE => SQLCODE
287: ,P_SQLERRM => SQLERRM
288: ,X_MSG_COUNT => X_MSG_COUNT
281: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
282: P_API_NAME => L_API_NAME
283: ,P_PKG_NAME => G_PKG_NAME
284: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
285: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
286: ,P_SQLCODE => SQLCODE
287: ,P_SQLERRM => SQLERRM
288: ,X_MSG_COUNT => X_MSG_COUNT
289: ,X_MSG_DATA => X_MSG_DATA