[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.5 2009/06/12 10:57:37 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 -- Bug 8446283 (Added wt/vol UOM codes on shipping parameters forms)
149 l_param_info.weight_uom_code := l_shipping_param_info.weight_uom_code;
150 l_param_info.volume_uom_code := l_shipping_param_info.volume_uom_code;
151 -- Bug 8446283 : end
152 x_return_status := l_return_status;
153 x_param_info := l_param_info;
154
155 -- Debug Statements
156 --
157 IF l_debug_on THEN
158 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.SHIP_CONFIRM_RULE_ID ',X_PARAM_INFO.SHIP_CONFIRM_RULE_ID);
159 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.AUTOPACK_LEVEL ',X_PARAM_INFO.AUTOPACK_LEVEL);
160 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.TASK_PLANNING_FLAG ',X_PARAM_INFO.TASK_PLANNING_FLAG);
161 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.EXPORT_SCREENING_FLAG ',X_PARAM_INFO.EXPORT_SCREENING_FLAG);
162 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.APPENDING_LIMIT ',X_PARAM_INFO.APPENDING_LIMIT);
163 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.IGNORE_INBOUND_TRIP ',X_PARAM_INFO.IGNORE_INBOUND_TRIP);
164 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.PACK_SLIP_REQUIRED_FLAG ',X_PARAM_INFO.PACK_SLIP_REQUIRED_FLAG);
165 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.PICK_SEQUENCE_RULE_ID ',X_PARAM_INFO.PICK_SEQUENCE_RULE_ID);
166 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.PICK_GROUPING_RULE_ID ',X_PARAM_INFO.PICK_GROUPING_RULE_ID);
167 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.PRINT_PICK_SLIP_MODE ',X_PARAM_INFO.PRINT_PICK_SLIP_MODE);
168 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.PICK_RELEASE_REPORT_SET_ID ',X_PARAM_INFO.PICK_RELEASE_REPORT_SET_ID);
169 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.AUTOCREATE_DEL_ORDERS_FLAG ',X_PARAM_INFO.AUTOCREATE_DEL_ORDERS_FLAG);
170 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.DEFAULT_STAGE_SUBINVENTORY ',X_PARAM_INFO.DEFAULT_STAGE_SUBINVENTORY);
171 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.DEFAULT_STAGE_LOCATOR_ID ',X_PARAM_INFO.DEFAULT_STAGE_LOCATOR_ID);
172 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.AUTODETAIL_PR_FLAG ',X_PARAM_INFO.AUTODETAIL_PR_FLAG);
173 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.ENFORCE_PACKING_FLAG ',X_PARAM_INFO.ENFORCE_PACKING_FLAG);
174 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.GROUP_BY_CUSTOMER_FLAG ',X_PARAM_INFO.GROUP_BY_CUSTOMER_FLAG);
175 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.GROUP_BY_FOB_FLAG ',X_PARAM_INFO.GROUP_BY_FOB_FLAG);
176 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.GROUP_BY_FREIGHT_TERMS_FLAG ',X_PARAM_INFO.GROUP_BY_FREIGHT_TERMS_FLAG);
177 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);
178 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.GROUP_BY_SHIP_METHOD_FLAG ',X_PARAM_INFO.GROUP_BY_SHIP_METHOD_FLAG);
179 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.GROUP_BY_CARRIER_FLAG ',X_PARAM_INFO.GROUP_BY_CARRIER_FLAG);
180 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.ATTRIBUTE_CATEGORY ',X_PARAM_INFO.ATTRIBUTE_CATEGORY);
181 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.ATTRIBUTE1 ',X_PARAM_INFO.ATTRIBUTE1);
182 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.ATTRIBUTE2 ',X_PARAM_INFO.ATTRIBUTE2);
183 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.ATTRIBUTE3 ',X_PARAM_INFO.ATTRIBUTE3);
184 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.ATTRIBUTE4 ',X_PARAM_INFO.ATTRIBUTE4);
185 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.ATTRIBUTE5 ',X_PARAM_INFO.ATTRIBUTE5);
186 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.ATTRIBUTE6 ',X_PARAM_INFO.ATTRIBUTE6);
187 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.ATTRIBUTE7 ',X_PARAM_INFO.ATTRIBUTE7);
188 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.ATTRIBUTE8 ',X_PARAM_INFO.ATTRIBUTE8);
189 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.ATTRIBUTE9 ',X_PARAM_INFO.ATTRIBUTE9);
190 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.ATTRIBUTE10 ',X_PARAM_INFO.ATTRIBUTE10);
191 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.ATTRIBUTE11 ',X_PARAM_INFO.ATTRIBUTE11);
192 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.ATTRIBUTE12 ',X_PARAM_INFO.ATTRIBUTE12);
193 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.ATTRIBUTE13 ',X_PARAM_INFO.ATTRIBUTE13);
194 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.ATTRIBUTE14 ',X_PARAM_INFO.ATTRIBUTE14);
195 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.ATTRIBUTE15 ',X_PARAM_INFO.ATTRIBUTE15);
196 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.CREATION_DATE ',X_PARAM_INFO.CREATION_DATE);
197 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.CREATED_BY ',X_PARAM_INFO.CREATED_BY);
198 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.LAST_UPDATE_DATE ',X_PARAM_INFO.LAST_UPDATE_DATE);
199 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.LAST_UPDATED_BY ',X_PARAM_INFO.LAST_UPDATED_BY);
200 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.LAST_UPDATE_LOGIN ',X_PARAM_INFO.LAST_UPDATE_LOGIN);
201 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.PROGRAM_APPLICATION_ID ',X_PARAM_INFO.PROGRAM_APPLICATION_ID);
202 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.PROGRAM_ID ',X_PARAM_INFO.PROGRAM_ID);
203 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.PROGRAM_UPDATE_DATE ',X_PARAM_INFO.PROGRAM_UPDATE_DATE);
204 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.REQUEST_ID ',X_PARAM_INFO.REQUEST_ID);
205 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.PICK_SLIP_LINES ',X_PARAM_INFO.PICK_SLIP_LINES);
206 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.AUTOCREATE_DELIVERIES_FLAG ',X_PARAM_INFO.AUTOCREATE_DELIVERIES_FLAG);
207 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.FREIGHT_CLASS_CAT_SET_ID ',X_PARAM_INFO.FREIGHT_CLASS_CAT_SET_ID);
208 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.COMMODITY_CODE_CAT_SET_ID ',X_PARAM_INFO.COMMODITY_CODE_CAT_SET_ID);
209 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.ENFORCE_SHIP_SET_AND_SMC ',X_PARAM_INFO.ENFORCE_SHIP_SET_AND_SMC);
210 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.AUTO_SEND_DOC_FLAG ',X_PARAM_INFO.AUTO_SEND_DOC_FLAG);
211 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.ITM_ADDITIONAL_COUNTRY_CODE ',X_PARAM_INFO.ITM_ADDITIONAL_COUNTRY_CODE);
212 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.AUTO_SELECT_CARRIER ',X_PARAM_INFO.AUTO_SELECT_CARRIER);
213 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.GOODS_DISPATCHED_ACCOUNT ',X_PARAM_INFO.GOODS_DISPATCHED_ACCOUNT);
214 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.LOCATION_ID ',X_PARAM_INFO.LOCATION_ID);
215 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.ORGANIZATION_ID ',X_PARAM_INFO.ORGANIZATION_ID);
216 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.WEIGHT_UOM_CLASS ',X_PARAM_INFO.WEIGHT_UOM_CLASS);
217 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.VOLUME_UOM_CLASS ',X_PARAM_INFO.VOLUME_UOM_CLASS);
218 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.WEIGHT_VOLUME_FLAG ',X_PARAM_INFO.WEIGHT_VOLUME_FLAG);
219 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.INV_CONTROLS_CONTAINER_FLAG ',X_PARAM_INFO.INV_CONTROLS_CONTAINER_FLAG);
220 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.PERCENT_FILL_BASIS_FLAG ',X_PARAM_INFO.PERCENT_FILL_BASIS_FLAG);
221 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.TRIP_REPORT_SET_ID ',X_PARAM_INFO.TRIP_REPORT_SET_ID);
222 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.DELIVERY_REPORT_SET_ID ',X_PARAM_INFO.DELIVERY_REPORT_SET_ID);
223 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.AUTOCREATE_DEL_ORDERS_PR_FLAG ',X_PARAM_INFO.AUTOCREATE_DEL_ORDERS_PR_FLAG);
224 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.FPA_POSITIVE_TOL_AMT ',X_PARAM_INFO.FPA_POSITIVE_TOL_AMT);
225 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.FPA_NEGATIVE_TOL_AMT ',X_PARAM_INFO.FPA_NEGATIVE_TOL_AMT);
226 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.FPA_POSITIVE_TOL_PERCENTAGE ',X_PARAM_INFO.FPA_POSITIVE_TOL_PERCENTAGE);
227 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.FPA_NEGATIVE_TOL_PERCENTAGE ',X_PARAM_INFO.FPA_NEGATIVE_TOL_PERCENTAGE);
228 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.FPA_DEFAULT_FREIGHT_ACCOUNT ',X_PARAM_INFO.FPA_DEFAULT_FREIGHT_ACCOUNT);
229 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.AUTO_APPLY_ROUTING_RULES ',X_PARAM_INFO.AUTO_APPLY_ROUTING_RULES);
230 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);
231 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);
232 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);
233 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.RAISE_BUSINESS_EVENTS',X_PARAM_INFO.RAISE_BUSINESS_EVENTS);
234 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.ENABLE_TRACKING_WFS',X_PARAM_INFO.ENABLE_TRACKING_WFS);
235 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.ENABLE_SC_WF',X_PARAM_INFO.ENABLE_SC_WF);
236 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.PROCESS_FLAG ',X_PARAM_INFO.PROCESS_FLAG);
237 -- HW OPMCONV - Print the value of check_on_hand
238 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.CHECK_ON_HAND ',X_PARAM_INFO.CHECK_ON_HAND);
239 -- Bugfix 7194517 Start
240 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.MAX_NET_WEIGHT ',X_PARAM_INFO.MAX_NET_WEIGHT);
241 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.MAX_GROSS_WEIGHT ',X_PARAM_INFO.MAX_GROSS_WEIGHT);
242 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.OTM_ENABLED',X_PARAM_INFO.OTM_ENABLED);
243 -- Bugfix 7194517 End
244 --Bug 7131800
245 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.RETAIN_NONSTAGED_DET_FLAG ',X_PARAM_INFO.RETAIN_NONSTAGED_DET_FLAG);
246 --Bug 7131800
247 -- Bug 8446283 begin
248 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.WEIGHT_UOM_CODE ',X_PARAM_INFO.WEIGHT_UOM_CODE);
249 WSH_DEBUG_SV.log(l_module_name,'X_PARAM_INFO.VOLUME_UOM_CODE ',X_PARAM_INFO.VOLUME_UOM_CODE);
250 -- Bug 8446283 end
251
252 END IF;
253 --
254 -- Debug Statements
255 --
256 IF l_debug_on THEN
257 WSH_DEBUG_SV.pop(l_module_name);
258 END IF;
259 --
260 END Get_Shipping_Parameters;
261
262 --
263 -- Procedure: Get_Global_Parameters
264 -- Parameters: x_global_param_info - Record of all Global parameters
265 -- x_return_status - return status of the API
266
267 PROCEDURE Get_Global_Parameters
268 (x_global_param_info OUT NOCOPY Global_Params_Rec,
269 x_return_status OUT NOCOPY VARCHAR2) IS
270
271 --
272 --Variable Declaration.
273 --
274 l_global_param_info WSH_SHIPPING_PARAMS_PVT.Global_Parameters_Rec_Typ;
275 l_param_info Global_Params_Rec;
276 l_return_status VARCHAR2(1);
277 --
278 l_debug_on BOOLEAN;
279 --
280 l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'GET_GLOBAL_PARAMETERS';
281 --
282 BEGIN
283
284 --
285 --
286 l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
287 --
288 IF l_debug_on IS NULL
289 THEN
290 l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
291 END IF;
292 --
293 IF l_debug_on THEN
294 WSH_DEBUG_SV.push(l_module_name);
295 END IF;
296 --
297 x_return_status := FND_API.G_RET_STS_SUCCESS;
298
299 -- Fetch Global Parameters using WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters
300
301 WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters( x_param_info => l_global_param_info,
302 x_return_status =>l_return_status);
303
304 l_param_info.AUTO_RATE_TP_REL_TRIPS := l_global_param_info.AUTO_RATE_TP_REL_TRIPS;
305 l_param_info.TL_PRIN_COST_ALLOC_BASIS := l_global_param_info.TL_PRIN_COST_ALLOC_BASIS;
306 l_param_info.TL_DISTANCE_ALLOC_BASIS := l_global_param_info.TL_DISTANCE_ALLOC_BASIS;
307 l_param_info.TL_STOP_COST_ALLOC_BASIS := l_global_param_info.TL_STOP_COST_ALLOC_BASIS;
308 l_param_info.AUTOFIRM_LOAD_TENDERED_TRIPS:= l_global_param_info.AUTOFIRM_LOAD_TENDERED_TRIPS;
309 l_param_info.CONSOLIDATE_BO_LINES := l_global_param_info.CONSOLIDATE_BO_LINES;
310 l_param_info.GU_WEIGHT_CLASS := l_global_param_info.GU_WEIGHT_CLASS;
311 l_param_info.GU_WEIGHT_UOM := l_global_param_info.GU_WEIGHT_UOM;
312 l_param_info.GU_VOLUME_UOM := l_global_param_info.GU_VOLUME_UOM;
313 l_param_info.GU_VOLUME_CLASS := l_global_param_info.GU_VOLUME_CLASS;
314 l_param_info.GU_DISTANCE_CLASS := l_global_param_info.GU_DISTANCE_CLASS;
315 l_param_info.GU_DISTANCE_UOM := l_global_param_info.GU_DISTANCE_UOM;
316 l_param_info.GU_DIMENSION_CLASS := l_global_param_info.GU_DIMENSION_CLASS;
317 l_param_info.GU_DIMENSION_UOM := l_global_param_info.GU_DIMENSION_UOM;
318 l_param_info.GU_CURRENCY_COUNTRY := l_global_param_info.GU_CURRENCY_COUNTRY;
319 l_param_info.GU_CURRENCY_UOM := l_global_param_info.GU_CURRENCY_UOM;
320 l_param_info.GU_TIME_CLASS := l_global_param_info.GU_TIME_CLASS;
321 l_param_info.GU_TIME_UOM := l_global_param_info.GU_TIME_UOM;
322 l_param_info.DEF_MILE_CALC_ON_CUST_FAC := l_global_param_info.DEF_MILE_CALC_ON_CUST_FAC;
323 l_param_info.DEF_MILE_CALC_ON_SUPP_FAC := l_global_param_info.DEF_MILE_CALC_ON_SUPP_FAC;
324 l_param_info.DEF_MILE_CALC_ON_ORG_FAC := l_global_param_info.DEF_MILE_CALC_ON_ORG_FAC;
325 l_param_info.DEF_MILE_CALC_ON_CARR_FAC := l_global_param_info.DEF_MILE_CALC_ON_CARR_FAC;
326 l_param_info.TL_HWAY_DIS_EMP_CONSTANT := l_global_param_info.TL_HWAY_DIS_EMP_CONSTANT;
327 l_param_info.AVG_HWAY_SPEED := l_global_param_info.AVG_HWAY_SPEED;
328 l_param_info.DISTANCE_UOM := l_global_param_info.DISTANCE_UOM;
329 l_param_info.TIME_UOM := l_global_param_info.TIME_UOM;
330 l_param_info.UOM_FOR_NUM_OF_UNITS := l_global_param_info.UOM_FOR_NUM_OF_UNITS;
331 l_param_info.PALLET_ITEM_TYPE := l_global_param_info.PALLET_ITEM_TYPE;
332 l_param_info.ATTRIBUTE_CATEGORY := l_global_param_info.ATTRIBUTE_CATEGORY;
333 l_param_info.ATTRIBUTE1 := l_global_param_info.ATTRIBUTE1;
334 l_param_info.ATTRIBUTE2 := l_global_param_info.ATTRIBUTE2;
335 l_param_info.ATTRIBUTE3 := l_global_param_info.ATTRIBUTE3;
336 l_param_info.ATTRIBUTE4 := l_global_param_info.ATTRIBUTE4;
337 l_param_info.ATTRIBUTE5 := l_global_param_info.ATTRIBUTE5;
338 l_param_info.ATTRIBUTE6 := l_global_param_info.ATTRIBUTE6;
339 l_param_info.ATTRIBUTE7 := l_global_param_info.ATTRIBUTE7;
340 l_param_info.ATTRIBUTE8 := l_global_param_info.ATTRIBUTE8;
341 l_param_info.ATTRIBUTE9 := l_global_param_info.ATTRIBUTE9;
342 l_param_info.ATTRIBUTE10 := l_global_param_info.ATTRIBUTE10;
343 l_param_info.ATTRIBUTE11 := l_global_param_info.ATTRIBUTE11;
344 l_param_info.ATTRIBUTE12 := l_global_param_info.ATTRIBUTE12;
345 l_param_info.ATTRIBUTE13 := l_global_param_info.ATTRIBUTE13;
346 l_param_info.ATTRIBUTE14 := l_global_param_info.ATTRIBUTE14;
347 l_param_info.ATTRIBUTE15 := l_global_param_info.ATTRIBUTE15;
348 l_param_info.CREATION_DATE := l_global_param_info.CREATION_DATE;
349 l_param_info.CREATED_BY := l_global_param_info.CREATED_BY;
350 l_param_info.LAST_UPDATE_DATE := l_global_param_info.LAST_UPDATE_DATE;
351 l_param_info.LAST_UPDATED_BY := l_global_param_info.LAST_UPDATED_BY;
352 l_param_info.LAST_UPDATE_LOGIN := l_global_param_info.LAST_UPDATE_LOGIN;
353 l_param_info.DEFER_INTERFACE := l_global_param_info.DEFER_INTERFACE;
354 l_param_info.ENFORCE_SHIP_METHOD := l_global_param_info.ENFORCE_SHIP_METHOD;
355 l_param_info.ALLOW_FUTURE_SHIP_DATE := l_global_param_info.ALLOW_FUTURE_SHIP_DATE;
356 l_param_info.RATE_IB_DELS_FGT_TERM := l_global_param_info.RATE_IB_DELS_FGT_TERM;
357 l_param_info.SKIP_RATE_OB_DELS_FGT_TERM:= l_global_param_info.SKIP_RATE_OB_DELS_FGT_TERM;
358 l_param_info.DEL_DATE_CALC_METHOD := l_global_param_info.DEL_DATE_CALC_METHOD;
359 l_param_info.RATE_DS_DELS_FGT_TERM_ID := l_global_param_info.RATE_DS_DELS_FGT_TERM_ID;
360 l_param_info.RAISE_BUSINESS_EVENTS := l_global_param_info.RAISE_BUSINESS_EVENTS;
361 l_param_info.ENABLE_TRACKING_WFS := l_global_param_info.ENABLE_TRACKING_WFS;
362 l_param_info.ENABLE_SC_WF := l_global_param_info.ENABLE_SC_WF;
363 --bug 7491598 DEFER OTM-PLANNED SHIPMENT INTERFACES ENHANCEMENT
364 l_param_info.DEFER_PLAN_SHIPMENT_INTERFACE := l_global_param_info.DEFER_PLAN_SHIPMENT_INTERFACE;
365
366 x_return_status := l_return_status;
367 x_global_param_info := l_param_info;
368
369 IF l_debug_on THEN
370 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);
371 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);
372 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.TL_DISTANCE_ALLOC_BASIS ',X_GLOBAL_PARAM_INFO.TL_DISTANCE_ALLOC_BASIS);
373 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);
374 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.AUTOFIRM_LOAD_TENDERED_TRIPS ',X_GLOBAL_PARAM_INFO.AUTOFIRM_LOAD_TENDERED_TRIPS);
375 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.CONSOLIDATE_BO_LINES ',X_GLOBAL_PARAM_INFO.CONSOLIDATE_BO_LINES);
376 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.GU_WEIGHT_CLASS ',X_GLOBAL_PARAM_INFO.GU_WEIGHT_CLASS);
377 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.GU_WEIGHT_UOM ',X_GLOBAL_PARAM_INFO.GU_WEIGHT_UOM);
378 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.GU_VOLUME_UOM ',X_GLOBAL_PARAM_INFO.GU_VOLUME_UOM);
379 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.GU_VOLUME_CLASS ',X_GLOBAL_PARAM_INFO.GU_VOLUME_CLASS);
380 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.GU_DISTANCE_CLASS ',X_GLOBAL_PARAM_INFO.GU_DISTANCE_CLASS);
381 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.GU_DISTANCE_UOM ',X_GLOBAL_PARAM_INFO.GU_DISTANCE_UOM);
382 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.GU_DIMENSION_CLASS ',X_GLOBAL_PARAM_INFO.GU_DIMENSION_CLASS);
383 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.GU_DIMENSION_UOM ',X_GLOBAL_PARAM_INFO.GU_DIMENSION_UOM);
384 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.GU_CURRENCY_COUNTRY ',X_GLOBAL_PARAM_INFO.GU_CURRENCY_COUNTRY);
385 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.GU_CURRENCY_UOM ',X_GLOBAL_PARAM_INFO.GU_CURRENCY_UOM);
386 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.GU_TIME_CLASS ',X_GLOBAL_PARAM_INFO.GU_TIME_CLASS);
387 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.GU_TIME_UOM ',X_GLOBAL_PARAM_INFO.GU_TIME_UOM);
388 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);
389 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);
390 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);
391 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);
392 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);
393 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.AVG_HWAY_SPEED ',X_GLOBAL_PARAM_INFO.AVG_HWAY_SPEED);
394 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.DISTANCE_UOM ',X_GLOBAL_PARAM_INFO.DISTANCE_UOM);
395 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.TIME_UOM ',X_GLOBAL_PARAM_INFO.TIME_UOM);
396 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);
397 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.PALLET_ITEM_TYPE ',X_GLOBAL_PARAM_INFO.PALLET_ITEM_TYPE);
398 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.ATTRIBUTE_CATEGORY ',X_GLOBAL_PARAM_INFO.ATTRIBUTE_CATEGORY);
399 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.ATTRIBUTE1 ',X_GLOBAL_PARAM_INFO.ATTRIBUTE1);
400 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.ATTRIBUTE2 ',X_GLOBAL_PARAM_INFO.ATTRIBUTE2);
401 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.ATTRIBUTE3 ',X_GLOBAL_PARAM_INFO.ATTRIBUTE3);
402 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.ATTRIBUTE4 ',X_GLOBAL_PARAM_INFO.ATTRIBUTE4);
403 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.ATTRIBUTE5 ',X_GLOBAL_PARAM_INFO.ATTRIBUTE5);
404 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.ATTRIBUTE6 ',X_GLOBAL_PARAM_INFO.ATTRIBUTE6);
405 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.ATTRIBUTE7 ',X_GLOBAL_PARAM_INFO.ATTRIBUTE7);
406 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.ATTRIBUTE8 ',X_GLOBAL_PARAM_INFO.ATTRIBUTE8);
407 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.ATTRIBUTE9 ',X_GLOBAL_PARAM_INFO.ATTRIBUTE9);
408 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.ATTRIBUTE10 ',X_GLOBAL_PARAM_INFO.ATTRIBUTE10);
409 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.ATTRIBUTE11 ',X_GLOBAL_PARAM_INFO.ATTRIBUTE11);
410 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.ATTRIBUTE12 ',X_GLOBAL_PARAM_INFO.ATTRIBUTE12);
411 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.ATTRIBUTE13 ',X_GLOBAL_PARAM_INFO.ATTRIBUTE13);
412 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.ATTRIBUTE14 ',X_GLOBAL_PARAM_INFO.ATTRIBUTE14);
413 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.ATTRIBUTE15 ',X_GLOBAL_PARAM_INFO.ATTRIBUTE15);
414 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.CREATION_DATE ',X_GLOBAL_PARAM_INFO.CREATION_DATE);
415 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.CREATED_BY ',X_GLOBAL_PARAM_INFO.CREATED_BY);
416 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.LAST_UPDATE_DATE ',X_GLOBAL_PARAM_INFO.LAST_UPDATE_DATE);
417 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.LAST_UPDATED_BY ',X_GLOBAL_PARAM_INFO.LAST_UPDATED_BY);
418 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.LAST_UPDATE_LOGIN ',X_GLOBAL_PARAM_INFO.LAST_UPDATE_LOGIN);
419 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.ENFORCE_SHIP_METHOD ',X_GLOBAL_PARAM_INFO.ENFORCE_SHIP_METHOD);
420 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.ALLOW_FUTURE_SHIP_DATE ',X_GLOBAL_PARAM_INFO.ALLOW_FUTURE_SHIP_DATE);
421 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.DEFER_INTERFACE ',X_GLOBAL_PARAM_INFO.DEFER_INTERFACE);
422 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);
423 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);
424 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.DEL_DATE_CALC_METHOD ',X_GLOBAL_PARAM_INFO.DEL_DATE_CALC_METHOD);
425 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);
426 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.RAISE_BUSINESS_EVENTS',X_GLOBAL_PARAM_INFO.RAISE_BUSINESS_EVENTS);
427 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.ENABLE_TRACKING_WFS',X_GLOBAL_PARAM_INFO.ENABLE_TRACKING_WFS);
428 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.ENABLE_SC_WF',X_GLOBAL_PARAM_INFO.ENABLE_SC_WF);
429 --bug 7491598 DEFER OTM-PLANNED SHIPMENT INTERFACES ENHANCEMENT
430 WSH_DEBUG_SV.log(l_module_name,'X_GLOBAL_PARAM_INFO.DEFER_PLAN_SHIPMENT_INTERFACE',X_GLOBAL_PARAM_INFO.DEFER_PLAN_SHIPMENT_INTERFACE);
431
432 END IF;
433
434 --
435 -- Debug Statements
436 --
437 IF l_debug_on THEN
438 WSH_DEBUG_SV.pop(l_module_name);
439 END IF;
440 --
441
442 END Get_Global_Parameters;
443
444 END WSH_SHIPPING_PARAMS_GRP;