293:
294: EXCEPTION
295: WHEN NO_DATA_FOUND THEN
296: IF (l_debug = 1) THEN
297: inv_trx_util_pub.trace(' no data found in gen_update','MTL_OG_UTIL_PKG');
298: END IF;
299: x_return_status := FND_API.G_RET_STS_ERROR;
300: WHEN OTHERS THEN
301: IF (l_debug = 1) THEN
298: END IF;
299: x_return_status := FND_API.G_RET_STS_ERROR;
300: WHEN OTHERS THEN
301: IF (l_debug = 1) THEN
302: inv_trx_util_pub.trace(' exception in gen_update','MTL_OG_UTIL_PKG');
303: END IF;
304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
305: END;
306: BEGIN
321: WHERE gen_object_id = l_object_id;
322: EXCEPTION
323: WHEN no_data_found THEN
324: IF (l_debug = 1) THEN
325: inv_trx_util_pub.trace(' no data found while trying to update in gen_update','MTL_OG_UTIL_PKG');
326: END IF;
327: x_return_status := FND_API.G_RET_STS_ERROR;
328: WHEN OTHERS THEN
329: IF (l_debug = 1) THEN
326: END IF;
327: x_return_status := FND_API.G_RET_STS_ERROR;
328: WHEN OTHERS THEN
329: IF (l_debug = 1) THEN
330: inv_trx_util_pub.trace(' exception in gen_update when trying to update','MTL_OG_UTIL_PKG');
331: END IF;
332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
333: END;
334: END gen_update;