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

639: END IF;
640: -- END IF;
641: EXCEPTION
642: WHEN NO_DATA_FOUND THEN
643: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
644: fnd_message.set_token('FK', 'party_id');
645: fnd_message.set_token('COLUMN', 'party_id');
646: fnd_message.set_token('TABLE', 'hz_parties');
647: fnd_msg_pub.add;

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

640: -- END IF;
641: EXCEPTION
642: WHEN NO_DATA_FOUND THEN
643: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
644: fnd_message.set_token('FK', 'party_id');
645: fnd_message.set_token('COLUMN', 'party_id');
646: fnd_message.set_token('TABLE', 'hz_parties');
647: fnd_msg_pub.add;
648: x_return_status := fnd_api.g_ret_sts_error;

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

641: EXCEPTION
642: WHEN NO_DATA_FOUND THEN
643: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
644: fnd_message.set_token('FK', 'party_id');
645: fnd_message.set_token('COLUMN', 'party_id');
646: fnd_message.set_token('TABLE', 'hz_parties');
647: fnd_msg_pub.add;
648: x_return_status := fnd_api.g_ret_sts_error;
649:

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

642: WHEN NO_DATA_FOUND THEN
643: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
644: fnd_message.set_token('FK', 'party_id');
645: fnd_message.set_token('COLUMN', 'party_id');
646: fnd_message.set_token('TABLE', 'hz_parties');
647: fnd_msg_pub.add;
648: x_return_status := fnd_api.g_ret_sts_error;
649:
650: END;

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

778: fetch get_pk_by_owner_id into l_orig_system_ref_id;
779: close get_pk_by_owner_id;
780: if l_orig_system_ref_id is null
781: then
782: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_DATA_FOUND');
783: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system+orig_system_reference+owner_table_id');
784: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');
785: FND_MSG_PUB.ADD;
786: x_return_status := FND_API.G_RET_STS_ERROR;

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

779: close get_pk_by_owner_id;
780: if l_orig_system_ref_id is null
781: then
782: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_DATA_FOUND');
783: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system+orig_system_reference+owner_table_id');
784: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');
785: FND_MSG_PUB.ADD;
786: x_return_status := FND_API.G_RET_STS_ERROR;
787: RAISE FND_API.G_EXC_ERROR;

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

780: if l_orig_system_ref_id is null
781: then
782: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_DATA_FOUND');
783: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system+orig_system_reference+owner_table_id');
784: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');
785: FND_MSG_PUB.ADD;
786: x_return_status := FND_API.G_RET_STS_ERROR;
787: RAISE FND_API.G_EXC_ERROR;
788: end if;

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

791: and p_orig_sys_reference_rec.orig_system_ref_id<>fnd_api.g_miss_num)
792: then
793: 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
794: then
795: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_DATA_FOUND');
796: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system+orig_system_reference+owner_table_id+orig_system_ref_id');
797: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');
798: FND_MSG_PUB.ADD;
799: x_return_status := FND_API.G_RET_STS_ERROR;

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

792: then
793: 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
794: then
795: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_DATA_FOUND');
796: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system+orig_system_reference+owner_table_id+orig_system_ref_id');
797: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');
798: FND_MSG_PUB.ADD;
799: x_return_status := FND_API.G_RET_STS_ERROR;
800: RAISE FND_API.G_EXC_ERROR;

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

793: 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
794: then
795: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_DATA_FOUND');
796: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system+orig_system_reference+owner_table_id+orig_system_ref_id');
797: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');
798: FND_MSG_PUB.ADD;
799: x_return_status := FND_API.G_RET_STS_ERROR;
800: RAISE FND_API.G_EXC_ERROR;
801: end if;

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

807: l_count :=hz_mosr_validate_pkg.get_orig_system_ref_count(p_orig_sys_reference_rec.orig_system,
808: p_orig_sys_reference_rec.orig_system_reference,p_orig_sys_reference_rec.owner_table_name);
809: if l_count > 1
810: then
811: FND_MESSAGE.SET_NAME('AR', 'HZ_MOSR_CANNOT_UPDATE');
812: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system+orig_system_reference');
813: FND_MSG_PUB.ADD;
814: x_return_status := FND_API.G_RET_STS_ERROR;
815: RAISE FND_API.G_EXC_ERROR;

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

808: p_orig_sys_reference_rec.orig_system_reference,p_orig_sys_reference_rec.owner_table_name);
809: if l_count > 1
810: then
811: FND_MESSAGE.SET_NAME('AR', 'HZ_MOSR_CANNOT_UPDATE');
812: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system+orig_system_reference');
813: FND_MSG_PUB.ADD;
814: x_return_status := FND_API.G_RET_STS_ERROR;
815: RAISE FND_API.G_EXC_ERROR;
816: elsif l_count = 0

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

814: x_return_status := FND_API.G_RET_STS_ERROR;
815: RAISE FND_API.G_EXC_ERROR;
816: elsif l_count = 0
817: then
818: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_DATA_FOUND');
819: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system+orig_system_reference');
820: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');
821: FND_MSG_PUB.ADD;
822: x_return_status := FND_API.G_RET_STS_ERROR;

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

815: RAISE FND_API.G_EXC_ERROR;
816: elsif l_count = 0
817: then
818: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_DATA_FOUND');
819: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system+orig_system_reference');
820: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');
821: FND_MSG_PUB.ADD;
822: x_return_status := FND_API.G_RET_STS_ERROR;
823: RAISE FND_API.G_EXC_ERROR;

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

816: elsif l_count = 0
817: then
818: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_DATA_FOUND');
819: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system+orig_system_reference');
820: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');
821: FND_MSG_PUB.ADD;
822: x_return_status := FND_API.G_RET_STS_ERROR;
823: RAISE FND_API.G_EXC_ERROR;
824: elsif l_count = 1

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

843:
844: IF NOT ((p_object_version_number is null and l_object_version_number is null)
845: OR (p_object_version_number = l_object_version_number))
846: THEN
847: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
848: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');
849: FND_MSG_PUB.ADD;
850: x_return_status := FND_API.G_RET_STS_ERROR;
851: RAISE FND_API.G_EXC_ERROR;

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

844: IF NOT ((p_object_version_number is null and l_object_version_number is null)
845: OR (p_object_version_number = l_object_version_number))
846: THEN
847: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
848: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');
849: FND_MSG_PUB.ADD;
850: x_return_status := FND_API.G_RET_STS_ERROR;
851: RAISE FND_API.G_EXC_ERROR;
852: END IF;

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

853:
854: p_object_version_number := nvl(l_object_version_number, 1) + 1;
855:
856: EXCEPTION WHEN NO_DATA_FOUND THEN
857: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
858: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_ORIG_SYS_REFERENCES');
859: FND_MESSAGE.SET_TOKEN('VALUE', l_orig_system_ref_id);
860: FND_MSG_PUB.ADD;
861: RAISE FND_API.G_EXC_ERROR;

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

854: p_object_version_number := nvl(l_object_version_number, 1) + 1;
855:
856: EXCEPTION WHEN NO_DATA_FOUND THEN
857: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
858: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_ORIG_SYS_REFERENCES');
859: FND_MESSAGE.SET_TOKEN('VALUE', l_orig_system_ref_id);
860: FND_MSG_PUB.ADD;
861: RAISE FND_API.G_EXC_ERROR;
862: END;

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

855:
856: EXCEPTION WHEN NO_DATA_FOUND THEN
857: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
858: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_ORIG_SYS_REFERENCES');
859: FND_MESSAGE.SET_TOKEN('VALUE', l_orig_system_ref_id);
860: FND_MSG_PUB.ADD;
861: RAISE FND_API.G_EXC_ERROR;
862: END;
863:

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

867: p_orig_sys_reference_rec.orig_system_reference <> l_orig_system_reference
868: then
869: if HZ_UTILITY_V2PUB.is_purchased_content_source(l_orig_system) = 'Y'
870: then
871: FND_MESSAGE.SET_NAME('AR', 'HZ_SSM_NO_UPDATE_PUR');
872: FND_MSG_PUB.ADD;
873: RAISE FND_API.G_EXC_ERROR;
874: end if;
875: end if;

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

991: END IF;
992: -- END IF;
993: EXCEPTION
994: WHEN NO_DATA_FOUND THEN
995: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
996: fnd_message.set_token('FK', 'party_id');
997: fnd_message.set_token('COLUMN', 'party_id');
998: fnd_message.set_token('TABLE', 'hz_parties');
999: fnd_msg_pub.add;

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

992: -- END IF;
993: EXCEPTION
994: WHEN NO_DATA_FOUND THEN
995: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
996: fnd_message.set_token('FK', 'party_id');
997: fnd_message.set_token('COLUMN', 'party_id');
998: fnd_message.set_token('TABLE', 'hz_parties');
999: fnd_msg_pub.add;
1000: x_return_status := fnd_api.g_ret_sts_error;

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

993: EXCEPTION
994: WHEN NO_DATA_FOUND THEN
995: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
996: fnd_message.set_token('FK', 'party_id');
997: fnd_message.set_token('COLUMN', 'party_id');
998: fnd_message.set_token('TABLE', 'hz_parties');
999: fnd_msg_pub.add;
1000: x_return_status := fnd_api.g_ret_sts_error;
1001:

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

994: WHEN NO_DATA_FOUND THEN
995: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
996: fnd_message.set_token('FK', 'party_id');
997: fnd_message.set_token('COLUMN', 'party_id');
998: fnd_message.set_token('TABLE', 'hz_parties');
999: fnd_msg_pub.add;
1000: x_return_status := fnd_api.g_ret_sts_error;
1001:
1002: END;

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

1133: open get_orig_system_new;
1134: fetch get_orig_system_new into l_dummy ;
1135: if get_orig_system_new%FOUND then
1136: if p_validation_level = FND_API.G_VALID_LEVEL_FULL then
1137: FND_MESSAGE.SET_NAME( 'AR', 'HZ_MOSR_NO_MULTIPLE_ALLOWED' );
1138: FND_MSG_PUB.ADD;
1139: x_return_status := FND_API.G_RET_STS_ERROR;
1140: end if;
1141: else

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

1194:
1195: WHEN OTHERS THEN
1196: ROLLBACK TO create_orig_sys_reference;
1197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1198: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1199: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1200: FND_MSG_PUB.ADD;
1201: FND_MSG_PUB.Count_And_Get(
1202: p_encoded => FND_API.G_FALSE,

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

1195: WHEN OTHERS THEN
1196: ROLLBACK TO create_orig_sys_reference;
1197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1198: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1199: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1200: FND_MSG_PUB.ADD;
1201: FND_MSG_PUB.Count_And_Get(
1202: p_encoded => FND_API.G_FALSE,
1203: p_count => x_msg_count,

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

1344: p_validation_level,
1345: x_return_status );
1346: else
1347: if p_validation_level = FND_API.G_VALID_LEVEL_FULL then
1348: FND_MESSAGE.SET_NAME( 'AR', 'HZ_MOSR_NO_MULTIPLE_ALLOWED' );
1349: FND_MSG_PUB.ADD;
1350: x_return_status := FND_API.G_RET_STS_ERROR;
1351: end if;
1352: end if;

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

1459: open get_orig_system_new;
1460: fetch get_orig_system_new into l_dummy ;
1461: if get_orig_system_new%FOUND then
1462: if p_validation_level = FND_API.G_VALID_LEVEL_FULL then
1463: FND_MESSAGE.SET_NAME( 'AR', 'HZ_MOSR_NO_MULTIPLE_ALLOWED' );
1464: FND_MSG_PUB.ADD;
1465: x_return_status := FND_API.G_RET_STS_ERROR;
1466: end if;
1467: else

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

1550:
1551: WHEN OTHERS THEN
1552: ROLLBACK TO update_orig_sys_reference;
1553: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1554: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1555: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1556: FND_MSG_PUB.ADD;
1557: FND_MSG_PUB.Count_And_Get(
1558: p_encoded => FND_API.G_FALSE,

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

1551: WHEN OTHERS THEN
1552: ROLLBACK TO update_orig_sys_reference;
1553: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1554: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1555: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1556: FND_MSG_PUB.ADD;
1557: FND_MSG_PUB.Count_And_Get(
1558: p_encoded => FND_API.G_FALSE,
1559: p_count => x_msg_count,

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

1810: -- END IF;
1811: end loop;
1812: IF l_party_merge_flag = FALSE THEN /*Bug 3235877*/
1813: if p_validation_level = FND_API.G_VALID_LEVEL_FULL then--YES
1814: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_DATA_FOUND');
1815: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system+orig_system_reference+owner_table_id');
1816: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');
1817: FND_MSG_PUB.ADD;
1818: x_return_status := FND_API.G_RET_STS_ERROR;

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

1811: end loop;
1812: IF l_party_merge_flag = FALSE THEN /*Bug 3235877*/
1813: if p_validation_level = FND_API.G_VALID_LEVEL_FULL then--YES
1814: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_DATA_FOUND');
1815: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system+orig_system_reference+owner_table_id');
1816: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');
1817: FND_MSG_PUB.ADD;
1818: x_return_status := FND_API.G_RET_STS_ERROR;
1819: end if;

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

1812: IF l_party_merge_flag = FALSE THEN /*Bug 3235877*/
1813: if p_validation_level = FND_API.G_VALID_LEVEL_FULL then--YES
1814: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_DATA_FOUND');
1815: FND_MESSAGE.SET_TOKEN('COLUMN', 'orig_system+orig_system_reference+owner_table_id');
1816: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYS_REFERENCES');
1817: FND_MSG_PUB.ADD;
1818: x_return_status := FND_API.G_RET_STS_ERROR;
1819: end if;
1820: END IF;

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

1839:
1840: WHEN OTHERS THEN
1841: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1842:
1843: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1844: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1845: FND_MSG_PUB.ADD;
1846:
1847: FND_MSG_PUB.Count_And_Get(

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

1840: WHEN OTHERS THEN
1841: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1842:
1843: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1844: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1845: FND_MSG_PUB.ADD;
1846:
1847: FND_MSG_PUB.Count_And_Get(
1848: p_encoded => FND_API.G_FALSE,

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

1949:
1950: WHEN OTHERS THEN
1951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1952:
1953: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1954: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1955: FND_MSG_PUB.ADD;
1956:
1957: FND_MSG_PUB.Count_And_Get(

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

1950: WHEN OTHERS THEN
1951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1952:
1953: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1954: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1955: FND_MSG_PUB.ADD;
1956:
1957: FND_MSG_PUB.Count_And_Get(
1958: p_encoded => FND_API.G_FALSE,

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

2239: IF NOT ((p_object_version_number is null and l_object_version_number is
2240: null)
2241: OR (p_object_version_number = l_object_version_number))
2242: THEN
2243: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
2244: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYSTEMS_B');
2245: FND_MSG_PUB.ADD;
2246: x_return_status := FND_API.G_RET_STS_ERROR;
2247: RAISE FND_API.G_EXC_ERROR;

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

2240: null)
2241: OR (p_object_version_number = l_object_version_number))
2242: THEN
2243: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
2244: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_ORIG_SYSTEMS_B');
2245: FND_MSG_PUB.ADD;
2246: x_return_status := FND_API.G_RET_STS_ERROR;
2247: RAISE FND_API.G_EXC_ERROR;
2248: END IF;

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

2249:
2250: p_object_version_number := nvl(l_object_version_number, 1) + 1;
2251:
2252: EXCEPTION WHEN NO_DATA_FOUND THEN
2253: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
2254: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_ORIG_SYSTEMS_B');
2255: FND_MESSAGE.SET_TOKEN('VALUE', p_orig_sys_rec.orig_system_id);
2256: FND_MSG_PUB.ADD;
2257: RAISE FND_API.G_EXC_ERROR;

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

2250: p_object_version_number := nvl(l_object_version_number, 1) + 1;
2251:
2252: EXCEPTION WHEN NO_DATA_FOUND THEN
2253: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
2254: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_ORIG_SYSTEMS_B');
2255: FND_MESSAGE.SET_TOKEN('VALUE', p_orig_sys_rec.orig_system_id);
2256: FND_MSG_PUB.ADD;
2257: RAISE FND_API.G_EXC_ERROR;
2258: END;

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

2251:
2252: EXCEPTION WHEN NO_DATA_FOUND THEN
2253: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
2254: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_ORIG_SYSTEMS_B');
2255: FND_MESSAGE.SET_TOKEN('VALUE', p_orig_sys_rec.orig_system_id);
2256: FND_MSG_PUB.ADD;
2257: RAISE FND_API.G_EXC_ERROR;
2258: END;
2259:

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

2392:
2393: WHEN OTHERS THEN
2394: ROLLBACK TO create_orig_system;
2395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2396: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2397: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2398: FND_MSG_PUB.ADD;
2399: FND_MSG_PUB.Count_And_Get(
2400: p_encoded => FND_API.G_FALSE,

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

2393: WHEN OTHERS THEN
2394: ROLLBACK TO create_orig_system;
2395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2396: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2397: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2398: FND_MSG_PUB.ADD;
2399: FND_MSG_PUB.Count_And_Get(
2400: p_encoded => FND_API.G_FALSE,
2401: p_count => x_msg_count,

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

2459:
2460: WHEN OTHERS THEN
2461: ROLLBACK TO update_orig_system;
2462: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2463: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2464: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2465: FND_MSG_PUB.ADD;
2466: FND_MSG_PUB.Count_And_Get(
2467: p_encoded => FND_API.G_FALSE,

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

2460: WHEN OTHERS THEN
2461: ROLLBACK TO update_orig_system;
2462: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2463: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2464: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2465: FND_MSG_PUB.ADD;
2466: FND_MSG_PUB.Count_And_Get(
2467: p_encoded => FND_API.G_FALSE,
2468: p_count => x_msg_count,