176:
177: --END IF;
178: -- IF PG_DEBUG < 10 THEN
179: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
180: IEX_DEBUG_PUB.LogMessage('Create_case_contact: ' || 'Before calling IEX_CASE_CONTACTS_PKG.Insert_Row');
181: END IF;
182: -- Invoke table handler(IEX_CASE_CONTACTS_PKG.Insert_Row)
183: IEX_CASE_CONTACTS_PKG.Insert_Row(
184: x_rowid =>v_rowid,
178: -- IF PG_DEBUG < 10 THEN
179: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
180: IEX_DEBUG_PUB.LogMessage('Create_case_contact: ' || 'Before calling IEX_CASE_CONTACTS_PKG.Insert_Row');
181: END IF;
182: -- Invoke table handler(IEX_CASE_CONTACTS_PKG.Insert_Row)
183: IEX_CASE_CONTACTS_PKG.Insert_Row(
184: x_rowid =>v_rowid,
185: p_CAS_CONTACT_ID => v_CAS_CONTACT_ID,
186: p_CAS_ID => p_case_contact_rec.CAS_ID,
179: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
180: IEX_DEBUG_PUB.LogMessage('Create_case_contact: ' || 'Before calling IEX_CASE_CONTACTS_PKG.Insert_Row');
181: END IF;
182: -- Invoke table handler(IEX_CASE_CONTACTS_PKG.Insert_Row)
183: IEX_CASE_CONTACTS_PKG.Insert_Row(
184: x_rowid =>v_rowid,
185: p_CAS_CONTACT_ID => v_CAS_CONTACT_ID,
186: p_CAS_ID => p_case_contact_rec.CAS_ID,
187: p_CONTACT_PARTY_ID => p_case_contact_rec.CONTACT_PARTY_ID,
219:
220: x_CAS_CONTACT_ID := V_CAS_CONTACT_ID;
221: -- IF PG_DEBUG < 10 THEN
222: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
223: IEX_DEBUG_PUB.LogMessage('Create_case_contact: ' || 'After Calling IEX_CASE_CONTACTS_PKG.Insert_Row and cas Contact id => '
224: ||x_cas_contact_id);
225: END IF;
226: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
227: RAISE FND_API.G_EXC_ERROR;
334: -- Api body
335: --
336: -- Invoke table handler(IEX_CASES_ALL_B_PKG.Update_Row)
337: -- call locking table handler
338: IEX_CASE_CONTACTS_PKG.lock_row (
339: p_case_contact_rec.cas_contact_id,
340: l_object_version_number
341: );
342:
339: p_case_contact_rec.cas_contact_id,
340: l_object_version_number
341: );
342:
343: -- Invoke table handler(IEX_CASE_CONTACTS_PKG.Update_Row)
344: IEX_CASE_CONTACTS_PKG.Update_Row(
345: p_CAS_CONTACT_ID => p_case_contact_rec.CAS_CONTACT_ID,
346: p_CAS_ID => p_case_contact_rec.CAS_ID,
347: p_CONTACT_PARTY_ID => p_case_contact_rec.CONTACT_PARTY_ID,
340: l_object_version_number
341: );
342:
343: -- Invoke table handler(IEX_CASE_CONTACTS_PKG.Update_Row)
344: IEX_CASE_CONTACTS_PKG.Update_Row(
345: p_CAS_CONTACT_ID => p_case_contact_rec.CAS_CONTACT_ID,
346: p_CAS_ID => p_case_contact_rec.CAS_ID,
347: p_CONTACT_PARTY_ID => p_case_contact_rec.CONTACT_PARTY_ID,
348: p_OBJECT_VERSION_NUMBER => l_OBJECT_VERSION_NUMBER +1,
480: --
481: -- Api body
482: --
483:
484: -- Invoke table handler(IEX_CASE_CONTACTS_PKG.Delete_Row)
485: IEX_CASE_CONTACTS_PKG.Delete_Row(
486: p_CAS_CONTACT_ID => p_CAS_CONTACT_ID);
487: --
488: -- End of API body
481: -- Api body
482: --
483:
484: -- Invoke table handler(IEX_CASE_CONTACTS_PKG.Delete_Row)
485: IEX_CASE_CONTACTS_PKG.Delete_Row(
486: p_CAS_CONTACT_ID => p_CAS_CONTACT_ID);
487: --
488: -- End of API body
489: --