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 FND_LOG

Line 17: PG_DEBUG NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

13:
14:
15: -- Hint: Primary key needs to be returned.
16: --PG_DEBUG NUMBER(2) := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
17: PG_DEBUG NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
18:
19: PROCEDURE Create_case_contact(
20: P_Api_Version_Number IN NUMBER,
21: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

Line 61: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

57: and primary_flag = 'Y';
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;

Line 76: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

72: THEN
73: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
74: END IF;
75: -- IF PG_DEBUG < 10 THEN
76: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
77: IEX_DEBUG_PUB.LogMessage('Create_case_contact: ' || 'After Compatibility Check');
78: END IF;
79:
80:

Line 108: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

104: END IF;
105: RAISE FND_API.G_EXC_ERROR;
106: END IF;
107: -- IF PG_DEBUG < 10 THEN
108: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
109: IEX_DEBUG_PUB.LogMessage('Create_case_contact: ' || 'After Global user Check');
110: END IF;
111:
112: --IF p_validation_level = FND_API.G_VALID_LEVEL_FULL THEN

Line 124: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

120: OPEN C2;
121: FETCH C2 INTO v_CAS_CONTACT_ID;
122: CLOSE C2;
123: -- IF PG_DEBUG < 10 THEN
124: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
125: IEX_DEBUG_PUB.LogMessage('Create_case_contact: ' || 'After CAS CONTACT ID Check and cas_contact_id is => '||v_cas_contact_id);
126: END IF;
127: --check for cas_id
128: IF (p_case_contact_rec.cas_id IS NULL) OR (p_case_contact_rec.cas_ID = FND_API.G_MISS_NUM) THEN

Line 136: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

132: fnd_msg_pub.add;
133: RAISE FND_API.G_EXC_ERROR;
134: END IF;
135: -- IF PG_DEBUG < 10 THEN
136: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
137: IEX_DEBUG_PUB.LogMessage('Create_case_contact: ' || 'After CAS ID Check ');
138: END IF;
139: --check for contact_party_id
140: IF (p_case_contact_rec.contact_party_id IS NULL) OR (p_case_contact_rec.contact_party_id = FND_API.G_MISS_NUM) THEN

Line 148: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

144: fnd_msg_pub.add;
145: RAISE FND_API.G_EXC_ERROR;
146: END IF;
147: -- IF PG_DEBUG < 10 THEN
148: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
149: IEX_DEBUG_PUB.LogMessage('Create_case_contact: ' || 'After CAS contact ID Check ');
150: END IF;
151: --Populate default address_id if it is not passed
152: IF (p_case_contact_rec.address_id IS NULL)

Line 179: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

175: END IF;
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(

Line 222: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

218: );
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

Line 248: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

244: ( p_count => x_msg_count,
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

Line 306: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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 ******** ');
308: END IF;
309: -- Standard Start of API savepoint
310: SAVEPOINT UPDATE_case_contact_PVT;

Line 398: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

394: ( p_count => x_msg_count,
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

Line 455: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

451: l_api_version_number CONSTANT NUMBER := 2.0;
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;

Line 505: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

501: ( p_count => x_msg_count,
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