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

Line 10: PG_DEBUG NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

6:
7: /* this will be the outside wrapper for the concurrent program to call the "creation" in batch
8: */
9: --PG_DEBUG NUMBER(2) := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
10: PG_DEBUG NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
11:
12: PROCEDURE IEX_CASE_OWNER_CONCUR(ERRBUF OUT NOCOPY VARCHAR2,
13: RETCODE OUT NOCOPY VARCHAR2,
14: p_list_name IN VARCHAR2)

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

23:
24: BEGIN
25:
26: -- IF PG_DEBUG < 10 THEN
27: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
28: iex_debug_pub.LogMessage ('Starting IEX_CASE_OWNER_CONCUR');
29: END IF;
30:
31: IF p_list_name IS NULL THEN

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

30:
31: IF p_list_name IS NULL THEN
32:
33: -- IF PG_DEBUG < 10 THEN
34: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
35: iex_debug_pub.LogMessage ('IEX_CASE_OWNER_CONCUR: ' || 'p_list_name is null and calling RUN_LOAD_BALANCE');
36: END IF;
37:
38: IEX_CASE_OWNER_PUB.Run_Load_Balance(p_api_version => 1.0,

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

41: x_return_status => l_return_status,
42: x_msg_count => l_msg_count,
43: x_msg_data => l_msg_data);
44: -- IF PG_DEBUG < 10 THEN
45: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
46: iex_debug_pub.LogMessage ('IEX_CASE_OWNER_CONCUR: ' || 'after RUN_LOAD_BALANCE:return_status=' || l_return_status);
47: END IF;
48:
49: END IF;

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

126: l_count number;
127: BEGIN
128:
129: -- IF PG_DEBUG < 10 THEN
130: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
131: iex_debug_pub.LogMessage ('starting RUN_LOAD_BALANCE');
132: END IF;
133:
134: -- Standard Start of API savepoint

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

151: --
152:
153: FOR r_party IN c_parties LOOP
154: -- IF PG_DEBUG < 10 THEN
155: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
156: iex_debug_pub.LogMessage('Run_Load_Balance: ' || 'in C_PARTIES LOOP:party_id=' || r_party.party_id);
157: END IF;
158:
159:

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

161: FETCH c_party_resource BULK COLLECT INTO l_p_rs_id_tab, l_p_rs_cnt_tab;
162:
163: l_count := l_p_rs_id_tab.count;
164: -- IF PG_DEBUG < 10 THEN
165: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
166: iex_debug_pub.LogMessage('Run_Load_Balance: ' || 'after fetch:c_party_resource:count=' || l_count);
167: END IF;
168:
169: CLOSE c_party_resource;

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

171: OPEN c_party_case_count(r_party.party_id);
172: FETCH c_party_case_count INTO l_p_case_cnt;
173:
174: -- IF PG_DEBUG < 10 THEN
175: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
176: iex_debug_pub.LogMessage('Run_Load_Balance: ' || 'after fetch of c_party_case_count:count=' || l_p_case_cnt);
177: END IF;
178:
179: CLOSE c_party_case_count;

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

181: OPEN c_party_case_id(r_party.party_id);
182:
183: l_avg_cnt := trunc(l_p_case_cnt / l_p_rs_id_tab.count);
184: -- IF PG_DEBUG < 10 THEN
185: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
186: iex_debug_pub.LogMessage('Run_Load_Balance: ' || 'average count=' || l_avg_cnt);
187: END IF;
188:
189:

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

192: CLOSE c_party_case_id;
193:
194: l_count := l_p_case_id_tab.count;
195: -- IF PG_DEBUG < 10 THEN
196: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
197: iex_debug_pub.LogMessage('Run_Load_Balance: ' || 'after fetch c_party_case_id:count=' || l_count);
198: END IF;
199:
200: IF l_p_case_id_tab.count > 0 THEN

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

198: END IF;
199:
200: IF l_p_case_id_tab.count > 0 THEN
201: -- IF PG_DEBUG < 10 THEN
202: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
203: iex_debug_pub.LogMessage('Run_Load_Balance: ' || 'c_party_case_id found');
204: END IF;
205:
206: FOR i in 1..l_p_case_cnt LOOP

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

204: END IF;
205:
206: FOR i in 1..l_p_case_cnt LOOP
207: -- IF PG_DEBUG < 10 THEN
208: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
209: iex_debug_pub.LogMessage('Run_Load_Balance: ' || 'before update:index_of_resource=' || l_idx || ':resource=' || l_p_rs_id_tab(l_idx)
210: || ':assigned_count=' || l_p_rs_cnt_tab(l_idx)
211: || ':case_id=' || l_p_case_id_tab(i));
212: END IF;

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

217:
218: l_p_rs_cnt_tab(l_idx) := l_p_rs_cnt_tab(l_idx) + 1;
219:
220: -- IF PG_DEBUG < 10 THEN
221: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
222: iex_debug_pub.LogMessage('Run_Load_Balance: ' || 'after update:index_of_resource=' || l_idx || ':resource=' || l_p_rs_id_tab(l_idx)
223: || ':assigned_count=' || l_p_rs_cnt_tab(l_idx)
224: || ':case_id=' || l_p_case_id_tab(i));
225: END IF;

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

226:
227: IF l_p_rs_cnt_tab(l_idx) >= l_avg_cnt THEN
228: l_idx := l_idx + 1;
229: -- IF PG_DEBUG < 10 THEN
230: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
231: iex_debug_pub.LogMessage('Run_Load_Balance: ' || 'after increase index:idx=' || l_idx);
232: END IF;
233: END IF;
234:

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

235: IF l_idx > l_p_rs_cnt_tab.count THEN
236: l_idx := 1;
237: l_avg_cnt := l_avg_cnt + 1;
238: -- IF PG_DEBUG < 10 THEN
239: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
240: iex_debug_pub.LogMessage('Run_Load_Balance: ' || 'after reset index:idx=' || l_idx || ':average_count=' || l_avg_cnt);
241: END IF;
242: END IF;
243:

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

260: x_msg_data := l_msg_data ;
261:
262:
263: -- IF PG_DEBUG < 10 THEN
264: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
265: iex_debug_pub.LogMessage ('end of RUN_LOAD_BALANCE main block');
266: END IF;
267:
268: -- Standard call to get message count and if count is 1, get message info.

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

274: EXCEPTION
275: WHEN FND_API.G_EXC_ERROR THEN
276: l_errmsg := SQLERRM;
277: -- IF PG_DEBUG < 10 THEN
278: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
279: iex_debug_pub.LogMessage('Run_Load_Balance: ' || 'EXCEPTION:FND_API.G_EXC_ERROR:' || l_errmsg);
280: END IF;
281:
282: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(P_API_NAME => L_API_NAME

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

289:
290: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
291: l_errmsg := SQLERRM;
292: -- IF PG_DEBUG < 10 THEN
293: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
294: iex_debug_pub.LogMessage('Run_Load_Balance: ' || 'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR:' || l_errmsg);
295: END IF;
296:
297: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(P_API_NAME => L_API_NAME

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

303: ,X_RETURN_STATUS => X_RETURN_STATUS);
304: WHEN OTHERS THEN
305: l_errmsg := SQLERRM;
306: -- IF PG_DEBUG < 10 THEN
307: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
308: iex_debug_pub.LogMessage('Run_Load_Balance: ' || 'EXCEPTION:OTHERS:' || l_errmsg);
309: END IF;
310:
311: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(P_API_NAME => L_API_NAME