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 123: ||fnd_message.GET_STRING('CS','CS_KB_C_UNEXP_ERR')||' '||SQLERRM;

119: EXCEPTION
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: /*

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

156: EXCEPTION
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:

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

190: EXCEPTION
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:

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

224: EXCEPTION
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: /*

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

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;
309: x_return_status := fnd_api.G_RET_STS_ERROR;
310: END do_create;
311:
312:

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

391: -- logic to drop or create is taken in the individual api.
392: NULL;
393: ELSE
394: FND_FILE.PUT_LINE(FND_FILE.LOG,
395: fnd_message.get_string('CS', 'CS_KB_SYN_INDEX_INV_MODE'));
396: RAISE invalid_mode_error;
397: END IF;
398: END Sync_index;
399:

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

408: IS
409: BEGIN
410:
411: -- Return successfully
412: errbuf := fnd_message.get_string('CS', 'CS_KB_C_SUCCESS');
413: retcode :=0;
414: END Sync_All_Index;
415:
416: /*

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

560: WHEN create_index_error THEN
561: NULL; -- x_msg_error is set in the do_create api.
562: WHEN others THEN
563: x_msg_error := 'Create_Set_Index: '
564: ||fnd_message.GET_STRING('CS','CS_KB_C_UNEXP_ERR')||' '||SQLERRM;
565: END Create_Set_Index;
566:
567:
568: /*

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

636: WHEN create_index_error THEN
637: NULL; -- x_msg_error is set in the do_create api.
638: WHEN others THEN
639: x_msg_error := 'Create_Element_Index: '
640: ||fnd_message.GET_STRING('CS','CS_KB_C_UNEXP_ERR')||' '||SQLERRM;
641: END Create_Element_Index;
642:
643:
644: /*

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

708: WHEN create_index_error THEN
709: NULL; -- x_msg_error is set in the do_create api.
710: WHEN others THEN
711: x_msg_error := 'Create_Element_Index: '
712: ||fnd_message.GET_STRING('CS','CS_KB_C_UNEXP_ERR')||' '||SQLERRM;
713: END Create_Soln_Cat_Index;
714:
715: /*
716: * Create_Forum_Index

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

779: WHEN create_index_error THEN
780: NULL; -- x_msg_error is set in the do_create api.
781: WHEN others THEN
782: x_msg_error := 'Create_Forum_Index: '
783: ||fnd_message.GET_STRING('CS','CS_KB_C_UNEXP_ERR')||' '||SQLERRM;
784: END Create_Forum_Index;
785:
786:
787:

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

822: -- global system table.
823: EXCEPTION
824: WHEN others THEN
825: x_msg_error := 'Drop_Index: '||
826: fnd_message.GET_STRING('CS','CS_KB_C_UNEXP_ERR')||' '||
827: SQLERRM;
828: END Drop_Index;
829:
830:

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

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

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

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

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

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

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

1149:
1150: END LOOP;
1151: END IF;
1152: -- Set return value and log message to Success
1153: errbuf := fnd_message.get_string('CS', 'CS_KB_C_SUCCESS');
1154: retcode := 0;
1155:
1156: EXCEPTION
1157: WHEN invalid_mode_error THEN

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

1155:
1156: EXCEPTION
1157: WHEN invalid_mode_error THEN
1158: BEGIN
1159: errbuf := fnd_message.get_string('CS', 'CS_KB_SYN_INDEX_INV_MODE');
1160: END;
1161: WHEN drop_index_error THEN
1162: BEGIN
1163: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);

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

1173: NULL;
1174: END;
1175: WHEN others THEN
1176: errbuf := 'Sync_Element_Index: '||
1177: fnd_message.GET_STRING('CS','CS_KB_C_UNEXP_ERR')||' '||
1178: SQLERRM;
1179: -- Write out error to concurrent program log
1180: BEGIN
1181: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);

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

1236: -- 4321268_eof
1237: END IF;
1238:
1239: -- Return successfully
1240: errbuf := fnd_message.get_string('CS', 'CS_KB_C_SUCCESS');
1241: retcode := 0;
1242: EXCEPTION
1243: WHEN invalid_mode_error THEN
1244: BEGIN

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

1241: retcode := 0;
1242: EXCEPTION
1243: WHEN invalid_mode_error THEN
1244: BEGIN
1245: errbuf := fnd_message.get_string('CS', 'CS_KB_SYN_INDEX_INV_MODE');
1246: END;
1247: WHEN drop_index_error THEN
1248: BEGIN
1249: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);

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

1259: NULL;
1260: END;
1261: WHEN others THEN
1262: errbuf := 'Sync_Forum_Index: '||
1263: fnd_message.GET_STRING('CS','CS_KB_C_UNEXP_ERR')||' '||
1264: SQLERRM;
1265: BEGIN
1266: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);
1267: EXCEPTION

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

1319: -- 4321268_eof
1320: END IF;
1321:
1322: -- Return successfully
1323: errbuf := fnd_message.get_string('CS', 'CS_KB_C_SUCCESS');
1324: retcode := 0;
1325: EXCEPTION
1326: WHEN invalid_mode_error THEN
1327: BEGIN

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

1324: retcode := 0;
1325: EXCEPTION
1326: WHEN invalid_mode_error THEN
1327: BEGIN
1328: errbuf := fnd_message.get_string('CS', 'CS_KB_SYN_INDEX_INV_MODE');
1329: END;
1330: WHEN drop_index_error THEN
1331: BEGIN
1332: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);

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

1342: NULL;
1343: END;
1344: WHEN others THEN
1345: errbuf := 'Sync_Soln_Cat_Index: '||
1346: fnd_message.GET_STRING('CS','CS_KB_C_UNEXP_ERR')||' '||
1347: SQLERRM;
1348: BEGIN
1349: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);
1350: EXCEPTION

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

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
1562: ROLLBACK TO Update_Usage_Score_Sav;

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

1610: lCounter := 0;
1611: END IF;
1612: END LOOP;
1613: COMMIT;
1614: errbuf := fnd_message.get_string('CS', 'CS_KB_C_SUCCESS');
1615: retcode := 0;
1616: EXCEPTION
1617: WHEN others THEN
1618: ROLLBACK TO start_rebuild_cache;

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

1615: retcode := 0;
1616: EXCEPTION
1617: WHEN others THEN
1618: ROLLBACK TO start_rebuild_cache;
1619: errbuf := 'Rebuild_Soln_Content_Cache: '||fnd_message.GET_STRING('CS','CS_KB_C_UNEXP_ERR')||' '||SQLERRM;
1620: -- Write out error to concurrent program log
1621: BEGIN
1622: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);
1623: EXCEPTION

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

1650: BEGIN
1651: -- Initialize some variables
1652: retcode := ERROR; -- init return val to FAIL
1653:
1654: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.get_string('CS', 'CS_KB_SYNC_IND_BEG')||' '|| 'Mark_Idx_on_Sec_Change');
1655:
1656: -- Call out to appropriate helper function for the
1657: -- security setup change action type
1658: IF ( security_change_action_type = 'ADD_VIS' )

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

1656: -- Call out to appropriate helper function for the
1657: -- security setup change action type
1658: IF ( security_change_action_type = 'ADD_VIS' )
1659: THEN
1660: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.get_string('CS', 'CS_KB_SYNC_IND_PROC')||' '|| 'ADD_VIS');
1661: l_visibility_id := PARAMETER1;
1662: cs_kb_sync_index_pkg.Mark_Idx_on_Add_Vis( l_visibility_id );
1663: ELSIF ( security_change_action_type = 'REM_VIS' )
1664: THEN

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

1661: l_visibility_id := PARAMETER1;
1662: cs_kb_sync_index_pkg.Mark_Idx_on_Add_Vis( l_visibility_id );
1663: ELSIF ( security_change_action_type = 'REM_VIS' )
1664: THEN
1665: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.get_string('CS', 'CS_KB_SYNC_IND_PROC')||' '|| 'REM_VIS');
1666: l_visibility_id := PARAMETER1;
1667: cs_kb_sync_index_pkg.Mark_Idx_on_Rem_Vis( l_visibility_id );
1668: ELSIF ( security_change_action_type = 'CHANGE_CAT_VIS' )
1669: THEN

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

1666: l_visibility_id := PARAMETER1;
1667: cs_kb_sync_index_pkg.Mark_Idx_on_Rem_Vis( l_visibility_id );
1668: ELSIF ( security_change_action_type = 'CHANGE_CAT_VIS' )
1669: THEN
1670: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.get_string('CS', 'CS_KB_SYNC_IND_PROC')||' '|| 'CHANGE_CAT_VIS');
1671: l_category_id := PARAMETER1;
1672: l_orig_visibility_id := PARAMETER2;
1673: cs_kb_sync_index_pkg.Mark_Idx_on_Change_Cat_Vis( l_category_id, l_orig_visibility_id );
1674: ELSIF ( security_change_action_type = 'ADD_CAT_TO_CAT_GRP' )

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

1672: l_orig_visibility_id := PARAMETER2;
1673: cs_kb_sync_index_pkg.Mark_Idx_on_Change_Cat_Vis( l_category_id, l_orig_visibility_id );
1674: ELSIF ( security_change_action_type = 'ADD_CAT_TO_CAT_GRP' )
1675: THEN
1676: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.get_string('CS', 'CS_KB_SYNC_IND_PROC')||' '|| 'ADD_CAT_TO_CAT_GRP');
1677: l_cat_grp_id := PARAMETER1;
1678: l_category_id := PARAMETER2;
1679: cs_kb_sync_index_pkg.Mark_Idx_on_Add_Cat_To_Cat_Grp( l_cat_grp_id, l_category_id );
1680: ELSIF ( security_change_action_type = 'REM_CAT_FROM_CAT_GRP' )

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

1678: l_category_id := PARAMETER2;
1679: cs_kb_sync_index_pkg.Mark_Idx_on_Add_Cat_To_Cat_Grp( l_cat_grp_id, l_category_id );
1680: ELSIF ( security_change_action_type = 'REM_CAT_FROM_CAT_GRP' )
1681: THEN
1682: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.get_string('CS', 'CS_KB_SYNC_IND_PROC')||' '|| 'REM_CAT_FROM_CAT_GRP');
1683: l_cat_grp_id := PARAMETER1;
1684: l_category_id := PARAMETER2;
1685: cs_kb_sync_index_pkg.Mark_Idx_on_Rem_Cat_fr_Cat_Grp( l_cat_grp_id, l_category_id );
1686: ELSIF ( security_change_action_type = 'CHANGE_PARENT_CAT' )

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

1684: l_category_id := PARAMETER2;
1685: cs_kb_sync_index_pkg.Mark_Idx_on_Rem_Cat_fr_Cat_Grp( l_cat_grp_id, l_category_id );
1686: ELSIF ( security_change_action_type = 'CHANGE_PARENT_CAT' )
1687: THEN
1688: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.get_string('CS', 'CS_KB_SYNC_IND_PROC')||' '|| 'CHANGE_PARENT_CAT');
1689: l_category_id := PARAMETER1;
1690: l_orig_parent_category_id := PARAMETER2;
1691: cs_kb_sync_index_pkg.Mark_Idx_on_Change_Parent_Cat( l_category_id, l_orig_parent_category_id );
1692: ELSE -- invalid action

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

1690: l_orig_parent_category_id := PARAMETER2;
1691: cs_kb_sync_index_pkg.Mark_Idx_on_Change_Parent_Cat( l_category_id, l_orig_parent_category_id );
1692: ELSE -- invalid action
1693:
1694: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.get_string('CS', 'CS_KB_SYNC_IND_INV_TYPE'));
1695: -- 'Error: Invalid change security setup action type specified'
1696: RAISE invalid_action_error;
1697: END IF;
1698: COMMIT;

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

1696: RAISE invalid_action_error;
1697: END IF;
1698: COMMIT;
1699: -- Set return value and log message to Success
1700: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.get_string('CS', 'CS_KB_SYNC_SUCESS_END'));
1701: -- 'Successfully Completed.'
1702: errbuf := fnd_message.get_string('CS', 'CS_KB_C_SUCCESS');
1703: retcode := SUCCESS;
1704:

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

1698: COMMIT;
1699: -- Set return value and log message to Success
1700: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.get_string('CS', 'CS_KB_SYNC_SUCESS_END'));
1701: -- 'Successfully Completed.'
1702: errbuf := fnd_message.get_string('CS', 'CS_KB_C_SUCCESS');
1703: retcode := SUCCESS;
1704:
1705: EXCEPTION
1706: WHEN invalid_action_error THEN

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

1704:
1705: EXCEPTION
1706: WHEN invalid_action_error THEN
1707: BEGIN
1708: errbuf := fnd_message.get_string('CS', 'CS_KB_SYN_INDEX_INV_ACT');
1709: -- 'Invalid action specified'
1710: END;
1711: WHEN others THEN
1712: ROLLBACK;

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

1709: -- 'Invalid action specified'
1710: END;
1711: WHEN others THEN
1712: ROLLBACK;
1713: errbuf := 'Mark_Idx_on_Sec_Change: '||fnd_message.GET_STRING('CS','CS_KB_C_UNEXP_ERR')||' '||SQLERRM;
1714: -- Write out error to concurrent program log
1715: BEGIN
1716: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);
1717: EXCEPTION