Hello Jone,   you can create or update inventory item by using API (ego_item_pub.process_item) and this an example :  

Note : before using both API’s be aware that we are not committing the changes. You have to perform explicit commit manually from IDE or set parameter (p_commit = ‘T’) to commit your changes.

1. Create new inventory item using this API example:

DECLARE
  l_inventory_item_id   NUMBER;
  l_organization_id     NUMBER;
  l_return_status       VARCHAR2 (4000);
  l_msg_data            VARCHAR2 (4000);
  l_msg_count           NUMBER;
  x_message_list        error_handler.error_tbl_type;
BEGIN
  fnd_global.apps_initialize (user_id => 1318, --> OPERATIONS
                              resp_id => 50583, --> Inventory, Vision Operations (USA)
                              resp_appl_id => 401); --> Inventory

  ego_item_pub.process_item (p_api_version                  => 1.0
                            ,p_init_msg_list                => 'T' -- (F:- False), (T:- True)
                            ,p_commit                       => 'F' -- (F:- False), (T:- True)
                            ,p_transaction_type             => 'CREATE' -- UPDATE FOR Updating item
                            ,p_segment1                     => 'Oraask_Item01' -- ITEM CODE
                            ,p_description                  => 'Oraask Test Item Description' -- ITEM DESCRIPTION
                            ,p_long_description             => 'Oraask Test Long Item Description' -- ITEM LONG DESCRIPTION
                            ,p_organization_id              => 204 -- Vision Operations
                            ,p_apply_template               => 'ALL'
                            ,p_template_id                  => 2 -- Purchased Item — select * from mtl_item_templates_vl
                            -- P_TEMPLATE_NAME => '@Purchased Item',
                            -- P_ITEM_TYPE => 'P',
                            ,p_inventory_item_status_code   => 'Active'
                            ,p_approval_status              => 'A'
                            ,x_inventory_item_id            => l_inventory_item_id
                            ,x_organization_id              => l_organization_id
                            ,x_return_status                => l_return_status
                            ,x_msg_count                    => l_msg_count
                            ,x_msg_data                     => l_msg_data);

  IF l_return_status = fnd_api.g_ret_sts_success THEN
    dbms_output.put_line ('Item is Created Successfully, Inventory Item ID : ' || l_inventory_item_id);

  ELSE
    dbms_output.put_line ('Item Creation is Failed');
    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;

    ROLLBACK;
  END IF;
--> EXCEPTIONS HANDLING PART
EXCEPTION
  WHEN OTHERS THEN
    FOR i IN 1 .. l_msg_count
    LOOP
      dbms_output.put_line (substr (fnd_msg_pub.get (p_encoded => fnd_api.g_false), 1, 255));
      dbms_output.put_line ('message is: ' || l_msg_data);
    END LOOP;
END;

• Update existing inventory item using this API example:

DECLARE
  l_inventory_item_id   NUMBER;
  l_organization_id     NUMBER;
  l_return_status       VARCHAR2 (4000);
  l_msg_data            VARCHAR2 (4000);
  l_msg_count           NUMBER;
  x_message_list        error_handler.error_tbl_type;
BEGIN
  fnd_global.apps_initialize (user_id => 1318, --> OPERATIONS
                              resp_id => 50583, --> Inventory, Vision Operations (USA)
                              resp_appl_id => 401); --> Inventory
 
  ego_item_pub.process_item (p_api_version                  => 1.0
                            ,p_init_msg_list                => 'T' -- (F:- False), (T:- True)
                            ,p_commit                       => 'F' -- (F:- False), (T:- True)
                            ,p_transaction_type             => 'UPDATE' -- UPDATE FOR Updating item
                            ,p_Inventory_Item_Id            => 53899
                            ,p_description                  => 'Oraask test description' -- ITEM DESCRIPTION
                            ,p_organization_id              => 204 -- Vision Operations
                            ,x_inventory_item_id            => l_inventory_item_id
                            ,x_organization_id              => l_organization_id
                            ,x_return_status                => l_return_status
                            ,x_msg_count                    => l_msg_count
                            ,x_msg_data                     => l_msg_data);
 
  IF l_return_status = fnd_api.g_ret_sts_success THEN
    dbms_output.put_line ('Inventory Item has been updated Successfully, Inventory Item ID : ' || l_inventory_item_id);

  ELSE
    dbms_output.put_line ('Update inventory item is Failed');
    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;
 
    ROLLBACK;
  END IF;
--> EXCEPTIONS HANDLING PART
EXCEPTION
  WHEN OTHERS THEN
    FOR i IN 1 .. l_msg_count
    LOOP
      dbms_output.put_line (substr (fnd_msg_pub.get (p_encoded => fnd_api.g_false), 1, 255));
      dbms_output.put_line ('message is: ' || l_msg_data);
    END LOOP;
END;

— By executing above code we have updated item description to be “Oraask test description” for inventory item id “53899”

Hopefully, this code snippet helps you 🙂

hi Albert,

You can display a message in Oracle report builder by using the standard built-in srw.message.

The basic syntax for using this package is:

srw.message(error_no,'YOUR MESSAGE');

the error no will appear along with the message text. and here is the sample to do this in a particular function

FUNCTION chck_sal RETURN BOOLEAN IS
BEGIN
  IF :sal < 0 THEN SRW.MESSAGE(
    100,
    'There is employee that take negative salary.'
  );
RAISE SRW.PROGRAM_ABORT;
ELSE :bonus := :sal * .01;
END IF;
RETURN(TRUE);
END;