APPS.AME_TRANS_DATA_PURGE dependencies on AME_TRANS_DATA_PURGE

Line 1: package body ame_trans_data_purge as

1: package body ame_trans_data_purge as
2: /* $Header: amepurge.pkb 120.10 2008/04/16 13:50:38 prasashe noship $ */
3: procedure purgeTransData(errbuf out nocopy varchar2, --needed by concurrent manager.
4: retcode out nocopy number, --needed by concurrent manager.
5: applicationIdIn in number,

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 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 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 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 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);

Line 349: end ame_trans_data_purge;

345: FND_FILE.PUT_LINE (FND_FILE.LOG,sqlerrm);
346: raise_application_error(sqlcode,
347: sqlerrm);
348: end purgeDeviationData;
349: end ame_trans_data_purge;