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 JTY_TAE_GEN_PVT

Line 1: PACKAGE BODY JTY_TAE_GEN_PVT AS

1: PACKAGE BODY JTY_TAE_GEN_PVT AS
2: /* $Header: jtfytaeb.pls 120.15 2011/04/26 09:08:30 sseshaiy ship $ */
3: -- Start of Comments
4: -- ---------------------------------------------------
5: -- PACKAGE NAME: JTY_TAE_GEN_PVT

Line 5: -- PACKAGE NAME: JTY_TAE_GEN_PVT

1: PACKAGE BODY JTY_TAE_GEN_PVT AS
2: /* $Header: jtfytaeb.pls 120.15 2011/04/26 09:08:30 sseshaiy ship $ */
3: -- Start of Comments
4: -- ---------------------------------------------------
5: -- PACKAGE NAME: JTY_TAE_GEN_PVT
6: -- ---------------------------------------------------
7: -- PURPOSE
8: -- This package is used to generate the batch matching SQLs for all qualifier combinations.
9: --

Line 96: 'jtf.plsql.JTY_TAE_GEN_PVT.build_predicate_for_operator.others',

92:
93: EXCEPTION
94: WHEN OTHERS THEN
95: jty_log(FND_LOG.LEVEL_EXCEPTION,
96: 'jtf.plsql.JTY_TAE_GEN_PVT.build_predicate_for_operator.others',
97: substr(SQLCODE || ' : ' || SQLERRM, 1, 4000));
98: RAISE;
99: END build_predicate_for_operator;
100:

Line 206: 'jtf.plsql.JTY_TAE_GEN_PVT.append_inlineview.others',

202:
203: EXCEPTION
204: WHEN OTHERS THEN
205: jty_log(FND_LOG.LEVEL_EXCEPTION,
206: 'jtf.plsql.JTY_TAE_GEN_PVT.append_inlineview.others',
207: substr(SQLCODE || ' : ' || SQLERRM, 1, 4000));
208: RAISE;
209:
210: END append_inlineview;

Line 240: 'jtf.plsql.JTY_TAE_GEN_PVT.get_insert_select_nmtrans.start',

236: BEGIN
237:
238: -- debug message
239: jty_log(FND_LOG.LEVEL_PROCEDURE,
240: 'jtf.plsql.JTY_TAE_GEN_PVT.get_insert_select_nmtrans.start',
241: 'Start of the procedure JTY_TAE_GEN_PVT.get_insert_select_nmtrans ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
242:
243: /* Get the schema name corresponding to JTF application */
244: IF (FND_INSTALLATION.GET_APP_INFO('JTF', l_status, l_industry, l_owner)) THEN

Line 241: 'Start of the procedure JTY_TAE_GEN_PVT.get_insert_select_nmtrans ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

237:
238: -- debug message
239: jty_log(FND_LOG.LEVEL_PROCEDURE,
240: 'jtf.plsql.JTY_TAE_GEN_PVT.get_insert_select_nmtrans.start',
241: 'Start of the procedure JTY_TAE_GEN_PVT.get_insert_select_nmtrans ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
242:
243: /* Get the schema name corresponding to JTF application */
244: IF (FND_INSTALLATION.GET_APP_INFO('JTF', l_status, l_industry, l_owner)) THEN
245: NULL;

Line 296: 'jtf.plsql.JTY_TAE_GEN_PVT.get_insert_select_nmtrans.end',

292: ' FROM ';
293:
294: -- debug message
295: jty_log(FND_LOG.LEVEL_PROCEDURE,
296: 'jtf.plsql.JTY_TAE_GEN_PVT.get_insert_select_nmtrans.end',
297: 'End of the procedure JTY_TAE_GEN_PVT.get_insert_select_nmtrans ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
298:
299: retcode := 0;
300: errbuf := null;

Line 297: 'End of the procedure JTY_TAE_GEN_PVT.get_insert_select_nmtrans ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

293:
294: -- debug message
295: jty_log(FND_LOG.LEVEL_PROCEDURE,
296: 'jtf.plsql.JTY_TAE_GEN_PVT.get_insert_select_nmtrans.end',
297: 'End of the procedure JTY_TAE_GEN_PVT.get_insert_select_nmtrans ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
298:
299: retcode := 0;
300: errbuf := null;
301:

Line 307: 'jtf.plsql.JTY_TAE_GEN_PVT.get_insert_select_nmtrans.l_schema_notfound',

303: WHEN L_SCHEMA_NOTFOUND THEN
304: errbuf := 'Schema name corresponding to JTF application not found';
305: retcode := 2;
306: jty_log(FND_LOG.LEVEL_EXCEPTION,
307: 'jtf.plsql.JTY_TAE_GEN_PVT.get_insert_select_nmtrans.l_schema_notfound',
308: errbuf);
309:
310: WHEN OTHERS THEN
311: RETCODE := 2;

Line 314: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_batch_sql.others',

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

Line 404: 'jtf.plsql.JTY_TAE_GEN_PVT.build_ilv1.start',

400: BEGIN
401:
402: -- debug message
403: jty_log(FND_LOG.LEVEL_PROCEDURE,
404: 'jtf.plsql.JTY_TAE_GEN_PVT.build_ilv1.start',
405: 'Start of the procedure JTY_TAE_GEN_PVT.build_ilv1 ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
406:
407: IF ((p_mode = 'DATE EFFECTIVE') or (p_mode = 'DEA INCREMENTAL')) THEN
408: OPEN c_dea_rel_prod_detail(p_source_id, p_trans_id, p_qual_relation_prd, p_relation_factor);

Line 405: 'Start of the procedure JTY_TAE_GEN_PVT.build_ilv1 ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

401:
402: -- debug message
403: jty_log(FND_LOG.LEVEL_PROCEDURE,
404: 'jtf.plsql.JTY_TAE_GEN_PVT.build_ilv1.start',
405: 'Start of the procedure JTY_TAE_GEN_PVT.build_ilv1 ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
406:
407: IF ((p_mode = 'DATE EFFECTIVE') or (p_mode = 'DEA INCREMENTAL')) THEN
408: OPEN c_dea_rel_prod_detail(p_source_id, p_trans_id, p_qual_relation_prd, p_relation_factor);
409: FETCH c_dea_rel_prod_detail BULK COLLECT INTO

Line 515: 'jtf.plsql.JTY_TAE_GEN_PVT.build_ilv1.end',

511: l_predicate;
512:
513: -- debug message
514: jty_log(FND_LOG.LEVEL_PROCEDURE,
515: 'jtf.plsql.JTY_TAE_GEN_PVT.build_ilv1.end',
516: 'End of the procedure JTY_TAE_GEN_PVT.build_ilv1 ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
517:
518: retcode := 0;
519: errbuf := null;

Line 516: 'End of the procedure JTY_TAE_GEN_PVT.build_ilv1 ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

512:
513: -- debug message
514: jty_log(FND_LOG.LEVEL_PROCEDURE,
515: 'jtf.plsql.JTY_TAE_GEN_PVT.build_ilv1.end',
516: 'End of the procedure JTY_TAE_GEN_PVT.build_ilv1 ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
517:
518: retcode := 0;
519: errbuf := null;
520:

Line 526: 'jtf.plsql.JTY_TAE_GEN_PVT.build_ilv1.others',

522: WHEN OTHERS THEN
523: RETCODE := 2;
524: ERRBUF := SQLCODE || ' : ' || SQLERRM;
525: jty_log(FND_LOG.LEVEL_EXCEPTION,
526: 'jtf.plsql.JTY_TAE_GEN_PVT.build_ilv1.others',
527: substr(errbuf, 1, 4000));
528:
529: END build_ilv1;
530:

Line 621: 'jtf.plsql.JTY_TAE_GEN_PVT.build_ilv2.start',

617: BEGIN
618:
619: -- debug message
620: jty_log(FND_LOG.LEVEL_PROCEDURE,
621: 'jtf.plsql.JTY_TAE_GEN_PVT.build_ilv2.start',
622: 'Start of the procedure JTY_TAE_GEN_PVT.build_ilv2 ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
623:
624: l_relation_product := p_qual_relation_prd/p_relation_factor;
625: l_counter := 1;

Line 622: 'Start of the procedure JTY_TAE_GEN_PVT.build_ilv2 ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

618:
619: -- debug message
620: jty_log(FND_LOG.LEVEL_PROCEDURE,
621: 'jtf.plsql.JTY_TAE_GEN_PVT.build_ilv2.start',
622: 'Start of the procedure JTY_TAE_GEN_PVT.build_ilv2 ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
623:
624: l_relation_product := p_qual_relation_prd/p_relation_factor;
625: l_counter := 1;
626:

Line 718: 'jtf.plsql.JTY_TAE_GEN_PVT.build_ilv2.end',

714: 'AND B.trans_type_id = ' || p_trans_id;
715:
716: -- debug message
717: jty_log(FND_LOG.LEVEL_PROCEDURE,
718: 'jtf.plsql.JTY_TAE_GEN_PVT.build_ilv2.end',
719: 'End of the procedure JTY_TAE_GEN_PVT.build_ilv2 ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
720:
721: retcode := 0;
722: errbuf := null;

Line 719: 'End of the procedure JTY_TAE_GEN_PVT.build_ilv2 ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

715:
716: -- debug message
717: jty_log(FND_LOG.LEVEL_PROCEDURE,
718: 'jtf.plsql.JTY_TAE_GEN_PVT.build_ilv2.end',
719: 'End of the procedure JTY_TAE_GEN_PVT.build_ilv2 ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
720:
721: retcode := 0;
722: errbuf := null;
723: EXCEPTION

Line 728: 'jtf.plsql.JTY_TAE_GEN_PVT.build_ilv2.others',

724: WHEN OTHERS THEN
725: RETCODE := 2;
726: ERRBUF := SQLCODE || ' : ' || SQLERRM;
727: jty_log(FND_LOG.LEVEL_EXCEPTION,
728: 'jtf.plsql.JTY_TAE_GEN_PVT.build_ilv2.others',
729: substr(errbuf, 1, 4000));
730:
731: END build_ilv2;
732:

Line 823: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules.start',

819: BEGIN
820:
821: -- debug message
822: jty_log(FND_LOG.LEVEL_PROCEDURE,
823: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules.start',
824: 'Start of the procedure JTY_TAE_GEN_PVT.build_qualifier_rules ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
825: -- debug message
826: jty_log(FND_LOG.LEVEL_PROCEDURE,
827: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules',

Line 824: 'Start of the procedure JTY_TAE_GEN_PVT.build_qualifier_rules ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

820:
821: -- debug message
822: jty_log(FND_LOG.LEVEL_PROCEDURE,
823: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules.start',
824: 'Start of the procedure JTY_TAE_GEN_PVT.build_qualifier_rules ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
825: -- debug message
826: jty_log(FND_LOG.LEVEL_PROCEDURE,
827: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules',
828: 'source_id='|| p_source_id || ',trans_id='|| p_trans_id

Line 827: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules',

823: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules.start',
824: 'Start of the procedure JTY_TAE_GEN_PVT.build_qualifier_rules ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
825: -- debug message
826: jty_log(FND_LOG.LEVEL_PROCEDURE,
827: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules',
828: 'source_id='|| p_source_id || ',trans_id='|| p_trans_id
829: || ',qual_relation_prd='|| p_qual_relation_prd
830: || ',relation_factor='||p_relation_factor);
831:

Line 861: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules',

857: l_alias_rule1 := 'ABC';
858: FOR i IN l_qual_usg_id_tbl.FIRST .. l_qual_usg_id_tbl.LAST LOOP
859: -- debug message
860: jty_log(FND_LOG.LEVEL_PROCEDURE,
861: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules',
862: l_counter || ',l_alias_rule1='|| l_alias_rule1
863: || ',l_alias_rule1_tbl('||i||')='|| l_alias_rule1_tbl(i)
864: || ',p_trans_table_name='|| p_trans_table_name
865: || ',p_denorm_table_name='|| p_denorm_table_name);

Line 869: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules',

865: || ',p_denorm_table_name='|| p_denorm_table_name);
866: IF (l_counter = 1) THEN
867: -- debug message
868: jty_log(FND_LOG.LEVEL_PROCEDURE,
869: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules',
870: 'enter l_counter=1');
871: l_from_str := g_new_line || p_trans_table_name || ' A ' || g_new_line || ',' || p_denorm_table_name || ' B ';
872: IF (l_alias_rule1_tbl(i) IS NOT NULL) THEN
873: l_from_str := l_from_str || g_new_line || ',' || l_alias_rule1_tbl(i);

Line 890: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules',

886: ,l_op_between_tbl(i)
887: ,g_new_line);
888: -- debug message
889: jty_log(FND_LOG.LEVEL_PROCEDURE,
890: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules',
891: 'l_predicate='||l_predicate);
892: -- SOLIN
893: ELSIF l_alias_rule1 = l_alias_rule1_tbl(i)
894: THEN

Line 901: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules',

897: -- SOLIN end
898: -- ELSIF l_alias_rule1 <> l_alias_rule1_tbl(i)
899: -- debug message
900: jty_log(FND_LOG.LEVEL_PROCEDURE,
901: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules',
902: 'enter l_alias_rule1<>l_alias_rule1_tbl(i)');
903: IF (l_alias_rule1_tbl(i) IS NOT NULL) THEN
904: l_from_str := l_from_str || g_new_line || ',' || l_alias_rule1_tbl(i);
905: END IF;

Line 916: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules',

912: ,l_op_between_tbl(i)
913: ,g_new_line);
914: -- debug message
915: jty_log(FND_LOG.LEVEL_PROCEDURE,
916: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules',
917: 'l_predicate='||l_predicate);
918: END IF; /* end IF (l_counter = 1) */
919: l_counter := l_counter + 1;
920: l_alias_rule1 := l_alias_rule1_tbl(i);

Line 926: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules',

922: END IF; /* end IF (l_qual_usg_id_tbl.COUNT > 0) */
923:
924: -- debug message
925: jty_log(FND_LOG.LEVEL_PROCEDURE,
926: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules',
927: 'l_from_str1='|| l_from_str
928: || ',l_predicate='|| l_predicate);
929: l_from_str :=
930: append_inlineview(

Line 939: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules',

935: p_from_str => l_from_str,
936: p_new_mode_fetch => p_new_mode_fetch);
937: -- debug message
938: jty_log(FND_LOG.LEVEL_PROCEDURE,
939: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules',
940: 'l_from_str2='|| l_from_str);
941:
942: p_sql := l_from_str || g_new_line || l_where_str || g_new_line || l_predicate || g_new_line ||
943: 'AND ILV.terr_id = B.terr_id ' || g_new_line ||

Line 950: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules.end',

946: 'AND B.trans_type_id = ' || p_trans_id;
947:
948: -- debug message
949: jty_log(FND_LOG.LEVEL_PROCEDURE,
950: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules.end',
951: 'End of the procedure JTY_TAE_GEN_PVT.build_qualifier_rules ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
952:
953: retcode := 0;
954: errbuf := null;

Line 951: 'End of the procedure JTY_TAE_GEN_PVT.build_qualifier_rules ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

947:
948: -- debug message
949: jty_log(FND_LOG.LEVEL_PROCEDURE,
950: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules.end',
951: 'End of the procedure JTY_TAE_GEN_PVT.build_qualifier_rules ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
952:
953: retcode := 0;
954: errbuf := null;
955: EXCEPTION

Line 960: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules.others',

956: WHEN OTHERS THEN
957: RETCODE := 2;
958: ERRBUF := SQLCODE || ' : ' || SQLERRM;
959: jty_log(FND_LOG.LEVEL_EXCEPTION,
960: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules.others',
961: substr(errbuf, 1, 4000));
962:
963: END build_qualifier_rules;
964:

Line 1004: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules1.start',

1000: BEGIN
1001:
1002: -- debug message
1003: jty_log(FND_LOG.LEVEL_PROCEDURE,
1004: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules1.start',
1005: 'Start of the procedure JTY_TAE_GEN_PVT.build_qualifier_rules1 ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1006:
1007: IF mod(p_qual_relation_prd,79) = 0 THEN
1008: l_rel_prod1 := 79;

Line 1005: 'Start of the procedure JTY_TAE_GEN_PVT.build_qualifier_rules1 ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

1001:
1002: -- debug message
1003: jty_log(FND_LOG.LEVEL_PROCEDURE,
1004: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules1.start',
1005: 'Start of the procedure JTY_TAE_GEN_PVT.build_qualifier_rules1 ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1006:
1007: IF mod(p_qual_relation_prd,79) = 0 THEN
1008: l_rel_prod1 := 79;
1009: ELSIF mod(p_qual_relation_prd,137) = 0 THEN

Line 1081: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules1.build_ilv1',

1077:
1078: IF (retcode <> 0) THEN
1079: -- debug message
1080: jty_log(FND_LOG.LEVEL_EXCEPTION,
1081: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules1.build_ilv1',
1082: 'JTY_TAE_GEN_PVT.build_ilv1 API has failed');
1083:
1084: RAISE FND_API.G_EXC_ERROR;
1085: END IF;

Line 1082: 'JTY_TAE_GEN_PVT.build_ilv1 API has failed');

1078: IF (retcode <> 0) THEN
1079: -- debug message
1080: jty_log(FND_LOG.LEVEL_EXCEPTION,
1081: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules1.build_ilv1',
1082: 'JTY_TAE_GEN_PVT.build_ilv1 API has failed');
1083:
1084: RAISE FND_API.G_EXC_ERROR;
1085: END IF;
1086:

Line 1111: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules1.build_qualifier_rules',

1107:
1108: IF (retcode <> 0) THEN
1109: -- debug message
1110: jty_log(FND_LOG.LEVEL_EXCEPTION,
1111: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules1.build_qualifier_rules',
1112: 'JTY_TAE_GEN_PVT.build_qualifier_rules API has failed');
1113:
1114: RAISE FND_API.G_EXC_ERROR;
1115: END IF;

Line 1112: 'JTY_TAE_GEN_PVT.build_qualifier_rules API has failed');

1108: IF (retcode <> 0) THEN
1109: -- debug message
1110: jty_log(FND_LOG.LEVEL_EXCEPTION,
1111: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules1.build_qualifier_rules',
1112: 'JTY_TAE_GEN_PVT.build_qualifier_rules API has failed');
1113:
1114: RAISE FND_API.G_EXC_ERROR;
1115: END IF;
1116:

Line 1144: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules1.end',

1140: END IF;
1141:
1142: -- debug message
1143: jty_log(FND_LOG.LEVEL_PROCEDURE,
1144: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules1.end',
1145: 'End of the procedure JTY_TAE_GEN_PVT.build_qualifier_rules1 ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1146:
1147: retcode := 0;
1148: errbuf := null;

Line 1145: 'End of the procedure JTY_TAE_GEN_PVT.build_qualifier_rules1 ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

1141:
1142: -- debug message
1143: jty_log(FND_LOG.LEVEL_PROCEDURE,
1144: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules1.end',
1145: 'End of the procedure JTY_TAE_GEN_PVT.build_qualifier_rules1 ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1146:
1147: retcode := 0;
1148: errbuf := null;
1149: EXCEPTION

Line 1153: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules1.g_exc_error',

1149: EXCEPTION
1150: WHEN FND_API.G_EXC_ERROR THEN
1151: RETCODE := 2;
1152: jty_log(FND_LOG.LEVEL_EXCEPTION,
1153: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules1.g_exc_error',
1154: 'API JTY_TAE_GEN_PVT..build_qualifier_rules1 has failed with FND_API.G_EXC_ERROR exception');
1155:
1156: WHEN L_SCHEMA_NOTFOUND THEN
1157: errbuf := 'Schema name corresponding to JTF application not found';

Line 1154: 'API JTY_TAE_GEN_PVT..build_qualifier_rules1 has failed with FND_API.G_EXC_ERROR exception');

1150: WHEN FND_API.G_EXC_ERROR THEN
1151: RETCODE := 2;
1152: jty_log(FND_LOG.LEVEL_EXCEPTION,
1153: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules1.g_exc_error',
1154: 'API JTY_TAE_GEN_PVT..build_qualifier_rules1 has failed with FND_API.G_EXC_ERROR exception');
1155:
1156: WHEN L_SCHEMA_NOTFOUND THEN
1157: errbuf := 'Schema name corresponding to JTF application not found';
1158: retcode := 2;

Line 1160: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules1.l_schema_notfound',

1156: WHEN L_SCHEMA_NOTFOUND THEN
1157: errbuf := 'Schema name corresponding to JTF application not found';
1158: retcode := 2;
1159: jty_log(FND_LOG.LEVEL_EXCEPTION,
1160: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules1.l_schema_notfound',
1161: errbuf);
1162:
1163: WHEN OTHERS THEN
1164: RETCODE := 2;

Line 1167: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules1.others',

1163: WHEN OTHERS THEN
1164: RETCODE := 2;
1165: ERRBUF := SQLCODE || ' : ' || SQLERRM;
1166: jty_log(FND_LOG.LEVEL_EXCEPTION,
1167: 'jtf.plsql.JTY_TAE_GEN_PVT.build_qualifier_rules1.others',
1168: substr(errbuf, 1, 4000));
1169:
1170: END build_qualifier_rules1;
1171:

Line 1208: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_terr_rules_recurse.start',

1204: l_sql CLOB;
1205: BEGIN
1206: -- debug message
1207: jty_log(FND_LOG.LEVEL_PROCEDURE,
1208: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_terr_rules_recurse.start',
1209: 'Start of the procedure JTY_TAE_GEN_PVT.gen_terr_rules_recurse ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1210:
1211: IF (p_new_mode_fetch = 'Y') THEN
1212: get_insert_select_nmtrans(

Line 1209: 'Start of the procedure JTY_TAE_GEN_PVT.gen_terr_rules_recurse ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

1205: BEGIN
1206: -- debug message
1207: jty_log(FND_LOG.LEVEL_PROCEDURE,
1208: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_terr_rules_recurse.start',
1209: 'Start of the procedure JTY_TAE_GEN_PVT.gen_terr_rules_recurse ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1210:
1211: IF (p_new_mode_fetch = 'Y') THEN
1212: get_insert_select_nmtrans(
1213: p_match_table_name => p_match_table_name,

Line 1222: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_terr_rules_recurse.get_insert_select_nmtrans',

1218:
1219: IF (retcode <> 0) THEN
1220: -- debug message
1221: jty_log(FND_LOG.LEVEL_EXCEPTION,
1222: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_terr_rules_recurse.get_insert_select_nmtrans',
1223: 'JTY_TAE_GEN_PVT.get_insert_select_nmtrans API has failed');
1224:
1225: RAISE FND_API.G_EXC_ERROR;
1226: END IF;

Line 1223: 'JTY_TAE_GEN_PVT.get_insert_select_nmtrans API has failed');

1219: IF (retcode <> 0) THEN
1220: -- debug message
1221: jty_log(FND_LOG.LEVEL_EXCEPTION,
1222: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_terr_rules_recurse.get_insert_select_nmtrans',
1223: 'JTY_TAE_GEN_PVT.get_insert_select_nmtrans API has failed');
1224:
1225: RAISE FND_API.G_EXC_ERROR;
1226: END IF;
1227:

Line 1348: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_terr_rules_recurse.Build_Qualifier_Rules1',

1344:
1345: IF (retcode <> 0) THEN
1346: -- debug message
1347: jty_log(FND_LOG.LEVEL_EXCEPTION,
1348: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_terr_rules_recurse.Build_Qualifier_Rules1',
1349: 'JTY_TAE_GEN_PVT.Build_Qualifier_Rules1 API has failed');
1350:
1351: RAISE FND_API.G_EXC_ERROR;
1352: END IF;

Line 1349: 'JTY_TAE_GEN_PVT.Build_Qualifier_Rules1 API has failed');

1345: IF (retcode <> 0) THEN
1346: -- debug message
1347: jty_log(FND_LOG.LEVEL_EXCEPTION,
1348: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_terr_rules_recurse.Build_Qualifier_Rules1',
1349: 'JTY_TAE_GEN_PVT.Build_Qualifier_Rules1 API has failed');
1350:
1351: RAISE FND_API.G_EXC_ERROR;
1352: END IF;
1353:

Line 1381: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_terr_rules_recurse.Build_Qualifier_Rules',

1377:
1378: IF (retcode <> 0) THEN
1379: -- debug message
1380: jty_log(FND_LOG.LEVEL_EXCEPTION,
1381: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_terr_rules_recurse.Build_Qualifier_Rules',
1382: 'JTY_TAE_GEN_PVT.Build_Qualifier_Rules API has failed');
1383:
1384: RAISE FND_API.G_EXC_ERROR;
1385: END IF;

Line 1382: 'JTY_TAE_GEN_PVT.Build_Qualifier_Rules API has failed');

1378: IF (retcode <> 0) THEN
1379: -- debug message
1380: jty_log(FND_LOG.LEVEL_EXCEPTION,
1381: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_terr_rules_recurse.Build_Qualifier_Rules',
1382: 'JTY_TAE_GEN_PVT.Build_Qualifier_Rules API has failed');
1383:
1384: RAISE FND_API.G_EXC_ERROR;
1385: END IF;
1386:

Line 1392: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_terr_rules_recurse.end',

1388: END IF;
1389:
1390: -- debug message
1391: jty_log(FND_LOG.LEVEL_PROCEDURE,
1392: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_terr_rules_recurse.end',
1393: 'End of the procedure JTY_TAE_GEN_PVT.gen_terr_rules_recurse ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1394:
1395: p_match_sql := l_match_sql;
1396:

Line 1393: 'End of the procedure JTY_TAE_GEN_PVT.gen_terr_rules_recurse ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

1389:
1390: -- debug message
1391: jty_log(FND_LOG.LEVEL_PROCEDURE,
1392: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_terr_rules_recurse.end',
1393: 'End of the procedure JTY_TAE_GEN_PVT.gen_terr_rules_recurse ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1394:
1395: p_match_sql := l_match_sql;
1396:
1397: retcode := 0;

Line 1404: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_terr_rules_recurse.g_exc_error',

1400: EXCEPTION
1401: WHEN FND_API.G_EXC_ERROR THEN
1402: RETCODE := 2;
1403: jty_log(FND_LOG.LEVEL_EXCEPTION,
1404: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_terr_rules_recurse.g_exc_error',
1405: 'API JTY_TAE_GEN_PVT.gen_terr_rules_recurse has failed with FND_API.G_EXC_ERROR exception');
1406:
1407: WHEN OTHERS THEN
1408: RETCODE := 2;

Line 1405: 'API JTY_TAE_GEN_PVT.gen_terr_rules_recurse has failed with FND_API.G_EXC_ERROR exception');

1401: WHEN FND_API.G_EXC_ERROR THEN
1402: RETCODE := 2;
1403: jty_log(FND_LOG.LEVEL_EXCEPTION,
1404: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_terr_rules_recurse.g_exc_error',
1405: 'API JTY_TAE_GEN_PVT.gen_terr_rules_recurse has failed with FND_API.G_EXC_ERROR exception');
1406:
1407: WHEN OTHERS THEN
1408: RETCODE := 2;
1409: ERRBUF := SQLCODE || ' : ' || SQLERRM;

Line 1411: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_terr_rules_recurse.others',

1407: WHEN OTHERS THEN
1408: RETCODE := 2;
1409: ERRBUF := SQLCODE || ' : ' || SQLERRM;
1410: jty_log(FND_LOG.LEVEL_EXCEPTION,
1411: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_terr_rules_recurse.others',
1412: substr(errbuf, 1, 4000));
1413:
1414: END gen_terr_rules_recurse;
1415:

Line 1463: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_batch_sql.start',

1459: BEGIN
1460:
1461: -- debug message
1462: jty_log(FND_LOG.LEVEL_PROCEDURE,
1463: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_batch_sql.start',
1464: 'Start of the procedure JTY_TAE_GEN_PVT.gen_batch_sql ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1465:
1466: IF (p_qual_prd_tbl.COUNT = 0) THEN
1467: -- debug message

Line 1464: 'Start of the procedure JTY_TAE_GEN_PVT.gen_batch_sql ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

1460:
1461: -- debug message
1462: jty_log(FND_LOG.LEVEL_PROCEDURE,
1463: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_batch_sql.start',
1464: 'Start of the procedure JTY_TAE_GEN_PVT.gen_batch_sql ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1465:
1466: IF (p_qual_prd_tbl.COUNT = 0) THEN
1467: -- debug message
1468: jty_log(FND_LOG.LEVEL_EXCEPTION,

Line 1469: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_batch_sql.no_qual_product',

1465:
1466: IF (p_qual_prd_tbl.COUNT = 0) THEN
1467: -- debug message
1468: jty_log(FND_LOG.LEVEL_EXCEPTION,
1469: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_batch_sql.no_qual_product',
1470: 'JTY_TAE_GEN_PVT.gen_batch_sql API has failed as there is no qual product to be processed');
1471:
1472: RAISE FND_API.G_EXC_ERROR;
1473: END IF;

Line 1470: 'JTY_TAE_GEN_PVT.gen_batch_sql API has failed as there is no qual product to be processed');

1466: IF (p_qual_prd_tbl.COUNT = 0) THEN
1467: -- debug message
1468: jty_log(FND_LOG.LEVEL_EXCEPTION,
1469: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_batch_sql.no_qual_product',
1470: 'JTY_TAE_GEN_PVT.gen_batch_sql API has failed as there is no qual product to be processed');
1471:
1472: RAISE FND_API.G_EXC_ERROR;
1473: END IF;
1474:

Line 1494: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_batch_sql.Classify_dea_Territories',

1490:
1491: IF (retcode <> 0) THEN
1492: -- debug message
1493: jty_log(FND_LOG.LEVEL_EXCEPTION,
1494: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_batch_sql.Classify_dea_Territories',
1495: 'jty_tae_control_pvt.Classify_dea_Territories API has failed');
1496:
1497: RAISE FND_API.G_EXC_ERROR;
1498: END IF;

Line 1519: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_batch_sql.Classify_Territories',

1515:
1516: IF (retcode <> 0) THEN
1517: -- debug message
1518: jty_log(FND_LOG.LEVEL_EXCEPTION,
1519: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_batch_sql.Classify_Territories',
1520: 'jty_tae_control_pvt.Classify_Territories API has failed');
1521:
1522: RAISE FND_API.G_EXC_ERROR;
1523: END IF;

Line 1575: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_batch_sql.gen_terr_rules_recurse1',

1571:
1572: IF (retcode <> 0) THEN
1573: -- debug message
1574: jty_log(FND_LOG.LEVEL_EXCEPTION,
1575: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_batch_sql.gen_terr_rules_recurse1',
1576: 'JTY_TAE_GEN_PVT.gen_terr_rules_recurse API has failed');
1577:
1578: RAISE FND_API.G_EXC_ERROR;
1579: END IF;

Line 1576: 'JTY_TAE_GEN_PVT.gen_terr_rules_recurse API has failed');

1572: IF (retcode <> 0) THEN
1573: -- debug message
1574: jty_log(FND_LOG.LEVEL_EXCEPTION,
1575: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_batch_sql.gen_terr_rules_recurse1',
1576: 'JTY_TAE_GEN_PVT.gen_terr_rules_recurse API has failed');
1577:
1578: RAISE FND_API.G_EXC_ERROR;
1579: END IF;
1580:

Line 1599: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_batch_sql.gen_terr_rules_recurse2',

1595:
1596: IF (retcode <> 0) THEN
1597: -- debug message
1598: jty_log(FND_LOG.LEVEL_EXCEPTION,
1599: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_batch_sql.gen_terr_rules_recurse2',
1600: 'JTY_TAE_GEN_PVT.gen_terr_rules_recurse API has failed');
1601:
1602: RAISE FND_API.G_EXC_ERROR;
1603: END IF;

Line 1600: 'JTY_TAE_GEN_PVT.gen_terr_rules_recurse API has failed');

1596: IF (retcode <> 0) THEN
1597: -- debug message
1598: jty_log(FND_LOG.LEVEL_EXCEPTION,
1599: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_batch_sql.gen_terr_rules_recurse2',
1600: 'JTY_TAE_GEN_PVT.gen_terr_rules_recurse API has failed');
1601:
1602: RAISE FND_API.G_EXC_ERROR;
1603: END IF;
1604:

Line 1622: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_batch_sql.gen_terr_rules_recurse3',

1618:
1619: IF (retcode <> 0) THEN
1620: -- debug message
1621: jty_log(FND_LOG.LEVEL_EXCEPTION,
1622: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_batch_sql.gen_terr_rules_recurse3',
1623: 'JTY_TAE_GEN_PVT.gen_terr_rules_recurse API has failed');
1624:
1625: RAISE FND_API.G_EXC_ERROR;
1626: END IF;

Line 1623: 'JTY_TAE_GEN_PVT.gen_terr_rules_recurse API has failed');

1619: IF (retcode <> 0) THEN
1620: -- debug message
1621: jty_log(FND_LOG.LEVEL_EXCEPTION,
1622: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_batch_sql.gen_terr_rules_recurse3',
1623: 'JTY_TAE_GEN_PVT.gen_terr_rules_recurse API has failed');
1624:
1625: RAISE FND_API.G_EXC_ERROR;
1626: END IF;
1627:

Line 1719: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_batch_sql.end',

1715: END IF; /* end IF (l_pgm_name_tbl.COUNT > 0) */
1716:
1717: -- debug message
1718: jty_log(FND_LOG.LEVEL_PROCEDURE,
1719: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_batch_sql.end',
1720: 'End of the procedure JTY_TAE_GEN_PVT.gen_batch_sql ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1721:
1722: retcode := 0;
1723: errbuf := null;

Line 1720: 'End of the procedure JTY_TAE_GEN_PVT.gen_batch_sql ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

1716:
1717: -- debug message
1718: jty_log(FND_LOG.LEVEL_PROCEDURE,
1719: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_batch_sql.end',
1720: 'End of the procedure JTY_TAE_GEN_PVT.gen_batch_sql ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1721:
1722: retcode := 0;
1723: errbuf := null;
1724:

Line 1729: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_batch_sql.g_exc_error',

1725: EXCEPTION
1726: WHEN FND_API.G_EXC_ERROR THEN
1727: RETCODE := 2;
1728: jty_log(FND_LOG.LEVEL_EXCEPTION,
1729: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_batch_sql.g_exc_error',
1730: 'API JTY_TAE_GEN_PVT.gen_batch_sql has failed with FND_API.G_EXC_ERROR exception');
1731:
1732: WHEN OTHERS THEN
1733: RETCODE := 2;

Line 1730: 'API JTY_TAE_GEN_PVT.gen_batch_sql has failed with FND_API.G_EXC_ERROR exception');

1726: WHEN FND_API.G_EXC_ERROR THEN
1727: RETCODE := 2;
1728: jty_log(FND_LOG.LEVEL_EXCEPTION,
1729: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_batch_sql.g_exc_error',
1730: 'API JTY_TAE_GEN_PVT.gen_batch_sql has failed with FND_API.G_EXC_ERROR exception');
1731:
1732: WHEN OTHERS THEN
1733: RETCODE := 2;
1734: ERRBUF := SQLCODE || ' : ' || SQLERRM;

Line 1736: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_batch_sql.others',

1732: WHEN OTHERS THEN
1733: RETCODE := 2;
1734: ERRBUF := SQLCODE || ' : ' || SQLERRM;
1735: jty_log(FND_LOG.LEVEL_EXCEPTION,
1736: 'jtf.plsql.JTY_TAE_GEN_PVT.gen_batch_sql.others',
1737: substr(errbuf, 1, 4000));
1738: END gen_batch_sql;
1739:
1740:

Line 1741: END JTY_TAE_GEN_PVT;

1737: substr(errbuf, 1, 4000));
1738: END gen_batch_sql;
1739:
1740:
1741: END JTY_TAE_GEN_PVT;