76: );
77:
78: EXCEPTION
79: WHEN FND_API.G_EXC_ERROR THEN
80: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
81: P_API_NAME => L_API_NAME
82: ,P_PKG_NAME => G_PKG_NAME
83: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
84: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
80: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
81: P_API_NAME => L_API_NAME
82: ,P_PKG_NAME => G_PKG_NAME
83: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
84: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
85: ,P_SQLCODE => SQLCODE
86: ,P_SQLERRM => SQLERRM
87: ,X_MSG_COUNT => X_MSG_COUNT
88: ,X_MSG_DATA => X_MSG_DATA
88: ,X_MSG_DATA => X_MSG_DATA
89: ,X_RETURN_STATUS => X_RETURN_STATUS);
90:
91: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
92: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
93: P_API_NAME => L_API_NAME
94: ,P_PKG_NAME => G_PKG_NAME
95: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
96: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
92: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
93: P_API_NAME => L_API_NAME
94: ,P_PKG_NAME => G_PKG_NAME
95: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
96: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
97: ,P_SQLCODE => SQLCODE
98: ,P_SQLERRM => SQLERRM
99: ,X_MSG_COUNT => X_MSG_COUNT
100: ,X_MSG_DATA => X_MSG_DATA
100: ,X_MSG_DATA => X_MSG_DATA
101: ,X_RETURN_STATUS => X_RETURN_STATUS);
102:
103: WHEN OTHERS THEN
104: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
105: P_API_NAME => L_API_NAME
106: ,P_PKG_NAME => G_PKG_NAME
107: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
108: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
103: WHEN OTHERS THEN
104: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
105: P_API_NAME => L_API_NAME
106: ,P_PKG_NAME => G_PKG_NAME
107: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
108: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
109: ,P_SQLCODE => SQLCODE
110: ,P_SQLERRM => SQLERRM
111: ,X_MSG_COUNT => X_MSG_COUNT
104: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
105: P_API_NAME => L_API_NAME
106: ,P_PKG_NAME => G_PKG_NAME
107: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
108: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
109: ,P_SQLCODE => SQLCODE
110: ,P_SQLERRM => SQLERRM
111: ,X_MSG_COUNT => X_MSG_COUNT
112: ,X_MSG_DATA => X_MSG_DATA
181: );
182:
183: EXCEPTION
184: WHEN FND_API.G_EXC_ERROR THEN
185: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
186: P_API_NAME => L_API_NAME
187: ,P_PKG_NAME => G_PKG_NAME
188: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
189: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
185: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
186: P_API_NAME => L_API_NAME
187: ,P_PKG_NAME => G_PKG_NAME
188: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
189: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
190: ,P_SQLCODE => SQLCODE
191: ,P_SQLERRM => SQLERRM
192: ,X_MSG_COUNT => X_MSG_COUNT
193: ,X_MSG_DATA => X_MSG_DATA
193: ,X_MSG_DATA => X_MSG_DATA
194: ,X_RETURN_STATUS => X_RETURN_STATUS);
195:
196: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
197: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
198: P_API_NAME => L_API_NAME
199: ,P_PKG_NAME => G_PKG_NAME
200: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
201: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
197: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
198: P_API_NAME => L_API_NAME
199: ,P_PKG_NAME => G_PKG_NAME
200: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
201: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
202: ,P_SQLCODE => SQLCODE
203: ,P_SQLERRM => SQLERRM
204: ,X_MSG_COUNT => X_MSG_COUNT
205: ,X_MSG_DATA => X_MSG_DATA
205: ,X_MSG_DATA => X_MSG_DATA
206: ,X_RETURN_STATUS => X_RETURN_STATUS);
207:
208: WHEN OTHERS THEN
209: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
210: P_API_NAME => L_API_NAME
211: ,P_PKG_NAME => G_PKG_NAME
212: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
213: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
208: WHEN OTHERS THEN
209: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
210: P_API_NAME => L_API_NAME
211: ,P_PKG_NAME => G_PKG_NAME
212: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
213: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
214: ,P_SQLCODE => SQLCODE
215: ,P_SQLERRM => SQLERRM
216: ,X_MSG_COUNT => X_MSG_COUNT
209: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
210: P_API_NAME => L_API_NAME
211: ,P_PKG_NAME => G_PKG_NAME
212: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
213: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
214: ,P_SQLCODE => SQLCODE
215: ,P_SQLERRM => SQLERRM
216: ,X_MSG_COUNT => X_MSG_COUNT
217: ,X_MSG_DATA => X_MSG_DATA