0027868: The "Create Standards" process throws a "ORA-01403: no data found" exception.

# 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');

diff --git a/src-db/database/model/functions/MA_PRODUCTIONRUN_STANDARD.xml b/src-db/database/model/functions/MA_PRODUCTIONRUN_STANDARD.xml
--- a/src-db/database/model/functions/MA_PRODUCTIONRUN_STANDARD.xml
+++ b/src-db/database/model/functions/MA_PRODUCTIONRUN_STANDARD.xml
@@ -322,10 +322,17 @@
               --Review no warehouse as parameter
               M_GET_STOCK_PARAM(v_AD_Pinstance_ID, v_Record_ID, v_DoneQuantity*Cur_WRPUsed.MovementQty, v_Product_old, null, null, null, v_PlanOrg_ID, null, v_User_ID, v_Client_ID, v_warehouse_rule_id, v_UOM_old, v_Product_UOM_old, '325', v_Production_ID, v_PlanLine, '800105', null, 'N', v_pinstance_result, v_pinstance_msg);              
               -- Check result
-              SELECT result, errormsg
+              begin
+                SELECT result, errormsg
                 INTO v_pinstance_result, v_pinstance_msg
-              FROM ad_pinstance
-              WHERE ad_pinstance_id = v_ad_pinstance_id;
+                FROM ad_pinstance
+                WHERE ad_pinstance_id = v_ad_pinstance_id;
+                exception
+                when NO_DATA_FOUND then 
+                v_pinstance_result := null;
+                v_pinstance_msg := null;
+              end;
+              
               IF (v_pinstance_result = 0) THEN
                 -- Error on m_get_stock
                 RAISE_APPLICATION_ERROR(-20000, v_pinstance_msg);