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 FND_LOG

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

103:
104: 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;

Line 108: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

104: 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:

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

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

Line 135: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

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

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

274: ,x_msg_count => x_msg_count
275: ,x_msg_data => x_msg_data);
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;

Line 279: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

275: ,x_msg_data => x_msg_data);
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;

Line 287: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

283: RAISE FND_API.G_EXC_ERROR;
284: END IF;
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;

Line 288: FND_LOG.string(FND_LOG.LEVEL_EVENT,

284: END IF;
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:

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

302: ,x_msg_data => x_msg_data
303: ,x_winners_rec => lx_winners_rec);
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;

Line 307: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

303: ,x_winners_rec => lx_winners_rec);
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;

Line 315: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

311: RAISE FND_API.G_EXC_ERROR;
312: END IF;
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;

Line 316: FND_LOG.string(FND_LOG.LEVEL_EVENT,

312: END IF;
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:

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

345:
346: END LOOP;
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;

Line 350: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

346: END LOOP;
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:

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

353: END IF;
354:
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;

Line 358: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

354:
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:

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

363: WHEN OTHERS THEN
364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
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;

Line 368: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
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: