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_ENGINE

Line 32: where application_id = ame_engine.getAmeApplicationId

28: appr_rec_params varchar2(100);
29: cursor getAnchorInsertions (parameterIn varchar2) is
30: (select name
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;

Line 43: ame_engine.lockTransaction(fndApplicationIdIn => applicationIdIn,

39: anchorList varchar2(1000);
40: approvers ame_util.approversTable2;
41: nullApprRecordFieldException Exception;
42: begin
43: ame_engine.lockTransaction(fndApplicationIdIn => applicationIdIn,
44: transactionIdIn => transactionIdIn,
45: transactionTypeIdIn => transactionTypeIn);
46: ameAppId := ame_admin_pkg.getApplicationId(fndAppIdIn => applicationIdIn,
47: transactionTypeIdIn => transactionTypeIn);

Line 61: ame_engine.updateTransactionState(isTestTransactionIn => false,

57: end if;
58: if appr_rec_params is not null then
59: raise nullApprRecordFieldException;
60: end if;
61: ame_engine.updateTransactionState(isTestTransactionIn => false,
62: isLocalTransactionIn => false,
63: fetchConfigVarsIn => true,
64: fetchOldApproversIn => true,
65: fetchInsertionsIn => true,

Line 81: ame_engine.getApprovers(approversOut => approvers);

77: transactionIdIn => transactionIdIn,
78: ameApplicationIdIn => null,
79: fndApplicationIdIn => applicationIdIn,
80: transactionTypeIdIn => transactionTypeIn );
81: ame_engine.getApprovers(approversOut => approvers);
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

Line 112: ame_engine.updateInsertions(indexIn => i);

108: for i in 1 .. approvers.count loop
109: if approvers(i).name = approverIn.name and
110: approvers(i).item_class = approverIn.item_class and
111: approvers(i).item_id = approverIn.item_id then
112: ame_engine.updateInsertions(indexIn => i);
113: end if;
114: end loop;
115: delete from ame_temp_insertions
116: where

Line 127: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,

123: ame_approver_deviation_pkg.clearDeviationState(
124: applicationIdIn => ameAppId
125: ,transactionIdIn => transactionIdIn );
126: end if;
127: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,
128: transactionIdIn => transactionIdIn,
129: transactionTypeIdIn => transactionTypeIn);
130: exception
131: when anchorsExistException then

Line 132: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,

128: transactionIdIn => transactionIdIn,
129: transactionTypeIdIn => transactionTypeIn);
130: exception
131: when anchorsExistException then
132: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,
133: transactionIdIn => transactionIdIn,
134: transactionTypeIdIn => transactionTypeIn);
135: anchorList := '';
136: for i in 1 .. nameList.count loop

Line 156: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,

152: exceptionStringIn => errorMessage);
153: raise_application_error(errorCode,
154: errorMessage);
155: when nullApprRecordFieldException then
156: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,
157: transactionIdIn => transactionIdIn,
158: transactionTypeIdIn => transactionTypeIn);
159: errorCode := -20319;
160: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',

Line 171: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,

167: exceptionStringIn => errorMessage);
168: raise_application_error(errorCode,
169: errorMessage);
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',

Line 185: ame_engine.lockTransaction(fndApplicationIdIn => applicationIdIn,

181: transactionTypeIn in varchar2,
182: transactionIdIn in varchar2) as
183: ameAppId integer;
184: begin
185: ame_engine.lockTransaction(fndApplicationIdIn => applicationIdIn,
186: transactionIdIn => transactionIdIn,
187: transactionTypeIdIn => transactionTypeIn);
188: ameAppId := ame_admin_pkg.getApplicationId(fndAppIdIn => applicationIdIn,
189: transactionTypeIdIn => transactionTypeIn);

Line 199: ame_engine.updateTransactionState(isTestTransactionIn => false,

195: ame_approver_deviation_pkg.clearDeviationState(
196: applicationIdIn => ameAppId
197: ,transactionIdIn => transactionIdIn );
198: end if;
199: ame_engine.updateTransactionState(isTestTransactionIn => false,
200: isLocalTransactionIn => false,
201: fetchConfigVarsIn => true,
202: fetchOldApproversIn => true,
203: fetchInsertionsIn => true,

Line 219: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,

215: transactionIdIn => transactionIdIn,
216: ameApplicationIdIn => null,
217: fndApplicationIdIn => applicationIdIn,
218: transactionTypeIdIn => transactionTypeIn );
219: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,
220: transactionIdIn => transactionIdIn,
221: transactionTypeIdIn => transactionTypeIn);
222: exception
223: when others then

Line 224: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,

220: transactionIdIn => transactionIdIn,
221: transactionTypeIdIn => transactionTypeIn);
222: exception
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',

Line 243: ame_engine.lockTransaction(fndApplicationIdIn => applicationIdIn,

239: errorMessage ame_util.longStringType;
240: appr_rec_params varchar2(100);
241: nullApprRecordFieldException Exception;
242: begin
243: ame_engine.lockTransaction(fndApplicationIdIn => applicationIdIn,
244: transactionIdIn => transactionIdIn,
245: transactionTypeIdIn => transactionTypeIn);
246: ameAppId := ame_admin_pkg.getApplicationId(fndAppIdIn => applicationIdIn,
247: transactionTypeIdIn => transactionTypeIn);

Line 285: ame_engine.updateTransactionState(isTestTransactionIn => false,

281: --
282: -- Cycle the engine to account for changes in the deletions table. (There is no previous
283: -- call to initializePlsqlContext, so all of the boolean arguments need to be true.)
284: --
285: ame_engine.updateTransactionState(isTestTransactionIn => false,
286: isLocalTransactionIn => false,
287: fetchConfigVarsIn => true,
288: fetchOldApproversIn => true,
289: fetchInsertionsIn => true,

Line 305: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,

301: transactionIdIn => transactionIdIn,
302: ameApplicationIdIn => null,
303: fndApplicationIdIn => applicationIdIn,
304: transactionTypeIdIn => transactionTypeIn );
305: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,
306: transactionIdIn => transactionIdIn,
307: transactionTypeIdIn => transactionTypeIn);
308: exception
309: when nullApprRecordFieldException then

Line 310: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,

306: transactionIdIn => transactionIdIn,
307: transactionTypeIdIn => transactionTypeIn);
308: exception
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',

Line 325: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,

321: exceptionStringIn => errorMessage);
322: raise_application_error(errorCode,
323: errorMessage);
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',

Line 339: ame_engine.lockTransaction(fndApplicationIdIn => applicationIdIn,

335: transactionTypeIn in varchar2,
336: transactionIdIn in varchar2) as
337: ameAppId integer;
338: begin
339: ame_engine.lockTransaction(fndApplicationIdIn => applicationIdIn,
340: transactionIdIn => transactionIdIn,
341: transactionTypeIdIn => transactionTypeIn);
342: ameAppId := ame_admin_pkg.getApplicationId(fndAppIdIn => applicationIdIn,
343: transactionTypeIdIn => transactionTypeIn);

Line 353: ame_engine.updateTransactionState(isTestTransactionIn => false,

349: ame_approver_deviation_pkg.clearDeviationState(
350: applicationIdIn => ameAppId
351: ,transactionIdIn => transactionIdIn );
352: end if;
353: ame_engine.updateTransactionState(isTestTransactionIn => false,
354: isLocalTransactionIn => false,
355: fetchConfigVarsIn => true,
356: fetchOldApproversIn => true,
357: fetchInsertionsIn => true,

Line 373: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,

369: transactionIdIn => transactionIdIn,
370: ameApplicationIdIn => null,
371: fndApplicationIdIn => applicationIdIn,
372: transactionTypeIdIn => transactionTypeIn );
373: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,
374: transactionIdIn => transactionIdIn,
375: transactionTypeIdIn => transactionTypeIn);
376: exception
377: when others then

Line 378: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,

374: transactionIdIn => transactionIdIn,
375: transactionTypeIdIn => transactionTypeIn);
376: exception
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',

Line 429: ame_engine.updateTransactionState(isTestTransactionIn => false,

425: processProductionRules := false;
426: else
427: processProductionRules := true;
428: end if;
429: ame_engine.updateTransactionState(isTestTransactionIn => false,
430: isLocalTransactionIn => false,
431: fetchConfigVarsIn => true,
432: fetchOldApproversIn => true,
433: fetchInsertionsIn => true,

Line 449: ame_engine.getApplicableRules

445: transactionIdIn => transactionIdIn,
446: ameApplicationIdIn => null,
447: fndApplicationIdIn => applicationIdIn,
448: transactionTypeIdIn => transactionTypeIn );
449: ame_engine.getApplicableRules
450: (ruleIdsOut => ruleIdsOut
451: ,ruleDescriptionsOut => ruleDescriptions);
452: exception
453: when others then

Line 480: ame_engine.updateTransactionState(isTestTransactionIn => false,

476: processProductionRules := false;
477: else
478: processProductionRules := true;
479: end if;
480: ame_engine.updateTransactionState(isTestTransactionIn => false,
481: isLocalTransactionIn => false,
482: fetchConfigVarsIn => true,
483: fetchOldApproversIn => true,
484: fetchInsertionsIn => true,

Line 500: ame_engine.getApplicableRules

496: transactionIdIn => transactionIdIn,
497: ameApplicationIdIn => null,
498: fndApplicationIdIn => applicationIdIn,
499: transactionTypeIdIn => transactionTypeIn );
500: ame_engine.getApplicableRules
501: (ruleIdsOut => ruleIds
502: ,ruleDescriptionsOut => ruleDescriptionsOut);
503: exception
504: when others then

Line 531: ame_engine.updateTransactionState(isTestTransactionIn => false,

527: processProductionRules := false;
528: else
529: processProductionRules := true;
530: end if;
531: ame_engine.updateTransactionState(isTestTransactionIn => false,
532: isLocalTransactionIn => false,
533: fetchConfigVarsIn => true,
534: fetchOldApproversIn => true,
535: fetchInsertionsIn => true,

Line 551: ame_engine.getApplicableRules

547: transactionIdIn => transactionIdIn,
548: ameApplicationIdIn => null,
549: fndApplicationIdIn => applicationIdIn,
550: transactionTypeIdIn => transactionTypeIn);
551: ame_engine.getApplicableRules
552: (ruleIdsOut => ruleIdsOut
553: ,ruleDescriptionsOut => ruleDescriptionsOut);
554: exception
555: when others then

Line 603: ame_engine.updateTransactionState(isTestTransactionIn => false,

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,
606: fetchOldApproversIn => false,
607: fetchInsertionsIn => false,

Line 630: ame_engine.getItemAttValues2(attributeNameIn => attributeNameIn,

626: itemId := transactionIdIn;
627: else
628: itemId := itemIdIn;
629: end if;
630: ame_engine.getItemAttValues2(attributeNameIn => attributeNameIn,
631: itemIdIn => itemId,
632: attributeValue1Out => attributeValue1Out,
633: attributeValue2Out => attributeValue2Out,
634: attributeValue3Out => attributeValue3Out);

Line 657: ame_engine.updateTransactionState(isTestTransactionIn => false,

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,
660: fetchOldApproversIn => true,
661: fetchInsertionsIn => true,

Line 678: ame_engine.getInsertions

674: ameApplicationIdIn => null,
675: fndApplicationIdIn => applicationIdIn,
676: transactionTypeIdIn => transactionTypeIn );
677:
678: ame_engine.getInsertions
679: (positionIn => positionIn
680: ,coaInsertionsYNIn => ame_util.booleanTrue
681: ,orderTypeIn => orderTypeIn
682: ,availableInsertionsOut => availableInsertionsOut

Line 2168: ame_engine.lockTransaction(fndApplicationIdIn => applicationIdIn,

2164: if(approverIn.api_insertion = ame_util.oamGenerated) then
2165: raise badInsertionTypeException;
2166: end if;
2167: /* Lock Transactions */
2168: ame_engine.lockTransaction(fndApplicationIdIn => applicationIdIn,
2169: transactionIdIn => transactionIdIn,
2170: transactionTypeIdIn => transactionTypeIn);
2171: /*
2172: Check that only allowed insertion-order and approver-type values are passed, by calling

Line 2197: insertionOrder := ame_engine.getNextInsertionOrder;

2193: if(insertionTypeNotFound) then
2194: raise badInsertionTypeException;
2195: end if;
2196: /* Perform the insertion. */
2197: insertionOrder := ame_engine.getNextInsertionOrder;
2198: ameApplicationId := ame_engine.getAmeApplicationId;
2199: insert into ame_temp_insertions(
2200: transaction_id,
2201: application_id,

Line 2198: ameApplicationId := ame_engine.getAmeApplicationId;

2194: raise badInsertionTypeException;
2195: end if;
2196: /* Perform the insertion. */
2197: insertionOrder := ame_engine.getNextInsertionOrder;
2198: ameApplicationId := ame_engine.getAmeApplicationId;
2199: insert into ame_temp_insertions(
2200: transaction_id,
2201: application_id,
2202: insertion_order,

Line 2230: ame_engine.updateTransactionState(isTestTransactionIn => false,

2226: sysdate,
2227: ame_approver_deviation_pkg.insertReason
2228: );
2229: /* Cycle the engine to account for changes in the insertions table. */
2230: ame_engine.updateTransactionState(isTestTransactionIn => false,
2231: isLocalTransactionIn => false,
2232: fetchConfigVarsIn => true,
2233: fetchOldApproversIn => true,
2234: fetchInsertionsIn => true,

Line 2250: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,

2246: transactionIdIn => transactionIdIn,
2247: ameApplicationIdIn => null,
2248: fndApplicationIdIn => applicationIdIn,
2249: transactionTypeIdIn => transactionTypeIn );
2250: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,
2251: transactionIdIn => transactionIdIn,
2252: transactionTypeIdIn => transactionTypeIn);
2253: exception
2254: when ambiguousApproverException then

Line 2255: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,

2251: transactionIdIn => transactionIdIn,
2252: transactionTypeIdIn => transactionTypeIn);
2253: exception
2254: when ambiguousApproverException then
2255: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,
2256: transactionIdIn => transactionIdIn,
2257: transactionTypeIdIn => transactionTypeIn);
2258: errorCode := -20001;
2259: errorMessage := ambiguousApproverMessage;

Line 2267: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,

2263: exceptionStringIn => errorMessage);
2264: raise_application_error(errorCode,
2265: errorMessage);
2266: when badInsertionTypeException then
2267: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,
2268: transactionIdIn => transactionIdIn,
2269: transactionTypeIdIn => transactionTypeIn);
2270: errorCode := -20304;
2271: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',

Line 2280: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,

2276: exceptionStringIn => errorMessage);
2277: raise_application_error(errorCode,
2278: errorMessage);
2279: when badStatusException then
2280: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,
2281: transactionIdIn => transactionIdIn,
2282: transactionTypeIdIn => transactionTypeIn);
2283: errorCode := -20305;
2284: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',

Line 2293: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,

2289: exceptionStringIn => errorMessage);
2290: raise_application_error(errorCode,
2291: errorMessage);
2292: when incompatibleApproverException then
2293: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,
2294: transactionIdIn => transactionIdIn,
2295: transactionTypeIdIn => transactionTypeIn);
2296: errorCode := -20313;
2297: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',

Line 2306: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,

2302: exceptionStringIn => errorMessage);
2303: raise_application_error(errorCode,
2304: errorMessage);
2305: when noApproverCategoryException then
2306: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,
2307: transactionIdIn => transactionIdIn,
2308: transactionTypeIdIn => transactionTypeIn);
2309: errorCode := -20314;
2310: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',

Line 2319: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,

2315: exceptionStringIn => errorMessage);
2316: raise_application_error(errorCode,
2317: errorMessage);
2318: when others then
2319: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,
2320: transactionIdIn => transactionIdIn,
2321: transactionTypeIdIn => transactionTypeIn);
2322: ame_util.runtimeException(packageNameIn => 'ame_api3',
2323: routineNameIn => 'insertApprover',

Line 2487: where application_id = ame_engine.getAmeApplicationId

2483: upperLimit integer;
2484: cursor getAnchorInsertions (parameterIn varchar2) is
2485: (select name
2486: from ame_temp_insertions
2487: where application_id = ame_engine.getAmeApplicationId
2488: and transaction_id = transactionIdIn
2489: and parameter = parameterIn);
2490: nameList ame_util.longStringList;
2491: anchorsExistException exception;

Line 2500: ame_engine.lockTransaction(fndApplicationIdIn => applicationIdIn,

2496: nullApprRecordFieldException Exception;
2497: l_count number;
2498: l_orderType varchar2(50);
2499: begin
2500: ame_engine.lockTransaction(fndApplicationIdIn => applicationIdIn,
2501: transactionIdIn => transactionIdIn,
2502: transactionTypeIdIn => transactionTypeIn);
2503: appr_rec_params:=null;
2504: if(approverIn.name is null) then

Line 2552: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,

2548: and fnd_application_id = applicationIdIn
2549: and transaction_type_id = transactionTypeIn) and
2550: transaction_id = transactionIdIn and
2551: name = approverIn.name;
2552: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,
2553: transactionIdIn => transactionIdIn,
2554: transactionTypeIdIn => transactionTypeIn);
2555: return;
2556: end if;

Line 2573: ame_engine.updateTransactionState(isTestTransactionIn => false,

2569: end if;
2570: if appr_rec_params is not null then
2571: raise nullApprRecordFieldException;
2572: end if;
2573: ame_engine.updateTransactionState(isTestTransactionIn => false,
2574: isLocalTransactionIn => false,
2575: fetchConfigVarsIn => true,
2576: fetchOldApproversIn => true,
2577: fetchInsertionsIn => true,

Line 2594: ame_engine.getApprovers(approversOut => approvers);

2590: ameApplicationIdIn => null,
2591: fndApplicationIdIn => applicationIdIn,
2592: transactionTypeIdIn => transactionTypeIn );
2593: /* Try to match the approver. */
2594: ame_engine.getApprovers(approversOut => approvers);
2595: upperLimit := approvers.count;
2596: approverIndex := null;
2597: for i in 1 .. upperLimit loop
2598: if((approvers(i).approval_status is null or

Line 2604: ame_engine.approversMatch(approverRecord1In => approverIn,

2600: (ame_util.exceptionStatus,
2601: ame_util.noResponseStatus,
2602: ame_util.notifiedStatus,
2603: ame_util.rejectStatus)) and
2604: ame_engine.approversMatch(approverRecord1In => approverIn,
2605: approverRecord2In => approvers(i))) then
2606: approverIndex := i;
2607: if approvers(approverIndex).api_insertion = ame_util.apiInsertion then
2608: anchorName := approvers(i).name;

Line 2635: ameApplicationId := ame_engine.getAmeApplicationId;

2631: -- If there is no match, raise an exception.
2632: if(approverIndex is null) then
2633: raise noMatchException;
2634: end if;
2635: ameApplicationId := ame_engine.getAmeApplicationId;
2636: -- parse the source to see if the approver was inserted.
2637: ame_util.parseSourceValue(sourceValueIn => approvers(approverIndex).source,
2638: sourceDescriptionOut => sourceDescription,
2639: ruleIdListOut => ruleIdList);

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

2644: if(approvers(approverIndex).api_insertion = ame_util.oamGenerated or
2645: sourceDescription = ame_util.ruleGeneratedSource or
2646: sourceDescription = ame_util.surrogateSource) then
2647: allowDeletingOamApprovers :=
2648: ame_engine.getHeaderAttValue2(attributeNameIn => ame_util.allowDeletingOamApprovers);
2649: if(allowDeletingOamApprovers <> ame_util.booleanAttributeTrue) then
2650: raise badDeletionException;
2651: end if;
2652: insert into ame_temp_deletions(

Line 2681: ame_engine.updateInsertions(indexIn => i);

2677: for i in 1 .. approvers.count loop
2678: if approvers(i).name = approverIn.name and
2679: approvers(i).item_class = approverIn.item_class and
2680: approvers(i).item_id = approverIn.item_id then
2681: ame_engine.updateInsertions(indexIn => i);
2682: end if;
2683: end loop;
2684: delete from ame_temp_insertions
2685: where

Line 2693: ame_engine.updateTransactionState(isTestTransactionIn => false,

2689: item_class = approvers(approverIndex).item_class and
2690: item_id = approvers(approverIndex).item_id ;
2691: end if;
2692: -- Cycle the engine to account for changes in the deletions table.
2693: ame_engine.updateTransactionState(isTestTransactionIn => false,
2694: isLocalTransactionIn => false,
2695: fetchConfigVarsIn => true,
2696: fetchOldApproversIn => true,
2697: fetchInsertionsIn => true,

Line 2713: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,

2709: transactionIdIn => transactionIdIn,
2710: ameApplicationIdIn => null,
2711: fndApplicationIdIn => applicationIdIn,
2712: transactionTypeIdIn => transactionTypeIn );
2713: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,
2714: transactionIdIn => transactionIdIn,
2715: transactionTypeIdIn => transactionTypeIn);
2716: exception
2717: when anchorsExistException then

Line 2718: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,

2714: transactionIdIn => transactionIdIn,
2715: transactionTypeIdIn => transactionTypeIn);
2716: exception
2717: when anchorsExistException then
2718: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,
2719: transactionIdIn => transactionIdIn,
2720: transactionTypeIdIn => transactionTypeIn);
2721: anchorList := '';
2722: for i in 1 .. nameList.count loop

Line 2742: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,

2738: exceptionStringIn => errorMessage);
2739: raise_application_error(errorCode,
2740: errorMessage);
2741: when nullApprRecordFieldException then
2742: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,
2743: transactionIdIn => transactionIdIn,
2744: transactionTypeIdIn => transactionTypeIn);
2745: errorCode := -20320;
2746: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',

Line 2757: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,

2753: exceptionStringIn => errorMessage);
2754: raise_application_error(errorCode,
2755: errorMessage);
2756: when badDeletionException then
2757: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,
2758: transactionIdIn => transactionIdIn,
2759: transactionTypeIdIn => transactionTypeIn);
2760: errorCode := -20301;
2761: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',

Line 2770: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,

2766: exceptionStringIn => errorMessage);
2767: raise_application_error(errorCode,
2768: errorMessage);
2769: when noMatchException then
2770: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,
2771: transactionIdIn => transactionIdIn,
2772: transactionTypeIdIn => transactionTypeIn);
2773: errorCode := -20302;
2774: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',

Line 2783: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,

2779: exceptionStringIn => errorMessage);
2780: raise_application_error(errorCode,
2781: errorMessage);
2782: when others then
2783: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,
2784: transactionIdIn => transactionIdIn,
2785: transactionTypeIdIn => transactionTypeIn);
2786: ame_util.runtimeException(packageNameIn => 'ame_api3',
2787: routineNameIn => 'suppressApprover',