29: FND_MSG_PUB.ADD;
30: X_return_status := FND_API.g_ret_sts_error;
31: END IF;
32: EXCEPTION
33: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
34: IF Cur_lock_header%ISOPEN THEN
35: CLOSE Cur_lock_header;
36: END IF;
37: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECORD_LOCK');
73: FND_MSG_PUB.ADD;
74: X_return_status := FND_API.g_ret_sts_error;
75: END IF;
76: EXCEPTION
77: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
78: IF Cur_lock_details%ISOPEN THEN
79: CLOSE Cur_lock_details;
80: END IF;
81: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECORD_LOCK');
171: FND_MSG_PUB.ADD;
172: X_return_status := FND_API.g_ret_sts_error;
173: END IF;
174: EXCEPTION
175: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
176: IF Cur_lock_header%ISOPEN THEN
177: CLOSE Cur_lock_header;
178: END IF;
179: FND_MESSAGE.SET_NAME('GME', 'GME_RECORD_LOCKED');
216: FND_MSG_PUB.ADD;
217: X_return_status := FND_API.g_ret_sts_error;
218: END IF;
219: EXCEPTION
220: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
221: IF Cur_lock_details%ISOPEN THEN
222: CLOSE Cur_lock_details;
223: END IF;
224: FND_MESSAGE.SET_NAME('GME', 'GME_RECORD_LOCKED');