eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AME_APPROVAL_GROUP_PKG dependencies on AME_APPROVAL_GROUP_PKG

Line 1: package body ame_approval_group_pkg as

1: package body ame_approval_group_pkg as
2: /* $Header: ameogrou.pkb 120.2 2011/09/21 14:54:08 prasashe ship $ */
3: /* forward declarations */
4: /*
5: getNestedMembers returns the membership of an approval group, including nested

Line 45: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',

41: return(false);
42: exception
43: when others then
44: rollback;
45: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
46: routineNameIn => 'isSeeded',
47: exceptionNumberIn => sqlcode,
48: exceptionStringIn => '(Approval Group ' ||
49: approvalGroupIdIn ||

Line 70: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',

66: return(orderNumber);
67: exception
68: when others then
69: rollback;
70: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
71: routineNameIn => 'getApprovalGroupItemMaxOrdNum',
72: exceptionNumberIn => sqlcode,
73: exceptionStringIn => sqlerrm);
74: raise;

Line 91: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',

87: return(orderNumber);
88: exception
89: when others then
90: rollback;
91: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
92: routineNameIn => 'getApprovalGroupMaxOrderNumber',
93: exceptionNumberIn => sqlcode,
94: exceptionStringIn => sqlerrm);
95: raise;

Line 114: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',

110: return(orderNumber);
111: exception
112: when others then
113: rollback;
114: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
115: routineNameIn => 'getApprovalGroupOrderNumber',
116: exceptionNumberIn => sqlcode,
117: exceptionStringIn => ame_util.getMessage(applicationShortNameIn => 'PER',
118: messageNameIn => 'AME_400356_APPR_GROUP_ID_ERR',

Line 139: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',

135: return(description);
136: exception
137: when others then
138: rollback;
139: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
140: routineNameIn => 'getDescription',
141: exceptionNumberIn => sqlcode,
142: exceptionStringIn => ame_util.getMessage(applicationShortNameIn => 'PER',
143: messageNameIn => 'AME_400354_APPR_GRP_NAME_ERR',

Line 164: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',

160: return(approvalGroupId);
161: exception
162: when others then
163: rollback;
164: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
165: routineNameIn => 'getId',
166: exceptionNumberIn => sqlcode,
167: exceptionStringIn => ame_util.getMessage(applicationShortNameIn => 'PER',
168: messageNameIn => 'AME_400354_APPR_GRP_NAME_ERR',

Line 189: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',

185: return(approvalGroupId);
186: exception
187: when others then
188: rollback;
189: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
190: routineNameIn => 'getItemApprovalGroupId',
191: exceptionNumberIn => sqlcode,
192: exceptionStringIn => ame_util.getMessage(applicationShortNameIn => 'PER',
193: messageNameIn => 'AME_400355_APPR_GRPITEMID_ERR',

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

213: return(itemId);
214: exception
215: when others then
216: rollback;
217: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
218: routineNameIn => 'getItemId',
219: exceptionNumberIn => sqlcode,
220: exceptionStringIn => ame_util.getMessage(applicationShortNameIn => 'PER',
221: messageNameIn => 'AME_400354_APPR_GRP_NAME_ERR',

Line 242: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',

238: return(parameter);
239: exception
240: when others then
241: rollback;
242: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
243: routineNameIn => 'getItemParameter',
244: exceptionNumberIn => sqlcode,
245: exceptionStringIn => ame_util.getMessage(applicationShortNameIn => 'PER',
246: messageNameIn => 'AME_400355_APPR_GRPITEMID_ERR',

Line 267: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',

263: return(parameterName);
264: exception
265: when others then
266: rollback;
267: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
268: routineNameIn => 'getItemParameterName',
269: exceptionNumberIn => sqlcode,
270: exceptionStringIn => ame_util.getMessage(applicationShortNameIn => 'PER',
271: messageNameIn => 'AME_400355_APPR_GRPITEMID_ERR',

Line 296: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',

292: return(name);
293: exception
294: when others then
295: rollback;
296: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
297: routineNameIn => 'getName',
298: exceptionNumberIn => sqlcode,
299: exceptionStringIn => ame_util.getMessage(applicationShortNameIn => 'PER',
300: messageNameIn => 'AME_400356_APPR_GROUP_ID_ERR',

Line 331: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',

327: messageNameIn => 'AME_400194_APG_NO_USAGE',
328: tokenNameOneIn => 'APPROVAL_GROUP',
329: tokenValueOneIn => getName(approvalGroupIdIn => approvalGroupIdIn,
330: effectiveDateIn => effectiveDateIn));
331: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
332: routineNameIn => 'getQueryString',
333: exceptionNumberIn => errorCode,
334: exceptionStringIn => errorMessage);
335: raise_application_error(errorCode,

Line 340: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',

336: errorMessage);
337: return(null);
338: when others then
339: rollback;
340: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
341: routineNameIn => 'getQueryString',
342: exceptionNumberIn => sqlcode,
343: exceptionStringIn => ame_util.getMessage(applicationShortNameIn => 'PER',
344: messageNameIn => 'AME_400354_APPR_GRP_NAME_ERR',

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

361: return(isStatic);
362: exception
363: when others then
364: rollback;
365: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
366: routineNameIn => 'getIsStatic',
367: exceptionNumberIn => sqlcode,
368: exceptionStringIn => ame_util.getMessage(applicationShortNameIn => 'PER',
369: messageNameIn => 'AME_400354_APPR_GRP_NAME_ERR',

Line 394: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',

390: return(stringStartDate);
391: exception
392: when others then
393: rollback;
394: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
395: routineNameIn => 'getChildVersionStartDate',
396: exceptionNumberIn => sqlcode,
397: exceptionStringIn => ame_util.getMessage(applicationShortNameIn => 'PER',
398: messageNameIn => 'AME_400354_APPR_GRP_NAME_ERR',

Line 421: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',

417: return(stringStartDate);
418: exception
419: when others then
420: rollback;
421: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
422: routineNameIn => 'getParentVersionStartDate',
423: exceptionNumberIn => sqlcode,
424: exceptionStringIn => ame_util.getMessage(applicationShortNameIn => 'PER',
425: messageNameIn => 'AME_400354_APPR_GRP_NAME_ERR',

Line 446: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',

442: return(orderNumber);
443: exception
444: when others then
445: rollback;
446: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
447: routineNameIn => 'getItemOrderNumber',
448: exceptionNumberIn => sqlcode,
449: exceptionStringIn => ame_util.getMessage(applicationShortNameIn => 'PER',
450: messageNameIn => 'AME_400355_APPR_GRPITEMID_ERR',

Line 478: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',

474: return(orderCount);
475: exception
476: when others then
477: rollback;
478: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
479: routineNameIn => 'getOrderNumberCount',
480: exceptionNumberIn => sqlcode,
481: exceptionStringIn => ame_util.getMessage(applicationShortNameIn => 'PER',
482: messageNameIn => 'AME_400354_APPR_GRP_NAME_ERR',

Line 505: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',

501: return(votingRegime);
502: exception
503: when others then
504: rollback;
505: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
506: routineNameIn => 'getVotingRegime',
507: exceptionNumberIn => sqlcode,
508: exceptionStringIn => sqlerrm);
509: raise;

Line 540: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',

536: return(false);
537: exception
538: when others then
539: rollback;
540: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
541: routineNameIn => 'groupIsInGroup',
542: exceptionNumberIn => sqlcode,
543: exceptionStringIn => ame_util.getMessage(applicationShortNameIn => 'PER',
544: messageNameIn => 'AME_400354_APPR_GRP_NAME_ERR',

Line 577: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',

573: end if;
574: exception
575: when others then
576: rollback;
577: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
578: routineNameIn => 'hasGroupChanged2',
579: exceptionNumberIn => sqlcode,
580: exceptionStringIn => sqlerrm);
581: raise;

Line 635: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',

631: end if;
632: exception
633: when others then
634: rollback;
635: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
636: routineNameIn => 'hasGroupChanged',
637: exceptionNumberIn => sqlcode,
638: exceptionStringIn => sqlerrm);
639: raise;

Line 674: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',

670: return(false);
671: exception
672: when others then
673: rollback;
674: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
675: routineNameIn => 'isInUse',
676: exceptionNumberIn => sqlcode,
677: exceptionStringIn => ame_util.getMessage(applicationShortNameIn => 'PER',
678: messageNameIn => 'AME_400354_APPR_GRP_NAME_ERR',

Line 702: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',

698: return(false);
699: exception
700: when others then
701: rollback;
702: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
703: routineNameIn => 'isStatic',
704: exceptionNumberIn => sqlcode,
705: exceptionStringIn => ame_util.getMessage(applicationShortNameIn => 'PER',
706: messageNameIn => 'AME_400354_APPR_GRP_NAME_ERR',

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

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

Line 918: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',

914: messageNameIn => 'AME_400196_APG_NAME_LONG',
915: tokenNameOneIn => 'COLUMN_LENGTH',
916: tokenValueOneIn => ame_util.getColumnLength(tableNameIn => 'ame_approval_groups',
917: columnNameIn => 'name'));
918: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
919: routineNameIn => 'new',
920: exceptionNumberIn => errorCode,
921: exceptionStringIn => errorMessage);
922: raise_application_error(errorCode,

Line 933: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',

929: messageNameIn => 'AME_400197_APG_DESC_LONG',
930: tokenNameOneIn => 'COLUMN_LENGTH',
931: tokenValueOneIn => ame_util.getColumnLength(tableNameIn => 'ame_approval_groups',
932: columnNameIn => 'description'));
933: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
934: routineNameIn => 'new',
935: exceptionNumberIn => errorCode,
936: exceptionStringIn => errorMessage);
937: raise_application_error(errorCode,

Line 946: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',

942: errorCode := -20001;
943: errorMessage :=
944: ame_util.getMessage(applicationShortNameIn => 'PER',
945: messageNameIn => 'AME_400198_APG_NAME_DESC_ENT');
946: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
947: routineNameIn => 'new',
948: exceptionNumberIn => errorCode,
949: exceptionStringIn => errorMessage);
950: raise_application_error(errorCode,

Line 955: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',

951: errorMessage);
952: return(null);
953: when others then
954: rollback;
955: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
956: routineNameIn => 'new',
957: exceptionNumberIn => sqlcode,
958: exceptionStringIn => ame_util.getMessage(applicationShortNameIn => 'PER',
959: messageNameIn => 'AME_400354_APPR_GRP_NAME_ERR',

Line 1058: if(ame_approval_group_pkg.itemOrderNumberUnique(orderNumberIn => oldOrderNumberIn,

1054: else
1055: createdBy := currentUserId;
1056: end if;
1057: end if;
1058: if(ame_approval_group_pkg.itemOrderNumberUnique(orderNumberIn => oldOrderNumberIn,
1059: approvalGroupIdIn => approvalGroupIdIn)) then
1060: oldOrderNumberUnique := ame_util.yes;
1061: else
1062: oldOrderNumberUnique := ame_util.no;

Line 1200: ame_approval_group_pkg.getApprovalGroupItemMaxOrdNum(approvalGroupIdIn => approvalGroupIdIn);

1196: nvl(newStartDateIn, processingDate),
1197: null);
1198: end if;
1199: maxOrderNumber :=
1200: ame_approval_group_pkg.getApprovalGroupItemMaxOrdNum(approvalGroupIdIn => approvalGroupIdIn);
1201: if(oldOrderNumberIn is null) then
1202: if(orderNumberUniqueIn = ame_util.yes) then
1203: if(newOrderNumberIn <> (maxOrderNumber + 1)) then
1204: incrementGroupItemOrderNumbers(approvalGroupItemIdIn => approvalGroupItemId,

Line 1230: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',

1226: errorCode := -20001;
1227: errorMessage :=
1228: ame_util.getMessage(applicationShortNameIn => 'PER',
1229: messageNameIn => 'AME_400143_ACT_OBJECT_CHNGED');
1230: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
1231: routineNameIn => 'newApprovalGroupItem',
1232: exceptionNumberIn => errorCode,
1233: exceptionStringIn => errorMessage);
1234: raise_application_error(errorCode,

Line 1243: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',

1239: errorCode := -20001;
1240: errorMessage :=
1241: ame_util.getMessage(applicationShortNameIn => 'PER',
1242: messageNameIn => 'AME_400199_APG_NEST_CONTAINS');
1243: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
1244: routineNameIn => 'newApprovalGroupItem',
1245: exceptionNumberIn => errorCode,
1246: exceptionStringIn => errorMessage);
1247: raise_application_error(errorCode,

Line 1256: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',

1252: errorCode := -20001;
1253: errorMessage :=
1254: ame_util.getMessage(applicationShortNameIn => 'PER',
1255: messageNameIn => 'AME_400200_APG_MEMBER_EXISTS');
1256: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
1257: routineNameIn => 'newApprovalGroupItem',
1258: exceptionNumberIn => errorCode,
1259: exceptionStringIn => errorMessage);
1260: raise_application_error(errorCode,

Line 1272: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',

1268: errorCode := -20001;
1269: errorMessage :=
1270: ame_util.getMessage(applicationShortNameIn => 'PER',
1271: messageNameIn => 'AME_400145_ACT_OBJECT_DELETED');
1272: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
1273: routineNameIn => 'newApprovalGroupItem',
1274: exceptionNumberIn => errorCode,
1275: exceptionStringIn => errorMessage);
1276: raise_application_error(errorCode,

Line 1288: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',

1284: messageNameIn => 'AME_400201_APG_PAR_MEM_LONG',
1285: tokenNameOneIn => 'COLUMN_LENGTH',
1286: tokenValueOneIn => ame_util.getColumnLength(tableNameIn => 'ame_approval_group_items',
1287: columnNameIn => 'parameter'));
1288: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
1289: routineNameIn => 'newApprovalGroupItem',
1290: exceptionNumberIn => errorCode,
1291: exceptionStringIn => errorMessage);
1292: raise_application_error(errorCode,

Line 1301: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',

1297: errorCode := -20001;
1298: errorMessage :=
1299: ame_util.getMessage(applicationShortNameIn => 'PER',
1300: messageNameIn => 'AME_400202_APG_ORD_NAME_ARG');
1301: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
1302: routineNameIn => 'newApprovalGroupItem',
1303: exceptionNumberIn => errorCode,
1304: exceptionStringIn => errorMessage);
1305: raise_application_error(errorCode,

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

1313: messageNameIn => 'AME_400203_APG_PAR_GRP_LONG',
1314: tokenNameOneIn => 'COLUMN_LENGTH',
1315: tokenValueOneIn => ame_util.getColumnLength(tableNameIn => 'ame_approval_group_items',
1316: columnNameIn => 'parameter_name'));
1317: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
1318: routineNameIn => 'newApprovalGroupItem',
1319: exceptionNumberIn => errorCode,
1320: exceptionStringIn => errorMessage);
1321: raise_application_error(errorCode,

Line 1335: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',

1331: /*
1332: ame_util.getMessage(applicationShortNameIn => 'PER',
1333: messageNameIn => 'AME_400373_ACT DYNAMIC_DESC3');
1334: */
1335: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
1336: routineNameIn => 'newApprovalGroupItem',
1337: exceptionNumberIn => errorCode,
1338: exceptionStringIn => errorMessage);
1339: raise_application_error(errorCode,

Line 1346: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',

1342: rollback;
1343: if(startDateCursor%isOpen) then
1344: close startDateCursor;
1345: end if;
1346: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
1347: routineNameIn => 'newApprovalGroupItem',
1348: exceptionNumberIn => sqlcode,
1349: exceptionStringIn => ame_util.getMessage(applicationShortNameIn => 'PER',
1350: messageNameIn => 'AME_400354_APPR_GRP_NAME_ERR',

Line 1377: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',

1373: end if;
1374: exception
1375: when others then
1376: rollback;
1377: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
1378: routineNameIn => 'orderNumberUnique',
1379: exceptionNumberIn => sqlcode,
1380: exceptionStringIn => sqlerrm);
1381: raise;

Line 1428: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',

1424: end if;
1425: exception
1426: when others then
1427: rollback;
1428: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
1429: routineNameIn => 'change',
1430: exceptionNumberIn => sqlcode,
1431: exceptionStringIn => ame_util.getMessage(applicationShortNameIn => 'PER',
1432: messageNameIn => 'AME_400354_APPR_GRP_NAME_ERR',

Line 1522: queryStringIn => queryStringIn) OR (not ame_approval_group_pkg.isSeeded(approvalGroupIdIn => approvalGroupIdIn))) then

1518: if(hasGroupChanged2(approvalGroupIdIn => approvalGroupIdIn,
1519: nameIn => name,
1520: descriptionIn => description,
1521: isStaticIn => isStaticIn,
1522: queryStringIn => queryStringIn) OR (not ame_approval_group_pkg.isSeeded(approvalGroupIdIn => approvalGroupIdIn))) then
1523:
1524:
1525: ame_approval_group_pkg.change(approvalGroupIdIn => approvalGroupIdIn,
1526: nameIn => name,

Line 1525: ame_approval_group_pkg.change(approvalGroupIdIn => approvalGroupIdIn,

1521: isStaticIn => isStaticIn,
1522: queryStringIn => queryStringIn) OR (not ame_approval_group_pkg.isSeeded(approvalGroupIdIn => approvalGroupIdIn))) then
1523:
1524:
1525: ame_approval_group_pkg.change(approvalGroupIdIn => approvalGroupIdIn,
1526: nameIn => name,
1527: descriptionIn => description,
1528: isStaticIn => isStaticIn,
1529: queryStringIn => queryStringIn,

Line 1535: ame_approval_group_pkg.changeGroupConfig(approvalGroupIdIn => approvalGroupIdIn,

1531: updateActionIn => updateAction,
1532: finalizeIn => false);
1533: end if;
1534:
1535: ame_approval_group_pkg.changeGroupConfig(approvalGroupIdIn => approvalGroupIdIn,
1536: orderNumberUniqueIn => orderNumberUniqueIn,
1537: orderNumberIn => orderNumberIn,
1538: votingRegimeIn => votingRegimeIn,
1539: applicationIdIn => applicationIdIn,

Line 1560: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',

1556: errorCode := -20001;
1557: errorMessage :=
1558: ame_util.getMessage(applicationShortNameIn => 'PER',
1559: messageNameIn => 'AME_400143_ACT_OBJECT_CHNGED');
1560: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
1561: routineNameIn => 'changeGroupAndConfig',
1562: exceptionNumberIn => errorCode,
1563: exceptionStringIn => errorMessage);
1564: raise_application_error(errorCode,

Line 1578: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',

1574: errorCode := -20001;
1575: errorMessage :=
1576: ame_util.getMessage(applicationShortNameIn => 'PER',
1577: messageNameIn => 'AME_400145_ACT_OBJECT_DELETED');
1578: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
1579: routineNameIn => 'changeGroupAndConfig',
1580: exceptionNumberIn => errorCode,
1581: exceptionStringIn => errorMessage);
1582: raise_application_error(errorCode,

Line 1592: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',

1588: end if;
1589: if(startDateCursor2%isOpen) then
1590: close startDateCursor2;
1591: end if;
1592: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
1593: routineNameIn => 'changeGroupAndConfig',
1594: exceptionNumberIn => sqlcode,
1595: exceptionStringIn => '(approval group ID ' ||
1596: approvalGroupIdIn||

Line 1621: if(ame_approval_group_pkg.orderNumberUnique(applicationIdIn => applicationIdIn,

1617: updateOnlyAGModified boolean;
1618: begin
1619: oldOrderNumber := getApprovalGroupOrderNumber(applicationIdIn => applicationIdIn,
1620: approvalGroupIdIn => approvalGroupIdIn);
1621: if(ame_approval_group_pkg.orderNumberUnique(applicationIdIn => applicationIdIn,
1622: orderNumberIn => oldOrderNumber)) then
1623: oldOrderNumberUnique := ame_util.yes;
1624: else
1625: oldOrderNumberUnique := ame_util.no;

Line 1745: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',

1741: /*
1742: ame_util.getMessage(applicationShortNameIn => 'PER',
1743: messageNameIn => 'AME_400373_ACT DYNAMIC_DESC3');
1744: */
1745: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
1746: routineNameIn => 'changeGroupConfig',
1747: exceptionNumberIn => errorCode,
1748: exceptionStringIn => errorMessage);
1749: raise_application_error(errorCode,

Line 1753: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',

1749: raise_application_error(errorCode,
1750: errorMessage);
1751: when others then
1752: rollback;
1753: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
1754: routineNameIn => 'changeGroupConfig',
1755: exceptionNumberIn => sqlcode,
1756: exceptionStringIn => ame_util.getMessage(applicationShortNameIn => 'PER',
1757: messageNameIn => 'AME_400354_APPR_GRP_NAME_ERR',

Line 1866: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',

1862: errorCode := -20001;
1863: errorMessage :=
1864: ame_util.getMessage(applicationShortNameIn => 'PER',
1865: messageNameIn => 'AME_400145_ACT_OBJECT_DELETED');
1866: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
1867: routineNameIn => 'changeApprovalGroupItem',
1868: exceptionNumberIn => errorCode,
1869: exceptionStringIn => errorMessage);
1870: raise_application_error(errorCode,

Line 1877: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',

1873: rollback;
1874: if(startDateCursor%isOpen) then
1875: close startDateCursor;
1876: end if;
1877: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
1878: routineNameIn => 'changeApprovalGroupItem',
1879: exceptionNumberIn => sqlcode,
1880: exceptionStringIn => ame_util.getMessage(applicationShortNameIn => 'PER',
1881: messageNameIn => 'AME_400354_APPR_GRP_NAME_ERR',

Line 1959: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',

1955: end if;
1956: exception
1957: when others then
1958: rollback;
1959: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
1960: routineNameIn => 'decrementGroupItemOrderNumbers',
1961: exceptionNumberIn => sqlcode,
1962: exceptionStringIn => sqlerrm);
1963: raise;

Line 2032: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',

2028: end if;
2029: exception
2030: when others then
2031: rollback;
2032: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
2033: routineNameIn => 'decrementGroupOrderNumbers',
2034: exceptionNumberIn => sqlcode,
2035: exceptionStringIn => sqlerrm);
2036: raise;

Line 2072: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',

2068: end loop;
2069: exception
2070: when others then
2071: rollback;
2072: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
2073: routineNameIn => 'getAllowedNestedGroups',
2074: exceptionNumberIn => sqlcode,
2075: exceptionStringIn => ame_util.getMessage(applicationShortNameIn => 'PER',
2076: messageNameIn => 'AME_400354_APPR_GRP_NAME_ERR',

Line 2114: tempParameterName := ame_approval_group_pkg.getItemParameterName(approvalGroupItemIdIn => tempItemId);

2110: tempIndex := 1;
2111: invalidMembersOut := false;
2112: for tempItem in itemCursor(approvalGroupIdIn) loop
2113: tempItemId := tempItem.approval_group_item_id;
2114: tempParameterName := ame_approval_group_pkg.getItemParameterName(approvalGroupItemIdIn => tempItemId);
2115: tempParameter := ame_approval_group_pkg.getItemParameter(approvalGroupItemIdIn => tempItemId);
2116: itemListOut(tempIndex) := tempItemId;
2117: orderListOut(tempIndex) := getItemOrderNumber(approvalGroupItemIdIn => tempItemId);
2118: if tempParameterName = ame_util.approverOamGroupId then

Line 2115: tempParameter := ame_approval_group_pkg.getItemParameter(approvalGroupItemIdIn => tempItemId);

2111: invalidMembersOut := false;
2112: for tempItem in itemCursor(approvalGroupIdIn) loop
2113: tempItemId := tempItem.approval_group_item_id;
2114: tempParameterName := ame_approval_group_pkg.getItemParameterName(approvalGroupItemIdIn => tempItemId);
2115: tempParameter := ame_approval_group_pkg.getItemParameter(approvalGroupItemIdIn => tempItemId);
2116: itemListOut(tempIndex) := tempItemId;
2117: orderListOut(tempIndex) := getItemOrderNumber(approvalGroupItemIdIn => tempItemId);
2118: if tempParameterName = ame_util.approverOamGroupId then
2119: descriptionListOut(tempIndex) :=

Line 2138: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',

2134: end loop;
2135: exception
2136: when others then
2137: rollback;
2138: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
2139: routineNameIn => 'getApprovalGroupItemList',
2140: exceptionNumberIn => sqlcode,
2141: exceptionStringIn => ame_util.getMessage(applicationShortNameIn => 'PER',
2142: messageNameIn => 'AME_400354_APPR_GRP_NAME_ERR',

Line 2168: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',

2164: end loop;
2165: exception
2166: when others then
2167: rollback;
2168: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
2169: routineNameIn => 'getApprovalGroupList',
2170: exceptionNumberIn => sqlcode,
2171: exceptionStringIn => sqlerrm);
2172: groupListOut := ame_util.emptyIdList;

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

2195: end loop;
2196: exception
2197: when others then
2198: rollback;
2199: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
2200: routineNameIn => 'getApprovalGroupList2',
2201: exceptionNumberIn => sqlcode,
2202: exceptionStringIn => sqlerrm);
2203: groupListOut := ame_util.emptyIdList;

Line 2265: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',

2261: end if;
2262: exception
2263: when others then
2264: rollback;
2265: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
2266: routineNameIn => 'getGroupMembers',
2267: exceptionNumberIn => sqlcode,
2268: exceptionStringIn => ame_util.getMessage(applicationShortNameIn => 'PER',
2269: messageNameIn => 'AME_400354_APPR_GRP_NAME_ERR',

Line 2304: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',

2300: end loop;
2301: exception
2302: when others then
2303: rollback;
2304: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
2305: routineNameIn => 'getInvalidApprGroupItemList',
2306: exceptionNumberIn => sqlcode,
2307: exceptionStringIn => ame_util.getMessage(applicationShortNameIn => 'PER',
2308: messageNameIn => 'AME_400354_APPR_GRP_NAME_ERR',

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

2389: end loop;
2390: exception
2391: when others then
2392: rollback;
2393: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
2394: routineNameIn => 'getNestedMembers',
2395: exceptionNumberIn => sqlcode,
2396: exceptionStringIn => ame_util.getMessage(applicationShortNameIn => 'PER',
2397: messageNameIn => 'AME_400354_APPR_GRP_NAME_ERR',

Line 2428: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',

2424: end loop;
2425: exception
2426: when others then
2427: rollback;
2428: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
2429: routineNameIn => 'getOrderNumbers',
2430: exceptionNumberIn => sqlcode,
2431: exceptionStringIn => ame_util.getMessage(applicationShortNameIn => 'PER',
2432: messageNameIn => 'AME_400354_APPR_GRP_NAME_ERR',

Line 2515: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',

2511: end if;
2512: exception
2513: when others then
2514: rollback;
2515: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
2516: routineNameIn => 'incrementGroupItemOrderNumbers',
2517: exceptionNumberIn => sqlcode,
2518: exceptionStringIn => sqlerrm);
2519: raise;

Line 2590: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',

2586: end if;
2587: exception
2588: when others then
2589: rollback;
2590: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
2591: routineNameIn => 'incrementGroupOrderNumbers',
2592: exceptionNumberIn => sqlcode,
2593: exceptionStringIn => sqlerrm);
2594: raise;

Line 2620: ame_approval_group_pkg.getApprovalGroupMaxOrderNumber(applicationIdIn => applicationIdIn);

2616: begin
2617: currentUserId := ame_util.getCurrentUserId;
2618: processingDate := sysdate;
2619: maxOrderNumber :=
2620: ame_approval_group_pkg.getApprovalGroupMaxOrderNumber(applicationIdIn => applicationIdIn);
2621: open applicationIdCursor;
2622: fetch applicationIdCursor bulk collect
2623: into
2624: applicationIds;

Line 2687: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',

2683: end if;
2684: exception
2685: when others then
2686: rollback;
2687: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
2688: routineNameIn => 'newApprovalGroupConfig',
2689: exceptionNumberIn => sqlcode,
2690: exceptionStringIn => sqlerrm);
2691: end newApprovalGroupConfig;

Line 2817: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',

2813: errorCode := -20001;
2814: errorMessage :=
2815: ame_util.getMessage(applicationShortNameIn => 'PER',
2816: messageNameIn => 'AME_400143_ACT_OBJECT_CHNGED');
2817: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
2818: routineNameIn => 'remove',
2819: exceptionNumberIn => errorCode,
2820: exceptionStringIn => errorMessage);
2821: raise_application_error(errorCode,

Line 2832: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',

2828: errorCode := -20001;
2829: errorMessage :=
2830: ame_util.getMessage(applicationShortNameIn => 'PER',
2831: messageNameIn => 'AME_400145_ACT_OBJECT_DELETED');
2832: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
2833: routineNameIn => 'remove',
2834: exceptionNumberIn => errorCode,
2835: exceptionStringIn => errorMessage);
2836: raise_application_error(errorCode,

Line 2844: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',

2840: errorCode := -20001;
2841: errorMessage :=
2842: ame_util.getMessage(applicationShortNameIn => 'PER',
2843: messageNameIn => 'AME_400205_APG_IN_USE');
2844: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
2845: routineNameIn => 'remove',
2846: exceptionNumberIn => errorCode,
2847: exceptionStringIn => errorMessage);
2848: raise_application_error(errorCode,

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

2851: rollback;
2852: if(startDateCursor%isOpen) then
2853: close startDateCursor;
2854: end if;
2855: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
2856: routineNameIn => 'remove',
2857: exceptionNumberIn => sqlcode,
2858: exceptionStringIn => ame_util.getMessage(applicationShortNameIn => 'PER',
2859: messageNameIn => 'AME_400354_APPR_GRP_NAME_ERR',

Line 2973: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',

2969: errorCode := -20001;
2970: errorMessage :=
2971: ame_util.getMessage(applicationShortNameIn => 'PER',
2972: messageNameIn => 'AME_400143_ACT_OBJECT_CHNGED');
2973: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
2974: routineNameIn => 'removeApprovalGroupItem',
2975: exceptionNumberIn => errorCode,
2976: exceptionStringIn => errorMessage);
2977: raise_application_error(errorCode,

Line 2988: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',

2984: errorCode := -20001;
2985: errorMessage :=
2986: ame_util.getMessage(applicationShortNameIn => 'PER',
2987: messageNameIn => 'AME_400145_ACT_OBJECT_DELETED');
2988: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
2989: routineNameIn => 'removeApprovalGroupItem',
2990: exceptionNumberIn => errorCode,
2991: exceptionStringIn => errorMessage);
2992: raise_application_error(errorCode,

Line 2999: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',

2995: rollback;
2996: if(startDateCursor%isOpen) then
2997: close startDateCursor;
2998: end if;
2999: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
3000: routineNameIn => 'removeApprovalGroupItem',
3001: exceptionNumberIn => sqlcode,
3002: exceptionStringIn => ame_util.getMessage(applicationShortNameIn => 'PER',
3003: messageNameIn => 'AME_400354_APPR_GRP_NAME_ERR',

Line 3057: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',

3053: origSystem := null;
3054: origSystemId := null;
3055: else
3056: rollback;
3057: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
3058: routineNameIn => 'setGroupMembers2',
3059: exceptionNumberIn => sqlcode,
3060: exceptionStringIn => ame_util.getMessage(applicationShortNameIn => 'PER',
3061: messageNameIn => 'AME_400354_APPR_GRP_NAME_ERR',

Line 3096: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',

3092: end loop;
3093: exception
3094: when others then
3095: rollback;
3096: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
3097: routineNameIn => 'setGroupMembers2',
3098: exceptionNumberIn => sqlcode,
3099: exceptionStringIn => ame_util.getMessage(applicationShortNameIn => 'PER',
3100: messageNameIn => 'AME_400354_APPR_GRP_NAME_ERR',

Line 3175: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',

3171: end loop;
3172: exception
3173: when others then
3174: rollback;
3175: ame_util.runtimeException(packageNameIn => 'ame_approval_group_pkg',
3176: routineNameIn => 'updateDependentGroups',
3177: exceptionNumberIn => sqlcode,
3178: exceptionStringIn => ame_util.getMessage(applicationShortNameIn => 'PER',
3179: messageNameIn => 'AME_400354_APPR_GRP_NAME_ERR',

Line 3185: end ame_approval_group_pkg;

3181: tokenValueOneIn => getName(approvalGroupIdIn => groupIdIn))
3182: || ' ' || sqlerrm);
3183: raise;
3184: end updateDependentGroups;
3185: end ame_approval_group_pkg;