APPS.FPA_PROCESS_PVT dependencies on FPA_UTILITIES_PVT

Line 6: G_APP_NAME CONSTANT VARCHAR2(3) := FPA_UTILITIES_PVT.G_APP_NAME;

2: /* $Header: FPAVPRCB.pls 120.9 2006/05/05 16:05:19 appldev noship $ */
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(200) := 'FPA_PROCESS_PVT';
6: G_APP_NAME CONSTANT VARCHAR2(3) := FPA_UTILITIES_PVT.G_APP_NAME;
7: G_API_TYPE CONSTANT VARCHAR2(4) := '_PVT';
8: L_API_NAME CONSTANT VARCHAR2(35) := 'PROCESS';
9:
10:

Line 213: 'Calling Fpa_Utilities_Pvt.attach_AW.'

209: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
210: FND_LOG.String
211: ( FND_LOG.LEVEL_PROCEDURE,
212: 'fpa.sql.FPA_Process_Pvt.Create_Pc',
213: 'Calling Fpa_Utilities_Pvt.attach_AW.'
214: );
215: END IF;
216:
217: -- Attach AW Workspace

Line 218: Fpa_Utilities_Pvt.attach_AW

214: );
215: END IF;
216:
217: -- Attach AW Workspace
218: Fpa_Utilities_Pvt.attach_AW
219: (
220: p_api_version => 1.0,
221: p_attach_mode => 'rw',
222: x_return_status => x_return_status,

Line 666: 'CAlling Fpa_Utilities_Pvt.detach_AW.'

662: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
663: FND_LOG.String
664: ( FND_LOG.LEVEL_PROCEDURE,
665: 'fpa.sql.FPA_Process_Pvt.Create_Pc.begin',
666: 'CAlling Fpa_Utilities_Pvt.detach_AW.'
667: );
668: END IF;
669:
670: -- Detach AW Workspace

Line 671: Fpa_Utilities_Pvt.detach_AW

667: );
668: END IF;
669:
670: -- Detach AW Workspace
671: Fpa_Utilities_Pvt.detach_AW
672: (
673: p_api_version => 1.0,
674: x_return_status => x_return_status,
675: x_msg_count => x_msg_count,

Line 708: Fpa_Utilities_Pvt.detach_AW

704: FND_MESSAGE.SET_TOKEN('SQL_ERR_CODE', SQLCODE);
705: FND_MESSAGE.SET_TOKEN('SQL_ERR_MSG', SQLERRM);
706: FND_MSG_PUB.ADD;
707: -- Detach AW Workspace
708: Fpa_Utilities_Pvt.detach_AW
709: (
710: p_api_version => 1.0,
711: x_return_status => x_return_status,
712: x_msg_count => x_msg_count,

Line 785: 'Calling Fpa_Utilities_Pvt.attach_AW'

781: FND_LOG.String
782: (
783: FND_LOG.LEVEL_PROCEDURE,
784: 'fpa.sql.FPA_Process_Pvt.Update_Pc',
785: 'Calling Fpa_Utilities_Pvt.attach_AW'
786: );
787: END IF;
788:
789: -- Attach AW Workspace

Line 790: Fpa_Utilities_Pvt.attach_AW

786: );
787: END IF;
788:
789: -- Attach AW Workspace
790: Fpa_Utilities_Pvt.attach_AW
791: (
792: p_api_version => 1.0,
793: p_attach_mode => 'rw',
794: x_return_status => x_return_status,

Line 1018: 'Calling Fpa_Utilities_Pvt.detach_AW.'

1014: FND_LOG.String
1015: (
1016: FND_LOG.LEVEL_PROCEDURE,
1017: 'fpa.sql.FPA_Process_Pvt.Update_Pc',
1018: 'Calling Fpa_Utilities_Pvt.detach_AW.'
1019: );
1020: END IF;
1021:
1022: Fpa_Utilities_Pvt.detach_AW

Line 1022: Fpa_Utilities_Pvt.detach_AW

1018: 'Calling Fpa_Utilities_Pvt.detach_AW.'
1019: );
1020: END IF;
1021:
1022: Fpa_Utilities_Pvt.detach_AW
1023: (
1024: p_api_version => 1.0,
1025: x_return_status => x_return_status,
1026: x_msg_count => x_msg_count,

Line 1049: Fpa_Utilities_Pvt.detach_AW

1045: FND_MESSAGE.SET_TOKEN('SQL_ERR_MSG', SQLERRM);
1046: FND_MSG_PUB.ADD;
1047: ROLLBACK;
1048: -- Detach AW Workspace
1049: Fpa_Utilities_Pvt.detach_AW
1050: (
1051: p_api_version => 1.0,
1052: x_return_status => x_return_status,
1053: x_msg_count => x_msg_count,

Line 1125: 'Value of l_last_pc_id ='||l_last_pc_id||', Calling Fpa_Utilities_Pvt.attach_AW'

1121: FND_LOG.String
1122: (
1123: FND_LOG.LEVEL_PROCEDURE,
1124: 'fpa.sql.FPA_Process_Pvt.Set_Pc_Initiate.begin',
1125: 'Value of l_last_pc_id ='||l_last_pc_id||', Calling Fpa_Utilities_Pvt.attach_AW'
1126: );
1127: END IF;
1128: -- Attach AW Workspace
1129: Fpa_Utilities_Pvt.attach_AW

Line 1129: Fpa_Utilities_Pvt.attach_AW

1125: 'Value of l_last_pc_id ='||l_last_pc_id||', Calling Fpa_Utilities_Pvt.attach_AW'
1126: );
1127: END IF;
1128: -- Attach AW Workspace
1129: Fpa_Utilities_Pvt.attach_AW
1130: (
1131: p_api_version => 1.0,
1132: p_attach_mode => 'rw',
1133: x_return_status => x_return_status,

Line 1267: 'Calling Fpa_Utilities_Pvt.detach_AW'

1263: FND_LOG.String
1264: (
1265: FND_LOG.LEVEL_PROCEDURE,
1266: 'fpa.sql.FPA_Process_Pvt.Set_Pc_Initiate.begin',
1267: 'Calling Fpa_Utilities_Pvt.detach_AW'
1268: );
1269: END IF;
1270: -- Detach AW Workspace
1271: Fpa_Utilities_Pvt.detach_AW

Line 1271: Fpa_Utilities_Pvt.detach_AW

1267: 'Calling Fpa_Utilities_Pvt.detach_AW'
1268: );
1269: END IF;
1270: -- Detach AW Workspace
1271: Fpa_Utilities_Pvt.detach_AW
1272: (
1273: p_api_version => 1.0,
1274: x_return_status => x_return_status,
1275: x_msg_count => x_msg_count,

Line 1298: Fpa_Utilities_Pvt.detach_AW

1294: FND_MESSAGE.SET_TOKEN('SQL_ERR_MSG', SQLERRM);
1295: FND_MSG_PUB.ADD;
1296: ROLLBACK;
1297: -- Detach AW Workspace
1298: Fpa_Utilities_Pvt.detach_AW
1299: (
1300: p_api_version => 1.0,
1301: x_return_status => x_return_status,
1302: x_msg_count => x_msg_count,

Line 1467: Fpa_Utilities_Pvt.attach_AW

1463: 'fpa.sql.fpa_process_pvt.create_portfolio',
1464: 'Attaching OLAP workspace: '
1465: );
1466: END IF;
1467: Fpa_Utilities_Pvt.attach_AW
1468: (
1469: p_api_version => 1.0,
1470: p_attach_mode => 'rw',
1471: x_return_status => x_return_status,

Line 1513: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR

1509: x_msg_count
1510:
1511: );
1512:
1513: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR
1514: or x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
1515: l_msg_log := portfolio_rec.portfolio_id;
1516: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
1517: end if;

Line 1514: or x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then

1510:
1511: );
1512:
1513: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR
1514: or x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
1515: l_msg_log := portfolio_rec.portfolio_id;
1516: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
1517: end if;
1518:

Line 1516: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;

1512:
1513: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR
1514: or x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
1515: l_msg_log := portfolio_rec.portfolio_id;
1516: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
1517: end if;
1518:
1519: IF p_portfolio_obj.portfolio_users IS NOT NULL then
1520: -- Create or update the access list users

Line 1529: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR

1525: x_msg_data,
1526: x_msg_count
1527: );
1528:
1529: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR
1530: or x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
1531: l_msg_log := portfolio_rec.portfolio_id;
1532: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
1533: end if;

Line 1530: or x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then

1526: x_msg_count
1527: );
1528:
1529: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR
1530: or x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
1531: l_msg_log := portfolio_rec.portfolio_id;
1532: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
1533: end if;
1534:

Line 1532: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;

1528:
1529: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR
1530: or x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
1531: l_msg_log := portfolio_rec.portfolio_id;
1532: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
1533: end if;
1534:
1535: END IF;
1536:

Line 1554: Fpa_Utilities_Pvt.detach_AW

1550: 'Detaching OLAP workspace: '
1551: );
1552: END IF;
1553: -- Detach AW Workspace
1554: Fpa_Utilities_Pvt.detach_AW
1555: (
1556: p_api_version => 1.0,
1557: x_return_status => x_return_status,
1558: x_msg_count => x_msg_count,

Line 1572: WHEN FPA_UTILITIES_PVT.G_EXCEPTION_ERROR THEN

1568: );
1569: END IF;
1570:
1571: EXCEPTION
1572: WHEN FPA_UTILITIES_PVT.G_EXCEPTION_ERROR THEN
1573:
1574: ROLLBACK;
1575:
1576: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1581: 'fpa_process_pvt.create_portfolio, FPA_UTILITIES_PVT.G_EXCEPTION_ERROR '||l_msg_log,

1577: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1578: fnd_log.string
1579: (
1580: FND_LOG.LEVEL_ERROR,
1581: 'fpa_process_pvt.create_portfolio, FPA_UTILITIES_PVT.G_EXCEPTION_ERROR '||l_msg_log,
1582: SQLERRM
1583: );
1584: END IF;
1585:

Line 1613: Fpa_Utilities_Pvt.detach_AW

1609: FND_MESSAGE.SET_TOKEN('SQL_ERR_CODE', SQLCODE);
1610: FND_MESSAGE.SET_TOKEN('SQL_ERR_MSG', SQLERRM);
1611: FND_MSG_PUB.ADD;
1612: -- Detach AW Workspace
1613: Fpa_Utilities_Pvt.detach_AW
1614: (
1615: p_api_version => 1.0,
1616: x_return_status => x_return_status,
1617: x_msg_count => x_msg_count,

Line 1673: Fpa_Utilities_Pvt.attach_AW

1669: 'fpa.sql.fpa_process_pvt.Delete_Portfolio',
1670: 'Attaching OLAP workspace: '
1671: );
1672: END IF;
1673: Fpa_Utilities_Pvt.attach_AW
1674: (
1675: p_api_version => 1.0,
1676: p_attach_mode => 'rw',
1677: x_return_status => x_return_status,

Line 1711: Fpa_Utilities_Pvt.detach_AW

1707: 'Detaching OLAP workspace: '
1708: );
1709: END IF;
1710: -- Detach AW Workspace
1711: Fpa_Utilities_Pvt.detach_AW
1712: (
1713: p_api_version => 1.0,
1714: x_return_status => x_return_status,
1715: x_msg_count => x_msg_count,

Line 1738: Fpa_Utilities_Pvt.detach_AW

1734: FND_MESSAGE.SET_TOKEN('SQL_ERR_CODE', SQLCODE);
1735: FND_MESSAGE.SET_TOKEN('SQL_ERR_MSG', SQLERRM);
1736: FND_MSG_PUB.ADD;
1737: -- Detach AW Workspace
1738: Fpa_Utilities_Pvt.detach_AW
1739: (
1740: p_api_version => 1.0,
1741: x_return_status => x_return_status,
1742: x_msg_count => x_msg_count,

Line 1836: Fpa_Utilities_Pvt.attach_AW

1832: 'fpa.sql.fpa_process_pvt.update_portfolio',
1833: 'Attaching OLAP workspace: '
1834: );
1835: END IF;
1836: Fpa_Utilities_Pvt.attach_AW
1837: (
1838: p_api_version => 1.0,
1839: p_attach_mode => 'rw',
1840: x_return_status => x_return_status,

Line 1918: Fpa_Utilities_Pvt.detach_AW

1914: 'Detaching OLAP workspace: '
1915: );
1916: END IF;
1917: -- Detach AW Workspace
1918: Fpa_Utilities_Pvt.detach_AW
1919: (
1920: p_api_version => 1.0,
1921: x_return_status => x_return_status,
1922: x_msg_count => x_msg_count,

Line 1963: Fpa_Utilities_Pvt.detach_AW

1959: FND_MESSAGE.SET_TOKEN('SQL_ERR_CODE', SQLCODE);
1960: FND_MESSAGE.SET_TOKEN('SQL_ERR_MSG', SQLERRM);
1961: FND_MSG_PUB.ADD;
1962: -- Detach AW Workspace
1963: Fpa_Utilities_Pvt.detach_AW
1964: (
1965: p_api_version => 1.0,
1966: x_return_status => x_return_status,
1967: x_msg_count => x_msg_count,

Line 2058: Fpa_Utilities_Pvt.detach_AW

2054: FND_MESSAGE.SET_TOKEN('SQL_ERR_CODE', SQLCODE);
2055: FND_MESSAGE.SET_TOKEN('SQL_ERR_MSG', SQLERRM);
2056: FND_MSG_PUB.ADD;
2057: -- Detach AW Workspace
2058: Fpa_Utilities_Pvt.detach_AW
2059: (
2060: p_api_version => 1.0,
2061: x_return_status => x_return_status,
2062: x_msg_count => x_msg_count,

Line 2135: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

2131: 'Entering fpa_process_pvt.create_update_access_list'
2132: );
2133: END IF;
2134:
2135: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
2136:
2137: x_return_status := FPA_UTILITIES_PVT.START_ACTIVITY(
2138: p_api_name => l_api_name,
2139: p_pkg_name => G_PKG_NAME,

Line 2137: x_return_status := FPA_UTILITIES_PVT.START_ACTIVITY(

2133: END IF;
2134:
2135: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
2136:
2137: x_return_status := FPA_UTILITIES_PVT.START_ACTIVITY(
2138: p_api_name => l_api_name,
2139: p_pkg_name => G_PKG_NAME,
2140: p_init_msg_list => 'T',
2141: l_api_version => l_api_version,

Line 2148: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then

2144: p_msg_log => 'Entering fpa_process_pvt.create_update_access_list.begin',
2145: x_return_status => x_return_status);
2146:
2147: -- check if activity started successfully
2148: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
2149: l_msg_log := 'start_activity';
2150: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
2151: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
2152: l_msg_log := 'start_activity';

Line 2150: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;

2146:
2147: -- check if activity started successfully
2148: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
2149: l_msg_log := 'start_activity';
2150: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
2151: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
2152: l_msg_log := 'start_activity';
2153: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
2154: end if;

Line 2151: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then

2147: -- check if activity started successfully
2148: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
2149: l_msg_log := 'start_activity';
2150: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
2151: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
2152: l_msg_log := 'start_activity';
2153: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
2154: end if;
2155:

Line 2153: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;

2149: l_msg_log := 'start_activity';
2150: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
2151: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
2152: l_msg_log := 'start_activity';
2153: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
2154: end if;
2155:
2156:
2157: IF p_portf_users_tbl IS NOT NULL THEN

Line 2199: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then

2195: );
2196:
2197: END IF;
2198:
2199: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
2200: l_msg_log := p_portf_users_tbl(i).project_party_id||','||p_portf_users_tbl(i).role_id;
2201: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
2202: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
2203: l_msg_log := p_portf_users_tbl(i).project_party_id||','||p_portf_users_tbl(i).role_id;

Line 2201: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;

2197: END IF;
2198:
2199: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
2200: l_msg_log := p_portf_users_tbl(i).project_party_id||','||p_portf_users_tbl(i).role_id;
2201: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
2202: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
2203: l_msg_log := p_portf_users_tbl(i).project_party_id||','||p_portf_users_tbl(i).role_id;
2204: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
2205: end if;

Line 2202: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then

2198:
2199: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
2200: l_msg_log := p_portf_users_tbl(i).project_party_id||','||p_portf_users_tbl(i).role_id;
2201: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
2202: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
2203: l_msg_log := p_portf_users_tbl(i).project_party_id||','||p_portf_users_tbl(i).role_id;
2204: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
2205: end if;
2206:

Line 2204: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;

2200: l_msg_log := p_portf_users_tbl(i).project_party_id||','||p_portf_users_tbl(i).role_id;
2201: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
2202: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
2203: l_msg_log := p_portf_users_tbl(i).project_party_id||','||p_portf_users_tbl(i).role_id;
2204: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
2205: end if;
2206:
2207: /*
2208: -- CHECK IF THE SECUCITY CALL IS SUCCESSFUL

Line 2235: FPA_UTILITIES_PVT.END_ACTIVITY(

2231: END IF;
2232:
2233: END IF;
2234:
2235: FPA_UTILITIES_PVT.END_ACTIVITY(
2236: p_api_name => l_api_name,
2237: p_pkg_name => G_PKG_NAME,
2238: p_msg_log => l_msg_log,
2239: x_msg_count => x_msg_count,

Line 2243: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then

2239: x_msg_count => x_msg_count,
2240: x_msg_data => x_msg_data);
2241:
2242: EXCEPTION
2243: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
2244: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
2245: p_api_name => l_api_name,
2246: p_pkg_name => G_PKG_NAME,
2247: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',

Line 2244: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

2240: x_msg_data => x_msg_data);
2241:
2242: EXCEPTION
2243: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
2244: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
2245: p_api_name => l_api_name,
2246: p_pkg_name => G_PKG_NAME,
2247: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',
2248: p_msg_log => l_msg_log,

Line 2247: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',

2243: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
2244: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
2245: p_api_name => l_api_name,
2246: p_pkg_name => G_PKG_NAME,
2247: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',
2248: p_msg_log => l_msg_log,
2249: x_msg_count => x_msg_count,
2250: x_msg_data => x_msg_data,
2251: p_api_type => G_API_TYPE);

Line 2253: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then

2249: x_msg_count => x_msg_count,
2250: x_msg_data => x_msg_data,
2251: p_api_type => G_API_TYPE);
2252:
2253: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
2254: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
2255: p_api_name => l_api_name,
2256: p_pkg_name => G_PKG_NAME,
2257: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',

Line 2254: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

2250: x_msg_data => x_msg_data,
2251: p_api_type => G_API_TYPE);
2252:
2253: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
2254: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
2255: p_api_name => l_api_name,
2256: p_pkg_name => G_PKG_NAME,
2257: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',
2258: p_msg_log => l_msg_log,

Line 2257: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',

2253: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
2254: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
2255: p_api_name => l_api_name,
2256: p_pkg_name => G_PKG_NAME,
2257: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',
2258: p_msg_log => l_msg_log,
2259: x_msg_count => x_msg_count,
2260: x_msg_data => x_msg_data,
2261: p_api_type => G_API_TYPE);

Line 2264: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

2260: x_msg_data => x_msg_data,
2261: p_api_type => G_API_TYPE);
2262:
2263: when OTHERS then
2264: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
2265: p_api_name => l_api_name,
2266: p_pkg_name => G_PKG_NAME,
2267: p_exc_name => 'OTHERS',
2268: p_msg_log => l_msg_log||SQLERRM,

Line 2316: 'Calling Fpa_Utilities_Pvt.attach_AW'

2312: FND_LOG.STRING
2313: (
2314: FND_LOG.LEVEL_PROCEDURE,
2315: 'FPA.SQL.FPA_PROCESS_PVT.Collect_Projects.',
2316: 'Calling Fpa_Utilities_Pvt.attach_AW'
2317: );
2318: END IF;
2319:
2320: -- Attach AW Workspace

Line 2321: Fpa_Utilities_Pvt.attach_AW

2317: );
2318: END IF;
2319:
2320: -- Attach AW Workspace
2321: Fpa_Utilities_Pvt.attach_AW
2322: (
2323: p_api_version => 1.0,
2324: p_attach_mode => 'rw',
2325: x_return_status => x_return_status,

Line 2439: 'Calling Fpa_Utilities_Pvt.detach_AW'

2435: FND_LOG.STRING
2436: (
2437: FND_LOG.LEVEL_PROCEDURE,
2438: 'FPA.SQL.FPA_PROCESS_PVT.Collect_Projects.',
2439: 'Calling Fpa_Utilities_Pvt.detach_AW'
2440: );
2441: END IF;
2442:
2443: Fpa_Utilities_Pvt.detach_AW

Line 2443: Fpa_Utilities_Pvt.detach_AW

2439: 'Calling Fpa_Utilities_Pvt.detach_AW'
2440: );
2441: END IF;
2442:
2443: Fpa_Utilities_Pvt.detach_AW
2444: (
2445: p_api_version => l_api_version,
2446: x_return_status => x_return_status,
2447: x_msg_count => x_msg_count,

Line 2465: Fpa_Utilities_Pvt.detach_AW

2461: WHEN OTHERS THEN
2462: ROLLBACK;
2463:
2464: -- Detach AW Workspace
2465: Fpa_Utilities_Pvt.detach_AW
2466: (
2467: p_api_version => l_api_version,
2468: x_return_status => x_return_status,
2469: x_msg_count => x_msg_count,

Line 2636: Fpa_Utilities_Pvt.attach_AW

2632: end if;
2633:
2634: -- irrespective of the project source, PJT or PJP, AW should be attached R/w here.
2635:
2636: Fpa_Utilities_Pvt.attach_AW
2637: (
2638: p_api_version => 1.0,
2639: p_attach_mode => 'rw',
2640: x_return_status => x_return_status,

Line 3017: Fpa_Utilities_Pvt.detach_AW

3013: COMMIT;
3014: END IF;
3015:
3016: -- Detach AW Workspace
3017: Fpa_Utilities_Pvt.detach_AW
3018: (
3019: p_api_version => l_api_version,
3020: x_return_status => x_return_status,
3021: x_msg_count => x_msg_count,

Line 3039: Fpa_Utilities_Pvt.detach_AW

3035: EXCEPTION
3036: WHEN OTHERS THEN
3037: ROLLBACK;
3038:
3039: Fpa_Utilities_Pvt.detach_AW
3040: (
3041: p_api_version => l_api_version,
3042: x_return_status => x_return_status,
3043: x_msg_count => x_msg_count,

Line 3152: Fpa_Utilities_Pvt.attach_AW

3148: x_msg_count => x_msg_data,
3149: x_msg_data => x_msg_count
3150: );
3151:
3152: Fpa_Utilities_Pvt.attach_AW
3153: (
3154: p_api_version => 1.0,
3155: p_attach_mode => 'rw',
3156: x_return_status => x_return_status,

Line 3294: Fpa_Utilities_Pvt.detach_AW

3290: COMMIT;
3291: END IF;
3292:
3293: -- Detach AW Workspace
3294: Fpa_Utilities_Pvt.detach_AW
3295: (
3296: p_api_version => l_api_version,
3297: x_return_status => x_return_status,
3298: x_msg_count => x_msg_count,

Line 3338: Fpa_Utilities_Pvt.detach_AW

3334: EXCEPTION
3335: WHEN OTHERS THEN
3336: ROLLBACK;
3337:
3338: Fpa_Utilities_Pvt.detach_AW
3339: (
3340: p_api_version => l_api_version,
3341: x_return_status => x_return_status,
3342: x_msg_count => x_msg_count,

Line 3408: Fpa_Utilities_Pvt.attach_AW

3404: open c_class_code;
3405: fetch c_class_code into l_class_code_id;
3406: close c_class_code;
3407:
3408: Fpa_Utilities_Pvt.attach_AW
3409: (
3410: p_api_version => 1.0,
3411: p_attach_mode => 'rw',
3412: x_return_status => x_return_status,

Line 3527: Fpa_Utilities_Pvt.detach_AW

3523: COMMIT;
3524: END IF;
3525:
3526: -- Detach AW Workspace
3527: Fpa_Utilities_Pvt.detach_AW
3528: (
3529: p_api_version => l_api_version,
3530: x_return_status => x_return_status,
3531: x_msg_count => x_msg_count,

Line 3549: Fpa_Utilities_Pvt.detach_AW

3545: WHEN OTHERS THEN
3546: ROLLBACK;
3547:
3548: -- Detach AW Workspace
3549: Fpa_Utilities_Pvt.detach_AW
3550: (
3551: p_api_version => l_api_version,
3552: x_return_status => x_return_status,
3553: x_msg_count => x_msg_count,

Line 3608: Fpa_Utilities_Pvt.attach_AW

3604: 'Attaching OLAP workspace: '
3605: );
3606: END IF;
3607:
3608: Fpa_Utilities_Pvt.attach_AW
3609: (
3610: p_api_version => 1.0,
3611: p_attach_mode => 'rw',
3612: x_return_status => x_return_status,

Line 3645: Fpa_Utilities_Pvt.detach_AW

3641: COMMIT;
3642: END IF;
3643:
3644: -- Detach AW Workspace
3645: Fpa_Utilities_Pvt.detach_AW
3646: (
3647: p_api_version => 1.0,
3648: x_return_status => x_return_status,
3649: x_msg_count => x_msg_count,

Line 3657: Fpa_Utilities_Pvt.detach_AW

3653: EXCEPTION
3654: WHEN OTHERS THEN
3655: ROLLBACK;
3656: -- Detach AW Workspace
3657: Fpa_Utilities_Pvt.detach_AW
3658: (
3659: p_api_version => 1.0,
3660: x_return_status => x_return_status,
3661: x_msg_count => x_msg_count,

Line 3717: Fpa_Utilities_Pvt.attach_AW( p_api_version => 1.0,

3713: 'fpa.sql.fpa_resourcetype_pvt.create_resourcetype',
3714: 'Attaching OLAP workspace: ');
3715: END IF;
3716:
3717: Fpa_Utilities_Pvt.attach_AW( p_api_version => 1.0,
3718: p_attach_mode => 'rw',
3719: x_return_status => x_return_status,
3720: x_msg_count => x_msg_count,
3721: x_msg_data => x_msg_data);

Line 3737: Fpa_Utilities_Pvt.detach_AW(p_api_version => 1.0,

3733: COMMIT;
3734: END IF;
3735:
3736: -- Detach AW Workspace
3737: Fpa_Utilities_Pvt.detach_AW(p_api_version => 1.0,
3738: x_return_status => x_return_status,
3739: x_msg_count => x_msg_count,
3740: x_msg_data => x_msg_data);
3741:

Line 3794: Fpa_Utilities_Pvt.attach_AW

3790: 'Attaching OLAP workspace: '
3791: );
3792: END IF;
3793:
3794: Fpa_Utilities_Pvt.attach_AW
3795: (
3796: p_api_version => 1.0,
3797: p_attach_mode => 'rw',
3798: x_return_status => x_return_status,

Line 3842: Fpa_Utilities_Pvt.detach_AW

3838: COMMIT;
3839: END IF;
3840:
3841: -- Detach AW Workspace
3842: Fpa_Utilities_Pvt.detach_AW
3843: (
3844: p_api_version => 1.0,
3845: x_return_status => x_return_status,
3846: x_msg_count => x_msg_count,

Line 3853: Fpa_Utilities_Pvt.detach_AW

3849:
3850: EXCEPTION
3851: WHEN OTHERS THEN
3852: -- Detach AW Workspace
3853: Fpa_Utilities_Pvt.detach_AW
3854: (
3855: p_api_version => 1.0,
3856: x_return_status => x_return_status,
3857: x_msg_count => x_msg_count,

Line 3895: Fpa_Utilities_Pvt.attach_AW( p_api_version => 1.0,

3891: 'fpa.sql.fpa_process_pvt.delete_strategicobj',
3892: 'Attaching OLAP workspace: ');
3893: END IF;
3894:
3895: Fpa_Utilities_Pvt.attach_AW( p_api_version => 1.0,
3896: p_attach_mode => 'rw',
3897: x_return_status => x_return_status,
3898: x_msg_count => x_msg_count,
3899: x_msg_data => x_msg_data);

Line 3917: Fpa_Utilities_Pvt.detach_AW(p_api_version => 1.0,

3913: COMMIT;
3914: END IF;
3915:
3916: -- Detach AW Workspace
3917: Fpa_Utilities_Pvt.detach_AW(p_api_version => 1.0,
3918: x_return_status => x_return_status,
3919: x_msg_count => x_msg_count,
3920: x_msg_data => x_msg_data);
3921:

Line 3926: Fpa_Utilities_Pvt.detach_AW

3922: EXCEPTION
3923: WHEN OTHERS THEN
3924: ROLLBACK;
3925: -- Detach AW Workspace
3926: Fpa_Utilities_Pvt.detach_AW
3927: (
3928: p_api_version => 1.0,
3929: x_return_status => x_return_status,
3930: x_msg_count => x_msg_count,

Line 4041: Fpa_Utilities_Pvt.attach_AW

4037: );
4038: END IF;
4039:
4040: -- Attach AW Workspace
4041: Fpa_Utilities_Pvt.attach_AW
4042: (
4043: p_api_version => 1.0,
4044: p_attach_mode => 'rw',
4045: x_return_status => x_return_status,

Line 4249: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR

4245: 'End Fpa_Validation_Process_Pvt.Validate_Budget_Versions.end'
4246: );
4247: END IF;
4248:
4249: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR
4250: and FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4251: FND_LOG.STRING
4252: (
4253: FND_LOG.LEVEL_PROCEDURE,

Line 4257: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR

4253: FND_LOG.LEVEL_PROCEDURE,
4254: 'fpa.sql.Fpa_Validation_Process_Pvt.Validate_Budget_Versions',
4255: 'unexpected error - create_scenario.Validate_Budget_Versions'
4256: );
4257: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR
4258: and FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4259: FND_LOG.STRING
4260: (
4261: FND_LOG.LEVEL_PROCEDURE,

Line 4283: Fpa_Utilities_Pvt.detach_AW

4279: );
4280: END IF;
4281:
4282: -- Detach AW Workspace
4283: Fpa_Utilities_Pvt.detach_AW
4284: (
4285: p_api_version => 1.0,
4286: x_return_status => x_return_status,
4287: x_msg_count => x_msg_count,

Line 4302: Fpa_Utilities_Pvt.detach_AW

4298: p_data => x_msg_data
4299: );
4300: WHEN OTHERS THEN
4301: -- Detach AW Workspace
4302: Fpa_Utilities_Pvt.detach_AW
4303: (
4304: p_api_version => 1.0,
4305: x_return_status => x_return_status,
4306: x_msg_count => x_msg_count,

Line 4369: Fpa_Utilities_Pvt.attach_AW

4365: );
4366: END IF;
4367:
4368: -- Attach AW Workspace
4369: Fpa_Utilities_Pvt.attach_AW
4370: (
4371: p_api_version => 1.0,
4372: p_attach_mode => 'rw',
4373: x_return_status => x_return_status,

Line 4487: Fpa_Utilities_Pvt.detach_AW

4483: );
4484: END IF;
4485:
4486: -- Detach AW Workspace
4487: Fpa_Utilities_Pvt.detach_AW
4488: (
4489: p_api_version => 1.0,
4490: x_return_status => x_return_status,
4491: x_msg_count => x_msg_count,

Line 4506: Fpa_Utilities_Pvt.detach_AW

4502: p_data => x_msg_data
4503: );
4504: WHEN OTHERS THEN
4505: -- Detach AW Workspace
4506: Fpa_Utilities_Pvt.detach_AW
4507: (
4508: p_api_version => 1.0,
4509: x_return_status => x_return_status,
4510: x_msg_count => x_msg_count,

Line 4570: Fpa_Utilities_Pvt.attach_AW

4566: );
4567: END IF;
4568:
4569: -- Attach AW Workspace
4570: Fpa_Utilities_Pvt.attach_AW
4571: (
4572: p_api_version => 1.0,
4573: p_attach_mode => 'rw',
4574: x_return_status => x_return_status,

Line 4666: Fpa_Utilities_Pvt.detach_AW

4662: );
4663: END IF;
4664:
4665: -- Detach AW Workspace
4666: Fpa_Utilities_Pvt.detach_AW
4667: (
4668: p_api_version => 1.0,
4669: x_return_status => x_return_status,
4670: x_msg_count => x_msg_count,

Line 4685: Fpa_Utilities_Pvt.detach_AW

4681: p_data => x_msg_data
4682: );
4683: WHEN OTHERS THEN
4684: -- Detach AW Workspace
4685: Fpa_Utilities_Pvt.detach_AW
4686: (
4687: p_api_version => 1.0,
4688: x_return_status => x_return_status,
4689: x_msg_count => x_msg_count,

Line 4738: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

4734:
4735: BEGIN
4736:
4737:
4738: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
4739: -- call START_ACTIVITY to create savepoint, check compatibility
4740: -- and initialize message list
4741:
4742: x_return_status := FPA_UTILITIES_PVT.START_ACTIVITY(

Line 4742: x_return_status := FPA_UTILITIES_PVT.START_ACTIVITY(

4738: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
4739: -- call START_ACTIVITY to create savepoint, check compatibility
4740: -- and initialize message list
4741:
4742: x_return_status := FPA_UTILITIES_PVT.START_ACTIVITY(
4743: p_api_name => l_api_name,
4744: p_pkg_name => G_PKG_NAME,
4745: p_init_msg_list => p_init_msg_list,
4746: l_api_version => l_api_version,

Line 4754: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then

4750: x_return_status => x_return_status);
4751:
4752:
4753: -- check if activity started successfully
4754: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
4755: l_msg_log := 'start_activity';
4756: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
4757: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
4758: l_msg_log := 'start_activity';

Line 4756: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;

4752:
4753: -- check if activity started successfully
4754: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
4755: l_msg_log := 'start_activity';
4756: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
4757: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
4758: l_msg_log := 'start_activity';
4759: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
4760: end if;

Line 4757: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then

4753: -- check if activity started successfully
4754: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
4755: l_msg_log := 'start_activity';
4756: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
4757: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
4758: l_msg_log := 'start_activity';
4759: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
4760: end if;
4761:

Line 4759: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;

4755: l_msg_log := 'start_activity';
4756: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
4757: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
4758: l_msg_log := 'start_activity';
4759: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
4760: end if;
4761:
4762: FPA_UTILITIES_PVT.Attach_AW
4763: (p_api_version => l_api_version,

Line 4762: FPA_UTILITIES_PVT.Attach_AW

4758: l_msg_log := 'start_activity';
4759: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
4760: end if;
4761:
4762: FPA_UTILITIES_PVT.Attach_AW
4763: (p_api_version => l_api_version,
4764: p_attach_mode => 'rw',
4765: x_return_status => x_return_status,
4766: x_msg_count => x_msg_count,

Line 4770: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

4766: x_msg_count => x_msg_count,
4767: x_msg_data => x_msg_data);
4768:
4769:
4770: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
4771:
4772: FPA_PROJECT_PVT.Submit_Project_Aw(
4773: p_api_version => p_api_version,
4774: p_init_msg_list => p_init_msg_list,

Line 4781: FPA_UTILITIES_PVT.Detach_AW

4777: x_return_status => x_return_status,
4778: x_msg_count => x_msg_count,
4779: x_msg_data => x_msg_data);
4780:
4781: FPA_UTILITIES_PVT.Detach_AW
4782: (p_api_version => 1.0,
4783: x_return_status => x_return_status,
4784: x_msg_count => x_msg_count,
4785: x_msg_data => x_msg_data);

Line 4787: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

4783: x_return_status => x_return_status,
4784: x_msg_count => x_msg_count,
4785: x_msg_data => x_msg_data);
4786:
4787: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
4788:
4789: FPA_UTILITIES_PVT.END_ACTIVITY(
4790: p_api_name => l_api_name,
4791: p_pkg_name => G_PKG_NAME,

Line 4789: FPA_UTILITIES_PVT.END_ACTIVITY(

4785: x_msg_data => x_msg_data);
4786:
4787: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
4788:
4789: FPA_UTILITIES_PVT.END_ACTIVITY(
4790: p_api_name => l_api_name,
4791: p_pkg_name => G_PKG_NAME,
4792: p_msg_log => null,
4793: x_msg_count => x_msg_count,

Line 4797: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then

4793: x_msg_count => x_msg_count,
4794: x_msg_data => x_msg_data);
4795:
4796: EXCEPTION
4797: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
4798:
4799: FPA_UTILITIES_PVT.Detach_AW(
4800: p_api_version => l_api_version,
4801: x_return_status => x_return_status,

Line 4799: FPA_UTILITIES_PVT.Detach_AW(

4795:
4796: EXCEPTION
4797: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
4798:
4799: FPA_UTILITIES_PVT.Detach_AW(
4800: p_api_version => l_api_version,
4801: x_return_status => x_return_status,
4802: x_msg_count => x_msg_count,
4803: x_msg_data => x_msg_data);

Line 4805: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

4801: x_return_status => x_return_status,
4802: x_msg_count => x_msg_count,
4803: x_msg_data => x_msg_data);
4804:
4805: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
4806: p_api_name => l_api_name,
4807: p_pkg_name => G_PKG_NAME,
4808: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',
4809: p_msg_log => l_msg_log,

Line 4808: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',

4804:
4805: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
4806: p_api_name => l_api_name,
4807: p_pkg_name => G_PKG_NAME,
4808: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',
4809: p_msg_log => l_msg_log,
4810: x_msg_count => x_msg_count,
4811: x_msg_data => x_msg_data,
4812: p_api_type => G_API_TYPE);

Line 4814: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then

4810: x_msg_count => x_msg_count,
4811: x_msg_data => x_msg_data,
4812: p_api_type => G_API_TYPE);
4813:
4814: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
4815:
4816: FPA_UTILITIES_PVT.Detach_AW(
4817: p_api_version => l_api_version,
4818: x_return_status => x_return_status,

Line 4816: FPA_UTILITIES_PVT.Detach_AW(

4812: p_api_type => G_API_TYPE);
4813:
4814: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
4815:
4816: FPA_UTILITIES_PVT.Detach_AW(
4817: p_api_version => l_api_version,
4818: x_return_status => x_return_status,
4819: x_msg_count => x_msg_count,
4820: x_msg_data => x_msg_data);

Line 4822: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

4818: x_return_status => x_return_status,
4819: x_msg_count => x_msg_count,
4820: x_msg_data => x_msg_data);
4821:
4822: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
4823: p_api_name => l_api_name,
4824: p_pkg_name => G_PKG_NAME,
4825: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',
4826: p_msg_log => l_msg_log,

Line 4825: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',

4821:
4822: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
4823: p_api_name => l_api_name,
4824: p_pkg_name => G_PKG_NAME,
4825: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',
4826: p_msg_log => l_msg_log,
4827: x_msg_count => x_msg_count,
4828: x_msg_data => x_msg_data,
4829: p_api_type => G_API_TYPE);

Line 4833: FPA_UTILITIES_PVT.Detach_AW(

4829: p_api_type => G_API_TYPE);
4830:
4831: when OTHERS then
4832:
4833: FPA_UTILITIES_PVT.Detach_AW(
4834: p_api_version => l_api_version,
4835: x_return_status => x_return_status,
4836: x_msg_count => x_msg_count,
4837: x_msg_data => x_msg_data);

Line 4839: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

4835: x_return_status => x_return_status,
4836: x_msg_count => x_msg_count,
4837: x_msg_data => x_msg_data);
4838:
4839: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
4840: p_api_name => l_api_name,
4841: p_pkg_name => G_PKG_NAME,
4842: p_exc_name => 'OTHERS',
4843: p_msg_log => l_msg_log||SQLERRM,

Line 4869: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

4865: l_msg_log VARCHAR2(200) := null;
4866:
4867: BEGIN
4868:
4869: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
4870: -- call START_ACTIVITY to create savepoint, check compatibility
4871: -- and initialize message list
4872:
4873: x_return_status := FPA_UTILITIES_PVT.START_ACTIVITY(

Line 4873: x_return_status := FPA_UTILITIES_PVT.START_ACTIVITY(

4869: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
4870: -- call START_ACTIVITY to create savepoint, check compatibility
4871: -- and initialize message list
4872:
4873: x_return_status := FPA_UTILITIES_PVT.START_ACTIVITY(
4874: p_api_name => l_api_name,
4875: p_pkg_name => G_PKG_NAME,
4876: p_init_msg_list => p_init_msg_list,
4877: l_api_version => l_api_version,

Line 4885: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then

4881: x_return_status => x_return_status);
4882:
4883:
4884: -- check if activity started successfully
4885: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
4886: l_msg_log := 'start_activity';
4887: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
4888: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
4889: l_msg_log := 'start_activity';

Line 4887: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;

4883:
4884: -- check if activity started successfully
4885: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
4886: l_msg_log := 'start_activity';
4887: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
4888: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
4889: l_msg_log := 'start_activity';
4890: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
4891: end if;

Line 4888: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then

4884: -- check if activity started successfully
4885: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
4886: l_msg_log := 'start_activity';
4887: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
4888: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
4889: l_msg_log := 'start_activity';
4890: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
4891: end if;
4892:

Line 4890: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;

4886: l_msg_log := 'start_activity';
4887: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
4888: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
4889: l_msg_log := 'start_activity';
4890: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
4891: end if;
4892:
4893: FPA_UTILITIES_PVT.Attach_AW
4894: (p_api_version => l_api_version,

Line 4893: FPA_UTILITIES_PVT.Attach_AW

4889: l_msg_log := 'start_activity';
4890: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
4891: end if;
4892:
4893: FPA_UTILITIES_PVT.Attach_AW
4894: (p_api_version => l_api_version,
4895: p_attach_mode => 'rw',
4896: x_return_status => x_return_status,
4897: x_msg_count => x_msg_count,

Line 4901: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

4897: x_msg_count => x_msg_count,
4898: x_msg_data => x_msg_data);
4899:
4900:
4901: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
4902:
4903:
4904: FPA_PROJECT_PVT.Load_Project_Details_Aw(
4905: p_api_version => p_api_version,

Line 4920: FPA_UTILITIES_PVT.Detach_AW

4916: dbms_aw.execute('UPDATE');
4917: COMMIT;
4918: end if;
4919:
4920: FPA_UTILITIES_PVT.Detach_AW
4921: (p_api_version => 1.0,
4922: x_return_status => x_return_status,
4923: x_msg_count => x_msg_count,
4924: x_msg_data => x_msg_data);

Line 4926: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

4922: x_return_status => x_return_status,
4923: x_msg_count => x_msg_count,
4924: x_msg_data => x_msg_data);
4925:
4926: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
4927:
4928: FPA_UTILITIES_PVT.END_ACTIVITY(
4929: p_api_name => l_api_name,
4930: p_pkg_name => G_PKG_NAME,

Line 4928: FPA_UTILITIES_PVT.END_ACTIVITY(

4924: x_msg_data => x_msg_data);
4925:
4926: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
4927:
4928: FPA_UTILITIES_PVT.END_ACTIVITY(
4929: p_api_name => l_api_name,
4930: p_pkg_name => G_PKG_NAME,
4931: p_msg_log => null,
4932: x_msg_count => x_msg_count,

Line 4936: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then

4932: x_msg_count => x_msg_count,
4933: x_msg_data => x_msg_data);
4934:
4935: EXCEPTION
4936: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
4937:
4938: FPA_UTILITIES_PVT.Detach_AW(
4939: p_api_version => l_api_version,
4940: x_return_status => x_return_status,

Line 4938: FPA_UTILITIES_PVT.Detach_AW(

4934:
4935: EXCEPTION
4936: when FPA_UTILITIES_PVT.G_EXCEPTION_ERROR then
4937:
4938: FPA_UTILITIES_PVT.Detach_AW(
4939: p_api_version => l_api_version,
4940: x_return_status => x_return_status,
4941: x_msg_count => x_msg_count,
4942: x_msg_data => x_msg_data);

Line 4944: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

4940: x_return_status => x_return_status,
4941: x_msg_count => x_msg_count,
4942: x_msg_data => x_msg_data);
4943:
4944: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
4945: p_api_name => l_api_name,
4946: p_pkg_name => G_PKG_NAME,
4947: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',
4948: p_msg_log => l_msg_log,

Line 4947: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',

4943:
4944: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
4945: p_api_name => l_api_name,
4946: p_pkg_name => G_PKG_NAME,
4947: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_ERROR',
4948: p_msg_log => l_msg_log,
4949: x_msg_count => x_msg_count,
4950: x_msg_data => x_msg_data,
4951: p_api_type => G_API_TYPE);

Line 4953: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then

4949: x_msg_count => x_msg_count,
4950: x_msg_data => x_msg_data,
4951: p_api_type => G_API_TYPE);
4952:
4953: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
4954:
4955: FPA_UTILITIES_PVT.Detach_AW(
4956: p_api_version => l_api_version,
4957: x_return_status => x_return_status,

Line 4955: FPA_UTILITIES_PVT.Detach_AW(

4951: p_api_type => G_API_TYPE);
4952:
4953: when FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR then
4954:
4955: FPA_UTILITIES_PVT.Detach_AW(
4956: p_api_version => l_api_version,
4957: x_return_status => x_return_status,
4958: x_msg_count => x_msg_count,
4959: x_msg_data => x_msg_data);

Line 4961: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

4957: x_return_status => x_return_status,
4958: x_msg_count => x_msg_count,
4959: x_msg_data => x_msg_data);
4960:
4961: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
4962: p_api_name => l_api_name,
4963: p_pkg_name => G_PKG_NAME,
4964: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',
4965: p_msg_log => l_msg_log,

Line 4964: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',

4960:
4961: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
4962: p_api_name => l_api_name,
4963: p_pkg_name => G_PKG_NAME,
4964: p_exc_name => 'FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR',
4965: p_msg_log => l_msg_log,
4966: x_msg_count => x_msg_count,
4967: x_msg_data => x_msg_data,
4968: p_api_type => G_API_TYPE);

Line 4972: FPA_UTILITIES_PVT.Detach_AW(

4968: p_api_type => G_API_TYPE);
4969:
4970: when OTHERS then
4971:
4972: FPA_UTILITIES_PVT.Detach_AW(
4973: p_api_version => l_api_version,
4974: x_return_status => x_return_status,
4975: x_msg_count => x_msg_count,
4976: x_msg_data => x_msg_data);

Line 4978: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(

4974: x_return_status => x_return_status,
4975: x_msg_count => x_msg_count,
4976: x_msg_data => x_msg_data);
4977:
4978: x_return_status := FPA_UTILITIES_PVT.HANDLE_EXCEPTIONS(
4979: p_api_name => l_api_name,
4980: p_pkg_name => G_PKG_NAME,
4981: p_exc_name => 'OTHERS',
4982: p_msg_log => l_msg_log||SQLERRM,

Line 5013: 'Entering fpa_process_pvt.close_pc ,Calling Fpa_Utilities_Pvt.attach_AW'

5009: fnd_log.string
5010: (
5011: FND_LOG.LEVEL_PROCEDURE,
5012: 'fpa.sql.fpa_process_pvt.close_pc.begin',
5013: 'Entering fpa_process_pvt.close_pc ,Calling Fpa_Utilities_Pvt.attach_AW'
5014: );
5015: END IF;
5016:
5017: -- Attach AW Workspace

Line 5018: Fpa_Utilities_Pvt.attach_AW

5014: );
5015: END IF;
5016:
5017: -- Attach AW Workspace
5018: Fpa_Utilities_Pvt.attach_AW
5019: (
5020: p_api_version => 1.0,
5021: p_attach_mode => 'rw',
5022: x_return_status => x_return_status,

Line 5060: 'CAlling Fpa_Utilities_Pvt.detach_AW.'

5056: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5057: FND_LOG.String
5058: ( FND_LOG.LEVEL_PROCEDURE,
5059: 'fpa.sql.FPA_Process_Pvt.Close_Pc',
5060: 'CAlling Fpa_Utilities_Pvt.detach_AW.'
5061: );
5062: END IF;
5063:
5064: -- Detach AW Workspace

Line 5065: Fpa_Utilities_Pvt.detach_AW

5061: );
5062: END IF;
5063:
5064: -- Detach AW Workspace
5065: Fpa_Utilities_Pvt.detach_AW
5066: (
5067: p_api_version => 1.0,
5068: x_return_status => x_return_status,
5069: x_msg_count => x_msg_count,

Line 5101: Fpa_Utilities_Pvt.detach_AW

5097: FND_MESSAGE.SET_TOKEN('SQL_ERR_CODE', SQLCODE);
5098: FND_MESSAGE.SET_TOKEN('SQL_ERR_MSG', SQLERRM);
5099: FND_MSG_PUB.ADD;
5100: -- Detach AW Workspace
5101: Fpa_Utilities_Pvt.detach_AW
5102: ( p_api_version => 1.0,
5103: x_return_status => x_return_status,
5104: x_msg_count => x_msg_count,
5105: x_msg_data => x_msg_data

Line 5149: Fpa_Utilities_Pvt.attach_AW

5145: );
5146: END IF;
5147:
5148: -- Attach AW Workspace
5149: Fpa_Utilities_Pvt.attach_AW
5150: (
5151: p_api_version => 1.0,
5152: p_attach_mode => 'rw',
5153: x_return_status => x_return_status,

Line 5174: Fpa_Utilities_Pvt.detach_AW

5170: COMMIT;
5171: END IF;
5172:
5173: -- Detach AW Workspace
5174: Fpa_Utilities_Pvt.detach_AW
5175: (
5176: p_api_version => 1.0,
5177: x_return_status => x_return_status,
5178: x_msg_count => x_msg_count,

Line 5200: Fpa_Utilities_Pvt.detach_AW

5196: FND_MESSAGE.SET_TOKEN('SQL_ERR_MSG', SQLERRM);
5197: FND_MSG_PUB.ADD;
5198: ROLLBACK;
5199: -- Detach AW Workspace
5200: Fpa_Utilities_Pvt.detach_AW
5201: (
5202: p_api_version => 1.0,
5203: x_return_status => x_return_status,
5204: x_msg_count => x_msg_count,