DBA Data[Home] [Help]

APPS.FA_XLA_CMP_HEADER_PKG dependencies on FND_LOG

Line 45: fnd_log.string(G_LEVEL_PROCEDURE,

41:
42: BEGIN
43:
44: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
45: fnd_log.string(G_LEVEL_PROCEDURE,
46: G_MODULE_NAME||l_procedure_name||''.begin'',
47: ''Beginning of procedure'');
48: END IF;
49:

Line 56: fnd_log.string(G_LEVEL_PROCEDURE,

52:
53: C_PRIVATE_API_2 CONSTANT VARCHAR2(32000) := '
54:
55: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
56: fnd_log.string(G_LEVEL_PROCEDURE,
57: G_MODULE_NAME||l_procedure_name,
58: ''Rows inserted into headers: '' || to_char(SQL%ROWCOUNT));
59: END IF;
60:

Line 66: fnd_log.string(G_LEVEL_PROCEDURE,

62:
63: C_PRIVATE_API_3 CONSTANT VARCHAR2(32000) := '
64:
65: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
66: fnd_log.string(G_LEVEL_PROCEDURE,
67: G_MODULE_NAME||l_procedure_name||''.end'',
68: ''End of procedure'');
69: END IF;
70:

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

72: WHEN others THEN
73: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
74: fnd_message.set_name(''OFA'',''FA_SHARED_ORACLE_ERR'');
75: fnd_message.set_token(''ORACLE_ERR'',SQLERRM);
76: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
77: END IF;
78: raise;
79:
80: end $proc_name$;

Line 93: fnd_log.string(G_LEVEL_PROCEDURE,

89:
90: BEGIN
91:
92: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
93: fnd_log.string(G_LEVEL_PROCEDURE,
94: G_MODULE_NAME||l_procedure_name||''.begin'',
95: ''Beginning of procedure'');
96: END IF;
97:

Line 129: fnd_log.string(G_LEVEL_PROCEDURE,

125: AND dp.period_counter = ds.period_counter;
126:
127:
128: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
129: fnd_log.string(G_LEVEL_PROCEDURE,
130: G_MODULE_NAME||l_procedure_name||''.end'',
131: ''End of procedure'');
132: END IF;
133:

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

135: WHEN others THEN
136: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
137: fnd_message.set_name(''OFA'',''FA_SHARED_ORACLE_ERR'');
138: fnd_message.set_token(''ORACLE_ERR'',SQLERRM);
139: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
140: END IF;
141: raise;
142:
143: END Load_header_data_rb ;

Line 163: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

159: g_chr_newline CONSTANT VARCHAR2(10):= fa_cmp_string_pkg.g_chr_newline;
160:
161: g_log_level_rec fa_api_types.log_level_rec_type;
162:
163: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
164:
165: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
166: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
167: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

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

161: g_log_level_rec fa_api_types.log_level_rec_type;
162:
163: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
164:
165: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
166: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
167: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
168: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
169: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

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

162:
163: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
164:
165: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
166: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
167: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
168: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
169: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
170: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

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

163: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
164:
165: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
166: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
167: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
168: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
169: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
170: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
171:

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

164:
165: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
166: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
167: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
168: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
169: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
170: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
171:
172: G_MODULE_NAME CONSTANT VARCHAR2(50):= 'fa.plsql.fa_xla_cmp_header_pkg.';

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

165: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
166: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
167: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
168: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
169: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
170: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
171:
172: G_MODULE_NAME CONSTANT VARCHAR2(50):= 'fa.plsql.fa_xla_cmp_header_pkg.';
173:

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

166: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
167: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
168: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
169: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
170: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
171:
172: G_MODULE_NAME CONSTANT VARCHAR2(50):= 'fa.plsql.fa_xla_cmp_header_pkg.';
173:
174:

Line 194: fnd_log.string(G_LEVEL_PROCEDURE,

190:
191: BEGIN
192:
193: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
194: fnd_log.string(G_LEVEL_PROCEDURE,
195: G_MODULE_NAME||l_procedure_name||'.begin',
196: 'Beginning of procedure');
197: END IF;
198:

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

310: WHEN OTHERS THEN
311: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
312: fnd_message.set_name('OFA','FA_SHARED_ORACLE_ERR');
313: fnd_message.set_token('ORACLE_ERR',SQLERRM);
314: FND_LOG.MESSAGE (G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_procedure_name,TRUE);
315: END IF;
316: RETURN FALSE;
317:
318: END GenerateHeaderExtract;