APPS.WMA_INV_WRAPPERS dependencies on WIP_CONSTANTS

Line 387: if(l_logLevel <= wip_constants.trace_logging) then

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';
389: l_params(1).paramValue := p_header_id;
390: l_params(2).paramName := 'p_subinventory_code';
391: l_params(2).paramValue := p_subinventory_code;

Line 412: if(l_entityType = wip_constants.discrete) then

408: where header_id = p_header_id
409: returning wip_entity_id, organization_id, inventory_item_id, wip_entity_type
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,

Line 413: if(l_logLevel <= wip_constants.full_logging) then

409: returning wip_entity_id, organization_id, inventory_item_id, wip_entity_type
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,

Line 427: elsif(l_entityType = wip_constants.flow) then

423: p_lot_number => p_lot_number,
424: x_return_status => x_return_status,
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

Line 428: if(l_logLevel <= wip_constants.full_logging) then

424: x_return_status => x_return_status,
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

Line 440: and bom_item_type = wip_constants.standard_type

436: where inventory_item_id = l_itemID
437: and organization_id = l_orgID
438: and build_in_wip_flag = 'Y'
439: and base_item_id is not null
440: and bom_item_type = wip_constants.standard_type
441: and replenish_to_order_flag = 'Y';
442: if(l_ctoItemCount > 0) then
443: */
444: select count(*)

Line 451: if(l_logLevel <= wip_constants.full_logging) then

447: where header_id = p_header_id
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,

Line 463: if(l_logLevel <= wip_constants.trace_logging) then

459: x_msg_count => x_msg_count,
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);

Line 471: if(l_logLevel <= wip_constants.trace_logging) then

467: x_returnStatus => l_dummy);
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);