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_EMAILPROC_HDL_PVT dependencies on FND_MSG_PUB

Line 78: FND_MSG_PUB.initialize;

74:
75: -- Initialize message list if p_init_msg_list is set to TRUE.
76:
77: IF FND_API.to_Boolean( p_init_msg_list ) THEN
78: FND_MSG_PUB.initialize;
79: END IF;
80:
81: -- Initialize API return status to SUCCESS
82:

Line 157: FND_MSG_PUB.Count_And_Get

153: COMMIT WORK;
154: END IF;
155:
156: -- Standard callto get message count and if count is 1, get message info.
157: FND_MSG_PUB.Count_And_Get
158: ( p_count => x_msg_count,
159: p_data => x_msg_data
160: );
161:

Line 168: FND_MSG_PUB.Count_And_Get

164:
165: ROLLBACK TO create_item_acct_routes_PVT;
166:
167: x_return_status := FND_API.G_RET_STS_ERROR ;
168: FND_MSG_PUB.Count_And_Get
169: ( p_count => x_msg_count,
170: p_data => x_msg_data
171: );
172:

Line 176: FND_MSG_PUB.Count_And_Get

172:
173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
174: ROLLBACK TO create_item_acct_routes_PVT;
175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
176: FND_MSG_PUB.Count_And_Get
177: ( p_count => x_msg_count,
178:
179: p_data => x_msg_data
180: );

Line 186: IF FND_MSG_PUB.Check_Msg_Level

182:
183: WHEN OTHERS THEN
184: ROLLBACK TO create_item_acct_routes_PVT;
185: x_return_status := FND_API.G_RET_STS_ERROR;
186: IF FND_MSG_PUB.Check_Msg_Level
187: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
188: THEN
189: FND_MSG_PUB.Add_Exc_Msg
190: ( G_PKG_NAME ,

Line 187: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

183: WHEN OTHERS THEN
184: ROLLBACK TO create_item_acct_routes_PVT;
185: x_return_status := FND_API.G_RET_STS_ERROR;
186: IF FND_MSG_PUB.Check_Msg_Level
187: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
188: THEN
189: FND_MSG_PUB.Add_Exc_Msg
190: ( G_PKG_NAME ,
191: l_api_name

Line 189: FND_MSG_PUB.Add_Exc_Msg

185: x_return_status := FND_API.G_RET_STS_ERROR;
186: IF FND_MSG_PUB.Check_Msg_Level
187: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
188: THEN
189: FND_MSG_PUB.Add_Exc_Msg
190: ( G_PKG_NAME ,
191: l_api_name
192:
193: );

Line 195: FND_MSG_PUB.Count_And_Get

191: l_api_name
192:
193: );
194: END IF;
195: FND_MSG_PUB.Count_And_Get
196:
197: ( p_count => x_msg_count ,
198: p_data => x_msg_data
199: );

Line 248: FND_MSG_PUB.initialize;

244:
245: -- Initialize message list if p_init_msg_list is set to TRUE.
246: IF FND_API.to_Boolean( p_init_msg_list )
247: THEN
248: FND_MSG_PUB.initialize;
249: END IF;
250:
251: -- Initialize API return status to SUCCESS
252: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 322: FND_MSG_PUB.Count_And_Get

318: COMMIT WORK;
319: END IF;
320:
321: -- Standard callto get message count and if count is 1, get message info.
322: FND_MSG_PUB.Count_And_Get
323: ( p_count => x_msg_count,
324: p_data => x_msg_data
325: );
326:

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

328: EXCEPTION
329: WHEN l_IEM_INVALID_PROCEDURE THEN
330: ROLLBACK TO update_item_route;
331: x_return_status := FND_API.G_RET_STS_ERROR ;
332: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
333:
334: WHEN IEM_ADM_G_MISS_FOR_NOTNULL THEN
335: ROLLBACK TO update_item_route;
336: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_G_MISS_FOR_NOTNULL');

Line 337: FND_MSG_PUB.Add;

333:
334: WHEN IEM_ADM_G_MISS_FOR_NOTNULL THEN
335: ROLLBACK TO update_item_route;
336: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_G_MISS_FOR_NOTNULL');
337: FND_MSG_PUB.Add;
338: x_return_status := FND_API.G_RET_STS_ERROR ;
339: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
340:
341: WHEN IEM_ADM_DUP_NAME THEN

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

335: ROLLBACK TO update_item_route;
336: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_G_MISS_FOR_NOTNULL');
337: FND_MSG_PUB.Add;
338: x_return_status := FND_API.G_RET_STS_ERROR ;
339: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
340:
341: WHEN IEM_ADM_DUP_NAME THEN
342: ROLLBACK TO update_item_route;
343: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_DUP_NAME');

Line 344: FND_MSG_PUB.Add;

340:
341: WHEN IEM_ADM_DUP_NAME THEN
342: ROLLBACK TO update_item_route;
343: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_DUP_NAME');
344: FND_MSG_PUB.Add;
345: x_return_status := FND_API.G_RET_STS_ERROR ;
346: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
347:
348: WHEN IEM_ADMIN_ROUTE_NO_PROC THEN

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

342: ROLLBACK TO update_item_route;
343: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_DUP_NAME');
344: FND_MSG_PUB.Add;
345: x_return_status := FND_API.G_RET_STS_ERROR ;
346: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
347:
348: WHEN IEM_ADMIN_ROUTE_NO_PROC THEN
349: ROLLBACK TO update_item_route;
350: FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_ROUTE_NO_PROC');

Line 351: FND_MSG_PUB.Add;

347:
348: WHEN IEM_ADMIN_ROUTE_NO_PROC THEN
349: ROLLBACK TO update_item_route;
350: FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_ROUTE_NO_PROC');
351: FND_MSG_PUB.Add;
352: x_return_status := FND_API.G_RET_STS_ERROR ;
353: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
354:
355: WHEN FND_API.G_EXC_ERROR THEN

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

349: ROLLBACK TO update_item_route;
350: FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_ROUTE_NO_PROC');
351: FND_MSG_PUB.Add;
352: x_return_status := FND_API.G_RET_STS_ERROR ;
353: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
354:
355: WHEN FND_API.G_EXC_ERROR THEN
356: ROLLBACK TO update_item_route;
357: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 358: FND_MSG_PUB.Count_And_Get

354:
355: WHEN FND_API.G_EXC_ERROR THEN
356: ROLLBACK TO update_item_route;
357: x_return_status := FND_API.G_RET_STS_ERROR ;
358: FND_MSG_PUB.Count_And_Get
359:
360:
361: ( p_count => x_msg_count,
362: p_data => x_msg_data

Line 368: FND_MSG_PUB.Count_And_Get

364:
365: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
366: ROLLBACK TO update_item_route;
367: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
368: FND_MSG_PUB.Count_And_Get
369: ( p_count => x_msg_count,
370: p_data => x_msg_data
371: );
372:

Line 378: IF FND_MSG_PUB.Check_Msg_Level

374: WHEN OTHERS THEN
375:
376: ROLLBACK TO update_item_route;
377: x_return_status := FND_API.G_RET_STS_ERROR;
378: IF FND_MSG_PUB.Check_Msg_Level
379: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
380: THEN
381: FND_MSG_PUB.Add_Exc_Msg
382: ( G_PKG_NAME ,

Line 379: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

375:
376: ROLLBACK TO update_item_route;
377: x_return_status := FND_API.G_RET_STS_ERROR;
378: IF FND_MSG_PUB.Check_Msg_Level
379: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
380: THEN
381: FND_MSG_PUB.Add_Exc_Msg
382: ( G_PKG_NAME ,
383: l_api_name

Line 381: FND_MSG_PUB.Add_Exc_Msg

377: x_return_status := FND_API.G_RET_STS_ERROR;
378: IF FND_MSG_PUB.Check_Msg_Level
379: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
380: THEN
381: FND_MSG_PUB.Add_Exc_Msg
382: ( G_PKG_NAME ,
383: l_api_name
384: );
385: END IF;

Line 386: FND_MSG_PUB.Count_And_Get

382: ( G_PKG_NAME ,
383: l_api_name
384: );
385: END IF;
386: FND_MSG_PUB.Count_And_Get
387:
388: ( p_count => x_msg_count ,
389: p_data => x_msg_data
390:

Line 433: FND_MSG_PUB.initialize;

429: -- Initialize message list if p_init_msg_list is set to TRUE.
430: IF FND_API.to_Boolean( p_init_msg_list )
431: THEN
432:
433: FND_MSG_PUB.initialize;
434: END IF;
435: -- Initialize API return status to SUCCESS
436: x_return_status := FND_API.G_RET_STS_SUCCESS;
437:

Line 486: FND_MSG_PUB.Count_And_Get

482: COMMIT WORK;
483: END IF;
484:
485: -- Standard callto get message count and if count is 1, get message info.
486: FND_MSG_PUB.Count_And_Get
487: ( p_count => x_msg_count,
488: p_data => x_msg_data
489: );
490: EXCEPTION

Line 495: FND_MSG_PUB.Add;

491: WHEN IEM_NO_RULE_UPDATE THEN
492: ROLLBACK TO update_item_rule;
493: FND_MESSAGE.SET_NAME('IEM','IEM_NO_RULE_UPDATE');
494:
495: FND_MSG_PUB.Add;
496: x_return_status := FND_API.G_RET_STS_ERROR ;
497: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
498:
499: WHEN IEM_ADM_G_MISS_FOR_NOTNULL THEN

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

493: FND_MESSAGE.SET_NAME('IEM','IEM_NO_RULE_UPDATE');
494:
495: FND_MSG_PUB.Add;
496: x_return_status := FND_API.G_RET_STS_ERROR ;
497: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
498:
499: WHEN IEM_ADM_G_MISS_FOR_NOTNULL THEN
500: ROLLBACK TO update_item_rule;
501: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_G_MISS_FOR_NOTNULL');

Line 503: FND_MSG_PUB.Add;

499: WHEN IEM_ADM_G_MISS_FOR_NOTNULL THEN
500: ROLLBACK TO update_item_rule;
501: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_G_MISS_FOR_NOTNULL');
502:
503: FND_MSG_PUB.Add;
504: x_return_status := FND_API.G_RET_STS_ERROR ;
505: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
506: /*
507: WHEN IEM_INVALID_DATE_FORMAT THEN

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

501: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_G_MISS_FOR_NOTNULL');
502:
503: FND_MSG_PUB.Add;
504: x_return_status := FND_API.G_RET_STS_ERROR ;
505: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
506: /*
507: WHEN IEM_INVALID_DATE_FORMAT THEN
508: ROLLBACK TO update_item_rule;
509: FND_MESSAGE.SET_NAME('IEM','IEM_INVALID_DATE_FORMAT');

Line 510: FND_MSG_PUB.Add;

506: /*
507: WHEN IEM_INVALID_DATE_FORMAT THEN
508: ROLLBACK TO update_item_rule;
509: FND_MESSAGE.SET_NAME('IEM','IEM_INVALID_DATE_FORMAT');
510: FND_MSG_PUB.Add;
511: x_return_status := FND_API.G_RET_STS_ERROR ;
512: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
513: */
514: WHEN FND_API.G_EXC_ERROR THEN

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

508: ROLLBACK TO update_item_rule;
509: FND_MESSAGE.SET_NAME('IEM','IEM_INVALID_DATE_FORMAT');
510: FND_MSG_PUB.Add;
511: x_return_status := FND_API.G_RET_STS_ERROR ;
512: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
513: */
514: WHEN FND_API.G_EXC_ERROR THEN
515: ROLLBACK TO update_item_rule;
516:

Line 518: FND_MSG_PUB.Count_And_Get

514: WHEN FND_API.G_EXC_ERROR THEN
515: ROLLBACK TO update_item_rule;
516:
517: x_return_status := FND_API.G_RET_STS_ERROR ;
518: FND_MSG_PUB.Count_And_Get
519:
520: ( p_count => x_msg_count,
521: p_data => x_msg_data
522: );

Line 526: FND_MSG_PUB.Count_And_Get

522: );
523: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
524: ROLLBACK TO update_item_rule;
525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
526: FND_MSG_PUB.Count_And_Get
527: ( p_count => x_msg_count,
528: p_data => x_msg_data
529: );
530: WHEN OTHERS THEN

Line 535: IF FND_MSG_PUB.Check_Msg_Level

531:
532: ROLLBACK TO update_item_rule;
533:
534: x_return_status := FND_API.G_RET_STS_ERROR;
535: IF FND_MSG_PUB.Check_Msg_Level
536: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
537: THEN
538: FND_MSG_PUB.Add_Exc_Msg
539: ( G_PKG_NAME ,

Line 536: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

532: ROLLBACK TO update_item_rule;
533:
534: x_return_status := FND_API.G_RET_STS_ERROR;
535: IF FND_MSG_PUB.Check_Msg_Level
536: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
537: THEN
538: FND_MSG_PUB.Add_Exc_Msg
539: ( G_PKG_NAME ,
540: l_api_name

Line 538: FND_MSG_PUB.Add_Exc_Msg

534: x_return_status := FND_API.G_RET_STS_ERROR;
535: IF FND_MSG_PUB.Check_Msg_Level
536: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
537: THEN
538: FND_MSG_PUB.Add_Exc_Msg
539: ( G_PKG_NAME ,
540: l_api_name
541: );
542: END IF;

Line 543: FND_MSG_PUB.Count_And_Get

539: ( G_PKG_NAME ,
540: l_api_name
541: );
542: END IF;
543: FND_MSG_PUB.Count_And_Get
544: ( p_count => x_msg_count ,
545: p_data => x_msg_data
546:
547:

Line 592: FND_MSG_PUB.initialize;

588:
589: IF FND_API.to_Boolean( p_init_msg_list )
590:
591: THEN
592: FND_MSG_PUB.initialize;
593: END IF;
594: -- Initialize API return status to SUCCESS
595: x_return_status := FND_API.G_RET_STS_SUCCESS;
596:

Line 654: FND_MSG_PUB.Count_And_Get

650: COMMIT WORK;
651:
652: END IF;
653: -- Standard callto get message count and if count is 1, get message info.
654: FND_MSG_PUB.Count_And_Get
655: ( p_count => x_msg_count,
656: p_data => x_msg_data
657:
658: );

Line 664: FND_MSG_PUB.Count_And_Get

660:
661: WHEN FND_API.G_EXC_ERROR THEN
662: ROLLBACK TO update_account_emailprocs_PVT;
663: x_return_status := FND_API.G_RET_STS_ERROR ;
664: FND_MSG_PUB.Count_And_Get
665:
666: ( p_count => x_msg_count,
667: p_data => x_msg_data
668: );

Line 673: FND_MSG_PUB.Count_And_Get

669: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
670: ROLLBACK TO update_account_emailprocs_PVT;
671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
672:
673: FND_MSG_PUB.Count_And_Get
674: ( p_count => x_msg_count,
675: p_data => x_msg_data
676: );
677: WHEN OTHERS THEN

Line 681: IF FND_MSG_PUB.Check_Msg_Level

677: WHEN OTHERS THEN
678: ROLLBACK TO update_account_emailprocs_PVT;
679:
680: x_return_status := FND_API.G_RET_STS_ERROR;
681: IF FND_MSG_PUB.Check_Msg_Level
682: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
683: THEN
684: FND_MSG_PUB.Add_Exc_Msg
685: ( G_PKG_NAME ,

Line 682: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

678: ROLLBACK TO update_account_emailprocs_PVT;
679:
680: x_return_status := FND_API.G_RET_STS_ERROR;
681: IF FND_MSG_PUB.Check_Msg_Level
682: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
683: THEN
684: FND_MSG_PUB.Add_Exc_Msg
685: ( G_PKG_NAME ,
686: l_api_name

Line 684: FND_MSG_PUB.Add_Exc_Msg

680: x_return_status := FND_API.G_RET_STS_ERROR;
681: IF FND_MSG_PUB.Check_Msg_Level
682: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
683: THEN
684: FND_MSG_PUB.Add_Exc_Msg
685: ( G_PKG_NAME ,
686: l_api_name
687:
688: );

Line 690: FND_MSG_PUB.Count_And_Get

686: l_api_name
687:
688: );
689: END IF;
690: FND_MSG_PUB.Count_And_Get
691: ( p_count => x_msg_count,
692: p_data => x_msg_data
693:
694: );

Line 751: FND_MSG_PUB.initialize;

747:
748: -- Initialize message list if p_init_msg_list is set to TRUE.
749: IF FND_API.to_Boolean( p_init_msg_list )
750: THEN
751: FND_MSG_PUB.initialize;
752: END IF;
753:
754:
755: -- Initialize API return status to SUCCESS

Line 874: FND_MSG_PUB.Count_And_Get

870: COMMIT WORK;
871: END IF;
872:
873: -- Standard callto get message count and if count is 1, get message info.
874: FND_MSG_PUB.Count_And_Get
875: ( p_count => x_msg_count,
876: p_data => x_msg_data
877: );
878:

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

881: EXCEPTION
882: WHEN l_IEM_INVALID_PROCEDURE THEN
883: ROLLBACK TO create_item_routes_PVT;
884: x_return_status := FND_API.G_RET_STS_ERROR ;
885: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
886:
887: WHEN IEM_ADM_DUP_NAME THEN
888: ROLLBACK TO create_item_routes_PVT;
889: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_DUP_NAME');

Line 890: FND_MSG_PUB.Add;

886:
887: WHEN IEM_ADM_DUP_NAME THEN
888: ROLLBACK TO create_item_routes_PVT;
889: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_DUP_NAME');
890: FND_MSG_PUB.Add;
891: x_return_status := FND_API.G_RET_STS_ERROR ;
892: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
893:
894: WHEN FND_API.G_EXC_ERROR THEN

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

888: ROLLBACK TO create_item_routes_PVT;
889: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_DUP_NAME');
890: FND_MSG_PUB.Add;
891: x_return_status := FND_API.G_RET_STS_ERROR ;
892: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
893:
894: WHEN FND_API.G_EXC_ERROR THEN
895: ROLLBACK TO create_item_routes_PVT;
896: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 898: FND_MSG_PUB.Count_And_Get

894: WHEN FND_API.G_EXC_ERROR THEN
895: ROLLBACK TO create_item_routes_PVT;
896: x_return_status := FND_API.G_RET_STS_ERROR ;
897:
898: FND_MSG_PUB.Count_And_Get
899:
900: ( p_count => x_msg_count,
901: p_data => x_msg_data
902: );

Line 907: FND_MSG_PUB.Count_And_Get

903:
904: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
905: ROLLBACK TO create_item_routes_PVT;
906: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
907: FND_MSG_PUB.Count_And_Get
908: ( p_count => x_msg_count,
909: p_data => x_msg_data
910: );
911:

Line 917: IF FND_MSG_PUB.Check_Msg_Level

913: WHEN OTHERS THEN
914:
915: ROLLBACK TO create_item_routes_PVT;
916: x_return_status := FND_API.G_RET_STS_ERROR;
917: IF FND_MSG_PUB.Check_Msg_Level
918: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
919: THEN
920: FND_MSG_PUB.Add_Exc_Msg
921: ( G_PKG_NAME ,

Line 918: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

914:
915: ROLLBACK TO create_item_routes_PVT;
916: x_return_status := FND_API.G_RET_STS_ERROR;
917: IF FND_MSG_PUB.Check_Msg_Level
918: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
919: THEN
920: FND_MSG_PUB.Add_Exc_Msg
921: ( G_PKG_NAME ,
922: l_api_name

Line 920: FND_MSG_PUB.Add_Exc_Msg

916: x_return_status := FND_API.G_RET_STS_ERROR;
917: IF FND_MSG_PUB.Check_Msg_Level
918: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
919: THEN
920: FND_MSG_PUB.Add_Exc_Msg
921: ( G_PKG_NAME ,
922: l_api_name
923: );
924: END IF;

Line 926: FND_MSG_PUB.Count_And_Get

922: l_api_name
923: );
924: END IF;
925:
926: FND_MSG_PUB.Count_And_Get
927: ( p_count => x_msg_count,
928: p_data => x_msg_data
929:
930: );

Line 972: FND_MSG_PUB.initialize;

968: -- Initialize message list if p_init_msg_list is set to TRUE.
969: IF FND_API.to_Boolean( p_init_msg_list )
970: THEN
971:
972: FND_MSG_PUB.initialize;
973: END IF;
974:
975: -- Initialize API return status to SUCCESS
976: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1068: FND_MSG_PUB.Count_And_Get

1064:
1065: END IF;
1066:
1067: -- Standard callto get message count and if count is 1, get message info.
1068: FND_MSG_PUB.Count_And_Get
1069: ( p_count => x_msg_count,
1070: p_data => x_msg_data
1071: );
1072:

Line 1077: FND_MSG_PUB.Count_And_Get

1073: EXCEPTION
1074: WHEN FND_API.G_EXC_ERROR THEN
1075: ROLLBACK TO create_emailproc_rules_PVT;
1076: x_return_status := FND_API.G_RET_STS_ERROR ;
1077: FND_MSG_PUB.Count_And_Get
1078: ( p_count => x_msg_count,
1079: p_data => x_msg_data
1080: );
1081:

Line 1085: FND_MSG_PUB.Count_And_Get

1081:
1082: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1083: ROLLBACK TO create_emailproc_rules_PVT;
1084: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1085: FND_MSG_PUB.Count_And_Get
1086: ( p_count => x_msg_count,
1087: p_data => x_msg_data
1088: );
1089:

Line 1093: IF FND_MSG_PUB.Check_Msg_Level

1089:
1090: WHEN OTHERS THEN
1091: ROLLBACK TO create_emailproc_rules_PVT;
1092: x_return_status := FND_API.G_RET_STS_ERROR;
1093: IF FND_MSG_PUB.Check_Msg_Level
1094: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1095: THEN
1096: FND_MSG_PUB.Add_Exc_Msg
1097: ( G_PKG_NAME ,

Line 1094: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1090: WHEN OTHERS THEN
1091: ROLLBACK TO create_emailproc_rules_PVT;
1092: x_return_status := FND_API.G_RET_STS_ERROR;
1093: IF FND_MSG_PUB.Check_Msg_Level
1094: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1095: THEN
1096: FND_MSG_PUB.Add_Exc_Msg
1097: ( G_PKG_NAME ,
1098: l_api_name

Line 1096: FND_MSG_PUB.Add_Exc_Msg

1092: x_return_status := FND_API.G_RET_STS_ERROR;
1093: IF FND_MSG_PUB.Check_Msg_Level
1094: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1095: THEN
1096: FND_MSG_PUB.Add_Exc_Msg
1097: ( G_PKG_NAME ,
1098: l_api_name
1099: );
1100: END IF;

Line 1101: FND_MSG_PUB.Count_And_Get

1097: ( G_PKG_NAME ,
1098: l_api_name
1099: );
1100: END IF;
1101: FND_MSG_PUB.Count_And_Get
1102: ( p_count => x_msg_count ,
1103: p_data => x_msg_data
1104: );
1105: END create_item_emailproc_rules;

Line 1140: FND_MSG_PUB.initialize;

1136:
1137: -- Initialize message list if p_init_msg_list is set to TRUE.
1138:
1139: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1140: FND_MSG_PUB.initialize;
1141: END IF;
1142:
1143: -- Initialize API return status to SUCCESS
1144:

Line 1215: FND_MSG_PUB.Count_And_Get

1211: COMMIT WORK;
1212: END IF;
1213:
1214: -- Standard callto get message count and if count is 1, get message info.
1215: FND_MSG_PUB.Count_And_Get
1216: ( p_count => x_msg_count,
1217: p_data => x_msg_data
1218: );
1219:

Line 1226: FND_MSG_PUB.Count_And_Get

1222:
1223: ROLLBACK TO create_item_actions_PVT;
1224:
1225: x_return_status := FND_API.G_RET_STS_ERROR ;
1226: FND_MSG_PUB.Count_And_Get
1227: ( p_count => x_msg_count,
1228: p_data => x_msg_data
1229: );
1230:

Line 1234: FND_MSG_PUB.Count_And_Get

1230:
1231: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1232: ROLLBACK TO create_item_actions_PVT;
1233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1234: FND_MSG_PUB.Count_And_Get
1235: ( p_count => x_msg_count,
1236:
1237: p_data => x_msg_data
1238: );

Line 1244: IF FND_MSG_PUB.Check_Msg_Level

1240:
1241: WHEN OTHERS THEN
1242: ROLLBACK TO create_item_actions_PVT;
1243: x_return_status := FND_API.G_RET_STS_ERROR;
1244: IF FND_MSG_PUB.Check_Msg_Level
1245: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1246: THEN
1247: FND_MSG_PUB.Add_Exc_Msg
1248: ( G_PKG_NAME ,

Line 1245: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1241: WHEN OTHERS THEN
1242: ROLLBACK TO create_item_actions_PVT;
1243: x_return_status := FND_API.G_RET_STS_ERROR;
1244: IF FND_MSG_PUB.Check_Msg_Level
1245: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1246: THEN
1247: FND_MSG_PUB.Add_Exc_Msg
1248: ( G_PKG_NAME ,
1249: l_api_name

Line 1247: FND_MSG_PUB.Add_Exc_Msg

1243: x_return_status := FND_API.G_RET_STS_ERROR;
1244: IF FND_MSG_PUB.Check_Msg_Level
1245: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1246: THEN
1247: FND_MSG_PUB.Add_Exc_Msg
1248: ( G_PKG_NAME ,
1249: l_api_name
1250:
1251: );

Line 1253: FND_MSG_PUB.Count_And_Get

1249: l_api_name
1250:
1251: );
1252: END IF;
1253: FND_MSG_PUB.Count_And_Get
1254:
1255: ( p_count => x_msg_count ,
1256: p_data => x_msg_data
1257: );

Line 1296: FND_MSG_PUB.initialize;

1292:
1293: -- Initialize message list if p_init_msg_list is set to TRUE.
1294:
1295: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1296: FND_MSG_PUB.initialize;
1297: END IF;
1298:
1299: -- Initialize API return status to SUCCESS
1300:

Line 1377: FND_MSG_PUB.Count_And_Get

1373: COMMIT WORK;
1374: END IF;
1375:
1376: -- Standard callto get message count and if count is 1, get message info.
1377: FND_MSG_PUB.Count_And_Get
1378: ( p_count => x_msg_count,
1379: p_data => x_msg_data
1380: );
1381:

Line 1388: FND_MSG_PUB.Count_And_Get

1384:
1385: ROLLBACK TO create_item_action_dtls_pvt;
1386:
1387: x_return_status := FND_API.G_RET_STS_ERROR ;
1388: FND_MSG_PUB.Count_And_Get
1389: ( p_count => x_msg_count,
1390: p_data => x_msg_data
1391: );
1392:

Line 1396: FND_MSG_PUB.Count_And_Get

1392:
1393: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1394: ROLLBACK TO create_item_action_dtls_pvt;
1395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1396: FND_MSG_PUB.Count_And_Get
1397: ( p_count => x_msg_count,
1398:
1399: p_data => x_msg_data
1400: );

Line 1406: IF FND_MSG_PUB.Check_Msg_Level

1402:
1403: WHEN OTHERS THEN
1404: ROLLBACK TO create_item_action_dtls_pvt;
1405: x_return_status := FND_API.G_RET_STS_ERROR;
1406: IF FND_MSG_PUB.Check_Msg_Level
1407: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1408: THEN
1409: FND_MSG_PUB.Add_Exc_Msg
1410: ( G_PKG_NAME ,

Line 1407: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1403: WHEN OTHERS THEN
1404: ROLLBACK TO create_item_action_dtls_pvt;
1405: x_return_status := FND_API.G_RET_STS_ERROR;
1406: IF FND_MSG_PUB.Check_Msg_Level
1407: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1408: THEN
1409: FND_MSG_PUB.Add_Exc_Msg
1410: ( G_PKG_NAME ,
1411: l_api_name

Line 1409: FND_MSG_PUB.Add_Exc_Msg

1405: x_return_status := FND_API.G_RET_STS_ERROR;
1406: IF FND_MSG_PUB.Check_Msg_Level
1407: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1408: THEN
1409: FND_MSG_PUB.Add_Exc_Msg
1410: ( G_PKG_NAME ,
1411: l_api_name
1412:
1413: );

Line 1415: FND_MSG_PUB.Count_And_Get

1411: l_api_name
1412:
1413: );
1414: END IF;
1415: FND_MSG_PUB.Count_And_Get
1416:
1417: ( p_count => x_msg_count ,
1418: p_data => x_msg_data
1419: );

Line 1459: FND_MSG_PUB.initialize;

1455:
1456: --Initialize the message list if p_init_msg_list is set to TRUE
1457:
1458: If FND_API.to_Boolean(p_init_msg_list) THEN
1459: FND_MSG_PUB.initialize;
1460: END IF;
1461:
1462: --Initialize API status return
1463: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1505: FND_MSG_PUB.Count_And_Get

1501:
1502: WHEN FND_API.G_EXC_ERROR THEN
1503: ROLLBACK TO delete_acct_emailproc_batch;
1504: x_return_status := FND_API.G_RET_STS_ERROR ;
1505: FND_MSG_PUB.Count_And_Get
1506: ( p_count => x_msg_count,p_data => x_msg_data);
1507:
1508: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1509:

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

1509:
1510: ROLLBACK TO delete_acct_emailproc_batch;
1511:
1512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1513: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
1514:
1515: WHEN OTHERS THEN
1516: ROLLBACK TO delete_acct_emailproc_batch;
1517: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1518: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1514:
1515: WHEN OTHERS THEN
1516: ROLLBACK TO delete_acct_emailproc_batch;
1517: x_return_status := FND_API.G_RET_STS_ERROR;
1518: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1519: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
1520: END IF;
1521:
1522: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);

Line 1519: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);

1515: WHEN OTHERS THEN
1516: ROLLBACK TO delete_acct_emailproc_batch;
1517: x_return_status := FND_API.G_RET_STS_ERROR;
1518: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1519: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
1520: END IF;
1521:
1522: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);
1523:

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

1518: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1519: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
1520: END IF;
1521:
1522: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);
1523:
1524:
1525: END delete_acct_emailproc_batch;
1526: