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

Line 1213: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1209: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1210: X_RETURN := -1;
1211: SAVEPOINT START_OF_SUBMIT;
1212:
1213: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1214: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'csk.plsql.CS_KB_SOLUTION_PVT.Submit_Solution.Start',
1215: 'Submit Solution started for set id- '||P_SET_ID );
1216: END IF;
1217:

Line 1214: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'csk.plsql.CS_KB_SOLUTION_PVT.Submit_Solution.Start',

1210: X_RETURN := -1;
1211: SAVEPOINT START_OF_SUBMIT;
1212:
1213: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1214: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'csk.plsql.CS_KB_SOLUTION_PVT.Submit_Solution.Start',
1215: 'Submit Solution started for set id- '||P_SET_ID );
1216: END IF;
1217:
1218: -- Firstly perform duplicate statement checking against exisiting

Line 1255: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1251: END IF;
1252:
1253: END LOOP;
1254:
1255: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1256: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'csk.plsql.CS_KB_SOLUTION_PVT.Submit_Solution',
1257: 'After Dup Check before Start_Wf - '||P_SET_ID );
1258: END IF;
1259:

Line 1256: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'csk.plsql.CS_KB_SOLUTION_PVT.Submit_Solution',

1252:
1253: END LOOP;
1254:
1255: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1256: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'csk.plsql.CS_KB_SOLUTION_PVT.Submit_Solution',
1257: 'After Dup Check before Start_Wf - '||P_SET_ID );
1258: END IF;
1259:
1260: -- Start_Wf is an Internal api that performs the following:

Line 1289: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1285: END IF;
1286:
1287: X_RETURN := l_results;
1288:
1289: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1290: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'csk.plsql.CS_KB_SOLUTION_PVT.Submit_Solution.Finish',
1291: 'Submit Solution finished for set id- '||P_SET_ID );
1292: END IF;
1293:

Line 1290: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'csk.plsql.CS_KB_SOLUTION_PVT.Submit_Solution.Finish',

1286:
1287: X_RETURN := l_results;
1288:
1289: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1290: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'csk.plsql.CS_KB_SOLUTION_PVT.Submit_Solution.Finish',
1291: 'Submit Solution finished for set id- '||P_SET_ID );
1292: END IF;
1293:
1294: EXCEPTION

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

1295: WHEN OTHERS THEN
1296: X_RETURN := -1;
1297: ROLLBACK TO START_OF_SUBMIT;
1298:
1299: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1300: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'csk.plsql.CS_KB_SOLUTION_PVT.Submit_Solution.Unexpected',
1301: 'Unexpected Exception for set id- '||P_SET_ID||' '||substrb(sqlerrm,1,200) );
1302: END IF;
1303:

Line 1300: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'csk.plsql.CS_KB_SOLUTION_PVT.Submit_Solution.Unexpected',

1296: X_RETURN := -1;
1297: ROLLBACK TO START_OF_SUBMIT;
1298:
1299: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1300: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'csk.plsql.CS_KB_SOLUTION_PVT.Submit_Solution.Unexpected',
1301: 'Unexpected Exception for set id- '||P_SET_ID||' '||substrb(sqlerrm,1,200) );
1302: END IF;
1303:
1304: FND_MSG_PUB.initialize;

Line 1589: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1585:
1586: BEGIN
1587: SAVEPOINT MOVE_SOLUTIONS;
1588: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1589: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1590: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'csk.plsql.CS_KB_SOLUTION_PVT.Move_Solutions.begin',
1591: 'User='||fnd_global.user_id);
1592: END IF;
1593:

Line 1590: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'csk.plsql.CS_KB_SOLUTION_PVT.Move_Solutions.begin',

1586: BEGIN
1587: SAVEPOINT MOVE_SOLUTIONS;
1588: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1589: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1590: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'csk.plsql.CS_KB_SOLUTION_PVT.Move_Solutions.begin',
1591: 'User='||fnd_global.user_id);
1592: END IF;
1593:
1594: --Validate categories' id

Line 1665: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1661:
1662: --Return.
1663: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1664:
1665: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1666: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'csk.plsql.CS_KB_SOLUTION_PVT.Move_Solutions.begin',
1667: 'Status='||X_RETURN_STATUS);
1668: END IF;
1669:

Line 1666: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'csk.plsql.CS_KB_SOLUTION_PVT.Move_Solutions.begin',

1662: --Return.
1663: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1664:
1665: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1666: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'csk.plsql.CS_KB_SOLUTION_PVT.Move_Solutions.begin',
1667: 'Status='||X_RETURN_STATUS);
1668: END IF;
1669:
1670: if fnd_api.to_boolean( p_commit ) then

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

1673:
1674: EXCEPTION
1675: WHEN INVALID_CATEGORY_ID THEN
1676: ROLLBACK TO MOVE_SOLUTIONS;
1677: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1678: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csk.plsql.CS_KB_SECURITY_PVT.Move_Solutions.validate_parameters',
1679: 'Invalid category ID:'||l_cat_id);
1680: END IF;
1681:

Line 1678: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csk.plsql.CS_KB_SECURITY_PVT.Move_Solutions.validate_parameters',

1674: EXCEPTION
1675: WHEN INVALID_CATEGORY_ID THEN
1676: ROLLBACK TO MOVE_SOLUTIONS;
1677: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1678: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csk.plsql.CS_KB_SECURITY_PVT.Move_Solutions.validate_parameters',
1679: 'Invalid category ID:'||l_cat_id);
1680: END IF;
1681:
1682: FND_MSG_PUB.initialize;

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

1687: p_count => X_MSG_COUNT,
1688: p_data => X_MSG_DATA);
1689: WHEN INVALID_SET_CATEGORY_LINK THEN
1690: ROLLBACK TO MOVE_SOLUTIONS;
1691: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1692: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csk.plsql.CS_KB_SECURITY_PVT.Move_Solutions.update_link',
1693: 'Invalid link (set_id,category_id): ('||l_set_id||','||l_cat_id||')');
1694: END IF;
1695:

Line 1692: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csk.plsql.CS_KB_SECURITY_PVT.Move_Solutions.update_link',

1688: p_data => X_MSG_DATA);
1689: WHEN INVALID_SET_CATEGORY_LINK THEN
1690: ROLLBACK TO MOVE_SOLUTIONS;
1691: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1692: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csk.plsql.CS_KB_SECURITY_PVT.Move_Solutions.update_link',
1693: 'Invalid link (set_id,category_id): ('||l_set_id||','||l_cat_id||')');
1694: END IF;
1695:
1696: FND_MSG_PUB.initialize;