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_ELEMENTS_AUDIT_PKG dependencies on FND_LOG

Line 1112: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1108:
1109: SAVEPOINT START_GSU;
1110:
1111:
1112: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1113: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csk.plsql.CS_KB_ELEMENTS_AUDIT_PVT.Update_Statement_Admin.Start',
1114: 'Started Global Statement Update');
1115: END IF;
1116:

Line 1113: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csk.plsql.CS_KB_ELEMENTS_AUDIT_PVT.Update_Statement_Admin.Start',

1109: SAVEPOINT START_GSU;
1110:
1111:
1112: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1113: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csk.plsql.CS_KB_ELEMENTS_AUDIT_PVT.Update_Statement_Admin.Start',
1114: 'Started Global Statement Update');
1115: END IF;
1116:
1117: -- Is the updated Statement now a Duplicate ?

Line 1132: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1128: IF l_dup_id <> 0 THEN
1129: -- A Duplicate Statement Exists for this update
1130: -- Update All Solutions within the Current Category Group to be
1131: -- associated to the Duplicate (Already existing Statement).
1132: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1133: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csk.plsql.CS_KB_ELEMENTS_AUDIT_PVT.Update_Statement_Admin',
1134: 'A Duplicate Statement Exists for this update - UPD with Current CG');
1135: END IF;
1136:

Line 1133: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csk.plsql.CS_KB_ELEMENTS_AUDIT_PVT.Update_Statement_Admin',

1129: -- A Duplicate Statement Exists for this update
1130: -- Update All Solutions within the Current Category Group to be
1131: -- associated to the Duplicate (Already existing Statement).
1132: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1133: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csk.plsql.CS_KB_ELEMENTS_AUDIT_PVT.Update_Statement_Admin',
1134: 'A Duplicate Statement Exists for this update - UPD with Current CG');
1135: END IF;
1136:
1137: -- Bug 3576066 moved to above upd + delete

Line 1218: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1214: CLOSE Get_Other_Stmt_Attributes;
1215:
1216: IF l_cg_usage_count = 0 THEN
1217: -- If Yes (count=0) - Statement only used in current Category Group - Update Statement as normal
1218: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1219: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csk.plsql.CS_KB_ELEMENTS_AUDIT_PVT.Update_Statement_Admin',
1220: 'Statement only used in current Category Group - Update Statement');
1221: END IF;
1222:

Line 1219: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csk.plsql.CS_KB_ELEMENTS_AUDIT_PVT.Update_Statement_Admin',

1215:
1216: IF l_cg_usage_count = 0 THEN
1217: -- If Yes (count=0) - Statement only used in current Category Group - Update Statement as normal
1218: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1219: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csk.plsql.CS_KB_ELEMENTS_AUDIT_PVT.Update_Statement_Admin',
1220: 'Statement only used in current Category Group - Update Statement');
1221: END IF;
1222:
1223: Update_Statement( p_element_id => P_ELEMENT_ID,

Line 1274: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1270:
1271: ELSE -- Statement is shared across multiple Category Groups
1272: -- + Statement is not being updated Duplicate, therefore
1273: -- create a new Statement and associate within current CG
1274: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1275: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csk.plsql.CS_KB_ELEMENTS_AUDIT_PVT.Update_Statement_Admin',
1276: 'Statement is shared across multiple Category Groups - Create New Stmt');
1277: END IF;
1278:

Line 1275: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csk.plsql.CS_KB_ELEMENTS_AUDIT_PVT.Update_Statement_Admin',

1271: ELSE -- Statement is shared across multiple Category Groups
1272: -- + Statement is not being updated Duplicate, therefore
1273: -- create a new Statement and associate within current CG
1274: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1275: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csk.plsql.CS_KB_ELEMENTS_AUDIT_PVT.Update_Statement_Admin',
1276: 'Statement is shared across multiple Category Groups - Create New Stmt');
1277: END IF;
1278:
1279: -- Before creating a New Statement check that the Stmt is not being updated

Line 1354: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1350:
1351: END IF;
1352:
1353: ELSE
1354: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1355: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csk.plsql.CS_KB_ELEMENTS_AUDIT_PVT.Update_Statement_Admin',
1356: 'Stmt is dup of the original - NO new Stmt created.');
1357: END IF;
1358: X_RETURN_ELEMENT := P_ELEMENT_ID;

Line 1355: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csk.plsql.CS_KB_ELEMENTS_AUDIT_PVT.Update_Statement_Admin',

1351: END IF;
1352:
1353: ELSE
1354: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1355: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csk.plsql.CS_KB_ELEMENTS_AUDIT_PVT.Update_Statement_Admin',
1356: 'Stmt is dup of the original - NO new Stmt created.');
1357: END IF;
1358: X_RETURN_ELEMENT := P_ELEMENT_ID;
1359: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

Line 1367: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1363:
1364: END IF; -- Dup Check
1365:
1366:
1367: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1368: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csk.plsql.CS_KB_ELEMENTS_AUDIT_PVT.Update_Statement_Admin.End',
1369: 'Finished Global Statement Update - '||X_RETURN_STATUS||'-'||X_RETURN_ELEMENT );
1370: END IF;
1371:

Line 1368: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csk.plsql.CS_KB_ELEMENTS_AUDIT_PVT.Update_Statement_Admin.End',

1364: END IF; -- Dup Check
1365:
1366:
1367: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1368: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csk.plsql.CS_KB_ELEMENTS_AUDIT_PVT.Update_Statement_Admin.End',
1369: 'Finished Global Statement Update - '||X_RETURN_STATUS||'-'||X_RETURN_ELEMENT );
1370: END IF;
1371:
1372: EXCEPTION

Line 1377: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1373: WHEN OTHERS THEN
1374:
1375: ROLLBACK TO START_GSU;
1376:
1377: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1378: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'csk.plsql.CS_KB_ELEMENTS_AUDIT_PVT.Update_Statement_Admin.UNEX',
1379: 'Unexpected Exception-'||substrb(sqlerrm,1,200) );
1380: END IF;
1381:

Line 1378: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'csk.plsql.CS_KB_ELEMENTS_AUDIT_PVT.Update_Statement_Admin.UNEX',

1374:
1375: ROLLBACK TO START_GSU;
1376:
1377: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1378: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'csk.plsql.CS_KB_ELEMENTS_AUDIT_PVT.Update_Statement_Admin.UNEX',
1379: 'Unexpected Exception-'||substrb(sqlerrm,1,200) );
1380: END IF;
1381:
1382: X_RETURN_ELEMENT := NULL;