eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEX_CASE_CONTACTS_PVT dependencies on IEX_CASE_CONTACTS

Line 1: PACKAGE BODY IEX_CASE_CONTACTS_PVT as

1: PACKAGE BODY IEX_CASE_CONTACTS_PVT as
2: /* $Header: iexvconb.pls 120.1 2006/05/30 21:13:08 scherkas noship $ */
3: -- Start of Comments
4: -- Package name : IEX_CASE_CONTACTS_PVT
5: -- Purpose :

Line 4: -- Package name : IEX_CASE_CONTACTS_PVT

1: PACKAGE BODY IEX_CASE_CONTACTS_PVT as
2: /* $Header: iexvconb.pls 120.1 2006/05/30 21:13:08 scherkas noship $ */
3: -- Start of Comments
4: -- Package name : IEX_CASE_CONTACTS_PVT
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

Line 11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IEX_CASE_CONTACTS_PVT';

7: -- NOTE :
8: -- End of Comments
9:
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IEX_CASE_CONTACTS_PVT';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'iexvconb.pls';
13:
14:
15: -- Hint: Primary key needs to be returned.

Line 36: v_cas_contact_id iex_case_contacts.cas_contact_id%TYPE;

32: l_api_name CONSTANT VARCHAR2(30) := 'Create_case_contact';
33: l_api_version_number CONSTANT NUMBER := 2.0;
34: l_return_status_full VARCHAR2(1);
35: v_rowid VARCHAR2(24);
36: v_cas_contact_id iex_case_contacts.cas_contact_id%TYPE;
37: v_object_version_number iex_case_contacts.object_version_number%TYPE;
38: v_active_flag iex_case_contacts.active_flag%TYPE;
39: v_address_id iex_case_contacts.address_id%TYPE;
40: v_phone_id iex_case_contacts.phone_id%TYPE;

Line 37: v_object_version_number iex_case_contacts.object_version_number%TYPE;

33: l_api_version_number CONSTANT NUMBER := 2.0;
34: l_return_status_full VARCHAR2(1);
35: v_rowid VARCHAR2(24);
36: v_cas_contact_id iex_case_contacts.cas_contact_id%TYPE;
37: v_object_version_number iex_case_contacts.object_version_number%TYPE;
38: v_active_flag iex_case_contacts.active_flag%TYPE;
39: v_address_id iex_case_contacts.address_id%TYPE;
40: v_phone_id iex_case_contacts.phone_id%TYPE;
41: v_primary_flag iex_case_contacts.primary_flag%TYPE;

Line 38: v_active_flag iex_case_contacts.active_flag%TYPE;

34: l_return_status_full VARCHAR2(1);
35: v_rowid VARCHAR2(24);
36: v_cas_contact_id iex_case_contacts.cas_contact_id%TYPE;
37: v_object_version_number iex_case_contacts.object_version_number%TYPE;
38: v_active_flag iex_case_contacts.active_flag%TYPE;
39: v_address_id iex_case_contacts.address_id%TYPE;
40: v_phone_id iex_case_contacts.phone_id%TYPE;
41: v_primary_flag iex_case_contacts.primary_flag%TYPE;
42:

Line 39: v_address_id iex_case_contacts.address_id%TYPE;

35: v_rowid VARCHAR2(24);
36: v_cas_contact_id iex_case_contacts.cas_contact_id%TYPE;
37: v_object_version_number iex_case_contacts.object_version_number%TYPE;
38: v_active_flag iex_case_contacts.active_flag%TYPE;
39: v_address_id iex_case_contacts.address_id%TYPE;
40: v_phone_id iex_case_contacts.phone_id%TYPE;
41: v_primary_flag iex_case_contacts.primary_flag%TYPE;
42:
43: Cursor c2 is SELECT IEX_CASE_CONTACTS_S.nextval from dual;

Line 40: v_phone_id iex_case_contacts.phone_id%TYPE;

36: v_cas_contact_id iex_case_contacts.cas_contact_id%TYPE;
37: v_object_version_number iex_case_contacts.object_version_number%TYPE;
38: v_active_flag iex_case_contacts.active_flag%TYPE;
39: v_address_id iex_case_contacts.address_id%TYPE;
40: v_phone_id iex_case_contacts.phone_id%TYPE;
41: v_primary_flag iex_case_contacts.primary_flag%TYPE;
42:
43: Cursor c2 is SELECT IEX_CASE_CONTACTS_S.nextval from dual;
44:

Line 41: v_primary_flag iex_case_contacts.primary_flag%TYPE;

37: v_object_version_number iex_case_contacts.object_version_number%TYPE;
38: v_active_flag iex_case_contacts.active_flag%TYPE;
39: v_address_id iex_case_contacts.address_id%TYPE;
40: v_phone_id iex_case_contacts.phone_id%TYPE;
41: v_primary_flag iex_case_contacts.primary_flag%TYPE;
42:
43: Cursor c2 is SELECT IEX_CASE_CONTACTS_S.nextval from dual;
44:
45: CURSOR C_GET_ADDRESS(P_PARTY_ID NUMBER) IS

Line 43: Cursor c2 is SELECT IEX_CASE_CONTACTS_S.nextval from dual;

39: v_address_id iex_case_contacts.address_id%TYPE;
40: v_phone_id iex_case_contacts.phone_id%TYPE;
41: v_primary_flag iex_case_contacts.primary_flag%TYPE;
42:
43: Cursor c2 is SELECT IEX_CASE_CONTACTS_S.nextval from dual;
44:
45: CURSOR C_GET_ADDRESS(P_PARTY_ID NUMBER) IS
46: SELECT PARTY_SITE_ID
47: FROM HZ_PARTY_SITES

Line 62: IEX_DEBUG_PUB.LogMessage ('* start of Procedure =>IEX_CASE_CONTACTS_PVT.Create_case_contact ');

58:
59: BEGIN
60: -- IF PG_DEBUG < 10 THEN
61: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
62: IEX_DEBUG_PUB.LogMessage ('********* start of Procedure =>IEX_CASE_CONTACTS_PVT.Create_case_contact ******** ');
63: END IF;
64: -- Standard Start of API savepoint
65: SAVEPOINT CREATE_CASE_CONTACT_PVT;
66:

Line 180: IEX_DEBUG_PUB.LogMessage('Create_case_contact: ' || 'Before calling IEX_CASE_CONTACTS_PKG.Insert_Row');

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,

Line 182: -- Invoke table handler(IEX_CASE_CONTACTS_PKG.Insert_Row)

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,

Line 183: IEX_CASE_CONTACTS_PKG.Insert_Row(

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,

Line 223: IEX_DEBUG_PUB.LogMessage('Create_case_contact: ' || 'After Calling IEX_CASE_CONTACTS_PKG.Insert_Row and cas Contact 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;

Line 249: IEX_DEBUG_PUB.LogMessage ('* End of Procedure =>IEX_CASE_CONTACTS_PVT.Create_case_contact ');

245: p_data => x_msg_data
246: );
247: -- IF PG_DEBUG < 10 THEN
248: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
249: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_CASE_CONTACTS_PVT.Create_case_contact ******** ');
250: END IF;
251: EXCEPTION
252: WHEN FND_API.G_EXC_ERROR THEN
253: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

Line 303: l_object_version_number iex_case_contacts.object_version_number%TYPE:=p_case_contact_rec.object_version_number;

299:
300: IS
301: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_CASE_CONTACT';
302: l_api_version_number CONSTANT NUMBER := 2.0;
303: l_object_version_number iex_case_contacts.object_version_number%TYPE:=p_case_contact_rec.object_version_number;
304: BEGIN
305: -- IF PG_DEBUG < 10 THEN
306: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
307: IEX_DEBUG_PUB.LogMessage ('********* start of Procedure =>IEX_CASE_CONTACTS_PVT.update_case_contact ******** ');

Line 307: IEX_DEBUG_PUB.LogMessage ('* start of Procedure =>IEX_CASE_CONTACTS_PVT.update_case_contact ');

303: l_object_version_number iex_case_contacts.object_version_number%TYPE:=p_case_contact_rec.object_version_number;
304: BEGIN
305: -- IF PG_DEBUG < 10 THEN
306: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
307: IEX_DEBUG_PUB.LogMessage ('********* start of Procedure =>IEX_CASE_CONTACTS_PVT.update_case_contact ******** ');
308: END IF;
309: -- Standard Start of API savepoint
310: SAVEPOINT UPDATE_case_contact_PVT;
311:

Line 338: IEX_CASE_CONTACTS_PKG.lock_row (

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:

Line 343: -- Invoke table handler(IEX_CASE_CONTACTS_PKG.Update_Row)

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,

Line 344: IEX_CASE_CONTACTS_PKG.Update_Row(

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,

Line 399: IEX_DEBUG_PUB.LogMessage ('* end of Procedure =>IEX_CASE_CONTACTS_PVT.update_case_contact ');

395: p_data => x_msg_data
396: );
397: -- IF PG_DEBUG < 10 THEN
398: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
399: IEX_DEBUG_PUB.LogMessage ('********* end of Procedure =>IEX_CASE_CONTACTS_PVT.update_case_contact ******** ');
400: END IF;
401: EXCEPTION
402: WHEN FND_API.G_EXC_ERROR THEN
403: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

Line 456: IEX_DEBUG_PUB.LogMessage ('* start of Procedure =>IEX_CASE_CONTACTS_PVT.delete_case_contact ');

452:
453: BEGIN
454: -- IF PG_DEBUG < 10 THEN
455: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
456: IEX_DEBUG_PUB.LogMessage ('********* start of Procedure =>IEX_CASE_CONTACTS_PVT.delete_case_contact ******** ');
457: END IF;
458: -- Standard Start of API savepoint
459: SAVEPOINT DELETE_case_contact_PVT;
460:

Line 484: -- Invoke table handler(IEX_CASE_CONTACTS_PKG.Delete_Row)

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

Line 485: IEX_CASE_CONTACTS_PKG.Delete_Row(

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: --

Line 506: IEX_DEBUG_PUB.LogMessage ('* End of Procedure =>IEX_CASE_CONTACTS_PVT.delete_case_contact ');

502: p_data => x_msg_data
503: );
504: -- IF PG_DEBUG < 10 THEN
505: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
506: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_CASE_CONTACTS_PVT.delete_case_contact ******** ');
507: END IF;
508: EXCEPTION
509: WHEN FND_API.G_EXC_ERROR THEN
510: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

Line 543: End IEX_CASE_CONTACTS_PVT;

539: ,X_RETURN_STATUS => X_RETURN_STATUS);
540: End Delete_case_contact;
541:
542:
543: End IEX_CASE_CONTACTS_PVT;