DBA Data[Home] [Help]

APPS.WMA_INV_WRAPPERS dependencies on WIP_LOGGER

Line 384: l_params wip_logger.param_tbl_t;

380: l_entityType NUMBER;
381: l_ctoItemCount NUMBER;
382: l_soExistsFlag NUMBER;
383: l_dummy VARCHAR2(1);
384: l_params wip_logger.param_tbl_t;
385: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
386: BEGIN
387: if(l_logLevel <= wip_constants.trace_logging) then
388: l_params(1).paramName := 'p_header_id';

Line 401: wip_logger.entryPoint(p_procName => 'wma_inv_wrappers.transferReservation',

397: l_params(5).paramValue := p_lpn_id;
398: l_params(6).paramName := 'p_lot_number';
399: l_params(6).paramValue := p_lot_number;
400:
401: wip_logger.entryPoint(p_procName => 'wma_inv_wrappers.transferReservation',
402: p_params => l_params,
403: x_returnStatus => l_dummy);
404: end if;
405: update wip_lpn_completions

Line 414: wip_logger.log('discrete', l_dummy);

410: into l_wipID, l_orgID, l_itemID, l_entityType;
411:
412: if(l_entityType = wip_constants.discrete) then
413: if(l_logLevel <= wip_constants.full_logging) then
414: wip_logger.log('discrete', l_dummy);
415: end if;
416: wip_so_reservations.allocate_completion_to_so(p_organization_id => l_orgID,
417: p_wip_entity_id => l_wipID,
418: p_inventory_item_id => l_itemID,

Line 429: wip_logger.log('flow', l_dummy);

425: x_msg_count => x_msg_count,
426: x_msg_data => x_err_msg);
427: elsif(l_entityType = wip_constants.flow) then
428: if(l_logLevel <= wip_constants.full_logging) then
429: wip_logger.log('flow', l_dummy);
430: end if;
431: /* commented out as Sales Order will be entered through UI
432: --only transfer reservations for CTO items
433: select count(*)

Line 452: wip_logger.log('found cto item', l_dummy);

448: and demand_source_header_id is not null
449: and demand_source_line is not null;
450: if(l_soExistsFlag > 0) then
451: if(l_logLevel <= wip_constants.full_logging) then
452: wip_logger.log('found cto item', l_dummy);
453: end if;
454: wip_so_reservations.complete_flow_sched_to_so(p_header_id => p_header_id,
455: p_lpn_id => p_lpn_id,
456: p_primary_quantity => p_primary_quantity,

Line 464: wip_logger.exitPoint(p_procName => 'wma_inv_wrappers.transferReservation',

460: x_msg_data => x_err_msg);
461: end if;
462: end if;
463: if(l_logLevel <= wip_constants.trace_logging) then
464: wip_logger.exitPoint(p_procName => 'wma_inv_wrappers.transferReservation',
465: p_procReturnStatus => x_return_status,
466: p_msg => 'success',
467: x_returnStatus => l_dummy);
468: end if;

Line 472: wip_logger.exitPoint(p_procName => 'wma_inv_wrappers.transferReservation',

468: end if;
469: exception
470: when others then
471: if(l_logLevel <= wip_constants.trace_logging) then
472: wip_logger.exitPoint(p_procName => 'wma_inv_wrappers.transferReservation',
473: p_procReturnStatus => x_return_status,
474: p_msg => 'error:' || x_err_msg,
475: x_returnStatus => l_dummy);
476: end if;

Line 478: wip_logger.log('unhandled exception ' || SQLERRM, l_dummy);

474: p_msg => 'error:' || x_err_msg,
475: x_returnStatus => l_dummy);
476: end if;
477: x_return_status := FND_API.G_RET_STS_ERROR;
478: wip_logger.log('unhandled exception ' || SQLERRM, l_dummy);
479: fnd_message.set_name('WIP', 'GENERIC_ERROR');
480: fnd_message.set_token('FUNCTION', 'wmainvwb.transferReservation');
481: fnd_message.set_token('ERROR', SQLERRM);
482: fnd_msg_pub.add;