DBA Data[Home] [Help]

APPS.QP_OA_DELAYED_REQUESTS_PVT dependencies on QP_DELAYED_REQUESTS_PVT

Line 113: QP_Delayed_Requests_PVT.Log_Request(

109: LOOP
110:
111: l_request := requestTbl(i);
112:
113: QP_Delayed_Requests_PVT.Log_Request(
114: l_request.entity_code,
115: l_request.entity_id,
116: l_request.requesting_entity_code,
117: l_request.requesting_entity_id,

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

190:
191: END LOOP;
192:
193: oe_msg_pub.initialize;
194: QP_Delayed_Requests_PVT.Clear_Request(l_return_status);
195:
196: EXCEPTION
197:
198: WHEN FND_API.G_EXC_ERROR THEN

Line 203: QP_Delayed_Requests_PVT.Clear_Request(l_return_status);

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;
207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 210: QP_Delayed_Requests_PVT.Clear_Request(l_return_status);

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;
214: IF OE_MSG_PUB.Check_MSg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 223: QP_Delayed_Requests_PVT.Clear_Request(l_return_status);

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