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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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
0 comments
78 views