DBA Data[Home] [Help]

APPS.WIP_EAMWORKORDER_PVT dependencies on FND_LOG

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

19: l_api_name CONSTANT VARCHAR2(30) := 'Create_EAM_Work_Order';
20: l_api_version CONSTANT NUMBER := 1.0;
21: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
22: l_module CONSTANT VARCHAR2(60) := 'wip.plsql.'||l_full_name;
23: l_log boolean := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
24: l_request_id NUMBER := 0;
25: l_debug VARCHAR2(1);
26: l_scheduled_start_date DATE;
27: l_scheduled_completion_date DATE;

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

66: l_out_eam_mat_req_tbl EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type;
67: l_out_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
68:
69: BEGIN
70: if (l_log and (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
71: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Start of ' || l_module);
72: end if;
73: l_maint_obj_fnd :='N';
74: l_eam_wo_rec.asset_activity_id := p_work_order_rec.primary_item_id;

Line 71: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Start of ' || l_module);

67: l_out_eam_di_tbl EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
68:
69: BEGIN
70: if (l_log and (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
71: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Start of ' || l_module);
72: end if;
73: l_maint_obj_fnd :='N';
74: l_eam_wo_rec.asset_activity_id := p_work_order_rec.primary_item_id;
75:

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

211: NULL;
212: END;
213: END IF;
214:
215: if (l_log and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
216: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
217: 'l_gen_object_id: ' || l_gen_object_id);
218: end if;
219: l_eam_wo_rec.status_type := p_work_order_rec.status_type;

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

212: END;
213: END IF;
214:
215: if (l_log and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
216: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
217: 'l_gen_object_id: ' || l_gen_object_id);
218: end if;
219: l_eam_wo_rec.status_type := p_work_order_rec.status_type;
220:

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

240: l_eam_wo_rec.activity_cause :=p_work_order_rec.activity_cause;
241: l_eam_wo_rec.activity_source := p_work_order_rec.activity_source;
242: l_eam_wo_rec.work_order_type := p_work_order_rec.work_order_type;
243:
244: if (l_log and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
245: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, 'Fetching default owning dept');
246: end if;
247: IF p_work_order_rec.owning_department is not null THEN
248: l_dept_id := p_work_order_rec.owning_department;

Line 245: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, 'Fetching default owning dept');

241: l_eam_wo_rec.activity_source := p_work_order_rec.activity_source;
242: l_eam_wo_rec.work_order_type := p_work_order_rec.work_order_type;
243:
244: if (l_log and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
245: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, 'Fetching default owning dept');
246: end if;
247: IF p_work_order_rec.owning_department is not null THEN
248: l_dept_id := p_work_order_rec.owning_department;
249: ELSE if p_work_order_rec.owning_department_code is not null THEN

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

272: /* If the Department of Work Order cannot be set then change the status of Work Order to Unrelease */
273: IF l_dept_id is null and p_work_order_rec.status_type not in (1,6,17) THEN
274: l_eam_wo_rec.status_type:=1;
275: END IF ;
276: if (l_log and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
277: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, 'default owning dept id:'
278: || l_dept_id);
279: end if;
280:

Line 277: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, 'default owning dept id:'

273: IF l_dept_id is null and p_work_order_rec.status_type not in (1,6,17) THEN
274: l_eam_wo_rec.status_type:=1;
275: END IF ;
276: if (l_log and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
277: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, 'default owning dept id:'
278: || l_dept_id);
279: end if;
280:
281: l_eam_wo_rec.job_quantity := null;

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

347: l_eam_wo_rec.source_code := p_work_order_rec.source_code;
348: -- l_eam_wo_rec.return_status :=
349: l_eam_wo_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
350:
351: if (l_log and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
352: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, 'Calling work order API');
353: end if;
354: EAM_PROCESS_WO_PUB.Process_WO
355: ( p_bo_identifier => 'EAM'

Line 352: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, 'Calling work order API');

348: -- l_eam_wo_rec.return_status :=
349: l_eam_wo_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
350:
351: if (l_log and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
352: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, 'Calling work order API');
353: end if;
354: EAM_PROCESS_WO_PUB.Process_WO
355: ( p_bo_identifier => 'EAM'
356: , p_init_msg_list => TRUE

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

380: , p_debug_filename => 'wipvewob.log'
381: , p_output_dir => l_output_dir
382: , p_debug_file_mode => 'W'
383: );
384: if (l_log and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
385: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
386: 'work order API returned status: '|| l_return_status);
387: end if;
388:

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

381: , p_output_dir => l_output_dir
382: , p_debug_file_mode => 'W'
383: );
384: if (l_log and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
385: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
386: 'work order API returned status: '|| l_return_status);
387: end if;
388:
389: if(l_return_status <> FND_API.G_RET_STS_SUCCESS) then