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

Line 74: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

70: --
71: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
72: --
73: IF l_debug_on IS NULL THEN
74: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
75: END IF;
76: --
77: IF l_debug_on THEN
78: WSH_DEBUG_SV.push(l_module_name);

Line 78: WSH_DEBUG_SV.push(l_module_name);

74: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
75: END IF;
76: --
77: IF l_debug_on THEN
78: WSH_DEBUG_SV.push(l_module_name);
79: --
80: WSH_DEBUG_SV.log(l_module_name,'P_DETAIL_TAB COUNT',p_detail_tab.COUNT);
81: WSH_DEBUG_SV.log(l_module_name,'P_ITEM_QUANTITY_UOM_TAB COUNT',p_item_quantity_uom_tab.COUNT);
82: END IF;

Line 80: WSH_DEBUG_SV.log(l_module_name,'P_DETAIL_TAB COUNT',p_detail_tab.COUNT);

76: --
77: IF l_debug_on THEN
78: WSH_DEBUG_SV.push(l_module_name);
79: --
80: WSH_DEBUG_SV.log(l_module_name,'P_DETAIL_TAB COUNT',p_detail_tab.COUNT);
81: WSH_DEBUG_SV.log(l_module_name,'P_ITEM_QUANTITY_UOM_TAB COUNT',p_item_quantity_uom_tab.COUNT);
82: END IF;
83: --
84: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 81: WSH_DEBUG_SV.log(l_module_name,'P_ITEM_QUANTITY_UOM_TAB COUNT',p_item_quantity_uom_tab.COUNT);

77: IF l_debug_on THEN
78: WSH_DEBUG_SV.push(l_module_name);
79: --
80: WSH_DEBUG_SV.log(l_module_name,'P_DETAIL_TAB COUNT',p_detail_tab.COUNT);
81: WSH_DEBUG_SV.log(l_module_name,'P_ITEM_QUANTITY_UOM_TAB COUNT',p_item_quantity_uom_tab.COUNT);
82: END IF;
83: --
84: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
85:

Line 104: WSH_DEBUG_SV.logmsg(l_module_name, 'no delivery detail to split');

100: i := 0;
101:
102: IF (p_detail_tab.COUNT = 0) THEN
103: IF l_debug_on THEN
104: WSH_DEBUG_SV.logmsg(l_module_name, 'no delivery detail to split');
105: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
106: WSH_DEBUG_SV.pop(l_module_name);
107: END IF;
108: RETURN;

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

101:
102: IF (p_detail_tab.COUNT = 0) THEN
103: IF l_debug_on THEN
104: WSH_DEBUG_SV.logmsg(l_module_name, 'no delivery detail to split');
105: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
106: WSH_DEBUG_SV.pop(l_module_name);
107: END IF;
108: RETURN;
109: END IF;

Line 106: WSH_DEBUG_SV.pop(l_module_name);

102: IF (p_detail_tab.COUNT = 0) THEN
103: IF l_debug_on THEN
104: WSH_DEBUG_SV.logmsg(l_module_name, 'no delivery detail to split');
105: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
106: WSH_DEBUG_SV.pop(l_module_name);
107: END IF;
108: RETURN;
109: END IF;
110:

Line 114: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters',WSH_DEBUG_SV.C_PROC_LEVEL);

110:
111: --get weight UOM from global parameters
112:
113: IF l_debug_on THEN
114: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters',WSH_DEBUG_SV.C_PROC_LEVEL);
115: END IF;
116:
117: WSH_SHIPPING_PARAMS_PVT.get_global_parameters(
118: x_param_info => l_global_param_info,

Line 122: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters: ' || l_return_status);

118: x_param_info => l_global_param_info,
119: x_return_status => l_return_status);
120:
121: IF l_debug_on THEN
122: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters: ' || l_return_status);
123: END IF;
124:
125: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
126: l_number_of_warnings := l_number_of_warnings + 1;

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

130: wsh_util_core.add_message(l_return_status,l_module_name);
131: x_return_status := l_return_status;
132: --
133: IF l_debug_on THEN
134: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
135: WSH_DEBUG_SV.pop(l_module_name);
136: END IF;
137: RETURN;
138: END IF;

Line 135: WSH_DEBUG_SV.pop(l_module_name);

131: x_return_status := l_return_status;
132: --
133: IF l_debug_on THEN
134: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
135: WSH_DEBUG_SV.pop(l_module_name);
136: END IF;
137: RETURN;
138: END IF;
139:

Line 160: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.Get',WSH_DEBUG_SV.C_PROC_LEVEL);

156: -- LSP PROJECT : end
157: --
158: --get net weight limit
159: IF l_debug_on THEN
160: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.Get',WSH_DEBUG_SV.C_PROC_LEVEL);
161: END IF;
162:
163: WSH_SHIPPING_PARAMS_PVT.get(
164: p_organization_id => p_detail_tab(i).organization_id,

Line 170: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_SHIPPING_PARAMS_PVT.Get: ' || l_return_status);

166: x_param_info => l_parameter_info,
167: x_return_status => l_return_status);
168:
169: IF l_debug_on THEN
170: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_SHIPPING_PARAMS_PVT.Get: ' || l_return_status);
171: END IF;
172:
173: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
174: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN

Line 188: wsh_debug_sv.log(l_module_name,'l_parameter_info.otm_enabled', l_parameter_info.otm_enabled );

184: l_number_of_warnings := l_number_of_warnings + 1;
185: END IF;
186:
187: IF l_debug_on THEN
188: wsh_debug_sv.log(l_module_name,'l_parameter_info.otm_enabled', l_parameter_info.otm_enabled );
189: END IF;
190:
191: --Added the outer if condition to check OTM enabled at org level.
192: IF l_parameter_info.otm_enabled = 'Y' THEN --OTM R12 Org-Specific

Line 196: wsh_debug_sv.log(l_module_name,

192: IF l_parameter_info.otm_enabled = 'Y' THEN --OTM R12 Org-Specific
193: --{
194: IF l_debug_on THEN
195: -- muom + 16597177
196: wsh_debug_sv.log(l_module_name,
197: 'Processing Detail',
198: p_detail_tab(i).entity_id);
199: wsh_debug_sv.log(l_module_name,
200: 'Max Net Weight',

Line 199: wsh_debug_sv.log(l_module_name,

195: -- muom + 16597177
196: wsh_debug_sv.log(l_module_name,
197: 'Processing Detail',
198: p_detail_tab(i).entity_id);
199: wsh_debug_sv.log(l_module_name,
200: 'Max Net Weight',
201: l_parameter_info.max_net_weight);
202: wsh_debug_sv.log(l_module_name,
203: 'Global UOM',

Line 202: wsh_debug_sv.log(l_module_name,

198: p_detail_tab(i).entity_id);
199: wsh_debug_sv.log(l_module_name,
200: 'Max Net Weight',
201: l_parameter_info.max_net_weight);
202: wsh_debug_sv.log(l_module_name,
203: 'Global UOM',
204: l_global_param_info.GU_WEIGHT_UOM);
205: wsh_debug_sv.log(l_module_name,
206: 'detail uom',

Line 205: wsh_debug_sv.log(l_module_name,

201: l_parameter_info.max_net_weight);
202: wsh_debug_sv.log(l_module_name,
203: 'Global UOM',
204: l_global_param_info.GU_WEIGHT_UOM);
205: wsh_debug_sv.log(l_module_name,
206: 'detail uom',
207: p_detail_tab(i).weight_uom);
208: END IF;
209:

Line 239: wsh_debug_sv.log(l_module_name,

235: quantity => l_parameter_info.MAX_NET_WEIGHT);
236: END IF;
237:
238: IF l_debug_on THEN
239: wsh_debug_sv.log(l_module_name,
240: 'Converted Max Net Weight',
241: l_parameter_info.max_net_weight);
242:
243: wsh_debug_sv.log(l_module_name,

Line 243: wsh_debug_sv.log(l_module_name,

239: wsh_debug_sv.log(l_module_name,
240: 'Converted Max Net Weight',
241: l_parameter_info.max_net_weight);
242:
243: wsh_debug_sv.log(l_module_name,
244: 'Detail Weight',
245: NVL(p_detail_tab(i).net_weight, 0));
246: END IF;
247:

Line 263: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_DECIMAL_QUANTITY',WSH_DEBUG_SV.C_PROC_LEVEL);

259: --number of split needed idealy
260: l_num_split := FLOOR(p_detail_tab(i).net_weight/l_parameter_info.MAX_NET_WEIGHT);
261:
262: IF l_debug_on THEN
263: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_DECIMAL_QUANTITY',WSH_DEBUG_SV.C_PROC_LEVEL);
264: WSH_DEBUG_SV.log(l_module_name, 'l_max_quantity', l_max_quantity);
265: WSH_DEBUG_SV.log(l_module_name, 'l_num_split', l_num_split);
266: END IF;
267:

Line 264: WSH_DEBUG_SV.log(l_module_name, 'l_max_quantity', l_max_quantity);

260: l_num_split := FLOOR(p_detail_tab(i).net_weight/l_parameter_info.MAX_NET_WEIGHT);
261:
262: IF l_debug_on THEN
263: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_DECIMAL_QUANTITY',WSH_DEBUG_SV.C_PROC_LEVEL);
264: WSH_DEBUG_SV.log(l_module_name, 'l_max_quantity', l_max_quantity);
265: WSH_DEBUG_SV.log(l_module_name, 'l_num_split', l_num_split);
266: END IF;
267:
268: WSH_DETAILS_VALIDATIONS.check_decimal_quantity(

Line 265: WSH_DEBUG_SV.log(l_module_name, 'l_num_split', l_num_split);

261:
262: IF l_debug_on THEN
263: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_DECIMAL_QUANTITY',WSH_DEBUG_SV.C_PROC_LEVEL);
264: WSH_DEBUG_SV.log(l_module_name, 'l_max_quantity', l_max_quantity);
265: WSH_DEBUG_SV.log(l_module_name, 'l_num_split', l_num_split);
266: END IF;
267:
268: WSH_DETAILS_VALIDATIONS.check_decimal_quantity(
269: p_item_id => p_detail_tab(i).item_id,

Line 277: wsh_debug_sv.log(l_module_name,

273: x_output_quantity => l_quantity,
274: x_return_status => l_return_status);
275:
276: IF l_debug_on THEN
277: wsh_debug_sv.log(l_module_name,
278: 'check decimal quantity return status',
279: l_return_status);
280: WSH_DEBUG_SV.log(l_module_name, 'l_quantity', l_quantity);
281: END IF;

Line 280: WSH_DEBUG_SV.log(l_module_name, 'l_quantity', l_quantity);

276: IF l_debug_on THEN
277: wsh_debug_sv.log(l_module_name,
278: 'check decimal quantity return status',
279: l_return_status);
280: WSH_DEBUG_SV.log(l_module_name, 'l_quantity', l_quantity);
281: END IF;
282:
283: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
284: RAISE split_error;

Line 317: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);

313: -- muom + 16597177: Derive Secondary Quantity from Calculated Primary Quantity
314: l_max_quantity2 := null;
315: IF l_requested_quantity_uom2 is not null THEN
316: IF l_debug_on THEN
317: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
318: END IF;
319: l_max_quantity2 := wsh_wv_utils.convert_uom(
320: from_uom => l_requested_quantity_uom,
321: to_uom => l_requested_quantity_uom2,

Line 326: WSH_DEBUG_SV.logmsg(l_module_name,'l_max_quantity2 is '||l_max_quantity2);

322: quantity => l_max_quantity,
323: item_id => p_detail_tab(i).item_id,
324: org_id => p_detail_tab(i).organization_id);
325: IF l_debug_on THEN
326: WSH_DEBUG_SV.logmsg(l_module_name,'l_max_quantity2 is '||l_max_quantity2);
327: END IF;
328: END IF;
329:
330: IF l_debug_on THEN

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

327: END IF;
328: END IF;
329:
330: IF l_debug_on THEN
331: WSH_DEBUG_SV.log(l_module_name, 'l_num_split', l_num_split);
332: END IF;
333:
334: IF (l_num_split = 0) THEN
335: RAISE split_error;

Line 342: WSH_DEBUG_SV.logmsg(l_module_name,

338: l_dd_id_tab.DELETE;
339: l_new_detail_id := NULL;
340:
341: IF l_debug_on THEN
342: WSH_DEBUG_SV.logmsg(l_module_name,
343: 'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.SPLIT_DELIVERY_DETAILS_BULK',
344: WSH_DEBUG_SV.C_PROC_LEVEL);
345: WSH_DEBUG_SV.log(l_module_name, 'l_num_split', l_num_split);
346: END IF;

Line 344: WSH_DEBUG_SV.C_PROC_LEVEL);

340:
341: IF l_debug_on THEN
342: WSH_DEBUG_SV.logmsg(l_module_name,
343: 'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.SPLIT_DELIVERY_DETAILS_BULK',
344: WSH_DEBUG_SV.C_PROC_LEVEL);
345: WSH_DEBUG_SV.log(l_module_name, 'l_num_split', l_num_split);
346: END IF;
347:
348: WSH_DELIVERY_DETAILS_ACTIONS.split_delivery_details_bulk (

Line 345: WSH_DEBUG_SV.log(l_module_name, 'l_num_split', l_num_split);

341: IF l_debug_on THEN
342: WSH_DEBUG_SV.logmsg(l_module_name,
343: 'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.SPLIT_DELIVERY_DETAILS_BULK',
344: WSH_DEBUG_SV.C_PROC_LEVEL);
345: WSH_DEBUG_SV.log(l_module_name, 'l_num_split', l_num_split);
346: END IF;
347:
348: WSH_DELIVERY_DETAILS_ACTIONS.split_delivery_details_bulk (
349: p_from_detail_id => p_detail_tab(i).entity_id,

Line 360: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_DELIVERY_DETAILS_ACTIONS.SPLIT_DELIVERY_DETAILS_BULK: ' || l_return_status);

356: x_return_status => l_return_status
357: );
358:
359: IF l_debug_on THEN
360: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_DELIVERY_DETAILS_ACTIONS.SPLIT_DELIVERY_DETAILS_BULK: ' || l_return_status);
361: END IF;
362:
363: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
364: RAISE split_error;

Line 394: WSH_DEBUG_SV.logmsg(l_module_name,

390:
391: l_exception_id := NULL;
392:
393: IF l_debug_on THEN
394: WSH_DEBUG_SV.logmsg(l_module_name,
395: 'Calling program unit WSH_XC_UTIL.LOG_EXCEPTION',
396: WSH_DEBUG_SV.C_PROC_LEVEL);
397: END IF;
398:

Line 396: WSH_DEBUG_SV.C_PROC_LEVEL);

392:
393: IF l_debug_on THEN
394: WSH_DEBUG_SV.logmsg(l_module_name,
395: 'Calling program unit WSH_XC_UTIL.LOG_EXCEPTION',
396: WSH_DEBUG_SV.C_PROC_LEVEL);
397: END IF;
398:
399: WSH_XC_UTIL.log_exception(
400: p_api_version => 1.0,

Line 415: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_XC_UTIL.log_exception: ' || l_return_status);

411: p_message => SUBSTRB(l_exception_message,1,2000)
412: );
413:
414: IF l_debug_on THEN
415: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_XC_UTIL.log_exception: ' || l_return_status);
416: END IF;
417:
418: IF l_debug_on THEN
419: wsh_debug_sv.logmsg(l_module_name,

Line 419: wsh_debug_sv.logmsg(l_module_name,

415: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_XC_UTIL.log_exception: ' || l_return_status);
416: END IF;
417:
418: IF l_debug_on THEN
419: wsh_debug_sv.logmsg(l_module_name,
420: 'WSH_DELIVERY_DETAILS_SPLITTER.TMS_DELIVERY_DETAIL_SPLIT exception has occured ',
421: wsh_debug_sv.c_excep_level);
422: END IF;
423:

Line 421: wsh_debug_sv.c_excep_level);

417:
418: IF l_debug_on THEN
419: wsh_debug_sv.logmsg(l_module_name,
420: 'WSH_DELIVERY_DETAILS_SPLITTER.TMS_DELIVERY_DETAIL_SPLIT exception has occured ',
421: wsh_debug_sv.c_excep_level);
422: END IF;
423:
424: END;
425:

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

439: --
440: -- Debug Statements
441: --
442: IF l_debug_on THEN
443: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
444: WSH_DEBUG_SV.pop(l_module_name);
445: END IF;
446: --
447: EXCEPTION

Line 444: WSH_DEBUG_SV.pop(l_module_name);

440: -- Debug Statements
441: --
442: IF l_debug_on THEN
443: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
444: WSH_DEBUG_SV.pop(l_module_name);
445: END IF;
446: --
447: EXCEPTION
448:

Line 454: WSH_DEBUG_SV.logmsg(l_module_name,

450: --
451: WSH_UTIL_CORE.default_handler(
452: 'WSH_DELIVERY_DETAILS_SPLITTER.TMS_DELIVERY_DETAIL_SPLIT', l_module_name);
453: IF l_debug_on THEN
454: WSH_DEBUG_SV.logmsg(l_module_name,
455: 'Unexpected error has occured. Oracle error message is '||
456: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
457: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
458: END IF;

Line 456: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

452: 'WSH_DELIVERY_DETAILS_SPLITTER.TMS_DELIVERY_DETAIL_SPLIT', l_module_name);
453: IF l_debug_on THEN
454: WSH_DEBUG_SV.logmsg(l_module_name,
455: 'Unexpected error has occured. Oracle error message is '||
456: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
457: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
458: END IF;
459: END TMS_DELIVERY_DETAIL_SPLIT;
460:

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

453: IF l_debug_on THEN
454: WSH_DEBUG_SV.logmsg(l_module_name,
455: 'Unexpected error has occured. Oracle error message is '||
456: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
457: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
458: END IF;
459: END TMS_DELIVERY_DETAIL_SPLIT;
460:
461: END WSH_DELIVERY_DETAILS_SPLITTER;