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_API5 dependencies on AME_UTIL

Line 15: and sysdate between start_date and nvl(end_date - ame_util.oneSecond, sysdate);

11: cursor chkItemClass is
12: select name
13: from ame_item_classes
14: where item_class_id = itemClassIdIn
15: and sysdate between start_date and nvl(end_date - ame_util.oneSecond, sysdate);
16: item_class_name ame_item_classes.name%type;
17: errorCode integer;
18: errorMessage ame_util.longestStringType;
19: begin

Line 18: errorMessage ame_util.longestStringType;

14: where item_class_id = itemClassIdIn
15: and sysdate between start_date and nvl(end_date - ame_util.oneSecond, sysdate);
16: item_class_name ame_item_classes.name%type;
17: errorCode integer;
18: errorMessage ame_util.longestStringType;
19: begin
20: ame_engine.lockTransaction(fndApplicationIdIn => applicationIdIn,
21: transactionIdIn => transactionIdIn,
22: transactionTypeIdIn => transactionTypeIn);

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

58: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,
59: transactionIdIn => transactionIdIn,
60: transactionTypeIdIn => transactionTypeIn);
61: errorCode := -20001;
62: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
63: messageNameIn => 'AME_99999_INVALID_ITEM_CLASS');
64: ame_util.runtimeException(packageNameIn => 'ame_api3',
65: routineNameIn => 'getAvailableInsertions',
66: exceptionNumberIn => errorCode,

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

60: transactionTypeIdIn => transactionTypeIn);
61: errorCode := -20001;
62: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
63: messageNameIn => 'AME_99999_INVALID_ITEM_CLASS');
64: ame_util.runtimeException(packageNameIn => 'ame_api3',
65: routineNameIn => 'getAvailableInsertions',
66: exceptionNumberIn => errorCode,
67: exceptionStringIn => errorMessage);
68: raise_application_error(errorCode,

Line 74: ame_util.runtimeException(packageNameIn => 'ame_api2',

70: when others then
71: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,
72: transactionIdIn => transactionIdIn,
73: transactionTypeIdIn => transactionTypeIn);
74: ame_util.runtimeException(packageNameIn => 'ame_api2',
75: routineNameIn => 'clearAllApprovals',
76: exceptionNumberIn => sqlcode,
77: exceptionStringIn => sqlerrm);
78: raise;

Line 91: and sysdate between start_date and nvl(end_date - ame_util.oneSecond, sysdate);

87: cursor chkItemClass is
88: select item_class_id
89: from ame_item_classes
90: where name = itemClassNameIn
91: and sysdate between start_date and nvl(end_date - ame_util.oneSecond, sysdate);
92: item_class_id ame_item_classes.item_class_id%type;
93: errorCode integer;
94: errorMessage ame_util.longestStringType;
95: begin

Line 94: errorMessage ame_util.longestStringType;

90: where name = itemClassNameIn
91: and sysdate between start_date and nvl(end_date - ame_util.oneSecond, sysdate);
92: item_class_id ame_item_classes.item_class_id%type;
93: errorCode integer;
94: errorMessage ame_util.longestStringType;
95: begin
96: ame_engine.lockTransaction(fndApplicationIdIn => applicationIdIn,
97: transactionIdIn => transactionIdIn,
98: transactionTypeIdIn => transactionTypeIn);

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

134: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,
135: transactionIdIn => transactionIdIn,
136: transactionTypeIdIn => transactionTypeIn);
137: errorCode := -20001;
138: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
139: messageNameIn => 'AME_99999_INVALID_ITEM_CLASS');
140: ame_util.runtimeException(packageNameIn => 'ame_api3',
141: routineNameIn => 'getAvailableInsertions',
142: exceptionNumberIn => errorCode,

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

136: transactionTypeIdIn => transactionTypeIn);
137: errorCode := -20001;
138: errorMessage := ame_util.getMessage(applicationShortNameIn =>'PER',
139: messageNameIn => 'AME_99999_INVALID_ITEM_CLASS');
140: ame_util.runtimeException(packageNameIn => 'ame_api3',
141: routineNameIn => 'getAvailableInsertions',
142: exceptionNumberIn => errorCode,
143: exceptionStringIn => errorMessage);
144: raise_application_error(errorCode,

Line 150: ame_util.runtimeException(packageNameIn => 'ame_api2',

146: when others then
147: ame_engine.unlockTransaction(fndApplicationIdIn => applicationIdIn,
148: transactionIdIn => transactionIdIn,
149: transactionTypeIdIn => transactionTypeIn);
150: ame_util.runtimeException(packageNameIn => 'ame_api2',
151: routineNameIn => 'clearAllApprovals',
152: exceptionNumberIn => sqlcode,
153: exceptionStringIn => sqlerrm);
154: raise;

Line 157: ,groupNameOut out nocopy ame_util.stringType) as

153: exceptionStringIn => sqlerrm);
154: raise;
155: end clearItemClassApprovals2;
156: procedure getApprovalGroupName(groupIdIn in number
157: ,groupNameOut out nocopy ame_util.stringType) as
158: errorCode integer;
159: errorMessage ame_util.longestStringType;
160: begin
161: select name

Line 159: errorMessage ame_util.longestStringType;

155: end clearItemClassApprovals2;
156: procedure getApprovalGroupName(groupIdIn in number
157: ,groupNameOut out nocopy ame_util.stringType) as
158: errorCode integer;
159: errorMessage ame_util.longestStringType;
160: begin
161: select name
162: into groupNameOut
163: from ame_approval_groups

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

162: into groupNameOut
163: from ame_approval_groups
164: where approval_group_id = groupIdIn
165: and sysdate between start_date
166: and nvl(end_date - ame_util.oneSecond, sysdate);
167: exception
168: when no_data_found then
169: errorCode := -20001;
170: errorMessage := ame_util.getMessage(

Line 170: errorMessage := ame_util.getMessage(

166: and nvl(end_date - ame_util.oneSecond, sysdate);
167: exception
168: when no_data_found then
169: errorCode := -20001;
170: errorMessage := ame_util.getMessage(
171: applicationShortNameIn => 'PER',
172: messageNameIn => 'AME_400453_GROUP_NOT_DEFINED',
173: tokenNameOneIn => 'APPROVAL_GROUP',
174: tokenValueOneIn => groupIdIn);

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

171: applicationShortNameIn => 'PER',
172: messageNameIn => 'AME_400453_GROUP_NOT_DEFINED',
173: tokenNameOneIn => 'APPROVAL_GROUP',
174: tokenValueOneIn => groupIdIn);
175: ame_util.runtimeException(packageNameIn => 'ame_api3',
176: routineNameIn => 'getApprovalGroupId',
177: exceptionNumberIn => errorCode,
178: exceptionStringIn => errorMessage);
179: raise_application_error(errorCode,

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

178: exceptionStringIn => errorMessage);
179: raise_application_error(errorCode,
180: errorMessage);
181: when others then
182: ame_util.runtimeException(packageNameIn => 'ame_api3',
183: routineNameIn => 'getApprovalGroupId',
184: exceptionNumberIn => sqlcode,
185: exceptionStringIn => sqlerrm);
186: raise;

Line 193: ,activeApproversYNIn in varchar2 default ame_util.booleanFalse

189: procedure getAllApproversAndInsertions
190: (applicationIdIn in number
191: ,transactionTypeIn in varchar2
192: ,transactionIdIn in varchar2
193: ,activeApproversYNIn in varchar2 default ame_util.booleanFalse
194: ,coaInsertionsYNIn in varchar2 default ame_util.booleanFalse
195: ,approvalProcessCompleteYNOut out nocopy varchar2
196: ,approversOut out nocopy ame_util.approversTable2
197: ,availableInsertionsOut out nocopy ame_util2.insertionsTable3

Line 194: ,coaInsertionsYNIn in varchar2 default ame_util.booleanFalse

190: (applicationIdIn in number
191: ,transactionTypeIn in varchar2
192: ,transactionIdIn in varchar2
193: ,activeApproversYNIn in varchar2 default ame_util.booleanFalse
194: ,coaInsertionsYNIn in varchar2 default ame_util.booleanFalse
195: ,approvalProcessCompleteYNOut out nocopy varchar2
196: ,approversOut out nocopy ame_util.approversTable2
197: ,availableInsertionsOut out nocopy ame_util2.insertionsTable3
198: ) as

Line 196: ,approversOut out nocopy ame_util.approversTable2

192: ,transactionIdIn in varchar2
193: ,activeApproversYNIn in varchar2 default ame_util.booleanFalse
194: ,coaInsertionsYNIn in varchar2 default ame_util.booleanFalse
195: ,approvalProcessCompleteYNOut out nocopy varchar2
196: ,approversOut out nocopy ame_util.approversTable2
197: ,availableInsertionsOut out nocopy ame_util2.insertionsTable3
198: ) as
199:
200: allApprovers ame_util.approversTable2;

Line 197: ,availableInsertionsOut out nocopy ame_util2.insertionsTable3

193: ,activeApproversYNIn in varchar2 default ame_util.booleanFalse
194: ,coaInsertionsYNIn in varchar2 default ame_util.booleanFalse
195: ,approvalProcessCompleteYNOut out nocopy varchar2
196: ,approversOut out nocopy ame_util.approversTable2
197: ,availableInsertionsOut out nocopy ame_util2.insertionsTable3
198: ) as
199:
200: allApprovers ame_util.approversTable2;
201: positionInsertions ame_util.insertionsTable2;

Line 200: allApprovers ame_util.approversTable2;

196: ,approversOut out nocopy ame_util.approversTable2
197: ,availableInsertionsOut out nocopy ame_util2.insertionsTable3
198: ) as
199:
200: allApprovers ame_util.approversTable2;
201: positionInsertions ame_util.insertionsTable2;
202: nextAvailableInsertionIndex integer;
203: lastActiveApproverIndex integer;
204: tempCount integer;

Line 201: positionInsertions ame_util.insertionsTable2;

197: ,availableInsertionsOut out nocopy ame_util2.insertionsTable3
198: ) as
199:
200: allApprovers ame_util.approversTable2;
201: positionInsertions ame_util.insertionsTable2;
202: nextAvailableInsertionIndex integer;
203: lastActiveApproverIndex integer;
204: tempCount integer;
205:

Line 207: (insertionRec2In in ame_util.insertionRecord2

203: lastActiveApproverIndex integer;
204: tempCount integer;
205:
206: procedure copyInsRec2ToInsRec3
207: (insertionRec2In in ame_util.insertionRecord2
208: ,insertionRec3Out out nocopy ame_util2.insertionRecord3
209: ) as
210: begin
211: insertionRec3Out.item_class := insertionRec2In.item_class;

Line 208: ,insertionRec3Out out nocopy ame_util2.insertionRecord3

204: tempCount integer;
205:
206: procedure copyInsRec2ToInsRec3
207: (insertionRec2In in ame_util.insertionRecord2
208: ,insertionRec3Out out nocopy ame_util2.insertionRecord3
209: ) as
210: begin
211: insertionRec3Out.item_class := insertionRec2In.item_class;
212: insertionRec3Out.item_id := insertionRec2In.item_id;

Line 272: if activeApproversYNIn = ame_util.booleanTrue then

268:
269: /* Copy approver records from input to output only if approvers are present */
270: if allApprovers.count > 0 then
271: for i in 1 .. allApprovers.count loop
272: if activeApproversYNIn = ame_util.booleanTrue then
273: if allApprovers(i).approval_status is null or
274: allApprovers(i).approval_status in
275: (ame_util.approveAndForwardStatus
276: ,ame_util.approvedStatus

Line 275: (ame_util.approveAndForwardStatus

271: for i in 1 .. allApprovers.count loop
272: if activeApproversYNIn = ame_util.booleanTrue then
273: if allApprovers(i).approval_status is null or
274: allApprovers(i).approval_status in
275: (ame_util.approveAndForwardStatus
276: ,ame_util.approvedStatus
277: ,ame_util.beatByFirstResponderStatus
278: ,ame_util.forwardStatus
279: ,ame_util.noResponseStatus

Line 276: ,ame_util.approvedStatus

272: if activeApproversYNIn = ame_util.booleanTrue then
273: if allApprovers(i).approval_status is null or
274: allApprovers(i).approval_status in
275: (ame_util.approveAndForwardStatus
276: ,ame_util.approvedStatus
277: ,ame_util.beatByFirstResponderStatus
278: ,ame_util.forwardStatus
279: ,ame_util.noResponseStatus
280: ,ame_util.notifiedStatus

Line 277: ,ame_util.beatByFirstResponderStatus

273: if allApprovers(i).approval_status is null or
274: allApprovers(i).approval_status in
275: (ame_util.approveAndForwardStatus
276: ,ame_util.approvedStatus
277: ,ame_util.beatByFirstResponderStatus
278: ,ame_util.forwardStatus
279: ,ame_util.noResponseStatus
280: ,ame_util.notifiedStatus
281: ,ame_util.rejectStatus) then

Line 278: ,ame_util.forwardStatus

274: allApprovers(i).approval_status in
275: (ame_util.approveAndForwardStatus
276: ,ame_util.approvedStatus
277: ,ame_util.beatByFirstResponderStatus
278: ,ame_util.forwardStatus
279: ,ame_util.noResponseStatus
280: ,ame_util.notifiedStatus
281: ,ame_util.rejectStatus) then
282: ame_util.copyApproverRecord2

Line 279: ,ame_util.noResponseStatus

275: (ame_util.approveAndForwardStatus
276: ,ame_util.approvedStatus
277: ,ame_util.beatByFirstResponderStatus
278: ,ame_util.forwardStatus
279: ,ame_util.noResponseStatus
280: ,ame_util.notifiedStatus
281: ,ame_util.rejectStatus) then
282: ame_util.copyApproverRecord2
283: (approverRecord2In => allApprovers(i)

Line 280: ,ame_util.notifiedStatus

276: ,ame_util.approvedStatus
277: ,ame_util.beatByFirstResponderStatus
278: ,ame_util.forwardStatus
279: ,ame_util.noResponseStatus
280: ,ame_util.notifiedStatus
281: ,ame_util.rejectStatus) then
282: ame_util.copyApproverRecord2
283: (approverRecord2In => allApprovers(i)
284: ,approverRecord2Out => approversOut(i)

Line 281: ,ame_util.rejectStatus) then

277: ,ame_util.beatByFirstResponderStatus
278: ,ame_util.forwardStatus
279: ,ame_util.noResponseStatus
280: ,ame_util.notifiedStatus
281: ,ame_util.rejectStatus) then
282: ame_util.copyApproverRecord2
283: (approverRecord2In => allApprovers(i)
284: ,approverRecord2Out => approversOut(i)
285: );

Line 282: ame_util.copyApproverRecord2

278: ,ame_util.forwardStatus
279: ,ame_util.noResponseStatus
280: ,ame_util.notifiedStatus
281: ,ame_util.rejectStatus) then
282: ame_util.copyApproverRecord2
283: (approverRecord2In => allApprovers(i)
284: ,approverRecord2Out => approversOut(i)
285: );
286:

Line 310: else /* if activeApproversYNIn = ame_util.booleanFalse */

306: end loop;
307: end if;
308:
309: end if;
310: else /* if activeApproversYNIn = ame_util.booleanFalse */
311: ame_util.copyApproverRecord2
312: (approverRecord2In => allApprovers(i)
313: ,approverRecord2Out => approversOut(i)
314: );

Line 311: ame_util.copyApproverRecord2

307: end if;
308:
309: end if;
310: else /* if activeApproversYNIn = ame_util.booleanFalse */
311: ame_util.copyApproverRecord2
312: (approverRecord2In => allApprovers(i)
313: ,approverRecord2Out => approversOut(i)
314: );
315:

Line 344: activeApproversYNIn = ame_util.booleanFalse then

340:
341: /* If all approvers are active or we want all approvers */
342: /* Also takes care when no approvers are present */
343: if allApprovers.count = approversOut.count or
344: activeApproversYNIn = ame_util.booleanFalse then
345:
346: positionInsertions.delete;
347:
348: /* Get available insertions at position i from the engine */

Line 389: if positionInsertions(j).order_type <> ame_util.beforeApprover then

385:
386: /* Copy insertion records only if insertions are available at this position */
387: if positionInsertions.count > 0 then
388: for j in 1 .. positionInsertions.count loop
389: if positionInsertions(j).order_type <> ame_util.beforeApprover then
390: nextAvailableInsertionIndex := nextAvailableInsertionIndex + 1;
391: copyInsRec2ToInsRec3
392: (insertionRec2In => positionInsertions(j)
393: ,insertionRec3Out => availableInsertionsOut(nextAvailableInsertionIndex)

Line 403: ame_util.runtimeException

399: end if;
400:
401: exception
402: when others then
403: ame_util.runtimeException
404: (packageNameIn => 'ame_api5'
405: ,routineNameIn => 'getAllApproversAndInsertions'
406: ,exceptionNumberIn => sqlcode
407: ,exceptionStringIn => sqlerrm