DBA Data[Home] [Help]

APPS.WSH_DELIVERY_LEGS_ACTIONS dependencies on WMS_SHIPPING_INTERFACE_GRP

Line 243: l_dlvy_trip_tbl WMS_SHIPPING_INTERFACE_GRP.g_dlvy_trip_tbl;

239: l_org_vol NUMBER;
240: l_trip_mode_of_transport VARCHAR2(30);
241: l_delivery_mode_of_transport VARCHAR2(30);
242: l_dummy_leg_id NUMBER;
243: l_dlvy_trip_tbl WMS_SHIPPING_INTERFACE_GRP.g_dlvy_trip_tbl;
244: l_msg_count NUMBER;
245: l_msg_data VARCHAR2(2000);
246:
247: bad_trip_stop EXCEPTION;

Line 1936: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WMS_SHIPPING_INTERFACE_GRP.Process_Delivery_Trip',WSH_DEBUG_SV.C_PROC_LEVEL);

1932: -- Call wms to check if assignment is valid
1933: l_dlvy_trip_tbl(1).delivery_id := l_del_rows(i);
1934: l_dlvy_trip_tbl(1).trip_id := p_trip_id;
1935: IF l_debug_on THEN
1936: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WMS_SHIPPING_INTERFACE_GRP.Process_Delivery_Trip',WSH_DEBUG_SV.C_PROC_LEVEL);
1937: WSH_DEBUG_SV.log(l_module_name,'trip_id',p_trip_id);
1938: WSH_DEBUG_SV.log(l_module_name,'del_id',l_del_rows(i));
1939: END IF;
1940: WMS_SHIPPING_INTERFACE_GRP.Process_Delivery_Trip(

Line 1940: WMS_SHIPPING_INTERFACE_GRP.Process_Delivery_Trip(

1936: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WMS_SHIPPING_INTERFACE_GRP.Process_Delivery_Trip',WSH_DEBUG_SV.C_PROC_LEVEL);
1937: WSH_DEBUG_SV.log(l_module_name,'trip_id',p_trip_id);
1938: WSH_DEBUG_SV.log(l_module_name,'del_id',l_del_rows(i));
1939: END IF;
1940: WMS_SHIPPING_INTERFACE_GRP.Process_Delivery_Trip(
1941: p_api_version => 1.0,
1942: p_init_msg_list => wms_shipping_interface_grp.g_false,
1943: p_commit => wms_shipping_interface_grp.g_false,
1944: p_validation_level => wms_shipping_interface_grp.g_full_validation,

Line 1942: p_init_msg_list => wms_shipping_interface_grp.g_false,

1938: WSH_DEBUG_SV.log(l_module_name,'del_id',l_del_rows(i));
1939: END IF;
1940: WMS_SHIPPING_INTERFACE_GRP.Process_Delivery_Trip(
1941: p_api_version => 1.0,
1942: p_init_msg_list => wms_shipping_interface_grp.g_false,
1943: p_commit => wms_shipping_interface_grp.g_false,
1944: p_validation_level => wms_shipping_interface_grp.g_full_validation,
1945: p_action => wms_shipping_interface_grp.g_action_assign_dlvy_trip,
1946: p_dlvy_trip_tbl => l_dlvy_trip_tbl,

Line 1943: p_commit => wms_shipping_interface_grp.g_false,

1939: END IF;
1940: WMS_SHIPPING_INTERFACE_GRP.Process_Delivery_Trip(
1941: p_api_version => 1.0,
1942: p_init_msg_list => wms_shipping_interface_grp.g_false,
1943: p_commit => wms_shipping_interface_grp.g_false,
1944: p_validation_level => wms_shipping_interface_grp.g_full_validation,
1945: p_action => wms_shipping_interface_grp.g_action_assign_dlvy_trip,
1946: p_dlvy_trip_tbl => l_dlvy_trip_tbl,
1947: x_return_status => l_return_status,

Line 1944: p_validation_level => wms_shipping_interface_grp.g_full_validation,

1940: WMS_SHIPPING_INTERFACE_GRP.Process_Delivery_Trip(
1941: p_api_version => 1.0,
1942: p_init_msg_list => wms_shipping_interface_grp.g_false,
1943: p_commit => wms_shipping_interface_grp.g_false,
1944: p_validation_level => wms_shipping_interface_grp.g_full_validation,
1945: p_action => wms_shipping_interface_grp.g_action_assign_dlvy_trip,
1946: p_dlvy_trip_tbl => l_dlvy_trip_tbl,
1947: x_return_status => l_return_status,
1948: x_msg_count => l_msg_count,

Line 1945: p_action => wms_shipping_interface_grp.g_action_assign_dlvy_trip,

1941: p_api_version => 1.0,
1942: p_init_msg_list => wms_shipping_interface_grp.g_false,
1943: p_commit => wms_shipping_interface_grp.g_false,
1944: p_validation_level => wms_shipping_interface_grp.g_full_validation,
1945: p_action => wms_shipping_interface_grp.g_action_assign_dlvy_trip,
1946: p_dlvy_trip_tbl => l_dlvy_trip_tbl,
1947: x_return_status => l_return_status,
1948: x_msg_count => l_msg_count,
1949: x_msg_data => l_msg_data);

Line 2946: l_dlvy_trip_tbl WMS_SHIPPING_INTERFACE_GRP.g_dlvy_trip_tbl;

2942: l_del_pu_location_id NUMBER;
2943: l_stop_pu_location_id NUMBER;
2944: l_org_id NUMBER;
2945: l_dummy_leg_id NUMBER;
2946: l_dlvy_trip_tbl WMS_SHIPPING_INTERFACE_GRP.g_dlvy_trip_tbl;
2947: l_msg_count NUMBER;
2948: l_msg_data VARCHAR2(2000);
2949: i NUMBER;
2950: l_del_leg_id NUMBER;

Line 3120: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WMS_SHIPPING_INTERFACE_GRP.Process_Delivery_Trip',WSH_DEBUG_SV.C_PROC_LEVEL);

3116: -- Call wms to check if unassignment is valid
3117: l_dlvy_trip_tbl(1).delivery_id := p_del_rows(i);
3118: l_dlvy_trip_tbl(1).trip_id := p_trip_id;
3119: IF l_debug_on THEN
3120: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WMS_SHIPPING_INTERFACE_GRP.Process_Delivery_Trip',WSH_DEBUG_SV.C_PROC_LEVEL);
3121: WSH_DEBUG_SV.log(l_module_name,'trip_id',p_trip_id);
3122: WSH_DEBUG_SV.log(l_module_name,'del_id',p_del_rows(i));
3123: END IF;
3124: WMS_SHIPPING_INTERFACE_GRP.Process_Delivery_Trip(

Line 3124: WMS_SHIPPING_INTERFACE_GRP.Process_Delivery_Trip(

3120: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WMS_SHIPPING_INTERFACE_GRP.Process_Delivery_Trip',WSH_DEBUG_SV.C_PROC_LEVEL);
3121: WSH_DEBUG_SV.log(l_module_name,'trip_id',p_trip_id);
3122: WSH_DEBUG_SV.log(l_module_name,'del_id',p_del_rows(i));
3123: END IF;
3124: WMS_SHIPPING_INTERFACE_GRP.Process_Delivery_Trip(
3125: p_api_version => 1.0,
3126: p_init_msg_list => wms_shipping_interface_grp.g_false,
3127: p_commit => wms_shipping_interface_grp.g_false,
3128: p_validation_level => wms_shipping_interface_grp.g_full_validation,

Line 3126: p_init_msg_list => wms_shipping_interface_grp.g_false,

3122: WSH_DEBUG_SV.log(l_module_name,'del_id',p_del_rows(i));
3123: END IF;
3124: WMS_SHIPPING_INTERFACE_GRP.Process_Delivery_Trip(
3125: p_api_version => 1.0,
3126: p_init_msg_list => wms_shipping_interface_grp.g_false,
3127: p_commit => wms_shipping_interface_grp.g_false,
3128: p_validation_level => wms_shipping_interface_grp.g_full_validation,
3129: p_action => wms_shipping_interface_grp.g_action_unassign_dlvy_trip,
3130: p_dlvy_trip_tbl => l_dlvy_trip_tbl,

Line 3127: p_commit => wms_shipping_interface_grp.g_false,

3123: END IF;
3124: WMS_SHIPPING_INTERFACE_GRP.Process_Delivery_Trip(
3125: p_api_version => 1.0,
3126: p_init_msg_list => wms_shipping_interface_grp.g_false,
3127: p_commit => wms_shipping_interface_grp.g_false,
3128: p_validation_level => wms_shipping_interface_grp.g_full_validation,
3129: p_action => wms_shipping_interface_grp.g_action_unassign_dlvy_trip,
3130: p_dlvy_trip_tbl => l_dlvy_trip_tbl,
3131: x_return_status => l_return_status,

Line 3128: p_validation_level => wms_shipping_interface_grp.g_full_validation,

3124: WMS_SHIPPING_INTERFACE_GRP.Process_Delivery_Trip(
3125: p_api_version => 1.0,
3126: p_init_msg_list => wms_shipping_interface_grp.g_false,
3127: p_commit => wms_shipping_interface_grp.g_false,
3128: p_validation_level => wms_shipping_interface_grp.g_full_validation,
3129: p_action => wms_shipping_interface_grp.g_action_unassign_dlvy_trip,
3130: p_dlvy_trip_tbl => l_dlvy_trip_tbl,
3131: x_return_status => l_return_status,
3132: x_msg_count => l_msg_count,

Line 3129: p_action => wms_shipping_interface_grp.g_action_unassign_dlvy_trip,

3125: p_api_version => 1.0,
3126: p_init_msg_list => wms_shipping_interface_grp.g_false,
3127: p_commit => wms_shipping_interface_grp.g_false,
3128: p_validation_level => wms_shipping_interface_grp.g_full_validation,
3129: p_action => wms_shipping_interface_grp.g_action_unassign_dlvy_trip,
3130: p_dlvy_trip_tbl => l_dlvy_trip_tbl,
3131: x_return_status => l_return_status,
3132: x_msg_count => l_msg_count,
3133: x_msg_data => l_msg_data);