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_ORIG_SYSTEM_REF_PVT dependencies on FND_MESSAGE

Line 160: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');

156: --Check whether primary key has been passed in.
157: IF (p_orig_system_ref_id IS NULL OR
158: p_orig_system_ref_id = FND_API.G_MISS_NUM)
159: THEN
160: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
161: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system_ref_id');
162: FND_MSG_PUB.ADD;
163: RAISE FND_API.G_EXC_ERROR;
164: END IF;

Line 161: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system_ref_id');

157: IF (p_orig_system_ref_id IS NULL OR
158: p_orig_system_ref_id = FND_API.G_MISS_NUM)
159: THEN
160: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
161: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system_ref_id');
162: FND_MSG_PUB.ADD;
163: RAISE FND_API.G_EXC_ERROR;
164: END IF;
165:

Line 232: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

228:
229: WHEN OTHERS THEN
230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
231:
232: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
233: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
234: FND_MSG_PUB.ADD;
235:
236: FND_MSG_PUB.Count_And_Get(

Line 233: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

229: WHEN OTHERS THEN
230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
231:
232: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
233: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
234: FND_MSG_PUB.ADD;
235:
236: FND_MSG_PUB.Count_And_Get(
237: p_encoded => FND_API.G_FALSE,

Line 323: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');

319: IF NOT ((p_object_version_number is null and l_object_version_number is
320: null)
321: OR (p_object_version_number = l_object_version_number))
322: THEN
323: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
324: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_MAPPING');
325: FND_MSG_PUB.ADD;
326: x_return_status := FND_API.G_RET_STS_ERROR;
327: RAISE FND_API.G_EXC_ERROR;

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

320: null)
321: OR (p_object_version_number = l_object_version_number))
322: THEN
323: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
324: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_MAPPING');
325: FND_MSG_PUB.ADD;
326: x_return_status := FND_API.G_RET_STS_ERROR;
327: RAISE FND_API.G_EXC_ERROR;
328: END IF;

Line 333: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');

329:
330: p_object_version_number := nvl(l_object_version_number, 1) + 1;
331:
332: EXCEPTION WHEN NO_DATA_FOUND THEN
333: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
334: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_ORIG_SYS_MAPPING');
335: FND_MESSAGE.SET_TOKEN('VALUE', p_orig_sys_entity_map_rec.orig_system);
336: FND_MSG_PUB.ADD;
337: RAISE FND_API.G_EXC_ERROR;

Line 334: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_ORIG_SYS_MAPPING');

330: p_object_version_number := nvl(l_object_version_number, 1) + 1;
331:
332: EXCEPTION WHEN NO_DATA_FOUND THEN
333: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
334: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_ORIG_SYS_MAPPING');
335: FND_MESSAGE.SET_TOKEN('VALUE', p_orig_sys_entity_map_rec.orig_system);
336: FND_MSG_PUB.ADD;
337: RAISE FND_API.G_EXC_ERROR;
338: END;

Line 335: FND_MESSAGE.SET_TOKEN('VALUE', p_orig_sys_entity_map_rec.orig_system);

331:
332: EXCEPTION WHEN NO_DATA_FOUND THEN
333: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
334: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_ORIG_SYS_MAPPING');
335: FND_MESSAGE.SET_TOKEN('VALUE', p_orig_sys_entity_map_rec.orig_system);
336: FND_MSG_PUB.ADD;
337: RAISE FND_API.G_EXC_ERROR;
338: END;
339: if p_validation_level = FND_API.G_VALID_LEVEL_FULL

Line 442: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

438:
439: WHEN OTHERS THEN
440: ROLLBACK TO create_orig_sys_entity_mapping;
441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
442: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
443: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
444: FND_MSG_PUB.ADD;
445: FND_MSG_PUB.Count_And_Get(
446: p_encoded => FND_API.G_FALSE,

Line 443: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

439: WHEN OTHERS THEN
440: ROLLBACK TO create_orig_sys_entity_mapping;
441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
442: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
443: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
444: FND_MSG_PUB.ADD;
445: FND_MSG_PUB.Count_And_Get(
446: p_encoded => FND_API.G_FALSE,
447: p_count => x_msg_count,

Line 508: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

504:
505: WHEN OTHERS THEN
506: ROLLBACK TO update_orig_sys_entity_mapping;
507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
508: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
509: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
510: FND_MSG_PUB.ADD;
511: FND_MSG_PUB.Count_And_Get(
512: p_encoded => FND_API.G_FALSE,

Line 509: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

505: WHEN OTHERS THEN
506: ROLLBACK TO update_orig_sys_entity_mapping;
507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
508: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
509: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
510: FND_MSG_PUB.ADD;
511: FND_MSG_PUB.Count_And_Get(
512: p_encoded => FND_API.G_FALSE,
513: p_count => x_msg_count,

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

622: END IF;
623: -- END IF;
624: EXCEPTION
625: WHEN NO_DATA_FOUND THEN
626: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
627: fnd_message.set_token('FK', 'party_id');
628: fnd_message.set_token('COLUMN', 'party_id');
629: fnd_message.set_token('TABLE', 'hz_parties');
630: fnd_msg_pub.add;

Line 627: fnd_message.set_token('FK', 'party_id');

623: -- END IF;
624: EXCEPTION
625: WHEN NO_DATA_FOUND THEN
626: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
627: fnd_message.set_token('FK', 'party_id');
628: fnd_message.set_token('COLUMN', 'party_id');
629: fnd_message.set_token('TABLE', 'hz_parties');
630: fnd_msg_pub.add;
631: x_return_status := fnd_api.g_ret_sts_error;

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

624: EXCEPTION
625: WHEN NO_DATA_FOUND THEN
626: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
627: fnd_message.set_token('FK', 'party_id');
628: fnd_message.set_token('COLUMN', 'party_id');
629: fnd_message.set_token('TABLE', 'hz_parties');
630: fnd_msg_pub.add;
631: x_return_status := fnd_api.g_ret_sts_error;
632:

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

625: WHEN NO_DATA_FOUND THEN
626: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
627: fnd_message.set_token('FK', 'party_id');
628: fnd_message.set_token('COLUMN', 'party_id');
629: fnd_message.set_token('TABLE', 'hz_parties');
630: fnd_msg_pub.add;
631: x_return_status := fnd_api.g_ret_sts_error;
632:
633: END;

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

756: fetch get_pk_by_owner_id into l_orig_system_ref_id;
757: close get_pk_by_owner_id;
758: if l_orig_system_ref_id is null
759: then
760: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_DATA_FOUND');
761: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system+orig_system_reference+owner_table_id');
762: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');
763: FND_MSG_PUB.ADD;
764: x_return_status := FND_API.G_RET_STS_ERROR;

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

757: close get_pk_by_owner_id;
758: if l_orig_system_ref_id is null
759: then
760: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_DATA_FOUND');
761: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system+orig_system_reference+owner_table_id');
762: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');
763: FND_MSG_PUB.ADD;
764: x_return_status := FND_API.G_RET_STS_ERROR;
765: RAISE FND_API.G_EXC_ERROR;

Line 762: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');

758: if l_orig_system_ref_id is null
759: then
760: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_DATA_FOUND');
761: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system+orig_system_reference+owner_table_id');
762: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');
763: FND_MSG_PUB.ADD;
764: x_return_status := FND_API.G_RET_STS_ERROR;
765: RAISE FND_API.G_EXC_ERROR;
766: end if;

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

769: and p_orig_sys_reference_rec.orig_system_ref_id<>fnd_api.g_miss_num)
770: then
771: if nvl(l_orig_system_ref_id,p_orig_sys_reference_rec.orig_system_ref_id)<>p_orig_sys_reference_rec.orig_system_ref_id
772: then
773: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_DATA_FOUND');
774: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system+orig_system_reference+owner_table_id+orig_system_ref_id');
775: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');
776: FND_MSG_PUB.ADD;
777: x_return_status := FND_API.G_RET_STS_ERROR;

Line 774: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system+orig_system_reference+owner_table_id+orig_system_ref_id');

770: then
771: if nvl(l_orig_system_ref_id,p_orig_sys_reference_rec.orig_system_ref_id)<>p_orig_sys_reference_rec.orig_system_ref_id
772: then
773: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_DATA_FOUND');
774: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system+orig_system_reference+owner_table_id+orig_system_ref_id');
775: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');
776: FND_MSG_PUB.ADD;
777: x_return_status := FND_API.G_RET_STS_ERROR;
778: RAISE FND_API.G_EXC_ERROR;

Line 775: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');

771: if nvl(l_orig_system_ref_id,p_orig_sys_reference_rec.orig_system_ref_id)<>p_orig_sys_reference_rec.orig_system_ref_id
772: then
773: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_DATA_FOUND');
774: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system+orig_system_reference+owner_table_id+orig_system_ref_id');
775: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');
776: FND_MSG_PUB.ADD;
777: x_return_status := FND_API.G_RET_STS_ERROR;
778: RAISE FND_API.G_EXC_ERROR;
779: end if;

Line 789: FND_MESSAGE.SET_NAME('AR', 'HZ_MOSR_CANNOT_UPDATE');

785: l_count :=hz_mosr_validate_pkg.get_orig_system_ref_count(p_orig_sys_reference_rec.orig_system,
786: p_orig_sys_reference_rec.orig_system_reference,p_orig_sys_reference_rec.owner_table_name);
787: if l_count > 1
788: then
789: FND_MESSAGE.SET_NAME('AR', 'HZ_MOSR_CANNOT_UPDATE');
790: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system+orig_system_reference');
791: FND_MSG_PUB.ADD;
792: x_return_status := FND_API.G_RET_STS_ERROR;
793: RAISE FND_API.G_EXC_ERROR;

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

786: p_orig_sys_reference_rec.orig_system_reference,p_orig_sys_reference_rec.owner_table_name);
787: if l_count > 1
788: then
789: FND_MESSAGE.SET_NAME('AR', 'HZ_MOSR_CANNOT_UPDATE');
790: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system+orig_system_reference');
791: FND_MSG_PUB.ADD;
792: x_return_status := FND_API.G_RET_STS_ERROR;
793: RAISE FND_API.G_EXC_ERROR;
794: elsif l_count = 0

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

792: x_return_status := FND_API.G_RET_STS_ERROR;
793: RAISE FND_API.G_EXC_ERROR;
794: elsif l_count = 0
795: then
796: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_DATA_FOUND');
797: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system+orig_system_reference');
798: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');
799: FND_MSG_PUB.ADD;
800: x_return_status := FND_API.G_RET_STS_ERROR;

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

793: RAISE FND_API.G_EXC_ERROR;
794: elsif l_count = 0
795: then
796: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_DATA_FOUND');
797: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system+orig_system_reference');
798: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');
799: FND_MSG_PUB.ADD;
800: x_return_status := FND_API.G_RET_STS_ERROR;
801: RAISE FND_API.G_EXC_ERROR;

Line 798: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');

794: elsif l_count = 0
795: then
796: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_DATA_FOUND');
797: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system+orig_system_reference');
798: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');
799: FND_MSG_PUB.ADD;
800: x_return_status := FND_API.G_RET_STS_ERROR;
801: RAISE FND_API.G_EXC_ERROR;
802: elsif l_count = 1

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

821:
822: IF NOT ((p_object_version_number is null and l_object_version_number is null)
823: OR (p_object_version_number = l_object_version_number))
824: THEN
825: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
826: 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: RAISE FND_API.G_EXC_ERROR;

Line 826: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');

822: IF NOT ((p_object_version_number is null and l_object_version_number is null)
823: OR (p_object_version_number = l_object_version_number))
824: THEN
825: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
826: 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: RAISE FND_API.G_EXC_ERROR;
830: END IF;

Line 835: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');

831:
832: p_object_version_number := nvl(l_object_version_number, 1) + 1;
833:
834: EXCEPTION WHEN NO_DATA_FOUND THEN
835: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
836: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_ORIG_SYS_REFERENCES');
837: FND_MESSAGE.SET_TOKEN('VALUE', l_orig_system_ref_id);
838: FND_MSG_PUB.ADD;
839: RAISE FND_API.G_EXC_ERROR;

Line 836: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_ORIG_SYS_REFERENCES');

832: p_object_version_number := nvl(l_object_version_number, 1) + 1;
833:
834: EXCEPTION WHEN NO_DATA_FOUND THEN
835: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
836: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_ORIG_SYS_REFERENCES');
837: FND_MESSAGE.SET_TOKEN('VALUE', l_orig_system_ref_id);
838: FND_MSG_PUB.ADD;
839: RAISE FND_API.G_EXC_ERROR;
840: END;

Line 837: FND_MESSAGE.SET_TOKEN('VALUE', l_orig_system_ref_id);

833:
834: EXCEPTION WHEN NO_DATA_FOUND THEN
835: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
836: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_ORIG_SYS_REFERENCES');
837: FND_MESSAGE.SET_TOKEN('VALUE', l_orig_system_ref_id);
838: FND_MSG_PUB.ADD;
839: RAISE FND_API.G_EXC_ERROR;
840: END;
841:

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

845: p_orig_sys_reference_rec.orig_system_reference <> l_orig_system_reference
846: then
847: if HZ_UTILITY_V2PUB.is_purchased_content_source(l_orig_system) = 'Y'
848: then
849: FND_MESSAGE.SET_NAME('AR', 'HZ_SSM_NO_UPDATE_PUR');
850: FND_MSG_PUB.ADD;
851: RAISE FND_API.G_EXC_ERROR;
852: end if;
853: end if;

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

962: END IF;
963: -- END IF;
964: EXCEPTION
965: WHEN NO_DATA_FOUND THEN
966: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
967: fnd_message.set_token('FK', 'party_id');
968: fnd_message.set_token('COLUMN', 'party_id');
969: fnd_message.set_token('TABLE', 'hz_parties');
970: fnd_msg_pub.add;

Line 967: fnd_message.set_token('FK', 'party_id');

963: -- END IF;
964: EXCEPTION
965: WHEN NO_DATA_FOUND THEN
966: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
967: fnd_message.set_token('FK', 'party_id');
968: fnd_message.set_token('COLUMN', 'party_id');
969: fnd_message.set_token('TABLE', 'hz_parties');
970: fnd_msg_pub.add;
971: x_return_status := fnd_api.g_ret_sts_error;

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

964: EXCEPTION
965: WHEN NO_DATA_FOUND THEN
966: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
967: fnd_message.set_token('FK', 'party_id');
968: fnd_message.set_token('COLUMN', 'party_id');
969: fnd_message.set_token('TABLE', 'hz_parties');
970: fnd_msg_pub.add;
971: x_return_status := fnd_api.g_ret_sts_error;
972:

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

965: WHEN NO_DATA_FOUND THEN
966: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
967: fnd_message.set_token('FK', 'party_id');
968: fnd_message.set_token('COLUMN', 'party_id');
969: fnd_message.set_token('TABLE', 'hz_parties');
970: fnd_msg_pub.add;
971: x_return_status := fnd_api.g_ret_sts_error;
972:
973: END;

Line 1108: FND_MESSAGE.SET_NAME( 'AR', 'HZ_MOSR_NO_MULTIPLE_ALLOWED' );

1104: open get_orig_system_new;
1105: fetch get_orig_system_new into l_dummy ;
1106: if get_orig_system_new%FOUND then
1107: if p_validation_level = FND_API.G_VALID_LEVEL_FULL then
1108: FND_MESSAGE.SET_NAME( 'AR', 'HZ_MOSR_NO_MULTIPLE_ALLOWED' );
1109: FND_MSG_PUB.ADD;
1110: x_return_status := FND_API.G_RET_STS_ERROR;
1111: end if;
1112: else

Line 1169: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

1165:
1166: WHEN OTHERS THEN
1167: ROLLBACK TO create_orig_sys_reference;
1168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1169: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1170: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1171: FND_MSG_PUB.ADD;
1172: FND_MSG_PUB.Count_And_Get(
1173: p_encoded => FND_API.G_FALSE,

Line 1170: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

1166: WHEN OTHERS THEN
1167: ROLLBACK TO create_orig_sys_reference;
1168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1169: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1170: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1171: FND_MSG_PUB.ADD;
1172: FND_MSG_PUB.Count_And_Get(
1173: p_encoded => FND_API.G_FALSE,
1174: p_count => x_msg_count,

Line 1319: FND_MESSAGE.SET_NAME( 'AR', 'HZ_MOSR_NO_MULTIPLE_ALLOWED' );

1315: p_validation_level,
1316: x_return_status );
1317: else
1318: if p_validation_level = FND_API.G_VALID_LEVEL_FULL then
1319: FND_MESSAGE.SET_NAME( 'AR', 'HZ_MOSR_NO_MULTIPLE_ALLOWED' );
1320: FND_MSG_PUB.ADD;
1321: x_return_status := FND_API.G_RET_STS_ERROR;
1322: end if;
1323: end if;

Line 1434: FND_MESSAGE.SET_NAME( 'AR', 'HZ_MOSR_NO_MULTIPLE_ALLOWED' );

1430: open get_orig_system_new;
1431: fetch get_orig_system_new into l_dummy ;
1432: if get_orig_system_new%FOUND then
1433: if p_validation_level = FND_API.G_VALID_LEVEL_FULL then
1434: FND_MESSAGE.SET_NAME( 'AR', 'HZ_MOSR_NO_MULTIPLE_ALLOWED' );
1435: FND_MSG_PUB.ADD;
1436: x_return_status := FND_API.G_RET_STS_ERROR;
1437: end if;
1438: else

Line 1517: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

1513:
1514: WHEN OTHERS THEN
1515: ROLLBACK TO update_orig_sys_reference;
1516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1517: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1518: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1519: FND_MSG_PUB.ADD;
1520: FND_MSG_PUB.Count_And_Get(
1521: p_encoded => FND_API.G_FALSE,

Line 1518: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

1514: WHEN OTHERS THEN
1515: ROLLBACK TO update_orig_sys_reference;
1516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1517: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1518: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1519: FND_MSG_PUB.ADD;
1520: FND_MSG_PUB.Count_And_Get(
1521: p_encoded => FND_API.G_FALSE,
1522: p_count => x_msg_count,

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

1765: -- END IF;
1766: end loop;
1767: IF l_party_merge_flag = FALSE THEN /*Bug 3235877*/
1768: if p_validation_level = FND_API.G_VALID_LEVEL_FULL then--YES
1769: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_DATA_FOUND');
1770: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system+orig_system_reference+owner_table_id');
1771: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');
1772: FND_MSG_PUB.ADD;
1773: x_return_status := FND_API.G_RET_STS_ERROR;

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

1766: end loop;
1767: IF l_party_merge_flag = FALSE THEN /*Bug 3235877*/
1768: if p_validation_level = FND_API.G_VALID_LEVEL_FULL then--YES
1769: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_DATA_FOUND');
1770: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system+orig_system_reference+owner_table_id');
1771: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');
1772: FND_MSG_PUB.ADD;
1773: x_return_status := FND_API.G_RET_STS_ERROR;
1774: end if;

Line 1771: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');

1767: IF l_party_merge_flag = FALSE THEN /*Bug 3235877*/
1768: if p_validation_level = FND_API.G_VALID_LEVEL_FULL then--YES
1769: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_DATA_FOUND');
1770: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system+orig_system_reference+owner_table_id');
1771: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');
1772: FND_MSG_PUB.ADD;
1773: x_return_status := FND_API.G_RET_STS_ERROR;
1774: end if;
1775: END IF;

Line 1798: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

1794:
1795: WHEN OTHERS THEN
1796: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1797:
1798: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1799: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1800: FND_MSG_PUB.ADD;
1801:
1802: FND_MSG_PUB.Count_And_Get(

Line 1799: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

1795: WHEN OTHERS THEN
1796: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1797:
1798: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1799: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1800: FND_MSG_PUB.ADD;
1801:
1802: FND_MSG_PUB.Count_And_Get(
1803: p_encoded => FND_API.G_FALSE,

Line 1908: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

1904:
1905: WHEN OTHERS THEN
1906: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1907:
1908: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1909: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1910: FND_MSG_PUB.ADD;
1911:
1912: FND_MSG_PUB.Count_And_Get(

Line 1909: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

1905: WHEN OTHERS THEN
1906: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1907:
1908: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1909: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1910: FND_MSG_PUB.ADD;
1911:
1912: FND_MSG_PUB.Count_And_Get(
1913: p_encoded => FND_API.G_FALSE,

Line 2196: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');

2192: IF NOT ((p_object_version_number is null and l_object_version_number is
2193: null)
2194: OR (p_object_version_number = l_object_version_number))
2195: THEN
2196: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
2197: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYSTEMS_B');
2198: FND_MSG_PUB.ADD;
2199: x_return_status := FND_API.G_RET_STS_ERROR;
2200: RAISE FND_API.G_EXC_ERROR;

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

2193: null)
2194: OR (p_object_version_number = l_object_version_number))
2195: THEN
2196: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
2197: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYSTEMS_B');
2198: FND_MSG_PUB.ADD;
2199: x_return_status := FND_API.G_RET_STS_ERROR;
2200: RAISE FND_API.G_EXC_ERROR;
2201: END IF;

Line 2206: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');

2202:
2203: p_object_version_number := nvl(l_object_version_number, 1) + 1;
2204:
2205: EXCEPTION WHEN NO_DATA_FOUND THEN
2206: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
2207: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_ORIG_SYSTEMS_B');
2208: FND_MESSAGE.SET_TOKEN('VALUE', p_orig_sys_rec.orig_system_id);
2209: FND_MSG_PUB.ADD;
2210: RAISE FND_API.G_EXC_ERROR;

Line 2207: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_ORIG_SYSTEMS_B');

2203: p_object_version_number := nvl(l_object_version_number, 1) + 1;
2204:
2205: EXCEPTION WHEN NO_DATA_FOUND THEN
2206: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
2207: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_ORIG_SYSTEMS_B');
2208: FND_MESSAGE.SET_TOKEN('VALUE', p_orig_sys_rec.orig_system_id);
2209: FND_MSG_PUB.ADD;
2210: RAISE FND_API.G_EXC_ERROR;
2211: END;

Line 2208: FND_MESSAGE.SET_TOKEN('VALUE', p_orig_sys_rec.orig_system_id);

2204:
2205: EXCEPTION WHEN NO_DATA_FOUND THEN
2206: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
2207: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_ORIG_SYSTEMS_B');
2208: FND_MESSAGE.SET_TOKEN('VALUE', p_orig_sys_rec.orig_system_id);
2209: FND_MSG_PUB.ADD;
2210: RAISE FND_API.G_EXC_ERROR;
2211: END;
2212:

Line 2349: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

2345:
2346: WHEN OTHERS THEN
2347: ROLLBACK TO create_orig_system;
2348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2349: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2350: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2351: FND_MSG_PUB.ADD;
2352: FND_MSG_PUB.Count_And_Get(
2353: p_encoded => FND_API.G_FALSE,

Line 2350: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

2346: WHEN OTHERS THEN
2347: ROLLBACK TO create_orig_system;
2348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2349: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2350: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2351: FND_MSG_PUB.ADD;
2352: FND_MSG_PUB.Count_And_Get(
2353: p_encoded => FND_API.G_FALSE,
2354: p_count => x_msg_count,

Line 2416: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

2412:
2413: WHEN OTHERS THEN
2414: ROLLBACK TO update_orig_system;
2415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2416: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2417: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2418: FND_MSG_PUB.ADD;
2419: FND_MSG_PUB.Count_And_Get(
2420: p_encoded => FND_API.G_FALSE,

Line 2417: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

2413: WHEN OTHERS THEN
2414: ROLLBACK TO update_orig_system;
2415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2416: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2417: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2418: FND_MSG_PUB.ADD;
2419: FND_MSG_PUB.Count_And_Get(
2420: p_encoded => FND_API.G_FALSE,
2421: p_count => x_msg_count,