98: CLOSE Cur_check_resource;
99: FND_MESSAGE.SET_NAME('GMD', 'GMD_DUP_ACTV_RSRC');
100: FND_MESSAGE.SET_TOKEN('RESOURCE', p_oprn_rsrc_tbl(i).resources);
101: FND_MESSAGE.SET_TOKEN('ACTIVITY', l_activity);
102: FND_MSG_PUB.ADD;
103: RAISE FND_API.G_EXC_ERROR;
104: END IF;
105: CLOSE Cur_check_resource;
106:
222: WHEN OTHERS THEN
223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
224: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
225: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
226: FND_MSG_PUB.ADD;
227: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
228: P_data => x_message_list);
229:
230:
223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
224: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
225: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
226: FND_MSG_PUB.ADD;
227: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
228: P_data => x_message_list);
229:
230:
231: END insert_operation_resources;
448: WHEN OTHERS THEN
449: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
450: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
451: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
452: FND_MSG_PUB.ADD;
453: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
454: P_data => x_message_list);
455:
456:
449: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
450: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
451: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
452: FND_MSG_PUB.ADD;
453: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
454: P_data => x_message_list);
455:
456:
457: END update_operation_resources;
507: WHEN OTHERS THEN
508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
509: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
510: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
511: FND_MSG_PUB.ADD;
512: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
513: P_data => x_message_list);
514:
515:
508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
509: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
510: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
511: FND_MSG_PUB.ADD;
512: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
513: P_data => x_message_list);
514:
515:
516: END delete_operation_resource;