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

Line 2333: --x_return_status := FND_API.G_SET_RET_STS_ERROR;

2329:
2330: --------------------------------------------
2331:
2332: else -- not acquired the lock so exit and set the return status to error
2333: --x_return_status := FND_API.G_SET_RET_STS_ERROR;
2334: x_err_stage := 'Unable to Acqurie Lock on FORCASTING';
2335: --dbms_output.put_line('org version '||p_org_version_id ||' is locked');
2336: end if;
2337:

Line 2372: x_return_status := FND_API.G_RET_STS_SUCCESS;

2368: and org_hierarchy_version_id = p_org_structure_version_id
2369: and pa_org_use_type = p_org_structure_type
2370: and rownum = 1;
2371:
2372: x_return_status := FND_API.G_RET_STS_SUCCESS;
2373: pa_debug.reset_err_stack;
2374:
2375: EXCEPTION
2376: WHEN NO_DATA_FOUND THEN

Line 2377: x_return_status := FND_API.G_RET_STS_ERROR;

2373: pa_debug.reset_err_stack;
2374:
2375: EXCEPTION
2376: WHEN NO_DATA_FOUND THEN
2377: x_return_status := FND_API.G_RET_STS_ERROR;
2378: x_error_message_code := 'PA_ORG_NOT_IN_ORGHIER';
2379:
2380: WHEN OTHERS THEN
2381: fnd_msg_pub.add_exc_msg

Line 2384: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

2380: WHEN OTHERS THEN
2381: fnd_msg_pub.add_exc_msg
2382: (p_pkg_name => 'PA_ORG_UTILS',
2383: p_procedure_name => pa_debug.g_err_stack );
2384: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
2385: RAISE;
2386: END Check_Org_In_OrgHierarchy;
2387:
2388: PROCEDURE Check_Org_Type(

Line 2407: x_return_status := FND_API.G_RET_STS_SUCCESS;

2403: where parent_organization_id = p_organization_id
2404: and pa_org_use_type = p_org_structure_type
2405: and rownum = 1;
2406:
2407: x_return_status := FND_API.G_RET_STS_SUCCESS;
2408: pa_debug.reset_err_stack;
2409:
2410: EXCEPTION
2411: WHEN NO_DATA_FOUND THEN

Line 2412: x_return_status := FND_API.G_RET_STS_ERROR;

2408: pa_debug.reset_err_stack;
2409:
2410: EXCEPTION
2411: WHEN NO_DATA_FOUND THEN
2412: x_return_status := FND_API.G_RET_STS_ERROR;
2413: IF p_org_structure_type = 'EXPENDITURES' THEN
2414: x_error_message_code := 'PA_NOT_EXP_ORG';
2415: ELSE
2416: x_error_message_code := 'PA_NOT_PROJ_ORG';

Line 2423: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

2419: WHEN OTHERS THEN
2420: fnd_msg_pub.add_exc_msg
2421: (p_pkg_name => 'PA_ORG_UTILS',
2422: p_procedure_name => pa_debug.g_err_stack );
2423: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
2424: RAISE;
2425: END Check_Org_Type;
2426:
2427:

Line 2447: x_return_status := FND_API.G_RET_STS_SUCCESS;

2443: where org_hierarchy_version_id = p_org_structure_version_id
2444: and pa_org_use_type = p_org_structure_type
2445: and rownum = 1;
2446:
2447: x_return_status := FND_API.G_RET_STS_SUCCESS;
2448: pa_debug.reset_err_stack;
2449:
2450: EXCEPTION
2451: WHEN NO_DATA_FOUND THEN

Line 2452: x_return_status := FND_API.G_RET_STS_ERROR;

2448: pa_debug.reset_err_stack;
2449:
2450: EXCEPTION
2451: WHEN NO_DATA_FOUND THEN
2452: x_return_status := FND_API.G_RET_STS_ERROR;
2453: IF p_org_structure_type = 'EXPENDITURES' THEN
2454: x_error_message_code := 'PA_NOT_EXP_ORGHIER';
2455: ELSE
2456: x_error_message_code := 'PA_NOT_PROJ_ORGHIER';

Line 2463: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

2459: WHEN OTHERS THEN
2460: fnd_msg_pub.add_exc_msg
2461: (p_pkg_name => 'PA_ORG_UTILS',
2462: p_procedure_name => pa_debug.g_err_stack );
2463: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
2464: RAISE;
2465: END Check_OrgHierarchy_Type;
2466:
2467:

Line 2493: x_return_status := FND_API.G_RET_STS_SUCCESS;

2489: v_org_version_id NUMBER;
2490: v_organization_id_parent NUMBER;
2491: v_organization_id_child NUMBER;
2492: BEGIN
2493: x_return_status := FND_API.G_RET_STS_SUCCESS;
2494: FOR i IN org_version LOOP
2495: v_org_version_id := i.version_id;
2496: v_organization_id_parent := i.start_org_id;
2497: v_organization_id_child := 1;

Line 2509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2505: ,x_err_stack => v_err_stack);
2506: END LOOP;
2507: EXCEPTION
2508: WHEN OTHERS THEN
2509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2510: v_err_code := SQLCODE;
2511: x_msg_data := SQLERRM;
2512: raise;
2513: END Populate_Org_Hier_Denorm;