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 AME_RULE_UTILITY_PKG

Line 530: ame_rule_utility_pkg.checkApplicationId(p_application_id => p_application_id);

526: l_swi_call := false;
527: --+
528: --+ Check the application id.
529: --+
530: ame_rule_utility_pkg.checkApplicationId(p_application_id => p_application_id);
531: --+
532: --+ condition id cannot be null for LCE and LM/SUB rule.
533: --+
534: if p_condition_id is null then

Line 550: ame_rule_utility_pkg.checkConditionId(p_condition_id);

546: else
547: --+
548: --+ Check the not null Condition Id.
549: --+
550: ame_rule_utility_pkg.checkConditionId(p_condition_id);
551: --+
552: --+ Fetch the condition details.
553: --+
554: open getConditionDetails;

Line 566: if not ame_rule_utility_pkg.is_condition_allowed(p_application_id => p_application_id

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;

Line 688: ame_rule_utility_pkg.checkActionId(p_action_id);

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.
691: --+
692: if p_rule_type = ame_util.listModRuleType then

Line 693: ame_rule_utility_pkg.chk_LM_action_Condition(p_condition_id => p_condition_id

689: --+
690: --+ Check the action and condition combination for LM Rule.
691: --+
692: if p_rule_type = ame_util.listModRuleType then
693: ame_rule_utility_pkg.chk_LM_action_Condition(p_condition_id => p_condition_id
694: ,p_action_id => p_action_id
695: ,is_first_condition => true);
696: end if;
697: end if;

Line 723: if not ame_rule_utility_pkg.chk_rule_type

719: end if;
720: --+
721: --+ Check the Rule Type and action combination.
722: --+
723: if not ame_rule_utility_pkg.chk_rule_type
724: (p_rule_id => l_rule_id
725: ,p_rule_type => p_rule_type
726: ,p_action_rule_type => l_action_rule_type
727: ,p_application_id => p_application_id

Line 1058: ame_rule_utility_pkg.checkRuleId(p_rule_id => p_rule_id);

1054:
1055: --+
1056: --+ Check Rule Id
1057: --+
1058: ame_rule_utility_pkg.checkRuleId(p_rule_id => p_rule_id);
1059: --+
1060: --+ Check Application Id
1061: --+
1062: ame_rule_utility_pkg.checkApplicationId(p_application_id => p_application_id);

Line 1062: ame_rule_utility_pkg.checkApplicationId(p_application_id => p_application_id);

1058: ame_rule_utility_pkg.checkRuleId(p_rule_id => p_rule_id);
1059: --+
1060: --+ Check Application Id
1061: --+
1062: ame_rule_utility_pkg.checkApplicationId(p_application_id => p_application_id);
1063: --+
1064: --+ Check If all the actions for this rule
1065: --+ are valid for this Transaction Type.
1066: --+

Line 1067: l_result := ame_rule_utility_pkg.is_rule_usage_allowed(p_application_id => p_application_id

1063: --+
1064: --+ Check If all the actions for this rule
1065: --+ are valid for this Transaction Type.
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');

Line 1069: if l_result = ame_rule_utility_pkg.ActionNotAllowedInTTY then

1065: --+ are valid for this Transaction Type.
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');

Line 1072: elsif l_result = ame_rule_utility_pkg.GroupNotAllowedInTTY then

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
1076: fnd_message.set_name('PER','AME_400770_POS_APR_NOT_IN_APP');

Line 1075: elsif l_result = ame_rule_utility_pkg.PosActionNotAllowedInTTY then

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;
1079: --+

Line 1083: if not ame_rule_utility_pkg.is_rule_usage_cond_allowed(p_application_id => p_application_id

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;

Line 1174: elsif l_rule_type = ame_util.combinationRuleType and not ame_rule_utility_pkg.is_LM_comb_rule(p_rule_id) then

1170: ,ame_util.combinationRuleType)) then
1171: if l_approver_category is null then
1172: l_approver_category := ame_util.approvalApproverCategory;
1173: end if;
1174: elsif l_rule_type = ame_util.combinationRuleType and not ame_rule_utility_pkg.is_LM_comb_rule(p_rule_id) then
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

Line 1536: ame_rule_utility_pkg.checkRuleId(p_rule_id => p_rule_id);

1532: -- Set the effective date to the sysdate
1533: l_effective_date := sysdate;
1534:
1535: l_swi_call := true;
1536: ame_rule_utility_pkg.checkRuleId(p_rule_id => p_rule_id);
1537: ame_rule_utility_pkg.checkConditionId(p_condition_id => p_condition_id);
1538: if (instrb(DBMS_UTILITY.FORMAT_CALL_STACK,l_swi_package_name||fnd_global.local_chr(ascii_chr => 10)) = 0) then
1539: ame_rule_utility_pkg.chk_rule_and_item_class(p_rule_id => p_rule_id
1540: ,p_condition_id => p_condition_id);

Line 1537: ame_rule_utility_pkg.checkConditionId(p_condition_id => p_condition_id);

1533: l_effective_date := sysdate;
1534:
1535: l_swi_call := true;
1536: ame_rule_utility_pkg.checkRuleId(p_rule_id => p_rule_id);
1537: ame_rule_utility_pkg.checkConditionId(p_condition_id => p_condition_id);
1538: if (instrb(DBMS_UTILITY.FORMAT_CALL_STACK,l_swi_package_name||fnd_global.local_chr(ascii_chr => 10)) = 0) then
1539: ame_rule_utility_pkg.chk_rule_and_item_class(p_rule_id => p_rule_id
1540: ,p_condition_id => p_condition_id);
1541: l_swi_call := false;

Line 1539: ame_rule_utility_pkg.chk_rule_and_item_class(p_rule_id => p_rule_id

1535: l_swi_call := true;
1536: ame_rule_utility_pkg.checkRuleId(p_rule_id => p_rule_id);
1537: ame_rule_utility_pkg.checkConditionId(p_condition_id => p_condition_id);
1538: if (instrb(DBMS_UTILITY.FORMAT_CALL_STACK,l_swi_package_name||fnd_global.local_chr(ascii_chr => 10)) = 0) then
1539: ame_rule_utility_pkg.chk_rule_and_item_class(p_rule_id => p_rule_id
1540: ,p_condition_id => p_condition_id);
1541: l_swi_call := false;
1542: end if;
1543:

Line 1553: if not ame_rule_utility_pkg.is_condition_allowed(p_application_id => appIdList(i)

1549: open getApplicationIds(p_rule_id => p_rule_id);
1550: fetch getApplicationIds
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;

Line 1609: if ame_rule_utility_pkg.rule_conditions_count(p_rule_id => p_rule_id) > 0 then

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

Line 1686: ame_rule_utility_pkg.checkAllApplications(ruleIdIn => p_rule_id

1682: */
1683: end if;
1684:
1685: --+
1686: ame_rule_utility_pkg.checkAllApplications(ruleIdIn => p_rule_id
1687: ,conditionIdIn => p_condition_id);
1688: --+
1689: --
1690: -- Calculate Condition Usage start and end date.

Line 1727: ame_rule_utility_pkg.getAttributeName(p_attribute_id => l_attribute_id

1723: if getAttributeUsages%notfound then
1724: open getApplicationName(applicationIdIn => l_application_id);
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);

Line 2007: ame_rule_utility_pkg.chekActionForAllApplications(ruleIdIn => p_rule_id

2003: end if;
2004: --+
2005: --+ Checks to be done for all transaction types using this rule
2006: --+
2007: ame_rule_utility_pkg.chekActionForAllApplications(ruleIdIn => p_rule_id
2008: ,actionIdIn => p_action_id);
2009: --+
2010: -- Fetch conditions and actions for rule
2011: l_swi_call := true;

Line 2017: ame_rule_utility_pkg.checkRuleId(p_rule_id => p_rule_id);

2013: --+
2014: --+ Check Rule Id.
2015: --+
2016: l_swi_call := false;
2017: ame_rule_utility_pkg.checkRuleId(p_rule_id => p_rule_id);
2018: --+
2019: --+ Check Action Id.
2020: --+
2021: ame_rule_utility_pkg.checkActionId(p_action_id => p_action_id);

Line 2021: ame_rule_utility_pkg.checkActionId(p_action_id => p_action_id);

2017: ame_rule_utility_pkg.checkRuleId(p_rule_id => p_rule_id);
2018: --+
2019: --+ Check Action Id.
2020: --+
2021: ame_rule_utility_pkg.checkActionId(p_action_id => p_action_id);
2022: --+
2023: --+ Get all the transaction types using this rule.
2024: --+
2025: open getApplicationIds(p_rule_id => p_rule_id);

Line 2032: l_result := ame_rule_utility_pkg.is_action_allowed(p_application_id => appIdList(i)

2028: --+
2029: --+ Check if this action is valid for all these transaction types.
2030: --+
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');

Line 2034: if l_result = ame_rule_utility_pkg.ActionNotAllowed then

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

Line 2037: elsif l_result = ame_rule_utility_pkg.GroupNotAllowed then

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
2041: fnd_message.set_name('PER','AME_400770_POS_APR_NOT_IN_APP');

Line 2040: elsif l_result = ame_rule_utility_pkg.PosActionNotAllowed then

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;
2044: --+

Line 2047: if not ame_rule_utility_pkg.chk_rule_type(p_rule_id => p_rule_id

2043: end if;
2044: --+
2045: --+ Check the Rule Type and action combination.
2046: --+
2047: if not ame_rule_utility_pkg.chk_rule_type(p_rule_id => p_rule_id
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

Line 2056: if not ame_rule_utility_pkg.chk_lm_actions(p_rule_id => p_rule_id

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
2058: fnd_message.set_name('PER','AME_400425_RULE_LM_RULE');
2059: hr_multi_message.add(p_associated_column1 => 'ACTION_ID');
2060: end if;

Line 2254: ame_rule_utility_pkg.checkRuleId(p_rule_id => p_rule_id);

2250:
2251: l_effective_date := sysdate;
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');

Line 2509: ame_rule_utility_pkg.checkRuleId(p_rule_id => p_rule_id);

2505: end if;
2506: --+
2507: --+ Check the Rule Id.
2508: --+
2509: ame_rule_utility_pkg.checkRuleId(p_rule_id => p_rule_id);
2510: --+
2511: --+ Check the Application Id.
2512: --+
2513: ame_rule_utility_pkg.checkApplicationId(p_application_id => p_application_id);

Line 2513: ame_rule_utility_pkg.checkApplicationId(p_application_id => p_application_id);

2509: ame_rule_utility_pkg.checkRuleId(p_rule_id => p_rule_id);
2510: --+
2511: --+ Check the Application Id.
2512: --+
2513: ame_rule_utility_pkg.checkApplicationId(p_application_id => p_application_id);
2514: --
2515: -- Check that there is no overlapping rule usage existing for the rule_id.
2516: -- Gaps between the rule usage dates is allowed.
2517: --

Line 2612: ame_rule_utility_pkg.syncRuleObjects(p_rule_id => p_rule_id);

2608: end if;
2609: end if;*/
2610: --+
2611: if (instrb(DBMS_UTILITY.FORMAT_CALL_STACK,l_swi_package_name||fnd_global.local_chr(ascii_chr => 10)) = 0) then
2612: ame_rule_utility_pkg.syncRuleObjects(p_rule_id => p_rule_id);
2613: end if;
2614: --
2615: -- Call After Process User Hook
2616: --

Line 2816: ame_rule_utility_pkg.checkRuleId(p_rule_id => p_rule_id);

2812: end;
2813: --+
2814: --+ Check Rule Id.
2815: --+
2816: ame_rule_utility_pkg.checkRuleId(p_rule_id => p_rule_id);
2817: --+
2818: --+ Check Application Id.
2819: --+
2820: ame_rule_utility_pkg.checkApplicationId(p_application_id => p_application_id);

Line 2820: ame_rule_utility_pkg.checkApplicationId(p_application_id => p_application_id);

2816: ame_rule_utility_pkg.checkRuleId(p_rule_id => p_rule_id);
2817: --+
2818: --+ Check Application Id.
2819: --+
2820: ame_rule_utility_pkg.checkApplicationId(p_application_id => p_application_id);
2821: --
2822: -- Process Logic
2823: --
2824: -- Set the effective date to the sysdate

Line 2922: ame_rule_utility_pkg.syncRuleObjects(p_rule_id => p_rule_id);

2918: ,p_end_date => l_rul_end_date
2919: );
2920: else
2921: if (instrb(DBMS_UTILITY.FORMAT_CALL_STACK,l_swi_package_name||fnd_global.local_chr(ascii_chr => 10)) = 0) then
2922: ame_rule_utility_pkg.syncRuleObjects(p_rule_id => p_rule_id);
2923: end if;
2924: --+
2925: end if;
2926: --end if;

Line 3137: ame_rule_utility_pkg.checkRuleId(p_rule_id => p_rule_id);

3133: -- or Substitution type condition other than this one should exist in the rule
3134: --+
3135: --+ Check Rule Id.
3136: --+
3137: ame_rule_utility_pkg.checkRuleId(p_rule_id => p_rule_id);
3138: --+
3139: --+ Check Condition Id.
3140: --+
3141: ame_rule_utility_pkg.checkConditionId(p_condition_id => p_condition_id);

Line 3141: ame_rule_utility_pkg.checkConditionId(p_condition_id => p_condition_id);

3137: ame_rule_utility_pkg.checkRuleId(p_rule_id => p_rule_id);
3138: --+
3139: --+ Check Condition Id.
3140: --+
3141: ame_rule_utility_pkg.checkConditionId(p_condition_id => p_condition_id);
3142: --
3143: --
3144: -- Fetch the rule details
3145: --

Line 3157: if not ame_rule_utility_pkg.is_cond_exist_in_rule(p_rule_id => p_rule_id

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;

Line 3260: ame_rule_utility_pkg.getAttributeName(p_attribute_id => l_attribute_id

3256: if getAttributeUsages%notfound then
3257: open getApplicationName(applicationIdIn => tempApplications.item_id);
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);

Line 3470: ame_rule_utility_pkg.checkRuleId(p_rule_id => p_rule_id);

3466: --+
3467: --+ Fetch conditions and actions for rule
3468: if not l_swi_call then
3469: --+ verify the rule_id
3470: ame_rule_utility_pkg.checkRuleId(p_rule_id => p_rule_id);
3471: --+ verify the action_id
3472: ame_rule_utility_pkg.checkActionId(p_action_id => p_action_id);
3473: --+
3474: --+ Check that there is atleast one other action defined for this rule, besides this one.

Line 3472: ame_rule_utility_pkg.checkActionId(p_action_id => p_action_id);

3468: if not l_swi_call then
3469: --+ verify the rule_id
3470: ame_rule_utility_pkg.checkRuleId(p_rule_id => p_rule_id);
3471: --+ verify the action_id
3472: ame_rule_utility_pkg.checkActionId(p_action_id => p_action_id);
3473: --+
3474: --+ Check that there is atleast one other action defined for this rule, besides this one.
3475: --+
3476: open getActionCount;

Line 3486: if not ame_rule_utility_pkg.is_action_deletion_allowed

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

Line 3708: ame_rule_utility_pkg.checkRuleId(p_rule_id => p_rule_id);

3704: l_effective_date := sysdate;
3705: --+
3706: --+ Check Rule Id.
3707: --+
3708: ame_rule_utility_pkg.checkRuleId(p_rule_id => p_rule_id);
3709: --+
3710: --+ Check Condition Id.
3711: --+
3712: ame_rule_utility_pkg.checkConditionId(p_condition_id => p_condition_id);

Line 3712: ame_rule_utility_pkg.checkConditionId(p_condition_id => p_condition_id);

3708: ame_rule_utility_pkg.checkRuleId(p_rule_id => p_rule_id);
3709: --+
3710: --+ Check Condition Id.
3711: --+
3712: ame_rule_utility_pkg.checkConditionId(p_condition_id => p_condition_id);
3713: --
3714: -- Fetch the condition details
3715: --
3716: open getConditionDetails;

Line 3749: if (l_rule_type = ame_util.combinationRuleType and not ame_rule_utility_pkg.is_LM_comb_rule(p_rule_id)) then

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

Line 3787: if not ame_rule_utility_pkg.is_condition_allowed(p_application_id => appIdList(i)

3783: open getApplicationIds(p_rule_id => p_rule_id);
3784: fetch getApplicationIds
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;

Line 3799: ame_rule_utility_pkg.chk_LM_action_Condition(p_condition_id => p_condition_id

3795: --+
3796: getActionIds(ruleIdIn => p_rule_id
3797: ,actionIdListOut => l_action_id_list);
3798: for i in 1..l_action_id_list.count loop
3799: ame_rule_utility_pkg.chk_LM_action_Condition(p_condition_id => p_condition_id
3800: ,p_action_id => l_action_id_list(i)
3801: ,is_first_condition => true);
3802: end loop;
3803: --+