DBA Data[Home] [Help]

APPS.INV_MINMAX_PVT dependencies on INV_MOVE_ORDER_PUB

Line 3200: l_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;

3196: l_ret_stat VARCHAR2(1);
3197: l_msg_count NUMBER;
3198: l_msg_data VARCHAR2(1000);
3199: l_mo_header_id NUMBER;
3200: l_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
3201: l_trolin_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
3202: l_trohdr_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
3203: l_trohdr_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
3204: l_x_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;

Line 3201: l_trolin_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;

3197: l_msg_count NUMBER;
3198: l_msg_data VARCHAR2(1000);
3199: l_mo_header_id NUMBER;
3200: l_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
3201: l_trolin_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
3202: l_trohdr_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
3203: l_trohdr_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
3204: l_x_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
3205: l_x_trohdr_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;

Line 3202: l_trohdr_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;

3198: l_msg_data VARCHAR2(1000);
3199: l_mo_header_id NUMBER;
3200: l_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
3201: l_trolin_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
3202: l_trohdr_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
3203: l_trohdr_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
3204: l_x_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
3205: l_x_trohdr_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
3206: l_x_trohdr_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;

Line 3203: l_trohdr_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;

3199: l_mo_header_id NUMBER;
3200: l_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
3201: l_trolin_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
3202: l_trohdr_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
3203: l_trohdr_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
3204: l_x_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
3205: l_x_trohdr_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
3206: l_x_trohdr_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
3207: l_x_trolin_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;

Line 3204: l_x_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;

3200: l_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
3201: l_trolin_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
3202: l_trohdr_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
3203: l_trohdr_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
3204: l_x_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
3205: l_x_trohdr_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
3206: l_x_trohdr_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
3207: l_x_trolin_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
3208: l_commit VARCHAR2(1) := FND_API.G_TRUE;

Line 3205: l_x_trohdr_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;

3201: l_trolin_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
3202: l_trohdr_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
3203: l_trohdr_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
3204: l_x_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
3205: l_x_trohdr_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
3206: l_x_trohdr_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
3207: l_x_trolin_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
3208: l_commit VARCHAR2(1) := FND_API.G_TRUE;
3209: l_mo_line_num NUMBER;

Line 3206: l_x_trohdr_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;

3202: l_trohdr_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
3203: l_trohdr_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
3204: l_x_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
3205: l_x_trohdr_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
3206: l_x_trohdr_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
3207: l_x_trolin_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
3208: l_commit VARCHAR2(1) := FND_API.G_TRUE;
3209: l_mo_line_num NUMBER;
3210: l_order_count NUMBER := 1; /* total number of lines */

Line 3207: l_x_trolin_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;

3203: l_trohdr_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
3204: l_x_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
3205: l_x_trohdr_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
3206: l_x_trohdr_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
3207: l_x_trolin_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
3208: l_commit VARCHAR2(1) := FND_API.G_TRUE;
3209: l_mo_line_num NUMBER;
3210: l_order_count NUMBER := 1; /* total number of lines */
3211: l_intransit_time NUMBER := 0;

Line 3457: -- Then call INV_Move_Order_PUB.Create_Move_Order_Lines to create a single move order line

3453: -- Replenishment Move Order Consolidation
3454: -- Replace the call to INV_Create_Move_Order_PVT.Create_Move_Orders with
3455: -- a call to INV_MMX_WRAPPER_PVT.get_move_order_info to get the correct header ID
3456: -- and Line Number.
3457: -- Then call INV_Move_Order_PUB.Create_Move_Order_Lines to create a single move order line
3458: -- for the current item. For the input record p_trolin_tbl, use the header ID returned by
3459: -- get_move_order_header_id.
3460: --
3461: -- the profile value set at the profile "INV: Minmax Reorder Approval"

Line 3592: print_debug('Calling INV_Move_Order_PUB.Create_Move_Order_Lines'

3588: l_trolin_tbl(l_order_count).secondary_uom := l_secondary_uom;
3589: /* ------INVCONV Change Added secondary qty and uom------ */
3590:
3591: IF G_TRACE_ON = 1 THEN
3592: print_debug('Calling INV_Move_Order_PUB.Create_Move_Order_Lines'
3593: , l_proc_name
3594: , 9);
3595: END IF;
3596: INV_Move_Order_PUB.Create_Move_Order_Lines

Line 3596: INV_Move_Order_PUB.Create_Move_Order_Lines

3592: print_debug('Calling INV_Move_Order_PUB.Create_Move_Order_Lines'
3593: , l_proc_name
3594: , 9);
3595: END IF;
3596: INV_Move_Order_PUB.Create_Move_Order_Lines
3597: ( p_api_version_number => 1.0 ,
3598: p_init_msg_list => FND_API.G_TRUE,
3599: p_commit => l_commit,
3600: x_return_status => l_ret_stat,

Line 3611: print_debug('INV_Move_Order_PUB.Create_Move_Order_Lines failed with expected error returning message: ' || l_msg_data|| l_msg_count

3607: );
3608:
3609: IF l_ret_stat = FND_API.G_RET_STS_ERROR THEN
3610: IF G_TRACE_ON = 1 THEN
3611: print_debug('INV_Move_Order_PUB.Create_Move_Order_Lines failed with expected error returning message: ' || l_msg_data|| l_msg_count
3612: , l_proc_name
3613: , 9);
3614: END IF;
3615: IF l_msg_count > 0 THEN

Line 3628: print_debug('INV_Move_Order_PUB.Create_Move_Order_Lines failed with unexpected error returning message: ' || l_msg_data

3624: END IF;
3625: RAISE fnd_api.g_exc_unexpected_error;
3626: ELSIF l_ret_stat = FND_API.G_RET_STS_UNEXP_ERROR THEN
3627: IF G_TRACE_ON = 1 THEN
3628: print_debug('INV_Move_Order_PUB.Create_Move_Order_Lines failed with unexpected error returning message: ' || l_msg_data
3629: , l_proc_name
3630: , 9);
3631: END IF;
3632: RAISE fnd_api.g_exc_error;

Line 3635: print_debug('INV_Move_Order_PUB.Create_Move_Order_Lines returned success'

3631: END IF;
3632: RAISE fnd_api.g_exc_error;
3633: ELSE
3634: IF G_TRACE_ON = 1 THEN
3635: print_debug('INV_Move_Order_PUB.Create_Move_Order_Lines returned success'
3636: , l_proc_name
3637: , 9);
3638: END IF;
3639: END IF;