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.MSC_COPY_PLAN_OPTIONS dependencies on MSC_UTIL

Line 46: --msc_util.init_message;

42: v_tab_Sql_Stmt Copy_Plan_Source_Tables_Type ;
43: l_count number := 0;
44:
45: BEGIN
46: --msc_util.init_message;
47: inti_pl_sql_table(v_tab_Sql_Stmt);
48: if nvl(L_Temp_plan,'N') = 'N' Then
49: v_dest_plan_id := MSC_MANAGE_PLAN_PARTITIONS.get_plan(
50: p_dest_plan_name,

Line 121: -- msc_util.debug_message(to_number(var) , 'Start '||v_tab_Sql_Stmt(to_number(var)).p_table_name);

117: inti_pl_sql_table(v_tab_Sql_Stmt);
118:
119: for var in 1..v_tab_Sql_Stmt.count
120: loop
121: -- msc_util.debug_message(to_number(var) , 'Start '||v_tab_Sql_Stmt(to_number(var)).p_table_name);
122: generate_sql_script(v_col_value , v_tab_Sql_Stmt(to_number(var)).p_table_name) ;
123: --msc_util.debug_message(to_number(var) , 'End '||v_tab_Sql_Stmt(to_number(var)).p_table_name);
124:
125: end loop;

Line 123: --msc_util.debug_message(to_number(var) , 'End '||v_tab_Sql_Stmt(to_number(var)).p_table_name);

119: for var in 1..v_tab_Sql_Stmt.count
120: loop
121: -- msc_util.debug_message(to_number(var) , 'Start '||v_tab_Sql_Stmt(to_number(var)).p_table_name);
122: generate_sql_script(v_col_value , v_tab_Sql_Stmt(to_number(var)).p_table_name) ;
123: --msc_util.debug_message(to_number(var) , 'End '||v_tab_Sql_Stmt(to_number(var)).p_table_name);
124:
125: end loop;
126: commit;
127:

Line 484: msc_util.msc_debug('Submitted request for plan deletion '||v_request_id);

480: if p_childreq then
481: fnd_conc_global.set_req_globals(conc_status => 'PAUSED',
482: request_data => to_char(v_request_id)) ;
483: end if;
484: msc_util.msc_debug('Submitted request for plan deletion '||v_request_id);
485: end if;
486: retcode := 0;
487: errbuf := NULL;
488:

Line 709: --msc_util.debug_message(1 ,v_statement);

705: v_statement1 := v_statement1||' , '||Get_Column_Value(p_bind_var_col ,var.column_name , var.data_type , p_table_name );
706: end if;
707: end loop;
708: v_statement := v_statement||' ) ' ;
709: --msc_util.debug_message(1 ,v_statement);
710: v_statement1 := v_statement1||' FROM '||p_table_name||' where designator_id = '||v_prev_designator_id ;
711: --msc_util.debug_message(2 ,v_statement1);
712: v_statement := v_statement||' '||v_statement1;
713: --msc_util.debug_message(1 ,'Start '|| p_table_name);

Line 711: --msc_util.debug_message(2 ,v_statement1);

707: end loop;
708: v_statement := v_statement||' ) ' ;
709: --msc_util.debug_message(1 ,v_statement);
710: v_statement1 := v_statement1||' FROM '||p_table_name||' where designator_id = '||v_prev_designator_id ;
711: --msc_util.debug_message(2 ,v_statement1);
712: v_statement := v_statement||' '||v_statement1;
713: --msc_util.debug_message(1 ,'Start '|| p_table_name);
714: --msc_util.debug_message(1 ,v_statement);
715:

Line 713: --msc_util.debug_message(1 ,'Start '|| p_table_name);

709: --msc_util.debug_message(1 ,v_statement);
710: v_statement1 := v_statement1||' FROM '||p_table_name||' where designator_id = '||v_prev_designator_id ;
711: --msc_util.debug_message(2 ,v_statement1);
712: v_statement := v_statement||' '||v_statement1;
713: --msc_util.debug_message(1 ,'Start '|| p_table_name);
714: --msc_util.debug_message(1 ,v_statement);
715:
716: EXECUTE IMMEDIATE v_statement using p_bind_var_col(1).P_DEST_PLAN_NAME ,p_bind_var_col(1).P_DESCRIPTION ;
717:

Line 714: --msc_util.debug_message(1 ,v_statement);

710: v_statement1 := v_statement1||' FROM '||p_table_name||' where designator_id = '||v_prev_designator_id ;
711: --msc_util.debug_message(2 ,v_statement1);
712: v_statement := v_statement||' '||v_statement1;
713: --msc_util.debug_message(1 ,'Start '|| p_table_name);
714: --msc_util.debug_message(1 ,v_statement);
715:
716: EXECUTE IMMEDIATE v_statement using p_bind_var_col(1).P_DEST_PLAN_NAME ,p_bind_var_col(1).P_DESCRIPTION ;
717:
718: --msc_util.debug_message(1 ,'End '|| p_table_name);

Line 718: --msc_util.debug_message(1 ,'End '|| p_table_name);

714: --msc_util.debug_message(1 ,v_statement);
715:
716: EXECUTE IMMEDIATE v_statement using p_bind_var_col(1).P_DEST_PLAN_NAME ,p_bind_var_col(1).P_DESCRIPTION ;
717:
718: --msc_util.debug_message(1 ,'End '|| p_table_name);
719: elsif p_table_name = 'MSC_PLANS' then
720: v_statement := 'INSERT INTO '||p_table_name||' (COMPILE_DESIGNATOR ,DESCRIPTION ' ;
721: v_statement1 := ' SELECT :COMPILE_DESIGNATOR , :DESCRIPTION ' ;
722: --6028814

Line 735: -- msc_util.debug_message(2 ,'Start '|| p_table_name);

731: v_statement := v_statement||' ) ';
732: v_statement1 := v_statement1||' FROM '||p_table_name||' where plan_id = '||p_bind_var_col(1).P_SOURCE_PLAN_ID ;
733: v_statement := v_statement||' '||v_statement1;
734:
735: -- msc_util.debug_message(2 ,'Start '|| p_table_name);
736:
737: EXECUTE IMMEDIATE v_statement using p_bind_var_col(1).P_DEST_PLAN_NAME ,p_bind_var_col(1).P_DEST_PLAN_DESC ;
738:
739: -- msc_util.debug_message(2 ,'End '|| p_table_name);

Line 739: -- msc_util.debug_message(2 ,'End '|| p_table_name);

735: -- msc_util.debug_message(2 ,'Start '|| p_table_name);
736:
737: EXECUTE IMMEDIATE v_statement using p_bind_var_col(1).P_DEST_PLAN_NAME ,p_bind_var_col(1).P_DEST_PLAN_DESC ;
738:
739: -- msc_util.debug_message(2 ,'End '|| p_table_name);
740:
741: elsif p_table_name not in ( 'MSC_PLANS' ,'MSC_DESIGNATORS' ) then
742: -- msc_util.debug_message(2 ,'Start '|| p_table_name);
743: for var in cur_design(p_table_name , v_msc_schema)

Line 742: -- msc_util.debug_message(2 ,'Start '|| p_table_name);

738:
739: -- msc_util.debug_message(2 ,'End '|| p_table_name);
740:
741: elsif p_table_name not in ( 'MSC_PLANS' ,'MSC_DESIGNATORS' ) then
742: -- msc_util.debug_message(2 ,'Start '|| p_table_name);
743: for var in cur_design(p_table_name , v_msc_schema)
744: loop
745: i := i + 1;
746: if i = 1 then

Line 755: -- msc_util.debug_message(2 ,v_statement);

751: end loop;
752: v_statement := v_statement||' ) ' ;
753:
754: i := 0;
755: -- msc_util.debug_message(2 ,v_statement);
756: for var in cur_design(p_table_name , v_msc_schema)
757: loop
758: i := i + 1;
759: if i = 1 then

Line 768: -- msc_util.debug_message(3 ,v_statement);

764: end if;
765: end loop;
766: v_statement1 := v_statement1||' FROM '||p_table_name||' where plan_id = '||p_bind_var_col(1).P_SOURCE_PLAN_ID ;
767: v_statement := v_statement||' '||v_statement1;
768: -- msc_util.debug_message(3 ,v_statement);
769: EXECUTE IMMEDIATE v_statement;
770:
771:
772: end if;