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 2540: --x_return_status := FND_API.G_SET_RET_STS_ERROR;

2536:
2537: --------------------------------------------
2538:
2539: else -- not acquired the lock so exit and set the return status to error
2540: --x_return_status := FND_API.G_SET_RET_STS_ERROR;
2541: x_err_stage := 'Unable to Acqurie Lock on FORCASTING';
2542: --dbms_output.put_line('org version '||p_org_version_id ||' is locked');
2543: end if;
2544:

Line 2579: x_return_status := FND_API.G_RET_STS_SUCCESS;

2575: and org_hierarchy_version_id = p_org_structure_version_id
2576: and pa_org_use_type = p_org_structure_type
2577: and rownum = 1;
2578:
2579: x_return_status := FND_API.G_RET_STS_SUCCESS;
2580: pa_debug.reset_err_stack;
2581:
2582: EXCEPTION
2583: WHEN NO_DATA_FOUND THEN

Line 2584: x_return_status := FND_API.G_RET_STS_ERROR;

2580: pa_debug.reset_err_stack;
2581:
2582: EXCEPTION
2583: WHEN NO_DATA_FOUND THEN
2584: x_return_status := FND_API.G_RET_STS_ERROR;
2585: x_error_message_code := 'PA_ORG_NOT_IN_ORGHIER';
2586:
2587: WHEN OTHERS THEN
2588: fnd_msg_pub.add_exc_msg

Line 2591: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

2587: WHEN OTHERS THEN
2588: fnd_msg_pub.add_exc_msg
2589: (p_pkg_name => 'PA_ORG_UTILS',
2590: p_procedure_name => pa_debug.g_err_stack );
2591: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
2592: RAISE;
2593: END Check_Org_In_OrgHierarchy;
2594:
2595: PROCEDURE Check_Org_Type(

Line 2614: x_return_status := FND_API.G_RET_STS_SUCCESS;

2610: where parent_organization_id = p_organization_id
2611: and pa_org_use_type = p_org_structure_type
2612: and rownum = 1;
2613:
2614: x_return_status := FND_API.G_RET_STS_SUCCESS;
2615: pa_debug.reset_err_stack;
2616:
2617: EXCEPTION
2618: WHEN NO_DATA_FOUND THEN

Line 2619: x_return_status := FND_API.G_RET_STS_ERROR;

2615: pa_debug.reset_err_stack;
2616:
2617: EXCEPTION
2618: WHEN NO_DATA_FOUND THEN
2619: x_return_status := FND_API.G_RET_STS_ERROR;
2620: IF p_org_structure_type = 'EXPENDITURES' THEN
2621: x_error_message_code := 'PA_NOT_EXP_ORG';
2622: ELSE
2623: x_error_message_code := 'PA_NOT_PROJ_ORG';

Line 2630: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

2626: WHEN OTHERS THEN
2627: fnd_msg_pub.add_exc_msg
2628: (p_pkg_name => 'PA_ORG_UTILS',
2629: p_procedure_name => pa_debug.g_err_stack );
2630: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
2631: RAISE;
2632: END Check_Org_Type;
2633:
2634:

Line 2654: x_return_status := FND_API.G_RET_STS_SUCCESS;

2650: where org_hierarchy_version_id = p_org_structure_version_id
2651: and pa_org_use_type = p_org_structure_type
2652: and rownum = 1;
2653:
2654: x_return_status := FND_API.G_RET_STS_SUCCESS;
2655: pa_debug.reset_err_stack;
2656:
2657: EXCEPTION
2658: WHEN NO_DATA_FOUND THEN

Line 2659: x_return_status := FND_API.G_RET_STS_ERROR;

2655: pa_debug.reset_err_stack;
2656:
2657: EXCEPTION
2658: WHEN NO_DATA_FOUND THEN
2659: x_return_status := FND_API.G_RET_STS_ERROR;
2660: IF p_org_structure_type = 'EXPENDITURES' THEN
2661: x_error_message_code := 'PA_NOT_EXP_ORGHIER';
2662: ELSE
2663: x_error_message_code := 'PA_NOT_PROJ_ORGHIER';

Line 2670: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

2666: WHEN OTHERS THEN
2667: fnd_msg_pub.add_exc_msg
2668: (p_pkg_name => 'PA_ORG_UTILS',
2669: p_procedure_name => pa_debug.g_err_stack );
2670: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
2671: RAISE;
2672: END Check_OrgHierarchy_Type;
2673:
2674:

Line 2700: x_return_status := FND_API.G_RET_STS_SUCCESS;

2696: v_org_version_id NUMBER;
2697: v_organization_id_parent NUMBER;
2698: v_organization_id_child NUMBER;
2699: BEGIN
2700: x_return_status := FND_API.G_RET_STS_SUCCESS;
2701: FOR i IN org_version LOOP
2702: v_org_version_id := i.version_id;
2703: v_organization_id_parent := i.start_org_id;
2704: v_organization_id_child := 1;

Line 2716: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2712: ,x_err_stack => v_err_stack);
2713: END LOOP;
2714: EXCEPTION
2715: WHEN OTHERS THEN
2716: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2717: v_err_code := SQLCODE;
2718: x_msg_data := SQLERRM;
2719: raise;
2720: END Populate_Org_Hier_Denorm;