APPS.HZ_CONTACT_PREFERENCE_VALIDATE dependencies on AMS_SOURCE_CODES

Line 610: IF p_contact_preference_rec.preference_topic_type = 'AMS_SOURCE_CODES' THEN

606: p_prefix =>l_debug_prefix,
607: p_msg_level=>fnd_log.level_statement);
608: END IF;
609:
610: IF p_contact_preference_rec.preference_topic_type = 'AMS_SOURCE_CODES' THEN
611: BEGIN
612: SELECT 'Y' INTO l_dummy
613: FROM AMS_SOURCE_CODES
614: WHERE source_code_id = p_contact_preference_rec.preference_topic_type_id;

Line 613: FROM AMS_SOURCE_CODES

609:
610: IF p_contact_preference_rec.preference_topic_type = 'AMS_SOURCE_CODES' THEN
611: BEGIN
612: SELECT 'Y' INTO l_dummy
613: FROM AMS_SOURCE_CODES
614: WHERE source_code_id = p_contact_preference_rec.preference_topic_type_id;
615: EXCEPTION
616: WHEN NO_DATA_FOUND THEN
617: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );

Line 620: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ams_source_codes' );

616: WHEN NO_DATA_FOUND THEN
617: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
618: FND_MESSAGE.SET_TOKEN( 'FK', 'source_code_id');
619: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'preference_topic_type_id' );
620: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ams_source_codes' );
621: FND_MSG_PUB.ADD;
622: x_return_status := FND_API.G_RET_STS_ERROR;
623: END;
624: ELSIF p_contact_preference_rec.preference_topic_type = 'AS_INTEREST_TYPES_B' THEN