8504: l_debug_on BOOLEAN;
8505:
8506: l_return_status VARCHAR2(1);
8507:
8508: l_wms_table WMS_SHIPPING_INTERFACE_GRP.g_delivery_detail_tbl;
8509: l_del_index NUMBER;
8510: l_dd_index NUMBER;
8511: l_dd_count NUMBER;
8512: l_indexes WSH_UTIL_CORE.ID_TAB_TYPE;
8583:
8584: IF l_wms_table.COUNT > 0 THEN
8585:
8586: IF l_debug_on THEN
8587: WSH_DEBUG_SV.logmsg(l_module_name,'Calling WMS_SHIPPING_INTERFACE_GRP.process_delivery_details',WSH_DEBUG_SV.C_PROC_LEVEL);
8588: END IF;
8589:
8590: WMS_SHIPPING_INTERFACE_GRP.process_delivery_details (
8591: p_api_version => 1.0,
8586: IF l_debug_on THEN
8587: WSH_DEBUG_SV.logmsg(l_module_name,'Calling WMS_SHIPPING_INTERFACE_GRP.process_delivery_details',WSH_DEBUG_SV.C_PROC_LEVEL);
8588: END IF;
8589:
8590: WMS_SHIPPING_INTERFACE_GRP.process_delivery_details (
8591: p_api_version => 1.0,
8592: p_action => WMS_SHIPPING_INTERFACE_GRP.g_action_unassign_delivery,
8593: p_delivery_detail_tbl => l_wms_table,
8594: x_return_status => l_return_status,
8588: END IF;
8589:
8590: WMS_SHIPPING_INTERFACE_GRP.process_delivery_details (
8591: p_api_version => 1.0,
8592: p_action => WMS_SHIPPING_INTERFACE_GRP.g_action_unassign_delivery,
8593: p_delivery_detail_tbl => l_wms_table,
8594: x_return_status => l_return_status,
8595: x_msg_count => l_msg_count,
8596: x_msg_data => l_msg_data);
8595: x_msg_count => l_msg_count,
8596: x_msg_data => l_msg_data);
8597:
8598: IF l_debug_on THEN
8599: WSH_DEBUG_SV.log(l_module_name,'WMS_SHIPPING_INTERFACE_GRP.process_delivery_details return_status',
8600: l_return_status);
8601: END IF;
8602:
8603: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
8698: END IF;
8699:
8700: IF l_wms_table.COUNT > 0 THEN --{
8701: IF l_debug_on THEN
8702: WSH_DEBUG_SV.logmsg(l_module_name,'Calling WMS_SHIPPING_INTERFACE_GRP.process_delivery_details',WSH_DEBUG_SV.C_PROC_LEVEL);
8703: END IF;
8704:
8705: WMS_SHIPPING_INTERFACE_GRP.process_delivery_details (
8706: p_api_version => 1.0,
8701: IF l_debug_on THEN
8702: WSH_DEBUG_SV.logmsg(l_module_name,'Calling WMS_SHIPPING_INTERFACE_GRP.process_delivery_details',WSH_DEBUG_SV.C_PROC_LEVEL);
8703: END IF;
8704:
8705: WMS_SHIPPING_INTERFACE_GRP.process_delivery_details (
8706: p_api_version => 1.0,
8707: p_action => WMS_SHIPPING_INTERFACE_GRP.g_action_unassign_delivery,
8708: p_delivery_detail_tbl => l_wms_table,
8709: x_return_status => l_return_status,
8703: END IF;
8704:
8705: WMS_SHIPPING_INTERFACE_GRP.process_delivery_details (
8706: p_api_version => 1.0,
8707: p_action => WMS_SHIPPING_INTERFACE_GRP.g_action_unassign_delivery,
8708: p_delivery_detail_tbl => l_wms_table,
8709: x_return_status => l_return_status,
8710: x_msg_count => l_msg_count,
8711: x_msg_data => l_msg_data);
8710: x_msg_count => l_msg_count,
8711: x_msg_data => l_msg_data);
8712:
8713: IF l_debug_on THEN
8714: WSH_DEBUG_SV.log(l_module_name,'WMS_SHIPPING_INTERFACE_GRP.process_delivery_details return_status',
8715: l_return_status);
8716: END IF;
8717:
8718: -- bug 4552612: issue #4