eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_FTE_COMP_CONSTRAINT_GRP dependencies on WSH_FTE_CONSTRAINT_FRAMEWORK

Line 47: l_delivery_info WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;

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;

Line 48: l_delivery_rec WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_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;

Line 49: l_dlvy_assigned_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_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;

Line 50: l_target_trip WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_rec_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;

Line 51: l_target_tripstops WSH_FTE_CONSTRAINT_FRAMEWORK.target_tripstop_cc_rec_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;

Line 52: l_target_trip_assign_dels 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;
56: l_group_info WSH_FTE_COMP_CONSTRAINT_PKG.cc_group_tab_type;

Line 53: l_target_trip_dlvy_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_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;

Line 54: l_target_trip_incl_stops WSH_FTE_CONSTRAINT_FRAMEWORK.stop_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;
58:

Line 59: l_trip_info WSH_FTE_CONSTRAINT_FRAMEWORK.trip_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:
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;

Line 60: l_trip_rec WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_rec_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;

Line 61: l_trip_assigned_dels WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_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:

Line 62: l_trip_dlvy_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_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:
66: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;

Line 63: l_trip_incl_stops WSH_FTE_CONSTRAINT_FRAMEWORK.stop_ccinfo_tab_type;

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';

Line 160: l_action_code := WSH_FTE_CONSTRAINT_FRAMEWORK.G_UPDATE_TRIP;

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,

Line 162: WSH_FTE_CONSTRAINT_FRAMEWORK.validate_constraint_trip(

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,

Line 220: l_action_code := WSH_FTE_CONSTRAINT_FRAMEWORK.G_UPDATE_DLVY;

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,

Line 222: WSH_FTE_CONSTRAINT_FRAMEWORK.validate_constraint_dlvy(

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,

Line 355: l_target_trip WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_rec_type;

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;

Line 356: l_target_trip_stop WSH_FTE_CONSTRAINT_FRAMEWORK.target_tripstop_cc_rec_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:

Line 359: x_output_id_tab WSH_FTE_CONSTRAINT_FRAMEWORK.deconsol_output_tab_type;

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;

Line 361: l_cc_delivery_info 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;

Line 362: l_cc_dlvy_assigned_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_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;

Line 363: l_cc_target_trip_assign_dels 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:

Line 364: l_cc_target_trip_dlvy_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_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:
368: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || g_package_name || '.' || 'is_valid_consol';

Line 365: l_cc_target_trip_incl_stops WSH_FTE_CONSTRAINT_FRAMEWORK.stop_ccinfo_tab_type;

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;

Line 366: l_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;
370:

Line 409: IF WSH_FTE_CONSTRAINT_FRAMEWORK.g_is_fte_installed = 'Y' THEN

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: --

Line 414: l_cc_action_code := WSH_FTE_CONSTRAINT_FRAMEWORK.G_AUTOCRT_MDC;

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,

Line 416: WSH_FTE_CONSTRAINT_FRAMEWORK.validate_constraint_dlvy(

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,

Line 502: WSH_FTE_CONSTRAINT_FRAMEWORK.validate_constraint_deconsol(

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,

Line 579: IF WSH_FTE_CONSTRAINT_FRAMEWORK.g_is_fte_installed = 'Y' THEN -- Bug 5194370

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:

Line 586: l_cc_action_code := WSH_FTE_CONSTRAINT_FRAMEWORK.G_ASSIGN_DLVY_TRIP;

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,

Line 588: WSH_FTE_CONSTRAINT_FRAMEWORK.validate_constraint_dlvy(

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,