APPS.CS_KB_SOLUTION_PVT dependencies on CS_KB_SOLUTION_PVT

Line 1: PACKAGE BODY CS_KB_SOLUTION_PVT AS

1: PACKAGE BODY CS_KB_SOLUTION_PVT AS
2: /* $Header: cskvsolb.pls 120.5 2011/07/22 10:41:44 isugavan ship $ */
3: /*=======================================================================+
4: | Copyright (c) 2003 Oracle Corporation Redwood Shores, California, USA|
5: | All rights reserved. |

Line 9: | PL/SQL body for package: CS_KB_SOLUTION_PVT

5: | All rights reserved. |
6: +=======================================================================+
7: | FILENAME cskvsolb.pls
8: | DESCRIPTION
9: | PL/SQL body for package: CS_KB_SOLUTION_PVT
10: | This contains Private api's for a Solution
11: |
12: | History:
13: | 19 Aug 03 Matt Kettle Created

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 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 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 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 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 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 1796: END CS_KB_SOLUTION_PVT;

1792: ROLLBACK TO CS_KB_ULOCK_SOLUTION;
1793: END unlock_solution;
1794: -- End Bugfix 7117546
1795:
1796: END CS_KB_SOLUTION_PVT;