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 394: FND_FILE.PUT_LINE(FND_FILE.LOG,

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

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

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

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

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

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

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

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

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);
1164: EXCEPTION
1165: WHEN others THEN
1166: NULL;
1167: END;

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

1166: NULL;
1167: END;
1168: WHEN create_index_error THEN
1169: BEGIN
1170: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);
1171: EXCEPTION
1172: WHEN others THEN
1173: NULL;
1174: END;

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

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

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

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);
1250: EXCEPTION
1251: WHEN others THEN
1252: NULL;
1253: END;

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

1252: NULL;
1253: END;
1254: WHEN create_index_error THEN
1255: BEGIN
1256: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);
1257: EXCEPTION
1258: WHEN others THEN
1259: NULL;
1260: END;

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

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
1268: WHEN others THEN
1269: NULL;
1270: END;

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

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);
1333: EXCEPTION
1334: WHEN others THEN
1335: NULL;
1336: END;

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

1335: NULL;
1336: END;
1337: WHEN create_index_error THEN
1338: BEGIN
1339: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);
1340: EXCEPTION
1341: WHEN others THEN
1342: NULL;
1343: END;

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

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
1351: WHEN others THEN
1352: NULL;
1353: END;

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

1562: ROLLBACK TO Update_Usage_Score_Sav;
1563: retcode := 2;
1564: errbuf := sqlerrm;
1565: BEGIN
1566: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);
1567: EXCEPTION
1568: WHEN others THEN
1569: NULL;
1570: END;

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

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
1624: WHEN others THEN
1625: NULL;
1626: END;

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

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
1718: WHEN others THEN
1719: NULL;
1720: END;