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;
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;
No comments:
Post a Comment