APPS.HZ_CONTACT_PREFERENCE_VALIDATE dependencies on HZ_PARTIES

Line 352: -- contact_level_table_id is foreign key of hz_parties, hz_parties, hz_contact_points

348: p_prefix =>l_debug_prefix,
349: p_msg_level=>fnd_log.level_statement);
350: END IF;
351:
352: -- contact_level_table_id is foreign key of hz_parties, hz_parties, hz_contact_points
353: -- Do not need to check during update because contact_level_table_id is
354: -- non-updateable.
355:
356: IF p_create_update_flag = 'C' THEN

Line 357: IF p_contact_preference_rec.contact_level_table = 'HZ_PARTIES' THEN

353: -- Do not need to check during update because contact_level_table_id is
354: -- non-updateable.
355:
356: IF p_create_update_flag = 'C' THEN
357: IF p_contact_preference_rec.contact_level_table = 'HZ_PARTIES' THEN
358: BEGIN
359: SELECT 'Y' INTO l_dummy
360: FROM HZ_PARTIES
361: WHERE PARTY_ID = p_contact_preference_rec.contact_level_table_id;

Line 360: FROM HZ_PARTIES

356: IF p_create_update_flag = 'C' THEN
357: IF p_contact_preference_rec.contact_level_table = 'HZ_PARTIES' THEN
358: BEGIN
359: SELECT 'Y' INTO l_dummy
360: FROM HZ_PARTIES
361: WHERE PARTY_ID = p_contact_preference_rec.contact_level_table_id;
362: EXCEPTION
363: WHEN NO_DATA_FOUND THEN
364: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );

Line 367: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_parties' );

363: WHEN NO_DATA_FOUND THEN
364: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
365: FND_MESSAGE.SET_TOKEN( 'FK', 'party_id' );
366: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'contact_level_table_id' );
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

Line 1147: IF p_contact_preference_rec.contact_level_table = 'HZ_PARTIES'

1143: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_contact_preferences' );
1144: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'contact_preference_id' );
1145: FND_MESSAGE.SET_TOKEN( 'ID', to_char(l_contact_pref_dup_id) );
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

Line 1221: IF l_contact_preference_rec.contact_level_table = 'HZ_PARTIES'

1217: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_contact_preferences' );
1218: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'contact_preference_id' );
1219: FND_MESSAGE.SET_TOKEN( 'ID', to_char(l_contact_pref_dup_id) );
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