109:
110: WHEN OTHERS THEN
111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
112: IF (SQLCODE IS NOT NULL) THEN
113: FND_MESSAGE.SET_NAME('GMI','GMI_LOTC_SQL_ERROR');
114: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
115: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM(SQLCODE));
116: FND_MSG_PUB.Add;
117: END IF;
110: WHEN OTHERS THEN
111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
112: IF (SQLCODE IS NOT NULL) THEN
113: FND_MESSAGE.SET_NAME('GMI','GMI_LOTC_SQL_ERROR');
114: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
115: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM(SQLCODE));
116: FND_MSG_PUB.Add;
117: END IF;
118: FND_MSG_PUB.Count_AND_GET
111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
112: IF (SQLCODE IS NOT NULL) THEN
113: FND_MESSAGE.SET_NAME('GMI','GMI_LOTC_SQL_ERROR');
114: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
115: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM(SQLCODE));
116: FND_MSG_PUB.Add;
117: END IF;
118: FND_MSG_PUB.Count_AND_GET
119: (p_count => x_msg_count, p_data => x_msg_data);
181:
182: WHEN OTHERS THEN
183: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
184: IF (SQLCODE IS NOT NULL) THEN
185: FND_MESSAGE.SET_NAME('GMI','GMI_LOTC_SQL_ERROR');
186: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
187: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM(SQLCODE));
188: FND_MSG_PUB.Add;
189: END IF;
182: WHEN OTHERS THEN
183: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
184: IF (SQLCODE IS NOT NULL) THEN
185: FND_MESSAGE.SET_NAME('GMI','GMI_LOTC_SQL_ERROR');
186: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
187: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM(SQLCODE));
188: FND_MSG_PUB.Add;
189: END IF;
190: FND_MSG_PUB.Count_AND_GET
183: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
184: IF (SQLCODE IS NOT NULL) THEN
185: FND_MESSAGE.SET_NAME('GMI','GMI_LOTC_SQL_ERROR');
186: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
187: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM(SQLCODE));
188: FND_MSG_PUB.Add;
189: END IF;
190: FND_MSG_PUB.Count_AND_GET
191: (p_count => x_msg_count, p_data => x_msg_data);
232:
233: WHEN OTHERS THEN
234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
235: IF (SQLCODE IS NOT NULL) THEN
236: FND_MESSAGE.SET_NAME('INV','INV_LOTC_SQL_ERROR');
237: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
238: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM(SQLCODE));
239: FND_MSG_PUB.Add;
240: END IF;
233: WHEN OTHERS THEN
234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
235: IF (SQLCODE IS NOT NULL) THEN
236: FND_MESSAGE.SET_NAME('INV','INV_LOTC_SQL_ERROR');
237: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
238: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM(SQLCODE));
239: FND_MSG_PUB.Add;
240: END IF;
241: FND_MSG_PUB.Count_AND_GET
234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
235: IF (SQLCODE IS NOT NULL) THEN
236: FND_MESSAGE.SET_NAME('INV','INV_LOTC_SQL_ERROR');
237: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
238: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM(SQLCODE));
239: FND_MSG_PUB.Add;
240: END IF;
241: FND_MSG_PUB.Count_AND_GET
242: (p_count => x_msg_count, p_data => x_msg_data);
278: FETCH c INTO recinfo;
279:
280: IF (c%NOTFOUND) THEN
281: CLOSE c;
282: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
283: app_exception.raise_exception;
284: END IF;
285:
286: CLOSE c;
324: END IF;
325:
326: EXCEPTION
327: WHEN record_changed THEN
328: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
329: app_exception.raise_exception;
330: END lock_row;
331:
332: