clear_record in Oracle Forms
1009658Jun 4 2013 — edited Jun 5 2013When I use clear_record in a block on a form the record seems to go away but it is still held in a buffer somehow. When the form saves the block to the database, the clear records are still there.
Any idea what could be causing this?
Here is part of the code.
currRec := :system.cursor_record;
SET_BLOCK_PROPERTY ('LINE', DELETE_ALLOWED, PROPERTY_TRUE);
l_ordered_item_orig := Name_In(l_ordered_item);
IF currRec <> '1' THEN
first_record;
loop
l_ordered_item_cur := Name_In(l_ordered_item);
IF (l_ordered_item_cur = l_ordered_item_orig) THEN
l_line_num := Name_In(l_line_no);
IF :SYSTEM.LAST_RECORD = 'TRUE' THEN
exit;
ELSE
Bell;
fnd_message.set_name ('XXBHP', 'XXBHP_DUP_SO_LINE');
fnd_message.set_token ('LINE', l_line_num, TRUE);
l_num_message := fnd_message.question ('YES', NULL, 'NO', 2, 2, 'question');
IF (l_num_message = 1) THEN
--fnd_message.clear;
go_record (currRec);
--delete_record;
clear_record;
next_record;
exit;
ELSE
exit;
END IF;
END IF;
ELSE
next_record;
END IF;
end loop;
go_record (currRec);
END IF;
-- go back to the original record position
end;