444: -- ----------------------------------------------------------------------------
445: --
446: procedure create_ame_rule
447: (p_validate in boolean default false
448: ,p_language_code in varchar2 default hr_api.userenv_lang
449: ,p_rule_key in varchar2
450: ,p_description in varchar2
451: ,p_rule_type in varchar2
452: ,p_item_class_id in number default null
596: ,p_rul_start_date => p_rul_start_date
597: ,p_rul_end_date => p_rul_end_date
598: );
599: exception
600: when hr_api.cannot_find_prog_unit then
601: hr_api.cannot_find_prog_unit_error
602: (p_module_name => 'create_ame_rule'
603: ,p_hook_type => 'BP'
604: );
597: ,p_rul_end_date => p_rul_end_date
598: );
599: exception
600: when hr_api.cannot_find_prog_unit then
601: hr_api.cannot_find_prog_unit_error
602: (p_module_name => 'create_ame_rule'
603: ,p_hook_type => 'BP'
604: );
605: end;
782: ,p_acu_start_date => p_acu_start_date
783: ,p_acu_end_date => p_acu_end_date
784: );
785: exception
786: when hr_api.cannot_find_prog_unit then
787: hr_api.cannot_find_prog_unit_error
788: (p_module_name => 'create_ame_rule'
789: ,p_hook_type => 'AP'
790: );
783: ,p_acu_end_date => p_acu_end_date
784: );
785: exception
786: when hr_api.cannot_find_prog_unit then
787: hr_api.cannot_find_prog_unit_error
788: (p_module_name => 'create_ame_rule'
789: ,p_hook_type => 'AP'
790: );
791: end;
792: --
793: -- When in validation only mode raise the Validate_Enabled exception
794: --
795: if p_validate then
796: raise hr_api.validate_enabled;
797: end if;
798: --
799: -- Set all IN OUT and OUT parameters with out values
800: --
815: end if;
816: --
817: hr_utility.set_location(' Leaving:'||l_proc, 70);
818: exception
819: when hr_api.validate_enabled then
820: --
821: -- As the Validate_Enabled exception has been raised
822: -- we must rollback to the savepoint
823: --
1022: ,p_start_date => p_start_date
1023: ,p_end_date => p_end_date
1024: );
1025: exception
1026: when hr_api.cannot_find_prog_unit then
1027: hr_api.cannot_find_prog_unit_error
1028: (p_module_name => 'create_ame_rule_usage'
1029: ,p_hook_type => 'BP'
1030: );
1023: ,p_end_date => p_end_date
1024: );
1025: exception
1026: when hr_api.cannot_find_prog_unit then
1027: hr_api.cannot_find_prog_unit_error
1028: (p_module_name => 'create_ame_rule_usage'
1029: ,p_hook_type => 'BP'
1030: );
1031: end;
1290: l_acu_object_version_number := tempActions.object_version_number;
1291: l_acu_start_date := tempActions.start_date;
1292: l_acu_end_date := tempActions.end_date;
1293: ame_acu_upd.upd(p_rule_id => p_rule_id
1294: ,p_datetrack_mode => hr_api.g_update
1295: ,p_action_id => tempActions.action_id
1296: ,p_effective_date => l_effective_date
1297: ,p_object_version_number => l_acu_object_version_number
1298: ,p_start_date => l_rul_start_date
1304: l_cnu_object_version_number := tempConditions.object_version_number;
1305: l_cnu_start_date := tempConditions.start_date;
1306: l_cnu_end_date := tempConditions.end_date;
1307: ame_cnu_upd.upd(p_rule_id => p_rule_id
1308: ,p_datetrack_mode => hr_api.g_update
1309: ,p_condition_id => tempConditions.condition_id
1310: ,p_effective_date => l_effective_date
1311: ,p_object_version_number => l_cnu_object_version_number
1312: ,p_start_date => l_rul_start_date
1314: );
1315: end loop;
1316: -- rules
1317: ame_rul_upd.upd(p_rule_id => p_rule_id
1318: ,p_datetrack_mode => hr_api.g_update
1319: ,p_effective_date => l_effective_date
1320: ,p_object_version_number => l_rul_object_version_number
1321: ,p_start_date => l_rul_start_date
1322: ,p_end_date => l_rul_end_date
1356: ,p_start_date => l_rlu_start_date
1357: ,p_end_date => l_rlu_end_date
1358: );
1359: exception
1360: when hr_api.cannot_find_prog_unit then
1361: hr_api.cannot_find_prog_unit_error
1362: (p_module_name => 'create_ame_rule_usage'
1363: ,p_hook_type => 'AP'
1364: );
1357: ,p_end_date => l_rlu_end_date
1358: );
1359: exception
1360: when hr_api.cannot_find_prog_unit then
1361: hr_api.cannot_find_prog_unit_error
1362: (p_module_name => 'create_ame_rule_usage'
1363: ,p_hook_type => 'AP'
1364: );
1365: end;
1366: --
1367: -- When in validation only mode raise the Validate_Enabled exception
1368: --
1369: if p_validate then
1370: raise hr_api.validate_enabled;
1371: end if;
1372: --
1373: -- Set all IN OUT and OUT parameters with out values
1374: --
1377: p_end_date := l_rlu_end_date;
1378: --
1379: hr_utility.set_location(' Leaving:'||l_proc, 70);
1380: exception
1381: when hr_api.validate_enabled then
1382: --
1383: -- As the Validate_Enabled exception has been raised
1384: -- we must rollback to the savepoint
1385: --
1519: (p_rule_id => p_rule_id
1520: ,p_condition_id => p_condition_id
1521: );
1522: exception
1523: when hr_api.cannot_find_prog_unit then
1524: hr_api.cannot_find_prog_unit_error
1525: (p_module_name => 'create_ame_condition_to_rule'
1526: ,p_hook_type => 'BP'
1527: );
1520: ,p_condition_id => p_condition_id
1521: );
1522: exception
1523: when hr_api.cannot_find_prog_unit then
1524: hr_api.cannot_find_prog_unit_error
1525: (p_module_name => 'create_ame_condition_to_rule'
1526: ,p_hook_type => 'BP'
1527: );
1528: end;
1748: ,p_start_date => l_cnu_start_date
1749: ,p_end_date => l_cnu_end_date
1750: );
1751: exception
1752: when hr_api.cannot_find_prog_unit then
1753: hr_api.cannot_find_prog_unit_error
1754: (p_module_name => 'create_ame_condition_to_rule'
1755: ,p_hook_type => 'AP'
1756: );
1749: ,p_end_date => l_cnu_end_date
1750: );
1751: exception
1752: when hr_api.cannot_find_prog_unit then
1753: hr_api.cannot_find_prog_unit_error
1754: (p_module_name => 'create_ame_condition_to_rule'
1755: ,p_hook_type => 'AP'
1756: );
1757: end;
1758: --
1759: -- When in validation only mode raise the Validate_Enabled exception
1760: --
1761: if p_validate then
1762: raise hr_api.validate_enabled;
1763: end if;
1764: --
1765: -- Set all IN OUT and OUT parameters with out values
1766: --
1769: p_end_date := l_cnu_end_date;
1770: --
1771: hr_utility.set_location(' Leaving:'||l_proc, 70);
1772: exception
1773: when hr_api.validate_enabled then
1774: --
1775: -- As the Validate_Enabled exception has been raised
1776: -- we must rollback to the savepoint
1777: --
1944: (p_rule_id => p_rule_id
1945: ,p_action_id => p_action_id
1946: );
1947: exception
1948: when hr_api.cannot_find_prog_unit then
1949: hr_api.cannot_find_prog_unit_error
1950: (p_module_name => 'create_ame_action_to_rule'
1951: ,p_hook_type => 'BP'
1952: );
1945: ,p_action_id => p_action_id
1946: );
1947: exception
1948: when hr_api.cannot_find_prog_unit then
1949: hr_api.cannot_find_prog_unit_error
1950: (p_module_name => 'create_ame_action_to_rule'
1951: ,p_hook_type => 'BP'
1952: );
1953: end;
2140: ,p_start_date => l_acu_start_date
2141: ,p_end_date => l_acu_end_date
2142: );
2143: exception
2144: when hr_api.cannot_find_prog_unit then
2145: hr_api.cannot_find_prog_unit_error
2146: (p_module_name => 'create_ame_action_to_rule'
2147: ,p_hook_type => 'AP'
2148: );
2141: ,p_end_date => l_acu_end_date
2142: );
2143: exception
2144: when hr_api.cannot_find_prog_unit then
2145: hr_api.cannot_find_prog_unit_error
2146: (p_module_name => 'create_ame_action_to_rule'
2147: ,p_hook_type => 'AP'
2148: );
2149: end;
2150: --
2151: -- When in validation only mode raise the Validate_Enabled exception
2152: --
2153: if p_validate then
2154: raise hr_api.validate_enabled;
2155: end if;
2156: --
2157: -- Set all IN OUT and OUT parameters with out values
2158: --
2161: p_end_date := l_acu_end_date;
2162: --
2163: hr_utility.set_location(' Leaving:'||l_proc, 70);
2164: exception
2165: when hr_api.validate_enabled then
2166: --
2167: -- As the Validate_Enabled exception has been raised
2168: -- we must rollback to the savepoint
2169: --
2200: -- ----------------------------------------------------------------------------
2201: --
2202: procedure update_ame_rule
2203: (p_validate in boolean default false
2204: ,p_language_code in varchar2 default hr_api.userenv_lang
2205: ,p_rule_id in number
2206: ,p_description in varchar2 default hr_api.g_varchar2
2207: ,p_object_version_number in out nocopy number
2208: ,p_start_date in out nocopy date
2202: procedure update_ame_rule
2203: (p_validate in boolean default false
2204: ,p_language_code in varchar2 default hr_api.userenv_lang
2205: ,p_rule_id in number
2206: ,p_description in varchar2 default hr_api.g_varchar2
2207: ,p_object_version_number in out nocopy number
2208: ,p_start_date in out nocopy date
2209: ,p_end_date in out nocopy date
2210: ,p_effective_date in date default null
2236: ,p_start_date => p_start_date
2237: ,p_end_date => p_end_date
2238: );
2239: exception
2240: when hr_api.cannot_find_prog_unit then
2241: hr_api.cannot_find_prog_unit_error
2242: (p_module_name => 'update_ame_rule'
2243: ,p_hook_type => 'BP'
2244: );
2237: ,p_end_date => p_end_date
2238: );
2239: exception
2240: when hr_api.cannot_find_prog_unit then
2241: hr_api.cannot_find_prog_unit_error
2242: (p_module_name => 'update_ame_rule'
2243: ,p_hook_type => 'BP'
2244: );
2245: end;
2265: if (instrb(DBMS_UTILITY.FORMAT_CALL_STACK,l_swi_package_name||fnd_global.local_chr(ascii_chr => 10)) = 0) then
2266: l_swi_call := false;
2267: -- If Description is null and call is not made from SWI layer, then raise an exception.
2268: if(p_description is null or
2269: p_description = hr_api.g_varchar2) then
2270: fnd_message.set_name('PER','AME_400731_NO_DESCRIPTION');
2271: hr_multi_message.add(p_associated_column1 => 'DESCRIPTION');
2272: end if;
2273: l_rul_start_date := null;
2279: if l_swi_call and p_effective_date is not null then
2280: l_effective_date := p_effective_date;
2281: end if;
2282: ame_rul_upd.upd(p_effective_date => l_effective_date
2283: ,p_datetrack_mode => hr_api.g_update
2284: ,p_rule_id => p_rule_id
2285: ,p_object_version_number => l_rul_object_version_number
2286: ,p_description => p_description
2287: ,p_start_date => l_rul_start_date
2289: );
2290:
2291: -- update data into TL tables
2292: if(p_description is not null or
2293: p_description <> hr_api.g_varchar2) then
2294: ame_rtl_upd.upd_tl(p_language_code => p_language_code
2295: ,p_rule_id => p_rule_id
2296: ,p_description => p_description
2297: );
2307: ,p_start_date => l_rul_start_date
2308: ,p_end_date => l_rul_end_date
2309: );
2310: exception
2311: when hr_api.cannot_find_prog_unit then
2312: hr_api.cannot_find_prog_unit_error
2313: (p_module_name => 'update_ame_rule'
2314: ,p_hook_type => 'AP'
2315: );
2308: ,p_end_date => l_rul_end_date
2309: );
2310: exception
2311: when hr_api.cannot_find_prog_unit then
2312: hr_api.cannot_find_prog_unit_error
2313: (p_module_name => 'update_ame_rule'
2314: ,p_hook_type => 'AP'
2315: );
2316: end;
2317: --
2318: -- When in validation only mode raise the Validate_Enabled exception
2319: --
2320: if p_validate then
2321: raise hr_api.validate_enabled;
2322: end if;
2323: --
2324: -- Set all IN OUT and OUT parameters with out values
2325: --
2335: hr_utility.set_location(' Leaving:'|| l_proc, 50);
2336: raise;
2337: end if;
2338: hr_utility.set_location(' Leaving:'|| l_proc, 60);
2339: when hr_api.validate_enabled then
2340: --
2341: -- As the Validate_Enabled exception has been raised
2342: -- we must rollback to the savepoint
2343: --
2373: procedure update_ame_rule_usage
2374: (p_validate in boolean default false
2375: ,p_rule_id in number
2376: ,p_application_id in number
2377: ,p_priority in number default hr_api.g_number
2378: ,p_approver_category in varchar2 default hr_api.g_varchar2
2379: ,p_old_start_date in date
2380: ,p_object_version_number in out nocopy number
2381: ,p_start_date in out nocopy date
2374: (p_validate in boolean default false
2375: ,p_rule_id in number
2376: ,p_application_id in number
2377: ,p_priority in number default hr_api.g_number
2378: ,p_approver_category in varchar2 default hr_api.g_varchar2
2379: ,p_old_start_date in date
2380: ,p_object_version_number in out nocopy number
2381: ,p_start_date in out nocopy date
2382: ,p_end_date in out nocopy date
2472: ,p_start_date => p_start_date
2473: ,p_end_date => p_end_date
2474: );
2475: exception
2476: when hr_api.cannot_find_prog_unit then
2477: hr_api.cannot_find_prog_unit_error
2478: (p_module_name => 'update_ame_rule_usage'
2479: ,p_hook_type => 'BP'
2480: );
2473: ,p_end_date => p_end_date
2474: );
2475: exception
2476: when hr_api.cannot_find_prog_unit then
2477: hr_api.cannot_find_prog_unit_error
2478: (p_module_name => 'update_ame_rule_usage'
2479: ,p_hook_type => 'BP'
2480: );
2481: end;
2540: if l_swi_call and p_effective_date is not null then
2541: l_effective_date := p_effective_date;
2542: end if;
2543: ame_rlu_upd.upd(p_effective_date => l_effective_date
2544: ,p_datetrack_mode => hr_api.g_update
2545: ,p_rule_id => p_rule_id
2546: ,p_item_id => p_application_id
2547: ,p_old_start_date => p_old_start_date
2548: ,p_object_version_number=> l_rlu_object_version_number
2570: -- date has changed, update the dates for rules, condition usages and action usages
2571: --
2572: -- rules
2573: ame_rul_upd.upd(p_rule_id => p_rule_id
2574: ,p_datetrack_mode => hr_api.g_update
2575: ,p_effective_date => l_effective_date
2576: ,p_object_version_number => l_rul_object_version_number
2577: ,p_start_date => l_rul_start_date
2578: ,p_end_date => l_rul_end_date
2582: l_acu_object_version_number := tempActions.object_version_number;
2583: l_acu_start_date := tempActions.start_date;
2584: l_acu_end_date := tempActions.end_date;
2585: ame_acu_upd.upd(p_rule_id => p_rule_id
2586: ,p_datetrack_mode => hr_api.g_update
2587: ,p_action_id => tempActions.action_id
2588: ,p_effective_date => l_effective_date
2589: ,p_object_version_number => l_acu_object_version_number
2590: ,p_start_date => l_acu_start_date
2596: l_cnu_object_version_number := tempConditions.object_version_number;
2597: l_cnu_start_date := tempConditions.start_date;
2598: l_cnu_end_date := tempConditions.end_date;
2599: ame_cnu_upd.upd(p_rule_id => p_rule_id
2600: ,p_datetrack_mode => hr_api.g_update
2601: ,p_condition_id => tempConditions.condition_id
2602: ,p_effective_date => l_effective_date
2603: ,p_object_version_number => l_cnu_object_version_number
2604: ,p_start_date => l_cnu_start_date
2625: ,p_start_date => p_start_date
2626: ,p_end_date => p_end_date
2627: );
2628: exception
2629: when hr_api.cannot_find_prog_unit then
2630: hr_api.cannot_find_prog_unit_error
2631: (p_module_name => 'update_ame_rule_usage'
2632: ,p_hook_type => 'AP'
2633: );
2626: ,p_end_date => p_end_date
2627: );
2628: exception
2629: when hr_api.cannot_find_prog_unit then
2630: hr_api.cannot_find_prog_unit_error
2631: (p_module_name => 'update_ame_rule_usage'
2632: ,p_hook_type => 'AP'
2633: );
2634: end;
2635: --
2636: -- When in validation only mode raise the Validate_Enabled exception
2637: --
2638: if p_validate then
2639: raise hr_api.validate_enabled;
2640: end if;
2641: --
2642: -- Set all IN OUT and OUT parameters with out values
2643: --
2646: p_end_date := l_rlu_end_date;
2647: --
2648: hr_utility.set_location(' Leaving:'||l_proc, 70);
2649: exception
2650: when hr_api.validate_enabled then
2651: --
2652: -- As the Validate_Enabled exception has been raised
2653: -- we must rollback to the savepoint
2654: --
2803: ,p_start_date => p_start_date
2804: ,p_end_date => p_end_date
2805: );
2806: exception
2807: when hr_api.cannot_find_prog_unit then
2808: hr_api.cannot_find_prog_unit_error
2809: (p_module_name => 'delete_ame_rule_usage'
2810: ,p_hook_type => 'BP'
2811: );
2804: ,p_end_date => p_end_date
2805: );
2806: exception
2807: when hr_api.cannot_find_prog_unit then
2808: hr_api.cannot_find_prog_unit_error
2809: (p_module_name => 'delete_ame_rule_usage'
2810: ,p_hook_type => 'BP'
2811: );
2812: end;
2828: l_rlu_end_date := p_end_date;
2829: -- delete the row in ame_rule_usages
2830: --
2831: ame_rlu_del.del(p_effective_date => l_effective_date
2832: ,p_datetrack_mode => hr_api.g_delete
2833: ,p_rule_id => p_rule_id
2834: ,p_item_id => p_application_id
2835: ,p_object_version_number => l_rlu_object_version_number
2836: ,p_start_date => l_rlu_start_date
2886: l_acu_object_version_number := tempActions.object_version_number;
2887: l_acu_start_date := tempActions.start_date;
2888: l_acu_end_date := tempActions.end_date;
2889: ame_acu_del.del(p_effective_date => l_effective_date
2890: ,p_datetrack_mode => hr_api.g_delete
2891: ,p_rule_id => p_rule_id
2892: ,p_action_id => tempActions.action_id
2893: ,p_object_version_number => l_acu_object_version_number
2894: ,p_start_date => l_acu_start_date
2900: l_cnu_object_version_number := tempConditions.object_version_number;
2901: l_cnu_start_date := tempConditions.start_date;
2902: l_cnu_end_date := tempConditions.end_date;
2903: ame_cnu_del.del(p_effective_date => l_effective_date
2904: ,p_datetrack_mode => hr_api.g_delete
2905: ,p_rule_id => p_rule_id
2906: ,p_condition_id => tempConditions.condition_id
2907: ,p_object_version_number => l_cnu_object_version_number
2908: ,p_start_date => l_cnu_start_date
2910: );
2911: end loop;
2912: -- rule
2913: ame_rul_del.del(p_effective_date => l_effective_date
2914: ,p_datetrack_mode => hr_api.g_delete
2915: ,p_rule_id => p_rule_id
2916: ,p_object_version_number => l_rul_object_version_number
2917: ,p_start_date => l_rul_start_date
2918: ,p_end_date => l_rul_end_date
2935: ,p_start_date => l_rlu_start_date
2936: ,p_end_date => l_rlu_end_date
2937: );
2938: exception
2939: when hr_api.cannot_find_prog_unit then
2940: hr_api.cannot_find_prog_unit_error
2941: (p_module_name => 'delete_ame_rule_usage'
2942: ,p_hook_type => 'AP'
2943: );
2936: ,p_end_date => l_rlu_end_date
2937: );
2938: exception
2939: when hr_api.cannot_find_prog_unit then
2940: hr_api.cannot_find_prog_unit_error
2941: (p_module_name => 'delete_ame_rule_usage'
2942: ,p_hook_type => 'AP'
2943: );
2944: end;
2945: --
2946: -- When in validation only mode raise the Validate_Enabled exception
2947: --
2948: if p_validate then
2949: raise hr_api.validate_enabled;
2950: end if;
2951: --
2952: -- Set all IN OUT and OUT parameters with out values
2953: --
2956: p_end_date := l_rlu_end_date;
2957: --
2958: hr_utility.set_location(' Leaving:'||l_proc, 70);
2959: exception
2960: when hr_api.validate_enabled then
2961: --
2962: -- As the Validate_Enabled exception has been raised
2963: -- we must rollback to the savepoint
2964: --
3113: ,p_condition_id => p_condition_id
3114: ,p_object_version_number => p_object_version_number
3115: );
3116: exception
3117: when hr_api.cannot_find_prog_unit then
3118: hr_api.cannot_find_prog_unit_error
3119: (p_module_name => 'delete_ame_rule_condition'
3120: ,p_hook_type => 'BP'
3121: );
3114: ,p_object_version_number => p_object_version_number
3115: );
3116: exception
3117: when hr_api.cannot_find_prog_unit then
3118: hr_api.cannot_find_prog_unit_error
3119: (p_module_name => 'delete_ame_rule_condition'
3120: ,p_hook_type => 'BP'
3121: );
3122: end;
3236: --
3237: -- delete the row in ame_condition_usages
3238: --
3239: ame_cnu_del.del(p_effective_date => l_effective_date
3240: ,p_datetrack_mode => hr_api.g_delete
3241: ,p_rule_id => p_rule_id
3242: ,p_condition_id => p_condition_id
3243: ,p_object_version_number => l_cnu_object_version_number
3244: ,p_start_date => l_cnu_start_date
3281: ,p_start_date => l_cnu_start_date
3282: ,p_end_date => l_cnu_end_date
3283: );
3284: exception
3285: when hr_api.cannot_find_prog_unit then
3286: hr_api.cannot_find_prog_unit_error
3287: (p_module_name => 'delete_ame_rule_condition'
3288: ,p_hook_type => 'AP'
3289: );
3282: ,p_end_date => l_cnu_end_date
3283: );
3284: exception
3285: when hr_api.cannot_find_prog_unit then
3286: hr_api.cannot_find_prog_unit_error
3287: (p_module_name => 'delete_ame_rule_condition'
3288: ,p_hook_type => 'AP'
3289: );
3290: end;
3291: --
3292: -- When in validation only mode raise the Validate_Enabled exception
3293: --
3294: if p_validate then
3295: raise hr_api.validate_enabled;
3296: end if;
3297: --
3298: -- Set all IN OUT and OUT parameters with out values
3299: --
3302: p_end_date := l_cnu_end_date;
3303: --
3304: hr_utility.set_location(' Leaving:'||l_proc, 70);
3305: exception
3306: when hr_api.validate_enabled then
3307: --
3308: -- As the Validate_Enabled exception has been raised
3309: -- we must rollback to the savepoint
3310: --
3448: ,p_action_id => p_action_id
3449: ,p_object_version_number => p_object_version_number
3450: );
3451: exception
3452: when hr_api.cannot_find_prog_unit then
3453: hr_api.cannot_find_prog_unit_error
3454: (p_module_name => 'delete_ame_rule_action '
3455: ,p_hook_type => 'BP'
3456: );
3449: ,p_object_version_number => p_object_version_number
3450: );
3451: exception
3452: when hr_api.cannot_find_prog_unit then
3453: hr_api.cannot_find_prog_unit_error
3454: (p_module_name => 'delete_ame_rule_action '
3455: ,p_hook_type => 'BP'
3456: );
3457: end;
3526: --+
3527: -- delete the row in ame_action_usages
3528: --+
3529: ame_acu_del.del(p_effective_date => l_effective_date
3530: ,p_datetrack_mode => hr_api.g_delete
3531: ,p_rule_id => p_rule_id
3532: ,p_action_id => p_action_id
3533: ,p_object_version_number => l_acu_object_version_number
3534: ,p_start_date => l_acu_start_date
3559: ,p_start_date => l_acu_start_date
3560: ,p_end_date => l_acu_end_date
3561: );
3562: exception
3563: when hr_api.cannot_find_prog_unit then
3564: hr_api.cannot_find_prog_unit_error
3565: (p_module_name => 'delete_ame_rule_action '
3566: ,p_hook_type => 'AP'
3567: );
3560: ,p_end_date => l_acu_end_date
3561: );
3562: exception
3563: when hr_api.cannot_find_prog_unit then
3564: hr_api.cannot_find_prog_unit_error
3565: (p_module_name => 'delete_ame_rule_action '
3566: ,p_hook_type => 'AP'
3567: );
3568: end;
3569: --+
3570: -- When in validation only mode raise the Validate_Enabled exception
3571: --+
3572: if p_validate then
3573: raise hr_api.validate_enabled;
3574: end if;
3575: --+
3576: -- Set all IN OUT and OUT parameters with out values
3577: --+
3580: p_end_date := l_acu_end_date;
3581: --+
3582: hr_utility.set_location(' Leaving:'||l_proc, 70);
3583: exception
3584: when hr_api.validate_enabled then
3585: --+
3586: -- As the Validate_Enabled exception has been raised
3587: -- we must rollback to the savepoint
3588: --+
3691: (p_rule_id => p_rule_id
3692: ,p_condition_id => p_condition_id
3693: );
3694: exception
3695: when hr_api.cannot_find_prog_unit then
3696: hr_api.cannot_find_prog_unit_error
3697: (p_module_name => 'replace_lm_condition'
3698: ,p_hook_type => 'BP'
3699: );
3692: ,p_condition_id => p_condition_id
3693: );
3694: exception
3695: when hr_api.cannot_find_prog_unit then
3696: hr_api.cannot_find_prog_unit_error
3697: (p_module_name => 'replace_lm_condition'
3698: ,p_hook_type => 'BP'
3699: );
3700: end;
3816: or
3817: (sysdate < start_date and start_date < nvl(end_date, start_date + (1/86400)))
3818: );
3819: ame_cnu_del.del(p_effective_date => l_effective_date
3820: ,p_datetrack_mode => hr_api.g_delete
3821: ,p_rule_id => p_rule_id
3822: ,p_condition_id => l_old_condition_id
3823: ,p_object_version_number => l_cnu_object_version_number
3824: ,p_start_date => l_cnu_start_date
3846: ,p_start_date => l_cnu_start_date
3847: ,p_end_date => l_cnu_end_date
3848: );
3849: exception
3850: when hr_api.cannot_find_prog_unit then
3851: hr_api.cannot_find_prog_unit_error
3852: (p_module_name => 'replace_lm_condition'
3853: ,p_hook_type => 'AP'
3854: );
3847: ,p_end_date => l_cnu_end_date
3848: );
3849: exception
3850: when hr_api.cannot_find_prog_unit then
3851: hr_api.cannot_find_prog_unit_error
3852: (p_module_name => 'replace_lm_condition'
3853: ,p_hook_type => 'AP'
3854: );
3855: end;
3856: --
3857: -- When in validation only mode raise the Validate_Enabled exception
3858: --
3859: if p_validate then
3860: raise hr_api.validate_enabled;
3861: end if;
3862: --
3863: -- Set all IN OUT and OUT parameters with out values
3864: --
3867: p_end_date := l_cnu_end_date;
3868: --
3869: hr_utility.set_location(' Leaving:'||l_proc, 70);
3870: exception
3871: when hr_api.validate_enabled then
3872: --
3873: -- As the Validate_Enabled exception has been raised
3874: -- we must rollback to the savepoint
3875: --