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:
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
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
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
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 ,
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
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;
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;
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:
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
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
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
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: */
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:
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;
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 ,
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
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;
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:
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:
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
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
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 ;
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
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
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 ,
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
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;
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:
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:
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
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
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 ;
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
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
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 ,
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
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;
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:
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;
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
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
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
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
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 ,
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
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;
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
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,
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;
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
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
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
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
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 ,
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
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;
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
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,
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:
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
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:
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;
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
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
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 ,
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
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;
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;