form里提交报表出现的错误
declare
g_request_id number;
g_error_dsc varchar2(100);
begin
g_request_id := fnd_request.submit_request('AR','XXFIN008','',to_char(SYSDATE,'DD-MON-YYYY HH24:MI'),false,
'USD','200001','01','01','','','','','','','','','','','','','','','','',
'','','','','','','','','','', '','','','','','','','','','',
'','','','','','','','','','', '','','','','','','','','','',
'','','','','','','','','','', '','','','','','','','','','',
'','','','','','','','','','', '','','','','','','','','',''
);
if g_request_id = 0 then
rollback;
g_error_dsc := sqlerrm;
fnd_message.set_string(g_error_dsc);
fnd_message.error;
raise form_trigger_failure;
else
commit;
fnd_message.set_string('并发请求已经提交');
fnd_message.show;
end if;
end;
|