[Home] [Help]
2965: END derive;
2966:
2967: PROCEDURE validate(p_group_id IN NUMBER,
2968: p_initMsgList IN VARCHAR2) IS
2969: l_params wip_logger.param_tbl_t;
2970: l_returnStatus VARCHAR2(1);
2971: l_logLevel NUMBER ;
2972:
2973: BEGIN
2979: -- write parameter value to log file
2980: if (l_logLevel <= wip_constants.trace_logging) then
2981: l_params(1).paramName := 'p_group_id';
2982: l_params(1).paramValue := p_group_id;
2983: wip_logger.entryPoint(p_procName => 'wip_move_validator.validate',
2984: p_params => l_params,
2985: x_returnStatus => l_returnStatus);
2986: end if;
2987:
3048: -- derive the rest nessary info
3049: derive;
3050: -- write to the log file
3051: if (l_logLevel <= wip_constants.trace_logging) then
3052: wip_logger.exitPoint(p_procName => 'wip_move_validator.validate',
3053: p_procReturnStatus => fnd_api.g_ret_sts_success,
3054: p_msg => 'procedure complete',
3055: x_returnStatus => l_returnStatus);
3056: end if;
3056: end if;
3057: EXCEPTION
3058: WHEN others THEN
3059: if (l_logLevel <= wip_constants.trace_logging) then
3060: wip_logger.exitPoint(p_procName => 'wip_move_validator.validate',
3061: p_procReturnStatus => fnd_api.g_ret_sts_unexp_error,
3062: p_msg => 'Unexpected Errors: ' || SQLERRM,
3063: x_returnStatus => l_returnStatus);
3064: end if;
3139: return p_txn_type;
3140: END move_txn_type;
3141:
3142: PROCEDURE validateOATxn(p_group_id IN NUMBER) IS
3143: l_params wip_logger.param_tbl_t;
3144: l_returnStatus VARCHAR2(1);
3145: l_logLevel NUMBER ;
3146: l_sf_status VARCHAR2(100); /*Fix Bug 9758848*/
3147:
3151: -- write parameter value to log file
3152: if (l_logLevel <= wip_constants.trace_logging) then
3153: l_params(1).paramName := 'p_group_id';
3154: l_params(1).paramValue := p_group_id;
3155: wip_logger.entryPoint(p_procName => 'wip_move_validator.validateOATxn',
3156: p_params => l_params,
3157: x_returnStatus => l_returnStatus);
3158: end if;
3159:
3380: AND wmti.process_status = WIP_CONSTANTS.RUNNING;
3381:
3382: -- write to the log file
3383: if (l_logLevel <= wip_constants.trace_logging) then
3384: wip_logger.exitPoint(p_procName => 'wip_move_validator.validateOATxn',
3385: p_procReturnStatus => fnd_api.g_ret_sts_success,
3386: p_msg => 'procedure complete',
3387: x_returnStatus => l_returnStatus);
3388: end if;
3388: end if;
3389: EXCEPTION
3390: WHEN others THEN
3391: if (l_logLevel <= wip_constants.trace_logging) then
3392: wip_logger.exitPoint(p_procName => 'wip_move_validator.validateOATxn',
3393: p_procReturnStatus => fnd_api.g_ret_sts_unexp_error,
3394: p_msg => 'Unexpected Errors: ' || SQLERRM,
3395: x_returnStatus => l_returnStatus);
3396: end if;