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 HZ_CONTACT_POINTS

Line 177: l_contact_point_type HZ_CONTACT_POINTS.contact_point_type%TYPE;

173: l_preference_start_time_hr NUMBER;
174: l_preference_end_time_hr NUMBER;
175: l_preference_start_time_mi NUMBER;
176: l_preference_end_time_mi NUMBER;
177: l_contact_point_type HZ_CONTACT_POINTS.contact_point_type%TYPE;
178: l_created_by_module HZ_CONTACT_PREFERENCES.created_by_module%TYPE;
179: l_application_id NUMBER;
180: l_dummy VARCHAR2(1);
181: l_tag FND_LOOKUP_VALUES.tag%TYPE;

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 385: ELSIF p_contact_preference_rec.contact_level_table = 'HZ_CONTACT_POINTS' THEN

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
386: BEGIN
387: SELECT 'Y' INTO l_dummy
388: FROM HZ_CONTACT_POINTS
389: WHERE CONTACT_POINT_ID = p_contact_preference_rec.contact_level_table_id;

Line 388: FROM HZ_CONTACT_POINTS

384: END;
385: ELSIF p_contact_preference_rec.contact_level_table = 'HZ_CONTACT_POINTS' THEN
386: BEGIN
387: SELECT 'Y' INTO l_dummy
388: FROM HZ_CONTACT_POINTS
389: WHERE CONTACT_POINT_ID = p_contact_preference_rec.contact_level_table_id;
390: EXCEPTION
391: WHEN NO_DATA_FOUND THEN
392: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );

Line 395: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_contact_points' );

391: WHEN NO_DATA_FOUND THEN
392: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
393: FND_MESSAGE.SET_TOKEN( 'FK', 'contact_point_id' );
394: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'contact_level_table_id' );
395: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_contact_points' );
396: FND_MSG_PUB.ADD;
397: x_return_status := FND_API.G_RET_STS_ERROR;
398: END;
399: END IF;

Line 470: -- if contact_level_table = 'HZ_CONTACT_POINTS' ,

466: END IF;
467:
468: -- check CONTACT_POINT_TYPE
469:
470: -- if contact_level_table = 'HZ_CONTACT_POINTS' ,
471: -- p_contact_preference_rec.contact_type should match with contact_point_type
472:
473: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
474:

Line 475: IF p_contact_preference_rec.contact_level_table = 'HZ_CONTACT_POINTS' THEN

471: -- p_contact_preference_rec.contact_type should match with contact_point_type
472:
473: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
474:
475: IF p_contact_preference_rec.contact_level_table = 'HZ_CONTACT_POINTS' THEN
476: select contact_point_type,
477: decode(contact_point_type, 'PHONE', 'CALL', 'FAX', 'FAX',
478: 'SMS', 'SMS', 'EMAIL','EMAIL', 'TLX', 'TLX', 'EDI', 'EDI', contact_point_type)
479: into l_contact_point_type, l_correct_contact_type

Line 480: FROM HZ_CONTACT_POINTS

476: select contact_point_type,
477: decode(contact_point_type, 'PHONE', 'CALL', 'FAX', 'FAX',
478: 'SMS', 'SMS', 'EMAIL','EMAIL', 'TLX', 'TLX', 'EDI', 'EDI', contact_point_type)
479: into l_contact_point_type, l_correct_contact_type
480: FROM HZ_CONTACT_POINTS
481: WHERE contact_point_id = p_contact_preference_rec.contact_level_table_id;
482:
483: IF p_contact_preference_rec.contact_type = 'MAIL' OR
484: p_contact_preference_rec.contact_type = 'VISIT' THEN

Line 487: FND_MESSAGE.SET_TOKEN( 'CONTACT_LEVEL_TABLE', 'hz_contact_points' );

483: IF p_contact_preference_rec.contact_type = 'MAIL' OR
484: p_contact_preference_rec.contact_type = 'VISIT' THEN
485: FND_MESSAGE.SET_NAME( 'AR', 'HZ_INVALID_CONTACT_LEVEL_TABLE' );
486: FND_MESSAGE.SET_TOKEN( 'CONTACT_TYPE', 'MAIL/VISIT' );
487: FND_MESSAGE.SET_TOKEN( 'CONTACT_LEVEL_TABLE', 'hz_contact_points' );
488: FND_MSG_PUB.ADD;
489: x_return_status := FND_API.G_RET_STS_ERROR;
490:
491: ELSIF p_contact_preference_rec.contact_type <> l_correct_contact_type AND

Line 504: hz_utility_v2pub.debug(p_message=>'if contact_level_table is HZ_CONTACT_POINTS ' ||

500: END IF;
501: END IF;
502:
503: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
504: hz_utility_v2pub.debug(p_message=>'if contact_level_table is HZ_CONTACT_POINTS ' ||
505: 'p_contact_preference_rec.contact_type should match with contact_point_type' ||
506: 'x_return_status = ' || x_return_status,
507: p_prefix =>l_debug_prefix,
508: p_msg_level=>fnd_log.level_statement);

Line 1153: ELSIF p_contact_preference_rec.contact_level_table = 'HZ_CONTACT_POINTS'

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
1155: FND_MESSAGE.SET_NAME('AR','HZ_CONTACT_POINT_PREF_OVERLAP');
1156: END IF;
1157:

Line 1227: ELSIF l_contact_preference_rec.contact_level_table = 'HZ_CONTACT_POINTS'

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
1229: FND_MESSAGE.SET_NAME('AR','HZ_CONTACT_POINT_PREF_OVERLAP');
1230: END IF;
1231: