105: END IF;
106:
107: -- IF PG_DEBUG < 10 THEN
108: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
109: IEX_DEBUG_PUB.LogMessage('Create_case_definitions: ' || 'Before Calling IEX_CASE_DEFINITIONS_PKG.Insert_Row');
110: END IF;
111: -- Invoke table handler(IEX_CASE_DEFINITIONS_PKG.Insert_Row)
112: IEX_CASE_DEFINITIONS_PKG.Insert_Row(
113: x_rowid =>v_rowid,
107: -- IF PG_DEBUG < 10 THEN
108: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
109: IEX_DEBUG_PUB.LogMessage('Create_case_definitions: ' || 'Before Calling IEX_CASE_DEFINITIONS_PKG.Insert_Row');
110: END IF;
111: -- Invoke table handler(IEX_CASE_DEFINITIONS_PKG.Insert_Row)
112: IEX_CASE_DEFINITIONS_PKG.Insert_Row(
113: x_rowid =>v_rowid,
114: x_CASE_DEFINITION_ID => v_CASE_DEFINITION_ID,
115: x_COLUMN_NAME => p_case_definition_rec.COLUMN_NAME,
108: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
109: IEX_DEBUG_PUB.LogMessage('Create_case_definitions: ' || 'Before Calling IEX_CASE_DEFINITIONS_PKG.Insert_Row');
110: END IF;
111: -- Invoke table handler(IEX_CASE_DEFINITIONS_PKG.Insert_Row)
112: IEX_CASE_DEFINITIONS_PKG.Insert_Row(
113: x_rowid =>v_rowid,
114: x_CASE_DEFINITION_ID => v_CASE_DEFINITION_ID,
115: x_COLUMN_NAME => p_case_definition_rec.COLUMN_NAME,
116: x_COLUMN_VALUE => p_case_definition_rec.COLUMN_VALUE,
147: -- Hint: Primary key should be returned.
148: x_CASE_DEFINITION_ID := v_CASE_DEFINITION_ID;
149: -- IF PG_DEBUG < 10 THEN
150: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
151: IEX_DEBUG_PUB.LogMessage('Create_case_definitions: ' || 'After Calling IEX_CASE_DEFINITIONS_PKG.Insert_Row and case definition id => '||x_CASE_DEFINITION_ID);
152: END IF;
153:
154: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
155: RAISE FND_API.G_EXC_ERROR;
258: --
259: -- Api body
260: --
261:
262: -- Invoke table handler(IEX_CASE_DEFINITIONS_PKG.Update_Row)
263: -- call locking table handler
264: -- IF PG_DEBUG < 10 THEN
265: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
266: IEX_DEBUG_PUB.LogMessage('Update_case_definitions: ' || 'Before Calling IEX_CASE_DEFINITIONS_PKG.lock_row');
262: -- Invoke table handler(IEX_CASE_DEFINITIONS_PKG.Update_Row)
263: -- call locking table handler
264: -- IF PG_DEBUG < 10 THEN
265: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
266: IEX_DEBUG_PUB.LogMessage('Update_case_definitions: ' || 'Before Calling IEX_CASE_DEFINITIONS_PKG.lock_row');
267: END IF;
268: IEX_CASE_DEFINITIONS_PKG.lock_row (
269: p_case_definition_rec.CASE_DEFINITION_ID,
270: l_object_version_number
264: -- IF PG_DEBUG < 10 THEN
265: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
266: IEX_DEBUG_PUB.LogMessage('Update_case_definitions: ' || 'Before Calling IEX_CASE_DEFINITIONS_PKG.lock_row');
267: END IF;
268: IEX_CASE_DEFINITIONS_PKG.lock_row (
269: p_case_definition_rec.CASE_DEFINITION_ID,
270: l_object_version_number
271: );
272: -- IF PG_DEBUG < 10 THEN
270: l_object_version_number
271: );
272: -- IF PG_DEBUG < 10 THEN
273: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
274: IEX_DEBUG_PUB.LogMessage('Update_case_definitions: ' || 'Before Calling IEX_CASE_DEFINITIONS_PKG.update_row');
275: END IF;
276: IEX_CASE_DEFINITIONS_PKG.Update_Row(
277: x_CASE_DEFINITION_ID => p_case_definition_rec.CASE_DEFINITION_ID,
278: x_COLUMN_NAME => p_case_definition_rec.COLUMN_NAME,
272: -- IF PG_DEBUG < 10 THEN
273: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
274: IEX_DEBUG_PUB.LogMessage('Update_case_definitions: ' || 'Before Calling IEX_CASE_DEFINITIONS_PKG.update_row');
275: END IF;
276: IEX_CASE_DEFINITIONS_PKG.Update_Row(
277: x_CASE_DEFINITION_ID => p_case_definition_rec.CASE_DEFINITION_ID,
278: x_COLUMN_NAME => p_case_definition_rec.COLUMN_NAME,
279: x_COLUMN_VALUE =>p_case_definition_rec.COLUMN_VALUE,
280: x_ACTIVE_FLAG =>p_case_definition_rec.ACTIVE_FLAG,
414: --
415: -- Api body
416: --
417:
418: -- Invoke table handler(IEX_CASE_DEFINITIONS_PKG.Delete_Row)
419: IEX_CASE_DEFINITIONS_PKG.Delete_Row(
420: X_CASE_DEFINITION_ID => p_CASE_DEFINITION_ID);
421: --
422: -- End of API body
415: -- Api body
416: --
417:
418: -- Invoke table handler(IEX_CASE_DEFINITIONS_PKG.Delete_Row)
419: IEX_CASE_DEFINITIONS_PKG.Delete_Row(
420: X_CASE_DEFINITION_ID => p_CASE_DEFINITION_ID);
421: --
422: -- End of API body
423: --