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

Line 54: ame_util.runtimeException(packageNameIn => 'ame_approver_deviation_pkg',

50: where application_id = applicationIdIn
51: and transaction_id = tranasactionId;
52: exception
53: when others then
54: ame_util.runtimeException(packageNameIn => 'ame_approver_deviation_pkg',
55: routineNameIn => 'markTransactionDeviation',
56: exceptionNumberIn => sqlcode,
57: exceptionStringIn => sqlerrm);
58: end;

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

70: where application_id = applicationIdIn
71: and transaction_id = tranasactionId;
72: exception
73: when others then
74: ame_util.runtimeException(packageNameIn => 'ame_approver_deviation_pkg',
75: routineNameIn => 'markTransactionDeviation',
76: exceptionNumberIn => sqlcode,
77: exceptionStringIn => sqlerrm);
78: end;

Line 86: querystring ame_util.longestStringType;

82: procedure getTransactionDecription( applicationIdIn in number
83: ,transactionIdIn in varchar2
84: ,descriptionOut out nocopy varchar2) as
85: tempStatic varchar2(2);
86: querystring ame_util.longestStringType;
87: dynamicQuery ame_util.longestStringType;
88: dynamicCursor integer;
89: tempAttributeValues1 dbms_sql.varchar2_table;
90: rowsFound integer;

Line 87: dynamicQuery ame_util.longestStringType;

83: ,transactionIdIn in varchar2
84: ,descriptionOut out nocopy varchar2) as
85: tempStatic varchar2(2);
86: querystring ame_util.longestStringType;
87: dynamicQuery ame_util.longestStringType;
88: dynamicCursor integer;
89: tempAttributeValues1 dbms_sql.varchar2_table;
90: rowsFound integer;
91: cursor getAttributeDetails(applnIdIn in number) is

Line 112: dynamicQuery := ame_util.removeReturns(stringIn => querystring,

108: if tempStatic = 'Y' then
109: descriptionOut := querystring;
110: return;
111: else
112: dynamicQuery := ame_util.removeReturns(stringIn => querystring,
113: replaceWithSpaces => true);
114: dynamicCursor := dbms_sql.open_cursor;
115: dbms_sql.parse(dynamicCursor,
116: dynamicQuery,

Line 118: if(instrb(dynamicQuery, ame_util.transactionIdPlaceholder, 1, 1) > 0) then

114: dynamicCursor := dbms_sql.open_cursor;
115: dbms_sql.parse(dynamicCursor,
116: dynamicQuery,
117: dbms_sql.native);
118: if(instrb(dynamicQuery, ame_util.transactionIdPlaceholder, 1, 1) > 0) then
119: dbms_sql.bind_variable(dynamicCursor,
120: ame_util.transactionIdPlaceholder,
121: transactionIdIn,
122: 50);

Line 120: ame_util.transactionIdPlaceholder,

116: dynamicQuery,
117: dbms_sql.native);
118: if(instrb(dynamicQuery, ame_util.transactionIdPlaceholder, 1, 1) > 0) then
119: dbms_sql.bind_variable(dynamicCursor,
120: ame_util.transactionIdPlaceholder,
121: transactionIdIn,
122: 50);
123: end if;
124: dbms_sql.define_array(dynamicCursor,

Line 139: ame_util.runtimeException(packageNameIn => 'ame_approver_deviation_pkg',

135: exit when rowsFound < 100;
136: end loop;
137: dbms_sql.close_cursor(dynamicCursor);
138: if tempAttributeValues1.count > 1 then
139: ame_util.runtimeException(packageNameIn => 'ame_approver_deviation_pkg',
140: routineNameIn => 'getTransactionDecription',
141: exceptionNumberIn => -20001,
142: exceptionStringIn => 'sql returned incorrect number of rows');
143: descriptionOut := null;

Line 151: ame_util.runtimeException(packageNameIn => 'ame_approver_deviation_pkg',

147: return;
148: end if;
149: exception
150: when others then
151: ame_util.runtimeException(packageNameIn => 'ame_approver_deviation_pkg',
152: routineNameIn => 'getTransactionDecription',
153: exceptionNumberIn => sqlcode,
154: exceptionStringIn => sqlerrm);
155: descriptionOut := null;

Line 172: ,finalapproverListIn in ame_util.approversTable2) as

168: and the trans_deviation_flag from master table*/
169: procedure insertDeviations( applicationIdIn in number
170: ,tranasactionIdIn in varchar2
171: ,deviationListIn in deviationReasonList
172: ,finalapproverListIn in ame_util.approversTable2) as
173: tempTransSequenceId integer;
174: approverDeviationId integer;
175: tempTransReq integer;
176: tempTransDescr varchar2(100);

Line 211: tempTransReq := ame_engine.getHeaderAttValue2(ame_util.transactionRequestorAttribute);

207: begin
208: getTransactionDecription( applicationIdIn => applicationIdIn
209: ,transactionIdIn => tranasactionIdIn
210: ,descriptionOut => tempTransDescr);
211: tempTransReq := ame_engine.getHeaderAttValue2(ame_util.transactionRequestorAttribute);
212: if tempTransReq is not null then
213: tempwfNmae := ame_approver_type_pkg.getWfRolesName(ame_util.perOrigSystem,tempTransReq,'false');
214: if tempwfNmae is not null then
215: tempDisplayName := ame_approver_type_pkg.getApproverDisplayName(tempwfNmae);

Line 213: tempwfNmae := ame_approver_type_pkg.getWfRolesName(ame_util.perOrigSystem,tempTransReq,'false');

209: ,transactionIdIn => tranasactionIdIn
210: ,descriptionOut => tempTransDescr);
211: tempTransReq := ame_engine.getHeaderAttValue2(ame_util.transactionRequestorAttribute);
212: if tempTransReq is not null then
213: tempwfNmae := ame_approver_type_pkg.getWfRolesName(ame_util.perOrigSystem,tempTransReq,'false');
214: if tempwfNmae is not null then
215: tempDisplayName := ame_approver_type_pkg.getApproverDisplayName(tempwfNmae);
216: else
217: tempDisplayName := 'INVALID:'||tempTransReq;

Line 323: ame_util.runtimeException(packageNameIn => 'ame_approver_deviation_pkg',

319: ,null
320: );
321: exception
322: when others then
323: ame_util.runtimeException(packageNameIn => 'ame_approver_deviation_pkg',
324: routineNameIn => 'insertDeviations',
325: exceptionNumberIn => sqlcode,
326: exceptionStringIn => sqlerrm);
327: end;

Line 370: ame_util.runtimeException(packageNameIn => 'ame_approver_deviation_pkg',

366: and lookup_code = templookupcode;
367: exception
368: when others then
369: descrOut := null;
370: ame_util.runtimeException(packageNameIn => 'ame_approver_deviation_pkg',
371: routineNameIn => 'getreasonDescription',
372: exceptionNumberIn => sqlcode,
373: exceptionStringIn => sqlerrm);
374: end;

Line 384: ,finalapproverListIn in ame_util.approversTable2) as

380: procedure updateDeviationState( applicationIdIn in number
381: ,tranasactionIdIn in varchar2
382: ,deviationListIn in deviationReasonList
383: ,approvalProcessCompleteYNIn in varchar2
384: ,finalapproverListIn in ame_util.approversTable2) as
385: tempTransactionKey integer;
386: recordConfig varchar2(100) := 'recordDeviations';
387: cursor getTxnKey(applnId in number, transIdIn in varchar2) is
388: select temp_transactions_id

Line 395: if ame_engine.getConfigVarValue(recordConfig) = ame_util.no then

391: and transaction_id = transIdIn
392: and end_date is not null;
393: begin
394: begin
395: if ame_engine.getConfigVarValue(recordConfig) = ame_util.no then
396: return;
397: end if;
398: exception
399: when others then

Line 400: ame_util.runtimeException(packageNameIn => 'ame_approver_deviation_pkg',

396: return;
397: end if;
398: exception
399: when others then
400: ame_util.runtimeException(packageNameIn => 'ame_approver_deviation_pkg',
401: routineNameIn => 'updateDeviationState',
402: exceptionNumberIn => sqlcode,
403: exceptionStringIn => sqlerrm);
404: return;

Line 407: (ame_util2.completeFullyApproved,

403: exceptionStringIn => sqlerrm);
404: return;
405: end;
406: if approvalProcessCompleteYNIn not in
407: (ame_util2.completeFullyApproved,
408: ame_util2.completeFullyRejected) then
409: open getTxnKey(applicationIdIn,tranasactionIdIn);
410: fetch getTxnKey into tempTransactionKey;
411: close getTxnKey;

Line 408: ame_util2.completeFullyRejected) then

404: return;
405: end;
406: if approvalProcessCompleteYNIn not in
407: (ame_util2.completeFullyApproved,
408: ame_util2.completeFullyRejected) then
409: open getTxnKey(applicationIdIn,tranasactionIdIn);
410: fetch getTxnKey into tempTransactionKey;
411: close getTxnKey;
412: if tempTransactionKey is null then

Line 427: ame_util.runtimeException(packageNameIn => 'ame_approver_deviation_pkg',

423: where temp_transactions_id = tempTransactionKey;
424: return;
425: exception
426: when others then
427: ame_util.runtimeException(packageNameIn => 'ame_approver_deviation_pkg',
428: routineNameIn => 'updateDeviationState',
429: exceptionNumberIn => sqlcode,
430: exceptionStringIn => sqlerrm);
431: end;

Line 489: ame_util.runtimeException(packageNameIn => 'ame_approver_deviation_pkg',

485: fndApplicationIdIn => null,
486: transactionTypeIdIn => null );
487: exception
488: when others then
489: ame_util.runtimeException(packageNameIn => 'ame_approver_deviation_pkg',
490: routineNameIn => 'clearDeviationState',
491: exceptionNumberIn => sqlcode,
492: exceptionStringIn => sqlerrm);
493: end;

Line 502: errorMessage ame_util.longStringType;

498: retcode varchar2(100);
499: endDateinFuture exception;
500: startDateinFurture exception;
501: priorStartDateExp exception;
502: errorMessage ame_util.longStringType;
503: errorCode integer;
504: begin
505: if P_ENDDATE < P_STARTDATE then
506: raise priorStartDateExp;

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

528: exception
529: when endDateinFuture then
530: errorCode := -20001;
531: errorMessage :=
532: ame_util.getMessage(applicationShortNameIn =>'PER',
533: messageNameIn => 'AME_400827_DEV_END_DATE_ERR');
534: ame_util.runtimeException(packageNameIn => 'ame_trans_data_purge',
535: routineNameIn => 'purgeDeviationData',
536: exceptionNumberIn => errorCode,

Line 534: ame_util.runtimeException(packageNameIn => 'ame_trans_data_purge',

530: errorCode := -20001;
531: errorMessage :=
532: ame_util.getMessage(applicationShortNameIn =>'PER',
533: messageNameIn => 'AME_400827_DEV_END_DATE_ERR');
534: ame_util.runtimeException(packageNameIn => 'ame_trans_data_purge',
535: routineNameIn => 'purgeDeviationData',
536: exceptionNumberIn => errorCode,
537: exceptionStringIn => errorMessage);
538: FND_FILE.PUT_LINE (FND_FILE.LOG,errorMessage);

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

540: errorMessage);
541: when startDateinFurture then
542: errorCode := -20001;
543: errorMessage :=
544: ame_util.getMessage(applicationShortNameIn =>'PER',
545: messageNameIn => 'AME_400826_DEV_START_DATE_ERR');
546: ame_util.runtimeException(packageNameIn => 'ame_trans_data_purge',
547: routineNameIn => 'purgeDeviationData',
548: exceptionNumberIn => errorCode,

Line 546: ame_util.runtimeException(packageNameIn => 'ame_trans_data_purge',

542: errorCode := -20001;
543: errorMessage :=
544: ame_util.getMessage(applicationShortNameIn =>'PER',
545: messageNameIn => 'AME_400826_DEV_START_DATE_ERR');
546: ame_util.runtimeException(packageNameIn => 'ame_trans_data_purge',
547: routineNameIn => 'purgeDeviationData',
548: exceptionNumberIn => errorCode,
549: exceptionStringIn => errorMessage);
550: FND_FILE.PUT_LINE (FND_FILE.LOG,errorMessage);

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

552: errorMessage);
553: when priorStartDateExp then
554: errorCode := -20001;
555: errorMessage :=
556: ame_util.getMessage(applicationShortNameIn =>'PER',
557: messageNameIn => 'AME_400828_DEV_DATE_MISMATCH');
558: ame_util.runtimeException(packageNameIn => 'ame_trans_data_purge',
559: routineNameIn => 'purgeDeviationData',
560: exceptionNumberIn => errorCode,

Line 558: ame_util.runtimeException(packageNameIn => 'ame_trans_data_purge',

554: errorCode := -20001;
555: errorMessage :=
556: ame_util.getMessage(applicationShortNameIn =>'PER',
557: messageNameIn => 'AME_400828_DEV_DATE_MISMATCH');
558: ame_util.runtimeException(packageNameIn => 'ame_trans_data_purge',
559: routineNameIn => 'purgeDeviationData',
560: exceptionNumberIn => errorCode,
561: exceptionStringIn => errorMessage);
562: FND_FILE.PUT_LINE (FND_FILE.LOG,errorMessage);