DBA Data[Home] [Help]

APPS.BSC_MO_UI_PKG dependencies on FND_API

Line 1380: x_return_status := FND_API.G_RET_STS_SUCCESS;

1376: BEGIN
1377: --DBMS_OUTPUT.PUT_LINE('checkSystemLock');
1378: SAVEPOINT BSCMOUIPKGCheckSystemLock;
1379: FND_MSG_PUB.Initialize;
1380: x_return_status := FND_API.G_RET_STS_SUCCESS;
1381:
1382: IF (p_all_objectives = 1) THEN
1383: FOR cobj IN c_get_all_objectives(p_process_id) LOOP
1384: BSC_LOCKS_PUB.CHECK_SYSTEM_LOCK

Line 1395: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1391: ,x_return_status => x_return_status
1392: ,x_msg_count => x_msg_count
1393: ,x_msg_data => x_msg_data
1394: );
1395: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1396: ROLLBACK TO BSCMOUIPKGCheckSystemLock;
1397: EXIT;
1398: END IF;
1399: END LOOP;

Line 1413: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1409: ,x_return_status => x_return_status
1410: ,x_msg_count => x_msg_count
1411: ,x_msg_data => x_msg_data
1412: );
1413: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1414: ROLLBACK TO BSCMOUIPKGCheckSystemLock;
1415: EXIT;
1416: END IF;
1417: END LOOP;

Line 1421: WHEN FND_API.G_EXC_ERROR THEN

1417: END LOOP;
1418: END IF;
1419:
1420: EXCEPTION
1421: WHEN FND_API.G_EXC_ERROR THEN
1422: ROLLBACK TO BSCMOUIPKGCheckSystemLock;
1423: x_return_status := FND_API.G_RET_STS_ERROR;
1424: FND_MSG_PUB.Count_And_Get(
1425: p_encoded => 'F'

Line 1423: x_return_status := FND_API.G_RET_STS_ERROR;

1419:
1420: EXCEPTION
1421: WHEN FND_API.G_EXC_ERROR THEN
1422: ROLLBACK TO BSCMOUIPKGCheckSystemLock;
1423: x_return_status := FND_API.G_RET_STS_ERROR;
1424: FND_MSG_PUB.Count_And_Get(
1425: p_encoded => 'F'
1426: ,p_count => x_msg_count
1427: ,p_data => x_msg_data

Line 1429: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1425: p_encoded => 'F'
1426: ,p_count => x_msg_count
1427: ,p_data => x_msg_data
1428: );
1429: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1430: ROLLBACK TO BSCMOUIPKGCheckSystemLock;
1431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1432: FND_MSG_PUB.Count_And_Get(
1433: p_encoded => 'F'

Line 1431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1427: ,p_data => x_msg_data
1428: );
1429: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1430: ROLLBACK TO BSCMOUIPKGCheckSystemLock;
1431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1432: FND_MSG_PUB.Count_And_Get(
1433: p_encoded => 'F'
1434: ,p_count => x_msg_count
1435: ,p_data => x_msg_data

Line 1444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1440: G_PKG_NAME,
1441: l_api_name,
1442: SQLERRM
1443: );
1444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1445: FND_MSG_PUB.Count_And_Get(
1446: p_encoded => 'F'
1447: ,p_count => x_msg_count
1448: ,p_data => x_msg_data

Line 1495: x_return_status := FND_API.G_RET_STS_SUCCESS;

1491: BEGIN
1492: --DBMS_OUTPUT.PUT_LINE('getSystemLock');
1493: SAVEPOINT BSCMOUIPKGGetSystemLock;
1494: FND_MSG_PUB.Initialize;
1495: x_return_status := FND_API.G_RET_STS_SUCCESS;
1496:
1497: IF (p_all_objectives = 1) THEN
1498: FOR cobj IN c_get_all_objectives(p_process_id) LOOP
1499: BSC_LOCKS_PUB.GET_SYSTEM_LOCK

Line 1512: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1508: ,x_return_status => x_return_status
1509: ,x_msg_count => x_msg_count
1510: ,x_msg_data => x_msg_data
1511: );
1512: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1513: ROLLBACK TO BSCMOUIPKGGetSystemLock;
1514: EXIT;
1515: END IF;
1516: END LOOP;

Line 1532: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1528: ,x_return_status => x_return_status
1529: ,x_msg_count => x_msg_count
1530: ,x_msg_data => x_msg_data
1531: );
1532: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1533: ROLLBACK TO BSCMOUIPKGGetSystemLock;
1534: EXIT;
1535: END IF;
1536: END LOOP;

Line 1540: WHEN FND_API.G_EXC_ERROR THEN

1536: END LOOP;
1537: END IF;
1538:
1539: EXCEPTION
1540: WHEN FND_API.G_EXC_ERROR THEN
1541: ROLLBACK TO BSCMOUIPKGGetSystemLock;
1542: x_return_status := FND_API.G_RET_STS_ERROR;
1543: FND_MSG_PUB.Count_And_Get(
1544: p_encoded => 'F'

Line 1542: x_return_status := FND_API.G_RET_STS_ERROR;

1538:
1539: EXCEPTION
1540: WHEN FND_API.G_EXC_ERROR THEN
1541: ROLLBACK TO BSCMOUIPKGGetSystemLock;
1542: x_return_status := FND_API.G_RET_STS_ERROR;
1543: FND_MSG_PUB.Count_And_Get(
1544: p_encoded => 'F'
1545: ,p_count => x_msg_count
1546: ,p_data => x_msg_data

Line 1548: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1544: p_encoded => 'F'
1545: ,p_count => x_msg_count
1546: ,p_data => x_msg_data
1547: );
1548: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1549: ROLLBACK TO BSCMOUIPKGGetSystemLock;
1550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1551: FND_MSG_PUB.Count_And_Get(
1552: p_encoded => 'F'

Line 1550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1546: ,p_data => x_msg_data
1547: );
1548: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1549: ROLLBACK TO BSCMOUIPKGGetSystemLock;
1550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1551: FND_MSG_PUB.Count_And_Get(
1552: p_encoded => 'F'
1553: ,p_count => x_msg_count
1554: ,p_data => x_msg_data

Line 1563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1559: G_PKG_NAME,
1560: l_api_name,
1561: SQLERRM
1562: );
1563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1564: FND_MSG_PUB.Count_And_Get(
1565: p_encoded => 'F'
1566: ,p_count => x_msg_count
1567: ,p_data => x_msg_data