[Home] [Help]
22: return(l_condition_type);
23: exception
24: when others then
25: fnd_message.set_name('PER','AME_400494_INVALID_CONDITION');
26: hr_multi_message.add (p_associated_column1 => 'CONDITION_ID');
27: raise;
28: return(null);
29: end getConditionType;
30: --+
95: return(0);
96: exception
97: when others then
98: fnd_message.set_name('PER','AME_400329_RULE_USG_OVER_LIFE');
99: hr_multi_message.add(p_associated_column1 =>'RULE_ID'
100: ,p_associated_column2 =>'ITEM_ID');
101: raise;
102: return(3);
103: end checkRuleUsageExists;
173: -- if this call is not made from an SWI package, raise an exception and return false
174: --+
175: if (instrb(DBMS_UTILITY.FORMAT_CALL_STACK,l_swi_package_name||fnd_global.local_chr(ascii_chr => 10)) = 0) then
176: fnd_message.set_name('PER','AME_400724_NO_ACTION_IN_RULE');
177: hr_multi_message.add (p_associated_column1 =>'RULE_ID');
178: return(false);
179: else
180: return(true);
181: end if;
231: fetch getApplicationName into applicationName;
232: close getApplicationName;
233: fnd_message.set_name('PER','AME_400640_TTY_NO_PROD_ACTIONS');
234: fnd_message.set_token('TXTYPENAME',applicationName);
235: hr_multi_message.add(p_associated_column1 =>'RULE_ID');
236: return(false);
237: end if;
238: end loop;
239: end if;
534: if p_condition_id is null then
535: --+
536: if p_rule_type = ame_util.exceptionRuleType then
537: fnd_message.set_name('PER','AME_400709_NO_EXC_COND_LCE_RUL');
538: hr_multi_message.add(p_associated_column1 => 'CONDITION_ID');
539: end if;
540: --+
541: if p_rule_type = ame_util.listModRuleType or p_rule_type = ame_util.substitutionRuleType then
542: fnd_message.set_name('PER','AME_400710_NO_LM_CON_LMSUB_RUL');
539: end if;
540: --+
541: if p_rule_type = ame_util.listModRuleType or p_rule_type = ame_util.substitutionRuleType then
542: fnd_message.set_name('PER','AME_400710_NO_LM_CON_LMSUB_RUL');
543: hr_multi_message.add(p_associated_column1 => 'CONDITION_ID');
544: end if;
545: --+
546: else
547: --+
556: into l_condition_type
557: ,l_attribute_id ;
558: if getConditionDetails%notfound then
559: fnd_message.set_name('PER','AME_400494_INVALID_CONDITION');
560: hr_multi_message.add(p_associated_column1 => 'CONDITION_ID');
561: end if;
562: close getConditionDetails;
563: --+
564: --+ Check if this condition can be added to this transaction type
565: --+
566: if not ame_rule_utility_pkg.is_condition_allowed(p_application_id => p_application_id
567: ,p_condition_id => p_condition_id) then
568: fnd_message.set_name('PER','AME_400738_COND_NOT_IN_APP');
569: hr_multi_message.add (p_associated_column1 => 'ITEM_ID');
570: end if;
571: --+
572: --+ Item class id should be null for LM Conditions
573: --+
666: if (getConditionType(p_condition_id => p_condition_id
667: ,p_effective_date => l_effective_date)
668: <> ame_util.exceptionConditionType) then
669: fnd_message.set_name('PER','AME_400709_NO_EXC_COND_LCE_RUL');
670: hr_multi_message.add (p_associated_column1 =>'CONDITION_ID');
671: end if;
672: elsif (p_rule_type = ame_util.listModRuleType or
673: p_rule_type = ame_util.substitutionRuleType) then
674: if ( getConditionType(p_condition_id => p_condition_id
674: if ( getConditionType(p_condition_id => p_condition_id
675: ,p_effective_date => l_effective_date)
676: <> ame_util.listModConditionType) then
677: fnd_message.set_name('PER','AME_400710_NO_LM_CON_LMSUB_RUL');
678: hr_multi_message.add (p_associated_column1 => 'CONDITION_ID');
679: end if;
680: end if;
681: --+
682: --+ Check Action Id.
682: --+ Check Action Id.
683: --+
684: if p_action_id is null then
685: fnd_message.set_name('PER','AME_400725_NO_ACTION_DEFINED');
686: hr_multi_message.add(p_associated_column1 => 'ACTION_ID');
687: else
688: ame_rule_utility_pkg.checkActionId(p_action_id);
689: --+
690: --+ Check the action and condition combination for LM Rule.
726: ,p_action_rule_type => l_action_rule_type
727: ,p_application_id => p_application_id
728: ,p_allow_production_action => false) then
729: fnd_message.set_name('PER','AME_400741_RULE_TYPE_MISMATCH');
730: hr_multi_message.add(p_associated_column1 => 'RULE_TYPE');
731: end if;
732: --
733: -- Create Action usage
734: --
1067: l_result := ame_rule_utility_pkg.is_rule_usage_allowed(p_application_id => p_application_id
1068: ,p_rule_id => p_rule_id);
1069: if l_result = ame_rule_utility_pkg.ActionNotAllowedInTTY then
1070: fnd_message.set_name('PER','AME_400735_ACT_NOT_IN_APP');
1071: hr_multi_message.add (p_associated_column1 => 'ITEM_ID');
1072: elsif l_result = ame_rule_utility_pkg.GroupNotAllowedInTTY then
1073: fnd_message.set_name('PER','AME_400744_GRP_NOT_IN_APP');
1074: hr_multi_message.add (p_associated_column1 => 'ITEM_ID');
1075: elsif l_result = ame_rule_utility_pkg.PosActionNotAllowedInTTY then
1070: fnd_message.set_name('PER','AME_400735_ACT_NOT_IN_APP');
1071: hr_multi_message.add (p_associated_column1 => 'ITEM_ID');
1072: elsif l_result = ame_rule_utility_pkg.GroupNotAllowedInTTY then
1073: fnd_message.set_name('PER','AME_400744_GRP_NOT_IN_APP');
1074: hr_multi_message.add (p_associated_column1 => 'ITEM_ID');
1075: elsif l_result = ame_rule_utility_pkg.PosActionNotAllowedInTTY then
1076: fnd_message.set_name('PER','AME_400770_POS_APR_NOT_IN_APP');
1077: hr_multi_message.add (p_associated_column1 => 'ITEM_ID');
1078: end if;
1073: fnd_message.set_name('PER','AME_400744_GRP_NOT_IN_APP');
1074: hr_multi_message.add (p_associated_column1 => 'ITEM_ID');
1075: elsif l_result = ame_rule_utility_pkg.PosActionNotAllowedInTTY then
1076: fnd_message.set_name('PER','AME_400770_POS_APR_NOT_IN_APP');
1077: hr_multi_message.add (p_associated_column1 => 'ITEM_ID');
1078: end if;
1079: --+
1080: --+ Check If all the conditions are
1081: --+ valid for this Transaction Type.
1082: --+
1083: if not ame_rule_utility_pkg.is_rule_usage_cond_allowed(p_application_id => p_application_id
1084: ,p_rule_id => p_rule_id) then
1085: fnd_message.set_name('PER','AME_400738_COND_NOT_IN_APP');
1086: hr_multi_message.add (p_associated_column1 => 'RULE_ID');
1087: end if;
1088: --+
1089: select item_class_id
1090: ,rule_type
1110: ,l_effective_date => l_effective_date);
1111: fetch itemClassUsageCursor into l_dummy;
1112: if itemClassUsageCursor%NOTFOUND then
1113: fnd_message.set_name('PER','AME_400740_INV_ITEM_CLASS_ID');
1114: hr_multi_message.add(p_associated_column1 =>'RULE_ID');
1115: end if;
1116: close itemClassUsageCursor;
1117: --
1118: -- Check the value of the config variable 'allowAllItemClassRules' to ensure that rules for this
1131: and nvl(end_date - ame_util.oneSecond, l_effective_date);
1132: if l_item_class_name not in (ame_util.headerItemClassName
1133: ,ame_util.lineItemItemClassName) then
1134: fnd_message.set_name('PER','AME_400743_ITC_NOT_ALLOWED');
1135: hr_multi_message.add(p_associated_column1 => 'RULE_ID');
1136: end if;
1137: end if;
1138: end if;
1139: --
1146: ,p_rule_id => p_rule_id
1147: ,p_effective_date => l_effective_date) then
1148: fnd_message.set_name('PER','AME_99999_RU_NOT_ALLOWED');
1149: fnd_message.raise_error;
1150: -- hr_multi_message.add(p_associated_column1 => 'RULE_ID');
1151: end if;
1152: end if;
1153: */
1154: --
1158: if p_approver_category = ame_util.fyiApproverCategory then
1159: if (ame_util.getConfigVar(variableNameIn => ame_util.allowFyiNotificationsConfigVar
1160: ,applicationIdIn => p_application_id) = ame_util.no ) then
1161: fnd_message.set_name('PER','AME_400742_FYI_CAT_NO_ALLOWED');
1162: hr_multi_message.add(p_associated_column1 => 'APPROVER_CATEGORY');
1163: end if;
1164: end if;
1165: l_approver_category := p_approver_category;
1166: if not l_swi_call then
1176: l_approver_category := ame_util.approvalApproverCategory;
1177: end if;
1178: elsif l_approver_category is not null then
1179: fnd_message.set_name('PER','AME_400744_APPR_CAT_NOT_NULL');
1180: hr_multi_message.add(p_associated_column1 => 'APPROVER_CATEGORY');
1181: end if;
1182: end if;
1183:
1184: --
1224: (instr(l_variable_value,':',1,7) +1));
1225: end if;
1226: if(priority <> ame_util.disabledRulePriority and p_priority is null) then
1227: fnd_message.set_name('PER','AME_400707_INVALID_PRIORITY');
1228: hr_multi_message.add(p_associated_column1 => 'PRIORITY');
1229: end if;
1230: --
1231: -- Check that the rule usage does not overlap with existing rule usage dates
1232: -- for the same application ID
1237: ,p_effective_date => l_effective_date
1238: ,p_priority => p_priority );
1239: if l_overlapping_usage = 1 then
1240: fnd_message.set_name('PER','AME_400327_RULE_USG_EXST_LIFE');
1241: hr_multi_message.add (p_associated_column1 => 'RULE_ID');
1242: elsif l_overlapping_usage = 2 then
1243: fnd_message.set_name('PER','AME_400328_RULE_USG_DIFF_PRIOR');
1244: hr_multi_message.add (p_associated_column1 =>'RULE_ID');
1245: elsif l_overlapping_usage = 3 then
1240: fnd_message.set_name('PER','AME_400327_RULE_USG_EXST_LIFE');
1241: hr_multi_message.add (p_associated_column1 => 'RULE_ID');
1242: elsif l_overlapping_usage = 2 then
1243: fnd_message.set_name('PER','AME_400328_RULE_USG_DIFF_PRIOR');
1244: hr_multi_message.add (p_associated_column1 =>'RULE_ID');
1245: elsif l_overlapping_usage = 3 then
1246: fnd_message.set_name('PER','AME_400329_RULE_USG_OVER_LIFE');
1247: hr_multi_message.add (p_associated_column1 => 'RULE_ID');
1248: end if;
1243: fnd_message.set_name('PER','AME_400328_RULE_USG_DIFF_PRIOR');
1244: hr_multi_message.add (p_associated_column1 =>'RULE_ID');
1245: elsif l_overlapping_usage = 3 then
1246: fnd_message.set_name('PER','AME_400329_RULE_USG_OVER_LIFE');
1247: hr_multi_message.add (p_associated_column1 => 'RULE_ID');
1248: end if;
1249: -- insert the row in ame_rule_usages
1250: if l_rlu_start_date is null then
1251: l_rlu_start_date := l_effective_date;
1552: for i in 1..appIdList.count loop
1553: if not ame_rule_utility_pkg.is_condition_allowed(p_application_id => appIdList(i)
1554: ,p_condition_id => p_condition_id) then
1555: fnd_message.set_name('PER','AME_400738_COND_NOT_IN_APP');
1556: hr_multi_message.add (p_associated_column1 => 'ITEM_ID');
1557: end if;
1558: end loop;
1559: --
1560: -- Fetch the condition details
1564: into l_condition_type
1565: ,l_attribute_id ;
1566: if getConditionDetails%notfound then
1567: fnd_message.set_name('PER','AME_400494_INVALID_CONDITION');
1568: hr_multi_message.add(p_associated_column1 => 'CONDITION_ID');
1569: end if;
1570: close getConditionDetails;
1571: --
1572: -- Fetch the rule details
1578: ,l_rul_end_date
1579: ,l_item_class_id;
1580: if getRuleDetails%notfound then
1581: fnd_message.set_name('PER','AME_400480_INV_RULE_ID');
1582: hr_multi_message.add(p_associated_column1 => 'RULE_ID');
1583: end if;
1584: close getRuleDetails;
1585: --+
1586: -- Check that the condition type of the condition is allowed for the Rule Type.
1597: --+
1598: if l_condition_type = ame_util.exceptionConditionType then
1599: if l_rule_type <> ame_util.exceptionRuleType then
1600: fnd_message.set_name('PER','AME_400726_NO_EXC_CON_IN_RULE');
1601: hr_multi_message.add(p_associated_column1 =>'CONDITION_ID');
1602: end if;
1603: elsif l_condition_type = ame_util.listModConditionType then
1604: if l_rule_type not in (ame_util.listModRuleType
1605: ,ame_util.substitutionRuleType
1604: if l_rule_type not in (ame_util.listModRuleType
1605: ,ame_util.substitutionRuleType
1606: ,ame_util.combinationRuleType) then
1607: fnd_message.set_name('PER','AME_400727_NO_LM_CON_IN_RULE');
1608: hr_multi_message.add(p_associated_column1 => 'CONDITION_ID');
1609: if ame_rule_utility_pkg.rule_conditions_count(p_rule_id => p_rule_id) > 0 then
1610: fnd_message.set_name('PER','AME_400733_EXTRA_LM_CON');
1611: hr_multi_message.add(p_associated_column1 => 'CONDITION_ID');
1612: end if;
1607: fnd_message.set_name('PER','AME_400727_NO_LM_CON_IN_RULE');
1608: hr_multi_message.add(p_associated_column1 => 'CONDITION_ID');
1609: if ame_rule_utility_pkg.rule_conditions_count(p_rule_id => p_rule_id) > 0 then
1610: fnd_message.set_name('PER','AME_400733_EXTRA_LM_CON');
1611: hr_multi_message.add(p_associated_column1 => 'CONDITION_ID');
1612: end if;
1613: end if;
1614: end if;
1615: --+
1646: ,ame_util.substitutionRuleType
1647: ,ame_util.combinationRuleType)
1648: and l_condition_type = ame_util.listModConditionType) then
1649: fnd_message.set_name('PER','AME_400385_RULE_LM');
1650: hr_multi_message.add(p_associated_column1 => 'CONDITION_ID');
1651: end if;
1652: end if;
1653: getConditionIds(ruleIdIn => p_rule_id,
1654: conditionIdListOut => conditionIdList);
1662: end if;
1663: end loop;
1664: if l_condition_found then
1665: fnd_message.set_name('PER','AME_400728_DUP_CON_IN_RULE');
1666: hr_multi_message.add(p_associated_column1 => 'CONDITION_ID');
1667: end if;
1668: -- add this condition_id to end of list
1669: l_condition_count := conditionIdList.count;
1670: conditionIdList(l_condition_count+1) := p_condition_id;
1676: ,p_conditions_list => conditionIdList
1677: ,p_actions_list => actionIdList
1678: ) then
1679: fnd_message.set_name('PER','AME_400212_RUL_PROP_EXISTS');
1680: hr_multi_message.add(p_associated_column1 => 'CONDITION_ID');
1681: end if;
1682: */
1683: end if;
1684:
1728: ,p_attribute_name_out => attributeName);
1729: fnd_message.set_name('PER','AME_400149_ATT_TTY_NO_USAGE');
1730: fnd_message.set_token('ATTRIBUTE',attributeName);
1731: fnd_message.set_token('APPLICATION',applicationName);
1732: hr_multi_message.add(p_associated_column1 => 'RULE_ID');
1733: end if;
1734: close getAttributeUsages;
1735: ame_attribute_api.updateUseCount(p_attribute_id => l_attribute_id
1736: ,p_application_id => tempApplications.item_id
1963: into l_action_type_id
1964: ,l_action_rule_type;
1965: if getActionDetails%notfound then
1966: fnd_message.set_name('PER','AME_400736_INV_ACTION_ID');
1967: hr_multi_message.add(p_associated_column1 => 'ACTION_ID');
1968: end if;
1969: close getActionDetails;
1970: --
1971: -- Fetch the rule details
1977: ,l_rul_end_date
1978: ,l_item_class_id;
1979: if getRuleDetails%notfound then
1980: fnd_message.set_name('PER','AME_400729_INV_RULE_ID');
1981: hr_multi_message.add(p_associated_column1 => 'RULE_ID');
1982: end if;
1983: close getRuleDetails;
1984: --+
1985: --+ Check if the action is of line-item job-level chains of authority action type.
1997: where name = 'header'
1998: and sysdate between start_date and nvl(end_date - (1/84600),sysdate);
1999: if l_head_item_class_id <> l_item_class_id then
2000: fnd_message.set_name('PER','AME_400449_INV_ACT_TYP_CHOSEN');
2001: hr_multi_message.add(p_associated_column1 => 'ITEM_CLASS_ID');
2002: end if;
2003: end if;
2004: --+
2005: --+ Checks to be done for all transaction types using this rule
2032: l_result := ame_rule_utility_pkg.is_action_allowed(p_application_id => appIdList(i)
2033: ,p_action_id => p_action_id);
2034: if l_result = ame_rule_utility_pkg.ActionNotAllowed then
2035: fnd_message.set_name('PER','AME_400735_ACT_NOT_IN_APP');
2036: hr_multi_message.add (p_associated_column1 => 'ITEM_ID');
2037: elsif l_result = ame_rule_utility_pkg.GroupNotAllowed then
2038: fnd_message.set_name('PER','AME_400744_GRP_NOT_IN_APP');
2039: hr_multi_message.add (p_associated_column1 => 'ITEM_ID');
2040: elsif l_result = ame_rule_utility_pkg.PosActionNotAllowed then
2035: fnd_message.set_name('PER','AME_400735_ACT_NOT_IN_APP');
2036: hr_multi_message.add (p_associated_column1 => 'ITEM_ID');
2037: elsif l_result = ame_rule_utility_pkg.GroupNotAllowed then
2038: fnd_message.set_name('PER','AME_400744_GRP_NOT_IN_APP');
2039: hr_multi_message.add (p_associated_column1 => 'ITEM_ID');
2040: elsif l_result = ame_rule_utility_pkg.PosActionNotAllowed then
2041: fnd_message.set_name('PER','AME_400770_POS_APR_NOT_IN_APP');
2042: hr_multi_message.add (p_associated_column1 => 'ITEM_ID');
2043: end if;
2038: fnd_message.set_name('PER','AME_400744_GRP_NOT_IN_APP');
2039: hr_multi_message.add (p_associated_column1 => 'ITEM_ID');
2040: elsif l_result = ame_rule_utility_pkg.PosActionNotAllowed then
2041: fnd_message.set_name('PER','AME_400770_POS_APR_NOT_IN_APP');
2042: hr_multi_message.add (p_associated_column1 => 'ITEM_ID');
2043: end if;
2044: --+
2045: --+ Check the Rule Type and action combination.
2046: --+
2049: ,p_action_rule_type => l_action_rule_type
2050: ,p_application_id => appIdList(i)
2051: ,p_allow_production_action => true) then
2052: fnd_message.set_name('PER','AME_400741_RULE_TYPE_MISMATCH');
2053: hr_multi_message.add(p_associated_column1 => 'RULE_TYPE');
2054: end if;
2055: if l_rule_type = ame_util.listModRuleType then
2056: if not ame_rule_utility_pkg.chk_lm_actions(p_rule_id => p_rule_id
2057: ,p_action_id => p_action_id) then
2055: if l_rule_type = ame_util.listModRuleType then
2056: if not ame_rule_utility_pkg.chk_lm_actions(p_rule_id => p_rule_id
2057: ,p_action_id => p_action_id) then
2058: fnd_message.set_name('PER','AME_400425_RULE_LM_RULE');
2059: hr_multi_message.add(p_associated_column1 => 'ACTION_ID');
2060: end if;
2061: end if;
2062: end loop;
2063: --added till here...
2073: end if;
2074: end loop;
2075: if l_action_found then
2076: fnd_message.set_name('PER','AME_400730_DUPLICATE_ACTION');
2077: hr_multi_message.add(p_associated_column1 => 'ACTION_ID');
2078: end if;
2079: -- add this condition_id to end of list
2080: l_count := actionIdList.count;
2081: actionIdList(l_count+1) := p_action_id;
2087: ,p_conditions_list => conditionIdList
2088: ,p_actions_list => actionIdList
2089: ) then
2090: fnd_message.set_name('PER','AME_400212_RUL_PROP_EXISTS');
2091: hr_multi_message.add(p_associated_column1 => 'CONDITION_ID');
2092: end if;
2093: */
2094: end if;
2095:
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;
2274: l_rul_end_date := null;
2275: else
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
2335: hr_utility.set_location(' Leaving:'|| l_proc, 50);
2336: raise;
2337: end if;
2491: if (instrb(DBMS_UTILITY.FORMAT_CALL_STACK,l_swi_package_name||fnd_global.local_chr(ascii_chr => 10)) = 0) then
2492: l_swi_call := false ;
2493: if p_start_date < l_effective_date then
2494: fnd_message.set_name('PER','AME_400213_RUL_STRT_GRTR_CUR');
2495: hr_multi_message.add (p_associated_column1 => 'START_DATE');
2496: end if;
2497: if p_end_date < l_effective_date then
2498: fnd_message.set_name('PER','AME_400706_PAS_END_DATE');
2499: hr_multi_message.add (p_associated_column1 => 'END_DATE');
2495: hr_multi_message.add (p_associated_column1 => 'START_DATE');
2496: end if;
2497: if p_end_date < l_effective_date then
2498: fnd_message.set_name('PER','AME_400706_PAS_END_DATE');
2499: hr_multi_message.add (p_associated_column1 => 'END_DATE');
2500: end if;
2501: if p_start_date > p_end_date then
2502: fnd_message.set_name('PER','AME_400214_RUL_STRT_LESS_END');
2503: hr_multi_message.add (p_associated_column1 => 'START_DATE');
2499: hr_multi_message.add (p_associated_column1 => 'END_DATE');
2500: end if;
2501: if p_start_date > p_end_date then
2502: fnd_message.set_name('PER','AME_400214_RUL_STRT_LESS_END');
2503: hr_multi_message.add (p_associated_column1 => 'START_DATE');
2504: end if;
2505: end if;
2506: --+
2507: --+ Check the Rule Id.
2523: ,p_priority => p_priority
2524: ,p_old_start_date => p_old_start_date);
2525: if l_overlapping_usage = 1 then
2526: fnd_message.set_name('PER','AME_400327_RULE_USG_EXST_LIFE');
2527: hr_multi_message.add (p_associated_column1 => 'RULE_ID');
2528: elsif l_overlapping_usage = 2 then
2529: fnd_message.set_name('PER','AME_400328_RULE_USG_DIFF_PRIOR');
2530: hr_multi_message.add (p_associated_column1 => 'RULE_ID');
2531: elsif l_overlapping_usage = 3 then
2526: fnd_message.set_name('PER','AME_400327_RULE_USG_EXST_LIFE');
2527: hr_multi_message.add (p_associated_column1 => 'RULE_ID');
2528: elsif l_overlapping_usage = 2 then
2529: fnd_message.set_name('PER','AME_400328_RULE_USG_DIFF_PRIOR');
2530: hr_multi_message.add (p_associated_column1 => 'RULE_ID');
2531: elsif l_overlapping_usage = 3 then
2532: fnd_message.set_name('PER','AME_400329_RULE_USG_OVER_LIFE');
2533: hr_multi_message.add (p_associated_column1 => 'RULE_ID');
2534: end if;
2529: fnd_message.set_name('PER','AME_400328_RULE_USG_DIFF_PRIOR');
2530: hr_multi_message.add (p_associated_column1 => 'RULE_ID');
2531: elsif l_overlapping_usage = 3 then
2532: fnd_message.set_name('PER','AME_400329_RULE_USG_OVER_LIFE');
2533: hr_multi_message.add (p_associated_column1 => 'RULE_ID');
2534: end if;
2535: --
2536: l_rlu_object_version_number := p_object_version_number;
2537: l_rlu_start_date := p_start_date;
3147: fetch getRuleDetails into l_rule_type, l_rul_start_date, l_rul_end_date,
3148: l_item_class_id;
3149: if getRuleDetails%notfound then
3150: fnd_message.set_name('PER','AME_400729_INV_RULE_ID');
3151: hr_multi_message.add(p_associated_column1 => 'RULE_ID');
3152: end if;
3153: close getRuleDetails;
3154: l_swi_call := true;
3155: if (instrb(DBMS_UTILITY.FORMAT_CALL_STACK,l_swi_package_name||fnd_global.local_chr(ascii_chr => 10)) = 0) then
3156: l_swi_call := false;
3157: if not ame_rule_utility_pkg.is_cond_exist_in_rule(p_rule_id => p_rule_id
3158: ,p_condition_id => p_condition_id) then
3159: fnd_message.set_name('PER','AME_400772_CON_NOT_EXIST_RULE');
3160: hr_multi_message.add(p_associated_column1 => 'CONDITION_ID');
3161: end if;
3162: if l_rule_type = ame_util.exceptionRuleType then
3163: l_condition_type := ame_util.exceptionConditionType;
3164: --
3169: fetch getConditionCount into l_count;
3170: close getConditionCount;
3171: if l_count = 0 then
3172: fnd_message.set_name('PER','AME_400709_NO_EXC_COND_LCE_RUL');
3173: hr_multi_message.add(p_associated_column1 => 'CONDITION_ID');
3174: end if;
3175: elsif l_rule_type in (ame_util.listModRuleType, ame_util.substitutionRuleType) then
3176: l_condition_type := ame_util.listModConditionType ;
3177: --
3182: fetch getConditionCount into l_count;
3183: close getConditionCount;
3184: if l_count = 0 then
3185: fnd_message.set_name('PER','AME_400710_NO_LM_CON_LMSUB_RUL');
3186: hr_multi_message.add(p_associated_column1 => 'CONDITION_ID');
3187: end if;
3188: end if;
3189: --
3190: -- Check that there is no other rule with the same combination of actions and conditions
3216: ,p_conditions_list => conditionIdList
3217: ,p_actions_list => actionIdList
3218: ) then
3219: fnd_message.set_name('PER','AME_400212_RUL_PROP_EXISTS');
3220: hr_multi_message.add(p_associated_column1 => 'CONDITION_ID');
3221: end if;
3222: */
3223: end if; -- end of if not swi call.
3224:
3261: ,p_attribute_name_out => attributeName);
3262: fnd_message.set_name('PER','AME_400149_ATT_TTY_NO_USAGE');
3263: fnd_message.set_token('ATTRIBUTE',attributeName);
3264: fnd_message.set_token('APPLICATION',applicationName);
3265: hr_multi_message.add(p_associated_column1 => 'RULE_ID');
3266: end if;
3267: close getAttributeUsages;
3268: ame_attribute_api.updateUseCount(p_attribute_id => l_attribute_id
3269: ,p_application_id => tempApplications.item_id
3477: fetch getActionCount into l_count;
3478: close getActionCount;
3479: if l_count = 0 then
3480: fnd_message.set_name('PER','AME_400724_NO_ACTION_IN_RULE');
3481: hr_multi_message.add(p_associated_column1 => 'ACTION_ID');
3482: end if;
3483: --+
3484: --+ verify the action can be deleted or not
3485: --+
3486: if not ame_rule_utility_pkg.is_action_deletion_allowed
3487: (p_rule_id => p_rule_id
3488: ,p_action_id => p_action_id) then
3489: fnd_message.set_name('PER','AME_400739_INV_ACT_DEL_RULE');
3490: hr_multi_message.add(p_associated_column1 => 'ACTION_ID');
3491: end if;
3492: --+
3493: getConditionIds(ruleIdIn => p_rule_id,
3494: conditionIdListOut => conditionIdList);
3515: ,p_conditions_list => conditionIdList
3516: ,p_actions_list => actionIdList
3517: ) then
3518: fnd_message.set_name('PER','AME_400212_RUL_PROP_EXISTS');
3519: hr_multi_message.add(p_associated_column1 => 'CONDITION_ID');
3520: end if;
3521: */
3522: end if;
3523: if l_swi_call and p_effective_date is not null then
3718: into l_condition_type
3719: ,l_attribute_id ;
3720: if getConditionDetails%notfound then
3721: fnd_message.set_name('PER','AME_400494_INVALID_CONDITION');
3722: hr_multi_message.add(p_associated_column1 => 'CONDITION_ID');
3723: end if;
3724: close getConditionDetails;
3725: --
3726: -- Fetch the rule details
3732: ,l_rul_end_date
3733: ,l_item_class_id;
3734: if getRuleDetails%notfound then
3735: fnd_message.set_name('PER','AME_400480_INV_RULE_ID');
3736: hr_multi_message.add(p_associated_column1 => 'RULE_ID');
3737: end if;
3738: close getRuleDetails;
3739: --+
3740: --+ Error out if condition is not LM.
3740: --+ Error out if condition is not LM.
3741: --+
3742: if l_condition_type <> ame_util.listModConditionType then
3743: fnd_message.set_name('PER','AME_400776_NON_LM_COND');
3744: hr_multi_message.add (p_associated_column1 => 'CONDITION_ID');
3745: end if;
3746: --+
3747: --+ Error out if rule is not LM/SUB/ LMCOMB.
3748: --+
3747: --+ Error out if rule is not LM/SUB/ LMCOMB.
3748: --+
3749: if (l_rule_type = ame_util.combinationRuleType and not ame_rule_utility_pkg.is_LM_comb_rule(p_rule_id)) then
3750: fnd_message.set_name('PER','AME_400777_NON_LM_SUB_RULE');
3751: hr_multi_message.add (p_associated_column1 => 'RULE_ID');
3752: end if;
3753: if l_rule_type not in(ame_util.listModRuleType
3754: ,ame_util.substitutionRuleType) then
3755: fnd_message.set_name('PER','AME_400777_NON_LM_SUB_RULE');
3752: end if;
3753: if l_rule_type not in(ame_util.listModRuleType
3754: ,ame_util.substitutionRuleType) then
3755: fnd_message.set_name('PER','AME_400777_NON_LM_SUB_RULE');
3756: hr_multi_message.add (p_associated_column1 => 'RULE_ID');
3757: end if;
3758: --+
3759: --+ Get the Old Condition ID
3760: --+
3774: --+ Error out if the new condition id is same as current condition id.
3775: --+
3776: if l_old_condition_id = p_condition_id then
3777: fnd_message.set_name('PER','AME_400778_DIFF_LM_COND');
3778: hr_multi_message.add (p_associated_column1 => 'CONDITION_ID');
3779: end if;
3780: --+
3781: --+ Check if this condition is valid in all the transaction tyes having this rule.
3782: --+
3786: for i in 1..appIdList.count loop
3787: if not ame_rule_utility_pkg.is_condition_allowed(p_application_id => appIdList(i)
3788: ,p_condition_id => p_condition_id) then
3789: fnd_message.set_name('PER','AME_400738_COND_NOT_IN_APP');
3790: hr_multi_message.add (p_associated_column1 => 'ITEM_ID');
3791: end if;
3792: end loop;
3793: --+
3794: --+ Verify the actions and conditions