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 JTY_TAE_CONTROL_PVT

Line 1: PACKAGE BODY JTY_TAE_CONTROL_PVT AS

1: PACKAGE BODY JTY_TAE_CONTROL_PVT AS
2: /* $Header: jtfyaecb.pls 120.4 2006/05/15 23:04:06 solin noship $ */
3: -- ---------------------------------------------------
4: -- Start of Comments
5: -- ---------------------------------------------------

Line 6: -- PACKAGE NAME: JTY_TAE_CONTROL_PVT

2: /* $Header: jtfyaecb.pls 120.4 2006/05/15 23:04:06 solin noship $ */
3: -- ---------------------------------------------------
4: -- Start of Comments
5: -- ---------------------------------------------------
6: -- PACKAGE NAME: JTY_TAE_CONTROL_PVT
7: -- ---------------------------------------------------
8: -- PURPOSE
9: --
10: -- Classify territories before mass assignment

Line 45: 'jtf.plsql.JTY_TAE_CONTROL_PVT.delete_combinations.begin',

41: BEGIN
42: -- debug message
43: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
44: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
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;

Line 46: 'Start of the procedure JTY_TAE_CONTROL_PVT.delete_combinations');

42: -- debug message
43: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
44: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
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:

Line 158: 'jtf.plsql.JTY_TAE_CONTROL_PVT.delete_combinations.end',

154:
155: -- debug message
156: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
157: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
158: 'jtf.plsql.JTY_TAE_CONTROL_PVT.delete_combinations.end',
159: 'End of the procedure JTY_TAE_CONTROL_PVT.delete_combinations');
160: END IF;
161:
162: EXCEPTION

Line 159: 'End of the procedure JTY_TAE_CONTROL_PVT.delete_combinations');

155: -- debug message
156: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
157: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
158: 'jtf.plsql.JTY_TAE_CONTROL_PVT.delete_combinations.end',
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

Line 182: 'jtf.plsql.JTY_TAE_CONTROL_PVT.delete_combinations.other',

178: RETCODE := 2;
179: ERRBUF := x_msg_data;
180: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
181: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
182: 'jtf.plsql.JTY_TAE_CONTROL_PVT.delete_combinations.other',
183: substr(x_msg_data, 1, 4000));
184: END IF;
185:
186: END delete_combinations;

Line 227: 'jtf.plsql.JTY_TAE_CONTROL_PVT.classify_territories.begin',

223: BEGIN
224: -- debug message
225: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
226: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
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;

Line 228: 'Start of the procedure JTY_TAE_CONTROL_PVT.classify_territories');

224: -- debug message
225: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
226: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
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:

Line 245: 'jtf.plsql.JTY_TAE_CONTROL_PVT.classify_territories.no_qual_type_usg_id',

241: x_msg_data := 'No row in table jtf_qual_type_usgs_all corresponding to source : ' || p_source_id || ' and transaction : ' ||
242: p_trans_id;
243: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
244: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
245: 'jtf.plsql.JTY_TAE_CONTROL_PVT.classify_territories.no_qual_type_usg_id',
246: x_msg_data);
247: END IF;
248: RAISE;
249: END;

Line 883: 'jtf.plsql.JTY_TAE_CONTROL_PVT.classify_territories.end',

879:
880: -- debug message
881: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
882: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
883: 'jtf.plsql.JTY_TAE_CONTROL_PVT.classify_territories.end',
884: 'End of the procedure JTY_TAE_CONTROL_PVT.classify_territories');
885: END IF;
886:
887: EXCEPTION

Line 884: 'End of the procedure JTY_TAE_CONTROL_PVT.classify_territories');

880: -- debug message
881: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
882: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
883: 'jtf.plsql.JTY_TAE_CONTROL_PVT.classify_territories.end',
884: 'End of the procedure JTY_TAE_CONTROL_PVT.classify_territories');
885: END IF;
886:
887: EXCEPTION
888: WHEN NO_DATA_FOUND THEN

Line 895: 'jtf.plsql.JTY_TAE_CONTROL_PVT.classify_territories.no_data_found',

891: RETCODE := 2;
892: ERRBUF := x_msg_data;
893: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
894: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
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

Line 906: 'jtf.plsql.JTY_TAE_CONTROL_PVT.classify_territories.g_exc_error',

902: RETCODE := 2;
903: ERRBUF := x_msg_data;
904: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
905: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
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

Line 929: 'jtf.plsql.JTY_TAE_CONTROL_PVT.classify_territories.other',

925: RETCODE := 2;
926: ERRBUF := x_msg_data;
927: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
928: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
929: 'jtf.plsql.JTY_TAE_CONTROL_PVT.classify_territories.other',
930: substr(x_msg_data, 1, 4000));
931: END IF;
932:
933: END Classify_Territories;

Line 972: 'jtf.plsql.JTY_TAE_CONTROL_PVT.classify_dea_territories.begin',

968: BEGIN
969: -- debug message
970: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
971: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
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;

Line 973: 'Start of the procedure JTY_TAE_CONTROL_PVT.classify_dea_territories');

969: -- debug message
970: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
971: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
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:

Line 990: 'jtf.plsql.JTY_TAE_CONTROL_PVT.classify_dea_territories.no_qual_type_usg_id',

986: x_msg_data := 'No row in table jtf_qual_type_usgs_all corresponding to source : ' || p_source_id || ' and transaction : ' ||
987: p_trans_id;
988: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
989: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
990: 'jtf.plsql.JTY_TAE_CONTROL_PVT.classify_dea_territories.no_qual_type_usg_id',
991: x_msg_data);
992: END IF;
993: RAISE;
994: END;

Line 1601: 'jtf.plsql.JTY_TAE_CONTROL_PVT.classify_dea_territories.end',

1597:
1598: -- debug message
1599: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1600: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1601: 'jtf.plsql.JTY_TAE_CONTROL_PVT.classify_dea_territories.end',
1602: 'End of the procedure JTY_TAE_CONTROL_PVT.classify_dea_territories');
1603: END IF;
1604:
1605: EXCEPTION

Line 1602: 'End of the procedure JTY_TAE_CONTROL_PVT.classify_dea_territories');

1598: -- debug message
1599: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1600: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1601: 'jtf.plsql.JTY_TAE_CONTROL_PVT.classify_dea_territories.end',
1602: 'End of the procedure JTY_TAE_CONTROL_PVT.classify_dea_territories');
1603: END IF;
1604:
1605: EXCEPTION
1606: WHEN NO_DATA_FOUND THEN

Line 1613: 'jtf.plsql.JTY_TAE_CONTROL_PVT.classify_dea_territories.no_data_found',

1609: RETCODE := 2;
1610: ERRBUF := x_msg_data;
1611: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1612: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
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

Line 1624: 'jtf.plsql.JTY_TAE_CONTROL_PVT.classify_dea_territories.g_exc_error',

1620: RETCODE := 2;
1621: ERRBUF := x_msg_data;
1622: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1623: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
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

Line 1647: 'jtf.plsql.JTY_TAE_CONTROL_PVT.classify_dea_territories.other',

1643: RETCODE := 2;
1644: ERRBUF := x_msg_data;
1645: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1646: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1647: 'jtf.plsql.JTY_TAE_CONTROL_PVT.classify_dea_territories.other',
1648: substr(x_msg_data, 1, 4000));
1649: END IF;
1650:
1651: END Classify_dea_Territories;

Line 1692: 'jtf.plsql.JTY_TAE_CONTROL_PVT.reduce_deaval_idx_set.start',

1688: BEGIN
1689: -- debug message
1690: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1691: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
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;

Line 1693: 'Start of the procedure JTY_TAE_CONTROL_PVT.reduce_deaval_idx_set');

1689: -- debug message
1690: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1691: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
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;

Line 1751: 'jtf.plsql.JTY_TAE_CONTROL_PVT.reduce_deaval_idx_set.end',

1747:
1748: -- debug message
1749: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1750: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1751: 'jtf.plsql.JTY_TAE_CONTROL_PVT.reduce_deaval_idx_set.end',
1752: 'End of the procedure JTY_TAE_CONTROL_PVT.reduce_deaval_idx_set');
1753: END IF;
1754:
1755: EXCEPTION

Line 1752: 'End of the procedure JTY_TAE_CONTROL_PVT.reduce_deaval_idx_set');

1748: -- debug message
1749: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1750: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1751: 'jtf.plsql.JTY_TAE_CONTROL_PVT.reduce_deaval_idx_set.end',
1752: 'End of the procedure JTY_TAE_CONTROL_PVT.reduce_deaval_idx_set');
1753: END IF;
1754:
1755: EXCEPTION
1756:

Line 1761: 'jtf.plsql.JTY_TAE_CONTROL_PVT.reduce_deaval_idx_set.other',

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));
1763: END IF;
1764:
1765: end reduce_deaval_idx_set;

Line 1808: 'jtf.plsql.JTY_TAE_CONTROL_PVT.reduce_dnmval_idx_set.start',

1804: BEGIN
1805: -- debug message
1806: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1807: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
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;

Line 1809: 'Start of the procedure JTY_TAE_CONTROL_PVT.reduce_dnmval_idx_set');

1805: -- debug message
1806: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1807: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
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;

Line 1876: 'jtf.plsql.JTY_TAE_CONTROL_PVT.reduce_dnmval_idx_set.end',

1872:
1873: -- debug message
1874: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1875: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1876: 'jtf.plsql.JTY_TAE_CONTROL_PVT.reduce_dnmval_idx_set.end',
1877: 'End of the procedure JTY_TAE_CONTROL_PVT.reduce_dnmval_idx_set');
1878: END IF;
1879:
1880: EXCEPTION

Line 1877: 'End of the procedure JTY_TAE_CONTROL_PVT.reduce_dnmval_idx_set');

1873: -- debug message
1874: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1875: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1876: 'jtf.plsql.JTY_TAE_CONTROL_PVT.reduce_dnmval_idx_set.end',
1877: 'End of the procedure JTY_TAE_CONTROL_PVT.reduce_dnmval_idx_set');
1878: END IF;
1879:
1880: EXCEPTION
1881:

Line 1886: 'jtf.plsql.JTY_TAE_CONTROL_PVT.reduce_dnmval_idx_set.other',

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));
1888: END IF;
1889:
1890: end reduce_dnmval_idx_set;

Line 1956: 'jtf.plsql.JTY_TAE_CONTROL_PVT.Reduce_TX_OIN_Index_Set.start',

1952: BEGIN
1953: -- debug message
1954: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1955: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
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;

Line 1957: 'Start of the procedure JTY_TAE_CONTROL_PVT.Reduce_TX_OIN_Index_Set');

1953: -- debug message
1954: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1955: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
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';

Line 2078: 'jtf.plsql.JTY_TAE_CONTROL_PVT.Reduce_TX_OIN_Index_Set.end',

2074:
2075: -- debug message
2076: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2077: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
2078: 'jtf.plsql.JTY_TAE_CONTROL_PVT.Reduce_TX_OIN_Index_Set.end',
2079: 'End of the procedure JTY_TAE_CONTROL_PVT.Reduce_TX_OIN_Index_Set');
2080: END IF;
2081:
2082: EXCEPTION

Line 2079: 'End of the procedure JTY_TAE_CONTROL_PVT.Reduce_TX_OIN_Index_Set');

2075: -- debug message
2076: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2077: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
2078: 'jtf.plsql.JTY_TAE_CONTROL_PVT.Reduce_TX_OIN_Index_Set.end',
2079: 'End of the procedure JTY_TAE_CONTROL_PVT.Reduce_TX_OIN_Index_Set');
2080: END IF;
2081:
2082: EXCEPTION
2083:

Line 2090: 'jtf.plsql.JTY_TAE_CONTROL_PVT.Reduce_TX_OIN_Index_Set.other',

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,
2090: 'jtf.plsql.JTY_TAE_CONTROL_PVT.Reduce_TX_OIN_Index_Set.other',
2091: substr(x_msg_data, 1, 4000));
2092: END IF;
2093:
2094: end Reduce_TX_OIN_Index_Set;

Line 2158: 'jtf.plsql.JTY_TAE_CONTROL_PVT.dea_Reduce_TX_OIN_Index_Set.start',

2154: BEGIN
2155: -- debug message
2156: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2157: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
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;

Line 2159: 'Start of the procedure JTY_TAE_CONTROL_PVT.dea_Reduce_TX_OIN_Index_Set');

2155: -- debug message
2156: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2157: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
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';

Line 2280: 'jtf.plsql.JTY_TAE_CONTROL_PVT.dea_Reduce_TX_OIN_Index_Set.end',

2276:
2277: -- debug message
2278: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2279: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
2280: 'jtf.plsql.JTY_TAE_CONTROL_PVT.dea_Reduce_TX_OIN_Index_Set.end',
2281: 'End of the procedure JTY_TAE_CONTROL_PVT.dea_Reduce_TX_OIN_Index_Set');
2282: END IF;
2283:
2284: EXCEPTION

Line 2281: 'End of the procedure JTY_TAE_CONTROL_PVT.dea_Reduce_TX_OIN_Index_Set');

2277: -- debug message
2278: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2279: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
2280: 'jtf.plsql.JTY_TAE_CONTROL_PVT.dea_Reduce_TX_OIN_Index_Set.end',
2281: 'End of the procedure JTY_TAE_CONTROL_PVT.dea_Reduce_TX_OIN_Index_Set');
2282: END IF;
2283:
2284: EXCEPTION
2285: WHEN OTHERS THEN

Line 2291: 'jtf.plsql.JTY_TAE_CONTROL_PVT.dea_Reduce_TX_OIN_Index_Set.other',

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,
2291: 'jtf.plsql.JTY_TAE_CONTROL_PVT.dea_Reduce_TX_OIN_Index_Set.other',
2292: substr(x_msg_data, 1, 4000));
2293: END IF;
2294:
2295: end dea_Reduce_TX_OIN_Index_Set;

Line 2321: 'jtf.plsql.JTY_TAE_CONTROL_PVT.decompose_terr_defns.begin',

2317: BEGIN
2318: -- debug message
2319: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2320: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
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;

Line 2322: 'Start of the procedure JTY_TAE_CONTROL_PVT.decompose_terr_defns');

2318: -- debug message
2319: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2320: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
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:

Line 2367: x_msg_data := 'CALL to JTY_TAE_CONTROL_PVT.dea_Reduce_TX_OIN_Index_Set API has failed.';

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
2371: -- Reduce Sets

Line 2383: x_msg_data := 'CALL to JTY_TAE_CONTROL_PVT.Reduce_TX_OIN_Index_Set API has failed.';

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') */
2387:

Line 2391: 'jtf.plsql.JTY_TAE_CONTROL_PVT.decompose_terr_defns.reduce_tx_oin_index_set',

2387:
2388: -- debug message
2389: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2390: FND_LOG.string(FND_LOG.LEVEL_EVENT,
2391: 'jtf.plsql.JTY_TAE_CONTROL_PVT.decompose_terr_defns.reduce_tx_oin_index_set',
2392: 'API JTY_TAE_CONTROL_PVT.reduce_tx_oin_index_set ended with success');
2393: END IF;
2394: END IF; /* end IF ((p_process_tx_oin_sel = 'Y') OR (p_process_tx_oin_sel = 'R')) */
2395:

Line 2392: 'API JTY_TAE_CONTROL_PVT.reduce_tx_oin_index_set ended with success');

2388: -- debug message
2389: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2390: FND_LOG.string(FND_LOG.LEVEL_EVENT,
2391: 'jtf.plsql.JTY_TAE_CONTROL_PVT.decompose_terr_defns.reduce_tx_oin_index_set',
2392: 'API JTY_TAE_CONTROL_PVT.reduce_tx_oin_index_set ended with success');
2393: END IF;
2394: END IF; /* end IF ((p_process_tx_oin_sel = 'Y') OR (p_process_tx_oin_sel = 'R')) */
2395:
2396: IF (p_generate_indexes = 'Y') THEN

Line 2433: 'jtf.plsql.JTY_TAE_CONTROL_PVT.decompose_terr_defns.create_index',

2429:
2430: -- debug message
2431: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2432: FND_LOG.string(FND_LOG.LEVEL_EVENT,
2433: 'jtf.plsql.JTY_TAE_CONTROL_PVT.decompose_terr_defns.create_index',
2434: 'API jty_tae_index_creation_pvt.create_index ended with success');
2435: END IF;
2436:
2437: END IF; /* end IF (p_generate_indexes = 'Y') */

Line 2442: 'jtf.plsql.JTY_TAE_CONTROL_PVT.decompose_terr_defns.end',

2438:
2439: -- debug message
2440: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2441: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
2442: 'jtf.plsql.JTY_TAE_CONTROL_PVT.decompose_terr_defns.end',
2443: 'End of the procedure JTY_TAE_CONTROL_PVT.decompose_terr_defns');
2444: END IF;
2445:
2446: EXCEPTION

Line 2443: 'End of the procedure JTY_TAE_CONTROL_PVT.decompose_terr_defns');

2439: -- debug message
2440: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2441: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
2442: 'jtf.plsql.JTY_TAE_CONTROL_PVT.decompose_terr_defns.end',
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

Line 2454: 'jtf.plsql.JTY_TAE_CONTROL_PVT.decompose_terr_defns.g_exc_error',

2450: RETCODE := 2;
2451: ERRBUF := x_msg_data;
2452: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2453: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2454: 'jtf.plsql.JTY_TAE_CONTROL_PVT.decompose_terr_defns.g_exc_error',
2455: x_msg_data);
2456: END IF;
2457:
2458: WHEN OTHERS THEN

Line 2466: 'jtf.plsql.JTY_TAE_CONTROL_PVT.decompose_terr_defns.other',

2462: RETCODE := 2;
2463: ERRBUF := x_msg_data;
2464: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2465: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2466: 'jtf.plsql.JTY_TAE_CONTROL_PVT.decompose_terr_defns.other',
2467: substr(x_msg_data, 1, 4000));
2468: END IF;
2469:
2470: END Decompose_Terr_Defns;

Line 2499: 'jtf.plsql.JTY_TAE_CONTROL_PVT.set_table_nologging.l_schema_notfound',

2495: EXCEPTION
2496: WHEN L_SCHEMA_NOTFOUND THEN
2497: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2498: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2499: 'jtf.plsql.JTY_TAE_CONTROL_PVT.set_table_nologging.l_schema_notfound',
2500: 'Schema name corresponding to JTF application not found');
2501: END IF;
2502:
2503: WHEN OTHERS THEN

Line 2506: 'jtf.plsql.JTY_TAE_CONTROL_PVT.set_table_nologging.others',

2502:
2503: WHEN OTHERS THEN
2504: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2505: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2506: 'jtf.plsql.JTY_TAE_CONTROL_PVT.set_table_nologging.others',
2507: substr(SQLCODE || ' : ' || SQLERRM, 1, 4000));
2508: END IF;
2509: END set_table_nologging;
2510:

Line 2511: END JTY_TAE_CONTROL_PVT;

2507: substr(SQLCODE || ' : ' || SQLERRM, 1, 4000));
2508: END IF;
2509: END set_table_nologging;
2510:
2511: END JTY_TAE_CONTROL_PVT;