APPS.HZ_CONTACT_PREFERENCE_VALIDATE dependencies on HZ_PARTY_SITES

Line 371: ELSIF p_contact_preference_rec.contact_level_table = 'HZ_PARTY_SITES' THEN

367: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_parties' );
368: FND_MSG_PUB.ADD;
369: x_return_status := FND_API.G_RET_STS_ERROR;
370: END;
371: ELSIF p_contact_preference_rec.contact_level_table = 'HZ_PARTY_SITES' THEN
372: BEGIN
373: SELECT 'Y' INTO l_dummy
374: FROM HZ_PARTY_SITES
375: WHERE PARTY_SITE_ID = p_contact_preference_rec.contact_level_table_id;

Line 374: FROM HZ_PARTY_SITES

370: END;
371: ELSIF p_contact_preference_rec.contact_level_table = 'HZ_PARTY_SITES' THEN
372: BEGIN
373: SELECT 'Y' INTO l_dummy
374: FROM HZ_PARTY_SITES
375: WHERE PARTY_SITE_ID = p_contact_preference_rec.contact_level_table_id;
376: EXCEPTION
377: WHEN NO_DATA_FOUND THEN
378: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );

Line 381: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_party_sites' );

377: WHEN NO_DATA_FOUND THEN
378: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
379: FND_MESSAGE.SET_TOKEN( 'FK', 'party_site_id' );
380: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'contact_level_table_id' );
381: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_party_sites' );
382: FND_MSG_PUB.ADD;
383: x_return_status := FND_API.G_RET_STS_ERROR;
384: END;
385: ELSIF p_contact_preference_rec.contact_level_table = 'HZ_CONTACT_POINTS' THEN

Line 1150: ELSIF p_contact_preference_rec.contact_level_table = 'HZ_PARTY_SITES'

1146: */
1147: IF p_contact_preference_rec.contact_level_table = 'HZ_PARTIES'
1148: THEN
1149: FND_MESSAGE.SET_NAME('AR','HZ_PARTY_PREFERENCE_OVERLAP');
1150: ELSIF p_contact_preference_rec.contact_level_table = 'HZ_PARTY_SITES'
1151: THEN
1152: FND_MESSAGE.SET_NAME('AR','HZ_PARTY_SITE_PREFER_OVERLAP');
1153: ELSIF p_contact_preference_rec.contact_level_table = 'HZ_CONTACT_POINTS'
1154: THEN

Line 1224: ELSIF l_contact_preference_rec.contact_level_table = 'HZ_PARTY_SITES'

1220: */
1221: IF l_contact_preference_rec.contact_level_table = 'HZ_PARTIES'
1222: THEN
1223: FND_MESSAGE.SET_NAME('AR','HZ_PARTY_PREFERENCE_OVERLAP');
1224: ELSIF l_contact_preference_rec.contact_level_table = 'HZ_PARTY_SITES'
1225: THEN
1226: FND_MESSAGE.SET_NAME('AR','HZ_PARTY_SITE_PREFER_OVERLAP');
1227: ELSIF l_contact_preference_rec.contact_level_table = 'HZ_CONTACT_POINTS'
1228: THEN