97: x_enable_setup_id := l_enable_setup_id;
98: x_object_version_number := 1;
99: EXCEPTION
100: WHEN OTHERS THEN
101: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
102: P_API_NAME => L_API_NAME,
103: P_PKG_NAME => G_PKG_NAME,
104: P_EXCEPTION_LEVEL => CSC_CORE_UTILS_PVT.G_MSG_LVL_OTHERS,
105: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
100: WHEN OTHERS THEN
101: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
102: P_API_NAME => L_API_NAME,
103: P_PKG_NAME => G_PKG_NAME,
104: P_EXCEPTION_LEVEL => CSC_CORE_UTILS_PVT.G_MSG_LVL_OTHERS,
105: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
106: X_MSG_COUNT => L_MSG_COUNT,
107: X_MSG_DATA => L_MSG_DATA,
108: X_RETURN_STATUS => L_RETURN_STATUS);
101: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
102: P_API_NAME => L_API_NAME,
103: P_PKG_NAME => G_PKG_NAME,
104: P_EXCEPTION_LEVEL => CSC_CORE_UTILS_PVT.G_MSG_LVL_OTHERS,
105: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
106: X_MSG_COUNT => L_MSG_COUNT,
107: X_MSG_DATA => L_MSG_DATA,
108: X_RETURN_STATUS => L_RETURN_STATUS);
109: APP_EXCEPTION.RAISE_EXCEPTION;
184: End If;
185:
186: EXCEPTION
187: WHEN OTHERS THEN
188: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
189: P_API_NAME => L_API_NAME,
190: P_PKG_NAME => G_PKG_NAME,
191: P_EXCEPTION_LEVEL => CSC_CORE_UTILS_PVT.G_MSG_LVL_OTHERS,
192: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
187: WHEN OTHERS THEN
188: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
189: P_API_NAME => L_API_NAME,
190: P_PKG_NAME => G_PKG_NAME,
191: P_EXCEPTION_LEVEL => CSC_CORE_UTILS_PVT.G_MSG_LVL_OTHERS,
192: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
193: X_MSG_COUNT => L_MSG_COUNT,
194: X_MSG_DATA => L_MSG_DATA,
195: X_RETURN_STATUS => L_RETURN_STATUS);
188: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
189: P_API_NAME => L_API_NAME,
190: P_PKG_NAME => G_PKG_NAME,
191: P_EXCEPTION_LEVEL => CSC_CORE_UTILS_PVT.G_MSG_LVL_OTHERS,
192: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
193: X_MSG_COUNT => L_MSG_COUNT,
194: X_MSG_DATA => L_MSG_DATA,
195: X_RETURN_STATUS => L_RETURN_STATUS);
196: APP_EXCEPTION.RAISE_EXCEPTION;
215: End If;
216:
217: EXCEPTION
218: WHEN OTHERS THEN
219: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
220: P_API_NAME => L_API_NAME,
221: P_PKG_NAME => G_PKG_NAME,
222: P_EXCEPTION_LEVEL => CSC_CORE_UTILS_PVT.G_MSG_LVL_OTHERS,
223: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
218: WHEN OTHERS THEN
219: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
220: P_API_NAME => L_API_NAME,
221: P_PKG_NAME => G_PKG_NAME,
222: P_EXCEPTION_LEVEL => CSC_CORE_UTILS_PVT.G_MSG_LVL_OTHERS,
223: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
224: X_MSG_COUNT => L_MSG_COUNT,
225: X_MSG_DATA => L_MSG_DATA,
226: X_RETURN_STATUS => L_RETURN_STATUS);
219: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
220: P_API_NAME => L_API_NAME,
221: P_PKG_NAME => G_PKG_NAME,
222: P_EXCEPTION_LEVEL => CSC_CORE_UTILS_PVT.G_MSG_LVL_OTHERS,
223: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
224: X_MSG_COUNT => L_MSG_COUNT,
225: X_MSG_DATA => L_MSG_DATA,
226: X_RETURN_STATUS => L_RETURN_STATUS);
227: APP_EXCEPTION.RAISE_EXCEPTION;
257: CLOSE C1;
258:
259: EXCEPTION
260: WHEN OTHERS THEN
261: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
262: P_API_NAME => L_API_NAME,
263: P_PKG_NAME => G_PKG_NAME,
264: P_EXCEPTION_LEVEL => CSC_CORE_UTILS_PVT.G_MSG_LVL_OTHERS,
265: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
260: WHEN OTHERS THEN
261: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
262: P_API_NAME => L_API_NAME,
263: P_PKG_NAME => G_PKG_NAME,
264: P_EXCEPTION_LEVEL => CSC_CORE_UTILS_PVT.G_MSG_LVL_OTHERS,
265: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
266: X_MSG_COUNT => L_MSG_COUNT,
267: X_MSG_DATA => L_MSG_DATA,
268: X_RETURN_STATUS => L_RETURN_STATUS);
261: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
262: P_API_NAME => L_API_NAME,
263: P_PKG_NAME => G_PKG_NAME,
264: P_EXCEPTION_LEVEL => CSC_CORE_UTILS_PVT.G_MSG_LVL_OTHERS,
265: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
266: X_MSG_COUNT => L_MSG_COUNT,
267: X_MSG_DATA => L_MSG_DATA,
268: X_RETURN_STATUS => L_RETURN_STATUS);
269: APP_EXCEPTION.RAISE_EXCEPTION;