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 129: x_return_status := FND_API.G_RET_STS_SUCCESS;

125: jty_log(FND_LOG.LEVEL_PROCEDURE,
126: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.begin',
127: 'Start of the procedure jty_terr_denorm_rules_pvt.create_dnmval_index ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
128:
129: x_return_status := FND_API.G_RET_STS_SUCCESS;
130:
131: /* In incremental mode mark all the qualifier combination present */
132: /* in jtf_tae_qual_products as being used by active territories */
133: IF (p_mode = 'INCREMENTAL') THEN

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

155: p_mode => p_mode,
156: p_source_id => p_source_id,
157: x_return_status => x_return_status);
158:
159: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
160: jty_log(FND_LOG.LEVEL_EXCEPTION,
161: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.selectivity',
162: 'API jty_tae_index_creation_pvt.SELECTIVITY has failed');
163: RAISE FND_API.G_EXC_ERROR;

Line 163: RAISE FND_API.G_EXC_ERROR;

159: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
160: jty_log(FND_LOG.LEVEL_EXCEPTION,
161: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.selectivity',
162: 'API jty_tae_index_creation_pvt.SELECTIVITY has failed');
163: RAISE FND_API.G_EXC_ERROR;
164: END IF;
165:
166: /* Determine the indexes that need to be created */
167: IF ((p_mode = 'TOTAL') OR (p_mode = 'INCREMENTAL')) THEN

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

175: p_mode => p_mode,
176: x_Return_Status => x_return_status );
177: END IF;
178:
179: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
180: jty_log(FND_LOG.LEVEL_EXCEPTION,
181: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.reduce_dnmval_idx_set',
182: 'API JTY_TAE_CONTROL_PVT.reduce_dnmval_idx_set has failed');
183: RAISE FND_API.G_EXC_ERROR;

Line 183: RAISE FND_API.G_EXC_ERROR;

179: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
180: jty_log(FND_LOG.LEVEL_EXCEPTION,
181: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.reduce_dnmval_idx_set',
182: 'API JTY_TAE_CONTROL_PVT.reduce_dnmval_idx_set has failed');
183: RAISE FND_API.G_EXC_ERROR;
184: END IF;
185:
186: /* get default Degree of Parallelism */
187: SELECT MIN(TO_NUMBER(v.value))

Line 385: x_return_status := FND_API.G_RET_STS_ERROR ;

381: 'End of the procedure jty_terr_denorm_rules_pvt.create_dnmval_index ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
382:
383: EXCEPTION
384: WHEN NO_DATA_FOUND THEN
385: x_return_status := FND_API.G_RET_STS_ERROR ;
386: jty_log(FND_LOG.LEVEL_EXCEPTION,
387: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.no_data_found',
388: 'API jty_terr_denorm_rules_pvt.create_dnmval_index has failed with no_data_found');
389:

Line 390: WHEN FND_API.G_EXC_ERROR THEN

386: jty_log(FND_LOG.LEVEL_EXCEPTION,
387: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.no_data_found',
388: 'API jty_terr_denorm_rules_pvt.create_dnmval_index has failed with no_data_found');
389:
390: WHEN FND_API.G_EXC_ERROR THEN
391: x_return_status := FND_API.G_RET_STS_ERROR ;
392: jty_log(FND_LOG.LEVEL_EXCEPTION,
393: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.g_exc_error',
394: 'jty_terr_denorm_rules_pvt.create_dnmval_index has failed with G_EXC_ERROR exception');

Line 391: x_return_status := FND_API.G_RET_STS_ERROR ;

387: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.no_data_found',
388: 'API jty_terr_denorm_rules_pvt.create_dnmval_index has failed with no_data_found');
389:
390: WHEN FND_API.G_EXC_ERROR THEN
391: x_return_status := FND_API.G_RET_STS_ERROR ;
392: jty_log(FND_LOG.LEVEL_EXCEPTION,
393: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.g_exc_error',
394: 'jty_terr_denorm_rules_pvt.create_dnmval_index has failed with G_EXC_ERROR exception');
395:

Line 397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

393: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.g_exc_error',
394: 'jty_terr_denorm_rules_pvt.create_dnmval_index has failed with G_EXC_ERROR exception');
395:
396: WHEN OTHERS THEN
397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
398: jty_log(FND_LOG.LEVEL_EXCEPTION,
399: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.others',
400: substr(SQLCODE || ' : ' || SQLERRM, 1, 4000));
401:

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

1665: , p_percent => 20
1666: , x_return_status => x_return_status );
1667: END IF;
1668:
1669: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1670: retcode := 2;
1671: errbuf := 'JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX has failed for table ' || l_table_name;
1672: jty_log(FND_LOG.LEVEL_EXCEPTION,
1673: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_values.analyze_table_index',

Line 1676: RAISE FND_API.G_EXC_ERROR;

1672: jty_log(FND_LOG.LEVEL_EXCEPTION,
1673: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_values.analyze_table_index',
1674: 'ANALYZE_TABLE_INDEX API has failed');
1675:
1676: RAISE FND_API.G_EXC_ERROR;
1677: END IF;
1678:
1679: IF (l_qtype_terr_id_tbl.COUNT > 0) THEN
1680: /* disable the trigger before update */

Line 1736: WHEN FND_API.G_EXC_ERROR THEN

1732: retcode := 0;
1733: errbuf := null;
1734:
1735: EXCEPTION
1736: WHEN FND_API.G_EXC_ERROR THEN
1737: jty_log(FND_LOG.LEVEL_EXCEPTION,
1738: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_values.g_exc_error',
1739: 'API JTY_TERR_DENORM_RULES_PVT.process_attr_values has failed with FND_API.G_EXC_ERROR exception');
1740:

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

1735: EXCEPTION
1736: WHEN FND_API.G_EXC_ERROR THEN
1737: jty_log(FND_LOG.LEVEL_EXCEPTION,
1738: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_values.g_exc_error',
1739: 'API JTY_TERR_DENORM_RULES_PVT.process_attr_values has failed with FND_API.G_EXC_ERROR exception');
1740:
1741: WHEN L_SCHEMA_NOTFOUND THEN
1742: RETCODE := 2;
1743: ERRBUF := 'JTY_TERR_DENORM_RULES_PVT.process_attr_values : SCHEMA NAME NOT FOUND CORRESPONDING TO JTF APPLICATION. ';

Line 1860: RAISE FND_API.G_EXC_ERROR;

1856: jty_log(FND_LOG.LEVEL_EXCEPTION,
1857: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_terr_rank.update_relative_rank',
1858: 'update_relative_rank API has failed');
1859:
1860: RAISE FND_API.G_EXC_ERROR;
1861: END IF;
1862:
1863: update_absolute_rank (
1864: p_terr_id_tbl => l_terr_id_tbl2,

Line 1876: RAISE FND_API.G_EXC_ERROR;

1872: jty_log(FND_LOG.LEVEL_EXCEPTION,
1873: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_terr_rank.update_absolute_rank',
1874: 'update_absolute_rank API has failed');
1875:
1876: RAISE FND_API.G_EXC_ERROR;
1877: END IF;
1878:
1879: l_terr_id_tbl2.TRIM(l_rows_inserted2);
1880: l_relative_rank_tbl.TRIM(l_rows_inserted2);

Line 1911: RAISE FND_API.G_EXC_ERROR;

1907: jty_log(FND_LOG.LEVEL_EXCEPTION,
1908: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_terr_rank.update_denorm_table',
1909: 'update_denorm_table API has failed');
1910:
1911: RAISE FND_API.G_EXC_ERROR;
1912: END IF;
1913:
1914: l_terr_id_tbl1.TRIM(l_rows_inserted1);
1915: l_related_terr_id_tbl.TRIM(l_rows_inserted1);

Line 2101: RAISE FND_API.G_EXC_ERROR;

2097: jty_log(FND_LOG.LEVEL_EXCEPTION,
2098: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_terr_rank.update_relative_rank',
2099: 'update_relative_rank API has failed');
2100:
2101: RAISE FND_API.G_EXC_ERROR;
2102: END IF;
2103:
2104: /* update absolute rank */
2105: update_absolute_rank (

Line 2118: RAISE FND_API.G_EXC_ERROR;

2114: jty_log(FND_LOG.LEVEL_EXCEPTION,
2115: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_terr_rank.update_absolute_rank',
2116: 'update_absolute_rank API has failed');
2117:
2118: RAISE FND_API.G_EXC_ERROR;
2119: END IF;
2120:
2121: l_terr_id_tbl2.TRIM(l_rows_inserted2);
2122:

Line 2154: RAISE FND_API.G_EXC_ERROR;

2150: jty_log(FND_LOG.LEVEL_EXCEPTION,
2151: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_terr_rank.update_denorm_table',
2152: 'update_denorm_table API has failed');
2153:
2154: RAISE FND_API.G_EXC_ERROR;
2155: END IF;
2156:
2157: l_terr_id_tbl1.TRIM(l_rows_inserted1);
2158: l_related_terr_id_tbl.TRIM(l_rows_inserted1);

Line 2287: WHEN FND_API.G_EXC_ERROR THEN

2283: retcode := 0;
2284: errbuf := null;
2285:
2286: EXCEPTION
2287: WHEN FND_API.G_EXC_ERROR THEN
2288: RETCODE := 2;
2289: jty_log(FND_LOG.LEVEL_EXCEPTION,
2290: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_terr_rank.g_exc_error',
2291: 'API JTY_TERR_DENORM_RULES_PVT.process_terr_rank has failed with FND_API.G_EXC_ERROR exception');

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

2287: WHEN FND_API.G_EXC_ERROR THEN
2288: RETCODE := 2;
2289: jty_log(FND_LOG.LEVEL_EXCEPTION,
2290: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_terr_rank.g_exc_error',
2291: 'API JTY_TERR_DENORM_RULES_PVT.process_terr_rank has failed with FND_API.G_EXC_ERROR exception');
2292:
2293: WHEN OTHERS THEN
2294: RETCODE := 2;
2295: ERRBUF := SQLCODE || ' : ' || SQLERRM;

Line 2334: x_return_status := FND_API.G_RET_STS_SUCCESS;

2330: jty_log(FND_LOG.LEVEL_PROCEDURE,
2331: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.drop_dnmval_table_indexes.begin',
2332: 'Start of the procedure JTY_TERR_DENORM_RULES_PVT.drop_dnmval_table_indexes ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
2333:
2334: x_return_status := FND_API.G_RET_STS_SUCCESS;
2335:
2336: IF(FND_INSTALLATION.GET_APP_INFO('JTF', l_status, l_industry, l_jtf_schema)) THEN
2337: NULL;
2338: END IF;

Line 2376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2372: 'End of the procedure JTY_TERR_DENORM_RULES_PVT.drop_dnmval_table_indexes ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
2373:
2374: EXCEPTION
2375: WHEN L_SCHEMA_NOTFOUND THEN
2376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2377: jty_log(FND_LOG.LEVEL_EXCEPTION,
2378: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.drop_dnmval_table_indexes.l_schema_notfound',
2379: 'Schema name corresponding to JTF application not found');
2380:

Line 2382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2378: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.drop_dnmval_table_indexes.l_schema_notfound',
2379: 'Schema name corresponding to JTF application not found');
2380:
2381: WHEN OTHERS THEN
2382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2383: jty_log(FND_LOG.LEVEL_EXCEPTION,
2384: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.drop_dnmval_table_indexes.others',
2385: substr(SQLCODE || ' : ' || SQLERRM, 1, 4000));
2386:

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

2447: p_table_name => l_table_name
2448: ,p_mode => p_mode
2449: ,x_return_status => x_return_status);
2450:
2451: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2452: retcode := 2;
2453: errbuf := 'drop_dnmval_table_indexes API has failed';
2454: -- debug message
2455: jty_log(FND_LOG.LEVEL_EXCEPTION,

Line 2459: RAISE FND_API.G_EXC_ERROR;

2455: jty_log(FND_LOG.LEVEL_EXCEPTION,
2456: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank.drop_dnmval_table_indexes',
2457: 'drop_dnmval_table_indexes API has failed');
2458:
2459: RAISE FND_API.G_EXC_ERROR;
2460: END IF;
2461:
2462: DELETE jty_terr_values_idx_details dtl
2463: WHERE EXISTS (

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

2479: p_table_name => l_table_name
2480: ,p_mode => p_mode
2481: ,x_return_status => x_return_status);
2482:
2483: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2484: retcode := 2;
2485: errbuf := 'drop_dnmval_table_indexes API has failed';
2486: -- debug message
2487: jty_log(FND_LOG.LEVEL_EXCEPTION,

Line 2491: RAISE FND_API.G_EXC_ERROR;

2487: jty_log(FND_LOG.LEVEL_EXCEPTION,
2488: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank.drop_dnmval_table_indexes',
2489: 'drop_dnmval_table_indexes API has failed');
2490:
2491: RAISE FND_API.G_EXC_ERROR;
2492: END IF;
2493:
2494: DELETE jty_dea_values_idx_details dtl
2495: WHERE EXISTS (

Line 2565: RAISE FND_API.G_EXC_ERROR;

2561: jty_log(FND_LOG.LEVEL_EXCEPTION,
2562: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank.process_terr_rank',
2563: 'process_terr_rank API has failed');
2564:
2565: RAISE FND_API.G_EXC_ERROR;
2566: END IF;
2567:
2568: -- debug message
2569: jty_log(FND_LOG.LEVEL_EVENT,

Line 2588: RAISE FND_API.G_EXC_ERROR;

2584: jty_log(FND_LOG.LEVEL_EXCEPTION,
2585: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank.process_attr_values',
2586: 'process_attr_values API has failed');
2587:
2588: RAISE FND_API.G_EXC_ERROR;
2589: END IF;
2590:
2591: -- debug message
2592: jty_log(FND_LOG.LEVEL_EVENT,

Line 2605: WHEN FND_API.G_EXC_ERROR THEN

2601: retcode := 0;
2602: errbuf := null;
2603:
2604: EXCEPTION
2605: WHEN FND_API.G_EXC_ERROR THEN
2606: jty_log(FND_LOG.LEVEL_EXCEPTION,
2607: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank.g_exc_error',
2608: 'API JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank has failed with FND_API.G_EXC_ERROR exception');
2609:

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

2604: EXCEPTION
2605: WHEN FND_API.G_EXC_ERROR THEN
2606: jty_log(FND_LOG.LEVEL_EXCEPTION,
2607: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank.g_exc_error',
2608: 'API JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank has failed with FND_API.G_EXC_ERROR exception');
2609:
2610: WHEN OTHERS THEN
2611: RETCODE := 2;
2612: ERRBUF := SQLCODE || ' : ' || SQLERRM;