APPS.WSH_SHIPMENT_ADVICE_PUB dependencies on WSH_DEL_DETAILS_INTERFACE

Line 157: l_del_detail_interface_id WSH_DEL_DETAILS_INTERFACE.delivery_detail_interface_id%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;

Line 437: wsh_debug_sv.logmsg(l_module_name, 'Inserting Rec'||i||' into WSH_DEL_DETAILS_INTERFACE (validating source_line_id)');

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;

Line 450: INSERT INTO WSH_DEL_DETAILS_INTERFACE(

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,

Line 507: wsh_del_details_interface_s.nextval,

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,

Line 657: INSERT INTO WSH_DEL_DETAILS_INTERFACE(

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,

Line 703: wsh_del_details_interface_s.nextval,

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,

Line 839: INSERT INTO WSH_DEL_DETAILS_INTERFACE(

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,

Line 885: wsh_del_details_interface_s.nextval,

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,

Line 1463: WSH_DEBUG_SV.logmsg(l_module_name,' WSH_DEL_DETAILS_INTERFACE info for the delivery');

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: --{

Line 1546: WSH_DEBUG_SV.logmsg(l_module_name,' WSH_DEL_DETAILS_INTERFACE(Master Containers) info for the delivery');

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);