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 WSH_DEBUG_SV

Line 54: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

50:
51: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
52: IF l_debug_on IS NULL
53: THEN
54: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
55: END IF;
56:
57: IF l_debug_on THEN
58: WSH_DEBUG_SV.push(l_module_name);

Line 58: WSH_DEBUG_SV.push(l_module_name);

54: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
55: END IF;
56:
57: IF l_debug_on THEN
58: WSH_DEBUG_SV.push(l_module_name);
59: END IF;
60:
61: G_ENC_STYLE := FND_PROFILE.VALUE('ICX_CLIENT_IANA_ENCODING');
62: G_WSH_OTM_SERVLET_URI := FND_PROFILE.value('APPS_FRAMEWORK_AGENT')||'/OA_HTML/wshRequestRates';

Line 80: WSH_DEBUG_SV.logmsg(l_module_name,'OTM Servlet URI profile can not be null ',WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

76: FND_MESSAGE.SET_NAME('WSH','WSH_PROFILE_NOT_SET_ERR');
77: FND_MESSAGE.SET_TOKEN('PRF_NAME',fnd_message.get_string('WSH','WSH_OTM_SERVLET_URI'));
78: FND_MSG_PUB.ADD;
79: IF l_debug_on THEN
80: WSH_DEBUG_SV.logmsg(l_module_name,'OTM Servlet URI profile can not be null ',WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
81: END IF;
82: END IF;
83:
84: IF ( (G_OTM_UNAME IS NULL ) OR ( length(G_OTM_UNAME) = 0)) THEN

Line 89: WSH_DEBUG_SV.logmsg(l_module_name,'OTM user name profile can not be null ',WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

85: FND_MESSAGE.SET_NAME('WSH','WSH_PROFILE_NOT_SET_ERR');
86: FND_MESSAGE.SET_TOKEN('PRF_NAME',fnd_message.get_string('WSH','WSH_OTM_USER_ID'));
87: FND_MSG_PUB.ADD;
88: IF l_debug_on THEN
89: WSH_DEBUG_SV.logmsg(l_module_name,'OTM user name profile can not be null ',WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
90: END IF;
91: END IF;
92:
93: IF ( (G_OTM_PSWD IS NULL) OR (length(G_OTM_PSWD) = 0)) THEN

Line 98: WSH_DEBUG_SV.logmsg(l_module_name,'OTM user password profile can not be null',WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

94: FND_MESSAGE.SET_NAME('WSH','WSH_PROFILE_NOT_SET_ERR');
95: FND_MESSAGE.SET_TOKEN('PRF_NAME',fnd_message.get_string('WSH','WSH_OTM_PASSWORD'));
96: FND_MSG_PUB.ADD;
97: IF l_debug_on THEN
98: WSH_DEBUG_SV.logmsg(l_module_name,'OTM user password profile can not be null',WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
99: END IF;
100: END IF;
101:
102: IF ((G_WSH_OTM_WS_ENDPOINT IS NULL ) OR (length(G_WSH_OTM_WS_ENDPOINT) = 0) OR

Line 123: WSH_DEBUG_SV.log(l_module_name,'g_wsh_otm_servlet_uri='||G_WSH_OTM_SERVLET_URI);

119: END IF;
120: END IF;
121:
122: IF l_debug_on THEN
123: WSH_DEBUG_SV.log(l_module_name,'g_wsh_otm_servlet_uri='||G_WSH_OTM_SERVLET_URI);
124: WSH_DEBUG_SV.log(l_module_name,'g_wsh_otm_ws_endpoint='||G_WSH_OTM_WS_ENDPOINT);
125: WSH_DEBUG_SV.log(l_module_name,'g_wsh_otm_proxy_server='||G_WSH_OTM_PROXY_SERVER);
126: WSH_DEBUG_SV.log(l_module_name,'g_wsh_otm_proxy_port='||G_WSH_OTM_PROXY_PORT);
127: WSH_DEBUG_SV.log(l_module_name,'G_OTM_UNAME='||G_OTM_UNAME);

Line 124: WSH_DEBUG_SV.log(l_module_name,'g_wsh_otm_ws_endpoint='||G_WSH_OTM_WS_ENDPOINT);

120: END IF;
121:
122: IF l_debug_on THEN
123: WSH_DEBUG_SV.log(l_module_name,'g_wsh_otm_servlet_uri='||G_WSH_OTM_SERVLET_URI);
124: WSH_DEBUG_SV.log(l_module_name,'g_wsh_otm_ws_endpoint='||G_WSH_OTM_WS_ENDPOINT);
125: WSH_DEBUG_SV.log(l_module_name,'g_wsh_otm_proxy_server='||G_WSH_OTM_PROXY_SERVER);
126: WSH_DEBUG_SV.log(l_module_name,'g_wsh_otm_proxy_port='||G_WSH_OTM_PROXY_PORT);
127: WSH_DEBUG_SV.log(l_module_name,'G_OTM_UNAME='||G_OTM_UNAME);
128: WSH_DEBUG_SV.log(l_module_name,'G_OTM_PSWD'||G_OTM_PSWD);

Line 125: WSH_DEBUG_SV.log(l_module_name,'g_wsh_otm_proxy_server='||G_WSH_OTM_PROXY_SERVER);

121:
122: IF l_debug_on THEN
123: WSH_DEBUG_SV.log(l_module_name,'g_wsh_otm_servlet_uri='||G_WSH_OTM_SERVLET_URI);
124: WSH_DEBUG_SV.log(l_module_name,'g_wsh_otm_ws_endpoint='||G_WSH_OTM_WS_ENDPOINT);
125: WSH_DEBUG_SV.log(l_module_name,'g_wsh_otm_proxy_server='||G_WSH_OTM_PROXY_SERVER);
126: WSH_DEBUG_SV.log(l_module_name,'g_wsh_otm_proxy_port='||G_WSH_OTM_PROXY_PORT);
127: WSH_DEBUG_SV.log(l_module_name,'G_OTM_UNAME='||G_OTM_UNAME);
128: WSH_DEBUG_SV.log(l_module_name,'G_OTM_PSWD'||G_OTM_PSWD);
129: WSH_DEBUG_SV.pop(l_module_name);

Line 126: WSH_DEBUG_SV.log(l_module_name,'g_wsh_otm_proxy_port='||G_WSH_OTM_PROXY_PORT);

122: IF l_debug_on THEN
123: WSH_DEBUG_SV.log(l_module_name,'g_wsh_otm_servlet_uri='||G_WSH_OTM_SERVLET_URI);
124: WSH_DEBUG_SV.log(l_module_name,'g_wsh_otm_ws_endpoint='||G_WSH_OTM_WS_ENDPOINT);
125: WSH_DEBUG_SV.log(l_module_name,'g_wsh_otm_proxy_server='||G_WSH_OTM_PROXY_SERVER);
126: WSH_DEBUG_SV.log(l_module_name,'g_wsh_otm_proxy_port='||G_WSH_OTM_PROXY_PORT);
127: WSH_DEBUG_SV.log(l_module_name,'G_OTM_UNAME='||G_OTM_UNAME);
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;

Line 127: WSH_DEBUG_SV.log(l_module_name,'G_OTM_UNAME='||G_OTM_UNAME);

123: WSH_DEBUG_SV.log(l_module_name,'g_wsh_otm_servlet_uri='||G_WSH_OTM_SERVLET_URI);
124: WSH_DEBUG_SV.log(l_module_name,'g_wsh_otm_ws_endpoint='||G_WSH_OTM_WS_ENDPOINT);
125: WSH_DEBUG_SV.log(l_module_name,'g_wsh_otm_proxy_server='||G_WSH_OTM_PROXY_SERVER);
126: WSH_DEBUG_SV.log(l_module_name,'g_wsh_otm_proxy_port='||G_WSH_OTM_PROXY_PORT);
127: WSH_DEBUG_SV.log(l_module_name,'G_OTM_UNAME='||G_OTM_UNAME);
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:

Line 128: WSH_DEBUG_SV.log(l_module_name,'G_OTM_PSWD'||G_OTM_PSWD);

124: WSH_DEBUG_SV.log(l_module_name,'g_wsh_otm_ws_endpoint='||G_WSH_OTM_WS_ENDPOINT);
125: WSH_DEBUG_SV.log(l_module_name,'g_wsh_otm_proxy_server='||G_WSH_OTM_PROXY_SERVER);
126: WSH_DEBUG_SV.log(l_module_name,'g_wsh_otm_proxy_port='||G_WSH_OTM_PROXY_PORT);
127: WSH_DEBUG_SV.log(l_module_name,'G_OTM_UNAME='||G_OTM_UNAME);
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;

Line 129: WSH_DEBUG_SV.pop(l_module_name);

125: WSH_DEBUG_SV.log(l_module_name,'g_wsh_otm_proxy_server='||G_WSH_OTM_PROXY_SERVER);
126: WSH_DEBUG_SV.log(l_module_name,'g_wsh_otm_proxy_port='||G_WSH_OTM_PROXY_PORT);
127: WSH_DEBUG_SV.log(l_module_name,'G_OTM_UNAME='||G_OTM_UNAME);
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:

Line 137: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_otm_endpoint_null');

133:
134: EXCEPTION
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

Line 142: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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');
144: END IF;
145: RETURN FND_API.G_RET_STS_ERROR;
146: END load_profiles;

Line 143: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

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');
144: END IF;
145: RETURN FND_API.G_RET_STS_ERROR;
146: END load_profiles;
147:

Line 235: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

231:
232: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
233: IF l_debug_on IS NULL
234: THEN
235: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
236: END IF;
237:
238: IF l_debug_on THEN
239: WSH_DEBUG_SV.push(l_module_name);

Line 239: WSH_DEBUG_SV.push(l_module_name);

235: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
236: END IF;
237:
238: IF l_debug_on THEN
239: WSH_DEBUG_SV.push(l_module_name);
240: END IF;
241:
242:
243: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 246: WSH_DEBUG_SV.log(l_module_name,'before load profiles');

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;
248:
249: l_profiles := load_profiles();
250:

Line 253: WSH_DEBUG_SV.log(l_module_name,'l_profiles='||l_profiles);

249: l_profiles := load_profiles();
250:
251:
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;

Line 261: WSH_DEBUG_SV.log(l_module_name,'After load profiles');

257: RAISE wsh_otm_load_profile_failed;
258: END IF;
259:
260: IF (l_debug_on) THEN
261: WSH_DEBUG_SV.log(l_module_name,'After load profiles');
262: END IF;
263:
264: get_secure_ticket_details ( p_op_code => G_WSH_TKT_OP_CODE,
265: p_argument => G_WSH_TKT_ARGUMENT_VALUE,

Line 270: WSH_DEBUG_SV.log(l_module_name,'After get secure tkt');

266: x_ticket => l_fnd_ticket,
267: x_server_time_zone => l_server_tz,
268: x_return_status => l_return_status);
269: IF (l_debug_on) THEN
270: WSH_DEBUG_SV.log(l_module_name,'After get secure tkt');
271: END IF;
272: IF (l_debug_on) THEN
273: WSH_DEBUG_SV.log(l_module_name,'l_return_status='||l_return_status);
274: END IF;

Line 273: WSH_DEBUG_SV.log(l_module_name,'l_return_status='||l_return_status);

269: IF (l_debug_on) THEN
270: WSH_DEBUG_SV.log(l_module_name,'After get secure tkt');
271: END IF;
272: IF (l_debug_on) THEN
273: WSH_DEBUG_SV.log(l_module_name,'l_return_status='||l_return_status);
274: END IF;
275:
276: --5226917
277: --IF (l_debug_on) THEN

Line 278: --WSH_DEBUG_SV.log(l_module_name,'l_fnd_ticket='||l_fnd_ticket);

274: END IF;
275:
276: --5226917
277: --IF (l_debug_on) THEN
278: --WSH_DEBUG_SV.log(l_module_name,'l_fnd_ticket='||l_fnd_ticket);
279: --WSH_DEBUG_SV.log(l_module_name,'l_tkt_end_date='||l_tkt_end_date);
280: --END IF;
281:
282: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

Line 279: --WSH_DEBUG_SV.log(l_module_name,'l_tkt_end_date='||l_tkt_end_date);

275:
276: --5226917
277: --IF (l_debug_on) THEN
278: --WSH_DEBUG_SV.log(l_module_name,'l_fnd_ticket='||l_fnd_ticket);
279: --WSH_DEBUG_SV.log(l_module_name,'l_tkt_end_date='||l_tkt_end_date);
280: --END IF;
281:
282: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
283: raise g_tkt_error;

Line 297: --WSH_DEBUG_SV.log(l_module_name,'l_context_params='||l_context_params);

293: l_servlet_uri := G_WSH_OTM_SERVLET_URI; ---||'?'||l_context_params;
294:
295: IF (l_debug_on) THEN
296: --5226917
297: --WSH_DEBUG_SV.log(l_module_name,'l_context_params='||l_context_params);
298: WSH_DEBUG_SV.log(l_module_name,'l_servlet_uri='||l_servlet_uri);
299: WSH_DEBUG_SV.log(l_module_name,'to_char(length(l_context_params))='||to_char(length(l_context_params)));
300:
301: END IF;

Line 298: WSH_DEBUG_SV.log(l_module_name,'l_servlet_uri='||l_servlet_uri);

294:
295: IF (l_debug_on) THEN
296: --5226917
297: --WSH_DEBUG_SV.log(l_module_name,'l_context_params='||l_context_params);
298: WSH_DEBUG_SV.log(l_module_name,'l_servlet_uri='||l_servlet_uri);
299: WSH_DEBUG_SV.log(l_module_name,'to_char(length(l_context_params))='||to_char(length(l_context_params)));
300:
301: END IF;
302:

Line 299: WSH_DEBUG_SV.log(l_module_name,'to_char(length(l_context_params))='||to_char(length(l_context_params)));

295: IF (l_debug_on) THEN
296: --5226917
297: --WSH_DEBUG_SV.log(l_module_name,'l_context_params='||l_context_params);
298: WSH_DEBUG_SV.log(l_module_name,'l_servlet_uri='||l_servlet_uri);
299: WSH_DEBUG_SV.log(l_module_name,'to_char(length(l_context_params))='||to_char(length(l_context_params)));
300:
301: END IF;
302:
303:

Line 306: WSH_DEBUG_SV.log(l_module_name,'SSL is enabled');

302:
303:
304: IF(is_SSL_Enabled(G_WSH_OTM_SERVLET_URI) = 'Y') THEN
305: IF (l_debug_on) THEN
306: WSH_DEBUG_SV.log(l_module_name,'SSL is enabled');
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:

Line 307: WSH_DEBUG_SV.log(l_module_name,'g_wallet_path='||G_WALLET_PATH);

303:
304: IF(is_SSL_Enabled(G_WSH_OTM_SERVLET_URI) = 'Y') THEN
305: IF (l_debug_on) THEN
306: WSH_DEBUG_SV.log(l_module_name,'SSL is enabled');
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);

Line 308: WSH_DEBUG_SV.log(l_module_name,'g_wallet_password='||G_WALLET_PASSWORD);

304: IF(is_SSL_Enabled(G_WSH_OTM_SERVLET_URI) = 'Y') THEN
305: IF (l_debug_on) THEN
306: WSH_DEBUG_SV.log(l_module_name,'SSL is enabled');
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:

Line 337: WSH_DEBUG_SV.log(l_module_name,'Length',l_length);

333: l_amt:= 32000;
334: l_pos:= 1;
335: l_length:=DBMS_LOB.GETLENGTH(l_context_params);
336: IF (l_debug_on) THEN
337: WSH_DEBUG_SV.log(l_module_name,'Length',l_length);
338: END IF;
339: WHILE(l_length > 0)
340: LOOP
341: --{

Line 347: WSH_DEBUG_SV.log(l_module_name,'l_amt', l_amt);

343: THEN
344: l_amt:=l_length;
345: END IF;
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;

Line 361: WSH_DEBUG_SV.log(l_module_name,'HTTP response status code:='||l_response.status_code);

357:
358: --END IF;
359:
360: IF (l_debug_on) THEN
361: WSH_DEBUG_SV.log(l_module_name,'HTTP response status code:='||l_response.status_code);
362: WSH_DEBUG_SV.log(l_module_name,'HTTP response reason phras:='||l_response.reason_phrase);
363: --WSH_DEBUG_SV.log(l_module_name,'l_resp_pieces.COUNT='||l_resp_pieces.COUNT);
364: END IF;
365:

Line 362: WSH_DEBUG_SV.log(l_module_name,'HTTP response reason phras:='||l_response.reason_phrase);

358: --END IF;
359:
360: IF (l_debug_on) THEN
361: WSH_DEBUG_SV.log(l_module_name,'HTTP response status code:='||l_response.status_code);
362: WSH_DEBUG_SV.log(l_module_name,'HTTP response reason phras:='||l_response.reason_phrase);
363: --WSH_DEBUG_SV.log(l_module_name,'l_resp_pieces.COUNT='||l_resp_pieces.COUNT);
364: END IF;
365:
366: IF l_response.status_code = 500 THEN

Line 363: --WSH_DEBUG_SV.log(l_module_name,'l_resp_pieces.COUNT='||l_resp_pieces.COUNT);

359:
360: IF (l_debug_on) THEN
361: WSH_DEBUG_SV.log(l_module_name,'HTTP response status code:='||l_response.status_code);
362: WSH_DEBUG_SV.log(l_module_name,'HTTP response reason phras:='||l_response.reason_phrase);
363: --WSH_DEBUG_SV.log(l_module_name,'l_resp_pieces.COUNT='||l_resp_pieces.COUNT);
364: END IF;
365:
366: IF l_response.status_code = 500 THEN
367: RAISE wsh_otm_unavailable_exception;

Line 374: WSH_DEBUG_SV.log(l_module_name,'Line ='||l_response_data);

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;
377: END LOOP;
378: EXCEPTION

Line 390: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);

386:
387: x_response := l_clob_response;--l_response;
388:
389: IF l_debug_on THEN
390: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
391: WSH_DEBUG_SV.pop(l_module_name);
392: END IF;
393:
394: EXCEPTION

Line 391: WSH_DEBUG_SV.pop(l_module_name);

387: x_response := l_clob_response;--l_response;
388:
389: IF l_debug_on THEN
390: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
391: WSH_DEBUG_SV.pop(l_module_name);
392: END IF;
393:
394: EXCEPTION
395: WHEN wsh_null_otm_response THEN

Line 398: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status='||x_return_status);

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;
401: WHEN wsh_otm_unavailable_exception THEN
402: x_return_status := FND_API.G_RET_STS_ERROR;

Line 399: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_null_otm_response: Null response received.');

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;
401: WHEN wsh_otm_unavailable_exception THEN
402: x_return_status := FND_API.G_RET_STS_ERROR;
403: IF l_debug_on THEN

Line 404: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status='||x_return_status);

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;
407: WHEN wsh_otm_load_profile_failed THEN
408: x_return_status := FND_API.G_RET_STS_ERROR;

Line 405: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_otm_unavailable_exception: OTM Server is down. Contact the System Administrator');

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;
407: WHEN wsh_otm_load_profile_failed THEN
408: x_return_status := FND_API.G_RET_STS_ERROR;
409: IF l_debug_on THEN

Line 410: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status='||x_return_status);

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;
413: WHEN UTL_HTTP.INIT_FAILED THEN
414: BEGIN

Line 411: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_otm_load_profile_failed');

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;
413: WHEN UTL_HTTP.INIT_FAILED THEN
414: BEGIN
415: EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlcode from dual' INTO x_return_status;

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

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;
424: WHEN UTL_HTTP.REQUEST_FAILED THEN

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

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;
438: END;
439: WHEN UTL_TCP.END_OF_INPUT THEN

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 443: WSH_DEBUG_SV.logmsg(l_module_name,'HTTP request failed because of UTL_TCP.END_OF_INPUT');

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

Line 444: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status='||x_return_status||' l_return_status_text='||l_return_status_text);

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

Line 445: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:UTL_TCP.END_OF_INPUT');

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

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 456: WSH_DEBUG_SV.logmsg(l_module_name,'g_tkt_error has occured.',WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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;
459: WHEN others THEN
460: x_return_status := FND_API.G_RET_STS_ERROR;

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 462: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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;
465: EXECUTE IMMEDIATE 'SELECT UTL_HTTP.get_detailed_sqlerrm from dual' INTO l_return_status_text;
466: IF l_debug_on THEN

Line 467: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status='||x_return_status||' l_return_status_text='||l_return_status_text);

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;
470: EXCEPTION
471: WHEN OTHERS THEN

Line 468: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

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;
470: EXCEPTION
471: WHEN OTHERS THEN
472: x_return_status := FND_API.G_RET_STS_ERROR;

Line 519: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

515: BEGIN
516:
517: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
518: IF l_debug_on IS NULL THEN
519: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
520: END IF;
521:
522: IF l_debug_on THEN
523: WSH_DEBUG_SV.push(l_module_name);

Line 523: WSH_DEBUG_SV.push(l_module_name);

519: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
520: END IF;
521:
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:

Line 534: --WSH_DEBUG_SV.log(l_module_name,'l_ticket='||l_ticket);

530: CLOSE c_get_ticket_details;
531:
532: IF l_debug_on THEN
533: --5226917
534: --WSH_DEBUG_SV.log(l_module_name,'l_ticket='||l_ticket);
535: WSH_DEBUG_SV.log(l_module_name,'l_operation='||l_operation);
536: WSH_DEBUG_SV.log(l_module_name,'l_argument='||l_argument);
537: WSH_DEBUG_SV.log(l_module_name,'l_edate='||l_edate);
538: END IF;

Line 535: WSH_DEBUG_SV.log(l_module_name,'l_operation='||l_operation);

531:
532: IF l_debug_on THEN
533: --5226917
534: --WSH_DEBUG_SV.log(l_module_name,'l_ticket='||l_ticket);
535: WSH_DEBUG_SV.log(l_module_name,'l_operation='||l_operation);
536: WSH_DEBUG_SV.log(l_module_name,'l_argument='||l_argument);
537: WSH_DEBUG_SV.log(l_module_name,'l_edate='||l_edate);
538: END IF;
539: --FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'sysdate='||to_date(to_char(sysdate,'yyyy/mm/dd hh:mi:ss'),'yyyy/mm/dd hh:mi:ss'));

Line 536: WSH_DEBUG_SV.log(l_module_name,'l_argument='||l_argument);

532: IF l_debug_on THEN
533: --5226917
534: --WSH_DEBUG_SV.log(l_module_name,'l_ticket='||l_ticket);
535: WSH_DEBUG_SV.log(l_module_name,'l_operation='||l_operation);
536: WSH_DEBUG_SV.log(l_module_name,'l_argument='||l_argument);
537: WSH_DEBUG_SV.log(l_module_name,'l_edate='||l_edate);
538: END IF;
539: --FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'sysdate='||to_date(to_char(sysdate,'yyyy/mm/dd hh:mi:ss'),'yyyy/mm/dd hh:mi:ss'));
540:

Line 537: WSH_DEBUG_SV.log(l_module_name,'l_edate='||l_edate);

533: --5226917
534: --WSH_DEBUG_SV.log(l_module_name,'l_ticket='||l_ticket);
535: WSH_DEBUG_SV.log(l_module_name,'l_operation='||l_operation);
536: WSH_DEBUG_SV.log(l_module_name,'l_argument='||l_argument);
537: WSH_DEBUG_SV.log(l_module_name,'l_edate='||l_edate);
538: END IF;
539: --FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'sysdate='||to_date(to_char(sysdate,'yyyy/mm/dd hh:mi:ss'),'yyyy/mm/dd hh:mi:ss'));
540:
541: -- Ticket Exists. Valid and not expired

Line 549: WSH_DEBUG_SV.log(l_module_name,'Ticket Exists. Valid and not expired');

545: CLOSE c_get_sysdate;
546:
547: IF ( l_edate IS NOT NULL) AND ( l_edate > SYSDATE) THEN
548: IF l_debug_on THEN
549: WSH_DEBUG_SV.log(l_module_name,'Ticket Exists. Valid and not expired');
550: END IF;
551: -- l_ticket is actual ticket. Do Nothing.
552: -- Ticket Exists but expired.Delete existing
553: ELSIF ( l_edate IS NOT NULL) AND ( l_edate < SYSDATE) THEN

Line 555: WSH_DEBUG_SV.log(l_module_name,'Ticket Exists but expired.Delete existing');

551: -- l_ticket is actual ticket. Do Nothing.
552: -- Ticket Exists but expired.Delete existing
553: ELSIF ( l_edate IS NOT NULL) AND ( l_edate < SYSDATE) THEN
554: IF l_debug_on THEN
555: WSH_DEBUG_SV.log(l_module_name,'Ticket Exists but expired.Delete existing');
556: WSH_DEBUG_SV.log(l_module_name,'Deleting...');
557: END IF;
558: FND_HTTP_TICKET.DESTROY_TICKET(l_ticket);
559: IF l_debug_on THEN

Line 556: WSH_DEBUG_SV.log(l_module_name,'Deleting...');

552: -- Ticket Exists but expired.Delete existing
553: ELSIF ( l_edate IS NOT NULL) AND ( l_edate < SYSDATE) THEN
554: IF l_debug_on THEN
555: WSH_DEBUG_SV.log(l_module_name,'Ticket Exists but expired.Delete existing');
556: WSH_DEBUG_SV.log(l_module_name,'Deleting...');
557: END IF;
558: FND_HTTP_TICKET.DESTROY_TICKET(l_ticket);
559: IF l_debug_on THEN
560: WSH_DEBUG_SV.log(l_module_name,'Creating new ticket...');

Line 560: WSH_DEBUG_SV.log(l_module_name,'Creating new ticket...');

556: WSH_DEBUG_SV.log(l_module_name,'Deleting...');
557: END IF;
558: FND_HTTP_TICKET.DESTROY_TICKET(l_ticket);
559: IF l_debug_on THEN
560: WSH_DEBUG_SV.log(l_module_name,'Creating new ticket...');
561: END IF;
562: l_ticket := FND_HTTP_TICKET.CREATE_TICKET(p_op_code
563: ,p_argument
564: ,G_WSH_TKT_LIFESPAN

Line 568: -- WSH_DEBUG_SV.log(l_module_name,'new l_ticket='||l_ticket);

564: ,G_WSH_TKT_LIFESPAN
565: );
566: --5226917
567: --IF l_debug_on THEN
568: -- WSH_DEBUG_SV.log(l_module_name,'new l_ticket='||l_ticket);
569: --END IF;
570: -- ticket doesn't exist . Get a new ticket.
571: --FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'x_end_date='||x_end_date);
572: ELSE

Line 574: WSH_DEBUG_SV.log(l_module_name,'ticket doesnt exist . Create a new ticket');

570: -- ticket doesn't exist . Get a new ticket.
571: --FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'x_end_date='||x_end_date);
572: ELSE
573: IF l_debug_on THEN
574: WSH_DEBUG_SV.log(l_module_name,'ticket doesnt exist . Create a new ticket');
575: END IF;
576: l_ticket := FND_HTTP_TICKET.CREATE_TICKET(p_op_code
577: ,p_argument
578: ,G_WSH_TKT_LIFESPAN

Line 586: -- WSH_DEBUG_SV.log(l_module_name,'l_ticket='||x_ticket);

582: x_ticket := l_ticket;
583:
584: --5226917
585: --IF l_debug_on THEN
586: -- WSH_DEBUG_SV.log(l_module_name,'l_ticket='||x_ticket);
587: --END IF;
588:
589: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
590:

Line 592: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);

588:
589: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
590:
591: IF l_debug_on THEN
592: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
593: WSH_DEBUG_SV.pop(l_module_name);
594: END IF;
595:
596: EXCEPTION

Line 593: WSH_DEBUG_SV.pop(l_module_name);

589: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
590:
591: IF l_debug_on THEN
592: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
593: WSH_DEBUG_SV.pop(l_module_name);
594: END IF;
595:
596: EXCEPTION
597: WHEN others THEN

Line 600: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

596: EXCEPTION
597: WHEN others THEN
598: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
599: IF l_debug_on THEN
600: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
601: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
602: END IF;
603:
604: END get_secure_ticket_details;

Line 601: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

597: WHEN others THEN
598: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
599: IF l_debug_on THEN
600: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
601: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
602: END IF;
603:
604: END get_secure_ticket_details;
605: