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.IEM_REROUTE_PUB dependencies on FND_MSG_PUB

Line 74: FND_MSG_PUB.initialize;

70: END IF;
71: -- Initialize message list if p_init_msg_list is set to TRUE.
72: IF p_init_msg_list='T'
73: THEN
74: FND_MSG_PUB.initialize;
75: END IF;
76: x_return_status := FND_API.G_RET_STS_SUCCESS;
77: IEM_REROUTING_HISTS_PVT.CREATE_ITEM (p_api_version_number=>1.0,
78: p_init_msg_list=>'F' ,

Line 232: FND_MSG_PUB.Count_And_Get

228: COMMIT WORK;
229: END IF;
230: COMMIT;
231: -- Standard callto get message count and if count is 1, get message info.
232: FND_MSG_PUB.Count_And_Get
233: ( p_count => x_msg_count,
234: p_data => x_msg_data
235: );
236: EXCEPTION WHEN INSERT_HIST_EXCEPTION THEN

Line 239: FND_MSG_PUB.Add;

235: );
236: EXCEPTION WHEN INSERT_HIST_EXCEPTION THEN
237: rollback to IEM_MAIL_REROUTE_PVT;
238: FND_MESSAGE.SET_NAME('IEM','IEM_INSERT_HIST_EXCEPTION');
239: FND_MSG_PUB.Add;
240: x_return_status := FND_API.G_RET_STS_ERROR ;
241: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
242:
243: WHEN INSERT_MDT_EXCEPTION THEN

Line 241: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

237: rollback to IEM_MAIL_REROUTE_PVT;
238: FND_MESSAGE.SET_NAME('IEM','IEM_INSERT_HIST_EXCEPTION');
239: FND_MSG_PUB.Add;
240: x_return_status := FND_API.G_RET_STS_ERROR ;
241: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
242:
243: WHEN INSERT_MDT_EXCEPTION THEN
244: rollback to IEM_MAIL_REROUTE_PVT;
245: FND_MESSAGE.SET_NAME('IEM','IEM_INSERT_MDT_EXCEPTION');

Line 246: FND_MSG_PUB.Add;

242:
243: WHEN INSERT_MDT_EXCEPTION THEN
244: rollback to IEM_MAIL_REROUTE_PVT;
245: FND_MESSAGE.SET_NAME('IEM','IEM_INSERT_MDT_EXCEPTION');
246: FND_MSG_PUB.Add;
247: x_return_status := FND_API.G_RET_STS_ERROR ;
248: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
249:
250: WHEN FAILED_CREATE_INTERACTION THEN

Line 248: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

244: rollback to IEM_MAIL_REROUTE_PVT;
245: FND_MESSAGE.SET_NAME('IEM','IEM_INSERT_MDT_EXCEPTION');
246: FND_MSG_PUB.Add;
247: x_return_status := FND_API.G_RET_STS_ERROR ;
248: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
249:
250: WHEN FAILED_CREATE_INTERACTION THEN
251: rollback to IEM_MAIL_REROUTE_PVT;
252: FND_MESSAGE.SET_NAME('IEM','IEM_FAILED_CREATE_INTERACTIONS');

Line 253: FND_MSG_PUB.Add;

249:
250: WHEN FAILED_CREATE_INTERACTION THEN
251: rollback to IEM_MAIL_REROUTE_PVT;
252: FND_MESSAGE.SET_NAME('IEM','IEM_FAILED_CREATE_INTERACTIONS');
253: FND_MSG_PUB.Add;
254: x_return_status := FND_API.G_RET_STS_ERROR ;
255: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
256:
257: WHEN FAILED_CREATE_ACTIVITY THEN

Line 255: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

251: rollback to IEM_MAIL_REROUTE_PVT;
252: FND_MESSAGE.SET_NAME('IEM','IEM_FAILED_CREATE_INTERACTIONS');
253: FND_MSG_PUB.Add;
254: x_return_status := FND_API.G_RET_STS_ERROR ;
255: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
256:
257: WHEN FAILED_CREATE_ACTIVITY THEN
258: rollback to IEM_MAIL_REROUTE_PVT;
259: FND_MESSAGE.SET_NAME('IEM','IEM_FAILED_CREATE_ACTIVITY');

Line 260: FND_MSG_PUB.Add;

256:
257: WHEN FAILED_CREATE_ACTIVITY THEN
258: rollback to IEM_MAIL_REROUTE_PVT;
259: FND_MESSAGE.SET_NAME('IEM','IEM_FAILED_CREATE_ACTIVITY');
260: FND_MSG_PUB.Add;
261: x_return_status := FND_API.G_RET_STS_ERROR ;
262: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
263:
264: WHEN INVALID_CLASSIFICATION THEN

Line 262: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

258: rollback to IEM_MAIL_REROUTE_PVT;
259: FND_MESSAGE.SET_NAME('IEM','IEM_FAILED_CREATE_ACTIVITY');
260: FND_MSG_PUB.Add;
261: x_return_status := FND_API.G_RET_STS_ERROR ;
262: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
263:
264: WHEN INVALID_CLASSIFICATION THEN
265: rollback to IEM_MAIL_REROUTE_PVT;
266: FND_MESSAGE.SET_NAME('IEM','IEM_INVALID_CLASSIFICATION');

Line 267: FND_MSG_PUB.Add;

263:
264: WHEN INVALID_CLASSIFICATION THEN
265: rollback to IEM_MAIL_REROUTE_PVT;
266: FND_MESSAGE.SET_NAME('IEM','IEM_INVALID_CLASSIFICATION');
267: FND_MSG_PUB.Add;
268: x_return_status := FND_API.G_RET_STS_ERROR ;
269: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
270:
271: WHEN NO_DEFAULT_RESOURCE_ID THEN

Line 269: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

265: rollback to IEM_MAIL_REROUTE_PVT;
266: FND_MESSAGE.SET_NAME('IEM','IEM_INVALID_CLASSIFICATION');
267: FND_MSG_PUB.Add;
268: x_return_status := FND_API.G_RET_STS_ERROR ;
269: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
270:
271: WHEN NO_DEFAULT_RESOURCE_ID THEN
272: rollback to IEM_MAIL_REROUTE_PVT;
273: FND_MESSAGE.SET_NAME('IEM','IEM_NO_DEFAULT_RESOURCE_ID');

Line 274: FND_MSG_PUB.Add;

270:
271: WHEN NO_DEFAULT_RESOURCE_ID THEN
272: rollback to IEM_MAIL_REROUTE_PVT;
273: FND_MESSAGE.SET_NAME('IEM','IEM_NO_DEFAULT_RESOURCE_ID');
274: FND_MSG_PUB.Add;
275: x_return_status := FND_API.G_RET_STS_ERROR ;
276: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
277:
278: WHEN ERROR_RETRIEVE_SOURCE_MESSAGE THEN

Line 276: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

272: rollback to IEM_MAIL_REROUTE_PVT;
273: FND_MESSAGE.SET_NAME('IEM','IEM_NO_DEFAULT_RESOURCE_ID');
274: FND_MSG_PUB.Add;
275: x_return_status := FND_API.G_RET_STS_ERROR ;
276: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
277:
278: WHEN ERROR_RETRIEVE_SOURCE_MESSAGE THEN
279: rollback to IEM_MAIL_REROUTE_PVT;
280: FND_MESSAGE.SET_NAME('IEM','IEM_ERROR_RETRIEVE_SOURCE_MSG');

Line 281: FND_MSG_PUB.Add;

277:
278: WHEN ERROR_RETRIEVE_SOURCE_MESSAGE THEN
279: rollback to IEM_MAIL_REROUTE_PVT;
280: FND_MESSAGE.SET_NAME('IEM','IEM_ERROR_RETRIEVE_SOURCE_MSG');
281: FND_MSG_PUB.Add;
282: x_return_status := FND_API.G_RET_STS_ERROR ;
283: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
284:
285:

Line 283: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

279: rollback to IEM_MAIL_REROUTE_PVT;
280: FND_MESSAGE.SET_NAME('IEM','IEM_ERROR_RETRIEVE_SOURCE_MSG');
281: FND_MSG_PUB.Add;
282: x_return_status := FND_API.G_RET_STS_ERROR ;
283: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
284:
285:
286: WHEN FND_API.G_EXC_ERROR THEN
287: rollback to IEM_MAIL_REROUTE_PVT;

Line 289: FND_MSG_PUB.Count_And_Get

285:
286: WHEN FND_API.G_EXC_ERROR THEN
287: rollback to IEM_MAIL_REROUTE_PVT;
288: x_return_status := FND_API.G_RET_STS_ERROR ;
289: FND_MSG_PUB.Count_And_Get
290: ( p_count => x_msg_count,
291: p_data => x_msg_data
292: );
293:

Line 297: FND_MSG_PUB.Count_And_Get

293:
294: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
295: rollback to IEM_MAIL_REROUTE_PVT;
296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
297: FND_MSG_PUB.Count_And_Get
298: ( p_count => x_msg_count,
299: p_data => x_msg_data
300: );
301: WHEN OTHERS then

Line 304: IF FND_MSG_PUB.Check_Msg_Level

300: );
301: WHEN OTHERS then
302: rollback to IEM_MAIL_REROUTE_PVT;
303: x_return_status := FND_API.G_RET_STS_ERROR;
304: IF FND_MSG_PUB.Check_Msg_Level
305: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
306: THEN
307: FND_MSG_PUB.Add_Exc_Msg
308: ( G_PKG_NAME ,

Line 305: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

301: WHEN OTHERS then
302: rollback to IEM_MAIL_REROUTE_PVT;
303: x_return_status := FND_API.G_RET_STS_ERROR;
304: IF FND_MSG_PUB.Check_Msg_Level
305: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
306: THEN
307: FND_MSG_PUB.Add_Exc_Msg
308: ( G_PKG_NAME ,
309: l_api_name

Line 307: FND_MSG_PUB.Add_Exc_Msg

303: x_return_status := FND_API.G_RET_STS_ERROR;
304: IF FND_MSG_PUB.Check_Msg_Level
305: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
306: THEN
307: FND_MSG_PUB.Add_Exc_Msg
308: ( G_PKG_NAME ,
309: l_api_name
310: );
311: END IF;

Line 312: FND_MSG_PUB.Count_And_Get

308: ( G_PKG_NAME ,
309: l_api_name
310: );
311: END IF;
312: FND_MSG_PUB.Count_And_Get
313: ( p_count => x_msg_count ,
314: p_data => x_msg_data
315: );
316: END IEM_MAIL_REROUTE_CLASS;

Line 359: FND_MSG_PUB.initialize;

355: END IF;
356: -- Initialize message list if p_init_msg_list is set to TRUE.
357: IF p_init_msg_list ='T'
358: THEN
359: FND_MSG_PUB.initialize;
360: END IF;
361: x_return_status := FND_API.G_RET_STS_SUCCESS;
362:
363: IEM_REROUTING_HISTS_PVT.CREATE_ITEM (p_api_version_number=>1.0,

Line 426: FND_MSG_PUB.Count_And_Get

422: COMMIT WORK;
423: END IF;
424: COMMIT;
425: -- Standard callto get message count and if count is 1, get message info.
426: FND_MSG_PUB.Count_And_Get
427: ( p_count => x_msg_count,
428: p_data => x_msg_data
429: );
430: EXCEPTION WHEN INSERT_HIST_EXCEPTION THEN

Line 433: FND_MSG_PUB.Add;

429: );
430: EXCEPTION WHEN INSERT_HIST_EXCEPTION THEN
431: rollback to IEM_MAIL_REROUTE_PVT;
432: FND_MESSAGE.SET_NAME('IEM','IEM_REROUTE_INSERT_FAILS');
433: FND_MSG_PUB.Add;
434: x_return_status := FND_API.G_RET_STS_ERROR ;
435: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
436:
437: WHEN NO_DATA_FOUND THEN

Line 435: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

431: rollback to IEM_MAIL_REROUTE_PVT;
432: FND_MESSAGE.SET_NAME('IEM','IEM_REROUTE_INSERT_FAILS');
433: FND_MSG_PUB.Add;
434: x_return_status := FND_API.G_RET_STS_ERROR ;
435: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
436:
437: WHEN NO_DATA_FOUND THEN
438: rollback to IEM_MAIL_REROUTE_PVT;
439: FND_MESSAGE.SET_NAME('IEM','IEM_INVALID_REROUTE_RECORD');

Line 440: FND_MSG_PUB.Add;

436:
437: WHEN NO_DATA_FOUND THEN
438: rollback to IEM_MAIL_REROUTE_PVT;
439: FND_MESSAGE.SET_NAME('IEM','IEM_INVALID_REROUTE_RECORD');
440: FND_MSG_PUB.Add;
441: x_return_status := FND_API.G_RET_STS_ERROR ;
442: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
443: WHEN REROUTING_FAILS THEN
444: rollback to IEM_MAIL_REROUTE_PVT;

Line 442: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

438: rollback to IEM_MAIL_REROUTE_PVT;
439: FND_MESSAGE.SET_NAME('IEM','IEM_INVALID_REROUTE_RECORD');
440: FND_MSG_PUB.Add;
441: x_return_status := FND_API.G_RET_STS_ERROR ;
442: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
443: WHEN REROUTING_FAILS THEN
444: rollback to IEM_MAIL_REROUTE_PVT;
445: FND_MESSAGE.SET_NAME('IEM','IEM_REROUTING_FAILS');
446: FND_MSG_PUB.Add;

Line 446: FND_MSG_PUB.Add;

442: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
443: WHEN REROUTING_FAILS THEN
444: rollback to IEM_MAIL_REROUTE_PVT;
445: FND_MESSAGE.SET_NAME('IEM','IEM_REROUTING_FAILS');
446: FND_MSG_PUB.Add;
447: x_return_status := FND_API.G_RET_STS_ERROR ;
448: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
449:
450: WHEN FND_API.G_EXC_ERROR THEN

Line 448: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

444: rollback to IEM_MAIL_REROUTE_PVT;
445: FND_MESSAGE.SET_NAME('IEM','IEM_REROUTING_FAILS');
446: FND_MSG_PUB.Add;
447: x_return_status := FND_API.G_RET_STS_ERROR ;
448: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
449:
450: WHEN FND_API.G_EXC_ERROR THEN
451: rollback to IEM_MAIL_REROUTE_PVT;
452: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 453: FND_MSG_PUB.Count_And_Get

449:
450: WHEN FND_API.G_EXC_ERROR THEN
451: rollback to IEM_MAIL_REROUTE_PVT;
452: x_return_status := FND_API.G_RET_STS_ERROR ;
453: FND_MSG_PUB.Count_And_Get
454: ( p_count => x_msg_count,
455: p_data => x_msg_data
456: );
457:

Line 461: FND_MSG_PUB.Count_And_Get

457:
458: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
459: rollback to IEM_MAIL_REROUTE_PVT;
460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
461: FND_MSG_PUB.Count_And_Get
462: ( p_count => x_msg_count,
463: p_data => x_msg_data
464: );
465: WHEN OTHERS then

Line 468: IF FND_MSG_PUB.Check_Msg_Level

464: );
465: WHEN OTHERS then
466: rollback to IEM_MAIL_REROUTE_PVT;
467: x_return_status := FND_API.G_RET_STS_ERROR;
468: IF FND_MSG_PUB.Check_Msg_Level
469: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
470: THEN
471: FND_MSG_PUB.Add_Exc_Msg
472: ( G_PKG_NAME ,

Line 469: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

465: WHEN OTHERS then
466: rollback to IEM_MAIL_REROUTE_PVT;
467: x_return_status := FND_API.G_RET_STS_ERROR;
468: IF FND_MSG_PUB.Check_Msg_Level
469: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
470: THEN
471: FND_MSG_PUB.Add_Exc_Msg
472: ( G_PKG_NAME ,
473: l_api_name

Line 471: FND_MSG_PUB.Add_Exc_Msg

467: x_return_status := FND_API.G_RET_STS_ERROR;
468: IF FND_MSG_PUB.Check_Msg_Level
469: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
470: THEN
471: FND_MSG_PUB.Add_Exc_Msg
472: ( G_PKG_NAME ,
473: l_api_name
474: );
475: END IF;

Line 476: FND_MSG_PUB.Count_And_Get

472: ( G_PKG_NAME ,
473: l_api_name
474: );
475: END IF;
476: FND_MSG_PUB.Count_And_Get
477: ( p_count => x_msg_count ,
478: p_data => x_msg_data
479: );
480: END IEM_MAIL_REROUTE_ACCOUNT;

Line 509: FND_MSG_PUB.initialize;

505: END IF;
506: -- Initialize message list if p_init_msg_list is set to TRUE.
507: IF p_init_msg_list ='T'
508: THEN
509: FND_MSG_PUB.initialize;
510: END IF;
511: x_return_status := FND_API.G_RET_STS_SUCCESS;
512: IF p_msg_ids_tbl.count>0 THEN
513: FOR i IN p_msg_ids_tbl.first..p_msg_ids_tbl.last LOOP

Line 531: FND_MSG_PUB.Count_And_Get

527: END IF;
528: EXCEPTION WHEN FND_API.G_EXC_ERROR THEN
529: rollback to IEM_UPD_GRP_QUEMSG_PVT;
530: x_return_status := FND_API.G_RET_STS_ERROR ;
531: FND_MSG_PUB.Count_And_Get
532: ( p_count => x_msg_count,
533: p_data => x_msg_data
534: );
535:

Line 539: FND_MSG_PUB.Count_And_Get

535:
536: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
537: rollback to IEM_UPD_GRP_QUEMSG_PVT;
538: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
539: FND_MSG_PUB.Count_And_Get
540: ( p_count => x_msg_count,
541: p_data => x_msg_data
542: );
543: WHEN OTHERS then

Line 546: IF FND_MSG_PUB.Check_Msg_Level

542: );
543: WHEN OTHERS then
544: rollback to IEM_UPD_GRP_QUEMSG_PVT;
545: x_return_status := FND_API.G_RET_STS_ERROR;
546: IF FND_MSG_PUB.Check_Msg_Level
547: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
548: THEN
549: FND_MSG_PUB.Add_Exc_Msg
550: ( G_PKG_NAME ,

Line 547: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

543: WHEN OTHERS then
544: rollback to IEM_UPD_GRP_QUEMSG_PVT;
545: x_return_status := FND_API.G_RET_STS_ERROR;
546: IF FND_MSG_PUB.Check_Msg_Level
547: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
548: THEN
549: FND_MSG_PUB.Add_Exc_Msg
550: ( G_PKG_NAME ,
551: l_api_name

Line 549: FND_MSG_PUB.Add_Exc_Msg

545: x_return_status := FND_API.G_RET_STS_ERROR;
546: IF FND_MSG_PUB.Check_Msg_Level
547: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
548: THEN
549: FND_MSG_PUB.Add_Exc_Msg
550: ( G_PKG_NAME ,
551: l_api_name
552: );
553: END IF;

Line 554: FND_MSG_PUB.Count_And_Get

550: ( G_PKG_NAME ,
551: l_api_name
552: );
553: END IF;
554: FND_MSG_PUB.Count_And_Get
555: ( p_count => x_msg_count ,
556: p_data => x_msg_data
557: );
558: END IEM_UPD_GRP_QUEMSG;