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

Line 231: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, '''|| procedure_name || '>>'');');

227: cn_utils.record_process_start('COL', '''Collection run for process '' || x_proc_audit_id', 'x_col_audit_id', code);
228: END IF;
229:
230: cn_utils.appindcr(code, 'cn_message_pkg.debug('''|| procedure_name || '>>'');');
231: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, '''|| procedure_name || '>>'');');
232: cn_utils.appindcr(code, 'MO_GLOBAL.SET_POLICY_CONTEXT (''S'','||x_org_id||');');
233: cn_utils.appendcr(code);
234:
235: cn_utils.unset_org_id();

Line 267: fnd_file.put_line(fnd_file.Log, 'call_notify >>');

263: cn_utils.appendcr(code, '--******** NOTIFY PROCESS ********-- ');
264: cn_utils.appendcr(code);
265: cn_utils.unset_org_id();
266: cn_debug.print_msg('call_notify >>', 1);
267: fnd_file.put_line(fnd_file.Log, 'call_notify >>');
268:
269: -- Translate the incoming period_names into period_ids. AE 02-28-96
270: -- We had to do this because AOL only passes VARCHAR2 input parms.
271:

Line 274: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, '''|| procedure_name || ': Call notify process begin.'');');

270: -- We had to do this because AOL only passes VARCHAR2 input parms.
271:
272: cn_utils.set_org_id(x_org_id);
273: cn_utils.appindcr(code, 'cn_message_pkg.debug('''|| procedure_name || ': Call notify process begin.'');');
274: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, '''|| procedure_name || ': Call notify process begin.'');');
275: cn_utils.appindcr(code, 'SELECT period_id ');
276: cn_utils.appindcr(code, ' INTO x_start_period_id ');
277: cn_utils.appindcr(code, ' FROM cn_periods ');
278: cn_utils.appindcr(code, 'WHERE period_name = x_start_period_name' );

Line 292: fnd_file.put_line(fnd_file.Log, 'call_notify: Generating CALL statement.');

288: cn_utils.unset_org_id();
289:
290: -- Generate the call statement
291: cn_debug.print_msg('call_notify: Generating CALL statement.', 1);
292: fnd_file.put_line(fnd_file.Log, 'call_notify: Generating CALL statement.');
293:
294: cn_utils.set_org_id(x_org_id);
295: cn_utils.appindcr(code, 'cn_message_pkg.debug('''|| procedure_name || ': entering notify.'');');
296: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, '''|| procedure_name || ': entering notify.'');');

Line 296: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, '''|| procedure_name || ': entering notify.'');');

292: fnd_file.put_line(fnd_file.Log, 'call_notify: Generating CALL statement.');
293:
294: cn_utils.set_org_id(x_org_id);
295: cn_utils.appindcr(code, 'cn_message_pkg.debug('''|| procedure_name || ': entering notify.'');');
296: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, '''|| procedure_name || ': entering notify.'');');
297:
298: IF (x_event_id = cn_global.inv_event_id) THEN
299: cn_utils.appindcr(code, 'cn_notify_invoices.notify(x_start_period_id, x_end_period_id, debug_pipe, debug_level,x_org_id);' );
300:

Line 327: fnd_file.put_line(fnd_file.Log, 'call_notify <<');

323: cn_utils.appendcr(code);
324: cn_utils.unset_org_id();
325:
326: cn_debug.print_msg('call_notify <<', 1);
327: fnd_file.put_line(fnd_file.Log, 'call_notify <<');
328:
329: cn_utils.set_org_id(x_org_id);
330: cn_utils.appindcr(code, 'cn_message_pkg.debug('''|| procedure_name || ': exit from notify and start collection run.'');');
331: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, '''|| procedure_name || ': exit from notify and start collection run.'');');

Line 331: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, '''|| procedure_name || ': exit from notify and start collection run.'');');

327: fnd_file.put_line(fnd_file.Log, 'call_notify <<');
328:
329: cn_utils.set_org_id(x_org_id);
330: cn_utils.appindcr(code, 'cn_message_pkg.debug('''|| procedure_name || ': exit from notify and start collection run.'');');
331: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, '''|| procedure_name || ': exit from notify and start collection run.'');');
332:
333: IF (x_event_id = cn_global.ord_event_id) THEN
334: cn_utils.appendcr(code, '--******** COLLECT AJUSTMENTS (NEGATE IN API) ********-- ');
335: cn_utils.appindcr(code, '-- This will negate those adjusted trx in the API table');

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

348:
349: EXCEPTION
350: WHEN NO_DATA_FOUND THEN
351: cn_debug.print_msg('call_notify: in exception handler for NO_DATA_FOUND', 1);
352: fnd_file.put_line(fnd_file.Log, 'call_notify: in exception handler for NO_DATA_FOUND');
353: RETURN;
354: END call_notify;
355:
356:

Line 389: fnd_file.put_line(fnd_file.Log, 'call_identify >>');

385: cn_utils.appendcr(code);
386: cn_utils.unset_org_id();
387:
388: cn_debug.print_msg('call_identify >>', 1);
389: fnd_file.put_line(fnd_file.Log, 'call_identify >>');
390:
391: cn_utils.set_org_id(x_org_id);
392: cn_utils.appindcr(code, 'cn_message_pkg.debug('''|| procedure_name || ': start identify process.'');');
393: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, '''|| procedure_name || ': start identify process.'');');

Line 393: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, '''|| procedure_name || ': start identify process.'');');

389: fnd_file.put_line(fnd_file.Log, 'call_identify >>');
390:
391: cn_utils.set_org_id(x_org_id);
392: cn_utils.appindcr(code, 'cn_message_pkg.debug('''|| procedure_name || ': start identify process.'');');
393: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, '''|| procedure_name || ': start identify process.'');');
394: cn_utils.appendcr(code);
395: cn_utils.appindcr(code, 'SELECT period_id ');
396: cn_utils.appindcr(code, ' INTO x_start_period_id ');
397: cn_utils.appindcr(code, ' FROM cn_periods ');

Line 412: fnd_file.put_line(fnd_file.Log, 'call_identify: Generating CALL statement.');

408: cn_utils.unset_org_id();
409:
410: -- Generate the call statement
411: cn_debug.print_msg('call_identify: Generating CALL statement.', 1);
412: fnd_file.put_line(fnd_file.Log, 'call_identify: Generating CALL statement.');
413:
414: cn_utils.set_org_id(x_org_id);
415: cn_utils.appindcr(code, 'cn_ram_adjustments_pkg.identify(x_start_period_id, x_end_period_id, debug_pipe, debug_level,x_org_id);' );
416: cn_utils.appendcr(code);

Line 420: fnd_file.put_line(fnd_file.Log, 'call_identify <<');

416: cn_utils.appendcr(code);
417: cn_utils.unset_org_id();
418:
419: cn_debug.print_msg('call_identify <<', 1);
420: fnd_file.put_line(fnd_file.Log, 'call_identify <<');
421:
422: cn_utils.set_org_id(x_org_id);
423: cn_utils.appindcr(code, 'cn_message_pkg.debug('''|| procedure_name || ': end identify process.'');');
424: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, '''|| procedure_name || ': end identify process.'');');

Line 424: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, '''|| procedure_name || ': end identify process.'');');

420: fnd_file.put_line(fnd_file.Log, 'call_identify <<');
421:
422: cn_utils.set_org_id(x_org_id);
423: cn_utils.appindcr(code, 'cn_message_pkg.debug('''|| procedure_name || ': end identify process.'');');
424: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, '''|| procedure_name || ': end identify process.'');');
425: cn_utils.appendcr(code);
426:
427: cn_utils.unset_org_id();
428: EXCEPTION

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

429:
430: WHEN NO_DATA_FOUND
431: THEN
432: cn_debug.print_msg('call_identify: in exception handler for NO_DATA_FOUND', 1);
433: fnd_file.put_line(fnd_file.Log, 'call_identify: in exception handler for NO_DATA_FOUND');
434: RETURN;
435:
436: END call_identify;
437:

Line 468: fnd_file.put_line(fnd_file.Log, 'call_negate >>');

464: cn_utils.appendcr(code);
465: cn_utils.unset_org_id();
466:
467: cn_debug.print_msg('call_negate >>', 1);
468: fnd_file.put_line(fnd_file.Log, 'call_negate >>');
469:
470: cn_utils.set_org_id(x_org_id);
471: cn_utils.appindcr(code, 'x_ram_negate_profile := CN_SYSTEM_PARAMETERS.value(''CN_RAM_NEGATE'','|| x_org_id ||');');
472: cn_utils.appendcr(code);

Line 475: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, '''|| procedure_name ||

471: cn_utils.appindcr(code, 'x_ram_negate_profile := CN_SYSTEM_PARAMETERS.value(''CN_RAM_NEGATE'','|| x_org_id ||');');
472: cn_utils.appendcr(code);
473: cn_utils.appindcr(code, 'cn_message_pkg.debug('''|| procedure_name ||
474: ': Profile OSC: Negate during Revenue Adjustments Collection = '' || x_ram_negate_profile);');
475: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, '''|| procedure_name ||
476: ': Profile OSC: Negate during Revenue Adjustments Collection = '' || x_ram_negate_profile);');
477: cn_utils.appendcr(code);
478: cn_utils.appindcr(code, 'IF x_ram_negate_profile = ''Y'' THEN ');
479: cn_utils.appindcr(code, ' cn_message_pkg.debug('''|| procedure_name || ': start negate process.'');');

Line 480: cn_utils.appindcr(code, ' fnd_file.put_line(fnd_file.Log, '''|| procedure_name || ': start negate process.'');');

476: ': Profile OSC: Negate during Revenue Adjustments Collection = '' || x_ram_negate_profile);');
477: cn_utils.appendcr(code);
478: cn_utils.appindcr(code, 'IF x_ram_negate_profile = ''Y'' THEN ');
479: cn_utils.appindcr(code, ' cn_message_pkg.debug('''|| procedure_name || ': start negate process.'');');
480: cn_utils.appindcr(code, ' fnd_file.put_line(fnd_file.Log, '''|| procedure_name || ': start negate process.'');');
481: cn_utils.appindcr(code, ' cn_ram_adjustments_pkg.negate(debug_pipe, debug_level,'||x_org_id||');' );
482: cn_utils.appindcr(code, ' cn_message_pkg.debug('''|| procedure_name || ': end negate process.'');');
483: cn_utils.appindcr(code, ' fnd_file.put_line(fnd_file.Log, '''|| procedure_name || ': end negate process.'');');
484: cn_utils.appindcr(code, 'ELSE');

Line 483: cn_utils.appindcr(code, ' fnd_file.put_line(fnd_file.Log, '''|| procedure_name || ': end negate process.'');');

479: cn_utils.appindcr(code, ' cn_message_pkg.debug('''|| procedure_name || ': start negate process.'');');
480: cn_utils.appindcr(code, ' fnd_file.put_line(fnd_file.Log, '''|| procedure_name || ': start negate process.'');');
481: cn_utils.appindcr(code, ' cn_ram_adjustments_pkg.negate(debug_pipe, debug_level,'||x_org_id||');' );
482: cn_utils.appindcr(code, ' cn_message_pkg.debug('''|| procedure_name || ': end negate process.'');');
483: cn_utils.appindcr(code, ' fnd_file.put_line(fnd_file.Log, '''|| procedure_name || ': end negate process.'');');
484: cn_utils.appindcr(code, 'ELSE');
485: cn_utils.appindcr(code, ' cn_message_pkg.debug('''|| procedure_name || ': skip negate process.'');');
486: cn_utils.appindcr(code, ' fnd_file.put_line(fnd_file.Log, '''|| procedure_name || ': skip negate process.'');');
487: cn_utils.appendcr(code);

Line 486: cn_utils.appindcr(code, ' fnd_file.put_line(fnd_file.Log, '''|| procedure_name || ': skip negate process.'');');

482: cn_utils.appindcr(code, ' cn_message_pkg.debug('''|| procedure_name || ': end negate process.'');');
483: cn_utils.appindcr(code, ' fnd_file.put_line(fnd_file.Log, '''|| procedure_name || ': end negate process.'');');
484: cn_utils.appindcr(code, 'ELSE');
485: cn_utils.appindcr(code, ' cn_message_pkg.debug('''|| procedure_name || ': skip negate process.'');');
486: cn_utils.appindcr(code, ' fnd_file.put_line(fnd_file.Log, '''|| procedure_name || ': skip negate process.'');');
487: cn_utils.appendcr(code);
488: cn_utils.appindcr(code, ' UPDATE cn_trx_lines ctl');
489: cn_utils.appindcr(code, ' SET negated_flag = ''Y''');
490: cn_utils.appindcr(code, ' WHERE ctl.adjusted_flag = ''Y'' and');

Line 501: fnd_file.put_line(fnd_file.Log, 'call_negate <<');

497: cn_utils.appendcr(code);
498: cn_utils.unset_org_id();
499:
500: cn_debug.print_msg('call_negate <<', 1);
501: fnd_file.put_line(fnd_file.Log, 'call_negate <<');
502:
503: cn_message_pkg.DEBUG('collect: Profile OSC: Negate during Revenue Adjustments Collection = ' ||
504: CN_SYSTEM_PARAMETERS.value('CN_RAM_NEGATE',x_org_id));
505: fnd_file.put_line(fnd_file.Log,'collect: Profile OSC: Negate during Revenue Adjustments Collection = ' ||

Line 505: fnd_file.put_line(fnd_file.Log,'collect: Profile OSC: Negate during Revenue Adjustments Collection = ' ||

501: fnd_file.put_line(fnd_file.Log, 'call_negate <<');
502:
503: cn_message_pkg.DEBUG('collect: Profile OSC: Negate during Revenue Adjustments Collection = ' ||
504: CN_SYSTEM_PARAMETERS.value('CN_RAM_NEGATE',x_org_id));
505: fnd_file.put_line(fnd_file.Log,'collect: Profile OSC: Negate during Revenue Adjustments Collection = ' ||
506: CN_SYSTEM_PARAMETERS.value('CN_RAM_NEGATE',x_org_id));
507:
508: EXCEPTION
509: WHEN NO_DATA_FOUND THEN

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

507:
508: EXCEPTION
509: WHEN NO_DATA_FOUND THEN
510: cn_debug.print_msg('call_negate: in exception handler for NO_DATA_FOUND', 1);
511: fnd_file.put_line(fnd_file.Log, 'call_negate: in exception handler for NO_DATA_FOUND');
512: RETURN;
513: END call_negate;
514:
515:

Line 536: fnd_file.put_line(fnd_file.Log, 'local_variables>>');

532:
533: IF (x_event_id = cn_global.ram_event_id) THEN
534:
535: cn_debug.print_msg('local_variables>>', 1);
536: fnd_file.put_line(fnd_file.Log, 'local_variables>>');
537:
538: cn_utils.set_org_id(x_org_id);
539: cn_utils.indent(code, 1);
540: cn_utils.appindcr(code, 'trx_sales_line_count NUMBER := 0;');

Line 582: fnd_file.put_line(fnd_file.Log, 'local_variables<<');

578: cn_utils.unindent(code, 1);
579: cn_utils.unset_org_id();
580:
581: cn_debug.print_msg('local_variables<<', 1);
582: fnd_file.put_line(fnd_file.Log, 'local_variables<<');
583:
584: ELSE
585:
586: cn_debug.print_msg('local_variables>>', 1);

Line 587: fnd_file.put_line(fnd_file.Log, 'local_variables<<');

583:
584: ELSE
585:
586: cn_debug.print_msg('local_variables>>', 1);
587: fnd_file.put_line(fnd_file.Log, 'local_variables<<');
588:
589: cn_utils.set_org_id(x_org_id);
590: cn_utils.indent(code, 1);
591: cn_utils.appindcr(code, 'trx_count NUMBER := 0;');

Line 635: fnd_file.put_line(fnd_file.Log, 'local_variables<<');

631: cn_utils.unindent(code, 1);
632: cn_utils.unset_org_id();
633: end if;
634: cn_debug.print_msg('local_variables<<', 1);
635: fnd_file.put_line(fnd_file.Log, 'local_variables<<');
636: END IF; -- IF (procedure_name = 'cn_collect_ram')
637:
638: cn_utils.unset_org_id;
639:

Line 657: fnd_file.put_line(fnd_file.Log, 'who>>');

653: -- The who code has been temporarily commented out since the who package
654: -- is yet to be implemented.
655:
656: cn_debug.print_msg('who>>', 1);
657: fnd_file.put_line(fnd_file.Log, 'who>>');
658:
659: cn_utils.set_org_id(x_org_id);
660: cn_utils.appindcr(code, '-- who.set_program_name(''' || procedure_name || ''');');
661: cn_utils.appendcr(code);

Line 665: fnd_file.put_line(fnd_file.Log, 'who<<');

661: cn_utils.appendcr(code);
662: cn_utils.unset_org_id();
663:
664: cn_debug.print_msg('who<<', 1);
665: fnd_file.put_line(fnd_file.Log, 'who<<');
666:
667: END who;
668:
669: -- Procedure Name

Line 692: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log,''' || x_procedure_name || ': Rollback.'');');

688: cn_utils.indent(code, 1);
689: IF (savepoint_name IS NOT NULL) THEN
690: cn_utils.appindcr(code, 'WHEN OTHERS THEN ROLLBACK TO ' || savepoint_name || ';');
691: cn_utils.appindcr(code, 'cn_message_pkg.debug(''' || x_procedure_name || ': Rollback.'');');
692: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log,''' || x_procedure_name || ': Rollback.'');');
693: ELSE
694: cn_utils.appindcr(code, 'WHEN OTHERS THEN ');
695: END IF;
696:

Line 698: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, ''' || x_procedure_name || ': In exception handler ' || location ||'.'');');

694: cn_utils.appindcr(code, 'WHEN OTHERS THEN ');
695: END IF;
696:
697: cn_utils.appindcr(code, 'cn_message_pkg.debug(''' || x_procedure_name || ': In exception handler ' || location ||'.'');');
698: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, ''' || x_procedure_name || ': In exception handler ' || location ||'.'');');
699: cn_utils.appendcr(code);
700:
701: cn_utils.appindcr(code, 'cn_process_audits_pkg.update_row(x_proc_audit_id, NULL, SYSDATE, SQLCODE,');
702: cn_utils.appindcr(code, ' SQLERRM);');

Line 705: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, sqlcode ||'''||' '||'''||sqlerrm);');

701: cn_utils.appindcr(code, 'cn_process_audits_pkg.update_row(x_proc_audit_id, NULL, SYSDATE, SQLCODE,');
702: cn_utils.appindcr(code, ' SQLERRM);');
703: cn_utils.appendcr(code);
704: cn_utils.appindcr(code, 'cn_message_pkg.debug(sqlcode ||'''||' '||'''||sqlerrm);');
705: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, sqlcode ||'''||' '||'''||sqlerrm);');
706: cn_utils.appindcr(code, 'cn_message_pkg.end_batch(x_proc_audit_id);');
707: cn_utils.appendcr(code);
708:
709: cn_utils.appindcr(code, 'app_exception.raise_exception;');

Line 742: fnd_file.put_line(fnd_file.Log, 'pkg_proc_init>>');

738:
739: l_org_id := x_org_id;
740:
741: cn_debug.print_msg('pkg_proc_init>>', 1);
742: fnd_file.put_line(fnd_file.Log, 'pkg_proc_init>>');
743:
744: cn_utils.set_org_id(X_org_id);
745: cn_utils.proc_init(x_procedure_name, x_description, x_parameter_list,
746: 'P', NULL, x_package_id, x_repository_id, spec_code, body_code);

Line 824: cn_utils.appindcr(body_code, 'fnd_file.put_line(fnd_file.Log, '''|| x_procedure_name || ': entering cursor Batches loop.'');');

820: --Condition added to fix bug 6203234
821: IF(x_event_id < 0)
822: THEN
823: cn_utils.appindcr(body_code, 'cn_message_pkg.debug('''|| x_procedure_name || ': entering cursor Batches loop.'');');
824: cn_utils.appindcr(body_code, 'fnd_file.put_line(fnd_file.Log, '''|| x_procedure_name || ': entering cursor Batches loop.'');');
825: cn_utils.appendcr(body_code);
826:
827: cn_utils.appindcr(body_code, 'FOR b IN batches LOOP');
828: cn_utils.appendcr(body_code);

Line 848: fnd_file.put_line(fnd_file.Log, 'pkg_proc_init<<');

844: cn_utils.appendcr(body_code);
845: END IF;
846: cn_utils.unset_org_id();
847: cn_debug.print_msg('pkg_proc_init<<', 1);
848: fnd_file.put_line(fnd_file.Log, 'pkg_proc_init<<');
849:
850:
851: END pkg_proc_init;
852:

Line 878: fnd_file.put_line(fnd_file.Log, 'collect_stmts>>');

874:
875: l_org_id := x_org_id;
876:
877: cn_debug.print_msg('collect_stmts>>', 1);
878: fnd_file.put_line(fnd_file.Log, 'collect_stmts>>');
879:
880: IF x_generic OR
881: x_event_id = cn_global.ord_event_id THEN
882: IF x_generic THEN

Line 938: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, ''' || x_procedure_name || ': update CN_TRX and CN_TRX_LINES.''); ');

934: cn_utils.set_org_id(X_org_id);
935: cn_utils.appendcr(code);
936: cn_utils.appendcr(code, '--******** UPDATE CN_TRX CN_TRX_LINES ********-- ');
937: cn_utils.appindcr(code, 'cn_message_pkg.debug(''' || x_procedure_name || ': update CN_TRX and CN_TRX_LINES.''); ');
938: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, ''' || x_procedure_name || ': update CN_TRX and CN_TRX_LINES.''); ');
939: cn_utils.appendcr(code);
940: cn_utils.appindcr(code, 'UPDATE cn_trx ');
941: cn_utils.appindcr(code, ' SET adj_collection_run_id = x_proc_audit_id ');
942: cn_utils.appindcr(code, ' WHERE trx_id IN (SELECT trx_id from cn_trx_lines ');

Line 953: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, ''' || x_procedure_name || ': Updated '' || trx_update_count || '' records in cn_trx.''); ');

949: cn_utils.appindcr(code, ' AND org_id = '||x_org_id||';');
950: cn_utils.appendcr(code);
951: cn_utils.appindcr(code, 'trx_update_count := SQL%ROWCOUNT; ');
952: cn_utils.appindcr(code, 'cn_message_pkg.debug(''' || x_procedure_name || ': Updated '' || trx_update_count || '' records in cn_trx.''); ');
953: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, ''' || x_procedure_name || ': Updated '' || trx_update_count || '' records in cn_trx.''); ');
954: cn_utils.appendcr(code);
955: cn_utils.appindcr(code, 'UPDATE cn_trx_lines ');
956: cn_utils.appindcr(code, ' SET adj_collection_run_id = x_proc_audit_id ');
957: cn_utils.appindcr(code, ' WHERE adjusted_flag = ''Y'' ');

Line 966: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, ''' || x_procedure_name || ': Updated '' || trx_line_update_count || '' records in cn_trx_lines.''); ');

962: cn_utils.appindcr(code, ' AND org_id = '||x_org_id||';');
963: cn_utils.appendcr(code);
964: cn_utils.appindcr(code, 'trx_line_update_count := SQL%ROWCOUNT; ');
965: cn_utils.appindcr(code, 'cn_message_pkg.debug(''' || x_procedure_name || ': Updated '' || trx_line_update_count || '' records in cn_trx_lines.''); ');
966: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, ''' || x_procedure_name || ': Updated '' || trx_line_update_count || '' records in cn_trx_lines.''); ');
967: cn_utils.appendcr(code);
968: cn_utils.indent(code, 1);
969:
970: ELSE -- Regular Receivables Collection

Line 1045: fnd_file.put_line(fnd_file.Log, 'collect_stmts<<');

1041: END IF;
1042: cn_utils.unset_org_id();
1043:
1044: cn_debug.print_msg('collect_stmts<<', 1);
1045: fnd_file.put_line(fnd_file.Log, 'collect_stmts<<');
1046:
1047:
1048: END collect_stmts;
1049:

Line 1068: fnd_file.put_line(fnd_file.Log, 'pkg_proc_end>>');

1064: x_org_id IN NUMBER) IS
1065: BEGIN
1066:
1067: cn_debug.print_msg('pkg_proc_end>>', 1);
1068: fnd_file.put_line(fnd_file.Log, 'pkg_proc_end>>');
1069: cn_utils.set_org_id(x_org_id);
1070: -- Generate code to record success or failure of batch
1071: IF(x_event_id < 0)
1072: THEN

Line 1080: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, '''|| x_procedure_name || ': inside loop<<'');');

1076: cn_utils.record_process_success('''Finished collection run for batch '' || x_batch_id', code);
1077: END IF;
1078:
1079: cn_utils.appindcr(code, 'cn_message_pkg.debug('''|| x_procedure_name || ': inside loop<<'');');
1080: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, '''|| x_procedure_name || ': inside loop<<'');');
1081: cn_utils.appindcr(code, 'cn_message_pkg.end_batch(x_proc_audit_id);');
1082: cn_utils.appindcr(code, 'COMMIT;');
1083: cn_utils.appendcr(code);
1084:

Line 1120: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, '''|| x_procedure_name ||'<<'');');

1116:
1117: cn_utils.appindcr(code, 'x_proc_audit_id := x_col_audit_id;'); --AE 08-01-95
1118:
1119: cn_utils.appindcr(code, 'cn_message_pkg.debug('''|| x_procedure_name ||'<<'');');
1120: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, '''|| x_procedure_name ||'<<'');');
1121:
1122: cn_utils.appindcr(code, 'cn_message_pkg.end_batch(x_proc_audit_id);');
1123: cn_utils.appendcr(code);
1124:

Line 1137: fnd_file.put_line(fnd_file.Log, 'pkg_proc_end<<');

1133: cn_utils.appendcr(code);
1134: cn_utils.unset_org_id();
1135:
1136: cn_debug.print_msg('pkg_proc_end<<', 1);
1137: fnd_file.put_line(fnd_file.Log, 'pkg_proc_end<<');
1138:
1139: END pkg_proc_end;
1140:
1141:

Line 1190: fnd_file.put_line(fnd_file.Log, 'collection_proc>>');

1186: --dbms_output.put_line('--- NOT x_generic parameter_list');
1187: --dbms_output.put_line(parameter_list);
1188:
1189: cn_debug.print_msg('collection_proc>>', 1);
1190: fnd_file.put_line(fnd_file.Log, 'collection_proc>>');
1191:
1192: -- Generate procedure definition, boilerplate text, local variables etc.
1193: --dbms_output.put_line(' Before pkg_proc_init ');
1194:

Line 1214: fnd_file.put_line(fnd_file.Log, 'collection_proc<<');

1210:
1211: pkg_proc_end(x_table_map_id, procedure_name, event_id,body_code,X_org_id);
1212:
1213: cn_debug.print_msg('collection_proc<<', 1);
1214: fnd_file.put_line(fnd_file.Log, 'collection_proc<<');
1215:
1216: END collection_proc;
1217: --+
1218: -- Procedure Name

Line 1249: fnd_file.put_line(fnd_file.Log, 'null_proc>>');

1245:
1246: l_org_id := x_org_id;
1247:
1248: cn_debug.print_msg('null_proc>>', 1);
1249: fnd_file.put_line(fnd_file.Log, 'null_proc>>');
1250:
1251: -- Generate procedure definition, boilerplate text, local variables etc.
1252:
1253: cn_utils.set_org_id(X_org_id);

Line 1275: cn_utils.appindcr(body_code, 'fnd_file.put_line(fnd_file.Log, '''|| procedure_name || ': Nothing is being collected.'');');

1271: cn_utils.appindcr(body_code, 'NULL;');
1272: cn_utils.appendcr(body_code);
1273:
1274: cn_utils.appindcr(body_code, 'cn_message_pkg.debug('''|| procedure_name || ': Nothing is being collected.'');');
1275: cn_utils.appindcr(body_code, 'fnd_file.put_line(fnd_file.Log, '''|| procedure_name || ': Nothing is being collected.'');');
1276: cn_utils.appindcr(body_code, 'cn_message_pkg.debug('''|| procedure_name ||'<<'');');
1277: cn_utils.appindcr(body_code, 'fnd_file.put_line(fnd_file.Log, '''|| procedure_name ||'<<'');');
1278: cn_utils.appindcr(body_code, 'cn_message_pkg.end_batch(x_proc_audit_id);');
1279: cn_utils.appendcr(body_code);

Line 1277: cn_utils.appindcr(body_code, 'fnd_file.put_line(fnd_file.Log, '''|| procedure_name ||'<<'');');

1273:
1274: cn_utils.appindcr(body_code, 'cn_message_pkg.debug('''|| procedure_name || ': Nothing is being collected.'');');
1275: cn_utils.appindcr(body_code, 'fnd_file.put_line(fnd_file.Log, '''|| procedure_name || ': Nothing is being collected.'');');
1276: cn_utils.appindcr(body_code, 'cn_message_pkg.debug('''|| procedure_name ||'<<'');');
1277: cn_utils.appindcr(body_code, 'fnd_file.put_line(fnd_file.Log, '''|| procedure_name ||'<<'');');
1278: cn_utils.appindcr(body_code, 'cn_message_pkg.end_batch(x_proc_audit_id);');
1279: cn_utils.appendcr(body_code);
1280:
1281:

Line 1291: fnd_file.put_line(fnd_file.Log, 'null_proc<<');

1287: cn_utils.appendcr(body_code);
1288: cn_utils.unset_org_id();
1289:
1290: cn_debug.print_msg('null_proc<<', 1);
1291: fnd_file.put_line(fnd_file.Log, 'null_proc<<');
1292:
1293: END null_proc;
1294:
1295:

Line 1339: fnd_file.put_line(fnd_file.Log, 'collection_pkg_code>>');

1335: IF (debug_pipe IS NOT NULL) THEN
1336: cn_debug.init_pipe(debug_pipe, debug_level);
1337: END IF;
1338: cn_debug.print_msg('collection_pkg_code>>', 1);
1339: fnd_file.put_line(fnd_file.Log, 'collection_pkg_code>>');
1340:
1341: --+
1342: -- Define package in Commissions dictionary, initialize code etc.
1343: -- Note: pkg_init calls delete_module in cn_utils to delete current mod.

Line 1371: fnd_file.put_line(fnd_file.Log, 'collection_pkg_code<<');

1367: l_spec_code, l_body_code);
1368:
1369: cn_utils.unset_org_id();
1370: cn_debug.print_msg('collection_pkg_code<<', 1);
1371: fnd_file.put_line(fnd_file.Log, 'collection_pkg_code<<');
1372:
1373: END collection_pkg_code;
1374:
1375: --------------------------------------------------------+

Line 1445: fnd_file.put_line(fnd_file.Log, 'collection_pkg>>');

1441: IF (debug_pipe IS NOT NULL) THEN
1442: cn_debug.init_pipe(debug_pipe, debug_level);
1443: END IF;
1444: cn_debug.print_msg('collection_pkg>>', 1);
1445: fnd_file.put_line(fnd_file.Log, 'collection_pkg>>');
1446: --+
1447: -- Get info about this data source from cn_table_maps
1448: --+
1449: SELECT mapping_type, module_id

Line 1540: fnd_file.put_line(fnd_file.Log, 'collection_pkg<<');

1536: --dbms_output.put_line(' Out OF collection_pkg_code ');
1537: END IF;
1538: --COMMIT;
1539: cn_debug.print_msg('collection_pkg<<', 1);
1540: fnd_file.put_line(fnd_file.Log, 'collection_pkg<<');
1541: END collection_pkg;
1542:
1543: PROCEDURE Collection_Install(
1544: x_errbuf OUT NOCOPY VARCHAR2,