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_API dependencies on AME_API

Line 1: package body ame_api as

1: package body ame_api as
2: /* $Header: ameeapin.pkb 120.9.12000000.3 2007/07/23 08:19:51 prasashe noship $ */
3: /*check11510 checks backward compatibility of 11510 code with 1159 implementation
4: by checking if parallelization is induced in the AME setup*/
5: procedure check11510(applicationIdIn in integer,

Line 2: /* $Header: ameeapin.pkb 120.9.12000000.3 2007/07/23 08:19:51 prasashe noship $ */

1: package body ame_api as
2: /* $Header: ameeapin.pkb 120.9.12000000.3 2007/07/23 08:19:51 prasashe noship $ */
3: /*check11510 checks backward compatibility of 11510 code with 1159 implementation
4: by checking if parallelization is induced in the AME setup*/
5: procedure check11510(applicationIdIn in integer,
6: transactionTypeIn in varchar2 default null);

Line 10: return(ame_api3.getRuleDescription(ruleIdIn => ruleIdIn));

6: transactionTypeIn in varchar2 default null);
7: /* functions */
8: function getRuleDescription(ruleIdIn in varchar2) return varchar2 as
9: begin
10: return(ame_api3.getRuleDescription(ruleIdIn => ruleIdIn));
11: exception
12: when others then
13: ame_util.runtimeException(packageNameIn => 'ame_api',
14: routineNameIn => 'getRuleDescription',

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

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

Line 29: return(ame_api2.validateApprover(approverIn=>approver));

25: approverRecord2Out =>approver);
26: if approver.name is null then
27: return(false);
28: else
29: return(ame_api2.validateApprover(approverIn=>approver));
30: end if;
31: exception
32: when others then
33: ame_util.runtimeException(packageNameIn => 'ame_api',

Line 33: ame_util.runtimeException(packageNameIn => 'ame_api',

29: return(ame_api2.validateApprover(approverIn=>approver));
30: end if;
31: exception
32: when others then
33: ame_util.runtimeException(packageNameIn => 'ame_api',
34: routineNameIn => 'validateApprover',
35: exceptionNumberIn => sqlcode,
36: exceptionStringIn => sqlerrm);
37: raise;

Line 292: ame_util.runtimeException(packageNameIn => 'ame_api',

288: when parallelizationFoundException then
289: errorCode := -20001;
290: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
291: messageNameIn => 'AME_400679_API_PARALLEL_CONFIG');
292: ame_util.runtimeException(packageNameIn => 'ame_api',
293: routineNameIn => 'check11510',
294: exceptionNumberIn => errorCode,
295: exceptionStringIn => 'ameApplicationId:'||ameApplicationId||
296: ':'||tempAMEObject||':'||errorMessage);

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

296: ':'||tempAMEObject||':'||errorMessage);
297: raise_application_error(errorCode,
298: errorMessage);
299: when others then
300: ame_util.runtimeException(packageNameIn => 'ame_api',
301: routineNameIn => 'check11510',
302: exceptionNumberIn => sqlcode,
303: exceptionStringIn => sqlerrm);
304: raise;

Line 312: ame_api2.clearAllApprovals(applicationIdIn => applicationIdIn,

308: transactionTypeIn in varchar2 default null) as
309: begin
310: check11510(applicationIdIn => applicationIdIn,
311: transactionTypeIn => transactionTypeIn);
312: ame_api2.clearAllApprovals(applicationIdIn => applicationIdIn,
313: transactionIdIn => transactionIdIn,
314: transactionTypeIn => transactionTypeIn);
315: exception
316: when others then

Line 317: ame_util.runtimeException(packageNameIn => 'ame_api',

313: transactionIdIn => transactionIdIn,
314: transactionTypeIn => transactionTypeIn);
315: exception
316: when others then
317: ame_util.runtimeException(packageNameIn => 'ame_api',
318: routineNameIn => 'clearAllApprovals',
319: exceptionNumberIn => sqlcode,
320: exceptionStringIn => sqlerrm);
321: raise;

Line 334: ame_api3.clearSuppression(approverIn => approver,

330: transactionTypeIn => transactionTypeIn);
331: ame_util.apprRecordToApprRecord2(approverRecordIn => approverIn,
332: itemIdIn => transactionIdIn,
333: approverRecord2Out =>approver);
334: ame_api3.clearSuppression(approverIn => approver,
335: applicationIdIn => applicationIdIn,
336: transactionIdIn => transactionIdIn,
337: transactionTypeIn => transactionTypeIn);
338: exception

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

336: transactionIdIn => transactionIdIn,
337: transactionTypeIn => transactionTypeIn);
338: exception
339: when others then
340: ame_util.runtimeException(packageNameIn => 'ame_api',
341: routineNameIn => 'clearDeletion',
342: exceptionNumberIn => sqlcode,
343: exceptionStringIn => sqlerrm);
344: raise;

Line 352: ame_api3.clearSuppressions(applicationIdIn => applicationIdIn,

348: transactionTypeIn in varchar2 default null) as
349: begin
350: check11510(applicationIdIn => applicationIdIn,
351: transactionTypeIn => transactionTypeIn);
352: ame_api3.clearSuppressions(applicationIdIn => applicationIdIn,
353: transactionIdIn => transactionIdIn,
354: transactionTypeIn => transactionTypeIn);
355: exception
356: when others then

Line 357: ame_util.runtimeException(packageNameIn => 'ame_api',

353: transactionIdIn => transactionIdIn,
354: transactionTypeIn => transactionTypeIn);
355: exception
356: when others then
357: ame_util.runtimeException(packageNameIn => 'ame_api',
358: routineNameIn => 'clearDeletions',
359: exceptionNumberIn => sqlcode,
360: exceptionStringIn => sqlerrm);
361: raise;

Line 374: ame_api3.clearInsertion(approverIn => approver,

370: transactionTypeIn => transactionTypeIn);
371: ame_util.apprRecordToApprRecord2(approverRecordIn => approverIn,
372: itemIdIn => transactionIdIn,
373: approverRecord2Out =>approver);
374: ame_api3.clearInsertion(approverIn => approver,
375: applicationIdIn => applicationIdIn,
376: transactionIdIn => transactionIdIn,
377: transactionTypeIn => transactionTypeIn);
378: exception

Line 380: ame_util.runtimeException(packageNameIn => 'ame_api',

376: transactionIdIn => transactionIdIn,
377: transactionTypeIn => transactionTypeIn);
378: exception
379: when others then
380: ame_util.runtimeException(packageNameIn => 'ame_api',
381: routineNameIn => 'clearInsertion',
382: exceptionNumberIn => sqlcode,
383: exceptionStringIn => sqlerrm);
384: raise;

Line 392: ame_api3.clearInsertions( applicationIdIn => applicationIdIn,

388: transactionTypeIn in varchar2 default null) as
389: begin
390: check11510(applicationIdIn => applicationIdIn,
391: transactionTypeIn => transactionTypeIn);
392: ame_api3.clearInsertions( applicationIdIn => applicationIdIn,
393: transactionIdIn => transactionIdIn,
394: transactionTypeIn => transactionTypeIn);
395: exception
396: when others then

Line 397: ame_util.runtimeException(packageNameIn => 'ame_api',

393: transactionIdIn => transactionIdIn,
394: transactionTypeIn => transactionTypeIn);
395: exception
396: when others then
397: ame_util.runtimeException(packageNameIn => 'ame_api',
398: routineNameIn => 'clearInsertions',
399: exceptionNumberIn => sqlcode,
400: exceptionStringIn => sqlerrm);
401: raise;

Line 468: ame_api3.suppressApprover(applicationIdIn => applicationIdIn,

464: if(approverIndex is null) then
465: raise noMatchException;
466: end if;
467: end if;
468: ame_api3.suppressApprover(applicationIdIn => applicationIdIn,
469: transactionIdIn => transactionIdIn,
470: approverIn => approver,
471: transactionTypeIn => transactionTypeIn);
472: exception

Line 477: ame_util.runtimeException(packageNameIn => 'ame_api',

473: when noMatchException then
474: errorCode := -20001;
475: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
476: messageNameIn => 'AME_400237_API_NO MATCH_APPR');
477: ame_util.runtimeException(packageNameIn => 'ame_api',
478: routineNameIn => 'deleteApprover',
479: exceptionNumberIn => errorCode,
480: exceptionStringIn => errorMessage);
481: raise_application_error(errorCode,

Line 484: ame_util.runtimeException(packageNameIn => 'ame_api',

480: exceptionStringIn => errorMessage);
481: raise_application_error(errorCode,
482: errorMessage);
483: when others then
484: ame_util.runtimeException(packageNameIn => 'ame_api',
485: routineNameIn => 'deleteApprover',
486: exceptionNumberIn => sqlcode,
487: exceptionStringIn => sqlerrm);
488: raise;

Line 507: ame_api.deleteApprover(applicationIdIn => applicationIdIn,

503: -- This procedure should always depend on deleteApprover, so that we don't
504: -- need to repeat error-checking and other logic here.
505: --
506: loop
507: ame_api.deleteApprover(applicationIdIn => applicationIdIn,
508: transactionIdIn => transactionIdIn,
509: approverIn => approversIn(currentApproverInIndex),
510: transactionTypeIn => transactionTypeIn);
511: if(currentApproverInIndex = lastApproverInIndex) then

Line 518: ame_util.runtimeException(packageNameIn => 'ame_api',

514: currentApproverInIndex := approversIn.next(currentApproverInIndex);
515: end loop;
516: exception
517: when others then
518: ame_util.runtimeException(packageNameIn => 'ame_api',
519: routineNameIn => 'deleteApprovers',
520: exceptionNumberIn => sqlcode,
521: exceptionStringIn => sqlerrm);
522: raise;

Line 529: ame_api2.getAdminApprover(applicationIdIn => applicationIdIn,

525: transactionTypeIn in varchar2 default null,
526: adminApproverOut out nocopy ame_util.approverRecord) as
527: adminApprover ame_util.approverRecord2;
528: begin
529: ame_api2.getAdminApprover(applicationIdIn => applicationIdIn,
530: transactionTypeIn => transactionTypeIn,
531: adminApproverOut => adminApprover);
532: if adminApprover.name is null then
533: return;

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

536: approverRecordOut => adminApproverOut);
537: end if;
538: exception
539: when others then
540: ame_util.runtimeException(packageNameIn => 'ame_api',
541: routineNameIn => 'getAdminApprover',
542: exceptionNumberIn => sqlcode,
543: exceptionStringIn => sqlerrm);
544: raise;

Line 556: ame_api2.getAllApprovers7(applicationIdIn => applicationIdIn,

552: tempCount integer;
553: begin
554: check11510(applicationIdIn => applicationIdIn,
555: transactionTypeIn => transactionTypeIn);
556: ame_api2.getAllApprovers7(applicationIdIn => applicationIdIn,
557: transactionTypeIn => transactionTypeIn,
558: transactionIdIn => transactionIdIn,
559: approvalProcessCompleteYNOut => approvalProcessCompleteYN,
560: approversOut => approvers);

Line 565: ame_util.runtimeException(packageNameIn => 'ame_api',

561: ame_util.apprTable2ToApprTable(approversTable2In => approvers,
562: approversTableOut => approversOut);
563: exception
564: when others then
565: ame_util.runtimeException(packageNameIn => 'ame_api',
566: routineNameIn => 'getAllApprovers',
567: exceptionNumberIn => sqlcode,
568: exceptionStringIn => sqlerrm);
569: approversOut.delete;

Line 589: ame_api2.getAndRecordAllApprovers(applicationIdIn => applicationIdIn,

585: itemSources ame_util.longStringList;
586: begin
587: check11510(applicationIdIn => applicationIdIn,
588: transactionTypeIn => transactionTypeIn);
589: ame_api2.getAndRecordAllApprovers(applicationIdIn => applicationIdIn,
590: transactionTypeIn => transactionTypeIn,
591: transactionIdIn => transactionIdIn,
592: approvalProcessCompleteYNOut => approvalProcessCompleteYN,
593: approversOut => approvers,

Line 602: ame_util.runtimeException(packageNameIn => 'ame_api',

598: ame_util.apprTable2ToApprTable(approversTable2In => approvers,
599: approversTableOut => approversOut);
600: exception
601: when others then
602: ame_util.runtimeException(packageNameIn => 'ame_api',
603: routineNameIn => 'getAndRecordAllApprovers',
604: exceptionNumberIn => sqlcode,
605: exceptionStringIn => sqlerrm);
606: approversOut.delete;

Line 619: ame_api3.getApplicableRules1(applicationIdIn => applicationIdIn,

615: ruleIdsOut out nocopy ame_util.idList) as
616: begin
617: check11510(applicationIdIn => applicationIdIn,
618: transactionTypeIn => transactionTypeIn);
619: ame_api3.getApplicableRules1(applicationIdIn => applicationIdIn,
620: transactionIdIn => transactionIdIn,
621: transactionTypeIn => transactionTypeIn,
622: ruleIdsOut => ruleIdsOut);
623: exception

Line 625: ame_util.runtimeException(packageNameIn => 'ame_api',

621: transactionTypeIn => transactionTypeIn,
622: ruleIdsOut => ruleIdsOut);
623: exception
624: when others then
625: ame_util.runtimeException(packageNameIn => 'ame_api',
626: routineNameIn => 'getApplicableRules1',
627: exceptionNumberIn => sqlcode,
628: exceptionStringIn => sqlerrm);
629: raise;

Line 638: ame_api3.getApplicableRules2(applicationIdIn => applicationIdIn,

634: ruleDescriptionsOut out nocopy ame_util.stringList) as
635: begin
636: check11510(applicationIdIn => applicationIdIn,
637: transactionTypeIn => transactionTypeIn);
638: ame_api3.getApplicableRules2(applicationIdIn => applicationIdIn,
639: transactionIdIn => transactionIdIn,
640: transactionTypeIn => transactionTypeIn,
641: ruleDescriptionsOut => ruleDescriptionsOut);
642: exception

Line 644: ame_util.runtimeException(packageNameIn => 'ame_api',

640: transactionTypeIn => transactionTypeIn,
641: ruleDescriptionsOut => ruleDescriptionsOut);
642: exception
643: when others then
644: ame_util.runtimeException(packageNameIn => 'ame_api',
645: routineNameIn => 'getApplicableRules2',
646: exceptionNumberIn => sqlcode,
647: exceptionStringIn => sqlerrm);
648: raise;

Line 658: ame_api3.getApplicableRules3(applicationIdIn => applicationIdIn,

654: ruleDescriptionsOut out nocopy ame_util.stringList) as
655: begin
656: check11510(applicationIdIn => applicationIdIn,
657: transactionTypeIn => transactionTypeIn);
658: ame_api3.getApplicableRules3(applicationIdIn => applicationIdIn,
659: transactionIdIn => transactionIdIn,
660: transactionTypeIn => transactionTypeIn,
661: ruleIdsOut => ruleIdsOut,
662: ruleDescriptionsOut => ruleDescriptionsOut);

Line 665: ame_util.runtimeException(packageNameIn => 'ame_api',

661: ruleIdsOut => ruleIdsOut,
662: ruleDescriptionsOut => ruleDescriptionsOut);
663: exception
664: when others then
665: ame_util.runtimeException(packageNameIn => 'ame_api',
666: routineNameIn => 'getApplicableRules3',
667: exceptionNumberIn => sqlcode,
668: exceptionStringIn => sqlerrm);
669: raise;

Line 681: ame_api2.getAllApprovers7(applicationIdIn => applicationIdIn,

677: approvers ame_util.approversTable2;
678: begin
679: check11510(applicationIdIn => applicationIdIn,
680: transactionTypeIn => transactionTypeIn);
681: ame_api2.getAllApprovers7(applicationIdIn => applicationIdIn,
682: transactionTypeIn => transactionTypeIn,
683: transactionIdIn => transactionIdIn,
684: approvalProcessCompleteYNOut => approvalProcessCompleteYN,
685: approversOut => approvers);

Line 686: ame_api3.getApplicableRules1(applicationIdIn => applicationIdIn,

682: transactionTypeIn => transactionTypeIn,
683: transactionIdIn => transactionIdIn,
684: approvalProcessCompleteYNOut => approvalProcessCompleteYN,
685: approversOut => approvers);
686: ame_api3.getApplicableRules1(applicationIdIn => applicationIdIn,
687: transactionIdIn => transactionIdIn,
688: transactionTypeIn => transactionTypeIn,
689: ruleIdsOut => ruleIdsOut);
690: ame_util.apprTable2ToApprTable(approversTable2In => approvers,

Line 694: ame_util.runtimeException(packageNameIn => 'ame_api',

690: ame_util.apprTable2ToApprTable(approversTable2In => approvers,
691: approversTableOut => approversOut);
692: exception
693: when others then
694: ame_util.runtimeException(packageNameIn => 'ame_api',
695: routineNameIn => 'getApproversAndRules1',
696: exceptionNumberIn => sqlcode,
697: exceptionStringIn => sqlerrm);
698: approversOut.delete;

Line 715: ame_api2.getAllApprovers7(applicationIdIn => applicationIdIn,

711: approvers ame_util.approversTable2;
712: begin
713: check11510(applicationIdIn => applicationIdIn,
714: transactionTypeIn => transactionTypeIn);
715: ame_api2.getAllApprovers7(applicationIdIn => applicationIdIn,
716: transactionTypeIn => transactionTypeIn,
717: transactionIdIn => transactionIdIn,
718: approvalProcessCompleteYNOut => approvalProcessCompleteYN,
719: approversOut => approvers);

Line 720: ame_api3.getApplicableRules2(applicationIdIn => applicationIdIn,

716: transactionTypeIn => transactionTypeIn,
717: transactionIdIn => transactionIdIn,
718: approvalProcessCompleteYNOut => approvalProcessCompleteYN,
719: approversOut => approvers);
720: ame_api3.getApplicableRules2(applicationIdIn => applicationIdIn,
721: transactionIdIn => transactionIdIn,
722: transactionTypeIn => transactionTypeIn,
723: ruleDescriptionsOut => ruleDescriptionsOut);
724: ame_util.apprTable2ToApprTable(approversTable2In => approvers,

Line 728: ame_util.runtimeException(packageNameIn => 'ame_api',

724: ame_util.apprTable2ToApprTable(approversTable2In => approvers,
725: approversTableOut => approversOut);
726: exception
727: when others then
728: ame_util.runtimeException(packageNameIn => 'ame_api',
729: routineNameIn => 'getApproversAndRules2',
730: exceptionNumberIn => sqlcode,
731: exceptionStringIn => sqlerrm);
732: approversOut.delete;

Line 750: ame_api2.getAllApprovers7(applicationIdIn => applicationIdIn,

746: approvers ame_util.approversTable2;
747: begin
748: check11510(applicationIdIn => applicationIdIn,
749: transactionTypeIn => transactionTypeIn);
750: ame_api2.getAllApprovers7(applicationIdIn => applicationIdIn,
751: transactionTypeIn => transactionTypeIn,
752: transactionIdIn => transactionIdIn,
753: approvalProcessCompleteYNOut => approvalProcessCompleteYN,
754: approversOut => approvers);

Line 755: ame_api3.getApplicableRules3(applicationIdIn => applicationIdIn,

751: transactionTypeIn => transactionTypeIn,
752: transactionIdIn => transactionIdIn,
753: approvalProcessCompleteYNOut => approvalProcessCompleteYN,
754: approversOut => approvers);
755: ame_api3.getApplicableRules3(applicationIdIn => applicationIdIn,
756: transactionIdIn => transactionIdIn,
757: transactionTypeIn => transactionTypeIn,
758: ruleIdsOut => ruleIdsOut,
759: ruleDescriptionsOut => ruleDescriptionsOut);

Line 764: ame_util.runtimeException(packageNameIn => 'ame_api',

760: ame_util.apprTable2ToApprTable(approversTable2In => approvers,
761: approversTableOut => approversOut);
762: exception
763: when others then
764: ame_util.runtimeException(packageNameIn => 'ame_api',
765: routineNameIn => 'getApproversAndRules3',
766: exceptionNumberIn => sqlcode,
767: exceptionStringIn => sqlerrm);
768: approversOut.delete;

Line 787: ame_api3.getAvailableInsertions(applicationIdIn => applicationIdIn,

783: availableInsertions ame_util.insertionsTable2;
784: begin
785: check11510(applicationIdIn => applicationIdIn,
786: transactionTypeIn => transactionTypeIn);
787: ame_api3.getAvailableInsertions(applicationIdIn => applicationIdIn,
788: transactionIdIn => transactionIdIn,
789: positionIn => positionIn,
790: transactionTypeIn => transactionTypeIn,
791: availableInsertionsOut => availableInsertions);

Line 796: ame_util.runtimeException(packageNameIn => 'ame_api',

792: ame_util.insTable2ToInsTable(insertionsTable2In => availableInsertions,
793: insertionsTableOut => availableInsertionsOut);
794: exception
795: when others then
796: ame_util.runtimeException(packageNameIn => 'ame_api',
797: routineNameIn => 'getAvailableInsertions',
798: exceptionNumberIn => sqlcode,
799: exceptionStringIn => sqlerrm);
800: raise;

Line 1213: ame_util.runtimeException(packageNameIn => 'ame_api',

1209: when invalidPositionException then
1210: errorCode := -20001;
1211: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
1212: messageNameIn => 'AME_400418_INVALID_INSERTION');
1213: ame_util.runtimeException(packageNameIn => 'ame_api',
1214: routineNameIn => 'getAvailableOrders',
1215: exceptionNumberIn => errorCode,
1216: exceptionStringIn => errorMessage);
1217: raise_application_error(errorCode,

Line 1220: ame_util.runtimeException(packageNameIn => 'ame_api',

1216: exceptionStringIn => errorMessage);
1217: raise_application_error(errorCode,
1218: errorMessage);
1219: when others then
1220: ame_util.runtimeException(packageNameIn => 'ame_api',
1221: routineNameIn => 'getAvailableOrders',
1222: exceptionNumberIn => sqlcode,
1223: exceptionStringIn => sqlerrm);
1224: raise;

Line 1237: ame_api3.getConditionDetails(conditionIdIn => conditionIdIn,

1233: includeUpperLimitOut out nocopy varchar2,
1234: currencyCodeOut out nocopy varchar2,
1235: allowedValuesOut out nocopy ame_util.longestStringList) as
1236: begin
1237: ame_api3.getConditionDetails(conditionIdIn => conditionIdIn,
1238: attributeNameOut => attributeNameOut,
1239: attributeTypeOut => attributeTypeOut,
1240: attributeDescriptionOut => attributeDescriptionOut,
1241: lowerLimitOut => lowerLimitOut,

Line 1249: ame_util.runtimeException(packageNameIn => 'ame_api',

1245: currencyCodeOut => currencyCodeOut,
1246: allowedValuesOut => allowedValuesOut);
1247: exception
1248: when others then
1249: ame_util.runtimeException(packageNameIn => 'ame_api',
1250: routineNameIn => 'getConditionDetails',
1251: exceptionNumberIn => sqlcode,
1252: exceptionStringIn => sqlerrm);
1253: raise;

Line 1281: ame_api2.getNextApprovers4(applicationIdIn => applicationIdIn,

1277: check11510(applicationIdIn => applicationIdIn,
1278: transactionTypeIn => transactionTypeIn);
1279: loop
1280: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanTrue;
1281: ame_api2.getNextApprovers4(applicationIdIn => applicationIdIn,
1282: transactionTypeIn => transactionTypeIn,
1283: transactionIdIn => transactionIdIn,
1284: flagApproversAsNotifiedIn => ame_util.booleanFalse,
1285: approvalProcessCompleteYNOut => approvalProcessCompleteYN,

Line 1326: ame_api2.getNextApprovers4(applicationIdIn => applicationIdIn,

1322: end if;
1323: end if;
1324: end loop;
1325: /* delete after talking to TM and SS - nsoni
1326: ame_api2.getNextApprovers4(applicationIdIn => applicationIdIn,
1327: transactionTypeIn => transactionTypeIn,
1328: transactionIdIn => transactionIdIn,
1329: flagApproversAsNotifiedIn => ame_util.booleanFalse,
1330: approvalProcessCompleteYNOut => approvalProcessCompleteYN,

Line 1344: ame_util.runtimeException(packageNameIn => 'ame_api',

1340: when parallelizationFoundException then
1341: errorCode := -20001;
1342: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
1343: messageNameIn => 'AME_400679_API_PARALLEL_CONFIG');
1344: ame_util.runtimeException(packageNameIn => 'ame_api',
1345: routineNameIn => 'getNextApprover',
1346: exceptionNumberIn => errorCode,
1347: exceptionStringIn => errorMessage);
1348: raise_application_error(errorCode,

Line 1351: ame_util.runtimeException(packageNameIn => 'ame_api',

1347: exceptionStringIn => errorMessage);
1348: raise_application_error(errorCode,
1349: errorMessage);
1350: when others then
1351: ame_util.runtimeException(packageNameIn => 'ame_api',
1352: routineNameIn => 'getNextApprover',
1353: exceptionNumberIn => sqlcode,
1354: exceptionStringIn => sqlerrm);
1355: getAdminApprover(applicationIdIn => applicationIdIn,

Line 1366: ame_api3.getOldApprovers(applicationIdIn => applicationIdIn,

1362: transactionTypeIn in varchar2 default null,
1363: oldApproversOut out nocopy ame_util.approversTable) as
1364: approvers ame_util.approversTable2;
1365: begin
1366: ame_api3.getOldApprovers(applicationIdIn => applicationIdIn,
1367: transactionIdIn => transactionIdIn,
1368: transactionTypeIn => transactionTypeIn,
1369: oldApproversOut => approvers);
1370: ame_util.apprTable2ToApprTable(approversTable2In => approvers,

Line 1374: ame_util.runtimeException(packageNameIn => 'ame_api',

1370: ame_util.apprTable2ToApprTable(approversTable2In => approvers,
1371: approversTableOut => oldApproversOut);
1372: exception
1373: when others then
1374: ame_util.runtimeException(packageNameIn => 'ame_api',
1375: routineNameIn => 'getOldApprovers',
1376: exceptionNumberIn => sqlcode,
1377: exceptionStringIn => sqlerrm);
1378: oldApproversOut.delete;

Line 1395: ame_api3.getRuleDetails1(ruleIdIn => ruleIdIn,

1391: approvalTypeNames ame_util.stringList;
1392: approvalTypeDescriptions ame_util.stringList;
1393: approvalDescriptions ame_util.stringList;
1394: begin
1395: ame_api3.getRuleDetails1(ruleIdIn => ruleIdIn,
1396: ruleTypeOut => ruleTypeOut,
1397: ruleDescriptionOut => ruleDescriptionOut,
1398: conditionIdsOut => conditionIdsOut,
1399: actionTypeNamesOut => approvalTypeNames,

Line 1413: ame_util.runtimeException(packageNameIn => 'ame_api',

1409: approvalDescriptionOut := approvalDescriptions(1);
1410: end if;
1411: exception
1412: when others then
1413: ame_util.runtimeException(packageNameIn => 'ame_api',
1414: routineNameIn => 'getRuleDetails1',
1415: exceptionNumberIn => sqlcode,
1416: exceptionStringIn => sqlerrm);
1417: conditionIdsOut.delete;

Line 1431: ame_api3.getRuleDetails2(ruleIdIn => ruleIdIn,

1427: approvalTypeNames ame_util.stringList;
1428: approvalTypeDescriptions ame_util.stringList;
1429: approvalDescriptions ame_util.stringList;
1430: begin
1431: ame_api3.getRuleDetails2(ruleIdIn => ruleIdIn,
1432: ruleTypeOut => ruleTypeOut,
1433: ruleDescriptionOut => ruleDescriptionOut,
1434: conditionDescriptionsOut => conditionDescriptionsOut,
1435: actionTypeNamesOut => approvalTypeNames,

Line 1449: ame_util.runtimeException(packageNameIn => 'ame_api',

1445: approvalDescriptionOut := approvalDescriptions(1);
1446: end if;
1447: exception
1448: when others then
1449: ame_util.runtimeException(packageNameIn => 'ame_api',
1450: routineNameIn => 'getRuleDetails2',
1451: exceptionNumberIn => sqlcode,
1452: exceptionStringIn => sqlerrm);
1453: conditionDescriptionsOut.delete;

Line 1470: ame_api3.getRuleDetails3(ruleIdIn => ruleIdIn,

1466: approvalTypeNames ame_util.stringList;
1467: approvalTypeDescriptions ame_util.stringList;
1468: approvalDescriptions ame_util.stringList;
1469: begin
1470: ame_api3.getRuleDetails3(ruleIdIn => ruleIdIn,
1471: ruleTypeOut => ruleTypeOut,
1472: ruleDescriptionOut => ruleDescriptionOut,
1473: conditionIdsOut => conditionIdsOut,
1474: conditionDescriptionsOut => conditionDescriptionsOut,

Line 1490: ame_util.runtimeException(packageNameIn => 'ame_api',

1486: approvalDescriptionOut := approvalDescriptions(1);
1487: end if;
1488: exception
1489: when others then
1490: ame_util.runtimeException(packageNameIn => 'ame_api',
1491: routineNameIn => 'getRuleDetails3',
1492: exceptionNumberIn => sqlcode,
1493: exceptionStringIn => sqlerrm);
1494: conditionIdsOut.delete;

Line 1505: ame_api2.initializeApprovalProcess(applicationIdIn => applicationIdIn,

1501: recordApproverListIn in boolean default false) as
1502: begin
1503: check11510(applicationIdIn => applicationIdIn,
1504: transactionTypeIn => transactionTypeIn);
1505: ame_api2.initializeApprovalProcess(applicationIdIn => applicationIdIn,
1506: transactionIdIn => transactionIdIn,
1507: transactionTypeIn => transactionTypeIn,
1508: recordApproverListIn => recordApproverListIn);
1509: exception

Line 1511: ame_util.runtimeException(packageNameIn => 'ame_api',

1507: transactionTypeIn => transactionTypeIn,
1508: recordApproverListIn => recordApproverListIn);
1509: exception
1510: when others then
1511: ame_util.runtimeException(packageNameIn => 'ame_api',
1512: routineNameIn => 'initializeApprovalProcess',
1513: exceptionNumberIn => sqlcode,
1514: exceptionStringIn => sqlerrm);
1515: raise;

Line 1539: ame_api3.insertApprover(applicationIdIn => applicationIdIn,

1535: approverIn => approverIn,
1536: insertionRecord2Out => insertion );
1537: approver.action_type_id := insertion.action_type_id;
1538: approver.group_or_chain_id := insertion.group_or_chain_id ;
1539: ame_api3.insertApprover(applicationIdIn => applicationIdIn,
1540: transactionTypeIn => transactionTypeIn,
1541: transactionIdIn => transactionIdIn,
1542: approverIn => approver,
1543: positionIn => positionIn,

Line 1547: ame_util.runtimeException(packageNameIn => 'ame_api',

1543: positionIn => positionIn,
1544: insertionIn =>insertion );
1545: exception
1546: when others then
1547: ame_util.runtimeException(packageNameIn => 'ame_api',
1548: routineNameIn => 'insertApprover',
1549: exceptionNumberIn => sqlcode,
1550: exceptionStringIn => sqlerrm);
1551: raise;

Line 1643: and group_or_chain_id. Call ame_api2.setFirstAuthorityApprover*/

1639: chainToBeInserted := false;
1640: end;
1641: if chainToBeInserted then
1642: /* convert approverIn to ame_util.approverRecord2, set action_type_id
1643: and group_or_chain_id. Call ame_api2.setFirstAuthorityApprover*/
1644: ame_util.apprRecordToApprRecord2(approverRecordIn => approverIn,
1645: itemIdIn => transactionIdIn,
1646: approverRecord2Out =>approver);
1647: approver.action_type_id := currentActionTypeId;

Line 1649: ame_api2.setFirstAuthorityApprover(applicationIdIn => applicationIdIn,

1645: itemIdIn => transactionIdIn,
1646: approverRecord2Out =>approver);
1647: approver.action_type_id := currentActionTypeId;
1648: approver.group_or_chain_id := currentGroupOrChainId;
1649: ame_api2.setFirstAuthorityApprover(applicationIdIn => applicationIdIn,
1650: transactionIdIn => transactionIdIn,
1651: approverIn => approver,
1652: transactionTypeIn => transactionTypeIn,
1653: clearChainStatusYNIn => 'Y');

Line 1663: ame_util.runtimeException(packageNameIn => 'ame_api',

1659: when tooLateException then
1660: errorCode := -20001;
1661: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
1662: messageNameIn => 'AME_400244_API_CHN_AUTH_TRANS');
1663: ame_util.runtimeException(packageNameIn => 'ame_api',
1664: routineNameIn => 'setFirstAuthorityApprover',
1665: exceptionNumberIn => errorCode,
1666: exceptionStringIn => errorMessage);
1667: raise_application_error(errorCode,

Line 1670: ame_util.runtimeException(packageNameIn => 'ame_api',

1666: exceptionStringIn => errorMessage);
1667: raise_application_error(errorCode,
1668: errorMessage);
1669: when others then
1670: ame_util.runtimeException(packageNameIn => 'ame_api',
1671: routineNameIn => 'setFirstAuthorityApprover',
1672: exceptionNumberIn => sqlcode,
1673: exceptionStringIn => sqlerrm);
1674: raise;

Line 1696: ame_api2.updateApprovalStatus(applicationIdIn => applicationIdIn,

1692: ame_util.apprRecordToApprRecord2(approverRecordIn => forwardeeIn,
1693: itemIdIn => transactionIdIn,
1694: approverRecord2Out =>forwardee);
1695: end if;
1696: ame_api2.updateApprovalStatus(applicationIdIn => applicationIdIn,
1697: transactionIdIn => transactionIdIn,
1698: approverIn => approver,
1699: transactionTypeIn => transactionTypeIn,
1700: forwardeeIn => forwardee);

Line 1703: ame_util.runtimeException(packageNameIn => 'ame_api',

1699: transactionTypeIn => transactionTypeIn,
1700: forwardeeIn => forwardee);
1701: exception
1702: when others then
1703: ame_util.runtimeException(packageNameIn => 'ame_api',
1704: routineNameIn => 'updateApprovalStatus',
1705: exceptionNumberIn => sqlcode,
1706: exceptionStringIn => sqlerrm);
1707: raise;

Line 1742: ame_api2.updateApprovalStatus2(applicationIdIn => applicationIdIn,

1738: ame_util.apprRecordToApprRecord2(approverRecordIn => forwardeeIn,
1739: itemIdIn => transactionIdIn,
1740: approverRecord2Out =>forwardee);
1741: end if;
1742: ame_api2.updateApprovalStatus2(applicationIdIn => applicationIdIn,
1743: transactionTypeIn => transactionTypeIn,
1744: transactionIdIn => transactionIdIn,
1745: approvalStatusIn => approvalStatusIn,
1746: approverNameIn=> approverName,

Line 1755: ame_util.runtimeException(packageNameIn => 'ame_api',

1751: occurrenceIn => occurrenceIn,
1752: forwardeeIn => forwardee);
1753: exception
1754: when others then
1755: ame_util.runtimeException(packageNameIn => 'ame_api',
1756: routineNameIn => 'updateApprovalStatus2',
1757: exceptionNumberIn => sqlcode,
1758: exceptionStringIn => sqlerrm);
1759: raise;

Line 1761: end ame_api;

1757: exceptionNumberIn => sqlcode,
1758: exceptionStringIn => sqlerrm);
1759: raise;
1760: end updateApprovalStatus2;
1761: end ame_api;