DBA Data[Home] [Help]

APPS.WIP_AUTOSERIALPROC_PRIV dependencies on WIP_AUTOSERIALPROC_PRIV

Line 1: PACKAGE BODY wip_autoSerialProc_priv AS

1: PACKAGE BODY wip_autoSerialProc_priv AS
2: /* $Header: wipserpb.pls 115.5 2004/03/30 00:15:16 kboonyap ship $ */
3:
4: PROCEDURE deriveSingleItem
5: (p_parentObjID IN NUMBER,

Line 89: p_procName => 'wip_autoSerialProc_priv.deriveSingleItem',

85: l_params(8).paramValue := l_item.primary_quantity;
86: l_params(9).paramName := 'x_compLot(cur_item).transaction_action_id';
87: l_params(9).paramValue := l_item.transaction_action_id;
88: wip_logger.entryPoint(
89: p_procName => 'wip_autoSerialProc_priv.deriveSingleItem',
90: p_params => l_params,
91: x_returnStatus => x_returnStatus);
92: END IF;
93:

Line 180: p_procName => 'wip_autoSerialProc_priv.deriveSingleItem',

176: END IF;
177:
178: IF (l_logLevel <= wip_constants.trace_logging) THEN
179: wip_logger.exitPoint(
180: p_procName => 'wip_autoSerialProc_priv.deriveSingleItem',
181: p_procReturnStatus => x_returnStatus,
182: p_msg => 'procedure success',
183: x_returnStatus => l_returnStatus); --discard return status
184: END IF;

Line 191: p_procName => 'wip_autoSerialProc_priv.deriveSingleItem',

187: WHEN fnd_api.g_exc_unexpected_error THEN
188: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
189: IF (l_logLevel <= wip_constants.trace_logging) THEN
190: wip_logger.exitPoint(
191: p_procName => 'wip_autoSerialProc_priv.deriveSingleItem',
192: p_procReturnStatus => x_returnStatus,
193: p_msg => l_errMsg,
194: x_returnStatus => l_returnStatus); --discard return status
195: END IF;

Line 205: p_procName => 'wip_autoSerialProc_priv.deriveSingleItem',

201: WHEN others THEN
202: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
203: IF (l_logLevel <= wip_constants.trace_logging) THEN
204: wip_logger.exitPoint(
205: p_procName => 'wip_autoSerialProc_priv.deriveSingleItem',
206: p_procReturnStatus => x_returnStatus,
207: p_msg => 'unexp error:' || SQLERRM,
208: x_returnStatus => l_returnStatus); --discard return status
209: END IF;

Line 260: p_procName => 'wip_autoSerialProc_priv.setItemRevision',

256: l_params(8).paramValue := p_item.primary_quantity;
257: l_params(9).paramName := 'p_item.transaction_action_id';
258: l_params(9).paramValue := p_item.transaction_action_id;
259: wip_logger.entryPoint(
260: p_procName => 'wip_autoSerialProc_priv.setItemRevision',
261: p_params => l_params,
262: x_returnStatus => x_returnStatus);
263: END IF;
264:

Line 278: p_procName => 'wip_autoSerialProc_priv.setItemRevision',

274: END IF;
275:
276: IF (l_logLevel <= wip_constants.trace_logging) THEN
277: wip_logger.exitPoint(
278: p_procName => 'wip_autoSerialProc_priv.setItemRevision',
279: p_procReturnStatus => x_returnStatus,
280: p_msg => 'procedure success',
281: x_returnStatus => l_returnStatus); --discard return status
282: END IF;

Line 293: p_procName => 'wip_autoSerialProc_priv.setItemRevision',

289:
290: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
291: IF (l_logLevel <= wip_constants.trace_logging) THEN
292: wip_logger.exitPoint(
293: p_procName => 'wip_autoSerialProc_priv.setItemRevision',
294: p_procReturnStatus => x_returnStatus,
295: p_msg => 'unexp error:' || SQLERRM,
296: x_returnStatus => l_returnStatus); --discard return status
297: END IF;

Line 340: p_procName => 'wip_autoSerialProc_priv.deriveSerial',

336: IF (l_logLevel <= wip_constants.trace_logging) THEN
337: l_params(1).paramName := 'p_objectID';
338: l_params(1).paramValue := p_objectID;
339: wip_logger.entryPoint(
340: p_procName => 'wip_autoSerialProc_priv.deriveSerial',
341: p_params => l_params,
342: x_returnStatus => x_returnStatus);
343: END IF;
344:

Line 400: p_procName => 'wip_autoSerialProc_priv.deriveSerial',

396: END LOOP;
397:
398: IF (l_logLevel <= wip_constants.trace_logging) THEN
399: wip_logger.exitPoint(
400: p_procName => 'wip_autoSerialProc_priv.deriveSerial',
401: p_procReturnStatus => x_returnStatus,
402: p_msg => 'procedure success',
403: x_returnStatus => l_returnStatus);
404: END IF;

Line 411: p_procName => 'wip_autoSerialProc_priv.deriveSerial',

407: WHEN fnd_api.g_exc_unexpected_error THEN
408: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
409: IF (l_logLevel <= wip_constants.trace_logging) THEN
410: wip_logger.exitPoint(
411: p_procName => 'wip_autoSerialProc_priv.deriveSerial',
412: p_procReturnStatus => x_returnStatus,
413: p_msg => l_errMsg,
414: x_returnStatus => l_returnStatus); --discard return status
415: END IF;

Line 422: p_procName => 'wip_autoSerialProc_priv.deriveSerial',

418: WHEN others THEN
419: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
420: IF (l_logLevel <= wip_constants.trace_logging) THEN
421: wip_logger.exitPoint(
422: p_procName => 'wip_autoSerialProc_priv.deriveSerial',
423: p_procReturnStatus => x_returnStatus,
424: p_msg => 'unexpected error:' || SQLERRM,
425: x_returnStatus => l_returnStatus); --discard return status
426: END IF;

Line 430: END wip_autoSerialProc_priv;

426: END IF;
427: ROLLBACK TO wipbflpb40;
428:
429: END deriveSerial;
430: END wip_autoSerialProc_priv;