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.

[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 979: fnd_log.string(G_LEVEL_PROCEDURE,

975:
976:
977: c_rowcount_debug CONSTANT VARCHAR2(32000) := '
978: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
979: fnd_log.string(G_LEVEL_PROCEDURE,
980: G_MODULE_NAME||l_procedure_name,
981: ''Rows inserted into lines: '' || to_char(SQL%ROWCOUNT));
982: END IF;
983:

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

1056: WHEN OTHERS THEN
1057: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
1058: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
1059: fnd_message.set_token('ORACLE_ERR',SQLERRM);
1060: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
1061: END IF;
1062: RAISE;
1063:
1064: END AddMember;

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

1094: WHEN OTHERS THEN
1095: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
1096: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
1097: fnd_message.set_token('ORACLE_ERR',SQLERRM);
1098: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
1099: END IF;
1100: RAISE;
1101:
1102: end delete_table_member;

Line 1128: fnd_log.string(G_LEVEL_PROCEDURE,

1124:
1125: EXCEPTION
1126: WHEN schema_err THEN
1127: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1128: fnd_log.string(G_LEVEL_PROCEDURE,
1129: G_MODULE_NAME||l_procedure_name,
1130: 'schema_err');
1131: END IF;
1132: raise;

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

1133: WHEN OTHERS THEN
1134: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
1135: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
1136: fnd_message.set_token('ORACLE_ERR',SQLERRM);
1137: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
1138: END IF;
1139: RAISE;
1140:
1141: END get_schema;

Line 1154: fnd_log.string(G_LEVEL_PROCEDURE,

1150:
1151: BEGIN
1152:
1153: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1154: fnd_log.string(G_LEVEL_PROCEDURE,
1155: G_MODULE_NAME||l_procedure_name||'.begin',
1156: 'Beginning of procedure');
1157: END IF;
1158:

Line 1387: fnd_log.string(G_LEVEL_PROCEDURE,

1383:
1384: G_initialized := TRUE;
1385:
1386: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1387: fnd_log.string(G_LEVEL_PROCEDURE,
1388: G_MODULE_NAME||l_procedure_name||'.end',
1389: 'End of procedure');
1390: END IF;
1391:

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

1394: WHEN OTHERS THEN
1395: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
1396: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
1397: fnd_message.set_token('ORACLE_ERR',SQLERRM);
1398: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
1399: END IF;
1400: RAISE;
1401:
1402: end initialize;

Line 1647: fnd_log.string(G_LEVEL_PROCEDURE,

1643:
1644: BEGIN
1645:
1646: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1647: fnd_log.string(G_LEVEL_PROCEDURE,
1648: G_MODULE_NAME||l_procedure_name||'.begin',
1649: 'Beginning of procedure');
1650: END IF;
1651:

Line 1660: fnd_log.string(G_LEVEL_STATEMENT,

1656: l_event_class_table := fa_char30_tbl_type();
1657:
1658:
1659: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1660: fnd_log.string(G_LEVEL_STATEMENT,
1661: G_MODULE_NAME||l_procedure_name,
1662: 'p_extract_type: ' || p_extract_type);
1663: fnd_log.string(G_LEVEL_STATEMENT,
1664: G_MODULE_NAME||l_procedure_name,

Line 1663: fnd_log.string(G_LEVEL_STATEMENT,

1659: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1660: fnd_log.string(G_LEVEL_STATEMENT,
1661: G_MODULE_NAME||l_procedure_name,
1662: 'p_extract_type: ' || p_extract_type);
1663: fnd_log.string(G_LEVEL_STATEMENT,
1664: G_MODULE_NAME||l_procedure_name,
1665: 'p_level: ' || p_level);
1666: END IF;
1667:

Line 1986: fnd_log.string(G_LEVEL_STATEMENT,

1982: end if;
1983:
1984:
1985: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1986: fnd_log.string(G_LEVEL_STATEMENT,
1987: G_MODULE_NAME||l_procedure_name,
1988: 'l_source_code.count: ' || to_char(l_source_code.count));
1989: END IF;
1990:

Line 2010: fnd_log.string(G_LEVEL_STATEMENT,

2006:
2007: end loop;
2008:
2009: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
2010: fnd_log.string(G_LEVEL_STATEMENT,
2011: G_MODULE_NAME||l_procedure_name,
2012: 'l_source_code.count after deletion: ' || to_char(l_source_code.count));
2013: END IF;
2014:

Line 2033: fnd_log.string(G_LEVEL_STATEMENT,

2029: -- if no match found - problem!!!
2030: if (not l_found) then
2031:
2032: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
2033: fnd_log.string(G_LEVEL_STATEMENT,
2034: G_MODULE_NAME||l_procedure_name,
2035: 'no match: l_table_name(i): ' || l_table_name(i) );
2036: fnd_log.string(G_LEVEL_STATEMENT,
2037: G_MODULE_NAME||l_procedure_name,

Line 2036: fnd_log.string(G_LEVEL_STATEMENT,

2032: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
2033: fnd_log.string(G_LEVEL_STATEMENT,
2034: G_MODULE_NAME||l_procedure_name,
2035: 'no match: l_table_name(i): ' || l_table_name(i) );
2036: fnd_log.string(G_LEVEL_STATEMENT,
2037: G_MODULE_NAME||l_procedure_name,
2038: 'no match: l_source_code(i): ' || l_source_code(i) );
2039: END IF;
2040:

Line 2374: fnd_log.string(G_LEVEL_PROCEDURE,

2370:
2371: p_package_body := l_array_pkg;
2372:
2373: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2374: fnd_log.string(G_LEVEL_PROCEDURE,
2375: G_MODULE_NAME||l_procedure_name||'.end',
2376: 'End of procedure');
2377: END IF;
2378:

Line 2385: fnd_log.string(G_LEVEL_STATEMENT,

2381: EXCEPTION
2382:
2383: WHEN invalid_mode THEN
2384: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
2385: fnd_log.string(G_LEVEL_STATEMENT,
2386: G_MODULE_NAME||l_procedure_name,
2387: 'invalid mode');
2388: END IF;
2389: RETURN FALSE;

Line 2393: fnd_log.string(G_LEVEL_STATEMENT,

2389: RETURN FALSE;
2390:
2391: WHEN table_not_found THEN
2392: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
2393: fnd_log.string(G_LEVEL_STATEMENT,
2394: G_MODULE_NAME||l_procedure_name,
2395: 'table not found');
2396: END IF;
2397: RETURN FALSE;

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

2419:
2420: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
2421: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
2422: fnd_message.set_token('ORACLE_ERR',SQLERRM);
2423: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
2424: END IF;
2425: RETURN FALSE;
2426:
2427: END GenerateSourcesExtract;