DBA Data[Home] [Help]

APPS.WIP_SF_STATUS dependencies on WIP_SF_STATUS

Line 1: PACKAGE BODY WIP_SF_STATUS AS

1: PACKAGE BODY WIP_SF_STATUS AS
2: /* $Header: wipsfstb.pls 120.3.12020000.2 2012/07/18 18:16:34 ankohli ship $ */
3:
4: PROCEDURE INSERT_STATUS
5: (P_wip_entity_id IN NUMBER,

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;

Line 612: END WIP_SF_STATUS;

608:
609: return(x_sf_status);
610: end get_no_move_status;
611:
612: END WIP_SF_STATUS;