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.WSH_OTM_HTTP_UTL dependencies on UTL_HTTP

Line 204: l_response UTL_HTTP.Resp;

200: l_fnd_ticket RAW(1000);
201: l_tkt_end_date VARCHAR2(500);
202: l_end_point VARCHAR2(4000);
203: l_return_status VARCHAR2(1);
204: l_response UTL_HTTP.Resp;
205: l_request UTL_HTTP.Req;
206: l_clob_response CLOB;
207: l_response_data VARCHAR2(2000);
208: l_resp_pieces UTL_HTTP.html_pieces;

Line 205: l_request UTL_HTTP.Req;

201: l_tkt_end_date VARCHAR2(500);
202: l_end_point VARCHAR2(4000);
203: l_return_status VARCHAR2(1);
204: l_response UTL_HTTP.Resp;
205: l_request UTL_HTTP.Req;
206: l_clob_response CLOB;
207: l_response_data VARCHAR2(2000);
208: l_resp_pieces UTL_HTTP.html_pieces;
209: l_profiles VARCHAR2(1);

Line 208: l_resp_pieces UTL_HTTP.html_pieces;

204: l_response UTL_HTTP.Resp;
205: l_request UTL_HTTP.Req;
206: l_clob_response CLOB;
207: l_response_data VARCHAR2(2000);
208: l_resp_pieces UTL_HTTP.html_pieces;
209: l_profiles VARCHAR2(1);
210: l_context_params CLOB;--VARCHAR2(32676);
211: l_server_tz VARCHAR2(100);
212: l_debug_on BOOLEAN;

Line 311: UTL_HTTP.SET_WALLET(G_WALLET_PATH,G_WALLET_PASSWORD);

307: WSH_DEBUG_SV.log(l_module_name,'g_wallet_path='||G_WALLET_PATH);
308: WSH_DEBUG_SV.log(l_module_name,'g_wallet_password='||G_WALLET_PASSWORD);
309: END IF;
310:
311: UTL_HTTP.SET_WALLET(G_WALLET_PATH,G_WALLET_PASSWORD);
312:
313: --l_resp_pieces := UTL_HTTP.Request_Pieces(url => l_servlet_uri,
314: -- proxy => G_WSH_OTM_PROXY_SERVER,
315: -- wallet_path => G_WALLET_PATH,

Line 313: --l_resp_pieces := UTL_HTTP.Request_Pieces(url => l_servlet_uri,

309: END IF;
310:
311: UTL_HTTP.SET_WALLET(G_WALLET_PATH,G_WALLET_PASSWORD);
312:
313: --l_resp_pieces := UTL_HTTP.Request_Pieces(url => l_servlet_uri,
314: -- proxy => G_WSH_OTM_PROXY_SERVER,
315: -- wallet_path => G_WALLET_PATH,
316: -- wallet_password => G_WALLET_PASSWORD);
317: END IF;

Line 318: --l_resp_pieces := UTL_HTTP.Request_Pieces(url => l_servlet_uri,

314: -- proxy => G_WSH_OTM_PROXY_SERVER,
315: -- wallet_path => G_WALLET_PATH,
316: -- wallet_password => G_WALLET_PASSWORD);
317: END IF;
318: --l_resp_pieces := UTL_HTTP.Request_Pieces(url => l_servlet_uri,
319: -- proxy => G_WSH_OTM_PROXY_SERVER);
320: Utl_Http.Set_Proxy ( proxy => G_WSH_OTM_PROXY_SERVER );
321:
322: UTL_HTTP.set_response_error_check ( enable => false);

Line 320: Utl_Http.Set_Proxy ( proxy => G_WSH_OTM_PROXY_SERVER );

316: -- wallet_password => G_WALLET_PASSWORD);
317: END IF;
318: --l_resp_pieces := UTL_HTTP.Request_Pieces(url => l_servlet_uri,
319: -- proxy => G_WSH_OTM_PROXY_SERVER);
320: Utl_Http.Set_Proxy ( proxy => G_WSH_OTM_PROXY_SERVER );
321:
322: UTL_HTTP.set_response_error_check ( enable => false);
323: --Utl_Http.Set_Detailed_Excp_Support ( enable => true );
324:

Line 322: UTL_HTTP.set_response_error_check ( enable => false);

318: --l_resp_pieces := UTL_HTTP.Request_Pieces(url => l_servlet_uri,
319: -- proxy => G_WSH_OTM_PROXY_SERVER);
320: Utl_Http.Set_Proxy ( proxy => G_WSH_OTM_PROXY_SERVER );
321:
322: UTL_HTTP.set_response_error_check ( enable => false);
323: --Utl_Http.Set_Detailed_Excp_Support ( enable => true );
324:
325: l_request := UTL_HTTP.begin_request(l_servlet_uri, 'POST' );--,'HTTP/1.0');--UTL_HTTP.HTTP_VERSION_1_0);
326: UTL_HTTP.SET_HEADER(l_request,'Content-Type','application/x-www-form-urlencoded');

Line 323: --Utl_Http.Set_Detailed_Excp_Support ( enable => true );

319: -- proxy => G_WSH_OTM_PROXY_SERVER);
320: Utl_Http.Set_Proxy ( proxy => G_WSH_OTM_PROXY_SERVER );
321:
322: UTL_HTTP.set_response_error_check ( enable => false);
323: --Utl_Http.Set_Detailed_Excp_Support ( enable => true );
324:
325: l_request := UTL_HTTP.begin_request(l_servlet_uri, 'POST' );--,'HTTP/1.0');--UTL_HTTP.HTTP_VERSION_1_0);
326: UTL_HTTP.SET_HEADER(l_request,'Content-Type','application/x-www-form-urlencoded');
327: UTL_HTTP.SET_HEADER(l_request,'Content-length',to_char(length(l_context_params)));

Line 325: l_request := UTL_HTTP.begin_request(l_servlet_uri, 'POST' );--,'HTTP/1.0');--UTL_HTTP.HTTP_VERSION_1_0);

321:
322: UTL_HTTP.set_response_error_check ( enable => false);
323: --Utl_Http.Set_Detailed_Excp_Support ( enable => true );
324:
325: l_request := UTL_HTTP.begin_request(l_servlet_uri, 'POST' );--,'HTTP/1.0');--UTL_HTTP.HTTP_VERSION_1_0);
326: UTL_HTTP.SET_HEADER(l_request,'Content-Type','application/x-www-form-urlencoded');
327: UTL_HTTP.SET_HEADER(l_request,'Content-length',to_char(length(l_context_params)));
328:
329: -- Bug 5625714

Line 326: UTL_HTTP.SET_HEADER(l_request,'Content-Type','application/x-www-form-urlencoded');

322: UTL_HTTP.set_response_error_check ( enable => false);
323: --Utl_Http.Set_Detailed_Excp_Support ( enable => true );
324:
325: l_request := UTL_HTTP.begin_request(l_servlet_uri, 'POST' );--,'HTTP/1.0');--UTL_HTTP.HTTP_VERSION_1_0);
326: UTL_HTTP.SET_HEADER(l_request,'Content-Type','application/x-www-form-urlencoded');
327: UTL_HTTP.SET_HEADER(l_request,'Content-length',to_char(length(l_context_params)));
328:
329: -- Bug 5625714
330: -- need to repeat Utl_Http.Write_Text as it can handle

Line 327: UTL_HTTP.SET_HEADER(l_request,'Content-length',to_char(length(l_context_params)));

323: --Utl_Http.Set_Detailed_Excp_Support ( enable => true );
324:
325: l_request := UTL_HTTP.begin_request(l_servlet_uri, 'POST' );--,'HTTP/1.0');--UTL_HTTP.HTTP_VERSION_1_0);
326: UTL_HTTP.SET_HEADER(l_request,'Content-Type','application/x-www-form-urlencoded');
327: UTL_HTTP.SET_HEADER(l_request,'Content-length',to_char(length(l_context_params)));
328:
329: -- Bug 5625714
330: -- need to repeat Utl_Http.Write_Text as it can handle
331: -- only up to 32767 characters

Line 330: -- need to repeat Utl_Http.Write_Text as it can handle

326: UTL_HTTP.SET_HEADER(l_request,'Content-Type','application/x-www-form-urlencoded');
327: UTL_HTTP.SET_HEADER(l_request,'Content-length',to_char(length(l_context_params)));
328:
329: -- Bug 5625714
330: -- need to repeat Utl_Http.Write_Text as it can handle
331: -- only up to 32767 characters
332: -- Utl_Http.Write_Text(l_request,l_context_params);
333: l_amt:= 32000;
334: l_pos:= 1;

Line 332: -- Utl_Http.Write_Text(l_request,l_context_params);

328:
329: -- Bug 5625714
330: -- need to repeat Utl_Http.Write_Text as it can handle
331: -- only up to 32767 characters
332: -- Utl_Http.Write_Text(l_request,l_context_params);
333: l_amt:= 32000;
334: l_pos:= 1;
335: l_length:=DBMS_LOB.GETLENGTH(l_context_params);
336: IF (l_debug_on) THEN

Line 350: Utl_Http.Write_Text(l_request,l_buffer);

346: IF (l_debug_on) THEN
347: WSH_DEBUG_SV.log(l_module_name,'l_amt', l_amt);
348: END IF;
349: dbms_lob.read(l_context_params, l_amt, l_pos, l_buffer);
350: Utl_Http.Write_Text(l_request,l_buffer);
351: l_length:=l_length-l_amt;
352: l_pos := l_pos + l_amt;
353: --}
354: END LOOP;

Line 356: l_response := utl_http.get_response(l_request);

352: l_pos := l_pos + l_amt;
353: --}
354: END LOOP;
355: -- End of Bug 5625714
356: l_response := utl_http.get_response(l_request);
357:
358: --END IF;
359:
360: IF (l_debug_on) THEN

Line 372: utl_http.read_text(l_response, l_response_data);

368: END IF;
369:
370: BEGIN
371: LOOP
372: utl_http.read_text(l_response, l_response_data);
373: IF (l_debug_on) THEN
374: WSH_DEBUG_SV.log(l_module_name,'Line ='||l_response_data);
375: END IF;
376: l_clob_response := l_clob_response||l_response_data;

Line 379: WHEN UTL_HTTP.end_of_body THEN

375: END IF;
376: l_clob_response := l_clob_response||l_response_data;
377: END LOOP;
378: EXCEPTION
379: WHEN UTL_HTTP.end_of_body THEN
380: UTL_HTTP.end_response(l_response);
381: END;
382:
383: IF l_clob_response IS NULL THEN

Line 380: UTL_HTTP.end_response(l_response);

376: l_clob_response := l_clob_response||l_response_data;
377: END LOOP;
378: EXCEPTION
379: WHEN UTL_HTTP.end_of_body THEN
380: UTL_HTTP.end_response(l_response);
381: END;
382:
383: IF l_clob_response IS NULL THEN
384: RAISE wsh_null_otm_response;

Line 413: WHEN UTL_HTTP.INIT_FAILED THEN

409: IF l_debug_on THEN
410: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status='||x_return_status);
411: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_otm_load_profile_failed');
412: END IF;
413: WHEN UTL_HTTP.INIT_FAILED THEN
414: BEGIN
415: EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlcode from dual' INTO x_return_status;
416: x_return_status := FND_API.G_RET_STS_ERROR;
417: EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlerrm from dual' INTO l_return_status_text;

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

411: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_otm_load_profile_failed');
412: END IF;
413: WHEN UTL_HTTP.INIT_FAILED THEN
414: BEGIN
415: EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlcode from dual' INTO x_return_status;
416: x_return_status := FND_API.G_RET_STS_ERROR;
417: EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlerrm from dual' INTO l_return_status_text;
418: IF l_debug_on THEN
419: WSH_DEBUG_SV.logmsg(l_module_name,'HTTP request failed because of UTL_HTTP_INIT_FAILED');

Line 417: EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlerrm from dual' INTO l_return_status_text;

413: WHEN UTL_HTTP.INIT_FAILED THEN
414: BEGIN
415: EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlcode from dual' INTO x_return_status;
416: x_return_status := FND_API.G_RET_STS_ERROR;
417: EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlerrm from dual' INTO l_return_status_text;
418: IF l_debug_on THEN
419: WSH_DEBUG_SV.logmsg(l_module_name,'HTTP request failed because of UTL_HTTP_INIT_FAILED');
420: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status='||x_return_status||' l_return_status_text='||l_return_status_text);
421: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.UTL_HTTP.INIT_FAILED');

Line 419: WSH_DEBUG_SV.logmsg(l_module_name,'HTTP request failed because of UTL_HTTP_INIT_FAILED');

415: EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlcode from dual' INTO x_return_status;
416: x_return_status := FND_API.G_RET_STS_ERROR;
417: EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlerrm from dual' INTO l_return_status_text;
418: IF l_debug_on THEN
419: WSH_DEBUG_SV.logmsg(l_module_name,'HTTP request failed because of UTL_HTTP_INIT_FAILED');
420: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status='||x_return_status||' l_return_status_text='||l_return_status_text);
421: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.UTL_HTTP.INIT_FAILED');
422: END IF;
423: END;

Line 421: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.UTL_HTTP.INIT_FAILED');

417: EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlerrm from dual' INTO l_return_status_text;
418: IF l_debug_on THEN
419: WSH_DEBUG_SV.logmsg(l_module_name,'HTTP request failed because of UTL_HTTP_INIT_FAILED');
420: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status='||x_return_status||' l_return_status_text='||l_return_status_text);
421: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.UTL_HTTP.INIT_FAILED');
422: END IF;
423: END;
424: WHEN UTL_HTTP.REQUEST_FAILED THEN
425: x_return_status := FND_API.G_RET_STS_ERROR;

Line 424: WHEN UTL_HTTP.REQUEST_FAILED THEN

420: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status='||x_return_status||' l_return_status_text='||l_return_status_text);
421: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.UTL_HTTP.INIT_FAILED');
422: END IF;
423: END;
424: WHEN UTL_HTTP.REQUEST_FAILED THEN
425: x_return_status := FND_API.G_RET_STS_ERROR;
426: l_return_status_text := 'UTL_HTTP.REQUEST_FAILED';
427: IF l_debug_on THEN
428: WSH_DEBUG_SV.logmsg(l_module_name,'HTTP request failed because of UTL HTTP REQUEST_FAILED'||l_return_status_text);

Line 426: l_return_status_text := 'UTL_HTTP.REQUEST_FAILED';

422: END IF;
423: END;
424: WHEN UTL_HTTP.REQUEST_FAILED THEN
425: x_return_status := FND_API.G_RET_STS_ERROR;
426: l_return_status_text := 'UTL_HTTP.REQUEST_FAILED';
427: IF l_debug_on THEN
428: WSH_DEBUG_SV.logmsg(l_module_name,'HTTP request failed because of UTL HTTP REQUEST_FAILED'||l_return_status_text);
429: END IF;
430: BEGIN

Line 428: WSH_DEBUG_SV.logmsg(l_module_name,'HTTP request failed because of UTL HTTP REQUEST_FAILED'||l_return_status_text);

424: WHEN UTL_HTTP.REQUEST_FAILED THEN
425: x_return_status := FND_API.G_RET_STS_ERROR;
426: l_return_status_text := 'UTL_HTTP.REQUEST_FAILED';
427: IF l_debug_on THEN
428: WSH_DEBUG_SV.logmsg(l_module_name,'HTTP request failed because of UTL HTTP REQUEST_FAILED'||l_return_status_text);
429: END IF;
430: BEGIN
431: EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlcode from dual' INTO x_return_status;
432: x_return_status := FND_API.G_RET_STS_ERROR;

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

427: IF l_debug_on THEN
428: WSH_DEBUG_SV.logmsg(l_module_name,'HTTP request failed because of UTL HTTP REQUEST_FAILED'||l_return_status_text);
429: END IF;
430: BEGIN
431: EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlcode from dual' INTO x_return_status;
432: x_return_status := FND_API.G_RET_STS_ERROR;
433: EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlerrm from dual' INTO l_return_status_text;
434: IF l_debug_on THEN
435: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status='||x_return_status||' l_return_status_text='||l_return_status_text);

Line 433: EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlerrm from dual' INTO l_return_status_text;

429: END IF;
430: BEGIN
431: EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlcode from dual' INTO x_return_status;
432: x_return_status := FND_API.G_RET_STS_ERROR;
433: EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlerrm from dual' INTO l_return_status_text;
434: IF l_debug_on THEN
435: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status='||x_return_status||' l_return_status_text='||l_return_status_text);
436: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:UTL_HTTP.REQUEST_FAILED');
437: END IF;

Line 436: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:UTL_HTTP.REQUEST_FAILED');

432: x_return_status := FND_API.G_RET_STS_ERROR;
433: EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlerrm from dual' INTO l_return_status_text;
434: IF l_debug_on THEN
435: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status='||x_return_status||' l_return_status_text='||l_return_status_text);
436: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:UTL_HTTP.REQUEST_FAILED');
437: END IF;
438: END;
439: WHEN UTL_TCP.END_OF_INPUT THEN
440: x_return_status := FND_API.G_RET_STS_ERROR;

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

460: x_return_status := FND_API.G_RET_STS_ERROR;
461: IF l_debug_on THEN
462: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
463: BEGIN
464: EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlcode from dual' INTO x_return_status;
465: EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlerrm from dual' INTO l_return_status_text;
466: IF l_debug_on THEN
467: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status='||x_return_status||' l_return_status_text='||l_return_status_text);
468: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 465: EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlerrm from dual' INTO l_return_status_text;

461: IF l_debug_on THEN
462: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
463: BEGIN
464: EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlcode from dual' INTO x_return_status;
465: EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlerrm from dual' INTO l_return_status_text;
466: IF l_debug_on THEN
467: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status='||x_return_status||' l_return_status_text='||l_return_status_text);
468: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
469: END IF;