[Home] [Help]
2118: IF l_Visit_rec.visit_type_code IS NOT NULL
2119: AND l_Visit_rec.visit_type_code <> FND_API.G_MISS_CHAR THEN
2120:
2121: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2122: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_VWP_TASKS_PVT.ASSOCIATE_DEFAULT_MRS');
2123: END IF;
2124:
2125: AHL_VWP_TASKS_PVT.ASSOCIATE_DEFAULT_MRS
2126: (
2121: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2122: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_VWP_TASKS_PVT.ASSOCIATE_DEFAULT_MRS');
2123: END IF;
2124:
2125: AHL_VWP_TASKS_PVT.ASSOCIATE_DEFAULT_MRS
2126: (
2127: p_api_version => 1.0,
2128: x_return_status => x_return_status,
2129: x_msg_count => x_msg_count,
2131: p_visit_rec => l_Visit_rec
2132: );
2133:
2134: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2135: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling AHL_VWP_TASKS_PVT.ASSOCIATE_DEFAULT_MRS - x_return_status : '||x_return_status);
2136: END IF;
2137:
2138: --Standard check to count messages
2139: l_msg_count := Fnd_Msg_Pub.count_msg;
4171: FETCH c_Tasks_csr INTO l_tasks_rec;
4172: EXIT WHEN c_Tasks_csr%NOTFOUND;
4173:
4174: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4175: fnd_log.string (fnd_log.level_statement,L_DEBUG,'Before calling AHL_VWP_TASKS_PVT.Delete_Task - visit_task_id : '||l_tasks_rec.visit_task_id);
4176: END IF;
4177:
4178: l_soft_delete_flag := 'Y'; -- If tasks are set only soft delete needs to be done.
4179:
4177:
4178: l_soft_delete_flag := 'Y'; -- If tasks are set only soft delete needs to be done.
4179:
4180: -- Call Delete_Task to remove all the task associations for the deleted task
4181: AHL_VWP_TASKS_PVT.Delete_Task
4182: ( p_api_version => p_api_version,
4183: p_init_msg_list => l_init_msg_list,
4184: p_commit => l_commit,
4185: p_validation_level => p_validation_level,