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

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

15: from ame_attribute_usages
16: where
17: application_id = applicationIdIn and
18: sysdate between start_date and
19: nvl(end_date - ame_util.oneSecond, sysdate);
20: cursor tempTransaction is
21: select transaction_id
22: from ame_temp_transactions
23: where application_id = applicationIdIn and

Line 46: transactionIds ame_util.stringList;

42: order by order_number;
43: tempIndex integer;
44: attributeId integer;
45: transactionId ame_temp_transactions.transaction_id%type;
46: transactionIds ame_util.stringList;
47: bulkFetchRowLimit number := 1000;
48: approverNames ame_util.longStringList;
49: approverItemClasses ame_util.stringList;
50: approverItemIds ame_util.stringList;

Line 48: approverNames ame_util.longStringList;

44: attributeId integer;
45: transactionId ame_temp_transactions.transaction_id%type;
46: transactionIds ame_util.stringList;
47: bulkFetchRowLimit number := 1000;
48: approverNames ame_util.longStringList;
49: approverItemClasses ame_util.stringList;
50: approverItemIds ame_util.stringList;
51: approverCategories ame_util.charList;
52: approverApiInsertions ame_util.StringList;

Line 49: approverItemClasses ame_util.stringList;

45: transactionId ame_temp_transactions.transaction_id%type;
46: transactionIds ame_util.stringList;
47: bulkFetchRowLimit number := 1000;
48: approverNames ame_util.longStringList;
49: approverItemClasses ame_util.stringList;
50: approverItemIds ame_util.stringList;
51: approverCategories ame_util.charList;
52: approverApiInsertions ame_util.StringList;
53: approverAuthorities ame_util.StringList;

Line 50: approverItemIds ame_util.stringList;

46: transactionIds ame_util.stringList;
47: bulkFetchRowLimit number := 1000;
48: approverNames ame_util.longStringList;
49: approverItemClasses ame_util.stringList;
50: approverItemIds ame_util.stringList;
51: approverCategories ame_util.charList;
52: approverApiInsertions ame_util.StringList;
53: approverAuthorities ame_util.StringList;
54: approverStatuses ame_util.StringList;

Line 51: approverCategories ame_util.charList;

47: bulkFetchRowLimit number := 1000;
48: approverNames ame_util.longStringList;
49: approverItemClasses ame_util.stringList;
50: approverItemIds ame_util.stringList;
51: approverCategories ame_util.charList;
52: approverApiInsertions ame_util.StringList;
53: approverAuthorities ame_util.StringList;
54: approverStatuses ame_util.StringList;
55: approverActionTypeIds ame_util.idList;

Line 52: approverApiInsertions ame_util.StringList;

48: approverNames ame_util.longStringList;
49: approverItemClasses ame_util.stringList;
50: approverItemIds ame_util.stringList;
51: approverCategories ame_util.charList;
52: approverApiInsertions ame_util.StringList;
53: approverAuthorities ame_util.StringList;
54: approverStatuses ame_util.StringList;
55: approverActionTypeIds ame_util.idList;
56: approverGroupOrChainIds ame_util.idList;

Line 53: approverAuthorities ame_util.StringList;

49: approverItemClasses ame_util.stringList;
50: approverItemIds ame_util.stringList;
51: approverCategories ame_util.charList;
52: approverApiInsertions ame_util.StringList;
53: approverAuthorities ame_util.StringList;
54: approverStatuses ame_util.StringList;
55: approverActionTypeIds ame_util.idList;
56: approverGroupOrChainIds ame_util.idList;
57: approverOccurrences ame_util.idList;

Line 54: approverStatuses ame_util.StringList;

50: approverItemIds ame_util.stringList;
51: approverCategories ame_util.charList;
52: approverApiInsertions ame_util.StringList;
53: approverAuthorities ame_util.StringList;
54: approverStatuses ame_util.StringList;
55: approverActionTypeIds ame_util.idList;
56: approverGroupOrChainIds ame_util.idList;
57: approverOccurrences ame_util.idList;
58: applicationName ame_calling_apps.application_name%type;

Line 55: approverActionTypeIds ame_util.idList;

51: approverCategories ame_util.charList;
52: approverApiInsertions ame_util.StringList;
53: approverAuthorities ame_util.StringList;
54: approverStatuses ame_util.StringList;
55: approverActionTypeIds ame_util.idList;
56: approverGroupOrChainIds ame_util.idList;
57: approverOccurrences ame_util.idList;
58: applicationName ame_calling_apps.application_name%type;
59: begin

Line 56: approverGroupOrChainIds ame_util.idList;

52: approverApiInsertions ame_util.StringList;
53: approverAuthorities ame_util.StringList;
54: approverStatuses ame_util.StringList;
55: approverActionTypeIds ame_util.idList;
56: approverGroupOrChainIds ame_util.idList;
57: approverOccurrences ame_util.idList;
58: applicationName ame_calling_apps.application_name%type;
59: begin
60: /* Get last Date to save based on the purge frquency set in the config variables */

Line 57: approverOccurrences ame_util.idList;

53: approverAuthorities ame_util.StringList;
54: approverStatuses ame_util.StringList;
55: approverActionTypeIds ame_util.idList;
56: approverGroupOrChainIds ame_util.idList;
57: approverOccurrences ame_util.idList;
58: applicationName ame_calling_apps.application_name%type;
59: begin
60: /* Get last Date to save based on the purge frquency set in the config variables */
61: lastDateToSave := sysdate - to_number(ame_util.getConfigVar(variableNameIn => 'purgeFrequency',

Line 61: lastDateToSave := sysdate - to_number(ame_util.getConfigVar(variableNameIn => 'purgeFrequency',

57: approverOccurrences ame_util.idList;
58: applicationName ame_calling_apps.application_name%type;
59: begin
60: /* Get last Date to save based on the purge frquency set in the config variables */
61: lastDateToSave := sysdate - to_number(ame_util.getConfigVar(variableNameIn => 'purgeFrequency',
62: applicationIdIn => applicationIdIn));
63: begin
64: select application_name
65: into applicationName

Line 119: (approverStatuses(j) = ame_util.notifiedStatus and

115: if approverNames.count >= 0 then
116: for j in 1..approverNames.count
117: loop
118: if (approverStatuses(j) is null or
119: (approverStatuses(j) = ame_util.notifiedStatus and
120: approverStatuses(j) = ame_util.approvalApproverCategory)) then
121: /* Transaction is incomplete so do not purge */
122: transactionIds.delete(i);
123: exit;

Line 120: approverStatuses(j) = ame_util.approvalApproverCategory)) then

116: for j in 1..approverNames.count
117: loop
118: if (approverStatuses(j) is null or
119: (approverStatuses(j) = ame_util.notifiedStatus and
120: approverStatuses(j) = ame_util.approvalApproverCategory)) then
121: /* Transaction is incomplete so do not purge */
122: transactionIds.delete(i);
123: exit;
124: elsif (approverStatuses(j) = ame_util.rejectStatus and

Line 124: elsif (approverStatuses(j) = ame_util.rejectStatus and

120: approverStatuses(j) = ame_util.approvalApproverCategory)) then
121: /* Transaction is incomplete so do not purge */
122: transactionIds.delete(i);
123: exit;
124: elsif (approverStatuses(j) = ame_util.rejectStatus and
125: purgeTypeIn <> 'P') then
126: /* Transaction is rejected, and purge type is not 'P' so do not purge */
127: transactionIds.delete(i);
128: exit;

Line 141: ame_util.compactStringList(stringListInOut => transactionIds);

137: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'3: ' ||transactionIds(i));
138: end if;
139: end loop;
140: /* compact ID List */
141: ame_util.compactStringList(stringListInOut => transactionIds);
142: /* Do bulk deletes */
143: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'No.of transaction ids to be purged: '||transactionIds.count);
144: if(transactionIds.count > 0) then
145: /* ame_temp_old_approver_lists */

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

174: where row_timestamp < sysdate - 1;
175: exception
176: when others then
177: FND_FILE.PUT_LINE(FND_FILE.LOG,sqlerrm);
178: ame_util.runtimeException(packageNameIn => 'ame_trans_data_purge',
179: routineNameIn => 'purgeTransData',
180: exceptionNumberIn => sqlcode,
181: exceptionStringIn => sqlerrm);
182: raise;

Line 197: errorMessage ame_util.longStringType;

193: errormsg varchar2(500);
194: errorCode integer;
195: tempTxnId varchar2(100);
196: tempFndapplicationId number;
197: errorMessage ame_util.longStringType;
198: applicationIdList ame_util.idList;
199: tempApplication number;
200: l_endDate date;
201: l_error_date varchar2(12);

Line 198: applicationIdList ame_util.idList;

194: errorCode integer;
195: tempTxnId varchar2(100);
196: tempFndapplicationId number;
197: errorMessage ame_util.longStringType;
198: applicationIdList ame_util.idList;
199: tempApplication number;
200: l_endDate date;
201: l_error_date varchar2(12);
202: cursor getApplicationList(applictionIdIn in number) is

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

242: where trunc(row_timestamp) <= dateToDelete
243: and application_id = tempApplication;
244: exception
245: when others then
246: ame_util.runtimeException(packageNameIn => 'ame_trans_data_purge',
247: routineNameIn => 'purgeDeviationData',
248: exceptionNumberIn => sqlcode,
249: exceptionStringIn => sqlerrm);
250: FND_FILE.PUT_LINE (FND_FILE.LOG,sqlerrm);

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

269: and application_id = applicationIdList(i);
270: end loop;
271: exception
272: when others then
273: ame_util.runtimeException(packageNameIn => 'ame_trans_data_purge',
274: routineNameIn => 'purgeDeviationData',
275: exceptionNumberIn => sqlcode,
276: exceptionStringIn => sqlerrm);
277: FND_FILE.PUT_LINE (FND_FILE.LOG,sqlerrm);

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

288: set trans_deviation_flag = 'D'
289: where trunc(row_timestamp) <= dateToDelete;
290: exception
291: when others then
292: ame_util.runtimeException(packageNameIn => 'ame_trans_data_purge',
293: routineNameIn => 'purgeDeviationData',
294: exceptionNumberIn => sqlcode,
295: exceptionStringIn => sqlerrm);
296: FND_FILE.PUT_LINE (FND_FILE.LOG,sqlerrm);

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

300: exception
301: when profileNotsetExc then
302: errorCode := -20001;
303: errorMessage :=
304: ame_util.getMessage(applicationShortNameIn =>'PER',
305: messageNameIn => 'AME_400828_DEV_PRF_NOTSET');
306: ame_util.runtimeException(packageNameIn => 'ame_trans_data_purge',
307: routineNameIn => 'purgeDeviationData',
308: exceptionNumberIn => errorCode,

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

302: errorCode := -20001;
303: errorMessage :=
304: ame_util.getMessage(applicationShortNameIn =>'PER',
305: messageNameIn => 'AME_400828_DEV_PRF_NOTSET');
306: ame_util.runtimeException(packageNameIn => 'ame_trans_data_purge',
307: routineNameIn => 'purgeDeviationData',
308: exceptionNumberIn => errorCode,
309: exceptionStringIn => errorMessage);
310: FND_FILE.PUT_LINE (FND_FILE.LOG,errorMessage);

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

312: errorMessage);
313: when deleteTodayRecordExc then
314: errorCode := -20001;
315: errorMessage :=
316: ame_util.getMessage(applicationShortNameIn =>'PER',
317: messageNameIn => 'AME_400832_INV_PURGE_UP_TODATE');
318: ame_util.runtimeException(packageNameIn => 'ame_trans_data_purge',
319: routineNameIn => 'purgeDeviationData',
320: exceptionNumberIn => errorCode,

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

314: errorCode := -20001;
315: errorMessage :=
316: ame_util.getMessage(applicationShortNameIn =>'PER',
317: messageNameIn => 'AME_400832_INV_PURGE_UP_TODATE');
318: ame_util.runtimeException(packageNameIn => 'ame_trans_data_purge',
319: routineNameIn => 'purgeDeviationData',
320: exceptionNumberIn => errorCode,
321: exceptionStringIn => errorMessage);
322: FND_FILE.PUT_LINE (FND_FILE.LOG,errorMessage);

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

325: when invalidInputDateExc then
326: l_error_date := FND_PROFILE.VALUE('AME_DEVITION_PURGE_DATE');
327: errorCode := -20001;
328: errorMessage :=
329: ame_util.getMessage(applicationShortNameIn =>'PER',
330: messageNameIn => 'AME_400830_INVALID_PURGE_DATE',
331: tokenNameOneIn => 'PROFILE_DATE',
332: tokenValueOneIn => l_error_date );
333: ame_util.runtimeException(packageNameIn => 'ame_trans_data_purge',

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

329: ame_util.getMessage(applicationShortNameIn =>'PER',
330: messageNameIn => 'AME_400830_INVALID_PURGE_DATE',
331: tokenNameOneIn => 'PROFILE_DATE',
332: tokenValueOneIn => l_error_date );
333: ame_util.runtimeException(packageNameIn => 'ame_trans_data_purge',
334: routineNameIn => 'purgeDeviationData',
335: exceptionNumberIn => errorCode,
336: exceptionStringIn => errorMessage);
337: FND_FILE.PUT_LINE (FND_FILE.LOG,errorMessage);

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

337: FND_FILE.PUT_LINE (FND_FILE.LOG,errorMessage);
338: raise_application_error(errorCode,
339: errorMessage);
340: when others then
341: ame_util.runtimeException(packageNameIn => 'ame_trans_data_purge',
342: routineNameIn => 'purgeDeviationData',
343: exceptionNumberIn => sqlcode,
344: exceptionStringIn => sqlerrm);
345: FND_FILE.PUT_LINE (FND_FILE.LOG,sqlerrm);