APPS.WIP_SF_STATUS dependencies on WIP_LOGGER

Line 419: l_params wip_logger.param_tbl_t;

415:
416: FUNCTION count_no_move_last_step(p_org_id IN NUMBER,
417: p_wip_id IN NUMBER) RETURN NUMBER IS
418:
419: l_params wip_logger.param_tbl_t;
420: l_returnStatus VARCHAR2(1);
421: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
422: l_no_move_count NUMBER := 0;
423: BEGIN

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

426: l_params(1).paramName := 'p_org_id';
427: l_params(1).paramValue := p_org_id;
428: l_params(2).paramName := 'p_wip_id';
429: l_params(2).paramValue := p_wip_id;
430: wip_logger.entryPoint(p_procName => 'wip_sf_status.count_no_move_last_step',
431: p_params => l_params,
432: x_returnStatus => l_returnStatus);
433: END IF;
434:

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

453: AND wsc.status_move_flag = WIP_CONSTANTS.NO
454: AND NVL(wsc.disable_date, SYSDATE + 1) > SYSDATE;
455:
456: IF (l_logLevel <= wip_constants.trace_logging) THEN
457: wip_logger.exitPoint(p_procName => 'wip_sf_status.count_no_move_last_step',
458: p_procReturnStatus => fnd_api.g_ret_sts_success,
459: p_msg => 'procedure complete',
460: x_returnStatus => l_returnStatus);
461: END IF;

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

462: RETURN l_no_move_count;
463: EXCEPTION
464: WHEN others THEN
465: IF (l_logLevel <= wip_constants.trace_logging) THEN
466: wip_logger.exitPoint(p_procName => 'wip_sf_status.count_no_move_last_step',
467: p_procReturnStatus => fnd_api.g_ret_sts_unexp_error,
468: p_msg => 'Unexpected Errors: ' || SQLERRM,
469: x_returnStatus => l_returnStatus);
470: END IF;