Annotation: core.party_before_update_trigger

Information: core.party_before_update_trigger

Implementation: core.party_before_update_trigger

CREATE OR REPLACE FUNCTION core.party_before_update_trigger()
 RETURNS trigger
 LANGUAGE plpgsql
AS $function$
    DECLARE _parent_currency_code text;
BEGIN
    
    --Get currency code of associated GL head.
    _parent_currency_code := core.get_currency_code_by_party_id(NEW.party_id);


    IF(NEW.currency_code != _parent_currency_code) THEN
        RAISE EXCEPTION 'You cannot have a different currency on the mapped GL account.';
    END IF;

    IF(NEW.account_id IS NULL) THEN
        RAISE EXCEPTION 'The column account_id cannot be null.';
    END IF;
    
    RETURN NEW;
END
$function$