DBA Data[Home] [Help]

APPS.WIP_AUTOSERIALPROC_PRIV dependencies on FND_API

Line 146: raise fnd_api.g_exc_unexpected_error;

142: wip_logger.log('primary_quantity : ' || l_item.primary_quantity,
143: l_returnStatus);
144: wip_logger.log('derived_quantity : ' || l_derivedQty, l_returnStatus);
145: l_errMsg := 'return quantity missmatch';
146: raise fnd_api.g_exc_unexpected_error;
147: END IF;
148:
149: -- Serial control only
150: FOR l_serialComp IN c_serialComp

Line 180: raise fnd_api.g_exc_unexpected_error;

176: wip_logger.log('primary_quantity : ' || l_item.primary_quantity,
177: l_returnStatus);
178: wip_logger.log('derived_quantity : ' || l_derivedQty, l_returnStatus);
179: l_errMsg := 'return quantity missmatch : ' || l_item.item_name;
180: raise fnd_api.g_exc_unexpected_error;
181: END IF;
182:
183: IF (l_logLevel <= wip_constants.trace_logging) THEN
184: wip_logger.exitPoint(

Line 192: WHEN fnd_api.g_exc_unexpected_error THEN

188: x_returnStatus => l_returnStatus); --discard return status
189: END IF;
190:
191: EXCEPTION
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',

Line 193: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

189: END IF;
190:
191: EXCEPTION
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,

Line 207: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

203: fnd_message.set_token('ENTITY1', l_item.item_name);
204: fnd_msg_pub.add;
205:
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,

Line 295: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

291: IF(c_revisionComp%ISOPEN) THEN
292: CLOSE c_revisionComp;
293: END IF;
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,

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

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

Line 328: * Otherwise return fnd_api.g_ret_sts_unexp_error.

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

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

349: END IF;
350:
351: SAVEPOINT wipbflpb40;
352:
353: IF(fnd_api.to_boolean(p_initMsgList)) THEN
354: fnd_msg_pub.initialize;
355: END IF;
356:
357: x_compLots.reset;

Line 359: x_returnStatus := fnd_api.g_ret_sts_success;

355: END IF;
356:
357: x_compLots.reset;
358: --assume we will be able to derive everything
359: x_returnStatus := fnd_api.g_ret_sts_success;
360:
361: LOOP
362: IF(x_compLots.getCurrentItem(l_curItem)) THEN
363: l_txnTypeId := getTxnType(p_txnActionID => l_curItem.transaction_action_id);

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

383: p_item => l_curItem,
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 := 'setItemRevision failed';
389: raise fnd_api.g_exc_unexpected_error;
390: END IF;
391: END IF;

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 := 'setItemRevision failed';
389: raise fnd_api.g_exc_unexpected_error;
390: END IF;
391: END IF;
392:
393: deriveSingleItem(p_parentObjID => p_objectID,

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

394: p_orgID => p_orgID,
395: x_compLots => x_compLots,
396: x_returnStatus => l_returnStatus);
397:
398: IF(l_returnStatus = fnd_api.g_ret_sts_unexp_error) THEN
399: l_errMsg := 'deriveSingleItem failed';
400: raise fnd_api.g_exc_unexpected_error;
401: END IF;
402:

Line 400: raise fnd_api.g_exc_unexpected_error;

396: x_returnStatus => l_returnStatus);
397:
398: IF(l_returnStatus = fnd_api.g_ret_sts_unexp_error) THEN
399: l_errMsg := 'deriveSingleItem failed';
400: raise fnd_api.g_exc_unexpected_error;
401: END IF;
402:
403: END IF; -- x_compLots.getCurrentItem(l_curItem)
404: <>

Line 418: WHEN fnd_api.g_exc_unexpected_error THEN

414: x_returnStatus => l_returnStatus);
415: END IF;
416:
417: EXCEPTION
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',

Line 419: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

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

Line 430: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

426: END IF;
427: ROLLBACK TO wipbflpb40;
428:
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,