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_FILE

Line 366: FND_FILE.PUT_LINE(FND_FILE.LOG,

362: ELSIF bmode = 'DR' THEN
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;

Line 864: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);

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);
865: EXCEPTION
866: WHEN others THEN
867: NULL;
868: END;

Line 871: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);

867: NULL;
868: END;
869: WHEN create_index_error THEN
870: BEGIN
871: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);
872: EXCEPTION
873: WHEN others THEN
874: NULL;
875: END;

Line 882: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);

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);
883: EXCEPTION
884: WHEN others THEN
885: NULL;
886: END;

Line 1014: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);

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);
1015: EXCEPTION
1016: WHEN others THEN
1017: NULL;
1018: END;

Line 1021: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);

1017: NULL;
1018: END;
1019: WHEN create_index_error THEN
1020: BEGIN
1021: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);
1022: EXCEPTION
1023: WHEN others THEN
1024: NULL;
1025: END;

Line 1032: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);

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);
1033: EXCEPTION
1034: WHEN others THEN
1035: NULL;
1036: END;

Line 1100: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);

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);
1101: EXCEPTION
1102: WHEN others THEN
1103: NULL;
1104: END;

Line 1107: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);

1103: NULL;
1104: END;
1105: WHEN create_index_error THEN
1106: BEGIN
1107: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);
1108: EXCEPTION
1109: WHEN others THEN
1110: NULL;
1111: END;

Line 1117: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);

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
1119: WHEN others THEN
1120: NULL;
1121: END;

Line 1183: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);

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);
1184: EXCEPTION
1185: WHEN others THEN
1186: NULL;
1187: END;

Line 1190: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);

1186: NULL;
1187: END;
1188: WHEN create_index_error THEN
1189: BEGIN
1190: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);
1191: EXCEPTION
1192: WHEN others THEN
1193: NULL;
1194: END;

Line 1200: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);

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
1202: WHEN others THEN
1203: NULL;
1204: END;

Line 1417: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);

1413: ROLLBACK TO Update_Usage_Score_Sav;
1414: retcode := 2;
1415: errbuf := sqlerrm;
1416: BEGIN
1417: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);
1418: EXCEPTION
1419: WHEN others THEN
1420: NULL;
1421: END;

Line 1472: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);

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
1474: WHEN others THEN
1475: NULL;
1476: END;

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 1566: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);

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
1568: WHEN others THEN
1569: NULL;
1570: END;