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 FND_MSG_PUB

Line 92: FND_MSG_PUB.ADD;

88:
89: IF l_error THEN
90: FND_MESSAGE.SET_NAME( 'AR', 'HZ_NONUPDATEABLE_PREF_DATE' );
91: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
92: FND_MSG_PUB.ADD;
93: x_return_status := FND_API.G_RET_STS_ERROR;
94: END IF;
95:
96: END preference_date_nonupdateable;

Line 216: FND_MSG_PUB.ADD;

212: WHERE CONTACT_PREFERENCE_ID = p_contact_preference_rec.contact_preference_id;
213:
214: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
215: FND_MESSAGE.SET_TOKEN('COLUMN', 'contact_preference_id');
216: FND_MSG_PUB.ADD;
217: x_return_status := FND_API.G_RET_STS_ERROR;
218: EXCEPTION
219: WHEN NO_DATA_FOUND THEN
220: NULL;

Line 368: FND_MSG_PUB.ADD;

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
372: BEGIN

Line 382: FND_MSG_PUB.ADD;

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
386: BEGIN

Line 396: FND_MSG_PUB.ADD;

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;
400: END IF;

Line 488: FND_MSG_PUB.ADD;

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
492: not ( p_contact_preference_rec.contact_type in ('CALL' , 'FAX') AND l_correct_contact_type in ( 'FAX', 'CALL')) THEN

Line 497: FND_MSG_PUB.ADD;

493: FND_MESSAGE.SET_NAME( 'AR', 'HZ_INVALID_CONTACT_TYPE' );
494: FND_MESSAGE.SET_TOKEN( 'INCORRECT_CONTACT_TYPE', p_contact_preference_rec.contact_type );
495: FND_MESSAGE.SET_TOKEN( 'CORRECT_CONTACT_TYPE', l_correct_contact_type );
496: FND_MESSAGE.SET_TOKEN( 'CONTACT_POINT_TYPE', l_contact_point_type);
497: FND_MSG_PUB.ADD;
498: x_return_status := FND_API.G_RET_STS_ERROR;
499: END IF;
500: END IF;
501: END IF;

Line 621: FND_MSG_PUB.ADD;

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
625: BEGIN

Line 635: FND_MSG_PUB.ADD;

631: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
632: FND_MESSAGE.SET_TOKEN( 'FK', 'interest_type_id');
633: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'preference_topic_type_id' );
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

Line 649: FND_MSG_PUB.ADD;

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 */
653: /* Removed the above as the design will change */

Line 760: FND_MSG_PUB.ADD;

756: p_contact_preference_rec.preference_end_date <> FND_API.G_MISS_DATE AND
757: trunc(p_contact_preference_rec.preference_end_date) < trunc(sysdate) THEN
758: FND_MESSAGE.SET_NAME( 'AR', 'HZ_INVALID_PREFERENCE_END_DATE' );
759: FND_MESSAGE.SET_TOKEN( 'PREFERENCE_END_DATE', to_char(p_contact_preference_rec.preference_end_date) );
760: FND_MSG_PUB.ADD;
761: x_return_status := FND_API.G_RET_STS_ERROR;
762: END IF;
763:
764: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 834: FND_MSG_PUB.ADD;

830: p_contact_preference_rec.preference_start_time_hr <> FND_API.G_MISS_NUM THEN
831: IF p_contact_preference_rec.preference_start_time_hr < 0 OR
832: p_contact_preference_rec.preference_start_time_hr > 23 THEN
833: FND_MESSAGE.SET_NAME( 'AR', 'HZ_INVALID_PREFERENCE_TIME' );
834: FND_MSG_PUB.ADD;
835: x_return_status := FND_API.G_RET_STS_ERROR;
836: l_time_comparison := FND_API.G_FALSE;
837: END IF;
838: ELSE

Line 846: FND_MSG_PUB.ADD;

842: p_contact_preference_rec.preference_end_time_hr <> FND_API.G_MISS_NUM THEN
843: IF p_contact_preference_rec.preference_end_time_hr < 0 OR
844: p_contact_preference_rec.preference_end_time_hr > 23 THEN
845: FND_MESSAGE.SET_NAME( 'AR', 'HZ_INVALID_PREFERENCE_TIME' );
846: FND_MSG_PUB.ADD;
847: x_return_status := FND_API.G_RET_STS_ERROR;
848: l_time_comparison := FND_API.G_FALSE;
849: END IF;
850: ELSE

Line 857: FND_MSG_PUB.ADD;

853:
854: IF l_time_comparison = FND_API.G_TRUE THEN
855: IF p_contact_preference_rec.preference_end_time_hr < p_contact_preference_rec.preference_start_time_hr THEN
856: FND_MESSAGE.SET_NAME( 'AR', 'HZ_INVALID_PREFERENCE_TIME' );
857: FND_MSG_PUB.ADD;
858: x_return_status := FND_API.G_RET_STS_ERROR;
859: l_time_comparison := FND_API.G_FALSE;
860: ELSIF p_contact_preference_rec.preference_end_time_hr > p_contact_preference_rec.preference_start_time_hr THEN
861: l_time_comparison := FND_API.G_FALSE;

Line 876: FND_MSG_PUB.ADD;

872: p_contact_preference_rec.preference_start_time_mi <> FND_API.G_MISS_NUM THEN
873: IF p_contact_preference_rec.preference_start_time_mi < 0 OR
874: p_contact_preference_rec.preference_start_time_mi > 59 THEN
875: FND_MESSAGE.SET_NAME( 'AR', 'HZ_INVALID_PREFERENCE_TIME' );
876: FND_MSG_PUB.ADD;
877: x_return_status := FND_API.G_RET_STS_ERROR;
878: l_time_comparison := FND_API.G_FALSE;
879: END IF;
880: ELSE

Line 888: FND_MSG_PUB.ADD;

884: p_contact_preference_rec.preference_end_time_mi <> FND_API.G_MISS_NUM THEN
885: IF p_contact_preference_rec.preference_end_time_mi < 0 OR
886: p_contact_preference_rec.preference_end_time_mi > 59 THEN
887: FND_MESSAGE.SET_NAME( 'AR', 'HZ_INVALID_PREFERENCE_TIME' );
888: FND_MSG_PUB.ADD;
889: x_return_status := FND_API.G_RET_STS_ERROR;
890: l_time_comparison := FND_API.G_FALSE;
891: END IF;
892: ELSE

Line 899: FND_MSG_PUB.ADD;

895:
896: IF l_time_comparison = FND_API.G_TRUE THEN
897: IF p_contact_preference_rec.preference_end_time_mi < p_contact_preference_rec.preference_start_time_mi THEN
898: FND_MESSAGE.SET_NAME( 'AR', 'HZ_INVALID_PREFERENCE_TIME' );
899: FND_MSG_PUB.ADD;
900: x_return_status := FND_API.G_RET_STS_ERROR;
901: l_time_comparison := FND_API.G_FALSE;
902: END IF;
903: END IF;

Line 1069: FND_MSG_PUB.ADD;

1065: p_contact_preference_rec.status <> 'A' THEN
1066: IF p_contact_preference_rec.preference_end_date is not null AND
1067: to_char(p_contact_preference_rec.preference_end_date,'DD-MON-YY') <> to_char(sysdate, 'DD-MON-YY') THEN
1068: FND_MESSAGE.SET_NAME( 'AR', 'HZ_CP_INVALID_END_DATE' );
1069: FND_MSG_PUB.ADD;
1070: END IF;
1071: END IF;
1072:
1073: --------------------------------------

Line 1158: FND_MSG_PUB.ADD;

1154: THEN
1155: FND_MESSAGE.SET_NAME('AR','HZ_CONTACT_POINT_PREF_OVERLAP');
1156: END IF;
1157:
1158: FND_MSG_PUB.ADD;
1159: x_return_status := FND_API.G_RET_STS_ERROR;
1160: EXCEPTION
1161: WHEN NO_DATA_FOUND THEN
1162: NULL;

Line 1232: FND_MSG_PUB.ADD;

1228: THEN
1229: FND_MESSAGE.SET_NAME('AR','HZ_CONTACT_POINT_PREF_OVERLAP');
1230: END IF;
1231:
1232: FND_MSG_PUB.ADD;
1233: x_return_status := FND_API.G_RET_STS_ERROR;
1234: EXCEPTION
1235: WHEN NO_DATA_FOUND THEN
1236: NULL;