APPS.JTY_TERR_DENORM_RULES_PVT dependencies on FND_LOG

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

99: AND B.owner = cl_owner;
100:
101: BEGIN
102: -- debug message
103: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
104: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
105: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.begin',
106: 'Start of the procedure jty_terr_denorm_rules_pvt.create_dnmval_index');
107: END IF;

Line 104: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

100:
101: BEGIN
102: -- debug message
103: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
104: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
105: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.begin',
106: 'Start of the procedure jty_terr_denorm_rules_pvt.create_dnmval_index');
107: END IF;
108:

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

127: p_source_id => p_source_id,
128: x_return_status => x_return_status);
129:
130: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
131: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
132: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
133: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.selectivity',
134: 'API jty_tae_index_creation_pvt.SELECTIVITY has failed');
135: END IF;

Line 132: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

128: x_return_status => x_return_status);
129:
130: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
131: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
132: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
133: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.selectivity',
134: 'API jty_tae_index_creation_pvt.SELECTIVITY has failed');
135: END IF;
136: RAISE FND_API.G_EXC_ERROR;

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

148: x_Return_Status => x_return_status );
149: END IF;
150:
151: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
152: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
153: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
154: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.reduce_dnmval_idx_set',
155: 'API JTY_TAE_CONTROL_PVT.reduce_dnmval_idx_set has failed');
156: END IF;

Line 153: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

149: END IF;
150:
151: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
152: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
153: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
154: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.reduce_dnmval_idx_set',
155: 'API JTY_TAE_CONTROL_PVT.reduce_dnmval_idx_set has failed');
156: END IF;
157: RAISE FND_API.G_EXC_ERROR;

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

164: WHERE v.name = 'parallel_max_servers'
165: OR v.name = 'cpu_count';
166:
167: -- debug message
168: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
169: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
170: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.l_dop',
171: 'Default degree of parallelism : ' || l_dop);
172: END IF;

Line 169: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

165: OR v.name = 'cpu_count';
166:
167: -- debug message
168: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
169: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
170: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.l_dop',
171: 'Default degree of parallelism : ' || l_dop);
172: END IF;
173:

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

179: AND a.application_id = i.application_id
180: AND u.oracle_id = i.oracle_id;
181:
182: -- debug message
183: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
184: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
185: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.tablespace',
186: 'Table tablespace : ' || l_table_tablespace || ' Index tablespace : ' || l_idx_tablespace ||
187: ' Schema Name : ' || l_ora_username);

Line 184: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

180: AND u.oracle_id = i.oracle_id;
181:
182: -- debug message
183: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
184: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
185: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.tablespace',
186: 'Table tablespace : ' || l_table_tablespace || ' Index tablespace : ' || l_idx_tablespace ||
187: ' Schema Name : ' || l_ora_username);
188: END IF;

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

224: /* Append Storage Parameter Information to Index Definition */
225: v_statement := v_statement || s_statement;
226:
227: -- debug message
228: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
229: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
230: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.index_creation',
231: 'Index created with the statement : ' || v_statement);
232: END IF;

Line 229: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

225: v_statement := v_statement || s_statement;
226:
227: -- debug message
228: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
229: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
230: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.index_creation',
231: 'Index created with the statement : ' || v_statement);
232: END IF;
233: DECLARE --Bug 7645026

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

294: /* Append Storage Parameter Information to Index Definition */
295: v_statement := v_statement || s_statement;
296:
297: -- debug message
298: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
299: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
300: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.index_creation',
301: 'Index created with the statement : ' || v_statement);
302: END IF;

Line 299: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

295: v_statement := v_statement || s_statement;
296:
297: -- debug message
298: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
299: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
300: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.index_creation',
301: 'Index created with the statement : ' || v_statement);
302: END IF;
303: DECLARE --Bug 7614496

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

318: END LOOP; /* end loop FOR prd IN getDeaProductList */
319: END IF; /* end IF ((p_mode = 'TOTAL') OR (p_mode = 'INCREMENTAL')) */
320:
321: -- debug message
322: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
323: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
324: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.end',
325: 'End of the procedure jty_terr_denorm_rules_pvt.create_dnmval_index');
326: END IF;

Line 323: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

319: END IF; /* end IF ((p_mode = 'TOTAL') OR (p_mode = 'INCREMENTAL')) */
320:
321: -- debug message
322: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
323: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
324: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.end',
325: 'End of the procedure jty_terr_denorm_rules_pvt.create_dnmval_index');
326: END IF;
327:

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

327:
328: EXCEPTION
329: WHEN NO_DATA_FOUND THEN
330: x_return_status := FND_API.G_RET_STS_ERROR ;
331: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
332: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
333: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.no_data_found',
334: 'API jty_terr_denorm_rules_pvt.create_dnmval_index has failed with no_data_found');
335: END IF;

Line 332: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

328: EXCEPTION
329: WHEN NO_DATA_FOUND THEN
330: x_return_status := FND_API.G_RET_STS_ERROR ;
331: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
332: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
333: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.no_data_found',
334: 'API jty_terr_denorm_rules_pvt.create_dnmval_index has failed with no_data_found');
335: END IF;
336:

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

335: END IF;
336:
337: WHEN FND_API.G_EXC_ERROR THEN
338: x_return_status := FND_API.G_RET_STS_ERROR ;
339: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
340: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
341: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.g_exc_error',
342: 'jty_terr_denorm_rules_pvt.create_dnmval_index has failed with G_EXC_ERROR exception');
343: END IF;

Line 340: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

336:
337: WHEN FND_API.G_EXC_ERROR THEN
338: x_return_status := FND_API.G_RET_STS_ERROR ;
339: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
340: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
341: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.g_exc_error',
342: 'jty_terr_denorm_rules_pvt.create_dnmval_index has failed with G_EXC_ERROR exception');
343: END IF;
344:

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

343: END IF;
344:
345: WHEN OTHERS THEN
346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
347: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
348: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
349: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.others',
350: substr(SQLCODE || ' : ' || SQLERRM, 1, 4000));
351: END IF;

Line 348: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

344:
345: WHEN OTHERS THEN
346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
347: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
348: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
349: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.others',
350: substr(SQLCODE || ' : ' || SQLERRM, 1, 4000));
351: END IF;
352:

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

401:
402: l_no_of_records NUMBER;
403: BEGIN
404: -- debug message
405: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
406: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
407: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.update_denorm_table.start',
408: 'Start of the procedure JTY_TERR_DENORM_RULES_PVT.update_denorm_table');
409: END IF;

Line 406: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

402: l_no_of_records NUMBER;
403: BEGIN
404: -- debug message
405: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
406: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
407: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.update_denorm_table.start',
408: 'Start of the procedure JTY_TERR_DENORM_RULES_PVT.update_denorm_table');
409: END IF;
410:

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

468: -- , (SELECT absolute_rank from jtf_terr_all where terr_id = p_terr_id_tbl(i))
469: );
470:
471: -- debug message
472: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
473: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
474: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.update_denorm_table.num_rows_inserted',
475: 'Number of records inserted into jtf_terr_denorm_rules_all : ' || l_no_of_records);
476: END IF;

Line 473: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

469: );
470:
471: -- debug message
472: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
473: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
474: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.update_denorm_table.num_rows_inserted',
475: 'Number of records inserted into jtf_terr_denorm_rules_all : ' || l_no_of_records);
476: END IF;
477:

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

528: -- , (SELECT absolute_rank from jtf_terr_all where terr_id = p_terr_id_tbl(i))
529: );
530:
531: -- debug message
532: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
533: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
534: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.update_denorm_table.num_rows_inserted',
535: 'Number of records inserted into jty_denorm_dea_rules_all : ' || l_no_of_records);
536: END IF;

Line 533: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

529: );
530:
531: -- debug message
532: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
533: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
534: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.update_denorm_table.num_rows_inserted',
535: 'Number of records inserted into jty_denorm_dea_rules_all : ' || l_no_of_records);
536: END IF;
537:

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

539:
540: END IF; /* end IF (l_no_of_records > 0) */
541:
542: -- debug message
543: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
544: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
545: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.update_denorm_table.end',
546: 'End of the procedure JTY_TERR_DENORM_RULES_PVT.update_denorm_table');
547: END IF;

Line 544: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

540: END IF; /* end IF (l_no_of_records > 0) */
541:
542: -- debug message
543: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
544: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
545: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.update_denorm_table.end',
546: 'End of the procedure JTY_TERR_DENORM_RULES_PVT.update_denorm_table');
547: END IF;
548:

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

552: EXCEPTION
553: WHEN OTHERS THEN
554: RETCODE := 2;
555: ERRBUF := SQLCODE || ' : ' || SQLERRM;
556: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
557: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
558: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.update_denorm_table.others',
559: substr(errbuf, 1, 4000));
560: END IF;

Line 557: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

553: WHEN OTHERS THEN
554: RETCODE := 2;
555: ERRBUF := SQLCODE || ' : ' || SQLERRM;
556: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
557: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
558: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.update_denorm_table.others',
559: substr(errbuf, 1, 4000));
560: END IF;
561: END update_denorm_table;

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

570:
571: l_no_of_records NUMBER;
572: BEGIN
573: -- debug message
574: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
575: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
576: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.update_relative_rank.start',
577: 'Start of the procedure JTY_TERR_DENORM_RULES_PVT.update_relative_rank');
578: END IF;

Line 575: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

571: l_no_of_records NUMBER;
572: BEGIN
573: -- debug message
574: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
575: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
576: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.update_relative_rank.start',
577: 'Start of the procedure JTY_TERR_DENORM_RULES_PVT.update_relative_rank');
578: END IF;
579:

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

603: NULL;
604: END;
605:
606: -- debug message
607: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
608: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
609: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.update_relative_rank.num_rows_updated',
610: 'Number of records updated in jtf_terr_all for relative rank : ' || l_no_of_records);
611: END IF;

Line 608: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

604: END;
605:
606: -- debug message
607: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
608: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
609: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.update_relative_rank.num_rows_updated',
610: 'Number of records updated in jtf_terr_all for relative rank : ' || l_no_of_records);
611: END IF;
612:

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

612:
613: END IF; /* end IF (l_no_of_records > 0) */
614:
615: -- debug message
616: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
617: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
618: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.update_relative_rank.end',
619: 'End of the procedure JTY_TERR_DENORM_RULES_PVT.update_relative_rank');
620: END IF;

Line 617: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

613: END IF; /* end IF (l_no_of_records > 0) */
614:
615: -- debug message
616: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
617: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
618: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.update_relative_rank.end',
619: 'End of the procedure JTY_TERR_DENORM_RULES_PVT.update_relative_rank');
620: END IF;
621:

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

625: EXCEPTION
626: WHEN OTHERS THEN
627: RETCODE := 2;
628: ERRBUF := SQLCODE || ' : ' || SQLERRM;
629: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
630: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
631: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.update_relative_rank.others',
632: substr(errbuf, 1, 4000));
633: END IF;

Line 630: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

626: WHEN OTHERS THEN
627: RETCODE := 2;
628: ERRBUF := SQLCODE || ' : ' || SQLERRM;
629: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
630: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
631: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.update_relative_rank.others',
632: substr(errbuf, 1, 4000));
633: END IF;
634: END update_relative_rank;

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

644: l_dyn_str VARCHAR2(1000);
645: l_no_of_records NUMBER;
646: BEGIN
647: -- debug message
648: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
649: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
650: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.update_absolute_rank.start',
651: 'Start of the procedure JTY_TERR_DENORM_RULES_PVT.update_absolute_rank');
652: END IF;

Line 649: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

645: l_no_of_records NUMBER;
646: BEGIN
647: -- debug message
648: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
649: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
650: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.update_absolute_rank.start',
651: 'Start of the procedure JTY_TERR_DENORM_RULES_PVT.update_absolute_rank');
652: END IF;
653:

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

699: NULL;
700: END;
701:
702: -- debug message
703: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
704: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
705: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.update_absolute_rank.num_rows_updated',
706: 'Number of records updated in jtf_terr_all for absolute rank : ' || l_no_of_records);
707: END IF;

Line 704: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

700: END;
701:
702: -- debug message
703: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
704: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
705: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.update_absolute_rank.num_rows_updated',
706: 'Number of records updated in jtf_terr_all for absolute rank : ' || l_no_of_records);
707: END IF;
708:

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

708:
709: END IF; /* end IF (l_no_of_records > 0) */
710:
711: -- debug message
712: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
713: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
714: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.update_absolute_rank.end',
715: 'End of the procedure JTY_TERR_DENORM_RULES_PVT.update_absolute_rank');
716: END IF;

Line 713: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

709: END IF; /* end IF (l_no_of_records > 0) */
710:
711: -- debug message
712: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
713: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
714: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.update_absolute_rank.end',
715: 'End of the procedure JTY_TERR_DENORM_RULES_PVT.update_absolute_rank');
716: END IF;
717:

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

721: EXCEPTION
722: WHEN OTHERS THEN
723: RETCODE := 2;
724: ERRBUF := SQLCODE || ' : ' || SQLERRM;
725: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
726: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
727: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.update_absolute_rank.others',
728: substr(errbuf, 1, 4000));
729: END IF;

Line 726: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

722: WHEN OTHERS THEN
723: RETCODE := 2;
724: ERRBUF := SQLCODE || ' : ' || SQLERRM;
725: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
726: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
727: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.update_absolute_rank.others',
728: substr(errbuf, 1, 4000));
729: END IF;
730: END update_absolute_rank;

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

1079: L_SCHEMA_NOTFOUND EXCEPTION;
1080:
1081: BEGIN
1082: -- debug message
1083: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1084: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1085: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_values.start',
1086: 'Start of the procedure JTY_TERR_DENORM_RULES_PVT.process_attr_values');
1087: END IF;

Line 1084: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

1080:
1081: BEGIN
1082: -- debug message
1083: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1084: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1085: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_values.start',
1086: 'Start of the procedure JTY_TERR_DENORM_RULES_PVT.process_attr_values');
1087: END IF;
1088:

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

1438: END LOOP; /* end loop FOR i IN p_terr_change_tab.terr_id.FIRST .. p_terr_change_tab.terr_id.LAST */
1439: END IF; /* end IF (p_terr_change_tab.terr_id.COUNT > 0) */
1440:
1441: -- debug message
1442: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1443: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1444: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_values.denorm_value_gt',
1445: 'Done populating the global temp table with denormalised informations');
1446: END IF;

Line 1443: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1439: END IF; /* end IF (p_terr_change_tab.terr_id.COUNT > 0) */
1440:
1441: -- debug message
1442: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1443: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1444: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_values.denorm_value_gt',
1445: 'Done populating the global temp table with denormalised informations');
1446: END IF;
1447:

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

1507: ,g_program_id
1508: ,g_sysdate;
1509:
1510: -- debug message
1511: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1512: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1513: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_values.denorm_value',
1514: 'Number of rows inserted : ' || SQL%ROWCOUNT);
1515: END IF;

Line 1512: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1508: ,g_sysdate;
1509:
1510: -- debug message
1511: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1512: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1513: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_values.denorm_value',
1514: 'Number of rows inserted : ' || SQL%ROWCOUNT);
1515: END IF;
1516:

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

1524:
1525: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1526: retcode := 2;
1527: errbuf := 'JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX has failed for table ' || l_table_name;
1528: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1529: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1530: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_values.analyze_table_index',
1531: 'ANALYZE_TABLE_INDEX API has failed');
1532: END IF;

Line 1529: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

1525: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1526: retcode := 2;
1527: errbuf := 'JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX has failed for table ' || l_table_name;
1528: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1529: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1530: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_values.analyze_table_index',
1531: 'ANALYZE_TABLE_INDEX API has failed');
1532: END IF;
1533:

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

1577:
1578: END IF; /* end IF (l_qtype_terr_id_tbl.COUNT > 0) */
1579:
1580: -- debug message
1581: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1582: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1583: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_values.update_num_qual',
1584: 'Done updating jtf_terr_qtype_usgs_all with num_qual and qual_relation_product');
1585: END IF;

Line 1582: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1578: END IF; /* end IF (l_qtype_terr_id_tbl.COUNT > 0) */
1579:
1580: -- debug message
1581: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1582: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1583: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_values.update_num_qual',
1584: 'Done updating jtf_terr_qtype_usgs_all with num_qual and qual_relation_product');
1585: END IF;
1586:

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

1584: 'Done updating jtf_terr_qtype_usgs_all with num_qual and qual_relation_product');
1585: END IF;
1586:
1587: -- debug message
1588: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1589: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1590: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_values.end',
1591: 'End of the procedure JTY_TERR_DENORM_RULES_PVT.process_attr_values');
1592: END IF;

Line 1589: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

1585: END IF;
1586:
1587: -- debug message
1588: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1589: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1590: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_values.end',
1591: 'End of the procedure JTY_TERR_DENORM_RULES_PVT.process_attr_values');
1592: END IF;
1593:

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

1595: errbuf := null;
1596:
1597: EXCEPTION
1598: WHEN FND_API.G_EXC_ERROR THEN
1599: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1600: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1601: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_values.g_exc_error',
1602: 'API JTY_TERR_DENORM_RULES_PVT.process_attr_values has failed with FND_API.G_EXC_ERROR exception');
1603: END IF;

Line 1600: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

1596:
1597: EXCEPTION
1598: WHEN FND_API.G_EXC_ERROR THEN
1599: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1600: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1601: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_values.g_exc_error',
1602: 'API JTY_TERR_DENORM_RULES_PVT.process_attr_values has failed with FND_API.G_EXC_ERROR exception');
1603: END IF;
1604:

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

1604:
1605: WHEN L_SCHEMA_NOTFOUND THEN
1606: RETCODE := 2;
1607: ERRBUF := 'JTY_TERR_DENORM_RULES_PVT.process_attr_values : SCHEMA NAME NOT FOUND CORRESPONDING TO JTF APPLICATION. ';
1608: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1609: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1610: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_values.l_schema_notfound',
1611: errbuf);
1612: END IF;

Line 1609: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

1605: WHEN L_SCHEMA_NOTFOUND THEN
1606: RETCODE := 2;
1607: ERRBUF := 'JTY_TERR_DENORM_RULES_PVT.process_attr_values : SCHEMA NAME NOT FOUND CORRESPONDING TO JTF APPLICATION. ';
1608: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1609: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1610: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_values.l_schema_notfound',
1611: errbuf);
1612: END IF;
1613:

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

1613:
1614: WHEN OTHERS THEN
1615: RETCODE := 2;
1616: ERRBUF := SQLCODE || ' : ' || SQLERRM;
1617: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1618: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1619: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_values.others',
1620: substr(errbuf, 1, 4000));
1621: END IF;

Line 1618: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

1614: WHEN OTHERS THEN
1615: RETCODE := 2;
1616: ERRBUF := SQLCODE || ' : ' || SQLERRM;
1617: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1618: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1619: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_values.others',
1620: substr(errbuf, 1, 4000));
1621: END IF;
1622:

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

1668: AND qual_type_id <> -1001;
1669:
1670: BEGIN
1671: -- debug message
1672: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1673: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1674: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_terr_rank.start',
1675: 'Start of the procedure JTY_TERR_DENORM_RULES_PVT.process_terr_rank');
1676: END IF;

Line 1673: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

1669:
1670: BEGIN
1671: -- debug message
1672: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1673: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1674: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_terr_rank.start',
1675: 'Start of the procedure JTY_TERR_DENORM_RULES_PVT.process_terr_rank');
1676: END IF;
1677:

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

1716: retcode => retcode);
1717:
1718: IF (retcode <> 0) THEN
1719: -- debug message
1720: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1721: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1722: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_terr_rank.update_relative_rank',
1723: 'update_relative_rank API has failed');
1724: END IF;

Line 1721: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

1717:
1718: IF (retcode <> 0) THEN
1719: -- debug message
1720: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1721: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1722: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_terr_rank.update_relative_rank',
1723: 'update_relative_rank API has failed');
1724: END IF;
1725:

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

1734: retcode => retcode);
1735:
1736: IF (retcode <> 0) THEN
1737: -- debug message
1738: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1739: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1740: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_terr_rank.update_absolute_rank',
1741: 'update_absolute_rank API has failed');
1742: END IF;

Line 1739: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

1735:
1736: IF (retcode <> 0) THEN
1737: -- debug message
1738: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1739: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1740: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_terr_rank.update_absolute_rank',
1741: 'update_absolute_rank API has failed');
1742: END IF;
1743:

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

1771: retcode => retcode);
1772:
1773: IF (retcode <> 0) THEN
1774: -- debug message
1775: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1776: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1777: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_terr_rank.update_denorm_table',
1778: 'update_denorm_table API has failed');
1779: END IF;

Line 1776: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

1772:
1773: IF (retcode <> 0) THEN
1774: -- debug message
1775: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1776: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1777: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_terr_rank.update_denorm_table',
1778: 'update_denorm_table API has failed');
1779: END IF;
1780:

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

1963: retcode => retcode);
1964:
1965: IF (retcode <> 0) THEN
1966: -- debug message
1967: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1968: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1969: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_terr_rank.update_relative_rank',
1970: 'update_relative_rank API has failed');
1971: END IF;

Line 1968: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

1964:
1965: IF (retcode <> 0) THEN
1966: -- debug message
1967: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1968: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1969: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_terr_rank.update_relative_rank',
1970: 'update_relative_rank API has failed');
1971: END IF;
1972:

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

1982: retcode => retcode);
1983:
1984: IF (retcode <> 0) THEN
1985: -- debug message
1986: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1987: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1988: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_terr_rank.update_absolute_rank',
1989: 'update_absolute_rank API has failed');
1990: END IF;

Line 1987: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

1983:
1984: IF (retcode <> 0) THEN
1985: -- debug message
1986: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1987: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1988: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_terr_rank.update_absolute_rank',
1989: 'update_absolute_rank API has failed');
1990: END IF;
1991:

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

2020: retcode => retcode);
2021:
2022: IF (retcode <> 0) THEN
2023: -- debug message
2024: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2025: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2026: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_terr_rank.update_denorm_table',
2027: 'update_denorm_table API has failed');
2028: END IF;

Line 2025: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

2021:
2022: IF (retcode <> 0) THEN
2023: -- debug message
2024: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2025: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2026: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_terr_rank.update_denorm_table',
2027: 'update_denorm_table API has failed');
2028: END IF;
2029:

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

2090: NULL;
2091: END;*/
2092:
2093: -- debug message
2094: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2095: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2096: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_terr_rank.rows_inserted',
2097: 'Finished inserting rows into denorm table and rank calculation');
2098: END IF;

Line 2095: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

2091: END;*/
2092:
2093: -- debug message
2094: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2095: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2096: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_terr_rank.rows_inserted',
2097: 'Finished inserting rows into denorm table and rank calculation');
2098: END IF;
2099:

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

2150: NULL;
2151: END;
2152:
2153: -- debug message
2154: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2155: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
2156: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_terr_rank.end',
2157: 'End of the procedure JTY_TERR_DENORM_RULES_PVT.process_terr_rank');
2158: END IF;

Line 2155: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

2151: END;
2152:
2153: -- debug message
2154: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2155: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
2156: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_terr_rank.end',
2157: 'End of the procedure JTY_TERR_DENORM_RULES_PVT.process_terr_rank');
2158: END IF;
2159:

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

2162:
2163: EXCEPTION
2164: WHEN FND_API.G_EXC_ERROR THEN
2165: RETCODE := 2;
2166: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2167: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2168: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_terr_rank.g_exc_error',
2169: 'API JTY_TERR_DENORM_RULES_PVT.process_terr_rank has failed with FND_API.G_EXC_ERROR exception');
2170: END IF;

Line 2167: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

2163: EXCEPTION
2164: WHEN FND_API.G_EXC_ERROR THEN
2165: RETCODE := 2;
2166: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2167: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2168: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_terr_rank.g_exc_error',
2169: 'API JTY_TERR_DENORM_RULES_PVT.process_terr_rank has failed with FND_API.G_EXC_ERROR exception');
2170: END IF;
2171:

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

2171:
2172: WHEN OTHERS THEN
2173: RETCODE := 2;
2174: ERRBUF := SQLCODE || ' : ' || SQLERRM;
2175: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2176: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2177: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_terr_rank.others',
2178: substr(errbuf, 1, 4000));
2179: END IF;

Line 2176: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

2172: WHEN OTHERS THEN
2173: RETCODE := 2;
2174: ERRBUF := SQLCODE || ' : ' || SQLERRM;
2175: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2176: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2177: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_terr_rank.others',
2178: substr(errbuf, 1, 4000));
2179: END IF;
2180:

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

2207:
2208: L_SCHEMA_NOTFOUND EXCEPTION;
2209: BEGIN
2210: -- debug message
2211: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2212: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
2213: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.drop_dnmval_table_indexes.begin',
2214: 'Start of the procedure JTY_TERR_DENORM_RULES_PVT.drop_dnmval_table_indexes');
2215: END IF;

Line 2212: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

2208: L_SCHEMA_NOTFOUND EXCEPTION;
2209: BEGIN
2210: -- debug message
2211: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2212: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
2213: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.drop_dnmval_table_indexes.begin',
2214: 'Start of the procedure JTY_TERR_DENORM_RULES_PVT.drop_dnmval_table_indexes');
2215: END IF;
2216:

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

2249: END LOOP;
2250: END IF;
2251:
2252: -- debug message
2253: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2254: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
2255: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.drop_dnmval_table_indexes.end',
2256: 'End of the procedure JTY_TERR_DENORM_RULES_PVT.drop_dnmval_table_indexes');
2257: END IF;

Line 2254: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

2250: END IF;
2251:
2252: -- debug message
2253: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2254: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
2255: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.drop_dnmval_table_indexes.end',
2256: 'End of the procedure JTY_TERR_DENORM_RULES_PVT.drop_dnmval_table_indexes');
2257: END IF;
2258:

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

2258:
2259: EXCEPTION
2260: WHEN L_SCHEMA_NOTFOUND THEN
2261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2262: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2263: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2264: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.drop_dnmval_table_indexes.l_schema_notfound',
2265: 'Schema name corresponding to JTF application not found');
2266: END IF;

Line 2263: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

2259: EXCEPTION
2260: WHEN L_SCHEMA_NOTFOUND THEN
2261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2262: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2263: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2264: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.drop_dnmval_table_indexes.l_schema_notfound',
2265: 'Schema name corresponding to JTF application not found');
2266: END IF;
2267:

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

2266: END IF;
2267:
2268: WHEN OTHERS THEN
2269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2270: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2271: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2272: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.drop_dnmval_table_indexes.others',
2273: substr(SQLCODE || ' : ' || SQLERRM, 1, 4000));
2274: END IF;

Line 2271: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

2267:
2268: WHEN OTHERS THEN
2269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2270: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2271: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2272: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.drop_dnmval_table_indexes.others',
2273: substr(SQLCODE || ' : ' || SQLERRM, 1, 4000));
2274: END IF;
2275:

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

2287: l_table_name VARCHAR2(30);
2288: x_return_status VARCHAR2(250);
2289: BEGIN
2290: -- debug message
2291: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2292: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
2293: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank.start',
2294: 'Start of the procedure JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank');
2295: END IF;

Line 2292: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

2288: x_return_status VARCHAR2(250);
2289: BEGIN
2290: -- debug message
2291: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2292: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
2293: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank.start',
2294: 'Start of the procedure JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank');
2295: END IF;
2296:

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

2320: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2321: retcode := 2;
2322: errbuf := 'drop_dnmval_table_indexes API has failed';
2323: -- debug message
2324: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2325: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2326: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank.drop_dnmval_table_indexes',
2327: 'drop_dnmval_table_indexes API has failed');
2328: END IF;

Line 2325: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

2321: retcode := 2;
2322: errbuf := 'drop_dnmval_table_indexes API has failed';
2323: -- debug message
2324: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2325: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2326: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank.drop_dnmval_table_indexes',
2327: 'drop_dnmval_table_indexes API has failed');
2328: END IF;
2329:

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

2354: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2355: retcode := 2;
2356: errbuf := 'drop_dnmval_table_indexes API has failed';
2357: -- debug message
2358: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2359: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2360: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank.drop_dnmval_table_indexes',
2361: 'drop_dnmval_table_indexes API has failed');
2362: END IF;

Line 2359: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

2355: retcode := 2;
2356: errbuf := 'drop_dnmval_table_indexes API has failed';
2357: -- debug message
2358: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2359: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2360: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank.drop_dnmval_table_indexes',
2361: 'drop_dnmval_table_indexes API has failed');
2362: END IF;
2363:

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

2401: ,retcode => retcode);
2402:
2403: IF (retcode <> 0) THEN
2404: -- debug message
2405: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2406: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2407: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank.process_terr_rank',
2408: 'process_terr_rank API has failed');
2409: END IF;

Line 2406: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

2402:
2403: IF (retcode <> 0) THEN
2404: -- debug message
2405: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2406: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2407: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank.process_terr_rank',
2408: 'process_terr_rank API has failed');
2409: END IF;
2410:

Line 2415: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2411: RAISE FND_API.G_EXC_ERROR;
2412: END IF;
2413:
2414: -- debug message
2415: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2416: FND_LOG.string(FND_LOG.LEVEL_EVENT,
2417: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank.process_terr_rank',
2418: 'API process_terr_rank completed successfully');
2419: END IF;

Line 2416: FND_LOG.string(FND_LOG.LEVEL_EVENT,

2412: END IF;
2413:
2414: -- debug message
2415: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2416: FND_LOG.string(FND_LOG.LEVEL_EVENT,
2417: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank.process_terr_rank',
2418: 'API process_terr_rank completed successfully');
2419: END IF;
2420:

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

2428: ,retcode => retcode);
2429:
2430: IF (retcode <> 0) THEN
2431: -- debug message
2432: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2433: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2434: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank.process_attr_values',
2435: 'process_attr_values API has failed');
2436: END IF;

Line 2433: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

2429:
2430: IF (retcode <> 0) THEN
2431: -- debug message
2432: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2433: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2434: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank.process_attr_values',
2435: 'process_attr_values API has failed');
2436: END IF;
2437:

Line 2442: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2438: RAISE FND_API.G_EXC_ERROR;
2439: END IF;
2440:
2441: -- debug message
2442: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2443: FND_LOG.string(FND_LOG.LEVEL_EVENT,
2444: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank.process_attr_values',
2445: 'API process_attr_values completed successfully');
2446: END IF;

Line 2443: FND_LOG.string(FND_LOG.LEVEL_EVENT,

2439: END IF;
2440:
2441: -- debug message
2442: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2443: FND_LOG.string(FND_LOG.LEVEL_EVENT,
2444: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank.process_attr_values',
2445: 'API process_attr_values completed successfully');
2446: END IF;
2447:

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

2445: 'API process_attr_values completed successfully');
2446: END IF;
2447:
2448: -- debug message
2449: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2450: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
2451: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank.end',
2452: 'End of the procedure JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank');
2453: END IF;

Line 2450: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

2446: END IF;
2447:
2448: -- debug message
2449: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2450: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
2451: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank.end',
2452: 'End of the procedure JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank');
2453: END IF;
2454:

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

2456: errbuf := null;
2457:
2458: EXCEPTION
2459: WHEN FND_API.G_EXC_ERROR THEN
2460: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2461: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2462: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank.g_exc_error',
2463: 'API JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank has failed with FND_API.G_EXC_ERROR exception');
2464: END IF;

Line 2461: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

2457:
2458: EXCEPTION
2459: WHEN FND_API.G_EXC_ERROR THEN
2460: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2461: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2462: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank.g_exc_error',
2463: 'API JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank has failed with FND_API.G_EXC_ERROR exception');
2464: END IF;
2465:

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

2465:
2466: WHEN OTHERS THEN
2467: RETCODE := 2;
2468: ERRBUF := SQLCODE || ' : ' || SQLERRM;
2469: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2470: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2471: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank.others',
2472: substr(errbuf, 1, 4000));
2473: END IF;

Line 2470: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

2466: WHEN OTHERS THEN
2467: RETCODE := 2;
2468: ERRBUF := SQLCODE || ' : ' || SQLERRM;
2469: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2470: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2471: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_and_rank.others',
2472: substr(errbuf, 1, 4000));
2473: END IF;
2474: