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

Line 1121: RAISE FND_API.G_EXC_ERROR;

1117: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules1.build_ilv1',
1118: 'JTY_TAE_GEN_PVT.build_ilv1 API has failed');
1119: END IF;
1120:
1121: RAISE FND_API.G_EXC_ERROR;
1122: END IF;
1123:
1124:
1125: p_sql := p_sql || l_ilv1_sql;

Line 1153: RAISE FND_API.G_EXC_ERROR;

1149: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules1.build_qualifier_rules',
1150: 'JTY_TAE_GEN_PVT.build_qualifier_rules API has failed');
1151: END IF;
1152:
1153: RAISE FND_API.G_EXC_ERROR;
1154: END IF;
1155:
1156: p_sql := p_sql || l_ilv2_sql;
1157:

Line 1191: WHEN FND_API.G_EXC_ERROR THEN

1187:
1188: retcode := 0;
1189: errbuf := null;
1190: EXCEPTION
1191: WHEN FND_API.G_EXC_ERROR THEN
1192: RETCODE := 2;
1193: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1194: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1195: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules1.g_exc_error',

Line 1196: 'API JTY_TAE_GEN_PVT..build_qualifier_rules1 has failed with FND_API.G_EXC_ERROR exception');

1192: RETCODE := 2;
1193: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1194: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1195: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules1.g_exc_error',
1196: 'API JTY_TAE_GEN_PVT..build_qualifier_rules1 has failed with FND_API.G_EXC_ERROR exception');
1197: END IF;
1198:
1199: WHEN L_SCHEMA_NOTFOUND THEN
1200: errbuf := 'Schema name corresponding to JTF application not found';

Line 1276: RAISE FND_API.G_EXC_ERROR;

1272: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_terr_rules_recurse.get_insert_select_nmtrans',
1273: 'JTY_TAE_GEN_PVT.get_insert_select_nmtrans API has failed');
1274: END IF;
1275:
1276: RAISE FND_API.G_EXC_ERROR;
1277: END IF;
1278:
1279: END IF;
1280:

Line 1404: RAISE FND_API.G_EXC_ERROR;

1400: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_terr_rules_recurse.Build_Qualifier_Rules1',
1401: 'JTY_TAE_GEN_PVT.Build_Qualifier_Rules1 API has failed');
1402: END IF;
1403:
1404: RAISE FND_API.G_EXC_ERROR;
1405: END IF;
1406:
1407: l_match_sql := l_match_sql || l_sql;
1408:

Line 1439: RAISE FND_API.G_EXC_ERROR;

1435: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_terr_rules_recurse.Build_Qualifier_Rules',
1436: 'JTY_TAE_GEN_PVT.Build_Qualifier_Rules API has failed');
1437: END IF;
1438:
1439: RAISE FND_API.G_EXC_ERROR;
1440: END IF;
1441:
1442: l_match_sql := l_match_sql || l_sql;
1443: END IF;

Line 1458: WHEN FND_API.G_EXC_ERROR THEN

1454: retcode := 0;
1455: errbuf := null;
1456:
1457: EXCEPTION
1458: WHEN FND_API.G_EXC_ERROR THEN
1459: RETCODE := 2;
1460: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1461: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1462: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_terr_rules_recurse.g_exc_error',

Line 1463: 'API JTY_TAE_GEN_PVT.gen_terr_rules_recurse has failed with FND_API.G_EXC_ERROR exception');

1459: RETCODE := 2;
1460: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1461: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1462: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_terr_rules_recurse.g_exc_error',
1463: 'API JTY_TAE_GEN_PVT.gen_terr_rules_recurse has failed with FND_API.G_EXC_ERROR exception');
1464: END IF;
1465:
1466: WHEN OTHERS THEN
1467: RETCODE := 2;

Line 1535: RAISE FND_API.G_EXC_ERROR;

1531: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_batch_sql.no_qual_product',
1532: 'JTY_TAE_GEN_PVT.gen_batch_sql API has failed as there is no qual product to be processed');
1533: END IF;
1534:
1535: RAISE FND_API.G_EXC_ERROR;
1536: END IF;
1537:
1538: IF (p_mode = 'DATE EFFECTIVE') THEN
1539: SELECT denorm_dea_value_table_name

Line 1562: RAISE FND_API.G_EXC_ERROR;

1558: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_batch_sql.Classify_dea_Territories',
1559: 'jty_tae_control_pvt.Classify_dea_Territories API has failed');
1560: END IF;
1561:
1562: RAISE FND_API.G_EXC_ERROR;
1563: END IF;
1564: ELSE
1565: SELECT denorm_value_table_name
1566: INTO l_denorm_table_name

Line 1589: RAISE FND_API.G_EXC_ERROR;

1585: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_batch_sql.Classify_Territories',
1586: 'jty_tae_control_pvt.Classify_Territories API has failed');
1587: END IF;
1588:
1589: RAISE FND_API.G_EXC_ERROR;
1590: END IF;
1591:
1592: END IF; /* end IF (p_mode = 'DATE EFFECTIVE') */
1593:

Line 1647: RAISE FND_API.G_EXC_ERROR;

1643: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_batch_sql.gen_terr_rules_recurse1',
1644: 'JTY_TAE_GEN_PVT.gen_terr_rules_recurse API has failed');
1645: END IF;
1646:
1647: RAISE FND_API.G_EXC_ERROR;
1648: END IF;
1649:
1650: IF (p_mode <> 'DATE EFFECTIVE') THEN
1651: gen_terr_rules_recurse (

Line 1673: RAISE FND_API.G_EXC_ERROR;

1669: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_batch_sql.gen_terr_rules_recurse2',
1670: 'JTY_TAE_GEN_PVT.gen_terr_rules_recurse API has failed');
1671: END IF;
1672:
1673: RAISE FND_API.G_EXC_ERROR;
1674: END IF;
1675:
1676: gen_terr_rules_recurse (
1677: p_source_id => p_source_id,

Line 1698: RAISE FND_API.G_EXC_ERROR;

1694: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_batch_sql.gen_terr_rules_recurse3',
1695: 'JTY_TAE_GEN_PVT.gen_terr_rules_recurse API has failed');
1696: END IF;
1697:
1698: RAISE FND_API.G_EXC_ERROR;
1699: END IF;
1700:
1701: INSERT INTO JTY_TAE_ATTR_PRODUCTS_SQL(
1702: ATTR_PRODUCTS_SQL_ID

Line 1798: WHEN FND_API.G_EXC_ERROR THEN

1794: retcode := 0;
1795: errbuf := null;
1796:
1797: EXCEPTION
1798: WHEN FND_API.G_EXC_ERROR THEN
1799: RETCODE := 2;
1800: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1801: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1802: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_batch_sql.g_exc_error',

Line 1803: 'API JTY_TAE_GEN_PVT.gen_batch_sql has failed with FND_API.G_EXC_ERROR exception');

1799: RETCODE := 2;
1800: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1801: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1802: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_batch_sql.g_exc_error',
1803: 'API JTY_TAE_GEN_PVT.gen_batch_sql has failed with FND_API.G_EXC_ERROR exception');
1804: END IF;
1805:
1806: WHEN OTHERS THEN
1807: RETCODE := 2;