194: WHEN OTHERS THEN
195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
196: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
197: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
198: FND_MSG_PUB.ADD;
199: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
200: P_data => x_message_list);
201: END insert_operation_activity;
202:
195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
196: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
197: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
198: FND_MSG_PUB.ADD;
199: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
200: P_data => x_message_list);
201: END insert_operation_activity;
202:
203: /*===============================================
397: WHEN OTHERS THEN
398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
399: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
400: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
401: FND_MSG_PUB.ADD;
402: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
403: P_data => x_message_list);
404:
405: END update_operation_activity;
398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
399: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
400: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
401: FND_MSG_PUB.ADD;
402: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
403: P_data => x_message_list);
404:
405: END update_operation_activity;
406:
441: WHEN OTHERS THEN
442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
443: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
444: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
445: FND_MSG_PUB.ADD;
446: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
447: P_data => x_message_list);
448:
449: l_errmsg := sqlerrm;
442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
443: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
444: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
445: FND_MSG_PUB.ADD;
446: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
447: P_data => x_message_list);
448:
449: l_errmsg := sqlerrm;
450: