71: gmd_debug.put_line('In insert_operation_activity private.');
72: END IF;
73:
74: /* Initially let us assign the return status to success */
75: x_return_status := FND_API.g_ret_sts_success;
76:
77: /* get values for row who cols */
78: IF NOT gmd_api_grp.setup_done THEN
79: gmd_api_grp.setup_done := gmd_api_grp.setup;
188: END IF;
189:
190: EXCEPTION
191: WHEN setup_failure THEN
192: x_return_status := FND_API.G_RET_STS_ERROR;
193:
194: WHEN OTHERS THEN
195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
196: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
191: WHEN setup_failure THEN
192: x_return_status := FND_API.G_RET_STS_ERROR;
193:
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,
227: gmd_debug.put_line(' In update_operation_activity private');
228: END IF;
229:
230: /* Initially let us assign the return status to success */
231: x_return_status := FND_API.g_ret_sts_success;
232:
233: OPEN retrieve_oprn_actv(p_oprn_line_id);
234: FETCH retrieve_oprn_actv INTO v_oprn_actv_update_rec;
235: CLOSE retrieve_oprn_actv;
391: END IF;
392:
393: EXCEPTION
394: WHEN setup_failure THEN
395: x_return_status := FND_API.G_RET_STS_ERROR;
396:
397: WHEN OTHERS THEN
398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
399: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
394: WHEN setup_failure THEN
395: x_return_status := FND_API.G_RET_STS_ERROR;
396:
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,
435:
436:
437: EXCEPTION
438: WHEN setup_failure THEN
439: x_return_status := FND_API.G_RET_STS_ERROR;
440:
441: WHEN OTHERS THEN
442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
443: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
438: WHEN setup_failure THEN
439: x_return_status := FND_API.G_RET_STS_ERROR;
440:
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,