0019492: The use can change the header organization in project window, when the project has lines

diff --git a/src-db/database/model/triggers/C_PROJECT_TRG.xml b/src-db/database/model/triggers/C_PROJECT_TRG.xml
--- a/src-db/database/model/triggers/C_PROJECT_TRG.xml
+++ b/src-db/database/model/triggers/C_PROJECT_TRG.xml
@@ -31,6 +31,7 @@
     ************************************************************************/
     v_Tree_ID VARCHAR2(32);
   v_Parent_ID VARCHAR2(32);
+    v_count NUMBER;
   --
   TYPE RECORD IS REF CURSOR;
     Cur_Defaults RECORD;
@@ -110,8 +111,19 @@
       )
       ;
     ELSIF (UPDATING) THEN
-     UPDATE C_PROJECT_ACCT SET AD_ORG_ID = :new.AD_ORG_ID
-     WHERE C_PROJECT_ID = :new.C_PROJECT_ID;
+
+      IF(COALESCE(:old.AD_ORG_ID, '0') <> COALESCE(:new.AD_ORG_ID, '0')) THEN 
+        SELECT COUNT(*) INTO V_COUNT FROM C_PROJECTLINE WHERE C_PROJECT_ID = :NEW.C_PROJECT_ID;
+        IF(V_COUNT > 0) THEN
+          SELECT COUNT(*) INTO V_COUNT FROM C_PROJECTLINE WHERE C_PROJECT_ID = :NEW.C_PROJECT_ID AND AD_ISORGINCLUDED(:NEW.AD_ORG_ID,AD_ORG_ID,:NEW.AD_CLIENT_ID) <> -1;
+          IF(V_COUNT = 0) THEN
+            RAISE_APPLICATION_ERROR(-20000, '@orgnizationHeaderCheck@') ;
+          END IF;
+        END IF;
+      END IF;
+    
+      UPDATE C_PROJECT_ACCT SET AD_ORG_ID = :new.AD_ORG_ID
+      WHERE C_PROJECT_ID = :new.C_PROJECT_ID;
     END IF;
     -- Summary Nodes first
 EXCEPTION
diff --git a/src-db/database/model/triggers/M_PRODUCT_TRG.xml b/src-db/database/model/triggers/M_PRODUCT_TRG.xml
--- a/src-db/database/model/triggers/M_PRODUCT_TRG.xml
+++ b/src-db/database/model/triggers/M_PRODUCT_TRG.xml
@@ -48,6 +48,16 @@
     END IF;
 
  IF (UPDATING) THEN
+  IF(COALESCE(:old.AD_ORG_ID, '0') <> COALESCE(:new.AD_ORG_ID, '0')) THEN 
+    SELECT COUNT(*) INTO V_COUNT FROM M_PRODUCTPRICE WHERE M_PRODUCT_ID = :NEW.M_PRODUCT_ID;
+    IF(V_COUNT > 0) THEN
+      SELECT COUNT(*) INTO V_COUNT FROM M_PRODUCTPRICE WHERE M_PRODUCT_ID = :NEW.M_PRODUCT_ID AND AD_ISORGINCLUDED(:NEW.AD_ORG_ID,AD_ORG_ID,:NEW.AD_CLIENT_ID) <> -1;
+      IF(V_COUNT = 0) THEN
+        RAISE_APPLICATION_ERROR(-20000, '@orgnizationHeaderCheck@') ;
+      END IF;
+    END IF;
+  END IF;
+ 
   UPDATE M_PRODUCT_ACCT SET AD_ORG_ID = :new.AD_ORG_ID
   WHERE M_PRODUCT_ID = :new.M_PRODUCT_ID;
   
diff --git a/src-db/database/model/triggers/M_WAREHOUSE_TRG.xml b/src-db/database/model/triggers/M_WAREHOUSE_TRG.xml
--- a/src-db/database/model/triggers/M_WAREHOUSE_TRG.xml
+++ b/src-db/database/model/triggers/M_WAREHOUSE_TRG.xml
@@ -28,6 +28,7 @@
 
   TYPE RECORD IS REF CURSOR;
   Cur_Defaults RECORD;
+  v_count NUMBER;
     
 BEGIN
     
@@ -71,6 +72,16 @@
         ;
     END LOOP;
   ELSIF (UPDATING) THEN
+    IF(COALESCE(:old.AD_ORG_ID, '0') <> COALESCE(:new.AD_ORG_ID, '0')) THEN 
+      SELECT COUNT(*) INTO V_COUNT FROM M_LOCATOR WHERE M_WAREHOUSE_ID = :NEW.M_WAREHOUSE_ID;
+      IF(V_COUNT > 0) THEN
+        SELECT COUNT(*) INTO V_COUNT FROM M_LOCATOR WHERE M_WAREHOUSE_ID = :NEW.M_WAREHOUSE_ID AND AD_ISORGINCLUDED(:NEW.AD_ORG_ID,AD_ORG_ID,:NEW.AD_CLIENT_ID) <> -1;
+        IF(V_COUNT = 0) THEN
+          RAISE_APPLICATION_ERROR(-20000, '@orgnizationHeaderCheck@') ;
+        END IF;
+      END IF;
+    END IF;
+
     UPDATE M_WAREHOUSE_ACCT SET AD_ORG_ID = :new.AD_ORG_ID
     WHERE M_WAREHOUSE_ID = :new.M_WAREHOUSE_ID;
   END IF;