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

Line 144: FND_MSG_PUB.initialize;

140: END IF;
141: -- Initialize message list if p_init_msg_list is set to TRUE.
142: IF FND_API.to_Boolean( p_init_msg_list )
143: THEN
144: FND_MSG_PUB.initialize;
145: END IF;
146: -- Initialize API return status to SUCCESS
147: x_return_status := FND_API.G_RET_STS_SUCCESS;
148:

Line 156: FND_MSG_PUB.Count_And_Get

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

Line 164: FND_MSG_PUB.Count_And_Get

160: EXCEPTION
161: WHEN FND_API.G_EXC_ERROR THEN
162: ROLLBACK TO delete_item_PVT;
163: x_return_status := FND_API.G_RET_STS_ERROR ;
164: FND_MSG_PUB.Count_And_Get
165: ( p_count => x_msg_count,
166: p_data => x_msg_data
167: );
168: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 171: FND_MSG_PUB.Count_And_Get

167: );
168: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
169: ROLLBACK TO delete_item_PVT;
170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
171: FND_MSG_PUB.Count_And_Get
172: ( p_count => x_msg_count,
173: p_data => x_msg_data
174: );
175: WHEN OTHERS THEN

Line 178: IF FND_MSG_PUB.Check_Msg_Level

174: );
175: WHEN OTHERS THEN
176: ROLLBACK TO delete_item_PVT;
177: x_return_status := FND_API.G_RET_STS_ERROR;
178: IF FND_MSG_PUB.Check_Msg_Level
179: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
180: THEN
181: FND_MSG_PUB.Add_Exc_Msg
182: ( G_PKG_NAME ,

Line 179: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

175: WHEN OTHERS THEN
176: ROLLBACK TO delete_item_PVT;
177: x_return_status := FND_API.G_RET_STS_ERROR;
178: IF FND_MSG_PUB.Check_Msg_Level
179: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
180: THEN
181: FND_MSG_PUB.Add_Exc_Msg
182: ( G_PKG_NAME ,
183: l_api_name

Line 181: FND_MSG_PUB.Add_Exc_Msg

177: x_return_status := FND_API.G_RET_STS_ERROR;
178: IF FND_MSG_PUB.Check_Msg_Level
179: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
180: THEN
181: FND_MSG_PUB.Add_Exc_Msg
182: ( G_PKG_NAME ,
183: l_api_name
184: );
185: END IF;

Line 186: FND_MSG_PUB.Count_And_Get

182: ( G_PKG_NAME ,
183: l_api_name
184: );
185: END IF;
186: FND_MSG_PUB.Count_And_Get
187: ( p_count => x_msg_count ,
188: p_data => x_msg_data
189: );
190: END;

Line 250: FND_MSG_PUB.initialize;

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

Line 284: FND_MSG_PUB.Count_And_Get

280: IF FND_API.To_Boolean(p_commit) THEN
281: COMMIT WORK;
282: END IF;
283: -- Standard callto get message count and if count is 1, get message info.
284: FND_MSG_PUB.Count_And_Get
285: ( p_count => x_msg_count,
286: p_data => x_msg_data
287: );
288: EXCEPTION

Line 292: FND_MSG_PUB.Count_And_Get

288: EXCEPTION
289: WHEN FND_API.G_EXC_ERROR THEN
290: ROLLBACK TO update_item_PVT;
291: x_return_status := FND_API.G_RET_STS_ERROR ;
292: FND_MSG_PUB.Count_And_Get
293: ( p_count => x_msg_count,
294: p_data => x_msg_data
295: );
296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 299: FND_MSG_PUB.Count_And_Get

295: );
296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
297: ROLLBACK TO update_item_PVT;
298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
299: FND_MSG_PUB.Count_And_Get
300: ( p_count => x_msg_count,
301: p_data => x_msg_data
302: );
303: WHEN IEM_DUPLICATE_THEME THEN

Line 308: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

304: ROLLBACK TO update_item_PVT;
305: FND_MESSAGE.SET_NAME('IEM','IEM_DUPLICATE_THEME');
306: x_return_status := FND_API.G_RET_STS_ERROR;
307: /*
308: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
309: THEN
310: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
311: END IF;
312: */

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

306: x_return_status := FND_API.G_RET_STS_ERROR;
307: /*
308: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
309: THEN
310: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
311: END IF;
312: */
313: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
314:

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

309: THEN
310: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
311: END IF;
312: */
313: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
314:
315: WHEN OTHERS THEN
316: ROLLBACK TO update_item_PVT;
317: x_return_status := FND_API.G_RET_STS_ERROR;

Line 318: IF FND_MSG_PUB.Check_Msg_Level

314:
315: WHEN OTHERS THEN
316: ROLLBACK TO update_item_PVT;
317: x_return_status := FND_API.G_RET_STS_ERROR;
318: IF FND_MSG_PUB.Check_Msg_Level
319: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
320: THEN
321: FND_MSG_PUB.Add_Exc_Msg
322: ( G_PKG_NAME ,

Line 319: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

315: WHEN OTHERS THEN
316: ROLLBACK TO update_item_PVT;
317: x_return_status := FND_API.G_RET_STS_ERROR;
318: IF FND_MSG_PUB.Check_Msg_Level
319: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
320: THEN
321: FND_MSG_PUB.Add_Exc_Msg
322: ( G_PKG_NAME ,
323: l_api_name

Line 321: FND_MSG_PUB.Add_Exc_Msg

317: x_return_status := FND_API.G_RET_STS_ERROR;
318: IF FND_MSG_PUB.Check_Msg_Level
319: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
320: THEN
321: FND_MSG_PUB.Add_Exc_Msg
322: ( G_PKG_NAME ,
323: l_api_name
324: );
325: END IF;

Line 326: FND_MSG_PUB.Count_And_Get

322: ( G_PKG_NAME ,
323: l_api_name
324: );
325: END IF;
326: FND_MSG_PUB.Count_And_Get
327: ( p_count => x_msg_count ,
328: p_data => x_msg_data
329: );
330:

Line 368: FND_MSG_PUB.initialize;

364: END IF;
365:
366: IF FND_API.to_Boolean( p_init_msg_list )
367: THEN
368: FND_MSG_PUB.initialize;
369: END IF;
370:
371: x_return_status := FND_API.G_RET_STS_SUCCESS;
372:

Line 422: FND_MSG_PUB.Count_And_Get

418: IF FND_API.To_Boolean(p_commit) THEN
419: COMMIT WORK;
420: END IF;
421:
422: FND_MSG_PUB.Count_And_Get
423: ( p_count => x_msg_count,
424: p_data => x_msg_data
425: );
426: EXCEPTION

Line 430: FND_MSG_PUB.Add;

426: EXCEPTION
427: WHEN IEM_DUPLICATE_THEME THEN
428: ROLLBACK TO create_item_jsp;
429: FND_MESSAGE.SET_NAME('IEM','IEM_DUPLICATE_THEME');
430: FND_MSG_PUB.Add;
431: x_return_status := FND_API.G_RET_STS_ERROR ;
432: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
433:
434: WHEN FND_API.G_EXC_ERROR THEN

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

428: ROLLBACK TO create_item_jsp;
429: FND_MESSAGE.SET_NAME('IEM','IEM_DUPLICATE_THEME');
430: FND_MSG_PUB.Add;
431: x_return_status := FND_API.G_RET_STS_ERROR ;
432: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
433:
434: WHEN FND_API.G_EXC_ERROR THEN
435: ROLLBACK TO create_item_jsp;
436: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 437: FND_MSG_PUB.Count_And_Get

433:
434: WHEN FND_API.G_EXC_ERROR THEN
435: ROLLBACK TO create_item_jsp;
436: x_return_status := FND_API.G_RET_STS_ERROR ;
437: FND_MSG_PUB.Count_And_Get
438: ( p_count => x_msg_count,
439: p_data => x_msg_data
440: );
441: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 444: FND_MSG_PUB.Count_And_Get

440: );
441: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
442: ROLLBACK TO create_item_jsp;
443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
444: FND_MSG_PUB.Count_And_Get
445: ( p_count => x_msg_count,
446: p_data => x_msg_data
447: );
448: WHEN OTHERS THEN

Line 451: IF FND_MSG_PUB.Check_Msg_Level

447: );
448: WHEN OTHERS THEN
449: ROLLBACK TO create_item_jsp;
450: x_return_status := FND_API.G_RET_STS_ERROR;
451: IF FND_MSG_PUB.Check_Msg_Level
452: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
453: THEN
454: FND_MSG_PUB.Add_Exc_Msg
455: ( G_PKG_NAME ,

Line 452: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

448: WHEN OTHERS THEN
449: ROLLBACK TO create_item_jsp;
450: x_return_status := FND_API.G_RET_STS_ERROR;
451: IF FND_MSG_PUB.Check_Msg_Level
452: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
453: THEN
454: FND_MSG_PUB.Add_Exc_Msg
455: ( G_PKG_NAME ,
456: l_api_name

Line 454: FND_MSG_PUB.Add_Exc_Msg

450: x_return_status := FND_API.G_RET_STS_ERROR;
451: IF FND_MSG_PUB.Check_Msg_Level
452: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
453: THEN
454: FND_MSG_PUB.Add_Exc_Msg
455: ( G_PKG_NAME ,
456: l_api_name
457: );
458: END IF;

Line 459: FND_MSG_PUB.Count_And_Get

455: ( G_PKG_NAME ,
456: l_api_name
457: );
458: END IF;
459: FND_MSG_PUB.Count_And_Get
460: ( p_count => x_msg_count ,
461: p_data => x_msg_data
462: );
463:

Line 499: FND_MSG_PUB.initialize;

495: END IF;
496:
497: IF FND_API.to_Boolean( p_init_msg_list )
498: THEN
499: FND_MSG_PUB.initialize;
500: END IF;
501:
502: x_return_status := FND_API.G_RET_STS_SUCCESS;
503:

Line 553: FND_MSG_PUB.Count_And_Get

549: IF FND_API.To_Boolean(p_commit) THEN
550: COMMIT WORK;
551: END IF;
552:
553: FND_MSG_PUB.Count_And_Get
554: ( p_count => x_msg_count,
555: p_data => x_msg_data
556: );
557: EXCEPTION

Line 561: FND_MSG_PUB.Add;

557: EXCEPTION
558: WHEN IEM_DUPLICATE_THEME THEN
559: ROLLBACK TO create_item_jsp;
560: FND_MESSAGE.SET_NAME('IEM','IEM_DUPLICATE_KEYWORD');
561: FND_MSG_PUB.Add;
562: x_return_status := FND_API.G_RET_STS_ERROR ;
563: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
564:
565: WHEN FND_API.G_EXC_ERROR THEN

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

559: ROLLBACK TO create_item_jsp;
560: FND_MESSAGE.SET_NAME('IEM','IEM_DUPLICATE_KEYWORD');
561: FND_MSG_PUB.Add;
562: x_return_status := FND_API.G_RET_STS_ERROR ;
563: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
564:
565: WHEN FND_API.G_EXC_ERROR THEN
566: ROLLBACK TO create_item_jsp;
567: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 568: FND_MSG_PUB.Count_And_Get

564:
565: WHEN FND_API.G_EXC_ERROR THEN
566: ROLLBACK TO create_item_jsp;
567: x_return_status := FND_API.G_RET_STS_ERROR ;
568: FND_MSG_PUB.Count_And_Get
569: ( p_count => x_msg_count,
570: p_data => x_msg_data
571: );
572: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 575: FND_MSG_PUB.Count_And_Get

571: );
572: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
573: ROLLBACK TO create_item_jsp;
574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
575: FND_MSG_PUB.Count_And_Get
576: ( p_count => x_msg_count,
577: p_data => x_msg_data
578: );
579: WHEN OTHERS THEN

Line 582: IF FND_MSG_PUB.Check_Msg_Level

578: );
579: WHEN OTHERS THEN
580: ROLLBACK TO create_item_jsp;
581: x_return_status := FND_API.G_RET_STS_ERROR;
582: IF FND_MSG_PUB.Check_Msg_Level
583: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
584: THEN
585: FND_MSG_PUB.Add_Exc_Msg
586: ( G_PKG_NAME ,

Line 583: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

579: WHEN OTHERS THEN
580: ROLLBACK TO create_item_jsp;
581: x_return_status := FND_API.G_RET_STS_ERROR;
582: IF FND_MSG_PUB.Check_Msg_Level
583: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
584: THEN
585: FND_MSG_PUB.Add_Exc_Msg
586: ( G_PKG_NAME ,
587: l_api_name

Line 585: FND_MSG_PUB.Add_Exc_Msg

581: x_return_status := FND_API.G_RET_STS_ERROR;
582: IF FND_MSG_PUB.Check_Msg_Level
583: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
584: THEN
585: FND_MSG_PUB.Add_Exc_Msg
586: ( G_PKG_NAME ,
587: l_api_name
588: );
589: END IF;

Line 590: FND_MSG_PUB.Count_And_Get

586: ( G_PKG_NAME ,
587: l_api_name
588: );
589: END IF;
590: FND_MSG_PUB.Count_And_Get
591: ( p_count => x_msg_count ,
592: p_data => x_msg_data
593: );
594:

Line 624: FND_MSG_PUB.initialize;

620: END IF;
621:
622: --Initialize the message list if p_init_msg_list is set to TRUE
623: If FND_API.to_Boolean(p_init_msg_list) THEN
624: FND_MSG_PUB.initialize;
625: END IF;
626:
627: --Initialize API status return
628: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 638: FND_MSG_PUB.ADD;

634: WHERE theme_id = p_thes_ids_tbl(i);
635:
636: IF SQL%NOTFOUND THEN
637: FND_MESSAGE.SET_NAME('IEM', 'IEM_EXP_INVALID_ACCOUNT');
638: FND_MSG_PUB.ADD;
639: RAISE FND_API.G_EXC_ERROR;
640: END IF;
641:
642: --Standard check of p_commit

Line 648: FND_MSG_PUB.Count_And_Get

644: COMMIT WORK;
645: END IF;
646:
647: -- Standard callto get message count and if count is 1, get message info.
648: FND_MSG_PUB.Count_And_Get
649: ( p_count => x_msg_count,
650: p_data => x_msg_data
651: );
652: EXCEPTION

Line 656: FND_MSG_PUB.Count_And_Get

652: EXCEPTION
653: WHEN FND_API.G_EXC_ERROR THEN
654: ROLLBACK TO delete_item_wrap;
655: x_return_status := FND_API.G_RET_STS_ERROR ;
656: FND_MSG_PUB.Count_And_Get
657: ( p_count => x_msg_count,
658: p_data => x_msg_data
659: );
660: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 663: FND_MSG_PUB.Count_And_Get

659: );
660: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
661: ROLLBACK TO delete_item_wrap;
662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
663: FND_MSG_PUB.Count_And_Get
664: ( p_count => x_msg_count,
665: p_data => x_msg_data
666: );
667: WHEN OTHERS THEN

Line 670: IF FND_MSG_PUB.Check_Msg_Level

666: );
667: WHEN OTHERS THEN
668: ROLLBACK TO delete_item_wrap;
669: x_return_status := FND_API.G_RET_STS_ERROR;
670: IF FND_MSG_PUB.Check_Msg_Level
671: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
672: THEN
673: FND_MSG_PUB.Add_Exc_Msg
674: ( G_PKG_NAME ,

Line 671: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

667: WHEN OTHERS THEN
668: ROLLBACK TO delete_item_wrap;
669: x_return_status := FND_API.G_RET_STS_ERROR;
670: IF FND_MSG_PUB.Check_Msg_Level
671: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
672: THEN
673: FND_MSG_PUB.Add_Exc_Msg
674: ( G_PKG_NAME ,
675: l_api_name

Line 673: FND_MSG_PUB.Add_Exc_Msg

669: x_return_status := FND_API.G_RET_STS_ERROR;
670: IF FND_MSG_PUB.Check_Msg_Level
671: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
672: THEN
673: FND_MSG_PUB.Add_Exc_Msg
674: ( G_PKG_NAME ,
675: l_api_name
676: );
677: END IF;

Line 678: FND_MSG_PUB.Count_And_Get

674: ( G_PKG_NAME ,
675: l_api_name
676: );
677: END IF;
678: FND_MSG_PUB.Count_And_Get
679: ( p_count => x_msg_count ,
680: p_data => x_msg_data
681: );
682: --Standard call to get message count and message info

Line 683: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

679: ( p_count => x_msg_count ,
680: p_data => x_msg_data
681: );
682: --Standard call to get message count and message info
683: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
684: p_data => x_msg_data);
685: END delete_item_wrap;
686: PROCEDURE delete_item_wrap_sss
687: (p_api_version_number IN NUMBER,

Line 716: FND_MSG_PUB.initialize;

712: END IF;
713:
714: --Initialize the message list if p_init_msg_list is set to TRUE
715: If FND_API.to_Boolean(p_init_msg_list) THEN
716: FND_MSG_PUB.initialize;
717: END IF;
718:
719: --Initialize API status return
720: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 750: FND_MSG_PUB.ADD;

746: l_status );
747:
748: IF SQL%NOTFOUND THEN
749: FND_MESSAGE.SET_NAME('IEM', 'IEM_EXP_INVALID_ACCOUNT');
750: FND_MSG_PUB.ADD;
751: RAISE FND_API.G_EXC_ERROR;
752: END IF;
753:
754: --Standard check of p_commit

Line 760: FND_MSG_PUB.Count_And_Get

756: COMMIT WORK;
757: END IF;
758:
759: -- Standard callto get message count and if count is 1, get message info.
760: FND_MSG_PUB.Count_And_Get
761: ( p_count => x_msg_count,
762: p_data => x_msg_data
763: );
764: EXCEPTION

Line 768: FND_MSG_PUB.Count_And_Get

764: EXCEPTION
765: WHEN FND_API.G_EXC_ERROR THEN
766: ROLLBACK TO delete_item_wrap;
767: x_return_status := FND_API.G_RET_STS_ERROR ;
768: FND_MSG_PUB.Count_And_Get
769: ( p_count => x_msg_count,
770: p_data => x_msg_data
771: );
772: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 775: FND_MSG_PUB.Count_And_Get

771: );
772: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
773: ROLLBACK TO delete_item_wrap;
774: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
775: FND_MSG_PUB.Count_And_Get
776: ( p_count => x_msg_count,
777: p_data => x_msg_data
778: );
779: WHEN OTHERS THEN

Line 782: IF FND_MSG_PUB.Check_Msg_Level

778: );
779: WHEN OTHERS THEN
780: ROLLBACK TO delete_item_wrap;
781: x_return_status := FND_API.G_RET_STS_ERROR;
782: IF FND_MSG_PUB.Check_Msg_Level
783: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
784: THEN
785: FND_MSG_PUB.Add_Exc_Msg
786: ( G_PKG_NAME ,

Line 783: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

779: WHEN OTHERS THEN
780: ROLLBACK TO delete_item_wrap;
781: x_return_status := FND_API.G_RET_STS_ERROR;
782: IF FND_MSG_PUB.Check_Msg_Level
783: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
784: THEN
785: FND_MSG_PUB.Add_Exc_Msg
786: ( G_PKG_NAME ,
787: l_api_name

Line 785: FND_MSG_PUB.Add_Exc_Msg

781: x_return_status := FND_API.G_RET_STS_ERROR;
782: IF FND_MSG_PUB.Check_Msg_Level
783: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
784: THEN
785: FND_MSG_PUB.Add_Exc_Msg
786: ( G_PKG_NAME ,
787: l_api_name
788: );
789: END IF;

Line 790: FND_MSG_PUB.Count_And_Get

786: ( G_PKG_NAME ,
787: l_api_name
788: );
789: END IF;
790: FND_MSG_PUB.Count_And_Get
791: ( p_count => x_msg_count ,
792: p_data => x_msg_data
793: );
794: --Standard call to get message count and message info

Line 795: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

791: ( p_count => x_msg_count ,
792: p_data => x_msg_data
793: );
794: --Standard call to get message count and message info
795: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
796: p_data => x_msg_data);
797: END delete_item_wrap_sss;
798:
799: PROCEDURE update_item_wrap (p_api_version_number IN NUMBER,

Line 836: FND_MSG_PUB.initialize;

832: END IF;
833: -- Initialize message list if p_init_msg_list is set to TRUE.
834: IF FND_API.to_Boolean( p_init_msg_list )
835: THEN
836: FND_MSG_PUB.initialize;
837: END IF;
838: -- Initialize API return status to SUCCESS
839: x_return_status := FND_API.G_RET_STS_SUCCESS;
840:

Line 889: FND_MSG_PUB.Count_And_Get

885: IF FND_API.To_Boolean(p_commit) THEN
886: COMMIT WORK;
887: END IF;
888: -- Standard callto get message count and if count is 1, get message info.
889: FND_MSG_PUB.Count_And_Get
890: ( p_count => x_msg_count,
891: p_data => x_msg_data
892: );
893: EXCEPTION

Line 897: FND_MSG_PUB.Add;

893: EXCEPTION
894: WHEN IEM_DUPLICATE_THEME THEN
895: ROLLBACK TO update_item_PVT;
896: FND_MESSAGE.SET_NAME('IEM','IEM_DUPLICATE_THEME');
897: FND_MSG_PUB.Add;
898: x_return_status := FND_API.G_RET_STS_ERROR ;
899: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
900:
901:

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

895: ROLLBACK TO update_item_PVT;
896: FND_MESSAGE.SET_NAME('IEM','IEM_DUPLICATE_THEME');
897: FND_MSG_PUB.Add;
898: x_return_status := FND_API.G_RET_STS_ERROR ;
899: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
900:
901:
902: WHEN FND_API.G_EXC_ERROR THEN
903: ROLLBACK TO update_item_PVT;

Line 905: FND_MSG_PUB.Count_And_Get

901:
902: WHEN FND_API.G_EXC_ERROR THEN
903: ROLLBACK TO update_item_PVT;
904: x_return_status := FND_API.G_RET_STS_ERROR ;
905: FND_MSG_PUB.Count_And_Get
906: ( p_count => x_msg_count,
907: p_data => x_msg_data
908: );
909: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 912: FND_MSG_PUB.Count_And_Get

908: );
909: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
910: ROLLBACK TO update_item_PVT;
911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
912: FND_MSG_PUB.Count_And_Get
913: ( p_count => x_msg_count,
914: p_data => x_msg_data
915: );
916: WHEN OTHERS THEN

Line 919: IF FND_MSG_PUB.Check_Msg_Level

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

Line 920: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

Line 922: FND_MSG_PUB.Add_Exc_Msg

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

Line 927: FND_MSG_PUB.Count_And_Get

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