DBA Data[Home] [Help]

APPS.CSM_PARTY_ASSIGNMENT_PKG dependencies on HZ_PARTIES

Line 39: FROM hz_parties hp

35: THEN
36:
37: SELECT COUNT(1)
38: INTO l_chk_party
39: FROM hz_parties hp
40: WHERE hp.party_id = p_party_id;
41:
42: ELSIF l_party_site_id <> -1
43:

Line 58: x_error_message := 'The party records does not exists in the HZ PARTIES base table for the party - '||p_party_id;

54: IF l_chk_party = 0
55:
56: THEN
57:
58: x_error_message := 'The party records does not exists in the HZ PARTIES base table for the party - '||p_party_id;
59:
60: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
61:
62: ELSIF l_chk_party_site = 0