Open on form from another
When Opening one form from another use:
FND_FUNCTION.EXECUTE( FUNCTION_NAME => 'XX1234',
OPEN_FLAG => 'Y',
SESSION_FLAG => 'Y',
OTHER_PARAMS => 'P_N_PERSON_ID="' || l_person_id || '"' ||
'CALLING_FORM="' || 'YY4321' || '"' );
Start with the form name, in this case XX1234.
Session flag should be always no (Y if the new form needs a new database session)
Open flag should be Y to keep the current form open and N to close the current form.
OTHER_PARAMS are other params to pass to the form
Forms Message Box
fnd_message.set_string('ucas_Cycle=' || to_char(123) ||':');