[Home] [Help]
PACKAGE BODY: APPS.WSH_SHIPMENT_ADVICE_PUB
Source
1 PACKAGE BODY WSH_SHIPMENT_ADVICE_PUB as
2 /* $Header: WSHSAPBB.pls 120.0.12010000.1 2010/02/25 17:15:36 sankarun noship $ */
3
4 G_PKG_NAME VARCHAR2(100) := 'WSH_SHIPMENT_ADVICE_PUB';
5 G_INTERFACE_ACTION_CODE VARCHAR2(100) := '94X_INBOUND';
6
7 --========================================================================
8 --PRIVATE APIS
9
10 PROCEDURE Create_Shipment_Advice(
11 p_delivery_rec IN Delivery_Rec_Type,
12 x_return_status OUT NOCOPY VARCHAR2);
13
14 PROCEDURE Debug_Shipment_Advice(
15 p_delivery_rec IN Delivery_Rec_Type);
16
17 --========================================================================
18 --========================================================================
19 -- PROCEDURE : Shipment_Advice PUBLIC
20 --
21 -- PARAMETERS: p_api_version_number known api version
22 -- p_init_msg_list FND_API.G_TRUE to reset list
23 -- p_action_code 'CREATE'
24 -- p_delivery_rec Attributes for the Shipment Advice entity
25 -- p_commit commit flag
26 -- x_return_status return status
27 -- x_msg_count number of messages in the list
28 -- x_msg_data text of messages
29 -- VERSION : current version 1.0
30 -- initial version 1.0
31 --========================================================================
32
33 PROCEDURE Shipment_Advice(
34 p_api_version_number IN NUMBER,
35 p_init_msg_list IN VARCHAR2 ,
36 p_delivery_rec IN Delivery_Rec_Type,
37 p_action IN VARCHAR2,
38 p_commit IN VARCHAR2 ,
39 x_return_status OUT NOCOPY VARCHAR2,
40 x_msg_count OUT NOCOPY NUMBER,
41 x_msg_data OUT NOCOPY VARCHAR2) IS
42
43 l_return_status VARCHAR2(100);
44 l_api_version_number CONSTANT NUMBER := 1.0;
45 l_api_name CONSTANT VARCHAR2(30):= 'Shipment_Advice';
46
47 --
48 l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
49 l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Shipment_Advice';
50 --
51 BEGIN
52 IF l_debug_on THEN
53 WSH_DEBUG_SV.push(l_module_name);
54 WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
55 END IF;
56 IF FND_API.to_Boolean(p_init_msg_list) THEN
57 FND_MSG_PUB.initialize;
58 END IF;
59 x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
60 IF NOT FND_API.Compatible_API_Call
61 ( l_api_version_number
62 , p_api_version_number
63 , l_api_name
64 , G_PKG_NAME
65 )
66 THEN
67 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
68 END IF;
69
70 IF p_action = 'CREATE' THEN
71 IF l_debug_on THEN
72 WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit Create_Shipment_Advice', WSH_DEBUG_SV.C_PROC_LEVEL);
73 END IF;
74 Create_Shipment_Advice(
75 p_delivery_rec => p_delivery_rec,
76 x_return_status => l_return_status);
77 IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
78 RAISE FND_API.G_EXC_ERROR;
79 END IF;
80 IF p_commit = FND_API.G_TRUE THEN
81 COMMIT;
82 END IF;
83 ELSE
84 x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
85 fnd_message.set_name('WSH', 'WSH_PUB_INVALID_ACTION');
86 fnd_message.set_token('ACTION_CODE', p_action);
87 wsh_util_core.add_message(x_return_status);
88 IF l_debug_on THEN
89 WSH_DEBUG_SV.log(l_module_name, 'p_action_code should be CREATE.The current value is',p_action);
90 END IF;
91 RAISE FND_API.G_EXC_ERROR;
92
93 END IF;
94 IF l_debug_on THEN
95 WSH_DEBUG_SV.pop(l_module_name);
96 END IF;
97
98 EXCEPTION
99 WHEN FND_API.G_EXC_ERROR THEN
100 x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
101 IF l_debug_on THEN
102 WSH_DEBUG_SV.logmsg(l_module_name,'Rolling back the transactions');
103 END IF;
104 rollback;
105 fnd_msg_pub.count_and_get(p_count => x_msg_count,
106 p_data => x_msg_data,
107 p_encoded => fnd_api.g_false);
108 IF l_debug_on THEN
109 WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
110 END IF;
111 WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
112 x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
113 IF l_debug_on THEN
114 WSH_DEBUG_SV.logmsg(l_module_name,'Rolling back the transactions');
115 END IF;
116 rollback;
117 fnd_msg_pub.count_and_get(p_count => x_msg_count,
118 p_data => x_msg_data,
119 p_encoded => fnd_api.g_false);
120
121 IF l_debug_on THEN
122 WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
123 END IF;
124 WHEN OTHERS THEN
125 x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
126 IF l_debug_on THEN
127 WSH_DEBUG_SV.logmsg(l_module_name,'Rolling back the transactions');
128 END IF;
129 fnd_msg_pub.count_and_get(p_count => x_msg_count,
130 p_data => x_msg_data,
131 p_encoded => fnd_api.g_false);
132 rollback;
133 IF l_debug_on THEN
134 WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
135 WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
136 END IF;
137 END Shipment_Advice;
138
139
140 --========================================================================
141 -- PROCEDURE : Create_Shipment_Advice PRIVATE
142 --
143 -- PARAMETERS:
144 -- p_delivery_rec Attributes for the create shipment Advice
145 -- x_return_status return status
146 --
147 -- COMMENT : Inserts records into WTH,WDAI,WDDI,WNDI,WFCI,WTI,WTSI and WDLI
148 --========================================================================
149
150
151 PROCEDURE Create_Shipment_Advice(
152 p_delivery_rec IN Delivery_Rec_Type,
153 x_return_status OUT NOCOPY VARCHAR2) IS
154
155 --
156 l_delivery_interface_id WSH_NEW_DEL_INTERFACE.delivery_interface_id%TYPE;
157 l_del_detail_interface_id WSH_DEL_DETAILS_INTERFACE.delivery_detail_interface_id%TYPE;
158 l_del_leg_interface_id NUMBER;
159 l_pickup_stop_interface_id NUMBER;
160 l_dropoff_stop_interface_id NUMBER;
161 l_trip_interface_id NUMBER;
162 l_del_assgn_cnt NUMBER :=0;
163 l_wdai_del_interface_id WSH_UTIL_CORE.ID_TAB_TYPE;
164 l_wdai_del_det_interface_id WSH_UTIL_CORE.ID_TAB_TYPE;
165 l_wdai_del_detail_id WSH_UTIL_CORE.ID_TAB_TYPE;
166 l_wdai_parent_del_detail_id WSH_UTIL_CORE.ID_TAB_TYPE;
167 --
168 l_return_status VARCHAR2(100);
169 l_exists NUMBER;
170 l_ins_rows NUMBER;
171 --
172 l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
173 l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Create_Shipmemt_Advice';
174 --
175 BEGIN
176 --
177 IF l_debug_on THEN
178 WSH_DEBUG_SV.push(l_module_name);
179 --WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit Debug_Shipment_Advice', WSH_DEBUG_SV.C_PROC_LEVEL);
180 --Debug_Shipment_Advice(p_delivery_rec);
181 END IF;
182 --
183 x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
184 --
185 IF p_delivery_rec.document_number IS NULL THEN
186 x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
187 fnd_message.set_name('WSH', 'WSH_SA_ATTR_MANDATORY');
188 fnd_message.set_token('ATTRIBUTE','DOCUMENT_NUMBER ');
189 wsh_util_core.add_message(x_return_status);
190
191 IF l_debug_on THEN
192 WSH_DEBUG_SV.log(l_module_name, 'Mandatory input parameters have not been passed');
193 END IF;
194 RAISE FND_API.G_EXC_ERROR;
195 END IF;
196 select count(*) into l_exists
197 FROM wsh_transactions_history
198 WHERE document_number = p_delivery_rec.document_number
199 AND document_type = 'SA'
200 AND document_direction = 'I';
201
202 if l_exists >0 THEN
203 x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
204 fnd_message.set_name('WSH', 'WSH_SA_DUP_DOCUMENT');
205 fnd_message.set_token('DOCUMENT_NUMBER', p_delivery_rec.document_number);
206 wsh_util_core.add_message(x_return_status);
207 IF l_debug_on THEN
208 wsh_debug_sv.logmsg(l_module_name, 'The document already exists');
209 END IF;
210 RAISE FND_API.G_EXC_ERROR;
211 END IF;
212
213 IF l_debug_on THEN
214 wsh_debug_sv.logmsg(l_module_name, 'Inserting into WSH_NEW_DEL_INTERFACE');
215 END IF;
216
217 INSERT INTO WSH_NEW_DEL_INTERFACE(
218 DELIVERY_INTERFACE_ID,
219 NAME,
220 DESCRIPTION,
221 INITIAL_PICKUP_DATE,
222 ULTIMATE_DROPOFF_DATE,
223 FREIGHT_TERMS_CODE,
224 GROSS_WEIGHT,
225 NET_WEIGHT,
226 WEIGHT_UOM_CODE,
227 NUMBER_OF_LPN,
228 VOLUME,
229 VOLUME_UOM_CODE,
230 SHIPPING_MARKS,
231 FOB_CODE,
232 SHIP_METHOD_CODE,
233 ORGANIZATION_CODE,
234 LOADING_SEQUENCE,
235 ATTRIBUTE_CATEGORY,
236 ATTRIBUTE1,
237 ATTRIBUTE2,
238 ATTRIBUTE3,
239 ATTRIBUTE4,
240 ATTRIBUTE5,
241 ATTRIBUTE6,
242 ATTRIBUTE7,
243 ATTRIBUTE8,
244 ATTRIBUTE9,
245 ATTRIBUTE10,
246 ATTRIBUTE11,
247 ATTRIBUTE12,
248 ATTRIBUTE13,
249 ATTRIBUTE14,
250 ATTRIBUTE15,
251 WAYBILL,
252 carrier_code,
253 SERVICE_LEVEL,
254 MODE_OF_TRANSPORT,
255 wv_frozen_flag,
256 SHIPMENT_DIRECTION,
257 DELIVERED_DATE,
258 CUSTOMER_NAME,
259 PLANNED_FLAG,
260 STATUS_CODE,
261 INTERFACE_ACTION_CODE,
262 DELIVERY_TYPE,
263 INITIAL_PICKUP_LOCATION_CODE,
264 SHIP_TO_CUSTOMER_NAME,
265 SHIP_TO_ADDRESS1,
266 SHIP_TO_ADDRESS2,
267 SHIP_TO_ADDRESS3,
268 SHIP_TO_ADDRESS4,
269 SHIP_TO_CITY,
270 SHIP_TO_STATE,
271 SHIP_TO_COUNTRY,
272 SHIP_TO_POSTAL_CODE,
273 CREATION_DATE,
274 CREATED_BY,
275 LAST_UPDATE_DATE,
276 LAST_UPDATED_BY,
277 LAST_UPDATE_LOGIN,
278 program_application_id,
279 program_id,
280 program_update_date,
281 request_id
282 )
283 VALUES(
284 wsh_new_del_interface_s.nextval,
285 p_delivery_rec.name,
286 p_delivery_rec.DESCRIPTION,
287 p_delivery_rec.INITIAL_PICKUP_DATE,
288 p_delivery_rec.ULTIMATE_DROPOFF_DATE,
289 p_delivery_rec.FREIGHT_TERMS_CODE,
290 p_delivery_rec.GROSS_WEIGHT,
291 p_delivery_rec.NET_WEIGHT,
292 p_delivery_rec.WEIGHT_UOM_CODE,
293 p_delivery_rec.NUMBER_OF_LPN,
294 p_delivery_rec.VOLUME,
295 p_delivery_rec.VOLUME_UOM_CODE,
296 p_delivery_rec.SHIPPING_MARKS,
297 p_delivery_rec.FOB_CODE,
298 p_delivery_rec.SHIP_METHOD_CODE,
299 p_delivery_rec.ORGANIZATION_CODE,
300 p_delivery_rec.LOADING_SEQUENCE,
301 p_delivery_rec.ATTRIBUTE_CATEGORY,
302 p_delivery_rec.ATTRIBUTE1,
303 p_delivery_rec.ATTRIBUTE2,
304 p_delivery_rec.ATTRIBUTE3,
305 p_delivery_rec.ATTRIBUTE4,
306 p_delivery_rec.ATTRIBUTE5,
307 p_delivery_rec.ATTRIBUTE6,
308 p_delivery_rec.ATTRIBUTE7,
309 p_delivery_rec.ATTRIBUTE8,
310 p_delivery_rec.ATTRIBUTE9,
311 p_delivery_rec.ATTRIBUTE10,
312 p_delivery_rec.ATTRIBUTE11,
313 p_delivery_rec.ATTRIBUTE12,
314 p_delivery_rec.ATTRIBUTE13,
315 p_delivery_rec.ATTRIBUTE14,
316 p_delivery_rec.ATTRIBUTE15,
317 p_delivery_rec.WAYBILL,
318 p_delivery_rec.carrier_code,
319 p_delivery_rec.SERVICE_LEVEL,
320 p_delivery_rec.MODE_OF_TRANSPORT,
321 p_delivery_rec.wv_frozen_flag,
322 p_delivery_rec.shipment_direction,
323 p_delivery_rec.DELIVERED_DATE,
324 p_delivery_rec.CUSTOMER_NAME,
325 'N',
326 'OP',
327 G_INTERFACE_ACTION_CODE,
328 'STANDARD',
329 p_delivery_rec.INITIAL_PICKUP_LOCATION_CODE,
330 p_delivery_rec.SHIP_TO_CUSTOMER_NAME,
331 p_delivery_rec.SHIP_TO_ADDRESS1,
332 p_delivery_rec.SHIP_TO_ADDRESS2,
333 p_delivery_rec.SHIP_TO_ADDRESS3,
334 p_delivery_rec.SHIP_TO_ADDRESS4,
335 p_delivery_rec.SHIP_TO_CITY,
336 p_delivery_rec.SHIP_TO_STATE,
337 p_delivery_rec.SHIP_TO_COUNTRY,
338 p_delivery_rec.SHIP_TO_POSTAL_CODE,
339 sysdate,
340 FND_GLOBAL.USER_ID,
341 sysdate,
342 FND_GLOBAL.USER_ID,
343 FND_GLOBAL.LOGIN_ID,
344 FND_GLOBAL.PROG_APPL_ID,
345 FND_GLOBAL.Conc_Program_Id,
346 sysdate,
347 FND_GLOBAL.Conc_Request_Id
348 )
349 RETURNING DELIVERY_INTERFACE_ID into l_delivery_interface_id;
350
351 l_ins_rows := sql%rowcount;
352 IF l_debug_on THEN
353 WSH_DEBUG_SV.log(l_module_name, 'Number of records inserted into WSH_NEW_DEL_INTERFACE',l_ins_rows);
354 WSH_DEBUG_SV.log(l_module_name, 'Number of Delivery Freight records',p_delivery_rec.delivery_freight_tab.count);
355 END IF;
356
357
358 IF p_delivery_rec.delivery_freight_tab.count>0 THEN --Delivery's Freight costs
359 --{
360 IF l_debug_on THEN
361 wsh_debug_sv.logmsg(l_module_name, 'Inserting WSH_FREIGHT_COSTS_INTERFACE for the delivery');
362 END IF;
363 FOR k in 1..p_delivery_rec.delivery_freight_tab.count LOOP --Looping through Delivery's Freight costs
364
365 INSERT INTO WSH_FREIGHT_COSTS_INTERFACE(
366 FREIGHT_COST_INTERFACE_ID,
367 INTERFACE_ACTION_CODE,
368 ATTRIBUTE_CATEGORY,
369 ATTRIBUTE1,
370 ATTRIBUTE2,
371 ATTRIBUTE3,
372 ATTRIBUTE4,
373 ATTRIBUTE5,
374 ATTRIBUTE6,
375 ATTRIBUTE7,
376 ATTRIBUTE8,
377 ATTRIBUTE9,
378 ATTRIBUTE10,
379 ATTRIBUTE11,
380 ATTRIBUTE12,
381 ATTRIBUTE13,
382 ATTRIBUTE14,
383 ATTRIBUTE15,
384 CREATION_DATE,
385 CREATED_BY,
386 LAST_UPDATE_DATE,
387 LAST_UPDATED_BY,
388 DELIVERY_INTERFACE_ID,
389 DELIVERY_DETAIL_INTERFACE_ID,
390 FREIGHT_COST_TYPE_CODE,
391 UNIT_AMOUNT,
392 CURRENCY_CODE)
393 VALUES(
394 wsh_freight_costs_interface_s.nextval,
395 G_INTERFACE_ACTION_CODE,
396 p_delivery_rec.delivery_freight_tab(k).ATTRIBUTE_CATEGORY,
397 p_delivery_rec.delivery_freight_tab(k).ATTRIBUTE1,
398 p_delivery_rec.delivery_freight_tab(k).ATTRIBUTE2,
399 p_delivery_rec.delivery_freight_tab(k).ATTRIBUTE3,
400 p_delivery_rec.delivery_freight_tab(k).ATTRIBUTE4,
401 p_delivery_rec.delivery_freight_tab(k).ATTRIBUTE5,
402 p_delivery_rec.delivery_freight_tab(k).ATTRIBUTE6,
403 p_delivery_rec.delivery_freight_tab(k).ATTRIBUTE7,
404 p_delivery_rec.delivery_freight_tab(k).ATTRIBUTE8,
405 p_delivery_rec.delivery_freight_tab(k).ATTRIBUTE9,
406 p_delivery_rec.delivery_freight_tab(k).ATTRIBUTE10,
407 p_delivery_rec.delivery_freight_tab(k).ATTRIBUTE11,
408 p_delivery_rec.delivery_freight_tab(k).ATTRIBUTE12,
409 p_delivery_rec.delivery_freight_tab(k).ATTRIBUTE13,
410 p_delivery_rec.delivery_freight_tab(k).ATTRIBUTE14,
411 p_delivery_rec.delivery_freight_tab(k).ATTRIBUTE15,
412 sysdate,
413 FND_GLOBAL.USER_ID,
414 sysdate,
415 FND_GLOBAL.USER_ID,
416 l_delivery_interface_id,
417 NULL,
418 p_delivery_rec.delivery_freight_tab(k).FREIGHT_COST_TYPE_CODE,
419 p_delivery_rec.delivery_freight_tab(k).UNIT_AMOUNT,
420 p_delivery_rec.delivery_freight_tab(k).CURRENCY_CODE
421 );
422 END LOOP;--End of looping through Delivery's Freight Costs..
423 --}
424 END IF;--Delivery's Freight costs
425 IF l_debug_on THEN
426 WSH_DEBUG_SV.log(l_module_name, 'Number of delivery details details',p_delivery_rec.delivery_details_tab.count);
427 END IF;
428
429 IF p_delivery_rec.delivery_details_tab.count > 0 THEN --Delivery details count
430 --{
431 IF l_debug_on THEN
432 wsh_debug_sv.logmsg(l_module_name, 'Inserting into WDDI and WFCI(delivery details freight info))');
433 END IF;
434 FOR I in 1..p_delivery_rec.delivery_details_tab.count LOOP
435 --{
436 IF l_debug_on THEN
437 wsh_debug_sv.logmsg(l_module_name, 'Inserting Rec'||i||' into WSH_DEL_DETAILS_INTERFACE (validating source_line_id)');
438 END IF;
439 IF p_delivery_rec.delivery_details_tab(i).source_line_id IS NULL THEN
440
441 x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
442 fnd_message.set_name('WSH', 'WSH_SA_ATTR_MANDATORY');
443 fnd_message.set_token('ATTRIBUTE','LINE_NUMBER');
444 wsh_util_core.add_message(x_return_status);
445 IF l_debug_on THEN
446 wsh_debug_sv.logmsg(l_module_name, 'Line number is a mandatory parameter for delivery_detail_interface records');
447 END IF;
448 RAISE FND_API.G_EXC_ERROR;
449 END IF;
450 INSERT INTO WSH_DEL_DETAILS_INTERFACE(
451 DELIVERY_DETAIL_INTERFACE_ID,
452 ITEM_NUMBER,
453 REQUESTED_QUANTITY,
454 REQUESTED_QUANTITY_UOM,
455 ITEM_DESCRIPTION,
456 REVISION,
457 SHIPPED_QUANTITY,
458 VOLUME,
459 VOLUME_UOM_CODE,
460 GROSS_WEIGHT,
461 NET_WEIGHT,
462 WEIGHT_UOM_CODE,
463 DELIVERY_DETAIL_ID,
464 SOURCE_LINE_ID,
465 LOAD_SEQ_NUMBER,
466 SUBINVENTORY,
467 LOT_NUMBER,
468 PREFERRED_GRADE,
469 SERIAL_NUMBER,
470 TO_SERIAL_NUMBER,
471 ATTRIBUTE_CATEGORY,
472 ATTRIBUTE1,
473 ATTRIBUTE2,
474 ATTRIBUTE3,
475 ATTRIBUTE4,
476 ATTRIBUTE5,
477 ATTRIBUTE6,
478 ATTRIBUTE7,
479 ATTRIBUTE8,
480 ATTRIBUTE9,
481 ATTRIBUTE10,
482 ATTRIBUTE11,
483 ATTRIBUTE12,
484 ATTRIBUTE13,
485 ATTRIBUTE14,
486 ATTRIBUTE15,
487 SOURCE_HEADER_NUMBER,
488 LINE_DIRECTION,
489 WV_FROZEN_FLAG,
490 CYCLE_COUNT_QUANTITY,
491 LOCATOR_CODE,
492 SOURCE_CODE,
493 CONTAINER_FLAG,
494 INTERFACE_ACTION_CODE,
495 ORGANIZATION_CODE,
496 CREATION_DATE,
497 CREATED_BY,
498 LAST_UPDATE_DATE,
499 LAST_UPDATED_BY,
500 LAST_UPDATE_LOGIN,
501 PROGRAM_APPLICATION_ID,
502 PROGRAM_ID,
503 PROGRAM_UPDATE_DATE,
504 REQUEST_ID
505 )
506 VALUES(
507 wsh_del_details_interface_s.nextval,
508 p_delivery_rec.delivery_details_tab(i).ITEM_NUMBER,
509 p_delivery_rec.delivery_details_tab(i).REQUESTED_QUANTITY,
510 p_delivery_rec.delivery_details_tab(i).REQUESTED_QUANTITY_UOM,
511 p_delivery_rec.delivery_details_tab(i).ITEM_DESCRIPTION,
512 p_delivery_rec.delivery_details_tab(i).REVISION,
513 p_delivery_rec.delivery_details_tab(i).SHIPPED_QUANTITY,
514 p_delivery_rec.delivery_details_tab(i).VOLUME,
515 p_delivery_rec.delivery_details_tab(i).VOLUME_UOM_CODE,
516 p_delivery_rec.delivery_details_tab(i).GROSS_WEIGHT,
517 p_delivery_rec.delivery_details_tab(i).NET_WEIGHT,
518 p_delivery_rec.delivery_details_tab(i).WEIGHT_UOM_CODE,
519 p_delivery_rec.delivery_details_tab(i).delivery_detail_number,
520 p_delivery_rec.delivery_details_tab(i).source_line_id,
521 p_delivery_rec.delivery_details_tab(i).LOAD_SEQ_NUMBER,
522 p_delivery_rec.delivery_details_tab(i).SUBINVENTORY,
523 p_delivery_rec.delivery_details_tab(i).LOT_NUMBER,
524 p_delivery_rec.delivery_details_tab(i).PREFERRED_GRADE,
525 p_delivery_rec.delivery_details_tab(i).SERIAL_NUMBER,
526 p_delivery_rec.delivery_details_tab(i).TO_SERIAL_NUMBER,
527 p_delivery_rec.delivery_details_tab(i).ATTRIBUTE_CATEGORY,
528 p_delivery_rec.delivery_details_tab(i).ATTRIBUTE1,
529 p_delivery_rec.delivery_details_tab(i).ATTRIBUTE2,
530 p_delivery_rec.delivery_details_tab(i).ATTRIBUTE3,
531 p_delivery_rec.delivery_details_tab(i).ATTRIBUTE4,
532 p_delivery_rec.delivery_details_tab(i).ATTRIBUTE5,
533 p_delivery_rec.delivery_details_tab(i).ATTRIBUTE6,
534 p_delivery_rec.delivery_details_tab(i).ATTRIBUTE7,
535 p_delivery_rec.delivery_details_tab(i).ATTRIBUTE8,
536 p_delivery_rec.delivery_details_tab(i).ATTRIBUTE9,
537 p_delivery_rec.delivery_details_tab(i).ATTRIBUTE10,
538 p_delivery_rec.delivery_details_tab(i).ATTRIBUTE11,
539 p_delivery_rec.delivery_details_tab(i).ATTRIBUTE12,
540 p_delivery_rec.delivery_details_tab(i).ATTRIBUTE13,
541 p_delivery_rec.delivery_details_tab(i).ATTRIBUTE14,
542 p_delivery_rec.delivery_details_tab(i).ATTRIBUTE15,
543 p_delivery_rec.delivery_details_tab(i).SOURCE_HEADER_NUMBER,
544 p_delivery_rec.delivery_details_tab(i).line_direction,
545 p_delivery_rec.delivery_details_tab(i).WV_FROZEN_FLAG,
546 p_delivery_rec.delivery_details_tab(i).CYCLE_COUNT_QUANTITY,
547 p_delivery_rec.delivery_details_tab(i).LOCATOR_CODE,
548 'WSH',
549 'N',
550 G_INTERFACE_ACTION_CODE,
551 p_delivery_rec.ORGANIZATION_CODE,
552 sysdate,
553 FND_GLOBAL.USER_ID,
554 sysdate,
555 FND_GLOBAL.USER_ID,
556 FND_GLOBAL.LOGIN_ID,
557 FND_GLOBAL.PROG_APPL_ID,
558 FND_GLOBAL.Conc_Program_Id,
559 sysdate,
560 FND_GLOBAL.Conc_Request_Id)
561 RETURNING DELIVERY_DETAIL_INTERFACE_ID into l_del_detail_interface_id;
562
563 l_del_assgn_cnt := l_del_assgn_cnt +1;
564 l_WDAI_DEL_INTERFACE_ID(l_del_assgn_cnt) := L_DELIVERY_INTERFACE_ID;
565 l_WDAI_DEL_DET_INTERFACE_ID(l_del_assgn_cnt) := l_del_detail_interface_id;
566 l_WDAI_DEL_DETAIL_ID(l_del_assgn_cnt) := p_delivery_rec.delivery_details_tab(i).delivery_detail_number;
567 l_WDAI_PARENT_DEL_DETAIL_ID(l_del_assgn_cnt) := p_delivery_rec.delivery_details_tab(i).PARENT_DELIVERY_DETAIL_NUMBER;
568
569 IF l_debug_on THEN
570 WSH_DEBUG_SV.log(l_module_name, 'Number of delivery details Freight Records',p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab.count);
571 END IF;
572
573 IF p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab.count > 0 THEN --Delivery details Freight costs count
574 --{
575 IF l_debug_on THEN
576 wsh_debug_sv.logmsg(l_module_name, 'Inserting into WFCI for delivery detail rec ' || i);
577 END IF;
578 FOR k in 1..p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab.count LOOP
579 --{
580 INSERT INTO WSH_FREIGHT_COSTS_INTERFACE(
581 FREIGHT_COST_INTERFACE_ID,
582 INTERFACE_ACTION_CODE,
583 ATTRIBUTE_CATEGORY,
584 ATTRIBUTE1,
585 ATTRIBUTE2,
586 ATTRIBUTE3,
587 ATTRIBUTE4,
588 ATTRIBUTE5,
589 ATTRIBUTE6,
590 ATTRIBUTE7,
591 ATTRIBUTE8,
592 ATTRIBUTE9,
593 ATTRIBUTE10,
594 ATTRIBUTE11,
595 ATTRIBUTE12,
596 ATTRIBUTE13,
597 ATTRIBUTE14,
598 ATTRIBUTE15,
599 CREATION_DATE,
600 CREATED_BY,
601 LAST_UPDATE_DATE,
602 LAST_UPDATED_BY,
603 DELIVERY_INTERFACE_ID,
604 DELIVERY_DETAIL_INTERFACE_ID,
605 FREIGHT_COST_TYPE_CODE,
606 UNIT_AMOUNT,
607 CURRENCY_CODE)
608 VALUES(
609 wsh_freight_costs_interface_s.nextval,
610 G_INTERFACE_ACTION_CODE,
611 p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab(k).ATTRIBUTE_CATEGORY,
612 p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab(k).ATTRIBUTE1,
613 p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab(k).ATTRIBUTE2,
614 p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab(k).ATTRIBUTE3,
615 p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab(k).ATTRIBUTE4,
616 p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab(k).ATTRIBUTE5,
617 p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab(k).ATTRIBUTE6,
618 p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab(k).ATTRIBUTE7,
619 p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab(k).ATTRIBUTE8,
620 p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab(k).ATTRIBUTE9,
621 p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab(k).ATTRIBUTE10,
622 p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab(k).ATTRIBUTE11,
623 p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab(k).ATTRIBUTE12,
624 p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab(k).ATTRIBUTE13,
625 p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab(k).ATTRIBUTE14,
626 p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab(k).ATTRIBUTE15,
627 sysdate,
628 FND_GLOBAL.USER_ID,
629 sysdate,
630 FND_GLOBAL.USER_ID,
631 NULL,
632 l_del_detail_interface_id,
633 p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab(k).FREIGHT_COST_TYPE_CODE,
634 p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab(k).UNIT_AMOUNT,
635 p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab(k).CURRENCY_CODE
636 );
637 --}
638 END LOOP;--End of looping through Delivery details' Freight Costs..
639 --}
640 END IF;--Delivery details Freight costs count
641
642 --}
643 END LOOP;--End of looping through Delivery details..
644 --}
645 END IF;--Delivery details count
646
647 IF l_debug_on THEN
648 wsh_debug_sv.log(l_module_name, 'Number of Master Container Records',p_delivery_rec.container_tab.count);
649 END IF;
650 IF p_delivery_rec.container_tab.count > 0 THEN --Master Containers
651 --{
652 IF l_debug_on THEN
653 wsh_debug_sv.logmsg(l_module_name, 'Inserting Master Container records into WDDI');
654 END IF;
655 FOR i in 1..p_delivery_rec.container_tab.count LOOP --Master Containers
656 --{
657 INSERT INTO WSH_DEL_DETAILS_INTERFACE(
658 DELIVERY_DETAIL_INTERFACE_ID,
659 CONTAINER_NAME,
660 SEAL_CODE,
661 ITEM_NUMBER,
662 ITEM_DESCRIPTION,
663 DELIVERY_DETAIL_ID,
664 GROSS_WEIGHT,
665 NET_WEIGHT,
666 WEIGHT_UOM_CODE,
667 VOLUME,
668 VOLUME_UOM_CODE,
669 TRACKING_NUMBER,
670 SHIPPING_INSTRUCTIONS,
671 PACKING_INSTRUCTIONS,
672 ATTRIBUTE_CATEGORY,
673 ATTRIBUTE1,
674 ATTRIBUTE2,
675 ATTRIBUTE3,
676 ATTRIBUTE4,
677 ATTRIBUTE5,
678 ATTRIBUTE6,
679 ATTRIBUTE7,
680 ATTRIBUTE8,
681 ATTRIBUTE9,
682 ATTRIBUTE10,
683 ATTRIBUTE11,
684 ATTRIBUTE12,
685 ATTRIBUTE13,
686 ATTRIBUTE14,
687 ATTRIBUTE15,
688 WV_FROZEN_FLAG,
689 FILLED_VOLUME,
690 FILL_PERCENT,
691 SOURCE_CODE,
692 CONTAINER_FLAG,
693 INTERFACE_ACTION_CODE,
694 LINE_DIRECTION,
695 SOURCE_LINE_ID,
696 ORGANIZATION_CODE,
697 CREATION_DATE,
698 CREATED_BY,
699 LAST_UPDATE_DATE,
700 LAST_UPDATED_BY
701 )
702 VALUES(
703 wsh_del_details_interface_s.nextval,
704 p_delivery_rec.container_tab(i).CONTAINER_NAME,
705 p_delivery_rec.container_tab(i).SEAL_CODE,
706 p_delivery_rec.container_tab(i).ITEM_NUMBER,
707 p_delivery_rec.container_tab(i).ITEM_DESCRIPTION,
708 p_delivery_rec.container_tab(i).DELIVERY_DETAIL_NUMBER,
709 p_delivery_rec.container_tab(i).GROSS_WEIGHT,
710 p_delivery_rec.container_tab(i).NET_WEIGHT,
711 p_delivery_rec.container_tab(i).WEIGHT_UOM_CODE,
712 p_delivery_rec.container_tab(i).VOLUME,
713 p_delivery_rec.container_tab(i).VOLUME_UOM_CODE,
714 p_delivery_rec.container_tab(i).TRACKING_NUMBER,
715 p_delivery_rec.container_tab(i).SHIPPING_INSTRUCTIONS,
716 p_delivery_rec.container_tab(i).PACKING_INSTRUCTIONS,
717 p_delivery_rec.container_tab(i).ATTRIBUTE_CATEGORY,
718 p_delivery_rec.container_tab(i).ATTRIBUTE1,
719 p_delivery_rec.container_tab(i).ATTRIBUTE2,
720 p_delivery_rec.container_tab(i).ATTRIBUTE3,
721 p_delivery_rec.container_tab(i).ATTRIBUTE4,
722 p_delivery_rec.container_tab(i).ATTRIBUTE5,
723 p_delivery_rec.container_tab(i).ATTRIBUTE6,
724 p_delivery_rec.container_tab(i).ATTRIBUTE7,
725 p_delivery_rec.container_tab(i).ATTRIBUTE8,
726 p_delivery_rec.container_tab(i).ATTRIBUTE9,
727 p_delivery_rec.container_tab(i).ATTRIBUTE10,
728 p_delivery_rec.container_tab(i).ATTRIBUTE11,
729 p_delivery_rec.container_tab(i).ATTRIBUTE12,
730 p_delivery_rec.container_tab(i).ATTRIBUTE13,
731 p_delivery_rec.container_tab(i).ATTRIBUTE14,
732 p_delivery_rec.container_tab(i).ATTRIBUTE15,
733 p_delivery_rec.container_tab(i).WV_FROZEN_FLAG,
734 p_delivery_rec.container_tab(i).FILLED_VOLUME,
735 p_delivery_rec.container_tab(i).FILL_PERCENT,
736 'WSH',
737 'Y',
738 G_INTERFACE_ACTION_CODE,
739 p_delivery_rec.delivery_details_tab(i).line_direction,
740 p_delivery_rec.container_tab(i).DELIVERY_DETAIL_NUMBER,
741 p_delivery_rec.ORGANIZATION_CODE,
742 sysdate,
743 FND_GLOBAL.USER_ID,
744 sysdate,
745 FND_GLOBAL.USER_ID)
746 RETURNING DELIVERY_DETAIL_INTERFACE_ID into l_del_detail_interface_id;
747 l_del_assgn_cnt := l_del_assgn_cnt +1;
748 l_WDAI_DEL_INTERFACE_ID(l_del_assgn_cnt) := L_DELIVERY_INTERFACE_ID ;
749 l_WDAI_DEL_DET_INTERFACE_ID(l_del_assgn_cnt) := l_del_detail_interface_id ;
750 l_WDAI_DEL_DETAIL_ID(l_del_assgn_cnt) := p_delivery_rec.container_tab(i).delivery_detail_number ;
751 l_WDAI_PARENT_DEL_DETAIL_ID(l_del_assgn_cnt) := NULL ;
752
753 IF l_debug_on THEN
754 wsh_debug_sv.log(l_module_name, 'Number of Master Container Freight records',p_delivery_rec.container_tab(i).Master_Container_Freight_Tab.count);
755 END IF;
756 IF p_delivery_rec.container_tab(i).Master_Container_Freight_Tab.count > 0 THEN --Master Containers Freight
757 --{
758 IF l_debug_on THEN
759 wsh_debug_sv.logmsg(l_module_name, 'Inserting Master Container Freight records into WFCI');
760 END IF;
761 FOR k in 1..p_delivery_rec.container_tab(i).Master_Container_Freight_Tab.count LOOP --Master Containers Freight
762 --{
763 INSERT INTO WSH_FREIGHT_COSTS_INTERFACE(
764 FREIGHT_COST_INTERFACE_ID,
765 INTERFACE_ACTION_CODE,
766 ATTRIBUTE_CATEGORY,
767 ATTRIBUTE1,
768 ATTRIBUTE2,
769 ATTRIBUTE3,
770 ATTRIBUTE4,
771 ATTRIBUTE5,
772 ATTRIBUTE6,
773 ATTRIBUTE7,
774 ATTRIBUTE8,
775 ATTRIBUTE9,
776 ATTRIBUTE10,
777 ATTRIBUTE11,
778 ATTRIBUTE12,
779 ATTRIBUTE13,
780 ATTRIBUTE14,
781 ATTRIBUTE15,
782 CREATION_DATE,
783 CREATED_BY,
784 LAST_UPDATE_DATE,
785 LAST_UPDATED_BY,
786 DELIVERY_INTERFACE_ID,
787 DELIVERY_DETAIL_INTERFACE_ID,
788 FREIGHT_COST_TYPE_CODE,
789 UNIT_AMOUNT,
790 CURRENCY_CODE)
791 VALUES(
792 wsh_freight_costs_interface_s.nextval,
793 G_INTERFACE_ACTION_CODE,
794 p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(k).ATTRIBUTE_CATEGORY,
795 p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(k).ATTRIBUTE1,
796 p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(k).ATTRIBUTE2,
797 p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(k).ATTRIBUTE3,
798 p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(k).ATTRIBUTE4,
799 p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(k).ATTRIBUTE5,
800 p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(k).ATTRIBUTE6,
801 p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(k).ATTRIBUTE7,
802 p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(k).ATTRIBUTE8,
803 p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(k).ATTRIBUTE9,
804 p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(k).ATTRIBUTE10,
805 p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(k).ATTRIBUTE11,
806 p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(k).ATTRIBUTE12,
807 p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(k).ATTRIBUTE13,
808 p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(k).ATTRIBUTE14,
809 p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(k).ATTRIBUTE15,
810 sysdate,
811 FND_GLOBAL.USER_ID,
812 sysdate,
813 FND_GLOBAL.USER_ID,
814 NULL,
815 l_del_detail_interface_id,
816 p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(k).FREIGHT_COST_TYPE_CODE,
817 p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(k).UNIT_AMOUNT,
818 p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(k).CURRENCY_CODE
819 );
820 --}
821 END LOOP; --Master Containers Freight
822 --}
823 END IF; --Master Containers Freight
824
825 IF l_debug_on THEN
826 wsh_debug_sv.log(l_module_name, 'Number of Inner Containers with in the Master Container',p_delivery_rec.container_tab(i).Container_Tab.count);
827 END IF;
828 IF p_delivery_rec.container_tab(i).Container_Tab.count > 0 THEN --Inner Containers
829 --{
830
831 IF l_debug_on THEN
832 wsh_debug_sv.logmsg(l_module_name, 'Number of Inner containers : '||p_delivery_rec.container_tab(i).Container_Tab.count);
833 END IF;
834 FOR k in 1..p_delivery_rec.container_tab(i).Container_Tab.count LOOP --Inner Containers
835 --{
836 IF l_debug_on THEN
837 wsh_debug_sv.logmsg(l_module_name, 'Inserting Inner Container records into WDDI');
838 END IF;
839 INSERT INTO WSH_DEL_DETAILS_INTERFACE(
840 DELIVERY_DETAIL_INTERFACE_ID,
841 CONTAINER_NAME,
842 SEAL_CODE,
843 ITEM_NUMBER,
844 ITEM_DESCRIPTION,
845 DELIVERY_DETAIL_ID,
846 GROSS_WEIGHT,
847 NET_WEIGHT,
848 WEIGHT_UOM_CODE,
849 VOLUME,
850 VOLUME_UOM_CODE,
851 TRACKING_NUMBER,
852 SHIPPING_INSTRUCTIONS,
853 PACKING_INSTRUCTIONS,
854 ATTRIBUTE_CATEGORY,
855 ATTRIBUTE1,
856 ATTRIBUTE2,
857 ATTRIBUTE3,
858 ATTRIBUTE4,
859 ATTRIBUTE5,
860 ATTRIBUTE6,
861 ATTRIBUTE7,
862 ATTRIBUTE8,
863 ATTRIBUTE9,
864 ATTRIBUTE10,
865 ATTRIBUTE11,
866 ATTRIBUTE12,
867 ATTRIBUTE13,
868 ATTRIBUTE14,
869 ATTRIBUTE15,
870 WV_FROZEN_FLAG,
871 FILLED_VOLUME,
872 FILL_PERCENT,
873 SOURCE_CODE,
874 CONTAINER_FLAG,
875 INTERFACE_ACTION_CODE,
876 LINE_DIRECTION,
877 SOURCE_LINE_ID,
878 ORGANIZATION_CODE,
879 CREATION_DATE,
880 CREATED_BY,
881 LAST_UPDATE_DATE,
882 LAST_UPDATED_BY
883 )
884 VALUES(
885 wsh_del_details_interface_s.nextval,
886 p_delivery_rec.container_tab(i).container_tab(k).CONTAINER_NAME,
887 p_delivery_rec.container_tab(i).container_tab(k).SEAL_CODE,
888 p_delivery_rec.container_tab(i).container_tab(k).ITEM_NUMBER,
889 p_delivery_rec.container_tab(i).container_tab(k).ITEM_DESCRIPTION,
890 p_delivery_rec.container_tab(i).container_tab(k).DELIVERY_DETAIL_NUMBER,
891 p_delivery_rec.container_tab(i).container_tab(k).GROSS_WEIGHT,
892 p_delivery_rec.container_tab(i).container_tab(k).NET_WEIGHT,
893 p_delivery_rec.container_tab(i).container_tab(k).WEIGHT_UOM_CODE,
894 p_delivery_rec.container_tab(i).container_tab(k).VOLUME,
895 p_delivery_rec.container_tab(i).container_tab(k).VOLUME_UOM_CODE,
896 p_delivery_rec.container_tab(i).container_tab(k).TRACKING_NUMBER,
897 p_delivery_rec.container_tab(i).container_tab(k).SHIPPING_INSTRUCTIONS,
898 p_delivery_rec.container_tab(i).container_tab(k).PACKING_INSTRUCTIONS,
899 p_delivery_rec.container_tab(i).container_tab(k).ATTRIBUTE_CATEGORY,
900 p_delivery_rec.container_tab(i).container_tab(k).ATTRIBUTE1,
901 p_delivery_rec.container_tab(i).container_tab(k).ATTRIBUTE2,
902 p_delivery_rec.container_tab(i).container_tab(k).ATTRIBUTE3,
903 p_delivery_rec.container_tab(i).container_tab(k).ATTRIBUTE4,
904 p_delivery_rec.container_tab(i).container_tab(k).ATTRIBUTE5,
905 p_delivery_rec.container_tab(i).container_tab(k).ATTRIBUTE6,
906 p_delivery_rec.container_tab(i).container_tab(k).ATTRIBUTE7,
907 p_delivery_rec.container_tab(i).container_tab(k).ATTRIBUTE8,
908 p_delivery_rec.container_tab(i).container_tab(k).ATTRIBUTE9,
909 p_delivery_rec.container_tab(i).container_tab(k).ATTRIBUTE10,
910 p_delivery_rec.container_tab(i).container_tab(k).ATTRIBUTE11,
911 p_delivery_rec.container_tab(i).container_tab(k).ATTRIBUTE12,
912 p_delivery_rec.container_tab(i).container_tab(k).ATTRIBUTE13,
913 p_delivery_rec.container_tab(i).container_tab(k).ATTRIBUTE14,
914 p_delivery_rec.container_tab(i).container_tab(k).ATTRIBUTE15,
915 p_delivery_rec.container_tab(i).container_tab(k).WV_FROZEN_FLAG,
916 p_delivery_rec.container_tab(i).container_tab(k).FILLED_VOLUME,
917 p_delivery_rec.container_tab(i).container_tab(k).FILL_PERCENT,
918 'WSH',
919 'Y',
920 G_INTERFACE_ACTION_CODE,
921 p_delivery_rec.delivery_details_tab(i).line_direction,
922 p_delivery_rec.container_tab(i).container_tab(k).DELIVERY_DETAIL_NUMBER,
923 p_delivery_rec.ORGANIZATION_CODE,
924 sysdate,
925 FND_GLOBAL.USER_ID,
926 sysdate,
927 FND_GLOBAL.USER_ID)
928 RETURNING DELIVERY_DETAIL_INTERFACE_ID into l_del_detail_interface_id;
929
930
931 l_del_assgn_cnt := l_del_assgn_cnt +1;
932 l_WDAI_DEL_INTERFACE_ID(l_del_assgn_cnt) := L_DELIVERY_INTERFACE_ID ;
933 l_WDAI_DEL_DET_INTERFACE_ID(l_del_assgn_cnt) := l_del_detail_interface_id ;
934 l_WDAI_DEL_DETAIL_ID(l_del_assgn_cnt) := p_delivery_rec.container_tab(i).container_tab(k).delivery_detail_number ;
935 l_WDAI_PARENT_DEL_DETAIL_ID(l_del_assgn_cnt) := p_delivery_rec.container_tab(i).delivery_detail_number ;
936
937 IF l_debug_on THEN
938 wsh_debug_sv.log(l_module_name, 'Number of Inner Container Freight records', p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab.count);
939 END IF;
940 IF p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab.count > 0 THEN --Inner Containers Freight Costs
941 --{
942 IF l_debug_on THEN
943 wsh_debug_sv.logmsg(l_module_name, 'Inserting Inner Container Freight records into WFCI');
944 END IF;
945 FOR l in 1..p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab.count LOOP --Inner Containers Freight Costs
946 --{
947 INSERT INTO WSH_FREIGHT_COSTS_INTERFACE(
948 FREIGHT_COST_INTERFACE_ID,
949 INTERFACE_ACTION_CODE,
950 ATTRIBUTE_CATEGORY,
951 ATTRIBUTE1,
952 ATTRIBUTE2,
953 ATTRIBUTE3,
954 ATTRIBUTE4,
955 ATTRIBUTE5,
956 ATTRIBUTE6,
957 ATTRIBUTE7,
958 ATTRIBUTE8,
959 ATTRIBUTE9,
960 ATTRIBUTE10,
961 ATTRIBUTE11,
962 ATTRIBUTE12,
963 ATTRIBUTE13,
964 ATTRIBUTE14,
965 ATTRIBUTE15,
966 CREATION_DATE,
967 CREATED_BY,
968 LAST_UPDATE_DATE,
969 LAST_UPDATED_BY,
970 DELIVERY_INTERFACE_ID,
971 DELIVERY_DETAIL_INTERFACE_ID,
972 FREIGHT_COST_TYPE_CODE,
973 UNIT_AMOUNT,
974 CURRENCY_CODE)
975 VALUES(
976 wsh_freight_costs_interface_s.nextval,
977 G_INTERFACE_ACTION_CODE,
978 p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).ATTRIBUTE_CATEGORY,
979 p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).ATTRIBUTE1,
980 p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).ATTRIBUTE2,
981 p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).ATTRIBUTE3,
982 p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).ATTRIBUTE4,
983 p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).ATTRIBUTE5,
984 p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).ATTRIBUTE6,
985 p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).ATTRIBUTE7,
986 p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).ATTRIBUTE8,
987 p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).ATTRIBUTE9,
988 p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).ATTRIBUTE10,
989 p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).ATTRIBUTE11,
990 p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).ATTRIBUTE12,
991 p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).ATTRIBUTE13,
992 p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).ATTRIBUTE14,
993 p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).ATTRIBUTE15,
994 sysdate,
995 FND_GLOBAL.USER_ID,
996 sysdate,
997 FND_GLOBAL.USER_ID,
998 NULL,
999 l_del_detail_interface_id,
1000 p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).FREIGHT_COST_TYPE_CODE,
1001 p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).UNIT_AMOUNT,
1002 p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).CURRENCY_CODE
1003 );
1004 --}
1005 END LOOP;--Inner Containers Freight Costs
1006 --}
1007 END IF;--Inner Containers Freight Costs
1008 --}
1009 END LOOP;--Inner Containers
1010 --}
1011 END IF;--Inner Containers
1012
1013
1014 --}
1015 END LOOP;--Master Containers
1016 --}
1017 END IF;--Master Containers
1018
1019 IF l_debug_on THEN
1020 wsh_debug_sv.logmsg(l_module_name, 'Storing Trips and Trip Stops infp ');
1021 END IF;
1022
1023 IF l_del_assgn_cnt > 0 THEN
1024
1025
1026 IF l_debug_on THEN
1027 wsh_debug_sv.log(l_module_name, 'Inserting Records into WSH_DEL_ASSGN_INTERFACE.Number of Records',l_del_assgn_cnt);
1028 END IF;
1029 IF l_del_assgn_cnt <4 THEN
1030
1031 FOR I in 1..l_del_assgn_cnt LOOP
1032
1033 INSERT INTO WSH_DEL_ASSGN_INTERFACE(
1034 DEL_ASSGN_INTERFACE_ID,
1035 INTERFACE_ACTION_CODE,
1036 CREATION_DATE,
1037 CREATED_BY,
1038 LAST_UPDATE_DATE,
1039 LAST_UPDATED_BY,
1040 DELIVERY_INTERFACE_ID ,
1041 DELIVERY_DETAIL_INTERFACE_ID ,
1042 DELIVERY_DETAIL_ID,
1043 PARENT_DELIVERY_DETAIL_ID)
1044 VALUES(
1045 wsh_del_assgn_interface_s.nextval,
1046 G_INTERFACE_ACTION_CODE,
1047 sysdate,
1048 FND_GLOBAL.USER_ID,
1049 sysdate,
1050 FND_GLOBAL.USER_ID,
1051 l_WDAI_DEL_INTERFACE_ID(i),
1052 l_WDAI_DEL_DET_INTERFACE_ID(i),
1053 l_WDAI_DEL_DETAIL_ID(i),
1054 l_WDAI_PARENT_DEL_DETAIL_ID(i));
1055
1056 END LOOP;
1057
1058 ELSE
1059
1060 FORALL I in 1..l_del_assgn_cnt
1061
1062 INSERT INTO WSH_DEL_ASSGN_INTERFACE(
1063 DEL_ASSGN_INTERFACE_ID,
1064 INTERFACE_ACTION_CODE,
1065 CREATION_DATE,
1066 CREATED_BY,
1067 LAST_UPDATE_DATE,
1068 LAST_UPDATED_BY,
1069 DELIVERY_INTERFACE_ID ,
1070 DELIVERY_DETAIL_INTERFACE_ID ,
1071 DELIVERY_DETAIL_ID,
1072 PARENT_DELIVERY_DETAIL_ID)
1073 VALUES(
1074 wsh_del_assgn_interface_s.nextval,
1075 G_INTERFACE_ACTION_CODE,
1076 sysdate,
1077 FND_GLOBAL.USER_ID,
1078 sysdate,
1079 FND_GLOBAL.USER_ID,
1080 l_WDAI_DEL_INTERFACE_ID(i),
1081 l_WDAI_DEL_DET_INTERFACE_ID(i),
1082 l_WDAI_DEL_DETAIL_ID(i),
1083 l_WDAI_PARENT_DEL_DETAIL_ID(i));
1084 END IF;
1085
1086 END IF;
1087
1088 IF l_debug_on THEN
1089 WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTERFACE_COMMON_ACTIONS.Int_Trip_Stop_Info', WSH_DEBUG_SV.C_PROC_LEVEL);
1090 END IF;
1091
1092 WSH_INTERFACE_COMMON_ACTIONS.Int_Trip_Stop_Info(
1093 p_delivery_interface_id =>l_delivery_interface_id,
1094 p_act_dep_date => p_delivery_rec.actual_departure_date,
1095 p_dep_seal_code => p_delivery_rec.departure_seal_code,
1096 p_act_arr_date => p_delivery_rec.actual_arrival_date ,
1097 p_trip_vehicle_num => p_delivery_rec.vehicle_number,
1098 p_trip_veh_num_pfx => p_delivery_rec.vehicle_num_prefix,
1099 p_trip_route_id => p_delivery_rec.route_id,
1100 p_trip_routing_ins => p_delivery_rec.routing_instructions,
1101 p_operator => p_delivery_rec.operator ,
1102 x_return_status => l_return_status);
1103 IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1104 RAISE FND_API.G_EXC_ERROR;
1105 END IF;
1106
1107 INSERT INTO wsh_transactions_history (
1108 TRANSACTION_ID,
1109 DOCUMENT_TYPE,
1110 DOCUMENT_NUMBER,
1111 DOCUMENT_DIRECTION,
1112 TRANSACTION_STATUS,
1113 ACTION_TYPE,
1114 ENTITY_NUMBER,
1115 ENTITY_TYPE,
1116 TRADING_PARTNER_ID,
1117 CREATION_DATE,
1118 CREATED_BY,
1119 LAST_UPDATE_DATE,
1120 LAST_UPDATED_BY,
1121 LAST_UPDATE_LOGIN,
1122 REQUEST_ID,
1123 PROGRAM_APPLICATION_ID,
1124 PROGRAM_ID,
1125 PROGRAM_UPDATE_DATE)
1126 VALUES(
1127 wsh_transaction_s.nextval,
1128 'SA',
1129 p_delivery_rec.DOCUMENT_NUMBER,
1130 'I',
1131 'AP',
1132 'A',
1133 l_delivery_interface_id,
1134 'DLVY_INT',
1135 -1,
1136 sysdate,
1137 FND_GLOBAL.USER_ID,
1138 sysdate,
1139 FND_GLOBAL.USER_ID,
1140 FND_GLOBAL.LOGIN_ID,
1141 FND_GLOBAL.Conc_Request_Id,
1142 FND_GLOBAL.PROG_APPL_ID,
1143 FND_GLOBAL.Conc_Program_Id,
1144 sysdate);
1145
1146 --
1147 IF l_debug_on THEN
1148 WSH_DEBUG_SV.log(l_module_name, 'Return Status', x_return_status);
1149 WSH_DEBUG_SV.pop(l_module_name);
1150 END IF;
1151 --
1152
1153
1154 EXCEPTION
1155
1156 WHEN FND_API.G_EXC_ERROR THEN
1157 x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1158 IF l_debug_on THEN
1159 WSH_DEBUG_SV.log(l_module_name, 'Error Creating Shipment advance with Document_Number',p_delivery_rec.Document_Number);
1160 WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1161 END IF;
1162 WHEN OTHERS THEN
1163 x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1164 IF l_debug_on THEN
1165 WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1166 WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1167 END IF;
1168 END Create_Shipment_Advice;
1169
1170 --========================================================================
1171 -- PROCEDURE : Process_Shipment_Advice PUBLIC
1172 --
1173 -- PARAMETERS: p_api_version_number known api version
1174 -- p_init_msg_list FND_API.G_TRUE to reset list
1175 -- p_process_mode 'ONLINE' or 'CONCURRENT'
1176 -- p_log_level 0 or 1 to control the log messages
1177 -- p_transaction_status Status of Shipment Advice
1178 -- p_from_document_number From Document Number
1179 -- p_to_document_number To Document Number
1180 -- p_from_creation_date From Creation Date
1181 -- p_to_creation_date To Creation Date
1182 -- x_return_status return status
1183 -- VERSION : current version 1.0
1184 -- initial version 1.0
1185 -- COMMENT : Processes Shipment Advice as per criteria
1186 -- specified in p_transaction_status,p_from_document_number,
1187 -- p_to_document_number,p_from_creation_date and p_to_creation_date
1188 --========================================================================
1189
1190 PROCEDURE Process_Shipment_Advice (
1191 p_api_version_number IN NUMBER,
1192 p_init_msg_list IN VARCHAR2,
1193 p_commit IN VARCHAR2,
1194 p_process_mode IN VARCHAR2 ,
1195 p_log_level IN NUMBER,
1196 p_transaction_status IN VARCHAR2,
1197 p_from_document_number IN VARCHAR2,
1198 p_to_document_number IN VARCHAR2,
1199 p_from_creation_date IN DATE,
1200 p_to_creation_date IN DATE,
1201 p_transaction_id IN NUMBER,
1202 x_request_id OUT NOCOPY NUMBER,
1203 x_return_status OUT NOCOPY VARCHAR2,
1204 x_msg_count OUT NOCOPY NUMBER,
1205 x_msg_data OUT NOCOPY VARCHAR2)IS
1206
1207
1208 l_return_status VARCHAR2(100);
1209
1210 l_api_version_number CONSTANT NUMBER := 1.0;
1211 l_api_name CONSTANT VARCHAR2(30):= 'Process_Shipment_Advice';
1212 --
1213 l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
1214 l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Process_Shipmemt_Advice';
1215 --
1216
1217 BEGIN
1218 x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1219 IF l_debug_on then
1220 wsh_debug_sv.push(l_module_name);
1221 --
1222 WSH_DEBUG_SV.log(l_module_name,'p_process_mode',p_process_mode);
1223 WSH_DEBUG_SV.log(l_module_name,'p_log_level',p_log_level);
1224 WSH_DEBUG_SV.log(l_module_name,'p_commit',p_commit);
1225 WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list',p_init_msg_list);
1226 --
1227
1228 WSH_DEBUG_SV.log(l_module_name,'p_transaction_status',p_transaction_status);
1229 WSH_DEBUG_SV.log(l_module_name,'p_from_document_number',p_from_document_number);
1230 WSH_DEBUG_SV.log(l_module_name,'p_to_document_number',p_to_document_number);
1231 WSH_DEBUG_SV.log(l_module_name,'p_from_creation_date',p_from_creation_date);
1232 WSH_DEBUG_SV.log(l_module_name,'p_to_creation_date',p_to_creation_date);
1233 WSH_DEBUG_SV.log(l_module_name,'p_transaction_id',p_transaction_id);
1234
1235 END IF;
1236 IF FND_API.to_Boolean(p_init_msg_list) THEN
1237 FND_MSG_PUB.initialize;
1238 END IF;
1239
1240 IF NOT FND_API.Compatible_API_Call
1241 ( l_api_version_number
1242 , p_api_version_number
1243 , l_api_name
1244 , G_PKG_NAME
1245 )
1246 THEN
1247 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1248 END IF;
1249 IF p_process_mode = 'ONLINE' THEN
1250
1251 IF l_debug_on THEN
1252 WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPMENT_ADVICE_PKG.Process_Shipment_Advice', WSH_DEBUG_SV.C_PROC_LEVEL);
1253 END IF;
1254 WSH_SHIPMENT_ADVICE_PKG.Process_Shipment_Advice(
1255 p_commit_flag => p_commit,
1256 p_transaction_status => p_transaction_status,
1257 p_from_document_number => p_from_document_number ,
1258 p_to_document_number => p_to_document_number,
1259 p_from_creation_date => to_date(p_from_creation_date,'yy-mm-dd'),
1260 p_to_creation_date => to_date(p_to_creation_date,'yy-mm-dd'),
1261 p_transaction_id => p_transaction_id,
1262 x_return_status => l_return_status);
1263
1264 IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1265 --
1266 IF l_debug_on THEN
1267 WSH_DEBUG_SV.logmsg(l_module_name, 'Process_Shipment_Advice completed with error');
1268 END IF;
1269 --
1270 x_return_status := l_return_status;
1271 FND_MESSAGE.Set_Name('WSH', 'WSH_SA_PROCESS_ERROR');
1272 wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
1273 raise FND_API.G_EXC_ERROR;
1274 END IF;
1275
1276 ELSIF p_process_mode = 'CONCURRENT' THEN
1277 --
1278 IF l_debug_on THEN
1279 WSH_DEBUG_SV.logmsg(l_module_name, 'Calling FND_REQUEST.SUBMIT_REQUEST', WSH_DEBUG_SV.C_PROC_LEVEL);
1280 END IF;
1281 --
1282 x_request_id := FND_REQUEST.SUBMIT_REQUEST(
1283 application => 'WSH',
1284 program => 'WSHSAINB',
1285 description => 'Process Shipment Advices',
1286 start_time => NULL,
1287 sub_request => FALSE,
1288 argument1 => p_transaction_status,
1289 argument2 => p_from_document_number,
1290 argument3 => p_to_document_number,
1291 argument4 => to_date(p_from_creation_date,'yy-mm-dd'),
1292 argument5 => to_date(p_to_creation_date,'yy-mm-dd'),
1293 argument6 => p_transaction_id,
1294 argument7 => p_log_level);
1295
1296 --
1297 IF l_debug_on THEN
1298 WSH_DEBUG_SV.log(l_module_name, 'Request Id returned from FND_REQUEST.SUBMIT_REQUEST', x_request_id);
1299 END IF;
1300 --
1301 IF (nvl(x_request_id,0) <= 0) THEN
1302 raise FND_API.G_EXC_ERROR;
1303 END IF;
1304 ELSE
1305 x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1306 fnd_message.set_name('WSH', 'WSH_OI_INVALID_ATTRIBUTE');
1307 fnd_message.set_token('ATTRIBUTE', 'PROCESS_MODE');
1308 wsh_util_core.add_message(x_return_status);
1309 IF l_debug_on THEN
1310 WSH_DEBUG_SV.logmsg(l_module_name, 'p_process_mode should be ONLINE/CONCURRENT');
1311 END IF;
1312 raise FND_API.G_EXC_ERROR;
1313 END IF;
1314
1315 IF p_commit = FND_API.G_TRUE THEN
1316 COMMIT;
1317 END IF;
1318
1319
1320 IF l_debug_on THEN
1321 wsh_debug_sv.pop(l_module_name);
1322 END IF;
1323 EXCEPTION
1324 WHEN FND_API.G_EXC_ERROR THEN
1325 x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1326 fnd_msg_pub.count_and_get(p_count => x_msg_count,
1327 p_data => x_msg_data,
1328 p_encoded => fnd_api.g_false);
1329 IF l_debug_on THEN
1330 WSH_DEBUG_SV.log(l_module_name, 'Error Processing Shipment Advice ');
1331 WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1332 END IF;
1333 WHEN OTHERS THEN
1334 x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1335 fnd_msg_pub.count_and_get(p_count => x_msg_count,
1336 p_data => x_msg_data,
1337 p_encoded => fnd_api.g_false);
1338 IF l_debug_on THEN
1339 WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1340 WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1341 END IF;
1342
1343 END Process_Shipment_Advice;
1344
1345 --========================================================================
1346 -- PROCEDURE : Debug_Shipment_Advice PRIVATE
1347 --
1348 -- PARAMETERS:
1349 -- p_delivery_rec
1350 --
1351 -- COMMENT : Reads all the inforamtion in 'p_delivery_rec' and writes to
1352 -- debug log file.
1353 --========================================================================
1354
1355
1356 PROCEDURE Debug_Shipment_Advice(
1357 p_delivery_rec IN Delivery_Rec_Type) IS
1358
1359 l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Debug_Shipment_Advice';
1360 BEGIN
1361
1362 WSH_DEBUG_SV.push(l_module_name);
1363 WSH_DEBUG_SV.logmsg(l_module_name,'Delivery Rec Information for document '||p_delivery_rec.document_number);
1364 WSH_DEBUG_SV.logmsg(l_module_name,'-------------------------------------------------------------------');
1365 WSH_DEBUG_SV.logmsg(l_module_name,'-------------------------------------------------------------------');
1366 WSH_DEBUG_SV.log(l_module_name,'document_number',p_delivery_rec.document_number);
1367 WSH_DEBUG_SV.log(l_module_name,'name',p_delivery_rec.name);
1368 WSH_DEBUG_SV.log(l_module_name,'organization_code',p_delivery_rec.organization_code);
1369 WSH_DEBUG_SV.log(l_module_name,'customer_name',p_delivery_rec.customer_name);
1370 WSH_DEBUG_SV.log(l_module_name,'delivered_date',p_delivery_rec.delivered_date);
1371 WSH_DEBUG_SV.log(l_module_name,'description',p_delivery_rec.description);
1372 WSH_DEBUG_SV.log(l_module_name,'shipment_direction',p_delivery_rec.shipment_direction);
1373 WSH_DEBUG_SV.log(l_module_name,'carrier_code',p_delivery_rec.carrier_code);
1374 WSH_DEBUG_SV.log(l_module_name,'fob_code',p_delivery_rec.fob_code);
1375 WSH_DEBUG_SV.log(l_module_name,'freight_terms_code',p_delivery_rec.freight_terms_code);
1376 WSH_DEBUG_SV.log(l_module_name,'gross_weight',p_delivery_rec.gross_weight);
1377 WSH_DEBUG_SV.log(l_module_name,'net_weight',p_delivery_rec.net_weight);
1378 WSH_DEBUG_SV.log(l_module_name,'weight_uom_code',p_delivery_rec.weight_uom_code);
1379 WSH_DEBUG_SV.log(l_module_name,'volume',p_delivery_rec.volume);
1380 WSH_DEBUG_SV.log(l_module_name,'volume_uom_code',p_delivery_rec.volume_uom_code);
1381 WSH_DEBUG_SV.log(l_module_name,'initial_pickup_date',p_delivery_rec.initial_pickup_date);
1382 WSH_DEBUG_SV.log(l_module_name,'loading_sequence',p_delivery_rec.loading_sequence);
1383 WSH_DEBUG_SV.log(l_module_name,'number_of_lpn',p_delivery_rec.number_of_lpn);
1384 WSH_DEBUG_SV.log(l_module_name,'shipping_marks',p_delivery_rec.shipping_marks);
1385 WSH_DEBUG_SV.log(l_module_name,'ultimate_dropoff_date',p_delivery_rec.ultimate_dropoff_date);
1386 WSH_DEBUG_SV.log(l_module_name,'waybill',p_delivery_rec.waybill);
1387 WSH_DEBUG_SV.log(l_module_name,'service_level',p_delivery_rec.service_level);
1388 WSH_DEBUG_SV.log(l_module_name,'mode_of_transport',p_delivery_rec.mode_of_transport);
1389 WSH_DEBUG_SV.log(l_module_name,'wv_frozen_flag',p_delivery_rec.wv_frozen_flag);
1390 WSH_DEBUG_SV.log(l_module_name,'attribute_category',p_delivery_rec.attribute_category);
1391 WSH_DEBUG_SV.log(l_module_name,'attribute1',p_delivery_rec.attribute1);
1392 WSH_DEBUG_SV.log(l_module_name,'attribute2',p_delivery_rec.attribute2);
1393 WSH_DEBUG_SV.log(l_module_name,'attribute3',p_delivery_rec.attribute3);
1394 WSH_DEBUG_SV.log(l_module_name,'attribute4',p_delivery_rec.attribute4);
1395 WSH_DEBUG_SV.log(l_module_name,'attribute5',p_delivery_rec.attribute5);
1396 WSH_DEBUG_SV.log(l_module_name,'attribute6',p_delivery_rec.attribute6);
1397 WSH_DEBUG_SV.log(l_module_name,'attribute7',p_delivery_rec.attribute7);
1398 WSH_DEBUG_SV.log(l_module_name,'attribute8',p_delivery_rec.attribute8);
1399 WSH_DEBUG_SV.log(l_module_name,'attribute9',p_delivery_rec.attribute9);
1400 WSH_DEBUG_SV.log(l_module_name,'attribute10',p_delivery_rec.attribute10);
1401 WSH_DEBUG_SV.log(l_module_name,'attribute11',p_delivery_rec.attribute11);
1402 WSH_DEBUG_SV.log(l_module_name,'attribute12',p_delivery_rec.attribute12);
1403 WSH_DEBUG_SV.log(l_module_name,'attribute13',p_delivery_rec.attribute13);
1404 WSH_DEBUG_SV.log(l_module_name,'attribute14',p_delivery_rec.attribute14);
1405 WSH_DEBUG_SV.log(l_module_name,'attribute15',p_delivery_rec.attribute15);
1406 WSH_DEBUG_SV.log(l_module_name,'SHIP_TO_CUSTOMER_NAME',p_delivery_rec.SHIP_TO_CUSTOMER_NAME);
1407 WSH_DEBUG_SV.log(l_module_name,'SHIP_TO_ADDRESS1',p_delivery_rec.SHIP_TO_ADDRESS1);
1408 WSH_DEBUG_SV.log(l_module_name,'SHIP_TO_ADDRESS2',p_delivery_rec.SHIP_TO_ADDRESS2);
1409 WSH_DEBUG_SV.log(l_module_name,'SHIP_TO_ADDRESS3',p_delivery_rec.SHIP_TO_ADDRESS3);
1410 WSH_DEBUG_SV.log(l_module_name,'SHIP_TO_ADDRESS4',p_delivery_rec.SHIP_TO_ADDRESS4);
1411 WSH_DEBUG_SV.log(l_module_name,'SHIP_TO_CITY',p_delivery_rec.SHIP_TO_CITY);
1412 WSH_DEBUG_SV.log(l_module_name,'SHIP_TO_STATE',p_delivery_rec.SHIP_TO_STATE);
1413 WSH_DEBUG_SV.log(l_module_name,'SHIP_TO_COUNTRY',p_delivery_rec.SHIP_TO_COUNTRY);
1414 WSH_DEBUG_SV.log(l_module_name,'SHIP_TO_POSTAL_CODE',p_delivery_rec.SHIP_TO_POSTAL_CODE);
1415 WSH_DEBUG_SV.logmsg(l_module_name,'-------------------------------------------------------------------');
1416
1417 WSH_DEBUG_SV.logmsg(l_module_name,' -------------------------------------------------------------------');
1418 WSH_DEBUG_SV.logmsg(l_module_name,' WSH_TRIP_STOPS_INTERFACE info');
1419 WSH_DEBUG_SV.log(l_module_name,' actual_departure_date',p_delivery_rec.actual_departure_date);
1420 WSH_DEBUG_SV.log(l_module_name,' actual_arrival_date',p_delivery_rec.actual_arrival_date);
1421 WSH_DEBUG_SV.log(l_module_name,' departure_seal_code',p_delivery_rec.departure_seal_code);
1422 WSH_DEBUG_SV.logmsg(l_module_name,' -------------------------------------------------------------------');
1423
1424 WSH_DEBUG_SV.logmsg(l_module_name,' -------------------------------------------------------------------');
1425 WSH_DEBUG_SV.logmsg(l_module_name,' WSH_TRIPS_INTERFACE info');
1426 WSH_DEBUG_SV.log(l_module_name,' vehicle_number',p_delivery_rec.vehicle_number);
1427 WSH_DEBUG_SV.log(l_module_name,' vehicle_num_prefix',p_delivery_rec.vehicle_num_prefix);
1428 WSH_DEBUG_SV.log(l_module_name,' route_id',p_delivery_rec.route_id);
1429 WSH_DEBUG_SV.log(l_module_name,' routing_instructions',p_delivery_rec.routing_instructions);
1430 WSH_DEBUG_SV.log(l_module_name,' operator',p_delivery_rec.operator);
1431 WSH_DEBUG_SV.logmsg(l_module_name,' -------------------------------------------------------------------');
1432
1433 WSH_DEBUG_SV.log(l_module_name,'p_delivery_rec.delivery_freight_tab.count',p_delivery_rec.delivery_freight_tab.count);
1434 --WSH_FREIGHT_COSTS_INTERFACE info
1435 IF p_delivery_rec.delivery_freight_tab.count > 0 THEN
1436 WSH_DEBUG_SV.logmsg(l_module_name,' WSH_FREIGHT_COSTS_INTERFACE info for the delivery');
1437 WSH_DEBUG_SV.logmsg(l_module_name,' -------------------------------------------------------------------');
1438 FOR k in 1..p_delivery_rec.delivery_freight_tab.count LOOP
1439 WSH_DEBUG_SV.log(l_module_name,' freight_cost_type_code',p_delivery_rec.delivery_freight_tab(k).freight_cost_type_code);
1440 WSH_DEBUG_SV.log(l_module_name,' unit_amount',p_delivery_rec.delivery_freight_tab(k).unit_amount);
1441 WSH_DEBUG_SV.log(l_module_name,' currency_code',p_delivery_rec.delivery_freight_tab(k).currency_code);
1442 WSH_DEBUG_SV.log(l_module_name,' attribute_category',p_delivery_rec.delivery_freight_tab(k).attribute_category);
1443 WSH_DEBUG_SV.log(l_module_name,' attribute1',p_delivery_rec.delivery_freight_tab(k).attribute1);
1444 WSH_DEBUG_SV.log(l_module_name,' attribute2',p_delivery_rec.delivery_freight_tab(k).attribute2);
1445 WSH_DEBUG_SV.log(l_module_name,' attribute3',p_delivery_rec.delivery_freight_tab(k).attribute3);
1446 WSH_DEBUG_SV.log(l_module_name,' attribute4',p_delivery_rec.delivery_freight_tab(k).attribute4);
1447 WSH_DEBUG_SV.log(l_module_name,' attribute5',p_delivery_rec.delivery_freight_tab(k).attribute5);
1448 WSH_DEBUG_SV.log(l_module_name,' attribute6',p_delivery_rec.delivery_freight_tab(k).attribute6);
1449 WSH_DEBUG_SV.log(l_module_name,' attribute7',p_delivery_rec.delivery_freight_tab(k).attribute7);
1450 WSH_DEBUG_SV.log(l_module_name,' attribute8',p_delivery_rec.delivery_freight_tab(k).attribute8);
1451 WSH_DEBUG_SV.log(l_module_name,' attribute9',p_delivery_rec.delivery_freight_tab(k).attribute9);
1452 WSH_DEBUG_SV.log(l_module_name,' attribute10',p_delivery_rec.delivery_freight_tab(k).attribute10);
1453 WSH_DEBUG_SV.log(l_module_name,' attribute11',p_delivery_rec.delivery_freight_tab(k).attribute11);
1454 WSH_DEBUG_SV.log(l_module_name,' attribute12',p_delivery_rec.delivery_freight_tab(k).attribute12);
1455 WSH_DEBUG_SV.log(l_module_name,' attribute13',p_delivery_rec.delivery_freight_tab(k).attribute13);
1456 WSH_DEBUG_SV.log(l_module_name,' attribute14',p_delivery_rec.delivery_freight_tab(k).attribute14);
1457 WSH_DEBUG_SV.log(l_module_name,' attribute15',p_delivery_rec.delivery_freight_tab(k).attribute15);
1458 END LOOP;
1459 END IF;
1460 WSH_DEBUG_SV.log(l_module_name,'delivery_details_tab.count',p_delivery_rec.delivery_details_tab.count);
1461 IF p_delivery_rec.delivery_details_tab.count > 0 THEN --Delivery details count
1462 --{
1463 WSH_DEBUG_SV.logmsg(l_module_name,' WSH_DEL_DETAILS_INTERFACE info for the delivery');
1464 WSH_DEBUG_SV.logmsg(l_module_name,' -------------------------------------------------------------------');
1465
1466 FOR I in 1..p_delivery_rec.delivery_details_tab.count LOOP
1467 --{
1468 WSH_DEBUG_SV.log(l_module_name,' delivery_detail_number',p_delivery_rec.delivery_details_tab(I).delivery_detail_number);
1469 WSH_DEBUG_SV.log(l_module_name,' source_line_id',p_delivery_rec.delivery_details_tab(I).source_line_id);
1470 WSH_DEBUG_SV.log(l_module_name,' source_header_number',p_delivery_rec.delivery_details_tab(I).source_header_number);
1471 WSH_DEBUG_SV.log(l_module_name,' item_number',p_delivery_rec.delivery_details_tab(I).item_number);
1472 WSH_DEBUG_SV.log(l_module_name,' item_description',p_delivery_rec.delivery_details_tab(I).item_description);
1473 WSH_DEBUG_SV.log(l_module_name,' line_direction',p_delivery_rec.delivery_details_tab(I).line_direction);
1474 WSH_DEBUG_SV.log(l_module_name,' gross_weight',p_delivery_rec.delivery_details_tab(I).gross_weight);
1475 WSH_DEBUG_SV.log(l_module_name,' net_weight',p_delivery_rec.delivery_details_tab(I).net_weight);
1476 WSH_DEBUG_SV.log(l_module_name,' weight_uom_code',p_delivery_rec.delivery_details_tab(I).weight_uom_code);
1477 WSH_DEBUG_SV.log(l_module_name,' volume',p_delivery_rec.delivery_details_tab(I).volume);
1478 WSH_DEBUG_SV.log(l_module_name,' volume_uom_code',p_delivery_rec.delivery_details_tab(I).volume_uom_code);
1479 WSH_DEBUG_SV.log(l_module_name,' wv_frozen_flag',p_delivery_rec.delivery_details_tab(I).wv_frozen_flag);
1480 WSH_DEBUG_SV.log(l_module_name,' requested_quantity',p_delivery_rec.delivery_details_tab(I).requested_quantity);
1481 WSH_DEBUG_SV.log(l_module_name,' requested_quantity_uom',p_delivery_rec.delivery_details_tab(I).requested_quantity_uom);
1482 WSH_DEBUG_SV.log(l_module_name,' shipped_quantity',p_delivery_rec.delivery_details_tab(I).shipped_quantity);
1483 WSH_DEBUG_SV.log(l_module_name,' cycle_count_quantity',p_delivery_rec.delivery_details_tab(I).cycle_count_quantity);
1484 WSH_DEBUG_SV.log(l_module_name,' subinventory',p_delivery_rec.delivery_details_tab(I).subinventory);
1485 WSH_DEBUG_SV.log(l_module_name,' locator_code',p_delivery_rec.delivery_details_tab(I).locator_code);
1486 WSH_DEBUG_SV.log(l_module_name,' lot_number',p_delivery_rec.delivery_details_tab(I).lot_number);
1487 WSH_DEBUG_SV.log(l_module_name,' revision',p_delivery_rec.delivery_details_tab(I).revision);
1488 WSH_DEBUG_SV.log(l_module_name,' serial_number',p_delivery_rec.delivery_details_tab(I).serial_number);
1489 WSH_DEBUG_SV.log(l_module_name,' to_serial_number',p_delivery_rec.delivery_details_tab(I).to_serial_number);
1490 WSH_DEBUG_SV.log(l_module_name,' load_seq_number',p_delivery_rec.delivery_details_tab(I).load_seq_number);
1491 WSH_DEBUG_SV.log(l_module_name,' preferred_grade',p_delivery_rec.delivery_details_tab(I).preferred_grade);
1492 WSH_DEBUG_SV.log(l_module_name,' attribute_category',p_delivery_rec.delivery_details_tab(I).attribute_category);
1493 WSH_DEBUG_SV.log(l_module_name,' attribute1',p_delivery_rec.delivery_details_tab(I).attribute1);
1494 WSH_DEBUG_SV.log(l_module_name,' attribute2',p_delivery_rec.delivery_details_tab(I).attribute2);
1495 WSH_DEBUG_SV.log(l_module_name,' attribute3',p_delivery_rec.delivery_details_tab(I).attribute3);
1496 WSH_DEBUG_SV.log(l_module_name,' attribute4',p_delivery_rec.delivery_details_tab(I).attribute4);
1497 WSH_DEBUG_SV.log(l_module_name,' attribute5',p_delivery_rec.delivery_details_tab(I).attribute5);
1498 WSH_DEBUG_SV.log(l_module_name,' attribute6',p_delivery_rec.delivery_details_tab(I).attribute6);
1499 WSH_DEBUG_SV.log(l_module_name,' attribute7',p_delivery_rec.delivery_details_tab(I).attribute7);
1500 WSH_DEBUG_SV.log(l_module_name,' attribute8',p_delivery_rec.delivery_details_tab(I).attribute8);
1501 WSH_DEBUG_SV.log(l_module_name,' attribute9',p_delivery_rec.delivery_details_tab(I).attribute9);
1502 WSH_DEBUG_SV.log(l_module_name,' attribute10',p_delivery_rec.delivery_details_tab(I).attribute10);
1503 WSH_DEBUG_SV.log(l_module_name,' attribute11',p_delivery_rec.delivery_details_tab(I).attribute11);
1504 WSH_DEBUG_SV.log(l_module_name,' attribute12',p_delivery_rec.delivery_details_tab(I).attribute12);
1505 WSH_DEBUG_SV.log(l_module_name,' attribute13',p_delivery_rec.delivery_details_tab(I).attribute13);
1506 WSH_DEBUG_SV.log(l_module_name,' attribute14',p_delivery_rec.delivery_details_tab(I).attribute14);
1507 WSH_DEBUG_SV.log(l_module_name,' attribute15',p_delivery_rec.delivery_details_tab(I).attribute15);
1508 WSH_DEBUG_SV.log(l_module_name,' parent_delivery_detail_number',p_delivery_rec.delivery_details_tab(I).parent_delivery_detail_number);
1509
1510 WSH_DEBUG_SV.log(l_module_name,' Detail_Freight_tab_count',p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab.count);
1511 IF p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab.count > 0 THEN
1512 WSH_DEBUG_SV.logmsg(l_module_name,' -----------------------------------------------------------');
1513 WSH_DEBUG_SV.logmsg(l_module_name,' ---------------Details Freight Cost Details----------------');
1514 FOR k in 1..p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab.count LOOP
1515
1516 WSH_DEBUG_SV.log(l_module_name,' freight_cost_type_code',p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab(k).freight_cost_type_code);
1517 WSH_DEBUG_SV.log(l_module_name,' unit_amount',p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab(k).unit_amount);
1518 WSH_DEBUG_SV.log(l_module_name,' currency_code',p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab(k).currency_code);
1519 WSH_DEBUG_SV.log(l_module_name,' attribute_category',p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab(k).attribute_category);
1520 WSH_DEBUG_SV.log(l_module_name,' attribute1',p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab(k).attribute1);
1521 WSH_DEBUG_SV.log(l_module_name,' attribute2',p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab(k).attribute2);
1522 WSH_DEBUG_SV.log(l_module_name,' attribute3',p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab(k).attribute3);
1523 WSH_DEBUG_SV.log(l_module_name,' attribute4',p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab(k).attribute4);
1524 WSH_DEBUG_SV.log(l_module_name,' attribute5',p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab(k).attribute5);
1525 WSH_DEBUG_SV.log(l_module_name,' attribute6',p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab(k).attribute6);
1526 WSH_DEBUG_SV.log(l_module_name,' attribute7',p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab(k).attribute7);
1527 WSH_DEBUG_SV.log(l_module_name,' attribute8',p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab(k).attribute8);
1528 WSH_DEBUG_SV.log(l_module_name,' attribute9',p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab(k).attribute9);
1529 WSH_DEBUG_SV.log(l_module_name,' attribute10',p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab(k).attribute10);
1530 WSH_DEBUG_SV.log(l_module_name,' attribute11',p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab(k).attribute11);
1531 WSH_DEBUG_SV.log(l_module_name,' attribute12',p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab(k).attribute12);
1532 WSH_DEBUG_SV.log(l_module_name,' attribute13',p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab(k).attribute13);
1533 WSH_DEBUG_SV.log(l_module_name,' attribute14',p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab(k).attribute14);
1534 WSH_DEBUG_SV.log(l_module_name,' attribute15',p_delivery_rec.delivery_details_tab(I).Detail_Freight_Tab(k).attribute15);
1535 WSH_DEBUG_SV.logmsg(l_module_name,' -----------------------------------------------------------');
1536 END LOOP;
1537 END IF;
1538 --}
1539 END LOOP;
1540 END IF;
1541
1542 WSH_DEBUG_SV.log(l_module_name,'Master_container_tab.count',p_delivery_rec.container_tab.count);
1543 IF p_delivery_rec.container_tab.count > 0 THEN --Delivery details count
1544 --{
1545 WSH_DEBUG_SV.logmsg(l_module_name,' -------------------------------------------------------------------');
1546 WSH_DEBUG_SV.logmsg(l_module_name,' WSH_DEL_DETAILS_INTERFACE(Master Containers) info for the delivery');
1547
1548 FOR I in 1..p_delivery_rec.container_tab.count LOOP
1549 --{
1550 WSH_DEBUG_SV.log(l_module_name,' delivery_detail_number',p_delivery_rec.container_tab(i).delivery_detail_number);
1551 WSH_DEBUG_SV.log(l_module_name,' attribute_category',p_delivery_rec.container_tab(i).attribute_category);
1552 WSH_DEBUG_SV.log(l_module_name,' attribute1',p_delivery_rec.container_tab(i).attribute1);
1553 WSH_DEBUG_SV.log(l_module_name,' attribute2',p_delivery_rec.container_tab(i).attribute2);
1554 WSH_DEBUG_SV.log(l_module_name,' attribute3',p_delivery_rec.container_tab(i).attribute3);
1555 WSH_DEBUG_SV.log(l_module_name,' attribute4',p_delivery_rec.container_tab(i).attribute4);
1556 WSH_DEBUG_SV.log(l_module_name,' attribute5',p_delivery_rec.container_tab(i).attribute5);
1557 WSH_DEBUG_SV.log(l_module_name,' attribute6',p_delivery_rec.container_tab(i).attribute6);
1558 WSH_DEBUG_SV.log(l_module_name,' attribute7',p_delivery_rec.container_tab(i).attribute7);
1559 WSH_DEBUG_SV.log(l_module_name,' attribute8',p_delivery_rec.container_tab(i).attribute8);
1560 WSH_DEBUG_SV.log(l_module_name,' attribute9',p_delivery_rec.container_tab(i).attribute9);
1561 WSH_DEBUG_SV.log(l_module_name,' attribute10',p_delivery_rec.container_tab(i).attribute10);
1562 WSH_DEBUG_SV.log(l_module_name,' attribute11',p_delivery_rec.container_tab(i).attribute11);
1563 WSH_DEBUG_SV.log(l_module_name,' attribute12',p_delivery_rec.container_tab(i).attribute12);
1564 WSH_DEBUG_SV.log(l_module_name,' attribute13',p_delivery_rec.container_tab(i).attribute13);
1565 WSH_DEBUG_SV.log(l_module_name,' attribute14',p_delivery_rec.container_tab(i).attribute14);
1566 WSH_DEBUG_SV.log(l_module_name,' attribute15',p_delivery_rec.container_tab(i).attribute15);
1567 WSH_DEBUG_SV.log(l_module_name,' container_name ',p_delivery_rec.container_tab(i).container_name );
1568 WSH_DEBUG_SV.log(l_module_name,' item_number',p_delivery_rec.container_tab(i).item_number);
1569 WSH_DEBUG_SV.log(l_module_name,' item_description',p_delivery_rec.container_tab(i).item_description);
1570 WSH_DEBUG_SV.log(l_module_name,' gross_weight',p_delivery_rec.container_tab(i).gross_weight);
1571 WSH_DEBUG_SV.log(l_module_name,' net_weight',p_delivery_rec.container_tab(i).net_weight);
1572 WSH_DEBUG_SV.log(l_module_name,' weight_uom_code',p_delivery_rec.container_tab(i).weight_uom_code);
1573 WSH_DEBUG_SV.log(l_module_name,' volume',p_delivery_rec.container_tab(i).volume);
1574 WSH_DEBUG_SV.log(l_module_name,' volume_uom_code',p_delivery_rec.container_tab(i).volume_uom_code);
1575 WSH_DEBUG_SV.log(l_module_name,' wv_frozen_flag',p_delivery_rec.container_tab(i).wv_frozen_flag);
1576 WSH_DEBUG_SV.log(l_module_name,' filled_volume',p_delivery_rec.container_tab(i).filled_volume);
1577 WSH_DEBUG_SV.log(l_module_name,' fill_percent',p_delivery_rec.container_tab(i).fill_percent);
1578 WSH_DEBUG_SV.log(l_module_name,' seal_code',p_delivery_rec.container_tab(i).seal_code);
1579 WSH_DEBUG_SV.log(l_module_name,' packing_instructions',p_delivery_rec.container_tab(i).packing_instructions);
1580 WSH_DEBUG_SV.log(l_module_name,' shipping_instructions',p_delivery_rec.container_tab(i).shipping_instructions);
1581 WSH_DEBUG_SV.log(l_module_name,' tracking_number',p_delivery_rec.container_tab(i).tracking_number);
1582 WSH_DEBUG_SV.logmsg(l_module_name,' -------------------------------------------------------------------');
1583 WSH_DEBUG_SV.log(l_module_name,' Master_Container_Freight_Tab.count',p_delivery_rec.container_tab(i).Master_Container_Freight_Tab.count);
1584 IF p_delivery_rec.container_tab(i).Master_Container_Freight_Tab.count >0 THEN
1585 WSH_DEBUG_SV.logmsg(l_module_name,' -------------------------------------------------------------------');
1586 WSH_DEBUG_SV.logmsg(l_module_name,' Master_Container_Freight_Tab Details');
1587 WSH_DEBUG_SV.logmsg(l_module_name,' -------------------------------------------------------------------');
1588
1589 FOR K in 1..p_delivery_rec.container_tab(i).Master_Container_Freight_Tab.count LOOP
1590 WSH_DEBUG_SV.log(l_module_name,' freight_cost_type_code',p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(K).freight_cost_type_code);
1591 WSH_DEBUG_SV.log(l_module_name,' unit_amount ',p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(K).unit_amount );
1592 WSH_DEBUG_SV.log(l_module_name,' currency_code',p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(K).currency_code);
1593 WSH_DEBUG_SV.log(l_module_name,' attribute_category',p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(K).attribute_category);
1594 WSH_DEBUG_SV.log(l_module_name,' attribute1',p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(K).attribute1);
1595 WSH_DEBUG_SV.log(l_module_name,' attribute2',p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(K).attribute2);
1596 WSH_DEBUG_SV.log(l_module_name,' attribute3',p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(K).attribute3);
1597 WSH_DEBUG_SV.log(l_module_name,' attribute4',p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(K).attribute4);
1598 WSH_DEBUG_SV.log(l_module_name,' attribute5',p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(K).attribute5);
1599 WSH_DEBUG_SV.log(l_module_name,' attribute6',p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(K).attribute6);
1600 WSH_DEBUG_SV.log(l_module_name,' attribute7',p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(K).attribute7);
1601 WSH_DEBUG_SV.log(l_module_name,' attribute8',p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(K).attribute8);
1602 WSH_DEBUG_SV.log(l_module_name,' attribute9',p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(K).attribute9);
1603 WSH_DEBUG_SV.log(l_module_name,' attribute10',p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(K).attribute10);
1604 WSH_DEBUG_SV.log(l_module_name,' attribute11',p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(K).attribute11);
1605 WSH_DEBUG_SV.log(l_module_name,' attribute12',p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(K).attribute12);
1606 WSH_DEBUG_SV.log(l_module_name,' attribute13',p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(K).attribute13);
1607 WSH_DEBUG_SV.log(l_module_name,' attribute14',p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(K).attribute14);
1608 WSH_DEBUG_SV.log(l_module_name,' attribute15',p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(K).attribute15);
1609 WSH_DEBUG_SV.log(l_module_name,' unit_amount ',p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(K).unit_amount );
1610 WSH_DEBUG_SV.log(l_module_name,' currency_code',p_delivery_rec.container_tab(i).Master_Container_Freight_Tab(K).currency_code);
1611 WSH_DEBUG_SV.logmsg(l_module_name,' -------------------------------------------------------------------');
1612 END LOOP;
1613 END IF;
1614
1615 WSH_DEBUG_SV.log(l_module_name,' ',p_delivery_rec.container_tab(i).Container_Tab.count);
1616
1617 IF p_delivery_rec.container_tab(i).Container_Tab.count >0 THEN
1618 WSH_DEBUG_SV.logmsg(l_module_name,' -------------------------------------------------------------------');
1619 WSH_DEBUG_SV.logmsg(l_module_name,' Inner Containers Details');
1620 WSH_DEBUG_SV.logmsg(l_module_name,' -------------------------------------------------------------------');
1621
1622 FOR K in 1..p_delivery_rec.container_tab(i).Container_Tab.count LOOP
1623 WSH_DEBUG_SV.log(l_module_name,' delivery_detail_number',p_delivery_rec.container_tab(i).container_tab(k).delivery_detail_number);
1624 WSH_DEBUG_SV.log(l_module_name,' attribute_category',p_delivery_rec.container_tab(i).container_tab(k).attribute_category);
1625 WSH_DEBUG_SV.log(l_module_name,' attribute1',p_delivery_rec.container_tab(i).container_tab(k).attribute1);
1626 WSH_DEBUG_SV.log(l_module_name,' attribute2',p_delivery_rec.container_tab(i).container_tab(k).attribute2);
1627 WSH_DEBUG_SV.log(l_module_name,' attribute3',p_delivery_rec.container_tab(i).container_tab(k).attribute3);
1628 WSH_DEBUG_SV.log(l_module_name,' attribute4',p_delivery_rec.container_tab(i).container_tab(k).attribute4);
1629 WSH_DEBUG_SV.log(l_module_name,' attribute5',p_delivery_rec.container_tab(i).container_tab(k).attribute5);
1630 WSH_DEBUG_SV.log(l_module_name,' attribute6',p_delivery_rec.container_tab(i).container_tab(k).attribute6);
1631 WSH_DEBUG_SV.log(l_module_name,' attribute7',p_delivery_rec.container_tab(i).container_tab(k).attribute7);
1632 WSH_DEBUG_SV.log(l_module_name,' attribute8',p_delivery_rec.container_tab(i).container_tab(k).attribute8);
1633 WSH_DEBUG_SV.log(l_module_name,' attribute9',p_delivery_rec.container_tab(i).container_tab(k).attribute9);
1634 WSH_DEBUG_SV.log(l_module_name,' attribute10',p_delivery_rec.container_tab(i).container_tab(k).attribute10);
1635 WSH_DEBUG_SV.log(l_module_name,' attribute11',p_delivery_rec.container_tab(i).container_tab(k).attribute11);
1636 WSH_DEBUG_SV.log(l_module_name,' attribute12',p_delivery_rec.container_tab(i).container_tab(k).attribute12);
1637 WSH_DEBUG_SV.log(l_module_name,' attribute13',p_delivery_rec.container_tab(i).container_tab(k).attribute13);
1638 WSH_DEBUG_SV.log(l_module_name,' attribute14',p_delivery_rec.container_tab(i).container_tab(k).attribute14);
1639 WSH_DEBUG_SV.log(l_module_name,' attribute15',p_delivery_rec.container_tab(i).container_tab(k).attribute15);
1640 WSH_DEBUG_SV.log(l_module_name,' container_name ',p_delivery_rec.container_tab(i).container_tab(k).container_name );
1641 WSH_DEBUG_SV.log(l_module_name,' item_number',p_delivery_rec.container_tab(i).container_tab(k).item_number);
1642 WSH_DEBUG_SV.log(l_module_name,' item_description',p_delivery_rec.container_tab(i).container_tab(k).item_description);
1643 WSH_DEBUG_SV.log(l_module_name,' gross_weight',p_delivery_rec.container_tab(i).container_tab(k).gross_weight);
1644 WSH_DEBUG_SV.log(l_module_name,' net_weight',p_delivery_rec.container_tab(i).container_tab(k).net_weight);
1645 WSH_DEBUG_SV.log(l_module_name,' weight_uom_code',p_delivery_rec.container_tab(i).container_tab(k).weight_uom_code);
1646 WSH_DEBUG_SV.log(l_module_name,' volume',p_delivery_rec.container_tab(i).container_tab(k).volume);
1647 WSH_DEBUG_SV.log(l_module_name,' volume_uom_code',p_delivery_rec.container_tab(i).container_tab(k).volume_uom_code);
1648 WSH_DEBUG_SV.log(l_module_name,' wv_frozen_flag',p_delivery_rec.container_tab(i).container_tab(k).wv_frozen_flag);
1649 WSH_DEBUG_SV.log(l_module_name,' filled_volume',p_delivery_rec.container_tab(i).container_tab(k).filled_volume);
1650 WSH_DEBUG_SV.log(l_module_name,' fill_percent',p_delivery_rec.container_tab(i).container_tab(k).fill_percent);
1651 WSH_DEBUG_SV.log(l_module_name,' seal_code',p_delivery_rec.container_tab(i).container_tab(k).seal_code);
1652 WSH_DEBUG_SV.log(l_module_name,' packing_instructions',p_delivery_rec.container_tab(i).container_tab(k).packing_instructions);
1653 WSH_DEBUG_SV.log(l_module_name,' shipping_instructions',p_delivery_rec.container_tab(i).container_tab(k).shipping_instructions);
1654 WSH_DEBUG_SV.log(l_module_name,' tracking_number',p_delivery_rec.container_tab(i).container_tab(k).tracking_number);
1655 WSH_DEBUG_SV.logmsg(l_module_name,' -------------------------------------------------------------------');
1656
1657 WSH_DEBUG_SV.log(l_module_name,' Inner Container Freight costs.count',p_delivery_rec.container_tab(i).container_tab(k).Container_Freight_Tab.count);
1658 IF p_delivery_rec.container_tab(i).container_tab(k).Container_Freight_Tab.count >0 THEN
1659 WSH_DEBUG_SV.logmsg(l_module_name,' -------------------------------------------------------------------');
1660 WSH_DEBUG_SV.logmsg(l_module_name,' Inner Container Freight costs Details');
1661 WSH_DEBUG_SV.logmsg(l_module_name,' -------------------------------------------------------------------');
1662
1663 FOR l in 1..p_delivery_rec.container_tab(i).container_tab(k).Container_Freight_Tab.count LOOP
1664 WSH_DEBUG_SV.log(l_module_name,' freight_cost_type_code',p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).freight_cost_type_code);
1665 WSH_DEBUG_SV.log(l_module_name,' unit_amount ',p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).unit_amount );
1666 WSH_DEBUG_SV.log(l_module_name,' currency_code',p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).currency_code);
1667 WSH_DEBUG_SV.log(l_module_name,' attribute_category',p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).attribute_category);
1668 WSH_DEBUG_SV.log(l_module_name,' attribute1',p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).attribute1);
1669 WSH_DEBUG_SV.log(l_module_name,' attribute2',p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).attribute2);
1670 WSH_DEBUG_SV.log(l_module_name,' attribute3',p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).attribute3);
1671 WSH_DEBUG_SV.log(l_module_name,' attribute4',p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).attribute4);
1672 WSH_DEBUG_SV.log(l_module_name,' attribute5',p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).attribute5);
1673 WSH_DEBUG_SV.log(l_module_name,' attribute6',p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).attribute6);
1674 WSH_DEBUG_SV.log(l_module_name,' attribute7',p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).attribute7);
1675 WSH_DEBUG_SV.log(l_module_name,' attribute8',p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).attribute8);
1676 WSH_DEBUG_SV.log(l_module_name,' attribute9',p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).attribute9);
1677 WSH_DEBUG_SV.log(l_module_name,' attribute10',p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).attribute10);
1678 WSH_DEBUG_SV.log(l_module_name,' attribute11',p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).attribute11);
1679 WSH_DEBUG_SV.log(l_module_name,' attribute12',p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).attribute12);
1680 WSH_DEBUG_SV.log(l_module_name,' attribute13',p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).attribute13);
1681 WSH_DEBUG_SV.log(l_module_name,' attribute14',p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).attribute14);
1682 WSH_DEBUG_SV.log(l_module_name,' attribute15',p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).attribute15);
1683 WSH_DEBUG_SV.log(l_module_name,' unit_amount ',p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).unit_amount );
1684 WSH_DEBUG_SV.log(l_module_name,' currency_code',p_delivery_rec.container_tab(i).Container_Tab(k).Container_Freight_Tab(l).currency_code);
1685 WSH_DEBUG_SV.logmsg(l_module_name,' -------------------------------------------------------------------');
1686 END LOOP;
1687 END IF;
1688 END LOOP;
1689 END IF;
1690
1691 --}
1692 END LOOP;
1693 END IF;
1694 wsh_debug_sv.pop(l_module_name);
1695 EXCEPTION
1696 WHEN OTHERS THEN
1697 WSH_DEBUG_SV.logmsg(l_module_name,'Error in '||l_module_name, WSH_DEBUG_SV.C_STMT_LEVEL);
1698 WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1699 wsh_debug_sv.pop(l_module_name);
1700
1701 END Debug_Shipment_Advice;
1702
1703
1704 END WSH_SHIPMENT_ADVICE_PUB;
1705