DBA Data[Home] [Help]

APPS.INV_MMX_WRAPPER_PVT dependencies on INV_MOVE_ORDER_PUB

Line 1436: l_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;

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

Line 1437: l_trohdr_val_rec INV_Move_Order_PUB.Trohdr_Val_Rec_Type;

1433: l_return_status VARCHAR2(1);
1434: l_msg_count NUMBER;
1435: l_msg_data VARCHAR2(240);
1436: l_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
1437: l_trohdr_val_rec INV_Move_Order_PUB.Trohdr_Val_Rec_Type;
1438: l_x_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
1439: l_x_trohdr_val_rec INV_Move_Order_PUB.Trohdr_Val_Rec_Type;
1440: l_commit VARCHAR2(1) := FND_API.G_FALSE;
1441:

Line 1438: l_x_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;

1434: l_msg_count NUMBER;
1435: l_msg_data VARCHAR2(240);
1436: l_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
1437: l_trohdr_val_rec INV_Move_Order_PUB.Trohdr_Val_Rec_Type;
1438: l_x_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
1439: l_x_trohdr_val_rec INV_Move_Order_PUB.Trohdr_Val_Rec_Type;
1440: l_commit VARCHAR2(1) := FND_API.G_FALSE;
1441:
1442: BEGIN

Line 1439: l_x_trohdr_val_rec INV_Move_Order_PUB.Trohdr_Val_Rec_Type;

1435: l_msg_data VARCHAR2(240);
1436: l_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
1437: l_trohdr_val_rec INV_Move_Order_PUB.Trohdr_Val_Rec_Type;
1438: l_x_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
1439: l_x_trohdr_val_rec INV_Move_Order_PUB.Trohdr_Val_Rec_Type;
1440: l_commit VARCHAR2(1) := FND_API.G_FALSE;
1441:
1442: BEGIN
1443: SAVEPOINT sp_get_move_order_info;

Line 1478: print_debug('Calling INV_Move_Order_PUB.Create_Move_Order_Header'

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

Line 1482: INV_Move_Order_PUB.Create_Move_Order_Header(

1478: print_debug('Calling INV_Move_Order_PUB.Create_Move_Order_Header'
1479: , l_proc_name
1480: , 9);
1481: END IF;
1482: INV_Move_Order_PUB.Create_Move_Order_Header(
1483: p_api_version_number => 1,
1484: p_init_msg_list => FND_API.G_FALSE,
1485: p_return_values => FND_API.G_TRUE,
1486: p_commit => l_commit,

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

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

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

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

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

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