Fixed bug 20394 Add informative messages in m_rappel_invoce_create
authorSandra Huguet <sandra.huguet@openbravo.com>
Thu, 03 May 2012 09:54:03 +0200
changeset 16466 3877d39c8130
parent 16465 e720f25cba62
child 16467 1abd834b75af
Fixed bug 20394 Add informative messages in m_rappel_invoce_create
src-db/database/model/functions/M_RAPPEL_INVOICE_CREATE.xml
src-db/database/sourcedata/AD_MESSAGE.xml
--- a/src-db/database/model/functions/M_RAPPEL_INVOICE_CREATE.xml	Wed May 09 15:43:52 2012 +0200
+++ b/src-db/database/model/functions/M_RAPPEL_INVOICE_CREATE.xml	Thu May 03 09:54:03 2012 +0200
@@ -16,7 +16,7 @@
 * under the License.
 * The Original Code is Openbravo ERP.
 * The Initial Developer of the Original Code is Openbravo SLU
-* All portions are Copyright (C) 2001-2008 Openbravo SLU
+* All portions are Copyright (C) 2001-2012 Openbravo SLU
 * All Rights Reserved.
 * Contributor(s):  ______________________________________.
 ************************************************************************/
@@ -329,6 +329,14 @@
           v_pricelistId
         FROM C_BPARTNER
         WHERE C_BPARTNER.C_BPARTNER_ID=CUR_INVOICE.C_BPARTNER_ID;
+
+	IF(v_paymenttermId is NULL) THEN
+	RAISE_APPLICATION_ERROR(-20000, '@notnullpayment@') ;
+	END IF;
+	IF(v_pricelistId is NULL) THEN
+	RAISE_APPLICATION_ERROR(-20000, '@notnullpricelist@') ;
+	END IF;
+
         INSERT
         INTO C_INVOICE
           (
--- a/src-db/database/sourcedata/AD_MESSAGE.xml	Wed May 09 15:43:52 2012 +0200
+++ b/src-db/database/sourcedata/AD_MESSAGE.xml	Thu May 03 09:54:03 2012 +0200
@@ -17687,6 +17687,18 @@
 <!--866391790789BDF4E040007F010116CE-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--866391790789BDF4E040007F010116CE--></AD_MESSAGE>
 
+<!--867773EE801F4C2495FA16E0B6DC04E8--><AD_MESSAGE>
+<!--867773EE801F4C2495FA16E0B6DC04E8-->  <AD_MESSAGE_ID><![CDATA[867773EE801F4C2495FA16E0B6DC04E8]]></AD_MESSAGE_ID>
+<!--867773EE801F4C2495FA16E0B6DC04E8-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--867773EE801F4C2495FA16E0B6DC04E8-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--867773EE801F4C2495FA16E0B6DC04E8-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--867773EE801F4C2495FA16E0B6DC04E8-->  <VALUE><![CDATA[notnullpricelist]]></VALUE>
+<!--867773EE801F4C2495FA16E0B6DC04E8-->  <MSGTEXT><![CDATA[The field price list in business partner is mandatory and cannot be left empty.
+]]></MSGTEXT>
+<!--867773EE801F4C2495FA16E0B6DC04E8-->  <MSGTYPE><![CDATA[E]]></MSGTYPE>
+<!--867773EE801F4C2495FA16E0B6DC04E8-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--867773EE801F4C2495FA16E0B6DC04E8--></AD_MESSAGE>
+
 <!--86AB14C5F80B4241A3E75E7D45CE62F6--><AD_MESSAGE>
 <!--86AB14C5F80B4241A3E75E7D45CE62F6-->  <AD_MESSAGE_ID><![CDATA[86AB14C5F80B4241A3E75E7D45CE62F6]]></AD_MESSAGE_ID>
 <!--86AB14C5F80B4241A3E75E7D45CE62F6-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -18142,6 +18154,17 @@
 <!--97481F69F2B84927918A073C6466BAE2-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--97481F69F2B84927918A073C6466BAE2--></AD_MESSAGE>
 
+<!--97D69827C27242C584842C0306B92580--><AD_MESSAGE>
+<!--97D69827C27242C584842C0306B92580-->  <AD_MESSAGE_ID><![CDATA[97D69827C27242C584842C0306B92580]]></AD_MESSAGE_ID>
+<!--97D69827C27242C584842C0306B92580-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--97D69827C27242C584842C0306B92580-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--97D69827C27242C584842C0306B92580-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--97D69827C27242C584842C0306B92580-->  <VALUE><![CDATA[notnullpayment]]></VALUE>
+<!--97D69827C27242C584842C0306B92580-->  <MSGTEXT><![CDATA[The field payment term in business partner is mandatory and cannot be left empty.]]></MSGTEXT>
+<!--97D69827C27242C584842C0306B92580-->  <MSGTYPE><![CDATA[E]]></MSGTYPE>
+<!--97D69827C27242C584842C0306B92580-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--97D69827C27242C584842C0306B92580--></AD_MESSAGE>
+
 <!--9825FDAA19EC44B5AE5A32EAE999FDE5--><AD_MESSAGE>
 <!--9825FDAA19EC44B5AE5A32EAE999FDE5-->  <AD_MESSAGE_ID><![CDATA[9825FDAA19EC44B5AE5A32EAE999FDE5]]></AD_MESSAGE_ID>
 <!--9825FDAA19EC44B5AE5A32EAE999FDE5-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>