DBA Data[Home] [Help]

APPS.AME_API3 dependencies on AME_API3

Line 1: package body ame_api3 as

1: package body ame_api3 as
2: /* $Header: ameeapi3.pkb 120.20 2011/05/17 11:38:14 nchinnam ship $ */
3: ambiguousApproverException exception;
4: ambiguousApproverMessage constant ame_util.longestStringType :=
5: ame_util.getMessage(applicationShortNameIn =>'PER',

Line 2: /* $Header: ameeapi3.pkb 120.20 2011/05/17 11:38:14 nchinnam ship $ */

1: package body ame_api3 as
2: /* $Header: ameeapi3.pkb 120.20 2011/05/17 11:38:14 nchinnam ship $ */
3: ambiguousApproverException exception;
4: ambiguousApproverMessage constant ame_util.longestStringType :=
5: ame_util.getMessage(applicationShortNameIn =>'PER',
6: messageNameIn => 'AME_400812_NULL_APPR_REC_NAME');

Line 13: ame_util.runtimeException(packageNameIn => 'ame_api3',

9: begin
10: return(ame_rule_pkg.getDescription(ruleIdIn => ruleIdIn));
11: exception
12: when others then
13: ame_util.runtimeException(packageNameIn => 'ame_api3',
14: routineNameIn => 'getRuleDescription',
15: exceptionNumberIn => sqlcode,
16: exceptionStringIn => sqlerrm);
17: raise;

Line 149: ame_util.runtimeException(packageNameIn => 'ame_api3',

145: tokenNameOneIn => 'APPROVER',
146: tokenValueOneIn => ame_approver_type_pkg.getApproverDescription(anchorName),
147: tokenNameTwoIn => 'ANCHORED_APPROVERS',
148: tokenValueTwoIn => anchorList);
149: ame_util.runtimeException(packageNameIn => 'ame_api3',
150: routineNameIn => 'clearInsertion',
151: exceptionNumberIn => errorCode,
152: exceptionStringIn => errorMessage);
153: raise_application_error(errorCode,

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

160: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
161: messageNameIn => 'AME_400813_NULL_CLINS_APPR_FLD',
162: tokenNameOneIn => 'APPROVER_REC_PARAMS',
163: tokenValueOneIn => appr_rec_params);
164: ame_util.runtimeException(packageNameIn => 'ame_api3',
165: routineNameIn => 'clearInsertion',
166: exceptionNumberIn => errorCode,
167: exceptionStringIn => errorMessage);
168: raise_application_error(errorCode,

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

170: when others then
171: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,
172: transactionIdIn => transactionIdIn,
173: transactionTypeIdIn => transactionTypeIn);
174: ame_util.runtimeException(packageNameIn => 'ame_api3',
175: routineNameIn => 'clearInsertion',
176: exceptionNumberIn => sqlcode,
177: exceptionStringIn => sqlerrm);
178: raise;

Line 227: ame_util.runtimeException(packageNameIn => 'ame_api3',

223: when others then
224: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,
225: transactionIdIn => transactionIdIn,
226: transactionTypeIdIn => transactionTypeIn);
227: ame_util.runtimeException(packageNameIn => 'ame_api3',
228: routineNameIn => 'clearInsertions',
229: exceptionNumberIn => sqlcode,
230: exceptionStringIn => sqlerrm);
231: raise;

Line 318: ame_util.runtimeException(packageNameIn => 'ame_api3',

314: messageNameIn => 'AME_400814_NULL_SUPPR_APPR_FLD',
315: tokenNameOneIn => 'APPROVER_REC_PARAMS',
316: tokenvalueOneIn=>appr_rec_params);
317: errorCode := -20320;
318: ame_util.runtimeException(packageNameIn => 'ame_api3',
319: routineNameIn => 'clearSuppression',
320: exceptionNumberIn => errorCode,
321: exceptionStringIn => errorMessage);
322: raise_application_error(errorCode,

Line 328: ame_util.runtimeException(packageNameIn => 'ame_api3',

324: when others then
325: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,
326: transactionIdIn => transactionIdIn,
327: transactionTypeIdIn => transactionTypeIn);
328: ame_util.runtimeException(packageNameIn => 'ame_api3',
329: routineNameIn => 'clearSuppression',
330: exceptionNumberIn => sqlcode,
331: exceptionStringIn => sqlerrm);
332: raise;

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

377: when others then
378: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,
379: transactionIdIn => transactionIdIn,
380: transactionTypeIdIn => transactionTypeIn);
381: ame_util.runtimeException(packageNameIn => 'ame_api3',
382: routineNameIn => 'clearSuppressions',
383: exceptionNumberIn => sqlcode,
384: exceptionStringIn => sqlerrm);
385: raise;

Line 403: ame_util.runtimeException(packageNameIn => 'ame_api3',

399: groupNamesOut;
400: close fetchGroupsCursor;
401: exception
402: when others then
403: ame_util.runtimeException(packageNameIn => 'ame_api3',
404: routineNameIn => 'getAllApprovalGroups',
405: exceptionNumberIn => sqlcode,
406: exceptionStringIn => sqlerrm);
407: raise;

Line 454: ame_util.runtimeException(packageNameIn => 'ame_api3',

450: (ruleIdsOut => ruleIdsOut
451: ,ruleDescriptionsOut => ruleDescriptions);
452: exception
453: when others then
454: ame_util.runtimeException(packageNameIn => 'ame_api3',
455: routineNameIn => 'getApplicableRules1',
456: exceptionNumberIn => sqlcode,
457: exceptionStringIn => sqlerrm);
458: raise;

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

501: (ruleIdsOut => ruleIds
502: ,ruleDescriptionsOut => ruleDescriptionsOut);
503: exception
504: when others then
505: ame_util.runtimeException(packageNameIn => 'ame_api3',
506: routineNameIn => 'getApplicableRules2',
507: exceptionNumberIn => sqlcode,
508: exceptionStringIn => sqlerrm);
509: raise;

Line 556: ame_util.runtimeException(packageNameIn => 'ame_api3',

552: (ruleIdsOut => ruleIdsOut
553: ,ruleDescriptionsOut => ruleDescriptionsOut);
554: exception
555: when others then
556: ame_util.runtimeException(packageNameIn => 'ame_api3',
557: routineNameIn => 'getApplicableRules3',
558: exceptionNumberIn => sqlcode,
559: exceptionStringIn => sqlerrm);
560: raise;

Line 580: ame_util.runtimeException(packageNameIn => 'ame_api3',

576: applicationShortNameIn => 'PER',
577: messageNameIn => 'AME_400453_GROUP_NOT_DEFINED',
578: tokenNameOneIn => 'APPROVAL_GROUP',
579: tokenValueOneIn => groupNameIn);
580: ame_util.runtimeException(packageNameIn => 'ame_api3',
581: routineNameIn => 'getApprovalGroupId',
582: exceptionNumberIn => errorCode,
583: exceptionStringIn => errorMessage);
584: raise_application_error(errorCode,

Line 587: ame_util.runtimeException(packageNameIn => 'ame_api3',

583: exceptionStringIn => errorMessage);
584: raise_application_error(errorCode,
585: errorMessage);
586: when others then
587: ame_util.runtimeException(packageNameIn => 'ame_api3',
588: routineNameIn => 'getApprovalGroupId',
589: exceptionNumberIn => sqlcode,
590: exceptionStringIn => sqlerrm);
591: raise;

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

633: attributeValue2Out => attributeValue2Out,
634: attributeValue3Out => attributeValue3Out);
635: exception
636: when others then
637: ame_util.runtimeException(packageNameIn => 'ame_api3',
638: routineNameIn => 'getAttributeValue',
639: exceptionNumberIn => sqlcode,
640: exceptionStringIn => sqlerrm);
641: raise;

Line 687: (packageNameIn => 'ame_api3'

683: );
684: exception
685: when others then
686: ame_util.runtimeException
687: (packageNameIn => 'ame_api3'
688: ,routineNameIn => 'getAvailableInsertions'
689: ,exceptionNumberIn => sqlcode
690: ,exceptionStringIn => sqlerrm
691: );

Line 741: ame_util.runtimeException(packageNameIn => 'ame_api3',

737: stringValueListOut => allowedValuesOut);
738: end if;
739: exception
740: when others then
741: ame_util.runtimeException(packageNameIn => 'ame_api3',
742: routineNameIn => 'getConditionDetails',
743: exceptionNumberIn => sqlcode,
744: exceptionStringIn => sqlerrm);
745: raise;

Line 880: tokenValueOneIn => 'ame_api3.getGroupMembers1',

876: errorCode := -20223;
877: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
878: messageNameIn => 'AME_400838_INV_APR_FOUND',
879: tokenNameOneIn => 'PROCESS_NAME',
880: tokenValueOneIn => 'ame_api3.getGroupMembers1',
881: tokenNameTwoIn => 'ORIG_SYSTEM',
882: tokenValueTwoIn => memberOrigSystem,
883: tokenNameThreeIn => 'ORIG_SYSEM_ID',
884: tokenValueThreeIn => memberOrigSystemId);

Line 902: tokenValueOneIn => 'ame_api3.getGroupMembers1',

898: errorCode := -20223;
899: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
900: messageNameIn => 'AME_400838_INV_APR_FOUND',
901: tokenNameOneIn => 'PROCESS_NAME',
902: tokenValueOneIn => 'ame_api3.getGroupMembers1',
903: tokenNameTwoIn => 'ORIG_SYSTEM',
904: tokenValueTwoIn => l_orig_systemList(i),
905: tokenNameThreeIn => 'ORIG_SYSEM_ID',
906: tokenValueThreeIn => l_orig_system_id(i));

Line 923: ame_util.runtimeException(packageNameIn => 'ame_api3',

919: memberDisplayNamesOut.delete;
920: errorCode := -20315;
921: errorMessage := ame_util.getMessage(applicationShortNameIn => 'PER',
922: messageNameIn => 'AME_400454_GRP_DYN_QRY_ERR');
923: ame_util.runtimeException(packageNameIn => 'ame_api3',
924: routineNameIn => 'getGroupMembers1',
925: exceptionNumberIn => errorCode,
926: exceptionStringIn => errorMessage);
927: raise_application_error(errorCode,

Line 942: ame_util.runtimeException(packageNameIn => 'ame_api3',

938: applicationShortNameIn => 'PER',
939: messageNameIn => 'AME_400798_GROUP_ITEM_BIND',
940: tokenNameOneIn => 'APPROVER_GROUP',
941: tokenValueOneIn => tempGroupName);
942: ame_util.runtimeException(packageNameIn => 'ame_api3',
943: routineNameIn => 'getGroupMembers1',
944: exceptionNumberIn => errorCode,
945: exceptionStringIn => errorMessage);
946: raise_application_error(errorCode,

Line 961: ame_util.runtimeException(packageNameIn => 'ame_api3',

957: applicationShortNameIn => 'PER',
958: messageNameIn => 'AME_400455_GRP_DYN_NULL_TXID',
959: tokenNameOneIn => 'APPROVAL_GROUP',
960: tokenValueOneIn => tempGroupName);
961: ame_util.runtimeException(packageNameIn => 'ame_api3',
962: routineNameIn => 'getGroupMembers1',
963: exceptionNumberIn => errorCode,
964: exceptionStringIn => errorMessage);
965: raise_application_error(errorCode,

Line 972: ame_util.runtimeException(packageNameIn => 'ame_api3',

968: if(groupMemberCursor%isopen) then
969: close groupMemberCursor;
970: end if;
971: memberDisplayNamesOut.delete;
972: ame_util.runtimeException(packageNameIn => 'ame_api3',
973: routineNameIn => 'getGroupMembers1',
974: exceptionNumberIn => sqlcode,
975: exceptionStringIn => sqlerrm);
976: raise;

Line 1117: tokenValueOneIn => 'ame_api3.getGroupMembers2',

1113: errorCode := -20223;
1114: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
1115: messageNameIn => 'AME_400838_INV_APR_FOUND',
1116: tokenNameOneIn => 'PROCESS_NAME',
1117: tokenValueOneIn => 'ame_api3.getGroupMembers2',
1118: tokenNameTwoIn => 'ORIG_SYSTEM',
1119: tokenValueTwoIn => memberOrigSystem,
1120: tokenNameThreeIn => 'ORIG_SYSEM_ID',
1121: tokenValueThreeIn => memberOrigSystemId);

Line 1143: tokenValueOneIn => 'ame_api3.getGroupMembers2',

1139: errorCode := -20223;
1140: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
1141: messageNameIn => 'AME_400838_INV_APR_FOUND',
1142: tokenNameOneIn => 'PROCESS_NAME',
1143: tokenValueOneIn => 'ame_api3.getGroupMembers2',
1144: tokenNameTwoIn => 'ORIG_SYSTEM',
1145: tokenValueTwoIn => orig_systemList(i),
1146: tokenNameThreeIn => 'ORIG_SYSEM_ID',
1147: tokenValueThreeIn => orig_system_idList(i));

Line 1162: ame_util.runtimeException(packageNameIn => 'ame_api3',

1158: end if;
1159: errorCode := -20315;
1160: errorMessage := ame_util.getMessage(applicationShortNameIn => 'PER',
1161: messageNameIn => 'AME_400454_GRP_DYN_QRY_ERR');
1162: ame_util.runtimeException(packageNameIn => 'ame_api3',
1163: routineNameIn => 'getGroupMembers2',
1164: exceptionNumberIn => errorCode,
1165: exceptionStringIn => errorMessage);
1166: raise_application_error(errorCode,

Line 1180: ame_util.runtimeException(packageNameIn => 'ame_api3',

1176: applicationShortNameIn => 'PER',
1177: messageNameIn => 'AME_400455_GRP_DYN_NULL_TXID',
1178: tokenNameOneIn => 'APPROVAL_GROUP',
1179: tokenValueOneIn => tempGroupName);
1180: ame_util.runtimeException(packageNameIn => 'ame_api3',
1181: routineNameIn => 'getGroupMembers2',
1182: exceptionNumberIn => errorCode,
1183: exceptionStringIn => errorMessage);
1184: raise_application_error(errorCode,

Line 1199: ame_util.runtimeException(packageNameIn => 'ame_api3',

1195: applicationShortNameIn => 'PER',
1196: messageNameIn => 'AME_400798_GROUP_ITEM_BIND',
1197: tokenNameOneIn => 'APPROVER_GROUP',
1198: tokenValueOneIn => tempGroupName);
1199: ame_util.runtimeException(packageNameIn => 'ame_api3',
1200: routineNameIn => 'getGroupMembers2',
1201: exceptionNumberIn => errorCode,
1202: exceptionStringIn => errorMessage);
1203: raise_application_error(errorCode,

Line 1209: ame_util.runtimeException(packageNameIn => 'ame_api3',

1205: when others then
1206: if(groupMemberCursor%isopen) then
1207: close groupMemberCursor;
1208: end if;
1209: ame_util.runtimeException(packageNameIn => 'ame_api3',
1210: routineNameIn => 'getGroupMembers2',
1211: exceptionNumberIn => sqlcode,
1212: exceptionStringIn => sqlerrm);
1213: raise;

Line 1357: tokenValueOneIn => 'ame_api3.getGroupMembers3',

1353: errorCode := -20223;
1354: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
1355: messageNameIn => 'AME_400838_INV_APR_FOUND',
1356: tokenNameOneIn => 'PROCESS_NAME',
1357: tokenValueOneIn => 'ame_api3.getGroupMembers3',
1358: tokenNameTwoIn => 'ORIG_SYSTEM',
1359: tokenValueTwoIn => memberOrigSystem,
1360: tokenNameThreeIn => 'ORIG_SYSEM_ID',
1361: tokenValueThreeIn => memberOrigSystemId);

Line 1384: tokenValueOneIn => 'ame_api3.getGroupMembers3',

1380: errorCode := -20223;
1381: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
1382: messageNameIn => 'AME_400838_INV_APR_FOUND',
1383: tokenNameOneIn => 'PROCESS_NAME',
1384: tokenValueOneIn => 'ame_api3.getGroupMembers3',
1385: tokenNameTwoIn => 'ORIG_SYSTEM',
1386: tokenValueTwoIn => orig_systemList(i),
1387: tokenNameThreeIn => 'ORIG_SYSEM_ID',
1388: tokenValueThreeIn => orig_systemIdList(i));

Line 1403: ame_util.runtimeException(packageNameIn => 'ame_api3',

1399: end if;
1400: errorCode := -20315;
1401: errorMessage := ame_util.getMessage(applicationShortNameIn => 'PER',
1402: messageNameIn => 'AME_400454_GRP_DYN_QRY_ERR');
1403: ame_util.runtimeException(packageNameIn => 'ame_api3',
1404: routineNameIn => 'getGroupMembers3',
1405: exceptionNumberIn => errorCode,
1406: exceptionStringIn => errorMessage);
1407: raise_application_error(errorCode,

Line 1421: ame_util.runtimeException(packageNameIn => 'ame_api3',

1417: applicationShortNameIn => 'PER',
1418: messageNameIn => 'AME_400455_GRP_DYN_NULL_TXID',
1419: tokenNameOneIn => 'APPROVAL_GROUP',
1420: tokenValueOneIn => tempGroupName);
1421: ame_util.runtimeException(packageNameIn => 'ame_api3',
1422: routineNameIn => 'getGroupMembers3',
1423: exceptionNumberIn => errorCode,
1424: exceptionStringIn => errorMessage);
1425: raise_application_error(errorCode,

Line 1440: ame_util.runtimeException(packageNameIn => 'ame_api3',

1436: applicationShortNameIn => 'PER',
1437: messageNameIn => 'AME_400798_GROUP_ITEM_BIND',
1438: tokenNameOneIn => 'APPROVER_GROUP',
1439: tokenValueOneIn => tempGroupName);
1440: ame_util.runtimeException(packageNameIn => 'ame_api3',
1441: routineNameIn => 'getGroupMembers3',
1442: exceptionNumberIn => errorCode,
1443: exceptionStringIn => errorMessage);
1444: raise_application_error(errorCode,

Line 1450: ame_util.runtimeException(packageNameIn => 'ame_api3',

1446: when others then
1447: if(groupMemberCursor%isopen) then
1448: close groupMemberCursor;
1449: end if;
1450: ame_util.runtimeException(packageNameIn => 'ame_api3',
1451: routineNameIn => 'getGroupMembers3',
1452: exceptionNumberIn => sqlcode,
1453: exceptionStringIn => sqlerrm);
1454: raise;

Line 1596: tokenValueOneIn => 'ame_api3.getGroupMembers4',

1592: errorCode := -20223;
1593: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
1594: messageNameIn => 'AME_400838_INV_APR_FOUND',
1595: tokenNameOneIn => 'PROCESS_NAME',
1596: tokenValueOneIn => 'ame_api3.getGroupMembers4',
1597: tokenNameTwoIn => 'ORIG_SYSTEM',
1598: tokenValueTwoIn => memberOrigSystemsOut(outputIndex),
1599: tokenNameThreeIn => 'ORIG_SYSEM_ID',
1600: tokenValueThreeIn => memberOrigSystemIdsOut(outputIndex));

Line 1623: tokenValueOneIn => 'ame_api3.getGroupMembers4',

1619: errorCode := -20223;
1620: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
1621: messageNameIn => 'AME_400838_INV_APR_FOUND',
1622: tokenNameOneIn => 'PROCESS_NAME',
1623: tokenValueOneIn => 'ame_api3.getGroupMembers4',
1624: tokenNameTwoIn => 'ORIG_SYSTEM',
1625: tokenValueTwoIn => origSystems(i),
1626: tokenNameThreeIn => 'ORIG_SYSEM_ID',
1627: tokenValueThreeIn => origSystemIds(i));

Line 1644: ame_util.runtimeException(packageNameIn => 'ame_api3',

1640: end if;
1641: errorCode := -20315;
1642: errorMessage := ame_util.getMessage(applicationShortNameIn => 'PER',
1643: messageNameIn => 'AME_400454_GRP_DYN_QRY_ERR');
1644: ame_util.runtimeException(packageNameIn => 'ame_api3',
1645: routineNameIn => 'getGroupMembers4',
1646: exceptionNumberIn => errorCode,
1647: exceptionStringIn => errorMessage);
1648: raise_application_error(errorCode,

Line 1662: ame_util.runtimeException(packageNameIn => 'ame_api3',

1658: applicationShortNameIn => 'PER',
1659: messageNameIn => 'AME_400455_GRP_DYN_NULL_TXID',
1660: tokenNameOneIn => 'APPROVAL_GROUP',
1661: tokenValueOneIn => tempGroupName);
1662: ame_util.runtimeException(packageNameIn => 'ame_api3',
1663: routineNameIn => 'getGroupMembers4',
1664: exceptionNumberIn => errorCode,
1665: exceptionStringIn => errorMessage);
1666: raise_application_error(errorCode,

Line 1681: ame_util.runtimeException(packageNameIn => 'ame_api3',

1677: applicationShortNameIn => 'PER',
1678: messageNameIn => 'AME_400798_GROUP_ITEM_BIND',
1679: tokenNameOneIn => 'APPROVER_GROUP',
1680: tokenValueOneIn => tempGroupName);
1681: ame_util.runtimeException(packageNameIn => 'ame_api3',
1682: routineNameIn => 'getGroupMembers4',
1683: exceptionNumberIn => errorCode,
1684: exceptionStringIn => errorMessage);
1685: raise_application_error(errorCode,

Line 1691: ame_util.runtimeException(packageNameIn => 'ame_api3',

1687: when others then
1688: if(groupMemberCursor%isopen) then
1689: close groupMemberCursor;
1690: end if;
1691: ame_util.runtimeException(packageNameIn => 'ame_api3',
1692: routineNameIn => 'getGroupMembers4',
1693: exceptionNumberIn => sqlcode,
1694: exceptionStringIn => sqlerrm);
1695: raise;

Line 1710: ame_util.runtimeException(packageNameIn => 'ame_api3',

1706: itemClassIdsOut => itemClassIdsOut,
1707: itemClassNamesOut => itemClassNamesOut);
1708: exception
1709: when others then
1710: ame_util.runtimeException(packageNameIn => 'ame_api3',
1711: routineNameIn => 'getItemClasses',
1712: exceptionNumberIn => sqlcode,
1713: exceptionStringIn => sqlerrm);
1714: raise;

Line 1723: ame_util.runtimeException(packageNameIn => 'ame_api3',

1719: begin
1720: itemClassIdOut := ame_admin_pkg.getItemClassIdByName(itemClassNameIn => itemClassNameIn);
1721: exception
1722: when others then
1723: ame_util.runtimeException(packageNameIn => 'ame_api3',
1724: routineNameIn => 'getItemClassId',
1725: exceptionNumberIn => sqlcode,
1726: exceptionStringIn => sqlerrm);
1727: raise;

Line 1736: ame_util.runtimeException(packageNameIn => 'ame_api3',

1732: begin
1733: itemClassNameOut := ame_admin_pkg.getItemClassName(itemClassIdIn => itemClassIdIn);
1734: exception
1735: when others then
1736: ame_util.runtimeException(packageNameIn => 'ame_api3',
1737: routineNameIn => 'getItemClassName',
1738: exceptionNumberIn => sqlcode,
1739: exceptionStringIn => sqlerrm);
1740: raise;

Line 1855: ame_util.runtimeException(packageNameIn => 'ame_api3',

1851: oldApproversOut(tempIndex).source := null;
1852: end loop;
1853: exception
1854: when others then
1855: ame_util.runtimeException(packageNameIn => 'ame_api3',
1856: routineNameIn => 'getOldApprovers',
1857: exceptionNumberIn => sqlcode,
1858: exceptionStringIn => sqlerrm);
1859: oldApproversOut.delete;

Line 1931: ame_util.runtimeException(packageNameIn => 'ame_api3',

1927: into conditionIdsOut;
1928: close conditionCursor;
1929: exception
1930: when others then
1931: ame_util.runtimeException(packageNameIn => 'ame_api3',
1932: routineNameIn => 'getRuleDetails1',
1933: exceptionNumberIn => sqlcode,
1934: exceptionStringIn => sqlerrm);
1935: conditionIdsOut.delete;

Line 2004: ame_util.runtimeException(packageNameIn => 'ame_api3',

2000: into conditionDescriptionsOut;
2001: close conditionCursor;
2002: exception
2003: when others then
2004: ame_util.runtimeException(packageNameIn => 'ame_api3',
2005: routineNameIn => 'getRuleDetails2',
2006: exceptionNumberIn => sqlcode,
2007: exceptionStringIn => sqlerrm);
2008: conditionDescriptionsOut.delete;

Line 2098: ame_util.runtimeException(packageNameIn => 'ame_api3',

2094: conditionHasLOVsOut;
2095: close conditionCursor;
2096: exception
2097: when others then
2098: ame_util.runtimeException(packageNameIn => 'ame_api3',
2099: routineNameIn => 'getRuleDetails3',
2100: exceptionNumberIn => sqlcode,
2101: exceptionStringIn => sqlerrm);
2102: conditionDescriptionsOut.delete;

Line 2260: ame_util.runtimeException(packageNameIn => 'ame_api3',

2256: transactionIdIn => transactionIdIn,
2257: transactionTypeIdIn => transactionTypeIn);
2258: errorCode := -20001;
2259: errorMessage := ambiguousApproverMessage;
2260: ame_util.runtimeException(packageNameIn => 'ame_api3',
2261: routineNameIn => 'insertApprover',
2262: exceptionNumberIn => errorCode,
2263: exceptionStringIn => errorMessage);
2264: raise_application_error(errorCode,

Line 2273: ame_util.runtimeException(packageNameIn => 'ame_api3',

2269: transactionTypeIdIn => transactionTypeIn);
2270: errorCode := -20304;
2271: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
2272: messageNameIn => 'AME_400240_API_INV_ORDER_TYPE');
2273: ame_util.runtimeException(packageNameIn => 'ame_api3',
2274: routineNameIn => 'insertApprover',
2275: exceptionNumberIn => errorCode,
2276: exceptionStringIn => errorMessage);
2277: raise_application_error(errorCode,

Line 2286: ame_util.runtimeException(packageNameIn => 'ame_api3',

2282: transactionTypeIdIn => transactionTypeIn);
2283: errorCode := -20305;
2284: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
2285: messageNameIn => 'AME_400241_API_NON_NULL_INSAPP');
2286: ame_util.runtimeException(packageNameIn => 'ame_api3',
2287: routineNameIn => 'insertApprover',
2288: exceptionNumberIn => errorCode,
2289: exceptionStringIn => errorMessage);
2290: raise_application_error(errorCode,

Line 2299: ame_util.runtimeException(packageNameIn => 'ame_api3',

2295: transactionTypeIdIn => transactionTypeIn);
2296: errorCode := -20313;
2297: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
2298: messageNameIn => 'AME_400446_INCMPTBLE_APPR_INS');
2299: ame_util.runtimeException(packageNameIn => 'ame_api3',
2300: routineNameIn => 'insertApprover',
2301: exceptionNumberIn => errorCode,
2302: exceptionStringIn => errorMessage);
2303: raise_application_error(errorCode,

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

2308: transactionTypeIdIn => transactionTypeIn);
2309: errorCode := -20314;
2310: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
2311: messageNameIn => 'AME_400447_INVALID_APPR_CATG');
2312: ame_util.runtimeException(packageNameIn => 'ame_api3',
2313: routineNameIn => 'insertApprover',
2314: exceptionNumberIn => errorCode,
2315: exceptionStringIn => errorMessage);
2316: raise_application_error(errorCode,

Line 2322: ame_util.runtimeException(packageNameIn => 'ame_api3',

2318: when others then
2319: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,
2320: transactionIdIn => transactionIdIn,
2321: transactionTypeIdIn => transactionTypeIn);
2322: ame_util.runtimeException(packageNameIn => 'ame_api3',
2323: routineNameIn => 'insertApprover',
2324: exceptionNumberIn => sqlcode,
2325: exceptionStringIn => sqlerrm);
2326: raise;

Line 2735: ame_util.runtimeException(packageNameIn => 'ame_api3',

2731: tokenNameOneIn => 'APPROVER',
2732: tokenValueOneIn => ame_approver_type_pkg.getApproverDescription(anchorName),
2733: tokenNameTwoIn => 'ANCHORED_APPROVERS',
2734: tokenValueTwoIn => anchorList);
2735: ame_util.runtimeException(packageNameIn => 'ame_api3',
2736: routineNameIn => 'suppressApprover',
2737: exceptionNumberIn => errorCode,
2738: exceptionStringIn => errorMessage);
2739: raise_application_error(errorCode,

Line 2750: ame_util.runtimeException(packageNameIn => 'ame_api3',

2746: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
2747: messageNameIn => 'AME_400814_NULL_SUPPR_APPR_FLD',
2748: tokenNameOneIn => 'APPROVER_REC_PARAMS',
2749: tokenValueOneIn=>appr_rec_params);
2750: ame_util.runtimeException(packageNameIn => 'ame_api3',
2751: routineNameIn => 'suppressApprover',
2752: exceptionNumberIn => errorCode,
2753: exceptionStringIn => errorMessage);
2754: raise_application_error(errorCode,

Line 2763: ame_util.runtimeException(packageNameIn => 'ame_api3',

2759: transactionTypeIdIn => transactionTypeIn);
2760: errorCode := -20301;
2761: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
2762: messageNameIn => 'AME_400236_API_ADRGA_TRUE');
2763: ame_util.runtimeException(packageNameIn => 'ame_api3',
2764: routineNameIn => 'suppressApprover',
2765: exceptionNumberIn => errorCode,
2766: exceptionStringIn => errorMessage);
2767: raise_application_error(errorCode,

Line 2776: ame_util.runtimeException(packageNameIn => 'ame_api3',

2772: transactionTypeIdIn => transactionTypeIn);
2773: errorCode := -20302;
2774: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
2775: messageNameIn => 'AME_400237_API_NO MATCH_APPR');
2776: ame_util.runtimeException(packageNameIn => 'ame_api3',
2777: routineNameIn => 'suppressApprover',
2778: exceptionNumberIn => errorCode,
2779: exceptionStringIn => errorMessage);
2780: raise_application_error(errorCode,

Line 2786: ame_util.runtimeException(packageNameIn => 'ame_api3',

2782: when others then
2783: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,
2784: transactionIdIn => transactionIdIn,
2785: transactionTypeIdIn => transactionTypeIn);
2786: ame_util.runtimeException(packageNameIn => 'ame_api3',
2787: routineNameIn => 'suppressApprover',
2788: exceptionNumberIn => sqlcode,
2789: exceptionStringIn => sqlerrm);
2790: raise;

Line 2818: ame_util.runtimeException(packageNameIn => 'ame_api3',

2814: currentApproverInIndex := approversIn.next(currentApproverInIndex);
2815: end loop;
2816: exception
2817: when others then
2818: ame_util.runtimeException(packageNameIn => 'ame_api3',
2819: routineNameIn => 'suppressApprovers',
2820: exceptionNumberIn => sqlcode,
2821: exceptionStringIn => sqlerrm);
2822: raise;

Line 2824: end ame_api3;

2820: exceptionNumberIn => sqlcode,
2821: exceptionStringIn => sqlerrm);
2822: raise;
2823: end suppressApprovers;
2824: end ame_api3;