DBA Data[Home] [Help]

APPS.AHL_VWP_VISITS_PVT dependencies on AHL_UMP_UNPLANNED_PVT

Line 6992: fnd_log.string(fnd_log.level_statement, L_DEBUG, 'About to call AHL_UMP_UNPLANNED_PVT.DELETE_UNIT_EFFECTIVITY with p_unit_effectivity_id = ' || l_ue_id);

6988: LOOP
6989: FETCH c_unplanned_task_UEs INTO l_ue_id;
6990: EXIT WHEN c_unplanned_task_UEs%NOTFOUND;
6991: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
6992: fnd_log.string(fnd_log.level_statement, L_DEBUG, 'About to call AHL_UMP_UNPLANNED_PVT.DELETE_UNIT_EFFECTIVITY with p_unit_effectivity_id = ' || l_ue_id);
6993: END IF;
6994: AHL_UMP_UNPLANNED_PVT.DELETE_UNIT_EFFECTIVITY
6995: (
6996: p_api_version => 1.0,

Line 6994: AHL_UMP_UNPLANNED_PVT.DELETE_UNIT_EFFECTIVITY

6990: EXIT WHEN c_unplanned_task_UEs%NOTFOUND;
6991: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
6992: fnd_log.string(fnd_log.level_statement, L_DEBUG, 'About to call AHL_UMP_UNPLANNED_PVT.DELETE_UNIT_EFFECTIVITY with p_unit_effectivity_id = ' || l_ue_id);
6993: END IF;
6994: AHL_UMP_UNPLANNED_PVT.DELETE_UNIT_EFFECTIVITY
6995: (
6996: p_api_version => 1.0,
6997: p_init_msg_list => FND_API.G_FALSE,
6998: p_commit => FND_API.G_FALSE,

Line 7005: fnd_log.string(fnd_log.level_statement, L_DEBUG, 'Returned from AHL_UMP_UNPLANNED_PVT.DELETE_UNIT_EFFECTIVITY, l_return_status = ' || l_return_status);

7001: x_msg_data => x_msg_data,
7002: p_unit_effectivity_id => l_ue_id
7003: );
7004: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
7005: fnd_log.string(fnd_log.level_statement, L_DEBUG, 'Returned from AHL_UMP_UNPLANNED_PVT.DELETE_UNIT_EFFECTIVITY, l_return_status = ' || l_return_status);
7006: END IF;
7007: IF ((l_msg_count > 0) OR NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS) THEN
7008: CLOSE c_unplanned_task_UEs;
7009: RAISE FND_API.G_EXC_ERROR;