BEGIN
IF :OFFER.NUMOFF IS NULL THEN
  MESSAGE_AUTORIS('Le N° Décision doit être saisi.');
  GO_ITEM('OFFER.NUMOFF');
  RAISE form_trigger_failure;
ELSIF :OFFER.FIRSTDAT IS NULL THEN
  MESSAGE_AUTORIS('La date d''effet doit être saisie.');
  GO_ITEM('OFFER.FIRSTDAT');
  RAISE form_trigger_failure;
ELSIF :OFFER.LASTDAT IS NULL THEN
  MESSAGE_AUTORIS('La date fin de validité doit être saisie.');
  GO_ITEM('OFFER.LASTDAT');
  RAISE form_trigger_failure;
ELSIF :OFFER.NATUREOFF IS NULL THEN
  MESSAGE_AUTORIS('Le code en douane du bénéficiaire doit être saisi.');
  GO_ITEM('OFFER.NATUREOFF');
  RAISE form_trigger_failure;

END IF;
			
  BEGIN
  	
  	:system.message_level := 25;  
	insert into OFFER
	(NUMOFF, FIRSTDAT, LASTDAT, NATUREOFF)
	values (:OFFER.NUMOFF, :OFFER.FIRSTDAT, :OFFER.LASTDAT, :OFFER.NATUREOFF); 
	system.message_level := 0;
  EXCEPTION	
  	WHEN no_data_found THEN
  	 	message_autoris('Insertion on offer table (no data): '||SQLCODE||' - '||SQLERRM);
    	raise FORM_TRIGGER_FAILURE;
  	WHEN OTHERS THEN
 		message_autoris('Insertion on offer table (others) : '||SQLCODE||' - '||SQLERRM);
    raise FORM_TRIGGER_FAILURE;
	END;
	
  :system.message_level := 25;
  COMMIT;
  :system.message_level := 0;
  message_autoris(:system.form_status); -- RETURN "QUERY"
  message_autoris(DBMS_ERROR_CODE || DBMS_ERROR_TEXT); -- RETURN ORA-01403 no data found
  GO_BLOCK('OFFER');
  clear_block(no_validate);
  Message_autoris('Offer is saved');

END;

message(:system.cursor_item ||'--'||DBMS_ERROR_CODE || DBMS_ERROR_TEXT); -- RETURN OFFER.NUMOFF--ORA-01403 no data found