APPS.IGS_DA_PURGE_RQST_PKG dependencies on FND_API

Line 53: RAISE FND_API.G_EXC_ERROR;

49: IF (p_batch_id IS NULL) THEN
50: FND_MESSAGE.Set_Name ('IGS', 'IGS_DA_BTCH_ID_NOT_FND');
51: FND_MESSAGE.Set_Token ('BATCH_ID', p_batch_id);
52: FND_MSG_PUB.ADD;
53: RAISE FND_API.G_EXC_ERROR;
54: ELSE
55: --
56: FOR l_req_stdnts IN cur_req_stdnts LOOP
57: igs_da_req_stdnts_pkg.delete_row (

Line 94: WHEN FND_API.G_EXC_ERROR THEN

90: --
91: END IF ;
92: --
93: EXCEPTION
94: WHEN FND_API.G_EXC_ERROR THEN
95: IF (cur_req_stdnts%ISOPEN) THEN
96: CLOSE cur_req_stdnts;
97: END IF;
98: IF (cur_req_ftrs%ISOPEN) THEN

Line 107: x_status := FND_API.G_RET_STS_ERROR;

103: END IF;
104: IF (cur_req_rqst%ISOPEN) THEN
105: CLOSE cur_req_rqst;
106: END IF;
107: x_status := FND_API.G_RET_STS_ERROR;
108: WHEN OTHERS THEN
109: x_status := FND_API.G_RET_STS_UNEXP_ERROR;
110: IF (cur_req_stdnts%ISOPEN) THEN
111: CLOSE cur_req_stdnts;

Line 109: x_status := FND_API.G_RET_STS_UNEXP_ERROR;

105: CLOSE cur_req_rqst;
106: END IF;
107: x_status := FND_API.G_RET_STS_ERROR;
108: WHEN OTHERS THEN
109: x_status := FND_API.G_RET_STS_UNEXP_ERROR;
110: IF (cur_req_stdnts%ISOPEN) THEN
111: CLOSE cur_req_stdnts;
112: END IF;
113: IF (cur_req_ftrs%ISOPEN) THEN

Line 258: RAISE FND_API.G_EXC_ERROR;

254: p_requestor_id IS NULL AND
255: p_responsibility IS NULL AND
256: p_request_status IS NULL AND
257: p_request_type IS NULL) THEN
258: RAISE FND_API.G_EXC_ERROR;
259: ELSE
260: --
261: FOR l_cur_request IN cur_request LOOP
262: FOR l_cur_req_stdnts IN cur_req_stdnts (l_cur_request.batch_id) LOOP

Line 352: WHEN FND_API.G_EXC_ERROR THEN

348: FND_MESSAGE.SET_TOKEN ('COUNT', l_count);
349: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.Get);
350: --
351: EXCEPTION
352: WHEN FND_API.G_EXC_ERROR THEN
353: errbuf := FND_MESSAGE.GET_STRING('IGS','IGS_DA_NO_PARAM');
354: retcode := 2;
355: ROLLBACK TO s_before_delete;
356: WHEN OTHERS THEN