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 243: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 256: IF l_profiles = FND_API.G_RET_STS_ERROR THEN

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

Line 396: x_return_status := FND_API.G_RET_STS_ERROR;

392: END IF;
393:
394: EXCEPTION
395: WHEN wsh_null_otm_response 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_null_otm_response: Null response received.');
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_null_otm_response: Null response received.');
400: END IF;
401: WHEN wsh_otm_unavailable_exception 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_unavailable_exception: OTM Server is down. Contact the System Administrator');
406: END IF;

Line 408: x_return_status := FND_API.G_RET_STS_ERROR;

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_unavailable_exception: OTM Server is down. Contact the System Administrator');
406: END IF;
407: WHEN wsh_otm_load_profile_failed THEN
408: x_return_status := FND_API.G_RET_STS_ERROR;
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;

Line 416: x_return_status := FND_API.G_RET_STS_ERROR;

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

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

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

Line 432: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 440: x_return_status := FND_API.G_RET_STS_ERROR;

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;
441: l_return_status_text := 'UTL_TCP.END_OF_INPUT';
442: IF l_debug_on THEN
443: WSH_DEBUG_SV.logmsg(l_module_name,'HTTP request failed because of UTL_TCP.END_OF_INPUT');
444: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status='||x_return_status||' l_return_status_text='||l_return_status_text);

Line 447: WHEN FND_API.G_EXC_ERROR THEN

443: WSH_DEBUG_SV.logmsg(l_module_name,'HTTP request failed because of UTL_TCP.END_OF_INPUT');
444: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status='||x_return_status||' l_return_status_text='||l_return_status_text);
445: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:UTL_TCP.END_OF_INPUT');
446: END IF;
447: WHEN FND_API.G_EXC_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,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
451: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

Line 448: x_return_status := FND_API.G_RET_STS_ERROR;

444: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status='||x_return_status||' l_return_status_text='||l_return_status_text);
445: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:UTL_TCP.END_OF_INPUT');
446: END IF;
447: WHEN FND_API.G_EXC_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,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
451: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
452: END IF;

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

446: END IF;
447: WHEN FND_API.G_EXC_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,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
451: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
452: END IF;
453: WHEN g_tkt_error THEN
454: x_return_status := FND_API.G_RET_STS_ERROR;

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

447: WHEN FND_API.G_EXC_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,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
451: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
452: END IF;
453: WHEN g_tkt_error 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,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
451: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
452: END IF;
453: WHEN g_tkt_error 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,'g_tkt_error has occured.',WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
457: WSH_DEBUG_SV.pop(l_module_name,'FND_API.G_EXC_ERROR');
458: END IF;

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

453: WHEN g_tkt_error 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,'g_tkt_error has occured.',WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
457: WSH_DEBUG_SV.pop(l_module_name,'FND_API.G_EXC_ERROR');
458: END IF;
459: WHEN others THEN
460: x_return_status := FND_API.G_RET_STS_ERROR;
461: IF l_debug_on THEN

Line 460: x_return_status := FND_API.G_RET_STS_ERROR;

456: WSH_DEBUG_SV.logmsg(l_module_name,'g_tkt_error has occured.',WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
457: WSH_DEBUG_SV.pop(l_module_name,'FND_API.G_EXC_ERROR');
458: END IF;
459: WHEN others THEN
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;

Line 472: x_return_status := FND_API.G_RET_STS_ERROR;

468: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
469: END IF;
470: EXCEPTION
471: WHEN OTHERS THEN
472: x_return_status := FND_API.G_RET_STS_ERROR;
473: FND_MESSAGE.SET_NAME('WSH','WSH_UTL_POST_UNEXPECTED_ERROR');
474: l_return_status_text := FND_MESSAGE.GET;
475: END;
476: END IF;

Line 526: x_return_status := FND_API.G_RET_STS_SUCCESS;

522: IF l_debug_on THEN
523: WSH_DEBUG_SV.push(l_module_name);
524: END IF;
525:
526: x_return_status := FND_API.G_RET_STS_SUCCESS;
527:
528: OPEN c_get_ticket_details (p_op_code,p_argument);
529: FETCH c_get_ticket_details INTO l_ticket,l_operation, l_argument, l_edate;
530: CLOSE c_get_ticket_details;