BEGIN
	SELECT
	SUPPLIER.SUPPLIER_ID,
	SUPPLIER.ADDRESS,
	SUPPLIER.CITY,
	SUPPLIER.STATE,
	SUPPLIER.COUNTRY
INTO
	:SEARCH_SUPPLIER_CONTACT.SUPPLIER_ID,
	:SEARCH_SUPPLIER_CONTACT.ADDRESS,
	:SEARCH_SUPPLIER_CONTACT.CITY,
	:SEARCH_SUPPLIER_CONTACT.STATE,
	:SEARCH_SUPPLIER_CONTACT.COUNTRY
FROM
	SUPPLIER
WHERE
	SUPPLIER.COMPANY_NAME =:SEARCH_SUPPLIER_CONTACT.COMPANY_NAME ;
		
EXCEPTION
	WHEN NO_DATA_FOUND THEN
	MESSAGE ('INVALID SUPLIER ID');
	raise form_TRIGGER_failure;
	END;