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 1279: MSC_UTIL.G_ERROR_STACK:= DBMS_UTILITY.FORMAT_ERROR_STACK;

1275: EXCEPTION
1276: WHEN OTHERS THEN
1277:
1278: lv_elapsed_mins := CEIL((SYSDATE- lv_task_start_time)*14400.0)/10;
1279: MSC_UTIL.G_ERROR_STACK:= DBMS_UTILITY.FORMAT_ERROR_STACK;
1280:
1281: IF instr(MSC_UTIL.G_ERROR_STACK ,'ORA-12034') > 0
1282: OR instr(MSC_UTIL.G_ERROR_STACK ,'ORA-12052') > 0
1283: OR instr(MSC_UTIL.G_ERROR_STACK ,'ORA-12057') > 0 THEN --bug 8420469

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

1937: g_INSTANCE_CODE := pINSTANCE_CODE;
1938: g_A2M_DBLINK := pA2M_DBLINK;
1939:
1940: BEGIN
1941: DBMS_UTILITY.DB_VERSION (lv_db_version,lv_db_cmpt_version);
1942: v_database_version := to_number(substr(lv_db_version,1,instrb(lv_db_version,'.')-1) );
1943: EXCEPTION
1944: WHEN OTHERS THEN
1945: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error getting DataBase version : ' || SQLERRM);

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

2195: RETCODE := G_SUCCESS;
2196:
2197: EXCEPTION
2198: WHEN OTHERS THEN
2199: MSC_UTIL.G_ERROR_STACK:= DBMS_UTILITY.FORMAT_ERROR_STACK;
2200: IF instr(MSC_UTIL.G_ERROR_STACK ,'ORA-1578') > 0
2201: OR instr(MSC_UTIL.G_ERROR_STACK ,'ORA-36040') > 0 THEN
2202: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error in refresh snapshot program : ' || MSC_UTIL.G_ERROR_STACK);
2203: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Please Launch CP "DROP Collection SnapShots" with option "ALL SNAPSHOTS"');

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

2723: lv_snap_str VARCHAR2(150) := MSC_UTIL.G_APPS_SCHEMA||'.'||lv_snapshot_name;
2724: BEGIN
2725:
2726: BEGIN
2727: DBMS_UTILITY.DB_VERSION (lv_db_version,lv_db_cmpt_version);
2728: v_database_version := to_number(substr(lv_db_version,1,instrb(lv_db_version,'.')-1) );
2729:
2730: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'Database Version: ' || lv_db_version);
2731:

Line 2840: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, DBMS_UTILITY.FORMAT_ERROR_STACK );

2836: */
2837: EXCEPTION
2838: WHEN OTHERS THEN
2839: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error_Stack...' );
2840: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, DBMS_UTILITY.FORMAT_ERROR_STACK );
2841: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error_Backtrace...' );
2842: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, DBMS_UTILITY.FORMAT_ERROR_BACKTRACE );
2843: --MSC_UTIL.G_ERROR_STACK := DBMS_UTILITY.FORMAT_ERROR_STACK;
2844: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error in refresh snapshot program : ' || MSC_UTIL.G_ERROR_STACK);

Line 2842: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, DBMS_UTILITY.FORMAT_ERROR_BACKTRACE );

2838: WHEN OTHERS THEN
2839: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error_Stack...' );
2840: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, DBMS_UTILITY.FORMAT_ERROR_STACK );
2841: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error_Backtrace...' );
2842: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, DBMS_UTILITY.FORMAT_ERROR_BACKTRACE );
2843: --MSC_UTIL.G_ERROR_STACK := DBMS_UTILITY.FORMAT_ERROR_STACK;
2844: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error in refresh snapshot program : ' || MSC_UTIL.G_ERROR_STACK);
2845: IF instr(MSC_UTIL.G_ERROR_STACK ,'ORA-1578') > 0
2846: OR instr(MSC_UTIL.G_ERROR_STACK ,'ORA-36040') > 0 THEN

Line 2843: --MSC_UTIL.G_ERROR_STACK := DBMS_UTILITY.FORMAT_ERROR_STACK;

2839: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error_Stack...' );
2840: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, DBMS_UTILITY.FORMAT_ERROR_STACK );
2841: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error_Backtrace...' );
2842: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, DBMS_UTILITY.FORMAT_ERROR_BACKTRACE );
2843: --MSC_UTIL.G_ERROR_STACK := DBMS_UTILITY.FORMAT_ERROR_STACK;
2844: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error in refresh snapshot program : ' || MSC_UTIL.G_ERROR_STACK);
2845: IF instr(MSC_UTIL.G_ERROR_STACK ,'ORA-1578') > 0
2846: OR instr(MSC_UTIL.G_ERROR_STACK ,'ORA-36040') > 0 THEN
2847: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error in refresh snapshot program : ' || MSC_UTIL.G_ERROR_STACK);