DBA Data[Home] [Help]

APPS.AME_TRANS_DATA_PURGE dependencies on FND_PROFILE

Line 212: l_profileDate := to_date(FND_PROFILE.VALUE('AME_DEVITION_PURGE_DATE'),'dd/mm/yyyy');

208: invalidInputDateExc exception;
209: deleteTodayRecordExc exception;
210: begin
211: tempFndapplicationId := applicationIdIn;
212: l_profileDate := to_date(FND_PROFILE.VALUE('AME_DEVITION_PURGE_DATE'),'dd/mm/yyyy');
213: l_endDate := fnd_date.canonical_to_date(endDateIn);
214: dateToDelete := l_endDate;
215: FND_FILE.PUT_LINE (FND_FILE.LOG,'Staring AME deviation data purge process');
216: FND_FILE.PUT_LINE (FND_FILE.LOG,'Application id:'||applicationIdIn);

Line 326: l_error_date := FND_PROFILE.VALUE('AME_DEVITION_PURGE_DATE');

322: FND_FILE.PUT_LINE (FND_FILE.LOG,errorMessage);
323: raise_application_error(errorCode,
324: errorMessage);
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',