DBA Data[Home] [Help]

APPS.MTL_LOT_CONV_AUDIT_PKG dependencies on FND_API

Line 36: x_return_status := FND_API.G_RET_STS_SUCCESS;

32: l_audit_seq NUMBER;
33:
34:
35: BEGIN
36: x_return_status := FND_API.G_RET_STS_SUCCESS;
37: IF (X_CONV_AUDIT_ID IS NULL) THEN
38: OPEN GET_AUDIT_SEQ;
39: FETCH GET_AUDIT_SEQ INTO l_audit_seq;
40: X_CONV_AUDIT_ID := l_audit_seq;

Line 83: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

79:
80: EXCEPTION
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));

Line 118: x_return_status := FND_API.G_RET_STS_SUCCESS;

114:
115: BEGIN
116:
117:
118: x_return_status := FND_API.G_RET_STS_SUCCESS;
119: UPDATE MTL_LOT_CONV_AUDIT SET
120: CONVERSION_ID = X_CONVERSION_ID,
121: CONVERSION_DATE = X_CONVERSION_DATE,
122: UPDATE_TYPE_INDICATOR = X_UPDATE_TYPE_INDICATOR,

Line 140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

136: EXCEPTION
137:
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));