APPS.CS_KB_SECURITY_PVT dependencies on FND_LOG

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

179:
180: SAVEPOINT Create_Visibility_PVT;
181: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
182:
183: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
184: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_VISIBILITY.begin',
185: 'User='||l_current_user);
186: END IF;
187:

Line 184: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_VISIBILITY.begin',

180: SAVEPOINT Create_Visibility_PVT;
181: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
182:
183: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
184: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_VISIBILITY.begin',
185: 'User='||l_current_user);
186: END IF;
187:
188: -- Validate Required Parameters have been passed into api

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

304: --dbms_output.put_line('Insert Check-'||l_check);
305: IF l_check <> 1 THEN
306: RAISE INSERT_FAILED;
307: ELSE
308: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
309: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_VISIBILITY.insert',
310: 'Visibility Insert Successfull='||l_seq);
311: END IF;
312: --X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

Line 309: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_VISIBILITY.insert',

305: IF l_check <> 1 THEN
306: RAISE INSERT_FAILED;
307: ELSE
308: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
309: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_VISIBILITY.insert',
310: 'Visibility Insert Successfull='||l_seq);
311: END IF;
312: --X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
313:

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

330: END IF; --Validate duplicate Visibility Name
331:
332: END IF; -- Validate Required Parameters Passed
333:
334: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
335: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_VISIBILITY.end',
336: 'Status='||X_RETURN_STATUS);
337: END IF;
338:

Line 335: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_VISIBILITY.end',

331:
332: END IF; -- Validate Required Parameters Passed
333:
334: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
335: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_VISIBILITY.end',
336: 'Status='||X_RETURN_STATUS);
337: END IF;
338:
339:

Line 342: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

338:
339:
340: EXCEPTION
341: WHEN INVALID_IN_PARAMETERS THEN
342: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
343: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_VISIBILITY.invparam',
344: 'P_NAME='||P_NAME||
345: 'P_ADD_BEFORE_POSITION='||P_ADD_BEFORE_VISIBILITY||
346: 'P_ADD_AFTER_POSITION='||P_ADD_AFTER_VISIBILITY);

Line 343: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_VISIBILITY.invparam',

339:
340: EXCEPTION
341: WHEN INVALID_IN_PARAMETERS THEN
342: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
343: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_VISIBILITY.invparam',
344: 'P_NAME='||P_NAME||
345: 'P_ADD_BEFORE_POSITION='||P_ADD_BEFORE_VISIBILITY||
346: 'P_ADD_AFTER_POSITION='||P_ADD_AFTER_VISIBILITY);
347: END IF;

Line 358: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

354: p_data => X_MSG_DATA);
355:
356: WHEN INSERT_FAILED THEN
357: ROLLBACK TO Create_Visibility_PVT;
358: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
359: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_VISIBILITY.insertcheck',
360: 'Insert Row has failed='||l_check);
361: END IF;
362: FND_MSG_PUB.initialize;

Line 359: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_VISIBILITY.insertcheck',

355:
356: WHEN INSERT_FAILED THEN
357: ROLLBACK TO Create_Visibility_PVT;
358: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
359: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_VISIBILITY.insertcheck',
360: 'Insert Row has failed='||l_check);
361: END IF;
362: FND_MSG_PUB.initialize;
363: FND_MESSAGE.set_name('CS', 'CS_KB_C_CREATE_ERR');

Line 371: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

367: p_count => X_MSG_COUNT,
368: p_data => X_MSG_DATA);
369:
370: WHEN DUPLICATE_VISIBILITY THEN
371: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
372: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_VISIBILITY.dupcheck',
373: 'Visibility Name is a Duplicate='||P_NAME);
374: END IF;
375: FND_MSG_PUB.initialize;

Line 372: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_VISIBILITY.dupcheck',

368: p_data => X_MSG_DATA);
369:
370: WHEN DUPLICATE_VISIBILITY THEN
371: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
372: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_VISIBILITY.dupcheck',
373: 'Visibility Name is a Duplicate='||P_NAME);
374: END IF;
375: FND_MSG_PUB.initialize;
376: FND_MESSAGE.set_name('CS', 'CS_KB_VIS_DUP_ERROR');

Line 385: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

381: p_data => X_MSG_DATA);
382:
383: WHEN INDEX_SYNC_FAILED THEN
384: ROLLBACK TO Create_Visibility_PVT;
385: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
386: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_VISIBILITY.indexsync',
387: 'Index Sync failed='||l_request_id);
388: END IF;
389: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

Line 386: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_VISIBILITY.indexsync',

382:
383: WHEN INDEX_SYNC_FAILED THEN
384: ROLLBACK TO Create_Visibility_PVT;
385: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
386: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_VISIBILITY.indexsync',
387: 'Index Sync failed='||l_request_id);
388: END IF;
389: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
390: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

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

392: p_data => X_MSG_DATA);
393:
394: WHEN OTHERS THEN
395: ROLLBACK TO Create_Visibility_PVT;
396: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
397: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_VISIBILITY.UNEXPECTED',
398: ' Error= '||sqlerrm);
399: END IF;
400: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');

Line 397: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_VISIBILITY.UNEXPECTED',

393:
394: WHEN OTHERS THEN
395: ROLLBACK TO Create_Visibility_PVT;
396: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
397: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_VISIBILITY.UNEXPECTED',
398: ' Error= '||sqlerrm);
399: END IF;
400: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
401: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

479:
480: SAVEPOINT Update_Visibility_PVT;
481: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
482:
483: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
484: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_KB_SECURITY_PVT.UPDATE_VISIBILITY.begin',
485: 'User='||l_current_user);
486: END IF;
487:

Line 484: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_KB_SECURITY_PVT.UPDATE_VISIBILITY.begin',

480: SAVEPOINT Update_Visibility_PVT;
481: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
482:
483: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
484: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_KB_SECURITY_PVT.UPDATE_VISIBILITY.begin',
485: 'User='||l_current_user);
486: END IF;
487:
488: -- Validate Required Parameters have been passed into api

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

536:
537: IF l_check <> 1 THEN
538: RAISE UPDATE_FAILED;
539: ELSE
540: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
541: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'cs.plsql.CS_KB_SECURITY_PVT.UPDATE_VISIBILITY.update',
542: 'Visibility Update Successfull='||P_VISIBILITY_ID);
543: END IF;
544:

Line 541: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'cs.plsql.CS_KB_SECURITY_PVT.UPDATE_VISIBILITY.update',

537: IF l_check <> 1 THEN
538: RAISE UPDATE_FAILED;
539: ELSE
540: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
541: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'cs.plsql.CS_KB_SECURITY_PVT.UPDATE_VISIBILITY.update',
542: 'Visibility Update Successfull='||P_VISIBILITY_ID);
543: END IF;
544:
545: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

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

548: END IF; --Validate duplicate Visibility Name
549:
550: END IF; -- Validate Required Parameters Passed
551:
552: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
553: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_VISIBILITY.end',
554: 'Status='||X_RETURN_STATUS);
555: END IF;
556:

Line 553: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_VISIBILITY.end',

549:
550: END IF; -- Validate Required Parameters Passed
551:
552: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
553: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_VISIBILITY.end',
554: 'Status='||X_RETURN_STATUS);
555: END IF;
556:
557:

Line 560: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

556:
557:
558: EXCEPTION
559: WHEN INVALID_IN_PARAMETERS THEN
560: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
561: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.UPDATE_VISIBILITY.invparam',
562: 'P_NAME='||P_NAME||
563: 'P_VISIBILITY='||P_VISIBILITY_ID);
564: END IF;

Line 561: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.UPDATE_VISIBILITY.invparam',

557:
558: EXCEPTION
559: WHEN INVALID_IN_PARAMETERS THEN
560: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
561: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.UPDATE_VISIBILITY.invparam',
562: 'P_NAME='||P_NAME||
563: 'P_VISIBILITY='||P_VISIBILITY_ID);
564: END IF;
565: FND_MSG_PUB.initialize;

Line 574: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

570: p_count => X_MSG_COUNT,
571: p_data => X_MSG_DATA);
572:
573: WHEN UPDATE_FAILED THEN
574: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
575: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.UPDATE_VISIBILITY.updcheck',
576: 'Update Row has failed='||l_check);
577: END IF;
578: FND_MSG_PUB.initialize;

Line 575: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.UPDATE_VISIBILITY.updcheck',

571: p_data => X_MSG_DATA);
572:
573: WHEN UPDATE_FAILED THEN
574: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
575: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.UPDATE_VISIBILITY.updcheck',
576: 'Update Row has failed='||l_check);
577: END IF;
578: FND_MSG_PUB.initialize;
579: FND_MESSAGE.set_name('CS', 'CS_KB_C_UPDATE_ERR');

Line 587: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

583: p_count => X_MSG_COUNT,
584: p_data => X_MSG_DATA);
585:
586: WHEN DUPLICATE_VISIBILITY THEN
587: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
588: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.UPDATE_VISIBILITY.dupcheck',
589: 'Visibility Name is a Duplicate='||P_NAME);
590: END IF;
591: FND_MSG_PUB.initialize;

Line 588: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.UPDATE_VISIBILITY.dupcheck',

584: p_data => X_MSG_DATA);
585:
586: WHEN DUPLICATE_VISIBILITY THEN
587: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
588: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.UPDATE_VISIBILITY.dupcheck',
589: 'Visibility Name is a Duplicate='||P_NAME);
590: END IF;
591: FND_MSG_PUB.initialize;
592: FND_MESSAGE.set_name('CS', 'CS_KB_VIS_DUP_ERROR');

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

597: p_data => X_MSG_DATA);
598:
599: WHEN OTHERS THEN
600: ROLLBACK TO Update_Visibility_PVT;
601: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
602: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'cs.plsql.CS_KB_SECURITY_PVT.UPDATE_VISIBILITY.UNEXPECTED',
603: ' Error= '||sqlerrm);
604: END IF;
605: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');

Line 602: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'cs.plsql.CS_KB_SECURITY_PVT.UPDATE_VISIBILITY.UNEXPECTED',

598:
599: WHEN OTHERS THEN
600: ROLLBACK TO Update_Visibility_PVT;
601: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
602: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'cs.plsql.CS_KB_SECURITY_PVT.UPDATE_VISIBILITY.UNEXPECTED',
603: ' Error= '||sqlerrm);
604: END IF;
605: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

680: BEGIN
681: SAVEPOINT Delete_Visibility_PVT;
682: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
683:
684: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
685: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_VISIBILITY.begin',
686: 'User='||l_current_user);
687: END IF;
688:

Line 685: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_VISIBILITY.begin',

681: SAVEPOINT Delete_Visibility_PVT;
682: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
683:
684: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
685: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_VISIBILITY.begin',
686: 'User='||l_current_user);
687: END IF;
688:
689: OPEN CHECK_VISIBILITY;

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

745: END IF;
746:
747: END IF; -- Valid Param Check
748:
749: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
750: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_VISIBILITY.end',
751: 'Status='||X_RETURN_STATUS);
752: END IF;
753:

Line 750: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_VISIBILITY.end',

746:
747: END IF; -- Valid Param Check
748:
749: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
750: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_VISIBILITY.end',
751: 'Status='||X_RETURN_STATUS);
752: END IF;
753:
754: EXCEPTION

Line 756: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

752: END IF;
753:
754: EXCEPTION
755: WHEN INVALID_IN_PARAMETERS THEN
756: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
757: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_VISIBILITY.invparam',
758: 'P_VISIBILITY_ID='||P_VISIBILITY_ID);
759: END IF;
760: FND_MSG_PUB.initialize;

Line 757: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_VISIBILITY.invparam',

753:
754: EXCEPTION
755: WHEN INVALID_IN_PARAMETERS THEN
756: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
757: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_VISIBILITY.invparam',
758: 'P_VISIBILITY_ID='||P_VISIBILITY_ID);
759: END IF;
760: FND_MSG_PUB.initialize;
761: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_PARAM');

Line 768: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

764: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
765: p_count => X_MSG_COUNT,
766: p_data => X_MSG_DATA);
767: WHEN UNABLE_TO_DELETE_VIS THEN
768: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
769: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_VISIBILITY.invdel',
770: 'P_VISIBILITY_ID='||P_VISIBILITY_ID);
771: END IF;
772: FND_MSG_PUB.initialize;

Line 769: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_VISIBILITY.invdel',

765: p_count => X_MSG_COUNT,
766: p_data => X_MSG_DATA);
767: WHEN UNABLE_TO_DELETE_VIS THEN
768: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
769: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_VISIBILITY.invdel',
770: 'P_VISIBILITY_ID='||P_VISIBILITY_ID);
771: END IF;
772: FND_MSG_PUB.initialize;
773: FND_MESSAGE.set_name('CS', 'CS_KB_VIS_INV_DEL');

Line 781: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

777: p_count => X_MSG_COUNT,
778: p_data => X_MSG_DATA);
779: WHEN DELETE_FAILED THEN
780: ROLLBACK TO Delete_Visibility_PVT;
781: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
782: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_VISIBILITY.deletefail',
783: 'Delete Row has failed='||l_vis_count);
784: END IF;
785: FND_MSG_PUB.initialize;

Line 782: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_VISIBILITY.deletefail',

778: p_data => X_MSG_DATA);
779: WHEN DELETE_FAILED THEN
780: ROLLBACK TO Delete_Visibility_PVT;
781: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
782: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_VISIBILITY.deletefail',
783: 'Delete Row has failed='||l_vis_count);
784: END IF;
785: FND_MSG_PUB.initialize;
786: FND_MESSAGE.set_name('CS', 'CS_KB_C_DELETE_ERR');

Line 794: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

790: p_count => X_MSG_COUNT,
791: p_data => X_MSG_DATA);
792: WHEN INDEX_SYNC_FAILED THEN
793: ROLLBACK TO Delete_Visibility_PVT;
794: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
795: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_VISIBILITY.indexsync',
796: 'Index Sync failed='||l_request_id);
797: END IF;
798: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

Line 795: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_VISIBILITY.indexsync',

791: p_data => X_MSG_DATA);
792: WHEN INDEX_SYNC_FAILED THEN
793: ROLLBACK TO Delete_Visibility_PVT;
794: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
795: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_VISIBILITY.indexsync',
796: 'Index Sync failed='||l_request_id);
797: END IF;
798: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
799: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

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

801: p_data => X_MSG_DATA);
802:
803: WHEN OTHERS THEN
804: ROLLBACK TO Delete_Visibility_PVT;
805: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
806: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_VISIBILITY.UNEXPECTED',
807: ' Error= '||sqlerrm);
808: END IF;
809: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');

Line 806: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_VISIBILITY.UNEXPECTED',

802:
803: WHEN OTHERS THEN
804: ROLLBACK TO Delete_Visibility_PVT;
805: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
806: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_VISIBILITY.UNEXPECTED',
807: ' Error= '||sqlerrm);
808: END IF;
809: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
810: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

945:
946: SAVEPOINT Create_Category_Group_PVT;
947: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
948:
949: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
950: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_CATEGORY_GROUP.begin',
951: 'User='||l_current_user);
952: END IF;
953:

Line 950: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_CATEGORY_GROUP.begin',

946: SAVEPOINT Create_Category_Group_PVT;
947: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
948:
949: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
950: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_CATEGORY_GROUP.begin',
951: 'User='||l_current_user);
952: END IF;
953:
954: -- Validate Required Parameters have been passed into api

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

1004: --dbms_output.put_line('Insert Check-'||l_check);
1005: IF l_check <> 1 THEN
1006: RAISE INSERT_FAILED;
1007: ELSE
1008: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1009: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_CATEGORY_GROUP.insert',
1010: 'Visibility Insert Successfull='||l_seq);
1011: END IF;
1012:

Line 1009: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_CATEGORY_GROUP.insert',

1005: IF l_check <> 1 THEN
1006: RAISE INSERT_FAILED;
1007: ELSE
1008: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1009: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_CATEGORY_GROUP.insert',
1010: 'Visibility Insert Successfull='||l_seq);
1011: END IF;
1012:
1013: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

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

1014: END IF; -- Insert Successful Check
1015: END IF; -- Check Name Dup
1016: END IF;
1017:
1018: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1019: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_CATEGORY_GROUP.end',
1020: 'Status='||X_RETURN_STATUS);
1021: END IF;
1022:

Line 1019: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_CATEGORY_GROUP.end',

1015: END IF; -- Check Name Dup
1016: END IF;
1017:
1018: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1019: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_CATEGORY_GROUP.end',
1020: 'Status='||X_RETURN_STATUS);
1021: END IF;
1022:
1023: EXCEPTION

Line 1025: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1021: END IF;
1022:
1023: EXCEPTION
1024: WHEN INVALID_IN_PARAMETERS THEN
1025: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1026: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_CATEGORY_GROUP.invparam',
1027: 'P_NAME='||P_NAME||
1028: 'P_CATEGORY_GROUP_ID='||P_CATEGORY_GROUP_ID);
1029: END IF;

Line 1026: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_CATEGORY_GROUP.invparam',

1022:
1023: EXCEPTION
1024: WHEN INVALID_IN_PARAMETERS THEN
1025: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1026: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_CATEGORY_GROUP.invparam',
1027: 'P_NAME='||P_NAME||
1028: 'P_CATEGORY_GROUP_ID='||P_CATEGORY_GROUP_ID);
1029: END IF;
1030: FND_MSG_PUB.initialize;

Line 1039: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1035: p_count => X_MSG_COUNT,
1036: p_data => X_MSG_DATA);
1037:
1038: WHEN INSERT_FAILED THEN
1039: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1040: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_CATEGORY_GROUP.insertcheck',
1041: 'Insert Row has failed='||l_check);
1042: END IF;
1043: FND_MSG_PUB.initialize;

Line 1040: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_CATEGORY_GROUP.insertcheck',

1036: p_data => X_MSG_DATA);
1037:
1038: WHEN INSERT_FAILED THEN
1039: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1040: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_CATEGORY_GROUP.insertcheck',
1041: 'Insert Row has failed='||l_check);
1042: END IF;
1043: FND_MSG_PUB.initialize;
1044: FND_MESSAGE.set_name('CS', 'CS_KB_C_CREATE_ERR');

Line 1052: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1048: p_count => X_MSG_COUNT,
1049: p_data => X_MSG_DATA);
1050:
1051: WHEN DUPLICATE_CATEGORY_GROUP THEN
1052: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1053: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_CATEGORY_GROUP.dupcheck',
1054: 'Category Group Name is a Duplicate='||P_NAME);
1055: END IF;
1056: FND_MSG_PUB.initialize;

Line 1053: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_CATEGORY_GROUP.dupcheck',

1049: p_data => X_MSG_DATA);
1050:
1051: WHEN DUPLICATE_CATEGORY_GROUP THEN
1052: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1053: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_CATEGORY_GROUP.dupcheck',
1054: 'Category Group Name is a Duplicate='||P_NAME);
1055: END IF;
1056: FND_MSG_PUB.initialize;
1057: FND_MESSAGE.set_name('CS', 'CS_KB_CG_DUP_ERROR');

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

1062: p_data => X_MSG_DATA);
1063:
1064: WHEN OTHERS THEN
1065: ROLLBACK TO Create_Category_Group_PVT;
1066: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1067: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_CATEGORY_GROUP.UNEXPECTED',
1068: ' Error= '||sqlerrm);
1069: END IF;
1070: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');

Line 1067: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_CATEGORY_GROUP.UNEXPECTED',

1063:
1064: WHEN OTHERS THEN
1065: ROLLBACK TO Create_Category_Group_PVT;
1066: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1067: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_CATEGORY_GROUP.UNEXPECTED',
1068: ' Error= '||sqlerrm);
1069: END IF;
1070: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
1071: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

1143: BEGIN
1144: SAVEPOINT Update_Category_Group_PVT;
1145: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1146:
1147: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1148: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_KB_SECURITY_PVT.UPDATE_CATEGORY_GROUP.begin',
1149: 'User='||l_current_user);
1150: END IF;
1151:

Line 1148: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_KB_SECURITY_PVT.UPDATE_CATEGORY_GROUP.begin',

1144: SAVEPOINT Update_Category_Group_PVT;
1145: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1146:
1147: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1148: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_KB_SECURITY_PVT.UPDATE_CATEGORY_GROUP.begin',
1149: 'User='||l_current_user);
1150: END IF;
1151:
1152: -- Validate Required Parameters have been passed into api

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

1193: --dbms_output.put_line('Update Check-'||l_check);
1194: IF l_check <> 1 THEN
1195: RAISE UPDATE_FAILED;
1196: ELSE
1197: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1198: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'cs.plsql.CS_KB_SECURITY_PVT.UPDATE_CATEGORY_GROUP.update',
1199: 'Cat Grp Update Successfull='||P_CATEGORY_GROUP_ID);
1200: END IF;
1201:

Line 1198: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'cs.plsql.CS_KB_SECURITY_PVT.UPDATE_CATEGORY_GROUP.update',

1194: IF l_check <> 1 THEN
1195: RAISE UPDATE_FAILED;
1196: ELSE
1197: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1198: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'cs.plsql.CS_KB_SECURITY_PVT.UPDATE_CATEGORY_GROUP.update',
1199: 'Cat Grp Update Successfull='||P_CATEGORY_GROUP_ID);
1200: END IF;
1201:
1202: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

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

1204: END IF; -- Check Name Dup
1205:
1206: END IF; -- Valid Params Passed
1207:
1208: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1209: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_CATEGORY_GROUP.end',
1210: 'Status='||X_RETURN_STATUS);
1211: END IF;
1212: EXCEPTION

Line 1209: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_CATEGORY_GROUP.end',

1205:
1206: END IF; -- Valid Params Passed
1207:
1208: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1209: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_CATEGORY_GROUP.end',
1210: 'Status='||X_RETURN_STATUS);
1211: END IF;
1212: EXCEPTION
1213: WHEN INVALID_IN_PARAMETERS THEN

Line 1214: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1210: 'Status='||X_RETURN_STATUS);
1211: END IF;
1212: EXCEPTION
1213: WHEN INVALID_IN_PARAMETERS THEN
1214: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1215: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.UPDATE_CATEGORY_GROUP.invparam',
1216: 'P_NAME='||P_NAME||
1217: 'P_CATEGORY_GROUP_ID='||P_CATEGORY_GROUP_ID);
1218: END IF;

Line 1215: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.UPDATE_CATEGORY_GROUP.invparam',

1211: END IF;
1212: EXCEPTION
1213: WHEN INVALID_IN_PARAMETERS THEN
1214: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1215: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.UPDATE_CATEGORY_GROUP.invparam',
1216: 'P_NAME='||P_NAME||
1217: 'P_CATEGORY_GROUP_ID='||P_CATEGORY_GROUP_ID);
1218: END IF;
1219: FND_MSG_PUB.initialize;

Line 1228: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1224: p_count => X_MSG_COUNT,
1225: p_data => X_MSG_DATA);
1226:
1227: WHEN DUPLICATE_CATEGORY_GROUP THEN
1228: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1229: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.UPDATE_CATEGORY_GROUP.dupcheck',
1230: 'Update is Duplicate='||p_name);
1231: END IF;
1232: FND_MSG_PUB.initialize;

Line 1229: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.UPDATE_CATEGORY_GROUP.dupcheck',

1225: p_data => X_MSG_DATA);
1226:
1227: WHEN DUPLICATE_CATEGORY_GROUP THEN
1228: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1229: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.UPDATE_CATEGORY_GROUP.dupcheck',
1230: 'Update is Duplicate='||p_name);
1231: END IF;
1232: FND_MSG_PUB.initialize;
1233: FND_MESSAGE.set_name('CS', 'CS_KB_CG_DUP_ERROR');

Line 1241: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1237: p_count => X_MSG_COUNT,
1238: p_data => X_MSG_DATA);
1239:
1240: WHEN UPDATE_FAILED THEN
1241: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1242: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.UPDATE_CATEGORY_GROUP.updatecheck',
1243: 'Update Row has failed='||l_check);
1244: END IF;
1245: FND_MSG_PUB.initialize;

Line 1242: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.UPDATE_CATEGORY_GROUP.updatecheck',

1238: p_data => X_MSG_DATA);
1239:
1240: WHEN UPDATE_FAILED THEN
1241: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1242: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.UPDATE_CATEGORY_GROUP.updatecheck',
1243: 'Update Row has failed='||l_check);
1244: END IF;
1245: FND_MSG_PUB.initialize;
1246: FND_MESSAGE.set_name('CS', 'CS_KB_C_UPDATE_ERR');

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

1250: p_count => X_MSG_COUNT,
1251: p_data => X_MSG_DATA);
1252: WHEN OTHERS THEN
1253: ROLLBACK TO Update_Category_Group_PVT;
1254: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1255: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'cs.plsql.CS_KB_SECURITY_PVT.UPDATE_CATEGORY_GROUP.UNEXPECTED',
1256: ' Error= '||sqlerrm);
1257: END IF;
1258: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');

Line 1255: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'cs.plsql.CS_KB_SECURITY_PVT.UPDATE_CATEGORY_GROUP.UNEXPECTED',

1251: p_data => X_MSG_DATA);
1252: WHEN OTHERS THEN
1253: ROLLBACK TO Update_Category_Group_PVT;
1254: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1255: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'cs.plsql.CS_KB_SECURITY_PVT.UPDATE_CATEGORY_GROUP.UNEXPECTED',
1256: ' Error= '||sqlerrm);
1257: END IF;
1258: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
1259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

1318: BEGIN
1319: SAVEPOINT Delete_Category_Group_PVT;
1320: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1321:
1322: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1323: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_CATEGORY_GROUP.begin',
1324: 'User='||l_current_user);
1325: END IF;
1326:

Line 1323: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_CATEGORY_GROUP.begin',

1319: SAVEPOINT Delete_Category_Group_PVT;
1320: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1321:
1322: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1323: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_CATEGORY_GROUP.begin',
1324: 'User='||l_current_user);
1325: END IF;
1326:
1327: OPEN CHECK_DELETE;

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

1366: END IF;
1367:
1368: END IF; -- Valid Param Check
1369:
1370: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1371: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_CATEGORY_GROUP.end',
1372: 'Status='||X_RETURN_STATUS);
1373: END IF;
1374:

Line 1371: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_CATEGORY_GROUP.end',

1367:
1368: END IF; -- Valid Param Check
1369:
1370: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1371: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_CATEGORY_GROUP.end',
1372: 'Status='||X_RETURN_STATUS);
1373: END IF;
1374:
1375: EXCEPTION

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

1373: END IF;
1374:
1375: EXCEPTION
1376: WHEN INVALID_IN_PARAMETERS THEN
1377: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1378: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_CATEGORY_GROUP.invparam',
1379: 'P_CATEGORY_GROUP_ID='||P_CATEGORY_GROUP_ID);
1380: END IF;
1381: FND_MSG_PUB.initialize;

Line 1378: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_CATEGORY_GROUP.invparam',

1374:
1375: EXCEPTION
1376: WHEN INVALID_IN_PARAMETERS THEN
1377: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1378: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_CATEGORY_GROUP.invparam',
1379: 'P_CATEGORY_GROUP_ID='||P_CATEGORY_GROUP_ID);
1380: END IF;
1381: FND_MSG_PUB.initialize;
1382: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_PARAM');

Line 1390: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1386: p_count => X_MSG_COUNT,
1387: p_data => X_MSG_DATA);
1388:
1389: WHEN CG_NOT_FOUND THEN
1390: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1391: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_CATEGORY_GROUP.invdel',
1392: 'P_CATEGORY_GROUP_ID='||P_CATEGORY_GROUP_ID);
1393: END IF;
1394: FND_MSG_PUB.initialize;

Line 1391: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_CATEGORY_GROUP.invdel',

1387: p_data => X_MSG_DATA);
1388:
1389: WHEN CG_NOT_FOUND THEN
1390: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1391: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_CATEGORY_GROUP.invdel',
1392: 'P_CATEGORY_GROUP_ID='||P_CATEGORY_GROUP_ID);
1393: END IF;
1394: FND_MSG_PUB.initialize;
1395: FND_MESSAGE.set_name('CS', 'CS_KB_CG_NOT_FOUND');

Line 1403: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1399: p_count => X_MSG_COUNT,
1400: p_data => X_MSG_DATA);
1401:
1402: WHEN DELETE_FAILED THEN
1403: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1404: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_CATEGORY_GROUP.deletefail',
1405: 'Delete Row has failed='||l_valid);
1406: END IF;
1407: FND_MSG_PUB.initialize;

Line 1404: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_CATEGORY_GROUP.deletefail',

1400: p_data => X_MSG_DATA);
1401:
1402: WHEN DELETE_FAILED THEN
1403: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1404: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_CATEGORY_GROUP.deletefail',
1405: 'Delete Row has failed='||l_valid);
1406: END IF;
1407: FND_MSG_PUB.initialize;
1408: FND_MESSAGE.set_name('CS', 'CS_KB_C_DELETE_ERR');

Line 1417: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1413: p_data => X_MSG_DATA);
1414:
1415: WHEN CG_MEMBERS_EXIST THEN
1416: ROLLBACK TO Delete_Category_Group_PVT;
1417: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1418: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_CATEGORY_GROUP.memexist',
1419: 'Members Exist for Cat Grp='||l_member_count);
1420: END IF;
1421: FND_MSG_PUB.initialize;

Line 1418: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_CATEGORY_GROUP.memexist',

1414:
1415: WHEN CG_MEMBERS_EXIST THEN
1416: ROLLBACK TO Delete_Category_Group_PVT;
1417: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1418: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_CATEGORY_GROUP.memexist',
1419: 'Members Exist for Cat Grp='||l_member_count);
1420: END IF;
1421: FND_MSG_PUB.initialize;
1422: FND_MESSAGE.set_name('CS', 'CS_KB_INV_DEL_CG');

Line 1431: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1427: p_data => X_MSG_DATA);
1428:
1429: WHEN CG_FLOWS_EXIST THEN
1430: ROLLBACK TO Delete_Category_Group_PVT;
1431: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1432: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_CATEGORY_GROUP.flowexist',
1433: 'Flows Exist for Cat Grp='||l_flow_count);
1434: END IF;
1435: FND_MSG_PUB.initialize;

Line 1432: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_CATEGORY_GROUP.flowexist',

1428:
1429: WHEN CG_FLOWS_EXIST THEN
1430: ROLLBACK TO Delete_Category_Group_PVT;
1431: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1432: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_CATEGORY_GROUP.flowexist',
1433: 'Flows Exist for Cat Grp='||l_flow_count);
1434: END IF;
1435: FND_MSG_PUB.initialize;
1436: FND_MESSAGE.set_name('CS', 'CS_KB_INV_DEL_CG');

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

1441: p_data => X_MSG_DATA);
1442:
1443: WHEN OTHERS THEN
1444: ROLLBACK TO Delete_Category_Group_PVT;
1445: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1446: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_CATEGORY_GROUP.UNEXPECTED',
1447: ' Error= '||sqlerrm);
1448: END IF;
1449: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');

Line 1446: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_CATEGORY_GROUP.UNEXPECTED',

1442:
1443: WHEN OTHERS THEN
1444: ROLLBACK TO Delete_Category_Group_PVT;
1445: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1446: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_CATEGORY_GROUP.UNEXPECTED',
1447: ' Error= '||sqlerrm);
1448: END IF;
1449: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
1450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

1602: --dbms_output.put_line('In api-'||P_CATEGORY_GROUP_ID||' - '||P_CATEGORY_ID);
1603: SAVEPOINT Create_Cat_Group_Member_PVT;
1604: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1605:
1606: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1607: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_CATEGORY_GROUP_MEMBER.begin',
1608: 'User='||l_current_user);
1609: END IF;
1610:

Line 1607: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_CATEGORY_GROUP_MEMBER.begin',

1603: SAVEPOINT Create_Cat_Group_Member_PVT;
1604: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1605:
1606: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1607: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_CATEGORY_GROUP_MEMBER.begin',
1608: 'User='||l_current_user);
1609: END IF;
1610:
1611: -- Validate Required Parameters have been passed into api

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

1682:
1683: -- Populate the New Category Member and its children to the Denorm table
1684: ADD_CAT_GRP_MEMBER_TO_DENORM(P_CATEGORY_GROUP_ID, P_CATEGORY_ID);
1685:
1686: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1687: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_CATEGORY_GROUP_MEMBER.insert',
1688: 'CG Member Insert Successfull='||P_CATEGORY_GROUP_ID||'-'||P_CATEGORY_ID);
1689: END IF;
1690:

Line 1687: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_CATEGORY_GROUP_MEMBER.insert',

1683: -- Populate the New Category Member and its children to the Denorm table
1684: ADD_CAT_GRP_MEMBER_TO_DENORM(P_CATEGORY_GROUP_ID, P_CATEGORY_ID);
1685:
1686: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1687: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_CATEGORY_GROUP_MEMBER.insert',
1688: 'CG Member Insert Successfull='||P_CATEGORY_GROUP_ID||'-'||P_CATEGORY_ID);
1689: END IF;
1690:
1691: CS_KB_SYNC_INDEX_PKG.request_mark_idx_on_sec_change

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

1709: END IF;-- valid params check
1710:
1711: END IF; --Params passed in
1712:
1713: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1714: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_CATEGORY_GROUP_MEMBER.end',
1715: 'Status='||X_RETURN_STATUS);
1716: END IF;
1717:

Line 1714: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_CATEGORY_GROUP_MEMBER.end',

1710:
1711: END IF; --Params passed in
1712:
1713: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1714: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_CATEGORY_GROUP_MEMBER.end',
1715: 'Status='||X_RETURN_STATUS);
1716: END IF;
1717:
1718: EXCEPTION

Line 1721: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1717:
1718: EXCEPTION
1719: WHEN INVALID_IN_PARAMETERS THEN
1720:
1721: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1722: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_CATEGORY_GROUP_MEMBER.invparam',
1723: 'P_CATEGORY_ID='||P_CATEGORY_ID||
1724: '+P_CATEGORY_GROUP_ID='||P_CATEGORY_GROUP_ID);
1725: END IF;

Line 1722: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_CATEGORY_GROUP_MEMBER.invparam',

1718: EXCEPTION
1719: WHEN INVALID_IN_PARAMETERS THEN
1720:
1721: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1722: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_CATEGORY_GROUP_MEMBER.invparam',
1723: 'P_CATEGORY_ID='||P_CATEGORY_ID||
1724: '+P_CATEGORY_GROUP_ID='||P_CATEGORY_GROUP_ID);
1725: END IF;
1726: FND_MSG_PUB.initialize;

Line 1735: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1731: p_count => X_MSG_COUNT,
1732: p_data => X_MSG_DATA);
1733:
1734: WHEN INSERT_FAILED THEN
1735: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1736: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_CATEGORY_GROUP.insertcheck',
1737: 'Insert Row has failed='||l_check);
1738: END IF;
1739: ROLLBACK TO Create_Cat_Group_Member_PVT;

Line 1736: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_CATEGORY_GROUP.insertcheck',

1732: p_data => X_MSG_DATA);
1733:
1734: WHEN INSERT_FAILED THEN
1735: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1736: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_CATEGORY_GROUP.insertcheck',
1737: 'Insert Row has failed='||l_check);
1738: END IF;
1739: ROLLBACK TO Create_Cat_Group_Member_PVT;
1740: FND_MSG_PUB.initialize;

Line 1750: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1746: p_data => X_MSG_DATA);
1747:
1748: WHEN DUP_CATEGORY_GROUP_MEMBER THEN
1749:
1750: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1751: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_CATEGORY_GROUP.dupcheck',
1752: 'Member already included: P_CATEGORY_ID='||P_CATEGORY_ID||
1753: '+P_CATEGORY_GROUP_ID='||P_CATEGORY_GROUP_ID);
1754: END IF;

Line 1751: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_CATEGORY_GROUP.dupcheck',

1747:
1748: WHEN DUP_CATEGORY_GROUP_MEMBER THEN
1749:
1750: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1751: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_CATEGORY_GROUP.dupcheck',
1752: 'Member already included: P_CATEGORY_ID='||P_CATEGORY_ID||
1753: '+P_CATEGORY_GROUP_ID='||P_CATEGORY_GROUP_ID);
1754: END IF;
1755: FND_MSG_PUB.initialize;

Line 1765: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1761: p_data => X_MSG_DATA);
1762:
1763: WHEN INDEX_SYNC_FAILED THEN
1764: ROLLBACK TO Create_Cat_Group_Member_PVT;
1765: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1766: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_CATEGORY_GROUP.indexsync',
1767: 'Index Sync failed='||l_request_id);
1768: END IF;
1769: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

Line 1766: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_CATEGORY_GROUP.indexsync',

1762:
1763: WHEN INDEX_SYNC_FAILED THEN
1764: ROLLBACK TO Create_Cat_Group_Member_PVT;
1765: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1766: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_CATEGORY_GROUP.indexsync',
1767: 'Index Sync failed='||l_request_id);
1768: END IF;
1769: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1770: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

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

1772: p_data => X_MSG_DATA);
1773:
1774: WHEN OTHERS THEN
1775: ROLLBACK TO Create_Cat_Group_Member_PVT;
1776: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1777: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_CATEGORY_GROUP_MEMBER.UNEXPECTED',
1778: ' Error= '||sqlerrm);
1779: END IF;
1780: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');

Line 1777: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_CATEGORY_GROUP_MEMBER.UNEXPECTED',

1773:
1774: WHEN OTHERS THEN
1775: ROLLBACK TO Create_Cat_Group_Member_PVT;
1776: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1777: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'cs.plsql.CS_KB_SECURITY_PVT.CREATE_CATEGORY_GROUP_MEMBER.UNEXPECTED',
1778: ' Error= '||sqlerrm);
1779: END IF;
1780: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
1781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

1833: BEGIN
1834: SAVEPOINT Delete_Cat_Group_Member_PVT;
1835: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1836:
1837: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1838: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_CAT_GROUP_MEMBER.begin',
1839: 'User='||l_current_user);
1840: END IF;
1841:

Line 1838: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_CAT_GROUP_MEMBER.begin',

1834: SAVEPOINT Delete_Cat_Group_Member_PVT;
1835: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1836:
1837: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1838: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_CAT_GROUP_MEMBER.begin',
1839: 'User='||l_current_user);
1840: END IF;
1841:
1842: -- Validate Required Parameters have been passed into api

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

1886: END IF;
1887:
1888: END IF; -- Valid Param Check
1889:
1890: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1891: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_CAT_GROUP_MEMBER.end',
1892: 'Status='||X_RETURN_STATUS);
1893: END IF;
1894:

Line 1891: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_CAT_GROUP_MEMBER.end',

1887:
1888: END IF; -- Valid Param Check
1889:
1890: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1891: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_CAT_GROUP_MEMBER.end',
1892: 'Status='||X_RETURN_STATUS);
1893: END IF;
1894:
1895: EXCEPTION

Line 1897: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1893: END IF;
1894:
1895: EXCEPTION
1896: WHEN INVALID_IN_PARAMETERS THEN
1897: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1898: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_CAT_GROUP_MEMBER.invparam',
1899: 'P_CATEGORY_GROUP_ID='||P_CATEGORY_GROUP_ID||
1900: ' P_CATEGORY_ID='||P_CATEGORY_ID);
1901: END IF;

Line 1898: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_CAT_GROUP_MEMBER.invparam',

1894:
1895: EXCEPTION
1896: WHEN INVALID_IN_PARAMETERS THEN
1897: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1898: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_CAT_GROUP_MEMBER.invparam',
1899: 'P_CATEGORY_GROUP_ID='||P_CATEGORY_GROUP_ID||
1900: ' P_CATEGORY_ID='||P_CATEGORY_ID);
1901: END IF;
1902: FND_MSG_PUB.initialize;

Line 1910: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1906: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1907: p_count => X_MSG_COUNT,
1908: p_data => X_MSG_DATA);
1909: WHEN DELETE_FAILED THEN
1910: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1911: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_CAT_GROUP_MEMBER.deletefail',
1912: 'Delete Row has failed='||l_valid);
1913: END IF;
1914: FND_MSG_PUB.initialize;

Line 1911: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_CAT_GROUP_MEMBER.deletefail',

1907: p_count => X_MSG_COUNT,
1908: p_data => X_MSG_DATA);
1909: WHEN DELETE_FAILED THEN
1910: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1911: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_CAT_GROUP_MEMBER.deletefail',
1912: 'Delete Row has failed='||l_valid);
1913: END IF;
1914: FND_MSG_PUB.initialize;
1915: FND_MESSAGE.set_name('CS', 'CS_KB_C_DELETE_ERR');

Line 1924: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1920: p_data => X_MSG_DATA);
1921:
1922: WHEN INDEX_SYNC_FAILED THEN
1923: ROLLBACK TO Delete_Cat_Group_Member_PVT;
1924: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1925: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_CAT_GROUP_MEMBER.indexsync',
1926: 'Index Sync failed='||l_request_id);
1927: END IF;
1928: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

Line 1925: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_CAT_GROUP_MEMBER.indexsync',

1921:
1922: WHEN INDEX_SYNC_FAILED THEN
1923: ROLLBACK TO Delete_Cat_Group_Member_PVT;
1924: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1925: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_CAT_GROUP_MEMBER.indexsync',
1926: 'Index Sync failed='||l_request_id);
1927: END IF;
1928: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1929: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

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

1931: p_data => X_MSG_DATA);
1932:
1933: WHEN OTHERS THEN
1934: ROLLBACK TO Delete_Cat_Group_Member_PVT;
1935: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1936: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_CATEGORY_GROUP_MEMBER.UNEXPECTED',
1937: ' Error= '||sqlerrm);
1938: END IF;
1939: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');

Line 1936: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_CATEGORY_GROUP_MEMBER.UNEXPECTED',

1932:
1933: WHEN OTHERS THEN
1934: ROLLBACK TO Delete_Cat_Group_Member_PVT;
1935: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1936: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'cs.plsql.CS_KB_SECURITY_PVT.DELETE_CATEGORY_GROUP_MEMBER.UNEXPECTED',
1937: ' Error= '||sqlerrm);
1938: END IF;
1939: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
1940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2234: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2230: END IF;
2231:
2232: EXCEPTION
2233: WHEN INVALID_IN_PARAMETERS THEN
2234: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2235: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.ADD_CATEGORY_TO_DENORM.invparam',
2236: 'P_CATEGORY_ID='||P_CATEGORY_ID||
2237: 'P_PARENT_CATEGORY_ID='||P_PARENT_CATEGORY_ID||
2238: 'P_VISIBILITY_ID='||P_VISIBILITY_ID);

Line 2235: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.ADD_CATEGORY_TO_DENORM.invparam',

2231:
2232: EXCEPTION
2233: WHEN INVALID_IN_PARAMETERS THEN
2234: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2235: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.ADD_CATEGORY_TO_DENORM.invparam',
2236: 'P_CATEGORY_ID='||P_CATEGORY_ID||
2237: 'P_PARENT_CATEGORY_ID='||P_PARENT_CATEGORY_ID||
2238: 'P_VISIBILITY_ID='||P_VISIBILITY_ID);
2239: END IF;

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

2246: p_data => X_MSG_DATA);
2247:
2248: WHEN OTHERS THEN
2249: ROLLBACK TO Add_Cat_To_Denorm_PVT;
2250: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2251: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'cs.plsql.CS_KB_SECURITY_PVT.ADD_CATEGORY_TO_DENORM.UNEXPECTED',
2252: ' Error= '||sqlerrm);
2253: END IF;
2254: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');

Line 2251: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'cs.plsql.CS_KB_SECURITY_PVT.ADD_CATEGORY_TO_DENORM.UNEXPECTED',

2247:
2248: WHEN OTHERS THEN
2249: ROLLBACK TO Add_Cat_To_Denorm_PVT;
2250: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2251: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'cs.plsql.CS_KB_SECURITY_PVT.ADD_CATEGORY_TO_DENORM.UNEXPECTED',
2252: ' Error= '||sqlerrm);
2253: END IF;
2254: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
2255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2349: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2345: END IF;
2346:
2347: EXCEPTION
2348: WHEN INVALID_IN_PARAMETERS THEN
2349: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2350: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.UPDATE_CATEGORY_TO_DENORM.invparam',
2351: 'P_CATEGORY_ID='||P_CATEGORY_ID||
2352: 'P_VISIBILITY_ID='||P_VISIBILITY_ID);
2353: END IF;

Line 2350: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.UPDATE_CATEGORY_TO_DENORM.invparam',

2346:
2347: EXCEPTION
2348: WHEN INVALID_IN_PARAMETERS THEN
2349: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2350: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.UPDATE_CATEGORY_TO_DENORM.invparam',
2351: 'P_CATEGORY_ID='||P_CATEGORY_ID||
2352: 'P_VISIBILITY_ID='||P_VISIBILITY_ID);
2353: END IF;
2354: FND_MSG_PUB.initialize;

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

2360: p_data => X_MSG_DATA);
2361:
2362: WHEN OTHERS THEN
2363: ROLLBACK TO Upd_Cat_To_Denorm_PVT;
2364: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2365: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'cs.plsql.CS_KB_SECURITY_PVT.UPDATE_CATEGORY_TO_DENORM.UNEXPECTED',
2366: ' Error= '||sqlerrm);
2367: END IF;
2368: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');

Line 2365: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'cs.plsql.CS_KB_SECURITY_PVT.UPDATE_CATEGORY_TO_DENORM.UNEXPECTED',

2361:
2362: WHEN OTHERS THEN
2363: ROLLBACK TO Upd_Cat_To_Denorm_PVT;
2364: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2365: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'cs.plsql.CS_KB_SECURITY_PVT.UPDATE_CATEGORY_TO_DENORM.UNEXPECTED',
2366: ' Error= '||sqlerrm);
2367: END IF;
2368: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
2369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2451: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2447: END IF;
2448:
2449: EXCEPTION
2450: WHEN INVALID_IN_PARAMETERS THEN
2451: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2452: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.REMOVE_CATEGORY_FROM_CAT_GROUP.invparam',
2453: 'P_CATEGORY_ID='||P_CATEGORY_ID);
2454: END IF;
2455: FND_MSG_PUB.initialize;

Line 2452: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.REMOVE_CATEGORY_FROM_CAT_GROUP.invparam',

2448:
2449: EXCEPTION
2450: WHEN INVALID_IN_PARAMETERS THEN
2451: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2452: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.REMOVE_CATEGORY_FROM_CAT_GROUP.invparam',
2453: 'P_CATEGORY_ID='||P_CATEGORY_ID);
2454: END IF;
2455: FND_MSG_PUB.initialize;
2456: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_PARAM');

Line 2464: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2460: p_count => X_MSG_COUNT,
2461: p_data => X_MSG_DATA);
2462:
2463: WHEN DELETE_FAILED THEN
2464: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2465: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.REMOVE_CATEGORY_FROM_CAT_GROUP.delfail',
2466: 'Member Count='||l_member_count||
2467: 'Denorm Count='||l_denorm_count);
2468: END IF;

Line 2465: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.REMOVE_CATEGORY_FROM_CAT_GROUP.delfail',

2461: p_data => X_MSG_DATA);
2462:
2463: WHEN DELETE_FAILED THEN
2464: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2465: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'cs.plsql.CS_KB_SECURITY_PVT.REMOVE_CATEGORY_FROM_CAT_GROUP.delfail',
2466: 'Member Count='||l_member_count||
2467: 'Denorm Count='||l_denorm_count);
2468: END IF;
2469: FND_MSG_PUB.initialize;

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

2475: p_data => X_MSG_DATA);
2476:
2477: WHEN OTHERS THEN
2478: ROLLBACK TO Remove_Cat_From_Cat_Grp_PVT;
2479: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2480: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'cs.plsql.CS_KB_SECURITY_PVT.REMOVE_CATEGORY_FROM_CAT_GROUP.UNEXPECTED',
2481: ' Error= '||sqlerrm);
2482: END IF;
2483: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');

Line 2480: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'cs.plsql.CS_KB_SECURITY_PVT.REMOVE_CATEGORY_FROM_CAT_GROUP.UNEXPECTED',

2476:
2477: WHEN OTHERS THEN
2478: ROLLBACK TO Remove_Cat_From_Cat_Grp_PVT;
2479: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2480: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'cs.plsql.CS_KB_SECURITY_PVT.REMOVE_CATEGORY_FROM_CAT_GROUP.UNEXPECTED',
2481: ' Error= '||sqlerrm);
2482: END IF;
2483: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
2484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

2885: p_data => X_MSG_DATA);
2886:
2887: WHEN OTHERS THEN
2888: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
2889: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2890: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'cs.plsql.CS_KB_SECURITY_PVT.GET_SECURITY_PROFILES.UNEXPECTED',
2891: ' Error= '||sqlerrm);
2892: END IF;
2893: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2890: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'cs.plsql.CS_KB_SECURITY_PVT.GET_SECURITY_PROFILES.UNEXPECTED',

2886:
2887: WHEN OTHERS THEN
2888: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
2889: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2890: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'cs.plsql.CS_KB_SECURITY_PVT.GET_SECURITY_PROFILES.UNEXPECTED',
2891: ' Error= '||sqlerrm);
2892: END IF;
2893: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2894: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

Line 3144: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

3140: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
3141:
3142: EXCEPTION
3143: WHEN UPDATE_FAILED THEN
3144: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3145: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
3146: 'cs.plsql.CS_KB_SECURITY_PVT.MOVE_CAT_IN_DENORM.update',
3147: 'P_CATEGORY_ID='||P_CATEGORY_ID --||
3148: --'P_PARENT_CATEGORY_ID='||P_PARENT_CATEGORY_ID||

Line 3145: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,

3141:
3142: EXCEPTION
3143: WHEN UPDATE_FAILED THEN
3144: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3145: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
3146: 'cs.plsql.CS_KB_SECURITY_PVT.MOVE_CAT_IN_DENORM.update',
3147: 'P_CATEGORY_ID='||P_CATEGORY_ID --||
3148: --'P_PARENT_CATEGORY_ID='||P_PARENT_CATEGORY_ID||
3149: --'P_VISIBILITY_ID='||P_VISIBILITY_ID

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

3155: X_MSG_DATA := l_msg_data;
3156:
3157: WHEN OTHERS THEN
3158: ROLLBACK TO Move_Cat_In_Denorm_PVT;
3159: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3160: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'cs.plsql.CS_KB_SECURITY_PVT.MOVE_CATEGORY_IN_DENORM.UNEXPECTED',
3161: ' Error= '||sqlerrm);
3162: END IF;
3163: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');

Line 3160: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'cs.plsql.CS_KB_SECURITY_PVT.MOVE_CATEGORY_IN_DENORM.UNEXPECTED',

3156:
3157: WHEN OTHERS THEN
3158: ROLLBACK TO Move_Cat_In_Denorm_PVT;
3159: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3160: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'cs.plsql.CS_KB_SECURITY_PVT.MOVE_CATEGORY_IN_DENORM.UNEXPECTED',
3161: ' Error= '||sqlerrm);
3162: END IF;
3163: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
3164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;