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 232: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

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

Line 236: WSH_DEBUG_SV.push(l_module_name);

232: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
233: END IF;
234:
235: IF l_debug_on THEN
236: WSH_DEBUG_SV.push(l_module_name);
237: END IF;
238:
239:
240: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

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;
245:
246: l_profiles := load_profiles();
247:

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

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

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

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

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

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

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

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

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

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

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

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

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

287: l_servlet_uri := G_WSH_OTM_SERVLET_URI; ---||'?'||l_context_params;
288:
289: IF (l_debug_on) THEN
290: --5226917
291: --WSH_DEBUG_SV.log(l_module_name,'l_context_params='||l_context_params);
292: WSH_DEBUG_SV.log(l_module_name,'l_servlet_uri='||l_servlet_uri);
293: WSH_DEBUG_SV.log(l_module_name,'to_char(length(l_context_params))='||to_char(length(l_context_params)));
294:
295: END IF;

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

288:
289: IF (l_debug_on) THEN
290: --5226917
291: --WSH_DEBUG_SV.log(l_module_name,'l_context_params='||l_context_params);
292: WSH_DEBUG_SV.log(l_module_name,'l_servlet_uri='||l_servlet_uri);
293: WSH_DEBUG_SV.log(l_module_name,'to_char(length(l_context_params))='||to_char(length(l_context_params)));
294:
295: END IF;
296:

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

289: IF (l_debug_on) THEN
290: --5226917
291: --WSH_DEBUG_SV.log(l_module_name,'l_context_params='||l_context_params);
292: WSH_DEBUG_SV.log(l_module_name,'l_servlet_uri='||l_servlet_uri);
293: WSH_DEBUG_SV.log(l_module_name,'to_char(length(l_context_params))='||to_char(length(l_context_params)));
294:
295: END IF;
296:
297:

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

296:
297:
298: IF(is_SSL_Enabled(G_WSH_OTM_SERVLET_URI) = 'Y') THEN
299: IF (l_debug_on) THEN
300: WSH_DEBUG_SV.log(l_module_name,'SSL is enabled');
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:

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

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

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

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

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

327: l_amt:= 32000;
328: l_pos:= 1;
329: l_length:=DBMS_LOB.GETLENGTH(l_context_params);
330: IF (l_debug_on) THEN
331: WSH_DEBUG_SV.log(l_module_name,'Length',l_length);
332: END IF;
333: WHILE(l_length > 0)
334: LOOP
335: --{

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

337: THEN
338: l_amt:=l_length;
339: END IF;
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;

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

351:
352: --END IF;
353:
354: IF (l_debug_on) THEN
355: WSH_DEBUG_SV.log(l_module_name,'HTTP response status code:='||l_response.status_code);
356: WSH_DEBUG_SV.log(l_module_name,'HTTP response reason phras:='||l_response.reason_phrase);
357: --WSH_DEBUG_SV.log(l_module_name,'l_resp_pieces.COUNT='||l_resp_pieces.COUNT);
358: END IF;
359:

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

352: --END IF;
353:
354: IF (l_debug_on) THEN
355: WSH_DEBUG_SV.log(l_module_name,'HTTP response status code:='||l_response.status_code);
356: WSH_DEBUG_SV.log(l_module_name,'HTTP response reason phras:='||l_response.reason_phrase);
357: --WSH_DEBUG_SV.log(l_module_name,'l_resp_pieces.COUNT='||l_resp_pieces.COUNT);
358: END IF;
359:
360: IF l_response.status_code = 500 THEN

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

353:
354: IF (l_debug_on) THEN
355: WSH_DEBUG_SV.log(l_module_name,'HTTP response status code:='||l_response.status_code);
356: WSH_DEBUG_SV.log(l_module_name,'HTTP response reason phras:='||l_response.reason_phrase);
357: --WSH_DEBUG_SV.log(l_module_name,'l_resp_pieces.COUNT='||l_resp_pieces.COUNT);
358: END IF;
359:
360: IF l_response.status_code = 500 THEN
361: RAISE wsh_otm_unavailable_exception;

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

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;
371: END LOOP;
372: EXCEPTION

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

380:
381: x_response := l_clob_response;--l_response;
382:
383: IF l_debug_on THEN
384: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
385: WSH_DEBUG_SV.pop(l_module_name);
386: END IF;
387:
388: EXCEPTION

Line 385: WSH_DEBUG_SV.pop(l_module_name);

381: x_response := l_clob_response;--l_response;
382:
383: IF l_debug_on THEN
384: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
385: WSH_DEBUG_SV.pop(l_module_name);
386: END IF;
387:
388: EXCEPTION
389: WHEN wsh_null_otm_response THEN

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

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

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

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;
395: WHEN wsh_otm_unavailable_exception THEN
396: x_return_status := FND_API.G_RET_STS_ERROR;
397: IF l_debug_on THEN

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

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

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

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;
401: WHEN wsh_otm_load_profile_failed 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_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;
407: WHEN UTL_HTTP.INIT_FAILED THEN
408: BEGIN

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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;
464: EXCEPTION
465: WHEN OTHERS THEN

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

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;
464: EXCEPTION
465: WHEN OTHERS THEN
466: x_return_status := FND_API.G_RET_STS_ERROR;

Line 513: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

509: BEGIN
510:
511: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
512: IF l_debug_on IS NULL THEN
513: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
514: END IF;
515:
516: IF l_debug_on THEN
517: WSH_DEBUG_SV.push(l_module_name);

Line 517: WSH_DEBUG_SV.push(l_module_name);

513: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
514: END IF;
515:
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:

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

524: CLOSE c_get_ticket_details;
525:
526: IF l_debug_on THEN
527: --5226917
528: --WSH_DEBUG_SV.log(l_module_name,'l_ticket='||l_ticket);
529: WSH_DEBUG_SV.log(l_module_name,'l_operation='||l_operation);
530: WSH_DEBUG_SV.log(l_module_name,'l_argument='||l_argument);
531: WSH_DEBUG_SV.log(l_module_name,'l_edate='||l_edate);
532: END IF;

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

525:
526: IF l_debug_on THEN
527: --5226917
528: --WSH_DEBUG_SV.log(l_module_name,'l_ticket='||l_ticket);
529: WSH_DEBUG_SV.log(l_module_name,'l_operation='||l_operation);
530: WSH_DEBUG_SV.log(l_module_name,'l_argument='||l_argument);
531: WSH_DEBUG_SV.log(l_module_name,'l_edate='||l_edate);
532: END IF;
533: --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 530: WSH_DEBUG_SV.log(l_module_name,'l_argument='||l_argument);

526: IF l_debug_on THEN
527: --5226917
528: --WSH_DEBUG_SV.log(l_module_name,'l_ticket='||l_ticket);
529: WSH_DEBUG_SV.log(l_module_name,'l_operation='||l_operation);
530: WSH_DEBUG_SV.log(l_module_name,'l_argument='||l_argument);
531: WSH_DEBUG_SV.log(l_module_name,'l_edate='||l_edate);
532: END IF;
533: --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'));
534:

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

527: --5226917
528: --WSH_DEBUG_SV.log(l_module_name,'l_ticket='||l_ticket);
529: WSH_DEBUG_SV.log(l_module_name,'l_operation='||l_operation);
530: WSH_DEBUG_SV.log(l_module_name,'l_argument='||l_argument);
531: WSH_DEBUG_SV.log(l_module_name,'l_edate='||l_edate);
532: END IF;
533: --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'));
534:
535: -- Ticket Exists. Valid and not expired

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

539: CLOSE c_get_sysdate;
540:
541: IF ( l_edate IS NOT NULL) AND ( l_edate > SYSDATE) THEN
542: IF l_debug_on THEN
543: WSH_DEBUG_SV.log(l_module_name,'Ticket Exists. Valid and not expired');
544: END IF;
545: -- l_ticket is actual ticket. Do Nothing.
546: -- Ticket Exists but expired.Delete existing
547: ELSIF ( l_edate IS NOT NULL) AND ( l_edate < SYSDATE) THEN

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

545: -- l_ticket is actual ticket. Do Nothing.
546: -- Ticket Exists but expired.Delete existing
547: ELSIF ( 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 but expired.Delete existing');
550: WSH_DEBUG_SV.log(l_module_name,'Deleting...');
551: END IF;
552: FND_HTTP_TICKET.DESTROY_TICKET(l_ticket);
553: IF l_debug_on THEN

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

546: -- Ticket Exists but expired.Delete existing
547: ELSIF ( 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 but expired.Delete existing');
550: WSH_DEBUG_SV.log(l_module_name,'Deleting...');
551: END IF;
552: FND_HTTP_TICKET.DESTROY_TICKET(l_ticket);
553: IF l_debug_on THEN
554: WSH_DEBUG_SV.log(l_module_name,'Creating new ticket...');

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

550: WSH_DEBUG_SV.log(l_module_name,'Deleting...');
551: END IF;
552: FND_HTTP_TICKET.DESTROY_TICKET(l_ticket);
553: IF l_debug_on THEN
554: WSH_DEBUG_SV.log(l_module_name,'Creating new ticket...');
555: END IF;
556: l_ticket := FND_HTTP_TICKET.CREATE_TICKET(p_op_code
557: ,p_argument
558: ,G_WSH_TKT_LIFESPAN

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

558: ,G_WSH_TKT_LIFESPAN
559: );
560: --5226917
561: --IF l_debug_on THEN
562: -- WSH_DEBUG_SV.log(l_module_name,'new l_ticket='||l_ticket);
563: --END IF;
564: -- ticket doesn't exist . Get a new ticket.
565: --FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'x_end_date='||x_end_date);
566: ELSE

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

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

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

576: x_ticket := l_ticket;
577:
578: --5226917
579: --IF l_debug_on THEN
580: -- WSH_DEBUG_SV.log(l_module_name,'l_ticket='||x_ticket);
581: --END IF;
582:
583: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
584:

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

582:
583: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
584:
585: IF l_debug_on THEN
586: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
587: WSH_DEBUG_SV.pop(l_module_name);
588: END IF;
589:
590: EXCEPTION

Line 587: WSH_DEBUG_SV.pop(l_module_name);

583: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
584:
585: IF l_debug_on THEN
586: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
587: WSH_DEBUG_SV.pop(l_module_name);
588: END IF;
589:
590: EXCEPTION
591: WHEN others THEN

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

590: EXCEPTION
591: WHEN others THEN
592: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
593: IF l_debug_on THEN
594: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
595: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
596: END IF;
597:
598: END get_secure_ticket_details;

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

591: WHEN others THEN
592: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
593: IF l_debug_on THEN
594: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
595: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
596: END IF;
597:
598: END get_secure_ticket_details;
599: