[Home] [Help]
730: SELECT stop_id,
731: NULL, -- organization_id,
732: status_code,
733: shipments_type_flag
734: FROM wsh_trip_stops
735: WHERE stop_id = v_stop_id;
736:
737: CURSOR c_del_rec(v_del_id NUMBER ) IS
738: SELECT delivery_id,
750:
751: l_detail_rec WSH_DETAILS_VALIDATIONS.detail_rec_type;
752: l_del_rec WSH_DELIVERY_VALIDATIONS.dlvy_rec_type;
753: l_trip_rec WSH_TRIP_VALIDATIONS.trip_rec_type;
754: l_stop_rec WSH_TRIP_STOPS_VALIDATIONS.stop_rec_type;
755: l_detail_rec_tab WSH_DETAILS_VALIDATIONS.detail_rec_tab_type;
756: l_del_rec_tab WSH_DELIVERY_VALIDATIONS.dlvy_rec_tab_type;
757: l_trip_rec_tab WSH_TRIP_VALIDATIONS.trip_rec_tab_type;
758: l_stop_rec_tab WSH_TRIP_STOPS_VALIDATIONS.stop_rec_tab_type;
754: l_stop_rec WSH_TRIP_STOPS_VALIDATIONS.stop_rec_type;
755: l_detail_rec_tab WSH_DETAILS_VALIDATIONS.detail_rec_tab_type;
756: l_del_rec_tab WSH_DELIVERY_VALIDATIONS.dlvy_rec_tab_type;
757: l_trip_rec_tab WSH_TRIP_VALIDATIONS.trip_rec_tab_type;
758: l_stop_rec_tab WSH_TRIP_STOPS_VALIDATIONS.stop_rec_tab_type;
759:
760: l_valid_index_tab wsh_util_core.id_tab_type;
761: l_valid_id_tab wsh_util_core.id_tab_type;
762: l_error_ids wsh_util_core.id_tab_type;
1050: --Bugfix 6816437 Start --Code has been written to check the oe interface flag when inserting/updating Freight Cost Record and display warning
1051: IF p_in_rec.caller = 'PLSQL' THEN
1052: BEGIN
1053: SELECT 'Y',wt.name into l_status,l_name
1054: FROM wsh_trips wt, wsh_trip_stops wts, wsh_delivery_legs wdl, wsh_new_deliveries wnd,
1055: wsh_delivery_assignments wda, wsh_delivery_details wdd
1056: WHERE wt.trip_id = l_trip_id
1057: AND wts.trip_id = wt.trip_id
1058: AND wdl.pick_up_stop_id = wts.stop_id
1127: --Bugfix 6816437 Start --Code has been written to check the oe interface flag when inserting/updating Freight Cost Record
1128: IF p_in_rec.caller = 'PLSQL' THEN
1129: BEGIN
1130: SELECT 'Y',wts.stop_location_id into l_status,l_stop_loc_id
1131: FROM wsh_trip_stops wts, wsh_delivery_legs wdl, wsh_new_deliveries wnd,
1132: wsh_delivery_assignments wda, wsh_delivery_details wdd
1133: WHERE wts.stop_id = l_stop_id
1134: AND (wdl.pick_up_stop_id = wts.stop_id OR wdl.drop_off_stop_id = wts.stop_id)
1135: AND wnd.delivery_id = wdl.delivery_id
1157: --Bugfix 6816437 End
1158:
1159: IF (WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_PARENT_ENTITY_LVL)=1) THEN
1160: SELECT COUNT(*) INTO l_counts
1161: FROM wsh_trip_stops
1162: WHERE stop_id = l_stop_id
1163: AND ROWNUM = 1;
1164:
1165: IF l_debug_on THEN
1464: END IF;
1465: --
1466: CLOSE c_stop_rec;
1467: --
1468: WSH_TRIP_STOPS_VALIDATIONS.Is_Action_Enabled(
1469: p_stop_rec_tab => l_stop_rec_tab,
1470: p_action => 'ASSIGN-FREIGHT-COSTS',
1471: p_caller => p_in_rec.caller,
1472: x_return_status => l_return_status,
1657: END IF;
1658:
1659: WHEN OTHERS THEN
1660: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1661: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP');
1662: FND_MSG_PUB.Count_And_Get (
1663: p_count => x_msg_count,
1664: p_data => x_msg_data,
1665: p_encoded => FND_API.G_FALSE);
1772:
1773:
1774: WHEN OTHERS THEN
1775: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1776: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP');
1777: IF l_debug_on THEN
1778: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1779: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1780: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');