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 658: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

654: CS_KB_SYNC_INDEX_PKG.Mark_Idxs_on_Pub_Soln( p_set_number );
655:
656: -- Populate the Solution Content cache
657: CS_KB_SYNC_INDEX_PKG.Populate_Soln_Content_Cache (l_new_set_id);
658: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
659: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'cs.plsql.cskvsolb.pls',
660: 'Before Pop_Soln_Attach_Content_Cache - ');
661: END IF;
662: CS_KB_SYNC_INDEX_PKG.Pop_Soln_Attach_Content_Cache (l_new_set_id);

Line 659: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'cs.plsql.cskvsolb.pls',

655:
656: -- Populate the Solution Content cache
657: CS_KB_SYNC_INDEX_PKG.Populate_Soln_Content_Cache (l_new_set_id);
658: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
659: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'cs.plsql.cskvsolb.pls',
660: 'Before Pop_Soln_Attach_Content_Cache - ');
661: END IF;
662: CS_KB_SYNC_INDEX_PKG.Pop_Soln_Attach_Content_Cache (l_new_set_id);
663: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

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

659: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'cs.plsql.cskvsolb.pls',
660: 'Before Pop_Soln_Attach_Content_Cache - ');
661: END IF;
662: CS_KB_SYNC_INDEX_PKG.Pop_Soln_Attach_Content_Cache (l_new_set_id);
663: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
664: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'cs.plsql.cskvsolb.pls',
665: 'After Pop_Soln_Attach_Content_Cache - ');
666: END IF;
667:

Line 664: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'cs.plsql.cskvsolb.pls',

660: 'Before Pop_Soln_Attach_Content_Cache - ');
661: END IF;
662: CS_KB_SYNC_INDEX_PKG.Pop_Soln_Attach_Content_Cache (l_new_set_id);
663: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
664: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'cs.plsql.cskvsolb.pls',
665: 'After Pop_Soln_Attach_Content_Cache - ');
666: END IF;
667:
668: ELSIF (p_status = 'OBS') THEN

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

1223: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1224: X_RETURN := -1;
1225: SAVEPOINT START_OF_SUBMIT;
1226:
1227: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1228: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'csk.plsql.CS_KB_SOLUTION_PVT.Submit_Solution.Start',
1229: 'Submit Solution started for set id- '||P_SET_ID );
1230: END IF;
1231:

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

1224: X_RETURN := -1;
1225: SAVEPOINT START_OF_SUBMIT;
1226:
1227: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1228: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'csk.plsql.CS_KB_SOLUTION_PVT.Submit_Solution.Start',
1229: 'Submit Solution started for set id- '||P_SET_ID );
1230: END IF;
1231:
1232: -- Firstly perform duplicate statement checking against exisiting

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

1265: END IF;
1266:
1267: END LOOP;
1268:
1269: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1270: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'csk.plsql.CS_KB_SOLUTION_PVT.Submit_Solution',
1271: 'After Dup Check before Start_Wf - '||P_SET_ID );
1272: END IF;
1273:

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

1266:
1267: END LOOP;
1268:
1269: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1270: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'csk.plsql.CS_KB_SOLUTION_PVT.Submit_Solution',
1271: 'After Dup Check before Start_Wf - '||P_SET_ID );
1272: END IF;
1273:
1274: -- Start_Wf is an Internal api that performs the following:

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

1299: END IF;
1300:
1301: X_RETURN := l_results;
1302:
1303: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1304: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'csk.plsql.CS_KB_SOLUTION_PVT.Submit_Solution.Finish',
1305: 'Submit Solution finished for set id- '||P_SET_ID );
1306: END IF;
1307:

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

1300:
1301: X_RETURN := l_results;
1302:
1303: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1304: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'csk.plsql.CS_KB_SOLUTION_PVT.Submit_Solution.Finish',
1305: 'Submit Solution finished for set id- '||P_SET_ID );
1306: END IF;
1307:
1308: EXCEPTION

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

1309: WHEN OTHERS THEN
1310: X_RETURN := -1;
1311: ROLLBACK TO START_OF_SUBMIT;
1312:
1313: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1314: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'csk.plsql.CS_KB_SOLUTION_PVT.Submit_Solution.Unexpected',
1315: 'Unexpected Exception for set id- '||P_SET_ID||' '||substrb(sqlerrm,1,200) );
1316: END IF;
1317:

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

1310: X_RETURN := -1;
1311: ROLLBACK TO START_OF_SUBMIT;
1312:
1313: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1314: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'csk.plsql.CS_KB_SOLUTION_PVT.Submit_Solution.Unexpected',
1315: 'Unexpected Exception for set id- '||P_SET_ID||' '||substrb(sqlerrm,1,200) );
1316: END IF;
1317:
1318: FND_MSG_PUB.initialize;

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

1599:
1600: BEGIN
1601: SAVEPOINT MOVE_SOLUTIONS;
1602: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1603: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1604: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'csk.plsql.CS_KB_SOLUTION_PVT.Move_Solutions.begin',
1605: 'User='||fnd_global.user_id);
1606: END IF;
1607:

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

1600: BEGIN
1601: SAVEPOINT MOVE_SOLUTIONS;
1602: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1603: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1604: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'csk.plsql.CS_KB_SOLUTION_PVT.Move_Solutions.begin',
1605: 'User='||fnd_global.user_id);
1606: END IF;
1607:
1608: --Validate categories' id

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

1675:
1676: --Return.
1677: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1678:
1679: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1680: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'csk.plsql.CS_KB_SOLUTION_PVT.Move_Solutions.begin',
1681: 'Status='||X_RETURN_STATUS);
1682: END IF;
1683:

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

1676: --Return.
1677: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1678:
1679: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1680: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'csk.plsql.CS_KB_SOLUTION_PVT.Move_Solutions.begin',
1681: 'Status='||X_RETURN_STATUS);
1682: END IF;
1683:
1684: if fnd_api.to_boolean( p_commit ) then

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

1687:
1688: EXCEPTION
1689: WHEN INVALID_CATEGORY_ID 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.validate_parameters',
1693: 'Invalid category 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.validate_parameters',

1688: EXCEPTION
1689: WHEN INVALID_CATEGORY_ID 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.validate_parameters',
1693: 'Invalid category ID:'||l_cat_id);
1694: END IF;
1695:
1696: FND_MSG_PUB.initialize;

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

1701: p_count => X_MSG_COUNT,
1702: p_data => X_MSG_DATA);
1703: WHEN INVALID_SET_CATEGORY_LINK THEN
1704: ROLLBACK TO MOVE_SOLUTIONS;
1705: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1706: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csk.plsql.CS_KB_SECURITY_PVT.Move_Solutions.update_link',
1707: 'Invalid link (set_id,category_id): ('||l_set_id||','||l_cat_id||')');
1708: END IF;
1709:

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

1702: p_data => X_MSG_DATA);
1703: WHEN INVALID_SET_CATEGORY_LINK THEN
1704: ROLLBACK TO MOVE_SOLUTIONS;
1705: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1706: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csk.plsql.CS_KB_SECURITY_PVT.Move_Solutions.update_link',
1707: 'Invalid link (set_id,category_id): ('||l_set_id||','||l_cat_id||')');
1708: END IF;
1709:
1710: FND_MSG_PUB.initialize;