DBA Data[Home] [Help]

APPS.CN_COLLECTION_GEN dependencies on CN_DEBUG

Line 266: cn_debug.print_msg('call_notify >>', 1);

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

Line 291: cn_debug.print_msg('call_notify: Generating CALL statement.', 1);

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

Line 326: cn_debug.print_msg('call_notify <<', 1);

322: END IF;
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.'');');

Line 351: cn_debug.print_msg('call_notify: in exception handler for NO_DATA_FOUND', 1);

347: cn_utils.unset_org_id();
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:

Line 388: cn_debug.print_msg('call_identify >>', 1);

384: cn_utils.appendcr(code, '--******** IDENTIFY PROCESS ********-- ');
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.'');');

Line 411: cn_debug.print_msg('call_identify: Generating CALL statement.', 1);

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

Line 419: cn_debug.print_msg('call_identify <<', 1);

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

Line 432: cn_debug.print_msg('call_identify: in exception handler for NO_DATA_FOUND', 1);

428: EXCEPTION
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;

Line 467: cn_debug.print_msg('call_negate >>', 1);

463: cn_utils.appendcr(code, '--******** NEGATE PROCESS ********-- ');
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 ||');');

Line 500: cn_debug.print_msg('call_negate <<', 1);

496: cn_utils.appindcr(code, 'END IF;');
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));

Line 510: cn_debug.print_msg('call_negate: in exception handler for NO_DATA_FOUND', 1);

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

Line 535: cn_debug.print_msg('local_variables>>', 1);

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

Line 581: cn_debug.print_msg('local_variables<<', 1);

577:
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:

Line 586: 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);
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);

Line 634: cn_debug.print_msg('local_variables<<', 1);

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

Line 656: cn_debug.print_msg('who>>', 1);

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

Line 664: cn_debug.print_msg('who<<', 1);

660: cn_utils.appindcr(code, '-- who.set_program_name(''' || procedure_name || ''');');
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:

Line 741: cn_debug.print_msg('pkg_proc_init>>', 1);

737: BEGIN
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,

Line 847: cn_debug.print_msg('pkg_proc_init<<', 1);

843: cn_utils.appindcr(body_code, 'SAVEPOINT start_transaction;');
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;

Line 877: cn_debug.print_msg('collect_stmts>>', 1);

873: BEGIN
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

Line 1044: cn_debug.print_msg('collect_stmts<<', 1);

1040: END IF;
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;

Line 1067: cn_debug.print_msg('pkg_proc_end>>', 1);

1063: code IN OUT NOCOPY cn_utils.code_type,
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)

Line 1136: cn_debug.print_msg('pkg_proc_end<<', 1);

1132: cn_utils.appindcr(code, 'END ' ||x_procedure_name || ';');
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:

Line 1189: cn_debug.print_msg('collection_proc>>', 1);

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

Line 1213: cn_debug.print_msg('collection_proc<<', 1);

1209: -- Generate procedure end boilerplate text
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: --+

Line 1248: cn_debug.print_msg('null_proc>>', 1);

1244: BEGIN
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:

Line 1290: cn_debug.print_msg('null_proc<<', 1);

1286: cn_utils.appindcr(body_code, 'END ' || procedure_name || ';');
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:

Line 1336: cn_debug.init_pipe(debug_pipe, debug_level);

1332: --dbms_output.put_line('--- l_event_id '||l_event_id);
1333:
1334:
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:

Line 1338: cn_debug.print_msg('collection_pkg_code>>', 1);

1334:
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.

Line 1370: cn_debug.print_msg('collection_pkg_code<<', 1);

1366: cn_utils.pkg_end(x_package_name, l_package_spec_id, l_package_body_id,
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:

Line 1442: cn_debug.init_pipe(debug_pipe, debug_level);

1438: --dbms_output.put_line('l_org_id:1'||l_org_id);
1439:
1440:
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: --+

Line 1444: cn_debug.print_msg('collection_pkg>>', 1);

1440:
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: --+

Line 1539: cn_debug.print_msg('collection_pkg<<', 1);

1535:
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(