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_MDC_SRS dependencies on WSH_FTE_CONSTRAINT_FRAMEWORK

Line 73: -- WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_rec_type and

69: -- p_del_addnl_rec Input delivery record type containing additional info
70: -- RETRUN type Delivery record
71: --
72: -- COMMENT : This function takes delivery records of types
73: -- WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_rec_type and
74: -- WSH_MDC_SRS.addnl_del_attr_rec_type and copies the information
75: -- to a record of type WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type
76: -- and returns it.
77: --========================================================================

Line 79: p_del_ccinfo_rec IN WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_rec_type,

75: -- to a record of type WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type
76: -- and returns it.
77: --========================================================================
78: FUNCTION Copy_Record(
79: p_del_ccinfo_rec IN WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_rec_type,
80: p_del_addnl_rec IN addnl_del_attr_rec_type)
81: RETURN WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type
82: IS
83: x_delivery_rec WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;

Line 146: l_delivery_tab WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;

142: l_status VARCHAR2(10);
143: l_temp BOOLEAN;
144: l_completion_status VARCHAR2(10);
145:
146: l_delivery_tab WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
147: l_delivery_addnl_attr_tab addnl_del_attr_tab_type;
148: l_sel_del_attr select_del_flags_rec_type;
149: l_failed_records WSH_UTIL_CORE.id_tab_type;
150: l_failed_index NUMBER;

Line 170: l_dummy_dlvy_asgnd_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;

166: l_del_all WSH_UTIL_CORE.id_tab_type;
167: l_trips_all WSH_UTIL_CORE.id_tab_type;
168: l_dummy_exception_list WSH_UTIL_CORE.Column_Tab_Type;
169: l_dummy_in_ids WSH_UTIL_CORE.id_tab_type;
170: l_dummy_dlvy_asgnd_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
171: l_dummy_tar_trip WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_rec_type;
172: l_dummy_tar_tstops WSH_FTE_CONSTRAINT_FRAMEWORK.target_tripstop_cc_rec_type;
173: l_dummy_tar_t_asgn_dels WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
174: l_dummy_tar_t_dlvy_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;

Line 171: l_dummy_tar_trip WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_rec_type;

167: l_trips_all WSH_UTIL_CORE.id_tab_type;
168: l_dummy_exception_list WSH_UTIL_CORE.Column_Tab_Type;
169: l_dummy_in_ids WSH_UTIL_CORE.id_tab_type;
170: l_dummy_dlvy_asgnd_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
171: l_dummy_tar_trip WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_rec_type;
172: l_dummy_tar_tstops WSH_FTE_CONSTRAINT_FRAMEWORK.target_tripstop_cc_rec_type;
173: l_dummy_tar_t_asgn_dels WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
174: l_dummy_tar_t_dlvy_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
175: l_dummy_tar_t_incl_stops WSH_FTE_CONSTRAINT_FRAMEWORK.stop_ccinfo_tab_type;

Line 172: l_dummy_tar_tstops WSH_FTE_CONSTRAINT_FRAMEWORK.target_tripstop_cc_rec_type;

168: l_dummy_exception_list WSH_UTIL_CORE.Column_Tab_Type;
169: l_dummy_in_ids WSH_UTIL_CORE.id_tab_type;
170: l_dummy_dlvy_asgnd_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
171: l_dummy_tar_trip WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_rec_type;
172: l_dummy_tar_tstops WSH_FTE_CONSTRAINT_FRAMEWORK.target_tripstop_cc_rec_type;
173: l_dummy_tar_t_asgn_dels WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
174: l_dummy_tar_t_dlvy_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
175: l_dummy_tar_t_incl_stops WSH_FTE_CONSTRAINT_FRAMEWORK.stop_ccinfo_tab_type;
176: l_dummy_val_result VARCHAR2(100);

Line 173: l_dummy_tar_t_asgn_dels WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;

169: l_dummy_in_ids WSH_UTIL_CORE.id_tab_type;
170: l_dummy_dlvy_asgnd_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
171: l_dummy_tar_trip WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_rec_type;
172: l_dummy_tar_tstops WSH_FTE_CONSTRAINT_FRAMEWORK.target_tripstop_cc_rec_type;
173: l_dummy_tar_t_asgn_dels WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
174: l_dummy_tar_t_dlvy_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
175: l_dummy_tar_t_incl_stops WSH_FTE_CONSTRAINT_FRAMEWORK.stop_ccinfo_tab_type;
176: l_dummy_val_result VARCHAR2(100);
177: l_valid_hash BOOLEAN := FALSE;

Line 174: l_dummy_tar_t_dlvy_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;

170: l_dummy_dlvy_asgnd_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
171: l_dummy_tar_trip WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_rec_type;
172: l_dummy_tar_tstops WSH_FTE_CONSTRAINT_FRAMEWORK.target_tripstop_cc_rec_type;
173: l_dummy_tar_t_asgn_dels WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
174: l_dummy_tar_t_dlvy_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
175: l_dummy_tar_t_incl_stops WSH_FTE_CONSTRAINT_FRAMEWORK.stop_ccinfo_tab_type;
176: l_dummy_val_result VARCHAR2(100);
177: l_valid_hash BOOLEAN := FALSE;
178: l_hash_power NUMBER := 24;

Line 175: l_dummy_tar_t_incl_stops WSH_FTE_CONSTRAINT_FRAMEWORK.stop_ccinfo_tab_type;

171: l_dummy_tar_trip WSH_FTE_CONSTRAINT_FRAMEWORK.trip_ccinfo_rec_type;
172: l_dummy_tar_tstops WSH_FTE_CONSTRAINT_FRAMEWORK.target_tripstop_cc_rec_type;
173: l_dummy_tar_t_asgn_dels WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type;
174: l_dummy_tar_t_dlvy_lines WSH_FTE_CONSTRAINT_FRAMEWORK.detail_ccinfo_tab_type;
175: l_dummy_tar_t_incl_stops WSH_FTE_CONSTRAINT_FRAMEWORK.stop_ccinfo_tab_type;
176: l_dummy_val_result VARCHAR2(100);
177: l_valid_hash BOOLEAN := FALSE;
178: l_hash_power NUMBER := 24;
179: l_hash_size NUMBER;

Line 584: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_FTE_CONSTRAINT_FRAMEWORK.validate_constraint_dlvy',WSH_DEBUG_SV.C_PROC_LEVEL);

580: WSH_UTIL_CORE.PrintMsg('Grouping deliveries based on constraints');
581:
582: IF l_debug_on THEN
583: WSH_DEBUG_SV.logmsg(l_module_name,'FTE is installed');
584: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_FTE_CONSTRAINT_FRAMEWORK.validate_constraint_dlvy',WSH_DEBUG_SV.C_PROC_LEVEL);
585: END IF;
586:
587: WSH_FTE_CONSTRAINT_FRAMEWORK.validate_constraint_dlvy(
588: p_init_msg_list => l_init_msg_list,

Line 587: WSH_FTE_CONSTRAINT_FRAMEWORK.validate_constraint_dlvy(

583: WSH_DEBUG_SV.logmsg(l_module_name,'FTE is installed');
584: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_FTE_CONSTRAINT_FRAMEWORK.validate_constraint_dlvy',WSH_DEBUG_SV.C_PROC_LEVEL);
585: END IF;
586:
587: WSH_FTE_CONSTRAINT_FRAMEWORK.validate_constraint_dlvy(
588: p_init_msg_list => l_init_msg_list,
589: p_action_code => 'ACM',
590: p_exception_list => l_dummy_exception_list,
591: p_in_ids => l_dummy_in_ids,

Line 616: WSH_UTIL_CORE.PrintMsg('Error occurred in WSH_FTE_CONSTRAINT_FRAMEWORK.validate_constraint_dlvy');

612: WSH_DEBUG_SV.logmsg(l_module_name, 'Deliveries grouped based on constraints');
613: END IF;
614: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
615: THEN
616: WSH_UTIL_CORE.PrintMsg('Error occurred in WSH_FTE_CONSTRAINT_FRAMEWORK.validate_constraint_dlvy');
617: FOR m in 1..l_msg_count
618: LOOP
619: l_message := fnd_msg_pub.get(m,'F');
620: l_message := replace(l_message,chr(0),' ');

Line 629: errbuf := 'Error occurred in WSH_FTE_CONSTRAINT_FRAMEWORK.validate_constraint_dlvy';

625: END LOOP;
626:
627: fnd_msg_pub.delete_msg();
628: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','');
629: errbuf := 'Error occurred in WSH_FTE_CONSTRAINT_FRAMEWORK.validate_constraint_dlvy';
630: retcode := '2';
631:
632: raise FND_API.G_EXC_ERROR;
633: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING)

Line 1297: x_delivery_tab OUT NOCOPY WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type,

1293: -- COMMENT : This procedure fetches the deliveries to be consolidated.
1294: --========================================================================
1295: PROCEDURE Get_Deliveries(
1296: p_sel_del_attr IN select_del_flags_rec_type,
1297: x_delivery_tab OUT NOCOPY WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type,
1298: x_delivery_addnl_attr_tab OUT NOCOPY addnl_del_attr_tab_type,
1299: x_return_status OUT NOCOPY VARCHAR2)
1300: IS
1301: l_delivery_rec WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_rec_type;

Line 1301: l_delivery_rec WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_rec_type;

1297: x_delivery_tab OUT NOCOPY WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type,
1298: x_delivery_addnl_attr_tab OUT NOCOPY addnl_del_attr_tab_type,
1299: x_return_status OUT NOCOPY VARCHAR2)
1300: IS
1301: l_delivery_rec WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_rec_type;
1302: l_delivery_addnl_rec addnl_del_attr_rec_type;
1303: l_delivery_id NUMBER;
1304: l_select_clause varchar2(1000);
1305: l_from_clause varchar2(1000);

Line 1710: x_delivery_tab IN OUT NOCOPY WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type,

1706: PROCEDURE Set_Intermediate_Location(
1707: p_consol_loc_id IN NUMBER,
1708: p_override_ship_to_flag IN VARCHAR2,
1709: p_rule_zone_id IN NUMBER,
1710: x_delivery_tab IN OUT NOCOPY WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type,
1711: x_delivery_addnl_attr_tab IN OUT NOCOPY addnl_del_attr_tab_type,
1712: x_failed_records IN OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
1713: x_return_status OUT NOCOPY VARCHAR2)
1714: IS

Line 1715: l_deconsol_output_tab WSH_FTE_CONSTRAINT_FRAMEWORK.deconsol_output_tab_type;

1711: x_delivery_addnl_attr_tab IN OUT NOCOPY addnl_del_attr_tab_type,
1712: x_failed_records IN OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
1713: x_return_status OUT NOCOPY VARCHAR2)
1714: IS
1715: l_deconsol_output_tab WSH_FTE_CONSTRAINT_FRAMEWORK.deconsol_output_tab_type;
1716: l_delivery_id NUMBER;
1717: l_failed_index NUMBER;
1718: l_dummy_list WSH_UTIL_CORE.id_tab_type;
1719: l_override_flag BOOLEAN;

Line 1766: WSH_FTE_CONSTRAINT_FRAMEWORK.validate_constraint_deconsol(

1762: IF l_debug_on THEN
1763: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_FTE_COMP_CONSTRAINT_PKG.validate_constraint_deconsol',WSH_DEBUG_SV.C_PROC_LEVEL);
1764: END IF;
1765:
1766: WSH_FTE_CONSTRAINT_FRAMEWORK.validate_constraint_deconsol(
1767: p_init_msg_list => l_init_msg_list,
1768: p_delivery_info => x_delivery_tab,
1769: p_in_ids => l_dummy_list,
1770: p_rule_to_zone_id => p_rule_zone_id,

Line 2003: x_delivery_rec IN OUT NOCOPY WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_rec_type,

1999: -- The procedure also clears out all the non-grouping
2000: -- attributes from the delivery records
2001: --========================================================================
2002: PROCEDURE Get_Hash_Value(
2003: x_delivery_rec IN OUT NOCOPY WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_rec_type,
2004: x_delivery_addnl_attr_rec IN OUT NOCOPY addnl_del_attr_rec_type,
2005: p_group_by_flags IN group_by_flags_rec_type,
2006: p_hash_base IN NUMBER,
2007: p_hash_size IN NUMBER,

Line 2225: x_delivery_tab IN OUT NOCOPY WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type,

2221: -- The max consolidation trip weight and trip name prefix
2222: -- can also be specified.
2223: --========================================================================
2224: PROCEDURE Create_Consolidations(
2225: x_delivery_tab IN OUT NOCOPY WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type,
2226: x_delivery_addnl_attr_tab IN OUT NOCOPY addnl_del_attr_tab_type,
2227: p_group_tab IN grp_attr_tab_type,
2228: p_max_trip_weight IN NUMBER,
2229: p_max_weight_uom IN VARCHAR2,

Line 2558: x_delivery_tab IN OUT NOCOPY WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type,

2554: -- COMMENT : This procedure takes the delivery records and and creates
2555: -- cdeconsolidation trips for the deliveries.
2556: --========================================================================
2557: PROCEDURE Create_Deconsol_Trips(
2558: x_delivery_tab IN OUT NOCOPY WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type,
2559: x_delivery_addnl_attr_tab IN OUT NOCOPY addnl_del_attr_tab_type,
2560: p_consol_trip_id IN WSH_UTIL_CORE.id_tab_type,
2561: p_trip_name_prefix IN VARCHAR2,
2562: x_trips_all IN OUT NOCOPY WSH_UTIL_CORE.id_tab_type,