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.CS_KB_CONC_PROG_PKG dependencies on FND_API

Line 66: x_return_status := fnd_api.G_RET_STS_SUCCESS;

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;
67:
68: -- Fetch out the list of IDs for all published solutions
69: OPEN all_published_solutions;
70: LOOP

Line 96: IF x_return_status != fnd_api.G_RET_STS_SUCCESS THEN

92: p_conc_request_name => 'CS_KB_SYNC_SOLUTIONS_INDEX',
93: x_msg_error => x_msg_error,
94: x_return_status => x_return_status );
95:
96: IF x_return_status != fnd_api.G_RET_STS_SUCCESS THEN
97: EXIT;
98: END IF;
99:
100: x_return_status := fnd_api.G_RET_STS_SUCCESS;

Line 100: x_return_status := fnd_api.G_RET_STS_SUCCESS;

96: IF x_return_status != fnd_api.G_RET_STS_SUCCESS THEN
97: EXIT;
98: END IF;
99:
100: x_return_status := fnd_api.G_RET_STS_SUCCESS;
101: */
102:
103: -- Check if all_published_solutions is notfound.
104: -- NOTE: this check should come at the end because for the last batch

Line 124: x_return_status := fnd_api.G_RET_STS_ERROR;

120: WHEN OTHERS THEN
121: ROLLBACK; -- do not use savepoint because savepoint is cleared when commit.
122: x_msg_error := 'populate_set_index: '
123: ||fnd_message.GET_STRING('CS','CS_KB_C_UNEXP_ERR')||' '||SQLERRM;
124: x_return_status := fnd_api.G_RET_STS_ERROR;
125: END populate_set_index;
126:
127: /*
128: * Populate element text index.

Line 138: x_return_status := fnd_api.G_RET_STS_SUCCESS;

134: )
135: IS
136: l_statement_comp_index VARCHAR2(250) := 'CS_KB_ELEMENTS_TL_N2';
137: BEGIN
138: x_return_status := fnd_api.G_RET_STS_SUCCESS;
139:
140: SAVEPOINT populate_element_index_SAV;
141:
142: -- We do not use bulk update in this case because the concurrent request

Line 161: x_return_status := fnd_api.G_RET_STS_ERROR;

157: WHEN OTHERS THEN
158: ROLLBACK TO populate_element_index_SAV;
159: x_msg_error := 'populate_element_index: '
160: ||fnd_message.GET_STRING('CS','CS_KB_C_UNEXP_ERR')||' '||SQLERRM;
161: x_return_status := fnd_api.G_RET_STS_ERROR;
162: END populate_element_index;
163:
164:
165: /*

Line 177: x_return_status := fnd_api.G_RET_STS_SUCCESS;

173: IS
174: index1 VARCHAR2(250) := 'CS_KB_SOLN_CAT_TL_N1';
175:
176: BEGIN
177: x_return_status := fnd_api.G_RET_STS_SUCCESS;
178: SAVEPOINT populate_soln_cat_index_SAV;
179: UPDATE /*+ parallel(t) */ cs_kb_soln_categories_tl t
180: SET t.name = t.name;
181:

Line 195: x_return_status := fnd_api.G_RET_STS_ERROR;

191: WHEN OTHERS THEN
192: ROLLBACK TO populate_soln_cat_index_SAV;
193: x_msg_error := 'populate_sol_cat_index: '
194: ||fnd_message.GET_STRING('CS','CS_KB_C_UNEXP_ERR')||' '||SQLERRM;
195: x_return_status := fnd_api.G_RET_STS_ERROR;
196: END populate_soln_cat_index;
197:
198:
199: /*

Line 210: x_return_status := fnd_api.G_RET_STS_SUCCESS;

206: )
207: IS
208: index3 VARCHAR2(250) := 'CS_FORUM_MESSAGES_TL_N4';
209: BEGIN
210: x_return_status := fnd_api.G_RET_STS_SUCCESS;
211:
212: SAVEPOINT populate_forum_index_SAV;
213:
214: UPDATE /*+ parallel(t) */ cs_forum_messages_tl t

Line 229: x_return_status := fnd_api.G_RET_STS_ERROR;

225: WHEN OTHERS THEN
226: ROLLBACK TO populate_forum_index_SAV;
227: x_msg_error := 'populate_forum_index: '
228: ||fnd_message.GET_STRING('CS','CS_KB_C_UNEXP_ERR')||' '||SQLERRM;
229: x_return_status := fnd_api.G_RET_STS_ERROR;
230: END populate_forum_index;
231: -- 4321268_new_apis_eof
232: /*
233: * get_max_parallel_worker: get THE job_queue_processes value.

Line 300: x_return_status := fnd_api.G_RET_STS_ERROR;

296:
297: l_update VARCHAR2(1) := 'Y';
298: BEGIN
299: -- initialize return status
300: x_return_status := fnd_api.G_RET_STS_ERROR;
301:
302: EXECUTE IMMEDIATE p_create_cmd;
303:
304: x_return_status := fnd_api.G_RET_STS_SUCCESS;

Line 304: x_return_status := fnd_api.G_RET_STS_SUCCESS;

300: x_return_status := fnd_api.G_RET_STS_ERROR;
301:
302: EXECUTE IMMEDIATE p_create_cmd;
303:
304: x_return_status := fnd_api.G_RET_STS_SUCCESS;
305: EXCEPTION
306: WHEN OTHERS THEN
307: x_msg_error := 'do_create: '||p_index_name||' :'
308: ||fnd_message.GET_STRING('CS','CS_KB_C_UNEXP_ERR')||' '||SQLERRM;

Line 309: x_return_status := fnd_api.G_RET_STS_ERROR;

305: EXCEPTION
306: WHEN OTHERS THEN
307: x_msg_error := 'do_create: '||p_index_name||' :'
308: ||fnd_message.GET_STRING('CS','CS_KB_C_UNEXP_ERR')||' '||SQLERRM;
309: x_return_status := fnd_api.G_RET_STS_ERROR;
310: END do_create;
311:
312:
313: /*

Line 495: x_return_status := fnd_api.G_RET_STS_ERROR;

491: ' l_create_cmmd:'|| l_create_cmmd);
492: END IF;
493:
494: -- End 12.1.3
495: x_return_status := fnd_api.G_RET_STS_ERROR;
496:
497: -- 4321268
498: IF nvl(pworker,0) = 0 THEN
499: -- Create index online

Line 540: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN

536: p_index_version => l_index_version,
537: x_msg_error => x_msg_error,
538: x_return_status => x_return_status );
539: END IF;
540: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
541: RAISE create_index_error;
542: END IF;
543:
544: -- 4321268

Line 551: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN

547: x_msg_error ,
548: x_return_status
549: );
550: END IF;
551: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
552: RAISE create_index_error;
553: END IF;
554: -- 4321268_eof
555:

Line 557: x_return_status := fnd_api.G_RET_STS_SUCCESS;

553: END IF;
554: -- 4321268_eof
555:
556:
557: x_return_status := fnd_api.G_RET_STS_SUCCESS;
558:
559: EXCEPTION
560: WHEN create_index_error THEN
561: NULL; -- x_msg_error is set in the do_create api.

Line 596: x_return_status := fnd_api.G_RET_STS_ERROR;

592: --4321268
593: || ' storage ' ||g_apps_short_name||'.CS_KB_INDEX_STORAGE '; -- <-command not yet completed
594: -- 4321268_eof
595:
596: x_return_status := fnd_api.G_RET_STS_ERROR;
597:
598: -- 4321268
599: IF nvl(pworker,0) = 0 THEN
600: -- Create index online

Line 625: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN

621: x_msg_error ,
622: x_return_status
623: );
624: END IF;
625: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
626: RAISE create_index_error;
627: END IF;
628: -- 4321268_eof
629:

Line 630: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN

626: RAISE create_index_error;
627: END IF;
628: -- 4321268_eof
629:
630: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
631: RAISE create_index_error;
632: END IF;
633: x_return_status := fnd_api.G_RET_STS_SUCCESS;
634:

Line 633: x_return_status := fnd_api.G_RET_STS_SUCCESS;

629:
630: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
631: RAISE create_index_error;
632: END IF;
633: x_return_status := fnd_api.G_RET_STS_SUCCESS;
634:
635: EXCEPTION
636: WHEN create_index_error THEN
637: NULL; -- x_msg_error is set in the do_create api.

Line 671: x_return_status := fnd_api.G_RET_STS_ERROR;

667: --4321268
668: || ' storage ' ||g_apps_short_name||'.CS_KB_INDEX_STORAGE '; -- <-command not yet completed
669: -- 4321268_eof
670:
671: x_return_status := fnd_api.G_RET_STS_ERROR;
672:
673: -- 4321268
674: IF nvl(pworker,0) = 0 THEN
675: -- Create index online

Line 701: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN

697: x_msg_error ,
698: x_return_status
699: );
700: END IF;
701: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
702: RAISE create_index_error;
703: END IF;
704: -- 4321268_eof
705: x_return_status := fnd_api.G_RET_STS_SUCCESS;

Line 705: x_return_status := fnd_api.G_RET_STS_SUCCESS;

701: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
702: RAISE create_index_error;
703: END IF;
704: -- 4321268_eof
705: x_return_status := fnd_api.G_RET_STS_SUCCESS;
706:
707: EXCEPTION
708: WHEN create_index_error THEN
709: NULL; -- x_msg_error is set in the do_create api.

Line 743: x_return_status := fnd_api.G_RET_STS_ERROR;

739: --4321268
740: || ' storage ' ||g_apps_short_name||'.CS_KB_INDEX_STORAGE '; -- <-command not yet completed
741: -- 4321268_eof
742:
743: x_return_status := fnd_api.G_RET_STS_ERROR;
744:
745: -- 4321268
746: IF nvl(pworker,0) = 0 THEN
747: -- Create index online

Line 772: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN

768: x_msg_error ,
769: x_return_status
770: );
771: END IF;
772: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
773: RAISE create_index_error;
774: END IF;
775: -- 4321268_eof
776: x_return_status := fnd_api.G_RET_STS_SUCCESS;

Line 776: x_return_status := fnd_api.G_RET_STS_SUCCESS;

772: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
773: RAISE create_index_error;
774: END IF;
775: -- 4321268_eof
776: x_return_status := fnd_api.G_RET_STS_SUCCESS;
777:
778: EXCEPTION
779: WHEN create_index_error THEN
780: NULL; -- x_msg_error is set in the do_create api.

Line 804: x_return_status := fnd_api.G_RET_STS_ERROR;

800:
801: l_total NUMBER := 0;
802:
803: BEGIN
804: x_return_status := fnd_api.G_RET_STS_ERROR;
805: IF p_index_name IS NULL THEN
806: RETURN;
807: END IF;
808:

Line 819: x_return_status := fnd_api.G_RET_STS_SUCCESS;

815: drop_index := 'drop index '||g_cs_short_name||'.'||p_index_name||' force ';
816: EXECUTE IMMEDIATE drop_index;
817: END IF;
818:
819: x_return_status := fnd_api.G_RET_STS_SUCCESS;
820:
821: -- Logic to remove the index version in the
822: -- global system table.
823: EXCEPTION

Line 860: l_return_status VARCHAR2(1) := fnd_api.G_RET_STS_ERROR;

856: l_num_batch_rows_updated NUMBER := 0;
857: l_reindex_batch_size NUMBER := 300;
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);

Line 906: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN

902: errbuf,
903: l_return_status);
904: --END IF;
905: --12.1.3
906: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
907: RAISE drop_index_error;
908: END IF;
909:
910: Create_Set_Index(pworker,

Line 913: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN

909:
910: Create_Set_Index(pworker,
911: errbuf,
912: l_return_status);
913: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
914: RAISE create_index_error;
915: END IF;
916: ELSIF l_mode = 'RC' THEN
917: -- Rebuild content cache

Line 1066: l_return_status VARCHAR2(1) := fnd_api.G_RET_STS_ERROR;

1062: l_statement_comp_index VARCHAR2(250) := 'CS_KB_ELEMENTS_TL_N2';
1063: l_num_batch_rows_updated NUMBER := 0;
1064: l_reindex_batch_size NUMBER := 300;
1065: l_mode VARCHAR2(10) := bmode;
1066: l_return_status VARCHAR2(1) := fnd_api.G_RET_STS_ERROR;
1067: BEGIN
1068: -- Initialize some variables
1069: retcode := 2; -- init return val to FAIL
1070:

Line 1085: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN

1081: -- At this point we can assume that we can safely drop the index.
1082: Drop_Index(l_statement_comp_index,
1083: errbuf,
1084: l_return_status);
1085: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1086: RAISE drop_index_error;
1087: END IF;
1088:
1089: Create_Element_Index(pworker,

Line 1092: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN

1088:
1089: Create_Element_Index(pworker,
1090: errbuf,
1091: l_return_status);
1092: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1093: RAISE create_index_error;
1094: END IF;
1095: ELSE
1096: fnd_profile.get('CS_KB_REINDEX_BATCH_SIZE', l_reindex_batch_size);

Line 1197: l_return_status VARCHAR2(1) := fnd_api.G_RET_STS_ERROR;

1193:
1194: IS
1195: index3 VARCHAR2(250) := 'CS_FORUM_MESSAGES_TL_N4';
1196: l_mode VARCHAR2(10) := bmode;
1197: l_return_status VARCHAR2(1) := fnd_api.G_RET_STS_ERROR;
1198: BEGIN
1199: -- Initialize some variables
1200: retcode := 2; -- init return val to FAIL
1201:

Line 1216: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN

1212: -- At this point we can assume that we can safely drop the index.
1213: Drop_Index(index3,
1214: errbuf,
1215: l_return_status);
1216: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1217: RAISE drop_index_error;
1218: END IF;
1219:
1220: Create_Forum_Index(pworker,

Line 1223: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN

1219:
1220: Create_Forum_Index(pworker,
1221: errbuf,
1222: l_return_status);
1223: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1224: RAISE create_index_error;
1225: END IF;
1226: ELSE
1227: -- 4321268

Line 1280: l_return_status VARCHAR2(1) := fnd_api.G_RET_STS_ERROR;

1276: pworker IN NUMBER DEFAULT 0)
1277: IS
1278: index1 VARCHAR2(250) := 'CS_KB_SOLN_CAT_TL_N1';
1279: l_mode VARCHAR2(10) := bmode;
1280: l_return_status VARCHAR2(1) := fnd_api.G_RET_STS_ERROR;
1281:
1282: BEGIN
1283: retcode := 2;
1284:

Line 1299: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN

1295: -- At this point we can assume that we can safely drop the index.
1296: Drop_Index(index1,
1297: errbuf,
1298: l_return_status);
1299: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1300: RAISE drop_index_error;
1301: END IF;
1302:
1303: Create_Soln_Cat_Index(pworker,

Line 1306: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN

1302:
1303: Create_Soln_Cat_Index(pworker,
1304: errbuf,
1305: l_return_status);
1306: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1307: RAISE create_index_error;
1308: END IF;
1309: ELSE
1310: -- 4321268

Line 1557: Cs_Knowledge_Audit_Pvt.Update_Solution_Usage_Score(p_commit =>fnd_api.g_true);

1553: RETCODE OUT NOCOPY NUMBER) AS
1554:
1555: BEGIN
1556: SAVEPOINT Update_Usage_Score_Sav;
1557: Cs_Knowledge_Audit_Pvt.Update_Solution_Usage_Score(p_commit =>fnd_api.g_true);
1558: errbuf := fnd_message.get_string('CS', 'CS_KB_C_SUCCESS');
1559: retcode := 0;
1560: EXCEPTION
1561: WHEN OTHERS THEN