1-My Brother said that he IS coming tomorrow.
Since you are talking about tomorrow you can't say was coming tomorrow.
For number two: It depends, are you trying to inform the recipient that your manager doesn't know what the new process is about, or are you telling them that your manager didn't know what the new process is and now she does. I'm guessing you meant to say that your manager has no idea what the new process is, so in that case, the first example would be accurate.
Hope this helps.