DBA Data[Home] [Help]

APPS.CSFW_SIGNATURE_PVT dependencies on FND_API

Line 92: x_return_status := FND_API.G_RET_STS_SUCCESS;

88: DEBRIEF_ATTACH_FAILED EXCEPTION;
89:
90: BEGIN
91:
92: x_return_status := FND_API.G_RET_STS_SUCCESS;
93:
94: -- get the max seq no
95: open l_max_seq_no_cursor(p_debrief_header_id);
96: FETCH l_max_seq_no_cursor INTO l_seq_num;

Line 168: x_return_status := FND_API.G_RET_STS_ERROR;

164:
165: EXCEPTION
166:
167: WHEN RECORD_NOT_INSERTED THEN
168: x_return_status := FND_API.G_RET_STS_ERROR;
169: p_error_msg := 'Record not inserted';
170:
171: WHEN DEBRIEF_ATTACH_FAILED THEN
172: x_return_status := FND_API.G_RET_STS_ERROR;

Line 172: x_return_status := FND_API.G_RET_STS_ERROR;

168: x_return_status := FND_API.G_RET_STS_ERROR;
169: p_error_msg := 'Record not inserted';
170:
171: WHEN DEBRIEF_ATTACH_FAILED THEN
172: x_return_status := FND_API.G_RET_STS_ERROR;
173: p_error_msg := 'Attachment of BLOB:' || l_fnd_lobs_id || ' to Debrief Header Id:'|| p_debrief_header_id || ' failed';
174:
175: WHEN OTHERS THEN
176:

Line 178: x_return_status := FND_API.G_RET_STS_ERROR;

174:
175: WHEN OTHERS THEN
176:
177: p_error_msg := SQLERRM;
178: x_return_status := FND_API.G_RET_STS_ERROR;
179:
180: END UPLOAD_SIGNATURE;
181:
182: END CSFW_SIGNATURE_PVT;