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 JTY_TERR_ENGINE_GEN2_PVT

Line 1: Package Body JTY_TERR_ENGINE_GEN2_PVT AS

1: Package Body JTY_TERR_ENGINE_GEN2_PVT AS
2: /* $Header: jtfytseb.pls 120.5.12010000.4 2008/11/04 06:09:45 vpalle ship $ */
3: -- Start of Comments
4: -- ---------------------------------------------------
5: -- PACKAGE NAME: JTY_TERR_ENGINE_GEN_PVT

Line 76: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.populate_index_info.start',

72: BEGIN
73: -- debug message
74: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
75: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
76: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.populate_index_info.start',
77: 'Start of the procedure JTY_TERR_ENGINE_GEN2_PVT.populate_index_info');
78: END IF;
79:
80: IF (p_qual_usg_id_tbl.COUNT > 0) THEN

Line 77: 'Start of the procedure JTY_TERR_ENGINE_GEN2_PVT.populate_index_info');

73: -- debug message
74: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
75: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
76: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.populate_index_info.start',
77: 'Start of the procedure JTY_TERR_ENGINE_GEN2_PVT.populate_index_info');
78: END IF;
79:
80: IF (p_qual_usg_id_tbl.COUNT > 0) THEN
81:

Line 528: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.populate_index_info.end',

524:
525: -- debug message
526: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
527: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
528: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.populate_index_info.end',
529: 'End of the procedure JTY_TERR_ENGINE_GEN2_PVT.populate_index_info');
530: END IF;
531:
532: retcode := 0;

Line 529: 'End of the procedure JTY_TERR_ENGINE_GEN2_PVT.populate_index_info');

525: -- debug message
526: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
527: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
528: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.populate_index_info.end',
529: 'End of the procedure JTY_TERR_ENGINE_GEN2_PVT.populate_index_info');
530: END IF;
531:
532: retcode := 0;
533: errbuf := null;

Line 541: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.populate_index_info.others',

537: RETCODE := 2;
538: ERRBUF := SQLCODE || ' : ' || SQLERRM;
539: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
540: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
541: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.populate_index_info.others',
542: substr(errbuf, 1, 4000));
543: END IF;
544: END populate_index_info;
545:

Line 578: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.populate_dea_index_info.start',

574: BEGIN
575: -- debug message
576: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
577: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
578: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.populate_dea_index_info.start',
579: 'Start of the procedure JTY_TERR_ENGINE_GEN2_PVT.populate_dea_index_info');
580: END IF;
581:
582: IF (p_qual_usg_id_tbl.COUNT > 0) THEN

Line 579: 'Start of the procedure JTY_TERR_ENGINE_GEN2_PVT.populate_dea_index_info');

575: -- debug message
576: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
577: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
578: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.populate_dea_index_info.start',
579: 'Start of the procedure JTY_TERR_ENGINE_GEN2_PVT.populate_dea_index_info');
580: END IF;
581:
582: IF (p_qual_usg_id_tbl.COUNT > 0) THEN
583:

Line 1011: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.populate_dea_index_info.end',

1007:
1008: -- debug message
1009: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1010: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1011: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.populate_dea_index_info.end',
1012: 'End of the procedure JTY_TERR_ENGINE_GEN2_PVT.populate_dea_index_info');
1013: END IF;
1014:
1015: retcode := 0;

Line 1012: 'End of the procedure JTY_TERR_ENGINE_GEN2_PVT.populate_dea_index_info');

1008: -- debug message
1009: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1010: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1011: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.populate_dea_index_info.end',
1012: 'End of the procedure JTY_TERR_ENGINE_GEN2_PVT.populate_dea_index_info');
1013: END IF;
1014:
1015: retcode := 0;
1016: errbuf := null;

Line 1024: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.populate_dea_index_info.others',

1020: RETCODE := 2;
1021: ERRBUF := SQLCODE || ' : ' || SQLERRM;
1022: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1023: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1024: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.populate_dea_index_info.others',
1025: substr(errbuf, 1, 4000));
1026: END IF;
1027: END populate_dea_index_info;
1028:

Line 1136: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_terr_rules_recurse.start',

1132: BEGIN
1133: -- debug message
1134: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1135: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1136: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_terr_rules_recurse.start',
1137: 'Start of the procedure JTY_TERR_ENGINE_GEN2_PVT.gen_terr_rules_recurse');
1138: END IF;
1139:
1140: l_newline := FND_GLOBAL.Local_Chr(10); /* newline character */

Line 1137: 'Start of the procedure JTY_TERR_ENGINE_GEN2_PVT.gen_terr_rules_recurse');

1133: -- debug message
1134: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1135: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1136: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_terr_rules_recurse.start',
1137: 'Start of the procedure JTY_TERR_ENGINE_GEN2_PVT.gen_terr_rules_recurse');
1138: END IF;
1139:
1140: l_newline := FND_GLOBAL.Local_Chr(10); /* newline character */
1141:

Line 1181: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_terr_rules_recurse.num_qual',

1177:
1178: -- debug message
1179: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1180: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1181: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_terr_rules_recurse.num_qual',
1182: 'Number of qualifiers used by valid territories : ' || l_qual_usg_id_tbl.COUNT);
1183: END IF;
1184:
1185: /* get all the program name and its corresponding real time trans table for the usage and txn type */

Line 1195: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_terr_rules_recurse.num_program',

1191:
1192: -- debug message
1193: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1194: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1195: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_terr_rules_recurse.num_program',
1196: 'Number of programs for the usage and transaction type : ' || l_pgm_name_tbl.COUNT);
1197: END IF;
1198:
1199: /* generic insert statement */

Line 1374: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_terr_rules_recurse.populate_index_info',

1370: IF (retcode <> 0) THEN
1371: -- debug message
1372: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1373: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1374: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_terr_rules_recurse.populate_index_info',
1375: 'populate_index_info API has failed');
1376: END IF;
1377:
1378: RAISE FND_API.G_EXC_ERROR;

Line 1384: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_terr_rules_recurse.end',

1380:
1381: -- debug message
1382: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1383: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1384: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_terr_rules_recurse.end',
1385: 'End of the procedure JTY_TERR_ENGINE_GEN2_PVT.gen_terr_rules_recurse');
1386: END IF;
1387:
1388: EXCEPTION

Line 1385: 'End of the procedure JTY_TERR_ENGINE_GEN2_PVT.gen_terr_rules_recurse');

1381: -- debug message
1382: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1383: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1384: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_terr_rules_recurse.end',
1385: 'End of the procedure JTY_TERR_ENGINE_GEN2_PVT.gen_terr_rules_recurse');
1386: END IF;
1387:
1388: EXCEPTION
1389: WHEN FND_API.G_EXC_ERROR THEN

Line 1392: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_terr_rules_recurse.g_exc_error',

1388: EXCEPTION
1389: WHEN FND_API.G_EXC_ERROR THEN
1390: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1391: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1392: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_terr_rules_recurse.g_exc_error',
1393: 'API JTY_TERR_ENGINE_GEN2_PVT.gen_terr_rules_recurse has failed with FND_API.G_EXC_ERROR exception');
1394: END IF;
1395:
1396: WHEN OTHERS THEN

Line 1393: 'API JTY_TERR_ENGINE_GEN2_PVT.gen_terr_rules_recurse has failed with FND_API.G_EXC_ERROR exception');

1389: WHEN FND_API.G_EXC_ERROR THEN
1390: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1391: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1392: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_terr_rules_recurse.g_exc_error',
1393: 'API JTY_TERR_ENGINE_GEN2_PVT.gen_terr_rules_recurse has failed with FND_API.G_EXC_ERROR exception');
1394: END IF;
1395:
1396: WHEN OTHERS THEN
1397: RETCODE := 2;

Line 1401: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_terr_rules_recurse.others',

1397: RETCODE := 2;
1398: ERRBUF := SQLCODE || ' : ' || SQLERRM;
1399: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1400: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1401: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_terr_rules_recurse.others',
1402: substr(errbuf, 1, 4000));
1403: END IF;
1404: END gen_terr_rules_recurse;
1405:

Line 1426: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_real_time_sql.start',

1422: BEGIN
1423: -- debug message
1424: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1425: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1426: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_real_time_sql.start',
1427: 'Start of the procedure JTY_TERR_ENGINE_GEN2_PVT.gen_real_time_sql');
1428: END IF;
1429:
1430: -- debug message

Line 1427: 'Start of the procedure JTY_TERR_ENGINE_GEN2_PVT.gen_real_time_sql');

1423: -- debug message
1424: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1425: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1426: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_real_time_sql.start',
1427: 'Start of the procedure JTY_TERR_ENGINE_GEN2_PVT.gen_real_time_sql');
1428: END IF;
1429:
1430: -- debug message
1431: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1433: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_real_time_sql.parameters',

1429:
1430: -- debug message
1431: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1432: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1433: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_real_time_sql.parameters',
1434: 'p_source_id : ' || p_source_id || ' p_trans_id : ' || p_trans_id || ' p_mode : ' || p_mode ||
1435: ' p_start_date : ' || p_start_date || ' p_end_date : ' || p_end_date);
1436: END IF;
1437:

Line 1518: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_real_time_sql.num_terr',

1514:
1515: -- debug message
1516: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1517: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1518: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_real_time_sql.num_terr',
1519: 'Number of territories for this usage and transaction type : ' || l_num_of_terr);
1520: END IF;
1521:
1522: /* territories exist for this USAGE/TRANSACTION TYPE combination */

Line 1539: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_real_time_sql.gen_terr_rules_recurse',

1535: IF (retcode <> 0) THEN
1536: -- debug message
1537: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1538: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1539: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_real_time_sql.gen_terr_rules_recurse',
1540: 'gen_terr_rules_recurse API has failed');
1541: END IF;
1542:
1543: RAISE FND_API.G_EXC_ERROR;

Line 1550: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_real_time_sql.no_real_time_sql',

1546: ELSE
1547: -- debug message
1548: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1549: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1550: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_real_time_sql.no_real_time_sql',
1551: 'No valid territories for this usage and transaction type');
1552: END IF;
1553:
1554: END IF; /* end if(num_of_terr > 0) */

Line 1559: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_real_time_sql.end',

1555:
1556: -- debug message
1557: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1558: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1559: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_real_time_sql.end',
1560: 'End of the procedure JTY_TERR_ENGINE_GEN2_PVT.gen_real_time_sql');
1561: END IF;
1562:
1563: retcode := 0;

Line 1560: 'End of the procedure JTY_TERR_ENGINE_GEN2_PVT.gen_real_time_sql');

1556: -- debug message
1557: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1558: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1559: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_real_time_sql.end',
1560: 'End of the procedure JTY_TERR_ENGINE_GEN2_PVT.gen_real_time_sql');
1561: END IF;
1562:
1563: retcode := 0;
1564: errbuf := null;

Line 1570: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_real_time_sql.g_exc_error',

1566: EXCEPTION
1567: WHEN FND_API.G_EXC_ERROR THEN
1568: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1569: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1570: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_real_time_sql.g_exc_error',
1571: 'API JTY_TERR_ENGINE_GEN2_PVT.gen_real_time_sql has failed with FND_API.G_EXC_ERROR exception');
1572: END IF;
1573:
1574: WHEN OTHERS THEN

Line 1571: 'API JTY_TERR_ENGINE_GEN2_PVT.gen_real_time_sql has failed with FND_API.G_EXC_ERROR exception');

1567: WHEN FND_API.G_EXC_ERROR THEN
1568: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1569: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1570: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_real_time_sql.g_exc_error',
1571: 'API JTY_TERR_ENGINE_GEN2_PVT.gen_real_time_sql has failed with FND_API.G_EXC_ERROR exception');
1572: END IF;
1573:
1574: WHEN OTHERS THEN
1575: RETCODE := 2;

Line 1579: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_real_time_sql.others',

1575: RETCODE := 2;
1576: ERRBUF := SQLCODE || ' : ' || SQLERRM;
1577: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1578: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1579: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_real_time_sql.others',
1580: substr(errbuf, 1, 4000));
1581: END IF;
1582: END gen_real_time_sql;
1583:

Line 1584: END JTY_TERR_ENGINE_GEN2_PVT;

1580: substr(errbuf, 1, 4000));
1581: END IF;
1582: END gen_real_time_sql;
1583:
1584: END JTY_TERR_ENGINE_GEN2_PVT;