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 127: -- msc_util.debug_message(to_number(var) , 'Start'||v_tab_Sql_Stmt(to_number(var)).p_table_name);

123: inti_pl_sql_table(v_tab_Sql_Stmt);
124:
125: for var in 1..v_tab_Sql_Stmt.count
126: loop
127: -- msc_util.debug_message(to_number(var) , 'Start'||v_tab_Sql_Stmt(to_number(var)).p_table_name);
128: generate_sql_script(v_col_value ,
129: v_tab_Sql_Stmt(to_number(var)).p_table_name) ;
130: --msc_util.debug_message(to_number(var) , 'End'||v_tab_Sql_Stmt(to_number(var)).p_table_name);
131:

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

126: loop
127: -- msc_util.debug_message(to_number(var) , 'Start'||v_tab_Sql_Stmt(to_number(var)).p_table_name);
128: generate_sql_script(v_col_value ,
129: v_tab_Sql_Stmt(to_number(var)).p_table_name) ;
130: --msc_util.debug_message(to_number(var) , 'End'||v_tab_Sql_Stmt(to_number(var)).p_table_name);
131:
132: end loop;
133: commit;
134:

Line 505: msc_util.msc_debug('Submitted request for plan deletion

501: if p_childreq then
502: fnd_conc_global.set_req_globals(conc_status => 'PAUSED',
503: request_data => to_char(v_request_id)) ;
504: end if;
505: msc_util.msc_debug('Submitted request for plan deletion
506: '||v_request_id);
507: end if;
508: retcode := 0;
509: errbuf := NULL;

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

796: p_table_name );
797: end if;
798: end loop;
799: v_statement := v_statement||' ) ' ;
800: --msc_util.debug_message(1 ,v_statement);
801: v_statement1 := v_statement1||' FROM '||p_table_name||' where
802: designator_id = '||v_prev_designator_id ;
803: --msc_util.debug_message(2 ,v_statement1);
804: v_statement := v_statement||' '||v_statement1;

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

799: v_statement := v_statement||' ) ' ;
800: --msc_util.debug_message(1 ,v_statement);
801: v_statement1 := v_statement1||' FROM '||p_table_name||' where
802: designator_id = '||v_prev_designator_id ;
803: --msc_util.debug_message(2 ,v_statement1);
804: v_statement := v_statement||' '||v_statement1;
805: --msc_util.debug_message(1 ,'Start '|| p_table_name);
806: --msc_util.debug_message(1 ,v_statement);
807:

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

801: v_statement1 := v_statement1||' FROM '||p_table_name||' where
802: designator_id = '||v_prev_designator_id ;
803: --msc_util.debug_message(2 ,v_statement1);
804: v_statement := v_statement||' '||v_statement1;
805: --msc_util.debug_message(1 ,'Start '|| p_table_name);
806: --msc_util.debug_message(1 ,v_statement);
807:
808: EXECUTE IMMEDIATE v_statement using p_bind_var_col(1).P_DEST_PLAN_NAME
809: ,p_bind_var_col(1).P_DESCRIPTION ;

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

802: designator_id = '||v_prev_designator_id ;
803: --msc_util.debug_message(2 ,v_statement1);
804: v_statement := v_statement||' '||v_statement1;
805: --msc_util.debug_message(1 ,'Start '|| p_table_name);
806: --msc_util.debug_message(1 ,v_statement);
807:
808: EXECUTE IMMEDIATE v_statement using p_bind_var_col(1).P_DEST_PLAN_NAME
809: ,p_bind_var_col(1).P_DESCRIPTION ;
810:

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

807:
808: EXECUTE IMMEDIATE v_statement using p_bind_var_col(1).P_DEST_PLAN_NAME
809: ,p_bind_var_col(1).P_DESCRIPTION ;
810:
811: --msc_util.debug_message(1 ,'End '|| p_table_name);
812: elsif p_table_name = 'MSC_PLANS' then
813: v_statement := 'INSERT INTO '||p_table_name||' (COMPILE_DESIGNATOR
814: ,DESCRIPTION ' ;
815: v_statement1 := ' SELECT :COMPILE_DESIGNATOR , :DESCRIPTION ' ;

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

830: v_statement1 := v_statement1||' FROM '||p_table_name||' where
831: plan_id = '||p_bind_var_col(1).P_SOURCE_PLAN_ID ;
832: v_statement := v_statement||' '||v_statement1;
833:
834: -- msc_util.debug_message(2 ,'Start '|| p_table_name);
835:
836: EXECUTE IMMEDIATE v_statement using p_bind_var_col(1).P_DEST_PLAN_NAME
837: ,p_bind_var_col(1).P_DEST_PLAN_DESC ;
838:

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

835:
836: EXECUTE IMMEDIATE v_statement using p_bind_var_col(1).P_DEST_PLAN_NAME
837: ,p_bind_var_col(1).P_DEST_PLAN_DESC ;
838:
839: -- msc_util.debug_message(2 ,'End '|| p_table_name);
840:
841: elsif p_table_name not in ( 'MSC_PLANS' ,'MSC_DESIGNATORS' ) then
842: -- msc_util.debug_message(2 ,'Start '|| p_table_name);
843: for var in cur_design(p_table_name , v_msc_schema)

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

838:
839: -- msc_util.debug_message(2 ,'End '|| p_table_name);
840:
841: elsif p_table_name not in ( 'MSC_PLANS' ,'MSC_DESIGNATORS' ) then
842: -- msc_util.debug_message(2 ,'Start '|| p_table_name);
843: for var in cur_design(p_table_name , v_msc_schema)
844: loop
845: i := i + 1;
846: if i = 1 then

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

852: end loop;
853: v_statement := v_statement||' ) ' ;
854:
855: i := 0;
856: -- msc_util.debug_message(2 ,v_statement);
857: for var in cur_design(p_table_name , v_msc_schema)
858: loop
859: i := i + 1;
860: if i = 1 then

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

869: end loop;
870: v_statement1 := v_statement1||' FROM '||p_table_name||' where
871: plan_id = '||p_bind_var_col(1).P_SOURCE_PLAN_ID ;
872: v_statement := v_statement||' '||v_statement1;
873: -- msc_util.debug_message(3 ,v_statement);
874: EXECUTE IMMEDIATE v_statement;
875:
876:
877: end if;