DBA Data[Home] [Help]

APPS.AME_RULE_UTILITY_PKG dependencies on HR_MULTI_MESSAGE

Line 314: hr_multi_message.enable_message_list;

310: begin
311: errorExists := false;
312: endDate := endDateIn;
313: resultOut := 'Y';
314: hr_multi_message.enable_message_list;
315: --+
316: --+ get application name
317: --+
318: open getApplicationName(applicationIdIn => applicationIdIn);

Line 334: hr_multi_message.add (p_associated_column1 => 'RULE_ID');

330: fetch getItemClass into dummy;
331: if(getItemClass%found) then
332: fnd_message.set_name('PER','AME_400633_SUBITC_TTY_NO_USAGE');
333: fnd_message.set_token('TXTYPENAME',applicationName);
334: hr_multi_message.add (p_associated_column1 => 'RULE_ID');
335: close getItemClass;
336: resultOut := 'N';
337: fnd_message.raise_error;
338: return;

Line 355: hr_multi_message.add (p_associated_column1 => 'RULE_ID');

351: fetch checkLMConditions into dummy;
352: if(checkLMConditions%found) then
353: fnd_message.set_name('PER','AME_400641_TTY_INV_APPR_TYPE');
354: fnd_message.set_token('TXTYPENAME',applicationName);
355: hr_multi_message.add (p_associated_column1 => 'RULE_ID');
356: close checkLMConditions;
357: resultOut := 'N';
358: fnd_message.raise_error;
359: return;

Line 374: hr_multi_message.add (p_associated_column1 => 'RULE_ID');

370: if(tempValue <> ame_util.allProductions) then
371: if(tempValue <> ame_util.perTransactionProductions and isProdRule(ruleIdIn)) then
372: fnd_message.set_name('PER','AME_400639_TTY_NO_PROD_RULES');
373: fnd_message.set_token('TXTYPENAME',applicationName);
374: hr_multi_message.add (p_associated_column1 => 'RULE_ID');
375: resultOut := 'N';
376: fnd_message.raise_error;
377: return;
378: elsif(tempValue <> ame_util.perApproverProductions and hasProductionActions(ruleIdIn,endDate) and not isProdRule(ruleIdIn)) then

Line 381: hr_multi_message.add (p_associated_column1 => 'RULE_ID');

377: return;
378: elsif(tempValue <> ame_util.perApproverProductions and hasProductionActions(ruleIdIn,endDate) and not isProdRule(ruleIdIn)) then
379: fnd_message.set_name('PER','AME_400640_TTY_NO_PROD_ACTIONS');
380: fnd_message.set_token('TXTYPENAME',applicationName);
381: hr_multi_message.add (p_associated_column1 => 'RULE_ID');
382: resultOut := 'N';
383: fnd_message.raise_error;
384: return;
385: end if;

Line 398: hr_multi_message.add (p_associated_column1 => 'RULE_ID');

394: if(checkItemClass%found)then
395: fnd_message.set_name('PER','AME_400632_ITC_TTY_NO_USAGE');
396: fnd_message.set_token('ITEM_CLASS',itemClassName);
397: fnd_message.set_token('TXTYPENAME',applicationName);
398: hr_multi_message.add (p_associated_column1 => 'RULE_ID');
399: errorExists := true;
400: end if;
401: close checkItemClass;
402: --+

Line 419: hr_multi_message.add (p_associated_column1 => 'RULE_ID');

415: for i in 1 .. attributeIdList.count loop
416: fnd_message.set_name('PER','AME_400149_ATT_TTY_NO_USAGE');
417: fnd_message.set_token('ATTRIBUTE',attributeNamesList(i));
418: fnd_message.set_token('APPLICATION',applicationName);
419: hr_multi_message.add (p_associated_column1 => 'RULE_ID');
420: end loop;
421: --+
422: --+ check for action types
423: --+

Line 438: hr_multi_message.add (p_associated_column1 => 'RULE_ID');

434: for i in 1 .. actionTypeIdList.count loop
435: fnd_message.set_name('PER','AME_400634_ATY_TTY_NO_USAGE');
436: fnd_message.set_token('ACTION_TYPE',actionTypeNameList(i));
437: fnd_message.set_token('TXTYPENAME',applicationName);
438: hr_multi_message.add (p_associated_column1 => 'RULE_ID');
439: end loop;
440: --+
441: --+ check for approval groups
442: --+

Line 458: hr_multi_message.add (p_associated_column1 => 'RULE_ID');

454: for i in 1 .. actionTypeIdList.count loop
455: fnd_message.set_name('PER','AME_400643_APG_TTY_NO_USAGE');
456: fnd_message.set_token('GROUP',actionTypeNameList(i));
457: fnd_message.set_token('TXTYPENAME',applicationName);
458: hr_multi_message.add (p_associated_column1 => 'RULE_ID');
459: end loop;
460: --+
461: if errorExists then
462: resultOut := 'N';

Line 700: hr_multi_message.enable_message_list;

696: return;
697: end if;
698: --+
699: resultOut := 'Y';
700: hr_multi_message.enable_message_list;
701: --+
702: --+ get application name
703: --+
704: open getApplicationName(applicationIdIn => applicationIdIn);

Line 719: hr_multi_message.add (p_associated_column1 => 'RULE_ID');

715: fetch getItemClass into dummy;
716: if(getItemClass%found) then
717: fnd_message.set_name('PER','AME_400633_SUBITC_TTY_NO_USAGE');
718: fnd_message.set_token('TXTYPENAME',applicationName);
719: hr_multi_message.add (p_associated_column1 => 'RULE_ID');
720: close getItemClass;
721: resultOut := 'N';
722: fnd_message.raise_error;
723: return;

Line 739: hr_multi_message.add (p_associated_column1 => 'RULE_ID');

735: fetch checkLMConditions into dummy;
736: if(checkLMConditions%found) then
737: fnd_message.set_name('PER','AME_400641_TTY_INV_APPR_TYPE');
738: fnd_message.set_token('TXTYPENAME',applicationName);
739: hr_multi_message.add (p_associated_column1 => 'RULE_ID');
740: close getItemClass;
741: resultOut := 'N';
742: fnd_message.raise_error;
743: return;

Line 757: hr_multi_message.add (p_associated_column1 => 'RULE_ID');

753: if(tempValue <> ame_util.allProductions) then
754: if(tempValue <> ame_util.perTransactionProductions and isProdRule(ruleIdIn)) then
755: fnd_message.set_name('PER','AME_400639_TTY_NO_PROD_RULES');
756: fnd_message.set_token('TXTYPENAME',applicationName);
757: hr_multi_message.add (p_associated_column1 => 'RULE_ID');
758: resultOut := 'N';
759: fnd_message.raise_error;
760: return;
761: elsif(tempValue <> ame_util.perApproverProductions and hasProductionActions(ruleIdIn,endDate) and not isProdRule(ruleIdIn)) then

Line 764: hr_multi_message.add (p_associated_column1 => 'RULE_ID');

760: return;
761: elsif(tempValue <> ame_util.perApproverProductions and hasProductionActions(ruleIdIn,endDate) and not isProdRule(ruleIdIn)) then
762: fnd_message.set_name('PER','AME_400640_TTY_NO_PROD_ACTIONS');
763: fnd_message.set_token('TXTYPENAME',applicationName);
764: hr_multi_message.add (p_associated_column1 => 'RULE_ID');
765: resultOut := 'N';
766: fnd_message.raise_error;
767: return;
768: end if;

Line 781: hr_multi_message.add (p_associated_column1 => 'RULE_ID');

777: if(checkItemClass%found)then
778: fnd_message.set_name('PER','AME_400632_ITC_TTY_NO_USAGE');
779: fnd_message.set_token('ITEM_CLASS',itemClassName);
780: fnd_message.set_token('TXTYPENAME',applicationName);
781: hr_multi_message.add (p_associated_column1 => 'RULE_ID');
782: errorExists := true;
783: end if;
784: close checkItemClass;
785: --+

Line 801: hr_multi_message.add (p_associated_column1 => 'RULE_ID');

797: for i in 1 .. attributeIdList.count loop
798: fnd_message.set_name('PER','AME_400149_ATT_TTY_NO_USAGE');
799: fnd_message.set_token('ATTRIBUTE',attributeNamesList(i));
800: fnd_message.set_token('APPLICATION',applicationName);
801: hr_multi_message.add (p_associated_column1 => 'RULE_ID');
802: end loop;
803: --+
804: --+ check for action types
805: --+

Line 819: hr_multi_message.add (p_associated_column1 => 'RULE_ID');

815: for i in 1 .. actionTypeIdList.count loop
816: fnd_message.set_name('PER','AME_400634_ATY_TTY_NO_USAGE');
817: fnd_message.set_token('ACTION_TYPE',actionTypeNameList(i));
818: fnd_message.set_token('TXTYPENAME',applicationName);
819: hr_multi_message.add (p_associated_column1 => 'RULE_ID');
820: end loop;
821: --+
822: --+ check for approval groups
823: --+

Line 838: hr_multi_message.add (p_associated_column1 => 'RULE_ID');

834: for i in 1 .. actionTypeIdList.count loop
835: fnd_message.set_name('PER','AME_400643_APG_TTY_NO_USAGE');
836: fnd_message.set_token('GROUP',actionTypeNameList(i));
837: fnd_message.set_token('TXTYPENAME',applicationName);
838: hr_multi_message.add (p_associated_column1 => 'RULE_ID');
839: end loop;
840: --+
841: if errorExists then
842: resultOut := 'N';

Line 1161: hr_multi_message.add (p_associated_column1 => 'CONDITION_ID');

1157: for i in 1 .. attributeIdList.count loop
1158: fnd_message.set_name('PER','AME_400149_ATT_TTY_NO_USAGE');
1159: fnd_message.set_token('ATTRIBUTE',attributeNameList(i));
1160: fnd_message.set_token('APPLICATION',rec.application_name);
1161: hr_multi_message.add (p_associated_column1 => 'CONDITION_ID');
1162: errorExists := true;
1163: end loop;
1164: close getInvalidAttributes;
1165: end loop;

Line 1177: hr_multi_message.add (p_associated_column1 => 'RULE_ID');

1173: fetch checkLMCondition into dummy;
1174: if(checkLMCondition%found) then
1175: fnd_message.set_name('PER','AME_400641_TTY_INV_APPR_TYPE');
1176: fnd_message.set_token('TXTYPENAME',rec.application_name);
1177: hr_multi_message.add (p_associated_column1 => 'RULE_ID');
1178: end if;
1179: close checkLMCondition;
1180: end if;
1181: end loop;

Line 1276: hr_multi_message.add (p_associated_column1 => 'CONDITION_ID');

1272: for i in 1 .. actionTypeIdList.count loop
1273: fnd_message.set_name('PER','AME_400634_ATY_TTY_NO_USAGE');
1274: fnd_message.set_token('ACTION_TYPE',actionTypeNameList(i));
1275: fnd_message.set_token('TXTYPENAME',rec.application_name);
1276: hr_multi_message.add (p_associated_column1 => 'CONDITION_ID');
1277: errorExists := true;
1278: end loop;
1279: close getInvalidActionTypes;
1280: end loop;

Line 1295: hr_multi_message.add (p_associated_column1 => 'ACTION_ID');

1291: for i in 1 .. attributeIdList.count loop
1292: fnd_message.set_name('PER','AME_400149_ATT_TTY_NO_USAGE');
1293: fnd_message.set_token('ATTRIBUTE',attributeNameList(i));
1294: fnd_message.set_token('APPLICATION',rec.application_name);
1295: hr_multi_message.add (p_associated_column1 => 'ACTION_ID');
1296: errorExists := true;
1297: end loop;
1298: close getInvalidRequiredAttributes;
1299: end loop;

Line 1312: hr_multi_message.add (p_associated_column1 => 'RULE_ID');

1308: ,applicationIdIn => rec.application_id);
1309: if(tempValue = ame_util.noProductions and isProductionAction(actionIdIn)) then
1310: fnd_message.set_name('PER','AME_400640_TTY_NO_PROD_ACTIONS');
1311: fnd_message.set_token('TXTYPENAME',rec.application_name);
1312: hr_multi_message.add (p_associated_column1 => 'RULE_ID');
1313: end if;
1314: end loop;
1315: --+
1316: for rec in getApplications loop

Line 1327: hr_multi_message.add (p_associated_column1 => 'CONDITION_ID');

1323: for i in 1 .. actionTypeIdList.count loop
1324: fnd_message.set_name('PER','AME_400643_APG_TTY_NO_USAGE');
1325: fnd_message.set_token('GROUP',actionTypeNameList(i));
1326: fnd_message.set_token('TXTYPENAME',rec.application_name);
1327: hr_multi_message.add (p_associated_column1 => 'CONDITION_ID');
1328: errorExists := true;
1329: end loop;
1330: close getInvalidGroups;
1331: end loop;

Line 1538: hr_multi_message.add (p_associated_column1 => 'RULE_ID');

1534: --+
1535: close checkRule;
1536: if l_count = 0 then
1537: fnd_message.set_name('PER','AME_400729_INV_RULE_ID');
1538: hr_multi_message.add (p_associated_column1 => 'RULE_ID');
1539: end if;
1540: end checkRuleId;
1541: --+
1542: --+ validates the action id.

Line 1562: hr_multi_message.add (p_associated_column1 => 'ACTION_ID');

1558: into l_count;
1559: close checkAction;
1560: if l_count = 0 then
1561: fnd_message.set_name('PER','AME_400736_INV_ACTION_ID');
1562: hr_multi_message.add (p_associated_column1 => 'ACTION_ID');
1563: end if;
1564: end checkActionId;
1565: --+
1566: --+ validates the condition id.

Line 1586: hr_multi_message.add (p_associated_column1 => 'CONDITION_ID');

1582: into l_count;
1583: close checkCondition;
1584: if l_count = 0 then
1585: fnd_message.set_name('PER','AME_400737_INV_COND_ID');
1586: hr_multi_message.add (p_associated_column1 => 'CONDITION_ID');
1587: end if;
1588: end checkConditionId;
1589: --+
1590: --+ Validates the Application Id

Line 1610: hr_multi_message.add (p_associated_column1 => 'ITEM_ID');

1606: into l_count;
1607: close checkApplication;
1608: if l_count = 0 then
1609: fnd_message.set_name('PER','AME_400732_INV_APPLICATION_ID');
1610: hr_multi_message.add (p_associated_column1 => 'ITEM_ID');
1611: end if;
1612: end checkApplicationId;
1613: --+
1614: --+ Invoked from create_ame_rule

Line 2130: hr_multi_message.add(p_associated_column1 => 'ACTION_ID');

2126: close getActionType;
2127: --+
2128: if l_param = 'any_approver' and l_action_type = 'nonfinal authority' then
2129: fnd_message.set_name('PER','AME_400702_INV_LM_ATY_COMB_1');
2130: hr_multi_message.add(p_associated_column1 => 'ACTION_ID');
2131: elsif l_param = 'final_approver' and l_action_type = 'final authority' then
2132: fnd_message.set_name('PER','AME_400703_INV_LM_ATY_COMB_2');
2133: hr_multi_message.add(p_associated_column1 => 'ACTION_ID');
2134: end if;

Line 2133: hr_multi_message.add(p_associated_column1 => 'ACTION_ID');

2129: fnd_message.set_name('PER','AME_400702_INV_LM_ATY_COMB_1');
2130: hr_multi_message.add(p_associated_column1 => 'ACTION_ID');
2131: elsif l_param = 'final_approver' and l_action_type = 'final authority' then
2132: fnd_message.set_name('PER','AME_400703_INV_LM_ATY_COMB_2');
2133: hr_multi_message.add(p_associated_column1 => 'ACTION_ID');
2134: end if;
2135: --+
2136: if l_param = 'final_approver' and not is_per_approver(p_name => l_param_two) and is_first_condition then
2137: fnd_message.set_name('PER','AME_400703_INV_LM_ATY_COMB_2');

Line 2138: hr_multi_message.add (p_associated_column1 => 'RULE_ID');

2134: end if;
2135: --+
2136: if l_param = 'final_approver' and not is_per_approver(p_name => l_param_two) and is_first_condition then
2137: fnd_message.set_name('PER','AME_400703_INV_LM_ATY_COMB_2');
2138: hr_multi_message.add (p_associated_column1 => 'RULE_ID');
2139: end if;
2140: end chk_LM_action_Condition;
2141: --+
2142: --+ used in is_action_allowed

Line 2325: hr_multi_message.add(p_associated_column1 => 'ITEM_CLASS_ID');

2321: bulk collect into l_sub_ic_cond_list;
2322: if l_sub_ic_cond_list.count <> 0 then
2323: if l_sub_ic_cond_list(1) <> l_con_item_class_id then
2324: fnd_message.set_name('PER','AME_400695_RULE_SUB_ITC_COND');
2325: hr_multi_message.add(p_associated_column1 => 'ITEM_CLASS_ID');
2326: end if;
2327: end if;
2328: close get_sub_ic_cond;
2329: else

Line 2332: hr_multi_message.add(p_associated_column1 => 'ITEM_CLASS_ID');

2328: close get_sub_ic_cond;
2329: else
2330: if l_con_item_class_id <> l_item_class_id then
2331: fnd_message.set_name('PER','AME_400708_NH_RULE_SUB_ITC_CON');
2332: hr_multi_message.add(p_associated_column1 => 'ITEM_CLASS_ID');
2333: end if;
2334: end if;
2335: --+
2336: end chk_rule_and_item_class;