215: if (locationName%notfound) then
216: raise no_data_found;
217: end if;
218: Close locationName;
219: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
220: FND_MESSAGE.Set_Name('JTF', 'JTF_DELETE_LOC_AREA');
221: FND_MESSAGE.Set_Token('AREA', l_loc_area_name, FALSE);
222: FND_MSG_PUB.ADD;
223: END IF;
218: Close locationName;
219: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
220: FND_MESSAGE.Set_Name('JTF', 'JTF_DELETE_LOC_AREA');
221: FND_MESSAGE.Set_Token('AREA', l_loc_area_name, FALSE);
222: FND_MSG_PUB.ADD;
223: END IF;
224: end if;
225: exit;
226: end loop;
224: end if;
225: exit;
226: end loop;
227:
228: FND_MSG_PUB.Count_And_Get(
229: p_count => x_msg_count,
230: p_data => x_msg_data);
231: end if;
232: