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.JTY_ASSIGN_BULK_PUB dependencies on FND_LOG

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

89:
90: BEGIN
91:
92: -- debug message
93: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
94: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
95: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_nm_trans_data.begin',
96: 'Start of the procedure JTY_ASSIGN_BULK_PUB.insert_nm_trans_data');
97: END IF;

Line 94: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

90: BEGIN
91:
92: -- debug message
93: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
94: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
95: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_nm_trans_data.begin',
96: 'Start of the procedure JTY_ASSIGN_BULK_PUB.insert_nm_trans_data');
97: END IF;
98:

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

200: g_new_line || l_seeded_sql ||
201: g_new_line || ' ) ) ';
202:
203: -- debug message
204: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
205: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
206: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_nm_trans_data.final_sql',
207: substr('Insert satement : ' || l_final_sql, 1, 4000));
208: END IF;

Line 205: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

201: g_new_line || ' ) ) ';
202:
203: -- debug message
204: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
205: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
206: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_nm_trans_data.final_sql',
207: substr('Insert satement : ' || l_final_sql, 1, 4000));
208: END IF;
209:

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

214: commit;
215: EXECUTE IMMEDIATE 'alter session disable parallel dml';
216:
217: -- debug message
218: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
219: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
220: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_nm_trans_data.num_rows',
221: 'Number of rows inserted : ' || SQL%ROWCOUNT);
222: END IF;

Line 219: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

215: EXECUTE IMMEDIATE 'alter session disable parallel dml';
216:
217: -- debug message
218: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
219: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
220: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_nm_trans_data.num_rows',
221: 'Number of rows inserted : ' || SQL%ROWCOUNT);
222: END IF;
223:

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

221: 'Number of rows inserted : ' || SQL%ROWCOUNT);
222: END IF;
223:
224: -- debug message
225: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
226: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
227: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_nm_trans_data.end',
228: 'End of the procedure JTY_ASSIGN_BULK_PUB.insert_nm_trans_data');
229: END IF;

Line 226: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

222: END IF;
223:
224: -- debug message
225: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
226: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
227: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_nm_trans_data.end',
228: 'End of the procedure JTY_ASSIGN_BULK_PUB.insert_nm_trans_data');
229: END IF;
230:

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

233: x_return_status := FND_API.G_RET_STS_ERROR ;
234: RETCODE := 2;
235: x_msg_count := 1;
236: ERRBUF := x_msg_data;
237: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
238: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
239: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_nm_trans_data.l_seed_data_notfound',
240: x_msg_data);
241: END IF;

Line 238: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

234: RETCODE := 2;
235: x_msg_count := 1;
236: ERRBUF := x_msg_data;
237: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
238: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
239: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_nm_trans_data.l_seed_data_notfound',
240: x_msg_data);
241: END IF;
242:

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

244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
245: RETCODE := 2;
246: x_msg_data := 'JTY_ASSIGN_BULK_PUB.insert_nm_trans_data: SCHEMA NAME NOT FOUND CORRESPONDING TO JTF APPLICATION. ';
247: ERRBUF := x_msg_data;
248: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
249: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
250: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_nm_trans_data.l_schema_notfound',
251: x_msg_data);
252: END IF;

Line 249: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

245: RETCODE := 2;
246: x_msg_data := 'JTY_ASSIGN_BULK_PUB.insert_nm_trans_data: SCHEMA NAME NOT FOUND CORRESPONDING TO JTF APPLICATION. ';
247: ERRBUF := x_msg_data;
248: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
249: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
250: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_nm_trans_data.l_schema_notfound',
251: x_msg_data);
252: END IF;
253:

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

255: x_return_status := FND_API.G_RET_STS_ERROR ;
256: RETCODE := 2;
257: x_msg_count := 1;
258: ERRBUF := x_msg_data;
259: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
260: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
261: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_nm_trans_data.no_data_found',
262: x_msg_data);
263: END IF;

Line 260: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

256: RETCODE := 2;
257: x_msg_count := 1;
258: ERRBUF := x_msg_data;
259: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
260: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
261: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_nm_trans_data.no_data_found',
262: x_msg_data);
263: END IF;
264:

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

266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
267: x_msg_data := SQLCODE || ' : ' || SQLERRM;
268: x_msg_count := 1;
269: ERRBUF := x_msg_data;
270: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
271: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
272: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_nm_trans_data.other',
273: substr(x_msg_data, 1, 4000));
274: END IF;

Line 271: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

267: x_msg_data := SQLCODE || ' : ' || SQLERRM;
268: x_msg_count := 1;
269: ERRBUF := x_msg_data;
270: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
271: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
272: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_nm_trans_data.other',
273: substr(x_msg_data, 1, 4000));
274: END IF;
275:

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

329:
330: BEGIN
331:
332: -- debug message
333: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
334: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
335: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_trans_data.begin',
336: 'Start of the procedure JTY_ASSIGN_BULK_PUB.insert_trans_data');
337: END IF;

Line 334: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

330: BEGIN
331:
332: -- debug message
333: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
334: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
335: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_trans_data.begin',
336: 'Start of the procedure JTY_ASSIGN_BULK_PUB.insert_trans_data');
337: END IF;
338:

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

390: RAISE L_SEED_DATA_NOTFOUND;
391: END IF;
392:
393: -- debug message
394: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
395: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
396: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_trans_data.trans_table_name',
397: 'TRANS table name : ' || l_trans_target);
398: /*

Line 395: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

391: END IF;
392:
393: -- debug message
394: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
395: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
396: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_trans_data.trans_table_name',
397: 'TRANS table name : ' || l_trans_target);
398: /*
399: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

Line 399: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

395: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
396: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_trans_data.trans_table_name',
397: 'TRANS table name : ' || l_trans_target);
398: /*
399: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
400: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_trans_data.trans_table_name',
401: ' Seeded SQL : ' || substr(l_seeded_sql, 1, 4000));
402: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
403: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_trans_data.trans_table_name',

Line 402: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

398: /*
399: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
400: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_trans_data.trans_table_name',
401: ' Seeded SQL : ' || substr(l_seeded_sql, 1, 4000));
402: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
403: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_trans_data.trans_table_name',
404: ' Where clause : ' || substr(p_where, 1, 4000));
405: */
406: END IF;

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

480: END IF;
481: l_final_sql := l_final_sql || ' ) ';
482:
483: -- debug message
484: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
485: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
486: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_trans_data.final_sql',
487: substr('Insert satement : ' || l_final_sql, 1, 4000));
488: END IF;

Line 485: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

481: l_final_sql := l_final_sql || ' ) ';
482:
483: -- debug message
484: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
485: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
486: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_trans_data.final_sql',
487: substr('Insert satement : ' || l_final_sql, 1, 4000));
488: END IF;
489:

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

495: commit;
496: EXECUTE IMMEDIATE 'alter session disable parallel dml';
497:
498: -- debug message
499: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
500: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
501: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_trans_data.num_rows',
502: 'Number of rows inserted : ' || SQL%ROWCOUNT);
503: END IF;

Line 500: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

496: EXECUTE IMMEDIATE 'alter session disable parallel dml';
497:
498: -- debug message
499: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
500: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
501: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_trans_data.num_rows',
502: 'Number of rows inserted : ' || SQL%ROWCOUNT);
503: END IF;
504:

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

502: 'Number of rows inserted : ' || SQL%ROWCOUNT);
503: END IF;
504:
505: -- debug message
506: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
507: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
508: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_trans_data.end',
509: 'End of the procedure JTY_ASSIGN_BULK_PUB.insert_trans_data');
510: END IF;

Line 507: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

503: END IF;
504:
505: -- debug message
506: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
507: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
508: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_trans_data.end',
509: 'End of the procedure JTY_ASSIGN_BULK_PUB.insert_trans_data');
510: END IF;
511:

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

514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
515: RETCODE := 2;
516: x_msg_data := 'JTY_ASSIGN_BULK_PUB.insert_trans_data: Invalid number of workers : Valid range from 1 - 10';
517: ERRBUF := x_msg_data;
518: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
519: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
520: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_trans_data.l_invalid_workers',
521: x_msg_data);
522: END IF;

Line 519: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

515: RETCODE := 2;
516: x_msg_data := 'JTY_ASSIGN_BULK_PUB.insert_trans_data: Invalid number of workers : Valid range from 1 - 10';
517: ERRBUF := x_msg_data;
518: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
519: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
520: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_trans_data.l_invalid_workers',
521: x_msg_data);
522: END IF;
523:

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

525: x_return_status := FND_API.G_RET_STS_ERROR ;
526: RETCODE := 2;
527: x_msg_count := 1;
528: ERRBUF := x_msg_data;
529: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
530: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
531: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_trans_data.l_seed_data_notfound',
532: x_msg_data);
533: END IF;

Line 530: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

526: RETCODE := 2;
527: x_msg_count := 1;
528: ERRBUF := x_msg_data;
529: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
530: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
531: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_trans_data.l_seed_data_notfound',
532: x_msg_data);
533: END IF;
534:

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

536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
537: RETCODE := 2;
538: x_msg_data := 'JTY_ASSIGN_BULK_PUB.insert_trans_data: SCHEMA NAME NOT FOUND CORRESPONDING TO JTF APPLICATION. ';
539: ERRBUF := x_msg_data;
540: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
541: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
542: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_trans_data.l_schema_notfound',
543: x_msg_data);
544: END IF;

Line 541: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

537: RETCODE := 2;
538: x_msg_data := 'JTY_ASSIGN_BULK_PUB.insert_trans_data: SCHEMA NAME NOT FOUND CORRESPONDING TO JTF APPLICATION. ';
539: ERRBUF := x_msg_data;
540: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
541: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
542: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_trans_data.l_schema_notfound',
543: x_msg_data);
544: END IF;
545:

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

547: x_return_status := FND_API.G_RET_STS_ERROR ;
548: RETCODE := 2;
549: x_msg_count := 1;
550: ERRBUF := x_msg_data;
551: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
552: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
553: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_trans_data.no_data_found',
554: x_msg_data);
555: END IF;

Line 552: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

548: RETCODE := 2;
549: x_msg_count := 1;
550: ERRBUF := x_msg_data;
551: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
552: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
553: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_trans_data.no_data_found',
554: x_msg_data);
555: END IF;
556:

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

558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
559: x_msg_data := SQLCODE || ' : ' || SQLERRM;
560: x_msg_count := 1;
561: ERRBUF := x_msg_data;
562: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
563: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
564: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_trans_data.other',
565: substr(x_msg_data, 1, 4000));
566: END IF;

Line 563: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

559: x_msg_data := SQLCODE || ' : ' || SQLERRM;
560: x_msg_count := 1;
561: ERRBUF := x_msg_data;
562: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
563: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
564: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_trans_data.other',
565: substr(x_msg_data, 1, 4000));
566: END IF;
567:

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

605: l_dummy NUMBER;
606: BEGIN
607:
608: -- debug message
609: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
610: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
611: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.begin',
612: 'Start of the procedure JTY_ASSIGN_BULK_PUB.clear_trans_data');
613: END IF;

Line 610: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

606: BEGIN
607:
608: -- debug message
609: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
610: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
611: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.begin',
612: 'Start of the procedure JTY_ASSIGN_BULK_PUB.clear_trans_data');
613: END IF;
614:

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

645: AND tup.trans_type_id = p_trans_id
646: AND tup.program_name = p_program_name;
647:
648: -- debug message
649: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
650: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
651: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.temp_table_names',
652: 'TRANS table name : ' || l_trans_target || ' MATCH table name : ' || l_match_target ||
653: ' WINNER table name : ' || l_winner_target || ' L1 table name : ' || l_L1_target ||

Line 650: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

646: AND tup.program_name = p_program_name;
647:
648: -- debug message
649: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
650: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
651: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.temp_table_names',
652: 'TRANS table name : ' || l_trans_target || ' MATCH table name : ' || l_match_target ||
653: ' WINNER table name : ' || l_winner_target || ' L1 table name : ' || l_L1_target ||
654: ' L2 table name : ' || l_L2_target || ' L3 table name : ' || l_L3_target ||

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

659: /* Truncate and drop indexes on the TRANS table */
660: IF (l_trans_target IS NOT NULL) THEN
661:
662: -- debug message
663: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
664: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
665: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.trans_clear',
666: 'Deleting data and dropping indexes from ' || l_trans_target);
667: END IF;

Line 664: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

660: IF (l_trans_target IS NOT NULL) THEN
661:
662: -- debug message
663: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
664: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
665: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.trans_clear',
666: 'Deleting data and dropping indexes from ' || l_trans_target);
667: END IF;
668:

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

673:
674: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
675: -- debug message
676: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_trans_target;
677: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
678: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
679: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.trans_clear',
680: x_msg_data);
681: END IF;

Line 678: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

674: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
675: -- debug message
676: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_trans_target;
677: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
678: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
679: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.trans_clear',
680: x_msg_data);
681: END IF;
682:

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

690:
691: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
692: -- debug message
693: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_trans_target;
694: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
695: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
696: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.trans_clear',
697: x_msg_data);
698: END IF;

Line 695: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

691: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
692: -- debug message
693: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_trans_target;
694: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
695: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
696: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.trans_clear',
697: x_msg_data);
698: END IF;
699:

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

705: /* Truncate and drop indexes on the MATCH table */
706: IF (l_match_target IS NOT NULL) THEN
707:
708: -- debug message
709: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
710: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
711: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.match_clear',
712: 'Deleting data and dropping indexes from ' || l_match_target);
713: END IF;

Line 710: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

706: IF (l_match_target IS NOT NULL) THEN
707:
708: -- debug message
709: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
710: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
711: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.match_clear',
712: 'Deleting data and dropping indexes from ' || l_match_target);
713: END IF;
714:

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

720: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
721:
722: -- debug message
723: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_match_target;
724: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
725: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
726: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.match_clear',
727: x_msg_data);
728: END IF;

Line 725: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

721:
722: -- debug message
723: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_match_target;
724: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
725: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
726: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.match_clear',
727: x_msg_data);
728: END IF;
729:

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

737:
738: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
739: -- debug message
740: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_match_target;
741: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
742: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
743: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.match_clear',
744: x_msg_data);
745: END IF;

Line 742: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

738: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
739: -- debug message
740: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_match_target;
741: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
742: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
743: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.match_clear',
744: x_msg_data);
745: END IF;
746:

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

752: /* Truncate and drop indexes on the UMATCH table */
753: IF (l_umatch_target IS NOT NULL) THEN
754:
755: -- debug message
756: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
757: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
758: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.umatch_clear',
759: 'Deleting data and dropping indexes from ' || l_umatch_target);
760: END IF;

Line 757: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

753: IF (l_umatch_target IS NOT NULL) THEN
754:
755: -- debug message
756: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
757: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
758: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.umatch_clear',
759: 'Deleting data and dropping indexes from ' || l_umatch_target);
760: END IF;
761:

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

767: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
768:
769: -- debug message
770: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_umatch_target;
771: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
772: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
773: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.umatch_clear',
774: x_msg_data);
775: END IF;

Line 772: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

768:
769: -- debug message
770: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_umatch_target;
771: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
772: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
773: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.umatch_clear',
774: x_msg_data);
775: END IF;
776:

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

784:
785: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
786: -- debug message
787: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_umatch_target;
788: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
789: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
790: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.umatch_clear',
791: x_msg_data);
792: END IF;

Line 789: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

785: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
786: -- debug message
787: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_umatch_target;
788: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
789: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
790: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.umatch_clear',
791: x_msg_data);
792: END IF;
793:

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

799: /* Truncate and drop indexes on the WINNER table */
800: IF (l_winner_target IS NOT NULL) THEN
801:
802: -- debug message
803: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
804: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
805: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.winner_clear',
806: 'Deleting data and dropping indexes from ' || l_winner_target);
807: END IF;

Line 804: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

800: IF (l_winner_target IS NOT NULL) THEN
801:
802: -- debug message
803: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
804: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
805: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.winner_clear',
806: 'Deleting data and dropping indexes from ' || l_winner_target);
807: END IF;
808:

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

814: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
815:
816: -- debug message
817: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_winner_target;
818: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
819: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
820: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.winner_clear',
821: x_msg_data);
822: END IF;

Line 819: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

815:
816: -- debug message
817: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_winner_target;
818: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
819: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
820: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.winner_clear',
821: x_msg_data);
822: END IF;
823:

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

831:
832: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
833: -- debug message
834: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_winner_target;
835: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
836: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
837: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.winner_clear',
838: x_msg_data);
839: END IF;

Line 836: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

832: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
833: -- debug message
834: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_winner_target;
835: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
836: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
837: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.winner_clear',
838: x_msg_data);
839: END IF;
840:

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

846: /* Truncate and drop indexes on the UWINNER table */
847: IF (l_uwinner_target IS NOT NULL) THEN
848:
849: -- debug message
850: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
851: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
852: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.uwinner_clear',
853: 'Deleting data and dropping indexes from ' || l_uwinner_target);
854: END IF;

Line 851: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

847: IF (l_uwinner_target IS NOT NULL) THEN
848:
849: -- debug message
850: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
851: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
852: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.uwinner_clear',
853: 'Deleting data and dropping indexes from ' || l_uwinner_target);
854: END IF;
855:

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

861: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
862:
863: -- debug message
864: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_uwinner_target;
865: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
866: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
867: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.uwinner_clear',
868: x_msg_data);
869: END IF;

Line 866: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

862:
863: -- debug message
864: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_uwinner_target;
865: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
866: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
867: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.uwinner_clear',
868: x_msg_data);
869: END IF;
870:

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

878:
879: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
880: -- debug message
881: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_uwinner_target;
882: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
883: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
884: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.uwinner_clear',
885: x_msg_data);
886: END IF;

Line 883: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

879: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
880: -- debug message
881: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_uwinner_target;
882: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
883: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
884: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.uwinner_clear',
885: x_msg_data);
886: END IF;
887:

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

893: /* Truncate and drop indexes on the L1 table */
894: IF (l_l1_target IS NOT NULL) THEN
895:
896: -- debug message
897: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
898: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
899: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l1_clear',
900: 'Deleting data and dropping indexes from ' || l_l1_target);
901: END IF;

Line 898: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

894: IF (l_l1_target IS NOT NULL) THEN
895:
896: -- debug message
897: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
898: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
899: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l1_clear',
900: 'Deleting data and dropping indexes from ' || l_l1_target);
901: END IF;
902:

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

908: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
909:
910: -- debug message
911: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_l1_target;
912: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
913: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
914: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l1_clear',
915: x_msg_data);
916: END IF;

Line 913: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

909:
910: -- debug message
911: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_l1_target;
912: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
913: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
914: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l1_clear',
915: x_msg_data);
916: END IF;
917:

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

925:
926: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
927: -- debug message
928: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_l1_target;
929: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
930: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
931: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l1_clear',
932: x_msg_data);
933: END IF;

Line 930: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

926: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
927: -- debug message
928: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_l1_target;
929: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
930: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
931: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l1_clear',
932: x_msg_data);
933: END IF;
934:

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

940: /* Truncate and drop indexes on the L2 table */
941: IF (l_l2_target IS NOT NULL) THEN
942:
943: -- debug message
944: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
945: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
946: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l2_clear',
947: 'Deleting data and dropping indexes from ' || l_l2_target);
948: END IF;

Line 945: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

941: IF (l_l2_target IS NOT NULL) THEN
942:
943: -- debug message
944: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
945: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
946: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l2_clear',
947: 'Deleting data and dropping indexes from ' || l_l2_target);
948: END IF;
949:

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

955: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
956:
957: -- debug message
958: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_l2_target;
959: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
960: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
961: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l2_clear',
962: x_msg_data);
963: END IF;

Line 960: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

956:
957: -- debug message
958: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_l2_target;
959: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
960: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
961: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l2_clear',
962: x_msg_data);
963: END IF;
964:

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

972:
973: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
974: -- debug message
975: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_l2_target;
976: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
977: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
978: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l2_clear',
979: x_msg_data);
980: END IF;

Line 977: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

973: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
974: -- debug message
975: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_l2_target;
976: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
977: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
978: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l2_clear',
979: x_msg_data);
980: END IF;
981:

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

987: /* Truncate and drop indexes on the L3 table */
988: IF (l_l3_target IS NOT NULL) THEN
989:
990: -- debug message
991: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
992: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
993: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l3_clear',
994: 'Deleting data and dropping indexes from ' || l_l3_target);
995: END IF;

Line 992: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

988: IF (l_l3_target IS NOT NULL) THEN
989:
990: -- debug message
991: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
992: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
993: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l3_clear',
994: 'Deleting data and dropping indexes from ' || l_l3_target);
995: END IF;
996:

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

1002: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1003:
1004: -- debug message
1005: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_l3_target;
1006: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1007: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1008: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l3_clear',
1009: x_msg_data);
1010: END IF;

Line 1007: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

1003:
1004: -- debug message
1005: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_l3_target;
1006: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1007: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1008: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l3_clear',
1009: x_msg_data);
1010: END IF;
1011:

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

1019:
1020: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1021: -- debug message
1022: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_l3_target;
1023: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1024: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1025: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l3_clear',
1026: x_msg_data);
1027: END IF;

Line 1024: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

1020: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1021: -- debug message
1022: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_l3_target;
1023: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1024: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1025: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l3_clear',
1026: x_msg_data);
1027: END IF;
1028:

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

1034: /* Truncate and drop indexes on the L4 table */
1035: IF (l_l4_target IS NOT NULL) THEN
1036:
1037: -- debug message
1038: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1039: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1040: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l4_clear',
1041: 'Deleting data and dropping indexes from ' || l_l4_target);
1042: END IF;

Line 1039: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1035: IF (l_l4_target IS NOT NULL) THEN
1036:
1037: -- debug message
1038: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1039: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1040: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l4_clear',
1041: 'Deleting data and dropping indexes from ' || l_l4_target);
1042: END IF;
1043:

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

1049: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1050:
1051: -- debug message
1052: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_l4_target;
1053: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1054: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1055: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l4_clear',
1056: x_msg_data);
1057: END IF;

Line 1054: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

1050:
1051: -- debug message
1052: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_l4_target;
1053: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1054: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1055: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l4_clear',
1056: x_msg_data);
1057: END IF;
1058:

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

1066:
1067: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1068: -- debug message
1069: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_l4_target;
1070: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1071: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1072: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l4_clear',
1073: x_msg_data);
1074: END IF;

Line 1071: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

1067: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1068: -- debug message
1069: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_l4_target;
1070: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1071: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1072: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l4_clear',
1073: x_msg_data);
1074: END IF;
1075:

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

1081: /* Truncate and drop indexes on the L5 table */
1082: IF (l_l5_target IS NOT NULL) THEN
1083:
1084: -- debug message
1085: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1086: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1087: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l5_clear',
1088: 'Deleting data and dropping indexes from ' || l_l5_target);
1089: END IF;

Line 1086: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1082: IF (l_l5_target IS NOT NULL) THEN
1083:
1084: -- debug message
1085: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1086: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1087: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l5_clear',
1088: 'Deleting data and dropping indexes from ' || l_l5_target);
1089: END IF;
1090:

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

1096: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1097:
1098: -- debug message
1099: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_l5_target;
1100: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1101: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1102: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l5_clear',
1103: x_msg_data);
1104: END IF;

Line 1101: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

1097:
1098: -- debug message
1099: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_l5_target;
1100: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1101: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1102: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l5_clear',
1103: x_msg_data);
1104: END IF;
1105:

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

1113:
1114: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1115: -- debug message
1116: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_l5_target;
1117: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1118: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1119: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l5_clear',
1120: x_msg_data);
1121: END IF;

Line 1118: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

1114: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1115: -- debug message
1116: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_l5_target;
1117: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1118: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1119: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l5_clear',
1120: x_msg_data);
1121: END IF;
1122:

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

1128: /* Truncate and drop indexes on the WT table */
1129: IF (l_wt_target IS NOT NULL) THEN
1130:
1131: -- debug message
1132: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1133: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1134: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.wt_clear',
1135: 'Deleting data and dropping indexes from ' || l_wt_target);
1136: END IF;

Line 1133: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1129: IF (l_wt_target IS NOT NULL) THEN
1130:
1131: -- debug message
1132: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1133: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1134: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.wt_clear',
1135: 'Deleting data and dropping indexes from ' || l_wt_target);
1136: END IF;
1137:

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

1143: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1144:
1145: -- debug message
1146: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_wt_target;
1147: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1148: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1149: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.wt_clear',
1150: x_msg_data);
1151: END IF;

Line 1148: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

1144:
1145: -- debug message
1146: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_wt_target;
1147: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1148: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1149: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.wt_clear',
1150: x_msg_data);
1151: END IF;
1152:

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

1160:
1161: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1162: -- debug message
1163: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_wt_target;
1164: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1165: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1166: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.wt_clear',
1167: x_msg_data);
1168: END IF;

Line 1165: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

1161: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1162: -- debug message
1163: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_wt_target;
1164: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1165: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1166: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.wt_clear',
1167: x_msg_data);
1168: END IF;
1169:

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

1198: END;
1199: END IF;
1200:
1201: -- debug message
1202: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1203: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1204: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.end',
1205: 'End of the procedure JTY_ASSIGN_BULK_PUB.clear_trans_data');
1206: END IF;

Line 1203: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

1199: END IF;
1200:
1201: -- debug message
1202: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1203: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1204: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.end',
1205: 'End of the procedure JTY_ASSIGN_BULK_PUB.clear_trans_data');
1206: END IF;
1207:

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

1212: x_msg_count := 1;
1213: x_msg_data := 'No row in jty_trans_usg_pgm_details corresponding to usage : ' || p_source_id || ' transaction : ' || p_trans_id ||
1214: ' program name : ' || p_program_name;
1215: ERRBUF := x_msg_data;
1216: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1217: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1218: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.Clear_Trans_Data.no_data_found',
1219: x_msg_data);
1220: END IF;

Line 1217: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

1213: x_msg_data := 'No row in jty_trans_usg_pgm_details corresponding to usage : ' || p_source_id || ' transaction : ' || p_trans_id ||
1214: ' program name : ' || p_program_name;
1215: ERRBUF := x_msg_data;
1216: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1217: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1218: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.Clear_Trans_Data.no_data_found',
1219: x_msg_data);
1220: END IF;
1221:

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

1222: WHEN FND_API.G_EXC_ERROR THEN
1223: RETCODE := 2;
1224: x_msg_count := 1;
1225: ERRBUF := x_msg_data;
1226: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1227: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1228: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.Clear_Trans_Data.g_exc_error',
1229: x_msg_data);
1230: END IF;

Line 1227: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

1223: RETCODE := 2;
1224: x_msg_count := 1;
1225: ERRBUF := x_msg_data;
1226: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1227: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1228: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.Clear_Trans_Data.g_exc_error',
1229: x_msg_data);
1230: END IF;
1231:

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

1233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1234: x_msg_data := SQLCODE || ' : ' || SQLERRM;
1235: x_msg_count := 1;
1236: ERRBUF := x_msg_data;
1237: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1238: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1239: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.other',
1240: substr(x_msg_data, 1, 4000));
1241: END IF;

Line 1238: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

1234: x_msg_data := SQLCODE || ' : ' || SQLERRM;
1235: x_msg_count := 1;
1236: ERRBUF := x_msg_data;
1237: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1238: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1239: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.other',
1240: substr(x_msg_data, 1, 4000));
1241: END IF;
1242:

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

1287:
1288: BEGIN
1289:
1290: -- debug message
1291: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1292: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1293: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.begin',
1294: 'Start of the procedure JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup');
1295: END IF;

Line 1292: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

1288: BEGIN
1289:
1290: -- debug message
1291: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1292: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1293: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.begin',
1294: 'Start of the procedure JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup');
1295: END IF;
1296:

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

1331: AND tup.trans_type_id = p_trans_id
1332: AND tup.program_name = p_program_name;
1333:
1334: -- debug message
1335: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1336: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1337: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.temp_table_names',
1338: 'TRANS table name : ' || l_trans_target || ' MATCH table name : ' || l_match_target ||
1339: ' WINNER table name : ' || l_winner_target || ' L1 table name : ' || l_L1_target ||

Line 1336: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1332: AND tup.program_name = p_program_name;
1333:
1334: -- debug message
1335: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1336: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1337: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.temp_table_names',
1338: 'TRANS table name : ' || l_trans_target || ' MATCH table name : ' || l_match_target ||
1339: ' WINNER table name : ' || l_winner_target || ' L1 table name : ' || l_L1_target ||
1340: ' L2 table name : ' || l_L2_target || ' L3 table name : ' || l_L3_target ||

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

1391: START WITH jt.terr_id = jt1.terr_id)
1392: AND jqtu.qual_type_id <> -1001;
1393:
1394: -- debug message
1395: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1396: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1397: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.num_of_terr',
1398: 'Number of valid territories with resources for this transaction : ' || num_of_terr);
1399: END IF;

Line 1396: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1392: AND jqtu.qual_type_id <> -1001;
1393:
1394: -- debug message
1395: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1396: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1397: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.num_of_terr',
1398: 'Number of valid territories with resources for this transaction : ' || num_of_terr);
1399: END IF;
1400:

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

1410: d_statement := ' SELECT COUNT(*) FROM ' || l_trans_target || ' WHERE rownum < 2 ';
1411: EXECUTE IMMEDIATE d_statement INTO num_of_trans;
1412:
1413: -- debug message
1414: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1415: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1416: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.num_of_trans',
1417: 'Number of valid transaction objects : ' || num_of_trans);
1418: END IF;

Line 1415: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1411: EXECUTE IMMEDIATE d_statement INTO num_of_trans;
1412:
1413: -- debug message
1414: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1415: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1416: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.num_of_trans',
1417: 'Number of valid transaction objects : ' || num_of_trans);
1418: END IF;
1419:

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

1422: RAISE NO_TAE_DATA_FOUND;
1423: END IF;
1424:
1425: -- debug message
1426: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1427: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1428: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.analyze_trans',
1429: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_trans_target);
1430: END IF;

Line 1427: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1423: END IF;
1424:
1425: -- debug message
1426: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1427: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1428: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.analyze_trans',
1429: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_trans_target);
1430: END IF;
1431:

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

1440: RAISE FND_API.G_EXC_ERROR;
1441: END IF;
1442:
1443: -- debug message
1444: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1445: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1446: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.decompose_terr_defns',
1447: 'Call to JTY_TAE_CONTROL_PVT.Decompose_Terr_Defns API begins for : ' || l_trans_target);
1448: END IF;

Line 1445: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1441: END IF;
1442:
1443: -- debug message
1444: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1445: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1446: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.decompose_terr_defns',
1447: 'Call to JTY_TAE_CONTROL_PVT.Decompose_Terr_Defns API begins for : ' || l_trans_target);
1448: END IF;
1449:

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

1470: RAISE FND_API.G_EXC_ERROR;
1471: END IF;
1472:
1473: -- debug message
1474: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1475: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1476: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.analyze_matches',
1477: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_match_target);
1478: END IF;

Line 1475: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1471: END IF;
1472:
1473: -- debug message
1474: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1475: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1476: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.analyze_matches',
1477: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_match_target);
1478: END IF;
1479:

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

1492: RAISE FND_API.G_EXC_ERROR;
1493: END IF;
1494:
1495: -- debug message
1496: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1497: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1498: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.analyze_winners',
1499: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_winner_target);
1500: END IF;

Line 1497: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1493: END IF;
1494:
1495: -- debug message
1496: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1497: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1498: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.analyze_winners',
1499: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_winner_target);
1500: END IF;
1501:

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

1514: RAISE FND_API.G_EXC_ERROR;
1515: END IF;
1516:
1517: -- debug message
1518: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1519: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1520: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.analyze_l1',
1521: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_l1_target);
1522: END IF;

Line 1519: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1515: END IF;
1516:
1517: -- debug message
1518: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1519: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1520: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.analyze_l1',
1521: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_l1_target);
1522: END IF;
1523:

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

1536: RAISE FND_API.G_EXC_ERROR;
1537: END IF;
1538:
1539: -- debug message
1540: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1541: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1542: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.analyze_l2',
1543: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_l2_target);
1544: END IF;

Line 1541: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1537: END IF;
1538:
1539: -- debug message
1540: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1541: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1542: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.analyze_l2',
1543: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_l2_target);
1544: END IF;
1545:

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

1559: END IF;
1560:
1561:
1562: -- debug message
1563: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1564: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1565: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.analyze_l3',
1566: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_l3_target);
1567: END IF;

Line 1564: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1560:
1561:
1562: -- debug message
1563: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1564: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1565: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.analyze_l3',
1566: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_l3_target);
1567: END IF;
1568:

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

1581: RAISE FND_API.G_EXC_ERROR;
1582: END IF;
1583:
1584: -- debug message
1585: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1586: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1587: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.analyze_l4',
1588: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_l4_target);
1589: END IF;

Line 1586: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1582: END IF;
1583:
1584: -- debug message
1585: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1586: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1587: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.analyze_l4',
1588: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_l4_target);
1589: END IF;
1590:

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

1603: RAISE FND_API.G_EXC_ERROR;
1604: END IF;
1605:
1606: -- debug message
1607: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1608: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1609: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.analyze_l5',
1610: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_l5_target);
1611: END IF;

Line 1608: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1604: END IF;
1605:
1606: -- debug message
1607: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1608: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1609: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.analyze_l5',
1610: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_l5_target);
1611: END IF;
1612:

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

1625: RAISE FND_API.G_EXC_ERROR;
1626: END IF;
1627:
1628: -- debug message
1629: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1630: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1631: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.analyze_wt',
1632: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_wt_target);
1633: END IF;

Line 1630: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1626: END IF;
1627:
1628: -- debug message
1629: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1630: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1631: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.analyze_wt',
1632: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_wt_target);
1633: END IF;
1634:

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

1654: EXECUTE IMMEDIATE d_statement USING p_no_of_workers;
1655: END IF;
1656:
1657: -- debug message
1658: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1659: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1660: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.end',
1661: 'End of the procedure JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup');
1662: END IF;

Line 1659: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

1655: END IF;
1656:
1657: -- debug message
1658: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1659: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1660: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.end',
1661: 'End of the procedure JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup');
1662: END IF;
1663:

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

1666: x_return_status := FND_API.G_RET_STS_SUCCESS;
1667: x_msg_count := 1;
1668: RETCODE := 0;
1669: ERRBUF := null;
1670: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1671: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1672: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.no_tae_data_found',
1673: x_msg_data);
1674: END IF;

Line 1671: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

1667: x_msg_count := 1;
1668: RETCODE := 0;
1669: ERRBUF := null;
1670: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1671: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1672: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.no_tae_data_found',
1673: x_msg_data);
1674: END IF;
1675:

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

1677: x_return_status := FND_API.G_RET_STS_ERROR;
1678: x_msg_count := 1;
1679: RETCODE := 2;
1680: ERRBUF := x_msg_data;
1681: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1682: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1683: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.g_exc_error',
1684: x_msg_data);
1685: END IF;

Line 1682: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

1678: x_msg_count := 1;
1679: RETCODE := 2;
1680: ERRBUF := x_msg_data;
1681: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1682: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1683: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.g_exc_error',
1684: x_msg_data);
1685: END IF;
1686:

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

1688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1689: x_msg_count := 1;
1690: RETCODE := 2;
1691: ERRBUF := x_msg_data;
1692: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1693: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1694: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.g_exc_unexpected_error',
1695: x_msg_data);
1696: END IF;

Line 1693: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

1689: x_msg_count := 1;
1690: RETCODE := 2;
1691: ERRBUF := x_msg_data;
1692: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1693: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1694: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.g_exc_unexpected_error',
1695: x_msg_data);
1696: END IF;
1697:

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

1700: x_msg_data := SQLCODE || ' : ' || SQLERRM;
1701: x_msg_count := 1;
1702: RETCODE := 2;
1703: ERRBUF := x_msg_data;
1704: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1705: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1706: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.other',
1707: substr(x_msg_data, 1, 4000));
1708: END IF;

Line 1705: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

1701: x_msg_count := 1;
1702: RETCODE := 2;
1703: ERRBUF := x_msg_data;
1704: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1705: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1706: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.other',
1707: substr(x_msg_data, 1, 4000));
1708: END IF;
1709:

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

1731:
1732: BEGIN
1733:
1734: -- debug message
1735: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1736: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1737: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.Process_Level_Winners.start',
1738: 'Start of the procedure JTY_ASSIGN_BULK_PUB.Process_Level_Winners');
1739: END IF;

Line 1736: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

1732: BEGIN
1733:
1734: -- debug message
1735: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1736: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1737: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.Process_Level_Winners.start',
1738: 'Start of the procedure JTY_ASSIGN_BULK_PUB.Process_Level_Winners');
1739: END IF;
1740:

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

2016:
2017: END IF; /* end IF ( p_UPPER_LEVEL_FROM_ROOT = 1 AND p_LOWER_LEVEL_FROM_ROOT = 1) */
2018:
2019: -- debug message
2020: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2021: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2022: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.Process_Level_Winners.num_rows',
2023: 'Number of rows inserted into ' || p_terr_LEVEL_target_tbl || ' : ' || SQL%ROWCOUNT);
2024: END IF;

Line 2021: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

2017: END IF; /* end IF ( p_UPPER_LEVEL_FROM_ROOT = 1 AND p_LOWER_LEVEL_FROM_ROOT = 1) */
2018:
2019: -- debug message
2020: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2021: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2022: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.Process_Level_Winners.num_rows',
2023: 'Number of rows inserted into ' || p_terr_LEVEL_target_tbl || ' : ' || SQL%ROWCOUNT);
2024: END IF;
2025:

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

2023: 'Number of rows inserted into ' || p_terr_LEVEL_target_tbl || ' : ' || SQL%ROWCOUNT);
2024: END IF;
2025:
2026: -- debug message
2027: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2028: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
2029: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.Process_Level_Winners.end',
2030: 'End of the procedure JTY_ASSIGN_BULK_PUB.Process_Level_Winners');
2031: END IF;

Line 2028: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

2024: END IF;
2025:
2026: -- debug message
2027: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2028: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
2029: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.Process_Level_Winners.end',
2030: 'End of the procedure JTY_ASSIGN_BULK_PUB.Process_Level_Winners');
2031: END IF;
2032:

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

2033: EXCEPTION
2034:
2035: WHEN FND_API.G_EXC_ERROR THEN
2036: x_return_status := FND_API.G_RET_STS_ERROR;
2037: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2038: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2039: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.Process_Level_Winners.other',
2040: 'JTY_ASSIGN_BULK_PUB.Process_Level_Winners has failed with FND_API.G_EXC_ERROR exception for ' ||
2041: 'UPPER LEVEL : ' || p_UPPER_LEVEL_FROM_ROOT || ' LOWER LEVEL : ' || p_LOWER_LEVEL_FROM_ROOT);

Line 2038: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

2034:
2035: WHEN FND_API.G_EXC_ERROR THEN
2036: x_return_status := FND_API.G_RET_STS_ERROR;
2037: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2038: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2039: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.Process_Level_Winners.other',
2040: 'JTY_ASSIGN_BULK_PUB.Process_Level_Winners has failed with FND_API.G_EXC_ERROR exception for ' ||
2041: 'UPPER LEVEL : ' || p_UPPER_LEVEL_FROM_ROOT || ' LOWER LEVEL : ' || p_LOWER_LEVEL_FROM_ROOT);
2042: END IF;

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

2042: END IF;
2043:
2044: WHEN OTHERS THEN
2045: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2046: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2047: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2048: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.Process_Level_Winners.other',
2049: substr(SQLCODE || ' : ' || SQLERRM, 1, 4000));
2050: END IF;

Line 2047: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

2043:
2044: WHEN OTHERS THEN
2045: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2046: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2047: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2048: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.Process_Level_Winners.other',
2049: substr(SQLCODE || ' : ' || SQLERRM, 1, 4000));
2050: END IF;
2051:

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

2072:
2073: BEGIN
2074:
2075: -- debug message
2076: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2077: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
2078: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.Process_Final_Level_Winners.start',
2079: 'Start of the procedure JTY_ASSIGN_BULK_PUB.Process_Final_Level_Winners');
2080: END IF;

Line 2077: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

2073: BEGIN
2074:
2075: -- debug message
2076: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2077: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
2078: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.Process_Final_Level_Winners.start',
2079: 'Start of the procedure JTY_ASSIGN_BULK_PUB.Process_Final_Level_Winners');
2080: END IF;
2081:

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

2167: NULL;
2168: END;
2169:
2170: -- debug message
2171: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2172: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2173: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.Process_Final_Level_Winners.num_rows',
2174: 'Number of rows inserted into ' || p_terr_LEVEL_target_tbl || ' : ' || SQL%ROWCOUNT);
2175: END IF;

Line 2172: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

2168: END;
2169:
2170: -- debug message
2171: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2172: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2173: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.Process_Final_Level_Winners.num_rows',
2174: 'Number of rows inserted into ' || p_terr_LEVEL_target_tbl || ' : ' || SQL%ROWCOUNT);
2175: END IF;
2176:

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

2174: 'Number of rows inserted into ' || p_terr_LEVEL_target_tbl || ' : ' || SQL%ROWCOUNT);
2175: END IF;
2176:
2177: -- debug message
2178: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2179: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
2180: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.Process_Final_Level_Winners.end',
2181: 'End of the procedure JTY_ASSIGN_BULK_PUB.Process_Final_Level_Winners');
2182: END IF;

Line 2179: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

2175: END IF;
2176:
2177: -- debug message
2178: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2179: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
2180: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.Process_Final_Level_Winners.end',
2181: 'End of the procedure JTY_ASSIGN_BULK_PUB.Process_Final_Level_Winners');
2182: END IF;
2183:

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

2183:
2184: EXCEPTION
2185: WHEN OTHERS THEN
2186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2187: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2188: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2189: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.Process_Final_Level_Winners.other',
2190: substr(SQLCODE || ' : ' || SQLERRM, 1, 4000));
2191: END IF;

Line 2188: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

2184: EXCEPTION
2185: WHEN OTHERS THEN
2186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2187: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2188: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2189: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.Process_Final_Level_Winners.other',
2190: substr(SQLCODE || ' : ' || SQLERRM, 1, 4000));
2191: END IF;
2192:

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

2248: L_SCHEMA_NOTFOUND EXCEPTION;
2249: BEGIN
2250:
2251: -- debug message
2252: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2253: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
2254: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_nmc_match.start',
2255: 'Start of the procedure JTY_ASSIGN_BULK_PUB.process_nmc_match');
2256: END IF;

Line 2253: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

2249: BEGIN
2250:
2251: -- debug message
2252: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2253: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
2254: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_nmc_match.start',
2255: 'Start of the procedure JTY_ASSIGN_BULK_PUB.process_nmc_match');
2256: END IF;
2257:

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

2347: l_final_sql := l_insert_stmt || g_new_line ||
2348: l_select_stmt || g_new_line || 'FROM ' || l_nm_trans_target || g_new_line || ' ) ';
2349:
2350: -- debug message
2351: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2352: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2353: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_nmc_match.final_sql',
2354: substr('Insert satement : ' || l_final_sql, 1, 4000));
2355: END IF;

Line 2352: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

2348: l_select_stmt || g_new_line || 'FROM ' || l_nm_trans_target || g_new_line || ' ) ';
2349:
2350: -- debug message
2351: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2352: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2353: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_nmc_match.final_sql',
2354: substr('Insert satement : ' || l_final_sql, 1, 4000));
2355: END IF;
2356:

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

2376: EXECUTE IMMEDIATE l_match_sql USING l_sysdate, g_user_id, l_sysdate, g_user_id, g_user_id, g_request_id,
2377: g_appl_id, g_program_id, l_sysdate, p_request_id, l_sysdate;
2378:
2379: -- debug message
2380: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2381: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2382: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_nmc_match.match',
2383: 'Number of records inserted for qualifier combination ' || jtf_csr.relation_product || ' : ' || SQL%ROWCOUNT);
2384: END IF;

Line 2381: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

2377: g_appl_id, g_program_id, l_sysdate, p_request_id, l_sysdate;
2378:
2379: -- debug message
2380: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2381: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2382: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_nmc_match.match',
2383: 'Number of records inserted for qualifier combination ' || jtf_csr.relation_product || ' : ' || SQL%ROWCOUNT);
2384: END IF;
2385: END LOOP;

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

2384: END IF;
2385: END LOOP;
2386:
2387: -- debug message
2388: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2389: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
2390: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_nmc_match.end',
2391: 'End of the procedure JTY_ASSIGN_BULK_PUB.process_nmc_match');
2392: END IF;

Line 2389: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

2385: END LOOP;
2386:
2387: -- debug message
2388: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2389: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
2390: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_nmc_match.end',
2391: 'End of the procedure JTY_ASSIGN_BULK_PUB.process_nmc_match');
2392: END IF;
2393:

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

2397: x_msg_data := 'Schema name corresponding to JTF application not found';
2398: RETCODE := 2;
2399: x_msg_count := 1;
2400: ERRBUF := x_msg_data;
2401: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2402: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2403: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_nmc_match.l_schema_notfound',
2404: 'Schema name corresponding to the JTF application not found');
2405: END IF;

Line 2402: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

2398: RETCODE := 2;
2399: x_msg_count := 1;
2400: ERRBUF := x_msg_data;
2401: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2402: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2403: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_nmc_match.l_schema_notfound',
2404: 'Schema name corresponding to the JTF application not found');
2405: END IF;
2406:

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

2408: x_return_status := FND_API.G_RET_STS_ERROR ;
2409: RETCODE := 2;
2410: x_msg_count := 1;
2411: ERRBUF := x_msg_data;
2412: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2413: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2414: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_nmc_match.no_data_found',
2415: x_msg_data);
2416: END IF;

Line 2413: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

2409: RETCODE := 2;
2410: x_msg_count := 1;
2411: ERRBUF := x_msg_data;
2412: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2413: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2414: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_nmc_match.no_data_found',
2415: x_msg_data);
2416: END IF;
2417:

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

2420: x_msg_data := SQLCODE || ' : ' || SQLERRM;
2421: x_msg_count := 1;
2422: RETCODE := 2;
2423: ERRBUF := x_msg_data;
2424: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2425: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2426: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_nmc_match.other',
2427: substr(x_msg_data, 1, 4000));
2428: END IF;

Line 2425: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

2421: x_msg_count := 1;
2422: RETCODE := 2;
2423: ERRBUF := x_msg_data;
2424: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2425: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2426: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_nmc_match.other',
2427: substr(x_msg_data, 1, 4000));
2428: END IF;
2429:

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

2463:
2464: BEGIN
2465:
2466: -- debug message
2467: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2468: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
2469: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.start',
2470: 'Start of the procedure JTY_ASSIGN_BULK_PUB.collect_trans_data');
2471: END IF;

Line 2468: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

2464: BEGIN
2465:
2466: -- debug message
2467: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2468: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
2469: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.start',
2470: 'Start of the procedure JTY_ASSIGN_BULK_PUB.collect_trans_data');
2471: END IF;
2472:

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

2487:
2488: x_return_status := FND_API.G_RET_STS_SUCCESS;
2489:
2490: -- debug message
2491: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2492: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2493: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.param_value',
2494: 'Source : ' || p_source_id || ' Trans : ' || p_trans_id || ' Program Name : ' || p_program_name ||
2495: ' Mode : ' || p_mode || ' Where clause : ' || p_where || ' Number of workers : ' || p_no_of_workers ||

Line 2492: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

2488: x_return_status := FND_API.G_RET_STS_SUCCESS;
2489:
2490: -- debug message
2491: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2492: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2493: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.param_value',
2494: 'Source : ' || p_source_id || ' Trans : ' || p_trans_id || ' Program Name : ' || p_program_name ||
2495: ' Mode : ' || p_mode || ' Where clause : ' || p_where || ' Number of workers : ' || p_no_of_workers ||
2496: ' Percent Analyzed : ' || p_percent_analyzed);

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

2511:
2512: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2513: -- debug message
2514: x_msg_data := 'API JTY_ASSIGN_BULK_PUB.clear_trans_data has failed';
2515: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2516: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2517: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.clear_trans_data',
2518: x_msg_data);
2519: END IF;

Line 2516: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

2512: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2513: -- debug message
2514: x_msg_data := 'API JTY_ASSIGN_BULK_PUB.clear_trans_data has failed';
2515: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2516: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2517: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.clear_trans_data',
2518: x_msg_data);
2519: END IF;
2520:

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

2521: RAISE FND_API.G_EXC_ERROR;
2522: END IF;
2523:
2524: -- debug message
2525: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2526: FND_LOG.string(FND_LOG.LEVEL_EVENT,
2527: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.end_clear_trans_data',
2528: 'API clear_trans_data completed successfully');
2529: END IF;

Line 2526: FND_LOG.string(FND_LOG.LEVEL_EVENT,

2522: END IF;
2523:
2524: -- debug message
2525: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2526: FND_LOG.string(FND_LOG.LEVEL_EVENT,
2527: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.end_clear_trans_data',
2528: 'API clear_trans_data completed successfully');
2529: END IF;
2530:

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

2545:
2546: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2547: -- debug message
2548: x_msg_data := 'API JTY_ASSIGN_BULK_PUB.insert_trans_data has failed';
2549: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2550: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2551: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.insert_trans_data',
2552: x_msg_data);
2553: END IF;

Line 2550: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

2546: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2547: -- debug message
2548: x_msg_data := 'API JTY_ASSIGN_BULK_PUB.insert_trans_data has failed';
2549: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2550: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2551: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.insert_trans_data',
2552: x_msg_data);
2553: END IF;
2554:

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

2555: RAISE FND_API.G_EXC_ERROR;
2556: END IF;
2557:
2558: -- debug message
2559: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2560: FND_LOG.string(FND_LOG.LEVEL_EVENT,
2561: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.end_insert_trans_data',
2562: 'API insert_trans_data completed successfully');
2563: END IF;

Line 2560: FND_LOG.string(FND_LOG.LEVEL_EVENT,

2556: END IF;
2557:
2558: -- debug message
2559: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2560: FND_LOG.string(FND_LOG.LEVEL_EVENT,
2561: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.end_insert_trans_data',
2562: 'API insert_trans_data completed successfully');
2563: END IF;
2564:

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

2579:
2580: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2581: -- debug message
2582: x_msg_data := 'API JTY_ASSIGN_BULK_PUB.process_nmc_match has failed';
2583: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2584: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2585: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.process_nmc_match',
2586: x_msg_data);
2587: END IF;

Line 2584: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

2580: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2581: -- debug message
2582: x_msg_data := 'API JTY_ASSIGN_BULK_PUB.process_nmc_match has failed';
2583: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2584: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2585: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.process_nmc_match',
2586: x_msg_data);
2587: END IF;
2588:

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

2589: RAISE FND_API.G_EXC_ERROR;
2590: END IF;
2591:
2592: -- debug message
2593: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2594: FND_LOG.string(FND_LOG.LEVEL_EVENT,
2595: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.end_process_nmc_match',
2596: 'API process_nmc_match completed successfully');
2597: END IF;

Line 2594: FND_LOG.string(FND_LOG.LEVEL_EVENT,

2590: END IF;
2591:
2592: -- debug message
2593: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2594: FND_LOG.string(FND_LOG.LEVEL_EVENT,
2595: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.end_process_nmc_match',
2596: 'API process_nmc_match completed successfully');
2597: END IF;
2598:

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

2610:
2611: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2612: -- debug message
2613: x_msg_data := 'API JTY_ASSIGN_BULK_PUB.insert_nm_trans_data has failed';
2614: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2615: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2616: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.insert_nm_trans_data',
2617: x_msg_data);
2618: END IF;

Line 2615: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

2611: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2612: -- debug message
2613: x_msg_data := 'API JTY_ASSIGN_BULK_PUB.insert_nm_trans_data has failed';
2614: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2615: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2616: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.insert_nm_trans_data',
2617: x_msg_data);
2618: END IF;
2619:

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

2620: RAISE FND_API.G_EXC_ERROR;
2621: END IF;
2622:
2623: -- debug message
2624: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2625: FND_LOG.string(FND_LOG.LEVEL_EVENT,
2626: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.end_insert_nm_trans_data',
2627: 'API insert_nm_trans_data completed successfully');
2628: END IF;

Line 2625: FND_LOG.string(FND_LOG.LEVEL_EVENT,

2621: END IF;
2622:
2623: -- debug message
2624: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2625: FND_LOG.string(FND_LOG.LEVEL_EVENT,
2626: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.end_insert_nm_trans_data',
2627: 'API insert_nm_trans_data completed successfully');
2628: END IF;
2629:

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

2646:
2647: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2648: -- debug message
2649: x_msg_data := 'API JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup has failed';
2650: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2651: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2652: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.get_winners_parallel_setup',
2653: x_msg_data);
2654: END IF;

Line 2651: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

2647: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2648: -- debug message
2649: x_msg_data := 'API JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup has failed';
2650: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2651: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2652: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.get_winners_parallel_setup',
2653: x_msg_data);
2654: END IF;
2655:

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

2659: retcode := 0;
2660: errbuf := null;
2661:
2662: -- debug message
2663: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2664: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
2665: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.end',
2666: 'End of the procedure JTY_ASSIGN_BULK_PUB.collect_trans_data');
2667: END IF;

Line 2664: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

2660: errbuf := null;
2661:
2662: -- debug message
2663: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2664: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
2665: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.end',
2666: 'End of the procedure JTY_ASSIGN_BULK_PUB.collect_trans_data');
2667: END IF;
2668:

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

2671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2672: x_msg_count := 1;
2673: RETCODE := 2;
2674: ERRBUF := x_msg_data;
2675: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2676: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2677: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.g_exc_unexpected_error',
2678: x_msg_data);
2679: END IF;

Line 2676: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

2672: x_msg_count := 1;
2673: RETCODE := 2;
2674: ERRBUF := x_msg_data;
2675: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2676: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2677: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.g_exc_unexpected_error',
2678: x_msg_data);
2679: END IF;
2680:

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

2682: x_return_status := FND_API.G_RET_STS_ERROR ;
2683: RETCODE := 2;
2684: x_msg_count := 1;
2685: ERRBUF := x_msg_data;
2686: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2687: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2688: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.no_data_found',
2689: x_msg_data);
2690: END IF;

Line 2687: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

2683: RETCODE := 2;
2684: x_msg_count := 1;
2685: ERRBUF := x_msg_data;
2686: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2687: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2688: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.no_data_found',
2689: x_msg_data);
2690: END IF;
2691:

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

2692: WHEN FND_API.G_EXC_ERROR THEN
2693: RETCODE := 2;
2694: x_msg_count := 1;
2695: ERRBUF := x_msg_data;
2696: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2697: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2698: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.g_exc_error',
2699: x_msg_data);
2700: END IF;

Line 2697: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

2693: RETCODE := 2;
2694: x_msg_count := 1;
2695: ERRBUF := x_msg_data;
2696: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2697: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2698: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.g_exc_error',
2699: x_msg_data);
2700: END IF;
2701:

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

2704: x_msg_data := SQLCODE || ' : ' || SQLERRM;
2705: x_msg_count := 1;
2706: RETCODE := 2;
2707: ERRBUF := x_msg_data;
2708: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2709: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2710: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.other',
2711: substr(x_msg_data, 1, 4000));
2712: END IF;

Line 2709: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

2705: x_msg_count := 1;
2706: RETCODE := 2;
2707: ERRBUF := x_msg_data;
2708: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2709: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2710: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.other',
2711: substr(x_msg_data, 1, 4000));
2712: END IF;
2713:

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

2766: L_NO_MATCH_TERR EXCEPTION;
2767: BEGIN
2768:
2769: -- debug message
2770: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2771: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
2772: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winner.start',
2773: 'Start of the procedure JTY_ASSIGN_BULK_PUB.process_winner');
2774: END IF;

Line 2771: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

2767: BEGIN
2768:
2769: -- debug message
2770: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2771: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
2772: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winner.start',
2773: 'Start of the procedure JTY_ASSIGN_BULK_PUB.process_winner');
2774: END IF;
2775:

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

2946: , p_trans_id;
2947:
2948: COMMIT; -- after modifying table in parallel
2949:
2950: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2951: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2952: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.winner_num_row',
2953: 'Number of records inserted into ' || l_winner_target || ' for worker_id : ' || p_worker_id || ' : ' || SQL%ROWCOUNT);
2954: END IF;

Line 2951: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

2947:
2948: COMMIT; -- after modifying table in parallel
2949:
2950: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2951: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2952: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.winner_num_row',
2953: 'Number of records inserted into ' || l_winner_target || ' for worker_id : ' || p_worker_id || ' : ' || SQL%ROWCOUNT);
2954: END IF;
2955: EXCEPTION

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

2957: NULL;
2958: END;
2959:
2960: ELSE
2961: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2962: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2963: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.winning_process',
2964: 'Star of winning process');
2965: END IF;

Line 2962: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

2958: END;
2959:
2960: ELSE
2961: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2962: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2963: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.winning_process',
2964: 'Star of winning process');
2965: END IF;
2966:

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

2980: 'GROUP BY trans_object_id, trans_detail_object_id';
2981:
2982: EXECUTE IMMEDIATE l_dyn_str INTO l_max_terr USING p_worker_id;
2983:
2984: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2985: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2986: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.l_max_terr',
2987: 'Number of maximum territories for a matching combination for the worker_id : ' || p_worker_id || ' : ' || l_max_terr);
2988: END IF;

Line 2985: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

2981:
2982: EXECUTE IMMEDIATE l_dyn_str INTO l_max_terr USING p_worker_id;
2983:
2984: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2985: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2986: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.l_max_terr',
2987: 'Number of maximum territories for a matching combination for the worker_id : ' || p_worker_id || ' : ' || l_max_terr);
2988: END IF;
2989:

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

3005: when others then
3006: null;
3007: END;
3008:
3009: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3010: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3011: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.l_mp_winner_target',
3012: 'Table ' || l_mp_winner_target || ' successfully dropped');
3013: END IF;

Line 3010: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

3006: null;
3007: END;
3008:
3009: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3010: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3011: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.l_mp_winner_target',
3012: 'Table ' || l_mp_winner_target || ' successfully dropped');
3013: END IF;
3014:

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

3031: ' from ' || l_match_target ||
3032: ' where worker_id = ' || p_worker_id || ' ) ' ||
3033: ' group by trans_object_id, trans_detail_object_id, txn_date )';
3034:
3035: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3036: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3037: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.l_mp_winner_target',
3038: substr(l_dyn_str, 1, 4000));
3039: END IF;

Line 3036: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

3032: ' where worker_id = ' || p_worker_id || ' ) ' ||
3033: ' group by trans_object_id, trans_detail_object_id, txn_date )';
3034:
3035: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3036: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3037: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.l_mp_winner_target',
3038: substr(l_dyn_str, 1, 4000));
3039: END IF;
3040:

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

3040:
3041: /* create the table in jtf schema */
3042: ad_ddl.do_ddl(l_fnd_schema, 'JTF', ad_ddl.create_table, l_dyn_str, l_mp_winner_target);
3043:
3044: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3045: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3046: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.l_mp_winner_target',
3047: 'Table ' || l_mp_winner_target || ' successfully created');
3048: END IF;

Line 3045: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

3041: /* create the table in jtf schema */
3042: ad_ddl.do_ddl(l_fnd_schema, 'JTF', ad_ddl.create_table, l_dyn_str, l_mp_winner_target);
3043:
3044: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3045: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3046: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.l_mp_winner_target',
3047: 'Table ' || l_mp_winner_target || ' successfully created');
3048: END IF;
3049:

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

3056: when others then
3057: null;
3058: END;
3059:
3060: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3061: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3062: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.l_dmc_winner_target',
3063: 'Table ' || l_dmc_winner_target || ' successfully dropped');
3064: END IF;

Line 3061: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

3057: null;
3058: END;
3059:
3060: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3061: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3062: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.l_dmc_winner_target',
3063: 'Table ' || l_dmc_winner_target || ' successfully dropped');
3064: END IF;
3065:

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

3077: ' ,terr_id' || i;
3078: end loop;
3079: l_dyn_str := l_dyn_str || ' )';
3080:
3081: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3082: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3083: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.l_dmc_winner_target',
3084: substr(l_dyn_str, 1, 4000));
3085: END IF;

Line 3082: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

3078: end loop;
3079: l_dyn_str := l_dyn_str || ' )';
3080:
3081: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3082: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3083: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.l_dmc_winner_target',
3084: substr(l_dyn_str, 1, 4000));
3085: END IF;
3086:

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

3086:
3087: /* Create the table in JTF schema */
3088: ad_ddl.do_ddl(l_fnd_schema, 'JTF', ad_ddl.create_table, l_dyn_str, l_dmc_winner_target);
3089:
3090: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3091: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3092: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.l_dmc_winner_target',
3093: 'Table ' || l_dmc_winner_target || ' successfully created');
3094: END IF;

Line 3091: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

3087: /* Create the table in JTF schema */
3088: ad_ddl.do_ddl(l_fnd_schema, 'JTF', ad_ddl.create_table, l_dyn_str, l_dmc_winner_target);
3089:
3090: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3091: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3092: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.l_dmc_winner_target',
3093: 'Table ' || l_dmc_winner_target || ' successfully created');
3094: END IF;
3095:

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

3167: end if;
3168: end loop;
3169: l_dyn_str := l_dyn_str || ' )';
3170: */
3171: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3172: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3173: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.l_umatch',
3174: substr(l_dyn_str, 1, 4000));
3175: END IF;

Line 3172: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

3168: end loop;
3169: l_dyn_str := l_dyn_str || ' )';
3170: */
3171: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3172: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3173: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.l_umatch',
3174: substr(l_dyn_str, 1, 4000));
3175: END IF;
3176:

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

3175: END IF;
3176:
3177: execute immediate l_dyn_str;
3178:
3179: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3180: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3181: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.l_umatch',
3182: 'Data successfully inserted in umatch table');
3183: END IF;

Line 3180: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

3176:
3177: execute immediate l_dyn_str;
3178:
3179: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3180: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3181: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.l_umatch',
3182: 'Data successfully inserted in umatch table');
3183: END IF;
3184:

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

3195: ' , terr_id' || i;
3196: end loop;
3197: l_dyn_str := l_dyn_str || ' )';
3198:
3199: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3200: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3201: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.l_dmc_winner_target_index',
3202: substr(l_dyn_str, 1, 4000));
3203: END IF;

Line 3200: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

3196: end loop;
3197: l_dyn_str := l_dyn_str || ' )';
3198:
3199: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3200: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3201: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.l_dmc_winner_target_index',
3202: substr(l_dyn_str, 1, 4000));
3203: END IF;
3204:

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

3217: ' and a.terr_id' || i || ' = b.terr_id' || i || ' ';
3218: end loop;
3219: l_dyn_str := l_dyn_str || ' )';
3220:
3221: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3222: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3223: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.l_mp_winner_update',
3224: substr(l_dyn_str, 1, 4000));
3225: END IF;

Line 3222: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

3218: end loop;
3219: l_dyn_str := l_dyn_str || ' )';
3220:
3221: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3222: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3223: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.l_mp_winner_update',
3224: substr(l_dyn_str, 1, 4000));
3225: END IF;
3226:

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

3225: END IF;
3226:
3227: execute immediate l_dyn_str;
3228:
3229: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3230: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3231: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.l_mp_winner_update',
3232: 'Link successfully updated in ' || l_dmc_winner_target || ' table');
3233: END IF;

Line 3230: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

3226:
3227: execute immediate l_dyn_str;
3228:
3229: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3230: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3231: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.l_mp_winner_update',
3232: 'Link successfully updated in ' || l_dmc_winner_target || ' table');
3233: END IF;
3234:

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

3246: p_worker_id => p_worker_id
3247: );
3248:
3249: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3250: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3251: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3252: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l1',
3253: x_msg_data);
3254: END IF;

Line 3251: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

3247: );
3248:
3249: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3250: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3251: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3252: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l1',
3253: x_msg_data);
3254: END IF;
3255: RAISE FND_API.G_EXC_ERROR;

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

3264: , x_return_status => x_return_status );
3265:
3266: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3267: x_msg_data := 'API JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX has failed for ' || l_L1_target;
3268: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3269: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3270: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l1_analyze',
3271: x_msg_data);
3272: END IF;

Line 3269: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

3265:
3266: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3267: x_msg_data := 'API JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX has failed for ' || l_L1_target;
3268: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3269: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3270: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l1_analyze',
3271: x_msg_data);
3272: END IF;
3273: RAISE FND_API.G_EXC_ERROR;

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

3288: p_worker_id => p_worker_id
3289: );
3290:
3291: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3292: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3293: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3294: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l2',
3295: x_msg_data);
3296: END IF;

Line 3293: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

3289: );
3290:
3291: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3292: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3293: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3294: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l2',
3295: x_msg_data);
3296: END IF;
3297: RAISE FND_API.G_EXC_ERROR;

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

3306: , x_return_status => x_return_status );
3307:
3308: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3309: x_msg_data := 'API JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX has failed for ' || l_L2_target;
3310: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3311: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3312: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l2_analyze',
3313: x_msg_data);
3314: END IF;

Line 3311: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

3307:
3308: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3309: x_msg_data := 'API JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX has failed for ' || l_L2_target;
3310: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3311: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3312: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l2_analyze',
3313: x_msg_data);
3314: END IF;
3315: RAISE FND_API.G_EXC_ERROR;

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

3330: p_worker_id => p_worker_id
3331: );
3332:
3333: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3334: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3335: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3336: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l3',
3337: x_msg_data);
3338: END IF;

Line 3335: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

3331: );
3332:
3333: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3334: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3335: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3336: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l3',
3337: x_msg_data);
3338: END IF;
3339: RAISE FND_API.G_EXC_ERROR;

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

3348: , x_return_status => x_return_status );
3349:
3350: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3351: x_msg_data := 'API JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX has failed for ' || l_L3_target;
3352: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3353: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3354: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l3_analyze',
3355: x_msg_data);
3356: END IF;

Line 3353: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

3349:
3350: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3351: x_msg_data := 'API JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX has failed for ' || l_L3_target;
3352: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3353: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3354: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l3_analyze',
3355: x_msg_data);
3356: END IF;
3357: RAISE FND_API.G_EXC_ERROR;

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

3372: p_worker_id => p_worker_id
3373: );
3374:
3375: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3376: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3377: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3378: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l4',
3379: x_msg_data);
3380: END IF;

Line 3377: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

3373: );
3374:
3375: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3376: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3377: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3378: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l4',
3379: x_msg_data);
3380: END IF;
3381: RAISE FND_API.G_EXC_ERROR;

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

3390: , x_return_status => x_return_status );
3391:
3392: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3393: x_msg_data := 'API JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX has failed for ' || l_L4_target;
3394: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3395: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3396: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l4_analyze',
3397: x_msg_data);
3398: END IF;

Line 3395: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

3391:
3392: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3393: x_msg_data := 'API JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX has failed for ' || l_L4_target;
3394: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3395: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3396: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l4_analyze',
3397: x_msg_data);
3398: END IF;
3399: RAISE FND_API.G_EXC_ERROR;

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

3414: p_worker_id => p_worker_id
3415: );
3416:
3417: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3418: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3419: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3420: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l5',
3421: x_msg_data);
3422: END IF;

Line 3419: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

3415: );
3416:
3417: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3418: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3419: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3420: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l5',
3421: x_msg_data);
3422: END IF;
3423: RAISE FND_API.G_EXC_ERROR;

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

3432: , x_return_status => x_return_status );
3433:
3434: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3435: x_msg_data := 'API JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX has failed for ' || l_L5_target;
3436: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3437: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3438: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l5_analyze',
3439: x_msg_data);
3440: END IF;

Line 3437: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

3433:
3434: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3435: x_msg_data := 'API JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX has failed for ' || l_L5_target;
3436: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3437: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3438: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l5_analyze',
3439: x_msg_data);
3440: END IF;
3441: RAISE FND_API.G_EXC_ERROR;

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

3454: p_worker_id => p_worker_id
3455: );
3456:
3457: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3458: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3459: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3460: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.wt',
3461: x_msg_data);
3462: END IF;

Line 3459: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

3455: );
3456:
3457: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3458: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3459: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3460: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.wt',
3461: x_msg_data);
3462: END IF;
3463: RAISE FND_API.G_EXC_ERROR;

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

3472: , x_return_status => x_return_status );
3473:
3474: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3475: x_msg_data := 'API JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX has failed for ' || l_wt_target;
3476: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3477: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3478: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.wt_analyze',
3479: x_msg_data);
3480: END IF;

Line 3477: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

3473:
3474: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3475: x_msg_data := 'API JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX has failed for ' || l_wt_target;
3476: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3477: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3478: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.wt_analyze',
3479: x_msg_data);
3480: END IF;
3481: RAISE FND_API.G_EXC_ERROR;

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

3481: RAISE FND_API.G_EXC_ERROR;
3482: END IF;
3483: */
3484:
3485: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3486: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3487: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.begin_populate_winners',
3488: 'Start of populating the winner table');
3489: END IF;

Line 3486: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

3482: END IF;
3483: */
3484:
3485: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3486: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3487: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.begin_populate_winners',
3488: 'Start of populating the winner table');
3489: END IF;
3490:

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

3648: , p_worker_id /* :bv_worker_id */
3649: , p_worker_id /* :bv_worker_id */ --10
3650: , p_worker_id; /* :bv_worker_id */
3651:
3652: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3653: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3654: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.winner_num_row',
3655: 'Number of records inserted into ' || l_winner_target || ' for worker_id : ' || p_worker_id || ' : ' || SQL%ROWCOUNT);
3656: END IF;

Line 3653: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

3649: , p_worker_id /* :bv_worker_id */ --10
3650: , p_worker_id; /* :bv_worker_id */
3651:
3652: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3653: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3654: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.winner_num_row',
3655: 'Number of records inserted into ' || l_winner_target || ' for worker_id : ' || p_worker_id || ' : ' || SQL%ROWCOUNT);
3656: END IF;
3657:

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

3767: , lp_sysdate /* :BV1_PROGRAM_UPDATE_DATE */
3768: , p_worker_id /* :bv_worker_id */ --1
3769: , p_trans_id;
3770:
3771: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3772: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3773: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.winner_num_row',
3774: 'Number of records inserted into ' || l_winner_target || ' for worker_id : ' || p_worker_id || ' : ' || SQL%ROWCOUNT);
3775: END IF;

Line 3772: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

3768: , p_worker_id /* :bv_worker_id */ --1
3769: , p_trans_id;
3770:
3771: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3772: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3773: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.winner_num_row',
3774: 'Number of records inserted into ' || l_winner_target || ' for worker_id : ' || p_worker_id || ' : ' || SQL%ROWCOUNT);
3775: END IF;
3776:

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

3789: , x_return_status => x_return_status );
3790:
3791: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3792: x_msg_data := 'API JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX has failed for ' || l_winner_target;
3793: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3794: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3795: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.winner_analyze',
3796: x_msg_data);
3797: END IF;

Line 3794: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

3790:
3791: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3792: x_msg_data := 'API JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX has failed for ' || l_winner_target;
3793: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3794: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3795: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.winner_analyze',
3796: x_msg_data);
3797: END IF;
3798: RAISE FND_API.G_EXC_ERROR;

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

3803: x_return_status := FND_API.G_RET_STS_SUCCESS;
3804: RETCODE := 0;
3805:
3806: -- debug message
3807: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3808: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
3809: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winner.end',
3810: 'End of the procedure JTY_ASSIGN_BULK_PUB.process_winner');
3811: END IF;

Line 3808: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

3804: RETCODE := 0;
3805:
3806: -- debug message
3807: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3808: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
3809: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winner.end',
3810: 'End of the procedure JTY_ASSIGN_BULK_PUB.process_winner');
3811: END IF;
3812:

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

3816: x_msg_data := 'Schema name corresponding to the FND application not found';
3817: RETCODE := 2;
3818: x_msg_count := 1;
3819: ERRBUF := x_msg_data;
3820: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3821: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3822: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winner.l_schema_notfound',
3823: x_msg_data);
3824: END IF;

Line 3821: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

3817: RETCODE := 2;
3818: x_msg_count := 1;
3819: ERRBUF := x_msg_data;
3820: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3821: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3822: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winner.l_schema_notfound',
3823: x_msg_data);
3824: END IF;
3825:

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

3827: x_return_status := FND_API.G_RET_STS_ERROR ;
3828: RETCODE := 2;
3829: x_msg_count := 1;
3830: ERRBUF := x_msg_data;
3831: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3832: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3833: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winner.no_data_found',
3834: x_msg_data);
3835: END IF;

Line 3832: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

3828: RETCODE := 2;
3829: x_msg_count := 1;
3830: ERRBUF := x_msg_data;
3831: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3832: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3833: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winner.no_data_found',
3834: x_msg_data);
3835: END IF;
3836:

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

3834: x_msg_data);
3835: END IF;
3836:
3837: WHEN L_NO_MATCH_TERR THEN
3838: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3839: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3840: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winner.l_no_match_terr',
3841: x_msg_data);
3842: END IF;

Line 3839: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

3835: END IF;
3836:
3837: WHEN L_NO_MATCH_TERR THEN
3838: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3839: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3840: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winner.l_no_match_terr',
3841: x_msg_data);
3842: END IF;
3843:

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

3845: x_return_status := FND_API.G_RET_STS_ERROR ;
3846: RETCODE := 2;
3847: x_msg_count := 1;
3848: ERRBUF := x_msg_data;
3849: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3850: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3851: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winner.g_exc_error',
3852: x_msg_data);
3853: END IF;

Line 3850: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

3846: RETCODE := 2;
3847: x_msg_count := 1;
3848: ERRBUF := x_msg_data;
3849: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3850: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3851: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winner.g_exc_error',
3852: x_msg_data);
3853: END IF;
3854:

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

3857: x_msg_data := SQLCODE || ' : ' || SQLERRM;
3858: x_msg_count := 1;
3859: RETCODE := 2;
3860: ERRBUF := x_msg_data;
3861: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3862: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3863: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winner.other',
3864: substr(x_msg_data, 1, 4000));
3865: END IF;

Line 3862: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

3858: x_msg_count := 1;
3859: RETCODE := 2;
3860: ERRBUF := x_msg_data;
3861: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3862: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3863: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winner.other',
3864: substr(x_msg_data, 1, 4000));
3865: END IF;
3866:

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

3914:
3915: BEGIN
3916:
3917: -- debug message
3918: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3919: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
3920: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_match.start',
3921: 'Start of the procedure JTY_ASSIGN_BULK_PUB.process_match');
3922: END IF;

Line 3919: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

3915: BEGIN
3916:
3917: -- debug message
3918: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3919: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
3920: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_match.start',
3921: 'Start of the procedure JTY_ASSIGN_BULK_PUB.process_match');
3922: END IF;
3923:

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

3975: EXECUTE IMMEDIATE l_match_sql USING l_sysdate, g_user_id, l_sysdate, g_user_id, g_user_id, g_request_id,
3976: g_appl_id, g_program_id, l_sysdate, p_worker_id;
3977:
3978: -- debug message
3979: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3980: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3981: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_match.dea_match',
3982: 'Number of records inserted for qualifier combination ' || jtf_csr.attr_relation_product || ' : ' || SQL%ROWCOUNT);
3983: END IF;

Line 3980: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

3976: g_appl_id, g_program_id, l_sysdate, p_worker_id;
3977:
3978: -- debug message
3979: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3980: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
3981: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_match.dea_match',
3982: 'Number of records inserted for qualifier combination ' || jtf_csr.attr_relation_product || ' : ' || SQL%ROWCOUNT);
3983: END IF;
3984: END LOOP;

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

4003:
4004: EXECUTE IMMEDIATE l_match_sql USING l_sysdate, g_user_id, l_sysdate, g_user_id, g_user_id, g_request_id,
4005: g_appl_id, g_program_id, l_sysdate, p_worker_id;
4006: -- debug message
4007: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4008: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
4009: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_match.match',
4010: 'Number of records inserted for qualifier combination ' || jtf_csr.relation_product || ' : ' || SQL%ROWCOUNT);
4011: END IF;

Line 4008: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

4004: EXECUTE IMMEDIATE l_match_sql USING l_sysdate, g_user_id, l_sysdate, g_user_id, g_user_id, g_request_id,
4005: g_appl_id, g_program_id, l_sysdate, p_worker_id;
4006: -- debug message
4007: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4008: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
4009: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_match.match',
4010: 'Number of records inserted for qualifier combination ' || jtf_csr.relation_product || ' : ' || SQL%ROWCOUNT);
4011: END IF;
4012: END LOOP;

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

4018: , p_percent => p_percent_analyzed
4019: , x_return_status => x_return_status );
4020:
4021: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4022: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4023: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
4024: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_match.analyze_match',
4025: 'JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API has failed for table : ' || l_match_target);
4026: END IF;

Line 4023: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

4019: , x_return_status => x_return_status );
4020:
4021: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4022: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4023: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
4024: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_match.analyze_match',
4025: 'JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API has failed for table : ' || l_match_target);
4026: END IF;
4027:

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

4032: errbuf := x_msg_data;
4033: END IF;
4034:
4035: -- debug message
4036: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4037: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
4038: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_match.end',
4039: 'End of the procedure JTY_ASSIGN_BULK_PUB.process_match');
4040: END IF;

Line 4037: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

4033: END IF;
4034:
4035: -- debug message
4036: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4037: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
4038: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_match.end',
4039: 'End of the procedure JTY_ASSIGN_BULK_PUB.process_match');
4040: END IF;
4041:

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

4044: x_return_status := FND_API.G_RET_STS_ERROR ;
4045: RETCODE := 2;
4046: x_msg_count := 1;
4047: ERRBUF := x_msg_data;
4048: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4049: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
4050: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_match.no_data_found',
4051: x_msg_data);
4052: END IF;

Line 4049: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

4045: RETCODE := 2;
4046: x_msg_count := 1;
4047: ERRBUF := x_msg_data;
4048: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4049: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
4050: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_match.no_data_found',
4051: x_msg_data);
4052: END IF;
4053:

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

4051: x_msg_data);
4052: END IF;
4053:
4054: WHEN FND_API.G_EXC_ERROR THEN
4055: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4056: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
4057: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_match.g_exc_error',
4058: x_msg_data);
4059: END IF;

Line 4056: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

4052: END IF;
4053:
4054: WHEN FND_API.G_EXC_ERROR THEN
4055: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4056: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
4057: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_match.g_exc_error',
4058: x_msg_data);
4059: END IF;
4060:

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

4063: x_msg_data := SQLCODE || ' : ' || SQLERRM;
4064: x_msg_count := 1;
4065: RETCODE := 2;
4066: ERRBUF := x_msg_data;
4067: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4068: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
4069: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_match.other',
4070: substr(x_msg_data, 1, 4000));
4071: END IF;

Line 4068: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

4064: x_msg_count := 1;
4065: RETCODE := 2;
4066: ERRBUF := x_msg_data;
4067: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4068: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
4069: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_match.other',
4070: substr(x_msg_data, 1, 4000));
4071: END IF;
4072:

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

4103:
4104: BEGIN
4105:
4106: -- debug message
4107: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4108: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
4109: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.start',
4110: 'Start of the procedure JTY_ASSIGN_BULK_PUB.get_winners');
4111: END IF;

Line 4108: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

4104: BEGIN
4105:
4106: -- debug message
4107: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4108: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
4109: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.start',
4110: 'Start of the procedure JTY_ASSIGN_BULK_PUB.get_winners');
4111: END IF;
4112:

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

4126:
4127: x_return_status := FND_API.G_RET_STS_SUCCESS;
4128:
4129: -- debug message
4130: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4131: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
4132: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.param_value',
4133: 'Source : ' || p_source_id || ' Trans : ' || p_trans_id || ' Program Name : ' || p_program_name ||
4134: ' Mode : ' || p_mode || ' Worker : ' || p_worker_id);

Line 4131: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

4127: x_return_status := FND_API.G_RET_STS_SUCCESS;
4128:
4129: -- debug message
4130: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4131: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
4132: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.param_value',
4133: 'Source : ' || p_source_id || ' Trans : ' || p_trans_id || ' Program Name : ' || p_program_name ||
4134: ' Mode : ' || p_mode || ' Worker : ' || p_worker_id);
4135: END IF;

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

4149: retcode => retcode);
4150:
4151: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4152: -- debug message
4153: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4154: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
4155: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.match',
4156: 'process_match API has failed for source : ' || p_source_id || ' trans : ' || p_trans_id ||
4157: ' program name : ' || p_program_name);

Line 4154: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

4150:
4151: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4152: -- debug message
4153: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4154: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
4155: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.match',
4156: 'process_match API has failed for source : ' || p_source_id || ' trans : ' || p_trans_id ||
4157: ' program name : ' || p_program_name);
4158: END IF;

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

4160: RAISE FND_API.G_EXC_ERROR;
4161: END IF;
4162:
4163: -- debug message
4164: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4165: FND_LOG.string(FND_LOG.LEVEL_EVENT,
4166: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.end_match',
4167: 'Matching process completed successfully');
4168: END IF;

Line 4165: FND_LOG.string(FND_LOG.LEVEL_EVENT,

4161: END IF;
4162:
4163: -- debug message
4164: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4165: FND_LOG.string(FND_LOG.LEVEL_EVENT,
4166: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.end_match',
4167: 'Matching process completed successfully');
4168: END IF;
4169:

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

4182: retcode => retcode);
4183:
4184: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4185: -- debug message
4186: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4187: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
4188: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.winner',
4189: 'process_winners API has failed for source : ' || p_source_id || ' trans : ' || p_trans_id ||
4190: ' program name : ' || p_program_name);

Line 4187: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

4183:
4184: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4185: -- debug message
4186: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4187: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
4188: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.winner',
4189: 'process_winners API has failed for source : ' || p_source_id || ' trans : ' || p_trans_id ||
4190: ' program name : ' || p_program_name);
4191: END IF;

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

4193: RAISE FND_API.G_EXC_ERROR;
4194: END IF;
4195:
4196: -- debug message
4197: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4198: FND_LOG.string(FND_LOG.LEVEL_EVENT,
4199: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.end_winner',
4200: 'Winner process completed successfully');
4201: END IF;

Line 4198: FND_LOG.string(FND_LOG.LEVEL_EVENT,

4194: END IF;
4195:
4196: -- debug message
4197: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4198: FND_LOG.string(FND_LOG.LEVEL_EVENT,
4199: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.end_winner',
4200: 'Winner process completed successfully');
4201: END IF;
4202:

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

4200: 'Winner process completed successfully');
4201: END IF;
4202:
4203: -- debug message
4204: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4205: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
4206: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.end',
4207: 'End of the procedure JTY_ASSIGN_BULK_PUB.get_winners');
4208: END IF;

Line 4205: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

4201: END IF;
4202:
4203: -- debug message
4204: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4205: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
4206: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.end',
4207: 'End of the procedure JTY_ASSIGN_BULK_PUB.get_winners');
4208: END IF;
4209:

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

4211: WHEN FND_API.G_EXC_ERROR THEN
4212: x_return_status := FND_API.G_RET_STS_ERROR ;
4213: RETCODE := 2;
4214: x_msg_count := 1;
4215: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4216: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
4217: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.g_exc_error',
4218: x_msg_data);
4219: END IF;

Line 4216: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

4212: x_return_status := FND_API.G_RET_STS_ERROR ;
4213: RETCODE := 2;
4214: x_msg_count := 1;
4215: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4216: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
4217: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.g_exc_error',
4218: x_msg_data);
4219: END IF;
4220:

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

4223: x_msg_data := SQLCODE || ' : ' || SQLERRM;
4224: x_msg_count := 1;
4225: RETCODE := 2;
4226: ERRBUF := x_msg_data;
4227: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4228: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
4229: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.other',
4230: substr(x_msg_data, 1, 4000));
4231: END IF;

Line 4228: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

4224: x_msg_count := 1;
4225: RETCODE := 2;
4226: ERRBUF := x_msg_data;
4227: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4228: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
4229: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.other',
4230: substr(x_msg_data, 1, 4000));
4231: END IF;
4232: