APPS.AME_ACTION_PKG dependencies on AME_ACTION_PKG

Line 1: package body ame_action_pkg as

1: package body ame_action_pkg as
2: /* $Header: ameoacti.pkb 120.1 2006/12/26 12:59:25 avarri noship $ */
3: function actionTypeIsInUse(actionTypeIdIn in integer) return boolean as
4: useCount integer;
5: begin

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

16: return(false);
17: exception
18: when others then
19: rollback;
20: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
21: routineNameIn => 'actionTypeIsInUse',
22: exceptionNumberIn => sqlcode,
23: exceptionStringIn => '(action type ID ' ||
24: actionTypeIdIn||

Line 44: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

40: return(descriptionQuery);
41: exception
42: when others then
43: rollback;
44: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
45: routineNameIn => 'getActionTypeDescQuery',
46: exceptionNumberIn => sqlcode,
47: exceptionStringIn => '(action type ID ' ||
48: actionTypeIdIn||

Line 68: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

64: return(dynamicDescription);
65: exception
66: when others then
67: rollback;
68: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
69: routineNameIn => 'getActionTypeDynamicDesc',
70: exceptionNumberIn => sqlcode,
71: exceptionStringIn => '(action type ID ' ||
72: actionTypeIdIn||

Line 92: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

88: return(actionTypeId);
89: exception
90: when others then
91: rollback;
92: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
93: routineNameIn => 'getActionTypeIdById',
94: exceptionNumberIn => sqlcode,
95: exceptionStringIn => '(action ID ' ||
96: actionIdIn||

Line 116: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

112: return(actionTypeId);
113: exception
114: when others then
115: rollback;
116: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
117: routineNameIn => 'getActionTypeIdByName',
118: exceptionNumberIn => sqlcode,
119: exceptionStringIn => '(action name ' ||
120: actionTypeNameIn||

Line 140: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

136: return(description);
137: exception
138: when others then
139: rollback;
140: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
141: routineNameIn => 'getActionTypeDescription',
142: exceptionNumberIn => sqlcode,
143: exceptionStringIn => '(action type ID ' ||
144: actionTypeIdIn||

Line 174: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

170: return(orderNumber);
171: exception
172: when others then
173: rollback;
174: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
175: routineNameIn => 'getActionTypeMaxOrderNumber',
176: exceptionNumberIn => sqlcode,
177: exceptionStringIn => sqlerrm);
178: raise;

Line 198: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

194: return(name);
195: exception
196: when others then
197: rollback;
198: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
199: routineNameIn => 'getActionTypeName',
200: exceptionNumberIn => sqlcode,
201: exceptionStringIn => '(action type ID ' ||
202: actionTypeIdIn||

Line 226: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

222: return(name);
223: exception
224: when others then
225: rollback;
226: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
227: routineNameIn => 'getActionTypeNameByActionId',
228: exceptionNumberIn => sqlcode,
229: exceptionStringIn => '(action ID ' ||
230: actionIdIn||

Line 250: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

246: return(procedureName);
247: exception
248: when others then
249: rollback;
250: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
251: routineNameIn => 'getActionTypeProcedureName',
252: exceptionNumberIn => sqlcode,
253: exceptionStringIn => '(action type ID ' ||
254: actionTypeIdIn||

Line 276: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

272: return(orderNumber);
273: exception
274: when others then
275: rollback;
276: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
277: routineNameIn => 'getActionTypeOrderNumber',
278: exceptionNumberIn => sqlcode,
279: exceptionStringIn => '(action type ID ' ||
280: actionTypeIdIn||

Line 300: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

296: return(createdBy);
297: exception
298: when others then
299: rollback;
300: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
301: routineNameIn => 'getActionTypeCreatedBy',
302: exceptionNumberIn => sqlcode,
303: exceptionStringIn => '(action type ID ' ||
304: actionTypeIdIn||

Line 338: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

334: end if;
335: exception
336: when others then
337: rollback;
338: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
339: routineNameIn => 'getAllowedRuleType',
340: exceptionNumberIn => sqlcode,
341: exceptionStringIn => sqlerrm);
342: raise;

Line 368: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

364: end if;
365: exception
366: when others then
367: rollback;
368: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
369: routineNameIn => 'getAllowedRuleTypeLabel',
370: exceptionNumberIn => sqlcode,
371: exceptionStringIn => sqlerrm);
372: raise;

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

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

Line 414: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

410: return(stringStartDate);
411: exception
412: when others then
413: rollback;
414: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
415: routineNameIn => 'getChildVersionStartDate',
416: exceptionNumberIn => sqlcode,
417: exceptionStringIn => sqlerrm);
418: raise;

Line 439: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

435: return(stringStartDate);
436: exception
437: when others then
438: rollback;
439: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
440: routineNameIn => 'getChildVersionStartDate2',
441: exceptionNumberIn => sqlcode,
442: exceptionStringIn => sqlerrm);
443: raise;

Line 488: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

484: return(actionTypeName|| ': '|| description);
485: exception
486: when others then
487: rollback;
488: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
489: routineNameIn => 'getDescription',
490: exceptionNumberIn => sqlcode,
491: exceptionStringIn => '(action ID ' ||
492: actionIdIn||

Line 532: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

528: return(description);
529: exception
530: when others then
531: rollback;
532: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
533: routineNameIn => 'getDescription2',
534: exceptionNumberIn => sqlcode,
535: exceptionStringIn => '(action ID ' ||
536: actionIdIn||

Line 591: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

587: return(actionTypeName || ': '|| actionDescription);
588: exception
589: when others then
590: rollback;
591: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
592: routineNameIn => 'getDynamicActionDesc',
593: exceptionNumberIn => sqlcode,
594: exceptionStringIn => '(action ID ' ||
595: actionIdIn||

Line 614: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

610: return actionTypeId;
611: exception
612: when others then
613: rollback;
614: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
615: routineNameIn => 'getGroupChainActionTypeId',
616: exceptionNumberIn => sqlcode,
617: exceptionStringIn => sqlerrm);
618: raise;

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

633: return(actionId);
634: exception
635: when others then
636: rollback;
637: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
638: routineNameIn => 'getId',
639: exceptionNumberIn => sqlcode,
640: exceptionStringIn => '(action type ID ' ||
641: actionTypeIdIn||

Line 661: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

657: return(parameter);
658: exception
659: when others then
660: rollback;
661: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
662: routineNameIn => 'getParameter',
663: exceptionNumberIn => sqlcode,
664: exceptionStringIn => '(action ID ' ||
665: actionIdIn||

Line 685: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

681: return(parameterTwo);
682: exception
683: when others then
684: rollback;
685: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
686: routineNameIn => 'getParameter2',
687: exceptionNumberIn => sqlcode,
688: exceptionStringIn => '(action ID ' ||
689: actionIdIn||

Line 711: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

707: return(stringStartDate);
708: exception
709: when others then
710: rollback;
711: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
712: routineNameIn => 'getParentVersionStartDate',
713: exceptionNumberIn => sqlcode,
714: exceptionStringIn => '(action type ID ' ||
715: actionTypeIdIn||

Line 734: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

730: return actionTypeId;
731: exception
732: when others then
733: rollback;
734: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
735: routineNameIn => 'getPreApprovalActionTypeId',
736: exceptionNumberIn => sqlcode,
737: exceptionStringIn => sqlerrm);
738: raise;

Line 754: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

750: return actionTypeId;
751: exception
752: when others then
753: rollback;
754: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
755: routineNameIn => 'getPostApprovalActionTypeId',
756: exceptionNumberIn => sqlcode,
757: exceptionStringIn => sqlerrm);
758: raise;

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

773: return(votingRegime);
774: exception
775: when others then
776: rollback;
777: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
778: routineNameIn => 'getVotingRegime',
779: exceptionNumberIn => sqlcode,
780: exceptionStringIn => sqlerrm);
781: raise;

Line 817: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

813: return(false);
814: exception
815: when others then
816: rollback;
817: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
818: routineNameIn => 'isInUse',
819: exceptionNumberIn => sqlcode,
820: exceptionStringIn => '(action ID ' ||
821: actionIdIn||

Line 845: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

841: return(false);
842: exception
843: when others then
844: rollback;
845: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
846: routineNameIn => 'isListCreationRuleType',
847: exceptionNumberIn => sqlcode,
848: exceptionStringIn => '(action type ID ' ||
849: actionTypeIdIn||

Line 873: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

869: return(false);
870: exception
871: when others then
872: rollback;
873: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
874: routineNameIn => 'isSeeded',
875: exceptionNumberIn => sqlcode,
876: exceptionStringIn => '(action type ID ' ||
877: actionTypeIdIn||

Line 1034: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

1030: rollback;
1031: errorCode := -20001;
1032: errorMessage := ame_util.getMessage(applicationShortNameIn => 'PER',
1033: messageNameIn => 'AME_400370_ACT_DYNAMIC_DESC');
1034: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
1035: routineNameIn => 'new',
1036: exceptionNumberIn => errorCode,
1037: exceptionStringIn => errorMessage);
1038: raise_application_error(errorCode,

Line 1046: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

1042: rollback;
1043: errorCode := -20001;
1044: errorMessage := ame_util.getMessage(applicationShortNameIn => 'PER',
1045: messageNameIn => 'AME_400371_ACT_INV_BIND_VAR');
1046: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
1047: routineNameIn => 'new',
1048: exceptionNumberIn => errorCode,
1049: exceptionStringIn => errorMessage);
1050: raise_application_error(errorCode,

Line 1063: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

1059: tokenNameOneIn => 'COLUMN_LENGTH',
1060: tokenValueOneIn =>
1061: ame_util.getColumnLength(tableNameIn => 'ame_action_types',
1062: columnNameIn => 'name'));
1063: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
1064: routineNameIn => 'new',
1065: exceptionNumberIn => errorCode,
1066: exceptionStringIn => errorMessage);
1067: raise_application_error(errorCode,

Line 1080: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

1076: tokenNameOneIn => 'COLUMN_LENGTH',
1077: tokenValueOneIn =>
1078: ame_util.getColumnLength(tableNameIn => 'ame_action_types',
1079: columnNameIn => 'procedure_name'));
1080: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
1081: routineNameIn => 'new',
1082: exceptionNumberIn => errorCode,
1083: exceptionStringIn => errorMessage);
1084: raise_application_error(errorCode,

Line 1097: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

1093: tokenNameOneIn => 'COLUMN_LENGTH',
1094: tokenValueOneIn =>
1095: ame_util.getColumnLength(tableNameIn => 'ame_action_types',
1096: columnNameIn => 'description'));
1097: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
1098: routineNameIn => 'new',
1099: exceptionNumberIn => errorCode,
1100: exceptionStringIn => errorMessage);
1101: raise_application_error(errorCode,

Line 1109: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

1105: rollback;
1106: errorCode := -20001;
1107: errorMessage := ame_util.getMessage(applicationShortNameIn => 'PER',
1108: messageNameIn => 'AME_400144_ACT_VALUE_APT_ENT');
1109: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
1110: routineNameIn => 'new',
1111: exceptionNumberIn => errorCode,
1112: exceptionStringIn => errorMessage);
1113: raise_application_error(errorCode,

Line 1122: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

1118: errorCode := -20001;
1119: errorMessage :=
1120: ame_util.getMessage(applicationShortNameIn => 'PER',
1121: messageNameIn => 'AME_400372_ACT DYNAMIC_DESC2');
1122: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
1123: routineNameIn => 'new',
1124: exceptionNumberIn => errorCode,
1125: exceptionStringIn => errorMessage);
1126: raise_application_error(errorCode,

Line 1134: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

1130: errorCode := -20001;
1131: errorMessage :=
1132: ame_util.getMessage(applicationShortNameIn => 'PER',
1133: messageNameIn => 'AME_400373_ACT DYNAMIC_DESC3');
1134: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
1135: routineNameIn => 'new',
1136: exceptionNumberIn => errorCode,
1137: exceptionStringIn => errorMessage);
1138: raise_application_error(errorCode,

Line 1150: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

1146: tokenNameOneIn => 'COLUMN_LENGTH',
1147: tokenValueOneIn =>
1148: ame_util.getColumnLength(tableNameIn => 'ame_action_types',
1149: columnNameIn => 'description_query'));
1150: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
1151: routineNameIn => 'new',
1152: exceptionNumberIn => errorCode,
1153: exceptionStringIn => errorMessage);
1154: raise_application_error(errorCode,

Line 1159: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

1155: errorMessage);
1156: return(null);
1157: when others then
1158: rollback;
1159: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
1160: routineNameIn => 'new',
1161: exceptionNumberIn => sqlcode,
1162: exceptionStringIn => '(action type ID ' ||
1163: actionTypeIdIn||

Line 1307: actionTypeName := ame_action_pkg.getActionTypeName(actionTypeIdIn => actionTypeIdIn);

1303: nvl(newStartDateIn, startDate),
1304: null,
1305: descriptionIn,
1306: parameterTwoIn);
1307: actionTypeName := ame_action_pkg.getActionTypeName(actionTypeIdIn => actionTypeIdIn);
1308: if(updateParentObjectIn) then
1309: endDate := startDate ;
1310: actionTypeDescription := getActionTypeDescription(actionTypeIdIn => actionTypeIdIn);
1311: actionTypeProcedureName := getActionTypeProcedureName(actionTypeIdIn => actionTypeIdIn);

Line 1347: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

1343: end if;
1344: errorCode := -20001;
1345: errorMessage := ame_util.getMessage(applicationShortNameIn => 'PER',
1346: messageNameIn => 'AME_400143_ACT_OBJECT_CHNGED');
1347: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
1348: routineNameIn => 'newAction',
1349: exceptionNumberIn => errorCode,
1350: exceptionStringIn => errorMessage);
1351: raise_application_error(errorCode,

Line 1361: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

1357: end if;
1358: errorCode := -20001;
1359: errorMessage := ame_util.getMessage(applicationShortNameIn => 'PER',
1360: messageNameIn => 'AME_400145_ACT_OBJECT_DELETED');
1361: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
1362: routineNameIn => 'newAction',
1363: exceptionNumberIn => errorCode,
1364: exceptionStringIn => errorMessage);
1365: raise_application_error(errorCode,

Line 1375: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

1371: end if;
1372: errorCode := -20001;
1373: errorMessage := ame_util.getMessage(applicationShortNameIn => 'PER',
1374: messageNameIn => 'AME_400137_ACT_EMPTY_DESC');
1375: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
1376: routineNameIn => 'newAction',
1377: exceptionNumberIn => errorCode,
1378: exceptionStringIn => errorMessage);
1379: raise_application_error(errorCode,

Line 1389: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

1385: end if;
1386: errorCode := -20001;
1387: errorMessage := ame_util.getMessage(applicationShortNameIn => 'PER',
1388: messageNameIn => 'AME_400293_ACT_APR_ALD_EXISTS');
1389: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
1390: routineNameIn => 'newAction',
1391: exceptionNumberIn => errorCode,
1392: exceptionStringIn => errorMessage);
1393: raise_application_error(errorCode,

Line 1400: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

1396: rollback;
1397: errorCode := -20001;
1398: errorMessage := ame_util.getMessage(applicationShortNameIn => 'PER',
1399: messageNameIn => 'AME_400135_ACT_NO_PAR_SEMI');
1400: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
1401: routineNameIn => 'newAction',
1402: exceptionNumberIn => errorCode,
1403: exceptionStringIn => errorMessage);
1404: raise_application_error(errorCode,

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

1412: tokenNameOneIn => 'COLUMN_LENGTH',
1413: tokenValueOneIn =>
1414: ame_util.getColumnLength(tableNameIn => 'ame_actions',
1415: columnNameIn => 'description'));
1416: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
1417: routineNameIn => 'newAction',
1418: exceptionNumberIn => errorCode,
1419: exceptionStringIn => errorMessage);
1420: raise_application_error(errorCode,

Line 1432: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

1428: tokenNameOneIn => 'COLUMN_LENGTH',
1429: tokenValueOneIn =>
1430: ame_util.getColumnLength(tableNameIn => 'ame_actions',
1431: columnNameIn => 'parameter'));
1432: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
1433: routineNameIn => 'newAction',
1434: exceptionNumberIn => errorCode,
1435: exceptionStringIn => errorMessage);
1436: raise_application_error(errorCode,

Line 1445: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

1441: errorCode := -20001;
1442: errorMessage :=
1443: ame_util.getMessage(applicationShortNameIn => 'PER',
1444: messageNameIn => 'AME_400323_INV_ATTRIB_ENT_PAR');
1445: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
1446: routineNameIn => 'newAction',
1447: exceptionNumberIn => errorCode,
1448: exceptionStringIn => errorMessage);
1449: raise_application_error(errorCode,

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

1450: errorMessage);
1451: return(null);
1452: when others then
1453: rollback;
1454: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
1455: routineNameIn => 'newAction',
1456: exceptionNumberIn => sqlcode,
1457: exceptionStringIn => '(action type ID ' ||
1458: actionTypeIdIn||

Line 1492: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

1488: end if;
1489: exception
1490: when others then
1491: rollback;
1492: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
1493: routineNameIn => 'orderNumberUnique',
1494: exceptionNumberIn => sqlcode,
1495: exceptionStringIn => sqlerrm);
1496: raise;

Line 1518: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

1514: return false;
1515: exception
1516: when others then
1517: rollback;
1518: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
1519: routineNameIn => 'requiredAttOnApprovalTypeList',
1520: exceptionNumberIn => sqlcode,
1521: exceptionStringIn => '(action type ID ' ||
1522: actionTypeIdIn||

Line 1619: ame_action_pkg.getChildVersionStartDate(actionIdIn => deleteListIn(i)));

1615: else
1616: actionIdList(tempIndex) := deleteListIn(i);
1617: childVersionStartDates(tempIndex) :=
1618: ame_util.versionStringToDate(stringDateIn =>
1619: ame_action_pkg.getChildVersionStartDate(actionIdIn => deleteListIn(i)));
1620: tempIndex := tempIndex + 1;
1621: end if;
1622: end loop;
1623: -- Check if any approver types were selected for deletion.

Line 1651: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

1647: end if;
1648: errorCode := -20001;
1649: errorMessage := ame_util.getMessage(applicationShortNameIn => 'PER',
1650: messageNameIn => 'AME_400143_ACT_OBJECT_CHNGED');
1651: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
1652: routineNameIn => 'change',
1653: exceptionNumberIn => errorCode,
1654: exceptionStringIn => errorMessage);
1655: raise_application_error(errorCode,

Line 1665: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

1661: end if;
1662: errorCode := -20001;
1663: errorMessage := ame_util.getMessage(applicationShortNameIn => 'PER',
1664: messageNameIn => 'AME_400145_ACT_OBJECT_DELETED');
1665: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
1666: routineNameIn => 'change',
1667: exceptionNumberIn => errorCode,
1668: exceptionStringIn => errorMessage);
1669: raise_application_error(errorCode,

Line 1676: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

1672: rollback;
1673: if(startDateCursor%isOpen) then
1674: close startDateCursor;
1675: end if;
1676: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
1677: routineNameIn => 'change',
1678: exceptionNumberIn => sqlcode,
1679: exceptionStringIn => '(action type ID ' ||
1680: actionTypeIdIn||

Line 1816: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

1812: end if;
1813: errorCode := -20001;
1814: errorMessage := ame_util.getMessage(applicationShortNameIn => 'PER',
1815: messageNameIn => 'AME_400137_ACT_EMPTY_DESC');
1816: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
1817: routineNameIn => 'changeAction',
1818: exceptionNumberIn => errorCode,
1819: exceptionStringIn => errorMessage);
1820: raise_application_error(errorCode,

Line 1833: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

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

Line 1850: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

1846: end if;
1847: errorCode := -20001;
1848: errorMessage := ame_util.getMessage(applicationShortNameIn => 'PER',
1849: messageNameIn => 'AME_400145_ACT_OBJECT_DELETED');
1850: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
1851: routineNameIn => 'changeAction',
1852: exceptionNumberIn => errorCode,
1853: exceptionStringIn => errorMessage);
1854: raise_application_error(errorCode,

Line 1864: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

1860: end if;
1861: if(startDateCursor%isOpen) then
1862: close startDateCursor;
1863: end if;
1864: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
1865: routineNameIn => 'changeAction',
1866: exceptionNumberIn => sqlcode,
1867: exceptionStringIn => '(action ID ' ||
1868: actionIdIn||

Line 1947: ame_action_pkg.change(actionTypeIdIn => actionTypeIdIn,

1943: if(descriptionQueryIn is null) then
1944: raise nullDescriptionQueryException;
1945: end if;
1946: end if;
1947: ame_action_pkg.change(actionTypeIdIn => actionTypeIdIn,
1948: nameIn => nameIn,
1949: procedureNameIn => procedureNameIn,
1950: descriptionIn => descriptionIn,
1951: descriptionQueryIn => descriptionQueryIn,

Line 1956: ame_action_pkg.changeActionTypeConfig(actionTypeIdIn => actionTypeIdIn,

1952: ruleTypeIn => ruleTypeIn,
1953: deleteListIn => deleteListIn,
1954: processingDateIn => processingDate,
1955: finalizeIn => false);
1956: ame_action_pkg.changeActionTypeConfig(actionTypeIdIn => actionTypeIdIn,
1957: orderNumberIn => orderNumberIn,
1958: orderNumberUniqueIn => orderNumberUniqueIn,
1959: chainOrderingModeIn => chainOrderingModeIn,
1960: votingRegimeIn => votingRegimeIn,

Line 1982: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

1978: errorCode := -20001;
1979: errorMessage :=
1980: ame_util.getMessage(applicationShortNameIn => 'PER',
1981: messageNameIn => 'AME_400143_ACT_OBJECT_CHNGED');
1982: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
1983: routineNameIn => 'changeActionTypeAndConfig',
1984: exceptionNumberIn => errorCode,
1985: exceptionStringIn => errorMessage);
1986: raise_application_error(errorCode,

Line 2000: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

1996: errorCode := -20001;
1997: errorMessage :=
1998: ame_util.getMessage(applicationShortNameIn => 'PER',
1999: messageNameIn => 'AME_400145_ACT_OBJECT_DELETED');
2000: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
2001: routineNameIn => 'changeActionTypeAndConfig',
2002: exceptionNumberIn => errorCode,
2003: exceptionStringIn => errorMessage);
2004: raise_application_error(errorCode,

Line 2011: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

2007: rollback;
2008: errorCode := -20001;
2009: errorMessage := ame_util.getMessage(applicationShortNameIn => 'PER',
2010: messageNameIn => 'AME_400144_ACT_VALUE_APT_ENT');
2011: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
2012: routineNameIn => 'changeActionTypeAndConfig',
2013: exceptionNumberIn => errorCode,
2014: exceptionStringIn => errorMessage);
2015: raise_application_error(errorCode,

Line 2022: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

2018: rollback;
2019: errorCode := -20001;
2020: errorMessage := ame_util.getMessage(applicationShortNameIn => 'PER',
2021: messageNameIn => 'AME_400373_ACT DYNAMIC_DESC3');
2022: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
2023: routineNameIn => 'changeActionTypeAndConfig',
2024: exceptionNumberIn => errorCode,
2025: exceptionStringIn => errorMessage);
2026: raise_application_error(errorCode,

Line 2036: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

2032: end if;
2033: if(startDateCursor2%isOpen) then
2034: close startDateCursor2;
2035: end if;
2036: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
2037: routineNameIn => 'changeActionTypeAndConfig',
2038: exceptionNumberIn => sqlcode,
2039: exceptionStringIn => '(action type ID ' ||
2040: actionTypeIdIn||

Line 2066: if(ame_action_pkg.orderNumberUnique(applicationIdIn => applicationIdIn,

2062: updateOnlyATModified boolean;
2063: begin
2064: oldOrderNumber := getActionTypeOrderNumber(applicationIdIn => applicationIdIn,
2065: actionTypeIdIn => actionTypeIdIn);
2066: if(ame_action_pkg.orderNumberUnique(applicationIdIn => applicationIdIn,
2067: orderNumberIn => oldOrderNumber,
2068: actionTypeIdIn => actionTypeIdIn)) then
2069: oldOrderNumberUnique := ame_util.yes;
2070: else

Line 2191: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

2187: errorCode := -20001;
2188: errorMessage :=
2189: ame_util.getMessage(applicationShortNameIn => 'PER',
2190: messageNameIn => 'AME_400463_ORD_NUM_UNIQUE');
2191: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
2192: routineNameIn => 'changeActionTypeConfig',
2193: exceptionNumberIn => errorCode,
2194: exceptionStringIn => errorMessage);
2195: raise_application_error(errorCode,

Line 2199: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

2195: raise_application_error(errorCode,
2196: errorMessage);
2197: when others then
2198: rollback;
2199: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
2200: routineNameIn => 'changeActionTypeConfig',
2201: exceptionNumberIn => sqlcode,
2202: exceptionStringIn => '(action type ID ' ||
2203: actionTypeIdIn||

Line 2293: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

2289: end if;
2290: exception
2291: when others then
2292: rollback;
2293: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
2294: routineNameIn => 'decrementActionTypeOrdNumbers',
2295: exceptionNumberIn => sqlcode,
2296: exceptionStringIn => sqlerrm);
2297: raise;

Line 2334: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

2330: end if;
2331: exception
2332: when others then
2333: rollback;
2334: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
2335: routineNameIn => 'getActions',
2336: exceptionNumberIn => sqlcode,
2337: exceptionStringIn => '(action type ID ' ||
2338: actionTypeIdIn||

Line 2379: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

2375: end if;
2376: exception
2377: when others then
2378: rollback;
2379: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
2380: routineNameIn => 'getActions2',
2381: exceptionNumberIn => sqlcode,
2382: exceptionStringIn => '(action type ID ' ||
2383: actionTypeIdIn||

Line 2460: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

2456: end loop;
2457: exception
2458: when others then
2459: rollback;
2460: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
2461: routineNameIn => 'getActions3',
2462: exceptionNumberIn => sqlcode,
2463: exceptionStringIn => '(action type ID ' ||
2464: actionTypeIdIn||

Line 2534: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

2530: end loop;
2531: exception
2532: when others then
2533: rollback;
2534: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
2535: routineNameIn => 'getActions4',
2536: exceptionNumberIn => sqlcode,
2537: exceptionStringIn => sqlerrm);
2538: actionIdsOut := ame_util.emptyStringList;

Line 2563: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

2559: end loop;
2560: exception
2561: when others then
2562: rollback;
2563: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
2564: routineNameIn => 'getActionTypes',
2565: exceptionNumberIn => sqlcode,
2566: exceptionStringIn => sqlerrm);
2567: actionTypesOut := ame_util.emptyIdStringTable;

Line 2592: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

2588: end loop;
2589: exception
2590: when others then
2591: rollback;
2592: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
2593: routineNameIn => 'getActionTypes2',
2594: exceptionNumberIn => sqlcode,
2595: exceptionStringIn => sqlerrm);
2596: actionTypeIdsOut := ame_util.emptyStringList;

Line 2641: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

2637: end loop;
2638: exception
2639: when others then
2640: rollback;
2641: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
2642: routineNameIn => 'getActionTypes3',
2643: exceptionNumberIn => sqlcode,
2644: exceptionStringIn => sqlerrm);
2645: actionTypeIdsOut := ame_util.emptyStringList;

Line 2673: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

2669: end loop;
2670: exception
2671: when others then
2672: rollback;
2673: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
2674: routineNameIn => 'getActionTypeDescriptions',
2675: exceptionNumberIn => sqlcode,
2676: exceptionStringIn => sqlerrm);
2677: actionTypeIdsOut := ame_util.emptyStringList;

Line 2700: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

2696: end loop;
2697: exception
2698: when others then
2699: rollback;
2700: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
2701: routineNameIn => 'getActionTypeUsages',
2702: exceptionNumberIn => sqlcode,
2703: exceptionStringIn => '(action type ID ' ||
2704: actionTypeIdIn||

Line 2733: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

2729: close getRuleTypesCur;
2730: exception
2731: when others then
2732: rollback;
2733: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
2734: routineNameIn => 'getActionTypeUsages2',
2735: exceptionNumberIn => sqlcode,
2736: exceptionStringIn => sqlerrm);
2737: actionTypeIdsOut := ame_util.emptyIdList;

Line 2769: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

2765: close getApproverTypesCursor;
2766: exception
2767: when others then
2768: rollback;
2769: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
2770: routineNameIn => 'getAllowedApproverTypes',
2771: exceptionNumberIn => sqlcode,
2772: exceptionStringIn => '(action type ID ' ||
2773: actionTypeIdIn||

Line 2798: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

2794: allowedRuleTypeLabelsOut(6) := ame_util.getLabel(ame_util.perFndAppId,'AME_PRODUCTION');
2795: exception
2796: when others then
2797: rollback;
2798: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
2799: routineNameIn => 'getAllowedRuleTypeLabels',
2800: exceptionNumberIn => sqlcode,
2801: exceptionStringIn => sqlerrm);
2802: allowedRuleTypesOut := ame_util.emptyStringList;

Line 2917: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

2913: end if;
2914: exception
2915: when others then
2916: rollback;
2917: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
2918: routineNameIn => 'getAvailableActionTypes',
2919: exceptionNumberIn => sqlcode,
2920: exceptionStringIn => sqlerrm);
2921: actionTypeIdsOut := ame_util.emptyStringList;

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

3035: end if;
3036: exception
3037: when others then
3038: rollback;
3039: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
3040: routineNameIn => 'getAvailCombActionTypes',
3041: exceptionNumberIn => sqlcode,
3042: exceptionStringIn => sqlerrm);
3043: actionTypeIdsOut := ame_util.emptyStringList;

Line 3135: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

3131: end if;
3132: exception
3133: when others then
3134: rollback;
3135: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
3136: routineNameIn => 'incrementActionTypeOrdNumbers',
3137: exceptionNumberIn => sqlcode,
3138: exceptionStringIn => sqlerrm);
3139: raise;

Line 3169: ame_action_pkg.getActionTypeMaxOrderNumber(applicationIdIn => applicationIdIn,

3165: begin
3166: currentUserId := ame_util.getCurrentUserId;
3167: processingDate := sysdate;
3168: maxOrderNumber :=
3169: ame_action_pkg.getActionTypeMaxOrderNumber(applicationIdIn => applicationIdIn,
3170: ruleTypeIn => ruleTypeIn);
3171: open applicationIdCursor;
3172: fetch applicationIdCursor bulk collect
3173: into

Line 3248: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

3244: end if;
3245: exception
3246: when others then
3247: rollback;
3248: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
3249: routineNameIn => 'newActionTypeConfig',
3250: exceptionNumberIn => sqlcode,
3251: exceptionStringIn => sqlerrm);
3252: end newActionTypeConfig;

Line 3330: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

3326: end if;
3327: exception
3328: when others then
3329: rollback;
3330: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
3331: routineNameIn => 'newActionTypeUsage',
3332: exceptionNumberIn => sqlcode,
3333: exceptionStringIn => '(action type ID ' ||
3334: actionTypeIdIn||

Line 3466: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

3462: end if;
3463: errorCode := -20001;
3464: errorMessage := ame_util.getMessage(applicationShortNameIn => 'PER',
3465: messageNameIn => 'AME_400143_ACT_OBJECT_CHNGED');
3466: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
3467: routineNameIn => 'remove',
3468: exceptionNumberIn => errorCode,
3469: exceptionStringIn => errorMessage);
3470: raise_application_error(errorCode,

Line 3480: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

3476: end if;
3477: errorCode := -20001;
3478: errorMessage := ame_util.getMessage(applicationShortNameIn => 'PER',
3479: messageNameIn => 'AME_400145_ACT_OBJECT_DELETED');
3480: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
3481: routineNameIn => 'remove',
3482: exceptionNumberIn => errorCode,
3483: exceptionStringIn => errorMessage);
3484: raise_application_error(errorCode,

Line 3491: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

3487: rollback;
3488: errorCode := -20001;
3489: errorMessage := ame_util.getMessage(applicationShortNameIn => 'PER',
3490: messageNameIn => 'AME_400148_ACT_REM_APPR_ASSOC');
3491: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
3492: routineNameIn => 'remove',
3493: exceptionNumberIn => errorCode,
3494: exceptionStringIn => errorMessage);
3495: raise_application_error(errorCode,

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

3498: rollback;
3499: if(startDateCursor%isOpen) then
3500: close startDateCursor;
3501: end if;
3502: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
3503: routineNameIn => 'remove',
3504: exceptionNumberIn => sqlcode,
3505: exceptionStringIn => '(action type ID ' ||
3506: actionTypeIdIn||

Line 3604: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

3600: end if;
3601: errorCode := -20001;
3602: errorMessage := ame_util.getMessage(applicationShortNameIn => 'PER',
3603: messageNameIn => 'AME_400143_ACT_OBJECT_CHNGED');
3604: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
3605: routineNameIn => 'removeAction',
3606: exceptionNumberIn => errorCode,
3607: exceptionStringIn => errorMessage);
3608: raise_application_error(errorCode,

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

3614: end if;
3615: errorCode := -20001;
3616: errorMessage := ame_util.getMessage(applicationShortNameIn => 'PER',
3617: messageNameIn => 'AME_400145_ACT_OBJECT_DELETED');
3618: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
3619: routineNameIn => 'removeAction',
3620: exceptionNumberIn => errorCode,
3621: exceptionStringIn => errorMessage);
3622: raise_application_error(errorCode,

Line 3632: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

3628: end if;
3629: errorCode := -20001;
3630: errorMessage := ame_util.getMessage(applicationShortNameIn => 'PER',
3631: messageNameIn => 'AME_400147_ACT_APR_IN_USE');
3632: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
3633: routineNameIn => 'removeAction',
3634: exceptionNumberIn => errorCode,
3635: exceptionStringIn => errorMessage);
3636: raise_application_error(errorCode,

Line 3643: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

3639: rollback;
3640: if(startDateCursor2%isOpen) then
3641: close startDateCursor2;
3642: end if;
3643: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
3644: routineNameIn => 'removeAction',
3645: exceptionNumberIn => sqlcode,
3646: exceptionStringIn => '(action type ID ' ||
3647: actionTypeIdIn||

Line 3682: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

3678: end if;
3679: exception
3680: when others then
3681: rollback;
3682: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
3683: routineNameIn => 'removeActionTypeUsage',
3684: exceptionNumberIn => sqlcode,
3685: exceptionStringIn => '(action type ID ' ||
3686: actionTypeIdIn||

Line 3714: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',

3710: end loop;
3711: exception
3712: when others then
3713: rollback;
3714: ame_util.runtimeException(packageNameIn => 'ame_action_pkg',
3715: routineNameIn => 'removeActionTypeUsages',
3716: exceptionNumberIn => sqlcode,
3717: exceptionStringIn => '(action type ID ' ||
3718: actionTypeIdIn||

Line 3723: end AME_action_pkg;

3719: ') ' ||
3720: sqlerrm);
3721: raise;
3722: end removeActionTypeUsages;
3723: end AME_action_pkg;