eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_NEW_DELIVERY_ACTIONS dependencies on WSH_TRIPS

Line 1748: wsh_trips t

1744: t.name
1745: FROM wsh_new_deliveries dl,
1746: wsh_delivery_legs dg,
1747: wsh_trip_stops st,
1748: wsh_trips t
1749: WHERE dl.delivery_id = p_delivery_id AND
1750: dl.delivery_id = dg.delivery_id AND
1751: dg.pick_up_stop_id = st.stop_id AND
1752: st.trip_id = t.trip_id;

Line 2248: wsh_trips wt

2244: SELECT wt.ship_method_code
2245: FROM wsh_new_deliveries del,
2246: wsh_delivery_legs dlg,
2247: wsh_trip_stops st,
2248: wsh_trips wt
2249: WHERE del.delivery_id = dlg.delivery_id
2250: AND dlg.pick_up_stop_id = st.stop_id
2251: AND del.initial_pickup_location_id = st.stop_location_id
2252: AND st.trip_id = wt.trip_id

Line 2617: FROM wsh_delivery_legs wdl, wsh_trip_stops wts, wsh_trips wt

2613: SELECT wt.trip_id , wt.carrier_id, wt.ship_method_code, wt.mode_of_transport,
2614: --OTM R12
2615: wt.tp_plan_name
2616: --
2617: FROM wsh_delivery_legs wdl, wsh_trip_stops wts, wsh_trips wt
2618: WHERE wdl.pick_up_stop_id=wts.stop_id
2619: AND wdl.delivery_id=v_del_id
2620: AND wts.trip_id=wt.trip_id;
2621:

Line 2689: from wsh_trips wt

2685:
2686: --bugfix 3925963
2687: CURSOR get_trip_name_csr (p_first_trip_id NUMBER) IS
2688: Select wt.name
2689: from wsh_trips wt
2690: where wt.trip_id = p_first_trip_id;
2691:
2692: --bug 3314353 -- jckwok
2693: CURSOR stop_sequence_number_csr (p_stop_id IN NUMBER) IS

Line 2918: l_trip_rec WSH_TRIPS_PVT.trip_rec_type;

2914: l_confirm_del_cnt NUMBER := 0;
2915:
2916: /*new variable */
2917: l_stop_rec WSH_TRIP_STOPS_PVT.trip_stop_rec_type;
2918: l_trip_rec WSH_TRIPS_PVT.trip_rec_type;
2919: -- bug 2263249
2920: l_wms_enabled_flag BOOLEAN;
2921: -- bug 2343058
2922: l_check_credit_init_flag BOOLEAN;

Line 2940: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;

2936: l_cc_failed_records WSH_FTE_COMP_CONSTRAINT_PKG.failed_line_tab_type;
2937: l_cc_group_info WSH_FTE_COMP_CONSTRAINT_PKG.cc_group_tab_type;
2938: l_cc_line_groups WSH_FTE_COMP_CONSTRAINT_PKG.line_group_tab_type;
2939:
2940: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
2941: l_trip_id_tab_temp wsh_util_core.id_tab_type;
2942: l_cc_count_success NUMBER;
2943: b_cc_linefailed BOOLEAN;
2944: l_target_trip_id NUMBER;

Line 2951: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;

2947:
2948: --dummy tables for calling validate_constraint_wrapper
2949: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
2950: l_cc_det_attr_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
2951: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
2952: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
2953: l_cc_in_ids wsh_util_core.id_tab_type;
2954: l_cc_fail_ids wsh_util_core.id_tab_type;
2955: l_cc_carrier_id NUMBER;

Line 3088: l_otm_trip_id WSH_TRIPS.TRIP_ID%TYPE;

3084:
3085: --OTM R12
3086: l_ignore_for_planning WSH_NEW_DELIVERIES.IGNORE_FOR_PLANNING%TYPE;
3087: l_tms_interface_flag WSH_NEW_DELIVERIES.TMS_INTERFACE_FLAG%TYPE;
3088: l_otm_trip_id WSH_TRIPS.TRIP_ID%TYPE;
3089: l_otm_carrier_id WSH_NEW_DELIVERIES.CARRIER_ID%TYPE;
3090: l_otm_ship_method_code WSH_NEW_DELIVERIES.SHIP_METHOD_CODE%TYPE;
3091: l_otm_mode WSH_NEW_DELIVERIES.MODE_OF_TRANSPORT%TYPE;
3092: l_otm_plan_name WSH_TRIPS.TP_PLAN_NAME%TYPE;

Line 3092: l_otm_plan_name WSH_TRIPS.TP_PLAN_NAME%TYPE;

3088: l_otm_trip_id WSH_TRIPS.TRIP_ID%TYPE;
3089: l_otm_carrier_id WSH_NEW_DELIVERIES.CARRIER_ID%TYPE;
3090: l_otm_ship_method_code WSH_NEW_DELIVERIES.SHIP_METHOD_CODE%TYPE;
3091: l_otm_mode WSH_NEW_DELIVERIES.MODE_OF_TRANSPORT%TYPE;
3092: l_otm_plan_name WSH_TRIPS.TP_PLAN_NAME%TYPE;
3093: l_gc3_is_installed VARCHAR2(1);
3094: --
3095:
3096: l_debug_on BOOLEAN;

Line 5758: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.AUTOCREATE_TRIP',WSH_DEBUG_SV.C_PROC_LEVEL);

5754: --
5755: -- Debug Statements
5756: --
5757: IF l_debug_on THEN
5758: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.AUTOCREATE_TRIP',WSH_DEBUG_SV.C_PROC_LEVEL);
5759: END IF;
5760: --
5761:
5762: --heali :Shipment Advice change for trip Consolidation.

Line 5764: wsh_trips_actions.autocreate_trip(

5760: --
5761:
5762: --heali :Shipment Advice change for trip Consolidation.
5763: IF (p_autocreate_trip_flag = 'Y' ) THEN
5764: wsh_trips_actions.autocreate_trip(
5765: p_del_rows => l_del_rows,
5766: x_trip_id => l_trip_id,
5767: x_trip_name => l_trip_name,
5768: x_return_status => l_return_status,

Line 5879: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit wsh_trips_pvt.get_name',WSH_DEBUG_SV.C_PROC_LEVEL);

5875: IF l_return_status=wsh_util_core.g_ret_sts_error THEN
5876: IF l_cc_fail_ids.COUNT>0 THEN
5877:
5878: IF l_debug_on THEN
5879: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit wsh_trips_pvt.get_name',WSH_DEBUG_SV.C_PROC_LEVEL);
5880: END IF;
5881:
5882: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_COMP_FAILED');
5883: FND_MESSAGE.SET_TOKEN('TRIP_ID',wsh_trips_pvt.get_name(l_cc_fail_ids(1)));

Line 5883: FND_MESSAGE.SET_TOKEN('TRIP_ID',wsh_trips_pvt.get_name(l_cc_fail_ids(1)));

5879: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit wsh_trips_pvt.get_name',WSH_DEBUG_SV.C_PROC_LEVEL);
5880: END IF;
5881:
5882: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_COMP_FAILED');
5883: FND_MESSAGE.SET_TOKEN('TRIP_ID',wsh_trips_pvt.get_name(l_cc_fail_ids(1)));
5884: x_return_status := l_return_status;
5885: wsh_util_core.add_message(x_return_status);
5886: goto confirm_error;
5887: ELSE

Line 5942: WSH_TRIPS_PVT.lock_trip_no_compare(l_del_first_trip);

5938: END IF;
5939:
5940: BEGIN
5941:
5942: WSH_TRIPS_PVT.lock_trip_no_compare(l_del_first_trip);
5943:
5944: EXCEPTION
5945:
5946: WHEN app_exception.application_exception OR app_exception.record_lock_exception THEN

Line 5955: UPDATE wsh_trips

5951: goto confirm_error;
5952:
5953: END;
5954:
5955: UPDATE wsh_trips
5956: SET ship_method_code = p_ship_method,
5957: service_level = l_carrier_rec.service_level,
5958: mode_of_transport = l_carrier_rec.mode_of_transport,
5959: carrier_id = l_carrier_rec.carrier_id

Line 5981: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_GRP.GET_TRIP_DETAILS_PVT',WSH_DEBUG_SV.C_PROC_LEVEL);

5977: --
5978: -- Debug Statements
5979: --
5980: IF l_debug_on THEN
5981: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_GRP.GET_TRIP_DETAILS_PVT',WSH_DEBUG_SV.C_PROC_LEVEL);
5982: END IF;
5983: --
5984: wsh_trips_grp.get_trip_details_pvt
5985: (p_trip_id => l_trip_id,

Line 5984: wsh_trips_grp.get_trip_details_pvt

5980: IF l_debug_on THEN
5981: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_GRP.GET_TRIP_DETAILS_PVT',WSH_DEBUG_SV.C_PROC_LEVEL);
5982: END IF;
5983: --
5984: wsh_trips_grp.get_trip_details_pvt
5985: (p_trip_id => l_trip_id,
5986: x_trip_rec => l_trip_rec,
5987: x_return_status => l_return_status);
5988: IF l_return_status <>WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

Line 6117: UPDATE wsh_trips

6113: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6114: goto confirm_error;
6115: END IF;
6116:
6117: UPDATE wsh_trips
6118: SET ship_method_code = p_ship_method,
6119: service_level = l_carrier_rec.service_level,
6120: mode_of_transport = l_carrier_rec.mode_of_transport,
6121: carrier_id = l_carrier_rec.carrier_id

Line 9840: l_trip_rec WSH_TRIPS_PVT.TRIP_REC_TYPE;

9836: l_success_trip_ids wsh_util_core.id_tab_type;
9837: -- End of J+ Internal Location
9838: l_stop_rec WSH_TRIP_STOPS_PVT.TRIP_STOP_REC_TYPE;
9839: l_pub_stop_rec WSH_TRIP_STOPS_PUB.TRIP_STOP_PUB_REC_TYPE;
9840: l_trip_rec WSH_TRIPS_PVT.TRIP_REC_TYPE;
9841: --
9842: l_debug_on BOOLEAN;
9843: --
9844: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || g_pkg_name || '.' || 'update_ship_from_location';

Line 10024: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.Handle_Internal_Stops',WSH_DEBUG_SV.C_PROC_LEVEL);

10020: -- Call Handle Internal Stops API to link the stops
10021: l_trip_id_tab(1) := l_stop_rec.trip_id;
10022: IF l_debug_on THEN
10023: wsh_debug_sv.log(l_module_name,'trip_id' , l_stop_rec.trip_id);
10024: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.Handle_Internal_Stops',WSH_DEBUG_SV.C_PROC_LEVEL);
10025: END IF;
10026:
10027: WSH_TRIPS_ACTIONS.Handle_Internal_Stops(
10028: p_trip_ids => l_trip_id_tab,

Line 10027: WSH_TRIPS_ACTIONS.Handle_Internal_Stops(

10023: wsh_debug_sv.log(l_module_name,'trip_id' , l_stop_rec.trip_id);
10024: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.Handle_Internal_Stops',WSH_DEBUG_SV.C_PROC_LEVEL);
10025: END IF;
10026:
10027: WSH_TRIPS_ACTIONS.Handle_Internal_Stops(
10028: p_trip_ids => l_trip_id_tab,
10029: p_caller => 'WSH_UPDATE_SHIP_FROM_LOC',
10030: x_success_trip_ids => l_success_trip_ids,
10031: x_return_status => l_return_status);

Line 10308: FROM wsh_trips

10304: AND d.parent_delivery_leg_id IS NULL;
10305:
10306: CURSOR check_trip_lane(x_trip_id NUMBER) IS
10307: SELECT lane_id
10308: FROM wsh_trips
10309: WHERE trip_id = x_trip_id;
10310:
10311: BEGIN
10312:

Line 11061: -- x_trip_info_tab OUT NOCOPY WSH_TRIPS_PVT.Trip_Attr_Tbl_Type

11057: -- p_org_del_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers --
11058: -- p_trip_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers --
11059: -- --
11060: -- PARAMETERS (OUT): x_rec_attr_tab OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type --
11061: -- x_trip_info_tab OUT NOCOPY WSH_TRIPS_PVT.Trip_Attr_Tbl_Type
11062: --
11063: --
11064: -- RETURN: none --
11065: -- --

Line 11092: x_trip_info_tab OUT NOCOPY WSH_TRIPS_PVT.Trip_Attr_Tbl_Type,

11088: PROCEDURE FORMAT_DEL_UPDATE_TABLE(--p_cs_result_tab IN FTE_ACS_PKG.FTE_CS_RESULT_TAB_TYPE,
11089: p_cs_result_tab IN WSH_FTE_INTEGRATION.WSH_CS_RESULT_TAB_TYPE,
11090: p_caller IN VARCHAR2 DEFAULT NULL,
11091: x_rec_attr_tab OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,
11092: x_trip_info_tab OUT NOCOPY WSH_TRIPS_PVT.Trip_Attr_Tbl_Type,
11093: x_return_message OUT NOCOPY VARCHAR2,
11094: x_return_status OUT NOCOPY VARCHAR2) IS
11095:
11096: fmc NUMBER;

Line 11108: l_ignore_for_planning WSH_TRIPS.ignore_for_planning%TYPE;

11104: l_del_org_id NUMBER;
11105: l_prev_org_id NUMBER;
11106: l_skip_rtng_rule_ac_trip VARCHAR2(1) := 'N';
11107: l_param_value_info WSH_SHIPPING_PARAMS_PVT.PARAMETER_VALUE_REC_TYP;
11108: l_ignore_for_planning WSH_TRIPS.ignore_for_planning%TYPE;
11109: --
11110: l_debug_on BOOLEAN;
11111: --
11112: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'FORMAT_DEL_UPDATE_TABLE';

Line 11620: wsh_trips wt

11616: select wts.trip_id,
11617: wt.rank_id
11618: from wsh_trip_stops wts,
11619: wsh_delivery_legs wdl,
11620: wsh_trips wt
11621: where wdl.delivery_id = p_del_id
11622: and wts.stop_id = wdl.pick_up_stop_id
11623: and wts.trip_id = wt.trip_id;
11624:

Line 11658: l_trip_in_rec WSH_TRIPS_GRP.tripInRecType;

11654: -- New variables added for new call to group constraint API to update delivery table
11655: --
11656:
11657: l_in_rec WSH_DELIVERIES_GRP.Del_In_Rec_Type;
11658: l_trip_in_rec WSH_TRIPS_GRP.tripInRecType;
11659: l_rec_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
11660: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
11661: l_trip_out_rec_tab WSH_TRIPS_GRP.Trip_Out_Tab_Type;
11662: l_del_out_rec_tab WSH_DELIVERIES_GRP.Del_Out_Tbl_Type;

Line 11660: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;

11656:
11657: l_in_rec WSH_DELIVERIES_GRP.Del_In_Rec_Type;
11658: l_trip_in_rec WSH_TRIPS_GRP.tripInRecType;
11659: l_rec_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
11660: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
11661: l_trip_out_rec_tab WSH_TRIPS_GRP.Trip_Out_Tab_Type;
11662: l_del_out_rec_tab WSH_DELIVERIES_GRP.Del_Out_Tbl_Type;
11663: l_msg_count NUMBER;
11664: l_msg_data VARCHAR2(2000);

Line 11661: l_trip_out_rec_tab WSH_TRIPS_GRP.Trip_Out_Tab_Type;

11657: l_in_rec WSH_DELIVERIES_GRP.Del_In_Rec_Type;
11658: l_trip_in_rec WSH_TRIPS_GRP.tripInRecType;
11659: l_rec_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
11660: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
11661: l_trip_out_rec_tab WSH_TRIPS_GRP.Trip_Out_Tab_Type;
11662: l_del_out_rec_tab WSH_DELIVERIES_GRP.Del_Out_Tbl_Type;
11663: l_msg_count NUMBER;
11664: l_msg_data VARCHAR2(2000);
11665: l_del_org_id NUMBER;

Line 12791: from wsh_trip_stops s1, wsh_trip_stops s2, wsh_delivery_legs l, wsh_new_deliveries d, wsh_trips t

12787: s1.planned_arrival_date pu_ar_date,
12788: s1.planned_departure_date pu_dep_date,
12789: s2.planned_arrival_date do_ar_date,
12790: s2.planned_departure_date do_dep_date
12791: from wsh_trip_stops s1, wsh_trip_stops s2, wsh_delivery_legs l, wsh_new_deliveries d, wsh_trips t
12792: where s1.stop_id = l.pick_up_stop_id
12793: and s2.stop_id = l.drop_off_stop_id
12794: and l.delivery_id = d.delivery_id
12795: and d.delivery_id = p_parent_del_id

Line 13009: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_TRIPS_ACTIONS.Unassign_Trip',WSH_DEBUG_SV.C_PROC_LEVEL);

13005:
13006: ELSE
13007: l_unassign_dels(1) := p_del_tab(i).delivery_id;
13008: IF l_debug_on THEN
13009: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_TRIPS_ACTIONS.Unassign_Trip',WSH_DEBUG_SV.C_PROC_LEVEL);
13010: END IF;
13011: WSH_TRIPS_ACTIONS.Unassign_Trip(p_del_rows => l_unassign_dels,
13012: p_trip_id => l_parent_trip_rec.trip_id,
13013: x_return_status => l_return_status);

Line 13011: WSH_TRIPS_ACTIONS.Unassign_Trip(p_del_rows => l_unassign_dels,

13007: l_unassign_dels(1) := p_del_tab(i).delivery_id;
13008: IF l_debug_on THEN
13009: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_TRIPS_ACTIONS.Unassign_Trip',WSH_DEBUG_SV.C_PROC_LEVEL);
13010: END IF;
13011: WSH_TRIPS_ACTIONS.Unassign_Trip(p_del_rows => l_unassign_dels,
13012: p_trip_id => l_parent_trip_rec.trip_id,
13013: x_return_status => l_return_status);
13014:
13015: wsh_util_core.api_post_call

Line 13215: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_TRIPS_ACTIONS.assign_trip for ignore plan = N',WSH_DEBUG_SV.C_PROC_LEVEL);

13211:
13212: END IF;
13213:
13214: IF l_debug_on THEN
13215: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_TRIPS_ACTIONS.assign_trip for ignore plan = N',WSH_DEBUG_SV.C_PROC_LEVEL);
13216: END IF;
13217: WSH_TRIPS_ACTIONS.assign_trip(
13218: p_del_rows => l_include_plan_dels,
13219: p_trip_id => l_trip_id_tab(1),

Line 13217: WSH_TRIPS_ACTIONS.assign_trip(

13213:
13214: IF l_debug_on THEN
13215: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_TRIPS_ACTIONS.assign_trip for ignore plan = N',WSH_DEBUG_SV.C_PROC_LEVEL);
13216: END IF;
13217: WSH_TRIPS_ACTIONS.assign_trip(
13218: p_del_rows => l_include_plan_dels,
13219: p_trip_id => l_trip_id_tab(1),
13220: p_pickup_stop_id => l_parent_trip_rec.pick_up_stop_id,
13221: p_dropoff_stop_id => l_parent_trip_rec.drop_off_stop_id,

Line 13266: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_TRIPS_ACTIONS.assign_trip for ignore plan = Y',WSH_DEBUG_SV.C_PROC_LEVEL);

13262: END IF;
13263: IF l_ignore_plan_dels.count > 0 THEN
13264:
13265: IF l_debug_on THEN
13266: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_TRIPS_ACTIONS.assign_trip for ignore plan = Y',WSH_DEBUG_SV.C_PROC_LEVEL);
13267: END IF;
13268:
13269: WSH_TRIPS_ACTIONS.assign_trip(
13270: p_del_rows => l_ignore_plan_dels,

Line 13269: WSH_TRIPS_ACTIONS.assign_trip(

13265: IF l_debug_on THEN
13266: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_TRIPS_ACTIONS.assign_trip for ignore plan = Y',WSH_DEBUG_SV.C_PROC_LEVEL);
13267: END IF;
13268:
13269: WSH_TRIPS_ACTIONS.assign_trip(
13270: p_del_rows => l_ignore_plan_dels,
13271: p_trip_id => l_trip_id_tab(1),
13272: p_pickup_stop_id => l_parent_trip_rec.pick_up_stop_id,
13273: p_dropoff_stop_id => l_parent_trip_rec.drop_off_stop_id,

Line 14384: l_trip_in_rec WSH_TRIPS_GRP.tripInRecType;

14380: l_del_tab wsh_util_core.id_tab_type;
14381: l_trip_tab wsh_util_core.id_tab_type;
14382:
14383:
14384: l_trip_in_rec WSH_TRIPS_GRP.tripInRecType;
14385: l_init_msg_list VARCHAR2(100);
14386: l_api_version_number NUMBER := 1.0;
14387: l_commit VARCHAR2(10);
14388: l_return_status VARCHAR2(1);

Line 14391: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;

14387: l_commit VARCHAR2(10);
14388: l_return_status VARCHAR2(1);
14389: l_msg_count NUMBER;
14390: l_msg_data VARCHAR2(2000);
14391: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
14392: l_trip_info_rec WSH_TRIPS_PVT.trip_rec_type;
14393: l_trip_out_rec_tab WSH_TRIPS_GRP.Trip_Out_Tab_Type;
14394: l_num_warnings NUMBER := 0;
14395: l_num_errors NUMBER := 0;

Line 14392: l_trip_info_rec WSH_TRIPS_PVT.trip_rec_type;

14388: l_return_status VARCHAR2(1);
14389: l_msg_count NUMBER;
14390: l_msg_data VARCHAR2(2000);
14391: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
14392: l_trip_info_rec WSH_TRIPS_PVT.trip_rec_type;
14393: l_trip_out_rec_tab WSH_TRIPS_GRP.Trip_Out_Tab_Type;
14394: l_num_warnings NUMBER := 0;
14395: l_num_errors NUMBER := 0;
14396: l_do_date DATE;

Line 14393: l_trip_out_rec_tab WSH_TRIPS_GRP.Trip_Out_Tab_Type;

14389: l_msg_count NUMBER;
14390: l_msg_data VARCHAR2(2000);
14391: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
14392: l_trip_info_rec WSH_TRIPS_PVT.trip_rec_type;
14393: l_trip_out_rec_tab WSH_TRIPS_GRP.Trip_Out_Tab_Type;
14394: l_num_warnings NUMBER := 0;
14395: l_num_errors NUMBER := 0;
14396: l_do_date DATE;
14397: i NUMBER;

Line 14429: WSH_TRIPS_ACTIONS.Unassign_Trip(

14425: -- delivery.
14426:
14427: FOR trip in c_second_leg(p_deliveries_tab(i)) LOOP
14428:
14429: WSH_TRIPS_ACTIONS.Unassign_Trip(
14430: p_del_rows => l_del_tab,
14431: p_trip_id => trip.trip_id,
14432: x_return_status => l_return_status);
14433:

Line 14459: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_GRP.Create_Update_Trip',WSH_DEBUG_SV.C_PROC_LEVEL);

14455:
14456: l_commit := FND_API.g_false;
14457: IF l_debug_on THEN
14458: WSH_DEBUG_SV.logmsg(l_module_name,'Creating deconsol trip');
14459: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_GRP.Create_Update_Trip',WSH_DEBUG_SV.C_PROC_LEVEL);
14460: END IF;
14461:
14462: WSH_TRIPS_GRP.Create_Update_Trip(
14463: p_api_version_number => l_api_version_number,

Line 14462: WSH_TRIPS_GRP.Create_Update_Trip(

14458: WSH_DEBUG_SV.logmsg(l_module_name,'Creating deconsol trip');
14459: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_GRP.Create_Update_Trip',WSH_DEBUG_SV.C_PROC_LEVEL);
14460: END IF;
14461:
14462: WSH_TRIPS_GRP.Create_Update_Trip(
14463: p_api_version_number => l_api_version_number,
14464: p_init_msg_list => l_init_msg_list,
14465: p_commit => l_commit,
14466: x_return_status => l_return_status,

Line 14484: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.assign_trip',WSH_DEBUG_SV.C_PROC_LEVEL);

14480: -- Assign delivery to trip
14481:
14482: IF l_debug_on THEN
14483: WSH_DEBUG_SV.logmsg(l_module_name,'Assigning to deconsol trip');
14484: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.assign_trip',WSH_DEBUG_SV.C_PROC_LEVEL);
14485: END IF;
14486:
14487:
14488: IF del.pu_date < del.do_date THEN

Line 14494: WSH_TRIPS_ACTIONS.assign_trip(

14490: ELSE
14491: l_do_date := del.pu_date + 1;
14492: END IF;
14493:
14494: WSH_TRIPS_ACTIONS.assign_trip(
14495: p_del_rows => l_del_tab,
14496: p_trip_id => l_trip_out_rec_tab(l_trip_out_rec_tab.FIRST).trip_id,
14497: p_pickup_location_id => del.pu_location,
14498: p_dropoff_location_id => del.do_location,