APPS.WSH_OTM_INBOUND_GRP dependencies on WSH_TMS_RELEASE

Line 106: l_delivery_tab WSH_TMS_RELEASE.delivery_tab;

102: l_release_freight_currency WSH_UTIL_CORE.column_tab_type;
103: l_release_freight_del_id WSH_UTIL_CORE.column_tab_type;
104: l_release_freight_dint_id WSH_UTIL_CORE.id_tab_type;
105:
106: l_delivery_tab WSH_TMS_RELEASE.delivery_tab;
107: l_dummy_del_id_tab WSH_UTIL_CORE.id_tab_type;
108: l_return_status VARCHAR2(1);
109:
110: l_delivery_id VARCHAR2(32767) := NULL;

Line 114: l_interface_act_code VARCHAR2(30) := WSH_TMS_RELEASE.g_tms_release_code;

110: l_delivery_id VARCHAR2(32767) := NULL;
111: l_local_release_tab WSH_OTM_DEL_INTERFACES;
112: l_stop_loc_tab WSH_OTM_STOP_INTERFACES;
113:
114: l_interface_act_code VARCHAR2(30) := WSH_TMS_RELEASE.g_tms_release_code;
115: l_del_refnum NUMBER := NULL;
116: l_del_id_number NUMBER := 0;
117: l_release_id VARCHAR2(100);
118: l_dleg_pu_loc_id VARCHAR2(100);

Line 216: WSH_TMS_RELEASE.find_deliveries_for_trip(

212:
213: --IF nvl(p_int_trip_info(i).transaction_code,'CREATE') <> 'DELETE' THEN
214: IF nvl(p_int_trip_info(i).transaction_code,'CREATE') <> 'D' THEN
215:
216: WSH_TMS_RELEASE.find_deliveries_for_trip(
217: p_trip_id => NULL,
218: p_tp_plan_name => p_int_trip_info(i).shipment_xid,
219: x_delivery_tab => l_delivery_tab,
220: x_delivery_id_tab => l_dummy_del_id_tab,

Line 227: WSH_DEBUG_SV.logmsg(l_module_name,'Returned from WSH_TMS_RELEASE.FIND_DELIVERIES_FOR_TRIP x_return_status : '||l_return_status);

223: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
224: raise FND_API.G_EXC_UNEXPECTED_ERROR;
225: ELSE
226: IF l_debug_on THEN
227: WSH_DEBUG_SV.logmsg(l_module_name,'Returned from WSH_TMS_RELEASE.FIND_DELIVERIES_FOR_TRIP x_return_status : '||l_return_status);
228: WSH_DEBUG_SV.logmsg(l_module_name,'l_delivery_tab.COUNT : '||l_delivery_tab.COUNT);
229: END IF;
230:
231: END IF;

Line 374: l_interface_act_code := WSH_TMS_RELEASE.g_tms_delete_code;

370: GOTO next_trip;
371: END IF;
372:
373: ELSE
374: l_interface_act_code := WSH_TMS_RELEASE.g_tms_delete_code;
375: END IF; -- Transaction_code <> 'DELETE'
376:
377: --l_process_trip_cnt := l_process_trip_cnt + 1;
378:

Line 383: WSH_TMS_RELEASE.purge_interface_data(

379: -- Call purge_interface_tables API :
380: -- Delete if any record exits in interface tables for the input deliveries
381: -- What about the exceptions for those deliveries ? -- This API takes care
382:
383: WSH_TMS_RELEASE.purge_interface_data(
384: p_tp_plan_name => p_int_trip_info(i).shipment_xid,
385: p_commit_flag => 'N',
386: x_return_status => l_return_status);
387: