Fix for crash with LoRA + tp_overlap_comm=false + sequence_parallel=true
# What does this PR do ?

When running LoRA with NeMo 2.0 and setting tp_overlap_comm=false and sequence_parallel=true, training crashes with `RuntimeError: The size of tensor a (4096) must match the size of tensor b (8192) at non-singleton dimension 0`.  This crash occurs because when `tp_overlap_comm=false`:
- ParallelLinearAdapter checks for `tp_overlap_comm_disable_qkv=false` ([this line](https://github.com/NVIDIA/NeMo/blob/9a66eeeac2aa62541476bb4b66ae375b70d2db83/nemo/collections/nlp/modules/common/megatron/adapters/parallel_adapters.py#L259)) and assumes TP overlap is enabled, so it does not disable `self._sequence_parallel`
- LoRA checks `ub_overlap_ag` instead ([this line](https://github.com/NVIDIA/NeMo/blob/9a66eeeac2aa62541476bb4b66ae375b70d2db83/nemo/collections/llm/peft/lora.py#L150)), finds that it is false so TP overlap is disabled, and enables `return_layernorm_output_gathered` for the module.
- Then with both `_sequence_parallel` and `return_layernorm_output_gathered` enabled for this module, a shape mismatch crash occurs.

This PR edits the line in ParallelLinearAdapter to also disable `self._sequence_parallel` if `tp_comm_overlap` is set to false.

++ Folded in #10921 and #10985.

**Collection**: nlp, llm

# Changelog 
- Add specific line by line info of high level changes in this PR.

# Usage
* You can potentially add a usage example below

```python
# Add a code snippet demonstrating how to use this 
```

# GitHub Actions CI

The Jenkins CI system has been replaced by GitHub Actions self-hosted runners.

The GitHub Actions CI will run automatically when the "Run CICD" label is added to the PR.
To re-run CI remove and add the label again.
To run CI on an untrusted fork, a NeMo user with write access must first click "Approve and run".

# Before your PR is "Ready for review"
**Pre checks**:
- [x] Make sure you read and followed [Contributor guidelines](https://github.com/NVIDIA/NeMo/blob/main/CONTRIBUTING.md)
- [ ] Did you write any new necessary tests?
- [ ] Did you add or update any necessary documentation?
- [ ] Does the PR affect components that are optional to install? (Ex: Numba, Pynini, Apex etc)
  - [ ] Reviewer: Does the PR have correct import guards for all optional libraries?
  
**PR Type**:
- [ ] New Feature
- [x] Bugfix
- [ ] Documentation

If you haven't finished some of the above items you can still open "Draft" PR.


## Who can review?

Anyone in the community is free to review the PR once the checks have passed. 
[Contributor guidelines](https://github.com/NVIDIA/NeMo/blob/main/CONTRIBUTING.md) contains specific people who can review PRs to various areas.

# Additional Information
* Related to # (issue)
