what I want to know is that my PSU is 850 w platinum and the apc is 1100 va. The apc guy said that I have to get the ups which is 900 w or at 1500va for it to work and the transformer won't take much of heat. Is this true?
Yes
If you have a 850W PSU and you only have a UPS thats <850W (ex. a UPS thats 700W only), when your computer reaches 700W it will blow up the UPS but not the PSU.
Its the weakest link that will blow up first, same is true for PSU (i.e. 700W PSU and 850W UPS but your power consumption from your PC reaches 700W, then PSU will blow).
Just a quick glance at your specs I can tell that 850W is already fine but you might want to get
BOTH a higher wattage UPS and PSU (1000W at least)
IF you plan to upgrade your GPU to a Nvidia RTX 30 series and above because
they are power hungry and have high voltage transient spikes.
Also the higher your wattage capacity but the lower your actual power consumption, the less heat that your PSU and UPS generates (i.e. lets say 500W actual power consumption but you have a 850W PSU and UPS - so you have 350W of extra headroom left. If you have a 1000W PSU with the same amount of 500W actual power consumption, then you have more extra headroom of 500W. It also allows you to install more powerful components if you desire in the future).
And if you're following the NEC rule standards, don't run a continuous load of more than 80% of your max wattage capacity (since PSU is a branched circuit). So assuming you have a 850W PSU and 850W UPS, your system's total power consumption should not exceed more than 680W for safety.