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_TERR_ENGINE_GEN2_PVT dependencies on FND_LOG

Line 48: IF (p_log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

44: ,p_message IN VARCHAR2)
45: IS
46: pragma autonomous_transaction;
47: BEGIN
48: IF (p_log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
49: FND_LOG.string(p_log_level, p_module, p_message);
50: commit;
51: END IF;
52: END;

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

45: IS
46: pragma autonomous_transaction;
47: BEGIN
48: IF (p_log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
49: FND_LOG.string(p_log_level, p_module, p_message);
50: commit;
51: END IF;
52: END;
53:

Line 86: jty_log(FND_LOG.LEVEL_PROCEDURE,

82: l_index_name varchar2(30);
83:
84: BEGIN
85: -- debug message
86: jty_log(FND_LOG.LEVEL_PROCEDURE,
87: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.populate_index_info.start',
88: 'Start of the procedure JTY_TERR_ENGINE_GEN2_PVT.populate_index_info ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
89:
90: IF (p_qual_usg_id_tbl.COUNT > 0) THEN

Line 536: jty_log(FND_LOG.LEVEL_PROCEDURE,

532:
533: END IF; -- IF (p_qual_usg_id_tbl.COUNT > 0)
534:
535: -- debug message
536: jty_log(FND_LOG.LEVEL_PROCEDURE,
537: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.populate_index_info.end',
538: 'End of the procedure JTY_TERR_ENGINE_GEN2_PVT.populate_index_info ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
539:
540: retcode := 0;

Line 547: jty_log(FND_LOG.LEVEL_EXCEPTION,

543: EXCEPTION
544: WHEN OTHERS THEN
545: RETCODE := 2;
546: ERRBUF := SQLCODE || ' : ' || SQLERRM;
547: jty_log(FND_LOG.LEVEL_EXCEPTION,
548: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.populate_index_info.others',
549: substr(errbuf, 1, 4000));
550:
551: END populate_index_info;

Line 584: jty_log(FND_LOG.LEVEL_PROCEDURE,

580: l_qual_type_usg_id NUMBER;
581:
582: BEGIN
583: -- debug message
584: jty_log(FND_LOG.LEVEL_PROCEDURE,
585: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.populate_dea_index_info.start',
586: 'Start of the procedure JTY_TERR_ENGINE_GEN2_PVT.populate_dea_index_info ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
587:
588: IF (p_qual_usg_id_tbl.COUNT > 0) THEN

Line 1026: jty_log(FND_LOG.LEVEL_PROCEDURE,

1022:
1023: END IF; -- IF (p_qual_usg_id_tbl.COUNT > 0)
1024:
1025: -- debug message
1026: jty_log(FND_LOG.LEVEL_PROCEDURE,
1027: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.populate_dea_index_info.end',
1028: 'End of the procedure JTY_TERR_ENGINE_GEN2_PVT.populate_dea_index_info ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1029:
1030: retcode := 0;

Line 1037: jty_log(FND_LOG.LEVEL_EXCEPTION,

1033: EXCEPTION
1034: WHEN OTHERS THEN
1035: RETCODE := 2;
1036: ERRBUF := SQLCODE || ' : ' || SQLERRM;
1037: jty_log(FND_LOG.LEVEL_EXCEPTION,
1038: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.populate_dea_index_info.others',
1039: substr(errbuf, 1, 4000));
1040:
1041: END populate_dea_index_info;

Line 1148: jty_log(FND_LOG.LEVEL_PROCEDURE,

1144: l_newline VARCHAR2(2);
1145:
1146: BEGIN
1147: -- debug message
1148: jty_log(FND_LOG.LEVEL_PROCEDURE,
1149: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_terr_rules_recurse.start',
1150: 'Start of the procedure JTY_TERR_ENGINE_GEN2_PVT.gen_terr_rules_recurse ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1151:
1152: l_newline := FND_GLOBAL.Local_Chr(10); /* newline character */

Line 1191: jty_log(FND_LOG.LEVEL_STATEMENT,

1187: ,l_fc_tbl;
1188: CLOSE c_terr_qual;
1189:
1190: -- debug message
1191: jty_log(FND_LOG.LEVEL_STATEMENT,
1192: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_terr_rules_recurse.num_qual',
1193: 'Number of qualifiers used by valid territories : ' || l_qual_usg_id_tbl.COUNT);
1194:
1195: /* get all the program name and its corresponding real time trans table for the usage and txn type */

Line 1203: jty_log(FND_LOG.LEVEL_STATEMENT,

1199: ,l_trans_name_tbl;
1200: CLOSE c_trans_details;
1201:
1202: -- debug message
1203: jty_log(FND_LOG.LEVEL_STATEMENT,
1204: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_terr_rules_recurse.num_program',
1205: 'Number of programs for the usage and transaction type : ' || l_pgm_name_tbl.COUNT);
1206:
1207: /* generic insert statement */

Line 1300: jty_log(FND_LOG.LEVEL_STATEMENT,

1296: -- Province -1046
1297:
1298:
1299: -- debug message
1300: jty_log(FND_LOG.LEVEL_STATEMENT,
1301: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_terr_rules_recurse loop qualifier - length', length(l_qual_rules));
1302:
1303: IF l_qual_usg_id_tbl(j) in ( '-1040','-1041','-1042','-1044','-1048','-1744','-1734','-1096','-1039','-1213', '-1218',
1304: '-1037','-1038','-1043','-1046','-1050','-1051','-1060','-1061','-1095', '-1210', '-1045', '-1206') THEN

Line 1413: jty_log(FND_LOG.LEVEL_EXCEPTION,

1409: END IF;
1410:
1411: IF (retcode <> 0) THEN
1412: -- debug message
1413: jty_log(FND_LOG.LEVEL_EXCEPTION,
1414: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_terr_rules_recurse.populate_index_info',
1415: 'populate_index_info API has failed');
1416:
1417: RAISE FND_API.G_EXC_ERROR;

Line 1421: jty_log(FND_LOG.LEVEL_PROCEDURE,

1417: RAISE FND_API.G_EXC_ERROR;
1418: END IF;
1419:
1420: -- debug message
1421: jty_log(FND_LOG.LEVEL_PROCEDURE,
1422: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_terr_rules_recurse.end',
1423: 'End of the procedure JTY_TERR_ENGINE_GEN2_PVT.gen_terr_rules_recurse ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1424:
1425: EXCEPTION

Line 1427: jty_log(FND_LOG.LEVEL_EXCEPTION,

1423: 'End of the procedure JTY_TERR_ENGINE_GEN2_PVT.gen_terr_rules_recurse ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1424:
1425: EXCEPTION
1426: WHEN FND_API.G_EXC_ERROR THEN
1427: jty_log(FND_LOG.LEVEL_EXCEPTION,
1428: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_terr_rules_recurse.g_exc_error',
1429: 'API JTY_TERR_ENGINE_GEN2_PVT.gen_terr_rules_recurse has failed with FND_API.G_EXC_ERROR exception');
1430:
1431: WHEN OTHERS THEN

Line 1434: jty_log(FND_LOG.LEVEL_EXCEPTION,

1430:
1431: WHEN OTHERS THEN
1432: RETCODE := 2;
1433: ERRBUF := SQLCODE || ' : ' || SQLERRM;
1434: jty_log(FND_LOG.LEVEL_EXCEPTION,
1435: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_terr_rules_recurse.others',
1436: substr(errbuf, 1, 4000));
1437:
1438: END gen_terr_rules_recurse;

Line 1458: jty_log(FND_LOG.LEVEL_PROCEDURE,

1454: l_end_date DATE;
1455:
1456: BEGIN
1457: -- debug message
1458: jty_log(FND_LOG.LEVEL_PROCEDURE,
1459: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_real_time_sql.start',
1460: 'Start of the procedure JTY_TERR_ENGINE_GEN2_PVT.gen_real_time_sql ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1461:
1462: -- debug message

Line 1463: jty_log(FND_LOG.LEVEL_STATEMENT,

1459: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_real_time_sql.start',
1460: 'Start of the procedure JTY_TERR_ENGINE_GEN2_PVT.gen_real_time_sql ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1461:
1462: -- debug message
1463: jty_log(FND_LOG.LEVEL_STATEMENT,
1464: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_real_time_sql.parameters',
1465: 'p_source_id : ' || p_source_id || ' p_trans_id : ' || p_trans_id || ' p_mode : ' || p_mode ||
1466: ' p_start_date : ' || p_start_date || ' p_end_date : ' || p_end_date);
1467:

Line 1549: jty_log(FND_LOG.LEVEL_STATEMENT,

1545: AND rownum < 2;
1546: END IF;
1547:
1548: -- debug message
1549: jty_log(FND_LOG.LEVEL_STATEMENT,
1550: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_real_time_sql.num_terr',
1551: 'Number of territories for this usage and transaction type : ' || l_num_of_terr);
1552:
1553: /* territories exist for this USAGE/TRANSACTION TYPE combination */

Line 1568: jty_log(FND_LOG.LEVEL_EXCEPTION,

1564: retcode => retcode);
1565:
1566: IF (retcode <> 0) THEN
1567: -- debug message
1568: jty_log(FND_LOG.LEVEL_EXCEPTION,
1569: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_real_time_sql.gen_terr_rules_recurse',
1570: 'gen_terr_rules_recurse API has failed');
1571:
1572: RAISE FND_API.G_EXC_ERROR;

Line 1577: jty_log(FND_LOG.LEVEL_EXCEPTION,

1573: END IF;
1574:
1575: ELSE
1576: -- debug message
1577: jty_log(FND_LOG.LEVEL_EXCEPTION,
1578: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_real_time_sql.no_real_time_sql',
1579: 'No valid territories for this usage and transaction type');
1580:
1581: END IF; /* end if(num_of_terr > 0) */

Line 1584: jty_log(FND_LOG.LEVEL_PROCEDURE,

1580:
1581: END IF; /* end if(num_of_terr > 0) */
1582:
1583: -- debug message
1584: jty_log(FND_LOG.LEVEL_PROCEDURE,
1585: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_real_time_sql.end',
1586: 'End of the procedure JTY_TERR_ENGINE_GEN2_PVT.gen_real_time_sql ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1587:
1588: retcode := 0;

Line 1593: jty_log(FND_LOG.LEVEL_EXCEPTION,

1589: errbuf := null;
1590:
1591: EXCEPTION
1592: WHEN FND_API.G_EXC_ERROR THEN
1593: jty_log(FND_LOG.LEVEL_EXCEPTION,
1594: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_real_time_sql.g_exc_error',
1595: 'API JTY_TERR_ENGINE_GEN2_PVT.gen_real_time_sql has failed with FND_API.G_EXC_ERROR exception');
1596:
1597: WHEN OTHERS THEN

Line 1600: jty_log(FND_LOG.LEVEL_EXCEPTION,

1596:
1597: WHEN OTHERS THEN
1598: RETCODE := 2;
1599: ERRBUF := SQLCODE || ' : ' || SQLERRM;
1600: jty_log(FND_LOG.LEVEL_EXCEPTION,
1601: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_real_time_sql.others',
1602: substr(errbuf, 1, 4000));
1603:
1604: END gen_real_time_sql;