DBA Data[Home] [Help]

APPS.CS_KB_CONC_PROG_PKG dependencies on FND_LOG

Line 54: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

50: l_soln_comp_attach_index VARCHAR2(250) := 'CS_KB_SETS_ATTACH_TL_N3'; --12.1.3
51:
52: BEGIN
53: --12.1.3
54: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
55: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csk.plsql.cs_kb_conc_prog_pkg.populate_set_index',
56: ' attachment_flag:'||attachment_flag);
57: END IF;
58:

Line 55: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csk.plsql.cs_kb_conc_prog_pkg.populate_set_index',

51:
52: BEGIN
53: --12.1.3
54: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
55: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csk.plsql.cs_kb_conc_prog_pkg.populate_set_index',
56: ' attachment_flag:'||attachment_flag);
57: END IF;
58:
59:

Line 61: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

57: END IF;
58:
59:
60:
61: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
62: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csk.plsql.cs_kb_conc_prog_pkg.populate_set_index',
63: 'l_soln_comp_index:'||l_soln_comp_index);
64: END IF;
65: --12.1.3

Line 62: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csk.plsql.cs_kb_conc_prog_pkg.populate_set_index',

58:
59:
60:
61: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
62: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csk.plsql.cs_kb_conc_prog_pkg.populate_set_index',
63: 'l_soln_comp_index:'||l_soln_comp_index);
64: END IF;
65: --12.1.3
66: x_return_status := fnd_api.G_RET_STS_SUCCESS;

Line 450: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

446: --4321268
447: || ' storage ' ||g_apps_short_name||'.CS_KB_INDEX_STORAGE '; -- <-command not yet completed
448: -- 4321268_eof
449: -- Start 12.1.3
450: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
451: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csk.plsql.cs_kb_conc_prog_pkg.Create_Set_Index',
452: ' attachment_flag:'||attachment_flag);
453: END IF;
454:

Line 451: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csk.plsql.cs_kb_conc_prog_pkg.Create_Set_Index',

447: || ' storage ' ||g_apps_short_name||'.CS_KB_INDEX_STORAGE '; -- <-command not yet completed
448: -- 4321268_eof
449: -- Start 12.1.3
450: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
451: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csk.plsql.cs_kb_conc_prog_pkg.Create_Set_Index',
452: ' attachment_flag:'||attachment_flag);
453: END IF;
454:
455: /* l_create_cmmd :=

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

480: || ' storage ' ||g_apps_short_name||'.CS_KB_INDEX_STORAGE '; -- <-command not yet completed
481: -- 4321268_eof
482: END IF;
483:
484: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
485: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csk.plsql.cs_kb_conc_prog_pkg.Create_Set_Index',
486: 'l_index_name:'||l_index_name|| 'l_dummy_col:'||l_dummy_col|| 'l_datastore:'||l_datastore);
487: END IF;
488:

Line 485: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csk.plsql.cs_kb_conc_prog_pkg.Create_Set_Index',

481: -- 4321268_eof
482: END IF;
483:
484: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
485: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csk.plsql.cs_kb_conc_prog_pkg.Create_Set_Index',
486: 'l_index_name:'||l_index_name|| 'l_dummy_col:'||l_dummy_col|| 'l_datastore:'||l_datastore);
487: END IF;
488:
489: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 489: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

485: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csk.plsql.cs_kb_conc_prog_pkg.Create_Set_Index',
486: 'l_index_name:'||l_index_name|| 'l_dummy_col:'||l_dummy_col|| 'l_datastore:'||l_datastore);
487: END IF;
488:
489: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
490: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csk.plsql.cs_kb_conc_prog_pkg.Create_Set_Index',
491: ' l_create_cmmd:'|| l_create_cmmd);
492: END IF;
493:

Line 490: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csk.plsql.cs_kb_conc_prog_pkg.Create_Set_Index',

486: 'l_index_name:'||l_index_name|| 'l_dummy_col:'||l_dummy_col|| 'l_datastore:'||l_datastore);
487: END IF;
488:
489: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
490: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csk.plsql.cs_kb_conc_prog_pkg.Create_Set_Index',
491: ' l_create_cmmd:'|| l_create_cmmd);
492: END IF;
493:
494: -- End 12.1.3

Line 512: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

508: l_create_cmmd1 := l_create_cmmd1 || ''')';
509: l_create_cmmd1 := resolve_parallel_indexing(l_create_cmmd1, pworker);
510: --12.1.3
511: END IF;
512: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
513: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csk.plsql.cs_kb_conc_prog_pkg.Create_Set_Index',
514: ' l_create_cmmd before do_create:'|| l_create_cmmd);
515: END IF;
516:

Line 513: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csk.plsql.cs_kb_conc_prog_pkg.Create_Set_Index',

509: l_create_cmmd1 := resolve_parallel_indexing(l_create_cmmd1, pworker);
510: --12.1.3
511: END IF;
512: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
513: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csk.plsql.cs_kb_conc_prog_pkg.Create_Set_Index',
514: ' l_create_cmmd before do_create:'|| l_create_cmmd);
515: END IF;
516:
517: -- 4321268_eof

Line 527: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

523: x_msg_error => x_msg_error,
524: x_return_status => x_return_status );
525: --12.1.3
526: IF attachment_flag = 'Y' THEN
527: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
528: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csk.plsql.cs_kb_conc_prog_pkg.Create_Set_Index',
529: ' l_create_cmmd inside do_create:'|| l_create_cmmd1 ||l_index_name1);
530: END IF;
531:

Line 528: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csk.plsql.cs_kb_conc_prog_pkg.Create_Set_Index',

524: x_return_status => x_return_status );
525: --12.1.3
526: IF attachment_flag = 'Y' THEN
527: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
528: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csk.plsql.cs_kb_conc_prog_pkg.Create_Set_Index',
529: ' l_create_cmmd inside do_create:'|| l_create_cmmd1 ||l_index_name1);
530: END IF;
531:
532:

Line 862: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

858: l_mode VARCHAR2(10) := bmode;
859:
860: l_return_status VARCHAR2(1) := fnd_api.G_RET_STS_ERROR;
861: BEGIN
862: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
863: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csk.plsql.cs_kb_conc_prog_pkg.Sync_Set_Index',
864: 'Index attachments:'||attachment);
865: END IF;
866: --12.1.3

Line 863: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csk.plsql.cs_kb_conc_prog_pkg.Sync_Set_Index',

859:
860: l_return_status VARCHAR2(1) := fnd_api.G_RET_STS_ERROR;
861: BEGIN
862: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
863: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csk.plsql.cs_kb_conc_prog_pkg.Sync_Set_Index',
864: 'Index attachments:'||attachment);
865: END IF;
866: --12.1.3
867: --Commented to fix bug 8757484

Line 871: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

867: --Commented to fix bug 8757484
868: --IF attachment = 'Y' THEN
869: attachment_flag :='Y';
870: --END IF;
871: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
872: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csk.plsql.cs_kb_conc_prog_pkg.Sync_Set_Index',
873: 'l_soln_comp_index:'||l_soln_comp_index);
874: END IF;
875:

Line 872: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csk.plsql.cs_kb_conc_prog_pkg.Sync_Set_Index',

868: --IF attachment = 'Y' THEN
869: attachment_flag :='Y';
870: --END IF;
871: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
872: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csk.plsql.cs_kb_conc_prog_pkg.Sync_Set_Index',
873: 'l_soln_comp_index:'||l_soln_comp_index);
874: END IF;
875:
876: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 876: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

872: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csk.plsql.cs_kb_conc_prog_pkg.Sync_Set_Index',
873: 'l_soln_comp_index:'||l_soln_comp_index);
874: END IF;
875:
876: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
877: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csk.plsql.cs_kb_conc_prog_pkg.Sync_Set_Index',
878: 'l_soln_comp_attach_index:'||l_soln_comp_attach_index);
879: END IF;
880:

Line 877: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csk.plsql.cs_kb_conc_prog_pkg.Sync_Set_Index',

873: 'l_soln_comp_index:'||l_soln_comp_index);
874: END IF;
875:
876: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
877: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csk.plsql.cs_kb_conc_prog_pkg.Sync_Set_Index',
878: 'l_soln_comp_attach_index:'||l_soln_comp_attach_index);
879: END IF;
880:
881: --12.1.3