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_CASES_PVT dependencies on FND_LOG

Line 15: PG_DEBUG NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IEX_CASES_PVT';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'iexvaseb.pls';
13:
14: --PG_DEBUG NUMBER(2) := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
15: PG_DEBUG NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
16:
17: PROCEDURE Create_cas(
18: P_Api_Version_Number IN NUMBER,
19: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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

41: Cursor c2 is SELECT IEX_CASES_ALL_B_S.nextval from dual;
42:
43: BEGIN
44: -- IF PG_DEBUG < 10 THEN
45: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
46: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_CASES_PVT.Create_cas ******** ');
47: END IF;
48: -- Standard Start of API savepoint
49: SAVEPOINT CREATE_CAS_PVT;

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

56: THEN
57: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
58: END IF;
59: -- IF PG_DEBUG < 10 THEN
60: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
61: IEX_DEBUG_PUB.LogMessage('Create_cas: ' || 'After Compatibility Check');
62: END IF;
63:
64: -- Initialize message list if p_init_msg_list is set to TRUE.

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

86: END IF;
87: RAISE FND_API.G_EXC_ERROR;
88: END IF;
89: -- IF PG_DEBUG < 10 THEN
90: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
91: IEX_DEBUG_PUB.LogMessage('Create_cas: ' || 'After Global user Check');
92: END IF;
93:
94: -- Get org_id if not present

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

100: else
101: v_org_id :=p_cas_rec.org_id;
102: END IF;
103: -- IF PG_DEBUG < 10 THEN
104: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
105: IEX_DEBUG_PUB.LogMessage('Create_cas: ' || 'After ORG ID Check and Org_id is => '||v_org_id);
106: END IF;
107:
108: -- Set Status_code to 'CURRENT'

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

116: OPEN C2;
117: FETCH C2 INTO v_CAS_ID;
118: CLOSE C2;
119: -- IF PG_DEBUG < 10 THEN
120: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
121: IEX_DEBUG_PUB.LogMessage('Create_cas: ' || 'After CAS ID Check and cas_id is => '||v_cas_id);
122: END IF;
123:
124: --Case number

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

127: else
128: v_case_number := p_cas_rec.CASE_NUMBER;
129: end if;
130: -- IF PG_DEBUG < 10 THEN
131: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
132: IEX_DEBUG_PUB.LogMessage('Create_cas: ' || 'After CAS Number Check and cas_number is => '||v_case_number);
133: END IF;
134:
135: --Active_flag

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

134:
135: --Active_flag
136: v_active_flag:='Y';
137: -- IF PG_DEBUG < 10 THEN
138: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
139: IEX_DEBUG_PUB.LogMessage('Create_cas: ' || 'After active flag Check' );
140: END IF;
141:
142: --Case established Date

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

145: else
146: v_CASE_ESTABLISHED_DATE := p_cas_rec.CASE_ESTABLISHED_DATE;
147: end if;
148: -- IF PG_DEBUG < 10 THEN
149: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
150: IEX_DEBUG_PUB.LogMessage('Create_cas: ' || 'After Case ESTABLISHED Date Check and case_ESTABLISHED is => '||v_case_ESTABLISHED_DATE);
151: END IF;
152: -- Added on 11/21/01
153: --Party Id check

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

158: fnd_msg_pub.add;
159: RAISE FND_API.G_EXC_ERROR;
160: END IF;
161: -- IF PG_DEBUG < 10 THEN
162: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
163: IEX_DEBUG_PUB.LogMessage ('Create_cas: ' || 'After Party id check');
164: END IF;
165:
166: -- IF PG_DEBUG < 10 THEN

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

163: IEX_DEBUG_PUB.LogMessage ('Create_cas: ' || 'After Party id check');
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(

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

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

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

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

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

304: l_object_version_number iex_cases_all_b.object_version_number%TYPE:=p_cas_rec.object_version_number;
305:
306: BEGIN
307: -- IF PG_DEBUG < 10 THEN
308: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
309: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_CASES_PVT.update_cas ******** ');
310: END IF;
311: -- Standard Start of API savepoint
312: SAVEPOINT UPDATE_CAS_PVT;

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

335: -- API body
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

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

345: p_cas_rec.cas_id,
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,

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

416: ( p_count => x_msg_count,
417: p_data => x_msg_data
418: );
419: -- IF PG_DEBUG < 10 THEN
420: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
421: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_CASES_PVT.Update_cas ******** ');
422: END IF;
423: EXCEPTION
424: WHEN FND_API.G_EXC_ERROR THEN