Experts,

How has this quirk in Oracle HR been handled on your projects?

Currently overlapping absences is allowed with a warning popup. Traditionally sites which needed to prevent this used a custom library fix.

The current site wants to prevent it both from forms and self service.
Is User Hook on the absence api the best option?

How does the error message transmit back to a self service form.

Thanks in advance.
vin

We've got exactly the same issue here - so we'll watch for words of wisdom!

Vin/Geoff,

OK it's been a while since my last post - but I think I can help with this one…maybe

We used the hook route on;
HR_PERSON_ABSENCE_BK1.CREATE_PERSON_ABSENCE_B
HR_PERSON_ABSENCE_BK2.UPDATE_PERSON_ABSENCE_B

and here's a sample from our exception block which uses registered custom message;

EXCEPTION

WHEN e_overlap_error THEN
hr_utility.set_message (20010,'XXPER_88888_SSP_ABS_OVERLAP');
hr_utility.raise_error;

WHEN e_asg_overlap_error THEN
hr_utility.set_message (20010,'XXPER_88889_ASG_ABS_OVERLAP');
hr_utility.raise_error;

WHEN OTHERS THEN
hr_utility.set_message (20010,'XXPER_88899_ORACLE_ERROR');
hr_utility.set_message_token ('PROCEDURE',g_package||'.'||lv_proc);
hr_utility.set_message_token ('LOCATION',g_location );
hr_utility.set_message_token ('ORA_MESG',SQLERRM);
hr_utility.raise_error;

END check_for_overlap_ins;

These errors appear at the top of the page just like the standard ones (lovely job).

I think the only words of wisdom I can offer is watch out for any approval hierarchy shenanigans records end up in the transaction tables and it can all get a bit messy.

HTH

Jay

Master J,
Thanks for that overalp enlightment, it will be very handy when I attempt absence entries via OTL. Also, will pass this on to Dave C who was laso querying overlapping issues.
Sha