1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Value set

Discussion in 'Oracle Apps Technical' started by venkat1234, Nov 6, 2013.

  1. venkat1234

    venkat1234 Active Member

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    100
    Location:
    Hyderabad
    Hello everyone...
    I have a doubt when creating a value set from backend...:confused:

    what is SESSION_MODE???
    and why it is mandatory???
    and why taking customer_data only???
    I have checked from so many websites regarding this..but no use.

    FND_FLEX_VAL_API.SET_SESSION_MODE('customer_data');/*Mandatory*/

    awaiting for ur reply...:)

    Thanks & Regards,
    Venki.
     
  2. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi,

    That is used to know 'WHO' information.

    PROCEDURE set_session_mode(session_mode IN VARCHAR2) IS
    BEGIN
    IF(session_mode NOT IN ('customer_data', 'seed_data')) THEN
    message('bad mode:'|| session_mode);
    message('valid values are: customer_data, seed_data');
    RAISE bad_parameter;
    END IF;
    who_mode := session_mode;
    END;