APPS.MTL_LOT_CONV_AUD_DET_PKG dependencies on FND_API

Line 41: x_return_status := FND_API.G_RET_STS_SUCCESS;

37: l_aud_det_seq NUMBER;
38:
39:
40: BEGIN
41: x_return_status := FND_API.G_RET_STS_SUCCESS;
42: IF (X_CONV_AUDIT_DETAIL_ID IS NULL) THEN
43: OPEN GET_AUD_DET_SEQ;
44: FETCH GET_AUD_DET_SEQ INTO l_aud_det_seq;
45: IF (SQL%NOTFOUND) then

Line 104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

100:
101: EXCEPTION
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));

Line 145: x_return_status := FND_API.G_RET_STS_SUCCESS;

141:
142: BEGIN
143:
144:
145: x_return_status := FND_API.G_RET_STS_SUCCESS;
146: UPDATE MTL_LOT_CONV_AUDIT_DETAILS SET
147: CONV_AUDIT_ID = X_CONV_AUDIT_ID,
148: REVISION = X_REVISION,
149: ORGANIZATION_ID = X_ORGANIZATION_ID,

Line 172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

168:
169: EXCEPTION
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));