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 DBMS_UTILITY

Line 1491: IF instr(DBMS_UTILITY.FORMAT_ERROR_STACK ,'ORA-01434') > 0 OR

1487: EXECUTE IMMEDIATE lv_sql;
1488:
1489: EXCEPTION
1490: WHEN OTHERS THEN
1491: IF instr(DBMS_UTILITY.FORMAT_ERROR_STACK ,'ORA-01434') > 0 OR
1492: instr(DBMS_UTILITY.FORMAT_ERROR_STACK ,'ORA-01432') > 0 THEN
1493: NULL; --private/public synonym to be dropped does not exist
1494: ELSE
1495: RAISE_APPLICATION_ERROR(-20001,'Error while executing:-'||lv_sql || ': ' || SQLERRM);

Line 1492: instr(DBMS_UTILITY.FORMAT_ERROR_STACK ,'ORA-01432') > 0 THEN

1488:
1489: EXCEPTION
1490: WHEN OTHERS THEN
1491: IF instr(DBMS_UTILITY.FORMAT_ERROR_STACK ,'ORA-01434') > 0 OR
1492: instr(DBMS_UTILITY.FORMAT_ERROR_STACK ,'ORA-01432') > 0 THEN
1493: NULL; --private/public synonym to be dropped does not exist
1494: ELSE
1495: RAISE_APPLICATION_ERROR(-20001,'Error while executing:-'||lv_sql || ': ' || SQLERRM);
1496: END IF;

Line 1516: IF instr(DBMS_UTILITY.FORMAT_ERROR_STACK ,'ORA-04080') > 0 THEN

1512: EXECUTE IMMEDIATE lv_sql;
1513:
1514: EXCEPTION
1515: WHEN OTHERS THEN
1516: IF instr(DBMS_UTILITY.FORMAT_ERROR_STACK ,'ORA-04080') > 0 THEN
1517: NULL;
1518: ELSE
1519: RAISE_APPLICATION_ERROR(-20001,'Error while executing:-'||lv_sql || ': ' || SQLERRM);
1520: END IF;

Line 1541: IF instr(DBMS_UTILITY.FORMAT_ERROR_STACK ,'ORA-12003') > 0 THEN --materialized view does not exist

1537: lv_sql:='DROP MATERIALIZED VIEW '||I.mview_owner||'.'||i.mview_name;
1538: EXECUTE IMMEDIATE lv_sql;
1539: EXCEPTION
1540: WHEN OTHERS THEN
1541: IF instr(DBMS_UTILITY.FORMAT_ERROR_STACK ,'ORA-12003') > 0 THEN --materialized view does not exist
1542: NULL;--materialized view does not exist
1543: ELSE
1544: RAISE_APPLICATION_ERROR(-20001,'Error while executing:-'||lv_sql || ': ' || SQLERRM);
1545: END IF;

Line 1582: IF instr(DBMS_UTILITY.FORMAT_ERROR_STACK ,'ORA-12003') > 0 THEN --materialized view does not exist

1578: lv_sql:='DROP MATERIALIZED VIEW '||v_deprecatedMVSchemaList(i)||'.'||v_deprecatedMVList(i);
1579: EXECUTE IMMEDIATE lv_sql;
1580: EXCEPTION
1581: WHEN OTHERS THEN
1582: IF instr(DBMS_UTILITY.FORMAT_ERROR_STACK ,'ORA-12003') > 0 THEN --materialized view does not exist
1583: NULL;--materialized view does not exist
1584: ELSE
1585: RAISE_APPLICATION_ERROR(-20001,'Error while executing:-'||lv_sql || ': ' || SQLERRM);
1586: END IF;