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

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

32: ,p_message IN VARCHAR2)
33: IS
34: pragma autonomous_transaction;
35: BEGIN
36: IF (p_log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
37: FND_LOG.string(p_log_level, p_module, p_message);
38: commit;
39: END IF;
40: END;

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

33: IS
34: pragma autonomous_transaction;
35: BEGIN
36: IF (p_log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
37: FND_LOG.string(p_log_level, p_module, p_message);
38: commit;
39: END IF;
40: END;
41:

Line 107: jty_log(FND_LOG.LEVEL_PROCEDURE,

103: l_hier_tbl l_hier_tbl_type;
104: BEGIN
105:
106: -- debug message
107: jty_log(FND_LOG.LEVEL_PROCEDURE,
108: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.get_terr_for_incr_star.start',
109: 'Start of the procedure JTY_TERR_ENGINE_GEN_PVT.get_terr_for_incr_star ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
110:
111: /* Insert into jty_changed_terrs the territories that */

Line 316: jty_log(FND_LOG.LEVEL_PROCEDURE,

312: AND b.parent_territory_id = c.terr_id(+)
313: AND b.org_id = c.org_id(+);
314:
315: -- debug message
316: jty_log(FND_LOG.LEVEL_PROCEDURE,
317: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.get_terr_for_incr_star.end',
318: 'End of the procedure JTY_TERR_ENGINE_GEN_PVT.get_terr_for_incr_star ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
319:
320: retcode := 0;

Line 327: jty_log(FND_LOG.LEVEL_EXCEPTION,

323: EXCEPTION
324: WHEN OTHERS THEN
325: RETCODE := 2;
326: ERRBUF := SQLCODE || ' : ' || SQLERRM;
327: jty_log(FND_LOG.LEVEL_EXCEPTION,
328: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.get_terr_for_incr_star.others',
329: substr(errbuf, 1, 4000));
330:
331: END get_terr_for_incr_star;

Line 387: jty_log(FND_LOG.LEVEL_PROCEDURE,

383:
384: BEGIN
385:
386: -- debug message
387: jty_log(FND_LOG.LEVEL_PROCEDURE,
388: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.get_terr_for_dea_incr_star.start',
389: 'Start of the procedure JTY_TERR_ENGINE_GEN_PVT.get_terr_for_dea_incr_star ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
390:
391:

Line 511: jty_log(FND_LOG.LEVEL_PROCEDURE,

507: AND b.org_id = c.org_id(+);
508:
509:
510: -- debug message
511: jty_log(FND_LOG.LEVEL_PROCEDURE,
512: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.get_terr_for_dea_incr_star.end',
513: 'End of the procedure JTY_TERR_ENGINE_GEN_PVT.get_terr_for_dea_incr_star ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
514:
515: retcode := 0;

Line 522: jty_log(FND_LOG.LEVEL_EXCEPTION,

518: EXCEPTION
519: WHEN OTHERS THEN
520: RETCODE := 2;
521: ERRBUF := SQLCODE || ' : ' || SQLERRM;
522: jty_log(FND_LOG.LEVEL_EXCEPTION,
523: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.get_terr_for_dea_incr_star.others',
524: substr(errbuf, 1, 4000));
525:
526: END get_terr_for_dea_incr_star;

Line 589: jty_log(FND_LOG.LEVEL_PROCEDURE,

585:
586: BEGIN
587:
588: -- debug message
589: jty_log(FND_LOG.LEVEL_PROCEDURE,
590: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_matching_sql.start',
591: 'Start of the procedure JTY_TERR_ENGINE_GEN_PVT.gen_matching_sql ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
592:
593: l_sysdate := SYSDATE;

Line 616: jty_log(FND_LOG.LEVEL_EXCEPTION,

612: errbuf => errbuf,
613: retcode => retcode);
614: IF (retcode <> 0) THEN
615: -- debug message
616: jty_log(FND_LOG.LEVEL_EXCEPTION,
617: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_matching_sql.gen_real_time_sql',
618: 'JTY_TERR_ENGINE_GEN2_PVT.gen_real_time_sql API has failed');
619:
620: RAISE FND_API.G_EXC_ERROR;

Line 640: jty_log(FND_LOG.LEVEL_EXCEPTION,

636: RETCODE => retcode);
637:
638: IF (retcode <> 0) THEN
639: -- debug message
640: jty_log(FND_LOG.LEVEL_EXCEPTION,
641: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_matching_sql.delete_combinations',
642: 'JTY_TAE_CONTROL_PVT.delete_combinations API has failed');
643:
644: RAISE FND_API.G_EXC_ERROR;

Line 773: jty_log(FND_LOG.LEVEL_EXCEPTION,

769: retcode => retcode);
770:
771: IF (retcode <> 0) THEN
772: -- debug message
773: jty_log(FND_LOG.LEVEL_EXCEPTION,
774: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_matching_sql.gen_batch_sql',
775: 'jty_tae_gen_pvt.gen_batch_sql API has failed');
776:
777: RAISE FND_API.G_EXC_ERROR;

Line 788: jty_log(FND_LOG.LEVEL_PROCEDURE,

784: END LOOP; /* end loop FOR i IN l_qual_type_id_tbl.FIRST .. l_qual_type_id_tbl.LAST */
785: END IF; /* end IF (l_qual_type_id_tbl.COUNT > 0) */
786:
787: -- debug message
788: jty_log(FND_LOG.LEVEL_PROCEDURE,
789: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_matching_sql.end',
790: 'End of the procedure JTY_TERR_ENGINE_GEN_PVT.gen_matching_sql ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
791:
792: retcode := 0;

Line 798: jty_log(FND_LOG.LEVEL_EXCEPTION,

794:
795: EXCEPTION
796: WHEN FND_API.G_EXC_ERROR THEN
797: RETCODE := 2;
798: jty_log(FND_LOG.LEVEL_EXCEPTION,
799: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_matching_sql.g_exc_error',
800: 'API JTY_TERR_ENGINE_GEN_PVT.gen_matching_sql has failed with FND_API.G_EXC_ERROR exception');
801:
802: WHEN OTHERS THEN

Line 805: jty_log(FND_LOG.LEVEL_EXCEPTION,

801:
802: WHEN OTHERS THEN
803: RETCODE := 2;
804: ERRBUF := SQLCODE || ' : ' || SQLERRM;
805: jty_log(FND_LOG.LEVEL_EXCEPTION,
806: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_matching_sql.others',
807: substr(errbuf, 1, 4000));
808:
809: END gen_matching_sql;

Line 882: jty_log(FND_LOG.LEVEL_PROCEDURE,

878: l_denorm_count NUMBER;
879: BEGIN
880:
881: -- debug message
882: jty_log(FND_LOG.LEVEL_PROCEDURE,
883: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_rule_engine.start',
884: 'Start of the procedure JTY_TERR_ENGINE_GEN_PVT.gen_rule_engine ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
885:
886: /* Initialize audit columns */

Line 928: jty_log(FND_LOG.LEVEL_STATEMENT,

924: order by end_date ;
925: END IF;
926:
927: -- debug message
928: jty_log(FND_LOG.LEVEL_STATEMENT,
929: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_rule_engine.param_values',
930: 'Source : ' || p_source_id || ' Mode : ' || p_mode || ' Start Date : ' || p_start_date ||
931: ' End Date : ' || p_end_date);
932:

Line 950: jty_log(FND_LOG.LEVEL_EXCEPTION,

946: IF (l_count = 0) THEN
947: -- debug message
948: retcode := 2;
949: errbuf := 'STAR should be run at least once in TOTAL mode before INCREMENTAL mode';
950: jty_log(FND_LOG.LEVEL_EXCEPTION,
951: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_rule_engine.check_total_mode',
952: errbuf);
953:
954: RAISE FND_API.G_EXC_ERROR;

Line 970: jty_log(FND_LOG.LEVEL_EXCEPTION,

966: errbuf => errbuf);
967:
968: IF (retcode <> 0) THEN
969: -- debug message
970: jty_log(FND_LOG.LEVEL_EXCEPTION,
971: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_rule_engine.get_terr_for_incr_star',
972: 'get_terr_for_incr_star API has failed');
973:
974: RAISE FND_API.G_EXC_ERROR;

Line 990: jty_log(FND_LOG.LEVEL_EXCEPTION,

986: IF (l_count = 0) THEN
987: -- debug message
988: retcode := 2;
989: errbuf := 'STAR should be run at least once in DATE EFFECTIVE mode before DEA INCREMENTAL mode';
990: jty_log(FND_LOG.LEVEL_EXCEPTION,
991: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_rule_engine.check_dea_incremental_mode',
992: errbuf);
993:
994: RAISE FND_API.G_EXC_ERROR;

Line 1010: jty_log(FND_LOG.LEVEL_EXCEPTION,

1006: errbuf => errbuf);
1007:
1008: IF (retcode <> 0) THEN
1009: -- debug message
1010: jty_log(FND_LOG.LEVEL_EXCEPTION,
1011: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_rule_engine.get_terr_for_dea_incr_star',
1012: 'get_terr_for_incr_star API has failed');
1013:
1014: RAISE FND_API.G_EXC_ERROR;

Line 1044: jty_log(FND_LOG.LEVEL_STATEMENT,

1040:
1041: l_no_of_records := l_terr_change_tab.terr_id.COUNT;
1042:
1043: -- debug message
1044: jty_log(FND_LOG.LEVEL_STATEMENT,
1045: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_rule_engine.no_of_terr',
1046: 'Number of territories to be processed : ' || l_no_of_records);
1047:
1048: IF (l_no_of_records > 0) THEN

Line 1059: jty_log(FND_LOG.LEVEL_EXCEPTION,

1055: retcode => retcode);
1056:
1057: IF (retcode <> 0) THEN
1058: -- debug message
1059: jty_log(FND_LOG.LEVEL_EXCEPTION,
1060: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_rule_engine.process_attr_and_rank',
1061: 'process_attr_and_rank API has failed');
1062:
1063: RAISE FND_API.G_EXC_ERROR;

Line 1067: jty_log(FND_LOG.LEVEL_EVENT,

1063: RAISE FND_API.G_EXC_ERROR;
1064: END IF;
1065:
1066: -- debug message
1067: jty_log(FND_LOG.LEVEL_EVENT,
1068: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_rule_engine.process_attr_and_rank',
1069: 'process_attr_and_rank API has completed with success');
1070:
1071: /* Generate real time and batch matching SQLs */

Line 1086: jty_log(FND_LOG.LEVEL_EXCEPTION,

1082: retcode => retcode);
1083:
1084: IF (retcode <> 0) THEN
1085: -- debug message
1086: jty_log(FND_LOG.LEVEL_EXCEPTION,
1087: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_rule_engine.gen_matching_sql',
1088: 'gen_matching_sql API has failed');
1089:
1090: RAISE FND_API.G_EXC_ERROR;

Line 1094: jty_log(FND_LOG.LEVEL_EVENT,

1090: RAISE FND_API.G_EXC_ERROR;
1091: END IF;
1092:
1093: -- debug message
1094: jty_log(FND_LOG.LEVEL_EVENT,
1095: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_rule_engine.gen_matching_sql',
1096: 'gen_matching_sql API has completed with success');
1097:
1098: /* PERSON_ID required for OSO TAP */

Line 1168: jty_log(FND_LOG.LEVEL_EXCEPTION,

1164: END IF;
1165:
1166: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1167: -- debug message
1168: jty_log(FND_LOG.LEVEL_EXCEPTION,
1169: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_rule_engine.CREATE_DNMVAL_INDEX',
1170: 'JTY_TERR_DENORM_RULES_PVT.CREATE_DNMVAL_INDEX API has failed');
1171:
1172: RAISE FND_API.G_EXC_ERROR;

Line 1177: jty_log(FND_LOG.LEVEL_EXCEPTION,

1173: END IF;
1174:
1175: ELSE
1176: -- debug message
1177: jty_log(FND_LOG.LEVEL_EXCEPTION,
1178: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_rule_engine.no_of_terr',
1179: 'No territories processed');
1180:
1181: END IF; /* IF (l_no_of_records > 0) */

Line 1192: jty_log(FND_LOG.LEVEL_EXCEPTION, 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_rule_engine', 'JTY_TERR_MAP_PVT.set_terr_geo_flag API has failed');

1188: p_terr_change_tab => l_terr_change_tab,
1189: errbuf => errbuf, retcode => retcode );
1190: IF (retcode <> 0) THEN
1191: -- debug message
1192: jty_log(FND_LOG.LEVEL_EXCEPTION, 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_rule_engine', 'JTY_TERR_MAP_PVT.set_terr_geo_flag API has failed');
1193: RAISE FND_API.G_EXC_ERROR;
1194: END IF;
1195: */
1196: /* if batch mode is not enabled for the usage, delete all the entries processed from the changed table */

Line 1298: jty_log(FND_LOG.LEVEL_PROCEDURE,

1294: ,0);
1295: END IF;
1296:
1297: -- debug message
1298: jty_log(FND_LOG.LEVEL_PROCEDURE,
1299: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_rule_engine.end',
1300: 'End of the procedure JTY_TERR_ENGINE_GEN_PVT.gen_rule_engine ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1301:
1302: EXCEPTION

Line 1305: jty_log(FND_LOG.LEVEL_EXCEPTION,

1301:
1302: EXCEPTION
1303: WHEN FND_API.G_EXC_ERROR THEN
1304: RETCODE := 2;
1305: jty_log(FND_LOG.LEVEL_EXCEPTION,
1306: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_rule_engine.g_exc_error',
1307: 'API JTY_TERR_ENGINE_GEN_PVT.gen_rule_engine has failed with FND_API.G_EXC_ERROR exception');
1308:
1309: WHEN OTHERS THEN

Line 1312: jty_log(FND_LOG.LEVEL_EXCEPTION,

1308:
1309: WHEN OTHERS THEN
1310: RETCODE := 2;
1311: ERRBUF := SQLCODE || ' : ' || SQLERRM;
1312: jty_log(FND_LOG.LEVEL_EXCEPTION,
1313: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_rule_engine.others',
1314: substr(errbuf, 1, 4000));
1315:
1316: END gen_rule_engine;