APPS.MSC_DEMANTRA_PKG dependencies on MSC_TRANSLATED_MESSAGE

Line 160: delete from msc_translated_message where lang_id='00' and msg_num like g_msg_num_prefix1||'%';

156: delete from msc_apcc_custom_hier;
157: msc_phub_util.log('msc_demantra_pkg.build_custom_hierarchy: delete from msc_apcc_custom_hier: '||sql%rowcount);
158: commit;
159:
160: delete from msc_translated_message where lang_id='00' and msg_num like g_msg_num_prefix1||'%';
161: msc_phub_util.log('msc_demantra_pkg.build_custom_hierarchy: delete from msc_translated_message: '||sql%rowcount);
162: commit;
163:
164: l_sql :=

Line 161: msc_phub_util.log('msc_demantra_pkg.build_custom_hierarchy: delete from msc_translated_message: '||sql%rowcount);

157: msc_phub_util.log('msc_demantra_pkg.build_custom_hierarchy: delete from msc_apcc_custom_hier: '||sql%rowcount);
158: commit;
159:
160: delete from msc_translated_message where lang_id='00' and msg_num like g_msg_num_prefix1||'%';
161: msc_phub_util.log('msc_demantra_pkg.build_custom_hierarchy: delete from msc_translated_message: '||sql%rowcount);
162: commit;
163:
164: l_sql :=
165: ' select rownum level_id, gtable, cust_code_field, gtable2, id_field2, table_label'||LF||

Line 204: ' insert into msc_translated_message(lang_id, msg_num, msg_text)'||LF||

200: msc_phub_util.log('msc_demantra_pkg.build_custom_hierarchy: insert into msc_apcc_custom_hier: '||sql%rowcount);
201: commit;
202:
203: l_sql2 :=
204: ' insert into msc_translated_message(lang_id, msg_num, msg_text)'||LF||
205: ' select ''00'', '''||g_msg_num_prefix1||'''||substr(to_char(level_id,''09''),2), table_label'||LF||
206: ' from ('||l_sql||')';
207:
208: msc_phub_util.log_sql(l_sql2);

Line 210: msc_phub_util.log('msc_demantra_pkg.build_custom_hierarchy: insert into msc_translated_message: '||sql%rowcount);

206: ' from ('||l_sql||')';
207:
208: msc_phub_util.log_sql(l_sql2);
209: execute immediate l_sql2;
210: msc_phub_util.log('msc_demantra_pkg.build_custom_hierarchy: insert into msc_translated_message: '||sql%rowcount);
211: commit;
212: end if;
213:
214: exception

Line 558: delete from msc_translated_message where lang_id='00' and msg_num like g_msg_num_prefix2||'%';

554: end;
555: end loop;
556: close c;
557:
558: delete from msc_translated_message where lang_id='00' and msg_num like g_msg_num_prefix2||'%';
559: msc_phub_util.log('msc_demantra_pkg.register_custom_measures: delete from msc_translated_message: '||sql%rowcount);
560: commit;
561:
562: insert into msc_translated_message(lang_id, msg_num, msg_text)

Line 559: msc_phub_util.log('msc_demantra_pkg.register_custom_measures: delete from msc_translated_message: '||sql%rowcount);

555: end loop;
556: close c;
557:
558: delete from msc_translated_message where lang_id='00' and msg_num like g_msg_num_prefix2||'%';
559: msc_phub_util.log('msc_demantra_pkg.register_custom_measures: delete from msc_translated_message: '||sql%rowcount);
560: commit;
561:
562: insert into msc_translated_message(lang_id, msg_num, msg_text)
563: select

Line 562: insert into msc_translated_message(lang_id, msg_num, msg_text)

558: delete from msc_translated_message where lang_id='00' and msg_num like g_msg_num_prefix2||'%';
559: msc_phub_util.log('msc_demantra_pkg.register_custom_measures: delete from msc_translated_message: '||sql%rowcount);
560: commit;
561:
562: insert into msc_translated_message(lang_id, msg_num, msg_text)
563: select
564: '00' lang_id,
565: g_msg_num_prefix2||upper(m.entity_name)||'_'||substr(to_char(substr(f.column_name,10),'09'),2) msg_num,
566: f.column_title msg_text

Line 571: msc_phub_util.log('msc_demantra_pkg.register_custom_measures: insert into msc_translated_message: '||sql%rowcount);

567: from msc_apcc_custom_measures f, table(msc_phub_pkg.meta_info) m
568: where f.fact_type=m.fact_type
569: and f.source_column_name is not null
570: order by to_number(substr(f.column_name,10));
571: msc_phub_util.log('msc_demantra_pkg.register_custom_measures: insert into msc_translated_message: '||sql%rowcount);
572: commit;
573:
574: exception
575: when others then