Subhash, over the past thirty years or so we've gotten more bang for our buck with flourescent and other types of lighting that use a fraction of the electricity of traditional tungsten bulbs for the same visual brightness. Many of these light sources have a discontinuous spectrum. Some wave lengths just aren't there wheras traditional light bulbs have all the colors like the sun, but skewed toward the red end of the spectrum. Put an 80 series blue filter and it'll match daylight. Trying to do that with flourescents or the various types of light sources used for street lighting is an exercize in futility.
An FL-D filter will give you fairly believable (but not accurate) color under a variety of flourescents. It's when you start shooting in a typical indoor situation where you have tungsten, flourescent, and perhaps some window light mixed in that things become touch and go. The light color will vary even within the same room.
You can try to overpower the existing light with eleectronic flash, using multiple units around the room to try to give the effect of the natural lighting. That will give you the most accurate color. Use an amateur color film such as Kodak Gold or the Fuji that Walgreens sells under their own name and shy away from the pro films.
Pro films give fantastic color with the lighting they're designed for. They have great flesh tones, and a wedding dress will be white in electronic flash or daylight conditions. Under mixed lighting you're better off with amateur film. Kodak and Fuji understand that the average person knows squat about color temperature, reciprocity failure, discontinuous spectrums, and all that technical rot. That's for engineers and scientists, not Uncle Joe. He just wants to take his film back to Walgreens and pick up a stack of prints with the proverbial "acceptable color", and most of the time that one-hour set-up comes pretty damned close.
In the end though, you're choices really come down to filtering the existing light sources, overpowering the existing light with flash, filtering the flash that you might be using as fill, going crazy at the computer, or pretending that nobody invented color film yet and shoving a roll of Double-X 5222 B&W film in your Leica. (I know you bought some.)
Vivitar made (or used to make anyway) an orange filter for the flash, 85B, that converts the daylight output of the flash to tungsten. These can be adapted to other brands of flash. It costs you about two stops of light but the auto feature of the flash compensates for that. That's not going to help you with window light or flourescents in the mix, or do a complete job in mixed situations, but it'll give you pretty damned good color with tungsten room lighting.