433: ,approverTypeIdIn in number default null) is
434: itemClassName varchar2(100);
435: begin
436: if attributeItemTypeIn = 'MANDATORY_ATTR' then
437: fnd_message.set_name('PER','AME_400824_INV_MAND_ATTR_USG');
438: fnd_message.set_token('ATTRIBUTE_NAME',attributeNameIn);
439: hr_multi_message.add (p_associated_column1 => 'ATTR_NAME'
440: , p_message_type => hr_multi_message.g_warning_msg);
441: elsif attributeItemTypeIn = 'HEADER_ATTR' then
434: itemClassName varchar2(100);
435: begin
436: if attributeItemTypeIn = 'MANDATORY_ATTR' then
437: fnd_message.set_name('PER','AME_400824_INV_MAND_ATTR_USG');
438: fnd_message.set_token('ATTRIBUTE_NAME',attributeNameIn);
439: hr_multi_message.add (p_associated_column1 => 'ATTR_NAME'
440: , p_message_type => hr_multi_message.g_warning_msg);
441: elsif attributeItemTypeIn = 'HEADER_ATTR' then
442: if approverTypeIdIn is not null then
439: hr_multi_message.add (p_associated_column1 => 'ATTR_NAME'
440: , p_message_type => hr_multi_message.g_warning_msg);
441: elsif attributeItemTypeIn = 'HEADER_ATTR' then
442: if approverTypeIdIn is not null then
443: fnd_message.set_name('PER','AME_400821_INVAL_APR_ATTR_USG');
444: fnd_message.set_token('ATTRIBUTE_NAME',attributeNameIn);
445: hr_multi_message.add (p_associated_column1 => 'ATTR_NAME');
446: else
447: fnd_message.set_name('PER','AME_400820_INVAL_HDR_ATTR_USG');
440: , p_message_type => hr_multi_message.g_warning_msg);
441: elsif attributeItemTypeIn = 'HEADER_ATTR' then
442: if approverTypeIdIn is not null then
443: fnd_message.set_name('PER','AME_400821_INVAL_APR_ATTR_USG');
444: fnd_message.set_token('ATTRIBUTE_NAME',attributeNameIn);
445: hr_multi_message.add (p_associated_column1 => 'ATTR_NAME');
446: else
447: fnd_message.set_name('PER','AME_400820_INVAL_HDR_ATTR_USG');
448: fnd_message.set_token('ATTRIBUTE_NAME',attributeNameIn);
443: fnd_message.set_name('PER','AME_400821_INVAL_APR_ATTR_USG');
444: fnd_message.set_token('ATTRIBUTE_NAME',attributeNameIn);
445: hr_multi_message.add (p_associated_column1 => 'ATTR_NAME');
446: else
447: fnd_message.set_name('PER','AME_400820_INVAL_HDR_ATTR_USG');
448: fnd_message.set_token('ATTRIBUTE_NAME',attributeNameIn);
449: hr_multi_message.add (p_associated_column1 => 'ATTR_NAME'
450: , p_message_type => hr_multi_message.g_warning_msg);
451: end if;
444: fnd_message.set_token('ATTRIBUTE_NAME',attributeNameIn);
445: hr_multi_message.add (p_associated_column1 => 'ATTR_NAME');
446: else
447: fnd_message.set_name('PER','AME_400820_INVAL_HDR_ATTR_USG');
448: fnd_message.set_token('ATTRIBUTE_NAME',attributeNameIn);
449: hr_multi_message.add (p_associated_column1 => 'ATTR_NAME'
450: , p_message_type => hr_multi_message.g_warning_msg);
451: end if;
452: else
451: end if;
452: else
453: itemClassName := getItemClassNameById(itemClassIdIn=> itemClassIdIn);
454: if approverTypeIdIn is not null then
455: fnd_message.set_name('PER','AME_400823_INV_APR_LN_ATR_USG');
456: fnd_message.set_token('ATTRIBUTE_NAME',attributeNameIn);
457: fnd_message.set_token('ITEM_ID',itemIdIn);
458: fnd_message.set_token('ITEM_CLASS',itemClassName);
459: hr_multi_message.add (p_associated_column1 => 'ATTR_NAME');
452: else
453: itemClassName := getItemClassNameById(itemClassIdIn=> itemClassIdIn);
454: if approverTypeIdIn is not null then
455: fnd_message.set_name('PER','AME_400823_INV_APR_LN_ATR_USG');
456: fnd_message.set_token('ATTRIBUTE_NAME',attributeNameIn);
457: fnd_message.set_token('ITEM_ID',itemIdIn);
458: fnd_message.set_token('ITEM_CLASS',itemClassName);
459: hr_multi_message.add (p_associated_column1 => 'ATTR_NAME');
460: else
453: itemClassName := getItemClassNameById(itemClassIdIn=> itemClassIdIn);
454: if approverTypeIdIn is not null then
455: fnd_message.set_name('PER','AME_400823_INV_APR_LN_ATR_USG');
456: fnd_message.set_token('ATTRIBUTE_NAME',attributeNameIn);
457: fnd_message.set_token('ITEM_ID',itemIdIn);
458: fnd_message.set_token('ITEM_CLASS',itemClassName);
459: hr_multi_message.add (p_associated_column1 => 'ATTR_NAME');
460: else
461: fnd_message.set_name('PER','AME_400822_INVAL_LNE_ATTR_USG');
454: if approverTypeIdIn is not null then
455: fnd_message.set_name('PER','AME_400823_INV_APR_LN_ATR_USG');
456: fnd_message.set_token('ATTRIBUTE_NAME',attributeNameIn);
457: fnd_message.set_token('ITEM_ID',itemIdIn);
458: fnd_message.set_token('ITEM_CLASS',itemClassName);
459: hr_multi_message.add (p_associated_column1 => 'ATTR_NAME');
460: else
461: fnd_message.set_name('PER','AME_400822_INVAL_LNE_ATTR_USG');
462: fnd_message.set_token('ATTRIBUTE_NAME',attributeNameIn);
457: fnd_message.set_token('ITEM_ID',itemIdIn);
458: fnd_message.set_token('ITEM_CLASS',itemClassName);
459: hr_multi_message.add (p_associated_column1 => 'ATTR_NAME');
460: else
461: fnd_message.set_name('PER','AME_400822_INVAL_LNE_ATTR_USG');
462: fnd_message.set_token('ATTRIBUTE_NAME',attributeNameIn);
463: fnd_message.set_token('ITEM_ID',itemIdIn);
464: fnd_message.set_token('ITEM_CLASS',itemClassName);
465: hr_multi_message.add (p_associated_column1 => 'ATTR_NAME'
458: fnd_message.set_token('ITEM_CLASS',itemClassName);
459: hr_multi_message.add (p_associated_column1 => 'ATTR_NAME');
460: else
461: fnd_message.set_name('PER','AME_400822_INVAL_LNE_ATTR_USG');
462: fnd_message.set_token('ATTRIBUTE_NAME',attributeNameIn);
463: fnd_message.set_token('ITEM_ID',itemIdIn);
464: fnd_message.set_token('ITEM_CLASS',itemClassName);
465: hr_multi_message.add (p_associated_column1 => 'ATTR_NAME'
466: ,p_message_type => hr_multi_message.g_warning_msg
459: hr_multi_message.add (p_associated_column1 => 'ATTR_NAME');
460: else
461: fnd_message.set_name('PER','AME_400822_INVAL_LNE_ATTR_USG');
462: fnd_message.set_token('ATTRIBUTE_NAME',attributeNameIn);
463: fnd_message.set_token('ITEM_ID',itemIdIn);
464: fnd_message.set_token('ITEM_CLASS',itemClassName);
465: hr_multi_message.add (p_associated_column1 => 'ATTR_NAME'
466: ,p_message_type => hr_multi_message.g_warning_msg
467: );
460: else
461: fnd_message.set_name('PER','AME_400822_INVAL_LNE_ATTR_USG');
462: fnd_message.set_token('ATTRIBUTE_NAME',attributeNameIn);
463: fnd_message.set_token('ITEM_ID',itemIdIn);
464: fnd_message.set_token('ITEM_CLASS',itemClassName);
465: hr_multi_message.add (p_associated_column1 => 'ATTR_NAME'
466: ,p_message_type => hr_multi_message.g_warning_msg
467: );
468: end if;
991: if sqlcode = -20001 then
992: errString := sqlerrm;
993: errString:= substr(errString,11);
994: else
995: fnd_message.set_name('PER','AME_400754_TEST_REALTX_ATT_ERR');
996: hr_multi_message.add (p_associated_column1 => 'ATTR_NAME');
997: errString := 'ERROR_EXIST';
998: end if;
999: end populateRealTransAttributes;
1084: if sqlcode = -20001 then
1085: errString := sqlerrm;
1086: errString:= substr(errString,11);
1087: else
1088: fnd_message.set_name('PER','AME_400692_ENGINE_ERROR');
1089: errString := fnd_message.get;
1090: end if;
1091: end getApplicableRules;
1092: --+
1085: errString := sqlerrm;
1086: errString:= substr(errString,11);
1087: else
1088: fnd_message.set_name('PER','AME_400692_ENGINE_ERROR');
1089: errString := fnd_message.get;
1090: end if;
1091: end getApplicableRules;
1092: --+
1093: procedure getApprovers(applicationIdIn in number
1205: if sqlcode = -20001 then
1206: errString := sqlerrm;
1207: errString:= substr(errString,11);
1208: else
1209: fnd_message.set_name('PER','AME_400692_ENGINE_ERROR');
1210: errString := fnd_message.get;
1211: end if;
1212: --+
1213: end getApprovers;
1206: errString := sqlerrm;
1207: errString:= substr(errString,11);
1208: else
1209: fnd_message.set_name('PER','AME_400692_ENGINE_ERROR');
1210: errString := fnd_message.get;
1211: end if;
1212: --+
1213: end getApprovers;
1214: --+
1266: if sqlcode = -20001 then
1267: errString := sqlerrm;
1268: errString:= substr(errString,11);
1269: else
1270: fnd_message.set_name('PER','AME_400692_ENGINE_ERROR');
1271: errString := fnd_message.get;
1272: end if;
1273: end getTransactionProductions;
1274: end ame_test_utility_pkg;
1267: errString := sqlerrm;
1268: errString:= substr(errString,11);
1269: else
1270: fnd_message.set_name('PER','AME_400692_ENGINE_ERROR');
1271: errString := fnd_message.get;
1272: end if;
1273: end getTransactionProductions;
1274: end ame_test_utility_pkg;