[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);
2693: -- p_delivery_leg_tab Table of Attributes for the delivery leg entity
2694: -- x_out_rec for future usage.
2695: -- VERSION : current version 1.0
2696: -- initial version 1.0
2697: -- COMMENT : Updates a record in wsh_delivery_legs table with information
2698: -- specified in p_delivery_leg_tab. Please note that as per perfomance
2699: -- standards, if you need to update a field to null, then use the
2700: -- fnd_api.g_miss_(num/char/date) value for that field. If a field
2701: -- has a null value, it will not be updated.
2703: PROCEDURE Update_Delivery_Leg(
2704: p_api_version_number IN NUMBER,
2705: p_init_msg_list IN VARCHAR2,
2706: p_commit IN VARCHAR2,
2707: p_delivery_leg_tab IN WSH_DELIVERY_LEGS_GRP.dlvy_leg_tab_type,
2708: p_in_rec IN WSH_DELIVERY_LEGS_GRP.action_parameters_rectype,
2709: x_out_rec OUT NOCOPY WSH_DELIVERY_LEGS_GRP.action_out_rec_type,
2710: x_return_status OUT NOCOPY VARCHAR2,
2711: x_msg_count OUT NOCOPY NUMBER,
2704: p_api_version_number IN NUMBER,
2705: p_init_msg_list IN VARCHAR2,
2706: p_commit IN VARCHAR2,
2707: p_delivery_leg_tab IN WSH_DELIVERY_LEGS_GRP.dlvy_leg_tab_type,
2708: p_in_rec IN WSH_DELIVERY_LEGS_GRP.action_parameters_rectype,
2709: x_out_rec OUT NOCOPY WSH_DELIVERY_LEGS_GRP.action_out_rec_type,
2710: x_return_status OUT NOCOPY VARCHAR2,
2711: x_msg_count OUT NOCOPY NUMBER,
2712: x_msg_data OUT NOCOPY VARCHAR2) IS
2705: p_init_msg_list IN VARCHAR2,
2706: p_commit IN VARCHAR2,
2707: p_delivery_leg_tab IN WSH_DELIVERY_LEGS_GRP.dlvy_leg_tab_type,
2708: p_in_rec IN WSH_DELIVERY_LEGS_GRP.action_parameters_rectype,
2709: x_out_rec OUT NOCOPY WSH_DELIVERY_LEGS_GRP.action_out_rec_type,
2710: x_return_status OUT NOCOPY VARCHAR2,
2711: x_msg_count OUT NOCOPY NUMBER,
2712: x_msg_data OUT NOCOPY VARCHAR2) IS
2713:
2728: IF l_debug_on THEN
2729: WSH_DEBUG_SV.push(l_module_name);
2730: END IF;
2731:
2732: WSH_DELIVERY_LEGS_GRP.Update_Delivery_Leg(
2733: p_api_version_number => p_api_version_number,
2734: p_init_msg_list => p_init_msg_list,
2735: p_commit => p_commit,
2736: p_delivery_leg_tab => p_delivery_leg_tab,
2747:
2748: EXCEPTION
2749:
2750: WHEN others THEN
2751: wsh_util_core.default_handler('WSH_DELIVERY_LEGS_GRP.Update_Delivery_Leg',l_module_name);
2752: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2753: --
2754: IF l_debug_on THEN
2755: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);