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.JTF_RS_ACTIVE_REC_CONC_PUB dependencies on FND_FILE

Line 138: fnd_file.put_line(fnd_file.log, fnd_message.get);

134:
135: fnd_message.set_name('JTF', 'JTF_RS_ACTIVE_TO_INACT_COUNT');
136: fnd_message.set_token('P_TABLE_NAME', 'JTF_RS_GROUPS_DENORM');
137: fnd_message.set_token('P_ROWCOUNT', TO_CHAR(SQL%ROWCOUNT));
138: fnd_file.put_line(fnd_file.log, fnd_message.get);
139: fnd_file.new_line(fnd_file.log,1);
140:
141: COMMIT;
142:

Line 139: fnd_file.new_line(fnd_file.log,1);

135: fnd_message.set_name('JTF', 'JTF_RS_ACTIVE_TO_INACT_COUNT');
136: fnd_message.set_token('P_TABLE_NAME', 'JTF_RS_GROUPS_DENORM');
137: fnd_message.set_token('P_ROWCOUNT', TO_CHAR(SQL%ROWCOUNT));
138: fnd_file.put_line(fnd_file.log, fnd_message.get);
139: fnd_file.new_line(fnd_file.log,1);
140:
141: COMMIT;
142:
143: -- now update the latest relationship flag for group relations which are inactive

Line 299: fnd_file.put_line(fnd_file.LOG, fnd_message.get);

295:
296: fnd_message.set_name('JTF', 'JTF_RS_INACT_TO_ACTIVE_COUNT');
297: fnd_message.set_token('P_TABLE_NAME', 'JTF_RS_GROUPS_DENORM');
298: fnd_message.set_token('P_ROWCOUNT', TO_CHAR(l_update_count));
299: fnd_file.put_line(fnd_file.LOG, fnd_message.get);
300: fnd_file.new_line(fnd_file.LOG,1);
301:
302: COMMIT;
303:

Line 300: fnd_file.new_line(fnd_file.LOG,1);

296: fnd_message.set_name('JTF', 'JTF_RS_INACT_TO_ACTIVE_COUNT');
297: fnd_message.set_token('P_TABLE_NAME', 'JTF_RS_GROUPS_DENORM');
298: fnd_message.set_token('P_ROWCOUNT', TO_CHAR(l_update_count));
299: fnd_file.put_line(fnd_file.LOG, fnd_message.get);
300: fnd_file.new_line(fnd_file.LOG,1);
301:
302: COMMIT;
303:
304: ---------------------------------------------------------

Line 332: fnd_file.put_line(fnd_file.log, fnd_message.get);

328:
329: fnd_message.set_name('JTF', 'JTF_RS_ACTIVE_TO_INACT_COUNT');
330: fnd_message.set_token('P_TABLE_NAME', 'JTF_RS_ROLE_RELATIONS');
331: fnd_message.set_token('P_ROWCOUNT', to_char(l_update_count));
332: fnd_file.put_line(fnd_file.log, fnd_message.get);
333: fnd_file.new_line(fnd_file.log,1);
334:
335: COMMIT;
336:

Line 333: fnd_file.new_line(fnd_file.log,1);

329: fnd_message.set_name('JTF', 'JTF_RS_ACTIVE_TO_INACT_COUNT');
330: fnd_message.set_token('P_TABLE_NAME', 'JTF_RS_ROLE_RELATIONS');
331: fnd_message.set_token('P_ROWCOUNT', to_char(l_update_count));
332: fnd_file.put_line(fnd_file.log, fnd_message.get);
333: fnd_file.new_line(fnd_file.log,1);
334:
335: COMMIT;
336:
337: UPDATE jtf_rs_role_relations

Line 350: fnd_file.put_line(fnd_file.log, fnd_message.get);

346:
347: fnd_message.set_name('JTF', 'JTF_RS_INACT_TO_ACTIVE_COUNT');
348: fnd_message.set_token('P_TABLE_NAME', 'JTF_RS_ROLE_RELATIONS');
349: fnd_message.set_token('P_ROWCOUNT', to_char(SQL%ROWCOUNT));
350: fnd_file.put_line(fnd_file.log, fnd_message.get);
351: fnd_file.new_line(fnd_file.log,1);
352:
353: COMMIT;
354:

Line 351: fnd_file.new_line(fnd_file.log,1);

347: fnd_message.set_name('JTF', 'JTF_RS_INACT_TO_ACTIVE_COUNT');
348: fnd_message.set_token('P_TABLE_NAME', 'JTF_RS_ROLE_RELATIONS');
349: fnd_message.set_token('P_ROWCOUNT', to_char(SQL%ROWCOUNT));
350: fnd_file.put_line(fnd_file.log, fnd_message.get);
351: fnd_file.new_line(fnd_file.log,1);
352:
353: COMMIT;
354:
355: /* Following lines are add for the performance bug # 3119586 */

Line 415: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);

411:
412: EXCEPTION
413: WHEN OTHERS THEN
414: ROLLBACK;
415: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
416: -- Even though Error return warning using retcode = 1
417: -- because we want other programs in request set to continue.
418: --retcode := 1;
419: -- Changed on 20-Jan-2005 for Bug 4099782 to return Error instead of Warning