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_TRB_API_PROCEDURES dependencies on HR_UTILITY

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

31: where supplied_resource_id = p_supplied_resource_id
32: and resource_type = p_type;
33: --
34: begin
35: hr_utility.set_location('Entering:'||l_proc,5);
36: --
37: open chk_type;
38: fetch chk_type into l_exists;
39: IF chk_type%found THEN

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

44: close chk_type;
45: --
46: return (l_return);
47: --
48: hr_utility.set_location(' Leaving:'||l_proc, 10);
49: end check_resource_type;
50: --
51: -- ---------------------------------------------------------------------
52: -- |------------------< check_number_delegates >------------------------

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

101: and sr.delegates_per_unit >=
102: nvl(e.maximum_attendees,off.maximum_attendees);
103: --
104: begin
105: hr_utility.set_location('Entering:'||l_proc,5);
106: --
107: open chk_pland;
108: fetch chk_pland into l_plnd;
109: close chk_pland;

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

129: ELSE l_return := TRUE;
130: END IF;
131: return (l_return);
132: --
133: hr_utility.set_location('Leaving:'||l_proc,10);
134: end check_number_delegates; */
135: --
136: -- ---------------------------------------------------------------------
137: -- |-------------------< check_role_to_play >---------------------------

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

153: where lookup_type = 'TRAINER_PARTICIPATION'
154: and lookup_code = p_role_to_play;
155: --
156: begin
157: hr_utility.set_location('Entering:'||l_proc,5);
158: --
159: open chk_roleplay;
160: fetch chk_roleplay into l_exists;
161: IF chk_roleplay%notfound THEN

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

164: fnd_message.raise_error;
165: END IF;
166: close chk_roleplay;
167: --
168: hr_utility.set_location('Leaving:'||l_proc,10);
169: end check_role_to_play;
170: --
171: -- ---------------------------------------------------------------------
172: -- |------------------< check_role_res_type_excl >----------------------

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

179: --
180: l_proc varchar2(72) := g_package||'check_role_res_type_excl';
181: --
182: begin
183: hr_utility.set_location('Entering:'||l_proc,5);
184: --
185: IF p_role_to_play is not null THEN
186: IF not check_resource_type(p_supplied_resource_id,
187: 'T') THEN

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

189: fnd_message.raise_error;
190: END IF;
191: END IF;
192: --
193: hr_utility.set_location('Leaving:'||l_proc,10);
194: end check_role_res_type_excl;
195: --
196: -- ---------------------------------------------------------------------
197: -- |------------------------< get_total_cost >--------------------------

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

244: and sr.supplied_resource_id = rb.supplied_resource_id
245: and e.event_id = p_event_id;
246: --
247: begin
248: hr_utility.set_location('Entering:'||l_proc,5);
249: --
250:
251: open csr_business_group_id ; --bug 4304067
252: fetch csr_business_group_id into l_business_group_id;

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

262: p_total_cost := l_tot;
263: ELSE close chk_curr;
264: END IF;
265: --
266: hr_utility.set_location('Leaving:'||l_proc,10);
267: end get_total_cost;
268: --
269: -- ---------------------------------------------------------------------
270: -- |--------------------< check_quantity_entered >----------------------

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

289: --from ota_suppliable_resources
290: --where supplied_resource_id = p_supplied_resource_id;
291: --
292: begin
293: hr_utility.set_location('Entering:'||l_proc,5);
294: --
295: if p_quantity > 1 then
296: if check_resource_type(p_supplied_resource_id,
297: 'V') THEN

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

312: --end if;
313: end if;
314: end if;
315: --
316: hr_utility.set_location('Leaving:'||l_proc,10);
317: end check_quantity_entered;
318: --
319: -- ---------------------------------------------------------------------
320: -- |-------------------< check_delivery_address >-----------------------

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

337: and sr.resource_type = l.lookup_code
338: and l.lookup_type in ('VENUE','TRAINER');
339: --
340: begin
341: hr_utility.set_location('Entering:'||l_proc,5);
342: --
343: open chk_type;
344: fetch chk_type into l_exists;
345: IF l_exists = '1' AND p_del_add is not null THEN

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

348: fnd_message.raise_error;
349: END IF;
350: close chk_type;
351: --
352: hr_utility.set_location('Leaving:'||l_proc,10);
353: end check_delivery_address;
354: --
355: -- ---------------------------------------------------------------------
356: -- |------------------------< get_resource_booking_id >-----------------

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

374: where supplied_resource_id = p_supplied_resource_id
375: and event_id = p_event_id;
376: --
377: begin
378: hr_utility.set_location('Entering:'||l_proc,5);
379: --
380: open get_book;
381: fetch get_book into l_resbook_id;
382: IF get_book%notfound THEN

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

387: close get_book;
388: --
389: return (l_resbook_id);
390: --
391: hr_utility.set_location('Leaving:'||l_proc,10);
392: end get_resource_booking_id;
393: --
394: -- ---------------------------------------------------------------------
395: -- |-----------------------< resource_booked_for_event >----------------

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

412: from ota_resource_bookings
413: where event_id = p_event_id;
414: --
415: begin
416: hr_utility.set_location('Entering:'||l_proc,5);
417: --
418: open chk_bookings;
419: fetch chk_bookings into l_exists;
420: IF chk_bookings%found THEN l_return := TRUE;

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

423: close chk_bookings;
424: --
425: return (l_return);
426: --
427: hr_utility.set_location('Leaving:'||l_proc,10);
428: end resource_booked_for_event;
429:
430: -- ---------------------------------------------------------------------
431: -- |----------------------------< check_obj_booking_dates >---------------------

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

487: l_timezone varchar2(30) := null;
488: l_id_passed boolean := false;
489: --
490: begin
491: hr_utility.set_location('Entering:'||l_proc,5);
492:
493: if p_event_id is not null then
494: l_id_passed :=true;
495: open get_event_dates;

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

525: end if;
526: close chk_dates_tsr;
527: end if;
528: --
529: hr_utility.set_location('Leaving:'||l_proc,10);
530: end check_obj_booking_dates;
531: --
532: -- ---------------------------------------------------------------------
533: -- |----------------------------< check_dates_tsr >---------------------

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

576: */
577:
578: --
579: begin
580: hr_utility.set_location('Entering:'||l_proc,5);
581: --
582: open chk_dates_tsr;
583: fetch chk_dates_tsr into l_exists;
584: IF chk_dates_tsr%notfound THEN

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

587: fnd_message.raise_error;
588: END IF;
589: close chk_dates_tsr;
590: --
591: hr_utility.set_location('Leaving:'||l_proc,10);
592: end check_dates_tsr;
593: --
594: -- ---------------------------------------------------------------------
595: -- |-------------------------< check_evt_tsr_bus_grp >------------------

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

620: and e.event_id = p_event_id
621: and sr.business_group_id = e.business_group_id;
622: --
623: begin
624: hr_utility.set_location('Entering:'||l_proc,5);
625: --
626: open chk_bgroup;
627: fetch chk_bgroup into l_exists;
628: IF chk_bgroup%notfound THEN

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

631: fnd_message.raise_error;
632: END IF;
633: close chk_bgroup;
634: --
635: hr_utility.set_location('Leaving:'||l_proc,10);
636: end check_evt_tsr_bus_grp;
637: --
638: -- ---------------------------------------------------------------------
639: -- |---------------------------< check_from_to_dates >------------------

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

647: --
648: l_proc varchar2(72) := g_package||'check_from_to_dates';
649: --
650: begin
651: hr_utility.set_location('Entering:'||l_proc,5);
652: --
653: IF p_req_from <= nvl(p_req_to,hr_api.g_eot) THEN null;
654: ELSE fnd_message.set_name('OTA','OTA_13271_TRB_FROM_TO_DATES');
655: fnd_message.raise_error;

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

654: ELSE fnd_message.set_name('OTA','OTA_13271_TRB_FROM_TO_DATES');
655: fnd_message.raise_error;
656: END IF;
657: --
658: hr_utility.set_location('Leaving:'||l_proc,10);
659: end check_from_to_dates;
660: --
661: -- ---------------------------------------------------------------------
662: -- |----------------------------< check_update_tra >--------------------

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

681: OR equipment_resource_booking_id = p_resource_booking_id)
682: and (start_date < p_req_date_from OR end_date > p_req_date_to);
683: --
684: begin
685: hr_utility.set_location('Entering:'||l_proc,5);
686: --
687: open chk_dates;
688: fetch chk_dates into l_exists;
689: IF chk_dates%found THEN

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

692: fnd_message.raise_error;
693: END IF;
694: close chk_dates;
695: --
696: hr_utility.set_location('Leaving:'||l_proc,10);
697: end check_update_tra;
698: --
699: -- ---------------------------------------------------------------------
700: -- |------------------------< check_tra_trainer_exists >----------------

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

716: from ota_resource_allocations
717: where trainer_resource_booking_id = p_resource_booking_id;
718: --
719: begin
720: hr_utility.set_location('Entering:'||l_proc,5);
721: --
722: open chk_trn;
723: fetch chk_trn into l_exists;
724: IF chk_trn%found THEN

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

727: fnd_message.raise_error;
728: END IF;
729: close chk_trn;
730: --
731: hr_utility.set_location('Leaving:'||l_proc,10);
732: end check_tra_trainer_exists;
733: --
734: -- ---------------------------------------------------------------------
735: -- |--------------------< check_tra_resource_exists >-------------------

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

751: from ota_resource_allocations
752: where equipment_resource_booking_id = p_resource_booking_id;
753: --
754: begin
755: hr_utility.set_location('Entering:'||l_proc,5);
756: --
757: open chk_res;
758: fetch chk_res into l_exists;
759: IF chk_res%found THEN

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

762: fnd_message.raise_error;
763: END IF;
764: close chk_res;
765: --
766: hr_utility.set_location('Leaving:'||l_proc,10);
767: end check_tra_resource_exists;
768: --
769: -- ---------------------------------------------------------------------
770: -- |------------------------< check_status >----------------------------

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

786: where lookup_type = 'RESOURCE_BOOKING_STATUS'
787: and lookup_code = p_status;
788: --
789: begin
790: hr_utility.set_location('Entering:'||l_proc,5);
791: --
792: open chk_status;
793: fetch chk_status into l_exists;
794: IF chk_status%notfound THEN

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

799: fnd_message.raise_error;
800: END IF;
801: close chk_status;
802: --
803: hr_utility.set_location('Leaving:'||l_proc,10);
804: end check_status;
805: --
806: -- ---------------------------------------------------------------------
807: -- |-----------------------< check_status_value >-----------------------

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

817: -- left for now until API for events entity written so code can be
818: -- shared. KLS 25/11/94.
819: --
820: begin
821: hr_utility.set_location('Entering:'||l_proc,5);
822: --
823: null;
824: --
825: hr_utility.set_location('Leaving:'||l_proc,10);

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

821: hr_utility.set_location('Entering:'||l_proc,5);
822: --
823: null;
824: --
825: hr_utility.set_location('Leaving:'||l_proc,10);
826: end check_status_value;
827: --
828: -- ---------------------------------------------------------------------
829: -- |---------------------< check_primary_venue >------------------------

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

857: and rb.event_id = p_event_id
858: and rb.resource_booking_id <> nvl(p_resource_booking_id, -1);
859: --
860: begin
861: hr_utility.set_location('Entering:'||l_proc,5);
862: --
863: IF p_prim_ven = 'Y' THEN
864: open chk_primven;
865: fetch chk_primven into l_exists;

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

870: END IF;
871: close chk_primven;
872: END IF;
873: --
874: hr_utility.set_location('Leaving:'||l_proc,10);
875: end check_primary_venue;
876:
877: -- ---------------------------------------------------------------------
878: -- |--------------------< check_booking_conflict >-----------------------|

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

959:
960:
961: --
962: begin
963: hr_utility.set_location('Entering:'||l_proc,5);
964:
965:
966: --
967: open get_resource_type;

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

1064:
1065: --close double_booking;
1066: return l_return_value;
1067: --
1068: hr_utility.set_location('Leaving:'||l_proc,10);
1069:
1070: end check_booking_conflict;
1071:
1072:

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

1154:
1155:
1156: --
1157: begin
1158: hr_utility.set_location('Entering:'||l_proc,5);
1159:
1160:
1161: --
1162: open get_resource_type;

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

1260:
1261: --close double_booking;
1262: return l_return_value;
1263: --
1264: hr_utility.set_location('Leaving:'||l_proc,10);
1265:
1266: end is_booking_conflict;
1267:
1268:

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

1425:
1426:
1427: --
1428: begin
1429: hr_utility.set_location('Entering:'||l_proc,5);
1430: --
1431: open get_resource_type;
1432: fetch get_resource_type into l_resource_type;
1433: close get_resource_type;

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

1604:
1605: --close double_booking;
1606: return FALSE;
1607: --
1608: hr_utility.set_location('Leaving:'||l_proc,10);
1609:
1610: end check_double_booking;
1611:
1612: --

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

1686: where sr.supplied_resource_id = p_supplied_resource_id
1687: and sr.consumable_flag = 'Y';
1688: --
1689: begin
1690: hr_utility.set_location('Entering:'||l_proc,5);
1691: --
1692: open chk_slevels;
1693: fetch chk_slevels into l_sign;
1694: IF chk_slevels%found THEN

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

1699: END IF;
1700: close chk_slevels;
1701: return (l_return);
1702: --
1703: hr_utility.set_location('Leaving:'||l_proc,10);
1704: end deduct_consumable_stock_check; */
1705: --
1706: -- ---------------------------------------------------------------------
1707: -- |---------------------< deduct_consumable_stock >--------------------

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

1724: where tsr.supplied_resource_id = p_supplied_resource_id
1725: and tsr.consumable_flag = 'Y';
1726: --
1727: begin
1728: hr_utility.set_location('Entering:'||l_proc,5);
1729: --
1730: open calc_newstock;
1731: fetch calc_newstock into l_new_stock;
1732: close calc_newstock;

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

1736: update ota_suppliable_resources
1737: set stock = l_new_stock
1738: where supplied_resource_id = p_supplied_resource_id;
1739: --
1740: hr_utility.set_location('Leaving:'||l_proc,10);
1741: end deduct_consumable_stock; */
1742: --
1743: -- ---------------------------------------------------------------------
1744: -- |---------------------< check_if_tfl_exists >------------------------

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

1759: from ota_finance_lines
1760: where resource_booking_id = p_resource_booking_id;
1761: --
1762: begin
1763: hr_utility.set_location('Entering:'||l_proc,5);
1764: --
1765: open chk_tfl;
1766: fetch chk_tfl into l_exists;
1767: IF chk_tfl%found THEN

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

1770: fnd_message.raise_error;
1771: ELSE close chk_tfl;
1772: END IF;
1773: --
1774: hr_utility.set_location('Leaving:'||l_proc,10);
1775: end check_if_tfl_exists;
1776: --
1777: -- -------------------------------------------------------------------
1778: -- |-------------------< check_event_type >---------------------------

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

1795: and event_type in
1796: ('SCHEDULED','SESSION','PROGRAMME MEMBER','DEVELOPMENT','SELFPACED');
1797: --
1798: begin
1799: hr_utility.set_location('Entering:'||l_proc,5);
1800: --
1801: open chk_type;
1802: fetch chk_type into l_exists;
1803: IF chk_type%notfound THEN

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

1806: fnd_message.raise_error;
1807: ELSE close chk_type;
1808: END IF;
1809: --
1810: hr_utility.set_location('Leaving:'||l_proc,10);
1811: end check_event_type;
1812: --
1813: -- -------------------------------------------------------------------
1814: -- |-------------------< check_update_quant_del >---------------------

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

1841: from ota_resource_allocations
1842: where equipment_resource_booking_id = p_resource_booking_id;
1843: --
1844: begin
1845: hr_utility.set_location('Entering:'||l_proc,5);
1846: --
1847: IF p_quantity is not null AND p_del_per_unit is not null THEN
1848: l_calc := p_quantity * p_del_per_unit;
1849: open get_count;

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

1856: ELSE l_return := TRUE;
1857: END IF;
1858: return (l_return);
1859: --
1860: hr_utility.set_location('Leaving:'||l_proc,10);
1861: end check_update_quant_del;
1862: --
1863: -- ------------------------------------------------------------------
1864: -- |---------------------< get_required_resources >------------------

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

1907:
1908: --
1909: Begin
1910: --
1911: hr_utility.set_location('Entering:'||l_proc,5);
1912: --
1913: Open get_resources;
1914: --
1915: Loop

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

1946: Close get_resources;
1947: --
1948: commit;
1949:
1950: hr_utility.set_location('Leaving:'||l_proc,10);
1951: end get_required_resources;
1952:
1953: -- -------------------------------------------------------------------
1954: -- |----------------------< get_evt_defaults >------------------------

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

1980: where evt.event_id = p_event_id
1981: and fnd.currency_code = evt.currency_code;
1982: --
1983: begin
1984: hr_utility.set_location('Entering:'||l_proc,5);
1985: --
1986: open get_defs;
1987: fetch get_defs into p_event_title,
1988: p_event_start_date,

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

1993: p_curr_meaning;
1994: close get_defs;
1995: --
1996: --
1997: hr_utility.set_location('Leaving:'||l_proc,10);
1998: end get_evt_defaults;
1999:
2000: -- ---------------------------------------------------------------------
2001: -- |--------------------< check_start_end_times >-----------------------

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

2009: l_proc varchar2(72) := g_package||'check_start_end_times';
2010: --
2011: begin
2012: --
2013: hr_utility.set_location('Entering:'||l_proc,5);
2014: --
2015: if to_number(substr(p_start_time, 1, 2)) >
2016: to_number(substr(p_end_time, 1, 2))
2017: or (to_number(substr(p_start_time, 1, 2)) =

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

2023: fnd_message.raise_error;
2024: --
2025: end if;
2026: --
2027: hr_utility.set_location('Leaving:'||l_proc,10);
2028: --
2029: end check_start_end_times;
2030: --
2031: ----------------------------------------------------------------------

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

2122:
2123:
2124: begin
2125: --
2126: hr_utility.set_location('Entering:'||l_proc,5);
2127: p_warn := false;
2128: IF p_event_id is not null then
2129: For a in c_resource LOOP
2130: l_resource_type := a.resource_type;

Line 2141: hr_utility.set_location('Entering:'||l_proc,10);

2137: l_language_code := event.language_code;
2138: end loop;
2139:
2140: If l_resource_type = 'T' then
2141: hr_utility.set_location('Entering:'||l_proc,10);
2142: if l_parent_event is not null and
2143: l_event_type = 'SESSION' then
2144: l_event_id := l_parent_event;
2145:

Line 2257: hr_utility.set_location('Entering:'||l_proc,15);

2253: end if;
2254:
2255: end if;
2256: IF l_competence is not null then
2257: hr_utility.set_location('Entering:'||l_proc,15);
2258:
2259: BEGIN
2260:
2261:

Line 2278: hr_utility.set_location('leaving:'||l_proc,20);

2274: p_warn := FALSE;
2275: end if;
2276: end if;
2277: end if;
2278: hr_utility.set_location('leaving:'||l_proc,20);
2279: end check_trainer_competence;
2280:
2281: end ota_trb_api_procedures;