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.MRP_CL_REFRESH_SNAPSHOT dependencies on DBMS_UTILITY

Line 1822: DBMS_UTILITY.DB_VERSION (lv_db_version,lv_db_cmpt_version);

1818: g_INSTANCE_CODE := pINSTANCE_CODE;
1819: g_A2M_DBLINK := pA2M_DBLINK;
1820:
1821: BEGIN
1822: DBMS_UTILITY.DB_VERSION (lv_db_version,lv_db_cmpt_version);
1823: v_database_version := to_number(substr(lv_db_version,1,instrb(lv_db_version,'.')-1) );
1824: EXCEPTION
1825: WHEN OTHERS THEN
1826: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error getting DataBase version : ' || SQLERRM);

Line 1966: MSC_UTIL.G_ERROR_STACK:= DBMS_UTILITY.FORMAT_ERROR_STACK;

1962: RETCODE := G_SUCCESS;
1963:
1964: EXCEPTION
1965: WHEN OTHERS THEN
1966: MSC_UTIL.G_ERROR_STACK:= DBMS_UTILITY.FORMAT_ERROR_STACK;
1967: IF instr(MSC_UTIL.G_ERROR_STACK ,'ORA-1578') > 0
1968: OR instr(MSC_UTIL.G_ERROR_STACK ,'ORA-36040') > 0 THEN
1969: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error in refresh snapshot program : ' || MSC_UTIL.G_ERROR_STACK);
1970: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Please Launch CP "DROP Collection SnapShots" with option "ALL SNAPSHOTS"');

Line 2354: DBMS_UTILITY.DB_VERSION (lv_db_version,lv_db_cmpt_version);

2350: lv_snap_str VARCHAR2(150) := MSC_UTIL.G_APPS_SCHEMA||'.'||lv_snapshot_name;
2351: BEGIN
2352:
2353: BEGIN
2354: DBMS_UTILITY.DB_VERSION (lv_db_version,lv_db_cmpt_version);
2355: v_database_version := to_number(substr(lv_db_version,1,instrb(lv_db_version,'.')-1) );
2356: EXCEPTION
2357: WHEN OTHERS THEN
2358: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error getting DataBase version : ' || SQLERRM);

Line 2414: MSC_UTIL.G_ERROR_STACK := DBMS_UTILITY.FORMAT_ERROR_STACK;

2410: parallelism => pDEGREE);
2411: end if;
2412: EXCEPTION
2413: WHEN OTHERS THEN
2414: MSC_UTIL.G_ERROR_STACK := DBMS_UTILITY.FORMAT_ERROR_STACK;
2415: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error in refresh snapshot program : ' || MSC_UTIL.G_ERROR_STACK);
2416: IF instr(MSC_UTIL.G_ERROR_STACK ,'ORA-1578') > 0
2417: OR instr(MSC_UTIL.G_ERROR_STACK ,'ORA-36040') > 0 THEN
2418: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error in refresh snapshot program : ' || MSC_UTIL.G_ERROR_STACK);