Not 100% sure on Lowes, but Home Depot's policy is no returns on custom tinted paint (says so right on the label which prints with the color codes).
That being said, a lot of the time, the returns desk/manager will just take it back as opposed to arguing with the customer. Personally I don't think they should, because why should they take back a customized item that you chose just because you don't like it?
Also, regarding the oops paint. This could potentially be a returned item (if as I said the customer complained enough and got them to take it back) but most often is a paint that didn't come out correcly when the paint department was first mixing it (like a color match that the customer didn't like the results of). They will then mix in other tint to change the color so it is completely different from what they were originally making (to prevent customers from asking for a color, saying the don't like it, then waiting for the store to mark it down and buying it anyway).
OP, you mentioned trying to see if they could change the apricot to blue, you should take it back in to the store and ask them. It might not be possible however, because different paint colors start with different bases.
SO is addicted to paint. He is constantly buying paint and painting/repainting our house, and other things. Since oops paints are such a "great" deal he is constantly buying them. We have a detached large storage shed (I call it "the barn"...it is one of those Tuff Sheds Home Depot sells and contracts to have people come out and build on your property...did I mention that SO spends far too much money at Home Depot?) and we probably currently have no less than 30 different cans of paint in there for various projects.
