DBA Data[Home] [Help]

APPS.OTA_EVT_API_UPD2 dependencies on HR_UTILITY

Line 44: hr_utility.set_location('Entering:'||l_proc, 5);

40: l_proc varchar2(72) := g_package||'check_status_change';
41: --
42: begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: -- Get Event Record
47: --
48: ota_evt_shd.get_event_details (p_event_id,

Line 114: hr_utility.set_location('Leaving:'||l_proc, 10);

110: end if;
111: end if;
112: --
113: --
114: hr_utility.set_location('Leaving:'||l_proc, 10);
115: --
116: end Check_Status_Change;
117: --
118: --

Line 151: hr_utility.set_location('Entering:'||l_proc, 5);

147:
148: --
149: begin
150: --
151: hr_utility.set_location('Entering:'||l_proc, 5);
152: --
153: --
154: if p_maximum_attendees is null then
155: --Bug 6640334/6705591:Admin should be able to nullify the maximum attendees set previously.

Line 196: hr_utility.set_location('Leaving:'||l_proc, 10);

192: end if;
193: end if;
194: end if;
195: --
196: hr_utility.set_location('Leaving:'||l_proc, 10);
197: --
198: end Check_Maximum_Attendees;
199: --
200: --

Line 248: hr_utility.set_location('Entering:'|| l_proc, 5);

244: l_proc varchar2(72) := g_package||'process_event_change';
245: --
246: begin
247: --
248: hr_utility.set_location('Entering:'|| l_proc, 5);
249: --
250: FOR c_get_enrollment in c_get_event_enrollments LOOP
251: --
252: --

Line 304: hr_utility.set_location('Leaving:'|| l_proc, 10);

300: end if;
301: --
302: END LOOP get_enrollment;
303: --
304: hr_utility.set_location('Leaving:'|| l_proc, 10);
305: --
306: --
307: end Process_Event_Change;
308: --

Line 331: hr_utility.set_location('Entering:'|| l_proc, 5);

327: l_proc varchar2(72) := g_package||'reset_max_attendees';
328: --
329: begin
330: --
331: hr_utility.set_location('Entering:'|| l_proc, 5);
332: --
333: -- If reset_max_attendees selected then only fire When new event Status is
334: -- Closed.
335: --

Line 349: hr_utility.set_location('Leaving:'|| l_proc, 10);

345: end if;
346: end if;
347: end if;
348: --
349: hr_utility.set_location('Leaving:'|| l_proc, 10);
350: --
351: end Reset_Max_Attendees;
352: --
353: --

Line 385: hr_utility.set_location('Entering:'|| l_proc, 5);

381: l_proc varchar2(72) := g_package||'update_event';
382: --
383: begin
384: --
385: hr_utility.set_location('Entering:'|| l_proc, 5);
386: --
387: -- Issue a savepoint if operating in validation only mode.
388: --
389: if p_validate then

Line 393: hr_utility.set_location(l_proc, 6);

389: if p_validate then
390: savepoint update_enrollment;
391: end if;
392: --
393: hr_utility.set_location(l_proc, 6);
394: --
395: -- Validation in addition to Table Handlers.
396: -- Lock Event
397: --

Line 416: hr_utility.set_location(l_proc, 7);

412: ,p_booking_status_type_id => p_booking_status_type_id
413: ,p_maximum_attendees => l_event_rec.maximum_attendees);
414: --
415: --
416: hr_utility.set_location(l_proc, 7);
417: --
418: -- Process Event Status change.
419: --
420: Process_Event_Change(p_event_id => p_event_id

Line 427: hr_utility.set_location(l_proc, 8);

423: ,p_booking_status_type_id => p_booking_status_type_id
424: ,p_date_status_changed => p_date_status_changed);
425:
426: --
427: hr_utility.set_location(l_proc, 8);
428: --
429: -- Reset Max Attendees and Max Internal Attendees. Only when Closed Event
430: -- Status is selected.
431: --

Line 440: hr_utility.set_location(l_proc, 9);

436: ,p_maximum_attendees => l_event_rec.maximum_attendees
437: ,p_maximum_internal_attendees => l_event_rec.maximum_internal_attendees);
438: end if;
439: --
440: hr_utility.set_location(l_proc, 9);
441: --
442: --
443: --
444: else

Line 476: hr_utility.set_location('Leaving:'|| l_proc, 10);

472: -- Enh# 1753511 hdshah Commented out the commit so that we can use update_event procedure for this enhancement.
473: -- Included app_form.quietcommit in OTAEVENT.pll.
474: -- commit;
475: --
476: hr_utility.set_location('Leaving:'|| l_proc, 10);
477: --
478: -- When in validation only mode raise the Validate_Enabled exception
479: --
480: if p_validate then