DBA Data[Home] [Help]

APPS.QP_JAVA_ENGINE_UTIL_PUB dependencies on UTL_TCP

Line 372: WHEN UTL_TCP.END_OF_INPUT THEN

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

Line 374: x_return_status_text := '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

Line 376: QP_PREQ_GRP.engine_debug('HTTP request failed because of UTL_TCP.END_OF_INPUT');

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;

Line 506: IF (x_return_status_text = 'UTL_TCP.END_OF_INPUT' or instr(x_return_status_text, 'ORA-29276') <> 0) THEN

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

Line 524: IF (x_return_status_text <> 'UTL_TCP.END_OF_INPUT' and instr(x_return_status_text, 'ORA-29276') = 0) THEN

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,

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

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;

Line 610: WHEN UTL_TCP.END_OF_INPUT THEN

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

Line 612: x_return_status_text := '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

Line 614: QP_PREQ_GRP.engine_debug('HTTP request failed because of UTL_TCP.END_OF_INPUT');

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

Line 831: WHEN UTL_TCP.END_OF_INPUT THEN

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

Line 833: x_return_status_text := '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

Line 835: QP_PREQ_GRP.engine_debug('HTTP request failed because of UTL_TCP.END_OF_INPUT');

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