172: EXCEPTION
173:
174: WHEN FND_API.G_EXC_ERROR THEN
175:
176: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
177: P_API_NAME => L_API_NAME
178: ,P_PKG_NAME => G_PKG_NAME
179: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
180: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
176: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
177: P_API_NAME => L_API_NAME
178: ,P_PKG_NAME => G_PKG_NAME
179: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
180: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
181: ,P_ROLLBACK_FLAG => 'N'
182: ,X_MSG_COUNT => X_MSG_COUNT
183: ,X_MSG_DATA => X_MSG_DATA
184: ,X_RETURN_STATUS => X_RETURN_STATUS);
184: ,X_RETURN_STATUS => X_RETURN_STATUS);
185:
186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
187:
188: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
189: P_API_NAME => L_API_NAME
190: ,P_PKG_NAME => G_PKG_NAME
191: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
192: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
188: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
189: P_API_NAME => L_API_NAME
190: ,P_PKG_NAME => G_PKG_NAME
191: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
192: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
193: ,P_ROLLBACK_FLAG => 'N'
194: ,X_MSG_COUNT => X_MSG_COUNT
195: ,X_MSG_DATA => X_MSG_DATA
196: ,X_RETURN_STATUS => X_RETURN_STATUS);
196: ,X_RETURN_STATUS => X_RETURN_STATUS);
197:
198: WHEN OTHERS THEN
199:
200: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
201: P_API_NAME => L_API_NAME
202: ,P_PKG_NAME => G_PKG_NAME
203: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
204: ,P_SQLCODE => SQLCODE
199:
200: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
201: P_API_NAME => L_API_NAME
202: ,P_PKG_NAME => G_PKG_NAME
203: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
204: ,P_SQLCODE => SQLCODE
205: ,P_SQLERRM => SQLERRM
206: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
207: ,P_ROLLBACK_FLAG => 'N'
202: ,P_PKG_NAME => G_PKG_NAME
203: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
204: ,P_SQLCODE => SQLCODE
205: ,P_SQLERRM => SQLERRM
206: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
207: ,P_ROLLBACK_FLAG => 'N'
208: ,X_MSG_COUNT => X_MSG_COUNT
209: ,X_MSG_DATA => X_MSG_DATA
210: ,X_RETURN_STATUS => X_RETURN_STATUS);