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_DENORM_RULES_PVT dependencies on FND_LOG

Line 41: IF (p_log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

37: ,p_message IN VARCHAR2)
38: IS
39: pragma autonomous_transaction;
40: BEGIN
41: IF (p_log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
42: FND_LOG.string(p_log_level, p_module, p_message);
43: commit;
44: END IF;
45: END;

Line 42: FND_LOG.string(p_log_level, p_module, p_message);

38: IS
39: pragma autonomous_transaction;
40: BEGIN
41: IF (p_log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
42: FND_LOG.string(p_log_level, p_module, p_message);
43: commit;
44: END IF;
45: END;
46:

Line 125: jty_log(FND_LOG.LEVEL_PROCEDURE,

121: AND B.owner = cl_owner;
122:
123: BEGIN
124: -- debug message
125: jty_log(FND_LOG.LEVEL_PROCEDURE,
126: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.begin',
127: 'Start of the procedure jty_terr_denorm_rules_pvt.create_dnmval_index ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
128:
129: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 160: jty_log(FND_LOG.LEVEL_EXCEPTION,

156: p_source_id => p_source_id,
157: x_return_status => x_return_status);
158:
159: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
160: jty_log(FND_LOG.LEVEL_EXCEPTION,
161: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.selectivity',
162: 'API jty_tae_index_creation_pvt.SELECTIVITY has failed');
163: RAISE FND_API.G_EXC_ERROR;
164: END IF;

Line 180: jty_log(FND_LOG.LEVEL_EXCEPTION,

176: x_Return_Status => x_return_status );
177: END IF;
178:
179: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
180: jty_log(FND_LOG.LEVEL_EXCEPTION,
181: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.reduce_dnmval_idx_set',
182: 'API JTY_TAE_CONTROL_PVT.reduce_dnmval_idx_set has failed');
183: RAISE FND_API.G_EXC_ERROR;
184: END IF;

Line 194: jty_log(FND_LOG.LEVEL_STATEMENT,

190: WHERE v.name = 'parallel_max_servers'
191: OR v.name = 'cpu_count';
192:
193: -- debug message
194: jty_log(FND_LOG.LEVEL_STATEMENT,
195: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.l_dop',
196: 'Default degree of parallelism : ' || l_dop);
197:
198: /* get tablespace information */

Line 207: jty_log(FND_LOG.LEVEL_STATEMENT,

203: AND a.application_id = i.application_id
204: AND u.oracle_id = i.oracle_id;
205:
206: -- debug message
207: jty_log(FND_LOG.LEVEL_STATEMENT,
208: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.tablespace',
209: 'Table tablespace : ' || l_table_tablespace || ' Index tablespace : ' || l_idx_tablespace ||
210: ' Schema Name : ' || l_ora_username);
211:

Line 253: jty_log(FND_LOG.LEVEL_STATEMENT,

249: /* Append Storage Parameter Information to Index Definition */
250: v_statement := v_statement || s_statement;
251:
252: -- debug message
253: jty_log(FND_LOG.LEVEL_STATEMENT,
254: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.index_creation',
255: 'Index created with the statement : ' || v_statement);
256: DECLARE --Bug 7645026
257: duplicate_index EXCEPTION;

Line 324: jty_log(FND_LOG.LEVEL_STATEMENT,

320: /* Append Storage Parameter Information to Index Definition */
321: v_statement := v_statement || s_statement;
322:
323: -- debug message
324: jty_log(FND_LOG.LEVEL_STATEMENT,
325: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.index_creation dea incr',
326: 'Index created with the statement : ' || v_statement);
327: DECLARE --Bug 7645026
328: duplicate_index EXCEPTION;

Line 342: jty_log(FND_LOG.LEVEL_STATEMENT,

338: UPDATE jty_dea_values_idx_header
339: SET BUILD_INDEX_FLAG = 'N'
340: WHERE dea_values_idx_header_id = prd.dea_values_idx_header_id;
341: WHEN index_exists THEN
342: jty_log(FND_LOG.LEVEL_STATEMENT,
343: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.index_creation dea incr',
344: 'Index '|| prd.index_name ||'already exists and not created again');
345:
346: END;

Line 379: jty_log(FND_LOG.LEVEL_PROCEDURE,

375: END IF;
376: END IF; /* end IF ((p_mode = 'TOTAL') OR (p_mode = 'INCREMENTAL')) */
377:
378: -- debug message
379: jty_log(FND_LOG.LEVEL_PROCEDURE,
380: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.end',
381: 'End of the procedure jty_terr_denorm_rules_pvt.create_dnmval_index ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
382:
383: EXCEPTION

Line 386: jty_log(FND_LOG.LEVEL_EXCEPTION,

382:
383: EXCEPTION
384: WHEN NO_DATA_FOUND THEN
385: x_return_status := FND_API.G_RET_STS_ERROR ;
386: jty_log(FND_LOG.LEVEL_EXCEPTION,
387: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.no_data_found',
388: 'API jty_terr_denorm_rules_pvt.create_dnmval_index has failed with no_data_found');
389:
390: WHEN FND_API.G_EXC_ERROR THEN

Line 392: jty_log(FND_LOG.LEVEL_EXCEPTION,

388: 'API jty_terr_denorm_rules_pvt.create_dnmval_index has failed with no_data_found');
389:
390: WHEN FND_API.G_EXC_ERROR THEN
391: x_return_status := FND_API.G_RET_STS_ERROR ;
392: jty_log(FND_LOG.LEVEL_EXCEPTION,
393: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.g_exc_error',
394: 'jty_terr_denorm_rules_pvt.create_dnmval_index has failed with G_EXC_ERROR exception');
395:
396: WHEN OTHERS THEN

Line 398: jty_log(FND_LOG.LEVEL_EXCEPTION,

394: 'jty_terr_denorm_rules_pvt.create_dnmval_index has failed with G_EXC_ERROR exception');
395:
396: WHEN OTHERS THEN
397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
398: jty_log(FND_LOG.LEVEL_EXCEPTION,
399: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.others',
400: substr(SQLCODE || ' : ' || SQLERRM, 1, 4000));
401:
402: END CREATE_DNMVAL_INDEX;

Line 454: jty_log(FND_LOG.LEVEL_PROCEDURE,

450:
451: l_no_of_records NUMBER;
452: BEGIN
453: -- debug message
454: jty_log(FND_LOG.LEVEL_PROCEDURE,
455: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.update_denorm_table.start',
456: 'Start of the procedure JTY_TERR_DENORM_RULES_PVT.update_denorm_table ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
457:
458: l_no_of_records := p_terr_id_tbl.COUNT;

Line 519: jty_log(FND_LOG.LEVEL_STATEMENT,

515: -- , (SELECT absolute_rank from jtf_terr_all where terr_id = p_terr_id_tbl(i))
516: );
517:
518: -- debug message
519: jty_log(FND_LOG.LEVEL_STATEMENT,
520: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.update_denorm_table.num_rows_inserted',
521: 'Number of records inserted into jtf_terr_denorm_rules_all : ' || l_no_of_records);
522: ELSIF (p_mode = 'DEA INCREMENTAL') THEN
523: /* if mode is date effective incremental , insert the denormalized */

Line 576: jty_log(FND_LOG.LEVEL_STATEMENT,

572: -- , (SELECT absolute_rank from jtf_terr_all where terr_id = p_terr_id_tbl(i))
573: );
574:
575: -- debug message
576: jty_log(FND_LOG.LEVEL_STATEMENT,
577: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.update_denorm_table.num_rows_inserted',
578: 'Number of records inserted into jty_denorm_dea_rules_all : ' || l_no_of_records);
579:
580: ELSE

Line 634: jty_log(FND_LOG.LEVEL_STATEMENT,

630: -- , (SELECT absolute_rank from jtf_terr_all where terr_id = p_terr_id_tbl(i))
631: );
632:
633: -- debug message
634: jty_log(FND_LOG.LEVEL_STATEMENT,
635: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.update_denorm_table.num_rows_inserted',
636: 'Number of records inserted into jty_denorm_dea_rules_all : ' || l_no_of_records);
637:
638: END IF; /* end IF (p_mode IN ('TOTAL', 'INCREMENTAL')) */

Line 643: jty_log(FND_LOG.LEVEL_PROCEDURE,

639:
640: END IF; /* end IF (l_no_of_records > 0) */
641:
642: -- debug message
643: jty_log(FND_LOG.LEVEL_PROCEDURE,
644: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.update_denorm_table.end',
645: 'End of the procedure JTY_TERR_DENORM_RULES_PVT.update_denorm_table ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
646:
647: retcode := 0;

Line 654: jty_log(FND_LOG.LEVEL_EXCEPTION,

650: EXCEPTION
651: WHEN OTHERS THEN
652: RETCODE := 2;
653: ERRBUF := SQLCODE || ' : ' || SQLERRM;
654: jty_log(FND_LOG.LEVEL_EXCEPTION,
655: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.update_denorm_table.others',
656: substr(errbuf, 1, 4000));
657:
658: END update_denorm_table;

Line 671: jty_log(FND_LOG.LEVEL_PROCEDURE,

667:
668: l_no_of_records NUMBER;
669: BEGIN
670: -- debug message
671: jty_log(FND_LOG.LEVEL_PROCEDURE,
672: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.update_relative_rank.start',
673: 'Start of the procedure JTY_TERR_DENORM_RULES_PVT.update_relative_rank ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
674:
675: l_no_of_records := p_terr_id_tbl.COUNT;

Line 702: jty_log(FND_LOG.LEVEL_STATEMENT,

698: NULL;
699: END;
700:
701: -- debug message
702: jty_log(FND_LOG.LEVEL_STATEMENT,
703: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.update_relative_rank.num_rows_updated',
704: 'Number of records updated in jtf_terr_all for relative rank : ' || l_no_of_records);
705:
706: END IF; /* end IF (l_no_of_records > 0) */

Line 709: jty_log(FND_LOG.LEVEL_PROCEDURE,

705:
706: END IF; /* end IF (l_no_of_records > 0) */
707:
708: -- debug message
709: jty_log(FND_LOG.LEVEL_PROCEDURE,
710: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.update_relative_rank.end',
711: 'End of the procedure JTY_TERR_DENORM_RULES_PVT.update_relative_rank ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
712:
713: retcode := 0;

Line 720: jty_log(FND_LOG.LEVEL_EXCEPTION,

716: EXCEPTION
717: WHEN OTHERS THEN
718: RETCODE := 2;
719: ERRBUF := SQLCODE || ' : ' || SQLERRM;
720: jty_log(FND_LOG.LEVEL_EXCEPTION,
721: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.update_relative_rank.others',
722: substr(errbuf, 1, 4000));
723: END update_relative_rank;
724:

Line 737: jty_log(FND_LOG.LEVEL_PROCEDURE,

733: l_dyn_str VARCHAR2(1000);
734: l_no_of_records NUMBER;
735: BEGIN
736: -- debug message
737: jty_log(FND_LOG.LEVEL_PROCEDURE,
738: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.update_absolute_rank.start',
739: 'Start of the procedure JTY_TERR_DENORM_RULES_PVT.update_absolute_rank ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
740:
741: l_no_of_records := p_terr_id_tbl.COUNT;

Line 793: jty_log(FND_LOG.LEVEL_STATEMENT,

789: NULL;
790: END;
791:
792: -- debug message
793: jty_log(FND_LOG.LEVEL_STATEMENT,
794: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.update_absolute_rank.num_rows_updated',
795: 'Number of records updated in jtf_terr_all for absolute rank : ' || l_no_of_records);
796:
797: END IF; /* end IF (l_no_of_records > 0) */

Line 800: jty_log(FND_LOG.LEVEL_PROCEDURE,

796:
797: END IF; /* end IF (l_no_of_records > 0) */
798:
799: -- debug message
800: jty_log(FND_LOG.LEVEL_PROCEDURE,
801: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.update_absolute_rank.end',
802: 'End of the procedure JTY_TERR_DENORM_RULES_PVT.update_absolute_rank ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
803:
804: retcode := 0;

Line 811: jty_log(FND_LOG.LEVEL_EXCEPTION,

807: EXCEPTION
808: WHEN OTHERS THEN
809: RETCODE := 2;
810: ERRBUF := SQLCODE || ' : ' || SQLERRM;
811: jty_log(FND_LOG.LEVEL_EXCEPTION,
812: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.update_absolute_rank.others',
813: substr(errbuf, 1, 4000));
814: END update_absolute_rank;
815:

Line 1181: jty_log(FND_LOG.LEVEL_PROCEDURE,

1177: l_actual_tab_reference NUMBER;
1178:
1179: BEGIN
1180: -- debug message
1181: jty_log(FND_LOG.LEVEL_PROCEDURE,
1182: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_values.start',
1183: 'Start of the procedure JTY_TERR_DENORM_RULES_PVT.process_attr_values ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1184:
1185: /* initialize the pl/sql tables */

Line 1582: jty_log(FND_LOG.LEVEL_STATEMENT,

1578: END LOOP; /* end loop FOR i IN p_terr_change_tab.terr_id.FIRST .. p_terr_change_tab.terr_id.LAST */
1579: END IF; /* end IF (p_terr_change_tab.terr_id.COUNT > 0) */
1580:
1581: -- debug message
1582: jty_log(FND_LOG.LEVEL_STATEMENT,
1583: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_values.denorm_value_gt',
1584: 'Done populating the global temp table with denormalised informations');
1585:
1586: /* Move the denormalized territory qualifier values from global temp table to the actual one */

Line 1637: jty_log(FND_LOG.LEVEL_STATEMENT,

1633: g_new_line || l_indent || ',:8' ||
1634: g_new_line || l_indent || ',:9' ||
1635: g_new_line || l_indent || ' FROM jty_denorm_terr_attr_values_gt) ';
1636:
1637: jty_log(FND_LOG.LEVEL_STATEMENT,
1638: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_values.denorm_value',
1639: 'Start Insert into denormalized table ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1640:
1641: EXECUTE IMMEDIATE l_insert_stmt || l_select_stmt USING

Line 1652: jty_log(FND_LOG.LEVEL_STATEMENT,

1648: ,g_program_appl_id
1649: ,g_program_id
1650: ,g_sysdate;
1651:
1652: jty_log(FND_LOG.LEVEL_STATEMENT,
1653: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_values.denorm_value',
1654: 'End Insert into denormalized table ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1655:
1656: -- debug message

Line 1657: jty_log(FND_LOG.LEVEL_STATEMENT,

1653: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_values.denorm_value',
1654: 'End Insert into denormalized table ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1655:
1656: -- debug message
1657: jty_log(FND_LOG.LEVEL_STATEMENT,
1658: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_values.denorm_value',
1659: 'Number of rows inserted : ' || SQL%ROWCOUNT);
1660:
1661: /* analyze the denorm value table to caluclate the selectivity of the columns */

Line 1672: jty_log(FND_LOG.LEVEL_EXCEPTION,

1668:
1669: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1670: retcode := 2;
1671: errbuf := 'JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX has failed for table ' || l_table_name;
1672: jty_log(FND_LOG.LEVEL_EXCEPTION,
1673: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_values.analyze_table_index',
1674: 'ANALYZE_TABLE_INDEX API has failed');
1675:
1676: RAISE FND_API.G_EXC_ERROR;

Line 1723: jty_log(FND_LOG.LEVEL_STATEMENT,

1719:
1720: END IF; /* end IF (l_qtype_terr_id_tbl.COUNT > 0) */
1721:
1722: -- debug message
1723: jty_log(FND_LOG.LEVEL_STATEMENT,
1724: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_values.update_num_qual',
1725: 'Done updating jtf_terr_qtype_usgs_all with num_qual and qual_relation_product');
1726:
1727: -- debug message

Line 1728: jty_log(FND_LOG.LEVEL_PROCEDURE,

1724: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_values.update_num_qual',
1725: 'Done updating jtf_terr_qtype_usgs_all with num_qual and qual_relation_product');
1726:
1727: -- debug message
1728: jty_log(FND_LOG.LEVEL_PROCEDURE,
1729: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_values.end',
1730: 'End of the procedure JTY_TERR_DENORM_RULES_PVT.process_attr_values ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1731:
1732: retcode := 0;

Line 1737: jty_log(FND_LOG.LEVEL_EXCEPTION,

1733: errbuf := null;
1734:
1735: EXCEPTION
1736: WHEN FND_API.G_EXC_ERROR THEN
1737: jty_log(FND_LOG.LEVEL_EXCEPTION,
1738: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_values.g_exc_error',
1739: 'API JTY_TERR_DENORM_RULES_PVT.process_attr_values has failed with FND_API.G_EXC_ERROR exception');
1740:
1741: WHEN L_SCHEMA_NOTFOUND THEN

Line 1744: jty_log(FND_LOG.LEVEL_EXCEPTION,

1740:
1741: WHEN L_SCHEMA_NOTFOUND THEN
1742: RETCODE := 2;
1743: ERRBUF := 'JTY_TERR_DENORM_RULES_PVT.process_attr_values : SCHEMA NAME NOT FOUND CORRESPONDING TO JTF APPLICATION. ';
1744: jty_log(FND_LOG.LEVEL_EXCEPTION,
1745: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_values.l_schema_notfound',
1746: errbuf);
1747:
1748: WHEN OTHERS THEN

Line 1751: jty_log(FND_LOG.LEVEL_EXCEPTION,

1747:
1748: WHEN OTHERS THEN
1749: RETCODE := 2;
1750: ERRBUF := SQLCODE || ' : ' || SQLERRM;
1751: jty_log(FND_LOG.LEVEL_EXCEPTION,
1752: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_values.others',
1753: substr(errbuf, 1, 4000));
1754:
1755: END process_attr_values;

Line 1804: jty_log(FND_LOG.LEVEL_PROCEDURE,

1800: AND qual_type_id <> -1001;
1801:
1802: BEGIN
1803: -- debug message
1804: jty_log(FND_LOG.LEVEL_PROCEDURE,
1805: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_terr_rank.start',
1806: 'Start of the procedure JTY_TERR_DENORM_RULES_PVT.process_terr_rank ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1807:
1808: /* Get the maximum rank among the territories for the usage */

Line 1856: jty_log(FND_LOG.LEVEL_EXCEPTION,

1852: retcode => retcode);
1853:
1854: IF (retcode <> 0) THEN
1855: -- debug message
1856: jty_log(FND_LOG.LEVEL_EXCEPTION,
1857: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_terr_rank.update_relative_rank',
1858: 'update_relative_rank API has failed');
1859:
1860: RAISE FND_API.G_EXC_ERROR;

Line 1872: jty_log(FND_LOG.LEVEL_EXCEPTION,

1868: retcode => retcode);
1869:
1870: IF (retcode <> 0) THEN
1871: -- debug message
1872: jty_log(FND_LOG.LEVEL_EXCEPTION,
1873: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_terr_rank.update_absolute_rank',
1874: 'update_absolute_rank API has failed');
1875:
1876: RAISE FND_API.G_EXC_ERROR;

Line 1907: jty_log(FND_LOG.LEVEL_EXCEPTION,

1903: retcode => retcode);
1904:
1905: IF (retcode <> 0) THEN
1906: -- debug message
1907: jty_log(FND_LOG.LEVEL_EXCEPTION,
1908: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_terr_rank.update_denorm_table',
1909: 'update_denorm_table API has failed');
1910:
1911: RAISE FND_API.G_EXC_ERROR;

Line 2097: jty_log(FND_LOG.LEVEL_EXCEPTION,

2093: retcode => retcode);
2094:
2095: IF (retcode <> 0) THEN
2096: -- debug message
2097: jty_log(FND_LOG.LEVEL_EXCEPTION,
2098: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_terr_rank.update_relative_rank',
2099: 'update_relative_rank API has failed');
2100:
2101: RAISE FND_API.G_EXC_ERROR;

Line 2114: jty_log(FND_LOG.LEVEL_EXCEPTION,

2110: retcode => retcode);
2111:
2112: IF (retcode <> 0) THEN
2113: -- debug message
2114: jty_log(FND_LOG.LEVEL_EXCEPTION,
2115: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_terr_rank.update_absolute_rank',
2116: 'update_absolute_rank API has failed');
2117:
2118: RAISE FND_API.G_EXC_ERROR;

Line 2150: jty_log(FND_LOG.LEVEL_EXCEPTION,

2146: retcode => retcode);
2147:
2148: IF (retcode <> 0) THEN
2149: -- debug message
2150: jty_log(FND_LOG.LEVEL_EXCEPTION,
2151: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_terr_rank.update_denorm_table',
2152: 'update_denorm_table API has failed');
2153:
2154: RAISE FND_API.G_EXC_ERROR;

Line 2221: jty_log(FND_LOG.LEVEL_STATEMENT,

2217: NULL;
2218: END;*/
2219:
2220: -- debug message
2221: jty_log(FND_LOG.LEVEL_STATEMENT,
2222: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_terr_rank.rows_inserted',
2223: 'Finished inserting rows into denorm table and rank calculation');
2224:
2225: END IF; /* end IF (p_terr_change_tab.terr_id.COUNT > 0) */

Line 2279: jty_log(FND_LOG.LEVEL_PROCEDURE,

2275: NULL;
2276: END;
2277:
2278: -- debug message
2279: jty_log(FND_LOG.LEVEL_PROCEDURE,
2280: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_terr_rank.end',
2281: 'End of the procedure JTY_TERR_DENORM_RULES_PVT.process_terr_rank ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
2282:
2283: retcode := 0;

Line 2289: jty_log(FND_LOG.LEVEL_EXCEPTION,

2285:
2286: EXCEPTION
2287: WHEN FND_API.G_EXC_ERROR THEN
2288: RETCODE := 2;
2289: jty_log(FND_LOG.LEVEL_EXCEPTION,
2290: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_terr_rank.g_exc_error',
2291: 'API JTY_TERR_DENORM_RULES_PVT.process_terr_rank has failed with FND_API.G_EXC_ERROR exception');
2292:
2293: WHEN OTHERS THEN

Line 2296: jty_log(FND_LOG.LEVEL_EXCEPTION,

2292:
2293: WHEN OTHERS THEN
2294: RETCODE := 2;
2295: ERRBUF := SQLCODE || ' : ' || SQLERRM;
2296: jty_log(FND_LOG.LEVEL_EXCEPTION,
2297: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_terr_rank.others',
2298: substr(errbuf, 1, 4000));
2299:
2300: END process_terr_rank;

Line 2330: jty_log(FND_LOG.LEVEL_PROCEDURE,

2326:
2327: L_SCHEMA_NOTFOUND EXCEPTION;
2328: BEGIN
2329: -- debug message
2330: jty_log(FND_LOG.LEVEL_PROCEDURE,
2331: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.drop_dnmval_table_indexes.begin',
2332: 'Start of the procedure JTY_TERR_DENORM_RULES_PVT.drop_dnmval_table_indexes ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
2333:
2334: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2370: jty_log(FND_LOG.LEVEL_PROCEDURE,

2366: END LOOP;
2367: END IF;
2368:
2369: -- debug message
2370: jty_log(FND_LOG.LEVEL_PROCEDURE,
2371: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.drop_dnmval_table_indexes.end',
2372: 'End of the procedure JTY_TERR_DENORM_RULES_PVT.drop_dnmval_table_indexes ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
2373:
2374: EXCEPTION

Line 2377: jty_log(FND_LOG.LEVEL_EXCEPTION,

2373:
2374: EXCEPTION
2375: WHEN L_SCHEMA_NOTFOUND THEN
2376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2377: jty_log(FND_LOG.LEVEL_EXCEPTION,
2378: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.drop_dnmval_table_indexes.l_schema_notfound',
2379: 'Schema name corresponding to JTF application not found');
2380:
2381: WHEN OTHERS THEN

Line 2383: jty_log(FND_LOG.LEVEL_EXCEPTION,

2379: 'Schema name corresponding to JTF application not found');
2380:
2381: WHEN OTHERS THEN
2382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2383: jty_log(FND_LOG.LEVEL_EXCEPTION,
2384: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.drop_dnmval_table_indexes.others',
2385: substr(SQLCODE || ' : ' || SQLERRM, 1, 4000));
2386:
2387: END DROP_DNMVAL_TABLE_INDEXES;

Line 2411: jty_log(FND_LOG.LEVEL_PROCEDURE,

2407: FROM FND_ORACLE_USERID
2408: WHERE ORACLE_ID=b_APP_ID;
2409: BEGIN
2410: -- debug message
2411: jty_log(FND_LOG.LEVEL_PROCEDURE,
2412: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank.start',
2413: 'Start of the procedure JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
2414:
2415: OPEN c_prod(l_jtf_app_id);

Line 2419: jty_log(FND_LOG.LEVEL_PROCEDURE,

2415: OPEN c_prod(l_jtf_app_id);
2416: FETCH c_prod INTO l_table_owner;
2417: CLOSE c_prod;
2418:
2419: jty_log(FND_LOG.LEVEL_PROCEDURE,
2420: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank.l_table_owner',
2421: 'Start of the procedure JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank ' || l_table_owner);
2422:
2423: IF (p_mode = 'DATE EFFECTIVE') THEN

Line 2455: jty_log(FND_LOG.LEVEL_EXCEPTION,

2451: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2452: retcode := 2;
2453: errbuf := 'drop_dnmval_table_indexes API has failed';
2454: -- debug message
2455: jty_log(FND_LOG.LEVEL_EXCEPTION,
2456: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank.drop_dnmval_table_indexes',
2457: 'drop_dnmval_table_indexes API has failed');
2458:
2459: RAISE FND_API.G_EXC_ERROR;

Line 2487: jty_log(FND_LOG.LEVEL_EXCEPTION,

2483: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2484: retcode := 2;
2485: errbuf := 'drop_dnmval_table_indexes API has failed';
2486: -- debug message
2487: jty_log(FND_LOG.LEVEL_EXCEPTION,
2488: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank.drop_dnmval_table_indexes',
2489: 'drop_dnmval_table_indexes API has failed');
2490:
2491: RAISE FND_API.G_EXC_ERROR;

Line 2561: jty_log(FND_LOG.LEVEL_EXCEPTION,

2557: ,retcode => retcode);
2558:
2559: IF (retcode <> 0) THEN
2560: -- debug message
2561: jty_log(FND_LOG.LEVEL_EXCEPTION,
2562: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank.process_terr_rank',
2563: 'process_terr_rank API has failed');
2564:
2565: RAISE FND_API.G_EXC_ERROR;

Line 2569: jty_log(FND_LOG.LEVEL_EVENT,

2565: RAISE FND_API.G_EXC_ERROR;
2566: END IF;
2567:
2568: -- debug message
2569: jty_log(FND_LOG.LEVEL_EVENT,
2570: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank.process_terr_rank',
2571: 'API process_terr_rank completed successfully');
2572:
2573: /* Denormalize the qualifier values and calculate num_qual and qual_relation_product */

Line 2584: jty_log(FND_LOG.LEVEL_EXCEPTION,

2580: ,retcode => retcode);
2581:
2582: IF (retcode <> 0) THEN
2583: -- debug message
2584: jty_log(FND_LOG.LEVEL_EXCEPTION,
2585: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank.process_attr_values',
2586: 'process_attr_values API has failed');
2587:
2588: RAISE FND_API.G_EXC_ERROR;

Line 2592: jty_log(FND_LOG.LEVEL_EVENT,

2588: RAISE FND_API.G_EXC_ERROR;
2589: END IF;
2590:
2591: -- debug message
2592: jty_log(FND_LOG.LEVEL_EVENT,
2593: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank.process_attr_values',
2594: 'API process_attr_values completed successfully');
2595:
2596: -- debug message

Line 2597: jty_log(FND_LOG.LEVEL_PROCEDURE,

2593: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank.process_attr_values',
2594: 'API process_attr_values completed successfully');
2595:
2596: -- debug message
2597: jty_log(FND_LOG.LEVEL_PROCEDURE,
2598: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank.end',
2599: 'End of the procedure JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
2600:
2601: retcode := 0;

Line 2606: jty_log(FND_LOG.LEVEL_EXCEPTION,

2602: errbuf := null;
2603:
2604: EXCEPTION
2605: WHEN FND_API.G_EXC_ERROR THEN
2606: jty_log(FND_LOG.LEVEL_EXCEPTION,
2607: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank.g_exc_error',
2608: 'API JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank has failed with FND_API.G_EXC_ERROR exception');
2609:
2610: WHEN OTHERS THEN

Line 2613: jty_log(FND_LOG.LEVEL_EXCEPTION,

2609:
2610: WHEN OTHERS THEN
2611: RETCODE := 2;
2612: ERRBUF := SQLCODE || ' : ' || SQLERRM;
2613: jty_log(FND_LOG.LEVEL_EXCEPTION,
2614: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank.others',
2615: substr(errbuf, 1, 4000));
2616:
2617: END process_attr_and_rank;