APPS.QP_OA_DELAYED_REQUESTS_PVT dependencies on FND_API

Line 106: x_return_status := FND_API.G_RET_STS_SUCCESS;

102: BEGIN
103:
104: SAVEPOINT delayedRequestSavePoint;
105:
106: x_return_status := FND_API.G_RET_STS_SUCCESS;
107:
108: FOR i IN 1 .. requestTbl.COUNT
109: LOOP
110:

Line 152: IF (l_return_status IN (FND_API.G_RET_STS_UNEXP_ERROR,FND_API.G_RET_STS_ERROR)) THEN

148: l_request.param25,
149: l_request.long_param1,
150: l_return_status);
151:
152: IF (l_return_status IN (FND_API.G_RET_STS_UNEXP_ERROR,FND_API.G_RET_STS_ERROR)) THEN
153: x_error_type := 'LOGGING';
154: END IF;
155:
156: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 156: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

152: IF (l_return_status IN (FND_API.G_RET_STS_UNEXP_ERROR,FND_API.G_RET_STS_ERROR)) THEN
153: x_error_type := 'LOGGING';
154: END IF;
155:
156: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
158: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
159: RAISE FND_API.G_EXC_ERROR;
160: END IF;

Line 157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

153: x_error_type := 'LOGGING';
154: END IF;
155:
156: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
158: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
159: RAISE FND_API.G_EXC_ERROR;
160: END IF;
161:

Line 158: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

154: END IF;
155:
156: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
158: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
159: RAISE FND_API.G_EXC_ERROR;
160: END IF;
161:
162:

Line 159: RAISE FND_API.G_EXC_ERROR;

155:
156: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
158: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
159: RAISE FND_API.G_EXC_ERROR;
160: END IF;
161:
162:
163: END LOOP;

Line 170: QP_DELAYED_REQUESTS_PVT.Process_Request_For_ReqType(l_request.request_type,FND_API.G_TRUE,l_return_status);

166: LOOP
167:
168: l_request := requestTbl(i);
169:
170: QP_DELAYED_REQUESTS_PVT.Process_Request_For_ReqType(l_request.request_type,FND_API.G_TRUE,l_return_status);
171:
172: insert_msg(l_request,l_return_status);
173:
174: /*insert into del_request_test values(l_request.request_type,l_request.entity_id,

Line 177: IF (l_return_status IN (FND_API.G_RET_STS_UNEXP_ERROR,FND_API.G_RET_STS_ERROR)) THEN

173:
174: /*insert into del_request_test values(l_request.request_type,l_request.entity_id,
175: l_request.entity_code, l_return_status);*/
176:
177: IF (l_return_status IN (FND_API.G_RET_STS_UNEXP_ERROR,FND_API.G_RET_STS_ERROR)) THEN
178: x_error_type := 'DELAYED_REQUEST';
179: x_error_request_type := l_request.request_type;
180: x_error_entity_id := l_request.entity_id;
181: x_error_entity_code := l_request.entity_code;

Line 184: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

180: x_error_entity_id := l_request.entity_id;
181: x_error_entity_code := l_request.entity_code;
182: END IF;
183:
184: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
185: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
186: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
187: RAISE FND_API.G_EXC_ERROR;
188: END IF;

Line 185: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

181: x_error_entity_code := l_request.entity_code;
182: END IF;
183:
184: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
185: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
186: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
187: RAISE FND_API.G_EXC_ERROR;
188: END IF;
189:

Line 186: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

182: END IF;
183:
184: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
185: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
186: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
187: RAISE FND_API.G_EXC_ERROR;
188: END IF;
189:
190:

Line 187: RAISE FND_API.G_EXC_ERROR;

183:
184: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
185: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
186: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
187: RAISE FND_API.G_EXC_ERROR;
188: END IF;
189:
190:
191: END LOOP;

Line 198: WHEN FND_API.G_EXC_ERROR THEN

194: QP_Delayed_Requests_PVT.Clear_Request(l_return_status);
195:
196: EXCEPTION
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;

Line 200: x_return_status := FND_API.G_RET_STS_ERROR;

196: EXCEPTION
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:

Line 205: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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;
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;

Line 207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

203: QP_Delayed_Requests_PVT.Clear_Request(l_return_status);
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:

Line 220: x_return_status := FND_API.G_RET_STS_ERROR;

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;
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: