BEGIN
    IF inventory_item_status_code = 'Active' THEN
      SELECT item_number
      FROM   regal.regal_inv_landed_cost_tab ril
      WHERE  EXISTS (SELECT 1
                     FROM   mtl_system_items
                     WHERE  organization_id IN ( 81, 82 )
                            AND inventory_item_status_code = 'Active');
    ELSE
   fnd_message.Set_string('This item is  Inacive status please active and move  ');

   fnd_message.show;
END IF;
END;  

 DECLARE
    alert_button NUMBER;
    alert_button2 NUMBER; -->Added on 14-Feb-2014
    v_message    VARCHAR2(1000);
    v_count1     Number;  -->Added on 14-Feb-2014
    v_count      NUMBER := 0;
BEGIN
      IF show_alert('ACTIVE') = alert_button1 then
      SELECT  Count(1)
      INTO   v_count1
      FROM   regal_inv_landed_cost_tab ril,
             mtl_system_items mtk
      WHERE  ril.inventory_item_id = mtk.inventory_item_id
       AND ril.organization_id = mtk.organization_id
       AND ril.ORGANIZATION_ID='1381'
       AND mtk.inventory_item_status_code = 'Inactive';
     ELSE
        fnd_message.Set_string('This item is  not in active status please active and move  ');
        fnd_message.show;
        raise form_trigger_failure; 
     END IF;
     
    v_message := 'Are you sure,you want to move data into Brooklyn Warehouse?';

    Set_alert_property('BRW', alert_message_text, v_message);

    alert_button := Show_alert('BRW');   
   
    IF alert_button = alert_button1 THEN
      commit_form;

      BEGIN
          SELECT Count(1)
          INTO   v_count
          FROM   regal_inv_landed_cost_tab
          WHERE  file_number = :RHCLANDEDCOSTHEADER.file_number
                 AND selected_flag = 'Y'
                 AND brw_processed = 'Y'
                 AND orig_quantity_received = quantity_received;
      END;
      IF v_count != 0 THEN
        fnd_message.Set_string('You are selecting Processed Records. Please Check ');--testing
        fnd_message.show;
      ELSE
        submit_inv_request;
      END IF;
  END IF;

END;