API-MoveOrder-How To Create A Move Order Header Using INV_MOVE_ORDER_PUB.Create_Move_Order_Header？

摘自：Document 729261.1 (oracle.com)

How To Create A Move Order Header Using INV_MOVE_ORDER_PUB.Create_Move_Order_Header API ? (Doc ID 729261.1)

APPLIES TO:

Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.

GOAL

The purpose of this document is to provide an example to show how how Move Order Headers can be loaded using the standard Inventory API.

SOLUTION

1. Code Snippet

 INV_MOVE_ORDER_PUB.Create_Move_Order_Header
(   p_api_version_number  => '1.0'
,   p_init_msg_list       => FND_API.G_FALSE
,   p_return_values       => FND_API.G_FALSE
,   p_commit              => FND_API.G_FALSE
,   x_return_status       => x_return_status
,   x_msg_count           => x_msg_count
,   x_msg_data            => x_msg_data
,   p_trohdr_rec          => l_trohdr_rec
,   p_trohdr_val_rec      => l_trohdr_val_rec
,   x_trohdr_rec          => x_Trohdr_Rec_Type
,   x_trohdr_val_rec      => x_Trohdr_Val_Rec_Type
,   p_validation_flag      => FND_API.G_TRUE
); 

2. Sample Code 

Download Create Move Order Headers Sample API for the sample API Code
 

Also review Note 729263.1 - How To Create Move Order Lines Using INV_MOVE_ORDER_PUB.Create_Move_Order_Lines API [Video] ?

Attachments
 
Sample code：CreateMoveOrderHdr

CREATE OR REPLACE PROCEDURE XX_CreateMoveOrderHeader AS         -- Common Declarations         l_api_version         NUMBER := 1.0;          l_init_msg_list         VARCHAR2(2) := FND_API.G_TRUE;          l_return_values         VARCHAR2(2) := FND_API.G_FALSE;          l_commit         VARCHAR2(2) := FND_API.G_FALSE;          x_return_status         VARCHAR2(2);         x_msg_count         NUMBER := 0;         x_msg_data         VARCHAR2(255);              -- WHO columns         l_user_id        NUMBER := -1;         l_resp_id        NUMBER := -1;         l_application_id    NUMBER := -1;         l_user_name        VARCHAR2(30) := 'MFG';         l_resp_name        VARCHAR2(50) := 'Manufacturing and Distribution Manager';                     -- API specific declarations         l_trohdr_rec             INV_MOVE_ORDER_PUB.TROHDR_REC_TYPE;         l_trohdr_val_rec         INV_MOVE_ORDER_PUB.TROHDR_VAL_REC_TYPE;         x_trohdr_rec             INV_MOVE_ORDER_PUB.TROHDR_REC_TYPE;         x_trohdr_val_rec         INV_MOVE_ORDER_PUB.TROHDR_VAL_REC_TYPE;         l_validation_flag        VARCHAR2(2) := INV_MOVE_ORDER_PUB.G_VALIDATION_YES;           BEGIN       -- Get the user_id     SELECT user_id     INTO l_user_id     FROM fnd_user     WHERE user_name = l_user_name;     -- Get the application_id and responsibility_id     SELECT application_id, responsibility_id     INTO l_application_id, l_resp_id     FROM fnd_responsibility_vl     WHERE responsibility_name = l_resp_name;     FND_GLOBAL.APPS_INITIALIZE(l_user_id, l_resp_id, l_application_id);      dbms_output.put_line('Initialized applications context: '|| l_user_id || ' '|| l_resp_id ||' '|| l_application_id );                  -- Initialize the variables           l_trohdr_rec.date_required              :=   sysdate+2;           l_trohdr_rec.organization_id            :=   207;               l_trohdr_rec.from_subinventory_code     :=   'Stores';           l_trohdr_rec.to_subinventory_code       :=   'FGI';           l_trohdr_rec.status_date                :=   sysdate;           l_trohdr_rec.request_number             :=   'TEST_TRO1';           l_trohdr_rec.header_status           :=   INV_Globals.G_TO_STATUS_PREAPPROVED;   -- preApproved           l_trohdr_rec.transaction_type_id        :=   INV_GLOBALS.G_TYPE_TRANSFER_ORDER_SUBXFR; -- INV_GLOBALS.G_TYPE_TRANSFER_ORDER_STGXFR;             l_trohdr_rec.move_order_type              :=   INV_GLOBALS.G_MOVE_ORDER_REQUISITION; -- G_MOVE_ORDER_PICK_WAVE;           l_trohdr_rec.db_flag                    :=   FND_API.G_TRUE;           l_trohdr_rec.operation                  :=   INV_GLOBALS.G_OPR_CREATE;                  -- Who columns                  l_trohdr_rec.created_by                 :=  l_user_id;           l_trohdr_rec.creation_date              :=  sysdate;           l_trohdr_rec.last_updated_by            :=  l_user_id;           l_trohdr_rec.last_update_date           :=  sysdate;                         -- call API to create move order header          DBMS_OUTPUT.PUT_LINE('=======================================================');          DBMS_OUTPUT.PUT_LINE('Calling INV_MOVE_ORDER_PUB.Create_Move_Order_Header API');                     INV_MOVE_ORDER_PUB.Create_Move_Order_Header(                     P_API_VERSION_NUMBER   => l_api_version                 ,  P_INIT_MSG_LIST        => l_init_msg_list                 ,  P_RETURN_VALUES        => l_return_values                 ,  P_COMMIT               => l_commit                 ,  X_RETURN_STATUS        => x_return_status                 ,  X_MSG_COUNT            => x_msg_count                 ,  X_MSG_DATA             => x_msg_data                 ,  P_TROHDR_REC           => l_trohdr_rec                 ,  P_TROHDR_VAL_REC          => l_trohdr_val_rec                 ,  X_TROHDR_REC                => x_trohdr_rec                 ,  X_TROHDR_VAL_REC          => x_trohdr_val_rec                 ,  P_VALIDATION_FLAG        => l_validation_flag         );                       DBMS_OUTPUT.PUT_LINE('=======================================================');        DBMS_OUTPUT.PUT_LINE('Return Status: '||x_return_status);        IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN           DBMS_OUTPUT.PUT_LINE('Error Message :'||x_msg_data);        END IF;        IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN           DBMS_OUTPUT.PUT_LINE('Move Order Created Successfully');           DBMS_OUTPUT.PUT_LINE('Move Order Header ID : '||x_trohdr_rec.header_id);        END IF;        DBMS_OUTPUT.PUT_LINE('=======================================================');         EXCEPTION         WHEN OTHERS THEN           DBMS_OUTPUT.PUT_LINE('Exception Occured :');           DBMS_OUTPUT.PUT_LINE(SQLCODE ||':'||SQLERRM);           DBMS_OUTPUT.PUT_LINE('======================================================='); END XX_CreateMoveOrderHeader;