eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_EVT_BUS2 dependencies on HR_UTILITY

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

27: l_proc varchar2(72) := g_package||'lock_event';
28: --
29: Begin
30: --
31: hr_utility.set_location('Entering:'||l_proc, 5);
32: --
33: open get_event;
34: fetch get_event into l_evt_object_version_number;
35: if get_event%notfound then

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

38: --
39: ota_evt_shd.lck(p_event_id
40: ,l_evt_object_version_number);
41: --
42: hr_utility.set_location('Leaving:'||l_proc, 10);
43: --
44: end LOCK_EVENT;
45: --
46: -- ----------------------------------------------------------------------------

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

73: l_proc varchar2(72) := g_package||'get_total_places';
74: --
75: begin
76: --
77: hr_utility.set_location('Entering:'||l_proc, 5);
78: --
79: open get_total_places;
80: fetch get_total_places into l_tdb_total_places;
81: close get_total_places;

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

81: close get_total_places;
82: --
83: return l_tdb_total_places;
84: --
85: hr_utility.set_location('Leaving:'||l_proc, 10);
86: --
87: end Get_Total_Places;
88: --
89: -- ----------------------------------------------------------------------------

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

106: l_proc varchar2(72) := g_package||'check_places';
107: --
108: begin
109: --
110: hr_utility.set_location('Entering:'||l_proc, 5);
111: --
112: if p_maximum_attendees is not null and p_maximum_internal_attendees is not null then
113: if p_maximum_internal_attendees > p_maximum_attendees then
114: fnd_message.set_name('OTA','OTA_13512_EVT_MAX_ATT');

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

129: fnd_message.raise_error;
130: end if;
131: end if;
132: --
133: hr_utility.set_location('Leaving:'||l_proc, 10);
134: --
135: end Check_Places;
136: --
137: -- ----------------------------------------------------------------------------

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

180:
181: --
182: begin
183: --
184: hr_utility.set_location('Entering:'||l_proc, 5);
185: --
186: if p_event_status in ('N','F') then
187: if p_maximum_attendees is not null then
188: l_total_places := get_total_places('ALL',p_event_id);

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

221: end if;
222: end if;
223: end if;
224: --
225: hr_utility.set_location('Leaving:'||l_proc, 10);
226: --
227: end Reset_Event_Status;
228: --
229: -- ----------------------------------------------------------------------------

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

245: l_proc varchar2(72) := g_package||'resource_booking_exists';
246: --
247: begin
248: --
249: hr_utility.set_location('Entering:'|| l_proc, 5);
250: --
251: -- Check if resource_booking exists.
252: --
253: open c_check_resource_bookings;

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

259: else
260: return true;
261: end if;
262: --
263: hr_utility.set_location('Leaving:'|| l_proc, 10);
264: --
265: end Resource_Booking_Exists;
266: --
267: --

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

286: l_proc varchar2(72) := g_package||'finance_line_exists';
287: --
288: begin
289: --
290: hr_utility.set_location('Entering:'|| l_proc, 5);
291: --
292: -- Check if finance line exists.
293: --
294: open c_check_finance_line;

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

300: else
301: return true;
302: end if;
303: --
304: hr_utility.set_location('Leaving:'|| l_proc, 10);
305: --
306: end Finance_Line_Exists;
307: --
308: --

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

325: --
326: --
327: begin
328: --
329: hr_utility.set_location('Entering:'|| l_proc, 5);
330: --
331: ota_evt_shd.get_event_details(p_event_id,p_rec,p_event_exists);
332: --
333: if p_rec.maximum_attendees is not null then

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

337: end if;
338: --
339: return l_vacancies;
340: --
341: hr_utility.set_location('Leaving:'|| l_proc, 10);
342: --
343: end Get_Vacancies;
344: --
345: --

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

372: Begin
373: --
374: ota_evt_shd.get_event_details(p_event_id,l_rec,l_event_exists);
375: --
376: hr_utility.set_location('Entering:'|| l_proc, 5);
377: --
378: if p_event_type = 'ENROLLMENT' then
379: --
380: l_old_booking_status := ota_tdb_bus.booking_status_type(

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

405: return (false);
406: --
407: end if;
408: --
409: hr_utility.set_location('Leaving:'|| l_proc, 10);
410: --
411: end Wait_List_Required;
412: --
413: -- --------------------------------------------------------------------------------------------

Line 432: hr_utility.set_location('Leaving:'|| l_proc, 5);

428: l_mandatory_assoc_exists number;
429:
430: begin
431:
432: hr_utility.set_location('Leaving:'|| l_proc, 5);
433: -- check if mandatory associations are defined for the class
434: OPEN check_mandatory_assoc;
435: FETCH check_mandatory_assoc into l_mandatory_assoc_exists;
436: CLOSE check_mandatory_assoc;

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

440: else
441: return true;
442: end if;
443:
444: hr_utility.set_location('Leaving:'|| l_proc, 10);
445:
446: end mandatory_associations_exists;
447:
448:

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

468: l_proc varchar2(72) := g_package||'check_mandatory_associations';
469: --
470: begin
471: --
472: hr_utility.set_location('Entering:'||l_proc, 5);
473: --
474: if p_maximum_attendees is not null or p_maximum_internal_attendees is not null then
475: if ((l_mandatory_association_exists and p_maximum_attendees >= 0) or
476: (l_mandatory_association_exists and p_maximum_internal_attendees >= 0)) then

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

479: end if;
480:
481: end if;
482: --
483: hr_utility.set_location('Leaving:'||l_proc, 10);
484: --
485: end Check_Mandatory_Associations;
486: end ota_evt_bus2;