[Home] [Help]
PACKAGE BODY: APPS.WSH_SHIPPING_PARAMS_GRP
Source
1 PACKAGE BODY WSH_SHIPPING_PARAMS_GRP as
2 /* $Header: WSHSPGPB.pls 120.0.12010000.4 2008/10/23 14:21:15 mvudugul ship $ */
3
4
5 --
6 -- Package Variables
7 --
8
9 G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_SHIPPING_PARAMS_GRP';
10
11 --
12 -- Procedure: Get_Shipping_Parameters
13 -- Parameters: p_organization_id - Organization's parameters
14 -- x_param_info - Record of all parameter info
15 -- x_return_status - return status of the API
16
17 PROCEDURE Get_Shipping_Parameters
18 (p_organization_id IN NUMBER,
19 x_param_info OUT NOCOPY Shipping_Params_Rec,
20 x_return_status OUT NOCOPY VARCHAR2) IS
21
22 --
23 --
24 l_shipping_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;
25 l_param_info Shipping_Params_Rec;
26 l_return_status VARCHAR2(1);
27 --
28 l_debug_on BOOLEAN;
29 --
30 l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'GET_SHIPPING_PARAMETERS';
31 --
32
33 BEGIN
34
35
36 --
37 l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
38 --
39
40 IF l_debug_on IS NULL
41 THEN
42 l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
43 END IF;
44 --
45
46 IF l_debug_on THEN
47 WSH_DEBUG_SV.push(l_module_name);
48 WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
49 END IF;
50
51 --
52 x_return_status := FND_API.G_RET_STS_SUCCESS;
53
54 -- Fetch Shipping Parameters using WSH_SHIPPING_PARAMS_PVT.Get
55
56 WSH_SHIPPING_PARAMS_PVT.Get(p_organization_id => p_organization_id,
57 x_param_info => l_shipping_param_info,
58 x_return_status => l_return_status);
59
60 l_param_info.SHIP_CONFIRM_RULE_ID := l_shipping_param_info.SHIP_CONFIRM_RULE_ID;
61 l_param_info.AUTOPACK_LEVEL := l_shipping_param_info.AUTOPACK_LEVEL;
62 l_param_info.TASK_PLANNING_FLAG := l_shipping_param_info.TASK_PLANNING_FLAG;
63 l_param_info.EXPORT_SCREENING_FLAG := l_shipping_param_info.EXPORT_SCREENING_FLAG;
64 l_param_info.APPENDING_LIMIT := l_shipping_param_info.APPENDING_LIMIT;
65 l_param_info.IGNORE_INBOUND_TRIP := l_shipping_param_info.IGNORE_INBOUND_TRIP;
66 l_param_info.PACK_SLIP_REQUIRED_FLAG:= l_shipping_param_info.PACK_SLIP_REQUIRED_FLAG;
67 l_param_info.PICK_SEQUENCE_RULE_ID := l_shipping_param_info.PICK_SEQUENCE_RULE_ID;
68 l_param_info.PICK_GROUPING_RULE_ID := l_shipping_param_info.PICK_GROUPING_RULE_ID;
69 l_param_info.PRINT_PICK_SLIP_MODE := l_shipping_param_info.PRINT_PICK_SLIP_MODE;
70 l_param_info.PICK_RELEASE_REPORT_SET_ID:= l_shipping_param_info.PICK_RELEASE_REPORT_SET_ID;
71 l_param_info.AUTOCREATE_DEL_ORDERS_FLAG:= l_shipping_param_info.AUTOCREATE_DEL_ORDERS_FLAG;
72 l_param_info.DEFAULT_STAGE_SUBINVENTORY:= l_shipping_param_info.DEFAULT_STAGE_SUBINVENTORY;
73 l_param_info.DEFAULT_STAGE_LOCATOR_ID := l_shipping_param_info.DEFAULT_STAGE_LOCATOR_ID;
74 l_param_info.AUTODETAIL_PR_FLAG := l_shipping_param_info.AUTODETAIL_PR_FLAG;
75 l_param_info.ENFORCE_PACKING_FLAG := l_shipping_param_info.ENFORCE_PACKING_FLAG;
76 l_param_info.GROUP_BY_CUSTOMER_FLAG := l_shipping_param_info.GROUP_BY_CUSTOMER_FLAG;
77 l_param_info.GROUP_BY_FOB_FLAG := l_shipping_param_info.GROUP_BY_FOB_FLAG;
78 l_param_info.GROUP_BY_FREIGHT_TERMS_FLAG := l_shipping_param_info.GROUP_BY_FREIGHT_TERMS_FLAG;
79 l_param_info.GROUP_BY_INTMED_SHIP_TO_FLAG:= l_shipping_param_info.GROUP_BY_INTMED_SHIP_TO_FLAG;
80 l_param_info.GROUP_BY_SHIP_METHOD_FLAG := l_shipping_param_info.GROUP_BY_SHIP_METHOD_FLAG;
81 l_param_info.GROUP_BY_CARRIER_FLAG := l_shipping_param_info.GROUP_BY_CARRIER_FLAG;
82 l_param_info.ATTRIBUTE_CATEGORY := l_shipping_param_info.ATTRIBUTE_CATEGORY;
83 l_param_info.ATTRIBUTE1 := l_shipping_param_info.ATTRIBUTE1;
84 l_param_info.ATTRIBUTE2 := l_shipping_param_info.ATTRIBUTE2;
85 l_param_info.ATTRIBUTE3 := l_shipping_param_info.ATTRIBUTE3;
86 l_param_info.ATTRIBUTE4 := l_shipping_param_info.ATTRIBUTE4;
87 l_param_info.ATTRIBUTE5 := l_shipping_param_info.ATTRIBUTE5;
88 l_param_info.ATTRIBUTE6 := l_shipping_param_info.ATTRIBUTE6;
89 l_param_info.ATTRIBUTE7 := l_shipping_param_info.ATTRIBUTE7;
90 l_param_info.ATTRIBUTE8 := l_shipping_param_info.ATTRIBUTE8;
91 l_param_info.ATTRIBUTE9 := l_shipping_param_info.ATTRIBUTE9;
92 l_param_info.ATTRIBUTE10 := l_shipping_param_info.ATTRIBUTE10;
93 l_param_info.ATTRIBUTE11 := l_shipping_param_info.ATTRIBUTE11;
94 l_param_info.ATTRIBUTE12 := l_shipping_param_info.ATTRIBUTE12;
95 l_param_info.ATTRIBUTE13 := l_shipping_param_info.ATTRIBUTE13;
96 l_param_info.ATTRIBUTE14 := l_shipping_param_info.ATTRIBUTE14;
97 l_param_info.ATTRIBUTE15 := l_shipping_param_info.ATTRIBUTE15;
98 l_param_info.CREATION_DATE := l_shipping_param_info.CREATION_DATE;
99 l_param_info.CREATED_BY := l_shipping_param_info.CREATED_BY;
100 l_param_info.LAST_UPDATE_DATE := l_shipping_param_info.LAST_UPDATE_DATE;
101 l_param_info.LAST_UPDATED_BY := l_shipping_param_info.LAST_UPDATED_BY;
102 l_param_info.LAST_UPDATE_LOGIN := l_shipping_param_info.LAST_UPDATE_LOGIN;
103 l_param_info.PROGRAM_APPLICATION_ID := l_shipping_param_info.PROGRAM_APPLICATION_ID;
104 l_param_info.PROGRAM_ID := l_shipping_param_info.PROGRAM_ID;
105 l_param_info.PROGRAM_UPDATE_DATE := l_shipping_param_info.PROGRAM_UPDATE_DATE;
106 l_param_info.REQUEST_ID := l_shipping_param_info.REQUEST_ID;
107 l_param_info.PICK_SLIP_LINES := l_shipping_param_info.PICK_SLIP_LINES;
108 l_param_info.AUTOCREATE_DELIVERIES_FLAG:= l_shipping_param_info.AUTOCREATE_DELIVERIES_FLAG;
109 l_param_info.FREIGHT_CLASS_CAT_SET_ID := l_shipping_param_info.FREIGHT_CLASS_CAT_SET_ID;
110 l_param_info.COMMODITY_CODE_CAT_SET_ID := l_shipping_param_info.COMMODITY_CODE_CAT_SET_ID;
111 l_param_info.ENFORCE_SHIP_SET_AND_SMC := l_shipping_param_info.ENFORCE_SHIP_SET_AND_SMC;
112 l_param_info.AUTO_SEND_DOC_FLAG := l_shipping_param_info.AUTO_SEND_DOC_FLAG;
113 l_param_info.ITM_ADDITIONAL_COUNTRY_CODE:= l_shipping_param_info.ITM_ADDITIONAL_COUNTRY_CODE;
114 l_param_info.AUTO_SELECT_CARRIER := l_shipping_param_info.AUTO_SELECT_CARRIER;
115 l_param_info.GOODS_DISPATCHED_ACCOUNT := l_shipping_param_info.GOODS_DISPATCHED_ACCOUNT;
116 l_param_info.LOCATION_ID := l_shipping_param_info.LOCATION_ID;
117 l_param_info.ORGANIZATION_ID := l_shipping_param_info.ORGANIZATION_ID;
118 l_param_info.WEIGHT_UOM_CLASS := l_shipping_param_info.WEIGHT_UOM_CLASS;
119 l_param_info.VOLUME_UOM_CLASS := l_shipping_param_info.VOLUME_UOM_CLASS;
120 l_param_info.WEIGHT_VOLUME_FLAG := l_shipping_param_info.WEIGHT_VOLUME_FLAG;
121 l_param_info.INV_CONTROLS_CONTAINER_FLAG:= l_shipping_param_info.INV_CONTROLS_CONTAINER_FLAG;
122 l_param_info.PERCENT_FILL_BASIS_FLAG:= l_shipping_param_info.PERCENT_FILL_BASIS_FLAG;
123 l_param_info.TRIP_REPORT_SET_ID := l_shipping_param_info.TRIP_REPORT_SET_ID;
124 l_param_info.DELIVERY_REPORT_SET_ID := l_shipping_param_info.DELIVERY_REPORT_SET_ID;
125 l_param_info.AUTOCREATE_DEL_ORDERS_PR_FLAG:= l_shipping_param_info.AUTOCREATE_DEL_ORDERS_PR_FLAG;
126 l_param_info.FPA_POSITIVE_TOL_AMT := l_shipping_param_info.FPA_POSITIVE_TOL_AMT;
127 l_param_info.FPA_NEGATIVE_TOL_AMT := l_shipping_param_info.FPA_NEGATIVE_TOL_AMT;
128 l_param_info.FPA_POSITIVE_TOL_PERCENTAGE:= l_shipping_param_info.FPA_POSITIVE_TOL_PERCENTAGE;
129 l_param_info.FPA_NEGATIVE_TOL_PERCENTAGE:= l_shipping_param_info.FPA_NEGATIVE_TOL_PERCENTAGE;
130 l_param_info.FPA_DEFAULT_FREIGHT_ACCOUNT:= l_shipping_param_info.FPA_DEFAULT_FREIGHT_ACCOUNT;
131 l_param_info.AUTO_APPLY_ROUTING_RULES := l_shipping_param_info.AUTO_APPLY_ROUTING_RULES;
132 l_param_info.AUTO_CALC_FGT_RATE_CR_DEL := l_shipping_param_info.AUTO_CALC_FGT_RATE_CR_DEL;
133 l_param_info.AUTO_CALC_FGT_RATE_APPEND_DEL:= l_shipping_param_info.AUTO_CALC_FGT_RATE_APPEND_DEL;
134 l_param_info.AUTO_CALC_FGT_RATE_SC_DEL := l_shipping_param_info.AUTO_CALC_FGT_RATE_SC_DEL;
135 l_param_info.RAISE_BUSINESS_EVENTS := l_shipping_param_info.RAISE_BUSINESS_EVENTS;
136 l_param_info.ENABLE_TRACKING_WFS := l_shipping_param_info.ENABLE_TRACKING_WFS;
137 l_param_info.ENABLE_SC_WF := l_shipping_param_info.ENABLE_SC_WF;
138 l_param_info.PROCESS_FLAG := l_shipping_param_info.PROCESS_FLAG;
139 -- HW OPMCONV - Retrieve check_on_hand
140 l_param_info.CHECK_ON_HAND := l_shipping_param_info.CHECK_ON_HAND ;
141 -- Bugfix 7194517 added below 3 columns
142 l_param_info.MAX_NET_WEIGHT := l_shipping_param_info.MAX_NET_WEIGHT;
143 l_param_info.MAX_GROSS_WEIGHT := l_shipping_param_info.MAX_GROSS_WEIGHT;
144 l_param_info.OTM_ENABLED := l_shipping_param_info.OTM_ENABLED;
145 --Bug 7131800
146 l_param_info.retain_nonstaged_det_flag := l_shipping_param_info.retain_nonstaged_det_flag;
147 --Bug 7131800
148 x_return_status := l_return_status;
149 x_param_info := l_param_info;
150
151 -- Debug Statements
152 --
153 IF l_debug_on THEN
154 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.SHIP_CONFIRM_RULE_ID ',X_PARAM_INFO.SHIP_CONFIRM_RULE_ID);
155 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.AUTOPACK_LEVEL ',X_PARAM_INFO.AUTOPACK_LEVEL);
156 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.TASK_PLANNING_FLAG ',X_PARAM_INFO.TASK_PLANNING_FLAG);
157 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.EXPORT_SCREENING_FLAG ',X_PARAM_INFO.EXPORT_SCREENING_FLAG);
158 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.APPENDING_LIMIT ',X_PARAM_INFO.APPENDING_LIMIT);
159 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.IGNORE_INBOUND_TRIP ',X_PARAM_INFO.IGNORE_INBOUND_TRIP);
160 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.PACK_SLIP_REQUIRED_FLAG ',X_PARAM_INFO.PACK_SLIP_REQUIRED_FLAG);
161 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.PICK_SEQUENCE_RULE_ID ',X_PARAM_INFO.PICK_SEQUENCE_RULE_ID);
162 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.PICK_GROUPING_RULE_ID ',X_PARAM_INFO.PICK_GROUPING_RULE_ID);
163 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.PRINT_PICK_SLIP_MODE ',X_PARAM_INFO.PRINT_PICK_SLIP_MODE);
164 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.PICK_RELEASE_REPORT_SET_ID ',X_PARAM_INFO.PICK_RELEASE_REPORT_SET_ID);
165 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.AUTOCREATE_DEL_ORDERS_FLAG ',X_PARAM_INFO.AUTOCREATE_DEL_ORDERS_FLAG);
166 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.DEFAULT_STAGE_SUBINVENTORY ',X_PARAM_INFO.DEFAULT_STAGE_SUBINVENTORY);
167 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.DEFAULT_STAGE_LOCATOR_ID ',X_PARAM_INFO.DEFAULT_STAGE_LOCATOR_ID);
168 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.AUTODETAIL_PR_FLAG ',X_PARAM_INFO.AUTODETAIL_PR_FLAG);
169 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.ENFORCE_PACKING_FLAG ',X_PARAM_INFO.ENFORCE_PACKING_FLAG);
170 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.GROUP_BY_CUSTOMER_FLAG ',X_PARAM_INFO.GROUP_BY_CUSTOMER_FLAG);
171 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.GROUP_BY_FOB_FLAG ',X_PARAM_INFO.GROUP_BY_FOB_FLAG);
172 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.GROUP_BY_FREIGHT_TERMS_FLAG ',X_PARAM_INFO.GROUP_BY_FREIGHT_TERMS_FLAG);
173 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.GROUP_BY_INTMED_SHIP_TO_FLAG ',X_PARAM_INFO.GROUP_BY_INTMED_SHIP_TO_FLAG);
174 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.GROUP_BY_SHIP_METHOD_FLAG ',X_PARAM_INFO.GROUP_BY_SHIP_METHOD_FLAG);
175 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.GROUP_BY_CARRIER_FLAG ',X_PARAM_INFO.GROUP_BY_CARRIER_FLAG);
176 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.ATTRIBUTE_CATEGORY ',X_PARAM_INFO.ATTRIBUTE_CATEGORY);
177 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.ATTRIBUTE1 ',X_PARAM_INFO.ATTRIBUTE1);
178 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.ATTRIBUTE2 ',X_PARAM_INFO.ATTRIBUTE2);
179 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.ATTRIBUTE3 ',X_PARAM_INFO.ATTRIBUTE3);
180 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.ATTRIBUTE4 ',X_PARAM_INFO.ATTRIBUTE4);
181 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.ATTRIBUTE5 ',X_PARAM_INFO.ATTRIBUTE5);
182 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.ATTRIBUTE6 ',X_PARAM_INFO.ATTRIBUTE6);
183 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.ATTRIBUTE7 ',X_PARAM_INFO.ATTRIBUTE7);
184 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.ATTRIBUTE8 ',X_PARAM_INFO.ATTRIBUTE8);
185 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.ATTRIBUTE9 ',X_PARAM_INFO.ATTRIBUTE9);
186 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.ATTRIBUTE10 ',X_PARAM_INFO.ATTRIBUTE10);
187 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.ATTRIBUTE11 ',X_PARAM_INFO.ATTRIBUTE11);
188 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.ATTRIBUTE12 ',X_PARAM_INFO.ATTRIBUTE12);
189 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.ATTRIBUTE13 ',X_PARAM_INFO.ATTRIBUTE13);
190 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.ATTRIBUTE14 ',X_PARAM_INFO.ATTRIBUTE14);
191 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.ATTRIBUTE15 ',X_PARAM_INFO.ATTRIBUTE15);
192 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.CREATION_DATE ',X_PARAM_INFO.CREATION_DATE);
193 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.CREATED_BY ',X_PARAM_INFO.CREATED_BY);
194 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.LAST_UPDATE_DATE ',X_PARAM_INFO.LAST_UPDATE_DATE);
195 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.LAST_UPDATED_BY ',X_PARAM_INFO.LAST_UPDATED_BY);
196 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.LAST_UPDATE_LOGIN ',X_PARAM_INFO.LAST_UPDATE_LOGIN);
197 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.PROGRAM_APPLICATION_ID ',X_PARAM_INFO.PROGRAM_APPLICATION_ID);
198 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.PROGRAM_ID ',X_PARAM_INFO.PROGRAM_ID);
199 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.PROGRAM_UPDATE_DATE ',X_PARAM_INFO.PROGRAM_UPDATE_DATE);
200 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.REQUEST_ID ',X_PARAM_INFO.REQUEST_ID);
201 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.PICK_SLIP_LINES ',X_PARAM_INFO.PICK_SLIP_LINES);
202 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.AUTOCREATE_DELIVERIES_FLAG ',X_PARAM_INFO.AUTOCREATE_DELIVERIES_FLAG);
203 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.FREIGHT_CLASS_CAT_SET_ID ',X_PARAM_INFO.FREIGHT_CLASS_CAT_SET_ID);
204 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.COMMODITY_CODE_CAT_SET_ID ',X_PARAM_INFO.COMMODITY_CODE_CAT_SET_ID);
205 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.ENFORCE_SHIP_SET_AND_SMC ',X_PARAM_INFO.ENFORCE_SHIP_SET_AND_SMC);
206 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.AUTO_SEND_DOC_FLAG ',X_PARAM_INFO.AUTO_SEND_DOC_FLAG);
207 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.ITM_ADDITIONAL_COUNTRY_CODE ',X_PARAM_INFO.ITM_ADDITIONAL_COUNTRY_CODE);
208 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.AUTO_SELECT_CARRIER ',X_PARAM_INFO.AUTO_SELECT_CARRIER);
209 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.GOODS_DISPATCHED_ACCOUNT ',X_PARAM_INFO.GOODS_DISPATCHED_ACCOUNT);
210 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.LOCATION_ID ',X_PARAM_INFO.LOCATION_ID);
211 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.ORGANIZATION_ID ',X_PARAM_INFO.ORGANIZATION_ID);
212 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.WEIGHT_UOM_CLASS ',X_PARAM_INFO.WEIGHT_UOM_CLASS);
213 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.VOLUME_UOM_CLASS ',X_PARAM_INFO.VOLUME_UOM_CLASS);
214 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.WEIGHT_VOLUME_FLAG ',X_PARAM_INFO.WEIGHT_VOLUME_FLAG);
215 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.INV_CONTROLS_CONTAINER_FLAG ',X_PARAM_INFO.INV_CONTROLS_CONTAINER_FLAG);
216 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.PERCENT_FILL_BASIS_FLAG ',X_PARAM_INFO.PERCENT_FILL_BASIS_FLAG);
217 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.TRIP_REPORT_SET_ID ',X_PARAM_INFO.TRIP_REPORT_SET_ID);
218 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.DELIVERY_REPORT_SET_ID ',X_PARAM_INFO.DELIVERY_REPORT_SET_ID);
219 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.AUTOCREATE_DEL_ORDERS_PR_FLAG ',X_PARAM_INFO.AUTOCREATE_DEL_ORDERS_PR_FLAG);
220 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.FPA_POSITIVE_TOL_AMT ',X_PARAM_INFO.FPA_POSITIVE_TOL_AMT);
221 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.FPA_NEGATIVE_TOL_AMT ',X_PARAM_INFO.FPA_NEGATIVE_TOL_AMT);
222 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.FPA_POSITIVE_TOL_PERCENTAGE ',X_PARAM_INFO.FPA_POSITIVE_TOL_PERCENTAGE);
223 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.FPA_NEGATIVE_TOL_PERCENTAGE ',X_PARAM_INFO.FPA_NEGATIVE_TOL_PERCENTAGE);
224 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.FPA_DEFAULT_FREIGHT_ACCOUNT ',X_PARAM_INFO.FPA_DEFAULT_FREIGHT_ACCOUNT);
225 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.AUTO_APPLY_ROUTING_RULES ',X_PARAM_INFO.AUTO_APPLY_ROUTING_RULES);
226 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.AUTO_CALC_FGT_RATE_CR_DEL ',X_PARAM_INFO.AUTO_CALC_FGT_RATE_CR_DEL);
227 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.AUTO_CALC_FGT_RATE_APPEND_DEL ',X_PARAM_INFO.AUTO_CALC_FGT_RATE_APPEND_DEL);
228 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.AUTO_CALC_FGT_RATE_SC_DEL ',X_PARAM_INFO.AUTO_CALC_FGT_RATE_SC_DEL);
229 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.RAISE_BUSINESS_EVENTS',X_PARAM_INFO.RAISE_BUSINESS_EVENTS);
230 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.ENABLE_TRACKING_WFS',X_PARAM_INFO.ENABLE_TRACKING_WFS);
231 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.ENABLE_SC_WF',X_PARAM_INFO.ENABLE_SC_WF);
232 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.PROCESS_FLAG ',X_PARAM_INFO.PROCESS_FLAG);
233 -- HW OPMCONV - Print the value of check_on_hand
237 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.MAX_GROSS_WEIGHT ',X_PARAM_INFO.MAX_GROSS_WEIGHT);
234 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.CHECK_ON_HAND ',X_PARAM_INFO.CHECK_ON_HAND);
235 -- Bugfix 7194517 Start
236 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.MAX_NET_WEIGHT ',X_PARAM_INFO.MAX_NET_WEIGHT);
238 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.OTM_ENABLED',X_PARAM_INFO.OTM_ENABLED);
239 -- Bugfix 7194517 End
240 --Bug 7131800
241 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.RETAIN_NONSTAGED_DET_FLAG ',X_PARAM_INFO.RETAIN_NONSTAGED_DET_FLAG);
242 --Bug 7131800
243
244 END IF;
245 --
246 -- Debug Statements
247 --
248 IF l_debug_on THEN
249 WSH_DEBUG_SV.pop(l_module_name);
250 END IF;
251 --
252 END Get_Shipping_Parameters;
253
254 --
255 -- Procedure: Get_Global_Parameters
256 -- Parameters: x_global_param_info - Record of all Global parameters
257 -- x_return_status - return status of the API
258
259 PROCEDURE Get_Global_Parameters
260 (x_global_param_info OUT NOCOPY Global_Params_Rec,
261 x_return_status OUT NOCOPY VARCHAR2) IS
262
263 --
264 --Variable Declaration.
265 --
266 l_global_param_info WSH_SHIPPING_PARAMS_PVT.Global_Parameters_Rec_Typ;
267 l_param_info Global_Params_Rec;
268 l_return_status VARCHAR2(1);
269 --
270 l_debug_on BOOLEAN;
271 --
272 l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'GET_GLOBAL_PARAMETERS';
273 --
274 BEGIN
275
276 --
277 --
278 l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
279 --
280 IF l_debug_on IS NULL
281 THEN
282 l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
283 END IF;
284 --
285 IF l_debug_on THEN
286 WSH_DEBUG_SV.push(l_module_name);
287 END IF;
288 --
289 x_return_status := FND_API.G_RET_STS_SUCCESS;
290
291 -- Fetch Global Parameters using WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters
292
293 WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters( x_param_info => l_global_param_info,
294 x_return_status =>l_return_status);
295
296 l_param_info.AUTO_RATE_TP_REL_TRIPS := l_global_param_info.AUTO_RATE_TP_REL_TRIPS;
297 l_param_info.TL_PRIN_COST_ALLOC_BASIS := l_global_param_info.TL_PRIN_COST_ALLOC_BASIS;
298 l_param_info.TL_DISTANCE_ALLOC_BASIS := l_global_param_info.TL_DISTANCE_ALLOC_BASIS;
299 l_param_info.TL_STOP_COST_ALLOC_BASIS := l_global_param_info.TL_STOP_COST_ALLOC_BASIS;
300 l_param_info.AUTOFIRM_LOAD_TENDERED_TRIPS:= l_global_param_info.AUTOFIRM_LOAD_TENDERED_TRIPS;
301 l_param_info.CONSOLIDATE_BO_LINES := l_global_param_info.CONSOLIDATE_BO_LINES;
302 l_param_info.GU_WEIGHT_CLASS := l_global_param_info.GU_WEIGHT_CLASS;
303 l_param_info.GU_WEIGHT_UOM := l_global_param_info.GU_WEIGHT_UOM;
304 l_param_info.GU_VOLUME_UOM := l_global_param_info.GU_VOLUME_UOM;
305 l_param_info.GU_VOLUME_CLASS := l_global_param_info.GU_VOLUME_CLASS;
306 l_param_info.GU_DISTANCE_CLASS := l_global_param_info.GU_DISTANCE_CLASS;
307 l_param_info.GU_DISTANCE_UOM := l_global_param_info.GU_DISTANCE_UOM;
308 l_param_info.GU_DIMENSION_CLASS := l_global_param_info.GU_DIMENSION_CLASS;
309 l_param_info.GU_DIMENSION_UOM := l_global_param_info.GU_DIMENSION_UOM;
310 l_param_info.GU_CURRENCY_COUNTRY := l_global_param_info.GU_CURRENCY_COUNTRY;
311 l_param_info.GU_CURRENCY_UOM := l_global_param_info.GU_CURRENCY_UOM;
312 l_param_info.GU_TIME_CLASS := l_global_param_info.GU_TIME_CLASS;
313 l_param_info.GU_TIME_UOM := l_global_param_info.GU_TIME_UOM;
314 l_param_info.DEF_MILE_CALC_ON_CUST_FAC := l_global_param_info.DEF_MILE_CALC_ON_CUST_FAC;
315 l_param_info.DEF_MILE_CALC_ON_SUPP_FAC := l_global_param_info.DEF_MILE_CALC_ON_SUPP_FAC;
316 l_param_info.DEF_MILE_CALC_ON_ORG_FAC := l_global_param_info.DEF_MILE_CALC_ON_ORG_FAC;
317 l_param_info.DEF_MILE_CALC_ON_CARR_FAC := l_global_param_info.DEF_MILE_CALC_ON_CARR_FAC;
318 l_param_info.TL_HWAY_DIS_EMP_CONSTANT := l_global_param_info.TL_HWAY_DIS_EMP_CONSTANT;
319 l_param_info.AVG_HWAY_SPEED := l_global_param_info.AVG_HWAY_SPEED;
320 l_param_info.DISTANCE_UOM := l_global_param_info.DISTANCE_UOM;
321 l_param_info.TIME_UOM := l_global_param_info.TIME_UOM;
322 l_param_info.UOM_FOR_NUM_OF_UNITS := l_global_param_info.UOM_FOR_NUM_OF_UNITS;
323 l_param_info.PALLET_ITEM_TYPE := l_global_param_info.PALLET_ITEM_TYPE;
324 l_param_info.ATTRIBUTE_CATEGORY := l_global_param_info.ATTRIBUTE_CATEGORY;
325 l_param_info.ATTRIBUTE1 := l_global_param_info.ATTRIBUTE1;
326 l_param_info.ATTRIBUTE2 := l_global_param_info.ATTRIBUTE2;
327 l_param_info.ATTRIBUTE3 := l_global_param_info.ATTRIBUTE3;
328 l_param_info.ATTRIBUTE4 := l_global_param_info.ATTRIBUTE4;
329 l_param_info.ATTRIBUTE5 := l_global_param_info.ATTRIBUTE5;
330 l_param_info.ATTRIBUTE6 := l_global_param_info.ATTRIBUTE6;
331 l_param_info.ATTRIBUTE7 := l_global_param_info.ATTRIBUTE7;
332 l_param_info.ATTRIBUTE8 := l_global_param_info.ATTRIBUTE8;
333 l_param_info.ATTRIBUTE9 := l_global_param_info.ATTRIBUTE9;
334 l_param_info.ATTRIBUTE10 := l_global_param_info.ATTRIBUTE10;
335 l_param_info.ATTRIBUTE11 := l_global_param_info.ATTRIBUTE11;
336 l_param_info.ATTRIBUTE12 := l_global_param_info.ATTRIBUTE12;
337 l_param_info.ATTRIBUTE13 := l_global_param_info.ATTRIBUTE13;
338 l_param_info.ATTRIBUTE14 := l_global_param_info.ATTRIBUTE14;
339 l_param_info.ATTRIBUTE15 := l_global_param_info.ATTRIBUTE15;
340 l_param_info.CREATION_DATE := l_global_param_info.CREATION_DATE;
341 l_param_info.CREATED_BY := l_global_param_info.CREATED_BY;
342 l_param_info.LAST_UPDATE_DATE := l_global_param_info.LAST_UPDATE_DATE;
343 l_param_info.LAST_UPDATED_BY := l_global_param_info.LAST_UPDATED_BY;
347 l_param_info.ALLOW_FUTURE_SHIP_DATE := l_global_param_info.ALLOW_FUTURE_SHIP_DATE;
344 l_param_info.LAST_UPDATE_LOGIN := l_global_param_info.LAST_UPDATE_LOGIN;
345 l_param_info.DEFER_INTERFACE := l_global_param_info.DEFER_INTERFACE;
346 l_param_info.ENFORCE_SHIP_METHOD := l_global_param_info.ENFORCE_SHIP_METHOD;
348 l_param_info.RATE_IB_DELS_FGT_TERM := l_global_param_info.RATE_IB_DELS_FGT_TERM;
349 l_param_info.SKIP_RATE_OB_DELS_FGT_TERM:= l_global_param_info.SKIP_RATE_OB_DELS_FGT_TERM;
350 l_param_info.DEL_DATE_CALC_METHOD := l_global_param_info.DEL_DATE_CALC_METHOD;
351 l_param_info.RATE_DS_DELS_FGT_TERM_ID := l_global_param_info.RATE_DS_DELS_FGT_TERM_ID;
352 l_param_info.RAISE_BUSINESS_EVENTS := l_global_param_info.RAISE_BUSINESS_EVENTS;
353 l_param_info.ENABLE_TRACKING_WFS := l_global_param_info.ENABLE_TRACKING_WFS;
354 l_param_info.ENABLE_SC_WF := l_global_param_info.ENABLE_SC_WF;
355 --bug 7491598 DEFER OTM-PLANNED SHIPMENT INTERFACES ENHANCEMENT
356 l_param_info.DEFER_PLAN_SHIPMENT_INTERFACE := l_global_param_info.DEFER_PLAN_SHIPMENT_INTERFACE;
357
358 x_return_status := l_return_status;
359 x_global_param_info := l_param_info;
360
361 IF l_debug_on THEN
362 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.AUTO_RATE_TP_REL_TRIPS ',X_GLOBAL_PARAM_INFO.AUTO_RATE_TP_REL_TRIPS);
363 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.TL_PRIN_COST_ALLOC_BASIS ',X_GLOBAL_PARAM_INFO.TL_PRIN_COST_ALLOC_BASIS);
364 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.TL_DISTANCE_ALLOC_BASIS ',X_GLOBAL_PARAM_INFO.TL_DISTANCE_ALLOC_BASIS);
365 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.TL_STOP_COST_ALLOC_BASIS ',X_GLOBAL_PARAM_INFO.TL_STOP_COST_ALLOC_BASIS);
366 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.AUTOFIRM_LOAD_TENDERED_TRIPS ',X_GLOBAL_PARAM_INFO.AUTOFIRM_LOAD_TENDERED_TRIPS);
367 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.CONSOLIDATE_BO_LINES ',X_GLOBAL_PARAM_INFO.CONSOLIDATE_BO_LINES);
368 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.GU_WEIGHT_CLASS ',X_GLOBAL_PARAM_INFO.GU_WEIGHT_CLASS);
369 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.GU_WEIGHT_UOM ',X_GLOBAL_PARAM_INFO.GU_WEIGHT_UOM);
370 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.GU_VOLUME_UOM ',X_GLOBAL_PARAM_INFO.GU_VOLUME_UOM);
371 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.GU_VOLUME_CLASS ',X_GLOBAL_PARAM_INFO.GU_VOLUME_CLASS);
372 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.GU_DISTANCE_CLASS ',X_GLOBAL_PARAM_INFO.GU_DISTANCE_CLASS);
373 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.GU_DISTANCE_UOM ',X_GLOBAL_PARAM_INFO.GU_DISTANCE_UOM);
374 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.GU_DIMENSION_CLASS ',X_GLOBAL_PARAM_INFO.GU_DIMENSION_CLASS);
375 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.GU_DIMENSION_UOM ',X_GLOBAL_PARAM_INFO.GU_DIMENSION_UOM);
376 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.GU_CURRENCY_COUNTRY ',X_GLOBAL_PARAM_INFO.GU_CURRENCY_COUNTRY);
377 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.GU_CURRENCY_UOM ',X_GLOBAL_PARAM_INFO.GU_CURRENCY_UOM);
378 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.GU_TIME_CLASS ',X_GLOBAL_PARAM_INFO.GU_TIME_CLASS);
379 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.GU_TIME_UOM ',X_GLOBAL_PARAM_INFO.GU_TIME_UOM);
380 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.DEF_MILE_CALC_ON_CUST_FAC ',X_GLOBAL_PARAM_INFO.DEF_MILE_CALC_ON_CUST_FAC);
381 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.DEF_MILE_CALC_ON_SUPP_FAC ',X_GLOBAL_PARAM_INFO.DEF_MILE_CALC_ON_SUPP_FAC);
382 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.DEF_MILE_CALC_ON_ORG_FAC ',X_GLOBAL_PARAM_INFO.DEF_MILE_CALC_ON_ORG_FAC);
383 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.DEF_MILE_CALC_ON_CARR_FAC ',X_GLOBAL_PARAM_INFO.DEF_MILE_CALC_ON_CARR_FAC);
384 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.TL_HWAY_DIS_EMP_CONSTANT ',X_GLOBAL_PARAM_INFO.TL_HWAY_DIS_EMP_CONSTANT);
385 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.AVG_HWAY_SPEED ',X_GLOBAL_PARAM_INFO.AVG_HWAY_SPEED);
386 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.DISTANCE_UOM ',X_GLOBAL_PARAM_INFO.DISTANCE_UOM);
387 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.TIME_UOM ',X_GLOBAL_PARAM_INFO.TIME_UOM);
388 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.UOM_FOR_NUM_OF_UNITS ',X_GLOBAL_PARAM_INFO.UOM_FOR_NUM_OF_UNITS);
389 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.PALLET_ITEM_TYPE ',X_GLOBAL_PARAM_INFO.PALLET_ITEM_TYPE);
390 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.ATTRIBUTE_CATEGORY ',X_GLOBAL_PARAM_INFO.ATTRIBUTE_CATEGORY);
391 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.ATTRIBUTE1 ',X_GLOBAL_PARAM_INFO.ATTRIBUTE1);
392 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.ATTRIBUTE2 ',X_GLOBAL_PARAM_INFO.ATTRIBUTE2);
393 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.ATTRIBUTE3 ',X_GLOBAL_PARAM_INFO.ATTRIBUTE3);
394 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.ATTRIBUTE4 ',X_GLOBAL_PARAM_INFO.ATTRIBUTE4);
395 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.ATTRIBUTE5 ',X_GLOBAL_PARAM_INFO.ATTRIBUTE5);
396 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.ATTRIBUTE6 ',X_GLOBAL_PARAM_INFO.ATTRIBUTE6);
397 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.ATTRIBUTE7 ',X_GLOBAL_PARAM_INFO.ATTRIBUTE7);
398 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.ATTRIBUTE8 ',X_GLOBAL_PARAM_INFO.ATTRIBUTE8);
399 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.ATTRIBUTE9 ',X_GLOBAL_PARAM_INFO.ATTRIBUTE9);
400 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.ATTRIBUTE10 ',X_GLOBAL_PARAM_INFO.ATTRIBUTE10);
401 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.ATTRIBUTE11 ',X_GLOBAL_PARAM_INFO.ATTRIBUTE11);
402 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.ATTRIBUTE12 ',X_GLOBAL_PARAM_INFO.ATTRIBUTE12);
403 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.ATTRIBUTE13 ',X_GLOBAL_PARAM_INFO.ATTRIBUTE13);
404 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.ATTRIBUTE14 ',X_GLOBAL_PARAM_INFO.ATTRIBUTE14);
405 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.ATTRIBUTE15 ',X_GLOBAL_PARAM_INFO.ATTRIBUTE15);
406 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.CREATION_DATE ',X_GLOBAL_PARAM_INFO.CREATION_DATE);
407 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.CREATED_BY ',X_GLOBAL_PARAM_INFO.CREATED_BY);
408 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.LAST_UPDATE_DATE ',X_GLOBAL_PARAM_INFO.LAST_UPDATE_DATE);
409 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.LAST_UPDATED_BY ',X_GLOBAL_PARAM_INFO.LAST_UPDATED_BY);
410 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.LAST_UPDATE_LOGIN ',X_GLOBAL_PARAM_INFO.LAST_UPDATE_LOGIN);
411 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.ENFORCE_SHIP_METHOD ',X_GLOBAL_PARAM_INFO.ENFORCE_SHIP_METHOD);
412 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.ALLOW_FUTURE_SHIP_DATE ',X_GLOBAL_PARAM_INFO.ALLOW_FUTURE_SHIP_DATE);
413 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.DEFER_INTERFACE ',X_GLOBAL_PARAM_INFO.DEFER_INTERFACE);
414 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.RATE_IB_DELS_FGT_TERM ',X_GLOBAL_PARAM_INFO.RATE_IB_DELS_FGT_TERM);
415 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.SKIP_RATE_OB_DELS_FGT_TERM ',X_GLOBAL_PARAM_INFO.SKIP_RATE_OB_DELS_FGT_TERM);
416 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.DEL_DATE_CALC_METHOD ',X_GLOBAL_PARAM_INFO.DEL_DATE_CALC_METHOD);
417 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.RATE_DS_DELS_FGT_TERM_ID ',X_GLOBAL_PARAM_INFO.RATE_DS_DELS_FGT_TERM_ID);
418 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.RAISE_BUSINESS_EVENTS',X_GLOBAL_PARAM_INFO.RAISE_BUSINESS_EVENTS);
419 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.ENABLE_TRACKING_WFS',X_GLOBAL_PARAM_INFO.ENABLE_TRACKING_WFS);
420 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.ENABLE_SC_WF',X_GLOBAL_PARAM_INFO.ENABLE_SC_WF);
421 --bug 7491598 DEFER OTM-PLANNED SHIPMENT INTERFACES ENHANCEMENT
422 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.DEFER_PLAN_SHIPMENT_INTERFACE',X_GLOBAL_PARAM_INFO.DEFER_PLAN_SHIPMENT_INTERFACE);
423
424 END IF;
425
426 --
427 -- Debug Statements
428 --
429 IF l_debug_on THEN
430 WSH_DEBUG_SV.pop(l_module_name);
431 END IF;
432 --
433
434 END Get_Global_Parameters;
435
436 END WSH_SHIPPING_PARAMS_GRP;