44: EXCEPTION
45: WHEN OTHERS THEN
46: ROLLBACK TO create_item_instance_event;
47: x_return_status := FND_API.G_RET_STS_ERROR;
48: FND_MESSAGE.SET_NAME('CSI','CSI_CREATE_EVENT_ERROR');
49: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
50: FND_MSG_PUB.Add;
51: FND_MSG_PUB.Count_And_Get
52: (p_count => x_msg_count
45: WHEN OTHERS THEN
46: ROLLBACK TO create_item_instance_event;
47: x_return_status := FND_API.G_RET_STS_ERROR;
48: FND_MESSAGE.SET_NAME('CSI','CSI_CREATE_EVENT_ERROR');
49: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
50: FND_MSG_PUB.Add;
51: FND_MSG_PUB.Count_And_Get
52: (p_count => x_msg_count
53: ,p_data => x_msg_data);
97: EXCEPTION
98: WHEN OTHERS THEN
99: ROLLBACK TO update_item_instance_event;
100: x_return_status := FND_API.G_RET_STS_ERROR;
101: FND_MESSAGE.SET_NAME('CSI','CSI_UPDATE_EVENT_ERROR');
102: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
103: FND_MSG_PUB.Add;
104: FND_MSG_PUB.Count_And_Get
105: (p_count => x_msg_count
98: WHEN OTHERS THEN
99: ROLLBACK TO update_item_instance_event;
100: x_return_status := FND_API.G_RET_STS_ERROR;
101: FND_MESSAGE.SET_NAME('CSI','CSI_UPDATE_EVENT_ERROR');
102: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
103: FND_MSG_PUB.Add;
104: FND_MSG_PUB.Count_And_Get
105: (p_count => x_msg_count
106: ,p_data => x_msg_data);