DBA Data[Home] [Help]

APPS.AME_API2 dependencies on AME_UTIL2

Line 228: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then

224: ame_engine.getItemIndexes(itemIndexesOut => itemIndexesOut);
225: ame_engine.getItemIds(itemIdsOut => itemIdsOut);
226: ame_engine.getItemClasses(itemClassesOut => itemClassesOut);
227: ame_engine.getItemSources(itemSourcesOut => itemSourcesOut);
228: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
229: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
230: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
231: approvalProcessCompleteYNOut := ame_util.booleanTrue;
232: else

Line 229: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved

225: ame_engine.getItemIds(itemIdsOut => itemIdsOut);
226: ame_engine.getItemClasses(itemClassesOut => itemClassesOut);
227: ame_engine.getItemSources(itemSourcesOut => itemSourcesOut);
228: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
229: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
230: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
231: approvalProcessCompleteYNOut := ame_util.booleanTrue;
232: else
233: approvalProcessCompleteYNOut := ame_util.booleanFalse;

Line 230: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then

226: ame_engine.getItemClasses(itemClassesOut => itemClassesOut);
227: ame_engine.getItemSources(itemSourcesOut => itemSourcesOut);
228: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
229: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
230: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
231: approvalProcessCompleteYNOut := ame_util.booleanTrue;
232: else
233: approvalProcessCompleteYNOut := ame_util.booleanFalse;
234: end if;

Line 236: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;

232: else
233: approvalProcessCompleteYNOut := ame_util.booleanFalse;
234: end if;
235: else
236: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
237: end if;
238: exception
239: when others then
240: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;

Line 240: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;

236: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
237: end if;
238: exception
239: when others then
240: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
241: ame_util.runtimeException(packageNameIn => 'ame_api2',
242: routineNameIn => 'getAllApprovers1',
243: exceptionNumberIn => sqlcode,
244: exceptionStringIn => sqlerrm);

Line 292: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then

288: ame_engine.getItemSources(itemSourcesOut => itemSourcesOut);
289: ame_engine.getProductionIndexes(productionIndexesOut => productionIndexesOut);
290: ame_engine.getVariableNames(variableNamesOut=> variableNamesOut);
291: ame_engine.getVariableValues(variableValuesOut => variableValuesOut);
292: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
293: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
294: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
295: approvalProcessCompleteYNOut := ame_util.booleanTrue;
296: else

Line 293: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved

289: ame_engine.getProductionIndexes(productionIndexesOut => productionIndexesOut);
290: ame_engine.getVariableNames(variableNamesOut=> variableNamesOut);
291: ame_engine.getVariableValues(variableValuesOut => variableValuesOut);
292: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
293: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
294: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
295: approvalProcessCompleteYNOut := ame_util.booleanTrue;
296: else
297: approvalProcessCompleteYNOut := ame_util.booleanFalse;

Line 294: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then

290: ame_engine.getVariableNames(variableNamesOut=> variableNamesOut);
291: ame_engine.getVariableValues(variableValuesOut => variableValuesOut);
292: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
293: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
294: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
295: approvalProcessCompleteYNOut := ame_util.booleanTrue;
296: else
297: approvalProcessCompleteYNOut := ame_util.booleanFalse;
298: end if;

Line 300: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;

296: else
297: approvalProcessCompleteYNOut := ame_util.booleanFalse;
298: end if;
299: else
300: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
301: end if;
302: exception
303: when others then
304: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;

Line 304: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;

300: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
301: end if;
302: exception
303: when others then
304: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
305: ame_util.runtimeException(packageNameIn => 'ame_api2',
306: routineNameIn => 'getAllApprovers2',
307: exceptionNumberIn => sqlcode,
308: exceptionStringIn => sqlerrm);

Line 360: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then

356: ame_engine.getVariableNames(variableNamesOut=> variableNamesOut);
357: ame_engine.getVariableValues(variableValuesOut => variableValuesOut);
358: ame_engine.getTransVariableNames(transVariableNamesOut => transVariableNamesOut);
359: ame_engine.getTransVariableValues(transVariableValuesOut => transVariableValuesOut);
360: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
361: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
362: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
363: approvalProcessCompleteYNOut := ame_util.booleanTrue;
364: else

Line 361: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved

357: ame_engine.getVariableValues(variableValuesOut => variableValuesOut);
358: ame_engine.getTransVariableNames(transVariableNamesOut => transVariableNamesOut);
359: ame_engine.getTransVariableValues(transVariableValuesOut => transVariableValuesOut);
360: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
361: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
362: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
363: approvalProcessCompleteYNOut := ame_util.booleanTrue;
364: else
365: approvalProcessCompleteYNOut := ame_util.booleanFalse;

Line 362: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then

358: ame_engine.getTransVariableNames(transVariableNamesOut => transVariableNamesOut);
359: ame_engine.getTransVariableValues(transVariableValuesOut => transVariableValuesOut);
360: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
361: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
362: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
363: approvalProcessCompleteYNOut := ame_util.booleanTrue;
364: else
365: approvalProcessCompleteYNOut := ame_util.booleanFalse;
366: end if;

Line 368: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;

364: else
365: approvalProcessCompleteYNOut := ame_util.booleanFalse;
366: end if;
367: else
368: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
369: end if;
370: exception
371: when others then
372: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;

Line 372: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;

368: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
369: end if;
370: exception
371: when others then
372: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
373: ame_util.runtimeException(packageNameIn => 'ame_api2',
374: routineNameIn => 'getAllApprovers3',
375: exceptionNumberIn => sqlcode,
376: exceptionStringIn => sqlerrm);

Line 424: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then

420: ame_engine.getItemSources(itemSourcesOut => itemSourcesOut);
421: ame_engine.getRuleIndexes(ruleIndexesOut => ruleIndexesOut);
422: ame_engine.getSourceTypes(sourceTypesOut => sourceTypesOut);
423: ame_engine.getRuleIds(ruleIdsOut => ruleIdsOut);
424: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
425: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
426: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
427: approvalProcessCompleteYNOut := ame_util.booleanTrue;
428: else

Line 425: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved

421: ame_engine.getRuleIndexes(ruleIndexesOut => ruleIndexesOut);
422: ame_engine.getSourceTypes(sourceTypesOut => sourceTypesOut);
423: ame_engine.getRuleIds(ruleIdsOut => ruleIdsOut);
424: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
425: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
426: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
427: approvalProcessCompleteYNOut := ame_util.booleanTrue;
428: else
429: approvalProcessCompleteYNOut := ame_util.booleanFalse;

Line 426: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then

422: ame_engine.getSourceTypes(sourceTypesOut => sourceTypesOut);
423: ame_engine.getRuleIds(ruleIdsOut => ruleIdsOut);
424: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
425: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
426: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
427: approvalProcessCompleteYNOut := ame_util.booleanTrue;
428: else
429: approvalProcessCompleteYNOut := ame_util.booleanFalse;
430: end if;

Line 432: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;

428: else
429: approvalProcessCompleteYNOut := ame_util.booleanFalse;
430: end if;
431: else
432: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
433: end if;
434: exception
435: when others then
436: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;

Line 436: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;

432: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
433: end if;
434: exception
435: when others then
436: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
437: ame_util.runtimeException(packageNameIn => 'ame_api2',
438: routineNameIn => 'getAllApprovers4',
439: exceptionNumberIn => sqlcode,
440: exceptionStringIn => sqlerrm);

Line 488: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then

484: ame_engine.getItemSources(itemSourcesOut => itemSourcesOut);
485: ame_engine.getRuleIndexes(ruleIndexesOut => ruleIndexesOut);
486: ame_engine.getSourceTypes(sourceTypesOut => sourceTypesOut);
487: ame_engine.getRuleDescriptions(ruleDescriptionsOut => ruleDescriptionsOut);
488: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
489: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
490: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
491: approvalProcessCompleteYNOut := ame_util.booleanTrue;
492: else

Line 489: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved

485: ame_engine.getRuleIndexes(ruleIndexesOut => ruleIndexesOut);
486: ame_engine.getSourceTypes(sourceTypesOut => sourceTypesOut);
487: ame_engine.getRuleDescriptions(ruleDescriptionsOut => ruleDescriptionsOut);
488: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
489: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
490: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
491: approvalProcessCompleteYNOut := ame_util.booleanTrue;
492: else
493: approvalProcessCompleteYNOut := ame_util.booleanFalse;

Line 490: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then

486: ame_engine.getSourceTypes(sourceTypesOut => sourceTypesOut);
487: ame_engine.getRuleDescriptions(ruleDescriptionsOut => ruleDescriptionsOut);
488: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
489: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
490: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
491: approvalProcessCompleteYNOut := ame_util.booleanTrue;
492: else
493: approvalProcessCompleteYNOut := ame_util.booleanFalse;
494: end if;

Line 496: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;

492: else
493: approvalProcessCompleteYNOut := ame_util.booleanFalse;
494: end if;
495: else
496: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
497: end if;
498: exception
499: when others then
500: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;

Line 500: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;

496: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
497: end if;
498: exception
499: when others then
500: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
501: ame_util.runtimeException(packageNameIn => 'ame_api2',
502: routineNameIn => 'getAllApprovers5',
503: exceptionNumberIn => sqlcode,
504: exceptionStringIn => sqlerrm);

Line 554: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then

550: ame_engine.getRuleIndexes(ruleIndexesOut => ruleIndexesOut);
551: ame_engine.getSourceTypes(sourceTypesOut => sourceTypesOut);
552: ame_engine.getRuleIds(ruleIdsOut => ruleIdsOut);
553: ame_engine.getRuleDescriptions(ruleDescriptionsOut => ruleDescriptionsOut);
554: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
555: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
556: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
557: approvalProcessCompleteYNOut := ame_util.booleanTrue;
558: else

Line 555: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved

551: ame_engine.getSourceTypes(sourceTypesOut => sourceTypesOut);
552: ame_engine.getRuleIds(ruleIdsOut => ruleIdsOut);
553: ame_engine.getRuleDescriptions(ruleDescriptionsOut => ruleDescriptionsOut);
554: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
555: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
556: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
557: approvalProcessCompleteYNOut := ame_util.booleanTrue;
558: else
559: approvalProcessCompleteYNOut := ame_util.booleanFalse;

Line 556: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then

552: ame_engine.getRuleIds(ruleIdsOut => ruleIdsOut);
553: ame_engine.getRuleDescriptions(ruleDescriptionsOut => ruleDescriptionsOut);
554: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
555: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
556: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
557: approvalProcessCompleteYNOut := ame_util.booleanTrue;
558: else
559: approvalProcessCompleteYNOut := ame_util.booleanFalse;
560: end if;

Line 562: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;

558: else
559: approvalProcessCompleteYNOut := ame_util.booleanFalse;
560: end if;
561: else
562: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
563: end if;
564: exception
565: when others then
566: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;

Line 566: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;

562: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
563: end if;
564: exception
565: when others then
566: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
567: ame_util.runtimeException(packageNameIn => 'ame_api2',
568: routineNameIn => 'getAllApprovers6',
569: exceptionNumberIn => sqlcode,
570: exceptionStringIn => sqlerrm);

Line 604: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then

600: fndApplicationIdIn => applicationIdIn,
601: transactionTypeIdIn => transactionTypeIn );
602: approvalProcessCompleteYNOut := ame_engine.getApprovalProcessCompleteYN;
603: ame_engine.getApprovers(approversOut => approversOut);
604: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
605: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
606: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
607: approvalProcessCompleteYNOut := ame_util.booleanTrue;
608: else

Line 605: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved

601: transactionTypeIdIn => transactionTypeIn );
602: approvalProcessCompleteYNOut := ame_engine.getApprovalProcessCompleteYN;
603: ame_engine.getApprovers(approversOut => approversOut);
604: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
605: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
606: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
607: approvalProcessCompleteYNOut := ame_util.booleanTrue;
608: else
609: approvalProcessCompleteYNOut := ame_util.booleanFalse;

Line 606: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then

602: approvalProcessCompleteYNOut := ame_engine.getApprovalProcessCompleteYN;
603: ame_engine.getApprovers(approversOut => approversOut);
604: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
605: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
606: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
607: approvalProcessCompleteYNOut := ame_util.booleanTrue;
608: else
609: approvalProcessCompleteYNOut := ame_util.booleanFalse;
610: end if;

Line 612: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;

608: else
609: approvalProcessCompleteYNOut := ame_util.booleanFalse;
610: end if;
611: else
612: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
613: end if;
614: exception
615: when others then
616: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;

Line 616: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;

612: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
613: end if;
614: exception
615: when others then
616: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
617: ame_util.runtimeException(packageNameIn => 'ame_api2',
618: routineNameIn => 'getAllApprovers7',
619: exceptionNumberIn => sqlcode,
620: exceptionStringIn => sqlerrm);

Line 698: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then

694: ame_util.copyApproverRecord2(approverRecord2In => approvers(i),
695: approverRecord2Out => approversOut(approverCount) );
696: end if;
697: end loop;
698: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
699: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
700: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
701: approvalProcessCompleteYNOut := ame_util.booleanTrue;
702: else

Line 699: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved

695: approverRecord2Out => approversOut(approverCount) );
696: end if;
697: end loop;
698: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
699: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
700: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
701: approvalProcessCompleteYNOut := ame_util.booleanTrue;
702: else
703: approvalProcessCompleteYNOut := ame_util.booleanFalse;

Line 700: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then

696: end if;
697: end loop;
698: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
699: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
700: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
701: approvalProcessCompleteYNOut := ame_util.booleanTrue;
702: else
703: approvalProcessCompleteYNOut := ame_util.booleanFalse;
704: end if;

Line 706: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;

702: else
703: approvalProcessCompleteYNOut := ame_util.booleanFalse;
704: end if;
705: else
706: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
707: end if;
708: exception
709: when invalidItemClassIdException then
710: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;

Line 710: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;

706: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
707: end if;
708: exception
709: when invalidItemClassIdException then
710: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
711: errorCode := -20311;
712: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
713: messageNameIn => 'AME_400419_INVALID_IC') ;
714: ame_util.runtimeException(packageNameIn => 'ame_api2',

Line 722: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;

718: approvalProcessCompleteYNOut := null;
719: raise_application_error(errorCode,
720: errorMessage);
721: when invalidItemException then
722: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
723: errorCode := -20312;
724: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
725: messageNameIn => 'AME_400420_INVALID_ITEM_ID') ;
726: ame_util.runtimeException(packageNameIn => 'ame_api2',

Line 734: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;

730: approvalProcessCompleteYNOut := null;
731: raise_application_error(errorCode,
732: errorMessage);
733: when others then
734: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
735: ame_util.runtimeException(packageNameIn => 'ame_api2',
736: routineNameIn => 'getAllItemApprovers1',
737: exceptionNumberIn => sqlcode,
738: exceptionStringIn => sqlerrm);

Line 808: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then

804: ame_util.copyApproverRecord2(approverRecord2In => approvers(i),
805: approverRecord2Out => approversOut(approverCount) );
806: end if;
807: end loop;
808: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
809: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
810: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
811: approvalProcessCompleteYNOut := ame_util.booleanTrue;
812: else

Line 809: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved

805: approverRecord2Out => approversOut(approverCount) );
806: end if;
807: end loop;
808: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
809: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
810: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
811: approvalProcessCompleteYNOut := ame_util.booleanTrue;
812: else
813: approvalProcessCompleteYNOut := ame_util.booleanFalse;

Line 810: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then

806: end if;
807: end loop;
808: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
809: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
810: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
811: approvalProcessCompleteYNOut := ame_util.booleanTrue;
812: else
813: approvalProcessCompleteYNOut := ame_util.booleanFalse;
814: end if;

Line 816: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;

812: else
813: approvalProcessCompleteYNOut := ame_util.booleanFalse;
814: end if;
815: else
816: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
817: end if;
818: exception
819: when invalidItemException then
820: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;

Line 820: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;

816: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
817: end if;
818: exception
819: when invalidItemException then
820: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
821: errorCode := -20312;
822: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
823: messageNameIn => 'AME_400420_INVALID_ITEM_ID') ;
824: ame_util.runtimeException(packageNameIn => 'ame_api2',

Line 832: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;

828: approvalProcessCompleteYNOut := null;
829: raise_application_error(errorCode,
830: errorMessage);
831: when others then
832: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
833: ame_util.runtimeException(packageNameIn => 'ame_api2',
834: routineNameIn => 'getAllItemApprovers2',
835: exceptionNumberIn => sqlcode,
836: exceptionStringIn => sqlerrm);

Line 884: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then

880: ame_engine.getItemSources(itemSourcesOut => itemSourcesOut);
881: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,
882: transactionIdIn => transactionIdIn,
883: transactionTypeIdIn => transactionTypeIn);
884: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
885: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
886: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
887: approvalProcessCompleteYNOut := ame_util.booleanTrue;
888: else

Line 885: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved

881: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,
882: transactionIdIn => transactionIdIn,
883: transactionTypeIdIn => transactionTypeIn);
884: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
885: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
886: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
887: approvalProcessCompleteYNOut := ame_util.booleanTrue;
888: else
889: approvalProcessCompleteYNOut := ame_util.booleanFalse;

Line 886: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then

882: transactionIdIn => transactionIdIn,
883: transactionTypeIdIn => transactionTypeIn);
884: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
885: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
886: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
887: approvalProcessCompleteYNOut := ame_util.booleanTrue;
888: else
889: approvalProcessCompleteYNOut := ame_util.booleanFalse;
890: end if;

Line 892: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;

888: else
889: approvalProcessCompleteYNOut := ame_util.booleanFalse;
890: end if;
891: else
892: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
893: end if;
894: exception
895: when others then
896: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;

Line 896: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;

892: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
893: end if;
894: exception
895: when others then
896: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
897: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,
898: transactionIdIn => transactionIdIn,
899: transactionTypeIdIn => transactionTypeIn);
900: ame_util.runtimeException(packageNameIn => 'ame_api2',

Line 966: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then

962: end loop;
963: if approvalProcessCompleteYNOut is null then
964: raise invalidItemException;
965: end if;
966: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
967: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
968: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
969: approvalProcessCompleteYNOut := ame_util.booleanTrue;
970: else

Line 967: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved

963: if approvalProcessCompleteYNOut is null then
964: raise invalidItemException;
965: end if;
966: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
967: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
968: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
969: approvalProcessCompleteYNOut := ame_util.booleanTrue;
970: else
971: approvalProcessCompleteYNOut := ame_util.booleanFalse;

Line 968: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then

964: raise invalidItemException;
965: end if;
966: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
967: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
968: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
969: approvalProcessCompleteYNOut := ame_util.booleanTrue;
970: else
971: approvalProcessCompleteYNOut := ame_util.booleanFalse;
972: end if;

Line 974: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;

970: else
971: approvalProcessCompleteYNOut := ame_util.booleanFalse;
972: end if;
973: else
974: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
975: end if;
976: exception
977: when invalidItemClassIdException then
978: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;

Line 978: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;

974: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
975: end if;
976: exception
977: when invalidItemClassIdException then
978: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
979: errorCode := -20311;
980: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
981: messageNameIn => 'AME_400419_INVALID_IC') ;
982: ame_util.runtimeException(packageNameIn => 'ame_api2',

Line 990: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;

986: approvalProcessCompleteYNOut := null;
987: raise_application_error(errorCode,
988: errorMessage);
989: when invalidItemException then
990: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
991: errorCode := -20312;
992: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
993: messageNameIn => 'AME_400420_INVALID_ITEM_ID') ;
994: ame_util.runtimeException(packageNameIn => 'ame_api2',

Line 1002: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;

998: approvalProcessCompleteYNOut := null;
999: raise_application_error(errorCode,
1000: errorMessage);
1001: when others then
1002: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
1003: ame_util.runtimeException(packageNameIn => 'ame_api2',
1004: routineNameIn => 'getItemStatus1',
1005: exceptionNumberIn => sqlcode,
1006: exceptionStringIn => sqlerrm);

Line 1061: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then

1057: end loop;
1058: if approvalProcessCompleteYNOut is null then
1059: raise invalidItemException;
1060: end if;
1061: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
1062: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
1063: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
1064: approvalProcessCompleteYNOut := ame_util.booleanTrue;
1065: else

Line 1062: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved

1058: if approvalProcessCompleteYNOut is null then
1059: raise invalidItemException;
1060: end if;
1061: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
1062: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
1063: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
1064: approvalProcessCompleteYNOut := ame_util.booleanTrue;
1065: else
1066: approvalProcessCompleteYNOut := ame_util.booleanFalse;

Line 1063: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then

1059: raise invalidItemException;
1060: end if;
1061: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
1062: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
1063: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
1064: approvalProcessCompleteYNOut := ame_util.booleanTrue;
1065: else
1066: approvalProcessCompleteYNOut := ame_util.booleanFalse;
1067: end if;

Line 1069: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;

1065: else
1066: approvalProcessCompleteYNOut := ame_util.booleanFalse;
1067: end if;
1068: else
1069: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
1070: end if;
1071: exception
1072: when invalidItemClassIdException then
1073: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;

Line 1073: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;

1069: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
1070: end if;
1071: exception
1072: when invalidItemClassIdException then
1073: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
1074: errorCode := -20311;
1075: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
1076: messageNameIn => 'AME_400419_INVALID_IC') ;
1077: ame_util.runtimeException(packageNameIn => 'ame_api2',

Line 1085: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;

1081: approvalProcessCompleteYNOut := null;
1082: raise_application_error(errorCode,
1083: errorMessage);
1084: when invalidItemException then
1085: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
1086: errorCode := -20312;
1087: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
1088: messageNameIn => 'AME_400420_INVALID_ITEM_ID') ;
1089: ame_util.runtimeException(packageNameIn => 'ame_api2',

Line 1097: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;

1093: approvalProcessCompleteYNOut := null;
1094: raise_application_error(errorCode,
1095: errorMessage);
1096: when others then
1097: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
1098: ame_util.runtimeException(packageNameIn => 'ame_api2',
1099: routineNameIn => 'getItemStatus2',
1100: exceptionNumberIn => sqlcode,
1101: exceptionStringIn => sqlerrm);

Line 1136: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then

1132: transactionTypeIdIn => transactionTypeIn );
1133: ame_engine.getAllItemIds(itemIdsOut => itemIdsOut);
1134: ame_engine.getAllItemClasses(itemClassNamesOut => itemClassNamesOut);
1135: ame_engine.getItemAppProcessCompleteYN(itemAppProcessCompleteYNOut => approvalProcessesCompleteYNOut);
1136: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
1137: for i in 1 .. approvalProcessesCompleteYNOut.count loop
1138: if approvalProcessesCompleteYNOut(i) = ame_util2.completeFullyApproved
1139: or approvalProcessesCompleteYNOut(i) = ame_util2.completeNoApprovers then
1140: approvalProcessesCompleteYNOut(i) := ame_util.booleanTrue;

Line 1138: if approvalProcessesCompleteYNOut(i) = ame_util2.completeFullyApproved

1134: ame_engine.getAllItemClasses(itemClassNamesOut => itemClassNamesOut);
1135: ame_engine.getItemAppProcessCompleteYN(itemAppProcessCompleteYNOut => approvalProcessesCompleteYNOut);
1136: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
1137: for i in 1 .. approvalProcessesCompleteYNOut.count loop
1138: if approvalProcessesCompleteYNOut(i) = ame_util2.completeFullyApproved
1139: or approvalProcessesCompleteYNOut(i) = ame_util2.completeNoApprovers then
1140: approvalProcessesCompleteYNOut(i) := ame_util.booleanTrue;
1141: else
1142: approvalProcessesCompleteYNOut(i) := ame_util.booleanFalse;

Line 1139: or approvalProcessesCompleteYNOut(i) = ame_util2.completeNoApprovers then

1135: ame_engine.getItemAppProcessCompleteYN(itemAppProcessCompleteYNOut => approvalProcessesCompleteYNOut);
1136: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
1137: for i in 1 .. approvalProcessesCompleteYNOut.count loop
1138: if approvalProcessesCompleteYNOut(i) = ame_util2.completeFullyApproved
1139: or approvalProcessesCompleteYNOut(i) = ame_util2.completeNoApprovers then
1140: approvalProcessesCompleteYNOut(i) := ame_util.booleanTrue;
1141: else
1142: approvalProcessesCompleteYNOut(i) := ame_util.booleanFalse;
1143: end if;

Line 1146: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;

1142: approvalProcessesCompleteYNOut(i) := ame_util.booleanFalse;
1143: end if;
1144: end loop;
1145: else
1146: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
1147: end if;
1148: exception
1149: when others then
1150: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;

Line 1150: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;

1146: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
1147: end if;
1148: exception
1149: when others then
1150: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
1151: ame_util.runtimeException(packageNameIn => 'ame_api2',
1152: routineNameIn => 'getItemStatuses',
1153: exceptionNumberIn => sqlcode,
1154: exceptionStringIn => sqlerrm);

Line 1190: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then

1186: ,variableNamesOut => dummyStringList
1187: ,variableValuesOut => dummyStringList
1188: ,transVariableNamesOut => dummyStringList
1189: ,transVariableValuesOut => dummyStringList);
1190: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
1191: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
1192: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
1193: approvalProcessCompleteYNOut := ame_util.booleanTrue;
1194: else

Line 1191: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved

1187: ,variableValuesOut => dummyStringList
1188: ,transVariableNamesOut => dummyStringList
1189: ,transVariableValuesOut => dummyStringList);
1190: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
1191: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
1192: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
1193: approvalProcessCompleteYNOut := ame_util.booleanTrue;
1194: else
1195: approvalProcessCompleteYNOut := ame_util.booleanFalse;

Line 1192: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then

1188: ,transVariableNamesOut => dummyStringList
1189: ,transVariableValuesOut => dummyStringList);
1190: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
1191: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
1192: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
1193: approvalProcessCompleteYNOut := ame_util.booleanTrue;
1194: else
1195: approvalProcessCompleteYNOut := ame_util.booleanFalse;
1196: end if;

Line 1198: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;

1194: else
1195: approvalProcessCompleteYNOut := ame_util.booleanFalse;
1196: end if;
1197: else
1198: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
1199: end if;
1200: exception
1201: when others then
1202: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;

Line 1202: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;

1198: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
1199: end if;
1200: exception
1201: when others then
1202: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
1203: ame_util.runtimeException(packageNameIn => 'ame_api2',
1204: routineNameIn => 'getNextApprovers1',
1205: exceptionNumberIn => sqlcode,
1206: exceptionStringIn => sqlerrm);

Line 1247: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then

1243: ,variableNamesOut => variableNamesOut
1244: ,variableValuesOut => variableValuesOut
1245: ,transVariableNamesOut => dummyStringList
1246: ,transVariableValuesOut => dummyStringList);
1247: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
1248: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
1249: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
1250: approvalProcessCompleteYNOut := ame_util.booleanTrue;
1251: else

Line 1248: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved

1244: ,variableValuesOut => variableValuesOut
1245: ,transVariableNamesOut => dummyStringList
1246: ,transVariableValuesOut => dummyStringList);
1247: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
1248: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
1249: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
1250: approvalProcessCompleteYNOut := ame_util.booleanTrue;
1251: else
1252: approvalProcessCompleteYNOut := ame_util.booleanFalse;

Line 1249: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then

1245: ,transVariableNamesOut => dummyStringList
1246: ,transVariableValuesOut => dummyStringList);
1247: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
1248: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
1249: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
1250: approvalProcessCompleteYNOut := ame_util.booleanTrue;
1251: else
1252: approvalProcessCompleteYNOut := ame_util.booleanFalse;
1253: end if;

Line 1255: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;

1251: else
1252: approvalProcessCompleteYNOut := ame_util.booleanFalse;
1253: end if;
1254: else
1255: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
1256: end if;
1257: exception
1258: when others then
1259: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;

Line 1259: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;

1255: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
1256: end if;
1257: exception
1258: when others then
1259: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
1260: ame_util.runtimeException(packageNameIn => 'ame_api2',
1261: routineNameIn => 'getNextApprovers2',
1262: exceptionNumberIn => sqlcode,
1263: exceptionStringIn => sqlerrm);

Line 1308: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then

1304: ,variableNamesOut => variableNamesOut
1305: ,variableValuesOut => variableValuesOut
1306: ,transVariableNamesOut => transVariableNamesOut
1307: ,transVariableValuesOut => transVariableValuesOut);
1308: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
1309: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
1310: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
1311: approvalProcessCompleteYNOut := ame_util.booleanTrue;
1312: else

Line 1309: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved

1305: ,variableValuesOut => variableValuesOut
1306: ,transVariableNamesOut => transVariableNamesOut
1307: ,transVariableValuesOut => transVariableValuesOut);
1308: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
1309: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
1310: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
1311: approvalProcessCompleteYNOut := ame_util.booleanTrue;
1312: else
1313: approvalProcessCompleteYNOut := ame_util.booleanFalse;

Line 1310: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then

1306: ,transVariableNamesOut => transVariableNamesOut
1307: ,transVariableValuesOut => transVariableValuesOut);
1308: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
1309: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
1310: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
1311: approvalProcessCompleteYNOut := ame_util.booleanTrue;
1312: else
1313: approvalProcessCompleteYNOut := ame_util.booleanFalse;
1314: end if;

Line 1316: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;

1312: else
1313: approvalProcessCompleteYNOut := ame_util.booleanFalse;
1314: end if;
1315: else
1316: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
1317: end if;
1318: exception
1319: when others then
1320: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;

Line 1320: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;

1316: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
1317: end if;
1318: exception
1319: when others then
1320: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
1321: ame_util.runtimeException(packageNameIn => 'ame_api2',
1322: routineNameIn => 'getNextApprovers3',
1323: exceptionNumberIn => sqlcode,
1324: exceptionStringIn => sqlerrm);

Line 1365: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then

1361: ,variableNamesOut => dummyStringList
1362: ,variableValuesOut => dummyStringList
1363: ,transVariableNamesOut => dummyStringList
1364: ,transVariableValuesOut => dummyStringList);
1365: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
1366: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
1367: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
1368: approvalProcessCompleteYNOut := ame_util.booleanTrue;
1369: else

Line 1366: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved

1362: ,variableValuesOut => dummyStringList
1363: ,transVariableNamesOut => dummyStringList
1364: ,transVariableValuesOut => dummyStringList);
1365: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
1366: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
1367: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
1368: approvalProcessCompleteYNOut := ame_util.booleanTrue;
1369: else
1370: approvalProcessCompleteYNOut := ame_util.booleanFalse;

Line 1367: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then

1363: ,transVariableNamesOut => dummyStringList
1364: ,transVariableValuesOut => dummyStringList);
1365: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
1366: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
1367: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
1368: approvalProcessCompleteYNOut := ame_util.booleanTrue;
1369: else
1370: approvalProcessCompleteYNOut := ame_util.booleanFalse;
1371: end if;

Line 1373: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;

1369: else
1370: approvalProcessCompleteYNOut := ame_util.booleanFalse;
1371: end if;
1372: else
1373: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
1374: end if;
1375: exception
1376: when others then
1377: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;

Line 1377: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;

1373: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
1374: end if;
1375: exception
1376: when others then
1377: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
1378: ame_util.runtimeException(packageNameIn => 'ame_api2',
1379: routineNameIn => 'getNextApprovers4',
1380: exceptionNumberIn => sqlcode,
1381: exceptionStringIn => sqlerrm);

Line 1426: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then

1422: ame_util.copyApproverRecord2(approverRecord2In => approvers(i),
1423: approverRecord2Out => approversOut(approverCount) );
1424: end if;
1425: end loop;
1426: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
1427: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
1428: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
1429: approvalProcessCompleteYNOut := ame_util.booleanTrue;
1430: else

Line 1427: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved

1423: approverRecord2Out => approversOut(approverCount) );
1424: end if;
1425: end loop;
1426: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
1427: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
1428: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
1429: approvalProcessCompleteYNOut := ame_util.booleanTrue;
1430: else
1431: approvalProcessCompleteYNOut := ame_util.booleanFalse;

Line 1428: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then

1424: end if;
1425: end loop;
1426: if ame_util2.detailedApprovalStatusFlagYN = ame_util.booleanFalse then
1427: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved
1428: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then
1429: approvalProcessCompleteYNOut := ame_util.booleanTrue;
1430: else
1431: approvalProcessCompleteYNOut := ame_util.booleanFalse;
1432: end if;

Line 1434: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;

1430: else
1431: approvalProcessCompleteYNOut := ame_util.booleanFalse;
1432: end if;
1433: else
1434: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
1435: end if;
1436: exception
1437: when others then
1438: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;

Line 1438: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;

1434: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
1435: end if;
1436: exception
1437: when others then
1438: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanFalse;
1439: ame_util.runtimeException(packageNameIn => 'ame_api2',
1440: routineNameIn => 'getPendingApprovers',
1441: exceptionNumberIn => sqlcode,
1442: exceptionStringIn => sqlerrm);

Line 1452: tempProductions ame_util2.productionsTable;

1448: transactionTypeIn in varchar2,
1449: transactionIdIn in varchar2,
1450: variableNamesOut out nocopy ame_util.stringList,
1451: variableValuesOut out nocopy ame_util.stringList) as
1452: tempProductions ame_util2.productionsTable;
1453: tempIndex integer;
1454: begin
1455: ame_engine.updateTransactionState(isTestTransactionIn => false,
1456: isLocalTransactionIn => false,