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 FND_LOG

Line 74: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

70: l_index_name varchar2(30);
71:
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;

Line 75: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

71:
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:

Line 526: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

522:
523: END IF; -- IF (p_qual_usg_id_tbl.COUNT > 0)
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;

Line 527: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

523: END IF; -- IF (p_qual_usg_id_tbl.COUNT > 0)
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:

Line 539: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

535: EXCEPTION
536: WHEN OTHERS THEN
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;

Line 540: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

536: WHEN OTHERS THEN
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;

Line 576: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

572: l_qual_type_usg_id NUMBER;
573:
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;

Line 577: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

573:
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:

Line 1009: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1005:
1006: END IF; -- IF (p_qual_usg_id_tbl.COUNT > 0)
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;

Line 1010: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

1006: END IF; -- IF (p_qual_usg_id_tbl.COUNT > 0)
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:

Line 1022: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1018: EXCEPTION
1019: WHEN OTHERS THEN
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;

Line 1023: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

1019: WHEN OTHERS THEN
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;

Line 1134: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1130: l_newline VARCHAR2(2);
1131:
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;

Line 1135: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

1131:
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:

Line 1179: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1175: ,l_fc_tbl;
1176: CLOSE c_terr_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;

Line 1180: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1176: CLOSE c_terr_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:

Line 1193: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1189: ,l_trans_name_tbl;
1190: CLOSE c_trans_details;
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;

Line 1194: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1190: CLOSE c_trans_details;
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:

Line 1372: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1368: END IF;
1369:
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;

Line 1373: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

1369:
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:

Line 1382: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1378: RAISE FND_API.G_EXC_ERROR;
1379: END IF;
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;

Line 1383: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

1379: END IF;
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:

Line 1390: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1386: END IF;
1387:
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;

Line 1391: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

1387:
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:

Line 1399: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1395:
1396: WHEN OTHERS THEN
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;

Line 1400: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

1396: WHEN OTHERS THEN
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;

Line 1424: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1420: l_end_date DATE;
1421:
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;

Line 1425: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

1421:
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:

Line 1431: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

Line 1432: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1428: END IF;
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;

Line 1516: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1512: AND rownum < 2;
1513: END IF;
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;

Line 1517: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1513: END IF;
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:

Line 1537: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1533: retcode => retcode);
1534:
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;

Line 1538: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

1534:
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:

Line 1548: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1544: END IF;
1545:
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;

Line 1549: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

1545:
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:

Line 1557: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1553:
1554: END IF; /* end if(num_of_terr > 0) */
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;

Line 1558: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

1554: END IF; /* end if(num_of_terr > 0) */
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:

Line 1568: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1564: errbuf := null;
1565:
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;

Line 1569: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

1565:
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:

Line 1577: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1573:
1574: WHEN OTHERS THEN
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;

Line 1578: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

1574: WHEN OTHERS THEN
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;