APPS.WSH_USA_INV_PVT dependencies on WSH_NEW_DELIVERIES_PVT

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

240: ROLLBACK TO unassign_backorder_details;
241: l_num_errors := l_num_errors + 1;
242: GOTO next_record;
243: ELSIF (l_is_delivery_empty = 'Y') THEN
244: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED;
245: ELSIF (l_is_delivery_empty = 'N') THEN
246: IF (NVL(p_backorder_rec_tbl(i).gross_weight, 0) = 0) THEN
247: -- do not update if assign/unassign 0/NULL weight line/LPN
248: -- to nonempty delivery

Line 258: WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG(

254: END IF;
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;