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.IEO_SVR_UTIL_PVT dependencies on FND_API

Line 2196: IF NOT FND_API.Compatible_API_Call (l_api_version ,

2192:
2193: l_comp_def_id NUMBER;
2194:
2195: BEGIN
2196: IF NOT FND_API.Compatible_API_Call (l_api_version ,
2197: p_api_version ,
2198: l_api_name ,
2199: G_PKG_NAME )
2200: THEN

Line 2201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2197: p_api_version ,
2198: l_api_name ,
2199: G_PKG_NAME )
2200: THEN
2201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2202: END IF;
2203: -- Initialize message list if p_init_msg_list is set to TRUE.
2204: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2205: FND_MSG_PUB.initialize;

Line 2204: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2200: THEN
2201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2202: END IF;
2203: -- Initialize message list if p_init_msg_list is set to TRUE.
2204: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2205: FND_MSG_PUB.initialize;
2206: END IF;
2207: -- Initialize API return status to failure
2208: x_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 2208: x_return_status := FND_API.G_RET_STS_SUCCESS ;

2204: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2205: FND_MSG_PUB.initialize;
2206: END IF;
2207: -- Initialize API return status to failure
2208: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2209: x_msg_count := 0;
2210: x_msg_data := null;
2211: x_comp_id := -1;
2212: x_comp_name := null;

Line 2241: IF FND_API.To_Boolean( p_commit ) THEN

2237: || x_port
2238: || '/' ;
2239: x_url := x_base_url || x_comp_name;
2240:
2241: IF FND_API.To_Boolean( p_commit ) THEN
2242: COMMIT WORK;
2243: END IF;
2244:
2245: EXCEPTION

Line 2248: x_return_status := FND_API.G_RET_STS_ERROR ;

2244:
2245: EXCEPTION
2246: WHEN NO_DATA_FOUND then
2247: rollback;
2248: x_return_status := FND_API.G_RET_STS_ERROR ;
2249: x_msg_count := 1;
2250: x_err_num := SQLCODE;
2251: x_err_msg := SUBSTR(SQLERRM, 1, 100);
2252: x_msg_data := 'GET_SVR_CONNECT_INFO: IEO_EXC_ERROR'

Line 2256: WHEN FND_API.G_EXC_ERROR THEN

2252: x_msg_data := 'GET_SVR_CONNECT_INFO: IEO_EXC_ERROR'
2253: || ' ErrorCode = ' || x_err_num
2254: || ' ErrorMsg = ' || x_err_msg;
2255:
2256: WHEN FND_API.G_EXC_ERROR THEN
2257: rollback;
2258: x_return_status := FND_API.G_RET_STS_ERROR ;
2259: x_msg_count := 1;
2260: x_err_num := SQLCODE;

Line 2258: x_return_status := FND_API.G_RET_STS_ERROR ;

2254: || ' ErrorMsg = ' || x_err_msg;
2255:
2256: WHEN FND_API.G_EXC_ERROR THEN
2257: rollback;
2258: x_return_status := FND_API.G_RET_STS_ERROR ;
2259: x_msg_count := 1;
2260: x_err_num := SQLCODE;
2261: x_err_msg := SUBSTR(SQLERRM, 1, 100);
2262: x_msg_data := 'GET_SVR_CONNECT_INFO: IEO_EXC_ERROR'

Line 2267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2263: || ' ErrorCode = ' || x_err_num
2264: || ' ErrorMsg = ' || x_err_msg;
2265: --dbms_output.put_line(x_msg_data);
2266:
2267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2268: --dbms_output.put_line('Unexpected error');
2269: ROLLBACK;
2270: x_return_status := FND_API.G_RET_STS_ERROR ;
2271: x_msg_count := 1;

Line 2270: x_return_status := FND_API.G_RET_STS_ERROR ;

2266:
2267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2268: --dbms_output.put_line('Unexpected error');
2269: ROLLBACK;
2270: x_return_status := FND_API.G_RET_STS_ERROR ;
2271: x_msg_count := 1;
2272: x_err_num := SQLCODE;
2273: x_err_msg := SUBSTR(SQLERRM, 1, 100);
2274: x_msg_data := 'GET_SVR_CONNECT_INFO: IEO_UNEXPECTED_ERROR'

Line 2280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2276: || ' ErrorMsg = ' || x_err_msg;
2277: --dbms_output.put_line(x_msg_data);
2278: WHEN OTHERS THEN
2279: rollback;
2280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2281: x_msg_count := 1;
2282: x_err_num := SQLCODE;
2283: x_err_msg := SUBSTR(SQLERRM, 1, 100);
2284: x_msg_data := 'GET_SVR_CONNECT_INFO: IEO_OTHERS_ERROR'

Line 2318: IF NOT FND_API.Compatible_API_Call (l_api_version ,

2314: l_refresh_rate NUMBER;
2315: l_last_update_date DATE;
2316: l_sysdate DATE;
2317: BEGIN
2318: IF NOT FND_API.Compatible_API_Call (l_api_version ,
2319: p_api_version ,
2320: l_api_name ,
2321: G_PKG_NAME )
2322: THEN

Line 2323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2319: p_api_version ,
2320: l_api_name ,
2321: G_PKG_NAME )
2322: THEN
2323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2324: END IF;
2325: -- Initialize message list if p_init_msg_list is set to TRUE.
2326: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2327: FND_MSG_PUB.initialize;

Line 2326: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2322: THEN
2323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2324: END IF;
2325: -- Initialize message list if p_init_msg_list is set to TRUE.
2326: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2327: FND_MSG_PUB.initialize;
2328: END IF;
2329: -- Initialize API return status to failure
2330: x_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 2330: x_return_status := FND_API.G_RET_STS_SUCCESS ;

2326: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2327: FND_MSG_PUB.initialize;
2328: END IF;
2329: -- Initialize API return status to failure
2330: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2331: x_msg_count := 0;
2332: x_msg_data := null;
2333: x_is_server_up := FND_API.G_FALSE;
2334: x_server_status := -1;

Line 2333: x_is_server_up := FND_API.G_FALSE;

2329: -- Initialize API return status to failure
2330: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2331: x_msg_count := 0;
2332: x_msg_data := null;
2333: x_is_server_up := FND_API.G_FALSE;
2334: x_server_status := -1;
2335: x_server_name := null;
2336: x_server_group_name := null;
2337:

Line 2355: x_is_server_up := FND_API.G_TRUE;

2351: --dbms_output.put_line('diff= ' || to_char(l_sysdate - l_last_update_date));
2352:
2353: if (x_server_status >= 4) then
2354: if (((l_sysdate - l_last_update_date)*1440) <= l_refresh_rate) then
2355: x_is_server_up := FND_API.G_TRUE;
2356: end if;
2357: end if;
2358:
2359: select a.server_name, b.group_name into x_server_name, x_server_group_name

Line 2363: IF FND_API.To_Boolean( p_commit ) THEN

2359: select a.server_name, b.group_name into x_server_name, x_server_group_name
2360: from ieo_Svr_servers a, ieo_Svr_groups b
2361: where a.server_id = p_server_id and a.member_svr_group_id = b.server_group_id;
2362:
2363: IF FND_API.To_Boolean( p_commit ) THEN
2364: COMMIT WORK;
2365: END IF;
2366:
2367: EXCEPTION

Line 2370: x_return_status := FND_API.G_RET_STS_ERROR ;

2366:
2367: EXCEPTION
2368: WHEN NO_DATA_FOUND then
2369: rollback;
2370: x_return_status := FND_API.G_RET_STS_ERROR ;
2371: x_msg_count := 1;
2372: x_err_num := SQLCODE;
2373: x_err_msg := SUBSTR(SQLERRM, 1, 100);
2374: x_msg_data := 'IS_SERVER_UP: IEO_NO_DATA_FOUND_ERROR'

Line 2378: WHEN FND_API.G_EXC_ERROR THEN

2374: x_msg_data := 'IS_SERVER_UP: IEO_NO_DATA_FOUND_ERROR'
2375: || ' ErrorCode = ' || x_err_num
2376: || ' ErrorMsg = ' || x_err_msg;
2377:
2378: WHEN FND_API.G_EXC_ERROR THEN
2379: rollback;
2380: x_return_status := FND_API.G_RET_STS_ERROR ;
2381: x_msg_count := 1;
2382: x_err_num := SQLCODE;

Line 2380: x_return_status := FND_API.G_RET_STS_ERROR ;

2376: || ' ErrorMsg = ' || x_err_msg;
2377:
2378: WHEN FND_API.G_EXC_ERROR THEN
2379: rollback;
2380: x_return_status := FND_API.G_RET_STS_ERROR ;
2381: x_msg_count := 1;
2382: x_err_num := SQLCODE;
2383: x_err_msg := SUBSTR(SQLERRM, 1, 100);
2384: x_msg_data := 'IS_SERVER_UP: IEO_EXC_ERROR'

Line 2389: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2385: || ' ErrorCode = ' || x_err_num
2386: || ' ErrorMsg = ' || x_err_msg;
2387: --dbms_output.put_line(x_msg_data);
2388:
2389: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2390: --dbms_output.put_line('Unexpected error');
2391: ROLLBACK;
2392: x_return_status := FND_API.G_RET_STS_ERROR ;
2393: x_msg_count := 1;

Line 2392: x_return_status := FND_API.G_RET_STS_ERROR ;

2388:
2389: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2390: --dbms_output.put_line('Unexpected error');
2391: ROLLBACK;
2392: x_return_status := FND_API.G_RET_STS_ERROR ;
2393: x_msg_count := 1;
2394: x_err_num := SQLCODE;
2395: x_err_msg := SUBSTR(SQLERRM, 1, 100);
2396: x_msg_data := 'IS_SERVER_UP: IEO_UNEXPECTED_ERROR'

Line 2402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2398: || ' ErrorMsg = ' || x_err_msg;
2399: --dbms_output.put_line(x_msg_data);
2400: WHEN OTHERS THEN
2401: rollback;
2402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2403: x_msg_count := 1;
2404: x_err_num := SQLCODE;
2405: x_err_msg := SUBSTR(SQLERRM, 1, 100);
2406: x_msg_data := 'IS_SERVER_UP: IEO_OTHERS_ERROR'