APPS.MTL_LOT_UOM_CONV_PKG dependencies on FND_API

Line 45: x_return_status := FND_API.G_RET_STS_SUCCESS;

41:
42:
43: BEGIN
44:
45: x_return_status := FND_API.G_RET_STS_SUCCESS;
46: IF (X_CONVERSION_ID IS NULL) THEN
47: OPEN GET_CONV_SEQ;
48: FETCH GET_CONV_SEQ INTO l_conv_seq;
49: X_CONVERSION_ID := l_conv_seq;

Line 111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

107: EXCEPTION
108:
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));

Line 154: x_return_status := FND_API.G_RET_STS_SUCCESS;

150: IS
151:
152: BEGIN
153:
154: x_return_status := FND_API.G_RET_STS_SUCCESS;
155: UPDATE MTL_LOT_UOM_CLASS_CONVERSIONS SET
156: LOT_NUMBER = X_LOT_NUMBER,
157: ORGANIZATION_ID = X_ORGANIZATION_ID,
158: INVENTORY_ITEM_ID = X_INVENTORY_ITEM_ID,

Line 183: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

179:
180: EXCEPTION
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));

Line 215: x_return_status := FND_API.G_RET_STS_SUCCESS;

211: IS
212:
213: BEGIN
214:
215: x_return_status := FND_API.G_RET_STS_SUCCESS;
216: UPDATE MTL_LOT_UOM_CLASS_CONVERSIONS SET
217: DISABLE_DATE = X_DISABLE_DATE,
218: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
219: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

230: EXCEPTION
231:
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));