APPS.IEX_CASES_PVT dependencies on IEX_CASES_PKG

Line 168: IEX_DEBUG_PUB.LogMessage('Create_cas: ' || 'Before Calling iex_cases_pkg.insert_row');

164: END IF;
165:
166: -- IF PG_DEBUG < 10 THEN
167: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
168: IEX_DEBUG_PUB.LogMessage('Create_cas: ' || 'Before Calling iex_cases_pkg.insert_row');
169: END IF;
170: -- Invoke table handler(IEX_CASES_ALL_B_PKG.Insert_Row)
171: IEX_CASES_PKG.Insert_Row(
172: x_rowid =>v_rowid,

Line 171: IEX_CASES_PKG.Insert_Row(

167: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
168: IEX_DEBUG_PUB.LogMessage('Create_cas: ' || 'Before Calling iex_cases_pkg.insert_row');
169: END IF;
170: -- Invoke table handler(IEX_CASES_ALL_B_PKG.Insert_Row)
171: IEX_CASES_PKG.Insert_Row(
172: x_rowid =>v_rowid,
173: x_CAS_ID => v_CAS_ID,
174: x_CASE_NUMBER => v_CASE_NUMBER,
175: x_active_flag => v_active_flag,

Line 220: IEX_DEBUG_PUB.LogMessage('Create_cas: ' || 'After Calling iex_cases_pkg.insert_row and case id => '||x_case_id);

216: -- Hint: Primary key should be returned.
217: x_CASE_ID := v_CAS_ID;
218: -- IF PG_DEBUG < 10 THEN
219: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
220: IEX_DEBUG_PUB.LogMessage('Create_cas: ' || 'After Calling iex_cases_pkg.insert_row and case id => '||x_case_id);
221: END IF;
222:
223:
224:

Line 340: IEX_DEBUG_PUB.LogMessage('Update_cas: ' || 'Before Calling iex_cases_pkg.lock_row');

336: --
337:
338: -- IF PG_DEBUG < 10 THEN
339: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
340: IEX_DEBUG_PUB.LogMessage('Update_cas: ' || 'Before Calling iex_cases_pkg.lock_row');
341: END IF;
342: -- Invoke table handler(IEX_CASES_ALL_B_PKG.Update_Row)
343: -- call locking table handler
344: IEX_CASES_PKG.lock_row (

Line 344: IEX_CASES_PKG.lock_row (

340: IEX_DEBUG_PUB.LogMessage('Update_cas: ' || 'Before Calling iex_cases_pkg.lock_row');
341: END IF;
342: -- Invoke table handler(IEX_CASES_ALL_B_PKG.Update_Row)
343: -- call locking table handler
344: IEX_CASES_PKG.lock_row (
345: p_cas_rec.cas_id,
346: l_object_version_number
347: );
348: -- IF PG_DEBUG < 10 THEN

Line 350: IEX_DEBUG_PUB.LogMessage('Update_cas: ' || 'Before Calling iex_cases_pkg.update_row');

346: l_object_version_number
347: );
348: -- IF PG_DEBUG < 10 THEN
349: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
350: IEX_DEBUG_PUB.LogMessage('Update_cas: ' || 'Before Calling iex_cases_pkg.update_row');
351: END IF;
352: IEX_CASES_PKG.Update_Row(
353: x_CAS_ID => p_cas_rec.CAS_ID,
354: x_CASE_NUMBER => p_cas_rec.CASE_NUMBER,

Line 352: IEX_CASES_PKG.Update_Row(

348: -- IF PG_DEBUG < 10 THEN
349: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
350: IEX_DEBUG_PUB.LogMessage('Update_cas: ' || 'Before Calling iex_cases_pkg.update_row');
351: END IF;
352: IEX_CASES_PKG.Update_Row(
353: x_CAS_ID => p_cas_rec.CAS_ID,
354: x_CASE_NUMBER => p_cas_rec.CASE_NUMBER,
355: x_ACTIVE_FLAG => p_cas_rec.ACTIVE_FLAG,
356: x_PARTY_ID => p_cas_rec.PARTY_ID,

Line 503: iex_cases_pkg.delete_row (p_cas_id);

499: -- API body
500: --
501:
502: -- call table handler to insert into jtf_tasks_temp_groups
503: iex_cases_pkg.delete_row (p_cas_id);
504:
505: -- Check return status from the above procedure call
506: IF x_return_status = FND_API.G_RET_STS_ERROR then
507: raise FND_API.G_EXC_ERROR;