aonestar.public

Parameters

Name	Type	Mode
p_lang_code	text	IN

Definition

DECLARE
    v_state TEXT; v_message TEXT; v_detail TEXT; v_hint TEXT; v_context TEXT;
    v_doc_count int;
BEGIN
    SELECT count(*) INTO v_doc_count
    FROM public.precheckin_legal_document
    WHERE lang_code = p_lang_code;

IF v_doc_count > 0 THEN
        RETURN fn_result_error('60103',
            sys_msg('60103', 'Cannot delete a language that still has legal document content (%s row(s)). Remove or reassign that content first.'),
            v_doc_count::text);
    END IF;

DELETE FROM public.precheckin_language WHERE lang_code = p_lang_code;

IF NOT FOUND THEN
        RETURN fn_result_error('60104', sys_msg('60104', 'Language not found'));
    END IF;

RETURN fn_result_success(jsonb_build_object('lang_code', p_lang_code));
EXCEPTION WHEN OTHERS THEN
    GET STACKED DIAGNOSTICS
        v_state = RETURNED_SQLSTATE, v_message = MESSAGE_TEXT,
        v_detail = PG_EXCEPTION_DETAIL, v_hint = PG_EXCEPTION_HINT, v_context = PG_EXCEPTION_CONTEXT;
    RETURN fn_handle_error(v_state, v_message, v_detail, v_hint, v_context, 'sp_delete_precheckin_language',
        jsonb_build_object('lang_code', p_lang_code));
END