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

37: ,p_message IN VARCHAR2)
38: IS
39: pragma autonomous_transaction;
40: BEGIN
41: IF (p_log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
42: FND_LOG.string(p_log_level, p_module, p_message);
43: commit;
44: END IF;
45: END;

Line 42: FND_LOG.string(p_log_level, p_module, p_message);

38: IS
39: pragma autonomous_transaction;
40: BEGIN
41: IF (p_log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
42: FND_LOG.string(p_log_level, p_module, p_message);
43: commit;
44: END IF;
45: END;
46:

Line 95: jty_log(FND_LOG.LEVEL_EXCEPTION,

91: RETURN l_result;
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;

Line 205: jty_log(FND_LOG.LEVEL_EXCEPTION,

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

Line 239: jty_log(FND_LOG.LEVEL_PROCEDURE,

235: L_SCHEMA_NOTFOUND EXCEPTION;
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 */

Line 295: jty_log(FND_LOG.LEVEL_PROCEDURE,

291: g_new_line || l_indent || ',:PROGRAM_UPDATE_DATE ' ||
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;

Line 306: jty_log(FND_LOG.LEVEL_EXCEPTION,

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

Line 313: jty_log(FND_LOG.LEVEL_EXCEPTION,

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

Line 403: jty_log(FND_LOG.LEVEL_PROCEDURE,

399: l_op_where_tbl l_op_where_tbl_type;
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

Line 514: jty_log(FND_LOG.LEVEL_PROCEDURE,

510: l_where_str || g_new_line ||
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;

Line 525: jty_log(FND_LOG.LEVEL_EXCEPTION,

521: EXCEPTION
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;

Line 620: jty_log(FND_LOG.LEVEL_PROCEDURE,

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

Line 717: jty_log(FND_LOG.LEVEL_PROCEDURE,

713: 'AND B.source_id = ' || p_source_id || g_new_line ||
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;

Line 727: jty_log(FND_LOG.LEVEL_EXCEPTION,

723: EXCEPTION
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;

Line 822: jty_log(FND_LOG.LEVEL_PROCEDURE,

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

Line 826: jty_log(FND_LOG.LEVEL_PROCEDURE,

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
829: || ',qual_relation_prd='|| p_qual_relation_prd
830: || ',relation_factor='||p_relation_factor);

Line 860: jty_log(FND_LOG.LEVEL_PROCEDURE,

856: IF (l_qual_usg_id_tbl.COUNT > 0) THEN
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

Line 868: jty_log(FND_LOG.LEVEL_PROCEDURE,

864: || ',p_trans_table_name='|| p_trans_table_name
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

Line 889: jty_log(FND_LOG.LEVEL_PROCEDURE,

885: ,l_op_like_tbl(i)
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)

Line 900: jty_log(FND_LOG.LEVEL_PROCEDURE,

896: ELSE
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);

Line 915: jty_log(FND_LOG.LEVEL_PROCEDURE,

911: ,l_op_like_tbl(i)
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;

Line 925: jty_log(FND_LOG.LEVEL_PROCEDURE,

921: END LOOP; /* end loop FOR i IN l_qual_usg_id_tbl.FIRST .. l_qual_usg_id_tbl.LAST */
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 :=

Line 938: jty_log(FND_LOG.LEVEL_PROCEDURE,

934: p_qual_relation_prd => p_qual_relation_prd,
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 ||

Line 949: jty_log(FND_LOG.LEVEL_PROCEDURE,

945: 'AND B.source_id = ' || p_source_id || g_new_line ||
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;

Line 959: jty_log(FND_LOG.LEVEL_EXCEPTION,

955: EXCEPTION
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;

Line 1003: jty_log(FND_LOG.LEVEL_PROCEDURE,

999: L_SCHEMA_NOTFOUND EXCEPTION;
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

Line 1080: jty_log(FND_LOG.LEVEL_EXCEPTION,

1076: errbuf => errbuf);
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;

Line 1110: jty_log(FND_LOG.LEVEL_EXCEPTION,

1106: errbuf => errbuf);
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;

Line 1143: jty_log(FND_LOG.LEVEL_PROCEDURE,

1139: p_sql := p_sql || g_new_line || l_indent || ' AND ILV1.lead_id = ILV2.trans_object_id';
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;

Line 1152: jty_log(FND_LOG.LEVEL_EXCEPTION,

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

Line 1159: jty_log(FND_LOG.LEVEL_EXCEPTION,

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

Line 1166: jty_log(FND_LOG.LEVEL_EXCEPTION,

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

Line 1207: jty_log(FND_LOG.LEVEL_PROCEDURE,

1203: l_match_sql CLOB;
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

Line 1221: jty_log(FND_LOG.LEVEL_EXCEPTION,

1217: retcode => retcode);
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;

Line 1347: jty_log(FND_LOG.LEVEL_EXCEPTION,

1343: ,errbuf => errbuf);
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;

Line 1380: jty_log(FND_LOG.LEVEL_EXCEPTION,

1376: ,errbuf => errbuf);
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;

Line 1391: jty_log(FND_LOG.LEVEL_PROCEDURE,

1387: l_match_sql := l_match_sql || l_sql;
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;

Line 1403: jty_log(FND_LOG.LEVEL_EXCEPTION,

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

Line 1410: jty_log(FND_LOG.LEVEL_EXCEPTION,

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

Line 1462: jty_log(FND_LOG.LEVEL_PROCEDURE,

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

Line 1468: jty_log(FND_LOG.LEVEL_EXCEPTION,

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,
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;

Line 1493: jty_log(FND_LOG.LEVEL_EXCEPTION,

1489: RETCODE => retcode );
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;

Line 1518: jty_log(FND_LOG.LEVEL_EXCEPTION,

1514: RETCODE => retcode );
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;

Line 1574: jty_log(FND_LOG.LEVEL_EXCEPTION,

1570: errbuf => errbuf);
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;

Line 1598: jty_log(FND_LOG.LEVEL_EXCEPTION,

1594: errbuf => errbuf);
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;

Line 1621: jty_log(FND_LOG.LEVEL_EXCEPTION,

1617: errbuf => errbuf);
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;

Line 1718: jty_log(FND_LOG.LEVEL_PROCEDURE,

1714: END LOOP; /* end loop FOR i IN l_pgm_name_tbl.FIRST .. l_pgm_name_tbl.LAST */
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;

Line 1728: jty_log(FND_LOG.LEVEL_EXCEPTION,

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

Line 1735: jty_log(FND_LOG.LEVEL_EXCEPTION,

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