Im tyring to display a canvas (stacked) on top of a content canvas.. for some reason i cant get it to work properly.. any help would be appreciated... This is the trigger i created...
BEGIN
DECLARE
v_status varchar2(1) := null;
mesg varchar2(70) := null;
return_alert number;
BEGIN
--
show_view('IN_PROGRESS');
--
-- Call the Forms Procedure to run Pension
-- Calculations.
--
OF_CALC_BLOCK10.display_item21,:BLOCK10.display_item25,:BLOCK10.display_item27);
--
--
--- If program gets to this point then the calculations ran ok
--
:BLOCK10.display_item55 := v_status;
mesg := ('Pension Calculation Completed Successfully');
ALERTS(mesg);
--
--- Hide View
--
hide_view('IN_PROGRESS');
--
EXCEPTION
WHEN OTHERS THEN
MESSAGE(sqlerrm);
mesg := ('Pension Calculation Completed UnSuccessfully, Read Error Message below');
ALERTS(mesg);
RAISE FORM_TRIGGER_FAILURE;
END;
END;
Tony
tonyworc@charter.net
BEGIN
DECLARE
v_status varchar2(1) := null;
mesg varchar2(70) := null;
return_alert number;
BEGIN
--
show_view('IN_PROGRESS');
--
-- Call the Forms Procedure to run Pension
-- Calculations.
--
OF_CALC_BLOCK10.display_item21,:BLOCK10.display_item25,:BLOCK10.display_item27);
--
--
--- If program gets to this point then the calculations ran ok
--
:BLOCK10.display_item55 := v_status;
mesg := ('Pension Calculation Completed Successfully');
ALERTS(mesg);
--
--- Hide View
--
hide_view('IN_PROGRESS');
--
EXCEPTION
WHEN OTHERS THEN
MESSAGE(sqlerrm);
mesg := ('Pension Calculation Completed UnSuccessfully, Read Error Message below');
ALERTS(mesg);
RAISE FORM_TRIGGER_FAILURE;
END;
END;
Tony
tonyworc@charter.net