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 305: UTL_HTTP.SET_WALLET(G_WALLET_PATH,G_WALLET_PASSWORD);

301: WSH_DEBUG_SV.log(l_module_name,'g_wallet_path='||G_WALLET_PATH);
302: WSH_DEBUG_SV.log(l_module_name,'g_wallet_password='||G_WALLET_PASSWORD);
303: END IF;
304:
305: UTL_HTTP.SET_WALLET(G_WALLET_PATH,G_WALLET_PASSWORD);
306:
307: --l_resp_pieces := UTL_HTTP.Request_Pieces(url => l_servlet_uri,
308: -- proxy => G_WSH_OTM_PROXY_SERVER,
309: -- wallet_path => G_WALLET_PATH,

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

303: END IF;
304:
305: UTL_HTTP.SET_WALLET(G_WALLET_PATH,G_WALLET_PASSWORD);
306:
307: --l_resp_pieces := UTL_HTTP.Request_Pieces(url => l_servlet_uri,
308: -- proxy => G_WSH_OTM_PROXY_SERVER,
309: -- wallet_path => G_WALLET_PATH,
310: -- wallet_password => G_WALLET_PASSWORD);
311: END IF;

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

308: -- proxy => G_WSH_OTM_PROXY_SERVER,
309: -- wallet_path => G_WALLET_PATH,
310: -- wallet_password => G_WALLET_PASSWORD);
311: END IF;
312: --l_resp_pieces := UTL_HTTP.Request_Pieces(url => l_servlet_uri,
313: -- proxy => G_WSH_OTM_PROXY_SERVER);
314: Utl_Http.Set_Proxy ( proxy => G_WSH_OTM_PROXY_SERVER );
315:
316: UTL_HTTP.set_response_error_check ( enable => false);

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

310: -- wallet_password => G_WALLET_PASSWORD);
311: END IF;
312: --l_resp_pieces := UTL_HTTP.Request_Pieces(url => l_servlet_uri,
313: -- proxy => G_WSH_OTM_PROXY_SERVER);
314: Utl_Http.Set_Proxy ( proxy => G_WSH_OTM_PROXY_SERVER );
315:
316: UTL_HTTP.set_response_error_check ( enable => false);
317: --Utl_Http.Set_Detailed_Excp_Support ( enable => true );
318:

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

312: --l_resp_pieces := UTL_HTTP.Request_Pieces(url => l_servlet_uri,
313: -- proxy => G_WSH_OTM_PROXY_SERVER);
314: Utl_Http.Set_Proxy ( proxy => G_WSH_OTM_PROXY_SERVER );
315:
316: UTL_HTTP.set_response_error_check ( enable => false);
317: --Utl_Http.Set_Detailed_Excp_Support ( enable => true );
318:
319: l_request := UTL_HTTP.begin_request(l_servlet_uri, 'POST' );--,'HTTP/1.0');--UTL_HTTP.HTTP_VERSION_1_0);
320: UTL_HTTP.SET_HEADER(l_request,'Content-Type','application/x-www-form-urlencoded');

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

313: -- proxy => G_WSH_OTM_PROXY_SERVER);
314: Utl_Http.Set_Proxy ( proxy => G_WSH_OTM_PROXY_SERVER );
315:
316: UTL_HTTP.set_response_error_check ( enable => false);
317: --Utl_Http.Set_Detailed_Excp_Support ( enable => true );
318:
319: l_request := UTL_HTTP.begin_request(l_servlet_uri, 'POST' );--,'HTTP/1.0');--UTL_HTTP.HTTP_VERSION_1_0);
320: UTL_HTTP.SET_HEADER(l_request,'Content-Type','application/x-www-form-urlencoded');
321: UTL_HTTP.SET_HEADER(l_request,'Content-length',to_char(length(l_context_params)));

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

315:
316: UTL_HTTP.set_response_error_check ( enable => false);
317: --Utl_Http.Set_Detailed_Excp_Support ( enable => true );
318:
319: l_request := UTL_HTTP.begin_request(l_servlet_uri, 'POST' );--,'HTTP/1.0');--UTL_HTTP.HTTP_VERSION_1_0);
320: UTL_HTTP.SET_HEADER(l_request,'Content-Type','application/x-www-form-urlencoded');
321: UTL_HTTP.SET_HEADER(l_request,'Content-length',to_char(length(l_context_params)));
322:
323: -- Bug 5625714

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

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

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

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

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

320: UTL_HTTP.SET_HEADER(l_request,'Content-Type','application/x-www-form-urlencoded');
321: UTL_HTTP.SET_HEADER(l_request,'Content-length',to_char(length(l_context_params)));
322:
323: -- Bug 5625714
324: -- need to repeat Utl_Http.Write_Text as it can handle
325: -- only up to 32767 characters
326: -- Utl_Http.Write_Text(l_request,l_context_params);
327: l_amt:= 32000;
328: l_pos:= 1;

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

322:
323: -- Bug 5625714
324: -- need to repeat Utl_Http.Write_Text as it can handle
325: -- only up to 32767 characters
326: -- Utl_Http.Write_Text(l_request,l_context_params);
327: l_amt:= 32000;
328: l_pos:= 1;
329: l_length:=DBMS_LOB.GETLENGTH(l_context_params);
330: IF (l_debug_on) THEN

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

340: IF (l_debug_on) THEN
341: WSH_DEBUG_SV.log(l_module_name,'l_amt', l_amt);
342: END IF;
343: dbms_lob.read(l_context_params, l_amt, l_pos, l_buffer);
344: Utl_Http.Write_Text(l_request,l_buffer);
345: l_length:=l_length-l_amt;
346: l_pos := l_pos + l_amt;
347: --}
348: END LOOP;

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

346: l_pos := l_pos + l_amt;
347: --}
348: END LOOP;
349: -- End of Bug 5625714
350: l_response := utl_http.get_response(l_request);
351:
352: --END IF;
353:
354: IF (l_debug_on) THEN

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

362: END IF;
363:
364: BEGIN
365: LOOP
366: utl_http.read_text(l_response, l_response_data);
367: IF (l_debug_on) THEN
368: WSH_DEBUG_SV.log(l_module_name,'Line ='||l_response_data);
369: END IF;
370: l_clob_response := l_clob_response||l_response_data;

Line 373: WHEN UTL_HTTP.end_of_body THEN

369: END IF;
370: l_clob_response := l_clob_response||l_response_data;
371: END LOOP;
372: EXCEPTION
373: WHEN UTL_HTTP.end_of_body THEN
374: UTL_HTTP.end_response(l_response);
375: END;
376:
377: IF l_clob_response IS NULL THEN

Line 374: UTL_HTTP.end_response(l_response);

370: l_clob_response := l_clob_response||l_response_data;
371: END LOOP;
372: EXCEPTION
373: WHEN UTL_HTTP.end_of_body THEN
374: UTL_HTTP.end_response(l_response);
375: END;
376:
377: IF l_clob_response IS NULL THEN
378: RAISE wsh_null_otm_response;

Line 407: WHEN UTL_HTTP.INIT_FAILED THEN

403: IF l_debug_on THEN
404: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status='||x_return_status);
405: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_otm_load_profile_failed');
406: END IF;
407: WHEN UTL_HTTP.INIT_FAILED THEN
408: BEGIN
409: EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlcode from dual' INTO x_return_status;
410: x_return_status := FND_API.G_RET_STS_ERROR;
411: EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlerrm from dual' INTO l_return_status_text;

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

405: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_otm_load_profile_failed');
406: END IF;
407: WHEN UTL_HTTP.INIT_FAILED THEN
408: BEGIN
409: EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlcode from dual' INTO x_return_status;
410: x_return_status := FND_API.G_RET_STS_ERROR;
411: EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlerrm from dual' INTO l_return_status_text;
412: IF l_debug_on THEN
413: WSH_DEBUG_SV.logmsg(l_module_name,'HTTP request failed because of UTL_HTTP_INIT_FAILED');

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

407: WHEN UTL_HTTP.INIT_FAILED THEN
408: BEGIN
409: EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlcode from dual' INTO x_return_status;
410: x_return_status := FND_API.G_RET_STS_ERROR;
411: EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlerrm from dual' INTO l_return_status_text;
412: IF l_debug_on THEN
413: WSH_DEBUG_SV.logmsg(l_module_name,'HTTP request failed because of UTL_HTTP_INIT_FAILED');
414: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status='||x_return_status||' l_return_status_text='||l_return_status_text);
415: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.UTL_HTTP.INIT_FAILED');

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

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

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

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

Line 418: WHEN UTL_HTTP.REQUEST_FAILED THEN

414: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status='||x_return_status||' l_return_status_text='||l_return_status_text);
415: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.UTL_HTTP.INIT_FAILED');
416: END IF;
417: END;
418: WHEN UTL_HTTP.REQUEST_FAILED THEN
419: x_return_status := FND_API.G_RET_STS_ERROR;
420: l_return_status_text := 'UTL_HTTP.REQUEST_FAILED';
421: IF l_debug_on THEN
422: WSH_DEBUG_SV.logmsg(l_module_name,'HTTP request failed because of UTL HTTP REQUEST_FAILED'||l_return_status_text);

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

416: END IF;
417: END;
418: WHEN UTL_HTTP.REQUEST_FAILED THEN
419: x_return_status := FND_API.G_RET_STS_ERROR;
420: l_return_status_text := 'UTL_HTTP.REQUEST_FAILED';
421: IF l_debug_on THEN
422: WSH_DEBUG_SV.logmsg(l_module_name,'HTTP request failed because of UTL HTTP REQUEST_FAILED'||l_return_status_text);
423: END IF;
424: BEGIN

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

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

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

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

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

423: END IF;
424: BEGIN
425: EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlcode from dual' INTO x_return_status;
426: x_return_status := FND_API.G_RET_STS_ERROR;
427: EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlerrm from dual' INTO l_return_status_text;
428: IF l_debug_on THEN
429: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status='||x_return_status||' l_return_status_text='||l_return_status_text);
430: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:UTL_HTTP.REQUEST_FAILED');
431: END IF;

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

426: x_return_status := FND_API.G_RET_STS_ERROR;
427: EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlerrm from dual' INTO l_return_status_text;
428: IF l_debug_on THEN
429: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status='||x_return_status||' l_return_status_text='||l_return_status_text);
430: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:UTL_HTTP.REQUEST_FAILED');
431: END IF;
432: END;
433: WHEN UTL_TCP.END_OF_INPUT THEN
434: x_return_status := FND_API.G_RET_STS_ERROR;

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

454: x_return_status := FND_API.G_RET_STS_ERROR;
455: IF l_debug_on THEN
456: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
457: BEGIN
458: EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlcode from dual' INTO x_return_status;
459: EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlerrm from dual' INTO l_return_status_text;
460: IF l_debug_on THEN
461: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status='||x_return_status||' l_return_status_text='||l_return_status_text);
462: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

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

455: IF l_debug_on THEN
456: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
457: BEGIN
458: EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlcode from dual' INTO x_return_status;
459: EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlerrm from dual' INTO l_return_status_text;
460: IF l_debug_on THEN
461: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status='||x_return_status||' l_return_status_text='||l_return_status_text);
462: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
463: END IF;