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 FND_API

Line 45: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

41: IS
42: l_debug_on BOOLEAN;
43: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'load_profiles';
44: j NUMBER;
45: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
46: wsh_otm_endpoint_null EXCEPTION;
47: wsh_otm_uname_null EXCEPTION;
48: wsh_otm_pswd_null EXCEPTION;
49: BEGIN

Line 132: RETURN FND_API.G_RET_STS_SUCCESS;

128: WSH_DEBUG_SV.log(l_module_name,'G_OTM_PSWD'||G_OTM_PSWD);
129: WSH_DEBUG_SV.pop(l_module_name);
130: END IF;
131:
132: RETURN FND_API.G_RET_STS_SUCCESS;
133:
134: EXCEPTION
135: WHEN wsh_otm_endpoint_null THEN
136: IF l_debug_on THEN

Line 139: RETURN FND_API.G_RET_STS_ERROR;

135: WHEN wsh_otm_endpoint_null THEN
136: IF l_debug_on THEN
137: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_otm_endpoint_null');
138: END IF;
139: RETURN FND_API.G_RET_STS_ERROR;
140: WHEN others THEN
141: IF l_debug_on THEN
142: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
143: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 145: RETURN FND_API.G_RET_STS_ERROR;

141: IF l_debug_on THEN
142: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
143: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
144: END IF;
145: RETURN FND_API.G_RET_STS_ERROR;
146: END load_profiles;
147:
148: -- Check if URL is an HTTPS URL
149: -- Return Y or N

Line 240: x_return_status := FND_API.G_RET_STS_SUCCESS;

236: WSH_DEBUG_SV.push(l_module_name);
237: END IF;
238:
239:
240: x_return_status := FND_API.G_RET_STS_SUCCESS;
241:
242: IF (l_debug_on) THEN
243: WSH_DEBUG_SV.log(l_module_name,'before load profiles');
244: END IF;

Line 253: IF l_profiles = FND_API.G_RET_STS_ERROR THEN

249: IF (l_debug_on) THEN
250: WSH_DEBUG_SV.log(l_module_name,'l_profiles='||l_profiles);
251: END IF;
252:
253: IF l_profiles = FND_API.G_RET_STS_ERROR THEN
254: RAISE wsh_otm_load_profile_failed;
255: END IF;
256:
257: IF (l_debug_on) THEN

Line 390: x_return_status := FND_API.G_RET_STS_ERROR;

386: END IF;
387:
388: EXCEPTION
389: WHEN wsh_null_otm_response THEN
390: x_return_status := FND_API.G_RET_STS_ERROR;
391: IF l_debug_on THEN
392: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status='||x_return_status);
393: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_null_otm_response: Null response received.');
394: END IF;

Line 396: x_return_status := FND_API.G_RET_STS_ERROR;

392: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status='||x_return_status);
393: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_null_otm_response: Null response received.');
394: END IF;
395: WHEN wsh_otm_unavailable_exception THEN
396: x_return_status := FND_API.G_RET_STS_ERROR;
397: IF l_debug_on THEN
398: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status='||x_return_status);
399: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_otm_unavailable_exception: OTM Server is down. Contact the System Administrator');
400: END IF;

Line 402: x_return_status := FND_API.G_RET_STS_ERROR;

398: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status='||x_return_status);
399: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_otm_unavailable_exception: OTM Server is down. Contact the System Administrator');
400: END IF;
401: WHEN wsh_otm_load_profile_failed THEN
402: x_return_status := FND_API.G_RET_STS_ERROR;
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;

Line 410: x_return_status := FND_API.G_RET_STS_ERROR;

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');
414: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status='||x_return_status||' l_return_status_text='||l_return_status_text);

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 419: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 426: x_return_status := FND_API.G_RET_STS_ERROR;

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);
430: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:UTL_HTTP.REQUEST_FAILED');

Line 434: x_return_status := FND_API.G_RET_STS_ERROR;

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;
435: l_return_status_text := 'UTL_TCP.END_OF_INPUT';
436: IF l_debug_on THEN
437: WSH_DEBUG_SV.logmsg(l_module_name,'HTTP request failed because of UTL_TCP.END_OF_INPUT');
438: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status='||x_return_status||' l_return_status_text='||l_return_status_text);

Line 441: WHEN FND_API.G_EXC_ERROR THEN

437: WSH_DEBUG_SV.logmsg(l_module_name,'HTTP request failed because of UTL_TCP.END_OF_INPUT');
438: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status='||x_return_status||' l_return_status_text='||l_return_status_text);
439: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:UTL_TCP.END_OF_INPUT');
440: END IF;
441: WHEN FND_API.G_EXC_ERROR THEN
442: x_return_status := FND_API.G_RET_STS_ERROR;
443: IF l_debug_on THEN
444: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
445: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

Line 442: x_return_status := FND_API.G_RET_STS_ERROR;

438: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status='||x_return_status||' l_return_status_text='||l_return_status_text);
439: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:UTL_TCP.END_OF_INPUT');
440: END IF;
441: WHEN FND_API.G_EXC_ERROR THEN
442: x_return_status := FND_API.G_RET_STS_ERROR;
443: IF l_debug_on THEN
444: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
445: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
446: END IF;

Line 444: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

440: END IF;
441: WHEN FND_API.G_EXC_ERROR THEN
442: x_return_status := FND_API.G_RET_STS_ERROR;
443: IF l_debug_on THEN
444: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
445: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
446: END IF;
447: WHEN g_tkt_error THEN
448: x_return_status := FND_API.G_RET_STS_ERROR;

Line 445: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

441: WHEN FND_API.G_EXC_ERROR THEN
442: x_return_status := FND_API.G_RET_STS_ERROR;
443: IF l_debug_on THEN
444: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
445: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
446: END IF;
447: WHEN g_tkt_error THEN
448: x_return_status := FND_API.G_RET_STS_ERROR;
449: IF l_debug_on THEN

Line 448: x_return_status := FND_API.G_RET_STS_ERROR;

444: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
445: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
446: END IF;
447: WHEN g_tkt_error THEN
448: x_return_status := FND_API.G_RET_STS_ERROR;
449: IF l_debug_on THEN
450: WSH_DEBUG_SV.logmsg(l_module_name,'g_tkt_error has occured.',WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
451: WSH_DEBUG_SV.pop(l_module_name,'FND_API.G_EXC_ERROR');
452: END IF;

Line 451: WSH_DEBUG_SV.pop(l_module_name,'FND_API.G_EXC_ERROR');

447: WHEN g_tkt_error THEN
448: x_return_status := FND_API.G_RET_STS_ERROR;
449: IF l_debug_on THEN
450: WSH_DEBUG_SV.logmsg(l_module_name,'g_tkt_error has occured.',WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
451: WSH_DEBUG_SV.pop(l_module_name,'FND_API.G_EXC_ERROR');
452: END IF;
453: WHEN others THEN
454: x_return_status := FND_API.G_RET_STS_ERROR;
455: IF l_debug_on THEN

Line 454: x_return_status := FND_API.G_RET_STS_ERROR;

450: WSH_DEBUG_SV.logmsg(l_module_name,'g_tkt_error has occured.',WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
451: WSH_DEBUG_SV.pop(l_module_name,'FND_API.G_EXC_ERROR');
452: END IF;
453: WHEN others THEN
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;

Line 466: x_return_status := FND_API.G_RET_STS_ERROR;

462: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
463: END IF;
464: EXCEPTION
465: WHEN OTHERS THEN
466: x_return_status := FND_API.G_RET_STS_ERROR;
467: FND_MESSAGE.SET_NAME('WSH','WSH_UTL_POST_UNEXPECTED_ERROR');
468: l_return_status_text := FND_MESSAGE.GET;
469: END;
470: END IF;

Line 520: x_return_status := FND_API.G_RET_STS_SUCCESS;

516: IF l_debug_on THEN
517: WSH_DEBUG_SV.push(l_module_name);
518: END IF;
519:
520: x_return_status := FND_API.G_RET_STS_SUCCESS;
521:
522: OPEN c_get_ticket_details (p_op_code,p_argument);
523: FETCH c_get_ticket_details INTO l_ticket,l_operation, l_argument, l_edate;
524: CLOSE c_get_ticket_details;