APPS.JTY_MISC_UTILS_PKG dependencies on FND_LOG

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

64:
65: BEGIN
66:
67: -- debug message
68: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
69: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
70: 'jtf.plsql.JTY_MISC_UTILS_PKG.alter_qual_denorm_tables.begin',
71: 'Start of the procedure JTY_MISC_UTILS_PKG.alter_qual_denorm_tables');
72: END IF;

Line 69: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

65: BEGIN
66:
67: -- debug message
68: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
69: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
70: 'jtf.plsql.JTY_MISC_UTILS_PKG.alter_qual_denorm_tables.begin',
71: 'Start of the procedure JTY_MISC_UTILS_PKG.alter_qual_denorm_tables');
72: END IF;
73:

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

519: x_success_flag := 'Y';
520: x_err_code := null;
521:
522: -- debug message
523: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
524: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
525: 'jtf.plsql.JTY_MISC_UTILS_PKG.alter_qual_denorm_tables.end',
526: 'End of the procedure JTY_MISC_UTILS_PKG.alter_qual_denorm_tables');
527: END IF;

Line 524: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

520: x_err_code := null;
521:
522: -- debug message
523: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
524: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
525: 'jtf.plsql.JTY_MISC_UTILS_PKG.alter_qual_denorm_tables.end',
526: 'End of the procedure JTY_MISC_UTILS_PKG.alter_qual_denorm_tables');
527: END IF;
528:

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

529: EXCEPTION
530: WHEN L_SCHEMA_NOTFOUND THEN
531: x_success_flag := 'N';
532: x_err_code := 'JTF Schema not found';
533: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
534: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
535: 'jtf.plsql.JTY_MISC_UTILS_PKG.alter_qual_denorm_tables.l_schema_notfound',
536: 'Schema name corresponding to JTF application not found');
537: END IF;

Line 534: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

530: WHEN L_SCHEMA_NOTFOUND THEN
531: x_success_flag := 'N';
532: x_err_code := 'JTF Schema not found';
533: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
534: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
535: 'jtf.plsql.JTY_MISC_UTILS_PKG.alter_qual_denorm_tables.l_schema_notfound',
536: 'Schema name corresponding to JTF application not found');
537: END IF;
538:

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

538:
539: WHEN OTHERS THEN
540: x_success_flag := 'N';
541: x_err_code := SQLCODE;
542: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
543: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
544: 'jtf.plsql.JTY_MISC_UTILS_PKG.alter_qual_denorm_tables.other',
545: substr(SQLCODE || ' : ' || SQLERRM, 1, 4000));
546: END IF;

Line 543: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

539: WHEN OTHERS THEN
540: x_success_flag := 'N';
541: x_err_code := SQLCODE;
542: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
543: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
544: 'jtf.plsql.JTY_MISC_UTILS_PKG.alter_qual_denorm_tables.other',
545: substr(SQLCODE || ' : ' || SQLERRM, 1, 4000));
546: END IF;
547: