DBA Data[Home] [Help]

APPS.EAM_OBJECTINSTANTIATION_PUB dependencies on FND_LOG

Line 38: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;

34:
35: l_maintenance_object_id NUMBER;
36:
37: l_module varchar2(200) ;
38: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
39: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level ;
40: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
41: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
42:

Line 39: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level ;

35: l_maintenance_object_id NUMBER;
36:
37: l_module varchar2(200) ;
38: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
39: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level ;
40: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
41: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
42:
43: BEGIN

Line 40: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;

36:
37: l_module varchar2(200) ;
38: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
39: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level ;
40: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
41: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
42:
43: BEGIN
44: if( l_ulog) then

Line 41: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

37: l_module varchar2(200) ;
38: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
39: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level ;
40: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
41: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
42:
43: BEGIN
44: if( l_ulog) then
45: l_module := 'eam.plsql.'||g_pkg_name|| '.' || l_api_name;

Line 49: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

45: l_module := 'eam.plsql.'||g_pkg_name|| '.' || l_api_name;
46: end if;
47:
48:
49: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
50: '==================== Entered EAM_ObjectInstantiation_PUB.Instantiate_Serial_Number ===================='
51: || 'p_current_organization_id = ' || p_current_organization_id
52: || 'p_inventory_item_id = ' || p_inventory_item_id
53: || 'p_serial_number = ' || p_serial_number);

Line 65: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

61: FROM csi_item_instances
62: WHERE inventory_item_id = p_inventory_item_id
63: AND serial_number = p_serial_number;
64:
65: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
66: 'l_maintenance_object_id = ' || l_maintenance_object_id);
67: end if;
68:
69: EXCEPTION

Line 85: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

81: RETURN;
82: END;
83:
84:
85: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
86: 'Calling EAM_ObjectInstantiation_PUB.Instantiate_Object...');
87: end if;
88:
89: Instantiate_Object

Line 161: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;

157: l_return_status VARCHAR2(5);
158: l_comments VARCHAR2(2000) := 'Initial Creation of Asset';
159:
160: l_module varchar2(200) ;
161: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
162: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level ;
163: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
164: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
165: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

Line 162: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level ;

158: l_comments VARCHAR2(2000) := 'Initial Creation of Asset';
159:
160: l_module varchar2(200) ;
161: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
162: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level ;
163: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
164: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
165: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
166:

Line 163: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;

159:
160: l_module varchar2(200) ;
161: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
162: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level ;
163: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
164: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
165: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
166:
167: l_date DATE;

Line 164: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;

160: l_module varchar2(200) ;
161: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
162: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level ;
163: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
164: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
165: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
166:
167: l_date DATE;
168:

Line 165: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

161: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
162: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level ;
163: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
164: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
165: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
166:
167: l_date DATE;
168:
169: BEGIN

Line 174: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

170: if( l_ulog) then
171: l_module := 'eam.plsql.'||g_pkg_name|| '.' || l_api_name;
172: end if;
173:
174: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
175: '==================== Entered EAM_ObjectInstantiation_PUB.Instantiate_Object ===================='
176: || 'p_maintenance_object_id = ' || p_maintenance_object_id
177: || 'p_maintenance_object_type = ' || p_maintenance_object_type);
178: end if;

Line 235: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

231: l_class_code := null;
232: l_owning_department_id := null;
233: end;
234:
235: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
236: 'l_eam_instantiation_flag=' || l_eam_instantiation_flag);
237: end if;
238:
239: IF (NVL(l_eam_instantiation_flag, 'N') <> 'Y' AND NVL(l_network_asset_flag, 'N') <> 'Y' ) THEN

Line 241: IF (l_plog) THEN FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

237: end if;
238:
239: IF (NVL(l_eam_instantiation_flag, 'N') <> 'Y' AND NVL(l_network_asset_flag, 'N') <> 'Y' ) THEN
240:
241: IF (l_plog) THEN FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
242: 'Calling EAM_ActivityAssociation_PVT.Inst_Activity_Template...');
243: END IF;
244:
245: -- 3: Call the Activity Instantiation API

Line 263: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

259: ,p_class_code => l_class_code
260: ,p_owning_department_id => l_owning_department_id
261: );
262:
263: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
264: 'Returned from EAM_ActivityAssociation_PVT.Inst_Activity_Template'
265: || 'l_x_act_return_status = ' || l_x_act_return_status
266: || 'l_x_act_msg_count = ' || l_x_act_msg_count
267: || 'l_x_act_msg_data = ' || l_x_act_msg_data

Line 280: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

276: x_msg_data => l_x_pm_msg_data,
277: p_activity_assoc_id_tbl=> l_x_act_association_id_tbl
278: );
279:
280: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
281: 'Returned from eam_pmdef_pub.instantiate_pm_defs'
282: || 'l_x_pm_return_status = ' || l_x_pm_return_status
283: || 'l_x_pm_msg_count = ' || l_x_pm_msg_count
284: || 'l_x_pm_msg_data = ' || l_x_pm_msg_data

Line 297: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

293: x_msg_data => l_x_supp_msg_data,
294: p_maintenance_object_id=> p_maintenance_object_id
295: );
296:
297: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
298: 'Returned from eam_pm_suppressions.instantiate_supp_defs'
299: || 'l_x_supp_return_status = ' || l_x_supp_return_status
300: || 'l_x_supp_msg_count = ' || l_x_supp_msg_count
301: || 'l_x_supp_msg_data = ' || l_x_supp_msg_data);

Line 374: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

370: p_data => x_msg_data
371: );
372: x_msg_data := substr(x_msg_data,1,4000);
373:
374: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
375: '==================== Exiting EAM_ObjectInstantiation_PUB.Instantiate_Object ====================');
376: end if;
377:
378: EXCEPTION

Line 382: if (l_exlog) then FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module,

378: EXCEPTION
379: WHEN FND_API.G_EXC_ERROR THEN
380: ROLLBACK TO Instantiate_Object_PUB;
381:
382: if (l_exlog) then FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module,
383: '==================== EAM_ObjectInstantiation_PUB.Instantiate_Object: EXPECTED ERROR ====================');
384: end if;
385:
386: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 398: if (l_exlog) then FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module,

394:
395: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
396: ROLLBACK TO Instantiate_Object_PUB;
397:
398: if (l_exlog) then FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module,
399: '==================== EAM_ObjectInstantiation_PUB.Instantiate_Object: UNEXPECTED ERROR ====================');
400: end if;
401:
402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 414: if (l_exlog) then FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module,

410:
411: WHEN OTHERS THEN
412: ROLLBACK TO Instantiate_Object_PUB;
413:
414: if (l_exlog) then FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module,
415: '==================== EAM_ObjectInstantiation_PUB.Instantiate_Object: OTHER ERROR ====================');
416: end if;
417:
418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;