APPS.WIP_MOVPROC_GRP dependencies on WIP_MOVPROC_GRP

Line 1: PACKAGE BODY wip_movProc_grp AS

1: PACKAGE BODY wip_movProc_grp AS
2: /* $Header: wipmvgpb.pls 120.1 2006/04/27 16:58:19 kboonyap noship $*/
3: PROCEDURE backflush(p_wipEntityID IN NUMBER,
4: p_orgID IN NUMBER,
5: p_primaryQty IN NUMBER,

Line 171: wip_logger.entryPoint(p_procName => 'wip_movProc_grp.processInterface',

167: l_params(5).paramValue := p_cplTxnID;
168: l_params(6).paramName := 'p_commit';
169: l_params(6).paramValue := p_commit;
170:
171: wip_logger.entryPoint(p_procName => 'wip_movProc_grp.processInterface',
172: p_params => l_params,
173: x_returnStatus => l_returnStatus);
174:
175: END IF;

Line 215: wip_logger.exitPoint(p_procName => 'wip_movProc_grp.processInterface',

211: COMMIT;
212: END IF;
213:
214: IF (l_logLevel <= wip_constants.trace_logging) THEN
215: wip_logger.exitPoint(p_procName => 'wip_movProc_grp.processInterface',
216: p_procReturnStatus => x_returnStatus,
217: p_msg => 'procedure complete',
218: x_returnStatus => l_returnStatus);
219: wip_logger.cleanUp(x_returnStatus => l_returnStatus);

Line 237: wip_logger.exitPoint(p_procName => 'wip_movProc_grp.processInterface',

233: inv_mobile_helper_functions.get_stacked_messages(x_errorMsg);
234: END IF;
235:
236: IF (l_logLevel <= wip_constants.trace_logging) THEN
237: wip_logger.exitPoint(p_procName => 'wip_movProc_grp.processInterface',
238: p_procReturnStatus => x_returnStatus,
239: p_msg => 'wip_movProc_priv.processIntf failed',
240: x_returnStatus => l_returnStatus);
241: wip_logger.cleanUp(x_returnStatus => l_returnStatus);

Line 251: wip_logger.exitPoint(p_procName => 'wip_movProc_grp.processInterface',

247: fnd_message.set_token('ENTITY', 'TRANSACTION_ID');
248: x_errorMsg := substr(fnd_message.get, 1, 1000);
249:
250: IF (l_logLevel <= wip_constants.trace_logging) THEN
251: wip_logger.exitPoint(p_procName => 'wip_movProc_grp.processInterface',
252: p_procReturnStatus => x_returnStatus,
253: p_msg => 'to many rows: ' || SQLERRM,
254: x_returnStatus => l_returnStatus);
255: wip_logger.cleanUp(x_returnStatus => l_returnStatus);

Line 266: wip_logger.exitPoint(p_procName => 'wip_movProc_grp.processInterface',

262: 'TRANSACTION_ID/GROUP_ID/PROCESS_PHASE/PROCESS_STATUS');
263: x_errorMsg := substr(fnd_message.get, 1, 1000);
264:
265: IF (l_logLevel <= wip_constants.trace_logging) THEN
266: wip_logger.exitPoint(p_procName => 'wip_movProc_grp.processInterface',
267: p_procReturnStatus => x_returnStatus,
268: p_msg => 'no data found: ' || SQLERRM,
269: x_returnStatus => l_returnStatus);
270: wip_logger.cleanUp(x_returnStatus => l_returnStatus);

Line 277: wip_logger.exitPoint(p_procName => 'wip_movProc_grp.processInterface',

273: WHEN others THEN
274: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
275: x_errorMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
276: IF (l_logLevel <= wip_constants.trace_logging) THEN
277: wip_logger.exitPoint(p_procName => 'wip_movProc_grp.processInterface',
278: p_procReturnStatus => x_returnStatus,
279: p_msg => x_errorMsg,
280: x_returnStatus => l_returnStatus);
281: wip_logger.cleanUp(x_returnStatus => l_returnStatus);

Line 304: wip_logger.entryPoint(p_procName => 'wip_movProc_grp.processInterface',

300: l_params(1).paramName := 'p_groupID';
301: l_params(1).paramValue := p_groupID;
302: l_params(2).paramName := 'p_commit';
303: l_params(2).paramValue := p_commit;
304: wip_logger.entryPoint(p_procName => 'wip_movProc_grp.processInterface',
305: p_params => l_params,
306: x_returnStatus => l_returnStatus);
307:
308: END IF;

Line 333: wip_logger.exitPoint(p_procName => 'wip_movProc_grp.processInterface',

329: COMMIT;
330: END IF;
331:
332: IF (l_logLevel <= wip_constants.trace_logging) THEN
333: wip_logger.exitPoint(p_procName => 'wip_movProc_grp.processInterface',
334: p_procReturnStatus => x_returnStatus,
335: p_msg => 'no record in this group error out',
336: x_returnStatus => l_returnStatus);
337: wip_logger.cleanUp(x_returnStatus => l_returnStatus);

Line 345: wip_logger.exitPoint(p_procName => 'wip_movProc_grp.processInterface',

341: WHEN fnd_api.g_exc_error THEN
342: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
343:
344: IF (l_logLevel <= wip_constants.trace_logging) THEN
345: wip_logger.exitPoint(p_procName => 'wip_movProc_grp.processInterface',
346: p_procReturnStatus => x_returnStatus,
347: p_msg => 'some records in this group error out',
348: x_returnStatus => l_returnStatus);
349: wip_logger.cleanUp(x_returnStatus => l_returnStatus);

Line 356: wip_logger.exitPoint(p_procName => 'wip_movProc_grp.processInterface',

352: WHEN others THEN
353: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
354:
355: IF (l_logLevel <= wip_constants.trace_logging) THEN
356: wip_logger.exitPoint(p_procName => 'wip_movProc_grp.processInterface',
357: p_procReturnStatus => x_returnStatus,
358: p_msg => 'unexpected error: ' || SQLERRM,
359: x_returnStatus => l_returnStatus);
360: wip_logger.cleanUp(x_returnStatus => l_returnStatus);

Line 364: END wip_movProc_grp;

360: wip_logger.cleanUp(x_returnStatus => l_returnStatus);
361: END IF;
362: END processInterface;
363:
364: END wip_movProc_grp;