Skip to main content
Question

Pop-up message in Time registration

  • August 23, 2024
  • 1 reply
  • 100 views

Forum|alt.badge.img+2

Hey community,

we are trying to improve the Time registration process for our users and want to add pop-up information message to remind users to confirm their hours entered when week is completed.

I have set up a Custom Event to LU TimmanJobTrans and table TIMMAN_JOB_TRANS_TAB. It fires upon new records created and records changed. So far it’s working.
I have also added two Event Actions to this event: 

  1. Type: E-Mail - which works just fine but was considered only for testing reasons (check if the event is fired etc.)
  2. Type: Execute Online SQL - which seems to be not firing or at least the pop-up message doesn’t show up.

Can anyone assist on making the Online SQL Event action work?

DECLARE
   msg_de VARCHAR2(200) := 'DE';
   msg_en VARCHAR2(200) := 'EN';
   msq_output VARCHAR2(200);

   job_status_ VARCHAR2(50);

BEGIN

   IF '#USER_LANGUAGE#' = 'de' THEN
      msq_output := msg_de;
   ELSE 
      msq_output := msg_en;
   END IF;

   job_status_ := IFSAPP.Project_Pers_Diary_API.Date_Intervall_Confirm_Status('&NEW:COMPANY_ID', '&NEW:EMP_NO', TO_DATE('&NEW:ACCOUNT_DATE', 'YYYY-MM-DD'), TO_DATE('&NEW:ACCOUNT_DATE', 'YYYY-MM-DD')+6);

      --IF job_status_ = 'PARTLY CONFIRMED' THEN
         Client_SYS.Add_Info('CompanyPerson', msq_output);
      --END IF;

END; 

The If statement at the end should not actually be commented out, but I have commented it out for testing purposes. Nevertheless, no message appears.

Forum|alt.badge.img+2
  • Do Gooder (Customer)
  • October 14, 2024

Any suggestions on this?


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings