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 JTY_TERR_DENORM_RULES_PVT

Line 1: PACKAGE BODY JTY_TERR_DENORM_RULES_PVT AS

1: PACKAGE BODY JTY_TERR_DENORM_RULES_PVT AS
2: /* $Header: jtfytdrb.pls 120.56.12020000.3 2012/09/24 10:29:45 swpoddar ship $ */
3: -- Start of Comments
4: -- ---------------------------------------------------
5: -- PACKAGE NAME: JTY_TERR_DENORM_RULES_PVT

Line 5: -- PACKAGE NAME: JTY_TERR_DENORM_RULES_PVT

1: PACKAGE BODY JTY_TERR_DENORM_RULES_PVT AS
2: /* $Header: jtfytdrb.pls 120.56.12020000.3 2012/09/24 10:29:45 swpoddar ship $ */
3: -- Start of Comments
4: -- ---------------------------------------------------
5: -- PACKAGE NAME: JTY_TERR_DENORM_RULES_PVT
6: -- ---------------------------------------------------
7: -- PURPOSE
8: -- This package is used for the following prposes :
9: -- a) denormalize the territory hierarchy

Line 126: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.begin',

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;
130:

Line 127: 'Start of the procedure jty_terr_denorm_rules_pvt.create_dnmval_index ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

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;
130:
131: /* In incremental mode mark all the qualifier combination present */

Line 161: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.selectivity',

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;
165:

Line 181: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.reduce_dnmval_idx_set',

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;
185:

Line 195: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.l_dop',

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 */
199: SELECT i.tablespace, i.index_tablespace, u.oracle_username

Line 208: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.tablespace',

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:
212: -- default INDEX STORAGE parameters

Line 254: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.index_creation',

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;
258: pragma EXCEPTION_INIT(duplicate_index, -1408);

Line 325: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.index_creation dea incr',

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;
329: index_exists EXCEPTION;

Line 343: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.index_creation dea incr',

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;
347: END IF; /* end IF (j > 1) */

Line 380: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.end',

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
384: WHEN NO_DATA_FOUND THEN

Line 381: 'End of the procedure jty_terr_denorm_rules_pvt.create_dnmval_index ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

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
384: WHEN NO_DATA_FOUND THEN
385: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 387: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.no_data_found',

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
391: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 388: 'API jty_terr_denorm_rules_pvt.create_dnmval_index has failed with no_data_found');

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
391: x_return_status := FND_API.G_RET_STS_ERROR ;
392: jty_log(FND_LOG.LEVEL_EXCEPTION,

Line 393: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.g_exc_error',

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
397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 394: 'jty_terr_denorm_rules_pvt.create_dnmval_index has failed with G_EXC_ERROR exception');

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
397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
398: jty_log(FND_LOG.LEVEL_EXCEPTION,

Line 399: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.others',

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;
403:

Line 455: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.update_denorm_table.start',

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;
459:

Line 456: 'Start of the procedure JTY_TERR_DENORM_RULES_PVT.update_denorm_table ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

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;
459:
460: IF (l_no_of_records > 0) THEN

Line 520: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.update_denorm_table.num_rows_inserted',

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 */
524: /* hierarchy information into jty_denorm_dea_rules_all */

Line 577: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.update_denorm_table.num_rows_inserted',

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
581: /* if mode is date effective, insert the denormalized */

Line 635: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.update_denorm_table.num_rows_inserted',

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')) */
639:

Line 644: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.update_denorm_table.end',

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

Line 645: 'End of the procedure JTY_TERR_DENORM_RULES_PVT.update_denorm_table ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

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;
648: errbuf := null;
649:

Line 655: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.update_denorm_table.others',

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;
659:

Line 672: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.update_relative_rank.start',

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;
676:

Line 673: 'Start of the procedure JTY_TERR_DENORM_RULES_PVT.update_relative_rank ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

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;
676:
677: /* update the relative rank of the territory in jtf_terr_all */

Line 703: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.update_relative_rank.num_rows_updated',

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) */
707:

Line 710: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.update_relative_rank.end',

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

Line 711: 'End of the procedure JTY_TERR_DENORM_RULES_PVT.update_relative_rank ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

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;
714: errbuf := null;
715:

Line 721: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.update_relative_rank.others',

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:
725: /* This procedure updates the absolute rank in the table jtf_terr_all */

Line 738: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.update_absolute_rank.start',

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;
742:

Line 739: 'Start of the procedure JTY_TERR_DENORM_RULES_PVT.update_absolute_rank ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

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;
742:
743: /* update the relative rank of the territory in jtf_terr_all */

Line 794: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.update_absolute_rank.num_rows_updated',

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) */
798:

Line 801: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.update_absolute_rank.end',

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

Line 802: 'End of the procedure JTY_TERR_DENORM_RULES_PVT.update_absolute_rank ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

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;
805: errbuf := null;
806:

Line 812: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.update_absolute_rank.others',

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:
816: /* This procedure updates the denormalized territory qualifier value informations */

Line 1182: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_values.start',

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 */
1186: l_qtype_terr_id_tbl := l_qtype_terr_id_tbl_type();

Line 1183: 'Start of the procedure JTY_TERR_DENORM_RULES_PVT.process_attr_values ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

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 */
1186: l_qtype_terr_id_tbl := l_qtype_terr_id_tbl_type();
1187: l_qtype_trans_id_tbl := l_qtype_trans_id_tbl_type();

Line 1583: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_values.denorm_value_gt',

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 */
1587: /* Get the schema name corresponding to JTF application */

Line 1638: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_values.denorm_value',

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
1642: g_sysdate

Line 1653: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_values.denorm_value',

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
1657: jty_log(FND_LOG.LEVEL_STATEMENT,

Line 1658: '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 */
1662: IF (p_mode <> 'INCREMENTAL') THEN

Line 1673: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_values.analyze_table_index',

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

Line 1724: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_values.update_num_qual',

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
1728: jty_log(FND_LOG.LEVEL_PROCEDURE,

Line 1729: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_values.end',

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

Line 1730: 'End of the procedure JTY_TERR_DENORM_RULES_PVT.process_attr_values ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

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;
1733: errbuf := null;
1734:

Line 1738: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_values.g_exc_error',

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
1742: RETCODE := 2;

Line 1739: 'API JTY_TERR_DENORM_RULES_PVT.process_attr_values has failed with FND_API.G_EXC_ERROR exception');

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
1742: RETCODE := 2;
1743: ERRBUF := 'JTY_TERR_DENORM_RULES_PVT.process_attr_values : SCHEMA NAME NOT FOUND CORRESPONDING TO JTF APPLICATION. ';

Line 1743: ERRBUF := 'JTY_TERR_DENORM_RULES_PVT.process_attr_values : SCHEMA NAME NOT FOUND CORRESPONDING TO JTF APPLICATION. ';

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

Line 1745: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_values.l_schema_notfound',

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
1749: RETCODE := 2;

Line 1752: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_values.others',

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;
1756:

Line 1805: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_terr_rank.start',

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 */
1809: BEGIN

Line 1806: 'Start of the procedure JTY_TERR_DENORM_RULES_PVT.process_terr_rank ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

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 */
1809: BEGIN
1810:

Line 1857: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_terr_rank.update_relative_rank',

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

Line 1873: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_terr_rank.update_absolute_rank',

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

Line 1908: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_terr_rank.update_denorm_table',

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

Line 2098: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_terr_rank.update_relative_rank',

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

Line 2115: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_terr_rank.update_absolute_rank',

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

Line 2151: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_terr_rank.update_denorm_table',

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

Line 2222: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_terr_rank.rows_inserted',

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) */
2226:

Line 2280: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_terr_rank.end',

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

Line 2281: 'End of the procedure JTY_TERR_DENORM_RULES_PVT.process_terr_rank ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

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;
2284: errbuf := null;
2285:

Line 2290: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_terr_rank.g_exc_error',

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
2294: RETCODE := 2;

Line 2291: 'API JTY_TERR_DENORM_RULES_PVT.process_terr_rank has failed with FND_API.G_EXC_ERROR 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
2294: RETCODE := 2;
2295: ERRBUF := SQLCODE || ' : ' || SQLERRM;

Line 2297: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_terr_rank.others',

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;
2301:

Line 2331: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.drop_dnmval_table_indexes.begin',

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;
2335:

Line 2332: 'Start of the procedure JTY_TERR_DENORM_RULES_PVT.drop_dnmval_table_indexes ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

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;
2335:
2336: IF(FND_INSTALLATION.GET_APP_INFO('JTF', l_status, l_industry, l_jtf_schema)) THEN

Line 2371: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.drop_dnmval_table_indexes.end',

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
2375: WHEN L_SCHEMA_NOTFOUND THEN

Line 2372: 'End of the procedure JTY_TERR_DENORM_RULES_PVT.drop_dnmval_table_indexes ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

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
2375: WHEN L_SCHEMA_NOTFOUND THEN
2376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2378: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.drop_dnmval_table_indexes.l_schema_notfound',

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
2382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2384: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.drop_dnmval_table_indexes.others',

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;
2388:

Line 2412: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank.start',

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);
2416: FETCH c_prod INTO l_table_owner;

Line 2413: 'Start of the procedure JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

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);
2416: FETCH c_prod INTO l_table_owner;
2417: CLOSE c_prod;

Line 2420: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank.l_table_owner',

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
2424: SELECT denorm_dea_value_table_name

Line 2421: 'Start of the procedure JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank ' || 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
2424: SELECT denorm_dea_value_table_name
2425: INTO l_table_name

Line 2456: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank.drop_dnmval_table_indexes',

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

Line 2488: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank.drop_dnmval_table_indexes',

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

Line 2562: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank.process_terr_rank',

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

Line 2570: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank.process_terr_rank',

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 */
2574: process_attr_values (

Line 2585: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank.process_attr_values',

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

Line 2593: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank.process_attr_values',

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
2597: jty_log(FND_LOG.LEVEL_PROCEDURE,

Line 2598: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank.end',

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

Line 2599: 'End of the procedure JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

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;
2602: errbuf := null;
2603:

Line 2607: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank.g_exc_error',

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
2611: RETCODE := 2;

Line 2608: 'API JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank has failed with FND_API.G_EXC_ERROR exception');

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
2611: RETCODE := 2;
2612: ERRBUF := SQLCODE || ' : ' || SQLERRM;

Line 2614: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank.others',

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;
2618:

Line 2620: END JTY_TERR_DENORM_RULES_PVT;

2616:
2617: END process_attr_and_rank;
2618:
2619:
2620: END JTY_TERR_DENORM_RULES_PVT;