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.2.12010000.2 2008/09/12 05:51:31 mmaiya 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 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 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 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 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 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 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 1782: END CS_KB_SOLUTION_PVT;

1778: ROLLBACK TO CS_KB_ULOCK_SOLUTION;
1779: END unlock_solution;
1780: -- End Bugfix 7117546
1781:
1782: END CS_KB_SOLUTION_PVT;