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_TASK_PUB dependencies on JTF_TERR_TASK_PUB

Line 1: Package Body JTF_TERR_TASK_PUB AS

1: Package Body JTF_TERR_TASK_PUB AS
2: /* $Header: jtfpttsb.pls 120.3 2005/11/18 15:07:17 achanda ship $ */
3: -- ---------------------------------------------------
4: -- Start of Comments
5: -- ---------------------------------------------------

Line 6: -- PACKAGE NAME: JTF_TERR_TASK_PUB

2: /* $Header: jtfpttsb.pls 120.3 2005/11/18 15:07:17 achanda ship $ */
3: -- ---------------------------------------------------
4: -- Start of Comments
5: -- ---------------------------------------------------
6: -- PACKAGE NAME: JTF_TERR_TASK_PUB
7: -- ---------------------------------------------------
8: -- PURPOSE
9: -- Joint task force core Sales territory manager public api's.
10: -- This package is a public API for getting winning territories

Line 46: G_PKG_NAME CONSTANT VARCHAR2(30):='JTF_TERR_TASK_PUB';

42: --
43: -- ***************************************************
44: -- GLOBAL VARIABLES
45: -- ***************************************************
46: G_PKG_NAME CONSTANT VARCHAR2(30):='JTF_TERR_TASK_PUB';
47: G_FILE_NAME CONSTANT VARCHAR2(12):='jtfpttsb.pls';
48:
49: --
50: -- ***************************************************

Line 109: 'jtf.plsql.jtf_terr_task_pub.get_winningterrmembers.begin',

105:
106: -- debug message
107: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
108: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
109: 'jtf.plsql.jtf_terr_task_pub.get_winningterrmembers.begin',
110: 'Start of the procedure jtf_terr_task_pub.get_winningterrmembers');
111: END IF;
112:
113: -- Standard call to check for call compatibility.

Line 110: 'Start of the procedure jtf_terr_task_pub.get_winningterrmembers');

106: -- debug message
107: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
108: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
109: 'jtf.plsql.jtf_terr_task_pub.get_winningterrmembers.begin',
110: 'Start of the procedure jtf_terr_task_pub.get_winningterrmembers');
111: END IF;
112:
113: -- Standard call to check for call compatibility.
114: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 136: 'jtf.plsql.jtf_terr_task_pub.get_winningterrmembers.parameters',

132:
133: -- debug message
134: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
135: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
136: 'jtf.plsql.jtf_terr_task_pub.get_winningterrmembers.parameters',
137: 'Country : ' || p_TerrTask_rec.COUNTRY || ' City : ' || p_TerrTask_rec.CITY || ' Postal Code : ' ||
138: p_TerrTask_rec.POSTAL_CODE || ' State : ' || p_TerrTask_rec.STATE || ' Area Code : ' || p_TerrTask_rec.AREA_CODE ||
139: ' County : ' || p_TerrTask_rec.COUNTY || ' Company Name Range : ' || p_TerrTask_rec.COMP_NAME_RANGE ||
140: ' Province : ' || p_TerrTask_rec.PROVINCE || ' Number of Employees : ' || p_TerrTask_rec.NUM_OF_EMPLOYEES ||

Line 280: 'jtf.plsql.jtf_terr_task_pub.get_winningterrmembers.process_match',

276:
277: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
278: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
279: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
280: 'jtf.plsql.jtf_terr_task_pub.get_winningterrmembers.process_match',
281: 'API JTY_ASSIGN_REALTIME_PUB.process_match has failed');
282: END IF;
283: RAISE FND_API.G_EXC_ERROR;
284: END IF;

Line 289: 'jtf.plsql.jtf_terr_task_pub.get_winningterrmembers.process_match',

285:
286: -- debug message
287: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
288: FND_LOG.string(FND_LOG.LEVEL_EVENT,
289: 'jtf.plsql.jtf_terr_task_pub.get_winningterrmembers.process_match',
290: 'Finish calling procedure JTY_ASSIGN_REALTIME_PUB.process_match');
291: END IF;
292:
293: JTY_ASSIGN_REALTIME_PUB.process_winners (

Line 308: 'jtf.plsql.jtf_terr_task_pub.get_winningterrmembers.process_winners',

304:
305: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
306: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
307: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
308: 'jtf.plsql.jtf_terr_task_pub.get_winningterrmembers.process_winners',
309: 'API JTY_ASSIGN_REALTIME_PUB.process_winners has failed');
310: END IF;
311: RAISE FND_API.G_EXC_ERROR;
312: END IF;

Line 317: 'jtf.plsql.jtf_terr_task_pub.get_winningterrmembers.process_winners',

313:
314: -- debug message
315: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
316: FND_LOG.string(FND_LOG.LEVEL_EVENT,
317: 'jtf.plsql.jtf_terr_task_pub.get_winningterrmembers.process_winners',
318: 'Finish calling procedure JTY_ASSIGN_REALTIME_PUB.process_winners');
319: END IF;
320:
321: /*

Line 351: 'jtf.plsql.jtf_terr_task_pub.get_winningterrmembers.end',

347:
348: -- debug message
349: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
350: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
351: 'jtf.plsql.jtf_terr_task_pub.get_winningterrmembers.end',
352: 'End of the procedure jtf_terr_task_pub.get_winningterrmembers');
353: END IF;
354:
355: EXCEPTION

Line 352: 'End of the procedure jtf_terr_task_pub.get_winningterrmembers');

348: -- debug message
349: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
350: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
351: 'jtf.plsql.jtf_terr_task_pub.get_winningterrmembers.end',
352: 'End of the procedure jtf_terr_task_pub.get_winningterrmembers');
353: END IF;
354:
355: EXCEPTION
356: WHEN FND_API.G_EXC_ERROR THEN

Line 359: 'jtf.plsql.jtf_terr_task_pub.get_winningterrmembers.g_exc_error',

355: EXCEPTION
356: WHEN FND_API.G_EXC_ERROR THEN
357: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
358: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
359: 'jtf.plsql.jtf_terr_task_pub.get_winningterrmembers.g_exc_error',
360: substr(x_msg_data, 1, 4000));
361: END IF;
362:
363: WHEN OTHERS THEN

Line 369: 'jtf.plsql.jtf_terr_task_pub.get_winningterrmembers.other',

365: x_msg_data := SQLCODE || ' : ' || SQLERRM;
366: x_msg_count := 1;
367: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
368: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
369: 'jtf.plsql.jtf_terr_task_pub.get_winningterrmembers.other',
370: substr(x_msg_data, 1, 4000));
371: END IF;
372:
373: End Get_WinningTerrMembers;

Line 375: END JTF_TERR_TASK_PUB;

371: END IF;
372:
373: End Get_WinningTerrMembers;
374:
375: END JTF_TERR_TASK_PUB;