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.GMD_COA_DATA_NEW dependencies on FND_API

Line 821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

817: WHEN NO_DATA_FOUND THEN
818: NULL;
819: /* no data found is not an error. Not all items will have specs */
820: WHEN OTHERS THEN
821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
822: /* exception defined in Populate_Coa_Data */
823:
824: END Look_For_CoC_Specs;
825: /* end procedure */

Line 1215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1211: WHEN NO_DATA_FOUND THEN
1212: NULL;
1213:
1214: WHEN OTHERS THEN
1215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1216: /* exception defined in Populate_Coa_Data */
1217:
1218: END Populate_Details;
1219:

Line 1307: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1303: NULL;
1304: /* there may not be text information for this result rec */
1305:
1306: WHEN OTHERS THEN
1307: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1308:
1309: END Populate_Text;
1310:
1311:

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

1328: # replaced with NVL(tbl_hdr.FIRST,0) and NVL(tbl_hdr.LAST,0).
1329: ################################################################*/
1330: PROCEDURE Populate_CoA_Data (
1331: p_api_version In NUMBER,
1332: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1333: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1334: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1335: rec_param IN t_coa_parameters,
1336: x_return_status OUT NOCOPY VARCHAR2,

Line 1333: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1329: ################################################################*/
1330: PROCEDURE Populate_CoA_Data (
1331: p_api_version In NUMBER,
1332: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1333: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1334: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1335: rec_param IN t_coa_parameters,
1336: x_return_status OUT NOCOPY VARCHAR2,
1337: x_msg_count OUT NOCOPY NUMBER,

Line 1334: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1330: PROCEDURE Populate_CoA_Data (
1331: p_api_version In NUMBER,
1332: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1333: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1334: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1335: rec_param IN t_coa_parameters,
1336: x_return_status OUT NOCOPY VARCHAR2,
1337: x_msg_count OUT NOCOPY NUMBER,
1338: x_msg_data OUT NOCOPY VARCHAR2,

Line 1621: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,

1617: BEGIN
1618:
1619: /* Do API standard code for savepoint, messages, initialize return status */
1620: SAVEPOINT Populate_CoA_Data_SAVE;
1621: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
1622: l_api_name, G_PKG_NAME) THEN
1623: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1624: END IF;
1625: IF FND_API.to_Boolean (p_init_msg_list) THEN

Line 1623: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1619: /* Do API standard code for savepoint, messages, initialize return status */
1620: SAVEPOINT Populate_CoA_Data_SAVE;
1621: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
1622: l_api_name, G_PKG_NAME) THEN
1623: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1624: END IF;
1625: IF FND_API.to_Boolean (p_init_msg_list) THEN
1626: FND_MSG_PUB.initialize;
1627: END IF;

Line 1625: IF FND_API.to_Boolean (p_init_msg_list) THEN

1621: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
1622: l_api_name, G_PKG_NAME) THEN
1623: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1624: END IF;
1625: IF FND_API.to_Boolean (p_init_msg_list) THEN
1626: FND_MSG_PUB.initialize;
1627: END IF;
1628: x_return_status := FND_API.G_RET_STS_SUCCESS;
1629: v_report_title := 'COA';

Line 1628: x_return_status := FND_API.G_RET_STS_SUCCESS;

1624: END IF;
1625: IF FND_API.to_Boolean (p_init_msg_list) THEN
1626: FND_MSG_PUB.initialize;
1627: END IF;
1628: x_return_status := FND_API.G_RET_STS_SUCCESS;
1629: v_report_title := 'COA';
1630:
1631: IF rec_param.order_id is not NULL or rec_param.bol_id is not NULL
1632: or rec_param.from_shipdate is not NULL THEN

Line 1836: IF FND_API.To_Boolean(p_commit) THEN

1832: END IF;
1833: /* end if there are any records in header table */
1834:
1835: /* -- standard check of p_commit */
1836: IF FND_API.To_Boolean(p_commit) THEN
1837: COMMIT WORK;
1838: END IF;
1839: /* -- standard call to get message count and if count is 1, get message info */
1840: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

Line 1843: WHEN FND_API.G_EXC_ERROR THEN

1839: /* -- standard call to get message count and if count is 1, get message info */
1840: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1841:
1842: EXCEPTION
1843: WHEN FND_API.G_EXC_ERROR THEN
1844: ROLLBACK TO Populate_CoA_Data_Save;
1845: x_return_status := FND_API.G_RET_STS_ERROR;
1846: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1847:

Line 1845: x_return_status := FND_API.G_RET_STS_ERROR;

1841:
1842: EXCEPTION
1843: WHEN FND_API.G_EXC_ERROR THEN
1844: ROLLBACK TO Populate_CoA_Data_Save;
1845: x_return_status := FND_API.G_RET_STS_ERROR;
1846: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1847:
1848: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1849: ROLLBACK TO Populate_CoA_Data_Save;

Line 1848: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1844: ROLLBACK TO Populate_CoA_Data_Save;
1845: x_return_status := FND_API.G_RET_STS_ERROR;
1846: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1847:
1848: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1849: ROLLBACK TO Populate_CoA_Data_Save;
1850: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1851: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1852:

Line 1850: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1846: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1847:
1848: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1849: ROLLBACK TO Populate_CoA_Data_Save;
1850: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1851: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1852:
1853: WHEN OTHERS THEN
1854: ROLLBACK TO Populate_CoA_Data_Save;

Line 1855: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1851: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1852:
1853: WHEN OTHERS THEN
1854: ROLLBACK TO Populate_CoA_Data_Save;
1855: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1856: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1857: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1858:
1859: END Populate_CoA_Data;

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

1881:
1882:
1883: PROCEDURE Dump_To_Db_Tables (
1884: p_api_version In NUMBER,
1885: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1886: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1887: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1888: tbl_hdr IN t_coa_header_tbl,
1889: tbl_dtl IN t_coa_detail_tbl,

Line 1886: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1882:
1883: PROCEDURE Dump_To_Db_Tables (
1884: p_api_version In NUMBER,
1885: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1886: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1887: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1888: tbl_hdr IN t_coa_header_tbl,
1889: tbl_dtl IN t_coa_detail_tbl,
1890: tbl_spec_text IN t_coa_text_tbl,

Line 1887: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1883: PROCEDURE Dump_To_Db_Tables (
1884: p_api_version In NUMBER,
1885: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1886: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1887: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1888: tbl_hdr IN t_coa_header_tbl,
1889: tbl_dtl IN t_coa_detail_tbl,
1890: tbl_spec_text IN t_coa_text_tbl,
1891: tbl_rslt_text IN t_coa_text_tbl,

Line 1904: IF FND_API.to_Boolean (p_init_msg_list) THEN

1900: l_api_version CONSTANT NUMBER := 1.6;
1901:
1902: begin
1903:
1904: IF FND_API.to_Boolean (p_init_msg_list) THEN
1905: FND_MSG_PUB.initialize;
1906: END IF;
1907: x_return_status := FND_API.G_RET_STS_SUCCESS;
1908:

Line 1907: x_return_status := FND_API.G_RET_STS_SUCCESS;

1903:
1904: IF FND_API.to_Boolean (p_init_msg_list) THEN
1905: FND_MSG_PUB.initialize;
1906: END IF;
1907: x_return_status := FND_API.G_RET_STS_SUCCESS;
1908:
1909: /* ******* if db table is necessary and for debugging ***** -- */
1910:
1911: delete from gmd_coa_headers;

Line 1918: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,

1914: delete from gmd_coa_rslt_text;
1915:
1916: /* -- Do API standard code for savepoint, messages, initialize return status */
1917: SAVEPOINT Dump_To_Db_Tables_SAVE;
1918: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
1919: l_api_name, G_PKG_NAME) THEN
1920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1921: END IF;
1922:

Line 1920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1916: /* -- Do API standard code for savepoint, messages, initialize return status */
1917: SAVEPOINT Dump_To_Db_Tables_SAVE;
1918: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
1919: l_api_name, G_PKG_NAME) THEN
1920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1921: END IF;
1922:
1923: IF tbl_hdr.FIRST is not NULL THEN
1924: X_user_id := FND_GLOBAL.USER_ID;

Line 2050: IF FND_API.To_Boolean(p_commit) THEN

2046: END IF;
2047: /* if there is something in header table */
2048:
2049: /* -- standard check of p_commit */
2050: IF FND_API.To_Boolean(p_commit) THEN
2051: COMMIT WORK;
2052: END IF;
2053:
2054: /* -- standard call to get message count and if count is 1, get message info */

Line 2058: WHEN FND_API.G_EXC_ERROR THEN

2054: /* -- standard call to get message count and if count is 1, get message info */
2055: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2056:
2057: EXCEPTION
2058: WHEN FND_API.G_EXC_ERROR THEN
2059: ROLLBACK TO Dump_To_Db_Tables_Save;
2060: x_return_status := FND_API.G_RET_STS_ERROR;
2061: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2062:

Line 2060: x_return_status := FND_API.G_RET_STS_ERROR;

2056:
2057: EXCEPTION
2058: WHEN FND_API.G_EXC_ERROR THEN
2059: ROLLBACK TO Dump_To_Db_Tables_Save;
2060: x_return_status := FND_API.G_RET_STS_ERROR;
2061: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2062:
2063: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2064: ROLLBACK TO Dump_To_Db_Tables_Save;

Line 2063: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2059: ROLLBACK TO Dump_To_Db_Tables_Save;
2060: x_return_status := FND_API.G_RET_STS_ERROR;
2061: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2062:
2063: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2064: ROLLBACK TO Dump_To_Db_Tables_Save;
2065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2066: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2067:

Line 2065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2061: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2062:
2063: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2064: ROLLBACK TO Dump_To_Db_Tables_Save;
2065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2066: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2067:
2068: WHEN OTHERS THEN
2069: ROLLBACK TO Dump_To_Db_Tables_Save;

Line 2070: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2066: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2067:
2068: WHEN OTHERS THEN
2069: ROLLBACK TO Dump_To_Db_Tables_Save;
2070: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2071: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
2072: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
2073:
2074: END Dump_To_Db_Tables;