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 CN_MESSAGE_PKG

Line 211: cn_utils.appindcr(code, 'cn_message_pkg.begin_batch(');

207: cn_utils.appindcr(code, 'EXECUTE IMMEDIATE ''ALTER SESSION ENABLE PARALLEL DML'';');
208: END IF;
209: END IF;
210:
211: cn_utils.appindcr(code, 'cn_message_pkg.begin_batch(');
212: cn_utils.indent(code, 5);
213:
214: cn_utils.appindcr(code, ' x_parent_proc_audit_id => dummy_num');
215: cn_utils.appindcr(code, ',x_process_audit_id => x_proc_audit_id');

Line 230: cn_utils.appindcr(code, 'cn_message_pkg.debug('''|| procedure_name || '>>'');');

226: THEN
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:

Line 273: cn_utils.appindcr(code, 'cn_message_pkg.debug('''|| procedure_name || ': Call notify process begin.'');');

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:
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 ');

Line 295: cn_utils.appindcr(code, 'cn_message_pkg.debug('''|| procedure_name || ': entering notify.'');');

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.'');');
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);' );

Line 330: cn_utils.appindcr(code, 'cn_message_pkg.debug('''|| procedure_name || ': exit from notify and start collection run.'');');

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.'');');
332:
333: IF (x_event_id = cn_global.ord_event_id) THEN
334: cn_utils.appendcr(code, '--******** COLLECT AJUSTMENTS (NEGATE IN API) ********-- ');

Line 392: cn_utils.appindcr(code, 'cn_message_pkg.debug('''|| procedure_name || ': start identify process.'');');

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.'');');
394: cn_utils.appendcr(code);
395: cn_utils.appindcr(code, 'SELECT period_id ');
396: cn_utils.appindcr(code, ' INTO x_start_period_id ');

Line 423: cn_utils.appindcr(code, 'cn_message_pkg.debug('''|| procedure_name || ': end identify process.'');');

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.'');');
425: cn_utils.appendcr(code);
426:
427: cn_utils.unset_org_id();

Line 473: cn_utils.appindcr(code, 'cn_message_pkg.debug('''|| procedure_name ||

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);
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);

Line 479: cn_utils.appindcr(code, ' cn_message_pkg.debug('''|| procedure_name || ': start negate process.'');');

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.'');');
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.'');');

Line 482: cn_utils.appindcr(code, ' cn_message_pkg.debug('''|| procedure_name || ': end negate process.'');');

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');
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.'');');

Line 485: cn_utils.appindcr(code, ' cn_message_pkg.debug('''|| procedure_name || ': skip 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);
488: cn_utils.appindcr(code, ' UPDATE cn_trx_lines ctl');
489: cn_utils.appindcr(code, ' SET negated_flag = ''Y''');

Line 503: cn_message_pkg.DEBUG('collect: Profile OSC: Negate during Revenue Adjustments Collection = ' ||

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 = ' ||
506: CN_SYSTEM_PARAMETERS.value('CN_RAM_NEGATE',x_org_id));
507:

Line 691: cn_utils.appindcr(code, 'cn_message_pkg.debug(''' || x_procedure_name || ': Rollback.'');');

687: cn_utils.appindcr(code, 'EXCEPTION');
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;

Line 697: cn_utils.appindcr(code, 'cn_message_pkg.debug(''' || x_procedure_name || ': In exception handler ' || location ||'.'');');

693: ELSE
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,');

Line 704: cn_utils.appindcr(code, 'cn_message_pkg.debug(sqlcode ||'''||' '||'''||sqlerrm);');

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);');
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:

Line 706: cn_utils.appindcr(code, 'cn_message_pkg.end_batch(x_proc_audit_id);');

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;');
710: cn_utils.appendcr(code);

Line 810: cn_utils.appindcr(body_code, 'cn_message_pkg.debug('''|| x_procedure_name || ': start collection process.'');');

806:
807: cn_utils.set_org_id(X_org_id);
808: cn_utils.appendcr(body_code, '--******** COLLECT PROCESS ********-- ');
809: cn_utils.appendcr(body_code);
810: cn_utils.appindcr(body_code, 'cn_message_pkg.debug('''|| x_procedure_name || ': start collection process.'');');
811:
812: /* -- Generate code to record start of the collection
813: cn_utils.record_process_start('COL', '''Collection run''', 'NULL', body_code);
814:

Line 823: cn_utils.appindcr(body_code, 'cn_message_pkg.debug('''|| x_procedure_name || ': entering cursor Batches loop.'');');

819:
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');

Line 937: cn_utils.appindcr(code, 'cn_message_pkg.debug(''' || x_procedure_name || ': update CN_TRX and CN_TRX_LINES.''); ');

933:
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 ');

Line 952: cn_utils.appindcr(code, 'cn_message_pkg.debug(''' || x_procedure_name || ': Updated '' || trx_update_count || '' records in cn_trx.''); ');

948: cn_utils.appindcr(code, ' AND org_id = '||x_org_id||')');
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 ');

Line 965: cn_utils.appindcr(code, 'cn_message_pkg.debug(''' || x_procedure_name || ': Updated '' || trx_line_update_count || '' records in cn_trx_lines.''); ');

961: cn_utils.appindcr(code, ' AND adj_batch_id = x_adj_batch_id ');
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:

Line 1079: cn_utils.appindcr(code, 'cn_message_pkg.debug('''|| x_procedure_name || ': inside loop<<'');');

1075: ELSE
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);

Line 1081: cn_utils.appindcr(code, 'cn_message_pkg.end_batch(x_proc_audit_id);');

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:
1085: -- cn_utils.record_process_exception(x_procedure_name, 'start_transaction', code);

Line 1119: cn_utils.appindcr(code, 'cn_message_pkg.debug('''|| x_procedure_name ||'<<'');');

1115: cn_utils.appendcr(code);
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);

Line 1122: cn_utils.appindcr(code, 'cn_message_pkg.end_batch(x_proc_audit_id);');

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:
1125: -- cn_utils.proc_end(x_procedure_name, 'Y', code);
1126:

Line 1274: cn_utils.appindcr(body_code, 'cn_message_pkg.debug('''|| procedure_name || ': Nothing is being collected.'');');

1270: cn_utils.set_org_id(X_org_id);
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);');

Line 1276: cn_utils.appindcr(body_code, 'cn_message_pkg.debug('''|| procedure_name ||'<<'');');

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);
1280:

Line 1278: cn_utils.appindcr(body_code, 'cn_message_pkg.end_batch(x_proc_audit_id);');

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:
1282: -- Generate procedure end.