Oracle Forms notes

Submitted by code_admin on Mon, 07/16/2018 - 15:55

Open on form from another

When Opening one form from another use:

  1.              FND_FUNCTION.EXECUTE( FUNCTION_NAME => 'XX1234',
  2.                                  OPEN_FLAG     => 'Y',
  3.                                  SESSION_FLAG  => 'Y',
  4.                                  OTHER_PARAMS  => 'P_N_PERSON_ID="'  || l_person_id  || '"' ||
  5.                                                   '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

  1.                  fnd_message.set_string('ucas_Cycle=' || to_char(123) ||':');
  2.                  fnd_message.show;
RJM Article Type
Quick Reference