APPS.CSM_PARTY_ASSIGNMENT_PKG dependencies on HZ_PARTY_SITES
Line 48: FROM hz_party_sites hps
44: THEN
45:
46: SELECT COUNT(1)
47: INTO l_chk_party_site 48: FROM hz_party_sites hps 49: WHERE hps.party_id = p_party_id
50: AND hps.party_site_id = p_party_site_id;
51:
52: END IF;
Line 66: x_error_message := 'The party site records does not exists in the HZ PARTY SITES base table for the party - '||p_party_id|| ' and site -'||p_party_site_id;
62: ELSIF l_chk_party_site = 0
63:
64: THEN
65: 66: x_error_message := 'The party site records does not exists in the HZ PARTY SITES base table for the party - '||p_party_id|| ' and site -'||p_party_site_id; 67:
68: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
69:
70: END IF;