43: l_action_code VARCHAR2(30) := NULL;
44: l_dummy_exception_list WSH_UTIL_CORE.column_tab_type;
45:
46: l_dummy_in_ids WSH_UTIL_CORE.id_tab_type; -- Either of the next two
47: l_delivery_info WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
48: l_delivery_rec WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_rec_type;
49: l_dlvy_assigned_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
50: l_target_trip WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_rec_type;
51: l_target_tripstops WSH_FTE_CONSTRAINT_FRAMEWORK.target_tripstop_cc_rec_type;
44: l_dummy_exception_list WSH_UTIL_CORE.column_tab_type;
45:
46: l_dummy_in_ids WSH_UTIL_CORE.id_tab_type; -- Either of the next two
47: l_delivery_info WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
48: l_delivery_rec WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_rec_type;
49: l_dlvy_assigned_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
50: l_target_trip WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_rec_type;
51: l_target_tripstops WSH_FTE_CONSTRAINT_FRAMEWORK.target_tripstop_cc_rec_type;
52: l_target_trip_assign_dels WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
45:
46: l_dummy_in_ids WSH_UTIL_CORE.id_tab_type; -- Either of the next two
47: l_delivery_info WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
48: l_delivery_rec WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_rec_type;
49: l_dlvy_assigned_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
50: l_target_trip WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_rec_type;
51: l_target_tripstops WSH_FTE_CONSTRAINT_FRAMEWORK.target_tripstop_cc_rec_type;
52: l_target_trip_assign_dels WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
53: l_target_trip_dlvy_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
46: l_dummy_in_ids WSH_UTIL_CORE.id_tab_type; -- Either of the next two
47: l_delivery_info WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
48: l_delivery_rec WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_rec_type;
49: l_dlvy_assigned_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
50: l_target_trip WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_rec_type;
51: l_target_tripstops WSH_FTE_CONSTRAINT_FRAMEWORK.target_tripstop_cc_rec_type;
52: l_target_trip_assign_dels WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
53: l_target_trip_dlvy_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
54: l_target_trip_incl_stops WSH_FTE_CONSTRAINT_FRAMEWORK.stop_ccinfo_tab_type;
47: l_delivery_info WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
48: l_delivery_rec WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_rec_type;
49: l_dlvy_assigned_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
50: l_target_trip WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_rec_type;
51: l_target_tripstops WSH_FTE_CONSTRAINT_FRAMEWORK.target_tripstop_cc_rec_type;
52: l_target_trip_assign_dels WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
53: l_target_trip_dlvy_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
54: l_target_trip_incl_stops WSH_FTE_CONSTRAINT_FRAMEWORK.stop_ccinfo_tab_type;
55: l_line_groups WSH_FTE_COMP_CONSTRAINT_PKG.line_group_tab_type;
48: l_delivery_rec WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_rec_type;
49: l_dlvy_assigned_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
50: l_target_trip WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_rec_type;
51: l_target_tripstops WSH_FTE_CONSTRAINT_FRAMEWORK.target_tripstop_cc_rec_type;
52: l_target_trip_assign_dels WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
53: l_target_trip_dlvy_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
54: l_target_trip_incl_stops WSH_FTE_CONSTRAINT_FRAMEWORK.stop_ccinfo_tab_type;
55: l_line_groups WSH_FTE_COMP_CONSTRAINT_PKG.line_group_tab_type;
56: l_group_info WSH_FTE_COMP_CONSTRAINT_PKG.cc_group_tab_type;
49: l_dlvy_assigned_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
50: l_target_trip WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_rec_type;
51: l_target_tripstops WSH_FTE_CONSTRAINT_FRAMEWORK.target_tripstop_cc_rec_type;
52: l_target_trip_assign_dels WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
53: l_target_trip_dlvy_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
54: l_target_trip_incl_stops WSH_FTE_CONSTRAINT_FRAMEWORK.stop_ccinfo_tab_type;
55: l_line_groups WSH_FTE_COMP_CONSTRAINT_PKG.line_group_tab_type;
56: l_group_info WSH_FTE_COMP_CONSTRAINT_PKG.cc_group_tab_type;
57: l_failed_lines WSH_FTE_COMP_CONSTRAINT_PKG.failed_line_tab_type;
50: l_target_trip WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_rec_type;
51: l_target_tripstops WSH_FTE_CONSTRAINT_FRAMEWORK.target_tripstop_cc_rec_type;
52: l_target_trip_assign_dels WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
53: l_target_trip_dlvy_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
54: l_target_trip_incl_stops WSH_FTE_CONSTRAINT_FRAMEWORK.stop_ccinfo_tab_type;
55: l_line_groups WSH_FTE_COMP_CONSTRAINT_PKG.line_group_tab_type;
56: l_group_info WSH_FTE_COMP_CONSTRAINT_PKG.cc_group_tab_type;
57: l_failed_lines WSH_FTE_COMP_CONSTRAINT_PKG.failed_line_tab_type;
58:
55: l_line_groups WSH_FTE_COMP_CONSTRAINT_PKG.line_group_tab_type;
56: l_group_info WSH_FTE_COMP_CONSTRAINT_PKG.cc_group_tab_type;
57: l_failed_lines WSH_FTE_COMP_CONSTRAINT_PKG.failed_line_tab_type;
58:
59: l_trip_info WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_tab_type;
60: l_trip_rec WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_rec_type;
61: l_trip_assigned_dels WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
62: l_trip_dlvy_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
63: l_trip_incl_stops WSH_FTE_CONSTRAINT_FRAMEWORK.stop_ccinfo_tab_type;
56: l_group_info WSH_FTE_COMP_CONSTRAINT_PKG.cc_group_tab_type;
57: l_failed_lines WSH_FTE_COMP_CONSTRAINT_PKG.failed_line_tab_type;
58:
59: l_trip_info WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_tab_type;
60: l_trip_rec WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_rec_type;
61: l_trip_assigned_dels WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
62: l_trip_dlvy_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
63: l_trip_incl_stops WSH_FTE_CONSTRAINT_FRAMEWORK.stop_ccinfo_tab_type;
64: l_fail_trips WSH_UTIL_CORE.id_tab_type;
57: l_failed_lines WSH_FTE_COMP_CONSTRAINT_PKG.failed_line_tab_type;
58:
59: l_trip_info WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_tab_type;
60: l_trip_rec WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_rec_type;
61: l_trip_assigned_dels WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
62: l_trip_dlvy_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
63: l_trip_incl_stops WSH_FTE_CONSTRAINT_FRAMEWORK.stop_ccinfo_tab_type;
64: l_fail_trips WSH_UTIL_CORE.id_tab_type;
65:
58:
59: l_trip_info WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_tab_type;
60: l_trip_rec WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_rec_type;
61: l_trip_assigned_dels WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
62: l_trip_dlvy_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
63: l_trip_incl_stops WSH_FTE_CONSTRAINT_FRAMEWORK.stop_ccinfo_tab_type;
64: l_fail_trips WSH_UTIL_CORE.id_tab_type;
65:
66: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
59: l_trip_info WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_tab_type;
60: l_trip_rec WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_rec_type;
61: l_trip_assigned_dels WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
62: l_trip_dlvy_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
63: l_trip_incl_stops WSH_FTE_CONSTRAINT_FRAMEWORK.stop_ccinfo_tab_type;
64: l_fail_trips WSH_UTIL_CORE.id_tab_type;
65:
66: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
67: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || g_package_name || '.' || 'validate_constraint';
156: END IF;
157:
158: IF l_trip_info.COUNT > 0 THEN
159:
160: l_action_code := WSH_FTE_CONSTRAINT_FRAMEWORK.G_UPDATE_TRIP;
161:
162: WSH_FTE_CONSTRAINT_FRAMEWORK.validate_constraint_trip(
163: p_init_msg_list => p_init_msg_list,
164: p_action_code => l_action_code,
158: IF l_trip_info.COUNT > 0 THEN
159:
160: l_action_code := WSH_FTE_CONSTRAINT_FRAMEWORK.G_UPDATE_TRIP;
161:
162: WSH_FTE_CONSTRAINT_FRAMEWORK.validate_constraint_trip(
163: p_init_msg_list => p_init_msg_list,
164: p_action_code => l_action_code,
165: p_exception_list => l_dummy_exception_list,
166: p_trip_info => l_trip_info,
216: END IF; -- l_trip_info
217:
218: IF l_delivery_info.COUNT > 0 THEN
219:
220: l_action_code := WSH_FTE_CONSTRAINT_FRAMEWORK.G_UPDATE_DLVY;
221:
222: WSH_FTE_CONSTRAINT_FRAMEWORK.validate_constraint_dlvy(
223: p_init_msg_list => p_init_msg_list,
224: p_action_code => l_action_code,
218: IF l_delivery_info.COUNT > 0 THEN
219:
220: l_action_code := WSH_FTE_CONSTRAINT_FRAMEWORK.G_UPDATE_DLVY;
221:
222: WSH_FTE_CONSTRAINT_FRAMEWORK.validate_constraint_dlvy(
223: p_init_msg_list => p_init_msg_list,
224: p_action_code => l_action_code,
225: p_exception_list => l_dummy_exception_list,
226: p_in_ids => l_dummy_in_ids,
351: l_consol_drop_off_loc NUMBER;
352: l_consol_trip_id NUMBER;
353: l_prev_consolidation_del NUMBER;
354: l_pre_consolidation_del NUMBER;
355: l_target_trip WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_rec_type;
356: l_target_trip_stop WSH_FTE_CONSTRAINT_FRAMEWORK.target_tripstop_cc_rec_type;
357: d_itr NUMBER;
358: l_cc_exception_list WSH_UTIL_CORE.Column_Tab_Type;
359: x_output_id_tab WSH_FTE_CONSTRAINT_FRAMEWORK.deconsol_output_tab_type;
352: l_consol_trip_id NUMBER;
353: l_prev_consolidation_del NUMBER;
354: l_pre_consolidation_del NUMBER;
355: l_target_trip WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_rec_type;
356: l_target_trip_stop WSH_FTE_CONSTRAINT_FRAMEWORK.target_tripstop_cc_rec_type;
357: d_itr NUMBER;
358: l_cc_exception_list WSH_UTIL_CORE.Column_Tab_Type;
359: x_output_id_tab WSH_FTE_CONSTRAINT_FRAMEWORK.deconsol_output_tab_type;
360:
355: l_target_trip WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_rec_type;
356: l_target_trip_stop WSH_FTE_CONSTRAINT_FRAMEWORK.target_tripstop_cc_rec_type;
357: d_itr NUMBER;
358: l_cc_exception_list WSH_UTIL_CORE.Column_Tab_Type;
359: x_output_id_tab WSH_FTE_CONSTRAINT_FRAMEWORK.deconsol_output_tab_type;
360:
361: l_cc_delivery_info WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
362: l_cc_dlvy_assigned_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
363: l_cc_target_trip_assign_dels WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
357: d_itr NUMBER;
358: l_cc_exception_list WSH_UTIL_CORE.Column_Tab_Type;
359: x_output_id_tab WSH_FTE_CONSTRAINT_FRAMEWORK.deconsol_output_tab_type;
360:
361: l_cc_delivery_info WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
362: l_cc_dlvy_assigned_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
363: l_cc_target_trip_assign_dels WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
364: l_cc_target_trip_dlvy_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
365: l_cc_target_trip_incl_stops WSH_FTE_CONSTRAINT_FRAMEWORK.stop_ccinfo_tab_type;
358: l_cc_exception_list WSH_UTIL_CORE.Column_Tab_Type;
359: x_output_id_tab WSH_FTE_CONSTRAINT_FRAMEWORK.deconsol_output_tab_type;
360:
361: l_cc_delivery_info WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
362: l_cc_dlvy_assigned_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
363: l_cc_target_trip_assign_dels WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
364: l_cc_target_trip_dlvy_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
365: l_cc_target_trip_incl_stops WSH_FTE_CONSTRAINT_FRAMEWORK.stop_ccinfo_tab_type;
366: l_delivery_info WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
359: x_output_id_tab WSH_FTE_CONSTRAINT_FRAMEWORK.deconsol_output_tab_type;
360:
361: l_cc_delivery_info WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
362: l_cc_dlvy_assigned_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
363: l_cc_target_trip_assign_dels WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
364: l_cc_target_trip_dlvy_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
365: l_cc_target_trip_incl_stops WSH_FTE_CONSTRAINT_FRAMEWORK.stop_ccinfo_tab_type;
366: l_delivery_info WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
367:
360:
361: l_cc_delivery_info WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
362: l_cc_dlvy_assigned_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
363: l_cc_target_trip_assign_dels WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
364: l_cc_target_trip_dlvy_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
365: l_cc_target_trip_incl_stops WSH_FTE_CONSTRAINT_FRAMEWORK.stop_ccinfo_tab_type;
366: l_delivery_info WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
367:
368: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || g_package_name || '.' || 'is_valid_consol';
361: l_cc_delivery_info WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
362: l_cc_dlvy_assigned_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
363: l_cc_target_trip_assign_dels WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
364: l_cc_target_trip_dlvy_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
365: l_cc_target_trip_incl_stops WSH_FTE_CONSTRAINT_FRAMEWORK.stop_ccinfo_tab_type;
366: l_delivery_info WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
367:
368: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || g_package_name || '.' || 'is_valid_consol';
369: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
362: l_cc_dlvy_assigned_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
363: l_cc_target_trip_assign_dels WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
364: l_cc_target_trip_dlvy_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
365: l_cc_target_trip_incl_stops WSH_FTE_CONSTRAINT_FRAMEWORK.stop_ccinfo_tab_type;
366: l_delivery_info WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
367:
368: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || g_package_name || '.' || 'is_valid_consol';
369: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
370:
405: END IF;
406:
407: l_deconsol_location := NULL;
408:
409: IF WSH_FTE_CONSTRAINT_FRAMEWORK.g_is_fte_installed = 'Y' THEN
410: --
411: -- check if deliveries do not have any conflicting constraints so that
412: -- they can be put in one group
413: --
410: --
411: -- check if deliveries do not have any conflicting constraints so that
412: -- they can be put in one group
413: --
414: l_cc_action_code := WSH_FTE_CONSTRAINT_FRAMEWORK.G_AUTOCRT_MDC;
415:
416: WSH_FTE_CONSTRAINT_FRAMEWORK.validate_constraint_dlvy(
417: p_init_msg_list => p_init_msg_list,
418: p_action_code => l_cc_action_code,
412: -- they can be put in one group
413: --
414: l_cc_action_code := WSH_FTE_CONSTRAINT_FRAMEWORK.G_AUTOCRT_MDC;
415:
416: WSH_FTE_CONSTRAINT_FRAMEWORK.validate_constraint_dlvy(
417: p_init_msg_list => p_init_msg_list,
418: p_action_code => l_cc_action_code,
419: p_exception_list => l_cc_exception_list,
420: p_delivery_info => l_cc_delivery_info,
498: END IF;
499: END IF;
500: -- skattama
501:
502: WSH_FTE_CONSTRAINT_FRAMEWORK.validate_constraint_deconsol(
503: p_init_msg_list => p_init_msg_list,
504: p_delivery_info => l_delivery_info,
505: p_in_ids => l_in_ids,
506: p_caller => p_caller,
575:
576: -- AG
577: IF l_consol_drop_off_loc = l_deconsol_location THEN
578: --{
579: IF WSH_FTE_CONSTRAINT_FRAMEWORK.g_is_fte_installed = 'Y' THEN -- Bug 5194370
580: OPEN c_get_dlvy_trip_id(p_target_consol_delivery_id);
581: FETCH c_get_dlvy_trip_id INTO l_target_trip;
582: CLOSE c_get_dlvy_trip_id;
583:
582: CLOSE c_get_dlvy_trip_id;
583:
584: l_target_trip_stop.dropoff_location_id := l_deconsol_location;
585:
586: l_cc_action_code := WSH_FTE_CONSTRAINT_FRAMEWORK.G_ASSIGN_DLVY_TRIP;
587:
588: WSH_FTE_CONSTRAINT_FRAMEWORK.validate_constraint_dlvy(
589: p_init_msg_list => p_init_msg_list,
590: p_action_code => l_cc_action_code,
584: l_target_trip_stop.dropoff_location_id := l_deconsol_location;
585:
586: l_cc_action_code := WSH_FTE_CONSTRAINT_FRAMEWORK.G_ASSIGN_DLVY_TRIP;
587:
588: WSH_FTE_CONSTRAINT_FRAMEWORK.validate_constraint_dlvy(
589: p_init_msg_list => p_init_msg_list,
590: p_action_code => l_cc_action_code,
591: p_exception_list => l_cc_exception_list,
592: p_delivery_info => l_cc_delivery_info,