DBA Data[Home] [Help]

APPS.CSFW_ATTACHMENT_PVT dependencies on FND_API

Line 92: x_return_status := FND_API.G_RET_STS_SUCCESS;

88: 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_incident_id);
96: FETCH l_max_seq_no_cursor INTO l_seq_num;

Line 205: x_return_status := FND_API.G_RET_STS_ERROR;

201:
202: EXCEPTION
203:
204: WHEN RECORD_NOT_INSERTED THEN
205: x_return_status := FND_API.G_RET_STS_ERROR;
206: p_error_msg := 'Record not inserted';
207:
208: WHEN ATTACH_FAILED THEN
209: x_return_status := FND_API.G_RET_STS_ERROR;

Line 209: x_return_status := FND_API.G_RET_STS_ERROR;

205: x_return_status := FND_API.G_RET_STS_ERROR;
206: p_error_msg := 'Record not inserted';
207:
208: WHEN ATTACH_FAILED THEN
209: x_return_status := FND_API.G_RET_STS_ERROR;
210: p_error_msg := 'Attachment of BLOB:' || l_fnd_lobs_id || ' to Service Request Number:'|| p_incident_number || ' failed';
211:
212: WHEN OTHERS THEN
213:

Line 215: x_return_status := FND_API.G_RET_STS_ERROR;

211:
212: WHEN OTHERS THEN
213:
214: p_error_msg := SQLERRM;
215: x_return_status := FND_API.G_RET_STS_ERROR;
216:
217: END UPLOAD_ATTACHMENT;
218:
219: END CSFW_ATTACHMENT_PVT;