DBA Data[Home] [Help]

APPS.WIP_AUTOSERIALPROC_PRIV dependencies on FND_API

Line 141: raise fnd_api.g_exc_unexpected_error;

137: wip_logger.log('primary_quantity : ' || l_item.primary_quantity,
138: l_returnStatus);
139: wip_logger.log('derived_quantity : ' || l_derivedQty, l_returnStatus);
140: l_errMsg := 'return quantity missmatch';
141: raise fnd_api.g_exc_unexpected_error;
142: END IF;
143:
144: -- Serial control only
145: FOR l_serialComp IN c_serialComp

Line 175: raise fnd_api.g_exc_unexpected_error;

171: wip_logger.log('primary_quantity : ' || l_item.primary_quantity,
172: l_returnStatus);
173: wip_logger.log('derived_quantity : ' || l_derivedQty, l_returnStatus);
174: l_errMsg := 'return quantity missmatch : ' || l_item.item_name;
175: raise fnd_api.g_exc_unexpected_error;
176: END IF;
177:
178: IF (l_logLevel <= wip_constants.trace_logging) THEN
179: wip_logger.exitPoint(

Line 187: WHEN fnd_api.g_exc_unexpected_error THEN

183: x_returnStatus => l_returnStatus); --discard return status
184: END IF;
185:
186: EXCEPTION
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',

Line 188: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

184: END IF;
185:
186: EXCEPTION
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,

Line 202: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

198: fnd_message.set_token('ENTITY1', l_item.item_name);
199: fnd_msg_pub.add;
200:
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,

Line 290: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

286: IF(c_revisionComp%ISOPEN) THEN
287: CLOSE c_revisionComp;
288: END IF;
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,

Line 322: * x_returnStatus fnd_api.g_ret_sts_success if success without any errors.

318: * p_objectID Object_id of the parent serial(assembly). Used to derive
319: * all the child serial number
320: * p_orgID Organization ID
321: * p_initMsgList Initialize the message list?
322: * x_returnStatus fnd_api.g_ret_sts_success if success without any errors.
323: * Otherwise return fnd_api.g_ret_sts_unexp_error.
324: ****************************************************************************/
325: PROCEDURE deriveSerial(x_compLots IN OUT NOCOPY system.wip_lot_serial_obj_t,
326: p_orgID IN NUMBER,

Line 323: * Otherwise return fnd_api.g_ret_sts_unexp_error.

319: * all the child serial number
320: * p_orgID Organization ID
321: * p_initMsgList Initialize the message list?
322: * x_returnStatus fnd_api.g_ret_sts_success if success without any errors.
323: * Otherwise return fnd_api.g_ret_sts_unexp_error.
324: ****************************************************************************/
325: PROCEDURE deriveSerial(x_compLots IN OUT NOCOPY system.wip_lot_serial_obj_t,
326: p_orgID IN NUMBER,
327: p_objectID IN NUMBER,

Line 347: IF(fnd_api.to_boolean(p_initMsgList)) THEN

343: END IF;
344:
345: SAVEPOINT wipbflpb40;
346:
347: IF(fnd_api.to_boolean(p_initMsgList)) THEN
348: fnd_msg_pub.initialize;
349: END IF;
350:
351: x_compLots.reset;

Line 353: x_returnStatus := fnd_api.g_ret_sts_success;

349: END IF;
350:
351: x_compLots.reset;
352: --assume we will be able to derive everything
353: x_returnStatus := fnd_api.g_ret_sts_success;
354:
355: LOOP
356: IF(x_compLots.getCurrentItem(l_curItem)) THEN
357: IF(l_curItem.wip_supply_type NOT IN (WIP_CONSTANTS.PUSH,

Line 376: IF(l_returnStatus = fnd_api.g_ret_sts_unexp_error) THEN

372: p_item => l_curItem,
373: x_compLots => x_compLots,
374: x_returnStatus => l_returnStatus);
375:
376: IF(l_returnStatus = fnd_api.g_ret_sts_unexp_error) THEN
377: l_errMsg := 'setItemRevision failed';
378: raise fnd_api.g_exc_unexpected_error;
379: END IF;
380: END IF;

Line 378: raise fnd_api.g_exc_unexpected_error;

374: x_returnStatus => l_returnStatus);
375:
376: IF(l_returnStatus = fnd_api.g_ret_sts_unexp_error) THEN
377: l_errMsg := 'setItemRevision failed';
378: raise fnd_api.g_exc_unexpected_error;
379: END IF;
380: END IF;
381:
382: deriveSingleItem(p_parentObjID => p_objectID,

Line 387: IF(l_returnStatus = fnd_api.g_ret_sts_unexp_error) THEN

383: p_orgID => p_orgID,
384: x_compLots => x_compLots,
385: x_returnStatus => l_returnStatus);
386:
387: IF(l_returnStatus = fnd_api.g_ret_sts_unexp_error) THEN
388: l_errMsg := 'deriveSingleItem failed';
389: raise fnd_api.g_exc_unexpected_error;
390: END IF;
391:

Line 389: raise fnd_api.g_exc_unexpected_error;

385: x_returnStatus => l_returnStatus);
386:
387: IF(l_returnStatus = fnd_api.g_ret_sts_unexp_error) THEN
388: l_errMsg := 'deriveSingleItem failed';
389: raise fnd_api.g_exc_unexpected_error;
390: END IF;
391:
392: END IF; -- x_compLots.getCurrentItem(l_curItem)
393: <>

Line 407: WHEN fnd_api.g_exc_unexpected_error THEN

403: x_returnStatus => l_returnStatus);
404: END IF;
405:
406: EXCEPTION
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',

Line 408: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

404: END IF;
405:
406: EXCEPTION
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,

Line 419: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

415: END IF;
416: ROLLBACK TO wipbflpb40;
417:
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,