v_rec_id number;
v_sort_order number;
BEGIN
   v_rec_id := get_rec_id;
   v_sort_order := get_sort_order(p_report_no, p_report_yr);
    insert into assist_report_requests (rec_id, report_yr, report_no, req_no, req_yr, create_user, create_date,print_counter, sort_order) 
                                values (v_rec_id, p_report_no, p_report_yr, p_req_no, p_req_yr, user, sysdate,0, v_sort_order);

commit;
exception when others then
    message('Error Code: '||sqlcode||' Error Message: '||sqlerrm);
    raise form_trigger_failure;
END;