[OpenbravoERP-commits] devel/pi: Fixes issue 0022241: Changing the UOM for a product wi...

[hg]

details:   https://code.openbravo.com/erp/devel/pi/rev/32e41720eaa1
changeset: 18549:32e41720eaa1
user:      Jon Alegría <jon.alegria <at> openbravo.com>
date:      Wed Nov 14 17:14:07 2012 +0100
summary:   Fixes issue 0022241: Changing the UOM for a product with stock 
should be
forbidden

diffstat:

 src-db/database/model/triggers/M_PRODUCT_TRG.xml |   4 +++-
 src-db/database/sourcedata/AD_MESSAGE.xml        |  11 +++++++++++
 2 files changed, 14 insertions(+), 1 deletions(-)

diffs (42 lines):

diff -r 0aacf87829e4 -r 32e41720eaa1 
src-db/database/model/triggers/M_PRODUCT_TRG.xml
--- a/src-db/database/model/triggers/M_PRODUCT_TRG.xml  Wed Nov 14 11:10:46 
2012 +0100
+++ b/src-db/database/model/triggers/M_PRODUCT_TRG.xml  Wed Nov 14 17:14:07 
2012 +0100
@@ -57,7 +57,7 @@
   
  -- Do not allow to de-activate products with OnHand Qty
  -- or Change the attribute set
-  IF ((:new.IsActive='N' AND :old.IsActive='Y') OR 
(COALESCE(:new.m_attributeset_id,'null') <> 
COALESCE(:old.m_attributeset_id,'null'))) THEN
+  IF ((:new.IsActive='N' AND :old.IsActive='Y') OR 
(COALESCE(:new.m_attributeset_id,'null') <> 
COALESCE(:old.m_attributeset_id,'null')) OR (COALESCE(:new.c_uom_id,'null') <> 
COALESCE(:old.c_uom_id,'null'))) THEN
    SELECT  COALESCE(SUM(QtyOnHand)+SUM(QtyReserved)*.111+SUM(QtyOrdered)*999, 
0) INTO v_ControlNo
    FROM (SELECT QtyOnHand, 0 AS QtyReserved, 0 AS QtyOrdered
    FROM M_Storage_Detail s
@@ -69,6 +69,8 @@
    IF (v_ControlNo <> 0) THEN
     IF (COALESCE(:new.m_attributeset_id,'null') <> 
COALESCE(:old.m_attributeset_id,'null')) THEN
       RAISE_APPLICATION_ERROR(-20000, '@20633@');
+    ELSIF (COALESCE(:new.c_uom_id,'null') <> COALESCE(:old.c_uom_id,'null')) 
THEN
+      RAISE_APPLICATION_ERROR(-20000, '@20634@');
     ELSE
       RAISE_APPLICATION_ERROR(-20000, '@20400@');
     END IF;
diff -r 0aacf87829e4 -r 32e41720eaa1 src-db/database/sourcedata/AD_MESSAGE.xml
--- a/src-db/database/sourcedata/AD_MESSAGE.xml Wed Nov 14 11:10:46 2012 +0100
+++ b/src-db/database/sourcedata/AD_MESSAGE.xml Wed Nov 14 17:14:07 2012 +0100
@@ -17442,6 +17442,17 @@
 <!--6CA1ABF3BD6047798BC810CEA1477B45-->  
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--6CA1ABF3BD6047798BC810CEA1477B45--></AD_MESSAGE>
 
+<!--6D2758613C5F44AF9204D818EB0085C8--><AD_MESSAGE>
+<!--6D2758613C5F44AF9204D818EB0085C8-->  
<AD_MESSAGE_ID><![CDATA[6D2758613C5F44AF9204D818EB0085C8]]></AD_MESSAGE_ID>
+<!--6D2758613C5F44AF9204D818EB0085C8-->  
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--6D2758613C5F44AF9204D818EB0085C8-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--6D2758613C5F44AF9204D818EB0085C8-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--6D2758613C5F44AF9204D818EB0085C8-->  <VALUE><![CDATA[20634]]></VALUE>
+<!--6D2758613C5F44AF9204D818EB0085C8-->  <MSGTEXT><![CDATA[You cannot change 
the unit of the product because it has inventory]]></MSGTEXT>
+<!--6D2758613C5F44AF9204D818EB0085C8-->  <MSGTYPE><![CDATA[E]]></MSGTYPE>
+<!--6D2758613C5F44AF9204D818EB0085C8-->  
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--6D2758613C5F44AF9204D818EB0085C8--></AD_MESSAGE>
+
 <!--6D5E5F8894AF4B77A713CD24B7500BCB--><AD_MESSAGE>
 <!--6D5E5F8894AF4B77A713CD24B7500BCB-->  
<AD_MESSAGE_ID><![CDATA[6D5E5F8894AF4B77A713CD24B7500BCB]]></AD_MESSAGE_ID>
 <!--6D5E5F8894AF4B77A713CD24B7500BCB-->  
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>

------------------------------------------------------------------------------
Monitor your physical, virtual and cloud infrastructure from a single
web console. Get in-depth insight into apps, servers, databases, vmware,
SAP, cloud infrastructure, etc. Download 30-day Free Trial.
Pricing starts from $795 for 25 servers or applications!
http://p.sf.net/sfu/zoho_dev2dev_nov
_______________________________________________
Openbravo-commits mailing list
Openbravo-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openbravo-commits