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

392: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
393: --
394: IF l_debug_on IS NULL
395: THEN
396: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
397: END IF;
398: --
399: --
400: -- Debug Statements

Line 403: WSH_DEBUG_SV.push(l_module_name);

399: --
400: -- Debug Statements
401: --
402: IF l_debug_on THEN
403: WSH_DEBUG_SV.push(l_module_name);
404: --
405: WSH_DEBUG_SV.log(l_module_name,'P_TRANSMISSION_ID',P_TRANSMISSION_ID);
406: END IF;
407: --

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

401: --
402: IF l_debug_on THEN
403: WSH_DEBUG_SV.push(l_module_name);
404: --
405: WSH_DEBUG_SV.log(l_module_name,'P_TRANSMISSION_ID',P_TRANSMISSION_ID);
406: END IF;
407: --
408: x_return_status := wsh_util_core.g_ret_sts_success;
409: --

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

414: --{
415: FOR i in p_entity_in_rec.entity_id_tbl.first..p_entity_in_rec.entity_id_tbl.last LOOP
416: --{
417: IF l_debug_on THEN
418: WSH_DEBUG_SV.log(l_module_name,'Delivery_Id('||i||')',p_entity_in_rec.entity_id_tbl(i));
419: END IF;
420: l_internal_loc_id := NULL;
421: l_internal_org_id := NULL;
422:

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

437: --
438: -- Debug Statements
439: --
440: IF l_debug_on THEN
441: WSH_DEBUG_SV.log(l_module_name,'l_return_status after calling Convert_internal_cust_location',l_return_status);
442: WSH_DEBUG_SV.log(l_module_name,'l_internal_loc_id',l_internal_loc_id);
443: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
444: END IF;
445: --

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

438: -- Debug Statements
439: --
440: IF l_debug_on THEN
441: WSH_DEBUG_SV.log(l_module_name,'l_return_status after calling Convert_internal_cust_location',l_return_status);
442: WSH_DEBUG_SV.log(l_module_name,'l_internal_loc_id',l_internal_loc_id);
443: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
444: END IF;
445: --
446: wsh_util_core.api_post_call(

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

439: --
440: IF l_debug_on THEN
441: WSH_DEBUG_SV.log(l_module_name,'l_return_status after calling Convert_internal_cust_location',l_return_status);
442: WSH_DEBUG_SV.log(l_module_name,'l_internal_loc_id',l_internal_loc_id);
443: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
444: END IF;
445: --
446: wsh_util_core.api_post_call(
447: p_return_status => l_return_status,

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

470: --
471: -- Debug Statements
472: --
473: IF l_debug_on THEN
474: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
475: END IF;
476: --
477: wsh_util_core.api_post_call(
478: p_return_status => l_return_status,

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

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

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

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

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

538: --
539: -- Debug Statements
540: --
541: IF l_debug_on THEN
542: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling INSERT_ROW_IN_LOC_GTMP is', l_return_status);
543: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
544: END IF;
545: --
546: wsh_util_core.api_post_call(

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

539: -- Debug Statements
540: --
541: IF l_debug_on THEN
542: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling INSERT_ROW_IN_LOC_GTMP is', l_return_status);
543: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
544: END IF;
545: --
546: wsh_util_core.api_post_call(
547: p_return_status => l_return_status,

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

568: --
569: -- Debug Statements
570: --
571: IF l_debug_on THEN
572: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling INSERT_ROW_IN_LOC_GTMP is', l_return_status);
573: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
574: END IF;
575: --
576: wsh_util_core.api_post_call(

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

569: -- Debug Statements
570: --
571: IF l_debug_on THEN
572: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling INSERT_ROW_IN_LOC_GTMP is', l_return_status);
573: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
574: END IF;
575: --
576: wsh_util_core.api_post_call(
577: p_return_status => l_return_status,

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

594: -- Customer Site.
595: for del_contact_rec in l_del_contact_csr(p_entity_in_rec.entity_id_tbl(i)) loop
596: --{
597: IF l_debug_on THEN
598: WSH_DEBUG_SV.log(l_module_name,'ContactId for delivery is', del_contact_rec.contact_id);
599: WSH_DEBUG_SV.log(l_module_name,'Prev Contact Id for delivery is', l_prev_contact_id);
600: WSH_DEBUG_SV.log(l_module_name,'location_id',l_st_loc_id);
601: WSH_DEBUG_SV.log(l_module_name,'customer_id',del_contact_rec.customer_id);
602: END IF;

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

595: for del_contact_rec in l_del_contact_csr(p_entity_in_rec.entity_id_tbl(i)) loop
596: --{
597: IF l_debug_on THEN
598: WSH_DEBUG_SV.log(l_module_name,'ContactId for delivery is', del_contact_rec.contact_id);
599: WSH_DEBUG_SV.log(l_module_name,'Prev Contact Id for delivery is', l_prev_contact_id);
600: WSH_DEBUG_SV.log(l_module_name,'location_id',l_st_loc_id);
601: WSH_DEBUG_SV.log(l_module_name,'customer_id',del_contact_rec.customer_id);
602: END IF;
603:

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

596: --{
597: IF l_debug_on THEN
598: WSH_DEBUG_SV.log(l_module_name,'ContactId for delivery is', del_contact_rec.contact_id);
599: WSH_DEBUG_SV.log(l_module_name,'Prev Contact Id for delivery is', l_prev_contact_id);
600: WSH_DEBUG_SV.log(l_module_name,'location_id',l_st_loc_id);
601: WSH_DEBUG_SV.log(l_module_name,'customer_id',del_contact_rec.customer_id);
602: END IF;
603:
604: l_contact_exists := null;

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

597: IF l_debug_on THEN
598: WSH_DEBUG_SV.log(l_module_name,'ContactId for delivery is', del_contact_rec.contact_id);
599: WSH_DEBUG_SV.log(l_module_name,'Prev Contact Id for delivery is', l_prev_contact_id);
600: WSH_DEBUG_SV.log(l_module_name,'location_id',l_st_loc_id);
601: WSH_DEBUG_SV.log(l_module_name,'customer_id',del_contact_rec.customer_id);
602: END IF;
603:
604: l_contact_exists := null;
605:

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

608: open l_check_contacts_exists_csr(del_contact_rec.contact_id, l_st_loc_id,del_contact_rec.customer_id);
609: fetch l_check_contacts_exists_csr into l_contact_exists;
610: close l_check_contacts_exists_csr;
611: IF l_debug_on THEN
612: WSH_DEBUG_SV.log(l_module_name,'contact exists',l_contact_exists);
613: END IF;
614: IF (l_contact_exists IS NULL) THEN
615: --{
616: insert into WSH_OTM_LOC_CONTACTS_GTMP

Line 647: WSH_DEBUG_SV.pop(l_module_name);

643: --
644: -- Debug Statements
645: --
646: IF l_debug_on THEN
647: WSH_DEBUG_SV.pop(l_module_name);
648: END IF;
649: --
650: END EXTRACT_DLVY_INFO;
651:

Line 722: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

718: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
719: --
720: IF l_debug_on IS NULL
721: THEN
722: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
723: END IF;
724: --
725: --
726: -- Debug Statements

Line 729: WSH_DEBUG_SV.push(l_module_name);

725: --
726: -- Debug Statements
727: --
728: IF l_debug_on THEN
729: WSH_DEBUG_SV.push(l_module_name);
730: --
731: WSH_DEBUG_SV.log(l_module_name,'P_TRANSMISSION_ID',P_TRANSMISSION_ID);
732: END IF;
733: --

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

727: --
728: IF l_debug_on THEN
729: WSH_DEBUG_SV.push(l_module_name);
730: --
731: WSH_DEBUG_SV.log(l_module_name,'P_TRANSMISSION_ID',P_TRANSMISSION_ID);
732: END IF;
733: --
734: x_return_status := wsh_util_core.g_ret_sts_success;
735: --

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

767: --
768: -- Debug Statements
769: --
770: IF l_debug_on THEN
771: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
772: END IF;
773: --
774: wsh_util_core.api_post_call(
775: p_return_status => l_return_status,

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

811: --
812: -- Debug Statements
813: --
814: IF l_debug_on THEN
815: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
816: END IF;
817: --
818: wsh_util_core.api_post_call(
819: p_return_status => l_return_status,

Line 845: WSH_DEBUG_SV.pop(l_module_name);

841: --
842: -- Debug Statements
843: --
844: IF l_debug_on THEN
845: WSH_DEBUG_SV.pop(l_module_name);
846: END IF;
847: --
848: EXCEPTION
849: --{

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

852: --
853: -- Debug Statements
854: --
855: IF l_debug_on THEN
856: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
857: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
858: END IF;
859: --
860: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

853: -- Debug Statements
854: --
855: IF l_debug_on THEN
856: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
857: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
858: END IF;
859: --
860: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
861: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

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

862: --
863: -- Debug Statements
864: --
865: IF l_debug_on THEN
866: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
867: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
868: END IF;
869: --
870: WHEN OTHERS THEN

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

863: -- Debug Statements
864: --
865: IF l_debug_on THEN
866: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
867: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
868: END IF;
869: --
870: WHEN OTHERS THEN
871: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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

873: --
874: -- Debug Statements
875: --
876: IF l_debug_on THEN
877: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
878: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
879: END IF;
880: --
881: END EXTRACT_TRIP_INFO;

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

874: -- Debug Statements
875: --
876: IF l_debug_on THEN
877: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
878: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
879: END IF;
880: --
881: END EXTRACT_TRIP_INFO;
882:

Line 919: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

915: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
916: --
917: IF l_debug_on IS NULL
918: THEN
919: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
920: END IF;
921: --
922: --
923: -- Debug Statements

Line 926: WSH_DEBUG_SV.push(l_module_name);

922: --
923: -- Debug Statements
924: --
925: IF l_debug_on THEN
926: WSH_DEBUG_SV.push(l_module_name);
927: --
928: WSH_DEBUG_SV.log(l_module_name,'P_TRANSMISSION_ID',P_TRANSMISSION_ID);
929: END IF;
930: --

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

924: --
925: IF l_debug_on THEN
926: WSH_DEBUG_SV.push(l_module_name);
927: --
928: WSH_DEBUG_SV.log(l_module_name,'P_TRANSMISSION_ID',P_TRANSMISSION_ID);
929: END IF;
930: --
931: x_return_status := wsh_util_core.g_ret_sts_success;
932: --

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

966: close l_get_loc_id_csr;
967: --
968: IF l_debug_on THEN
969: --
970: WSH_DEBUG_SV.log(l_module_name,'party_site_id ('||i||')',p_entity_in_rec.entity_id_tbl(i));
971: WSH_DEBUG_SV.log(l_module_name,'party_id ('||i||')',p_entity_in_rec.parent_entity_id_tbl(i));
972: WSH_DEBUG_SV.log(l_module_name,'l_location_id',l_location_id);
973: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOCATION',WSH_DEBUG_SV.C_PROC_LEVEL);
974: --

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

967: --
968: IF l_debug_on THEN
969: --
970: WSH_DEBUG_SV.log(l_module_name,'party_site_id ('||i||')',p_entity_in_rec.entity_id_tbl(i));
971: WSH_DEBUG_SV.log(l_module_name,'party_id ('||i||')',p_entity_in_rec.parent_entity_id_tbl(i));
972: WSH_DEBUG_SV.log(l_module_name,'l_location_id',l_location_id);
973: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOCATION',WSH_DEBUG_SV.C_PROC_LEVEL);
974: --
975: END IF;

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

968: IF l_debug_on THEN
969: --
970: WSH_DEBUG_SV.log(l_module_name,'party_site_id ('||i||')',p_entity_in_rec.entity_id_tbl(i));
971: WSH_DEBUG_SV.log(l_module_name,'party_id ('||i||')',p_entity_in_rec.parent_entity_id_tbl(i));
972: WSH_DEBUG_SV.log(l_module_name,'l_location_id',l_location_id);
973: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOCATION',WSH_DEBUG_SV.C_PROC_LEVEL);
974: --
975: END IF;
976: --

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

969: --
970: WSH_DEBUG_SV.log(l_module_name,'party_site_id ('||i||')',p_entity_in_rec.entity_id_tbl(i));
971: WSH_DEBUG_SV.log(l_module_name,'party_id ('||i||')',p_entity_in_rec.parent_entity_id_tbl(i));
972: WSH_DEBUG_SV.log(l_module_name,'l_location_id',l_location_id);
973: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOCATION',WSH_DEBUG_SV.C_PROC_LEVEL);
974: --
975: END IF;
976: --
977: wsh_util_validate.validate_location

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

984: --
985: -- Debug Statements
986: --
987: IF l_debug_on THEN
988: WSH_DEBUG_SV.log(l_module_name,'l_return_status', l_return_status);
989: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
990: END IF;
991: --
992: wsh_util_core.api_post_call(

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

985: -- Debug Statements
986: --
987: IF l_debug_on THEN
988: WSH_DEBUG_SV.log(l_module_name,'l_return_status', l_return_status);
989: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
990: END IF;
991: --
992: wsh_util_core.api_post_call(
993: p_return_status => l_return_status,

Line 1008: WSH_DEBUG_SV.pop(l_module_name);

1004: --
1005: -- Debug Statements
1006: --
1007: IF l_debug_on THEN
1008: WSH_DEBUG_SV.pop(l_module_name);
1009: END IF;
1010: --
1011: EXCEPTION
1012: --{

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

1015: --
1016: -- Debug Statements
1017: --
1018: IF l_debug_on THEN
1019: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1020: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1021: END IF;
1022: --
1023: --}

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

1016: -- Debug Statements
1017: --
1018: IF l_debug_on THEN
1019: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1020: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1021: END IF;
1022: --
1023: --}
1024: END EXTRACT_CARRIER_INFO;

Line 1064: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1060: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1061: --
1062: IF l_debug_on IS NULL
1063: THEN
1064: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1065: END IF;
1066: --
1067: --
1068: -- Debug Statements

Line 1071: WSH_DEBUG_SV.push(l_module_name);

1067: --
1068: -- Debug Statements
1069: --
1070: IF l_debug_on THEN
1071: WSH_DEBUG_SV.push(l_module_name);
1072: --
1073: WSH_DEBUG_SV.log(l_module_name,'P_TRANSMISSION_ID',P_TRANSMISSION_ID);
1074: END IF;
1075: --

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

1069: --
1070: IF l_debug_on THEN
1071: WSH_DEBUG_SV.push(l_module_name);
1072: --
1073: WSH_DEBUG_SV.log(l_module_name,'P_TRANSMISSION_ID',P_TRANSMISSION_ID);
1074: END IF;
1075: --
1076: x_return_status := wsh_util_core.g_ret_sts_success;
1077: --

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

1106: --
1107: -- Debug Statements
1108: --
1109: IF l_debug_on THEN
1110: WSH_DEBUG_SV.log(l_module_name,'return status from insert into locGtmp ', l_return_status);
1111: WSH_DEBUG_SV.log(l_module_name,'org_id ('||i||')',p_entity_in_rec.entity_id_tbl(i));
1112: WSH_DEBUG_SV.log(l_module_name,'from_location_id', l_location_id);
1113: WSH_DEBUG_SV.log(l_module_name,'gtmp_location_id', l_gtmp_location_id);
1114: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

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

1107: -- Debug Statements
1108: --
1109: IF l_debug_on THEN
1110: WSH_DEBUG_SV.log(l_module_name,'return status from insert into locGtmp ', l_return_status);
1111: WSH_DEBUG_SV.log(l_module_name,'org_id ('||i||')',p_entity_in_rec.entity_id_tbl(i));
1112: WSH_DEBUG_SV.log(l_module_name,'from_location_id', l_location_id);
1113: WSH_DEBUG_SV.log(l_module_name,'gtmp_location_id', l_gtmp_location_id);
1114: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1115: --

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

1108: --
1109: IF l_debug_on THEN
1110: WSH_DEBUG_SV.log(l_module_name,'return status from insert into locGtmp ', l_return_status);
1111: WSH_DEBUG_SV.log(l_module_name,'org_id ('||i||')',p_entity_in_rec.entity_id_tbl(i));
1112: WSH_DEBUG_SV.log(l_module_name,'from_location_id', l_location_id);
1113: WSH_DEBUG_SV.log(l_module_name,'gtmp_location_id', l_gtmp_location_id);
1114: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1115: --
1116: END IF;

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

1109: IF l_debug_on THEN
1110: WSH_DEBUG_SV.log(l_module_name,'return status from insert into locGtmp ', l_return_status);
1111: WSH_DEBUG_SV.log(l_module_name,'org_id ('||i||')',p_entity_in_rec.entity_id_tbl(i));
1112: WSH_DEBUG_SV.log(l_module_name,'from_location_id', l_location_id);
1113: WSH_DEBUG_SV.log(l_module_name,'gtmp_location_id', l_gtmp_location_id);
1114: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1115: --
1116: END IF;
1117: --

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

1110: WSH_DEBUG_SV.log(l_module_name,'return status from insert into locGtmp ', l_return_status);
1111: WSH_DEBUG_SV.log(l_module_name,'org_id ('||i||')',p_entity_in_rec.entity_id_tbl(i));
1112: WSH_DEBUG_SV.log(l_module_name,'from_location_id', l_location_id);
1113: WSH_DEBUG_SV.log(l_module_name,'gtmp_location_id', l_gtmp_location_id);
1114: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1115: --
1116: END IF;
1117: --
1118: --

Line 1134: WSH_DEBUG_SV.pop(l_module_name);

1130: --
1131: -- Debug Statements
1132: --
1133: IF l_debug_on THEN
1134: WSH_DEBUG_SV.pop(l_module_name);
1135: END IF;
1136: --
1137: EXCEPTION
1138: --{

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

1145: --
1146: -- Debug Statements
1147: --
1148: IF l_debug_on THEN
1149: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1150: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1151: END IF;
1152: --
1153: --}

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

1146: -- Debug Statements
1147: --
1148: IF l_debug_on THEN
1149: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1150: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1151: END IF;
1152: --
1153: --}
1154: END EXTRACT_ORG_INFO;

Line 1188: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1184: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1185: --
1186: IF l_debug_on IS NULL
1187: THEN
1188: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1189: END IF;
1190: --
1191: --
1192: -- Debug Statements

Line 1195: WSH_DEBUG_SV.push(l_module_name);

1191: --
1192: -- Debug Statements
1193: --
1194: IF l_debug_on THEN
1195: WSH_DEBUG_SV.push(l_module_name);
1196: --
1197: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_ID',P_LOCATION_ID);
1198: WSH_DEBUG_SV.log(l_module_name,'P_STATE',P_STATE);
1199: END IF;

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

1193: --
1194: IF l_debug_on THEN
1195: WSH_DEBUG_SV.push(l_module_name);
1196: --
1197: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_ID',P_LOCATION_ID);
1198: WSH_DEBUG_SV.log(l_module_name,'P_STATE',P_STATE);
1199: END IF;
1200: --
1201: open l_get_state_code_csr(p_location_id);

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

1194: IF l_debug_on THEN
1195: WSH_DEBUG_SV.push(l_module_name);
1196: --
1197: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_ID',P_LOCATION_ID);
1198: WSH_DEBUG_SV.log(l_module_name,'P_STATE',P_STATE);
1199: END IF;
1200: --
1201: open l_get_state_code_csr(p_location_id);
1202: fetch l_get_state_code_csr into l_state_code;

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

1208: --
1209: -- Debug Statements
1210: --
1211: IF l_debug_on THEN
1212: WSH_DEBUG_SV.log(l_module_name,'l_state_code',l_state_code);
1213: WSH_DEBUG_SV.pop(l_module_name);
1214: END IF;
1215: --
1216: return l_state_code;

Line 1213: WSH_DEBUG_SV.pop(l_module_name);

1209: -- Debug Statements
1210: --
1211: IF l_debug_on THEN
1212: WSH_DEBUG_SV.log(l_module_name,'l_state_code',l_state_code);
1213: WSH_DEBUG_SV.pop(l_module_name);
1214: END IF;
1215: --
1216: return l_state_code;
1217: --}

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

1221: --
1222: -- Debug Statements
1223: --
1224: IF l_debug_on THEN
1225: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1226: WSH_DEBUG_SV.pop(l_module_name);
1227: END IF;
1228: return NULL;
1229: --

Line 1226: WSH_DEBUG_SV.pop(l_module_name);

1222: -- Debug Statements
1223: --
1224: IF l_debug_on THEN
1225: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1226: WSH_DEBUG_SV.pop(l_module_name);
1227: END IF;
1228: return NULL;
1229: --
1230: --}

Line 1251: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1247: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1248: --
1249: IF l_debug_on IS NULL
1250: THEN
1251: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1252: END IF;
1253: --
1254: --
1255: -- Debug Statements

Line 1258: WSH_DEBUG_SV.push(l_module_name);

1254: --
1255: -- Debug Statements
1256: --
1257: IF l_debug_on THEN
1258: WSH_DEBUG_SV.push(l_module_name);
1259: --
1260: WSH_DEBUG_SV.log(l_module_name,'P_TBL_EXTEND_INDEX',P_TBL_EXTEND_INDEX);
1261: END IF;
1262: --

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

1256: --
1257: IF l_debug_on THEN
1258: WSH_DEBUG_SV.push(l_module_name);
1259: --
1260: WSH_DEBUG_SV.log(l_module_name,'P_TBL_EXTEND_INDEX',P_TBL_EXTEND_INDEX);
1261: END IF;
1262: --
1263: x_locations_tbl.extend;
1264: x_locations_tbl(p_tbl_extend_index) := WSH_OTM_LOCATIONS_REC_TYPE

Line 1293: WSH_DEBUG_SV.pop(l_module_name);

1289: --
1290: -- Debug Statements
1291: --
1292: IF l_debug_on THEN
1293: WSH_DEBUG_SV.pop(l_module_name);
1294: END IF;
1295: --
1296: END EXTEND_LOCATIONS_TBL;
1297:

Line 1321: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1317: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1318: --
1319: IF l_debug_on IS NULL
1320: THEN
1321: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1322: END IF;
1323: --
1324: --
1325: -- Debug Statements

Line 1328: WSH_DEBUG_SV.push(l_module_name);

1324: --
1325: -- Debug Statements
1326: --
1327: IF l_debug_on THEN
1328: WSH_DEBUG_SV.push(l_module_name);
1329: --
1330: WSH_DEBUG_SV.log(l_module_name,'p_qualifier',p_qualifier);
1331: WSH_DEBUG_SV.log(l_module_name,'p_domain_name',p_domain_name);
1332: WSH_DEBUG_SV.log(l_module_name,'p_value',p_value);

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

1326: --
1327: IF l_debug_on THEN
1328: WSH_DEBUG_SV.push(l_module_name);
1329: --
1330: WSH_DEBUG_SV.log(l_module_name,'p_qualifier',p_qualifier);
1331: WSH_DEBUG_SV.log(l_module_name,'p_domain_name',p_domain_name);
1332: WSH_DEBUG_SV.log(l_module_name,'p_value',p_value);
1333: END IF;
1334: --

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

1327: IF l_debug_on THEN
1328: WSH_DEBUG_SV.push(l_module_name);
1329: --
1330: WSH_DEBUG_SV.log(l_module_name,'p_qualifier',p_qualifier);
1331: WSH_DEBUG_SV.log(l_module_name,'p_domain_name',p_domain_name);
1332: WSH_DEBUG_SV.log(l_module_name,'p_value',p_value);
1333: END IF;
1334: --
1335: l_count := x_ref_num_tbl.count + 1;

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

1328: WSH_DEBUG_SV.push(l_module_name);
1329: --
1330: WSH_DEBUG_SV.log(l_module_name,'p_qualifier',p_qualifier);
1331: WSH_DEBUG_SV.log(l_module_name,'p_domain_name',p_domain_name);
1332: WSH_DEBUG_SV.log(l_module_name,'p_value',p_value);
1333: END IF;
1334: --
1335: l_count := x_ref_num_tbl.count + 1;
1336: --

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

1336: --
1337: --
1338: IF l_debug_on THEN
1339: --
1340: WSH_DEBUG_SV.log(l_module_name,'l_count',l_count);
1341: --
1342: END IF;
1343: --
1344: IF (p_value IS NOT NULL AND p_domain_name IS NOT NULL AND p_qualifier IS NOT NULL) THEN

Line 1356: WSH_DEBUG_SV.pop(l_module_name);

1352: --
1353: -- Debug Statements
1354: --
1355: IF l_debug_on THEN
1356: WSH_DEBUG_SV.pop(l_module_name);
1357: END IF;
1358: --
1359: END EXTND_ASSIGN_LOC_REF_NUM_TBL;
1360:

Line 1621: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1617: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1618: --
1619: IF l_debug_on IS NULL
1620: THEN
1621: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1622: END IF;
1623: --
1624: --
1625: -- Debug Statements

Line 1628: WSH_DEBUG_SV.push(l_module_name);

1624: --
1625: -- Debug Statements
1626: --
1627: IF l_debug_on THEN
1628: WSH_DEBUG_SV.push(l_module_name);
1629: --
1630: WSH_DEBUG_SV.log(l_module_name,'P_TRANSMISSION_ID',P_TRANSMISSION_ID);
1631: END IF;
1632: --

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

1626: --
1627: IF l_debug_on THEN
1628: WSH_DEBUG_SV.push(l_module_name);
1629: --
1630: WSH_DEBUG_SV.log(l_module_name,'P_TRANSMISSION_ID',P_TRANSMISSION_ID);
1631: END IF;
1632: --
1633: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1634:

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

1647: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_DOMAIN_NOT_SET_ERR');
1648: x_return_status := wsh_util_core.G_RET_STS_UNEXP_ERROR;
1649: wsh_util_core.add_message(x_return_status, l_module_name);
1650: IF l_debug_on THEN
1651: WSH_DEBUG_SV.logmsg(l_module_name,'Error: The profile WSH_OTM_DOMAIN_NAME is set to NULL. Please correct the profile value');
1652: END IF;
1653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1654: --}
1655: END IF;

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

1659: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_CNTR_CODE_NOT_SET_ERR');
1660: x_return_status := wsh_util_core.G_RET_STS_UNEXP_ERROR;
1661: wsh_util_core.add_message(x_return_status, l_module_name);
1662: IF l_debug_on THEN
1663: WSH_DEBUG_SV.logmsg(l_module_name,'Error: The profile WSH_OTM_CORP_COUNTRY_CODE is set to NULL. Please correct the profile value');
1664: END IF;
1665: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1666: --}
1667: END IF;

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

1674: -- Debug Statements
1675: --
1676: IF l_debug_on THEN
1677: --
1678: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.LOCATION_XID',org_loc_rec.LOCATION_XID);
1679: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.LOCATION_NAME',org_loc_rec.LOCATION_NAME);
1680: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ADDRESS_LINE_1',org_loc_rec.ADDRESS_LINE_1);
1681: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ADDRESS_LINE_2',org_loc_rec.ADDRESS_LINE_2);
1682: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ADDRESS_LINE_3',org_loc_rec.ADDRESS_LINE_3);

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

1675: --
1676: IF l_debug_on THEN
1677: --
1678: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.LOCATION_XID',org_loc_rec.LOCATION_XID);
1679: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.LOCATION_NAME',org_loc_rec.LOCATION_NAME);
1680: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ADDRESS_LINE_1',org_loc_rec.ADDRESS_LINE_1);
1681: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ADDRESS_LINE_2',org_loc_rec.ADDRESS_LINE_2);
1682: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ADDRESS_LINE_3',org_loc_rec.ADDRESS_LINE_3);
1683: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.TOWN_OR_CITY',org_loc_rec.TOWN_OR_CITY);

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

1676: IF l_debug_on THEN
1677: --
1678: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.LOCATION_XID',org_loc_rec.LOCATION_XID);
1679: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.LOCATION_NAME',org_loc_rec.LOCATION_NAME);
1680: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ADDRESS_LINE_1',org_loc_rec.ADDRESS_LINE_1);
1681: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ADDRESS_LINE_2',org_loc_rec.ADDRESS_LINE_2);
1682: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ADDRESS_LINE_3',org_loc_rec.ADDRESS_LINE_3);
1683: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.TOWN_OR_CITY',org_loc_rec.TOWN_OR_CITY);
1684: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PROVINCE',org_loc_rec.PROVINCE);

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

1677: --
1678: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.LOCATION_XID',org_loc_rec.LOCATION_XID);
1679: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.LOCATION_NAME',org_loc_rec.LOCATION_NAME);
1680: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ADDRESS_LINE_1',org_loc_rec.ADDRESS_LINE_1);
1681: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ADDRESS_LINE_2',org_loc_rec.ADDRESS_LINE_2);
1682: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ADDRESS_LINE_3',org_loc_rec.ADDRESS_LINE_3);
1683: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.TOWN_OR_CITY',org_loc_rec.TOWN_OR_CITY);
1684: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PROVINCE',org_loc_rec.PROVINCE);
1685: --WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PROVINCE_CODE',org_loc_rec.PROVINCE_CODE);

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

1678: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.LOCATION_XID',org_loc_rec.LOCATION_XID);
1679: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.LOCATION_NAME',org_loc_rec.LOCATION_NAME);
1680: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ADDRESS_LINE_1',org_loc_rec.ADDRESS_LINE_1);
1681: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ADDRESS_LINE_2',org_loc_rec.ADDRESS_LINE_2);
1682: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ADDRESS_LINE_3',org_loc_rec.ADDRESS_LINE_3);
1683: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.TOWN_OR_CITY',org_loc_rec.TOWN_OR_CITY);
1684: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PROVINCE',org_loc_rec.PROVINCE);
1685: --WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PROVINCE_CODE',org_loc_rec.PROVINCE_CODE);
1686: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.POSTAL_CODE',org_loc_rec.POSTAL_CODE);

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

1679: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.LOCATION_NAME',org_loc_rec.LOCATION_NAME);
1680: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ADDRESS_LINE_1',org_loc_rec.ADDRESS_LINE_1);
1681: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ADDRESS_LINE_2',org_loc_rec.ADDRESS_LINE_2);
1682: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ADDRESS_LINE_3',org_loc_rec.ADDRESS_LINE_3);
1683: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.TOWN_OR_CITY',org_loc_rec.TOWN_OR_CITY);
1684: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PROVINCE',org_loc_rec.PROVINCE);
1685: --WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PROVINCE_CODE',org_loc_rec.PROVINCE_CODE);
1686: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.POSTAL_CODE',org_loc_rec.POSTAL_CODE);
1687: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.COUNTRY',org_loc_rec.COUNTRY);

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

1680: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ADDRESS_LINE_1',org_loc_rec.ADDRESS_LINE_1);
1681: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ADDRESS_LINE_2',org_loc_rec.ADDRESS_LINE_2);
1682: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ADDRESS_LINE_3',org_loc_rec.ADDRESS_LINE_3);
1683: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.TOWN_OR_CITY',org_loc_rec.TOWN_OR_CITY);
1684: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PROVINCE',org_loc_rec.PROVINCE);
1685: --WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PROVINCE_CODE',org_loc_rec.PROVINCE_CODE);
1686: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.POSTAL_CODE',org_loc_rec.POSTAL_CODE);
1687: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.COUNTRY',org_loc_rec.COUNTRY);
1688: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PHONE1',org_loc_rec.PHONE1);

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

1681: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ADDRESS_LINE_2',org_loc_rec.ADDRESS_LINE_2);
1682: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ADDRESS_LINE_3',org_loc_rec.ADDRESS_LINE_3);
1683: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.TOWN_OR_CITY',org_loc_rec.TOWN_OR_CITY);
1684: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PROVINCE',org_loc_rec.PROVINCE);
1685: --WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PROVINCE_CODE',org_loc_rec.PROVINCE_CODE);
1686: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.POSTAL_CODE',org_loc_rec.POSTAL_CODE);
1687: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.COUNTRY',org_loc_rec.COUNTRY);
1688: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PHONE1',org_loc_rec.PHONE1);
1689: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PHONE2',org_loc_rec.PHONE2);

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

1682: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ADDRESS_LINE_3',org_loc_rec.ADDRESS_LINE_3);
1683: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.TOWN_OR_CITY',org_loc_rec.TOWN_OR_CITY);
1684: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PROVINCE',org_loc_rec.PROVINCE);
1685: --WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PROVINCE_CODE',org_loc_rec.PROVINCE_CODE);
1686: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.POSTAL_CODE',org_loc_rec.POSTAL_CODE);
1687: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.COUNTRY',org_loc_rec.COUNTRY);
1688: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PHONE1',org_loc_rec.PHONE1);
1689: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PHONE2',org_loc_rec.PHONE2);
1690: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.FAX',org_loc_rec.FAX);

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

1683: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.TOWN_OR_CITY',org_loc_rec.TOWN_OR_CITY);
1684: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PROVINCE',org_loc_rec.PROVINCE);
1685: --WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PROVINCE_CODE',org_loc_rec.PROVINCE_CODE);
1686: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.POSTAL_CODE',org_loc_rec.POSTAL_CODE);
1687: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.COUNTRY',org_loc_rec.COUNTRY);
1688: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PHONE1',org_loc_rec.PHONE1);
1689: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PHONE2',org_loc_rec.PHONE2);
1690: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.FAX',org_loc_rec.FAX);
1691: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.NAME',org_loc_rec.NAME);

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

1684: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PROVINCE',org_loc_rec.PROVINCE);
1685: --WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PROVINCE_CODE',org_loc_rec.PROVINCE_CODE);
1686: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.POSTAL_CODE',org_loc_rec.POSTAL_CODE);
1687: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.COUNTRY',org_loc_rec.COUNTRY);
1688: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PHONE1',org_loc_rec.PHONE1);
1689: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PHONE2',org_loc_rec.PHONE2);
1690: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.FAX',org_loc_rec.FAX);
1691: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.NAME',org_loc_rec.NAME);
1692: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ORGANIZATION_CODE',org_loc_rec.ORGANIZATION_CODE);

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

1685: --WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PROVINCE_CODE',org_loc_rec.PROVINCE_CODE);
1686: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.POSTAL_CODE',org_loc_rec.POSTAL_CODE);
1687: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.COUNTRY',org_loc_rec.COUNTRY);
1688: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PHONE1',org_loc_rec.PHONE1);
1689: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PHONE2',org_loc_rec.PHONE2);
1690: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.FAX',org_loc_rec.FAX);
1691: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.NAME',org_loc_rec.NAME);
1692: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ORGANIZATION_CODE',org_loc_rec.ORGANIZATION_CODE);
1693: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.WSH_LOCATION_ID',org_loc_rec.WSH_LOCATION_ID);

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

1686: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.POSTAL_CODE',org_loc_rec.POSTAL_CODE);
1687: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.COUNTRY',org_loc_rec.COUNTRY);
1688: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PHONE1',org_loc_rec.PHONE1);
1689: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PHONE2',org_loc_rec.PHONE2);
1690: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.FAX',org_loc_rec.FAX);
1691: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.NAME',org_loc_rec.NAME);
1692: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ORGANIZATION_CODE',org_loc_rec.ORGANIZATION_CODE);
1693: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.WSH_LOCATION_ID',org_loc_rec.WSH_LOCATION_ID);
1694: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.LOCATION_ID',org_loc_rec.LOCATION_ID);

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

1687: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.COUNTRY',org_loc_rec.COUNTRY);
1688: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PHONE1',org_loc_rec.PHONE1);
1689: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PHONE2',org_loc_rec.PHONE2);
1690: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.FAX',org_loc_rec.FAX);
1691: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.NAME',org_loc_rec.NAME);
1692: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ORGANIZATION_CODE',org_loc_rec.ORGANIZATION_CODE);
1693: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.WSH_LOCATION_ID',org_loc_rec.WSH_LOCATION_ID);
1694: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.LOCATION_ID',org_loc_rec.LOCATION_ID);
1695: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ORGANIZATION_ID',org_loc_rec.ORGANIZATION_ID);

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

1688: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PHONE1',org_loc_rec.PHONE1);
1689: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PHONE2',org_loc_rec.PHONE2);
1690: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.FAX',org_loc_rec.FAX);
1691: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.NAME',org_loc_rec.NAME);
1692: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ORGANIZATION_CODE',org_loc_rec.ORGANIZATION_CODE);
1693: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.WSH_LOCATION_ID',org_loc_rec.WSH_LOCATION_ID);
1694: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.LOCATION_ID',org_loc_rec.LOCATION_ID);
1695: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ORGANIZATION_ID',org_loc_rec.ORGANIZATION_ID);
1696: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.LAST_UPDATE_DATE',org_loc_rec.LAST_UPDATE_DATE);

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

1689: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.PHONE2',org_loc_rec.PHONE2);
1690: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.FAX',org_loc_rec.FAX);
1691: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.NAME',org_loc_rec.NAME);
1692: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ORGANIZATION_CODE',org_loc_rec.ORGANIZATION_CODE);
1693: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.WSH_LOCATION_ID',org_loc_rec.WSH_LOCATION_ID);
1694: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.LOCATION_ID',org_loc_rec.LOCATION_ID);
1695: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ORGANIZATION_ID',org_loc_rec.ORGANIZATION_ID);
1696: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.LAST_UPDATE_DATE',org_loc_rec.LAST_UPDATE_DATE);
1697: --

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

1690: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.FAX',org_loc_rec.FAX);
1691: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.NAME',org_loc_rec.NAME);
1692: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ORGANIZATION_CODE',org_loc_rec.ORGANIZATION_CODE);
1693: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.WSH_LOCATION_ID',org_loc_rec.WSH_LOCATION_ID);
1694: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.LOCATION_ID',org_loc_rec.LOCATION_ID);
1695: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ORGANIZATION_ID',org_loc_rec.ORGANIZATION_ID);
1696: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.LAST_UPDATE_DATE',org_loc_rec.LAST_UPDATE_DATE);
1697: --
1698: 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 1695: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ORGANIZATION_ID',org_loc_rec.ORGANIZATION_ID);

1691: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.NAME',org_loc_rec.NAME);
1692: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ORGANIZATION_CODE',org_loc_rec.ORGANIZATION_CODE);
1693: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.WSH_LOCATION_ID',org_loc_rec.WSH_LOCATION_ID);
1694: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.LOCATION_ID',org_loc_rec.LOCATION_ID);
1695: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ORGANIZATION_ID',org_loc_rec.ORGANIZATION_ID);
1696: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.LAST_UPDATE_DATE',org_loc_rec.LAST_UPDATE_DATE);
1697: --
1698: 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);
1699: --

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

1692: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ORGANIZATION_CODE',org_loc_rec.ORGANIZATION_CODE);
1693: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.WSH_LOCATION_ID',org_loc_rec.WSH_LOCATION_ID);
1694: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.LOCATION_ID',org_loc_rec.LOCATION_ID);
1695: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ORGANIZATION_ID',org_loc_rec.ORGANIZATION_ID);
1696: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.LAST_UPDATE_DATE',org_loc_rec.LAST_UPDATE_DATE);
1697: --
1698: 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);
1699: --
1700: END IF;

Line 1698: 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);

1694: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.LOCATION_ID',org_loc_rec.LOCATION_ID);
1695: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.ORGANIZATION_ID',org_loc_rec.ORGANIZATION_ID);
1696: WSH_DEBUG_SV.log(l_module_name,'org_loc_rec.LAST_UPDATE_DATE',org_loc_rec.LAST_UPDATE_DATE);
1697: --
1698: 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);
1699: --
1700: END IF;
1701: --
1702: WSH_OTM_SYNC_REF_DATA_PKG.IS_REF_DATA_SEND_REQD

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

1714: --
1715: -- Debug Statements
1716: --
1717: IF l_debug_on THEN
1718: WSH_DEBUG_SV.log(l_module_name,'l_send_allowed', l_send_allowed);
1719: WSH_DEBUG_SV.log(l_module_name,'Calling Entity Type from Send_LOcations', p_entity_type);
1720: WSH_DEBUG_SV.log(l_module_name,'l_return_status', l_return_status);
1721: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1722: END IF;

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

1715: -- Debug Statements
1716: --
1717: IF l_debug_on THEN
1718: WSH_DEBUG_SV.log(l_module_name,'l_send_allowed', l_send_allowed);
1719: WSH_DEBUG_SV.log(l_module_name,'Calling Entity Type from Send_LOcations', p_entity_type);
1720: WSH_DEBUG_SV.log(l_module_name,'l_return_status', l_return_status);
1721: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1722: END IF;
1723: --

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

1716: --
1717: IF l_debug_on THEN
1718: WSH_DEBUG_SV.log(l_module_name,'l_send_allowed', l_send_allowed);
1719: WSH_DEBUG_SV.log(l_module_name,'Calling Entity Type from Send_LOcations', p_entity_type);
1720: WSH_DEBUG_SV.log(l_module_name,'l_return_status', l_return_status);
1721: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1722: END IF;
1723: --
1724: wsh_util_core.api_post_call(

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

1717: IF l_debug_on THEN
1718: WSH_DEBUG_SV.log(l_module_name,'l_send_allowed', l_send_allowed);
1719: WSH_DEBUG_SV.log(l_module_name,'Calling Entity Type from Send_LOcations', p_entity_type);
1720: WSH_DEBUG_SV.log(l_module_name,'l_return_status', l_return_status);
1721: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1722: END IF;
1723: --
1724: wsh_util_core.api_post_call(
1725: p_return_status => l_return_status,

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

1806:
1807: l_address_line := org_loc_rec.ADDRESS_LINE_1 || ' ' || org_loc_rec.ADDRESS_LINE_2 || ' ' || org_loc_rec.ADDRESS_LINE_3;
1808:
1809: IF l_debug_on THEN
1810: WSH_DEBUG_SV.log(l_module_name,'l_address_line', l_address_line);
1811: END IF;
1812:
1813: j := lengthb(l_address_line);
1814: k := 1;

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

1854: END LOOP;
1855:
1856: i := x_loc_xmission_rec.LOCATIONS_TBL.count+1;
1857: IF l_debug_on THEN
1858: WSH_DEBUG_SV.log(l_module_name,'i is ', i);
1859: END IF;
1860: -- Extracting the Cust Location Information
1861: FOR cust_loc_rec in l_cust_loc_csr LOOP
1862: --{

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

1879: --}
1880: END IF;
1881:
1882: IF l_debug_on THEN
1883: WSH_DEBUG_SV.log(l_module_name,'location_id', cust_loc_rec.wsh_location_id);
1884: WSH_DEBUG_SV.log(l_module_name,'customer_id', cust_loc_rec.CUST_ACCOUNT_ID);
1885: END IF;
1886: open l_ship_to_contact_csr(cust_loc_rec.wsh_location_id, cust_loc_rec.CUST_ACCOUNT_ID);
1887: fetch l_ship_to_contact_csr bulk collect into

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

1880: END IF;
1881:
1882: IF l_debug_on THEN
1883: WSH_DEBUG_SV.log(l_module_name,'location_id', cust_loc_rec.wsh_location_id);
1884: WSH_DEBUG_SV.log(l_module_name,'customer_id', cust_loc_rec.CUST_ACCOUNT_ID);
1885: END IF;
1886: open l_ship_to_contact_csr(cust_loc_rec.wsh_location_id, cust_loc_rec.CUST_ACCOUNT_ID);
1887: fetch l_ship_to_contact_csr bulk collect into
1888: l_contact_first_name_tbl,

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

1896: l_contact_last_upd_date_tbl;
1897: close l_ship_to_contact_csr;
1898:
1899: IF l_debug_on THEN
1900: WSH_DEBUG_SV.log(l_module_name,'count of contact table', l_contact_id_tbl.count);
1901: END IF;
1902: IF (l_contact_id_tbl.count > 0 ) THEN
1903: IF l_debug_on THEN
1904: WSH_DEBUG_SV.log(l_module_name,'l_contact_last_upd_date_tbl(1)', l_contact_last_upd_date_tbl(1));

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

1900: WSH_DEBUG_SV.log(l_module_name,'count of contact table', l_contact_id_tbl.count);
1901: END IF;
1902: IF (l_contact_id_tbl.count > 0 ) THEN
1903: IF l_debug_on THEN
1904: WSH_DEBUG_SV.log(l_module_name,'l_contact_last_upd_date_tbl(1)', l_contact_last_upd_date_tbl(1));
1905: END IF;
1906: 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);
1907: ELSE
1908: l_last_update_date := cust_loc_rec.last_update_date;

Line 1915: 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);

1911: --
1912: -- Debug Statements
1913: --
1914: IF l_debug_on THEN
1915: 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);
1916: END IF;
1917: --
1918: WSH_OTM_SYNC_REF_DATA_PKG.IS_REF_DATA_SEND_REQD
1919: (

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

1930: --
1931: -- Debug Statements
1932: --
1933: IF l_debug_on THEN
1934: WSH_DEBUG_SV.log(l_module_name,'l_send_allowed', l_send_allowed);
1935: WSH_DEBUG_SV.log(l_module_name,'l_return_status', l_return_status);
1936: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1937: END IF;
1938: --

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

1931: -- Debug Statements
1932: --
1933: IF l_debug_on THEN
1934: WSH_DEBUG_SV.log(l_module_name,'l_send_allowed', l_send_allowed);
1935: WSH_DEBUG_SV.log(l_module_name,'l_return_status', l_return_status);
1936: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1937: END IF;
1938: --
1939: wsh_util_core.api_post_call(

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

1932: --
1933: IF l_debug_on THEN
1934: WSH_DEBUG_SV.log(l_module_name,'l_send_allowed', l_send_allowed);
1935: WSH_DEBUG_SV.log(l_module_name,'l_return_status', l_return_status);
1936: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1937: END IF;
1938: --
1939: wsh_util_core.api_post_call(
1940: p_return_status => l_return_status,

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

1942: x_num_errors => l_num_errors);
1943:
1944: IF l_debug_on THEN
1945: --
1946: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.LOCATION_ID',cust_loc_rec.LOCATION_ID);
1947: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ADDRESS1',cust_loc_rec.ADDRESS1);
1948: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ADDRESS2',cust_loc_rec.ADDRESS2);
1949: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ADDRESS3',cust_loc_rec.ADDRESS3);
1950: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ADDRESS4',cust_loc_rec.ADDRESS4);

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

1943:
1944: IF l_debug_on THEN
1945: --
1946: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.LOCATION_ID',cust_loc_rec.LOCATION_ID);
1947: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ADDRESS1',cust_loc_rec.ADDRESS1);
1948: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ADDRESS2',cust_loc_rec.ADDRESS2);
1949: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ADDRESS3',cust_loc_rec.ADDRESS3);
1950: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ADDRESS4',cust_loc_rec.ADDRESS4);
1951: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.CITY',cust_loc_rec.CITY);

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

1944: IF l_debug_on THEN
1945: --
1946: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.LOCATION_ID',cust_loc_rec.LOCATION_ID);
1947: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ADDRESS1',cust_loc_rec.ADDRESS1);
1948: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ADDRESS2',cust_loc_rec.ADDRESS2);
1949: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ADDRESS3',cust_loc_rec.ADDRESS3);
1950: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ADDRESS4',cust_loc_rec.ADDRESS4);
1951: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.CITY',cust_loc_rec.CITY);
1952: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.PROVINCE',cust_loc_rec.PROVINCE);

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

1945: --
1946: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.LOCATION_ID',cust_loc_rec.LOCATION_ID);
1947: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ADDRESS1',cust_loc_rec.ADDRESS1);
1948: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ADDRESS2',cust_loc_rec.ADDRESS2);
1949: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ADDRESS3',cust_loc_rec.ADDRESS3);
1950: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ADDRESS4',cust_loc_rec.ADDRESS4);
1951: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.CITY',cust_loc_rec.CITY);
1952: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.PROVINCE',cust_loc_rec.PROVINCE);
1953: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.STATE',cust_loc_rec.STATE);

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

1946: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.LOCATION_ID',cust_loc_rec.LOCATION_ID);
1947: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ADDRESS1',cust_loc_rec.ADDRESS1);
1948: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ADDRESS2',cust_loc_rec.ADDRESS2);
1949: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ADDRESS3',cust_loc_rec.ADDRESS3);
1950: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ADDRESS4',cust_loc_rec.ADDRESS4);
1951: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.CITY',cust_loc_rec.CITY);
1952: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.PROVINCE',cust_loc_rec.PROVINCE);
1953: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.STATE',cust_loc_rec.STATE);
1954: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.POSTAL_CODE',cust_loc_rec.POSTAL_CODE);

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

1947: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ADDRESS1',cust_loc_rec.ADDRESS1);
1948: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ADDRESS2',cust_loc_rec.ADDRESS2);
1949: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ADDRESS3',cust_loc_rec.ADDRESS3);
1950: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ADDRESS4',cust_loc_rec.ADDRESS4);
1951: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.CITY',cust_loc_rec.CITY);
1952: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.PROVINCE',cust_loc_rec.PROVINCE);
1953: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.STATE',cust_loc_rec.STATE);
1954: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.POSTAL_CODE',cust_loc_rec.POSTAL_CODE);
1955: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.COUNTRY',cust_loc_rec.COUNTRY);

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

1948: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ADDRESS2',cust_loc_rec.ADDRESS2);
1949: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ADDRESS3',cust_loc_rec.ADDRESS3);
1950: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ADDRESS4',cust_loc_rec.ADDRESS4);
1951: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.CITY',cust_loc_rec.CITY);
1952: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.PROVINCE',cust_loc_rec.PROVINCE);
1953: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.STATE',cust_loc_rec.STATE);
1954: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.POSTAL_CODE',cust_loc_rec.POSTAL_CODE);
1955: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.COUNTRY',cust_loc_rec.COUNTRY);
1956: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.PARTY_NAME',cust_loc_rec.PARTY_NAME);

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

1949: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ADDRESS3',cust_loc_rec.ADDRESS3);
1950: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ADDRESS4',cust_loc_rec.ADDRESS4);
1951: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.CITY',cust_loc_rec.CITY);
1952: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.PROVINCE',cust_loc_rec.PROVINCE);
1953: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.STATE',cust_loc_rec.STATE);
1954: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.POSTAL_CODE',cust_loc_rec.POSTAL_CODE);
1955: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.COUNTRY',cust_loc_rec.COUNTRY);
1956: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.PARTY_NAME',cust_loc_rec.PARTY_NAME);
1957: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.CUST_ACCOUNT_ID',cust_loc_rec.CUST_ACCOUNT_ID);

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

1950: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ADDRESS4',cust_loc_rec.ADDRESS4);
1951: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.CITY',cust_loc_rec.CITY);
1952: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.PROVINCE',cust_loc_rec.PROVINCE);
1953: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.STATE',cust_loc_rec.STATE);
1954: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.POSTAL_CODE',cust_loc_rec.POSTAL_CODE);
1955: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.COUNTRY',cust_loc_rec.COUNTRY);
1956: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.PARTY_NAME',cust_loc_rec.PARTY_NAME);
1957: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.CUST_ACCOUNT_ID',cust_loc_rec.CUST_ACCOUNT_ID);
1958: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ACCOUNT_NUMBER',cust_loc_rec.ACCOUNT_NUMBER);

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

1951: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.CITY',cust_loc_rec.CITY);
1952: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.PROVINCE',cust_loc_rec.PROVINCE);
1953: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.STATE',cust_loc_rec.STATE);
1954: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.POSTAL_CODE',cust_loc_rec.POSTAL_CODE);
1955: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.COUNTRY',cust_loc_rec.COUNTRY);
1956: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.PARTY_NAME',cust_loc_rec.PARTY_NAME);
1957: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.CUST_ACCOUNT_ID',cust_loc_rec.CUST_ACCOUNT_ID);
1958: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ACCOUNT_NUMBER',cust_loc_rec.ACCOUNT_NUMBER);
1959: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.WSH_LOCATION_ID',cust_loc_rec.WSH_LOCATION_ID);

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

1952: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.PROVINCE',cust_loc_rec.PROVINCE);
1953: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.STATE',cust_loc_rec.STATE);
1954: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.POSTAL_CODE',cust_loc_rec.POSTAL_CODE);
1955: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.COUNTRY',cust_loc_rec.COUNTRY);
1956: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.PARTY_NAME',cust_loc_rec.PARTY_NAME);
1957: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.CUST_ACCOUNT_ID',cust_loc_rec.CUST_ACCOUNT_ID);
1958: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ACCOUNT_NUMBER',cust_loc_rec.ACCOUNT_NUMBER);
1959: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.WSH_LOCATION_ID',cust_loc_rec.WSH_LOCATION_ID);
1960: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.LAST_UPDATE_DATE',cust_loc_rec.LAST_UPDATE_DATE);

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

1953: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.STATE',cust_loc_rec.STATE);
1954: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.POSTAL_CODE',cust_loc_rec.POSTAL_CODE);
1955: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.COUNTRY',cust_loc_rec.COUNTRY);
1956: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.PARTY_NAME',cust_loc_rec.PARTY_NAME);
1957: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.CUST_ACCOUNT_ID',cust_loc_rec.CUST_ACCOUNT_ID);
1958: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ACCOUNT_NUMBER',cust_loc_rec.ACCOUNT_NUMBER);
1959: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.WSH_LOCATION_ID',cust_loc_rec.WSH_LOCATION_ID);
1960: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.LAST_UPDATE_DATE',cust_loc_rec.LAST_UPDATE_DATE);
1961: WSH_DEBUG_SV.log(l_module_name,'l_last_update_date', l_last_update_date);

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

1954: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.POSTAL_CODE',cust_loc_rec.POSTAL_CODE);
1955: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.COUNTRY',cust_loc_rec.COUNTRY);
1956: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.PARTY_NAME',cust_loc_rec.PARTY_NAME);
1957: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.CUST_ACCOUNT_ID',cust_loc_rec.CUST_ACCOUNT_ID);
1958: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ACCOUNT_NUMBER',cust_loc_rec.ACCOUNT_NUMBER);
1959: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.WSH_LOCATION_ID',cust_loc_rec.WSH_LOCATION_ID);
1960: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.LAST_UPDATE_DATE',cust_loc_rec.LAST_UPDATE_DATE);
1961: WSH_DEBUG_SV.log(l_module_name,'l_last_update_date', l_last_update_date);
1962: WSH_DEBUG_SV.log(l_module_name,'l_send_allowed', l_send_allowed);

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

1955: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.COUNTRY',cust_loc_rec.COUNTRY);
1956: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.PARTY_NAME',cust_loc_rec.PARTY_NAME);
1957: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.CUST_ACCOUNT_ID',cust_loc_rec.CUST_ACCOUNT_ID);
1958: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ACCOUNT_NUMBER',cust_loc_rec.ACCOUNT_NUMBER);
1959: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.WSH_LOCATION_ID',cust_loc_rec.WSH_LOCATION_ID);
1960: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.LAST_UPDATE_DATE',cust_loc_rec.LAST_UPDATE_DATE);
1961: WSH_DEBUG_SV.log(l_module_name,'l_last_update_date', l_last_update_date);
1962: WSH_DEBUG_SV.log(l_module_name,'l_send_allowed', l_send_allowed);
1963: --

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

1956: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.PARTY_NAME',cust_loc_rec.PARTY_NAME);
1957: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.CUST_ACCOUNT_ID',cust_loc_rec.CUST_ACCOUNT_ID);
1958: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ACCOUNT_NUMBER',cust_loc_rec.ACCOUNT_NUMBER);
1959: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.WSH_LOCATION_ID',cust_loc_rec.WSH_LOCATION_ID);
1960: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.LAST_UPDATE_DATE',cust_loc_rec.LAST_UPDATE_DATE);
1961: WSH_DEBUG_SV.log(l_module_name,'l_last_update_date', l_last_update_date);
1962: WSH_DEBUG_SV.log(l_module_name,'l_send_allowed', l_send_allowed);
1963: --
1964: END IF;

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

1957: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.CUST_ACCOUNT_ID',cust_loc_rec.CUST_ACCOUNT_ID);
1958: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ACCOUNT_NUMBER',cust_loc_rec.ACCOUNT_NUMBER);
1959: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.WSH_LOCATION_ID',cust_loc_rec.WSH_LOCATION_ID);
1960: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.LAST_UPDATE_DATE',cust_loc_rec.LAST_UPDATE_DATE);
1961: WSH_DEBUG_SV.log(l_module_name,'l_last_update_date', l_last_update_date);
1962: WSH_DEBUG_SV.log(l_module_name,'l_send_allowed', l_send_allowed);
1963: --
1964: END IF;
1965: --

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

1958: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.ACCOUNT_NUMBER',cust_loc_rec.ACCOUNT_NUMBER);
1959: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.WSH_LOCATION_ID',cust_loc_rec.WSH_LOCATION_ID);
1960: WSH_DEBUG_SV.log(l_module_name,'cust_loc_rec.LAST_UPDATE_DATE',cust_loc_rec.LAST_UPDATE_DATE);
1961: WSH_DEBUG_SV.log(l_module_name,'l_last_update_date', l_last_update_date);
1962: WSH_DEBUG_SV.log(l_module_name,'l_send_allowed', l_send_allowed);
1963: --
1964: END IF;
1965: --
1966: IF (l_send_allowed) THEN

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

2148: x_loc_xmission_rec.LOCATIONS_TBL(i).LOC_CONTACT_TBL(k).TXN_CODE := 'IU';
2149:
2150: IF l_debug_on THEN
2151: --
2152: WSH_DEBUG_SV.log(l_module_name,'l_contact_ph_cntr_code_tbl('||k||')',l_contact_ph_cntr_code_tbl(k));
2153: WSH_DEBUG_SV.log(l_module_name,'l_contact_ph_area_code_tbl('||k||')',l_contact_ph_area_code_tbl(k));
2154: WSH_DEBUG_SV.log(l_module_name,'l_contact_ph_number_tbl('||k||')',l_contact_ph_number_tbl(k));
2155: WSH_DEBUG_SV.log(l_module_name,'l_contact_email_addr_tbl('||k||')',l_contact_email_addr_tbl(k));
2156: WSH_DEBUG_SV.log(l_module_name,'l_contact_first_name_tbl('||k||')',l_contact_first_name_tbl(k));

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

2149:
2150: IF l_debug_on THEN
2151: --
2152: WSH_DEBUG_SV.log(l_module_name,'l_contact_ph_cntr_code_tbl('||k||')',l_contact_ph_cntr_code_tbl(k));
2153: WSH_DEBUG_SV.log(l_module_name,'l_contact_ph_area_code_tbl('||k||')',l_contact_ph_area_code_tbl(k));
2154: WSH_DEBUG_SV.log(l_module_name,'l_contact_ph_number_tbl('||k||')',l_contact_ph_number_tbl(k));
2155: WSH_DEBUG_SV.log(l_module_name,'l_contact_email_addr_tbl('||k||')',l_contact_email_addr_tbl(k));
2156: WSH_DEBUG_SV.log(l_module_name,'l_contact_first_name_tbl('||k||')',l_contact_first_name_tbl(k));
2157: WSH_DEBUG_SV.log(l_module_name,'l_contact_last_name_tbl('||k||')',l_contact_last_name_tbl(k));

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

2150: IF l_debug_on THEN
2151: --
2152: WSH_DEBUG_SV.log(l_module_name,'l_contact_ph_cntr_code_tbl('||k||')',l_contact_ph_cntr_code_tbl(k));
2153: WSH_DEBUG_SV.log(l_module_name,'l_contact_ph_area_code_tbl('||k||')',l_contact_ph_area_code_tbl(k));
2154: WSH_DEBUG_SV.log(l_module_name,'l_contact_ph_number_tbl('||k||')',l_contact_ph_number_tbl(k));
2155: WSH_DEBUG_SV.log(l_module_name,'l_contact_email_addr_tbl('||k||')',l_contact_email_addr_tbl(k));
2156: WSH_DEBUG_SV.log(l_module_name,'l_contact_first_name_tbl('||k||')',l_contact_first_name_tbl(k));
2157: WSH_DEBUG_SV.log(l_module_name,'l_contact_last_name_tbl('||k||')',l_contact_last_name_tbl(k));
2158: WSH_DEBUG_SV.log(l_module_name,'l_contact_job_title_tbl('||k||')',l_contact_job_title_tbl(k));

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

2151: --
2152: WSH_DEBUG_SV.log(l_module_name,'l_contact_ph_cntr_code_tbl('||k||')',l_contact_ph_cntr_code_tbl(k));
2153: WSH_DEBUG_SV.log(l_module_name,'l_contact_ph_area_code_tbl('||k||')',l_contact_ph_area_code_tbl(k));
2154: WSH_DEBUG_SV.log(l_module_name,'l_contact_ph_number_tbl('||k||')',l_contact_ph_number_tbl(k));
2155: WSH_DEBUG_SV.log(l_module_name,'l_contact_email_addr_tbl('||k||')',l_contact_email_addr_tbl(k));
2156: WSH_DEBUG_SV.log(l_module_name,'l_contact_first_name_tbl('||k||')',l_contact_first_name_tbl(k));
2157: WSH_DEBUG_SV.log(l_module_name,'l_contact_last_name_tbl('||k||')',l_contact_last_name_tbl(k));
2158: WSH_DEBUG_SV.log(l_module_name,'l_contact_job_title_tbl('||k||')',l_contact_job_title_tbl(k));
2159: --

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

2152: WSH_DEBUG_SV.log(l_module_name,'l_contact_ph_cntr_code_tbl('||k||')',l_contact_ph_cntr_code_tbl(k));
2153: WSH_DEBUG_SV.log(l_module_name,'l_contact_ph_area_code_tbl('||k||')',l_contact_ph_area_code_tbl(k));
2154: WSH_DEBUG_SV.log(l_module_name,'l_contact_ph_number_tbl('||k||')',l_contact_ph_number_tbl(k));
2155: WSH_DEBUG_SV.log(l_module_name,'l_contact_email_addr_tbl('||k||')',l_contact_email_addr_tbl(k));
2156: WSH_DEBUG_SV.log(l_module_name,'l_contact_first_name_tbl('||k||')',l_contact_first_name_tbl(k));
2157: WSH_DEBUG_SV.log(l_module_name,'l_contact_last_name_tbl('||k||')',l_contact_last_name_tbl(k));
2158: WSH_DEBUG_SV.log(l_module_name,'l_contact_job_title_tbl('||k||')',l_contact_job_title_tbl(k));
2159: --
2160: END IF;

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

2153: WSH_DEBUG_SV.log(l_module_name,'l_contact_ph_area_code_tbl('||k||')',l_contact_ph_area_code_tbl(k));
2154: WSH_DEBUG_SV.log(l_module_name,'l_contact_ph_number_tbl('||k||')',l_contact_ph_number_tbl(k));
2155: WSH_DEBUG_SV.log(l_module_name,'l_contact_email_addr_tbl('||k||')',l_contact_email_addr_tbl(k));
2156: WSH_DEBUG_SV.log(l_module_name,'l_contact_first_name_tbl('||k||')',l_contact_first_name_tbl(k));
2157: WSH_DEBUG_SV.log(l_module_name,'l_contact_last_name_tbl('||k||')',l_contact_last_name_tbl(k));
2158: WSH_DEBUG_SV.log(l_module_name,'l_contact_job_title_tbl('||k||')',l_contact_job_title_tbl(k));
2159: --
2160: END IF;
2161: l_contact_ph := NULL;

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

2154: WSH_DEBUG_SV.log(l_module_name,'l_contact_ph_number_tbl('||k||')',l_contact_ph_number_tbl(k));
2155: WSH_DEBUG_SV.log(l_module_name,'l_contact_email_addr_tbl('||k||')',l_contact_email_addr_tbl(k));
2156: WSH_DEBUG_SV.log(l_module_name,'l_contact_first_name_tbl('||k||')',l_contact_first_name_tbl(k));
2157: WSH_DEBUG_SV.log(l_module_name,'l_contact_last_name_tbl('||k||')',l_contact_last_name_tbl(k));
2158: WSH_DEBUG_SV.log(l_module_name,'l_contact_job_title_tbl('||k||')',l_contact_job_title_tbl(k));
2159: --
2160: END IF;
2161: l_contact_ph := NULL;
2162:

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

2201: FND_PROFILE.Get('WSH_OTM_USER_ID',x_loc_xmission_rec.username);
2202: FND_PROFILE.Get('WSH_OTM_PASSWORD',x_loc_xmission_rec.password);
2203:
2204: IF l_debug_on THEN
2205: WSH_DEBUG_SV.log(l_module_name,'x_loc_xmission_rec.username', x_loc_xmission_rec.username);
2206: WSH_DEBUG_SV.log(l_module_name,'x_loc_xmission_rec.password', x_loc_xmission_rec.password);
2207: END IF;
2208:
2209: IF (x_loc_xmission_rec.username is null) THEN

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

2202: FND_PROFILE.Get('WSH_OTM_PASSWORD',x_loc_xmission_rec.password);
2203:
2204: IF l_debug_on THEN
2205: WSH_DEBUG_SV.log(l_module_name,'x_loc_xmission_rec.username', x_loc_xmission_rec.username);
2206: WSH_DEBUG_SV.log(l_module_name,'x_loc_xmission_rec.password', x_loc_xmission_rec.password);
2207: END IF;
2208:
2209: IF (x_loc_xmission_rec.username is null) THEN
2210: --{

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

2212: FND_MESSAGE.SET_TOKEN('PRF_NAME','WSH_OTM_USER_ID');
2213: x_return_status := wsh_util_core.G_RET_STS_UNEXP_ERROR;
2214: wsh_util_core.add_message(x_return_status, l_module_name);
2215: IF l_debug_on THEN
2216: WSH_DEBUG_SV.logmsg(l_module_name,'Error: The profile WSH_OTM_USER_ID is set to NULL. Please correct the profile value');
2217: END IF;
2218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2219: --}
2220: END IF;

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

2225: FND_MESSAGE.SET_TOKEN('PRF_NAME','WSH_OTM_PASSWORD');
2226: x_return_status := wsh_util_core.G_RET_STS_UNEXP_ERROR;
2227: wsh_util_core.add_message(x_return_status, l_module_name);
2228: IF l_debug_on THEN
2229: WSH_DEBUG_SV.logmsg(l_module_name,'Error: The profile WSH_OTM_PASSWORD is set to NULL. Please correct the profile value');
2230: END IF;
2231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2232: --}
2233: END IF;

Line 2245: 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);

2241: -- of storing already sent carriers
2242: -- Debug Statements
2243: --
2244: IF l_debug_on THEN
2245: 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);
2246: END IF;
2247: --
2248:
2249: WSH_OTM_SYNC_REF_DATA_PKG.IS_REF_DATA_SEND_REQD

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

2261: --
2262: -- Debug Statements
2263: --
2264: IF l_debug_on THEN
2265: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling IS_REF_DATA_SEND_REQD is', l_return_status);
2266: WSH_DEBUG_SV.log(l_module_name,'l_send_allowed', l_send_allowed);
2267: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2268: END IF;
2269: --

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

2262: -- Debug Statements
2263: --
2264: IF l_debug_on THEN
2265: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling IS_REF_DATA_SEND_REQD is', l_return_status);
2266: WSH_DEBUG_SV.log(l_module_name,'l_send_allowed', l_send_allowed);
2267: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2268: END IF;
2269: --
2270: wsh_util_core.api_post_call(

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

2263: --
2264: IF l_debug_on THEN
2265: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling IS_REF_DATA_SEND_REQD is', l_return_status);
2266: WSH_DEBUG_SV.log(l_module_name,'l_send_allowed', l_send_allowed);
2267: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2268: END IF;
2269: --
2270: wsh_util_core.api_post_call(
2271: p_return_status => l_return_status,

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

2274: */
2275:
2276: IF l_debug_on THEN
2277: --
2278: WSH_DEBUG_SV.log(l_module_name,'Current carrier_id',carrier_loc_rec.CARRIER_ID);
2279: WSH_DEBUG_SV.log(l_module_name,'Previous carrier_id', l_prev_carrier_id);
2280: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.CARRIER_SITE_ID',carrier_loc_rec.CARRIER_SITE_ID);
2281: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.CARRIER_NAME',carrier_loc_rec.CARRIER_NAME);
2282: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.LOCATION_NAME',carrier_loc_rec.LOCATION_NAME);

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

2275:
2276: IF l_debug_on THEN
2277: --
2278: WSH_DEBUG_SV.log(l_module_name,'Current carrier_id',carrier_loc_rec.CARRIER_ID);
2279: WSH_DEBUG_SV.log(l_module_name,'Previous carrier_id', l_prev_carrier_id);
2280: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.CARRIER_SITE_ID',carrier_loc_rec.CARRIER_SITE_ID);
2281: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.CARRIER_NAME',carrier_loc_rec.CARRIER_NAME);
2282: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.LOCATION_NAME',carrier_loc_rec.LOCATION_NAME);
2283: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS1',carrier_loc_rec.ADDRESS1);

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

2276: IF l_debug_on THEN
2277: --
2278: WSH_DEBUG_SV.log(l_module_name,'Current carrier_id',carrier_loc_rec.CARRIER_ID);
2279: WSH_DEBUG_SV.log(l_module_name,'Previous carrier_id', l_prev_carrier_id);
2280: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.CARRIER_SITE_ID',carrier_loc_rec.CARRIER_SITE_ID);
2281: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.CARRIER_NAME',carrier_loc_rec.CARRIER_NAME);
2282: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.LOCATION_NAME',carrier_loc_rec.LOCATION_NAME);
2283: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS1',carrier_loc_rec.ADDRESS1);
2284: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS2',carrier_loc_rec.ADDRESS2);

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

2277: --
2278: WSH_DEBUG_SV.log(l_module_name,'Current carrier_id',carrier_loc_rec.CARRIER_ID);
2279: WSH_DEBUG_SV.log(l_module_name,'Previous carrier_id', l_prev_carrier_id);
2280: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.CARRIER_SITE_ID',carrier_loc_rec.CARRIER_SITE_ID);
2281: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.CARRIER_NAME',carrier_loc_rec.CARRIER_NAME);
2282: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.LOCATION_NAME',carrier_loc_rec.LOCATION_NAME);
2283: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS1',carrier_loc_rec.ADDRESS1);
2284: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS2',carrier_loc_rec.ADDRESS2);
2285: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS3',carrier_loc_rec.ADDRESS3);

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

2278: WSH_DEBUG_SV.log(l_module_name,'Current carrier_id',carrier_loc_rec.CARRIER_ID);
2279: WSH_DEBUG_SV.log(l_module_name,'Previous carrier_id', l_prev_carrier_id);
2280: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.CARRIER_SITE_ID',carrier_loc_rec.CARRIER_SITE_ID);
2281: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.CARRIER_NAME',carrier_loc_rec.CARRIER_NAME);
2282: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.LOCATION_NAME',carrier_loc_rec.LOCATION_NAME);
2283: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS1',carrier_loc_rec.ADDRESS1);
2284: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS2',carrier_loc_rec.ADDRESS2);
2285: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS3',carrier_loc_rec.ADDRESS3);
2286: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS4',carrier_loc_rec.ADDRESS4);

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

2279: WSH_DEBUG_SV.log(l_module_name,'Previous carrier_id', l_prev_carrier_id);
2280: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.CARRIER_SITE_ID',carrier_loc_rec.CARRIER_SITE_ID);
2281: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.CARRIER_NAME',carrier_loc_rec.CARRIER_NAME);
2282: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.LOCATION_NAME',carrier_loc_rec.LOCATION_NAME);
2283: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS1',carrier_loc_rec.ADDRESS1);
2284: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS2',carrier_loc_rec.ADDRESS2);
2285: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS3',carrier_loc_rec.ADDRESS3);
2286: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS4',carrier_loc_rec.ADDRESS4);
2287: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.CITY',carrier_loc_rec.CITY);

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

2280: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.CARRIER_SITE_ID',carrier_loc_rec.CARRIER_SITE_ID);
2281: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.CARRIER_NAME',carrier_loc_rec.CARRIER_NAME);
2282: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.LOCATION_NAME',carrier_loc_rec.LOCATION_NAME);
2283: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS1',carrier_loc_rec.ADDRESS1);
2284: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS2',carrier_loc_rec.ADDRESS2);
2285: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS3',carrier_loc_rec.ADDRESS3);
2286: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS4',carrier_loc_rec.ADDRESS4);
2287: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.CITY',carrier_loc_rec.CITY);
2288: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.PROVINCE',carrier_loc_rec.PROVINCE);

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

2281: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.CARRIER_NAME',carrier_loc_rec.CARRIER_NAME);
2282: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.LOCATION_NAME',carrier_loc_rec.LOCATION_NAME);
2283: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS1',carrier_loc_rec.ADDRESS1);
2284: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS2',carrier_loc_rec.ADDRESS2);
2285: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS3',carrier_loc_rec.ADDRESS3);
2286: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS4',carrier_loc_rec.ADDRESS4);
2287: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.CITY',carrier_loc_rec.CITY);
2288: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.PROVINCE',carrier_loc_rec.PROVINCE);
2289: --WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.PROVINCE_CODE',carrier_loc_rec.PROVINCE_CODE);

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

2282: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.LOCATION_NAME',carrier_loc_rec.LOCATION_NAME);
2283: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS1',carrier_loc_rec.ADDRESS1);
2284: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS2',carrier_loc_rec.ADDRESS2);
2285: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS3',carrier_loc_rec.ADDRESS3);
2286: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS4',carrier_loc_rec.ADDRESS4);
2287: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.CITY',carrier_loc_rec.CITY);
2288: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.PROVINCE',carrier_loc_rec.PROVINCE);
2289: --WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.PROVINCE_CODE',carrier_loc_rec.PROVINCE_CODE);
2290: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.POSTAL_CODE',carrier_loc_rec.POSTAL_CODE);

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

2283: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS1',carrier_loc_rec.ADDRESS1);
2284: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS2',carrier_loc_rec.ADDRESS2);
2285: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS3',carrier_loc_rec.ADDRESS3);
2286: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS4',carrier_loc_rec.ADDRESS4);
2287: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.CITY',carrier_loc_rec.CITY);
2288: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.PROVINCE',carrier_loc_rec.PROVINCE);
2289: --WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.PROVINCE_CODE',carrier_loc_rec.PROVINCE_CODE);
2290: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.POSTAL_CODE',carrier_loc_rec.POSTAL_CODE);
2291: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.COUNTRY',carrier_loc_rec.COUNTRY);

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

2284: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS2',carrier_loc_rec.ADDRESS2);
2285: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS3',carrier_loc_rec.ADDRESS3);
2286: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS4',carrier_loc_rec.ADDRESS4);
2287: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.CITY',carrier_loc_rec.CITY);
2288: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.PROVINCE',carrier_loc_rec.PROVINCE);
2289: --WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.PROVINCE_CODE',carrier_loc_rec.PROVINCE_CODE);
2290: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.POSTAL_CODE',carrier_loc_rec.POSTAL_CODE);
2291: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.COUNTRY',carrier_loc_rec.COUNTRY);
2292: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.SUPPLIER_ID',carrier_loc_rec.SUPPLIER_ID);

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

2285: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS3',carrier_loc_rec.ADDRESS3);
2286: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS4',carrier_loc_rec.ADDRESS4);
2287: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.CITY',carrier_loc_rec.CITY);
2288: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.PROVINCE',carrier_loc_rec.PROVINCE);
2289: --WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.PROVINCE_CODE',carrier_loc_rec.PROVINCE_CODE);
2290: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.POSTAL_CODE',carrier_loc_rec.POSTAL_CODE);
2291: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.COUNTRY',carrier_loc_rec.COUNTRY);
2292: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.SUPPLIER_ID',carrier_loc_rec.SUPPLIER_ID);
2293: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.SCAC_CODE',carrier_loc_rec.SCAC_CODE);

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

2286: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.ADDRESS4',carrier_loc_rec.ADDRESS4);
2287: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.CITY',carrier_loc_rec.CITY);
2288: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.PROVINCE',carrier_loc_rec.PROVINCE);
2289: --WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.PROVINCE_CODE',carrier_loc_rec.PROVINCE_CODE);
2290: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.POSTAL_CODE',carrier_loc_rec.POSTAL_CODE);
2291: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.COUNTRY',carrier_loc_rec.COUNTRY);
2292: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.SUPPLIER_ID',carrier_loc_rec.SUPPLIER_ID);
2293: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.SCAC_CODE',carrier_loc_rec.SCAC_CODE);
2294: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.LOCATION_ID',carrier_loc_rec.LOCATION_ID);

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

2287: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.CITY',carrier_loc_rec.CITY);
2288: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.PROVINCE',carrier_loc_rec.PROVINCE);
2289: --WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.PROVINCE_CODE',carrier_loc_rec.PROVINCE_CODE);
2290: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.POSTAL_CODE',carrier_loc_rec.POSTAL_CODE);
2291: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.COUNTRY',carrier_loc_rec.COUNTRY);
2292: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.SUPPLIER_ID',carrier_loc_rec.SUPPLIER_ID);
2293: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.SCAC_CODE',carrier_loc_rec.SCAC_CODE);
2294: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.LOCATION_ID',carrier_loc_rec.LOCATION_ID);
2295: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.WSH_LOCATION_ID',carrier_loc_rec.WSH_LOCATION_ID);

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

2288: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.PROVINCE',carrier_loc_rec.PROVINCE);
2289: --WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.PROVINCE_CODE',carrier_loc_rec.PROVINCE_CODE);
2290: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.POSTAL_CODE',carrier_loc_rec.POSTAL_CODE);
2291: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.COUNTRY',carrier_loc_rec.COUNTRY);
2292: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.SUPPLIER_ID',carrier_loc_rec.SUPPLIER_ID);
2293: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.SCAC_CODE',carrier_loc_rec.SCAC_CODE);
2294: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.LOCATION_ID',carrier_loc_rec.LOCATION_ID);
2295: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.WSH_LOCATION_ID',carrier_loc_rec.WSH_LOCATION_ID);
2296: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.HZL_LAST_UPD_DATE',carrier_loc_rec.HZL_LAST_UPD_DATE);

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

2289: --WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.PROVINCE_CODE',carrier_loc_rec.PROVINCE_CODE);
2290: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.POSTAL_CODE',carrier_loc_rec.POSTAL_CODE);
2291: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.COUNTRY',carrier_loc_rec.COUNTRY);
2292: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.SUPPLIER_ID',carrier_loc_rec.SUPPLIER_ID);
2293: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.SCAC_CODE',carrier_loc_rec.SCAC_CODE);
2294: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.LOCATION_ID',carrier_loc_rec.LOCATION_ID);
2295: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.WSH_LOCATION_ID',carrier_loc_rec.WSH_LOCATION_ID);
2296: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.HZL_LAST_UPD_DATE',carrier_loc_rec.HZL_LAST_UPD_DATE);
2297: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.WCV_LAST_UPD_DATE',carrier_loc_rec.WCV_LAST_UPD_DATE);

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

2290: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.POSTAL_CODE',carrier_loc_rec.POSTAL_CODE);
2291: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.COUNTRY',carrier_loc_rec.COUNTRY);
2292: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.SUPPLIER_ID',carrier_loc_rec.SUPPLIER_ID);
2293: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.SCAC_CODE',carrier_loc_rec.SCAC_CODE);
2294: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.LOCATION_ID',carrier_loc_rec.LOCATION_ID);
2295: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.WSH_LOCATION_ID',carrier_loc_rec.WSH_LOCATION_ID);
2296: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.HZL_LAST_UPD_DATE',carrier_loc_rec.HZL_LAST_UPD_DATE);
2297: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.WCV_LAST_UPD_DATE',carrier_loc_rec.WCV_LAST_UPD_DATE);
2298: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.HPS_LAST_UPD_DATE',carrier_loc_rec.HPS_LAST_UPD_DATE);

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

2291: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.COUNTRY',carrier_loc_rec.COUNTRY);
2292: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.SUPPLIER_ID',carrier_loc_rec.SUPPLIER_ID);
2293: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.SCAC_CODE',carrier_loc_rec.SCAC_CODE);
2294: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.LOCATION_ID',carrier_loc_rec.LOCATION_ID);
2295: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.WSH_LOCATION_ID',carrier_loc_rec.WSH_LOCATION_ID);
2296: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.HZL_LAST_UPD_DATE',carrier_loc_rec.HZL_LAST_UPD_DATE);
2297: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.WCV_LAST_UPD_DATE',carrier_loc_rec.WCV_LAST_UPD_DATE);
2298: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.HPS_LAST_UPD_DATE',carrier_loc_rec.HPS_LAST_UPD_DATE);
2299: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.HP_LAST_UPD_DATE',carrier_loc_rec.HP_LAST_UPD_DATE);

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

2292: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.SUPPLIER_ID',carrier_loc_rec.SUPPLIER_ID);
2293: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.SCAC_CODE',carrier_loc_rec.SCAC_CODE);
2294: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.LOCATION_ID',carrier_loc_rec.LOCATION_ID);
2295: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.WSH_LOCATION_ID',carrier_loc_rec.WSH_LOCATION_ID);
2296: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.HZL_LAST_UPD_DATE',carrier_loc_rec.HZL_LAST_UPD_DATE);
2297: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.WCV_LAST_UPD_DATE',carrier_loc_rec.WCV_LAST_UPD_DATE);
2298: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.HPS_LAST_UPD_DATE',carrier_loc_rec.HPS_LAST_UPD_DATE);
2299: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.HP_LAST_UPD_DATE',carrier_loc_rec.HP_LAST_UPD_DATE);
2300: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.SUPPLIER_SITE_ID',carrier_loc_rec.SUPPLIER_SITE_ID);

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

2293: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.SCAC_CODE',carrier_loc_rec.SCAC_CODE);
2294: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.LOCATION_ID',carrier_loc_rec.LOCATION_ID);
2295: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.WSH_LOCATION_ID',carrier_loc_rec.WSH_LOCATION_ID);
2296: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.HZL_LAST_UPD_DATE',carrier_loc_rec.HZL_LAST_UPD_DATE);
2297: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.WCV_LAST_UPD_DATE',carrier_loc_rec.WCV_LAST_UPD_DATE);
2298: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.HPS_LAST_UPD_DATE',carrier_loc_rec.HPS_LAST_UPD_DATE);
2299: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.HP_LAST_UPD_DATE',carrier_loc_rec.HP_LAST_UPD_DATE);
2300: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.SUPPLIER_SITE_ID',carrier_loc_rec.SUPPLIER_SITE_ID);
2301: WSH_DEBUG_SV.log(l_module_name,'l_last_update_date', l_last_update_date);

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

2294: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.LOCATION_ID',carrier_loc_rec.LOCATION_ID);
2295: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.WSH_LOCATION_ID',carrier_loc_rec.WSH_LOCATION_ID);
2296: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.HZL_LAST_UPD_DATE',carrier_loc_rec.HZL_LAST_UPD_DATE);
2297: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.WCV_LAST_UPD_DATE',carrier_loc_rec.WCV_LAST_UPD_DATE);
2298: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.HPS_LAST_UPD_DATE',carrier_loc_rec.HPS_LAST_UPD_DATE);
2299: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.HP_LAST_UPD_DATE',carrier_loc_rec.HP_LAST_UPD_DATE);
2300: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.SUPPLIER_SITE_ID',carrier_loc_rec.SUPPLIER_SITE_ID);
2301: WSH_DEBUG_SV.log(l_module_name,'l_last_update_date', l_last_update_date);
2302: --

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

2295: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.WSH_LOCATION_ID',carrier_loc_rec.WSH_LOCATION_ID);
2296: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.HZL_LAST_UPD_DATE',carrier_loc_rec.HZL_LAST_UPD_DATE);
2297: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.WCV_LAST_UPD_DATE',carrier_loc_rec.WCV_LAST_UPD_DATE);
2298: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.HPS_LAST_UPD_DATE',carrier_loc_rec.HPS_LAST_UPD_DATE);
2299: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.HP_LAST_UPD_DATE',carrier_loc_rec.HP_LAST_UPD_DATE);
2300: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.SUPPLIER_SITE_ID',carrier_loc_rec.SUPPLIER_SITE_ID);
2301: WSH_DEBUG_SV.log(l_module_name,'l_last_update_date', l_last_update_date);
2302: --
2303: END IF;

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

2296: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.HZL_LAST_UPD_DATE',carrier_loc_rec.HZL_LAST_UPD_DATE);
2297: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.WCV_LAST_UPD_DATE',carrier_loc_rec.WCV_LAST_UPD_DATE);
2298: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.HPS_LAST_UPD_DATE',carrier_loc_rec.HPS_LAST_UPD_DATE);
2299: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.HP_LAST_UPD_DATE',carrier_loc_rec.HP_LAST_UPD_DATE);
2300: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.SUPPLIER_SITE_ID',carrier_loc_rec.SUPPLIER_SITE_ID);
2301: WSH_DEBUG_SV.log(l_module_name,'l_last_update_date', l_last_update_date);
2302: --
2303: END IF;
2304:

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

2297: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.WCV_LAST_UPD_DATE',carrier_loc_rec.WCV_LAST_UPD_DATE);
2298: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.HPS_LAST_UPD_DATE',carrier_loc_rec.HPS_LAST_UPD_DATE);
2299: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.HP_LAST_UPD_DATE',carrier_loc_rec.HP_LAST_UPD_DATE);
2300: WSH_DEBUG_SV.log(l_module_name,'carrier_loc_rec.SUPPLIER_SITE_ID',carrier_loc_rec.SUPPLIER_SITE_ID);
2301: WSH_DEBUG_SV.log(l_module_name,'l_last_update_date', l_last_update_date);
2302: --
2303: END IF;
2304:
2305: IF (nvl(l_prev_carrier_id,-999) <> nvl(l_carrier_id,-998)) THEN

Line 2586: WSH_DEBUG_SV.pop(l_module_name);

2582: --
2583: -- Debug Statements
2584: --
2585: IF l_debug_on THEN
2586: WSH_DEBUG_SV.pop(l_module_name);
2587: END IF;
2588: --
2589: EXCEPTION
2590: --{

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

2594: --
2595: -- Debug Statements
2596: --
2597: IF l_debug_on THEN
2598: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2599: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2600: END IF;
2601: --
2602: END EXTRACT_LOCATION_INFO;

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

2595: -- Debug Statements
2596: --
2597: IF l_debug_on THEN
2598: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2599: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2600: END IF;
2601: --
2602: END EXTRACT_LOCATION_INFO;
2603:

Line 2643: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

2639: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2640: --
2641: IF l_debug_on IS NULL
2642: THEN
2643: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2644: END IF;
2645: --
2646: --
2647: -- Debug Statements

Line 2650: WSH_DEBUG_SV.push(l_module_name);

2646: --
2647: -- Debug Statements
2648: --
2649: IF l_debug_on THEN
2650: WSH_DEBUG_SV.push(l_module_name);
2651: WSH_DEBUG_SV.log(l_module_name,'entity type is ', p_entity_in_rec.entity_type);
2652: END IF;
2653: --
2654: x_return_status := wsh_util_core.g_ret_sts_success;

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

2647: -- Debug Statements
2648: --
2649: IF l_debug_on THEN
2650: WSH_DEBUG_SV.push(l_module_name);
2651: WSH_DEBUG_SV.log(l_module_name,'entity type is ', p_entity_in_rec.entity_type);
2652: END IF;
2653: --
2654: x_return_status := wsh_util_core.g_ret_sts_success;
2655:

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

2667: --
2668: -- Debug Statements
2669: --
2670: IF l_debug_on THEN
2671: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2672: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling EXTRACT_TRIP_INFO is', l_return_status);
2673: END IF;
2674: --
2675: wsh_util_core.api_post_call(

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

2668: -- Debug Statements
2669: --
2670: IF l_debug_on THEN
2671: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2672: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling EXTRACT_TRIP_INFO is', l_return_status);
2673: END IF;
2674: --
2675: wsh_util_core.api_post_call(
2676: p_return_status => l_return_status,

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

2691: --
2692: -- Debug Statements
2693: --
2694: IF l_debug_on THEN
2695: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2696: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling EXTRACT_TRIP_INFO is', l_return_status);
2697: END IF;
2698: --
2699: wsh_util_core.api_post_call(

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

2692: -- Debug Statements
2693: --
2694: IF l_debug_on THEN
2695: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2696: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling EXTRACT_TRIP_INFO is', l_return_status);
2697: END IF;
2698: --
2699: wsh_util_core.api_post_call(
2700: p_return_status => l_return_status,

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

2717: --
2718: -- Debug Statements
2719: --
2720: IF l_debug_on THEN
2721: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling VALIDATE_TKT is', l_return_status);
2722: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2723: END IF;
2724: --
2725: wsh_util_core.api_post_call(

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

2718: -- Debug Statements
2719: --
2720: IF l_debug_on THEN
2721: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling VALIDATE_TKT is', l_return_status);
2722: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2723: END IF;
2724: --
2725: wsh_util_core.api_post_call(
2726: p_return_status => l_return_status,

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

2738: --
2739: -- Debug Statements
2740: --
2741: IF l_debug_on THEN
2742: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2743: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling EXTRACT_CARRIER_INFO is', l_return_status);
2744: END IF;
2745: --
2746: wsh_util_core.api_post_call(

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

2739: -- Debug Statements
2740: --
2741: IF l_debug_on THEN
2742: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2743: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling EXTRACT_CARRIER_INFO is', l_return_status);
2744: END IF;
2745: --
2746: wsh_util_core.api_post_call(
2747: p_return_status => l_return_status,

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

2765: --
2766: -- Debug Statements
2767: --
2768: IF l_debug_on THEN
2769: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling VALIDATE_TKT is', l_return_status);
2770: WSH_DEBUG_SV.logmsg(l_module_name,'calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2771: END IF;
2772: --
2773: wsh_util_core.api_post_call(

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

2766: -- Debug Statements
2767: --
2768: IF l_debug_on THEN
2769: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling VALIDATE_TKT is', l_return_status);
2770: WSH_DEBUG_SV.logmsg(l_module_name,'calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2771: END IF;
2772: --
2773: wsh_util_core.api_post_call(
2774: p_return_status => l_return_status,

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

2786: --
2787: -- Debug Statements
2788: --
2789: IF l_debug_on THEN
2790: WSH_DEBUG_SV.logmsg(l_module_name,'OrgAfterCalling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2791: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling EXTRACT_ORG_INFO is', l_return_status);
2792: END IF;
2793: --
2794: wsh_util_core.api_post_call(

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

2787: -- Debug Statements
2788: --
2789: IF l_debug_on THEN
2790: WSH_DEBUG_SV.logmsg(l_module_name,'OrgAfterCalling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2791: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling EXTRACT_ORG_INFO is', l_return_status);
2792: END IF;
2793: --
2794: wsh_util_core.api_post_call(
2795: p_return_status => l_return_status,

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

2821: --
2822: -- Debug Statements
2823: --
2824: IF l_debug_on THEN
2825: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling EXTRACT_LOCATION_INFO is', l_return_status);
2826: WSH_DEBUG_SV.log(l_module_name,'Number of records finally being sent to GC3 is',x_loc_xmission_rec.LOCATIONS_TBL.count);
2827: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2828: END IF;
2829: --

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

2822: -- Debug Statements
2823: --
2824: IF l_debug_on THEN
2825: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling EXTRACT_LOCATION_INFO is', l_return_status);
2826: WSH_DEBUG_SV.log(l_module_name,'Number of records finally being sent to GC3 is',x_loc_xmission_rec.LOCATIONS_TBL.count);
2827: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2828: END IF;
2829: --
2830: wsh_util_core.api_post_call(

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

2823: --
2824: IF l_debug_on THEN
2825: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling EXTRACT_LOCATION_INFO is', l_return_status);
2826: WSH_DEBUG_SV.log(l_module_name,'Number of records finally being sent to GC3 is',x_loc_xmission_rec.LOCATIONS_TBL.count);
2827: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2828: END IF;
2829: --
2830: wsh_util_core.api_post_call(
2831: p_return_status => l_return_status,

Line 2864: WSH_DEBUG_SV.pop(l_module_name);

2860: --
2861: -- Debug Statements
2862: --
2863: IF l_debug_on THEN
2864: WSH_DEBUG_SV.pop(l_module_name);
2865: END IF;
2866: --
2867: --}
2868: EXCEPTION

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

2882:
2883: x_msg_data := x_msg_data || l_summary || ' ' || l_details;
2884:
2885: IF l_debug_on THEN
2886: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2887: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2888: END IF;
2889: --
2890: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2883: x_msg_data := x_msg_data || l_summary || ' ' || l_details;
2884:
2885: IF l_debug_on THEN
2886: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2887: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2888: END IF;
2889: --
2890: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2891: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

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

2903: --
2904: -- Debug Statements
2905: --
2906: IF l_debug_on THEN
2907: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2908: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2909: END IF;
2910: --
2911: WHEN OTHERS THEN

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

2904: -- Debug Statements
2905: --
2906: IF l_debug_on THEN
2907: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2908: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2909: END IF;
2910: --
2911: WHEN OTHERS THEN
2912: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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

2924: --
2925: -- Debug Statements
2926: --
2927: IF l_debug_on THEN
2928: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2929: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2930: END IF;
2931: --
2932: --}

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

2925: -- Debug Statements
2926: --
2927: IF l_debug_on THEN
2928: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2929: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2930: END IF;
2931: --
2932: --}
2933: END SEND_LOCATIONS;

Line 2966: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

2962: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2963: --
2964: IF l_debug_on IS NULL
2965: THEN
2966: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2967: END IF;
2968: --
2969: --
2970: -- Debug Statements

Line 2973: WSH_DEBUG_SV.push(l_module_name);

2969: --
2970: -- Debug Statements
2971: --
2972: IF l_debug_on THEN
2973: WSH_DEBUG_SV.push(l_module_name);
2974: --
2975: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
2976: END IF;
2977: --

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

2971: --
2972: IF l_debug_on THEN
2973: WSH_DEBUG_SV.push(l_module_name);
2974: --
2975: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
2976: END IF;
2977: --
2978: FOR l_stop_loc_rec in l_get_stop_loc_csr LOOP
2979: --{

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

2984: ELSE
2985: l_corp_type := 'CUS';
2986: END IF;
2987: IF l_debug_on THEN
2988: WSH_DEBUG_SV.log(l_module_name,'location type',l_stop_loc_rec.loc_type);
2989: WSH_DEBUG_SV.log(l_module_name,'location id',l_stop_loc_rec.location_id);
2990: WSH_DEBUG_SV.log(l_module_name,'corporation id',l_corporation_id);
2991: END IF;
2992: --}

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

2985: l_corp_type := 'CUS';
2986: END IF;
2987: IF l_debug_on THEN
2988: WSH_DEBUG_SV.log(l_module_name,'location type',l_stop_loc_rec.loc_type);
2989: WSH_DEBUG_SV.log(l_module_name,'location id',l_stop_loc_rec.location_id);
2990: WSH_DEBUG_SV.log(l_module_name,'corporation id',l_corporation_id);
2991: END IF;
2992: --}
2993: END LOOP;

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

2986: END IF;
2987: IF l_debug_on THEN
2988: WSH_DEBUG_SV.log(l_module_name,'location type',l_stop_loc_rec.loc_type);
2989: WSH_DEBUG_SV.log(l_module_name,'location id',l_stop_loc_rec.location_id);
2990: WSH_DEBUG_SV.log(l_module_name,'corporation id',l_corporation_id);
2991: END IF;
2992: --}
2993: END LOOP;
2994:

Line 3004: WSH_DEBUG_SV.pop(l_module_name);

3000: --
3001: -- Debug Statements
3002: --
3003: IF l_debug_on THEN
3004: WSH_DEBUG_SV.pop(l_module_name);
3005: --
3006: END IF;
3007: return l_location_xid;
3008: --

Line 3044: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

3040: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
3041: --
3042: IF l_debug_on IS NULL
3043: THEN
3044: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3045: END IF;
3046: --
3047: --
3048: -- Debug Statements

Line 3051: WSH_DEBUG_SV.push(l_module_name);

3047: --
3048: -- Debug Statements
3049: --
3050: IF l_debug_on THEN
3051: WSH_DEBUG_SV.push(l_module_name);
3052: --
3053: WSH_DEBUG_SV.log(l_module_name,'p_operation',p_operation);
3054: WSH_DEBUG_SV.log(l_module_name,'p_argument',p_argument);
3055: WSH_DEBUG_SV.log(l_module_name,'p_ticket',p_ticket);

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

3049: --
3050: IF l_debug_on THEN
3051: WSH_DEBUG_SV.push(l_module_name);
3052: --
3053: WSH_DEBUG_SV.log(l_module_name,'p_operation',p_operation);
3054: WSH_DEBUG_SV.log(l_module_name,'p_argument',p_argument);
3055: WSH_DEBUG_SV.log(l_module_name,'p_ticket',p_ticket);
3056: END IF;
3057: --

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

3050: IF l_debug_on THEN
3051: WSH_DEBUG_SV.push(l_module_name);
3052: --
3053: WSH_DEBUG_SV.log(l_module_name,'p_operation',p_operation);
3054: WSH_DEBUG_SV.log(l_module_name,'p_argument',p_argument);
3055: WSH_DEBUG_SV.log(l_module_name,'p_ticket',p_ticket);
3056: END IF;
3057: --
3058: x_tkt_valid := 'F';

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

3051: WSH_DEBUG_SV.push(l_module_name);
3052: --
3053: WSH_DEBUG_SV.log(l_module_name,'p_operation',p_operation);
3054: WSH_DEBUG_SV.log(l_module_name,'p_argument',p_argument);
3055: WSH_DEBUG_SV.log(l_module_name,'p_ticket',p_ticket);
3056: END IF;
3057: --
3058: x_tkt_valid := 'F';
3059: x_return_status := wsh_util_core.G_RET_STS_SUCCESS;

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

3058: x_tkt_valid := 'F';
3059: x_return_status := wsh_util_core.G_RET_STS_SUCCESS;
3060:
3061: IF l_debug_on THEN
3062: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FND_HTTP_TICKET.CHECK_TICKET',WSH_DEBUG_SV.C_PROC_LEVEL);
3063: END IF;
3064:
3065: l_is_tkt_valid := FND_HTTP_TICKET.CHECK_TICKET
3066: (

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

3069: p_argument => l_argument
3070: );
3071:
3072: IF l_debug_on THEN
3073: WSH_DEBUG_SV.log(l_module_name,'l_operation',l_operation);
3074: WSH_DEBUG_SV.log(l_module_name,'l_argument',l_argument);
3075: END IF;
3076: IF (
3077: l_is_tkt_valid

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

3070: );
3071:
3072: IF l_debug_on THEN
3073: WSH_DEBUG_SV.log(l_module_name,'l_operation',l_operation);
3074: WSH_DEBUG_SV.log(l_module_name,'l_argument',l_argument);
3075: END IF;
3076: IF (
3077: l_is_tkt_valid
3078: and l_operation = p_operation

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

3079: and l_argument = p_argument
3080: ) THEN
3081: --{
3082: IF l_debug_on THEN
3083: WSH_DEBUG_SV.logmsg(l_module_name,'Tkt is valid');
3084: END IF;
3085: x_tkt_valid := 'T';
3086: --}
3087: ELSE

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

3086: --}
3087: ELSE
3088: --{
3089: IF l_debug_on THEN
3090: WSH_DEBUG_SV.logmsg(l_module_name,'Tkt is invalid');
3091: END IF;
3092: x_tkt_valid := 'F';
3093: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_INVALID_TKT');
3094: FND_MESSAGE.SET_TOKEN('TICKET',p_ticket);

Line 3103: WSH_DEBUG_SV.pop(l_module_name);

3099: --
3100: -- Debug Statements
3101: --
3102: IF l_debug_on THEN
3103: WSH_DEBUG_SV.pop(l_module_name);
3104: --
3105: END IF;
3106: --}
3107: EXCEPTION

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

3115: --
3116: -- Debug Statements
3117: --
3118: IF l_debug_on THEN
3119: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3120: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3121: END IF;
3122: --
3123: --}

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

3116: -- Debug Statements
3117: --
3118: IF l_debug_on THEN
3119: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3120: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3121: END IF;
3122: --
3123: --}
3124: END VALIDATE_TKT;

Line 3159: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

3155: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
3156: --
3157: IF l_debug_on IS NULL
3158: THEN
3159: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3160: END IF;
3161: --
3162: --
3163: -- Debug Statements

Line 3166: WSH_DEBUG_SV.push(l_module_name);

3162: --
3163: -- Debug Statements
3164: --
3165: IF l_debug_on THEN
3166: WSH_DEBUG_SV.push(l_module_name);
3167: --
3168: WSH_DEBUG_SV.log(l_module_name,'p_location_id',p_location_id);
3169: END IF;
3170: --

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

3164: --
3165: IF l_debug_on THEN
3166: WSH_DEBUG_SV.push(l_module_name);
3167: --
3168: WSH_DEBUG_SV.log(l_module_name,'p_location_id',p_location_id);
3169: END IF;
3170: --
3171: x_return_status := wsh_util_core.g_ret_sts_success;
3172: --

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

3177: --
3178: -- Debug Statements
3179: --
3180: IF l_debug_on THEN
3181: WSH_DEBUG_SV.log(l_module_name,'l_return_status after calling Convert_internal_cust_location',l_return_status);
3182: WSH_DEBUG_SV.log(l_module_name,'l_int_location_id',l_int_location_id);
3183: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
3184: END IF;
3185: --

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

3178: -- Debug Statements
3179: --
3180: IF l_debug_on THEN
3181: WSH_DEBUG_SV.log(l_module_name,'l_return_status after calling Convert_internal_cust_location',l_return_status);
3182: WSH_DEBUG_SV.log(l_module_name,'l_int_location_id',l_int_location_id);
3183: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
3184: END IF;
3185: --
3186: wsh_util_core.api_post_call(

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

3179: --
3180: IF l_debug_on THEN
3181: WSH_DEBUG_SV.log(l_module_name,'l_return_status after calling Convert_internal_cust_location',l_return_status);
3182: WSH_DEBUG_SV.log(l_module_name,'l_int_location_id',l_int_location_id);
3183: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
3184: END IF;
3185: --
3186: wsh_util_core.api_post_call(
3187: p_return_status => l_return_status,

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

3195: fetch l_loc_to_org_csr into l_corporation_id;
3196: close l_loc_to_org_csr;
3197: --
3198: IF l_debug_on THEN
3199: WSH_DEBUG_SV.log(l_module_name,'l_corporation_id',l_corporation_id);
3200: END IF;
3201: --
3202: IF (l_corporation_id is null) THEN
3203: l_location_xid := l_corp_type || '-000-' || l_int_location_id;

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

3211: --
3212: -- Debug Statements
3213: --
3214: IF l_debug_on THEN
3215: WSH_DEBUG_SV.log(l_module_name,'x_location_xid',x_location_xid);
3216: WSH_DEBUG_SV.pop(l_module_name);
3217: --
3218: END IF;
3219: --

Line 3216: WSH_DEBUG_SV.pop(l_module_name);

3212: -- Debug Statements
3213: --
3214: IF l_debug_on THEN
3215: WSH_DEBUG_SV.log(l_module_name,'x_location_xid',x_location_xid);
3216: WSH_DEBUG_SV.pop(l_module_name);
3217: --
3218: END IF;
3219: --
3220: --}

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

3225: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3226: --
3227:
3228: IF l_debug_on THEN
3229: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3230: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3231: END IF;
3232: --
3233: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

3226: --
3227:
3228: IF l_debug_on THEN
3229: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3230: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3231: END IF;
3232: --
3233: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3234: --

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

3236: --
3237: -- Debug Statements
3238: --
3239: IF l_debug_on THEN
3240: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3241: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3242: END IF;
3243: --
3244: WHEN OTHERS THEN

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

3237: -- Debug Statements
3238: --
3239: IF l_debug_on THEN
3240: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3241: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3242: END IF;
3243: --
3244: WHEN OTHERS THEN
3245: --

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

3247: --
3248: -- Debug Statements
3249: --
3250: IF l_debug_on THEN
3251: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3252: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3253: END IF;
3254: --
3255: --}

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

3248: -- Debug Statements
3249: --
3250: IF l_debug_on THEN
3251: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3252: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3253: END IF;
3254: --
3255: --}
3256: END GET_INT_LOCATION_XID;