eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AME_API3 dependencies on AME_UTIL

Line 4: ambiguousApproverMessage constant ame_util.longestStringType :=

1: package body ame_api3 as
2: /* $Header: ameeapi3.pkb 120.13 2007/12/12 12:41:39 prasashe noship $ */
3: ambiguousApproverException exception;
4: ambiguousApproverMessage constant ame_util.longestStringType :=
5: ame_util.getMessage(applicationShortNameIn =>'PER',
6: messageNameIn => 'AME_400812_NULL_APPR_REC_NAME');
7: /* functions */
8: function getRuleDescription(ruleIdIn in varchar2) return varchar2 as

Line 5: ame_util.getMessage(applicationShortNameIn =>'PER',

1: package body ame_api3 as
2: /* $Header: ameeapi3.pkb 120.13 2007/12/12 12:41:39 prasashe noship $ */
3: ambiguousApproverException exception;
4: ambiguousApproverMessage constant ame_util.longestStringType :=
5: ame_util.getMessage(applicationShortNameIn =>'PER',
6: messageNameIn => 'AME_400812_NULL_APPR_REC_NAME');
7: /* functions */
8: function getRuleDescription(ruleIdIn in varchar2) return varchar2 as
9: begin

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

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

Line 24: approverIn in ame_util.approverRecord2) as

20: /* procedures */
21: procedure clearInsertion(applicationIdIn in number,
22: transactionTypeIn in varchar2,
23: transactionIdIn in varchar2,
24: approverIn in ame_util.approverRecord2) as
25: ameAppId integer;
26: errorCode integer;
27: errorMessage ame_util.longStringType;
28: appr_rec_params varchar2(100);

Line 27: errorMessage ame_util.longStringType;

23: transactionIdIn in varchar2,
24: approverIn in ame_util.approverRecord2) as
25: ameAppId integer;
26: errorCode integer;
27: errorMessage ame_util.longStringType;
28: appr_rec_params varchar2(100);
29: cursor getAnchorInsertions (parameterIn varchar2) is
30: (select name
31: from ame_temp_insertions

Line 35: nameList ame_util.longStringList;

31: from ame_temp_insertions
32: where application_id = ame_engine.getAmeApplicationId
33: and transaction_id = transactionIdIn
34: and parameter = parameterIn);
35: nameList ame_util.longStringList;
36: anchorsExistException exception;
37: cmpParameter ame_temp_insertions.parameter%type;
38: anchorName varchar2(320);
39: anchorList varchar2(1000);

Line 40: approvers ame_util.approversTable2;

36: anchorsExistException exception;
37: cmpParameter ame_temp_insertions.parameter%type;
38: anchorName varchar2(320);
39: anchorList varchar2(1000);
40: approvers ame_util.approversTable2;
41: nullApprRecordFieldException Exception;
42: begin
43: ame_engine.lockTransaction(fndApplicationIdIn => applicationIdIn,
44: transactionIdIn => transactionIdIn,

Line 86: approvers(i).api_insertion = ame_util.apiInsertion then

82: for i in 1 .. approvers.count loop
83: if approvers(i).name = approverIn.name and
84: approvers(i).item_class = approverIn.item_class and
85: approvers(i).item_id = approverIn.item_id and
86: approvers(i).api_insertion = ame_util.apiInsertion then
87: anchorName := approvers(i).name;
88: cmpParameter := approvers(i).name ||
89: ame_util.fieldDelimiter ||
90: approvers(i).item_class ||

Line 89: ame_util.fieldDelimiter ||

85: approvers(i).item_id = approverIn.item_id and
86: approvers(i).api_insertion = ame_util.apiInsertion then
87: anchorName := approvers(i).name;
88: cmpParameter := approvers(i).name ||
89: ame_util.fieldDelimiter ||
90: approvers(i).item_class ||
91: ame_util.fieldDelimiter ||
92: approvers(i).item_id ||
93: ame_util.fieldDelimiter ||

Line 91: ame_util.fieldDelimiter ||

87: anchorName := approvers(i).name;
88: cmpParameter := approvers(i).name ||
89: ame_util.fieldDelimiter ||
90: approvers(i).item_class ||
91: ame_util.fieldDelimiter ||
92: approvers(i).item_id ||
93: ame_util.fieldDelimiter ||
94: approvers(i).action_type_id ||
95: ame_util.fieldDelimiter ||

Line 93: ame_util.fieldDelimiter ||

89: ame_util.fieldDelimiter ||
90: approvers(i).item_class ||
91: ame_util.fieldDelimiter ||
92: approvers(i).item_id ||
93: ame_util.fieldDelimiter ||
94: approvers(i).action_type_id ||
95: ame_util.fieldDelimiter ||
96: approvers(i).group_or_chain_id ||
97: ame_util.fieldDelimiter ||

Line 95: ame_util.fieldDelimiter ||

91: ame_util.fieldDelimiter ||
92: approvers(i).item_id ||
93: ame_util.fieldDelimiter ||
94: approvers(i).action_type_id ||
95: ame_util.fieldDelimiter ||
96: approvers(i).group_or_chain_id ||
97: ame_util.fieldDelimiter ||
98: approvers(i).occurrence;
99: open getAnchorInsertions(cmpParameter);

Line 97: ame_util.fieldDelimiter ||

93: ame_util.fieldDelimiter ||
94: approvers(i).action_type_id ||
95: ame_util.fieldDelimiter ||
96: approvers(i).group_or_chain_id ||
97: ame_util.fieldDelimiter ||
98: approvers(i).occurrence;
99: open getAnchorInsertions(cmpParameter);
100: fetch getAnchorInsertions bulk collect into nameList;
101: if nameList.count > 0 then

Line 143: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',

139: anchorList := anchorList || '; ';
140: end if;
141: end loop;
142: errorCode := -20001;
143: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
144: messageNameIn => 'AME_400651_ANCHORS_EXIST',
145: tokenNameOneIn => 'APPROVER',
146: tokenValueOneIn => ame_approver_type_pkg.getApproverDescription(anchorName),
147: tokenNameTwoIn => 'ANCHORED_APPROVERS',

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

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

Line 160: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',

156: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,
157: transactionIdIn => transactionIdIn,
158: transactionTypeIdIn => transactionTypeIn);
159: errorCode := -20001;
160: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
161: messageNameIn => 'AME_400813_NULL_CLINS_APPR_FLD',
162: tokenNameOneIn => 'APPROVER_REC_PARAMS',
163: tokenValueOneIn => appr_rec_params);
164: ame_util.runtimeException(packageNameIn => 'ame_api3',

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

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

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

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

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

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

Line 236: approverIn in ame_util.approverRecord2) as

232: end clearInsertions;
233: procedure clearSuppression(applicationIdIn in number,
234: transactionTypeIn in varchar2,
235: transactionIdIn in varchar2,
236: approverIn in ame_util.approverRecord2) as
237: ameAppId integer;
238: errorCode integer;
239: errorMessage ame_util.longStringType;
240: appr_rec_params varchar2(100);

Line 239: errorMessage ame_util.longStringType;

235: transactionIdIn in varchar2,
236: approverIn in ame_util.approverRecord2) as
237: ameAppId integer;
238: errorCode integer;
239: errorMessage ame_util.longStringType;
240: appr_rec_params varchar2(100);
241: nullApprRecordFieldException Exception;
242: begin
243: ame_engine.lockTransaction(fndApplicationIdIn => applicationIdIn,

Line 313: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',

309: when nullApprRecordFieldException then
310: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,
311: transactionIdIn => transactionIdIn,
312: transactionTypeIdIn => transactionTypeIn);
313: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
314: messageNameIn => 'AME_400814_NULL_SUPPR_APPR_FLD',
315: tokenNameOneIn => 'APPROVER_REC_PARAMS',
316: tokenvalueOneIn=>appr_rec_params);
317: errorCode := -20001;

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

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

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

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

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

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

Line 387: procedure getAllApprovalGroups(groupIdsOut out nocopy ame_util.idList,

383: exceptionNumberIn => sqlcode,
384: exceptionStringIn => sqlerrm);
385: raise;
386: end clearSuppressions;
387: procedure getAllApprovalGroups(groupIdsOut out nocopy ame_util.idList,
388: groupNamesOut out nocopy ame_util.stringList) as
389: cursor fetchGroupsCursor is
390: select approval_group_id, name
391: from ame_approval_groups

Line 388: groupNamesOut out nocopy ame_util.stringList) as

384: exceptionStringIn => sqlerrm);
385: raise;
386: end clearSuppressions;
387: procedure getAllApprovalGroups(groupIdsOut out nocopy ame_util.idList,
388: groupNamesOut out nocopy ame_util.stringList) as
389: cursor fetchGroupsCursor is
390: select approval_group_id, name
391: from ame_approval_groups
392: where end_date is null

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

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

Line 412: ruleIdsOut out nocopy ame_util.idList) as

408: end getAllApprovalGroups;
409: procedure getApplicableRules1(applicationIdIn in integer,
410: transactionIdIn in varchar2,
411: transactionTypeIn in varchar2,
412: ruleIdsOut out nocopy ame_util.idList) as
413: ruleDescriptions ame_util.stringList;
414: productionFunctionality ame_util.stringType;
415: processProductionRules boolean;
416: begin

Line 413: ruleDescriptions ame_util.stringList;

409: procedure getApplicableRules1(applicationIdIn in integer,
410: transactionIdIn in varchar2,
411: transactionTypeIn in varchar2,
412: ruleIdsOut out nocopy ame_util.idList) as
413: ruleDescriptions ame_util.stringList;
414: productionFunctionality ame_util.stringType;
415: processProductionRules boolean;
416: begin
417: productionFunctionality := ame_util.getConfigVar

Line 414: productionFunctionality ame_util.stringType;

410: transactionIdIn in varchar2,
411: transactionTypeIn in varchar2,
412: ruleIdsOut out nocopy ame_util.idList) as
413: ruleDescriptions ame_util.stringList;
414: productionFunctionality ame_util.stringType;
415: processProductionRules boolean;
416: begin
417: productionFunctionality := ame_util.getConfigVar
418: (variableNameIn => ame_util.productionConfigVar

Line 417: productionFunctionality := ame_util.getConfigVar

413: ruleDescriptions ame_util.stringList;
414: productionFunctionality ame_util.stringType;
415: processProductionRules boolean;
416: begin
417: productionFunctionality := ame_util.getConfigVar
418: (variableNameIn => ame_util.productionConfigVar
419: ,applicationIdIn => ame_admin_pkg.getApplicationId
420: (fndAppIdIn => applicationIdIn
421: ,transactionTypeIdIn => transactionTypeIn

Line 418: (variableNameIn => ame_util.productionConfigVar

414: productionFunctionality ame_util.stringType;
415: processProductionRules boolean;
416: begin
417: productionFunctionality := ame_util.getConfigVar
418: (variableNameIn => ame_util.productionConfigVar
419: ,applicationIdIn => ame_admin_pkg.getApplicationId
420: (fndAppIdIn => applicationIdIn
421: ,transactionTypeIdIn => transactionTypeIn
422: )

Line 424: if productionFunctionality in (ame_util.noProductions, ame_util.perApproverProductions) then

420: (fndAppIdIn => applicationIdIn
421: ,transactionTypeIdIn => transactionTypeIn
422: )
423: );
424: if productionFunctionality in (ame_util.noProductions, ame_util.perApproverProductions) then
425: processProductionRules := false;
426: else
427: processProductionRules := true;
428: end if;

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

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

Line 463: ruleDescriptionsOut out nocopy ame_util.stringList) as

459: end getApplicableRules1;
460: procedure getApplicableRules2(applicationIdIn in integer,
461: transactionIdIn in varchar2,
462: transactionTypeIn in varchar2,
463: ruleDescriptionsOut out nocopy ame_util.stringList) as
464: ruleIds ame_util.idList;
465: productionFunctionality ame_util.stringType;
466: processProductionRules boolean;
467: begin

Line 464: ruleIds ame_util.idList;

460: procedure getApplicableRules2(applicationIdIn in integer,
461: transactionIdIn in varchar2,
462: transactionTypeIn in varchar2,
463: ruleDescriptionsOut out nocopy ame_util.stringList) as
464: ruleIds ame_util.idList;
465: productionFunctionality ame_util.stringType;
466: processProductionRules boolean;
467: begin
468: productionFunctionality := ame_util.getConfigVar

Line 465: productionFunctionality ame_util.stringType;

461: transactionIdIn in varchar2,
462: transactionTypeIn in varchar2,
463: ruleDescriptionsOut out nocopy ame_util.stringList) as
464: ruleIds ame_util.idList;
465: productionFunctionality ame_util.stringType;
466: processProductionRules boolean;
467: begin
468: productionFunctionality := ame_util.getConfigVar
469: (variableNameIn => ame_util.productionConfigVar

Line 468: productionFunctionality := ame_util.getConfigVar

464: ruleIds ame_util.idList;
465: productionFunctionality ame_util.stringType;
466: processProductionRules boolean;
467: begin
468: productionFunctionality := ame_util.getConfigVar
469: (variableNameIn => ame_util.productionConfigVar
470: ,applicationIdIn => ame_admin_pkg.getApplicationId
471: (fndAppIdIn => applicationIdIn
472: ,transactionTypeIdIn => transactionTypeIn

Line 469: (variableNameIn => ame_util.productionConfigVar

465: productionFunctionality ame_util.stringType;
466: processProductionRules boolean;
467: begin
468: productionFunctionality := ame_util.getConfigVar
469: (variableNameIn => ame_util.productionConfigVar
470: ,applicationIdIn => ame_admin_pkg.getApplicationId
471: (fndAppIdIn => applicationIdIn
472: ,transactionTypeIdIn => transactionTypeIn
473: )

Line 475: if productionFunctionality in (ame_util.noProductions, ame_util.perApproverProductions) then

471: (fndAppIdIn => applicationIdIn
472: ,transactionTypeIdIn => transactionTypeIn
473: )
474: );
475: if productionFunctionality in (ame_util.noProductions, ame_util.perApproverProductions) then
476: processProductionRules := false;
477: else
478: processProductionRules := true;
479: end if;

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

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

Line 514: ruleIdsOut out nocopy ame_util.idList,

510: end getApplicableRules2;
511: procedure getApplicableRules3(applicationIdIn in integer,
512: transactionIdIn in varchar2,
513: transactionTypeIn in varchar2,
514: ruleIdsOut out nocopy ame_util.idList,
515: ruleDescriptionsOut out nocopy ame_util.stringList) as
516: productionFunctionality ame_util.stringType;
517: processProductionRules boolean;
518: begin

Line 515: ruleDescriptionsOut out nocopy ame_util.stringList) as

511: procedure getApplicableRules3(applicationIdIn in integer,
512: transactionIdIn in varchar2,
513: transactionTypeIn in varchar2,
514: ruleIdsOut out nocopy ame_util.idList,
515: ruleDescriptionsOut out nocopy ame_util.stringList) as
516: productionFunctionality ame_util.stringType;
517: processProductionRules boolean;
518: begin
519: productionFunctionality := ame_util.getConfigVar

Line 516: productionFunctionality ame_util.stringType;

512: transactionIdIn in varchar2,
513: transactionTypeIn in varchar2,
514: ruleIdsOut out nocopy ame_util.idList,
515: ruleDescriptionsOut out nocopy ame_util.stringList) as
516: productionFunctionality ame_util.stringType;
517: processProductionRules boolean;
518: begin
519: productionFunctionality := ame_util.getConfigVar
520: (variableNameIn => ame_util.productionConfigVar

Line 519: productionFunctionality := ame_util.getConfigVar

515: ruleDescriptionsOut out nocopy ame_util.stringList) as
516: productionFunctionality ame_util.stringType;
517: processProductionRules boolean;
518: begin
519: productionFunctionality := ame_util.getConfigVar
520: (variableNameIn => ame_util.productionConfigVar
521: ,applicationIdIn => ame_admin_pkg.getApplicationId
522: (fndAppIdIn => applicationIdIn
523: ,transactionTypeIdIn => transactionTypeIn

Line 520: (variableNameIn => ame_util.productionConfigVar

516: productionFunctionality ame_util.stringType;
517: processProductionRules boolean;
518: begin
519: productionFunctionality := ame_util.getConfigVar
520: (variableNameIn => ame_util.productionConfigVar
521: ,applicationIdIn => ame_admin_pkg.getApplicationId
522: (fndAppIdIn => applicationIdIn
523: ,transactionTypeIdIn => transactionTypeIn
524: )

Line 526: if productionFunctionality in (ame_util.noProductions, ame_util.perApproverProductions) then

522: (fndAppIdIn => applicationIdIn
523: ,transactionTypeIdIn => transactionTypeIn
524: )
525: );
526: if productionFunctionality in (ame_util.noProductions, ame_util.perApproverProductions) then
527: processProductionRules := false;
528: else
529: processProductionRules := true;
530: end if;

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

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

Line 562: procedure getApprovalGroupId(groupNameIn ame_util.stringType,

558: exceptionNumberIn => sqlcode,
559: exceptionStringIn => sqlerrm);
560: raise;
561: end getApplicableRules3;
562: procedure getApprovalGroupId(groupNameIn ame_util.stringType,
563: groupIdOut out nocopy number) as
564: errorCode integer;
565: errorMessage ame_util.longestStringType;
566: begin

Line 565: errorMessage ame_util.longestStringType;

561: end getApplicableRules3;
562: procedure getApprovalGroupId(groupNameIn ame_util.stringType,
563: groupIdOut out nocopy number) as
564: errorCode integer;
565: errorMessage ame_util.longestStringType;
566: begin
567: select approval_group_id
568: into groupIdOut
569: from ame_approval_groups

Line 575: errorMessage := ame_util.getMessage(

571: and end_date is null;
572: exception
573: when no_data_found then
574: errorCode := -20001;
575: errorMessage := ame_util.getMessage(
576: applicationShortNameIn => 'PER',
577: messageNameIn => 'AME_400453_GROUP_NOT_DEFINED',
578: tokenNameOneIn => 'APPROVAL_GROUP',
579: tokenValueOneIn => groupNameIn);

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

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

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

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

Line 601: itemId ame_util.stringType;

597: itemIdIn in varchar2,
598: attributeValue1Out out nocopy varchar2,
599: attributeValue2Out out nocopy varchar2,
600: attributeValue3Out out nocopy varchar2) as
601: itemId ame_util.stringType;
602: begin
603: ame_engine.updateTransactionState(isTestTransactionIn => false,
604: isLocalTransactionIn => false,
605: fetchConfigVarsIn => false,

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

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

Line 646: Chain-of-authority insertees (those having authority = ame_util.authorityApprover and

642: end getAttributeValue;
643: /*
644: getAvailableInsertions limits its output to insertions available for the order type orderTypeIn,
645: if this is null; otherwise getAvailableInsertions outputs insertions available for all order types.
646: Chain-of-authority insertees (those having authority = ame_util.authorityApprover and
647: api_insertion = ame_util.apiAuthorityInsertion) must have the approver_category value
648: ame_util.approvalApproverCategory. Ad-hoc insertees may be of either approver category.
649: */
650: procedure getAvailableInsertions(applicationIdIn in number,

Line 647: api_insertion = ame_util.apiAuthorityInsertion) must have the approver_category value

643: /*
644: getAvailableInsertions limits its output to insertions available for the order type orderTypeIn,
645: if this is null; otherwise getAvailableInsertions outputs insertions available for all order types.
646: Chain-of-authority insertees (those having authority = ame_util.authorityApprover and
647: api_insertion = ame_util.apiAuthorityInsertion) must have the approver_category value
648: ame_util.approvalApproverCategory. Ad-hoc insertees may be of either approver category.
649: */
650: procedure getAvailableInsertions(applicationIdIn in number,
651: transactionTypeIn in varchar2,

Line 648: ame_util.approvalApproverCategory. Ad-hoc insertees may be of either approver category.

644: getAvailableInsertions limits its output to insertions available for the order type orderTypeIn,
645: if this is null; otherwise getAvailableInsertions outputs insertions available for all order types.
646: Chain-of-authority insertees (those having authority = ame_util.authorityApprover and
647: api_insertion = ame_util.apiAuthorityInsertion) must have the approver_category value
648: ame_util.approvalApproverCategory. Ad-hoc insertees may be of either approver category.
649: */
650: procedure getAvailableInsertions(applicationIdIn in number,
651: transactionTypeIn in varchar2,
652: transactionIdIn in varchar2,

Line 655: availableInsertionsOut out nocopy ame_util.insertionsTable2) as

651: transactionTypeIn in varchar2,
652: transactionIdIn in varchar2,
653: positionIn in number,
654: orderTypeIn in varchar2 default null,
655: availableInsertionsOut out nocopy ame_util.insertionsTable2) as
656: begin
657: ame_engine.updateTransactionState(isTestTransactionIn => false,
658: isLocalTransactionIn => false,
659: fetchConfigVarsIn => true,

Line 680: ,coaInsertionsYNIn => ame_util.booleanTrue

676: transactionTypeIdIn => transactionTypeIn );
677:
678: ame_engine.getInsertions
679: (positionIn => positionIn
680: ,coaInsertionsYNIn => ame_util.booleanTrue
681: ,orderTypeIn => orderTypeIn
682: ,availableInsertionsOut => availableInsertionsOut
683: );
684: exception

Line 686: ame_util.runtimeException

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

Line 703: allowedValuesOut out nocopy ame_util.longestStringList) as

699: upperLimitOut out nocopy varchar2,
700: includeLowerLimitOut out nocopy varchar2,
701: includeUpperLimitOut out nocopy varchar2,
702: currencyCodeOut out nocopy varchar2,
703: allowedValuesOut out nocopy ame_util.longestStringList) as
704: begin
705: select
706: ame_attributes.name,
707: ame_attributes.attribute_type,

Line 731: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and

727: ame_attributes.attribute_id = ame_conditions.attribute_id and
728: ame_conditions.condition_id = conditionIdIn and
729: sysdate between
730: ame_attributes.start_date and
731: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
732: sysdate between
733: ame_conditions.start_date and
734: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate);
735: if(attributeTypeOut = ame_util.stringAttributeType) then

Line 734: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate);

730: ame_attributes.start_date and
731: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
732: sysdate between
733: ame_conditions.start_date and
734: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate);
735: if(attributeTypeOut = ame_util.stringAttributeType) then
736: ame_condition_pkg.getStringValueList(conditionIdIn => conditionIdIn,
737: stringValueListOut => allowedValuesOut);
738: end if;

Line 735: if(attributeTypeOut = ame_util.stringAttributeType) then

731: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
732: sysdate between
733: ame_conditions.start_date and
734: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate);
735: if(attributeTypeOut = ame_util.stringAttributeType) then
736: ame_condition_pkg.getStringValueList(conditionIdIn => conditionIdIn,
737: stringValueListOut => allowedValuesOut);
738: end if;
739: exception

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

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

Line 751: memberDisplayNamesOut out nocopy ame_util.longStringList)as

747: procedure getGroupMembers1(applicationIdIn in number default null,
748: transactionTypeIn in varchar2 default null,
749: transactionIdIn in varchar2 default null,
750: groupIdIn in number,
751: memberDisplayNamesOut out nocopy ame_util.longStringList)as
752: cursor groupMemberCursor(groupIdIn in integer) is
753: select
754: parameter,
755: upper(parameter_name),

Line 758: ame_util.approverOamGroupId, null,

754: parameter,
755: upper(parameter_name),
756: query_string,
757: decode(parameter_name,
758: ame_util.approverOamGroupId, null,
759: ame_approver_type_pkg.getApproverDisplayName2(orig_system, orig_system_id)) display_name
760: from ame_approval_group_members
761: where
762: approval_group_id = groupIdIn

Line 769: displayNames ame_util.longStringList;

765: noItemBindException exception;
766: dynamicCursor integer;
767: colonLocation1 integer;
768: colonLocation2 integer;
769: displayNames ame_util.longStringList;
770: errorCode integer;
771: errorMessage ame_util.longestStringType;
772: noTransIdDefinedException exception;
773: orderNumbers ame_util.idList;

Line 771: errorMessage ame_util.longestStringType;

767: colonLocation1 integer;
768: colonLocation2 integer;
769: displayNames ame_util.longStringList;
770: errorCode integer;
771: errorMessage ame_util.longestStringType;
772: noTransIdDefinedException exception;
773: orderNumbers ame_util.idList;
774: memberOrigSystem ame_util.stringType;
775: memberOrigSystemId number;

Line 773: orderNumbers ame_util.idList;

769: displayNames ame_util.longStringList;
770: errorCode integer;
771: errorMessage ame_util.longestStringType;
772: noTransIdDefinedException exception;
773: orderNumbers ame_util.idList;
774: memberOrigSystem ame_util.stringType;
775: memberOrigSystemId number;
776: outputIndex integer;
777: parameters ame_util.longStringList;

Line 774: memberOrigSystem ame_util.stringType;

770: errorCode integer;
771: errorMessage ame_util.longestStringType;
772: noTransIdDefinedException exception;
773: orderNumbers ame_util.idList;
774: memberOrigSystem ame_util.stringType;
775: memberOrigSystemId number;
776: outputIndex integer;
777: parameters ame_util.longStringList;
778: queryStrings ame_util.longestStringList;

Line 777: parameters ame_util.longStringList;

773: orderNumbers ame_util.idList;
774: memberOrigSystem ame_util.stringType;
775: memberOrigSystemId number;
776: outputIndex integer;
777: parameters ame_util.longStringList;
778: queryStrings ame_util.longestStringList;
779: rowsFound integer;
780: tempGroupMembers dbms_sql.Varchar2_Table;
781: upperParameterNames ame_util.stringList;

Line 778: queryStrings ame_util.longestStringList;

774: memberOrigSystem ame_util.stringType;
775: memberOrigSystemId number;
776: outputIndex integer;
777: parameters ame_util.longStringList;
778: queryStrings ame_util.longestStringList;
779: rowsFound integer;
780: tempGroupMembers dbms_sql.Varchar2_Table;
781: upperParameterNames ame_util.stringList;
782: tempGroupName ame_util.stringType;

Line 781: upperParameterNames ame_util.stringList;

777: parameters ame_util.longStringList;
778: queryStrings ame_util.longestStringList;
779: rowsFound integer;
780: tempGroupMembers dbms_sql.Varchar2_Table;
781: upperParameterNames ame_util.stringList;
782: tempGroupName ame_util.stringType;
783: begin
784: open groupMemberCursor(groupIdIn => groupIdIn);
785: fetch groupMemberCursor bulk collect

Line 782: tempGroupName ame_util.stringType;

778: queryStrings ame_util.longestStringList;
779: rowsFound integer;
780: tempGroupMembers dbms_sql.Varchar2_Table;
781: upperParameterNames ame_util.stringList;
782: tempGroupName ame_util.stringType;
783: begin
784: open groupMemberCursor(groupIdIn => groupIdIn);
785: fetch groupMemberCursor bulk collect
786: into

Line 794: if(upperParameterNames(i) = upper(ame_util.approverOamGroupId)) then

790: displayNames;
791: close groupMemberCursor;
792: outputIndex := 0; /* pre-increment */
793: for i in 1 .. parameters.count loop
794: if(upperParameterNames(i) = upper(ame_util.approverOamGroupId)) then
795: dynamicCursor := dbms_sql.open_cursor;
796: dbms_sql.parse(dynamicCursor,
797: ame_util.removeReturns(stringIn => queryStrings(i),
798: replaceWithSpaces => true),

Line 797: ame_util.removeReturns(stringIn => queryStrings(i),

793: for i in 1 .. parameters.count loop
794: if(upperParameterNames(i) = upper(ame_util.approverOamGroupId)) then
795: dynamicCursor := dbms_sql.open_cursor;
796: dbms_sql.parse(dynamicCursor,
797: ame_util.removeReturns(stringIn => queryStrings(i),
798: replaceWithSpaces => true),
799: dbms_sql.native);
800: if(instrb(queryStrings(i),
801: ame_util.transactionIdPlaceholder) > 0) then

Line 801: ame_util.transactionIdPlaceholder) > 0) then

797: ame_util.removeReturns(stringIn => queryStrings(i),
798: replaceWithSpaces => true),
799: dbms_sql.native);
800: if(instrb(queryStrings(i),
801: ame_util.transactionIdPlaceholder) > 0) then
802: if transactionIdIn is null then
803: dbms_sql.close_cursor(dynamicCursor);
804: raise noTransIdDefinedException;
805: end if;

Line 807: ame_util.transactionIdPlaceholder,

803: dbms_sql.close_cursor(dynamicCursor);
804: raise noTransIdDefinedException;
805: end if;
806: dbms_sql.bind_variable(dynamicCursor,
807: ame_util.transactionIdPlaceholder,
808: transactionIdIn,
809: 50);
810: end if;
811: if(instrb(queryStrings(i),

Line 812: ame_util2.itemClassPlaceHolder) > 0) then

808: transactionIdIn,
809: 50);
810: end if;
811: if(instrb(queryStrings(i),
812: ame_util2.itemClassPlaceHolder) > 0) then
813: dbms_sql.bind_variable(dynamicCursor,
814: ame_util2.itemClassPlaceHolder,
815: ame_util.headerItemClassName,
816: 50);

Line 814: ame_util2.itemClassPlaceHolder,

810: end if;
811: if(instrb(queryStrings(i),
812: ame_util2.itemClassPlaceHolder) > 0) then
813: dbms_sql.bind_variable(dynamicCursor,
814: ame_util2.itemClassPlaceHolder,
815: ame_util.headerItemClassName,
816: 50);
817: end if;
818: if (instrb(queryStrings(i),

Line 815: ame_util.headerItemClassName,

811: if(instrb(queryStrings(i),
812: ame_util2.itemClassPlaceHolder) > 0) then
813: dbms_sql.bind_variable(dynamicCursor,
814: ame_util2.itemClassPlaceHolder,
815: ame_util.headerItemClassName,
816: 50);
817: end if;
818: if (instrb(queryStrings(i),
819: ame_util2.itemIdPlaceHolder) > 0) then

Line 819: ame_util2.itemIdPlaceHolder) > 0) then

815: ame_util.headerItemClassName,
816: 50);
817: end if;
818: if (instrb(queryStrings(i),
819: ame_util2.itemIdPlaceHolder) > 0) then
820: if transactionIdIn is null then
821: dbms_sql.close_cursor(dynamicCursor);
822: raise noTransIdDefinedException;
823: end if;

Line 825: ame_util2.itemIdPlaceHolder,

821: dbms_sql.close_cursor(dynamicCursor);
822: raise noTransIdDefinedException;
823: end if;
824: dbms_sql.bind_variable(dynamicCursor,
825: ame_util2.itemIdPlaceHolder,
826: transactionIdIn,
827: 50);
828: end if;
829: dbms_sql.define_array(dynamicCursor,

Line 859: upper(ame_util.approverPersonId)) then

855: if(colonLocation2 = 0) then /* first case (old style) */
856: memberOrigSystemId :=
857: substrb(tempGroupMembers(j), (instrb(tempGroupMembers(j), ':', 1, 1) + 1));
858: if(substrb(upper(tempGroupMembers(j)), 1, (instrb(tempGroupMembers(j), ':', 1, 1) - 1)) =
859: upper(ame_util.approverPersonId)) then
860: memberOrigSystem := ame_util.perOrigSystem;
861: elsif (substrb(upper(tempGroupMembers(j)), 1, (instrb(tempGroupMembers(j), ':', 1, 1) - 1)) =
862: upper(ame_util.approverUserId)) then
863: memberOrigSystem := ame_util.fndUserOrigSystem;

Line 860: memberOrigSystem := ame_util.perOrigSystem;

856: memberOrigSystemId :=
857: substrb(tempGroupMembers(j), (instrb(tempGroupMembers(j), ':', 1, 1) + 1));
858: if(substrb(upper(tempGroupMembers(j)), 1, (instrb(tempGroupMembers(j), ':', 1, 1) - 1)) =
859: upper(ame_util.approverPersonId)) then
860: memberOrigSystem := ame_util.perOrigSystem;
861: elsif (substrb(upper(tempGroupMembers(j)), 1, (instrb(tempGroupMembers(j), ':', 1, 1) - 1)) =
862: upper(ame_util.approverUserId)) then
863: memberOrigSystem := ame_util.fndUserOrigSystem;
864: else

Line 862: upper(ame_util.approverUserId)) then

858: if(substrb(upper(tempGroupMembers(j)), 1, (instrb(tempGroupMembers(j), ':', 1, 1) - 1)) =
859: upper(ame_util.approverPersonId)) then
860: memberOrigSystem := ame_util.perOrigSystem;
861: elsif (substrb(upper(tempGroupMembers(j)), 1, (instrb(tempGroupMembers(j), ':', 1, 1) - 1)) =
862: upper(ame_util.approverUserId)) then
863: memberOrigSystem := ame_util.fndUserOrigSystem;
864: else
865: memberOrigSystem :=
866: substrb(tempGroupMembers(j), 1, (instrb(tempGroupMembers(j), ':', 1, 1)-1));

Line 863: memberOrigSystem := ame_util.fndUserOrigSystem;

859: upper(ame_util.approverPersonId)) then
860: memberOrigSystem := ame_util.perOrigSystem;
861: elsif (substrb(upper(tempGroupMembers(j)), 1, (instrb(tempGroupMembers(j), ':', 1, 1) - 1)) =
862: upper(ame_util.approverUserId)) then
863: memberOrigSystem := ame_util.fndUserOrigSystem;
864: else
865: memberOrigSystem :=
866: substrb(tempGroupMembers(j), 1, (instrb(tempGroupMembers(j), ':', 1, 1)-1));
867: memberOrigSystemId :=

Line 894: errorMessage := ame_util.getMessage(applicationShortNameIn => 'PER',

890: close groupMemberCursor;
891: end if;
892: memberDisplayNamesOut.delete;
893: errorCode := -20001;
894: errorMessage := ame_util.getMessage(applicationShortNameIn => 'PER',
895: messageNameIn => 'AME_400454_GRP_DYN_QRY_ERR');
896: ame_util.runtimeException(packageNameIn => 'ame_api3',
897: routineNameIn => 'getGroupMembers1',
898: exceptionNumberIn => errorCode,

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

892: memberDisplayNamesOut.delete;
893: errorCode := -20001;
894: errorMessage := ame_util.getMessage(applicationShortNameIn => 'PER',
895: messageNameIn => 'AME_400454_GRP_DYN_QRY_ERR');
896: ame_util.runtimeException(packageNameIn => 'ame_api3',
897: routineNameIn => 'getGroupMembers1',
898: exceptionNumberIn => errorCode,
899: exceptionStringIn => errorMessage);
900: raise_application_error(errorCode,

Line 910: errorMessage := ame_util.getMessage(

906: memberDisplayNamesOut.delete;
907: errorCode := -20001;
908: ame_api5.getApprovalGroupName(groupIdIn => groupIdIn
909: ,groupNameOut => tempGroupName);
910: errorMessage := ame_util.getMessage(
911: applicationShortNameIn => 'PER',
912: messageNameIn => 'AME_400798_GROUP_ITEM_BIND',
913: tokenNameOneIn => 'APPROVER_GROUP',
914: tokenValueOneIn => tempGroupName);

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

911: applicationShortNameIn => 'PER',
912: messageNameIn => 'AME_400798_GROUP_ITEM_BIND',
913: tokenNameOneIn => 'APPROVER_GROUP',
914: tokenValueOneIn => tempGroupName);
915: ame_util.runtimeException(packageNameIn => 'ame_api3',
916: routineNameIn => 'getGroupMembers1',
917: exceptionNumberIn => errorCode,
918: exceptionStringIn => errorMessage);
919: raise_application_error(errorCode,

Line 929: errorMessage := ame_util.getMessage(

925: memberDisplayNamesOut.delete;
926: errorCode := -20001;
927: ame_api5.getApprovalGroupName(groupIdIn => groupIdIn
928: ,groupNameOut => tempGroupName);
929: errorMessage := ame_util.getMessage(
930: applicationShortNameIn => 'PER',
931: messageNameIn => 'AME_400455_GRP_DYN_NULL_TXID',
932: tokenNameOneIn => 'APPROVAL_GROUP',
933: tokenValueOneIn => tempGroupName);

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

930: applicationShortNameIn => 'PER',
931: messageNameIn => 'AME_400455_GRP_DYN_NULL_TXID',
932: tokenNameOneIn => 'APPROVAL_GROUP',
933: tokenValueOneIn => tempGroupName);
934: ame_util.runtimeException(packageNameIn => 'ame_api3',
935: routineNameIn => 'getGroupMembers1',
936: exceptionNumberIn => errorCode,
937: exceptionStringIn => errorMessage);
938: raise_application_error(errorCode,

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

941: if(groupMemberCursor%isopen) then
942: close groupMemberCursor;
943: end if;
944: memberDisplayNamesOut.delete;
945: ame_util.runtimeException(packageNameIn => 'ame_api3',
946: routineNameIn => 'getGroupMembers1',
947: exceptionNumberIn => sqlcode,
948: exceptionStringIn => sqlerrm);
949: raise;

Line 955: memberNamesOut out nocopy ame_util.longStringList,

951: procedure getGroupMembers2(applicationIdIn in number default null,
952: transactionTypeIn in varchar2 default null,
953: transactionIdIn in varchar2 default null,
954: groupIdIn in number,
955: memberNamesOut out nocopy ame_util.longStringList,
956: memberDisplayNamesOut out nocopy ame_util.longStringList)as
957: cursor groupMemberCursor(groupIdIn in integer) is
958: select
959: parameter,

Line 956: memberDisplayNamesOut out nocopy ame_util.longStringList)as

952: transactionTypeIn in varchar2 default null,
953: transactionIdIn in varchar2 default null,
954: groupIdIn in number,
955: memberNamesOut out nocopy ame_util.longStringList,
956: memberDisplayNamesOut out nocopy ame_util.longStringList)as
957: cursor groupMemberCursor(groupIdIn in integer) is
958: select
959: parameter,
960: upper(parameter_name),

Line 963: ame_util.approverOamGroupId, null,

959: parameter,
960: upper(parameter_name),
961: query_string,
962: decode(parameter_name,
963: ame_util.approverOamGroupId, null,
964: ame_approver_type_pkg.getWfRolesName(orig_system, orig_system_id)) approver_name,
965: decode(parameter_name,
966: ame_util.approverOamGroupId, null,
967: ame_approver_type_pkg.getApproverDisplayName2(orig_system, orig_system_id)) display_name

Line 966: ame_util.approverOamGroupId, null,

962: decode(parameter_name,
963: ame_util.approverOamGroupId, null,
964: ame_approver_type_pkg.getWfRolesName(orig_system, orig_system_id)) approver_name,
965: decode(parameter_name,
966: ame_util.approverOamGroupId, null,
967: ame_approver_type_pkg.getApproverDisplayName2(orig_system, orig_system_id)) display_name
968: from ame_approval_group_members
969: where
970: approval_group_id = groupIdIn

Line 977: displayNames ame_util.longStringList;

973: noItemBindException exception;
974: dynamicCursor integer;
975: colonLocation1 integer;
976: colonLocation2 integer;
977: displayNames ame_util.longStringList;
978: errorCode integer;
979: errorMessage ame_util.longestStringType;
980: approverNames ame_util.longStringList;
981: memberOrigSystem ame_util.stringType;

Line 979: errorMessage ame_util.longestStringType;

975: colonLocation1 integer;
976: colonLocation2 integer;
977: displayNames ame_util.longStringList;
978: errorCode integer;
979: errorMessage ame_util.longestStringType;
980: approverNames ame_util.longStringList;
981: memberOrigSystem ame_util.stringType;
982: memberOrigSystemId number;
983: noTransIdDefinedException exception;

Line 980: approverNames ame_util.longStringList;

976: colonLocation2 integer;
977: displayNames ame_util.longStringList;
978: errorCode integer;
979: errorMessage ame_util.longestStringType;
980: approverNames ame_util.longStringList;
981: memberOrigSystem ame_util.stringType;
982: memberOrigSystemId number;
983: noTransIdDefinedException exception;
984: orderNumbers ame_util.idList;

Line 981: memberOrigSystem ame_util.stringType;

977: displayNames ame_util.longStringList;
978: errorCode integer;
979: errorMessage ame_util.longestStringType;
980: approverNames ame_util.longStringList;
981: memberOrigSystem ame_util.stringType;
982: memberOrigSystemId number;
983: noTransIdDefinedException exception;
984: orderNumbers ame_util.idList;
985: origSystemIds ame_util.idList;

Line 984: orderNumbers ame_util.idList;

980: approverNames ame_util.longStringList;
981: memberOrigSystem ame_util.stringType;
982: memberOrigSystemId number;
983: noTransIdDefinedException exception;
984: orderNumbers ame_util.idList;
985: origSystemIds ame_util.idList;
986: origSystems ame_util.stringList;
987: outputIndex integer;
988: parameters ame_util.longStringList;

Line 985: origSystemIds ame_util.idList;

981: memberOrigSystem ame_util.stringType;
982: memberOrigSystemId number;
983: noTransIdDefinedException exception;
984: orderNumbers ame_util.idList;
985: origSystemIds ame_util.idList;
986: origSystems ame_util.stringList;
987: outputIndex integer;
988: parameters ame_util.longStringList;
989: queryStrings ame_util.longestStringList;

Line 986: origSystems ame_util.stringList;

982: memberOrigSystemId number;
983: noTransIdDefinedException exception;
984: orderNumbers ame_util.idList;
985: origSystemIds ame_util.idList;
986: origSystems ame_util.stringList;
987: outputIndex integer;
988: parameters ame_util.longStringList;
989: queryStrings ame_util.longestStringList;
990: rowsFound integer;

Line 988: parameters ame_util.longStringList;

984: orderNumbers ame_util.idList;
985: origSystemIds ame_util.idList;
986: origSystems ame_util.stringList;
987: outputIndex integer;
988: parameters ame_util.longStringList;
989: queryStrings ame_util.longestStringList;
990: rowsFound integer;
991: tempGroupMembers dbms_sql.Varchar2_Table;
992: upperParameterNames ame_util.stringList;

Line 989: queryStrings ame_util.longestStringList;

985: origSystemIds ame_util.idList;
986: origSystems ame_util.stringList;
987: outputIndex integer;
988: parameters ame_util.longStringList;
989: queryStrings ame_util.longestStringList;
990: rowsFound integer;
991: tempGroupMembers dbms_sql.Varchar2_Table;
992: upperParameterNames ame_util.stringList;
993: tempGroupName ame_util.stringType;

Line 992: upperParameterNames ame_util.stringList;

988: parameters ame_util.longStringList;
989: queryStrings ame_util.longestStringList;
990: rowsFound integer;
991: tempGroupMembers dbms_sql.Varchar2_Table;
992: upperParameterNames ame_util.stringList;
993: tempGroupName ame_util.stringType;
994: begin
995: open groupMemberCursor(groupIdIn => groupIdIn);
996: fetch groupMemberCursor bulk collect

Line 993: tempGroupName ame_util.stringType;

989: queryStrings ame_util.longestStringList;
990: rowsFound integer;
991: tempGroupMembers dbms_sql.Varchar2_Table;
992: upperParameterNames ame_util.stringList;
993: tempGroupName ame_util.stringType;
994: begin
995: open groupMemberCursor(groupIdIn => groupIdIn);
996: fetch groupMemberCursor bulk collect
997: into

Line 1006: if(upperParameterNames(i) = upper(ame_util.approverOamGroupId)) then

1002: displayNames;
1003: close groupMemberCursor;
1004: outputIndex := 0; /* pre-increment */
1005: for i in 1 .. parameters.count loop
1006: if(upperParameterNames(i) = upper(ame_util.approverOamGroupId)) then
1007: dynamicCursor := dbms_sql.open_cursor;
1008: dbms_sql.parse(dynamicCursor,
1009: ame_util.removeReturns(stringIn => queryStrings(i),
1010: replaceWithSpaces => true),

Line 1009: ame_util.removeReturns(stringIn => queryStrings(i),

1005: for i in 1 .. parameters.count loop
1006: if(upperParameterNames(i) = upper(ame_util.approverOamGroupId)) then
1007: dynamicCursor := dbms_sql.open_cursor;
1008: dbms_sql.parse(dynamicCursor,
1009: ame_util.removeReturns(stringIn => queryStrings(i),
1010: replaceWithSpaces => true),
1011: dbms_sql.native);
1012: if(instrb(queryStrings(i),
1013: ame_util.transactionIdPlaceholder) > 0) then

Line 1013: ame_util.transactionIdPlaceholder) > 0) then

1009: ame_util.removeReturns(stringIn => queryStrings(i),
1010: replaceWithSpaces => true),
1011: dbms_sql.native);
1012: if(instrb(queryStrings(i),
1013: ame_util.transactionIdPlaceholder) > 0) then
1014: if transactionIdIn is null then
1015: dbms_sql.close_cursor(dynamicCursor);
1016: raise noTransIdDefinedException;
1017: end if;

Line 1019: ame_util.transactionIdPlaceholder,

1015: dbms_sql.close_cursor(dynamicCursor);
1016: raise noTransIdDefinedException;
1017: end if;
1018: dbms_sql.bind_variable(dynamicCursor,
1019: ame_util.transactionIdPlaceholder,
1020: transactionIdIn,
1021: 50);
1022: end if;
1023: if(instrb(queryStrings(i),

Line 1024: ame_util2.itemClassPlaceHolder) > 0) then

1020: transactionIdIn,
1021: 50);
1022: end if;
1023: if(instrb(queryStrings(i),
1024: ame_util2.itemClassPlaceHolder) > 0) then
1025: dbms_sql.bind_variable(dynamicCursor,
1026: ame_util2.itemClassPlaceHolder,
1027: ame_util.headerItemClassName,
1028: 50);

Line 1026: ame_util2.itemClassPlaceHolder,

1022: end if;
1023: if(instrb(queryStrings(i),
1024: ame_util2.itemClassPlaceHolder) > 0) then
1025: dbms_sql.bind_variable(dynamicCursor,
1026: ame_util2.itemClassPlaceHolder,
1027: ame_util.headerItemClassName,
1028: 50);
1029: end if;
1030: if (instrb(queryStrings(i),

Line 1027: ame_util.headerItemClassName,

1023: if(instrb(queryStrings(i),
1024: ame_util2.itemClassPlaceHolder) > 0) then
1025: dbms_sql.bind_variable(dynamicCursor,
1026: ame_util2.itemClassPlaceHolder,
1027: ame_util.headerItemClassName,
1028: 50);
1029: end if;
1030: if (instrb(queryStrings(i),
1031: ame_util2.itemIdPlaceHolder) > 0) then

Line 1031: ame_util2.itemIdPlaceHolder) > 0) then

1027: ame_util.headerItemClassName,
1028: 50);
1029: end if;
1030: if (instrb(queryStrings(i),
1031: ame_util2.itemIdPlaceHolder) > 0) then
1032: if transactionIdIn is null then
1033: dbms_sql.close_cursor(dynamicCursor);
1034: raise noTransIdDefinedException;
1035: end if;

Line 1037: ame_util2.itemIdPlaceHolder,

1033: dbms_sql.close_cursor(dynamicCursor);
1034: raise noTransIdDefinedException;
1035: end if;
1036: dbms_sql.bind_variable(dynamicCursor,
1037: ame_util2.itemIdPlaceHolder,
1038: transactionIdIn,
1039: 50);
1040: end if;
1041: dbms_sql.define_array(dynamicCursor,

Line 1071: upper(ame_util.approverPersonId)) then

1067: if(colonLocation2 = 0) then /* first case (old style) */
1068: memberOrigSystemId :=
1069: substrb(tempGroupMembers(j), (instrb(tempGroupMembers(j), ':', 1, 1) + 1));
1070: if(substrb(upper(tempGroupMembers(j)), 1, (instrb(tempGroupMembers(j), ':', 1, 1) - 1)) =
1071: upper(ame_util.approverPersonId)) then
1072: memberOrigSystem := ame_util.perOrigSystem;
1073: elsif (substrb(upper(tempGroupMembers(j)), 1, (instrb(tempGroupMembers(j), ':', 1, 1) - 1)) =
1074: upper(ame_util.approverUserId)) then
1075: memberOrigSystem := ame_util.fndUserOrigSystem;

Line 1072: memberOrigSystem := ame_util.perOrigSystem;

1068: memberOrigSystemId :=
1069: substrb(tempGroupMembers(j), (instrb(tempGroupMembers(j), ':', 1, 1) + 1));
1070: if(substrb(upper(tempGroupMembers(j)), 1, (instrb(tempGroupMembers(j), ':', 1, 1) - 1)) =
1071: upper(ame_util.approverPersonId)) then
1072: memberOrigSystem := ame_util.perOrigSystem;
1073: elsif (substrb(upper(tempGroupMembers(j)), 1, (instrb(tempGroupMembers(j), ':', 1, 1) - 1)) =
1074: upper(ame_util.approverUserId)) then
1075: memberOrigSystem := ame_util.fndUserOrigSystem;
1076: else

Line 1074: upper(ame_util.approverUserId)) then

1070: if(substrb(upper(tempGroupMembers(j)), 1, (instrb(tempGroupMembers(j), ':', 1, 1) - 1)) =
1071: upper(ame_util.approverPersonId)) then
1072: memberOrigSystem := ame_util.perOrigSystem;
1073: elsif (substrb(upper(tempGroupMembers(j)), 1, (instrb(tempGroupMembers(j), ':', 1, 1) - 1)) =
1074: upper(ame_util.approverUserId)) then
1075: memberOrigSystem := ame_util.fndUserOrigSystem;
1076: else
1077: memberOrigSystem :=
1078: substrb(tempGroupMembers(j), 1, (instrb(tempGroupMembers(j), ':', 1, 1)-1));

Line 1075: memberOrigSystem := ame_util.fndUserOrigSystem;

1071: upper(ame_util.approverPersonId)) then
1072: memberOrigSystem := ame_util.perOrigSystem;
1073: elsif (substrb(upper(tempGroupMembers(j)), 1, (instrb(tempGroupMembers(j), ':', 1, 1) - 1)) =
1074: upper(ame_util.approverUserId)) then
1075: memberOrigSystem := ame_util.fndUserOrigSystem;
1076: else
1077: memberOrigSystem :=
1078: substrb(tempGroupMembers(j), 1, (instrb(tempGroupMembers(j), ':', 1, 1)-1));
1079: memberOrigSystemId :=

Line 1107: errorMessage := ame_util.getMessage(applicationShortNameIn => 'PER',

1103: if(groupMemberCursor%isopen) then
1104: close groupMemberCursor;
1105: end if;
1106: errorCode := -20001;
1107: errorMessage := ame_util.getMessage(applicationShortNameIn => 'PER',
1108: messageNameIn => 'AME_400454_GRP_DYN_QRY_ERR');
1109: ame_util.runtimeException(packageNameIn => 'ame_api3',
1110: routineNameIn => 'getGroupMembers2',
1111: exceptionNumberIn => errorCode,

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

1105: end if;
1106: errorCode := -20001;
1107: errorMessage := ame_util.getMessage(applicationShortNameIn => 'PER',
1108: messageNameIn => 'AME_400454_GRP_DYN_QRY_ERR');
1109: ame_util.runtimeException(packageNameIn => 'ame_api3',
1110: routineNameIn => 'getGroupMembers2',
1111: exceptionNumberIn => errorCode,
1112: exceptionStringIn => errorMessage);
1113: raise_application_error(errorCode,

Line 1122: errorMessage := ame_util.getMessage(

1118: end if;
1119: errorCode := -20001;
1120: ame_api5.getApprovalGroupName(groupIdIn => groupIdIn
1121: ,groupNameOut => tempGroupName);
1122: errorMessage := ame_util.getMessage(
1123: applicationShortNameIn => 'PER',
1124: messageNameIn => 'AME_400455_GRP_DYN_NULL_TXID',
1125: tokenNameOneIn => 'APPROVAL_GROUP',
1126: tokenValueOneIn => tempGroupName);

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

1123: applicationShortNameIn => 'PER',
1124: messageNameIn => 'AME_400455_GRP_DYN_NULL_TXID',
1125: tokenNameOneIn => 'APPROVAL_GROUP',
1126: tokenValueOneIn => tempGroupName);
1127: ame_util.runtimeException(packageNameIn => 'ame_api3',
1128: routineNameIn => 'getGroupMembers2',
1129: exceptionNumberIn => errorCode,
1130: exceptionStringIn => errorMessage);
1131: raise_application_error(errorCode,

Line 1141: errorMessage := ame_util.getMessage(

1137: memberDisplayNamesOut.delete;
1138: errorCode := -20001;
1139: ame_api5.getApprovalGroupName(groupIdIn => groupIdIn
1140: ,groupNameOut => tempGroupName);
1141: errorMessage := ame_util.getMessage(
1142: applicationShortNameIn => 'PER',
1143: messageNameIn => 'AME_400798_GROUP_ITEM_BIND',
1144: tokenNameOneIn => 'APPROVER_GROUP',
1145: tokenValueOneIn => tempGroupName);

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

1142: applicationShortNameIn => 'PER',
1143: messageNameIn => 'AME_400798_GROUP_ITEM_BIND',
1144: tokenNameOneIn => 'APPROVER_GROUP',
1145: tokenValueOneIn => tempGroupName);
1146: ame_util.runtimeException(packageNameIn => 'ame_api3',
1147: routineNameIn => 'getGroupMembers2',
1148: exceptionNumberIn => errorCode,
1149: exceptionStringIn => errorMessage);
1150: raise_application_error(errorCode,

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

1152: when others then
1153: if(groupMemberCursor%isopen) then
1154: close groupMemberCursor;
1155: end if;
1156: ame_util.runtimeException(packageNameIn => 'ame_api3',
1157: routineNameIn => 'getGroupMembers2',
1158: exceptionNumberIn => sqlcode,
1159: exceptionStringIn => sqlerrm);
1160: raise;

Line 1166: memberNamesOut out nocopy ame_util.longStringList,

1162: procedure getGroupMembers3(applicationIdIn in number default null,
1163: transactionTypeIn in varchar2 default null,
1164: transactionIdIn in varchar2 default null,
1165: groupIdIn in number,
1166: memberNamesOut out nocopy ame_util.longStringList,
1167: memberOrderNumbersOut out nocopy ame_util.idList,
1168: memberDisplayNamesOut out nocopy ame_util.longStringList)as
1169: cursor groupMemberCursor(groupIdIn in integer) is
1170: select

Line 1167: memberOrderNumbersOut out nocopy ame_util.idList,

1163: transactionTypeIn in varchar2 default null,
1164: transactionIdIn in varchar2 default null,
1165: groupIdIn in number,
1166: memberNamesOut out nocopy ame_util.longStringList,
1167: memberOrderNumbersOut out nocopy ame_util.idList,
1168: memberDisplayNamesOut out nocopy ame_util.longStringList)as
1169: cursor groupMemberCursor(groupIdIn in integer) is
1170: select
1171: parameter,

Line 1168: memberDisplayNamesOut out nocopy ame_util.longStringList)as

1164: transactionIdIn in varchar2 default null,
1165: groupIdIn in number,
1166: memberNamesOut out nocopy ame_util.longStringList,
1167: memberOrderNumbersOut out nocopy ame_util.idList,
1168: memberDisplayNamesOut out nocopy ame_util.longStringList)as
1169: cursor groupMemberCursor(groupIdIn in integer) is
1170: select
1171: parameter,
1172: upper(parameter_name),

Line 1176: ame_util.approverOamGroupId, null,

1172: upper(parameter_name),
1173: query_string,
1174: order_number,
1175: decode(parameter_name,
1176: ame_util.approverOamGroupId, null,
1177: ame_approver_type_pkg.getWfRolesName(orig_system, orig_system_id)) approver_name,
1178: decode(parameter_name,
1179: ame_util.approverOamGroupId, null,
1180: ame_approver_type_pkg.getApproverDisplayName2(orig_system, orig_system_id)) display_name

Line 1179: ame_util.approverOamGroupId, null,

1175: decode(parameter_name,
1176: ame_util.approverOamGroupId, null,
1177: ame_approver_type_pkg.getWfRolesName(orig_system, orig_system_id)) approver_name,
1178: decode(parameter_name,
1179: ame_util.approverOamGroupId, null,
1180: ame_approver_type_pkg.getApproverDisplayName2(orig_system, orig_system_id)) display_name
1181: from ame_approval_group_members
1182: where
1183: approval_group_id = groupIdIn

Line 1190: displayNames ame_util.longStringList;

1186: noItemBindException exception;
1187: dynamicCursor integer;
1188: colonLocation1 integer;
1189: colonLocation2 integer;
1190: displayNames ame_util.longStringList;
1191: errorCode integer;
1192: errorMessage ame_util.longestStringType;
1193: approverNames ame_util.longStringList;
1194: memberOrigSystem ame_util.stringType;

Line 1192: errorMessage ame_util.longestStringType;

1188: colonLocation1 integer;
1189: colonLocation2 integer;
1190: displayNames ame_util.longStringList;
1191: errorCode integer;
1192: errorMessage ame_util.longestStringType;
1193: approverNames ame_util.longStringList;
1194: memberOrigSystem ame_util.stringType;
1195: memberOrigSystemId number;
1196: noTransIdDefinedException exception;

Line 1193: approverNames ame_util.longStringList;

1189: colonLocation2 integer;
1190: displayNames ame_util.longStringList;
1191: errorCode integer;
1192: errorMessage ame_util.longestStringType;
1193: approverNames ame_util.longStringList;
1194: memberOrigSystem ame_util.stringType;
1195: memberOrigSystemId number;
1196: noTransIdDefinedException exception;
1197: orderNumbers ame_util.idList;

Line 1194: memberOrigSystem ame_util.stringType;

1190: displayNames ame_util.longStringList;
1191: errorCode integer;
1192: errorMessage ame_util.longestStringType;
1193: approverNames ame_util.longStringList;
1194: memberOrigSystem ame_util.stringType;
1195: memberOrigSystemId number;
1196: noTransIdDefinedException exception;
1197: orderNumbers ame_util.idList;
1198: origSystemIds ame_util.idList;

Line 1197: orderNumbers ame_util.idList;

1193: approverNames ame_util.longStringList;
1194: memberOrigSystem ame_util.stringType;
1195: memberOrigSystemId number;
1196: noTransIdDefinedException exception;
1197: orderNumbers ame_util.idList;
1198: origSystemIds ame_util.idList;
1199: origSystems ame_util.stringList;
1200: outputIndex integer;
1201: parameters ame_util.longStringList;

Line 1198: origSystemIds ame_util.idList;

1194: memberOrigSystem ame_util.stringType;
1195: memberOrigSystemId number;
1196: noTransIdDefinedException exception;
1197: orderNumbers ame_util.idList;
1198: origSystemIds ame_util.idList;
1199: origSystems ame_util.stringList;
1200: outputIndex integer;
1201: parameters ame_util.longStringList;
1202: queryStrings ame_util.longestStringList;

Line 1199: origSystems ame_util.stringList;

1195: memberOrigSystemId number;
1196: noTransIdDefinedException exception;
1197: orderNumbers ame_util.idList;
1198: origSystemIds ame_util.idList;
1199: origSystems ame_util.stringList;
1200: outputIndex integer;
1201: parameters ame_util.longStringList;
1202: queryStrings ame_util.longestStringList;
1203: rowsFound integer;

Line 1201: parameters ame_util.longStringList;

1197: orderNumbers ame_util.idList;
1198: origSystemIds ame_util.idList;
1199: origSystems ame_util.stringList;
1200: outputIndex integer;
1201: parameters ame_util.longStringList;
1202: queryStrings ame_util.longestStringList;
1203: rowsFound integer;
1204: tempGroupMembers dbms_sql.Varchar2_Table;
1205: upperParameterNames ame_util.stringList;

Line 1202: queryStrings ame_util.longestStringList;

1198: origSystemIds ame_util.idList;
1199: origSystems ame_util.stringList;
1200: outputIndex integer;
1201: parameters ame_util.longStringList;
1202: queryStrings ame_util.longestStringList;
1203: rowsFound integer;
1204: tempGroupMembers dbms_sql.Varchar2_Table;
1205: upperParameterNames ame_util.stringList;
1206: tempGroupName ame_util.stringType;

Line 1205: upperParameterNames ame_util.stringList;

1201: parameters ame_util.longStringList;
1202: queryStrings ame_util.longestStringList;
1203: rowsFound integer;
1204: tempGroupMembers dbms_sql.Varchar2_Table;
1205: upperParameterNames ame_util.stringList;
1206: tempGroupName ame_util.stringType;
1207: begin
1208: open groupMemberCursor(groupIdIn => groupIdIn);
1209: fetch groupMemberCursor bulk collect

Line 1206: tempGroupName ame_util.stringType;

1202: queryStrings ame_util.longestStringList;
1203: rowsFound integer;
1204: tempGroupMembers dbms_sql.Varchar2_Table;
1205: upperParameterNames ame_util.stringList;
1206: tempGroupName ame_util.stringType;
1207: begin
1208: open groupMemberCursor(groupIdIn => groupIdIn);
1209: fetch groupMemberCursor bulk collect
1210: into

Line 1220: if(upperParameterNames(i) = upper(ame_util.approverOamGroupId)) then

1216: displayNames;
1217: close groupMemberCursor;
1218: outputIndex := 0; /* pre-increment */
1219: for i in 1 .. parameters.count loop
1220: if(upperParameterNames(i) = upper(ame_util.approverOamGroupId)) then
1221: dynamicCursor := dbms_sql.open_cursor;
1222: dbms_sql.parse(dynamicCursor,
1223: ame_util.removeReturns(stringIn => queryStrings(i),
1224: replaceWithSpaces => true),

Line 1223: ame_util.removeReturns(stringIn => queryStrings(i),

1219: for i in 1 .. parameters.count loop
1220: if(upperParameterNames(i) = upper(ame_util.approverOamGroupId)) then
1221: dynamicCursor := dbms_sql.open_cursor;
1222: dbms_sql.parse(dynamicCursor,
1223: ame_util.removeReturns(stringIn => queryStrings(i),
1224: replaceWithSpaces => true),
1225: dbms_sql.native);
1226: if(instrb(queryStrings(i),
1227: ame_util.transactionIdPlaceholder) > 0) then

Line 1227: ame_util.transactionIdPlaceholder) > 0) then

1223: ame_util.removeReturns(stringIn => queryStrings(i),
1224: replaceWithSpaces => true),
1225: dbms_sql.native);
1226: if(instrb(queryStrings(i),
1227: ame_util.transactionIdPlaceholder) > 0) then
1228: if transactionIdIn is null then
1229: dbms_sql.close_cursor(dynamicCursor);
1230: raise noTransIdDefinedException;
1231: end if;

Line 1233: ame_util.transactionIdPlaceholder,

1229: dbms_sql.close_cursor(dynamicCursor);
1230: raise noTransIdDefinedException;
1231: end if;
1232: dbms_sql.bind_variable(dynamicCursor,
1233: ame_util.transactionIdPlaceholder,
1234: transactionIdIn,
1235: 50);
1236: end if;
1237: if(instrb(queryStrings(i),

Line 1238: ame_util2.itemClassPlaceHolder) > 0) then

1234: transactionIdIn,
1235: 50);
1236: end if;
1237: if(instrb(queryStrings(i),
1238: ame_util2.itemClassPlaceHolder) > 0) then
1239: dbms_sql.bind_variable(dynamicCursor,
1240: ame_util2.itemClassPlaceHolder,
1241: ame_util.headerItemClassName,
1242: 50);

Line 1240: ame_util2.itemClassPlaceHolder,

1236: end if;
1237: if(instrb(queryStrings(i),
1238: ame_util2.itemClassPlaceHolder) > 0) then
1239: dbms_sql.bind_variable(dynamicCursor,
1240: ame_util2.itemClassPlaceHolder,
1241: ame_util.headerItemClassName,
1242: 50);
1243: end if;
1244: if (instrb(queryStrings(i),

Line 1241: ame_util.headerItemClassName,

1237: if(instrb(queryStrings(i),
1238: ame_util2.itemClassPlaceHolder) > 0) then
1239: dbms_sql.bind_variable(dynamicCursor,
1240: ame_util2.itemClassPlaceHolder,
1241: ame_util.headerItemClassName,
1242: 50);
1243: end if;
1244: if (instrb(queryStrings(i),
1245: ame_util2.itemIdPlaceHolder) > 0) then

Line 1245: ame_util2.itemIdPlaceHolder) > 0) then

1241: ame_util.headerItemClassName,
1242: 50);
1243: end if;
1244: if (instrb(queryStrings(i),
1245: ame_util2.itemIdPlaceHolder) > 0) then
1246: if transactionIdIn is null then
1247: dbms_sql.close_cursor(dynamicCursor);
1248: raise noTransIdDefinedException;
1249: end if;

Line 1251: ame_util2.itemIdPlaceHolder,

1247: dbms_sql.close_cursor(dynamicCursor);
1248: raise noTransIdDefinedException;
1249: end if;
1250: dbms_sql.bind_variable(dynamicCursor,
1251: ame_util2.itemIdPlaceHolder,
1252: transactionIdIn,
1253: 50);
1254: end if;
1255: dbms_sql.define_array(dynamicCursor,

Line 1286: upper(ame_util.approverPersonId)) then

1282: if(colonLocation2 = 0) then /* first case (old style) */
1283: memberOrigSystemId :=
1284: substrb(tempGroupMembers(j), (instrb(tempGroupMembers(j), ':', 1, 1) + 1));
1285: if(substrb(upper(tempGroupMembers(j)), 1, (instrb(tempGroupMembers(j), ':', 1, 1) - 1)) =
1286: upper(ame_util.approverPersonId)) then
1287: memberOrigSystem := ame_util.perOrigSystem;
1288: elsif (substrb(upper(tempGroupMembers(j)), 1, (instrb(tempGroupMembers(j), ':', 1, 1) - 1)) =
1289: upper(ame_util.approverUserId)) then
1290: memberOrigSystem := ame_util.fndUserOrigSystem;

Line 1287: memberOrigSystem := ame_util.perOrigSystem;

1283: memberOrigSystemId :=
1284: substrb(tempGroupMembers(j), (instrb(tempGroupMembers(j), ':', 1, 1) + 1));
1285: if(substrb(upper(tempGroupMembers(j)), 1, (instrb(tempGroupMembers(j), ':', 1, 1) - 1)) =
1286: upper(ame_util.approverPersonId)) then
1287: memberOrigSystem := ame_util.perOrigSystem;
1288: elsif (substrb(upper(tempGroupMembers(j)), 1, (instrb(tempGroupMembers(j), ':', 1, 1) - 1)) =
1289: upper(ame_util.approverUserId)) then
1290: memberOrigSystem := ame_util.fndUserOrigSystem;
1291: else

Line 1289: upper(ame_util.approverUserId)) then

1285: if(substrb(upper(tempGroupMembers(j)), 1, (instrb(tempGroupMembers(j), ':', 1, 1) - 1)) =
1286: upper(ame_util.approverPersonId)) then
1287: memberOrigSystem := ame_util.perOrigSystem;
1288: elsif (substrb(upper(tempGroupMembers(j)), 1, (instrb(tempGroupMembers(j), ':', 1, 1) - 1)) =
1289: upper(ame_util.approverUserId)) then
1290: memberOrigSystem := ame_util.fndUserOrigSystem;
1291: else
1292: memberOrigSystem :=
1293: substrb(tempGroupMembers(j), 1, (instrb(tempGroupMembers(j), ':', 1, 1)-1));

Line 1290: memberOrigSystem := ame_util.fndUserOrigSystem;

1286: upper(ame_util.approverPersonId)) then
1287: memberOrigSystem := ame_util.perOrigSystem;
1288: elsif (substrb(upper(tempGroupMembers(j)), 1, (instrb(tempGroupMembers(j), ':', 1, 1) - 1)) =
1289: upper(ame_util.approverUserId)) then
1290: memberOrigSystem := ame_util.fndUserOrigSystem;
1291: else
1292: memberOrigSystem :=
1293: substrb(tempGroupMembers(j), 1, (instrb(tempGroupMembers(j), ':', 1, 1)-1));
1294: memberOrigSystemId :=

Line 1323: errorMessage := ame_util.getMessage(applicationShortNameIn => 'PER',

1319: if(groupMemberCursor%isopen) then
1320: close groupMemberCursor;
1321: end if;
1322: errorCode := -20001;
1323: errorMessage := ame_util.getMessage(applicationShortNameIn => 'PER',
1324: messageNameIn => 'AME_400454_GRP_DYN_QRY_ERR');
1325: ame_util.runtimeException(packageNameIn => 'ame_api3',
1326: routineNameIn => 'getGroupMembers3',
1327: exceptionNumberIn => errorCode,

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

1321: end if;
1322: errorCode := -20001;
1323: errorMessage := ame_util.getMessage(applicationShortNameIn => 'PER',
1324: messageNameIn => 'AME_400454_GRP_DYN_QRY_ERR');
1325: ame_util.runtimeException(packageNameIn => 'ame_api3',
1326: routineNameIn => 'getGroupMembers3',
1327: exceptionNumberIn => errorCode,
1328: exceptionStringIn => errorMessage);
1329: raise_application_error(errorCode,

Line 1338: errorMessage := ame_util.getMessage(

1334: end if;
1335: errorCode := -20001;
1336: ame_api5.getApprovalGroupName(groupIdIn => groupIdIn
1337: ,groupNameOut => tempGroupName);
1338: errorMessage := ame_util.getMessage(
1339: applicationShortNameIn => 'PER',
1340: messageNameIn => 'AME_400455_GRP_DYN_NULL_TXID',
1341: tokenNameOneIn => 'APPROVAL_GROUP',
1342: tokenValueOneIn => tempGroupName);

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

1339: applicationShortNameIn => 'PER',
1340: messageNameIn => 'AME_400455_GRP_DYN_NULL_TXID',
1341: tokenNameOneIn => 'APPROVAL_GROUP',
1342: tokenValueOneIn => tempGroupName);
1343: ame_util.runtimeException(packageNameIn => 'ame_api3',
1344: routineNameIn => 'getGroupMembers3',
1345: exceptionNumberIn => errorCode,
1346: exceptionStringIn => errorMessage);
1347: raise_application_error(errorCode,

Line 1357: errorMessage := ame_util.getMessage(

1353: memberDisplayNamesOut.delete;
1354: errorCode := -20001;
1355: ame_api5.getApprovalGroupName(groupIdIn => groupIdIn
1356: ,groupNameOut => tempGroupName);
1357: errorMessage := ame_util.getMessage(
1358: applicationShortNameIn => 'PER',
1359: messageNameIn => 'AME_400798_GROUP_ITEM_BIND',
1360: tokenNameOneIn => 'APPROVER_GROUP',
1361: tokenValueOneIn => tempGroupName);

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

1358: applicationShortNameIn => 'PER',
1359: messageNameIn => 'AME_400798_GROUP_ITEM_BIND',
1360: tokenNameOneIn => 'APPROVER_GROUP',
1361: tokenValueOneIn => tempGroupName);
1362: ame_util.runtimeException(packageNameIn => 'ame_api3',
1363: routineNameIn => 'getGroupMembers3',
1364: exceptionNumberIn => errorCode,
1365: exceptionStringIn => errorMessage);
1366: raise_application_error(errorCode,

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

1368: when others then
1369: if(groupMemberCursor%isopen) then
1370: close groupMemberCursor;
1371: end if;
1372: ame_util.runtimeException(packageNameIn => 'ame_api3',
1373: routineNameIn => 'getGroupMembers3',
1374: exceptionNumberIn => sqlcode,
1375: exceptionStringIn => sqlerrm);
1376: raise;

Line 1382: memberNamesOut out nocopy ame_util.longStringList,

1378: procedure getGroupMembers4(applicationIdIn in number default null,
1379: transactionTypeIn in varchar2 default null,
1380: transactionIdIn in varchar2 default null,
1381: groupIdIn in number,
1382: memberNamesOut out nocopy ame_util.longStringList,
1383: memberOrderNumbersOut out nocopy ame_util.idList,
1384: memberDisplayNamesOut out nocopy ame_util.longStringList,
1385: memberOrigSystemIdsOut out nocopy ame_util.idList,
1386: memberOrigSystemsOut out nocopy ame_util.stringList)as

Line 1383: memberOrderNumbersOut out nocopy ame_util.idList,

1379: transactionTypeIn in varchar2 default null,
1380: transactionIdIn in varchar2 default null,
1381: groupIdIn in number,
1382: memberNamesOut out nocopy ame_util.longStringList,
1383: memberOrderNumbersOut out nocopy ame_util.idList,
1384: memberDisplayNamesOut out nocopy ame_util.longStringList,
1385: memberOrigSystemIdsOut out nocopy ame_util.idList,
1386: memberOrigSystemsOut out nocopy ame_util.stringList)as
1387: cursor groupMemberCursor(groupIdIn in integer) is

Line 1384: memberDisplayNamesOut out nocopy ame_util.longStringList,

1380: transactionIdIn in varchar2 default null,
1381: groupIdIn in number,
1382: memberNamesOut out nocopy ame_util.longStringList,
1383: memberOrderNumbersOut out nocopy ame_util.idList,
1384: memberDisplayNamesOut out nocopy ame_util.longStringList,
1385: memberOrigSystemIdsOut out nocopy ame_util.idList,
1386: memberOrigSystemsOut out nocopy ame_util.stringList)as
1387: cursor groupMemberCursor(groupIdIn in integer) is
1388: select

Line 1385: memberOrigSystemIdsOut out nocopy ame_util.idList,

1381: groupIdIn in number,
1382: memberNamesOut out nocopy ame_util.longStringList,
1383: memberOrderNumbersOut out nocopy ame_util.idList,
1384: memberDisplayNamesOut out nocopy ame_util.longStringList,
1385: memberOrigSystemIdsOut out nocopy ame_util.idList,
1386: memberOrigSystemsOut out nocopy ame_util.stringList)as
1387: cursor groupMemberCursor(groupIdIn in integer) is
1388: select
1389: orig_system,

Line 1386: memberOrigSystemsOut out nocopy ame_util.stringList)as

1382: memberNamesOut out nocopy ame_util.longStringList,
1383: memberOrderNumbersOut out nocopy ame_util.idList,
1384: memberDisplayNamesOut out nocopy ame_util.longStringList,
1385: memberOrigSystemIdsOut out nocopy ame_util.idList,
1386: memberOrigSystemsOut out nocopy ame_util.stringList)as
1387: cursor groupMemberCursor(groupIdIn in integer) is
1388: select
1389: orig_system,
1390: orig_system_id,

Line 1396: ame_util.approverOamGroupId, null,

1392: upper(parameter_name),
1393: query_string,
1394: order_number,
1395: decode(parameter_name,
1396: ame_util.approverOamGroupId, null,
1397: ame_approver_type_pkg.getWfRolesName(orig_system, orig_system_id)) approver_name,
1398: decode(parameter_name,
1399: ame_util.approverOamGroupId, null,
1400: ame_approver_type_pkg.getApproverDisplayName2(orig_system, orig_system_id)) display_name

Line 1399: ame_util.approverOamGroupId, null,

1395: decode(parameter_name,
1396: ame_util.approverOamGroupId, null,
1397: ame_approver_type_pkg.getWfRolesName(orig_system, orig_system_id)) approver_name,
1398: decode(parameter_name,
1399: ame_util.approverOamGroupId, null,
1400: ame_approver_type_pkg.getApproverDisplayName2(orig_system, orig_system_id)) display_name
1401: from ame_approval_group_members
1402: where
1403: approval_group_id = groupIdIn

Line 1410: displayNames ame_util.longStringList;

1406: noItemBindException exception;
1407: dynamicCursor integer;
1408: colonLocation1 integer;
1409: colonLocation2 integer;
1410: displayNames ame_util.longStringList;
1411: errorCode integer;
1412: errorMessage ame_util.longestStringType;
1413: approverNames ame_util.longStringList;
1414: noTransIdDefinedException exception;

Line 1412: errorMessage ame_util.longestStringType;

1408: colonLocation1 integer;
1409: colonLocation2 integer;
1410: displayNames ame_util.longStringList;
1411: errorCode integer;
1412: errorMessage ame_util.longestStringType;
1413: approverNames ame_util.longStringList;
1414: noTransIdDefinedException exception;
1415: orderNumbers ame_util.idList;
1416: origSystemIds ame_util.idList;

Line 1413: approverNames ame_util.longStringList;

1409: colonLocation2 integer;
1410: displayNames ame_util.longStringList;
1411: errorCode integer;
1412: errorMessage ame_util.longestStringType;
1413: approverNames ame_util.longStringList;
1414: noTransIdDefinedException exception;
1415: orderNumbers ame_util.idList;
1416: origSystemIds ame_util.idList;
1417: origSystems ame_util.stringList;

Line 1415: orderNumbers ame_util.idList;

1411: errorCode integer;
1412: errorMessage ame_util.longestStringType;
1413: approverNames ame_util.longStringList;
1414: noTransIdDefinedException exception;
1415: orderNumbers ame_util.idList;
1416: origSystemIds ame_util.idList;
1417: origSystems ame_util.stringList;
1418: outputIndex integer;
1419: parameters ame_util.longStringList;

Line 1416: origSystemIds ame_util.idList;

1412: errorMessage ame_util.longestStringType;
1413: approverNames ame_util.longStringList;
1414: noTransIdDefinedException exception;
1415: orderNumbers ame_util.idList;
1416: origSystemIds ame_util.idList;
1417: origSystems ame_util.stringList;
1418: outputIndex integer;
1419: parameters ame_util.longStringList;
1420: queryStrings ame_util.longestStringList;

Line 1417: origSystems ame_util.stringList;

1413: approverNames ame_util.longStringList;
1414: noTransIdDefinedException exception;
1415: orderNumbers ame_util.idList;
1416: origSystemIds ame_util.idList;
1417: origSystems ame_util.stringList;
1418: outputIndex integer;
1419: parameters ame_util.longStringList;
1420: queryStrings ame_util.longestStringList;
1421: rowsFound integer;

Line 1419: parameters ame_util.longStringList;

1415: orderNumbers ame_util.idList;
1416: origSystemIds ame_util.idList;
1417: origSystems ame_util.stringList;
1418: outputIndex integer;
1419: parameters ame_util.longStringList;
1420: queryStrings ame_util.longestStringList;
1421: rowsFound integer;
1422: tempGroupMembers dbms_sql.Varchar2_Table;
1423: upperParameterNames ame_util.stringList;

Line 1420: queryStrings ame_util.longestStringList;

1416: origSystemIds ame_util.idList;
1417: origSystems ame_util.stringList;
1418: outputIndex integer;
1419: parameters ame_util.longStringList;
1420: queryStrings ame_util.longestStringList;
1421: rowsFound integer;
1422: tempGroupMembers dbms_sql.Varchar2_Table;
1423: upperParameterNames ame_util.stringList;
1424: tempGroupName ame_util.stringType;

Line 1423: upperParameterNames ame_util.stringList;

1419: parameters ame_util.longStringList;
1420: queryStrings ame_util.longestStringList;
1421: rowsFound integer;
1422: tempGroupMembers dbms_sql.Varchar2_Table;
1423: upperParameterNames ame_util.stringList;
1424: tempGroupName ame_util.stringType;
1425: begin
1426: open groupMemberCursor(groupIdIn => groupIdIn);
1427: fetch groupMemberCursor bulk collect

Line 1424: tempGroupName ame_util.stringType;

1420: queryStrings ame_util.longestStringList;
1421: rowsFound integer;
1422: tempGroupMembers dbms_sql.Varchar2_Table;
1423: upperParameterNames ame_util.stringList;
1424: tempGroupName ame_util.stringType;
1425: begin
1426: open groupMemberCursor(groupIdIn => groupIdIn);
1427: fetch groupMemberCursor bulk collect
1428: into

Line 1440: if(upperParameterNames(i) = upper(ame_util.approverOamGroupId)) then

1436: displayNames;
1437: close groupMemberCursor;
1438: outputIndex := 0; /* pre-increment */
1439: for i in 1 .. parameters.count loop
1440: if(upperParameterNames(i) = upper(ame_util.approverOamGroupId)) then
1441: dynamicCursor := dbms_sql.open_cursor;
1442: dbms_sql.parse(dynamicCursor,
1443: ame_util.removeReturns(stringIn => queryStrings(i),
1444: replaceWithSpaces => true),

Line 1443: ame_util.removeReturns(stringIn => queryStrings(i),

1439: for i in 1 .. parameters.count loop
1440: if(upperParameterNames(i) = upper(ame_util.approverOamGroupId)) then
1441: dynamicCursor := dbms_sql.open_cursor;
1442: dbms_sql.parse(dynamicCursor,
1443: ame_util.removeReturns(stringIn => queryStrings(i),
1444: replaceWithSpaces => true),
1445: dbms_sql.native);
1446: if(instrb(queryStrings(i),
1447: ame_util.transactionIdPlaceholder) > 0) then

Line 1447: ame_util.transactionIdPlaceholder) > 0) then

1443: ame_util.removeReturns(stringIn => queryStrings(i),
1444: replaceWithSpaces => true),
1445: dbms_sql.native);
1446: if(instrb(queryStrings(i),
1447: ame_util.transactionIdPlaceholder) > 0) then
1448: if transactionIdIn is null then
1449: dbms_sql.close_cursor(dynamicCursor);
1450: raise noTransIdDefinedException;
1451: end if;

Line 1453: ame_util.transactionIdPlaceholder,

1449: dbms_sql.close_cursor(dynamicCursor);
1450: raise noTransIdDefinedException;
1451: end if;
1452: dbms_sql.bind_variable(dynamicCursor,
1453: ame_util.transactionIdPlaceholder,
1454: transactionIdIn,
1455: 50);
1456: end if;
1457: if(instrb(queryStrings(i),

Line 1458: ame_util2.itemClassPlaceHolder) > 0) then

1454: transactionIdIn,
1455: 50);
1456: end if;
1457: if(instrb(queryStrings(i),
1458: ame_util2.itemClassPlaceHolder) > 0) then
1459: dbms_sql.bind_variable(dynamicCursor,
1460: ame_util2.itemClassPlaceHolder,
1461: ame_util.headerItemClassName,
1462: 50);

Line 1460: ame_util2.itemClassPlaceHolder,

1456: end if;
1457: if(instrb(queryStrings(i),
1458: ame_util2.itemClassPlaceHolder) > 0) then
1459: dbms_sql.bind_variable(dynamicCursor,
1460: ame_util2.itemClassPlaceHolder,
1461: ame_util.headerItemClassName,
1462: 50);
1463: end if;
1464: if (instrb(queryStrings(i),

Line 1461: ame_util.headerItemClassName,

1457: if(instrb(queryStrings(i),
1458: ame_util2.itemClassPlaceHolder) > 0) then
1459: dbms_sql.bind_variable(dynamicCursor,
1460: ame_util2.itemClassPlaceHolder,
1461: ame_util.headerItemClassName,
1462: 50);
1463: end if;
1464: if (instrb(queryStrings(i),
1465: ame_util2.itemIdPlaceHolder) > 0) then

Line 1465: ame_util2.itemIdPlaceHolder) > 0) then

1461: ame_util.headerItemClassName,
1462: 50);
1463: end if;
1464: if (instrb(queryStrings(i),
1465: ame_util2.itemIdPlaceHolder) > 0) then
1466: if transactionIdIn is null then
1467: dbms_sql.close_cursor(dynamicCursor);
1468: raise noTransIdDefinedException;
1469: end if;

Line 1471: ame_util2.itemIdPlaceHolder,

1467: dbms_sql.close_cursor(dynamicCursor);
1468: raise noTransIdDefinedException;
1469: end if;
1470: dbms_sql.bind_variable(dynamicCursor,
1471: ame_util2.itemIdPlaceHolder,
1472: transactionIdIn,
1473: 50);
1474: end if;
1475: dbms_sql.define_array(dynamicCursor,

Line 1506: upper(ame_util.approverPersonId)) then

1502: if(colonLocation2 = 0) then /* first case (old style) */
1503: memberOrigSystemIdsOut(outputIndex) :=
1504: substrb(tempGroupMembers(j), (instrb(tempGroupMembers(j), ':', 1, 1) + 1));
1505: if(substrb(upper(tempGroupMembers(j)), 1, (instrb(tempGroupMembers(j), ':', 1, 1) - 1)) =
1506: upper(ame_util.approverPersonId)) then
1507: memberOrigSystemsOut(outputIndex) := ame_util.perOrigSystem;
1508: elsif (substrb(upper(tempGroupMembers(j)), 1, (instrb(tempGroupMembers(j), ':', 1, 1) - 1)) =
1509: upper(ame_util.approverUserId)) then
1510: memberOrigSystemsOut(outputIndex) := ame_util.fndUserOrigSystem;

Line 1507: memberOrigSystemsOut(outputIndex) := ame_util.perOrigSystem;

1503: memberOrigSystemIdsOut(outputIndex) :=
1504: substrb(tempGroupMembers(j), (instrb(tempGroupMembers(j), ':', 1, 1) + 1));
1505: if(substrb(upper(tempGroupMembers(j)), 1, (instrb(tempGroupMembers(j), ':', 1, 1) - 1)) =
1506: upper(ame_util.approverPersonId)) then
1507: memberOrigSystemsOut(outputIndex) := ame_util.perOrigSystem;
1508: elsif (substrb(upper(tempGroupMembers(j)), 1, (instrb(tempGroupMembers(j), ':', 1, 1) - 1)) =
1509: upper(ame_util.approverUserId)) then
1510: memberOrigSystemsOut(outputIndex) := ame_util.fndUserOrigSystem;
1511: else

Line 1509: upper(ame_util.approverUserId)) then

1505: if(substrb(upper(tempGroupMembers(j)), 1, (instrb(tempGroupMembers(j), ':', 1, 1) - 1)) =
1506: upper(ame_util.approverPersonId)) then
1507: memberOrigSystemsOut(outputIndex) := ame_util.perOrigSystem;
1508: elsif (substrb(upper(tempGroupMembers(j)), 1, (instrb(tempGroupMembers(j), ':', 1, 1) - 1)) =
1509: upper(ame_util.approverUserId)) then
1510: memberOrigSystemsOut(outputIndex) := ame_util.fndUserOrigSystem;
1511: else
1512: memberOrigSystemsOut(outputIndex) :=
1513: substrb(tempGroupMembers(j), 1, (instrb(tempGroupMembers(j), ':', 1, 1)-1));

Line 1510: memberOrigSystemsOut(outputIndex) := ame_util.fndUserOrigSystem;

1506: upper(ame_util.approverPersonId)) then
1507: memberOrigSystemsOut(outputIndex) := ame_util.perOrigSystem;
1508: elsif (substrb(upper(tempGroupMembers(j)), 1, (instrb(tempGroupMembers(j), ':', 1, 1) - 1)) =
1509: upper(ame_util.approverUserId)) then
1510: memberOrigSystemsOut(outputIndex) := ame_util.fndUserOrigSystem;
1511: else
1512: memberOrigSystemsOut(outputIndex) :=
1513: substrb(tempGroupMembers(j), 1, (instrb(tempGroupMembers(j), ':', 1, 1)-1));
1514: memberOrigSystemIdsOut(outputIndex) :=

Line 1545: errorMessage := ame_util.getMessage(applicationShortNameIn => 'PER',

1541: if(groupMemberCursor%isopen) then
1542: close groupMemberCursor;
1543: end if;
1544: errorCode := -20001;
1545: errorMessage := ame_util.getMessage(applicationShortNameIn => 'PER',
1546: messageNameIn => 'AME_400454_GRP_DYN_QRY_ERR');
1547: ame_util.runtimeException(packageNameIn => 'ame_api3',
1548: routineNameIn => 'getGroupMembers4',
1549: exceptionNumberIn => errorCode,

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

1543: end if;
1544: errorCode := -20001;
1545: errorMessage := ame_util.getMessage(applicationShortNameIn => 'PER',
1546: messageNameIn => 'AME_400454_GRP_DYN_QRY_ERR');
1547: ame_util.runtimeException(packageNameIn => 'ame_api3',
1548: routineNameIn => 'getGroupMembers4',
1549: exceptionNumberIn => errorCode,
1550: exceptionStringIn => errorMessage);
1551: raise_application_error(errorCode,

Line 1560: errorMessage := ame_util.getMessage(

1556: end if;
1557: errorCode := -20001;
1558: ame_api5.getApprovalGroupName(groupIdIn => groupIdIn
1559: ,groupNameOut => tempGroupName);
1560: errorMessage := ame_util.getMessage(
1561: applicationShortNameIn => 'PER',
1562: messageNameIn => 'AME_400455_GRP_DYN_NULL_TXID',
1563: tokenNameOneIn => 'APPROVAL_GROUP',
1564: tokenValueOneIn => tempGroupName);

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

1561: applicationShortNameIn => 'PER',
1562: messageNameIn => 'AME_400455_GRP_DYN_NULL_TXID',
1563: tokenNameOneIn => 'APPROVAL_GROUP',
1564: tokenValueOneIn => tempGroupName);
1565: ame_util.runtimeException(packageNameIn => 'ame_api3',
1566: routineNameIn => 'getGroupMembers4',
1567: exceptionNumberIn => errorCode,
1568: exceptionStringIn => errorMessage);
1569: raise_application_error(errorCode,

Line 1579: errorMessage := ame_util.getMessage(

1575: memberDisplayNamesOut.delete;
1576: errorCode := -20001;
1577: ame_api5.getApprovalGroupName(groupIdIn => groupIdIn
1578: ,groupNameOut => tempGroupName);
1579: errorMessage := ame_util.getMessage(
1580: applicationShortNameIn => 'PER',
1581: messageNameIn => 'AME_400798_GROUP_ITEM_BIND',
1582: tokenNameOneIn => 'APPROVER_GROUP',
1583: tokenValueOneIn => tempGroupName);

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

1580: applicationShortNameIn => 'PER',
1581: messageNameIn => 'AME_400798_GROUP_ITEM_BIND',
1582: tokenNameOneIn => 'APPROVER_GROUP',
1583: tokenValueOneIn => tempGroupName);
1584: ame_util.runtimeException(packageNameIn => 'ame_api3',
1585: routineNameIn => 'getGroupMembers4',
1586: exceptionNumberIn => errorCode,
1587: exceptionStringIn => errorMessage);
1588: raise_application_error(errorCode,

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

1590: when others then
1591: if(groupMemberCursor%isopen) then
1592: close groupMemberCursor;
1593: end if;
1594: ame_util.runtimeException(packageNameIn => 'ame_api3',
1595: routineNameIn => 'getGroupMembers4',
1596: exceptionNumberIn => sqlcode,
1597: exceptionStringIn => sqlerrm);
1598: raise;

Line 1602: itemClassIdsOut out nocopy ame_util.idList,

1598: raise;
1599: end getGroupMembers4;
1600: procedure getItemClasses( applicationIdIn in number,
1601: transactionTypeIn in varchar2,
1602: itemClassIdsOut out nocopy ame_util.idList,
1603: itemClassNamesOut out nocopy ame_util.stringList) as
1604: ameAppId integer;
1605: begin
1606: ameAppId := ame_admin_pkg.getApplicationId(fndAppIdIn => applicationIdIn,

Line 1603: itemClassNamesOut out nocopy ame_util.stringList) as

1599: end getGroupMembers4;
1600: procedure getItemClasses( applicationIdIn in number,
1601: transactionTypeIn in varchar2,
1602: itemClassIdsOut out nocopy ame_util.idList,
1603: itemClassNamesOut out nocopy ame_util.stringList) as
1604: ameAppId integer;
1605: begin
1606: ameAppId := ame_admin_pkg.getApplicationId(fndAppIdIn => applicationIdIn,
1607: transactionTypeIdIn => transactionTypeIn);

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

1609: itemClassIdsOut => itemClassIdsOut,
1610: itemClassNamesOut => itemClassNamesOut);
1611: exception
1612: when others then
1613: ame_util.runtimeException(packageNameIn => 'ame_api3',
1614: routineNameIn => 'getItemClasses',
1615: exceptionNumberIn => sqlcode,
1616: exceptionStringIn => sqlerrm);
1617: raise;

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

1622: begin
1623: itemClassIdOut := ame_admin_pkg.getItemClassIdByName(itemClassNameIn => itemClassNameIn);
1624: exception
1625: when others then
1626: ame_util.runtimeException(packageNameIn => 'ame_api3',
1627: routineNameIn => 'getItemClassId',
1628: exceptionNumberIn => sqlcode,
1629: exceptionStringIn => sqlerrm);
1630: raise;

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

1635: begin
1636: itemClassNameOut := ame_admin_pkg.getItemClassName(itemClassIdIn => itemClassIdIn);
1637: exception
1638: when others then
1639: ame_util.runtimeException(packageNameIn => 'ame_api3',
1640: routineNameIn => 'getItemClassName',
1641: exceptionNumberIn => sqlcode,
1642: exceptionStringIn => sqlerrm);
1643: raise;

Line 1648: oldApproversOut out nocopy ame_util.approversTable2) as

1644: end getItemClassName;
1645: procedure getOldApprovers( applicationIdIn in number,
1646: transactionTypeIn in varchar2,
1647: transactionIdIn in varchar2,
1648: oldApproversOut out nocopy ame_util.approversTable2) as
1649: ameAppId integer;
1650: cursor oldApproverCursor(applicationIdIn in integer,
1651: transactionIdIn in varchar2) is
1652: select

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

1694: oldApproversOut(tempIndex).source := null;
1695: end loop;
1696: exception
1697: when others then
1698: ame_util.runtimeException(packageNameIn => 'ame_api3',
1699: routineNameIn => 'getOldApprovers',
1700: exceptionNumberIn => sqlcode,
1701: exceptionStringIn => sqlerrm);
1702: oldApproversOut.delete;

Line 1711: conditionIdsOut out nocopy ame_util.idList,

1707: end getOldApprovers;
1708: procedure getRuleDetails1( ruleIdIn in number,
1709: ruleTypeOut out nocopy varchar2,
1710: ruleDescriptionOut out nocopy varchar2,
1711: conditionIdsOut out nocopy ame_util.idList,
1712: actionTypeNamesOut out nocopy ame_util.stringList,
1713: actionTypeDescriptionsOut out nocopy ame_util.stringList,
1714: actionDescriptionsOut out nocopy ame_util.stringList) as
1715: cursor actionCursor is

Line 1712: actionTypeNamesOut out nocopy ame_util.stringList,

1708: procedure getRuleDetails1( ruleIdIn in number,
1709: ruleTypeOut out nocopy varchar2,
1710: ruleDescriptionOut out nocopy varchar2,
1711: conditionIdsOut out nocopy ame_util.idList,
1712: actionTypeNamesOut out nocopy ame_util.stringList,
1713: actionTypeDescriptionsOut out nocopy ame_util.stringList,
1714: actionDescriptionsOut out nocopy ame_util.stringList) as
1715: cursor actionCursor is
1716: select

Line 1713: actionTypeDescriptionsOut out nocopy ame_util.stringList,

1709: ruleTypeOut out nocopy varchar2,
1710: ruleDescriptionOut out nocopy varchar2,
1711: conditionIdsOut out nocopy ame_util.idList,
1712: actionTypeNamesOut out nocopy ame_util.stringList,
1713: actionTypeDescriptionsOut out nocopy ame_util.stringList,
1714: actionDescriptionsOut out nocopy ame_util.stringList) as
1715: cursor actionCursor is
1716: select
1717: ame_action_types.name,

Line 1714: actionDescriptionsOut out nocopy ame_util.stringList) as

1710: ruleDescriptionOut out nocopy varchar2,
1711: conditionIdsOut out nocopy ame_util.idList,
1712: actionTypeNamesOut out nocopy ame_util.stringList,
1713: actionTypeDescriptionsOut out nocopy ame_util.stringList,
1714: actionDescriptionsOut out nocopy ame_util.stringList) as
1715: cursor actionCursor is
1716: select
1717: ame_action_types.name,
1718: ame_action_types.description,

Line 1730: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and

1726: ame_actions.action_id = ame_action_usages.action_id and
1727: ame_action_types.action_type_id = ame_actions.action_type_id and
1728: sysdate between
1729: ame_action_usages.start_date and
1730: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and
1731: sysdate between
1732: ame_action_types.start_date and
1733: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
1734: sysdate between

Line 1733: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and

1729: ame_action_usages.start_date and
1730: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and
1731: sysdate between
1732: ame_action_types.start_date and
1733: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
1734: sysdate between
1735: ame_actions.start_date and
1736: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate);
1737: cursor conditionCursor(ruleIdIn in integer) is

Line 1736: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate);

1732: ame_action_types.start_date and
1733: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
1734: sysdate between
1735: ame_actions.start_date and
1736: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate);
1737: cursor conditionCursor(ruleIdIn in integer) is
1738: select condition_id
1739: from ame_condition_usages
1740: where

Line 1744: nvl(end_date - ame_util.oneSecond, sysdate);

1740: where
1741: ame_condition_usages.rule_id = ruleIdIn and
1742: sysdate between
1743: start_date and
1744: nvl(end_date - ame_util.oneSecond, sysdate);
1745: cursor ruleCursor is
1746: select
1747: ame_rules.rule_type,
1748: ame_rules.description

Line 1755: nvl(ame_rules.end_date - ame_util.oneSecond, sysdate) ;

1751: where
1752: ame_rules.rule_id = ruleIdIn and
1753: sysdate between
1754: ame_rules.start_date and
1755: nvl(ame_rules.end_date - ame_util.oneSecond, sysdate) ;
1756: begin
1757: open ruleCursor;
1758: fetch ruleCursor into
1759: ruleTypeOut,

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

1770: into conditionIdsOut;
1771: close conditionCursor;
1772: exception
1773: when others then
1774: ame_util.runtimeException(packageNameIn => 'ame_api3',
1775: routineNameIn => 'getRuleDetails1',
1776: exceptionNumberIn => sqlcode,
1777: exceptionStringIn => sqlerrm);
1778: conditionIdsOut.delete;

Line 1784: conditionDescriptionsOut out nocopy ame_util.longestStringList,

1780: end getRuleDetails1;
1781: procedure getRuleDetails2( ruleIdIn in number,
1782: ruleTypeOut out nocopy varchar2,
1783: ruleDescriptionOut out nocopy varchar2,
1784: conditionDescriptionsOut out nocopy ame_util.longestStringList,
1785: actionTypeNamesOut out nocopy ame_util.stringList,
1786: actionTypeDescriptionsOut out nocopy ame_util.stringList,
1787: actionDescriptionsOut out nocopy ame_util.stringList) as
1788: cursor actionCursor is

Line 1785: actionTypeNamesOut out nocopy ame_util.stringList,

1781: procedure getRuleDetails2( ruleIdIn in number,
1782: ruleTypeOut out nocopy varchar2,
1783: ruleDescriptionOut out nocopy varchar2,
1784: conditionDescriptionsOut out nocopy ame_util.longestStringList,
1785: actionTypeNamesOut out nocopy ame_util.stringList,
1786: actionTypeDescriptionsOut out nocopy ame_util.stringList,
1787: actionDescriptionsOut out nocopy ame_util.stringList) as
1788: cursor actionCursor is
1789: select

Line 1786: actionTypeDescriptionsOut out nocopy ame_util.stringList,

1782: ruleTypeOut out nocopy varchar2,
1783: ruleDescriptionOut out nocopy varchar2,
1784: conditionDescriptionsOut out nocopy ame_util.longestStringList,
1785: actionTypeNamesOut out nocopy ame_util.stringList,
1786: actionTypeDescriptionsOut out nocopy ame_util.stringList,
1787: actionDescriptionsOut out nocopy ame_util.stringList) as
1788: cursor actionCursor is
1789: select
1790: ame_action_types.name,

Line 1787: actionDescriptionsOut out nocopy ame_util.stringList) as

1783: ruleDescriptionOut out nocopy varchar2,
1784: conditionDescriptionsOut out nocopy ame_util.longestStringList,
1785: actionTypeNamesOut out nocopy ame_util.stringList,
1786: actionTypeDescriptionsOut out nocopy ame_util.stringList,
1787: actionDescriptionsOut out nocopy ame_util.stringList) as
1788: cursor actionCursor is
1789: select
1790: ame_action_types.name,
1791: ame_action_types.description,

Line 1803: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and

1799: ame_actions.action_id = ame_action_usages.action_id and
1800: ame_action_types.action_type_id = ame_actions.action_type_id and
1801: sysdate between
1802: ame_action_usages.start_date and
1803: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and
1804: sysdate between
1805: ame_action_types.start_date and
1806: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
1807: sysdate between

Line 1806: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and

1802: ame_action_usages.start_date and
1803: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and
1804: sysdate between
1805: ame_action_types.start_date and
1806: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
1807: sysdate between
1808: ame_actions.start_date and
1809: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate);
1810: cursor conditionCursor(ruleIdIn in integer) is

Line 1809: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate);

1805: ame_action_types.start_date and
1806: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
1807: sysdate between
1808: ame_actions.start_date and
1809: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate);
1810: cursor conditionCursor(ruleIdIn in integer) is
1811: select ame_condition_pkg.getDescription(ame_condition_usages.condition_id)
1812: from ame_condition_usages
1813: where

Line 1817: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate);

1813: where
1814: ame_condition_usages.rule_id = ruleIdIn and
1815: sysdate between
1816: ame_condition_usages.start_date and
1817: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate);
1818: cursor ruleCursor is
1819: select
1820: ame_rules.rule_type,
1821: ame_rules.description

Line 1828: nvl(ame_rules.end_date - ame_util.oneSecond, sysdate) ;

1824: where
1825: ame_rules.rule_id = ruleIdIn and
1826: sysdate between
1827: ame_rules.start_date and
1828: nvl(ame_rules.end_date - ame_util.oneSecond, sysdate) ;
1829: begin
1830: open ruleCursor;
1831: fetch ruleCursor into
1832: ruleTypeOut,

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

1843: into conditionDescriptionsOut;
1844: close conditionCursor;
1845: exception
1846: when others then
1847: ame_util.runtimeException(packageNameIn => 'ame_api3',
1848: routineNameIn => 'getRuleDetails2',
1849: exceptionNumberIn => sqlcode,
1850: exceptionStringIn => sqlerrm);
1851: conditionDescriptionsOut.delete;

Line 1857: conditionIdsOut out nocopy ame_util.idList,

1853: end getRuleDetails2;
1854: procedure getRuleDetails3( ruleIdIn in number,
1855: ruleTypeOut out nocopy varchar2,
1856: ruleDescriptionOut out nocopy varchar2,
1857: conditionIdsOut out nocopy ame_util.idList,
1858: conditionDescriptionsOut out nocopy ame_util.longestStringList,
1859: conditionHasLOVsOut out nocopy ame_util.charList,
1860: actionTypeNamesOut out nocopy ame_util.stringList,
1861: actionTypeDescriptionsOut out nocopy ame_util.stringList,

Line 1858: conditionDescriptionsOut out nocopy ame_util.longestStringList,

1854: procedure getRuleDetails3( ruleIdIn in number,
1855: ruleTypeOut out nocopy varchar2,
1856: ruleDescriptionOut out nocopy varchar2,
1857: conditionIdsOut out nocopy ame_util.idList,
1858: conditionDescriptionsOut out nocopy ame_util.longestStringList,
1859: conditionHasLOVsOut out nocopy ame_util.charList,
1860: actionTypeNamesOut out nocopy ame_util.stringList,
1861: actionTypeDescriptionsOut out nocopy ame_util.stringList,
1862: actionDescriptionsOut out nocopy ame_util.stringList) as

Line 1859: conditionHasLOVsOut out nocopy ame_util.charList,

1855: ruleTypeOut out nocopy varchar2,
1856: ruleDescriptionOut out nocopy varchar2,
1857: conditionIdsOut out nocopy ame_util.idList,
1858: conditionDescriptionsOut out nocopy ame_util.longestStringList,
1859: conditionHasLOVsOut out nocopy ame_util.charList,
1860: actionTypeNamesOut out nocopy ame_util.stringList,
1861: actionTypeDescriptionsOut out nocopy ame_util.stringList,
1862: actionDescriptionsOut out nocopy ame_util.stringList) as
1863: cursor actionCursor is

Line 1860: actionTypeNamesOut out nocopy ame_util.stringList,

1856: ruleDescriptionOut out nocopy varchar2,
1857: conditionIdsOut out nocopy ame_util.idList,
1858: conditionDescriptionsOut out nocopy ame_util.longestStringList,
1859: conditionHasLOVsOut out nocopy ame_util.charList,
1860: actionTypeNamesOut out nocopy ame_util.stringList,
1861: actionTypeDescriptionsOut out nocopy ame_util.stringList,
1862: actionDescriptionsOut out nocopy ame_util.stringList) as
1863: cursor actionCursor is
1864: select

Line 1861: actionTypeDescriptionsOut out nocopy ame_util.stringList,

1857: conditionIdsOut out nocopy ame_util.idList,
1858: conditionDescriptionsOut out nocopy ame_util.longestStringList,
1859: conditionHasLOVsOut out nocopy ame_util.charList,
1860: actionTypeNamesOut out nocopy ame_util.stringList,
1861: actionTypeDescriptionsOut out nocopy ame_util.stringList,
1862: actionDescriptionsOut out nocopy ame_util.stringList) as
1863: cursor actionCursor is
1864: select
1865: ame_action_types.name,

Line 1862: actionDescriptionsOut out nocopy ame_util.stringList) as

1858: conditionDescriptionsOut out nocopy ame_util.longestStringList,
1859: conditionHasLOVsOut out nocopy ame_util.charList,
1860: actionTypeNamesOut out nocopy ame_util.stringList,
1861: actionTypeDescriptionsOut out nocopy ame_util.stringList,
1862: actionDescriptionsOut out nocopy ame_util.stringList) as
1863: cursor actionCursor is
1864: select
1865: ame_action_types.name,
1866: ame_action_types.description,

Line 1878: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and

1874: ame_actions.action_id = ame_action_usages.action_id and
1875: ame_action_types.action_type_id = ame_actions.action_type_id and
1876: sysdate between
1877: ame_action_usages.start_date and
1878: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and
1879: sysdate between
1880: ame_action_types.start_date and
1881: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
1882: sysdate between

Line 1881: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and

1877: ame_action_usages.start_date and
1878: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and
1879: sysdate between
1880: ame_action_types.start_date and
1881: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
1882: sysdate between
1883: ame_actions.start_date and
1884: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate);
1885: cursor conditionCursor(ruleIdIn in integer) is

Line 1884: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate);

1880: ame_action_types.start_date and
1881: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
1882: sysdate between
1883: ame_actions.start_date and
1884: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate);
1885: cursor conditionCursor(ruleIdIn in integer) is
1886: select
1887: ame_conditions.condition_id,
1888: ame_condition_pkg.getDescription(ame_conditions.condition_id),

Line 1890: ame_util.stringAttributeType, ame_util.booleanTrue,

1886: select
1887: ame_conditions.condition_id,
1888: ame_condition_pkg.getDescription(ame_conditions.condition_id),
1889: decode(ame_attributes.attribute_type,
1890: ame_util.stringAttributeType, ame_util.booleanTrue,
1891: /* default */ ame_util.booleanFalse)
1892: from
1893: ame_conditions,
1894: ame_condition_usages,

Line 1891: /* default */ ame_util.booleanFalse)

1887: ame_conditions.condition_id,
1888: ame_condition_pkg.getDescription(ame_conditions.condition_id),
1889: decode(ame_attributes.attribute_type,
1890: ame_util.stringAttributeType, ame_util.booleanTrue,
1891: /* default */ ame_util.booleanFalse)
1892: from
1893: ame_conditions,
1894: ame_condition_usages,
1895: ame_attributes

Line 1902: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate) and

1898: ame_conditions.condition_id = ame_condition_usages.condition_id and
1899: ame_attributes.attribute_id = ame_conditions.attribute_id and
1900: sysdate between
1901: ame_condition_usages.start_date and
1902: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate) and
1903: sysdate between
1904: ame_conditions.start_date and
1905: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
1906: sysdate between

Line 1905: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and

1901: ame_condition_usages.start_date and
1902: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate) and
1903: sysdate between
1904: ame_conditions.start_date and
1905: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
1906: sysdate between
1907: ame_attributes.start_date and
1908: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate);
1909: cursor ruleCursor is

Line 1908: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate);

1904: ame_conditions.start_date and
1905: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
1906: sysdate between
1907: ame_attributes.start_date and
1908: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate);
1909: cursor ruleCursor is
1910: select
1911: ame_rules.rule_type,
1912: ame_rules.description

Line 1919: nvl(ame_rules.end_date - ame_util.oneSecond, sysdate) ;

1915: where
1916: ame_rules.rule_id = ruleIdIn and
1917: sysdate between
1918: ame_rules.start_date and
1919: nvl(ame_rules.end_date - ame_util.oneSecond, sysdate) ;
1920: begin
1921: open ruleCursor;
1922: fetch ruleCursor into
1923: ruleTypeOut,

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

1937: conditionHasLOVsOut;
1938: close conditionCursor;
1939: exception
1940: when others then
1941: ame_util.runtimeException(packageNameIn => 'ame_api3',
1942: routineNameIn => 'getRuleDetails3',
1943: exceptionNumberIn => sqlcode,
1944: exceptionStringIn => sqlerrm);
1945: conditionDescriptionsOut.delete;

Line 1953: approverIn in ame_util.approverRecord2,

1949: end getRuleDetails3;
1950: procedure insertApprover( applicationIdIn in number,
1951: transactionTypeIn in varchar2,
1952: transactionIdIn in varchar2,
1953: approverIn in ame_util.approverRecord2,
1954: positionIn in number,
1955: insertionIn in ame_util.insertionRecord2) as
1956: ameApplicationId integer;
1957: absoluteOrder integer;

Line 1955: insertionIn in ame_util.insertionRecord2) as

1951: transactionTypeIn in varchar2,
1952: transactionIdIn in varchar2,
1953: approverIn in ame_util.approverRecord2,
1954: positionIn in number,
1955: insertionIn in ame_util.insertionRecord2) as
1956: ameApplicationId integer;
1957: absoluteOrder integer;
1958: availableInsertions ame_util.insertionsTable2;
1959: badInsertionTypeException exception;

Line 1958: availableInsertions ame_util.insertionsTable2;

1954: positionIn in number,
1955: insertionIn in ame_util.insertionRecord2) as
1956: ameApplicationId integer;
1957: absoluteOrder integer;
1958: availableInsertions ame_util.insertionsTable2;
1959: badInsertionTypeException exception;
1960: badStatusException exception;
1961: disallowedAuthException exception;
1962: errorCode integer;

Line 1963: errorMessage ame_util.longStringType;

1959: badInsertionTypeException exception;
1960: badStatusException exception;
1961: disallowedAuthException exception;
1962: errorCode integer;
1963: errorMessage ame_util.longStringType;
1964: incompatibleApproverException exception;
1965: insertionOrder integer;
1966: insertionTypeNotFound boolean;
1967: noApproverCategoryException exception;

Line 1989: ( approverIn.approver_category <> ame_util.approvalApproverCategory and

1985: raise incompatibleApproverException;
1986: end if;
1987: /* Make sure that the approver catgeory is defined correctly for approver */
1988: if (( approverIn.approver_category is null ) or
1989: ( approverIn.approver_category <> ame_util.approvalApproverCategory and
1990: approverIn.approver_category <> ame_util.fyiApproverCategory)) then
1991: raise noApproverCategoryException;
1992: end if;
1993: /* Handler ame_util.firstApprover order types specially. */

Line 1990: approverIn.approver_category <> ame_util.fyiApproverCategory)) then

1986: end if;
1987: /* Make sure that the approver catgeory is defined correctly for approver */
1988: if (( approverIn.approver_category is null ) or
1989: ( approverIn.approver_category <> ame_util.approvalApproverCategory and
1990: approverIn.approver_category <> ame_util.fyiApproverCategory)) then
1991: raise noApproverCategoryException;
1992: end if;
1993: /* Handler ame_util.firstApprover order types specially. */
1994: if(insertionIn.order_type = ame_util.firstAuthority) then

Line 1993: /* Handler ame_util.firstApprover order types specially. */

1989: ( approverIn.approver_category <> ame_util.approvalApproverCategory and
1990: approverIn.approver_category <> ame_util.fyiApproverCategory)) then
1991: raise noApproverCategoryException;
1992: end if;
1993: /* Handler ame_util.firstApprover order types specially. */
1994: if(insertionIn.order_type = ame_util.firstAuthority) then
1995: ame_api2.setFirstAuthorityApprover(applicationIdIn => applicationIdIn,
1996: transactionTypeIn => transactionTypeIn,
1997: transactionIdIn => transactionIdIn,

Line 1994: if(insertionIn.order_type = ame_util.firstAuthority) then

1990: approverIn.approver_category <> ame_util.fyiApproverCategory)) then
1991: raise noApproverCategoryException;
1992: end if;
1993: /* Handler ame_util.firstApprover order types specially. */
1994: if(insertionIn.order_type = ame_util.firstAuthority) then
1995: ame_api2.setFirstAuthorityApprover(applicationIdIn => applicationIdIn,
1996: transactionTypeIn => transactionTypeIn,
1997: transactionIdIn => transactionIdIn,
1998: approverIn => approverIn,

Line 1999: clearChainStatusYNIn => ame_util.booleanFalse);

1995: ame_api2.setFirstAuthorityApprover(applicationIdIn => applicationIdIn,
1996: transactionTypeIn => transactionTypeIn,
1997: transactionIdIn => transactionIdIn,
1998: approverIn => approverIn,
1999: clearChainStatusYNIn => ame_util.booleanFalse);
2000: return;
2001: end if;
2002: /* Make sure approverIn.approval_status is null. */
2003: if(approverIn.approval_status is not null) then

Line 2007: if(approverIn.api_insertion = ame_util.oamGenerated) then

2003: if(approverIn.approval_status is not null) then
2004: raise badStatusException;
2005: end if;
2006: /* Make sure approverIn.api_insertion is of the right type. */
2007: if(approverIn.api_insertion = ame_util.oamGenerated) then
2008: raise badInsertionTypeException;
2009: end if;
2010: /* Lock Transactions */
2011: ame_engine.lockTransaction(fndApplicationIdIn => applicationIdIn,

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

2099: transactionIdIn => transactionIdIn,
2100: transactionTypeIdIn => transactionTypeIn);
2101: errorCode := -20001;
2102: errorMessage := ambiguousApproverMessage;
2103: ame_util.runtimeException(packageNameIn => 'ame_api3',
2104: routineNameIn => 'insertApprover',
2105: exceptionNumberIn => errorCode,
2106: exceptionStringIn => errorMessage);
2107: raise_application_error(errorCode,

Line 2114: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',

2110: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,
2111: transactionIdIn => transactionIdIn,
2112: transactionTypeIdIn => transactionTypeIn);
2113: errorCode := -20001;
2114: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
2115: messageNameIn => 'AME_400240_API_INV_ORDER_TYPE');
2116: ame_util.runtimeException(packageNameIn => 'ame_api3',
2117: routineNameIn => 'insertApprover',
2118: exceptionNumberIn => errorCode,

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

2112: transactionTypeIdIn => transactionTypeIn);
2113: errorCode := -20001;
2114: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
2115: messageNameIn => 'AME_400240_API_INV_ORDER_TYPE');
2116: ame_util.runtimeException(packageNameIn => 'ame_api3',
2117: routineNameIn => 'insertApprover',
2118: exceptionNumberIn => errorCode,
2119: exceptionStringIn => errorMessage);
2120: raise_application_error(errorCode,

Line 2127: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',

2123: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,
2124: transactionIdIn => transactionIdIn,
2125: transactionTypeIdIn => transactionTypeIn);
2126: errorCode := -20001;
2127: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
2128: messageNameIn => 'AME_400241_API_NON_NULL_INSAPP');
2129: ame_util.runtimeException(packageNameIn => 'ame_api3',
2130: routineNameIn => 'insertApprover',
2131: exceptionNumberIn => errorCode,

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

2125: transactionTypeIdIn => transactionTypeIn);
2126: errorCode := -20001;
2127: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
2128: messageNameIn => 'AME_400241_API_NON_NULL_INSAPP');
2129: ame_util.runtimeException(packageNameIn => 'ame_api3',
2130: routineNameIn => 'insertApprover',
2131: exceptionNumberIn => errorCode,
2132: exceptionStringIn => errorMessage);
2133: raise_application_error(errorCode,

Line 2140: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',

2136: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,
2137: transactionIdIn => transactionIdIn,
2138: transactionTypeIdIn => transactionTypeIn);
2139: errorCode := -20001;
2140: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
2141: messageNameIn => 'AME_400446_INCMPTBLE_APPR_INS');
2142: ame_util.runtimeException(packageNameIn => 'ame_api3',
2143: routineNameIn => 'insertApprover',
2144: exceptionNumberIn => errorCode,

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

2138: transactionTypeIdIn => transactionTypeIn);
2139: errorCode := -20001;
2140: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
2141: messageNameIn => 'AME_400446_INCMPTBLE_APPR_INS');
2142: ame_util.runtimeException(packageNameIn => 'ame_api3',
2143: routineNameIn => 'insertApprover',
2144: exceptionNumberIn => errorCode,
2145: exceptionStringIn => errorMessage);
2146: raise_application_error(errorCode,

Line 2153: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',

2149: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,
2150: transactionIdIn => transactionIdIn,
2151: transactionTypeIdIn => transactionTypeIn);
2152: errorCode := -20001;
2153: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
2154: messageNameIn => 'AME_400447_INVALID_APPR_CATG');
2155: ame_util.runtimeException(packageNameIn => 'ame_api3',
2156: routineNameIn => 'insertApprover',
2157: exceptionNumberIn => errorCode,

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

2151: transactionTypeIdIn => transactionTypeIn);
2152: errorCode := -20001;
2153: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
2154: messageNameIn => 'AME_400447_INVALID_APPR_CATG');
2155: ame_util.runtimeException(packageNameIn => 'ame_api3',
2156: routineNameIn => 'insertApprover',
2157: exceptionNumberIn => errorCode,
2158: exceptionStringIn => errorMessage);
2159: raise_application_error(errorCode,

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

2161: when others then
2162: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,
2163: transactionIdIn => transactionIdIn,
2164: transactionTypeIdIn => transactionTypeIn);
2165: ame_util.runtimeException(packageNameIn => 'ame_api3',
2166: routineNameIn => 'insertApprover',
2167: exceptionNumberIn => sqlcode,
2168: exceptionStringIn => sqlerrm);
2169: raise;

Line 2173: ruleIdListOut out nocopy ame_util.idList) as

2169: raise;
2170: end insertApprover;
2171: procedure parseApproverSource(approverSourceIn in varchar2,
2172: sourceDescriptionOut out nocopy varchar2,
2173: ruleIdListOut out nocopy ame_util.idList) as
2174: begin
2175: ame_util.parseSourceValue(sourceValueIn => approverSourceIn,
2176: sourceDescriptionOut => sourceDescriptionOut,
2177: ruleIdListOut => ruleIdListOut);

Line 2175: ame_util.parseSourceValue(sourceValueIn => approverSourceIn,

2171: procedure parseApproverSource(approverSourceIn in varchar2,
2172: sourceDescriptionOut out nocopy varchar2,
2173: ruleIdListOut out nocopy ame_util.idList) as
2174: begin
2175: ame_util.parseSourceValue(sourceValueIn => approverSourceIn,
2176: sourceDescriptionOut => sourceDescriptionOut,
2177: ruleIdListOut => ruleIdListOut);
2178: end parseApproverSource;
2179: procedure suppressApprover(applicationIdIn in number,

Line 2182: approverIn in ame_util.approverRecord2) as

2178: end parseApproverSource;
2179: procedure suppressApprover(applicationIdIn in number,
2180: transactionTypeIn in varchar2,
2181: transactionIdIn in varchar2,
2182: approverIn in ame_util.approverRecord2) as
2183: ameApplicationId integer;
2184: approverIndex integer;
2185: approvers ame_util.approversTable2;
2186: allowDeletingOamApprovers ame_util.attributeValueType;

Line 2185: approvers ame_util.approversTable2;

2181: transactionIdIn in varchar2,
2182: approverIn in ame_util.approverRecord2) as
2183: ameApplicationId integer;
2184: approverIndex integer;
2185: approvers ame_util.approversTable2;
2186: allowDeletingOamApprovers ame_util.attributeValueType;
2187: badDeletionException exception;
2188: errorCode integer;
2189: errorMessage ame_util.longStringType;

Line 2186: allowDeletingOamApprovers ame_util.attributeValueType;

2182: approverIn in ame_util.approverRecord2) as
2183: ameApplicationId integer;
2184: approverIndex integer;
2185: approvers ame_util.approversTable2;
2186: allowDeletingOamApprovers ame_util.attributeValueType;
2187: badDeletionException exception;
2188: errorCode integer;
2189: errorMessage ame_util.longStringType;
2190: noMatchException exception;

Line 2189: errorMessage ame_util.longStringType;

2185: approvers ame_util.approversTable2;
2186: allowDeletingOamApprovers ame_util.attributeValueType;
2187: badDeletionException exception;
2188: errorCode integer;
2189: errorMessage ame_util.longStringType;
2190: noMatchException exception;
2191: orderTypeLocation integer;
2192: parameterLocation integer;
2193: ruleIdList ame_util.idList;

Line 2193: ruleIdList ame_util.idList;

2189: errorMessage ame_util.longStringType;
2190: noMatchException exception;
2191: orderTypeLocation integer;
2192: parameterLocation integer;
2193: ruleIdList ame_util.idList;
2194: sourceDescription ame_util.stringType;
2195: sourceLength integer;
2196: tempOrderType ame_temp_insertions.order_type%type;
2197: tempParameter ame_temp_insertions.parameter%type;

Line 2194: sourceDescription ame_util.stringType;

2190: noMatchException exception;
2191: orderTypeLocation integer;
2192: parameterLocation integer;
2193: ruleIdList ame_util.idList;
2194: sourceDescription ame_util.stringType;
2195: sourceLength integer;
2196: tempOrderType ame_temp_insertions.order_type%type;
2197: tempParameter ame_temp_insertions.parameter%type;
2198: upperLimit integer;

Line 2205: nameList ame_util.longStringList;

2201: from ame_temp_insertions
2202: where application_id = ame_engine.getAmeApplicationId
2203: and transaction_id = transactionIdIn
2204: and parameter = parameterIn);
2205: nameList ame_util.longStringList;
2206: anchorsExistException exception;
2207: cmpParameter ame_temp_insertions.parameter%type;
2208: anchorName varchar2(320);
2209: anchorList varchar2(1000);

Line 2262: (ame_util.exceptionStatus,

2258: approverIndex := null;
2259: for i in 1 .. upperLimit loop
2260: if((approvers(i).approval_status is null or
2261: approvers(i).approval_status in
2262: (ame_util.exceptionStatus,
2263: ame_util.noResponseStatus,
2264: ame_util.notifiedStatus,
2265: ame_util.rejectStatus)) and
2266: ame_engine.approversMatch(approverRecord1In => approverIn,

Line 2263: ame_util.noResponseStatus,

2259: for i in 1 .. upperLimit loop
2260: if((approvers(i).approval_status is null or
2261: approvers(i).approval_status in
2262: (ame_util.exceptionStatus,
2263: ame_util.noResponseStatus,
2264: ame_util.notifiedStatus,
2265: ame_util.rejectStatus)) and
2266: ame_engine.approversMatch(approverRecord1In => approverIn,
2267: approverRecord2In => approvers(i))) then

Line 2264: ame_util.notifiedStatus,

2260: if((approvers(i).approval_status is null or
2261: approvers(i).approval_status in
2262: (ame_util.exceptionStatus,
2263: ame_util.noResponseStatus,
2264: ame_util.notifiedStatus,
2265: ame_util.rejectStatus)) and
2266: ame_engine.approversMatch(approverRecord1In => approverIn,
2267: approverRecord2In => approvers(i))) then
2268: approverIndex := i;

Line 2265: ame_util.rejectStatus)) and

2261: approvers(i).approval_status in
2262: (ame_util.exceptionStatus,
2263: ame_util.noResponseStatus,
2264: ame_util.notifiedStatus,
2265: ame_util.rejectStatus)) and
2266: ame_engine.approversMatch(approverRecord1In => approverIn,
2267: approverRecord2In => approvers(i))) then
2268: approverIndex := i;
2269: if approvers(approverIndex).api_insertion = ame_util.apiInsertion then

Line 2269: if approvers(approverIndex).api_insertion = ame_util.apiInsertion then

2265: ame_util.rejectStatus)) and
2266: ame_engine.approversMatch(approverRecord1In => approverIn,
2267: approverRecord2In => approvers(i))) then
2268: approverIndex := i;
2269: if approvers(approverIndex).api_insertion = ame_util.apiInsertion then
2270: anchorName := approvers(i).name;
2271: cmpParameter := approvers(i).name ||
2272: ame_util.fieldDelimiter ||
2273: approvers(i).item_class ||

Line 2272: ame_util.fieldDelimiter ||

2268: approverIndex := i;
2269: if approvers(approverIndex).api_insertion = ame_util.apiInsertion then
2270: anchorName := approvers(i).name;
2271: cmpParameter := approvers(i).name ||
2272: ame_util.fieldDelimiter ||
2273: approvers(i).item_class ||
2274: ame_util.fieldDelimiter ||
2275: approvers(i).item_id ||
2276: ame_util.fieldDelimiter ||

Line 2274: ame_util.fieldDelimiter ||

2270: anchorName := approvers(i).name;
2271: cmpParameter := approvers(i).name ||
2272: ame_util.fieldDelimiter ||
2273: approvers(i).item_class ||
2274: ame_util.fieldDelimiter ||
2275: approvers(i).item_id ||
2276: ame_util.fieldDelimiter ||
2277: approvers(i).action_type_id ||
2278: ame_util.fieldDelimiter ||

Line 2276: ame_util.fieldDelimiter ||

2272: ame_util.fieldDelimiter ||
2273: approvers(i).item_class ||
2274: ame_util.fieldDelimiter ||
2275: approvers(i).item_id ||
2276: ame_util.fieldDelimiter ||
2277: approvers(i).action_type_id ||
2278: ame_util.fieldDelimiter ||
2279: approvers(i).group_or_chain_id ||
2280: ame_util.fieldDelimiter ||

Line 2278: ame_util.fieldDelimiter ||

2274: ame_util.fieldDelimiter ||
2275: approvers(i).item_id ||
2276: ame_util.fieldDelimiter ||
2277: approvers(i).action_type_id ||
2278: ame_util.fieldDelimiter ||
2279: approvers(i).group_or_chain_id ||
2280: ame_util.fieldDelimiter ||
2281: approvers(i).occurrence;
2282: open getAnchorInsertions(cmpParameter);

Line 2280: ame_util.fieldDelimiter ||

2276: ame_util.fieldDelimiter ||
2277: approvers(i).action_type_id ||
2278: ame_util.fieldDelimiter ||
2279: approvers(i).group_or_chain_id ||
2280: ame_util.fieldDelimiter ||
2281: approvers(i).occurrence;
2282: open getAnchorInsertions(cmpParameter);
2283: fetch getAnchorInsertions bulk collect into nameList;
2284: if nameList.count > 0 then

Line 2299: ame_util.parseSourceValue(sourceValueIn => approvers(approverIndex).source,

2295: raise noMatchException;
2296: end if;
2297: ameApplicationId := ame_engine.getAmeApplicationId;
2298: -- parse the source to see if the approver was inserted.
2299: ame_util.parseSourceValue(sourceValueIn => approvers(approverIndex).source,
2300: sourceDescriptionOut => sourceDescription,
2301: ruleIdListOut => ruleIdList);
2302: -- If the approver was inserted, delete the approver from ame_temp_insertions.
2303: -- If the approver was OAM generated, check whether deleting OAM-generated approvers

Line 2306: if(approvers(approverIndex).api_insertion = ame_util.oamGenerated or

2302: -- If the approver was inserted, delete the approver from ame_temp_insertions.
2303: -- If the approver was OAM generated, check whether deleting OAM-generated approvers
2304: -- is allowed. If so, record the deletion.
2305: --
2306: if(approvers(approverIndex).api_insertion = ame_util.oamGenerated or
2307: sourceDescription = ame_util.ruleGeneratedSource or
2308: sourceDescription = ame_util.surrogateSource) then
2309: allowDeletingOamApprovers :=
2310: ame_engine.getHeaderAttValue2(attributeNameIn => ame_util.allowDeletingOamApprovers);

Line 2307: sourceDescription = ame_util.ruleGeneratedSource or

2303: -- If the approver was OAM generated, check whether deleting OAM-generated approvers
2304: -- is allowed. If so, record the deletion.
2305: --
2306: if(approvers(approverIndex).api_insertion = ame_util.oamGenerated or
2307: sourceDescription = ame_util.ruleGeneratedSource or
2308: sourceDescription = ame_util.surrogateSource) then
2309: allowDeletingOamApprovers :=
2310: ame_engine.getHeaderAttValue2(attributeNameIn => ame_util.allowDeletingOamApprovers);
2311: if(allowDeletingOamApprovers <> ame_util.booleanAttributeTrue) then

Line 2308: sourceDescription = ame_util.surrogateSource) then

2304: -- is allowed. If so, record the deletion.
2305: --
2306: if(approvers(approverIndex).api_insertion = ame_util.oamGenerated or
2307: sourceDescription = ame_util.ruleGeneratedSource or
2308: sourceDescription = ame_util.surrogateSource) then
2309: allowDeletingOamApprovers :=
2310: ame_engine.getHeaderAttValue2(attributeNameIn => ame_util.allowDeletingOamApprovers);
2311: if(allowDeletingOamApprovers <> ame_util.booleanAttributeTrue) then
2312: raise badDeletionException;

Line 2310: ame_engine.getHeaderAttValue2(attributeNameIn => ame_util.allowDeletingOamApprovers);

2306: if(approvers(approverIndex).api_insertion = ame_util.oamGenerated or
2307: sourceDescription = ame_util.ruleGeneratedSource or
2308: sourceDescription = ame_util.surrogateSource) then
2309: allowDeletingOamApprovers :=
2310: ame_engine.getHeaderAttValue2(attributeNameIn => ame_util.allowDeletingOamApprovers);
2311: if(allowDeletingOamApprovers <> ame_util.booleanAttributeTrue) then
2312: raise badDeletionException;
2313: end if;
2314: insert into ame_temp_deletions(

Line 2311: if(allowDeletingOamApprovers <> ame_util.booleanAttributeTrue) then

2307: sourceDescription = ame_util.ruleGeneratedSource or
2308: sourceDescription = ame_util.surrogateSource) then
2309: allowDeletingOamApprovers :=
2310: ame_engine.getHeaderAttValue2(attributeNameIn => ame_util.allowDeletingOamApprovers);
2311: if(allowDeletingOamApprovers <> ame_util.booleanAttributeTrue) then
2312: raise badDeletionException;
2313: end if;
2314: insert into ame_temp_deletions(
2315: transaction_id,

Line 2391: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',

2387: anchorList := anchorList || '; ';
2388: end if;
2389: end loop;
2390: errorCode := -20001;
2391: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
2392: messageNameIn => 'AME_400651_ANCHORS_EXIST',
2393: tokenNameOneIn => 'APPROVER',
2394: tokenValueOneIn => ame_approver_type_pkg.getApproverDescription(anchorName),
2395: tokenNameTwoIn => 'ANCHORED_APPROVERS',

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

2393: tokenNameOneIn => 'APPROVER',
2394: tokenValueOneIn => ame_approver_type_pkg.getApproverDescription(anchorName),
2395: tokenNameTwoIn => 'ANCHORED_APPROVERS',
2396: tokenValueTwoIn => anchorList);
2397: ame_util.runtimeException(packageNameIn => 'ame_api3',
2398: routineNameIn => 'suppressApprover',
2399: exceptionNumberIn => errorCode,
2400: exceptionStringIn => errorMessage);
2401: raise_application_error(errorCode,

Line 2408: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',

2404: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,
2405: transactionIdIn => transactionIdIn,
2406: transactionTypeIdIn => transactionTypeIn);
2407: errorCode := -20001;
2408: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
2409: messageNameIn => 'AME_400814_NULL_SUPPR_APPR_FLD',
2410: tokenNameOneIn => 'APPROVER_REC_PARAMS',
2411: tokenValueOneIn=>appr_rec_params);
2412: ame_util.runtimeException(packageNameIn => 'ame_api3',

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

2408: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
2409: messageNameIn => 'AME_400814_NULL_SUPPR_APPR_FLD',
2410: tokenNameOneIn => 'APPROVER_REC_PARAMS',
2411: tokenValueOneIn=>appr_rec_params);
2412: ame_util.runtimeException(packageNameIn => 'ame_api3',
2413: routineNameIn => 'suppressApprover',
2414: exceptionNumberIn => errorCode,
2415: exceptionStringIn => errorMessage);
2416: raise_application_error(errorCode,

Line 2423: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',

2419: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,
2420: transactionIdIn => transactionIdIn,
2421: transactionTypeIdIn => transactionTypeIn);
2422: errorCode := -20001;
2423: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
2424: messageNameIn => 'AME_400236_API_ADRGA_TRUE');
2425: ame_util.runtimeException(packageNameIn => 'ame_api3',
2426: routineNameIn => 'suppressApprover',
2427: exceptionNumberIn => errorCode,

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

2421: transactionTypeIdIn => transactionTypeIn);
2422: errorCode := -20001;
2423: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
2424: messageNameIn => 'AME_400236_API_ADRGA_TRUE');
2425: ame_util.runtimeException(packageNameIn => 'ame_api3',
2426: routineNameIn => 'suppressApprover',
2427: exceptionNumberIn => errorCode,
2428: exceptionStringIn => errorMessage);
2429: raise_application_error(errorCode,

Line 2436: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',

2432: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,
2433: transactionIdIn => transactionIdIn,
2434: transactionTypeIdIn => transactionTypeIn);
2435: errorCode := -20001;
2436: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
2437: messageNameIn => 'AME_400237_API_NO MATCH_APPR');
2438: ame_util.runtimeException(packageNameIn => 'ame_api3',
2439: routineNameIn => 'suppressApprover',
2440: exceptionNumberIn => errorCode,

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

2434: transactionTypeIdIn => transactionTypeIn);
2435: errorCode := -20001;
2436: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
2437: messageNameIn => 'AME_400237_API_NO MATCH_APPR');
2438: ame_util.runtimeException(packageNameIn => 'ame_api3',
2439: routineNameIn => 'suppressApprover',
2440: exceptionNumberIn => errorCode,
2441: exceptionStringIn => errorMessage);
2442: raise_application_error(errorCode,

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

2444: when others then
2445: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,
2446: transactionIdIn => transactionIdIn,
2447: transactionTypeIdIn => transactionTypeIn);
2448: ame_util.runtimeException(packageNameIn => 'ame_api3',
2449: routineNameIn => 'suppressApprover',
2450: exceptionNumberIn => sqlcode,
2451: exceptionStringIn => sqlerrm);
2452: raise;

Line 2457: approversIn in ame_util.approversTable2) as

2453: end suppressApprover;
2454: procedure suppressApprovers(applicationIdIn in integer,
2455: transactionTypeIn in varchar2,
2456: transactionIdIn in varchar2,
2457: approversIn in ame_util.approversTable2) as
2458: currentApproverInIndex integer;
2459: lastApproverInIndex integer;
2460: nextApproverInIndex integer;
2461: begin

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

2476: currentApproverInIndex := approversIn.next(currentApproverInIndex);
2477: end loop;
2478: exception
2479: when others then
2480: ame_util.runtimeException(packageNameIn => 'ame_api3',
2481: routineNameIn => 'suppressApprovers',
2482: exceptionNumberIn => sqlcode,
2483: exceptionStringIn => sqlerrm);
2484: raise;