APPS.JTF_TTY_GEN_TERR_PVT dependencies on JTF_TTY_GEN_TERR_PVT

Line 1: Package Body JTF_TTY_GEN_TERR_PVT AS

1: Package Body JTF_TTY_GEN_TERR_PVT AS
2: /* $Header: jtftsstb.pls 120.22 2006/09/29 07:30:35 spai ship $ */
3: -- Start of Comments
4: -- ---------------------------------------------------
5: -- PACKAGE NAME: JTF_TTY_GEN_TERR_PVT

Line 5: -- PACKAGE NAME: JTF_TTY_GEN_TERR_PVT

1: Package Body JTF_TTY_GEN_TERR_PVT AS
2: /* $Header: jtftsstb.pls 120.22 2006/09/29 07:30:35 spai ship $ */
3: -- Start of Comments
4: -- ---------------------------------------------------
5: -- PACKAGE NAME: JTF_TTY_GEN_TERR_PVT
6: -- ---------------------------------------------------
7: -- PURPOSE
8: -- Joint task force core territory manager public api's.
9: -- This package is used to generate the territories

Line 482: 'jtf.plsql.JTF_TTY_GEN_TERR_PVT.delete_bulk_TGA',

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:
486: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 483: 'Start of the procedure JTF_TTY_GEN_TERR_PVT.delete_bulk_TGA');

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:
486: x_return_status := FND_API.G_RET_STS_SUCCESS;
487:

Line 490: 'jtf.plsql.JTF_TTY_GEN_TERR_PVT.delete_bulk_TGA',

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:
494: --Delete Territory Values

Line 568: 'jtf.plsql.JTF_TTY_GEN_TERR_PVT.delete_bulk_TGA',

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:
572: EXCEPTION

Line 569: 'End of the procedure JTF_TTY_GEN_TERR_PVT.delete_bulk_TGA');

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:
572: EXCEPTION
573: WHEN NO_DATA_FOUND THEN

Line 581: 'jtf.plsql.JTF_TTY_GEN_TERR_PVT.delete_bulk_TGA.OTHERS',

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;
585: END delete_bulk_TGA;

Line 7939: procedure call in UI : JTF_TTY_GEN_TERR_PVT.create_catchall_terr_rsc.

7935:
7936: l_init_msg_list :=FND_API.G_TRUE;
7937:
7938: /* The resources for catch ALL territory will be created through a seperate
7939: procedure call in UI : JTF_TTY_GEN_TERR_PVT.create_catchall_terr_rsc.
7940:
7941: SELECT JTF_TERR_RSC_S.NEXTVAL
7942: INTO l_terr_rsc_id
7943: FROM DUAL;

Line 13123: END JTF_TTY_GEN_TERR_PVT;

13119: AND jta.terr_group_id = p_terr_group_id;
13120:
13121: END update_terr_for_na;
13122:
13123: END JTF_TTY_GEN_TERR_PVT;