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_UMP_SMRINSTANCE_PVT dependencies on FND_LOG

Line 6: -- FND Logging Constants

2: /* $Header: AHLVSMRB.pls 120.15.12020000.2 2012/12/07 14:40:58 sareepar ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_UMP_SMRINSTANCE_PVT';
5:
6: -- FND Logging Constants
7: G_DEBUG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
8: G_DEBUG_PROC CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
9: G_DEBUG_STMT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
10: G_DEBUG_UEXP CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

Line 7: G_DEBUG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_UMP_SMRINSTANCE_PVT';
5:
6: -- FND Logging Constants
7: G_DEBUG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
8: G_DEBUG_PROC CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
9: G_DEBUG_STMT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
10: G_DEBUG_UEXP CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
11:

Line 8: G_DEBUG_PROC CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_UMP_SMRINSTANCE_PVT';
5:
6: -- FND Logging Constants
7: G_DEBUG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
8: G_DEBUG_PROC CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
9: G_DEBUG_STMT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
10: G_DEBUG_UEXP CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
11:
12: -------------------------------

Line 9: G_DEBUG_STMT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

5:
6: -- FND Logging Constants
7: G_DEBUG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
8: G_DEBUG_PROC CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
9: G_DEBUG_STMT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
10: G_DEBUG_UEXP CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
11:
12: -------------------------------
13: -- Declare Local Procedures --

Line 10: G_DEBUG_UEXP CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

6: -- FND Logging Constants
7: G_DEBUG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
8: G_DEBUG_PROC CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
9: G_DEBUG_STMT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
10: G_DEBUG_UEXP CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
11:
12: -------------------------------
13: -- Declare Local Procedures --
14: -------------------------------

Line 329: fnd_log.string

325: l_due_to DATE;
326:
327: BEGIN
328: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL)THEN
329: fnd_log.string
330: (
331: G_DEBUG_PROC,
332: 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances.begin',
333: 'At the start of PLSQL procedure'

Line 359: fnd_log.string

355: l_early_exit_status := TRUE;
356: l_bind_index := 1;
357: -- Logging input
358: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)THEN
359: fnd_log.string
360: (
361: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
362: 'p_search_mr_instance_rec.unit_name :' || p_search_mr_instance_rec.unit_name
363: );

Line 364: fnd_log.string

360: (
361: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
362: 'p_search_mr_instance_rec.unit_name :' || p_search_mr_instance_rec.unit_name
363: );
364: fnd_log.string
365: (
366: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
367: 'p_search_mr_instance_rec.part_number :' || p_search_mr_instance_rec.part_number
368: );

Line 369: fnd_log.string

365: (
366: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
367: 'p_search_mr_instance_rec.part_number :' || p_search_mr_instance_rec.part_number
368: );
369: fnd_log.string
370: (
371: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
372: 'p_search_mr_instance_rec.serial_number :' || p_search_mr_instance_rec.serial_number
373: );

Line 374: fnd_log.string

370: (
371: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
372: 'p_search_mr_instance_rec.serial_number :' || p_search_mr_instance_rec.serial_number
373: );
374: fnd_log.string
375: (
376: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
377: 'p_search_mr_instance_rec.sort_by :' || p_search_mr_instance_rec.sort_by
378: );

Line 379: fnd_log.string

375: (
376: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
377: 'p_search_mr_instance_rec.sort_by :' || p_search_mr_instance_rec.sort_by
378: );
379: fnd_log.string
380: (
381: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
382: 'p_search_mr_instance_rec.mr_status :' || p_search_mr_instance_rec.mr_status
383: );

Line 384: fnd_log.string

380: (
381: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
382: 'p_search_mr_instance_rec.mr_status :' || p_search_mr_instance_rec.mr_status
383: );
384: fnd_log.string
385: (
386: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
387: 'p_search_mr_instance_rec.program_type :' || p_search_mr_instance_rec.program_type
388: );

Line 389: fnd_log.string

385: (
386: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
387: 'p_search_mr_instance_rec.program_type :' || p_search_mr_instance_rec.program_type
388: );
389: fnd_log.string
390: (
391: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
392: 'p_search_mr_instance_rec.due_from :' || p_search_mr_instance_rec.due_from
393: );

Line 394: fnd_log.string

390: (
391: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
392: 'p_search_mr_instance_rec.due_from :' || p_search_mr_instance_rec.due_from
393: );
394: fnd_log.string
395: (
396: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
397: 'p_search_mr_instance_rec.due_to :' || p_search_mr_instance_rec.due_to
398: );

Line 399: fnd_log.string

395: (
396: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
397: 'p_search_mr_instance_rec.due_to :' || p_search_mr_instance_rec.due_to
398: );
399: fnd_log.string
400: (
401: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
402: 'p_search_mr_instance_rec.show_tolerance :' || p_search_mr_instance_rec.show_tolerance
403: );

Line 404: fnd_log.string

400: (
401: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
402: 'p_search_mr_instance_rec.show_tolerance :' || p_search_mr_instance_rec.show_tolerance
403: );
404: fnd_log.string
405: (
406: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
407: 'p_search_mr_instance_rec.components_flag :' || p_search_mr_instance_rec.components_flag
408: );

Line 409: fnd_log.string

405: (
406: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
407: 'p_search_mr_instance_rec.components_flag :' || p_search_mr_instance_rec.components_flag
408: );
409: fnd_log.string
410: (
411: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
412: 'p_search_mr_instance_rec.repetitive_flag :' || p_search_mr_instance_rec.repetitive_flag
413: );

Line 414: fnd_log.string

410: (
411: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
412: 'p_search_mr_instance_rec.repetitive_flag :' || p_search_mr_instance_rec.repetitive_flag
413: );
414: fnd_log.string
415: (
416: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
417: 'p_search_mr_instance_rec.contract_number :' || p_search_mr_instance_rec.contract_number
418: );

Line 419: fnd_log.string

415: (
416: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
417: 'p_search_mr_instance_rec.contract_number :' || p_search_mr_instance_rec.contract_number
418: );
419: fnd_log.string
420: (
421: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
422: 'p_search_mr_instance_rec.contract_modifier :' || p_search_mr_instance_rec.contract_modifier
423: );

Line 424: fnd_log.string

420: (
421: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
422: 'p_search_mr_instance_rec.contract_modifier :' || p_search_mr_instance_rec.contract_modifier
423: );
424: fnd_log.string
425: (
426: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
427: 'p_search_mr_instance_rec.contract_number :' || p_search_mr_instance_rec.contract_number
428: );

Line 429: fnd_log.string

425: (
426: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
427: 'p_search_mr_instance_rec.contract_number :' || p_search_mr_instance_rec.contract_number
428: );
429: fnd_log.string
430: (
431: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
432: 'p_search_mr_instance_rec.service_line_id :' || p_search_mr_instance_rec.service_line_id
433: );

Line 434: fnd_log.string

430: (
431: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
432: 'p_search_mr_instance_rec.service_line_id :' || p_search_mr_instance_rec.service_line_id
433: );
434: fnd_log.string
435: (
436: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
437: 'p_search_mr_instance_rec.service_line_num :' || p_search_mr_instance_rec.service_line_num
438: );

Line 439: fnd_log.string

435: (
436: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
437: 'p_search_mr_instance_rec.service_line_num :' || p_search_mr_instance_rec.service_line_num
438: );
439: fnd_log.string
440: (
441: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
442: 'p_search_mr_instance_rec.program_id :' || p_search_mr_instance_rec.program_id
443: );

Line 444: fnd_log.string

440: (
441: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
442: 'p_search_mr_instance_rec.program_id :' || p_search_mr_instance_rec.program_id
443: );
444: fnd_log.string
445: (
446: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
447: 'p_search_mr_instance_rec.program_title :' || p_search_mr_instance_rec.program_title
448: );

Line 449: fnd_log.string

445: (
446: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
447: 'p_search_mr_instance_rec.program_title :' || p_search_mr_instance_rec.program_title
448: );
449: fnd_log.string
450: (
451: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
452: 'p_search_mr_instance_rec.show_groupmr :' || p_search_mr_instance_rec.show_groupmr
453: );

Line 454: fnd_log.string

450: (
451: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
452: 'p_search_mr_instance_rec.show_groupmr :' || p_search_mr_instance_rec.show_groupmr
453: );
454: fnd_log.string
455: (
456: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
457: 'p_search_mr_instance_rec.object_type :' || p_search_mr_instance_rec.object_type
458: );

Line 460: fnd_log.string

456: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
457: 'p_search_mr_instance_rec.object_type :' || p_search_mr_instance_rec.object_type
458: );
459:
460: fnd_log.string
461: (
462: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
463: 'p_search_mr_instance_rec.search_for_type :' || p_search_mr_instance_rec.search_for_type
464: );

Line 466: fnd_log.string

462: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
463: 'p_search_mr_instance_rec.search_for_type :' || p_search_mr_instance_rec.search_for_type
464: );
465:
466: fnd_log.string
467: (
468: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
469: 'p_search_mr_instance_rec.INCIDENT_TYPE_ID :' || p_search_mr_instance_rec.INCIDENT_TYPE_ID
470: );

Line 472: fnd_log.string

468: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
469: 'p_search_mr_instance_rec.INCIDENT_TYPE_ID :' || p_search_mr_instance_rec.INCIDENT_TYPE_ID
470: );
471:
472: fnd_log.string
473: (
474: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
475: 'p_search_mr_instance_rec.SERVICE_REQ_NUM :' || p_search_mr_instance_rec.SERVICE_REQ_NUM
476: );

Line 479: fnd_log.string

475: 'p_search_mr_instance_rec.SERVICE_REQ_NUM :' || p_search_mr_instance_rec.SERVICE_REQ_NUM
476: );
477:
478: --apattark added for VWPE
479: fnd_log.string
480: (
481: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
482: 'p_search_mr_instance_rec.item_grp_name :' || p_search_mr_instance_rec.ITEM_GRP_NAME
483: );

Line 484: fnd_log.string

480: (
481: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
482: 'p_search_mr_instance_rec.item_grp_name :' || p_search_mr_instance_rec.ITEM_GRP_NAME
483: );
484: fnd_log.string
485: (
486: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
487: 'p_search_mr_instance_rec.on_wing :' || p_search_mr_instance_rec.ON_WING
488: );

Line 491: fnd_log.string

487: 'p_search_mr_instance_rec.on_wing :' || p_search_mr_instance_rec.ON_WING
488: );
489:
490: -- Sthilak CAM changes
491: fnd_log.string
492: (
493: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
494: 'p_search_mr_instance_rec.service_category :' || p_search_mr_instance_rec.SERVICE_CATEGORY
495: );

Line 497: fnd_log.string

493: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
494: 'p_search_mr_instance_rec.service_category :' || p_search_mr_instance_rec.SERVICE_CATEGORY
495: );
496:
497: fnd_log.string
498: (
499: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
500: 'p_search_mr_instance_rec.mr_implement_status :' || p_search_mr_instance_rec.MR_IMPLEMENT_STATUS
501: );

Line 511: fnd_log.string

507: IF p_search_mr_instance_rec.due_to is NOT NULL THEN
508: --l_due_to := TRUNC(p_search_mr_instance_rec.due_to) + 86399/86400;
509: l_due_to := TRUNC(p_search_mr_instance_rec.due_to) + 1;
510: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)THEN
511: fnd_log.string
512: (
513: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
514: 'l_due_to :' || to_char(l_due_to,'DD-MON-YYYY HH24:MI:SS')
515: );

Line 1023: fnd_log.string

1019: END IF;
1020:
1021: -- Logging the sql string .
1022: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)THEN
1023: fnd_log.string
1024: (
1025: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
1026: 'Prepared SQL string IS '
1027: );

Line 1031: fnd_log.string

1027: );
1028: l_sql_segment_count := CEIL(LENGTH(l_sql_string)/4000);
1029: FOR i in 1..l_sql_segment_count LOOP
1030: IF(i < l_sql_segment_count - 1) THEN
1031: fnd_log.string
1032: (
1033: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
1034: SUBSTR(l_sql_string,(i-1)*4000,4000)
1035: );

Line 1037: fnd_log.string

1033: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
1034: SUBSTR(l_sql_string,(i-1)*4000,4000)
1035: );
1036: ELSE
1037: fnd_log.string
1038: (
1039: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
1040: SUBSTR(l_sql_string,(i-1)*4000, LENGTH(l_sql_string) - (l_sql_segment_count -1 ) * 4000)
1041: );

Line 1199: fnd_log.string

1195:
1196: IF(l_status_code = 'TERMINATED' OR l_end_date <= sysdate) THEN
1197: x_results_mr_instance_tbl(l_counter).version_number := l_version_number || '+';
1198: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)THEN
1199: fnd_log.string
1200: (
1201: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
1202: 'entered +' || l_end_date || l_status_code || sysdate
1203: );

Line 1208: fnd_log.string

1204: END IF;
1205: ELSE
1206: x_results_mr_instance_tbl(l_counter).version_number := l_version_number;
1207: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)THEN
1208: fnd_log.string
1209: (
1210: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
1211: 'entered normal' || l_end_date || l_status_code || sysdate
1212: );

Line 1352: fnd_log.string

1348: );
1349:
1350: -- Logging input
1351: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)THEN
1352: fnd_log.string
1353: (
1354: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
1355: 'number of records returned :' || x_results_count
1356: );

Line 1360: fnd_log.string

1356: );
1357: END IF;
1358:
1359: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL)THEN
1360: fnd_log.string
1361: (
1362: G_DEBUG_PROC,
1363: 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances.end',
1364: 'At the end of PLSQL procedure'

Line 1836: FND_LOG.STRING

1832:
1833: BEGIN
1834:
1835: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL)THEN
1836: FND_LOG.STRING
1837: (
1838: G_DEBUG_PROC,
1839: 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Build_Ump_Search_query.start',
1840: 'At the start of PLSQL procedure'

Line 2481: FND_LOG.STRING ( G_DEBUG_PROC, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Build_Ump_Search_query.end', 'At the end of PLSQL procedure' );

2477: P_DATA => X_MSG_DATA,
2478: P_ENCODED => FND_API.G_FALSE );
2479:
2480: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL)THEN
2481: FND_LOG.STRING ( G_DEBUG_PROC, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Build_Ump_Search_query.end', 'At the end of PLSQL procedure' );
2482: END IF;
2483:
2484: EXCEPTION
2485: WHEN FND_API.G_EXC_ERROR THEN