Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0006773Openbravo ERP02. Master data managementpublic2009-01-02 21:502009-04-21 11:09
Reportericiordia 
Assigned ToDowid 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0006773: Wrong code in M_PRODUCT_BOM_CHECK pl/sql function
DescriptionM_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@"
      
Steps To Reproduce
Proposed SolutionIt should be:

        EXCEPTION
      WHEN others THEN
            RAISE_APPLICATION_ERROR(-20000, '@C_TEMP_SELECTION2_KEY@');
        END;
Additional Information
TagsNo tags attached.
Relationships
related to defect 0005935 closed Dowid Message not informative enough after "Verify BOM" Process 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-01-02 21:50iciordiaNew Issue
2009-01-02 21:50iciordiaAssigned To => rafaroda
2009-01-02 21:50iciordiasf_bug_id0 => 2482859
2009-01-02 21:50iciordiaRegression testing => No
2009-01-03 20:23rafarodaRelationship addedrelated to 0005935
2009-01-03 20:24rafarodaStatusnew => scheduled
2009-01-03 20:24rafarodaAssigned Torafaroda => Dowid
2009-01-03 20:24rafarodafix_in_branch => trunk
2009-01-05 15:02svnbotCheckin
2009-01-05 15:02svnbotNote Added: 0011915
2009-01-05 15:02svnbotStatusscheduled => resolved
2009-01-05 15:02svnbotResolutionopen => fixed
2009-01-05 15:02svnbotsvn_revision => 11659
2009-04-21 11:09psarobeStatusresolved => closed

Notes
(0011915)
svnbot   
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 [^]