Self consistent theory of fluctuations near D-dimensional superconducting phase transitions