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!

calling Journal import concurrent program from PL/SQL

Discussion in 'Oracle Financials' started by meenu_contact@yahoo.com, Jul 5, 2010.

  1. meenu_contact@yahoo.com

    meenu_contact@yahoo.com Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    My concurrent program returns 0 while executing the following code.

    ln_request_id := fnd_request.submit_request ( application => 'SQLGL',
    program => 'GLLEZL',
    description => null,
    start_time => SYSDATE,
    sub_request => FALSE,
    argument1 => to_char(p_iface_run_id),
    argument2 => to_char(ln_sob_id),
    argument3 => 'N', -- Post errors to suspense
    argument4 => NULL, -- Start Date
    argument5 => NULL, -- End Date
    argument6 => 'N', -- Create Summary Journal
    argument7 => 'N' -- Import DF
    );

    Can anyone help me ?

    thanks
    Meenakshi
     
  2. sskhatri1

    sskhatri1 Guest

    Kindly capture why the API is returing with 0.

    If ln_request_id = 0 THEN
    DBMS_OUTPUT.PUT_LINE('ERROR = '||SQLCODE||'/'||SQLERRM);
    End If;
     
  3. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi Meenakshi,

    Try the following code and post the error message what you are getting:

    Code (Text):

    declare
    n_request_id number;
    p_iface_run_id number;
    ln_sob_id number;
    begin
    n_request_id := fnd_request.submit_request ( application => 'SQLGL',
    program => 'GLLEZL',
    description => null,
    start_time => SYSDATE,
    sub_request => FALSE,
    argument1 => to_char(p_iface_run_id),
    argument2 => to_char(ln_sob_id),
    argument3 => 'N', -- Post errors to suspense
    argument4 => NULL, -- Start Date
    argument5 => NULL, -- End Date
    argument6 => 'N', -- Create Summary Journal
    argument7 => 'N' -- Import DF
    );
    exception when others then
    dbms_output.put_line(sqlerrm);
    end;

     
    Initiate the values at declare statement level and try to run this program