APPS.WIP_SF_STATUS dependencies on WIP_LOGGER

Line 431: l_params wip_logger.param_tbl_t;

427:
428: FUNCTION count_no_move_last_step(p_org_id IN NUMBER,
429: p_wip_id IN NUMBER) RETURN NUMBER IS
430:
431: l_params wip_logger.param_tbl_t;
432: l_returnStatus VARCHAR2(1);
433: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
434: l_no_move_count NUMBER := 0;
435: BEGIN

Line 442: wip_logger.entryPoint(p_procName => 'wip_sf_status.count_no_move_last_step',

438: l_params(1).paramName := 'p_org_id';
439: l_params(1).paramValue := p_org_id;
440: l_params(2).paramName := 'p_wip_id';
441: l_params(2).paramValue := p_wip_id;
442: wip_logger.entryPoint(p_procName => 'wip_sf_status.count_no_move_last_step',
443: p_params => l_params,
444: x_returnStatus => l_returnStatus);
445: END IF;
446:

Line 469: wip_logger.exitPoint(p_procName => 'wip_sf_status.count_no_move_last_step',

465: AND wsc.status_move_flag = WIP_CONSTANTS.NO
466: AND NVL(wsc.disable_date, SYSDATE + 1) > SYSDATE;
467:
468: IF (l_logLevel <= wip_constants.trace_logging) THEN
469: wip_logger.exitPoint(p_procName => 'wip_sf_status.count_no_move_last_step',
470: p_procReturnStatus => fnd_api.g_ret_sts_success,
471: p_msg => 'procedure complete',
472: x_returnStatus => l_returnStatus);
473: END IF;

Line 478: wip_logger.exitPoint(p_procName => 'wip_sf_status.count_no_move_last_step',

474: RETURN l_no_move_count;
475: EXCEPTION
476: WHEN others THEN
477: IF (l_logLevel <= wip_constants.trace_logging) THEN
478: wip_logger.exitPoint(p_procName => 'wip_sf_status.count_no_move_last_step',
479: p_procReturnStatus => fnd_api.g_ret_sts_unexp_error,
480: p_msg => 'Unexpected Errors: ' || SQLERRM,
481: x_returnStatus => l_returnStatus);
482: END IF;