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_MESSAGE

Line 94: ||fnd_message.GET_STRING('CS','CS_KB_C_UNEXP_ERR')||' '||SQLERRM;

90: EXCEPTION
91: WHEN OTHERS THEN
92: ROLLBACK; -- do not use savepoint because savepoint is cleared when commit.
93: x_msg_error := 'populate_set_index: '
94: ||fnd_message.GET_STRING('CS','CS_KB_C_UNEXP_ERR')||' '||SQLERRM;
95: x_return_status := fnd_api.G_RET_STS_ERROR;
96: END populate_set_index;
97:
98: /*

Line 131: ||fnd_message.GET_STRING('CS','CS_KB_C_UNEXP_ERR')||' '||SQLERRM;

127: EXCEPTION
128: WHEN OTHERS THEN
129: ROLLBACK TO populate_element_index_SAV;
130: x_msg_error := 'populate_element_index: '
131: ||fnd_message.GET_STRING('CS','CS_KB_C_UNEXP_ERR')||' '||SQLERRM;
132: x_return_status := fnd_api.G_RET_STS_ERROR;
133: END populate_element_index;
134:
135:

Line 165: ||fnd_message.GET_STRING('CS','CS_KB_C_UNEXP_ERR')||' '||SQLERRM;

161: EXCEPTION
162: WHEN OTHERS THEN
163: ROLLBACK TO populate_soln_cat_index_SAV;
164: x_msg_error := 'populate_sol_cat_index: '
165: ||fnd_message.GET_STRING('CS','CS_KB_C_UNEXP_ERR')||' '||SQLERRM;
166: x_return_status := fnd_api.G_RET_STS_ERROR;
167: END populate_soln_cat_index;
168:
169:

Line 199: ||fnd_message.GET_STRING('CS','CS_KB_C_UNEXP_ERR')||' '||SQLERRM;

195: EXCEPTION
196: WHEN OTHERS THEN
197: ROLLBACK TO populate_forum_index_SAV;
198: x_msg_error := 'populate_forum_index: '
199: ||fnd_message.GET_STRING('CS','CS_KB_C_UNEXP_ERR')||' '||SQLERRM;
200: x_return_status := fnd_api.G_RET_STS_ERROR;
201: END populate_forum_index;
202: -- 4321268_new_apis_eof
203: /*

Line 279: ||fnd_message.GET_STRING('CS','CS_KB_C_UNEXP_ERR')||' '||SQLERRM;

275: x_return_status := fnd_api.G_RET_STS_SUCCESS;
276: EXCEPTION
277: WHEN OTHERS THEN
278: x_msg_error := 'do_create: '||p_index_name||' :'
279: ||fnd_message.GET_STRING('CS','CS_KB_C_UNEXP_ERR')||' '||SQLERRM;
280: x_return_status := fnd_api.G_RET_STS_ERROR;
281: END do_create;
282:
283:

Line 367: fnd_message.get_string('CS', 'CS_KB_SYN_INDEX_INV_MODE'));

363: -- logic to drop or create is taken in the individual api.
364: NULL;
365: ELSE
366: FND_FILE.PUT_LINE(FND_FILE.LOG,
367: fnd_message.get_string('CS', 'CS_KB_SYN_INDEX_INV_MODE'));
368: RAISE invalid_mode_error;
369: END IF;
370: END Sync_index;
371:

Line 384: errbuf := fnd_message.get_string('CS', 'CS_KB_C_SUCCESS');

380: IS
381: BEGIN
382:
383: -- Return successfully
384: errbuf := fnd_message.get_string('CS', 'CS_KB_C_SUCCESS');
385: retcode :=0;
386: END Sync_All_Index;
387:
388: /*

Line 461: ||fnd_message.GET_STRING('CS','CS_KB_C_UNEXP_ERR')||' '||SQLERRM;

457: WHEN create_index_error THEN
458: NULL; -- x_msg_error is set in the do_create api.
459: WHEN others THEN
460: x_msg_error := 'Create_Set_Index: '
461: ||fnd_message.GET_STRING('CS','CS_KB_C_UNEXP_ERR')||' '||SQLERRM;
462: END Create_Set_Index;
463:
464:
465: /*

Line 537: ||fnd_message.GET_STRING('CS','CS_KB_C_UNEXP_ERR')||' '||SQLERRM;

533: WHEN create_index_error THEN
534: NULL; -- x_msg_error is set in the do_create api.
535: WHEN others THEN
536: x_msg_error := 'Create_Element_Index: '
537: ||fnd_message.GET_STRING('CS','CS_KB_C_UNEXP_ERR')||' '||SQLERRM;
538: END Create_Element_Index;
539:
540:
541: /*

Line 609: ||fnd_message.GET_STRING('CS','CS_KB_C_UNEXP_ERR')||' '||SQLERRM;

605: WHEN create_index_error THEN
606: NULL; -- x_msg_error is set in the do_create api.
607: WHEN others THEN
608: x_msg_error := 'Create_Element_Index: '
609: ||fnd_message.GET_STRING('CS','CS_KB_C_UNEXP_ERR')||' '||SQLERRM;
610: END Create_Soln_Cat_Index;
611:
612: /*
613: * Create_Forum_Index

Line 680: ||fnd_message.GET_STRING('CS','CS_KB_C_UNEXP_ERR')||' '||SQLERRM;

676: WHEN create_index_error THEN
677: NULL; -- x_msg_error is set in the do_create api.
678: WHEN others THEN
679: x_msg_error := 'Create_Forum_Index: '
680: ||fnd_message.GET_STRING('CS','CS_KB_C_UNEXP_ERR')||' '||SQLERRM;
681: END Create_Forum_Index;
682:
683:
684:

Line 723: fnd_message.GET_STRING('CS','CS_KB_C_UNEXP_ERR')||' '||

719: -- global system table.
720: EXCEPTION
721: WHEN others THEN
722: x_msg_error := 'Drop_Index: '||
723: fnd_message.GET_STRING('CS','CS_KB_C_UNEXP_ERR')||' '||
724: SQLERRM;
725: END Drop_Index;
726:
727:

Line 854: errbuf := fnd_message.get_string('CS', 'CS_KB_C_SUCCESS');

850: -- Update magic word.
851: Update_Magic_Word;
852:
853: -- Set return value and log message to Success
854: errbuf := fnd_message.get_string('CS', 'CS_KB_C_SUCCESS');
855: retcode := 0;
856:
857: EXCEPTION
858: WHEN invalid_mode_error THEN

Line 860: errbuf := fnd_message.get_string('CS', 'CS_KB_SYN_INDEX_INV_MODE');

856:
857: EXCEPTION
858: WHEN invalid_mode_error THEN
859: BEGIN
860: errbuf := fnd_message.get_string('CS', 'CS_KB_SYN_INDEX_INV_MODE');
861: END;
862: WHEN drop_index_error THEN
863: BEGIN
864: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);

Line 878: fnd_message.GET_STRING('CS','CS_KB_C_UNEXP_ERR')||' '||

874: NULL;
875: END;
876: WHEN others THEN
877: errbuf := 'Sync_Set_Index: '||
878: fnd_message.GET_STRING('CS','CS_KB_C_UNEXP_ERR')||' '||
879: SQLERRM;
880: -- Write out error to concurrent program log
881: BEGIN
882: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);

Line 1004: errbuf := fnd_message.get_string('CS', 'CS_KB_C_SUCCESS');

1000:
1001: END LOOP;
1002: END IF;
1003: -- Set return value and log message to Success
1004: errbuf := fnd_message.get_string('CS', 'CS_KB_C_SUCCESS');
1005: retcode := 0;
1006:
1007: EXCEPTION
1008: WHEN invalid_mode_error THEN

Line 1010: errbuf := fnd_message.get_string('CS', 'CS_KB_SYN_INDEX_INV_MODE');

1006:
1007: EXCEPTION
1008: WHEN invalid_mode_error THEN
1009: BEGIN
1010: errbuf := fnd_message.get_string('CS', 'CS_KB_SYN_INDEX_INV_MODE');
1011: END;
1012: WHEN drop_index_error THEN
1013: BEGIN
1014: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);

Line 1028: fnd_message.GET_STRING('CS','CS_KB_C_UNEXP_ERR')||' '||

1024: NULL;
1025: END;
1026: WHEN others THEN
1027: errbuf := 'Sync_Element_Index: '||
1028: fnd_message.GET_STRING('CS','CS_KB_C_UNEXP_ERR')||' '||
1029: SQLERRM;
1030: -- Write out error to concurrent program log
1031: BEGIN
1032: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);

Line 1091: errbuf := fnd_message.get_string('CS', 'CS_KB_C_SUCCESS');

1087: -- 4321268_eof
1088: END IF;
1089:
1090: -- Return successfully
1091: errbuf := fnd_message.get_string('CS', 'CS_KB_C_SUCCESS');
1092: retcode := 0;
1093: EXCEPTION
1094: WHEN invalid_mode_error THEN
1095: BEGIN

Line 1096: errbuf := fnd_message.get_string('CS', 'CS_KB_SYN_INDEX_INV_MODE');

1092: retcode := 0;
1093: EXCEPTION
1094: WHEN invalid_mode_error THEN
1095: BEGIN
1096: errbuf := fnd_message.get_string('CS', 'CS_KB_SYN_INDEX_INV_MODE');
1097: END;
1098: WHEN drop_index_error THEN
1099: BEGIN
1100: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);

Line 1114: fnd_message.GET_STRING('CS','CS_KB_C_UNEXP_ERR')||' '||

1110: NULL;
1111: END;
1112: WHEN others THEN
1113: errbuf := 'Sync_Forum_Index: '||
1114: fnd_message.GET_STRING('CS','CS_KB_C_UNEXP_ERR')||' '||
1115: SQLERRM;
1116: BEGIN
1117: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);
1118: EXCEPTION

Line 1174: errbuf := fnd_message.get_string('CS', 'CS_KB_C_SUCCESS');

1170: -- 4321268_eof
1171: END IF;
1172:
1173: -- Return successfully
1174: errbuf := fnd_message.get_string('CS', 'CS_KB_C_SUCCESS');
1175: retcode := 0;
1176: EXCEPTION
1177: WHEN invalid_mode_error THEN
1178: BEGIN

Line 1179: errbuf := fnd_message.get_string('CS', 'CS_KB_SYN_INDEX_INV_MODE');

1175: retcode := 0;
1176: EXCEPTION
1177: WHEN invalid_mode_error THEN
1178: BEGIN
1179: errbuf := fnd_message.get_string('CS', 'CS_KB_SYN_INDEX_INV_MODE');
1180: END;
1181: WHEN drop_index_error THEN
1182: BEGIN
1183: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);

Line 1197: fnd_message.GET_STRING('CS','CS_KB_C_UNEXP_ERR')||' '||

1193: NULL;
1194: END;
1195: WHEN others THEN
1196: errbuf := 'Sync_Soln_Cat_Index: '||
1197: fnd_message.GET_STRING('CS','CS_KB_C_UNEXP_ERR')||' '||
1198: SQLERRM;
1199: BEGIN
1200: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);
1201: EXCEPTION

Line 1409: errbuf := fnd_message.get_string('CS', 'CS_KB_C_SUCCESS');

1405:
1406: BEGIN
1407: SAVEPOINT Update_Usage_Score_Sav;
1408: Cs_Knowledge_Audit_Pvt.Update_Solution_Usage_Score(p_commit =>fnd_api.g_true);
1409: errbuf := fnd_message.get_string('CS', 'CS_KB_C_SUCCESS');
1410: retcode := 0;
1411: EXCEPTION
1412: WHEN OTHERS THEN
1413: ROLLBACK TO Update_Usage_Score_Sav;

Line 1464: errbuf := fnd_message.get_string('CS', 'CS_KB_C_SUCCESS');

1460: lCounter := 0;
1461: END IF;
1462: END LOOP;
1463: COMMIT;
1464: errbuf := fnd_message.get_string('CS', 'CS_KB_C_SUCCESS');
1465: retcode := 0;
1466: EXCEPTION
1467: WHEN others THEN
1468: ROLLBACK TO start_rebuild_cache;

Line 1469: errbuf := 'Rebuild_Soln_Content_Cache: '||fnd_message.GET_STRING('CS','CS_KB_C_UNEXP_ERR')||' '||SQLERRM;

1465: retcode := 0;
1466: EXCEPTION
1467: WHEN others THEN
1468: ROLLBACK TO start_rebuild_cache;
1469: errbuf := 'Rebuild_Soln_Content_Cache: '||fnd_message.GET_STRING('CS','CS_KB_C_UNEXP_ERR')||' '||SQLERRM;
1470: -- Write out error to concurrent program log
1471: BEGIN
1472: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);
1473: EXCEPTION

Line 1504: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.get_string('CS', 'CS_KB_SYNC_IND_BEG')||' '|| 'Mark_Idx_on_Sec_Change');

1500: BEGIN
1501: -- Initialize some variables
1502: retcode := ERROR; -- init return val to FAIL
1503:
1504: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.get_string('CS', 'CS_KB_SYNC_IND_BEG')||' '|| 'Mark_Idx_on_Sec_Change');
1505:
1506: -- Call out to appropriate helper function for the
1507: -- security setup change action type
1508: IF ( security_change_action_type = 'ADD_VIS' )

Line 1510: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.get_string('CS', 'CS_KB_SYNC_IND_PROC')||' '|| 'ADD_VIS');

1506: -- Call out to appropriate helper function for the
1507: -- security setup change action type
1508: IF ( security_change_action_type = 'ADD_VIS' )
1509: THEN
1510: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.get_string('CS', 'CS_KB_SYNC_IND_PROC')||' '|| 'ADD_VIS');
1511: l_visibility_id := PARAMETER1;
1512: cs_kb_sync_index_pkg.Mark_Idx_on_Add_Vis( l_visibility_id );
1513: ELSIF ( security_change_action_type = 'REM_VIS' )
1514: THEN

Line 1515: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.get_string('CS', 'CS_KB_SYNC_IND_PROC')||' '|| 'REM_VIS');

1511: l_visibility_id := PARAMETER1;
1512: cs_kb_sync_index_pkg.Mark_Idx_on_Add_Vis( l_visibility_id );
1513: ELSIF ( security_change_action_type = 'REM_VIS' )
1514: THEN
1515: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.get_string('CS', 'CS_KB_SYNC_IND_PROC')||' '|| 'REM_VIS');
1516: l_visibility_id := PARAMETER1;
1517: cs_kb_sync_index_pkg.Mark_Idx_on_Rem_Vis( l_visibility_id );
1518: ELSIF ( security_change_action_type = 'CHANGE_CAT_VIS' )
1519: THEN

Line 1520: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.get_string('CS', 'CS_KB_SYNC_IND_PROC')||' '|| 'CHANGE_CAT_VIS');

1516: l_visibility_id := PARAMETER1;
1517: cs_kb_sync_index_pkg.Mark_Idx_on_Rem_Vis( l_visibility_id );
1518: ELSIF ( security_change_action_type = 'CHANGE_CAT_VIS' )
1519: THEN
1520: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.get_string('CS', 'CS_KB_SYNC_IND_PROC')||' '|| 'CHANGE_CAT_VIS');
1521: l_category_id := PARAMETER1;
1522: l_orig_visibility_id := PARAMETER2;
1523: cs_kb_sync_index_pkg.Mark_Idx_on_Change_Cat_Vis( l_category_id, l_orig_visibility_id );
1524: ELSIF ( security_change_action_type = 'ADD_CAT_TO_CAT_GRP' )

Line 1526: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.get_string('CS', 'CS_KB_SYNC_IND_PROC')||' '|| 'ADD_CAT_TO_CAT_GRP');

1522: l_orig_visibility_id := PARAMETER2;
1523: cs_kb_sync_index_pkg.Mark_Idx_on_Change_Cat_Vis( l_category_id, l_orig_visibility_id );
1524: ELSIF ( security_change_action_type = 'ADD_CAT_TO_CAT_GRP' )
1525: THEN
1526: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.get_string('CS', 'CS_KB_SYNC_IND_PROC')||' '|| 'ADD_CAT_TO_CAT_GRP');
1527: l_cat_grp_id := PARAMETER1;
1528: l_category_id := PARAMETER2;
1529: cs_kb_sync_index_pkg.Mark_Idx_on_Add_Cat_To_Cat_Grp( l_cat_grp_id, l_category_id );
1530: ELSIF ( security_change_action_type = 'REM_CAT_FROM_CAT_GRP' )

Line 1532: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.get_string('CS', 'CS_KB_SYNC_IND_PROC')||' '|| 'REM_CAT_FROM_CAT_GRP');

1528: l_category_id := PARAMETER2;
1529: cs_kb_sync_index_pkg.Mark_Idx_on_Add_Cat_To_Cat_Grp( l_cat_grp_id, l_category_id );
1530: ELSIF ( security_change_action_type = 'REM_CAT_FROM_CAT_GRP' )
1531: THEN
1532: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.get_string('CS', 'CS_KB_SYNC_IND_PROC')||' '|| 'REM_CAT_FROM_CAT_GRP');
1533: l_cat_grp_id := PARAMETER1;
1534: l_category_id := PARAMETER2;
1535: cs_kb_sync_index_pkg.Mark_Idx_on_Rem_Cat_fr_Cat_Grp( l_cat_grp_id, l_category_id );
1536: ELSIF ( security_change_action_type = 'CHANGE_PARENT_CAT' )

Line 1538: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.get_string('CS', 'CS_KB_SYNC_IND_PROC')||' '|| 'CHANGE_PARENT_CAT');

1534: l_category_id := PARAMETER2;
1535: cs_kb_sync_index_pkg.Mark_Idx_on_Rem_Cat_fr_Cat_Grp( l_cat_grp_id, l_category_id );
1536: ELSIF ( security_change_action_type = 'CHANGE_PARENT_CAT' )
1537: THEN
1538: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.get_string('CS', 'CS_KB_SYNC_IND_PROC')||' '|| 'CHANGE_PARENT_CAT');
1539: l_category_id := PARAMETER1;
1540: l_orig_parent_category_id := PARAMETER2;
1541: cs_kb_sync_index_pkg.Mark_Idx_on_Change_Parent_Cat( l_category_id, l_orig_parent_category_id );
1542: ELSE -- invalid action

Line 1544: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.get_string('CS', 'CS_KB_SYNC_IND_INV_TYPE'));

1540: l_orig_parent_category_id := PARAMETER2;
1541: cs_kb_sync_index_pkg.Mark_Idx_on_Change_Parent_Cat( l_category_id, l_orig_parent_category_id );
1542: ELSE -- invalid action
1543:
1544: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.get_string('CS', 'CS_KB_SYNC_IND_INV_TYPE'));
1545: -- 'Error: Invalid change security setup action type specified'
1546: RAISE invalid_action_error;
1547: END IF;
1548: COMMIT;

Line 1550: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.get_string('CS', 'CS_KB_SYNC_SUCESS_END'));

1546: RAISE invalid_action_error;
1547: END IF;
1548: COMMIT;
1549: -- Set return value and log message to Success
1550: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.get_string('CS', 'CS_KB_SYNC_SUCESS_END'));
1551: -- 'Successfully Completed.'
1552: errbuf := fnd_message.get_string('CS', 'CS_KB_C_SUCCESS');
1553: retcode := SUCCESS;
1554:

Line 1552: errbuf := fnd_message.get_string('CS', 'CS_KB_C_SUCCESS');

1548: COMMIT;
1549: -- Set return value and log message to Success
1550: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.get_string('CS', 'CS_KB_SYNC_SUCESS_END'));
1551: -- 'Successfully Completed.'
1552: errbuf := fnd_message.get_string('CS', 'CS_KB_C_SUCCESS');
1553: retcode := SUCCESS;
1554:
1555: EXCEPTION
1556: WHEN invalid_action_error THEN

Line 1558: errbuf := fnd_message.get_string('CS', 'CS_KB_SYN_INDEX_INV_ACT');

1554:
1555: EXCEPTION
1556: WHEN invalid_action_error THEN
1557: BEGIN
1558: errbuf := fnd_message.get_string('CS', 'CS_KB_SYN_INDEX_INV_ACT');
1559: -- 'Invalid action specified'
1560: END;
1561: WHEN others THEN
1562: ROLLBACK;

Line 1563: errbuf := 'Mark_Idx_on_Sec_Change: '||fnd_message.GET_STRING('CS','CS_KB_C_UNEXP_ERR')||' '||SQLERRM;

1559: -- 'Invalid action specified'
1560: END;
1561: WHEN others THEN
1562: ROLLBACK;
1563: errbuf := 'Mark_Idx_on_Sec_Change: '||fnd_message.GET_STRING('CS','CS_KB_C_UNEXP_ERR')||' '||SQLERRM;
1564: -- Write out error to concurrent program log
1565: BEGIN
1566: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);
1567: EXCEPTION