Skip to Main Content

E-Business Suite

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!

How to Assign a procedure out variable value to a global variable - form personalization

Latha00Dec 2 2024

Hello all.

I created a special menu and called the backend procedure: emailing the supplier.

In that procedure, I am storing debug messages if an email is sent to the supplier display.

As of now, it is sending an email to the business/user and I need to populate a message on the form/window/screen that says" email has been sent" Can you please suggest how to achieve this?

I tried this way.

  1. created Global variable not assigned any values here (seq 10)
  2. created SPECIAL seq/rule (seq 20)
  3. calling pkg. procedure trigger object is SPECIAL seq (seq 30)

action 1—> calling pkg. procedure

action 2—> assigning select pkg.message_fun from to dual to Globale variable

action 3—> display message by using: GLOBAL.global variable name

I can send an email to the user but not populate a pop-up message on the screen.

how to capture and display messages on the screen?

Thank you,

Comments
Post Details
Added on Dec 2 2024
1 comment
263 views