APPS.CS_KB_SECURITY_PVT dependencies on FND_API

Line 181: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

177:
178: BEGIN
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);

Line 312: --X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

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:
314: CS_KB_SYNC_INDEX_PKG.request_mark_idx_on_sec_change
315: ( 'ADD_VIS',
316: l_position,

Line 321: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

317: null,
318: l_request_id,
319: l_return_status );
320:
321: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
322: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
323: ELSE
324: RAISE INDEX_SYNC_FAILED;
325: END IF;

Line 322: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

318: l_request_id,
319: l_return_status );
320:
321: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
322: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
323: ELSE
324: RAISE INDEX_SYNC_FAILED;
325: END IF;
326:

Line 351: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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);
355:

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 365: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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);
369:

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 378: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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);
382:

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 389: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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

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 401: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 481: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

477:
478: BEGIN
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);

Line 545: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

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;
546: END IF; -- Update Successful Check
547:
548: END IF; --Validate duplicate Visibility Name
549:

Line 568: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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);
572:

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 581: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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);
585:

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 594: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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);
598:

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 606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 682: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

678: l_current_user NUMBER := FND_GLOBAL.user_id;
679:
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);

Line 734: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

730: null,
731: l_request_id,
732: l_return_status );
733:
734: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
735: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
736: ELSE
737: RAISE INDEX_SYNC_FAILED;
738: END IF;

Line 735: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

731: l_request_id,
732: l_return_status );
733:
734: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
735: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
736: ELSE
737: RAISE INDEX_SYNC_FAILED;
738: END IF;
739:

Line 742: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

738: END IF;
739:
740:
741: ELSE
742: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
743: RAISE DELETE_FAILED;
744: END IF;
745: END IF;
746:

Line 763: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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);
767: WHEN UNABLE_TO_DELETE_VIS THEN

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 775: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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);
779: WHEN DELETE_FAILED THEN

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 788: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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);
792: WHEN INDEX_SYNC_FAILED THEN

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 798: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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

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 810: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 947: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

943:
944: BEGIN
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);

Line 1013: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

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;
1014: END IF; -- Insert Successful Check
1015: END IF; -- Check Name Dup
1016: END IF;
1017:

Line 1033: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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);
1037:

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 1046: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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);
1050:

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 1059: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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);
1063:

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 1071: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1145: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

1141: AND NAME = P_NAME;
1142:
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);

Line 1202: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

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;
1203: END IF; -- Update Successful Check
1204: END IF; -- Check Name Dup
1205:
1206: END IF; -- Valid Params Passed

Line 1222: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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);
1226:

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 1235: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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);
1239:

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 1248: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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);
1252: WHEN OTHERS THEN

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 1259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1320: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

1316: l_valid NUMBER;
1317:
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);

Line 1359: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1355: OPEN CHECK_DELETE;
1356: FETCH CHECK_DELETE INTO l_valid;
1357: CLOSE CHECK_DELETE;
1358: IF l_valid = 0 THEN
1359: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1360: ELSE
1361: RAISE DELETE_FAILED;
1362: END IF;
1363:

Line 1384: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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);
1388:

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 1397: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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);
1401:

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 1410: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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);
1414:

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 1424: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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);
1428:

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 1438: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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);
1442:

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 1450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1604: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

1600:
1601: BEGIN
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);

Line 1700: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1696: l_return_status );
1697: --dbms_output.put_line('sync success-'||l_return_status||l_request_id);
1698:
1699:
1700: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1701: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1702: ELSE
1703: RAISE INDEX_SYNC_FAILED;
1704: END IF;

Line 1701: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1697: --dbms_output.put_line('sync success-'||l_return_status||l_request_id);
1698:
1699:
1700: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1701: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1702: ELSE
1703: RAISE INDEX_SYNC_FAILED;
1704: END IF;
1705:

Line 1729: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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);
1733:

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 1743: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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);
1747:

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 1758: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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);
1762:

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 1769: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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

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 1781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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 ;
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;

Line 1835: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

1831: l_return_status VARCHAR2(1);
1832:
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);

Line 1862: --X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1858: IF l_valid = 0 THEN
1859: --Remove FK records for Member + Children from CS_KB_CAT_GROUP_DENORM
1860: REMOVE_CG_MEMBER_FROM_DENORM ( P_CATEGORY_GROUP_ID, P_CATEGORY_ID);
1861:
1862: --X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1863: CS_KB_SYNC_INDEX_PKG.request_mark_idx_on_sec_change
1864: ( 'REM_CAT_FROM_CAT_GRP',
1865: P_CATEGORY_GROUP_ID,
1866: P_CATEGORY_ID,

Line 1870: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1866: P_CATEGORY_ID,
1867: l_request_id,
1868: l_return_status );
1869:
1870: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1871: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1872: ELSE
1873: RAISE INDEX_SYNC_FAILED;
1874: END IF;

Line 1871: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1867: l_request_id,
1868: l_return_status );
1869:
1870: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1871: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1872: ELSE
1873: RAISE INDEX_SYNC_FAILED;
1874: END IF;
1875:

Line 1879: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

1875:
1876:
1877:
1878: ELSE
1879: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1880: RAISE DELETE_FAILED;
1881: END IF;
1882:
1883: ELSE

Line 1885: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1881: END IF;
1882:
1883: ELSE
1884: -- Else Row already Deleted - ignore and return Successful
1885: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1886: END IF;
1887:
1888: END IF; -- Valid Param Check
1889:

Line 1905: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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);
1909: WHEN DELETE_FAILED THEN

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 1917: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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);
1921:

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 1928: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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

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 1940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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 ;
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;

Line 2174: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

2170: l_login NUMBER := FND_GLOBAL.login_id;
2171:
2172: BEGIN
2173: SAVEPOINT Add_Cat_To_Denorm_PVT;
2174: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2175:
2176: -- Validate Category
2177: OPEN Validate_Category;
2178: FETCH Validate_Category INTO l_cat_valid;

Line 2222: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

2218: l_login
2219: );
2220: --END LOOP;
2221:
2222: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2223:
2224: ELSE
2225: RAISE INVALID_IN_PARAMETERS;
2226: END IF;

Line 2243: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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);
2247:

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 2255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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 ;
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:

Line 2314: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

2310: l_login NUMBER := FND_GLOBAL.login_id;
2311:
2312: BEGIN
2313: SAVEPOINT Upd_Cat_To_Denorm_PVT;
2314: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2315:
2316: OPEN Validate_Category;
2317: FETCH Validate_Category INTO l_cat_id, l_vis_id;
2318: CLOSE Validate_Category;

Line 2337: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

2333: Last_Update_Login = l_login
2334: WHERE Child_Category_Id = P_CATEGORY_ID
2335: AND Visibility_id <> P_VISIBILITY_ID;
2336:
2337: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2338:
2339: ELSE
2340: RAISE INVALID_IN_PARAMETERS;
2341: END IF;

Line 2357: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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);
2361:

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 2369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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 ;
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:

Line 2421: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

2417: l_member_count NUMBER;
2418:
2419: BEGIN
2420: SAVEPOINT Remove_Cat_From_Cat_Grp_PVT;
2421: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2422:
2423: IF P_CATEGORY_ID IS NOT NULL THEN
2424: -- 1. Removes Category from Members table if the Category Exists
2425: DELETE FROM CS_KB_CAT_GROUP_MEMBERS

Line 2440: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

2436: FETCH Check_Delete_Denorm INTO l_denorm_count;
2437: CLOSE Check_Delete_Denorm;
2438:
2439: IF l_member_count = 0 AND l_denorm_count = 0 THEN
2440: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2441: ELSE
2442: RAISE DELETE_FAILED;
2443: END IF;
2444:

Line 2458: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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);
2462:

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 2472: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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);
2476:

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 2484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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 ;
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:

Line 2832: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

2828: l_Soln_Vis_Position NUMBER;
2829: l_Stmt_Vis_Position NUMBER;
2830:
2831: BEGIN
2832: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2833:
2834: l_cat_group_id := Get_Category_Group_id;
2835:
2836: IF l_cat_group_id is null THEN

Line 2851: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

2847:
2848: IF l_Stmt_Vis_Position is null THEN
2849: RAISE INV_SEC_STMT_VIS;
2850: ELSE
2851: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2852: X_CATEGORY_GROUP_ID := l_cat_group_id;
2853: X_SOLN_VISIBILITY_POSITION := l_Soln_Vis_Position;
2854: X_STMT_VISIBILITY_POSITION := l_Stmt_Vis_Position;
2855: END IF;

Line 2866: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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);
2870: WHEN INV_SEC_SOLN_VIS THEN

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 2874: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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);
2878: WHEN INV_SEC_STMT_VIS THEN

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 2882: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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);
2886:

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 2893: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 3097: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

3093: BEGIN
3094:
3095: SAVEPOINT Move_Cat_In_Denorm_PVT;
3096:
3097: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3098:
3099:
3100: -- Firstly Delete all the Records in the Denorm Table For the Moved
3101: -- Catageory and its Children except where this Category has been directly

Line 3134: IF l_ret_status <> FND_API.G_RET_STS_SUCCESS THEN

3130: X_RETURN_STATUS => l_ret_status,
3131: X_MSG_DATA => l_msg_data,
3132: X_MSG_COUNT => l_msg_count );
3133:
3134: IF l_ret_status <> FND_API.G_RET_STS_SUCCESS THEN
3135: RAISE UPDATE_FAILED;
3136: END IF;
3137:
3138: END LOOP;

Line 3140: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

3136: END IF;
3137:
3138: END LOOP;
3139:
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

Line 3164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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 ;
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: