i use this pl/sql in dynamic action to date field when enter date it check period if it lock display message and if not lock insert date into table it's ok display message but the display like this
this is code '''' could you please anyone tell my why display look like that "
or is there anyway to display only the message
DECLARE
lck number;
BEGIN
select nvl(count(*),0) into lck from LOCKOPER where STAT=1 and :p78_DATE_BILL between FRM_DATE and TO_DATE;
if lck=0 then
INSERT INTO BILL_RECIV(no_brch,NO_GROP,NO_MEBER,TYP_BILL,NO_FUND,DATE_BILL,NO_BILL,STATUS_DOC,cur,eqv,DATE_OPR,DETAIL)
VALUES(br,:p78_NO_GROP,NO_MEm,:p78_TYPBILL,:p78_NO_FUND,:P78_DATE_BILL,Nobill,0,cur,1,:p78_OPR,' saving month '||:P78_D);
elsif lck=1 then
apex_util.set_session_state('this month is locked from manager');
end if;
END;
