How to use APPS_INITIALIZE

How to use APPS_INITIALIZE
------------------------------------------------------------------------------------------------------------------------


What is APPS_INITIALIZE :- 
FND_GLOBAL.APPS_INITIALIZE is used for proving the environment where we can initialize the session before calling any public or private API's in Oracle Ebusiness Suite.
also, we are able to use all profile option which oracle provide from the frontend.


SYNTAX:- 

fnd_global.APPS_INITIALIZE
(
user_id=>l_user_id,  /* l_user_id is the fnd user ID */
resp_id=>l_resp_id,  /* l_resp_id is the responsibility ID */
resp_appl_id=>l_resp_appl_id /* l_resp_appl_id is the responsibility application ID */
);

-----------------------------------------------------------------------------------------------------------------------

 Environment Values:- 

fnd_profile
fnd_profile.VALUE('PROFILEOPTION')
fnd_profile
fnd_profile.VALUE('MFG_ORGANIZATION_ID')
fnd_profile
fnd_profile.VALUE('ORG_ID')
fnd_profile
fnd_profile.VALUE('LOGIN_ID')
fnd_profile
fnd_profile.VALUE('USER_ID')
fnd_profile
fnd_profile.VALUE('USERNAME')
fnd_profile
fnd_profile.VALUE('CONCURRENT_REQUEST_ID')
fnd_profile
fnd_profile.VALUE('GL_SET_OF_BKS_ID')
fnd_profile
fnd_profile.VALUE('SO_ORGANIZATION_ID')
fnd_profile
fnd_profile.VALUE('APPL_SHRT_NAME')
fnd_profile
fnd_profile.VALUE('RESP_NAME')
fnd_profile
fnd_profile.VALUE('RESP_ID')
fnd_profile
fnd_profile.VALUE('PER_BUSINESS_GROUP_ID')
fnd_profile
fnd_profile.VALUE('GL_SET_OF_BKS_ID')
fnd_profile
fnd_profile.VALUE('CURRENT_ORG_CONTEXT')


fnd_global
fnd_global.USER_ID
fnd_global
fnd_global.USER_NAME
fnd_global
fnd_global.RESP_ID
fnd_global
fnd_global.RESP_NAME
fnd_global
fnd_global.APPLICATION_NAME
fnd_global
fnd_global.APPLICATION_SHORT_NAME
fnd_global
fnd_global.RESP_APPL_ID
fnd_global
fnd_global.BASE_LANGUAGE
fnd_global
fnd_global.CONC_LOGIN_ID
fnd_global
fnd_global.CONC_PRIORITY_REQUEST
fnd_global
fnd_global.CONC_PROCESS_ID
fnd_global
fnd_global.CONC_PROGRAM_ID
fnd_global
fnd_global.CONC_QUEUE_ID
fnd_global
fnd_global.CONC_REQUEST_ID
fnd_global
fnd_global.CURRENT_LANGUAGE
fnd_global
fnd_global.CUSTOMER_ID
fnd_global
fnd_global.EMPLOYEE_ID
fnd_global
fnd_global.FORM_APPL_ID
fnd_global
fnd_global.FORM_ID
fnd_global
fnd_global.GET_SESSION_CONTEXT
fnd_global
fnd_global.LANGUAGE_COUNT
fnd_global
fnd_global.LOGIN_ID
fnd_global
fnd_global.NEWLINE
fnd_global
fnd_global.NLS_DATE_FORMAT
fnd_global
fnd_global.NLS_DATE_LANGUAGE
fnd_global
fnd_global.NLS_LANGUAGE
fnd_global
fnd_global.NLS_NUMERIC_CHARACTERS
fnd_global
fnd_global.NLS_SORT
fnd_global
fnd_global.NLS_TERRITORY
fnd_global
fnd_global.ORG_ID
fnd_global
fnd_global.ORG_NAME
fnd_global
fnd_global.PARTY_ID
fnd_global
fnd_global.PER_BUSINESS_GROUP_ID
fnd_global
fnd_global.PER_SECURITY_PROFILE_ID
fnd_global
fnd_global.PROG_APPL_ID
fnd_global
fnd_global.QUEUE_APPL_ID
fnd_global
fnd_global.RT_TEST_ID
fnd_global
fnd_global.SECURITY_GROUP_ID
fnd_global
fnd_global.SERVER_ID
fnd_global
fnd_global.SESSION_ID
fnd_global
fnd_global.SUPPLIER_ID
fnd_global
fnd_global.TAB


Frontend:-



CREATE OR REPLACE PROCEDURE XXSD_APPS_INITIALIZE_PROC  (
ERRBUF    OUT   VARCHAR2,
RETCODE   OUT   NUMBER
) AS

BEGIN

fnd_file.put_line (fnd_file.log,(' User_id :- '|| FND_GLOBAL.USER_ID));
fnd_file.put_line (fnd_file.log,(' Application_id:- '||FND_GLOBAL.RESP_APPL_ID));
fnd_file.put_line (fnd_file.log,(' Responsibility_id :- '|| FND_GLOBAL.RESP_ID));

fnd_file.put_line (fnd_file.log,(' (P) Business_Group_id:- '||fnd_profile.VALUE('PER_BUSINESS_GROUP_ID')));
fnd_file.put_line (fnd_file.log,(' (P) User_id :- '|| fnd_profile.VALUE('USER_ID')));
fnd_file.put_line (fnd_file.log,(' (P) User_Name :- '|| fnd_profile.VALUE('USERNAME')));
fnd_file.put_line (fnd_file.log,(' (P) Responsibility_id :- '|| fnd_profile.VALUE('RESP_ID')));
fnd_file.put_line (fnd_file.log,(' (P) Responsibility_Name :- '|| fnd_profile.VALUE('RESP_NAME')));

END;







Log:-
XXSD_APPS_INITIALIZE_PROC: XXSD APPS INITIALIZE PROGRAM
+---------------------------------------------------------------------------+

Current system time is 11-AUG-2019 11:23:37

+---------------------------------------------------------------------------+

**Starts**11-AUG-2019 11:23:38
**Ends**11-AUG-2019 11:23:38
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
 User_id :- 15790
 Application_id:- 0
 Responsibility_id :- 20419

 (P) Business_Group_id:- 81
 (P) User_id :- 15790
 (P) User_Name :- DEVELOPER
 (P) Responsibility_id :- 20419
 (P) Responsibility_Name :- Application Developer

+---------------------------------------------------------------------------+

Backend:-

create or replace PROCEDURE XXSD_REPORT_SUBMIT_PROC (
      errbuf               OUT   NUMBER,
      retcode              OUT   VARCHAR2) AS

--DECLARE
      l_request_id         NUMBER;
      v_phase              VARCHAR2 (20);
      v_dev_phase          VARCHAR2 (20);
      v_dev_status         VARCHAR2 (20);
      v_message            VARCHAR2 (20);
      v_wait_status        VARCHAR2 (20);
      l_return_status      BOOLEAN;
      e_submit_error       EXCEPTION;
      e_program_status     EXCEPTION;
      e_program_status1    EXCEPTION;
      v_lay                BOOLEAN;


BEGIN

--FND_GLOBAL.APPS_INITIALIZE(
--      user_id      => 15790  /* USER_ID  => DEVELOPER*/
--   ,  resp_id      => 20419  /* RESPONSIBILITY_ID => Application Developer*/
--   ,  resp_appl_id => 0  /* APPLICATION_ID => Application Object Library */
--        );

FND_GLOBAL.APPS_INITIALIZE(
      user_id      => 1147  /* USER_ID => MANISH.KUMAR*/
   ,  resp_id      => 20639  /* RESPONSIBILITY_ID =>   Payables Manager*/
   ,  resp_appl_id => 200  /* APPLICATION_ID  => Payables*/
        );



                                    
         l_request_id :=
         fnd_request.submit_request
                            (application       => 'XXSD',
                             program          => 'XXSD_APPS_INITIALIZE_PROC',
                             description       => 'XXSD_APPS_INITIALIZE_PROC',
                             start_time        => SYSDATE,
                             sub_request     => FALSE
                            );

         COMMIT;


         IF l_request_id = 0  THEN
            fnd_file.put_line (fnd_file.LOG, 'Request Not Submitted');
         ELSIF l_request_id != 0
         THEN
            fnd_file.put_line (fnd_file.LOG,  'Request Submitted : ' || l_request_id );
         fnd_file.put_line (fnd_file.LOG,'(XXSD APPS INITIALIZE PROGRAM ) || '|| v_dev_phase||' With '||v_dev_status);                    

         END IF;      


EXCEPTION WHEN OTHERS  THEN

fnd_file.put_line (fnd_file.LOG, 'Errored In exception'||SQLERRM);
END;



------------------------------  Submit Program -------------------------------

declare
V_CODE VARCHAR2(100);
V_ERROR VARCHAR2(100);
V_DEPT_NO NUMBER:= 10;
begin
XXSD_REPORT_SUBMIT_PROC(V_CODE, V_ERROR);
end;


Program LOG:- 


XXSD_APPS_INITIALIZE_PROC: XXSD APPS INITIALIZE PROGRAM
+---------------------------------------------------------------------------+
 
Current system time is 11-AUG-2019 11:24:50
 
+---------------------------------------------------------------------------+
 
**Starts**11-AUG-2019 11:24:50
**Ends**11-AUG-2019 11:24:50
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
 User_id :- 1147
 Application_id:- 200
 Responsibility_id :- 20639
 
 (P) Business_Group_id:- 81
 (P) User_id :- 1147
 (P) User_Name :- MANISH.KUMAR
 (P) Responsibility_id :- 20639
 (P) Responsibility_Name :- Payables Manager
 
+---------------------------------------------------------------------------+










Comments

Post a Comment

Popular posts from this blog

E-Text Report In Fusion | Types of E-Text reports

 WHAT IS Oracle Fusion E-Text Report ? An eText template is an RTF-based template that is used to generate text output  for Electronic Funds Transfer (EFT) and Electronic Data Interchange (EDI). How it generate the output for User or Bank? At runtime, BI Publisher applies this template to an input XML data file to create an output text file. that can be transmitted to a bank or other customer.  Because the output is intended for electronic communication, the eText templates must follow very specific format instructions for exact placement of data. Example :- Bank payment file , Bank MT940 File .. etc what is look and feel of this file ? Note:  There are two types of eText templates:  1. fixed-position based (EFT templates)  2. Delimiter-based (EDI templates) What IS EFT File? An EFT is an electronic transmission of financial data and payments to banks in a specific fixed-position format flat file (text). Link for download:- EFT :-  https://docs.google.com/document/d/14xAYceq2hx8WIy3Iux
Read more

Supplier API's

API's for Create Supplier, Create Supplier Site, Create Supplier Site Contacts --======================================================================= -------------Supplier API ------------- 1. First Write a CURSOR for Required Data 2. FND_GLOBAL.APPS_INITIALIZE 3. Pass required Values in Proper way. 4. API :- For Supplier Create (pos_vendor_pub_pkg.create_vendor)    API :- For Supplier Site Create (pos_vendor_pub_pkg.create_vendor_site)    API :- For Supplier Create Contact (ap_vendor_pub_pkg.create_vendor_contact) 5. Run API 6. Checking ------------------------------  Query For APPS_INITIALIZE   --------------------------------------------- select 'USER_ID' REMARKS , user_name NAME, user_id ID from fnd_user where user_name like 'DEVELOPER' union select 'RESPONSIBILITY_ID' NAME, responsibility_name , RESPONSIBILITY_ID from fnd_responsibility_tl where responsibility_name like 'Payables Manager' union s
Read more

How to pass default Parameter in cursor

--==================================================== --Parameterized Cursors /* Syntax of Parameterized Cursor :- CURSOR cur _ name (parameter list may be one, two, or more or Default ) IS SELECT statement; OPEN cur _ name (Parameter value) */ EMPNO ENAME HIREDATE DOB GENDER SAL DEPTNO COMM 1000 Sachin 11-Sep-85 01-Mar-20 M 25000 20 1002 Rena 01-Aug-82 11-Mar-20 F 125000 20 1008 Sonu 11-Sep-85 01-Mar-20 M 2500 10 100 1003 Chavi 25-Mar-81 15-Feb-20 F 5000 20 1006 Ravi 11-Sep-89 01-Mar-19 M 2500 10 100 1005 Vinod 18-Sep-86 01-Mar-20
Read more