[Home] [Help]
685: SELECT stop_id,
686: NULL, -- organization_id,
687: status_code,
688: shipments_type_flag
689: FROM wsh_trip_stops
690: WHERE stop_id = v_stop_id;
691:
692: CURSOR c_del_rec(v_del_id NUMBER ) IS
693: SELECT delivery_id,
704:
705: l_detail_rec WSH_DETAILS_VALIDATIONS.detail_rec_type;
706: l_del_rec WSH_DELIVERY_VALIDATIONS.dlvy_rec_type;
707: l_trip_rec WSH_TRIP_VALIDATIONS.trip_rec_type;
708: l_stop_rec WSH_TRIP_STOPS_VALIDATIONS.stop_rec_type;
709: l_detail_rec_tab WSH_DETAILS_VALIDATIONS.detail_rec_tab_type;
710: l_del_rec_tab WSH_DELIVERY_VALIDATIONS.dlvy_rec_tab_type;
711: l_trip_rec_tab WSH_TRIP_VALIDATIONS.trip_rec_tab_type;
712: l_stop_rec_tab WSH_TRIP_STOPS_VALIDATIONS.stop_rec_tab_type;
708: l_stop_rec WSH_TRIP_STOPS_VALIDATIONS.stop_rec_type;
709: l_detail_rec_tab WSH_DETAILS_VALIDATIONS.detail_rec_tab_type;
710: l_del_rec_tab WSH_DELIVERY_VALIDATIONS.dlvy_rec_tab_type;
711: l_trip_rec_tab WSH_TRIP_VALIDATIONS.trip_rec_tab_type;
712: l_stop_rec_tab WSH_TRIP_STOPS_VALIDATIONS.stop_rec_tab_type;
713:
714: l_valid_index_tab wsh_util_core.id_tab_type;
715: l_valid_id_tab wsh_util_core.id_tab_type;
716: l_error_ids wsh_util_core.id_tab_type;
1004: --Bugfix 6816437 Start --Code has been written to check the oe interface flag when inserting/updating Freight Cost Record and display warning
1005: IF p_in_rec.caller = 'PLSQL' THEN
1006: BEGIN
1007: SELECT 'Y',wt.name into l_status,l_name
1008: FROM wsh_trips wt, wsh_trip_stops wts, wsh_delivery_legs wdl, wsh_new_deliveries wnd,
1009: wsh_delivery_assignments wda, wsh_delivery_details wdd
1010: WHERE wt.trip_id = l_trip_id
1011: AND wts.trip_id = wt.trip_id
1012: AND wdl.pick_up_stop_id = wts.stop_id
1081: --Bugfix 6816437 Start --Code has been written to check the oe interface flag when inserting/updating Freight Cost Record
1082: IF p_in_rec.caller = 'PLSQL' THEN
1083: BEGIN
1084: SELECT 'Y',wts.stop_location_id into l_status,l_stop_loc_id
1085: FROM wsh_trip_stops wts, wsh_delivery_legs wdl, wsh_new_deliveries wnd,
1086: wsh_delivery_assignments wda, wsh_delivery_details wdd
1087: WHERE wts.stop_id = l_stop_id
1088: AND (wdl.pick_up_stop_id = wts.stop_id OR wdl.drop_off_stop_id = wts.stop_id)
1089: AND wnd.delivery_id = wdl.delivery_id
1111: --Bugfix 6816437 End
1112:
1113: IF (WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_PARENT_ENTITY_LVL)=1) THEN
1114: SELECT COUNT(*) INTO l_counts
1115: FROM wsh_trip_stops
1116: WHERE stop_id = l_stop_id
1117: AND ROWNUM = 1;
1118:
1119: IF l_debug_on THEN
1418: END IF;
1419: --
1420: CLOSE c_stop_rec;
1421: --
1422: WSH_TRIP_STOPS_VALIDATIONS.Is_Action_Enabled(
1423: p_stop_rec_tab => l_stop_rec_tab,
1424: p_action => 'ASSIGN-FREIGHT-COSTS',
1425: p_caller => p_in_rec.caller,
1426: x_return_status => l_return_status,
1611: END IF;
1612:
1613: WHEN OTHERS THEN
1614: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1615: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP');
1616: FND_MSG_PUB.Count_And_Get (
1617: p_count => x_msg_count,
1618: p_data => x_msg_data,
1619: p_encoded => FND_API.G_FALSE);
1726:
1727:
1728: WHEN OTHERS THEN
1729: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1730: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP');
1731: IF l_debug_on THEN
1732: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1733: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1734: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');