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 1084: RAISE FND_API.G_EXC_ERROR;

1080: jty_log(FND_LOG.LEVEL_EXCEPTION,
1081: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules1.build_ilv1',
1082: 'JTY_TAE_GEN_PVT.build_ilv1 API has failed');
1083:
1084: RAISE FND_API.G_EXC_ERROR;
1085: END IF;
1086:
1087:
1088: p_sql := p_sql || l_ilv1_sql;

Line 1114: RAISE FND_API.G_EXC_ERROR;

1110: jty_log(FND_LOG.LEVEL_EXCEPTION,
1111: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules1.build_qualifier_rules',
1112: 'JTY_TAE_GEN_PVT.build_qualifier_rules API has failed');
1113:
1114: RAISE FND_API.G_EXC_ERROR;
1115: END IF;
1116:
1117: p_sql := p_sql || l_ilv2_sql;
1118:

Line 1150: WHEN FND_API.G_EXC_ERROR THEN

1146:
1147: retcode := 0;
1148: errbuf := null;
1149: EXCEPTION
1150: WHEN FND_API.G_EXC_ERROR THEN
1151: RETCODE := 2;
1152: jty_log(FND_LOG.LEVEL_EXCEPTION,
1153: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules1.g_exc_error',
1154: 'API JTY_TAE_GEN_PVT..build_qualifier_rules1 has failed with FND_API.G_EXC_ERROR exception');

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

1150: WHEN FND_API.G_EXC_ERROR THEN
1151: RETCODE := 2;
1152: jty_log(FND_LOG.LEVEL_EXCEPTION,
1153: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules1.g_exc_error',
1154: 'API JTY_TAE_GEN_PVT..build_qualifier_rules1 has failed with FND_API.G_EXC_ERROR exception');
1155:
1156: WHEN L_SCHEMA_NOTFOUND THEN
1157: errbuf := 'Schema name corresponding to JTF application not found';
1158: retcode := 2;

Line 1225: RAISE FND_API.G_EXC_ERROR;

1221: jty_log(FND_LOG.LEVEL_EXCEPTION,
1222: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_terr_rules_recurse.get_insert_select_nmtrans',
1223: 'JTY_TAE_GEN_PVT.get_insert_select_nmtrans API has failed');
1224:
1225: RAISE FND_API.G_EXC_ERROR;
1226: END IF;
1227:
1228: END IF;
1229:

Line 1351: RAISE FND_API.G_EXC_ERROR;

1347: jty_log(FND_LOG.LEVEL_EXCEPTION,
1348: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_terr_rules_recurse.Build_Qualifier_Rules1',
1349: 'JTY_TAE_GEN_PVT.Build_Qualifier_Rules1 API has failed');
1350:
1351: RAISE FND_API.G_EXC_ERROR;
1352: END IF;
1353:
1354: l_match_sql := l_match_sql || l_sql;
1355:

Line 1384: RAISE FND_API.G_EXC_ERROR;

1380: jty_log(FND_LOG.LEVEL_EXCEPTION,
1381: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_terr_rules_recurse.Build_Qualifier_Rules',
1382: 'JTY_TAE_GEN_PVT.Build_Qualifier_Rules API has failed');
1383:
1384: RAISE FND_API.G_EXC_ERROR;
1385: END IF;
1386:
1387: l_match_sql := l_match_sql || l_sql;
1388: END IF;

Line 1401: WHEN FND_API.G_EXC_ERROR THEN

1397: retcode := 0;
1398: errbuf := null;
1399:
1400: EXCEPTION
1401: WHEN FND_API.G_EXC_ERROR THEN
1402: RETCODE := 2;
1403: jty_log(FND_LOG.LEVEL_EXCEPTION,
1404: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_terr_rules_recurse.g_exc_error',
1405: 'API JTY_TAE_GEN_PVT.gen_terr_rules_recurse has failed with FND_API.G_EXC_ERROR exception');

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

1401: WHEN FND_API.G_EXC_ERROR THEN
1402: RETCODE := 2;
1403: jty_log(FND_LOG.LEVEL_EXCEPTION,
1404: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_terr_rules_recurse.g_exc_error',
1405: 'API JTY_TAE_GEN_PVT.gen_terr_rules_recurse has failed with FND_API.G_EXC_ERROR exception');
1406:
1407: WHEN OTHERS THEN
1408: RETCODE := 2;
1409: ERRBUF := SQLCODE || ' : ' || SQLERRM;

Line 1472: RAISE FND_API.G_EXC_ERROR;

1468: jty_log(FND_LOG.LEVEL_EXCEPTION,
1469: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_batch_sql.no_qual_product',
1470: 'JTY_TAE_GEN_PVT.gen_batch_sql API has failed as there is no qual product to be processed');
1471:
1472: RAISE FND_API.G_EXC_ERROR;
1473: END IF;
1474:
1475: IF ((p_mode = 'DATE EFFECTIVE') or (p_mode = 'DEA INCREMENTAL')) THEN
1476: SELECT denorm_dea_value_table_name

Line 1497: RAISE FND_API.G_EXC_ERROR;

1493: jty_log(FND_LOG.LEVEL_EXCEPTION,
1494: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_batch_sql.Classify_dea_Territories',
1495: 'jty_tae_control_pvt.Classify_dea_Territories API has failed');
1496:
1497: RAISE FND_API.G_EXC_ERROR;
1498: END IF;
1499: ELSE
1500: SELECT denorm_value_table_name
1501: INTO l_denorm_table_name

Line 1522: RAISE FND_API.G_EXC_ERROR;

1518: jty_log(FND_LOG.LEVEL_EXCEPTION,
1519: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_batch_sql.Classify_Territories',
1520: 'jty_tae_control_pvt.Classify_Territories API has failed');
1521:
1522: RAISE FND_API.G_EXC_ERROR;
1523: END IF;
1524:
1525: END IF; /* end IF (p_mode = 'DATE EFFECTIVE') */
1526:

Line 1578: RAISE FND_API.G_EXC_ERROR;

1574: jty_log(FND_LOG.LEVEL_EXCEPTION,
1575: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_batch_sql.gen_terr_rules_recurse1',
1576: 'JTY_TAE_GEN_PVT.gen_terr_rules_recurse API has failed');
1577:
1578: RAISE FND_API.G_EXC_ERROR;
1579: END IF;
1580:
1581: IF (p_mode <> 'DATE EFFECTIVE') THEN
1582: gen_terr_rules_recurse (

Line 1602: RAISE FND_API.G_EXC_ERROR;

1598: jty_log(FND_LOG.LEVEL_EXCEPTION,
1599: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_batch_sql.gen_terr_rules_recurse2',
1600: 'JTY_TAE_GEN_PVT.gen_terr_rules_recurse API has failed');
1601:
1602: RAISE FND_API.G_EXC_ERROR;
1603: END IF;
1604:
1605: gen_terr_rules_recurse (
1606: p_source_id => p_source_id,

Line 1625: RAISE FND_API.G_EXC_ERROR;

1621: jty_log(FND_LOG.LEVEL_EXCEPTION,
1622: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_batch_sql.gen_terr_rules_recurse3',
1623: 'JTY_TAE_GEN_PVT.gen_terr_rules_recurse API has failed');
1624:
1625: RAISE FND_API.G_EXC_ERROR;
1626: END IF;
1627:
1628: INSERT INTO JTY_TAE_ATTR_PRODUCTS_SQL(
1629: ATTR_PRODUCTS_SQL_ID

Line 1726: WHEN FND_API.G_EXC_ERROR THEN

1722: retcode := 0;
1723: errbuf := null;
1724:
1725: EXCEPTION
1726: WHEN FND_API.G_EXC_ERROR THEN
1727: RETCODE := 2;
1728: jty_log(FND_LOG.LEVEL_EXCEPTION,
1729: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_batch_sql.g_exc_error',
1730: 'API JTY_TAE_GEN_PVT.gen_batch_sql has failed with FND_API.G_EXC_ERROR exception');

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

1726: WHEN FND_API.G_EXC_ERROR THEN
1727: RETCODE := 2;
1728: jty_log(FND_LOG.LEVEL_EXCEPTION,
1729: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_batch_sql.g_exc_error',
1730: 'API JTY_TAE_GEN_PVT.gen_batch_sql has failed with FND_API.G_EXC_ERROR exception');
1731:
1732: WHEN OTHERS THEN
1733: RETCODE := 2;
1734: ERRBUF := SQLCODE || ' : ' || SQLERRM;