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 347: FROM wsh_delivery_details

343: requested_quantity,
344: serial_number,
345: transaction_temp_id,
346: subinventory
347: FROM wsh_delivery_details
348: WHERE delivery_detail_id = x_detail_id AND
349: NVL(container_flag, 'N') = 'N';
350: l_detail_rec c_detail%ROWTYPE;
351:

Line 409: wsh_delivery_details wdd,

405: CURSOR c_assigned(c_delivery_detail_id number) is
406: SELECT wnd.delivery_id,
407: wnd.planned_flag
408: FROM wsh_new_deliveries wnd,
409: wsh_delivery_details wdd,
410: wsh_delivery_assignments_v wda
411: WHERE wdd.delivery_detail_id = c_delivery_detail_id
412: AND wda.delivery_id = wnd.delivery_id
413: AND wda.delivery_detail_id = wdd.delivery_detail_id ;

Line 432: l_inv_controls_rec WSH_DELIVERY_DETAILS_INV.inv_control_flag_rec;

428: l_bo_qty2 NUMBER ;
429: l_unassign_dds WSH_UTIL_CORE.Id_Tab_Type ;
430: l_unassign_dds_tmp WSH_UTIL_CORE.Id_Tab_Type ; -- bug 7460785
431: l_delete_dds WSH_UTIL_CORE.Id_Tab_Type ; -- to delete overpicked delivery lines
432: l_inv_controls_rec WSH_DELIVERY_DETAILS_INV.inv_control_flag_rec;
433:
434: invalid_source_code EXCEPTION; /*Bug 2096052- added for OKE */
435: no_backorder_full EXCEPTION; /*Bug 2399729- added for third party warehouse shipment line */
436: l_backorder_all VARCHAR2(1) := 'N'; /* Bug 2399729 */

Line 471: l_cons_source_line_rec_tab WSH_DELIVERY_DETAILS_ACTIONS.Cons_Source_Line_Rec_Tab;

467: l_remain_bo_qtys WSH_UTIL_CORE.Id_Tab_Type ; --Stores the remaining bo qty returned by Consolidate_Delivery_details
468: -- HW OPM BUG#:3121616 added qty2s
469: l_remain_bo_qty2s WSH_UTIL_CORE.Id_Tab_Type ; --Stores the remaining bo qty2 returned by Consolidate_Delivery_details
470: -- end of 3121616
471: l_cons_source_line_rec_tab WSH_DELIVERY_DETAILS_ACTIONS.Cons_Source_Line_Rec_Tab;
472: l_dd_rec_tab WSH_DELIVERY_DETAILS_ACTIONS.Cons_Source_Line_Rec_Tab;
473: l_cons_dd_rec_tab WSH_DELIVERY_DETAILS_ACTIONS.Cons_Source_Line_Rec_Tab;
474: k NUMBER;
475:

Line 472: l_dd_rec_tab WSH_DELIVERY_DETAILS_ACTIONS.Cons_Source_Line_Rec_Tab;

468: -- HW OPM BUG#:3121616 added qty2s
469: l_remain_bo_qty2s WSH_UTIL_CORE.Id_Tab_Type ; --Stores the remaining bo qty2 returned by Consolidate_Delivery_details
470: -- end of 3121616
471: l_cons_source_line_rec_tab WSH_DELIVERY_DETAILS_ACTIONS.Cons_Source_Line_Rec_Tab;
472: l_dd_rec_tab WSH_DELIVERY_DETAILS_ACTIONS.Cons_Source_Line_Rec_Tab;
473: l_cons_dd_rec_tab WSH_DELIVERY_DETAILS_ACTIONS.Cons_Source_Line_Rec_Tab;
474: k NUMBER;
475:
476: l_dd_txn_id NUMBER; --DBI

Line 473: l_cons_dd_rec_tab WSH_DELIVERY_DETAILS_ACTIONS.Cons_Source_Line_Rec_Tab;

469: l_remain_bo_qty2s WSH_UTIL_CORE.Id_Tab_Type ; --Stores the remaining bo qty2 returned by Consolidate_Delivery_details
470: -- end of 3121616
471: l_cons_source_line_rec_tab WSH_DELIVERY_DETAILS_ACTIONS.Cons_Source_Line_Rec_Tab;
472: l_dd_rec_tab WSH_DELIVERY_DETAILS_ACTIONS.Cons_Source_Line_Rec_Tab;
473: l_cons_dd_rec_tab WSH_DELIVERY_DETAILS_ACTIONS.Cons_Source_Line_Rec_Tab;
474: k NUMBER;
475:
476: l_dd_txn_id NUMBER; --DBI
477: l_txn_return_status VARCHAR2(1); --DBI

Line 482: SELECT organization_id from wsh_delivery_details

478: --
479:
480: -- HW 3457369
481: CURSOR find_org_id (l_delivery_detail_id NUMBER ) IS
482: SELECT organization_id from wsh_delivery_details
483: WHERE delivery_detail_id = l_delivery_detail_id
484: AND NVL(container_flag, 'N') = 'N';
485:
486: l_organization_id NUMBER;

Line 492: FROM oe_order_lines_all oelines, wsh_delivery_details wdd

488:
489: --Begin OPM Bug 3561937
490: CURSOR get_pref_grade(wdd_id NUMBER) IS
491: SELECT oelines.preferred_grade
492: FROM oe_order_lines_all oelines, wsh_delivery_details wdd
493: WHERE wdd.delivery_detail_id = wdd_id
494: AND wdd.source_code = 'OE'
495: AND wdd.source_line_id = oelines.line_id;
496:

Line 519: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;

515: l_msg_count NUMBER;
516: l_msg_data VARCHAR2(32767);
517: e_return_excp EXCEPTION;
518: -- K LPN CONV. rv
519: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;
520: --
521: --
522: l_unassign_dd_flag VARCHAR2(1) := 'N';
523: l_planned_flag VARCHAR2(1); -- bug# 6908504 (replenishment project)

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

568: END IF;
569: --
570: WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters(l_global_param_rec, l_return_status);
571: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
572: wsh_util_core.add_message(l_return_status,'WSH_DELIVERY_DETAILS_ACTIONS.Consolidate_Delivery_Details');
573: x_return_status := l_return_status;
574: RAISE backorder_error;
575: END IF;
576:

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

594: --
595: -- Debug Statements
596: --
597: IF l_debug_on THEN
598: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.Consolidate_Delivery_Details',WSH_DEBUG_SV.C_PROC_LEVEL);
599: END IF;
600: --
601: -- HW OPM BUG#:3121616 Added x_remain_bo_qty2s
602: WSH_DELIVERY_DETAILS_ACTIONS.Consolidate_Delivery_Details(

Line 602: WSH_DELIVERY_DETAILS_ACTIONS.Consolidate_Delivery_Details(

598: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.Consolidate_Delivery_Details',WSH_DEBUG_SV.C_PROC_LEVEL);
599: END IF;
600: --
601: -- HW OPM BUG#:3121616 Added x_remain_bo_qty2s
602: WSH_DELIVERY_DETAILS_ACTIONS.Consolidate_Delivery_Details(
603: p_delivery_details_tab => l_dd_rec_tab,
604: p_bo_mode => p_bo_mode,
605: x_cons_delivery_details_tab => l_cons_dd_rec_tab,
606: x_remain_bo_qtys => l_remain_bo_qtys,

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

608: x_return_status => l_return_status
609: );
610: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
611: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
612: wsh_util_core.add_message(l_return_status,'WSH_DELIVERY_DETAILS_ACTIONS.Consolidate_Delivery_Details');
613: x_return_status := l_return_status;
614: RAISE backorder_error;
615: END IF;
616:

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

696: --
697: -- Debug Statements
698: --
699: IF l_debug_on THEN
700: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.SPLIT_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
701: END IF;
702: --
703: wsh_delivery_details_actions.split_delivery_details(
704: p_from_detail_id => l_detail_ids(i),

Line 703: wsh_delivery_details_actions.split_delivery_details(

699: IF l_debug_on THEN
700: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.SPLIT_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
701: END IF;
702: --
703: wsh_delivery_details_actions.split_delivery_details(
704: p_from_detail_id => l_detail_ids(i),
705: p_req_quantity => l_bo_qty,
706: x_new_detail_id => l_bo_detail_id,
707: x_return_status => l_return_status ,

Line 733: and WSH_DELIVERY_DETAILS_INV.Get_item_information procedure. */

729:
730: END IF;
731:
732: /*Bug 5525314 moved up the open cursor c_detail
733: and WSH_DELIVERY_DETAILS_INV.Get_item_information procedure. */
734: /* H integration: 940/945 look up source code before unassigning wrudge*/
735: OPEN c_detail(l_bo_detail_id );
736: FETCH c_detail INTO l_detail_rec;
737: CLOSE c_detail;

Line 756: WSH_DELIVERY_DETAILS_INV.Get_item_information

752: IF l_detail_rec.released_status = 'Y' THEN
753: -- call this API only if line is staged, so we can test lot
754: -- divisibility.
755:
756: WSH_DELIVERY_DETAILS_INV.Get_item_information
757: (
758: p_organization_id => l_detail_rec.organization_id,
759: p_inventory_item_id => l_detail_rec.inventory_item_id,
760: x_mtl_system_items_rec => l_item_info,

Line 798: UPDATE wsh_delivery_details

794: IF (l_item_info.lot_divisible_flag = 'N' AND
795: l_item_info.lot_control_code = 2 ) THEN
796: l_new_picked_quantity := l_detail_rec.picked_quantity ;
797: ELSE
798: UPDATE wsh_delivery_details
799: SET picked_quantity = picked_quantity - l_overpick_qtys(i),
800: picked_quantity2 = picked_quantity2 - p_overpick_qtys2(i)
801: WHERE l_detail_ids(i) = delivery_detail_id
802: RETURNING picked_quantity INTO l_new_picked_quantity;

Line 872: l_reserved_flag :=WSH_DELIVERY_DETAILS_INV.LINE_RESERVED(

868: -- then mark it as deleted.
869: l_delete_dds( l_delete_dds.count+1 ) := l_detail_ids(i);
870: END IF;
871: -- bug 1672188: unreserve if the detail is reserved
872: l_reserved_flag :=WSH_DELIVERY_DETAILS_INV.LINE_RESERVED(
873: p_detail_id => l_detail_rec.delivery_detail_id,
874: p_source_code => l_detail_rec.source_code,
875: p_released_status => l_detail_rec.released_status,
876: p_pickable_flag => l_detail_rec.pickable_flag,

Line 934: l_qty WSH_DELIVERY_DETAILS.REQUESTED_QUANTITY%TYPE;

930: l_item_info.lot_control_code = 2 ) THEN --{ lot divisibility
931:
932: DECLARE --{ lot indivisible reservation block
933: l_bo_mode VARCHAR2(30);
934: l_qty WSH_DELIVERY_DETAILS.REQUESTED_QUANTITY%TYPE;
935: l_qty2 WSH_DELIVERY_DETAILS.REQUESTED_QUANTITY2%TYPE;
936: BEGIN
937:
938: l_bo_mode := p_bo_mode;

Line 935: l_qty2 WSH_DELIVERY_DETAILS.REQUESTED_QUANTITY2%TYPE;

931:
932: DECLARE --{ lot indivisible reservation block
933: l_bo_mode VARCHAR2(30);
934: l_qty WSH_DELIVERY_DETAILS.REQUESTED_QUANTITY%TYPE;
935: l_qty2 WSH_DELIVERY_DETAILS.REQUESTED_QUANTITY2%TYPE;
936: BEGIN
937:
938: l_bo_mode := p_bo_mode;
939: IF l_bo_mode = 'RETAIN_RSV' THEN

Line 957: WSH_DELIVERY_DETAILS_ACTIONS.UNRESERVE_DELIVERY_DETAIL(

953: --then over pick Qty should not be unreserved
954: IF ((l_bo_qtys(i) > 0 AND l_detail_rec.requested_quantity >0)
955: OR (l_bo_qtys(i) = 0 AND l_detail_rec.requested_quantity = 0))
956: THEN
957: WSH_DELIVERY_DETAILS_ACTIONS.UNRESERVE_DELIVERY_DETAIL(
958: p_delivery_Detail_id => l_detail_ids(i),
959: p_unreserve_mode => l_bo_mode ,
960: p_quantity_to_unreserve => l_qty,
961: p_quantity2_to_unreserve => l_qty2,

Line 991: 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);

987: -- Bug 2824748: Call unreserve_delivery_detail with p_override_retain_ato_rsv 'Y' so that the
988: -- reservations for unused overpick qty are always removed
989: IF (l_overpick_qtys(i) > 0) THEN
990: IF l_debug_on THEN
991: 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);
992: END IF;
993: --
994: -- HW OPMCONV - Added Qty2
995:

Line 998: wsh_delivery_details_actions.unreserve_delivery_detail(

994: -- HW OPMCONV - Added Qty2
995:
996: --Bug 4721577 Do not retain reservation for overpicked quantities
997: IF p_bo_mode = 'RETAIN_RSV' THEN
998: wsh_delivery_details_actions.unreserve_delivery_detail(
999: p_delivery_Detail_id => l_detail_ids(i),
1000: p_unreserve_mode => 'UNRESERVE' ,
1001: p_quantity_to_unreserve => l_overpick_qtys(i),
1002: p_override_retain_ato_rsv => 'Y',

Line 1005: wsh_delivery_details_actions.unreserve_delivery_detail(

1001: p_quantity_to_unreserve => l_overpick_qtys(i),
1002: p_override_retain_ato_rsv => 'Y',
1003: x_return_status => l_return_status );
1004: ELSE
1005: wsh_delivery_details_actions.unreserve_delivery_detail(
1006: p_delivery_Detail_id => l_detail_ids(i),
1007: p_unreserve_mode => p_bo_mode ,
1008: p_quantity_to_unreserve => l_overpick_qtys(i),
1009: p_quantity2_to_unreserve =>p_overpick_qtys2(i),

Line 1039: 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);

1035: -- Bug 2824748: Call unreserve_delivery_detail with p_override_retain_ato_rsv 'N' so that the
1036: -- reservations for backorder qty are removed depending on the ATO profile option
1037: IF (l_bo_qtys(i) > 0) THEN
1038: IF l_debug_on THEN
1039: 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);
1040: END IF;
1041: wsh_delivery_details_actions.unreserve_delivery_detail(
1042: p_delivery_Detail_id => l_detail_ids(i),
1043: p_unreserve_mode => p_bo_mode ,

Line 1041: wsh_delivery_details_actions.unreserve_delivery_detail(

1037: IF (l_bo_qtys(i) > 0) THEN
1038: IF l_debug_on THEN
1039: 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);
1040: END IF;
1041: wsh_delivery_details_actions.unreserve_delivery_detail(
1042: p_delivery_Detail_id => l_detail_ids(i),
1043: p_unreserve_mode => p_bo_mode ,
1044: p_quantity_to_unreserve => l_bo_qtys(i),
1045: p_quantity2_to_unreserve => l_bo_qty2s(i),

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

1088: --
1089: -- Debug Statements
1090: --
1091: IF l_debug_on THEN
1092: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.FETCH_INV_CONTROLS',WSH_DEBUG_SV.C_PROC_LEVEL);
1093: END IF;
1094: --
1095: WSH_DELIVERY_DETAILS_INV.Fetch_Inv_Controls(
1096: p_delivery_detail_id => l_detail_rec.delivery_detail_id,

Line 1095: WSH_DELIVERY_DETAILS_INV.Fetch_Inv_Controls(

1091: IF l_debug_on THEN
1092: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.FETCH_INV_CONTROLS',WSH_DEBUG_SV.C_PROC_LEVEL);
1093: END IF;
1094: --
1095: WSH_DELIVERY_DETAILS_INV.Fetch_Inv_Controls(
1096: p_delivery_detail_id => l_detail_rec.delivery_detail_id,
1097: p_inventory_item_id => l_detail_rec.inventory_item_id,
1098: p_organization_id => l_detail_rec.organization_id,
1099: p_subinventory => l_detail_rec.subinventory,

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

1116: --
1117: -- Debug Statements
1118: --
1119: IF l_debug_on THEN
1120: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.UNMARK_SERIAL_NUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
1121: END IF;
1122: --
1123: WSH_DELIVERY_DETAILS_INV.Unmark_Serial_Number(
1124: p_delivery_detail_id => l_detail_rec.delivery_detail_id,

Line 1123: WSH_DELIVERY_DETAILS_INV.Unmark_Serial_Number(

1119: IF l_debug_on THEN
1120: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.UNMARK_SERIAL_NUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
1121: END IF;
1122: --
1123: WSH_DELIVERY_DETAILS_INV.Unmark_Serial_Number(
1124: p_delivery_detail_id => l_detail_rec.delivery_detail_id,
1125: p_serial_number_code => l_inv_controls_rec.serial_code,
1126: p_serial_number => l_detail_rec.serial_number,
1127: p_transaction_temp_id => l_detail_rec.transaction_temp_id,

Line 1143: UPDATE wsh_delivery_details

1139: l_num_warn := l_num_warn + 1;
1140: END IF;
1141: /* End of Bug 2308509 */
1142:
1143: UPDATE wsh_delivery_details
1144: SET transaction_temp_id = NULL,
1145: serial_number = NULL,
1146: last_update_date = SYSDATE,
1147: last_updated_by = FND_GLOBAL.USER_ID,

Line 1177: UPDATE wsh_delivery_details

1173: FETCH get_pref_grade INTO l_oeline_pref_grade;
1174: CLOSE get_pref_grade;
1175: --End OPM bug 3561937
1176:
1177: UPDATE wsh_delivery_details
1178: SET move_order_line_id = NULL ,
1179: -- 2807093: For ATO items, it is possible that during Shp.Confirm CTO would have updated the rel.Status to N
1180: -- so checking to see if it is 'N' then it has to remain 'N' otherwise 'B'
1181: released_status = decode(pickable_flag,'Y', decode(released_status, 'N', released_status,'B'),'X'),

Line 1250: UPDATE WSH_DELIVERY_DETAILS

1246: -- HW OPM BUG#:3121616 added qty2s
1247: WSH_DEBUG_SV.logmsg(l_module_name,'..Consolidate BO quantity2 '||l_remain_bo_qty2s(i), WSH_DEBUG_SV.C_PROC_LEVEL);
1248: END IF;
1249: -- HW OPM BUG#:3121616 added requested_quantity2
1250: UPDATE WSH_DELIVERY_DETAILS
1251: SET requested_quantity = requested_quantity + l_remain_bo_qtys(i),
1252: requested_quantity2 = requested_quantity2 + l_remain_bo_qty2s(i)
1253: WHERE delivery_detail_id = l_detail_rec.delivery_detail_id;
1254:

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

1272: -- These update released_status/requested_quantity
1273: -- This is different from l_detail_ids which is the set of ids for which LOOP is
1274: -- getting executed
1275: --
1276: -- Update of wsh_delivery_details where requested_quantity/released_status
1277: -- are changed, call DBI API after the update.
1278: -- This API will also check for DBI Installed or not
1279: IF l_debug_on THEN
1280: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Detail id-',l_detail_rec.delivery_detail_id);

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

1343: --{
1344: l_unassign_dds_tmp(1) := l_bo_detail_id;
1345:
1346: IF l_debug_on THEN
1347: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.unassign_unpack_empty_cont',WSH_DEBUG_SV.C_PROC_LEVEL);
1348: END IF;
1349:
1350: -- p_validate_flag is passed as 'N', so that backordering does not fail for planned Deliveries.
1351: WSH_DELIVERY_DETAILS_ACTIONS.unassign_unpack_empty_cont

Line 1351: WSH_DELIVERY_DETAILS_ACTIONS.unassign_unpack_empty_cont

1347: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.unassign_unpack_empty_cont',WSH_DEBUG_SV.C_PROC_LEVEL);
1348: END IF;
1349:
1350: -- p_validate_flag is passed as 'N', so that backordering does not fail for planned Deliveries.
1351: WSH_DELIVERY_DETAILS_ACTIONS.unassign_unpack_empty_cont
1352: (
1353: p_ids_tobe_unassigned => l_unassign_dds_tmp ,
1354: p_validate_flag => 'N',
1355: x_return_status => l_return_status

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

1392: --
1393: -- Debug Statements
1394: --
1395: IF l_debug_on THEN
1396: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.Consolidate_Source_Line',WSH_DEBUG_SV.C_PROC_LEVEL);
1397: END IF;
1398: --
1399: WSH_DELIVERY_DETAILS_ACTIONS.Consolidate_Source_Line(
1400: p_Cons_Source_Line_Rec_Tab => l_cons_source_line_rec_tab,

Line 1399: WSH_DELIVERY_DETAILS_ACTIONS.Consolidate_Source_Line(

1395: IF l_debug_on THEN
1396: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.Consolidate_Source_Line',WSH_DEBUG_SV.C_PROC_LEVEL);
1397: END IF;
1398: --
1399: WSH_DELIVERY_DETAILS_ACTIONS.Consolidate_Source_Line(
1400: p_Cons_Source_Line_Rec_Tab => l_cons_source_line_rec_tab,
1401: x_consolidate_ids => l_cons_dd_ids,
1402: x_return_status => l_return_status
1403: );

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

1439: --
1440: -- Debug Statements
1441: --
1442: IF l_debug_on THEN
1443: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.unassign_unpack_empty_cont',WSH_DEBUG_SV.C_PROC_LEVEL);
1444: END IF;
1445: -- p_validate_flag is passed as 'N', so that backordering does not fail for planned Deliveries.
1446: WSH_DELIVERY_DETAILS_ACTIONS.unassign_unpack_empty_cont (
1447: p_ids_tobe_unassigned => l_unassign_dds ,

Line 1446: WSH_DELIVERY_DETAILS_ACTIONS.unassign_unpack_empty_cont (

1442: IF l_debug_on THEN
1443: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.unassign_unpack_empty_cont',WSH_DEBUG_SV.C_PROC_LEVEL);
1444: END IF;
1445: -- p_validate_flag is passed as 'N', so that backordering does not fail for planned Deliveries.
1446: WSH_DELIVERY_DETAILS_ACTIONS.unassign_unpack_empty_cont (
1447: p_ids_tobe_unassigned => l_unassign_dds ,
1448: p_validate_flag => 'N',
1449: x_return_status => l_return_status
1450: );