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 2257: wsh_trips wt

2253: SELECT wt.ship_method_code
2254: FROM wsh_new_deliveries del,
2255: wsh_delivery_legs dlg,
2256: wsh_trip_stops st,
2257: wsh_trips wt
2258: WHERE del.delivery_id = dlg.delivery_id
2259: AND dlg.pick_up_stop_id = st.stop_id
2260: AND del.initial_pickup_location_id = st.stop_location_id
2261: AND st.trip_id = wt.trip_id

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

2646: SELECT wt.trip_id , wt.carrier_id, wt.ship_method_code, wt.mode_of_transport,
2647: --OTM R12
2648: wt.tp_plan_name
2649: --
2650: FROM wsh_delivery_legs wdl, wsh_trip_stops wts, wsh_trips wt
2651: WHERE wdl.pick_up_stop_id=wts.stop_id
2652: AND wdl.delivery_id=v_del_id
2653: AND wts.trip_id=wt.trip_id;
2654:

Line 2722: from wsh_trips wt

2718:
2719: --bugfix 3925963
2720: CURSOR get_trip_name_csr (p_first_trip_id NUMBER) IS
2721: Select wt.name
2722: from wsh_trips wt
2723: where wt.trip_id = p_first_trip_id;
2724:
2725: --bug 3314353 -- jckwok
2726: CURSOR stop_sequence_number_csr (p_stop_id IN NUMBER) IS

Line 2956: l_trip_rec WSH_TRIPS_PVT.trip_rec_type;

2952: l_confirm_del_cnt NUMBER := 0;
2953:
2954: /*new variable */
2955: l_stop_rec WSH_TRIP_STOPS_PVT.trip_stop_rec_type;
2956: l_trip_rec WSH_TRIPS_PVT.trip_rec_type;
2957: -- bug 2263249
2958: l_wms_enabled_flag BOOLEAN;
2959: -- bug 2343058
2960: l_check_credit_init_flag BOOLEAN;

Line 2978: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;

2974: l_cc_failed_records WSH_FTE_COMP_CONSTRAINT_PKG.failed_line_tab_type;
2975: l_cc_group_info WSH_FTE_COMP_CONSTRAINT_PKG.cc_group_tab_type;
2976: l_cc_line_groups WSH_FTE_COMP_CONSTRAINT_PKG.line_group_tab_type;
2977:
2978: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
2979: l_trip_id_tab_temp wsh_util_core.id_tab_type;
2980: l_cc_count_success NUMBER;
2981: b_cc_linefailed BOOLEAN;
2982: l_target_trip_id NUMBER;

Line 2989: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;

2985:
2986: --dummy tables for calling validate_constraint_wrapper
2987: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
2988: l_cc_det_attr_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
2989: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
2990: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
2991: l_cc_in_ids wsh_util_core.id_tab_type;
2992: l_cc_fail_ids wsh_util_core.id_tab_type;
2993: l_cc_carrier_id NUMBER;

Line 3128: l_otm_trip_id WSH_TRIPS.TRIP_ID%TYPE;

3124:
3125: --OTM R12
3126: l_ignore_for_planning WSH_NEW_DELIVERIES.IGNORE_FOR_PLANNING%TYPE;
3127: l_tms_interface_flag WSH_NEW_DELIVERIES.TMS_INTERFACE_FLAG%TYPE;
3128: l_otm_trip_id WSH_TRIPS.TRIP_ID%TYPE;
3129: l_otm_carrier_id WSH_NEW_DELIVERIES.CARRIER_ID%TYPE;
3130: l_otm_ship_method_code WSH_NEW_DELIVERIES.SHIP_METHOD_CODE%TYPE;
3131: l_otm_mode WSH_NEW_DELIVERIES.MODE_OF_TRANSPORT%TYPE;
3132: l_otm_plan_name WSH_TRIPS.TP_PLAN_NAME%TYPE;

Line 3132: l_otm_plan_name WSH_TRIPS.TP_PLAN_NAME%TYPE;

3128: l_otm_trip_id WSH_TRIPS.TRIP_ID%TYPE;
3129: l_otm_carrier_id WSH_NEW_DELIVERIES.CARRIER_ID%TYPE;
3130: l_otm_ship_method_code WSH_NEW_DELIVERIES.SHIP_METHOD_CODE%TYPE;
3131: l_otm_mode WSH_NEW_DELIVERIES.MODE_OF_TRANSPORT%TYPE;
3132: l_otm_plan_name WSH_TRIPS.TP_PLAN_NAME%TYPE;
3133: l_gc3_is_installed VARCHAR2(1);
3134: --
3135: -- Bug 8555654 : begin
3136: l_period_id NUMBER;

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

5855: --
5856: -- Debug Statements
5857: --
5858: IF l_debug_on THEN
5859: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.AUTOCREATE_TRIP',WSH_DEBUG_SV.C_PROC_LEVEL);
5860: END IF;
5861: --
5862:
5863: --heali :Shipment Advice change for trip Consolidation.

Line 5865: wsh_trips_actions.autocreate_trip(

5861: --
5862:
5863: --heali :Shipment Advice change for trip Consolidation.
5864: IF (p_autocreate_trip_flag = 'Y' ) THEN
5865: wsh_trips_actions.autocreate_trip(
5866: p_del_rows => l_del_rows,
5867: x_trip_id => l_trip_id,
5868: x_trip_name => l_trip_name,
5869: x_return_status => l_return_status,

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

5976: IF l_return_status=wsh_util_core.g_ret_sts_error THEN
5977: IF l_cc_fail_ids.COUNT>0 THEN
5978:
5979: IF l_debug_on THEN
5980: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit wsh_trips_pvt.get_name',WSH_DEBUG_SV.C_PROC_LEVEL);
5981: END IF;
5982:
5983: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_COMP_FAILED');
5984: FND_MESSAGE.SET_TOKEN('TRIP_ID',wsh_trips_pvt.get_name(l_cc_fail_ids(1)));

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

5980: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit wsh_trips_pvt.get_name',WSH_DEBUG_SV.C_PROC_LEVEL);
5981: END IF;
5982:
5983: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_COMP_FAILED');
5984: FND_MESSAGE.SET_TOKEN('TRIP_ID',wsh_trips_pvt.get_name(l_cc_fail_ids(1)));
5985: x_return_status := l_return_status;
5986: wsh_util_core.add_message(x_return_status);
5987: goto confirm_error;
5988: ELSE

Line 6043: WSH_TRIPS_PVT.lock_trip_no_compare(l_del_first_trip);

6039: END IF;
6040:
6041: BEGIN
6042:
6043: WSH_TRIPS_PVT.lock_trip_no_compare(l_del_first_trip);
6044:
6045: EXCEPTION
6046:
6047: WHEN app_exception.application_exception OR app_exception.record_lock_exception THEN

Line 6056: UPDATE wsh_trips

6052: goto confirm_error;
6053:
6054: END;
6055:
6056: UPDATE wsh_trips
6057: SET ship_method_code = p_ship_method,
6058: service_level = l_carrier_rec.service_level,
6059: mode_of_transport = l_carrier_rec.mode_of_transport,
6060: carrier_id = l_carrier_rec.carrier_id

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

6078: --
6079: -- Debug Statements
6080: --
6081: IF l_debug_on THEN
6082: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_GRP.GET_TRIP_DETAILS_PVT',WSH_DEBUG_SV.C_PROC_LEVEL);
6083: END IF;
6084: --
6085: wsh_trips_grp.get_trip_details_pvt
6086: (p_trip_id => l_trip_id,

Line 6085: wsh_trips_grp.get_trip_details_pvt

6081: IF l_debug_on THEN
6082: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_GRP.GET_TRIP_DETAILS_PVT',WSH_DEBUG_SV.C_PROC_LEVEL);
6083: END IF;
6084: --
6085: wsh_trips_grp.get_trip_details_pvt
6086: (p_trip_id => l_trip_id,
6087: x_trip_rec => l_trip_rec,
6088: x_return_status => l_return_status);
6089: IF l_return_status <>WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

Line 6218: UPDATE wsh_trips

6214: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6215: goto confirm_error;
6216: END IF;
6217:
6218: UPDATE wsh_trips
6219: SET ship_method_code = p_ship_method,
6220: service_level = l_carrier_rec.service_level,
6221: mode_of_transport = l_carrier_rec.mode_of_transport,
6222: carrier_id = l_carrier_rec.carrier_id

Line 10036: l_trip_rec WSH_TRIPS_PVT.TRIP_REC_TYPE;

10032: l_success_trip_ids wsh_util_core.id_tab_type;
10033: -- End of J+ Internal Location
10034: l_stop_rec WSH_TRIP_STOPS_PVT.TRIP_STOP_REC_TYPE;
10035: l_pub_stop_rec WSH_TRIP_STOPS_PUB.TRIP_STOP_PUB_REC_TYPE;
10036: l_trip_rec WSH_TRIPS_PVT.TRIP_REC_TYPE;
10037: --
10038: l_debug_on BOOLEAN;
10039: --
10040: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || g_pkg_name || '.' || 'update_ship_from_location';

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

10216: -- Call Handle Internal Stops API to link the stops
10217: l_trip_id_tab(1) := l_stop_rec.trip_id;
10218: IF l_debug_on THEN
10219: wsh_debug_sv.log(l_module_name,'trip_id' , l_stop_rec.trip_id);
10220: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.Handle_Internal_Stops',WSH_DEBUG_SV.C_PROC_LEVEL);
10221: END IF;
10222:
10223: WSH_TRIPS_ACTIONS.Handle_Internal_Stops(
10224: p_trip_ids => l_trip_id_tab,

Line 10223: WSH_TRIPS_ACTIONS.Handle_Internal_Stops(

10219: wsh_debug_sv.log(l_module_name,'trip_id' , l_stop_rec.trip_id);
10220: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.Handle_Internal_Stops',WSH_DEBUG_SV.C_PROC_LEVEL);
10221: END IF;
10222:
10223: WSH_TRIPS_ACTIONS.Handle_Internal_Stops(
10224: p_trip_ids => l_trip_id_tab,
10225: p_caller => 'WSH_UPDATE_SHIP_FROM_LOC',
10226: x_success_trip_ids => l_success_trip_ids,
10227: x_return_status => l_return_status);

Line 10504: FROM wsh_trips

10500: AND d.parent_delivery_leg_id IS NULL;
10501:
10502: CURSOR check_trip_lane(x_trip_id NUMBER) IS
10503: SELECT lane_id
10504: FROM wsh_trips
10505: WHERE trip_id = x_trip_id;
10506:
10507: BEGIN
10508:

Line 11257: -- x_trip_info_tab OUT NOCOPY WSH_TRIPS_PVT.Trip_Attr_Tbl_Type

11253: -- p_org_del_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers --
11254: -- p_trip_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers --
11255: -- --
11256: -- PARAMETERS (OUT): x_rec_attr_tab OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type --
11257: -- x_trip_info_tab OUT NOCOPY WSH_TRIPS_PVT.Trip_Attr_Tbl_Type
11258: --
11259: --
11260: -- RETURN: none --
11261: -- --

Line 11288: x_trip_info_tab OUT NOCOPY WSH_TRIPS_PVT.Trip_Attr_Tbl_Type,

11284: PROCEDURE FORMAT_DEL_UPDATE_TABLE(--p_cs_result_tab IN FTE_ACS_PKG.FTE_CS_RESULT_TAB_TYPE,
11285: p_cs_result_tab IN WSH_FTE_INTEGRATION.WSH_CS_RESULT_TAB_TYPE,
11286: p_caller IN VARCHAR2 DEFAULT NULL,
11287: x_rec_attr_tab OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,
11288: x_trip_info_tab OUT NOCOPY WSH_TRIPS_PVT.Trip_Attr_Tbl_Type,
11289: x_return_message OUT NOCOPY VARCHAR2,
11290: x_return_status OUT NOCOPY VARCHAR2) IS
11291:
11292: fmc NUMBER;

Line 11304: l_ignore_for_planning WSH_TRIPS.ignore_for_planning%TYPE;

11300: l_del_org_id NUMBER;
11301: l_prev_org_id NUMBER;
11302: l_skip_rtng_rule_ac_trip VARCHAR2(1) := 'N';
11303: l_param_value_info WSH_SHIPPING_PARAMS_PVT.PARAMETER_VALUE_REC_TYP;
11304: l_ignore_for_planning WSH_TRIPS.ignore_for_planning%TYPE;
11305: --
11306: l_debug_on BOOLEAN;
11307: --
11308: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'FORMAT_DEL_UPDATE_TABLE';

Line 11816: wsh_trips wt

11812: select wts.trip_id,
11813: wt.rank_id
11814: from wsh_trip_stops wts,
11815: wsh_delivery_legs wdl,
11816: wsh_trips wt
11817: where wdl.delivery_id = p_del_id
11818: and wts.stop_id = wdl.pick_up_stop_id
11819: and wts.trip_id = wt.trip_id;
11820:

Line 11854: l_trip_in_rec WSH_TRIPS_GRP.tripInRecType;

11850: -- New variables added for new call to group constraint API to update delivery table
11851: --
11852:
11853: l_in_rec WSH_DELIVERIES_GRP.Del_In_Rec_Type;
11854: l_trip_in_rec WSH_TRIPS_GRP.tripInRecType;
11855: l_rec_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
11856: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
11857: l_trip_out_rec_tab WSH_TRIPS_GRP.Trip_Out_Tab_Type;
11858: l_del_out_rec_tab WSH_DELIVERIES_GRP.Del_Out_Tbl_Type;

Line 11856: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;

11852:
11853: l_in_rec WSH_DELIVERIES_GRP.Del_In_Rec_Type;
11854: l_trip_in_rec WSH_TRIPS_GRP.tripInRecType;
11855: l_rec_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
11856: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
11857: l_trip_out_rec_tab WSH_TRIPS_GRP.Trip_Out_Tab_Type;
11858: l_del_out_rec_tab WSH_DELIVERIES_GRP.Del_Out_Tbl_Type;
11859: l_msg_count NUMBER;
11860: l_msg_data VARCHAR2(2000);

Line 11857: l_trip_out_rec_tab WSH_TRIPS_GRP.Trip_Out_Tab_Type;

11853: l_in_rec WSH_DELIVERIES_GRP.Del_In_Rec_Type;
11854: l_trip_in_rec WSH_TRIPS_GRP.tripInRecType;
11855: l_rec_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
11856: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
11857: l_trip_out_rec_tab WSH_TRIPS_GRP.Trip_Out_Tab_Type;
11858: l_del_out_rec_tab WSH_DELIVERIES_GRP.Del_Out_Tbl_Type;
11859: l_msg_count NUMBER;
11860: l_msg_data VARCHAR2(2000);
11861: l_del_org_id NUMBER;

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

12984: s1.planned_arrival_date pu_ar_date,
12985: s1.planned_departure_date pu_dep_date,
12986: s2.planned_arrival_date do_ar_date,
12987: s2.planned_departure_date do_dep_date
12988: from wsh_trip_stops s1, wsh_trip_stops s2, wsh_delivery_legs l, wsh_new_deliveries d, wsh_trips t
12989: where s1.stop_id = l.pick_up_stop_id
12990: and s2.stop_id = l.drop_off_stop_id
12991: and l.delivery_id = d.delivery_id
12992: and d.delivery_id = p_parent_del_id

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

13202:
13203: ELSE
13204: l_unassign_dels(1) := p_del_tab(i).delivery_id;
13205: IF l_debug_on THEN
13206: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_TRIPS_ACTIONS.Unassign_Trip',WSH_DEBUG_SV.C_PROC_LEVEL);
13207: END IF;
13208: WSH_TRIPS_ACTIONS.Unassign_Trip(p_del_rows => l_unassign_dels,
13209: p_trip_id => l_parent_trip_rec.trip_id,
13210: x_return_status => l_return_status);

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

13204: l_unassign_dels(1) := p_del_tab(i).delivery_id;
13205: IF l_debug_on THEN
13206: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_TRIPS_ACTIONS.Unassign_Trip',WSH_DEBUG_SV.C_PROC_LEVEL);
13207: END IF;
13208: WSH_TRIPS_ACTIONS.Unassign_Trip(p_del_rows => l_unassign_dels,
13209: p_trip_id => l_parent_trip_rec.trip_id,
13210: x_return_status => l_return_status);
13211:
13212: wsh_util_core.api_post_call

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

13408:
13409: END IF;
13410:
13411: IF l_debug_on THEN
13412: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_TRIPS_ACTIONS.assign_trip for ignore plan = N',WSH_DEBUG_SV.C_PROC_LEVEL);
13413: END IF;
13414: WSH_TRIPS_ACTIONS.assign_trip(
13415: p_del_rows => l_include_plan_dels,
13416: p_trip_id => l_trip_id_tab(1),

Line 13414: WSH_TRIPS_ACTIONS.assign_trip(

13410:
13411: IF l_debug_on THEN
13412: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_TRIPS_ACTIONS.assign_trip for ignore plan = N',WSH_DEBUG_SV.C_PROC_LEVEL);
13413: END IF;
13414: WSH_TRIPS_ACTIONS.assign_trip(
13415: p_del_rows => l_include_plan_dels,
13416: p_trip_id => l_trip_id_tab(1),
13417: p_pickup_stop_id => l_parent_trip_rec.pick_up_stop_id,
13418: p_dropoff_stop_id => l_parent_trip_rec.drop_off_stop_id,

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

13459: END IF;
13460: IF l_ignore_plan_dels.count > 0 THEN
13461:
13462: IF l_debug_on THEN
13463: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_TRIPS_ACTIONS.assign_trip for ignore plan = Y',WSH_DEBUG_SV.C_PROC_LEVEL);
13464: END IF;
13465:
13466: WSH_TRIPS_ACTIONS.assign_trip(
13467: p_del_rows => l_ignore_plan_dels,

Line 13466: WSH_TRIPS_ACTIONS.assign_trip(

13462: IF l_debug_on THEN
13463: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_TRIPS_ACTIONS.assign_trip for ignore plan = Y',WSH_DEBUG_SV.C_PROC_LEVEL);
13464: END IF;
13465:
13466: WSH_TRIPS_ACTIONS.assign_trip(
13467: p_del_rows => l_ignore_plan_dels,
13468: p_trip_id => l_trip_id_tab(1),
13469: p_pickup_stop_id => l_parent_trip_rec.pick_up_stop_id,
13470: p_dropoff_stop_id => l_parent_trip_rec.drop_off_stop_id,

Line 14581: l_trip_in_rec WSH_TRIPS_GRP.tripInRecType;

14577: l_del_tab wsh_util_core.id_tab_type;
14578: l_trip_tab wsh_util_core.id_tab_type;
14579:
14580:
14581: l_trip_in_rec WSH_TRIPS_GRP.tripInRecType;
14582: l_init_msg_list VARCHAR2(100);
14583: l_api_version_number NUMBER := 1.0;
14584: l_commit VARCHAR2(10);
14585: l_return_status VARCHAR2(1);

Line 14588: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;

14584: l_commit VARCHAR2(10);
14585: l_return_status VARCHAR2(1);
14586: l_msg_count NUMBER;
14587: l_msg_data VARCHAR2(2000);
14588: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
14589: l_trip_info_rec WSH_TRIPS_PVT.trip_rec_type;
14590: l_trip_out_rec_tab WSH_TRIPS_GRP.Trip_Out_Tab_Type;
14591: l_num_warnings NUMBER := 0;
14592: l_num_errors NUMBER := 0;

Line 14589: l_trip_info_rec WSH_TRIPS_PVT.trip_rec_type;

14585: l_return_status VARCHAR2(1);
14586: l_msg_count NUMBER;
14587: l_msg_data VARCHAR2(2000);
14588: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
14589: l_trip_info_rec WSH_TRIPS_PVT.trip_rec_type;
14590: l_trip_out_rec_tab WSH_TRIPS_GRP.Trip_Out_Tab_Type;
14591: l_num_warnings NUMBER := 0;
14592: l_num_errors NUMBER := 0;
14593: l_do_date DATE;

Line 14590: l_trip_out_rec_tab WSH_TRIPS_GRP.Trip_Out_Tab_Type;

14586: l_msg_count NUMBER;
14587: l_msg_data VARCHAR2(2000);
14588: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
14589: l_trip_info_rec WSH_TRIPS_PVT.trip_rec_type;
14590: l_trip_out_rec_tab WSH_TRIPS_GRP.Trip_Out_Tab_Type;
14591: l_num_warnings NUMBER := 0;
14592: l_num_errors NUMBER := 0;
14593: l_do_date DATE;
14594: i NUMBER;

Line 14626: WSH_TRIPS_ACTIONS.Unassign_Trip(

14622: -- delivery.
14623:
14624: FOR trip in c_second_leg(p_deliveries_tab(i)) LOOP
14625:
14626: WSH_TRIPS_ACTIONS.Unassign_Trip(
14627: p_del_rows => l_del_tab,
14628: p_trip_id => trip.trip_id,
14629: x_return_status => l_return_status);
14630:

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

14652:
14653: l_commit := FND_API.g_false;
14654: IF l_debug_on THEN
14655: WSH_DEBUG_SV.logmsg(l_module_name,'Creating deconsol trip');
14656: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_GRP.Create_Update_Trip',WSH_DEBUG_SV.C_PROC_LEVEL);
14657: END IF;
14658:
14659: WSH_TRIPS_GRP.Create_Update_Trip(
14660: p_api_version_number => l_api_version_number,

Line 14659: WSH_TRIPS_GRP.Create_Update_Trip(

14655: WSH_DEBUG_SV.logmsg(l_module_name,'Creating deconsol trip');
14656: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_GRP.Create_Update_Trip',WSH_DEBUG_SV.C_PROC_LEVEL);
14657: END IF;
14658:
14659: WSH_TRIPS_GRP.Create_Update_Trip(
14660: p_api_version_number => l_api_version_number,
14661: p_init_msg_list => l_init_msg_list,
14662: p_commit => l_commit,
14663: x_return_status => l_return_status,

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

14677: -- Assign delivery to trip
14678:
14679: IF l_debug_on THEN
14680: WSH_DEBUG_SV.logmsg(l_module_name,'Assigning to deconsol trip');
14681: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.assign_trip',WSH_DEBUG_SV.C_PROC_LEVEL);
14682: END IF;
14683:
14684:
14685: IF del.pu_date < del.do_date THEN

Line 14691: WSH_TRIPS_ACTIONS.assign_trip(

14687: ELSE
14688: l_do_date := del.pu_date + 1;
14689: END IF;
14690:
14691: WSH_TRIPS_ACTIONS.assign_trip(
14692: p_del_rows => l_del_tab,
14693: p_trip_id => l_trip_out_rec_tab(l_trip_out_rec_tab.FIRST).trip_id,
14694: p_pickup_location_id => del.pu_location,
14695: p_dropoff_location_id => del.do_location,