Hi shameem,
The results are different. But both results are useful.
If you use +, you are using a local carrier with positive frequency:
cos()+j*sin()=exp[j*()]
If you use -, you are using a local carrier with negative frequency:
cos()-j*sin()=exp[-j*()]
In the first case, the negative part of the passband spectrum of the real-valued signal goes to baseband. In the second case, the positive part does that. Both parts are symmetrical with respect of the other.
Between the two cases, there is an inversion of the baseband spectrum. The results are conjugated in time-domain one of the other.
For instance, imagine that detecting PSK there is a +90 degrees phase change between two consecutive symbols. Using -sin() you get +90 degrees phase change in baseband, but using +sin() you get -90 degrees change in baseband.
Regards
Z