DBA Data[Home] [Help]

APPS.AME_API2 dependencies on AME_UTIL2

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

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

Line 186: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved

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;

Line 187: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then

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;

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

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;

Line 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);

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

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

Line 250: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved

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;

Line 251: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then

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;

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

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;

Line 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);

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

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

Line 318: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved

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;

Line 319: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then

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;

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

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;

Line 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);

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

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

Line 382: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved

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;

Line 383: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then

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;

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

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;

Line 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);

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

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

Line 446: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved

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;

Line 447: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then

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;

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

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;

Line 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);

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

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

Line 512: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved

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;

Line 513: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then

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;

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

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;

Line 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);

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

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

Line 562: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved

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;

Line 563: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then

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;

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

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;

Line 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);

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

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

Line 656: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved

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;

Line 657: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then

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;

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

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;

Line 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',

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

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',

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

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);

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

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

Line 766: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved

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;

Line 767: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then

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;

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

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;

Line 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',

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

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);

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

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

Line 842: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved

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;

Line 843: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then

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;

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

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;

Line 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',

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

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

Line 924: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved

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;

Line 925: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers 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;
929: end if;

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

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;

Line 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',

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

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',

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

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);

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

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

Line 1019: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved

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;

Line 1020: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers 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;
1024: end if;

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

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;

Line 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',

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

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',

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

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);

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

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;

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

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;

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

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;

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

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;

Line 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);

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

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

Line 1148: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved

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;

Line 1149: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then

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;

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

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;

Line 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);

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

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

Line 1205: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved

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;

Line 1206: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then

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;

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

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;

Line 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);

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

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

Line 1266: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved

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;

Line 1267: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then

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;

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

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;

Line 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);

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

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

Line 1323: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved

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;

Line 1324: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then

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;

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

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;

Line 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);

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

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

Line 1384: if approvalProcessCompleteYNOut = ame_util2.completeFullyApproved

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;

Line 1385: or approvalProcessCompleteYNOut = ame_util2.completeNoApprovers then

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;

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

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;

Line 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);

Line 1409: tempProductions ame_util2.productionsTable;

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,