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.FTE_PROCESS_REQUESTS dependencies on WSH_DEBUG_SV

Line 39: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;

35: cust_site_id NUMBER;
36: no_ship_to_site EXCEPTION;
37: mult_ship_to_site EXCEPTION;
38:
39: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
40: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'GET_CUSTOMER_SITE';
41:
42: BEGIN
43: --

Line 47: wsh_debug_sv.push (l_module_name);

43: --
44: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
45: --
46: IF l_debug_on THEN
47: wsh_debug_sv.push (l_module_name);
48: END IF;
49: --
50: cust_site_id := -1;
51:

Line 81: wsh_debug_sv.pop(l_module_name);

77: x_customer_site_id := cust_site_id;
78: END IF;
79: --
80: IF l_debug_on THEN
81: wsh_debug_sv.pop(l_module_name);
82: END IF;
83: --
84:
85: EXCEPTION

Line 92: WSH_DEBUG_SV.pop(l_module_name);

88: FND_MESSAGE.SET_NAME('WSH','WSH_PDLVY_NO_SITE');
89: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
90: WSH_UTIL_CORE.add_message(x_return_status);
91: IF l_debug_on THEN
92: WSH_DEBUG_SV.pop(l_module_name);
93: END IF;
94: WHEN MULT_SHIP_TO_SITE THEN
95: -- Delivery is associated with multiple sites
96: FND_MESSAGE.SET_NAME('WSH','WSH_PDLVY_MULT_SITE');

Line 100: WSH_DEBUG_SV.pop(l_module_name);

96: FND_MESSAGE.SET_NAME('WSH','WSH_PDLVY_MULT_SITE');
97: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
98: WSH_UTIL_CORE.add_message(x_return_status);
99: IF l_debug_on THEN
100: WSH_DEBUG_SV.pop(l_module_name);
101: END IF;
102:
103: WHEN OTHERS THEN
104: WSH_UTIL_CORE.default_handler('FTE_PROCESS_REQUEST.get_customer_site');

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

103: WHEN OTHERS THEN
104: WSH_UTIL_CORE.default_handler('FTE_PROCESS_REQUEST.get_customer_site');
105: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
106: IF l_debug_on THEN
107: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
108: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
109: END IF;
110: END get_customer_site;
111:

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

104: WSH_UTIL_CORE.default_handler('FTE_PROCESS_REQUEST.get_customer_site');
105: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
106: IF l_debug_on THEN
107: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
108: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
109: END IF;
110: END get_customer_site;
111:
112: -- -------------------------------------------------------------------------- --

Line 156: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;

152: l_cust_tab WSH_UTIL_CORE.ID_TAB_TYPE;
153: no_cust_for_loc EXCEPTION;
154: mult_cust_for_loc EXCEPTION;
155:
156: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
157: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'GET_SHIP_TO_CUSTOMER';
158:
159: BEGIN
160: --

Line 164: wsh_debug_sv.push (l_module_name);

160: --
161: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
162: --
163: IF l_debug_on THEN
164: wsh_debug_sv.push (l_module_name);
165: END IF;
166: --
167: OPEN c_get_shipto_cust_from_loc(p_dropoff_loc_id);
168: FETCH c_get_shipto_cust_from_loc BULK COLLECT INTO l_cust_tab;

Line 190: WSH_DEBUG_SV.pop(l_module_name);

186: END IF;
187: END IF;
188: --
189: IF l_debug_on THEN
190: WSH_DEBUG_SV.pop(l_module_name);
191: END IF;
192: --
193: EXCEPTION
194: WHEN NO_CUST_FOR_LOC THEN

Line 200: WSH_DEBUG_SV.pop(l_module_name);

196: FND_MESSAGE.SET_NAME('WSH','WSH_CUST_NO_LOC');
197: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
198: WSH_UTIL_CORE.add_message(x_return_status);
199: IF l_debug_on THEN
200: WSH_DEBUG_SV.pop(l_module_name);
201: END IF;
202:
203: WHEN MULT_CUST_FOR_LOC THEN
204: -- Location associated with a multiple customers.

Line 209: WSH_DEBUG_SV.pop(l_module_name);

205: FND_MESSAGE.SET_NAME('WSH','WSH_CUST_MULT_LOC');
206: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
207: WSH_UTIL_CORE.add_message(x_return_status);
208: IF l_debug_on THEN
209: WSH_DEBUG_SV.pop(l_module_name);
210: END IF;
211:
212: WHEN OTHERS THEN
213: WSH_UTIL_CORE.default_handler('FTE_PROCESS_REQUEST.get_ship_to_customer');

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

221: CLOSE c_get_shipto_cust_from_site;
222: END IF;
223:
224: IF l_debug_on THEN
225: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
226: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
227: END IF;
228: END get_ship_to_customer;
229:

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

222: END IF;
223:
224: IF l_debug_on THEN
225: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
226: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
227: END IF;
228: END get_ship_to_customer;
229:
230: -- -------------------------------------------------------------------------- --

Line 303: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

299: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
300: --
301: IF l_debug_on IS NULL
302: THEN
303: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
304: END IF;
305: --
306: --
307: -- Debug Statements

Line 310: WSH_DEBUG_SV.push(l_module_name);

306: --
307: -- Debug Statements
308: --
309: IF l_debug_on THEN
310: WSH_DEBUG_SV.push(l_module_name);
311: END IF;
312: --
313: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
314: x_return_message := null;

Line 393: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_ACS_PKG.START_ACS',WSH_DEBUG_SV.C_PROC_LEVEL);

389: --
390: -- Debug Statements
391: --
392: IF l_debug_on THEN
393: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_ACS_PKG.START_ACS',WSH_DEBUG_SV.C_PROC_LEVEL);
394: END IF;
395: --
396:
397: FTE_ACS_PKG.GET_ROUTING_RESULTS( p_format_cs_tab => l_cs_input_tab,

Line 430: WSH_DEBUG_SV.pop(l_module_name);

426: --
427: -- Debug Statements
428: --
429: IF l_debug_on THEN
430: WSH_DEBUG_SV.pop(l_module_name);
431: END IF;
432: --
433:
434: EXCEPTION

Line 442: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM FTE_PROCESS_REQUESTS.FORMAT_CS_CALL IS ' ||L_ERROR_TEXT );

438: --
439: -- Debug Statements
440: --
441: IF l_debug_on THEN
442: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM FTE_PROCESS_REQUESTS.FORMAT_CS_CALL IS ' ||L_ERROR_TEXT );
443: END IF;
444: --
445:
446: WSH_UTIL_CORE.default_handler('FTE_PROCESS_REQUESTS.FORMAT_CS_CALL');

Line 453: WSH_DEBUG_SV.pop(l_module_name);

449: --
450: -- Debug Statements
451: --
452: IF l_debug_on THEN
453: WSH_DEBUG_SV.pop(l_module_name);
454: END IF;
455: --
456:
457: --

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

457: --
458: -- Debug Statements
459: --
460: IF l_debug_on THEN
461: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
462: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
463: END IF;
464: --
465: END FORMAT_CS_CALL;

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

458: -- Debug Statements
459: --
460: IF l_debug_on THEN
461: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
462: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
463: END IF;
464: --
465: END FORMAT_CS_CALL;
466:

Line 631: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

627: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
628: --
629: IF l_debug_on IS NULL
630: THEN
631: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
632: END IF;
633: --
634: --
635: -- Debug Statements

Line 638: WSH_DEBUG_SV.push(l_module_name);

634: --
635: -- Debug Statements
636: --
637: IF l_debug_on THEN
638: WSH_DEBUG_SV.push(l_module_name);
639: --
640: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_TYPE',P_SOURCE_TYPE);
641: WSH_DEBUG_SV.log(l_module_name,'P_ACTION',P_ACTION);
642: END IF;

Line 640: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_TYPE',P_SOURCE_TYPE);

636: --
637: IF l_debug_on THEN
638: WSH_DEBUG_SV.push(l_module_name);
639: --
640: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_TYPE',P_SOURCE_TYPE);
641: WSH_DEBUG_SV.log(l_module_name,'P_ACTION',P_ACTION);
642: END IF;
643: --
644: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 641: WSH_DEBUG_SV.log(l_module_name,'P_ACTION',P_ACTION);

637: IF l_debug_on THEN
638: WSH_DEBUG_SV.push(l_module_name);
639: --
640: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_TYPE',P_SOURCE_TYPE);
641: WSH_DEBUG_SV.log(l_module_name,'P_ACTION',P_ACTION);
642: END IF;
643: --
644: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
645:

Line 671: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR returned ' || x_msg_data);

667: --
668: -- Debug Statements
669: --
670: IF l_debug_on THEN
671: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR returned ' || x_msg_data);
672: WSH_DEBUG_SV.pop(l_module_name);
673: END IF;
674: --
675: RETURN;

Line 672: WSH_DEBUG_SV.pop(l_module_name);

668: -- Debug Statements
669: --
670: IF l_debug_on THEN
671: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR returned ' || x_msg_data);
672: WSH_DEBUG_SV.pop(l_module_name);
673: END IF;
674: --
675: RETURN;
676: END IF;

Line 693: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR returned ' || x_msg_data);

689: --
690: -- Debug Statements
691: --
692: IF l_debug_on THEN
693: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR returned ' || x_msg_data);
694: WSH_DEBUG_SV.pop(l_module_name);
695: END IF;
696: --
697: RETURN;

Line 694: WSH_DEBUG_SV.pop(l_module_name);

690: -- Debug Statements
691: --
692: IF l_debug_on THEN
693: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR returned ' || x_msg_data);
694: WSH_DEBUG_SV.pop(l_module_name);
695: END IF;
696: --
697: RETURN;
698:

Line 704: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_FREIGHT_RATING_PUB.GET_FREIGHT_COSTS',WSH_DEBUG_SV.C_PROC_LEVEL);

700:
701: IF (l_otm_installed = 'N') THEN
702:
703: IF l_debug_on THEN
704: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_FREIGHT_RATING_PUB.GET_FREIGHT_COSTS',WSH_DEBUG_SV.C_PROC_LEVEL);
705: END IF;
706: FTE_FREIGHT_RATING_PUB.Get_Freight_Costs(p_api_version => 1,
707: p_source_line_tab => p_source_line_tab,
708: p_source_header_tab => p_source_header_tab,

Line 719: WSH_DEBUG_SV.logmsg(l_module_name,'currency for choose ship method is '||p_source_header_tab(p_source_header_tab.FIRST).currency);

715: x_msg_count => l_msg_count,
716: x_msg_data => l_msg_data);
717: ELSE
718: IF l_debug_on THEN
719: WSH_DEBUG_SV.logmsg(l_module_name,'currency for choose ship method is '||p_source_header_tab(p_source_header_tab.FIRST).currency);
720: END IF;
721: WSH_OTM_RIQ_XML.CALL_OTM_FOR_OM(
722: x_source_line_tab => p_source_line_tab,
723: x_source_header_tab => p_source_header_tab,

Line 760: WSH_DEBUG_SV.logmsg(l_module_name,'p_source_header_tab.COUNT = 0');

756: --
757: -- Debug Statements
758: --
759: IF l_debug_on THEN
760: WSH_DEBUG_SV.logmsg(l_module_name,'p_source_header_tab.COUNT = 0');
761: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_SOURCE_LINE_CONSOLIDATION.CONSOLIDATE_LINES',WSH_DEBUG_SV.C_PROC_LEVEL);
762: END IF;
763: --
764: FTE_SOURCE_LINE_CONSOLIDATION.Consolidate_Lines(p_source_line_tab,

Line 761: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_SOURCE_LINE_CONSOLIDATION.CONSOLIDATE_LINES',WSH_DEBUG_SV.C_PROC_LEVEL);

757: -- Debug Statements
758: --
759: IF l_debug_on THEN
760: WSH_DEBUG_SV.logmsg(l_module_name,'p_source_header_tab.COUNT = 0');
761: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_SOURCE_LINE_CONSOLIDATION.CONSOLIDATE_LINES',WSH_DEBUG_SV.C_PROC_LEVEL);
762: END IF;
763: --
764: FTE_SOURCE_LINE_CONSOLIDATION.Consolidate_Lines(p_source_line_tab,
765: p_source_header_tab,

Line 775: WSH_DEBUG_SV.logmsg(l_module_name,'-------- Consolidations -----------');

771: --
772: -- Debug Statements
773: --
774: IF l_debug_on THEN
775: WSH_DEBUG_SV.logmsg(l_module_name,'-------- Consolidations -----------');
776: IF (p_source_header_tab.COUNT > 0) THEN
777: FOR zz IN p_source_header_tab.FIRST..p_source_header_tab.LAST LOOP
778: WSH_DEBUG_SV.logmsg(l_module_name,'*********************************');
779: WSH_DEBUG_SV.log(l_module_name, 'consolidation_id', p_source_header_tab(zz).consolidation_id);

Line 778: WSH_DEBUG_SV.logmsg(l_module_name,'*********************************');

774: IF l_debug_on THEN
775: WSH_DEBUG_SV.logmsg(l_module_name,'-------- Consolidations -----------');
776: IF (p_source_header_tab.COUNT > 0) THEN
777: FOR zz IN p_source_header_tab.FIRST..p_source_header_tab.LAST LOOP
778: WSH_DEBUG_SV.logmsg(l_module_name,'*********************************');
779: WSH_DEBUG_SV.log(l_module_name, 'consolidation_id', p_source_header_tab(zz).consolidation_id);
780: WSH_DEBUG_SV.log(l_module_name, 'total_weight', p_source_header_tab(zz).total_weight);
781: WSH_DEBUG_SV.log(l_module_name, 'weight_uom_code', p_source_header_tab(zz).weight_uom_code);
782: WSH_DEBUG_SV.log(l_module_name, 'total_volume', p_source_header_tab(zz).total_volume);

Line 779: WSH_DEBUG_SV.log(l_module_name, 'consolidation_id', p_source_header_tab(zz).consolidation_id);

775: WSH_DEBUG_SV.logmsg(l_module_name,'-------- Consolidations -----------');
776: IF (p_source_header_tab.COUNT > 0) THEN
777: FOR zz IN p_source_header_tab.FIRST..p_source_header_tab.LAST LOOP
778: WSH_DEBUG_SV.logmsg(l_module_name,'*********************************');
779: WSH_DEBUG_SV.log(l_module_name, 'consolidation_id', p_source_header_tab(zz).consolidation_id);
780: WSH_DEBUG_SV.log(l_module_name, 'total_weight', p_source_header_tab(zz).total_weight);
781: WSH_DEBUG_SV.log(l_module_name, 'weight_uom_code', p_source_header_tab(zz).weight_uom_code);
782: WSH_DEBUG_SV.log(l_module_name, 'total_volume', p_source_header_tab(zz).total_volume);
783: WSH_DEBUG_SV.log(l_module_name, 'volume_uom_code', p_source_header_tab(zz).volume_uom_code);

Line 780: WSH_DEBUG_SV.log(l_module_name, 'total_weight', p_source_header_tab(zz).total_weight);

776: IF (p_source_header_tab.COUNT > 0) THEN
777: FOR zz IN p_source_header_tab.FIRST..p_source_header_tab.LAST LOOP
778: WSH_DEBUG_SV.logmsg(l_module_name,'*********************************');
779: WSH_DEBUG_SV.log(l_module_name, 'consolidation_id', p_source_header_tab(zz).consolidation_id);
780: WSH_DEBUG_SV.log(l_module_name, 'total_weight', p_source_header_tab(zz).total_weight);
781: WSH_DEBUG_SV.log(l_module_name, 'weight_uom_code', p_source_header_tab(zz).weight_uom_code);
782: WSH_DEBUG_SV.log(l_module_name, 'total_volume', p_source_header_tab(zz).total_volume);
783: WSH_DEBUG_SV.log(l_module_name, 'volume_uom_code', p_source_header_tab(zz).volume_uom_code);
784: END LOOP;

Line 781: WSH_DEBUG_SV.log(l_module_name, 'weight_uom_code', p_source_header_tab(zz).weight_uom_code);

777: FOR zz IN p_source_header_tab.FIRST..p_source_header_tab.LAST LOOP
778: WSH_DEBUG_SV.logmsg(l_module_name,'*********************************');
779: WSH_DEBUG_SV.log(l_module_name, 'consolidation_id', p_source_header_tab(zz).consolidation_id);
780: WSH_DEBUG_SV.log(l_module_name, 'total_weight', p_source_header_tab(zz).total_weight);
781: WSH_DEBUG_SV.log(l_module_name, 'weight_uom_code', p_source_header_tab(zz).weight_uom_code);
782: WSH_DEBUG_SV.log(l_module_name, 'total_volume', p_source_header_tab(zz).total_volume);
783: WSH_DEBUG_SV.log(l_module_name, 'volume_uom_code', p_source_header_tab(zz).volume_uom_code);
784: END LOOP;
785: ELSE

Line 782: WSH_DEBUG_SV.log(l_module_name, 'total_volume', p_source_header_tab(zz).total_volume);

778: WSH_DEBUG_SV.logmsg(l_module_name,'*********************************');
779: WSH_DEBUG_SV.log(l_module_name, 'consolidation_id', p_source_header_tab(zz).consolidation_id);
780: WSH_DEBUG_SV.log(l_module_name, 'total_weight', p_source_header_tab(zz).total_weight);
781: WSH_DEBUG_SV.log(l_module_name, 'weight_uom_code', p_source_header_tab(zz).weight_uom_code);
782: WSH_DEBUG_SV.log(l_module_name, 'total_volume', p_source_header_tab(zz).total_volume);
783: WSH_DEBUG_SV.log(l_module_name, 'volume_uom_code', p_source_header_tab(zz).volume_uom_code);
784: END LOOP;
785: ELSE
786: WSH_DEBUG_SV.logmsg(l_module_name, 'FTE_SOURCE_LINE_CONSOLIDATION.Consolidate_Lines resulted in no consolidations');

Line 783: WSH_DEBUG_SV.log(l_module_name, 'volume_uom_code', p_source_header_tab(zz).volume_uom_code);

779: WSH_DEBUG_SV.log(l_module_name, 'consolidation_id', p_source_header_tab(zz).consolidation_id);
780: WSH_DEBUG_SV.log(l_module_name, 'total_weight', p_source_header_tab(zz).total_weight);
781: WSH_DEBUG_SV.log(l_module_name, 'weight_uom_code', p_source_header_tab(zz).weight_uom_code);
782: WSH_DEBUG_SV.log(l_module_name, 'total_volume', p_source_header_tab(zz).total_volume);
783: WSH_DEBUG_SV.log(l_module_name, 'volume_uom_code', p_source_header_tab(zz).volume_uom_code);
784: END LOOP;
785: ELSE
786: WSH_DEBUG_SV.logmsg(l_module_name, 'FTE_SOURCE_LINE_CONSOLIDATION.Consolidate_Lines resulted in no consolidations');
787: END IF;

Line 786: WSH_DEBUG_SV.logmsg(l_module_name, 'FTE_SOURCE_LINE_CONSOLIDATION.Consolidate_Lines resulted in no consolidations');

782: WSH_DEBUG_SV.log(l_module_name, 'total_volume', p_source_header_tab(zz).total_volume);
783: WSH_DEBUG_SV.log(l_module_name, 'volume_uom_code', p_source_header_tab(zz).volume_uom_code);
784: END LOOP;
785: ELSE
786: WSH_DEBUG_SV.logmsg(l_module_name, 'FTE_SOURCE_LINE_CONSOLIDATION.Consolidate_Lines resulted in no consolidations');
787: END IF;
788: WSH_DEBUG_SV.logmsg(l_module_name,'-------- End Consolidations -----------');
789: END IF;
790: END IF;

Line 788: WSH_DEBUG_SV.logmsg(l_module_name,'-------- End Consolidations -----------');

784: END LOOP;
785: ELSE
786: WSH_DEBUG_SV.logmsg(l_module_name, 'FTE_SOURCE_LINE_CONSOLIDATION.Consolidate_Lines resulted in no consolidations');
787: END IF;
788: WSH_DEBUG_SV.logmsg(l_module_name,'-------- End Consolidations -----------');
789: END IF;
790: END IF;
791:
792: IF (p_source_header_tab.COUNT = 0 OR

Line 805: WSH_DEBUG_SV.pop(l_module_name);

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

Line 848: WSH_DEBUG_SV.log(l_module_name,'x_return_status from call_otm', l_status);

844: x_msg_count => l_msg_count,
845: x_msg_data => l_msg_data);
846:
847: IF l_debug_on THEN
848: WSH_DEBUG_SV.log(l_module_name,'x_return_status from call_otm', l_status);
849: WSH_DEBUG_SV.log(l_module_name,'x_msg_count from call_otm', l_msg_count);
850: WSH_DEBUG_SV.log(l_module_name,'x_msg_data from call_otm', l_msg_data);
851: END IF;
852:

Line 849: WSH_DEBUG_SV.log(l_module_name,'x_msg_count from call_otm', l_msg_count);

845: x_msg_data => l_msg_data);
846:
847: IF l_debug_on THEN
848: WSH_DEBUG_SV.log(l_module_name,'x_return_status from call_otm', l_status);
849: WSH_DEBUG_SV.log(l_module_name,'x_msg_count from call_otm', l_msg_count);
850: WSH_DEBUG_SV.log(l_module_name,'x_msg_data from call_otm', l_msg_data);
851: END IF;
852:
853: /* R12 Glog Integration

Line 850: WSH_DEBUG_SV.log(l_module_name,'x_msg_data from call_otm', l_msg_data);

846:
847: IF l_debug_on THEN
848: WSH_DEBUG_SV.log(l_module_name,'x_return_status from call_otm', l_status);
849: WSH_DEBUG_SV.log(l_module_name,'x_msg_count from call_otm', l_msg_count);
850: WSH_DEBUG_SV.log(l_module_name,'x_msg_data from call_otm', l_msg_data);
851: END IF;
852:
853: /* R12 Glog Integration
854: format_cs_call's signature is changed in R12 to return

Line 876: WSH_DEBUG_SV.log(l_module_name,'l_result_tab.count',l_result_tab.count);

872: */
873:
874: IF (l_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
875: IF l_debug_on THEN
876: WSH_DEBUG_SV.log(l_module_name,'l_result_tab.count',l_result_tab.count);
877: WSH_DEBUG_SV.log(l_module_name,'l_result_consolidation_id_tab.count',l_result_consolidation_id_tab.count);
878: END IF;
879:
880: FOR i IN l_result_consolidation_id_tab.FIRST..l_result_consolidation_id_tab.LAST LOOP

Line 877: WSH_DEBUG_SV.log(l_module_name,'l_result_consolidation_id_tab.count',l_result_consolidation_id_tab.count);

873:
874: IF (l_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
875: IF l_debug_on THEN
876: WSH_DEBUG_SV.log(l_module_name,'l_result_tab.count',l_result_tab.count);
877: WSH_DEBUG_SV.log(l_module_name,'l_result_consolidation_id_tab.count',l_result_consolidation_id_tab.count);
878: END IF;
879:
880: FOR i IN l_result_consolidation_id_tab.FIRST..l_result_consolidation_id_tab.LAST LOOP
881: l_result_tab(i).delivery_id := l_result_consolidation_id_tab(i);

Line 893: WSH_DEBUG_SV.log(l_module_name,'l_result_tab.count',l_result_tab.count);

889: l_result_tab(i).result_type := 'RANK'; -- need to be populated
890: END LOOP;
891:
892: IF l_debug_on THEN
893: WSH_DEBUG_SV.log(l_module_name,'l_result_tab.count',l_result_tab.count);
894: FOR i IN l_result_tab.FIRST..l_result_tab.LAST LOOP
895: WSH_DEBUG_SV.log(l_module_name,'l_result_tab.delivery_id',l_result_tab(i).delivery_id);
896: END LOOP;
897: END IF;

Line 895: WSH_DEBUG_SV.log(l_module_name,'l_result_tab.delivery_id',l_result_tab(i).delivery_id);

891:
892: IF l_debug_on THEN
893: WSH_DEBUG_SV.log(l_module_name,'l_result_tab.count',l_result_tab.count);
894: FOR i IN l_result_tab.FIRST..l_result_tab.LAST LOOP
895: WSH_DEBUG_SV.log(l_module_name,'l_result_tab.delivery_id',l_result_tab(i).delivery_id);
896: END LOOP;
897: END IF;
898:
899: END IF;

Line 906: WSH_DEBUG_SV.logmsg(l_module_name, 'Populating CS results into consolidation table');

902:
903: IF (l_status is not null AND l_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
904:
905: IF l_debug_on THEN
906: WSH_DEBUG_SV.logmsg(l_module_name, 'Populating CS results into consolidation table');
907: END IF;
908:
909: -- populate the CS results into the consolidation table
910: FOR i IN p_source_header_tab.FIRST..p_source_header_tab.LAST LOOP

Line 934: WSH_DEBUG_SV.logmsg(l_module_name,'Multileg results returned');

930: -- p_source_header_tab(i).message_data := FND_MESSAGE.GET;
931: FND_MSG_PUB.ADD;
932:
933: IF l_debug_on THEN
934: WSH_DEBUG_SV.logmsg(l_module_name,'Multileg results returned');
935: END IF;
936:
937: --
938: -- Here we are looping over the output results table. The results are sorted by

Line 966: WSH_DEBUG_SV.logmsg(l_module_name, '----------------------------------------');

962: p_source_header_tab(i).freight_terms := l_result_tab(j).freight_terms_code;
963: END IF;
964:
965: IF l_debug_on THEN
966: WSH_DEBUG_SV.logmsg(l_module_name, '----------------------------------------');
967: WSH_DEBUG_SV.logmsg(l_module_name, 'Added ship method, carrier, service, mode, freight terms for consolidation_id = ' || p_source_header_tab(i).consolidation_id);
968: END IF;
969:
970: l_orig_delivery_time := p_source_header_tab(i).delivery_lead_time; -- save for later

Line 967: WSH_DEBUG_SV.logmsg(l_module_name, 'Added ship method, carrier, service, mode, freight terms for consolidation_id = ' || p_source_header_tab(i).consolidation_id);

963: END IF;
964:
965: IF l_debug_on THEN
966: WSH_DEBUG_SV.logmsg(l_module_name, '----------------------------------------');
967: WSH_DEBUG_SV.logmsg(l_module_name, 'Added ship method, carrier, service, mode, freight terms for consolidation_id = ' || p_source_header_tab(i).consolidation_id);
968: END IF;
969:
970: l_orig_delivery_time := p_source_header_tab(i).delivery_lead_time; -- save for later
971: -- l_cs_transit_min := l_result_transit_time_min_tab(j);

Line 994: -- WSH_DEBUG_SV.logmsg(l_module_name, 'Obtained rule name and lead times for consolidation_id = ' || p_source_header_tab(i).consolidation_id);

990: p_source_header_tab(i).delivery_lead_time := l_result_tab(j).max_transit_time;
991: END IF;
992:
993: -- IF l_debug_on THEN
994: -- WSH_DEBUG_SV.logmsg(l_module_name, 'Obtained rule name and lead times for consolidation_id = ' || p_source_header_tab(i).consolidation_id);
995: -- END IF;
996: --
997:
998: IF (p_source_header_tab(i).carrier_id is null) THEN

Line 1001: WSH_DEBUG_SV.logmsg(l_module_name, 'carrier_id is null');

997:
998: IF (p_source_header_tab(i).carrier_id is null) THEN
999:
1000: IF l_debug_on THEN
1001: WSH_DEBUG_SV.logmsg(l_module_name, 'carrier_id is null');
1002: END IF;
1003:
1004: -- check to see if generic carrier
1005: -- (as generic carriers can have just service level or mode)

Line 1037: WSH_DEBUG_SV.log(l_module_name, 'message_data', p_source_header_tab(i).message_data);

1033: p_source_header_tab(i).status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1034: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEL_NO_CS_RESULT');
1035: p_source_header_tab(i).message_data := FND_MESSAGE.GET;
1036: IF l_debug_on THEN
1037: WSH_DEBUG_SV.log(l_module_name, 'message_data', p_source_header_tab(i).message_data);
1038: END IF;
1039: END IF; -- no carrier servoce
1040: IF l_debug_on THEN
1041: WSH_DEBUG_SV.log(l_module_name, 'Gneric Ship Method Derived', p_source_header_tab(i).ship_method_code);

Line 1041: WSH_DEBUG_SV.log(l_module_name, 'Gneric Ship Method Derived', p_source_header_tab(i).ship_method_code);

1037: WSH_DEBUG_SV.log(l_module_name, 'message_data', p_source_header_tab(i).message_data);
1038: END IF;
1039: END IF; -- no carrier servoce
1040: IF l_debug_on THEN
1041: WSH_DEBUG_SV.log(l_module_name, 'Gneric Ship Method Derived', p_source_header_tab(i).ship_method_code);
1042: END IF;
1043:
1044: -- error: need to set up generic carrier
1045: IF (p_source_header_tab(i).ship_method_code is null) THEN

Line 1057: WSH_DEBUG_SV.log(l_module_name, 'message_data', p_source_header_tab(i).message_data);

1053: -- p_source_header_tab(i).message_data := FND_MESSAGE.GET;
1054: FND_MSG_PUB.ADD;
1055:
1056: IF l_debug_on THEN
1057: WSH_DEBUG_SV.log(l_module_name, 'message_data', p_source_header_tab(i).message_data);
1058: END IF;
1059: END IF;
1060:
1061:

Line 1070: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR result from CS, but no valid ship method assigned to org');

1066: p_source_header_tab(i).mode_of_transport is not null AND
1067: p_source_header_tab(i).ship_method_code is null) THEN
1068:
1069: IF l_debug_on THEN
1070: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR result from CS, but no valid ship method assigned to org');
1071: END IF;
1072:
1073: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1074: p_source_header_tab(i).status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 1091: WSH_DEBUG_SV.log(l_module_name, 'message_data', p_source_header_tab(i).message_data);

1087: -- p_source_header_tab(i).message_data := FND_MESSAGE.GET;
1088: FND_MSG_PUB.ADD;
1089:
1090: IF l_debug_on THEN
1091: WSH_DEBUG_SV.log(l_module_name, 'message_data', p_source_header_tab(i).message_data);
1092: END IF;
1093:
1094: -- have carrier, but not others, incomplete ship method setup
1095: ELSIF (p_source_header_tab(i).ship_method_code is null) THEN

Line 1098: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR incomplete ship method setup');

1094: -- have carrier, but not others, incomplete ship method setup
1095: ELSIF (p_source_header_tab(i).ship_method_code is null) THEN
1096:
1097: IF l_debug_on THEN
1098: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR incomplete ship method setup');
1099: END IF;
1100:
1101: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1102: p_source_header_tab(i).status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 1111: WSH_DEBUG_SV.log(l_module_name, 'message_data', p_source_header_tab(i).message_data);

1107: -- p_source_header_tab(i).message_data := FND_MESSAGE.GET;
1108: FND_MSG_PUB.ADD;
1109:
1110: IF l_debug_on THEN
1111: WSH_DEBUG_SV.log(l_module_name, 'message_data', p_source_header_tab(i).message_data);
1112: END IF;
1113: END IF; -- end checking for errors
1114:
1115: -- if have ship_method must mean have everything, continue

Line 1130: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit MSC_ATP_PROC.ATP_SHIPPING_LEAD_TIME',WSH_DEBUG_SV.C_PROC_LEVEL);

1126: --
1127: -- Debug Statements
1128: --
1129: IF l_debug_on THEN
1130: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit MSC_ATP_PROC.ATP_SHIPPING_LEAD_TIME',WSH_DEBUG_SV.C_PROC_LEVEL);
1131: WSH_DEBUG_SV.log(l_module_name,'session_id', l_session_id);
1132: WSH_DEBUG_SV.log(l_module_name,'ship_from_location_id', p_source_header_tab(i).ship_from_location_id);
1133: WSH_DEBUG_SV.log(l_module_name,'ship_to_site_id', p_source_header_tab(i).ship_to_site_id);
1134: WSH_DEBUG_SV.log(l_module_name,'original_ship_method', l_transit_ship_method);

Line 1131: WSH_DEBUG_SV.log(l_module_name,'session_id', l_session_id);

1127: -- Debug Statements
1128: --
1129: IF l_debug_on THEN
1130: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit MSC_ATP_PROC.ATP_SHIPPING_LEAD_TIME',WSH_DEBUG_SV.C_PROC_LEVEL);
1131: WSH_DEBUG_SV.log(l_module_name,'session_id', l_session_id);
1132: WSH_DEBUG_SV.log(l_module_name,'ship_from_location_id', p_source_header_tab(i).ship_from_location_id);
1133: WSH_DEBUG_SV.log(l_module_name,'ship_to_site_id', p_source_header_tab(i).ship_to_site_id);
1134: WSH_DEBUG_SV.log(l_module_name,'original_ship_method', l_transit_ship_method);
1135: END IF;

Line 1132: WSH_DEBUG_SV.log(l_module_name,'ship_from_location_id', p_source_header_tab(i).ship_from_location_id);

1128: --
1129: IF l_debug_on THEN
1130: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit MSC_ATP_PROC.ATP_SHIPPING_LEAD_TIME',WSH_DEBUG_SV.C_PROC_LEVEL);
1131: WSH_DEBUG_SV.log(l_module_name,'session_id', l_session_id);
1132: WSH_DEBUG_SV.log(l_module_name,'ship_from_location_id', p_source_header_tab(i).ship_from_location_id);
1133: WSH_DEBUG_SV.log(l_module_name,'ship_to_site_id', p_source_header_tab(i).ship_to_site_id);
1134: WSH_DEBUG_SV.log(l_module_name,'original_ship_method', l_transit_ship_method);
1135: END IF;
1136: --

Line 1133: WSH_DEBUG_SV.log(l_module_name,'ship_to_site_id', p_source_header_tab(i).ship_to_site_id);

1129: IF l_debug_on THEN
1130: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit MSC_ATP_PROC.ATP_SHIPPING_LEAD_TIME',WSH_DEBUG_SV.C_PROC_LEVEL);
1131: WSH_DEBUG_SV.log(l_module_name,'session_id', l_session_id);
1132: WSH_DEBUG_SV.log(l_module_name,'ship_from_location_id', p_source_header_tab(i).ship_from_location_id);
1133: WSH_DEBUG_SV.log(l_module_name,'ship_to_site_id', p_source_header_tab(i).ship_to_site_id);
1134: WSH_DEBUG_SV.log(l_module_name,'original_ship_method', l_transit_ship_method);
1135: END IF;
1136: --
1137: MSC_ATP_PROC.ATP_Shipping_Lead_Time(p_source_header_tab(i).ship_from_location_id,

Line 1134: WSH_DEBUG_SV.log(l_module_name,'original_ship_method', l_transit_ship_method);

1130: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit MSC_ATP_PROC.ATP_SHIPPING_LEAD_TIME',WSH_DEBUG_SV.C_PROC_LEVEL);
1131: WSH_DEBUG_SV.log(l_module_name,'session_id', l_session_id);
1132: WSH_DEBUG_SV.log(l_module_name,'ship_from_location_id', p_source_header_tab(i).ship_from_location_id);
1133: WSH_DEBUG_SV.log(l_module_name,'ship_to_site_id', p_source_header_tab(i).ship_to_site_id);
1134: WSH_DEBUG_SV.log(l_module_name,'original_ship_method', l_transit_ship_method);
1135: END IF;
1136: --
1137: MSC_ATP_PROC.ATP_Shipping_Lead_Time(p_source_header_tab(i).ship_from_location_id,
1138: p_source_header_tab(i).ship_to_site_id,

Line 1145: WSH_DEBUG_SV.logmsg(l_module_name, 'Results from MSC_ATP_PROC.ATP_SHIPPING_LEAD_TIME:');

1141: l_transit_time,
1142: l_transit_status);
1143:
1144: IF l_debug_on THEN
1145: WSH_DEBUG_SV.logmsg(l_module_name, 'Results from MSC_ATP_PROC.ATP_SHIPPING_LEAD_TIME:');
1146: WSH_DEBUG_SV.log(l_module_name, 'ship_method', l_transit_ship_method);
1147: WSH_DEBUG_SV.log(l_module_name, 'transit_time', l_transit_time);
1148: WSH_DEBUG_SV.log(l_module_name, 'status', l_transit_status);
1149: END IF;

Line 1146: WSH_DEBUG_SV.log(l_module_name, 'ship_method', l_transit_ship_method);

1142: l_transit_status);
1143:
1144: IF l_debug_on THEN
1145: WSH_DEBUG_SV.logmsg(l_module_name, 'Results from MSC_ATP_PROC.ATP_SHIPPING_LEAD_TIME:');
1146: WSH_DEBUG_SV.log(l_module_name, 'ship_method', l_transit_ship_method);
1147: WSH_DEBUG_SV.log(l_module_name, 'transit_time', l_transit_time);
1148: WSH_DEBUG_SV.log(l_module_name, 'status', l_transit_status);
1149: END IF;
1150:

Line 1147: WSH_DEBUG_SV.log(l_module_name, 'transit_time', l_transit_time);

1143:
1144: IF l_debug_on THEN
1145: WSH_DEBUG_SV.logmsg(l_module_name, 'Results from MSC_ATP_PROC.ATP_SHIPPING_LEAD_TIME:');
1146: WSH_DEBUG_SV.log(l_module_name, 'ship_method', l_transit_ship_method);
1147: WSH_DEBUG_SV.log(l_module_name, 'transit_time', l_transit_time);
1148: WSH_DEBUG_SV.log(l_module_name, 'status', l_transit_status);
1149: END IF;
1150:
1151: -- make sure ship method returned from transit times table matches

Line 1148: WSH_DEBUG_SV.log(l_module_name, 'status', l_transit_status);

1144: IF l_debug_on THEN
1145: WSH_DEBUG_SV.logmsg(l_module_name, 'Results from MSC_ATP_PROC.ATP_SHIPPING_LEAD_TIME:');
1146: WSH_DEBUG_SV.log(l_module_name, 'ship_method', l_transit_ship_method);
1147: WSH_DEBUG_SV.log(l_module_name, 'transit_time', l_transit_time);
1148: WSH_DEBUG_SV.log(l_module_name, 'status', l_transit_status);
1149: END IF;
1150:
1151: -- make sure ship method returned from transit times table matches
1152: -- that returned from CS, else error

Line 1157: WSH_DEBUG_SV.logmsg(l_module_name, 'MSC_ATP_PROC.ATP_SHIPPING_LEAD_TIM returned ' || l_transit_status);

1153: IF (l_transit_status = FND_API.G_RET_STS_ERROR OR
1154: l_transit_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1155:
1156: IF l_debug_on THEN
1157: WSH_DEBUG_SV.logmsg(l_module_name, 'MSC_ATP_PROC.ATP_SHIPPING_LEAD_TIM returned ' || l_transit_status);
1158: END IF;
1159: p_source_header_tab(i).status := l_transit_status;
1160: -- continue, end of this iteration of loop
1161: -- ship method returned by ATP is different from CS ship method

Line 1167: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR ship method returned by ATP is different from CS ship method');

1163: l_transit_ship_method is not null AND
1164: l_transit_ship_method <> p_source_header_tab(i).ship_method_code) THEN
1165:
1166: IF l_debug_on THEN
1167: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR ship method returned by ATP is different from CS ship method');
1168: END IF;
1169:
1170: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1171: p_source_header_tab(i).status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 1191: WSH_DEBUG_SV.log(l_module_name, 'message_data', p_source_header_tab(i).message_data);

1187: FND_MSG_PUB.ADD;
1188: END IF;
1189:
1190: IF l_debug_on THEN
1191: WSH_DEBUG_SV.log(l_module_name, 'message_data', p_source_header_tab(i).message_data);
1192: END IF;
1193: -- continue, end of this iteration of loop
1194:
1195: -- make sure transit time (from TT) is between min and max

Line 1206: WSH_DEBUG_SV.logmsg(l_module_name, 'WARNING ATP transit time falls outside FTE range. Setting return lead time to be FTE min');

1202: -- set return lead time to be FTE's min
1203: p_source_header_tab(i).delivery_lead_time := l_cs_transit_min;
1204:
1205: IF l_debug_on THEN
1206: WSH_DEBUG_SV.logmsg(l_module_name, 'WARNING ATP transit time falls outside FTE range. Setting return lead time to be FTE min');
1207: END IF;
1208:
1209: -- set warning message
1210: p_source_header_tab(i).status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 1226: WSH_DEBUG_SV.log(l_module_name, 'message_data', p_source_header_tab(i).message_data);

1222: -- p_source_header_tab(i).message_data := FND_MESSAGE.GET;
1223: FND_MSG_PUB.ADD;
1224:
1225: IF l_debug_on THEN
1226: WSH_DEBUG_SV.log(l_module_name, 'message_data', p_source_header_tab(i).message_data);
1227: END IF;
1228: -- continue, end of this iteration of loop
1229: END IF;
1230:

Line 1248: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR OM lead time not null and greater than 0 (scheduled) and transit time to be returned by FTE process_lines is greater than exisiting on OM');

1244: p_source_header_tab(i).delivery_lead_time is not null AND
1245: p_source_header_tab(i).delivery_lead_time > l_orig_delivery_time) THEN
1246:
1247: IF l_debug_on THEN
1248: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR OM lead time not null and greater than 0 (scheduled) and transit time to be returned by FTE process_lines is greater than exisiting on OM');
1249: END IF;
1250:
1251: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1252: p_source_header_tab(i).status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 1265: WSH_DEBUG_SV.log(l_module_name, 'message_data', p_source_header_tab(i).message_data);

1261: -- p_source_header_tab(i).message_data := FND_MESSAGE.GET;
1262: FND_MSG_PUB.ADD;
1263:
1264: IF l_debug_on THEN
1265: WSH_DEBUG_SV.log(l_module_name, 'message_data', p_source_header_tab(i).message_data);
1266: END IF;
1267: END IF; -- end mandatory OM line delivery lead time check against CS/TT
1268:
1269: END IF; -- end have ship method

Line 1299: WSH_DEBUG_SV.logmsg(l_module_name, '-------- SOURCE LINE OUTPUT--------');

1295: p_source_line_tab(i).status := p_source_header_tab(l_con_id).status;
1296: p_source_line_tab(i).message_data := p_source_header_tab(l_con_id).message_data;
1297:
1298: IF l_debug_on THEN
1299: WSH_DEBUG_SV.logmsg(l_module_name, '-------- SOURCE LINE OUTPUT--------');
1300: WSH_DEBUG_SV.log(l_module_name, 'source_line_id', p_source_line_tab(i).source_line_id);
1301: WSH_DEBUG_SV.log(l_module_name, 'source_header_id', p_source_line_tab(i).source_header_id);
1302: WSH_DEBUG_SV.log(l_module_name, 'consolidation_id', p_source_line_tab(i).consolidation_id);
1303: WSH_DEBUG_SV.log(l_module_name, 'ship_from_org_id', p_source_line_tab(i).ship_from_org_id);

Line 1300: WSH_DEBUG_SV.log(l_module_name, 'source_line_id', p_source_line_tab(i).source_line_id);

1296: p_source_line_tab(i).message_data := p_source_header_tab(l_con_id).message_data;
1297:
1298: IF l_debug_on THEN
1299: WSH_DEBUG_SV.logmsg(l_module_name, '-------- SOURCE LINE OUTPUT--------');
1300: WSH_DEBUG_SV.log(l_module_name, 'source_line_id', p_source_line_tab(i).source_line_id);
1301: WSH_DEBUG_SV.log(l_module_name, 'source_header_id', p_source_line_tab(i).source_header_id);
1302: WSH_DEBUG_SV.log(l_module_name, 'consolidation_id', p_source_line_tab(i).consolidation_id);
1303: WSH_DEBUG_SV.log(l_module_name, 'ship_from_org_id', p_source_line_tab(i).ship_from_org_id);
1304: WSH_DEBUG_SV.log(l_module_name, 'ship_from_location_id', p_source_line_tab(i).ship_from_location_id);

Line 1301: WSH_DEBUG_SV.log(l_module_name, 'source_header_id', p_source_line_tab(i).source_header_id);

1297:
1298: IF l_debug_on THEN
1299: WSH_DEBUG_SV.logmsg(l_module_name, '-------- SOURCE LINE OUTPUT--------');
1300: WSH_DEBUG_SV.log(l_module_name, 'source_line_id', p_source_line_tab(i).source_line_id);
1301: WSH_DEBUG_SV.log(l_module_name, 'source_header_id', p_source_line_tab(i).source_header_id);
1302: WSH_DEBUG_SV.log(l_module_name, 'consolidation_id', p_source_line_tab(i).consolidation_id);
1303: WSH_DEBUG_SV.log(l_module_name, 'ship_from_org_id', p_source_line_tab(i).ship_from_org_id);
1304: WSH_DEBUG_SV.log(l_module_name, 'ship_from_location_id', p_source_line_tab(i).ship_from_location_id);
1305: WSH_DEBUG_SV.log(l_module_name, 'ship_to_site_id', p_source_line_tab(i).ship_to_site_id);

Line 1302: WSH_DEBUG_SV.log(l_module_name, 'consolidation_id', p_source_line_tab(i).consolidation_id);

1298: IF l_debug_on THEN
1299: WSH_DEBUG_SV.logmsg(l_module_name, '-------- SOURCE LINE OUTPUT--------');
1300: WSH_DEBUG_SV.log(l_module_name, 'source_line_id', p_source_line_tab(i).source_line_id);
1301: WSH_DEBUG_SV.log(l_module_name, 'source_header_id', p_source_line_tab(i).source_header_id);
1302: WSH_DEBUG_SV.log(l_module_name, 'consolidation_id', p_source_line_tab(i).consolidation_id);
1303: WSH_DEBUG_SV.log(l_module_name, 'ship_from_org_id', p_source_line_tab(i).ship_from_org_id);
1304: WSH_DEBUG_SV.log(l_module_name, 'ship_from_location_id', p_source_line_tab(i).ship_from_location_id);
1305: WSH_DEBUG_SV.log(l_module_name, 'ship_to_site_id', p_source_line_tab(i).ship_to_site_id);
1306: WSH_DEBUG_SV.log(l_module_name, 'ship_to_location_id', p_source_line_tab(i).ship_to_location_id);

Line 1303: WSH_DEBUG_SV.log(l_module_name, 'ship_from_org_id', p_source_line_tab(i).ship_from_org_id);

1299: WSH_DEBUG_SV.logmsg(l_module_name, '-------- SOURCE LINE OUTPUT--------');
1300: WSH_DEBUG_SV.log(l_module_name, 'source_line_id', p_source_line_tab(i).source_line_id);
1301: WSH_DEBUG_SV.log(l_module_name, 'source_header_id', p_source_line_tab(i).source_header_id);
1302: WSH_DEBUG_SV.log(l_module_name, 'consolidation_id', p_source_line_tab(i).consolidation_id);
1303: WSH_DEBUG_SV.log(l_module_name, 'ship_from_org_id', p_source_line_tab(i).ship_from_org_id);
1304: WSH_DEBUG_SV.log(l_module_name, 'ship_from_location_id', p_source_line_tab(i).ship_from_location_id);
1305: WSH_DEBUG_SV.log(l_module_name, 'ship_to_site_id', p_source_line_tab(i).ship_to_site_id);
1306: WSH_DEBUG_SV.log(l_module_name, 'ship_to_location_id', p_source_line_tab(i).ship_to_location_id);
1307: WSH_DEBUG_SV.log(l_module_name, 'customer_id', p_source_line_tab(i).customer_id);

Line 1304: WSH_DEBUG_SV.log(l_module_name, 'ship_from_location_id', p_source_line_tab(i).ship_from_location_id);

1300: WSH_DEBUG_SV.log(l_module_name, 'source_line_id', p_source_line_tab(i).source_line_id);
1301: WSH_DEBUG_SV.log(l_module_name, 'source_header_id', p_source_line_tab(i).source_header_id);
1302: WSH_DEBUG_SV.log(l_module_name, 'consolidation_id', p_source_line_tab(i).consolidation_id);
1303: WSH_DEBUG_SV.log(l_module_name, 'ship_from_org_id', p_source_line_tab(i).ship_from_org_id);
1304: WSH_DEBUG_SV.log(l_module_name, 'ship_from_location_id', p_source_line_tab(i).ship_from_location_id);
1305: WSH_DEBUG_SV.log(l_module_name, 'ship_to_site_id', p_source_line_tab(i).ship_to_site_id);
1306: WSH_DEBUG_SV.log(l_module_name, 'ship_to_location_id', p_source_line_tab(i).ship_to_location_id);
1307: WSH_DEBUG_SV.log(l_module_name, 'customer_id', p_source_line_tab(i).customer_id);
1308: WSH_DEBUG_SV.log(l_module_name, 'inventory_item_id', p_source_line_tab(i).inventory_item_id);

Line 1305: WSH_DEBUG_SV.log(l_module_name, 'ship_to_site_id', p_source_line_tab(i).ship_to_site_id);

1301: WSH_DEBUG_SV.log(l_module_name, 'source_header_id', p_source_line_tab(i).source_header_id);
1302: WSH_DEBUG_SV.log(l_module_name, 'consolidation_id', p_source_line_tab(i).consolidation_id);
1303: WSH_DEBUG_SV.log(l_module_name, 'ship_from_org_id', p_source_line_tab(i).ship_from_org_id);
1304: WSH_DEBUG_SV.log(l_module_name, 'ship_from_location_id', p_source_line_tab(i).ship_from_location_id);
1305: WSH_DEBUG_SV.log(l_module_name, 'ship_to_site_id', p_source_line_tab(i).ship_to_site_id);
1306: WSH_DEBUG_SV.log(l_module_name, 'ship_to_location_id', p_source_line_tab(i).ship_to_location_id);
1307: WSH_DEBUG_SV.log(l_module_name, 'customer_id', p_source_line_tab(i).customer_id);
1308: WSH_DEBUG_SV.log(l_module_name, 'inventory_item_id', p_source_line_tab(i).inventory_item_id);
1309: WSH_DEBUG_SV.log(l_module_name, 'source_quantity', p_source_line_tab(i).source_quantity);

Line 1306: WSH_DEBUG_SV.log(l_module_name, 'ship_to_location_id', p_source_line_tab(i).ship_to_location_id);

1302: WSH_DEBUG_SV.log(l_module_name, 'consolidation_id', p_source_line_tab(i).consolidation_id);
1303: WSH_DEBUG_SV.log(l_module_name, 'ship_from_org_id', p_source_line_tab(i).ship_from_org_id);
1304: WSH_DEBUG_SV.log(l_module_name, 'ship_from_location_id', p_source_line_tab(i).ship_from_location_id);
1305: WSH_DEBUG_SV.log(l_module_name, 'ship_to_site_id', p_source_line_tab(i).ship_to_site_id);
1306: WSH_DEBUG_SV.log(l_module_name, 'ship_to_location_id', p_source_line_tab(i).ship_to_location_id);
1307: WSH_DEBUG_SV.log(l_module_name, 'customer_id', p_source_line_tab(i).customer_id);
1308: WSH_DEBUG_SV.log(l_module_name, 'inventory_item_id', p_source_line_tab(i).inventory_item_id);
1309: WSH_DEBUG_SV.log(l_module_name, 'source_quantity', p_source_line_tab(i).source_quantity);
1310: WSH_DEBUG_SV.log(l_module_name, 'source_quantity_uom', p_source_line_tab(i).source_quantity_uom);

Line 1307: WSH_DEBUG_SV.log(l_module_name, 'customer_id', p_source_line_tab(i).customer_id);

1303: WSH_DEBUG_SV.log(l_module_name, 'ship_from_org_id', p_source_line_tab(i).ship_from_org_id);
1304: WSH_DEBUG_SV.log(l_module_name, 'ship_from_location_id', p_source_line_tab(i).ship_from_location_id);
1305: WSH_DEBUG_SV.log(l_module_name, 'ship_to_site_id', p_source_line_tab(i).ship_to_site_id);
1306: WSH_DEBUG_SV.log(l_module_name, 'ship_to_location_id', p_source_line_tab(i).ship_to_location_id);
1307: WSH_DEBUG_SV.log(l_module_name, 'customer_id', p_source_line_tab(i).customer_id);
1308: WSH_DEBUG_SV.log(l_module_name, 'inventory_item_id', p_source_line_tab(i).inventory_item_id);
1309: WSH_DEBUG_SV.log(l_module_name, 'source_quantity', p_source_line_tab(i).source_quantity);
1310: WSH_DEBUG_SV.log(l_module_name, 'source_quantity_uom', p_source_line_tab(i).source_quantity_uom);
1311: WSH_DEBUG_SV.log(l_module_name, 'ship_date', p_source_line_tab(i).ship_date);

Line 1308: WSH_DEBUG_SV.log(l_module_name, 'inventory_item_id', p_source_line_tab(i).inventory_item_id);

1304: WSH_DEBUG_SV.log(l_module_name, 'ship_from_location_id', p_source_line_tab(i).ship_from_location_id);
1305: WSH_DEBUG_SV.log(l_module_name, 'ship_to_site_id', p_source_line_tab(i).ship_to_site_id);
1306: WSH_DEBUG_SV.log(l_module_name, 'ship_to_location_id', p_source_line_tab(i).ship_to_location_id);
1307: WSH_DEBUG_SV.log(l_module_name, 'customer_id', p_source_line_tab(i).customer_id);
1308: WSH_DEBUG_SV.log(l_module_name, 'inventory_item_id', p_source_line_tab(i).inventory_item_id);
1309: WSH_DEBUG_SV.log(l_module_name, 'source_quantity', p_source_line_tab(i).source_quantity);
1310: WSH_DEBUG_SV.log(l_module_name, 'source_quantity_uom', p_source_line_tab(i).source_quantity_uom);
1311: WSH_DEBUG_SV.log(l_module_name, 'ship_date', p_source_line_tab(i).ship_date);
1312: WSH_DEBUG_SV.log(l_module_name, 'arrival_date', p_source_line_tab(i).arrival_date);

Line 1309: WSH_DEBUG_SV.log(l_module_name, 'source_quantity', p_source_line_tab(i).source_quantity);

1305: WSH_DEBUG_SV.log(l_module_name, 'ship_to_site_id', p_source_line_tab(i).ship_to_site_id);
1306: WSH_DEBUG_SV.log(l_module_name, 'ship_to_location_id', p_source_line_tab(i).ship_to_location_id);
1307: WSH_DEBUG_SV.log(l_module_name, 'customer_id', p_source_line_tab(i).customer_id);
1308: WSH_DEBUG_SV.log(l_module_name, 'inventory_item_id', p_source_line_tab(i).inventory_item_id);
1309: WSH_DEBUG_SV.log(l_module_name, 'source_quantity', p_source_line_tab(i).source_quantity);
1310: WSH_DEBUG_SV.log(l_module_name, 'source_quantity_uom', p_source_line_tab(i).source_quantity_uom);
1311: WSH_DEBUG_SV.log(l_module_name, 'ship_date', p_source_line_tab(i).ship_date);
1312: WSH_DEBUG_SV.log(l_module_name, 'arrival_date', p_source_line_tab(i).arrival_date);
1313: WSH_DEBUG_SV.log(l_module_name, 'scheduled_flag', p_source_line_tab(i).scheduled_flag);

Line 1310: WSH_DEBUG_SV.log(l_module_name, 'source_quantity_uom', p_source_line_tab(i).source_quantity_uom);

1306: WSH_DEBUG_SV.log(l_module_name, 'ship_to_location_id', p_source_line_tab(i).ship_to_location_id);
1307: WSH_DEBUG_SV.log(l_module_name, 'customer_id', p_source_line_tab(i).customer_id);
1308: WSH_DEBUG_SV.log(l_module_name, 'inventory_item_id', p_source_line_tab(i).inventory_item_id);
1309: WSH_DEBUG_SV.log(l_module_name, 'source_quantity', p_source_line_tab(i).source_quantity);
1310: WSH_DEBUG_SV.log(l_module_name, 'source_quantity_uom', p_source_line_tab(i).source_quantity_uom);
1311: WSH_DEBUG_SV.log(l_module_name, 'ship_date', p_source_line_tab(i).ship_date);
1312: WSH_DEBUG_SV.log(l_module_name, 'arrival_date', p_source_line_tab(i).arrival_date);
1313: WSH_DEBUG_SV.log(l_module_name, 'scheduled_flag', p_source_line_tab(i).scheduled_flag);
1314: WSH_DEBUG_SV.log(l_module_name, 'intmed_ship_to_site_id', p_source_line_tab(i).intmed_ship_to_site_id);

Line 1311: WSH_DEBUG_SV.log(l_module_name, 'ship_date', p_source_line_tab(i).ship_date);

1307: WSH_DEBUG_SV.log(l_module_name, 'customer_id', p_source_line_tab(i).customer_id);
1308: WSH_DEBUG_SV.log(l_module_name, 'inventory_item_id', p_source_line_tab(i).inventory_item_id);
1309: WSH_DEBUG_SV.log(l_module_name, 'source_quantity', p_source_line_tab(i).source_quantity);
1310: WSH_DEBUG_SV.log(l_module_name, 'source_quantity_uom', p_source_line_tab(i).source_quantity_uom);
1311: WSH_DEBUG_SV.log(l_module_name, 'ship_date', p_source_line_tab(i).ship_date);
1312: WSH_DEBUG_SV.log(l_module_name, 'arrival_date', p_source_line_tab(i).arrival_date);
1313: WSH_DEBUG_SV.log(l_module_name, 'scheduled_flag', p_source_line_tab(i).scheduled_flag);
1314: WSH_DEBUG_SV.log(l_module_name, 'intmed_ship_to_site_id', p_source_line_tab(i).intmed_ship_to_site_id);
1315: WSH_DEBUG_SV.log(l_module_name, 'intmed_ship_to_loc_id', p_source_line_tab(i).intmed_ship_to_loc_id);

Line 1312: WSH_DEBUG_SV.log(l_module_name, 'arrival_date', p_source_line_tab(i).arrival_date);

1308: WSH_DEBUG_SV.log(l_module_name, 'inventory_item_id', p_source_line_tab(i).inventory_item_id);
1309: WSH_DEBUG_SV.log(l_module_name, 'source_quantity', p_source_line_tab(i).source_quantity);
1310: WSH_DEBUG_SV.log(l_module_name, 'source_quantity_uom', p_source_line_tab(i).source_quantity_uom);
1311: WSH_DEBUG_SV.log(l_module_name, 'ship_date', p_source_line_tab(i).ship_date);
1312: WSH_DEBUG_SV.log(l_module_name, 'arrival_date', p_source_line_tab(i).arrival_date);
1313: WSH_DEBUG_SV.log(l_module_name, 'scheduled_flag', p_source_line_tab(i).scheduled_flag);
1314: WSH_DEBUG_SV.log(l_module_name, 'intmed_ship_to_site_id', p_source_line_tab(i).intmed_ship_to_site_id);
1315: WSH_DEBUG_SV.log(l_module_name, 'intmed_ship_to_loc_id', p_source_line_tab(i).intmed_ship_to_loc_id);
1316: WSH_DEBUG_SV.log(l_module_name, 'fob_code', p_source_line_tab(i).fob_code);

Line 1313: WSH_DEBUG_SV.log(l_module_name, 'scheduled_flag', p_source_line_tab(i).scheduled_flag);

1309: WSH_DEBUG_SV.log(l_module_name, 'source_quantity', p_source_line_tab(i).source_quantity);
1310: WSH_DEBUG_SV.log(l_module_name, 'source_quantity_uom', p_source_line_tab(i).source_quantity_uom);
1311: WSH_DEBUG_SV.log(l_module_name, 'ship_date', p_source_line_tab(i).ship_date);
1312: WSH_DEBUG_SV.log(l_module_name, 'arrival_date', p_source_line_tab(i).arrival_date);
1313: WSH_DEBUG_SV.log(l_module_name, 'scheduled_flag', p_source_line_tab(i).scheduled_flag);
1314: WSH_DEBUG_SV.log(l_module_name, 'intmed_ship_to_site_id', p_source_line_tab(i).intmed_ship_to_site_id);
1315: WSH_DEBUG_SV.log(l_module_name, 'intmed_ship_to_loc_id', p_source_line_tab(i).intmed_ship_to_loc_id);
1316: WSH_DEBUG_SV.log(l_module_name, 'fob_code', p_source_line_tab(i).fob_code);
1317: WSH_DEBUG_SV.log(l_module_name, 'weight', p_source_line_tab(i).weight);

Line 1314: WSH_DEBUG_SV.log(l_module_name, 'intmed_ship_to_site_id', p_source_line_tab(i).intmed_ship_to_site_id);

1310: WSH_DEBUG_SV.log(l_module_name, 'source_quantity_uom', p_source_line_tab(i).source_quantity_uom);
1311: WSH_DEBUG_SV.log(l_module_name, 'ship_date', p_source_line_tab(i).ship_date);
1312: WSH_DEBUG_SV.log(l_module_name, 'arrival_date', p_source_line_tab(i).arrival_date);
1313: WSH_DEBUG_SV.log(l_module_name, 'scheduled_flag', p_source_line_tab(i).scheduled_flag);
1314: WSH_DEBUG_SV.log(l_module_name, 'intmed_ship_to_site_id', p_source_line_tab(i).intmed_ship_to_site_id);
1315: WSH_DEBUG_SV.log(l_module_name, 'intmed_ship_to_loc_id', p_source_line_tab(i).intmed_ship_to_loc_id);
1316: WSH_DEBUG_SV.log(l_module_name, 'fob_code', p_source_line_tab(i).fob_code);
1317: WSH_DEBUG_SV.log(l_module_name, 'weight', p_source_line_tab(i).weight);
1318: WSH_DEBUG_SV.log(l_module_name, 'weight_uom_code', p_source_line_tab(i).weight_uom_code);

Line 1315: WSH_DEBUG_SV.log(l_module_name, 'intmed_ship_to_loc_id', p_source_line_tab(i).intmed_ship_to_loc_id);

1311: WSH_DEBUG_SV.log(l_module_name, 'ship_date', p_source_line_tab(i).ship_date);
1312: WSH_DEBUG_SV.log(l_module_name, 'arrival_date', p_source_line_tab(i).arrival_date);
1313: WSH_DEBUG_SV.log(l_module_name, 'scheduled_flag', p_source_line_tab(i).scheduled_flag);
1314: WSH_DEBUG_SV.log(l_module_name, 'intmed_ship_to_site_id', p_source_line_tab(i).intmed_ship_to_site_id);
1315: WSH_DEBUG_SV.log(l_module_name, 'intmed_ship_to_loc_id', p_source_line_tab(i).intmed_ship_to_loc_id);
1316: WSH_DEBUG_SV.log(l_module_name, 'fob_code', p_source_line_tab(i).fob_code);
1317: WSH_DEBUG_SV.log(l_module_name, 'weight', p_source_line_tab(i).weight);
1318: WSH_DEBUG_SV.log(l_module_name, 'weight_uom_code', p_source_line_tab(i).weight_uom_code);
1319: WSH_DEBUG_SV.log(l_module_name, 'volume', p_source_line_tab(i).volume);

Line 1316: WSH_DEBUG_SV.log(l_module_name, 'fob_code', p_source_line_tab(i).fob_code);

1312: WSH_DEBUG_SV.log(l_module_name, 'arrival_date', p_source_line_tab(i).arrival_date);
1313: WSH_DEBUG_SV.log(l_module_name, 'scheduled_flag', p_source_line_tab(i).scheduled_flag);
1314: WSH_DEBUG_SV.log(l_module_name, 'intmed_ship_to_site_id', p_source_line_tab(i).intmed_ship_to_site_id);
1315: WSH_DEBUG_SV.log(l_module_name, 'intmed_ship_to_loc_id', p_source_line_tab(i).intmed_ship_to_loc_id);
1316: WSH_DEBUG_SV.log(l_module_name, 'fob_code', p_source_line_tab(i).fob_code);
1317: WSH_DEBUG_SV.log(l_module_name, 'weight', p_source_line_tab(i).weight);
1318: WSH_DEBUG_SV.log(l_module_name, 'weight_uom_code', p_source_line_tab(i).weight_uom_code);
1319: WSH_DEBUG_SV.log(l_module_name, 'volume', p_source_line_tab(i).volume);
1320: WSH_DEBUG_SV.log(l_module_name, 'volume_uom_code', p_source_line_tab(i).volume_uom_code);

Line 1317: WSH_DEBUG_SV.log(l_module_name, 'weight', p_source_line_tab(i).weight);

1313: WSH_DEBUG_SV.log(l_module_name, 'scheduled_flag', p_source_line_tab(i).scheduled_flag);
1314: WSH_DEBUG_SV.log(l_module_name, 'intmed_ship_to_site_id', p_source_line_tab(i).intmed_ship_to_site_id);
1315: WSH_DEBUG_SV.log(l_module_name, 'intmed_ship_to_loc_id', p_source_line_tab(i).intmed_ship_to_loc_id);
1316: WSH_DEBUG_SV.log(l_module_name, 'fob_code', p_source_line_tab(i).fob_code);
1317: WSH_DEBUG_SV.log(l_module_name, 'weight', p_source_line_tab(i).weight);
1318: WSH_DEBUG_SV.log(l_module_name, 'weight_uom_code', p_source_line_tab(i).weight_uom_code);
1319: WSH_DEBUG_SV.log(l_module_name, 'volume', p_source_line_tab(i).volume);
1320: WSH_DEBUG_SV.log(l_module_name, 'volume_uom_code', p_source_line_tab(i).volume_uom_code);
1321: WSH_DEBUG_SV.log(l_module_name, 'ship_method_code', p_source_line_tab(i).ship_method_code);

Line 1318: WSH_DEBUG_SV.log(l_module_name, 'weight_uom_code', p_source_line_tab(i).weight_uom_code);

1314: WSH_DEBUG_SV.log(l_module_name, 'intmed_ship_to_site_id', p_source_line_tab(i).intmed_ship_to_site_id);
1315: WSH_DEBUG_SV.log(l_module_name, 'intmed_ship_to_loc_id', p_source_line_tab(i).intmed_ship_to_loc_id);
1316: WSH_DEBUG_SV.log(l_module_name, 'fob_code', p_source_line_tab(i).fob_code);
1317: WSH_DEBUG_SV.log(l_module_name, 'weight', p_source_line_tab(i).weight);
1318: WSH_DEBUG_SV.log(l_module_name, 'weight_uom_code', p_source_line_tab(i).weight_uom_code);
1319: WSH_DEBUG_SV.log(l_module_name, 'volume', p_source_line_tab(i).volume);
1320: WSH_DEBUG_SV.log(l_module_name, 'volume_uom_code', p_source_line_tab(i).volume_uom_code);
1321: WSH_DEBUG_SV.log(l_module_name, 'ship_method_code', p_source_line_tab(i).ship_method_code);
1322: WSH_DEBUG_SV.log(l_module_name, 'carrier_id', p_source_line_tab(i).carrier_id);

Line 1319: WSH_DEBUG_SV.log(l_module_name, 'volume', p_source_line_tab(i).volume);

1315: WSH_DEBUG_SV.log(l_module_name, 'intmed_ship_to_loc_id', p_source_line_tab(i).intmed_ship_to_loc_id);
1316: WSH_DEBUG_SV.log(l_module_name, 'fob_code', p_source_line_tab(i).fob_code);
1317: WSH_DEBUG_SV.log(l_module_name, 'weight', p_source_line_tab(i).weight);
1318: WSH_DEBUG_SV.log(l_module_name, 'weight_uom_code', p_source_line_tab(i).weight_uom_code);
1319: WSH_DEBUG_SV.log(l_module_name, 'volume', p_source_line_tab(i).volume);
1320: WSH_DEBUG_SV.log(l_module_name, 'volume_uom_code', p_source_line_tab(i).volume_uom_code);
1321: WSH_DEBUG_SV.log(l_module_name, 'ship_method_code', p_source_line_tab(i).ship_method_code);
1322: WSH_DEBUG_SV.log(l_module_name, 'carrier_id', p_source_line_tab(i).carrier_id);
1323: WSH_DEBUG_SV.log(l_module_name, 'service_level', p_source_line_tab(i).service_level);

Line 1320: WSH_DEBUG_SV.log(l_module_name, 'volume_uom_code', p_source_line_tab(i).volume_uom_code);

1316: WSH_DEBUG_SV.log(l_module_name, 'fob_code', p_source_line_tab(i).fob_code);
1317: WSH_DEBUG_SV.log(l_module_name, 'weight', p_source_line_tab(i).weight);
1318: WSH_DEBUG_SV.log(l_module_name, 'weight_uom_code', p_source_line_tab(i).weight_uom_code);
1319: WSH_DEBUG_SV.log(l_module_name, 'volume', p_source_line_tab(i).volume);
1320: WSH_DEBUG_SV.log(l_module_name, 'volume_uom_code', p_source_line_tab(i).volume_uom_code);
1321: WSH_DEBUG_SV.log(l_module_name, 'ship_method_code', p_source_line_tab(i).ship_method_code);
1322: WSH_DEBUG_SV.log(l_module_name, 'carrier_id', p_source_line_tab(i).carrier_id);
1323: WSH_DEBUG_SV.log(l_module_name, 'service_level', p_source_line_tab(i).service_level);
1324: WSH_DEBUG_SV.log(l_module_name, 'mode_of_transport', p_source_line_tab(i).mode_of_transport);

Line 1321: WSH_DEBUG_SV.log(l_module_name, 'ship_method_code', p_source_line_tab(i).ship_method_code);

1317: WSH_DEBUG_SV.log(l_module_name, 'weight', p_source_line_tab(i).weight);
1318: WSH_DEBUG_SV.log(l_module_name, 'weight_uom_code', p_source_line_tab(i).weight_uom_code);
1319: WSH_DEBUG_SV.log(l_module_name, 'volume', p_source_line_tab(i).volume);
1320: WSH_DEBUG_SV.log(l_module_name, 'volume_uom_code', p_source_line_tab(i).volume_uom_code);
1321: WSH_DEBUG_SV.log(l_module_name, 'ship_method_code', p_source_line_tab(i).ship_method_code);
1322: WSH_DEBUG_SV.log(l_module_name, 'carrier_id', p_source_line_tab(i).carrier_id);
1323: WSH_DEBUG_SV.log(l_module_name, 'service_level', p_source_line_tab(i).service_level);
1324: WSH_DEBUG_SV.log(l_module_name, 'mode_of_transport', p_source_line_tab(i).mode_of_transport);
1325: WSH_DEBUG_SV.log(l_module_name, 'freight_terms', p_source_line_tab(i).freight_terms);

Line 1322: WSH_DEBUG_SV.log(l_module_name, 'carrier_id', p_source_line_tab(i).carrier_id);

1318: WSH_DEBUG_SV.log(l_module_name, 'weight_uom_code', p_source_line_tab(i).weight_uom_code);
1319: WSH_DEBUG_SV.log(l_module_name, 'volume', p_source_line_tab(i).volume);
1320: WSH_DEBUG_SV.log(l_module_name, 'volume_uom_code', p_source_line_tab(i).volume_uom_code);
1321: WSH_DEBUG_SV.log(l_module_name, 'ship_method_code', p_source_line_tab(i).ship_method_code);
1322: WSH_DEBUG_SV.log(l_module_name, 'carrier_id', p_source_line_tab(i).carrier_id);
1323: WSH_DEBUG_SV.log(l_module_name, 'service_level', p_source_line_tab(i).service_level);
1324: WSH_DEBUG_SV.log(l_module_name, 'mode_of_transport', p_source_line_tab(i).mode_of_transport);
1325: WSH_DEBUG_SV.log(l_module_name, 'freight_terms', p_source_line_tab(i).freight_terms);
1326: WSH_DEBUG_SV.log(l_module_name, 'delivery_lead_time', p_source_line_tab(i).delivery_lead_time);

Line 1323: WSH_DEBUG_SV.log(l_module_name, 'service_level', p_source_line_tab(i).service_level);

1319: WSH_DEBUG_SV.log(l_module_name, 'volume', p_source_line_tab(i).volume);
1320: WSH_DEBUG_SV.log(l_module_name, 'volume_uom_code', p_source_line_tab(i).volume_uom_code);
1321: WSH_DEBUG_SV.log(l_module_name, 'ship_method_code', p_source_line_tab(i).ship_method_code);
1322: WSH_DEBUG_SV.log(l_module_name, 'carrier_id', p_source_line_tab(i).carrier_id);
1323: WSH_DEBUG_SV.log(l_module_name, 'service_level', p_source_line_tab(i).service_level);
1324: WSH_DEBUG_SV.log(l_module_name, 'mode_of_transport', p_source_line_tab(i).mode_of_transport);
1325: WSH_DEBUG_SV.log(l_module_name, 'freight_terms', p_source_line_tab(i).freight_terms);
1326: WSH_DEBUG_SV.log(l_module_name, 'delivery_lead_time', p_source_line_tab(i).delivery_lead_time);
1327: WSH_DEBUG_SV.log(l_module_name, 'status', p_source_line_tab(i).status);

Line 1324: WSH_DEBUG_SV.log(l_module_name, 'mode_of_transport', p_source_line_tab(i).mode_of_transport);

1320: WSH_DEBUG_SV.log(l_module_name, 'volume_uom_code', p_source_line_tab(i).volume_uom_code);
1321: WSH_DEBUG_SV.log(l_module_name, 'ship_method_code', p_source_line_tab(i).ship_method_code);
1322: WSH_DEBUG_SV.log(l_module_name, 'carrier_id', p_source_line_tab(i).carrier_id);
1323: WSH_DEBUG_SV.log(l_module_name, 'service_level', p_source_line_tab(i).service_level);
1324: WSH_DEBUG_SV.log(l_module_name, 'mode_of_transport', p_source_line_tab(i).mode_of_transport);
1325: WSH_DEBUG_SV.log(l_module_name, 'freight_terms', p_source_line_tab(i).freight_terms);
1326: WSH_DEBUG_SV.log(l_module_name, 'delivery_lead_time', p_source_line_tab(i).delivery_lead_time);
1327: WSH_DEBUG_SV.log(l_module_name, 'status', p_source_line_tab(i).status);
1328: WSH_DEBUG_SV.log(l_module_name, 'message_data', p_source_line_tab(i).message_data);

Line 1325: WSH_DEBUG_SV.log(l_module_name, 'freight_terms', p_source_line_tab(i).freight_terms);

1321: WSH_DEBUG_SV.log(l_module_name, 'ship_method_code', p_source_line_tab(i).ship_method_code);
1322: WSH_DEBUG_SV.log(l_module_name, 'carrier_id', p_source_line_tab(i).carrier_id);
1323: WSH_DEBUG_SV.log(l_module_name, 'service_level', p_source_line_tab(i).service_level);
1324: WSH_DEBUG_SV.log(l_module_name, 'mode_of_transport', p_source_line_tab(i).mode_of_transport);
1325: WSH_DEBUG_SV.log(l_module_name, 'freight_terms', p_source_line_tab(i).freight_terms);
1326: WSH_DEBUG_SV.log(l_module_name, 'delivery_lead_time', p_source_line_tab(i).delivery_lead_time);
1327: WSH_DEBUG_SV.log(l_module_name, 'status', p_source_line_tab(i).status);
1328: WSH_DEBUG_SV.log(l_module_name, 'message_data', p_source_line_tab(i).message_data);
1329: END IF;

Line 1326: WSH_DEBUG_SV.log(l_module_name, 'delivery_lead_time', p_source_line_tab(i).delivery_lead_time);

1322: WSH_DEBUG_SV.log(l_module_name, 'carrier_id', p_source_line_tab(i).carrier_id);
1323: WSH_DEBUG_SV.log(l_module_name, 'service_level', p_source_line_tab(i).service_level);
1324: WSH_DEBUG_SV.log(l_module_name, 'mode_of_transport', p_source_line_tab(i).mode_of_transport);
1325: WSH_DEBUG_SV.log(l_module_name, 'freight_terms', p_source_line_tab(i).freight_terms);
1326: WSH_DEBUG_SV.log(l_module_name, 'delivery_lead_time', p_source_line_tab(i).delivery_lead_time);
1327: WSH_DEBUG_SV.log(l_module_name, 'status', p_source_line_tab(i).status);
1328: WSH_DEBUG_SV.log(l_module_name, 'message_data', p_source_line_tab(i).message_data);
1329: END IF;
1330: END LOOP;

Line 1327: WSH_DEBUG_SV.log(l_module_name, 'status', p_source_line_tab(i).status);

1323: WSH_DEBUG_SV.log(l_module_name, 'service_level', p_source_line_tab(i).service_level);
1324: WSH_DEBUG_SV.log(l_module_name, 'mode_of_transport', p_source_line_tab(i).mode_of_transport);
1325: WSH_DEBUG_SV.log(l_module_name, 'freight_terms', p_source_line_tab(i).freight_terms);
1326: WSH_DEBUG_SV.log(l_module_name, 'delivery_lead_time', p_source_line_tab(i).delivery_lead_time);
1327: WSH_DEBUG_SV.log(l_module_name, 'status', p_source_line_tab(i).status);
1328: WSH_DEBUG_SV.log(l_module_name, 'message_data', p_source_line_tab(i).message_data);
1329: END IF;
1330: END LOOP;
1331:

Line 1328: WSH_DEBUG_SV.log(l_module_name, 'message_data', p_source_line_tab(i).message_data);

1324: WSH_DEBUG_SV.log(l_module_name, 'mode_of_transport', p_source_line_tab(i).mode_of_transport);
1325: WSH_DEBUG_SV.log(l_module_name, 'freight_terms', p_source_line_tab(i).freight_terms);
1326: WSH_DEBUG_SV.log(l_module_name, 'delivery_lead_time', p_source_line_tab(i).delivery_lead_time);
1327: WSH_DEBUG_SV.log(l_module_name, 'status', p_source_line_tab(i).status);
1328: WSH_DEBUG_SV.log(l_module_name, 'message_data', p_source_line_tab(i).message_data);
1329: END IF;
1330: END LOOP;
1331:
1332: -- if it failed with any of the above validation

Line 1337: FND_MESSAGE.SET_TOKEN('LOGFILE',WSH_DEBUG_SV.g_Dir||'/'||WSH_DEBUG_SV.g_File);

1333: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1334:
1335: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_LOG_FILE_NAME');
1336: IF l_debug_on THEN
1337: FND_MESSAGE.SET_TOKEN('LOGFILE',WSH_DEBUG_SV.g_Dir||'/'||WSH_DEBUG_SV.g_File);
1338: ELSE
1339: FND_MESSAGE.SET_TOKEN('LOGFILE','');
1340: END IF;
1341: FND_MSG_PUB.ADD;

Line 1347: WSH_DEBUG_SV.logmsg(l_module_name,'return_status is changed from '||l_status||' to '||x_return_status||' after getting ship method.',WSH_DEBUG_SV.C_PROC_LEVEL);

1343: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEL_NO_CS_RESULT');
1344: FND_MSG_PUB.ADD;
1345:
1346: IF l_debug_on THEN
1347: WSH_DEBUG_SV.logmsg(l_module_name,'return_status is changed from '||l_status||' to '||x_return_status||' after getting ship method.',WSH_DEBUG_SV.C_PROC_LEVEL);
1348: WSH_DEBUG_SV.pop(l_module_name);
1349: END IF;
1350:
1351: RETURN;

Line 1348: WSH_DEBUG_SV.pop(l_module_name);

1344: FND_MSG_PUB.ADD;
1345:
1346: IF l_debug_on THEN
1347: WSH_DEBUG_SV.logmsg(l_module_name,'return_status is changed from '||l_status||' to '||x_return_status||' after getting ship method.',WSH_DEBUG_SV.C_PROC_LEVEL);
1348: WSH_DEBUG_SV.pop(l_module_name);
1349: END IF;
1350:
1351: RETURN;
1352: END IF;

Line 1369: WSH_DEBUG_SV.pop(l_module_name);

1365: --
1366: -- Debug Statements
1367: --
1368: IF l_debug_on THEN
1369: WSH_DEBUG_SV.pop(l_module_name);
1370: END IF;
1371: --
1372: RETURN;
1373:

Line 1377: WSH_DEBUG_SV.log(l_module_name, 'error_return_status', l_status);

1373:
1374: -- format cs call had errors or unexpected errors
1375: ELSE
1376: IF l_debug_on THEN
1377: WSH_DEBUG_SV.log(l_module_name, 'error_return_status', l_status);
1378: WSH_DEBUG_SV.log(l_module_name, 'error_return_status', l_msg_data);
1379: END IF;
1380: x_return_status := l_status;
1381: x_msg_data := l_msg_data;

Line 1378: WSH_DEBUG_SV.log(l_module_name, 'error_return_status', l_msg_data);

1374: -- format cs call had errors or unexpected errors
1375: ELSE
1376: IF l_debug_on THEN
1377: WSH_DEBUG_SV.log(l_module_name, 'error_return_status', l_status);
1378: WSH_DEBUG_SV.log(l_module_name, 'error_return_status', l_msg_data);
1379: END IF;
1380: x_return_status := l_status;
1381: x_msg_data := l_msg_data;
1382: IF (x_return_status is null) THEN

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

1384: END IF;
1385:
1386: FOR i IN p_source_line_tab.FIRST..p_source_line_tab.LAST LOOP
1387: IF l_debug_on THEN
1388: WSH_DEBUG_SV.log(l_module_name, 'i is', to_char(i));
1389: END IF;
1390: p_source_line_tab(i).status := x_return_status;
1391: p_source_line_tab(i).message_data := x_msg_data;
1392: END LOOP;

Line 1398: WSH_DEBUG_SV.pop(l_module_name);

1394: --
1395: -- Debug Statements
1396: --
1397: IF l_debug_on THEN
1398: WSH_DEBUG_SV.pop(l_module_name);
1399: END IF;
1400: --
1401: RETURN;
1402:

Line 1414: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_FREIGHT_RATING_PUB.GET_FREIGHT_COSTS',WSH_DEBUG_SV.C_PROC_LEVEL);

1410: AND (p_action = 'R' OR p_action = 'B')) THEN
1411:
1412: IF (l_otm_installed ='N') THEN
1413: IF l_debug_on THEN
1414: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_FREIGHT_RATING_PUB.GET_FREIGHT_COSTS',WSH_DEBUG_SV.C_PROC_LEVEL);
1415: END IF;
1416: FTE_FREIGHT_RATING_PUB.Get_Freight_Costs(
1417: p_api_version => 1,
1418: p_source_line_tab => p_source_line_tab,

Line 1430: WSH_DEBUG_SV.logmsg(l_module_name,'currency for get rates is '||p_source_header_tab(p_source_header_tab.FIRST).currency);

1426: x_msg_count => l_msg_count,
1427: x_msg_data => l_msg_data);
1428: ELSE
1429: IF l_debug_on THEN
1430: WSH_DEBUG_SV.logmsg(l_module_name,'currency for get rates is '||p_source_header_tab(p_source_header_tab.FIRST).currency);
1431: END IF;
1432: WSH_OTM_RIQ_XML.CALL_OTM_FOR_OM(
1433: x_source_line_tab => p_source_line_tab,
1434: x_source_header_tab => p_source_header_tab,

Line 1468: WSH_DEBUG_SV.pop(l_module_name);

1464: --
1465: -- Debug Statements
1466: --
1467: IF l_debug_on THEN
1468: WSH_DEBUG_SV.pop(l_module_name);
1469: END IF;
1470: --
1471: EXCEPTION
1472:

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

1476: --
1477: -- Debug Statements
1478: --
1479: IF l_debug_on THEN
1480: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1481: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1482: END IF;
1483: --
1484: RAISE;

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

1477: -- Debug Statements
1478: --
1479: IF l_debug_on THEN
1480: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1481: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1482: END IF;
1483: --
1484: RAISE;
1485:

Line 1490: WSH_DEBUG_SV.pop(l_module_name);

1486: --
1487: -- Debug Statements
1488: --
1489: IF l_debug_on THEN
1490: WSH_DEBUG_SV.pop(l_module_name);
1491: END IF;
1492: --
1493: END Process_Lines;
1494: