189:
190:
191: END LOOP;
192:
193: oe_msg_pub.initialize;
194: QP_Delayed_Requests_PVT.Clear_Request(l_return_status);
195:
196: EXCEPTION
197:
197:
198: WHEN FND_API.G_EXC_ERROR THEN
199: ROLLBACK TO delayedRequestSavePoint;
200: x_return_status := FND_API.G_RET_STS_ERROR;
201: x_return_status_text := oe_msg_pub.get(1,'F');
202: oe_msg_pub.initialize;
203: QP_Delayed_Requests_PVT.Clear_Request(l_return_status);
204:
205: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
198: WHEN FND_API.G_EXC_ERROR THEN
199: ROLLBACK TO delayedRequestSavePoint;
200: x_return_status := FND_API.G_RET_STS_ERROR;
201: x_return_status_text := oe_msg_pub.get(1,'F');
202: oe_msg_pub.initialize;
203: QP_Delayed_Requests_PVT.Clear_Request(l_return_status);
204:
205: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
206: ROLLBACK TO delayedRequestSavePoint;
204:
205: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
206: ROLLBACK TO delayedRequestSavePoint;
207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
208: x_return_status_text := oe_msg_pub.get(1,'F');
209: oe_msg_pub.initialize;
210: QP_Delayed_Requests_PVT.Clear_Request(l_return_status);
211:
212: WHEN OTHERS THEN
205: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
206: ROLLBACK TO delayedRequestSavePoint;
207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
208: x_return_status_text := oe_msg_pub.get(1,'F');
209: oe_msg_pub.initialize;
210: QP_Delayed_Requests_PVT.Clear_Request(l_return_status);
211:
212: WHEN OTHERS THEN
213: ROLLBACK TO delayedRequestSavePoint;
210: QP_Delayed_Requests_PVT.Clear_Request(l_return_status);
211:
212: WHEN OTHERS THEN
213: ROLLBACK TO delayedRequestSavePoint;
214: IF OE_MSG_PUB.Check_MSg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
215: THEN
216: OE_MSG_PUB.Add_Exc_Msg
217: (G_PKG_NAME
218: ,'LOGREQUEST');
212: WHEN OTHERS THEN
213: ROLLBACK TO delayedRequestSavePoint;
214: IF OE_MSG_PUB.Check_MSg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
215: THEN
216: OE_MSG_PUB.Add_Exc_Msg
217: (G_PKG_NAME
218: ,'LOGREQUEST');
219: END IF;
220: x_return_status := FND_API.G_RET_STS_ERROR;
217: (G_PKG_NAME
218: ,'LOGREQUEST');
219: END IF;
220: x_return_status := FND_API.G_RET_STS_ERROR;
221: x_return_status_text := oe_msg_pub.get(1,'F');
222: oe_msg_pub.initialize;
223: QP_Delayed_Requests_PVT.Clear_Request(l_return_status);
224:
225: END;
218: ,'LOGREQUEST');
219: END IF;
220: x_return_status := FND_API.G_RET_STS_ERROR;
221: x_return_status_text := oe_msg_pub.get(1,'F');
222: oe_msg_pub.initialize;
223: QP_Delayed_Requests_PVT.Clear_Request(l_return_status);
224:
225: END;
226: