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 2160: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2156: CLOSE c_wo_actual_date;
2157:
2158: END IF;
2159:
2160: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2161: THEN
2162: fnd_log.string(
2163: FND_LOG.LEVEL_STATEMENT,
2164: 'ahl.plsql.AHL_COMPLETIONS_PVT.get_cp_counters',

Line 2162: fnd_log.string(

2158: END IF;
2159:
2160: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2161: THEN
2162: fnd_log.string(
2163: FND_LOG.LEVEL_STATEMENT,
2164: 'ahl.plsql.AHL_COMPLETIONS_PVT.get_cp_counters',
2165: 'l_wo_actual_date in get_cp_counters -> ' || TO_CHAR(l_wo_actual_date, 'DD-MON-YYYY HH24:MI:SS')
2166: );

Line 2163: FND_LOG.LEVEL_STATEMENT,

2159:
2160: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2161: THEN
2162: fnd_log.string(
2163: FND_LOG.LEVEL_STATEMENT,
2164: 'ahl.plsql.AHL_COMPLETIONS_PVT.get_cp_counters',
2165: 'l_wo_actual_date in get_cp_counters -> ' || TO_CHAR(l_wo_actual_date, 'DD-MON-YYYY HH24:MI:SS')
2166: );
2167: END IF;

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

2305: -- Bug # 6750836 -- end
2306:
2307: BEGIN
2308:
2309: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2310: THEN
2311: fnd_log.string(
2312: FND_LOG.LEVEL_STATEMENT,
2313: 'ahl.plsql.AHL_COMPLETIONS_PVT.get_reset_counters',

Line 2311: fnd_log.string(

2307: BEGIN
2308:
2309: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2310: THEN
2311: fnd_log.string(
2312: FND_LOG.LEVEL_STATEMENT,
2313: 'ahl.plsql.AHL_COMPLETIONS_PVT.get_reset_counters',
2314: 'p_actual_date in get_reset_counters -> ' || TO_CHAR(p_actual_date, 'DD-MON-YYYY HH24:MI:SS')
2315: );

Line 2312: FND_LOG.LEVEL_STATEMENT,

2308:
2309: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2310: THEN
2311: fnd_log.string(
2312: FND_LOG.LEVEL_STATEMENT,
2313: 'ahl.plsql.AHL_COMPLETIONS_PVT.get_reset_counters',
2314: 'p_actual_date in get_reset_counters -> ' || TO_CHAR(p_actual_date, 'DD-MON-YYYY HH24:MI:SS')
2315: );
2316: END IF;

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

2350: OPEN get_current_readings(ctr_cursor.counter_id);
2351: FETCH get_current_readings INTO l_cur_ct_reading;
2352: CLOSE get_current_readings;
2353:
2354: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2355: THEN
2356:
2357: fnd_log.string(
2358: FND_LOG.LEVEL_STATEMENT,

Line 2357: fnd_log.string(

2353:
2354: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2355: THEN
2356:
2357: fnd_log.string(
2358: FND_LOG.LEVEL_STATEMENT,
2359: 'ahl.plsql.AHL_COMPLETIONS_PVT.get_reset_counters',
2360: 'counter with id.. -> ' || ctr_cursor.counter_id
2361: ||', l_actual_ct_reading ->' ||l_actual_ct_reading

Line 2358: FND_LOG.LEVEL_STATEMENT,

2354: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2355: THEN
2356:
2357: fnd_log.string(
2358: FND_LOG.LEVEL_STATEMENT,
2359: 'ahl.plsql.AHL_COMPLETIONS_PVT.get_reset_counters',
2360: 'counter with id.. -> ' || ctr_cursor.counter_id
2361: ||', l_actual_ct_reading ->' ||l_actual_ct_reading
2362: ||', l_cur_ct_reading ->' ||l_cur_ct_reading

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

2365: END IF;
2366:
2367: IF l_actual_ct_reading = l_cur_ct_reading THEN
2368:
2369: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2370: THEN
2371: fnd_log.string(
2372: FND_LOG.LEVEL_STATEMENT,
2373: 'ahl.plsql.AHL_COMPLETIONS_PVT.get_reset_counters',

Line 2371: fnd_log.string(

2367: IF l_actual_ct_reading = l_cur_ct_reading THEN
2368:
2369: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2370: THEN
2371: fnd_log.string(
2372: FND_LOG.LEVEL_STATEMENT,
2373: 'ahl.plsql.AHL_COMPLETIONS_PVT.get_reset_counters',
2374: 'Resetting counter with id.. -> ' || ctr_cursor.counter_id
2375: );

Line 2372: FND_LOG.LEVEL_STATEMENT,

2368:
2369: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2370: THEN
2371: fnd_log.string(
2372: FND_LOG.LEVEL_STATEMENT,
2373: 'ahl.plsql.AHL_COMPLETIONS_PVT.get_reset_counters',
2374: 'Resetting counter with id.. -> ' || ctr_cursor.counter_id
2375: );
2376: fnd_log.string(

Line 2376: fnd_log.string(

2372: FND_LOG.LEVEL_STATEMENT,
2373: 'ahl.plsql.AHL_COMPLETIONS_PVT.get_reset_counters',
2374: 'Resetting counter with id.. -> ' || ctr_cursor.counter_id
2375: );
2376: fnd_log.string(
2377: FND_LOG.LEVEL_STATEMENT,
2378: 'ahl.plsql.AHL_COMPLETIONS_PVT.get_reset_counters',
2379: 'counter with id.. -> ' || ctr_cursor.counter_id ||', l_actual_ct_reading ->' ||l_actual_ct_reading
2380: );

Line 2377: FND_LOG.LEVEL_STATEMENT,

2373: 'ahl.plsql.AHL_COMPLETIONS_PVT.get_reset_counters',
2374: 'Resetting counter with id.. -> ' || ctr_cursor.counter_id
2375: );
2376: fnd_log.string(
2377: FND_LOG.LEVEL_STATEMENT,
2378: 'ahl.plsql.AHL_COMPLETIONS_PVT.get_reset_counters',
2379: 'counter with id.. -> ' || ctr_cursor.counter_id ||', l_actual_ct_reading ->' ||l_actual_ct_reading
2380: );
2381: END IF;

Line 2657: l_DEBUG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2653:
2654: l_msg_count NUMBER;
2655: l_msg_data VARCHAR2(2000);
2656:
2657: l_DEBUG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2658: l_DEBUG_PROC NUMBER := FND_LOG.LEVEL_PROCEDURE;
2659: l_DEBUG_STMT NUMBER := FND_LOG.LEVEL_STATEMENT;
2660:
2661: BEGIN

Line 2658: l_DEBUG_PROC NUMBER := FND_LOG.LEVEL_PROCEDURE;

2654: l_msg_count NUMBER;
2655: l_msg_data VARCHAR2(2000);
2656:
2657: l_DEBUG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2658: l_DEBUG_PROC NUMBER := FND_LOG.LEVEL_PROCEDURE;
2659: l_DEBUG_STMT NUMBER := FND_LOG.LEVEL_STATEMENT;
2660:
2661: BEGIN
2662:

Line 2659: l_DEBUG_STMT NUMBER := FND_LOG.LEVEL_STATEMENT;

2655: l_msg_data VARCHAR2(2000);
2656:
2657: l_DEBUG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2658: l_DEBUG_PROC NUMBER := FND_LOG.LEVEL_PROCEDURE;
2659: l_DEBUG_STMT NUMBER := FND_LOG.LEVEL_STATEMENT;
2660:
2661: BEGIN
2662:
2663:

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

2661: BEGIN
2662:
2663:
2664: IF ( l_DEBUG_PROC >= l_DEBUG_LEVEL) THEN
2665: fnd_log.string(l_DEBUG_PROC, 'ahl.plsql.AHL_PRD_WORKORDER_PVT.delete_serial_reservations.begin',
2666: 'At the start of procedure for workorder_id:' || p_workorder_id);
2667: END IF;
2668:
2669: -- Initialize return status.

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

2684: p_scheduled_material_id => get_scheduled_mater_rec.scheduled_material_id );
2685:
2686: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
2687: IF (l_DEBUG_STMT >= l_DEBUG_LEVEL) THEN
2688: fnd_log.string(l_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WORKORDER_PVT.delete_serial_reservations',
2689: 'AHL_RSV_RESERVATIONS_PVT.Delete_Reservation failed for schedule material ID: '
2690: || get_scheduled_mater_rec.scheduled_material_id);
2691: END IF; -- x_return_status
2692:

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

4302: --
4303: -- As per the issue # 2 in bug # 4626717 the master workorder has to be completed once
4304: -- the associated UE is signed off.Putting this code here because this is the logical end
4305: -- of mr signoff and before parent mr check starts.
4306: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4307: fnd_log.string
4308: (
4309: fnd_log.level_statement,
4310: 'ahl.plsql.AHL_PRD_COMPLETIONS_PVT.complete_mr_instance',

Line 4307: fnd_log.string

4303: -- As per the issue # 2 in bug # 4626717 the master workorder has to be completed once
4304: -- the associated UE is signed off.Putting this code here because this is the logical end
4305: -- of mr signoff and before parent mr check starts.
4306: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4307: fnd_log.string
4308: (
4309: fnd_log.level_statement,
4310: 'ahl.plsql.AHL_PRD_COMPLETIONS_PVT.complete_mr_instance',
4311: 'p_x_mr_rec.unit_effectivity_id : ' || p_x_mr_rec.unit_effectivity_id

Line 4309: fnd_log.level_statement,

4305: -- of mr signoff and before parent mr check starts.
4306: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4307: fnd_log.string
4308: (
4309: fnd_log.level_statement,
4310: 'ahl.plsql.AHL_PRD_COMPLETIONS_PVT.complete_mr_instance',
4311: 'p_x_mr_rec.unit_effectivity_id : ' || p_x_mr_rec.unit_effectivity_id
4312: );
4313: END IF;

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

4317: p_workorder_id => null,
4318: p_ue_id => p_x_mr_rec.unit_effectivity_id
4319: );
4320:
4321: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4322: fnd_log.string
4323: (
4324: fnd_log.level_statement,
4325: 'ahl.plsql.AHL_PRD_COMPLETIONS_PVT.complete_mr_instance',

Line 4322: fnd_log.string

4318: p_ue_id => p_x_mr_rec.unit_effectivity_id
4319: );
4320:
4321: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4322: fnd_log.string
4323: (
4324: fnd_log.level_statement,
4325: 'ahl.plsql.AHL_PRD_COMPLETIONS_PVT.complete_mr_instance',
4326: 'return status after calling complete_master_wo: ' || l_mwo_return_status

Line 4324: fnd_log.level_statement,

4320:
4321: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4322: fnd_log.string
4323: (
4324: fnd_log.level_statement,
4325: 'ahl.plsql.AHL_PRD_COMPLETIONS_PVT.complete_mr_instance',
4326: 'return status after calling complete_master_wo: ' || l_mwo_return_status
4327: );
4328: END IF;

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

10216: END IF; -- for Visit Status check
10217: --Pekambar added for 9274897 and 9504544
10218:
10219: -- sthilak Project Integration ER - start
10220: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
10221: THEN
10222: fnd_log.string(
10223: FND_LOG.LEVEL_STATEMENT,
10224: 'ahl.plsql.'||G_PKG_NAME||l_api_name,

Line 10222: fnd_log.string(

10218:
10219: -- sthilak Project Integration ER - start
10220: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
10221: THEN
10222: fnd_log.string(
10223: FND_LOG.LEVEL_STATEMENT,
10224: 'ahl.plsql.'||G_PKG_NAME||l_api_name,
10225: 'before calling FND_REQUEST.SUBMIT_REQUEST for visit ->'||p_close_visit_rec.visit_id
10226: );

Line 10223: FND_LOG.LEVEL_STATEMENT,

10219: -- sthilak Project Integration ER - start
10220: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
10221: THEN
10222: fnd_log.string(
10223: FND_LOG.LEVEL_STATEMENT,
10224: 'ahl.plsql.'||G_PKG_NAME||l_api_name,
10225: 'before calling FND_REQUEST.SUBMIT_REQUEST for visit ->'||p_close_visit_rec.visit_id
10226: );
10227: END IF;

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

10240: argument9 => NULL,
10241: argument10 => NULL
10242: );
10243:
10244: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
10245: THEN
10246: fnd_log.string(
10247: FND_LOG.LEVEL_STATEMENT,
10248: 'ahl.plsql.'||G_PKG_NAME||l_api_name,

Line 10246: fnd_log.string(

10242: );
10243:
10244: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
10245: THEN
10246: fnd_log.string(
10247: FND_LOG.LEVEL_STATEMENT,
10248: 'ahl.plsql.'||G_PKG_NAME||l_api_name,
10249: 'Concurrent request with Id -> '|| l_request_id || ' Is sbmitted..'
10250: );

Line 10247: FND_LOG.LEVEL_STATEMENT,

10243:
10244: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
10245: THEN
10246: fnd_log.string(
10247: FND_LOG.LEVEL_STATEMENT,
10248: 'ahl.plsql.'||G_PKG_NAME||l_api_name,
10249: 'Concurrent request with Id -> '|| l_request_id || ' Is sbmitted..'
10250: );
10251: END IF;

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

12536: x_flight_schedules_tbl => l_flight_schedules_tbl
12537: );
12538:
12539:
12540: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
12541: THEN
12542: fnd_log.string(
12543: FND_LOG.LEVEL_STATEMENT,
12544: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,

Line 12542: fnd_log.string(

12538:
12539:
12540: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
12541: THEN
12542: fnd_log.string(
12543: FND_LOG.LEVEL_STATEMENT,
12544: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
12545: 'Flight schedule search return status is -> ' || l_return_status
12546: );

Line 12543: FND_LOG.LEVEL_STATEMENT,

12539:
12540: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
12541: THEN
12542: fnd_log.string(
12543: FND_LOG.LEVEL_STATEMENT,
12544: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
12545: 'Flight schedule search return status is -> ' || l_return_status
12546: );
12547:

Line 12548: fnd_log.string(

12544: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
12545: 'Flight schedule search return status is -> ' || l_return_status
12546: );
12547:
12548: fnd_log.string(
12549: FND_LOG.LEVEL_STATEMENT,
12550: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
12551: 'No of flight schedule records -> ' || l_flight_schedules_tbl.count
12552: );

Line 12549: FND_LOG.LEVEL_STATEMENT,

12545: 'Flight schedule search return status is -> ' || l_return_status
12546: );
12547:
12548: fnd_log.string(
12549: FND_LOG.LEVEL_STATEMENT,
12550: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
12551: 'No of flight schedule records -> ' || l_flight_schedules_tbl.count
12552: );
12553: END IF;

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

12564: l_overlap_status := 'E';
12565: END IF;
12566:
12567:
12568: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
12569: THEN
12570: fnd_log.string(
12571: FND_LOG.LEVEL_STATEMENT,
12572: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,

Line 12570: fnd_log.string(

12566:
12567:
12568: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
12569: THEN
12570: fnd_log.string(
12571: FND_LOG.LEVEL_STATEMENT,
12572: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
12573: 'Flight Schedule Conflict return status -> ' || l_overlap_status
12574: );

Line 12571: FND_LOG.LEVEL_STATEMENT,

12567:
12568: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
12569: THEN
12570: fnd_log.string(
12571: FND_LOG.LEVEL_STATEMENT,
12572: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
12573: 'Flight Schedule Conflict return status -> ' || l_overlap_status
12574: );
12575: END IF;

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

12651: )
12652: THEN
12653: l_overlap_status := 'E';
12654:
12655: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
12656: THEN
12657: fnd_log.string(
12658: FND_LOG.LEVEL_STATEMENT,
12659: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,

Line 12657: fnd_log.string(

12653: l_overlap_status := 'E';
12654:
12655: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
12656: THEN
12657: fnd_log.string(
12658: FND_LOG.LEVEL_STATEMENT,
12659: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
12660: 'Mandatory parameters are null -> ' || l_overlap_status
12661: );

Line 12658: FND_LOG.LEVEL_STATEMENT,

12654:
12655: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
12656: THEN
12657: fnd_log.string(
12658: FND_LOG.LEVEL_STATEMENT,
12659: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
12660: 'Mandatory parameters are null -> ' || l_overlap_status
12661: );
12662: END IF;

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

12688: FOR umr_csr IN c_get_unit_name_visit( p_visit_id ) LOOP
12689:
12690: l_unit_name := umr_csr.unit_name;
12691:
12692: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
12693: THEN
12694: fnd_log.string(
12695: FND_LOG.LEVEL_STATEMENT,
12696: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,

Line 12694: fnd_log.string(

12690: l_unit_name := umr_csr.unit_name;
12691:
12692: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
12693: THEN
12694: fnd_log.string(
12695: FND_LOG.LEVEL_STATEMENT,
12696: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
12697: 'Checking flst schedule conflict status for UNIT_NAME -> ' || l_unit_name );
12698: END IF;

Line 12695: FND_LOG.LEVEL_STATEMENT,

12691:
12692: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
12693: THEN
12694: fnd_log.string(
12695: FND_LOG.LEVEL_STATEMENT,
12696: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
12697: 'Checking flst schedule conflict status for UNIT_NAME -> ' || l_unit_name );
12698: END IF;
12699:

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

12712:
12713: END IF;
12714:
12715:
12716: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
12717: THEN
12718: fnd_log.string(
12719: FND_LOG.LEVEL_STATEMENT,
12720: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,

Line 12718: fnd_log.string(

12714:
12715:
12716: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
12717: THEN
12718: fnd_log.string(
12719: FND_LOG.LEVEL_STATEMENT,
12720: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
12721: 'Flight Schedule Conflict return status -> ' || l_overlap_status
12722: );

Line 12719: FND_LOG.LEVEL_STATEMENT,

12715:
12716: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
12717: THEN
12718: fnd_log.string(
12719: FND_LOG.LEVEL_STATEMENT,
12720: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
12721: 'Flight Schedule Conflict return status -> ' || l_overlap_status
12722: );
12723: END IF;