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_MOSR_VALIDATE_PKG dependencies on FND_MSG_PUB

Line 148: FND_MSG_PUB.ADD;

144: if p_create_update_flag = 'C'
145: then
146: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
147: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system+owner_table_name');
148: FND_MSG_PUB.ADD;
149: x_return_status := FND_API.G_RET_STS_ERROR;
150: end if;
151: else
152: if p_create_update_flag = 'U'

Line 157: FND_MSG_PUB.ADD;

153: then
154: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_DATA_FOUND');
155: FND_MESSAGE.SET_TOKEN('COLUMN','orig_system+owner_table_name');
156: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_MAPPING');
157: FND_MSG_PUB.ADD;
158: x_return_status := FND_API.G_RET_STS_ERROR;
159: end if;
160: end if;
161:

Line 179: FND_MSG_PUB.ADD;

175: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
176: FND_MESSAGE.SET_TOKEN('FK','orig_system');
177: FND_MESSAGE.SET_TOKEN('COLUMN','orig_system');
178: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYSTEMS_B');
179: FND_MSG_PUB.ADD;
180: x_return_status := FND_API.G_RET_STS_ERROR;
181: end if;
182:
183: HZ_UTILITY_V2PUB.validate_lookup (

Line 212: fnd_msg_pub.add;

208: fnd_message.set_token('COLUMN1', 'multiple_flag');
209: fnd_message.set_token('VALUE1', 'N(No)');
210: fnd_message.set_token('COLUMN2', 'multiple_flag');
211: fnd_message.set_token('VALUE2', 'Y(Yes)');
212: fnd_msg_pub.add;
213: x_return_status := FND_API.G_RET_STS_ERROR;
214: end if;
215: else -- other tables
216: open seed_orig_system_exist_csr;

Line 226: fnd_msg_pub.add;

222: fnd_message.set_token('COLUMN1', 'multiple_flag');
223: fnd_message.set_token('VALUE1', 'Y(Yes)');
224: fnd_message.set_token('COLUMN2', 'multiple_flag');
225: fnd_message.set_token('VALUE2', 'N(No)');
226: fnd_msg_pub.add;
227: x_return_status := FND_API.G_RET_STS_ERROR;
228: end if;
229: end if;
230:

Line 266: FND_MSG_PUB.ADD;

262:
263: IF mosr_rec_exists%FOUND then
264: FND_MESSAGE.SET_NAME('AR', 'HZ_SSM_INVALID_MULTIPLE_FLAG');
265: FND_MESSAGE.SET_TOKEN('ENTITY', p_orig_sys_entity_map_rec.owner_table_name);
266: FND_MSG_PUB.ADD;
267: x_return_status := FND_API.G_RET_STS_ERROR;
268: END IF;
269: CLOSE mosr_rec_exists;
270: END IF;

Line 400: FND_MSG_PUB.ADD;

396: then
397: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_DATA_FOUND');
398: FND_MESSAGE.SET_TOKEN('COLUMN','orig_system+owner_table_name');
399: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_MAPPING');
400: FND_MSG_PUB.ADD;
401: x_return_status := FND_API.G_RET_STS_ERROR;
402: end if;
403: */
404:

Line 414: FND_MSG_PUB.ADD;

410: FND_MESSAGE.SET_NAME('AR','HZ_API_INVALID_FK');
411: FND_MESSAGE.SET_TOKEN('FK','orig_system');
412: FND_MESSAGE.SET_TOKEN('COLUMN','orig_system');
413: FND_MESSAGE.SET_TOKEN('TABLE','HZ_ORIG_SYSTEMS_B');
414: FND_MSG_PUB.ADD;
415: -- Bug 5104024
416: x_return_status := fnd_api.g_ret_sts_error;
417: END IF;
418: CLOSE c_active_orig_system_exists;

Line 468: fnd_msg_pub.add;

464: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
465: fnd_message.set_token('FK', 'owner_table_id');
466: fnd_message.set_token('COLUMN', 'party_id');
467: fnd_message.set_token('TABLE', 'hz_parties');
468: fnd_msg_pub.add;
469: x_return_status := fnd_api.g_ret_sts_error;
470: END;
471: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
472: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,

Line 502: fnd_msg_pub.add;

498: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
499: fnd_message.set_token('FK', 'owner_table_id');
500: fnd_message.set_token('COLUMN', 'party_site_id');
501: fnd_message.set_token('TABLE', 'HZ_PARTY_SITES');
502: fnd_msg_pub.add;
503: x_return_status := fnd_api.g_ret_sts_error;
504: END;
505: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
506: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,

Line 537: fnd_msg_pub.add;

533: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
534: fnd_message.set_token('FK', 'owner_table_id');
535: fnd_message.set_token('COLUMN', 'contact_point_id');
536: fnd_message.set_token('TABLE', 'HZ_CONTACT_POINTS');
537: fnd_msg_pub.add;
538: x_return_status := fnd_api.g_ret_sts_error;
539: END;
540: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
541: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,

Line 570: fnd_msg_pub.add;

566: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
567: fnd_message.set_token('FK', 'owner_table_id');
568: fnd_message.set_token('COLUMN', 'cust_account_id');
569: fnd_message.set_token('TABLE', 'HZ_CUST_ACCOUNTS');
570: fnd_msg_pub.add;
571: x_return_status := fnd_api.g_ret_sts_error;
572: END;
573: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
574: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,

Line 603: fnd_msg_pub.add;

599: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
600: fnd_message.set_token('FK', 'owner_table_id');
601: fnd_message.set_token('COLUMN', 'cust_account_role_id');
602: fnd_message.set_token('TABLE', 'HZ_CUST_ACCOUNT_ROLES');
603: fnd_msg_pub.add;
604: x_return_status := fnd_api.g_ret_sts_error;
605: END;
606: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
607: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,

Line 637: fnd_msg_pub.add;

633: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
634: fnd_message.set_token('FK', 'owner_table_id');
635: fnd_message.set_token('COLUMN', 'cust_acct_site_id');
636: fnd_message.set_token('TABLE', 'HZ_CUST_ACCT_SITES_ALL');
637: fnd_msg_pub.add;
638: x_return_status := fnd_api.g_ret_sts_error;
639: END;
640: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
641: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,

Line 671: fnd_msg_pub.add;

667: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
668: fnd_message.set_token('FK', 'owner_table_id');
669: fnd_message.set_token('COLUMN', 'site_use_id');
670: fnd_message.set_token('TABLE', 'HZ_CUST_SITE_USES_ALL');
671: fnd_msg_pub.add;
672: x_return_status := fnd_api.g_ret_sts_error;
673: END;
674: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
675: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,

Line 705: fnd_msg_pub.add;

701: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
702: fnd_message.set_token('FK', 'owner_table_id');
703: fnd_message.set_token('COLUMN', 'location_id');
704: fnd_message.set_token('TABLE', 'HZ_LOCATIONS');
705: fnd_msg_pub.add;
706: x_return_status := fnd_api.g_ret_sts_error;
707: END;
708: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
709: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,

Line 739: fnd_msg_pub.add;

735: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
736: fnd_message.set_token('FK', 'owner_table_id');
737: fnd_message.set_token('COLUMN', 'org_contact_id');
738: fnd_message.set_token('TABLE', 'HZ_ORG_CONTACTS');
739: fnd_msg_pub.add;
740: x_return_status := fnd_api.g_ret_sts_error;
741: END;
742: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
743: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,

Line 773: fnd_msg_pub.add;

769: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
770: fnd_message.set_token('FK', 'owner_table_id');
771: fnd_message.set_token('COLUMN', 'org_contact_role_id');
772: fnd_message.set_token('TABLE', 'HZ_ORG_CONTACT_ROLES');
773: fnd_msg_pub.add;
774: x_return_status := fnd_api.g_ret_sts_error;
775: END;
776: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
777: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,

Line 799: FND_MSG_PUB.ADD;

795: if l_exist = 'Y'
796: then
797: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
798: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system+orig_system_reference+owner_table_name+owner_table_id');
799: FND_MSG_PUB.ADD;
800: x_return_status := FND_API.G_RET_STS_ERROR;
801: end if;
802: end if;
803:

Line 813: FND_MSG_PUB.ADD;

809:
810: then
811: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
812: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system+orig_system_reference+owner_table_name');
813: FND_MSG_PUB.ADD;
814: x_return_status := FND_API.G_RET_STS_ERROR;
815: end if;
816:
817: if p_create_update_flag = 'U'

Line 827: FND_MSG_PUB.ADD;

823: or p_orig_sys_reference_rec.old_orig_system_reference = fnd_api.g_miss_char)
824: then
825: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_DATA_FOUND');
826: FND_MESSAGE.SET_TOKEN('COLUMN','orig_system+orig_system_reference+owner_table_name'); FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');
827: FND_MSG_PUB.ADD;
828: x_return_status := FND_API.G_RET_STS_ERROR;
829: end if;
830:
831: if (p_orig_sys_reference_rec.old_orig_system_reference is not null

Line 840: FND_MSG_PUB.ADD;

836: p_orig_sys_reference_rec.owner_table_name) = 'N'
837: then
838: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_DATA_FOUND');
839: FND_MESSAGE.SET_TOKEN('COLUMN','orig_system+old_orig_system_reference+owner_table_name'); FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');
840: FND_MSG_PUB.ADD;
841: x_return_status := FND_API.G_RET_STS_ERROR;
842: end if;
843: end if;
844:

Line 851: FND_MSG_PUB.ADD;

847: and trunc(p_orig_sys_reference_rec.start_date_active) > trunc(sysdate)) /* Bug 3298896 */
848: then
849: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_FUTURE_DATE_ALLOWED');
850: FND_MESSAGE.SET_TOKEN('COLUMN','start_date_active');
851: FND_MSG_PUB.ADD;
852: x_return_status := FND_API.G_RET_STS_ERROR;
853: end if;
854:
855: if (p_orig_sys_reference_rec.end_date_active is not null

Line 861: FND_MSG_PUB.ADD;

857: and trunc(p_orig_sys_reference_rec.end_date_active) > trunc(sysdate)) /* Bug 3298896 */
858: then
859: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_FUTURE_DATE_ALLOWED');
860: FND_MESSAGE.SET_TOKEN('COLUMN','end_date_active');
861: FND_MSG_PUB.ADD;
862: x_return_status := FND_API.G_RET_STS_ERROR;
863: end if;
864:
865:

Line 971: FND_MSG_PUB.ADD;

967: into l_check_orig_system
968: from dual;
969: if l_check_orig_system is not null then
970: FND_MESSAGE.SET_NAME('AR', 'HZ_SSM_INVALID_SOURCE_SYSTEM');
971: FND_MSG_PUB.ADD;
972: x_return_status := FND_API.G_RET_STS_ERROR;
973: end if;
974:
975: IF p_create_update_flag = 'C' THEN

Line 982: FND_MSG_PUB.ADD;

978: into l_sst_flag, l_created_by_module, l_orig_system, l_orig_system_type;
979: if source_system_exist%FOUND then
980: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
981: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system');
982: FND_MSG_PUB.ADD;
983: x_return_status := FND_API.G_RET_STS_ERROR;
984: end if;
985:
986: HZ_UTILITY_V2PUB.validate_mandatory (

Line 1039: FND_MSG_PUB.ADD;

1035: x_return_status => x_return_status );
1036: END IF; */
1037: IF l_sst_flag = 'Y' and p_orig_sys_rec.sst_flag = 'N' THEN
1038: FND_MESSAGE.SET_NAME('AR','HZ_SST_N_TO_Y_ONLY');
1039: FND_MSG_PUB.ADD;
1040: x_return_status := FND_API.G_RET_STS_ERROR;
1041: END IF;
1042:
1043: IF p_orig_sys_rec.orig_system IS NOT NULL THEN