514: BEGIN
515: IF p_sob_id IS NOT NULL THEN
516: fv_utility.log_mesg
517: ('Deleting GTAS Attributes setup data for sob id: '||p_sob_id);
518: DELETE FROM FV_GTAS_ATTRIBUTES
519: WHERE set_of_books_id = p_sob_id;
520: ELSE
521: fv_utility.log_mesg
522: ('Deleting GTAS Attributes setup data for all set of books.');
519: WHERE set_of_books_id = p_sob_id;
520: ELSE
521: fv_utility.log_mesg
522: ('Deleting GTAS Attributes setup data for all set of books.');
523: DELETE FROM FV_GTAS_ATTRIBUTES;
524: END IF;
525:
526: fv_utility.log_mesg('Deleted from FV_GTAS_ATTRIBUTES');
527: EXCEPTION WHEN OTHERS THEN
522: ('Deleting GTAS Attributes setup data for all set of books.');
523: DELETE FROM FV_GTAS_ATTRIBUTES;
524: END IF;
525:
526: fv_utility.log_mesg('Deleted from FV_GTAS_ATTRIBUTES');
527: EXCEPTION WHEN OTHERS THEN
528: fv_utility.log_mesg
529: ('When others error when deleting GTAS Attributes setup data: '
530: ||SQLERRM);