Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

clear_record in Oracle Forms

1009658Jun 4 2013 — edited Jun 5 2013
When 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;
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 3 2013
Added on Jun 4 2013
16 comments
5,765 views