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.FND_ADG_UTILITY dependencies on FND_ADG_EXCEPTION

Line 71: fnd_adg_exception.raise_error(fnd_adg_exception.C_UTLERR_INVALID_DB_RELEASE);

67: begin
68:
69: if ( not is_standby_access_supported )
70: then
71: fnd_adg_exception.raise_error(fnd_adg_exception.C_UTLERR_INVALID_DB_RELEASE);
72: end if;
73:
74: end;
75:

Line 87: fnd_adg_exception.raise_error(fnd_adg_exception.C_UTLERR_INVALID_CONNECT_TYPE);

83: when C_CONNECT_STANDBY_TO_PRIMARY then return;
84: when C_CONNECT_PRIMARY_TO_STANDBY then return;
85: when C_CONNECT_TO_SIMULATED_STANDBY then return;
86: else
87: fnd_adg_exception.raise_error(fnd_adg_exception.C_UTLERR_INVALID_CONNECT_TYPE);
88: end case;
89:
90: end;
91:

Line 100: fnd_adg_exception.raise_error(fnd_adg_exception.C_UTLERR_STANDBY_NULL);

96: begin
97:
98: if ( p_standby_number is null )
99: then
100: fnd_adg_exception.raise_error(fnd_adg_exception.C_UTLERR_STANDBY_NULL);
101: end if;
102:
103: if ( p_standby_number < 1 or p_standby_number > C_MAX_STANDBY_SYSTEMS )
104: then

Line 105: fnd_adg_exception.raise_error(fnd_adg_exception.C_UTLERR_STANDBY_OUT_OF_RANGE);

101: end if;
102:
103: if ( p_standby_number < 1 or p_standby_number > C_MAX_STANDBY_SYSTEMS )
104: then
105: fnd_adg_exception.raise_error(fnd_adg_exception.C_UTLERR_STANDBY_OUT_OF_RANGE);
106: end if;
107:
108: end;
109:

Line 407: fnd_adg_exception.raise_error(fnd_adg_exception.C_UTLERR_RPC_SYSTEM_OFF);

403: if ( p_state_on )
404: then
405: if ( not is_rpc_state(l_rec,C_RPC_SYSTEM_ENABLED) )
406: then
407: fnd_adg_exception.raise_error(fnd_adg_exception.C_UTLERR_RPC_SYSTEM_OFF);
408: end if;
409: else
410: if ( is_rpc_state(l_rec,C_RPC_SYSTEM_ENABLED) )
411: then

Line 412: fnd_adg_exception.raise_error(fnd_adg_exception.C_UTLERR_RPC_SYSTEM_ON);

408: end if;
409: else
410: if ( is_rpc_state(l_rec,C_RPC_SYSTEM_ENABLED) )
411: then
412: fnd_adg_exception.raise_error(fnd_adg_exception.C_UTLERR_RPC_SYSTEM_ON);
413: end if;
414: end if;
415:
416: /* Consistency check */

Line 425: fnd_adg_exception.raise_error

421: ( not l_compile_state and not p_state_on ) )
422: then
423: null;
424: else
425: fnd_adg_exception.raise_error
426: (fnd_adg_exception.C_UTLERR_DIRECTIVE_MISMATCH);
427: end if;
428:
429: end;

Line 426: (fnd_adg_exception.C_UTLERR_DIRECTIVE_MISMATCH);

422: then
423: null;
424: else
425: fnd_adg_exception.raise_error
426: (fnd_adg_exception.C_UTLERR_DIRECTIVE_MISMATCH);
427: end if;
428:
429: end;
430:

Line 444: fnd_adg_exception.raise_error(fnd_adg_exception.C_UTLERR_RPC_ADG_OFF);

440: if ( p_state_on )
441: then
442: if ( not is_rpc_state(l_rec,C_RPC_ADG_ENABLED ) )
443: then
444: fnd_adg_exception.raise_error(fnd_adg_exception.C_UTLERR_RPC_ADG_OFF);
445: end if;
446: else
447: if ( is_rpc_state(l_rec,C_RPC_ADG_ENABLED ) )
448: then

Line 449: fnd_adg_exception.raise_error(fnd_adg_exception.C_UTLERR_RPC_ADG_ON);

445: end if;
446: else
447: if ( is_rpc_state(l_rec,C_RPC_ADG_ENABLED ) )
448: then
449: fnd_adg_exception.raise_error(fnd_adg_exception.C_UTLERR_RPC_ADG_ON);
450: end if;
451: end if;
452:
453: /* Consistency check */

Line 460: fnd_adg_exception.raise_error(fnd_adg_exception.C_UTLERR_INCONSISTENT_ADGSTATE);

456: ( l_rec.enable_adg_support = 'N' and not p_state_on ) )
457: then
458: null;
459: else
460: fnd_adg_exception.raise_error(fnd_adg_exception.C_UTLERR_INCONSISTENT_ADGSTATE);
461: end if;
462:
463: end;
464:

Line 1042: fnd_adg_exception.raise_error

1038: ( l_match_link_connstr = upper(p_link_connstr) )
1039: )
1040: )
1041: then
1042: fnd_adg_exception.raise_error
1043: (fnd_adg_exception.C_UTLERR_CDATA_EXISTS,p_type_info);
1044: end if;
1045:
1046: end;

Line 1043: (fnd_adg_exception.C_UTLERR_CDATA_EXISTS,p_type_info);

1039: )
1040: )
1041: then
1042: fnd_adg_exception.raise_error
1043: (fnd_adg_exception.C_UTLERR_CDATA_EXISTS,p_type_info);
1044: end if;
1045:
1046: end;
1047:

Line 1184: fnd_adg_exception.raise_error

1180: begin
1181:
1182: if ( p_link_name is null )
1183: then
1184: fnd_adg_exception.raise_error
1185: (fnd_adg_exception.C_UTLERR_LINKCHK_NULL,p_type_info);
1186: end if;
1187:
1188: begin

Line 1185: (fnd_adg_exception.C_UTLERR_LINKCHK_NULL,p_type_info);

1181:
1182: if ( p_link_name is null )
1183: then
1184: fnd_adg_exception.raise_error
1185: (fnd_adg_exception.C_UTLERR_LINKCHK_NULL,p_type_info);
1186: end if;
1187:
1188: begin
1189:

Line 1196: fnd_adg_exception.raise_error

1192:
1193: exception
1194: when others then
1195:
1196: fnd_adg_exception.raise_error
1197: (fnd_adg_exception.C_UTLERR_LINKCHK_TNS,
1198: p_type_info||' '||sqlerrm);
1199:
1200: end;

Line 1197: (fnd_adg_exception.C_UTLERR_LINKCHK_TNS,

1193: exception
1194: when others then
1195:
1196: fnd_adg_exception.raise_error
1197: (fnd_adg_exception.C_UTLERR_LINKCHK_TNS,
1198: p_type_info||' '||sqlerrm);
1199:
1200: end;
1201:

Line 1227: fnd_adg_exception.raise_error

1223:
1224: if ( l_sid = l_rpc_sid and
1225: l_serial = l_rpc_serial )
1226: then
1227: fnd_adg_exception.raise_error
1228: (fnd_adg_exception.C_UTLERR_LINKCHK_LOOPBACK,
1229: p_type_info);
1230: end if;
1231:

Line 1228: (fnd_adg_exception.C_UTLERR_LINKCHK_LOOPBACK,

1224: if ( l_sid = l_rpc_sid and
1225: l_serial = l_rpc_serial )
1226: then
1227: fnd_adg_exception.raise_error
1228: (fnd_adg_exception.C_UTLERR_LINKCHK_LOOPBACK,
1229: p_type_info);
1230: end if;
1231:
1232: /* Make sure same dbid,name */

Line 1246: fnd_adg_exception.raise_error

1242:
1243: if ( l_dbid <> l_rpc_dbid or
1244: l_dbname <> l_rpc_dbname )
1245: then
1246: fnd_adg_exception.raise_error
1247: (fnd_adg_exception.C_UTLERR_LINKCHK_BAD_DBID,
1248: p_type_info||' This DBID/Name '|| l_dbid || '-' || l_dbname
1249: ||' RPC DBID/Name '|| l_rpc_dbid||'-'|| l_rpc_dbname
1250: );

Line 1247: (fnd_adg_exception.C_UTLERR_LINKCHK_BAD_DBID,

1243: if ( l_dbid <> l_rpc_dbid or
1244: l_dbname <> l_rpc_dbname )
1245: then
1246: fnd_adg_exception.raise_error
1247: (fnd_adg_exception.C_UTLERR_LINKCHK_BAD_DBID,
1248: p_type_info||' This DBID/Name '|| l_dbid || '-' || l_dbname
1249: ||' RPC DBID/Name '|| l_rpc_dbid||'-'|| l_rpc_dbname
1250: );
1251: end if;

Line 1263: fnd_adg_exception.raise_error

1259:
1260: if ( l_rpc_open_mode <> C_OPEN_READ_WRITE or
1261: l_rpc_database_role <> C_PRIMARY_ROLE )
1262: then
1263: fnd_adg_exception.raise_error
1264: (fnd_adg_exception.C_UTLERR_LINKCHK_BAD_DB_ROLE,
1265: p_type_info);
1266: end if;
1267:

Line 1264: (fnd_adg_exception.C_UTLERR_LINKCHK_BAD_DB_ROLE,

1260: if ( l_rpc_open_mode <> C_OPEN_READ_WRITE or
1261: l_rpc_database_role <> C_PRIMARY_ROLE )
1262: then
1263: fnd_adg_exception.raise_error
1264: (fnd_adg_exception.C_UTLERR_LINKCHK_BAD_DB_ROLE,
1265: p_type_info);
1266: end if;
1267:
1268: /* And just in case db is a clone with same dbid see if remote

Line 1294: fnd_adg_exception.raise_error

1290:
1291: if ( l_rpc_client_info is null or
1292: l_rpc_client_info <> l_sysguid )
1293: then
1294: fnd_adg_exception.raise_error
1295: (fnd_adg_exception.C_UTLERR_LINKCHK_RPC_IS_CLONE,
1296: p_type_info);
1297: end if;
1298:

Line 1295: (fnd_adg_exception.C_UTLERR_LINKCHK_RPC_IS_CLONE,

1291: if ( l_rpc_client_info is null or
1292: l_rpc_client_info <> l_sysguid )
1293: then
1294: fnd_adg_exception.raise_error
1295: (fnd_adg_exception.C_UTLERR_LINKCHK_RPC_IS_CLONE,
1296: p_type_info);
1297: end if;
1298:
1299: end if;

Line 1309: fnd_adg_exception.raise_error

1305:
1306: if ( l_rpc_open_mode <> C_OPEN_READ_ONLY or
1307: l_rpc_database_role <> C_STANDBY_ROLE )
1308: then
1309: fnd_adg_exception.raise_error
1310: (fnd_adg_exception.C_UTLERR_LINKCHK_BAD_STANDBY,
1311: p_type_info);
1312: end if;
1313:

Line 1310: (fnd_adg_exception.C_UTLERR_LINKCHK_BAD_STANDBY,

1306: if ( l_rpc_open_mode <> C_OPEN_READ_ONLY or
1307: l_rpc_database_role <> C_STANDBY_ROLE )
1308: then
1309: fnd_adg_exception.raise_error
1310: (fnd_adg_exception.C_UTLERR_LINKCHK_BAD_STANDBY,
1311: p_type_info);
1312: end if;
1313:
1314: end if;

Line 1323: fnd_adg_exception.raise_error

1319:
1320: if ( p_link_service is null or l_rpc_service_name is null or
1321: upper(p_link_service) <> upper(l_rpc_service_name) )
1322: then
1323: fnd_adg_exception.raise_error
1324: (fnd_adg_exception.C_UTLERR_LINKCHK_BAD_SERVICE,
1325: p_type_info);
1326: end if;
1327:

Line 1324: (fnd_adg_exception.C_UTLERR_LINKCHK_BAD_SERVICE,

1320: if ( p_link_service is null or l_rpc_service_name is null or
1321: upper(p_link_service) <> upper(l_rpc_service_name) )
1322: then
1323: fnd_adg_exception.raise_error
1324: (fnd_adg_exception.C_UTLERR_LINKCHK_BAD_SERVICE,
1325: p_type_info);
1326: end if;
1327:
1328: end if;

Line 1831: fnd_adg_exception.raise_error(fnd_adg_exception.C_UTLERR_REGISTER_LINK_IS_NULL);

1827: end if;
1828:
1829: if ( p_link_owner is null or p_link_name is null )
1830: then
1831: fnd_adg_exception.raise_error(fnd_adg_exception.C_UTLERR_REGISTER_LINK_IS_NULL);
1832: end if;
1833:
1834: if ( C_FORCE_PUBLIC_DBLINK and upper(p_link_owner) <> 'PUBLIC' )
1835: then

Line 1836: fnd_adg_exception.raise_error(fnd_adg_exception.C_UTLERR_OWNER_NOT_PUBLIC);

1832: end if;
1833:
1834: if ( C_FORCE_PUBLIC_DBLINK and upper(p_link_owner) <> 'PUBLIC' )
1835: then
1836: fnd_adg_exception.raise_error(fnd_adg_exception.C_UTLERR_OWNER_NOT_PUBLIC);
1837: end if;
1838:
1839: if ( p_link_connstr is not null and
1840: length(p_link_connstr) > C_MAX_CONNSTR_LENGTH )

Line 1842: fnd_adg_exception.raise_error(fnd_adg_exception.C_UTLERR_CONNSTR_TOO_LONG,

1838:
1839: if ( p_link_connstr is not null and
1840: length(p_link_connstr) > C_MAX_CONNSTR_LENGTH )
1841: then
1842: fnd_adg_exception.raise_error(fnd_adg_exception.C_UTLERR_CONNSTR_TOO_LONG,
1843: to_char(C_MAX_CONNSTR_LENGTH));
1844: end if;
1845:
1846: l_rec := get_adg_control;

Line 1855: fnd_adg_exception.raise_error

1851: l_rec.stndby_to_primary_link_name is not null and
1852: l_rec.stndby_to_primary_link_owner = upper(p_link_owner) and
1853: l_rec.stndby_to_primary_link_name = upper(p_link_name) )
1854: then
1855: fnd_adg_exception.raise_error
1856: (fnd_adg_exception.C_UTLERR_STDBY_P_LINKS_MATCH,p_link_name);
1857: end if;
1858: end if;
1859:

Line 1856: (fnd_adg_exception.C_UTLERR_STDBY_P_LINKS_MATCH,p_link_name);

1852: l_rec.stndby_to_primary_link_owner = upper(p_link_owner) and
1853: l_rec.stndby_to_primary_link_name = upper(p_link_name) )
1854: then
1855: fnd_adg_exception.raise_error
1856: (fnd_adg_exception.C_UTLERR_STDBY_P_LINKS_MATCH,p_link_name);
1857: end if;
1858: end if;
1859:
1860: check_connection_data(p_type,l_rec,p_standby_number,

Line 1870: fnd_adg_exception.raise_error

1866:
1867: if ( p_link_connstr is not null and
1868: f_rec.host <> upper(p_link_connstr) )
1869: then
1870: fnd_adg_exception.raise_error
1871: (fnd_adg_exception.C_UTLERR_LINK_HOST_MISMATCH,
1872: p_link_name );
1873: end if;
1874:

Line 1871: (fnd_adg_exception.C_UTLERR_LINK_HOST_MISMATCH,

1867: if ( p_link_connstr is not null and
1868: f_rec.host <> upper(p_link_connstr) )
1869: then
1870: fnd_adg_exception.raise_error
1871: (fnd_adg_exception.C_UTLERR_LINK_HOST_MISMATCH,
1872: p_link_name );
1873: end if;
1874:
1875: l_connstr1 := f_rec.host;

Line 1892: fnd_adg_exception.raise_error(fnd_adg_exception.C_UTLERR_REG_LINK_NOT_FOUND,

1888: '''' || upper(p_link_connstr) || '''' ;
1889:
1890: l_connstr1 := upper(p_link_connstr);
1891: else
1892: fnd_adg_exception.raise_error(fnd_adg_exception.C_UTLERR_REG_LINK_NOT_FOUND,
1893: p_link_name );
1894: end if;
1895: end if;
1896:

Line 2094: fnd_adg_exception.raise_error

2090: check_standby_number(p_standby_number);
2091:
2092: if ( not is_standby_manager_defined(p_req_class_app_id,p_req_class_id,false))
2093: then
2094: fnd_adg_exception.raise_error
2095: (fnd_adg_exception.C_UTLERR_REG_CM_NOT_DEFINED);
2096: end if;
2097:
2098: l_rec := get_and_lock_adg_control;

Line 2095: (fnd_adg_exception.C_UTLERR_REG_CM_NOT_DEFINED);

2091:
2092: if ( not is_standby_manager_defined(p_req_class_app_id,p_req_class_id,false))
2093: then
2094: fnd_adg_exception.raise_error
2095: (fnd_adg_exception.C_UTLERR_REG_CM_NOT_DEFINED);
2096: end if;
2097:
2098: l_rec := get_and_lock_adg_control;
2099:

Line 2160: fnd_adg_exception.raise_error

2156: and owner= 'SYS';
2157:
2158: if ( l_dir_obj_ok <> 1 )
2159: then
2160: fnd_adg_exception.raise_error
2161: (fnd_adg_exception.C_UTLERR_BAD_DIR_OBJECT);
2162: end if;
2163:
2164: l_rec.simulated_stndby_trc_dir_obj := p_trace_directory_obj;

Line 2161: (fnd_adg_exception.C_UTLERR_BAD_DIR_OBJECT);

2157:
2158: if ( l_dir_obj_ok <> 1 )
2159: then
2160: fnd_adg_exception.raise_error
2161: (fnd_adg_exception.C_UTLERR_BAD_DIR_OBJECT);
2162: end if;
2163:
2164: l_rec.simulated_stndby_trc_dir_obj := p_trace_directory_obj;
2165:

Line 2418: fnd_adg_exception.raise_error

2414: l_rec := get_adg_control;
2415:
2416: if ( not is_rpc_state(l_rec,C_RPC_SYSTEM_PREPARED) )
2417: then
2418: fnd_adg_exception.raise_error
2419: (fnd_adg_exception.C_UTLERR_RPC_SYSTEM_NOT_PREPED);
2420: end if;
2421:
2422: -- Check that RPC packages are using adg_compile_directive.

Line 2419: (fnd_adg_exception.C_UTLERR_RPC_SYSTEM_NOT_PREPED);

2415:
2416: if ( not is_rpc_state(l_rec,C_RPC_SYSTEM_PREPARED) )
2417: then
2418: fnd_adg_exception.raise_error
2419: (fnd_adg_exception.C_UTLERR_RPC_SYSTEM_NOT_PREPED);
2420: end if;
2421:
2422: -- Check that RPC packages are using adg_compile_directive.
2423: -- Best guess pre-enable that packages are the correct version.

Line 2435: fnd_adg_exception.raise_error

2431: l_rec := get_adg_control;
2432:
2433: if ( not yn_to_boolean(l_rec.stndby_to_primary_link_valid) )
2434: then
2435: fnd_adg_exception.raise_error
2436: (fnd_adg_exception.C_UTLERR_RPC_SYSTEM_LINK_BAD);
2437: end if;
2438:
2439: fnd_adg_object.build_all_synonyms;

Line 2436: (fnd_adg_exception.C_UTLERR_RPC_SYSTEM_LINK_BAD);

2432:
2433: if ( not yn_to_boolean(l_rec.stndby_to_primary_link_valid) )
2434: then
2435: fnd_adg_exception.raise_error
2436: (fnd_adg_exception.C_UTLERR_RPC_SYSTEM_LINK_BAD);
2437: end if;
2438:
2439: fnd_adg_object.build_all_synonyms;
2440:

Line 2520: fnd_adg_exception.raise_error

2516: l_rec := get_adg_control;
2517:
2518: if ( not is_rpc_state(l_rec,C_RPC_SYSTEM_PREPARED) )
2519: then
2520: fnd_adg_exception.raise_error
2521: (fnd_adg_exception.C_UTLERR_RPC_SYSTEM_NOT_PREPED);
2522: end if;
2523:
2524: fnd_adg_object.compile_rpc_dependents;

Line 2521: (fnd_adg_exception.C_UTLERR_RPC_SYSTEM_NOT_PREPED);

2517:
2518: if ( not is_rpc_state(l_rec,C_RPC_SYSTEM_PREPARED) )
2519: then
2520: fnd_adg_exception.raise_error
2521: (fnd_adg_exception.C_UTLERR_RPC_SYSTEM_NOT_PREPED);
2522: end if;
2523:
2524: fnd_adg_object.compile_rpc_dependents;
2525: