APPS.FND_CP_FNDSM dependencies on FND_LOG

Line 8: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

4: procedure mark_shutdown_fndsm( node IN varchar2)
5: is
6: PRAGMA AUTONOMOUS_TRANSACTION;
7: begin
8: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
9: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
10: 'fnd.plsql.FND_CP_FNDSM.MARK_SHUTDOWN_FNDSM',
11: 'mark_shutdown_fndsm called for node'||node);
12: end if;

Line 9: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

5: is
6: PRAGMA AUTONOMOUS_TRANSACTION;
7: begin
8: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
9: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
10: 'fnd.plsql.FND_CP_FNDSM.MARK_SHUTDOWN_FNDSM',
11: 'mark_shutdown_fndsm called for node'||node);
12: end if;
13:

Line 23: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

19: from FND_CONCURRENT_QUEUES
20: where MANAGER_TYPE = '6'
21: and NODE_NAME = node)
22: and PROCESS_STATUS_CODE not in ('S', 'K');
23: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
24: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
25: 'fnd.plsql.FND_CP_FNDSM.MARK_SHUTDOWN_FNDSM',
26: to_char(SQL%ROWCOUNT) ||' fnd_concurrent_processes rows updated');
27: end if;

Line 24: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

20: where MANAGER_TYPE = '6'
21: and NODE_NAME = node)
22: and PROCESS_STATUS_CODE not in ('S', 'K');
23: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
24: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
25: 'fnd.plsql.FND_CP_FNDSM.MARK_SHUTDOWN_FNDSM',
26: to_char(SQL%ROWCOUNT) ||' fnd_concurrent_processes rows updated');
27: end if;
28:

Line 35: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

31: max_processes = 0,
32: control_code = null
33: where MANAGER_TYPE = '6'
34: and NODE_NAME = node;
35: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
36: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
37: 'fnd.plsql.FND_CP_FNDSM.MARK_SHUTDOWN_FNDSM',
38: to_char(SQL%ROWCOUNT) ||' fnd_concurrent_queues rows updated');
39: end if;

Line 36: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

32: control_code = null
33: where MANAGER_TYPE = '6'
34: and NODE_NAME = node;
35: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
36: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
37: 'fnd.plsql.FND_CP_FNDSM.MARK_SHUTDOWN_FNDSM',
38: to_char(SQL%ROWCOUNT) ||' fnd_concurrent_queues rows updated');
39: end if;
40:

Line 54: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

50: is
51: PRAGMA AUTONOMOUS_TRANSACTION;
52: begin
53:
54: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
55: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
56: 'fnd.plsql.FND_CP_FNDSM.MARK_KILLED_FNDSM',
57: 'mark_shutdown_fndsm called for node'||node);
58: end if;

Line 55: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

51: PRAGMA AUTONOMOUS_TRANSACTION;
52: begin
53:
54: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
55: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
56: 'fnd.plsql.FND_CP_FNDSM.MARK_KILLED_FNDSM',
57: 'mark_shutdown_fndsm called for node'||node);
58: end if;
59: update FND_CONCURRENT_PROCESSES

Line 68: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

64: from FND_CONCURRENT_QUEUES
65: where MANAGER_TYPE = '6'
66: and NODE_NAME = node)
67: and PROCESS_STATUS_CODE not in ('S', 'K');
68: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
69: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
70: 'fnd.plsql.FND_CP_FNDSM.MARK_SHUTDOWN_FNDSM',
71: to_char(SQL%ROWCOUNT) ||' fnd_concurrent_processes rows updated');
72: end if;

Line 69: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

65: where MANAGER_TYPE = '6'
66: and NODE_NAME = node)
67: and PROCESS_STATUS_CODE not in ('S', 'K');
68: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
69: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
70: 'fnd.plsql.FND_CP_FNDSM.MARK_SHUTDOWN_FNDSM',
71: to_char(SQL%ROWCOUNT) ||' fnd_concurrent_processes rows updated');
72: end if;
73:

Line 80: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

76: max_processes = 0,
77: control_code = null
78: where MANAGER_TYPE = 6
79: and NODE_NAME = node;
80: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
81: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
82: 'fnd.plsql.FND_CP_FNDSM.MARK_SHUTDOWN_FNDSM',
83: to_char(SQL%ROWCOUNT) ||' fnd_concurrent_queues rows updated');
84: end if;

Line 81: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

77: control_code = null
78: where MANAGER_TYPE = 6
79: and NODE_NAME = node;
80: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
81: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
82: 'fnd.plsql.FND_CP_FNDSM.MARK_SHUTDOWN_FNDSM',
83: to_char(SQL%ROWCOUNT) ||' fnd_concurrent_queues rows updated');
84: end if;
85: