DBA Data[Home] [Help]

APPS.WSH_USA_INV_PVT dependencies on WSH_NEW_DELIVERIES_PVT

Line 249: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED;

245: ROLLBACK TO unassign_backorder_details;
246: l_num_errors := l_num_errors + 1;
247: GOTO next_record;
248: ELSIF (l_is_delivery_empty = 'Y') THEN
249: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED;
250: ELSIF (l_is_delivery_empty = 'N') THEN
251: l_interface_flag_tab(1) := NULL;
252: --Bug7608629
253: --removed code which checked for gross weight

Line 258: WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG(

254: --now irrespective of gross weight UPDATE_TMS_INTERFACE_FLAG will be called
255: END IF;
256:
257: IF l_call_update = 'Y' THEN
258: WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG(
259: p_delivery_id_tab => l_delivery_id_tab,
260: p_tms_interface_flag_tab => l_interface_flag_tab,
261: x_return_status => l_return_status);
262:

Line 265: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG');

261: x_return_status => l_return_status);
262:
263: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
264: IF l_debug_on THEN
265: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG');
266: END IF;
267: ROLLBACK TO unassign_backorder_details;
268: l_num_errors := l_num_errors + 1;
269: GOTO next_record;

Line 272: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error in WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG');

268: l_num_errors := l_num_errors + 1;
269: GOTO next_record;
270: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
271: IF l_debug_on THEN
272: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error in WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG');
273: END IF;
274: RAISE e_return;
275: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
276: IF l_debug_on THEN

Line 277: WSH_DEBUG_SV.logmsg(l_module_name,'Warning in WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG');

273: END IF;
274: RAISE e_return;
275: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
276: IF l_debug_on THEN
277: WSH_DEBUG_SV.logmsg(l_module_name,'Warning in WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG');
278: END IF;
279: l_num_warnings := l_num_warnings + 1;
280: END IF;
281: END IF;