APPS.JTF_TTY_NA_TERRGP dependencies on FND_API

Line 220: x_return_status := FND_API.G_RET_STS_SUCCESS;

216: 'jtf.plsql.JTF_TTY_NA_TERRGP.delete_bulk_TGA',
217: 'Start of the procedure JTF_TTY_NA_TERRGP.delete_bulk_TGA');
218: END IF;
219:
220: x_return_status := FND_API.G_RET_STS_SUCCESS;
221: l_terrGrpId_tbl := jtf_terr_number_list();
222: l_grpAcctId_tbl := jtf_terr_number_list();
223: l_acctId_tbl := jtf_terr_number_list();
224:

Line 283: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

279: x_msg_count,
280: x_msg_data );
281:
282:
283: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
284: -- debug message
285: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
286: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
287: 'jtf.plsql.JTF_TTY_NA_TERRGP.delete_bulk_TGA',

Line 291: RAISE FND_API.G_EXC_ERROR;

287: 'jtf.plsql.JTF_TTY_NA_TERRGP.delete_bulk_TGA',
288: 'JTF_TTY_GEN_TERR_PVT.delete_bulk_TGA API has failed');
289: END IF;
290:
291: RAISE FND_API.G_EXC_ERROR;
292: END IF;
293:
294: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
295: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

Line 312: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

308: EXCEPTION
309: WHEN NO_DATA_FOUND THEN
310: NULL;
311: WHEN OTHERS THEN
312: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
313: x_msg_data := SQLCODE || ' : ' || SQLERRM;
314: x_msg_count := 1;
315: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
316: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,