APPS.JTY_TERR_ENGINE_GEN_PVT dependencies on FND_API

Line 422: RAISE FND_API.G_EXC_ERROR;

418: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_matching_sql.gen_real_time_sql',
419: 'JTY_TERR_ENGINE_GEN2_PVT.gen_real_time_sql API has failed');
420: END IF;
421:
422: RAISE FND_API.G_EXC_ERROR;
423: END IF;
424:
425:
426: /* delete the old records from the tables jtf_tae_qual_products, jtf_tae_qual_factors */

Line 448: RAISE FND_API.G_EXC_ERROR;

444: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_matching_sql.delete_combinations',
445: 'JTY_TAE_CONTROL_PVT.delete_combinations API has failed');
446: END IF;
447:
448: RAISE FND_API.G_EXC_ERROR;
449: END IF;
450:
451: /* if mode is total or date effective, get all the qualifier combinations for the active territories */
452: /* if mode is incremental, get all the distinct qualifier comb for the territories with */

Line 535: RAISE FND_API.G_EXC_ERROR;

531: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_matching_sql.gen_batch_sql',
532: 'jty_tae_gen_pvt.gen_batch_sql API has failed');
533: END IF;
534:
535: RAISE FND_API.G_EXC_ERROR;
536: END IF;
537:
538: END IF; /* end IF (l_qual_prd_tbl.COUNT > 0) */
539:

Line 556: WHEN FND_API.G_EXC_ERROR THEN

552: retcode := 0;
553: errbuf := null;
554:
555: EXCEPTION
556: WHEN FND_API.G_EXC_ERROR THEN
557: RETCODE := 2;
558: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
559: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
560: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_matching_sql.g_exc_error',

Line 561: 'API JTY_TERR_ENGINE_GEN_PVT.gen_matching_sql has failed with FND_API.G_EXC_ERROR exception');

557: RETCODE := 2;
558: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
559: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
560: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_matching_sql.g_exc_error',
561: 'API JTY_TERR_ENGINE_GEN_PVT.gen_matching_sql has failed with FND_API.G_EXC_ERROR exception');
562: END IF;
563:
564: WHEN OTHERS THEN
565: RETCODE := 2;

Line 703: RAISE FND_API.G_EXC_ERROR;

699: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_rule_engine.check_total_mode',
700: errbuf);
701: END IF;
702:
703: RAISE FND_API.G_EXC_ERROR;
704: END IF;
705: EXCEPTION
706: WHEN OTHERS THEN
707: RAISE;

Line 725: RAISE FND_API.G_EXC_ERROR;

721: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_rule_engine.get_terr_for_incr_star',
722: 'get_terr_for_incr_star API has failed');
723: END IF;
724:
725: RAISE FND_API.G_EXC_ERROR;
726: END IF;
727:
728: ELSE
729: IF (p_mode = 'TOTAL') THEN

Line 779: RAISE FND_API.G_EXC_ERROR;

775: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_rule_engine.process_attr_and_rank',
776: 'process_attr_and_rank API has failed');
777: END IF;
778:
779: RAISE FND_API.G_EXC_ERROR;
780: END IF;
781:
782: -- debug message
783: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 810: RAISE FND_API.G_EXC_ERROR;

806: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_rule_engine.gen_matching_sql',
807: 'gen_matching_sql API has failed');
808: END IF;
809:
810: RAISE FND_API.G_EXC_ERROR;
811: END IF;
812:
813: -- debug message
814: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

884: p_mode => p_mode,
885: x_Return_Status => l_Return_Status);
886: END IF;
887:
888: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
889: -- debug message
890: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
891: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
892: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_rule_engine.CREATE_DNMVAL_INDEX',

Line 896: RAISE FND_API.G_EXC_ERROR;

892: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_rule_engine.CREATE_DNMVAL_INDEX',
893: 'JTY_TERR_DENORM_RULES_PVT.CREATE_DNMVAL_INDEX API has failed');
894: END IF;
895:
896: RAISE FND_API.G_EXC_ERROR;
897: END IF;
898:
899: ELSE
900: -- debug message

Line 1007: WHEN FND_API.G_EXC_ERROR THEN

1003: 'End of the procedure JTY_TERR_ENGINE_GEN_PVT.gen_rule_engine');
1004: END IF;
1005:
1006: EXCEPTION
1007: WHEN FND_API.G_EXC_ERROR THEN
1008: RETCODE := 2;
1009: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1010: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1011: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_rule_engine.g_exc_error',

Line 1012: 'API JTY_TERR_ENGINE_GEN_PVT.gen_rule_engine has failed with FND_API.G_EXC_ERROR exception');

1008: RETCODE := 2;
1009: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1010: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1011: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_rule_engine.g_exc_error',
1012: 'API JTY_TERR_ENGINE_GEN_PVT.gen_rule_engine has failed with FND_API.G_EXC_ERROR exception');
1013: END IF;
1014:
1015: WHEN OTHERS THEN
1016: RETCODE := 2;