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.INL_SIMULATION_PVT dependencies on DBMS_LOCK

Line 1985: DBMS_LOCK.Allocate_Unique(lockname => l_lock_name,

1981: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1982: p_procedure_name => l_api_name,
1983: p_debug_info => 'Acquiring lock on: ' || l_lock_name);
1984:
1985: DBMS_LOCK.Allocate_Unique(lockname => l_lock_name,
1986: lockhandle => l_lock_handle);
1987:
1988: l_lock_status := DBMS_LOCK.Request(lockhandle => l_lock_handle,
1989: lockmode => dbms_lock.x_mode);

Line 1988: l_lock_status := DBMS_LOCK.Request(lockhandle => l_lock_handle,

1984:
1985: DBMS_LOCK.Allocate_Unique(lockname => l_lock_name,
1986: lockhandle => l_lock_handle);
1987:
1988: l_lock_status := DBMS_LOCK.Request(lockhandle => l_lock_handle,
1989: lockmode => dbms_lock.x_mode);
1990:
1991: IF l_lock_status = 0 THEN -- Successfully locked
1992: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

Line 1989: lockmode => dbms_lock.x_mode);

1985: DBMS_LOCK.Allocate_Unique(lockname => l_lock_name,
1986: lockhandle => l_lock_handle);
1987:
1988: l_lock_status := DBMS_LOCK.Request(lockhandle => l_lock_handle,
1989: lockmode => dbms_lock.x_mode);
1990:
1991: IF l_lock_status = 0 THEN -- Successfully locked
1992: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1993: p_procedure_name => l_api_name,

Line 2168: l_lock_status := DBMS_LOCK.Release(l_lock_handle);

2164: FND_MSG_PUB.Add;
2165: RAISE FND_API.G_EXC_ERROR;
2166: END IF;
2167: -- Release the lock
2168: l_lock_status := DBMS_LOCK.Release(l_lock_handle);
2169: l_lock_handle := NULL;
2170:
2171: -- Standard call to get message count and if count is 1, get message info.
2172: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

Line 2191: l_lock_status := DBMS_LOCK.Release(l_lock_handle);

2187: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
2188: p_count => x_msg_count,
2189: p_data => x_msg_data);
2190: IF l_lock_handle IS NOT NULL THEN
2191: l_lock_status := DBMS_LOCK.Release(l_lock_handle);
2192: END IF;
2193: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2194: -- Standard Unexpected Error Logging
2195: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

Line 2203: l_lock_status := DBMS_LOCK.Release(l_lock_handle);

2199: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
2200: p_count => x_msg_count,
2201: p_data => x_msg_data);
2202: IF l_lock_handle IS NOT NULL THEN
2203: l_lock_status := DBMS_LOCK.Release(l_lock_handle);
2204: END IF;
2205: WHEN OTHERS THEN
2206: -- Standard Unexpected Error Logging
2207: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

Line 2221: l_lock_status := DBMS_LOCK.Release(l_lock_handle);

2217: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
2218: p_count => x_msg_count,
2219: p_data => x_msg_data);
2220: IF l_lock_handle IS NOT NULL THEN
2221: l_lock_status := DBMS_LOCK.Release(l_lock_handle);
2222: END IF;
2223: END Copy_Simulation;
2224:
2225: -- API name : Create_Simulation

Line 2325: DBMS_LOCK.Allocate_Unique(lockname => l_lock_name,

2321: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
2322: p_procedure_name => l_api_name,
2323: p_debug_info => 'Acquiring lock on: ' || l_lock_name);
2324:
2325: DBMS_LOCK.Allocate_Unique(lockname => l_lock_name,
2326: lockhandle => l_lock_handle);
2327:
2328: l_lock_status := DBMS_LOCK.Request(lockhandle => l_lock_handle,
2329: lockmode => dbms_lock.x_mode);

Line 2328: l_lock_status := DBMS_LOCK.Request(lockhandle => l_lock_handle,

2324:
2325: DBMS_LOCK.Allocate_Unique(lockname => l_lock_name,
2326: lockhandle => l_lock_handle);
2327:
2328: l_lock_status := DBMS_LOCK.Request(lockhandle => l_lock_handle,
2329: lockmode => dbms_lock.x_mode);
2330:
2331: IF l_lock_status = 0 THEN -- Successfully locked
2332:

Line 2329: lockmode => dbms_lock.x_mode);

2325: DBMS_LOCK.Allocate_Unique(lockname => l_lock_name,
2326: lockhandle => l_lock_handle);
2327:
2328: l_lock_status := DBMS_LOCK.Request(lockhandle => l_lock_handle,
2329: lockmode => dbms_lock.x_mode);
2330:
2331: IF l_lock_status = 0 THEN -- Successfully locked
2332:
2333: SELECT NVL(MAX(sml.version_num),0) + 1

Line 2476: l_lock_status := DBMS_LOCK.Release(l_lock_handle);

2472: FND_MSG_PUB.Add;
2473: RAISE FND_API.G_EXC_ERROR;
2474: END IF;
2475: -- Release the lock
2476: l_lock_status := DBMS_LOCK.Release(l_lock_handle);
2477: l_lock_handle := NULL;
2478:
2479: -- Standard call to get message count and if count is 1, get message info.
2480: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

Line 2499: l_lock_status := DBMS_LOCK.Release(l_lock_handle);

2495: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
2496: p_count => x_msg_count,
2497: p_data => x_msg_data);
2498: IF l_lock_handle IS NOT NULL THEN
2499: l_lock_status := DBMS_LOCK.Release(l_lock_handle);
2500: END IF;
2501: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2502: -- Standard Unexpected Error Logging
2503: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

Line 2511: l_lock_status := DBMS_LOCK.Release(l_lock_handle);

2507: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
2508: p_count => x_msg_count,
2509: p_data => x_msg_data);
2510: IF l_lock_handle IS NOT NULL THEN
2511: l_lock_status := DBMS_LOCK.Release(l_lock_handle);
2512: END IF;
2513: WHEN OTHERS THEN
2514: -- Standard Unexpected Error Logging
2515: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

Line 2529: l_lock_status := DBMS_LOCK.Release(l_lock_handle);

2525: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
2526: p_count => x_msg_count,
2527: p_data => x_msg_data);
2528: IF l_lock_handle IS NOT NULL THEN
2529: l_lock_status := DBMS_LOCK.Release(l_lock_handle);
2530: END IF;
2531: END Create_Simulation;
2532:
2533: -- API name : Purge_Simulations