328: open getItemClass(ruleIdIn => ruleIdIn
329: ,endDateIn => endDate);
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';
329: ,endDateIn => endDate);
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;
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;
339: end if;
340: close getItemClass;
341: end if;
349: open checkLMConditions(ruleIdIn => ruleIdIn
350: ,endDateIn => endDate);
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';
350: ,endDateIn => endDate);
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;
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;
360: end if;
361: close checkLMConditions;
362: end if;
368: ,applicationIdIn => applicationIdIn);
369:
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;
369:
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;
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
379: fnd_message.set_name('PER','AME_400640_TTY_NO_PROD_ACTIONS');
380: fnd_message.set_token('TXTYPENAME',applicationName);
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
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;
376: fnd_message.raise_error;
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;
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;
386: end if;
387: --+
391: ,applicationIdIn => applicationIdIn
392: ,endDateIn => endDate);
393: fetch checkItemClass into itemClassName;
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;
392: ,endDateIn => endDate);
393: fetch checkItemClass into itemClassName;
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;
393: fetch checkItemClass into itemClassName;
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;
412: if attributeIdList.count > 0 then
413: errorExists := true;
414: end if;
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;
413: errorExists := true;
414: end if;
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: --+
414: end if;
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
431: if actionTypeIdList.count > 0 then
432: errorExists := true;
433: end if;
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;
432: errorExists := true;
433: end if;
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: --+
433: end if;
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
451: if actionTypeIdList.count > 0 then
452: errorExists := true;
453: end if;
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;
452: errorExists := true;
453: end if;
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: --+
453: end if;
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
459: end loop;
460: --+
461: if errorExists then
462: resultOut := 'N';
463: fnd_message.raise_error;
464: end if;
465: exception
466: when others then
467: null;
713: if(tempValue = ame_util.no) then
714: open getItemClass(ruleIdIn => ruleIdIn);
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';
714: open getItemClass(ruleIdIn => ruleIdIn);
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;
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;
724: end if;
725: close getItemClass;
726: end if;
733: if(tempValue = ame_util.no) then
734: open checkLMConditions(ruleIdIn => ruleIdIn);
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';
734: open checkLMConditions(ruleIdIn => ruleIdIn);
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;
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;
744: end if;
745: close checkLMConditions;
746: end if;
751: (variableNameIn => ame_util.productionConfigVar
752: ,applicationIdIn => applicationIdIn);
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;
752: ,applicationIdIn => applicationIdIn);
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;
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
762: fnd_message.set_name('PER','AME_400640_TTY_NO_PROD_ACTIONS');
763: fnd_message.set_token('TXTYPENAME',applicationName);
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
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;
759: fnd_message.raise_error;
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;
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;
769:
770: end if;
774: open checkItemClass(ruleIdIn => ruleIdIn
775: ,applicationIdIn => applicationIdIn);
776: fetch checkItemClass into itemClassName;
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;
775: ,applicationIdIn => applicationIdIn);
776: fetch checkItemClass into itemClassName;
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;
776: fetch checkItemClass into itemClassName;
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;
794: if attributeIdList.count > 0 then
795: errorExists := true;
796: end if;
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;
795: errorExists := true;
796: end if;
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: --+
796: end if;
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
812: if actionTypeIdList.count > 0 then
813: errorExists := true;
814: end if;
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;
813: errorExists := true;
814: end if;
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: --+
814: end if;
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
831: if actionTypeIdList.count > 0 then
832: errorExists := true;
833: end if;
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;
832: errorExists := true;
833: end if;
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: --+
833: end if;
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
839: end loop;
840: --+
841: if errorExists then
842: resultOut := 'N';
843: fnd_message.raise_error;
844: end if;
845: exception
846: when others then
847: null;
1154: open getInvalidAttributes(applicationIdIn => rec.application_id
1155: ,conditionIdIn => conditionIdIn);
1156: fetch getInvalidAttributes bulk collect into attributeIdList, attributeNameList;
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;
1155: ,conditionIdIn => conditionIdIn);
1156: fetch getInvalidAttributes bulk collect into attributeIdList, attributeNameList;
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;
1156: fetch getInvalidAttributes bulk collect into attributeIdList, attributeNameList;
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;
1171: if(tempValue = ame_util.no) then
1172: open checkLMCondition(conditionIdIn => conditionIdIn);
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;
1172: open checkLMCondition(conditionIdIn => conditionIdIn);
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;
1269: open getInvalidActionTypes(applicationIdIn => rec.application_id
1270: ,actionIdIn => actionIdIn);
1271: fetch getInvalidActionTypes bulk collect into actionTypeIdList, actionTypeNameList;
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;
1270: ,actionIdIn => actionIdIn);
1271: fetch getInvalidActionTypes bulk collect into actionTypeIdList, actionTypeNameList;
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;
1271: fetch getInvalidActionTypes bulk collect into actionTypeIdList, actionTypeNameList;
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;
1288: open getInvalidRequiredAttributes(applicationIdIn => rec.application_id
1289: ,actionIdIn => actionIdIn);
1290: fetch getInvalidRequiredAttributes bulk collect into attributeIdList, attributeNameList;
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;
1289: ,actionIdIn => actionIdIn);
1290: fetch getInvalidRequiredAttributes bulk collect into attributeIdList, attributeNameList;
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;
1290: fetch getInvalidRequiredAttributes bulk collect into attributeIdList, attributeNameList;
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;
1306: tempValue := ame_util.getConfigVar
1307: (variableNameIn => ame_util.productionConfigVar
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;
1307: (variableNameIn => ame_util.productionConfigVar
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: --+
1320: open getInvalidGroups(applicationIdIn => rec.application_id
1321: ,actionIdIn => actionIdIn);
1322: fetch getInvalidGroups bulk collect into actionTypeIdList, actionTypeNameList;
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;
1321: ,actionIdIn => actionIdIn);
1322: fetch getInvalidGroups bulk collect into actionTypeIdList, actionTypeNameList;
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;
1322: fetch getInvalidGroups bulk collect into actionTypeIdList, actionTypeNameList;
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;
1533: into l_count;
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: --+
1557: fetch checkAction
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: --+
1581: fetch checkCondition
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: --+
1605: fetch checkApplication
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: --+
2125: into l_action_type;
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');
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;
2135: --+
2136: if l_param = 'final_approver' and not is_per_approver(p_name => l_param_two) and is_first_condition then
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');
2138: hr_multi_message.add (p_associated_column1 => 'RULE_ID');
2139: end if;
2140: end chk_LM_action_Condition;
2141: --+
2320: fetch get_sub_ic_cond
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;
2327: end if;
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: --+