DBA Data[Home] [Help]

APPS.CN_COLLECTION_GEN dependencies on CN_DEBUG

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1382: --dbms_output.put_line('--- l_event_id '||l_event_id);
1383:
1384:
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:

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

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

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

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

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

1495: --dbms_output.put_line('x_org_id:1'||x_org_id);
1496: --dbms_output.put_line('l_org_id:1'||l_org_id);
1497:
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: --+

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

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

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

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