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_LOG

Line 43: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

39: l_qual_prd_id_tbl l_qual_prd_id_tbl_type;
40: l_rel_prd_tbl l_rel_prd_tbl_type;
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;

Line 44: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

40: l_rel_prd_tbl l_rel_prd_tbl_type;
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:

Line 156: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

152: END;
153: END IF; /* end IF (p_mode = 'TOTAL') */
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;

Line 157: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

153: END IF; /* end IF (p_mode = 'TOTAL') */
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:

Line 168: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) 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
169: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
170: 'jtf.plsql.jtf_tae_cpntrol_pvt.delete_combinations.g_exc_unexpected_error',
171: x_msg_data);
172: END IF;

Line 169: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

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
169: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
170: 'jtf.plsql.jtf_tae_cpntrol_pvt.delete_combinations.g_exc_unexpected_error',
171: x_msg_data);
172: END IF;
173:

Line 180: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

176: x_msg_data := SQLCODE || ' : ' || SQLERRM;
177: x_msg_count := 1;
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;

Line 181: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

177: x_msg_count := 1;
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:

Line 225: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

221: and org_id = -3113;
222:
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;

Line 226: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

222:
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:

Line 243: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

239: EXCEPTION
240: WHEN NO_DATA_FOUND THEN
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;

Line 244: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

240: WHEN NO_DATA_FOUND THEN
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;

Line 881: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

877: USE_TAE_COL_IN_INDEX_FLAG = 'N'
878: where TAE_COL_MAP is null;
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;

Line 882: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

878: where TAE_COL_MAP is null;
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:

Line 893: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) 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
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;

Line 894: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

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
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:

Line 904: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) 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
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;

Line 905: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

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
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:

Line 915: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) 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
916: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
917: 'jtf.plsql.jtf_tae_cpntrol_pvt.classify_territories.g_exc_unexpected_error',
918: x_msg_data);
919: END IF;

Line 916: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

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
916: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
917: 'jtf.plsql.jtf_tae_cpntrol_pvt.classify_territories.g_exc_unexpected_error',
918: x_msg_data);
919: END IF;
920:

Line 927: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

923: x_msg_data := SQLCODE || ' : ' || SQLERRM;
924: x_msg_count := 1;
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;

Line 928: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

924: x_msg_count := 1;
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:

Line 970: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

966: and org_id = -3113;
967:
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;

Line 971: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

967:
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:

Line 988: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

984: EXCEPTION
985: WHEN NO_DATA_FOUND THEN
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;

Line 989: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

985: WHEN NO_DATA_FOUND THEN
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;

Line 1599: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1595: USE_TAE_COL_IN_INDEX_FLAG = 'N'
1596: where TAE_COL_MAP is null;
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;

Line 1600: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

1596: where TAE_COL_MAP is null;
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:

Line 1611: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) 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
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;

Line 1612: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

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
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:

Line 1622: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) 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
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;

Line 1623: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

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
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:

Line 1633: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) 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
1634: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1635: 'jtf.plsql.jtf_tae_cpntrol_pvt.classify_dea_territories.g_exc_unexpected_error',
1636: x_msg_data);
1637: END IF;

Line 1634: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

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
1634: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1635: 'jtf.plsql.jtf_tae_cpntrol_pvt.classify_dea_territories.g_exc_unexpected_error',
1636: x_msg_data);
1637: END IF;
1638:

Line 1645: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1641: x_msg_data := SQLCODE || ' : ' || SQLERRM;
1642: x_msg_count := 1;
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;

Line 1646: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

1642: x_msg_count := 1;
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:

Line 1690: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1686:
1687:
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;

Line 1691: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

1687:
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:

Line 1749: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1745:
1746: COMMIT;
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;

Line 1750: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

1746: COMMIT;
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:

Line 1759: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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));
1763: END IF;

Line 1760: FND_LOG.string(FND_LOG.LEVEL_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));
1763: END IF;
1764:

Line 1806: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1802:
1803:
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;

Line 1807: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

1803:
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:

Line 1874: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1870:
1871: COMMIT;
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;

Line 1875: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

1871: COMMIT;
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:

Line 1884: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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));
1888: END IF;

Line 1885: FND_LOG.string(FND_LOG.LEVEL_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));
1888: END IF;
1889:

Line 1954: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1950:
1951:
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;

Line 1955: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

1951:
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:

Line 2076: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2072:
2073: COMMIT;
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;

Line 2077: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

2073: COMMIT;
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:

Line 2088: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

Line 2089: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

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

Line 2156: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2152: AND p.trans_type_id = cl_trans_id;
2153:
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;

Line 2157: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

2153:
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:

Line 2278: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2274:
2275: COMMIT;
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;

Line 2279: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

2275: COMMIT;
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:

Line 2289: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

Line 2290: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

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,
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:

Line 2319: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2315: l_selectivity_return_val NUMBER;
2316:
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;

Line 2320: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

2316:
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:

Line 2389: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2385: END IF;
2386: END IF; /* end IF (p_mode = 'DATE EFFECTIVE') */
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;

Line 2390: FND_LOG.string(FND_LOG.LEVEL_EVENT,

2386: END IF; /* end IF (p_mode = 'DATE EFFECTIVE') */
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')) */

Line 2431: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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
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;

Line 2432: FND_LOG.string(FND_LOG.LEVEL_EVENT,

2428: END IF;
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:

Line 2440: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2436:
2437: END IF; /* end IF (p_generate_indexes = 'Y') */
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;

Line 2441: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

2437: END IF; /* end IF (p_generate_indexes = 'Y') */
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:

Line 2452: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) 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
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;

Line 2453: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

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
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:

Line 2464: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2460: x_msg_data := SQLCODE || ' : ' || SQLERRM;
2461: x_msg_count := 1;
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;

Line 2465: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

2461: x_msg_count := 1;
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:

Line 2497: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2493: EXECUTE IMMEDIATE v_statement;
2494:
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;

Line 2498: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

2494:
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:

Line 2504: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2500: 'Schema name corresponding to JTF application not found');
2501: END IF;
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;

Line 2505: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

2501: END IF;
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;