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