Thursday 29 June 2017

How to Show Customize Error in WEBADI GL Sheets - Oracle EBS R12

http://generalledger-gl.blogspot.com/2017/06/to-show-customize-error-in-webadi-gl.html

How to Show Customize Error in WEBADI GL Sheets

CREATE OR REPLACE TRIGGER GL_INTERFACE_before_insert

  BEFORE INSERT

ON "GL"."GL_INTERFACE#"

  FOR EACH ROW

DECLARE

BEGIN

  if :new.entered_dr < 0 or :new.accounted_dr < 0 then

    RAISE_APPLICATION_ERROR(
                         
                            num => -20107,
                         
                            msg => 'Negative DR');

  end if;

  if :new.entered_cr < 0 or :new.accounted_cr < 0 then

    RAISE_APPLICATION_ERROR(
                         
                            num => -20107,
                         
                            msg => 'Negative CR');

  end if;

END;