181: ame_engine.getItemIndexes(itemIndexesOut => itemIndexesOut);
182: ame_engine.getItemIds(itemIdsOut => itemIdsOut);
183: ame_engine.getItemClasses(itemClassesOut => itemClassesOut);
184: ame_engine.getItemSources(itemSourcesOut => itemSourcesOut);
185: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
186: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
187: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
188: approvalProcessCompleteYNOut := ame_util.booleanTrue;
189: else
182: ame_engine.getItemIds(itemIdsOut => itemIdsOut);
183: ame_engine.getItemClasses(itemClassesOut => itemClassesOut);
184: ame_engine.getItemSources(itemSourcesOut => itemSourcesOut);
185: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
186: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
187: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
188: approvalProcessCompleteYNOut := ame_util.booleanTrue;
189: else
190: approvalProcessCompleteYNOut := ame_util.booleanFalse;
183: ame_engine.getItemClasses(itemClassesOut => itemClassesOut);
184: ame_engine.getItemSources(itemSourcesOut => itemSourcesOut);
185: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
186: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
187: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
188: approvalProcessCompleteYNOut := ame_util.booleanTrue;
189: else
190: approvalProcessCompleteYNOut := ame_util.booleanFalse;
191: end if;
189: else
190: approvalProcessCompleteYNOut := ame_util.booleanFalse;
191: end if;
192: else
193: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
194: end if;
195: exception
196: when others then
197: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
193: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
194: end if;
195: exception
196: when others then
197: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
198: ame_util.runtimeException(packageNameIn => 'ame_api2',
199: routineNameIn => 'getAllApprovers1',
200: exceptionNumberIn => sqlcode,
201: exceptionStringIn => sqlerrm);
245: ame_engine.getItemSources(itemSourcesOut => itemSourcesOut);
246: ame_engine.getProductionIndexes(productionIndexesOut => productionIndexesOut);
247: ame_engine.getVariableNames(variableNamesOut=> variableNamesOut);
248: ame_engine.getVariableValues(variableValuesOut => variableValuesOut);
249: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
250: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
251: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
252: approvalProcessCompleteYNOut := ame_util.booleanTrue;
253: else
246: ame_engine.getProductionIndexes(productionIndexesOut => productionIndexesOut);
247: ame_engine.getVariableNames(variableNamesOut=> variableNamesOut);
248: ame_engine.getVariableValues(variableValuesOut => variableValuesOut);
249: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
250: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
251: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
252: approvalProcessCompleteYNOut := ame_util.booleanTrue;
253: else
254: approvalProcessCompleteYNOut := ame_util.booleanFalse;
247: ame_engine.getVariableNames(variableNamesOut=> variableNamesOut);
248: ame_engine.getVariableValues(variableValuesOut => variableValuesOut);
249: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
250: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
251: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
252: approvalProcessCompleteYNOut := ame_util.booleanTrue;
253: else
254: approvalProcessCompleteYNOut := ame_util.booleanFalse;
255: end if;
253: else
254: approvalProcessCompleteYNOut := ame_util.booleanFalse;
255: end if;
256: else
257: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
258: end if;
259: exception
260: when others then
261: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
257: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
258: end if;
259: exception
260: when others then
261: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
262: ame_util.runtimeException(packageNameIn => 'ame_api2',
263: routineNameIn => 'getAllApprovers2',
264: exceptionNumberIn => sqlcode,
265: exceptionStringIn => sqlerrm);
313: ame_engine.getVariableNames(variableNamesOut=> variableNamesOut);
314: ame_engine.getVariableValues(variableValuesOut => variableValuesOut);
315: ame_engine.getTransVariableNames(transVariableNamesOut => transVariableNamesOut);
316: ame_engine.getTransVariableValues(transVariableValuesOut => transVariableValuesOut);
317: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
318: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
319: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
320: approvalProcessCompleteYNOut := ame_util.booleanTrue;
321: else
314: ame_engine.getVariableValues(variableValuesOut => variableValuesOut);
315: ame_engine.getTransVariableNames(transVariableNamesOut => transVariableNamesOut);
316: ame_engine.getTransVariableValues(transVariableValuesOut => transVariableValuesOut);
317: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
318: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
319: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
320: approvalProcessCompleteYNOut := ame_util.booleanTrue;
321: else
322: approvalProcessCompleteYNOut := ame_util.booleanFalse;
315: ame_engine.getTransVariableNames(transVariableNamesOut => transVariableNamesOut);
316: ame_engine.getTransVariableValues(transVariableValuesOut => transVariableValuesOut);
317: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
318: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
319: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
320: approvalProcessCompleteYNOut := ame_util.booleanTrue;
321: else
322: approvalProcessCompleteYNOut := ame_util.booleanFalse;
323: end if;
321: else
322: approvalProcessCompleteYNOut := ame_util.booleanFalse;
323: end if;
324: else
325: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
326: end if;
327: exception
328: when others then
329: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
325: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
326: end if;
327: exception
328: when others then
329: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
330: ame_util.runtimeException(packageNameIn => 'ame_api2',
331: routineNameIn => 'getAllApprovers3',
332: exceptionNumberIn => sqlcode,
333: exceptionStringIn => sqlerrm);
377: ame_engine.getItemSources(itemSourcesOut => itemSourcesOut);
378: ame_engine.getRuleIndexes(ruleIndexesOut => ruleIndexesOut);
379: ame_engine.getSourceTypes(sourceTypesOut => sourceTypesOut);
380: ame_engine.getRuleIds(ruleIdsOut => ruleIdsOut);
381: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
382: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
383: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
384: approvalProcessCompleteYNOut := ame_util.booleanTrue;
385: else
378: ame_engine.getRuleIndexes(ruleIndexesOut => ruleIndexesOut);
379: ame_engine.getSourceTypes(sourceTypesOut => sourceTypesOut);
380: ame_engine.getRuleIds(ruleIdsOut => ruleIdsOut);
381: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
382: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
383: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
384: approvalProcessCompleteYNOut := ame_util.booleanTrue;
385: else
386: approvalProcessCompleteYNOut := ame_util.booleanFalse;
379: ame_engine.getSourceTypes(sourceTypesOut => sourceTypesOut);
380: ame_engine.getRuleIds(ruleIdsOut => ruleIdsOut);
381: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
382: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
383: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
384: approvalProcessCompleteYNOut := ame_util.booleanTrue;
385: else
386: approvalProcessCompleteYNOut := ame_util.booleanFalse;
387: end if;
385: else
386: approvalProcessCompleteYNOut := ame_util.booleanFalse;
387: end if;
388: else
389: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
390: end if;
391: exception
392: when others then
393: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
389: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
390: end if;
391: exception
392: when others then
393: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
394: ame_util.runtimeException(packageNameIn => 'ame_api2',
395: routineNameIn => 'getAllApprovers4',
396: exceptionNumberIn => sqlcode,
397: exceptionStringIn => sqlerrm);
441: ame_engine.getItemSources(itemSourcesOut => itemSourcesOut);
442: ame_engine.getRuleIndexes(ruleIndexesOut => ruleIndexesOut);
443: ame_engine.getSourceTypes(sourceTypesOut => sourceTypesOut);
444: ame_engine.getRuleDescriptions(ruleDescriptionsOut => ruleDescriptionsOut);
445: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
446: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
447: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
448: approvalProcessCompleteYNOut := ame_util.booleanTrue;
449: else
442: ame_engine.getRuleIndexes(ruleIndexesOut => ruleIndexesOut);
443: ame_engine.getSourceTypes(sourceTypesOut => sourceTypesOut);
444: ame_engine.getRuleDescriptions(ruleDescriptionsOut => ruleDescriptionsOut);
445: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
446: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
447: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
448: approvalProcessCompleteYNOut := ame_util.booleanTrue;
449: else
450: approvalProcessCompleteYNOut := ame_util.booleanFalse;
443: ame_engine.getSourceTypes(sourceTypesOut => sourceTypesOut);
444: ame_engine.getRuleDescriptions(ruleDescriptionsOut => ruleDescriptionsOut);
445: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
446: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
447: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
448: approvalProcessCompleteYNOut := ame_util.booleanTrue;
449: else
450: approvalProcessCompleteYNOut := ame_util.booleanFalse;
451: end if;
449: else
450: approvalProcessCompleteYNOut := ame_util.booleanFalse;
451: end if;
452: else
453: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
454: end if;
455: exception
456: when others then
457: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
453: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
454: end if;
455: exception
456: when others then
457: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
458: ame_util.runtimeException(packageNameIn => 'ame_api2',
459: routineNameIn => 'getAllApprovers5',
460: exceptionNumberIn => sqlcode,
461: exceptionStringIn => sqlerrm);
507: ame_engine.getRuleIndexes(ruleIndexesOut => ruleIndexesOut);
508: ame_engine.getSourceTypes(sourceTypesOut => sourceTypesOut);
509: ame_engine.getRuleIds(ruleIdsOut => ruleIdsOut);
510: ame_engine.getRuleDescriptions(ruleDescriptionsOut => ruleDescriptionsOut);
511: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
512: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
513: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
514: approvalProcessCompleteYNOut := ame_util.booleanTrue;
515: else
508: ame_engine.getSourceTypes(sourceTypesOut => sourceTypesOut);
509: ame_engine.getRuleIds(ruleIdsOut => ruleIdsOut);
510: ame_engine.getRuleDescriptions(ruleDescriptionsOut => ruleDescriptionsOut);
511: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
512: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
513: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
514: approvalProcessCompleteYNOut := ame_util.booleanTrue;
515: else
516: approvalProcessCompleteYNOut := ame_util.booleanFalse;
509: ame_engine.getRuleIds(ruleIdsOut => ruleIdsOut);
510: ame_engine.getRuleDescriptions(ruleDescriptionsOut => ruleDescriptionsOut);
511: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
512: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
513: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
514: approvalProcessCompleteYNOut := ame_util.booleanTrue;
515: else
516: approvalProcessCompleteYNOut := ame_util.booleanFalse;
517: end if;
515: else
516: approvalProcessCompleteYNOut := ame_util.booleanFalse;
517: end if;
518: else
519: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
520: end if;
521: exception
522: when others then
523: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
519: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
520: end if;
521: exception
522: when others then
523: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
524: ame_util.runtimeException(packageNameIn => 'ame_api2',
525: routineNameIn => 'getAllApprovers6',
526: exceptionNumberIn => sqlcode,
527: exceptionStringIn => sqlerrm);
557: fndApplicationIdIn => applicationIdIn,
558: transactionTypeIdIn => transactionTypeIn );
559: approvalProcessCompleteYNOut := ame_engine.getApprovalProcessCompleteYN;
560: ame_engine.getApprovers(approversOut => approversOut);
561: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
562: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
563: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
564: approvalProcessCompleteYNOut := ame_util.booleanTrue;
565: else
558: transactionTypeIdIn => transactionTypeIn );
559: approvalProcessCompleteYNOut := ame_engine.getApprovalProcessCompleteYN;
560: ame_engine.getApprovers(approversOut => approversOut);
561: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
562: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
563: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
564: approvalProcessCompleteYNOut := ame_util.booleanTrue;
565: else
566: approvalProcessCompleteYNOut := ame_util.booleanFalse;
559: approvalProcessCompleteYNOut := ame_engine.getApprovalProcessCompleteYN;
560: ame_engine.getApprovers(approversOut => approversOut);
561: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
562: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
563: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
564: approvalProcessCompleteYNOut := ame_util.booleanTrue;
565: else
566: approvalProcessCompleteYNOut := ame_util.booleanFalse;
567: end if;
565: else
566: approvalProcessCompleteYNOut := ame_util.booleanFalse;
567: end if;
568: else
569: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
570: end if;
571: exception
572: when others then
573: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
569: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
570: end if;
571: exception
572: when others then
573: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
574: ame_util.runtimeException(packageNameIn => 'ame_api2',
575: routineNameIn => 'getAllApprovers7',
576: exceptionNumberIn => sqlcode,
577: exceptionStringIn => sqlerrm);
651: ame_util.copyApproverRecord2(approverRecord2In => approvers(i),
652: approverRecord2Out => approversOut(approverCount) );
653: end if;
654: end loop;
655: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
656: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
657: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
658: approvalProcessCompleteYNOut := ame_util.booleanTrue;
659: else
652: approverRecord2Out => approversOut(approverCount) );
653: end if;
654: end loop;
655: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
656: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
657: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
658: approvalProcessCompleteYNOut := ame_util.booleanTrue;
659: else
660: approvalProcessCompleteYNOut := ame_util.booleanFalse;
653: end if;
654: end loop;
655: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
656: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
657: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
658: approvalProcessCompleteYNOut := ame_util.booleanTrue;
659: else
660: approvalProcessCompleteYNOut := ame_util.booleanFalse;
661: end if;
659: else
660: approvalProcessCompleteYNOut := ame_util.booleanFalse;
661: end if;
662: else
663: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
664: end if;
665: exception
666: when invalidItemClassIdException then
667: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
663: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
664: end if;
665: exception
666: when invalidItemClassIdException then
667: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
668: errorCode := -20001;
669: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
670: messageNameIn => 'AME_400419_INVALID_IC') ;
671: ame_util.runtimeException(packageNameIn => 'ame_api2',
675: approvalProcessCompleteYNOut := null;
676: raise_application_error(errorCode,
677: errorMessage);
678: when invalidItemException then
679: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
680: errorCode := -20001;
681: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
682: messageNameIn => 'AME_400420_INVALID_ITEM_ID') ;
683: ame_util.runtimeException(packageNameIn => 'ame_api2',
687: approvalProcessCompleteYNOut := null;
688: raise_application_error(errorCode,
689: errorMessage);
690: when others then
691: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
692: ame_util.runtimeException(packageNameIn => 'ame_api2',
693: routineNameIn => 'getAllItemApprovers1',
694: exceptionNumberIn => sqlcode,
695: exceptionStringIn => sqlerrm);
761: ame_util.copyApproverRecord2(approverRecord2In => approvers(i),
762: approverRecord2Out => approversOut(approverCount) );
763: end if;
764: end loop;
765: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
766: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
767: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
768: approvalProcessCompleteYNOut := ame_util.booleanTrue;
769: else
762: approverRecord2Out => approversOut(approverCount) );
763: end if;
764: end loop;
765: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
766: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
767: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
768: approvalProcessCompleteYNOut := ame_util.booleanTrue;
769: else
770: approvalProcessCompleteYNOut := ame_util.booleanFalse;
763: end if;
764: end loop;
765: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
766: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
767: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
768: approvalProcessCompleteYNOut := ame_util.booleanTrue;
769: else
770: approvalProcessCompleteYNOut := ame_util.booleanFalse;
771: end if;
769: else
770: approvalProcessCompleteYNOut := ame_util.booleanFalse;
771: end if;
772: else
773: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
774: end if;
775: exception
776: when invalidItemException then
777: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
773: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
774: end if;
775: exception
776: when invalidItemException then
777: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
778: errorCode := -20001;
779: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
780: messageNameIn => 'AME_400420_INVALID_ITEM_ID') ;
781: ame_util.runtimeException(packageNameIn => 'ame_api2',
785: approvalProcessCompleteYNOut := null;
786: raise_application_error(errorCode,
787: errorMessage);
788: when others then
789: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
790: ame_util.runtimeException(packageNameIn => 'ame_api2',
791: routineNameIn => 'getAllItemApprovers2',
792: exceptionNumberIn => sqlcode,
793: exceptionStringIn => sqlerrm);
837: ame_engine.getItemSources(itemSourcesOut => itemSourcesOut);
838: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,
839: transactionIdIn => transactionIdIn,
840: transactionTypeIdIn => transactionTypeIn);
841: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
842: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
843: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
844: approvalProcessCompleteYNOut := ame_util.booleanTrue;
845: else
838: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,
839: transactionIdIn => transactionIdIn,
840: transactionTypeIdIn => transactionTypeIn);
841: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
842: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
843: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
844: approvalProcessCompleteYNOut := ame_util.booleanTrue;
845: else
846: approvalProcessCompleteYNOut := ame_util.booleanFalse;
839: transactionIdIn => transactionIdIn,
840: transactionTypeIdIn => transactionTypeIn);
841: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
842: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
843: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
844: approvalProcessCompleteYNOut := ame_util.booleanTrue;
845: else
846: approvalProcessCompleteYNOut := ame_util.booleanFalse;
847: end if;
845: else
846: approvalProcessCompleteYNOut := ame_util.booleanFalse;
847: end if;
848: else
849: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
850: end if;
851: exception
852: when others then
853: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
849: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
850: end if;
851: exception
852: when others then
853: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
854: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,
855: transactionIdIn => transactionIdIn,
856: transactionTypeIdIn => transactionTypeIn);
857: ame_util.runtimeException(packageNameIn => 'ame_api2',
919: end loop;
920: if approvalProcessCompleteYNOut is null then
921: raise invalidItemException;
922: end if;
923: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
924: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
925: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
926: approvalProcessCompleteYNOut := ame_util.booleanTrue;
927: else
920: if approvalProcessCompleteYNOut is null then
921: raise invalidItemException;
922: end if;
923: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
924: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
925: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
926: approvalProcessCompleteYNOut := ame_util.booleanTrue;
927: else
928: approvalProcessCompleteYNOut := ame_util.booleanFalse;
921: raise invalidItemException;
922: end if;
923: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
924: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
925: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
926: approvalProcessCompleteYNOut := ame_util.booleanTrue;
927: else
928: approvalProcessCompleteYNOut := ame_util.booleanFalse;
929: end if;
927: else
928: approvalProcessCompleteYNOut := ame_util.booleanFalse;
929: end if;
930: else
931: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
932: end if;
933: exception
934: when invalidItemClassIdException then
935: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
931: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
932: end if;
933: exception
934: when invalidItemClassIdException then
935: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
936: errorCode := -20001;
937: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
938: messageNameIn => 'AME_400419_INVALID_IC') ;
939: ame_util.runtimeException(packageNameIn => 'ame_api2',
943: approvalProcessCompleteYNOut := null;
944: raise_application_error(errorCode,
945: errorMessage);
946: when invalidItemException then
947: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
948: errorCode := -20001;
949: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
950: messageNameIn => 'AME_400420_INVALID_ITEM_ID') ;
951: ame_util.runtimeException(packageNameIn => 'ame_api2',
955: approvalProcessCompleteYNOut := null;
956: raise_application_error(errorCode,
957: errorMessage);
958: when others then
959: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
960: ame_util.runtimeException(packageNameIn => 'ame_api2',
961: routineNameIn => 'getItemStatus1',
962: exceptionNumberIn => sqlcode,
963: exceptionStringIn => sqlerrm);
1014: end loop;
1015: if approvalProcessCompleteYNOut is null then
1016: raise invalidItemException;
1017: end if;
1018: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
1019: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
1020: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
1021: approvalProcessCompleteYNOut := ame_util.booleanTrue;
1022: else
1015: if approvalProcessCompleteYNOut is null then
1016: raise invalidItemException;
1017: end if;
1018: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
1019: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
1020: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
1021: approvalProcessCompleteYNOut := ame_util.booleanTrue;
1022: else
1023: approvalProcessCompleteYNOut := ame_util.booleanFalse;
1016: raise invalidItemException;
1017: end if;
1018: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
1019: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
1020: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
1021: approvalProcessCompleteYNOut := ame_util.booleanTrue;
1022: else
1023: approvalProcessCompleteYNOut := ame_util.booleanFalse;
1024: end if;
1022: else
1023: approvalProcessCompleteYNOut := ame_util.booleanFalse;
1024: end if;
1025: else
1026: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
1027: end if;
1028: exception
1029: when invalidItemClassIdException then
1030: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
1026: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
1027: end if;
1028: exception
1029: when invalidItemClassIdException then
1030: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
1031: errorCode := -20001;
1032: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
1033: messageNameIn => 'AME_400419_INVALID_IC') ;
1034: ame_util.runtimeException(packageNameIn => 'ame_api2',
1038: approvalProcessCompleteYNOut := null;
1039: raise_application_error(errorCode,
1040: errorMessage);
1041: when invalidItemException then
1042: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
1043: errorCode := -20001;
1044: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
1045: messageNameIn => 'AME_400420_INVALID_ITEM_ID') ;
1046: ame_util.runtimeException(packageNameIn => 'ame_api2',
1050: approvalProcessCompleteYNOut := null;
1051: raise_application_error(errorCode,
1052: errorMessage);
1053: when others then
1054: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
1055: ame_util.runtimeException(packageNameIn => 'ame_api2',
1056: routineNameIn => 'getItemStatus2',
1057: exceptionNumberIn => sqlcode,
1058: exceptionStringIn => sqlerrm);
1089: transactionTypeIdIn => transactionTypeIn );
1090: ame_engine.getAllItemIds(itemIdsOut => itemIdsOut);
1091: ame_engine.getAllItemClasses(itemClassNamesOut => itemClassNamesOut);
1092: ame_engine.getItemAppProcessCompleteYN(itemAppProcessCompleteYNOut => approvalProcessesCompleteYNOut);
1093: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
1094: for i in 1 .. approvalProcessesCompleteYNOut.count loop
1095: if approvalProcessesCompleteYNOut(i) = ame_util2.completeFullyApproved
1096: or approvalProcessesCompleteYNOut(i) = ame_util2.completeNoApprovers then
1097: approvalProcessesCompleteYNOut(i) := ame_util.booleanTrue;
1091: ame_engine.getAllItemClasses(itemClassNamesOut => itemClassNamesOut);
1092: ame_engine.getItemAppProcessCompleteYN(itemAppProcessCompleteYNOut => approvalProcessesCompleteYNOut);
1093: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
1094: for i in 1 .. approvalProcessesCompleteYNOut.count loop
1095: if approvalProcessesCompleteYNOut(i) = ame_util2.completeFullyApproved
1096: or approvalProcessesCompleteYNOut(i) = ame_util2.completeNoApprovers then
1097: approvalProcessesCompleteYNOut(i) := ame_util.booleanTrue;
1098: else
1099: approvalProcessesCompleteYNOut(i) := ame_util.booleanFalse;
1092: ame_engine.getItemAppProcessCompleteYN(itemAppProcessCompleteYNOut => approvalProcessesCompleteYNOut);
1093: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
1094: for i in 1 .. approvalProcessesCompleteYNOut.count loop
1095: if approvalProcessesCompleteYNOut(i) = ame_util2.completeFullyApproved
1096: or approvalProcessesCompleteYNOut(i) = ame_util2.completeNoApprovers then
1097: approvalProcessesCompleteYNOut(i) := ame_util.booleanTrue;
1098: else
1099: approvalProcessesCompleteYNOut(i) := ame_util.booleanFalse;
1100: end if;
1099: approvalProcessesCompleteYNOut(i) := ame_util.booleanFalse;
1100: end if;
1101: end loop;
1102: else
1103: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
1104: end if;
1105: exception
1106: when others then
1107: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
1103: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
1104: end if;
1105: exception
1106: when others then
1107: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
1108: ame_util.runtimeException(packageNameIn => 'ame_api2',
1109: routineNameIn => 'getItemStatuses',
1110: exceptionNumberIn => sqlcode,
1111: exceptionStringIn => sqlerrm);
1143: ,variableNamesOut => dummyStringList
1144: ,variableValuesOut => dummyStringList
1145: ,transVariableNamesOut => dummyStringList
1146: ,transVariableValuesOut => dummyStringList);
1147: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
1148: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
1149: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
1150: approvalProcessCompleteYNOut := ame_util.booleanTrue;
1151: else
1144: ,variableValuesOut => dummyStringList
1145: ,transVariableNamesOut => dummyStringList
1146: ,transVariableValuesOut => dummyStringList);
1147: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
1148: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
1149: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
1150: approvalProcessCompleteYNOut := ame_util.booleanTrue;
1151: else
1152: approvalProcessCompleteYNOut := ame_util.booleanFalse;
1145: ,transVariableNamesOut => dummyStringList
1146: ,transVariableValuesOut => dummyStringList);
1147: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
1148: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
1149: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
1150: approvalProcessCompleteYNOut := ame_util.booleanTrue;
1151: else
1152: approvalProcessCompleteYNOut := ame_util.booleanFalse;
1153: end if;
1151: else
1152: approvalProcessCompleteYNOut := ame_util.booleanFalse;
1153: end if;
1154: else
1155: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
1156: end if;
1157: exception
1158: when others then
1159: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
1155: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
1156: end if;
1157: exception
1158: when others then
1159: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
1160: ame_util.runtimeException(packageNameIn => 'ame_api2',
1161: routineNameIn => 'getNextApprovers1',
1162: exceptionNumberIn => sqlcode,
1163: exceptionStringIn => sqlerrm);
1200: ,variableNamesOut => variableNamesOut
1201: ,variableValuesOut => variableValuesOut
1202: ,transVariableNamesOut => dummyStringList
1203: ,transVariableValuesOut => dummyStringList);
1204: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
1205: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
1206: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
1207: approvalProcessCompleteYNOut := ame_util.booleanTrue;
1208: else
1201: ,variableValuesOut => variableValuesOut
1202: ,transVariableNamesOut => dummyStringList
1203: ,transVariableValuesOut => dummyStringList);
1204: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
1205: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
1206: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
1207: approvalProcessCompleteYNOut := ame_util.booleanTrue;
1208: else
1209: approvalProcessCompleteYNOut := ame_util.booleanFalse;
1202: ,transVariableNamesOut => dummyStringList
1203: ,transVariableValuesOut => dummyStringList);
1204: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
1205: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
1206: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
1207: approvalProcessCompleteYNOut := ame_util.booleanTrue;
1208: else
1209: approvalProcessCompleteYNOut := ame_util.booleanFalse;
1210: end if;
1208: else
1209: approvalProcessCompleteYNOut := ame_util.booleanFalse;
1210: end if;
1211: else
1212: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
1213: end if;
1214: exception
1215: when others then
1216: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
1212: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
1213: end if;
1214: exception
1215: when others then
1216: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
1217: ame_util.runtimeException(packageNameIn => 'ame_api2',
1218: routineNameIn => 'getNextApprovers2',
1219: exceptionNumberIn => sqlcode,
1220: exceptionStringIn => sqlerrm);
1261: ,variableNamesOut => variableNamesOut
1262: ,variableValuesOut => variableValuesOut
1263: ,transVariableNamesOut => transVariableNamesOut
1264: ,transVariableValuesOut => transVariableValuesOut);
1265: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
1266: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
1267: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
1268: approvalProcessCompleteYNOut := ame_util.booleanTrue;
1269: else
1262: ,variableValuesOut => variableValuesOut
1263: ,transVariableNamesOut => transVariableNamesOut
1264: ,transVariableValuesOut => transVariableValuesOut);
1265: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
1266: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
1267: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
1268: approvalProcessCompleteYNOut := ame_util.booleanTrue;
1269: else
1270: approvalProcessCompleteYNOut := ame_util.booleanFalse;
1263: ,transVariableNamesOut => transVariableNamesOut
1264: ,transVariableValuesOut => transVariableValuesOut);
1265: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
1266: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
1267: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
1268: approvalProcessCompleteYNOut := ame_util.booleanTrue;
1269: else
1270: approvalProcessCompleteYNOut := ame_util.booleanFalse;
1271: end if;
1269: else
1270: approvalProcessCompleteYNOut := ame_util.booleanFalse;
1271: end if;
1272: else
1273: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
1274: end if;
1275: exception
1276: when others then
1277: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
1273: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
1274: end if;
1275: exception
1276: when others then
1277: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
1278: ame_util.runtimeException(packageNameIn => 'ame_api2',
1279: routineNameIn => 'getNextApprovers3',
1280: exceptionNumberIn => sqlcode,
1281: exceptionStringIn => sqlerrm);
1318: ,variableNamesOut => dummyStringList
1319: ,variableValuesOut => dummyStringList
1320: ,transVariableNamesOut => dummyStringList
1321: ,transVariableValuesOut => dummyStringList);
1322: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
1323: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
1324: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
1325: approvalProcessCompleteYNOut := ame_util.booleanTrue;
1326: else
1319: ,variableValuesOut => dummyStringList
1320: ,transVariableNamesOut => dummyStringList
1321: ,transVariableValuesOut => dummyStringList);
1322: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
1323: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
1324: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
1325: approvalProcessCompleteYNOut := ame_util.booleanTrue;
1326: else
1327: approvalProcessCompleteYNOut := ame_util.booleanFalse;
1320: ,transVariableNamesOut => dummyStringList
1321: ,transVariableValuesOut => dummyStringList);
1322: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
1323: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
1324: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
1325: approvalProcessCompleteYNOut := ame_util.booleanTrue;
1326: else
1327: approvalProcessCompleteYNOut := ame_util.booleanFalse;
1328: end if;
1326: else
1327: approvalProcessCompleteYNOut := ame_util.booleanFalse;
1328: end if;
1329: else
1330: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
1331: end if;
1332: exception
1333: when others then
1334: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
1330: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
1331: end if;
1332: exception
1333: when others then
1334: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
1335: ame_util.runtimeException(packageNameIn => 'ame_api2',
1336: routineNameIn => 'getNextApprovers4',
1337: exceptionNumberIn => sqlcode,
1338: exceptionStringIn => sqlerrm);
1379: ame_util.copyApproverRecord2(approverRecord2In => approvers(i),
1380: approverRecord2Out => approversOut(approverCount) );
1381: end if;
1382: end loop;
1383: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
1384: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
1385: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
1386: approvalProcessCompleteYNOut := ame_util.booleanTrue;
1387: else
1380: approverRecord2Out => approversOut(approverCount) );
1381: end if;
1382: end loop;
1383: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
1384: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
1385: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
1386: approvalProcessCompleteYNOut := ame_util.booleanTrue;
1387: else
1388: approvalProcessCompleteYNOut := ame_util.booleanFalse;
1381: end if;
1382: end loop;
1383: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
1384: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
1385: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
1386: approvalProcessCompleteYNOut := ame_util.booleanTrue;
1387: else
1388: approvalProcessCompleteYNOut := ame_util.booleanFalse;
1389: end if;
1387: else
1388: approvalProcessCompleteYNOut := ame_util.booleanFalse;
1389: end if;
1390: else
1391: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
1392: end if;
1393: exception
1394: when others then
1395: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
1391: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
1392: end if;
1393: exception
1394: when others then
1395: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
1396: ame_util.runtimeException(packageNameIn => 'ame_api2',
1397: routineNameIn => 'getPendingApprovers',
1398: exceptionNumberIn => sqlcode,
1399: exceptionStringIn => sqlerrm);
1405: transactionTypeIn in varchar2,
1406: transactionIdIn in varchar2,
1407: variableNamesOut out nocopy ame_util.stringList,
1408: variableValuesOut out nocopy ame_util.stringList) as
1409: tempProductions ame_util2.productionsTable;
1410: tempIndex integer;
1411: begin
1412: ame_engine.updateTransactionState(isTestTransactionIn => false,
1413: isLocalTransactionIn => false,