DBA Data[Home] [Help]

APPS.HZ_HIERARCHY_PUB dependencies on FND_API

Line 1574: * FND_API.G_TRUE. Default is FND_API.G_FALSE.

1570: *
1571: * ARGUMENTS
1572: * IN:
1573: * p_init_msg_list Initialize message stack if it is set to
1574: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
1575: * p_hierarchy_node_rec Hierarchy node record.
1576: * IN/OUT:
1577: * OUT:
1578: * x_return_status Return status after the call. The status can

Line 1579: * be FND_API.G_RET_STS_SUCCESS (success),

1575: * p_hierarchy_node_rec Hierarchy node record.
1576: * IN/OUT:
1577: * OUT:
1578: * x_return_status Return status after the call. The status can
1579: * be FND_API.G_RET_STS_SUCCESS (success),
1580: * FND_API.G_RET_STS_ERROR (error),
1581: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1582: * x_msg_count Number of messages in message stack.
1583: * x_msg_data Message text if x_msg_count is 1.

Line 1580: * FND_API.G_RET_STS_ERROR (error),

1576: * IN/OUT:
1577: * OUT:
1578: * x_return_status Return status after the call. The status can
1579: * be FND_API.G_RET_STS_SUCCESS (success),
1580: * FND_API.G_RET_STS_ERROR (error),
1581: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1582: * x_msg_count Number of messages in message stack.
1583: * x_msg_data Message text if x_msg_count is 1.
1584: *

Line 1581: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

1577: * OUT:
1578: * x_return_status Return status after the call. The status can
1579: * be FND_API.G_RET_STS_SUCCESS (success),
1580: * FND_API.G_RET_STS_ERROR (error),
1581: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1582: * x_msg_count Number of messages in message stack.
1583: * x_msg_data Message text if x_msg_count is 1.
1584: *
1585: * NOTES

Line 1594: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1590: *
1591: */
1592:
1593: PROCEDURE create_link(
1594: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1595: p_hierarchy_node_rec IN HIERARCHY_NODE_REC_TYPE,
1596: x_return_status OUT NOCOPY VARCHAR2,
1597: x_msg_count OUT NOCOPY NUMBER,
1598: x_msg_data OUT NOCOPY VARCHAR2

Line 1615: IF FND_API.to_Boolean(p_init_msg_list) THEN

1611: p_msg_level=>fnd_log.level_procedure);
1612: END IF;
1613:
1614: -- initialize message list if p_init_msg_list is set to TRUE.
1615: IF FND_API.to_Boolean(p_init_msg_list) THEN
1616: FND_MSG_PUB.initialize;
1617: END IF;
1618:
1619: -- initialize API return status to success.

Line 1620: x_return_status := FND_API.G_RET_STS_SUCCESS;

1616: FND_MSG_PUB.initialize;
1617: END IF;
1618:
1619: -- initialize API return status to success.
1620: x_return_status := FND_API.G_RET_STS_SUCCESS;
1621:
1622: do_create_link(p_hierarchy_node_rec,
1623: x_return_status);
1624:

Line 1627: p_encoded => FND_API.G_FALSE,

1623: x_return_status);
1624:
1625: --Standard call to get message count and if count is 1, get message info.
1626: FND_MSG_PUB.Count_And_Get(
1627: p_encoded => FND_API.G_FALSE,
1628: p_count => x_msg_count,
1629: p_data => x_msg_data);
1630:
1631: -- Debug info.

Line 1649: WHEN FND_API.G_EXC_ERROR THEN

1645: -- Check if API is called in debug mode. If yes, disable debug.
1646: --disable_debug;
1647:
1648: EXCEPTION
1649: WHEN FND_API.G_EXC_ERROR THEN
1650: ROLLBACK TO create_link;
1651: x_return_status := FND_API.G_RET_STS_ERROR;
1652: FND_MSG_PUB.Count_And_Get(
1653: p_encoded => FND_API.G_FALSE,

Line 1651: x_return_status := FND_API.G_RET_STS_ERROR;

1647:
1648: EXCEPTION
1649: WHEN FND_API.G_EXC_ERROR THEN
1650: ROLLBACK TO create_link;
1651: x_return_status := FND_API.G_RET_STS_ERROR;
1652: FND_MSG_PUB.Count_And_Get(
1653: p_encoded => FND_API.G_FALSE,
1654: p_count => x_msg_count,
1655: p_data => x_msg_data);

Line 1653: p_encoded => FND_API.G_FALSE,

1649: WHEN FND_API.G_EXC_ERROR THEN
1650: ROLLBACK TO create_link;
1651: x_return_status := FND_API.G_RET_STS_ERROR;
1652: FND_MSG_PUB.Count_And_Get(
1653: p_encoded => FND_API.G_FALSE,
1654: p_count => x_msg_count,
1655: p_data => x_msg_data);
1656:
1657: -- Debug info.

Line 1672: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1668: p_msg_level=>fnd_log.level_procedure);
1669: END IF;
1670:
1671:
1672: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1673: ROLLBACK TO create_link;
1674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1675: FND_MSG_PUB.Count_And_Get(
1676: p_encoded => FND_API.G_FALSE,

Line 1674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1670:
1671:
1672: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1673: ROLLBACK TO create_link;
1674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1675: FND_MSG_PUB.Count_And_Get(
1676: p_encoded => FND_API.G_FALSE,
1677: p_count => x_msg_count,
1678: p_data => x_msg_data);

Line 1676: p_encoded => FND_API.G_FALSE,

1672: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1673: ROLLBACK TO create_link;
1674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1675: FND_MSG_PUB.Count_And_Get(
1676: p_encoded => FND_API.G_FALSE,
1677: p_count => x_msg_count,
1678: p_data => x_msg_data);
1679:
1680: -- Debug info.

Line 1697: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1693:
1694:
1695: WHEN OTHERS THEN
1696: ROLLBACK TO create_link;
1697: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1698: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1699: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1700: FND_MSG_PUB.ADD;
1701: FND_MSG_PUB.Count_And_Get(

Line 1702: p_encoded => FND_API.G_FALSE,

1698: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1699: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1700: FND_MSG_PUB.ADD;
1701: FND_MSG_PUB.Count_And_Get(
1702: p_encoded => FND_API.G_FALSE,
1703: p_count => x_msg_count,
1704: p_data => x_msg_data);
1705:
1706: -- Debug info.

Line 1735: * FND_API.G_TRUE. Default is FND_API.G_FALSE.

1731: *
1732: * ARGUMENTS
1733: * IN:
1734: * p_init_msg_list Initialize message stack if it is set to
1735: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
1736: * p_hierarchy_node_rec Hierarchy node record.
1737: * IN/OUT:
1738: * OUT:
1739: * x_return_status Return status after the call. The status can

Line 1740: * be FND_API.G_RET_STS_SUCCESS (success),

1736: * p_hierarchy_node_rec Hierarchy node record.
1737: * IN/OUT:
1738: * OUT:
1739: * x_return_status Return status after the call. The status can
1740: * be FND_API.G_RET_STS_SUCCESS (success),
1741: * FND_API.G_RET_STS_ERROR (error),
1742: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1743: * x_msg_count Number of messages in message stack.
1744: * x_msg_data Message text if x_msg_count is 1.

Line 1741: * FND_API.G_RET_STS_ERROR (error),

1737: * IN/OUT:
1738: * OUT:
1739: * x_return_status Return status after the call. The status can
1740: * be FND_API.G_RET_STS_SUCCESS (success),
1741: * FND_API.G_RET_STS_ERROR (error),
1742: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1743: * x_msg_count Number of messages in message stack.
1744: * x_msg_data Message text if x_msg_count is 1.
1745: *

Line 1742: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

1738: * OUT:
1739: * x_return_status Return status after the call. The status can
1740: * be FND_API.G_RET_STS_SUCCESS (success),
1741: * FND_API.G_RET_STS_ERROR (error),
1742: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1743: * x_msg_count Number of messages in message stack.
1744: * x_msg_data Message text if x_msg_count is 1.
1745: *
1746: * NOTES

Line 1755: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1751: *
1752: */
1753:
1754: PROCEDURE update_link(
1755: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1756: p_hierarchy_node_rec IN HIERARCHY_NODE_REC_TYPE,
1757: x_return_status OUT NOCOPY VARCHAR2,
1758: x_msg_count OUT NOCOPY NUMBER,
1759: x_msg_data OUT NOCOPY VARCHAR2

Line 1777: IF FND_API.to_Boolean(p_init_msg_list) THEN

1773: p_msg_level=>fnd_log.level_procedure);
1774: END IF;
1775:
1776: -- initialize message list if p_init_msg_list is set to TRUE.
1777: IF FND_API.to_Boolean(p_init_msg_list) THEN
1778: FND_MSG_PUB.initialize;
1779: END IF;
1780:
1781: -- initialize API return status to success.

Line 1782: x_return_status := FND_API.G_RET_STS_SUCCESS;

1778: FND_MSG_PUB.initialize;
1779: END IF;
1780:
1781: -- initialize API return status to success.
1782: x_return_status := FND_API.G_RET_STS_SUCCESS;
1783:
1784: do_update_link(p_hierarchy_node_rec,
1785: x_return_status);
1786:

Line 1789: p_encoded => FND_API.G_FALSE,

1785: x_return_status);
1786:
1787: --Standard call to get message count and if count is 1, get message info.
1788: FND_MSG_PUB.Count_And_Get(
1789: p_encoded => FND_API.G_FALSE,
1790: p_count => x_msg_count,
1791: p_data => x_msg_data);
1792:
1793: -- Debug info.

Line 1810: WHEN FND_API.G_EXC_ERROR THEN

1806: -- Check if API is called in debug mode. If yes, disable debug.
1807: --disable_debug;
1808:
1809: EXCEPTION
1810: WHEN FND_API.G_EXC_ERROR THEN
1811: ROLLBACK TO update_link;
1812: x_return_status := FND_API.G_RET_STS_ERROR;
1813: FND_MSG_PUB.Count_And_Get(
1814: p_encoded => FND_API.G_FALSE,

Line 1812: x_return_status := FND_API.G_RET_STS_ERROR;

1808:
1809: EXCEPTION
1810: WHEN FND_API.G_EXC_ERROR THEN
1811: ROLLBACK TO update_link;
1812: x_return_status := FND_API.G_RET_STS_ERROR;
1813: FND_MSG_PUB.Count_And_Get(
1814: p_encoded => FND_API.G_FALSE,
1815: p_count => x_msg_count,
1816: p_data => x_msg_data);

Line 1814: p_encoded => FND_API.G_FALSE,

1810: WHEN FND_API.G_EXC_ERROR THEN
1811: ROLLBACK TO update_link;
1812: x_return_status := FND_API.G_RET_STS_ERROR;
1813: FND_MSG_PUB.Count_And_Get(
1814: p_encoded => FND_API.G_FALSE,
1815: p_count => x_msg_count,
1816: p_data => x_msg_data);
1817:
1818: -- Debug info.

Line 1833: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1829: p_msg_level=>fnd_log.level_procedure);
1830:
1831: END IF;
1832:
1833: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1834: ROLLBACK TO update_link;
1835: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1836: FND_MSG_PUB.Count_And_Get(
1837: p_encoded => FND_API.G_FALSE,

Line 1835: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1831: END IF;
1832:
1833: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1834: ROLLBACK TO update_link;
1835: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1836: FND_MSG_PUB.Count_And_Get(
1837: p_encoded => FND_API.G_FALSE,
1838: p_count => x_msg_count,
1839: p_data => x_msg_data);

Line 1837: p_encoded => FND_API.G_FALSE,

1833: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1834: ROLLBACK TO update_link;
1835: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1836: FND_MSG_PUB.Count_And_Get(
1837: p_encoded => FND_API.G_FALSE,
1838: p_count => x_msg_count,
1839: p_data => x_msg_data);
1840:
1841: -- Debug info.

Line 1858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1854:
1855:
1856: WHEN OTHERS THEN
1857: ROLLBACK TO update_link;
1858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1859: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1860: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1861: FND_MSG_PUB.ADD;
1862: FND_MSG_PUB.Count_And_Get(

Line 1863: p_encoded => FND_API.G_FALSE,

1859: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1860: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1861: FND_MSG_PUB.ADD;
1862: FND_MSG_PUB.Count_And_Get(
1863: p_encoded => FND_API.G_FALSE,
1864: p_count => x_msg_count,
1865: p_data => x_msg_data);
1866:
1867: -- Debug info.

Line 2125: p_init_msg_list => FND_API.G_FALSE,

2121: l_hierarchy_rec.status := NVL(r1.status, 'A');
2122: END IF;
2123:
2124: HZ_HIERARCHY_PUB.create_link(
2125: p_init_msg_list => FND_API.G_FALSE,
2126: p_hierarchy_node_rec => l_hierarchy_rec,
2127: x_return_status => l_return_status,
2128: x_msg_count => l_msg_count,
2129: x_msg_data => l_msg_data