eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_SHORTSTATEMENT_PVT dependencies on FND_API

Line 15: -- DEFAULT = FND_API.G_FALSE,

11: -- p_api_version IN NUMBER (required)
12: -- API Version of this procedure
13: --
14: -- p_init_msg_list IN VARCHAR2 (optional)
15: -- DEFAULT = FND_API.G_FALSE,
16: --
17: -- OUT :
18: -- x_return_status OUT NUMBER
19: -- Result of all the operations

Line 36: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

32: -- Notes :
33: -- END OF comments
34: PROCEDURE BuildDetail (
35: p_api_version IN NUMBER ,
36: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
37: x_return_status IN OUT NOCOPY VARCHAR2,
38: x_msg_count IN OUT NOCOPY NUMBER,
39: x_msg_data IN OUT NOCOPY VARCHAR2,
40: p_organization_id IN NUMBER,

Line 76: IF NOT FND_API.Compatible_API_Call(l_api_version

72: L_Check_rep NUMBER;
73: L_Order_System VARCHAR2(10); -- The type of order entry system which is installed.
74: BEGIN
75: -- Standard Call to check for call compatibility
76: IF NOT FND_API.Compatible_API_Call(l_api_version
77: , p_api_version
78: , l_api_name
79: , G_PKG_NAME) THEN
80: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 80: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

76: IF NOT FND_API.Compatible_API_Call(l_api_version
77: , p_api_version
78: , l_api_name
79: , G_PKG_NAME) THEN
80: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
81: END IF;
82: --
83: -- Initialize message list if p_init_msg_list is set to true
84: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 84: IF FND_API.to_Boolean(p_init_msg_list) THEN

80: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
81: END IF;
82: --
83: -- Initialize message list if p_init_msg_list is set to true
84: IF FND_API.to_Boolean(p_init_msg_list) THEN
85: FND_MSG_PUB.initialize;
86: END IF;
87: --
88: -- Initialize API return status to access

Line 89: x_return_status := FND_API.G_RET_STS_SUCCESS;

85: FND_MSG_PUB.initialize;
86: END IF;
87: --
88: -- Initialize API return status to access
89: x_return_status := FND_API.G_RET_STS_SUCCESS;
90: --
91: -- For WIP see whether jobs and/or schedules should be included
92: IF ( p_wip_rel_jobs_flag = 1 OR p_wip_unrel_jobs_flag = 1 OR
93: p_wip_hold_jobs_flag = 1 ) THEN

Line 992: WHEN FND_API.G_EXC_ERROR THEN

988: FND_MSG_PUB.Count_And_Get
989: (p_count => x_msg_count
990: , p_data => x_msg_data);
991: EXCEPTION
992: WHEN FND_API.G_EXC_ERROR THEN
993: --
994: x_return_status := FND_API.G_RET_STS_ERROR;
995: --
996: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

Line 994: x_return_status := FND_API.G_RET_STS_ERROR;

990: , p_data => x_msg_data);
991: EXCEPTION
992: WHEN FND_API.G_EXC_ERROR THEN
993: --
994: x_return_status := FND_API.G_RET_STS_ERROR;
995: --
996: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
997: , p_data => x_msg_data);
998: --

Line 999: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

995: --
996: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
997: , p_data => x_msg_data);
998: --
999: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1000: --
1001: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1002: --
1003: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

Line 1001: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

997: , p_data => x_msg_data);
998: --
999: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1000: --
1001: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1002: --
1003: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
1004: , p_data => x_msg_data);
1005: --

Line 1008: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1004: , p_data => x_msg_data);
1005: --
1006: WHEN OTHERS THEN
1007: --
1008: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1009: --
1010: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1011: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1012: END IF;

Line 1028: -- DEFAULT = FND_API.G_FALSE,

1024: -- p_api_version IN NUMBER (required)
1025: -- API Version of this procedure
1026: --
1027: -- p_init_msg_list IN VARCHAR2 (optional)
1028: -- DEFAULT = FND_API.G_FALSE,
1029: --
1030: -- OUT :
1031: -- x_return_status OUT NUMBER
1032: -- Result of all the operations

Line 1049: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1045: -- Notes :
1046: -- END OF comments
1047: PROCEDURE BuildSummary (
1048: p_api_version IN NUMBER ,
1049: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1050: x_return_status IN OUT NOCOPY VARCHAR2,
1051: x_msg_count IN OUT NOCOPY NUMBER,
1052: x_msg_data IN OUT NOCOPY VARCHAR2,
1053: p_organization_id IN NUMBER,

Line 1089: IF NOT FND_API.Compatible_API_Call(l_api_version

1085: L_Check_rep NUMBER;
1086: L_Order_System VARCHAR2(10); -- The type of order entry system which is installed.
1087: BEGIN
1088: -- Standard Call to check for call compatibility
1089: IF NOT FND_API.Compatible_API_Call(l_api_version
1090: , p_api_version
1091: , l_api_name
1092: , G_PKG_NAME) THEN
1093: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1093: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1089: IF NOT FND_API.Compatible_API_Call(l_api_version
1090: , p_api_version
1091: , l_api_name
1092: , G_PKG_NAME) THEN
1093: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1094: END IF;
1095: --
1096: -- Initialize message list if p_init_msg_list is set to true
1097: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1097: IF FND_API.to_Boolean(p_init_msg_list) THEN

1093: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1094: END IF;
1095: --
1096: -- Initialize message list if p_init_msg_list is set to true
1097: IF FND_API.to_Boolean(p_init_msg_list) THEN
1098: FND_MSG_PUB.initialize;
1099: END IF;
1100: --
1101: -- Initialize API return status to access

Line 1102: x_return_status := FND_API.G_RET_STS_SUCCESS;

1098: FND_MSG_PUB.initialize;
1099: END IF;
1100: --
1101: -- Initialize API return status to access
1102: x_return_status := FND_API.G_RET_STS_SUCCESS;
1103: --
1104: -- For WIP see whether jobs and/or schedules should be included
1105: IF ( p_wip_rel_jobs_flag = 1 OR p_wip_unrel_jobs_flag = 1 OR
1106: p_wip_hold_jobs_flag = 1 ) THEN

Line 1554: WHEN FND_API.G_EXC_ERROR THEN

1550: FND_MSG_PUB.Count_And_Get
1551: (p_count => x_msg_count
1552: , p_data => x_msg_data);
1553: EXCEPTION
1554: WHEN FND_API.G_EXC_ERROR THEN
1555: --
1556: x_return_status := FND_API.G_RET_STS_ERROR;
1557: --
1558: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

Line 1556: x_return_status := FND_API.G_RET_STS_ERROR;

1552: , p_data => x_msg_data);
1553: EXCEPTION
1554: WHEN FND_API.G_EXC_ERROR THEN
1555: --
1556: x_return_status := FND_API.G_RET_STS_ERROR;
1557: --
1558: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
1559: , p_data => x_msg_data);
1560: --

Line 1561: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1557: --
1558: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
1559: , p_data => x_msg_data);
1560: --
1561: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1562: --
1563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1564: --
1565: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

Line 1563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1559: , p_data => x_msg_data);
1560: --
1561: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1562: --
1563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1564: --
1565: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
1566: , p_data => x_msg_data);
1567: --

Line 1570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1566: , p_data => x_msg_data);
1567: --
1568: WHEN OTHERS THEN
1569: --
1570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1571: --
1572: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1573: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1574: END IF;

Line 1590: -- DEFAULT = FND_API.G_FALSE,

1586: -- p_api_version IN NUMBER (required)
1587: -- API Version of this procedure
1588: --
1589: -- p_init_msg_list IN VARCHAR2 (optional)
1590: -- DEFAULT = FND_API.G_FALSE,
1591: --
1592: -- OUT :
1593: -- x_return_status OUT NUMBER
1594: -- Result of all the operations

Line 1608: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1604: -- Notes :
1605: -- END OF comments
1606: PROCEDURE InsertUpdate (
1607: p_api_version IN NUMBER ,
1608: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1609: x_return_status IN OUT NOCOPY VARCHAR2,
1610: x_msg_count IN OUT NOCOPY NUMBER,
1611: x_msg_data IN OUT NOCOPY VARCHAR2,
1612: p_organization_id IN NUMBER,

Line 1629: IF NOT FND_API.Compatible_API_Call(l_api_version

1625: L_api_name CONSTANT VARCHAR2(30) := 'InsertUpdate';
1626: L_Object_Exists NUMBER;
1627: BEGIN
1628: -- Standard Call to check for call compatibility
1629: IF NOT FND_API.Compatible_API_Call(l_api_version
1630: , p_api_version
1631: , l_api_name
1632: , G_PKG_NAME) THEN
1633: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1633: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1629: IF NOT FND_API.Compatible_API_Call(l_api_version
1630: , p_api_version
1631: , l_api_name
1632: , G_PKG_NAME) THEN
1633: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1634: END IF;
1635: --
1636: -- Initialize message list if p_init_msg_list is set to true
1637: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1637: IF FND_API.to_Boolean(p_init_msg_list) THEN

1633: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1634: END IF;
1635: --
1636: -- Initialize message list if p_init_msg_list is set to true
1637: IF FND_API.to_Boolean(p_init_msg_list) THEN
1638: FND_MSG_PUB.initialize;
1639: END IF;
1640: --
1641: -- Initialize API return status to access

Line 1642: x_return_status := FND_API.G_RET_STS_SUCCESS;

1638: FND_MSG_PUB.initialize;
1639: END IF;
1640: --
1641: -- Initialize API return status to access
1642: x_return_status := FND_API.G_RET_STS_SUCCESS;
1643: --
1644: -- Insert/Update of shortage statement table
1645: -- First the detail statement
1646: OPEN crsStatement ( p_organization_id,

Line 1721: WHEN FND_API.G_EXC_ERROR THEN

1717: FND_MSG_PUB.Count_And_Get
1718: (p_count => x_msg_count
1719: , p_data => x_msg_data);
1720: EXCEPTION
1721: WHEN FND_API.G_EXC_ERROR THEN
1722: --
1723: x_return_status := FND_API.G_RET_STS_ERROR;
1724: --
1725: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

Line 1723: x_return_status := FND_API.G_RET_STS_ERROR;

1719: , p_data => x_msg_data);
1720: EXCEPTION
1721: WHEN FND_API.G_EXC_ERROR THEN
1722: --
1723: x_return_status := FND_API.G_RET_STS_ERROR;
1724: --
1725: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
1726: , p_data => x_msg_data);
1727: --

Line 1728: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1724: --
1725: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
1726: , p_data => x_msg_data);
1727: --
1728: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1729: --
1730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1731: --
1732: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

Line 1730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1726: , p_data => x_msg_data);
1727: --
1728: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1729: --
1730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1731: --
1732: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
1733: , p_data => x_msg_data);
1734: --

Line 1737: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1733: , p_data => x_msg_data);
1734: --
1735: WHEN OTHERS THEN
1736: --
1737: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1738: --
1739: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1740: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1741: END IF;

Line 1757: -- DEFAULT = FND_API.G_FALSE,

1753: -- p_api_version IN NUMBER (required)
1754: -- API Version of this procedure
1755: --
1756: -- p_init_msg_list IN VARCHAR2 (optional)
1757: -- DEFAULT = FND_API.G_FALSE,
1758: --
1759: -- p_commit IN VARCHAR2 (optional)
1760: -- DEFAULT = FND_API.G_FALSE
1761: --

Line 1760: -- DEFAULT = FND_API.G_FALSE

1756: -- p_init_msg_list IN VARCHAR2 (optional)
1757: -- DEFAULT = FND_API.G_FALSE,
1758: --
1759: -- p_commit IN VARCHAR2 (optional)
1760: -- DEFAULT = FND_API.G_FALSE
1761: --
1762: -- OUT :
1763: -- x_return_status OUT NUMBER
1764: -- Result of all the operations

Line 1784: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1780: -- Notes :
1781: -- END OF comments
1782: PROCEDURE StartBuild (
1783: p_api_version IN NUMBER ,
1784: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1785: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1786: x_return_status IN OUT NOCOPY VARCHAR2,
1787: x_msg_count IN OUT NOCOPY NUMBER,
1788: x_msg_data IN OUT NOCOPY VARCHAR2,

Line 1785: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1781: -- END OF comments
1782: PROCEDURE StartBuild (
1783: p_api_version IN NUMBER ,
1784: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1785: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1786: x_return_status IN OUT NOCOPY VARCHAR2,
1787: x_msg_count IN OUT NOCOPY NUMBER,
1788: x_msg_data IN OUT NOCOPY VARCHAR2,
1789: p_organization_id IN NUMBER,

Line 1819: IF NOT FND_API.Compatible_API_Call(l_api_version

1815: L_Short_stat_sum LONG;
1816: L_Short_stat_detail LONG;
1817: BEGIN
1818: -- Standard Call to check for call compatibility
1819: IF NOT FND_API.Compatible_API_Call(l_api_version
1820: , p_api_version
1821: , l_api_name
1822: , G_PKG_NAME) THEN
1823: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1823: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1819: IF NOT FND_API.Compatible_API_Call(l_api_version
1820: , p_api_version
1821: , l_api_name
1822: , G_PKG_NAME) THEN
1823: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1824: END IF;
1825: --
1826: -- Initialize message list if p_init_msg_list is set to true
1827: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1827: IF FND_API.to_Boolean(p_init_msg_list) THEN

1823: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1824: END IF;
1825: --
1826: -- Initialize message list if p_init_msg_list is set to true
1827: IF FND_API.to_Boolean(p_init_msg_list) THEN
1828: FND_MSG_PUB.initialize;
1829: END IF;
1830: --
1831: -- Initialize API return status to access

Line 1832: x_return_status := FND_API.G_RET_STS_SUCCESS;

1828: FND_MSG_PUB.initialize;
1829: END IF;
1830: --
1831: -- Initialize API return status to access
1832: x_return_status := FND_API.G_RET_STS_SUCCESS;
1833: --
1834: BuildDetail (
1835: p_api_version => 1.0,
1836: p_init_msg_list => p_init_msg_list,

Line 1906: IF FND_API.to_Boolean(p_commit) THEN

1902: p_short_stat_detail => L_Short_stat_detail
1903: );
1904: --
1905: -- Standard check of p_commit
1906: IF FND_API.to_Boolean(p_commit) THEN
1907: COMMIT;
1908: END IF;
1909: -- Standard call to get message count and if count is 1, get message info
1910: FND_MSG_PUB.Count_And_Get

Line 1914: WHEN FND_API.G_EXC_ERROR THEN

1910: FND_MSG_PUB.Count_And_Get
1911: (p_count => x_msg_count
1912: , p_data => x_msg_data);
1913: EXCEPTION
1914: WHEN FND_API.G_EXC_ERROR THEN
1915: --
1916: x_return_status := FND_API.G_RET_STS_ERROR;
1917: --
1918: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

Line 1916: x_return_status := FND_API.G_RET_STS_ERROR;

1912: , p_data => x_msg_data);
1913: EXCEPTION
1914: WHEN FND_API.G_EXC_ERROR THEN
1915: --
1916: x_return_status := FND_API.G_RET_STS_ERROR;
1917: --
1918: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
1919: , p_data => x_msg_data);
1920: --

Line 1921: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1917: --
1918: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
1919: , p_data => x_msg_data);
1920: --
1921: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1922: --
1923: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1924: --
1925: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

Line 1923: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1919: , p_data => x_msg_data);
1920: --
1921: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1922: --
1923: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1924: --
1925: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
1926: , p_data => x_msg_data);
1927: --

Line 1930: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1926: , p_data => x_msg_data);
1927: --
1928: WHEN OTHERS THEN
1929: --
1930: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1931: --
1932: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1933: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1934: END IF;