DBA Data[Home] [Help]

APPS.AHL_UMP_UNITMAINT_PVT dependencies on AHL_UTIL_PKG

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

432: END IF;
433:
434: --AMSRINIV: Bug #4360784
435: -- Tamal: Bug #4207212, #4114368 Begin
436: IF (ahl_util_pkg.is_pm_installed = 'Y')
437: THEN
438: Validate_PM_Input_Parameters (l_mr_id, l_csi_item_instance_id, l_contract_number, l_contract_modifier);
439: ELSE
440: -- JKJain, NR Analysis and Forecasting

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

449: END IF;
450:
451: -- Depending on input parameters call procedures for processing.
452: -- Tamal: Bug #4207212, #4114368 Begin
453: IF (l_contract_number IS NOT NULL and ahl_util_pkg.is_pm_installed = 'Y') THEN
454: -- Process all units affected by the contract number...
455: AHL_UMP_ProcessUnit_PVT.Process_PM_Contracts
456: (
457: p_commit => FND_API.G_TRUE,

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

931: x_return_status := FND_API.G_RET_STS_ERROR;
932: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
933: p_data => x_msg_data,
934: p_encoded => fnd_api.g_false);
935: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);
936:
937:
938: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
939: Rollback to Capture_MR_Updates_pvt;

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

940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
941: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
942: p_data => x_msg_data,
943: p_encoded => fnd_api.g_false);
944: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);
945:
946: WHEN OTHERS THEN
947: Rollback to Capture_MR_Updates_pvt;
948: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

958: END IF;
959: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
960: p_data => x_msg_data,
961: p_encoded => fnd_api.g_false);
962: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);
963:
964: END Capture_MR_Updates;
965:
966: -----------------------------

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

1860: IF (l_temp_status = FALSE) THEN
1861: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1862: END IF;
1863: /* Commented validation of accomplished date to fix bug# 14588580 (avoid data fixes)
1864: IF (AHL_UTIL_PKG.IS_PM_INSTALLED = 'Y') THEN
1865: IF (p_unit_Effectivity_rec.ACCOMPLISHED_DATE < l_last_accomplished_date) THEN
1866: -- Get service request number.
1867: OPEN l_servq_num_csr(p_unit_Effectivity_rec.UNIT_EFFECTIVITY_ID,
1868: 'AHL_UMP_EFF','SR',6);

Line 1891: IF (l_is_not_nr_ue AND AHL_UTIL_PKG.IS_PM_INSTALLED = 'Y') THEN

1887:
1888: -- If TERMINATING or ACCOMPLISHING, ensure that this is the earliest
1889: -- effectivity (nothing outstanding) for the given MR
1890: -- SALOGAN added the condition to skip the following for NR UE - Complex Mx
1891: IF (l_is_not_nr_ue AND AHL_UTIL_PKG.IS_PM_INSTALLED = 'Y') THEN
1892: IF ((p_unit_Effectivity_rec.STATUS_CODE = 'TERMINATED') OR
1893: (p_unit_Effectivity_rec.STATUS_CODE = 'ACCOMPLISHED')) THEN
1894: OPEN l_prior_ue_csr(l_mr_id, l_item_instance_id,l_service_line_id);
1895: FETCH l_prior_ue_csr INTO l_temp_ue_id;