DBA Data[Home] [Help]

APPS.WSH_NEW_DELIVERY_ACTIONS dependencies on WSH_SHIPPING_PARAMS_PVT

Line 700: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;

696: l_delivery_detail_count NUMBER := 0;
697: l_delivery_id NUMBER := 0;
698: l_auto_rate_tbl WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
699: l_select_carrier_tbl WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
700: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;
701: l_return_status VARCHAR2(1);
702: l_status_code VARCHAR2(30) := 'OP';
703: l_dels_to_update WSH_UTIL_CORE.Id_Tab_Type;
704: l_action_prms WSH_DELIVERIES_GRP.action_parameters_rectype;

Line 862: WSH_SHIPPING_PARAMS_PVT.Get(

858: l_assigned_to_trip := WSH_DELIVERY_VALIDATIONS.Del_Assigned_To_Trip(
859: p_delivery_id => p_delivery_ids(i),
860: x_return_status => l_return_status);
861:
862: WSH_SHIPPING_PARAMS_PVT.Get(
863: p_organization_id => l_organization_id,
864: x_param_info => l_param_info,
865: x_return_status => l_return_status);
866:

Line 868: wsh_debug_sv.logmsg(l_module_name, 'Return status from WSH_SHIPPING_PARAMS_PVT.Get is :'||l_return_status );

864: x_param_info => l_param_info,
865: x_return_status => l_return_status);
866:
867: IF l_debug_on THEN
868: wsh_debug_sv.logmsg(l_module_name, 'Return status from WSH_SHIPPING_PARAMS_PVT.Get is :'||l_return_status );
869: END IF;
870:
871:
872: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

Line 939: WSH_SHIPPING_PARAMS_PVT.Get(

935: l_assigned_to_trip := WSH_DELIVERY_VALIDATIONS.Del_Assigned_To_Trip(
936: p_delivery_id => p_delivery_ids(i),
937: x_return_status => l_return_status);
938:
939: WSH_SHIPPING_PARAMS_PVT.Get(
940: p_organization_id => l_organization_id,
941: x_param_info => l_param_info,
942: x_return_status => l_return_status);
943:

Line 945: wsh_debug_sv.logmsg(l_module_name, 'Return status from WSH_SHIPPING_PARAMS_PVT.Get is :'||l_return_status );

941: x_param_info => l_param_info,
942: x_return_status => l_return_status);
943:
944: IF l_debug_on THEN
945: wsh_debug_sv.logmsg(l_module_name, 'Return status from WSH_SHIPPING_PARAMS_PVT.Get is :'||l_return_status );
946: END IF;
947: -- handle return status
948:
949: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

Line 2225: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;

2221: l_trip_id NUMBER;
2222: l_prev_organization_id NUMBER; -- to find out the Prev. Org. Id
2223: l_organization_id NUMBER;
2224: l_all_orgids_match BOOLEAN := TRUE;
2225: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;
2226:
2227: l_num_warn NUMBER := 0;
2228: l_count NUMBER := 0;
2229:

Line 2319: WSH_SHIPPING_PARAMS_PVT.Get(

2315: x_autoclose_flag := 'N';
2316:
2317:
2318: IF (l_all_orgids_match = TRUE) THEN --{
2319: WSH_SHIPPING_PARAMS_PVT.Get(
2320: p_organization_id => l_organization_id,
2321: x_param_info => l_param_info,
2322: x_return_status => l_return_status);
2323: OPEN report_set(l_param_info.delivery_report_set_id);

Line 2841: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;

2837: u_stop_rows wsh_util_core.id_tab_type; -- bug 2064810
2838: l_del_rows wsh_util_core.id_tab_type;
2839: u_del_rows wsh_util_core.id_tab_type;
2840:
2841: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;
2842: l_enforce_packing_flag VARCHAR2(1) := 'N';
2843:
2844: l_cc_qtys wsh_util_core.id_tab_type; -- list of details BO qty
2845: l_cc_req_qtys wsh_util_core.id_tab_type ;

Line 2964: l_global_parameters WSH_SHIPPING_PARAMS_PVT.Global_Parameters_Rec_Typ;

2960: l_with_mc_trip_flag Flag_Tab_Type;
2961:
2962: -- Variables added for Consolidation of BO Delivery Details project
2963: --
2964: l_global_parameters WSH_SHIPPING_PARAMS_PVT.Global_Parameters_Rec_Typ;
2965: l_assigned_source_lines wsh_util_core.id_Tab_Type;
2966: l_unassign_backordered_dds wsh_util_core.id_Tab_Type; --Stores the list of BackOrder/Cycle-Count delivery detail ids
2967: l_unassign_rel_status wsh_util_core.Column_Tab_Type;
2968: -- Stores the corresponding Released_status of the delivery details in l_unassign_dds

Line 3190: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit 2WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters',WSH_DEBUG_SV.C_PROC_LEVEL);

3186: l_check_credit_init_flag := TRUE;
3187:
3188: -- Code Shifted from below to execute irrespective of the If condition - Workflow Changes
3189: IF l_debug_on THEN
3190: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit 2WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters',WSH_DEBUG_SV.C_PROC_LEVEL);
3191: END IF;
3192: --
3193: WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters(l_global_parameters, l_return_status);
3194: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,

Line 3193: WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters(l_global_parameters, l_return_status);

3189: IF l_debug_on THEN
3190: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit 2WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters',WSH_DEBUG_SV.C_PROC_LEVEL);
3191: END IF;
3192: --
3193: WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters(l_global_parameters, l_return_status);
3194: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
3195: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
3196: raise ship_confirm_error;
3197: -- x_return_status := l_return_status;

Line 5211: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.GET',WSH_DEBUG_SV.C_PROC_LEVEL);

5207:
5208:
5209: -- Code Shifted from below 12. *** to here, since this is a mandatory step now - Workflow Changes
5210: IF l_debug_on THEN
5211: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.GET',WSH_DEBUG_SV.C_PROC_LEVEL);
5212: END IF;
5213: --
5214: WSH_SHIPPING_PARAMS_PVT.Get(
5215: p_organization_id => l_organization_id,

Line 5214: WSH_SHIPPING_PARAMS_PVT.Get(

5210: IF l_debug_on THEN
5211: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.GET',WSH_DEBUG_SV.C_PROC_LEVEL);
5212: END IF;
5213: --
5214: WSH_SHIPPING_PARAMS_PVT.Get(
5215: p_organization_id => l_organization_id,
5216: x_param_info => l_param_info,
5217: x_return_status => l_return_status
5218: );

Line 11107: l_param_value_info WSH_SHIPPING_PARAMS_PVT.PARAMETER_VALUE_REC_TYP;

11103: l_error_text VARCHAR2(2000);
11104: l_del_org_id NUMBER;
11105: l_prev_org_id NUMBER;
11106: l_skip_rtng_rule_ac_trip VARCHAR2(1) := 'N';
11107: l_param_value_info WSH_SHIPPING_PARAMS_PVT.PARAMETER_VALUE_REC_TYP;
11108: l_ignore_for_planning WSH_TRIPS.ignore_for_planning%TYPE;
11109: --
11110: l_debug_on BOOLEAN;
11111: --

Line 11346: WSH_SHIPPING_PARAMS_PVT.Get(x_param_value_info => l_param_value_info,

11342:
11343: l_param_value_info.organization_id := l_del_org_id;
11344: l_param_value_info.param_name(1) := 'SKIP_RTNG_RULE_AC_TRIP';
11345:
11346: WSH_SHIPPING_PARAMS_PVT.Get(x_param_value_info => l_param_value_info,
11347: x_return_status => x_return_status);
11348: l_skip_rtng_rule_ac_trip := l_param_value_info.PARAM_VALUE_CHR(1);
11349: END IF;
11350: END IF;

Line 11690: l_global_param_rec WSH_SHIPPING_PARAMS_PVT.Global_Parameters_Rec_Typ;

11686: l_ultimate_dropoff_date DATE;
11687: i NUMBER;
11688: j NUMBER;
11689: k NUMBER;
11690: l_global_param_rec WSH_SHIPPING_PARAMS_PVT.Global_Parameters_Rec_Typ;
11691: l_param_value_info WSH_SHIPPING_PARAMS_PVT.PARAMETER_VALUE_REC_TYP;
11692: l_prev_delivery_id NUMBER;
11693: l_start_index NUMBER;
11694: l_end_index NUMBER;

Line 11691: l_param_value_info WSH_SHIPPING_PARAMS_PVT.PARAMETER_VALUE_REC_TYP;

11687: i NUMBER;
11688: j NUMBER;
11689: k NUMBER;
11690: l_global_param_rec WSH_SHIPPING_PARAMS_PVT.Global_Parameters_Rec_Typ;
11691: l_param_value_info WSH_SHIPPING_PARAMS_PVT.PARAMETER_VALUE_REC_TYP;
11692: l_prev_delivery_id NUMBER;
11693: l_start_index NUMBER;
11694: l_end_index NUMBER;
11695: rec_cnt NUMBER;

Line 11716: l_param_rec WSH_SHIPPING_PARAMS_PVT.PARAMETER_VALUE_REC_TYP;

11712:
11713: itr NUMBER;
11714: l_cnt NUMBER := 0;
11715: l_start_search_level_flag VARCHAR2(10) := 'SCOE';
11716: l_param_rec WSH_SHIPPING_PARAMS_PVT.PARAMETER_VALUE_REC_TYP;
11717: l_num_ranked_results NUMBER;
11718: -- sbakshi
11719:
11720: -- Debug Variables

Line 12068: WSH_SHIPPING_PARAMS_PVT.Get(x_param_value_info => l_param_rec ,

12064: l_param_rec.organization_id := l_dlvy_info_tab(i).l_organization_id;
12065: l_param_rec.param_name(1) := 'EVAL_RULE_BASED_ON_SHIPTO_CUST';
12066:
12067:
12068: WSH_SHIPPING_PARAMS_PVT.Get(x_param_value_info => l_param_rec ,
12069: x_return_status => l_return_status);
12070:
12071: IF l_debug_on THEN
12072: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status after getting shipping params '||l_return_status);

Line 12177: WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters( x_Param_Info => l_global_param_rec,

12173: l_end_index := 0;
12174:
12175: /*
12176: -- Hiding project
12177: WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters( x_Param_Info => l_global_param_rec,
12178: x_return_status => l_return_status);
12179: */ -- Hiding project
12180:
12181: rec_cnt := l_cs_result_tab.FIRST;

Line 12215: WSH_SHIPPING_PARAMS_PVT.Get(x_param_value_info => l_param_value_info,

12211:
12212: l_param_value_info.organization_id := l_del_org_id;
12213: l_param_value_info.param_name(1) := 'SKIP_RTNG_RULE_AC_TRIP';
12214:
12215: WSH_SHIPPING_PARAMS_PVT.Get(x_param_value_info => l_param_value_info,
12216: x_return_status => l_return_status);
12217: l_skip_rtng_rule_ac_trip := l_param_value_info.PARAM_VALUE_CHR(1);
12218: END IF;
12219: */ -- Hiding project