eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EAM_MATERIAL_REQUEST_PVT dependencies on FND_LOG

Line 40: l_current_log_level constant number := FND_LOG.G_CURRENT_RUNTIME_LEVEL ;

36: l_msg VARCHAR2(2000);
37: l_return_status VARCHAR2(2000);
38: allocate_table wip_picking_pub.allocate_comp_tbl_t;
39: l_pickslip_conc_req_id NUMBER := 0;
40: l_current_log_level constant number := FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
41: l_uLog constant BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= l_current_log_level;
42: l_pLog constant BOOLEAN := l_uLog AND FND_LOG.LEVEL_PROCEDURE >= l_current_log_level;
43: l_sLog constant BOOLEAN := l_pLog AND FND_LOG.LEVEL_STATEMENT >= l_current_log_level;
44: l_partial_qty NUMBER := 0;

Line 41: l_uLog constant BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= l_current_log_level;

37: l_return_status VARCHAR2(2000);
38: allocate_table wip_picking_pub.allocate_comp_tbl_t;
39: l_pickslip_conc_req_id NUMBER := 0;
40: l_current_log_level constant number := FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
41: l_uLog constant BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= l_current_log_level;
42: l_pLog constant BOOLEAN := l_uLog AND FND_LOG.LEVEL_PROCEDURE >= l_current_log_level;
43: l_sLog constant BOOLEAN := l_pLog AND FND_LOG.LEVEL_STATEMENT >= l_current_log_level;
44: l_partial_qty NUMBER := 0;
45: l_project_id number := p_project_id;

Line 42: l_pLog constant BOOLEAN := l_uLog AND FND_LOG.LEVEL_PROCEDURE >= l_current_log_level;

38: allocate_table wip_picking_pub.allocate_comp_tbl_t;
39: l_pickslip_conc_req_id NUMBER := 0;
40: l_current_log_level constant number := FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
41: l_uLog constant BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= l_current_log_level;
42: l_pLog constant BOOLEAN := l_uLog AND FND_LOG.LEVEL_PROCEDURE >= l_current_log_level;
43: l_sLog constant BOOLEAN := l_pLog AND FND_LOG.LEVEL_STATEMENT >= l_current_log_level;
44: l_partial_qty NUMBER := 0;
45: l_project_id number := p_project_id;
46: l_task_id number := p_task_id;

Line 43: l_sLog constant BOOLEAN := l_pLog AND FND_LOG.LEVEL_STATEMENT >= l_current_log_level;

39: l_pickslip_conc_req_id NUMBER := 0;
40: l_current_log_level constant number := FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
41: l_uLog constant BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= l_current_log_level;
42: l_pLog constant BOOLEAN := l_uLog AND FND_LOG.LEVEL_PROCEDURE >= l_current_log_level;
43: l_sLog constant BOOLEAN := l_pLog AND FND_LOG.LEVEL_STATEMENT >= l_current_log_level;
44: l_partial_qty NUMBER := 0;
45: l_project_id number := p_project_id;
46: l_task_id number := p_task_id;
47:

Line 85: if (l_pLog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

81: p_data => x_msg_data);
82: return;
83: end if;
84:
85: if (l_pLog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
86: 'Start of ' || l_full_name || '('
87: || 'p_commit='|| p_commit ||','
88: || 'p_wip_entity_type='|| p_wip_entity_type || ','
89: || 'p_organization_id='|| p_organization_id || ','

Line 129: if (l_sLog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

125: allocate_table(1).lot_number := p_lot_number;
126: allocate_table(1).start_serial := p_fm_serial;
127: allocate_table(1).end_serial := p_to_serial;
128:
129: if (l_sLog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
130: 'Calling wip_picking_pub.allocate_comp');
131: end if;
132: wip_picking_pub.allocate_comp(p_alloc_comp_tbl => allocate_table,
133: p_cutoff_date => null,

Line 140: if (l_sLog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

136: x_return_status => l_return_status,
137: x_msg_data => l_msg_data,
138: x_mo_req_number => x_request_number,
139: x_conc_req_id => l_pickslip_conc_req_id);
140: if (l_sLog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
141: 'After Calling wip_picking_pub.allocate_comp');
142: end if;
143: if (l_sLog) then
144: l_msg := 'WIP returned: Request Number:' || x_request_number || ', x_return_status:'

Line 148: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, l_msg);

144: l_msg := 'WIP returned: Request Number:' || x_request_number || ', x_return_status:'
145: || l_return_status|| ', x_msg_data:' || l_msg_data ||
146: ', x_conc_req_id:' || l_pickslip_conc_req_id;
147: l_msg := REPLACE(l_msg, CHR(0), ' ');
148: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, l_msg);
149: end if;
150: x_return_status := l_return_status;
151: if (l_msg_data is not null) then
152: --needed since WIP does not put messages on stack while INV does.

Line 198: if (l_pLog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

194: -- Standard call to get message count and if count is 1, get message info.
195: FND_MSG_PUB.Count_And_Get(
196: p_count => x_msg_count,
197: p_data => x_msg_data);
198: if (l_pLog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
199: 'End of ' || l_full_name );
200: end if;
201: EXCEPTION
202: WHEN FND_API.G_EXC_ERROR THEN

Line 204: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

200: end if;
201: EXCEPTION
202: WHEN FND_API.G_EXC_ERROR THEN
203: ROLLBACK TO ALLOCATE_EAM;
204: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
205: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module,
206: 'Exception Block 1 - Expected Error' );
207: END IF;
208: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 205: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module,

201: EXCEPTION
202: WHEN FND_API.G_EXC_ERROR THEN
203: ROLLBACK TO ALLOCATE_EAM;
204: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
205: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module,
206: 'Exception Block 1 - Expected Error' );
207: END IF;
208: x_return_status := FND_API.G_RET_STS_ERROR ;
209: FND_MSG_PUB.Count_And_Get(

Line 215: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module,

211: p_data => x_msg_data);
212: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
213: ROLLBACK TO ALLOCATE_EAM;
214: IF ( l_uLog ) THEN
215: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module,
216: 'Exception Block 2 - Unexpected error' );
217: END IF ;
218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
219: FND_MSG_PUB.Count_And_Get(

Line 225: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module,

221: p_data => x_msg_data);
222: WHEN OTHERS THEN
223: ROLLBACK TO ALLOCATE_EAM;
224: IF ( l_uLog ) THEN
225: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module,
226: 'Exception Block 3 - Others' );
227: END IF ;
228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
229: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)