DBA Data[Home] [Help]

APPS.INV_MINMAX_PVT dependencies on INV_MOVE_ORDER_PUB

Line 3210: l_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;

3206: l_ret_stat VARCHAR2(1);
3207: l_msg_count NUMBER;
3208: l_msg_data VARCHAR2(1000);
3209: l_mo_header_id NUMBER;
3210: l_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
3211: l_trolin_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
3212: l_trohdr_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
3213: l_trohdr_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
3214: l_x_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;

Line 3211: l_trolin_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;

3207: l_msg_count NUMBER;
3208: l_msg_data VARCHAR2(1000);
3209: l_mo_header_id NUMBER;
3210: l_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
3211: l_trolin_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
3212: l_trohdr_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
3213: l_trohdr_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
3214: l_x_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
3215: l_x_trohdr_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;

Line 3212: l_trohdr_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;

3208: l_msg_data VARCHAR2(1000);
3209: l_mo_header_id NUMBER;
3210: l_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
3211: l_trolin_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
3212: l_trohdr_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
3213: l_trohdr_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
3214: l_x_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
3215: l_x_trohdr_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
3216: l_x_trohdr_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;

Line 3213: l_trohdr_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;

3209: l_mo_header_id NUMBER;
3210: l_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
3211: l_trolin_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
3212: l_trohdr_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
3213: l_trohdr_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
3214: l_x_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
3215: l_x_trohdr_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
3216: l_x_trohdr_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
3217: l_x_trolin_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;

Line 3214: l_x_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;

3210: l_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
3211: l_trolin_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
3212: l_trohdr_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
3213: l_trohdr_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
3214: l_x_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
3215: l_x_trohdr_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
3216: l_x_trohdr_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
3217: l_x_trolin_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
3218: l_commit VARCHAR2(1) := FND_API.G_TRUE;

Line 3215: l_x_trohdr_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;

3211: l_trolin_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
3212: l_trohdr_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
3213: l_trohdr_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
3214: l_x_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
3215: l_x_trohdr_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
3216: l_x_trohdr_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
3217: l_x_trolin_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
3218: l_commit VARCHAR2(1) := FND_API.G_TRUE;
3219: l_mo_line_num NUMBER;

Line 3216: l_x_trohdr_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;

3212: l_trohdr_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
3213: l_trohdr_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
3214: l_x_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
3215: l_x_trohdr_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
3216: l_x_trohdr_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
3217: l_x_trolin_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
3218: l_commit VARCHAR2(1) := FND_API.G_TRUE;
3219: l_mo_line_num NUMBER;
3220: l_order_count NUMBER := 1; /* total number of lines */

Line 3217: l_x_trolin_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;

3213: l_trohdr_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
3214: l_x_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
3215: l_x_trohdr_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
3216: l_x_trohdr_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
3217: l_x_trolin_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
3218: l_commit VARCHAR2(1) := FND_API.G_TRUE;
3219: l_mo_line_num NUMBER;
3220: l_order_count NUMBER := 1; /* total number of lines */
3221: l_intransit_time NUMBER := 0;

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

3463: -- Replenishment Move Order Consolidation
3464: -- Replace the call to INV_Create_Move_Order_PVT.Create_Move_Orders with
3465: -- a call to INV_MMX_WRAPPER_PVT.get_move_order_info to get the correct header ID
3466: -- and Line Number.
3467: -- Then call INV_Move_Order_PUB.Create_Move_Order_Lines to create a single move order line
3468: -- for the current item. For the input record p_trolin_tbl, use the header ID returned by
3469: -- get_move_order_header_id.
3470: --
3471: -- the profile value set at the profile "INV: Minmax Reorder Approval"

Line 3599: print_debug('Calling INV_Move_Order_PUB.Create_Move_Order_Lines'

3595: l_trolin_tbl(l_order_count).secondary_uom := l_secondary_uom;
3596: /* ------INVCONV Change Added secondary qty and uom------ */
3597:
3598: IF G_TRACE_ON = 1 THEN
3599: print_debug('Calling INV_Move_Order_PUB.Create_Move_Order_Lines'
3600: , l_proc_name
3601: , 9);
3602: END IF;
3603: INV_Move_Order_PUB.Create_Move_Order_Lines

Line 3603: INV_Move_Order_PUB.Create_Move_Order_Lines

3599: print_debug('Calling INV_Move_Order_PUB.Create_Move_Order_Lines'
3600: , l_proc_name
3601: , 9);
3602: END IF;
3603: INV_Move_Order_PUB.Create_Move_Order_Lines
3604: ( p_api_version_number => 1.0 ,
3605: p_init_msg_list => FND_API.G_TRUE,
3606: p_commit => l_commit,
3607: x_return_status => l_ret_stat,

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

3614: );
3615:
3616: IF l_ret_stat = FND_API.G_RET_STS_ERROR THEN
3617: IF G_TRACE_ON = 1 THEN
3618: print_debug('INV_Move_Order_PUB.Create_Move_Order_Lines failed with expected error returning message: ' || l_msg_data|| l_msg_count
3619: , l_proc_name
3620: , 9);
3621: END IF;
3622: IF l_msg_count > 0 THEN

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

3631: END IF;
3632: RAISE fnd_api.g_exc_unexpected_error;
3633: ELSIF l_ret_stat = FND_API.G_RET_STS_UNEXP_ERROR THEN
3634: IF G_TRACE_ON = 1 THEN
3635: print_debug('INV_Move_Order_PUB.Create_Move_Order_Lines failed with unexpected error returning message: ' || l_msg_data
3636: , l_proc_name
3637: , 9);
3638: END IF;
3639: RAISE fnd_api.g_exc_error;

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

3638: END IF;
3639: RAISE fnd_api.g_exc_error;
3640: ELSE
3641: IF G_TRACE_ON = 1 THEN
3642: print_debug('INV_Move_Order_PUB.Create_Move_Order_Lines returned success'
3643: , l_proc_name
3644: , 9);
3645: END IF;
3646: END IF;