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 147: fnd_log.string

143:
144: -- Log API entry point
145: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL)
146: THEN
147: fnd_log.string
148: (
149: G_DEBUG_PROC,
150: l_debug_module||'.begin',
151: 'At the start of PLSQL procedure'

Line 272: fnd_log.string

268: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
269: THEN
270: IF (G_DEBUG_UEXP >= G_DEBUG_LEVEL)
271: THEN
272: fnd_log.string
273: (
274: G_DEBUG_UEXP,
275: l_debug_module,
276: 'Call to CS_SERVICEREQUEST_PUB.Create_ServiceRequest failed...'

Line 287: fnd_log.string

283: -- l_cs_incident_id is anyway expected to be the same as p_x_nonroutine_rec.incident_id, still to be extra sure...
284: p_x_nonroutine_rec.incident_id := l_cs_incident_id;
285: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
286: THEN
287: fnd_log.string
288: (
289: G_DEBUG_STMT,
290: l_debug_module,
291: 'New non-routine created ['||p_x_nonroutine_rec.incident_id||']'

Line 304: fnd_log.string

300: cs_incident_id = p_x_nonroutine_rec.incident_id;
301:
302: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
303: THEN
304: fnd_log.string
305: (
306: G_DEBUG_STMT,
307: l_debug_module,
308: 'UE ['||l_unit_effectivity_id||'] is created for non-routine ['||p_x_nonroutine_rec.incident_id||']'

Line 324: fnd_log.string

320: END IF;
321:
322: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
323: THEN
324: fnd_log.string
325: (
326: G_DEBUG_STMT,
327: l_debug_module,
328: 'UE validations for non-routines done'

Line 349: fnd_log.string

345: WHERE unit_effectivity_id = l_unit_effectivity_id;
346:
347: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
348: THEN
349: fnd_log.string
350: (
351: G_DEBUG_STMT,
352: l_debug_module,
353: 'UE details updated for MEL/CDL qualification'

Line 361: fnd_log.string

357: IF (p_x_nonroutine_rec.mel_cdl_qual_flag ='C')
358: THEN
359: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
360: THEN
361: fnd_log.string
362: (
363: G_DEBUG_STMT,
364: l_debug_module,
365: 'Attach MEL/CDL instructions for non-routines'

Line 420: fnd_log.string

416: END IF;
417:
418: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
419: THEN
420: fnd_log.string
421: (
422: G_DEBUG_STMT,
423: l_debug_module,
424: 'Qualification [ata_sequence_id='||l_ata_sequence_id||'] computed from [unit_config_header_id='||

Line 473: fnd_log.string

469: );
470:
471: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
472: THEN
473: fnd_log.string
474: (
475: G_DEBUG_STMT,
476: l_debug_module,
477: 'Insert unit_deferral ['||l_deferral_id||'] with relevant MEL/CDL qualification information'

Line 487: FND_LOG.string(G_DEBUG_STMT, l_debug_module,

483: --SALOGAN added the following for Complex Mx - Begin
484: --Launching workflow notification if the NR type is AHL_REMOVAL_NON_ROUTINE
485: IF(p_x_nonroutine_rec.type_id = fnd_profile.value('AHL_REMOVAL_NON_ROUTINE')) THEN
486: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
487: FND_LOG.string(G_DEBUG_STMT, l_debug_module,
488: 'before calling Launch_NR_Notification with arguments: '||
489: ' p_sr_incident_id > '||p_x_nonroutine_rec.incident_id);
490: END IF;
491:

Line 499: FND_LOG.string(G_DEBUG_STMT, l_debug_module,

495: x_item_key => l_item_key,
496: x_return_status => l_return_status);
497:
498: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
499: FND_LOG.string(G_DEBUG_STMT, l_debug_module,
500: 'after calling Launch_NR_Notification, '||
501: ' l_item_key > '||l_item_key||
502: ', l_return_status'||l_return_status);
503: END IF;

Line 511: fnd_log.string

507: -- API body ends here
508: -- Log API exit point
509: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL)
510: THEN
511: fnd_log.string
512: (
513: G_DEBUG_PROC,
514: l_debug_module||'.end',
515: 'At the end of PLSQL procedure'

Line 695: fnd_log.string

691:
692: -- Log API entry point
693: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL)
694: THEN
695: fnd_log.string
696: (
697: G_DEBUG_PROC,
698: l_debug_module||'.begin',
699: 'At the start of PLSQL procedure'

Line 819: fnd_log.string

815: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
816: THEN
817: IF (G_DEBUG_UEXP >= G_DEBUG_LEVEL)
818: THEN
819: fnd_log.string
820: (
821: G_DEBUG_UEXP,
822: l_debug_module,
823: 'Call to CS_SERVICEREQUEST_PUB.Update_ServiceRequest failed...'

Line 832: fnd_log.string

828: ELSE
829:
830: IF (G_DEBUG_UEXP >= G_DEBUG_LEVEL)
831: THEN
832: fnd_log.string
833: (
834: G_DEBUG_UEXP,
835: l_debug_module,
836: 'l_msg_count->'||l_msg_count||' , '||'l_msg_data->'||l_msg_data

Line 838: fnd_log.string

834: G_DEBUG_UEXP,
835: l_debug_module,
836: 'l_msg_count->'||l_msg_count||' , '||'l_msg_data->'||l_msg_data
837: );
838: fnd_log.string
839: (
840: G_DEBUG_UEXP,
841: l_debug_module,
842: 'l_return_status->'||l_return_status

Line 866: fnd_log.string

862: l_unit_effectivity_id := p_x_nonroutine_rec.unit_effectivity_id;
863:
864: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
865: THEN
866: fnd_log.string
867: (
868: G_DEBUG_STMT,
869: l_debug_module,
870: 'UE ['||l_unit_effectivity_id||'] is updated for non-routine ['||p_x_nonroutine_rec.incident_id||']'

Line 886: fnd_log.string

882: END IF;
883:
884: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
885: THEN
886: fnd_log.string
887: (
888: G_DEBUG_STMT,
889: l_debug_module,
890: 'UE validations for MEL/CDL non-routines done'

Line 911: fnd_log.string

907: IF NOT Is_MEL_CDL_Approved(l_unit_effectivity_id)
908: THEN
909: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
910: THEN
911: fnd_log.string
912: (
913: G_DEBUG_STMT,
914: l_debug_module,
915: 'UE ['||l_unit_effectivity_id||'] is not MEL/CDL approved / pending approval'

Line 928: fnd_log.string

924: WHERE unit_effectivity_id = l_unit_effectivity_id;
925:
926: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
927: THEN
928: fnd_log.string
929: (
930: G_DEBUG_STMT,
931: l_debug_module,
932: 'UE details updated for MEL/CDL qualification'

Line 940: fnd_log.string

936: IF (p_x_nonroutine_rec.mel_cdl_qual_flag ='C')
937: THEN
938: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
939: THEN
940: fnd_log.string
941: (
942: G_DEBUG_STMT,
943: l_debug_module,
944: 'Attach/Change MEL/CDL instructions for non-routines'

Line 999: fnd_log.string

995: END IF;
996:
997: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
998: THEN
999: fnd_log.string
1000: (
1001: G_DEBUG_STMT,
1002: l_debug_module,
1003: 'Qualification ata_sequence_id ['||l_ata_sequence_id||'] computed from unit_config_header_id ['||p_x_nonroutine_rec.unit_config_header_id||'],

Line 1053: fnd_log.string

1049: );
1050:
1051: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
1052: THEN
1053: fnd_log.string
1054: (
1055: G_DEBUG_STMT,
1056: l_debug_module,
1057: 'Updated unit_deferral ['||l_deferral_rec.unit_deferral_id||'] with relevant MEL/CDL qualification information'

Line 1104: fnd_log.string

1100: );
1101:
1102: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
1103: THEN
1104: fnd_log.string
1105: (
1106: G_DEBUG_STMT,
1107: l_debug_module,
1108: 'Insert unit_deferral ['||l_deferral_id||'] with relevant MEL/CDL qualification information'

Line 1131: fnd_log.string

1127: WHERE unit_effectivity_id = l_unit_effectivity_id;
1128:
1129: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
1130: THEN
1131: fnd_log.string
1132: (
1133: G_DEBUG_STMT,
1134: l_debug_module,
1135: 'Deleted unit_deferral ['||l_deferral_rec.unit_deferral_id||']'

Line 1160: fnd_log.string

1156: -- API body ends here
1157: -- Log API exit point
1158: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL)
1159: THEN
1160: fnd_log.string
1161: (
1162: G_DEBUG_PROC,
1163: l_debug_module||'.end',
1164: 'At the end of PLSQL procedure'

Line 1407: fnd_log.string

1403:
1404: -- Log API entry point
1405: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL)
1406: THEN
1407: fnd_log.string
1408: (
1409: G_DEBUG_PROC,
1410: l_debug_module ||'.begin', 'At the start of PLSQL procedure'
1411: );

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

1591: );
1592:
1593: -- if workorders under UE has external dependencies, dont submit for approval, raise error.
1594: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1595: IF (fnd_log.level_error >= G_DEBUG_LEVEL)THEN
1596: fnd_log.string
1597: (
1598: fnd_log.level_error,
1599: 'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Initiate_Mel_Cdl_Approval',

Line 1596: fnd_log.string

1592:
1593: -- if workorders under UE has external dependencies, dont submit for approval, raise error.
1594: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1595: IF (fnd_log.level_error >= G_DEBUG_LEVEL)THEN
1596: fnd_log.string
1597: (
1598: fnd_log.level_error,
1599: 'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Initiate_Mel_Cdl_Approval',
1600: 'Can not go ahead with submission of approval because Workorder dependencies exists'

Line 1598: fnd_log.level_error,

1594: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1595: IF (fnd_log.level_error >= G_DEBUG_LEVEL)THEN
1596: fnd_log.string
1597: (
1598: fnd_log.level_error,
1599: 'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Initiate_Mel_Cdl_Approval',
1600: 'Can not go ahead with submission of approval because Workorder dependencies exists'
1601: );
1602: END IF;

Line 1616: fnd_log.string

1612: x_return_status=>l_return_status,
1613: x_msg_count =>l_msg_count,
1614: x_msg_data =>l_msg_data);
1615: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)THEN
1616: fnd_log.string
1617: (
1618: G_DEBUG_STMT,
1619: 'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Initiate_Mel_Cdl_Approval',
1620: 'Workflow active flag : ' || l_active

Line 1622: fnd_log.string

1618: G_DEBUG_STMT,
1619: 'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Initiate_Mel_Cdl_Approval',
1620: 'Workflow active flag : ' || l_active
1621: );
1622: fnd_log.string
1623: (
1624: G_DEBUG_STMT,
1625: 'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Initiate_Mel_Cdl_Approval',
1626: 'l_process_name : ' || l_process_name

Line 1628: fnd_log.string

1624: G_DEBUG_STMT,
1625: 'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Initiate_Mel_Cdl_Approval',
1626: 'l_process_name : ' || l_process_name
1627: );
1628: fnd_log.string
1629: (
1630: G_DEBUG_STMT,
1631: 'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Initiate_Mel_Cdl_Approval',
1632: 'l_item_type : ' || l_item_type

Line 1640: fnd_log.string

1636:
1637: IF((l_return_status <> FND_API.G_RET_STS_SUCCESS) OR
1638: ( l_active <> G_YES_FLAG))THEN
1639: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)THEN
1640: fnd_log.string
1641: (
1642: G_DEBUG_STMT,
1643: 'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Initiate_Mel_Cdl_Approval',
1644: 'Workflow is not active so going for automatic approval'

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

1654: p_new_status => 'DEFERRAL_PENDING',
1655: x_return_status => l_return_status);
1656:
1657: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1658: IF (fnd_log.level_error >= G_DEBUG_LEVEL)THEN
1659: fnd_log.string
1660: (
1661: fnd_log.level_error,
1662: 'ahl.plsql.AHL_UMP_NONROUTINES_PVT.submit_for_approval',

Line 1659: fnd_log.string

1655: x_return_status => l_return_status);
1656:
1657: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1658: IF (fnd_log.level_error >= G_DEBUG_LEVEL)THEN
1659: fnd_log.string
1660: (
1661: fnd_log.level_error,
1662: 'ahl.plsql.AHL_UMP_NONROUTINES_PVT.submit_for_approval',
1663: 'Can not go ahead with approval because AHL_UMP_NONROUTINES_PVT.Initiate_Mel_Cdl_Approval threw error'

Line 1661: fnd_log.level_error,

1657: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1658: IF (fnd_log.level_error >= G_DEBUG_LEVEL)THEN
1659: fnd_log.string
1660: (
1661: fnd_log.level_error,
1662: 'ahl.plsql.AHL_UMP_NONROUTINES_PVT.submit_for_approval',
1663: 'Can not go ahead with approval because AHL_UMP_NONROUTINES_PVT.Initiate_Mel_Cdl_Approval threw error'
1664: );
1665: END IF;

Line 1670: fnd_log.string

1666: RAISE FND_API.G_EXC_ERROR;
1667: END IF;
1668:
1669: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)THEN
1670: fnd_log.string
1671: (
1672: G_DEBUG_STMT,
1673: 'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Initiate_Mel_Cdl_Approval',
1674: 'Workflow active flag : ' || l_active

Line 1732: fnd_log.string

1728: END IF;
1729: */
1730:
1731: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL)THEN
1732: fnd_log.string
1733: (
1734: G_DEBUG_PROC,
1735: 'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Initiate_Mel_Cdl_Approval.end',
1736: 'At the end of PLSQL procedure'

Line 1744: fnd_log.string

1740: -- API body ends here
1741: -- Log API exit point
1742: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL)
1743: THEN
1744: fnd_log.string
1745: (
1746: G_DEBUG_PROC,
1747: l_debug_module||'.end',
1748: 'At the end of PLSQL procedure'

Line 1885: fnd_log.string

1881:
1882: -- Log API entry point
1883: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL)
1884: THEN
1885: fnd_log.string
1886: (
1887: G_DEBUG_PROC,
1888: l_debug_module||'.begin',
1889: 'At the start of PLSQL procedure'

Line 1931: fnd_log.string

1927: -- API body ends here
1928: -- Log API exit point
1929: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL)
1930: THEN
1931: fnd_log.string
1932: (
1933: G_DEBUG_PROC,
1934: l_debug_module||'.end',
1935: 'At the end of PLSQL procedure'

Line 2034: fnd_log.string

2030: OPEN get_mel_cdl(l_unit_config_id, l_mel_cdl_type_code);
2031: FETCH get_mel_cdl INTO l_mel_cdl_header_id, l_mel_version_number, l_pc_node_id;
2032: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
2033: THEN
2034: fnd_log.string
2035: (
2036: G_DEBUG_STMT,
2037: 'ahl.plsql.'||G_PKG_NAME||'.Get_Mel_Cdl_Header_Id.end',
2038: '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 2593: fnd_log.string

2589: CLOSE check_pos_path_exists;
2590: ELSE
2591: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
2592: THEN
2593: fnd_log.string
2594: (
2595: G_DEBUG_STMT,
2596: l_debug_module,
2597: 'Call to AHL_MC_PATH_POSITION_PVT.Map_Position_To_Instances failed with error ['||l_msg_data||']'

Line 2760: fnd_log.string

2756: CLOSE get_ue_details;
2757:
2758: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
2759: THEN
2760: fnd_log.string
2761: (
2762: G_DEBUG_STMT,
2763: l_debug_module,
2764: 'l_ue_details_rec [unit_config_id='||l_ue_details_rec.unit_config_id||'][unit_config_name='

Line 2781: fnd_log.string

2777:
2778: l_mel_cdl_header_id := Get_Mel_Cdl_Header_Id(p_unit_effectivity_id, null, null);
2779: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
2780: THEN
2781: fnd_log.string
2782: (
2783: G_DEBUG_STMT,
2784: l_debug_module,
2785: 'l_mel_cdl_header_id='||l_mel_cdl_header_id||']'

Line 2833: fnd_log.string

2829: THEN
2830:
2831: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
2832: THEN
2833: fnd_log.string
2834: (
2835: G_DEBUG_STMT,
2836: l_debug_module,
2837: 'ATA Code of Position ATA is ='||p_ata_code||']'

Line 2843: fnd_log.string

2839: END IF;
2840:
2841: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
2842: THEN
2843: fnd_log.string
2844: (
2845: G_DEBUG_STMT,
2846: l_debug_module,
2847: 'ATA Code of Position ='||l_ata_for_position||']'

Line 2870: fnd_log.string

2866: CLOSE check_ata_exists;
2867:
2868: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
2869: THEN
2870: fnd_log.string
2871: (
2872: G_DEBUG_STMT,
2873: l_debug_module,
2874: 'From position_path_id -- x_ata_sequence_id='||x_ata_sequence_id||']'

Line 2888: fnd_log.string

2884: END IF;
2885: ELSE
2886: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
2887: THEN
2888: fnd_log.string
2889: (
2890: G_DEBUG_STMT,
2891: l_debug_module,
2892: 'Call to AHL_MC_PATH_POSITION_PVT.Map_Position_To_Instances failed with error ['||l_msg_data||']'

Line 2906: fnd_log.string

2902: CLOSE check_ata_exists;
2903:
2904: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
2905: THEN
2906: fnd_log.string
2907: (
2908: G_DEBUG_STMT,
2909: l_debug_module,
2910: 'From ata_code -- x_ata_sequence_id='||x_ata_sequence_id||']'

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

3520: BEGIN
3521:
3522: -- log debug message.
3523: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
3524: fnd_log.string(G_DEBUG_PROC,'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Process_MO_Procedures',
3525: 'At Start of procedure AHL_UMP_NONROUTINES_PVT.Process_MO_Procedures');
3526: END IF;
3527:
3528: -- read sr attributes.

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

3537: END IF;
3538:
3539: -- Debug Checkpoint.
3540: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
3541: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Process_MO_Procedures',
3542: 'Starting SR Update');
3543: END IF;
3544:
3545: -- Update urgency and expected resolution date.

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

3592: );
3593:
3594: -- log debug message.
3595: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
3596: fnd_log.string(G_DEBUG_STMT,'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Process_MO_Procedures',
3597: 'After call to Update Service Request :return_status:' || l_return_status);
3598: END IF;
3599:
3600: -- Raise errors if exceptions occur

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

3641: l_summary := fnd_message.get;
3642:
3643: -- log debug message.
3644: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
3645: fnd_log.string(G_DEBUG_STMT,'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Process_MO_Procedures',
3646: 'New Sr Summary is:' || l_summary);
3647: END IF;
3648:
3649: -- get incident type.

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

3733:
3734:
3735: -- log debug message.
3736: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
3737: fnd_log.string(G_DEBUG_STMT,'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Process_MO_Procedures',
3738: 'After call to Create Service Request :return_status:' || l_return_status);
3739: END IF;
3740:
3741: -- Raise errors if exceptions occur

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

3796: );
3797:
3798: -- log debug message.
3799: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
3800: fnd_log.string(G_DEBUG_STMT,'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Process_MO_Procedures',
3801: 'After call to Process_SR_MR_Associations :return_status:' || l_return_status);
3802: fnd_log.string(G_DEBUG_STMT,'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Process_MO_Procedures',
3803: 'systime:Visit Close Date:scheduled_start_date:' || to_char(sysdate, 'DD-MM-YYYY HH24:MI:SS')
3804: || to_char(l_close_date_time, 'DD-MM-YYYY HH24:MI:SS')

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

3798: -- log debug message.
3799: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
3800: fnd_log.string(G_DEBUG_STMT,'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Process_MO_Procedures',
3801: 'After call to Process_SR_MR_Associations :return_status:' || l_return_status);
3802: fnd_log.string(G_DEBUG_STMT,'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Process_MO_Procedures',
3803: 'systime:Visit Close Date:scheduled_start_date:' || to_char(sysdate, 'DD-MM-YYYY HH24:MI:SS')
3804: || to_char(l_close_date_time, 'DD-MM-YYYY HH24:MI:SS')
3805: || to_char(l_scheduled_start_date, 'DD-MM-YYYY HH24:MI:SS'));
3806: END IF;

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

3837: x_msg_data => l_msg_data);
3838:
3839: -- log debug message.
3840: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
3841: fnd_log.string(G_DEBUG_STMT,'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Process_MO_Procedures',
3842: 'After call to Create Task API:return_status:' || l_return_status);
3843: END IF;
3844:
3845: -- Raise errors if exceptions occur

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

3890: END IF;
3891:
3892: -- log debug message.
3893: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
3894: fnd_log.string(G_DEBUG_STMT,'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Process_MO_Procedures',
3895: 'After call to release workorders:return_status:' || l_return_status);
3896: END IF;
3897:
3898: -- Raise errors if exceptions occur

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

3918: p_new_status => 'DEFERRED',
3919: x_return_status => l_return_status);
3920:
3921: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3922: IF (fnd_log.level_error >= G_DEBUG_LEVEL)THEN
3923: fnd_log.string
3924: (
3925: fnd_log.level_error,
3926: 'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Initiate_Mel_Cdl_Approval',

Line 3923: fnd_log.string

3919: x_return_status => l_return_status);
3920:
3921: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3922: IF (fnd_log.level_error >= G_DEBUG_LEVEL)THEN
3923: fnd_log.string
3924: (
3925: fnd_log.level_error,
3926: 'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Initiate_Mel_Cdl_Approval',
3927: 'Can not go ahead with automatic approval because AHL_UMP_NONROUTINES_PVT.Initiate_Mel_Cdl_Approval threw error');

Line 3925: fnd_log.level_error,

3921: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3922: IF (fnd_log.level_error >= G_DEBUG_LEVEL)THEN
3923: fnd_log.string
3924: (
3925: fnd_log.level_error,
3926: 'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Initiate_Mel_Cdl_Approval',
3927: 'Can not go ahead with automatic approval because AHL_UMP_NONROUTINES_PVT.Initiate_Mel_Cdl_Approval threw error');
3928: END IF;
3929: RAISE FND_API.G_EXC_ERROR;

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

3995: );
3996:
3997: -- log debug message.
3998: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
3999: fnd_log.string(G_DEBUG_STMT,'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Process_MO_Procedures',
4000: 'After insert into ahl_unit_deferrals table: deferral ID:' || l_unit_deferral_id);
4001: END IF;
4002:
4003: -- log debug message.

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

4001: END IF;
4002:
4003: -- log debug message.
4004: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
4005: fnd_log.string(G_DEBUG_PROC,'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Process_MO_Procedures',
4006: 'At End of procedure AHL_UMP_NONROUTINES_PVT.Process_MO_Procedures');
4007: END IF;
4008:
4009: END Process_MO_procedures;

Line 4061: FND_LOG.string(G_DEBUG_PROC, l_full_name || '.begin', 'At the start of the API');

4057: --
4058:
4059: BEGIN
4060: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
4061: FND_LOG.string(G_DEBUG_PROC, l_full_name || '.begin', 'At the start of the API');
4062: END IF;
4063:
4064: -- initialize procedure return status to success
4065: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4068: FND_LOG.string(G_DEBUG_STMT, l_full_name, 'the arguments: '||

4064: -- initialize procedure return status to success
4065: x_return_status := FND_API.G_RET_STS_SUCCESS;
4066:
4067: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
4068: FND_LOG.string(G_DEBUG_STMT, l_full_name, 'the arguments: '||
4069: ' p_sr_incident_id > '||p_sr_incident_id||
4070: ', p_commit > '||p_commit);
4071: END IF;
4072:

Line 4093: FND_LOG.string(G_DEBUG_STMT, l_full_name, 'the returned values from AHL_UTILITY_PVT.Get_WF_Process_Name : '||

4089: x_msg_data => l_msg_data,
4090: x_return_status => x_return_status);
4091:
4092: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
4093: FND_LOG.string(G_DEBUG_STMT, l_full_name, 'the returned values from AHL_UTILITY_PVT.Get_WF_Process_Name : '||
4094: ' l_active_flag > '||l_active_flag||
4095: ', l_process_name > '||l_process_name||
4096: ', l_item_type > '||l_item_type||
4097: ', x_return_status > '||x_return_status);

Line 4111: FND_LOG.string(G_DEBUG_STMT, l_full_name,

4107: -- get the subject text
4108: l_subject := FND_MESSAGE.GET_STRING(G_APP_NAME, l_warranty_entl_sbj);
4109:
4110: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
4111: FND_LOG.string(G_DEBUG_STMT, l_full_name,
4112: 'before calling AHL_WF_NOTIFICATION_PVT.Launch_OA_Notification with arguments: '||
4113: ' p_object > '||l_wf_sr_obj||
4114: ', p_process_name > '||l_process_name||
4115: ', p_item_type > '||l_item_type||

Line 4135: FND_LOG.string(G_DEBUG_STMT, l_full_name,

4131: x_item_key => x_item_key,
4132: x_return_status => x_return_status);
4133:
4134: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
4135: FND_LOG.string(G_DEBUG_STMT, l_full_name,
4136: 'after calling AHL_WF_NOTIFICATION_PVT.Launch_OA_Notification, '||
4137: ' x_item_key > '||x_item_key||
4138: ', x_return_status > '||x_return_status);
4139: END IF;

Line 4153: FND_LOG.string(G_DEBUG_PROC, l_full_name || '.end', 'At the end of the API');

4149: COMMIT WORK;
4150: END IF;
4151:
4152: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
4153: FND_LOG.string(G_DEBUG_PROC, l_full_name || '.end', 'At the end of the API');
4154: END IF;
4155:
4156: END Launch_NR_Notification;
4157: --SALOGAN added the following for Complex Mx - End