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_SECURITY_PVT dependencies on FND_MSG_PUB

Line 348: FND_MSG_PUB.initialize;

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;
348: FND_MSG_PUB.initialize;
349: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_PARAM');
350: FND_MSG_PUB.ADD;
351: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
352: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

Line 350: FND_MSG_PUB.ADD;

346: 'P_ADD_AFTER_POSITION='||P_ADD_AFTER_VISIBILITY);
347: END IF;
348: FND_MSG_PUB.initialize;
349: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_PARAM');
350: FND_MSG_PUB.ADD;
351: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
352: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
353: p_count => X_MSG_COUNT,
354: p_data => X_MSG_DATA);

Line 352: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

348: FND_MSG_PUB.initialize;
349: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_PARAM');
350: FND_MSG_PUB.ADD;
351: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
352: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
353: p_count => X_MSG_COUNT,
354: p_data => X_MSG_DATA);
355:
356: WHEN INSERT_FAILED THEN

Line 362: FND_MSG_PUB.initialize;

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');
364: FND_MSG_PUB.ADD;
365: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
366: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

Line 364: FND_MSG_PUB.ADD;

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');
364: FND_MSG_PUB.ADD;
365: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
366: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
367: p_count => X_MSG_COUNT,
368: p_data => X_MSG_DATA);

Line 366: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

362: FND_MSG_PUB.initialize;
363: FND_MESSAGE.set_name('CS', 'CS_KB_C_CREATE_ERR');
364: FND_MSG_PUB.ADD;
365: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
366: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
367: p_count => X_MSG_COUNT,
368: p_data => X_MSG_DATA);
369:
370: WHEN DUPLICATE_VISIBILITY THEN

Line 375: FND_MSG_PUB.initialize;

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');
377: FND_MSG_PUB.ADD;
378: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
379: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

Line 377: FND_MSG_PUB.ADD;

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');
377: FND_MSG_PUB.ADD;
378: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
379: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
380: p_count => X_MSG_COUNT,
381: p_data => X_MSG_DATA);

Line 379: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

375: FND_MSG_PUB.initialize;
376: FND_MESSAGE.set_name('CS', 'CS_KB_VIS_DUP_ERROR');
377: FND_MSG_PUB.ADD;
378: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
379: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
380: p_count => X_MSG_COUNT,
381: p_data => X_MSG_DATA);
382:
383: WHEN INDEX_SYNC_FAILED THEN

Line 390: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

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 ,
391: p_count => X_MSG_COUNT,
392: p_data => X_MSG_DATA);
393:
394: WHEN OTHERS THEN

Line 402: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

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 ;
402: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
403: p_data => x_msg_data);
404: END CREATE_VISIBILITY;
405:
406:

Line 565: FND_MSG_PUB.initialize;

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;
566: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_PARAM');
567: FND_MSG_PUB.ADD;
568: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
569: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

Line 567: FND_MSG_PUB.ADD;

563: 'P_VISIBILITY='||P_VISIBILITY_ID);
564: END IF;
565: FND_MSG_PUB.initialize;
566: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_PARAM');
567: FND_MSG_PUB.ADD;
568: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
569: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
570: p_count => X_MSG_COUNT,
571: p_data => X_MSG_DATA);

Line 569: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

565: FND_MSG_PUB.initialize;
566: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_PARAM');
567: FND_MSG_PUB.ADD;
568: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
569: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
570: p_count => X_MSG_COUNT,
571: p_data => X_MSG_DATA);
572:
573: WHEN UPDATE_FAILED THEN

Line 578: FND_MSG_PUB.initialize;

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');
580: FND_MSG_PUB.ADD;
581: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
582: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

Line 580: FND_MSG_PUB.ADD;

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');
580: FND_MSG_PUB.ADD;
581: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
582: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
583: p_count => X_MSG_COUNT,
584: p_data => X_MSG_DATA);

Line 582: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

578: FND_MSG_PUB.initialize;
579: FND_MESSAGE.set_name('CS', 'CS_KB_C_UPDATE_ERR');
580: FND_MSG_PUB.ADD;
581: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
582: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
583: p_count => X_MSG_COUNT,
584: p_data => X_MSG_DATA);
585:
586: WHEN DUPLICATE_VISIBILITY THEN

Line 591: FND_MSG_PUB.initialize;

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');
593: FND_MSG_PUB.ADD;
594: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
595: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

Line 593: FND_MSG_PUB.ADD;

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');
593: FND_MSG_PUB.ADD;
594: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
595: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
596: p_count => X_MSG_COUNT,
597: p_data => X_MSG_DATA);

Line 595: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

591: FND_MSG_PUB.initialize;
592: FND_MESSAGE.set_name('CS', 'CS_KB_VIS_DUP_ERROR');
593: FND_MSG_PUB.ADD;
594: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
595: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
596: p_count => X_MSG_COUNT,
597: p_data => X_MSG_DATA);
598:
599: WHEN OTHERS THEN

Line 607: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

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 ;
607: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
608: p_data => x_msg_data);
609: END UPDATE_VISIBILITY;
610:
611: -- Start of comments

Line 760: FND_MSG_PUB.initialize;

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');
762: FND_MSG_PUB.ADD;
763: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
764: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

Line 762: FND_MSG_PUB.ADD;

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');
762: FND_MSG_PUB.ADD;
763: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
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);

Line 764: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

760: FND_MSG_PUB.initialize;
761: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_PARAM');
762: FND_MSG_PUB.ADD;
763: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
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

Line 772: FND_MSG_PUB.initialize;

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');
774: FND_MSG_PUB.ADD;
775: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
776: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

Line 774: FND_MSG_PUB.ADD;

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');
774: FND_MSG_PUB.ADD;
775: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
776: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
777: p_count => X_MSG_COUNT,
778: p_data => X_MSG_DATA);

Line 776: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

772: FND_MSG_PUB.initialize;
773: FND_MESSAGE.set_name('CS', 'CS_KB_VIS_INV_DEL');
774: FND_MSG_PUB.ADD;
775: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
776: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
777: p_count => X_MSG_COUNT,
778: p_data => X_MSG_DATA);
779: WHEN DELETE_FAILED THEN
780: ROLLBACK TO Delete_Visibility_PVT;

Line 785: FND_MSG_PUB.initialize;

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');
787: FND_MSG_PUB.ADD;
788: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
789: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

Line 787: FND_MSG_PUB.ADD;

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');
787: FND_MSG_PUB.ADD;
788: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
789: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
790: p_count => X_MSG_COUNT,
791: p_data => X_MSG_DATA);

Line 789: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

785: FND_MSG_PUB.initialize;
786: FND_MESSAGE.set_name('CS', 'CS_KB_C_DELETE_ERR');
787: FND_MSG_PUB.ADD;
788: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
789: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
790: p_count => X_MSG_COUNT,
791: p_data => X_MSG_DATA);
792: WHEN INDEX_SYNC_FAILED THEN
793: ROLLBACK TO Delete_Visibility_PVT;

Line 799: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

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 ,
800: p_count => X_MSG_COUNT,
801: p_data => X_MSG_DATA);
802:
803: WHEN OTHERS THEN

Line 811: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

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 ;
811: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
812: p_data => x_msg_data);
813: END DELETE_VISIBILITY;
814:
815:

Line 1030: FND_MSG_PUB.initialize;

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;
1031: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_PARAM');
1032: FND_MSG_PUB.ADD;
1033: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1034: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

Line 1032: FND_MSG_PUB.ADD;

1028: 'P_CATEGORY_GROUP_ID='||P_CATEGORY_GROUP_ID);
1029: END IF;
1030: FND_MSG_PUB.initialize;
1031: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_PARAM');
1032: FND_MSG_PUB.ADD;
1033: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1034: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1035: p_count => X_MSG_COUNT,
1036: p_data => X_MSG_DATA);

Line 1034: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

1030: FND_MSG_PUB.initialize;
1031: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_PARAM');
1032: FND_MSG_PUB.ADD;
1033: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1034: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1035: p_count => X_MSG_COUNT,
1036: p_data => X_MSG_DATA);
1037:
1038: WHEN INSERT_FAILED THEN

Line 1043: FND_MSG_PUB.initialize;

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');
1045: FND_MSG_PUB.ADD;
1046: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1047: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

Line 1045: FND_MSG_PUB.ADD;

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');
1045: FND_MSG_PUB.ADD;
1046: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1047: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1048: p_count => X_MSG_COUNT,
1049: p_data => X_MSG_DATA);

Line 1047: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

1043: FND_MSG_PUB.initialize;
1044: FND_MESSAGE.set_name('CS', 'CS_KB_C_CREATE_ERR');
1045: FND_MSG_PUB.ADD;
1046: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1047: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1048: p_count => X_MSG_COUNT,
1049: p_data => X_MSG_DATA);
1050:
1051: WHEN DUPLICATE_CATEGORY_GROUP THEN

Line 1056: FND_MSG_PUB.initialize;

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');
1058: FND_MSG_PUB.ADD;
1059: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1060: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

Line 1058: FND_MSG_PUB.ADD;

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');
1058: FND_MSG_PUB.ADD;
1059: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1060: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1061: p_count => X_MSG_COUNT,
1062: p_data => X_MSG_DATA);

Line 1060: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

1056: FND_MSG_PUB.initialize;
1057: FND_MESSAGE.set_name('CS', 'CS_KB_CG_DUP_ERROR');
1058: FND_MSG_PUB.ADD;
1059: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1060: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1061: p_count => X_MSG_COUNT,
1062: p_data => X_MSG_DATA);
1063:
1064: WHEN OTHERS THEN

Line 1072: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

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 ;
1072: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1073: p_data => x_msg_data);
1074:
1075: END CREATE_CATEGORY_GROUP;
1076:

Line 1219: FND_MSG_PUB.initialize;

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;
1220: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_PARAM');
1221: FND_MSG_PUB.ADD;
1222: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1223: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

Line 1221: FND_MSG_PUB.ADD;

1217: 'P_CATEGORY_GROUP_ID='||P_CATEGORY_GROUP_ID);
1218: END IF;
1219: FND_MSG_PUB.initialize;
1220: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_PARAM');
1221: FND_MSG_PUB.ADD;
1222: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1223: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1224: p_count => X_MSG_COUNT,
1225: p_data => X_MSG_DATA);

Line 1223: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

1219: FND_MSG_PUB.initialize;
1220: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_PARAM');
1221: FND_MSG_PUB.ADD;
1222: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1223: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1224: p_count => X_MSG_COUNT,
1225: p_data => X_MSG_DATA);
1226:
1227: WHEN DUPLICATE_CATEGORY_GROUP THEN

Line 1232: FND_MSG_PUB.initialize;

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');
1234: FND_MSG_PUB.ADD;
1235: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1236: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

Line 1234: FND_MSG_PUB.ADD;

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');
1234: FND_MSG_PUB.ADD;
1235: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1236: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1237: p_count => X_MSG_COUNT,
1238: p_data => X_MSG_DATA);

Line 1236: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

1232: FND_MSG_PUB.initialize;
1233: FND_MESSAGE.set_name('CS', 'CS_KB_CG_DUP_ERROR');
1234: FND_MSG_PUB.ADD;
1235: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1236: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1237: p_count => X_MSG_COUNT,
1238: p_data => X_MSG_DATA);
1239:
1240: WHEN UPDATE_FAILED THEN

Line 1245: FND_MSG_PUB.initialize;

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');
1247: FND_MSG_PUB.ADD;
1248: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1249: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

Line 1247: FND_MSG_PUB.ADD;

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');
1247: FND_MSG_PUB.ADD;
1248: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1249: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1250: p_count => X_MSG_COUNT,
1251: p_data => X_MSG_DATA);

Line 1249: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

1245: FND_MSG_PUB.initialize;
1246: FND_MESSAGE.set_name('CS', 'CS_KB_C_UPDATE_ERR');
1247: FND_MSG_PUB.ADD;
1248: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1249: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1250: p_count => X_MSG_COUNT,
1251: p_data => X_MSG_DATA);
1252: WHEN OTHERS THEN
1253: ROLLBACK TO Update_Category_Group_PVT;

Line 1260: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

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 ;
1260: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1261: p_data => x_msg_data);
1262: END UPDATE_CATEGORY_GROUP;
1263:
1264: -- Start of comments

Line 1381: FND_MSG_PUB.initialize;

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');
1383: FND_MSG_PUB.ADD;
1384: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1385: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

Line 1383: FND_MSG_PUB.ADD;

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');
1383: FND_MSG_PUB.ADD;
1384: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1385: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1386: p_count => X_MSG_COUNT,
1387: p_data => X_MSG_DATA);

Line 1385: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

1381: FND_MSG_PUB.initialize;
1382: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_PARAM');
1383: FND_MSG_PUB.ADD;
1384: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1385: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1386: p_count => X_MSG_COUNT,
1387: p_data => X_MSG_DATA);
1388:
1389: WHEN CG_NOT_FOUND THEN

Line 1394: FND_MSG_PUB.initialize;

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');
1396: FND_MSG_PUB.ADD;
1397: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1398: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

Line 1396: FND_MSG_PUB.ADD;

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');
1396: FND_MSG_PUB.ADD;
1397: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1398: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1399: p_count => X_MSG_COUNT,
1400: p_data => X_MSG_DATA);

Line 1398: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

1394: FND_MSG_PUB.initialize;
1395: FND_MESSAGE.set_name('CS', 'CS_KB_CG_NOT_FOUND');
1396: FND_MSG_PUB.ADD;
1397: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1398: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1399: p_count => X_MSG_COUNT,
1400: p_data => X_MSG_DATA);
1401:
1402: WHEN DELETE_FAILED THEN

Line 1407: FND_MSG_PUB.initialize;

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');
1409: FND_MSG_PUB.ADD;
1410: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1411: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

Line 1409: FND_MSG_PUB.ADD;

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');
1409: FND_MSG_PUB.ADD;
1410: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1411: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1412: p_count => X_MSG_COUNT,
1413: p_data => X_MSG_DATA);

Line 1411: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

1407: FND_MSG_PUB.initialize;
1408: FND_MESSAGE.set_name('CS', 'CS_KB_C_DELETE_ERR');
1409: FND_MSG_PUB.ADD;
1410: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1411: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1412: p_count => X_MSG_COUNT,
1413: p_data => X_MSG_DATA);
1414:
1415: WHEN CG_MEMBERS_EXIST THEN

Line 1421: FND_MSG_PUB.initialize;

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');
1423: FND_MSG_PUB.ADD;
1424: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1425: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

Line 1423: FND_MSG_PUB.ADD;

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');
1423: FND_MSG_PUB.ADD;
1424: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1425: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1426: p_count => X_MSG_COUNT,
1427: p_data => X_MSG_DATA);

Line 1425: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

1421: FND_MSG_PUB.initialize;
1422: FND_MESSAGE.set_name('CS', 'CS_KB_INV_DEL_CG');
1423: FND_MSG_PUB.ADD;
1424: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1425: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1426: p_count => X_MSG_COUNT,
1427: p_data => X_MSG_DATA);
1428:
1429: WHEN CG_FLOWS_EXIST THEN

Line 1435: FND_MSG_PUB.initialize;

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');
1437: FND_MSG_PUB.ADD;
1438: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1439: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

Line 1437: FND_MSG_PUB.ADD;

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');
1437: FND_MSG_PUB.ADD;
1438: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1439: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1440: p_count => X_MSG_COUNT,
1441: p_data => X_MSG_DATA);

Line 1439: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

1435: FND_MSG_PUB.initialize;
1436: FND_MESSAGE.set_name('CS', 'CS_KB_INV_DEL_CG');
1437: FND_MSG_PUB.ADD;
1438: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1439: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1440: p_count => X_MSG_COUNT,
1441: p_data => X_MSG_DATA);
1442:
1443: WHEN OTHERS THEN

Line 1451: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

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 ;
1451: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1452: p_data => x_msg_data);
1453:
1454: END DELETE_CATEGORY_GROUP;
1455:

Line 1726: FND_MSG_PUB.initialize;

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;
1727: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_PARAM');
1728: FND_MSG_PUB.ADD;
1729: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1730: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

Line 1728: FND_MSG_PUB.ADD;

1724: '+P_CATEGORY_GROUP_ID='||P_CATEGORY_GROUP_ID);
1725: END IF;
1726: FND_MSG_PUB.initialize;
1727: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_PARAM');
1728: FND_MSG_PUB.ADD;
1729: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1730: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1731: p_count => X_MSG_COUNT,
1732: p_data => X_MSG_DATA);

Line 1730: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

1726: FND_MSG_PUB.initialize;
1727: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_PARAM');
1728: FND_MSG_PUB.ADD;
1729: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1730: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1731: p_count => X_MSG_COUNT,
1732: p_data => X_MSG_DATA);
1733:
1734: WHEN INSERT_FAILED THEN

Line 1740: FND_MSG_PUB.initialize;

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;
1741: FND_MESSAGE.set_name('CS', 'CS_KB_C_CREATE_ERR');
1742: FND_MSG_PUB.ADD;
1743: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1744: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

Line 1742: FND_MSG_PUB.ADD;

1738: END IF;
1739: ROLLBACK TO Create_Cat_Group_Member_PVT;
1740: FND_MSG_PUB.initialize;
1741: FND_MESSAGE.set_name('CS', 'CS_KB_C_CREATE_ERR');
1742: FND_MSG_PUB.ADD;
1743: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1744: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1745: p_count => X_MSG_COUNT,
1746: p_data => X_MSG_DATA);

Line 1744: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

1740: FND_MSG_PUB.initialize;
1741: FND_MESSAGE.set_name('CS', 'CS_KB_C_CREATE_ERR');
1742: FND_MSG_PUB.ADD;
1743: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1744: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1745: p_count => X_MSG_COUNT,
1746: p_data => X_MSG_DATA);
1747:
1748: WHEN DUP_CATEGORY_GROUP_MEMBER THEN

Line 1755: FND_MSG_PUB.initialize;

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;
1756: FND_MESSAGE.set_name('CS', 'CS_KB_CGM_DUP_ERROR');
1757: FND_MSG_PUB.ADD;
1758: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1759: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

Line 1757: FND_MSG_PUB.ADD;

1753: '+P_CATEGORY_GROUP_ID='||P_CATEGORY_GROUP_ID);
1754: END IF;
1755: FND_MSG_PUB.initialize;
1756: FND_MESSAGE.set_name('CS', 'CS_KB_CGM_DUP_ERROR');
1757: FND_MSG_PUB.ADD;
1758: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1759: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1760: p_count => X_MSG_COUNT,
1761: p_data => X_MSG_DATA);

Line 1759: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

1755: FND_MSG_PUB.initialize;
1756: FND_MESSAGE.set_name('CS', 'CS_KB_CGM_DUP_ERROR');
1757: FND_MSG_PUB.ADD;
1758: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1759: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1760: p_count => X_MSG_COUNT,
1761: p_data => X_MSG_DATA);
1762:
1763: WHEN INDEX_SYNC_FAILED THEN

Line 1770: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

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 ,
1771: p_count => X_MSG_COUNT,
1772: p_data => X_MSG_DATA);
1773:
1774: WHEN OTHERS THEN

Line 1782: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

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 ;
1782: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1783: p_data => x_msg_data);
1784:
1785: END CREATE_CATEGORY_GROUP_MEMBER;
1786:

Line 1902: FND_MSG_PUB.initialize;

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;
1903: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_PARAM');
1904: FND_MSG_PUB.ADD;
1905: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1906: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

Line 1904: FND_MSG_PUB.ADD;

1900: ' P_CATEGORY_ID='||P_CATEGORY_ID);
1901: END IF;
1902: FND_MSG_PUB.initialize;
1903: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_PARAM');
1904: FND_MSG_PUB.ADD;
1905: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
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);

Line 1906: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

1902: FND_MSG_PUB.initialize;
1903: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_PARAM');
1904: FND_MSG_PUB.ADD;
1905: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
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

Line 1914: FND_MSG_PUB.initialize;

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');
1916: FND_MSG_PUB.ADD;
1917: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1918: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

Line 1916: FND_MSG_PUB.ADD;

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');
1916: FND_MSG_PUB.ADD;
1917: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1918: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1919: p_count => X_MSG_COUNT,
1920: p_data => X_MSG_DATA);

Line 1918: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

1914: FND_MSG_PUB.initialize;
1915: FND_MESSAGE.set_name('CS', 'CS_KB_C_DELETE_ERR');
1916: FND_MSG_PUB.ADD;
1917: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1918: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1919: p_count => X_MSG_COUNT,
1920: p_data => X_MSG_DATA);
1921:
1922: WHEN INDEX_SYNC_FAILED THEN

Line 1929: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

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 ,
1930: p_count => X_MSG_COUNT,
1931: p_data => X_MSG_DATA);
1932:
1933: WHEN OTHERS THEN

Line 1941: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

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 ;
1941: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1942: p_data => x_msg_data);
1943:
1944: END DELETE_CATEGORY_GROUP_MEMBER;
1945:

Line 2240: FND_MSG_PUB.initialize;

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;
2240: FND_MSG_PUB.initialize;
2241: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_PARAM');
2242: FND_MSG_PUB.ADD;
2243: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2244: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

Line 2242: FND_MSG_PUB.ADD;

2238: 'P_VISIBILITY_ID='||P_VISIBILITY_ID);
2239: END IF;
2240: FND_MSG_PUB.initialize;
2241: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_PARAM');
2242: FND_MSG_PUB.ADD;
2243: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2244: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
2245: p_count => X_MSG_COUNT,
2246: p_data => X_MSG_DATA);

Line 2244: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

2240: FND_MSG_PUB.initialize;
2241: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_PARAM');
2242: FND_MSG_PUB.ADD;
2243: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2244: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
2245: p_count => X_MSG_COUNT,
2246: p_data => X_MSG_DATA);
2247:
2248: WHEN OTHERS THEN

Line 2256: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

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 ;
2256: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2257: p_data => x_msg_data);
2258: END ADD_CATEGORY_TO_DENORM;
2259:
2260: -- Start of comments

Line 2354: FND_MSG_PUB.initialize;

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;
2355: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_PARAM');
2356: FND_MSG_PUB.ADD;
2357: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2358: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

Line 2356: FND_MSG_PUB.ADD;

2352: 'P_VISIBILITY_ID='||P_VISIBILITY_ID);
2353: END IF;
2354: FND_MSG_PUB.initialize;
2355: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_PARAM');
2356: FND_MSG_PUB.ADD;
2357: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2358: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
2359: p_count => X_MSG_COUNT,
2360: p_data => X_MSG_DATA);

Line 2358: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

2354: FND_MSG_PUB.initialize;
2355: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_PARAM');
2356: FND_MSG_PUB.ADD;
2357: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2358: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
2359: p_count => X_MSG_COUNT,
2360: p_data => X_MSG_DATA);
2361:
2362: WHEN OTHERS THEN

Line 2370: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

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 ;
2370: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2371: p_data => x_msg_data);
2372: END UPDATE_CATEGORY_TO_DENORM;
2373:
2374: -- Start of comments

Line 2455: FND_MSG_PUB.initialize;

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');
2457: FND_MSG_PUB.ADD;
2458: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2459: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

Line 2457: FND_MSG_PUB.ADD;

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');
2457: FND_MSG_PUB.ADD;
2458: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2459: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
2460: p_count => X_MSG_COUNT,
2461: p_data => X_MSG_DATA);

Line 2459: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

2455: FND_MSG_PUB.initialize;
2456: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_PARAM');
2457: FND_MSG_PUB.ADD;
2458: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2459: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
2460: p_count => X_MSG_COUNT,
2461: p_data => X_MSG_DATA);
2462:
2463: WHEN DELETE_FAILED THEN

Line 2469: FND_MSG_PUB.initialize;

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;
2470: FND_MESSAGE.set_name('CS', 'CS_KB_C_DELETE_ERR');
2471: FND_MSG_PUB.ADD;
2472: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2473: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

Line 2471: FND_MSG_PUB.ADD;

2467: 'Denorm Count='||l_denorm_count);
2468: END IF;
2469: FND_MSG_PUB.initialize;
2470: FND_MESSAGE.set_name('CS', 'CS_KB_C_DELETE_ERR');
2471: FND_MSG_PUB.ADD;
2472: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2473: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
2474: p_count => X_MSG_COUNT,
2475: p_data => X_MSG_DATA);

Line 2473: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

2469: FND_MSG_PUB.initialize;
2470: FND_MESSAGE.set_name('CS', 'CS_KB_C_DELETE_ERR');
2471: FND_MSG_PUB.ADD;
2472: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2473: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
2474: p_count => X_MSG_COUNT,
2475: p_data => X_MSG_DATA);
2476:
2477: WHEN OTHERS THEN

Line 2485: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

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 ;
2485: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2486: p_data => x_msg_data);
2487: END REMOVE_CATEGORY_FROM_CAT_GROUP;
2488:
2489: -- Not Used

Line 2863: FND_MSG_PUB.initialize;

2859: END IF;
2860:
2861: EXCEPTION
2862: WHEN INV_SEC_CAT_GRP THEN
2863: FND_MSG_PUB.initialize;
2864: FND_MESSAGE.set_name('CS', 'CS_KB_INV_SEC_CG');
2865: FND_MSG_PUB.ADD;
2866: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2867: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

Line 2865: FND_MSG_PUB.ADD;

2861: EXCEPTION
2862: WHEN INV_SEC_CAT_GRP THEN
2863: FND_MSG_PUB.initialize;
2864: FND_MESSAGE.set_name('CS', 'CS_KB_INV_SEC_CG');
2865: FND_MSG_PUB.ADD;
2866: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2867: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
2868: p_count => X_MSG_COUNT,
2869: p_data => X_MSG_DATA);

Line 2867: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

2863: FND_MSG_PUB.initialize;
2864: FND_MESSAGE.set_name('CS', 'CS_KB_INV_SEC_CG');
2865: FND_MSG_PUB.ADD;
2866: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2867: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
2868: p_count => X_MSG_COUNT,
2869: p_data => X_MSG_DATA);
2870: WHEN INV_SEC_SOLN_VIS THEN
2871: FND_MSG_PUB.initialize;

Line 2871: FND_MSG_PUB.initialize;

2867: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
2868: p_count => X_MSG_COUNT,
2869: p_data => X_MSG_DATA);
2870: WHEN INV_SEC_SOLN_VIS THEN
2871: FND_MSG_PUB.initialize;
2872: FND_MESSAGE.set_name('CS', 'CS_KB_INV_SEC_SOL_VIS');
2873: FND_MSG_PUB.ADD;
2874: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2875: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

Line 2873: FND_MSG_PUB.ADD;

2869: p_data => X_MSG_DATA);
2870: WHEN INV_SEC_SOLN_VIS THEN
2871: FND_MSG_PUB.initialize;
2872: FND_MESSAGE.set_name('CS', 'CS_KB_INV_SEC_SOL_VIS');
2873: FND_MSG_PUB.ADD;
2874: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2875: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
2876: p_count => X_MSG_COUNT,
2877: p_data => X_MSG_DATA);

Line 2875: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

2871: FND_MSG_PUB.initialize;
2872: FND_MESSAGE.set_name('CS', 'CS_KB_INV_SEC_SOL_VIS');
2873: FND_MSG_PUB.ADD;
2874: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2875: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
2876: p_count => X_MSG_COUNT,
2877: p_data => X_MSG_DATA);
2878: WHEN INV_SEC_STMT_VIS THEN
2879: FND_MSG_PUB.initialize;

Line 2879: FND_MSG_PUB.initialize;

2875: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
2876: p_count => X_MSG_COUNT,
2877: p_data => X_MSG_DATA);
2878: WHEN INV_SEC_STMT_VIS THEN
2879: FND_MSG_PUB.initialize;
2880: FND_MESSAGE.set_name('CS', 'CS_KB_INV_SEC_STM_VIS');
2881: FND_MSG_PUB.ADD;
2882: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2883: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

Line 2881: FND_MSG_PUB.ADD;

2877: p_data => X_MSG_DATA);
2878: WHEN INV_SEC_STMT_VIS THEN
2879: FND_MSG_PUB.initialize;
2880: FND_MESSAGE.set_name('CS', 'CS_KB_INV_SEC_STM_VIS');
2881: FND_MSG_PUB.ADD;
2882: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2883: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
2884: p_count => X_MSG_COUNT,
2885: p_data => X_MSG_DATA);

Line 2883: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

2879: FND_MSG_PUB.initialize;
2880: FND_MESSAGE.set_name('CS', 'CS_KB_INV_SEC_STM_VIS');
2881: FND_MSG_PUB.ADD;
2882: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2883: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
2884: p_count => X_MSG_COUNT,
2885: p_data => X_MSG_DATA);
2886:
2887: WHEN OTHERS THEN

Line 2894: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

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,
2895: p_data => x_msg_data);
2896:
2897: END GET_SECURITY_PROFILES;
2898:

Line 3165: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

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 ;
3165: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
3166: p_data => x_msg_data);
3167: END MOVE_CATEGORY_IN_DENORM;
3168:
3169: END CS_KB_SECURITY_PVT;