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_API

Line 620: RAISE FND_API.G_EXC_ERROR;

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;
621: END IF;
622:
623:
624: /* delete the old records from the tables jtf_tae_qual_products, jtf_tae_qual_factors */

Line 644: RAISE FND_API.G_EXC_ERROR;

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;
645: END IF;
646:
647: /* if mode is total or date effective, get all the qualifier combinations for the active territories */
648: /* if mode is incremental, get all the distinct qualifier comb for the territories with */

Line 777: RAISE FND_API.G_EXC_ERROR;

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;
778: END IF;
779:
780: END IF; /* end IF (l_qual_prd_tbl.COUNT > 0) */
781:

Line 796: WHEN FND_API.G_EXC_ERROR THEN

792: retcode := 0;
793: errbuf := null;
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');

Line 800: 'API JTY_TERR_ENGINE_GEN_PVT.gen_matching_sql has failed with FND_API.G_EXC_ERROR 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
803: RETCODE := 2;
804: ERRBUF := SQLCODE || ' : ' || SQLERRM;

Line 954: RAISE FND_API.G_EXC_ERROR;

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;
955: END IF;
956: EXCEPTION
957: WHEN OTHERS THEN
958: RAISE;

Line 974: RAISE FND_API.G_EXC_ERROR;

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;
975: END IF;
976: ELSIF (p_mode = 'DEA INCREMENTAL') THEN
977: BEGIN
978: SELECT count(*)

Line 994: RAISE FND_API.G_EXC_ERROR;

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;
995: END IF;
996: EXCEPTION
997: WHEN OTHERS THEN
998: RAISE;

Line 1014: RAISE FND_API.G_EXC_ERROR;

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;
1015: END IF;
1016: ELSE
1017: IF (p_mode = 'TOTAL') THEN
1018: OPEN csr_get_terr(p_source_id, g_sysdate, g_sysdate);

Line 1063: RAISE FND_API.G_EXC_ERROR;

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;
1064: END IF;
1065:
1066: -- debug message
1067: jty_log(FND_LOG.LEVEL_EVENT,

Line 1090: RAISE FND_API.G_EXC_ERROR;

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;
1091: END IF;
1092:
1093: -- debug message
1094: jty_log(FND_LOG.LEVEL_EVENT,

Line 1166: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1162: p_mode => p_mode,
1163: x_Return_Status => l_Return_Status);
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');

Line 1172: RAISE FND_API.G_EXC_ERROR;

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;
1173: END IF;
1174:
1175: ELSE
1176: -- debug message

Line 1193: RAISE FND_API.G_EXC_ERROR;

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 */
1197: IF ((p_mode = 'TOTAL') OR (p_mode = 'INCREMENTAL')) THEN

Line 1303: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1307: 'API JTY_TERR_ENGINE_GEN_PVT.gen_rule_engine has failed with FND_API.G_EXC_ERROR 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
1310: RETCODE := 2;
1311: ERRBUF := SQLCODE || ' : ' || SQLERRM;