DBA Data[Home] [Help]

APPS.EAM_REBUILDS_PVT dependencies on FND_LOG

Line 36: l_log := (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL);

32: IF FND_API.to_Boolean( p_init_msg_list ) THEN
33: FND_MSG_PUB.initialize;
34: END IF;
35:
36: l_log := (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL);
37: if (l_log) then -- true only if logging enabled, avoids costly function call
38: l_log := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
39: end if;
40: if (l_log and (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then

Line 38: l_log := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);

34: END IF;
35:
36: l_log := (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL);
37: if (l_log) then -- true only if logging enabled, avoids costly function call
38: l_log := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
39: end if;
40: if (l_log and (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
41: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
42: 'Start of ' || l_module || '('

Line 40: if (l_log and (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then

36: l_log := (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL);
37: if (l_log) then -- true only if logging enabled, avoids costly function call
38: l_log := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
39: end if;
40: if (l_log and (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
41: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
42: 'Start of ' || l_module || '('
43: || 'p_organization_id='|| p_organization_id || ','
44: || 'p_wip_entity_id='|| p_wip_entity_id || ','

Line 41: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

37: if (l_log) then -- true only if logging enabled, avoids costly function call
38: l_log := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
39: end if;
40: if (l_log and (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
41: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
42: 'Start of ' || l_module || '('
43: || 'p_organization_id='|| p_organization_id || ','
44: || 'p_wip_entity_id='|| p_wip_entity_id || ','
45: || 'p_rebuild_item_id='|| p_rebuild_item_id || ','

Line 62: if (l_log and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then

58: return;
59: end if;
60:
61: --validate rebuild item
62: if (l_log and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
63: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, 'Validating Rebuild Item...');
64: end if;
65: begin
66: if (p_rebuild_item_id is not null) then

Line 63: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, 'Validating Rebuild Item...');

59: end if;
60:
61: --validate rebuild item
62: if (l_log and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
63: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, 'Validating Rebuild Item...');
64: end if;
65: begin
66: if (p_rebuild_item_id is not null) then
67: select inventory_item_id, serial_number_control_code

Line 98: if (l_log and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then

94: FND_MSG_PUB.Count_And_Get('T', x_msg_count, x_msg_data);
95: return;
96: end;
97:
98: if (l_log and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
99: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
100: 'Finished Validating Rebuild Item Id ' || p_rebuild_item_id);
101: end if;
102:

Line 99: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

95: return;
96: end;
97:
98: if (l_log and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
99: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
100: 'Finished Validating Rebuild Item Id ' || p_rebuild_item_id);
101: end if;
102:
103: --validate rebuild serial

Line 105: if (l_log and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then

101: end if;
102:
103: --validate rebuild serial
104: if ((l_serial_control_code> 1) and p_rebuild_serial_number is not null) then
105: if (l_log and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
106: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
107: 'Now Validating Rebuild Serial...' || p_rebuild_item_id);
108: end if;
109: if ((p_wip_entity_id is null) and (p_validate_mode <> VALIDATE_ISSUE)) then

Line 106: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

102:
103: --validate rebuild serial
104: if ((l_serial_control_code> 1) and p_rebuild_serial_number is not null) then
105: if (l_log and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
106: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
107: 'Now Validating Rebuild Serial...' || p_rebuild_item_id);
108: end if;
109: if ((p_wip_entity_id is null) and (p_validate_mode <> VALIDATE_ISSUE)) then
110: -- wip entity id is required for checking the hierarchy

Line 152: if (l_log and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then

148: and start_date_active <= sysdate
149: and (end_date_active is null or end_date_active >= sysdate);
150: end if;
151: end if;
152: if (l_log and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
153: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
154: 'Finished Validating Rebuild Serial');
155: end if;
156: exception

Line 153: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

149: and (end_date_active is null or end_date_active >= sysdate);
150: end if;
151: end if;
152: if (l_log and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
153: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
154: 'Finished Validating Rebuild Serial');
155: end if;
156: exception
157: when no_data_found then

Line 176: if (l_log and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then

172:
173: --validate rebuild activity
174: if ((p_rebuild_activity_id is not null) or
175: (p_rebuild_activity_name is not null)) then
176: if (l_log and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
177: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
178: 'Now Validating Rebuild Activity...');
179: end if;
180: -- serial mandatory if specifying activity for serialized rebuild

Line 177: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

173: --validate rebuild activity
174: if ((p_rebuild_activity_id is not null) or
175: (p_rebuild_activity_name is not null)) then
176: if (l_log and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
177: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
178: 'Now Validating Rebuild Activity...');
179: end if;
180: -- serial mandatory if specifying activity for serialized rebuild
181: if ((p_rebuild_serial_number is null) and (l_serial_control_code > 1)) then

Line 201: if (l_log and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then

197: from mtl_system_items_b_kfv
198: where concatenated_segments = p_rebuild_activity_name
199: and organization_id = p_organization_id
200: and eam_item_type = 2;
201: if (l_log and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
202: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
203: 'Rebuild Activity Id is ' || p_rebuild_activity_id);
204: end if;
205: if (l_serial_control_code > 1) then

Line 202: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

198: where concatenated_segments = p_rebuild_activity_name
199: and organization_id = p_organization_id
200: and eam_item_type = 2;
201: if (l_log and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
202: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
203: 'Rebuild Activity Id is ' || p_rebuild_activity_id);
204: end if;
205: if (l_serial_control_code > 1) then
206:

Line 233: if (l_log and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then

229: and eomd.object_type = 40
230: and eomd.object_id = meaa.activity_association_id;
231: end if;
232: end if;
233: if (l_log and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
234: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
235: 'Finished Validating Rebuild Activity');
236: end if;
237: exception

Line 234: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

230: and eomd.object_id = meaa.activity_association_id;
231: end if;
232: end if;
233: if (l_log and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
234: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
235: 'Finished Validating Rebuild Activity');
236: end if;
237: exception
238: when no_data_found then

Line 248: if (l_log and (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then

244: end if;
245:
246: x_return_status := FND_API.G_RET_STS_SUCCESS;
247: FND_MSG_PUB.Count_And_Get('T', x_msg_count, x_msg_data);
248: if (l_log and (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
249: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'End of ' || l_module);
250: end if;
251:
252: EXCEPTION

Line 249: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'End of ' || l_module);

245:
246: x_return_status := FND_API.G_RET_STS_SUCCESS;
247: FND_MSG_PUB.Count_And_Get('T', x_msg_count, x_msg_data);
248: if (l_log and (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
249: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'End of ' || l_module);
250: end if;
251:
252: EXCEPTION
253: WHEN OTHERS THEN