DBA Data[Home] [Help]

APPS.WSH_MDC_SRS dependencies on WSH_DELIVERIES_GRP

Line 161: l_action_params WSH_DELIVERIES_GRP.action_parameters_rectype;

157: l_del_index NUMBER;
158: l_cont_cnt NUMBER;
159: l_trip_id NUMBER;
160: l_unassign_trip_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
161: l_action_params WSH_DELIVERIES_GRP.action_parameters_rectype;
162: l_rating_in_param_rec WSH_FTE_INTEGRATION.rate_del_in_param_rec;
163: l_rating_out_param_rec WSH_FTE_INTEGRATION.rate_del_out_param_rec;
164: l_consol_trip_id WSH_UTIL_CORE.id_tab_type;
165: l_consol_del_id WSH_UTIL_CORE.id_tab_type;

Line 181: l_delivery_out_rec WSH_DELIVERIES_GRP.Delivery_Action_Out_Rec_Type;

177: l_valid_hash BOOLEAN := FALSE;
178: l_hash_power NUMBER := 24;
179: l_hash_size NUMBER;
180: l_hash_base NUMBER := 1;
181: l_delivery_out_rec WSH_DELIVERIES_GRP.Delivery_Action_Out_Rec_Type;
182: l_defaults_rec WSH_DELIVERIES_GRP.default_parameters_rectype;
183:
184: l_init_msg_list VARCHAR2(1000);
185: l_failed_lines WSH_FTE_COMP_CONSTRAINT_PKG.failed_line_tab_type;

Line 182: l_defaults_rec WSH_DELIVERIES_GRP.default_parameters_rectype;

178: l_hash_power NUMBER := 24;
179: l_hash_size NUMBER;
180: l_hash_base NUMBER := 1;
181: l_delivery_out_rec WSH_DELIVERIES_GRP.Delivery_Action_Out_Rec_Type;
182: l_defaults_rec WSH_DELIVERIES_GRP.default_parameters_rectype;
183:
184: l_init_msg_list VARCHAR2(1000);
185: l_failed_lines WSH_FTE_COMP_CONSTRAINT_PKG.failed_line_tab_type;
186: l_line_groups WSH_FTE_COMP_CONSTRAINT_PKG.line_group_tab_type;

Line 485: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERIES_GRP.Delivery_Action',WSH_DEBUG_SV.C_PROC_LEVEL);

481: CLOSE Get_Trip;
482:
483: IF l_debug_on THEN
484: WSH_DEBUG_SV.logmsg(l_module_name,'Unassigning delivery '||l_delivery_tab(i).delivery_id||' from it''s delivery leg');
485: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERIES_GRP.Delivery_Action',WSH_DEBUG_SV.C_PROC_LEVEL);
486: END IF;
487: l_unassign_trip_tab(1) := Copy_Record(l_delivery_tab(i), l_delivery_addnl_attr_tab(i));
488:
489: l_action_params.action_code := 'UNASSIGN-TRIP';

Line 492: WSH_DELIVERIES_GRP.Delivery_Action

488:
489: l_action_params.action_code := 'UNASSIGN-TRIP';
490: l_action_params.caller := 'FTE_CONSOL_SRS';
491: l_action_params.trip_id := l_trip_id;
492: WSH_DELIVERIES_GRP.Delivery_Action
493: ( p_api_version_number => l_api_version_number,
494: p_init_msg_list => l_init_msg_list,
495: p_commit => l_commit,
496: p_action_prms => l_action_params,

Line 513: WSH_UTIL_CORE.PrintMsg('Error occurred in WSH_DELIVERIES_GRP.Delivery_Action');

509: END IF;
510: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
511: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
512: THEN
513: WSH_UTIL_CORE.PrintMsg('Error occurred in WSH_DELIVERIES_GRP.Delivery_Action');
514: FOR m in 1..l_msg_count
515: LOOP
516: l_message := fnd_msg_pub.get(m,'F');
517: l_message := replace(l_message,chr(0),' ');

Line 2245: l_action_params WSH_DELIVERIES_GRP.Action_Parameters_Rectype;

2241: l_d_id NUMBER;
2242: l_del_weight NUMBER;
2243: l_failed_index NUMBER;
2244: l_del_rec WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
2245: l_action_params WSH_DELIVERIES_GRP.Action_Parameters_Rectype;
2246: l_consol_tab consolidation_tab;
2247: l_init_msg_list VARCHAR2(1000);
2248: l_delivery_out_rec WSH_DELIVERIES_GRP.Delivery_Action_Out_Rec_Type;
2249: l_defaults_rec WSH_DELIVERIES_GRP.Default_Parameters_Rectype;

Line 2248: l_delivery_out_rec WSH_DELIVERIES_GRP.Delivery_Action_Out_Rec_Type;

2244: l_del_rec WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
2245: l_action_params WSH_DELIVERIES_GRP.Action_Parameters_Rectype;
2246: l_consol_tab consolidation_tab;
2247: l_init_msg_list VARCHAR2(1000);
2248: l_delivery_out_rec WSH_DELIVERIES_GRP.Delivery_Action_Out_Rec_Type;
2249: l_defaults_rec WSH_DELIVERIES_GRP.Default_Parameters_Rectype;
2250: l_index NUMBER;
2251: l_consol_count NUMBER; -- count of consolidations so far
2252: l_count NUMBER; -- l_consol_count + l_consol_index

Line 2249: l_defaults_rec WSH_DELIVERIES_GRP.Default_Parameters_Rectype;

2245: l_action_params WSH_DELIVERIES_GRP.Action_Parameters_Rectype;
2246: l_consol_tab consolidation_tab;
2247: l_init_msg_list VARCHAR2(1000);
2248: l_delivery_out_rec WSH_DELIVERIES_GRP.Delivery_Action_Out_Rec_Type;
2249: l_defaults_rec WSH_DELIVERIES_GRP.Default_Parameters_Rectype;
2250: l_index NUMBER;
2251: l_consol_count NUMBER; -- count of consolidations so far
2252: l_count NUMBER; -- l_consol_count + l_consol_index
2253: l_mesg_count NUMBER;

Line 2450: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERIES_GRP.Delivery_ACTION',WSH_DEBUG_SV.C_PROC_LEVEL);

2446:
2447: -- Create consol deliveries
2448: IF l_debug_on THEN
2449: WSH_DEBUG_SV.logmsg(l_module_name,'Creating consolidation delivery for consolidation no. '||l_consol_tab(k).consol_index);
2450: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERIES_GRP.Delivery_ACTION',WSH_DEBUG_SV.C_PROC_LEVEL);
2451: END IF;
2452:
2453: WSH_DELIVERIES_GRP.Delivery_ACTION(
2454: p_api_version_number => l_api_version_number,

Line 2453: WSH_DELIVERIES_GRP.Delivery_ACTION(

2449: WSH_DEBUG_SV.logmsg(l_module_name,'Creating consolidation delivery for consolidation no. '||l_consol_tab(k).consol_index);
2450: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERIES_GRP.Delivery_ACTION',WSH_DEBUG_SV.C_PROC_LEVEL);
2451: END IF;
2452:
2453: WSH_DELIVERIES_GRP.Delivery_ACTION(
2454: p_api_version_number => l_api_version_number,
2455: p_init_msg_list => l_init_msg_list,
2456: p_commit => l_commit,
2457: p_action_prms => l_action_params,

Line 2473: WSH_UTIL_CORE.PrintMsg('Error occurred in WSH_DELIVERIES_GRP.Delivery_ACTION');

2469: END IF;
2470: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
2471: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
2472: THEN
2473: WSH_UTIL_CORE.PrintMsg('Error occurred in WSH_DELIVERIES_GRP.Delivery_ACTION');
2474: FOR i in 1..l_mesg_count
2475: LOOP
2476: l_message := fnd_msg_pub.get(m,'F');
2477: l_message := replace(l_message,chr(0),' ');

Line 2586: l_action_prms WSH_DELIVERIES_GRP.action_parameters_rectype;

2582: l_dropoff_stop_info WSH_TRIP_STOPS_PVT.Trip_Stop_Rec_Type;
2583: l_dropoff_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
2584: l_dropoff_stop_out_tab WSH_TRIP_STOPS_GRP.stop_out_tab_type;
2585: l_stop_wt_vol_out_tab WSH_TRIP_STOPS_GRP.Stop_Wt_Vol_tab_type;
2586: l_action_prms WSH_DELIVERIES_GRP.action_parameters_rectype;
2587: l_rec_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
2588: l_delivery_out_rec WSH_DELIVERIES_GRP.Delivery_Action_Out_Rec_Type;
2589: l_defaults_rec WSH_DELIVERIES_GRP.default_parameters_rectype;
2590: l_unplan_action_prms WSH_TRIPS_GRP.action_parameters_rectype;

Line 2588: l_delivery_out_rec WSH_DELIVERIES_GRP.Delivery_Action_Out_Rec_Type;

2584: l_dropoff_stop_out_tab WSH_TRIP_STOPS_GRP.stop_out_tab_type;
2585: l_stop_wt_vol_out_tab WSH_TRIP_STOPS_GRP.Stop_Wt_Vol_tab_type;
2586: l_action_prms WSH_DELIVERIES_GRP.action_parameters_rectype;
2587: l_rec_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
2588: l_delivery_out_rec WSH_DELIVERIES_GRP.Delivery_Action_Out_Rec_Type;
2589: l_defaults_rec WSH_DELIVERIES_GRP.default_parameters_rectype;
2590: l_unplan_action_prms WSH_TRIPS_GRP.action_parameters_rectype;
2591: l_unplan_rec_attr WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
2592: l_unplan_dummy_out WSH_TRIPS_GRP.tripActionOutRecType;

Line 2589: l_defaults_rec WSH_DELIVERIES_GRP.default_parameters_rectype;

2585: l_stop_wt_vol_out_tab WSH_TRIP_STOPS_GRP.Stop_Wt_Vol_tab_type;
2586: l_action_prms WSH_DELIVERIES_GRP.action_parameters_rectype;
2587: l_rec_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
2588: l_delivery_out_rec WSH_DELIVERIES_GRP.Delivery_Action_Out_Rec_Type;
2589: l_defaults_rec WSH_DELIVERIES_GRP.default_parameters_rectype;
2590: l_unplan_action_prms WSH_TRIPS_GRP.action_parameters_rectype;
2591: l_unplan_rec_attr WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
2592: l_unplan_dummy_out WSH_TRIPS_GRP.tripActionOutRecType;
2593: l_unplan_dummy_def WSH_TRIPS_GRP.default_parameters_rectype;

Line 3013: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERIES_GRP.Delivery_Action',WSH_DEBUG_SV.C_PROC_LEVEL);

3009: l_rec_attr_tab(1).shipping_control := x_delivery_tab(i).shipping_control;
3010:
3011: IF l_debug_on THEN
3012: WSH_DEBUG_SV.logmsg(l_module_name,'Assigning delivery to trip');
3013: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERIES_GRP.Delivery_Action',WSH_DEBUG_SV.C_PROC_LEVEL);
3014: END IF;
3015:
3016:
3017: WSH_DELIVERIES_GRP.Delivery_Action(

Line 3017: WSH_DELIVERIES_GRP.Delivery_Action(

3013: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERIES_GRP.Delivery_Action',WSH_DEBUG_SV.C_PROC_LEVEL);
3014: END IF;
3015:
3016:
3017: WSH_DELIVERIES_GRP.Delivery_Action(
3018: p_api_version_number => l_api_version_number,
3019: p_init_msg_list => l_init_msg_list,
3020: p_commit => l_commit,
3021: p_action_prms => l_action_prms,

Line 3037: WSH_UTIL_CORE.PrintMsg('Error occurred in WSH_DELIVERIES_GRP.Delivery_Action');

3033: END IF;
3034: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
3035: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
3036: THEN
3037: WSH_UTIL_CORE.PrintMsg('Error occurred in WSH_DELIVERIES_GRP.Delivery_Action');
3038: IF l_debug_on THEN
3039: FOR m in 1..l_msg_count
3040: LOOP
3041: l_message := fnd_msg_pub.get(m,'F');