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_SALES_PUB dependencies on JTF_TERR_SALES_PUB

Line 1: Package Body JTF_TERR_SALES_PUB AS

1: Package Body JTF_TERR_SALES_PUB AS
2: /* $Header: jtfptsab.pls 120.5 2005/11/11 15:00:50 achanda ship $ */
3: -- Start of Comments
4: -- ---------------------------------------------------
5: -- PACKAGE NAME: JTF_SALES_TERRITORY_PUB

Line 51: G_PKG_NAME CONSTANT VARCHAR2(30):='JTF_TERR_SALES_PUB';

47: --
48: -- ***************************************************
49: -- GLOBAL VARIABLES
50: -- ***************************************************
51: G_PKG_NAME CONSTANT VARCHAR2(30):='JTF_TERR_SALES_PUB';
52: G_FILE_NAME CONSTANT VARCHAR2(12):='jtfptsab.pls';
53:
54: G_NEW_LINE VARCHAR2(02) := FND_GLOBAL.Local_Chr(10);
55: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;

Line 114: 'jtf.plsql.jtf_terr_sales_pub.get_winningterrmembers.g_exc_error',

110: EXCEPTION
111: WHEN FND_API.G_EXC_ERROR THEN
112: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
113: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
114: 'jtf.plsql.jtf_terr_sales_pub.get_winningterrmembers.g_exc_error',
115: substr(x_msg_data, 1, 4000));
116: END IF;
117:
118: WHEN OTHERS THEN

Line 124: 'jtf.plsql.jtf_terr_sales_pub.get_winningterrmembers.other',

120: x_msg_data := SQLCODE || ' : ' || SQLERRM;
121: x_msg_count := 1;
122: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
123: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
124: 'jtf.plsql.jtf_terr_sales_pub.get_winningterrmembers.other',
125: substr(x_msg_data, 1, 4000));
126: END IF;
127:
128: End Get_WinningTerrMembers;

Line 183: 'jtf.plsql.jtf_terr_sales_pub.get_winningterrmembers.g_exc_error',

179: EXCEPTION
180: WHEN FND_API.G_EXC_ERROR THEN
181: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
182: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
183: 'jtf.plsql.jtf_terr_sales_pub.get_winningterrmembers.g_exc_error',
184: substr(x_msg_data, 1, 4000));
185: END IF;
186:
187: WHEN OTHERS THEN

Line 193: 'jtf.plsql.jtf_terr_sales_pub.get_winningterrmembers.other',

189: x_msg_data := SQLCODE || ' : ' || SQLERRM;
190: x_msg_count := 1;
191: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
192: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
193: 'jtf.plsql.jtf_terr_sales_pub.get_winningterrmembers.other',
194: substr(x_msg_data, 1, 4000));
195: END IF;
196:
197: End Get_WinningTerrMembers;

Line 250: 'jtf.plsql.jtf_terr_sales_pub.get_winningterrmembers.begin',

246: BEGIN
247: -- debug message
248: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
249: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
250: 'jtf.plsql.jtf_terr_sales_pub.get_winningterrmembers.begin',
251: 'Start of the procedure jtf_terr_sales_pub.get_winningterrmembers');
252: END IF;
253:
254: -- Standard call to check for call compatibility.

Line 251: 'Start of the procedure jtf_terr_sales_pub.get_winningterrmembers');

247: -- debug message
248: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
249: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
250: 'jtf.plsql.jtf_terr_sales_pub.get_winningterrmembers.begin',
251: 'Start of the procedure jtf_terr_sales_pub.get_winningterrmembers');
252: END IF;
253:
254: -- Standard call to check for call compatibility.
255: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 304: 'jtf.plsql.jtf_terr_sales_pub.get_winningterrmembers.get_winners',

300:
301: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
302: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
303: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
304: 'jtf.plsql.jtf_terr_sales_pub.get_winningterrmembers.get_winners',
305: 'API JTY_ASSIGN_REALTIME_PUB.get_winners has failed');
306: END IF;
307: RAISE FND_API.G_EXC_ERROR;
308: END IF;

Line 314: 'jtf.plsql.jtf_terr_sales_pub.get_winningterrmembers.get_winners',

310:
311: -- debug message
312: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
313: FND_LOG.string(FND_LOG.LEVEL_EVENT,
314: 'jtf.plsql.jtf_terr_sales_pub.get_winningterrmembers.get_winners',
315: 'Finish calling procedure JTY_ASSIGN_REALTIME_PUB.get_winners');
316: END IF;
317:
318: /*

Line 367: 'jtf.plsql.jtf_terr_sales_pub.get_winningterrmembers.end',

363:
364: -- debug message
365: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
366: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
367: 'jtf.plsql.jtf_terr_sales_pub.get_winningterrmembers.end',
368: 'End of the procedure jtf_terr_sales_pub.get_winningterrmembers');
369: END IF;
370:
371: EXCEPTION

Line 368: 'End of the procedure jtf_terr_sales_pub.get_winningterrmembers');

364: -- debug message
365: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
366: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
367: 'jtf.plsql.jtf_terr_sales_pub.get_winningterrmembers.end',
368: 'End of the procedure jtf_terr_sales_pub.get_winningterrmembers');
369: END IF;
370:
371: EXCEPTION
372: WHEN FND_API.G_EXC_ERROR THEN

Line 375: 'jtf.plsql.jtf_terr_sales_pub.get_winningterrmembers.g_exc_error',

371: EXCEPTION
372: WHEN FND_API.G_EXC_ERROR THEN
373: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
374: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
375: 'jtf.plsql.jtf_terr_sales_pub.get_winningterrmembers.g_exc_error',
376: substr(x_msg_data, 1, 4000));
377: END IF;
378:
379: WHEN OTHERS THEN

Line 385: 'jtf.plsql.jtf_terr_sales_pub.get_winningterrmembers.other',

381: x_msg_data := SQLCODE || ' : ' || SQLERRM;
382: x_msg_count := 1;
383: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
384: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
385: 'jtf.plsql.jtf_terr_sales_pub.get_winningterrmembers.other',
386: substr(x_msg_data, 1, 4000));
387: END IF;
388:
389: End Get_WinningTerrMembers;

Line 483: JTF_TERR_SALES_PUB.Get_WinningTerrMembers(

479: p_rec.attribute14 := jtf_terr_char_360list(p_terraccount_rec.attribute14);
480: p_rec.attribute15 := jtf_terr_char_360list(p_terraccount_rec.attribute15);
481:
482:
483: JTF_TERR_SALES_PUB.Get_WinningTerrMembers(
484: P_Api_Version_Number => P_Api_Version_Number,
485: P_Init_Msg_List => p_init_msg_list,
486: p_TerrAccount_Rec => p_Rec,
487: p_resource_type => p_resource_type,

Line 590: JTF_TERR_SALES_PUB.Get_WinningTerritories( p_api_version_number => 1.0,

586: p_rec.attribute13 := jtf_terr_char_360list(p_terracct_rec.attribute13);
587: p_rec.attribute14 := jtf_terr_char_360list(p_terracct_rec.attribute14);
588: p_rec.attribute15 := jtf_terr_char_360list(p_terracct_rec.attribute15);
589:
590: JTF_TERR_SALES_PUB.Get_WinningTerritories( p_api_version_number => 1.0,
591: p_init_msg_list => p_init_msg_list,
592: x_return_status => x_return_status,
593: x_msg_count => x_msg_count,
594: X_msg_data => X_msg_data,

Line 906: JTF_TERR_SALES_PUB.Get_WinningTerrMembers(

902: p_rec.attribute14 := jtf_terr_char_360list(p_terroppor_rec.attribute14);
903: p_rec.attribute15 := jtf_terr_char_360list(p_terroppor_rec.attribute15);
904:
905:
906: JTF_TERR_SALES_PUB.Get_WinningTerrMembers(
907: P_Api_Version_Number => P_Api_Version_Number,
908: P_Init_Msg_List => p_init_msg_list,
909: p_TerrOppor_Rec => p_Rec,
910: p_resource_type => p_resource_type,

Line 1033: JTF_TERR_SALES_PUB.Get_WinningTerrMembers(

1029: p_rec.attribute13 := jtf_terr_char_360list(p_terrlead_rec.attribute13);
1030: p_rec.attribute14 := jtf_terr_char_360list(p_terrlead_rec.attribute14);
1031: p_rec.attribute15 := jtf_terr_char_360list(p_terrlead_rec.attribute15);
1032:
1033: JTF_TERR_SALES_PUB.Get_WinningTerrMembers(
1034: P_Api_Version_Number => P_Api_Version_Number,
1035: P_Init_Msg_List => p_init_msg_list,
1036: p_TerrLead_Rec => p_Rec,
1037: p_resource_type => p_resource_type,

Line 1064: END JTF_TERR_SALES_PUB;

1060: END LOOP;
1061:
1062: end Get_WinningTerrMembers;
1063:
1064: END JTF_TERR_SALES_PUB;