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

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

79: RETURN l_result;
80:
81: EXCEPTION
82: WHEN OTHERS THEN
83: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
84: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
85: 'jtf.plsql.JTY_TAE_GEN_PVT.build_predicate_for_operator.others',
86: substr(SQLCODE || ' : ' || SQLERRM, 1, 4000));
87: END IF;

Line 84: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

80:
81: EXCEPTION
82: WHEN OTHERS THEN
83: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
84: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
85: 'jtf.plsql.JTY_TAE_GEN_PVT.build_predicate_for_operator.others',
86: substr(SQLCODE || ' : ' || SQLERRM, 1, 4000));
87: END IF;
88: RAISE;

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

191: END IF;
192:
193: EXCEPTION
194: WHEN OTHERS THEN
195: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
196: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
197: 'jtf.plsql.JTY_TAE_GEN_PVT.append_inlineview.others',
198: substr(SQLCODE || ' : ' || SQLERRM, 1, 4000));
199: END IF;

Line 196: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

192:
193: EXCEPTION
194: WHEN OTHERS THEN
195: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
196: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
197: 'jtf.plsql.JTY_TAE_GEN_PVT.append_inlineview.others',
198: substr(SQLCODE || ' : ' || SQLERRM, 1, 4000));
199: END IF;
200: RAISE;

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

227: L_SCHEMA_NOTFOUND EXCEPTION;
228: BEGIN
229:
230: -- debug message
231: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
232: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
233: 'jtf.plsql.JTY_TAE_GEN_PVT.get_insert_select_nmtrans.start',
234: 'Start of the procedure JTY_TAE_GEN_PVT.get_insert_select_nmtrans');
235: END IF;

Line 232: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

228: BEGIN
229:
230: -- debug message
231: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
232: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
233: 'jtf.plsql.JTY_TAE_GEN_PVT.get_insert_select_nmtrans.start',
234: 'Start of the procedure JTY_TAE_GEN_PVT.get_insert_select_nmtrans');
235: END IF;
236:

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

285: g_new_line || l_indent || ',:PROGRAM_UPDATE_DATE ' ||
286: ' FROM ';
287:
288: -- debug message
289: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
290: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
291: 'jtf.plsql.JTY_TAE_GEN_PVT.get_insert_select_nmtrans.end',
292: 'End of the procedure JTY_TAE_GEN_PVT.get_insert_select_nmtrans');
293: END IF;

Line 290: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

286: ' FROM ';
287:
288: -- debug message
289: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
290: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
291: 'jtf.plsql.JTY_TAE_GEN_PVT.get_insert_select_nmtrans.end',
292: 'End of the procedure JTY_TAE_GEN_PVT.get_insert_select_nmtrans');
293: END IF;
294:

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

298: EXCEPTION
299: WHEN L_SCHEMA_NOTFOUND THEN
300: errbuf := 'Schema name corresponding to JTF application not found';
301: retcode := 2;
302: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
303: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
304: 'jtf.plsql.JTY_TAE_GEN_PVT.get_insert_select_nmtrans.l_schema_notfound',
305: errbuf);
306: END IF;

Line 303: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

299: WHEN L_SCHEMA_NOTFOUND THEN
300: errbuf := 'Schema name corresponding to JTF application not found';
301: retcode := 2;
302: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
303: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
304: 'jtf.plsql.JTY_TAE_GEN_PVT.get_insert_select_nmtrans.l_schema_notfound',
305: errbuf);
306: END IF;
307:

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

307:
308: WHEN OTHERS THEN
309: RETCODE := 2;
310: ERRBUF := SQLCODE || ' : ' || SQLERRM;
311: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
312: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
313: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_batch_sql.others',
314: substr(errbuf, 1, 4000));
315: END IF;

Line 312: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

308: WHEN OTHERS THEN
309: RETCODE := 2;
310: ERRBUF := SQLCODE || ' : ' || SQLERRM;
311: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
312: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
313: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_batch_sql.others',
314: substr(errbuf, 1, 4000));
315: END IF;
316: END get_insert_select_nmtrans;

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

399: l_op_where_tbl l_op_where_tbl_type;
400: BEGIN
401:
402: -- debug message
403: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
404: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
405: 'jtf.plsql.JTY_TAE_GEN_PVT.build_ilv1.start',
406: 'Start of the procedure JTY_TAE_GEN_PVT.build_ilv1');
407: END IF;

Line 404: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

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

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

512: l_where_str || g_new_line ||
513: l_predicate;
514:
515: -- debug message
516: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
517: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
518: 'jtf.plsql.JTY_TAE_GEN_PVT.build_ilv1.end',
519: 'End of the procedure JTY_TAE_GEN_PVT.build_ilv1');
520: END IF;

Line 517: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

513: l_predicate;
514:
515: -- debug message
516: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
517: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
518: 'jtf.plsql.JTY_TAE_GEN_PVT.build_ilv1.end',
519: 'End of the procedure JTY_TAE_GEN_PVT.build_ilv1');
520: END IF;
521:

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

525: EXCEPTION
526: WHEN OTHERS THEN
527: RETCODE := 2;
528: ERRBUF := SQLCODE || ' : ' || SQLERRM;
529: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
530: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
531: 'jtf.plsql.JTY_TAE_GEN_PVT.build_ilv1.others',
532: substr(errbuf, 1, 4000));
533: END IF;

Line 530: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

526: WHEN OTHERS THEN
527: RETCODE := 2;
528: ERRBUF := SQLCODE || ' : ' || SQLERRM;
529: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
530: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
531: 'jtf.plsql.JTY_TAE_GEN_PVT.build_ilv1.others',
532: substr(errbuf, 1, 4000));
533: END IF;
534: END build_ilv1;

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

621:
622: BEGIN
623:
624: -- debug message
625: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
626: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
627: 'jtf.plsql.JTY_TAE_GEN_PVT.build_ilv2.start',
628: 'Start of the procedure JTY_TAE_GEN_PVT.build_ilv2');
629: END IF;

Line 626: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

622: BEGIN
623:
624: -- debug message
625: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
626: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
627: 'jtf.plsql.JTY_TAE_GEN_PVT.build_ilv2.start',
628: 'Start of the procedure JTY_TAE_GEN_PVT.build_ilv2');
629: END IF;
630:

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

720: 'AND B.source_id = ' || p_source_id || g_new_line ||
721: 'AND B.trans_type_id = ' || p_trans_id;
722:
723: -- debug message
724: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
725: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
726: 'jtf.plsql.JTY_TAE_GEN_PVT.build_ilv2.end',
727: 'End of the procedure JTY_TAE_GEN_PVT.build_ilv2');
728: END IF;

Line 725: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

721: 'AND B.trans_type_id = ' || p_trans_id;
722:
723: -- debug message
724: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
725: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
726: 'jtf.plsql.JTY_TAE_GEN_PVT.build_ilv2.end',
727: 'End of the procedure JTY_TAE_GEN_PVT.build_ilv2');
728: END IF;
729:

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

732: EXCEPTION
733: WHEN OTHERS THEN
734: RETCODE := 2;
735: ERRBUF := SQLCODE || ' : ' || SQLERRM;
736: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
737: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
738: 'jtf.plsql.JTY_TAE_GEN_PVT.build_ilv2.others',
739: substr(errbuf, 1, 4000));
740: END IF;

Line 737: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

733: WHEN OTHERS THEN
734: RETCODE := 2;
735: ERRBUF := SQLCODE || ' : ' || SQLERRM;
736: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
737: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
738: 'jtf.plsql.JTY_TAE_GEN_PVT.build_ilv2.others',
739: substr(errbuf, 1, 4000));
740: END IF;
741:

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

829:
830: BEGIN
831:
832: -- debug message
833: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
834: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
835: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules.start',
836: 'Start of the procedure JTY_TAE_GEN_PVT.build_qualifier_rules');
837: END IF;

Line 834: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

830: BEGIN
831:
832: -- debug message
833: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
834: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
835: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules.start',
836: 'Start of the procedure JTY_TAE_GEN_PVT.build_qualifier_rules');
837: END IF;
838: -- debug message

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

835: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules.start',
836: 'Start of the procedure JTY_TAE_GEN_PVT.build_qualifier_rules');
837: END IF;
838: -- debug message
839: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
840: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
841: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules',
842: 'source_id='|| p_source_id || ',trans_id='|| p_trans_id
843: || ',qual_relation_prd='|| p_qual_relation_prd

Line 840: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

836: 'Start of the procedure JTY_TAE_GEN_PVT.build_qualifier_rules');
837: END IF;
838: -- debug message
839: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
840: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
841: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules',
842: 'source_id='|| p_source_id || ',trans_id='|| p_trans_id
843: || ',qual_relation_prd='|| p_qual_relation_prd
844: || ',relation_factor='||p_relation_factor);

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

871: IF (l_qual_usg_id_tbl.COUNT > 0) THEN
872: l_alias_rule1 := 'ABC';
873: FOR i IN l_qual_usg_id_tbl.FIRST .. l_qual_usg_id_tbl.LAST LOOP
874: -- debug message
875: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
876: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
877: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules',
878: l_counter || ',l_alias_rule1='|| l_alias_rule1
879: || ',l_alias_rule1_tbl('||i||')='|| l_alias_rule1_tbl(i)

Line 876: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

872: l_alias_rule1 := 'ABC';
873: FOR i IN l_qual_usg_id_tbl.FIRST .. l_qual_usg_id_tbl.LAST LOOP
874: -- debug message
875: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
876: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
877: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules',
878: l_counter || ',l_alias_rule1='|| l_alias_rule1
879: || ',l_alias_rule1_tbl('||i||')='|| l_alias_rule1_tbl(i)
880: || ',p_trans_table_name='|| p_trans_table_name

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

881: || ',p_denorm_table_name='|| p_denorm_table_name);
882: END IF;
883: IF (l_counter = 1) THEN
884: -- debug message
885: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
886: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
887: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules',
888: 'enter l_counter=1');
889: END IF;

Line 886: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

882: END IF;
883: IF (l_counter = 1) THEN
884: -- debug message
885: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
886: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
887: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules',
888: 'enter l_counter=1');
889: END IF;
890: l_from_str := g_new_line || p_trans_table_name || ' A ' || g_new_line || ',' || p_denorm_table_name || ' B ';

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

904: ,l_op_like_tbl(i)
905: ,l_op_between_tbl(i)
906: ,g_new_line);
907: -- debug message
908: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
909: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
910: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules',
911: 'l_predicate='||l_predicate);
912: END IF;

Line 909: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

905: ,l_op_between_tbl(i)
906: ,g_new_line);
907: -- debug message
908: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
909: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
910: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules',
911: 'l_predicate='||l_predicate);
912: END IF;
913: -- SOLIN

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

917: ELSE
918: -- SOLIN end
919: -- ELSIF l_alias_rule1 <> l_alias_rule1_tbl(i)
920: -- debug message
921: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
922: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
923: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules',
924: 'enter l_alias_rule1<>l_alias_rule1_tbl(i)');
925: END IF;

Line 922: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

918: -- SOLIN end
919: -- ELSIF l_alias_rule1 <> l_alias_rule1_tbl(i)
920: -- debug message
921: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
922: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
923: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules',
924: 'enter l_alias_rule1<>l_alias_rule1_tbl(i)');
925: END IF;
926: IF (l_alias_rule1_tbl(i) IS NOT NULL) THEN

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

934: ,l_op_like_tbl(i)
935: ,l_op_between_tbl(i)
936: ,g_new_line);
937: -- debug message
938: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
939: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
940: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules',
941: 'l_predicate='||l_predicate);
942: END IF;

Line 939: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

935: ,l_op_between_tbl(i)
936: ,g_new_line);
937: -- debug message
938: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
939: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
940: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules',
941: 'l_predicate='||l_predicate);
942: END IF;
943: END IF; /* end IF (l_counter = 1) */

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

946: END LOOP; /* end loop FOR i IN l_qual_usg_id_tbl.FIRST .. l_qual_usg_id_tbl.LAST */
947: END IF; /* end IF (l_qual_usg_id_tbl.COUNT > 0) */
948:
949: -- debug message
950: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
951: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
952: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules',
953: 'l_from_str1='|| l_from_str
954: || ',l_predicate='|| l_predicate);

Line 951: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

947: END IF; /* end IF (l_qual_usg_id_tbl.COUNT > 0) */
948:
949: -- debug message
950: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
951: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
952: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules',
953: 'l_from_str1='|| l_from_str
954: || ',l_predicate='|| l_predicate);
955: END IF;

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

961: p_qual_relation_prd => p_qual_relation_prd,
962: p_from_str => l_from_str,
963: p_new_mode_fetch => p_new_mode_fetch);
964: -- debug message
965: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
966: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
967: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules',
968: 'l_from_str2='|| l_from_str);
969: END IF;

Line 966: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

962: p_from_str => l_from_str,
963: p_new_mode_fetch => p_new_mode_fetch);
964: -- debug message
965: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
966: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
967: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules',
968: 'l_from_str2='|| l_from_str);
969: END IF;
970:

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

974: 'AND B.source_id = ' || p_source_id || g_new_line ||
975: 'AND B.trans_type_id = ' || p_trans_id;
976:
977: -- debug message
978: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
979: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
980: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules.end',
981: 'End of the procedure JTY_TAE_GEN_PVT.build_qualifier_rules');
982: END IF;

Line 979: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

975: 'AND B.trans_type_id = ' || p_trans_id;
976:
977: -- debug message
978: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
979: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
980: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules.end',
981: 'End of the procedure JTY_TAE_GEN_PVT.build_qualifier_rules');
982: END IF;
983:

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

986: EXCEPTION
987: WHEN OTHERS THEN
988: RETCODE := 2;
989: ERRBUF := SQLCODE || ' : ' || SQLERRM;
990: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
991: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
992: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules.others',
993: substr(errbuf, 1, 4000));
994: END IF;

Line 991: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

987: WHEN OTHERS THEN
988: RETCODE := 2;
989: ERRBUF := SQLCODE || ' : ' || SQLERRM;
990: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
991: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
992: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules.others',
993: substr(errbuf, 1, 4000));
994: END IF;
995:

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

1032: L_SCHEMA_NOTFOUND EXCEPTION;
1033: BEGIN
1034:
1035: -- debug message
1036: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1037: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1038: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules1.start',
1039: 'Start of the procedure JTY_TAE_GEN_PVT.build_qualifier_rules1');
1040: END IF;

Line 1037: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

1033: BEGIN
1034:
1035: -- debug message
1036: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1037: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1038: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules1.start',
1039: 'Start of the procedure JTY_TAE_GEN_PVT.build_qualifier_rules1');
1040: END IF;
1041:

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

1111: errbuf => errbuf);
1112:
1113: IF (retcode <> 0) THEN
1114: -- debug message
1115: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1116: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1117: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules1.build_ilv1',
1118: 'JTY_TAE_GEN_PVT.build_ilv1 API has failed');
1119: END IF;

Line 1116: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

1112:
1113: IF (retcode <> 0) THEN
1114: -- debug message
1115: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1116: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1117: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules1.build_ilv1',
1118: 'JTY_TAE_GEN_PVT.build_ilv1 API has failed');
1119: END IF;
1120:

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

1143: errbuf => errbuf);
1144:
1145: IF (retcode <> 0) THEN
1146: -- debug message
1147: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1148: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1149: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules1.build_qualifier_rules',
1150: 'JTY_TAE_GEN_PVT.build_qualifier_rules API has failed');
1151: END IF;

Line 1148: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

1144:
1145: IF (retcode <> 0) THEN
1146: -- debug message
1147: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1148: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1149: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules1.build_qualifier_rules',
1150: 'JTY_TAE_GEN_PVT.build_qualifier_rules API has failed');
1151: END IF;
1152:

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

1178: p_sql := p_sql || g_new_line || l_indent || ' AND ILV1.lead_id = ILV2.trans_object_id';
1179: END IF;
1180:
1181: -- debug message
1182: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1183: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1184: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules1.end',
1185: 'End of the procedure JTY_TAE_GEN_PVT.build_qualifier_rules1');
1186: END IF;

Line 1183: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

1179: END IF;
1180:
1181: -- debug message
1182: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1183: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1184: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules1.end',
1185: 'End of the procedure JTY_TAE_GEN_PVT.build_qualifier_rules1');
1186: END IF;
1187:

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

1189: errbuf := null;
1190: EXCEPTION
1191: WHEN FND_API.G_EXC_ERROR THEN
1192: RETCODE := 2;
1193: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1194: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1195: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules1.g_exc_error',
1196: 'API JTY_TAE_GEN_PVT..build_qualifier_rules1 has failed with FND_API.G_EXC_ERROR exception');
1197: END IF;

Line 1194: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

1190: EXCEPTION
1191: WHEN FND_API.G_EXC_ERROR THEN
1192: RETCODE := 2;
1193: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1194: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1195: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules1.g_exc_error',
1196: 'API JTY_TAE_GEN_PVT..build_qualifier_rules1 has failed with FND_API.G_EXC_ERROR exception');
1197: END IF;
1198:

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

1198:
1199: WHEN L_SCHEMA_NOTFOUND THEN
1200: errbuf := 'Schema name corresponding to JTF application not found';
1201: retcode := 2;
1202: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1203: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1204: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules1.l_schema_notfound',
1205: errbuf);
1206: END IF;

Line 1203: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

1199: WHEN L_SCHEMA_NOTFOUND THEN
1200: errbuf := 'Schema name corresponding to JTF application not found';
1201: retcode := 2;
1202: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1203: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1204: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules1.l_schema_notfound',
1205: errbuf);
1206: END IF;
1207:

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

1207:
1208: WHEN OTHERS THEN
1209: RETCODE := 2;
1210: ERRBUF := SQLCODE || ' : ' || SQLERRM;
1211: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1212: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1213: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules1.others',
1214: substr(errbuf, 1, 4000));
1215: END IF;

Line 1212: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

1208: WHEN OTHERS THEN
1209: RETCODE := 2;
1210: ERRBUF := SQLCODE || ' : ' || SQLERRM;
1211: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1212: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1213: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules1.others',
1214: substr(errbuf, 1, 4000));
1215: END IF;
1216:

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

1250: l_match_sql CLOB;
1251: l_sql CLOB;
1252: BEGIN
1253: -- debug message
1254: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1255: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1256: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_terr_rules_recurse.start',
1257: 'Start of the procedure JTY_TAE_GEN_PVT.gen_terr_rules_recurse');
1258: END IF;

Line 1255: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

1251: l_sql CLOB;
1252: BEGIN
1253: -- debug message
1254: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1255: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1256: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_terr_rules_recurse.start',
1257: 'Start of the procedure JTY_TAE_GEN_PVT.gen_terr_rules_recurse');
1258: END IF;
1259:

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

1266: retcode => retcode);
1267:
1268: IF (retcode <> 0) THEN
1269: -- debug message
1270: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1271: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1272: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_terr_rules_recurse.get_insert_select_nmtrans',
1273: 'JTY_TAE_GEN_PVT.get_insert_select_nmtrans API has failed');
1274: END IF;

Line 1271: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

1267:
1268: IF (retcode <> 0) THEN
1269: -- debug message
1270: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1271: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1272: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_terr_rules_recurse.get_insert_select_nmtrans',
1273: 'JTY_TAE_GEN_PVT.get_insert_select_nmtrans API has failed');
1274: END IF;
1275:

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

1394: ,errbuf => errbuf);
1395:
1396: IF (retcode <> 0) THEN
1397: -- debug message
1398: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1399: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1400: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_terr_rules_recurse.Build_Qualifier_Rules1',
1401: 'JTY_TAE_GEN_PVT.Build_Qualifier_Rules1 API has failed');
1402: END IF;

Line 1399: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

1395:
1396: IF (retcode <> 0) THEN
1397: -- debug message
1398: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1399: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1400: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_terr_rules_recurse.Build_Qualifier_Rules1',
1401: 'JTY_TAE_GEN_PVT.Build_Qualifier_Rules1 API has failed');
1402: END IF;
1403:

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

1429: ,errbuf => errbuf);
1430:
1431: IF (retcode <> 0) THEN
1432: -- debug message
1433: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1434: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1435: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_terr_rules_recurse.Build_Qualifier_Rules',
1436: 'JTY_TAE_GEN_PVT.Build_Qualifier_Rules API has failed');
1437: END IF;

Line 1434: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

1430:
1431: IF (retcode <> 0) THEN
1432: -- debug message
1433: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1434: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1435: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_terr_rules_recurse.Build_Qualifier_Rules',
1436: 'JTY_TAE_GEN_PVT.Build_Qualifier_Rules API has failed');
1437: END IF;
1438:

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

1442: l_match_sql := l_match_sql || l_sql;
1443: END IF;
1444:
1445: -- debug message
1446: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1447: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1448: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_terr_rules_recurse.end',
1449: 'End of the procedure JTY_TAE_GEN_PVT.gen_terr_rules_recurse');
1450: END IF;

Line 1447: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

1443: END IF;
1444:
1445: -- debug message
1446: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1447: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1448: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_terr_rules_recurse.end',
1449: 'End of the procedure JTY_TAE_GEN_PVT.gen_terr_rules_recurse');
1450: END IF;
1451:

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

1456:
1457: EXCEPTION
1458: WHEN FND_API.G_EXC_ERROR THEN
1459: RETCODE := 2;
1460: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1461: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1462: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_terr_rules_recurse.g_exc_error',
1463: 'API JTY_TAE_GEN_PVT.gen_terr_rules_recurse has failed with FND_API.G_EXC_ERROR exception');
1464: END IF;

Line 1461: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

1457: EXCEPTION
1458: WHEN FND_API.G_EXC_ERROR THEN
1459: RETCODE := 2;
1460: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1461: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1462: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_terr_rules_recurse.g_exc_error',
1463: 'API JTY_TAE_GEN_PVT.gen_terr_rules_recurse has failed with FND_API.G_EXC_ERROR exception');
1464: END IF;
1465:

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

1465:
1466: WHEN OTHERS THEN
1467: RETCODE := 2;
1468: ERRBUF := SQLCODE || ' : ' || SQLERRM;
1469: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1470: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1471: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_terr_rules_recurse.others',
1472: substr(errbuf, 1, 4000));
1473: END IF;

Line 1470: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

1466: WHEN OTHERS THEN
1467: RETCODE := 2;
1468: ERRBUF := SQLCODE || ' : ' || SQLERRM;
1469: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1470: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1471: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_terr_rules_recurse.others',
1472: substr(errbuf, 1, 4000));
1473: END IF;
1474: END gen_terr_rules_recurse;

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

1517:
1518: BEGIN
1519:
1520: -- debug message
1521: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1522: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1523: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_batch_sql.start',
1524: 'Start of the procedure JTY_TAE_GEN_PVT.gen_batch_sql');
1525: END IF;

Line 1522: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

1518: BEGIN
1519:
1520: -- debug message
1521: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1522: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1523: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_batch_sql.start',
1524: 'Start of the procedure JTY_TAE_GEN_PVT.gen_batch_sql');
1525: END IF;
1526:

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

1525: END IF;
1526:
1527: IF (p_qual_prd_tbl.COUNT = 0) THEN
1528: -- debug message
1529: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1530: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1531: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_batch_sql.no_qual_product',
1532: 'JTY_TAE_GEN_PVT.gen_batch_sql API has failed as there is no qual product to be processed');
1533: END IF;

Line 1530: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

1526:
1527: IF (p_qual_prd_tbl.COUNT = 0) THEN
1528: -- debug message
1529: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1530: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1531: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_batch_sql.no_qual_product',
1532: 'JTY_TAE_GEN_PVT.gen_batch_sql API has failed as there is no qual product to be processed');
1533: END IF;
1534:

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

1552: RETCODE => retcode );
1553:
1554: IF (retcode <> 0) THEN
1555: -- debug message
1556: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1557: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1558: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_batch_sql.Classify_dea_Territories',
1559: 'jty_tae_control_pvt.Classify_dea_Territories API has failed');
1560: END IF;

Line 1557: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

1553:
1554: IF (retcode <> 0) THEN
1555: -- debug message
1556: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1557: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1558: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_batch_sql.Classify_dea_Territories',
1559: 'jty_tae_control_pvt.Classify_dea_Territories API has failed');
1560: END IF;
1561:

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

1579: RETCODE => retcode );
1580:
1581: IF (retcode <> 0) THEN
1582: -- debug message
1583: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1584: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1585: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_batch_sql.Classify_Territories',
1586: 'jty_tae_control_pvt.Classify_Territories API has failed');
1587: END IF;

Line 1584: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

1580:
1581: IF (retcode <> 0) THEN
1582: -- debug message
1583: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1584: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1585: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_batch_sql.Classify_Territories',
1586: 'jty_tae_control_pvt.Classify_Territories API has failed');
1587: END IF;
1588:

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

1637: errbuf => errbuf);
1638:
1639: IF (retcode <> 0) THEN
1640: -- debug message
1641: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1642: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1643: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_batch_sql.gen_terr_rules_recurse1',
1644: 'JTY_TAE_GEN_PVT.gen_terr_rules_recurse API has failed');
1645: END IF;

Line 1642: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

1638:
1639: IF (retcode <> 0) THEN
1640: -- debug message
1641: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1642: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1643: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_batch_sql.gen_terr_rules_recurse1',
1644: 'JTY_TAE_GEN_PVT.gen_terr_rules_recurse API has failed');
1645: END IF;
1646:

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

1663: errbuf => errbuf);
1664:
1665: IF (retcode <> 0) THEN
1666: -- debug message
1667: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1668: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1669: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_batch_sql.gen_terr_rules_recurse2',
1670: 'JTY_TAE_GEN_PVT.gen_terr_rules_recurse API has failed');
1671: END IF;

Line 1668: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

1664:
1665: IF (retcode <> 0) THEN
1666: -- debug message
1667: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1668: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1669: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_batch_sql.gen_terr_rules_recurse2',
1670: 'JTY_TAE_GEN_PVT.gen_terr_rules_recurse API has failed');
1671: END IF;
1672:

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

1688: errbuf => errbuf);
1689:
1690: IF (retcode <> 0) THEN
1691: -- debug message
1692: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1693: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1694: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_batch_sql.gen_terr_rules_recurse3',
1695: 'JTY_TAE_GEN_PVT.gen_terr_rules_recurse API has failed');
1696: END IF;

Line 1693: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

1689:
1690: IF (retcode <> 0) THEN
1691: -- debug message
1692: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1693: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1694: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_batch_sql.gen_terr_rules_recurse3',
1695: 'JTY_TAE_GEN_PVT.gen_terr_rules_recurse API has failed');
1696: END IF;
1697:

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

1784: END LOOP; /* end loop FOR i IN l_pgm_name_tbl.FIRST .. l_pgm_name_tbl.LAST */
1785: END IF; /* end IF (l_pgm_name_tbl.COUNT > 0) */
1786:
1787: -- debug message
1788: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1789: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1790: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_batch_sql.end',
1791: 'End of the procedure JTY_TAE_GEN_PVT.gen_batch_sql');
1792: END IF;

Line 1789: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

1785: END IF; /* end IF (l_pgm_name_tbl.COUNT > 0) */
1786:
1787: -- debug message
1788: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1789: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1790: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_batch_sql.end',
1791: 'End of the procedure JTY_TAE_GEN_PVT.gen_batch_sql');
1792: END IF;
1793:

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

1796:
1797: EXCEPTION
1798: WHEN FND_API.G_EXC_ERROR THEN
1799: RETCODE := 2;
1800: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1801: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1802: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_batch_sql.g_exc_error',
1803: 'API JTY_TAE_GEN_PVT.gen_batch_sql has failed with FND_API.G_EXC_ERROR exception');
1804: END IF;

Line 1801: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

1797: EXCEPTION
1798: WHEN FND_API.G_EXC_ERROR THEN
1799: RETCODE := 2;
1800: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1801: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1802: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_batch_sql.g_exc_error',
1803: 'API JTY_TAE_GEN_PVT.gen_batch_sql has failed with FND_API.G_EXC_ERROR exception');
1804: END IF;
1805:

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

1805:
1806: WHEN OTHERS THEN
1807: RETCODE := 2;
1808: ERRBUF := SQLCODE || ' : ' || SQLERRM;
1809: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1810: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1811: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_batch_sql.others',
1812: substr(errbuf, 1, 4000));
1813: END IF;

Line 1810: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

1806: WHEN OTHERS THEN
1807: RETCODE := 2;
1808: ERRBUF := SQLCODE || ' : ' || SQLERRM;
1809: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1810: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1811: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_batch_sql.others',
1812: substr(errbuf, 1, 4000));
1813: END IF;
1814: END gen_batch_sql;