219:
220: EXCEPTION
221:
222: WHEN FND_API.G_EXC_ERROR THEN
223: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
224: P_API_NAME => L_API_NAME
225: , P_PKG_NAME => G_PKG_NAME
226: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
227: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
223: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
224: P_API_NAME => L_API_NAME
225: , P_PKG_NAME => G_PKG_NAME
226: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
227: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
228: , X_MSG_COUNT => X_MSG_COUNT
229: , X_MSG_DATA => X_MSG_DATA
230: , X_RETURN_STATUS => X_RETURN_STATUS
231: );
230: , X_RETURN_STATUS => X_RETURN_STATUS
231: );
232:
233: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
234: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
235: P_API_NAME => L_API_NAME
236: , P_PKG_NAME => G_PKG_NAME
237: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
238: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
234: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
235: P_API_NAME => L_API_NAME
236: , P_PKG_NAME => G_PKG_NAME
237: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
238: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
239: , X_MSG_COUNT => X_MSG_COUNT
240: , X_MSG_DATA => X_MSG_DATA
241: , X_RETURN_STATUS => X_RETURN_STATUS
242: );
240: , X_MSG_DATA => X_MSG_DATA
241: , X_RETURN_STATUS => X_RETURN_STATUS
242: );
243: WHEN OTHERS THEN
244: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
245: P_API_NAME => L_API_NAME
246: , P_PKG_NAME => G_PKG_NAME
247: , P_SQLCODE => SQLCODE
248: , P_SQLERRM => SQLERRM
245: P_API_NAME => L_API_NAME
246: , P_PKG_NAME => G_PKG_NAME
247: , P_SQLCODE => SQLCODE
248: , P_SQLERRM => SQLERRM
249: , P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
250: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
251: , X_MSG_COUNT => X_MSG_COUNT
252: , X_MSG_DATA => X_MSG_DATA
253: , X_RETURN_STATUS => X_RETURN_STATUS
246: , P_PKG_NAME => G_PKG_NAME
247: , P_SQLCODE => SQLCODE
248: , P_SQLERRM => SQLERRM
249: , P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
250: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
251: , X_MSG_COUNT => X_MSG_COUNT
252: , X_MSG_DATA => X_MSG_DATA
253: , X_RETURN_STATUS => X_RETURN_STATUS
254: );
361:
362: EXCEPTION
363:
364: WHEN FND_API.G_EXC_ERROR THEN
365: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
366: P_API_NAME => L_API_NAME
367: , P_PKG_NAME => G_PKG_NAME
368: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
369: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
365: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
366: P_API_NAME => L_API_NAME
367: , P_PKG_NAME => G_PKG_NAME
368: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
369: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
370: , X_MSG_COUNT => X_MSG_COUNT
371: , X_MSG_DATA => X_MSG_DATA
372: , X_RETURN_STATUS => X_RETURN_STATUS
373: );
372: , X_RETURN_STATUS => X_RETURN_STATUS
373: );
374:
375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
376: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
377: P_API_NAME => L_API_NAME
378: , P_PKG_NAME => G_PKG_NAME
379: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
380: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
376: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
377: P_API_NAME => L_API_NAME
378: , P_PKG_NAME => G_PKG_NAME
379: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
380: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
381: , X_MSG_COUNT => X_MSG_COUNT
382: , X_MSG_DATA => X_MSG_DATA
383: , X_RETURN_STATUS => X_RETURN_STATUS
384: );
382: , X_MSG_DATA => X_MSG_DATA
383: , X_RETURN_STATUS => X_RETURN_STATUS
384: );
385: WHEN OTHERS THEN
386: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
387: P_API_NAME => L_API_NAME
388: , P_PKG_NAME => G_PKG_NAME
389: , P_SQLCODE => SQLCODE
390: , P_SQLERRM => SQLERRM
387: P_API_NAME => L_API_NAME
388: , P_PKG_NAME => G_PKG_NAME
389: , P_SQLCODE => SQLCODE
390: , P_SQLERRM => SQLERRM
391: , P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
392: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
393: , X_MSG_COUNT => X_MSG_COUNT
394: , X_MSG_DATA => X_MSG_DATA
395: , X_RETURN_STATUS => X_RETURN_STATUS
388: , P_PKG_NAME => G_PKG_NAME
389: , P_SQLCODE => SQLCODE
390: , P_SQLERRM => SQLERRM
391: , P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
392: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
393: , X_MSG_COUNT => X_MSG_COUNT
394: , X_MSG_DATA => X_MSG_DATA
395: , X_RETURN_STATUS => X_RETURN_STATUS
396: );