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