3605: FORALL i in l_del_tab.FIRST..l_del_tab.LAST
3606: UPDATE wsh_new_deliveries
3607: SET loading_sequence = l_loading_sequence,
3608: last_update_date = SYSDATE,
3609: last_updated_by = FND_GLOBAL.USER_ID,
3610: last_update_login = FND_GLOBAL.LOGIN_ID
3611: WHERE delivery_id = l_del_tab(i);
3612:
3613: FORALL i in l_del_det_tab.FIRST..l_del_det_tab.LAST
3606: UPDATE wsh_new_deliveries
3607: SET loading_sequence = l_loading_sequence,
3608: last_update_date = SYSDATE,
3609: last_updated_by = FND_GLOBAL.USER_ID,
3610: last_update_login = FND_GLOBAL.LOGIN_ID
3611: WHERE delivery_id = l_del_tab(i);
3612:
3613: FORALL i in l_del_det_tab.FIRST..l_del_det_tab.LAST
3614: UPDATE wsh_delivery_details
3613: FORALL i in l_del_det_tab.FIRST..l_del_det_tab.LAST
3614: UPDATE wsh_delivery_details
3615: SET load_seq_number = l_loading_sequence,
3616: last_update_date = SYSDATE,
3617: last_updated_by = FND_GLOBAL.USER_ID,
3618: last_update_login = FND_GLOBAL.LOGIN_ID
3619: WHERE delivery_detail_id = l_del_det_tab(i);
3620: END IF;
3621:
3614: UPDATE wsh_delivery_details
3615: SET load_seq_number = l_loading_sequence,
3616: last_update_date = SYSDATE,
3617: last_updated_by = FND_GLOBAL.USER_ID,
3618: last_update_login = FND_GLOBAL.LOGIN_ID
3619: WHERE delivery_detail_id = l_del_det_tab(i);
3620: END IF;
3621:
3622: CLOSE c_lock_deliveries_and_details;
3819: x_exception_id => l_exception_id,
3820: p_exception_location_id => l_dleg_local_tab(rec).initial_pickup_location_id,
3821: p_logged_at_location_id => l_dleg_local_tab(rec).initial_pickup_location_id,
3822: p_logging_entity => 'SHIPPER',
3823: p_logging_entity_id => FND_GLOBAL.USER_ID,
3824: p_exception_name => l_exception_name, -- 'WSH_OTM_SHIPMENT_ERROR',
3825: p_message => substrb(l_exception_message,1,2000),
3826: p_delivery_id => l_dleg_local_tab(rec).delivery_id);
3827: IF l_debug_on THEN
4637: G_TMS_RELEASE_CODE,
4638: l_message_name,
4639: l_message,
4640: SYSDATE,
4641: FND_GLOBAL.USER_ID,
4642: SYSDATE,
4643: FND_GLOBAL.USER_ID);
4644: END IF;
4645:
4639: l_message,
4640: SYSDATE,
4641: FND_GLOBAL.USER_ID,
4642: SYSDATE,
4643: FND_GLOBAL.USER_ID);
4644: END IF;
4645:
4646: END IF;--}
4647: