102: p_data => x_msg_data
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: ,X_MSG_COUNT => X_MSG_COUNT
112: ,X_MSG_DATA => X_MSG_DATA
113: ,X_RETURN_STATUS => X_RETURN_STATUS);
114:
112: ,X_MSG_DATA => X_MSG_DATA
113: ,X_RETURN_STATUS => X_RETURN_STATUS);
114:
115: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
116: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
117: P_API_NAME => L_API_NAME
118: ,P_PKG_NAME => G_PKG_NAME
119: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
120: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
116: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
117: P_API_NAME => L_API_NAME
118: ,P_PKG_NAME => G_PKG_NAME
119: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
120: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
121: ,X_MSG_COUNT => X_MSG_COUNT
122: ,X_MSG_DATA => X_MSG_DATA
123: ,X_RETURN_STATUS => X_RETURN_STATUS);
124:
122: ,X_MSG_DATA => X_MSG_DATA
123: ,X_RETURN_STATUS => X_RETURN_STATUS);
124:
125: WHEN OTHERS THEN
126: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
127: P_API_NAME => L_API_NAME
128: ,P_PKG_NAME => G_PKG_NAME
129: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
130: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
125: WHEN OTHERS THEN
126: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
127: P_API_NAME => L_API_NAME
128: ,P_PKG_NAME => G_PKG_NAME
129: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
130: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
131: ,P_SQLCODE => SQLCODE
132: ,P_SQLERRM => SQLERRM
133: ,X_MSG_COUNT => X_MSG_COUNT
126: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
127: P_API_NAME => L_API_NAME
128: ,P_PKG_NAME => G_PKG_NAME
129: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
130: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
131: ,P_SQLCODE => SQLCODE
132: ,P_SQLERRM => SQLERRM
133: ,X_MSG_COUNT => X_MSG_COUNT
134: ,X_MSG_DATA => X_MSG_DATA