[Home] [Help]
131: --frontport bug 4310141: check trip or delivery to default ship method.
132:
133: CURSOR Check_Trip (l_delivery_id NUMBER) IS
134: select wts.trip_id
135: from wsh_delivery_legs wdl,
136: wsh_trip_stops wts
137: where wdl.pick_up_stop_id = wts.stop_id
138: and wdl.delivery_id = l_delivery_id
139: and rownum=1;
146: -- Bug 4103142 - to get first trip for delivery
147: CURSOR c_first_ship_method (p_delivery_id IN number)IS
148: SELECT wt.ship_method_code
149: FROM wsh_new_deliveries del,
150: wsh_delivery_legs dlg,
151: wsh_trip_stops st,
152: wsh_trips wt
153: WHERE del.delivery_id = dlg.delivery_id
154: AND dlg.pick_up_stop_id = st.stop_id
330:
331: EXCEPTION
332:
333: WHEN others THEN
334: wsh_util_core.default_handler('WSH_DELIVERY_LEGS_GRP.derive_sc_rule_details',l_module_name);
335: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
336: --
337: IF l_debug_on THEN
338: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2697: -- p_delivery_leg_tab Table of Attributes for the delivery leg entity
2698: -- x_out_rec for future usage.
2699: -- VERSION : current version 1.0
2700: -- initial version 1.0
2701: -- COMMENT : Updates a record in wsh_delivery_legs table with information
2702: -- specified in p_delivery_leg_tab. Please note that as per perfomance
2703: -- standards, if you need to update a field to null, then use the
2704: -- fnd_api.g_miss_(num/char/date) value for that field. If a field
2705: -- has a null value, it will not be updated.
2707: PROCEDURE Update_Delivery_Leg(
2708: p_api_version_number IN NUMBER,
2709: p_init_msg_list IN VARCHAR2,
2710: p_commit IN VARCHAR2,
2711: p_delivery_leg_tab IN WSH_DELIVERY_LEGS_GRP.dlvy_leg_tab_type,
2712: p_in_rec IN WSH_DELIVERY_LEGS_GRP.action_parameters_rectype,
2713: x_out_rec OUT NOCOPY WSH_DELIVERY_LEGS_GRP.action_out_rec_type,
2714: x_return_status OUT NOCOPY VARCHAR2,
2715: x_msg_count OUT NOCOPY NUMBER,
2708: p_api_version_number IN NUMBER,
2709: p_init_msg_list IN VARCHAR2,
2710: p_commit IN VARCHAR2,
2711: p_delivery_leg_tab IN WSH_DELIVERY_LEGS_GRP.dlvy_leg_tab_type,
2712: p_in_rec IN WSH_DELIVERY_LEGS_GRP.action_parameters_rectype,
2713: x_out_rec OUT NOCOPY WSH_DELIVERY_LEGS_GRP.action_out_rec_type,
2714: x_return_status OUT NOCOPY VARCHAR2,
2715: x_msg_count OUT NOCOPY NUMBER,
2716: x_msg_data OUT NOCOPY VARCHAR2) IS
2709: p_init_msg_list IN VARCHAR2,
2710: p_commit IN VARCHAR2,
2711: p_delivery_leg_tab IN WSH_DELIVERY_LEGS_GRP.dlvy_leg_tab_type,
2712: p_in_rec IN WSH_DELIVERY_LEGS_GRP.action_parameters_rectype,
2713: x_out_rec OUT NOCOPY WSH_DELIVERY_LEGS_GRP.action_out_rec_type,
2714: x_return_status OUT NOCOPY VARCHAR2,
2715: x_msg_count OUT NOCOPY NUMBER,
2716: x_msg_data OUT NOCOPY VARCHAR2) IS
2717:
2732: IF l_debug_on THEN
2733: WSH_DEBUG_SV.push(l_module_name);
2734: END IF;
2735:
2736: WSH_DELIVERY_LEGS_GRP.Update_Delivery_Leg(
2737: p_api_version_number => p_api_version_number,
2738: p_init_msg_list => p_init_msg_list,
2739: p_commit => p_commit,
2740: p_delivery_leg_tab => p_delivery_leg_tab,
2751:
2752: EXCEPTION
2753:
2754: WHEN others THEN
2755: wsh_util_core.default_handler('WSH_DELIVERY_LEGS_GRP.Update_Delivery_Leg',l_module_name);
2756: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2757: --
2758: IF l_debug_on THEN
2759: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);