DBA Data[Home] [Help]

APPS.PA_PURGE_BATCHES_PKG dependencies on APP_EXCEPTION

Line 177: app_exception.raise_exception;

173: -- check notfound?
174:
175: if (batches_rec.batch_status_code <> 'W') then
176: fnd_message.set_name ('PA', 'PA_ARPUR_ONLY_DEL_WORK');
177: app_exception.raise_exception;
178: end if;
179:
180: -- cascade delete to purge projects in the batch.
181: DECLARE

Line 211: when APP_EXCEPTION.RECORD_LOCK_EXCEPTION then

207: END LOOP;
208:
209: close purge_projects ;
210: EXCEPTION
211: when APP_EXCEPTION.RECORD_LOCK_EXCEPTION then
212: fnd_message.set_name ('FND', 'FORM_UNABLE_TO_RESERVE_RECORD');
213: app_exception.raise_exception;
214: END;
215:

Line 213: app_exception.raise_exception;

209: close purge_projects ;
210: EXCEPTION
211: when APP_EXCEPTION.RECORD_LOCK_EXCEPTION then
212: fnd_message.set_name ('FND', 'FORM_UNABLE_TO_RESERVE_RECORD');
213: app_exception.raise_exception;
214: END;
215:
216: delete from pa_purge_batches
217: where rowid = x_rowid;

Line 263: APP_EXCEPTION.RAISE_EXCEPTION ;

259:
260: if C%NOTFOUND then
261: close C ;
262: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
263: APP_EXCEPTION.RAISE_EXCEPTION ;
264: end if ;
265: close C ;
266:
267: if ( recinfo.purge_batch_id = x_purge_batch_id and

Line 303: app_exception.raise_exception ;

299:
300: else
301:
302: fnd_message.set_name('FND','FORM_RECORD_CHANGED');
303: app_exception.raise_exception ;
304:
305:
306: end if ;
307: