Oracle Reports (MOSC)

MOSC Banner

Ending Oracle rdf report in warning

edited Jul 17, 2018 5:01AM in Oracle Reports (MOSC) 6 commentsAnswered ✓

Hi,

please let us know how to end  Oracle Rdf report in warning status based on some condition.

We tried below thing but it is not working

function AfterReport return boolean is
l_status boolean;
begin
srw.MESSAGE(112,'AfterReport- Before condition');
if :CS_1 > '0'
then
srw.MESSAGE(112,'AfterReport- within condition');
   l_status:=fnd_concurrent.set_completion_status('WARNING','WARNING: The CZK rate is not available');
   srw.MESSAGE(112,'AfterReport- warning status set');
   COMMIT;
   end if;
  return (l_status);
end;

Thanks,
Prasanna

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center