0006773: Wrong code in M_PRODUCT_BOM_CHECK pl/sql function

Description

M_PRODUCT_BOM_CHECK is in invalid status because of this piece of code:

        EXCEPTION
      WHEN others THEN
            RAISE '@C_TEMP_SELECTION2_KEY@ ';
        END;

It does not compile in Oracle. Furthermore the code is meaningless, is should be something like "@LOOP_IN_BOM@"

Proposed Solution

It should be:

        EXCEPTION
      WHEN others THEN
            RAISE_APPLICATION_ERROR(-20000, '@C_TEMP_SELECTION2_KEY@');
        END;

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

related to

defect

0005935

closed

Dowid

Message not informative enough after "Verify BOM" Process

Notes
(0011915) svnbot (reporter) 2009-01-05 15:02	Repository: openbravo Revision: 11659 Author: dowid Date: 2009-01-05 15:01:51 +0100 (Mon, 05 Jan 2009) bug fixed 0006773: Wrong code in M_PRODUCT_BOM_CHECK pl/sql function --- U trunk/src-db/database/model/functions/M_PRODUCT_BOM_CHECK.xml U trunk/src-db/database/sourcedata/AD_MESSAGE.xml --- https://dev.openbravo.com/websvn/openbravo/?rev=11659&sc=1 [^]

Issue History
Date Modified	Username	Field	Change
2009-01-02 21:50	iciordia	New Issue
2009-01-02 21:50	iciordia	Assigned To	=> rafaroda
2009-01-02 21:50	iciordia	sf_bug_id	0 => 2482859
2009-01-02 21:50	iciordia	Regression testing	=> No
2009-01-03 20:23	rafaroda	Relationship added	related to 0005935
2009-01-03 20:24	rafaroda	Status	new => scheduled
2009-01-03 20:24	rafaroda	Assigned To	rafaroda => Dowid
2009-01-03 20:24	rafaroda	fix_in_branch	=> trunk
2009-01-05 15:02	svnbot	Checkin
2009-01-05 15:02	svnbot	Note Added: 0011915
2009-01-05 15:02	svnbot	Status	scheduled => resolved
2009-01-05 15:02	svnbot	Resolution	open => fixed
2009-01-05 15:02	svnbot	svn_revision	=> 11659
2009-04-21 11:09	psarobe	Status	resolved => closed