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_ACTIONS

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