DBA Data[Home] [Help]

APPS.AHL_LTP_MATERIALS_GRP dependencies on FND_LOG

Line 6: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;

2: /* $Header: AHLGMTLB.pls 120.2 2010/02/25 10:03:45 skpathak noship $ */
3: ------------------------------------
4: -- Common constants and variables --
5: ------------------------------------
6: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
7: l_log_statement NUMBER := fnd_log.level_statement;
8: l_log_procedure NUMBER := fnd_log.level_procedure;
9: l_log_error NUMBER := fnd_log.level_error;
10: l_log_unexpected NUMBER := fnd_log.level_unexpected;

Line 7: l_log_statement NUMBER := fnd_log.level_statement;

3: ------------------------------------
4: -- Common constants and variables --
5: ------------------------------------
6: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
7: l_log_statement NUMBER := fnd_log.level_statement;
8: l_log_procedure NUMBER := fnd_log.level_procedure;
9: l_log_error NUMBER := fnd_log.level_error;
10: l_log_unexpected NUMBER := fnd_log.level_unexpected;
11:

Line 8: l_log_procedure NUMBER := fnd_log.level_procedure;

4: -- Common constants and variables --
5: ------------------------------------
6: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
7: l_log_statement NUMBER := fnd_log.level_statement;
8: l_log_procedure NUMBER := fnd_log.level_procedure;
9: l_log_error NUMBER := fnd_log.level_error;
10: l_log_unexpected NUMBER := fnd_log.level_unexpected;
11:
12:

Line 9: l_log_error NUMBER := fnd_log.level_error;

5: ------------------------------------
6: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
7: l_log_statement NUMBER := fnd_log.level_statement;
8: l_log_procedure NUMBER := fnd_log.level_procedure;
9: l_log_error NUMBER := fnd_log.level_error;
10: l_log_unexpected NUMBER := fnd_log.level_unexpected;
11:
12:
13:

Line 10: l_log_unexpected NUMBER := fnd_log.level_unexpected;

6: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
7: l_log_statement NUMBER := fnd_log.level_statement;
8: l_log_procedure NUMBER := fnd_log.level_procedure;
9: l_log_error NUMBER := fnd_log.level_error;
10: l_log_unexpected NUMBER := fnd_log.level_unexpected;
11:
12:
13:
14: ----------------------------------------

Line 103: fnd_log.string

99: END IF;
100:
101: -- Log API entry point
102: IF (l_log_procedure >= l_log_current_level)THEN
103: fnd_log.string
104: (
105: fnd_log.level_procedure,
106: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
107: 'At the start of PL SQL procedure p_wip_entity_id = ' || p_wip_entity_id

Line 105: fnd_log.level_procedure,

101: -- Log API entry point
102: IF (l_log_procedure >= l_log_current_level)THEN
103: fnd_log.string
104: (
105: fnd_log.level_procedure,
106: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
107: 'At the start of PL SQL procedure p_wip_entity_id = ' || p_wip_entity_id
108: );
109: END IF;

Line 133: fnd_log.string

129: FETCH get_scheduled_material_id INTO l_scheduled_material_id;
130: EXIT WHEN get_scheduled_material_id%NOTFOUND;
131:
132: IF (l_log_statement >= l_log_current_level)THEN
133: fnd_log.string
134: (
135: fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
136: 'Inside the loop i= ' || i || ', scheduled_material_id = ' || l_scheduled_material_id
137: );

Line 135: fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,

131:
132: IF (l_log_statement >= l_log_current_level)THEN
133: fnd_log.string
134: (
135: fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
136: 'Inside the loop i= ' || i || ', scheduled_material_id = ' || l_scheduled_material_id
137: );
138: END IF;
139:

Line 155: fnd_log.string

151: p_requested_date => l_requested_date);
152:
153: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
154: IF (l_log_statement >= l_log_current_level)THEN
155: fnd_log.string
156: (
157: fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
158: 'Returned success from AHL_RSV_RESERVATIONS_PVT.Update_Reservation'
159: );

Line 157: fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,

153: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
154: IF (l_log_statement >= l_log_current_level)THEN
155: fnd_log.string
156: (
157: fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
158: 'Returned success from AHL_RSV_RESERVATIONS_PVT.Update_Reservation'
159: );
160: END IF;
161: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 178: fnd_log.string

174:
175: i := i + 1;
176: END LOOP;
177: IF (l_log_statement >= l_log_current_level)THEN
178: fnd_log.string
179: (
180: fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
181: 'After end of the loop, total number of iteration to modify date = ' || (i-1)
182: );

Line 180: fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,

176: END LOOP;
177: IF (l_log_statement >= l_log_current_level)THEN
178: fnd_log.string
179: (
180: fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
181: 'After end of the loop, total number of iteration to modify date = ' || (i-1)
182: );
183: END IF;
184: CLOSE get_scheduled_material_id;

Line 188: fnd_log.string

184: CLOSE get_scheduled_material_id;
185:
186: -- End logging
187: IF (l_log_procedure >= l_log_current_level)THEN
188: fnd_log.string
189: (
190: fnd_log.level_procedure,
191: l_debug_module||'.end',
192: 'At the end of PLSQL procedure'

Line 190: fnd_log.level_procedure,

186: -- End logging
187: IF (l_log_procedure >= l_log_current_level)THEN
188: fnd_log.string
189: (
190: fnd_log.level_procedure,
191: l_debug_module||'.end',
192: 'At the end of PLSQL procedure'
193: );
194: END IF;

Line 207: fnd_log.string

203: IF FND_API.TO_BOOLEAN(p_commit)
204: THEN
205: COMMIT WORK;
206: IF (l_log_statement >= l_log_current_level) THEN
207: fnd_log.string
208: (
209: fnd_log.level_statement,
210: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
211: 'Committed'

Line 209: fnd_log.level_statement,

205: COMMIT WORK;
206: IF (l_log_statement >= l_log_current_level) THEN
207: fnd_log.string
208: (
209: fnd_log.level_statement,
210: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
211: 'Committed'
212: );
213: END IF;