DBA Data[Home] [Help]

APPS.AHL_UMP_UNITMAINT_PVT dependencies on AHL_UTIL_PKG

Line 430: IF (ahl_util_pkg.is_pm_installed = 'Y')

426: END IF;
427:
428: --AMSRINIV: Bug #4360784
429: -- Tamal: Bug #4207212, #4114368 Begin
430: IF (ahl_util_pkg.is_pm_installed = 'Y')
431: THEN
432: Validate_PM_Input_Parameters (l_mr_id, l_csi_item_instance_id, l_contract_number, l_contract_modifier);
433: ELSE
434: Validate_Input_Parameters (l_mr_id, l_csi_item_instance_id, l_unit_config_header_id);

Line 446: IF (l_contract_number IS NOT NULL and ahl_util_pkg.is_pm_installed = 'Y') THEN

442: END IF;
443:
444: -- Depending on input parameters call procedures for processing.
445: -- Tamal: Bug #4207212, #4114368 Begin
446: IF (l_contract_number IS NOT NULL and ahl_util_pkg.is_pm_installed = 'Y') THEN
447: -- Process all units affected by the contract number...
448: AHL_UMP_ProcessUnit_PVT.Process_PM_Contracts
449: (
450: p_commit => FND_API.G_TRUE,

Line 776: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);

772: x_return_status := FND_API.G_RET_STS_ERROR;
773: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
774: p_data => x_msg_data,
775: p_encoded => fnd_api.g_false);
776: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);
777:
778:
779: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
780: Rollback to Capture_MR_Updates_pvt;

Line 785: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);

781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
782: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
783: p_data => x_msg_data,
784: p_encoded => fnd_api.g_false);
785: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);
786:
787: WHEN OTHERS THEN
788: Rollback to Capture_MR_Updates_pvt;
789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 798: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);

794: END IF;
795: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
796: p_data => x_msg_data,
797: p_encoded => fnd_api.g_false);
798: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);
799:
800:
801: END Capture_MR_Updates;
802:

Line 1610: IF (AHL_UTIL_PKG.IS_PM_INSTALLED = 'Y') THEN

1606: AHL_UMP_UTIL_PKG.get_last_accomplishment(l_item_instance_id, l_mr_id, l_last_accomplished_date, l_last_ue_id, l_temp_deferral_flag, l_temp_status_code, l_temp_status);
1607: IF (l_temp_status = FALSE) THEN
1608: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1609: END IF;
1610: IF (AHL_UTIL_PKG.IS_PM_INSTALLED = 'Y') THEN
1611: IF (p_unit_Effectivity_rec.ACCOMPLISHED_DATE < l_last_accomplished_date) THEN
1612: -- Get service request number.
1613: OPEN l_servq_num_csr(p_unit_Effectivity_rec.UNIT_EFFECTIVITY_ID,
1614: 'AHL_UMP_EFF','SR',6);

Line 1635: IF (AHL_UTIL_PKG.IS_PM_INSTALLED = 'Y') THEN

1631: -- set of open records.
1632:
1633: -- If TERMINATING or ACCOMPLISHING, ensure that this is the earliest
1634: -- effectivity (nothing outstanding) for the given MR
1635: IF (AHL_UTIL_PKG.IS_PM_INSTALLED = 'Y') THEN
1636: IF ((p_unit_Effectivity_rec.STATUS_CODE = 'TERMINATED') OR
1637: (p_unit_Effectivity_rec.STATUS_CODE = 'ACCOMPLISHED')) THEN
1638: OPEN l_prior_ue_csr(l_mr_id, l_item_instance_id,l_service_line_id);
1639: FETCH l_prior_ue_csr INTO l_temp_ue_id;