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 636: -- These values are used as select columns in the SQLs used in INV_MINMAX_PVT.run_min_max(),

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

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

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

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

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

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

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

Line 810: INV_Minmax_PVT.run_min_max_plan

806: ,l_proc
807: , 9);
808: END IF;
809:
810: INV_Minmax_PVT.run_min_max_plan
811: ( p_item_select => l_item_select
812: , p_handle_rep_item => NVL(p_handle_rep_item,3)
813: , p_pur_revision => l_pur_revision
814: , p_cat_select => l_cat_select

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

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

Line 868: 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

864: END IF;
865: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
866: l_warn := 'W'; --Bug 4681032
867: IF G_TRACE_ON = 1 THEN
868: 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
869: ,l_proc
870: , 9);
871: END IF;
872: END IF;

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

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

Line 881: INV_Minmax_PVT.run_min_max_plan

877: ,l_proc
878: , 9);
879: END IF;
880:
881: INV_Minmax_PVT.run_min_max_plan
882: ( p_item_select => l_item_select
883: , p_handle_rep_item => NVL(p_handle_rep_item,3)
884: , p_pur_revision => l_pur_revision
885: , p_cat_select => l_cat_select

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

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

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

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

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

940: END IF;
941: RAISE fnd_api.g_exc_error;
942: ELSE
943: IF G_TRACE_ON = 1 THEN
944: print_debug('INV_Minmax_PVT.run_min_max_plan returned success'
945: ,l_proc
946: , 9);
947: END IF;
948:

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

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

Line 1276: print_debug('Calling INV_Minmax_PVT.do_restock'

1272: ', p_pur_revision: ' || to_char(p_pur_revision) || fnd_global.local_chr(10) ||
1273: ', p_mo_line_grouping ' || to_char(p_mo_line_grouping) || fnd_global.local_chr(10)
1274: , l_proc_name
1275: , 9);
1276: print_debug('Calling INV_Minmax_PVT.do_restock'
1277: , l_proc_name
1278: , 9);
1279: END IF;
1280:

Line 1281: INV_Minmax_PVT.do_restock( p_item_id => p_item_id

1277: , l_proc_name
1278: , 9);
1279: END IF;
1280:
1281: INV_Minmax_PVT.do_restock( p_item_id => p_item_id
1282: , p_mbf => p_mbf
1283: , p_handle_repetitive_item => p_handle_repetitive_item
1284: , p_repetitive_planned_item => p_repetitive_planned_item
1285: , p_qty => p_qty

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

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

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

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

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

1335: END IF;
1336: RAISE fnd_api.g_exc_error;
1337: ELSE
1338: IF G_TRACE_ON = 1 THEN
1339: print_debug('INV_Minmax_PVT.do_restock returned success'
1340: , l_proc_name
1341: , 9);
1342: END IF;
1343: END IF;

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

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