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

Line 63: fnd_file.put_line(fnd_file.Log, 'identify RAM adjustments>>');

59: cn_debug.init_pipe(debug_pipe, debug_level);
60: END IF;
61: cn_debug.print_msg('>>identify RAM adjustments', 1);
62: cn_message_pkg.debug('identify RAM adjustments>>');
63: fnd_file.put_line(fnd_file.Log, 'identify RAM adjustments>>');
64:
65: x_proc_audit_id := NULL; -- Will get a value in the call below
66: cn_process_audits_pkg.insert_row(x_rowid, x_proc_audit_id, NULL,'RAMADJ', 'Identify RAM adjustments', NULL, NULL, NULL, NULL, NULL, SYSDATE, NULL, x_org_id);
67:

Line 75: fnd_file.put_line(fnd_file.Log, 'identify RAM adjustments: identifing adjustments for transactions from '||x_start_date ||' to '||x_end_date ||'.');

71: x_start_date,
72: x_end_date);
73:
74: cn_message_pkg.debug('identify RAM adjustments: identifing adjustments for transactions from '||x_start_date ||' to '||x_end_date ||'.');
75: fnd_file.put_line(fnd_file.Log, 'identify RAM adjustments: identifing adjustments for transactions from '||x_start_date ||' to '||x_end_date ||'.');
76:
77: OPEN batch_size;
78: FETCH batch_size INTO l_sys_batch_size;
79: CLOSE batch_size;

Line 260: fnd_file.put_line(fnd_file.Log, 'identify RAM adjustments: no RAM adjustments was found.');

256: 'identify RAM adjustments: completed. ' || x_trx_identified_count || ' transactions identified.');
257:
258: IF ( x_trx_identified_count = 0 ) THEN
259: cn_message_pkg.debug('identify RAM adjustments: no RAM adjustments was found.');
260: fnd_file.put_line(fnd_file.Log, 'identify RAM adjustments: no RAM adjustments was found.');
261: END IF;
262:
263: COMMIT; -- commit after identify process
264:

Line 266: fnd_file.put_line(fnd_file.Log, 'identify RAM adjustments: identify process completed. ' || x_trx_identified_count || ' transactions identified.');

262:
263: COMMIT; -- commit after identify process
264:
265: cn_message_pkg.debug('identify RAM adjustments: identify process completed. ' || x_trx_identified_count || ' transactions identified.');
266: fnd_file.put_line(fnd_file.Log, 'identify RAM adjustments: identify process completed. ' || x_trx_identified_count || ' transactions identified.');
267:
268: cn_debug.print_msg('< 269: cn_message_pkg.debug('identify RAM adjustments<<');
270: fnd_file.put_line(fnd_file.Log, 'identify RAM adjustments<<');

Line 270: fnd_file.put_line(fnd_file.Log, 'identify RAM adjustments<<');

266: fnd_file.put_line(fnd_file.Log, 'identify RAM adjustments: identify process completed. ' || x_trx_identified_count || ' transactions identified.');
267:
268: cn_debug.print_msg('< 269: cn_message_pkg.debug('identify RAM adjustments<<');
270: fnd_file.put_line(fnd_file.Log, 'identify RAM adjustments<<');
271:
272:
273:
274: EXCEPTION

Line 278: fnd_file.put_line(fnd_file.Log, 'identify RAM adjustments: in exception handler');

274: EXCEPTION
275: WHEN OTHERS THEN ROLLBACK;
276:
277: cn_message_pkg.debug('identify RAM adjustments: in exception handler');
278: fnd_file.put_line(fnd_file.Log, 'identify RAM adjustments: in exception handler');
279:
280: cn_message_pkg.debug(SQLCODE||' '||SQLERRM);
281: fnd_file.put_line(fnd_file.Log, SQLCODE||' '||SQLERRM);
282:

Line 281: fnd_file.put_line(fnd_file.Log, SQLCODE||' '||SQLERRM);

277: cn_message_pkg.debug('identify RAM adjustments: in exception handler');
278: fnd_file.put_line(fnd_file.Log, 'identify RAM adjustments: in exception handler');
279:
280: cn_message_pkg.debug(SQLCODE||' '||SQLERRM);
281: fnd_file.put_line(fnd_file.Log, SQLCODE||' '||SQLERRM);
282:
283: cn_debug.print_msg('identify RAM adjustments: in exception handler', 1);
284: cn_process_audits_pkg.update_row(X_proc_audit_id, NULL, SYSDATE, SQLCODE,
285: SQLERRM);

Line 330: fnd_file.put_line(fnd_file.Log, 'negate process>>');

326: cn_debug.init_pipe(debug_pipe, debug_level);
327: END IF;
328: cn_debug.print_msg('>>negate process', 1);
329: cn_message_pkg.debug('negate process>>');
330: fnd_file.put_line(fnd_file.Log, 'negate process>>');
331:
332: x_proc_audit_id := NULL; -- Will get a value in the call below
333: cn_process_audits_pkg.insert_row(x_rowid, x_proc_audit_id, NULL,'RAMADJ', 'negate process', NULL, NULL, NULL, NULL, NULL, SYSDATE, NULL, x_org_id);
334:

Line 367: fnd_file.put_line(fnd_file.Log, 'negate process: No OIC transaction was negated.');

363: 'negate process: completed. ' || x_api_negated_count || ' OIC transactions negated.');
364:
365: IF ( x_api_negated_count = 0 ) THEN
366: cn_message_pkg.debug('negate process: No OIC transaction was negated.');
367: fnd_file.put_line(fnd_file.Log, 'negate process: No OIC transaction was negated.');
368: END IF;
369:
370: -- COMMIT; commit will be called when the re-collection is done.
371:

Line 373: fnd_file.put_line(fnd_file.Log, 'negate process: negate process completed. ' || x_api_negated_count || ' OIC transactions negated.');

369:
370: -- COMMIT; commit will be called when the re-collection is done.
371:
372: cn_message_pkg.debug('negate process: negate process completed. ' || x_api_negated_count || ' OIC transactions negated.');
373: fnd_file.put_line(fnd_file.Log, 'negate process: negate process completed. ' || x_api_negated_count || ' OIC transactions negated.');
374:
375: cn_debug.print_msg('< 376: cn_message_pkg.debug('negate process<<');
377: fnd_file.put_line(fnd_file.Log, 'negate process<<');

Line 377: fnd_file.put_line(fnd_file.Log, 'negate process<<');

373: fnd_file.put_line(fnd_file.Log, 'negate process: negate process completed. ' || x_api_negated_count || ' OIC transactions negated.');
374:
375: cn_debug.print_msg('< 376: cn_message_pkg.debug('negate process<<');
377: fnd_file.put_line(fnd_file.Log, 'negate process<<');
378:
379:
380: EXCEPTION
381: WHEN OTHERS THEN ROLLBACK;

Line 384: fnd_file.put_line(fnd_file.Log, 'negate process: in exception handler');

380: EXCEPTION
381: WHEN OTHERS THEN ROLLBACK;
382:
383: cn_message_pkg.debug('negate process: in exception handler');
384: fnd_file.put_line(fnd_file.Log, 'negate process: in exception handler');
385:
386: cn_message_pkg.debug(SQLCODE||' '||SQLERRM);
387: fnd_file.put_line(fnd_file.Log, SQLCODE||' '||SQLERRM);
388:

Line 387: fnd_file.put_line(fnd_file.Log, SQLCODE||' '||SQLERRM);

383: cn_message_pkg.debug('negate process: in exception handler');
384: fnd_file.put_line(fnd_file.Log, 'negate process: in exception handler');
385:
386: cn_message_pkg.debug(SQLCODE||' '||SQLERRM);
387: fnd_file.put_line(fnd_file.Log, SQLCODE||' '||SQLERRM);
388:
389: cn_debug.print_msg('negate process: in exception handler', 1);
390: cn_process_audits_pkg.update_row(X_proc_audit_id, NULL, SYSDATE, SQLCODE,
391: SQLERRM);