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.AHL_COMPLETIONS_PVT dependencies on FND_LOG

Line 2082: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2078: CLOSE c_wo_actual_date;
2079:
2080: END IF;
2081:
2082: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2083: THEN
2084: fnd_log.string(
2085: FND_LOG.LEVEL_STATEMENT,
2086: 'ahl.plsql.AHL_COMPLETIONS_PVT.get_cp_counters',

Line 2084: fnd_log.string(

2080: END IF;
2081:
2082: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2083: THEN
2084: fnd_log.string(
2085: FND_LOG.LEVEL_STATEMENT,
2086: 'ahl.plsql.AHL_COMPLETIONS_PVT.get_cp_counters',
2087: 'l_wo_actual_date in get_cp_counters -> ' || TO_CHAR(l_wo_actual_date, 'DD-MON-YYYY HH24:MI:SS')
2088: );

Line 2085: FND_LOG.LEVEL_STATEMENT,

2081:
2082: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2083: THEN
2084: fnd_log.string(
2085: FND_LOG.LEVEL_STATEMENT,
2086: 'ahl.plsql.AHL_COMPLETIONS_PVT.get_cp_counters',
2087: 'l_wo_actual_date in get_cp_counters -> ' || TO_CHAR(l_wo_actual_date, 'DD-MON-YYYY HH24:MI:SS')
2088: );
2089: END IF;

Line 2231: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2227: -- Bug # 6750836 -- end
2228:
2229: BEGIN
2230:
2231: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2232: THEN
2233: fnd_log.string(
2234: FND_LOG.LEVEL_STATEMENT,
2235: 'ahl.plsql.AHL_COMPLETIONS_PVT.get_reset_counters',

Line 2233: fnd_log.string(

2229: BEGIN
2230:
2231: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2232: THEN
2233: fnd_log.string(
2234: FND_LOG.LEVEL_STATEMENT,
2235: 'ahl.plsql.AHL_COMPLETIONS_PVT.get_reset_counters',
2236: 'p_actual_date in get_reset_counters -> ' || TO_CHAR(p_actual_date, 'DD-MON-YYYY HH24:MI:SS')
2237: );

Line 2234: FND_LOG.LEVEL_STATEMENT,

2230:
2231: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2232: THEN
2233: fnd_log.string(
2234: FND_LOG.LEVEL_STATEMENT,
2235: 'ahl.plsql.AHL_COMPLETIONS_PVT.get_reset_counters',
2236: 'p_actual_date in get_reset_counters -> ' || TO_CHAR(p_actual_date, 'DD-MON-YYYY HH24:MI:SS')
2237: );
2238: END IF;

Line 2274: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2270: OPEN get_current_readings(ctr_cursor.counter_id);
2271: FETCH get_current_readings INTO l_cur_ct_reading;
2272: CLOSE get_current_readings;
2273:
2274: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2275: THEN
2276:
2277: fnd_log.string(
2278: FND_LOG.LEVEL_STATEMENT,

Line 2277: fnd_log.string(

2273:
2274: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2275: THEN
2276:
2277: fnd_log.string(
2278: FND_LOG.LEVEL_STATEMENT,
2279: 'ahl.plsql.AHL_COMPLETIONS_PVT.get_reset_counters',
2280: 'counter with id.. -> ' || ctr_cursor.counter_id
2281: ||', l_actual_ct_reading ->' ||l_actual_ct_reading

Line 2278: FND_LOG.LEVEL_STATEMENT,

2274: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2275: THEN
2276:
2277: fnd_log.string(
2278: FND_LOG.LEVEL_STATEMENT,
2279: 'ahl.plsql.AHL_COMPLETIONS_PVT.get_reset_counters',
2280: 'counter with id.. -> ' || ctr_cursor.counter_id
2281: ||', l_actual_ct_reading ->' ||l_actual_ct_reading
2282: ||', l_cur_ct_reading ->' ||l_cur_ct_reading

Line 2289: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2285: END IF;
2286:
2287: IF l_actual_ct_reading = l_cur_ct_reading THEN
2288:
2289: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2290: THEN
2291: fnd_log.string(
2292: FND_LOG.LEVEL_STATEMENT,
2293: 'ahl.plsql.AHL_COMPLETIONS_PVT.get_reset_counters',

Line 2291: fnd_log.string(

2287: IF l_actual_ct_reading = l_cur_ct_reading THEN
2288:
2289: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2290: THEN
2291: fnd_log.string(
2292: FND_LOG.LEVEL_STATEMENT,
2293: 'ahl.plsql.AHL_COMPLETIONS_PVT.get_reset_counters',
2294: 'Resetting counter with id.. -> ' || ctr_cursor.counter_id
2295: );

Line 2292: FND_LOG.LEVEL_STATEMENT,

2288:
2289: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2290: THEN
2291: fnd_log.string(
2292: FND_LOG.LEVEL_STATEMENT,
2293: 'ahl.plsql.AHL_COMPLETIONS_PVT.get_reset_counters',
2294: 'Resetting counter with id.. -> ' || ctr_cursor.counter_id
2295: );
2296: fnd_log.string(

Line 2296: fnd_log.string(

2292: FND_LOG.LEVEL_STATEMENT,
2293: 'ahl.plsql.AHL_COMPLETIONS_PVT.get_reset_counters',
2294: 'Resetting counter with id.. -> ' || ctr_cursor.counter_id
2295: );
2296: fnd_log.string(
2297: FND_LOG.LEVEL_STATEMENT,
2298: 'ahl.plsql.AHL_COMPLETIONS_PVT.get_reset_counters',
2299: 'counter with id.. -> ' || ctr_cursor.counter_id ||', l_actual_ct_reading ->' ||l_actual_ct_reading
2300: );

Line 2297: FND_LOG.LEVEL_STATEMENT,

2293: 'ahl.plsql.AHL_COMPLETIONS_PVT.get_reset_counters',
2294: 'Resetting counter with id.. -> ' || ctr_cursor.counter_id
2295: );
2296: fnd_log.string(
2297: FND_LOG.LEVEL_STATEMENT,
2298: 'ahl.plsql.AHL_COMPLETIONS_PVT.get_reset_counters',
2299: 'counter with id.. -> ' || ctr_cursor.counter_id ||', l_actual_ct_reading ->' ||l_actual_ct_reading
2300: );
2301: END IF;

Line 2544: l_DEBUG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2540:
2541: l_msg_count NUMBER;
2542: l_msg_data VARCHAR2(2000);
2543:
2544: l_DEBUG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2545: l_DEBUG_PROC NUMBER := FND_LOG.LEVEL_PROCEDURE;
2546: l_DEBUG_STMT NUMBER := FND_LOG.LEVEL_STATEMENT;
2547:
2548: BEGIN

Line 2545: l_DEBUG_PROC NUMBER := FND_LOG.LEVEL_PROCEDURE;

2541: l_msg_count NUMBER;
2542: l_msg_data VARCHAR2(2000);
2543:
2544: l_DEBUG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2545: l_DEBUG_PROC NUMBER := FND_LOG.LEVEL_PROCEDURE;
2546: l_DEBUG_STMT NUMBER := FND_LOG.LEVEL_STATEMENT;
2547:
2548: BEGIN
2549:

Line 2546: l_DEBUG_STMT NUMBER := FND_LOG.LEVEL_STATEMENT;

2542: l_msg_data VARCHAR2(2000);
2543:
2544: l_DEBUG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2545: l_DEBUG_PROC NUMBER := FND_LOG.LEVEL_PROCEDURE;
2546: l_DEBUG_STMT NUMBER := FND_LOG.LEVEL_STATEMENT;
2547:
2548: BEGIN
2549:
2550:

Line 2552: fnd_log.string(l_DEBUG_PROC, 'ahl.plsql.AHL_PRD_WORKORDER_PVT.delete_serial_reservations.begin',

2548: BEGIN
2549:
2550:
2551: IF ( l_DEBUG_PROC >= l_DEBUG_LEVEL) THEN
2552: fnd_log.string(l_DEBUG_PROC, 'ahl.plsql.AHL_PRD_WORKORDER_PVT.delete_serial_reservations.begin',
2553: 'At the start of procedure for workorder_id:' || p_workorder_id);
2554: END IF;
2555:
2556: -- Initialize return status.

Line 2575: fnd_log.string(l_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WORKORDER_PVT.delete_serial_reservations',

2571: p_scheduled_material_id => get_scheduled_mater_rec.scheduled_material_id );
2572:
2573: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
2574: IF (l_DEBUG_STMT >= l_DEBUG_LEVEL) THEN
2575: fnd_log.string(l_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WORKORDER_PVT.delete_serial_reservations',
2576: 'AHL_RSV_RESERVATIONS_PVT.Delete_Reservation failed for schedule material ID: '
2577: || get_scheduled_mater_rec.scheduled_material_id);
2578: END IF; -- x_return_status
2579:

Line 4192: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

4188: --
4189: -- As per the issue # 2 in bug # 4626717 the master workorder has to be completed once
4190: -- the associated UE is signed off.Putting this code here because this is the logical end
4191: -- of mr signoff and before parent mr check starts.
4192: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4193: fnd_log.string
4194: (
4195: fnd_log.level_statement,
4196: 'ahl.plsql.AHL_PRD_COMPLETIONS_PVT.complete_mr_instance',

Line 4193: fnd_log.string

4189: -- As per the issue # 2 in bug # 4626717 the master workorder has to be completed once
4190: -- the associated UE is signed off.Putting this code here because this is the logical end
4191: -- of mr signoff and before parent mr check starts.
4192: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4193: fnd_log.string
4194: (
4195: fnd_log.level_statement,
4196: 'ahl.plsql.AHL_PRD_COMPLETIONS_PVT.complete_mr_instance',
4197: 'p_x_mr_rec.unit_effectivity_id : ' || p_x_mr_rec.unit_effectivity_id

Line 4195: fnd_log.level_statement,

4191: -- of mr signoff and before parent mr check starts.
4192: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4193: fnd_log.string
4194: (
4195: fnd_log.level_statement,
4196: 'ahl.plsql.AHL_PRD_COMPLETIONS_PVT.complete_mr_instance',
4197: 'p_x_mr_rec.unit_effectivity_id : ' || p_x_mr_rec.unit_effectivity_id
4198: );
4199: END IF;

Line 4207: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

4203: p_workorder_id => null,
4204: p_ue_id => p_x_mr_rec.unit_effectivity_id
4205: );
4206:
4207: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4208: fnd_log.string
4209: (
4210: fnd_log.level_statement,
4211: 'ahl.plsql.AHL_PRD_COMPLETIONS_PVT.complete_mr_instance',

Line 4208: fnd_log.string

4204: p_ue_id => p_x_mr_rec.unit_effectivity_id
4205: );
4206:
4207: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4208: fnd_log.string
4209: (
4210: fnd_log.level_statement,
4211: 'ahl.plsql.AHL_PRD_COMPLETIONS_PVT.complete_mr_instance',
4212: 'return status after calling complete_master_wo: ' || l_mwo_return_status

Line 4210: fnd_log.level_statement,

4206:
4207: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4208: fnd_log.string
4209: (
4210: fnd_log.level_statement,
4211: 'ahl.plsql.AHL_PRD_COMPLETIONS_PVT.complete_mr_instance',
4212: 'return status after calling complete_master_wo: ' || l_mwo_return_status
4213: );
4214: END IF;