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.9 2011/04/26 08:46:17 sseshaiy ship $ */
3: -- ---------------------------------------------------
4: -- Start of Comments
5: -- ---------------------------------------------------

Line 6: -- PACKAGE NAME: JTY_TAE_CONTROL_PVT

2: /* $Header: jtfyaecb.pls 120.9 2011/04/26 08:46:17 sseshaiy ship $ */
3: -- ---------------------------------------------------
4: -- Start of Comments
5: -- ---------------------------------------------------
6: -- PACKAGE NAME: JTY_TAE_CONTROL_PVT
7: -- ---------------------------------------------------
8: -- PURPOSE
9: --
10: -- Classify territories before mass assignment

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

52: l_rel_prd_tbl l_rel_prd_tbl_type;
53: BEGIN
54: -- debug message
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:

Line 57: 'Start of the procedure JTY_TAE_CONTROL_PVT.delete_combinations ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

53: BEGIN
54: -- debug message
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

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

204: END IF; /* end IF (p_mode = 'TOTAL') */
205:
206: -- debug message
207: jty_log(FND_LOG.LEVEL_PROCEDURE,
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

Line 209: 'End of the procedure JTY_TAE_CONTROL_PVT.delete_combinations ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

205:
206: -- debug message
207: jty_log(FND_LOG.LEVEL_PROCEDURE,
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;

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

224: x_msg_count := 1;
225: RETCODE := 2;
226: ERRBUF := x_msg_data;
227: jty_log(FND_LOG.LEVEL_EXCEPTION,
228: 'jtf.plsql.JTY_TAE_CONTROL_PVT.delete_combinations.other',
229: substr(x_msg_data, 1, 4000));
230:
231: END delete_combinations;
232:

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

267:
268: BEGIN
269: -- debug message
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:

Line 272: 'Start of the procedure JTY_TAE_CONTROL_PVT.classify_territories ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

268: BEGIN
269: -- debug message
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

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

283: WHEN NO_DATA_FOUND THEN
284: x_msg_data := 'No row in table jtf_qual_type_usgs_all corresponding to source : ' || p_source_id || ' and transaction : ' ||
285: p_trans_id;
286: jty_log(FND_LOG.LEVEL_EXCEPTION,
287: 'jtf.plsql.JTY_TAE_CONTROL_PVT.classify_territories.no_qual_type_usg_id',
288: x_msg_data);
289: RAISE;
290: END;
291:

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

919: where TAE_COL_MAP is null;
920:
921: -- debug message
922: jty_log(FND_LOG.LEVEL_PROCEDURE,
923: 'jtf.plsql.JTY_TAE_CONTROL_PVT.classify_territories.end',
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

Line 924: 'End of the procedure JTY_TAE_CONTROL_PVT.classify_territories ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

920:
921: -- debug message
922: jty_log(FND_LOG.LEVEL_PROCEDURE,
923: 'jtf.plsql.JTY_TAE_CONTROL_PVT.classify_territories.end',
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;

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

929: x_msg_count := 1;
930: RETCODE := 2;
931: ERRBUF := x_msg_data;
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;

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

938: x_msg_count := 1;
939: RETCODE := 2;
940: ERRBUF := x_msg_data;
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;

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

957: x_msg_count := 1;
958: RETCODE := 2;
959: ERRBUF := x_msg_data;
960: jty_log(FND_LOG.LEVEL_EXCEPTION,
961: 'jtf.plsql.JTY_TAE_CONTROL_PVT.classify_territories.other',
962: substr(x_msg_data, 1, 4000));
963:
964: END Classify_Territories;
965:

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

998:
999: BEGIN
1000: -- debug message
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:

Line 1003: 'Start of the procedure JTY_TAE_CONTROL_PVT.classify_dea_territories ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

999: BEGIN
1000: -- debug message
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

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

1014: WHEN NO_DATA_FOUND THEN
1015: x_msg_data := 'No row in table jtf_qual_type_usgs_all corresponding to source : ' || p_source_id || ' and transaction : ' ||
1016: p_trans_id;
1017: jty_log(FND_LOG.LEVEL_EXCEPTION,
1018: 'jtf.plsql.JTY_TAE_CONTROL_PVT.classify_dea_territories.no_qual_type_usg_id',
1019: x_msg_data);
1020:
1021: RAISE;
1022: END;

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

1626: where TAE_COL_MAP is null;
1627:
1628: -- debug message
1629: jty_log(FND_LOG.LEVEL_PROCEDURE,
1630: 'jtf.plsql.JTY_TAE_CONTROL_PVT.classify_dea_territories.end',
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

Line 1631: 'End of the procedure JTY_TAE_CONTROL_PVT.classify_dea_territories ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

1627:
1628: -- debug message
1629: jty_log(FND_LOG.LEVEL_PROCEDURE,
1630: 'jtf.plsql.JTY_TAE_CONTROL_PVT.classify_dea_territories.end',
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;

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

1636: x_msg_count := 1;
1637: RETCODE := 2;
1638: ERRBUF := x_msg_data;
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;

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

1645: x_msg_count := 1;
1646: RETCODE := 2;
1647: ERRBUF := x_msg_data;
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;

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

1664: x_msg_count := 1;
1665: RETCODE := 2;
1666: ERRBUF := x_msg_data;
1667: jty_log(FND_LOG.LEVEL_EXCEPTION,
1668: 'jtf.plsql.JTY_TAE_CONTROL_PVT.classify_dea_territories.other',
1669: substr(x_msg_data, 1, 4000));
1670:
1671: END Classify_dea_Territories;
1672:

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

1708:
1709: BEGIN
1710: -- debug message
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;

Line 1713: 'Start of the procedure JTY_TAE_CONTROL_PVT.reduce_deaval_idx_set ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

1709: BEGIN
1710: -- debug message
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';

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

1774: COMMIT;
1775:
1776: -- debug message
1777: jty_log(FND_LOG.LEVEL_PROCEDURE,
1778: 'jtf.plsql.JTY_TAE_CONTROL_PVT.reduce_deaval_idx_set.end',
1779: 'End of the procedure JTY_TAE_CONTROL_PVT.reduce_deaval_idx_set ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1780:
1781: EXCEPTION
1782:

Line 1779: 'End of the procedure JTY_TAE_CONTROL_PVT.reduce_deaval_idx_set ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

1775:
1776: -- debug message
1777: jty_log(FND_LOG.LEVEL_PROCEDURE,
1778: 'jtf.plsql.JTY_TAE_CONTROL_PVT.reduce_deaval_idx_set.end',
1779: 'End of the procedure JTY_TAE_CONTROL_PVT.reduce_deaval_idx_set ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1780:
1781: EXCEPTION
1782:
1783: WHEN OTHERS THEN

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

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:
1789: end reduce_deaval_idx_set;
1790:

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

1827:
1828: BEGIN
1829: -- debug message
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;

Line 1832: 'Start of the procedure JTY_TAE_CONTROL_PVT.reduce_dnmval_idx_set ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

1828: BEGIN
1829: -- debug message
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';

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

1893: COMMIT;
1894:
1895: -- debug message
1896: jty_log(FND_LOG.LEVEL_PROCEDURE,
1897: 'jtf.plsql.JTY_TAE_CONTROL_PVT.reduce_dnmval_idx_set.end',
1898: 'End of the procedure JTY_TAE_CONTROL_PVT.reduce_dnmval_idx_set ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1899:
1900: EXCEPTION
1901:

Line 1898: 'End of the procedure JTY_TAE_CONTROL_PVT.reduce_dnmval_idx_set ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

1894:
1895: -- debug message
1896: jty_log(FND_LOG.LEVEL_PROCEDURE,
1897: 'jtf.plsql.JTY_TAE_CONTROL_PVT.reduce_dnmval_idx_set.end',
1898: 'End of the procedure JTY_TAE_CONTROL_PVT.reduce_dnmval_idx_set ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1899:
1900: EXCEPTION
1901:
1902: WHEN OTHERS THEN

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

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:
1908: end reduce_dnmval_idx_set;
1909:

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

1969:
1970: BEGIN
1971: -- debug message
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';

Line 1974: 'Start of the procedure JTY_TAE_CONTROL_PVT.Reduce_TX_OIN_Index_Set ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

1970: BEGIN
1971: -- debug message
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;

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

2089: COMMIT;
2090:
2091: -- debug message
2092: jty_log(FND_LOG.LEVEL_PROCEDURE,
2093: 'jtf.plsql.JTY_TAE_CONTROL_PVT.Reduce_TX_OIN_Index_Set.end',
2094: 'End of the procedure JTY_TAE_CONTROL_PVT.Reduce_TX_OIN_Index_Set ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
2095:
2096: EXCEPTION
2097:

Line 2094: 'End of the procedure JTY_TAE_CONTROL_PVT.Reduce_TX_OIN_Index_Set ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

2090:
2091: -- debug message
2092: jty_log(FND_LOG.LEVEL_PROCEDURE,
2093: 'jtf.plsql.JTY_TAE_CONTROL_PVT.Reduce_TX_OIN_Index_Set.end',
2094: 'End of the procedure JTY_TAE_CONTROL_PVT.Reduce_TX_OIN_Index_Set ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
2095:
2096: EXCEPTION
2097:
2098: WHEN OTHERS THEN

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

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',
2104: substr(x_msg_data, 1, 4000));
2105:
2106: end Reduce_TX_OIN_Index_Set;
2107:

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

2165:
2166: BEGIN
2167: -- debug message
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';

Line 2170: 'Start of the procedure JTY_TAE_CONTROL_PVT.dea_Reduce_TX_OIN_Index_Set ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

2166: BEGIN
2167: -- debug message
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;

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

2285: COMMIT;
2286:
2287: -- debug message
2288: jty_log(FND_LOG.LEVEL_PROCEDURE,
2289: 'jtf.plsql.JTY_TAE_CONTROL_PVT.dea_Reduce_TX_OIN_Index_Set.end',
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

Line 2290: 'End of the procedure JTY_TAE_CONTROL_PVT.dea_Reduce_TX_OIN_Index_Set ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

2286:
2287: -- debug message
2288: jty_log(FND_LOG.LEVEL_PROCEDURE,
2289: 'jtf.plsql.JTY_TAE_CONTROL_PVT.dea_Reduce_TX_OIN_Index_Set.end',
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 ;

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

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',
2299: substr(x_msg_data, 1, 4000));
2300:
2301: end dea_Reduce_TX_OIN_Index_Set;
2302:

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

2322:
2323: BEGIN
2324: -- debug message
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:

Line 2327: 'Start of the procedure JTY_TAE_CONTROL_PVT.decompose_terr_defns ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

2323: BEGIN
2324: -- debug message
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

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

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

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

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

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

2390: END IF; /* end IF (p_mode = 'DATE EFFECTIVE') */
2391:
2392: -- debug message
2393: jty_log(FND_LOG.LEVEL_EVENT,
2394: 'jtf.plsql.JTY_TAE_CONTROL_PVT.decompose_terr_defns.reduce_tx_oin_index_set',
2395: 'API JTY_TAE_CONTROL_PVT.reduce_tx_oin_index_set ended with success');
2396: END IF; /* end IF ((p_process_tx_oin_sel = 'Y') OR (p_process_tx_oin_sel = 'R')) */
2397:
2398: IF (p_generate_indexes = 'Y') THEN

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

2391:
2392: -- debug message
2393: jty_log(FND_LOG.LEVEL_EVENT,
2394: 'jtf.plsql.JTY_TAE_CONTROL_PVT.decompose_terr_defns.reduce_tx_oin_index_set',
2395: 'API JTY_TAE_CONTROL_PVT.reduce_tx_oin_index_set ended with success');
2396: END IF; /* end IF ((p_process_tx_oin_sel = 'Y') OR (p_process_tx_oin_sel = 'R')) */
2397:
2398: IF (p_generate_indexes = 'Y') THEN
2399: jty_tae_index_creation_pvt.drop_table_indexes(

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

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

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

2436: END IF; /* end IF (p_generate_indexes = 'Y') */
2437:
2438: -- debug message
2439: jty_log(FND_LOG.LEVEL_PROCEDURE,
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

Line 2441: 'End of the procedure JTY_TAE_CONTROL_PVT.decompose_terr_defns ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

2437:
2438: -- debug message
2439: jty_log(FND_LOG.LEVEL_PROCEDURE,
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;

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

2446: x_msg_count := 1;
2447: RETCODE := 2;
2448: ERRBUF := x_msg_data;
2449: jty_log(FND_LOG.LEVEL_EXCEPTION,
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 ;

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

2456: x_msg_count := 1;
2457: RETCODE := 2;
2458: ERRBUF := x_msg_data;
2459: jty_log(FND_LOG.LEVEL_EXCEPTION,
2460: 'jtf.plsql.JTY_TAE_CONTROL_PVT.decompose_terr_defns.other',
2461: substr(x_msg_data, 1, 4000));
2462:
2463: END Decompose_Terr_Defns;
2464:

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

2487:
2488: EXCEPTION
2489: WHEN L_SCHEMA_NOTFOUND THEN
2490: jty_log(FND_LOG.LEVEL_EXCEPTION,
2491: 'jtf.plsql.JTY_TAE_CONTROL_PVT.set_table_nologging.l_schema_notfound',
2492: 'Schema name corresponding to JTF application not found');
2493:
2494: WHEN OTHERS THEN
2495: jty_log(FND_LOG.LEVEL_EXCEPTION,

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

2492: 'Schema name corresponding to JTF application not found');
2493:
2494: WHEN OTHERS THEN
2495: jty_log(FND_LOG.LEVEL_EXCEPTION,
2496: 'jtf.plsql.JTY_TAE_CONTROL_PVT.set_table_nologging.others',
2497: substr(SQLCODE || ' : ' || SQLERRM, 1, 4000));
2498: END set_table_nologging;
2499:
2500:

Line 2501: END JTY_TAE_CONTROL_PVT;

2497: substr(SQLCODE || ' : ' || SQLERRM, 1, 4000));
2498: END set_table_nologging;
2499:
2500:
2501: END JTY_TAE_CONTROL_PVT;