DBA Data[Home] [Help]

APPS.WSH_DELIVERY_SPLITTER_PKG dependencies on WSH_NEW_DELIVERIES_PVT

Line 314: l_delivery_info WSH_NEW_DELIVERIES_PVT.DELIVERY_REC_TYPE;

310: l_return_status VARCHAR2(1);
311: l_msg_count NUMBER;
312: l_msg_data VARCHAR2(32767);
313:
314: l_delivery_info WSH_NEW_DELIVERIES_PVT.DELIVERY_REC_TYPE;
315: i NUMBER;
316: j NUMBER;
317: k NUMBER;
318: z NUMBER;

Line 458: l_delivery_info.tms_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED OR

454:
455: --accept all delete required or ignore for planning deliveries, no need to split
456: --Bug 7148914 added OR condition so that same flow is followed for delivery with tms_interface_flag 'DP'
457: IF (l_delivery_info.ignore_for_planning = 'Y' OR
458: l_delivery_info.tms_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED OR
459: l_delivery_info.tms_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS ) THEN
460:
461:
462: IF l_debug_on THEN

Line 459: l_delivery_info.tms_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS ) THEN

455: --accept all delete required or ignore for planning deliveries, no need to split
456: --Bug 7148914 added OR condition so that same flow is followed for delivery with tms_interface_flag 'DP'
457: IF (l_delivery_info.ignore_for_planning = 'Y' OR
458: l_delivery_info.tms_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED OR
459: l_delivery_info.tms_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS ) THEN
460:
461:
462: IF l_debug_on THEN
463: wsh_debug_sv.logmsg(l_module_name, 'accepted delivery ' || p_delivery_tab(i).entity_id || ' because ignore for planning, DR or DP status');

Line 1132: l_new_delivery_name := WSH_NEW_DELIVERIES_PVT.get_name(l_temp_ids(z)); --newly created delivery

1128: z := l_temp_ids.FIRST;
1129:
1130: WHILE z IS NOT NULL LOOP
1131:
1132: l_new_delivery_name := WSH_NEW_DELIVERIES_PVT.get_name(l_temp_ids(z)); --newly created delivery
1133:
1134: --logging tms exception for the new delivery
1135: IF l_debug_on THEN
1136: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit log_del_splitter_exception',WSH_DEBUG_SV.C_PROC_LEVEL);

Line 1247: l_new_delivery_name := WSH_NEW_DELIVERIES_PVT.get_name(l_temp_ids(z)); --newly created delivery

1243: z := l_temp_ids.FIRST;
1244:
1245: WHILE z IS NOT NULL LOOP
1246:
1247: l_new_delivery_name := WSH_NEW_DELIVERIES_PVT.get_name(l_temp_ids(z)); --newly created delivery
1248:
1249: --log tms exceptions for the new delivery
1250: IF l_debug_on THEN
1251: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit log_del_splitter_exception',WSH_DEBUG_SV.C_PROC_LEVEL);