# HG changeset patch
# User Fernando Soto <fernando.soto@peoplewalking.com>
# Date 1413307824 18000
#      Tue Oct 14 12:30:24 2014 -0500
# Node ID 92c087e9bcd8f667ef78b345b6af1710e51b5033
# Parent  9060285248abfd0f339844fcedd8ab181c075005
Fixed bug 27868: The Create Standards process throws "ORA-01403: no data found"

Modified MA_PRODUCTIONRUN_STANDARD to catch the exception.

diff -r 9060285248ab -r 92c087e9bcd8 src-db/database/model/functions/MA_PRODUCTIONRUN_STANDARD.xml
--- a/src-db/database/model/functions/MA_PRODUCTIONRUN_STANDARD.xml	Sun Oct 12 11:59:49 2014 -0500
+++ b/src-db/database/model/functions/MA_PRODUCTIONRUN_STANDARD.xml	Tue Oct 14 12:30:24 2014 -0500
@@ -329,11 +329,17 @@
               AD_PINSTANCE_PARA_INSERT(v_AD_Pinstance_ID, '80', 'LineNo', null, null, v_PlanLine, null, null, null);
               AD_PINSTANCE_PARA_INSERT(v_AD_Pinstance_ID, '90', 'ProcessID', '800105', null, null, null, null, null);
               AD_PINSTANCE_PARA_INSERT(v_AD_Pinstance_ID, '100', 'Quantity', null, null, v_DoneQuantity*Cur_WRPUsed.MovementQty, null, null, null);
-              
-              SELECT COALESCE(wrpp.m_warehouse_rule_id, sp.m_warehouse_rule_id) INTO v_warehouse_rule_id
-              FROM ma_wrphaseproduct wrpp
-                  JOIN ma_sequenceproduct sp ON wrpp.ma_sequenceproduct_id = sp.ma_sequenceproduct_id
-              WHERE wrpp.ma_wrphaseproduct_id = cur_wrpused.ma_wrphaseproduct_id;
+
+              begin
+                SELECT COALESCE(wrpp.m_warehouse_rule_id, sp.m_warehouse_rule_id) INTO v_warehouse_rule_id
+                FROM ma_wrphaseproduct wrpp
+                    JOIN ma_sequenceproduct sp ON wrpp.ma_sequenceproduct_id = sp.ma_sequenceproduct_id
+                WHERE wrpp.ma_wrphaseproduct_id = cur_wrpused.ma_wrphaseproduct_id;
+                
+                exception
+                when NO_DATA_FOUND then 
+                v_warehouse_rule_id := null;
+              end;
               AD_PINSTANCE_PARA_INSERT(v_AD_Pinstance_ID, '110', 'M_Warehouse_Rule_ID', v_warehouse_rule_id, null, null, null, null, null);
 
               M_GET_STOCK(v_AD_Pinstance_ID, 'N');