Hello Aashish,

There are three common means of passing parameters between pages :
Request
Transaction
Session

and you can use VO attributes for passing values
Values stored in VO attributes are available in all pages within the transaction with same Root AM.

URL Parameters : Encryption and Encoding
When we are passing parameters in URL, following need to be considered:

[code]
{@Attr} – encodes. Changes Prince Kapoor to Prince%20Kapoor
{!Attr} – encrypts. Encrypts sensitive information.
{$Attr} – plain token substitution (no encoding or encryption)
{@@RETURN_TO_MENU} – Used for E-Business Suite Personal Home Page. Same as OAWebBeanConstants.RETURN_TO_MENU_URL.
{@@RETURN_TO_PORTAL} – Return the user to a launching Portal page. Same as OAWebBeanConstants.RETURN_TO_PORTAL_URL.
[/code]

Hi Saly,

Actually you can achieve this by simulate HTTP redirect by using one of the following :

// similar behavior as an HTTP redirect

[code]window.location.replace(“http://www.oraask.com”);[/code]

or

// similar behavior as clicking on a link

[code]window.location.href(“http://www.oraask.com”);[/code]

at the end this your choice but for my suggestion i prefer using  (window.location.replace) because this doesn’t keep originate page in the session history.

hope this help.

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 🙂