140: x_msg_data => x_msg_data
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');
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;
150: RAISE FND_API.G_EXC_ERROR;
151: END IF;
152:
184: p_encoded => 'F');
185:
186: WHEN OTHERS THEN
187: ROLLBACK TO Associate_Resps_To_Msite_Pvt;
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;
185:
186: WHEN OTHERS THEN
187: ROLLBACK TO Associate_Resps_To_Msite_Pvt;
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;
186: WHEN OTHERS THEN
187: ROLLBACK TO Associate_Resps_To_Msite_Pvt;
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:
187: ROLLBACK TO Associate_Resps_To_Msite_Pvt;
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)
272: x_msg_data => x_msg_data
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');
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;
282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
283: END IF;
284:
305: x_msg_data => x_msg_data
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');
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;
315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
316: END IF;
317:
447: x_msg_data => x_msg_data
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');
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;
457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
458: END IF;
459:
486: x_msg_data => x_msg_data
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');
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;
496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
497: END IF;
498:
519: x_msg_data => x_msg_data
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');
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;
529: RAISE FND_API.G_EXC_ERROR;
530: END IF;
531:
549: x_msg_data => x_msg_data
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');
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;
559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
560: END IF;
561:
781: );
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');
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;
791: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
792: END IF;
793: