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_COLLECTION_CUSTOM_GEN dependencies on FND_FILE

Line 98: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log,''Inserting new transactions into CN_NOT_TRX.'');');

94: cn_utils.set_org_id(p_org_id => l_org_id);
95: cn_utils.appendcr(code);
96: cn_utils.appendcr(code, '--******** NOTIFICATION PROCESSING *********-- ');
97: cn_utils.appindcr(code, 'cn_message_pkg.debug(''Inserting new transactions into CN_NOT_TRX.'');');
98: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log,''Inserting new transactions into CN_NOT_TRX.'');');
99: cn_utils.appendcr(code);
100: --+
101: -- Most local variables for the collect procedure are part of a static set, which is generated
102: -- for all pacakges (inclding OC and AR) at the start of the procedure by the cn_collection_gen

Line 250: fnd_file.put_line(fnd_file.Log,'*** Finished notification run ');

246: cn_utils.appindcr(code, '-- Commit the notification inserts - they are permanent even if collection fails');
247: cn_utils.appindcr(code, 'COMMIT;');
248: cn_utils.unset_org_id();
249: cn_message_pkg.debug('*** Finished notification run ');
250: fnd_file.put_line(fnd_file.Log,'*** Finished notification run ');
251: cn_utils.set_org_id(p_org_id => l_org_id);
252: cn_utils.appendcr(code);
253: cn_utils.appendcr(code, '--******** COLLECT AJUSTMENTS (NEGATE IN API) ********-- ');
254: cn_utils.appindcr(code, '-- This will negate those adjusted trx in the API table');

Line 419: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, ''Inserting into CN_COMM_LINES_API.'');');

415: cn_utils.set_org_id(p_org_id => X_org_id);
416: cn_utils.appendcr(code);
417: cn_utils.appendcr(code, '--******** INSERT CN_COMM_LINES_API *********-- ');
418: cn_utils.appindcr(code, 'cn_message_pkg.debug(''Inserting into CN_COMM_LINES_API.'');');
419: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, ''Inserting into CN_COMM_LINES_API.'');');
420: cn_utils.appendcr(code);
421: --+
422: -- Generate the INSERT INTO API .. SELECT portion of
423: -- the statement

Line 464: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log,''Inserted '' || comm_lines_api_count || '' line records into CN_COMM_LINES_API.'');');

460: cn_utils.appendcr(code);
461: cn_utils.appindcr(code, 'comm_lines_api_count := SQL%ROWCOUNT;');
462: cn_utils.appendcr(code);
463: cn_utils.appindcr(code, 'cn_message_pkg.debug(''Inserted '' || comm_lines_api_count || '' line records into CN_COMM_LINES_API.'');');
464: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log,''Inserted '' || comm_lines_api_count || '' line records into CN_COMM_LINES_API.'');');
465: cn_utils.appendcr(code);
466: cn_utils.appendcr(code);
467: -- Update the collected_flag in CN_NOT_TRX
468: cn_utils.appindcr(code, 'cn_message_pkg.debug(''Updating collected_flag in CN_NOT_TRX .'');');

Line 469: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log,''Updating collected_flag in CN_NOT_TRX .'');');

465: cn_utils.appendcr(code);
466: cn_utils.appendcr(code);
467: -- Update the collected_flag in CN_NOT_TRX
468: cn_utils.appindcr(code, 'cn_message_pkg.debug(''Updating collected_flag in CN_NOT_TRX .'');');
469: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log,''Updating collected_flag in CN_NOT_TRX .'');');
470: cn_utils.appendcr(code);
471: IF CN_COLLECTION_GEN.isParallelEnabled THEN
472: cn_utils.appindcr(code, 'UPDATE /'||'*+ PARALLEL(cnt) */ cn_not_trx cnt');
473: ELSE

Line 491: fnd_file.put_line(fnd_file.Log, 'insert_lines: in exception handler for NO_DATA_FOUND');

487: cn_utils.unset_org_id();
488: EXCEPTION
489: WHEN NO_DATA_FOUND THEN
490: cn_debug.print_msg('insert_lines: in exception handler for NO_DATA_FOUND',1);
491: fnd_file.put_line(fnd_file.Log, 'insert_lines: in exception handler for NO_DATA_FOUND');
492: RETURN;
493: END insert_comm_lines_api;
494: ---------------------------------------------------------- +
495: -- Procedure Name

Line 660: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, ''For all INDIRECT mappings updated '' || SQL%ROWCOUNT || '' rows in cn_comm_lines_api.'');');

656: -- Generate code to update the comm_lines_api_update_count variable
657: --+
658: cn_utils.appendcr(code);
659: cn_utils.appindcr(code, 'cn_message_pkg.debug(''For all INDIRECT mappings updated '' || SQL%ROWCOUNT || '' rows in cn_comm_lines_api.'');');
660: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, ''For all INDIRECT mappings updated '' || SQL%ROWCOUNT || '' rows in cn_comm_lines_api.'');');
661: cn_utils.appendcr(code);
662: cn_utils.unset_org_id();
663: EXCEPTION
664: WHEN NO_DATA_FOUND THEN

Line 666: fnd_file.put_line(fnd_file.Log, 'update_lines: in exception handler for NO_DATA_FOUND');

662: cn_utils.unset_org_id();
663: EXCEPTION
664: WHEN NO_DATA_FOUND THEN
665: cn_debug.print_msg('update_lines: in exception handler for NO_DATA_FOUND', 1);
666: fnd_file.put_line(fnd_file.Log, 'update_lines: in exception handler for NO_DATA_FOUND');
667: RETURN;
668: END update_comm_lines_api;
669: --
670: -- Procedure Name

Line 714: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, ''Filtering unwanted transactions from cn_comm_lines_api.'');');

710: cn_utils.set_org_id(x_org_id);
711: cn_utils.appendcr(code);
712: cn_utils.appendcr(code, '--******** FILTER PROCESSING *********-- ');
713: cn_utils.appindcr(code, 'cn_message_pkg.debug(''Filtering unwanted transactions from cn_comm_lines_api.'');');
714: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, ''Filtering unwanted transactions from cn_comm_lines_api.'');');
715: cn_utils.appendcr(code);
716: --+
717: -- Generate deletion code
718: --+