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

55: jty_log(FND_LOG.LEVEL_PROCEDURE,
56: 'jtf.plsql.JTY_TAE_CONTROL_PVT.delete_combinations.begin',
57: 'Start of the procedure JTY_TAE_CONTROL_PVT.delete_combinations ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
58:
59: x_return_status := FND_API.G_RET_STS_SUCCESS;
60:
61: IF (p_mode = 'TOTAL') THEN
62: BEGIN
63:

Line 89: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

85:
86: EXCEPTION
87: WHEN OTHERS THEN
88: x_msg_data := SQLCODE || ' : ' || SQLERRM;
89: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
90: END;
91: ELSIF (p_mode = 'DATE EFFECTIVE') THEN
92: BEGIN
93:

Line 120: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

116: EXCEPTION
117:
118: WHEN OTHERS THEN
119: x_msg_data := SQLCODE || ' : ' || SQLERRM;
120: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
121: END;
122: ELSIF (p_mode = 'INCREMENTAL') THEN
123: BEGIN
124:

Line 161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

157:
158: EXCEPTION
159: WHEN OTHERS THEN
160: x_msg_data := SQLCODE || ' : ' || SQLERRM;
161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
162: END;
163: ELSIF (p_mode = 'DEA INCREMENTAL') THEN
164: BEGIN
165:

Line 202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

198:
199: EXCEPTION
200: WHEN OTHERS THEN
201: x_msg_data := SQLCODE || ' : ' || SQLERRM;
202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
203: END;
204: END IF; /* end IF (p_mode = 'TOTAL') */
205:
206: -- debug message

Line 212: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

208: 'jtf.plsql.JTY_TAE_CONTROL_PVT.delete_combinations.end',
209: 'End of the procedure JTY_TAE_CONTROL_PVT.delete_combinations ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
210:
211: EXCEPTION
212: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
214: x_msg_count := 1;
215: RETCODE := 2;
216: ERRBUF := x_msg_data;

Line 213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

209: 'End of the procedure JTY_TAE_CONTROL_PVT.delete_combinations ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
210:
211: EXCEPTION
212: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
214: x_msg_count := 1;
215: RETCODE := 2;
216: ERRBUF := x_msg_data;
217: jty_log(FND_LOG.LEVEL_EXCEPTION,

Line 222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

218: 'jtf.plsql.jtf_tae_cpntrol_pvt.delete_combinations.g_exc_unexpected_error',
219: x_msg_data);
220:
221: WHEN OTHERS THEN
222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
223: x_msg_data := SQLCODE || ' : ' || SQLERRM;
224: x_msg_count := 1;
225: RETCODE := 2;
226: ERRBUF := x_msg_data;

Line 274: x_return_status := FND_API.G_RET_STS_SUCCESS;

270: jty_log(FND_LOG.LEVEL_PROCEDURE,
271: 'jtf.plsql.JTY_TAE_CONTROL_PVT.classify_territories.begin',
272: 'Start of the procedure JTY_TAE_CONTROL_PVT.classify_territories ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
273:
274: x_return_status := FND_API.G_RET_STS_SUCCESS;
275:
276: BEGIN
277: SELECT qual_type_usg_id
278: INTO l_qual_type_usg_id

Line 361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

357:
358: EXCEPTION
359: WHEN OTHERS THEN
360: x_msg_data := SQLCODE || ' : ' || SQLERRM;
361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
362: END;
363:
364: l_no_of_records := 0;
365:

Line 474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

470:
471: EXCEPTION
472: WHEN OTHERS THEN
473: x_msg_data := SQLCODE || ' : ' || SQLERRM;
474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
475: END;
476:
477: END IF; /* end IF l_exist_qual_detail_count = 0 */
478:

Line 903: RAISE FND_API.G_EXC_ERROR;

899:
900: EXCEPTION
901: WHEN NO_DATA_FOUND THEN
902: x_msg_data := 'Populating JTF_TAE_QUAL_PROD_FACTORS table : Error no_data_found.';
903: RAISE FND_API.G_EXC_ERROR;
904:
905: WHEN OTHERS THEN
906: x_msg_data := SQLCODE || ' : ' || SQLERRM;
907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

903: RAISE FND_API.G_EXC_ERROR;
904:
905: WHEN OTHERS THEN
906: x_msg_data := SQLCODE || ' : ' || SQLERRM;
907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
908: END;
909:
910: END LOOP; /* end loop FOR qual_name in quals_used(rel_set.qual_relation_product) */
911: END IF; /* end IF ((p_qual_prd_tbl(i) <> 1) AND (p_qual_prd_tbl(i) IS NOT NULL)) */

Line 928: x_return_status := FND_API.G_RET_STS_ERROR;

924: 'End of the procedure JTY_TAE_CONTROL_PVT.classify_territories ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
925:
926: EXCEPTION
927: WHEN NO_DATA_FOUND THEN
928: x_return_status := FND_API.G_RET_STS_ERROR;
929: x_msg_count := 1;
930: RETCODE := 2;
931: ERRBUF := x_msg_data;
932: jty_log(FND_LOG.LEVEL_EXCEPTION,

Line 936: WHEN FND_API.G_EXC_ERROR THEN

932: jty_log(FND_LOG.LEVEL_EXCEPTION,
933: 'jtf.plsql.JTY_TAE_CONTROL_PVT.classify_territories.no_data_found',
934: x_msg_data);
935:
936: WHEN FND_API.G_EXC_ERROR THEN
937: x_return_status := FND_API.G_RET_STS_ERROR;
938: x_msg_count := 1;
939: RETCODE := 2;
940: ERRBUF := x_msg_data;

Line 937: x_return_status := FND_API.G_RET_STS_ERROR;

933: 'jtf.plsql.JTY_TAE_CONTROL_PVT.classify_territories.no_data_found',
934: x_msg_data);
935:
936: WHEN FND_API.G_EXC_ERROR THEN
937: x_return_status := FND_API.G_RET_STS_ERROR;
938: x_msg_count := 1;
939: RETCODE := 2;
940: ERRBUF := x_msg_data;
941: jty_log(FND_LOG.LEVEL_EXCEPTION,

Line 945: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

941: jty_log(FND_LOG.LEVEL_EXCEPTION,
942: 'jtf.plsql.JTY_TAE_CONTROL_PVT.classify_territories.g_exc_error',
943: x_msg_data);
944:
945: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
946: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
947: x_msg_count := 1;
948: RETCODE := 2;
949: ERRBUF := x_msg_data;

Line 946: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

942: 'jtf.plsql.JTY_TAE_CONTROL_PVT.classify_territories.g_exc_error',
943: x_msg_data);
944:
945: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
946: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
947: x_msg_count := 1;
948: RETCODE := 2;
949: ERRBUF := x_msg_data;
950: jty_log(FND_LOG.LEVEL_EXCEPTION,

Line 955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

951: 'jtf.plsql.jtf_tae_cpntrol_pvt.classify_territories.g_exc_unexpected_error',
952: x_msg_data);
953:
954: WHEN OTHERS THEN
955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
956: x_msg_data := SQLCODE || ' : ' || SQLERRM;
957: x_msg_count := 1;
958: RETCODE := 2;
959: ERRBUF := x_msg_data;

Line 1005: x_return_status := FND_API.G_RET_STS_SUCCESS;

1001: jty_log(FND_LOG.LEVEL_PROCEDURE,
1002: 'jtf.plsql.JTY_TAE_CONTROL_PVT.classify_dea_territories.begin',
1003: 'Start of the procedure JTY_TAE_CONTROL_PVT.classify_dea_territories ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1004:
1005: x_return_status := FND_API.G_RET_STS_SUCCESS;
1006:
1007: BEGIN
1008: SELECT qual_type_usg_id
1009: INTO l_qual_type_usg_id

Line 1078: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1074:
1075: EXCEPTION
1076: WHEN OTHERS THEN
1077: x_msg_data := SQLCODE || ' : ' || SQLERRM;
1078: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1079: END;
1080:
1081: l_no_of_records := 0;
1082:

Line 1183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1179:
1180: EXCEPTION
1181: WHEN OTHERS THEN
1182: x_msg_data := SQLCODE || ' : ' || SQLERRM;
1183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1184: END;
1185:
1186: END IF; /* end IF l_exist_qual_detail_count = 0 */
1187:

Line 1610: RAISE FND_API.G_EXC_ERROR;

1606:
1607: EXCEPTION
1608: WHEN NO_DATA_FOUND THEN
1609: x_msg_data := 'Populating JTY_DEA_ATTR_PROD_FACTORS table : Error no_data_found.';
1610: RAISE FND_API.G_EXC_ERROR;
1611:
1612: WHEN OTHERS THEN
1613: x_msg_data := SQLCODE || ' : ' || SQLERRM;
1614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1610: RAISE FND_API.G_EXC_ERROR;
1611:
1612: WHEN OTHERS THEN
1613: x_msg_data := SQLCODE || ' : ' || SQLERRM;
1614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1615: END;
1616:
1617: END LOOP; /* end loop FOR qual_name in quals_used(rel_set.qual_relation_product) */
1618: END IF; /* end IF ((p_qual_prd_tbl(i) <> 1) AND (p_qual_prd_tbl(i) IS NOT NULL)) */

Line 1635: x_return_status := FND_API.G_RET_STS_ERROR;

1631: 'End of the procedure JTY_TAE_CONTROL_PVT.classify_dea_territories ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1632:
1633: EXCEPTION
1634: WHEN NO_DATA_FOUND THEN
1635: x_return_status := FND_API.G_RET_STS_ERROR;
1636: x_msg_count := 1;
1637: RETCODE := 2;
1638: ERRBUF := x_msg_data;
1639: jty_log(FND_LOG.LEVEL_EXCEPTION,

Line 1643: WHEN FND_API.G_EXC_ERROR THEN

1639: jty_log(FND_LOG.LEVEL_EXCEPTION,
1640: 'jtf.plsql.JTY_TAE_CONTROL_PVT.classify_dea_territories.no_data_found',
1641: x_msg_data);
1642:
1643: WHEN FND_API.G_EXC_ERROR THEN
1644: x_return_status := FND_API.G_RET_STS_ERROR;
1645: x_msg_count := 1;
1646: RETCODE := 2;
1647: ERRBUF := x_msg_data;

Line 1644: x_return_status := FND_API.G_RET_STS_ERROR;

1640: 'jtf.plsql.JTY_TAE_CONTROL_PVT.classify_dea_territories.no_data_found',
1641: x_msg_data);
1642:
1643: WHEN FND_API.G_EXC_ERROR THEN
1644: x_return_status := FND_API.G_RET_STS_ERROR;
1645: x_msg_count := 1;
1646: RETCODE := 2;
1647: ERRBUF := x_msg_data;
1648: jty_log(FND_LOG.LEVEL_EXCEPTION,

Line 1652: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1648: jty_log(FND_LOG.LEVEL_EXCEPTION,
1649: 'jtf.plsql.JTY_TAE_CONTROL_PVT.classify_dea_territories.g_exc_error',
1650: x_msg_data);
1651:
1652: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1654: x_msg_count := 1;
1655: RETCODE := 2;
1656: ERRBUF := x_msg_data;

Line 1653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1649: 'jtf.plsql.JTY_TAE_CONTROL_PVT.classify_dea_territories.g_exc_error',
1650: x_msg_data);
1651:
1652: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1654: x_msg_count := 1;
1655: RETCODE := 2;
1656: ERRBUF := x_msg_data;
1657: jty_log(FND_LOG.LEVEL_EXCEPTION,

Line 1662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1658: 'jtf.plsql.jtf_tae_cpntrol_pvt.classify_dea_territories.g_exc_unexpected_error',
1659: x_msg_data);
1660:
1661: WHEN OTHERS THEN
1662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1663: x_msg_data := SQLCODE || ' : ' || SQLERRM;
1664: x_msg_count := 1;
1665: RETCODE := 2;
1666: ERRBUF := x_msg_data;

Line 1715: x_return_status := FND_API.G_RET_STS_SUCCESS;

1711: jty_log(FND_LOG.LEVEL_PROCEDURE,
1712: 'jtf.plsql.JTY_TAE_CONTROL_PVT.reduce_deaval_idx_set.start',
1713: 'Start of the procedure JTY_TAE_CONTROL_PVT.reduce_deaval_idx_set ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1714:
1715: x_return_status := FND_API.G_RET_STS_SUCCESS;
1716: S_element_ord_subset_L_count := 0;
1717: S_subset_L := 'N';
1718:
1719: /* mark the indexes as obsolete for qualifers and qualifier combinations */

Line 1784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1780:
1781: EXCEPTION
1782:
1783: WHEN OTHERS THEN
1784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1785: jty_log(FND_LOG.LEVEL_EXCEPTION,
1786: 'jtf.plsql.JTY_TAE_CONTROL_PVT.reduce_deaval_idx_set.other',
1787: substr(SQLCODE || ' : ' || SQLERRM, 1, 4000));
1788:

Line 1834: x_return_status := FND_API.G_RET_STS_SUCCESS;

1830: jty_log(FND_LOG.LEVEL_PROCEDURE,
1831: 'jtf.plsql.JTY_TAE_CONTROL_PVT.reduce_dnmval_idx_set.start',
1832: 'Start of the procedure JTY_TAE_CONTROL_PVT.reduce_dnmval_idx_set ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1833:
1834: x_return_status := FND_API.G_RET_STS_SUCCESS;
1835: S_element_ord_subset_L_count := 0;
1836: S_subset_L := 'N';
1837:
1838: /* mark the indexes as obsolete for qualifers and qualifier combinations */

Line 1903: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1899:
1900: EXCEPTION
1901:
1902: WHEN OTHERS THEN
1903: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1904: jty_log(FND_LOG.LEVEL_EXCEPTION,
1905: 'jtf.plsql.JTY_TAE_CONTROL_PVT.reduce_dnmval_idx_set.other',
1906: substr(SQLCODE || ' : ' || SQLERRM, 1, 4000));
1907:

Line 1976: x_return_status := FND_API.G_RET_STS_SUCCESS;

1972: jty_log(FND_LOG.LEVEL_PROCEDURE,
1973: 'jtf.plsql.JTY_TAE_CONTROL_PVT.Reduce_TX_OIN_Index_Set.start',
1974: 'Start of the procedure JTY_TAE_CONTROL_PVT.Reduce_TX_OIN_Index_Set ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1975:
1976: x_return_status := FND_API.G_RET_STS_SUCCESS;
1977: l_first_char_flag := 'N';
1978: S_element_ord_subset_L_count := 0;
1979: S_subset_L := 'N';
1980:

Line 2099: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2095:
2096: EXCEPTION
2097:
2098: WHEN OTHERS THEN
2099: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2100: x_msg_data := SQLCODE || ' : ' || SQLERRM;
2101: x_msg_count := 1;
2102: jty_log(FND_LOG.LEVEL_EXCEPTION,
2103: 'jtf.plsql.JTY_TAE_CONTROL_PVT.Reduce_TX_OIN_Index_Set.other',

Line 2172: x_return_status := FND_API.G_RET_STS_SUCCESS;

2168: jty_log(FND_LOG.LEVEL_PROCEDURE,
2169: 'jtf.plsql.JTY_TAE_CONTROL_PVT.dea_Reduce_TX_OIN_Index_Set.start',
2170: 'Start of the procedure JTY_TAE_CONTROL_PVT.dea_Reduce_TX_OIN_Index_Set ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
2171:
2172: x_return_status := FND_API.G_RET_STS_SUCCESS;
2173: l_first_char_flag := 'N';
2174: S_element_ord_subset_L_count := 0;
2175: S_subset_L := 'N';
2176:

Line 2294: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2290: 'End of the procedure JTY_TAE_CONTROL_PVT.dea_Reduce_TX_OIN_Index_Set ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
2291:
2292: EXCEPTION
2293: WHEN OTHERS THEN
2294: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2295: x_msg_data := SQLCODE || ' : ' || SQLERRM;
2296: x_msg_count := 1;
2297: jty_log(FND_LOG.LEVEL_EXCEPTION,
2298: 'jtf.plsql.JTY_TAE_CONTROL_PVT.dea_Reduce_TX_OIN_Index_Set.other',

Line 2329: x_return_status := FND_API.G_RET_STS_SUCCESS;

2325: jty_log(FND_LOG.LEVEL_PROCEDURE,
2326: 'jtf.plsql.JTY_TAE_CONTROL_PVT.decompose_terr_defns.begin',
2327: 'Start of the procedure JTY_TAE_CONTROL_PVT.decompose_terr_defns ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
2328:
2329: x_return_status := FND_API.G_RET_STS_SUCCESS;
2330:
2331: -- ANALYSIS OF TERRITORY DEFINITION FOR DYN PACKAGE GENERATION
2332: IF (p_classify_terr_comb = 'Y') THEN
2333: NULL;

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

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

Line 2345: RAISE FND_API.G_EXC_ERROR;

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

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

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

Line 2352: RAISE FND_API.G_EXC_ERROR;

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

Line 2362: p_Init_Msg_List => FND_API.G_FALSE,

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

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

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

Line 2372: RAISE FND_API.G_EXC_ERROR;

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

Line 2378: p_Init_Msg_List => FND_API.G_FALSE,

2374: ELSE
2375: -- Reduce Sets
2376: Reduce_TX_OIN_Index_Set
2377: ( p_Api_Version_Number => 1.0,
2378: p_Init_Msg_List => FND_API.G_FALSE,
2379: p_source_id => p_source_id,
2380: p_trans_id => p_trans_id,
2381: x_Return_Status => x_return_status,
2382: x_Msg_Count => x_msg_count,

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

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

Line 2388: RAISE FND_API.G_EXC_ERROR;

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

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

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

Line 2405: RAISE FND_API.G_EXC_ERROR;

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

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

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

Line 2429: RAISE FND_API.G_EXC_ERROR;

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

Line 2444: WHEN FND_API.G_EXC_ERROR THEN

2440: 'jtf.plsql.JTY_TAE_CONTROL_PVT.decompose_terr_defns.end',
2441: 'End of the procedure JTY_TAE_CONTROL_PVT.decompose_terr_defns ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
2442:
2443: EXCEPTION
2444: WHEN FND_API.G_EXC_ERROR THEN
2445: x_return_status := FND_API.G_RET_STS_ERROR;
2446: x_msg_count := 1;
2447: RETCODE := 2;
2448: ERRBUF := x_msg_data;

Line 2445: x_return_status := FND_API.G_RET_STS_ERROR;

2441: 'End of the procedure JTY_TAE_CONTROL_PVT.decompose_terr_defns ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
2442:
2443: EXCEPTION
2444: WHEN FND_API.G_EXC_ERROR THEN
2445: x_return_status := FND_API.G_RET_STS_ERROR;
2446: x_msg_count := 1;
2447: RETCODE := 2;
2448: ERRBUF := x_msg_data;
2449: jty_log(FND_LOG.LEVEL_EXCEPTION,

Line 2454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2450: 'jtf.plsql.JTY_TAE_CONTROL_PVT.decompose_terr_defns.g_exc_error',
2451: x_msg_data);
2452:
2453: WHEN OTHERS THEN
2454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2455: x_msg_data := SQLCODE || ' : ' || SQLERRM;
2456: x_msg_count := 1;
2457: RETCODE := 2;
2458: ERRBUF := x_msg_data;