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 31: IF (p_log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

27: ,p_message IN VARCHAR2)
28: IS
29: pragma autonomous_transaction;
30: BEGIN
31: IF (p_log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
32: FND_LOG.string(p_log_level, p_module, p_message);
33: commit;
34: END IF;
35: END;

Line 32: FND_LOG.string(p_log_level, p_module, p_message);

28: IS
29: pragma autonomous_transaction;
30: BEGIN
31: IF (p_log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
32: FND_LOG.string(p_log_level, p_module, p_message);
33: commit;
34: END IF;
35: END;
36:

Line 55: jty_log(FND_LOG.LEVEL_PROCEDURE,

51: l_qual_prd_id_tbl l_qual_prd_id_tbl_type;
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;

Line 207: jty_log(FND_LOG.LEVEL_PROCEDURE,

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

Line 217: jty_log(FND_LOG.LEVEL_EXCEPTION,

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,
218: 'jtf.plsql.jtf_tae_cpntrol_pvt.delete_combinations.g_exc_unexpected_error',
219: x_msg_data);
220:
221: WHEN OTHERS THEN

Line 227: jty_log(FND_LOG.LEVEL_EXCEPTION,

223: x_msg_data := SQLCODE || ' : ' || SQLERRM;
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;

Line 270: jty_log(FND_LOG.LEVEL_PROCEDURE,

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

Line 286: jty_log(FND_LOG.LEVEL_EXCEPTION,

282: EXCEPTION
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;

Line 922: jty_log(FND_LOG.LEVEL_PROCEDURE,

918: USE_TAE_COL_IN_INDEX_FLAG = 'N'
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

Line 932: jty_log(FND_LOG.LEVEL_EXCEPTION,

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

Line 941: jty_log(FND_LOG.LEVEL_EXCEPTION,

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

Line 950: jty_log(FND_LOG.LEVEL_EXCEPTION,

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,
951: 'jtf.plsql.jtf_tae_cpntrol_pvt.classify_territories.g_exc_unexpected_error',
952: x_msg_data);
953:
954: WHEN OTHERS THEN

Line 960: jty_log(FND_LOG.LEVEL_EXCEPTION,

956: x_msg_data := SQLCODE || ' : ' || SQLERRM;
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;

Line 1001: jty_log(FND_LOG.LEVEL_PROCEDURE,

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

Line 1017: jty_log(FND_LOG.LEVEL_EXCEPTION,

1013: EXCEPTION
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;

Line 1629: jty_log(FND_LOG.LEVEL_PROCEDURE,

1625: USE_TAE_COL_IN_INDEX_FLAG = 'N'
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

Line 1639: jty_log(FND_LOG.LEVEL_EXCEPTION,

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

Line 1648: jty_log(FND_LOG.LEVEL_EXCEPTION,

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

Line 1657: jty_log(FND_LOG.LEVEL_EXCEPTION,

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,
1658: 'jtf.plsql.jtf_tae_cpntrol_pvt.classify_dea_territories.g_exc_unexpected_error',
1659: x_msg_data);
1660:
1661: WHEN OTHERS THEN

Line 1667: jty_log(FND_LOG.LEVEL_EXCEPTION,

1663: x_msg_data := SQLCODE || ' : ' || SQLERRM;
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;

Line 1711: jty_log(FND_LOG.LEVEL_PROCEDURE,

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

Line 1777: jty_log(FND_LOG.LEVEL_PROCEDURE,

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

Line 1785: jty_log(FND_LOG.LEVEL_EXCEPTION,

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

Line 1830: jty_log(FND_LOG.LEVEL_PROCEDURE,

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

Line 1896: jty_log(FND_LOG.LEVEL_PROCEDURE,

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

Line 1904: jty_log(FND_LOG.LEVEL_EXCEPTION,

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

Line 1972: jty_log(FND_LOG.LEVEL_PROCEDURE,

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

Line 2092: jty_log(FND_LOG.LEVEL_PROCEDURE,

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

Line 2102: jty_log(FND_LOG.LEVEL_EXCEPTION,

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

Line 2168: jty_log(FND_LOG.LEVEL_PROCEDURE,

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

Line 2288: jty_log(FND_LOG.LEVEL_PROCEDURE,

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

Line 2297: jty_log(FND_LOG.LEVEL_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',
2299: substr(x_msg_data, 1, 4000));
2300:
2301: end dea_Reduce_TX_OIN_Index_Set;

Line 2325: jty_log(FND_LOG.LEVEL_PROCEDURE,

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

Line 2393: jty_log(FND_LOG.LEVEL_EVENT,

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

Line 2433: jty_log(FND_LOG.LEVEL_EVENT,

2429: RAISE FND_API.G_EXC_ERROR;
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:

Line 2439: jty_log(FND_LOG.LEVEL_PROCEDURE,

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

Line 2449: jty_log(FND_LOG.LEVEL_EXCEPTION,

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,
2450: 'jtf.plsql.JTY_TAE_CONTROL_PVT.decompose_terr_defns.g_exc_error',
2451: x_msg_data);
2452:
2453: WHEN OTHERS THEN

Line 2459: jty_log(FND_LOG.LEVEL_EXCEPTION,

2455: x_msg_data := SQLCODE || ' : ' || SQLERRM;
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;

Line 2490: jty_log(FND_LOG.LEVEL_EXCEPTION,

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

Line 2495: 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,
2496: 'jtf.plsql.JTY_TAE_CONTROL_PVT.set_table_nologging.others',
2497: substr(SQLCODE || ' : ' || SQLERRM, 1, 4000));
2498: END set_table_nologging;
2499: