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

Line 109: x_return_status := FND_API.G_RET_STS_SUCCESS;

105: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.begin',
106: 'Start of the procedure jty_terr_denorm_rules_pvt.create_dnmval_index');
107: END IF;
108:
109: x_return_status := FND_API.G_RET_STS_SUCCESS;
110:
111: /* In incremental mode mark all the qualifier combination present */
112: /* in jtf_tae_qual_products as being used by active territories */
113: IF (p_mode = 'INCREMENTAL') THEN

Line 130: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

126: p_mode => p_mode,
127: p_source_id => p_source_id,
128: x_return_status => x_return_status);
129:
130: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
131: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
132: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
133: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.selectivity',
134: 'API jty_tae_index_creation_pvt.SELECTIVITY has failed');

Line 136: RAISE FND_API.G_EXC_ERROR;

132: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
133: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.selectivity',
134: 'API jty_tae_index_creation_pvt.SELECTIVITY has failed');
135: END IF;
136: RAISE FND_API.G_EXC_ERROR;
137: END IF;
138:
139: /* Determine the indexes that need to be created */
140: IF ((p_mode = 'TOTAL') OR (p_mode = 'INCREMENTAL')) THEN

Line 151: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

147: p_source_id => p_source_id,
148: x_Return_Status => x_return_status );
149: END IF;
150:
151: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
152: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
153: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
154: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.reduce_dnmval_idx_set',
155: 'API JTY_TAE_CONTROL_PVT.reduce_dnmval_idx_set has failed');

Line 157: RAISE FND_API.G_EXC_ERROR;

153: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
154: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.reduce_dnmval_idx_set',
155: 'API JTY_TAE_CONTROL_PVT.reduce_dnmval_idx_set has failed');
156: END IF;
157: RAISE FND_API.G_EXC_ERROR;
158: END IF;
159:
160: /* get default Degree of Parallelism */
161: SELECT MIN(TO_NUMBER(v.value))

Line 330: x_return_status := FND_API.G_RET_STS_ERROR ;

326: END IF;
327:
328: EXCEPTION
329: WHEN NO_DATA_FOUND THEN
330: x_return_status := FND_API.G_RET_STS_ERROR ;
331: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
332: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
333: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.no_data_found',
334: 'API jty_terr_denorm_rules_pvt.create_dnmval_index has failed with no_data_found');

Line 337: WHEN FND_API.G_EXC_ERROR THEN

333: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.no_data_found',
334: 'API jty_terr_denorm_rules_pvt.create_dnmval_index has failed with no_data_found');
335: END IF;
336:
337: WHEN FND_API.G_EXC_ERROR THEN
338: x_return_status := FND_API.G_RET_STS_ERROR ;
339: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
340: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
341: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.g_exc_error',

Line 338: x_return_status := FND_API.G_RET_STS_ERROR ;

334: 'API jty_terr_denorm_rules_pvt.create_dnmval_index has failed with no_data_found');
335: END IF;
336:
337: WHEN FND_API.G_EXC_ERROR THEN
338: x_return_status := FND_API.G_RET_STS_ERROR ;
339: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
340: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
341: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.g_exc_error',
342: 'jty_terr_denorm_rules_pvt.create_dnmval_index has failed with G_EXC_ERROR exception');

Line 346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

342: 'jty_terr_denorm_rules_pvt.create_dnmval_index has failed with G_EXC_ERROR exception');
343: END IF;
344:
345: WHEN OTHERS THEN
346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
347: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
348: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
349: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.others',
350: substr(SQLCODE || ' : ' || SQLERRM, 1, 4000));

Line 1525: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1521: , p_percent => 20
1522: , x_return_status => x_return_status );
1523: END IF;
1524:
1525: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1526: retcode := 2;
1527: errbuf := 'JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX has failed for table ' || l_table_name;
1528: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1529: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

Line 1534: RAISE FND_API.G_EXC_ERROR;

1530: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_values.analyze_table_index',
1531: 'ANALYZE_TABLE_INDEX API has failed');
1532: END IF;
1533:
1534: RAISE FND_API.G_EXC_ERROR;
1535: END IF;
1536:
1537: IF (l_qtype_terr_id_tbl.COUNT > 0) THEN
1538: /* disable the trigger before update */

Line 1598: WHEN FND_API.G_EXC_ERROR THEN

1594: retcode := 0;
1595: errbuf := null;
1596:
1597: EXCEPTION
1598: WHEN FND_API.G_EXC_ERROR THEN
1599: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1600: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1601: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_values.g_exc_error',
1602: 'API JTY_TERR_DENORM_RULES_PVT.process_attr_values has failed with FND_API.G_EXC_ERROR exception');

Line 1602: 'API JTY_TERR_DENORM_RULES_PVT.process_attr_values has failed with FND_API.G_EXC_ERROR exception');

1598: WHEN FND_API.G_EXC_ERROR THEN
1599: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1600: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1601: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_values.g_exc_error',
1602: 'API JTY_TERR_DENORM_RULES_PVT.process_attr_values has failed with FND_API.G_EXC_ERROR exception');
1603: END IF;
1604:
1605: WHEN L_SCHEMA_NOTFOUND THEN
1606: RETCODE := 2;

Line 1726: RAISE FND_API.G_EXC_ERROR;

1722: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_terr_rank.update_relative_rank',
1723: 'update_relative_rank API has failed');
1724: END IF;
1725:
1726: RAISE FND_API.G_EXC_ERROR;
1727: END IF;
1728:
1729: update_absolute_rank (
1730: p_terr_id_tbl => l_terr_id_tbl2,

Line 1744: RAISE FND_API.G_EXC_ERROR;

1740: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_terr_rank.update_absolute_rank',
1741: 'update_absolute_rank API has failed');
1742: END IF;
1743:
1744: RAISE FND_API.G_EXC_ERROR;
1745: END IF;
1746:
1747: l_terr_id_tbl2.TRIM(l_rows_inserted2);
1748: l_relative_rank_tbl.TRIM(l_rows_inserted2);

Line 1781: RAISE FND_API.G_EXC_ERROR;

1777: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_terr_rank.update_denorm_table',
1778: 'update_denorm_table API has failed');
1779: END IF;
1780:
1781: RAISE FND_API.G_EXC_ERROR;
1782: END IF;
1783:
1784: l_terr_id_tbl1.TRIM(l_rows_inserted1);
1785: l_related_terr_id_tbl.TRIM(l_rows_inserted1);

Line 1973: RAISE FND_API.G_EXC_ERROR;

1969: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_terr_rank.update_relative_rank',
1970: 'update_relative_rank API has failed');
1971: END IF;
1972:
1973: RAISE FND_API.G_EXC_ERROR;
1974: END IF;
1975:
1976: /* update absolute rank */
1977: update_absolute_rank (

Line 1992: RAISE FND_API.G_EXC_ERROR;

1988: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_terr_rank.update_absolute_rank',
1989: 'update_absolute_rank API has failed');
1990: END IF;
1991:
1992: RAISE FND_API.G_EXC_ERROR;
1993: END IF;
1994:
1995: l_terr_id_tbl2.TRIM(l_rows_inserted2);
1996:

Line 2030: RAISE FND_API.G_EXC_ERROR;

2026: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_terr_rank.update_denorm_table',
2027: 'update_denorm_table API has failed');
2028: END IF;
2029:
2030: RAISE FND_API.G_EXC_ERROR;
2031: END IF;
2032:
2033: l_terr_id_tbl1.TRIM(l_rows_inserted1);
2034: l_related_terr_id_tbl.TRIM(l_rows_inserted1);

Line 2164: WHEN FND_API.G_EXC_ERROR THEN

2160: retcode := 0;
2161: errbuf := null;
2162:
2163: EXCEPTION
2164: WHEN FND_API.G_EXC_ERROR THEN
2165: RETCODE := 2;
2166: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2167: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2168: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_terr_rank.g_exc_error',

Line 2169: 'API JTY_TERR_DENORM_RULES_PVT.process_terr_rank has failed with FND_API.G_EXC_ERROR exception');

2165: RETCODE := 2;
2166: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2167: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2168: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_terr_rank.g_exc_error',
2169: 'API JTY_TERR_DENORM_RULES_PVT.process_terr_rank has failed with FND_API.G_EXC_ERROR exception');
2170: END IF;
2171:
2172: WHEN OTHERS THEN
2173: RETCODE := 2;

Line 2217: x_return_status := FND_API.G_RET_STS_SUCCESS;

2213: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.drop_dnmval_table_indexes.begin',
2214: 'Start of the procedure JTY_TERR_DENORM_RULES_PVT.drop_dnmval_table_indexes');
2215: END IF;
2216:
2217: x_return_status := FND_API.G_RET_STS_SUCCESS;
2218:
2219: IF(FND_INSTALLATION.GET_APP_INFO('JTF', l_status, l_industry, l_jtf_schema)) THEN
2220: NULL;
2221: END IF;

Line 2261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2257: END IF;
2258:
2259: EXCEPTION
2260: WHEN L_SCHEMA_NOTFOUND THEN
2261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2262: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2263: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2264: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.drop_dnmval_table_indexes.l_schema_notfound',
2265: 'Schema name corresponding to JTF application not found');

Line 2269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2265: 'Schema name corresponding to JTF application not found');
2266: END IF;
2267:
2268: WHEN OTHERS THEN
2269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2270: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2271: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2272: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.drop_dnmval_table_indexes.others',
2273: substr(SQLCODE || ' : ' || SQLERRM, 1, 4000));

Line 2320: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2316: p_table_name => l_table_name
2317: ,p_mode => p_mode
2318: ,x_return_status => x_return_status);
2319:
2320: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2321: retcode := 2;
2322: errbuf := 'drop_dnmval_table_indexes API has failed';
2323: -- debug message
2324: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2330: RAISE FND_API.G_EXC_ERROR;

2326: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank.drop_dnmval_table_indexes',
2327: 'drop_dnmval_table_indexes API has failed');
2328: END IF;
2329:
2330: RAISE FND_API.G_EXC_ERROR;
2331: END IF;
2332:
2333: DELETE jty_terr_values_idx_details dtl
2334: WHERE EXISTS (

Line 2354: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2350: p_table_name => l_table_name
2351: ,p_mode => p_mode
2352: ,x_return_status => x_return_status);
2353:
2354: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2355: retcode := 2;
2356: errbuf := 'drop_dnmval_table_indexes API has failed';
2357: -- debug message
2358: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2364: RAISE FND_API.G_EXC_ERROR;

2360: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank.drop_dnmval_table_indexes',
2361: 'drop_dnmval_table_indexes API has failed');
2362: END IF;
2363:
2364: RAISE FND_API.G_EXC_ERROR;
2365: END IF;
2366:
2367: DELETE jty_dea_values_idx_details dtl
2368: WHERE EXISTS (

Line 2411: RAISE FND_API.G_EXC_ERROR;

2407: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank.process_terr_rank',
2408: 'process_terr_rank API has failed');
2409: END IF;
2410:
2411: RAISE FND_API.G_EXC_ERROR;
2412: END IF;
2413:
2414: -- debug message
2415: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2438: RAISE FND_API.G_EXC_ERROR;

2434: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank.process_attr_values',
2435: 'process_attr_values API has failed');
2436: END IF;
2437:
2438: RAISE FND_API.G_EXC_ERROR;
2439: END IF;
2440:
2441: -- debug message
2442: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2459: WHEN FND_API.G_EXC_ERROR THEN

2455: retcode := 0;
2456: errbuf := null;
2457:
2458: EXCEPTION
2459: WHEN FND_API.G_EXC_ERROR THEN
2460: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2461: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2462: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank.g_exc_error',
2463: 'API JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank has failed with FND_API.G_EXC_ERROR exception');

Line 2463: 'API JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank has failed with FND_API.G_EXC_ERROR exception');

2459: WHEN FND_API.G_EXC_ERROR THEN
2460: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2461: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2462: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank.g_exc_error',
2463: 'API JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank has failed with FND_API.G_EXC_ERROR exception');
2464: END IF;
2465:
2466: WHEN OTHERS THEN
2467: RETCODE := 2;