0001943: BOM Production without attributes, no exception shown

Description

On M_PRODUCTION_RUN line 414:

The exception should be captured on screen,
ROLLBACK;
RAISE_APPLICATION_ERROR(-20000, v_Message);
is missing.

Should be this way:

SELECT COUNT(*)
INTO v_Count
FROM M_PRODUCTIONPLAN PP,
M_PRODUCTIONLINE PL,
M_PRODUCT P
WHERE PL.M_PRODUCT_ID=P.M_PRODUCT_ID
AND P.M_ATTRIBUTESET_ID IS NOT NULL
AND PL.M_ATTRIBUTESETINSTANCE_ID IS NULL
AND PL.M_ProductionPlan_ID=pp.M_ProductionPlan_ID
AND pp.M_Production_ID=v_Record_ID;
IF v_Count<>0 THEN
v_Message:='@LinesWithoutAttributeSet@';
FINISH_PROCESS:=true;
ROLLBACK;
RAISE_APPLICATION_ERROR(-20000, v_Message);
END IF;

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
(0002084) gorkaion (viewer) 2007-10-10 18:46 edited on: 2008-06-12 09:21	Logged In: YES user_id=1500690 Originator: NO Fixed the procedure

(0002085) rafaroda (viewer) 2007-10-25 16:16 edited on: 2008-06-12 09:21	Logged In: YES user_id=1892190 Originator: NO Verification assigned to rafaroda.

(0005532) user71 2005-06-01 00:00 edited on: 2008-06-12 09:43	This bug was originally reported in SourceForge bug tracker and then migrated to Mantis. You can see the original bug report in: https://sourceforge.net/support/tracker.php?aid=1793119 [^]

Issue History
Date Modified	Username	Field	Change