34: g_last_update_login NUMBER(15);
35:
36: -- Globals for log
37:
38: g_current_runtime_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
39: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
40: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
41: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
42: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
35:
36: -- Globals for log
37:
38: g_current_runtime_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
39: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
40: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
41: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
42: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
43: g_level_error CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
36: -- Globals for log
37:
38: g_current_runtime_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
39: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
40: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
41: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
42: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
43: g_level_error CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
44: g_level_exception CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
37:
38: g_current_runtime_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
39: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
40: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
41: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
42: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
43: g_level_error CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
44: g_level_exception CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
45: g_error_buffer VARCHAR2(100);
38: g_current_runtime_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
39: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
40: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
41: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
42: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
43: g_level_error CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
44: g_level_exception CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
45: g_error_buffer VARCHAR2(100);
46: g_debug_flag VARCHAR2(1);
39: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
40: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
41: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
42: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
43: g_level_error CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
44: g_level_exception CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
45: g_error_buffer VARCHAR2(100);
46: g_debug_flag VARCHAR2(1);
47: g_pkg_name CONSTANT VARCHAR2(30) := 'JE_IT_INVOICES_ABOVE_THRESHOLD';
40: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
41: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
42: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
43: g_level_error CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
44: g_level_exception CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
45: g_error_buffer VARCHAR2(100);
46: g_debug_flag VARCHAR2(1);
47: g_pkg_name CONSTANT VARCHAR2(30) := 'JE_IT_INVOICES_ABOVE_THRESHOLD';
48: g_module_name CONSTANT VARCHAR2(30) := 'JE_IT_INVOICES_ABOVE_THRESHOLD';