APPS.JTF_TERR_SALES_PUB dependencies on FND_LOG

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

108: BEGIN
109: null;
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;

Line 113: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

109: null;
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:

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

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

Line 123: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

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

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

177: null;
178:
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;

Line 182: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

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

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

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

Line 192: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

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

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

244: l_trans_rec JTY_ASSIGN_REALTIME_PUB.bulk_trans_id_type;
245:
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;

Line 249: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

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

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

298: x_winners_rec => lx_winners_rec
299: );
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;

Line 303: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

299: );
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;

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

308: END IF;
309: END LOOP;
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;

Line 313: FND_LOG.string(FND_LOG.LEVEL_EVENT,

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

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

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

Line 366: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 374: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

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

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

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

Line 384: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

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