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

Line 15: -- FND Logging Constants

11: -- Yes/no flags
12: G_YES_FLAG CONSTANT VARCHAR2(1) := 'Y';
13: G_NO_FLAG CONSTANT VARCHAR2(1) := 'N';
14:
15: -- FND Logging Constants
16: G_DEBUG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
17: G_DEBUG_PROC CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
18: G_DEBUG_STMT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
19: G_DEBUG_UEXP CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

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

12: G_YES_FLAG CONSTANT VARCHAR2(1) := 'Y';
13: G_NO_FLAG CONSTANT VARCHAR2(1) := 'N';
14:
15: -- FND Logging Constants
16: G_DEBUG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
17: G_DEBUG_PROC CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
18: G_DEBUG_STMT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
19: G_DEBUG_UEXP CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
20:

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

13: G_NO_FLAG CONSTANT VARCHAR2(1) := 'N';
14:
15: -- FND Logging Constants
16: G_DEBUG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
17: G_DEBUG_PROC CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
18: G_DEBUG_STMT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
19: G_DEBUG_UEXP CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
20:
21: ----------------------------------

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

14:
15: -- FND Logging Constants
16: G_DEBUG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
17: G_DEBUG_PROC CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
18: G_DEBUG_STMT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
19: G_DEBUG_UEXP CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
20:
21: ----------------------------------
22: -- Non-spec Function Signatures --

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

15: -- FND Logging Constants
16: G_DEBUG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
17: G_DEBUG_PROC CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
18: G_DEBUG_STMT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
19: G_DEBUG_UEXP CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
20:
21: ----------------------------------
22: -- Non-spec Function Signatures --
23: ----------------------------------

Line 139: fnd_log.string

135:
136: -- Log API entry point
137: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL)
138: THEN
139: fnd_log.string
140: (
141: G_DEBUG_PROC,
142: l_debug_module||'.begin',
143: 'At the start of PLSQL procedure'

Line 242: fnd_log.string

238: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
239: THEN
240: IF (G_DEBUG_UEXP >= G_DEBUG_LEVEL)
241: THEN
242: fnd_log.string
243: (
244: G_DEBUG_UEXP,
245: l_debug_module,
246: 'Call to CS_SERVICEREQUEST_PUB.Create_ServiceRequest failed...'

Line 257: fnd_log.string

253: -- l_cs_incident_id is anyway expected to be the same as p_x_nonroutine_rec.incident_id, still to be extra sure...
254: p_x_nonroutine_rec.incident_id := l_cs_incident_id;
255: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
256: THEN
257: fnd_log.string
258: (
259: G_DEBUG_STMT,
260: l_debug_module,
261: 'New non-routine created ['||p_x_nonroutine_rec.incident_id||']'

Line 274: fnd_log.string

270: cs_incident_id = p_x_nonroutine_rec.incident_id;
271:
272: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
273: THEN
274: fnd_log.string
275: (
276: G_DEBUG_STMT,
277: l_debug_module,
278: 'UE ['||l_unit_effectivity_id||'] is created for non-routine ['||p_x_nonroutine_rec.incident_id||']'

Line 294: fnd_log.string

290: END IF;
291:
292: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
293: THEN
294: fnd_log.string
295: (
296: G_DEBUG_STMT,
297: l_debug_module,
298: 'UE validations for non-routines done'

Line 317: fnd_log.string

313: WHERE unit_effectivity_id = l_unit_effectivity_id;
314:
315: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
316: THEN
317: fnd_log.string
318: (
319: G_DEBUG_STMT,
320: l_debug_module,
321: 'UE details updated for MEL/CDL qualification'

Line 329: fnd_log.string

325: IF (p_x_nonroutine_rec.mel_cdl_qual_flag ='C')
326: THEN
327: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
328: THEN
329: fnd_log.string
330: (
331: G_DEBUG_STMT,
332: l_debug_module,
333: 'Attach MEL/CDL instructions for non-routines'

Line 388: fnd_log.string

384: END IF;
385:
386: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
387: THEN
388: fnd_log.string
389: (
390: G_DEBUG_STMT,
391: l_debug_module,
392: 'Qualification [ata_sequence_id='||l_ata_sequence_id||'] computed from [unit_config_header_id='||

Line 440: fnd_log.string

436: );
437:
438: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
439: THEN
440: fnd_log.string
441: (
442: G_DEBUG_STMT,
443: l_debug_module,
444: 'Insert unit_deferral ['||l_deferral_id||'] with relevant MEL/CDL qualification information'

Line 454: fnd_log.string

450: -- API body ends here
451: -- Log API exit point
452: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL)
453: THEN
454: fnd_log.string
455: (
456: G_DEBUG_PROC,
457: l_debug_module||'.end',
458: 'At the end of PLSQL procedure'

Line 638: fnd_log.string

634:
635: -- Log API entry point
636: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL)
637: THEN
638: fnd_log.string
639: (
640: G_DEBUG_PROC,
641: l_debug_module||'.begin',
642: 'At the start of PLSQL procedure'

Line 740: fnd_log.string

736: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
737: THEN
738: IF (G_DEBUG_UEXP >= G_DEBUG_LEVEL)
739: THEN
740: fnd_log.string
741: (
742: G_DEBUG_UEXP,
743: l_debug_module,
744: 'Call to CS_SERVICEREQUEST_PUB.Update_ServiceRequest failed...'

Line 753: fnd_log.string

749: ELSE
750:
751: IF (G_DEBUG_UEXP >= G_DEBUG_LEVEL)
752: THEN
753: fnd_log.string
754: (
755: G_DEBUG_UEXP,
756: l_debug_module,
757: 'l_msg_count->'||l_msg_count||' , '||'l_msg_data->'||l_msg_data

Line 759: fnd_log.string

755: G_DEBUG_UEXP,
756: l_debug_module,
757: 'l_msg_count->'||l_msg_count||' , '||'l_msg_data->'||l_msg_data
758: );
759: fnd_log.string
760: (
761: G_DEBUG_UEXP,
762: l_debug_module,
763: 'l_return_status->'||l_return_status

Line 787: fnd_log.string

783: l_unit_effectivity_id := p_x_nonroutine_rec.unit_effectivity_id;
784:
785: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
786: THEN
787: fnd_log.string
788: (
789: G_DEBUG_STMT,
790: l_debug_module,
791: 'UE ['||l_unit_effectivity_id||'] is updated for non-routine ['||p_x_nonroutine_rec.incident_id||']'

Line 807: fnd_log.string

803: END IF;
804:
805: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
806: THEN
807: fnd_log.string
808: (
809: G_DEBUG_STMT,
810: l_debug_module,
811: 'UE validations for MEL/CDL non-routines done'

Line 830: fnd_log.string

826: IF NOT Is_MEL_CDL_Approved(l_unit_effectivity_id)
827: THEN
828: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
829: THEN
830: fnd_log.string
831: (
832: G_DEBUG_STMT,
833: l_debug_module,
834: 'UE ['||l_unit_effectivity_id||'] is not MEL/CDL approved / pending approval'

Line 847: fnd_log.string

843: WHERE unit_effectivity_id = l_unit_effectivity_id;
844:
845: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
846: THEN
847: fnd_log.string
848: (
849: G_DEBUG_STMT,
850: l_debug_module,
851: 'UE details updated for MEL/CDL qualification'

Line 859: fnd_log.string

855: IF (p_x_nonroutine_rec.mel_cdl_qual_flag ='C')
856: THEN
857: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
858: THEN
859: fnd_log.string
860: (
861: G_DEBUG_STMT,
862: l_debug_module,
863: 'Attach/Change MEL/CDL instructions for non-routines'

Line 918: fnd_log.string

914: END IF;
915:
916: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
917: THEN
918: fnd_log.string
919: (
920: G_DEBUG_STMT,
921: l_debug_module,
922: 'Qualification ata_sequence_id ['||l_ata_sequence_id||'] computed from unit_config_header_id ['||p_x_nonroutine_rec.unit_config_header_id||'],

Line 971: fnd_log.string

967: );
968:
969: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
970: THEN
971: fnd_log.string
972: (
973: G_DEBUG_STMT,
974: l_debug_module,
975: 'Updated unit_deferral ['||l_deferral_rec.unit_deferral_id||'] with relevant MEL/CDL qualification information'

Line 1021: fnd_log.string

1017: );
1018:
1019: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
1020: THEN
1021: fnd_log.string
1022: (
1023: G_DEBUG_STMT,
1024: l_debug_module,
1025: 'Insert unit_deferral ['||l_deferral_id||'] with relevant MEL/CDL qualification information'

Line 1048: fnd_log.string

1044: WHERE unit_effectivity_id = l_unit_effectivity_id;
1045:
1046: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
1047: THEN
1048: fnd_log.string
1049: (
1050: G_DEBUG_STMT,
1051: l_debug_module,
1052: 'Deleted unit_deferral ['||l_deferral_rec.unit_deferral_id||']'

Line 1077: fnd_log.string

1073: -- API body ends here
1074: -- Log API exit point
1075: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL)
1076: THEN
1077: fnd_log.string
1078: (
1079: G_DEBUG_PROC,
1080: l_debug_module||'.end',
1081: 'At the end of PLSQL procedure'

Line 1324: fnd_log.string

1320:
1321: -- Log API entry point
1322: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL)
1323: THEN
1324: fnd_log.string
1325: (
1326: G_DEBUG_PROC,
1327: l_debug_module ||'.begin', 'At the start of PLSQL procedure'
1328: );

Line 1507: IF (fnd_log.level_error >= G_DEBUG_LEVEL)THEN

1503: );
1504:
1505: -- if workorders under UE has external dependencies, dont submit for approval, raise error.
1506: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1507: IF (fnd_log.level_error >= G_DEBUG_LEVEL)THEN
1508: fnd_log.string
1509: (
1510: fnd_log.level_error,
1511: 'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Initiate_Mel_Cdl_Approval',

Line 1508: fnd_log.string

1504:
1505: -- if workorders under UE has external dependencies, dont submit for approval, raise error.
1506: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1507: IF (fnd_log.level_error >= G_DEBUG_LEVEL)THEN
1508: fnd_log.string
1509: (
1510: fnd_log.level_error,
1511: 'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Initiate_Mel_Cdl_Approval',
1512: 'Can not go ahead with submission of approval because Workorder dependencies exists'

Line 1510: fnd_log.level_error,

1506: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1507: IF (fnd_log.level_error >= G_DEBUG_LEVEL)THEN
1508: fnd_log.string
1509: (
1510: fnd_log.level_error,
1511: 'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Initiate_Mel_Cdl_Approval',
1512: 'Can not go ahead with submission of approval because Workorder dependencies exists'
1513: );
1514: END IF;

Line 1528: fnd_log.string

1524: x_return_status=>l_return_status,
1525: x_msg_count =>l_msg_count,
1526: x_msg_data =>l_msg_data);
1527: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)THEN
1528: fnd_log.string
1529: (
1530: G_DEBUG_STMT,
1531: 'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Initiate_Mel_Cdl_Approval',
1532: 'Workflow active flag : ' || l_active

Line 1534: fnd_log.string

1530: G_DEBUG_STMT,
1531: 'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Initiate_Mel_Cdl_Approval',
1532: 'Workflow active flag : ' || l_active
1533: );
1534: fnd_log.string
1535: (
1536: G_DEBUG_STMT,
1537: 'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Initiate_Mel_Cdl_Approval',
1538: 'l_process_name : ' || l_process_name

Line 1540: fnd_log.string

1536: G_DEBUG_STMT,
1537: 'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Initiate_Mel_Cdl_Approval',
1538: 'l_process_name : ' || l_process_name
1539: );
1540: fnd_log.string
1541: (
1542: G_DEBUG_STMT,
1543: 'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Initiate_Mel_Cdl_Approval',
1544: 'l_item_type : ' || l_item_type

Line 1552: fnd_log.string

1548:
1549: IF((l_return_status <> FND_API.G_RET_STS_SUCCESS) OR
1550: ( l_active <> G_YES_FLAG))THEN
1551: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)THEN
1552: fnd_log.string
1553: (
1554: G_DEBUG_STMT,
1555: 'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Initiate_Mel_Cdl_Approval',
1556: 'Workflow is not active so going for automatic approval'

Line 1570: IF (fnd_log.level_error >= G_DEBUG_LEVEL)THEN

1566: p_new_status => 'DEFERRAL_PENDING',
1567: x_return_status => l_return_status);
1568:
1569: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1570: IF (fnd_log.level_error >= G_DEBUG_LEVEL)THEN
1571: fnd_log.string
1572: (
1573: fnd_log.level_error,
1574: 'ahl.plsql.AHL_UMP_NONROUTINES_PVT.submit_for_approval',

Line 1571: fnd_log.string

1567: x_return_status => l_return_status);
1568:
1569: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1570: IF (fnd_log.level_error >= G_DEBUG_LEVEL)THEN
1571: fnd_log.string
1572: (
1573: fnd_log.level_error,
1574: 'ahl.plsql.AHL_UMP_NONROUTINES_PVT.submit_for_approval',
1575: 'Can not go ahead with approval because AHL_UMP_NONROUTINES_PVT.Initiate_Mel_Cdl_Approval threw error'

Line 1573: fnd_log.level_error,

1569: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1570: IF (fnd_log.level_error >= G_DEBUG_LEVEL)THEN
1571: fnd_log.string
1572: (
1573: fnd_log.level_error,
1574: 'ahl.plsql.AHL_UMP_NONROUTINES_PVT.submit_for_approval',
1575: 'Can not go ahead with approval because AHL_UMP_NONROUTINES_PVT.Initiate_Mel_Cdl_Approval threw error'
1576: );
1577: END IF;

Line 1582: fnd_log.string

1578: RAISE FND_API.G_EXC_ERROR;
1579: END IF;
1580:
1581: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)THEN
1582: fnd_log.string
1583: (
1584: G_DEBUG_STMT,
1585: 'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Initiate_Mel_Cdl_Approval',
1586: 'Workflow active flag : ' || l_active

Line 1644: fnd_log.string

1640: END IF;
1641: */
1642:
1643: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL)THEN
1644: fnd_log.string
1645: (
1646: G_DEBUG_PROC,
1647: 'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Initiate_Mel_Cdl_Approval.end',
1648: 'At the end of PLSQL procedure'

Line 1656: fnd_log.string

1652: -- API body ends here
1653: -- Log API exit point
1654: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL)
1655: THEN
1656: fnd_log.string
1657: (
1658: G_DEBUG_PROC,
1659: l_debug_module||'.end',
1660: 'At the end of PLSQL procedure'

Line 1797: fnd_log.string

1793:
1794: -- Log API entry point
1795: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL)
1796: THEN
1797: fnd_log.string
1798: (
1799: G_DEBUG_PROC,
1800: l_debug_module||'.begin',
1801: 'At the start of PLSQL procedure'

Line 1843: fnd_log.string

1839: -- API body ends here
1840: -- Log API exit point
1841: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL)
1842: THEN
1843: fnd_log.string
1844: (
1845: G_DEBUG_PROC,
1846: l_debug_module||'.end',
1847: 'At the end of PLSQL procedure'

Line 1941: fnd_log.string

1937: OPEN get_mel_cdl(l_unit_config_id, l_mel_cdl_type_code);
1938: FETCH get_mel_cdl INTO l_mel_cdl_header_id, l_mel_version_number, l_pc_node_id;
1939: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
1940: THEN
1941: fnd_log.string
1942: (
1943: G_DEBUG_STMT,
1944: 'ahl.plsql.'||G_PKG_NAME||'.Get_Mel_Cdl_Header_Id.end',
1945: 'Retrieved mel_cdl_header_id ['||l_mel_cdl_header_id||'] with version ['||l_mel_version_number||'] for pc_node_id ['||l_pc_node_id||'] given uc_id ['||l_unit_config_id||'] and type ['||l_mel_cdl_type_code||']'

Line 2499: fnd_log.string

2495: CLOSE check_pos_path_exists;
2496: ELSE
2497: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
2498: THEN
2499: fnd_log.string
2500: (
2501: G_DEBUG_STMT,
2502: l_debug_module,
2503: 'Call to AHL_MC_PATH_POSITION_PVT.Map_Position_To_Instances failed with error ['||l_msg_data||']'

Line 2666: fnd_log.string

2662: CLOSE get_ue_details;
2663:
2664: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
2665: THEN
2666: fnd_log.string
2667: (
2668: G_DEBUG_STMT,
2669: l_debug_module,
2670: 'l_ue_details_rec [unit_config_id='||l_ue_details_rec.unit_config_id||'][unit_config_name='

Line 2687: fnd_log.string

2683:
2684: l_mel_cdl_header_id := Get_Mel_Cdl_Header_Id(p_unit_effectivity_id, null, null);
2685: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
2686: THEN
2687: fnd_log.string
2688: (
2689: G_DEBUG_STMT,
2690: l_debug_module,
2691: 'l_mel_cdl_header_id='||l_mel_cdl_header_id||']'

Line 2739: fnd_log.string

2735: THEN
2736:
2737: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
2738: THEN
2739: fnd_log.string
2740: (
2741: G_DEBUG_STMT,
2742: l_debug_module,
2743: 'ATA Code of Position ATA is ='||p_ata_code||']'

Line 2749: fnd_log.string

2745: END IF;
2746:
2747: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
2748: THEN
2749: fnd_log.string
2750: (
2751: G_DEBUG_STMT,
2752: l_debug_module,
2753: 'ATA Code of Position ='||l_ata_for_position||']'

Line 2776: fnd_log.string

2772: CLOSE check_ata_exists;
2773:
2774: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
2775: THEN
2776: fnd_log.string
2777: (
2778: G_DEBUG_STMT,
2779: l_debug_module,
2780: 'From position_path_id -- x_ata_sequence_id='||x_ata_sequence_id||']'

Line 2794: fnd_log.string

2790: END IF;
2791: ELSE
2792: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
2793: THEN
2794: fnd_log.string
2795: (
2796: G_DEBUG_STMT,
2797: l_debug_module,
2798: 'Call to AHL_MC_PATH_POSITION_PVT.Map_Position_To_Instances failed with error ['||l_msg_data||']'

Line 2812: fnd_log.string

2808: CLOSE check_ata_exists;
2809:
2810: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
2811: THEN
2812: fnd_log.string
2813: (
2814: G_DEBUG_STMT,
2815: l_debug_module,
2816: 'From ata_code -- x_ata_sequence_id='||x_ata_sequence_id||']'

Line 3344: fnd_log.string(G_DEBUG_PROC,'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Process_MO_Procedures',

3340: BEGIN
3341:
3342: -- log debug message.
3343: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
3344: fnd_log.string(G_DEBUG_PROC,'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Process_MO_Procedures',
3345: 'At Start of procedure AHL_UMP_NONROUTINES_PVT.Process_MO_Procedures');
3346: END IF;
3347:
3348: -- read sr attributes.

Line 3361: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Process_MO_Procedures',

3357: END IF;
3358:
3359: -- Debug Checkpoint.
3360: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
3361: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Process_MO_Procedures',
3362: 'Starting SR Update');
3363: END IF;
3364:
3365: -- Update urgency and expected resolution date.

Line 3416: fnd_log.string(G_DEBUG_STMT,'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Process_MO_Procedures',

3412: );
3413:
3414: -- log debug message.
3415: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
3416: fnd_log.string(G_DEBUG_STMT,'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Process_MO_Procedures',
3417: 'After call to Update Service Request :return_status:' || l_return_status);
3418: END IF;
3419:
3420: -- Raise errors if exceptions occur

Line 3441: fnd_log.string(G_DEBUG_STMT,'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Process_MO_Procedures',

3437: l_summary := fnd_message.get;
3438:
3439: -- log debug message.
3440: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
3441: fnd_log.string(G_DEBUG_STMT,'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Process_MO_Procedures',
3442: 'New Sr Summary is:' || l_summary);
3443: END IF;
3444:
3445: -- get incident type.

Line 3524: fnd_log.string(G_DEBUG_STMT,'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Process_MO_Procedures',

3520:
3521:
3522: -- log debug message.
3523: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
3524: fnd_log.string(G_DEBUG_STMT,'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Process_MO_Procedures',
3525: 'After call to Create Service Request :return_status:' || l_return_status);
3526: END IF;
3527:
3528: -- Raise errors if exceptions occur

Line 3582: fnd_log.string(G_DEBUG_STMT,'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Process_MO_Procedures',

3578: );
3579:
3580: -- log debug message.
3581: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
3582: fnd_log.string(G_DEBUG_STMT,'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Process_MO_Procedures',
3583: 'After call to Process_SR_MR_Associations :return_status:' || l_return_status);
3584: END IF;
3585:
3586: -- Raise errors if exceptions occur

Line 3614: fnd_log.string(G_DEBUG_STMT,'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Process_MO_Procedures',

3610: x_msg_data => l_msg_data);
3611:
3612: -- log debug message.
3613: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
3614: fnd_log.string(G_DEBUG_STMT,'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Process_MO_Procedures',
3615: 'After call to Create Task API:return_status:' || l_return_status);
3616: END IF;
3617:
3618: -- Raise errors if exceptions occur

Line 3644: fnd_log.string(G_DEBUG_STMT,'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Process_MO_Procedures',

3640: x_msg_data => l_msg_data);
3641:
3642: -- log debug message.
3643: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
3644: fnd_log.string(G_DEBUG_STMT,'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Process_MO_Procedures',
3645: 'After call to release workorders:return_status:' || l_return_status);
3646: END IF;
3647:
3648: -- Raise errors if exceptions occur

Line 3668: IF (fnd_log.level_error >= G_DEBUG_LEVEL)THEN

3664: p_new_status => 'DEFERRED',
3665: x_return_status => l_return_status);
3666:
3667: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3668: IF (fnd_log.level_error >= G_DEBUG_LEVEL)THEN
3669: fnd_log.string
3670: (
3671: fnd_log.level_error,
3672: 'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Initiate_Mel_Cdl_Approval',

Line 3669: fnd_log.string

3665: x_return_status => l_return_status);
3666:
3667: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3668: IF (fnd_log.level_error >= G_DEBUG_LEVEL)THEN
3669: fnd_log.string
3670: (
3671: fnd_log.level_error,
3672: 'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Initiate_Mel_Cdl_Approval',
3673: 'Can not go ahead with automatic approval because AHL_UMP_NONROUTINES_PVT.Initiate_Mel_Cdl_Approval threw error');

Line 3671: fnd_log.level_error,

3667: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3668: IF (fnd_log.level_error >= G_DEBUG_LEVEL)THEN
3669: fnd_log.string
3670: (
3671: fnd_log.level_error,
3672: 'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Initiate_Mel_Cdl_Approval',
3673: 'Can not go ahead with automatic approval because AHL_UMP_NONROUTINES_PVT.Initiate_Mel_Cdl_Approval threw error');
3674: END IF;
3675: RAISE FND_API.G_EXC_ERROR;

Line 3744: fnd_log.string(G_DEBUG_STMT,'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Process_MO_Procedures',

3740: );
3741:
3742: -- log debug message.
3743: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
3744: fnd_log.string(G_DEBUG_STMT,'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Process_MO_Procedures',
3745: 'After insert into ahl_unit_deferrals table: deferral ID:' || l_unit_deferral_id);
3746: END IF;
3747:
3748: -- log debug message.

Line 3750: fnd_log.string(G_DEBUG_PROC,'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Process_MO_Procedures',

3746: END IF;
3747:
3748: -- log debug message.
3749: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
3750: fnd_log.string(G_DEBUG_PROC,'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Process_MO_Procedures',
3751: 'At End of procedure AHL_UMP_NONROUTINES_PVT.Process_MO_Procedures');
3752: END IF;
3753:
3754: END Process_MO_procedures;