[Home] [Help]
78: --
79: -- Other variables
80: l_proc varchar2(72) := g_package ||'create_library_objective';
81: Begin
82: hr_utility.set_location(' Entering:' || l_proc,10);
83: --
84: -- Issue a savepoint
85: --
86: savepoint create_library_objective_swi;
206: --
207: -- Derive the API return status value based on whether
208: -- messages of any type exist in the Multiple Message List.
209: -- Also disable Multiple Message Detection.
210: hr_utility.set_location(' Leaving:' || l_proc,20);
211: --
212: exception
213: when hr_multi_message.error_message_exist then
214: --
222: --
223: -- p_objective_id := null;
224: p_object_version_number := null;
225: p_return_status := hr_multi_message.get_return_status_disable;
226: hr_utility.set_location(' Leaving:' || l_proc, 30);
227: when others then
228: --
229: -- When Multiple Message Detection is enabled catch
230: -- any Application specific or other unexpected
234: --
235: rollback to create_library_objective_swi;
236: p_return_status := hr_multi_message.get_return_status_disable;
237: if p_return_status<>'E' and hr_multi_message.unexpected_error_add(l_proc) then
238: hr_utility.set_location(' Leaving:' || l_proc,40);
239: raise;
240: end if;
241: --
242: -- Reset IN OUT and set OUT parameters
242: -- Reset IN OUT and set OUT parameters
243: --
244: -- p_objective_id := null;
245: p_object_version_number := null;
246: hr_utility.set_location(' Leaving:' || l_proc,50);
247: end create_library_objective;
248: -- ----------------------------------------------------------------------------
249: -- |-----------------------< delete_library_objective >-----------------------|
250: -- ----------------------------------------------------------------------------
262: --
263: -- Other variables
264: l_proc varchar2(72) := g_package ||'delete_library_objective';
265: Begin
266: hr_utility.set_location(' Entering:' || l_proc,10);
267: --
268: -- Issue a savepoint
269: --
270: savepoint delete_library_objective_swi;
304: -- messages of any type exist in the Multiple Message List.
305: -- Also disable Multiple Message Detection.
306: --
307: p_return_status := hr_multi_message.get_return_status_disable;
308: hr_utility.set_location(' Leaving:' || l_proc,20);
309: --
310: exception
311: when hr_multi_message.error_message_exist then
312: --
318: --
319: -- Reset IN OUT parameters and set OUT parameters
320: --
321: p_return_status := hr_multi_message.get_return_status_disable;
322: hr_utility.set_location(' Leaving:' || l_proc, 30);
323: when others then
324: --
325: -- When Multiple Message Detection is enabled catch
326: -- any Application specific or other unexpected
329: -- error.
330: --
331: rollback to delete_library_objective_swi;
332: if hr_multi_message.unexpected_error_add(l_proc) then
333: hr_utility.set_location(' Leaving:' || l_proc,40);
334: raise;
335: end if;
336: --
337: -- Reset IN OUT and set OUT parameters
336: --
337: -- Reset IN OUT and set OUT parameters
338: --
339: p_return_status := hr_multi_message.get_return_status_disable;
340: hr_utility.set_location(' Leaving:' || l_proc,50);
341: end delete_library_objective;
342: -- ----------------------------------------------------------------------------
343: -- |-----------------------< update_library_objective >-----------------------|
344: -- ----------------------------------------------------------------------------
411: --
412: -- Other variables
413: l_proc varchar2(72) := g_package ||'update_library_objective';
414: Begin
415: hr_utility.set_location(' Entering:' || l_proc,10);
416: --
417: -- Issue a savepoint
418: --
419: savepoint update_library_objective_swi;
532: -- messages of any type exist in the Multiple Message List.
533: -- Also disable Multiple Message Detection.
534: --
535: hr_multi_message.disable_message_list;
536: hr_utility.set_location(' Leaving:' || l_proc,20);
537: --
538: exception
539: when hr_multi_message.error_message_exist then
540: --
547: -- Reset IN OUT parameters and set OUT parameters
548: --
549: p_object_version_number := l_object_version_number;
550: p_return_status := hr_multi_message.get_return_status_disable;
551: hr_utility.set_location(' Leaving:' || l_proc, 30);
552: when others then
553: --
554: -- When Multiple Message Detection is enabled catch
555: -- any Application specific or other unexpected
559: --
560: rollback to update_library_objective_swi;
561: p_return_status := hr_multi_message.get_return_status_disable;
562: if p_return_status<>'E' and hr_multi_message.unexpected_error_add(l_proc) then
563: hr_utility.set_location(' Leaving:' || l_proc,40);
564: raise;
565: end if;
566: --
567: -- Reset IN OUT and set OUT parameters
567: -- Reset IN OUT and set OUT parameters
568: --
569: p_object_version_number := l_object_version_number;
570:
571: hr_utility.set_location(' Leaving:' || l_proc,50);
572: end update_library_objective;
573: --
574: -- ----------------------------------------------------------------------------
575: -- |-------------------------< create_eligy_profile >-------------------------|
633: l_proc varchar2(72) := g_package ||'create_eligy_profile';
634: l_eligy_prfl_id number;
635: msgName varchar2(100);
636: begin
637: hr_utility.set_location(' Entering:' || l_proc,10);
638: --
639: -- Issue a savepoint
640: --
641: savepoint create_eligy_profile_swi;
679: );
680:
681: p_eligy_prfl_id := l_eligy_prfl_id;
682: p_return_status := hr_multi_message.get_return_status_disable;
683: hr_utility.set_location(' Leaving:' || l_proc,20);
684:
685: exception
686: when hr_multi_message.error_message_exist then
687:
716: );
717: end if;
718:
719: if hr_multi_message.unexpected_error_add(l_proc) then
720: hr_utility.set_location(' Leaving:' || l_proc,40);
721: raise;
722: end if;
723:
724: p_effective_start_date := null;
724: p_effective_start_date := null;
725: p_effective_end_date := null;
726: p_object_version_number := null;
727: p_return_status := hr_multi_message.get_return_status_disable;
728: hr_utility.set_location(' Leaving:' || l_proc, 30);
729: end create_eligy_profile;
730: --
731: --
732: -- ----------------------------------------------------------------------------
781: -- Other variables
782: l_proc varchar2(72) := g_package ||'update_eligy_position';
783:
784: begin
785: hr_utility.set_location(' Entering:' || l_proc,10);
786: --
787: -- Issue a savepoint
788: --
789: savepoint update_eligy_profile_swi;
818: ,p_effective_date => p_effective_date
819: );
820:
821: p_return_status := hr_multi_message.get_return_status_disable;
822: hr_utility.set_location(' Leaving:' || l_proc,20);
823: --
824: exception
825: when hr_multi_message.error_message_exist then
826: --
853: );
854: end if;
855:
856: if hr_multi_message.unexpected_error_add(l_proc) then
857: hr_utility.set_location(' Leaving:' || l_proc,40);
858: raise;
859: end if;
860:
861: p_effective_start_date := null;
861: p_effective_start_date := null;
862: p_effective_end_date := null;
863: p_object_version_number := null;
864: p_return_status := hr_multi_message.get_return_status_disable;
865: hr_utility.set_location(' Leaving:' || l_proc, 30);
866:
867: end update_eligy_profile;
868: -- ----------------------------------------------------------------------------
869: -- |--------------------------< create_eligy_object >-------------------------|
912: -- Other variables
913: l_proc varchar2(72) := g_package ||'create_eligy_obj';
914:
915: begin
916: hr_utility.set_location(' Entering:' || l_proc,10);
917: --
918: -- Issue a savepoint
919: --
920: savepoint create_eligy_object_swi;
968: p_effective_start_date := null;
969: p_effective_end_date := null;
970: p_object_version_number := null;
971:
972: hr_utility.set_location(' Leaving:' || l_proc, 30);
973:
974: end create_eligy_object;
975: --
976: -- ----------------------------------------------------------------------------
1021: -- Other variables
1022: l_proc varchar2(72) := g_package ||'update_eligy_object';
1023:
1024: begin
1025: hr_utility.set_location(' Entering:' || l_proc,10);
1026: --
1027: -- Issue a savepoint
1028: --
1029: savepoint update_eligy_object_swi;
1058: ,p_object_version_number => p_object_version_number
1059: ,p_effective_date => p_effective_date
1060: ,p_datetrack_mode => p_datetrack_mode
1061: );
1062: hr_utility.set_location(' Leaving:' || l_proc,20);
1063: --
1064:
1065: exception
1066: when hr_multi_message.error_message_exist then
1076: p_effective_start_date := null;
1077: p_effective_end_date := null;
1078: p_object_version_number := null;
1079:
1080: hr_utility.set_location(' Leaving:' || l_proc, 30);
1081:
1082: end update_eligy_object;
1083: --
1084: -- ----------------------------------------------------------------------------
1125: -- Other variables
1126: l_proc varchar2(72) := g_package ||'delete_eligy_object';
1127:
1128: begin
1129: hr_utility.set_location(' Entering:' || l_proc,10);
1130: --
1131: -- Issue a savepoint
1132: --
1133: savepoint delete_eligy_object_swi;
1158: ,p_object_version_number => p_object_version_number
1159: ,p_effective_date => p_effective_date
1160: ,p_datetrack_mode => p_datetrack_mode
1161: );
1162: hr_utility.set_location(' Leaving:' || l_proc,20);
1163: --
1164: exception
1165: when hr_multi_message.error_message_exist then
1166: --
1175: p_effective_start_date := null;
1176: p_effective_end_date := null;
1177: p_object_version_number := null;
1178:
1179: hr_utility.set_location(' Leaving:' || l_proc, 30);
1180:
1181: end delete_eligy_object;
1182: --
1183: --
1227: -- Other variables
1228: l_proc varchar2(72) := g_package ||'create_elig_obj_elig_prfl';
1229:
1230: begin
1231: hr_utility.set_location(' Entering:' || l_proc,10);
1232: --
1233: -- Issue a savepoint
1234: --
1235: savepoint create_elig_obj_elig_prfl_swi;
1266: ,p_object_version_number => p_object_version_number
1267: ,p_effective_date => p_effective_date
1268: );
1269:
1270: hr_utility.set_location(' Leaving:' || l_proc,20);
1271: --
1272:
1273: exception
1274: when hr_multi_message.error_message_exist then
1285: p_effective_start_date := null;
1286: p_effective_end_date := null;
1287: p_object_version_number := null;
1288:
1289: hr_utility.set_location(' Leaving:' || l_proc, 30);
1290:
1291:
1292: end create_elig_obj_elig_prfl;
1293: --
1337: -- Other variables
1338: l_proc varchar2(72) := g_package ||'update_elig_obj_elig_prfl';
1339:
1340: begin
1341: hr_utility.set_location(' Entering:' || l_proc,10);
1342: --
1343: -- Issue a savepoint
1344: --
1345: savepoint update_elig_obj_elig_prfl_swi;
1372: ,p_object_version_number => p_object_version_number
1373: ,p_effective_date => p_effective_date
1374: ,p_datetrack_mode => p_datetrack_mode
1375: );
1376: hr_utility.set_location(' Leaving:' || l_proc,20);
1377: --
1378:
1379: exception
1380: when hr_multi_message.error_message_exist then
1390: p_effective_start_date := null;
1391: p_effective_end_date := null;
1392: p_object_version_number := null;
1393:
1394: hr_utility.set_location(' Leaving:' || l_proc, 30);
1395:
1396: end update_elig_obj_elig_prfl;
1397: --
1398: --
1440: -- Other variables
1441: l_proc varchar2(72) := g_package ||'delete_elig_obj_elig_prfl';
1442:
1443: begin
1444: hr_utility.set_location(' Entering:' || l_proc,10);
1445: --
1446: -- Issue a savepoint
1447: --
1448: savepoint delete_elig_obj_elig_prfl_swi;
1473: ,p_object_version_number => p_object_version_number
1474: ,p_effective_date => p_effective_date
1475: ,p_datetrack_mode => p_datetrack_mode
1476: );
1477: hr_utility.set_location(' Leaving:' || l_proc,20);
1478: --
1479:
1480: exception
1481: when hr_multi_message.error_message_exist then
1491: p_effective_start_date := null;
1492: p_effective_end_date := null;
1493: p_object_version_number := null;
1494:
1495: hr_utility.set_location(' Leaving:' || l_proc, 30);
1496:
1497: end delete_elig_obj_elig_prfl;
1498: --
1499: --
1546: -- Other variables
1547: l_proc varchar2(72) := g_package ||'create_eligy_grade';
1548:
1549: begin
1550: hr_utility.set_location(' Entering:' || l_proc,10);
1551: --
1552: -- Issue a savepoint
1553: --
1554: savepoint create_eligy_grade_swi;
1586: ,p_object_version_number => p_object_version_number
1587: ,p_effective_date => p_effective_date
1588: );
1589:
1590: hr_utility.set_location(' Leaving:' || l_proc,20);
1591: --
1592:
1593: exception
1594: when hr_multi_message.error_message_exist then
1605: p_effective_start_date := null;
1606: p_effective_end_date := null;
1607: p_object_version_number := null;
1608:
1609: hr_utility.set_location(' Leaving:' || l_proc, 30);
1610:
1611: end create_eligy_grade;
1612: --
1613: -- ----------------------------------------------------------------------------
1658: -- Other variables
1659: l_proc varchar2(72) := g_package ||'update_eligy_grade';
1660:
1661: begin
1662: hr_utility.set_location(' Entering:' || l_proc,10);
1663: --
1664: -- Issue a savepoint
1665: --
1666: savepoint update_eligy_grade_swi;
1695: ,p_effective_date => p_effective_date
1696: ,p_datetrack_mode => p_datetrack_mode
1697: );
1698:
1699: hr_utility.set_location(' Leaving:' || l_proc,20);
1700: --
1701: exception
1702: when hr_multi_message.error_message_exist then
1703: --
1712: p_effective_start_date := null;
1713: p_effective_end_date := null;
1714: p_object_version_number := null;
1715:
1716: hr_utility.set_location(' Leaving:' || l_proc, 30);
1717:
1718: end update_eligy_grade;
1719: --
1720: -- ----------------------------------------------------------------------------
1762: -- Other variables
1763: l_proc varchar2(72) := g_package ||'delete_eligy_grade';
1764:
1765: begin
1766: hr_utility.set_location(' Entering:' || l_proc,10);
1767: --
1768: -- Issue a savepoint
1769: --
1770: savepoint delete_eligy_grade_swi;
1796: ,p_effective_date => p_effective_date
1797: ,p_datetrack_mode => p_datetrack_mode
1798: );
1799:
1800: hr_utility.set_location(' Leaving:' || l_proc,20);
1801: --
1802: exception
1803: when hr_multi_message.error_message_exist then
1804: --
1813: p_effective_start_date := null;
1814: p_effective_end_date := null;
1815: p_object_version_number := null;
1816:
1817: hr_utility.set_location(' Leaving:' || l_proc, 30);
1818:
1819: end delete_eligy_grade;
1820: --
1821: --
1867: --
1868: -- Other variables
1869: l_proc varchar2(72) := g_package ||'create_eligy_org';
1870: begin
1871: hr_utility.set_location(' Entering:' || l_proc,10);
1872: --
1873: -- Issue a savepoint
1874: --
1875: savepoint create_eligy_org_swi;
1905: ,p_object_version_number => p_object_version_number
1906: ,p_effective_date => p_effective_date
1907: );
1908:
1909: hr_utility.set_location(' Leaving:' || l_proc,20);
1910: --
1911:
1912: exception
1913: when hr_multi_message.error_message_exist then
1925: p_effective_start_date := null;
1926: p_effective_end_date := null;
1927: p_object_version_number := null;
1928:
1929: hr_utility.set_location(' Leaving:' || l_proc, 30);
1930:
1931: end create_eligy_org;
1932: --
1933: -- ----------------------------------------------------------------------------
1978: -- Other variables
1979: l_proc varchar2(72) := g_package ||'update_eligy_org';
1980:
1981: begin
1982: hr_utility.set_location(' Entering:' || l_proc,10);
1983: --
1984: -- Issue a savepoint
1985: --
1986: savepoint update_eligy_org_swi;
2015: ,p_effective_date => p_effective_date
2016: ,p_datetrack_mode => p_datetrack_mode
2017: );
2018:
2019: hr_utility.set_location(' Leaving:' || l_proc,20);
2020: --
2021: exception
2022: when hr_multi_message.error_message_exist then
2023: --
2032: p_effective_start_date := null;
2033: p_effective_end_date := null;
2034: p_object_version_number := null;
2035:
2036: hr_utility.set_location(' Leaving:' || l_proc, 30);
2037:
2038: end update_eligy_org;
2039: --
2040: -- ----------------------------------------------------------------------------
2082: -- Other variables
2083: l_proc varchar2(72) := g_package ||'delete_eligy_org';
2084:
2085: begin
2086: hr_utility.set_location(' Entering:' || l_proc,10);
2087: --
2088: -- Issue a savepoint
2089: --
2090: savepoint delete_eligy_org_swi;
2116: ,p_effective_date => p_effective_date
2117: ,p_datetrack_mode => p_datetrack_mode
2118: );
2119:
2120: hr_utility.set_location(' Leaving:' || l_proc,20);
2121: --
2122: exception
2123: when hr_multi_message.error_message_exist then
2124: --
2133: p_effective_start_date := null;
2134: p_effective_end_date := null;
2135: p_object_version_number := null;
2136:
2137: hr_utility.set_location(' Leaving:' || l_proc, 30);
2138:
2139: end delete_eligy_org;
2140: --
2141: --
2187: --
2188: -- Other variables
2189: l_proc varchar2(72) := g_package ||'create_eligy_job';
2190: begin
2191: hr_utility.set_location(' Entering:' || l_proc,10);
2192: --
2193: -- Issue a savepoint
2194: --
2195: savepoint create_eligy_job_swi;
2225: ,p_object_version_number => p_object_version_number
2226: ,p_effective_date => p_effective_date
2227: );
2228:
2229: hr_utility.set_location(' Leaving:' || l_proc,20);
2230: --
2231:
2232: exception
2233: when hr_multi_message.error_message_exist then
2245: p_effective_start_date := null;
2246: p_effective_end_date := null;
2247: p_object_version_number := null;
2248:
2249: hr_utility.set_location(' Leaving:' || l_proc, 30);
2250:
2251: end create_eligy_job;
2252: --
2253: -- ----------------------------------------------------------------------------
2298: -- Other variables
2299: l_proc varchar2(72) := g_package ||'update_eligy_job';
2300:
2301: begin
2302: hr_utility.set_location(' Entering:' || l_proc,10);
2303: --
2304: -- Issue a savepoint
2305: --
2306: savepoint update_eligy_job_swi;
2335: ,p_effective_date => p_effective_date
2336: ,p_datetrack_mode => p_datetrack_mode
2337: );
2338:
2339: hr_utility.set_location(' Leaving:' || l_proc,20);
2340: --
2341: exception
2342: when hr_multi_message.error_message_exist then
2343: --
2352: p_effective_start_date := null;
2353: p_effective_end_date := null;
2354: p_object_version_number := null;
2355:
2356: hr_utility.set_location(' Leaving:' || l_proc, 30);
2357:
2358: end update_eligy_job;
2359: --
2360: -- ----------------------------------------------------------------------------
2402: -- Other variables
2403: l_proc varchar2(72) := g_package ||'delete_eligy_job';
2404:
2405: begin
2406: hr_utility.set_location(' Entering:' || l_proc,10);
2407: --
2408: -- Issue a savepoint
2409: --
2410: savepoint delete_eligy_job_swi;
2436: ,p_effective_date => p_effective_date
2437: ,p_datetrack_mode => p_datetrack_mode
2438: );
2439:
2440: hr_utility.set_location(' Leaving:' || l_proc,20);
2441: --
2442: exception
2443: when hr_multi_message.error_message_exist then
2444: --
2453: p_effective_start_date := null;
2454: p_effective_end_date := null;
2455: p_object_version_number := null;
2456:
2457: hr_utility.set_location(' Leaving:' || l_proc, 30);
2458:
2459: end delete_eligy_job;
2460: --
2461: --
2507: --
2508: -- Other variables
2509: l_proc varchar2(72) := g_package ||'create_eligy_position';
2510: begin
2511: hr_utility.set_location(' Entering:' || l_proc,10);
2512: --
2513: -- Issue a savepoint
2514: --
2515: savepoint create_eligy_position_swi;
2545: ,p_object_version_number => p_object_version_number
2546: ,p_effective_date => p_effective_date
2547: );
2548:
2549: hr_utility.set_location(' Leaving:' || l_proc,20);
2550: --
2551:
2552: exception
2553: when hr_multi_message.error_message_exist then
2565: p_effective_start_date := null;
2566: p_effective_end_date := null;
2567: p_object_version_number := null;
2568:
2569: hr_utility.set_location(' Leaving:' || l_proc, 30);
2570:
2571: end create_eligy_position;
2572: --
2573: -- ----------------------------------------------------------------------------
2618: -- Other variables
2619: l_proc varchar2(72) := g_package ||'update_eligy_position';
2620:
2621: begin
2622: hr_utility.set_location(' Entering:' || l_proc,10);
2623: --
2624: -- Issue a savepoint
2625: --
2626: savepoint update_eligy_position_swi;
2655: ,p_effective_date => p_effective_date
2656: ,p_datetrack_mode => p_datetrack_mode
2657: );
2658:
2659: hr_utility.set_location(' Leaving:' || l_proc,20);
2660: --
2661: exception
2662: when hr_multi_message.error_message_exist then
2663: --
2672: p_effective_start_date := null;
2673: p_effective_end_date := null;
2674: p_object_version_number := null;
2675:
2676: hr_utility.set_location(' Leaving:' || l_proc, 30);
2677:
2678: end update_eligy_position;
2679: --
2680: -- ----------------------------------------------------------------------------
2722: -- Other variables
2723: l_proc varchar2(72) := g_package ||'delete_eligy_position';
2724:
2725: begin
2726: hr_utility.set_location(' Entering:' || l_proc,10);
2727: --
2728: -- Issue a savepoint
2729: --
2730: savepoint delete_eligy_position_swi;
2756: ,p_effective_date => p_effective_date
2757: ,p_datetrack_mode => p_datetrack_mode
2758: );
2759:
2760: hr_utility.set_location(' Leaving:' || l_proc,20);
2761: --
2762: exception
2763: when hr_multi_message.error_message_exist then
2764: --
2773: p_effective_start_date := null;
2774: p_effective_end_date := null;
2775: p_object_version_number := null;
2776:
2777: hr_utility.set_location(' Leaving:' || l_proc, 30);
2778:
2779: end delete_eligy_position;
2780: --
2781: