mscmp_syst_hierarchy.ms_syst

Parameters

Name	Type	Mode
		IN

Definition

-- File:        trig_b_i_syst_hierarchy_items_hierarchy_prereqs.eex.sql
-- Location:    musebms/database/components/system/mscmp_syst_hierarchy/ms_syst_data/syst_hierarchy_items/trig_b_i_syst_hierarchy_items_hierarchy_prereqs.eex.sql
-- Project:     Muse Systems Business Management System
--
-- Copyright © Lima Buttgereit Holdings LLC d/b/a Muse Systems
-- This file may include content copyrighted and licensed from third parties.
--
-- See the LICENSE file in the project root for license terms and conditions.
-- See the NOTICE file in the project root for copyright ownership information.
--
-- muse.information@musesystems.com :: https://muse.systems

DECLARE

v_context_data record;

BEGIN

SELECT INTO v_context_data
        eft.internal_name = 'hierarchy_states_active' AS is_active
      , ch.structured
    FROM
        ms_syst_data.syst_hierarchies ch
            JOIN ms_syst_data.syst_enum_items ei
                 ON ei.id = ch.hierarchy_state_id
            JOIN ms_syst_data.syst_enum_functional_types eft
                 ON eft.id = ei.functional_type_id
    WHERE ch.id = new.hierarchy_id;

CASE
        WHEN v_context_data.is_active THEN

RAISE EXCEPTION
                USING
                    MESSAGE = 'Inserting Hierarchy Item records may only be ' ||
                              'done when the parent Hierarchy is in an ' ||
                              '"inactive" state.',
                    DETAIL  = ms_syst_priv.get_exception_details(
                                 p_proc_schema    => 'ms_appl_data'
                                ,p_proc_name      =>
                                    'trig_b_i_syst_hierarchy_items_hierarchy_prereqs'
                                ,p_param_data     => to_jsonb( new )
                                ,p_context_data   =>
                                    jsonb_build_object(
                                         'tg_op',         tg_op
                                        ,'tg_when',       tg_when
                                        ,'tg_schema',     tg_table_schema
                                        ,'tg_table_name', tg_table_name)),
                    ERRCODE = 'PM106',
                    SCHEMA  = tg_table_schema,
                    TABLE   = tg_table_name;

WHEN NOT v_context_data.structured THEN

RAISE EXCEPTION
                USING
                    MESSAGE = 'Hierarchy Item records may not be inserted ' ||
                              'for unstructured Hierarchies.',
                    DETAIL  = ms_syst_priv.get_exception_details(
                                 p_proc_schema    => 'ms_appl_data'
                                ,p_proc_name      =>
                                    'trig_b_i_syst_hierarchy_items_hierarchy_prereqs'
                                ,p_param_data     => to_jsonb( new )
                                ,p_context_data   =>
                                    jsonb_build_object(
                                         'tg_op',         tg_op
                                        ,'tg_when',       tg_when
                                        ,'tg_schema',     tg_table_schema
                                        ,'tg_table_name', tg_table_name)),
                    ERRCODE = 'PM107',
                    SCHEMA  = tg_table_schema,
                    TABLE   = tg_table_name;

ELSE

RETURN new;

END CASE;

END;

trig_b_i_syst_hierarchy_items_hierarchy_prereqs()

Description

Parameters

Definition