1380: END IF;
1381:
1382: -- Initialize message list if p_init_msg_list is set to TRUE.
1383: IF FND_API.to_Boolean(p_init_msg_list) THEN
1384: FND_MSG_PUB.initialize;
1385: END IF;
1386:
1387: -- initialize the API return status to success
1388: x_return_status := FND_API.G_RET_STS_SUCCESS;
1393:
1394: -- never commit changes
1395:
1396: -- get message count, and also message if there is only one
1397: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1398: p_data => x_msg_data);
1399:
1400: EXCEPTION
1401: WHEN GL_INVALID_MAPPING_NAME THEN
1400: EXCEPTION
1401: WHEN GL_INVALID_MAPPING_NAME THEN
1402: ROLLBACK TO Map_Account_GRP;
1403: x_return_status := FND_API.G_RET_STS_ERROR;
1404: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1405: p_data => x_msg_data);
1406: WHEN GL_DISABLED_MAPPING THEN
1407: ROLLBACK TO Map_Account_GRP;
1408: x_return_status := FND_API.G_RET_STS_ERROR;
1405: p_data => x_msg_data);
1406: WHEN GL_DISABLED_MAPPING THEN
1407: ROLLBACK TO Map_Account_GRP;
1408: x_return_status := FND_API.G_RET_STS_ERROR;
1409: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1410: p_data => x_msg_data);
1411: WHEN GL_INVALID_MAPPING_RULES THEN
1412: ROLLBACK TO Map_Account_GRP;
1413: x_return_status := FND_API.G_RET_STS_ERROR;
1410: p_data => x_msg_data);
1411: WHEN GL_INVALID_MAPPING_RULES THEN
1412: ROLLBACK TO Map_Account_GRP;
1413: x_return_status := FND_API.G_RET_STS_ERROR;
1414: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1415: p_data => x_msg_data);
1416: WHEN OTHERS THEN
1417: ROLLBACK TO Map_Account_GRP;
1418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1415: p_data => x_msg_data);
1416: WHEN OTHERS THEN
1417: ROLLBACK TO Map_Account_GRP;
1418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1419: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1420: p_data => x_msg_data);
1421: END Map_Account;
1422:
1423:
1650: END IF;
1651:
1652: -- Initialize message list if p_init_msg_list is set to TRUE.
1653: IF FND_API.to_Boolean(p_init_msg_list) THEN
1654: FND_MSG_PUB.initialize;
1655: END IF;
1656:
1657: -- initialize the API return status to success
1658: x_return_status := FND_API.G_RET_STS_SUCCESS;
1663:
1664: -- never commit changes
1665:
1666: -- get message count, and also message if there is only one
1667: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1668: p_data => x_msg_data);
1669:
1670: EXCEPTION
1671: WHEN GL_INVALID_MAPPING_NAME THEN
1670: EXCEPTION
1671: WHEN GL_INVALID_MAPPING_NAME THEN
1672: ROLLBACK TO Map_Account_GRP;
1673: x_return_status := FND_API.G_RET_STS_ERROR;
1674: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1675: p_data => x_msg_data);
1676: WHEN GL_DISABLED_MAPPING THEN
1677: ROLLBACK TO Map_Account_GRP;
1678: x_return_status := FND_API.G_RET_STS_ERROR;
1675: p_data => x_msg_data);
1676: WHEN GL_DISABLED_MAPPING THEN
1677: ROLLBACK TO Map_Account_GRP;
1678: x_return_status := FND_API.G_RET_STS_ERROR;
1679: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1680: p_data => x_msg_data);
1681: WHEN GL_BSV_MAP_NO_SOURCE_BAL_SEG THEN
1682: ROLLBACK TO Map_Account_GRP;
1683: x_return_status := FND_API.G_RET_STS_ERROR;
1680: p_data => x_msg_data);
1681: WHEN GL_BSV_MAP_NO_SOURCE_BAL_SEG THEN
1682: ROLLBACK TO Map_Account_GRP;
1683: x_return_status := FND_API.G_RET_STS_ERROR;
1684: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1685: p_data => x_msg_data);
1686: WHEN GL_BSV_MAP_NO_TARGET_BAL_SEG THEN
1687: ROLLBACK TO Map_Account_GRP;
1688: x_return_status := FND_API.G_RET_STS_ERROR;
1685: p_data => x_msg_data);
1686: WHEN GL_BSV_MAP_NO_TARGET_BAL_SEG THEN
1687: ROLLBACK TO Map_Account_GRP;
1688: x_return_status := FND_API.G_RET_STS_ERROR;
1689: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1690: p_data => x_msg_data);
1691: WHEN GL_BSV_MAP_NO_SEGMENT_MAP THEN
1692: ROLLBACK TO Map_Account_GRP;
1693: x_return_status := FND_API.G_RET_STS_ERROR;
1690: p_data => x_msg_data);
1691: WHEN GL_BSV_MAP_NO_SEGMENT_MAP THEN
1692: ROLLBACK TO Map_Account_GRP;
1693: x_return_status := FND_API.G_RET_STS_ERROR;
1694: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1695: p_data => x_msg_data);
1696: WHEN GL_BSV_MAP_NO_SINGLE_VALUE THEN
1697: ROLLBACK TO Map_Account_GRP;
1698: x_return_status := FND_API.G_RET_STS_ERROR;
1695: p_data => x_msg_data);
1696: WHEN GL_BSV_MAP_NO_SINGLE_VALUE THEN
1697: ROLLBACK TO Map_Account_GRP;
1698: x_return_status := FND_API.G_RET_STS_ERROR;
1699: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1700: p_data => x_msg_data);
1701: WHEN GL_BSV_MAP_NO_FROM_SEGMENT THEN
1702: ROLLBACK TO Map_Account_GRP;
1703: x_return_status := FND_API.G_RET_STS_ERROR;
1700: p_data => x_msg_data);
1701: WHEN GL_BSV_MAP_NO_FROM_SEGMENT THEN
1702: ROLLBACK TO Map_Account_GRP;
1703: x_return_status := FND_API.G_RET_STS_ERROR;
1704: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1705: p_data => x_msg_data);
1706: WHEN GL_BSV_MAP_NOT_BSV_DERIVED THEN
1707: ROLLBACK TO Map_Account_GRP;
1708: x_return_status := FND_API.G_RET_STS_ERROR;
1705: p_data => x_msg_data);
1706: WHEN GL_BSV_MAP_NOT_BSV_DERIVED THEN
1707: ROLLBACK TO Map_Account_GRP;
1708: x_return_status := FND_API.G_RET_STS_ERROR;
1709: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1710: p_data => x_msg_data);
1711: WHEN GL_BSV_MAP_SETUP_ERROR THEN
1712: ROLLBACK TO Map_Account_GRP;
1713: x_return_status := FND_API.G_RET_STS_ERROR;
1710: p_data => x_msg_data);
1711: WHEN GL_BSV_MAP_SETUP_ERROR THEN
1712: ROLLBACK TO Map_Account_GRP;
1713: x_return_status := FND_API.G_RET_STS_ERROR;
1714: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1715: p_data => x_msg_data);
1716: WHEN GL_BSV_MAP_MAPPING_ERROR THEN
1717: ROLLBACK TO Map_Account_GRP;
1718: x_return_status := FND_API.G_RET_STS_ERROR;
1715: p_data => x_msg_data);
1716: WHEN GL_BSV_MAP_MAPPING_ERROR THEN
1717: ROLLBACK TO Map_Account_GRP;
1718: x_return_status := FND_API.G_RET_STS_ERROR;
1719: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1720: p_data => x_msg_data);
1721: WHEN OTHERS THEN
1722: ROLLBACK TO Populate_BSV_Targets_Start;
1723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1720: p_data => x_msg_data);
1721: WHEN OTHERS THEN
1722: ROLLBACK TO Populate_BSV_Targets_Start;
1723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1724: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1725: p_data => x_msg_data);
1726: END Populate_BSV_Targets;
1727:
1728:
1799: END IF;
1800:
1801: -- Initialize message list if p_init_msg_list is set to TRUE.
1802: IF FND_API.to_Boolean(p_init_msg_list) THEN
1803: FND_MSG_PUB.initialize;
1804: END IF;
1805:
1806: -- initialize the API return status to success
1807: x_return_status := FND_API.G_RET_STS_SUCCESS;
1813:
1814: -- never commit changes
1815:
1816: -- get message count, and also message if there is only one
1817: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1818: p_data => x_msg_data);
1819:
1820: EXCEPTION
1821: WHEN GL_INVALID_MAPPING_NAME THEN
1820: EXCEPTION
1821: WHEN GL_INVALID_MAPPING_NAME THEN
1822: ROLLBACK TO Map_Account_GRP;
1823: x_return_status := FND_API.G_RET_STS_ERROR;
1824: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1825: p_data => x_msg_data);
1826: WHEN GL_DISABLED_MAPPING THEN
1827: ROLLBACK TO Map_Account_GRP;
1828: x_return_status := FND_API.G_RET_STS_ERROR;
1825: p_data => x_msg_data);
1826: WHEN GL_DISABLED_MAPPING THEN
1827: ROLLBACK TO Map_Account_GRP;
1828: x_return_status := FND_API.G_RET_STS_ERROR;
1829: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1830: p_data => x_msg_data);
1831: WHEN GL_BSV_MAP_NO_SOURCE_BAL_SEG THEN
1832: ROLLBACK TO Map_Account_GRP;
1833: x_return_status := FND_API.G_RET_STS_ERROR;
1830: p_data => x_msg_data);
1831: WHEN GL_BSV_MAP_NO_SOURCE_BAL_SEG THEN
1832: ROLLBACK TO Map_Account_GRP;
1833: x_return_status := FND_API.G_RET_STS_ERROR;
1834: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1835: p_data => x_msg_data);
1836: WHEN GL_BSV_MAP_NO_TARGET_BAL_SEG THEN
1837: ROLLBACK TO Map_Account_GRP;
1838: x_return_status := FND_API.G_RET_STS_ERROR;
1835: p_data => x_msg_data);
1836: WHEN GL_BSV_MAP_NO_TARGET_BAL_SEG THEN
1837: ROLLBACK TO Map_Account_GRP;
1838: x_return_status := FND_API.G_RET_STS_ERROR;
1839: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1840: p_data => x_msg_data);
1841: WHEN GL_BSV_MAP_NO_SEGMENT_MAP THEN
1842: ROLLBACK TO Map_Account_GRP;
1843: x_return_status := FND_API.G_RET_STS_ERROR;
1840: p_data => x_msg_data);
1841: WHEN GL_BSV_MAP_NO_SEGMENT_MAP THEN
1842: ROLLBACK TO Map_Account_GRP;
1843: x_return_status := FND_API.G_RET_STS_ERROR;
1844: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1845: p_data => x_msg_data);
1846: WHEN GL_BSV_MAP_NO_SINGLE_VALUE THEN
1847: ROLLBACK TO Map_Account_GRP;
1848: x_return_status := FND_API.G_RET_STS_ERROR;
1845: p_data => x_msg_data);
1846: WHEN GL_BSV_MAP_NO_SINGLE_VALUE THEN
1847: ROLLBACK TO Map_Account_GRP;
1848: x_return_status := FND_API.G_RET_STS_ERROR;
1849: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1850: p_data => x_msg_data);
1851: WHEN GL_BSV_MAP_NO_FROM_SEGMENT THEN
1852: ROLLBACK TO Map_Account_GRP;
1853: x_return_status := FND_API.G_RET_STS_ERROR;
1850: p_data => x_msg_data);
1851: WHEN GL_BSV_MAP_NO_FROM_SEGMENT THEN
1852: ROLLBACK TO Map_Account_GRP;
1853: x_return_status := FND_API.G_RET_STS_ERROR;
1854: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1855: p_data => x_msg_data);
1856: WHEN GL_BSV_MAP_NOT_BSV_DERIVED THEN
1857: ROLLBACK TO Map_Account_GRP;
1858: x_return_status := FND_API.G_RET_STS_ERROR;
1855: p_data => x_msg_data);
1856: WHEN GL_BSV_MAP_NOT_BSV_DERIVED THEN
1857: ROLLBACK TO Map_Account_GRP;
1858: x_return_status := FND_API.G_RET_STS_ERROR;
1859: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1860: p_data => x_msg_data);
1861: WHEN GL_BSV_MAP_SETUP_ERROR THEN
1862: ROLLBACK TO Map_Account_GRP;
1863: x_return_status := FND_API.G_RET_STS_ERROR;
1860: p_data => x_msg_data);
1861: WHEN GL_BSV_MAP_SETUP_ERROR THEN
1862: ROLLBACK TO Map_Account_GRP;
1863: x_return_status := FND_API.G_RET_STS_ERROR;
1864: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1865: p_data => x_msg_data);
1866: WHEN GL_BSV_MAP_MAPPING_ERROR THEN
1867: ROLLBACK TO Map_Account_GRP;
1868: x_return_status := FND_API.G_RET_STS_ERROR;
1865: p_data => x_msg_data);
1866: WHEN GL_BSV_MAP_MAPPING_ERROR THEN
1867: ROLLBACK TO Map_Account_GRP;
1868: x_return_status := FND_API.G_RET_STS_ERROR;
1869: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1870: p_data => x_msg_data);
1871: WHEN OTHERS THEN
1872: ROLLBACK TO Populate_QS_Targets_Start;
1873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1870: p_data => x_msg_data);
1871: WHEN OTHERS THEN
1872: ROLLBACK TO Populate_QS_Targets_Start;
1873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1874: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1875: p_data => x_msg_data);
1876: END Populate_Qual_Segment_Targets;
1877:
1878: END GL_ACCOUNTS_MAP_GRP;