DBA Data[Home] [Help]

APPS.AME_RULE_UTILITY_PKG dependencies on FND_MESSAGE

Line 332: fnd_message.set_name('PER','AME_400633_SUBITC_TTY_NO_USAGE');

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

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

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;

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

Line 353: fnd_message.set_name('PER','AME_400641_TTY_INV_APPR_TYPE');

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

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

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;

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

Line 372: fnd_message.set_name('PER','AME_400639_TTY_NO_PROD_RULES');

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;

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

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;

Line 376: fnd_message.raise_error;

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

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

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;

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

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;

Line 383: fnd_message.raise_error;

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

Line 395: fnd_message.set_name('PER','AME_400632_ITC_TTY_NO_USAGE');

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;

Line 396: fnd_message.set_token('ITEM_CLASS',itemClassName);

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;

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

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;

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

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;

Line 417: fnd_message.set_token('ATTRIBUTE',attributeNamesList(i));

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

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

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

Line 435: fnd_message.set_name('PER','AME_400634_ATY_TTY_NO_USAGE');

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;

Line 436: fnd_message.set_token('ACTION_TYPE',actionTypeNameList(i));

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

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

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

Line 455: fnd_message.set_name('PER','AME_400643_APG_TTY_NO_USAGE');

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;

Line 456: fnd_message.set_token('GROUP',actionTypeNameList(i));

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

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

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

Line 463: fnd_message.raise_error;

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;

Line 717: fnd_message.set_name('PER','AME_400633_SUBITC_TTY_NO_USAGE');

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

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

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;

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

Line 737: fnd_message.set_name('PER','AME_400641_TTY_INV_APPR_TYPE');

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

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

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;

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

Line 755: fnd_message.set_name('PER','AME_400639_TTY_NO_PROD_RULES');

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;

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

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;

Line 759: fnd_message.raise_error;

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

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

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;

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

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;

Line 766: fnd_message.raise_error;

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;

Line 778: fnd_message.set_name('PER','AME_400632_ITC_TTY_NO_USAGE');

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;

Line 779: fnd_message.set_token('ITEM_CLASS',itemClassName);

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;

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

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;

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

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;

Line 799: fnd_message.set_token('ATTRIBUTE',attributeNamesList(i));

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

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

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

Line 816: fnd_message.set_name('PER','AME_400634_ATY_TTY_NO_USAGE');

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;

Line 817: fnd_message.set_token('ACTION_TYPE',actionTypeNameList(i));

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

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

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

Line 835: fnd_message.set_name('PER','AME_400643_APG_TTY_NO_USAGE');

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;

Line 836: fnd_message.set_token('GROUP',actionTypeNameList(i));

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

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

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

Line 843: fnd_message.raise_error;

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;

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

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;

Line 1159: fnd_message.set_token('ATTRIBUTE',attributeNameList(i));

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;

Line 1160: fnd_message.set_token('APPLICATION',rec.application_name);

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;

Line 1175: fnd_message.set_name('PER','AME_400641_TTY_INV_APPR_TYPE');

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;

Line 1176: fnd_message.set_token('TXTYPENAME',rec.application_name);

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;

Line 1273: fnd_message.set_name('PER','AME_400634_ATY_TTY_NO_USAGE');

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;

Line 1274: fnd_message.set_token('ACTION_TYPE',actionTypeNameList(i));

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;

Line 1275: fnd_message.set_token('TXTYPENAME',rec.application_name);

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;

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

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;

Line 1293: fnd_message.set_token('ATTRIBUTE',attributeNameList(i));

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;

Line 1294: fnd_message.set_token('APPLICATION',rec.application_name);

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;

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

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;

Line 1311: fnd_message.set_token('TXTYPENAME',rec.application_name);

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

Line 1324: fnd_message.set_name('PER','AME_400643_APG_TTY_NO_USAGE');

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;

Line 1325: fnd_message.set_token('GROUP',actionTypeNameList(i));

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;

Line 1326: fnd_message.set_token('TXTYPENAME',rec.application_name);

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;

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

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

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

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

Line 1585: fnd_message.set_name('PER','AME_400737_INV_COND_ID');

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

Line 1609: fnd_message.set_name('PER','AME_400732_INV_APPLICATION_ID');

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

Line 2129: fnd_message.set_name('PER','AME_400702_INV_LM_ATY_COMB_1');

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

Line 2132: fnd_message.set_name('PER','AME_400703_INV_LM_ATY_COMB_2');

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

Line 2137: 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');
2138: hr_multi_message.add (p_associated_column1 => 'RULE_ID');
2139: end if;
2140: end chk_LM_action_Condition;
2141: --+

Line 2324: fnd_message.set_name('PER','AME_400695_RULE_SUB_ITC_COND');

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;

Line 2331: fnd_message.set_name('PER','AME_400708_NH_RULE_SUB_ITC_CON');

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