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 AHL_UMP_NONROUTINES_PVT

Line 1: PACKAGE BODY AHL_UMP_NONROUTINES_PVT AS

1: PACKAGE BODY AHL_UMP_NONROUTINES_PVT AS
2: /* $Header: AHLVNRTB.pls 120.65.12020000.2 2012/12/13 02:57:01 sareepar ship $ */
3:
4: ------------------------------------
5: -- Common constants and variables --

Line 1599: 'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Initiate_Mel_Cdl_Approval',

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;
1603: RAISE FND_API.G_EXC_ERROR;

Line 1619: 'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Initiate_Mel_Cdl_Approval',

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
1621: );
1622: fnd_log.string
1623: (

Line 1625: 'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Initiate_Mel_Cdl_Approval',

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
1627: );
1628: fnd_log.string
1629: (

Line 1631: 'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Initiate_Mel_Cdl_Approval',

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
1633: );
1634:
1635: END IF;

Line 1643: 'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Initiate_Mel_Cdl_Approval',

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'
1645: );
1646: END IF;
1647: l_active := G_NO_FLAG;

Line 1662: 'ahl.plsql.AHL_UMP_NONROUTINES_PVT.submit_for_approval',

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;
1666: RAISE FND_API.G_EXC_ERROR;

Line 1663: 'Can not go ahead with approval because AHL_UMP_NONROUTINES_PVT.Initiate_Mel_Cdl_Approval threw error'

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;
1666: RAISE FND_API.G_EXC_ERROR;
1667: END IF;

Line 1673: 'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Initiate_Mel_Cdl_Approval',

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
1675: );
1676: END IF;
1677:

Line 1735: 'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Initiate_Mel_Cdl_Approval.end',

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'
1737: );
1738: END IF;
1739:

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 3525: 'At Start of procedure AHL_UMP_NONROUTINES_PVT.Process_MO_Procedures');

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.
3529: OPEN cs_inc_csr(p_cs_incident_id);

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 3926: 'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Initiate_Mel_Cdl_Approval',

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;
3930: END IF;

Line 3927: 'Can not go ahead with automatic approval because AHL_UMP_NONROUTINES_PVT.Initiate_Mel_Cdl_Approval threw error');

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;
3930: END IF;
3931:

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 4006: 'At End of procedure AHL_UMP_NONROUTINES_PVT.Process_MO_Procedures');

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;
4010:

Line 4159: End AHL_UMP_NONROUTINES_PVT;

4155:
4156: END Launch_NR_Notification;
4157: --SALOGAN added the following for Complex Mx - End
4158:
4159: End AHL_UMP_NONROUTINES_PVT;