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.AME_RULE_API dependencies on FND_MESSAGE

Line 25: fnd_message.set_name('PER','AME_400494_INVALID_CONDITION');

21: and nvl(end_date - ame_util.oneSecond, p_effective_date);
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;

Line 98: fnd_message.set_name('PER','AME_400329_RULE_USG_OVER_LIFE');

94: end loop;
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);

Line 176: fnd_message.set_name('PER','AME_400724_NO_ACTION_IN_RULE');

172: --+
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);

Line 233: fnd_message.set_name('PER','AME_400640_TTY_NO_PROD_ACTIONS');

229: if l_count <> 0 then
230: open getApplicationName(applicationIdIn => p_application_id);
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;

Line 234: fnd_message.set_token('TXTYPENAME',applicationName);

230: open getApplicationName(applicationIdIn => p_application_id);
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;

Line 537: fnd_message.set_name('PER','AME_400709_NO_EXC_COND_LCE_RUL');

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

Line 542: fnd_message.set_name('PER','AME_400710_NO_LM_CON_LMSUB_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');
543: hr_multi_message.add(p_associated_column1 => 'CONDITION_ID');
544: end if;
545: --+
546: else

Line 559: fnd_message.set_name('PER','AME_400494_INVALID_CONDITION');

555: fetch getConditionDetails
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: --+

Line 568: fnd_message.set_name('PER','AME_400738_COND_NOT_IN_APP');

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

Line 627: fnd_message.set_name('PER','AME_400208_RUL_STRT_PREC_TDY');

623: end if;
624:
625: if not l_swi_call then
626: if(l_rul_start_date < l_effective_date ) then
627: fnd_message.set_name('PER','AME_400208_RUL_STRT_PREC_TDY');
628: fnd_message.raise_error;
629: end if;
630: end if;
631:

Line 628: fnd_message.raise_error;

624:
625: if not l_swi_call then
626: if(l_rul_start_date < l_effective_date ) then
627: fnd_message.set_name('PER','AME_400208_RUL_STRT_PREC_TDY');
628: fnd_message.raise_error;
629: end if;
630: end if;
631:
632: l_effective_date := l_rul_start_date;

Line 669: fnd_message.set_name('PER','AME_400709_NO_EXC_COND_LCE_RUL');

665: if p_rule_type = ame_util.exceptionRuleType then
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

Line 677: fnd_message.set_name('PER','AME_400710_NO_LM_CON_LMSUB_RUL');

673: p_rule_type = ame_util.substitutionRuleType) then
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: --+

Line 685: fnd_message.set_name('PER','AME_400725_NO_ACTION_DEFINED');

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

Line 729: fnd_message.set_name('PER','AME_400741_RULE_TYPE_MISMATCH');

725: ,p_rule_type => p_rule_type
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

Line 1070: fnd_message.set_name('PER','AME_400735_ACT_NOT_IN_APP');

1066: --+
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');

Line 1073: fnd_message.set_name('PER','AME_400744_GRP_NOT_IN_APP');

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
1076: fnd_message.set_name('PER','AME_400770_POS_APR_NOT_IN_APP');
1077: hr_multi_message.add (p_associated_column1 => 'ITEM_ID');

Line 1076: fnd_message.set_name('PER','AME_400770_POS_APR_NOT_IN_APP');

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;
1079: --+
1080: --+ Check If all the conditions are

Line 1085: fnd_message.set_name('PER','AME_400738_COND_NOT_IN_APP');

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

Line 1113: fnd_message.set_name('PER','AME_400740_INV_ITEM_CLASS_ID');

1109: ,p_item_class_id => l_item_class_id
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: --

Line 1134: fnd_message.set_name('PER','AME_400743_ITC_NOT_ALLOWED');

1130: and l_effective_date between start_date
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;

Line 1148: fnd_message.set_name('PER','AME_99999_RU_NOT_ALLOWED');

1144: if l_rule_type not in (ame_util.substitutionRuleType) then
1145: if not checkRuleAllowed(p_application_id => p_application_id
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;

Line 1149: fnd_message.raise_error;

1145: if not checkRuleAllowed(p_application_id => p_application_id
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: */

Line 1161: fnd_message.set_name('PER','AME_400742_FYI_CAT_NO_ALLOWED');

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

Line 1179: fnd_message.set_name('PER','AME_400744_APPR_CAT_NOT_NULL');

1175: if l_approver_category is null 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:

Line 1227: fnd_message.set_name('PER','AME_400707_INVALID_PRIORITY');

1223: priority := substrb(l_variable_value,
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

Line 1240: fnd_message.set_name('PER','AME_400327_RULE_USG_EXST_LIFE');

1236: ,p_rlu_end_date => p_end_date
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');

Line 1243: fnd_message.set_name('PER','AME_400328_RULE_USG_DIFF_PRIOR');

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
1246: fnd_message.set_name('PER','AME_400329_RULE_USG_OVER_LIFE');
1247: hr_multi_message.add (p_associated_column1 => 'RULE_ID');

Line 1246: fnd_message.set_name('PER','AME_400329_RULE_USG_OVER_LIFE');

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;
1249: -- insert the row in ame_rule_usages
1250: if l_rlu_start_date is null then

Line 1555: fnd_message.set_name('PER','AME_400738_COND_NOT_IN_APP');

1551: bulk collect into appIdList;
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: --

Line 1567: fnd_message.set_name('PER','AME_400494_INVALID_CONDITION');

1563: fetch getConditionDetails
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: --

Line 1581: fnd_message.set_name('PER','AME_400480_INV_RULE_ID');

1577: ,l_rul_start_date
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: --+

Line 1600: fnd_message.set_name('PER','AME_400726_NO_EXC_CON_IN_RULE');

1596: -- Production Rule Y N N
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

Line 1607: fnd_message.set_name('PER','AME_400727_NO_LM_CON_IN_RULE');

1603: elsif l_condition_type = ame_util.listModConditionType then
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');

Line 1610: fnd_message.set_name('PER','AME_400733_EXTRA_LM_CON');

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;
1613: end if;
1614: end if;

Line 1649: fnd_message.set_name('PER','AME_400385_RULE_LM');

1645: if(l_rule_type in(ame_util.listModRuleType
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,

Line 1665: fnd_message.set_name('PER','AME_400728_DUP_CON_IN_RULE');

1661: l_condition_found := true;
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;

Line 1679: fnd_message.set_name('PER','AME_400212_RUL_PROP_EXISTS');

1675: ,p_effective_date => l_effective_date
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;

Line 1729: fnd_message.set_name('PER','AME_400149_ATT_TTY_NO_USAGE');

1725: fetch getApplicationName into applicationName;
1726: close getApplicationName;
1727: ame_rule_utility_pkg.getAttributeName(p_attribute_id => l_attribute_id
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;

Line 1730: fnd_message.set_token('ATTRIBUTE',attributeName);

1726: close getApplicationName;
1727: ame_rule_utility_pkg.getAttributeName(p_attribute_id => l_attribute_id
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;

Line 1731: fnd_message.set_token('APPLICATION',applicationName);

1727: ame_rule_utility_pkg.getAttributeName(p_attribute_id => l_attribute_id
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

Line 1966: fnd_message.set_name('PER','AME_400736_INV_ACTION_ID');

1962: fetch getActionDetails
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: --

Line 1980: fnd_message.set_name('PER','AME_400729_INV_RULE_ID');

1976: ,l_rul_start_date
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: --+

Line 2000: fnd_message.set_name('PER','AME_400449_INV_ACT_TYP_CHOSEN');

1996: from ame_item_classes
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: --+

Line 2035: fnd_message.set_name('PER','AME_400735_ACT_NOT_IN_APP');

2031: for i in 1..appIdList.count loop
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');

Line 2038: fnd_message.set_name('PER','AME_400744_GRP_NOT_IN_APP');

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
2041: fnd_message.set_name('PER','AME_400770_POS_APR_NOT_IN_APP');
2042: hr_multi_message.add (p_associated_column1 => 'ITEM_ID');

Line 2041: fnd_message.set_name('PER','AME_400770_POS_APR_NOT_IN_APP');

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;
2044: --+
2045: --+ Check the Rule Type and action combination.

Line 2052: fnd_message.set_name('PER','AME_400741_RULE_TYPE_MISMATCH');

2048: ,p_rule_type => l_rule_type
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

Line 2058: fnd_message.set_name('PER','AME_400425_RULE_LM_RULE');

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

Line 2076: fnd_message.set_name('PER','AME_400730_DUPLICATE_ACTION');

2072: l_action_found := true;
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;

Line 2090: fnd_message.set_name('PER','AME_400212_RUL_PROP_EXISTS');

2086: ,p_effective_date => l_effective_date
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;

Line 2256: fnd_message.set_name('PER', 'AME_400729_INV_RULE_ID');

2252: l_rul_object_version_number := p_object_version_number;
2253: --+ Check Rule Id.
2254: ame_rule_utility_pkg.checkRuleId(p_rule_id => p_rule_id);
2255: if p_rule_id is null then
2256: fnd_message.set_name('PER', 'AME_400729_INV_RULE_ID');
2257: fnd_message.set_token('PROCEDURE', l_proc);
2258: fnd_message.set_token('STEP','5');
2259: fnd_message.raise_error;
2260: end if;

Line 2257: fnd_message.set_token('PROCEDURE', l_proc);

2253: --+ Check Rule Id.
2254: ame_rule_utility_pkg.checkRuleId(p_rule_id => p_rule_id);
2255: if p_rule_id is null then
2256: fnd_message.set_name('PER', 'AME_400729_INV_RULE_ID');
2257: fnd_message.set_token('PROCEDURE', l_proc);
2258: fnd_message.set_token('STEP','5');
2259: fnd_message.raise_error;
2260: end if;
2261: --

Line 2258: fnd_message.set_token('STEP','5');

2254: ame_rule_utility_pkg.checkRuleId(p_rule_id => p_rule_id);
2255: if p_rule_id is null then
2256: fnd_message.set_name('PER', 'AME_400729_INV_RULE_ID');
2257: fnd_message.set_token('PROCEDURE', l_proc);
2258: fnd_message.set_token('STEP','5');
2259: fnd_message.raise_error;
2260: end if;
2261: --
2262: -- Check if the API is called from the SWI layer. If yes, update start and end dates for rules.

Line 2259: fnd_message.raise_error;

2255: if p_rule_id is null then
2256: fnd_message.set_name('PER', 'AME_400729_INV_RULE_ID');
2257: fnd_message.set_token('PROCEDURE', l_proc);
2258: fnd_message.set_token('STEP','5');
2259: fnd_message.raise_error;
2260: end if;
2261: --
2262: -- Check if the API is called from the SWI layer. If yes, update start and end dates for rules.
2263: -- Else only update Description.

Line 2270: fnd_message.set_name('PER','AME_400731_NO_DESCRIPTION');

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;
2274: l_rul_end_date := null;

Line 2494: fnd_message.set_name('PER','AME_400213_RUL_STRT_GRTR_CUR');

2490: l_swi_call := true;
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');

Line 2498: fnd_message.set_name('PER','AME_400706_PAS_END_DATE');

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');
2500: end if;
2501: if p_start_date > p_end_date then
2502: fnd_message.set_name('PER','AME_400214_RUL_STRT_LESS_END');

Line 2502: fnd_message.set_name('PER','AME_400214_RUL_STRT_LESS_END');

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');
2504: end if;
2505: end if;
2506: --+

Line 2526: fnd_message.set_name('PER','AME_400327_RULE_USG_EXST_LIFE');

2522: ,p_effective_date => l_effective_date
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');

Line 2529: fnd_message.set_name('PER','AME_400328_RULE_USG_DIFF_PRIOR');

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
2532: fnd_message.set_name('PER','AME_400329_RULE_USG_OVER_LIFE');
2533: hr_multi_message.add (p_associated_column1 => 'RULE_ID');

Line 2532: fnd_message.set_name('PER','AME_400329_RULE_USG_OVER_LIFE');

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;
2535: --
2536: l_rlu_object_version_number := p_object_version_number;

Line 3150: fnd_message.set_name('PER','AME_400729_INV_RULE_ID');

3146: open getRuleDetails;
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;

Line 3159: fnd_message.set_name('PER','AME_400772_CON_NOT_EXIST_RULE');

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;

Line 3172: fnd_message.set_name('PER','AME_400709_NO_EXC_COND_LCE_RUL');

3168: ,p_condition_id => p_condition_id);
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 ;

Line 3185: fnd_message.set_name('PER','AME_400710_NO_LM_CON_LMSUB_RUL');

3181: ,p_condition_id => p_condition_id);
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: --

Line 3219: fnd_message.set_name('PER','AME_400212_RUL_PROP_EXISTS');

3215: ,p_effective_date => l_effective_date
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.

Line 3262: fnd_message.set_name('PER','AME_400149_ATT_TTY_NO_USAGE');

3258: fetch getApplicationName into applicationName;
3259: close getApplicationName;
3260: ame_rule_utility_pkg.getAttributeName(p_attribute_id => l_attribute_id
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;

Line 3263: fnd_message.set_token('ATTRIBUTE',attributeName);

3259: close getApplicationName;
3260: ame_rule_utility_pkg.getAttributeName(p_attribute_id => l_attribute_id
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;

Line 3264: fnd_message.set_token('APPLICATION',applicationName);

3260: ame_rule_utility_pkg.getAttributeName(p_attribute_id => l_attribute_id
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

Line 3480: fnd_message.set_name('PER','AME_400724_NO_ACTION_IN_RULE');

3476: open getActionCount;
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

Line 3489: fnd_message.set_name('PER','AME_400739_INV_ACT_DEL_RULE');

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,

Line 3518: fnd_message.set_name('PER','AME_400212_RUL_PROP_EXISTS');

3514: ,p_effective_date => l_effective_date
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;

Line 3721: fnd_message.set_name('PER','AME_400494_INVALID_CONDITION');

3717: fetch getConditionDetails
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: --

Line 3735: fnd_message.set_name('PER','AME_400480_INV_RULE_ID');

3731: ,l_rul_start_date
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: --+

Line 3743: fnd_message.set_name('PER','AME_400776_NON_LM_COND');

3739: --+
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.

Line 3750: fnd_message.set_name('PER','AME_400777_NON_LM_SUB_RULE');

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

Line 3755: 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');
3756: hr_multi_message.add (p_associated_column1 => 'RULE_ID');
3757: end if;
3758: --+
3759: --+ Get the Old Condition ID

Line 3777: fnd_message.set_name('PER','AME_400778_DIFF_LM_COND');

3773: --+
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.

Line 3789: fnd_message.set_name('PER','AME_400738_COND_NOT_IN_APP');

3785: bulk collect into appIdList;
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: --+