DBA Data[Home] [Help]

APPS.INV_MMX_WRAPPER_PVT dependencies on INV_MOVE_ORDER_PUB

Line 1440: l_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;

1436: l_proc_name CONSTANT VARCHAR2(30) := 'GET_MOVE_ORDER_INFO';
1437: l_return_status VARCHAR2(1);
1438: l_msg_count NUMBER;
1439: l_msg_data VARCHAR2(240);
1440: l_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
1441: l_trohdr_val_rec INV_Move_Order_PUB.Trohdr_Val_Rec_Type;
1442: l_x_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
1443: l_x_trohdr_val_rec INV_Move_Order_PUB.Trohdr_Val_Rec_Type;
1444: l_commit VARCHAR2(1) := FND_API.G_FALSE;

Line 1441: l_trohdr_val_rec INV_Move_Order_PUB.Trohdr_Val_Rec_Type;

1437: l_return_status VARCHAR2(1);
1438: l_msg_count NUMBER;
1439: l_msg_data VARCHAR2(240);
1440: l_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
1441: l_trohdr_val_rec INV_Move_Order_PUB.Trohdr_Val_Rec_Type;
1442: l_x_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
1443: l_x_trohdr_val_rec INV_Move_Order_PUB.Trohdr_Val_Rec_Type;
1444: l_commit VARCHAR2(1) := FND_API.G_FALSE;
1445:

Line 1442: l_x_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;

1438: l_msg_count NUMBER;
1439: l_msg_data VARCHAR2(240);
1440: l_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
1441: l_trohdr_val_rec INV_Move_Order_PUB.Trohdr_Val_Rec_Type;
1442: l_x_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
1443: l_x_trohdr_val_rec INV_Move_Order_PUB.Trohdr_Val_Rec_Type;
1444: l_commit VARCHAR2(1) := FND_API.G_FALSE;
1445:
1446: BEGIN

Line 1443: l_x_trohdr_val_rec INV_Move_Order_PUB.Trohdr_Val_Rec_Type;

1439: l_msg_data VARCHAR2(240);
1440: l_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
1441: l_trohdr_val_rec INV_Move_Order_PUB.Trohdr_Val_Rec_Type;
1442: l_x_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
1443: l_x_trohdr_val_rec INV_Move_Order_PUB.Trohdr_Val_Rec_Type;
1444: l_commit VARCHAR2(1) := FND_API.G_FALSE;
1445:
1446: BEGIN
1447: SAVEPOINT sp_get_move_order_info;

Line 1482: print_debug('Calling INV_Move_Order_PUB.Create_Move_Order_Header'

1478: l_trohdr_rec.transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_SUBXFR;
1479: l_trohdr_rec.db_flag := FND_API.G_TRUE;
1480: l_trohdr_rec.operation := INV_GLOBALS.G_OPR_CREATE;
1481: IF G_TRACE_ON = 1 THEN
1482: print_debug('Calling INV_Move_Order_PUB.Create_Move_Order_Header'
1483: , l_proc_name
1484: , 9);
1485: END IF;
1486: INV_Move_Order_PUB.Create_Move_Order_Header(

Line 1486: INV_Move_Order_PUB.Create_Move_Order_Header(

1482: print_debug('Calling INV_Move_Order_PUB.Create_Move_Order_Header'
1483: , l_proc_name
1484: , 9);
1485: END IF;
1486: INV_Move_Order_PUB.Create_Move_Order_Header(
1487: p_api_version_number => 1,
1488: p_init_msg_list => FND_API.G_FALSE,
1489: p_return_values => FND_API.G_TRUE,
1490: p_commit => l_commit,

Line 1502: print_debug('INV_Move_Order_PUB.Create_Move_Order_Header failed with unexpected error returning message: ' || l_msg_data

1498: );
1499:
1500: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1501: IF G_TRACE_ON = 1 THEN
1502: print_debug('INV_Move_Order_PUB.Create_Move_Order_Header failed with unexpected error returning message: ' || l_msg_data
1503: , l_proc_name
1504: , 9);
1505: END IF;
1506: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1509: print_debug('INV_Move_Order_PUB.Create_Move_Order_Header failed with expected error returning message: ' || l_msg_data

1505: END IF;
1506: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1507: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1508: IF G_TRACE_ON = 1 THEN
1509: print_debug('INV_Move_Order_PUB.Create_Move_Order_Header failed with expected error returning message: ' || l_msg_data
1510: , l_proc_name
1511: , 9);
1512: END IF;
1513: RAISE FND_API.G_EXC_ERROR;

Line 1516: print_debug('INV_Move_Order_PUB.Create_Move_Order_Header returned success with header Id: ' || l_x_trohdr_rec.header_id

1512: END IF;
1513: RAISE FND_API.G_EXC_ERROR;
1514: ELSE
1515: IF G_TRACE_ON = 1 THEN
1516: print_debug('INV_Move_Order_PUB.Create_Move_Order_Header returned success with header Id: ' || l_x_trohdr_rec.header_id
1517: , l_proc_name
1518: , 9);
1519: END IF;
1520: END IF;