DBA Data[Home] [Help]

APPS.XDO_DGF_RULE_PKG dependencies on FND_LOG

Line 3: g_current_runtime_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1: PACKAGE BODY xdo_dgf_rule_pkg AS
2: /* $Header: XDODGFRLB.pls 120.2 2008/01/22 18:40:28 bgkim noship $ */
3: g_current_runtime_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
5: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
6: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
7: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

Line 4: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

1: PACKAGE BODY xdo_dgf_rule_pkg AS
2: /* $Header: XDODGFRLB.pls 120.2 2008/01/22 18:40:28 bgkim noship $ */
3: g_current_runtime_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
5: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
6: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
7: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
8: g_error_buffer VARCHAR2(100);

Line 5: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

1: PACKAGE BODY xdo_dgf_rule_pkg AS
2: /* $Header: XDODGFRLB.pls 120.2 2008/01/22 18:40:28 bgkim noship $ */
3: g_current_runtime_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
5: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
6: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
7: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
8: g_error_buffer VARCHAR2(100);
9:

Line 6: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

2: /* $Header: XDODGFRLB.pls 120.2 2008/01/22 18:40:28 bgkim noship $ */
3: g_current_runtime_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
5: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
6: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
7: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
8: g_error_buffer VARCHAR2(100);
9:
10:

Line 7: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

3: g_current_runtime_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
5: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
6: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
7: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
8: g_error_buffer VARCHAR2(100);
9:
10:
11: -- procedure definitions

Line 24: FND_LOG.STRING(g_level_statement,

20: l_return_char varchar2(4000);
21: l_ret number;
22: BEGIN
23: IF (g_level_statement >= g_current_runtime_level ) THEN
24: FND_LOG.STRING(g_level_statement,
25: 'xdo_dgf_rule_pkg.evaluate_rules',
26: 'start:p_rule_table.count = ' || p_rule_table.count );
27: END IF;
28: i:= p_rule_table.first;

Line 32: FND_LOG.STRING(g_level_statement,

28: i:= p_rule_table.first;
29: LOOP
30:
31: IF (g_level_statement >= g_current_runtime_level ) THEN
32: FND_LOG.STRING(g_level_statement,
33: 'xdo_dgf_rule_pkg.evaluate_rules',
34: p_rule_table(i).rule_variable || ' ' ||
35: p_rule_table(i).rule_operator || ' ' ||
36: p_rule_table(i).rule_values);

Line 49: FND_LOG.STRING(g_level_statement,

45: p_rule_table(i).rule_values_datatype);
46: ELSIF p_rule_table(i).rule_type = 'D' THEN
47:
48: IF (g_level_statement >= g_current_runtime_level ) THEN
49: FND_LOG.STRING(g_level_statement,
50: 'xdo_dgf_rule_pkg.evaluate_rules',
51: 'rule_type=''D''');
52: END IF;
53:

Line 69: FND_LOG.STRING(g_level_statement,

65:
66: IF p_rule_table(i).arg_number > 0 THEN
67:
68: IF (g_level_statement >= g_current_runtime_level ) THEN
69: FND_LOG.STRING(g_level_statement,
70: 'xdo_dgf_rule_pkg.evaluate_rules',
71: 'arg_number > 0');
72: END IF;
73:

Line 88: FND_LOG.STRING(g_level_statement,

84: END IF;
85: l_statement := l_statement || '; end;';
86:
87: IF (g_level_statement >= g_current_runtime_level ) THEN
88: FND_LOG.STRING(g_level_statement,
89: 'xdo_dgf_rule_pkg.evaluate_rules',
90: 'before open cursor: l_statement = '
91: || l_statement);
92: END IF;

Line 106: FND_LOG.STRING(g_level_statement,

102: dbms_sql.variable_value(l_cur_handler,'1', l_return_char);
103: dbms_sql.close_cursor(l_cur_handler);
104:
105: IF (g_level_statement >= g_current_runtime_level ) THEN
106: FND_LOG.STRING(g_level_statement,
107: 'xdo_dgf_rule_pkg.evaluate_rules',
108: 'Cursor closed. l_return_char = ' || l_return_char);
109: END IF;
110:

Line 122: FND_LOG.STRING(g_level_statement,

118: i := p_rule_table.next(i);
119: END LOOP;
120:
121: IF (g_level_statement >= g_current_runtime_level ) THEN
122: FND_LOG.STRING(g_level_statement,
123: 'xdo_dgf_rule_pkg.evaluate_rules',
124: 'END: p_rule_table.count = ' || p_rule_table.count);
125: END IF;
126: