DBA Data[Home] [Help]

APPS.FA_XLA_CMP_SOURCES_PKG dependencies on FND_LOG

Line 64: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

60: g_chr_newline CONSTANT VARCHAR2(10):= fa_cmp_string_pkg.g_chr_newline;
61:
62: g_log_level_rec fa_api_types.log_level_rec_type;
63:
64: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
65:
66: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
67: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
68: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

Line 66: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

62: g_log_level_rec fa_api_types.log_level_rec_type;
63:
64: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
65:
66: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
67: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
68: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
69: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
70: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

Line 67: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

63:
64: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
65:
66: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
67: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
68: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
69: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
70: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
71: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

Line 68: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

64: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
65:
66: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
67: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
68: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
69: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
70: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
71: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
72:

Line 69: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

65:
66: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
67: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
68: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
69: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
70: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
71: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
72:
73: G_MODULE_NAME CONSTANT VARCHAR2(50):= 'fa.plsql.fa_xla_cmp_header_pkg.';

Line 70: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

66: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
67: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
68: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
69: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
70: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
71: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
72:
73: G_MODULE_NAME CONSTANT VARCHAR2(50):= 'fa.plsql.fa_xla_cmp_header_pkg.';
74:

Line 71: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

67: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
68: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
69: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
70: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
71: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
72:
73: G_MODULE_NAME CONSTANT VARCHAR2(50):= 'fa.plsql.fa_xla_cmp_header_pkg.';
74:
75: G_initialized boolean := FALSE;

Line 849: fnd_log.string(G_LEVEL_PROCEDURE,

845:
846:
847: c_line_rowcount_debug CONSTANT VARCHAR2(32000) := '
848: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
849: fnd_log.string(G_LEVEL_PROCEDURE,
850: G_MODULE_NAME||l_procedure_name,
851: ''Rows inserted into lines: '' || to_char(SQL%ROWCOUNT));
852: END IF;
853:

Line 915: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);

911: WHEN OTHERS THEN
912: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
913: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
914: fnd_message.set_token('ORACLE_ERR',SQLERRM);
915: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
916: END IF;
917: RAISE;
918:
919: END AddMember;

Line 953: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);

949: WHEN OTHERS THEN
950: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
951: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
952: fnd_message.set_token('ORACLE_ERR',SQLERRM);
953: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
954: END IF;
955: RAISE;
956:
957: end delete_table_member;

Line 971: fnd_log.string(G_LEVEL_PROCEDURE,

967:
968: BEGIN
969:
970: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
971: fnd_log.string(G_LEVEL_PROCEDURE,
972: G_MODULE_NAME||l_procedure_name||'.begin',
973: 'Beginning of procedure');
974: END IF;
975:

Line 1201: fnd_log.string(G_LEVEL_PROCEDURE,

1197:
1198: G_initialized := TRUE;
1199:
1200: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1201: fnd_log.string(G_LEVEL_PROCEDURE,
1202: G_MODULE_NAME||l_procedure_name||'.end',
1203: 'End of procedure');
1204: END IF;
1205:

Line 1212: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);

1208: WHEN OTHERS THEN
1209: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
1210: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
1211: fnd_message.set_token('ORACLE_ERR',SQLERRM);
1212: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
1213: END IF;
1214: RAISE;
1215:
1216: end initialize;

Line 1458: fnd_log.string(G_LEVEL_PROCEDURE,

1454:
1455: BEGIN
1456:
1457: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1458: fnd_log.string(G_LEVEL_PROCEDURE,
1459: G_MODULE_NAME||l_procedure_name||'.begin',
1460: 'Beginning of procedure');
1461: END IF;
1462:

Line 1471: fnd_log.string(G_LEVEL_STATEMENT,

1467: l_event_class_table := fa_char30_tbl_type();
1468:
1469:
1470: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1471: fnd_log.string(G_LEVEL_STATEMENT,
1472: G_MODULE_NAME||l_procedure_name,
1473: 'p_extract_type: ' || p_extract_type);
1474: fnd_log.string(G_LEVEL_STATEMENT,
1475: G_MODULE_NAME||l_procedure_name,

Line 1474: fnd_log.string(G_LEVEL_STATEMENT,

1470: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1471: fnd_log.string(G_LEVEL_STATEMENT,
1472: G_MODULE_NAME||l_procedure_name,
1473: 'p_extract_type: ' || p_extract_type);
1474: fnd_log.string(G_LEVEL_STATEMENT,
1475: G_MODULE_NAME||l_procedure_name,
1476: 'p_level: ' || p_level);
1477: END IF;
1478:

Line 1802: fnd_log.string(G_LEVEL_STATEMENT,

1798: end if;
1799:
1800:
1801: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1802: fnd_log.string(G_LEVEL_STATEMENT,
1803: G_MODULE_NAME||l_procedure_name,
1804: 'l_source_code.count: ' || to_char(l_source_code.count));
1805: END IF;
1806:

Line 1828: fnd_log.string(G_LEVEL_STATEMENT,

1824:
1825: end loop;
1826:
1827: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1828: fnd_log.string(G_LEVEL_STATEMENT,
1829: G_MODULE_NAME||l_procedure_name,
1830: 'l_source_code.count after deletion: ' || to_char(l_source_code.count));
1831: END IF;
1832:

Line 1852: fnd_log.string(G_LEVEL_STATEMENT,

1848: -- if no match found - problem!!!
1849: if (not l_found) then
1850:
1851: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1852: fnd_log.string(G_LEVEL_STATEMENT,
1853: G_MODULE_NAME||l_procedure_name,
1854: 'no match: l_table_name(i): ' || l_table_name(i) );
1855: fnd_log.string(G_LEVEL_STATEMENT,
1856: G_MODULE_NAME||l_procedure_name,

Line 1855: fnd_log.string(G_LEVEL_STATEMENT,

1851: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1852: fnd_log.string(G_LEVEL_STATEMENT,
1853: G_MODULE_NAME||l_procedure_name,
1854: 'no match: l_table_name(i): ' || l_table_name(i) );
1855: fnd_log.string(G_LEVEL_STATEMENT,
1856: G_MODULE_NAME||l_procedure_name,
1857: 'no match: l_source_code(i): ' || l_source_code(i) );
1858: END IF;
1859:

Line 2062: fnd_log.string(G_LEVEL_PROCEDURE,

2058:
2059: p_package_body := l_array_pkg;
2060:
2061: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2062: fnd_log.string(G_LEVEL_PROCEDURE,
2063: G_MODULE_NAME||l_procedure_name||'.end',
2064: 'End of procedure');
2065: END IF;
2066:

Line 2073: fnd_log.string(G_LEVEL_STATEMENT,

2069: EXCEPTION
2070:
2071: WHEN invalid_mode THEN
2072: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
2073: fnd_log.string(G_LEVEL_STATEMENT,
2074: G_MODULE_NAME||l_procedure_name,
2075: 'invalid mode');
2076: END IF;
2077: RETURN FALSE;

Line 2081: fnd_log.string(G_LEVEL_STATEMENT,

2077: RETURN FALSE;
2078:
2079: WHEN table_not_found THEN
2080: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
2081: fnd_log.string(G_LEVEL_STATEMENT,
2082: G_MODULE_NAME||l_procedure_name,
2083: 'table not found');
2084: END IF;
2085: RETURN FALSE;

Line 2091: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);

2087: WHEN OTHERS THEN
2088: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
2089: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
2090: fnd_message.set_token('ORACLE_ERR',SQLERRM);
2091: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
2092: END IF;
2093: RETURN FALSE;
2094:
2095: END GenerateSourcesExtract;