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 2249: if (pa_debug.acquire_user_lock('FCLOCK:'||to_char(p_org_version_id)) = 0)

2245: delete from pa_cc_tp_schedule_line_lkp;
2246:
2247: ------- Acquire a lock before processing ----------------
2248:
2249: if (pa_debug.acquire_user_lock('FCLOCK:'||to_char(p_org_version_id)) = 0)
2250: and (pa_debug.acquire_user_lock('ACLOCK:'||to_char(p_org_version_id)) = 0) then
2251:
2252: --dbms_output.put_line('acquired fclock and aclock');
2253:

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

2246:
2247: ------- Acquire a lock before processing ----------------
2248:
2249: if (pa_debug.acquire_user_lock('FCLOCK:'||to_char(p_org_version_id)) = 0)
2250: and (pa_debug.acquire_user_lock('ACLOCK:'||to_char(p_org_version_id)) = 0) then
2251:
2252: --dbms_output.put_line('acquired fclock and aclock');
2253:
2254: for imp_rec in ( select org_id, start_organization_id

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

2319:
2320: END LOOP; ------ end of imp loop
2321:
2322: ------------- Release the Lock --------------
2323: if (pa_debug.release_user_lock('FCLOCK:'||to_char(p_org_version_id)) = 0)
2324: and (pa_debug.release_user_lock('ACLOCK:'||to_char(p_org_version_id)) = 0) then
2325: --dbms_output.put_line('org version '||p_org_version_id ||' is lock released');
2326: --r_msg('Releasing the lock on project ...');
2327: null;

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

2320: END LOOP; ------ end of imp loop
2321:
2322: ------------- Release the Lock --------------
2323: if (pa_debug.release_user_lock('FCLOCK:'||to_char(p_org_version_id)) = 0)
2324: and (pa_debug.release_user_lock('ACLOCK:'||to_char(p_org_version_id)) = 0) then
2325: --dbms_output.put_line('org version '||p_org_version_id ||' is lock released');
2326: --r_msg('Releasing the lock on project ...');
2327: null;
2328: end if;

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

2338: x_err_stack := old_stack;
2339:
2340: EXCEPTION
2341: when others then
2342: v_success_flag := pa_debug.release_user_lock('FCLOCK:'||to_char(p_org_version_id));
2343: v_success_flag := pa_debug.release_user_lock('ACLOCK:'||to_char(p_org_version_id));
2344: x_err_code := SQLCODE;
2345: x_err_stage := SQLERRM;
2346: --r_msg('exception raised in outer'||x_err_code||x_err_stage);

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

2339:
2340: EXCEPTION
2341: when others then
2342: v_success_flag := pa_debug.release_user_lock('FCLOCK:'||to_char(p_org_version_id));
2343: v_success_flag := pa_debug.release_user_lock('ACLOCK:'||to_char(p_org_version_id));
2344: x_err_code := SQLCODE;
2345: x_err_stage := SQLERRM;
2346: --r_msg('exception raised in outer'||x_err_code||x_err_stage);
2347: return;

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

2359: l_exist VARCHAR2(1):= null;
2360:
2361: BEGIN
2362:
2363: pa_debug.init_err_stack ('pa_org_utils.Check_Org_In_OrgHierarchy');
2364:
2365: select 'X' into l_exist
2366: from pa_org_hierarchy_denorm
2367: where parent_organization_id = p_organization_id

Line 2373: pa_debug.reset_err_stack;

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

Line 2383: p_procedure_name => pa_debug.g_err_stack );

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

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

2395: l_exist VARCHAR2(1):= null;
2396:
2397: BEGIN
2398:
2399: pa_debug.init_err_stack ('pa_org_utils.Check_Org_Type');
2400:
2401: select 'X' into l_exist
2402: from pa_org_hierarchy_denorm
2403: where parent_organization_id = p_organization_id

Line 2408: pa_debug.reset_err_stack;

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

Line 2422: p_procedure_name => pa_debug.g_err_stack );

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

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

2435: l_exist VARCHAR2(1):= null;
2436:
2437: BEGIN
2438:
2439: pa_debug.init_err_stack ('pa_org_utils.Check_OrgHierarchy_Type');
2440:
2441: select 'X' into l_exist
2442: from pa_org_hierarchy_denorm
2443: where org_hierarchy_version_id = p_org_structure_version_id

Line 2448: pa_debug.reset_err_stack;

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

Line 2462: p_procedure_name => pa_debug.g_err_stack );

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

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

2584: delete from pa_cc_tp_schedule_line_lkp;
2585:
2586: ------- Acquire a lock before processing ----------------
2587:
2588: IF (pa_debug.acquire_user_lock('FCLOCK:'||to_char(p_org_version_id)) = 0) AND
2589: (pa_debug.acquire_user_lock('ACLOCK:'||to_char(p_org_version_id)) = 0) THEN
2590:
2591: /*
2592: mano_msg('p_org_version_id = ' || p_org_version_id );

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

2585:
2586: ------- Acquire a lock before processing ----------------
2587:
2588: IF (pa_debug.acquire_user_lock('FCLOCK:'||to_char(p_org_version_id)) = 0) AND
2589: (pa_debug.acquire_user_lock('ACLOCK:'||to_char(p_org_version_id)) = 0) THEN
2590:
2591: /*
2592: mano_msg('p_org_version_id = ' || p_org_version_id );
2593: mano_msg('p_organization_id_parent = ' || p_organization_id_parent );

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

2728:
2729: --mano_msg('inserted ' || sql%rowcount || ' rows');
2730:
2731: ------------- Release the Lock --------------
2732: IF (pa_debug.release_user_lock('FCLOCK:'||to_char(p_org_version_id)) = 0) AND
2733: (pa_debug.release_user_lock('ACLOCK:'||to_char(p_org_version_id)) = 0) THEN
2734: NULL;
2735: END IF;
2736:

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

2729: --mano_msg('inserted ' || sql%rowcount || ' rows');
2730:
2731: ------------- Release the Lock --------------
2732: IF (pa_debug.release_user_lock('FCLOCK:'||to_char(p_org_version_id)) = 0) AND
2733: (pa_debug.release_user_lock('ACLOCK:'||to_char(p_org_version_id)) = 0) THEN
2734: NULL;
2735: END IF;
2736:
2737:

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

2744: x_err_stack := old_stack;
2745:
2746: EXCEPTION
2747: WHEN OTHERS THEN
2748: v_success_flag := pa_debug.release_user_lock('FCLOCK:'||to_char(p_org_version_id));
2749: v_success_flag := pa_debug.release_user_lock('ACLOCK:'||to_char(p_org_version_id));
2750: x_err_code := SQLCODE;
2751: x_err_stage := SQLERRM;
2752: --r_msg('exception raised in outer'||x_err_code||x_err_stage);

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

2745:
2746: EXCEPTION
2747: WHEN OTHERS THEN
2748: v_success_flag := pa_debug.release_user_lock('FCLOCK:'||to_char(p_org_version_id));
2749: v_success_flag := pa_debug.release_user_lock('ACLOCK:'||to_char(p_org_version_id));
2750: x_err_code := SQLCODE;
2751: x_err_stage := SQLERRM;
2752: --r_msg('exception raised in outer'||x_err_code||x_err_stage);
2753: RETURN;