details: /erp/erp/devel/pi/rev/07213d2821d1
changeset: 4662:07213d2821d1
user: Rajagopal Baskaran <rajagopal.baskaran <at> openbravo.com>
date: Thu Aug 20 00:45:58 2009 +0530
summary: Code changes of core enhancement for Booking control feature.
diffstat:
src-db/database/model/tables/C_ACCTSCHEMA_PROCESS.xml | 3 ++-
src-db/database/model/triggers/C_ACCTSCHEMA_PROCESS_TRG.xml | 5 +++--
2 files changed, 5 insertions(+), 3 deletions(-)
diffs (34 lines):
diff -r a4c854202eb2 -r 07213d2821d1
src-db/database/model/tables/C_ACCTSCHEMA_PROCESS.xml
--- a/src-db/database/model/tables/C_ACCTSCHEMA_PROCESS.xml Wed Aug 19
20:27:12 2009 +0200
+++ b/src-db/database/model/tables/C_ACCTSCHEMA_PROCESS.xml Thu Aug 20
00:45:58 2009 +0530
@@ -47,7 +47,7 @@
</column>
<column name="ISDATASET" primaryKey="false" required="true" type="CHAR"
size="1" autoIncrement="false">
<default><![CDATA[N]]></default>
- <onCreateDefault/>
+ <onCreateDefault><![CDATA['N']]></onCreateDefault>
</column>
<foreign-key foreignTable="AD_CLIENT"
name="AD_CLIENT_CACCTSCHEMAPROCESS">
<reference local="AD_CLIENT_ID" foreign="AD_CLIENT_ID"/>
@@ -62,5 +62,6 @@
<reference local="C_ACCTSCHEMA_ID" foreign="C_ACCTSCHEMA_ID"/>
</foreign-key>
<check name="CACCTSCHPROCESS_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y',
'N')]]></check>
+ <check name="CACCTSCHPROCESS_ISDATASET_CHECK"><![CDATA[ISDATASET IN
('Y', 'N')]]></check>
</table>
</database>
diff -r a4c854202eb2 -r 07213d2821d1
src-db/database/model/triggers/C_ACCTSCHEMA_PROCESS_TRG.xml
--- a/src-db/database/model/triggers/C_ACCTSCHEMA_PROCESS_TRG.xml Wed Aug
19 20:27:12 2009 +0200
+++ b/src-db/database/model/triggers/C_ACCTSCHEMA_PROCESS_TRG.xml Thu Aug
20 00:45:58 2009 +0530
@@ -62,8 +62,9 @@
WHERE AD_CLIENT_ID = :NEW.AD_CLIENT_ID AND AD_ORG_ID = :NEW.AD_ORG_ID;
ELSE
-- No accounting schema was found!
- --RAISE_APPLICATION_ERROR(-1, 'WHATEVER EXCEPTION') ;
- RAISE EXCEPTION '-20000','@NoAcctSchema@';
+ --RAISE_APPLICATION_ERROR(-20000,'@NoAcctSchema@');
+ --RAISE_APPLICATION_ERROR(-20000, 'NoAcctSchema');
+ RAISE_APPLICATION_ERROR(-20000, '@NoAcctSchema@');
END IF;
ELSIF (v_Count>1) THEN
-- If there exists more than one accounting schema for the organization
then
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Openbravo-commits mailing list
Openbravo-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
