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.2 2006/01/10 18:04:37 kboonyap noship $ */
3:
4: PROCEDURE INSERT_STATUS
5: (P_wip_entity_id IN NUMBER,

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;

Line 473: END WIP_SF_STATUS;

469: x_returnStatus => l_returnStatus);
470: END IF;
471: END count_no_move_last_step;
472:
473: END WIP_SF_STATUS;