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_OM dependencies on FND_API

Line 237: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

233: WHEN NO_DATA_FOUND THEN
234: NULL;
235: /* no data found is not an error. Not all items will have specs */
236: WHEN OTHERS THEN
237: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
238: /* exception defined in Populate_Coa_Data */
239:
240: END Look_For_CoC_Specs;
241: /* end procedure */

Line 669: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

665: WHEN NO_DATA_FOUND THEN
666: NULL;
667:
668: WHEN OTHERS THEN
669: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
670: /* exception defined in Populate_Coa_Data */
671:
672: END Populate_Details;
673:

Line 761: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

757: NULL;
758: /* there may not be text information for this result rec */
759:
760: WHEN OTHERS THEN
761: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
762:
763: END Populate_Text;
764:
765:

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

782: # replaced with NVL(tbl_hdr.FIRST,0) and NVL(tbl_hdr.LAST,0).
783: ################################################################*/
784: PROCEDURE Populate_CoA_Data (
785: p_api_version In NUMBER,
786: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
787: p_commit IN VARCHAR2 := FND_API.G_FALSE,
788: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
789: rec_param IN t_coa_parameters,
790: x_return_status OUT NOCOPY VARCHAR2,

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

783: ################################################################*/
784: PROCEDURE Populate_CoA_Data (
785: p_api_version In NUMBER,
786: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
787: p_commit IN VARCHAR2 := FND_API.G_FALSE,
788: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
789: rec_param IN t_coa_parameters,
790: x_return_status OUT NOCOPY VARCHAR2,
791: x_msg_count OUT NOCOPY NUMBER,

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

784: PROCEDURE Populate_CoA_Data (
785: p_api_version In NUMBER,
786: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
787: p_commit IN VARCHAR2 := FND_API.G_FALSE,
788: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
789: rec_param IN t_coa_parameters,
790: x_return_status OUT NOCOPY VARCHAR2,
791: x_msg_count OUT NOCOPY NUMBER,
792: x_msg_data OUT NOCOPY VARCHAR2,

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

1032:
1033:
1034: /* Do API standard code for savepoint, messages, initialize return status */
1035: SAVEPOINT Populate_CoA_Data_SAVE;
1036: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
1037: l_api_name, G_PKG_NAME) THEN
1038: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1039: END IF;
1040: IF FND_API.to_Boolean (p_init_msg_list) THEN

Line 1038: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1034: /* Do API standard code for savepoint, messages, initialize return status */
1035: SAVEPOINT Populate_CoA_Data_SAVE;
1036: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
1037: l_api_name, G_PKG_NAME) THEN
1038: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1039: END IF;
1040: IF FND_API.to_Boolean (p_init_msg_list) THEN
1041: FND_MSG_PUB.initialize;
1042: END IF;

Line 1040: IF FND_API.to_Boolean (p_init_msg_list) THEN

1036: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
1037: l_api_name, G_PKG_NAME) THEN
1038: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1039: END IF;
1040: IF FND_API.to_Boolean (p_init_msg_list) THEN
1041: FND_MSG_PUB.initialize;
1042: END IF;
1043: x_return_status := FND_API.G_RET_STS_SUCCESS;
1044: v_report_title := 'COA';

Line 1043: x_return_status := FND_API.G_RET_STS_SUCCESS;

1039: END IF;
1040: IF FND_API.to_Boolean (p_init_msg_list) THEN
1041: FND_MSG_PUB.initialize;
1042: END IF;
1043: x_return_status := FND_API.G_RET_STS_SUCCESS;
1044: v_report_title := 'COA';
1045: /*IF (l_debug_enabled = 'Y') THEN
1046: select value into l_utl_file_dir from v$parameter where name like 'utl_file_dir';
1047: fnd_file.put_names('coacoc.log','coacoc.out',l_utl_file_dir);

Line 1288: IF FND_API.To_Boolean(p_commit) THEN

1284: END IF;
1285: /* end if there are any records in header table */
1286:
1287: /* -- standard check of p_commit */
1288: IF FND_API.To_Boolean(p_commit) THEN
1289: COMMIT WORK;
1290: END IF;
1291: /* -- standard call to get message count and if count is 1, get message info */
1292: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

Line 1295: WHEN FND_API.G_EXC_ERROR THEN

1291: /* -- standard call to get message count and if count is 1, get message info */
1292: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1293: --fnd_file.close;
1294: EXCEPTION
1295: WHEN FND_API.G_EXC_ERROR THEN
1296: ROLLBACK TO Populate_CoA_Data_Save;
1297: x_return_status := FND_API.G_RET_STS_ERROR;
1298: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1299:

Line 1297: x_return_status := FND_API.G_RET_STS_ERROR;

1293: --fnd_file.close;
1294: EXCEPTION
1295: WHEN FND_API.G_EXC_ERROR THEN
1296: ROLLBACK TO Populate_CoA_Data_Save;
1297: x_return_status := FND_API.G_RET_STS_ERROR;
1298: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1299:
1300: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1301: ROLLBACK TO Populate_CoA_Data_Save;

Line 1300: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1296: ROLLBACK TO Populate_CoA_Data_Save;
1297: x_return_status := FND_API.G_RET_STS_ERROR;
1298: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1299:
1300: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1301: ROLLBACK TO Populate_CoA_Data_Save;
1302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1303: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1304:

Line 1302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1298: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1299:
1300: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1301: ROLLBACK TO Populate_CoA_Data_Save;
1302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1303: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1304:
1305: WHEN OTHERS THEN
1306: ROLLBACK TO Populate_CoA_Data_Save;

Line 1307: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1303: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1304:
1305: WHEN OTHERS THEN
1306: ROLLBACK TO Populate_CoA_Data_Save;
1307: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1308: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1309: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1310:
1311: END Populate_CoA_Data;

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

1333:
1334:
1335: PROCEDURE Dump_To_Db_Tables (
1336: p_api_version In NUMBER,
1337: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1338: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1339: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1340: tbl_hdr IN t_coa_header_tbl,
1341: tbl_dtl IN t_coa_detail_tbl,

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

1334:
1335: PROCEDURE Dump_To_Db_Tables (
1336: p_api_version In NUMBER,
1337: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1338: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1339: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1340: tbl_hdr IN t_coa_header_tbl,
1341: tbl_dtl IN t_coa_detail_tbl,
1342: tbl_spec_text IN t_coa_text_tbl,

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

1335: PROCEDURE Dump_To_Db_Tables (
1336: p_api_version In NUMBER,
1337: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1338: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1339: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1340: tbl_hdr IN t_coa_header_tbl,
1341: tbl_dtl IN t_coa_detail_tbl,
1342: tbl_spec_text IN t_coa_text_tbl,
1343: tbl_rslt_text IN t_coa_text_tbl,

Line 1356: IF FND_API.to_Boolean (p_init_msg_list) THEN

1352: l_api_version CONSTANT NUMBER := 1.6;
1353:
1354: begin
1355:
1356: IF FND_API.to_Boolean (p_init_msg_list) THEN
1357: FND_MSG_PUB.initialize;
1358: END IF;
1359: x_return_status := FND_API.G_RET_STS_SUCCESS;
1360:

Line 1359: x_return_status := FND_API.G_RET_STS_SUCCESS;

1355:
1356: IF FND_API.to_Boolean (p_init_msg_list) THEN
1357: FND_MSG_PUB.initialize;
1358: END IF;
1359: x_return_status := FND_API.G_RET_STS_SUCCESS;
1360:
1361: /* ******* if db table is necessary and for debugging ***** -- */
1362:
1363: delete from gmd_coa_headers;

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

1366: delete from gmd_coa_rslt_text;
1367:
1368: /* -- Do API standard code for savepoint, messages, initialize return status */
1369: SAVEPOINT Dump_To_Db_Tables_SAVE;
1370: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
1371: l_api_name, G_PKG_NAME) THEN
1372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1373: END IF;
1374:

Line 1372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1368: /* -- Do API standard code for savepoint, messages, initialize return status */
1369: SAVEPOINT Dump_To_Db_Tables_SAVE;
1370: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
1371: l_api_name, G_PKG_NAME) THEN
1372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1373: END IF;
1374:
1375: IF tbl_hdr.FIRST is not NULL THEN
1376: X_user_id := FND_GLOBAL.USER_ID;

Line 1502: IF FND_API.To_Boolean(p_commit) THEN

1498: END IF;
1499: /* if there is something in header table */
1500:
1501: /* -- standard check of p_commit */
1502: IF FND_API.To_Boolean(p_commit) THEN
1503: COMMIT WORK;
1504: END IF;
1505:
1506: /* -- standard call to get message count and if count is 1, get message info */

Line 1510: WHEN FND_API.G_EXC_ERROR THEN

1506: /* -- standard call to get message count and if count is 1, get message info */
1507: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1508:
1509: EXCEPTION
1510: WHEN FND_API.G_EXC_ERROR THEN
1511: ROLLBACK TO Dump_To_Db_Tables_Save;
1512: x_return_status := FND_API.G_RET_STS_ERROR;
1513: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1514:

Line 1512: x_return_status := FND_API.G_RET_STS_ERROR;

1508:
1509: EXCEPTION
1510: WHEN FND_API.G_EXC_ERROR THEN
1511: ROLLBACK TO Dump_To_Db_Tables_Save;
1512: x_return_status := FND_API.G_RET_STS_ERROR;
1513: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1514:
1515: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1516: ROLLBACK TO Dump_To_Db_Tables_Save;

Line 1515: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1511: ROLLBACK TO Dump_To_Db_Tables_Save;
1512: x_return_status := FND_API.G_RET_STS_ERROR;
1513: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1514:
1515: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1516: ROLLBACK TO Dump_To_Db_Tables_Save;
1517: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1518: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1519:

Line 1517: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1513: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1514:
1515: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1516: ROLLBACK TO Dump_To_Db_Tables_Save;
1517: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1518: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1519:
1520: WHEN OTHERS THEN
1521: ROLLBACK TO Dump_To_Db_Tables_Save;

Line 1522: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1518: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1519:
1520: WHEN OTHERS THEN
1521: ROLLBACK TO Dump_To_Db_Tables_Save;
1522: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1523: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1524: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1525:
1526: END Dump_To_Db_Tables;