DBA Data[Home] [Help]

APPS.HZ_HIERARCHY_PUB dependencies on FND_API

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

1546: *
1547: * ARGUMENTS
1548: * IN:
1549: * p_init_msg_list Initialize message stack if it is set to
1550: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
1551: * p_hierarchy_node_rec Hierarchy node record.
1552: * IN/OUT:
1553: * OUT:
1554: * x_return_status Return status after the call. The status can

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

1551: * p_hierarchy_node_rec Hierarchy node record.
1552: * IN/OUT:
1553: * OUT:
1554: * x_return_status Return status after the call. The status can
1555: * be FND_API.G_RET_STS_SUCCESS (success),
1556: * FND_API.G_RET_STS_ERROR (error),
1557: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1558: * x_msg_count Number of messages in message stack.
1559: * x_msg_data Message text if x_msg_count is 1.

Line 1556: * FND_API.G_RET_STS_ERROR (error),

1552: * IN/OUT:
1553: * OUT:
1554: * x_return_status Return status after the call. The status can
1555: * be FND_API.G_RET_STS_SUCCESS (success),
1556: * FND_API.G_RET_STS_ERROR (error),
1557: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1558: * x_msg_count Number of messages in message stack.
1559: * x_msg_data Message text if x_msg_count is 1.
1560: *

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

1553: * OUT:
1554: * x_return_status Return status after the call. The status can
1555: * be FND_API.G_RET_STS_SUCCESS (success),
1556: * FND_API.G_RET_STS_ERROR (error),
1557: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1558: * x_msg_count Number of messages in message stack.
1559: * x_msg_data Message text if x_msg_count is 1.
1560: *
1561: * NOTES

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

1566: *
1567: */
1568:
1569: PROCEDURE create_link(
1570: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1571: p_hierarchy_node_rec IN HIERARCHY_NODE_REC_TYPE,
1572: x_return_status OUT NOCOPY VARCHAR2,
1573: x_msg_count OUT NOCOPY NUMBER,
1574: x_msg_data OUT NOCOPY VARCHAR2

Line 1591: IF FND_API.to_Boolean(p_init_msg_list) THEN

1587: p_msg_level=>fnd_log.level_procedure);
1588: END IF;
1589:
1590: -- initialize message list if p_init_msg_list is set to TRUE.
1591: IF FND_API.to_Boolean(p_init_msg_list) THEN
1592: FND_MSG_PUB.initialize;
1593: END IF;
1594:
1595: -- initialize API return status to success.

Line 1596: x_return_status := FND_API.G_RET_STS_SUCCESS;

1592: FND_MSG_PUB.initialize;
1593: END IF;
1594:
1595: -- initialize API return status to success.
1596: x_return_status := FND_API.G_RET_STS_SUCCESS;
1597:
1598: do_create_link(p_hierarchy_node_rec,
1599: x_return_status);
1600:

Line 1603: p_encoded => FND_API.G_FALSE,

1599: x_return_status);
1600:
1601: --Standard call to get message count and if count is 1, get message info.
1602: FND_MSG_PUB.Count_And_Get(
1603: p_encoded => FND_API.G_FALSE,
1604: p_count => x_msg_count,
1605: p_data => x_msg_data);
1606:
1607: -- Debug info.

Line 1625: WHEN FND_API.G_EXC_ERROR THEN

1621: -- Check if API is called in debug mode. If yes, disable debug.
1622: --disable_debug;
1623:
1624: EXCEPTION
1625: WHEN FND_API.G_EXC_ERROR THEN
1626: ROLLBACK TO create_link;
1627: x_return_status := FND_API.G_RET_STS_ERROR;
1628: FND_MSG_PUB.Count_And_Get(
1629: p_encoded => FND_API.G_FALSE,

Line 1627: x_return_status := FND_API.G_RET_STS_ERROR;

1623:
1624: EXCEPTION
1625: WHEN FND_API.G_EXC_ERROR THEN
1626: ROLLBACK TO create_link;
1627: x_return_status := FND_API.G_RET_STS_ERROR;
1628: FND_MSG_PUB.Count_And_Get(
1629: p_encoded => FND_API.G_FALSE,
1630: p_count => x_msg_count,
1631: p_data => x_msg_data);

Line 1629: p_encoded => FND_API.G_FALSE,

1625: WHEN FND_API.G_EXC_ERROR THEN
1626: ROLLBACK TO create_link;
1627: x_return_status := FND_API.G_RET_STS_ERROR;
1628: FND_MSG_PUB.Count_And_Get(
1629: p_encoded => FND_API.G_FALSE,
1630: p_count => x_msg_count,
1631: p_data => x_msg_data);
1632:
1633: -- Debug info.

Line 1648: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1644: p_msg_level=>fnd_log.level_procedure);
1645: END IF;
1646:
1647:
1648: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1649: ROLLBACK TO create_link;
1650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1651: FND_MSG_PUB.Count_And_Get(
1652: p_encoded => FND_API.G_FALSE,

Line 1650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1652: p_encoded => FND_API.G_FALSE,

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

Line 1673: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1669:
1670:
1671: WHEN OTHERS THEN
1672: ROLLBACK TO create_link;
1673: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1674: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1675: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1676: FND_MSG_PUB.ADD;
1677: FND_MSG_PUB.Count_And_Get(

Line 1678: p_encoded => FND_API.G_FALSE,

1674: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1675: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1676: FND_MSG_PUB.ADD;
1677: FND_MSG_PUB.Count_And_Get(
1678: p_encoded => FND_API.G_FALSE,
1679: p_count => x_msg_count,
1680: p_data => x_msg_data);
1681:
1682: -- Debug info.

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

1707: *
1708: * ARGUMENTS
1709: * IN:
1710: * p_init_msg_list Initialize message stack if it is set to
1711: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
1712: * p_hierarchy_node_rec Hierarchy node record.
1713: * IN/OUT:
1714: * OUT:
1715: * x_return_status Return status after the call. The status can

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

1712: * p_hierarchy_node_rec Hierarchy node record.
1713: * IN/OUT:
1714: * OUT:
1715: * x_return_status Return status after the call. The status can
1716: * be FND_API.G_RET_STS_SUCCESS (success),
1717: * FND_API.G_RET_STS_ERROR (error),
1718: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1719: * x_msg_count Number of messages in message stack.
1720: * x_msg_data Message text if x_msg_count is 1.

Line 1717: * FND_API.G_RET_STS_ERROR (error),

1713: * IN/OUT:
1714: * OUT:
1715: * x_return_status Return status after the call. The status can
1716: * be FND_API.G_RET_STS_SUCCESS (success),
1717: * FND_API.G_RET_STS_ERROR (error),
1718: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1719: * x_msg_count Number of messages in message stack.
1720: * x_msg_data Message text if x_msg_count is 1.
1721: *

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

1714: * OUT:
1715: * x_return_status Return status after the call. The status can
1716: * be FND_API.G_RET_STS_SUCCESS (success),
1717: * FND_API.G_RET_STS_ERROR (error),
1718: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1719: * x_msg_count Number of messages in message stack.
1720: * x_msg_data Message text if x_msg_count is 1.
1721: *
1722: * NOTES

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

1727: *
1728: */
1729:
1730: PROCEDURE update_link(
1731: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1732: p_hierarchy_node_rec IN HIERARCHY_NODE_REC_TYPE,
1733: x_return_status OUT NOCOPY VARCHAR2,
1734: x_msg_count OUT NOCOPY NUMBER,
1735: x_msg_data OUT NOCOPY VARCHAR2

Line 1753: IF FND_API.to_Boolean(p_init_msg_list) THEN

1749: p_msg_level=>fnd_log.level_procedure);
1750: END IF;
1751:
1752: -- initialize message list if p_init_msg_list is set to TRUE.
1753: IF FND_API.to_Boolean(p_init_msg_list) THEN
1754: FND_MSG_PUB.initialize;
1755: END IF;
1756:
1757: -- initialize API return status to success.

Line 1758: x_return_status := FND_API.G_RET_STS_SUCCESS;

1754: FND_MSG_PUB.initialize;
1755: END IF;
1756:
1757: -- initialize API return status to success.
1758: x_return_status := FND_API.G_RET_STS_SUCCESS;
1759:
1760: do_update_link(p_hierarchy_node_rec,
1761: x_return_status);
1762:

Line 1765: p_encoded => FND_API.G_FALSE,

1761: x_return_status);
1762:
1763: --Standard call to get message count and if count is 1, get message info.
1764: FND_MSG_PUB.Count_And_Get(
1765: p_encoded => FND_API.G_FALSE,
1766: p_count => x_msg_count,
1767: p_data => x_msg_data);
1768:
1769: -- Debug info.

Line 1786: WHEN FND_API.G_EXC_ERROR THEN

1782: -- Check if API is called in debug mode. If yes, disable debug.
1783: --disable_debug;
1784:
1785: EXCEPTION
1786: WHEN FND_API.G_EXC_ERROR THEN
1787: ROLLBACK TO update_link;
1788: x_return_status := FND_API.G_RET_STS_ERROR;
1789: FND_MSG_PUB.Count_And_Get(
1790: p_encoded => FND_API.G_FALSE,

Line 1788: x_return_status := FND_API.G_RET_STS_ERROR;

1784:
1785: EXCEPTION
1786: WHEN FND_API.G_EXC_ERROR THEN
1787: ROLLBACK TO update_link;
1788: x_return_status := FND_API.G_RET_STS_ERROR;
1789: FND_MSG_PUB.Count_And_Get(
1790: p_encoded => FND_API.G_FALSE,
1791: p_count => x_msg_count,
1792: p_data => x_msg_data);

Line 1790: p_encoded => FND_API.G_FALSE,

1786: WHEN FND_API.G_EXC_ERROR THEN
1787: ROLLBACK TO update_link;
1788: x_return_status := FND_API.G_RET_STS_ERROR;
1789: FND_MSG_PUB.Count_And_Get(
1790: p_encoded => FND_API.G_FALSE,
1791: p_count => x_msg_count,
1792: p_data => x_msg_data);
1793:
1794: -- Debug info.

Line 1809: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1805: p_msg_level=>fnd_log.level_procedure);
1806:
1807: END IF;
1808:
1809: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1810: ROLLBACK TO update_link;
1811: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1812: FND_MSG_PUB.Count_And_Get(
1813: p_encoded => FND_API.G_FALSE,

Line 1811: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1807: END IF;
1808:
1809: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1810: ROLLBACK TO update_link;
1811: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1812: FND_MSG_PUB.Count_And_Get(
1813: p_encoded => FND_API.G_FALSE,
1814: p_count => x_msg_count,
1815: p_data => x_msg_data);

Line 1813: p_encoded => FND_API.G_FALSE,

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

Line 1834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1830:
1831:
1832: WHEN OTHERS THEN
1833: ROLLBACK TO update_link;
1834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1835: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1836: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1837: FND_MSG_PUB.ADD;
1838: FND_MSG_PUB.Count_And_Get(

Line 1839: p_encoded => FND_API.G_FALSE,

1835: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1836: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1837: FND_MSG_PUB.ADD;
1838: FND_MSG_PUB.Count_And_Get(
1839: p_encoded => FND_API.G_FALSE,
1840: p_count => x_msg_count,
1841: p_data => x_msg_data);
1842:
1843: -- Debug info.

Line 2101: p_init_msg_list => FND_API.G_FALSE,

2097: l_hierarchy_rec.status := NVL(r1.status, 'A');
2098: END IF;
2099:
2100: HZ_HIERARCHY_PUB.create_link(
2101: p_init_msg_list => FND_API.G_FALSE,
2102: p_hierarchy_node_rec => l_hierarchy_rec,
2103: x_return_status => l_return_status,
2104: x_msg_count => l_msg_count,
2105: x_msg_data => l_msg_data