DBA Data[Home] [Help]

APPS.AME_RULE_API dependencies on HR_UTILITY

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

512: and l_effective_date between start_date
513: and nvl(end_date - ame_util.oneSecond,l_effective_date);
514:
515: begin
516: hr_utility.set_location('Entering:'|| l_proc, 10);
517: --
518: -- Issue a savepoint
519: --
520: savepoint create_ame_rule;

Line 817: hr_utility.set_location(' Leaving:'||l_proc, 70);

813: p_cnu_start_date := l_cnu_start_date;
814: p_cnu_end_date := l_cnu_end_date;
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

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

841: p_cnu_object_version_number := null;
842: p_cnu_start_date := null;
843: p_cnu_end_date := null;
844: end if;
845: hr_utility.set_location(' Leaving:'||l_proc, 80);
846: when others then
847: --
848: -- A validation or unexpected error has occured
849: --

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

866: p_cnu_object_version_number := null;
867: p_cnu_start_date := null;
868: p_cnu_end_date := null;
869: end if;
870: hr_utility.set_location(' Leaving:'||l_proc, 90);
871: raise;
872: end create_ame_rule;
873: --
874: -- ----------------------------------------------------------------------------

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

1004: priority varchar2(100);
1005: l_swi_call boolean;
1006: l_create_ame_rule_call boolean;
1007: begin
1008: hr_utility.set_location('Entering:'|| l_proc, 10);
1009: --
1010: -- Issue a savepoint
1011: --
1012: savepoint create_ame_rule_usage;

Line 1379: hr_utility.set_location(' Leaving:'||l_proc, 70);

1375: p_object_version_number := l_rlu_object_version_number;
1376: p_start_date := l_rlu_start_date;
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

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

1391: --
1392: p_object_version_number := null;
1393: p_start_date := null;
1394: p_end_date := null;
1395: hr_utility.set_location(' Leaving:'||l_proc, 80);
1396: when others then
1397: --
1398: -- A validation or unexpected error has occured
1399: --

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

1404: --
1405: p_object_version_number := null;
1406: p_start_date := null;
1407: p_end_date := null;
1408: hr_utility.set_location(' Leaving:'||l_proc, 90);
1409: raise;
1410: end create_ame_rule_usage;
1411: --
1412: -- ----------------------------------------------------------------------------

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

1505: attributeName ame_attributes.name%type;
1506: appIdList ame_util.idList;
1507: lm_count number;
1508: begin
1509: hr_utility.set_location('Entering:'|| l_proc, 10);
1510: --
1511: -- Issue a savepoint
1512: --
1513: savepoint create_ame_condition_to_rule;

Line 1771: hr_utility.set_location(' Leaving:'||l_proc, 70);

1767: p_object_version_number := l_cnu_object_version_number;
1768: p_start_date := l_cnu_start_date;
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

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

1783: --
1784: p_object_version_number := null;
1785: p_start_date := null;
1786: p_end_date := null;
1787: hr_utility.set_location(' Leaving:'||l_proc, 80);
1788: when others then
1789: --
1790: -- A validation or unexpected error has occured
1791: --

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

1796: --
1797: p_object_version_number := null;
1798: p_start_date := null;
1799: p_end_date := null;
1800: hr_utility.set_location(' Leaving:'||l_proc, 90);
1801: raise;
1802: end create_ame_condition_to_rule;
1803: --
1804: -- ----------------------------------------------------------------------------

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

1930: l_head_item_class_id ame_item_classes.item_class_id%type;
1931: l_aty_name ame_action_types.name%type;
1932: l_swi_call boolean;
1933: begin
1934: hr_utility.set_location('Entering:'|| l_proc, 10);
1935: --
1936: -- Issue a savepoint
1937: --
1938: savepoint create_ame_action_to_rule;

Line 2163: hr_utility.set_location(' Leaving:'||l_proc, 70);

2159: p_object_version_number := l_acu_object_version_number;
2160: p_start_date := l_acu_start_date;
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

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

2175: --
2176: p_object_version_number := null;
2177: p_start_date := null;
2178: p_end_date := null;
2179: hr_utility.set_location(' Leaving:'||l_proc, 80);
2180: when others then
2181: --
2182: -- A validation or unexpected error has occured
2183: --

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

2188: --
2189: p_object_version_number := null;
2190: p_start_date := null;
2191: p_end_date := null;
2192: hr_utility.set_location(' Leaving:'||l_proc, 90);
2193: raise;
2194: end create_ame_action_to_rule;
2195:
2196: --

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

2219: l_swi_package_name varchar2(30) := 'AME_RULE_SWI';
2220: l_proc varchar2(72) := g_package||'update_ame_rule';
2221: l_swi_call boolean;
2222: begin
2223: hr_utility.set_location('Entering:'|| l_proc, 10);
2224: --
2225: -- Issue a savepoint
2226: --
2227: savepoint update_ame_rule;

Line 2330: hr_utility.set_location(' Leaving:'||l_proc, 70);

2326: p_object_version_number := l_rul_object_version_number;
2327: p_start_date := l_rul_start_date;
2328: p_end_date := l_rul_end_date;
2329: --
2330: hr_utility.set_location(' Leaving:'||l_proc, 70);
2331: exception
2332: when app_exception.application_exception then
2333: if hr_multi_message.exception_add
2334: (p_associated_column1 => 'action_id') then

Line 2335: hr_utility.set_location(' Leaving:'|| l_proc, 50);

2331: exception
2332: when app_exception.application_exception then
2333: if hr_multi_message.exception_add
2334: (p_associated_column1 => 'action_id') then
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

Line 2338: hr_utility.set_location(' Leaving:'|| l_proc, 60);

2334: (p_associated_column1 => 'action_id') then
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

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

2348: -- when validation only mode is being used.)
2349: --
2350: p_start_date := null;
2351: p_end_date := null;
2352: hr_utility.set_location(' Leaving:'||l_proc, 80);
2353: when others then
2354: --
2355: -- A validation or unexpected error has occured
2356: --

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

2360: -- OUT parameters, including warnings, to null
2361: --
2362: p_start_date := null;
2363: p_end_date := null;
2364: hr_utility.set_location(' Leaving:'||l_proc, 90);
2365: raise;
2366: end update_ame_rule;
2367: --
2368: --

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

2441: or
2442: (l_effective_date < start_date
2443: and start_date < nvl(end_date, start_date + ame_util.oneSecond)));
2444: begin
2445: hr_utility.set_location('Entering:'|| l_proc, 10);
2446:
2447: if(p_end_date is not null and TRUNC(p_end_date) = TRUNC(SYSDATE)) then
2448: delete_ame_rule_usage(p_validate => p_validate
2449: ,p_rule_id => p_rule_id

Line 2648: hr_utility.set_location(' Leaving:'||l_proc, 70);

2644: p_object_version_number := l_rlu_object_version_number;
2645: p_start_date := l_rlu_start_date;
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

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

2659: -- when validation only mode is being used.)
2660: --
2661: p_start_date := null;
2662: p_end_date := null;
2663: hr_utility.set_location(' Leaving:'||l_proc, 80);
2664: when others then
2665: --
2666: -- A validation or unexpected error has occured
2667: --

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

2672: --
2673: p_start_date := null;
2674: p_end_date := null;
2675: --+
2676: hr_utility.set_location(' Leaving:'||l_proc, 90);
2677: raise;
2678: end update_ame_rule_usage;
2679: --
2680: -- ----------------------------------------------------------------------------

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

2786: and application_id = p_application_id
2787: and l_effective_date between start_date and
2788: nvl(end_date - ame_util.oneSecond,l_effective_date);
2789: begin
2790: hr_utility.set_location('Entering:'|| l_proc, 10);
2791: --
2792: -- Issue a savepoint
2793: --
2794: savepoint delete_ame_rule_usage;

Line 2958: hr_utility.set_location(' Leaving:'||l_proc, 70);

2954: p_object_version_number := l_rlu_object_version_number;
2955: p_start_date := l_rlu_start_date;
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

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

2970: --
2971: p_start_date := null;
2972: p_end_date := null;
2973: --+
2974: hr_utility.set_location(' Leaving:'||l_proc, 80);
2975: when others then
2976: --
2977: -- A validation or unexpected error has occured
2978: --

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

2983: --
2984: p_start_date := null;
2985: p_end_date := null;
2986: --+
2987: hr_utility.set_location(' Leaving:'||l_proc, 90);
2988: raise;
2989: end delete_ame_rule_usage;
2990: --
2991: -- ----------------------------------------------------------------------------

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

3098: applicationName ame_calling_apps.application_name%type;
3099: attributeName ame_attributes.name%type;
3100: l_swi_call boolean;
3101: begin
3102: hr_utility.set_location('Entering:'|| l_proc, 10);
3103: --
3104: -- Issue a savepoint
3105: --
3106: savepoint delete_ame_rule_condition ;

Line 3304: hr_utility.set_location(' Leaving:'||l_proc, 70);

3300: p_object_version_number := l_cnu_object_version_number;
3301: p_start_date := l_cnu_start_date;
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

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

3317: p_object_version_number := null;
3318: p_start_date := null;
3319: p_end_date := null;
3320: --+
3321: hr_utility.set_location(' Leaving:'||l_proc, 80);
3322: when others then
3323: --
3324: -- A validation or unexpected error has occured
3325: --

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

3331: p_object_version_number := null;
3332: p_start_date := null;
3333: p_end_date := null;
3334: --+
3335: hr_utility.set_location(' Leaving:'||l_proc, 90);
3336: raise;
3337: end delete_ame_rule_condition;
3338: --
3339: -- ----------------------------------------------------------------------------

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

3427: actionIdList ame_util.idList;
3428: conditionIdList ame_util.idList;
3429: l_swi_call boolean;
3430: begin
3431: hr_utility.set_location('Entering:'|| l_proc, 10);
3432: --
3433: -- Issue a savepoint
3434: --
3435: savepoint delete_ame_rule_action ;

Line 3582: hr_utility.set_location(' Leaving:'||l_proc, 70);

3578: p_object_version_number := l_acu_object_version_number;
3579: p_start_date := l_acu_start_date;
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

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

3595: p_object_version_number := null;
3596: p_start_date := null;
3597: p_end_date := null;
3598: --+
3599: hr_utility.set_location(' Leaving:'||l_proc, 80);
3600: when others then
3601: --+
3602: -- A validation or unexpected error has occured
3603: --+

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

3609: p_object_version_number := null;
3610: p_start_date := null;
3611: p_end_date := null;
3612: --+
3613: hr_utility.set_location(' Leaving:'||l_proc, 90);
3614: raise;
3615: end delete_ame_rule_action ;
3616: --
3617: -- ----------------------------------------------------------------------------

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

3677: l_cnu_start_date date;
3678: l_cnu_end_date date;
3679: l_new_cnu_start_date date;
3680: begin
3681: hr_utility.set_location('Entering:'|| l_proc, 10);
3682: --
3683: -- Issue a savepoint
3684: --
3685: savepoint replace_lm_condition;

Line 3869: hr_utility.set_location(' Leaving:'||l_proc, 70);

3865: p_object_version_number := l_cnu_object_version_number;
3866: p_start_date := l_cnu_start_date;
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

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

3881: --
3882: p_object_version_number := null;
3883: p_start_date := null;
3884: p_end_date := null;
3885: hr_utility.set_location(' Leaving:'||l_proc, 80);
3886: when others then
3887: --
3888: -- A validation or unexpected error has occured
3889: --

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

3894: --
3895: p_object_version_number := null;
3896: p_start_date := null;
3897: p_end_date := null;
3898: hr_utility.set_location(' Leaving:'||l_proc, 90);
3899: raise;
3900: end replace_lm_condition;
3901: end ame_rule_api;