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

Line 49: x_return_status := FND_API.G_RET_STS_SUCCESS;

45: 'jtf.plsql.JTY_TAE_CONTROL_PVT.delete_combinations.begin',
46: 'Start of the procedure JTY_TAE_CONTROL_PVT.delete_combinations');
47: END IF;
48:
49: x_return_status := FND_API.G_RET_STS_SUCCESS;
50:
51: IF (p_mode = 'TOTAL') THEN
52: BEGIN
53:

Line 79: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

75:
76: EXCEPTION
77: WHEN OTHERS THEN
78: x_msg_data := SQLCODE || ' : ' || SQLERRM;
79: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
80: END;
81: ELSIF (p_mode = 'DATE EFFECTIVE') THEN
82: BEGIN
83:

Line 110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

106: EXCEPTION
107:
108: WHEN OTHERS THEN
109: x_msg_data := SQLCODE || ' : ' || SQLERRM;
110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
111: END;
112: ELSIF (p_mode = 'INCREMENTAL') THEN
113: BEGIN
114:

Line 151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

147:
148: EXCEPTION
149: WHEN OTHERS THEN
150: x_msg_data := SQLCODE || ' : ' || SQLERRM;
151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
152: END;
153: END IF; /* end IF (p_mode = 'TOTAL') */
154:
155: -- debug message

Line 163: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

159: 'End of the procedure JTY_TAE_CONTROL_PVT.delete_combinations');
160: END IF;
161:
162: EXCEPTION
163: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
165: x_msg_count := 1;
166: RETCODE := 2;
167: ERRBUF := x_msg_data;

Line 164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

160: END IF;
161:
162: EXCEPTION
163: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
165: x_msg_count := 1;
166: RETCODE := 2;
167: ERRBUF := x_msg_data;
168: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

171: x_msg_data);
172: END IF;
173:
174: WHEN OTHERS THEN
175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
176: x_msg_data := SQLCODE || ' : ' || SQLERRM;
177: x_msg_count := 1;
178: RETCODE := 2;
179: ERRBUF := x_msg_data;

Line 231: x_return_status := FND_API.G_RET_STS_SUCCESS;

227: 'jtf.plsql.JTY_TAE_CONTROL_PVT.classify_territories.begin',
228: 'Start of the procedure JTY_TAE_CONTROL_PVT.classify_territories');
229: END IF;
230:
231: x_return_status := FND_API.G_RET_STS_SUCCESS;
232:
233: BEGIN
234: SELECT qual_type_usg_id
235: INTO l_qual_type_usg_id

Line 320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

316:
317: EXCEPTION
318: WHEN OTHERS THEN
319: x_msg_data := SQLCODE || ' : ' || SQLERRM;
320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
321: END;
322:
323: l_no_of_records := 0;
324:

Line 433: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

429:
430: EXCEPTION
431: WHEN OTHERS THEN
432: x_msg_data := SQLCODE || ' : ' || SQLERRM;
433: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
434: END;
435:
436: END IF; /* end IF l_exist_qual_detail_count = 0 */
437:

Line 862: RAISE FND_API.G_EXC_ERROR;

858:
859: EXCEPTION
860: WHEN NO_DATA_FOUND THEN
861: x_msg_data := 'Populating JTF_TAE_QUAL_PROD_FACTORS table : Error no_data_found.';
862: RAISE FND_API.G_EXC_ERROR;
863:
864: WHEN OTHERS THEN
865: x_msg_data := SQLCODE || ' : ' || SQLERRM;
866: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 866: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

862: RAISE FND_API.G_EXC_ERROR;
863:
864: WHEN OTHERS THEN
865: x_msg_data := SQLCODE || ' : ' || SQLERRM;
866: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
867: END;
868:
869: END LOOP; /* end loop FOR qual_name in quals_used(rel_set.qual_relation_product) */
870: END IF; /* end IF ((p_qual_prd_tbl(i) <> 1) AND (p_qual_prd_tbl(i) IS NOT NULL)) */

Line 889: x_return_status := FND_API.G_RET_STS_ERROR;

885: END IF;
886:
887: EXCEPTION
888: WHEN NO_DATA_FOUND THEN
889: x_return_status := FND_API.G_RET_STS_ERROR;
890: x_msg_count := 1;
891: RETCODE := 2;
892: ERRBUF := x_msg_data;
893: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 899: WHEN FND_API.G_EXC_ERROR THEN

895: 'jtf.plsql.JTY_TAE_CONTROL_PVT.classify_territories.no_data_found',
896: x_msg_data);
897: END IF;
898:
899: WHEN FND_API.G_EXC_ERROR THEN
900: x_return_status := FND_API.G_RET_STS_ERROR;
901: x_msg_count := 1;
902: RETCODE := 2;
903: ERRBUF := x_msg_data;

Line 900: x_return_status := FND_API.G_RET_STS_ERROR;

896: x_msg_data);
897: END IF;
898:
899: WHEN FND_API.G_EXC_ERROR THEN
900: x_return_status := FND_API.G_RET_STS_ERROR;
901: x_msg_count := 1;
902: RETCODE := 2;
903: ERRBUF := x_msg_data;
904: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 910: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

906: 'jtf.plsql.JTY_TAE_CONTROL_PVT.classify_territories.g_exc_error',
907: x_msg_data);
908: END IF;
909:
910: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
912: x_msg_count := 1;
913: RETCODE := 2;
914: ERRBUF := x_msg_data;

Line 911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

907: x_msg_data);
908: END IF;
909:
910: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
912: x_msg_count := 1;
913: RETCODE := 2;
914: ERRBUF := x_msg_data;
915: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 922: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

918: x_msg_data);
919: END IF;
920:
921: WHEN OTHERS THEN
922: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
923: x_msg_data := SQLCODE || ' : ' || SQLERRM;
924: x_msg_count := 1;
925: RETCODE := 2;
926: ERRBUF := x_msg_data;

Line 976: x_return_status := FND_API.G_RET_STS_SUCCESS;

972: 'jtf.plsql.JTY_TAE_CONTROL_PVT.classify_dea_territories.begin',
973: 'Start of the procedure JTY_TAE_CONTROL_PVT.classify_dea_territories');
974: END IF;
975:
976: x_return_status := FND_API.G_RET_STS_SUCCESS;
977:
978: BEGIN
979: SELECT qual_type_usg_id
980: INTO l_qual_type_usg_id

Line 1050: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1046:
1047: EXCEPTION
1048: WHEN OTHERS THEN
1049: x_msg_data := SQLCODE || ' : ' || SQLERRM;
1050: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1051: END;
1052:
1053: l_no_of_records := 0;
1054:

Line 1153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1149:
1150: EXCEPTION
1151: WHEN OTHERS THEN
1152: x_msg_data := SQLCODE || ' : ' || SQLERRM;
1153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1154: END;
1155:
1156: END IF; /* end IF l_exist_qual_detail_count = 0 */
1157:

Line 1580: RAISE FND_API.G_EXC_ERROR;

1576:
1577: EXCEPTION
1578: WHEN NO_DATA_FOUND THEN
1579: x_msg_data := 'Populating JTY_DEA_ATTR_PROD_FACTORS table : Error no_data_found.';
1580: RAISE FND_API.G_EXC_ERROR;
1581:
1582: WHEN OTHERS THEN
1583: x_msg_data := SQLCODE || ' : ' || SQLERRM;
1584: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1584: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1580: RAISE FND_API.G_EXC_ERROR;
1581:
1582: WHEN OTHERS THEN
1583: x_msg_data := SQLCODE || ' : ' || SQLERRM;
1584: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1585: END;
1586:
1587: END LOOP; /* end loop FOR qual_name in quals_used(rel_set.qual_relation_product) */
1588: END IF; /* end IF ((p_qual_prd_tbl(i) <> 1) AND (p_qual_prd_tbl(i) IS NOT NULL)) */

Line 1607: x_return_status := FND_API.G_RET_STS_ERROR;

1603: END IF;
1604:
1605: EXCEPTION
1606: WHEN NO_DATA_FOUND THEN
1607: x_return_status := FND_API.G_RET_STS_ERROR;
1608: x_msg_count := 1;
1609: RETCODE := 2;
1610: ERRBUF := x_msg_data;
1611: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1617: WHEN FND_API.G_EXC_ERROR THEN

1613: 'jtf.plsql.JTY_TAE_CONTROL_PVT.classify_dea_territories.no_data_found',
1614: x_msg_data);
1615: END IF;
1616:
1617: WHEN FND_API.G_EXC_ERROR THEN
1618: x_return_status := FND_API.G_RET_STS_ERROR;
1619: x_msg_count := 1;
1620: RETCODE := 2;
1621: ERRBUF := x_msg_data;

Line 1618: x_return_status := FND_API.G_RET_STS_ERROR;

1614: x_msg_data);
1615: END IF;
1616:
1617: WHEN FND_API.G_EXC_ERROR THEN
1618: x_return_status := FND_API.G_RET_STS_ERROR;
1619: x_msg_count := 1;
1620: RETCODE := 2;
1621: ERRBUF := x_msg_data;
1622: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1628: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1624: 'jtf.plsql.JTY_TAE_CONTROL_PVT.classify_dea_territories.g_exc_error',
1625: x_msg_data);
1626: END IF;
1627:
1628: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1630: x_msg_count := 1;
1631: RETCODE := 2;
1632: ERRBUF := x_msg_data;

Line 1629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1625: x_msg_data);
1626: END IF;
1627:
1628: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1630: x_msg_count := 1;
1631: RETCODE := 2;
1632: ERRBUF := x_msg_data;
1633: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1636: x_msg_data);
1637: END IF;
1638:
1639: WHEN OTHERS THEN
1640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1641: x_msg_data := SQLCODE || ' : ' || SQLERRM;
1642: x_msg_count := 1;
1643: RETCODE := 2;
1644: ERRBUF := x_msg_data;

Line 1696: x_return_status := FND_API.G_RET_STS_SUCCESS;

1692: 'jtf.plsql.JTY_TAE_CONTROL_PVT.reduce_deaval_idx_set.start',
1693: 'Start of the procedure JTY_TAE_CONTROL_PVT.reduce_deaval_idx_set');
1694: END IF;
1695:
1696: x_return_status := FND_API.G_RET_STS_SUCCESS;
1697: S_element_ord_subset_L_count := 0;
1698: S_subset_L := 'N';
1699:
1700: FOR cl_set_S in all_sets( p_source_id ) LOOP

Line 1758: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1754:
1755: EXCEPTION
1756:
1757: WHEN OTHERS THEN
1758: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1759: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1760: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1761: 'jtf.plsql.JTY_TAE_CONTROL_PVT.reduce_deaval_idx_set.other',
1762: substr(SQLCODE || ' : ' || SQLERRM, 1, 4000));

Line 1812: x_return_status := FND_API.G_RET_STS_SUCCESS;

1808: 'jtf.plsql.JTY_TAE_CONTROL_PVT.reduce_dnmval_idx_set.start',
1809: 'Start of the procedure JTY_TAE_CONTROL_PVT.reduce_dnmval_idx_set');
1810: END IF;
1811:
1812: x_return_status := FND_API.G_RET_STS_SUCCESS;
1813: S_element_ord_subset_L_count := 0;
1814: S_subset_L := 'N';
1815:
1816: /* mark the indexes as obsolete for qualifers and qualifier combinations */

Line 1883: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1879:
1880: EXCEPTION
1881:
1882: WHEN OTHERS THEN
1883: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1884: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1885: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1886: 'jtf.plsql.JTY_TAE_CONTROL_PVT.reduce_dnmval_idx_set.other',
1887: substr(SQLCODE || ' : ' || SQLERRM, 1, 4000));

Line 1960: x_return_status := FND_API.G_RET_STS_SUCCESS;

1956: 'jtf.plsql.JTY_TAE_CONTROL_PVT.Reduce_TX_OIN_Index_Set.start',
1957: 'Start of the procedure JTY_TAE_CONTROL_PVT.Reduce_TX_OIN_Index_Set');
1958: END IF;
1959:
1960: x_return_status := FND_API.G_RET_STS_SUCCESS;
1961: l_first_char_flag := 'N';
1962: S_element_ord_subset_L_count := 0;
1963: S_subset_L := 'N';
1964:

Line 2085: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2081:
2082: EXCEPTION
2083:
2084: WHEN OTHERS THEN
2085: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2086: x_msg_data := SQLCODE || ' : ' || SQLERRM;
2087: x_msg_count := 1;
2088: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2089: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

Line 2162: x_return_status := FND_API.G_RET_STS_SUCCESS;

2158: 'jtf.plsql.JTY_TAE_CONTROL_PVT.dea_Reduce_TX_OIN_Index_Set.start',
2159: 'Start of the procedure JTY_TAE_CONTROL_PVT.dea_Reduce_TX_OIN_Index_Set');
2160: END IF;
2161:
2162: x_return_status := FND_API.G_RET_STS_SUCCESS;
2163: l_first_char_flag := 'N';
2164: S_element_ord_subset_L_count := 0;
2165: S_subset_L := 'N';
2166:

Line 2286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2282: END IF;
2283:
2284: EXCEPTION
2285: WHEN OTHERS THEN
2286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2287: x_msg_data := SQLCODE || ' : ' || SQLERRM;
2288: x_msg_count := 1;
2289: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2290: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

Line 2325: x_return_status := FND_API.G_RET_STS_SUCCESS;

2321: 'jtf.plsql.JTY_TAE_CONTROL_PVT.decompose_terr_defns.begin',
2322: 'Start of the procedure JTY_TAE_CONTROL_PVT.decompose_terr_defns');
2323: END IF;
2324:
2325: x_return_status := FND_API.G_RET_STS_SUCCESS;
2326:
2327: -- ANALYSIS OF TERRITORY DEFINITION FOR DYN PACKAGE GENERATION
2328: IF (p_classify_terr_comb = 'Y') THEN
2329: NULL;

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

2335: -- Analyze Selectivity and Get ordinals
2336: IF (p_mode = 'DATE EFFECTIVE') THEN
2337: jty_tae_index_creation_pvt.dea_selectivity(p_trans_target, x_return_status);
2338:
2339: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2340: x_msg_data := 'API jty_tae_index_creation_pvt.dea_selectivity has failed';
2341: RAISE FND_API.G_EXC_ERROR;
2342: END IF;
2343: ELSE

Line 2341: RAISE FND_API.G_EXC_ERROR;

2337: jty_tae_index_creation_pvt.dea_selectivity(p_trans_target, x_return_status);
2338:
2339: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2340: x_msg_data := 'API jty_tae_index_creation_pvt.dea_selectivity has failed';
2341: RAISE FND_API.G_EXC_ERROR;
2342: END IF;
2343: ELSE
2344: jty_tae_index_creation_pvt.selectivity(p_trans_target, p_mode, null, x_return_status);
2345:

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

2342: END IF;
2343: ELSE
2344: jty_tae_index_creation_pvt.selectivity(p_trans_target, p_mode, null, x_return_status);
2345:
2346: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2347: x_msg_data := 'API jty_tae_index_creation_pvt.selectivity has failed';
2348: RAISE FND_API.G_EXC_ERROR;
2349: END IF;
2350: END IF; /* end IF (p_mode = 'DATE EFFECTIVE') */

Line 2348: RAISE FND_API.G_EXC_ERROR;

2344: jty_tae_index_creation_pvt.selectivity(p_trans_target, p_mode, null, x_return_status);
2345:
2346: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2347: x_msg_data := 'API jty_tae_index_creation_pvt.selectivity has failed';
2348: RAISE FND_API.G_EXC_ERROR;
2349: END IF;
2350: END IF; /* end IF (p_mode = 'DATE EFFECTIVE') */
2351:
2352: END IF; /* end IF (p_process_tx_oin_sel = 'Y') */

Line 2358: p_Init_Msg_List => FND_API.G_FALSE,

2354: IF (p_mode = 'DATE EFFECTIVE') THEN
2355: -- Reduce Sets
2356: dea_Reduce_TX_OIN_Index_Set
2357: ( p_Api_Version_Number => 1.0,
2358: p_Init_Msg_List => FND_API.G_FALSE,
2359: p_source_id => p_source_id,
2360: p_trans_id => p_trans_id,
2361: x_Return_Status => x_return_status,
2362: x_Msg_Count => x_msg_count,

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

2362: x_Msg_Count => x_msg_count,
2363: x_Msg_Data => x_msg_data
2364: );
2365:
2366: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2367: x_msg_data := 'CALL to JTY_TAE_CONTROL_PVT.dea_Reduce_TX_OIN_Index_Set API has failed.';
2368: RAISE FND_API.G_EXC_ERROR;
2369: END IF;
2370: ELSE

Line 2368: RAISE FND_API.G_EXC_ERROR;

2364: );
2365:
2366: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2367: x_msg_data := 'CALL to JTY_TAE_CONTROL_PVT.dea_Reduce_TX_OIN_Index_Set API has failed.';
2368: RAISE FND_API.G_EXC_ERROR;
2369: END IF;
2370: ELSE
2371: -- Reduce Sets
2372: Reduce_TX_OIN_Index_Set

Line 2374: p_Init_Msg_List => FND_API.G_FALSE,

2370: ELSE
2371: -- Reduce Sets
2372: Reduce_TX_OIN_Index_Set
2373: ( p_Api_Version_Number => 1.0,
2374: p_Init_Msg_List => FND_API.G_FALSE,
2375: p_source_id => p_source_id,
2376: p_trans_id => p_trans_id,
2377: x_Return_Status => x_return_status,
2378: x_Msg_Count => x_msg_count,

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

2378: x_Msg_Count => x_msg_count,
2379: x_Msg_Data => x_msg_data
2380: );
2381:
2382: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2383: x_msg_data := 'CALL to JTY_TAE_CONTROL_PVT.Reduce_TX_OIN_Index_Set API has failed.';
2384: RAISE FND_API.G_EXC_ERROR;
2385: END IF;
2386: END IF; /* end IF (p_mode = 'DATE EFFECTIVE') */

Line 2384: RAISE FND_API.G_EXC_ERROR;

2380: );
2381:
2382: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2383: x_msg_data := 'CALL to JTY_TAE_CONTROL_PVT.Reduce_TX_OIN_Index_Set API has failed.';
2384: RAISE FND_API.G_EXC_ERROR;
2385: END IF;
2386: END IF; /* end IF (p_mode = 'DATE EFFECTIVE') */
2387:
2388: -- debug message

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

2397: jty_tae_index_creation_pvt.drop_table_indexes(
2398: p_table_name => p_trans_target
2399: , x_return_status => x_return_status);
2400:
2401: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2402: x_msg_data := 'CALL to JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed.';
2403: RAISE FND_API.G_EXC_ERROR;
2404: END IF;
2405:

Line 2403: RAISE FND_API.G_EXC_ERROR;

2399: , x_return_status => x_return_status);
2400:
2401: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2402: x_msg_data := 'CALL to JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed.';
2403: RAISE FND_API.G_EXC_ERROR;
2404: END IF;
2405:
2406: -- Build Indexes
2407: IF (p_mode = 'DATE EFFECTIVE') THEN

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

2421: , x_return_status
2422: , 'TRANS');
2423: END IF;
2424:
2425: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2426: x_msg_data := 'CALL to JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed.';
2427: RAISE FND_API.G_EXC_ERROR;
2428: END IF;
2429:

Line 2427: RAISE FND_API.G_EXC_ERROR;

2423: END IF;
2424:
2425: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2426: x_msg_data := 'CALL to JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed.';
2427: RAISE FND_API.G_EXC_ERROR;
2428: END IF;
2429:
2430: -- debug message
2431: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2447: WHEN FND_API.G_EXC_ERROR THEN

2443: 'End of the procedure JTY_TAE_CONTROL_PVT.decompose_terr_defns');
2444: END IF;
2445:
2446: EXCEPTION
2447: WHEN FND_API.G_EXC_ERROR THEN
2448: x_return_status := FND_API.G_RET_STS_ERROR;
2449: x_msg_count := 1;
2450: RETCODE := 2;
2451: ERRBUF := x_msg_data;

Line 2448: x_return_status := FND_API.G_RET_STS_ERROR;

2444: END IF;
2445:
2446: EXCEPTION
2447: WHEN FND_API.G_EXC_ERROR THEN
2448: x_return_status := FND_API.G_RET_STS_ERROR;
2449: x_msg_count := 1;
2450: RETCODE := 2;
2451: ERRBUF := x_msg_data;
2452: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2459: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2455: x_msg_data);
2456: END IF;
2457:
2458: WHEN OTHERS THEN
2459: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2460: x_msg_data := SQLCODE || ' : ' || SQLERRM;
2461: x_msg_count := 1;
2462: RETCODE := 2;
2463: ERRBUF := x_msg_data;