Thursday 30 October 2014

How to make the Oracle report concurrent program ends with Error or Warning

In 'after report' trigger, use below piece of code:
---------for Error
function AfterReport return boolean is
  CNC_RET BOOLEAN;
  begin
begin
srw.USER_EXIT ('FND SRWEXIT');
IF :P_FUNCT_DTL  = 1
THEN
CNC_RET := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','Error Message ');
return (CNC_RET);
END IF;    
return (TRUE);
end; 
  return (TRUE);
end;

--------for warning
function AfterReport return boolean is
  CNC_RET BOOLEAN;
  begin
begin
srw.USER_EXIT ('FND SRWEXIT');
IF :P_FUNCT_DTL  = 1
THEN
CNC_RET := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',' Warning Message');
return (CNC_RET);
END IF;    
return (TRUE);
end; 
  return (TRUE);
end;

No comments:

Post a Comment