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.

[Home] [Help]

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.26.12020000.3 2012/09/24 10:32:08 swpoddar ship $ */
3: -- Start of Comments
4: -- ---------------------------------------------------
5: -- PACKAGE NAME: JTY_TERR_ENGINE_GEN_PVT

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

83:
84: BEGIN
85: -- debug message
86: jty_log(FND_LOG.LEVEL_PROCEDURE,
87: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.populate_index_info.start',
88: 'Start of the procedure JTY_TERR_ENGINE_GEN2_PVT.populate_index_info ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
89:
90: IF (p_qual_usg_id_tbl.COUNT > 0) THEN
91:

Line 88: 'Start of the procedure JTY_TERR_ENGINE_GEN2_PVT.populate_index_info ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

84: BEGIN
85: -- debug message
86: jty_log(FND_LOG.LEVEL_PROCEDURE,
87: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.populate_index_info.start',
88: 'Start of the procedure JTY_TERR_ENGINE_GEN2_PVT.populate_index_info ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
89:
90: IF (p_qual_usg_id_tbl.COUNT > 0) THEN
91:
92: SELECT qual_type_usg_id

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

533: END IF; -- IF (p_qual_usg_id_tbl.COUNT > 0)
534:
535: -- debug message
536: jty_log(FND_LOG.LEVEL_PROCEDURE,
537: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.populate_index_info.end',
538: 'End of the procedure JTY_TERR_ENGINE_GEN2_PVT.populate_index_info ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
539:
540: retcode := 0;
541: errbuf := null;

Line 538: 'End of the procedure JTY_TERR_ENGINE_GEN2_PVT.populate_index_info ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

534:
535: -- debug message
536: jty_log(FND_LOG.LEVEL_PROCEDURE,
537: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.populate_index_info.end',
538: 'End of the procedure JTY_TERR_ENGINE_GEN2_PVT.populate_index_info ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
539:
540: retcode := 0;
541: errbuf := null;
542:

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

544: WHEN OTHERS THEN
545: RETCODE := 2;
546: ERRBUF := SQLCODE || ' : ' || SQLERRM;
547: jty_log(FND_LOG.LEVEL_EXCEPTION,
548: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.populate_index_info.others',
549: substr(errbuf, 1, 4000));
550:
551: END populate_index_info;
552:

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

581:
582: BEGIN
583: -- debug message
584: jty_log(FND_LOG.LEVEL_PROCEDURE,
585: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.populate_dea_index_info.start',
586: 'Start of the procedure JTY_TERR_ENGINE_GEN2_PVT.populate_dea_index_info ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
587:
588: IF (p_qual_usg_id_tbl.COUNT > 0) THEN
589:

Line 586: 'Start of the procedure JTY_TERR_ENGINE_GEN2_PVT.populate_dea_index_info ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

582: BEGIN
583: -- debug message
584: jty_log(FND_LOG.LEVEL_PROCEDURE,
585: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.populate_dea_index_info.start',
586: 'Start of the procedure JTY_TERR_ENGINE_GEN2_PVT.populate_dea_index_info ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
587:
588: IF (p_qual_usg_id_tbl.COUNT > 0) THEN
589:
590: SELECT qual_type_usg_id

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

1023: END IF; -- IF (p_qual_usg_id_tbl.COUNT > 0)
1024:
1025: -- debug message
1026: jty_log(FND_LOG.LEVEL_PROCEDURE,
1027: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.populate_dea_index_info.end',
1028: 'End of the procedure JTY_TERR_ENGINE_GEN2_PVT.populate_dea_index_info ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1029:
1030: retcode := 0;
1031: errbuf := null;

Line 1028: 'End of the procedure JTY_TERR_ENGINE_GEN2_PVT.populate_dea_index_info ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

1024:
1025: -- debug message
1026: jty_log(FND_LOG.LEVEL_PROCEDURE,
1027: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.populate_dea_index_info.end',
1028: 'End of the procedure JTY_TERR_ENGINE_GEN2_PVT.populate_dea_index_info ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1029:
1030: retcode := 0;
1031: errbuf := null;
1032:

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

1034: WHEN OTHERS THEN
1035: RETCODE := 2;
1036: ERRBUF := SQLCODE || ' : ' || SQLERRM;
1037: jty_log(FND_LOG.LEVEL_EXCEPTION,
1038: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.populate_dea_index_info.others',
1039: substr(errbuf, 1, 4000));
1040:
1041: END populate_dea_index_info;
1042:

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

1145:
1146: BEGIN
1147: -- debug message
1148: jty_log(FND_LOG.LEVEL_PROCEDURE,
1149: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_terr_rules_recurse.start',
1150: 'Start of the procedure JTY_TERR_ENGINE_GEN2_PVT.gen_terr_rules_recurse ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1151:
1152: l_newline := FND_GLOBAL.Local_Chr(10); /* newline character */
1153:

Line 1150: 'Start of the procedure JTY_TERR_ENGINE_GEN2_PVT.gen_terr_rules_recurse ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

1146: BEGIN
1147: -- debug message
1148: jty_log(FND_LOG.LEVEL_PROCEDURE,
1149: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_terr_rules_recurse.start',
1150: 'Start of the procedure JTY_TERR_ENGINE_GEN2_PVT.gen_terr_rules_recurse ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1151:
1152: l_newline := FND_GLOBAL.Local_Chr(10); /* newline character */
1153:
1154: IF ((p_mode = 'DATE EFFECTIVE') or (p_mode = 'DEA INCREMENTAL')) THEN

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

1188: CLOSE c_terr_qual;
1189:
1190: -- debug message
1191: jty_log(FND_LOG.LEVEL_STATEMENT,
1192: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_terr_rules_recurse.num_qual',
1193: 'Number of qualifiers used by valid territories : ' || l_qual_usg_id_tbl.COUNT);
1194:
1195: /* get all the program name and its corresponding real time trans table for the usage and txn type */
1196: OPEN c_trans_details(p_source_id, p_trans_id);

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

1200: CLOSE c_trans_details;
1201:
1202: -- debug message
1203: jty_log(FND_LOG.LEVEL_STATEMENT,
1204: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_terr_rules_recurse.num_program',
1205: 'Number of programs for the usage and transaction type : ' || l_pgm_name_tbl.COUNT);
1206:
1207: /* generic insert statement */
1208: l_insert_stmt :=

Line 1301: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_terr_rules_recurse loop qualifier - length', length(l_qual_rules));

1297:
1298:
1299: -- debug message
1300: jty_log(FND_LOG.LEVEL_STATEMENT,
1301: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_terr_rules_recurse loop qualifier - length', length(l_qual_rules));
1302:
1303: IF l_qual_usg_id_tbl(j) in ( '-1040','-1041','-1042','-1044','-1048','-1744','-1734','-1096','-1039','-1213', '-1218',
1304: '-1037','-1038','-1043','-1046','-1050','-1051','-1060','-1061','-1095', '-1210', '-1045', '-1206') THEN
1305:

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

1410:
1411: IF (retcode <> 0) THEN
1412: -- debug message
1413: jty_log(FND_LOG.LEVEL_EXCEPTION,
1414: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_terr_rules_recurse.populate_index_info',
1415: 'populate_index_info API has failed');
1416:
1417: RAISE FND_API.G_EXC_ERROR;
1418: END IF;

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

1418: END IF;
1419:
1420: -- debug message
1421: jty_log(FND_LOG.LEVEL_PROCEDURE,
1422: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_terr_rules_recurse.end',
1423: 'End of the procedure JTY_TERR_ENGINE_GEN2_PVT.gen_terr_rules_recurse ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1424:
1425: EXCEPTION
1426: WHEN FND_API.G_EXC_ERROR THEN

Line 1423: 'End of the procedure JTY_TERR_ENGINE_GEN2_PVT.gen_terr_rules_recurse ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

1419:
1420: -- debug message
1421: jty_log(FND_LOG.LEVEL_PROCEDURE,
1422: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_terr_rules_recurse.end',
1423: 'End of the procedure JTY_TERR_ENGINE_GEN2_PVT.gen_terr_rules_recurse ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1424:
1425: EXCEPTION
1426: WHEN FND_API.G_EXC_ERROR THEN
1427: jty_log(FND_LOG.LEVEL_EXCEPTION,

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

1424:
1425: EXCEPTION
1426: WHEN FND_API.G_EXC_ERROR THEN
1427: jty_log(FND_LOG.LEVEL_EXCEPTION,
1428: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_terr_rules_recurse.g_exc_error',
1429: 'API JTY_TERR_ENGINE_GEN2_PVT.gen_terr_rules_recurse has failed with FND_API.G_EXC_ERROR exception');
1430:
1431: WHEN OTHERS THEN
1432: RETCODE := 2;

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

1425: EXCEPTION
1426: WHEN FND_API.G_EXC_ERROR THEN
1427: jty_log(FND_LOG.LEVEL_EXCEPTION,
1428: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_terr_rules_recurse.g_exc_error',
1429: 'API JTY_TERR_ENGINE_GEN2_PVT.gen_terr_rules_recurse has failed with FND_API.G_EXC_ERROR exception');
1430:
1431: WHEN OTHERS THEN
1432: RETCODE := 2;
1433: ERRBUF := SQLCODE || ' : ' || SQLERRM;

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

1431: WHEN OTHERS THEN
1432: RETCODE := 2;
1433: ERRBUF := SQLCODE || ' : ' || SQLERRM;
1434: jty_log(FND_LOG.LEVEL_EXCEPTION,
1435: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_terr_rules_recurse.others',
1436: substr(errbuf, 1, 4000));
1437:
1438: END gen_terr_rules_recurse;
1439:

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

1455:
1456: BEGIN
1457: -- debug message
1458: jty_log(FND_LOG.LEVEL_PROCEDURE,
1459: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_real_time_sql.start',
1460: 'Start of the procedure JTY_TERR_ENGINE_GEN2_PVT.gen_real_time_sql ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1461:
1462: -- debug message
1463: jty_log(FND_LOG.LEVEL_STATEMENT,

Line 1460: 'Start of the procedure JTY_TERR_ENGINE_GEN2_PVT.gen_real_time_sql ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

1456: BEGIN
1457: -- debug message
1458: jty_log(FND_LOG.LEVEL_PROCEDURE,
1459: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_real_time_sql.start',
1460: 'Start of the procedure JTY_TERR_ENGINE_GEN2_PVT.gen_real_time_sql ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1461:
1462: -- debug message
1463: jty_log(FND_LOG.LEVEL_STATEMENT,
1464: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_real_time_sql.parameters',

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

1460: 'Start of the procedure JTY_TERR_ENGINE_GEN2_PVT.gen_real_time_sql ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1461:
1462: -- debug message
1463: jty_log(FND_LOG.LEVEL_STATEMENT,
1464: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_real_time_sql.parameters',
1465: 'p_source_id : ' || p_source_id || ' p_trans_id : ' || p_trans_id || ' p_mode : ' || p_mode ||
1466: ' p_start_date : ' || p_start_date || ' p_end_date : ' || p_end_date);
1467:
1468: /* if mode is date effective consider the territories active between p_start_date and p_end_date */

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

1546: END IF;
1547:
1548: -- debug message
1549: jty_log(FND_LOG.LEVEL_STATEMENT,
1550: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_real_time_sql.num_terr',
1551: 'Number of territories for this usage and transaction type : ' || l_num_of_terr);
1552:
1553: /* territories exist for this USAGE/TRANSACTION TYPE combination */
1554: IF (l_num_of_terr > 0) THEN

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

1565:
1566: IF (retcode <> 0) THEN
1567: -- debug message
1568: jty_log(FND_LOG.LEVEL_EXCEPTION,
1569: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_real_time_sql.gen_terr_rules_recurse',
1570: 'gen_terr_rules_recurse API has failed');
1571:
1572: RAISE FND_API.G_EXC_ERROR;
1573: END IF;

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

1574:
1575: ELSE
1576: -- debug message
1577: jty_log(FND_LOG.LEVEL_EXCEPTION,
1578: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_real_time_sql.no_real_time_sql',
1579: 'No valid territories for this usage and transaction type');
1580:
1581: END IF; /* end if(num_of_terr > 0) */
1582:

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

1581: END IF; /* end if(num_of_terr > 0) */
1582:
1583: -- debug message
1584: jty_log(FND_LOG.LEVEL_PROCEDURE,
1585: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_real_time_sql.end',
1586: 'End of the procedure JTY_TERR_ENGINE_GEN2_PVT.gen_real_time_sql ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1587:
1588: retcode := 0;
1589: errbuf := null;

Line 1586: 'End of the procedure JTY_TERR_ENGINE_GEN2_PVT.gen_real_time_sql ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

1582:
1583: -- debug message
1584: jty_log(FND_LOG.LEVEL_PROCEDURE,
1585: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_real_time_sql.end',
1586: 'End of the procedure JTY_TERR_ENGINE_GEN2_PVT.gen_real_time_sql ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1587:
1588: retcode := 0;
1589: errbuf := null;
1590:

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

1590:
1591: EXCEPTION
1592: WHEN FND_API.G_EXC_ERROR THEN
1593: jty_log(FND_LOG.LEVEL_EXCEPTION,
1594: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_real_time_sql.g_exc_error',
1595: 'API JTY_TERR_ENGINE_GEN2_PVT.gen_real_time_sql has failed with FND_API.G_EXC_ERROR exception');
1596:
1597: WHEN OTHERS THEN
1598: RETCODE := 2;

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

1591: EXCEPTION
1592: WHEN FND_API.G_EXC_ERROR THEN
1593: jty_log(FND_LOG.LEVEL_EXCEPTION,
1594: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_real_time_sql.g_exc_error',
1595: 'API JTY_TERR_ENGINE_GEN2_PVT.gen_real_time_sql has failed with FND_API.G_EXC_ERROR exception');
1596:
1597: WHEN OTHERS THEN
1598: RETCODE := 2;
1599: ERRBUF := SQLCODE || ' : ' || SQLERRM;

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

1597: WHEN OTHERS THEN
1598: RETCODE := 2;
1599: ERRBUF := SQLCODE || ' : ' || SQLERRM;
1600: jty_log(FND_LOG.LEVEL_EXCEPTION,
1601: 'jtf.plsql.JTY_TERR_ENGINE_GEN2_PVT.gen_real_time_sql.others',
1602: substr(errbuf, 1, 4000));
1603:
1604: END gen_real_time_sql;
1605:

Line 1607: END JTY_TERR_ENGINE_GEN2_PVT;

1603:
1604: END gen_real_time_sql;
1605:
1606:
1607: END JTY_TERR_ENGINE_GEN2_PVT;