eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_JAVA_ENGINE_UTIL_PUB dependencies on UTL_HTTP

Line 158: x_return_details OUT NOCOPY UTL_HTTP.HTML_PIECES)

154:
155: PROCEDURE Interprete_Response_Text(response_text IN VARCHAR2,
156: x_return_status OUT NOCOPY VARCHAR2,
157: x_return_status_text OUT NOCOPY VARCHAR2,
158: x_return_details OUT NOCOPY UTL_HTTP.HTML_PIECES)
159: is
160: l_debug VARCHAR2(3);
161: l_routine VARCHAR2(240):='Routine:QP_JAVA_ENGINE_UTIL_PUB.Interprete_Response_Text';
162: l_a number;

Line 207: FND_MESSAGE.SET_NAME('QP','QP_JPE_UTL_HTTP_STR_ERROR');

203: END IF;
204: EXCEPTION
205: WHEN OTHERS THEN
206: x_return_status := FND_API.G_RET_STS_ERROR;
207: FND_MESSAGE.SET_NAME('QP','QP_JPE_UTL_HTTP_STR_ERROR');
208: x_return_status_text := FND_MESSAGE.get;
209: --x_return_status_text := 'utl_http return string parsing error.';
210: END;
211:

Line 209: --x_return_status_text := 'utl_http return string parsing error.';

205: WHEN OTHERS THEN
206: x_return_status := FND_API.G_RET_STS_ERROR;
207: FND_MESSAGE.SET_NAME('QP','QP_JPE_UTL_HTTP_STR_ERROR');
208: x_return_status_text := FND_MESSAGE.get;
209: --x_return_status_text := 'utl_http return string parsing error.';
210: END;
211:
212: IF x_return_status IS NULL THEN
213: x_return_status := FND_API.G_RET_STS_ERROR;

Line 222: PROCEDURE Interprete_Response_Text(p_response_pieces IN UTL_HTTP.HTML_PIECES,

218: END IF;
219: END IF;
220: END;
221:
222: PROCEDURE Interprete_Response_Text(p_response_pieces IN UTL_HTTP.HTML_PIECES,
223: x_return_status OUT NOCOPY VARCHAR2,
224: x_return_status_text OUT NOCOPY VARCHAR2,
225: x_return_details OUT NOCOPY UTL_HTTP.HTML_PIECES)
226: is

Line 225: x_return_details OUT NOCOPY UTL_HTTP.HTML_PIECES)

221:
222: PROCEDURE Interprete_Response_Text(p_response_pieces IN UTL_HTTP.HTML_PIECES,
223: x_return_status OUT NOCOPY VARCHAR2,
224: x_return_status_text OUT NOCOPY VARCHAR2,
225: x_return_details OUT NOCOPY UTL_HTTP.HTML_PIECES)
226: is
227: BEGIN
228: Interprete_Response_Text(p_response_pieces(1),
229: x_return_status,

Line 240: FND_MESSAGE.SET_NAME('QP','QP_JPE_UTL_HTTP_STR_ERROR');

236: END IF;
237: EXCEPTION
238: WHEN OTHERS THEN
239: x_return_status := FND_API.G_RET_STS_ERROR;
240: FND_MESSAGE.SET_NAME('QP','QP_JPE_UTL_HTTP_STR_ERROR');
241: x_return_status_text := FND_MESSAGE.get;
242: --x_return_status_text := 'utl_http detail string parsing error.';
243: END;
244:

Line 242: --x_return_status_text := 'utl_http detail string parsing error.';

238: WHEN OTHERS THEN
239: x_return_status := FND_API.G_RET_STS_ERROR;
240: FND_MESSAGE.SET_NAME('QP','QP_JPE_UTL_HTTP_STR_ERROR');
241: x_return_status_text := FND_MESSAGE.get;
242: --x_return_status_text := 'utl_http detail string parsing error.';
243: END;
244:
245: FUNCTION is_SSL_Enabled(p_url_string IN VARCHAR2)
246: RETURN VARCHAR2

Line 256: PROCEDURE UTL_HTTP_REQUEST(p_url_string IN VARCHAR2,

252: RETURN 'N';
253: END IF;
254: END;
255:
256: PROCEDURE UTL_HTTP_REQUEST(p_url_string IN VARCHAR2,
257: x_return_status OUT NOCOPY VARCHAR2,
258: x_return_status_text OUT NOCOPY VARCHAR2,
259: x_return_details OUT NOCOPY UTL_HTTP.HTML_PIECES,
260: p_use_request_pieces IN BOOLEAN DEFAULT FALSE)

Line 259: x_return_details OUT NOCOPY UTL_HTTP.HTML_PIECES,

255:
256: PROCEDURE UTL_HTTP_REQUEST(p_url_string IN VARCHAR2,
257: x_return_status OUT NOCOPY VARCHAR2,
258: x_return_status_text OUT NOCOPY VARCHAR2,
259: x_return_details OUT NOCOPY UTL_HTTP.HTML_PIECES,
260: p_use_request_pieces IN BOOLEAN DEFAULT FALSE)
261: IS
262: url_str VARCHAR2(32767);
263: l_debug varchar2(3);

Line 264: l_routine VARCHAR2(240):='Routine:QP_JAVA_ENGINE_UTIL_PUB.UTL_HTTP_REQUEST';

260: p_use_request_pieces IN BOOLEAN DEFAULT FALSE)
261: IS
262: url_str VARCHAR2(32767);
263: l_debug varchar2(3);
264: l_routine VARCHAR2(240):='Routine:QP_JAVA_ENGINE_UTIL_PUB.UTL_HTTP_REQUEST';
265: pieces UTL_HTTP.HTML_PIECES;
266: BEGIN
267: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
268:

Line 265: pieces UTL_HTTP.HTML_PIECES;

261: IS
262: url_str VARCHAR2(32767);
263: l_debug varchar2(3);
264: l_routine VARCHAR2(240):='Routine:QP_JAVA_ENGINE_UTIL_PUB.UTL_HTTP_REQUEST';
265: pieces UTL_HTTP.HTML_PIECES;
266: BEGIN
267: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
268:
269: /*HTTP Get Request from Java Engine*/

Line 287: pieces := UTL_HTTP.Request_Pieces(url => p_url_string,

283: QP_PREQ_GRP.engine_debug('wallet_path:'||G_WALLET_PATH||' wallet_password:'||G_WALLET_PASSWORD);
284: QP_PREQ_GRP.engine_debug('proxy server:'||G_PROXY_SERVER);
285: END IF;
286: IF p_use_request_pieces THEN
287: pieces := UTL_HTTP.Request_Pieces(url => p_url_string,
288: proxy => G_PROXY_SERVER,
289: wallet_path => G_WALLET_PATH,
290: wallet_password => G_WALLET_PASSWORD);
291: ELSE

Line 292: url_str := UTL_HTTP.Request(p_url_string, G_PROXY_SERVER, G_WALLET_PATH, G_WALLET_PASSWORD);

288: proxy => G_PROXY_SERVER,
289: wallet_path => G_WALLET_PATH,
290: wallet_password => G_WALLET_PASSWORD);
291: ELSE
292: url_str := UTL_HTTP.Request(p_url_string, G_PROXY_SERVER, G_WALLET_PATH, G_WALLET_PASSWORD);
293: END IF;
294: ELSE
295: IF l_debug = FND_API.G_TRUE THEN
296: QP_PREQ_GRP.engine_debug('SSL is disabled.');

Line 304: pieces := UTL_HTTP.Request_Pieces(url => p_url_string,

300: IF l_debug = FND_API.G_TRUE THEN
301: QP_PREQ_GRP.engine_debug('proxy server:'||G_PROXY_SERVER);
302: END IF;
303: IF p_use_request_pieces THEN
304: pieces := UTL_HTTP.Request_Pieces(url => p_url_string,
305: proxy => G_PROXY_SERVER);
306: ELSE
307: url_str := UTL_HTTP.Request(p_url_string, G_PROXY_SERVER);
308: END IF;

Line 307: url_str := UTL_HTTP.Request(p_url_string, G_PROXY_SERVER);

303: IF p_use_request_pieces THEN
304: pieces := UTL_HTTP.Request_Pieces(url => p_url_string,
305: proxy => G_PROXY_SERVER);
306: ELSE
307: url_str := UTL_HTTP.Request(p_url_string, G_PROXY_SERVER);
308: END IF;
309: ELSE
310: IF p_use_request_pieces THEN
311: pieces := UTL_HTTP.Request_Pieces(url => p_url_string);

Line 311: pieces := UTL_HTTP.Request_Pieces(url => p_url_string);

307: url_str := UTL_HTTP.Request(p_url_string, G_PROXY_SERVER);
308: END IF;
309: ELSE
310: IF p_use_request_pieces THEN
311: pieces := UTL_HTTP.Request_Pieces(url => p_url_string);
312: ELSE
313: url_str := UTL_HTTP.Request(p_url_string);
314: END IF;
315: END IF;

Line 313: url_str := UTL_HTTP.Request(p_url_string);

309: ELSE
310: IF p_use_request_pieces THEN
311: pieces := UTL_HTTP.Request_Pieces(url => p_url_string);
312: ELSE
313: url_str := UTL_HTTP.Request(p_url_string);
314: END IF;
315: END IF;
316: END IF;
317:

Line 320: QP_PREQ_GRP.engine_debug('utl_http_request response:'||url_str);

316: END IF;
317:
318: IF l_debug = FND_API.G_TRUE THEN
319: QP_PREQ_GRP.engine_debug('response length: '||length(url_str));
320: QP_PREQ_GRP.engine_debug('utl_http_request response:'||url_str);
321: END IF;
322:
323: IF p_use_request_pieces THEN
324: Interprete_Response_Text(pieces, x_return_status, x_return_status_text, x_return_details);

Line 333: WHEN UTL_HTTP.INIT_FAILED THEN

329: IF l_debug = FND_API.G_TRUE THEN
330: QP_PREQ_GRP.engine_debug('after Interprete_Response_Text: x_return_status='||x_return_status||' x_return_status_text='||x_return_status_text);
331: END IF;
332: EXCEPTION
333: WHEN UTL_HTTP.INIT_FAILED THEN
334: BEGIN
335: --EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlcode from dual' INTO x_return_status;
336: --x_return_status_text := 'UTL_HTTP INIT_FAILED exception with errorcode:'||UTL_HTTP.get_detailed_sqlcode||' errormessage:'||UTL_HTTP.get_detailed_sqlerrm;
337: x_return_status := FND_API.G_RET_STS_ERROR;

Line 335: --EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlcode from dual' INTO x_return_status;

331: END IF;
332: EXCEPTION
333: WHEN UTL_HTTP.INIT_FAILED THEN
334: BEGIN
335: --EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlcode from dual' INTO x_return_status;
336: --x_return_status_text := 'UTL_HTTP INIT_FAILED exception with errorcode:'||UTL_HTTP.get_detailed_sqlcode||' errormessage:'||UTL_HTTP.get_detailed_sqlerrm;
337: x_return_status := FND_API.G_RET_STS_ERROR;
338: EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlerrm from dual' INTO x_return_status_text;
339:

Line 336: --x_return_status_text := 'UTL_HTTP INIT_FAILED exception with errorcode:'||UTL_HTTP.get_detailed_sqlcode||' errormessage:'||UTL_HTTP.get_detailed_sqlerrm;

332: EXCEPTION
333: WHEN UTL_HTTP.INIT_FAILED THEN
334: BEGIN
335: --EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlcode from dual' INTO x_return_status;
336: --x_return_status_text := 'UTL_HTTP INIT_FAILED exception with errorcode:'||UTL_HTTP.get_detailed_sqlcode||' errormessage:'||UTL_HTTP.get_detailed_sqlerrm;
337: x_return_status := FND_API.G_RET_STS_ERROR;
338: EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlerrm from dual' INTO x_return_status_text;
339:
340: IF l_debug = FND_API.G_TRUE THEN

Line 338: EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlerrm from dual' INTO x_return_status_text;

334: BEGIN
335: --EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlcode from dual' INTO x_return_status;
336: --x_return_status_text := 'UTL_HTTP INIT_FAILED exception with errorcode:'||UTL_HTTP.get_detailed_sqlcode||' errormessage:'||UTL_HTTP.get_detailed_sqlerrm;
337: x_return_status := FND_API.G_RET_STS_ERROR;
338: EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlerrm from dual' INTO x_return_status_text;
339:
340: IF l_debug = FND_API.G_TRUE THEN
341: QP_PREQ_GRP.engine_debug('HTTP request failed because of UTL_HTTP_INIT_FAILED');
342: QP_PREQ_GRP.engine_debug('x_return_status='||x_return_status||' x_return_status_text='||x_return_status_text);

Line 341: QP_PREQ_GRP.engine_debug('HTTP request failed because of UTL_HTTP_INIT_FAILED');

337: x_return_status := FND_API.G_RET_STS_ERROR;
338: EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlerrm from dual' INTO x_return_status_text;
339:
340: IF l_debug = FND_API.G_TRUE THEN
341: QP_PREQ_GRP.engine_debug('HTTP request failed because of UTL_HTTP_INIT_FAILED');
342: QP_PREQ_GRP.engine_debug('x_return_status='||x_return_status||' x_return_status_text='||x_return_status_text);
343: END IF;
344: EXCEPTION
345: WHEN OTHERS THEN

Line 354: WHEN UTL_HTTP.REQUEST_FAILED THEN

350: IF l_debug = FND_API.G_TRUE THEN
351: QP_PREQ_GRP.engine_debug('HTTP request failed unexpectedly!' );
352: END IF;
353: END;
354: WHEN UTL_HTTP.REQUEST_FAILED THEN
355: x_return_status := FND_API.G_RET_STS_ERROR;
356: --x_return_status_text := 'UTL_HTTP.REQUEST_FAILED';
357: IF l_debug = FND_API.G_TRUE THEN
358: QP_PREQ_GRP.engine_debug('HTTP request failed because of UTL HTTP REQUEST_FAILED'||x_return_status_text);

Line 356: --x_return_status_text := 'UTL_HTTP.REQUEST_FAILED';

352: END IF;
353: END;
354: WHEN UTL_HTTP.REQUEST_FAILED THEN
355: x_return_status := FND_API.G_RET_STS_ERROR;
356: --x_return_status_text := 'UTL_HTTP.REQUEST_FAILED';
357: IF l_debug = FND_API.G_TRUE THEN
358: QP_PREQ_GRP.engine_debug('HTTP request failed because of UTL HTTP REQUEST_FAILED'||x_return_status_text);
359: END IF;
360: BEGIN

Line 358: QP_PREQ_GRP.engine_debug('HTTP request failed because of UTL HTTP REQUEST_FAILED'||x_return_status_text);

354: WHEN UTL_HTTP.REQUEST_FAILED THEN
355: x_return_status := FND_API.G_RET_STS_ERROR;
356: --x_return_status_text := 'UTL_HTTP.REQUEST_FAILED';
357: IF l_debug = FND_API.G_TRUE THEN
358: QP_PREQ_GRP.engine_debug('HTTP request failed because of UTL HTTP REQUEST_FAILED'||x_return_status_text);
359: END IF;
360: BEGIN
361: x_return_status := FND_API.G_RET_STS_ERROR;
362: EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlerrm from dual' INTO x_return_status_text;

Line 362: EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlerrm from dual' INTO x_return_status_text;

358: QP_PREQ_GRP.engine_debug('HTTP request failed because of UTL HTTP REQUEST_FAILED'||x_return_status_text);
359: END IF;
360: BEGIN
361: x_return_status := FND_API.G_RET_STS_ERROR;
362: EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlerrm from dual' INTO x_return_status_text;
363:
364: IF l_debug = FND_API.G_TRUE THEN
365: QP_PREQ_GRP.engine_debug('x_return_status='||x_return_status||' x_return_status_text='||x_return_status_text);
366: END IF;

Line 370: x_return_status_text := 'UTL_HTTP REQUEST_FAILED exception';

366: END IF;
367: EXCEPTION
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';

Line 380: --EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlcode from dual' INTO x_return_status;

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;
381: x_return_status := FND_API.G_RET_STS_ERROR;
382: EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlerrm from dual' INTO x_return_status_text;
383:
384: IF l_debug = FND_API.G_TRUE THEN

Line 382: EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlerrm from dual' INTO x_return_status_text;

378: WHEN OTHERS THEN
379: BEGIN
380: --EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlcode from dual' INTO x_return_status;
381: x_return_status := FND_API.G_RET_STS_ERROR;
382: EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlerrm from dual' INTO x_return_status_text;
383:
384: IF l_debug = FND_API.G_TRUE THEN
385: QP_PREQ_GRP.engine_debug('x_return_status='||x_return_status||' x_return_status_text='||x_return_status_text);
386: END IF;

Line 402: x_return_details OUT NOCOPY UTL_HTTP.HTML_PIECES,

398:
399: PROCEDURE Send_Java_Engine_Request (p_url_param_string IN VARCHAR2,
400: x_return_status OUT NOCOPY VARCHAR2,
401: x_return_status_text OUT NOCOPY VARCHAR2,
402: x_return_details OUT NOCOPY UTL_HTTP.HTML_PIECES,
403: p_use_request_pieces IN BOOLEAN,
404: p_transfer_timeout IN NUMBER,
405: p_detailed_excp_support IN VARCHAR2,
406: p_timeout_processing IN VARCHAR2)

Line 466: QP_PREQ_GRP.engine_debug('before UTL_HTTP.Request, the url string:'||l_engine_server_url||'?'||l_ctxt_str||'&'||p_url_param_string);

462: /*Construct request parameter string ContextConfig*/
463: l_ctxt_str := Get_Context_Params;
464:
465: IF l_debug = FND_API.G_TRUE THEN
466: QP_PREQ_GRP.engine_debug('before UTL_HTTP.Request, the url string:'||l_engine_server_url||'?'||l_ctxt_str||'&'||p_url_param_string);
467: END IF;
468:
469: /*Defaulting transfer timeout to transferTimeout specified by profile*/
470: IF p_transfer_timeout = -1 THEN

Line 479: QP_PREQ_GRP.engine_debug('set utl_http transfer_timeout to '||l_transfer_timeout);

475:
476: /*Set transfer timeout, default is 60s in 9i database*/
477: IF(l_transfer_timeout IS NOT NULL AND defaultTimeout IS NOT NULL AND l_transfer_timeout <> defaultTimeout)THEN
478: IF l_debug = FND_API.G_TRUE THEN
479: QP_PREQ_GRP.engine_debug('set utl_http transfer_timeout to '||l_transfer_timeout);
480: END IF;
481: EXECUTE IMMEDIATE 'BEGIN UTL_HTTP.Set_Transfer_Timeout(:1); END;' USING IN l_transfer_timeout;
482: END IF;
483:

Line 481: EXECUTE IMMEDIATE 'BEGIN UTL_HTTP.Set_Transfer_Timeout(:1); END;' USING IN l_transfer_timeout;

477: IF(l_transfer_timeout IS NOT NULL AND defaultTimeout IS NOT NULL AND l_transfer_timeout <> defaultTimeout)THEN
478: IF l_debug = FND_API.G_TRUE THEN
479: QP_PREQ_GRP.engine_debug('set utl_http transfer_timeout to '||l_transfer_timeout);
480: END IF;
481: EXECUTE IMMEDIATE 'BEGIN UTL_HTTP.Set_Transfer_Timeout(:1); END;' USING IN l_transfer_timeout;
482: END IF;
483:
484: /*Added for catch more detailed error when UTL_HTTP errored out*/
485: IF l_detailed_excp_support = FND_API.G_TRUE THEN

Line 484: /Added for catch more detailed error when UTL_HTTP errored out/

480: END IF;
481: EXECUTE IMMEDIATE 'BEGIN UTL_HTTP.Set_Transfer_Timeout(:1); END;' USING IN l_transfer_timeout;
482: END IF;
483:
484: /*Added for catch more detailed error when UTL_HTTP errored out*/
485: IF l_detailed_excp_support = FND_API.G_TRUE THEN
486: IF l_debug = FND_API.G_TRUE THEN
487: QP_PREQ_GRP.engine_debug('set utl_http set_detailed_excp_support(true)');
488: END IF;

Line 487: QP_PREQ_GRP.engine_debug('set utl_http set_detailed_excp_support(true)');

483:
484: /*Added for catch more detailed error when UTL_HTTP errored out*/
485: IF l_detailed_excp_support = FND_API.G_TRUE THEN
486: IF l_debug = FND_API.G_TRUE THEN
487: QP_PREQ_GRP.engine_debug('set utl_http set_detailed_excp_support(true)');
488: END IF;
489: EXECUTE IMMEDIATE 'BEGIN UTL_HTTP.set_detailed_excp_support(TRUE); END;';
490: END IF;
491:

Line 489: EXECUTE IMMEDIATE 'BEGIN UTL_HTTP.set_detailed_excp_support(TRUE); END;';

485: IF l_detailed_excp_support = FND_API.G_TRUE THEN
486: IF l_debug = FND_API.G_TRUE THEN
487: QP_PREQ_GRP.engine_debug('set utl_http set_detailed_excp_support(true)');
488: END IF;
489: EXECUTE IMMEDIATE 'BEGIN UTL_HTTP.set_detailed_excp_support(TRUE); END;';
490: END IF;
491:
492: /*HTTP Get Request from Java Engine*/
493: UTL_HTTP_REQUEST(l_engine_server_url||'?'||l_ctxt_str||'&'||p_url_param_string,

Line 493: UTL_HTTP_REQUEST(l_engine_server_url||'?'||l_ctxt_str||'&'||p_url_param_string,

489: EXECUTE IMMEDIATE 'BEGIN UTL_HTTP.set_detailed_excp_support(TRUE); END;';
490: END IF;
491:
492: /*HTTP Get Request from Java Engine*/
493: UTL_HTTP_REQUEST(l_engine_server_url||'?'||l_ctxt_str||'&'||p_url_param_string,
494: x_return_status,
495: x_return_status_text,
496: x_return_details,
497: p_use_request_pieces);

Line 505: /UTL_HTTP_TRANSFER Timeout and HTTP Timeout issue handling/

501: END IF;
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

Line 514: UTL_HTTP_REQUEST(l_engine_server_url||'?'||l_ctxt_str||G_HARD_CHAR||'Action=inquery'|| G_HARD_CHAR||'RequestId='|| QP_Price_Request_Context.GET_REQUEST_ID,

510: QP_PREQ_GRP.engine_debug('sleeping........'||G_STATUS_REQUEST_INTERVAL||'(secs)');
511: END IF;
512: DBMS_LOCK.SLEEP(G_STATUS_REQUEST_INTERVAL);
513:
514: UTL_HTTP_REQUEST(l_engine_server_url||'?'||l_ctxt_str||G_HARD_CHAR||'Action=inquery'|| G_HARD_CHAR||'RequestId='|| QP_Price_Request_Context.GET_REQUEST_ID,
515: x_return_status,
516: x_return_status_text,
517: x_return_details);
518:

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

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,
529: l_return_status_text,
530: x_return_details,

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

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,
529: l_return_status_text,
530: x_return_details,
531: p_use_request_pieces);

Line 551: --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);

547: END IF;
548:
549: ELSE
550: /*other errors than timeout error, send request to remove mid-tier status */
551: --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);
552: 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,
553: l_return_status_code,
554: l_return_status_text,
555: x_return_details,

Line 552: 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,

548:
549: ELSE
550: /*other errors than timeout error, send request to remove mid-tier status */
551: --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);
552: 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,
553: l_return_status_code,
554: l_return_status_text,
555: x_return_details,
556: p_use_request_pieces);

Line 565: QP_PREQ_GRP.engine_debug('set utl_http transfer_timeout back to '||defaultTimeout);

561:
562: /*Set transfer timeout back to default value, default is 60s in 9i database*/
563: IF(l_transfer_timeout IS NOT NULL AND defaultTimeout IS NOT NULL AND l_transfer_timeout <> defaultTimeout)THEN
564: IF l_debug = FND_API.G_TRUE THEN
565: QP_PREQ_GRP.engine_debug('set utl_http transfer_timeout back to '||defaultTimeout);
566: END IF;
567: EXECUTE IMMEDIATE 'BEGIN UTL_HTTP.Set_Transfer_Timeout(:1); END;' USING IN defaultTimeout;
568: END IF;
569:

Line 567: EXECUTE IMMEDIATE 'BEGIN UTL_HTTP.Set_Transfer_Timeout(:1); END;' USING IN defaultTimeout;

563: IF(l_transfer_timeout IS NOT NULL AND defaultTimeout IS NOT NULL AND l_transfer_timeout <> defaultTimeout)THEN
564: IF l_debug = FND_API.G_TRUE THEN
565: QP_PREQ_GRP.engine_debug('set utl_http transfer_timeout back to '||defaultTimeout);
566: END IF;
567: EXECUTE IMMEDIATE 'BEGIN UTL_HTTP.Set_Transfer_Timeout(:1); END;' USING IN defaultTimeout;
568: END IF;
569:
570: /*Added for catch more detailed error when UTL_HTTP errored out*/
571: IF l_detailed_excp_support = FND_API.G_TRUE THEN

Line 570: /Added for catch more detailed error when UTL_HTTP errored out/

566: END IF;
567: EXECUTE IMMEDIATE 'BEGIN UTL_HTTP.Set_Transfer_Timeout(:1); END;' USING IN defaultTimeout;
568: END IF;
569:
570: /*Added for catch more detailed error when UTL_HTTP errored out*/
571: IF l_detailed_excp_support = FND_API.G_TRUE THEN
572: IF l_debug = FND_API.G_TRUE THEN
573: QP_PREQ_GRP.engine_debug('set utl_http set_detailed_excp_support(false)');
574: END IF;

Line 573: QP_PREQ_GRP.engine_debug('set utl_http set_detailed_excp_support(false)');

569:
570: /*Added for catch more detailed error when UTL_HTTP errored out*/
571: IF l_detailed_excp_support = FND_API.G_TRUE THEN
572: IF l_debug = FND_API.G_TRUE THEN
573: QP_PREQ_GRP.engine_debug('set utl_http set_detailed_excp_support(false)');
574: END IF;
575: EXECUTE IMMEDIATE 'BEGIN UTL_HTTP.set_detailed_excp_support(FALSE); END;';
576: END IF;
577:

Line 575: EXECUTE IMMEDIATE 'BEGIN UTL_HTTP.set_detailed_excp_support(FALSE); END;';

571: IF l_detailed_excp_support = FND_API.G_TRUE THEN
572: IF l_debug = FND_API.G_TRUE THEN
573: QP_PREQ_GRP.engine_debug('set utl_http set_detailed_excp_support(false)');
574: END IF;
575: EXECUTE IMMEDIATE 'BEGIN UTL_HTTP.set_detailed_excp_support(FALSE); END;';
576: END IF;
577:
578: IF l_debug = FND_API.G_TRUE THEN
579: l_pricing_end_time := dbms_utility.get_time;

Line 584: WHEN UTL_HTTP.INIT_FAILED THEN

580: QP_PREQ_GRP.engine_debug('Request total time: '||(l_pricing_end_time - l_pricing_start_time)/100);
581: END IF;
582:
583: EXCEPTION
584: WHEN UTL_HTTP.INIT_FAILED THEN
585: x_return_status := FND_API.G_RET_STS_ERROR;
586: --x_return_status_text := 'UTL_HTTP INIT_FAILED exception with errorcode:'||UTL_HTTP.get_detailed_sqlcode||' errormessage:'||UTL_HTTP.get_detailed_sqlerrm ;
587: x_return_status_text := 'UTL_HTTP.INIT_FAILED';
588: IF l_debug = FND_API.G_TRUE THEN

Line 586: --x_return_status_text := 'UTL_HTTP INIT_FAILED exception with errorcode:'||UTL_HTTP.get_detailed_sqlcode||' errormessage:'||UTL_HTTP.get_detailed_sqlerrm ;

582:
583: EXCEPTION
584: WHEN UTL_HTTP.INIT_FAILED THEN
585: x_return_status := FND_API.G_RET_STS_ERROR;
586: --x_return_status_text := 'UTL_HTTP INIT_FAILED exception with errorcode:'||UTL_HTTP.get_detailed_sqlcode||' errormessage:'||UTL_HTTP.get_detailed_sqlerrm ;
587: x_return_status_text := 'UTL_HTTP.INIT_FAILED';
588: IF l_debug = FND_API.G_TRUE THEN
589: QP_PREQ_GRP.engine_debug('HTTP request failed because of UTL_HTTP_INIT_FAILED');
590: END IF;

Line 587: x_return_status_text := 'UTL_HTTP.INIT_FAILED';

583: EXCEPTION
584: WHEN UTL_HTTP.INIT_FAILED THEN
585: x_return_status := FND_API.G_RET_STS_ERROR;
586: --x_return_status_text := 'UTL_HTTP INIT_FAILED exception with errorcode:'||UTL_HTTP.get_detailed_sqlcode||' errormessage:'||UTL_HTTP.get_detailed_sqlerrm ;
587: x_return_status_text := 'UTL_HTTP.INIT_FAILED';
588: IF l_debug = FND_API.G_TRUE THEN
589: QP_PREQ_GRP.engine_debug('HTTP request failed because of UTL_HTTP_INIT_FAILED');
590: END IF;
591: WHEN UTL_HTTP.REQUEST_FAILED THEN

Line 589: QP_PREQ_GRP.engine_debug('HTTP request failed because of UTL_HTTP_INIT_FAILED');

585: x_return_status := FND_API.G_RET_STS_ERROR;
586: --x_return_status_text := 'UTL_HTTP INIT_FAILED exception with errorcode:'||UTL_HTTP.get_detailed_sqlcode||' errormessage:'||UTL_HTTP.get_detailed_sqlerrm ;
587: x_return_status_text := 'UTL_HTTP.INIT_FAILED';
588: IF l_debug = FND_API.G_TRUE THEN
589: QP_PREQ_GRP.engine_debug('HTTP request failed because of UTL_HTTP_INIT_FAILED');
590: END IF;
591: WHEN UTL_HTTP.REQUEST_FAILED THEN
592: x_return_status := FND_API.G_RET_STS_ERROR;
593: x_return_status_text := 'UTL_HTTP.REQUEST_FAILED';

Line 591: WHEN UTL_HTTP.REQUEST_FAILED THEN

587: x_return_status_text := 'UTL_HTTP.INIT_FAILED';
588: IF l_debug = FND_API.G_TRUE THEN
589: QP_PREQ_GRP.engine_debug('HTTP request failed because of UTL_HTTP_INIT_FAILED');
590: END IF;
591: WHEN UTL_HTTP.REQUEST_FAILED THEN
592: x_return_status := FND_API.G_RET_STS_ERROR;
593: x_return_status_text := 'UTL_HTTP.REQUEST_FAILED';
594: IF l_debug = FND_API.G_TRUE THEN
595: QP_PREQ_GRP.engine_debug('HTTP request failed because of UTL HTTP REQUEST_FAILED'||x_return_status_text);

Line 593: x_return_status_text := 'UTL_HTTP.REQUEST_FAILED';

589: QP_PREQ_GRP.engine_debug('HTTP request failed because of UTL_HTTP_INIT_FAILED');
590: END IF;
591: WHEN UTL_HTTP.REQUEST_FAILED THEN
592: x_return_status := FND_API.G_RET_STS_ERROR;
593: x_return_status_text := 'UTL_HTTP.REQUEST_FAILED';
594: IF l_debug = FND_API.G_TRUE THEN
595: QP_PREQ_GRP.engine_debug('HTTP request failed because of UTL HTTP REQUEST_FAILED'||x_return_status_text);
596: END IF;
597: BEGIN

Line 595: QP_PREQ_GRP.engine_debug('HTTP request failed because of UTL HTTP REQUEST_FAILED'||x_return_status_text);

591: WHEN UTL_HTTP.REQUEST_FAILED THEN
592: x_return_status := FND_API.G_RET_STS_ERROR;
593: x_return_status_text := 'UTL_HTTP.REQUEST_FAILED';
594: IF l_debug = FND_API.G_TRUE THEN
595: QP_PREQ_GRP.engine_debug('HTTP request failed because of UTL HTTP REQUEST_FAILED'||x_return_status_text);
596: END IF;
597: BEGIN
598: --EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlcode from dual' INTO x_return_status;
599: x_return_status := FND_API.G_RET_STS_ERROR;

Line 598: --EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlcode from dual' INTO x_return_status;

594: IF l_debug = FND_API.G_TRUE THEN
595: QP_PREQ_GRP.engine_debug('HTTP request failed because of UTL HTTP REQUEST_FAILED'||x_return_status_text);
596: END IF;
597: BEGIN
598: --EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlcode from dual' INTO x_return_status;
599: x_return_status := FND_API.G_RET_STS_ERROR;
600: EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlerrm from dual' INTO x_return_status_text;
601:
602: IF l_debug = FND_API.G_TRUE THEN

Line 600: EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlerrm from dual' INTO x_return_status_text;

596: END IF;
597: BEGIN
598: --EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlcode from dual' INTO x_return_status;
599: x_return_status := FND_API.G_RET_STS_ERROR;
600: EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlerrm from dual' INTO x_return_status_text;
601:
602: IF l_debug = FND_API.G_TRUE THEN
603: QP_PREQ_GRP.engine_debug('x_return_status='||x_return_status||' x_return_status_text='||x_return_status_text);
604: END IF;

Line 608: x_return_status_text := 'UTL_HTTP REQUEST_FAILED exception';

604: END IF;
605: EXCEPTION
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';

Line 638: --EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlcode from dual' INTO x_return_status;

634: END IF;
635: x_return_status := FND_API.G_RET_STS_ERROR;
636: WHEN OTHERS THEN
637: BEGIN
638: --EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlcode from dual' INTO x_return_status;
639: x_return_status := FND_API.G_RET_STS_ERROR;
640: EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlerrm from dual' INTO x_return_status_text;
641:
642: IF l_debug = FND_API.G_TRUE THEN

Line 640: EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlerrm from dual' INTO x_return_status_text;

636: WHEN OTHERS THEN
637: BEGIN
638: --EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlcode from dual' INTO x_return_status;
639: x_return_status := FND_API.G_RET_STS_ERROR;
640: EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlerrm from dual' INTO x_return_status_text;
641:
642: IF l_debug = FND_API.G_TRUE THEN
643: QP_PREQ_GRP.engine_debug('x_return_status='||x_return_status||' x_return_status_text='||x_return_status_text);
644: END IF;

Line 665: l_dummy_return_details UTL_HTTP.HTML_PIECES;

661: p_transfer_timeout IN NUMBER,
662: p_detailed_excp_support IN VARCHAR2,
663: p_timeout_processing IN VARCHAR2)
664: is
665: l_dummy_return_details UTL_HTTP.HTML_PIECES;
666: BEGIN
667:
668: Send_Java_Engine_Request(p_url_param_string,
669: x_return_status,

Line 683: x_return_details OUT NOCOPY UTL_HTTP.HTML_PIECES,

679: PROCEDURE Send_Java_Request (p_server_url IN VARCHAR2,
680: p_url_param_string IN VARCHAR2,
681: x_return_status OUT NOCOPY VARCHAR2,
682: x_return_status_text OUT NOCOPY VARCHAR2,
683: x_return_details OUT NOCOPY UTL_HTTP.HTML_PIECES,
684: p_use_request_pieces IN BOOLEAN,
685: p_transfer_timeout IN NUMBER,
686: p_detailed_excp_support IN VARCHAR2,
687: p_timeout_processing IN VARCHAR2)

Line 746: QP_PREQ_GRP.engine_debug('before UTL_HTTP.Request, the url string:'||p_server_url||'?'||l_ctxt_str||'&'||p_url_param_string);

742: /*Construct request parameter string ContextConfig*/
743: l_ctxt_str := Get_Context_Params;
744:
745: IF l_debug = FND_API.G_TRUE THEN
746: QP_PREQ_GRP.engine_debug('before UTL_HTTP.Request, the url string:'||p_server_url||'?'||l_ctxt_str||'&'||p_url_param_string);
747: END IF;
748:
749: /*Defaulting transfer timeout to transferTimeout specified by profile*/
750: IF p_transfer_timeout = -1 THEN

Line 759: QP_PREQ_GRP.engine_debug('set utl_http transfer_timeout to '||l_transfer_timeout);

755:
756: /*Set transfer timeout, default is 60s in 9i database*/
757: IF(l_transfer_timeout IS NOT NULL AND defaultTimeout IS NOT NULL AND l_transfer_timeout <> defaultTimeout)THEN
758: IF l_debug = FND_API.G_TRUE THEN
759: QP_PREQ_GRP.engine_debug('set utl_http transfer_timeout to '||l_transfer_timeout);
760: END IF;
761: EXECUTE IMMEDIATE 'BEGIN UTL_HTTP.Set_Transfer_Timeout(:1); END;' USING IN l_transfer_timeout;
762: END IF;
763:

Line 761: EXECUTE IMMEDIATE 'BEGIN UTL_HTTP.Set_Transfer_Timeout(:1); END;' USING IN l_transfer_timeout;

757: IF(l_transfer_timeout IS NOT NULL AND defaultTimeout IS NOT NULL AND l_transfer_timeout <> defaultTimeout)THEN
758: IF l_debug = FND_API.G_TRUE THEN
759: QP_PREQ_GRP.engine_debug('set utl_http transfer_timeout to '||l_transfer_timeout);
760: END IF;
761: EXECUTE IMMEDIATE 'BEGIN UTL_HTTP.Set_Transfer_Timeout(:1); END;' USING IN l_transfer_timeout;
762: END IF;
763:
764: /*Added for catch more detailed error when UTL_HTTP errored out*/
765: IF l_detailed_excp_support = FND_API.G_TRUE THEN

Line 764: /Added for catch more detailed error when UTL_HTTP errored out/

760: END IF;
761: EXECUTE IMMEDIATE 'BEGIN UTL_HTTP.Set_Transfer_Timeout(:1); END;' USING IN l_transfer_timeout;
762: END IF;
763:
764: /*Added for catch more detailed error when UTL_HTTP errored out*/
765: IF l_detailed_excp_support = FND_API.G_TRUE THEN
766: IF l_debug = FND_API.G_TRUE THEN
767: QP_PREQ_GRP.engine_debug('set utl_http set_detailed_excp_support(true)');
768: END IF;

Line 767: QP_PREQ_GRP.engine_debug('set utl_http set_detailed_excp_support(true)');

763:
764: /*Added for catch more detailed error when UTL_HTTP errored out*/
765: IF l_detailed_excp_support = FND_API.G_TRUE THEN
766: IF l_debug = FND_API.G_TRUE THEN
767: QP_PREQ_GRP.engine_debug('set utl_http set_detailed_excp_support(true)');
768: END IF;
769: EXECUTE IMMEDIATE 'BEGIN UTL_HTTP.set_detailed_excp_support(TRUE); END;';
770: END IF;
771:

Line 769: EXECUTE IMMEDIATE 'BEGIN UTL_HTTP.set_detailed_excp_support(TRUE); END;';

765: IF l_detailed_excp_support = FND_API.G_TRUE THEN
766: IF l_debug = FND_API.G_TRUE THEN
767: QP_PREQ_GRP.engine_debug('set utl_http set_detailed_excp_support(true)');
768: END IF;
769: EXECUTE IMMEDIATE 'BEGIN UTL_HTTP.set_detailed_excp_support(TRUE); END;';
770: END IF;
771:
772: /*HTTP Get Request from Java Engine*/
773: UTL_HTTP_REQUEST(p_server_url||'?'||l_ctxt_str||'&'||p_url_param_string,

Line 773: UTL_HTTP_REQUEST(p_server_url||'?'||l_ctxt_str||'&'||p_url_param_string,

769: EXECUTE IMMEDIATE 'BEGIN UTL_HTTP.set_detailed_excp_support(TRUE); END;';
770: END IF;
771:
772: /*HTTP Get Request from Java Engine*/
773: UTL_HTTP_REQUEST(p_server_url||'?'||l_ctxt_str||'&'||p_url_param_string,
774: x_return_status,
775: x_return_status_text,
776: x_return_details,
777: p_use_request_pieces);

Line 786: QP_PREQ_GRP.engine_debug('set utl_http transfer_timeout back to '||defaultTimeout);

782:
783: /*Set transfer timeout back to default value, default is 60s in 9i database*/
784: IF(l_transfer_timeout IS NOT NULL AND defaultTimeout IS NOT NULL AND l_transfer_timeout <> defaultTimeout)THEN
785: IF l_debug = FND_API.G_TRUE THEN
786: QP_PREQ_GRP.engine_debug('set utl_http transfer_timeout back to '||defaultTimeout);
787: END IF;
788: EXECUTE IMMEDIATE 'BEGIN UTL_HTTP.Set_Transfer_Timeout(:1); END;' USING IN defaultTimeout;
789: END IF;
790:

Line 788: EXECUTE IMMEDIATE 'BEGIN UTL_HTTP.Set_Transfer_Timeout(:1); END;' USING IN defaultTimeout;

784: IF(l_transfer_timeout IS NOT NULL AND defaultTimeout IS NOT NULL AND l_transfer_timeout <> defaultTimeout)THEN
785: IF l_debug = FND_API.G_TRUE THEN
786: QP_PREQ_GRP.engine_debug('set utl_http transfer_timeout back to '||defaultTimeout);
787: END IF;
788: EXECUTE IMMEDIATE 'BEGIN UTL_HTTP.Set_Transfer_Timeout(:1); END;' USING IN defaultTimeout;
789: END IF;
790:
791: /*Added for catch more detailed error when UTL_HTTP errored out*/
792: IF l_detailed_excp_support = FND_API.G_TRUE THEN

Line 791: /Added for catch more detailed error when UTL_HTTP errored out/

787: END IF;
788: EXECUTE IMMEDIATE 'BEGIN UTL_HTTP.Set_Transfer_Timeout(:1); END;' USING IN defaultTimeout;
789: END IF;
790:
791: /*Added for catch more detailed error when UTL_HTTP errored out*/
792: IF l_detailed_excp_support = FND_API.G_TRUE THEN
793: IF l_debug = FND_API.G_TRUE THEN
794: QP_PREQ_GRP.engine_debug('set utl_http set_detailed_excp_support(false)');
795: END IF;

Line 794: QP_PREQ_GRP.engine_debug('set utl_http set_detailed_excp_support(false)');

790:
791: /*Added for catch more detailed error when UTL_HTTP errored out*/
792: IF l_detailed_excp_support = FND_API.G_TRUE THEN
793: IF l_debug = FND_API.G_TRUE THEN
794: QP_PREQ_GRP.engine_debug('set utl_http set_detailed_excp_support(false)');
795: END IF;
796: EXECUTE IMMEDIATE 'BEGIN UTL_HTTP.set_detailed_excp_support(FALSE); END;';
797: END IF;
798:

Line 796: EXECUTE IMMEDIATE 'BEGIN UTL_HTTP.set_detailed_excp_support(FALSE); END;';

792: IF l_detailed_excp_support = FND_API.G_TRUE THEN
793: IF l_debug = FND_API.G_TRUE THEN
794: QP_PREQ_GRP.engine_debug('set utl_http set_detailed_excp_support(false)');
795: END IF;
796: EXECUTE IMMEDIATE 'BEGIN UTL_HTTP.set_detailed_excp_support(FALSE); END;';
797: END IF;
798:
799: IF l_debug = FND_API.G_TRUE THEN
800: l_pricing_end_time := dbms_utility.get_time;

Line 805: WHEN UTL_HTTP.INIT_FAILED THEN

801: QP_PREQ_GRP.engine_debug('Request total time: '||(l_pricing_end_time - l_pricing_start_time)/100);
802: END IF;
803:
804: EXCEPTION
805: WHEN UTL_HTTP.INIT_FAILED THEN
806: x_return_status := FND_API.G_RET_STS_ERROR;
807: --x_return_status_text := 'UTL_HTTP INIT_FAILED exception with errorcode:'||UTL_HTTP.get_detailed_sqlcode||' errormessage:'||UTL_HTTP.get_detailed_sqlerrm ;
808: x_return_status_text := 'UTL_HTTP.INIT_FAILED';
809: IF l_debug = FND_API.G_TRUE THEN

Line 807: --x_return_status_text := 'UTL_HTTP INIT_FAILED exception with errorcode:'||UTL_HTTP.get_detailed_sqlcode||' errormessage:'||UTL_HTTP.get_detailed_sqlerrm ;

803:
804: EXCEPTION
805: WHEN UTL_HTTP.INIT_FAILED THEN
806: x_return_status := FND_API.G_RET_STS_ERROR;
807: --x_return_status_text := 'UTL_HTTP INIT_FAILED exception with errorcode:'||UTL_HTTP.get_detailed_sqlcode||' errormessage:'||UTL_HTTP.get_detailed_sqlerrm ;
808: x_return_status_text := 'UTL_HTTP.INIT_FAILED';
809: IF l_debug = FND_API.G_TRUE THEN
810: QP_PREQ_GRP.engine_debug('HTTP request failed because of UTL_HTTP_INIT_FAILED');
811: END IF;

Line 808: x_return_status_text := 'UTL_HTTP.INIT_FAILED';

804: EXCEPTION
805: WHEN UTL_HTTP.INIT_FAILED THEN
806: x_return_status := FND_API.G_RET_STS_ERROR;
807: --x_return_status_text := 'UTL_HTTP INIT_FAILED exception with errorcode:'||UTL_HTTP.get_detailed_sqlcode||' errormessage:'||UTL_HTTP.get_detailed_sqlerrm ;
808: x_return_status_text := 'UTL_HTTP.INIT_FAILED';
809: IF l_debug = FND_API.G_TRUE THEN
810: QP_PREQ_GRP.engine_debug('HTTP request failed because of UTL_HTTP_INIT_FAILED');
811: END IF;
812: WHEN UTL_HTTP.REQUEST_FAILED THEN

Line 810: QP_PREQ_GRP.engine_debug('HTTP request failed because of UTL_HTTP_INIT_FAILED');

806: x_return_status := FND_API.G_RET_STS_ERROR;
807: --x_return_status_text := 'UTL_HTTP INIT_FAILED exception with errorcode:'||UTL_HTTP.get_detailed_sqlcode||' errormessage:'||UTL_HTTP.get_detailed_sqlerrm ;
808: x_return_status_text := 'UTL_HTTP.INIT_FAILED';
809: IF l_debug = FND_API.G_TRUE THEN
810: QP_PREQ_GRP.engine_debug('HTTP request failed because of UTL_HTTP_INIT_FAILED');
811: END IF;
812: WHEN UTL_HTTP.REQUEST_FAILED THEN
813: x_return_status := FND_API.G_RET_STS_ERROR;
814: x_return_status_text := 'UTL_HTTP.REQUEST_FAILED';

Line 812: WHEN UTL_HTTP.REQUEST_FAILED THEN

808: x_return_status_text := 'UTL_HTTP.INIT_FAILED';
809: IF l_debug = FND_API.G_TRUE THEN
810: QP_PREQ_GRP.engine_debug('HTTP request failed because of UTL_HTTP_INIT_FAILED');
811: END IF;
812: WHEN UTL_HTTP.REQUEST_FAILED THEN
813: x_return_status := FND_API.G_RET_STS_ERROR;
814: x_return_status_text := 'UTL_HTTP.REQUEST_FAILED';
815: IF l_debug = FND_API.G_TRUE THEN
816: QP_PREQ_GRP.engine_debug('HTTP request failed because of UTL HTTP REQUEST_FAILED'||x_return_status_text);

Line 814: x_return_status_text := 'UTL_HTTP.REQUEST_FAILED';

810: QP_PREQ_GRP.engine_debug('HTTP request failed because of UTL_HTTP_INIT_FAILED');
811: END IF;
812: WHEN UTL_HTTP.REQUEST_FAILED THEN
813: x_return_status := FND_API.G_RET_STS_ERROR;
814: x_return_status_text := 'UTL_HTTP.REQUEST_FAILED';
815: IF l_debug = FND_API.G_TRUE THEN
816: QP_PREQ_GRP.engine_debug('HTTP request failed because of UTL HTTP REQUEST_FAILED'||x_return_status_text);
817: END IF;
818: BEGIN

Line 816: QP_PREQ_GRP.engine_debug('HTTP request failed because of UTL HTTP REQUEST_FAILED'||x_return_status_text);

812: WHEN UTL_HTTP.REQUEST_FAILED THEN
813: x_return_status := FND_API.G_RET_STS_ERROR;
814: x_return_status_text := 'UTL_HTTP.REQUEST_FAILED';
815: IF l_debug = FND_API.G_TRUE THEN
816: QP_PREQ_GRP.engine_debug('HTTP request failed because of UTL HTTP REQUEST_FAILED'||x_return_status_text);
817: END IF;
818: BEGIN
819: --EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlcode from dual' INTO x_return_status;
820: x_return_status := FND_API.G_RET_STS_ERROR;

Line 819: --EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlcode from dual' INTO x_return_status;

815: IF l_debug = FND_API.G_TRUE THEN
816: QP_PREQ_GRP.engine_debug('HTTP request failed because of UTL HTTP REQUEST_FAILED'||x_return_status_text);
817: END IF;
818: BEGIN
819: --EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlcode from dual' INTO x_return_status;
820: x_return_status := FND_API.G_RET_STS_ERROR;
821: EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlerrm from dual' INTO x_return_status_text;
822:
823: IF l_debug = FND_API.G_TRUE THEN

Line 821: EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlerrm from dual' INTO x_return_status_text;

817: END IF;
818: BEGIN
819: --EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlcode from dual' INTO x_return_status;
820: x_return_status := FND_API.G_RET_STS_ERROR;
821: EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlerrm from dual' INTO x_return_status_text;
822:
823: IF l_debug = FND_API.G_TRUE THEN
824: QP_PREQ_GRP.engine_debug('x_return_status='||x_return_status||' x_return_status_text='||x_return_status_text);
825: END IF;

Line 829: x_return_status_text := 'UTL_HTTP REQUEST_FAILED exception';

825: END IF;
826: EXCEPTION
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';

Line 851: --EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlcode from dual' INTO x_return_status;

847: END IF;
848: x_return_status := FND_API.G_RET_STS_ERROR;
849: WHEN OTHERS THEN
850: BEGIN
851: --EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlcode from dual' INTO x_return_status;
852: x_return_status := FND_API.G_RET_STS_ERROR;
853: EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlerrm from dual' INTO x_return_status_text;
854:
855: IF l_debug = FND_API.G_TRUE THEN

Line 853: EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlerrm from dual' INTO x_return_status_text;

849: WHEN OTHERS THEN
850: BEGIN
851: --EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlcode from dual' INTO x_return_status;
852: x_return_status := FND_API.G_RET_STS_ERROR;
853: EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlerrm from dual' INTO x_return_status_text;
854:
855: IF l_debug = FND_API.G_TRUE THEN
856: QP_PREQ_GRP.engine_debug('x_return_status='||x_return_status||' x_return_status_text='||x_return_status_text);
857: END IF;

Line 873: transferTimeout := FND_PROFILE.VALUE('QP_UTL_HTTP_TIMEOUT');

869: end Send_Java_Request;
870:
871: BEGIN
872: BEGIN
873: transferTimeout := FND_PROFILE.VALUE('QP_UTL_HTTP_TIMEOUT');
874: eightI_env := FND_API.G_FALSE;
875: EXECUTE IMMEDIATE 'BEGIN UTL_HTTP.GET_TRANSFER_TIMEOUT(:1); END;' USING IN OUT defaultTimeout;
876: IF l_debug = FND_API.G_TRUE THEN
877: QP_PREQ_GRP.engine_debug('transferTimeout='||transferTimeout||'sec defaultTimeout='||defaultTimeout||'sec.');

Line 875: EXECUTE IMMEDIATE 'BEGIN UTL_HTTP.GET_TRANSFER_TIMEOUT(:1); END;' USING IN OUT defaultTimeout;

871: BEGIN
872: BEGIN
873: transferTimeout := FND_PROFILE.VALUE('QP_UTL_HTTP_TIMEOUT');
874: eightI_env := FND_API.G_FALSE;
875: EXECUTE IMMEDIATE 'BEGIN UTL_HTTP.GET_TRANSFER_TIMEOUT(:1); END;' USING IN OUT defaultTimeout;
876: IF l_debug = FND_API.G_TRUE THEN
877: QP_PREQ_GRP.engine_debug('transferTimeout='||transferTimeout||'sec defaultTimeout='||defaultTimeout||'sec.');
878: END IF;
879: EXCEPTION