132: INTO l_dummy
133: FROM HZ_RELATIONSHIP_TYPES
134: WHERE RELATIONSHIP_TYPE_ID = l_relationship_type_id;
135:
136: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
137: FND_MESSAGE.SET_TOKEN('COLUMN', 'relationship_type_id');
138: FND_MSG_PUB.ADD;
139: RAISE FND_API.G_EXC_ERROR;
140:
133: FROM HZ_RELATIONSHIP_TYPES
134: WHERE RELATIONSHIP_TYPE_ID = l_relationship_type_id;
135:
136: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
137: FND_MESSAGE.SET_TOKEN('COLUMN', 'relationship_type_id');
138: FND_MSG_PUB.ADD;
139: RAISE FND_API.G_EXC_ERROR;
140:
141: EXCEPTION
527: p_object_version_number = l_object_version_number
528: )
529: )
530: THEN
531: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
532: FND_MESSAGE.SET_TOKEN('TABLE', 'relationship_type_id');
533: FND_MSG_PUB.ADD;
534: RAISE FND_API.G_EXC_ERROR;
535: END IF;
528: )
529: )
530: THEN
531: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
532: FND_MESSAGE.SET_TOKEN('TABLE', 'relationship_type_id');
533: FND_MSG_PUB.ADD;
534: RAISE FND_API.G_EXC_ERROR;
535: END IF;
536:
536:
537: p_object_version_number := NVL(l_object_version_number, 1) + 1;
538:
539: EXCEPTION WHEN NO_DATA_FOUND THEN
540: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
541: FND_MESSAGE.SET_TOKEN('RECORD', 'relationship_type');
542: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_relationship_type_rec.relationship_type_id),'null'));
543: FND_MSG_PUB.ADD;
544: RAISE FND_API.G_EXC_ERROR;
537: p_object_version_number := NVL(l_object_version_number, 1) + 1;
538:
539: EXCEPTION WHEN NO_DATA_FOUND THEN
540: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
541: FND_MESSAGE.SET_TOKEN('RECORD', 'relationship_type');
542: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_relationship_type_rec.relationship_type_id),'null'));
543: FND_MSG_PUB.ADD;
544: RAISE FND_API.G_EXC_ERROR;
545: END;
538:
539: EXCEPTION WHEN NO_DATA_FOUND THEN
540: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
541: FND_MESSAGE.SET_TOKEN('RECORD', 'relationship_type');
542: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_relationship_type_rec.relationship_type_id),'null'));
543: FND_MSG_PUB.ADD;
544: RAISE FND_API.G_EXC_ERROR;
545: END;
546:
730:
731: WHEN OTHERS THEN
732: ROLLBACK TO create_relationship_type;
733: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
734: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
735: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
736: FND_MSG_PUB.ADD;
737: FND_MSG_PUB.Count_And_Get(
738: p_encoded => FND_API.G_FALSE,
731: WHEN OTHERS THEN
732: ROLLBACK TO create_relationship_type;
733: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
734: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
735: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
736: FND_MSG_PUB.ADD;
737: FND_MSG_PUB.Count_And_Get(
738: p_encoded => FND_API.G_FALSE,
739: p_count => x_msg_count,
827: p_data => x_msg_data);
828: WHEN OTHERS THEN
829: ROLLBACK TO update_relationship_type;
830: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
831: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
832: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
833: FND_MSG_PUB.ADD;
834: FND_MSG_PUB.Count_And_Get(
835: p_encoded => FND_API.G_FALSE,
828: WHEN OTHERS THEN
829: ROLLBACK TO update_relationship_type;
830: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
831: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
832: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
833: FND_MSG_PUB.ADD;
834: FND_MSG_PUB.Count_And_Get(
835: p_encoded => FND_API.G_FALSE,
836: p_count => x_msg_count,