APPS.JTM_MESSAGE_LOG_PKG dependencies on FND_LOG

Line 4: /* This procedure inserts a record into the FND_LOG_MESSAGES table

1: PACKAGE BODY JTM_MESSAGE_LOG_PKG AS
2: /* $Header: jtmmlpb.pls 120.2 2006/09/20 16:54:12 rsripada noship $ */
3:
4: /* This procedure inserts a record into the FND_LOG_MESSAGES table
5: FND uses an autonomous transaction so even when the hookinsert is
6: rolled back because of an error the log messages still exists
7: */
8: g_initialize_log BOOLEAN :=FALSE;

Line 22: -- Convert to the FND_LOG LEVEL

18: l_module VARCHAR2(64);
19: l_message VARCHAR2(4000);
20: BEGIN
21: l_module := v_module;
22: -- Convert to the FND_LOG LEVEL
23: l_log_level := 5 - v_level_id;
24: --Create the message text
25: l_message := 'Object '||v_object_name||'-'||v_object_id||' : '||v_message;
26:

Line 29: IF (l_log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

25: l_message := 'Object '||v_object_name||'-'||v_object_id||' : '||v_message;
26:
27: --Bug 5532003
28: IF g_initialize_log = TRUE THEN
29: IF (l_log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
30: FND_LOG.STRING(l_log_level, l_module, l_message);
31: END IF;
32: ELSE
33: fnd_log_repository.init();

Line 30: FND_LOG.STRING(l_log_level, l_module, l_message);

26:
27: --Bug 5532003
28: IF g_initialize_log = TRUE THEN
29: IF (l_log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
30: FND_LOG.STRING(l_log_level, l_module, l_message);
31: END IF;
32: ELSE
33: fnd_log_repository.init();
34: g_initialize_log := TRUE;

Line 33: fnd_log_repository.init();

29: IF (l_log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
30: FND_LOG.STRING(l_log_level, l_module, l_message);
31: END IF;
32: ELSE
33: fnd_log_repository.init();
34: g_initialize_log := TRUE;
35: IF (l_log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
36: fnd_log.string(l_log_level, l_module, l_message);
37: END IF;

Line 35: IF (l_log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

31: END IF;
32: ELSE
33: fnd_log_repository.init();
34: g_initialize_log := TRUE;
35: IF (l_log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
36: fnd_log.string(l_log_level, l_module, l_message);
37: END IF;
38: END IF;
39:

Line 36: fnd_log.string(l_log_level, l_module, l_message);

32: ELSE
33: fnd_log_repository.init();
34: g_initialize_log := TRUE;
35: IF (l_log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
36: fnd_log.string(l_log_level, l_module, l_message);
37: END IF;
38: END IF;
39:
40: EXCEPTION WHEN OTHERS THEN

Line 54: DELETE FND_LOG_MESSAGES

50: PROCEDURE PURGE
51: IS
52: PRAGMA AUTONOMOUS_TRANSACTION;
53: BEGIN
54: DELETE FND_LOG_MESSAGES
55: WHERE lower(MODULE) LIKE 'jtm%';
56: COMMIT;
57:
58: DELETE FND_LOG_MESSAGES

Line 58: DELETE FND_LOG_MESSAGES

54: DELETE FND_LOG_MESSAGES
55: WHERE lower(MODULE) LIKE 'jtm%';
56: COMMIT;
57:
58: DELETE FND_LOG_MESSAGES
59: WHERE lower(MODULE) LIKE 'csl%';
60: COMMIT;
61: EXCEPTION WHEN OTHERS THEN
62: ROLLBACK;