APPS.AME_RULE_PKG dependencies on AME_RULE_PKG

Line 1: package body ame_rule_pkg as

1: package body ame_rule_pkg as
2: /* $Header: ameorule.pkb 120.1 2006/09/07 12:59:51 pvelugul noship $ */
3: allOrgsLabel constant varchar2(50) := 'Include all organizations.';
4: allGroupsLabel constant varchar2(50) := 'Include all business groups.';
5: allSetsOfBooksLabel constant varchar2(50) := 'Include all sets of books.';

Line 60: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

56: end if;
57: exception
58: when others then
59: rollback;
60: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
61: routineNamein => 'allOrdinaryConditionsDeleted',
62: exceptionNumberIn => sqlcode,
63: exceptionStringIn => sqlerrm);
64: raise;

Line 86: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

82: return(false);
83: exception
84: when others then
85: rollback;
86: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
87: routineNamein => 'appHasRules',
88: exceptionNumberIn => sqlcode,
89: exceptionStringIn => sqlerrm);
90: raise;

Line 121: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

117: return(false);
118: exception
119: when others then
120: rollback;
121: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
122: routineNamein => 'bothSeededLMActionTypesChosen',
123: exceptionNumberIn => sqlcode,
124: exceptionStringIn => sqlerrm);
125: raise;

Line 185: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

181: return(false);
182: exception
183: when others then
184: rollback;
185: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
186: routineNamein => 'bothSeededLMActionTypesChosen2',
187: exceptionNumberIn => sqlcode,
188: exceptionStringIn => sqlerrm);
189: raise;

Line 261: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',

257: errorCode := -20001;
258: errorMessage :=
259: ame_util.getMessage(applicationShortNameIn => 'PER',
260: messageNameIn => 'AME_400329_RULE_USG_OVER_LIFE');
261: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',
262: routineNameIn => 'checkRuleUsageExists',
263: exceptionNumberIn => errorCode,
264: exceptionStringIn => errorMessage);
265: raise;

Line 309: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

305: end if;
306: exception
307: when others then
308: rollback;
309: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
310: routineNamein => 'deletedAllExceptionConditions',
311: exceptionNumberIn => sqlcode,
312: exceptionStringIn => sqlerrm);
313: raise;

Line 335: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

331: return(false);
332: exception
333: when others then
334: rollback;
335: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
336: routineNamein => 'descriptionInUse',
337: exceptionNumberIn => sqlcode,
338: exceptionStringIn => sqlerrm);
339: raise;

Line 356: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

352: return(false);
353: exception
354: when others then
355: rollback;
356: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
357: routineNamein => 'finalAuthorityActionType',
358: exceptionNumberIn => sqlcode,
359: exceptionStringIn => sqlerrm);
360: raise;

Line 392: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

388: return(false);
389: exception
390: when others then
391: rollback;
392: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
393: routineNamein => 'finalAuthorityActionType2',
394: exceptionNumberIn => sqlcode,
395: exceptionStringIn => sqlerrm);
396: raise;

Line 420: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

416: return(approverCategory);
417: exception
418: when others then
419: rollback;
420: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
421: routineNamein => 'getApproverCategory',
422: exceptionNumberIn => sqlcode,
423: exceptionStringIn => '(rule ID ' ||
424: ruleIdIn||

Line 447: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

443: return(conditionCount);
444: exception
445: when others then
446: rollback;
447: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
448: routineNamein => 'getConditionCount',
449: exceptionNumberIn => sqlcode,
450: exceptionStringIn => '(rule ID ' ||
451: ruleIdIn||

Line 486: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

482: end if;
483: exception
484: when others then
485: rollback;
486: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
487: routineNamein => 'getItemClassId',
488: exceptionNumberIn => sqlcode,
489: exceptionStringIn => '(rule ID ' ||
490: ruleIdIn||

Line 518: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

514: return(conditionId);
515: exception
516: when others then
517: rollback;
518: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
519: routineNamein => 'getLMConditionId',
520: exceptionNumberIn => sqlcode,
521: exceptionStringIn => '(rule ID ' ||
522: ruleIdIn||

Line 542: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',

538: return(organizationName);
539: exception
540: when others then
541: rollback;
542: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',
543: routineNameIn => 'getOrganizationName',
544: exceptionNumberIn => sqlcode,
545: exceptionStringIn => '(organization ID ' ||
546: organizationIdIn||

Line 569: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

565: return(priority);
566: exception
567: when others then
568: rollback;
569: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
570: routineNamein => 'getPriority',
571: exceptionNumberIn => sqlcode,
572: exceptionStringIn => '(rule ID ' ||
573: ruleIdIn||

Line 595: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

591: return(itemId);
592: exception
593: when others then
594: rollback;
595: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
596: routineNamein => 'getItemId',
597: exceptionNumberIn => sqlcode,
598: exceptionStringIn => '(rule ID ' ||
599: ruleIdIn||

Line 634: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

630: end if;
631: exception
632: when others then
633: rollback;
634: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
635: routineNamein => 'getRuleType',
636: exceptionNumberIn => sqlcode,
637: exceptionStringIn => '(rule ID ' ||
638: ruleIdIn||

Line 669: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

665: end if;
666: exception
667: when others then
668: rollback;
669: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
670: routineNamein => 'getRuleTypeLabel',
671: exceptionNumberIn => sqlcode,
672: exceptionStringIn => sqlerrm);
673: raise;

Line 700: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

696: end if;
697: exception
698: when others then
699: rollback;
700: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
701: routineNamein => 'getRuleTypeLabel2',
702: exceptionNumberIn => sqlcode,
703: exceptionStringIn => sqlerrm);
704: raise;

Line 736: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

732: return(description);
733: exception
734: when others then
735: rollback;
736: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
737: routineNamein => 'getDescription',
738: exceptionNumberIn => sqlcode,
739: exceptionStringIn => '(rule ID ' ||
740: ruleIdIn||

Line 762: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

758: return(endDate);
759: exception
760: when others then
761: rollback;
762: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
763: routineNamein => 'getEndDate',
764: exceptionNumberIn => sqlcode,
765: exceptionStringIn => '(rule ID ' ||
766: ruleIdIn||

Line 796: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

792: when no_data_found then
793: return(null);
794: when others then
795: rollback;
796: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
797: routineNamein => 'getEffectiveEndDateUsage',
798: exceptionNumberIn => sqlcode,
799: exceptionStringIn => '(rule ID ' ||
800: ruleIdIn||

Line 830: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

826: when no_data_found then
827: return(null);
828: when others then
829: rollback;
830: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
831: routineNamein => 'getEffectiveStartDateUsage',
832: exceptionNumberIn => sqlcode,
833: exceptionStringIn => '(rule ID ' ||
834: ruleIdIn||

Line 856: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

852: return(ame_util.versionDateToString(dateIn => endDate));
853: exception
854: when others then
855: rollback;
856: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
857: routineNamein => 'getUsageEndDate',
858: exceptionNumberIn => sqlcode,
859: exceptionStringIn => '(rule ID ' ||
860: ruleIdIn||

Line 925: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

921: return(null);
922: exception
923: when others then
924: rollback;
925: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
926: routineNamein => 'getId',
927: exceptionNumberIn => sqlcode,
928: exceptionStringIn => '(rule ID ' ||
929: ruleId ||

Line 956: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',

952: end;
953: exception
954: when others then
955: rollback;
956: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',
957: routineNameIn => 'getRuleStripeSetId',
958: exceptionNumberIn => sqlcode,
959: exceptionStringIn => sqlerrm);
960: return(null);

Line 979: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

975: end if;
976: exception
977: when others then
978: rollback;
979: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
980: routineNamein => 'ruleKeyExists',
981: exceptionNumberIn => sqlcode,
982: exceptionStringIn => '(rule Key ' ||
983: ruleKeyIn ||

Line 1026: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

1022: return(newRuleKey);
1023: exception
1024: when others then
1025: rollback;
1026: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
1027: routineNamein => 'getNextRuleKey',
1028: exceptionNumberIn => sqlcode,
1029: exceptionStringIn => '(rule Key ' ||
1030: newRuleKey ||

Line 1063: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

1059: return(ruleKey);
1060: exception
1061: when others then
1062: rollback;
1063: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
1064: routineNamein => 'getRuleKey',
1065: exceptionNumberIn => sqlcode,
1066: exceptionStringIn => '(rule ID ' ||
1067: ruleIdIn||

Line 1098: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

1094: return(newStartDate);
1095: exception
1096: when others then
1097: rollback;
1098: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
1099: routineNamein => 'getNewRuleStartDate',
1100: exceptionNumberIn => sqlcode,
1101: exceptionStringIn => '(rule ID ' ||
1102: ruleIdIn||

Line 1134: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

1130: return(newEndDate);
1131: exception
1132: when others then
1133: rollback;
1134: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
1135: routineNamein => 'getNewRuleEndDate',
1136: exceptionNumberIn => sqlcode,
1137: exceptionStringIn => '(rule ID ' ||
1138: ruleIdIn||

Line 1191: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

1187: return(priority);
1188: exception
1189: when others then
1190: rollback;
1191: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
1192: routineNamein => 'getRulePriorityMode',
1193: exceptionNumberIn => sqlcode,
1194: exceptionStringIn => sqlerrm);
1195: raise;

Line 1214: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

1210: return(startDate);
1211: exception
1212: when others then
1213: rollback;
1214: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
1215: routineNamein => 'getStartDate',
1216: exceptionNumberIn => sqlcode,
1217: exceptionStringIn => '(rule ID ' ||
1218: ruleIdIn||

Line 1261: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

1257: end loop;
1258: exception
1259: when others then
1260: rollback;
1261: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
1262: routineNamein => 'getSubItemClassId',
1263: exceptionNumberIn => sqlcode,
1264: exceptionStringIn => '(rule ID ' ||
1265: ruleIdIn||

Line 1287: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

1283: return(ame_util.versionDateToString(dateIn => startDate));
1284: exception
1285: when others then
1286: rollback;
1287: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
1288: routineNamein => 'getUsageStartDate',
1289: exceptionNumberIn => sqlcode,
1290: exceptionStringIn => '(rule ID ' ||
1291: ruleIdIn||

Line 1313: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

1309: return(ruleType);
1310: exception
1311: when others then
1312: rollback;
1313: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
1314: routineNamein => 'getType',
1315: exceptionNumberIn => sqlcode,
1316: exceptionStringIn => '(rule ID ' ||
1317: ruleIdIn||

Line 1341: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',

1337: return(stringStartDate);
1338: exception
1339: when others then
1340: rollback;
1341: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',
1342: routineNameIn => 'getVersionStartDate',
1343: exceptionNumberIn => sqlcode,
1344: exceptionStringIn => '(rule ID ' ||
1345: ruleIdIn||

Line 1372: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',

1368: return(false);
1369: exception
1370: when others then
1371: rollback;
1372: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',
1373: routineNameIn => 'hasATUsageForRuleType',
1374: exceptionNumberIn => sqlcode,
1375: exceptionStringIn => sqlerrm);
1376: raise;

Line 1416: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',

1412: return(false);
1413: exception
1414: when others then
1415: rollback;
1416: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',
1417: routineNameIn => 'hasATUsageForRuleType2',
1418: exceptionNumberIn => sqlcode,
1419: exceptionStringIn => sqlerrm);
1420: raise;

Line 1435: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',

1431: return(false);
1432: exception
1433: when others then
1434: rollback;
1435: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',
1436: routineNameIn => 'hasExceptionCondition',
1437: exceptionNumberIn => sqlcode,
1438: exceptionStringIn => sqlerrm);
1439: raise;

Line 1454: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',

1450: return(false);
1451: exception
1452: when others then
1453: rollback;
1454: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',
1455: routineNameIn => 'hasListModCondition',
1456: exceptionNumberIn => sqlcode,
1457: exceptionStringIn => sqlerrm);
1458: raise;

Line 1487: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

1483: end if;
1484: exception
1485: when others then
1486: rollback;
1487: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
1488: routineNamein => 'hasListModCondition2',
1489: exceptionNumberIn => sqlcode,
1490: exceptionStringIn => '(rule ID ' ||
1491: ruleIdIn||

Line 1512: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',

1508: return(false);
1509: exception
1510: when others then
1511: rollback;
1512: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',
1513: routineNameIn => 'hasNonProductionActions',
1514: exceptionNumberIn => sqlcode,
1515: exceptionStringIn => sqlerrm);
1516: raise;

Line 1531: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',

1527: return(false);
1528: exception
1529: when others then
1530: rollback;
1531: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',
1532: routineNameIn => 'hasNonProductionActionTypes',
1533: exceptionNumberIn => sqlcode,
1534: exceptionStringIn => sqlerrm);
1535: raise;

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

1565: end if;
1566: exception
1567: when others then
1568: rollback;
1569: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',
1570: routineNameIn => 'hasSubOrListModAction',
1571: exceptionNumberIn => sqlcode,
1572: exceptionStringIn => sqlerrm);
1573: raise;

Line 1590: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

1586: return(false);
1587: exception
1588: when others then
1589: rollback;
1590: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
1591: routineNamein => 'isAtLeastOneICAttrSelected',
1592: exceptionNumberIn => sqlcode,
1593: exceptionStringIn => sqlerrm);
1594: raise;

Line 1613: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

1609: return(false);
1610: exception
1611: when others then
1612: rollback;
1613: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
1614: routineNamein => 'isAtLeastOneICCondSelected',
1615: exceptionNumberIn => sqlcode,
1616: exceptionStringIn => sqlerrm);
1617: raise;

Line 1639: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

1635: return(false);
1636: exception
1637: when others then
1638: rollback;
1639: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
1640: routineNamein => 'isinUse',
1641: exceptionNumberIn => sqlcode,
1642: exceptionStringIn => '(rule ID ' ||
1643: ruleIdIn||

Line 1670: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

1666: return(false);
1667: exception
1668: when others then
1669: rollback;
1670: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
1671: routineNamein => 'isInUseByOtherApps',
1672: exceptionNumberIn => sqlcode,
1673: exceptionStringIn => '(rule ID ' ||
1674: ruleIdIn||

Line 1699: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

1695: return(false);
1696: exception
1697: when others then
1698: rollback;
1699: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
1700: routineNamein => 'lastConditionDeleted',
1701: exceptionNumberIn => sqlcode,
1702: exceptionStringIn => sqlerrm);
1703: raise;

Line 1720: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

1716: return(false);
1717: exception
1718: when others then
1719: rollback;
1720: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
1721: routineNamein => 'lineItemJobLevelChosen',
1722: exceptionNumberIn => sqlcode,
1723: exceptionStringIn => sqlerrm);
1724: raise;

Line 1763: if ame_rule_pkg.descriptionInUse(descriptionIn => descriptionIn) then

1759: else
1760: processingDate := processingDateIn;
1761: end if;
1762: /* check to see if description has already been used */
1763: if ame_rule_pkg.descriptionInUse(descriptionIn => descriptionIn) then
1764: raise descriptionInUseException;
1765: end if;
1766: /* Check and set start date. */
1767: if ruleIdIn is null then

Line 1937: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

1933: errorMessage := ame_util.getMessage(applicationShortNameIn => 'PER',
1934: messageNameIn => 'AME_400361_RULE_KEY_LONG',
1935: tokenNameOneIn => 'COLUMN_LENGTH',
1936: tokenValueOneIn => 100);
1937: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
1938: routineNamein => 'new',
1939: exceptionNumberIn => errorCode,
1940: exceptionStringIn => errorMessage);
1941: raise_application_error(errorCode,

Line 1950: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

1946: errorCode := -20001;
1947: errorMessage :=
1948: ame_util.getMessage(applicationShortNameIn => 'PER',
1949: messageNameIn => 'AME_400206_RUL_DESC_IN_USE');
1950: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
1951: routineNamein => 'new',
1952: exceptionNumberIn => errorCode,
1953: exceptionStringIn => errorMessage);
1954: raise_application_error(errorCode,

Line 1965: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

1961: messageNameIn => 'AME_400207_RUL_DESC_LONG',
1962: tokenNameOneIn => 'COLUMN_LENGTH',
1963: tokenValueOneIn => ame_util.getColumnLength(tableNamein => 'ame_rules',
1964: columnNamein => 'description'));
1965: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
1966: routineNamein => 'new',
1967: exceptionNumberIn => errorCode,
1968: exceptionStringIn => errorMessage);
1969: raise_application_error(errorCode,

Line 1978: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

1974: errorCode := -20001;
1975: errorMessage :=
1976: ame_util.getMessage(applicationShortNameIn => 'PER',
1977: messageNameIn => 'AME_400208_RUL_STRT_PREC_TDY');
1978: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
1979: routineNamein => 'new',
1980: exceptionNumberIn => errorCode,
1981: exceptionStringIn => errorMessage);
1982: raise_application_error(errorCode,

Line 1991: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

1987: errorCode := -20001;
1988: errorMessage :=
1989: ame_util.getMessage(applicationShortNameIn => 'PER',
1990: messageNameIn => 'AME_400209_RUL_STRT_PREC_END');
1991: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
1992: routineNamein => 'new',
1993: exceptionNumberIn => errorCode,
1994: exceptionStringIn => errorMessage);
1995: raise_application_error(errorCode,

Line 2000: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

1996: errorMessage);
1997: return(null);
1998: when others then
1999: rollback;
2000: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
2001: routineNamein => 'new',
2002: exceptionNumberIn => sqlcode,
2003: exceptionStringIn => '(rule ID ' ||
2004: ruleIdIn||

Line 2065: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

2061: commit;
2062: exception
2063: when others then
2064: rollback;
2065: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
2066: routineNamein => 'newRuleStripeSet',
2067: exceptionNumberIn => sqlcode,
2068: exceptionStringIn => '(rule ID ' ||
2069: ruleIdIn||

Line 2163: if(ame_rule_pkg.useRulePriorityMode(applicationIdIn => itemIdIn,

2159: end if;
2160: ruleKey := getRuleKey(ruleIdIn => ruleIdIn);
2161: ruleType := getRuleType(ruleIdIn => ruleIdIn);
2162: itemClassId := getItemClassId(ruleIdIn => ruleIdIn);
2163: if(ame_rule_pkg.useRulePriorityMode(applicationIdIn => itemIdIn,
2164: ruleTypeIn => ruleType)) then
2165: if (priorityIn is null) or
2166: (not(ame_util.isANumber(stringIn => priorityIn,
2167: allowDecimalsIn => false,

Line 2343: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',

2339: errorCode := -20001;
2340: errorMessage :=
2341: ame_util.getMessage(applicationShortNameIn => 'PER',
2342: messageNameIn => 'AME_400143_ACT_OBJECT_CHNGED');
2343: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',
2344: routineNameIn => 'newRuleUsage',
2345: exceptionNumberIn => errorCode,
2346: exceptionStringIn => errorMessage);
2347: raise_application_error(errorCode,

Line 2356: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',

2352: errorCode := -20001;
2353: errorMessage :=
2354: ame_util.getMessage(applicationShortNameIn => 'PER',
2355: messageNameIn => 'AME_400327_RULE_USG_EXST_LIFE');
2356: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',
2357: routineNameIn => 'newRuleUsage',
2358: exceptionNumberIn => errorCode,
2359: exceptionStringIn => errorMessage);
2360: raise_application_error(errorCode,

Line 2369: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',

2365: errorCode := -20001;
2366: errorMessage :=
2367: ame_util.getMessage(applicationShortNameIn => 'PER',
2368: messageNameIn => 'AME_400328_RULE_USG_DIFF_PRIOR');
2369: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',
2370: routineNameIn => 'newRuleUsage',
2371: exceptionNumberIn => errorCode,
2372: exceptionStringIn => errorMessage);
2373: raise_application_error(errorCode,

Line 2382: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',

2378: errorCode := -20001;
2379: errorMessage :=
2380: ame_util.getMessage(applicationShortNameIn => 'PER',
2381: messageNameIn => 'AME_400329_RULE_USG_OVER_LIFE');
2382: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',
2383: routineNameIn => 'newRuleUsage',
2384: exceptionNumberIn => errorCode,
2385: exceptionStringIn => errorMessage);
2386: raise_application_error(errorCode,

Line 2398: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',

2394: errorCode := -20001;
2395: errorMessage :=
2396: ame_util.getMessage(applicationShortNameIn => 'PER',
2397: messageNameIn => 'AME_400288_RUL_PRI_NOT_VAL');
2398: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',
2399: routineNameIn => 'newRuleUsage',
2400: exceptionNumberIn => errorCode,
2401: exceptionStringIn => errorMessage);
2402: raise_application_error(errorCode,

Line 2411: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

2407: errorCode := -20001;
2408: errorMessage :=
2409: ame_util.getMessage(applicationShortNameIn => 'PER',
2410: messageNameIn => 'AME_400208_RUL_STRT_PREC_TDY');
2411: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
2412: routineNamein => 'newRuleUsage',
2413: exceptionNumberIn => errorCode,
2414: exceptionStringIn => errorMessage);
2415: raise_application_error(errorCode,

Line 2424: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

2420: errorCode := -20001;
2421: errorMessage :=
2422: ame_util.getMessage(applicationShortNameIn => 'PER',
2423: messageNameIn => 'AME_400214_RUL_STRT_LESS_END');
2424: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
2425: routineNamein => 'newRuleUsage',
2426: exceptionNumberIn => errorCode,
2427: exceptionStringIn => errorMessage);
2428: raise_application_error(errorCode,

Line 2439: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',

2435: errorCode := -20001;
2436: errorMessage :=
2437: ame_util.getMessage(applicationShortNameIn => 'PER',
2438: messageNameIn => 'AME_400145_ACT_OBJECT_DELETED');
2439: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',
2440: routineNameIn => 'newRuleUsage',
2441: exceptionNumberIn => errorCode,
2442: exceptionStringIn => errorMessage);
2443: raise_application_error(errorCode,

Line 2452: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

2448: errorCode := -20001;
2449: errorMessage :=
2450: ame_util.getMessage(applicationShortNameIn => 'PER',
2451: messageNameIn => 'AME_400210_RUL_USAGE_EXISTS');
2452: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
2453: routineNamein => 'newRuleUsage',
2454: exceptionNumberIn => errorCode,
2455: exceptionStringIn => errorMessage);
2456: raise_application_error(errorCode,

Line 2465: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',

2461: errorCode := -20001;
2462: errorMessage :=
2463: ame_util.getMessage(applicationShortNameIn => 'PER',
2464: messageNameIn => 'AME_400437_RULE_USAGE_END_DATE');
2465: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',
2466: routineNameIn => 'newRuleUsage',
2467: exceptionNumberIn => errorCode,
2468: exceptionStringIn => errorMessage);
2469: raise_application_error(errorCode,

Line 2476: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

2472: rollback;
2473: if(startDateCursor%isOpen) then
2474: close startDateCursor;
2475: end if;
2476: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
2477: routineNamein => 'newRuleUsage',
2478: exceptionNumberIn => sqlcode,
2479: exceptionStringIn => '(rule ID ' ||
2480: ruleIdIn||

Line 2500: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

2496: return(false);
2497: exception
2498: when others then
2499: rollback;
2500: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
2501: routineNamein => 'nonFinalAuthorityActionType',
2502: exceptionNumberIn => sqlcode,
2503: exceptionStringIn => sqlerrm);
2504: raise;

Line 2536: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

2532: return(false);
2533: exception
2534: when others then
2535: rollback;
2536: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
2537: routineNamein => 'nonFinalAuthorityActionType2',
2538: exceptionNumberIn => sqlcode,
2539: exceptionStringIn => sqlerrm);
2540: raise;

Line 2568: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

2564: return(false);
2565: exception
2566: when others then
2567: rollback;
2568: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
2569: routineNamein => 'ordinaryConditionsExist',
2570: exceptionNumberIn => sqlcode,
2571: exceptionStringIn => sqlerrm);
2572: raise;

Line 2651: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

2647: return(false);
2648: exception
2649: when others then
2650: rollback;
2651: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
2652: routineNamein => 'ruleAlreadyExistsForTransType',
2653: exceptionNumberIn => sqlcode,
2654: exceptionStringIn => '(rule ID ' ||
2655: ruleId ||

Line 2725: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

2721: return(false);
2722: exception
2723: when others then
2724: rollback;
2725: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
2726: routineNamein => 'ruleExists',
2727: exceptionNumberIn => sqlcode,
2728: exceptionStringIn => '(rule ID ' ||
2729: ruleId ||

Line 2766: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

2762: end if;
2763: exception
2764: when others then
2765: rollback;
2766: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
2767: routineNamein => 'subordinateICCondExist',
2768: exceptionNumberIn => sqlcode,
2769: exceptionStringIn => sqlerrm);
2770: raise;

Line 2843: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

2839: return(true);
2840: exception
2841: when others then
2842: rollback;
2843: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
2844: routineNamein => 'useRulePriorityMode',
2845: exceptionNumberIn => sqlcode,
2846: exceptionStringIn => sqlerrm);
2847: raise;

Line 2959: itemClassId := ame_rule_pkg.getItemClassId(ruleIdIn => ruleIdIn);

2955: newEndDate := null;
2956: else
2957: newEndDate := ruleEndDate;
2958: end if;
2959: itemClassId := ame_rule_pkg.getItemClassId(ruleIdIn => ruleIdIn);
2960: newConditionIdList := conditionIdsIn;
2961: conditionCount := newConditionIdList.count;
2962: newActionIdList := actionIdsIn;
2963: actionCount := newActionIdList.count;

Line 3015: itemClassId := ame_rule_pkg.getItemClassId(ruleIdIn => ruleIdIn);

3011: end if;
3012: end loop;
3013: end if;
3014: end loop;
3015: itemClassId := ame_rule_pkg.getItemClassId(ruleIdIn => ruleIdIn);
3016: if(ruleExists(typeIn => ruleType,
3017: itemClassIdIn => itemClassId,
3018: conditionIdListIn => newConditionIdList,
3019: actionIdListIn => newActionIdList)) then

Line 3028: if(not ame_rule_pkg.hasATUsageForRuleType2(ruleTypeIn => ruleType,

3024: With exception of the combination rule type, a rule must have at least
3025: one action of an action type that has an action-type usage for
3026: the rule's type.
3027: */
3028: if(not ame_rule_pkg.hasATUsageForRuleType2(ruleTypeIn => ruleType,
3029: actionIdsIn => newActionIdList)) then
3030: raise actionTypeUsageException;
3031: end if;
3032: if(ruleType = ame_util.combinationRuleType) then

Line 3033: if(not ame_rule_pkg.hasNonProductionActions(actionIdsIn => newActionIdList)) then

3029: actionIdsIn => newActionIdList)) then
3030: raise actionTypeUsageException;
3031: end if;
3032: if(ruleType = ame_util.combinationRuleType) then
3033: if(not ame_rule_pkg.hasNonProductionActions(actionIdsIn => newActionIdList)) then
3034: raise nonProductionActionException;
3035: end if;
3036: end if;
3037: /* Exception rules must have at least one exception condition. */

Line 3039: if(not ame_rule_pkg.hasExceptionCondition(conditionIdsIn => newConditionIdList)) then

3035: end if;
3036: end if;
3037: /* Exception rules must have at least one exception condition. */
3038: if(ruleType = ame_util.exceptionRuleType) then
3039: if(not ame_rule_pkg.hasExceptionCondition(conditionIdsIn => newConditionIdList)) then
3040: raise exceptionConditionException;
3041: end if;
3042: end if;
3043: /* List-modification and substitution rules must have exactly one list-modification condition. */

Line 3045: if(not ame_rule_pkg.hasListModCondition(conditionIdsIn => newConditionIdList)) then

3041: end if;
3042: end if;
3043: /* List-modification and substitution rules must have exactly one list-modification condition. */
3044: if(ruleType in (ame_util.listModRuleType, ame_util.substitutionRuleType)) then
3045: if(not ame_rule_pkg.hasListModCondition(conditionIdsIn => newConditionIdList)) then
3046: raise listModConditionException;
3047: end if;
3048: end if;
3049: update ame_condition_usages

Line 3113: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',

3109: errorCode := -20001;
3110: errorMessage :=
3111: ame_util.getMessage(applicationShortNameIn => 'PER',
3112: messageNameIn => 'AME_400143_ACT_OBJECT_CHNGED');
3113: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',
3114: routineNameIn => 'change',
3115: exceptionNumberIn => errorCode,
3116: exceptionStringIn => errorMessage);
3117: raise_application_error(errorCode,

Line 3128: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',

3124: errorCode := -20001;
3125: errorMessage :=
3126: ame_util.getMessage(applicationShortNameIn => 'PER',
3127: messageNameIn => 'AME_400145_ACT_OBJECT_DELETED');
3128: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',
3129: routineNameIn => 'change',
3130: exceptionNumberIn => errorCode,
3131: exceptionStringIn => errorMessage);
3132: raise_application_error(errorCode,

Line 3140: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

3136: errorCode := -20001;
3137: errorMessage :=
3138: ame_util.getMessage(applicationShortNameIn => 'PER',
3139: messageNameIn => 'AME_400212_RUL_PROP_EXISTS');
3140: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
3141: routineNamein => 'change',
3142: exceptionNumberIn => errorCode,
3143: exceptionStringIn => errorMessage);
3144: raise_application_error(errorCode,

Line 3152: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

3148: errorCode := -20001;
3149: errorMessage :=
3150: ame_util.getMessage(applicationShortNameIn => 'PER',
3151: messageNameIn => 'AME_400382_RULE_ONE_ACT_SEL');
3152: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
3153: routineNamein => 'change',
3154: exceptionNumberIn => errorCode,
3155: exceptionStringIn => errorMessage);
3156: raise_application_error(errorCode,

Line 3164: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

3160: errorCode := -20001;
3161: errorMessage :=
3162: ame_util.getMessage(applicationShortNameIn => 'PER',
3163: messageNameIn => 'AME_400383_RULE_ONE_ACT_SEL2');
3164: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
3165: routineNamein => 'change',
3166: exceptionNumberIn => errorCode,
3167: exceptionStringIn => errorMessage);
3168: raise_application_error(errorCode,

Line 3176: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

3172: errorCode := -20001;
3173: errorMessage :=
3174: ame_util.getMessage(applicationShortNameIn => 'PER',
3175: messageNameIn => 'AME_400464_RULE_NONPROD_ACTION');
3176: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
3177: routineNamein => 'change',
3178: exceptionNumberIn => errorCode,
3179: exceptionStringIn => errorMessage);
3180: raise_application_error(errorCode,

Line 3188: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

3184: errorCode := -20001;
3185: errorMessage :=
3186: ame_util.getMessage(applicationShortNameIn => 'PER',
3187: messageNameIn => 'AME_400384_RULE_ONE_EXC_COND');
3188: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
3189: routineNamein => 'change',
3190: exceptionNumberIn => errorCode,
3191: exceptionStringIn => errorMessage);
3192: raise_application_error(errorCode,

Line 3200: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

3196: errorCode := -20001;
3197: errorMessage :=
3198: ame_util.getMessage(applicationShortNameIn => 'PER',
3199: messageNameIn => 'AME_400385_RULE_LM');
3200: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
3201: routineNamein => 'change',
3202: exceptionNumberIn => errorCode,
3203: exceptionStringIn => errorMessage);
3204: raise_application_error(errorCode,

Line 3211: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

3207: rollback;
3208: if(ruleStartDateCursor%isOpen) then
3209: close ruleStartDateCursor;
3210: end if;
3211: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
3212: routineNamein => 'change',
3213: exceptionNumberIn => sqlcode,
3214: exceptionStringIn => '(rule ID ' ||
3215: ruleIdIn||

Line 3240: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

3236: end loop;
3237: exception
3238: when others then
3239: rollback;
3240: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
3241: routineNamein => 'changeAllAttributeUseCounts',
3242: exceptionNumberIn => sqlcode,
3243: exceptionStringIn => '(rule ID ' ||
3244: ruleIdIn||

Line 3266: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',

3262: end loop;
3263: exception
3264: when others then
3265: rollback;
3266: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',
3267: routineNameIn => 'changeAttributeUseCounts',
3268: exceptionNumberIn => sqlcode,
3269: exceptionStringIn => '(rule ID ' ||
3270: ruleIdIn||

Line 3289: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',

3285: end loop;
3286: exception
3287: when others then
3288: rollback;
3289: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',
3290: routineNameIn => 'changeAttributeUseCounts2',
3291: exceptionNumberIn => sqlcode,
3292: exceptionStringIn => '(application ID ' ||
3293: applicationIdIn||

Line 3341: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',

3337: commit;
3338: exception
3339: when others then
3340: rollback;
3341: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',
3342: routineNameIn => 'changeRuleStripe',
3343: exceptionNumberIn => sqlcode,
3344: exceptionStringIn => sqlerrm);
3345: raise;

Line 3468: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',

3464: errorCode := -20001;
3465: errorMessage :=
3466: ame_util.getMessage(applicationShortNameIn => 'PER',
3467: messageNameIn => 'AME_400143_ACT_OBJECT_CHNGED');
3468: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',
3469: routineNameIn => 'changeUsage',
3470: exceptionNumberIn => errorCode,
3471: exceptionStringIn => errorMessage);
3472: raise_application_error(errorCode,

Line 3486: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',

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

Line 3498: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',

3494: errorCode := -20001;
3495: errorMessage :=
3496: ame_util.getMessage(applicationShortNameIn => 'PER',
3497: messageNameIn => 'AME_400288_RUL_PRI_NOT_VAL');
3498: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',
3499: routineNameIn => 'changeUsage',
3500: exceptionNumberIn => errorCode,
3501: exceptionStringIn => errorMessage);
3502: raise_application_error(errorCode,

Line 3510: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

3506: errorCode := -20001;
3507: errorMessage :=
3508: ame_util.getMessage(applicationShortNameIn => 'PER',
3509: messageNameIn => 'AME_400213_RUL_STRT_GRTR_CUR');
3510: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
3511: routineNamein => 'changeUsage',
3512: exceptionNumberIn => errorCode,
3513: exceptionStringIn => errorMessage);
3514: raise_application_error(errorCode,

Line 3522: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

3518: errorCode := -20001;
3519: errorMessage :=
3520: ame_util.getMessage(applicationShortNameIn => 'PER',
3521: messageNameIn => 'AME_400214_RUL_STRT_LESS_END');
3522: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
3523: routineNamein => 'changeUsage',
3524: exceptionNumberIn => errorCode,
3525: exceptionStringIn => errorMessage);
3526: raise_application_error(errorCode,

Line 3530: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',

3526: raise_application_error(errorCode,
3527: errorMessage);
3528: when others then
3529: rollback;
3530: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',
3531: routineNameIn => 'changeUsage',
3532: exceptionNumberIn => sqlcode,
3533: exceptionStringIn => '(rule ID ' ||
3534: ruleIdIn||

Line 3580: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',

3576: end if;
3577: exception
3578: when others then
3579: rollback;
3580: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',
3581: routineNameIn => 'dropRuleStripeSet',
3582: exceptionNumberIn => sqlcode,
3583: exceptionStringIn => '(rule ID ' ||
3584: ruleIdIn||

Line 3595: ruleListOut out nocopy ame_rule_pkg.ruleActionRecordTable) as

3591: AME_STRIPING
3592: procedure getAppRuleList(applicationIdIn in integer,
3593: stripeSetIdIn in integer default null,
3594: isStripingIn in varchar2,
3595: ruleListOut out nocopy ame_rule_pkg.ruleActionRecordTable) as
3596: */
3597: procedure getActionIds(ruleIdIn in integer,
3598: actionIdListOut out nocopy ame_util.idList) as
3599: cursor actionCursor(ruleIdIn in integer) is

Line 3622: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

3618: end loop;
3619: exception
3620: when others then
3621: rollback;
3622: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
3623: routineNamein => 'getActionIds',
3624: exceptionNumberIn => sqlcode,
3625: exceptionStringIn => '(rule ID ' ||
3626: ruleIdIn||

Line 3703: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',

3699: end loop;
3700: exception
3701: when others then
3702: rollback;
3703: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',
3704: routineNameIn => 'getActions',
3705: exceptionNumberIn => sqlcode,
3706: exceptionStringIn => '(rule ID ' ||
3707: ruleIdIn||

Line 3785: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',

3781: end loop;
3782: exception
3783: when others then
3784: rollback;
3785: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',
3786: routineNameIn => 'getActions2',
3787: exceptionNumberIn => sqlcode,
3788: exceptionStringIn => '(rule ID ' ||
3789: ruleIdIn||

Line 3797: ruleListOut out nocopy ame_rule_pkg.ruleActionRecordTable) as

3793: actionDescriptionsOut := ame_util.emptyStringList;
3794: raise;
3795: end getActions2;
3796: procedure getAppRuleList(applicationIdIn in integer,
3797: ruleListOut out nocopy ame_rule_pkg.ruleActionRecordTable) as
3798: cursor ruleCursor(applicationIdIn in varchar2) is
3799: select
3800: r.rule_id rule_id,
3801: r.rule_key rule_key,

Line 3893: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',

3889: end loop;
3890: exception
3891: when others then
3892: rollback;
3893: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',
3894: routineNameIn => 'getAppRuleList',
3895: exceptionNumberIn => sqlcode,
3896: exceptionStringIn => '(application ID ' ||
3897: applicationIdIn||

Line 3900: ruleListOut := ame_rule_pkg.emptyRuleActionRecordTable;

3896: exceptionStringIn => '(application ID ' ||
3897: applicationIdIn||
3898: ') ' ||
3899: sqlerrm);
3900: ruleListOut := ame_rule_pkg.emptyRuleActionRecordTable;
3901: raise;
3902: end getAppRuleList;
3903: procedure getAppRuleList2(applicationIdIn in integer,
3904: applicationIdToShareIn in integer,

Line 3948: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',

3944: end loop;
3945: exception
3946: when others then
3947: rollback;
3948: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',
3949: routineNameIn => 'getAppRuleList2',
3950: exceptionNumberIn => sqlcode,
3951: exceptionStringIn => '(application ID ' ||
3952: applicationIdIn||

Line 3997: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

3993: end if;
3994: exception
3995: when others then
3996: rollback;
3997: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
3998: routineNamein => 'getConditionIds',
3999: exceptionNumberIn => sqlcode,
4000: exceptionStringIn => '(rule ID ' ||
4001: ruleIdIn||

Line 4043: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

4039: end if;
4040: exception
4041: when others then
4042: rollback;
4043: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
4044: routineNamein => 'getConditions',
4045: exceptionNumberIn => sqlcode,
4046: exceptionStringIn => '(rule ID ' ||
4047: ruleIdIn||

Line 4079: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

4075: end loop;
4076: exception
4077: when others then
4078: rollback;
4079: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
4080: routineNamein => 'getDetailUrls',
4081: exceptionNumberIn => sqlcode,
4082: exceptionStringIn => '(application ID ' ||
4083: applicationIdIn||

Line 4117: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

4113: end loop;
4114: exception
4115: when others then
4116: rollback;
4117: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
4118: routineNamein => 'getOrdinaryAttributeIds',
4119: exceptionNumberIn => sqlcode,
4120: exceptionStringIn => '(rule ID ' ||
4121: ruleIdIn||

Line 4174: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',

4170: end loop;
4171: exception
4172: when others then
4173: rollback;
4174: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',
4175: routineNameIn => 'getRequiredAttributes',
4176: exceptionNumberIn => sqlcode,
4177: exceptionStringIn => '(rule ID ' ||
4178: ruleIdIn||

Line 4210: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

4206: end loop;
4207: exception
4208: when others then
4209: rollback;
4210: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
4211: routineNamein => 'getRuleAppUsages',
4212: exceptionNumberIn => sqlcode,
4213: exceptionStringIn => '(rule ID ' ||
4214: ruleIdIn||

Line 4243: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

4239: end loop;
4240: exception
4241: when others then
4242: rollback;
4243: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
4244: routineNamein => 'getRuleUsages',
4245: exceptionNumberIn => sqlcode,
4246: exceptionStringIn => sqlerrm);
4247: applicationIdsOut := ame_util.emptyIdList;

Line 4270: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',

4266: close getRuleIdCursor;
4267: exception
4268: when others then
4269: rollback;
4270: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',
4271: routineNameIn => 'getStripeSetRules',
4272: exceptionNumberIn => sqlcode,
4273: exceptionStringIn => sqlerrm);
4274: ruleIdsOut := ame_util.emptyIdList;

Line 4301: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',

4297: close stripeSetCursor;
4298: exception
4299: when others then
4300: rollback;
4301: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',
4302: routineNameIn => 'getStripeSets',
4303: exceptionNumberIn => sqlcode,
4304: exceptionStringIn => sqlerrm);
4305: stripeSetIdsOut := ame_util.emptyIdList;

Line 4336: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

4332: close itemClassesCursor;
4333: exception
4334: when others then
4335: rollback;
4336: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
4337: routineNamein => 'getTransTypeItemClasses',
4338: exceptionNumberIn => sqlcode,
4339: exceptionStringIn => sqlerrm);
4340: itemClassIdsOut := ame_util.emptyStringList;

Line 4377: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

4373: end loop;
4374: exception
4375: when others then
4376: rollback;
4377: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
4378: routineNamein => 'getTypedConditions',
4379: exceptionNumberIn => sqlcode,
4380: exceptionStringIn => '(rule ID ' ||
4381: ruleIdIn||

Line 4423: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

4419: end loop;
4420: exception
4421: when others then
4422: rollback;
4423: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
4424: routineNamein => 'getTypedConditions2',
4425: exceptionNumberIn => sqlcode,
4426: exceptionStringIn => '(rule ID ' ||
4427: ruleIdIn||

Line 4455: ame_rule_pkg.getConditionIds(ruleIdIn => ruleIdIn,

4451: else
4452: processingDate := processingDateIn;
4453: end if;
4454: endDate := processingDate;
4455: ame_rule_pkg.getConditionIds(ruleIdIn => ruleIdIn,
4456: conditionIdListOut => conditionIdList);
4457: conditionCount := conditionIdList.count;
4458: for tempIndex in 1..conditionCount loop
4459: ame_condition_pkg.removeConditionUsage(ruleIdIn => ruleIdIn,

Line 4486: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

4482: errorCode := -20001;
4483: errorMessage :=
4484: ame_util.getMessage(applicationShortNameIn => 'PER',
4485: messageNameIn => 'AME_400216_RUL_IN_USE');
4486: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
4487: routineNamein => 'remove',
4488: exceptionNumberIn => errorCode,
4489: exceptionStringIn => errorMessage);
4490: raise_application_error(errorCode,

Line 4494: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

4490: raise_application_error(errorCode,
4491: errorMessage);
4492: when others then
4493: rollback;
4494: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
4495: routineNamein => 'remove',
4496: exceptionNumberIn => sqlcode,
4497: exceptionStringIn => '(rule ID ' ||
4498: ruleIdIn||

Line 4542: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',

4538: end if;
4539: exception
4540: when others then
4541: rollback;
4542: ame_util.runtimeException(packageNamein => 'ame_rule_pkg',
4543: routineNamein => 'removeRuleStripeSet',
4544: exceptionNumberIn => sqlcode,
4545: exceptionStringIn => sqlerrm);
4546: raise;

Line 4715: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',

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

Line 4730: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',

4726: errorCode := -20001;
4727: errorMessage :=
4728: ame_util.getMessage(applicationShortNameIn => 'PER',
4729: messageNameIn => 'AME_400145_ACT_OBJECT_DELETED');
4730: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',
4731: routineNameIn => 'removeUsage',
4732: exceptionNumberIn => errorCode,
4733: exceptionStringIn => errorMessage);
4734: raise_application_error(errorCode,

Line 4741: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',

4737: rollback;
4738: if(startDateCursor%isOpen) then
4739: close startDateCursor;
4740: end if;
4741: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',
4742: routineNameIn => 'removeUsage',
4743: exceptionNumberIn => sqlcode,
4744: exceptionStringIn => '(rule ID ' ||
4745: ruleIdIn||

Line 4848: ame_rule_pkg.newRuleStripeSet(applicationIdIn => applicationIdIn,

4844: if(tempStripeSetId is null) then
4845: tempStripeSetId := ame_admin_pkg.newStripeSet(applicationIdIn => applicationIdIn,
4846: attributeValuesIn => stripingAttributeValues);
4847: end if;
4848: ame_rule_pkg.newRuleStripeSet(applicationIdIn => applicationIdIn,
4849: ruleIdIn => ruleIdIn,
4850: stripeSetIdIn => tempStripeSetId);
4851: end if;
4852: end loop;

Line 4862: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',

4858: rollback;
4859: if(applicationIdCursor%isopen) then
4860: close applicationIdCursor;
4861: end if;
4862: ame_util.runtimeException(packageNameIn => 'ame_rule_pkg',
4863: routineNameIn => 'updateRuleStripeSets',
4864: exceptionNumberIn => sqlcode,
4865: exceptionStringIn => '(rule ID ' ||
4866: ruleIdIn||

Line 4873: end ame_rule_pkg;

4869: raise;
4870: end updateRuleStripeSets;
4871: */
4872: /* Get the rule id only once */
4873: end ame_rule_pkg;