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.INV_MMX_WRAPPER_PVT dependencies on INV_MINMAX_PVT

Line 49: ** the existing INV_Minmax_PVT.run_min_max_plan API when

45: ** 2) Initializes the package variables for move order line consolidation,
46: ** current subinventory being planned and current move order header ID
47: ** and line Number.
48: ** 3) Loops through the passed in array of subinventories and calls
49: ** the existing INV_Minmax_PVT.run_min_max_plan API when
50: ** doing sub-level planning for more than one subinventory.
51: ** 4) After report is complete,submit FND request for WIP Mass Load
52: ** which was previously done in AFTER-REPORT trigger of the min-max report.
53: **

Line 632: -- These values are used as select columns in the SQLs used in INV_MINMAX_PVT.run_min_max(),

628: END IF;
629:
630: --
631: -- Set Item and Category if they are null.
632: -- These values are used as select columns in the SQLs used in INV_MINMAX_PVT.run_min_max(),
633: -- but not used elsewhere in that procedure.
634: --
635: l_item_select := NVL(P_ITEM_SELECT,('C.SEGMENT1'));
636: l_cat_select := NVL(P_CAT_SELECT,('B.SEGMENT1||B.SEGMENT2'));

Line 771: -- Call inv_minmax_pvt.run_min_max_plan for each sub.

767: -- If no subs found, return an error: "No items have been set up for
768: -- subinventory level min-max planning in this organization."
769: -- End if;
770: -- Loop through list of subs
771: -- Call inv_minmax_pvt.run_min_max_plan for each sub.
772: -- End loop;
773: -- Else
774: -- Call inv_minmax_pvt.run_min_max_plan for org level planning.
775: -- End if;

Line 774: -- Call inv_minmax_pvt.run_min_max_plan for org level planning.

770: -- Loop through list of subs
771: -- Call inv_minmax_pvt.run_min_max_plan for each sub.
772: -- End loop;
773: -- Else
774: -- Call inv_minmax_pvt.run_min_max_plan for org level planning.
775: -- End if;
776: --
777: IF P_LEVEL = 2 THEN
778: IF P_SUBINV_TBL.COUNT = 0 THEN

Line 800: print_debug('Calling INV_Minmax_PVT.run_min_max_plan for subinventory level ' ||

796:
797: FOR l_subinv_count IN 1..l_subinv_tbl.COUNT
798: LOOP
799: IF G_TRACE_ON = 1 THEN
800: print_debug('Calling INV_Minmax_PVT.run_min_max_plan for subinventory level ' ||
801: 'Min Max Planning with sub '||l_subinv_tbl(l_subinv_count)
802: ,l_proc
803: , 9);
804: END IF;

Line 806: INV_Minmax_PVT.run_min_max_plan

802: ,l_proc
803: , 9);
804: END IF;
805:
806: INV_Minmax_PVT.run_min_max_plan
807: ( p_item_select => l_item_select
808: , p_handle_rep_item => NVL(p_handle_rep_item,3)
809: , p_pur_revision => l_pur_revision
810: , p_cat_select => l_cat_select

Line 855: print_debug('INV_Minmax_PVT.run_min_max_plan failed with unexpected error '||

851:
852: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
853: l_warn := 'W'; --Bug 4681032
854: IF G_TRACE_ON = 1 THEN
855: print_debug('INV_Minmax_PVT.run_min_max_plan failed with unexpected error '||
856: 'for subinventory '|| l_subinv_tbl(l_subinv_count) ||
857: 'returning message: ' || l_msg_data
858: ,l_proc
859: , 9);

Line 864: print_debug('INV_Minmax_PVT.run_min_max_plan failed with expected error for subinventory '|| l_subinv_tbl(l_subinv_count) ||' returning message: ' || l_msg_data

860: END IF;
861: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
862: l_warn := 'W'; --Bug 4681032
863: IF G_TRACE_ON = 1 THEN
864: print_debug('INV_Minmax_PVT.run_min_max_plan failed with expected error for subinventory '|| l_subinv_tbl(l_subinv_count) ||' returning message: ' || l_msg_data
865: ,l_proc
866: , 9);
867: END IF;
868: END IF;

Line 872: print_debug('Calling INV_Minmax_PVT.run_min_max_plan for Organization level Min Max Planning'

868: END IF;
869: END LOOP;
870: ELSE
871: IF G_TRACE_ON = 1 THEN
872: print_debug('Calling INV_Minmax_PVT.run_min_max_plan for Organization level Min Max Planning'
873: ,l_proc
874: , 9);
875: END IF;
876:

Line 877: INV_Minmax_PVT.run_min_max_plan

873: ,l_proc
874: , 9);
875: END IF;
876:
877: INV_Minmax_PVT.run_min_max_plan
878: ( p_item_select => l_item_select
879: , p_handle_rep_item => NVL(p_handle_rep_item,3)
880: , p_pur_revision => l_pur_revision
881: , p_cat_select => l_cat_select

Line 925: print_debug('INV_Minmax_PVT.run_min_max_plan failed with unexpected error ' ||

921: );
922:
923: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
924: IF G_TRACE_ON = 1 THEN
925: print_debug('INV_Minmax_PVT.run_min_max_plan failed with unexpected error ' ||
926: 'returning message: ' || l_msg_data
927: ,l_proc
928: , 9);
929: END IF;

Line 933: print_debug('INV_Minmax_PVT.run_min_max_plan failed with expected error returning message: ' || l_msg_data

929: END IF;
930: RAISE fnd_api.g_exc_unexpected_error;
931: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
932: IF G_TRACE_ON = 1 THEN
933: print_debug('INV_Minmax_PVT.run_min_max_plan failed with expected error returning message: ' || l_msg_data
934: ,l_proc
935: , 9);
936: END IF;
937: RAISE fnd_api.g_exc_error;

Line 940: print_debug('INV_Minmax_PVT.run_min_max_plan returned success'

936: END IF;
937: RAISE fnd_api.g_exc_error;
938: ELSE
939: IF G_TRACE_ON = 1 THEN
940: print_debug('INV_Minmax_PVT.run_min_max_plan returned success'
941: ,l_proc
942: , 9);
943: END IF;
944:

Line 1051: ** 2) Calls INV_Minmax_PVT.do_restock.

1047: **
1048: ** 1) Initializes the package variables for move order line consolidation,
1049: ** current subinventory being planned and current move order header ID
1050: ** and line Number.
1051: ** 2) Calls INV_Minmax_PVT.do_restock.
1052: **
1053: ** Input Parameters:
1054: **
1055: ** p_item_id

Line 1272: print_debug('Calling INV_Minmax_PVT.do_restock'

1268: ', p_pur_revision: ' || to_char(p_pur_revision) || fnd_global.local_chr(10) ||
1269: ', p_mo_line_grouping ' || to_char(p_mo_line_grouping) || fnd_global.local_chr(10)
1270: , l_proc_name
1271: , 9);
1272: print_debug('Calling INV_Minmax_PVT.do_restock'
1273: , l_proc_name
1274: , 9);
1275: END IF;
1276:

Line 1277: INV_Minmax_PVT.do_restock( p_item_id => p_item_id

1273: , l_proc_name
1274: , 9);
1275: END IF;
1276:
1277: INV_Minmax_PVT.do_restock( p_item_id => p_item_id
1278: , p_mbf => p_mbf
1279: , p_handle_repetitive_item => p_handle_repetitive_item
1280: , p_repetitive_planned_item => p_repetitive_planned_item
1281: , p_qty => p_qty

Line 1321: print_debug('INV_Minmax_PVT.do_restock failed with unexpected error returning message: ' || l_msg_data

1317: );
1318:
1319: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1320: IF G_TRACE_ON = 1 THEN
1321: print_debug('INV_Minmax_PVT.do_restock failed with unexpected error returning message: ' || l_msg_data
1322: , l_proc_name
1323: , 9);
1324: END IF;
1325: RAISE fnd_api.g_exc_unexpected_error;

Line 1328: print_debug('INV_Minmax_PVT.do_restock failed with expected error returning message: ' || l_msg_data

1324: END IF;
1325: RAISE fnd_api.g_exc_unexpected_error;
1326: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1327: IF G_TRACE_ON = 1 THEN
1328: print_debug('INV_Minmax_PVT.do_restock failed with expected error returning message: ' || l_msg_data
1329: , l_proc_name
1330: , 9);
1331: END IF;
1332: RAISE fnd_api.g_exc_error;

Line 1335: print_debug('INV_Minmax_PVT.do_restock returned success'

1331: END IF;
1332: RAISE fnd_api.g_exc_error;
1333: ELSE
1334: IF G_TRACE_ON = 1 THEN
1335: print_debug('INV_Minmax_PVT.do_restock returned success'
1336: , l_proc_name
1337: , 9);
1338: END IF;
1339: END IF;

Line 1376: ** Description : This procedure is called from INV_Minmax_PVT.do_restock to

1372:
1373: /*
1374: ** ---------------------------------------------------------------------------
1375: ** Procedure : get_move_order_info
1376: ** Description : This procedure is called from INV_Minmax_PVT.do_restock to
1377: ** get the move order header ID and move order line number ,
1378: ** prior to creating a move order line.
1379: **
1380: ** 1) It returns the header ID and line number of the existing Header,