Oracle Forms

Hi All,

I need to check whether a duplicate item/info entered in a multi record block(detail block)

For example we will enter Item 'ABCD' at Line 1 then again at Line 2 if I try to enter the same item 'ABCD' it should pop up a message saying "Item Already Entered" once we press Tab
on that ITem Field.

If we enter a different Item it should take as usual.

I will appreciate if some body posts the code for the same.

Tried below code but its not working. It has written in Apps.

---
if (form_name = 'OEXOEORD' and block_name = 'LINE') then
IF (event_name = 'WHEN-VALIDATE-RECORD') THEN
CI:=name_in('LINE.ORDERED_ITEM_DSP');
CR:=3;
-- CR:=:system.cursor_record;
Go_Record(':LINE.first_record_number');
for i in 1..CR-1
loop
if i <> 1 then
CP:=name_in('LINE.ORDERED_ITEM_DSP');
if CP = CI then
FND_MESSAGE.SET_string('Item Entered Already');
FND_MESSAGE.Show;
end if;
end if;
end loop;
END IF;
end if;

Appreciate your help
Thanks
Devender