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 2226: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;

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

Line 2347: WSH_SHIPPING_PARAMS_PVT.Get(

2343:
2344: ELSE
2345: /*Modified R12.1.1 LSP PROJECT*/
2346:
2347: WSH_SHIPPING_PARAMS_PVT.Get(
2348: p_organization_id => l_organization_id,
2349: x_param_info => l_param_info,
2350: x_return_status => l_return_status);
2351:

Line 2879: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;

2875: u_stop_rows wsh_util_core.id_tab_type; -- bug 2064810
2876: l_del_rows wsh_util_core.id_tab_type;
2877: u_del_rows wsh_util_core.id_tab_type;
2878:
2879: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;
2880: l_enforce_packing_flag VARCHAR2(1) := 'N';
2881:
2882: l_cc_qtys wsh_util_core.id_tab_type; -- list of details BO qty
2883: l_cc_req_qtys wsh_util_core.id_tab_type ;

Line 3002: l_global_parameters WSH_SHIPPING_PARAMS_PVT.Global_Parameters_Rec_Typ;

2998: l_with_mc_trip_flag Flag_Tab_Type;
2999:
3000: -- Variables added for Consolidation of BO Delivery Details project
3001: --
3002: l_global_parameters WSH_SHIPPING_PARAMS_PVT.Global_Parameters_Rec_Typ;
3003: l_assigned_source_lines wsh_util_core.id_Tab_Type;
3004: l_unassign_backordered_dds wsh_util_core.id_Tab_Type; --Stores the list of BackOrder/Cycle-Count delivery detail ids
3005: l_unassign_rel_status wsh_util_core.Column_Tab_Type;
3006: -- Stores the corresponding Released_status of the delivery details in l_unassign_dds

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

3234: l_check_credit_init_flag := TRUE;
3235:
3236: -- Code Shifted from below to execute irrespective of the If condition - Workflow Changes
3237: IF l_debug_on THEN
3238: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit 2WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters',WSH_DEBUG_SV.C_PROC_LEVEL);
3239: END IF;
3240: --
3241: WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters(l_global_parameters, l_return_status);
3242: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,

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

3237: IF l_debug_on THEN
3238: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit 2WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters',WSH_DEBUG_SV.C_PROC_LEVEL);
3239: END IF;
3240: --
3241: WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters(l_global_parameters, l_return_status);
3242: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
3243: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
3244: raise ship_confirm_error;
3245: -- x_return_status := l_return_status;

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

5291:
5292:
5293: -- Code Shifted from below 12. *** to here, since this is a mandatory step now - Workflow Changes
5294: IF l_debug_on THEN
5295: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.GET',WSH_DEBUG_SV.C_PROC_LEVEL);
5296: END IF;
5297: --
5298: WSH_SHIPPING_PARAMS_PVT.Get(
5299: p_organization_id => l_organization_id,

Line 5298: WSH_SHIPPING_PARAMS_PVT.Get(

5294: IF l_debug_on THEN
5295: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.GET',WSH_DEBUG_SV.C_PROC_LEVEL);
5296: END IF;
5297: --
5298: WSH_SHIPPING_PARAMS_PVT.Get(
5299: p_organization_id => l_organization_id,
5300: x_param_info => l_param_info,
5301: x_return_status => l_return_status
5302: );

Line 11303: l_param_value_info WSH_SHIPPING_PARAMS_PVT.PARAMETER_VALUE_REC_TYP;

11299: l_error_text VARCHAR2(2000);
11300: l_del_org_id NUMBER;
11301: l_prev_org_id NUMBER;
11302: l_skip_rtng_rule_ac_trip VARCHAR2(1) := 'N';
11303: l_param_value_info WSH_SHIPPING_PARAMS_PVT.PARAMETER_VALUE_REC_TYP;
11304: l_ignore_for_planning WSH_TRIPS.ignore_for_planning%TYPE;
11305: --
11306: l_debug_on BOOLEAN;
11307: --

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

11538:
11539: l_param_value_info.organization_id := l_del_org_id;
11540: l_param_value_info.param_name(1) := 'SKIP_RTNG_RULE_AC_TRIP';
11541:
11542: WSH_SHIPPING_PARAMS_PVT.Get(x_param_value_info => l_param_value_info,
11543: x_return_status => x_return_status);
11544: l_skip_rtng_rule_ac_trip := l_param_value_info.PARAM_VALUE_CHR(1);
11545: END IF;
11546: END IF;

Line 11885: l_global_param_rec WSH_SHIPPING_PARAMS_PVT.Global_Parameters_Rec_Typ;

11881: l_ultimate_dropoff_date DATE;
11882: i NUMBER;
11883: j NUMBER;
11884: k NUMBER;
11885: l_global_param_rec WSH_SHIPPING_PARAMS_PVT.Global_Parameters_Rec_Typ;
11886: l_param_value_info WSH_SHIPPING_PARAMS_PVT.PARAMETER_VALUE_REC_TYP;
11887: l_prev_delivery_id NUMBER;
11888: l_start_index NUMBER;
11889: l_end_index NUMBER;

Line 11886: l_param_value_info WSH_SHIPPING_PARAMS_PVT.PARAMETER_VALUE_REC_TYP;

11882: i NUMBER;
11883: j NUMBER;
11884: k NUMBER;
11885: l_global_param_rec WSH_SHIPPING_PARAMS_PVT.Global_Parameters_Rec_Typ;
11886: l_param_value_info WSH_SHIPPING_PARAMS_PVT.PARAMETER_VALUE_REC_TYP;
11887: l_prev_delivery_id NUMBER;
11888: l_start_index NUMBER;
11889: l_end_index NUMBER;
11890: rec_cnt NUMBER;

Line 11911: l_param_rec WSH_SHIPPING_PARAMS_PVT.PARAMETER_VALUE_REC_TYP;

11907:
11908: itr NUMBER;
11909: l_cnt NUMBER := 0;
11910: l_start_search_level_flag VARCHAR2(10) := 'SCOE';
11911: l_param_rec WSH_SHIPPING_PARAMS_PVT.PARAMETER_VALUE_REC_TYP;
11912: l_num_ranked_results NUMBER;
11913: -- sbakshi
11914:
11915: -- Debug Variables

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

12259: l_param_rec.organization_id := l_dlvy_info_tab(i).l_organization_id;
12260: l_param_rec.param_name(1) := 'EVAL_RULE_BASED_ON_SHIPTO_CUST';
12261:
12262:
12263: WSH_SHIPPING_PARAMS_PVT.Get(x_param_value_info => l_param_rec ,
12264: x_return_status => l_return_status);
12265:
12266: IF l_debug_on THEN
12267: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status after getting shipping params '||l_return_status);

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

12368: l_end_index := 0;
12369:
12370: /*
12371: -- Hiding project
12372: WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters( x_Param_Info => l_global_param_rec,
12373: x_return_status => l_return_status);
12374: */ -- Hiding project
12375:
12376: rec_cnt := l_cs_result_tab.FIRST;

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

12406:
12407: l_param_value_info.organization_id := l_del_org_id;
12408: l_param_value_info.param_name(1) := 'SKIP_RTNG_RULE_AC_TRIP';
12409:
12410: WSH_SHIPPING_PARAMS_PVT.Get(x_param_value_info => l_param_value_info,
12411: x_return_status => l_return_status);
12412: l_skip_rtng_rule_ac_trip := l_param_value_info.PARAM_VALUE_CHR(1);
12413: END IF;
12414: */ -- Hiding project