eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_TERR_ASSIGN_PUB dependencies on JTF_TERR_ASSIGN_PUB

Line 1: Package Body JTF_TERR_ASSIGN_PUB AS

1: Package Body JTF_TERR_ASSIGN_PUB AS
2: /* $Header: jtfptrwb.pls 120.7 2006/03/30 17:15:37 achanda ship $ */
3: ---------------------------------------------------------------------
4: -- Start of Comments
5: -- ---------------------------------------------------

Line 6: -- PACKAGE NAME: JTF_TERR_ASSIGN_PUB

2: /* $Header: jtfptrwb.pls 120.7 2006/03/30 17:15:37 achanda ship $ */
3: ---------------------------------------------------------------------
4: -- Start of Comments
5: -- ---------------------------------------------------
6: -- PACKAGE NAME: JTF_TERR_ASSIGN_PUB
7: -- ---------------------------------------------------
8: -- PURPOSE
9: -- Joint task force applications territory manager public api's.
10: -- This package is a public API for getting winning territories

Line 75: G_PKG_NAME CONSTANT VARCHAR2(30):='JTF_TERR_ASSIGN_PUB';

71: -- ***************************************************
72: -- GLOBAL VARIABLES and RECORD TYPE DEFINITIONS
73: -- ***************************************************
74:
75: G_PKG_NAME CONSTANT VARCHAR2(30):='JTF_TERR_ASSIGN_PUB';
76: G_FILE_NAME CONSTANT VARCHAR2(12):='jtfptrwb.pls';
77:
78: G_NEW_LINE VARCHAR2(02) := fnd_global.local_chr(10);
79: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;

Line 126: 'jtf.plsql.jtf_terr_assign_pub.get_winners.begin',

122:
123: -- debug message
124: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
125: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
126: 'jtf.plsql.jtf_terr_assign_pub.get_winners.begin',
127: 'Start of the procedure jtf_terr_assign_pub.get_winners');
128: END IF;
129:
130: -- Standard call to check for call compatibility.

Line 127: 'Start of the procedure jtf_terr_assign_pub.get_winners');

123: -- debug message
124: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
125: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
126: 'jtf.plsql.jtf_terr_assign_pub.get_winners.begin',
127: 'Start of the procedure jtf_terr_assign_pub.get_winners');
128: END IF;
129:
130: -- Standard call to check for call compatibility.
131: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 821: 'jtf.plsql.jtf_terr_assign_pub.get_winners.process_match',

817:
818: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
819: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
820: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
821: 'jtf.plsql.jtf_terr_assign_pub.get_winners.process_match',
822: 'API JTY_ASSIGN_REALTIME_PUB.process_match has failed');
823: END IF;
824: RAISE FND_API.G_EXC_ERROR;
825: END IF;

Line 830: 'jtf.plsql.jtf_terr_assign_pub.get_winners.process_match',

826:
827: -- debug message
828: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
829: FND_LOG.string(FND_LOG.LEVEL_EVENT,
830: 'jtf.plsql.jtf_terr_assign_pub.get_winners.process_match',
831: 'Finish calling procedure JTY_ASSIGN_REALTIME_PUB.process_match');
832: END IF;
833:
834: JTY_ASSIGN_REALTIME_PUB.process_winners (

Line 849: 'jtf.plsql.jtf_terr_assign_pub.get_winners.process_winners',

845:
846: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
847: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
848: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
849: 'jtf.plsql.jtf_terr_assign_pub.get_winners.process_winners',
850: 'JTY_ASSIGN_REALTIME_PUB.process_winners has failed');
851: END IF;
852: RAISE FND_API.G_EXC_ERROR;
853: END IF;

Line 858: 'jtf.plsql.jtf_terr_assign_pub.get_winners.process_winners',

854:
855: -- debug message
856: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
857: FND_LOG.string(FND_LOG.LEVEL_EVENT,
858: 'jtf.plsql.jtf_terr_assign_pub.get_winners.process_winners',
859: 'Finish calling procedure JTY_ASSIGN_REALTIME_PUB.process_winners');
860: END IF;
861:
862: l_counter := lx_winners_rec.terr_id.FIRST;

Line 902: 'jtf.plsql.jtf_terr_assign_pub.get_winners.end',

898:
899: -- debug message
900: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
901: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
902: 'jtf.plsql.jtf_terr_assign_pub.get_winners.end',
903: 'End of the procedure jtf_terr_assign_pub.get_winners');
904: END IF;
905:
906: EXCEPTION

Line 903: 'End of the procedure jtf_terr_assign_pub.get_winners');

899: -- debug message
900: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
901: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
902: 'jtf.plsql.jtf_terr_assign_pub.get_winners.end',
903: 'End of the procedure jtf_terr_assign_pub.get_winners');
904: END IF;
905:
906: EXCEPTION
907: WHEN FND_API.G_EXC_ERROR THEN

Line 910: 'jtf.plsql.jtf_terr_assign_pub.get_winners.g_exc_error',

906: EXCEPTION
907: WHEN FND_API.G_EXC_ERROR THEN
908: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
909: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
910: 'jtf.plsql.jtf_terr_assign_pub.get_winners.g_exc_error',
911: substr(x_msg_data, 1, 4000));
912: END IF;
913:
914: WHEN OTHERS THEN

Line 920: 'jtf.plsql.jtf_terr_assign_pub.get_winners.other',

916: x_msg_data := SQLCODE || ' : ' || SQLERRM;
917: x_msg_count := 1;
918: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
919: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
920: 'jtf.plsql.jtf_terr_assign_pub.get_winners.other',
921: substr(x_msg_data, 1, 4000));
922: END IF;
923:
924: End Get_Winners;

Line 926: END JTF_TERR_ASSIGN_PUB;

922: END IF;
923:
924: End Get_Winners;
925:
926: END JTF_TERR_ASSIGN_PUB;