0025317: Empty error message when inserting a incorrect m_transaction line when there is not symbol for the unit of meassure

Description

Empty error message when inserting a incorrect m_transaction line when there is not symbol for the unit of meassure

Steps To Reproduce

Check the trigger:
m_transaction_trg2

On the following line if the v_uom_value it does not show the error.

    RAISE EXCEPTION '%', '@CannotTakeOutReservedStock@' || ' @of@' || ' @Product@: ' || v_product_value || ', @AttributeSetInstance@: ' || COALESCE(v_attr_description, '-') || ', @UOM@: ' || v_uom_value || ' @And@'||' @StorageBin@: ' || COALESCE(v_locator_value, '-'); --OBTG:-20000--

The symbols is captured as following:

          SELECT uomsymbol
            INTO v_uom_value
          FROM C_Uom
          WHERE C_Uom_ID = NEW.c_uom_id;

It can be null because it is not mandatory on the application.

Proposed Solution

Add a coalesce on the raise.
Previously when thaking the symbol take also the name and use the name when the symbol is null.

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
(0064995) hgbot (developer) 2014-03-10 18:03	Repository: erp/devel/pi Changeset: ecb94735a506e358093b136b3093b15d1758dfa2 Author: Jon Alegría <jon.alegria <at> openbravo.com> Date: Mon Mar 10 18:02:57 2014 +0100 URL: http://code.openbravo.com/erp/devel/pi/rev/ecb94735a506e358093b136b3093b15d1758dfa2 [^] Fixes issue 0025317: Empty error message when inserting a incorrect m_transaction line when there is not symbol for the unit of meassure --- M src-db/database/model/triggers/M_TRANSACTION_TRG2.xml ---

(0065052) hudsonbot (developer) 2014-03-11 17:04	A changeset related to this issue has been promoted main and to the Central Repository, after passing a series of tests. Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/0d35a09c7eb8 [^] Maturity status: Test

Issue History
Date Modified	Username	Field	Change
2013-12-12 11:11	egoitz	New Issue
2013-12-12 11:11	egoitz	Assigned To	=> dmiguelez
2013-12-12 11:11	egoitz	Modules	=> Core
2013-12-12 11:11	egoitz	Resolution time	=> 1389913200
2013-12-12 11:11	egoitz	Triggers an Emergency Pack	=> No
2014-01-02 12:18	dmiguelez	Assigned To	dmiguelez => jonalegriaesarte
2014-03-10 18:03	hgbot	Checkin
2014-03-10 18:03	hgbot	Note Added: 0064995
2014-03-10 18:03	hgbot	Status	new => resolved
2014-03-10 18:03	hgbot	Resolution	open => fixed
2014-03-10 18:03	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/devel/pi/rev/ecb94735a506e358093b136b3093b15d1758dfa2 [^]
2014-03-10 18:05	egoitz	Review Assigned To	=> egoitz
2014-03-10 18:05	egoitz	Status	resolved => closed
2014-03-10 18:05	egoitz	Fixed in Version	=> PR14Q2
2014-03-11 17:04	hudsonbot	Checkin
2014-03-11 17:04	hudsonbot	Note Added: 0065052