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_MESSAGE

Line 146: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');

142: p_orig_sys_entity_map_rec.owner_table_name/*,null*/) = 'Y'
143: then
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;

Line 147: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system+owner_table_name');

143: then
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

Line 154: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_DATA_FOUND');

150: end if;
151: else
152: if p_create_update_flag = 'U'
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;

Line 155: FND_MESSAGE.SET_TOKEN('COLUMN','orig_system+owner_table_name');

151: else
152: if p_create_update_flag = 'U'
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;

Line 156: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_MAPPING');

152: if p_create_update_flag = 'U'
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;

Line 175: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');

171: */
172: open orig_system_exist;
173: fetch orig_system_exist into l_orig_sys;
174: if orig_system_exist%notfound then
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;

Line 176: FND_MESSAGE.SET_TOKEN('FK','orig_system');

172: open orig_system_exist;
173: fetch orig_system_exist into l_orig_sys;
174: if orig_system_exist%notfound then
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;

Line 177: FND_MESSAGE.SET_TOKEN('COLUMN','orig_system');

173: fetch orig_system_exist into l_orig_sys;
174: if orig_system_exist%notfound then
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;

Line 178: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYSTEMS_B');

174: if orig_system_exist%notfound then
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:

Line 207: fnd_message.set_name('AR', 'HZ_API_VAL_DEP_FIELDS');

203: 'HZ_CUST_ACCOUNT_ROLES', 'HZ_CUST_SITE_USES_ALL')
204: then
205: if p_orig_sys_entity_map_rec.multiple_flag = 'N'
206: then
207: fnd_message.set_name('AR', 'HZ_API_VAL_DEP_FIELDS');
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)');

Line 208: fnd_message.set_token('COLUMN1', 'multiple_flag');

204: then
205: if p_orig_sys_entity_map_rec.multiple_flag = 'N'
206: then
207: fnd_message.set_name('AR', 'HZ_API_VAL_DEP_FIELDS');
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;

Line 209: fnd_message.set_token('VALUE1', 'N(No)');

205: if p_orig_sys_entity_map_rec.multiple_flag = 'N'
206: then
207: fnd_message.set_name('AR', 'HZ_API_VAL_DEP_FIELDS');
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;

Line 210: fnd_message.set_token('COLUMN2', 'multiple_flag');

206: then
207: fnd_message.set_name('AR', 'HZ_API_VAL_DEP_FIELDS');
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;

Line 211: fnd_message.set_token('VALUE2', 'Y(Yes)');

207: fnd_message.set_name('AR', 'HZ_API_VAL_DEP_FIELDS');
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

Line 221: fnd_message.set_name('AR', 'HZ_API_VAL_DEP_FIELDS');

217: fetch seed_orig_system_exist_csr into l_exist;
218: close seed_orig_system_exist_csr;
219: if l_exist <> 'Y' and p_orig_sys_entity_map_rec.multiple_flag = 'Y'
220: then
221: fnd_message.set_name('AR', 'HZ_API_VAL_DEP_FIELDS');
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)');

Line 222: fnd_message.set_token('COLUMN1', 'multiple_flag');

218: close seed_orig_system_exist_csr;
219: if l_exist <> 'Y' and p_orig_sys_entity_map_rec.multiple_flag = 'Y'
220: then
221: fnd_message.set_name('AR', 'HZ_API_VAL_DEP_FIELDS');
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;

Line 223: fnd_message.set_token('VALUE1', 'Y(Yes)');

219: if l_exist <> 'Y' and p_orig_sys_entity_map_rec.multiple_flag = 'Y'
220: then
221: fnd_message.set_name('AR', 'HZ_API_VAL_DEP_FIELDS');
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;

Line 224: fnd_message.set_token('COLUMN2', 'multiple_flag');

220: then
221: fnd_message.set_name('AR', 'HZ_API_VAL_DEP_FIELDS');
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;

Line 225: fnd_message.set_token('VALUE2', 'N(No)');

221: fnd_message.set_name('AR', 'HZ_API_VAL_DEP_FIELDS');
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;

Line 264: FND_MESSAGE.SET_NAME('AR', 'HZ_SSM_INVALID_MULTIPLE_FLAG');

260: OPEN mosr_rec_exists;
261: FETCH mosr_rec_exists INTO l_dummy;
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;

Line 265: FND_MESSAGE.SET_TOKEN('ENTITY', p_orig_sys_entity_map_rec.owner_table_name);

261: FETCH mosr_rec_exists INTO l_dummy;
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;

Line 397: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_DATA_FOUND');

393: /* -- Make sure passing in orig_system and owner_table_name are validate
394: if orig_sys_entity_map_exist(p_orig_sys_reference_rec.orig_system,
395: p_orig_sys_reference_rec.owner_table_name/*,'A'*//*) = 'N'
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;

Line 398: FND_MESSAGE.SET_TOKEN('COLUMN','orig_system+owner_table_name');

394: if orig_sys_entity_map_exist(p_orig_sys_reference_rec.orig_system,
395: p_orig_sys_reference_rec.owner_table_name/*,'A'*//*) = 'N'
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;

Line 399: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_MAPPING');

395: p_orig_sys_reference_rec.owner_table_name/*,'A'*//*) = 'N'
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: */

Line 410: FND_MESSAGE.SET_NAME('AR','HZ_API_INVALID_FK');

406:
407: OPEN c_active_orig_system_exists;
408: FETCH c_active_orig_system_exists INTO l_temp;
409: IF c_active_orig_system_exists%notFOUND THEN
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;

Line 411: FND_MESSAGE.SET_TOKEN('FK','orig_system');

407: OPEN c_active_orig_system_exists;
408: FETCH c_active_orig_system_exists INTO l_temp;
409: IF c_active_orig_system_exists%notFOUND THEN
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

Line 412: FND_MESSAGE.SET_TOKEN('COLUMN','orig_system');

408: FETCH c_active_orig_system_exists INTO l_temp;
409: IF c_active_orig_system_exists%notFOUND THEN
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;

Line 413: FND_MESSAGE.SET_TOKEN('TABLE','HZ_ORIG_SYSTEMS_B');

409: IF c_active_orig_system_exists%notFOUND THEN
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;

Line 464: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

460: FROM HZ_PARTIES
461: WHERE PARTY_ID = p_orig_sys_reference_rec.owner_table_id;
462: EXCEPTION
463: WHEN NO_DATA_FOUND THEN
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;

Line 465: fnd_message.set_token('FK', 'owner_table_id');

461: WHERE PARTY_ID = p_orig_sys_reference_rec.owner_table_id;
462: EXCEPTION
463: WHEN NO_DATA_FOUND THEN
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;

Line 466: fnd_message.set_token('COLUMN', 'party_id');

462: EXCEPTION
463: WHEN NO_DATA_FOUND THEN
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;

Line 467: fnd_message.set_token('TABLE', 'hz_parties');

463: WHEN NO_DATA_FOUND THEN
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

Line 498: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

494: FROM HZ_PARTY_SITES
495: WHERE party_site_id = p_orig_sys_reference_rec.owner_table_id;
496: EXCEPTION
497: WHEN NO_DATA_FOUND THEN
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;

Line 499: fnd_message.set_token('FK', 'owner_table_id');

495: WHERE party_site_id = p_orig_sys_reference_rec.owner_table_id;
496: EXCEPTION
497: WHEN NO_DATA_FOUND THEN
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;

Line 500: fnd_message.set_token('COLUMN', 'party_site_id');

496: EXCEPTION
497: WHEN NO_DATA_FOUND THEN
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;

Line 501: fnd_message.set_token('TABLE', 'HZ_PARTY_SITES');

497: WHEN NO_DATA_FOUND THEN
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

Line 533: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

529: FROM HZ_CONTACT_POINTS
530: WHERE contact_point_id = p_orig_sys_reference_rec.owner_table_id;
531: EXCEPTION
532: WHEN NO_DATA_FOUND THEN
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;

Line 534: fnd_message.set_token('FK', 'owner_table_id');

530: WHERE contact_point_id = p_orig_sys_reference_rec.owner_table_id;
531: EXCEPTION
532: WHEN NO_DATA_FOUND THEN
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;

Line 535: fnd_message.set_token('COLUMN', 'contact_point_id');

531: EXCEPTION
532: WHEN NO_DATA_FOUND THEN
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;

Line 536: fnd_message.set_token('TABLE', 'HZ_CONTACT_POINTS');

532: WHEN NO_DATA_FOUND THEN
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

Line 566: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

562: FROM HZ_CUST_ACCOUNTS
563: WHERE cust_account_id = p_orig_sys_reference_rec.owner_table_id;
564: EXCEPTION
565: WHEN NO_DATA_FOUND THEN
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;

Line 567: fnd_message.set_token('FK', 'owner_table_id');

563: WHERE cust_account_id = p_orig_sys_reference_rec.owner_table_id;
564: EXCEPTION
565: WHEN NO_DATA_FOUND THEN
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;

Line 568: fnd_message.set_token('COLUMN', 'cust_account_id');

564: EXCEPTION
565: WHEN NO_DATA_FOUND THEN
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;

Line 569: fnd_message.set_token('TABLE', 'HZ_CUST_ACCOUNTS');

565: WHEN NO_DATA_FOUND THEN
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

Line 599: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

595: FROM HZ_CUST_ACCOUNT_ROLES
596: WHERE cust_account_role_id = p_orig_sys_reference_rec.owner_table_id;
597: EXCEPTION
598: WHEN NO_DATA_FOUND THEN
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;

Line 600: fnd_message.set_token('FK', 'owner_table_id');

596: WHERE cust_account_role_id = p_orig_sys_reference_rec.owner_table_id;
597: EXCEPTION
598: WHEN NO_DATA_FOUND THEN
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;

Line 601: fnd_message.set_token('COLUMN', 'cust_account_role_id');

597: EXCEPTION
598: WHEN NO_DATA_FOUND THEN
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;

Line 602: fnd_message.set_token('TABLE', 'HZ_CUST_ACCOUNT_ROLES');

598: WHEN NO_DATA_FOUND THEN
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

Line 633: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

629: FROM HZ_CUST_ACCT_SITES_ALL -- Bug 3730175
630: WHERE cust_acct_site_id = p_orig_sys_reference_rec.owner_table_id;
631: EXCEPTION
632: WHEN NO_DATA_FOUND THEN
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;

Line 634: fnd_message.set_token('FK', 'owner_table_id');

630: WHERE cust_acct_site_id = p_orig_sys_reference_rec.owner_table_id;
631: EXCEPTION
632: WHEN NO_DATA_FOUND THEN
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;

Line 635: fnd_message.set_token('COLUMN', 'cust_acct_site_id');

631: EXCEPTION
632: WHEN NO_DATA_FOUND THEN
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;

Line 636: fnd_message.set_token('TABLE', 'HZ_CUST_ACCT_SITES_ALL');

632: WHEN NO_DATA_FOUND THEN
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

Line 667: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

663: FROM HZ_CUST_SITE_USES_ALL
664: WHERE site_use_id = p_orig_sys_reference_rec.owner_table_id;
665: EXCEPTION
666: WHEN NO_DATA_FOUND THEN
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;

Line 668: fnd_message.set_token('FK', 'owner_table_id');

664: WHERE site_use_id = p_orig_sys_reference_rec.owner_table_id;
665: EXCEPTION
666: WHEN NO_DATA_FOUND THEN
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;

Line 669: fnd_message.set_token('COLUMN', 'site_use_id');

665: EXCEPTION
666: WHEN NO_DATA_FOUND THEN
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;

Line 670: fnd_message.set_token('TABLE', 'HZ_CUST_SITE_USES_ALL');

666: WHEN NO_DATA_FOUND THEN
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

Line 701: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

697: FROM HZ_LOCATIONS
698: WHERE location_id = p_orig_sys_reference_rec.owner_table_id;
699: EXCEPTION
700: WHEN NO_DATA_FOUND THEN
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;

Line 702: fnd_message.set_token('FK', 'owner_table_id');

698: WHERE location_id = p_orig_sys_reference_rec.owner_table_id;
699: EXCEPTION
700: WHEN NO_DATA_FOUND THEN
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;

Line 703: fnd_message.set_token('COLUMN', 'location_id');

699: EXCEPTION
700: WHEN NO_DATA_FOUND THEN
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;

Line 704: fnd_message.set_token('TABLE', 'HZ_LOCATIONS');

700: WHEN NO_DATA_FOUND THEN
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

Line 735: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

731: FROM HZ_ORG_CONTACTS
732: WHERE org_contact_id = p_orig_sys_reference_rec.owner_table_id;
733: EXCEPTION
734: WHEN NO_DATA_FOUND THEN
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;

Line 736: fnd_message.set_token('FK', 'owner_table_id');

732: WHERE org_contact_id = p_orig_sys_reference_rec.owner_table_id;
733: EXCEPTION
734: WHEN NO_DATA_FOUND THEN
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;

Line 737: fnd_message.set_token('COLUMN', 'org_contact_id');

733: EXCEPTION
734: WHEN NO_DATA_FOUND THEN
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;

Line 738: fnd_message.set_token('TABLE', 'HZ_ORG_CONTACTS');

734: WHEN NO_DATA_FOUND THEN
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

Line 769: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

765: FROM HZ_ORG_CONTACT_ROLES
766: WHERE org_contact_role_id = p_orig_sys_reference_rec.owner_table_id;
767: EXCEPTION
768: WHEN NO_DATA_FOUND THEN
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;

Line 770: fnd_message.set_token('FK', 'owner_table_id');

766: WHERE org_contact_role_id = p_orig_sys_reference_rec.owner_table_id;
767: EXCEPTION
768: WHEN NO_DATA_FOUND THEN
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;

Line 771: fnd_message.set_token('COLUMN', 'org_contact_role_id');

767: EXCEPTION
768: WHEN NO_DATA_FOUND THEN
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;

Line 772: fnd_message.set_token('TABLE', 'HZ_ORG_CONTACT_ROLES');

768: WHEN NO_DATA_FOUND THEN
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

Line 797: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');

793: fetch get_dup_orig_sys_ref_csr into l_exist;
794: close get_dup_orig_sys_ref_csr;
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;

Line 798: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system+orig_system_reference+owner_table_name+owner_table_id');

794: close get_dup_orig_sys_ref_csr;
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;

Line 811: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');

807:
808: if p_create_update_flag = 'C' and l_multiple_flag = 'N' and l_dup_exist = 'Y'
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;

Line 812: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system+orig_system_reference+owner_table_name');

808: if p_create_update_flag = 'C' and l_multiple_flag = 'N' and l_dup_exist = 'Y'
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:

Line 825: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_DATA_FOUND');

821: and
822: (p_orig_sys_reference_rec.old_orig_system_reference is null
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;

Line 826: FND_MESSAGE.SET_TOKEN('COLUMN','orig_system+orig_system_reference+owner_table_name'); FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');

822: (p_orig_sys_reference_rec.old_orig_system_reference is null
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:

Line 838: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_DATA_FOUND');

834: if orig_sys_reference_exist(p_orig_sys_reference_rec.orig_system,
835: p_orig_sys_reference_rec.old_orig_system_reference,
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;

Line 839: FND_MESSAGE.SET_TOKEN('COLUMN','orig_system+old_orig_system_reference+owner_table_name'); FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');

835: p_orig_sys_reference_rec.old_orig_system_reference,
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;

Line 849: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_FUTURE_DATE_ALLOWED');

845: if (p_orig_sys_reference_rec.start_date_active is not null
846: and p_orig_sys_reference_rec.start_date_active <>fnd_api.g_miss_date
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;

Line 850: FND_MESSAGE.SET_TOKEN('COLUMN','start_date_active');

846: and p_orig_sys_reference_rec.start_date_active <>fnd_api.g_miss_date
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:

Line 859: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_FUTURE_DATE_ALLOWED');

855: if (p_orig_sys_reference_rec.end_date_active is not null
856: and p_orig_sys_reference_rec.end_date_active <>fnd_api.g_miss_date
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;

Line 860: FND_MESSAGE.SET_TOKEN('COLUMN','end_date_active');

856: and p_orig_sys_reference_rec.end_date_active <>fnd_api.g_miss_date
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:

Line 966: FND_MESSAGE.SET_NAME('AR', 'HZ_SSM_INVALID_SOURCE_SYSTEM');

962: '1 '))
963: into l_check_orig_system
964: from dual;
965: if l_check_orig_system is not null then
966: FND_MESSAGE.SET_NAME('AR', 'HZ_SSM_INVALID_SOURCE_SYSTEM');
967: FND_MSG_PUB.ADD;
968: x_return_status := FND_API.G_RET_STS_ERROR;
969: end if;
970:

Line 976: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');

972: open source_system_exist;
973: fetch source_system_exist
974: into l_sst_flag, l_created_by_module, l_orig_system, l_orig_system_type;
975: if source_system_exist%FOUND then
976: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
977: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system');
978: FND_MSG_PUB.ADD;
979: x_return_status := FND_API.G_RET_STS_ERROR;
980: end if;

Line 977: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system');

973: fetch source_system_exist
974: into l_sst_flag, l_created_by_module, l_orig_system, l_orig_system_type;
975: if source_system_exist%FOUND then
976: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
977: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system');
978: FND_MSG_PUB.ADD;
979: x_return_status := FND_API.G_RET_STS_ERROR;
980: end if;
981:

Line 1034: FND_MESSAGE.SET_NAME('AR','HZ_SST_N_TO_Y_ONLY');

1030: p_restricted => 'N',
1031: x_return_status => x_return_status );
1032: END IF; */
1033: IF l_sst_flag = 'Y' and p_orig_sys_rec.sst_flag = 'N' THEN
1034: FND_MESSAGE.SET_NAME('AR','HZ_SST_N_TO_Y_ONLY');
1035: FND_MSG_PUB.ADD;
1036: x_return_status := FND_API.G_RET_STS_ERROR;
1037: END IF;
1038: