Inventory api in oracle apps r12

Inventory api in oracle apps r12

In this post , We will discuss about Inventory API uses to create the Inventory items in Oracle apps. Oracle has provided the standard API to create the Inventory Items from the backend. We don't need to use the Item interface to create the Inventory items but we can use the API directly which helps to create the Inventory item in oracle apps. Here below is the complete script using Inventory api in oracle apps r12.

Example using Inventory api in oracle apps r12

DECLARE

 

 

l_item_table EGO_Item_PUB.Item_Tbl_Type;

v_item_tabl_type EGO_Item_PUB.Item_Tbl_Type;

x_return_status VARCHAR2(1);

x_msg_count NUMBER(10);

x_msg_data VARCHAR2(1000);

x_message_list Error_Handler.Error_Tbl_Type;

BEGIN

 

 

FND_GLOBAL.APPS_INITIALIZE(USER_ID=>2524,RESP_ID=>20634,RESP_APPL_ID=>401);

l_item_table(1).Transaction_Type := 'CREATE'; -- Replace this with 'UPDATE' for update transaction.

l_item_table(1).Segment1 := '001100002234'; -- item code---

l_item_table(1).Description := 'TEST ITEM'; -- item description----

l_item_table(1).Organization_Code := 'IMO'; --inventory master org code--

l_item_table(1).Template_Name := '@PURCHASED GOOD'; -- inventory template name from which item will inherit the item attributes values--

 

 

EGO_ITEM_PUB.Process_Items(

p_api_version => 1.0

,p_init_msg_list => FND_API.g_TRUE

,p_commit => FND_API.g_TRUE

,p_Item_Tbl => l_item_table

,x_Item_Tbl =>v_item_tabl_type

,x_return_status => x_return_status

,x_msg_count => x_msg_count);

DBMS_OUTPUT.PUT_LINE('API Return Status ==>' ||x_return_status);

IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

DBMS_OUTPUT.PUT_LINE('SUCCESS');

FOR i IN 1..v_item_tabl_type.COUNT LOOP

DBMS_OUTPUT.PUT_LINE('Inventory Item Id Created:'||to_char(v_item_tabl_type(i).Inventory_Item_Id));

DBMS_OUTPUT.PUT_LINE('Organization Id :'||to_char(v_item_tabl_type(i).Organization_Id));

END LOOP;

ELSE

DBMS_OUTPUT.PUT_LINE('Error Messages :');

Error_Handler.GET_MESSAGE_LIST(x_message_list=>x_message_list);

FOR i IN 1..x_message_list.COUNT LOOP

DBMS_OUTPUT.PUT_LINE(x_message_list(i).message_text);

END LOOP;

END IF;

EXCEPTION

WHEN OTHERS THEN

DBMS_OUTPUT.PUT_LINE('Error has Occured and error is '||SUBSTR(SQLERRM,1,200));

END;