368: WHEN OTHERS THEN
369: x_return_status := FND_API.G_RET_STS_ERROR;
370: x_return_status_text := 'UTL_HTTP REQUEST_FAILED exception';
371: END;
372: WHEN UTL_TCP.END_OF_INPUT THEN
373: x_return_status := FND_API.G_RET_STS_ERROR;
374: x_return_status_text := 'UTL_TCP.END_OF_INPUT';
375: IF l_debug = FND_API.G_TRUE THEN
376: QP_PREQ_GRP.engine_debug('HTTP request failed because of UTL_TCP.END_OF_INPUT');
370: x_return_status_text := 'UTL_HTTP REQUEST_FAILED exception';
371: END;
372: WHEN UTL_TCP.END_OF_INPUT THEN
373: x_return_status := FND_API.G_RET_STS_ERROR;
374: x_return_status_text := 'UTL_TCP.END_OF_INPUT';
375: IF l_debug = FND_API.G_TRUE THEN
376: QP_PREQ_GRP.engine_debug('HTTP request failed because of UTL_TCP.END_OF_INPUT');
377: END IF;
378: WHEN OTHERS THEN
372: WHEN UTL_TCP.END_OF_INPUT THEN
373: x_return_status := FND_API.G_RET_STS_ERROR;
374: x_return_status_text := 'UTL_TCP.END_OF_INPUT';
375: IF l_debug = FND_API.G_TRUE THEN
376: QP_PREQ_GRP.engine_debug('HTTP request failed because of UTL_TCP.END_OF_INPUT');
377: END IF;
378: WHEN OTHERS THEN
379: BEGIN
380: --EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlcode from dual' INTO x_return_status;
502:
503: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
504: IF (p_timeout_processing = FND_API.G_TRUE) THEN
505: /*UTL_HTTP_TRANSFER Timeout and HTTP Timeout issue handling*/
506: IF (x_return_status_text = 'UTL_TCP.END_OF_INPUT' or instr(x_return_status_text, 'ORA-29276') <> 0) THEN
507: l_status_request_cnt := 0;
508: LOOP
509: IF l_debug = FND_API.G_TRUE THEN
510: QP_PREQ_GRP.engine_debug('sleeping........'||G_STATUS_REQUEST_INTERVAL||'(secs)');
520: QP_PREQ_GRP.engine_debug('After inquery HTTP call: x_return_status='||x_return_status||' x_return_status_text='||x_return_status_text);
521: END IF;
522:
523: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
524: IF (x_return_status_text <> 'UTL_TCP.END_OF_INPUT' and instr(x_return_status_text, 'ORA-29276') = 0) THEN
525: /*other errors than timeout error, send request to remove mid-tier status */
526: --UTL_HTTP_REQUEST(l_engine_server_url||'?'||l_ctxt_str||G_HARD_CHAR||'Action=finish'|| G_HARD_CHAR||'RequestId='|| QP_Price_Request_Context.GET_REQUEST_ID, x_return_status, x_return_status_text);
527: UTL_HTTP_REQUEST(l_engine_server_url||'?'||l_ctxt_str||G_HARD_CHAR||'Action=finish'|| G_HARD_CHAR||'RequestId='|| QP_Price_Request_Context.GET_REQUEST_ID,
528: l_return_status_code,
531: p_use_request_pieces);
532: RAISE E_ROUTINE_ERRORS;
533: END IF;
534: END IF;
535: EXIT WHEN x_return_status_text <> 'IN_PROGRESS' and x_return_status_text <> 'UTL_TCP.END_OF_INPUT' and instr(x_return_status_text, 'ORA-29276') = 0;
536:
537: -- 'COMPLETED','ERROR', or anything else;
538: IF l_status_request_cnt > G_MAX_STATUS_REQUESTS THEN
539: RAISE MAX_STATUS_REQUESTS_REACHED;
606: WHEN OTHERS THEN
607: x_return_status := FND_API.G_RET_STS_ERROR;
608: x_return_status_text := 'UTL_HTTP REQUEST_FAILED exception';
609: END;
610: WHEN UTL_TCP.END_OF_INPUT THEN
611: x_return_status := FND_API.G_RET_STS_ERROR;
612: x_return_status_text := 'UTL_TCP.END_OF_INPUT';
613: IF l_debug = FND_API.G_TRUE THEN
614: QP_PREQ_GRP.engine_debug('HTTP request failed because of UTL_TCP.END_OF_INPUT');
608: x_return_status_text := 'UTL_HTTP REQUEST_FAILED exception';
609: END;
610: WHEN UTL_TCP.END_OF_INPUT THEN
611: x_return_status := FND_API.G_RET_STS_ERROR;
612: x_return_status_text := 'UTL_TCP.END_OF_INPUT';
613: IF l_debug = FND_API.G_TRUE THEN
614: QP_PREQ_GRP.engine_debug('HTTP request failed because of UTL_TCP.END_OF_INPUT');
615: END IF;
616: WHEN E_JAVA_ENGINE_URL_NULL THEN
610: WHEN UTL_TCP.END_OF_INPUT THEN
611: x_return_status := FND_API.G_RET_STS_ERROR;
612: x_return_status_text := 'UTL_TCP.END_OF_INPUT';
613: IF l_debug = FND_API.G_TRUE THEN
614: QP_PREQ_GRP.engine_debug('HTTP request failed because of UTL_TCP.END_OF_INPUT');
615: END IF;
616: WHEN E_JAVA_ENGINE_URL_NULL THEN
617: x_return_status := FND_API.G_RET_STS_ERROR;
618: FND_MESSAGE.SET_NAME('QP','QP_JPE_URL_NULL_ERROR');
827: WHEN OTHERS THEN
828: x_return_status := FND_API.G_RET_STS_ERROR;
829: x_return_status_text := 'UTL_HTTP REQUEST_FAILED exception';
830: END;
831: WHEN UTL_TCP.END_OF_INPUT THEN
832: x_return_status := FND_API.G_RET_STS_ERROR;
833: x_return_status_text := 'UTL_TCP.END_OF_INPUT';
834: IF l_debug = FND_API.G_TRUE THEN
835: QP_PREQ_GRP.engine_debug('HTTP request failed because of UTL_TCP.END_OF_INPUT');
829: x_return_status_text := 'UTL_HTTP REQUEST_FAILED exception';
830: END;
831: WHEN UTL_TCP.END_OF_INPUT THEN
832: x_return_status := FND_API.G_RET_STS_ERROR;
833: x_return_status_text := 'UTL_TCP.END_OF_INPUT';
834: IF l_debug = FND_API.G_TRUE THEN
835: QP_PREQ_GRP.engine_debug('HTTP request failed because of UTL_TCP.END_OF_INPUT');
836: END IF;
837: WHEN MAX_STATUS_REQUESTS_REACHED THEN
831: WHEN UTL_TCP.END_OF_INPUT THEN
832: x_return_status := FND_API.G_RET_STS_ERROR;
833: x_return_status_text := 'UTL_TCP.END_OF_INPUT';
834: IF l_debug = FND_API.G_TRUE THEN
835: QP_PREQ_GRP.engine_debug('HTTP request failed because of UTL_TCP.END_OF_INPUT');
836: END IF;
837: WHEN MAX_STATUS_REQUESTS_REACHED THEN
838: x_return_status := FND_API.G_RET_STS_ERROR;
839: FND_MESSAGE.SET_NAME('QP','QP_JPE_REQUEST_TIMEOUT_ERROR');