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 120.1 2010/08/03 10:30:22 pfauzdar ship $ */
3:
4: ----------------------
5: --forward declarations

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

90: l_params(8).paramValue := l_item.primary_quantity;
91: l_params(9).paramName := 'x_compLot(cur_item).transaction_action_id';
92: l_params(9).paramValue := l_item.transaction_action_id;
93: wip_logger.entryPoint(
94: p_procName => 'wip_autoSerialProc_priv.deriveSingleItem',
95: p_params => l_params,
96: x_returnStatus => x_returnStatus);
97: END IF;
98:

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

181: END IF;
182:
183: IF (l_logLevel <= wip_constants.trace_logging) THEN
184: wip_logger.exitPoint(
185: p_procName => 'wip_autoSerialProc_priv.deriveSingleItem',
186: p_procReturnStatus => x_returnStatus,
187: p_msg => 'procedure success',
188: x_returnStatus => l_returnStatus); --discard return status
189: END IF;

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

192: WHEN fnd_api.g_exc_unexpected_error THEN
193: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
194: IF (l_logLevel <= wip_constants.trace_logging) THEN
195: wip_logger.exitPoint(
196: p_procName => 'wip_autoSerialProc_priv.deriveSingleItem',
197: p_procReturnStatus => x_returnStatus,
198: p_msg => l_errMsg,
199: x_returnStatus => l_returnStatus); --discard return status
200: END IF;

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

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

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

261: l_params(8).paramValue := p_item.primary_quantity;
262: l_params(9).paramName := 'p_item.transaction_action_id';
263: l_params(9).paramValue := p_item.transaction_action_id;
264: wip_logger.entryPoint(
265: p_procName => 'wip_autoSerialProc_priv.setItemRevision',
266: p_params => l_params,
267: x_returnStatus => x_returnStatus);
268: END IF;
269:

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

279: END IF;
280:
281: IF (l_logLevel <= wip_constants.trace_logging) THEN
282: wip_logger.exitPoint(
283: p_procName => 'wip_autoSerialProc_priv.setItemRevision',
284: p_procReturnStatus => x_returnStatus,
285: p_msg => 'procedure success',
286: x_returnStatus => l_returnStatus); --discard return status
287: END IF;

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

294:
295: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
296: IF (l_logLevel <= wip_constants.trace_logging) THEN
297: wip_logger.exitPoint(
298: p_procName => 'wip_autoSerialProc_priv.setItemRevision',
299: p_procReturnStatus => x_returnStatus,
300: p_msg => 'unexp error:' || SQLERRM,
301: x_returnStatus => l_returnStatus); --discard return status
302: END IF;

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

342: IF (l_logLevel <= wip_constants.trace_logging) THEN
343: l_params(1).paramName := 'p_objectID';
344: l_params(1).paramValue := p_objectID;
345: wip_logger.entryPoint(
346: p_procName => 'wip_autoSerialProc_priv.deriveSerial',
347: p_params => l_params,
348: x_returnStatus => x_returnStatus);
349: END IF;
350:

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

407: END LOOP;
408:
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 => 'procedure success',
414: x_returnStatus => l_returnStatus);
415: END IF;

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

418: WHEN fnd_api.g_exc_unexpected_error 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 => l_errMsg,
425: x_returnStatus => l_returnStatus); --discard return status
426: END IF;

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

429: WHEN others THEN
430: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
431: IF (l_logLevel <= wip_constants.trace_logging) THEN
432: wip_logger.exitPoint(
433: p_procName => 'wip_autoSerialProc_priv.deriveSerial',
434: p_procReturnStatus => x_returnStatus,
435: p_msg => 'unexpected error:' || SQLERRM,
436: x_returnStatus => l_returnStatus); --discard return status
437: END IF;

Line 456: END wip_autoSerialProc_priv;

452: end if;
453: return -1; --this procedure only works for component txn types
454: end getTxnType;
455:
456: END wip_autoSerialProc_priv;
457: