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