125: END IF;
126:
127:
128: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
129: IEX_DEBUG_PUB.LogMessage('Before Calling iex_writeoff_objects_pkg.insert_row');
130: END IF;
131:
132: IEX_writeoff_objects_PKG.Insert_Row(
133: x_rowid => v_rowid,
128: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
129: IEX_DEBUG_PUB.LogMessage('Before Calling iex_writeoff_objects_pkg.insert_row');
130: END IF;
131:
132: IEX_writeoff_objects_PKG.Insert_Row(
133: x_rowid => v_rowid,
134: x_WRITEOFF_OBJECT_ID => v_writeoff_object_id,
135: x_WRITEOFF_ID => p_writeoff_obj_rec.WRITEOFF_ID,
136: x_OBJECT_VERSION_NUMBER => v_OBJECT_VERSION_NUMBER,
174:
175:
176: x_writeoff_object_id := v_writeoff_object_id;
177: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
178: IEX_DEBUG_PUB.LogMessage('After Calling iex_writeoff_objects_pkg.insert_row'||
179: 'and writeoff_object_id => '||x_writeoff_object_id);
180: END IF;
181:
182:
280: --
281:
282: -- Debug Message
283: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
284: IEX_DEBUG_PUB.LogMessage('Before Calling iex_writeoff_objects_pkg.lock_row');
285: END IF;
286: -- Invoke table handler(IEX_writeoff_objects_PKG.Update_Row)
287: -- call locking table handler
288: IEX_writeoff_objects_PKG.lock_row (
282: -- Debug Message
283: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
284: IEX_DEBUG_PUB.LogMessage('Before Calling iex_writeoff_objects_pkg.lock_row');
285: END IF;
286: -- Invoke table handler(IEX_writeoff_objects_PKG.Update_Row)
287: -- call locking table handler
288: IEX_writeoff_objects_PKG.lock_row (
289: p_writeoff_obj_rec.writeoff_object_id,
290: v_object_version_number
284: IEX_DEBUG_PUB.LogMessage('Before Calling iex_writeoff_objects_pkg.lock_row');
285: END IF;
286: -- Invoke table handler(IEX_writeoff_objects_PKG.Update_Row)
287: -- call locking table handler
288: IEX_writeoff_objects_PKG.lock_row (
289: p_writeoff_obj_rec.writeoff_object_id,
290: v_object_version_number
291: );
292:
290: v_object_version_number
291: );
292:
293: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
294: IEX_DEBUG_PUB.LogMessage('Before Calling iex_writeoff_objects_pkg.update_row');
295: END IF;
296:
297: IEX_writeoff_objects_PKG.Update_Row(
298: x_WRITEOFF_OBJECT_ID => p_writeoff_obj_rec.writeoff_object_id,
293: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
294: IEX_DEBUG_PUB.LogMessage('Before Calling iex_writeoff_objects_pkg.update_row');
295: END IF;
296:
297: IEX_writeoff_objects_PKG.Update_Row(
298: x_WRITEOFF_OBJECT_ID => p_writeoff_obj_rec.writeoff_object_id,
299: x_WRITEOFF_ID => p_writeoff_obj_rec.WRITEOFF_ID,
300: x_OBJECT_VERSION_NUMBER => v_OBJECT_VERSION_NUMBER + 1,
301: x_CONTRACT_ID => p_writeoff_obj_rec.CONTRACT_ID,
427: -- API body
428: --
429:
430: -- call table handler to insert into jtf_tasks_temp_groups
431: iex_writeoff_objects_pkg.delete_row (p_writeoff_object_id);
432:
433: -- Check return status from the above procedure call
434: IF x_return_status = FND_API.G_RET_STS_ERROR then
435: raise FND_API.G_EXC_ERROR;