eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_CONTACT_PREFERENCE_VALIDATE dependencies on AS_INTEREST_CODES_B

Line 638: ELSIF p_contact_preference_rec.preference_topic_type = 'AS_INTEREST_CODES_B' THEN

634: FND_MESSAGE.SET_TOKEN( 'TABLE', 'as_interest_types_b' );
635: FND_MSG_PUB.ADD;
636: x_return_status := FND_API.G_RET_STS_ERROR;
637: END;
638: ELSIF p_contact_preference_rec.preference_topic_type = 'AS_INTEREST_CODES_B' THEN
639: BEGIN
640: SELECT 'Y' INTO l_dummy
641: FROM AS_INTEREST_CODES_B
642: WHERE interest_code_id = p_contact_preference_rec.preference_topic_type_id;

Line 641: FROM AS_INTEREST_CODES_B

637: END;
638: ELSIF p_contact_preference_rec.preference_topic_type = 'AS_INTEREST_CODES_B' THEN
639: BEGIN
640: SELECT 'Y' INTO l_dummy
641: FROM AS_INTEREST_CODES_B
642: WHERE interest_code_id = p_contact_preference_rec.preference_topic_type_id;
643: EXCEPTION
644: WHEN NO_DATA_FOUND THEN
645: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );

Line 648: FND_MESSAGE.SET_TOKEN( 'TABLE', 'as_interest_codes_b' );

644: WHEN NO_DATA_FOUND THEN
645: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
646: FND_MESSAGE.SET_TOKEN( 'FK', 'interest_code_id' );
647: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'preference_topic_type_id' );
648: FND_MESSAGE.SET_TOKEN( 'TABLE', 'as_interest_codes_b' );
649: FND_MSG_PUB.ADD;
650: x_return_status := FND_API.G_RET_STS_ERROR;
651: END;
652: /* Bug 3301160, data privacy support */