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.BSC_IM_INT_MD dependencies on BSC_IM_UTILS

Line 44: BSC_IM_UTILS.g_status_message:=sqlerrm;

40: im_md_dimensions(l_index).description:=p_description;
41: im_md_dimensions(l_index).property:=p_property;
42: return true;
43: Exception when others then
44: BSC_IM_UTILS.g_status_message:=sqlerrm;
45: g_status_message:=sqlerrm;
46: write_to_log_file_n('Error in create_dimension '||sqlerrm);
47: return false;
48: End;

Line 94: BSC_IM_UTILS.g_status_message:=sqlerrm;

90: im_md_levels(l_index).description:=p_description;
91: im_md_levels(l_index).property:=p_property;
92: return true;
93: Exception when others then
94: BSC_IM_UTILS.g_status_message:=sqlerrm;
95: g_status_message:=sqlerrm;
96: write_to_log_file_n('Error in create_level '||sqlerrm);
97: return false;
98: End;

Line 150: BSC_IM_UTILS.g_status_message:=sqlerrm;

146: im_md_columns(l_index).parent_name:=p_parent_name;
147: im_md_columns(l_index).property:=p_property;
148: return true;
149: Exception when others then
150: BSC_IM_UTILS.g_status_message:=sqlerrm;
151: g_status_message:=sqlerrm;
152: write_to_log_file_n('Error in create_column '||sqlerrm);
153: return false;
154: End;

Line 205: BSC_IM_UTILS.g_status_message:=sqlerrm;

201: im_md_level_relations(l_index).apps_origin:=p_apps_origin;
202: im_md_level_relations(l_index).property:=p_property;
203: return true;
204: Exception when others then
205: BSC_IM_UTILS.g_status_message:=sqlerrm;
206: g_status_message:=sqlerrm;
207: write_to_log_file_n('Error in create_level_relation '||sqlerrm);
208: return false;
209: End;

Line 253: BSC_IM_UTILS.g_status_message:=sqlerrm;

249: im_md_hierarchies(l_index).description:=p_description;
250: im_md_hierarchies(l_index).property:=p_property;
251: return true;
252: Exception when others then
253: BSC_IM_UTILS.g_status_message:=sqlerrm;
254: g_status_message:=sqlerrm;
255: write_to_log_file_n('Error in create_hierarchy '||sqlerrm);
256: return false;
257: End;

Line 300: BSC_IM_UTILS.g_status_message:=sqlerrm;

296: im_md_mapping(l_index).object_name:=p_object_name;
297: im_md_mapping(l_index).property:=p_property;
298: return true;
299: Exception when others then
300: BSC_IM_UTILS.g_status_message:=sqlerrm;
301: g_status_message:=sqlerrm;
302: write_to_log_file_n('Error in create_mapping '||sqlerrm);
303: return false;
304: End;

Line 349: BSC_IM_UTILS.g_status_message:=sqlerrm;

345: im_md_mapping_details(l_index).line_type:=p_line_type;
346: im_md_mapping_details(l_index).property:=p_property;
347: return true;
348: Exception when others then
349: BSC_IM_UTILS.g_status_message:=sqlerrm;
350: g_status_message:=sqlerrm;
351: write_to_log_file_n('Error in create_mapping_detail '||sqlerrm);
352: return false;
353: End;

Line 398: BSC_IM_UTILS.g_status_message:=sqlerrm;

394: im_md_cube(l_index).description:=p_description;
395: im_md_cube(l_index).property:=p_property;
396: return true;
397: Exception when others then
398: BSC_IM_UTILS.g_status_message:=sqlerrm;
399: g_status_message:=sqlerrm;
400: write_to_log_file_n('Error in create_cube '||sqlerrm);
401: return false;
402: End;

Line 452: BSC_IM_UTILS.g_status_message:=sqlerrm;

448: im_md_fk(l_index).apps_origin:=p_apps_origin;
449: im_md_fk(l_index).property:=p_property;
450: return true;
451: Exception when others then
452: BSC_IM_UTILS.g_status_message:=sqlerrm;
453: g_status_message:=sqlerrm;
454: write_to_log_file_n('Error in create_fk '||sqlerrm);
455: return false;
456: End;

Line 502: BSC_IM_UTILS.g_status_message:=sqlerrm;

498: im_md_uk(l_index).apps_origin:=p_apps_origin;
499: im_md_uk(l_index).property:=p_property;
500: return true;
501: Exception when others then
502: BSC_IM_UTILS.g_status_message:=sqlerrm;
503: g_status_message:=sqlerrm;
504: write_to_log_file_n('Error in create_uk '||sqlerrm);
505: return false;
506: End;

Line 553: BSC_IM_UTILS.g_status_message:=sqlerrm;

549: im_md_object(l_index).description:=p_description;
550: im_md_object(l_index).property:=p_property;
551: return true;
552: Exception when others then
553: BSC_IM_UTILS.g_status_message:=sqlerrm;
554: g_status_message:=sqlerrm;
555: write_to_log_file_n('Error in create_object '||sqlerrm);
556: return false;
557: End;

Line 609: BSC_IM_UTILS.g_status_message:=sqlerrm;

605: im_md_object.delete;
606: end if;
607: number_im_md_object:=null;
608: Exception when others then
609: BSC_IM_UTILS.g_status_message:=sqlerrm;
610: write_to_log_file_n('Error in reset_int_metadata '||sqlerrm);
611: raise;
612: End;
613: --==============================================================================

Line 635: BSC_IM_UTILS.g_status_message:=sqlerrm;

631: end if;
632: end loop;
633: return true;
634: Exception when others then
635: BSC_IM_UTILS.g_status_message:=sqlerrm;
636: g_status_message:=sqlerrm;
637: write_to_log_file_n('Error in get_dimension '||sqlerrm);
638: return false;
639: End;

Line 644: p_level_name out nocopy BSC_IM_UTILS.varchar_tabletype,

640:
641: function get_level(
642: p_dim_name varchar2,
643: p_apps_origin varchar2,
644: p_level_name out nocopy BSC_IM_UTILS.varchar_tabletype,
645: p_number_children out nocopy BSC_IM_UTILS.number_tabletype,
646: p_description out nocopy BSC_IM_UTILS.varchar_tabletype,
647: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
648: p_number_levels out nocopy number

Line 645: p_number_children out nocopy BSC_IM_UTILS.number_tabletype,

641: function get_level(
642: p_dim_name varchar2,
643: p_apps_origin varchar2,
644: p_level_name out nocopy BSC_IM_UTILS.varchar_tabletype,
645: p_number_children out nocopy BSC_IM_UTILS.number_tabletype,
646: p_description out nocopy BSC_IM_UTILS.varchar_tabletype,
647: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
648: p_number_levels out nocopy number
649: )return boolean is

Line 646: p_description out nocopy BSC_IM_UTILS.varchar_tabletype,

642: p_dim_name varchar2,
643: p_apps_origin varchar2,
644: p_level_name out nocopy BSC_IM_UTILS.varchar_tabletype,
645: p_number_children out nocopy BSC_IM_UTILS.number_tabletype,
646: p_description out nocopy BSC_IM_UTILS.varchar_tabletype,
647: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
648: p_number_levels out nocopy number
649: )return boolean is
650: Begin

Line 647: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,

643: p_apps_origin varchar2,
644: p_level_name out nocopy BSC_IM_UTILS.varchar_tabletype,
645: p_number_children out nocopy BSC_IM_UTILS.number_tabletype,
646: p_description out nocopy BSC_IM_UTILS.varchar_tabletype,
647: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
648: p_number_levels out nocopy number
649: )return boolean is
650: Begin
651: p_number_levels:=0;

Line 666: BSC_IM_UTILS.g_status_message:=sqlerrm;

662: end if;
663: end loop;
664: return true;
665: Exception when others then
666: BSC_IM_UTILS.g_status_message:=sqlerrm;
667: g_status_message:=sqlerrm;
668: write_to_log_file_n('Error in get_level '||sqlerrm);
669: return false;
670: End;

Line 688: BSC_IM_UTILS.g_status_message:=sqlerrm;

684: end if;
685: end loop;
686: return true;
687: Exception when others then
688: BSC_IM_UTILS.g_status_message:=sqlerrm;
689: g_status_message:=sqlerrm;
690: write_to_log_file_n('Error in get_dim_for_level '||sqlerrm);
691: return false;
692: End;

Line 697: p_column_name out nocopy BSC_IM_UTILS.varchar_tabletype,

693:
694: function get_column(
695: p_parent_name varchar2,
696: p_apps_origin varchar2,
697: p_column_name out nocopy BSC_IM_UTILS.varchar_tabletype,
698: p_column_type out nocopy BSC_IM_UTILS.varchar_tabletype,
699: p_column_data_type out nocopy BSC_IM_UTILS.varchar_tabletype,
700: p_column_origin out nocopy BSC_IM_UTILS.varchar_tabletype,
701: p_aggregation_type out nocopy BSC_IM_UTILS.varchar_tabletype,

Line 698: p_column_type out nocopy BSC_IM_UTILS.varchar_tabletype,

694: function get_column(
695: p_parent_name varchar2,
696: p_apps_origin varchar2,
697: p_column_name out nocopy BSC_IM_UTILS.varchar_tabletype,
698: p_column_type out nocopy BSC_IM_UTILS.varchar_tabletype,
699: p_column_data_type out nocopy BSC_IM_UTILS.varchar_tabletype,
700: p_column_origin out nocopy BSC_IM_UTILS.varchar_tabletype,
701: p_aggregation_type out nocopy BSC_IM_UTILS.varchar_tabletype,
702: p_description out nocopy BSC_IM_UTILS.varchar_tabletype,

Line 699: p_column_data_type out nocopy BSC_IM_UTILS.varchar_tabletype,

695: p_parent_name varchar2,
696: p_apps_origin varchar2,
697: p_column_name out nocopy BSC_IM_UTILS.varchar_tabletype,
698: p_column_type out nocopy BSC_IM_UTILS.varchar_tabletype,
699: p_column_data_type out nocopy BSC_IM_UTILS.varchar_tabletype,
700: p_column_origin out nocopy BSC_IM_UTILS.varchar_tabletype,
701: p_aggregation_type out nocopy BSC_IM_UTILS.varchar_tabletype,
702: p_description out nocopy BSC_IM_UTILS.varchar_tabletype,
703: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,

Line 700: p_column_origin out nocopy BSC_IM_UTILS.varchar_tabletype,

696: p_apps_origin varchar2,
697: p_column_name out nocopy BSC_IM_UTILS.varchar_tabletype,
698: p_column_type out nocopy BSC_IM_UTILS.varchar_tabletype,
699: p_column_data_type out nocopy BSC_IM_UTILS.varchar_tabletype,
700: p_column_origin out nocopy BSC_IM_UTILS.varchar_tabletype,
701: p_aggregation_type out nocopy BSC_IM_UTILS.varchar_tabletype,
702: p_description out nocopy BSC_IM_UTILS.varchar_tabletype,
703: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
704: p_number_columns out nocopy number

Line 701: p_aggregation_type out nocopy BSC_IM_UTILS.varchar_tabletype,

697: p_column_name out nocopy BSC_IM_UTILS.varchar_tabletype,
698: p_column_type out nocopy BSC_IM_UTILS.varchar_tabletype,
699: p_column_data_type out nocopy BSC_IM_UTILS.varchar_tabletype,
700: p_column_origin out nocopy BSC_IM_UTILS.varchar_tabletype,
701: p_aggregation_type out nocopy BSC_IM_UTILS.varchar_tabletype,
702: p_description out nocopy BSC_IM_UTILS.varchar_tabletype,
703: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
704: p_number_columns out nocopy number
705: )return boolean is

Line 702: p_description out nocopy BSC_IM_UTILS.varchar_tabletype,

698: p_column_type out nocopy BSC_IM_UTILS.varchar_tabletype,
699: p_column_data_type out nocopy BSC_IM_UTILS.varchar_tabletype,
700: p_column_origin out nocopy BSC_IM_UTILS.varchar_tabletype,
701: p_aggregation_type out nocopy BSC_IM_UTILS.varchar_tabletype,
702: p_description out nocopy BSC_IM_UTILS.varchar_tabletype,
703: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
704: p_number_columns out nocopy number
705: )return boolean is
706: Begin

Line 703: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,

699: p_column_data_type out nocopy BSC_IM_UTILS.varchar_tabletype,
700: p_column_origin out nocopy BSC_IM_UTILS.varchar_tabletype,
701: p_aggregation_type out nocopy BSC_IM_UTILS.varchar_tabletype,
702: p_description out nocopy BSC_IM_UTILS.varchar_tabletype,
703: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
704: p_number_columns out nocopy number
705: )return boolean is
706: Begin
707: p_number_columns:=0;

Line 725: BSC_IM_UTILS.g_status_message:=sqlerrm;

721: end if;
722: end loop;
723: return true;
724: Exception when others then
725: BSC_IM_UTILS.g_status_message:=sqlerrm;
726: g_status_message:=sqlerrm;
727: write_to_log_file_n('Error in get_column '||sqlerrm);
728: return false;
729: End;

Line 734: p_child_level out nocopy BSC_IM_UTILS.varchar_tabletype,

730:
731: function get_level_relation(
732: p_dim_name varchar2,
733: p_apps_origin varchar2,
734: p_child_level out nocopy BSC_IM_UTILS.varchar_tabletype,
735: p_parent_level out nocopy BSC_IM_UTILS.varchar_tabletype,
736: p_child_fk out nocopy BSC_IM_UTILS.varchar_tabletype,
737: p_parent_pk out nocopy BSC_IM_UTILS.varchar_tabletype,
738: p_hier_name out nocopy BSC_IM_UTILS.varchar_tabletype,

Line 735: p_parent_level out nocopy BSC_IM_UTILS.varchar_tabletype,

731: function get_level_relation(
732: p_dim_name varchar2,
733: p_apps_origin varchar2,
734: p_child_level out nocopy BSC_IM_UTILS.varchar_tabletype,
735: p_parent_level out nocopy BSC_IM_UTILS.varchar_tabletype,
736: p_child_fk out nocopy BSC_IM_UTILS.varchar_tabletype,
737: p_parent_pk out nocopy BSC_IM_UTILS.varchar_tabletype,
738: p_hier_name out nocopy BSC_IM_UTILS.varchar_tabletype,
739: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,

Line 736: p_child_fk out nocopy BSC_IM_UTILS.varchar_tabletype,

732: p_dim_name varchar2,
733: p_apps_origin varchar2,
734: p_child_level out nocopy BSC_IM_UTILS.varchar_tabletype,
735: p_parent_level out nocopy BSC_IM_UTILS.varchar_tabletype,
736: p_child_fk out nocopy BSC_IM_UTILS.varchar_tabletype,
737: p_parent_pk out nocopy BSC_IM_UTILS.varchar_tabletype,
738: p_hier_name out nocopy BSC_IM_UTILS.varchar_tabletype,
739: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
740: p_number_level_relations out nocopy number

Line 737: p_parent_pk out nocopy BSC_IM_UTILS.varchar_tabletype,

733: p_apps_origin varchar2,
734: p_child_level out nocopy BSC_IM_UTILS.varchar_tabletype,
735: p_parent_level out nocopy BSC_IM_UTILS.varchar_tabletype,
736: p_child_fk out nocopy BSC_IM_UTILS.varchar_tabletype,
737: p_parent_pk out nocopy BSC_IM_UTILS.varchar_tabletype,
738: p_hier_name out nocopy BSC_IM_UTILS.varchar_tabletype,
739: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
740: p_number_level_relations out nocopy number
741: )return boolean is

Line 738: p_hier_name out nocopy BSC_IM_UTILS.varchar_tabletype,

734: p_child_level out nocopy BSC_IM_UTILS.varchar_tabletype,
735: p_parent_level out nocopy BSC_IM_UTILS.varchar_tabletype,
736: p_child_fk out nocopy BSC_IM_UTILS.varchar_tabletype,
737: p_parent_pk out nocopy BSC_IM_UTILS.varchar_tabletype,
738: p_hier_name out nocopy BSC_IM_UTILS.varchar_tabletype,
739: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
740: p_number_level_relations out nocopy number
741: )return boolean is
742: Begin

Line 739: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,

735: p_parent_level out nocopy BSC_IM_UTILS.varchar_tabletype,
736: p_child_fk out nocopy BSC_IM_UTILS.varchar_tabletype,
737: p_parent_pk out nocopy BSC_IM_UTILS.varchar_tabletype,
738: p_hier_name out nocopy BSC_IM_UTILS.varchar_tabletype,
739: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
740: p_number_level_relations out nocopy number
741: )return boolean is
742: Begin
743: p_number_level_relations:=0;

Line 760: BSC_IM_UTILS.g_status_message:=sqlerrm;

756: end if;
757: end loop;
758: return true;
759: Exception when others then
760: BSC_IM_UTILS.g_status_message:=sqlerrm;
761: g_status_message:=sqlerrm;
762: write_to_log_file_n('Error in get_level_relation '||sqlerrm);
763: return false;
764: End;

Line 769: p_hier_name out nocopy BSC_IM_UTILS.varchar_tabletype,

765:
766: function get_hierarchy(
767: p_dim_name varchar2,
768: p_apps_origin varchar2,
769: p_hier_name out nocopy BSC_IM_UTILS.varchar_tabletype,
770: p_description out nocopy BSC_im_UTILS.varchar_tabletype,
771: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
772: p_number_hierarchy out nocopy number
773: )return boolean is

Line 770: p_description out nocopy BSC_im_UTILS.varchar_tabletype,

766: function get_hierarchy(
767: p_dim_name varchar2,
768: p_apps_origin varchar2,
769: p_hier_name out nocopy BSC_IM_UTILS.varchar_tabletype,
770: p_description out nocopy BSC_im_UTILS.varchar_tabletype,
771: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
772: p_number_hierarchy out nocopy number
773: )return boolean is
774: Begin

Line 771: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,

767: p_dim_name varchar2,
768: p_apps_origin varchar2,
769: p_hier_name out nocopy BSC_IM_UTILS.varchar_tabletype,
770: p_description out nocopy BSC_im_UTILS.varchar_tabletype,
771: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
772: p_number_hierarchy out nocopy number
773: )return boolean is
774: Begin
775: p_number_hierarchy:=0;

Line 789: BSC_IM_UTILS.g_status_message:=sqlerrm;

785: end if;
786: end loop;
787: return true;
788: Exception when others then
789: BSC_IM_UTILS.g_status_message:=sqlerrm;
790: g_status_message:=sqlerrm;
791: write_to_log_file_n('Error in get_hierarchy '||sqlerrm);
792: return false;
793: End;

Line 798: p_map_name out nocopy BSC_IM_UTILS.varchar_tabletype,

794:
795: function get_mapping(
796: p_owner_name varchar2,
797: p_apps_origin varchar2,
798: p_map_name out nocopy BSC_IM_UTILS.varchar_tabletype,
799: p_map_type out nocopy BSC_IM_UTILS.varchar_tabletype,
800: p_object_name out nocopy BSC_IM_UTILS.varchar_tabletype,
801: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
802: p_number_mapping out nocopy number

Line 799: p_map_type out nocopy BSC_IM_UTILS.varchar_tabletype,

795: function get_mapping(
796: p_owner_name varchar2,
797: p_apps_origin varchar2,
798: p_map_name out nocopy BSC_IM_UTILS.varchar_tabletype,
799: p_map_type out nocopy BSC_IM_UTILS.varchar_tabletype,
800: p_object_name out nocopy BSC_IM_UTILS.varchar_tabletype,
801: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
802: p_number_mapping out nocopy number
803: )return boolean is

Line 800: p_object_name out nocopy BSC_IM_UTILS.varchar_tabletype,

796: p_owner_name varchar2,
797: p_apps_origin varchar2,
798: p_map_name out nocopy BSC_IM_UTILS.varchar_tabletype,
799: p_map_type out nocopy BSC_IM_UTILS.varchar_tabletype,
800: p_object_name out nocopy BSC_IM_UTILS.varchar_tabletype,
801: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
802: p_number_mapping out nocopy number
803: )return boolean is
804: Begin

Line 801: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,

797: p_apps_origin varchar2,
798: p_map_name out nocopy BSC_IM_UTILS.varchar_tabletype,
799: p_map_type out nocopy BSC_IM_UTILS.varchar_tabletype,
800: p_object_name out nocopy BSC_IM_UTILS.varchar_tabletype,
801: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
802: p_number_mapping out nocopy number
803: )return boolean is
804: Begin
805: p_number_mapping:=0;

Line 820: BSC_IM_UTILS.g_status_message:=sqlerrm;

816: end if;
817: end loop;
818: return true;
819: Exception when others then
820: BSC_IM_UTILS.g_status_message:=sqlerrm;
821: g_status_message:=sqlerrm;
822: write_to_log_file_n('Error in get_mapping '||sqlerrm);
823: return false;
824: End;

Line 829: p_line out nocopy BSC_IM_UTILS.varchar_tabletype,

825:
826: function get_mapping_detail(
827: p_map_name varchar2,
828: p_apps_origin varchar2,
829: p_line out nocopy BSC_IM_UTILS.varchar_tabletype,
830: p_line_type out nocopy BSC_IM_UTILS.varchar_tabletype,
831: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
832: p_number_map_detail out nocopy number
833: )return boolean is

Line 830: p_line_type out nocopy BSC_IM_UTILS.varchar_tabletype,

826: function get_mapping_detail(
827: p_map_name varchar2,
828: p_apps_origin varchar2,
829: p_line out nocopy BSC_IM_UTILS.varchar_tabletype,
830: p_line_type out nocopy BSC_IM_UTILS.varchar_tabletype,
831: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
832: p_number_map_detail out nocopy number
833: )return boolean is
834: Begin

Line 831: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,

827: p_map_name varchar2,
828: p_apps_origin varchar2,
829: p_line out nocopy BSC_IM_UTILS.varchar_tabletype,
830: p_line_type out nocopy BSC_IM_UTILS.varchar_tabletype,
831: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
832: p_number_map_detail out nocopy number
833: )return boolean is
834: Begin
835: p_number_map_detail:=0;

Line 849: BSC_IM_UTILS.g_status_message:=sqlerrm;

845: end if;
846: end loop;
847: return true;
848: Exception when others then
849: BSC_IM_UTILS.g_status_message:=sqlerrm;
850: g_status_message:=sqlerrm;
851: write_to_log_file_n('Error in get_mapping_detail '||sqlerrm);
852: return false;
853: End;

Line 878: BSC_IM_UTILS.g_status_message:=sqlerrm;

874: end if;
875: end loop;
876: return true;
877: Exception when others then
878: BSC_IM_UTILS.g_status_message:=sqlerrm;
879: g_status_message:=sqlerrm;
880: write_to_log_file_n('Error in get_cube '||sqlerrm);
881: return false;
882: End;

Line 887: p_fk_name out nocopy BSC_IM_UTILS.varchar_tabletype,

883:
884: function get_fk(
885: p_owner_name varchar2,
886: p_apps_origin varchar2,
887: p_fk_name out nocopy BSC_IM_UTILS.varchar_tabletype,
888: p_fk_type out nocopy BSC_IM_UTILS.varchar_tabletype,
889: p_uk_name out nocopy BSC_IM_UTILS.varchar_tabletype,
890: p_uk_parent_name out nocopy BSC_IM_UTILS.varchar_tabletype,
891: p_description out nocopy BSC_IM_UTILS.varchar_tabletype,

Line 888: p_fk_type out nocopy BSC_IM_UTILS.varchar_tabletype,

884: function get_fk(
885: p_owner_name varchar2,
886: p_apps_origin varchar2,
887: p_fk_name out nocopy BSC_IM_UTILS.varchar_tabletype,
888: p_fk_type out nocopy BSC_IM_UTILS.varchar_tabletype,
889: p_uk_name out nocopy BSC_IM_UTILS.varchar_tabletype,
890: p_uk_parent_name out nocopy BSC_IM_UTILS.varchar_tabletype,
891: p_description out nocopy BSC_IM_UTILS.varchar_tabletype,
892: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,

Line 889: p_uk_name out nocopy BSC_IM_UTILS.varchar_tabletype,

885: p_owner_name varchar2,
886: p_apps_origin varchar2,
887: p_fk_name out nocopy BSC_IM_UTILS.varchar_tabletype,
888: p_fk_type out nocopy BSC_IM_UTILS.varchar_tabletype,
889: p_uk_name out nocopy BSC_IM_UTILS.varchar_tabletype,
890: p_uk_parent_name out nocopy BSC_IM_UTILS.varchar_tabletype,
891: p_description out nocopy BSC_IM_UTILS.varchar_tabletype,
892: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
893: p_number_fk out nocopy number

Line 890: p_uk_parent_name out nocopy BSC_IM_UTILS.varchar_tabletype,

886: p_apps_origin varchar2,
887: p_fk_name out nocopy BSC_IM_UTILS.varchar_tabletype,
888: p_fk_type out nocopy BSC_IM_UTILS.varchar_tabletype,
889: p_uk_name out nocopy BSC_IM_UTILS.varchar_tabletype,
890: p_uk_parent_name out nocopy BSC_IM_UTILS.varchar_tabletype,
891: p_description out nocopy BSC_IM_UTILS.varchar_tabletype,
892: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
893: p_number_fk out nocopy number
894: )return boolean is

Line 891: p_description out nocopy BSC_IM_UTILS.varchar_tabletype,

887: p_fk_name out nocopy BSC_IM_UTILS.varchar_tabletype,
888: p_fk_type out nocopy BSC_IM_UTILS.varchar_tabletype,
889: p_uk_name out nocopy BSC_IM_UTILS.varchar_tabletype,
890: p_uk_parent_name out nocopy BSC_IM_UTILS.varchar_tabletype,
891: p_description out nocopy BSC_IM_UTILS.varchar_tabletype,
892: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
893: p_number_fk out nocopy number
894: )return boolean is
895: Begin

Line 892: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,

888: p_fk_type out nocopy BSC_IM_UTILS.varchar_tabletype,
889: p_uk_name out nocopy BSC_IM_UTILS.varchar_tabletype,
890: p_uk_parent_name out nocopy BSC_IM_UTILS.varchar_tabletype,
891: p_description out nocopy BSC_IM_UTILS.varchar_tabletype,
892: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
893: p_number_fk out nocopy number
894: )return boolean is
895: Begin
896: p_number_fk:=0;

Line 913: BSC_IM_UTILS.g_status_message:=sqlerrm;

909: end if;
910: end loop;
911: return true;
912: Exception when others then
913: BSC_IM_UTILS.g_status_message:=sqlerrm;
914: g_status_message:=sqlerrm;
915: write_to_log_file_n('Error in get_fk '||sqlerrm);
916: return false;
917: End;

Line 922: p_uk_name out nocopy BSC_IM_UTILS.varchar_tabletype,

918:
919: function get_uk(
920: p_owner_name varchar2,
921: p_apps_origin varchar2,
922: p_uk_name out nocopy BSC_IM_UTILS.varchar_tabletype,
923: p_uk_type out nocopy BSC_IM_UTILS.varchar_tabletype,
924: p_description out nocopy BSC_IM_UTILS.varchar_tabletype,
925: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
926: p_number_uk out nocopy number

Line 923: p_uk_type out nocopy BSC_IM_UTILS.varchar_tabletype,

919: function get_uk(
920: p_owner_name varchar2,
921: p_apps_origin varchar2,
922: p_uk_name out nocopy BSC_IM_UTILS.varchar_tabletype,
923: p_uk_type out nocopy BSC_IM_UTILS.varchar_tabletype,
924: p_description out nocopy BSC_IM_UTILS.varchar_tabletype,
925: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
926: p_number_uk out nocopy number
927: )return boolean is

Line 924: p_description out nocopy BSC_IM_UTILS.varchar_tabletype,

920: p_owner_name varchar2,
921: p_apps_origin varchar2,
922: p_uk_name out nocopy BSC_IM_UTILS.varchar_tabletype,
923: p_uk_type out nocopy BSC_IM_UTILS.varchar_tabletype,
924: p_description out nocopy BSC_IM_UTILS.varchar_tabletype,
925: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
926: p_number_uk out nocopy number
927: )return boolean is
928: Begin

Line 925: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,

921: p_apps_origin varchar2,
922: p_uk_name out nocopy BSC_IM_UTILS.varchar_tabletype,
923: p_uk_type out nocopy BSC_IM_UTILS.varchar_tabletype,
924: p_description out nocopy BSC_IM_UTILS.varchar_tabletype,
925: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
926: p_number_uk out nocopy number
927: )return boolean is
928: Begin
929: p_number_uk:=0;

Line 944: BSC_IM_UTILS.g_status_message:=sqlerrm;

940: end if;
941: end loop;
942: return true;
943: Exception when others then
944: BSC_IM_UTILS.g_status_message:=sqlerrm;
945: g_status_message:=sqlerrm;
946: write_to_log_file_n('Error in get_uk '||sqlerrm);
947: return false;
948: End;

Line 953: p_object_name out nocopy BSC_IM_UTILS.varchar_tabletype,

949:
950: function get_object(
951: p_parent_name varchar2,
952: p_apps_origin varchar2,
953: p_object_name out nocopy BSC_IM_UTILS.varchar_tabletype,
954: p_object_type out nocopy BSC_IM_UTILS.varchar_tabletype,
955: p_description out nocopy BSC_IM_UTILS.varchar_tabletype,
956: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
957: p_number_object out nocopy number

Line 954: p_object_type out nocopy BSC_IM_UTILS.varchar_tabletype,

950: function get_object(
951: p_parent_name varchar2,
952: p_apps_origin varchar2,
953: p_object_name out nocopy BSC_IM_UTILS.varchar_tabletype,
954: p_object_type out nocopy BSC_IM_UTILS.varchar_tabletype,
955: p_description out nocopy BSC_IM_UTILS.varchar_tabletype,
956: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
957: p_number_object out nocopy number
958: )return boolean is

Line 955: p_description out nocopy BSC_IM_UTILS.varchar_tabletype,

951: p_parent_name varchar2,
952: p_apps_origin varchar2,
953: p_object_name out nocopy BSC_IM_UTILS.varchar_tabletype,
954: p_object_type out nocopy BSC_IM_UTILS.varchar_tabletype,
955: p_description out nocopy BSC_IM_UTILS.varchar_tabletype,
956: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
957: p_number_object out nocopy number
958: )return boolean is
959: Begin

Line 956: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,

952: p_apps_origin varchar2,
953: p_object_name out nocopy BSC_IM_UTILS.varchar_tabletype,
954: p_object_type out nocopy BSC_IM_UTILS.varchar_tabletype,
955: p_description out nocopy BSC_IM_UTILS.varchar_tabletype,
956: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
957: p_number_object out nocopy number
958: )return boolean is
959: Begin
960: p_number_object:=0;

Line 975: BSC_IM_UTILS.g_status_message:=sqlerrm;

971: end if;
972: end loop;
973: return true;
974: Exception when others then
975: BSC_IM_UTILS.g_status_message:=sqlerrm;
976: g_status_message:=sqlerrm;
977: write_to_log_file_n('Error in get_object '||sqlerrm);
978: return false;
979: End;

Line 985: p_object_name out nocopy BSC_IM_UTILS.varchar_tabletype,

981: function get_object(
982: p_parent_name varchar2,
983: p_apps_origin varchar2,
984: p_property varchar2,
985: p_object_name out nocopy BSC_IM_UTILS.varchar_tabletype,
986: p_object_type out nocopy BSC_IM_UTILS.varchar_tabletype,
987: p_description out nocopy BSC_IM_UTILS.varchar_tabletype,
988: p_number_object out nocopy number
989: )return boolean is

Line 986: p_object_type out nocopy BSC_IM_UTILS.varchar_tabletype,

982: p_parent_name varchar2,
983: p_apps_origin varchar2,
984: p_property varchar2,
985: p_object_name out nocopy BSC_IM_UTILS.varchar_tabletype,
986: p_object_type out nocopy BSC_IM_UTILS.varchar_tabletype,
987: p_description out nocopy BSC_IM_UTILS.varchar_tabletype,
988: p_number_object out nocopy number
989: )return boolean is
990: Begin

Line 987: p_description out nocopy BSC_IM_UTILS.varchar_tabletype,

983: p_apps_origin varchar2,
984: p_property varchar2,
985: p_object_name out nocopy BSC_IM_UTILS.varchar_tabletype,
986: p_object_type out nocopy BSC_IM_UTILS.varchar_tabletype,
987: p_description out nocopy BSC_IM_UTILS.varchar_tabletype,
988: p_number_object out nocopy number
989: )return boolean is
990: Begin
991: p_number_object:=0;

Line 1006: BSC_IM_UTILS.g_status_message:=sqlerrm;

1002: end if;
1003: end loop;
1004: return true;
1005: Exception when others then
1006: BSC_IM_UTILS.g_status_message:=sqlerrm;
1007: g_status_message:=sqlerrm;
1008: write_to_log_file_n('Error in get_object '||sqlerrm);
1009: return false;
1010: End;

Line 1035: BSC_IM_UTILS.g_status_message:=sqlerrm;

1031: end if;
1032: end loop;
1033: return true;
1034: Exception when others then
1035: BSC_IM_UTILS.g_status_message:=sqlerrm;
1036: g_status_message:=sqlerrm;
1037: write_to_log_file_n('Error in get_object '||sqlerrm);
1038: return false;
1039: End;

Line 1109: BSC_IM_UTILS.g_status_message:=sqlerrm;

1105: end loop;
1106: end if;
1107: return 'OTHER';
1108: Exception when others then
1109: BSC_IM_UTILS.g_status_message:=sqlerrm;
1110: g_status_message:=sqlerrm;
1111: write_to_log_file_n('Error in get_object_type '||sqlerrm);
1112: return null;
1113: End;

Line 1125: BSC_IM_UTILS.g_status_message:=sqlerrm;

1121: else
1122: return number_im_md_cube;
1123: end if;
1124: Exception when others then
1125: BSC_IM_UTILS.g_status_message:=sqlerrm;
1126: g_status_message:=sqlerrm;
1127: write_to_log_file_n('Error in get_object_type '||sqlerrm);
1128: return null;
1129: End;

Line 1148: BSC_IM_UTILS.g_status_message:=sqlerrm;

1144: write_to_log_file_s(im_md_dimensions(i).property);
1145: write_to_log_file(' ');
1146: end loop;
1147: Exception when others then
1148: BSC_IM_UTILS.g_status_message:=sqlerrm;
1149: write_to_log_file_n('Error in dump_dimension '||sqlerrm);
1150: End;
1151:
1152: procedure dump_level is

Line 1169: BSC_IM_UTILS.g_status_message:=sqlerrm;

1165: write_to_log_file_s(im_md_levels(i).property);
1166: write_to_log_file(' ');
1167: end loop;
1168: Exception when others then
1169: BSC_IM_UTILS.g_status_message:=sqlerrm;
1170: write_to_log_file_n('Error in dump_level '||sqlerrm);
1171: End;
1172:
1173: procedure dump_column is

Line 1194: BSC_IM_UTILS.g_status_message:=sqlerrm;

1190: write_to_log_file_s(im_md_columns(i).property);
1191: write_to_log_file(' ');
1192: end loop;
1193: Exception when others then
1194: BSC_IM_UTILS.g_status_message:=sqlerrm;
1195: write_to_log_file_n('Error in dump_column '||sqlerrm);
1196: End;
1197:
1198: procedure dump_level_relation is

Line 1217: BSC_IM_UTILS.g_status_message:=sqlerrm;

1213: write_to_log_file_s(im_md_level_relations(i).property);
1214: write_to_log_file(' ');
1215: end loop;
1216: Exception when others then
1217: BSC_IM_UTILS.g_status_message:=sqlerrm;
1218: write_to_log_file_n('Error in dump_level_relation '||sqlerrm);
1219: End;
1220:
1221: procedure dump_hierarchy is

Line 1237: BSC_IM_UTILS.g_status_message:=sqlerrm;

1233: write_to_log_file_s(im_md_hierarchies(i).property);
1234: write_to_log_file(' ');
1235: end loop;
1236: Exception when others then
1237: BSC_IM_UTILS.g_status_message:=sqlerrm;
1238: write_to_log_file_n('Error in dump_hierarchy '||sqlerrm);
1239: End;
1240:
1241: procedure dump_mapping is

Line 1258: BSC_IM_UTILS.g_status_message:=sqlerrm;

1254: write_to_log_file_s(im_md_mapping(i).property);
1255: write_to_log_file(' ');
1256: end loop;
1257: Exception when others then
1258: BSC_IM_UTILS.g_status_message:=sqlerrm;
1259: write_to_log_file_n('Error in dump_mapping '||sqlerrm);
1260: End;
1261:
1262: procedure dump_mapping_detail is

Line 1278: BSC_IM_UTILS.g_status_message:=sqlerrm;

1274: write_to_log_file_s(im_md_mapping_details(i).property);
1275: write_to_log_file(' ');
1276: end loop;
1277: Exception when others then
1278: BSC_IM_UTILS.g_status_message:=sqlerrm;
1279: write_to_log_file_n('Error in dump_mapping_detail '||sqlerrm);
1280: End;
1281:
1282: procedure dump_cube is

Line 1299: BSC_IM_UTILS.g_status_message:=sqlerrm;

1295: write_to_log_file_s(im_md_cube(i).property);
1296: write_to_log_file(' ');
1297: end loop;
1298: Exception when others then
1299: BSC_IM_UTILS.g_status_message:=sqlerrm;
1300: write_to_log_file_n('Error in dump_cube '||sqlerrm);
1301: End;
1302:
1303: procedure dump_fk is

Line 1323: BSC_IM_UTILS.g_status_message:=sqlerrm;

1319: write_to_log_file_s(im_md_fk(i).property);
1320: write_to_log_file(' ');
1321: end loop;
1322: Exception when others then
1323: BSC_IM_UTILS.g_status_message:=sqlerrm;
1324: write_to_log_file_n('Error in dump_fk '||sqlerrm);
1325: End;
1326:
1327: procedure dump_uk is

Line 1344: BSC_IM_UTILS.g_status_message:=sqlerrm;

1340: write_to_log_file_s(im_md_uk(i).property);
1341: write_to_log_file(' ');
1342: end loop;
1343: Exception when others then
1344: BSC_IM_UTILS.g_status_message:=sqlerrm;
1345: write_to_log_file_n('Error in dump_uk '||sqlerrm);
1346: End;
1347:
1348: procedure dump_object is

Line 1365: BSC_IM_UTILS.g_status_message:=sqlerrm;

1361: write_to_log_file_s(im_md_object(i).property);
1362: write_to_log_file(' ');
1363: end loop;
1364: Exception when others then
1365: BSC_IM_UTILS.g_status_message:=sqlerrm;
1366: write_to_log_file_n('Error in dump_object '||sqlerrm);
1367: End;
1368:
1369: procedure dump_all is

Line 1383: BSC_IM_UTILS.g_status_message:=sqlerrm;

1379: dump_fk;
1380: dump_uk;
1381: dump_object;
1382: Exception when others then
1383: BSC_IM_UTILS.g_status_message:=sqlerrm;
1384: write_to_log_file_n('Error in dump_all '||sqlerrm);
1385: End;
1386:
1387:

Line 1391: BSC_IM_UTILS.write_to_log_file(p_message);

1387:
1388: --==============================================================================
1389: procedure write_to_log_file(p_message varchar2) is
1390: Begin
1391: BSC_IM_UTILS.write_to_log_file(p_message);
1392: Exception when others then
1393: BSC_IM_UTILS.g_status_message:=sqlerrm;
1394: null;
1395: End;

Line 1393: BSC_IM_UTILS.g_status_message:=sqlerrm;

1389: procedure write_to_log_file(p_message varchar2) is
1390: Begin
1391: BSC_IM_UTILS.write_to_log_file(p_message);
1392: Exception when others then
1393: BSC_IM_UTILS.g_status_message:=sqlerrm;
1394: null;
1395: End;
1396:
1397: procedure write_to_log_file_s(p_message varchar2) is

Line 1399: BSC_IM_UTILS.write_to_log_file_s(p_message);

1395: End;
1396:
1397: procedure write_to_log_file_s(p_message varchar2) is
1398: Begin
1399: BSC_IM_UTILS.write_to_log_file_s(p_message);
1400: Exception when others then
1401: BSC_IM_UTILS.g_status_message:=sqlerrm;
1402: null;
1403: End;

Line 1401: BSC_IM_UTILS.g_status_message:=sqlerrm;

1397: procedure write_to_log_file_s(p_message varchar2) is
1398: Begin
1399: BSC_IM_UTILS.write_to_log_file_s(p_message);
1400: Exception when others then
1401: BSC_IM_UTILS.g_status_message:=sqlerrm;
1402: null;
1403: End;
1404:
1405: procedure write_to_log_file_n(p_message varchar2) is

Line 1410: BSC_IM_UTILS.g_status_message:=sqlerrm;

1406: begin
1407: write_to_log_file(' ');
1408: write_to_log_file(p_message);
1409: Exception when others then
1410: BSC_IM_UTILS.g_status_message:=sqlerrm;
1411: null;
1412: end;
1413:
1414: procedure write_to_debug_n(p_message varchar2) is

Line 1420: BSC_IM_UTILS.g_status_message:=sqlerrm;

1416: if g_debug then
1417: write_to_log_file_n(p_message);
1418: end if;
1419: Exception when others then
1420: BSC_IM_UTILS.g_status_message:=sqlerrm;
1421: null;
1422: end;
1423:
1424: procedure write_to_debug(p_message varchar2) is

Line 1430: BSC_IM_UTILS.g_status_message:=sqlerrm;

1426: if g_debug then
1427: write_to_log_file(p_message);
1428: end if;
1429: Exception when others then
1430: BSC_IM_UTILS.g_status_message:=sqlerrm;
1431: null;
1432: end;
1433:
1434: function get_time return varchar2 is

Line 1438: BSC_IM_UTILS.g_status_message:=sqlerrm;

1434: function get_time return varchar2 is
1435: begin
1436: return ' '||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS');
1437: Exception when others then
1438: BSC_IM_UTILS.g_status_message:=sqlerrm;
1439: null;
1440: End;
1441:
1442: procedure set_globals(p_debug boolean) is

Line 1446: BSC_IM_UTILS.g_status_message:=sqlerrm;

1442: procedure set_globals(p_debug boolean) is
1443: Begin
1444: g_debug:=p_debug;
1445: Exception when others then
1446: BSC_IM_UTILS.g_status_message:=sqlerrm;
1447: write_to_log_file_n('Error in set_globals '||sqlerrm);
1448: End;
1449:
1450: