81:
82: WHEN OTHERS THEN
83: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
84: IF (SQLCODE IS NOT NULL) THEN
85: FND_MESSAGE.SET_NAME('INV','INV_LOTC_SQL_ERROR');
86: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
87: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM(SQLCODE));
88: FND_MSG_PUB.Add;
89: END IF;
82: WHEN OTHERS THEN
83: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
84: IF (SQLCODE IS NOT NULL) THEN
85: FND_MESSAGE.SET_NAME('INV','INV_LOTC_SQL_ERROR');
86: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
87: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM(SQLCODE));
88: FND_MSG_PUB.Add;
89: END IF;
90: FND_MSG_PUB.Count_AND_GET
83: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
84: IF (SQLCODE IS NOT NULL) THEN
85: FND_MESSAGE.SET_NAME('INV','INV_LOTC_SQL_ERROR');
86: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
87: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM(SQLCODE));
88: FND_MSG_PUB.Add;
89: END IF;
90: FND_MSG_PUB.Count_AND_GET
91: (p_count => x_msg_count, p_data => x_msg_data);
138:
139: WHEN OTHERS THEN
140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
141: IF (SQLCODE IS NOT NULL) THEN
142: FND_MESSAGE.SET_NAME('INV','INV_LOTC_SQL_ERROR');
143: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
144: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM(SQLCODE));
145: FND_MSG_PUB.Add;
146: END IF;
139: WHEN OTHERS THEN
140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
141: IF (SQLCODE IS NOT NULL) THEN
142: FND_MESSAGE.SET_NAME('INV','INV_LOTC_SQL_ERROR');
143: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
144: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM(SQLCODE));
145: FND_MSG_PUB.Add;
146: END IF;
147: FND_MSG_PUB.Count_AND_GET
140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
141: IF (SQLCODE IS NOT NULL) THEN
142: FND_MESSAGE.SET_NAME('INV','INV_LOTC_SQL_ERROR');
143: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
144: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM(SQLCODE));
145: FND_MSG_PUB.Add;
146: END IF;
147: FND_MSG_PUB.Count_AND_GET
148: (p_count => x_msg_count, p_data => x_msg_data);