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_REF_DATA_GEN_PKG dependencies on WSH_DEBUG_SV

Line 37: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

33: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
34: --
35: IF l_debug_on IS NULL
36: THEN
37: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
38: END IF;
39: --
40: --
41: -- Debug Statements

Line 44: WSH_DEBUG_SV.push(l_module_name);

40: --
41: -- Debug Statements
42: --
43: IF l_debug_on THEN
44: WSH_DEBUG_SV.push(l_module_name);
45: --
46: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_ID',P_LOCATION_ID);
47: WSH_DEBUG_SV.log(l_module_name,'P_CORPORATION_ID',P_CORPORATION_ID);
48: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_TYPE',P_LOCATION_TYPE);

Line 46: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_ID',P_LOCATION_ID);

42: --
43: IF l_debug_on THEN
44: WSH_DEBUG_SV.push(l_module_name);
45: --
46: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_ID',P_LOCATION_ID);
47: WSH_DEBUG_SV.log(l_module_name,'P_CORPORATION_ID',P_CORPORATION_ID);
48: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_TYPE',P_LOCATION_TYPE);
49: END IF;
50: --

Line 47: WSH_DEBUG_SV.log(l_module_name,'P_CORPORATION_ID',P_CORPORATION_ID);

43: IF l_debug_on THEN
44: WSH_DEBUG_SV.push(l_module_name);
45: --
46: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_ID',P_LOCATION_ID);
47: WSH_DEBUG_SV.log(l_module_name,'P_CORPORATION_ID',P_CORPORATION_ID);
48: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_TYPE',P_LOCATION_TYPE);
49: END IF;
50: --
51: x_return_status := wsh_util_core.g_ret_sts_success;

Line 48: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_TYPE',P_LOCATION_TYPE);

44: WSH_DEBUG_SV.push(l_module_name);
45: --
46: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_ID',P_LOCATION_ID);
47: WSH_DEBUG_SV.log(l_module_name,'P_CORPORATION_ID',P_CORPORATION_ID);
48: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_TYPE',P_LOCATION_TYPE);
49: END IF;
50: --
51: x_return_status := wsh_util_core.g_ret_sts_success;
52: --

Line 62: WSH_DEBUG_SV.pop(l_module_name);

58: --
59: -- Debug Statements
60: --
61: IF l_debug_on THEN
62: WSH_DEBUG_SV.pop(l_module_name);
63: END IF;
64: --
65: EXCEPTION
66: --{

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

70: --
71: -- Debug Statements
72: --
73: IF l_debug_on THEN
74: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
75: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
76: END IF;
77: --
78: END INSERT_ROW_IN_LOC_GTMP;

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

71: -- Debug Statements
72: --
73: IF l_debug_on THEN
74: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
75: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
76: END IF;
77: --
78: END INSERT_ROW_IN_LOC_GTMP;
79:

Line 166: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

162: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
163: --
164: IF l_debug_on IS NULL
165: THEN
166: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
167: END IF;
168: --
169: --
170: -- Debug Statements

Line 173: WSH_DEBUG_SV.push(l_module_name);

169: --
170: -- Debug Statements
171: --
172: IF l_debug_on THEN
173: WSH_DEBUG_SV.push(l_module_name);
174: --
175: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
176: WSH_DEBUG_SV.log(l_module_name,'P_LOC_TYPE',P_LOC_TYPE);
177: END IF;

Line 175: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);

171: --
172: IF l_debug_on THEN
173: WSH_DEBUG_SV.push(l_module_name);
174: --
175: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
176: WSH_DEBUG_SV.log(l_module_name,'P_LOC_TYPE',P_LOC_TYPE);
177: END IF;
178: --
179: IF (p_loc_type = 'HR') THEN

Line 176: WSH_DEBUG_SV.log(l_module_name,'P_LOC_TYPE',P_LOC_TYPE);

172: IF l_debug_on THEN
173: WSH_DEBUG_SV.push(l_module_name);
174: --
175: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
176: WSH_DEBUG_SV.log(l_module_name,'P_LOC_TYPE',P_LOC_TYPE);
177: END IF;
178: --
179: IF (p_loc_type = 'HR') THEN
180: open l_stop_dd_org_csr(p_stop_id);

Line 185: WSH_DEBUG_SV.log(l_module_name,'l_corporation_id after l_pickup_stop_org_csr',l_corporation_id);

181: fetch l_stop_dd_org_csr into l_corporation_id;
182: close l_stop_dd_org_csr;
183:
184: IF l_debug_on THEN
185: WSH_DEBUG_SV.log(l_module_name,'l_corporation_id after l_pickup_stop_org_csr',l_corporation_id);
186: END IF;
187:
188: IF (l_corporation_id is null) THEN
189: open l_stop_org_csr(p_stop_id);

Line 194: WSH_DEBUG_SV.log(l_module_name,'l_corporation_id after l_dropoff_stop_org_csr',l_corporation_id);

190: fetch l_stop_org_csr into l_corporation_id;
191: close l_stop_org_csr;
192:
193: IF l_debug_on THEN
194: WSH_DEBUG_SV.log(l_module_name,'l_corporation_id after l_dropoff_stop_org_csr',l_corporation_id);
195: END IF;
196: END IF;
197: ELSIF (p_loc_type = 'HZ') THEN
198: open l_stop_dd_cust_csr(p_stop_id);

Line 203: WSH_DEBUG_SV.log(l_module_name,'l_corporation_id after l_pickup_stop_cust_csr',l_corporation_id);

199: fetch l_stop_dd_cust_csr into l_corporation_id;
200: close l_stop_dd_cust_csr;
201:
202: IF l_debug_on THEN
203: WSH_DEBUG_SV.log(l_module_name,'l_corporation_id after l_pickup_stop_cust_csr',l_corporation_id);
204: END IF;
205:
206:
207: IF (l_corporation_id is null) THEN

Line 213: WSH_DEBUG_SV.log(l_module_name,'l_corporation_id after l_dropoff_stop_cust_csr',l_corporation_id);

209: fetch l_stop_cust_csr into l_corporation_id;
210: close l_stop_cust_csr;
211:
212: IF l_debug_on THEN
213: WSH_DEBUG_SV.log(l_module_name,'l_corporation_id after l_dropoff_stop_cust_csr',l_corporation_id);
214: END IF;
215: END IF;
216:
217: ELSE

Line 223: WSH_DEBUG_SV.pop(l_module_name);

219: END IF;
220: -- Debug Statements
221: --
222: IF l_debug_on THEN
223: WSH_DEBUG_SV.pop(l_module_name);
224: --
225: END IF;
226: return l_corporation_id;
227: --

Line 366: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

362: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
363: --
364: IF l_debug_on IS NULL
365: THEN
366: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
367: END IF;
368: --
369: --
370: -- Debug Statements

Line 373: WSH_DEBUG_SV.push(l_module_name);

369: --
370: -- Debug Statements
371: --
372: IF l_debug_on THEN
373: WSH_DEBUG_SV.push(l_module_name);
374: --
375: WSH_DEBUG_SV.log(l_module_name,'P_TRANSMISSION_ID',P_TRANSMISSION_ID);
376: END IF;
377: --

Line 375: WSH_DEBUG_SV.log(l_module_name,'P_TRANSMISSION_ID',P_TRANSMISSION_ID);

371: --
372: IF l_debug_on THEN
373: WSH_DEBUG_SV.push(l_module_name);
374: --
375: WSH_DEBUG_SV.log(l_module_name,'P_TRANSMISSION_ID',P_TRANSMISSION_ID);
376: END IF;
377: --
378: x_return_status := wsh_util_core.g_ret_sts_success;
379: --

Line 388: WSH_DEBUG_SV.log(l_module_name,'Delivery_Id('||i||')',p_entity_in_rec.entity_id_tbl(i));

384: --{
385: FOR i in p_entity_in_rec.entity_id_tbl.first..p_entity_in_rec.entity_id_tbl.last LOOP
386: --{
387: IF l_debug_on THEN
388: WSH_DEBUG_SV.log(l_module_name,'Delivery_Id('||i||')',p_entity_in_rec.entity_id_tbl(i));
389: END IF;
390: l_internal_loc_id := NULL;
391: l_internal_org_id := NULL;
392: FOR l_del_loc_info_rec in l_get_del_loc_info_csr(p_entity_in_rec.entity_id_tbl(i)) LOOP

Line 402: WSH_DEBUG_SV.log(l_module_name,'l_return_status after calling Convert_internal_cust_location',l_return_status);

398: --
399: -- Debug Statements
400: --
401: IF l_debug_on THEN
402: WSH_DEBUG_SV.log(l_module_name,'l_return_status after calling Convert_internal_cust_location',l_return_status);
403: WSH_DEBUG_SV.log(l_module_name,'l_internal_loc_id',l_internal_loc_id);
404: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
405: END IF;
406: --

Line 403: WSH_DEBUG_SV.log(l_module_name,'l_internal_loc_id',l_internal_loc_id);

399: -- Debug Statements
400: --
401: IF l_debug_on THEN
402: WSH_DEBUG_SV.log(l_module_name,'l_return_status after calling Convert_internal_cust_location',l_return_status);
403: WSH_DEBUG_SV.log(l_module_name,'l_internal_loc_id',l_internal_loc_id);
404: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
405: END IF;
406: --
407: wsh_util_core.api_post_call(

Line 404: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

400: --
401: IF l_debug_on THEN
402: WSH_DEBUG_SV.log(l_module_name,'l_return_status after calling Convert_internal_cust_location',l_return_status);
403: WSH_DEBUG_SV.log(l_module_name,'l_internal_loc_id',l_internal_loc_id);
404: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
405: END IF;
406: --
407: wsh_util_core.api_post_call(
408: p_return_status => l_return_status,

Line 435: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

431: --
432: -- Debug Statements
433: --
434: IF l_debug_on THEN
435: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
436: END IF;
437: --
438: wsh_util_core.api_post_call(
439: p_return_status => l_return_status,

Line 467: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling INSERT_ROW_IN_LOC_GTMP is', l_return_status);

463: --
464: -- Debug Statements
465: --
466: IF l_debug_on THEN
467: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling INSERT_ROW_IN_LOC_GTMP is', l_return_status);
468: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
469: END IF;
470: --
471: wsh_util_core.api_post_call(

Line 468: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

464: -- Debug Statements
465: --
466: IF l_debug_on THEN
467: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling INSERT_ROW_IN_LOC_GTMP is', l_return_status);
468: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
469: END IF;
470: --
471: wsh_util_core.api_post_call(
472: p_return_status => l_return_status,

Line 503: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling INSERT_ROW_IN_LOC_GTMP is', l_return_status);

499: --
500: -- Debug Statements
501: --
502: IF l_debug_on THEN
503: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling INSERT_ROW_IN_LOC_GTMP is', l_return_status);
504: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
505: END IF;
506: --
507: wsh_util_core.api_post_call(

Line 504: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

500: -- Debug Statements
501: --
502: IF l_debug_on THEN
503: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling INSERT_ROW_IN_LOC_GTMP is', l_return_status);
504: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
505: END IF;
506: --
507: wsh_util_core.api_post_call(
508: p_return_status => l_return_status,

Line 533: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling INSERT_ROW_IN_LOC_GTMP is', l_return_status);

529: --
530: -- Debug Statements
531: --
532: IF l_debug_on THEN
533: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling INSERT_ROW_IN_LOC_GTMP is', l_return_status);
534: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
535: END IF;
536: --
537: wsh_util_core.api_post_call(

Line 534: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

530: -- Debug Statements
531: --
532: IF l_debug_on THEN
533: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling INSERT_ROW_IN_LOC_GTMP is', l_return_status);
534: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
535: END IF;
536: --
537: wsh_util_core.api_post_call(
538: p_return_status => l_return_status,

Line 559: WSH_DEBUG_SV.log(l_module_name,'ContactId for delivery is', del_contact_rec.contact_id);

555: -- Customer Site.
556: for del_contact_rec in l_del_contact_csr(p_entity_in_rec.entity_id_tbl(i)) loop
557: --{
558: IF l_debug_on THEN
559: WSH_DEBUG_SV.log(l_module_name,'ContactId for delivery is', del_contact_rec.contact_id);
560: WSH_DEBUG_SV.log(l_module_name,'Prev Contact Id for delivery is', l_prev_contact_id);
561: WSH_DEBUG_SV.log(l_module_name,'location_id',l_st_loc_id);
562: WSH_DEBUG_SV.log(l_module_name,'customer_id',del_contact_rec.customer_id);
563: END IF;

Line 560: WSH_DEBUG_SV.log(l_module_name,'Prev Contact Id for delivery is', l_prev_contact_id);

556: for del_contact_rec in l_del_contact_csr(p_entity_in_rec.entity_id_tbl(i)) loop
557: --{
558: IF l_debug_on THEN
559: WSH_DEBUG_SV.log(l_module_name,'ContactId for delivery is', del_contact_rec.contact_id);
560: WSH_DEBUG_SV.log(l_module_name,'Prev Contact Id for delivery is', l_prev_contact_id);
561: WSH_DEBUG_SV.log(l_module_name,'location_id',l_st_loc_id);
562: WSH_DEBUG_SV.log(l_module_name,'customer_id',del_contact_rec.customer_id);
563: END IF;
564:

Line 561: WSH_DEBUG_SV.log(l_module_name,'location_id',l_st_loc_id);

557: --{
558: IF l_debug_on THEN
559: WSH_DEBUG_SV.log(l_module_name,'ContactId for delivery is', del_contact_rec.contact_id);
560: WSH_DEBUG_SV.log(l_module_name,'Prev Contact Id for delivery is', l_prev_contact_id);
561: WSH_DEBUG_SV.log(l_module_name,'location_id',l_st_loc_id);
562: WSH_DEBUG_SV.log(l_module_name,'customer_id',del_contact_rec.customer_id);
563: END IF;
564:
565: l_contact_exists := null;

Line 562: WSH_DEBUG_SV.log(l_module_name,'customer_id',del_contact_rec.customer_id);

558: IF l_debug_on THEN
559: WSH_DEBUG_SV.log(l_module_name,'ContactId for delivery is', del_contact_rec.contact_id);
560: WSH_DEBUG_SV.log(l_module_name,'Prev Contact Id for delivery is', l_prev_contact_id);
561: WSH_DEBUG_SV.log(l_module_name,'location_id',l_st_loc_id);
562: WSH_DEBUG_SV.log(l_module_name,'customer_id',del_contact_rec.customer_id);
563: END IF;
564:
565: l_contact_exists := null;
566:

Line 573: WSH_DEBUG_SV.log(l_module_name,'contact exists',l_contact_exists);

569: open l_check_contacts_exists_csr(del_contact_rec.contact_id, l_st_loc_id,del_contact_rec.customer_id);
570: fetch l_check_contacts_exists_csr into l_contact_exists;
571: close l_check_contacts_exists_csr;
572: IF l_debug_on THEN
573: WSH_DEBUG_SV.log(l_module_name,'contact exists',l_contact_exists);
574: END IF;
575: IF (l_contact_exists IS NULL) THEN
576: --{
577: insert into WSH_OTM_LOC_CONTACTS_GTMP

Line 608: WSH_DEBUG_SV.pop(l_module_name);

604: --
605: -- Debug Statements
606: --
607: IF l_debug_on THEN
608: WSH_DEBUG_SV.pop(l_module_name);
609: END IF;
610: --
611: END EXTRACT_DLVY_INFO;
612:

Line 683: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

679: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
680: --
681: IF l_debug_on IS NULL
682: THEN
683: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
684: END IF;
685: --
686: --
687: -- Debug Statements

Line 690: WSH_DEBUG_SV.push(l_module_name);

686: --
687: -- Debug Statements
688: --
689: IF l_debug_on THEN
690: WSH_DEBUG_SV.push(l_module_name);
691: --
692: WSH_DEBUG_SV.log(l_module_name,'P_TRANSMISSION_ID',P_TRANSMISSION_ID);
693: END IF;
694: --

Line 692: WSH_DEBUG_SV.log(l_module_name,'P_TRANSMISSION_ID',P_TRANSMISSION_ID);

688: --
689: IF l_debug_on THEN
690: WSH_DEBUG_SV.push(l_module_name);
691: --
692: WSH_DEBUG_SV.log(l_module_name,'P_TRANSMISSION_ID',P_TRANSMISSION_ID);
693: END IF;
694: --
695: x_return_status := wsh_util_core.g_ret_sts_success;
696: --

Line 732: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

728: --
729: -- Debug Statements
730: --
731: IF l_debug_on THEN
732: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
733: END IF;
734: --
735: wsh_util_core.api_post_call(
736: p_return_status => l_return_status,

Line 776: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

772: --
773: -- Debug Statements
774: --
775: IF l_debug_on THEN
776: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
777: END IF;
778: --
779: wsh_util_core.api_post_call(
780: p_return_status => l_return_status,

Line 806: WSH_DEBUG_SV.pop(l_module_name);

802: --
803: -- Debug Statements
804: --
805: IF l_debug_on THEN
806: WSH_DEBUG_SV.pop(l_module_name);
807: END IF;
808: --
809: EXCEPTION
810: --{

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

813: --
814: -- Debug Statements
815: --
816: IF l_debug_on THEN
817: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
818: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
819: END IF;
820: --
821: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

814: -- Debug Statements
815: --
816: IF l_debug_on THEN
817: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
818: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
819: END IF;
820: --
821: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
822: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

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

823: --
824: -- Debug Statements
825: --
826: IF l_debug_on THEN
827: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
828: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
829: END IF;
830: --
831: WHEN OTHERS THEN

Line 828: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

824: -- Debug Statements
825: --
826: IF l_debug_on THEN
827: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
828: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
829: END IF;
830: --
831: WHEN OTHERS THEN
832: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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

834: --
835: -- Debug Statements
836: --
837: IF l_debug_on THEN
838: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
839: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
840: END IF;
841: --
842: END EXTRACT_TRIP_INFO;

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

835: -- Debug Statements
836: --
837: IF l_debug_on THEN
838: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
839: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
840: END IF;
841: --
842: END EXTRACT_TRIP_INFO;
843:

Line 880: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

876: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
877: --
878: IF l_debug_on IS NULL
879: THEN
880: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
881: END IF;
882: --
883: --
884: -- Debug Statements

Line 887: WSH_DEBUG_SV.push(l_module_name);

883: --
884: -- Debug Statements
885: --
886: IF l_debug_on THEN
887: WSH_DEBUG_SV.push(l_module_name);
888: --
889: WSH_DEBUG_SV.log(l_module_name,'P_TRANSMISSION_ID',P_TRANSMISSION_ID);
890: END IF;
891: --

Line 889: WSH_DEBUG_SV.log(l_module_name,'P_TRANSMISSION_ID',P_TRANSMISSION_ID);

885: --
886: IF l_debug_on THEN
887: WSH_DEBUG_SV.push(l_module_name);
888: --
889: WSH_DEBUG_SV.log(l_module_name,'P_TRANSMISSION_ID',P_TRANSMISSION_ID);
890: END IF;
891: --
892: x_return_status := wsh_util_core.g_ret_sts_success;
893: --

Line 931: WSH_DEBUG_SV.log(l_module_name,'party_site_id ('||i||')',p_entity_in_rec.entity_id_tbl(i));

927: close l_get_loc_id_csr;
928: --
929: IF l_debug_on THEN
930: --
931: WSH_DEBUG_SV.log(l_module_name,'party_site_id ('||i||')',p_entity_in_rec.entity_id_tbl(i));
932: WSH_DEBUG_SV.log(l_module_name,'party_id ('||i||')',p_entity_in_rec.parent_entity_id_tbl(i));
933: WSH_DEBUG_SV.log(l_module_name,'l_location_id',l_location_id);
934: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOCATION',WSH_DEBUG_SV.C_PROC_LEVEL);
935: --

Line 932: WSH_DEBUG_SV.log(l_module_name,'party_id ('||i||')',p_entity_in_rec.parent_entity_id_tbl(i));

928: --
929: IF l_debug_on THEN
930: --
931: WSH_DEBUG_SV.log(l_module_name,'party_site_id ('||i||')',p_entity_in_rec.entity_id_tbl(i));
932: WSH_DEBUG_SV.log(l_module_name,'party_id ('||i||')',p_entity_in_rec.parent_entity_id_tbl(i));
933: WSH_DEBUG_SV.log(l_module_name,'l_location_id',l_location_id);
934: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOCATION',WSH_DEBUG_SV.C_PROC_LEVEL);
935: --
936: END IF;

Line 933: WSH_DEBUG_SV.log(l_module_name,'l_location_id',l_location_id);

929: IF l_debug_on THEN
930: --
931: WSH_DEBUG_SV.log(l_module_name,'party_site_id ('||i||')',p_entity_in_rec.entity_id_tbl(i));
932: WSH_DEBUG_SV.log(l_module_name,'party_id ('||i||')',p_entity_in_rec.parent_entity_id_tbl(i));
933: WSH_DEBUG_SV.log(l_module_name,'l_location_id',l_location_id);
934: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOCATION',WSH_DEBUG_SV.C_PROC_LEVEL);
935: --
936: END IF;
937: --

Line 934: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOCATION',WSH_DEBUG_SV.C_PROC_LEVEL);

930: --
931: WSH_DEBUG_SV.log(l_module_name,'party_site_id ('||i||')',p_entity_in_rec.entity_id_tbl(i));
932: WSH_DEBUG_SV.log(l_module_name,'party_id ('||i||')',p_entity_in_rec.parent_entity_id_tbl(i));
933: WSH_DEBUG_SV.log(l_module_name,'l_location_id',l_location_id);
934: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOCATION',WSH_DEBUG_SV.C_PROC_LEVEL);
935: --
936: END IF;
937: --
938: wsh_util_validate.validate_location

Line 949: WSH_DEBUG_SV.log(l_module_name,'l_return_status', l_return_status);

945: --
946: -- Debug Statements
947: --
948: IF l_debug_on THEN
949: WSH_DEBUG_SV.log(l_module_name,'l_return_status', l_return_status);
950: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
951: END IF;
952: --
953: wsh_util_core.api_post_call(

Line 950: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

946: -- Debug Statements
947: --
948: IF l_debug_on THEN
949: WSH_DEBUG_SV.log(l_module_name,'l_return_status', l_return_status);
950: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
951: END IF;
952: --
953: wsh_util_core.api_post_call(
954: p_return_status => l_return_status,

Line 969: WSH_DEBUG_SV.pop(l_module_name);

965: --
966: -- Debug Statements
967: --
968: IF l_debug_on THEN
969: WSH_DEBUG_SV.pop(l_module_name);
970: END IF;
971: --
972: EXCEPTION
973: --{

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

976: --
977: -- Debug Statements
978: --
979: IF l_debug_on THEN
980: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
981: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
982: END IF;
983: --
984: --}

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

977: -- Debug Statements
978: --
979: IF l_debug_on THEN
980: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
981: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
982: END IF;
983: --
984: --}
985: END EXTRACT_CARRIER_INFO;

Line 1025: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1021: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1022: --
1023: IF l_debug_on IS NULL
1024: THEN
1025: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1026: END IF;
1027: --
1028: --
1029: -- Debug Statements

Line 1032: WSH_DEBUG_SV.push(l_module_name);

1028: --
1029: -- Debug Statements
1030: --
1031: IF l_debug_on THEN
1032: WSH_DEBUG_SV.push(l_module_name);
1033: --
1034: WSH_DEBUG_SV.log(l_module_name,'P_TRANSMISSION_ID',P_TRANSMISSION_ID);
1035: END IF;
1036: --

Line 1034: WSH_DEBUG_SV.log(l_module_name,'P_TRANSMISSION_ID',P_TRANSMISSION_ID);

1030: --
1031: IF l_debug_on THEN
1032: WSH_DEBUG_SV.push(l_module_name);
1033: --
1034: WSH_DEBUG_SV.log(l_module_name,'P_TRANSMISSION_ID',P_TRANSMISSION_ID);
1035: END IF;
1036: --
1037: x_return_status := wsh_util_core.g_ret_sts_success;
1038: --

Line 1071: WSH_DEBUG_SV.log(l_module_name,'return status from insert into locGtmp ', l_return_status);

1067: --
1068: -- Debug Statements
1069: --
1070: IF l_debug_on THEN
1071: WSH_DEBUG_SV.log(l_module_name,'return status from insert into locGtmp ', l_return_status);
1072: WSH_DEBUG_SV.log(l_module_name,'org_id ('||i||')',p_entity_in_rec.entity_id_tbl(i));
1073: WSH_DEBUG_SV.log(l_module_name,'from_location_id', l_location_id);
1074: WSH_DEBUG_SV.log(l_module_name,'gtmp_location_id', l_gtmp_location_id);
1075: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

Line 1072: WSH_DEBUG_SV.log(l_module_name,'org_id ('||i||')',p_entity_in_rec.entity_id_tbl(i));

1068: -- Debug Statements
1069: --
1070: IF l_debug_on THEN
1071: WSH_DEBUG_SV.log(l_module_name,'return status from insert into locGtmp ', l_return_status);
1072: WSH_DEBUG_SV.log(l_module_name,'org_id ('||i||')',p_entity_in_rec.entity_id_tbl(i));
1073: WSH_DEBUG_SV.log(l_module_name,'from_location_id', l_location_id);
1074: WSH_DEBUG_SV.log(l_module_name,'gtmp_location_id', l_gtmp_location_id);
1075: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1076: --

Line 1073: WSH_DEBUG_SV.log(l_module_name,'from_location_id', l_location_id);

1069: --
1070: IF l_debug_on THEN
1071: WSH_DEBUG_SV.log(l_module_name,'return status from insert into locGtmp ', l_return_status);
1072: WSH_DEBUG_SV.log(l_module_name,'org_id ('||i||')',p_entity_in_rec.entity_id_tbl(i));
1073: WSH_DEBUG_SV.log(l_module_name,'from_location_id', l_location_id);
1074: WSH_DEBUG_SV.log(l_module_name,'gtmp_location_id', l_gtmp_location_id);
1075: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1076: --
1077: END IF;

Line 1074: WSH_DEBUG_SV.log(l_module_name,'gtmp_location_id', l_gtmp_location_id);

1070: IF l_debug_on THEN
1071: WSH_DEBUG_SV.log(l_module_name,'return status from insert into locGtmp ', l_return_status);
1072: WSH_DEBUG_SV.log(l_module_name,'org_id ('||i||')',p_entity_in_rec.entity_id_tbl(i));
1073: WSH_DEBUG_SV.log(l_module_name,'from_location_id', l_location_id);
1074: WSH_DEBUG_SV.log(l_module_name,'gtmp_location_id', l_gtmp_location_id);
1075: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1076: --
1077: END IF;
1078: --

Line 1075: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

1071: WSH_DEBUG_SV.log(l_module_name,'return status from insert into locGtmp ', l_return_status);
1072: WSH_DEBUG_SV.log(l_module_name,'org_id ('||i||')',p_entity_in_rec.entity_id_tbl(i));
1073: WSH_DEBUG_SV.log(l_module_name,'from_location_id', l_location_id);
1074: WSH_DEBUG_SV.log(l_module_name,'gtmp_location_id', l_gtmp_location_id);
1075: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1076: --
1077: END IF;
1078: --
1079: --

Line 1095: WSH_DEBUG_SV.pop(l_module_name);

1091: --
1092: -- Debug Statements
1093: --
1094: IF l_debug_on THEN
1095: WSH_DEBUG_SV.pop(l_module_name);
1096: END IF;
1097: --
1098: EXCEPTION
1099: --{

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

1106: --
1107: -- Debug Statements
1108: --
1109: IF l_debug_on THEN
1110: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1111: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1112: END IF;
1113: --
1114: --}

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

1107: -- Debug Statements
1108: --
1109: IF l_debug_on THEN
1110: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1111: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1112: END IF;
1113: --
1114: --}
1115: END EXTRACT_ORG_INFO;

Line 1149: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1145: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1146: --
1147: IF l_debug_on IS NULL
1148: THEN
1149: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1150: END IF;
1151: --
1152: --
1153: -- Debug Statements

Line 1156: WSH_DEBUG_SV.push(l_module_name);

1152: --
1153: -- Debug Statements
1154: --
1155: IF l_debug_on THEN
1156: WSH_DEBUG_SV.push(l_module_name);
1157: --
1158: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_ID',P_LOCATION_ID);
1159: WSH_DEBUG_SV.log(l_module_name,'P_STATE',P_STATE);
1160: END IF;

Line 1158: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_ID',P_LOCATION_ID);

1154: --
1155: IF l_debug_on THEN
1156: WSH_DEBUG_SV.push(l_module_name);
1157: --
1158: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_ID',P_LOCATION_ID);
1159: WSH_DEBUG_SV.log(l_module_name,'P_STATE',P_STATE);
1160: END IF;
1161: --
1162: open l_get_state_code_csr(p_location_id);

Line 1159: WSH_DEBUG_SV.log(l_module_name,'P_STATE',P_STATE);

1155: IF l_debug_on THEN
1156: WSH_DEBUG_SV.push(l_module_name);
1157: --
1158: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_ID',P_LOCATION_ID);
1159: WSH_DEBUG_SV.log(l_module_name,'P_STATE',P_STATE);
1160: END IF;
1161: --
1162: open l_get_state_code_csr(p_location_id);
1163: fetch l_get_state_code_csr into l_state_code;

Line 1173: WSH_DEBUG_SV.log(l_module_name,'l_state_code',l_state_code);

1169: --
1170: -- Debug Statements
1171: --
1172: IF l_debug_on THEN
1173: WSH_DEBUG_SV.log(l_module_name,'l_state_code',l_state_code);
1174: WSH_DEBUG_SV.pop(l_module_name);
1175: END IF;
1176: --
1177: return l_state_code;

Line 1174: WSH_DEBUG_SV.pop(l_module_name);

1170: -- Debug Statements
1171: --
1172: IF l_debug_on THEN
1173: WSH_DEBUG_SV.log(l_module_name,'l_state_code',l_state_code);
1174: WSH_DEBUG_SV.pop(l_module_name);
1175: END IF;
1176: --
1177: return l_state_code;
1178: --}

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

1182: --
1183: -- Debug Statements
1184: --
1185: IF l_debug_on THEN
1186: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1187: WSH_DEBUG_SV.pop(l_module_name);
1188: END IF;
1189: return NULL;
1190: --

Line 1187: WSH_DEBUG_SV.pop(l_module_name);

1183: -- Debug Statements
1184: --
1185: IF l_debug_on THEN
1186: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1187: WSH_DEBUG_SV.pop(l_module_name);
1188: END IF;
1189: return NULL;
1190: --
1191: --}

Line 1212: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1208: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1209: --
1210: IF l_debug_on IS NULL
1211: THEN
1212: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1213: END IF;
1214: --
1215: --
1216: -- Debug Statements

Line 1219: WSH_DEBUG_SV.push(l_module_name);

1215: --
1216: -- Debug Statements
1217: --
1218: IF l_debug_on THEN
1219: WSH_DEBUG_SV.push(l_module_name);
1220: --
1221: WSH_DEBUG_SV.log(l_module_name,'P_TBL_EXTEND_INDEX',P_TBL_EXTEND_INDEX);
1222: END IF;
1223: --

Line 1221: WSH_DEBUG_SV.log(l_module_name,'P_TBL_EXTEND_INDEX',P_TBL_EXTEND_INDEX);

1217: --
1218: IF l_debug_on THEN
1219: WSH_DEBUG_SV.push(l_module_name);
1220: --
1221: WSH_DEBUG_SV.log(l_module_name,'P_TBL_EXTEND_INDEX',P_TBL_EXTEND_INDEX);
1222: END IF;
1223: --
1224: x_locations_tbl.extend;
1225: x_locations_tbl(p_tbl_extend_index) := WSH_OTM_LOCATIONS_REC_TYPE

Line 1254: WSH_DEBUG_SV.pop(l_module_name);

1250: --
1251: -- Debug Statements
1252: --
1253: IF l_debug_on THEN
1254: WSH_DEBUG_SV.pop(l_module_name);
1255: END IF;
1256: --
1257: END EXTEND_LOCATIONS_TBL;
1258:

Line 1282: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1278: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1279: --
1280: IF l_debug_on IS NULL
1281: THEN
1282: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1283: END IF;
1284: --
1285: --
1286: -- Debug Statements

Line 1289: WSH_DEBUG_SV.push(l_module_name);

1285: --
1286: -- Debug Statements
1287: --
1288: IF l_debug_on THEN
1289: WSH_DEBUG_SV.push(l_module_name);
1290: --
1291: WSH_DEBUG_SV.log(l_module_name,'p_qualifier',p_qualifier);
1292: WSH_DEBUG_SV.log(l_module_name,'p_domain_name',p_domain_name);
1293: WSH_DEBUG_SV.log(l_module_name,'p_value',p_value);

Line 1291: WSH_DEBUG_SV.log(l_module_name,'p_qualifier',p_qualifier);

1287: --
1288: IF l_debug_on THEN
1289: WSH_DEBUG_SV.push(l_module_name);
1290: --
1291: WSH_DEBUG_SV.log(l_module_name,'p_qualifier',p_qualifier);
1292: WSH_DEBUG_SV.log(l_module_name,'p_domain_name',p_domain_name);
1293: WSH_DEBUG_SV.log(l_module_name,'p_value',p_value);
1294: END IF;
1295: --

Line 1292: WSH_DEBUG_SV.log(l_module_name,'p_domain_name',p_domain_name);

1288: IF l_debug_on THEN
1289: WSH_DEBUG_SV.push(l_module_name);
1290: --
1291: WSH_DEBUG_SV.log(l_module_name,'p_qualifier',p_qualifier);
1292: WSH_DEBUG_SV.log(l_module_name,'p_domain_name',p_domain_name);
1293: WSH_DEBUG_SV.log(l_module_name,'p_value',p_value);
1294: END IF;
1295: --
1296: l_count := x_ref_num_tbl.count + 1;

Line 1293: WSH_DEBUG_SV.log(l_module_name,'p_value',p_value);

1289: WSH_DEBUG_SV.push(l_module_name);
1290: --
1291: WSH_DEBUG_SV.log(l_module_name,'p_qualifier',p_qualifier);
1292: WSH_DEBUG_SV.log(l_module_name,'p_domain_name',p_domain_name);
1293: WSH_DEBUG_SV.log(l_module_name,'p_value',p_value);
1294: END IF;
1295: --
1296: l_count := x_ref_num_tbl.count + 1;
1297: --

Line 1301: WSH_DEBUG_SV.log(l_module_name,'l_count',l_count);

1297: --
1298: --
1299: IF l_debug_on THEN
1300: --
1301: WSH_DEBUG_SV.log(l_module_name,'l_count',l_count);
1302: --
1303: END IF;
1304: --
1305: IF (p_value IS NOT NULL AND p_domain_name IS NOT NULL AND p_qualifier IS NOT NULL) THEN

Line 1317: WSH_DEBUG_SV.pop(l_module_name);

1313: --
1314: -- Debug Statements
1315: --
1316: IF l_debug_on THEN
1317: WSH_DEBUG_SV.pop(l_module_name);
1318: END IF;
1319: --
1320: END EXTND_ASSIGN_LOC_REF_NUM_TBL;
1321:

Line 1582: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1578: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1579: --
1580: IF l_debug_on IS NULL
1581: THEN
1582: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1583: END IF;
1584: --
1585: --
1586: -- Debug Statements

Line 1589: WSH_DEBUG_SV.push(l_module_name);

1585: --
1586: -- Debug Statements
1587: --
1588: IF l_debug_on THEN
1589: WSH_DEBUG_SV.push(l_module_name);
1590: --
1591: WSH_DEBUG_SV.log(l_module_name,'P_TRANSMISSION_ID',P_TRANSMISSION_ID);
1592: END IF;
1593: --

Line 1591: WSH_DEBUG_SV.log(l_module_name,'P_TRANSMISSION_ID',P_TRANSMISSION_ID);

1587: --
1588: IF l_debug_on THEN
1589: WSH_DEBUG_SV.push(l_module_name);
1590: --
1591: WSH_DEBUG_SV.log(l_module_name,'P_TRANSMISSION_ID',P_TRANSMISSION_ID);
1592: END IF;
1593: --
1594: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1595:

Line 1612: WSH_DEBUG_SV.logmsg(l_module_name,'Error: The profile WSH_OTM_DOMAIN_NAME is set to NULL. Please correct the profile value');

1608: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_DOMAIN_NOT_SET_ERR');
1609: x_return_status := wsh_util_core.G_RET_STS_UNEXP_ERROR;
1610: wsh_util_core.add_message(x_return_status, l_module_name);
1611: IF l_debug_on THEN
1612: WSH_DEBUG_SV.logmsg(l_module_name,'Error: The profile WSH_OTM_DOMAIN_NAME is set to NULL. Please correct the profile value');
1613: END IF;
1614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1615: --}
1616: END IF;

Line 1624: WSH_DEBUG_SV.logmsg(l_module_name,'Error: The profile WSH_OTM_CORP_COUNTRY_CODE is set to NULL. Please correct the profile value');

1620: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_CNTR_CODE_NOT_SET_ERR');
1621: x_return_status := wsh_util_core.G_RET_STS_UNEXP_ERROR;
1622: wsh_util_core.add_message(x_return_status, l_module_name);
1623: IF l_debug_on THEN
1624: WSH_DEBUG_SV.logmsg(l_module_name,'Error: The profile WSH_OTM_CORP_COUNTRY_CODE is set to NULL. Please correct the profile value');
1625: END IF;
1626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1627: --}
1628: END IF;

Line 1639: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.LOCATION_XID',org_loc_rec.LOCATION_XID);

1635: -- Debug Statements
1636: --
1637: IF l_debug_on THEN
1638: --
1639: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.LOCATION_XID',org_loc_rec.LOCATION_XID);
1640: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.LOCATION_NAME',org_loc_rec.LOCATION_NAME);
1641: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ADDRESS_LINE_1',org_loc_rec.ADDRESS_LINE_1);
1642: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ADDRESS_LINE_2',org_loc_rec.ADDRESS_LINE_2);
1643: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ADDRESS_LINE_3',org_loc_rec.ADDRESS_LINE_3);

Line 1640: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.LOCATION_NAME',org_loc_rec.LOCATION_NAME);

1636: --
1637: IF l_debug_on THEN
1638: --
1639: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.LOCATION_XID',org_loc_rec.LOCATION_XID);
1640: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.LOCATION_NAME',org_loc_rec.LOCATION_NAME);
1641: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ADDRESS_LINE_1',org_loc_rec.ADDRESS_LINE_1);
1642: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ADDRESS_LINE_2',org_loc_rec.ADDRESS_LINE_2);
1643: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ADDRESS_LINE_3',org_loc_rec.ADDRESS_LINE_3);
1644: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.TOWN_OR_CITY',org_loc_rec.TOWN_OR_CITY);

Line 1641: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ADDRESS_LINE_1',org_loc_rec.ADDRESS_LINE_1);

1637: IF l_debug_on THEN
1638: --
1639: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.LOCATION_XID',org_loc_rec.LOCATION_XID);
1640: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.LOCATION_NAME',org_loc_rec.LOCATION_NAME);
1641: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ADDRESS_LINE_1',org_loc_rec.ADDRESS_LINE_1);
1642: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ADDRESS_LINE_2',org_loc_rec.ADDRESS_LINE_2);
1643: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ADDRESS_LINE_3',org_loc_rec.ADDRESS_LINE_3);
1644: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.TOWN_OR_CITY',org_loc_rec.TOWN_OR_CITY);
1645: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PROVINCE',org_loc_rec.PROVINCE);

Line 1642: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ADDRESS_LINE_2',org_loc_rec.ADDRESS_LINE_2);

1638: --
1639: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.LOCATION_XID',org_loc_rec.LOCATION_XID);
1640: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.LOCATION_NAME',org_loc_rec.LOCATION_NAME);
1641: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ADDRESS_LINE_1',org_loc_rec.ADDRESS_LINE_1);
1642: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ADDRESS_LINE_2',org_loc_rec.ADDRESS_LINE_2);
1643: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ADDRESS_LINE_3',org_loc_rec.ADDRESS_LINE_3);
1644: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.TOWN_OR_CITY',org_loc_rec.TOWN_OR_CITY);
1645: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PROVINCE',org_loc_rec.PROVINCE);
1646: --WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PROVINCE_CODE',org_loc_rec.PROVINCE_CODE);

Line 1643: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ADDRESS_LINE_3',org_loc_rec.ADDRESS_LINE_3);

1639: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.LOCATION_XID',org_loc_rec.LOCATION_XID);
1640: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.LOCATION_NAME',org_loc_rec.LOCATION_NAME);
1641: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ADDRESS_LINE_1',org_loc_rec.ADDRESS_LINE_1);
1642: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ADDRESS_LINE_2',org_loc_rec.ADDRESS_LINE_2);
1643: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ADDRESS_LINE_3',org_loc_rec.ADDRESS_LINE_3);
1644: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.TOWN_OR_CITY',org_loc_rec.TOWN_OR_CITY);
1645: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PROVINCE',org_loc_rec.PROVINCE);
1646: --WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PROVINCE_CODE',org_loc_rec.PROVINCE_CODE);
1647: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.POSTAL_CODE',org_loc_rec.POSTAL_CODE);

Line 1644: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.TOWN_OR_CITY',org_loc_rec.TOWN_OR_CITY);

1640: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.LOCATION_NAME',org_loc_rec.LOCATION_NAME);
1641: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ADDRESS_LINE_1',org_loc_rec.ADDRESS_LINE_1);
1642: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ADDRESS_LINE_2',org_loc_rec.ADDRESS_LINE_2);
1643: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ADDRESS_LINE_3',org_loc_rec.ADDRESS_LINE_3);
1644: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.TOWN_OR_CITY',org_loc_rec.TOWN_OR_CITY);
1645: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PROVINCE',org_loc_rec.PROVINCE);
1646: --WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PROVINCE_CODE',org_loc_rec.PROVINCE_CODE);
1647: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.POSTAL_CODE',org_loc_rec.POSTAL_CODE);
1648: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.COUNTRY',org_loc_rec.COUNTRY);

Line 1645: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PROVINCE',org_loc_rec.PROVINCE);

1641: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ADDRESS_LINE_1',org_loc_rec.ADDRESS_LINE_1);
1642: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ADDRESS_LINE_2',org_loc_rec.ADDRESS_LINE_2);
1643: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ADDRESS_LINE_3',org_loc_rec.ADDRESS_LINE_3);
1644: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.TOWN_OR_CITY',org_loc_rec.TOWN_OR_CITY);
1645: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PROVINCE',org_loc_rec.PROVINCE);
1646: --WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PROVINCE_CODE',org_loc_rec.PROVINCE_CODE);
1647: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.POSTAL_CODE',org_loc_rec.POSTAL_CODE);
1648: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.COUNTRY',org_loc_rec.COUNTRY);
1649: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PHONE1',org_loc_rec.PHONE1);

Line 1646: --WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PROVINCE_CODE',org_loc_rec.PROVINCE_CODE);

1642: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ADDRESS_LINE_2',org_loc_rec.ADDRESS_LINE_2);
1643: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ADDRESS_LINE_3',org_loc_rec.ADDRESS_LINE_3);
1644: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.TOWN_OR_CITY',org_loc_rec.TOWN_OR_CITY);
1645: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PROVINCE',org_loc_rec.PROVINCE);
1646: --WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PROVINCE_CODE',org_loc_rec.PROVINCE_CODE);
1647: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.POSTAL_CODE',org_loc_rec.POSTAL_CODE);
1648: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.COUNTRY',org_loc_rec.COUNTRY);
1649: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PHONE1',org_loc_rec.PHONE1);
1650: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PHONE2',org_loc_rec.PHONE2);

Line 1647: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.POSTAL_CODE',org_loc_rec.POSTAL_CODE);

1643: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ADDRESS_LINE_3',org_loc_rec.ADDRESS_LINE_3);
1644: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.TOWN_OR_CITY',org_loc_rec.TOWN_OR_CITY);
1645: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PROVINCE',org_loc_rec.PROVINCE);
1646: --WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PROVINCE_CODE',org_loc_rec.PROVINCE_CODE);
1647: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.POSTAL_CODE',org_loc_rec.POSTAL_CODE);
1648: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.COUNTRY',org_loc_rec.COUNTRY);
1649: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PHONE1',org_loc_rec.PHONE1);
1650: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PHONE2',org_loc_rec.PHONE2);
1651: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.FAX',org_loc_rec.FAX);

Line 1648: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.COUNTRY',org_loc_rec.COUNTRY);

1644: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.TOWN_OR_CITY',org_loc_rec.TOWN_OR_CITY);
1645: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PROVINCE',org_loc_rec.PROVINCE);
1646: --WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PROVINCE_CODE',org_loc_rec.PROVINCE_CODE);
1647: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.POSTAL_CODE',org_loc_rec.POSTAL_CODE);
1648: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.COUNTRY',org_loc_rec.COUNTRY);
1649: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PHONE1',org_loc_rec.PHONE1);
1650: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PHONE2',org_loc_rec.PHONE2);
1651: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.FAX',org_loc_rec.FAX);
1652: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.NAME',org_loc_rec.NAME);

Line 1649: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PHONE1',org_loc_rec.PHONE1);

1645: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PROVINCE',org_loc_rec.PROVINCE);
1646: --WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PROVINCE_CODE',org_loc_rec.PROVINCE_CODE);
1647: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.POSTAL_CODE',org_loc_rec.POSTAL_CODE);
1648: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.COUNTRY',org_loc_rec.COUNTRY);
1649: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PHONE1',org_loc_rec.PHONE1);
1650: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PHONE2',org_loc_rec.PHONE2);
1651: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.FAX',org_loc_rec.FAX);
1652: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.NAME',org_loc_rec.NAME);
1653: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ORGANIZATION_CODE',org_loc_rec.ORGANIZATION_CODE);

Line 1650: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PHONE2',org_loc_rec.PHONE2);

1646: --WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PROVINCE_CODE',org_loc_rec.PROVINCE_CODE);
1647: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.POSTAL_CODE',org_loc_rec.POSTAL_CODE);
1648: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.COUNTRY',org_loc_rec.COUNTRY);
1649: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PHONE1',org_loc_rec.PHONE1);
1650: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PHONE2',org_loc_rec.PHONE2);
1651: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.FAX',org_loc_rec.FAX);
1652: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.NAME',org_loc_rec.NAME);
1653: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ORGANIZATION_CODE',org_loc_rec.ORGANIZATION_CODE);
1654: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.WSH_LOCATION_ID',org_loc_rec.WSH_LOCATION_ID);

Line 1651: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.FAX',org_loc_rec.FAX);

1647: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.POSTAL_CODE',org_loc_rec.POSTAL_CODE);
1648: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.COUNTRY',org_loc_rec.COUNTRY);
1649: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PHONE1',org_loc_rec.PHONE1);
1650: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PHONE2',org_loc_rec.PHONE2);
1651: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.FAX',org_loc_rec.FAX);
1652: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.NAME',org_loc_rec.NAME);
1653: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ORGANIZATION_CODE',org_loc_rec.ORGANIZATION_CODE);
1654: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.WSH_LOCATION_ID',org_loc_rec.WSH_LOCATION_ID);
1655: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.LOCATION_ID',org_loc_rec.LOCATION_ID);

Line 1652: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.NAME',org_loc_rec.NAME);

1648: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.COUNTRY',org_loc_rec.COUNTRY);
1649: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PHONE1',org_loc_rec.PHONE1);
1650: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PHONE2',org_loc_rec.PHONE2);
1651: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.FAX',org_loc_rec.FAX);
1652: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.NAME',org_loc_rec.NAME);
1653: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ORGANIZATION_CODE',org_loc_rec.ORGANIZATION_CODE);
1654: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.WSH_LOCATION_ID',org_loc_rec.WSH_LOCATION_ID);
1655: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.LOCATION_ID',org_loc_rec.LOCATION_ID);
1656: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ORGANIZATION_ID',org_loc_rec.ORGANIZATION_ID);

Line 1653: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ORGANIZATION_CODE',org_loc_rec.ORGANIZATION_CODE);

1649: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PHONE1',org_loc_rec.PHONE1);
1650: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PHONE2',org_loc_rec.PHONE2);
1651: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.FAX',org_loc_rec.FAX);
1652: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.NAME',org_loc_rec.NAME);
1653: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ORGANIZATION_CODE',org_loc_rec.ORGANIZATION_CODE);
1654: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.WSH_LOCATION_ID',org_loc_rec.WSH_LOCATION_ID);
1655: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.LOCATION_ID',org_loc_rec.LOCATION_ID);
1656: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ORGANIZATION_ID',org_loc_rec.ORGANIZATION_ID);
1657: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.LAST_UPDATE_DATE',org_loc_rec.LAST_UPDATE_DATE);

Line 1654: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.WSH_LOCATION_ID',org_loc_rec.WSH_LOCATION_ID);

1650: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PHONE2',org_loc_rec.PHONE2);
1651: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.FAX',org_loc_rec.FAX);
1652: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.NAME',org_loc_rec.NAME);
1653: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ORGANIZATION_CODE',org_loc_rec.ORGANIZATION_CODE);
1654: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.WSH_LOCATION_ID',org_loc_rec.WSH_LOCATION_ID);
1655: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.LOCATION_ID',org_loc_rec.LOCATION_ID);
1656: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ORGANIZATION_ID',org_loc_rec.ORGANIZATION_ID);
1657: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.LAST_UPDATE_DATE',org_loc_rec.LAST_UPDATE_DATE);
1658: --

Line 1655: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.LOCATION_ID',org_loc_rec.LOCATION_ID);

1651: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.FAX',org_loc_rec.FAX);
1652: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.NAME',org_loc_rec.NAME);
1653: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ORGANIZATION_CODE',org_loc_rec.ORGANIZATION_CODE);
1654: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.WSH_LOCATION_ID',org_loc_rec.WSH_LOCATION_ID);
1655: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.LOCATION_ID',org_loc_rec.LOCATION_ID);
1656: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ORGANIZATION_ID',org_loc_rec.ORGANIZATION_ID);
1657: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.LAST_UPDATE_DATE',org_loc_rec.LAST_UPDATE_DATE);
1658: --
1659: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_OTM_SYNC_REF_DATA_PKG.IS_REF_DATA_SEND_REQD',WSH_DEBUG_SV.C_PROC_LEVEL);

Line 1656: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ORGANIZATION_ID',org_loc_rec.ORGANIZATION_ID);

1652: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.NAME',org_loc_rec.NAME);
1653: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ORGANIZATION_CODE',org_loc_rec.ORGANIZATION_CODE);
1654: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.WSH_LOCATION_ID',org_loc_rec.WSH_LOCATION_ID);
1655: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.LOCATION_ID',org_loc_rec.LOCATION_ID);
1656: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ORGANIZATION_ID',org_loc_rec.ORGANIZATION_ID);
1657: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.LAST_UPDATE_DATE',org_loc_rec.LAST_UPDATE_DATE);
1658: --
1659: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_OTM_SYNC_REF_DATA_PKG.IS_REF_DATA_SEND_REQD',WSH_DEBUG_SV.C_PROC_LEVEL);
1660: --

Line 1657: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.LAST_UPDATE_DATE',org_loc_rec.LAST_UPDATE_DATE);

1653: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ORGANIZATION_CODE',org_loc_rec.ORGANIZATION_CODE);
1654: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.WSH_LOCATION_ID',org_loc_rec.WSH_LOCATION_ID);
1655: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.LOCATION_ID',org_loc_rec.LOCATION_ID);
1656: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ORGANIZATION_ID',org_loc_rec.ORGANIZATION_ID);
1657: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.LAST_UPDATE_DATE',org_loc_rec.LAST_UPDATE_DATE);
1658: --
1659: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_OTM_SYNC_REF_DATA_PKG.IS_REF_DATA_SEND_REQD',WSH_DEBUG_SV.C_PROC_LEVEL);
1660: --
1661: END IF;

Line 1659: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_OTM_SYNC_REF_DATA_PKG.IS_REF_DATA_SEND_REQD',WSH_DEBUG_SV.C_PROC_LEVEL);

1655: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.LOCATION_ID',org_loc_rec.LOCATION_ID);
1656: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ORGANIZATION_ID',org_loc_rec.ORGANIZATION_ID);
1657: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.LAST_UPDATE_DATE',org_loc_rec.LAST_UPDATE_DATE);
1658: --
1659: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_OTM_SYNC_REF_DATA_PKG.IS_REF_DATA_SEND_REQD',WSH_DEBUG_SV.C_PROC_LEVEL);
1660: --
1661: END IF;
1662: --
1663: WSH_OTM_SYNC_REF_DATA_PKG.IS_REF_DATA_SEND_REQD

Line 1679: WSH_DEBUG_SV.log(l_module_name,'l_send_allowed', l_send_allowed);

1675: --
1676: -- Debug Statements
1677: --
1678: IF l_debug_on THEN
1679: WSH_DEBUG_SV.log(l_module_name,'l_send_allowed', l_send_allowed);
1680: WSH_DEBUG_SV.log(l_module_name,'Calling Entity Type from Send_LOcations', p_entity_type);
1681: WSH_DEBUG_SV.log(l_module_name,'l_return_status', l_return_status);
1682: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1683: END IF;

Line 1680: WSH_DEBUG_SV.log(l_module_name,'Calling Entity Type from Send_LOcations', p_entity_type);

1676: -- Debug Statements
1677: --
1678: IF l_debug_on THEN
1679: WSH_DEBUG_SV.log(l_module_name,'l_send_allowed', l_send_allowed);
1680: WSH_DEBUG_SV.log(l_module_name,'Calling Entity Type from Send_LOcations', p_entity_type);
1681: WSH_DEBUG_SV.log(l_module_name,'l_return_status', l_return_status);
1682: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1683: END IF;
1684: --

Line 1681: WSH_DEBUG_SV.log(l_module_name,'l_return_status', l_return_status);

1677: --
1678: IF l_debug_on THEN
1679: WSH_DEBUG_SV.log(l_module_name,'l_send_allowed', l_send_allowed);
1680: WSH_DEBUG_SV.log(l_module_name,'Calling Entity Type from Send_LOcations', p_entity_type);
1681: WSH_DEBUG_SV.log(l_module_name,'l_return_status', l_return_status);
1682: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1683: END IF;
1684: --
1685: wsh_util_core.api_post_call(

Line 1682: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

1678: IF l_debug_on THEN
1679: WSH_DEBUG_SV.log(l_module_name,'l_send_allowed', l_send_allowed);
1680: WSH_DEBUG_SV.log(l_module_name,'Calling Entity Type from Send_LOcations', p_entity_type);
1681: WSH_DEBUG_SV.log(l_module_name,'l_return_status', l_return_status);
1682: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1683: END IF;
1684: --
1685: wsh_util_core.api_post_call(
1686: p_return_status => l_return_status,

Line 1771: WSH_DEBUG_SV.log(l_module_name,'l_address_line', l_address_line);

1767:
1768: l_address_line := org_loc_rec.ADDRESS_LINE_1 || ' ' || org_loc_rec.ADDRESS_LINE_2 || ' ' || org_loc_rec.ADDRESS_LINE_3;
1769:
1770: IF l_debug_on THEN
1771: WSH_DEBUG_SV.log(l_module_name,'l_address_line', l_address_line);
1772: END IF;
1773:
1774: j := lengthb(l_address_line);
1775: k := 1;

Line 1819: WSH_DEBUG_SV.log(l_module_name,'i is ', i);

1815: END LOOP;
1816:
1817: i := x_loc_xmission_rec.LOCATIONS_TBL.count+1;
1818: IF l_debug_on THEN
1819: WSH_DEBUG_SV.log(l_module_name,'i is ', i);
1820: END IF;
1821: -- Extracting the Cust Location Information
1822: FOR cust_loc_rec in l_cust_loc_csr LOOP
1823: --{

Line 1844: WSH_DEBUG_SV.log(l_module_name,'location_id', cust_loc_rec.wsh_location_id);

1840: --}
1841: END IF;
1842:
1843: IF l_debug_on THEN
1844: WSH_DEBUG_SV.log(l_module_name,'location_id', cust_loc_rec.wsh_location_id);
1845: WSH_DEBUG_SV.log(l_module_name,'customer_id', cust_loc_rec.CUST_ACCOUNT_ID);
1846: END IF;
1847: open l_ship_to_contact_csr(cust_loc_rec.wsh_location_id, cust_loc_rec.CUST_ACCOUNT_ID);
1848: fetch l_ship_to_contact_csr bulk collect into

Line 1845: WSH_DEBUG_SV.log(l_module_name,'customer_id', cust_loc_rec.CUST_ACCOUNT_ID);

1841: END IF;
1842:
1843: IF l_debug_on THEN
1844: WSH_DEBUG_SV.log(l_module_name,'location_id', cust_loc_rec.wsh_location_id);
1845: WSH_DEBUG_SV.log(l_module_name,'customer_id', cust_loc_rec.CUST_ACCOUNT_ID);
1846: END IF;
1847: open l_ship_to_contact_csr(cust_loc_rec.wsh_location_id, cust_loc_rec.CUST_ACCOUNT_ID);
1848: fetch l_ship_to_contact_csr bulk collect into
1849: l_contact_first_name_tbl,

Line 1861: WSH_DEBUG_SV.log(l_module_name,'count of contact table', l_contact_id_tbl.count);

1857: l_contact_last_upd_date_tbl;
1858: close l_ship_to_contact_csr;
1859:
1860: IF l_debug_on THEN
1861: WSH_DEBUG_SV.log(l_module_name,'count of contact table', l_contact_id_tbl.count);
1862: END IF;
1863: IF (l_contact_id_tbl.count > 0 ) THEN
1864: IF l_debug_on THEN
1865: WSH_DEBUG_SV.log(l_module_name,'l_contact_last_upd_date_tbl(1)', l_contact_last_upd_date_tbl(1));

Line 1865: WSH_DEBUG_SV.log(l_module_name,'l_contact_last_upd_date_tbl(1)', l_contact_last_upd_date_tbl(1));

1861: WSH_DEBUG_SV.log(l_module_name,'count of contact table', l_contact_id_tbl.count);
1862: END IF;
1863: IF (l_contact_id_tbl.count > 0 ) THEN
1864: IF l_debug_on THEN
1865: WSH_DEBUG_SV.log(l_module_name,'l_contact_last_upd_date_tbl(1)', l_contact_last_upd_date_tbl(1));
1866: END IF;
1867: l_last_update_date := greatest(nvl(l_contact_last_upd_date_tbl(1),cust_loc_rec.last_update_date),cust_loc_rec.last_update_date);
1868: ELSE
1869: l_last_update_date := cust_loc_rec.last_update_date;

Line 1876: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_OTM_SYNC_REF_DATA_PKG.IS_REF_DATA_SEND_REQD',WSH_DEBUG_SV.C_PROC_LEVEL);

1872: --
1873: -- Debug Statements
1874: --
1875: IF l_debug_on THEN
1876: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_OTM_SYNC_REF_DATA_PKG.IS_REF_DATA_SEND_REQD',WSH_DEBUG_SV.C_PROC_LEVEL);
1877: END IF;
1878: --
1879: WSH_OTM_SYNC_REF_DATA_PKG.IS_REF_DATA_SEND_REQD
1880: (

Line 1895: WSH_DEBUG_SV.log(l_module_name,'l_send_allowed', l_send_allowed);

1891: --
1892: -- Debug Statements
1893: --
1894: IF l_debug_on THEN
1895: WSH_DEBUG_SV.log(l_module_name,'l_send_allowed', l_send_allowed);
1896: WSH_DEBUG_SV.log(l_module_name,'l_return_status', l_return_status);
1897: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1898: END IF;
1899: --

Line 1896: WSH_DEBUG_SV.log(l_module_name,'l_return_status', l_return_status);

1892: -- Debug Statements
1893: --
1894: IF l_debug_on THEN
1895: WSH_DEBUG_SV.log(l_module_name,'l_send_allowed', l_send_allowed);
1896: WSH_DEBUG_SV.log(l_module_name,'l_return_status', l_return_status);
1897: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1898: END IF;
1899: --
1900: wsh_util_core.api_post_call(

Line 1897: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

1893: --
1894: IF l_debug_on THEN
1895: WSH_DEBUG_SV.log(l_module_name,'l_send_allowed', l_send_allowed);
1896: WSH_DEBUG_SV.log(l_module_name,'l_return_status', l_return_status);
1897: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1898: END IF;
1899: --
1900: wsh_util_core.api_post_call(
1901: p_return_status => l_return_status,

Line 1907: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.LOCATION_ID',cust_loc_rec.LOCATION_ID);

1903: x_num_errors => l_num_errors);
1904:
1905: IF l_debug_on THEN
1906: --
1907: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.LOCATION_ID',cust_loc_rec.LOCATION_ID);
1908: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ADDRESS1',cust_loc_rec.ADDRESS1);
1909: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ADDRESS2',cust_loc_rec.ADDRESS2);
1910: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ADDRESS3',cust_loc_rec.ADDRESS3);
1911: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ADDRESS4',cust_loc_rec.ADDRESS4);

Line 1908: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ADDRESS1',cust_loc_rec.ADDRESS1);

1904:
1905: IF l_debug_on THEN
1906: --
1907: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.LOCATION_ID',cust_loc_rec.LOCATION_ID);
1908: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ADDRESS1',cust_loc_rec.ADDRESS1);
1909: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ADDRESS2',cust_loc_rec.ADDRESS2);
1910: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ADDRESS3',cust_loc_rec.ADDRESS3);
1911: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ADDRESS4',cust_loc_rec.ADDRESS4);
1912: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.CITY',cust_loc_rec.CITY);

Line 1909: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ADDRESS2',cust_loc_rec.ADDRESS2);

1905: IF l_debug_on THEN
1906: --
1907: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.LOCATION_ID',cust_loc_rec.LOCATION_ID);
1908: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ADDRESS1',cust_loc_rec.ADDRESS1);
1909: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ADDRESS2',cust_loc_rec.ADDRESS2);
1910: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ADDRESS3',cust_loc_rec.ADDRESS3);
1911: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ADDRESS4',cust_loc_rec.ADDRESS4);
1912: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.CITY',cust_loc_rec.CITY);
1913: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.PROVINCE',cust_loc_rec.PROVINCE);

Line 1910: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ADDRESS3',cust_loc_rec.ADDRESS3);

1906: --
1907: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.LOCATION_ID',cust_loc_rec.LOCATION_ID);
1908: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ADDRESS1',cust_loc_rec.ADDRESS1);
1909: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ADDRESS2',cust_loc_rec.ADDRESS2);
1910: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ADDRESS3',cust_loc_rec.ADDRESS3);
1911: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ADDRESS4',cust_loc_rec.ADDRESS4);
1912: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.CITY',cust_loc_rec.CITY);
1913: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.PROVINCE',cust_loc_rec.PROVINCE);
1914: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.STATE',cust_loc_rec.STATE);

Line 1911: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ADDRESS4',cust_loc_rec.ADDRESS4);

1907: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.LOCATION_ID',cust_loc_rec.LOCATION_ID);
1908: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ADDRESS1',cust_loc_rec.ADDRESS1);
1909: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ADDRESS2',cust_loc_rec.ADDRESS2);
1910: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ADDRESS3',cust_loc_rec.ADDRESS3);
1911: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ADDRESS4',cust_loc_rec.ADDRESS4);
1912: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.CITY',cust_loc_rec.CITY);
1913: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.PROVINCE',cust_loc_rec.PROVINCE);
1914: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.STATE',cust_loc_rec.STATE);
1915: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.POSTAL_CODE',cust_loc_rec.POSTAL_CODE);

Line 1912: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.CITY',cust_loc_rec.CITY);

1908: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ADDRESS1',cust_loc_rec.ADDRESS1);
1909: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ADDRESS2',cust_loc_rec.ADDRESS2);
1910: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ADDRESS3',cust_loc_rec.ADDRESS3);
1911: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ADDRESS4',cust_loc_rec.ADDRESS4);
1912: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.CITY',cust_loc_rec.CITY);
1913: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.PROVINCE',cust_loc_rec.PROVINCE);
1914: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.STATE',cust_loc_rec.STATE);
1915: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.POSTAL_CODE',cust_loc_rec.POSTAL_CODE);
1916: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.COUNTRY',cust_loc_rec.COUNTRY);

Line 1913: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.PROVINCE',cust_loc_rec.PROVINCE);

1909: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ADDRESS2',cust_loc_rec.ADDRESS2);
1910: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ADDRESS3',cust_loc_rec.ADDRESS3);
1911: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ADDRESS4',cust_loc_rec.ADDRESS4);
1912: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.CITY',cust_loc_rec.CITY);
1913: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.PROVINCE',cust_loc_rec.PROVINCE);
1914: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.STATE',cust_loc_rec.STATE);
1915: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.POSTAL_CODE',cust_loc_rec.POSTAL_CODE);
1916: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.COUNTRY',cust_loc_rec.COUNTRY);
1917: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.PARTY_NAME',cust_loc_rec.PARTY_NAME);

Line 1914: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.STATE',cust_loc_rec.STATE);

1910: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ADDRESS3',cust_loc_rec.ADDRESS3);
1911: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ADDRESS4',cust_loc_rec.ADDRESS4);
1912: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.CITY',cust_loc_rec.CITY);
1913: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.PROVINCE',cust_loc_rec.PROVINCE);
1914: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.STATE',cust_loc_rec.STATE);
1915: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.POSTAL_CODE',cust_loc_rec.POSTAL_CODE);
1916: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.COUNTRY',cust_loc_rec.COUNTRY);
1917: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.PARTY_NAME',cust_loc_rec.PARTY_NAME);
1918: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.CUST_ACCOUNT_ID',cust_loc_rec.CUST_ACCOUNT_ID);

Line 1915: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.POSTAL_CODE',cust_loc_rec.POSTAL_CODE);

1911: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ADDRESS4',cust_loc_rec.ADDRESS4);
1912: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.CITY',cust_loc_rec.CITY);
1913: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.PROVINCE',cust_loc_rec.PROVINCE);
1914: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.STATE',cust_loc_rec.STATE);
1915: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.POSTAL_CODE',cust_loc_rec.POSTAL_CODE);
1916: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.COUNTRY',cust_loc_rec.COUNTRY);
1917: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.PARTY_NAME',cust_loc_rec.PARTY_NAME);
1918: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.CUST_ACCOUNT_ID',cust_loc_rec.CUST_ACCOUNT_ID);
1919: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ACCOUNT_NUMBER',cust_loc_rec.ACCOUNT_NUMBER);

Line 1916: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.COUNTRY',cust_loc_rec.COUNTRY);

1912: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.CITY',cust_loc_rec.CITY);
1913: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.PROVINCE',cust_loc_rec.PROVINCE);
1914: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.STATE',cust_loc_rec.STATE);
1915: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.POSTAL_CODE',cust_loc_rec.POSTAL_CODE);
1916: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.COUNTRY',cust_loc_rec.COUNTRY);
1917: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.PARTY_NAME',cust_loc_rec.PARTY_NAME);
1918: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.CUST_ACCOUNT_ID',cust_loc_rec.CUST_ACCOUNT_ID);
1919: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ACCOUNT_NUMBER',cust_loc_rec.ACCOUNT_NUMBER);
1920: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.WSH_LOCATION_ID',cust_loc_rec.WSH_LOCATION_ID);

Line 1917: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.PARTY_NAME',cust_loc_rec.PARTY_NAME);

1913: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.PROVINCE',cust_loc_rec.PROVINCE);
1914: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.STATE',cust_loc_rec.STATE);
1915: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.POSTAL_CODE',cust_loc_rec.POSTAL_CODE);
1916: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.COUNTRY',cust_loc_rec.COUNTRY);
1917: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.PARTY_NAME',cust_loc_rec.PARTY_NAME);
1918: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.CUST_ACCOUNT_ID',cust_loc_rec.CUST_ACCOUNT_ID);
1919: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ACCOUNT_NUMBER',cust_loc_rec.ACCOUNT_NUMBER);
1920: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.WSH_LOCATION_ID',cust_loc_rec.WSH_LOCATION_ID);
1921: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.LAST_UPDATE_DATE',cust_loc_rec.LAST_UPDATE_DATE);

Line 1918: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.CUST_ACCOUNT_ID',cust_loc_rec.CUST_ACCOUNT_ID);

1914: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.STATE',cust_loc_rec.STATE);
1915: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.POSTAL_CODE',cust_loc_rec.POSTAL_CODE);
1916: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.COUNTRY',cust_loc_rec.COUNTRY);
1917: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.PARTY_NAME',cust_loc_rec.PARTY_NAME);
1918: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.CUST_ACCOUNT_ID',cust_loc_rec.CUST_ACCOUNT_ID);
1919: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ACCOUNT_NUMBER',cust_loc_rec.ACCOUNT_NUMBER);
1920: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.WSH_LOCATION_ID',cust_loc_rec.WSH_LOCATION_ID);
1921: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.LAST_UPDATE_DATE',cust_loc_rec.LAST_UPDATE_DATE);
1922: WSH_DEBUG_SV.log(l_module_name,'l_last_update_date', l_last_update_date);

Line 1919: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ACCOUNT_NUMBER',cust_loc_rec.ACCOUNT_NUMBER);

1915: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.POSTAL_CODE',cust_loc_rec.POSTAL_CODE);
1916: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.COUNTRY',cust_loc_rec.COUNTRY);
1917: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.PARTY_NAME',cust_loc_rec.PARTY_NAME);
1918: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.CUST_ACCOUNT_ID',cust_loc_rec.CUST_ACCOUNT_ID);
1919: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ACCOUNT_NUMBER',cust_loc_rec.ACCOUNT_NUMBER);
1920: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.WSH_LOCATION_ID',cust_loc_rec.WSH_LOCATION_ID);
1921: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.LAST_UPDATE_DATE',cust_loc_rec.LAST_UPDATE_DATE);
1922: WSH_DEBUG_SV.log(l_module_name,'l_last_update_date', l_last_update_date);
1923: WSH_DEBUG_SV.log(l_module_name,'l_send_allowed', l_send_allowed);

Line 1920: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.WSH_LOCATION_ID',cust_loc_rec.WSH_LOCATION_ID);

1916: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.COUNTRY',cust_loc_rec.COUNTRY);
1917: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.PARTY_NAME',cust_loc_rec.PARTY_NAME);
1918: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.CUST_ACCOUNT_ID',cust_loc_rec.CUST_ACCOUNT_ID);
1919: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ACCOUNT_NUMBER',cust_loc_rec.ACCOUNT_NUMBER);
1920: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.WSH_LOCATION_ID',cust_loc_rec.WSH_LOCATION_ID);
1921: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.LAST_UPDATE_DATE',cust_loc_rec.LAST_UPDATE_DATE);
1922: WSH_DEBUG_SV.log(l_module_name,'l_last_update_date', l_last_update_date);
1923: WSH_DEBUG_SV.log(l_module_name,'l_send_allowed', l_send_allowed);
1924: --

Line 1921: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.LAST_UPDATE_DATE',cust_loc_rec.LAST_UPDATE_DATE);

1917: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.PARTY_NAME',cust_loc_rec.PARTY_NAME);
1918: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.CUST_ACCOUNT_ID',cust_loc_rec.CUST_ACCOUNT_ID);
1919: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ACCOUNT_NUMBER',cust_loc_rec.ACCOUNT_NUMBER);
1920: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.WSH_LOCATION_ID',cust_loc_rec.WSH_LOCATION_ID);
1921: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.LAST_UPDATE_DATE',cust_loc_rec.LAST_UPDATE_DATE);
1922: WSH_DEBUG_SV.log(l_module_name,'l_last_update_date', l_last_update_date);
1923: WSH_DEBUG_SV.log(l_module_name,'l_send_allowed', l_send_allowed);
1924: --
1925: END IF;

Line 1922: WSH_DEBUG_SV.log(l_module_name,'l_last_update_date', l_last_update_date);

1918: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.CUST_ACCOUNT_ID',cust_loc_rec.CUST_ACCOUNT_ID);
1919: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ACCOUNT_NUMBER',cust_loc_rec.ACCOUNT_NUMBER);
1920: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.WSH_LOCATION_ID',cust_loc_rec.WSH_LOCATION_ID);
1921: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.LAST_UPDATE_DATE',cust_loc_rec.LAST_UPDATE_DATE);
1922: WSH_DEBUG_SV.log(l_module_name,'l_last_update_date', l_last_update_date);
1923: WSH_DEBUG_SV.log(l_module_name,'l_send_allowed', l_send_allowed);
1924: --
1925: END IF;
1926: --

Line 1923: WSH_DEBUG_SV.log(l_module_name,'l_send_allowed', l_send_allowed);

1919: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ACCOUNT_NUMBER',cust_loc_rec.ACCOUNT_NUMBER);
1920: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.WSH_LOCATION_ID',cust_loc_rec.WSH_LOCATION_ID);
1921: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.LAST_UPDATE_DATE',cust_loc_rec.LAST_UPDATE_DATE);
1922: WSH_DEBUG_SV.log(l_module_name,'l_last_update_date', l_last_update_date);
1923: WSH_DEBUG_SV.log(l_module_name,'l_send_allowed', l_send_allowed);
1924: --
1925: END IF;
1926: --
1927: IF (l_send_allowed) THEN

Line 2113: WSH_DEBUG_SV.log(l_module_name,'l_contact_ph_cntr_code_tbl('||k||')',l_contact_ph_cntr_code_tbl(k));

2109: x_loc_xmission_rec.LOCATIONS_TBL(i).LOC_CONTACT_TBL(k).TXN_CODE := 'IU';
2110:
2111: IF l_debug_on THEN
2112: --
2113: WSH_DEBUG_SV.log(l_module_name,'l_contact_ph_cntr_code_tbl('||k||')',l_contact_ph_cntr_code_tbl(k));
2114: WSH_DEBUG_SV.log(l_module_name,'l_contact_ph_area_code_tbl('||k||')',l_contact_ph_area_code_tbl(k));
2115: WSH_DEBUG_SV.log(l_module_name,'l_contact_ph_number_tbl('||k||')',l_contact_ph_number_tbl(k));
2116: WSH_DEBUG_SV.log(l_module_name,'l_contact_email_addr_tbl('||k||')',l_contact_email_addr_tbl(k));
2117: WSH_DEBUG_SV.log(l_module_name,'l_contact_first_name_tbl('||k||')',l_contact_first_name_tbl(k));

Line 2114: WSH_DEBUG_SV.log(l_module_name,'l_contact_ph_area_code_tbl('||k||')',l_contact_ph_area_code_tbl(k));

2110:
2111: IF l_debug_on THEN
2112: --
2113: WSH_DEBUG_SV.log(l_module_name,'l_contact_ph_cntr_code_tbl('||k||')',l_contact_ph_cntr_code_tbl(k));
2114: WSH_DEBUG_SV.log(l_module_name,'l_contact_ph_area_code_tbl('||k||')',l_contact_ph_area_code_tbl(k));
2115: WSH_DEBUG_SV.log(l_module_name,'l_contact_ph_number_tbl('||k||')',l_contact_ph_number_tbl(k));
2116: WSH_DEBUG_SV.log(l_module_name,'l_contact_email_addr_tbl('||k||')',l_contact_email_addr_tbl(k));
2117: WSH_DEBUG_SV.log(l_module_name,'l_contact_first_name_tbl('||k||')',l_contact_first_name_tbl(k));
2118: WSH_DEBUG_SV.log(l_module_name,'l_contact_last_name_tbl('||k||')',l_contact_last_name_tbl(k));

Line 2115: WSH_DEBUG_SV.log(l_module_name,'l_contact_ph_number_tbl('||k||')',l_contact_ph_number_tbl(k));

2111: IF l_debug_on THEN
2112: --
2113: WSH_DEBUG_SV.log(l_module_name,'l_contact_ph_cntr_code_tbl('||k||')',l_contact_ph_cntr_code_tbl(k));
2114: WSH_DEBUG_SV.log(l_module_name,'l_contact_ph_area_code_tbl('||k||')',l_contact_ph_area_code_tbl(k));
2115: WSH_DEBUG_SV.log(l_module_name,'l_contact_ph_number_tbl('||k||')',l_contact_ph_number_tbl(k));
2116: WSH_DEBUG_SV.log(l_module_name,'l_contact_email_addr_tbl('||k||')',l_contact_email_addr_tbl(k));
2117: WSH_DEBUG_SV.log(l_module_name,'l_contact_first_name_tbl('||k||')',l_contact_first_name_tbl(k));
2118: WSH_DEBUG_SV.log(l_module_name,'l_contact_last_name_tbl('||k||')',l_contact_last_name_tbl(k));
2119: WSH_DEBUG_SV.log(l_module_name,'l_contact_job_title_tbl('||k||')',l_contact_job_title_tbl(k));

Line 2116: WSH_DEBUG_SV.log(l_module_name,'l_contact_email_addr_tbl('||k||')',l_contact_email_addr_tbl(k));

2112: --
2113: WSH_DEBUG_SV.log(l_module_name,'l_contact_ph_cntr_code_tbl('||k||')',l_contact_ph_cntr_code_tbl(k));
2114: WSH_DEBUG_SV.log(l_module_name,'l_contact_ph_area_code_tbl('||k||')',l_contact_ph_area_code_tbl(k));
2115: WSH_DEBUG_SV.log(l_module_name,'l_contact_ph_number_tbl('||k||')',l_contact_ph_number_tbl(k));
2116: WSH_DEBUG_SV.log(l_module_name,'l_contact_email_addr_tbl('||k||')',l_contact_email_addr_tbl(k));
2117: WSH_DEBUG_SV.log(l_module_name,'l_contact_first_name_tbl('||k||')',l_contact_first_name_tbl(k));
2118: WSH_DEBUG_SV.log(l_module_name,'l_contact_last_name_tbl('||k||')',l_contact_last_name_tbl(k));
2119: WSH_DEBUG_SV.log(l_module_name,'l_contact_job_title_tbl('||k||')',l_contact_job_title_tbl(k));
2120: --

Line 2117: WSH_DEBUG_SV.log(l_module_name,'l_contact_first_name_tbl('||k||')',l_contact_first_name_tbl(k));

2113: WSH_DEBUG_SV.log(l_module_name,'l_contact_ph_cntr_code_tbl('||k||')',l_contact_ph_cntr_code_tbl(k));
2114: WSH_DEBUG_SV.log(l_module_name,'l_contact_ph_area_code_tbl('||k||')',l_contact_ph_area_code_tbl(k));
2115: WSH_DEBUG_SV.log(l_module_name,'l_contact_ph_number_tbl('||k||')',l_contact_ph_number_tbl(k));
2116: WSH_DEBUG_SV.log(l_module_name,'l_contact_email_addr_tbl('||k||')',l_contact_email_addr_tbl(k));
2117: WSH_DEBUG_SV.log(l_module_name,'l_contact_first_name_tbl('||k||')',l_contact_first_name_tbl(k));
2118: WSH_DEBUG_SV.log(l_module_name,'l_contact_last_name_tbl('||k||')',l_contact_last_name_tbl(k));
2119: WSH_DEBUG_SV.log(l_module_name,'l_contact_job_title_tbl('||k||')',l_contact_job_title_tbl(k));
2120: --
2121: END IF;

Line 2118: WSH_DEBUG_SV.log(l_module_name,'l_contact_last_name_tbl('||k||')',l_contact_last_name_tbl(k));

2114: WSH_DEBUG_SV.log(l_module_name,'l_contact_ph_area_code_tbl('||k||')',l_contact_ph_area_code_tbl(k));
2115: WSH_DEBUG_SV.log(l_module_name,'l_contact_ph_number_tbl('||k||')',l_contact_ph_number_tbl(k));
2116: WSH_DEBUG_SV.log(l_module_name,'l_contact_email_addr_tbl('||k||')',l_contact_email_addr_tbl(k));
2117: WSH_DEBUG_SV.log(l_module_name,'l_contact_first_name_tbl('||k||')',l_contact_first_name_tbl(k));
2118: WSH_DEBUG_SV.log(l_module_name,'l_contact_last_name_tbl('||k||')',l_contact_last_name_tbl(k));
2119: WSH_DEBUG_SV.log(l_module_name,'l_contact_job_title_tbl('||k||')',l_contact_job_title_tbl(k));
2120: --
2121: END IF;
2122: l_contact_ph := NULL;

Line 2119: WSH_DEBUG_SV.log(l_module_name,'l_contact_job_title_tbl('||k||')',l_contact_job_title_tbl(k));

2115: WSH_DEBUG_SV.log(l_module_name,'l_contact_ph_number_tbl('||k||')',l_contact_ph_number_tbl(k));
2116: WSH_DEBUG_SV.log(l_module_name,'l_contact_email_addr_tbl('||k||')',l_contact_email_addr_tbl(k));
2117: WSH_DEBUG_SV.log(l_module_name,'l_contact_first_name_tbl('||k||')',l_contact_first_name_tbl(k));
2118: WSH_DEBUG_SV.log(l_module_name,'l_contact_last_name_tbl('||k||')',l_contact_last_name_tbl(k));
2119: WSH_DEBUG_SV.log(l_module_name,'l_contact_job_title_tbl('||k||')',l_contact_job_title_tbl(k));
2120: --
2121: END IF;
2122: l_contact_ph := NULL;
2123:

Line 2166: WSH_DEBUG_SV.log(l_module_name,'x_loc_xmission_rec.username', x_loc_xmission_rec.username);

2162: FND_PROFILE.Get('WSH_OTM_USER_ID',x_loc_xmission_rec.username);
2163: FND_PROFILE.Get('WSH_OTM_PASSWORD',x_loc_xmission_rec.password);
2164:
2165: IF l_debug_on THEN
2166: WSH_DEBUG_SV.log(l_module_name,'x_loc_xmission_rec.username', x_loc_xmission_rec.username);
2167: WSH_DEBUG_SV.log(l_module_name,'x_loc_xmission_rec.password', x_loc_xmission_rec.password);
2168: END IF;
2169:
2170: IF (x_loc_xmission_rec.username is null) THEN

Line 2167: WSH_DEBUG_SV.log(l_module_name,'x_loc_xmission_rec.password', x_loc_xmission_rec.password);

2163: FND_PROFILE.Get('WSH_OTM_PASSWORD',x_loc_xmission_rec.password);
2164:
2165: IF l_debug_on THEN
2166: WSH_DEBUG_SV.log(l_module_name,'x_loc_xmission_rec.username', x_loc_xmission_rec.username);
2167: WSH_DEBUG_SV.log(l_module_name,'x_loc_xmission_rec.password', x_loc_xmission_rec.password);
2168: END IF;
2169:
2170: IF (x_loc_xmission_rec.username is null) THEN
2171: --{

Line 2177: WSH_DEBUG_SV.logmsg(l_module_name,'Error: The profile WSH_OTM_USER_ID is set to NULL. Please correct the profile value');

2173: FND_MESSAGE.SET_TOKEN('PRF_NAME','WSH_OTM_USER_ID');
2174: x_return_status := wsh_util_core.G_RET_STS_UNEXP_ERROR;
2175: wsh_util_core.add_message(x_return_status, l_module_name);
2176: IF l_debug_on THEN
2177: WSH_DEBUG_SV.logmsg(l_module_name,'Error: The profile WSH_OTM_USER_ID is set to NULL. Please correct the profile value');
2178: END IF;
2179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2180: --}
2181: END IF;

Line 2190: WSH_DEBUG_SV.logmsg(l_module_name,'Error: The profile WSH_OTM_PASSWORD is set to NULL. Please correct the profile value');

2186: FND_MESSAGE.SET_TOKEN('PRF_NAME','WSH_OTM_PASSWORD');
2187: x_return_status := wsh_util_core.G_RET_STS_UNEXP_ERROR;
2188: wsh_util_core.add_message(x_return_status, l_module_name);
2189: IF l_debug_on THEN
2190: WSH_DEBUG_SV.logmsg(l_module_name,'Error: The profile WSH_OTM_PASSWORD is set to NULL. Please correct the profile value');
2191: END IF;
2192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2193: --}
2194: END IF;

Line 2206: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_OTM_SYNC_REF_DATA_PKG.IS_REF_DATA_SEND_REQD',WSH_DEBUG_SV.C_PROC_LEVEL);

2202: -- of storing already sent carriers
2203: -- Debug Statements
2204: --
2205: IF l_debug_on THEN
2206: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_OTM_SYNC_REF_DATA_PKG.IS_REF_DATA_SEND_REQD',WSH_DEBUG_SV.C_PROC_LEVEL);
2207: END IF;
2208: --
2209:
2210: WSH_OTM_SYNC_REF_DATA_PKG.IS_REF_DATA_SEND_REQD

Line 2226: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling IS_REF_DATA_SEND_REQD is', l_return_status);

2222: --
2223: -- Debug Statements
2224: --
2225: IF l_debug_on THEN
2226: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling IS_REF_DATA_SEND_REQD is', l_return_status);
2227: WSH_DEBUG_SV.log(l_module_name,'l_send_allowed', l_send_allowed);
2228: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2229: END IF;
2230: --

Line 2227: WSH_DEBUG_SV.log(l_module_name,'l_send_allowed', l_send_allowed);

2223: -- Debug Statements
2224: --
2225: IF l_debug_on THEN
2226: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling IS_REF_DATA_SEND_REQD is', l_return_status);
2227: WSH_DEBUG_SV.log(l_module_name,'l_send_allowed', l_send_allowed);
2228: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2229: END IF;
2230: --
2231: wsh_util_core.api_post_call(

Line 2228: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

2224: --
2225: IF l_debug_on THEN
2226: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling IS_REF_DATA_SEND_REQD is', l_return_status);
2227: WSH_DEBUG_SV.log(l_module_name,'l_send_allowed', l_send_allowed);
2228: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2229: END IF;
2230: --
2231: wsh_util_core.api_post_call(
2232: p_return_status => l_return_status,

Line 2239: WSH_DEBUG_SV.log(l_module_name,'Current carrier_id',carrier_loc_rec.CARRIER_ID);

2235: */
2236:
2237: IF l_debug_on THEN
2238: --
2239: WSH_DEBUG_SV.log(l_module_name,'Current carrier_id',carrier_loc_rec.CARRIER_ID);
2240: WSH_DEBUG_SV.log(l_module_name,'Previous carrier_id', l_prev_carrier_id);
2241: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.CARRIER_SITE_ID',carrier_loc_rec.CARRIER_SITE_ID);
2242: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.CARRIER_NAME',carrier_loc_rec.CARRIER_NAME);
2243: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.LOCATION_NAME',carrier_loc_rec.LOCATION_NAME);

Line 2240: WSH_DEBUG_SV.log(l_module_name,'Previous carrier_id', l_prev_carrier_id);

2236:
2237: IF l_debug_on THEN
2238: --
2239: WSH_DEBUG_SV.log(l_module_name,'Current carrier_id',carrier_loc_rec.CARRIER_ID);
2240: WSH_DEBUG_SV.log(l_module_name,'Previous carrier_id', l_prev_carrier_id);
2241: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.CARRIER_SITE_ID',carrier_loc_rec.CARRIER_SITE_ID);
2242: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.CARRIER_NAME',carrier_loc_rec.CARRIER_NAME);
2243: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.LOCATION_NAME',carrier_loc_rec.LOCATION_NAME);
2244: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS1',carrier_loc_rec.ADDRESS1);

Line 2241: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.CARRIER_SITE_ID',carrier_loc_rec.CARRIER_SITE_ID);

2237: IF l_debug_on THEN
2238: --
2239: WSH_DEBUG_SV.log(l_module_name,'Current carrier_id',carrier_loc_rec.CARRIER_ID);
2240: WSH_DEBUG_SV.log(l_module_name,'Previous carrier_id', l_prev_carrier_id);
2241: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.CARRIER_SITE_ID',carrier_loc_rec.CARRIER_SITE_ID);
2242: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.CARRIER_NAME',carrier_loc_rec.CARRIER_NAME);
2243: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.LOCATION_NAME',carrier_loc_rec.LOCATION_NAME);
2244: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS1',carrier_loc_rec.ADDRESS1);
2245: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS2',carrier_loc_rec.ADDRESS2);

Line 2242: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.CARRIER_NAME',carrier_loc_rec.CARRIER_NAME);

2238: --
2239: WSH_DEBUG_SV.log(l_module_name,'Current carrier_id',carrier_loc_rec.CARRIER_ID);
2240: WSH_DEBUG_SV.log(l_module_name,'Previous carrier_id', l_prev_carrier_id);
2241: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.CARRIER_SITE_ID',carrier_loc_rec.CARRIER_SITE_ID);
2242: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.CARRIER_NAME',carrier_loc_rec.CARRIER_NAME);
2243: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.LOCATION_NAME',carrier_loc_rec.LOCATION_NAME);
2244: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS1',carrier_loc_rec.ADDRESS1);
2245: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS2',carrier_loc_rec.ADDRESS2);
2246: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS3',carrier_loc_rec.ADDRESS3);

Line 2243: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.LOCATION_NAME',carrier_loc_rec.LOCATION_NAME);

2239: WSH_DEBUG_SV.log(l_module_name,'Current carrier_id',carrier_loc_rec.CARRIER_ID);
2240: WSH_DEBUG_SV.log(l_module_name,'Previous carrier_id', l_prev_carrier_id);
2241: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.CARRIER_SITE_ID',carrier_loc_rec.CARRIER_SITE_ID);
2242: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.CARRIER_NAME',carrier_loc_rec.CARRIER_NAME);
2243: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.LOCATION_NAME',carrier_loc_rec.LOCATION_NAME);
2244: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS1',carrier_loc_rec.ADDRESS1);
2245: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS2',carrier_loc_rec.ADDRESS2);
2246: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS3',carrier_loc_rec.ADDRESS3);
2247: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS4',carrier_loc_rec.ADDRESS4);

Line 2244: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS1',carrier_loc_rec.ADDRESS1);

2240: WSH_DEBUG_SV.log(l_module_name,'Previous carrier_id', l_prev_carrier_id);
2241: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.CARRIER_SITE_ID',carrier_loc_rec.CARRIER_SITE_ID);
2242: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.CARRIER_NAME',carrier_loc_rec.CARRIER_NAME);
2243: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.LOCATION_NAME',carrier_loc_rec.LOCATION_NAME);
2244: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS1',carrier_loc_rec.ADDRESS1);
2245: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS2',carrier_loc_rec.ADDRESS2);
2246: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS3',carrier_loc_rec.ADDRESS3);
2247: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS4',carrier_loc_rec.ADDRESS4);
2248: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.CITY',carrier_loc_rec.CITY);

Line 2245: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS2',carrier_loc_rec.ADDRESS2);

2241: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.CARRIER_SITE_ID',carrier_loc_rec.CARRIER_SITE_ID);
2242: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.CARRIER_NAME',carrier_loc_rec.CARRIER_NAME);
2243: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.LOCATION_NAME',carrier_loc_rec.LOCATION_NAME);
2244: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS1',carrier_loc_rec.ADDRESS1);
2245: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS2',carrier_loc_rec.ADDRESS2);
2246: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS3',carrier_loc_rec.ADDRESS3);
2247: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS4',carrier_loc_rec.ADDRESS4);
2248: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.CITY',carrier_loc_rec.CITY);
2249: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.PROVINCE',carrier_loc_rec.PROVINCE);

Line 2246: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS3',carrier_loc_rec.ADDRESS3);

2242: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.CARRIER_NAME',carrier_loc_rec.CARRIER_NAME);
2243: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.LOCATION_NAME',carrier_loc_rec.LOCATION_NAME);
2244: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS1',carrier_loc_rec.ADDRESS1);
2245: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS2',carrier_loc_rec.ADDRESS2);
2246: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS3',carrier_loc_rec.ADDRESS3);
2247: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS4',carrier_loc_rec.ADDRESS4);
2248: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.CITY',carrier_loc_rec.CITY);
2249: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.PROVINCE',carrier_loc_rec.PROVINCE);
2250: --WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.PROVINCE_CODE',carrier_loc_rec.PROVINCE_CODE);

Line 2247: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS4',carrier_loc_rec.ADDRESS4);

2243: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.LOCATION_NAME',carrier_loc_rec.LOCATION_NAME);
2244: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS1',carrier_loc_rec.ADDRESS1);
2245: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS2',carrier_loc_rec.ADDRESS2);
2246: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS3',carrier_loc_rec.ADDRESS3);
2247: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS4',carrier_loc_rec.ADDRESS4);
2248: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.CITY',carrier_loc_rec.CITY);
2249: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.PROVINCE',carrier_loc_rec.PROVINCE);
2250: --WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.PROVINCE_CODE',carrier_loc_rec.PROVINCE_CODE);
2251: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.POSTAL_CODE',carrier_loc_rec.POSTAL_CODE);

Line 2248: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.CITY',carrier_loc_rec.CITY);

2244: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS1',carrier_loc_rec.ADDRESS1);
2245: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS2',carrier_loc_rec.ADDRESS2);
2246: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS3',carrier_loc_rec.ADDRESS3);
2247: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS4',carrier_loc_rec.ADDRESS4);
2248: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.CITY',carrier_loc_rec.CITY);
2249: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.PROVINCE',carrier_loc_rec.PROVINCE);
2250: --WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.PROVINCE_CODE',carrier_loc_rec.PROVINCE_CODE);
2251: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.POSTAL_CODE',carrier_loc_rec.POSTAL_CODE);
2252: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.COUNTRY',carrier_loc_rec.COUNTRY);

Line 2249: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.PROVINCE',carrier_loc_rec.PROVINCE);

2245: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS2',carrier_loc_rec.ADDRESS2);
2246: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS3',carrier_loc_rec.ADDRESS3);
2247: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS4',carrier_loc_rec.ADDRESS4);
2248: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.CITY',carrier_loc_rec.CITY);
2249: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.PROVINCE',carrier_loc_rec.PROVINCE);
2250: --WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.PROVINCE_CODE',carrier_loc_rec.PROVINCE_CODE);
2251: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.POSTAL_CODE',carrier_loc_rec.POSTAL_CODE);
2252: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.COUNTRY',carrier_loc_rec.COUNTRY);
2253: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.SUPPLIER_ID',carrier_loc_rec.SUPPLIER_ID);

Line 2250: --WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.PROVINCE_CODE',carrier_loc_rec.PROVINCE_CODE);

2246: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS3',carrier_loc_rec.ADDRESS3);
2247: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS4',carrier_loc_rec.ADDRESS4);
2248: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.CITY',carrier_loc_rec.CITY);
2249: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.PROVINCE',carrier_loc_rec.PROVINCE);
2250: --WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.PROVINCE_CODE',carrier_loc_rec.PROVINCE_CODE);
2251: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.POSTAL_CODE',carrier_loc_rec.POSTAL_CODE);
2252: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.COUNTRY',carrier_loc_rec.COUNTRY);
2253: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.SUPPLIER_ID',carrier_loc_rec.SUPPLIER_ID);
2254: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.SCAC_CODE',carrier_loc_rec.SCAC_CODE);

Line 2251: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.POSTAL_CODE',carrier_loc_rec.POSTAL_CODE);

2247: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS4',carrier_loc_rec.ADDRESS4);
2248: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.CITY',carrier_loc_rec.CITY);
2249: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.PROVINCE',carrier_loc_rec.PROVINCE);
2250: --WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.PROVINCE_CODE',carrier_loc_rec.PROVINCE_CODE);
2251: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.POSTAL_CODE',carrier_loc_rec.POSTAL_CODE);
2252: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.COUNTRY',carrier_loc_rec.COUNTRY);
2253: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.SUPPLIER_ID',carrier_loc_rec.SUPPLIER_ID);
2254: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.SCAC_CODE',carrier_loc_rec.SCAC_CODE);
2255: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.LOCATION_ID',carrier_loc_rec.LOCATION_ID);

Line 2252: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.COUNTRY',carrier_loc_rec.COUNTRY);

2248: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.CITY',carrier_loc_rec.CITY);
2249: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.PROVINCE',carrier_loc_rec.PROVINCE);
2250: --WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.PROVINCE_CODE',carrier_loc_rec.PROVINCE_CODE);
2251: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.POSTAL_CODE',carrier_loc_rec.POSTAL_CODE);
2252: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.COUNTRY',carrier_loc_rec.COUNTRY);
2253: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.SUPPLIER_ID',carrier_loc_rec.SUPPLIER_ID);
2254: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.SCAC_CODE',carrier_loc_rec.SCAC_CODE);
2255: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.LOCATION_ID',carrier_loc_rec.LOCATION_ID);
2256: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.WSH_LOCATION_ID',carrier_loc_rec.WSH_LOCATION_ID);

Line 2253: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.SUPPLIER_ID',carrier_loc_rec.SUPPLIER_ID);

2249: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.PROVINCE',carrier_loc_rec.PROVINCE);
2250: --WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.PROVINCE_CODE',carrier_loc_rec.PROVINCE_CODE);
2251: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.POSTAL_CODE',carrier_loc_rec.POSTAL_CODE);
2252: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.COUNTRY',carrier_loc_rec.COUNTRY);
2253: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.SUPPLIER_ID',carrier_loc_rec.SUPPLIER_ID);
2254: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.SCAC_CODE',carrier_loc_rec.SCAC_CODE);
2255: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.LOCATION_ID',carrier_loc_rec.LOCATION_ID);
2256: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.WSH_LOCATION_ID',carrier_loc_rec.WSH_LOCATION_ID);
2257: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.HZL_LAST_UPD_DATE',carrier_loc_rec.HZL_LAST_UPD_DATE);

Line 2254: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.SCAC_CODE',carrier_loc_rec.SCAC_CODE);

2250: --WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.PROVINCE_CODE',carrier_loc_rec.PROVINCE_CODE);
2251: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.POSTAL_CODE',carrier_loc_rec.POSTAL_CODE);
2252: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.COUNTRY',carrier_loc_rec.COUNTRY);
2253: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.SUPPLIER_ID',carrier_loc_rec.SUPPLIER_ID);
2254: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.SCAC_CODE',carrier_loc_rec.SCAC_CODE);
2255: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.LOCATION_ID',carrier_loc_rec.LOCATION_ID);
2256: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.WSH_LOCATION_ID',carrier_loc_rec.WSH_LOCATION_ID);
2257: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.HZL_LAST_UPD_DATE',carrier_loc_rec.HZL_LAST_UPD_DATE);
2258: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.WCV_LAST_UPD_DATE',carrier_loc_rec.WCV_LAST_UPD_DATE);

Line 2255: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.LOCATION_ID',carrier_loc_rec.LOCATION_ID);

2251: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.POSTAL_CODE',carrier_loc_rec.POSTAL_CODE);
2252: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.COUNTRY',carrier_loc_rec.COUNTRY);
2253: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.SUPPLIER_ID',carrier_loc_rec.SUPPLIER_ID);
2254: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.SCAC_CODE',carrier_loc_rec.SCAC_CODE);
2255: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.LOCATION_ID',carrier_loc_rec.LOCATION_ID);
2256: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.WSH_LOCATION_ID',carrier_loc_rec.WSH_LOCATION_ID);
2257: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.HZL_LAST_UPD_DATE',carrier_loc_rec.HZL_LAST_UPD_DATE);
2258: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.WCV_LAST_UPD_DATE',carrier_loc_rec.WCV_LAST_UPD_DATE);
2259: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.HPS_LAST_UPD_DATE',carrier_loc_rec.HPS_LAST_UPD_DATE);

Line 2256: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.WSH_LOCATION_ID',carrier_loc_rec.WSH_LOCATION_ID);

2252: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.COUNTRY',carrier_loc_rec.COUNTRY);
2253: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.SUPPLIER_ID',carrier_loc_rec.SUPPLIER_ID);
2254: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.SCAC_CODE',carrier_loc_rec.SCAC_CODE);
2255: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.LOCATION_ID',carrier_loc_rec.LOCATION_ID);
2256: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.WSH_LOCATION_ID',carrier_loc_rec.WSH_LOCATION_ID);
2257: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.HZL_LAST_UPD_DATE',carrier_loc_rec.HZL_LAST_UPD_DATE);
2258: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.WCV_LAST_UPD_DATE',carrier_loc_rec.WCV_LAST_UPD_DATE);
2259: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.HPS_LAST_UPD_DATE',carrier_loc_rec.HPS_LAST_UPD_DATE);
2260: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.HP_LAST_UPD_DATE',carrier_loc_rec.HP_LAST_UPD_DATE);

Line 2257: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.HZL_LAST_UPD_DATE',carrier_loc_rec.HZL_LAST_UPD_DATE);

2253: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.SUPPLIER_ID',carrier_loc_rec.SUPPLIER_ID);
2254: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.SCAC_CODE',carrier_loc_rec.SCAC_CODE);
2255: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.LOCATION_ID',carrier_loc_rec.LOCATION_ID);
2256: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.WSH_LOCATION_ID',carrier_loc_rec.WSH_LOCATION_ID);
2257: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.HZL_LAST_UPD_DATE',carrier_loc_rec.HZL_LAST_UPD_DATE);
2258: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.WCV_LAST_UPD_DATE',carrier_loc_rec.WCV_LAST_UPD_DATE);
2259: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.HPS_LAST_UPD_DATE',carrier_loc_rec.HPS_LAST_UPD_DATE);
2260: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.HP_LAST_UPD_DATE',carrier_loc_rec.HP_LAST_UPD_DATE);
2261: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.SUPPLIER_SITE_ID',carrier_loc_rec.SUPPLIER_SITE_ID);

Line 2258: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.WCV_LAST_UPD_DATE',carrier_loc_rec.WCV_LAST_UPD_DATE);

2254: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.SCAC_CODE',carrier_loc_rec.SCAC_CODE);
2255: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.LOCATION_ID',carrier_loc_rec.LOCATION_ID);
2256: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.WSH_LOCATION_ID',carrier_loc_rec.WSH_LOCATION_ID);
2257: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.HZL_LAST_UPD_DATE',carrier_loc_rec.HZL_LAST_UPD_DATE);
2258: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.WCV_LAST_UPD_DATE',carrier_loc_rec.WCV_LAST_UPD_DATE);
2259: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.HPS_LAST_UPD_DATE',carrier_loc_rec.HPS_LAST_UPD_DATE);
2260: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.HP_LAST_UPD_DATE',carrier_loc_rec.HP_LAST_UPD_DATE);
2261: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.SUPPLIER_SITE_ID',carrier_loc_rec.SUPPLIER_SITE_ID);
2262: WSH_DEBUG_SV.log(l_module_name,'l_last_update_date', l_last_update_date);

Line 2259: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.HPS_LAST_UPD_DATE',carrier_loc_rec.HPS_LAST_UPD_DATE);

2255: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.LOCATION_ID',carrier_loc_rec.LOCATION_ID);
2256: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.WSH_LOCATION_ID',carrier_loc_rec.WSH_LOCATION_ID);
2257: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.HZL_LAST_UPD_DATE',carrier_loc_rec.HZL_LAST_UPD_DATE);
2258: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.WCV_LAST_UPD_DATE',carrier_loc_rec.WCV_LAST_UPD_DATE);
2259: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.HPS_LAST_UPD_DATE',carrier_loc_rec.HPS_LAST_UPD_DATE);
2260: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.HP_LAST_UPD_DATE',carrier_loc_rec.HP_LAST_UPD_DATE);
2261: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.SUPPLIER_SITE_ID',carrier_loc_rec.SUPPLIER_SITE_ID);
2262: WSH_DEBUG_SV.log(l_module_name,'l_last_update_date', l_last_update_date);
2263: --

Line 2260: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.HP_LAST_UPD_DATE',carrier_loc_rec.HP_LAST_UPD_DATE);

2256: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.WSH_LOCATION_ID',carrier_loc_rec.WSH_LOCATION_ID);
2257: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.HZL_LAST_UPD_DATE',carrier_loc_rec.HZL_LAST_UPD_DATE);
2258: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.WCV_LAST_UPD_DATE',carrier_loc_rec.WCV_LAST_UPD_DATE);
2259: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.HPS_LAST_UPD_DATE',carrier_loc_rec.HPS_LAST_UPD_DATE);
2260: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.HP_LAST_UPD_DATE',carrier_loc_rec.HP_LAST_UPD_DATE);
2261: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.SUPPLIER_SITE_ID',carrier_loc_rec.SUPPLIER_SITE_ID);
2262: WSH_DEBUG_SV.log(l_module_name,'l_last_update_date', l_last_update_date);
2263: --
2264: END IF;

Line 2261: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.SUPPLIER_SITE_ID',carrier_loc_rec.SUPPLIER_SITE_ID);

2257: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.HZL_LAST_UPD_DATE',carrier_loc_rec.HZL_LAST_UPD_DATE);
2258: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.WCV_LAST_UPD_DATE',carrier_loc_rec.WCV_LAST_UPD_DATE);
2259: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.HPS_LAST_UPD_DATE',carrier_loc_rec.HPS_LAST_UPD_DATE);
2260: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.HP_LAST_UPD_DATE',carrier_loc_rec.HP_LAST_UPD_DATE);
2261: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.SUPPLIER_SITE_ID',carrier_loc_rec.SUPPLIER_SITE_ID);
2262: WSH_DEBUG_SV.log(l_module_name,'l_last_update_date', l_last_update_date);
2263: --
2264: END IF;
2265:

Line 2262: WSH_DEBUG_SV.log(l_module_name,'l_last_update_date', l_last_update_date);

2258: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.WCV_LAST_UPD_DATE',carrier_loc_rec.WCV_LAST_UPD_DATE);
2259: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.HPS_LAST_UPD_DATE',carrier_loc_rec.HPS_LAST_UPD_DATE);
2260: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.HP_LAST_UPD_DATE',carrier_loc_rec.HP_LAST_UPD_DATE);
2261: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.SUPPLIER_SITE_ID',carrier_loc_rec.SUPPLIER_SITE_ID);
2262: WSH_DEBUG_SV.log(l_module_name,'l_last_update_date', l_last_update_date);
2263: --
2264: END IF;
2265:
2266: IF (nvl(l_prev_carrier_id,-999) <> nvl(l_carrier_id,-998)) THEN

Line 2547: WSH_DEBUG_SV.pop(l_module_name);

2543: --
2544: -- Debug Statements
2545: --
2546: IF l_debug_on THEN
2547: WSH_DEBUG_SV.pop(l_module_name);
2548: END IF;
2549: --
2550: EXCEPTION
2551: --{

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

2555: --
2556: -- Debug Statements
2557: --
2558: IF l_debug_on THEN
2559: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2560: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2561: END IF;
2562: --
2563: END EXTRACT_LOCATION_INFO;

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

2556: -- Debug Statements
2557: --
2558: IF l_debug_on THEN
2559: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2560: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2561: END IF;
2562: --
2563: END EXTRACT_LOCATION_INFO;
2564:

Line 2604: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

2600: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2601: --
2602: IF l_debug_on IS NULL
2603: THEN
2604: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2605: END IF;
2606: --
2607: --
2608: -- Debug Statements

Line 2611: WSH_DEBUG_SV.push(l_module_name);

2607: --
2608: -- Debug Statements
2609: --
2610: IF l_debug_on THEN
2611: WSH_DEBUG_SV.push(l_module_name);
2612: WSH_DEBUG_SV.log(l_module_name,'entity type is ', p_entity_in_rec.entity_type);
2613: END IF;
2614: --
2615: x_return_status := wsh_util_core.g_ret_sts_success;

Line 2612: WSH_DEBUG_SV.log(l_module_name,'entity type is ', p_entity_in_rec.entity_type);

2608: -- Debug Statements
2609: --
2610: IF l_debug_on THEN
2611: WSH_DEBUG_SV.push(l_module_name);
2612: WSH_DEBUG_SV.log(l_module_name,'entity type is ', p_entity_in_rec.entity_type);
2613: END IF;
2614: --
2615: x_return_status := wsh_util_core.g_ret_sts_success;
2616:

Line 2632: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

2628: --
2629: -- Debug Statements
2630: --
2631: IF l_debug_on THEN
2632: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2633: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling EXTRACT_TRIP_INFO is', l_return_status);
2634: END IF;
2635: --
2636: wsh_util_core.api_post_call(

Line 2633: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling EXTRACT_TRIP_INFO is', l_return_status);

2629: -- Debug Statements
2630: --
2631: IF l_debug_on THEN
2632: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2633: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling EXTRACT_TRIP_INFO is', l_return_status);
2634: END IF;
2635: --
2636: wsh_util_core.api_post_call(
2637: p_return_status => l_return_status,

Line 2656: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

2652: --
2653: -- Debug Statements
2654: --
2655: IF l_debug_on THEN
2656: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2657: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling EXTRACT_TRIP_INFO is', l_return_status);
2658: END IF;
2659: --
2660: wsh_util_core.api_post_call(

Line 2657: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling EXTRACT_TRIP_INFO is', l_return_status);

2653: -- Debug Statements
2654: --
2655: IF l_debug_on THEN
2656: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2657: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling EXTRACT_TRIP_INFO is', l_return_status);
2658: END IF;
2659: --
2660: wsh_util_core.api_post_call(
2661: p_return_status => l_return_status,

Line 2682: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling VALIDATE_TKT is', l_return_status);

2678: --
2679: -- Debug Statements
2680: --
2681: IF l_debug_on THEN
2682: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling VALIDATE_TKT is', l_return_status);
2683: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2684: END IF;
2685: --
2686: wsh_util_core.api_post_call(

Line 2683: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

2679: -- Debug Statements
2680: --
2681: IF l_debug_on THEN
2682: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling VALIDATE_TKT is', l_return_status);
2683: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2684: END IF;
2685: --
2686: wsh_util_core.api_post_call(
2687: p_return_status => l_return_status,

Line 2703: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

2699: --
2700: -- Debug Statements
2701: --
2702: IF l_debug_on THEN
2703: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2704: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling EXTRACT_CARRIER_INFO is', l_return_status);
2705: END IF;
2706: --
2707: wsh_util_core.api_post_call(

Line 2704: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling EXTRACT_CARRIER_INFO is', l_return_status);

2700: -- Debug Statements
2701: --
2702: IF l_debug_on THEN
2703: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2704: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling EXTRACT_CARRIER_INFO is', l_return_status);
2705: END IF;
2706: --
2707: wsh_util_core.api_post_call(
2708: p_return_status => l_return_status,

Line 2730: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling VALIDATE_TKT is', l_return_status);

2726: --
2727: -- Debug Statements
2728: --
2729: IF l_debug_on THEN
2730: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling VALIDATE_TKT is', l_return_status);
2731: WSH_DEBUG_SV.logmsg(l_module_name,'calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2732: END IF;
2733: --
2734: wsh_util_core.api_post_call(

Line 2731: WSH_DEBUG_SV.logmsg(l_module_name,'calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

2727: -- Debug Statements
2728: --
2729: IF l_debug_on THEN
2730: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling VALIDATE_TKT is', l_return_status);
2731: WSH_DEBUG_SV.logmsg(l_module_name,'calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2732: END IF;
2733: --
2734: wsh_util_core.api_post_call(
2735: p_return_status => l_return_status,

Line 2751: WSH_DEBUG_SV.logmsg(l_module_name,'OrgAfterCalling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

2747: --
2748: -- Debug Statements
2749: --
2750: IF l_debug_on THEN
2751: WSH_DEBUG_SV.logmsg(l_module_name,'OrgAfterCalling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2752: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling EXTRACT_ORG_INFO is', l_return_status);
2753: END IF;
2754: --
2755: wsh_util_core.api_post_call(

Line 2752: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling EXTRACT_ORG_INFO is', l_return_status);

2748: -- Debug Statements
2749: --
2750: IF l_debug_on THEN
2751: WSH_DEBUG_SV.logmsg(l_module_name,'OrgAfterCalling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2752: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling EXTRACT_ORG_INFO is', l_return_status);
2753: END IF;
2754: --
2755: wsh_util_core.api_post_call(
2756: p_return_status => l_return_status,

Line 2786: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling EXTRACT_LOCATION_INFO is', l_return_status);

2782: --
2783: -- Debug Statements
2784: --
2785: IF l_debug_on THEN
2786: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling EXTRACT_LOCATION_INFO is', l_return_status);
2787: WSH_DEBUG_SV.log(l_module_name,'Number of records finally being sent to GC3 is',x_loc_xmission_rec.LOCATIONS_TBL.count);
2788: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2789: END IF;
2790: --

Line 2787: WSH_DEBUG_SV.log(l_module_name,'Number of records finally being sent to GC3 is',x_loc_xmission_rec.LOCATIONS_TBL.count);

2783: -- Debug Statements
2784: --
2785: IF l_debug_on THEN
2786: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling EXTRACT_LOCATION_INFO is', l_return_status);
2787: WSH_DEBUG_SV.log(l_module_name,'Number of records finally being sent to GC3 is',x_loc_xmission_rec.LOCATIONS_TBL.count);
2788: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2789: END IF;
2790: --
2791: wsh_util_core.api_post_call(

Line 2788: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

2784: --
2785: IF l_debug_on THEN
2786: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling EXTRACT_LOCATION_INFO is', l_return_status);
2787: WSH_DEBUG_SV.log(l_module_name,'Number of records finally being sent to GC3 is',x_loc_xmission_rec.LOCATIONS_TBL.count);
2788: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2789: END IF;
2790: --
2791: wsh_util_core.api_post_call(
2792: p_return_status => l_return_status,

Line 2825: WSH_DEBUG_SV.pop(l_module_name);

2821: --
2822: -- Debug Statements
2823: --
2824: IF l_debug_on THEN
2825: WSH_DEBUG_SV.pop(l_module_name);
2826: END IF;
2827: --
2828: --}
2829: EXCEPTION

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

2843:
2844: x_msg_data := x_msg_data || l_summary || ' ' || l_details;
2845:
2846: IF l_debug_on THEN
2847: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2848: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2849: END IF;
2850: --
2851: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2844: x_msg_data := x_msg_data || l_summary || ' ' || l_details;
2845:
2846: IF l_debug_on THEN
2847: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2848: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2849: END IF;
2850: --
2851: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2852: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

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

2864: --
2865: -- Debug Statements
2866: --
2867: IF l_debug_on THEN
2868: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2869: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2870: END IF;
2871: --
2872: WHEN OTHERS THEN

Line 2869: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

2865: -- Debug Statements
2866: --
2867: IF l_debug_on THEN
2868: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2869: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2870: END IF;
2871: --
2872: WHEN OTHERS THEN
2873: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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

2885: --
2886: -- Debug Statements
2887: --
2888: IF l_debug_on THEN
2889: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2890: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2891: END IF;
2892: --
2893: --}

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

2886: -- Debug Statements
2887: --
2888: IF l_debug_on THEN
2889: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2890: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2891: END IF;
2892: --
2893: --}
2894: END SEND_LOCATIONS;

Line 2927: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

2923: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2924: --
2925: IF l_debug_on IS NULL
2926: THEN
2927: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2928: END IF;
2929: --
2930: --
2931: -- Debug Statements

Line 2934: WSH_DEBUG_SV.push(l_module_name);

2930: --
2931: -- Debug Statements
2932: --
2933: IF l_debug_on THEN
2934: WSH_DEBUG_SV.push(l_module_name);
2935: --
2936: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
2937: END IF;
2938: --

Line 2936: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);

2932: --
2933: IF l_debug_on THEN
2934: WSH_DEBUG_SV.push(l_module_name);
2935: --
2936: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
2937: END IF;
2938: --
2939: FOR l_stop_loc_rec in l_get_stop_loc_csr LOOP
2940: --{

Line 2949: WSH_DEBUG_SV.log(l_module_name,'location type',l_stop_loc_rec.loc_type);

2945: ELSE
2946: l_corp_type := 'CUS';
2947: END IF;
2948: IF l_debug_on THEN
2949: WSH_DEBUG_SV.log(l_module_name,'location type',l_stop_loc_rec.loc_type);
2950: WSH_DEBUG_SV.log(l_module_name,'location id',l_stop_loc_rec.location_id);
2951: WSH_DEBUG_SV.log(l_module_name,'corporation id',l_corporation_id);
2952: END IF;
2953: --}

Line 2950: WSH_DEBUG_SV.log(l_module_name,'location id',l_stop_loc_rec.location_id);

2946: l_corp_type := 'CUS';
2947: END IF;
2948: IF l_debug_on THEN
2949: WSH_DEBUG_SV.log(l_module_name,'location type',l_stop_loc_rec.loc_type);
2950: WSH_DEBUG_SV.log(l_module_name,'location id',l_stop_loc_rec.location_id);
2951: WSH_DEBUG_SV.log(l_module_name,'corporation id',l_corporation_id);
2952: END IF;
2953: --}
2954: END LOOP;

Line 2951: WSH_DEBUG_SV.log(l_module_name,'corporation id',l_corporation_id);

2947: END IF;
2948: IF l_debug_on THEN
2949: WSH_DEBUG_SV.log(l_module_name,'location type',l_stop_loc_rec.loc_type);
2950: WSH_DEBUG_SV.log(l_module_name,'location id',l_stop_loc_rec.location_id);
2951: WSH_DEBUG_SV.log(l_module_name,'corporation id',l_corporation_id);
2952: END IF;
2953: --}
2954: END LOOP;
2955:

Line 2965: WSH_DEBUG_SV.pop(l_module_name);

2961: --
2962: -- Debug Statements
2963: --
2964: IF l_debug_on THEN
2965: WSH_DEBUG_SV.pop(l_module_name);
2966: --
2967: END IF;
2968: return l_location_xid;
2969: --

Line 3005: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

3001: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
3002: --
3003: IF l_debug_on IS NULL
3004: THEN
3005: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3006: END IF;
3007: --
3008: --
3009: -- Debug Statements

Line 3012: WSH_DEBUG_SV.push(l_module_name);

3008: --
3009: -- Debug Statements
3010: --
3011: IF l_debug_on THEN
3012: WSH_DEBUG_SV.push(l_module_name);
3013: --
3014: WSH_DEBUG_SV.log(l_module_name,'p_operation',p_operation);
3015: WSH_DEBUG_SV.log(l_module_name,'p_argument',p_argument);
3016: WSH_DEBUG_SV.log(l_module_name,'p_ticket',p_ticket);

Line 3014: WSH_DEBUG_SV.log(l_module_name,'p_operation',p_operation);

3010: --
3011: IF l_debug_on THEN
3012: WSH_DEBUG_SV.push(l_module_name);
3013: --
3014: WSH_DEBUG_SV.log(l_module_name,'p_operation',p_operation);
3015: WSH_DEBUG_SV.log(l_module_name,'p_argument',p_argument);
3016: WSH_DEBUG_SV.log(l_module_name,'p_ticket',p_ticket);
3017: END IF;
3018: --

Line 3015: WSH_DEBUG_SV.log(l_module_name,'p_argument',p_argument);

3011: IF l_debug_on THEN
3012: WSH_DEBUG_SV.push(l_module_name);
3013: --
3014: WSH_DEBUG_SV.log(l_module_name,'p_operation',p_operation);
3015: WSH_DEBUG_SV.log(l_module_name,'p_argument',p_argument);
3016: WSH_DEBUG_SV.log(l_module_name,'p_ticket',p_ticket);
3017: END IF;
3018: --
3019: x_tkt_valid := 'F';

Line 3016: WSH_DEBUG_SV.log(l_module_name,'p_ticket',p_ticket);

3012: WSH_DEBUG_SV.push(l_module_name);
3013: --
3014: WSH_DEBUG_SV.log(l_module_name,'p_operation',p_operation);
3015: WSH_DEBUG_SV.log(l_module_name,'p_argument',p_argument);
3016: WSH_DEBUG_SV.log(l_module_name,'p_ticket',p_ticket);
3017: END IF;
3018: --
3019: x_tkt_valid := 'F';
3020: x_return_status := wsh_util_core.G_RET_STS_SUCCESS;

Line 3023: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FND_HTTP_TICKET.CHECK_TICKET',WSH_DEBUG_SV.C_PROC_LEVEL);

3019: x_tkt_valid := 'F';
3020: x_return_status := wsh_util_core.G_RET_STS_SUCCESS;
3021:
3022: IF l_debug_on THEN
3023: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FND_HTTP_TICKET.CHECK_TICKET',WSH_DEBUG_SV.C_PROC_LEVEL);
3024: END IF;
3025:
3026: l_is_tkt_valid := FND_HTTP_TICKET.CHECK_TICKET
3027: (

Line 3034: WSH_DEBUG_SV.log(l_module_name,'l_operation',l_operation);

3030: p_argument => l_argument
3031: );
3032:
3033: IF l_debug_on THEN
3034: WSH_DEBUG_SV.log(l_module_name,'l_operation',l_operation);
3035: WSH_DEBUG_SV.log(l_module_name,'l_argument',l_argument);
3036: END IF;
3037: IF (
3038: l_is_tkt_valid

Line 3035: WSH_DEBUG_SV.log(l_module_name,'l_argument',l_argument);

3031: );
3032:
3033: IF l_debug_on THEN
3034: WSH_DEBUG_SV.log(l_module_name,'l_operation',l_operation);
3035: WSH_DEBUG_SV.log(l_module_name,'l_argument',l_argument);
3036: END IF;
3037: IF (
3038: l_is_tkt_valid
3039: and l_operation = p_operation

Line 3044: WSH_DEBUG_SV.logmsg(l_module_name,'Tkt is valid');

3040: and l_argument = p_argument
3041: ) THEN
3042: --{
3043: IF l_debug_on THEN
3044: WSH_DEBUG_SV.logmsg(l_module_name,'Tkt is valid');
3045: END IF;
3046: x_tkt_valid := 'T';
3047: --}
3048: ELSE

Line 3051: WSH_DEBUG_SV.logmsg(l_module_name,'Tkt is invalid');

3047: --}
3048: ELSE
3049: --{
3050: IF l_debug_on THEN
3051: WSH_DEBUG_SV.logmsg(l_module_name,'Tkt is invalid');
3052: END IF;
3053: x_tkt_valid := 'F';
3054: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_INVALID_TKT');
3055: FND_MESSAGE.SET_TOKEN('TICKET',p_ticket);

Line 3064: WSH_DEBUG_SV.pop(l_module_name);

3060: --
3061: -- Debug Statements
3062: --
3063: IF l_debug_on THEN
3064: WSH_DEBUG_SV.pop(l_module_name);
3065: --
3066: END IF;
3067: --}
3068: EXCEPTION

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

3076: --
3077: -- Debug Statements
3078: --
3079: IF l_debug_on THEN
3080: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3081: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3082: END IF;
3083: --
3084: --}

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

3077: -- Debug Statements
3078: --
3079: IF l_debug_on THEN
3080: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3081: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3082: END IF;
3083: --
3084: --}
3085: END VALIDATE_TKT;

Line 3120: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

3116: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
3117: --
3118: IF l_debug_on IS NULL
3119: THEN
3120: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3121: END IF;
3122: --
3123: --
3124: -- Debug Statements

Line 3127: WSH_DEBUG_SV.push(l_module_name);

3123: --
3124: -- Debug Statements
3125: --
3126: IF l_debug_on THEN
3127: WSH_DEBUG_SV.push(l_module_name);
3128: --
3129: WSH_DEBUG_SV.log(l_module_name,'p_location_id',p_location_id);
3130: END IF;
3131: --

Line 3129: WSH_DEBUG_SV.log(l_module_name,'p_location_id',p_location_id);

3125: --
3126: IF l_debug_on THEN
3127: WSH_DEBUG_SV.push(l_module_name);
3128: --
3129: WSH_DEBUG_SV.log(l_module_name,'p_location_id',p_location_id);
3130: END IF;
3131: --
3132: x_return_status := wsh_util_core.g_ret_sts_success;
3133: --

Line 3142: WSH_DEBUG_SV.log(l_module_name,'l_return_status after calling Convert_internal_cust_location',l_return_status);

3138: --
3139: -- Debug Statements
3140: --
3141: IF l_debug_on THEN
3142: WSH_DEBUG_SV.log(l_module_name,'l_return_status after calling Convert_internal_cust_location',l_return_status);
3143: WSH_DEBUG_SV.log(l_module_name,'l_int_location_id',l_int_location_id);
3144: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
3145: END IF;
3146: --

Line 3143: WSH_DEBUG_SV.log(l_module_name,'l_int_location_id',l_int_location_id);

3139: -- Debug Statements
3140: --
3141: IF l_debug_on THEN
3142: WSH_DEBUG_SV.log(l_module_name,'l_return_status after calling Convert_internal_cust_location',l_return_status);
3143: WSH_DEBUG_SV.log(l_module_name,'l_int_location_id',l_int_location_id);
3144: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
3145: END IF;
3146: --
3147: wsh_util_core.api_post_call(

Line 3144: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

3140: --
3141: IF l_debug_on THEN
3142: WSH_DEBUG_SV.log(l_module_name,'l_return_status after calling Convert_internal_cust_location',l_return_status);
3143: WSH_DEBUG_SV.log(l_module_name,'l_int_location_id',l_int_location_id);
3144: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
3145: END IF;
3146: --
3147: wsh_util_core.api_post_call(
3148: p_return_status => l_return_status,

Line 3160: WSH_DEBUG_SV.log(l_module_name,'l_corporation_id',l_corporation_id);

3156: fetch l_loc_to_org_csr into l_corporation_id;
3157: close l_loc_to_org_csr;
3158: --
3159: IF l_debug_on THEN
3160: WSH_DEBUG_SV.log(l_module_name,'l_corporation_id',l_corporation_id);
3161: END IF;
3162: --
3163: IF (l_corporation_id is null) THEN
3164: l_location_xid := l_corp_type || '-000-' || l_int_location_id;

Line 3176: WSH_DEBUG_SV.log(l_module_name,'x_location_xid',x_location_xid);

3172: --
3173: -- Debug Statements
3174: --
3175: IF l_debug_on THEN
3176: WSH_DEBUG_SV.log(l_module_name,'x_location_xid',x_location_xid);
3177: WSH_DEBUG_SV.pop(l_module_name);
3178: --
3179: END IF;
3180: --

Line 3177: WSH_DEBUG_SV.pop(l_module_name);

3173: -- Debug Statements
3174: --
3175: IF l_debug_on THEN
3176: WSH_DEBUG_SV.log(l_module_name,'x_location_xid',x_location_xid);
3177: WSH_DEBUG_SV.pop(l_module_name);
3178: --
3179: END IF;
3180: --
3181: --}

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

3186: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3187: --
3188:
3189: IF l_debug_on THEN
3190: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3191: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3192: END IF;
3193: --
3194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

3187: --
3188:
3189: IF l_debug_on THEN
3190: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3191: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3192: END IF;
3193: --
3194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3195: --

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

3197: --
3198: -- Debug Statements
3199: --
3200: IF l_debug_on THEN
3201: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3202: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3203: END IF;
3204: --
3205: WHEN OTHERS THEN

Line 3202: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

3198: -- Debug Statements
3199: --
3200: IF l_debug_on THEN
3201: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3202: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3203: END IF;
3204: --
3205: WHEN OTHERS THEN
3206: --

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

3208: --
3209: -- Debug Statements
3210: --
3211: IF l_debug_on THEN
3212: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3213: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3214: END IF;
3215: --
3216: --}

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

3209: -- Debug Statements
3210: --
3211: IF l_debug_on THEN
3212: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3213: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3214: END IF;
3215: --
3216: --}
3217: END GET_INT_LOCATION_XID;