151: );
152:
153: EXCEPTION
154: WHEN FND_API.G_EXC_ERROR THEN
155: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
156: P_API_NAME => L_API_NAME
157: ,P_PKG_NAME => G_PKG_NAME
158: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
159: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
155: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
156: P_API_NAME => L_API_NAME
157: ,P_PKG_NAME => G_PKG_NAME
158: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
159: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
160: ,X_MSG_COUNT => X_MSG_COUNT
161: ,X_MSG_DATA => X_MSG_DATA
162: ,X_RETURN_STATUS => X_RETURN_STATUS);
163:
161: ,X_MSG_DATA => X_MSG_DATA
162: ,X_RETURN_STATUS => X_RETURN_STATUS);
163:
164: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
165: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
166: P_API_NAME => L_API_NAME
167: ,P_PKG_NAME => G_PKG_NAME
168: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
169: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
165: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
166: P_API_NAME => L_API_NAME
167: ,P_PKG_NAME => G_PKG_NAME
168: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
169: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
170: ,X_MSG_COUNT => X_MSG_COUNT
171: ,X_MSG_DATA => X_MSG_DATA
172: ,X_RETURN_STATUS => X_RETURN_STATUS);
173:
171: ,X_MSG_DATA => X_MSG_DATA
172: ,X_RETURN_STATUS => X_RETURN_STATUS);
173:
174: WHEN OTHERS THEN
175: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
176: P_API_NAME => L_API_NAME
177: ,P_PKG_NAME => G_PKG_NAME
178: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
179: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
174: WHEN OTHERS THEN
175: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
176: P_API_NAME => L_API_NAME
177: ,P_PKG_NAME => G_PKG_NAME
178: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
179: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
180: ,P_SQLCODE => SQLCODE
181: ,P_SQLERRM => SQLERRM
182: ,X_MSG_COUNT => X_MSG_COUNT
175: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
176: P_API_NAME => L_API_NAME
177: ,P_PKG_NAME => G_PKG_NAME
178: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
179: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
180: ,P_SQLCODE => SQLCODE
181: ,P_SQLERRM => SQLERRM
182: ,X_MSG_COUNT => X_MSG_COUNT
183: ,X_MSG_DATA => X_MSG_DATA