102: );
103:
104: EXCEPTION
105: WHEN FND_API.G_EXC_ERROR THEN
106: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
107: P_API_NAME => L_API_NAME
108: ,P_PKG_NAME => G_PKG_NAME
109: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
110: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
106: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
107: P_API_NAME => L_API_NAME
108: ,P_PKG_NAME => G_PKG_NAME
109: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
110: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
111: ,P_SQLCODE => SQLCODE
112: ,P_SQLERRM => SQLERRM
113: ,X_MSG_COUNT => X_MSG_COUNT
114: ,X_MSG_DATA => X_MSG_DATA
114: ,X_MSG_DATA => X_MSG_DATA
115: ,X_RETURN_STATUS => X_RETURN_STATUS);
116:
117: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
118: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
119: P_API_NAME => L_API_NAME
120: ,P_PKG_NAME => G_PKG_NAME
121: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
122: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
118: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
119: P_API_NAME => L_API_NAME
120: ,P_PKG_NAME => G_PKG_NAME
121: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
122: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
123: ,P_SQLCODE => SQLCODE
124: ,P_SQLERRM => SQLERRM
125: ,X_MSG_COUNT => X_MSG_COUNT
126: ,X_MSG_DATA => X_MSG_DATA
126: ,X_MSG_DATA => X_MSG_DATA
127: ,X_RETURN_STATUS => X_RETURN_STATUS);
128:
129: WHEN OTHERS THEN
130: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
131: P_API_NAME => L_API_NAME
132: ,P_PKG_NAME => G_PKG_NAME
133: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
134: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
129: WHEN OTHERS THEN
130: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
131: P_API_NAME => L_API_NAME
132: ,P_PKG_NAME => G_PKG_NAME
133: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
134: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
135: ,P_SQLCODE => SQLCODE
136: ,P_SQLERRM => SQLERRM
137: ,X_MSG_COUNT => X_MSG_COUNT
130: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
131: P_API_NAME => L_API_NAME
132: ,P_PKG_NAME => G_PKG_NAME
133: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
134: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
135: ,P_SQLCODE => SQLCODE
136: ,P_SQLERRM => SQLERRM
137: ,X_MSG_COUNT => X_MSG_COUNT
138: ,X_MSG_DATA => X_MSG_DATA
254: );
255:
256: EXCEPTION
257: WHEN FND_API.G_EXC_ERROR THEN
258: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
259: P_API_NAME => L_API_NAME
260: ,P_PKG_NAME => G_PKG_NAME
261: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
262: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
258: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
259: P_API_NAME => L_API_NAME
260: ,P_PKG_NAME => G_PKG_NAME
261: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
262: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
263: ,P_SQLCODE => SQLCODE
264: ,P_SQLERRM => SQLERRM
265: ,X_MSG_COUNT => X_MSG_COUNT
266: ,X_MSG_DATA => X_MSG_DATA
266: ,X_MSG_DATA => X_MSG_DATA
267: ,X_RETURN_STATUS => X_RETURN_STATUS);
268:
269: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
270: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
271: P_API_NAME => L_API_NAME
272: ,P_PKG_NAME => G_PKG_NAME
273: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
274: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
270: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
271: P_API_NAME => L_API_NAME
272: ,P_PKG_NAME => G_PKG_NAME
273: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
274: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
275: ,P_SQLCODE => SQLCODE
276: ,P_SQLERRM => SQLERRM
277: ,X_MSG_COUNT => X_MSG_COUNT
278: ,X_MSG_DATA => X_MSG_DATA
278: ,X_MSG_DATA => X_MSG_DATA
279: ,X_RETURN_STATUS => X_RETURN_STATUS);
280:
281: WHEN OTHERS THEN
282: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
283: P_API_NAME => L_API_NAME
284: ,P_PKG_NAME => G_PKG_NAME
285: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
286: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
281: WHEN OTHERS THEN
282: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
283: P_API_NAME => L_API_NAME
284: ,P_PKG_NAME => G_PKG_NAME
285: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
286: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
287: ,P_SQLCODE => SQLCODE
288: ,P_SQLERRM => SQLERRM
289: ,X_MSG_COUNT => X_MSG_COUNT
282: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
283: P_API_NAME => L_API_NAME
284: ,P_PKG_NAME => G_PKG_NAME
285: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
286: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
287: ,P_SQLCODE => SQLCODE
288: ,P_SQLERRM => SQLERRM
289: ,X_MSG_COUNT => X_MSG_COUNT
290: ,X_MSG_DATA => X_MSG_DATA
463: );
464:
465: EXCEPTION
466: WHEN FND_API.G_EXC_ERROR THEN
467: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
468: P_API_NAME => L_API_NAME
469: ,P_PKG_NAME => G_PKG_NAME
470: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
471: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
467: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
468: P_API_NAME => L_API_NAME
469: ,P_PKG_NAME => G_PKG_NAME
470: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
471: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
472: ,P_SQLCODE => SQLCODE
473: ,P_SQLERRM => SQLERRM
474: ,X_MSG_COUNT => X_MSG_COUNT
475: ,X_MSG_DATA => X_MSG_DATA
475: ,X_MSG_DATA => X_MSG_DATA
476: ,X_RETURN_STATUS => X_RETURN_STATUS);
477:
478: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
479: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
480: P_API_NAME => L_API_NAME
481: ,P_PKG_NAME => G_PKG_NAME
482: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
483: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
479: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
480: P_API_NAME => L_API_NAME
481: ,P_PKG_NAME => G_PKG_NAME
482: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
483: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
484: ,P_SQLCODE => SQLCODE
485: ,P_SQLERRM => SQLERRM
486: ,X_MSG_COUNT => X_MSG_COUNT
487: ,X_MSG_DATA => X_MSG_DATA
487: ,X_MSG_DATA => X_MSG_DATA
488: ,X_RETURN_STATUS => X_RETURN_STATUS);
489:
490: WHEN OTHERS THEN
491: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
492: P_API_NAME => L_API_NAME
493: ,P_PKG_NAME => G_PKG_NAME
494: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
495: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
490: WHEN OTHERS THEN
491: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
492: P_API_NAME => L_API_NAME
493: ,P_PKG_NAME => G_PKG_NAME
494: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
495: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
496: ,P_SQLCODE => SQLCODE
497: ,P_SQLERRM => SQLERRM
498: ,X_MSG_COUNT => X_MSG_COUNT
491: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
492: P_API_NAME => L_API_NAME
493: ,P_PKG_NAME => G_PKG_NAME
494: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
495: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
496: ,P_SQLCODE => SQLCODE
497: ,P_SQLERRM => SQLERRM
498: ,X_MSG_COUNT => X_MSG_COUNT
499: ,X_MSG_DATA => X_MSG_DATA
597: p_data => x_msg_data);
598:
599: EXCEPTION
600: WHEN FND_API.G_EXC_ERROR THEN
601: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
602: P_API_NAME => L_API_NAME
603: ,P_PKG_NAME => G_PKG_NAME
604: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
605: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
601: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
602: P_API_NAME => L_API_NAME
603: ,P_PKG_NAME => G_PKG_NAME
604: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
605: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
606: ,P_SQLCODE => SQLCODE
607: ,P_SQLERRM => SQLERRM
608: ,X_MSG_COUNT => X_MSG_COUNT
609: ,X_MSG_DATA => X_MSG_DATA
609: ,X_MSG_DATA => X_MSG_DATA
610: ,X_RETURN_STATUS => X_RETURN_STATUS);
611:
612: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
613: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
614: P_API_NAME => L_API_NAME
615: ,P_PKG_NAME => G_PKG_NAME
616: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
617: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
613: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
614: P_API_NAME => L_API_NAME
615: ,P_PKG_NAME => G_PKG_NAME
616: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
617: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
618: ,P_SQLCODE => SQLCODE
619: ,P_SQLERRM => SQLERRM
620: ,X_MSG_COUNT => X_MSG_COUNT
621: ,X_MSG_DATA => X_MSG_DATA
621: ,X_MSG_DATA => X_MSG_DATA
622: ,X_RETURN_STATUS => X_RETURN_STATUS);
623:
624: WHEN OTHERS THEN
625: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
626: P_API_NAME => L_API_NAME
627: ,P_PKG_NAME => G_PKG_NAME
628: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
629: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
624: WHEN OTHERS THEN
625: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
626: P_API_NAME => L_API_NAME
627: ,P_PKG_NAME => G_PKG_NAME
628: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
629: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
630: ,P_SQLCODE => SQLCODE
631: ,P_SQLERRM => SQLERRM
632: ,X_MSG_COUNT => X_MSG_COUNT
625: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
626: P_API_NAME => L_API_NAME
627: ,P_PKG_NAME => G_PKG_NAME
628: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
629: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
630: ,P_SQLCODE => SQLCODE
631: ,P_SQLERRM => SQLERRM
632: ,X_MSG_COUNT => X_MSG_COUNT
633: ,X_MSG_DATA => X_MSG_DATA