How to show the alert 'Do you want to save?' after entering each record. & Is there a way to sho [message #304698] |
Thu, 06 March 2008 03:58 |
astik.mondal
Messages: 14 Registered: March 2008 Location: Kolkata
|
Junior Member |
|
|
Hi,
Is there a way to show the alert 'Do you want to save the changes you have made?', after entering each record.
i.e. as soon as a record is entered, user should be prompted to 'Do you want to save the changes?' the record when they move to the next record.
I used the below code in Post-Record rigger. Prompt was diplaying fine as per the requirement,but record was not saved.
DECLARE
n_button_selection INTEGER;
BEGIN
if :System.Record_Status='INSERT' then
fnd_message.set_string('Do you want to save the changes?');
n_button_selection := fnd_message.question('Yes', 'No','Cancel', 1, 2,'question');
IF n_button_selection = 1 THEN
forms_ddl('commit_FORM');
ELSIF n_button_selection = 2 THEN
RAISE form_trigger_failure;
ELSE
NULL;
END IF;
end if;
END;
I used forms_ddl('commit_FORM') to commit the record. Because we can't us Do-key('commit_form') in post-record trigger. But forms_ddl('commit_FORM') is not working. So can anybody please give some idea regarding this.
Regards,
AM
|
|
|
How to show the alert 'Do you want to save?' after entering each record. [message #304718 is a reply to message #304698] |
Thu, 06 March 2008 06:17 |
astik.mondal
Messages: 14 Registered: March 2008 Location: Kolkata
|
Junior Member |
|
|
Hi,
Is there a way to show the alert 'Do you want to save the changes you have made?', after entering each record.
i.e. as soon as a record is entered, user should be prompted to 'Do you want to save the changes?' the record when they move to the next record.
I used the below code in Post-Record rigger. Prompt was diplaying fine as per the requirement,but record was not being saved.
DECLARE
n_button_selection INTEGER;
BEGIN
if :System.Record_Status='INSERT' then
fnd_message.set_string('Do you want to save the changes?');
n_button_selection := fnd_message.question('Yes', 'No','Cancel', 1, 2,'question');
IF n_button_selection = 1 THEN
forms_ddl('commit_FORM');
ELSIF n_button_selection = 2 THEN
RAISE form_trigger_failure;
ELSE
NULL;
END IF;
end if;
END;
I used forms_ddl('commit_FORM') to commit the record. Because we can't us Do-key('commit_form') in post-record trigger. But forms_ddl('commit_FORM') is not working. So can anybody please give some idea regarding this.
|
|
|
|
|
|
|
|
|