107:
108: l_totalNum number;
109: l_returnStatus VARCHAR2(1);
110: l_logLevel NUMBER;
111: l_params wip_logger.param_tbl_t;
112: l_periodID Number;
113: l_temp Number;
114: l_openperiod boolean := false;
115: begin
120:
121: if ( l_logLevel <= wip_constants.trace_logging) then
122: l_params(1).paramName := 'not printing params';
123: l_params(1).paramValue := ' ';
124: wip_logger.entryPoint(p_procName => 'wip_discrete_ws_move.insertMoveRecord',
125: p_params => l_params,
126: x_returnStatus => l_returnStatus);
127: end if;
128:
326: rollback to dsmove1;
327: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
328: wip_utilities.get_message_stack(p_msg => x_errMessage);
329: if (l_logLevel <= wip_constants.trace_logging) then
330: wip_logger.exitPoint(p_procName => 'wip_discrete_ws_move.insertMoveRecord',
331: p_procReturnStatus => x_returnStatus,
332: p_msg => x_errMessage,
333: x_returnStatus => l_returnStatus);
334: end if;
340: fnd_message.set_token ('PROCEDURE', 'wip_discrete_ws_move.processMove');
341: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
342: x_errMessage := fnd_message.get;
343: if (l_logLevel <= wip_constants.trace_logging) then
344: wip_logger.exitPoint(p_procName => 'wip_discrete_ws_move.processMove',
345: p_procReturnStatus => x_returnStatus,
346: p_msg => x_errMessage,
347: x_returnStatus => l_returnStatus);
348: end if;