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: -- ----------------------------------------------------------------------------

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

700: l_valid varchar2(1) := 'N';
701:
702: BEGIN
703:
704: hr_utility.set_location('Entering:'||l_proc, 15);
705: open c_enrollment;
706: fetch c_enrollment into l_exists;
707: if c_enrollment%found then
708: l_valid := 'Y';

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

708: l_valid := 'Y';
709: end If;
710: CLOSE C_enrollment;
711: x_valid := l_valid;
712: hr_utility.set_location('Leaving:'||l_proc, 15);
713:
714: END;
715: --
716:

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_event;
770: fetch c_event into l_exists;
771: if c_event%found then
772: l_valid := 'T';

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

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

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

886: line_id = p_line_id;
887:
888:
889: BEGIN
890: hr_utility.set_location('Entering:'||l_proc, 5);
891:
892: OPEN c_invoice;
893: FETCH c_invoice into l_invoice_quantity;
894: IF c_invoice%found THEN

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

900: END IF;
901: CLOSE c_invoice;
902:
903:
904: hr_utility.set_location(' Leaving:'||l_proc, 10);
905: END;
906: --
907: -- ----------------------------------------------------------------------------
908: -- |--------------------------------< CHECK_WF_STATUS>-------------------------|

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

947: AND item_type = 'OEOL'
948: AND item_key = to_char(p_line_id);
949:
950: BEGIN
951: hr_utility.set_location('Entering:'||l_proc, 5);
952: OPEN line_wf;
953: fetch line_wf into l_exist;
954: if line_wf%found then
955: l_return := True;

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

956: end if;
957: CLOSE line_wf;
958: Return(l_return);
959:
960: hr_utility.set_location('Leaving:'||l_proc, 10);
961: END check_wf_status;
962:
963:
964: -- ----------------------------------------------------------------------------

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

1033: l_booking_status varchar2(80);
1034: l_dummy varchar2(80);
1035: --
1036: Begin
1037: hr_utility.set_location('Entering:'||l_proc, 5);
1038: --
1039: p_warn := False;
1040: p_return_status := False;
1041: if p_delegate_person_id is not null then

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

1081: end if;
1082: --
1083:
1084: --
1085: hr_utility.set_location(' Leaving:'||l_proc, 10);
1086: End other_bookings_clash;
1087: -- --------------------------------------------------------------------------
1088: -- |---------------------------------------------------------|--
1089: -- -----------------------------------------------------------------------

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

1115: WHERE org.business_group_id = bg.organization_id
1116: AND org.organization_id = p_organization_id;
1117:
1118: BEGIN
1119: hr_utility.set_location('Entering :'||l_proc,5);
1120: OPEN bg_cr;
1121: FETCH bg_cr INTO l_return;
1122: CLOSE bg_cr;
1123: RETURN l_return;

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

1120: OPEN bg_cr;
1121: FETCH bg_cr INTO l_return;
1122: CLOSE bg_cr;
1123: RETURN l_return;
1124: hr_utility.set_location('Leaving:'||l_proc,10);
1125: EXCEPTION
1126: WHEN others THEN
1127: l_return := NULL;
1128: RETURN l_return;

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

1166:
1167: l_execute_proc VARCHAR2(4000);
1168:
1169: BEGIN
1170: hr_utility.set_location('Entering :'||l_proc,5);
1171: l_check_om_installed := check_product_installed(660);
1172: IF l_check_om_installed = 'Y' THEN
1173: l_execute_proc := '
1174: BEGIN

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

1184: OUT p_commitment_number,
1185: OUT p_commitment_start_date,
1186: OUT p_commitment_end_date;
1187: END IF;
1188: hr_utility.set_location('Leaving:'||l_proc,80);
1189: EXCEPTION
1190: WHEN others THEN
1191: hr_utility.set_location('Leaving:'||l_proc,90);
1192: END get_commitment_detail;

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

1187: END IF;
1188: hr_utility.set_location('Leaving:'||l_proc,80);
1189: EXCEPTION
1190: WHEN others THEN
1191: hr_utility.set_location('Leaving:'||l_proc,90);
1192: END get_commitment_detail;
1193: --
1194:
1195: -- --------------------------------------------------------------------------

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

1223: l_industry VARCHAR2(1);
1224: l_return_val VARCHAR2(1) := 'N';
1225:
1226: BEGIN
1227: hr_utility.set_location('Entering :'||l_proc,5);
1228: IF (fnd_installation.get ( p_application_id,
1229: p_application_id,
1230: l_status,
1231: l_industry)) THEN

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

1236: ELSE
1237: l_return_val := 'N';
1238: END IF;
1239: RETURN l_return_val;
1240: hr_utility.set_location('Leaving:'||l_proc,80);
1241: EXCEPTION
1242: WHEN others THEN
1243: l_return_val := 'N';
1244: RETURN l_return_val;

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

1241: EXCEPTION
1242: WHEN others THEN
1243: l_return_val := 'N';
1244: RETURN l_return_val;
1245: hr_utility.set_location('Leaving:'||l_proc,90);
1246: END check_product_installed;
1247:
1248:
1249: -- ----------------------------------------------------------------

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

1313: l_counter NUMBER := 0;
1314:
1315: BEGIN
1316:
1317: hr_utility.set_location('Entering :'||l_proc,5);
1318:
1319: FOR primary_dm_rec IN get_primary_dm_cr
1320: LOOP
1321: l_pr_dm_name := primary_dm_rec.dm_name;

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

1355: RETURN l_return;
1356:
1357: EXCEPTION
1358: WHEN others THEN
1359: hr_utility.set_location('Leaving :'||l_proc,15);
1360: RETURN l_return;
1361: END get_delivery_method;
1362:
1363: Function get_delivery_method (p_offering_id in number)

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

1407: IS
1408: l_proc VARCHAR2(72) := g_package||'Students_On_Waitlist';
1409: l_num_waitlisted NUMBER DEFAULT 0;
1410: BEGIN
1411: hr_utility.set_location('Entering :'||l_proc,5);
1412: SELECT COUNT(booking_id)
1413: INTO l_num_waitlisted
1414: FROM ota_delegate_bookings tdb
1415: WHERE tdb.event_id = p_event_id

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

1415: WHERE tdb.event_id = p_event_id
1416: AND tdb.booking_status_type_id IN (SELECT bst.booking_status_type_id
1417: FROM ota_booking_status_types bst
1418: WHERE bst.type = 'W');
1419: hr_utility.set_location('Leaving :'||l_proc,10);
1420: RETURN l_num_waitlisted;
1421:
1422: EXCEPTION
1423:

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

1421:
1422: EXCEPTION
1423:
1424: WHEN NO_DATA_FOUND THEN
1425: hr_utility.set_location('Leaving:'||l_proc,15);
1426: RETURN l_num_waitlisted;
1427:
1428: END students_on_waitlist;
1429:

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

1472: tdb.booking_id;
1473:
1474:
1475: BEGIN
1476: hr_utility.set_location('Entering :'||l_proc,5);
1477:
1478: IF fnd_profile.value('OTA_WAITLIST_SORT_CRITERIA') = 'BP' THEN
1479: --
1480: FOR l_waitlist_entry IN c_priority_waitlist

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

1498: --
1499: END LOOP;
1500: --
1501: END IF;
1502: hr_utility.set_location('Leaving :'||l_proc,10);
1503: EXCEPTION
1504: WHEN others THEN
1505: hr_utility.set_location('Leaving :'||l_proc,15);
1506: RETURN l_count;

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

1501: END IF;
1502: hr_utility.set_location('Leaving :'||l_proc,10);
1503: EXCEPTION
1504: WHEN others THEN
1505: hr_utility.set_location('Leaving :'||l_proc,15);
1506: RETURN l_count;
1507: END place_on_waitlist;
1508:
1509: -- ----------------------------------------------------------------

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

1553: WHERE o.organization_id = p_training_center_id;
1554:
1555: l_proc VARCHAR2(72) := g_package||'Get_Event_Location';
1556: BEGIN
1557: hr_utility.set_location('Entering :'||l_proc,5);
1558: FOR location1 IN primary_venue_cr
1559: LOOP
1560: l_location_id := location1.location_id;
1561:

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

1576: l_location_id := location3.location_id;
1577: END LOOP;
1578:
1579: END IF;
1580: hr_utility.set_location('Leaving :'||l_proc,10);
1581: RETURN l_location_id;
1582:
1583: EXCEPTION
1584: WHEN others THEN

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

1581: RETURN l_location_id;
1582:
1583: EXCEPTION
1584: WHEN others THEN
1585: hr_utility.set_location('Leaving :'||l_proc,15);
1586: RETURN l_location_id;
1587: END get_event_location;
1588: -- ----------------------------------------------------------------
1589: -- --------------------------------------

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

1623: l_fnd_user NUMBER;
1624: l_play VARCHAR2(10) := 'N';
1625:
1626: BEGIN
1627: hr_utility.set_location('Entering :'||l_proc,5);
1628: FOR get_emp IN get_emp_id_cr
1629: LOOP
1630: l_fnd_user := get_emp.employee_id;
1631: END LOOP;

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

1643: AND p_course_end_date >= sysdate
1644: THEN l_play := 'R';
1645: ELSE l_play := 'N';
1646: END IF;
1647: hr_utility.set_location('Leaving :'||l_proc,10);
1648: RETURN l_play;
1649:
1650: EXCEPTION
1651: WHEN others THEN

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

1648: RETURN l_play;
1649:
1650: EXCEPTION
1651: WHEN others THEN
1652: hr_utility.set_location('Leaving :'||l_proc,15);
1653: RETURN l_play;
1654: END get_play_button;
1655: -- ----------------------------------------------------------------
1656: -- --------------------< get_authorizer_name >---------------------

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

1705: l_proc VARCHAR2(72) := g_package||'Get_Authorizer_Name';
1706: --
1707: BEGIN
1708: --
1709: hr_utility.set_location('Entering :'||l_proc,5);
1710: --
1711: OPEN get_name_csr (p_authorizer_id, p_course_start_date, p_course_end_date);
1712: FETCH get_name_csr INTO l_full_name;
1713: IF get_name_csr%NOTFOUND THEN

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

1721: EXCEPTION
1722: --
1723: WHEN l_authorizer_not_found THEN
1724: --
1725: hr_utility.set_location('Leaving :'||l_proc,25);
1726: l_full_name := NULL;
1727: RETURN l_full_name;
1728: --
1729: WHEN others THEN

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

1727: RETURN l_full_name;
1728: --
1729: WHEN others THEN
1730: --
1731: hr_utility.set_location('Leaving :'||l_proc,15);
1732: RETURN l_full_name;
1733:
1734: END get_authorizer_name;
1735:

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

1761: l_msg_text VARCHAR2(2000);
1762: --
1763: BEGIN
1764: --
1765: hr_utility.set_location('Entering :'||l_proc,5);
1766: --
1767: fnd_message.set_name(p_application_code, p_message_code);
1768: l_msg_text := fnd_message.get();
1769: --

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

1776: EXCEPTION
1777: --
1778: WHEN l_msg_not_found THEN
1779: --
1780: hr_utility.set_location('Leaving :'||l_proc,25);
1781: RETURN l_msg_text;
1782: --
1783: WHEN others THEN
1784: --

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

1781: RETURN l_msg_text;
1782: --
1783: WHEN others THEN
1784: --
1785: hr_utility.set_location('Leaving :'||l_proc,15);
1786: RETURN l_msg_text;
1787:
1788: END get_message;
1789: -- ----------------------------------------------------------------

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

1816: l_date_time DATE;
1817: --
1818: BEGIN
1819: --
1820: hr_utility.set_location('Entering :'||l_proc,5);
1821: --
1822: IF p_time IS NULL THEN
1823: IF p_time_of_day = 'END'
1824: THEN

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

1835: EXCEPTION
1836: --
1837: WHEN others THEN
1838: --
1839: hr_utility.set_location('Leaving :'||l_proc,15);
1840: RETURN l_date_time;
1841: END get_date_time;
1842:
1843:

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

1901: l_counter NUMBER := 0;
1902:
1903: BEGIN
1904:
1905: hr_utility.set_location('Entering :'||l_proc,5);
1906:
1907: FOR primary_dm_rec IN get_primary_dm_cr
1908: LOOP
1909: -- bug#2652899

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

1924: RETURN l_return_dm_name;
1925:
1926: EXCEPTION
1927: WHEN others THEN
1928: hr_utility.set_location('Leaving :'||l_proc,15);
1929: RETURN l_return;
1930: END get_category_name;
1931:
1932: -- ----------------------------------------------------------------

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

2160: l_enrollment_status VARCHAR2(30) := 'Z'; --Default is Not Enrolled(Status Z)
2161: l_enrollment_status_name ota_booking_status_types_tl.name%TYPE;
2162:
2163: BEGIN
2164: hr_utility.set_location(' Step:'|| l_proc, 10);
2165:
2166: --Default is Not Enrolled
2167: l_enrollment_status_name := get_message('OTA','OTA_443407_NOT_ENROLLED');
2168:

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

2178: Else
2179: RETURN l_enrollment_status_name;
2180: End If;
2181:
2182: hr_utility.set_location(' Step:'|| l_proc, 20);
2183:
2184: END get_enrollment_status;
2185:
2186:

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

2206:
2207: l_proc VARCHAR2(72) := g_package|| 'get_user_fullname';
2208: l_return per_all_people_f.full_name%TYPE;
2209: BEGIN
2210: hr_utility.set_location(' Step:'|| l_proc, 10);
2211: IF p_user_type = 'E' THEN
2212: OPEN c_person_fullname;
2213: FETCH c_person_fullname INTO l_return;
2214: CLOSE c_person_fullname;

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

2220:
2221:
2222: RETURN l_return;
2223:
2224: hr_utility.set_location(' Step:'|| l_proc, 20);
2225:
2226: END get_user_fullname;
2227:
2228: FUNCTION get_person_fullname(p_user_id IN ota_attempts.user_id%TYPE

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

2239:
2240: l_proc VARCHAR2(72) := g_package|| 'get_person_fullname';
2241: l_return per_all_people_f.full_name%TYPE;
2242: BEGIN
2243: hr_utility.set_location(' Step:'|| l_proc, 10);
2244:
2245: OPEN c_person_fullname;
2246: FETCH c_person_fullname INTO l_return;
2247: CLOSE c_person_fullname;

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

2248:
2249:
2250: RETURN l_return;
2251:
2252: hr_utility.set_location(' Step:'|| l_proc, 20);
2253:
2254: END get_person_fullname;
2255:
2256: FUNCTION get_learner_name(p_person_id IN per_all_people_f.person_id%TYPE,

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

2287:
2288: l_proc VARCHAR2(72) := g_package|| 'get_learner_name';
2289: l_return VARCHAR2(500);
2290: BEGIN
2291: hr_utility.set_location(' Step:'|| l_proc, 10);
2292:
2293: IF (p_person_id is not null) THEN
2294: -- Internal Enrollment, Get Learner Name from per_all_people_f
2295: OPEN c_person_name;

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

2312: END IF;
2313:
2314: return l_return;
2315:
2316: hr_utility.set_location(' Step:'|| l_proc, 20);
2317:
2318: EXCEPTION
2319: WHEN others THEN
2320: hr_utility.set_location('Leaving :'||l_proc,15);

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

2316: hr_utility.set_location(' Step:'|| l_proc, 20);
2317:
2318: EXCEPTION
2319: WHEN others THEN
2320: hr_utility.set_location('Leaving :'||l_proc,15);
2321: RETURN NULL;
2322: END get_learner_name;
2323:
2324: FUNCTION get_customer_id(p_contact_id IN ota_lp_enrollments.contact_id%TYPE)

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

2346: l_proc VARCHAR2(72) := g_package|| 'get_customer_id';
2347: l_return ota_delegate_bookings.customer_id%TYPE;
2348:
2349: Begin
2350: hr_utility.set_location(' Step:'|| l_proc, 10);
2351:
2352: OPEN c_customer_id;
2353: FETCH c_customer_id INTO l_return;
2354: CLOSE c_customer_id;

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

2353: FETCH c_customer_id INTO l_return;
2354: CLOSE c_customer_id;
2355:
2356: return l_return;
2357: hr_utility.set_location(' Step:'|| l_proc, 20);
2358: End get_customer_id;
2359:
2360: FUNCTION get_cust_org_name(p_organization_id IN ota_delegate_bookings.organization_id%TYPE,
2361: p_customer_id IN ota_delegate_bookings.customer_id%TYPE,

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

2376:
2377: l_proc VARCHAR2(72) := g_package|| 'get_cust_org_name';
2378: l_return VARCHAR2(500);
2379: BEGIN
2380: hr_utility.set_location(' Step:'|| l_proc, 10);
2381:
2382: IF (p_organization_id is not null) THEN
2383: -- Internal Enrollment, Get org_name from hr_all_organization_units
2384: OPEN c_organization_name;

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

2399: END IF;
2400:
2401: return l_return;
2402:
2403: hr_utility.set_location(' Step:'|| l_proc, 20);
2404:
2405: EXCEPTION
2406: WHEN others THEN
2407: hr_utility.set_location('Leaving :'||l_proc,15);

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

2403: hr_utility.set_location(' Step:'|| l_proc, 20);
2404:
2405: EXCEPTION
2406: WHEN others THEN
2407: hr_utility.set_location('Leaving :'||l_proc,15);
2408: RETURN NULL;
2409: END get_cust_org_name;
2410:
2411:

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

2440: p_path := full_path;
2441:
2442: EXCEPTION
2443: WHEN others THEN
2444: hr_utility.set_location('Leaving :'||l_proc,15);
2445: p_path := null;
2446: End get_catalog_object_path ;
2447:
2448:

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

2513: p_path := full_path;
2514:
2515: EXCEPTION
2516: WHEN others THEN
2517: hr_utility.set_location('Leaving :'||l_proc,15);
2518: p_path := null;
2519: End get_content_object_path ;
2520:
2521: -- ----------------------------------------------------------------

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

2543: l_return VARCHAR2(1):= 'F';
2544: l_proc VARCHAR2(72) := g_package||'check_function_access';
2545:
2546: BEGIN
2547: hr_utility.set_location('Entering :'||l_proc,5);
2548:
2549: IF fnd_function.test_instance(function_name => p_function_name) THEN
2550: l_return := 'T';
2551: ELSE

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

2552: l_return := 'F';
2553: END IF;
2554: RETURN l_return;
2555:
2556: hr_utility.set_location('Leaving :'||l_proc,10);
2557: EXCEPTION
2558: WHEN others THEN
2559: l_return := 'F';
2560: RETURN l_return;

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

2702: l_proc VARCHAR2(72) := g_package|| 'get_ext_lrnr_party_id';
2703: l_return number;
2704:
2705: Begin
2706: hr_utility.set_location(' Step:'|| l_proc, 10);
2707:
2708: OPEN get_ext_lrn_party_id;
2709: FETCH get_ext_lrn_party_id INTO l_return;
2710: CLOSE get_ext_lrn_party_id;

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

2709: FETCH get_ext_lrn_party_id INTO l_return;
2710: CLOSE get_ext_lrn_party_id;
2711:
2712: return l_return;
2713: hr_utility.set_location(' Step:'|| l_proc, 20);
2714: End get_ext_lrnr_party_id;
2715:
2716: FUNCTION is_class_enrollable(
2717: p_class_id ota_events.event_id%TYPE)