1: PACKAGE BODY wip_discrete_ws_move AS
2: /* $Header: wipdsmvb.pls 120.2 2006/09/19 06:31:24 paho noship $ */
3:
4: procedure explodeComponents(p_jobID in number,
5: p_orgID in number,
117:
118: if ( l_logLevel <= wip_constants.trace_logging) then
119: l_params(1).paramName := 'not printing params';
120: l_params(1).paramValue := ' ';
121: wip_logger.entryPoint(p_procName => 'wip_discrete_ws_move.insertMoveRecord',
122: p_params => l_params,
123: x_returnStatus => l_returnStatus);
124: end if;
125:
297: rollback to dsmove1;
298: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
299: wip_utilities.get_message_stack(p_msg => x_errMessage);
300: if (l_logLevel <= wip_constants.trace_logging) then
301: wip_logger.exitPoint(p_procName => 'wip_discrete_ws_move.insertMoveRecord',
302: p_procReturnStatus => x_returnStatus,
303: p_msg => x_errMessage,
304: x_returnStatus => l_returnStatus);
305: end if;
307: when others then
308: rollback to dsmove1;
309: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
310: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
311: fnd_message.set_token ('PROCEDURE', 'wip_discrete_ws_move.processMove');
312: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
313: x_errMessage := fnd_message.get;
314: if (l_logLevel <= wip_constants.trace_logging) then
315: wip_logger.exitPoint(p_procName => 'wip_discrete_ws_move.processMove',
311: fnd_message.set_token ('PROCEDURE', 'wip_discrete_ws_move.processMove');
312: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
313: x_errMessage := fnd_message.get;
314: if (l_logLevel <= wip_constants.trace_logging) then
315: wip_logger.exitPoint(p_procName => 'wip_discrete_ws_move.processMove',
316: p_procReturnStatus => x_returnStatus,
317: p_msg => x_errMessage,
318: x_returnStatus => l_returnStatus);
319: end if;
621: END IF;
622: END IF;
623: END get_prj_loc_lov;
624:
625: END wip_discrete_ws_move;