190: If L_LOCATION_ID is null Then
191: Begin
192: select name
193: into l_org_name
194: from hr_all_organization_units
195: where organization_id = rec.organization_id;
196: Exception
197: when no_data_found then
198: l_org_name := Null;