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_UTILS dependencies on CN_DEBUG

Line 431: cn_debug.print_msg('record_process_start>>', 1);

427: audit_desc VARCHAR2,
428: parent_audit_id VARCHAR2,
429: code IN OUT NOCOPY cn_utils.code_type) IS
430: BEGIN
431: cn_debug.print_msg('record_process_start>>', 1);
432:
433: cn_utils.appindcr(code, 'x_proc_audit_id := NULL; -- Will get a value in the call below');
434: cn_utils.appindcr(code, 'cn_process_audits_pkg.insert_row(x_rowid, x_proc_audit_id, ' || parent_audit_id || ',');
435: cn_utils.appindcr(code, ' ''' || audit_type || ''',' || audit_desc || ', NULL, NULL, NULL, NULL, NULL, SYSDATE, NULL,'||g_org_id||');');

Line 439: cn_debug.print_msg('record_process_start<<', 1);

435: cn_utils.appindcr(code, ' ''' || audit_type || ''',' || audit_desc || ', NULL, NULL, NULL, NULL, NULL, SYSDATE, NULL,'||g_org_id||');');
436: --AE cn_utils.appindcr(code, 'COMMIT;');
437: cn_utils.appendcr(code);
438:
439: cn_debug.print_msg('record_process_start<<', 1);
440: END record_process_start;
441:
442:
443: --

Line 455: cn_debug.print_msg('record_process_status>>', 1);

451: PROCEDURE record_process_success (
452: message VARCHAR2,
453: code IN OUT NOCOPY cn_utils.code_type) IS
454: BEGIN
455: cn_debug.print_msg('record_process_status>>', 1);
456: -- Generate code to record success of the process
457: cn_utils.appindcr(code, 'cn_process_audits_pkg.update_row(x_proc_audit_id, NULL, SYSDATE, 0, ' || message || ');');
458: --AE cn_utils.appindcr(code, 'COMMIT;');
459: cn_utils.appendcr(code);

Line 460: cn_debug.print_msg('record_process_success<<', 1);

456: -- Generate code to record success of the process
457: cn_utils.appindcr(code, 'cn_process_audits_pkg.update_row(x_proc_audit_id, NULL, SYSDATE, 0, ' || message || ');');
458: --AE cn_utils.appindcr(code, 'COMMIT;');
459: cn_utils.appendcr(code);
460: cn_debug.print_msg('record_process_success<<', 1);
461: END record_process_success;
462:
463:
464: --

Line 478: cn_debug.print_msg('record_process_exception>>', 1);

474: savepoint_name VARCHAR2,
475: code IN OUT NOCOPY cn_utils.code_type) IS
476: BEGIN
477: -- Generate code to handle errors
478: cn_debug.print_msg('record_process_exception>>', 1);
479: cn_utils.unindent(code, 1);
480: cn_utils.appindcr(code, 'EXCEPTION');
481: cn_utils.indent(code, 1);
482: IF (savepoint_name IS NOT NULL) THEN

Line 512: cn_debug.print_msg('record_process_exception>>', 1);

508: savepoint_name VARCHAR2,
509: code IN OUT NOCOPY cn_utils.clob_code_type) IS
510: BEGIN
511: -- Generate code to handle errors
512: cn_debug.print_msg('record_process_exception>>', 1);
513: cn_utils.unindent(code, 1);
514: cn_utils.appindcr(code, 'EXCEPTION');
515: cn_utils.indent(code, 1);
516: IF (savepoint_name IS NOT NULL) THEN

Line 1030: cn_debug.print_msg('proc_init>>', 1);

1026:
1027: X_rowid ROWID;
1028:
1029: BEGIN
1030: cn_debug.print_msg('proc_init>>', 1);
1031:
1032: -- Generate boilerplate comments
1033: cn_utils.proc_init_boilerplate(spec_code, procedure_name, description);
1034: cn_utils.proc_init_boilerplate(body_code, procedure_name, description);

Line 1059: cn_debug.print_msg('proc_init<<', 1);

1055: cn_utils.appendcr(spec_code, ';');
1056: cn_utils.appendcr(spec_code);
1057: cn_utils.appendcr(body_code, ' IS');
1058:
1059: cn_debug.print_msg('proc_init<<', 1);
1060: END proc_init;
1061:
1062: --for clob
1063: PROCEDURE proc_init (

Line 1077: cn_debug.print_msg('proc_init>>', 1);

1073:
1074: X_rowid ROWID;
1075:
1076: BEGIN
1077: cn_debug.print_msg('proc_init>>', 1);
1078:
1079: -- Generate boilerplate comments
1080: cn_utils.proc_init_boilerplate(spec_code, procedure_name, description);
1081: cn_utils.proc_init_boilerplate(body_code, procedure_name, description);

Line 1106: cn_debug.print_msg('proc_init<<', 1);

1102: cn_utils.appendcr(spec_code, ';');
1103: cn_utils.appendcr(spec_code);
1104: cn_utils.appendcr(body_code, ' IS');
1105:
1106: cn_debug.print_msg('proc_init<<', 1);
1107: END proc_init;
1108:
1109: --end clob
1110:

Line 1118: cn_debug.print_msg('proc_begin>>', 1);

1114: generate_debug_pipe VARCHAR2,
1115: code IN OUT NOCOPY cn_utils.code_type) IS
1116:
1117: BEGIN
1118: cn_debug.print_msg('proc_begin>>', 1);
1119:
1120: -- Generate begin procedure statement
1121: cn_utils.appindcr(code, 'BEGIN');
1122: cn_utils.indent(code, 1);

Line 1127: cn_utils.appindcr(code, ' cn_debug.init_pipe(debug_pipe, debug_level);');

1123:
1124: IF (generate_debug_pipe = 'Y') THEN
1125: -- Generate code to initialize a debug pipe if a pipename has been specified
1126: cn_utils.appindcr(code, 'IF (debug_pipe IS NOT NULL) THEN');
1127: cn_utils.appindcr(code, ' cn_debug.init_pipe(debug_pipe, debug_level);');
1128: cn_utils.appindcr(code, 'END IF;');
1129: END IF;
1130:
1131: cn_utils.appendcr(code);

Line 1133: cn_debug.print_msg('proc_begin<<', 1);

1129: END IF;
1130:
1131: cn_utils.appendcr(code);
1132:
1133: cn_debug.print_msg('proc_begin<<', 1);
1134: END proc_begin;
1135:
1136: --for clob
1137: PROCEDURE proc_begin (

Line 1142: cn_debug.print_msg('proc_begin>>', 1);

1138: procedure_name cn_obj_procedures_v.name%TYPE,
1139: generate_debug_pipe VARCHAR2,
1140: code IN OUT NOCOPY cn_utils.clob_code_type) IS
1141: BEGIN
1142: cn_debug.print_msg('proc_begin>>', 1);
1143:
1144: -- Generate begin procedure statement
1145: cn_utils.appindcr(code, 'BEGIN');
1146: cn_utils.indent(code, 1);

Line 1151: cn_utils.appindcr(code, ' cn_debug.init_pipe(debug_pipe, debug_level);');

1147:
1148: IF (generate_debug_pipe = 'Y') THEN
1149: -- Generate code to initialize a debug pipe if a pipename has been specified
1150: cn_utils.appindcr(code, 'IF (debug_pipe IS NOT NULL) THEN');
1151: cn_utils.appindcr(code, ' cn_debug.init_pipe(debug_pipe, debug_level);');
1152: cn_utils.appindcr(code, 'END IF;');
1153: END IF;
1154:
1155: cn_utils.appendcr(code);

Line 1157: cn_debug.print_msg('proc_begin<<', 1);

1153: END IF;
1154:
1155: cn_utils.appendcr(code);
1156:
1157: cn_debug.print_msg('proc_begin<<', 1);
1158: END proc_begin;
1159: --end clob
1160:
1161:

Line 1168: cn_debug.print_msg('proc_end>>', 1);

1164: exception_flag VARCHAR2,
1165: code IN OUT NOCOPY cn_utils.code_type) IS
1166:
1167: BEGIN
1168: cn_debug.print_msg('proc_end>>', 1);
1169:
1170: cn_utils.appendcr(code);
1171: cn_utils.appendcr(code);
1172: IF (exception_flag = 'Y') THEN

Line 1182: cn_debug.print_msg('proc_end<<', 1);

1178: cn_utils.unindent(code, 1);
1179: cn_utils.appindcr(code, 'END ' || procedure_name || ';');
1180: cn_utils.appendcr(code);
1181:
1182: cn_debug.print_msg('proc_end<<', 1);
1183: END proc_end;
1184:
1185: --for clob
1186: PROCEDURE proc_end (

Line 1192: cn_debug.print_msg('proc_end>>', 1);

1188: exception_flag VARCHAR2,
1189: code IN OUT NOCOPY cn_utils.clob_code_type) IS
1190:
1191: BEGIN
1192: cn_debug.print_msg('proc_end>>', 1);
1193:
1194: cn_utils.appendcr(code);
1195: cn_utils.appendcr(code);
1196: IF (exception_flag = 'Y') THEN

Line 1206: cn_debug.print_msg('proc_end<<', 1);

1202: cn_utils.unindent(code, 1);
1203: cn_utils.appindcr(code, 'END ' || procedure_name || ';');
1204: cn_utils.appendcr(code);
1205:
1206: cn_debug.print_msg('proc_end<<', 1);
1207: END proc_end;
1208:
1209: --end clob
1210:

Line 1236: cn_debug.print_msg('gen_create_table>>', 1);

1232:
1233: table_name cn_obj_tables_v.name%TYPE;
1234:
1235: BEGIN
1236: cn_debug.print_msg('gen_create_table>>', 1);
1237:
1238: table_name := cn_utils.get_object_name(X_table_id);
1239:
1240: cn_utils.init_code( X_table_id, code);

Line 1267: cn_debug.print_msg('gen_create_table<<', 1);

1263: END IF;
1264: cn_utils.appendcr(code, ')');
1265:
1266: -- Note: How does one get storage parameters for the table?
1267: cn_debug.print_msg('gen_create_table<<', 1);
1268: END gen_create_table;
1269:
1270:
1271: --+

Line 1293: cn_debug.print_msg('gen_create_index>>', 1);

1289: X_table_name cn_obj_tables_v.name%TYPE;
1290: X_unique_flag cn_obj_indexes_v.unique_flag%TYPE;
1291:
1292: BEGIN
1293: cn_debug.print_msg('gen_create_index>>', 1);
1294:
1295: SELECT coiv.name, cotv.name, unique_flag
1296: INTO X_name, X_table_name, X_unique_flag
1297: FROM cn_obj_indexes_v coiv, cn_obj_tables_v cotv

Line 1315: cn_debug.print_msg('gen_create_index<<', 1);

1311: cn_utils.appindcr(code, ')');
1312: -- Shouldn't the next statement be customizable? -- Devesh
1313: cn_utils.appindcr(code, 'PCTFREE 10');
1314:
1315: cn_debug.print_msg('gen_create_index<<', 1);
1316: END gen_create_index;
1317:
1318:
1319: --+

Line 1334: cn_debug.print_msg('gen_create_sequence>>', 1);

1330: X_name cn_obj_sequences_v.name%TYPE;
1331: X_start_value cn_obj_sequences_v.start_value%TYPE;
1332: X_increment_value cn_obj_sequences_v.increment_value%TYPE;
1333: BEGIN
1334: cn_debug.print_msg('gen_create_sequence>>', 1);
1335:
1336: SELECT name, start_value, increment_value
1337: INTO X_name, X_start_value, X_increment_value
1338: FROM cn_obj_sequences_v cosv

Line 1359: cn_debug.print_msg('gen_create_sequence<<', 1);

1355: cn_utils.appindcr(code, 'CACHE 20');
1356: cn_utils.appindcr(code, 'NOORDER');
1357: cn_utils.unindent(code, 1);
1358:
1359: cn_debug.print_msg('gen_create_sequence<<', 1);
1360: END gen_create_sequence;
1361:
1362:
1363: --+

Line 1379: cn_debug.print_msg('gen_create_dblink>>', 1);

1375: X_connect_to_username cn_obj_dblinks_v.connect_to_username%TYPE;
1376: X_connect_to_password cn_obj_dblinks_v.connect_to_password%TYPE;
1377: X_connect_to_host cn_obj_dblinks_v.connect_to_host%TYPE;
1378: BEGIN
1379: cn_debug.print_msg('gen_create_dblink>>', 1);
1380:
1381: SELECT name, connect_to_username, connect_to_password, connect_to_host
1382: INTO X_name, X_connect_to_username, X_connect_to_password, X_connect_to_host
1383: FROM cn_obj_dblinks_v codv

Line 1394: cn_debug.print_msg('gen_create_dblink<<', 1);

1390: cn_utils.appendcr(code, ' IDENTIFIED BY ' || LOWER(X_connect_to_password));
1391: cn_utils.appindcr(code, 'USING ''' || LOWER(X_connect_to_host) || '''');
1392: cn_utils.unindent(code, 1);
1393:
1394: cn_debug.print_msg('gen_create_dblink<<', 1);
1395: END gen_create_dblink;
1396:
1397:
1398: --+

Line 1412: cn_debug.print_msg('gen_create_subprogram>>', 1);

1408: code IN OUT NOCOPY cn_utils.code_type) IS
1409:
1410: X_statement_text cn_obj_packages_v.statement_text%TYPE;
1411: BEGIN
1412: cn_debug.print_msg('gen_create_subprogram>>', 1);
1413:
1414: SELECT statement_text
1415: INTO X_statement_text
1416: FROM cn_objects co

Line 1422: cn_debug.print_msg('gen_create_subprogram<<', 1);

1418:
1419: cn_utils.init_code( X_object_id, code);
1420: cn_utils.appendcr(code, 'CREATE OR REPLACE ' || X_statement_text);
1421:
1422: cn_debug.print_msg('gen_create_subprogram<<', 1);
1423: END gen_create_subprogram;
1424:
1425:
1426: --+

Line 1446: cn_debug.print_msg('gen_create_package>>', 1);

1442: X_name cn_obj_packages_v.name%TYPE;
1443: X_description cn_obj_packages_v.description%TYPE;
1444:
1445: BEGIN
1446: cn_debug.print_msg('gen_create_package>>', 1);
1447:
1448: SELECT statement_text, object_type, name, description
1449: INTO X_statement_text, X_object_type, X_name, X_description
1450: FROM cn_objects co

Line 1471: cn_debug.print_msg('gen_create_package<<', 1);

1467: cn_utils.appendcr(code, X_statement_text);
1468: cn_utils.pkg_end_boilerplate(code, X_object_type);
1469: END IF;
1470:
1471: cn_debug.print_msg('gen_create_package<<', 1);
1472: END gen_create_package;
1473:
1474:
1475: --+

Line 1497: cn_debug.print_msg('gen_create_trigger>>', 1);

1493: WHERE cocv.column_id = cctm.column_id
1494: AND cctm.trigger_id = X_trigger_id;
1495:
1496: BEGIN
1497: cn_debug.print_msg('gen_create_trigger>>', 1);
1498: cn_utils.init_code( X_trigger_id, code);
1499:
1500: row.trigger_id := X_trigger_id;
1501: cn_obj_triggers_v_pkg.select_row(row);

Line 1532: cn_debug.print_msg('gen_create_trigger<<', 1);

1528: cn_utils.appendcr(code, 'WHEN ' || row.when_clause);
1529: END IF;
1530:
1531: cn_utils.appendcr(code, row.statement_text);
1532: cn_debug.print_msg('gen_create_trigger<<', 1);
1533: END gen_create_trigger;
1534:
1535:
1536: PROCEDURE gen_instantiation_code (

Line 1545: cn_debug.print_msg('gen_instantiation_code>>', 1);

1541: code cn_utils.code_type;
1542: X_object_type cn_objects.object_type%TYPE;
1543:
1544: BEGIN
1545: cn_debug.print_msg('gen_instantiation_code>>', 1);
1546: cn_debug.print_msg('gen_instantiation_code: X_object_id = ' || X_object_id, 1);
1547:
1548: SELECT object_type INTO X_object_type
1549: FROM cn_objects co

Line 1546: cn_debug.print_msg('gen_instantiation_code: X_object_id = ' || X_object_id, 1);

1542: X_object_type cn_objects.object_type%TYPE;
1543:
1544: BEGIN
1545: cn_debug.print_msg('gen_instantiation_code>>', 1);
1546: cn_debug.print_msg('gen_instantiation_code: X_object_id = ' || X_object_id, 1);
1547:
1548: SELECT object_type INTO X_object_type
1549: FROM cn_objects co
1550: WHERE co.object_id = X_object_id;

Line 1571: cn_debug.print_msg('gen_instantiation_code<<', 1);

1567: gen_create_index(X_object_id, code);
1568: END IF;
1569: code_text := code.text;
1570:
1571: cn_debug.print_msg('gen_instantiation_code<<', 1);
1572: END gen_instantiation_code;
1573: */
1574: -- AE 05-02-95. gen_create_xxxxxx procedures commented out. not used.
1575:

Line 1671: cn_debug.print_msg('compute_hierarchy_levels>>', 1);

1667:
1668: PROCEDURE compute_hierarchy_levels (
1669: X_dim_hierarchy_id cn_dim_hierarchies.dim_hierarchy_id%TYPE) IS
1670: BEGIN
1671: cn_debug.print_msg('compute_hierarchy_levels>>', 1);
1672:
1673: -- DELETE FROM cn_tmp_hierarchy_levels;
1674: -- INSERT INTO cn_tmp_hierarchy_levels
1675: -- SELECT value_id, MAX(LEVEL) FROM cn_hierarchy_edges

Line 1687: -- cn_debug.print_msg('compute_hierarchy_levels<<', 1);

1683: -- WHERE chn.value_id = cthl.value_id)
1684: -- WHERE chn.dim_hierarchy_id = X_dim_hierarchy_id;
1685: -- DELETE FROM cn_tmp_hierarchy_levels;
1686:
1687: -- cn_debug.print_msg('compute_hierarchy_levels<<', 1);
1688: END compute_hierarchy_levels;
1689:
1690: --+
1691: -- Procedure Name