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 IEX_DEBUG_PUB

Line 28: iex_debug_pub.LogMessage ('Starting IEX_CASE_OWNER_CONCUR');

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

Line 35: iex_debug_pub.LogMessage ('IEX_CASE_OWNER_CONCUR: ' || 'p_list_name is null and calling RUN_LOAD_BALANCE');

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,
39: p_commit => FND_API.G_TRUE,

Line 46: iex_debug_pub.LogMessage ('IEX_CASE_OWNER_CONCUR: ' || 'after RUN_LOAD_BALANCE: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;
50:

Line 131: iex_debug_pub.LogMessage ('starting RUN_LOAD_BALANCE');

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
135: SAVEPOINT Run_Load_Balance_PVT;

Line 156: iex_debug_pub.LogMessage('Run_Load_Balance: ' || 'in C_PARTIES LOOP:party_id=' || r_party.party_id);

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:
160: OPEN c_party_resource(r_party.party_id);

Line 166: iex_debug_pub.LogMessage('Run_Load_Balance: ' || 'after fetch:c_party_resource:count=' || l_count);

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;
170: IF l_p_rs_id_tab.count > 0 THEN

Line 176: iex_debug_pub.LogMessage('Run_Load_Balance: ' || 'after fetch of c_party_case_count:count=' || l_p_case_cnt);

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

Line 186: iex_debug_pub.LogMessage('Run_Load_Balance: ' || 'average count=' || l_avg_cnt);

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:
190: l_idx := 1;

Line 197: iex_debug_pub.LogMessage('Run_Load_Balance: ' || 'after fetch c_party_case_id:count=' || l_count);

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
201: -- IF PG_DEBUG < 10 THEN

Line 203: iex_debug_pub.LogMessage('Run_Load_Balance: ' || 'c_party_case_id found');

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
207: -- IF PG_DEBUG < 10 THEN

Line 209: iex_debug_pub.LogMessage('Run_Load_Balance: ' || 'before update:index_of_resource=' || l_idx || ':resource=' || l_p_rs_id_tab(l_idx)

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

Line 222: iex_debug_pub.LogMessage('Run_Load_Balance: ' || 'after update:index_of_resource=' || l_idx || ':resource=' || l_p_rs_id_tab(l_idx)

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

Line 231: iex_debug_pub.LogMessage('Run_Load_Balance: ' || 'after increase index:idx=' || l_idx);

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:
235: IF l_idx > l_p_rs_cnt_tab.count THEN

Line 240: iex_debug_pub.LogMessage('Run_Load_Balance: ' || 'after reset index:idx=' || l_idx || ':average_count=' || l_avg_cnt);

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:
244: END LOOP; -- FOR i

Line 265: iex_debug_pub.LogMessage ('end of RUN_LOAD_BALANCE main block');

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.
269: FND_MSG_PUB.Count_And_Get

Line 279: iex_debug_pub.LogMessage('Run_Load_Balance: ' || 'EXCEPTION:FND_API.G_EXC_ERROR:' || l_errmsg);

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
283: ,P_PKG_NAME => G_PKG_NAME

Line 294: iex_debug_pub.LogMessage('Run_Load_Balance: ' || 'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR:' || l_errmsg);

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
298: ,P_PKG_NAME => G_PKG_NAME

Line 308: iex_debug_pub.LogMessage('Run_Load_Balance: ' || 'EXCEPTION:OTHERS:' || l_errmsg);

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
312: ,P_PKG_NAME => G_PKG_NAME