12469: Exception
12470: when no_data_found then
12471: Raise Process_next;
12472: End;
12473: -- Get the Location ID from HR_ORGANIZATION_UNITS
12474: IF v_location_id IS NULL THEN
12475: Begin
12476: select location_id
12477: into v_location_id
12474: IF v_location_id IS NULL THEN
12475: Begin
12476: select location_id
12477: into v_location_id
12478: from HR_ORGANIZATION_UNITS
12479: where organization_id = organization_id_mig(i);
12480: Exception
12481: when no_data_found then
12482: Raise Process_next;
12951: Exception
12952: when no_data_found then
12953: Raise Process_next;
12954: End;
12955: -- Get the Location ID from HR_ORGANIZATION_UNITS
12956: IF v_location_id IS NULL THEN
12957: Begin
12958: select location_id
12959: into v_location_id
12956: IF v_location_id IS NULL THEN
12957: Begin
12958: select location_id
12959: into v_location_id
12960: from HR_ORGANIZATION_UNITS
12961: where organization_id = organization_id_mig(i);
12962: Exception
12963: when no_data_found then
12964: Raise Process_next;
13788: Exception
13789: when no_data_found then
13790: Raise Process_next;
13791: End;
13792: -- Get the Location ID from HR_ORGANIZATION_UNITS
13793: IF v_location_id IS NULL THEN
13794: Begin
13795: select location_id
13796: into v_location_id
13793: IF v_location_id IS NULL THEN
13794: Begin
13795: select location_id
13796: into v_location_id
13797: from HR_ORGANIZATION_UNITS
13798: where organization_id = organization_id_mig(i);
13799: Exception
13800: when no_data_found then
13801: Raise Process_next;