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.8 2008/05/12 13:20:15 rajukum 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.8 2008/05/12 13:20:15 rajukum 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 85: 'jtf.plsql.JTY_TAE_GEN_PVT.build_predicate_for_operator.others',

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;
89: END build_predicate_for_operator;

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

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

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

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

Line 234: 'Start of the procedure JTY_TAE_GEN_PVT.get_insert_select_nmtrans');

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:
237: /* Get the schema name corresponding to JTF application */
238: IF (FND_INSTALLATION.GET_APP_INFO('JTF', l_status, l_industry, l_owner)) THEN

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

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:
295: retcode := 0;

Line 292: 'End of the procedure JTY_TAE_GEN_PVT.get_insert_select_nmtrans');

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:
295: retcode := 0;
296: errbuf := null;

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

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:
308: WHEN OTHERS THEN

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

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

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

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:
409: IF (p_mode = 'DATE EFFECTIVE') THEN

Line 406: 'Start of the procedure JTY_TAE_GEN_PVT.build_ilv1');

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:
409: IF (p_mode = 'DATE EFFECTIVE') THEN
410: OPEN c_dea_rel_prod_detail(p_source_id, p_trans_id, p_qual_relation_prd, p_relation_factor);

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

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:
522: retcode := 0;

Line 519: 'End of the procedure JTY_TAE_GEN_PVT.build_ilv1');

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:
522: retcode := 0;
523: errbuf := null;

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

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

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

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:
631: l_relation_product := p_qual_relation_prd/p_relation_factor;

Line 628: 'Start of the procedure JTY_TAE_GEN_PVT.build_ilv2');

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:
631: l_relation_product := p_qual_relation_prd/p_relation_factor;
632: l_counter := 1;

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

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:
730: retcode := 0;

Line 727: 'End of the procedure JTY_TAE_GEN_PVT.build_ilv2');

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:
730: retcode := 0;
731: errbuf := null;

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

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

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

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
839: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 836: 'Start of the procedure JTY_TAE_GEN_PVT.build_qualifier_rules');

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
839: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
840: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

Line 841: 'jtf.plsql.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);
845: END IF;

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

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
881: || ',p_denorm_table_name='|| p_denorm_table_name);

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

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 ';
891: IF (l_alias_rule1_tbl(i) IS NOT NULL) THEN

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

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
914: ELSIF l_alias_rule1 = l_alias_rule1_tbl(i)

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

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
927: l_from_str := l_from_str || g_new_line || ',' || l_alias_rule1_tbl(i);

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

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) */
944: l_counter := l_counter + 1;

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

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;
956: l_from_str :=

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

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:
971: p_sql := l_from_str || g_new_line || l_where_str || g_new_line || l_predicate || g_new_line ||

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

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:
984: retcode := 0;

Line 981: 'End of the procedure JTY_TAE_GEN_PVT.build_qualifier_rules');

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:
984: retcode := 0;
985: errbuf := null;

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

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:
996: END build_qualifier_rules;

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

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:
1042: IF mod(p_qual_relation_prd,79) = 0 THEN

Line 1039: 'Start of the procedure JTY_TAE_GEN_PVT.build_qualifier_rules1');

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:
1042: IF mod(p_qual_relation_prd,79) = 0 THEN
1043: l_rel_prod1 := 79;

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

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:
1121: RAISE FND_API.G_EXC_ERROR;

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

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:
1121: RAISE FND_API.G_EXC_ERROR;
1122: END IF;

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

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:
1153: RAISE FND_API.G_EXC_ERROR;

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

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:
1153: RAISE FND_API.G_EXC_ERROR;
1154: END IF;

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

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:
1188: retcode := 0;

Line 1185: 'End of the procedure JTY_TAE_GEN_PVT.build_qualifier_rules1');

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:
1188: retcode := 0;
1189: errbuf := null;

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

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

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

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:
1199: WHEN L_SCHEMA_NOTFOUND THEN
1200: errbuf := 'Schema name corresponding to JTF application not found';

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

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:
1208: WHEN OTHERS THEN

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

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:
1217: END build_qualifier_rules1;

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

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:
1260: IF (p_new_mode_fetch = 'Y') THEN

Line 1257: 'Start of the procedure JTY_TAE_GEN_PVT.gen_terr_rules_recurse');

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:
1260: IF (p_new_mode_fetch = 'Y') THEN
1261: get_insert_select_nmtrans(

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

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:
1276: RAISE FND_API.G_EXC_ERROR;

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

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:
1276: RAISE FND_API.G_EXC_ERROR;
1277: END IF;

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

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:
1404: RAISE FND_API.G_EXC_ERROR;

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

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:
1404: RAISE FND_API.G_EXC_ERROR;
1405: END IF;

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

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:
1439: RAISE FND_API.G_EXC_ERROR;

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

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:
1439: RAISE FND_API.G_EXC_ERROR;
1440: END IF;

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

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:
1452: p_match_sql := l_match_sql;

Line 1449: 'End of the procedure JTY_TAE_GEN_PVT.gen_terr_rules_recurse');

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:
1452: p_match_sql := l_match_sql;
1453:

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

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:
1466: WHEN OTHERS THEN

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

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:
1466: WHEN OTHERS THEN
1467: RETCODE := 2;

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

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

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

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:
1527: IF (p_qual_prd_tbl.COUNT = 0) THEN

Line 1524: 'Start of the procedure JTY_TAE_GEN_PVT.gen_batch_sql');

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:
1527: IF (p_qual_prd_tbl.COUNT = 0) THEN
1528: -- debug message

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

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:
1535: RAISE FND_API.G_EXC_ERROR;

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

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:
1535: RAISE FND_API.G_EXC_ERROR;
1536: END IF;

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

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:
1562: RAISE FND_API.G_EXC_ERROR;

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

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:
1589: RAISE FND_API.G_EXC_ERROR;

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

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:
1647: RAISE FND_API.G_EXC_ERROR;

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

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:
1647: RAISE FND_API.G_EXC_ERROR;
1648: END IF;

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

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:
1673: RAISE FND_API.G_EXC_ERROR;

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

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:
1673: RAISE FND_API.G_EXC_ERROR;
1674: END IF;

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

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:
1698: RAISE FND_API.G_EXC_ERROR;

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

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:
1698: RAISE FND_API.G_EXC_ERROR;
1699: END IF;

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

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:
1794: retcode := 0;

Line 1791: 'End of the procedure JTY_TAE_GEN_PVT.gen_batch_sql');

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:
1794: retcode := 0;
1795: errbuf := null;

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

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:
1806: WHEN OTHERS THEN

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

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:
1806: WHEN OTHERS THEN
1807: RETCODE := 2;

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

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

Line 1816: END JTY_TAE_GEN_PVT;

1812: substr(errbuf, 1, 4000));
1813: END IF;
1814: END gen_batch_sql;
1815:
1816: END JTY_TAE_GEN_PVT;