Check_Product_Title;
Begin
	if :prod2.internet_product_flag = 'Y' and :prod2.brnd_code is null then
		soft_messages('E',TRUE,'Brand code must be specified for CCH online product');
	end if;
end;	
BEGIN
	IF :PROD2.GAA_AVAIL IS NULL THEN	
		 :PROD2.GAA_AVAIL :='N';
	END IF;
END;

BEGIN
   IF (:prod2.GAA_AVAIL = 'Y' AND :prod2.INTERNET_PRODUCT_FLAG = 'N' )
  THEN
    soft_messages('E', TRUE, 'The Available in GAA flag can only be set to Yes if the CCH Canadian Online Product flag is set to Yes');
  END IF;
END;

begin
if :prod2.GAA_AVAIL='Y' then
set_item_property('prod2.GAA_AVAIL',enabled,property_false);
else
set_item_property('prod2.GAA_AVAIL',enabled,property_true);
end if;
end;

BEGIN
  Check_printable_item_flag;

  :PROD2.CREATED_BY := :CG$CTRL.CGU$USER;
  :PROD2.CREATED_DATE := SYSDATE;
  
  IF :PROD2.DELIVERY_HANDLING_CHARGE_FLAG = 'Y'
    AND :PROD2.PRODUCT_TYPE IN ('BOOK','SE','PD','BVOL','BINC')
    AND :PROD2.SHIPPING_CHARGES_SCHEME IS NULL
  THEN
    soft_messages ('W',TRUE,'The Scheme is mandatory for this product type when Shipping Charges Flag is Yes ');
  END IF;  
    
  IF :PROD2.PRODUCT_TYPE='ADDL' AND :PROD2.PRMU_CODE IS NULL    
  THEN
    soft_messages ('E',TRUE,'Multi User Pricing Group is mandatory for Additional product type');
  END IF;
  	
END;

if sysdate between to_date('06.02.2013', 'dd.mm.yyyy') and to_date('01.03.2013', 'dd.mm.yyyy') then
   check_product_title;
   <the rest of your code goes here>
else
   message('Your error message goes here');
   raise form_trigger_failure;
end if;