This discussion is archived
0 Replies Latest reply: Mar 22, 2011 4:06 AM by 784117 RSS

Oracle Payables Automation Process

784117 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points