24:
25:
26: g_default_fetch_limit CONSTANT NUMBER := 99999;
27:
28: g_log_level_1 CONSTANT NUMBER := fnd_log.level_statement;
29: g_log_level_2 CONSTANT NUMBER := fnd_log.level_procedure;
30: g_log_level_3 CONSTANT NUMBER := fnd_log.level_event;
31: g_log_level_4 CONSTANT NUMBER := fnd_log.level_exception;
32: g_log_level_5 CONSTANT NUMBER := fnd_log.level_error;
25:
26: g_default_fetch_limit CONSTANT NUMBER := 99999;
27:
28: g_log_level_1 CONSTANT NUMBER := fnd_log.level_statement;
29: g_log_level_2 CONSTANT NUMBER := fnd_log.level_procedure;
30: g_log_level_3 CONSTANT NUMBER := fnd_log.level_event;
31: g_log_level_4 CONSTANT NUMBER := fnd_log.level_exception;
32: g_log_level_5 CONSTANT NUMBER := fnd_log.level_error;
33: g_log_level_6 CONSTANT NUMBER := fnd_log.level_unexpected;
26: g_default_fetch_limit CONSTANT NUMBER := 99999;
27:
28: g_log_level_1 CONSTANT NUMBER := fnd_log.level_statement;
29: g_log_level_2 CONSTANT NUMBER := fnd_log.level_procedure;
30: g_log_level_3 CONSTANT NUMBER := fnd_log.level_event;
31: g_log_level_4 CONSTANT NUMBER := fnd_log.level_exception;
32: g_log_level_5 CONSTANT NUMBER := fnd_log.level_error;
33: g_log_level_6 CONSTANT NUMBER := fnd_log.level_unexpected;
34:
27:
28: g_log_level_1 CONSTANT NUMBER := fnd_log.level_statement;
29: g_log_level_2 CONSTANT NUMBER := fnd_log.level_procedure;
30: g_log_level_3 CONSTANT NUMBER := fnd_log.level_event;
31: g_log_level_4 CONSTANT NUMBER := fnd_log.level_exception;
32: g_log_level_5 CONSTANT NUMBER := fnd_log.level_error;
33: g_log_level_6 CONSTANT NUMBER := fnd_log.level_unexpected;
34:
35:
28: g_log_level_1 CONSTANT NUMBER := fnd_log.level_statement;
29: g_log_level_2 CONSTANT NUMBER := fnd_log.level_procedure;
30: g_log_level_3 CONSTANT NUMBER := fnd_log.level_event;
31: g_log_level_4 CONSTANT NUMBER := fnd_log.level_exception;
32: g_log_level_5 CONSTANT NUMBER := fnd_log.level_error;
33: g_log_level_6 CONSTANT NUMBER := fnd_log.level_unexpected;
34:
35:
36: --------------------------------------------------------------------------------
29: g_log_level_2 CONSTANT NUMBER := fnd_log.level_procedure;
30: g_log_level_3 CONSTANT NUMBER := fnd_log.level_event;
31: g_log_level_4 CONSTANT NUMBER := fnd_log.level_exception;
32: g_log_level_5 CONSTANT NUMBER := fnd_log.level_error;
33: g_log_level_6 CONSTANT NUMBER := fnd_log.level_unexpected;
34:
35:
36: --------------------------------------------------------------------------------
37: -- Declare package variables --
241: FEM_ENGINES_PKG.Tech_Message( p_severity => g_log_level_2
242: ,p_module => G_BLOCK||l_api_name
243: ,p_msg_text => 'BEGIN');
244:
245: fnd_log_repository.init;
246: fnd_msg_pub.initialize;
247:
248: --------------------------------------------------------------------------
249: -- Check for the required parameters