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.FND_IREP_DEFERRED_LOADER dependencies on DBMS_LOCK

Line 340: dbms_lock.sleep(60);

336: -- Upload batch for files which have status N (New)
337: FND_FILE.NEW_LINE(FND_FILE.LOG);
338: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Uploading new files.');
339: UploadBatch('N');
340: dbms_lock.sleep(60);
341:
342: FND_FILE.NEW_LINE(FND_FILE.LOG);
343: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Processing completed files.');
344: cleanup_batches;

Line 360: dbms_lock.sleep(60);

356: -- Repeat upload batch for files which have status E (Error)
357: FND_FILE.NEW_LINE(FND_FILE.LOG);
358: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Re-uploading erroring files.');
359: UploadBatch('E');
360: dbms_lock.sleep(60);
361:
362: FND_FILE.NEW_LINE(FND_FILE.LOG);
363: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Processing completed files.');
364: cleanup_batches;

Line 399: dbms_lock.sleep(120);

395: from FND_IREP_DEFERRED_LOAD_FILES
396: where LOAD_STATUS = 'R';
397:
398: if (kount > 0) then
399: dbms_lock.sleep(120);
400: FND_FILE.PUT_LINE(FND_FILE.LOG,
401: 'Loading not Complete. Resubmitting . . .');
402: result_buf := fnd_adpatch.Post_Patch(appltop_id, errMsg);
403: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Submission result = '||result_buf||