APPS.JTF_TTY_GEN_TERR_PVT dependencies on FND_LOG

Line 480: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

476: idx integer;
477:
478: BEGIN
479:
480: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
481: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
482: 'jtf.plsql.JTF_TTY_GEN_TERR_PVT.delete_bulk_TGA',
483: 'Start of the procedure JTF_TTY_GEN_TERR_PVT.delete_bulk_TGA');
484: END IF;

Line 481: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

477:
478: BEGIN
479:
480: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
481: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
482: 'jtf.plsql.JTF_TTY_GEN_TERR_PVT.delete_bulk_TGA',
483: 'Start of the procedure JTF_TTY_GEN_TERR_PVT.delete_bulk_TGA');
484: END IF;
485:

Line 488: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

484: END IF;
485:
486: x_return_status := FND_API.G_RET_STS_SUCCESS;
487:
488: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
489: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
490: 'jtf.plsql.JTF_TTY_GEN_TERR_PVT.delete_bulk_TGA',
491: 'Deleting from JTF_TERR... tables');
492: END IF;

Line 489: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

485:
486: x_return_status := FND_API.G_RET_STS_SUCCESS;
487:
488: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
489: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
490: 'jtf.plsql.JTF_TTY_GEN_TERR_PVT.delete_bulk_TGA',
491: 'Deleting from JTF_TERR... tables');
492: END IF;
493:

Line 566: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

562: AND ta.terr_group_id = p_terrGrpId_tbl(idx)
563: );
564: END IF;
565:
566: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
567: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
568: 'jtf.plsql.JTF_TTY_GEN_TERR_PVT.delete_bulk_TGA',
569: 'End of the procedure JTF_TTY_GEN_TERR_PVT.delete_bulk_TGA');
570: END IF;

Line 567: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

563: );
564: END IF;
565:
566: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
567: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
568: 'jtf.plsql.JTF_TTY_GEN_TERR_PVT.delete_bulk_TGA',
569: 'End of the procedure JTF_TTY_GEN_TERR_PVT.delete_bulk_TGA');
570: END IF;
571:

Line 579: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

575: WHEN OTHERS THEN
576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
577: x_msg_data := SQLCODE || ' : ' || SQLERRM;
578: x_msg_count := 1;
579: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
580: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
581: 'jtf.plsql.JTF_TTY_GEN_TERR_PVT.delete_bulk_TGA.OTHERS',
582: substr(x_msg_data, 1, 4000));
583: END IF;

Line 580: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
577: x_msg_data := SQLCODE || ' : ' || SQLERRM;
578: x_msg_count := 1;
579: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
580: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
581: 'jtf.plsql.JTF_TTY_GEN_TERR_PVT.delete_bulk_TGA.OTHERS',
582: substr(x_msg_data, 1, 4000));
583: END IF;
584: RAISE;