0 Replies Latest reply: Mar 22, 2011 6:06 AM by 784117 RSS

    Oracle Payables Automation Process

    784117
      Hiii All,

      I am trying to call "Mass Additions Create" program from "Payables Transfer to General ledger" program.
      Actually the "Payables Transfer to General ledger" program is a Oracle report.so i am trying to call that program using FND_REQUEST.SUBMIT_REQUEST.
      But i am facing a error

      Cause: FDPSTP failed due to ORA-06550: line 1, column 7:
      PLS-00306: wrong number or types of arguments in call to 'MASS_ADDITIONS_CREATE'
      ORA-06550: line 1, column 7:
      PL/SQL: Statement ignored

      But i have passed both the mandatory parameters GL_DATE and BOOK, even though im facing the error.

      Here it is my script

      DECLARE
      v_org_id number;
      v_gl_date date;
      v_book varchar2(200);
      req_id number;
      v_user_abc number;
      v_resp_id_abc number;
      v_appl_id_abc number;
      cursor c1 is select sysdate from dual;
      cursor c2 is select FND_PROFILE.VALUE('ORG_ID') from dual;
      cursor c3 is SELECT BOOK_TYPE_CODE FROM AP_FA_TABLE WHERE ORG_ID=v_org_id;

      BEGIN
      select user_id
      into v_user_abc
      from fnd_user
      where upper(user_name) = 'CLOVER1';

      select responsibility_id, application_id
      into v_resp_id_abc, v_appl_id_abc
      from fnd_responsibility_tl
      where upper(responsibility_name) ='SEBI HO PAYABLES'
      and language = 'US';

      fnd_global.APPS_INITIALIZE(v_user_abc,v_resp_id_abc,v_appl_id_abc);

      open c1;
      fetch c1 into v_gl_date;
      close c1;

      open c2;
      fetch c2 into v_org_id;
      close c2;

      open c3;
      fetch c3 into v_book;
      close c3;
      SRW.USER_EXIT('FND SRWINIT');
      IF (:p_debug_switch in ('y','Y')) THEN
      SRW.MESSAGE('1','After SRWINIT');
      END IF;

      SRW.MESSAGE ('15', 'Before trying to submit Mass Additions Create');

      req_id := FND_REQUEST.SUBMIT_REQUEST
      (
      'SQLAP', -- application short name
      'APMACR', -- program short name
      'Mass Additions Create', -- description
      NULL, -- start date
      FALSE, -- sub-request
      v_gl_date, --gl_date
      v_book, --book
      ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ',
      ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ',
      ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ',
      ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ',
      ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ',
      ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ',
      ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ',
      ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ',
      ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ',
      ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' '
      );

      IF NVL(req_id,0) = 0 THEN
      SRW.MESSAGE ('16', 'ERROR trying to submit Mass Additions Create');
      ELSE
      SRW.MESSAGE ('17', 'Mass Additions Create submitted successfully, Req.
      ID:'|| to_char(req_id));
      END IF;
      END;

      Thanks & Regards
      Ajay Kumar