TLD-13498: Updated execption handling for status code 404

[dbshah1212]

Description of change

• Raised proper exception for status_code 404 of the HTTP response and added unittests for the same.

Manual QA steps

• Raising proper exceptions for the wrong URL.

Risks

Rollback steps

• revert this branch

[dbshah1212]

@KAllan357 We just fixed the Bug as part of this PR, detail message handling of all error is committed as part of PR: https://github.com/singer-io/tap-yotpo/pull/13

[dbshah1212]

Won't require as this code got handled in PR: https://github.com/singer-io/tap-yotpo/pull/13/files