APPS.CN_HIERARCHY_EDGES_T2 dependencies on CN_DEBUG

Line 32: cn_debug.print_msg('child not exist',1);

28:
29:
30: IF ( child_exist = 'N' ) THEN
31:
32: cn_debug.print_msg('child not exist',1);
33: INSERT INTO cn_dim_explosion
34: (dim_hierarchy_id,
35: value_id,
36: ancestor_id,

Line 64: cn_debug.print_msg('child not exist',1);

60: :new.parent_value_id);
61:
62: IF ( child_exist = 'N' ) THEN
63:
64: cn_debug.print_msg('child not exist',1);
65: INSERT INTO cn_dim_explosion
66: (dim_hierarchy_id,
67: value_id,
68: ancestor_id,

Line 95: cn_debug.print_msg('inserting edges',1);

91: IF ( :new.parent_value_id IS NOT NULL ) THEN
92:
93: -- for a new edge connecting two not null nodes, insert all
94: -- the ancestors for the new value
95: cn_debug.print_msg('inserting edges',1);
96: cn_debug.print_msg('dim_hierarchy_id = '||:new.dim_hierarchy_id,1);
97: INSERT INTO cn_dim_explosion
98: (dim_hierarchy_id,
99: value_id,

Line 96: cn_debug.print_msg('dim_hierarchy_id = '||:new.dim_hierarchy_id,1);

92:
93: -- for a new edge connecting two not null nodes, insert all
94: -- the ancestors for the new value
95: cn_debug.print_msg('inserting edges',1);
96: cn_debug.print_msg('dim_hierarchy_id = '||:new.dim_hierarchy_id,1);
97: INSERT INTO cn_dim_explosion
98: (dim_hierarchy_id,
99: value_id,
100: ancestor_id,

Line 140: cn_debug.print_msg(sqlerrm,1);

136: END LOOP;
137:
138: EXCEPTION
139: WHEN OTHERS THEN
140: cn_debug.print_msg(sqlerrm,1);
141: RAISE;
142:
143: END cn_hierarchy_edges_t2;