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_ATTRIBUTE_PKG dependencies on AME_ATTRIBUTE_PKG

Line 1: package body ame_attribute_pkg as

1: package body ame_attribute_pkg as
2: /* $Header: ameoattr.pkb 120.1 2006/12/26 13:14:27 avarri noship $ */
3: function attributeExists(attributeIdIn in integer) return boolean as
4: attributeCount integer;
5: begin

Line 20: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

16: return(false);
17: exception
18: when others then
19: rollback;
20: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
21: routineNameIn => 'attributeExists',
22: exceptionNumberIn => sqlcode,
23: exceptionStringIn => '(attribute ID ' ||
24: attributeIdIn||

Line 48: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

44: return(false);
45: exception
46: when others then
47: rollback;
48: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
49: routineNameIn => 'attributeExistsForDiffIC',
50: exceptionNumberIn => sqlcode,
51: exceptionStringIn => sqlerrm);
52: raise;

Line 151: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

147: return(useCount);
148: exception
149: when others then
150: rollback;
151: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
152: routineNameIn => 'calculateUseCount',
153: exceptionNumberIn => sqlcode,
154: exceptionStringIn => '(Attribute ID ' ||
155: attributeIdIn||

Line 193: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

189: return(approvalTypeNames);
190: exception
191: when others then
192: rollback;
193: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
194: routineNameIn => 'getApprovalTypeNames',
195: exceptionNumberIn => sqlcode,
196: exceptionStringIn => '(attribute ID ' ||
197: attributeIdIn ||

Line 217: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

213: return(approverTypeId);
214: exception
215: when others then
216: rollback;
217: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
218: routineNameIn => 'getApproverTypeId',
219: exceptionNumberIn => sqlcode,
220: exceptionStringIn => '(attribute ID ' ||
221: attributeIdIn ||

Line 247: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

243: return(attributeConditionCnt);
244: exception
245: when others then
246: rollback;
247: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
248: routineNameIn => 'getAttributeConditionCnt',
249: exceptionNumberIn => sqlcode,
250: exceptionStringIn => '(attribute ID ' ||
251: attributeIdIn ||

Line 293: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

289: return(attributeConditionInUseCnt);
290: exception
291: when others then
292: rollback;
293: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
294: routineNameIn => 'getAttributeConditionInUseCnt',
295: exceptionNumberIn => sqlcode,
296: exceptionStringIn => '(attribute ID ' ||
297: attributeIdIn ||

Line 333: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

329: return(attributeNames);
330: exception
331: when others then
332: rollback;
333: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
334: routineNameIn => 'getAttributeNames',
335: exceptionNumberIn => sqlcode,
336: exceptionStringIn => '(action type ID ' ||
337: actionTypeIdIn ||

Line 357: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

353: return(description);
354: exception
355: when others then
356: rollback;
357: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
358: routineNameIn => 'getDescription',
359: exceptionNumberIn => sqlcode,
360: exceptionStringIn => '(attribute ID ' ||
361: attributeIdIn||

Line 381: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

377: return(attributeId);
378: exception
379: when others then
380: rollback;
381: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
382: routineNameIn => 'getIdByName',
383: exceptionNumberIn => sqlcode,
384: exceptionStringIn => '(attribute name ' ||
385: attributeNameIn||

Line 405: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

401: return(itemClassId);
402: exception
403: when others then
404: rollback;
405: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
406: routineNameIn => 'getItemClassId',
407: exceptionNumberIn => sqlcode,
408: exceptionStringIn => '(attribute ID ' ||
409: attributeIdIn||

Line 429: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

425: return(lineItem);
426: exception
427: when others then
428: rollback;
429: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
430: routineNameIn => 'getLineItem',
431: exceptionNumberIn => sqlcode,
432: exceptionStringIn => '(attribute ID ' ||
433: attributeIdIn||

Line 453: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

449: return(name);
450: exception
451: when others then
452: rollback;
453: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
454: routineNameIn => 'getName',
455: exceptionNumberIn => sqlcode,
456: exceptionStringIn => '(attribute ID ' ||
457: attributeIdIn||

Line 489: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

485: tokenNameOneIn => 'ATTRIBUTE',
486: tokenValueOneIn => getName(attributeIdIn => attributeIdIn),
487: tokenNameTwoIn => 'APPLICATION',
488: tokenValueTwoIn => ame_admin_pkg.getApplicationName(applicationIdIn => applicationIdIn));
489: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
490: routineNameIn => 'getQueryString',
491: exceptionNumberIn => errorCode,
492: exceptionStringIn => errorMessage);
493: raise_application_error(errorCode,

Line 498: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

494: errorMessage);
495: return(null);
496: when others then
497: rollback;
498: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
499: routineNameIn => 'getQueryString',
500: exceptionNumberIn => sqlcode,
501: exceptionStringIn => '(attribute ID ' ||
502: attributeIdIn||

Line 522: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

518: return(startDate);
519: exception
520: when others then
521: rollback;
522: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
523: routineNameIn => 'getStartDate',
524: exceptionNumberIn => sqlcode,
525: exceptionStringIn => '(attribute ID ' ||
526: attributeIdIn||

Line 547: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

543: return(staticUsage);
544: exception
545: when others then
546: rollback;
547: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
548: routineNameIn => 'getStaticUsage',
549: exceptionNumberIn => sqlcode,
550: exceptionStringIn => '(attribute ID ' ||
551: attributeIdIn||

Line 583: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

579: tokenNameOneIn => 'ATTRIBUTE',
580: tokenValueOneIn => getName(attributeIdIn => attributeIdIn),
581: tokenNameTwoIn => 'APPLICATION',
582: tokenValueTwoIn => ame_admin_pkg.getApplicationName(applicationIdIn => applicationIdIn));
583: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
584: routineNameIn => 'getUseCount',
585: exceptionNumberIn => errorCode,
586: exceptionStringIn => errorMessage);
587: raise_application_error(errorCode,

Line 592: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

588: errorMessage);
589: return(null);
590: when others then
591: rollback;
592: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
593: routineNameIn => 'getUseCount',
594: exceptionNumberIn => sqlcode,
595: exceptionStringIn => '(attribute ID ' ||
596: attributeIdIn||

Line 628: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

624: tokenNameOneIn => 'ATTRIBUTE',
625: tokenValueOneIn => getName(attributeIdIn => attributeIdIn),
626: tokenNameTwoIn => 'APPLICATION',
627: tokenValueTwoIn => ame_admin_pkg.getApplicationName(applicationIdIn => applicationIdIn));
628: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
629: routineNameIn => 'getUserEditable',
630: exceptionNumberIn => errorCode,
631: exceptionStringIn => errorMessage);
632: raise_application_error(errorCode,

Line 637: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

633: errorMessage);
634: return(null);
635: when others then
636: rollback;
637: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
638: routineNameIn => 'getUserEditable',
639: exceptionNumberIn => sqlcode,
640: exceptionStringIn => '(attribute ID ' ||
641: attributeIdIn||

Line 665: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

661: return(stringStartDate);
662: exception
663: when others then
664: rollback;
665: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
666: routineNameIn => 'getChildVersionStartDate',
667: exceptionNumberIn => sqlcode,
668: exceptionStringIn => '(attribute ID ' ||
669: attributeIdIn||

Line 691: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

687: return(stringStartDate);
688: exception
689: when others then
690: rollback;
691: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
692: routineNameIn => 'getParentVersionStartDate',
693: exceptionNumberIn => sqlcode,
694: exceptionStringIn => '(attribute ID ' ||
695: attributeIdIn||

Line 715: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

711: return(attributeType);
712: exception
713: when others then
714: rollback;
715: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
716: routineNameIn => 'getType',
717: exceptionNumberIn => sqlcode,
718: exceptionStringIn => '(attribute ID ' ||
719: attributeIdIn||

Line 764: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

760: errorCode := -20001;
761: errorMessage :=
762: ame_util.getMessage(applicationShortNameIn => 'PER',
763: messageNameIn => 'AME_400150_ATT_STA_CONV_INV');
764: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
765: routineNameIn => 'inputToCanonStaticCurUsage',
766: exceptionNumberIn => errorCode,
767: exceptionStringIn => errorMessage); /* Runtime code doesn't validate input. */
768: raise_application_error(errorCode,

Line 777: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

773: errorCode := -20001;
774: errorMessage :=
775: ame_util.getMessage(applicationShortNameIn => 'PER',
776: messageNameIn => 'AME_400151_ATT_STA_CURR_INV');
777: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
778: routineNameIn => 'inputToCanonStaticCurUsage',
779: exceptionNumberIn => errorCode,
780: exceptionStringIn => errorMessage); /* Runtime code doesn't validate input. */
781: raise_application_error(errorCode,

Line 786: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

782: errorMessage);
783: return(null);
784: when others then
785: rollback;
786: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
787: routineNameIn => 'inputToCanonStaticCurUsage',
788: exceptionNumberIn => sqlcode,
789: exceptionStringIn => '(attribute ID ' ||
790: attributeIdIn||

Line 815: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

811: return(false);
812: exception
813: when others then
814: rollback;
815: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
816: routineNameIn => 'hasUsage',
817: exceptionNumberIn => sqlcode,
818: exceptionStringIn => '(attribute ID ' ||
819: attributeIdIn||

Line 859: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

855: return(false);
856: exception
857: when others then
858: rollback;
859: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
860: routineNameIn => 'isAStripingAttribute',
861: exceptionNumberIn => sqlcode,
862: exceptionStringIn => '(attribute ID ' ||
863: attributeIdIn||

Line 888: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

884: return(false);
885: exception
886: when others then
887: rollback;
888: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
889: routineNameIn => 'isInUse',
890: exceptionNumberIn => sqlcode,
891: exceptionStringIn => '(attribute ID ' ||
892: attributeIdIn||

Line 920: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

916: rollback;
917: return(false);
918: when others then
919: rollback;
920: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
921: routineNameIn => 'isInUseByApplication',
922: exceptionNumberIn => sqlcode,
923: exceptionStringIn => '(attribute ID ' ||
924: attributeIdIn||

Line 948: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

944: return(false);
945: exception
946: when others then
947: rollback;
948: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
949: routineNameIn => 'isLineItem',
950: exceptionNumberIn => sqlcode,
951: exceptionStringIn => '(attribute ID ' ||
952: attributeIdIn||

Line 975: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

971: return(false);
972: exception
973: when others then
974: rollback;
975: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
976: routineNameIn => 'isMandatory',
977: exceptionNumberIn => sqlcode,
978: exceptionStringIn => '(attribute ID ' ||
979: attributeIdIn||

Line 1003: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

999: return(false);
1000: exception
1001: when others then
1002: rollback;
1003: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
1004: routineNameIn => 'isNonHeaderAttributeItem',
1005: exceptionNumberIn => sqlcode,
1006: exceptionStringIn => '(attribute ID ' ||
1007: attributeIdIn||

Line 1031: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

1027: return(false);
1028: exception
1029: when others then
1030: rollback;
1031: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
1032: routineNameIn => 'isRequired',
1033: exceptionNumberIn => sqlcode,
1034: exceptionStringIn => '(attribute ID ' ||
1035: attributeIdIn||

Line 1058: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

1054: return(false);
1055: exception
1056: when others then
1057: rollback;
1058: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
1059: routineNameIn => 'isSeeded',
1060: exceptionNumberIn => sqlcode,
1061: exceptionStringIn => '(attribute ID ' ||
1062: attributeIdIn||

Line 1092: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

1088: rollback;
1089: return(false);
1090: when others then
1091: rollback;
1092: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
1093: routineNameIn => 'isStripingAttribute',
1094: exceptionNumberIn => sqlcode,
1095: exceptionStringIn => '(attribute ID ' ||
1096: attributeIdIn||

Line 1120: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

1116: return(false);
1117: exception
1118: when others then
1119: rollback;
1120: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
1121: routineNameIn => 'nameExists',
1122: exceptionNumberIn => sqlcode,
1123: exceptionStringIn => sqlerrm);
1124: raise;

Line 1251: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

1247: errorCode := -20001;
1248: errorMessage :=
1249: ame_util.getMessage(applicationShortNameIn => 'PER',
1250: messageNameIn => 'AME_400152_ATT_NAME_EXISTS');
1251: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
1252: routineNameIn => 'new',
1253: exceptionNumberIn => errorCode,
1254: exceptionStringIn => errorMessage);
1255: raise_application_error(errorCode,

Line 1267: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

1263: messageNameIn => 'AME_400153_ATT_NAME_LONG',
1264: tokenNameOneIn => 'COLUMN_LENGTH',
1265: tokenValueOneIn => ame_util.getColumnLength(tableNameIn => 'ame_attributes',
1266: columnNameIn => 'name'));
1267: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
1268: routineNameIn => 'new',
1269: exceptionNumberIn => errorCode,
1270: exceptionStringIn => errorMessage);
1271: raise_application_error(errorCode,

Line 1283: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

1279: messageNameIn => 'AME_400154_ATT_TYPE_LONG',
1280: tokenNameOneIn => 'COLUMN_LENGTH',
1281: tokenValueOneIn => ame_util.getColumnLength(tableNameIn => 'ame_attributes',
1282: columnNameIn => 'attribute_type'));
1283: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
1284: routineNameIn => 'new',
1285: exceptionNumberIn => errorCode,
1286: exceptionStringIn => errorMessage);
1287: raise_application_error(errorCode,

Line 1299: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

1295: messageNameIn => 'AME_400155_ATT_DESC_LONG',
1296: tokenNameOneIn => 'COLUMN_LENGTH',
1297: tokenValueOneIn => ame_util.getColumnLength(tableNameIn => 'ame_attributes',
1298: columnNameIn => 'description'));
1299: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
1300: routineNameIn => 'new',
1301: exceptionNumberIn => errorCode,
1302: exceptionStringIn => errorMessage);
1303: raise_application_error(errorCode,

Line 1308: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

1304: errorMessage);
1305: return(null);
1306: when others then
1307: rollback;
1308: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
1309: routineNameIn => 'new',
1310: exceptionNumberIn => sqlcode,
1311: exceptionStringIn => '(attribute ID ' ||
1312: attributeIdIn||

Line 1339: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

1335: return(false);
1336: exception
1337: when others then
1338: rollback;
1339: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
1340: routineNameIn => 'usageIsUserEditable',
1341: exceptionNumberIn => sqlcode,
1342: exceptionStringIn => '(attribute ID ' ||
1343: attributeIdIn||

Line 1388: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

1384: end if;
1385: exception
1386: when others then
1387: rollback;
1388: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
1389: routineNameIn => 'change',
1390: exceptionNumberIn => sqlcode,
1391: exceptionStringIn => '(attribute ID ' ||
1392: attributeIdIn||

Line 1499: ame_attribute_pkg.change(attributeIdIn => attributeIdIn,

1495: else
1496: description := descriptionIn;
1497: end if;
1498: newStartAndEndDate := sysdate;
1499: ame_attribute_pkg.change(attributeIdIn => attributeIdIn,
1500: applicationIdIn => applicationIdIn,
1501: nameIn => name,
1502: typeIn => attributeType,
1503: endDateIn => newStartAndEndDate,

Line 1508: ame_attribute_pkg.changeUsage(attributeIdIn => attributeIdIn,

1504: startDateIn => newStartAndEndDate,
1505: descriptionIn => description,
1506: itemClassIdIn => itemClassIdIn,
1507: finalizeIn => false);
1508: ame_attribute_pkg.changeUsage(attributeIdIn => attributeIdIn,
1509: applicationIdIn => applicationIdIn,
1510: staticUsageIn => staticUsageIn,
1511: queryStringIn => queryString,
1512: endDateIn => newStartAndEndDate,

Line 1533: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

1529: errorCode := -20001;
1530: errorMessage :=
1531: ame_util.getMessage(applicationShortNameIn => 'PER',
1532: messageNameIn => 'AME_400143_ACT_OBJECT_CHNGED');
1533: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
1534: routineNameIn => 'changeAttributeAndUsage',
1535: exceptionNumberIn => errorCode,
1536: exceptionStringIn => errorMessage);
1537: raise_application_error(errorCode,

Line 1551: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

1547: errorCode := -20001;
1548: errorMessage :=
1549: ame_util.getMessage(applicationShortNameIn => 'PER',
1550: messageNameIn => 'AME_400145_ACT_OBJECT_DELETED');
1551: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
1552: routineNameIn => 'changeAttributeAndUsage',
1553: exceptionNumberIn => errorCode,
1554: exceptionStringIn => errorMessage);
1555: raise_application_error(errorCode,

Line 1569: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

1565: errorCode := -20001;
1566: errorMessage :=
1567: ame_util.getMessage(applicationShortNameIn => 'PER',
1568: messageNameIn => 'AME_400157_ATT_REF_LINE_ITEM');
1569: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
1570: routineNameIn => 'changeAttributeAndUsage',
1571: exceptionNumberIn => errorCode,
1572: exceptionStringIn => errorMessage);
1573: raise_application_error(errorCode,

Line 1583: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

1579: end if;
1580: if(startDateCursor2%isOpen) then
1581: close startDateCursor2;
1582: end if;
1583: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
1584: routineNameIn => 'changeAttributeAndUsage',
1585: exceptionNumberIn => sqlcode,
1586: exceptionStringIn => '(attribute ID ' ||
1587: attributeIdIn||

Line 1625: attributeType := ame_attribute_pkg.getType(attributeIdIn => attributeIdIn);

1621: queryStringColumnException exception;
1622: tempCount integer;
1623: transactionType ame_calling_apps.application_name%type;
1624: begin
1625: attributeType := ame_attribute_pkg.getType(attributeIdIn => attributeIdIn);
1626: if(staticUsageIn = ame_util.booleanTrue) then
1627: queryString := ame_util.removeReturns(stringIn => queryStringIn,
1628: replaceWithSpaces => false);
1629: if(attributeType = ame_util.numberAttributeType) then

Line 1679: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

1675: errorCode := -20001;
1676: errorMessage := 'The select clause of a currency attribute''s ' ||
1677: 'usage must select three values: ' ||
1678: 'amount, currency code, and conversion-type code ';
1679: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
1680: routineNameIn => 'changeUsage',
1681: exceptionNumberIn => errorCode,
1682: exceptionStringIn => errorMessage);
1683: raise_application_error(errorCode,

Line 1687: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

1683: raise_application_error(errorCode,
1684: errorMessage);
1685: when others then
1686: rollback;
1687: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
1688: routineNameIn => 'changeUsage',
1689: exceptionNumberIn => sqlcode,
1690: exceptionStringIn => '(attribute ID ' ||
1691: attributeIdIn||

Line 1746: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

1742: end loop;
1743: exception
1744: when others then
1745: rollback;
1746: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
1747: routineNameIn => 'getActiveAttributes',
1748: exceptionNumberIn => sqlcode,
1749: exceptionStringIn => '(application ID ' ||
1750: applicationIdIn||

Line 1814: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

1810: end loop;
1811: exception
1812: when others then
1813: rollback;
1814: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
1815: routineNameIn => 'getActiveHeaderAttributes',
1816: exceptionNumberIn => sqlcode,
1817: exceptionStringIn => '(application ID ' ||
1818: applicationIdIn||

Line 1844: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

1840: end loop;
1841: exception
1842: when others then
1843: rollback;
1844: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
1845: routineNameIn => 'getAllAttributes',
1846: exceptionNumberIn => sqlcode,
1847: exceptionStringIn => sqlerrm);
1848: raise;

Line 1870: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

1866: end loop;
1867: exception
1868: when others then
1869: rollback;
1870: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
1871: routineNameIn => 'getApplicationAttributes',
1872: exceptionNumberIn => sqlcode,
1873: exceptionStringIn => '(applicationID ' ||
1874: applicationIdIn||

Line 1916: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

1912: end loop;
1913: exception
1914: when others then
1915: rollback;
1916: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
1917: routineNameIn => 'getApplicationAttributes2',
1918: exceptionNumberIn => sqlcode,
1919: exceptionStringIn => '(application ID ' ||
1920: applicationIdIn||

Line 2007: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

2003: end loop;
2004: exception
2005: when others then
2006: rollback;
2007: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
2008: routineNameIn => 'getApplicationAttributes3',
2009: exceptionNumberIn => sqlcode,
2010: exceptionStringIn => '(application ID ' ||
2011: applicationIdIn||

Line 2063: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

2059: end loop;
2060: exception
2061: when others then
2062: rollback;
2063: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
2064: routineNameIn => 'getAttributes',
2065: exceptionNumberIn => sqlcode,
2066: exceptionStringIn => '(application ID ' ||
2067: applicationIdIn||

Line 2120: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

2116: end loop;
2117: exception
2118: when others then
2119: rollback;
2120: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
2121: routineNameIn => 'getAttributes2',
2122: exceptionNumberIn => sqlcode,
2123: exceptionStringIn => '(application ID ' ||
2124: applicationIdIn||

Line 2189: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

2185: end loop;
2186: exception
2187: when others then
2188: rollback;
2189: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
2190: routineNameIn => 'getAttributes3',
2191: exceptionNumberIn => sqlcode,
2192: exceptionStringIn => '(application ID ' ||
2193: applicationIdIn||

Line 2218: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

2214: end loop;
2215: exception
2216: when others then
2217: rollback;
2218: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
2219: routineNameIn => 'getAttributeConditions',
2220: exceptionNumberIn => sqlcode,
2221: exceptionStringIn => sqlerrm);
2222: raise;

Line 2256: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

2252: end loop;
2253: exception
2254: when others then
2255: rollback;
2256: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
2257: routineNameIn => 'getAvailReqAttributes',
2258: exceptionNumberIn => sqlcode,
2259: exceptionStringIn => '(action type ID ' ||
2260: actionTypeIdIn||

Line 2305: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

2301: close getHeaderICAttributesCursor;
2302: exception
2303: when others then
2304: rollback;
2305: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
2306: routineNameIn => 'getHeaderICAttributes',
2307: exceptionNumberIn => sqlcode,
2308: exceptionStringIn => '(application ID ' ||
2309: applicationIdIn||

Line 2349: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

2345: end loop;
2346: exception
2347: when others then
2348: rollback;
2349: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
2350: routineNameIn => 'getMandatoryAttributes',
2351: exceptionNumberIn => sqlcode,
2352: exceptionStringIn => sqlerrm);
2353: raise;

Line 2393: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

2389: end loop;
2390: exception
2391: when others then
2392: rollback;
2393: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
2394: routineNameIn => 'getMandatoryAttributes2',
2395: exceptionNumberIn => sqlcode,
2396: exceptionStringIn => sqlerrm);
2397: raise;

Line 2436: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

2432: end loop;
2433: exception
2434: when others then
2435: rollback;
2436: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
2437: routineNameIn => 'getMandatoryAttributes3',
2438: exceptionNumberIn => sqlcode,
2439: exceptionStringIn => sqlerrm);
2440: raise;

Line 2476: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

2472: when others then
2473: rollback;
2474: attributeIdsOut := ame_util.emptyStringList;
2475: attributeNamesOut := ame_util.emptyStringList;
2476: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
2477: routineNameIn => 'getNonHeaderICAttributes',
2478: exceptionNumberIn => sqlcode,
2479: exceptionStringIn => '(application ID ' ||
2480: applicationIdIn||

Line 2519: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

2515: when others then
2516: rollback;
2517: attributeIdsOut := ame_util.emptyIdList;
2518: attributeNamesOut := ame_util.emptyStringList;
2519: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
2520: routineNameIn => 'getNonHeaderICAttributes2',
2521: exceptionNumberIn => sqlcode,
2522: exceptionStringIn => '(application ID ' ||
2523: applicationIdIn||

Line 2556: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

2552: end loop;
2553: exception
2554: when others then
2555: rollback;
2556: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
2557: routineNameIn => 'getRequiredAttributes',
2558: exceptionNumberIn => sqlcode,
2559: exceptionStringIn => '(action type ID ' ||
2560: actionTypeIdIn||

Line 2604: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

2600: end loop;
2601: exception
2602: when others then
2603: rollback;
2604: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
2605: routineNameIn => 'getLineItemAttributes',
2606: exceptionNumberIn => sqlcode,
2607: exceptionStringIn => '(application ID ' ||
2608: applicationIdIn||

Line 2645: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

2641: end loop;
2642: exception
2643: when others then
2644: rollback;
2645: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
2646: routineNameIn => 'getLineItemAttributes',
2647: exceptionNumberIn => sqlcode,
2648: exceptionStringIn => '(application ID ' ||
2649: applicationIdIn||

Line 2685: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

2681: end loop;
2682: exception
2683: when others then
2684: rollback;
2685: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
2686: routineNameIn => 'getLineItemAttributes2',
2687: exceptionNumberIn => sqlcode,
2688: exceptionStringIn => '(application ID ' ||
2689: applicationIdIn||

Line 2738: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

2734: end loop;
2735: exception
2736: when others then
2737: rollback;
2738: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
2739: routineNameIn => 'getNonMandatoryAttributes',
2740: exceptionNumberIn => sqlcode,
2741: exceptionStringIn => '(application ID ' ||
2742: applicationIdIn||

Line 2784: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

2780: end loop;
2781: exception
2782: when others then
2783: rollback;
2784: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
2785: routineNameIn => 'getNonMandatoryAttributes',
2786: exceptionNumberIn => sqlcode,
2787: exceptionStringIn => '(application ID ' ||
2788: applicationIdIn||

Line 2839: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

2835: end loop;
2836: exception
2837: when others then
2838: rollback;
2839: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
2840: routineNameIn => 'getNonMandHeaderAttributes',
2841: exceptionNumberIn => sqlcode,
2842: exceptionStringIn => '(application ID ' ||
2843: applicationIdIn||

Line 2878: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

2874: end loop;
2875: exception
2876: when others then
2877: rollback;
2878: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
2879: routineNameIn => 'getRuleStripingAttributes',
2880: exceptionNumberIn => sqlcode,
2881: exceptionStringIn => '(application ID ' ||
2882: applicationIdIn||

Line 2991: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

2987: end if;
2988: exception
2989: when others then
2990: rollback;
2991: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
2992: routineNameIn => 'getExistingShareableAttNames',
2993: exceptionNumberIn => sqlcode,
2994: exceptionStringIn => '(application ID ' ||
2995: applicationIdIn||

Line 3036: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

3032: when others then
3033: rollback;
3034: attributeIdsOut := ame_util.emptyStringList;
3035: attributeNamesOut := ame_util.emptyStringList;
3036: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
3037: routineNameIn => 'getSubordinateICAttributes',
3038: exceptionNumberIn => sqlcode,
3039: exceptionStringIn => '(application ID ' ||
3040: applicationIdIn||

Line 3085: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

3081: rollback;
3082: attributeIdsOut := ame_util.emptyIdList;
3083: attributeNamesOut := ame_util.emptyStringList;
3084: attributeTypesOut := ame_util.emptyStringList;
3085: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
3086: routineNameIn => 'getSubordinateICAttributes2',
3087: exceptionNumberIn => sqlcode,
3088: exceptionStringIn => '(application ID ' ||
3089: applicationIdIn||

Line 3190: attributeName := ame_attribute_pkg.getName(attributeIdIn => attributeIdIn);

3186: close startDateCursor;
3187: raise ame_util.objectVersionException;
3188: end if;
3189: end if;
3190: attributeName := ame_attribute_pkg.getName(attributeIdIn => attributeIdIn);
3191: attributeType := ame_attribute_pkg.getType(attributeIdIn => attributeIdIn);
3192: itemClassId := ame_attribute_pkg.getItemClassId(attributeIdIn => attributeIdIn);
3193: if(staticUsageIn = ame_util.booleanTrue) then /* static usage */
3194: queryString := ame_util.removeReturns(stringIn => queryStringIn,

Line 3191: attributeType := ame_attribute_pkg.getType(attributeIdIn => attributeIdIn);

3187: raise ame_util.objectVersionException;
3188: end if;
3189: end if;
3190: attributeName := ame_attribute_pkg.getName(attributeIdIn => attributeIdIn);
3191: attributeType := ame_attribute_pkg.getType(attributeIdIn => attributeIdIn);
3192: itemClassId := ame_attribute_pkg.getItemClassId(attributeIdIn => attributeIdIn);
3193: if(staticUsageIn = ame_util.booleanTrue) then /* static usage */
3194: queryString := ame_util.removeReturns(stringIn => queryStringIn,
3195: replaceWithSpaces => false);

Line 3192: itemClassId := ame_attribute_pkg.getItemClassId(attributeIdIn => attributeIdIn);

3188: end if;
3189: end if;
3190: attributeName := ame_attribute_pkg.getName(attributeIdIn => attributeIdIn);
3191: attributeType := ame_attribute_pkg.getType(attributeIdIn => attributeIdIn);
3192: itemClassId := ame_attribute_pkg.getItemClassId(attributeIdIn => attributeIdIn);
3193: if(staticUsageIn = ame_util.booleanTrue) then /* static usage */
3194: queryString := ame_util.removeReturns(stringIn => queryStringIn,
3195: replaceWithSpaces => false);
3196: if(instrb(upper(queryString), upper(ame_util.transactionIdPlaceholder))) > 0 then

Line 3220: attributeId := ame_attribute_pkg.getIdByName(attributeNameIn => ame_util.restrictiveItemEvalAttribute);

3216: raise booleanException;
3217: end if;
3218: if(attributeName = ame_util.evalPrioritiesPerItemAttribute) then
3219: if(queryString = 'true') then
3220: attributeId := ame_attribute_pkg.getIdByName(attributeNameIn => ame_util.restrictiveItemEvalAttribute);
3221: queryString1 := ame_attribute_pkg.getQueryString(attributeIdIn => attributeId,
3222: applicationIdIn => applicationIdIn);
3223: if(queryString1 is null or queryString1 = 'false') then
3224: raise invalidBooleanValueException;

Line 3221: queryString1 := ame_attribute_pkg.getQueryString(attributeIdIn => attributeId,

3217: end if;
3218: if(attributeName = ame_util.evalPrioritiesPerItemAttribute) then
3219: if(queryString = 'true') then
3220: attributeId := ame_attribute_pkg.getIdByName(attributeNameIn => ame_util.restrictiveItemEvalAttribute);
3221: queryString1 := ame_attribute_pkg.getQueryString(attributeIdIn => attributeId,
3222: applicationIdIn => applicationIdIn);
3223: if(queryString1 is null or queryString1 = 'false') then
3224: raise invalidBooleanValueException;
3225: end if;

Line 3305: attributeName := ame_attribute_pkg.getName(attributeIdIn => attributeIdIn);

3301: comma2Location = 0 or
3302: comma1Location < 2 or
3303: comma2Location < 4) then
3304: /*
3305: attributeName := ame_attribute_pkg.getName(attributeIdIn => attributeIdIn);
3306: */
3307: raise badCurUsageException;
3308: end if;
3309: end if;

Line 3487: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

3483: errorCode := -20001;
3484: errorMessage :=
3485: ame_util.getMessage(applicationShortNameIn => 'PER',
3486: messageNameIn => 'AME_400143_ACT_OBJECT_CHNGED');
3487: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
3488: routineNameIn => 'newAttributeUsage',
3489: exceptionNumberIn => errorCode,
3490: exceptionStringIn => errorMessage);
3491: raise_application_error(errorCode,

Line 3502: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

3498: errorCode := -20001;
3499: errorMessage :=
3500: ame_util.getMessage(applicationShortNameIn => 'PER',
3501: messageNameIn => 'AME_400145_ACT_OBJECT_DELETED');
3502: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
3503: routineNameIn => 'newAttributeUsage',
3504: exceptionNumberIn => errorCode,
3505: exceptionStringIn => errorMessage);
3506: raise_application_error(errorCode,

Line 3514: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

3510: errorCode := -20001;
3511: errorMessage :=
3512: ame_util.getMessage(applicationShortNameIn => 'PER',
3513: messageNameIn => 'AME_400159_ATT_STAT_NOT_PLC');
3514: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
3515: routineNameIn => 'newAttributeUsage',
3516: exceptionNumberIn => errorCode,
3517: exceptionStringIn => errorMessage);
3518: raise_application_error(errorCode,

Line 3526: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

3522: errorCode := -20001;
3523: errorMessage :=
3524: ame_util.getMessage(applicationShortNameIn => 'PER',
3525: messageNameIn => 'AME_400414_DYNAMIC_ATTR_USAGES');
3526: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
3527: routineNameIn => 'newAttributeUsage',
3528: exceptionNumberIn => errorCode,
3529: exceptionStringIn => errorMessage);
3530: raise_application_error(errorCode,

Line 3538: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

3534: errorCode := -20001;
3535: errorMessage :=
3536: ame_util.getMessage(applicationShortNameIn => 'PER',
3537: messageNameIn => 'AME_400161_ATT_EMPTY_USAGE');
3538: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
3539: routineNameIn => 'newAttributeUsage',
3540: exceptionNumberIn => errorCode,
3541: exceptionStringIn => errorMessage);
3542: raise_application_error(errorCode,

Line 3550: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

3546: errorCode := -20001;
3547: errorMessage :=
3548: ame_util.getMessage(applicationShortNameIn => 'PER',
3549: messageNameIn => 'AME_400162_ATT_USAGE_EXISTS');
3550: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
3551: routineNameIn => 'newAttributeUsage',
3552: exceptionNumberIn => errorCode,
3553: exceptionStringIn => errorMessage);
3554: raise_application_error(errorCode,

Line 3562: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

3558: errorCode := -20001;
3559: errorMessage :=
3560: ame_util.getMessage(applicationShortNameIn => 'PER',
3561: messageNameIn => 'AME_400158_ATT_THREE_VALUES');
3562: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
3563: routineNameIn => 'newAttributeUsage',
3564: exceptionNumberIn => errorCode,
3565: exceptionStringIn => errorMessage);
3566: raise_application_error(errorCode,

Line 3577: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

3573: messageNameIn => 'AME_400163_ATT_USAGE_LONG',
3574: tokenNameOneIn => 'COLUMN_LENGTH',
3575: tokenValueOneIn => ame_util.getColumnLength(tableNameIn => 'ame_attribute_usages',
3576: columnNameIn => 'query_string'));
3577: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
3578: routineNameIn => 'newAttributeUsage',
3579: exceptionNumberIn => errorCode,
3580: exceptionStringIn => errorMessage);
3581: raise_application_error(errorCode,

Line 3589: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

3585: errorCode := -20001;
3586: errorMessage :=
3587: ame_util.getMessage(applicationShortNameIn => 'PER',
3588: messageNameIn => 'AME_400322_LIN_ITEM_TRUE_SET');
3589: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
3590: routineNameIn => 'newAttributeUsage',
3591: exceptionNumberIn => errorCode,
3592: exceptionStringIn => errorMessage);
3593: raise_application_error(errorCode,

Line 3601: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

3597: errorCode := -20001;
3598: errorMessage :=
3599: ame_util.getMessage(applicationShortNameIn => 'PER',
3600: messageNameIn => 'AME_400157_ATT_REF_LINE_ITEM');
3601: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
3602: routineNameIn => 'newAttributeUsage',
3603: exceptionNumberIn => errorCode,
3604: exceptionStringIn => errorMessage);
3605: raise_application_error(errorCode,

Line 3618: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

3614: tokenNameOneIn => 'TRANSACTION_TYPE',
3615: tokenValueOneIn => transactionType,
3616: tokenNameTwoIn => 'ATTRIBUTE',
3617: tokenValueTwoIn => attributeName);
3618: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
3619: routineNameIn => 'newAttributeUsage',
3620: exceptionNumberIn => errorCode,
3621: exceptionStringIn => errorMessage);
3622: raise_application_error(errorCode,

Line 3630: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

3626: errorCode := -20001;
3627: errorMessage :=
3628: ame_util.getMessage(applicationShortNameIn => 'PER',
3629: messageNameIn => 'AME_400165_ATT_DYN_USG_COMM');
3630: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
3631: routineNameIn => 'newAttributeUsage',
3632: exceptionNumberIn => errorCode,
3633: exceptionStringIn => errorMessage);
3634: raise_application_error(errorCode,

Line 3642: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

3638: errorCode := -20001;
3639: errorMessage :=
3640: ame_util.getMessage(applicationShortNameIn => 'PER',
3641: messageNameIn => 'AME_400166_ATT_STAT_USG_STRING');
3642: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
3643: routineNameIn => 'newAttributeUsage',
3644: exceptionNumberIn => errorCode,
3645: exceptionStringIn => errorMessage);
3646: raise_application_error(errorCode,

Line 3654: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

3650: errorCode := -20001;
3651: errorMessage :=
3652: ame_util.getMessage(applicationShortNameIn => 'PER',
3653: messageNameIn => 'AME_400167_ATT_STAT_USG_BOOL');
3654: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
3655: routineNameIn => 'newAttributeUsage',
3656: exceptionNumberIn => errorCode,
3657: exceptionStringIn => errorMessage);
3658: raise_application_error(errorCode,

Line 3666: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

3662: errorCode := -20001;
3663: errorMessage :=
3664: ame_util.getMessage(applicationShortNameIn => 'PER',
3665: messageNameIn => 'AME_400168_ATT_STAT_USG_DATE');
3666: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
3667: routineNameIn => 'newAttributeUsage',
3668: exceptionNumberIn => errorCode,
3669: exceptionStringIn => errorMessage);
3670: raise_application_error(errorCode,

Line 3674: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

3670: raise_application_error(errorCode,
3671: errorMessage);
3672: when others then
3673: rollback;
3674: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
3675: routineNameIn => 'newAttributeUsage',
3676: exceptionNumberIn => sqlcode,
3677: exceptionStringIn => '(attribute ID ' ||
3678: attributeIdIn||

Line 3801: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

3797: end loop;
3798: exception
3799: when others then
3800: rollback;
3801: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
3802: routineNameIn => 'newMandatoryAttributes',
3803: exceptionNumberIn => sqlcode,
3804: exceptionStringIn => '(attribute ID ' ||
3805: attributeIdIn||

Line 3864: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

3860: end if;
3861: exception
3862: when others then
3863: rollback;
3864: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
3865: routineNameIn => 'remove',
3866: exceptionNumberIn => sqlcode,
3867: exceptionStringIn => '(attribute ID ' ||
3868: attributeIdIn||

Line 3908: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

3904: end loop;
3905: exception
3906: when others then
3907: rollback;
3908: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
3909: routineNameIn => 'removeMandatoryAttributes',
3910: exceptionNumberIn => sqlcode,
3911: exceptionStringIn => '(attribute ID ' ||
3912: attributeIdIn||

Line 4048: ame_attribute_pkg.remove(attributeIdIn => attributeIdIn,

4044: approverTypeIdIn => approverTypeId,
4045: finalizeIn => false,
4046: itemClassIdIn => itemClassIdIn);
4047: else
4048: ame_attribute_pkg.remove(attributeIdIn => attributeIdIn,
4049: finalizeIn => false);
4050: end if;
4051: close startDateCursor;
4052: close startDateCursor2;

Line 4069: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

4065: errorMessage := ame_util.getMessage(applicationShortNameIn => 'PER',
4066: messageNameIn => 'AME_400309_ATT_NAME_STRP_ATTR',
4067: tokenNameOneIn => 'ATTRIBUTE_NAME',
4068: tokenValueOneIn => attributeName);
4069: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
4070: routineNameIn => 'removeUsage',
4071: exceptionNumberIn => errorCode,
4072: exceptionStringIn => errorMessage);
4073: raise_application_error(errorCode,

Line 4088: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

4084: errorCode := -20001;
4085: errorMessage :=
4086: ame_util.getMessage(applicationShortNameIn => 'PER',
4087: messageNameIn => 'AME_400170_ATT_MAND_CANT_DEL');
4088: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
4089: routineNameIn => 'removeUsage',
4090: exceptionNumberIn => errorCode,
4091: exceptionStringIn => errorMessage);
4092: raise_application_error(errorCode,

Line 4106: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

4102: errorCode := -20001;
4103: errorMessage :=
4104: ame_util.getMessage(applicationShortNameIn => 'PER',
4105: messageNameIn => 'AME_400171_ATT_IS_IN_USE');
4106: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
4107: routineNameIn => 'removeUsage',
4108: exceptionNumberIn => errorCode,
4109: exceptionStringIn => errorMessage);
4110: raise_application_error(errorCode,

Line 4124: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

4120: errorCode := -20001;
4121: errorMessage :=
4122: ame_util.getMessage(applicationShortNameIn => 'PER',
4123: messageNameIn => 'AME_400143_ACT_OBJECT_CHNGED');
4124: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
4125: routineNameIn => 'removeUsage',
4126: exceptionNumberIn => errorCode,
4127: exceptionStringIn => errorMessage);
4128: raise_application_error(errorCode,

Line 4142: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

4138: errorCode := -20001;
4139: errorMessage :=
4140: ame_util.getMessage(applicationShortNameIn => 'PER',
4141: messageNameIn => 'AME_400145_ACT_OBJECT_DELETED');
4142: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
4143: routineNameIn => 'removeUsage',
4144: exceptionNumberIn => errorCode,
4145: exceptionStringIn => errorMessage);
4146: raise_application_error(errorCode,

Line 4156: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

4152: end if;
4153: if(startDateCursor2%isOpen) then
4154: close startDateCursor2;
4155: end if;
4156: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
4157: routineNameIn => 'removeUsage',
4158: exceptionNumberIn => sqlcode,
4159: exceptionStringIn => '(attribute ID ' ||
4160: attributeIdIn||

Line 4234: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

4230: commit;
4231: exception
4232: when others then
4233: rollback;
4234: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
4235: routineNameIn => 'setStripingAttributesToNull',
4236: exceptionNumberIn => sqlcode,
4237: exceptionStringIn => sqlerrm);
4238: raise;

Line 4262: staticUsage := ame_attribute_pkg.getStaticUsage(attributeIdIn => attributeIdIn,

4258: begin
4259: processingDate := sysdate;
4260: queryString := getQueryString(attributeIdIn => attributeIdIn,
4261: applicationIdIn => applicationIdIn);
4262: staticUsage := ame_attribute_pkg.getStaticUsage(attributeIdIn => attributeIdIn,
4263: applicationIdIn => applicationIdIn);
4264: /*
4265: AME_STRIPING
4266: if(isStripingAttribute(attributeIdIn => attributeIdIn,

Line 4305: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

4301: errorCode := -20001;
4302: errorMessage :=
4303: ame_util.getMessage(applicationShortNameIn => 'PER',
4304: messageNameIn => 'AME_400172_ATT_NULL_ATT_USAGE');
4305: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
4306: routineNameIn => 'updateUseCount',
4307: exceptionNumberIn => errorCode,
4308: exceptionStringIn => errorMessage);
4309: raise_application_error(errorCode,

Line 4313: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

4309: raise_application_error(errorCode,
4310: errorMessage);
4311: when others then
4312: rollback;
4313: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
4314: routineNameIn => 'updateUseCount',
4315: exceptionNumberIn => sqlcode,
4316: exceptionStringIn => '(attribute ID ' ||
4317: attributeIdIn||

Line 4348: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',

4344: commit;
4345: exception
4346: when others then
4347: rollback;
4348: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
4349: routineNameIn => 'updateUseCount2',
4350: exceptionNumberIn => sqlcode,
4351: exceptionStringIn => '(rule ID ' ||
4352: ruleIdIn||

Line 4357: end ame_attribute_pkg;

4353: ') ' ||
4354: sqlerrm);
4355: raise;
4356: end updateUseCount2;
4357: end ame_attribute_pkg;