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 := -20001;
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 2011: ame_engine.lockTransaction(fndApplicationIdIn => applicationIdIn,

2007: if(approverIn.api_insertion = ame_util.oamGenerated) then
2008: raise badInsertionTypeException;
2009: end if;
2010: /* Lock Transactions */
2011: ame_engine.lockTransaction(fndApplicationIdIn => applicationIdIn,
2012: transactionIdIn => transactionIdIn,
2013: transactionTypeIdIn => transactionTypeIn);
2014: /*
2015: Check that only allowed insertion-order and approver-type values are passed, by calling

Line 2040: insertionOrder := ame_engine.getNextInsertionOrder;

2036: if(insertionTypeNotFound) then
2037: raise badInsertionTypeException;
2038: end if;
2039: /* Perform the insertion. */
2040: insertionOrder := ame_engine.getNextInsertionOrder;
2041: ameApplicationId := ame_engine.getAmeApplicationId;
2042: insert into ame_temp_insertions(
2043: transaction_id,
2044: application_id,

Line 2041: ameApplicationId := ame_engine.getAmeApplicationId;

2037: raise badInsertionTypeException;
2038: end if;
2039: /* Perform the insertion. */
2040: insertionOrder := ame_engine.getNextInsertionOrder;
2041: ameApplicationId := ame_engine.getAmeApplicationId;
2042: insert into ame_temp_insertions(
2043: transaction_id,
2044: application_id,
2045: insertion_order,

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

2069: sysdate,
2070: ame_approver_deviation_pkg.insertReason
2071: );
2072: /* Cycle the engine to account for changes in the insertions table. */
2073: ame_engine.updateTransactionState(isTestTransactionIn => false,
2074: isLocalTransactionIn => false,
2075: fetchConfigVarsIn => true,
2076: fetchOldApproversIn => true,
2077: fetchInsertionsIn => true,

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

2089: transactionIdIn => transactionIdIn,
2090: ameApplicationIdIn => null,
2091: fndApplicationIdIn => applicationIdIn,
2092: transactionTypeIdIn => transactionTypeIn );
2093: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,
2094: transactionIdIn => transactionIdIn,
2095: transactionTypeIdIn => transactionTypeIn);
2096: exception
2097: when ambiguousApproverException then

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

2094: transactionIdIn => transactionIdIn,
2095: transactionTypeIdIn => transactionTypeIn);
2096: exception
2097: when ambiguousApproverException then
2098: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,
2099: transactionIdIn => transactionIdIn,
2100: transactionTypeIdIn => transactionTypeIn);
2101: errorCode := -20001;
2102: errorMessage := ambiguousApproverMessage;

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

2106: exceptionStringIn => errorMessage);
2107: raise_application_error(errorCode,
2108: errorMessage);
2109: when badInsertionTypeException then
2110: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,
2111: transactionIdIn => transactionIdIn,
2112: transactionTypeIdIn => transactionTypeIn);
2113: errorCode := -20001;
2114: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',

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

2119: exceptionStringIn => errorMessage);
2120: raise_application_error(errorCode,
2121: errorMessage);
2122: when badStatusException then
2123: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,
2124: transactionIdIn => transactionIdIn,
2125: transactionTypeIdIn => transactionTypeIn);
2126: errorCode := -20001;
2127: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',

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

2132: exceptionStringIn => errorMessage);
2133: raise_application_error(errorCode,
2134: errorMessage);
2135: when incompatibleApproverException then
2136: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,
2137: transactionIdIn => transactionIdIn,
2138: transactionTypeIdIn => transactionTypeIn);
2139: errorCode := -20001;
2140: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',

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

2145: exceptionStringIn => errorMessage);
2146: raise_application_error(errorCode,
2147: errorMessage);
2148: when noApproverCategoryException then
2149: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,
2150: transactionIdIn => transactionIdIn,
2151: transactionTypeIdIn => transactionTypeIn);
2152: errorCode := -20001;
2153: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',

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

2158: exceptionStringIn => errorMessage);
2159: raise_application_error(errorCode,
2160: errorMessage);
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',

Line 2202: where application_id = ame_engine.getAmeApplicationId

2198: upperLimit integer;
2199: cursor getAnchorInsertions (parameterIn varchar2) is
2200: (select name
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;

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

2209: anchorList varchar2(1000);
2210: appr_rec_params varchar2(100);
2211: nullApprRecordFieldException Exception;
2212: begin
2213: ame_engine.lockTransaction(fndApplicationIdIn => applicationIdIn,
2214: transactionIdIn => transactionIdIn,
2215: transactionTypeIdIn => transactionTypeIn);
2216: appr_rec_params:=null;
2217: if(approverIn.name is null) then

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

2231: end if;
2232: if appr_rec_params is not null then
2233: raise nullApprRecordFieldException;
2234: end if;
2235: ame_engine.updateTransactionState(isTestTransactionIn => false,
2236: isLocalTransactionIn => false,
2237: fetchConfigVarsIn => true,
2238: fetchOldApproversIn => true,
2239: fetchInsertionsIn => true,

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

2252: ameApplicationIdIn => null,
2253: fndApplicationIdIn => applicationIdIn,
2254: transactionTypeIdIn => transactionTypeIn );
2255: /* Try to match the approver. */
2256: ame_engine.getApprovers(approversOut => approvers);
2257: upperLimit := approvers.count;
2258: approverIndex := null;
2259: for i in 1 .. upperLimit loop
2260: if((approvers(i).approval_status is null or

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

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
2270: anchorName := approvers(i).name;

Line 2297: ameApplicationId := ame_engine.getAmeApplicationId;

2293: -- If there is no match, raise an exception.
2294: if(approverIndex is null) then
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);

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 2343: ame_engine.updateInsertions(indexIn => i);

2339: for i in 1 .. approvers.count loop
2340: if approvers(i).name = approverIn.name and
2341: approvers(i).item_class = approverIn.item_class and
2342: approvers(i).item_id = approverIn.item_id then
2343: ame_engine.updateInsertions(indexIn => i);
2344: end if;
2345: end loop;
2346: delete from ame_temp_insertions
2347: where

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

2351: item_class = approvers(approverIndex).item_class and
2352: item_id = approvers(approverIndex).item_id ;
2353: end if;
2354: -- Cycle the engine to account for changes in the deletions table.
2355: ame_engine.updateTransactionState(isTestTransactionIn => false,
2356: isLocalTransactionIn => false,
2357: fetchConfigVarsIn => true,
2358: fetchOldApproversIn => true,
2359: fetchInsertionsIn => true,

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

2371: transactionIdIn => transactionIdIn,
2372: ameApplicationIdIn => null,
2373: fndApplicationIdIn => applicationIdIn,
2374: transactionTypeIdIn => transactionTypeIn );
2375: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,
2376: transactionIdIn => transactionIdIn,
2377: transactionTypeIdIn => transactionTypeIn);
2378: exception
2379: when anchorsExistException then

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

2376: transactionIdIn => transactionIdIn,
2377: transactionTypeIdIn => transactionTypeIn);
2378: exception
2379: when anchorsExistException then
2380: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,
2381: transactionIdIn => transactionIdIn,
2382: transactionTypeIdIn => transactionTypeIn);
2383: anchorList := '';
2384: for i in 1 .. nameList.count loop

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

2400: exceptionStringIn => errorMessage);
2401: raise_application_error(errorCode,
2402: errorMessage);
2403: when nullApprRecordFieldException then
2404: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,
2405: transactionIdIn => transactionIdIn,
2406: transactionTypeIdIn => transactionTypeIn);
2407: errorCode := -20001;
2408: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',

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

2415: exceptionStringIn => errorMessage);
2416: raise_application_error(errorCode,
2417: errorMessage);
2418: when badDeletionException then
2419: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,
2420: transactionIdIn => transactionIdIn,
2421: transactionTypeIdIn => transactionTypeIn);
2422: errorCode := -20001;
2423: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',

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

2428: exceptionStringIn => errorMessage);
2429: raise_application_error(errorCode,
2430: errorMessage);
2431: when noMatchException then
2432: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,
2433: transactionIdIn => transactionIdIn,
2434: transactionTypeIdIn => transactionTypeIn);
2435: errorCode := -20001;
2436: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',

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

2441: exceptionStringIn => errorMessage);
2442: raise_application_error(errorCode,
2443: errorMessage);
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',