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;
224: end if;
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;
224: end if;
225: exit;