157: x_msg_data);
158: EXCEPTION
159: WHEN OTHERS THEN
160: x_return_status := FND_API.G_RET_STS_ERROR;
161: FND_MESSAGE.SET_NAME('CZ', 'CZ_PB_CREATE_PB_REQUEST_ERR');
162: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
163: FND_MSG_PUB.ADD;
164: fnd_msg_pub.count_and_get(p_count => x_msg_count,
165: p_data => x_msg_data);
158: EXCEPTION
159: WHEN OTHERS THEN
160: x_return_status := FND_API.G_RET_STS_ERROR;
161: FND_MESSAGE.SET_NAME('CZ', 'CZ_PB_CREATE_PB_REQUEST_ERR');
162: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
163: FND_MSG_PUB.ADD;
164: fnd_msg_pub.count_and_get(p_count => x_msg_count,
165: p_data => x_msg_data);
166: END create_publication_request;
192: x_msg_data);
193: EXCEPTION
194: WHEN OTHERS THEN
195: x_return_status := FND_API.G_RET_STS_ERROR;
196: FND_MESSAGE.SET_NAME('CZ', 'CZ_EDIT_PUB_ERR');
197: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
198: FND_MSG_PUB.ADD;
199: fnd_msg_pub.count_and_get(p_count => x_msg_count,
200: p_data => x_msg_data);
193: EXCEPTION
194: WHEN OTHERS THEN
195: x_return_status := FND_API.G_RET_STS_ERROR;
196: FND_MESSAGE.SET_NAME('CZ', 'CZ_EDIT_PUB_ERR');
197: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
198: FND_MSG_PUB.ADD;
199: fnd_msg_pub.count_and_get(p_count => x_msg_count,
200: p_data => x_msg_data);
201: END EDIT_PUBLICATION;
257: x_msg_data);
258: EXCEPTION
259: WHEN OTHERS THEN
260: x_return_status := FND_API.G_RET_STS_ERROR;
261: FND_MESSAGE.SET_NAME('CZ', 'CZ_EDIT_PUB_ERR');
262: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
263: FND_MSG_PUB.ADD;
264: fnd_msg_pub.count_and_get(p_count => x_msg_count,
265: p_data => x_msg_data);
258: EXCEPTION
259: WHEN OTHERS THEN
260: x_return_status := FND_API.G_RET_STS_ERROR;
261: FND_MESSAGE.SET_NAME('CZ', 'CZ_EDIT_PUB_ERR');
262: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
263: FND_MSG_PUB.ADD;
264: fnd_msg_pub.count_and_get(p_count => x_msg_count,
265: p_data => x_msg_data);
266: END EDIT_PUBLICATION;
278: cz_pb_mgr.delete_publication(publicationId,x_return_status,x_msg_count,x_msg_data);
279: EXCEPTION
280: WHEN OTHERS THEN
281: x_return_status := FND_API.G_RET_STS_ERROR;
282: FND_MESSAGE.SET_NAME('CZ', 'CZ_DELETE_PUB_ERR');
283: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
284: FND_MSG_PUB.ADD;
285: fnd_msg_pub.count_and_get(p_count => x_msg_count,
286: p_data => x_msg_data);
279: EXCEPTION
280: WHEN OTHERS THEN
281: x_return_status := FND_API.G_RET_STS_ERROR;
282: FND_MESSAGE.SET_NAME('CZ', 'CZ_DELETE_PUB_ERR');
283: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
284: FND_MSG_PUB.ADD;
285: fnd_msg_pub.count_and_get(p_count => x_msg_count,
286: p_data => x_msg_data);
287: END DELETE_PUBLICATION;