233:
234: EXCEPTION
235: WHEN FND_API.G_EXC_ERROR THEN
236: x_return_status := FND_API.G_RET_STS_ERROR;
237: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
238: P_API_NAME => L_API_NAME
239: ,P_PKG_NAME => G_PKG_NAME
240: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
241: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
237: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
238: P_API_NAME => L_API_NAME
239: ,P_PKG_NAME => G_PKG_NAME
240: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
241: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
242: ,X_MSG_COUNT => X_MSG_COUNT
243: ,X_MSG_DATA => X_MSG_DATA
244: ,X_RETURN_STATUS => X_RETURN_STATUS);
245:
244: ,X_RETURN_STATUS => X_RETURN_STATUS);
245:
246: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
248: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
249: P_API_NAME => L_API_NAME
250: ,P_PKG_NAME => G_PKG_NAME
251: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
252: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
248: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
249: P_API_NAME => L_API_NAME
250: ,P_PKG_NAME => G_PKG_NAME
251: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
252: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
253: ,X_MSG_COUNT => X_MSG_COUNT
254: ,X_MSG_DATA => X_MSG_DATA
255: ,X_RETURN_STATUS => X_RETURN_STATUS);
256:
255: ,X_RETURN_STATUS => X_RETURN_STATUS);
256:
257: WHEN OTHERS THEN
258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
259: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
260: P_API_NAME => L_API_NAME
261: ,P_PKG_NAME => G_PKG_NAME
262: ,P_SQLERRM => sqlerrm
263: ,P_SQLCODE => sqlcode
260: P_API_NAME => L_API_NAME
261: ,P_PKG_NAME => G_PKG_NAME
262: ,P_SQLERRM => sqlerrm
263: ,P_SQLCODE => sqlcode
264: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
265: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
266: ,X_MSG_COUNT => X_MSG_COUNT
267: ,X_MSG_DATA => X_MSG_DATA
268: ,X_RETURN_STATUS => X_RETURN_STATUS);
261: ,P_PKG_NAME => G_PKG_NAME
262: ,P_SQLERRM => sqlerrm
263: ,P_SQLCODE => sqlcode
264: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
265: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
266: ,X_MSG_COUNT => X_MSG_COUNT
267: ,X_MSG_DATA => X_MSG_DATA
268: ,X_RETURN_STATUS => X_RETURN_STATUS);
269: end;