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

Line 232: x_return_status := FND_API.G_RET_STS_SUCCESS;

228: --
229: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
230: --
231: BEGIN
232: x_return_status := FND_API.G_RET_STS_SUCCESS;
233:
234: SELECT nvl(multi_org_flag, 'N')
235: INTO l_multi_org_flag
236: FROM fnd_product_groups;

Line 250: RAISE FND_API.G_EXC_ERROR;

246: c1.responsibility_id,
247: c1.APPLICATION_ID);
248: IF l_org_id is NULL THEN
249: x_error_message := 'Profile option - MO: Operating Unit - is not set for this responsibility '|| to_char(c1.responsibility_id);
250: RAISE FND_API.G_EXC_ERROR;
251: END IF;
252:
253: END IF;
254: IF l_org_id = to_char(p_org_id) OR l_multi_org_flag = 'N' THEN

Line 279: RAISE FND_API.G_EXC_ERROR;

275: END IF;
276:
277: IF l_org_count = 0 THEN
278: x_error_message := 'There are no responsibilities defined for the user/Org '|| to_char(p_user_id)|| '/'|| to_char(p_org_id);
279: RAISE FND_API.G_EXC_ERROR;
280:
281: END IF;
282:
283: IF l_org_count > 1 AND

Line 286: RAISE FND_API.G_EXC_ERROR;

282:
283: IF l_org_count > 1 AND
284: l_res_count = 0 THEN
285: x_error_message := 'There are multiple responsibilities defined for the user/org '|| to_char(p_user_id)|| '/'|| to_char(p_org_id) || ' But the profile option OE_RESP_FOR_WF_UPGRADE is not set for any of those';
286: RAISE FND_API.G_EXC_ERROR;
287: END IF;
288:
289: IF l_org_count > 1 AND
290: l_res_count > 1 THEN

Line 292: RAISE FND_API.G_EXC_ERROR;

288:
289: IF l_org_count > 1 AND
290: l_res_count > 1 THEN
291: x_error_message := 'There are multiple responsibilities defined for the user/org_id '|| to_char(p_user_id) ||'/' ||to_char(p_org_id) || ' But the profile option OE_RESP_FOR_WF_UPGRADE is set for more than one responsibilites';
292: RAISE FND_API.G_EXC_ERROR;
293: END IF;
294:
295: EXCEPTION
296:

Line 297: WHEN FND_API.G_EXC_ERROR THEN

293: END IF;
294:
295: EXCEPTION
296:
297: WHEN FND_API.G_EXC_ERROR THEN
298:
299: x_return_status := FND_API.G_RET_STS_ERROR;
300: x_responsibility_id := NULL;
301: x_application_id := NULL;

Line 299: x_return_status := FND_API.G_RET_STS_ERROR;

295: EXCEPTION
296:
297: WHEN FND_API.G_EXC_ERROR THEN
298:
299: x_return_status := FND_API.G_RET_STS_ERROR;
300: x_responsibility_id := NULL;
301: x_application_id := NULL;
302:
303: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 303: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

299: x_return_status := FND_API.G_RET_STS_ERROR;
300: x_responsibility_id := NULL;
301: x_application_id := NULL;
302:
303: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
304:
305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
306: x_responsibility_id := NULL;
307: x_application_id := NULL;

Line 305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

301: x_application_id := NULL;
302:
303: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
304:
305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
306: x_responsibility_id := NULL;
307: x_application_id := NULL;
308:
309: WHEN OTHERS THEN

Line 311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

307: x_application_id := NULL;
308:
309: WHEN OTHERS THEN
310:
311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
312: x_responsibility_id := NULL;
313: x_application_id := NULL;
314:
315: END Get_responsibility_application;