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 JTY_TERR_ENGINE_GEN_PVT

Line 1: Package Body JTY_TERR_ENGINE_GEN_PVT AS

1: Package Body JTY_TERR_ENGINE_GEN_PVT AS
2: /* $Header: jtfytegb.pls 120.9.12010000.4 2008/11/04 10:07:48 vpalle ship $ */
3: -- Start of Comments
4: -- ---------------------------------------------------
5: -- PACKAGE NAME: JTY_TERR_ENGINE_GEN_PVT

Line 5: -- PACKAGE NAME: JTY_TERR_ENGINE_GEN_PVT

1: Package Body JTY_TERR_ENGINE_GEN_PVT AS
2: /* $Header: jtfytegb.pls 120.9.12010000.4 2008/11/04 10:07:48 vpalle ship $ */
3: -- Start of Comments
4: -- ---------------------------------------------------
5: -- PACKAGE NAME: JTY_TERR_ENGINE_GEN_PVT
6: -- ---------------------------------------------------
7: -- PURPOSE
8: -- This package is used to generate the complete territory
9: -- Engine based on tha data setup in the JTF territory tables

Line 97: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.get_terr_for_incr_star.start',

93:
94: -- debug message
95: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
96: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
97: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.get_terr_for_incr_star.start',
98: 'Start of the procedure JTY_TERR_ENGINE_GEN_PVT.get_terr_for_incr_star');
99: END IF;
100:
101: /* Insert into jty_changed_terrs the territories that */

Line 98: 'Start of the procedure JTY_TERR_ENGINE_GEN_PVT.get_terr_for_incr_star');

94: -- debug message
95: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
96: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
97: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.get_terr_for_incr_star.start',
98: 'Start of the procedure JTY_TERR_ENGINE_GEN_PVT.get_terr_for_incr_star');
99: END IF;
100:
101: /* Insert into jty_changed_terrs the territories that */
102: /* have become active after the last run of STAR */

Line 308: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.get_terr_for_incr_star.end',

304:
305: -- debug message
306: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
307: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
308: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.get_terr_for_incr_star.end',
309: 'End of the procedure JTY_TERR_ENGINE_GEN_PVT.get_terr_for_incr_star');
310: END IF;
311:
312: retcode := 0;

Line 309: 'End of the procedure JTY_TERR_ENGINE_GEN_PVT.get_terr_for_incr_star');

305: -- debug message
306: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
307: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
308: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.get_terr_for_incr_star.end',
309: 'End of the procedure JTY_TERR_ENGINE_GEN_PVT.get_terr_for_incr_star');
310: END IF;
311:
312: retcode := 0;
313: errbuf := null;

Line 321: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.get_terr_for_incr_star.others',

317: RETCODE := 2;
318: ERRBUF := SQLCODE || ' : ' || SQLERRM;
319: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
320: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
321: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.get_terr_for_incr_star.others',
322: substr(errbuf, 1, 4000));
323: END IF;
324: END get_terr_for_incr_star;
325:

Line 389: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_matching_sql.start',

385:
386: -- debug message
387: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
388: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
389: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_matching_sql.start',
390: 'Start of the procedure JTY_TERR_ENGINE_GEN_PVT.gen_matching_sql');
391: END IF;
392:
393: l_sysdate := SYSDATE;

Line 390: 'Start of the procedure JTY_TERR_ENGINE_GEN_PVT.gen_matching_sql');

386: -- debug message
387: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
388: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
389: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_matching_sql.start',
390: 'Start of the procedure JTY_TERR_ENGINE_GEN_PVT.gen_matching_sql');
391: END IF;
392:
393: l_sysdate := SYSDATE;
394: l_qual_prd_tbl := qual_prd_tbl_type();

Line 418: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_matching_sql.gen_real_time_sql',

414: IF (retcode <> 0) THEN
415: -- debug message
416: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
417: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
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;

Line 444: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_matching_sql.delete_combinations',

440: IF (retcode <> 0) THEN
441: -- debug message
442: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
443: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
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;

Line 531: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_matching_sql.gen_batch_sql',

527: IF (retcode <> 0) THEN
528: -- debug message
529: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
530: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
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;

Line 548: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_matching_sql.end',

544:
545: -- debug message
546: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
547: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
548: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_matching_sql.end',
549: 'End of the procedure JTY_TERR_ENGINE_GEN_PVT.gen_matching_sql');
550: END IF;
551:
552: retcode := 0;

Line 549: 'End of the procedure JTY_TERR_ENGINE_GEN_PVT.gen_matching_sql');

545: -- debug message
546: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
547: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
548: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_matching_sql.end',
549: 'End of the procedure JTY_TERR_ENGINE_GEN_PVT.gen_matching_sql');
550: END IF;
551:
552: retcode := 0;
553: errbuf := null;

Line 560: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_matching_sql.g_exc_error',

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

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 569: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_matching_sql.others',

565: RETCODE := 2;
566: ERRBUF := SQLCODE || ' : ' || SQLERRM;
567: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
568: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
569: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_matching_sql.others',
570: substr(errbuf, 1, 4000));
571: END IF;
572: END gen_matching_sql;
573:

Line 647: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_rule_engine.start',

643:
644: -- debug message
645: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
646: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
647: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_rule_engine.start',
648: 'Start of the procedure JTY_TERR_ENGINE_GEN_PVT.gen_rule_engine');
649: END IF;
650:
651: /* Initialize audit columns */

Line 648: 'Start of the procedure JTY_TERR_ENGINE_GEN_PVT.gen_rule_engine');

644: -- debug message
645: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
646: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
647: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_rule_engine.start',
648: 'Start of the procedure JTY_TERR_ENGINE_GEN_PVT.gen_rule_engine');
649: END IF;
650:
651: /* Initialize audit columns */
652: l_start_date := SYSDATE;

Line 675: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_rule_engine.param_values',

671:
672: -- debug message
673: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
674: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
675: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_rule_engine.param_values',
676: 'Source : ' || p_source_id || ' Mode : ' || p_mode || ' Start Date : ' || p_start_date ||
677: ' End Date : ' || p_end_date);
678: END IF;
679:

Line 699: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_rule_engine.check_total_mode',

695: retcode := 2;
696: errbuf := 'STAR should be run at least once in TOTAL mode before INCREMENTAL mode';
697: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
698: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
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;

Line 721: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_rule_engine.get_terr_for_incr_star',

717: IF (retcode <> 0) THEN
718: -- debug message
719: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
720: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
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;

Line 758: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_rule_engine.no_of_terr',

754:
755: -- debug message
756: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
757: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
758: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_rule_engine.no_of_terr',
759: 'Number of territories to be processed : ' || l_no_of_records);
760: END IF;
761:
762: IF (l_no_of_records > 0) THEN

Line 775: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_rule_engine.process_attr_and_rank',

771: IF (retcode <> 0) THEN
772: -- debug message
773: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
774: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
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;

Line 785: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_rule_engine.process_attr_and_rank',

781:
782: -- debug message
783: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
784: FND_LOG.string(FND_LOG.LEVEL_EVENT,
785: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_rule_engine.process_attr_and_rank',
786: 'process_attr_and_rank API has completed with success');
787: END IF;
788:
789: /* Generate real time and batch matching SQLs */

Line 806: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_rule_engine.gen_matching_sql',

802: IF (retcode <> 0) THEN
803: -- debug message
804: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
805: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
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;

Line 816: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_rule_engine.gen_matching_sql',

812:
813: -- debug message
814: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
815: FND_LOG.string(FND_LOG.LEVEL_EVENT,
816: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_rule_engine.gen_matching_sql',
817: 'gen_matching_sql API has completed with success');
818: END IF;
819:
820: /* PERSON_ID required for OSO TAP */

Line 892: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_rule_engine.CREATE_DNMVAL_INDEX',

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',
893: 'JTY_TERR_DENORM_RULES_PVT.CREATE_DNMVAL_INDEX API has failed');
894: END IF;
895:
896: RAISE FND_API.G_EXC_ERROR;

Line 903: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_rule_engine.no_of_terr',

899: ELSE
900: -- debug message
901: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
902: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
903: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_rule_engine.no_of_terr',
904: 'No territories processed');
905: END IF;
906:
907: END IF; /* IF (l_no_of_records > 0) */

Line 1002: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_rule_engine.end',

998:
999: -- debug message
1000: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1001: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1002: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_rule_engine.end',
1003: 'End of the procedure JTY_TERR_ENGINE_GEN_PVT.gen_rule_engine');
1004: END IF;
1005:
1006: EXCEPTION

Line 1003: 'End of the procedure JTY_TERR_ENGINE_GEN_PVT.gen_rule_engine');

999: -- debug message
1000: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1001: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1002: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_rule_engine.end',
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

Line 1011: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_rule_engine.g_exc_error',

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

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;

Line 1020: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_rule_engine.others',

1016: RETCODE := 2;
1017: ERRBUF := SQLCODE || ' : ' || SQLERRM;
1018: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1019: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1020: 'jtf.plsql.JTY_TERR_ENGINE_GEN_PVT.gen_rule_engine.others',
1021: substr(errbuf, 1, 4000));
1022: END IF;
1023: END gen_rule_engine;
1024:

Line 1025: END JTY_TERR_ENGINE_GEN_PVT;

1021: substr(errbuf, 1, 4000));
1022: END IF;
1023: END gen_rule_engine;
1024:
1025: END JTY_TERR_ENGINE_GEN_PVT;