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

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

273: l_add_struct_d hr_dflex_utility.l_ignore_dfcode_varray :=
274: hr_dflex_utility.l_ignore_dfcode_varray();
275:
276: begin
277: hr_utility.set_location('Entering:'||l_proc, 5);
278:
279: l_add_struct_d.extend(1);
280: l_add_struct_d(l_add_struct_d.count) := p_dff_name;
281:

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

281:
282: hr_dflex_utility.create_ignore_df_validation(p_rec => l_add_struct_d);
283:
284:
285: hr_utility.set_location('Leaving:'||l_proc, 5);
286:
287: end ignore_dff_validation;
288:
289:

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

401:
402: l_proc varchar2(72) := g_package||'get_description';
403:
404: BEGIN
405: hr_utility.set_location('Entering:'||l_proc, 5);
406: OPEN c_date_format;
407: FETCH c_date_format into l_date_format;
408: CLOSE c_date_format;
409:

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

407: FETCH c_date_format into l_date_format;
408: CLOSE c_date_format;
409:
410: IF p_uom= 'ENR' THEN
411: hr_utility.set_location('Entering:'||l_proc, 10);
412: l_title_prompt :=
413: ota_utility.Get_lookup_meaning ('OTA_ENROLL_INVOICE' ,'EVENT',810);
414: l_start_prompt :=
415: ota_utility.Get_lookup_meaning ('OTA_ENROLL_INVOICE' ,'START',810);

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

464: End if;
465: CLOSE C_enrollment;
466:
467: ELSIF p_uom = 'EVT' THEN
468: hr_utility.set_location('Entering:'||l_proc, 15);
469: l_title_prompt :=
470: ota_utility.Get_lookup_meaning ('OTA_EVENT_INVOICE' ,'EVENT',810);
471:
472: l_start_prompt :=

Line 521: hr_utility.set_location('Leaving:'||l_proc, 15);

517: End if;
518:
519: CLOSE C_event;
520: END IF;
521: hr_utility.set_location('Leaving:'||l_proc, 15);
522:
523: END;
524:
525: -- ----------------------------------------------------------------------------

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

572: l_proc varchar2(72) := g_package||'get_invoice_rule';
573: l_rule_id ra_rules.rule_id%type;
574:
575: BEGIN
576: hr_utility.set_location('Entering:'||l_proc, 5);
577: OPEN c_invoice_rule;
578: FETCH c_invoice_rule INTO l_rule_id;
579: IF c_invoice_rule%found THEN
580: IF l_rule_id = -2 THEN

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

583: p_invoice_rule := 'ARREARS';
584: END IF;
585: END IF;
586: CLOSE c_invoice_rule;
587: hr_utility.set_location(' Leaving:'||l_proc, 10);
588:
589: END;
590:
591: -- ----------------------------------------------------------------------------

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

637: l_status_type ota_booking_status_types.type%type ;
638:
639:
640: BEGIN
641: hr_utility.set_location('Entering:'||l_proc, 5);
642: OPEN c_status_type;
643: FETCH c_status_type INTO l_status_type;
644: IF c_status_type%found THEN
645: p_type := l_status_type;

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

644: IF c_status_type%found THEN
645: p_type := l_status_type;
646: END IF;
647: CLOSE c_status_type;
648: hr_utility.set_location(' Leaving:'||l_proc, 10);
649:
650: END;
651:
652: --8855548

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

699: l_status_name ota_booking_status_types.name%type ;
700:
701:
702: BEGIN
703: hr_utility.set_location('Entering:'||l_proc, 5);
704: OPEN c_status_type;
705: FETCH c_status_type INTO l_status_name;
706: IF c_status_type%found THEN
707: p_status := l_status_name;

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

707: p_status := l_status_name;
708: END IF;
709: CLOSE c_status_type;
710:
711: hr_utility.set_location(' Leaving:'||l_proc, 10);
712:
713: END;
714:
715:

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

764: l_valid varchar2(1) := 'N';
765:
766: BEGIN
767:
768: hr_utility.set_location('Entering:'||l_proc, 15);
769: open c_enrollment;
770: fetch c_enrollment into l_exists;
771: if c_enrollment%found then
772: l_valid := 'Y';

Line 776: hr_utility.set_location('Leaving:'||l_proc, 15);

772: l_valid := 'Y';
773: end If;
774: CLOSE C_enrollment;
775: x_valid := l_valid;
776: hr_utility.set_location('Leaving:'||l_proc, 15);
777:
778: END;
779: --
780:

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

828: l_valid varchar2(1) := 'N';
829:
830: BEGIN
831:
832: hr_utility.set_location('Entering:'||l_proc, 15);
833: open c_event;
834: fetch c_event into l_exists;
835: if c_event%found then
836: l_valid := 'T';

Line 840: hr_utility.set_location('Leaving:'||l_proc, 15);

836: l_valid := 'T';
837: end If;
838: CLOSE C_event;
839: x_valid := l_valid;
840: hr_utility.set_location('Leaving:'||l_proc, 15);
841:
842: END;
843:
844: --

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

950: line_id = p_line_id;
951:
952:
953: BEGIN
954: hr_utility.set_location('Entering:'||l_proc, 5);
955:
956: OPEN c_invoice;
957: FETCH c_invoice into l_invoice_quantity;
958: IF c_invoice%found THEN

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

964: END IF;
965: CLOSE c_invoice;
966:
967:
968: hr_utility.set_location(' Leaving:'||l_proc, 10);
969: END;
970: --
971: -- ----------------------------------------------------------------------------
972: -- |--------------------------------< CHECK_WF_STATUS>-------------------------|

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

1011: AND item_type = 'OEOL'
1012: AND item_key = to_char(p_line_id);
1013:
1014: BEGIN
1015: hr_utility.set_location('Entering:'||l_proc, 5);
1016: OPEN line_wf;
1017: fetch line_wf into l_exist;
1018: if line_wf%found then
1019: l_return := True;

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

1020: end if;
1021: CLOSE line_wf;
1022: Return(l_return);
1023:
1024: hr_utility.set_location('Leaving:'||l_proc, 10);
1025: END check_wf_status;
1026:
1027:
1028: -- ----------------------------------------------------------------------------

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

1097: l_booking_status varchar2(80);
1098: l_dummy varchar2(80);
1099: --
1100: Begin
1101: hr_utility.set_location('Entering:'||l_proc, 5);
1102: --
1103: p_warn := False;
1104: p_return_status := False;
1105: if p_delegate_person_id is not null then

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

1145: end if;
1146: --
1147:
1148: --
1149: hr_utility.set_location(' Leaving:'||l_proc, 10);
1150: End other_bookings_clash;
1151: -- --------------------------------------------------------------------------
1152: -- |---------------------------------------------------------|--
1153: -- -----------------------------------------------------------------------

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

1179: WHERE org.business_group_id = bg.organization_id
1180: AND org.organization_id = p_organization_id;
1181:
1182: BEGIN
1183: hr_utility.set_location('Entering :'||l_proc,5);
1184: OPEN bg_cr;
1185: FETCH bg_cr INTO l_return;
1186: CLOSE bg_cr;
1187: RETURN l_return;

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

1184: OPEN bg_cr;
1185: FETCH bg_cr INTO l_return;
1186: CLOSE bg_cr;
1187: RETURN l_return;
1188: hr_utility.set_location('Leaving:'||l_proc,10);
1189: EXCEPTION
1190: WHEN others THEN
1191: l_return := NULL;
1192: RETURN l_return;

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

1230:
1231: l_execute_proc VARCHAR2(4000);
1232:
1233: BEGIN
1234: hr_utility.set_location('Entering :'||l_proc,5);
1235: l_check_om_installed := check_product_installed(660);
1236: IF l_check_om_installed = 'Y' THEN
1237: l_execute_proc := '
1238: BEGIN

Line 1252: hr_utility.set_location('Leaving:'||l_proc,80);

1248: OUT p_commitment_number,
1249: OUT p_commitment_start_date,
1250: OUT p_commitment_end_date;
1251: END IF;
1252: hr_utility.set_location('Leaving:'||l_proc,80);
1253: EXCEPTION
1254: WHEN others THEN
1255: hr_utility.set_location('Leaving:'||l_proc,90);
1256: END get_commitment_detail;

Line 1255: hr_utility.set_location('Leaving:'||l_proc,90);

1251: END IF;
1252: hr_utility.set_location('Leaving:'||l_proc,80);
1253: EXCEPTION
1254: WHEN others THEN
1255: hr_utility.set_location('Leaving:'||l_proc,90);
1256: END get_commitment_detail;
1257: --
1258:
1259: -- --------------------------------------------------------------------------

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

1287: l_industry VARCHAR2(1);
1288: l_return_val VARCHAR2(1) := 'N';
1289:
1290: BEGIN
1291: hr_utility.set_location('Entering :'||l_proc,5);
1292: IF (fnd_installation.get ( p_application_id,
1293: p_application_id,
1294: l_status,
1295: l_industry)) THEN

Line 1304: hr_utility.set_location('Leaving:'||l_proc,80);

1300: ELSE
1301: l_return_val := 'N';
1302: END IF;
1303: RETURN l_return_val;
1304: hr_utility.set_location('Leaving:'||l_proc,80);
1305: EXCEPTION
1306: WHEN others THEN
1307: l_return_val := 'N';
1308: RETURN l_return_val;

Line 1309: hr_utility.set_location('Leaving:'||l_proc,90);

1305: EXCEPTION
1306: WHEN others THEN
1307: l_return_val := 'N';
1308: RETURN l_return_val;
1309: hr_utility.set_location('Leaving:'||l_proc,90);
1310: END check_product_installed;
1311:
1312:
1313: -- ----------------------------------------------------------------

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

1377: l_counter NUMBER := 0;
1378:
1379: BEGIN
1380:
1381: hr_utility.set_location('Entering :'||l_proc,5);
1382:
1383: FOR primary_dm_rec IN get_primary_dm_cr
1384: LOOP
1385: l_pr_dm_name := primary_dm_rec.dm_name;

Line 1423: hr_utility.set_location('Leaving :'||l_proc,15);

1419: RETURN l_return;
1420:
1421: EXCEPTION
1422: WHEN others THEN
1423: hr_utility.set_location('Leaving :'||l_proc,15);
1424: RETURN l_return;
1425: END get_delivery_method;
1426:
1427: Function get_delivery_method (p_offering_id in number)

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

1471: IS
1472: l_proc VARCHAR2(72) := g_package||'Students_On_Waitlist';
1473: l_num_waitlisted NUMBER DEFAULT 0;
1474: BEGIN
1475: hr_utility.set_location('Entering :'||l_proc,5);
1476: SELECT COUNT(booking_id)
1477: INTO l_num_waitlisted
1478: FROM ota_delegate_bookings tdb
1479: WHERE tdb.event_id = p_event_id

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

1479: WHERE tdb.event_id = p_event_id
1480: AND tdb.booking_status_type_id IN (SELECT bst.booking_status_type_id
1481: FROM ota_booking_status_types bst
1482: WHERE bst.type = 'W');
1483: hr_utility.set_location('Leaving :'||l_proc,10);
1484: RETURN l_num_waitlisted;
1485:
1486: EXCEPTION
1487:

Line 1489: hr_utility.set_location('Leaving:'||l_proc,15);

1485:
1486: EXCEPTION
1487:
1488: WHEN NO_DATA_FOUND THEN
1489: hr_utility.set_location('Leaving:'||l_proc,15);
1490: RETURN l_num_waitlisted;
1491:
1492: END students_on_waitlist;
1493:

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

1536: tdb.booking_id;
1537:
1538:
1539: BEGIN
1540: hr_utility.set_location('Entering :'||l_proc,5);
1541:
1542: IF fnd_profile.value('OTA_WAITLIST_SORT_CRITERIA') = 'BP' THEN
1543: --
1544: FOR l_waitlist_entry IN c_priority_waitlist

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

1562: --
1563: END LOOP;
1564: --
1565: END IF;
1566: hr_utility.set_location('Leaving :'||l_proc,10);
1567: EXCEPTION
1568: WHEN others THEN
1569: hr_utility.set_location('Leaving :'||l_proc,15);
1570: RETURN l_count;

Line 1569: hr_utility.set_location('Leaving :'||l_proc,15);

1565: END IF;
1566: hr_utility.set_location('Leaving :'||l_proc,10);
1567: EXCEPTION
1568: WHEN others THEN
1569: hr_utility.set_location('Leaving :'||l_proc,15);
1570: RETURN l_count;
1571: END place_on_waitlist;
1572:
1573: -- ----------------------------------------------------------------

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

1617: WHERE o.organization_id = p_training_center_id;
1618:
1619: l_proc VARCHAR2(72) := g_package||'Get_Event_Location';
1620: BEGIN
1621: hr_utility.set_location('Entering :'||l_proc,5);
1622: FOR location1 IN primary_venue_cr
1623: LOOP
1624: l_location_id := location1.location_id;
1625:

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

1640: l_location_id := location3.location_id;
1641: END LOOP;
1642:
1643: END IF;
1644: hr_utility.set_location('Leaving :'||l_proc,10);
1645: RETURN l_location_id;
1646:
1647: EXCEPTION
1648: WHEN others THEN

Line 1649: hr_utility.set_location('Leaving :'||l_proc,15);

1645: RETURN l_location_id;
1646:
1647: EXCEPTION
1648: WHEN others THEN
1649: hr_utility.set_location('Leaving :'||l_proc,15);
1650: RETURN l_location_id;
1651: END get_event_location;
1652: -- ----------------------------------------------------------------
1653: -- --------------------------------------

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

1687: l_fnd_user NUMBER;
1688: l_play VARCHAR2(10) := 'N';
1689:
1690: BEGIN
1691: hr_utility.set_location('Entering :'||l_proc,5);
1692: FOR get_emp IN get_emp_id_cr
1693: LOOP
1694: l_fnd_user := get_emp.employee_id;
1695: END LOOP;

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

1707: AND p_course_end_date >= sysdate
1708: THEN l_play := 'R';
1709: ELSE l_play := 'N';
1710: END IF;
1711: hr_utility.set_location('Leaving :'||l_proc,10);
1712: RETURN l_play;
1713:
1714: EXCEPTION
1715: WHEN others THEN

Line 1716: hr_utility.set_location('Leaving :'||l_proc,15);

1712: RETURN l_play;
1713:
1714: EXCEPTION
1715: WHEN others THEN
1716: hr_utility.set_location('Leaving :'||l_proc,15);
1717: RETURN l_play;
1718: END get_play_button;
1719: -- ----------------------------------------------------------------
1720: -- --------------------< get_authorizer_name >---------------------

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

1769: l_proc VARCHAR2(72) := g_package||'Get_Authorizer_Name';
1770: --
1771: BEGIN
1772: --
1773: hr_utility.set_location('Entering :'||l_proc,5);
1774: --
1775: OPEN get_name_csr (p_authorizer_id, p_course_start_date, p_course_end_date);
1776: FETCH get_name_csr INTO l_full_name;
1777: IF get_name_csr%NOTFOUND THEN

Line 1789: hr_utility.set_location('Leaving :'||l_proc,25);

1785: EXCEPTION
1786: --
1787: WHEN l_authorizer_not_found THEN
1788: --
1789: hr_utility.set_location('Leaving :'||l_proc,25);
1790: l_full_name := NULL;
1791: RETURN l_full_name;
1792: --
1793: WHEN others THEN

Line 1795: hr_utility.set_location('Leaving :'||l_proc,15);

1791: RETURN l_full_name;
1792: --
1793: WHEN others THEN
1794: --
1795: hr_utility.set_location('Leaving :'||l_proc,15);
1796: RETURN l_full_name;
1797:
1798: END get_authorizer_name;
1799:

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

1825: l_msg_text VARCHAR2(2000);
1826: --
1827: BEGIN
1828: --
1829: hr_utility.set_location('Entering :'||l_proc,5);
1830: --
1831: fnd_message.set_name(p_application_code, p_message_code);
1832: l_msg_text := fnd_message.get();
1833: --

Line 1844: hr_utility.set_location('Leaving :'||l_proc,25);

1840: EXCEPTION
1841: --
1842: WHEN l_msg_not_found THEN
1843: --
1844: hr_utility.set_location('Leaving :'||l_proc,25);
1845: RETURN l_msg_text;
1846: --
1847: WHEN others THEN
1848: --

Line 1849: hr_utility.set_location('Leaving :'||l_proc,15);

1845: RETURN l_msg_text;
1846: --
1847: WHEN others THEN
1848: --
1849: hr_utility.set_location('Leaving :'||l_proc,15);
1850: RETURN l_msg_text;
1851:
1852: END get_message;
1853: -- ----------------------------------------------------------------

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

1880: l_date_time DATE;
1881: --
1882: BEGIN
1883: --
1884: hr_utility.set_location('Entering :'||l_proc,5);
1885: --
1886: IF p_time IS NULL THEN
1887: IF p_time_of_day = 'END'
1888: THEN

Line 1903: hr_utility.set_location('Leaving :'||l_proc,15);

1899: EXCEPTION
1900: --
1901: WHEN others THEN
1902: --
1903: hr_utility.set_location('Leaving :'||l_proc,15);
1904: RETURN l_date_time;
1905: END get_date_time;
1906:
1907:

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

1965: l_counter NUMBER := 0;
1966:
1967: BEGIN
1968:
1969: hr_utility.set_location('Entering :'||l_proc,5);
1970:
1971: FOR primary_dm_rec IN get_primary_dm_cr
1972: LOOP
1973: -- bug#2652899

Line 1992: hr_utility.set_location('Leaving :'||l_proc,15);

1988: RETURN l_return_dm_name;
1989:
1990: EXCEPTION
1991: WHEN others THEN
1992: hr_utility.set_location('Leaving :'||l_proc,15);
1993: RETURN l_return;
1994: END get_category_name;
1995:
1996: -- ----------------------------------------------------------------

Line 2228: hr_utility.set_location(' Step:'|| l_proc, 10);

2224: l_enrollment_status VARCHAR2(30) := 'Z'; --Default is Not Enrolled(Status Z)
2225: l_enrollment_status_name ota_booking_status_types_tl.name%TYPE;
2226:
2227: BEGIN
2228: hr_utility.set_location(' Step:'|| l_proc, 10);
2229:
2230: --Default is Not Enrolled
2231: l_enrollment_status_name := get_message('OTA','OTA_443407_NOT_ENROLLED');
2232:

Line 2246: hr_utility.set_location(' Step:'|| l_proc, 20);

2242: Else
2243: RETURN l_enrollment_status_name;
2244: End If;
2245:
2246: hr_utility.set_location(' Step:'|| l_proc, 20);
2247:
2248: END get_enrollment_status;
2249:
2250:

Line 2274: hr_utility.set_location(' Step:'|| l_proc, 10);

2270:
2271: l_proc VARCHAR2(72) := g_package|| 'get_user_fullname';
2272: l_return per_all_people_f.full_name%TYPE;
2273: BEGIN
2274: hr_utility.set_location(' Step:'|| l_proc, 10);
2275: IF p_user_type = 'E' THEN
2276: OPEN c_person_fullname;
2277: FETCH c_person_fullname INTO l_return;
2278: CLOSE c_person_fullname;

Line 2288: hr_utility.set_location(' Step:'|| l_proc, 20);

2284:
2285:
2286: RETURN l_return;
2287:
2288: hr_utility.set_location(' Step:'|| l_proc, 20);
2289:
2290: END get_user_fullname;
2291:
2292: FUNCTION get_person_fullname(p_user_id IN ota_attempts.user_id%TYPE

Line 2307: hr_utility.set_location(' Step:'|| l_proc, 10);

2303:
2304: l_proc VARCHAR2(72) := g_package|| 'get_person_fullname';
2305: l_return per_all_people_f.full_name%TYPE;
2306: BEGIN
2307: hr_utility.set_location(' Step:'|| l_proc, 10);
2308:
2309: OPEN c_person_fullname;
2310: FETCH c_person_fullname INTO l_return;
2311: CLOSE c_person_fullname;

Line 2316: hr_utility.set_location(' Step:'|| l_proc, 20);

2312:
2313:
2314: RETURN l_return;
2315:
2316: hr_utility.set_location(' Step:'|| l_proc, 20);
2317:
2318: END get_person_fullname;
2319:
2320: FUNCTION get_learner_name(p_person_id IN per_all_people_f.person_id%TYPE,

Line 2355: hr_utility.set_location(' Step:'|| l_proc, 10);

2351:
2352: l_proc VARCHAR2(72) := g_package|| 'get_learner_name';
2353: l_return VARCHAR2(500);
2354: BEGIN
2355: hr_utility.set_location(' Step:'|| l_proc, 10);
2356:
2357: IF (p_person_id is not null) THEN
2358: -- Internal Enrollment, Get Learner Name from per_all_people_f
2359: OPEN c_person_name;

Line 2380: hr_utility.set_location(' Step:'|| l_proc, 20);

2376: END IF;
2377:
2378: return l_return;
2379:
2380: hr_utility.set_location(' Step:'|| l_proc, 20);
2381:
2382: EXCEPTION
2383: WHEN others THEN
2384: hr_utility.set_location('Leaving :'||l_proc,15);

Line 2384: hr_utility.set_location('Leaving :'||l_proc,15);

2380: hr_utility.set_location(' Step:'|| l_proc, 20);
2381:
2382: EXCEPTION
2383: WHEN others THEN
2384: hr_utility.set_location('Leaving :'||l_proc,15);
2385: RETURN NULL;
2386: END get_learner_name;
2387:
2388: FUNCTION get_customer_id(p_contact_id IN ota_lp_enrollments.contact_id%TYPE)

Line 2414: hr_utility.set_location(' Step:'|| l_proc, 10);

2410: l_proc VARCHAR2(72) := g_package|| 'get_customer_id';
2411: l_return ota_delegate_bookings.customer_id%TYPE;
2412:
2413: Begin
2414: hr_utility.set_location(' Step:'|| l_proc, 10);
2415:
2416: OPEN c_customer_id;
2417: FETCH c_customer_id INTO l_return;
2418: CLOSE c_customer_id;

Line 2421: hr_utility.set_location(' Step:'|| l_proc, 20);

2417: FETCH c_customer_id INTO l_return;
2418: CLOSE c_customer_id;
2419:
2420: return l_return;
2421: hr_utility.set_location(' Step:'|| l_proc, 20);
2422: End get_customer_id;
2423:
2424: FUNCTION get_cust_org_name(p_organization_id IN ota_delegate_bookings.organization_id%TYPE,
2425: p_customer_id IN ota_delegate_bookings.customer_id%TYPE,

Line 2444: hr_utility.set_location(' Step:'|| l_proc, 10);

2440:
2441: l_proc VARCHAR2(72) := g_package|| 'get_cust_org_name';
2442: l_return VARCHAR2(500);
2443: BEGIN
2444: hr_utility.set_location(' Step:'|| l_proc, 10);
2445:
2446: IF (p_organization_id is not null) THEN
2447: -- Internal Enrollment, Get org_name from hr_all_organization_units
2448: OPEN c_organization_name;

Line 2467: hr_utility.set_location(' Step:'|| l_proc, 20);

2463: END IF;
2464:
2465: return l_return;
2466:
2467: hr_utility.set_location(' Step:'|| l_proc, 20);
2468:
2469: EXCEPTION
2470: WHEN others THEN
2471: hr_utility.set_location('Leaving :'||l_proc,15);

Line 2471: hr_utility.set_location('Leaving :'||l_proc,15);

2467: hr_utility.set_location(' Step:'|| l_proc, 20);
2468:
2469: EXCEPTION
2470: WHEN others THEN
2471: hr_utility.set_location('Leaving :'||l_proc,15);
2472: RETURN NULL;
2473: END get_cust_org_name;
2474:
2475:

Line 2508: hr_utility.set_location('Leaving :'||l_proc,15);

2504: p_path := full_path;
2505:
2506: EXCEPTION
2507: WHEN others THEN
2508: hr_utility.set_location('Leaving :'||l_proc,15);
2509: p_path := null;
2510: End get_catalog_object_path ;
2511:
2512:

Line 2581: hr_utility.set_location('Leaving :'||l_proc,15);

2577: p_path := full_path;
2578:
2579: EXCEPTION
2580: WHEN others THEN
2581: hr_utility.set_location('Leaving :'||l_proc,15);
2582: p_path := null;
2583: End get_content_object_path ;
2584:
2585: -- ----------------------------------------------------------------

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

2607: l_return VARCHAR2(1):= 'F';
2608: l_proc VARCHAR2(72) := g_package||'check_function_access';
2609:
2610: BEGIN
2611: hr_utility.set_location('Entering :'||l_proc,5);
2612:
2613: IF fnd_function.test_instance(function_name => p_function_name) THEN
2614: l_return := 'T';
2615: ELSE

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

2616: l_return := 'F';
2617: END IF;
2618: RETURN l_return;
2619:
2620: hr_utility.set_location('Leaving :'||l_proc,10);
2621: EXCEPTION
2622: WHEN others THEN
2623: l_return := 'F';
2624: RETURN l_return;

Line 2770: hr_utility.set_location(' Step:'|| l_proc, 10);

2766: l_proc VARCHAR2(72) := g_package|| 'get_ext_lrnr_party_id';
2767: l_return number;
2768:
2769: Begin
2770: hr_utility.set_location(' Step:'|| l_proc, 10);
2771:
2772: OPEN get_ext_lrn_party_id;
2773: FETCH get_ext_lrn_party_id INTO l_return;
2774: CLOSE get_ext_lrn_party_id;

Line 2777: hr_utility.set_location(' Step:'|| l_proc, 20);

2773: FETCH get_ext_lrn_party_id INTO l_return;
2774: CLOSE get_ext_lrn_party_id;
2775:
2776: return l_return;
2777: hr_utility.set_location(' Step:'|| l_proc, 20);
2778: End get_ext_lrnr_party_id;
2779:
2780: FUNCTION is_class_enrollable(
2781: p_class_id ota_events.event_id%TYPE)