try {
<...>
$stmt = $dbh->prepare('insert into housecommonproperty(idprofile,id,`name`,function,area) values (:idprofile,:oid,:oname,:ofunc,:oarea)');
$stmt->bindValue(':idprofile',$idprofile);
foreach($hdata["house_profile_data"]["common_properties"] as $orow) {
  $stmt->bindValue(':oid'  ,$orow["id"]);
  $stmt->bindValue(':oname',$orow["name"]);
  $stmt->bindValue(':ofunc',$orow["function"]);
  $stmt->bindValue(':oarea',$orow["area"]);
  $stmt->execute(); //строка 400
  foreach($orow["rent"] as $ochildrow) {
    $stmt = $dbh->prepare('insert into housecommonpropertyrent (idhousecommonproperty,provider_name,provider_inn,contract_number,contract_date,contract_start_date,cost_per_month,common_meeting_protocol_date,common_meeting_protocol_number) values (:oidcp,:opname,:opinn,:ocnum,:ocdate,:ocstart,:ocost,:ocmpd,:ocmpnum)');
    $stmt->bindValue(':oidcp'  ,$orow["id"]);
    $stmt->bindValue(':opname' ,$ochildrow["provider_name"]);
    $stmt->bindValue(':opinn'  ,$ochildrow["provider_inn"]);
    $stmt->bindValue(':ocnum'  ,$ochildrow["contract_number"]);
    $stmt->bindValue(':ocdate' ,$ochildrow["contract_date"]);
    $stmt->bindValue(':ocstart',$ochildrow["contract_start_date"]);
    $stmt->bindValue(':ocost'  ,$ochildrow["cost_per_month"]);
    $stmt->bindValue(':ocmpd'  ,$ochildrow["common_meeting_protocol_date"]);
    $stmt->bindValue(':ocmpnum',$ochildrow["common_meeting_protocol_number"]);
    $stmt->execute();
    //if (!($stmt->execute())) {$dbh->rollBack(); var_dump($stmt->errorinfo());die();}
  }
}
<...>
  
catch (PDOException $e) {
  echo 'Ошибка: ' . $e->getMessage() . ' на строке '. $e->getLine();
  $stmt->DebugDumpParams();  
}