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_UTIL dependencies on MSC_UTIL

Line 1: PACKAGE BODY MSC_UTIL AS

1: PACKAGE BODY MSC_UTIL AS
2: /* $Header: MSCUTILB.pls 120.24.12010000.6 2008/08/28 06:08:44 vsiyer ship $ */
3:
4: -- GLOBAL VARIABLES IN BODY
5: APPS_SCHEMA VARCHAR2(30);

Line 210: IF pRECALC_SH = MSC_UTIL.SYS_YES THEN

206: IF Check_MSG_Level(G_LVL_STATUS) THEN
207: Print_Msg('************************************************************');
208: Print_Msg('Parameters selected for planning data pull:');
209: Print_Msg('------------------------------------------------------------');
210: IF pRECALC_SH = MSC_UTIL.SYS_YES THEN
211: Print_Msg('Recalculate Sourcing History: YES ' );
212: ELSE
213: Print_Msg('Recalculate Sourcing History: NO ' );
214: END IF;

Line 215: IF pPURGE_SH = MSC_UTIL.SYS_YES THEN

211: Print_Msg('Recalculate Sourcing History: YES ' );
212: ELSE
213: Print_Msg('Recalculate Sourcing History: NO ' );
214: END IF;
215: IF pPURGE_SH = MSC_UTIL.SYS_YES THEN
216: Print_Msg('Purge Sourcing History : YES ' );
217: ELSE
218: Print_Msg('Purge Sourcing History : NO ' );
219: END IF;

Line 332: p_column_list IN MSC_UTIL.char30_arr,

328:
329: PROCEDURE compare_index(
330: p_table_name IN VARCHAR2,
331: p_index_name IN VARCHAR2,
332: p_column_list IN MSC_UTIL.char30_arr,
333: x_create_index OUT NOCOPY BOOLEAN,
334: x_partitioned OUT NOCOPY BOOLEAN
335: )
336: IS

Line 408: RAISE_APPLICATION_ERROR(-20001, 'MSC_UTIL.COMPARE_INDEX: Error while checking the index attributes: ' || SQLERRM);

404: IF c_ind_columns%ISOPEN THEN
405: CLOSE c_ind_columns;
406: END IF;
407: ---- bug 2234098 change error code from 21001 to 20001
408: RAISE_APPLICATION_ERROR(-20001, 'MSC_UTIL.COMPARE_INDEX: Error while checking the index attributes: ' || SQLERRM);
409: END compare_index;
410:
411:
412:

Line 421: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Creating Snapshot Log for ' ||p_table||' ...');

417: IS
418: v_sql_stmt VARCHAR2(6000);
419: BEGIN
420:
421: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Creating Snapshot Log for ' ||p_table||' ...');
422:
423: v_sql_stmt:=
424: ' CREATE SNAPSHOT LOG ON '||p_schema ||'.'||p_table||' WITH ROWID ' ;
425:

Line 432: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Snapshot Log for ' ||p_table||' successfully created...');

428: statement_type => AD_DDL.CREATE_TABLE,
429: statement => v_sql_stmt,
430: object_name => p_table);
431:
432: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Snapshot Log for ' ||p_table||' successfully created...');
433:
434: EXCEPTION
435: WHEN OTHERS THEN
436:

Line 439: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Snapshot Log on ' ||p_table||' already exists...');

435: WHEN OTHERS THEN
436:
437: IF SQLCODE IN (-12000) THEN
438: /*Snapshot Log already EXISTS*/
439: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Snapshot Log on ' ||p_table||' already exists...');
440:
441: ELSIF SQLCODE IN (-00942) THEN
442: /*Base Table does not exist*/
443: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Table '||p_table||' does not exist...');

Line 443: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Table '||p_table||' does not exist...');

439: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Snapshot Log on ' ||p_table||' already exists...');
440:
441: ELSIF SQLCODE IN (-00942) THEN
442: /*Base Table does not exist*/
443: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Table '||p_table||' does not exist...');
444: ELSE
445: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, SQLERRM);
446: RAISE_APPLICATION_ERROR(-20001, 'Snapshot Log Creation on '|| p_table||' failed : ' || sqlerrm);
447: END IF;

Line 445: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, SQLERRM);

441: ELSIF SQLCODE IN (-00942) THEN
442: /*Base Table does not exist*/
443: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Table '||p_table||' does not exist...');
444: ELSE
445: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, SQLERRM);
446: RAISE_APPLICATION_ERROR(-20001, 'Snapshot Log Creation on '|| p_table||' failed : ' || sqlerrm);
447: END IF;
448: END CREATE_SNAP_LOG; --create_snap Log
449: /* ======== Create Snap Log========== */

Line 541: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, SQLERRM);

537: END IF;
538:
539: EXCEPTION
540: WHEN OTHERS THEN
541: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, SQLERRM);
542: raise_application_error(-20001, 'Error in Getting Storage Parameters : ' || sqlerrm);
543: END GET_STORAGE_PARAMETERS;
544:
545:

Line 566: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Creating Snapshot for '||p_table||' ...');

562:
563: v_logging_stmt := 'ALTER MATERIALIZED VIEW '||p_schema||'.'||p_object
564: ||' '||p_logging ||' PARALLEL '|| p_parallel_degree;
565:
566: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Creating Snapshot for '||p_table||' ...');
567:
568: ad_ddl.do_ddl( applsys_schema => p_applsys_schema,
569: application_short_name => p_schema,
570: statement_type => AD_DDL.CREATE_TABLE,

Line 574: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Snapshot for '||p_table||' succesfully created...');

570: statement_type => AD_DDL.CREATE_TABLE,
571: statement => p_sql_stmt,
572: object_name => p_object);
573:
574: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Snapshot for '||p_table||' succesfully created...');
575:
576: FND_STATS.gather_table_stats(p_schema,p_object,lv_pctg, lv_deg);
577:
578: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Gathered Statistics for the Snapshot '||p_object||' succesfully ...');

Line 578: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Gathered Statistics for the Snapshot '||p_object||' succesfully ...');

574: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Snapshot for '||p_table||' succesfully created...');
575:
576: FND_STATS.gather_table_stats(p_schema,p_object,lv_pctg, lv_deg);
577:
578: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Gathered Statistics for the Snapshot '||p_object||' succesfully ...');
579:
580: EXECUTE IMMEDIATE v_logging_stmt;
581: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Altering Snapshot : '||p_object);
582:

Line 581: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Altering Snapshot : '||p_object);

577:
578: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Gathered Statistics for the Snapshot '||p_object||' succesfully ...');
579:
580: EXECUTE IMMEDIATE v_logging_stmt;
581: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Altering Snapshot : '||p_object);
582:
583:
584: RETURN TRUE;
585:

Line 590: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Snapshot on '||p_table||' already exists...');

586: EXCEPTION
587: WHEN OTHERS THEN
588: IF SQLCODE IN (-12006) THEN
589: /*Snapshot already EXISTS*/
590: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Snapshot on '||p_table||' already exists...');
591: EXECUTE IMMEDIATE v_logging_stmt;
592: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Altering Snapshot : '||p_object);
593: RETURN TRUE;
594: ELSIF SQLCODE IN (-01749) THEN

Line 592: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Altering Snapshot : '||p_object);

588: IF SQLCODE IN (-12006) THEN
589: /*Snapshot already EXISTS*/
590: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Snapshot on '||p_table||' already exists...');
591: EXECUTE IMMEDIATE v_logging_stmt;
592: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Altering Snapshot : '||p_object);
593: RETURN TRUE;
594: ELSIF SQLCODE IN (-01749) THEN
595: /*you may not GRANT/REVOKE privileges to/from yourself*/
596: /* snapshot created in apps schema*/

Line 599: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, sqlerrm);

595: /*you may not GRANT/REVOKE privileges to/from yourself*/
596: /* snapshot created in apps schema*/
597: RETURN TRUE;
598: ELSIF instr(p_error,','||trim(SQLCODE)||',')>0 THEN /*6501625*/
599: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, sqlerrm);
600: RETURN FALSE;
601: ELSE
602: -- no need to log the error message twice, hence commenting.
603: -- The following error will be logged in the place from where create_snap is called.

Line 604: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, SQLERRM);

600: RETURN FALSE;
601: ELSE
602: -- no need to log the error message twice, hence commenting.
603: -- The following error will be logged in the place from where create_snap is called.
604: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, SQLERRM);
605: RAISE_APPLICATION_ERROR(-20001, 'Snapshot Creation on '|| p_table||' failed : ' || sqlerrm);
606: END IF;
607:
608: END CREATE_SNAP ; --Snapshot

Line 627: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Index '||p_object||' succesfully created...');

623: statement_type => AD_DDL.CREATE_INDEX,
624: statement => p_sql_stmt,
625: object_name => p_object);
626:
627: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Index '||p_object||' succesfully created...');
628:
629: EXCEPTION
630: WHEN OTHERS THEN
631: IF SQLCODE IN (-01408) THEN

Line 639: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, SQLERRM);

635: SQLCODE IN (-00955) THEN
636: /*Index already exists*/
637: NULL;
638: ELSE
639: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, SQLERRM);
640: raise_application_error(-20001, 'Index Creation failed: ' || sqlerrm);
641: END IF;
642:
643: END CREATE_INDEX; --Index

Line 662: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Index '||p_index||' succesfully dropped...');

658: statement_type => AD_DDL.DROP_INDEX,
659: statement => p_sql_stmt,
660: object_name => p_table);
661:
662: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Index '||p_index||' succesfully dropped...');
663:
664: EXCEPTION
665: WHEN OTHERS THEN
666: IF SQLCODE IN (-01418) THEN

Line 668: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Index ' ||p_index||' does not exist...');

664: EXCEPTION
665: WHEN OTHERS THEN
666: IF SQLCODE IN (-01418) THEN
667: /*Index does not exist */
668: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Index ' ||p_index||' does not exist...');
669: ELSE
670: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, SQLERRM);
671: raise_application_error(-20001, 'Dropping Index failed: ' || sqlerrm);
672: END IF;

Line 670: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, SQLERRM);

666: IF SQLCODE IN (-01418) THEN
667: /*Index does not exist */
668: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Index ' ||p_index||' does not exist...');
669: ELSE
670: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, SQLERRM);
671: raise_application_error(-20001, 'Dropping Index failed: ' || sqlerrm);
672: END IF;
673: END DROP_INDEX; --Index
674:

Line 723: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, SQLERRM);

719: RETURN lv_schema;
720:
721: EXCEPTION
722: WHEN OTHERS THEN
723: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, SQLERRM);
724: raise_application_error(-20001, 'Error getting the Schema : ' || sqlerrm);
725: END GET_SCHEMA_NAME;
726:
727:

Line 945: l_count := MSC_UTIL.g_dbmessage.count;

941: PROCEDURE init_dbmessage
942: is
943: l_count number;
944: begin
945: l_count := MSC_UTIL.g_dbmessage.count;
946: if nvl(l_count,0) > 0 then
947: MSC_UTIL.g_dbmessage.delete;
948: end if;
949: End init_dbmessage;

Line 947: MSC_UTIL.g_dbmessage.delete;

943: l_count number;
944: begin
945: l_count := MSC_UTIL.g_dbmessage.count;
946: if nvl(l_count,0) > 0 then
947: MSC_UTIL.g_dbmessage.delete;
948: end if;
949: End init_dbmessage;
950:
951:

Line 958: l_count := MSC_UTIL.g_dbmessage.count;

954: P_Program_unit in varchar2 default null )
955: is
956: l_count number ;
957: begin
958: l_count := MSC_UTIL.g_dbmessage.count;
959: MSC_UTIL.g_dbmessage(nvl(l_count , 0) + 1).msg_no := nvl(l_count , 0) + 1 ;
960: MSC_UTIL.g_dbmessage(nvl(l_count , 0) + 1).msg_desc := p_msg ;
961: MSC_UTIL.g_dbmessage(nvl(l_count , 0) + 1).package_name := p_Package_name ;
962: MSC_UTIL.g_dbmessage(nvl(l_count , 0) + 1).program_unit := P_Program_unit ;

Line 959: MSC_UTIL.g_dbmessage(nvl(l_count , 0) + 1).msg_no := nvl(l_count , 0) + 1 ;

955: is
956: l_count number ;
957: begin
958: l_count := MSC_UTIL.g_dbmessage.count;
959: MSC_UTIL.g_dbmessage(nvl(l_count , 0) + 1).msg_no := nvl(l_count , 0) + 1 ;
960: MSC_UTIL.g_dbmessage(nvl(l_count , 0) + 1).msg_desc := p_msg ;
961: MSC_UTIL.g_dbmessage(nvl(l_count , 0) + 1).package_name := p_Package_name ;
962: MSC_UTIL.g_dbmessage(nvl(l_count , 0) + 1).program_unit := P_Program_unit ;
963: End set_dbmessage;

Line 960: MSC_UTIL.g_dbmessage(nvl(l_count , 0) + 1).msg_desc := p_msg ;

956: l_count number ;
957: begin
958: l_count := MSC_UTIL.g_dbmessage.count;
959: MSC_UTIL.g_dbmessage(nvl(l_count , 0) + 1).msg_no := nvl(l_count , 0) + 1 ;
960: MSC_UTIL.g_dbmessage(nvl(l_count , 0) + 1).msg_desc := p_msg ;
961: MSC_UTIL.g_dbmessage(nvl(l_count , 0) + 1).package_name := p_Package_name ;
962: MSC_UTIL.g_dbmessage(nvl(l_count , 0) + 1).program_unit := P_Program_unit ;
963: End set_dbmessage;
964:

Line 961: MSC_UTIL.g_dbmessage(nvl(l_count , 0) + 1).package_name := p_Package_name ;

957: begin
958: l_count := MSC_UTIL.g_dbmessage.count;
959: MSC_UTIL.g_dbmessage(nvl(l_count , 0) + 1).msg_no := nvl(l_count , 0) + 1 ;
960: MSC_UTIL.g_dbmessage(nvl(l_count , 0) + 1).msg_desc := p_msg ;
961: MSC_UTIL.g_dbmessage(nvl(l_count , 0) + 1).package_name := p_Package_name ;
962: MSC_UTIL.g_dbmessage(nvl(l_count , 0) + 1).program_unit := P_Program_unit ;
963: End set_dbmessage;
964:
965: FUNCTION get_dbmessage return

Line 962: MSC_UTIL.g_dbmessage(nvl(l_count , 0) + 1).program_unit := P_Program_unit ;

958: l_count := MSC_UTIL.g_dbmessage.count;
959: MSC_UTIL.g_dbmessage(nvl(l_count , 0) + 1).msg_no := nvl(l_count , 0) + 1 ;
960: MSC_UTIL.g_dbmessage(nvl(l_count , 0) + 1).msg_desc := p_msg ;
961: MSC_UTIL.g_dbmessage(nvl(l_count , 0) + 1).package_name := p_Package_name ;
962: MSC_UTIL.g_dbmessage(nvl(l_count , 0) + 1).program_unit := P_Program_unit ;
963: End set_dbmessage;
964:
965: FUNCTION get_dbmessage return
966: DbMessageTabType

Line 969: return(MSC_UTIL.g_dbmessage);

965: FUNCTION get_dbmessage return
966: DbMessageTabType
967: is
968: begin
969: return(MSC_UTIL.g_dbmessage);
970: end get_dbmessage;
971:
972: /*-----------------------------------------------------------------------------
973: Function : MSC_NUMVAL

Line 1094: MSC_UTIL.v_in_org_str := msc_cl_pull.get_org_str(pinstance_id,2);

1090: END;
1091:
1092: ------ set v_in_org_str and v_in_all_org_str----------
1093:
1094: MSC_UTIL.v_in_org_str := msc_cl_pull.get_org_str(pinstance_id,2);
1095: MSC_UTIL.v_in_all_org_str := msc_cl_pull.get_org_str(pinstance_id,3);
1096:
1097: IF MSC_UTIL.G_COLLECT_SRP_DATA = 'Y' THEN
1098: SELECT APPS_VER

Line 1095: MSC_UTIL.v_in_all_org_str := msc_cl_pull.get_org_str(pinstance_id,3);

1091:
1092: ------ set v_in_org_str and v_in_all_org_str----------
1093:
1094: MSC_UTIL.v_in_org_str := msc_cl_pull.get_org_str(pinstance_id,2);
1095: MSC_UTIL.v_in_all_org_str := msc_cl_pull.get_org_str(pinstance_id,3);
1096:
1097: IF MSC_UTIL.G_COLLECT_SRP_DATA = 'Y' THEN
1098: SELECT APPS_VER
1099: INTO v_apps_ver

Line 1097: IF MSC_UTIL.G_COLLECT_SRP_DATA = 'Y' THEN

1093:
1094: MSC_UTIL.v_in_org_str := msc_cl_pull.get_org_str(pinstance_id,2);
1095: MSC_UTIL.v_in_all_org_str := msc_cl_pull.get_org_str(pinstance_id,3);
1096:
1097: IF MSC_UTIL.G_COLLECT_SRP_DATA = 'Y' THEN
1098: SELECT APPS_VER
1099: INTO v_apps_ver
1100: FROM MSC_APPS_INSTANCES
1101: WHERE INSTANCE_ID= pINSTANCE_ID;

Line 1103: IF (v_apps_ver<> -1 AND v_apps_ver < MSC_UTIL.G_APPS115) THEN --bug#5684183 (bcaru)

1099: INTO v_apps_ver
1100: FROM MSC_APPS_INSTANCES
1101: WHERE INSTANCE_ID= pINSTANCE_ID;
1102:
1103: IF (v_apps_ver<> -1 AND v_apps_ver < MSC_UTIL.G_APPS115) THEN --bug#5684183 (bcaru)
1104: MSC_UTIL.G_COLLECT_SRP_DATA := 'N' ; --SRP not supported for version < 12.1
1105: LOG_MSG(G_LVL_FATAL_ERR,'v115 SRP data is not collected because of wrong source version...');
1106: ELSE
1107: MSC_CL_PULL.GET_DEPOT_ORG_STRINGS(pINSTANCE_ID); -- For Bug 5909379

Line 1104: MSC_UTIL.G_COLLECT_SRP_DATA := 'N' ; --SRP not supported for version < 12.1

1100: FROM MSC_APPS_INSTANCES
1101: WHERE INSTANCE_ID= pINSTANCE_ID;
1102:
1103: IF (v_apps_ver<> -1 AND v_apps_ver < MSC_UTIL.G_APPS115) THEN --bug#5684183 (bcaru)
1104: MSC_UTIL.G_COLLECT_SRP_DATA := 'N' ; --SRP not supported for version < 12.1
1105: LOG_MSG(G_LVL_FATAL_ERR,'v115 SRP data is not collected because of wrong source version...');
1106: ELSE
1107: MSC_CL_PULL.GET_DEPOT_ORG_STRINGS(pINSTANCE_ID); -- For Bug 5909379
1108: END IF;

Line 1168: p_package_name,MSC_UTIL.G_APPS_SCHEMA;

1164: and status =''VALID''
1165: ';
1166: Execute immediate lv_sql_str into lv_exists
1167: USING
1168: p_package_name,MSC_UTIL.G_APPS_SCHEMA;
1169:
1170: EXCEPTION WHEN no_data_found THEN
1171: RAISE_APPLICATION_ERROR(-20056,'Package name does not exists or is Invalid');
1172: END;

Line 1256: for i in (SELECT mview_name,msc_util.GET_SCHEMA_NAME(erp_product_code) mview_owner

1252: PROCEDURE DROP_WRONGSCHEMA_MVIEWS IS
1253: lv_sql varchar2(1000);
1254: lv_Nologging_tblsp varchar2(30);
1255: begin
1256: for i in (SELECT mview_name,msc_util.GET_SCHEMA_NAME(erp_product_code) mview_owner
1257: FROM msc_coll_snapshots_v
1258: WHERE mview_name <> 'ALL SNAPSHOTS')
1259: loop
1260: BEGIN

Line 1333: RAISE_APPLICATION_ERROR(-20001,'MSC_UTIL:Error while initilizing Global Variables for Source Schema names: ' || SQLERRM);

1329: end ;
1330:
1331: EXCEPTION
1332: WHEN OTHERS THEN
1333: RAISE_APPLICATION_ERROR(-20001,'MSC_UTIL:Error while initilizing Global Variables for Source Schema names: ' || SQLERRM);
1334: END MSC_UTIL;

Line 1334: END MSC_UTIL;

1330:
1331: EXCEPTION
1332: WHEN OTHERS THEN
1333: RAISE_APPLICATION_ERROR(-20001,'MSC_UTIL:Error while initilizing Global Variables for Source Schema names: ' || SQLERRM);
1334: END MSC_UTIL;