I done this
****************

create or replace trigger insert_record
before insert on table
for each row
declare
v_dummy varchar2(1);
begin
select distinct count(id) into v_dummy from table
where id = :new.id;
if v_dummy > 0 then
raise_application_error (-20507 , 'Sorry .......');
end if;
end;