86:
87: EXCEPTION
88:
89: WHEN FND_API.G_EXC_ERROR THEN
90: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
91: P_API_NAME => L_API_NAME,
92: P_PKG_NAME => G_PKG_NAME,
93: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
94: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
90: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
91: P_API_NAME => L_API_NAME,
92: P_PKG_NAME => G_PKG_NAME,
93: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
94: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
95: P_SQLCODE => SQLCODE,
96: P_SQLERRM => SQLERRM,
97: X_MSG_COUNT => X_MSG_COUNT,
98: X_MSG_DATA => X_MSG_DATA,
99: X_RETURN_STATUS => X_RETURN_STATUS
100: );
101:
102: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
103: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
104: P_API_NAME => L_API_NAME,
105: P_PKG_NAME => G_PKG_NAME,
106: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
107: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
103: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
104: P_API_NAME => L_API_NAME,
105: P_PKG_NAME => G_PKG_NAME,
106: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
107: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
108: P_SQLCODE => SQLCODE,
109: P_SQLERRM => SQLERRM,
110: X_MSG_COUNT => X_MSG_COUNT,
111: X_MSG_DATA => X_MSG_DATA,
112: X_RETURN_STATUS => X_RETURN_STATUS
113: );
114:
115: WHEN OTHERS 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 => ASO_UTILITY_PVT.G_EXC_OTHERS,
120: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
115: WHEN OTHERS 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 => ASO_UTILITY_PVT.G_EXC_OTHERS,
120: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
121: P_SQLCODE => SQLCODE,
122: P_SQLERRM => SQLERRM,
123: X_MSG_COUNT => X_MSG_COUNT,
116: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
117: P_API_NAME => L_API_NAME,
118: P_PKG_NAME => G_PKG_NAME,
119: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
120: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
121: P_SQLCODE => SQLCODE,
122: P_SQLERRM => SQLERRM,
123: X_MSG_COUNT => X_MSG_COUNT,
124: X_MSG_DATA => X_MSG_DATA,