APPS.MSC_UTIL dependencies on DBMS_UTILITY

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

1214: EXECUTE IMMEDIATE lv_sql;
1215:
1216: EXCEPTION
1217: WHEN OTHERS THEN
1218: IF instr(DBMS_UTILITY.FORMAT_ERROR_STACK ,'ORA-01434') > 0 OR
1219: instr(DBMS_UTILITY.FORMAT_ERROR_STACK ,'ORA-01432') > 0 THEN
1220: NULL; --private/public synonym to be dropped does not exist
1221: ELSE
1222: RAISE_APPLICATION_ERROR(-20001,'Error while executing:-'||lv_sql || ': ' || SQLERRM);

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

1215:
1216: EXCEPTION
1217: WHEN OTHERS THEN
1218: IF instr(DBMS_UTILITY.FORMAT_ERROR_STACK ,'ORA-01434') > 0 OR
1219: instr(DBMS_UTILITY.FORMAT_ERROR_STACK ,'ORA-01432') > 0 THEN
1220: NULL; --private/public synonym to be dropped does not exist
1221: ELSE
1222: RAISE_APPLICATION_ERROR(-20001,'Error while executing:-'||lv_sql || ': ' || SQLERRM);
1223: END IF;

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

1239: EXECUTE IMMEDIATE lv_sql;
1240:
1241: EXCEPTION
1242: WHEN OTHERS THEN
1243: IF instr(DBMS_UTILITY.FORMAT_ERROR_STACK ,'ORA-04080') > 0 THEN
1244: NULL;
1245: ELSE
1246: RAISE_APPLICATION_ERROR(-20001,'Error while executing:-'||lv_sql || ': ' || SQLERRM);
1247: END IF;

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

1261: lv_sql:='DROP MATERIALIZED VIEW '||I.mview_owner||'.'||i.mview_name;
1262: EXECUTE IMMEDIATE lv_sql;
1263: EXCEPTION
1264: WHEN OTHERS THEN
1265: IF instr(DBMS_UTILITY.FORMAT_ERROR_STACK ,'ORA-12003') > 0 THEN --materialized view does not exist
1266: NULL;--materialized view does not exist
1267: ELSE
1268: RAISE_APPLICATION_ERROR(-20001,'Error while executing:-'||lv_sql || ': ' || SQLERRM);
1269: END IF;