eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_SHIP_CONFIRM_ACTIONS2 dependencies on WSH_DELIVERY_DETAILS

Line 38: from wsh_delivery_details

34: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_LINE_ID',P_SOURCE_LINE_ID);
35: END IF;
36: --
37: select count(*) into l_count
38: from wsh_delivery_details
39: where ship_set_id is not null
40: and source_line_id = p_source_line_id
41: and NVL(line_direction, 'O') IN ('O', 'IO') -- J Inbound Logistics Changes jckwok
42: and NVL(container_flag,'N') = 'N';

Line 186: FROM wsh_delivery_Details dd,

182: SELECT shipped_quantity
183: ,shipped_quantity2 -- OPM KYH 12/SEP/00
184: , dd.source_line_id
185: , dl.status_code
186: FROM wsh_delivery_Details dd,
187: wsh_delivery_assignments_v da ,
188: wsh_delivery_legs dg,
189: wsh_new_deliveries dl,
190: wsh_trip_stops st

Line 352: FROM wsh_delivery_details

348: serial_number,
349: transaction_temp_id,
350: subinventory,
351: client_id -- LSP PROJECT : Required to check whether order is for LSP
352: FROM wsh_delivery_details
353: WHERE delivery_detail_id = x_detail_id AND
354: NVL(container_flag, 'N') = 'N';
355: l_detail_rec c_detail%ROWTYPE;
356:

Line 420: wsh_delivery_details wdd,

416: wnd.planned_flag,
417: wdd.source_code,
418: wdd.source_line_id
419: FROM wsh_new_deliveries wnd,
420: wsh_delivery_details wdd,
421: wsh_delivery_assignments_v wda
422: WHERE wdd.delivery_detail_id = c_delivery_detail_id
423: AND wda.delivery_id = wnd.delivery_id (+)
424: AND wda.delivery_detail_id = wdd.delivery_detail_id ;

Line 443: l_inv_controls_rec WSH_DELIVERY_DETAILS_INV.inv_control_flag_rec;

439: l_bo_qty2 NUMBER ;
440: l_unassign_dds WSH_UTIL_CORE.Id_Tab_Type ;
441: l_unassign_dds_tmp WSH_UTIL_CORE.Id_Tab_Type ; -- bug 7460785
442: l_delete_dds WSH_UTIL_CORE.Id_Tab_Type ; -- to delete overpicked delivery lines
443: l_inv_controls_rec WSH_DELIVERY_DETAILS_INV.inv_control_flag_rec;
444:
445: invalid_source_code EXCEPTION; /*Bug 2096052- added for OKE */
446: no_backorder_full EXCEPTION; /*Bug 2399729- added for third party warehouse shipment line */
447: l_backorder_all VARCHAR2(1) := 'N'; /* Bug 2399729 */

Line 488: l_cons_source_line_rec_tab WSH_DELIVERY_DETAILS_ACTIONS.Cons_Source_Line_Rec_Tab;

484: l_remain_bo_qtys WSH_UTIL_CORE.Id_Tab_Type ; --Stores the remaining bo qty returned by Consolidate_Delivery_details
485: -- HW OPM BUG#:3121616 added qty2s
486: l_remain_bo_qty2s WSH_UTIL_CORE.Id_Tab_Type ; --Stores the remaining bo qty2 returned by Consolidate_Delivery_details
487: -- end of 3121616
488: l_cons_source_line_rec_tab WSH_DELIVERY_DETAILS_ACTIONS.Cons_Source_Line_Rec_Tab;
489: l_dd_rec_tab WSH_DELIVERY_DETAILS_ACTIONS.Cons_Source_Line_Rec_Tab;
490: l_cons_dd_rec_tab WSH_DELIVERY_DETAILS_ACTIONS.Cons_Source_Line_Rec_Tab;
491: k NUMBER;
492:

Line 489: l_dd_rec_tab WSH_DELIVERY_DETAILS_ACTIONS.Cons_Source_Line_Rec_Tab;

485: -- HW OPM BUG#:3121616 added qty2s
486: l_remain_bo_qty2s WSH_UTIL_CORE.Id_Tab_Type ; --Stores the remaining bo qty2 returned by Consolidate_Delivery_details
487: -- end of 3121616
488: l_cons_source_line_rec_tab WSH_DELIVERY_DETAILS_ACTIONS.Cons_Source_Line_Rec_Tab;
489: l_dd_rec_tab WSH_DELIVERY_DETAILS_ACTIONS.Cons_Source_Line_Rec_Tab;
490: l_cons_dd_rec_tab WSH_DELIVERY_DETAILS_ACTIONS.Cons_Source_Line_Rec_Tab;
491: k NUMBER;
492:
493: l_dd_txn_id NUMBER; --DBI

Line 490: l_cons_dd_rec_tab WSH_DELIVERY_DETAILS_ACTIONS.Cons_Source_Line_Rec_Tab;

486: l_remain_bo_qty2s WSH_UTIL_CORE.Id_Tab_Type ; --Stores the remaining bo qty2 returned by Consolidate_Delivery_details
487: -- end of 3121616
488: l_cons_source_line_rec_tab WSH_DELIVERY_DETAILS_ACTIONS.Cons_Source_Line_Rec_Tab;
489: l_dd_rec_tab WSH_DELIVERY_DETAILS_ACTIONS.Cons_Source_Line_Rec_Tab;
490: l_cons_dd_rec_tab WSH_DELIVERY_DETAILS_ACTIONS.Cons_Source_Line_Rec_Tab;
491: k NUMBER;
492:
493: l_dd_txn_id NUMBER; --DBI
494: l_txn_return_status VARCHAR2(1); --DBI

Line 499: SELECT organization_id from wsh_delivery_details

495: --
496:
497: -- HW 3457369
498: CURSOR find_org_id (l_delivery_detail_id NUMBER ) IS
499: SELECT organization_id from wsh_delivery_details
500: WHERE delivery_detail_id = l_delivery_detail_id
501: AND NVL(container_flag, 'N') = 'N';
502:
503: l_organization_id NUMBER;

Line 509: FROM oe_order_lines_all oelines, wsh_delivery_details wdd

505:
506: --Begin OPM Bug 3561937
507: CURSOR get_pref_grade(wdd_id NUMBER) IS
508: SELECT oelines.preferred_grade
509: FROM oe_order_lines_all oelines, wsh_delivery_details wdd
510: WHERE wdd.delivery_detail_id = wdd_id
511: AND wdd.source_code = 'OE'
512: AND wdd.source_line_id = oelines.line_id;
513:

Line 536: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;

532: l_msg_count NUMBER;
533: l_msg_data VARCHAR2(32767);
534: e_return_excp EXCEPTION;
535: -- K LPN CONV. rv
536: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;
537: --
538: --
539: l_unassign_dd_flag VARCHAR2(1) := 'N';
540: l_planned_flag VARCHAR2(1); -- bug# 6908504 (replenishment project)

Line 599: wsh_util_core.add_message(l_return_status,'WSH_DELIVERY_DETAILS_ACTIONS.Consolidate_Delivery_Details');

595: END IF;
596: --
597: WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters(l_global_param_rec, l_return_status);
598: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
599: wsh_util_core.add_message(l_return_status,'WSH_DELIVERY_DETAILS_ACTIONS.Consolidate_Delivery_Details');
600: x_return_status := l_return_status;
601: RAISE backorder_error;
602: END IF;
603:

Line 640: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.Consolidate_Delivery_Details',WSH_DEBUG_SV.C_PROC_LEVEL);

636: --
637: -- Debug Statements
638: --
639: IF l_debug_on THEN
640: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.Consolidate_Delivery_Details',WSH_DEBUG_SV.C_PROC_LEVEL);
641: END IF;
642: --
643: -- HW OPM BUG#:3121616 Added x_remain_bo_qty2s
644: WSH_DELIVERY_DETAILS_ACTIONS.Consolidate_Delivery_Details(

Line 644: WSH_DELIVERY_DETAILS_ACTIONS.Consolidate_Delivery_Details(

640: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.Consolidate_Delivery_Details',WSH_DEBUG_SV.C_PROC_LEVEL);
641: END IF;
642: --
643: -- HW OPM BUG#:3121616 Added x_remain_bo_qty2s
644: WSH_DELIVERY_DETAILS_ACTIONS.Consolidate_Delivery_Details(
645: p_delivery_details_tab => l_dd_rec_tab,
646: p_bo_mode => p_bo_mode,
647: x_cons_delivery_details_tab => l_cons_dd_rec_tab,
648: x_remain_bo_qtys => l_remain_bo_qtys,

Line 654: wsh_util_core.add_message(l_return_status,'WSH_DELIVERY_DETAILS_ACTIONS.Consolidate_Delivery_Details');

650: x_return_status => l_return_status
651: );
652: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
653: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
654: wsh_util_core.add_message(l_return_status,'WSH_DELIVERY_DETAILS_ACTIONS.Consolidate_Delivery_Details');
655: x_return_status := l_return_status;
656: RAISE backorder_error;
657: END IF;
658:

Line 775: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.SPLIT_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);

771: --
772: -- Debug Statements
773: --
774: IF l_debug_on THEN
775: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.SPLIT_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
776: END IF;
777: --
778: wsh_delivery_details_actions.split_delivery_details(
779: p_from_detail_id => l_detail_ids(i),

Line 778: wsh_delivery_details_actions.split_delivery_details(

774: IF l_debug_on THEN
775: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.SPLIT_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
776: END IF;
777: --
778: wsh_delivery_details_actions.split_delivery_details(
779: p_from_detail_id => l_detail_ids(i),
780: p_req_quantity => l_bo_qty,
781: x_new_detail_id => l_bo_detail_id,
782: x_return_status => l_return_status ,

Line 808: and WSH_DELIVERY_DETAILS_INV.Get_item_information procedure. */

804:
805: END IF;
806:
807: /*Bug 5525314 moved up the open cursor c_detail
808: and WSH_DELIVERY_DETAILS_INV.Get_item_information procedure. */
809: /* H integration: 940/945 look up source code before unassigning wrudge*/
810: OPEN c_detail(l_bo_detail_id );
811: FETCH c_detail INTO l_detail_rec;
812: CLOSE c_detail;

Line 831: WSH_DELIVERY_DETAILS_INV.Get_item_information

827: IF l_detail_rec.released_status = 'Y' THEN
828: -- call this API only if line is staged, so we can test lot
829: -- divisibility.
830:
831: WSH_DELIVERY_DETAILS_INV.Get_item_information
832: (
833: p_organization_id => l_detail_rec.organization_id,
834: p_inventory_item_id => l_detail_rec.inventory_item_id,
835: x_mtl_system_items_rec => l_item_info,

Line 889: UPDATE wsh_delivery_details

885: l_new_picked_quantity := l_detail_rec.picked_quantity ;
886: l_new_picked_quantity2 := l_detail_rec.picked_quantity2 ;
887: END IF;
888: ELSE
889: UPDATE wsh_delivery_details
890: SET picked_quantity = picked_quantity - l_overpick_qtys(i),
891: picked_quantity2 = picked_quantity2 - l_overpick_qty2s(i) -- muom
892: WHERE l_detail_ids(i) = delivery_detail_id
893: -- muom

Line 977: l_reserved_flag :=WSH_DELIVERY_DETAILS_INV.LINE_RESERVED(

973: -- then mark it as deleted.
974: l_delete_dds( l_delete_dds.count+1 ) := l_detail_ids(i);
975: END IF;
976: -- bug 1672188: unreserve if the detail is reserved
977: l_reserved_flag :=WSH_DELIVERY_DETAILS_INV.LINE_RESERVED(
978: p_detail_id => l_detail_rec.delivery_detail_id,
979: p_source_code => l_detail_rec.source_code,
980: p_released_status => l_detail_rec.released_status,
981: p_pickable_flag => l_detail_rec.pickable_flag,

Line 1038: l_qty WSH_DELIVERY_DETAILS.REQUESTED_QUANTITY%TYPE;

1034: l_item_info.lot_control_code = 2 ) THEN --{ lot divisibility
1035:
1036: DECLARE --{ lot indivisible reservation block
1037: l_bo_mode VARCHAR2(30);
1038: l_qty WSH_DELIVERY_DETAILS.REQUESTED_QUANTITY%TYPE;
1039: l_qty2 WSH_DELIVERY_DETAILS.REQUESTED_QUANTITY2%TYPE;
1040: BEGIN
1041:
1042: l_bo_mode := p_bo_mode;

Line 1039: l_qty2 WSH_DELIVERY_DETAILS.REQUESTED_QUANTITY2%TYPE;

1035:
1036: DECLARE --{ lot indivisible reservation block
1037: l_bo_mode VARCHAR2(30);
1038: l_qty WSH_DELIVERY_DETAILS.REQUESTED_QUANTITY%TYPE;
1039: l_qty2 WSH_DELIVERY_DETAILS.REQUESTED_QUANTITY2%TYPE;
1040: BEGIN
1041:
1042: l_bo_mode := p_bo_mode;
1043: IF l_bo_mode = 'RETAIN_RSV' THEN

Line 1064: WSH_DELIVERY_DETAILS_ACTIONS.UNRESERVE_DELIVERY_DETAIL(

1060: -- muom
1061: IF (l_fulfillment_base(i) = 'P' AND ((l_bo_qtys(i) > 0 AND l_detail_rec.requested_quantity >0) OR (l_bo_qtys(i) = 0 AND l_detail_rec.requested_quantity = 0))) OR
1062: (l_fulfillment_base(i) = 'S' AND ((l_bo_qty2s(i) > 0 AND l_detail_rec.requested_quantity2 >0) OR (l_bo_qty2s(i) = 0 AND l_detail_rec.requested_quantity2 = 0)))
1063: THEN
1064: WSH_DELIVERY_DETAILS_ACTIONS.UNRESERVE_DELIVERY_DETAIL(
1065: p_delivery_Detail_id => l_detail_ids(i),
1066: p_unreserve_mode => l_bo_mode ,
1067: p_quantity_to_unreserve => l_qty,
1068: p_quantity2_to_unreserve => l_qty2,

Line 1103: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.UNRESERVE_DELIVERY_DETAIL FOR OVERPICK QTY',WSH_DEBUG_SV.C_PROC_LEVEL);

1099: -- Bug 2824748: Call unreserve_delivery_detail with p_override_retain_ato_rsv 'Y' so that the
1100: -- reservations for unused overpick qty are always removed
1101: IF (l_fulfillment_base(i) = 'P' and l_overpick_qtys(i) > 0) OR (l_fulfillment_base(i) = 'S' and l_overpick_qty2s(i) > 0) THEN
1102: IF l_debug_on THEN
1103: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.UNRESERVE_DELIVERY_DETAIL FOR OVERPICK QTY',WSH_DEBUG_SV.C_PROC_LEVEL);
1104: END IF;
1105: --
1106: -- HW OPMCONV - Added Qty2
1107:

Line 1112: wsh_delivery_details_actions.unreserve_delivery_detail(

1108: --Bug 4721577 Do not retain reservation for overpicked quantities
1109: IF p_bo_mode = 'RETAIN_RSV' THEN
1110: -- muom
1111: IF l_fulfillment_base(i) = 'P' THEN
1112: wsh_delivery_details_actions.unreserve_delivery_detail(
1113: p_delivery_Detail_id => l_detail_ids(i),
1114: p_unreserve_mode => 'UNRESERVE' ,
1115: p_quantity_to_unreserve => l_overpick_qtys(i),
1116: p_override_retain_ato_rsv => 'Y',

Line 1119: wsh_delivery_details_actions.unreserve_delivery_detail(

1115: p_quantity_to_unreserve => l_overpick_qtys(i),
1116: p_override_retain_ato_rsv => 'Y',
1117: x_return_status => l_return_status );
1118: ELSE
1119: wsh_delivery_details_actions.unreserve_delivery_detail(
1120: p_delivery_Detail_id => l_detail_ids(i),
1121: p_unreserve_mode => 'UNRESERVE' ,
1122: p_quantity_to_unreserve => l_overpick_qtys(i),
1123: p_quantity2_to_unreserve => l_overpick_qty2s(i),

Line 1128: wsh_delivery_details_actions.unreserve_delivery_detail(

1124: p_override_retain_ato_rsv => 'Y',
1125: x_return_status => l_return_status );
1126: END IF;
1127: ELSE
1128: wsh_delivery_details_actions.unreserve_delivery_detail(
1129: p_delivery_Detail_id => l_detail_ids(i),
1130: p_unreserve_mode => p_bo_mode ,
1131: p_quantity_to_unreserve => l_overpick_qtys(i),
1132: -- muom: Changed from p_overpick_qtys2 to l_overpick_qty2s as the index on p_overpick_qtys2

Line 1171: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.UNRESERVE_DELIVERY_DETAIL FOR BO QTY',WSH_DEBUG_SV.C_PROC_LEVEL);

1167: -- reservations for backorder qty are removed depending on the ATO profile option
1168: -- muom
1169: IF (l_fulfillment_base(i) = 'P' and l_bo_qtys(i) > 0) OR (l_fulfillment_base(i) = 'S' and l_bo_qty2s(i) > 0) THEN
1170: IF l_debug_on THEN
1171: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.UNRESERVE_DELIVERY_DETAIL FOR BO QTY',WSH_DEBUG_SV.C_PROC_LEVEL);
1172: END IF;
1173: if (l_fulfillment_base(i) = 'S' and l_overpick_qty2s(i) <=0 and l_overpick_qtys(i)>0 ) then
1174:
1175: wsh_delivery_details_actions.unreserve_delivery_detail(

Line 1175: wsh_delivery_details_actions.unreserve_delivery_detail(

1171: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.UNRESERVE_DELIVERY_DETAIL FOR BO QTY',WSH_DEBUG_SV.C_PROC_LEVEL);
1172: END IF;
1173: if (l_fulfillment_base(i) = 'S' and l_overpick_qty2s(i) <=0 and l_overpick_qtys(i)>0 ) then
1174:
1175: wsh_delivery_details_actions.unreserve_delivery_detail(
1176: p_delivery_Detail_id => l_detail_ids(i),
1177: p_unreserve_mode => p_bo_mode ,
1178: p_quantity_to_unreserve => l_bo_qtys(i)+l_overpick_qtys(i),
1179: p_quantity2_to_unreserve => l_bo_qty2s(i),

Line 1183: wsh_delivery_details_actions.unreserve_delivery_detail(

1179: p_quantity2_to_unreserve => l_bo_qty2s(i),
1180: p_override_retain_ato_rsv => 'N',
1181: x_return_status => l_return_status );
1182: else
1183: wsh_delivery_details_actions.unreserve_delivery_detail(
1184: p_delivery_Detail_id => l_detail_ids(i),
1185: p_unreserve_mode => p_bo_mode ,
1186: p_quantity_to_unreserve => l_bo_qtys(i),
1187: p_quantity2_to_unreserve => l_bo_qty2s(i),

Line 1239: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.FETCH_INV_CONTROLS',WSH_DEBUG_SV.C_PROC_LEVEL);

1235: --
1236: -- Debug Statements
1237: --
1238: IF l_debug_on THEN
1239: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.FETCH_INV_CONTROLS',WSH_DEBUG_SV.C_PROC_LEVEL);
1240: END IF;
1241: --
1242: WSH_DELIVERY_DETAILS_INV.Fetch_Inv_Controls(
1243: p_delivery_detail_id => l_detail_rec.delivery_detail_id,

Line 1242: WSH_DELIVERY_DETAILS_INV.Fetch_Inv_Controls(

1238: IF l_debug_on THEN
1239: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.FETCH_INV_CONTROLS',WSH_DEBUG_SV.C_PROC_LEVEL);
1240: END IF;
1241: --
1242: WSH_DELIVERY_DETAILS_INV.Fetch_Inv_Controls(
1243: p_delivery_detail_id => l_detail_rec.delivery_detail_id,
1244: p_inventory_item_id => l_detail_rec.inventory_item_id,
1245: p_organization_id => l_detail_rec.organization_id,
1246: p_subinventory => l_detail_rec.subinventory,

Line 1267: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.UNMARK_SERIAL_NUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);

1263: --
1264: -- Debug Statements
1265: --
1266: IF l_debug_on THEN
1267: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.UNMARK_SERIAL_NUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
1268: END IF;
1269: --
1270: WSH_DELIVERY_DETAILS_INV.Unmark_Serial_Number(
1271: p_delivery_detail_id => l_detail_rec.delivery_detail_id,

Line 1270: WSH_DELIVERY_DETAILS_INV.Unmark_Serial_Number(

1266: IF l_debug_on THEN
1267: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.UNMARK_SERIAL_NUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
1268: END IF;
1269: --
1270: WSH_DELIVERY_DETAILS_INV.Unmark_Serial_Number(
1271: p_delivery_detail_id => l_detail_rec.delivery_detail_id,
1272: p_serial_number_code => l_inv_controls_rec.serial_code,
1273: p_serial_number => l_detail_rec.serial_number,
1274: p_transaction_temp_id => l_detail_rec.transaction_temp_id,

Line 1290: UPDATE wsh_delivery_details

1286: l_num_warn := l_num_warn + 1;
1287: END IF;
1288: /* End of Bug 2308509 */
1289:
1290: UPDATE wsh_delivery_details
1291: SET transaction_temp_id = NULL,
1292: serial_number = NULL,
1293: last_update_date = SYSDATE,
1294: last_updated_by = FND_GLOBAL.USER_ID,

Line 1333: UPDATE wsh_delivery_details

1329: -- LSP PROJECT : end
1330: --
1331: --RTV changes
1332: IF l_detail_rec.source_code IN ('OE','WSH','OKE') THEN
1333: UPDATE wsh_delivery_details
1334: SET move_order_line_id = NULL ,
1335: -- 2807093: For ATO items, it is possible that during Shp.Confirm CTO would have updated the rel.Status to N
1336: -- so checking to see if it is 'N' then it has to remain 'N' otherwise 'B'
1337: released_status = decode(pickable_flag,'Y', decode(released_status, 'N', released_status,'B'),'X'),

Line 1365: UPDATE wsh_delivery_details

1361: replenishment_status = NULL -- bug# 6908504 (replenishment project), update replenishment status to NULL.
1362: WHERE delivery_detail_id = l_detail_rec.delivery_detail_id AND
1363: NVL(container_flag, 'N') = 'N' ;
1364: ELSE
1365: UPDATE wsh_delivery_details
1366: SET move_order_line_id = NULL ,
1367: released_status ='X',
1368: cycle_count_quantity = NULL,
1369: cycle_count_quantity2 = NULL,

Line 1432: UPDATE WSH_DELIVERY_DETAILS

1428: -- HW OPM BUG#:3121616 added qty2s
1429: WSH_DEBUG_SV.logmsg(l_module_name,'..Consolidate BO quantity2 '||l_remain_bo_qty2s(i), WSH_DEBUG_SV.C_PROC_LEVEL);
1430: END IF;
1431: -- HW OPM BUG#:3121616 added requested_quantity2
1432: UPDATE WSH_DELIVERY_DETAILS
1433: SET requested_quantity = requested_quantity + l_remain_bo_qtys(i),
1434: requested_quantity2 = requested_quantity2 + l_remain_bo_qty2s(i)
1435: WHERE delivery_detail_id = l_detail_rec.delivery_detail_id;
1436:

Line 1460: -- Update of wsh_delivery_details where requested_quantity/released_status

1456: -- These update released_status/requested_quantity
1457: -- This is different from l_detail_ids which is the set of ids for which LOOP is
1458: -- getting executed
1459: --
1460: -- Update of wsh_delivery_details where requested_quantity/released_status
1461: -- are changed, call DBI API after the update.
1462: -- This API will also check for DBI Installed or not
1463: IF l_debug_on THEN
1464: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Detail id-',l_detail_rec.delivery_detail_id);

Line 1533: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.unassign_unpack_empty_cont',WSH_DEBUG_SV.C_PROC_LEVEL);

1529: --{
1530: l_unassign_dds_tmp(1) := l_bo_detail_id;
1531:
1532: IF l_debug_on THEN
1533: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.unassign_unpack_empty_cont',WSH_DEBUG_SV.C_PROC_LEVEL);
1534: END IF;
1535:
1536: -- p_validate_flag is passed as 'N', so that backordering does not fail for planned Deliveries.
1537: WSH_DELIVERY_DETAILS_ACTIONS.unassign_unpack_empty_cont

Line 1537: WSH_DELIVERY_DETAILS_ACTIONS.unassign_unpack_empty_cont

1533: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.unassign_unpack_empty_cont',WSH_DEBUG_SV.C_PROC_LEVEL);
1534: END IF;
1535:
1536: -- p_validate_flag is passed as 'N', so that backordering does not fail for planned Deliveries.
1537: WSH_DELIVERY_DETAILS_ACTIONS.unassign_unpack_empty_cont
1538: (
1539: p_ids_tobe_unassigned => l_unassign_dds_tmp ,
1540: p_validate_flag => 'N',
1541: x_return_status => l_return_status

Line 1584: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.Consolidate_Source_Line',WSH_DEBUG_SV.C_PROC_LEVEL);

1580: --
1581: -- Debug Statements
1582: --
1583: IF l_debug_on THEN
1584: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.Consolidate_Source_Line',WSH_DEBUG_SV.C_PROC_LEVEL);
1585: END IF;
1586: --
1587: WSH_DELIVERY_DETAILS_ACTIONS.Consolidate_Source_Line(
1588: p_Cons_Source_Line_Rec_Tab => l_cons_source_line_rec_tab,

Line 1587: WSH_DELIVERY_DETAILS_ACTIONS.Consolidate_Source_Line(

1583: IF l_debug_on THEN
1584: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.Consolidate_Source_Line',WSH_DEBUG_SV.C_PROC_LEVEL);
1585: END IF;
1586: --
1587: WSH_DELIVERY_DETAILS_ACTIONS.Consolidate_Source_Line(
1588: p_Cons_Source_Line_Rec_Tab => l_cons_source_line_rec_tab,
1589: x_consolidate_ids => l_cons_dd_ids,
1590: x_return_status => l_return_status
1591: );

Line 1631: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.unassign_unpack_empty_cont',WSH_DEBUG_SV.C_PROC_LEVEL);

1627: --
1628: -- Debug Statements
1629: --
1630: IF l_debug_on THEN
1631: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.unassign_unpack_empty_cont',WSH_DEBUG_SV.C_PROC_LEVEL);
1632: END IF;
1633: -- p_validate_flag is passed as 'N', so that backordering does not fail for planned Deliveries.
1634: WSH_DELIVERY_DETAILS_ACTIONS.unassign_unpack_empty_cont (
1635: p_ids_tobe_unassigned => l_unassign_dds ,

Line 1634: WSH_DELIVERY_DETAILS_ACTIONS.unassign_unpack_empty_cont (

1630: IF l_debug_on THEN
1631: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.unassign_unpack_empty_cont',WSH_DEBUG_SV.C_PROC_LEVEL);
1632: END IF;
1633: -- p_validate_flag is passed as 'N', so that backordering does not fail for planned Deliveries.
1634: WSH_DELIVERY_DETAILS_ACTIONS.unassign_unpack_empty_cont (
1635: p_ids_tobe_unassigned => l_unassign_dds ,
1636: p_validate_flag => 'N',
1637: x_return_status => l_return_status
1638: );