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

Line 93: FND_MSG_PUB.initialize;

89: END IF;
90:
91: -- Initialize message list if p_init_msg_list is set to TRUE.
92: IF FND_API.to_Boolean(p_init_msg_list) THEN
93: FND_MSG_PUB.initialize;
94: END IF;
95:
96: -- Initialize API return status to success
97: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 145: FND_MSG_PUB.Add;

141: );
142:
143: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
144: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_CREATE_MSITE_RESP_FL');
145: FND_MSG_PUB.Add;
146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
147: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
148: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_CREATE_MSITE_RESP_FL');
149: FND_MSG_PUB.Add;

Line 149: FND_MSG_PUB.Add;

145: FND_MSG_PUB.Add;
146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
147: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
148: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_CREATE_MSITE_RESP_FL');
149: FND_MSG_PUB.Add;
150: RAISE FND_API.G_EXC_ERROR;
151: END IF;
152:
153: END IF;

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

162: COMMIT WORK;
163: END IF;
164:
165: -- Standard call to get message count and if count is 1, get message info.
166: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
167: p_data => x_msg_data,
168: p_encoded => 'F');
169:
170: EXCEPTION

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

171:
172: WHEN FND_API.G_EXC_ERROR THEN
173: ROLLBACK TO Associate_Resps_To_Msite_Pvt;
174: x_return_status := FND_API.G_RET_STS_ERROR;
175: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
176: p_data => x_msg_data,
177: p_encoded => 'F');
178:
179: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

178:
179: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
180: ROLLBACK TO Associate_Resps_To_Msite_Pvt;
181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
182: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
183: p_data => x_msg_data,
184: p_encoded => 'F');
185:
186: WHEN OTHERS THEN

Line 192: FND_MSG_PUB.Add;

188: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
189: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
190: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
191: FND_MESSAGE.Set_Token('REASON', SQLERRM);
192: FND_MSG_PUB.Add;
193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
194:
195: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
196: THEN

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

191: FND_MESSAGE.Set_Token('REASON', SQLERRM);
192: FND_MSG_PUB.Add;
193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
194:
195: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
196: THEN
197: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
198: END IF;
199:

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

193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
194:
195: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
196: THEN
197: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
198: END IF;
199:
200: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
201: p_data => x_msg_data,

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

196: THEN
197: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
198: END IF;
199:
200: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
201: p_data => x_msg_data,
202: p_encoded => 'F');
203:
204: END Associate_Resps_To_MSite;

Line 246: FND_MSG_PUB.initialize;

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

Line 277: FND_MSG_PUB.Add;

273: );
274:
275: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
276: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_DELETE_MSITE_RESP_FL');
277: FND_MSG_PUB.Add;
278: RAISE FND_API.G_EXC_ERROR;
279: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
280: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_DELETE_MSITE_RESP_FL');
281: FND_MSG_PUB.Add;

Line 281: FND_MSG_PUB.Add;

277: FND_MSG_PUB.Add;
278: RAISE FND_API.G_EXC_ERROR;
279: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
280: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_DELETE_MSITE_RESP_FL');
281: FND_MSG_PUB.Add;
282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
283: END IF;
284:
285: ELSE

Line 310: FND_MSG_PUB.Add;

306: );
307:
308: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
309: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_UPDATE_MSITE_RESP_FL');
310: FND_MSG_PUB.Add;
311: RAISE FND_API.G_EXC_ERROR;
312: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
313: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_UPDATE_MSITE_RESP_FL');
314: FND_MSG_PUB.Add;

Line 314: FND_MSG_PUB.Add;

310: FND_MSG_PUB.Add;
311: RAISE FND_API.G_EXC_ERROR;
312: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
313: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_UPDATE_MSITE_RESP_FL');
314: FND_MSG_PUB.Add;
315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
316: END IF;
317:
318: END IF;

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

327: COMMIT WORK;
328: END IF;
329:
330: -- Standard call to get message count and if count is 1, get message info.
331: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
332: p_data => x_msg_data,
333: p_encoded => 'F');
334:
335: EXCEPTION

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

336:
337: WHEN FND_API.G_EXC_ERROR THEN
338: ROLLBACK TO Update_Delete_Msite_Resps_Pvt;
339: x_return_status := FND_API.G_RET_STS_ERROR;
340: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
341: p_data => x_msg_data,
342: p_encoded => 'F');
343:
344: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

343:
344: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
345: ROLLBACK TO Update_Delete_Msite_Resps_Pvt;
346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
347: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
348: p_data => x_msg_data,
349: p_encoded => 'F');
350:
351: WHEN OTHERS THEN

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

351: WHEN OTHERS THEN
352: ROLLBACK TO Update_Delete_Msite_Resps_Pvt;
353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
354:
355: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
356: THEN
357: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
358: END IF;
359:

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

353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
354:
355: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
356: THEN
357: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
358: END IF;
359:
360: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
361: p_data => x_msg_data,

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

356: THEN
357: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
358: END IF;
359:
360: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
361: p_data => x_msg_data,
362: p_encoded => 'F');
363:
364: END Update_Delete_Msite_Resps;

Line 420: FND_MSG_PUB.initialize;

416: END IF;
417:
418: -- Initialize message list if p_init_msg_list is set to TRUE.
419: IF FND_API.to_Boolean(p_init_msg_list) THEN
420: FND_MSG_PUB.initialize;
421: END IF;
422:
423: -- Initialize API return status to success
424: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 452: FND_MSG_PUB.Add;

448: );
449:
450: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
451: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_DELETE_MSITE_RESP_FL');
452: FND_MSG_PUB.Add;
453: RAISE FND_API.G_EXC_ERROR;
454: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
455: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_DELETE_MSITE_RESP_FL');
456: FND_MSG_PUB.Add;

Line 456: FND_MSG_PUB.Add;

452: FND_MSG_PUB.Add;
453: RAISE FND_API.G_EXC_ERROR;
454: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
455: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_DELETE_MSITE_RESP_FL');
456: FND_MSG_PUB.Add;
457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
458: END IF;
459:
460: ELSIF (p_delete_flags(i) = 'IG') THEN

Line 491: FND_MSG_PUB.Add;

487: );
488:
489: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
490: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_UPDATE_MSITE_RESP_FL');
491: FND_MSG_PUB.Add;
492: RAISE FND_API.G_EXC_ERROR;
493: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
494: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_UPDATE_MSITE_RESP_FL');
495: FND_MSG_PUB.Add;

Line 495: FND_MSG_PUB.Add;

491: FND_MSG_PUB.Add;
492: RAISE FND_API.G_EXC_ERROR;
493: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
494: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_UPDATE_MSITE_RESP_FL');
495: FND_MSG_PUB.Add;
496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
497: END IF;
498:
499: ELSE

Line 524: FND_MSG_PUB.Add;

520: );
521:
522: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
523: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_CREATE_MSITE_RESP_FL');
524: FND_MSG_PUB.Add;
525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
526: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
527: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_CREATE_MSITE_RESP_FL');
528: FND_MSG_PUB.Add;

Line 528: FND_MSG_PUB.Add;

524: FND_MSG_PUB.Add;
525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
526: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
527: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_CREATE_MSITE_RESP_FL');
528: FND_MSG_PUB.Add;
529: RAISE FND_API.G_EXC_ERROR;
530: END IF;
531:
532: END IF;

Line 554: FND_MSG_PUB.Add;

550: );
551:
552: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
553: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_UPDATE_MSITE_RESP_FL');
554: FND_MSG_PUB.Add;
555: RAISE FND_API.G_EXC_ERROR;
556: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
557: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_UPDATE_MSITE_RESP_FL');
558: FND_MSG_PUB.Add;

Line 558: FND_MSG_PUB.Add;

554: FND_MSG_PUB.Add;
555: RAISE FND_API.G_EXC_ERROR;
556: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
557: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_UPDATE_MSITE_RESP_FL');
558: FND_MSG_PUB.Add;
559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
560: END IF;
561:
562: ELSIF (p_delete_flags(i) = 'N') THEN

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

572: COMMIT WORK;
573: END IF;
574:
575: -- Standard call to get message count and if count is 1, get message info.
576: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
577: p_data => x_msg_data,
578: p_encoded => 'F');
579:
580: EXCEPTION

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

581:
582: WHEN FND_API.G_EXC_ERROR THEN
583: ROLLBACK TO Update_Delete_Msite_Resps_Pvt;
584: x_return_status := FND_API.G_RET_STS_ERROR;
585: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
586: p_data => x_msg_data,
587: p_encoded => 'F');
588:
589: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

588:
589: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
590: ROLLBACK TO Update_Delete_Msite_Resps_Pvt;
591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
592: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
593: p_data => x_msg_data,
594: p_encoded => 'F');
595:
596: WHEN OTHERS THEN

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

596: WHEN OTHERS THEN
597: ROLLBACK TO Update_Delete_Msite_Resps_Pvt;
598: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
599:
600: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
601: THEN
602: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
603: END IF;
604:

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

598: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
599:
600: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
601: THEN
602: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
603: END IF;
604:
605: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
606: p_data => x_msg_data,

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

601: THEN
602: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
603: END IF;
604:
605: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
606: p_data => x_msg_data,
607: p_encoded => 'F');
608:
609: END Update_Delete_Msite_Resps;

Line 639: FND_MSG_PUB.initialize;

635: BEGIN
636:
637: -- Initialize message list if p_init_msg_list is set to TRUE.
638: IF FND_API.to_Boolean(p_init_msg_list) THEN
639: FND_MSG_PUB.initialize;
640: END IF;
641:
642: -- Initialize API return status to success
643: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

683: EXCEPTION
684:
685: WHEN FND_API.G_EXC_ERROR THEN
686: x_return_status := FND_API.G_RET_STS_ERROR;
687: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
688: p_data => x_msg_data,
689: p_encoded => 'F');
690:
691: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

689: p_encoded => 'F');
690:
691: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
692: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
693: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
694: p_data => x_msg_data,
695: p_encoded => 'F');
696:
697: WHEN OTHERS THEN

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

696:
697: WHEN OTHERS THEN
698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
699:
700: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
701: THEN
702: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
703: END IF;
704:

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

698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
699:
700: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
701: THEN
702: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
703: END IF;
704:
705: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
706: p_data => x_msg_data,

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

701: THEN
702: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
703: END IF;
704:
705: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
706: p_data => x_msg_data,
707: p_encoded => 'F');
708:
709: END Load_MsiteResps_For_Msite;

Line 749: FND_MSG_PUB.initialize;

745: END IF;
746:
747: -- Initialize message list if p_init_msg_list is set to TRUE.
748: IF FND_API.to_Boolean(p_init_msg_list) THEN
749: FND_MSG_PUB.initialize;
750: END IF;
751:
752: -- Initialize API return status to success
753: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 786: FND_MSG_PUB.Add;

782:
783:
784: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
785: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_UPDATE_MSITE_RESP_FL');
786: FND_MSG_PUB.Add;
787: RAISE FND_API.G_EXC_ERROR;
788: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
789: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_UPDATE_MSITE_RESP_FL');
790: FND_MSG_PUB.Add;

Line 790: FND_MSG_PUB.Add;

786: FND_MSG_PUB.Add;
787: RAISE FND_API.G_EXC_ERROR;
788: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
789: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_UPDATE_MSITE_RESP_FL');
790: FND_MSG_PUB.Add;
791: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
792: END IF;
793:
794:

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

802: COMMIT WORK;
803: END IF;
804:
805: -- Standard call to get message count and if count is 1, get message info.
806: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
807: p_data => x_msg_data,
808: p_encoded => 'F');
809:
810: EXCEPTION

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

811:
812: WHEN FND_API.G_EXC_ERROR THEN
813: ROLLBACK TO Update_Delete_Msite_Resps_Pvt;
814: x_return_status := FND_API.G_RET_STS_ERROR;
815: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
816: p_data => x_msg_data,
817: p_encoded => 'F');
818:
819: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

818:
819: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
820: ROLLBACK TO Update_Delete_Msite_Resps_Pvt;
821: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
822: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
823: p_data => x_msg_data,
824: p_encoded => 'F');
825:
826: WHEN OTHERS THEN

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

826: WHEN OTHERS THEN
827: ROLLBACK TO Update_Delete_Msite_Resps_Pvt;
828: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
829:
830: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
831: THEN
832: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
833: END IF;
834:

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

828: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
829:
830: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
831: THEN
832: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
833: END IF;
834:
835: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
836: p_data => x_msg_data,

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

831: THEN
832: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
833: END IF;
834:
835: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
836: p_data => x_msg_data,
837: p_encoded => 'F');
838:
839: END Update_Msite_Resps;