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.51.12010000.3 2008/12/28 00:05:37 sracha ship $ */
3:
4: ------------------------------------
5: -- Common constants and variables --

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

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

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

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
1533: );
1534: fnd_log.string
1535: (

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

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
1539: );
1540: fnd_log.string
1541: (

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

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
1545: );
1546:
1547: END IF;

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

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'
1557: );
1558: END IF;
1559: l_active := G_NO_FLAG;

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

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

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

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

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

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
1587: );
1588: END IF;
1589:

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

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'
1649: );
1650: END IF;
1651:

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

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

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

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

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

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

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;

Line 3751: 'At End of procedure AHL_UMP_NONROUTINES_PVT.Process_MO_Procedures');

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

Line 3756: End AHL_UMP_NONROUTINES_PVT;

3752: END IF;
3753:
3754: END Process_MO_procedures;
3755:
3756: End AHL_UMP_NONROUTINES_PVT;