1309: p_user_name
1310: Creator :
1311: ashankar 05-05-04
1312: Note: This API is called from VB part.. so don't change the exception block.
1313: Any exception raised will be logged into BSC_Messages and will be checked in
1314: VB part.
1315: /***********************************************************************************/
1316:
1317:
1417:
1418:
1419: EXCEPTION
1420: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1421: BSC_MESSAGE.Add
1422: ( x_message => SQLERRM
1423: , x_source => 'BSC_SCORECARD_PVT.Insert_Scorecard_Grants'
1424: , x_mode => 'I'
1425: );
1425: );
1426:
1427:
1428: WHEN FND_API.G_EXC_ERROR THEN
1429: BSC_MESSAGE.Add
1430: ( x_message => SQLERRM
1431: , x_source => 'BSC_SCORECARD_PVT.Insert_Scorecard_Grants'
1432: , x_mode => 'I'
1433: );
1432: , x_mode => 'I'
1433: );
1434:
1435: WHEN OTHERS THEN
1436: BSC_MESSAGE.Add
1437: ( x_message => SQLERRM
1438: , x_source => 'BSC_SCORECARD_PVT.Insert_Scorecard_Grants'
1439: , x_mode => 'I'
1440: );
1451: p_user_name
1452: Creator :
1453: ashankar 05-05-04
1454: Note: This API is called from VB and PMD part.. so don't change the exception block.
1455: Any exception raised will be logged into BSC_Messages and will be checked in
1456: VB part.
1457: /***********************************************************************************/
1458:
1459: PROCEDURE Remove_Scorecard_Grants
1512: AND PROGRAM_NAME = 'BSC_PMD_GRANTS';
1513:
1514: EXCEPTION
1515: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1516: BSC_MESSAGE.Add
1517: (
1518: x_message => SQLERRM
1519: , x_source => 'BSC_SCORECARD_PVT.Remove_Scorecard_Grants'
1520: , x_mode => 'I'
1520: , x_mode => 'I'
1521: );
1522:
1523: WHEN OTHERS THEN
1524: BSC_MESSAGE.Add
1525: (
1526: x_message => SQLERRM
1527: , x_source => 'BSC_SCORECARD_PVT.Remove_Scorecard_Grants'
1528: , x_mode => 'I'
1558: COMMIT;
1559: END IF;
1560: EXCEPTION
1561: when others then
1562: BSC_MESSAGE.Add(x_message => sqlerrm,
1563: x_source => 'reovkeaccess',
1564: x_mode => 'I');
1565:
1566: