102:
103: WHEN OTHERS THEN
104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
105: IF (SQLCODE IS NOT NULL) THEN
106: FND_MESSAGE.SET_NAME('INV','INV_LOTC_SQL_ERROR');
107: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
108: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM(SQLCODE));
109: FND_MSG_PUB.Add;
110: END IF;
103: WHEN OTHERS THEN
104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
105: IF (SQLCODE IS NOT NULL) THEN
106: FND_MESSAGE.SET_NAME('INV','INV_LOTC_SQL_ERROR');
107: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
108: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM(SQLCODE));
109: FND_MSG_PUB.Add;
110: END IF;
111: FND_MSG_PUB.Count_AND_GET
104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
105: IF (SQLCODE IS NOT NULL) THEN
106: FND_MESSAGE.SET_NAME('INV','INV_LOTC_SQL_ERROR');
107: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
108: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM(SQLCODE));
109: FND_MSG_PUB.Add;
110: END IF;
111: FND_MSG_PUB.Count_AND_GET
112: (p_count => x_msg_count, p_data => x_msg_data);
170:
171: WHEN OTHERS THEN
172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
173: IF (SQLCODE IS NOT NULL) THEN
174: FND_MESSAGE.SET_NAME('INV','INV_LOTC_SQL_ERROR');
175: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
176: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM(SQLCODE));
177: FND_MSG_PUB.Add;
178: END IF;
171: WHEN OTHERS THEN
172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
173: IF (SQLCODE IS NOT NULL) THEN
174: FND_MESSAGE.SET_NAME('INV','INV_LOTC_SQL_ERROR');
175: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
176: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM(SQLCODE));
177: FND_MSG_PUB.Add;
178: END IF;
179: FND_MSG_PUB.Count_AND_GET
172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
173: IF (SQLCODE IS NOT NULL) THEN
174: FND_MESSAGE.SET_NAME('INV','INV_LOTC_SQL_ERROR');
175: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
176: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM(SQLCODE));
177: FND_MSG_PUB.Add;
178: END IF;
179: FND_MSG_PUB.Count_AND_GET
180: (p_count => x_msg_count, p_data => x_msg_data);