Skip to main content
Solved

API Call not Found in Attendance, only SVC in Cloud

  • April 30, 2025
  • 1 reply
  • 70 views

Forum|alt.badge.img+1

In Apps9 prior to upgrading to Cloud we used to use the API call Time_Pers_Diary_Result_API.New and Modify used to work. Now this is the only code I can find using the debug tool in 23r1:

DECLARE
return_array_ Time_Registration_Manager_Handling_SVC.Dialog_Result_Structure_Arr;
cursor_ SYS_REFCURSOR;
BEGIN
return_array_ := Time_Registration_Manager_Handling_SVC.Do_Report_Date_Range_With_Intervals('TIME_REGISTRATION_ATTENDANCE', 'FALSE', 'TRUE', 'FALSE', 'FALSE', 'FALSE', 'FALSE', 'FALSE', 'FALSE', 'FALSE', 'FALSE', 'FALSE', 'FALSE', 'FALSE', 'FALSE', '10', '826', TO_DATE('2025-04-09','YYYY-MM-DD'), NULL, 'JEH', NULL, NULL, NULL, NULL, 'M', 'M', NULL, NULL, '', NULL, NULL, 'L', 'O', 'NAT_DB', NULL, NULL, '101481020', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, 'FALSE', 'FALSE', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'FALSE', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '3', :JobTransactionParams, NULL, TO_DATE('2025-04-09','YYYY-MM-DD'), TO_DATE('2025-04-09','YYYY-MM-DD'), 'FALSE', 'FALSE', 'FALSE', NULL, unbound## => '');
OPEN cursor_ FOR SELECT * FROM TABLE(return_array_);
NULL := cursor_;
END;


How do I debug what API calls are in this SVC so I can use it in the custom event? I tried to look in the debug tool but couldn't find it.

 

Anyone found the same problem?

Best answer by Marcel.Ausan

@Robert Perez you can use the SVC package directly in your event. You just need to make sure you set OData session to true.

 

Basically you’ll have your event action code something like that. I’ve used that multiple times and it works like a charm.

DECLARE

   return_array_ Time_Registration_Manager_Handling_SVC.Dialog_Result_Structure_Arr;

   ….

BEGIN

  Fnd_Session_API.Set_Property('ODP_SESSION', 'TRUE');

  return_array_ := Time_Registration_Manager_Handling_SVC.Do_Report_Date_Range_With_Intervals('TIME_REGISTRATION_ATTENDANCE', 'FALSE', 'TRUE', 'FALSE', 'FALSE', 'FALSE', 'FALSE', 'FALSE', 'FALSE', 'FALSE', 'FALSE', 'FALSE', 'FALSE', 'FALSE', 'FALSE', '10', '826', TO_DATE('2025-04-09','YYYY-MM-DD'), NULL, 'JEH', NULL, NULL, NULL, NULL, 'M', 'M', NULL, NULL, '', NULL, NULL, 'L', 'O', 'NAT_DB', NULL, NULL, '101481020', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, 'FALSE', 'FALSE', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'FALSE', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '3', :JobTransactionParams, NULL, TO_DATE('2025-04-09','YYYY-MM-DD'), TO_DATE('2025-04-09','YYYY-MM-DD'), 'FALSE', 'FALSE', 'FALSE', NULL, unbound## => '');

  Fnd_Session_API.Set_Property('ODP_SESSION', 'FALSE');

END;

 

1 reply

Marcel.Ausan
Ultimate Hero (Partner)
Forum|alt.badge.img+22
  • Ultimate Hero (Partner)
  • 1306 replies
  • Answer
  • April 30, 2025

@Robert Perez you can use the SVC package directly in your event. You just need to make sure you set OData session to true.

 

Basically you’ll have your event action code something like that. I’ve used that multiple times and it works like a charm.

DECLARE

   return_array_ Time_Registration_Manager_Handling_SVC.Dialog_Result_Structure_Arr;

   ….

BEGIN

  Fnd_Session_API.Set_Property('ODP_SESSION', 'TRUE');

  return_array_ := Time_Registration_Manager_Handling_SVC.Do_Report_Date_Range_With_Intervals('TIME_REGISTRATION_ATTENDANCE', 'FALSE', 'TRUE', 'FALSE', 'FALSE', 'FALSE', 'FALSE', 'FALSE', 'FALSE', 'FALSE', 'FALSE', 'FALSE', 'FALSE', 'FALSE', 'FALSE', '10', '826', TO_DATE('2025-04-09','YYYY-MM-DD'), NULL, 'JEH', NULL, NULL, NULL, NULL, 'M', 'M', NULL, NULL, '', NULL, NULL, 'L', 'O', 'NAT_DB', NULL, NULL, '101481020', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, 'FALSE', 'FALSE', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'FALSE', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '3', :JobTransactionParams, NULL, TO_DATE('2025-04-09','YYYY-MM-DD'), TO_DATE('2025-04-09','YYYY-MM-DD'), 'FALSE', 'FALSE', 'FALSE', NULL, unbound## => '');

  Fnd_Session_API.Set_Property('ODP_SESSION', 'FALSE');

END;