138: END IF;
139:
140: -- This API updates all the reservation dates, if l_requested_date
141: -- and requested_date in AHL_SCHEDULE_MATERIALS table are different
142: AHL_RSV_RESERVATIONS_PVT.Update_Reservation(
143: p_api_version => 1.0,
144: p_init_msg_list => FND_API.G_FALSE,
145: p_commit => FND_API.G_FALSE,
146: p_module_type => NULL,
154: IF (l_log_statement >= l_log_current_level)THEN
155: fnd_log.string
156: (
157: fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
158: 'Returned success from AHL_RSV_RESERVATIONS_PVT.Update_Reservation'
159: );
160: END IF;
161: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
162: RAISE FND_API.G_EXC_ERROR;