PLSQL procedure for show success, info, warning notifications

Hi ​@pdollk 

Client_SYS.Add_Info or Client_SYS.Add_Warning but it has limited use.

Hi ​@knepiosko ,

Thank you for your reply. What I want is to call a PL/SQL procedure through a BPA workflow and show an info or warning banner. I already tested this using a workflow, but nothing pops out.

In the technical documentation, it says that Client_SYS.Add_Info adds an information message to the stack. Client Information - Technical Documentation For IFS Cloud

Does this require additional client-side development to display the message as a notification or banner in the UI?

Add_Info will be shown (as an Info message, so a blue message) as long as the method you’re calling (from a projection action) has the parameter supportwarnings = [true];

These actions are linked to PLSVC Methods that will be generated with an  info$_ OUT parameter.

You can assign a value to this OUT variable and it will then be displayed in the client once the Method has finished running.

Here’s an example:

I don’t know if it’s possible to do this through BPA though, never tested that.

Hi ​@SimonTestard ,

Thank you for the reply. Here is what I have done so far.

.projection

.plsvc

workflow

projection action for workflow trigger

But when I update a locality record, nothing happens. Do you have any suggestions?

thank u.

just as a quick test could you try and make sure to use a translate key in the errror message ?

so like “lu_name_, ‘KEYTEST: Sample Info Message’

(Also, If you open Devtools, can you see the projection action being called at all?)

Hi ​@SimonTestard ,

Thank you for your support. I changed the .plsvc file as you asked, as shown below, and it was deployed successfully to the database.

and the workflow is triggering correctly,

but no Info message is displayed. 😶

It’s very possible that this sort of thing is not supported by BPA.

If you try to create a Command that calls the  same action, is the Info Message displayed? If so, it probably means the framework doesn’t receive BPA info messages in the same way and therefore doesn’t display them.

I know BPA can take the “out” info$_ value of your action and then show it as an error message if you want, but I don’t know if it can actually show it as an info or warning message.

Hi ​@SimonTestard ,

I created a command in the .client file and called the same action InforBanner(). I received the info message as expected. It seems that Client_SYS.Add_Info cannot be used to display an info message through BPA.

Hi,

Any other ideas?

Sorry, no other ideas when using BPA, like I said BPA has an option to display errors as a process end, but I don’t know if there’s any way to make it display a message as an info or warning message.

It is surprising that this functionality is not available out of the box. Providing clear feedback to the user about what is happening during execution is, in my opinion, a fundamental requirement for usability and troubleshooting.

At the moment, the only reliable way to surface meaningful messages seems to be through PL/SQL Error_SYS.Record_General, which is not ideal because it stops and rolls all changes back.