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 PA_DEBUG

Line 2456: if (pa_debug.acquire_user_lock('FCLOCK:'||to_char(p_org_version_id)) = 0)

2452: delete from pa_cc_tp_schedule_line_lkp;
2453:
2454: ------- Acquire a lock before processing ----------------
2455:
2456: if (pa_debug.acquire_user_lock('FCLOCK:'||to_char(p_org_version_id)) = 0)
2457: and (pa_debug.acquire_user_lock('ACLOCK:'||to_char(p_org_version_id)) = 0) then
2458:
2459: --dbms_output.put_line('acquired fclock and aclock');
2460:

Line 2457: and (pa_debug.acquire_user_lock('ACLOCK:'||to_char(p_org_version_id)) = 0) then

2453:
2454: ------- Acquire a lock before processing ----------------
2455:
2456: if (pa_debug.acquire_user_lock('FCLOCK:'||to_char(p_org_version_id)) = 0)
2457: and (pa_debug.acquire_user_lock('ACLOCK:'||to_char(p_org_version_id)) = 0) then
2458:
2459: --dbms_output.put_line('acquired fclock and aclock');
2460:
2461: for imp_rec in ( select org_id, start_organization_id

Line 2530: if (pa_debug.release_user_lock('FCLOCK:'||to_char(p_org_version_id)) = 0)

2526:
2527: END LOOP; ------ end of imp loop
2528:
2529: ------------- Release the Lock --------------
2530: if (pa_debug.release_user_lock('FCLOCK:'||to_char(p_org_version_id)) = 0)
2531: and (pa_debug.release_user_lock('ACLOCK:'||to_char(p_org_version_id)) = 0) then
2532: --dbms_output.put_line('org version '||p_org_version_id ||' is lock released');
2533: --r_msg('Releasing the lock on project ...');
2534: null;

Line 2531: and (pa_debug.release_user_lock('ACLOCK:'||to_char(p_org_version_id)) = 0) then

2527: END LOOP; ------ end of imp loop
2528:
2529: ------------- Release the Lock --------------
2530: if (pa_debug.release_user_lock('FCLOCK:'||to_char(p_org_version_id)) = 0)
2531: and (pa_debug.release_user_lock('ACLOCK:'||to_char(p_org_version_id)) = 0) then
2532: --dbms_output.put_line('org version '||p_org_version_id ||' is lock released');
2533: --r_msg('Releasing the lock on project ...');
2534: null;
2535: end if;

Line 2549: v_success_flag := pa_debug.release_user_lock('FCLOCK:'||to_char(p_org_version_id));

2545: x_err_stack := old_stack;
2546:
2547: EXCEPTION
2548: when others then
2549: v_success_flag := pa_debug.release_user_lock('FCLOCK:'||to_char(p_org_version_id));
2550: v_success_flag := pa_debug.release_user_lock('ACLOCK:'||to_char(p_org_version_id));
2551: x_err_code := SQLCODE;
2552: x_err_stage := SQLERRM;
2553: --r_msg('exception raised in outer'||x_err_code||x_err_stage);

Line 2550: v_success_flag := pa_debug.release_user_lock('ACLOCK:'||to_char(p_org_version_id));

2546:
2547: EXCEPTION
2548: when others then
2549: v_success_flag := pa_debug.release_user_lock('FCLOCK:'||to_char(p_org_version_id));
2550: v_success_flag := pa_debug.release_user_lock('ACLOCK:'||to_char(p_org_version_id));
2551: x_err_code := SQLCODE;
2552: x_err_stage := SQLERRM;
2553: --r_msg('exception raised in outer'||x_err_code||x_err_stage);
2554: return;

Line 2570: pa_debug.init_err_stack ('pa_org_utils.Check_Org_In_OrgHierarchy');

2566: l_exist VARCHAR2(1):= null;
2567:
2568: BEGIN
2569:
2570: pa_debug.init_err_stack ('pa_org_utils.Check_Org_In_OrgHierarchy');
2571:
2572: select 'X' into l_exist
2573: from pa_org_hierarchy_denorm
2574: where parent_organization_id = p_organization_id

Line 2580: pa_debug.reset_err_stack;

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
2584: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2590: p_procedure_name => pa_debug.g_err_stack );

2586:
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:

Line 2606: pa_debug.init_err_stack ('pa_org_utils.Check_Org_Type');

2602: l_exist VARCHAR2(1):= null;
2603:
2604: BEGIN
2605:
2606: pa_debug.init_err_stack ('pa_org_utils.Check_Org_Type');
2607:
2608: select 'X' into l_exist
2609: from pa_org_hierarchy_denorm
2610: where parent_organization_id = p_organization_id

Line 2615: pa_debug.reset_err_stack;

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
2619: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2629: p_procedure_name => pa_debug.g_err_stack );

2625:
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:

Line 2646: pa_debug.init_err_stack ('pa_org_utils.Check_OrgHierarchy_Type');

2642: l_exist VARCHAR2(1):= null;
2643:
2644: BEGIN
2645:
2646: pa_debug.init_err_stack ('pa_org_utils.Check_OrgHierarchy_Type');
2647:
2648: select 'X' into l_exist
2649: from pa_org_hierarchy_denorm
2650: where org_hierarchy_version_id = p_org_structure_version_id

Line 2655: pa_debug.reset_err_stack;

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
2659: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2669: p_procedure_name => pa_debug.g_err_stack );

2665:
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:

Line 2795: IF (pa_debug.acquire_user_lock('FCLOCK:'||to_char(p_org_version_id)) = 0) AND

2791: delete from pa_cc_tp_schedule_line_lkp;
2792:
2793: ------- Acquire a lock before processing ----------------
2794:
2795: IF (pa_debug.acquire_user_lock('FCLOCK:'||to_char(p_org_version_id)) = 0) AND
2796: (pa_debug.acquire_user_lock('ACLOCK:'||to_char(p_org_version_id)) = 0) THEN
2797:
2798: /*
2799: mano_msg('p_org_version_id = ' || p_org_version_id );

Line 2796: (pa_debug.acquire_user_lock('ACLOCK:'||to_char(p_org_version_id)) = 0) THEN

2792:
2793: ------- Acquire a lock before processing ----------------
2794:
2795: IF (pa_debug.acquire_user_lock('FCLOCK:'||to_char(p_org_version_id)) = 0) AND
2796: (pa_debug.acquire_user_lock('ACLOCK:'||to_char(p_org_version_id)) = 0) THEN
2797:
2798: /*
2799: mano_msg('p_org_version_id = ' || p_org_version_id );
2800: mano_msg('p_organization_id_parent = ' || p_organization_id_parent );

Line 2939: IF (pa_debug.release_user_lock('FCLOCK:'||to_char(p_org_version_id)) = 0) AND

2935:
2936: --mano_msg('inserted ' || sql%rowcount || ' rows');
2937:
2938: ------------- Release the Lock --------------
2939: IF (pa_debug.release_user_lock('FCLOCK:'||to_char(p_org_version_id)) = 0) AND
2940: (pa_debug.release_user_lock('ACLOCK:'||to_char(p_org_version_id)) = 0) THEN
2941: NULL;
2942: END IF;
2943:

Line 2940: (pa_debug.release_user_lock('ACLOCK:'||to_char(p_org_version_id)) = 0) THEN

2936: --mano_msg('inserted ' || sql%rowcount || ' rows');
2937:
2938: ------------- Release the Lock --------------
2939: IF (pa_debug.release_user_lock('FCLOCK:'||to_char(p_org_version_id)) = 0) AND
2940: (pa_debug.release_user_lock('ACLOCK:'||to_char(p_org_version_id)) = 0) THEN
2941: NULL;
2942: END IF;
2943:
2944:

Line 2955: v_success_flag := pa_debug.release_user_lock('FCLOCK:'||to_char(p_org_version_id));

2951: x_err_stack := old_stack;
2952:
2953: EXCEPTION
2954: WHEN OTHERS THEN
2955: v_success_flag := pa_debug.release_user_lock('FCLOCK:'||to_char(p_org_version_id));
2956: v_success_flag := pa_debug.release_user_lock('ACLOCK:'||to_char(p_org_version_id));
2957: x_err_code := SQLCODE;
2958: x_err_stage := SQLERRM;
2959: --r_msg('exception raised in outer'||x_err_code||x_err_stage);

Line 2956: v_success_flag := pa_debug.release_user_lock('ACLOCK:'||to_char(p_org_version_id));

2952:
2953: EXCEPTION
2954: WHEN OTHERS THEN
2955: v_success_flag := pa_debug.release_user_lock('FCLOCK:'||to_char(p_org_version_id));
2956: v_success_flag := pa_debug.release_user_lock('ACLOCK:'||to_char(p_org_version_id));
2957: x_err_code := SQLCODE;
2958: x_err_stage := SQLERRM;
2959: --r_msg('exception raised in outer'||x_err_code||x_err_stage);
2960: RETURN;