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 233: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, '''|| procedure_name || '>>'');');

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

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

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

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

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

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

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

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

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

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

330: cn_utils.appendcr(code);
331: cn_utils.unset_org_id();
332:
333: cn_debug.print_msg('call_notify <<', 1);
334: fnd_file.put_line(fnd_file.Log, 'call_notify <<');
335:
336: cn_utils.set_org_id(x_org_id);
337: cn_utils.appindcr(code, 'cn_message_pkg.debug('''|| procedure_name || ': exit from notify and start collection run.'');');
338: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, '''|| procedure_name || ': exit from notify and start collection run.'');');

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

334: fnd_file.put_line(fnd_file.Log, 'call_notify <<');
335:
336: cn_utils.set_org_id(x_org_id);
337: cn_utils.appindcr(code, 'cn_message_pkg.debug('''|| procedure_name || ': exit from notify and start collection run.'');');
338: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, '''|| procedure_name || ': exit from notify and start collection run.'');');
339:
340: IF (x_event_id = cn_global.ord_event_id) THEN
341: cn_utils.appendcr(code, '--******** COLLECT AJUSTMENTS (NEGATE IN API) ********-- ');
342: cn_utils.appindcr(code, '-- This will negate those adjusted trx in the API table');

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

355:
356: EXCEPTION
357: WHEN NO_DATA_FOUND THEN
358: cn_debug.print_msg('call_notify: in exception handler for NO_DATA_FOUND', 1);
359: fnd_file.put_line(fnd_file.Log, 'call_notify: in exception handler for NO_DATA_FOUND');
360: RETURN;
361: END call_notify;
362:
363:

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

392: cn_utils.appendcr(code);
393: cn_utils.unset_org_id();
394:
395: cn_debug.print_msg('call_identify >>', 1);
396: fnd_file.put_line(fnd_file.Log, 'call_identify >>');
397:
398: cn_utils.set_org_id(x_org_id);
399: cn_utils.appindcr(code, 'cn_message_pkg.debug('''|| procedure_name || ': start identify process.'');');
400: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, '''|| procedure_name || ': start identify process.'');');

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

396: fnd_file.put_line(fnd_file.Log, 'call_identify >>');
397:
398: cn_utils.set_org_id(x_org_id);
399: cn_utils.appindcr(code, 'cn_message_pkg.debug('''|| procedure_name || ': start identify process.'');');
400: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, '''|| procedure_name || ': start identify process.'');');
401: cn_utils.appendcr(code);
402: cn_utils.appindcr(code, 'SELECT period_id ');
403: cn_utils.appindcr(code, ' INTO x_start_period_id ');
404: cn_utils.appindcr(code, ' FROM cn_periods ');

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

415: cn_utils.unset_org_id();
416:
417: -- Generate the call statement
418: cn_debug.print_msg('call_identify: Generating CALL statement.', 1);
419: fnd_file.put_line(fnd_file.Log, 'call_identify: Generating CALL statement.');
420:
421: cn_utils.set_org_id(x_org_id);
422: cn_utils.appindcr(code, 'cn_ram_adjustments_pkg.identify(x_start_period_id, x_end_period_id, debug_pipe, debug_level,x_org_id);' );
423: cn_utils.appendcr(code);

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

423: cn_utils.appendcr(code);
424: cn_utils.unset_org_id();
425:
426: cn_debug.print_msg('call_identify <<', 1);
427: fnd_file.put_line(fnd_file.Log, 'call_identify <<');
428:
429: cn_utils.set_org_id(x_org_id);
430: cn_utils.appindcr(code, 'cn_message_pkg.debug('''|| procedure_name || ': end identify process.'');');
431: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, '''|| procedure_name || ': end identify process.'');');

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

427: fnd_file.put_line(fnd_file.Log, 'call_identify <<');
428:
429: cn_utils.set_org_id(x_org_id);
430: cn_utils.appindcr(code, 'cn_message_pkg.debug('''|| procedure_name || ': end identify process.'');');
431: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, '''|| procedure_name || ': end identify process.'');');
432: cn_utils.appendcr(code);
433:
434: cn_utils.unset_org_id();
435: EXCEPTION

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

436:
437: WHEN NO_DATA_FOUND
438: THEN
439: cn_debug.print_msg('call_identify: in exception handler for NO_DATA_FOUND', 1);
440: fnd_file.put_line(fnd_file.Log, 'call_identify: in exception handler for NO_DATA_FOUND');
441: RETURN;
442:
443: END call_identify;
444:

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

471: cn_utils.appendcr(code);
472: cn_utils.unset_org_id();
473:
474: cn_debug.print_msg('call_negate >>', 1);
475: fnd_file.put_line(fnd_file.Log, 'call_negate >>');
476:
477: cn_utils.set_org_id(x_org_id);
478: cn_utils.appindcr(code, 'x_ram_negate_profile := CN_SYSTEM_PARAMETERS.value(''CN_RAM_NEGATE'','|| x_org_id ||');');
479: cn_utils.appendcr(code);

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

478: cn_utils.appindcr(code, 'x_ram_negate_profile := CN_SYSTEM_PARAMETERS.value(''CN_RAM_NEGATE'','|| x_org_id ||');');
479: cn_utils.appendcr(code);
480: cn_utils.appindcr(code, 'cn_message_pkg.debug('''|| procedure_name ||
481: ': Profile OSC: Negate during Revenue Adjustments Collection = '' || x_ram_negate_profile);');
482: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, '''|| procedure_name ||
483: ': Profile OSC: Negate during Revenue Adjustments Collection = '' || x_ram_negate_profile);');
484: cn_utils.appendcr(code);
485: cn_utils.appindcr(code, 'IF x_ram_negate_profile = ''Y'' THEN ');
486: cn_utils.appindcr(code, ' cn_message_pkg.debug('''|| procedure_name || ': start negate process.'');');

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

483: ': Profile OSC: Negate during Revenue Adjustments Collection = '' || x_ram_negate_profile);');
484: cn_utils.appendcr(code);
485: cn_utils.appindcr(code, 'IF x_ram_negate_profile = ''Y'' THEN ');
486: cn_utils.appindcr(code, ' cn_message_pkg.debug('''|| procedure_name || ': start negate process.'');');
487: cn_utils.appindcr(code, ' fnd_file.put_line(fnd_file.Log, '''|| procedure_name || ': start negate process.'');');
488: cn_utils.appindcr(code, ' cn_ram_adjustments_pkg.negate(debug_pipe, debug_level,'||x_org_id||');' );
489: cn_utils.appindcr(code, ' cn_message_pkg.debug('''|| procedure_name || ': end negate process.'');');
490: cn_utils.appindcr(code, ' fnd_file.put_line(fnd_file.Log, '''|| procedure_name || ': end negate process.'');');
491: cn_utils.appindcr(code, 'ELSE');

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

486: cn_utils.appindcr(code, ' cn_message_pkg.debug('''|| procedure_name || ': start negate process.'');');
487: cn_utils.appindcr(code, ' fnd_file.put_line(fnd_file.Log, '''|| procedure_name || ': start negate process.'');');
488: cn_utils.appindcr(code, ' cn_ram_adjustments_pkg.negate(debug_pipe, debug_level,'||x_org_id||');' );
489: cn_utils.appindcr(code, ' cn_message_pkg.debug('''|| procedure_name || ': end negate process.'');');
490: cn_utils.appindcr(code, ' fnd_file.put_line(fnd_file.Log, '''|| procedure_name || ': end negate process.'');');
491: cn_utils.appindcr(code, 'ELSE');
492: cn_utils.appindcr(code, ' cn_message_pkg.debug('''|| procedure_name || ': skip negate process.'');');
493: cn_utils.appindcr(code, ' fnd_file.put_line(fnd_file.Log, '''|| procedure_name || ': skip negate process.'');');
494: cn_utils.appendcr(code);

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

489: cn_utils.appindcr(code, ' cn_message_pkg.debug('''|| procedure_name || ': end negate process.'');');
490: cn_utils.appindcr(code, ' fnd_file.put_line(fnd_file.Log, '''|| procedure_name || ': end negate process.'');');
491: cn_utils.appindcr(code, 'ELSE');
492: cn_utils.appindcr(code, ' cn_message_pkg.debug('''|| procedure_name || ': skip negate process.'');');
493: cn_utils.appindcr(code, ' fnd_file.put_line(fnd_file.Log, '''|| procedure_name || ': skip negate process.'');');
494: cn_utils.appendcr(code);
495: cn_utils.appindcr(code, ' UPDATE cn_trx_lines ctl');
496: cn_utils.appindcr(code, ' SET negated_flag = ''Y''');
497: cn_utils.appindcr(code, ' WHERE ctl.adjusted_flag = ''Y'' and');

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

504: cn_utils.appendcr(code);
505: cn_utils.unset_org_id();
506:
507: cn_debug.print_msg('call_negate <<', 1);
508: fnd_file.put_line(fnd_file.Log, 'call_negate <<');
509:
510: cn_message_pkg.DEBUG('collect: Profile OSC: Negate during Revenue Adjustments Collection = ' ||
511: CN_SYSTEM_PARAMETERS.value('CN_RAM_NEGATE',x_org_id));
512: fnd_file.put_line(fnd_file.Log,'collect: Profile OSC: Negate during Revenue Adjustments Collection = ' ||

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

508: fnd_file.put_line(fnd_file.Log, 'call_negate <<');
509:
510: cn_message_pkg.DEBUG('collect: Profile OSC: Negate during Revenue Adjustments Collection = ' ||
511: CN_SYSTEM_PARAMETERS.value('CN_RAM_NEGATE',x_org_id));
512: fnd_file.put_line(fnd_file.Log,'collect: Profile OSC: Negate during Revenue Adjustments Collection = ' ||
513: CN_SYSTEM_PARAMETERS.value('CN_RAM_NEGATE',x_org_id));
514:
515: EXCEPTION
516: WHEN NO_DATA_FOUND THEN

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

514:
515: EXCEPTION
516: WHEN NO_DATA_FOUND THEN
517: cn_debug.print_msg('call_negate: in exception handler for NO_DATA_FOUND', 1);
518: fnd_file.put_line(fnd_file.Log, 'call_negate: in exception handler for NO_DATA_FOUND');
519: RETURN;
520: END call_negate;
521:
522:

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

539:
540: IF (x_event_id = cn_global.ram_event_id) THEN
541:
542: cn_debug.print_msg('local_variables>>', 1);
543: fnd_file.put_line(fnd_file.Log, 'local_variables>>');
544:
545: cn_utils.set_org_id(x_org_id);
546: cn_utils.indent(code, 1);
547: cn_utils.appindcr(code, 'trx_sales_line_count NUMBER := 0;');

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

585: cn_utils.unindent(code, 1);
586: cn_utils.unset_org_id();
587:
588: cn_debug.print_msg('local_variables<<', 1);
589: fnd_file.put_line(fnd_file.Log, 'local_variables<<');
590:
591: ELSE
592:
593: cn_debug.print_msg('local_variables>>', 1);

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

590:
591: ELSE
592:
593: cn_debug.print_msg('local_variables>>', 1);
594: fnd_file.put_line(fnd_file.Log, 'local_variables<<');
595:
596: cn_utils.set_org_id(x_org_id);
597: cn_utils.indent(code, 1);
598: cn_utils.appindcr(code, 'trx_count NUMBER := 0;');

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

650: cn_utils.unindent(code, 1);
651: cn_utils.unset_org_id();
652: -- end if;
653: cn_debug.print_msg('local_variables<<', 1);
654: fnd_file.put_line(fnd_file.Log, 'local_variables<<');
655: END IF; -- IF (procedure_name = 'cn_collect_ram')
656:
657: cn_utils.unset_org_id;
658:

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

672: -- The who code has been temporarily commented out since the who package
673: -- is yet to be implemented.
674:
675: cn_debug.print_msg('who>>', 1);
676: fnd_file.put_line(fnd_file.Log, 'who>>');
677:
678: cn_utils.set_org_id(x_org_id);
679: cn_utils.appindcr(code, '-- who.set_program_name(''' || procedure_name || ''');');
680: cn_utils.appendcr(code);

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

680: cn_utils.appendcr(code);
681: cn_utils.unset_org_id();
682:
683: cn_debug.print_msg('who<<', 1);
684: fnd_file.put_line(fnd_file.Log, 'who<<');
685:
686: END who;
687:
688: -- Procedure Name

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

707: cn_utils.indent(code, 1);
708: IF (savepoint_name IS NOT NULL) THEN
709: cn_utils.appindcr(code, 'WHEN OTHERS THEN ROLLBACK TO ' || savepoint_name || ';');
710: cn_utils.appindcr(code, 'cn_message_pkg.debug(''' || x_procedure_name || ': Rollback.'');');
711: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log,''' || x_procedure_name || ': Rollback.'');');
712: ELSE
713: cn_utils.appindcr(code, 'WHEN OTHERS THEN ');
714: END IF;
715:

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

713: cn_utils.appindcr(code, 'WHEN OTHERS THEN ');
714: END IF;
715:
716: cn_utils.appindcr(code, 'cn_message_pkg.debug(''' || x_procedure_name || ': In exception handler ' || location ||'.'');');
717: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, ''' || x_procedure_name || ': In exception handler ' || location ||'.'');');
718: cn_utils.appendcr(code);
719:
720: cn_utils.appindcr(code, 'cn_process_audits_pkg.update_row(x_proc_audit_id, NULL, SYSDATE, SQLCODE,');
721: cn_utils.appindcr(code, ' SQLERRM);');

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

720: cn_utils.appindcr(code, 'cn_process_audits_pkg.update_row(x_proc_audit_id, NULL, SYSDATE, SQLCODE,');
721: cn_utils.appindcr(code, ' SQLERRM);');
722: cn_utils.appendcr(code);
723: cn_utils.appindcr(code, 'cn_message_pkg.debug(sqlcode ||'''||' '||'''||sqlerrm);');
724: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, sqlcode ||'''||' '||'''||sqlerrm);');
725: cn_utils.appindcr(code, 'cn_message_pkg.end_batch(x_proc_audit_id);');
726: cn_utils.appendcr(code);
727:
728: cn_utils.appindcr(code, 'app_exception.raise_exception;');

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

757:
758: l_org_id := x_org_id;
759:
760: cn_debug.print_msg('pkg_proc_init>>', 1);
761: fnd_file.put_line(fnd_file.Log, 'pkg_proc_init>>');
762:
763: cn_utils.set_org_id(X_org_id);
764: cn_utils.proc_init(x_procedure_name, x_description, x_parameter_list,
765: 'P', NULL, x_package_id, x_repository_id, spec_code, body_code);

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

851: -- Fix for bug 8371984
852: --IF(x_event_id < 0)
853: --THEN
854: cn_utils.appindcr(body_code, 'cn_message_pkg.debug('''|| x_procedure_name || ': entering cursor Batches loop.'');');
855: cn_utils.appindcr(body_code, 'fnd_file.put_line(fnd_file.Log, '''|| x_procedure_name || ': entering cursor Batches loop.'');');
856: cn_utils.appendcr(body_code);
857:
858: cn_utils.appindcr(body_code, 'FOR b IN batches LOOP');
859: cn_utils.appendcr(body_code);

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

875: cn_utils.appendcr(body_code);
876: --END IF;
877: cn_utils.unset_org_id();
878: cn_debug.print_msg('pkg_proc_init<<', 1);
879: fnd_file.put_line(fnd_file.Log, 'pkg_proc_init<<');
880:
881:
882: END pkg_proc_init;
883:

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

905:
906: l_org_id := x_org_id;
907:
908: cn_debug.print_msg('collect_stmts>>', 1);
909: fnd_file.put_line(fnd_file.Log, 'collect_stmts>>');
910:
911: IF x_generic OR
912: x_event_id = cn_global.ord_event_id THEN
913: IF x_generic THEN

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

965: cn_utils.set_org_id(X_org_id);
966: cn_utils.appendcr(code);
967: cn_utils.appendcr(code, '--******** UPDATE CN_TRX CN_TRX_LINES ********-- ');
968: cn_utils.appindcr(code, 'cn_message_pkg.debug(''' || x_procedure_name || ': update CN_TRX and CN_TRX_LINES.''); ');
969: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, ''' || x_procedure_name || ': update CN_TRX and CN_TRX_LINES.''); ');
970: cn_utils.appendcr(code);
971: cn_utils.appindcr(code, 'UPDATE cn_trx ');
972: cn_utils.appindcr(code, ' SET adj_collection_run_id = x_proc_audit_id ');
973: cn_utils.appindcr(code, ' WHERE trx_id IN (SELECT trx_id from cn_trx_lines ');

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

980: cn_utils.appindcr(code, ' AND org_id = '||x_org_id||';');
981: cn_utils.appendcr(code);
982: cn_utils.appindcr(code, 'trx_update_count := SQL%ROWCOUNT; ');
983: cn_utils.appindcr(code, 'cn_message_pkg.debug(''' || x_procedure_name || ': Updated '' || trx_update_count || '' records in cn_trx.''); ');
984: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, ''' || x_procedure_name || ': Updated '' || trx_update_count || '' records in cn_trx.''); ');
985: cn_utils.appendcr(code);
986: cn_utils.appindcr(code, 'UPDATE cn_trx_lines ');
987: cn_utils.appindcr(code, ' SET adj_collection_run_id = x_proc_audit_id ');
988: cn_utils.appindcr(code, ' WHERE adjusted_flag = ''Y'' ');

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

993: cn_utils.appindcr(code, ' AND org_id = '||x_org_id||';');
994: cn_utils.appendcr(code);
995: cn_utils.appindcr(code, 'trx_line_update_count := SQL%ROWCOUNT; ');
996: cn_utils.appindcr(code, 'cn_message_pkg.debug(''' || x_procedure_name || ': Updated '' || trx_line_update_count || '' records in cn_trx_lines.''); ');
997: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, ''' || x_procedure_name || ': Updated '' || trx_line_update_count || '' records in cn_trx_lines.''); ');
998: cn_utils.appendcr(code);
999: cn_utils.indent(code, 1);
1000:
1001: ELSE -- Regular Receivables Collection

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

1072: END IF;
1073: cn_utils.unset_org_id();
1074:
1075: cn_debug.print_msg('collect_stmts<<', 1);
1076: fnd_file.put_line(fnd_file.Log, 'collect_stmts<<');
1077:
1078:
1079: END collect_stmts;
1080:

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

1095: x_org_id IN NUMBER) IS
1096: BEGIN
1097:
1098: cn_debug.print_msg('pkg_proc_end>>', 1);
1099: fnd_file.put_line(fnd_file.Log, 'pkg_proc_end>>');
1100: cn_utils.set_org_id(x_org_id);
1101: -- Generate code to record success or failure of batch
1102: -- Fix for bug 8371984
1103: --IF(x_event_id < 0)

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

1108: cn_utils.record_process_success('''Finished collection run for batch '' || x_batch_id', code);
1109: END IF;
1110:
1111: cn_utils.appindcr(code, 'cn_message_pkg.debug('''|| x_procedure_name || ': inside loop<<'');');
1112: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, '''|| x_procedure_name || ': inside loop<<'');');
1113: cn_utils.appindcr(code, 'cn_message_pkg.end_batch(x_proc_audit_id);');
1114: cn_utils.appindcr(code, 'COMMIT;');
1115: cn_utils.appendcr(code);
1116:

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

1150:
1151: cn_utils.appindcr(code, 'x_proc_audit_id := x_col_audit_id;'); --AE 08-01-95
1152:
1153: cn_utils.appindcr(code, 'cn_message_pkg.debug('''|| x_procedure_name ||'<<'');');
1154: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, '''|| x_procedure_name ||'<<'');');
1155:
1156: cn_utils.appindcr(code, 'cn_message_pkg.end_batch(x_proc_audit_id);');
1157: cn_utils.appendcr(code);
1158:

Line 1169: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, SQLCODE||'' ''||SQLERRM);');

1165: cn_utils.appindcr(code, 'exception when others then');
1166: cn_utils.appendcr(code, 'errbuf := SQLCODE||'' ''||SQLERRM;' );
1167: cn_utils.appendcr(code, 'retcode := 2;' );
1168: cn_utils.appindcr(code, 'cn_message_pkg.debug(SQLCODE||'' ''||SQLERRM);');
1169: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, SQLCODE||'' ''||SQLERRM);');
1170: cn_utils.appindcr(code, 'cn_notify_aia_om.notify_failed_trx(x_batch_id,x_start_period_id, x_end_period_id, debug_pipe, debug_level,x_org_id);' );
1171: cn_utils.appindcr(code, 'x_proc_audit_id := x_col_audit_id;');
1172: cn_utils.appindcr(code, 'cn_message_pkg.end_batch(x_proc_audit_id);');
1173: cn_utils.appendcr(code);

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

1180: cn_utils.appendcr(code);
1181: cn_utils.unset_org_id();
1182:
1183: cn_debug.print_msg('pkg_proc_end<<', 1);
1184: fnd_file.put_line(fnd_file.Log, 'pkg_proc_end<<');
1185:
1186: END pkg_proc_end;
1187:
1188:

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

1236: --dbms_output.put_line('--- NOT x_generic parameter_list');
1237: --dbms_output.put_line(parameter_list);
1238:
1239: cn_debug.print_msg('collection_proc>>', 1);
1240: fnd_file.put_line(fnd_file.Log, 'collection_proc>>');
1241:
1242: -- Generate procedure definition, boilerplate text, local variables etc.
1243: --dbms_output.put_line(' Before pkg_proc_init ');
1244:

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

1260:
1261: pkg_proc_end(x_table_map_id, procedure_name, event_id,body_code,X_org_id);
1262:
1263: cn_debug.print_msg('collection_proc<<', 1);
1264: fnd_file.put_line(fnd_file.Log, 'collection_proc<<');
1265:
1266: END collection_proc;
1267: --+
1268: -- Procedure Name

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

1295:
1296: l_org_id := x_org_id;
1297:
1298: cn_debug.print_msg('null_proc>>', 1);
1299: fnd_file.put_line(fnd_file.Log, 'null_proc>>');
1300:
1301: -- Generate procedure definition, boilerplate text, local variables etc.
1302:
1303: cn_utils.set_org_id(X_org_id);

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

1321: cn_utils.appindcr(body_code, 'NULL;');
1322: cn_utils.appendcr(body_code);
1323:
1324: cn_utils.appindcr(body_code, 'cn_message_pkg.debug('''|| procedure_name || ': Nothing is being collected.'');');
1325: cn_utils.appindcr(body_code, 'fnd_file.put_line(fnd_file.Log, '''|| procedure_name || ': Nothing is being collected.'');');
1326: cn_utils.appindcr(body_code, 'cn_message_pkg.debug('''|| procedure_name ||'<<'');');
1327: cn_utils.appindcr(body_code, 'fnd_file.put_line(fnd_file.Log, '''|| procedure_name ||'<<'');');
1328: cn_utils.appindcr(body_code, 'cn_message_pkg.end_batch(x_proc_audit_id);');
1329: cn_utils.appendcr(body_code);

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

1323:
1324: cn_utils.appindcr(body_code, 'cn_message_pkg.debug('''|| procedure_name || ': Nothing is being collected.'');');
1325: cn_utils.appindcr(body_code, 'fnd_file.put_line(fnd_file.Log, '''|| procedure_name || ': Nothing is being collected.'');');
1326: cn_utils.appindcr(body_code, 'cn_message_pkg.debug('''|| procedure_name ||'<<'');');
1327: cn_utils.appindcr(body_code, 'fnd_file.put_line(fnd_file.Log, '''|| procedure_name ||'<<'');');
1328: cn_utils.appindcr(body_code, 'cn_message_pkg.end_batch(x_proc_audit_id);');
1329: cn_utils.appendcr(body_code);
1330:
1331:

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

1337: cn_utils.appendcr(body_code);
1338: cn_utils.unset_org_id();
1339:
1340: cn_debug.print_msg('null_proc<<', 1);
1341: fnd_file.put_line(fnd_file.Log, 'null_proc<<');
1342:
1343: END null_proc;
1344:
1345:

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

1385: IF (debug_pipe IS NOT NULL) THEN
1386: cn_debug.init_pipe(debug_pipe, debug_level);
1387: END IF;
1388: cn_debug.print_msg('collection_pkg_code>>', 1);
1389: fnd_file.put_line(fnd_file.Log, 'collection_pkg_code>>');
1390:
1391: --+
1392: -- Define package in Commissions dictionary, initialize code etc.
1393: -- Note: pkg_init calls delete_module in cn_utils to delete current mod.

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

1417: l_spec_code, l_body_code);
1418:
1419: cn_utils.unset_org_id();
1420: cn_debug.print_msg('collection_pkg_code<<', 1);
1421: fnd_file.put_line(fnd_file.Log, 'collection_pkg_code<<');
1422:
1423: END collection_pkg_code;
1424:
1425: --------------------------------------------------------+

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

1498: IF (debug_pipe IS NOT NULL) THEN
1499: cn_debug.init_pipe(debug_pipe, debug_level);
1500: END IF;
1501: cn_debug.print_msg('collection_pkg>>', 1);
1502: fnd_file.put_line(fnd_file.Log, 'collection_pkg>>');
1503: --+
1504: -- Get info about this data source from cn_table_maps
1505: --+
1506: SELECT mapping_type, module_id

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

1595: --dbms_output.put_line(' Out OF collection_pkg_code ');
1596: END IF;
1597: --COMMIT;
1598: cn_debug.print_msg('collection_pkg<<', 1);
1599: fnd_file.put_line(fnd_file.Log, 'collection_pkg<<');
1600: END collection_pkg;
1601:
1602: PROCEDURE Collection_Install(
1603: x_errbuf OUT NOCOPY VARCHAR2,