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_ADMIN_PKG dependencies on AME_ADMIN_PKG

Line 1: package body ame_admin_pkg as

1: package body ame_admin_pkg as
2: /* $Header: ameoadmi.pkb 120.2 2006/12/26 13:28:43 avarri noship $ */
3: function arePrioritiesDisabled(applicationIdIn in integer) return boolean is
4: begin
5: if(ame_util.getConfigVar(variableNameIn => ame_util.rulePriorityModesConfigVar,

Line 14: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

10: return(false);
11: exception
12: when others then
13: rollback;
14: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
15: routineNameIn => 'arePrioritiesDisabled',
16: exceptionNumberIn => sqlcode,
17: exceptionStringIn => sqlerrm);
18: raise;

Line 42: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

38: return(true);
39: exception
40: when others then
41: rollback;
42: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
43: routineNameIn => 'canHaveItemAttributes',
44: exceptionNumberIn => sqlcode,
45: exceptionStringIn => sqlerrm);
46: raise;

Line 67: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

63: return(stringStartDate);
64: exception
65: when others then
66: rollback;
67: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
68: routineNameIn => 'getChildVersionStartDate',
69: exceptionNumberIn => sqlcode,
70: exceptionStringIn => '(item class ID ' ||
71: itemClassIdIn||

Line 96: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

92: return(false);
93: exception
94: when others then
95: rollback;
96: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
97: routineNameIn => 'doesStripeSetIdExist',
98: exceptionNumberIn => sqlcode,
99: exceptionStringIn => sqlerrm);
100: raise;

Line 127: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

123: when no_data_found then
124: return(null);
125: when others then
126: rollback;
127: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
128: routineNameIn => 'getEqualityConditionId',
129: exceptionNumberIn => sqlcode,
130: exceptionStringIn => sqlerrm);
131: raise;

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

147: return(appId);
148: exception
149: when others then
150: rollback;
151: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
152: routineNameIn => 'getApplicationId',
153: exceptionNumberIn => sqlcode,
154: exceptionStringIn => sqlerrm);
155: raise;

Line 172: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

168: return(appId);
169: exception
170: when others then
171: rollback;
172: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
173: routineNameIn => 'getApplicationIdByName',
174: exceptionNumberIn => sqlcode,
175: exceptionStringIn => sqlerrm);
176: raise;

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

189: return(applicationName);
190: exception
191: when others then
192: rollback;
193: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
194: routineNameIn => 'getApplicationName',
195: exceptionNumberIn => sqlcode,
196: exceptionStringIn => sqlerrm);
197: raise;

Line 212: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

208: return(attributeValueIn);
209: exception
210: when others then
211: rollback;
212: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
213: routineNameIn => 'getAttributeDisplayValue',
214: exceptionNumberIn => sqlcode,
215: exceptionStringIn => sqlerrm);
216: raise;

Line 230: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

226: return queryCursor;
227: exception
228: when others then
229: rollback;
230: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
231: routineNameIn => 'getAttributeQuery',
232: exceptionNumberIn => sqlcode,
233: exceptionStringIn => sqlerrm);
234: raise;

Line 259: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

255: return(ruleCount);
256: exception
257: when others then
258: rollback;
259: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
260: routineNameIn => 'getAttributeStripingUseCount',
261: exceptionNumberIn => sqlcode,
262: exceptionStringIn => sqlerrm);
263: raise;

Line 278: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

274: return(description);
275: exception
276: when others then
277: rollback;
278: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
279: routineNameIn => 'getFndAppDescription',
280: exceptionNumberIn => sqlcode,
281: exceptionStringIn => sqlerrm);
282: raise;

Line 303: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

299: return(description);
300: exception
301: when others then
302: rollback;
303: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
304: routineNameIn => 'getFndAppDescription1',
305: exceptionNumberIn => sqlcode,
306: exceptionStringIn => sqlerrm);
307: raise;

Line 324: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

320: return fndApplicationId;
321: exception
322: when others then
323: rollback;
324: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
325: routineNameIn => 'getFndApplicationId',
326: exceptionNumberIn => sqlcode,
327: exceptionStringIn => sqlerrm);
328: raise;

Line 344: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

340: return(itemClassCount);
341: exception
342: when others then
343: rollback;
344: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
345: routineNameIn => 'getItemClassCount',
346: exceptionNumberIn => sqlcode,
347: exceptionStringIn => sqlerrm);
348: raise;

Line 365: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

361: return(itemId);
362: exception
363: when others then
364: rollback;
365: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
366: routineNameIn => 'getItemClassIdByName',
367: exceptionNumberIn => sqlcode,
368: exceptionStringIn => '(item name ' ||
369: itemClassNameIn||

Line 391: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

387: return(itemIdQuery);
388: exception
389: when others then
390: rollback;
391: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
392: routineNameIn => 'getItemClassIdQuery',
393: exceptionNumberIn => sqlcode,
394: exceptionStringIn => sqlerrm);
395: raise;

Line 412: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

408: return(itemName);
409: exception
410: when others then
411: rollback;
412: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
413: routineNameIn => 'getItemClassName',
414: exceptionNumberIn => sqlcode,
415: exceptionStringIn => '(item class ID ' ||
416: itemClassIdIn||

Line 438: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

434: when no_data_found then
435: return(null);
436: when others then
437: rollback;
438: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
439: routineNameIn => 'getLineItemQueryString',
440: exceptionNumberIn => sqlcode,
441: exceptionStringIn => sqlerrm);
442: raise;

Line 459: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

455: return(orderNumber);
456: exception
457: when others then
458: rollback;
459: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
460: routineNameIn => 'getItemClassMaxOrderNumber',
461: exceptionNumberIn => sqlcode,
462: exceptionStringIn => sqlerrm);
463: raise;

Line 482: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

478: return(itemClassOrderNumber);
479: exception
480: when others then
481: rollback;
482: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
483: routineNameIn => 'getItemClassOrderNumber',
484: exceptionNumberIn => sqlcode,
485: exceptionStringIn => sqlerrm);
486: raise;

Line 503: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

499: return(tempCount);
500: exception
501: when others then
502: rollback;
503: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
504: routineNameIn => 'getItemClassTransTypeCount',
505: exceptionNumberIn => sqlcode,
506: exceptionStringIn => sqlerrm);
507: raise;

Line 526: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

522: return(itemClassParMode);
523: exception
524: when others then
525: rollback;
526: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
527: routineNameIn => 'getItemClassParMode',
528: exceptionNumberIn => sqlcode,
529: exceptionStringIn => sqlerrm);
530: raise;

Line 549: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

545: return(stringStartDate);
546: exception
547: when others then
548: rollback;
549: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
550: routineNameIn => 'getParentVersionStartDate',
551: exceptionNumberIn => sqlcode,
552: exceptionStringIn => '(item class ID ' ||
553: itemClassIdIn||

Line 575: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

571: return(itemClassSublistMode);
572: exception
573: when others then
574: rollback;
575: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
576: routineNameIn => 'getItemClassSublistMode',
577: exceptionNumberIn => sqlcode,
578: exceptionStringIn => sqlerrm);
579: raise;

Line 601: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

597: return(itemId);
598: exception
599: when others then
600: rollback;
601: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
602: routineNameIn => 'getSubordinateItemClassId',
603: exceptionNumberIn => sqlcode,
604: exceptionStringIn => sqlerrm);
605: raise;

Line 623: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

619: when no_data_found then
620: return(null);
621: when others then
622: rollback;
623: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
624: routineNameIn => 'getTransactionTypeId',
625: exceptionNumberIn => sqlcode,
626: exceptionStringIn => sqlerrm);
627: raise;

Line 646: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

642: return(stringStartDate);
643: exception
644: when others then
645: rollback;
646: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
647: routineNameIn => 'getVersionStartDate',
648: exceptionNumberIn => sqlcode,
649: exceptionStringIn => sqlerrm);
650: raise;

Line 673: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

669: return(stringStartDate);
670: exception
671: when others then
672: rollback;
673: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
674: routineNameIn => 'getVersionStartDate2',
675: exceptionNumberIn => sqlcode,
676: exceptionStringIn => sqlerrm);
677: raise;

Line 704: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

700: return(false);
701: exception
702: when others then
703: rollback;
704: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
705: routineNameIn => 'hasLineItemAttributes',
706: exceptionNumberIn => sqlcode,
707: exceptionStringIn => sqlerrm);
708: raise;

Line 730: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

726: return(false);
727: exception
728: when others then
729: rollback;
730: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
731: routineNameIn => 'hasRuleStripes',
732: exceptionNumberIn => sqlcode,
733: exceptionStringIn => sqlerrm);
734: raise;

Line 762: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

758: return(false);
759: exception
760: when others then
761: rollback;
762: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
763: routineNameIn => 'icInUseByAttributeUsage',
764: exceptionNumberIn => sqlcode,
765: exceptionStringIn => sqlerrm);
766: raise;

Line 793: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

789: return(false);
790: exception
791: when others then
792: rollback;
793: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
794: routineNameIn => 'icInUseByRuleUsage',
795: exceptionNumberIn => sqlcode,
796: exceptionStringIn => sqlerrm);
797: raise;

Line 839: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

835: errorCode := -20001;
836: errorMessage :=
837: ame_util.getMessage(applicationShortNameIn => 'PER',
838: messageNameIn => 'AME_400150_ATT_STA_CONV_INV');
839: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
840: routineNameIn => 'inputToCanonStaticCurUsage',
841: exceptionNumberIn => errorCode,
842: exceptionStringIn => errorMessage); /* Runtime code doesn't validate input. */
843: raise_application_error(errorCode,

Line 852: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

848: errorCode := -20001;
849: errorMessage :=
850: ame_util.getMessage(applicationShortNameIn => 'PER',
851: messageNameIn => 'AME_400151_ATT_STA_CURR_INV');
852: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
853: routineNameIn => 'inputToCanonStaticCurUsage',
854: exceptionNumberIn => errorCode,
855: exceptionStringIn => errorMessage); /* Runtime code doesn't validate input. */
856: raise_application_error(errorCode,

Line 861: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

857: errorMessage);
858: return(null);
859: when others then
860: rollback;
861: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
862: routineNameIn => 'inputToCanonStaticCurUsage',
863: exceptionNumberIn => sqlcode,
864: exceptionStringIn => sqlerrm); /* Runtime code doesn't validate input. */
865: raise;

Line 885: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

881: return(false);
882: exception
883: when others then
884: rollback;
885: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
886: routineNameIn => 'isApplicationActive',
887: exceptionNumberIn => sqlcode,
888: exceptionStringIn => sqlerrm);
889: raise;

Line 914: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

910: rollback;
911: return(false);
912: when others then
913: rollback;
914: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
915: routineNameIn => 'isInUseByApplication',
916: exceptionNumberIn => sqlcode,
917: exceptionStringIn => '(item class ID ' ||
918: itemClassIdIn||

Line 940: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

936: return(false);
937: exception
938: when others then
939: rollback;
940: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
941: routineNameIn => 'isSeeded',
942: exceptionNumberIn => sqlcode,
943: exceptionStringIn => sqlerrm);
944: raise;

Line 968: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

964: when no_data_found then
965: return(false);
966: when others then
967: rollback;
968: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
969: routineNameIn => 'isStripingOn',
970: exceptionNumberIn => sqlcode,
971: exceptionStringIn => sqlerrm);
972: raise;

Line 1041: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

1037: return(stripeSetId);
1038: exception
1039: when others then
1040: rollback;
1041: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
1042: routineNameIn => 'newStripeSet',
1043: exceptionNumberIn => sqlcode,
1044: exceptionStringIn => sqlerrm);
1045: raise;

Line 1074: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

1070: when no_data_found then
1071: return(null);
1072: when others then
1073: rollback;
1074: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
1075: routineNameIn => 'getStripeSetId',
1076: exceptionNumberIn => sqlcode,
1077: exceptionStringIn => sqlerrm);
1078: raise;

Line 1099: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

1095: return(false);
1096: exception
1097: when others then
1098: rollback;
1099: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
1100: routineNameIn => 'itemClassNameExists',
1101: exceptionNumberIn => sqlcode,
1102: exceptionStringIn => sqlerrm);
1103: raise;

Line 1210: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

1206: errorCode := -20001;
1207: errorMessage :=
1208: ame_util.getMessage(applicationShortNameIn => 'PER',
1209: messageNameIn => 'AME_400374_ADM IC_NAME_EXISTS');
1210: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
1211: routineNameIn => 'newItemClass',
1212: exceptionNumberIn => errorCode,
1213: exceptionStringIn => errorMessage);
1214: raise_application_error(errorCode,

Line 1226: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

1222: messageNameIn => 'AME_400375_ADM IC_NAME_LONG',
1223: tokenNameOneIn => 'COLUMN_LENGTH',
1224: tokenValueOneIn => ame_util.getColumnLength(tableNameIn => 'ame_item_classes',
1225: columnNameIn => 'name'));
1226: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
1227: routineNameIn => 'newItemClass',
1228: exceptionNumberIn => errorCode,
1229: exceptionStringIn => errorMessage);
1230: raise_application_error(errorCode,

Line 1235: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

1231: errorMessage);
1232: return(null);
1233: when others then
1234: rollback;
1235: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
1236: routineNameIn => 'newItemClass',
1237: exceptionNumberIn => sqlcode,
1238: exceptionStringIn => '(item class ID ' ||
1239: itemClassIdIn||

Line 1265: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

1261: end if;
1262: exception
1263: when others then
1264: rollback;
1265: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
1266: routineNameIn => 'orderNumberUnique',
1267: exceptionNumberIn => sqlcode,
1268: exceptionStringIn => sqlerrm);
1269: raise;

Line 1291: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

1287: return(itemClassCount);
1288: exception
1289: when others then
1290: rollback;
1291: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
1292: routineNameIn => 'subordinateItemClassCount',
1293: exceptionNumberIn => sqlcode,
1294: exceptionStringIn => sqlerrm);
1295: raise;

Line 1317: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

1313: return(false);
1314: exception
1315: when others then
1316: rollback;
1317: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
1318: routineNameIn => 'transTypeCVValueExists',
1319: exceptionNumberIn => sqlcode,
1320: exceptionStringIn => sqlerrm);
1321: raise;

Line 1562: tempStripeSetId := ame_admin_pkg.getStripeSetId(applicationIdIn => applicationIdIn,

1558: /* Now create new stripe sets and rule-stripe-set assignments as needed. */
1559: /*
1560: for i in 1 .. lastRuleHavingIndex loop
1561: stripingAttributeValues(1) := stringValues(i);
1562: tempStripeSetId := ame_admin_pkg.getStripeSetId(applicationIdIn => applicationIdIn,
1563: attributeValuesIn => stripingAttributeValues);
1564: if(tempStripeSetId is null) then
1565: tempStripeSetId := ame_admin_pkg.newStripeSet(applicationIdIn => applicationIdIn,
1566: attributeValuesIn => stripingAttributeValues);

Line 1565: tempStripeSetId := ame_admin_pkg.newStripeSet(applicationIdIn => applicationIdIn,

1561: stripingAttributeValues(1) := stringValues(i);
1562: tempStripeSetId := ame_admin_pkg.getStripeSetId(applicationIdIn => applicationIdIn,
1563: attributeValuesIn => stripingAttributeValues);
1564: if(tempStripeSetId is null) then
1565: tempStripeSetId := ame_admin_pkg.newStripeSet(applicationIdIn => applicationIdIn,
1566: attributeValuesIn => stripingAttributeValues);
1567: end if;
1568: ame_rule_pkg.newRuleStripeSet(applicationIdIn => applicationIdIn,
1569: ruleIdIn => ruleIds(i),

Line 1574: tempStripeSetId := ame_admin_pkg.newStripeSet(applicationIdIn => applicationIdIn,

1570: stripeSetIdIn => tempStripeSetId);
1571: end loop;
1572: if(firstRuleLackingIndex is not null) then
1573: stripingAttributeValues(1) := ame_util.stripeWildcard;
1574: tempStripeSetId := ame_admin_pkg.newStripeSet(applicationIdIn => applicationIdIn,
1575: attributeValuesIn => stripingAttributeValues);
1576: for i in firstRuleLackingIndex .. ruleIds.count loop
1577: ame_rule_pkg.newRuleStripeSet(applicationIdIn => applicationIdIn,
1578: ruleIdIn => ruleIds(i),

Line 1628: tempStripeSetId := ame_admin_pkg.getStripeSetId(applicationIdIn => applicationIdIn,

1624: stripingAttributeValues(3) := oldStripeSet.value_3;
1625: stripingAttributeValues(4) := oldStripeSet.value_4;
1626: stripingAttributeValues(5) := oldStripeSet.value_5;
1627: stripingAttributeValues(newStripingAttributeIndex) := stringValues(i);
1628: tempStripeSetId := ame_admin_pkg.getStripeSetId(applicationIdIn => applicationIdIn,
1629: attributeValuesIn => stripingAttributeValues);
1630: if(tempStripeSetId is null) then
1631: tempStripeSetId := ame_admin_pkg.newStripeSet(applicationIdIn => applicationIdIn,
1632: attributeValuesIn => stripingAttributeValues);

Line 1631: tempStripeSetId := ame_admin_pkg.newStripeSet(applicationIdIn => applicationIdIn,

1627: stripingAttributeValues(newStripingAttributeIndex) := stringValues(i);
1628: tempStripeSetId := ame_admin_pkg.getStripeSetId(applicationIdIn => applicationIdIn,
1629: attributeValuesIn => stripingAttributeValues);
1630: if(tempStripeSetId is null) then
1631: tempStripeSetId := ame_admin_pkg.newStripeSet(applicationIdIn => applicationIdIn,
1632: attributeValuesIn => stripingAttributeValues);
1633: end if;
1634: ame_rule_pkg.newRuleStripeSet(applicationIdIn => applicationIdIn,
1635: ruleIdIn => ruleIds(i),

Line 1680: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

1676: errorMessage :=
1677: 'The attribute ' ||
1678: ame_attribute_pkg.getName(attributeIdIn => attributeIdIn) ||
1679: ' is already a striping attribute for this transaction type. ';
1680: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
1681: routineNameIn => 'addStripingAttribute',
1682: exceptionNumberIn => errorCode,
1683: exceptionStringIn => errorMessage);
1684: raise_application_error(errorCode,

Line 1697: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

1693: end if;
1694: if(oldRuleStripeSetCursor%isopen) then
1695: close oldRuleStripeSetCursor;
1696: end if;
1697: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
1698: routineNameIn => 'addStripingAttribute',
1699: exceptionNumberIn => sqlcode,
1700: exceptionStringIn => sqlerrm);
1701: raise;

Line 1802: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

1798: errorCode := -20001;
1799: errorMessage :=
1800: ame_util.getMessage(applicationShortNameIn => 'PER',
1801: messageNameIn => 'AME_400173_ADM_TTY_NOT_NULL_ID');
1802: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
1803: routineNameIn => 'change',
1804: exceptionNumberIn => errorCode,
1805: exceptionStringIn => errorMessage);
1806: raise_application_error(errorCode,

Line 1817: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

1813: errorCode := -20001;
1814: errorMessage :=
1815: ame_util.getMessage(applicationShortNameIn => 'PER',
1816: messageNameIn => 'AME_400174_ADM_LIN_QRY_ORD_BY');
1817: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
1818: routineNameIn => 'change',
1819: exceptionNumberIn => errorCode,
1820: exceptionStringIn => errorMessage);
1821: raise_application_error(errorCode,

Line 1832: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

1828: errorCode := -20001;
1829: errorMessage :=
1830: ame_util.getMessage(applicationShortNameIn => 'PER',
1831: messageNameIn => 'AME_400143_ACT_OBJECT_CHNGED');
1832: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
1833: routineNameIn => 'change',
1834: exceptionNumberIn => errorCode,
1835: exceptionStringIn => errorMessage);
1836: raise_application_error(errorCode,

Line 1847: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

1843: errorCode := -20001;
1844: errorMessage :=
1845: ame_util.getMessage(applicationShortNameIn => 'PER',
1846: messageNameIn => 'AME_400145_ACT_OBJECT_DELETED');
1847: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
1848: routineNameIn => 'change',
1849: exceptionNumberIn => errorCode,
1850: exceptionStringIn => errorMessage);
1851: raise_application_error(errorCode,

Line 1858: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

1854: rollback;
1855: if(startDateCursor%isOpen) then
1856: close startDateCursor;
1857: end if;
1858: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
1859: routineNameIn => 'change',
1860: exceptionNumberIn => sqlcode,
1861: exceptionStringIn => sqlerrm);
1862: raise;

Line 1893: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

1889: end if;
1890: exception
1891: when others then
1892: rollback;
1893: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
1894: routineNameIn => 'changeItemClass',
1895: exceptionNumberIn => sqlcode,
1896: exceptionStringIn => '(item class ID ' ||
1897: itemClassIdIn||

Line 1982: ame_admin_pkg.changeItemClass(itemClassIdIn => itemClassIdIn,

1978: return;
1979: end if;
1980: /* Get current values as necessary for update. */
1981: newStartAndEndDate := sysdate;
1982: ame_admin_pkg.changeItemClass(itemClassIdIn => itemClassIdIn,
1983: itemClassNameIn => itemClassNameIn,
1984: endDateIn => newStartAndEndDate,
1985: startDateIn => newStartAndEndDate,
1986: finalizeIn => false);

Line 1987: ame_admin_pkg.changeUsage(itemClassIdIn => itemClassIdIn,

1983: itemClassNameIn => itemClassNameIn,
1984: endDateIn => newStartAndEndDate,
1985: startDateIn => newStartAndEndDate,
1986: finalizeIn => false);
1987: ame_admin_pkg.changeUsage(itemClassIdIn => itemClassIdIn,
1988: applicationIdIn => applicationIdIn,
1989: itemClassParModeIn => itemClassParModeIn,
1990: itemClassSublistModeIn => itemClassSublistModeIn,
1991: itemClassIdQueryIn => itemClassIdQueryIn,

Line 2015: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

2011: errorCode := -20001;
2012: errorMessage :=
2013: ame_util.getMessage(applicationShortNameIn => 'PER',
2014: messageNameIn => 'AME_400143_ACT_OBJECT_CHNGED');
2015: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
2016: routineNameIn => 'changeItemClassAndUsage',
2017: exceptionNumberIn => errorCode,
2018: exceptionStringIn => errorMessage);
2019: raise_application_error(errorCode,

Line 2033: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

2029: errorCode := -20001;
2030: errorMessage :=
2031: ame_util.getMessage(applicationShortNameIn => 'PER',
2032: messageNameIn => 'AME_400145_ACT_OBJECT_DELETED');
2033: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
2034: routineNameIn => 'changeItemClassAndUsage',
2035: exceptionNumberIn => errorCode,
2036: exceptionStringIn => errorMessage);
2037: raise_application_error(errorCode,

Line 2047: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

2043: end if;
2044: if(startDateCursor2%isOpen) then
2045: close startDateCursor2;
2046: end if;
2047: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
2048: routineNameIn => 'changeItemClassAndUsage',
2049: exceptionNumberIn => sqlcode,
2050: exceptionStringIn => '(item class ID ' ||
2051: itemClassIdIn||

Line 2079: if(ame_admin_pkg.orderNumberUnique(applicationIdIn => applicationIdIn,

2075: updateOnlyICModified boolean;
2076: begin
2077: oldOrderNumber := getItemClassOrderNumber(applicationIdIn => applicationIdIn,
2078: itemClassIdIn => itemClassIdIn);
2079: if(ame_admin_pkg.orderNumberUnique(applicationIdIn => applicationIdIn,
2080: orderNumberIn => oldOrderNumber)) then
2081: oldOrderNumberUnique := ame_util.yes;
2082: else
2083: oldOrderNumberUnique := ame_util.no;

Line 2202: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

2198: end if;
2199: exception
2200: when others then
2201: rollback;
2202: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
2203: routineNameIn => 'changeUsage',
2204: exceptionNumberIn => sqlcode,
2205: exceptionStringIn => '(item class ID ' ||
2206: itemClassIdIn||

Line 2277: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

2273: errorCode := -20001;
2274: errorMessage :=
2275: ame_util.getMessage(applicationShortNameIn => 'PER',
2276: messageNameIn => 'AME_400175_ADM_TTY_ID_ALREADY');
2277: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
2278: routineNameIn => 'checkNewOrChangedTransType',
2279: exceptionNumberIn => errorCode,
2280: exceptionStringIn => errorMessage);
2281: raise_application_error(errorCode,

Line 2289: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

2285: errorCode := -20001;
2286: errorMessage :=
2287: ame_util.getMessage(applicationShortNameIn => 'PER',
2288: messageNameIn => 'AME_400176_ADM_TTY_HAS_DESC');
2289: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
2290: routineNameIn => 'checkNewOrChangedTransType',
2291: exceptionNumberIn => errorCode,
2292: exceptionStringIn => errorMessage);
2293: raise_application_error(errorCode,

Line 2300: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

2296: errorCode := -20001;
2297: errorMessage :=
2298: ame_util.getMessage(applicationShortNameIn => 'PER',
2299: messageNameIn => 'AME_400177_ADM_TTY_EXIST_NULL');
2300: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
2301: routineNameIn => 'checkNewOrChangedTransType',
2302: exceptionNumberIn => errorCode,
2303: exceptionStringIn => errorMessage);
2304: raise_application_error(errorCode,

Line 2312: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

2308: errorCode := -20001;
2309: errorMessage :=
2310: ame_util.getMessage(applicationShortNameIn => 'PER',
2311: messageNameIn => 'AME_400178_ADM_TTY_EXIST_NONUL');
2312: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
2313: routineNameIn => 'checkNewOrChangedTransType',
2314: exceptionNumberIn => errorCode,
2315: exceptionStringIn => errorMessage);
2316: raise_application_error(errorCode,

Line 2320: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

2316: raise_application_error(errorCode,
2317: errorMessage);
2318: when others then
2319: rollback;
2320: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
2321: routineNameIn => 'checkNewOrChangedTransType',
2322: exceptionNumberIn => sqlcode,
2323: exceptionStringIn => sqlerrm);
2324: raise;

Line 2353: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

2349: end if;
2350: exception
2351: when others then
2352: rollback;
2353: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
2354: routineNameIn => 'checkStripeSetUsage',
2355: exceptionNumberIn => sqlcode,
2356: exceptionStringIn => sqlerrm);
2357: raise;

Line 2371: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

2367: commit;
2368: exception
2369: when others then
2370: rollback;
2371: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
2372: routineNameIn => 'clearTransException',
2373: exceptionNumberIn => sqlcode,
2374: exceptionStringIn => sqlerrm);
2375: raise;

Line 2391: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

2387: commit;
2388: exception
2389: when others then
2390: rollback;
2391: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
2392: routineNameIn => 'clearTransTypeConfigVarValue',
2393: exceptionNumberIn => sqlcode,
2394: exceptionStringIn => sqlerrm);
2395: raise;

Line 2405: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

2401: commit;
2402: exception
2403: when others then
2404: rollback;
2405: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
2406: routineNameIn => 'clearTransTypeExceptions',
2407: exceptionNumberIn => sqlcode,
2408: exceptionStringIn => sqlerrm);
2409: raise;

Line 2421: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

2417: commit;
2418: exception
2419: when others then
2420: rollback;
2421: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
2422: routineNameIn => 'clearWebExceptions',
2423: exceptionNumberIn => sqlcode,
2424: exceptionStringIn => sqlerrm);
2425: raise;

Line 2505: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

2501: end if;
2502: exception
2503: when others then
2504: rollback;
2505: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
2506: routineNameIn => 'decrementItemClassOrderNumbers',
2507: exceptionNumberIn => sqlcode,
2508: exceptionStringIn => sqlerrm);
2509: raise;

Line 2621: ame_admin_pkg.getStripingAttributeIds(applicationIdIn => applicationIdIn,

2617: /* indexed consecutively, reused */
2618: /*
2619: tempStripeSetId integer;
2620: begin
2621: ame_admin_pkg.getStripingAttributeIds(applicationIdIn => applicationIdIn,
2622: stripingAttributeIdsOut => stripingAttributeIds);
2623: stripingAttributeCount := stripingAttributeIds.count;
2624: if(stripingAttributeCount = 0) then
2625: raise noStripingAttsException;

Line 2690: tempStripeSetId := ame_admin_pkg.getStripeSetId(applicationIdIn => applicationIdIn,

2686: tempConditionValues(k) := stripingConditionValues(tempConditionIds(j));
2687: end if;
2688: end loop;
2689: end loop;
2690: tempStripeSetId := ame_admin_pkg.getStripeSetId(applicationIdIn => applicationIdIn,
2691: attributeValuesIn => tempConditionValues);
2692: if(tempStripeSetId is null) then
2693: tempStripeSetId := ame_admin_pkg.newStripeSet(applicationIdIn => applicationIdIn,
2694: attributeValuesIn => tempConditionValues);

Line 2693: tempStripeSetId := ame_admin_pkg.newStripeSet(applicationIdIn => applicationIdIn,

2689: end loop;
2690: tempStripeSetId := ame_admin_pkg.getStripeSetId(applicationIdIn => applicationIdIn,
2691: attributeValuesIn => tempConditionValues);
2692: if(tempStripeSetId is null) then
2693: tempStripeSetId := ame_admin_pkg.newStripeSet(applicationIdIn => applicationIdIn,
2694: attributeValuesIn => tempConditionValues);
2695: end if;
2696: ame_rule_pkg.newRuleStripeSet(applicationIdIn => applicationIdIn,
2697: ruleIdIn => ruleIds(i),

Line 2708: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

2704: when noStripingAttsException then
2705: rollback;
2706: errorCode := -20001;
2707: errorMessage := 'At least one striping attribute must be selected to enable rule striping. ';
2708: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
2709: routineNameIn => 'enableRuleStriping',
2710: exceptionNumberIn => errorCode,
2711: exceptionStringIn => errorMessage);
2712: raise_application_error(errorCode,

Line 2725: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

2721: end if;
2722: if(ruleStripingCondCursor%isopen) then
2723: close ruleStripingCondCursor;
2724: end if;
2725: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
2726: routineNameIn => 'enableRuleStriping',
2727: exceptionNumberIn => sqlcode,
2728: exceptionStringIn => sqlerrm);
2729: raise;

Line 2791: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

2787: end if;
2788: exception
2789: when others then
2790: rollback;
2791: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
2792: routineNameIn => 'getAttributeStripeSetNames',
2793: exceptionNumberIn => sqlcode,
2794: exceptionStringIn => sqlerrm);
2795: stripingAttributeIdsOut := ame_util.emptyIdList;

Line 2855: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

2851: */
2852: exception
2853: when others then
2854: rollback;
2855: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
2856: routineNameIn => 'getConfigVariables',
2857: exceptionNumberIn => sqlcode,
2858: exceptionStringIn => sqlerrm);
2859: variableNamesOut := ame_util.emptyStringList;

Line 2902: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

2898: end loop;
2899: exception
2900: when others then
2901: rollback;
2902: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
2903: routineNameIn => 'getExistingShareableIClasses',
2904: exceptionNumberIn => sqlcode,
2905: exceptionStringIn => '(application ID ' ||
2906: applicationIdIn||

Line 2933: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

2929: end loop;
2930: exception
2931: when others then
2932: rollback;
2933: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
2934: routineNameIn => 'getFndApplications',
2935: exceptionNumberIn => sqlcode,
2936: exceptionStringIn => sqlerrm);
2937: fndAppIdsOut := ame_util.emptyStringList;

Line 2971: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

2967: forwardingBehaviorLabelsOut(valueIndex) := ame_util.getLabel(ame_util.perFndAppId,'AME_IGNORE_FORWARDING');
2968: exception
2969: when others then
2970: rollback;
2971: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
2972: routineNameIn => 'getForwardingBehaviorList',
2973: exceptionNumberIn => sqlcode,
2974: exceptionStringIn => sqlerrm);
2975: forwardingBehaviorValuesOut := ame_util.emptyStringList;

Line 3009: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

3005: end loop;
3006: exception
3007: when others then
3008: rollback;
3009: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
3010: routineNameIn => 'getItemClassList',
3011: exceptionNumberIn => sqlcode,
3012: exceptionStringIn => sqlerrm);
3013: itemClassIdListOut := ame_util.emptyIdList;

Line 3039: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

3035: end loop;
3036: exception
3037: when others then
3038: rollback;
3039: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
3040: routineNameIn => 'getStripeSetIds',
3041: exceptionNumberIn => sqlcode,
3042: exceptionStringIn => sqlerrm);
3043: stripeSetIdsOut := ame_util.emptyIdList;

Line 3167: ame_util.runtimeException(packageNamein => 'ame_admin_pkg',

3163: close attributeCur;
3164: exception
3165: when others then
3166: rollback;
3167: ame_util.runtimeException(packageNamein => 'ame_admin_pkg',
3168: routineNamein => 'getStripeSetList',
3169: exceptionNumberIn => sqlcode,
3170: exceptionStringIn => sqlerrm);
3171: attributeValues1Out := ame_util.emptyStringList;

Line 3212: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

3208: end loop;
3209: exception
3210: when others then
3211: rollback;
3212: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
3213: routineNameIn => 'getStripingAttributeIds',
3214: exceptionNumberIn => sqlcode,
3215: exceptionStringIn => sqlerrm);
3216:

Line 3254: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

3250: end loop;
3251: exception
3252: when others then
3253: rollback;
3254: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
3255: routineNameIn => 'getStripingAttributeNames',
3256: exceptionNumberIn => sqlcode,
3257: exceptionStringIn => sqlerrm);
3258: stripingAttributeNamesOut := ame_util.emptyStringList;

Line 3353: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

3349: rollback;
3350: if(dbms_sql.is_open(dynamicCursor)) then
3351: dbms_sql.close_cursor(dynamicCursor);
3352: end if;
3353: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
3354: routineNameIn => 'getStripingAttributeValues',
3355: exceptionNumberIn => sqlcode,
3356: exceptionStringIn => sqlerrm);
3357: stripingAttributeIdsOut := ame_util.emptyStringList;

Line 3448: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

3444: rollback;
3445: if(dbms_sql.is_open(dynamicCursor)) then
3446: dbms_sql.close_cursor(dynamicCursor);
3447: end if;
3448: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
3449: routineNameIn => 'getStripingAttributeValues2',
3450: exceptionNumberIn => sqlcode,
3451: exceptionStringIn => sqlerrm);
3452: stripingAttributeIdsOut := ame_util.emptyStringList;

Line 3497: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

3493: stripeValue2Out := null;
3494: stripeValue3Out := null;
3495: stripeValue4Out := null;
3496: stripeValue5Out := null;
3497: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
3498: routineNameIn => 'getStripingAttributeValues3',
3499: exceptionNumberIn => sqlcode,
3500: exceptionStringIn => sqlerrm);
3501: raise;

Line 3555: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

3551: end if;
3552: exception
3553: when others then
3554: rollback;
3555: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
3556: routineNameIn => 'getTransExceptions',
3557: exceptionNumberIn => sqlcode,
3558: exceptionStringIn => sqlerrm);
3559: exceptionLogOut := ame_util.emptyExceptionLogTable;

Line 3609: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

3605: end if;
3606: exception
3607: when others then
3608: rollback;
3609: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
3610: routineNameIn => 'getTransTypeExceptions1',
3611: exceptionNumberIn => sqlcode,
3612: exceptionStringIn => sqlerrm);
3613: exceptionLogOut := ame_util.emptyExceptionLogTable;

Line 3665: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

3661: end if;
3662: exception
3663: when others then
3664: rollback;
3665: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
3666: routineNameIn => 'getTransTypeExceptions2',
3667: exceptionNumberIn => sqlcode,
3668: exceptionStringIn => sqlerrm);
3669: exceptionLogOut := ame_util.emptyExceptionLogTable;

Line 3702: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

3698: end loop;
3699: exception
3700: when others then
3701: rollback;
3702: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
3703: routineNameIn => 'getTransactionTypes',
3704: exceptionNumberIn => sqlcode,
3705: exceptionStringIn => sqlerrm);
3706: applicationIdsOut := ame_util.emptyIdList;

Line 3737: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

3733: close getItemClassesCursor;
3734: exception
3735: when others then
3736: rollback;
3737: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
3738: routineNameIn => 'getTransTypeItemClasses',
3739: exceptionNumberIn => sqlcode,
3740: exceptionStringIn => sqlerrm);
3741: itemClassIdsOut := ame_util.emptyStringList;

Line 3771: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

3767: close getItemClassesCursor;
3768: exception
3769: when others then
3770: rollback;
3771: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
3772: routineNameIn => 'getTransTypeItemClasses2',
3773: exceptionNumberIn => sqlcode,
3774: exceptionStringIn => sqlerrm);
3775: itemClassIdsOut := ame_util.emptyIdList;

Line 3805: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

3801: close getItemClassesCursor;
3802: exception
3803: when others then
3804: rollback;
3805: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
3806: routineNameIn => 'getTransTypeItemClasses3',
3807: exceptionNumberIn => sqlcode,
3808: exceptionStringIn => sqlerrm);
3809: itemClassIdsOut := ame_util.emptyIdList;

Line 3839: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

3835: close getItemClassesCursor;
3836: exception
3837: when others then
3838: rollback;
3839: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
3840: routineNameIn => 'getTransTypeItemClasses4',
3841: exceptionNumberIn => sqlcode,
3842: exceptionStringIn => sqlerrm);
3843: itemClassIdsOut := ame_util.emptyStringList;

Line 3869: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

3865: close getItemClassesCursor;
3866: exception
3867: when others then
3868: rollback;
3869: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
3870: routineNameIn => 'getTransTypeItemClassIds',
3871: exceptionNumberIn => sqlcode,
3872: exceptionStringIn => sqlerrm);
3873: itemClassIdsOut := ame_util.emptyIdList;

Line 3903: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

3899: end loop;
3900: exception
3901: when others then
3902: rollback;
3903: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
3904: routineNameIn => 'getWebExceptions',
3905: exceptionNumberIn => sqlcode,
3906: exceptionStringIn => sqlerrm);
3907: exceptionLogOut := ame_util.emptyExceptionLogTable;

Line 4047: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

4043: errorCode := -20001;
4044: errorMessage :=
4045: ame_util.getMessage(applicationShortNameIn => 'PER',
4046: messageNameIn => 'AME_400181_ADM_WKFLW_NOT_PRS');
4047: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
4048: routineNameIn => 'getWorkflowLog',
4049: exceptionNumberIn => errorCode,
4050: exceptionStringIn => errorMessage);
4051: logOut := ame_util.emptyWorkflowLogTable;

Line 4056: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

4052: raise_application_error(errorCode,
4053: errorMessage);
4054: when others then
4055: rollback;
4056: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
4057: routineNameIn => 'getWorkflowLog',
4058: exceptionNumberIn => sqlcode,
4059: exceptionStringIn => sqlerrm);
4060: logOut := ame_util.emptyWorkflowLogTable;

Line 4146: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

4142: end if;
4143: exception
4144: when others then
4145: rollback;
4146: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
4147: routineNameIn => 'incrementItemClassOrderNumbers',
4148: exceptionNumberIn => sqlcode,
4149: exceptionStringIn => sqlerrm);
4150: raise;

Line 4213: ame_admin_pkg.getItemClassMaxOrderNumber(applicationIdIn => applicationIdIn);

4209: else
4210: orderNumber := orderNumberIn;
4211: end if;
4212: maxOrderNumber :=
4213: ame_admin_pkg.getItemClassMaxOrderNumber(applicationIdIn => applicationIdIn);
4214: itemIdQuery := itemClassIdQueryIn;
4215: if(itemIdQuery is null) then
4216: raise nullQueryStringException;
4217: end if;

Line 4335: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

4331: errorCode := -20001;
4332: errorMessage :=
4333: ame_util.getMessage(applicationShortNameIn => 'PER',
4334: messageNameIn => 'AME_400143_ACT_OBJECT_CHNGED');
4335: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
4336: routineNameIn => 'newItemClassUsage',
4337: exceptionNumberIn => errorCode,
4338: exceptionStringIn => errorMessage);
4339: raise_application_error(errorCode,

Line 4350: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

4346: errorCode := -20001;
4347: errorMessage :=
4348: ame_util.getMessage(applicationShortNameIn => 'PER',
4349: messageNameIn => 'AME_400145_ACT_OBJECT_DELETED');
4350: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
4351: routineNameIn => 'newItemClassUsage',
4352: exceptionNumberIn => errorCode,
4353: exceptionStringIn => errorMessage);
4354: raise_application_error(errorCode,

Line 4362: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

4358: errorCode := -20001;
4359: errorMessage :=
4360: ame_util.getMessage(applicationShortNameIn => 'PER',
4361: messageNameIn => 'AME_400376_ADM IC_QUERY');
4362: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
4363: routineNameIn => 'newItemClassUsage',
4364: exceptionNumberIn => errorCode,
4365: exceptionStringIn => errorMessage);
4366: raise_application_error(errorCode,

Line 4374: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

4370: errorCode := -20001;
4371: errorMessage :=
4372: ame_util.getMessage(applicationShortNameIn => 'PER',
4373: messageNameIn => 'AME_400377_ADM IC_QUERY2');
4374: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
4375: routineNameIn => 'newItemClassUsage',
4376: exceptionNumberIn => errorCode,
4377: exceptionStringIn => errorMessage);
4378: raise_application_error(errorCode,

Line 4386: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

4382: errorCode := -20001;
4383: errorMessage :=
4384: ame_util.getMessage(applicationShortNameIn => 'PER',
4385: messageNameIn => 'AME_400410_ADM_NO_EMPTY_USAGE');
4386: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
4387: routineNameIn => 'newItemClassUsage',
4388: exceptionNumberIn => errorCode,
4389: exceptionStringIn => errorMessage);
4390: raise_application_error(errorCode,

Line 4398: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

4394: errorCode := -20001;
4395: errorMessage :=
4396: ame_util.getMessage(applicationShortNameIn => 'PER',
4397: messageNameIn => 'AME_400379_ADM IC_USAGE_EXISTS');
4398: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
4399: routineNameIn => 'newItemClassUsage',
4400: exceptionNumberIn => errorCode,
4401: exceptionStringIn => errorMessage);
4402: raise_application_error(errorCode,

Line 4406: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

4402: raise_application_error(errorCode,
4403: errorMessage);
4404: when others then
4405: rollback;
4406: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
4407: routineNameIn => 'newItemClassUsage',
4408: exceptionNumberIn => sqlcode,
4409: exceptionStringIn => '(item class ID ' ||
4410: itemClassIdIn||

Line 4481: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

4477: rollback;
4478: errorCode := -20001;
4479: errorMessage := 'This stripe set already exists for the ' ||
4480: 'transaction type. ';
4481: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
4482: routineNameIn => 'newStripeSet2',
4483: exceptionNumberIn => errorCode,
4484: exceptionStringIn => errorMessage);
4485: raise_application_error(errorCode,

Line 4490: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

4486: errorMessage);
4487: when others then
4488: rollback;
4489: rollback;
4490: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
4491: routineNameIn => 'newStripeSet2',
4492: exceptionNumberIn => sqlcode,
4493: exceptionStringIn => sqlerrm);
4494: raise;

Line 4713: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

4709: errorCode := -20001;
4710: errorMessage :=
4711: ame_util.getMessage(applicationShortNameIn => 'PER',
4712: messageNameIn => 'AME_400143_ACT_OBJECT_CHNGED');
4713: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
4714: routineNameIn => 'registerTransactionType',
4715: exceptionNumberIn => errorCode,
4716: exceptionStringIn => errorMessage);
4717: raise_application_error(errorCode,

Line 4721: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

4717: raise_application_error(errorCode,
4718: errorMessage);
4719: when others then
4720: rollback;
4721: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
4722: routineNameIn => 'registerTransactionType',
4723: exceptionNumberIn => sqlcode,
4724: exceptionStringIn => sqlerrm);
4725: raise;

Line 4782: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

4778: end if;
4779: exception
4780: when others then
4781: rollback;
4782: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
4783: routineNameIn => 'removeAllStripeSets',
4784: exceptionNumberIn => sqlcode,
4785: exceptionStringIn => sqlerrm);
4786: raise;

Line 5126: ame_util.runtimeException(packageNamein => 'ame_admin_pkg',

5122: errorCode := -20001;
5123: errorMessage := 'The attribute you selected to remove was not ' ||
5124: 'found within the current stripe set. Please ' ||
5125: 'contact your systems administrator.';
5126: ame_util.runtimeException(packageNamein => 'ame_admin_pkg',
5127: routineNamein => 'removeStripeSetAttributes',
5128: exceptionNumberIn => errorCode,
5129: exceptionStringIn => errorMessage);
5130: raise_application_error(errorCode,

Line 5134: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

5130: raise_application_error(errorCode,
5131: errorMessage);
5132: when others then
5133: rollback;
5134: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
5135: routineNameIn => 'removeStripeSetAttributes',
5136: exceptionNumberIn => sqlcode,
5137: exceptionStringIn => sqlerrm);
5138: raise;

Line 5197: if((ame_admin_pkg.icInUseByAttributeUsage(itemClassIdIn => itemClassIdIn,

5193: close startDateCursor2;
5194: raise ame_util.objectVersionException;
5195: end if;
5196: currentUserId := ame_util.getCurrentUserId;
5197: if((ame_admin_pkg.icInUseByAttributeUsage(itemClassIdIn => itemClassIdIn,
5198: applicationIdIn => applicationIdIn)) or
5199: (ame_admin_pkg.icInUseByRuleUsage(itemClassIdIn => itemClassIdIn,
5200: applicationIdIn => applicationIdIn))) then
5201: raise icUsageDeletionException;

Line 5199: (ame_admin_pkg.icInUseByRuleUsage(itemClassIdIn => itemClassIdIn,

5195: end if;
5196: currentUserId := ame_util.getCurrentUserId;
5197: if((ame_admin_pkg.icInUseByAttributeUsage(itemClassIdIn => itemClassIdIn,
5198: applicationIdIn => applicationIdIn)) or
5199: (ame_admin_pkg.icInUseByRuleUsage(itemClassIdIn => itemClassIdIn,
5200: applicationIdIn => applicationIdIn))) then
5201: raise icUsageDeletionException;
5202: end if;
5203: select item_class_order_number

Line 5229: itemClassName := ame_admin_pkg.getItemClassName(itemClassIdIn => itemClassIdIn);

5225: item_class_id = itemClassIdIn and
5226: application_id = applicationIdIn and
5227: processingDate between start_date and
5228: nvl(end_date - ame_util.oneSecond, processingDate);
5229: itemClassName := ame_admin_pkg.getItemClassName(itemClassIdIn => itemClassIdIn);
5230: update ame_item_classes
5231: set
5232: last_updated_by = currentUserId,
5233: last_update_date = processingDate,

Line 5262: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

5258: errorCode := -20001;
5259: errorMessage :=
5260: ame_util.getMessage(applicationShortNameIn => 'PER',
5261: messageNameIn => 'AME_400143_ACT_OBJECT_CHNGED');
5262: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
5263: routineNameIn => 'removeUsage',
5264: exceptionNumberIn => errorCode,
5265: exceptionStringIn => errorMessage);
5266: raise_application_error(errorCode,

Line 5280: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

5276: errorCode := -20001;
5277: errorMessage :=
5278: ame_util.getMessage(applicationShortNameIn => 'PER',
5279: messageNameIn => 'AME_400145_ACT_OBJECT_DELETED');
5280: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
5281: routineNameIn => 'removeUsage',
5282: exceptionNumberIn => errorCode,
5283: exceptionStringIn => errorMessage);
5284: raise_application_error(errorCode,

Line 5298: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

5294: errorCode := -20001;
5295: errorMessage :=
5296: ame_util.getMessage(applicationShortNameIn => 'PER',
5297: messageNameIn => 'AME_400381_ADM IC_USAGE_DEL');
5298: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
5299: routineNameIn => 'removeUsage',
5300: exceptionNumberIn => errorCode,
5301: exceptionStringIn => errorMessage);
5302: raise_application_error(errorCode,

Line 5312: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

5308: end if;
5309: if(startDateCursor2%isOpen) then
5310: close startDateCursor2;
5311: end if;
5312: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
5313: routineNameIn => 'removeUsage',
5314: exceptionNumberIn => sqlcode,
5315: exceptionStringIn => '(item class ID ' ||
5316: itemClassIdIn||

Line 5448: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

5444: errorCode := -20001;
5445: errorMessage :=
5446: ame_util.getMessage(applicationShortNameIn => 'PER',
5447: messageNameIn => 'AME_400143_ACT_OBJECT_CHNGED');
5448: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
5449: routineNameIn => 'removeTransactionType',
5450: exceptionNumberIn => errorCode,
5451: exceptionStringIn => errorMessage);
5452: raise_application_error(errorCode,

Line 5463: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

5459: errorCode := -20001;
5460: errorMessage :=
5461: ame_util.getMessage(applicationShortNameIn => 'PER',
5462: messageNameIn => 'AME_400145_ACT_OBJECT_DELETED');
5463: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
5464: routineNameIn => 'removeTransactionType',
5465: exceptionNumberIn => errorCode,
5466: exceptionStringIn => errorMessage);
5467: raise_application_error(errorCode,

Line 5474: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

5470: rollback;
5471: if(startDateCursor%isOpen) then
5472: close startDateCursor;
5473: end if;
5474: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
5475: routineNameIn => 'removeTransactionType',
5476: exceptionNumberIn => sqlcode,
5477: exceptionStringIn => sqlerrm);
5478: raise;

Line 5501: ame_admin_pkg.getStripingAttributeIds(applicationIdIn => applicationIdIn,

5497: application_id = applicationIdIn and
5498: (start_date <= sysdate and
5499: (end_date is null or sysdate < end_date));
5500: if(stripeCount > 0) then
5501: ame_admin_pkg.getStripingAttributeIds(applicationIdIn => applicationIdIn,
5502: stripingAttributeIdsOut => stripingAttributeIds);
5503: update ame_stripe_sets
5504: set end_date = sysdate
5505: where

Line 5574: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

5570: commit;
5571: exception
5572: when others then
5573: rollback;
5574: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
5575: routineNameIn => 'updateStripingAttIds',
5576: exceptionNumberIn => sqlcode,
5577: exceptionStringIn => sqlerrm);
5578: raise;

Line 5593: if(ame_admin_pkg.isStripingOn(applicationIdIn => applicationIdIn)) then

5589: staticUsage ame_attribute_usages.is_static%type;
5590: stripingAttributeIds ame_util.idList;
5591: stripingAttributeNames ame_util.stringList;
5592: begin
5593: if(ame_admin_pkg.isStripingOn(applicationIdIn => applicationIdIn)) then
5594: ame_admin_pkg.getAttributeStripeSetNames(applicationIdIn => applicationIdIn,
5595: stripingAttributeIdsOut => stripingAttributeIds,
5596: stripingAttributeNamesOut => stripingAttributeNames);
5597: attributeCount := stripingAttributeIds.count;

Line 5594: ame_admin_pkg.getAttributeStripeSetNames(applicationIdIn => applicationIdIn,

5590: stripingAttributeIds ame_util.idList;
5591: stripingAttributeNames ame_util.stringList;
5592: begin
5593: if(ame_admin_pkg.isStripingOn(applicationIdIn => applicationIdIn)) then
5594: ame_admin_pkg.getAttributeStripeSetNames(applicationIdIn => applicationIdIn,
5595: stripingAttributeIdsOut => stripingAttributeIds,
5596: stripingAttributeNamesOut => stripingAttributeNames);
5597: attributeCount := stripingAttributeIds.count;
5598: for i in 1..attributeCount loop

Line 5620: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',

5616: end if;
5617: exception
5618: when others then
5619: rollback;
5620: ame_util.runtimeException(packageNameIn => 'ame_admin_pkg',
5621: routineNameIn => 'updateStripingAttUseCount',
5622: exceptionNumberIn => sqlcode,
5623: exceptionStringIn => sqlerrm);
5624: raise;

Line 5627: end ame_admin_pkg;

5623: exceptionStringIn => sqlerrm);
5624: raise;
5625: end updateStripingAttUseCount;
5626: */
5627: end ame_admin_pkg;