SNR calculation with Noise Spectral Density
The comment above already gave you a roadmap to get to an answer, but I'll flesh it out a bit:


SNR is the ratio of signal power to noise power. To calculate the signal power at your receiver, you'll need to take the path loss and fading model into account, as you noted.
The noise power at the receiver is described by a (flat) noise power spectral density and receiver bandwidth. To calculate the total noise power over that bandwidth, you simply multiply the amount of power per Hertz times the width of the band. When power is specified in logarithmic units (dB), you need to first convert it to a linear scale. Recall the relationship between mW and dBm:
$$
P|_{dBm} = 10 \log_{10}\left(\frac{P}{1\text{ mW}}\right)
$$

That is, to convert a linear-scale power quantity to dBm, take ten times the base-10 logarithm of the ratio of that power quantity to 1 milliwatt. For example:


30 dBm: 1 W
0 dBm: 1 mW
-30 dBm: 1 uW
-60 dBm: 1 nW
-90 dBm: 1 pW


To go the other way, invert the calculation:
$$
P = 10^{\frac{P|_{dBm}}{10}} * 1\text{ mW}
$$
So, to calculate the total noise power at your receiver, you would convert the noise power spectral density to linear units using the above equation:
$$
S_n = 10^{\frac{-174}{10}} \frac{\text{mW}}{\text{Hz}} = 3.981 * 10^{-18} \frac{\text{mW}}{\text{Hz}}
$$
then multiply by the bandwidth to get the total amount of noise power:
$$
P_n = BS_n = \left(10 * 10^{6}\text{ Hz}\right)\left(3.981 * 10^{-18} \frac{\text{mW}}{\text{Hz}}\right)
$$
$$
P_n = 3.981 * 10^{-11} \text{ mW}
$$


Then, use your model to predict the received signal power, take the ratio, and you've got your SNR.