Apps Initialization Script | Script To Set Context and Profile Values From Back-End in R12 Oracle apps

Following script can be very handy if you want to initialize apps and set Org context:

FUNCTION set_context( i_user_name    IN  VARCHAR2

                     ,i_resp_name    IN  VARCHAR2

                     ,i_org_id       IN  NUMBER)

RETURN VARCHAR2

IS

v_user_id             NUMBER;

v_resp_id             NUMBER;

v_resp_appl_id NUMBER;

v_lang                   VARCHAR2(100);

v_session_lang VARCHAR2(100):=fnd_global.current_language;

v_return              VARCHAR2(10):='T';

v_nls_lang          VARCHAR2(100);

v_org_id              NUMBER:=i_org_id;

/* Cursor to get the user id information based on the input user name */

CURSOR cur_user

IS

    SELECT     user_id

    FROM       fnd_user

    WHERE      user_name  =  i_user_name;

/* Cursor to get the responsibility information */

CURSOR cur_resp

IS

    SELECT     responsibility_id

                     ,application_id

                    ,language

    FROM       fnd_responsibility_tl

    WHERE      responsibility_name  =  i_resp_name;

/* Cursor to get the nls language information for setting the language context */

CURSOR cur_lang(p_lang_code VARCHAR2)

IS

    SELECT    nls_language

    FROM      fnd_languages

    WHERE     language_code  = p_lang_code;

BEGIN

    /* To get the user id details */

    OPEN cur_user;

    FETCH cur_user INTO v_user_id;

    IF cur_user%NOTFOUND

    THEN

        v_return:='F';

       

    END IF; --IF cur_user%NOTFOUND

    CLOSE cur_user;

    /* To get the responsibility and responsibility application id */

    OPEN cur_resp;

    FETCH cur_resp INTO v_resp_id, v_resp_appl_id,v_lang;

    IF cur_resp%NOTFOUND

    THEN

        v_return:='F';

       

    END IF; --IF cur_resp%NOTFOUND

    CLOSE cur_resp;

    /* Setting the oracle applications context for the particular session */

    fnd_global.apps_initialize ( user_id      => v_user_id

                                ,resp_id      => v_resp_id

                                ,resp_appl_id => v_resp_appl_id);

    /* Setting the org context for the particular session */

    mo_global.set_policy_context('S',v_org_id);

    /* setting the nls context for the particular session */

    IF v_session_lang != v_lang

    THEN

        OPEN cur_lang(v_lang);

        FETCH cur_lang INTO v_nls_lang;

        CLOSE cur_lang;

        fnd_global.set_nls_context(v_nls_lang);

    END IF; --IF v_session_lang != v_lang

    RETURN v_return;

EXCEPTION

WHEN OTHERS THEN

    RETURN 'F';

END set_context;

Other Important Articles Related To Concurrent Programs:

1. Different Concurrent Program Executable Methods In Oracle Apps
2. How To Find All The Running Concurrent Requests And The Time Taken By Them
3. Meaning Of Different Status Codes And Phase Codes Used In Concurrent Programs
4. SQL Query To Find Scheduled Or On Hold Concurrent Request
5. SQL Query To Find Parameters and Value Sets Associated With A Concurrent Program
6. SQL Query To Find The Request Group Using An Executable | Important Apps Queries
7. SQL Script To Get Concurrent Program Details & Paraments