237: x_returnStatus => l_returnStatus);
238: end if;
239: WHEN others THEN
240: status := -1;
241: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
242: fnd_message.set_token ('FUNCTION', 'wma_move.process');
243: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
244: errMessage := fnd_message.get;
245: if (l_logLevel <= wip_constants.trace_logging) then
238: end if;
239: WHEN others THEN
240: status := -1;
241: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
242: fnd_message.set_token ('FUNCTION', 'wma_move.process');
243: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
244: errMessage := fnd_message.get;
245: if (l_logLevel <= wip_constants.trace_logging) then
246: wip_logger.exitPoint(p_procName => 'wma_move.process',
239: WHEN others THEN
240: status := -1;
241: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
242: fnd_message.set_token ('FUNCTION', 'wma_move.process');
243: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
244: errMessage := fnd_message.get;
245: if (l_logLevel <= wip_constants.trace_logging) then
246: wip_logger.exitPoint(p_procName => 'wma_move.process',
247: p_procReturnStatus => status,
240: status := -1;
241: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
242: fnd_message.set_token ('FUNCTION', 'wma_move.process');
243: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
244: errMessage := fnd_message.get;
245: if (l_logLevel <= wip_constants.trace_logging) then
246: wip_logger.exitPoint(p_procName => 'wma_move.process',
247: p_procReturnStatus => status,
248: p_msg => errMessage,
386: x_returnStatus => x_returnStatus,
387: x_errMessage => x_errMessage);
388:
389: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
390: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
391: fnd_message.set_token('MESSAGE', x_errMessage);
392: fnd_msg_pub.add;
393: raise fnd_api.g_exc_unexpected_error;
394: END IF;
387: x_errMessage => x_errMessage);
388:
389: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
390: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
391: fnd_message.set_token('MESSAGE', x_errMessage);
392: fnd_msg_pub.add;
393: raise fnd_api.g_exc_unexpected_error;
394: END IF;
395:
445: x_returnStatus => x_returnStatus,
446: x_errMessage => x_errMessage);
447:
448: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
449: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
450: fnd_message.set_token('MESSAGE', x_errMessage);
451: fnd_msg_pub.add;
452: raise fnd_api.g_exc_unexpected_error;
453: END IF;
446: x_errMessage => x_errMessage);
447:
448: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
449: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
450: fnd_message.set_token('MESSAGE', x_errMessage);
451: fnd_msg_pub.add;
452: raise fnd_api.g_exc_unexpected_error;
453: END IF;
454:
509: x_returnStatus => x_returnStatus,
510: x_errMessage => x_errMessage);
511:
512: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
513: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
514: fnd_message.set_token('MESSAGE', x_errMessage);
515: fnd_msg_pub.add;
516: raise fnd_api.g_exc_unexpected_error;
517: END IF;
510: x_errMessage => x_errMessage);
511:
512: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
513: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
514: fnd_message.set_token('MESSAGE', x_errMessage);
515: fnd_msg_pub.add;
516: raise fnd_api.g_exc_unexpected_error;
517: END IF;
518:
568: x_returnStatus => x_returnStatus,
569: x_errMessage => x_errMessage);
570:
571: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
572: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
573: fnd_message.set_token('MESSAGE', x_errMessage);
574: fnd_msg_pub.add;
575: raise fnd_api.g_exc_unexpected_error;
576: END IF;
569: x_errMessage => x_errMessage);
570:
571: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
572: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
573: fnd_message.set_token('MESSAGE', x_errMessage);
574: fnd_msg_pub.add;
575: raise fnd_api.g_exc_unexpected_error;
576: END IF;
577:
731: -- derive info about the job
732: job := wma_derive.getJob(parameters.wipEntityID);
733:
734: if (job.wipEntityID is null) then
735: fnd_message.set_name ('WIP', 'WIP_JOB_DOES_NOT_EXIST');
736: fnd_message.set_token('INTERFACE', 'wma_move.derive', TRUE);
737: errMessage := fnd_message.get;
738: return false;
739: end if;
732: job := wma_derive.getJob(parameters.wipEntityID);
733:
734: if (job.wipEntityID is null) then
735: fnd_message.set_name ('WIP', 'WIP_JOB_DOES_NOT_EXIST');
736: fnd_message.set_token('INTERFACE', 'wma_move.derive', TRUE);
737: errMessage := fnd_message.get;
738: return false;
739: end if;
740:
733:
734: if (job.wipEntityID is null) then
735: fnd_message.set_name ('WIP', 'WIP_JOB_DOES_NOT_EXIST');
736: fnd_message.set_token('INTERFACE', 'wma_move.derive', TRUE);
737: errMessage := fnd_message.get;
738: return false;
739: end if;
740:
741: if(parameters.txnMode = WIP_CONSTANTS.BACKGROUND AND
749: item := wma_derive.getItem(parameters.itemID,
750: parameters.environment.orgID,
751: parameters.locatorID);
752: if (item.invItemID is null) then
753: fnd_message.set_name ('WIP', 'WIP_ITEM_DOES_NOT_EXIST');
754: errMessage := fnd_message.get;
755: return false;
756: end if;
757:
750: parameters.environment.orgID,
751: parameters.locatorID);
752: if (item.invItemID is null) then
753: fnd_message.set_name ('WIP', 'WIP_ITEM_DOES_NOT_EXIST');
754: errMessage := fnd_message.get;
755: return false;
756: end if;
757:
758: -- get the item revision
761: wipEntityID => parameters.wipEntityID,
762: orgID => parameters.environment.orgID,
763: itemID => parameters.itemID,
764: revision => l_revision)) then
765: errMessage := substr(fnd_message.get,1,241);
766: return false;
767: end if; -- getRevision
768: end if; -- revQtyControlCode = WIP_CONSTANTS.REVISION_CONTROLLED
769: end if; -- Background transaction
775: period_id => periodID,
776: open_past_period => openPastPeriod);
777:
778: if (periodID = -1 or periodID = 0) then
779: fnd_message.set_name(
780: application => 'INV',
781: name => 'INV_NO_OPEN_PERIOD');
782: errMessage := fnd_message.get;
783: return false;
778: if (periodID = -1 or periodID = 0) then
779: fnd_message.set_name(
780: application => 'INV',
781: name => 'INV_NO_OPEN_PERIOD');
782: errMessage := fnd_message.get;
783: return false;
784: end if;
785:
786: -- derive the operation related information based on sequence number (From)
880: return true;
881:
882: EXCEPTION
883: when others then
884: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
885: fnd_message.set_token ('FUNCTION', 'wma_move.derive');
886: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
887: errMessage := fnd_message.get;
888: return false;
881:
882: EXCEPTION
883: when others then
884: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
885: fnd_message.set_token ('FUNCTION', 'wma_move.derive');
886: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
887: errMessage := fnd_message.get;
888: return false;
889: END derive;
882: EXCEPTION
883: when others then
884: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
885: fnd_message.set_token ('FUNCTION', 'wma_move.derive');
886: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
887: errMessage := fnd_message.get;
888: return false;
889: END derive;
890:
883: when others then
884: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
885: fnd_message.set_token ('FUNCTION', 'wma_move.derive');
886: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
887: errMessage := fnd_message.get;
888: return false;
889: END derive;
890:
891: /**
1297: p_result => result);
1298:
1299: IF (result = WIP_CONSTANTS.NO) THEN
1300: -- exceed tolerance, set error message
1301: fnd_message.set_name ('WIP', 'WIP_OC_TOLERANCE_FAIL');
1302: x_errMessage := fnd_message.get;
1303: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1304: if (l_logLevel <= wip_constants.trace_logging) then
1305: wip_logger.exitPoint(p_procName => 'wma_move.validate',
1298:
1299: IF (result = WIP_CONSTANTS.NO) THEN
1300: -- exceed tolerance, set error message
1301: fnd_message.set_name ('WIP', 'WIP_OC_TOLERANCE_FAIL');
1302: x_errMessage := fnd_message.get;
1303: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1304: if (l_logLevel <= wip_constants.trace_logging) then
1305: wip_logger.exitPoint(p_procName => 'wma_move.validate',
1306: p_procReturnStatus => x_returnStatus,
1326: AND NVL(wsc.disable_date, SYSDATE + 1) > SYSDATE;
1327:
1328: IF(l_noMoveCount <> 0)THEN
1329: -- From step has no move shopfloor status
1330: fnd_message.set_name ('WIP', 'WIP_STATUS_NO_TXN1');
1331: x_errMessage := fnd_message.get;
1332: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1333: if (l_logLevel <= wip_constants.trace_logging) then
1334: wip_logger.exitPoint(p_procName => 'wma_move.validate',
1327:
1328: IF(l_noMoveCount <> 0)THEN
1329: -- From step has no move shopfloor status
1330: fnd_message.set_name ('WIP', 'WIP_STATUS_NO_TXN1');
1331: x_errMessage := fnd_message.get;
1332: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1333: if (l_logLevel <= wip_constants.trace_logging) then
1334: wip_logger.exitPoint(p_procName => 'wma_move.validate',
1335: p_procReturnStatus => x_returnStatus,
1350: p_fm_step => p_fmStep,
1351: p_to_op => p_toOp,
1352: p_to_step => p_toStep) > 0) THEN
1353: -- There is no-move shop floor status in between
1354: fnd_message.set_name ('WIP', 'WIP_NO_MOVE_SF_STATUS_BETWEEN');
1355: x_errMessage := fnd_message.get;
1356: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1357: if (l_logLevel <= wip_constants.trace_logging) then
1358: wip_logger.exitPoint(p_procName => 'wma_move.validate',
1351: p_to_op => p_toOp,
1352: p_to_step => p_toStep) > 0) THEN
1353: -- There is no-move shop floor status in between
1354: fnd_message.set_name ('WIP', 'WIP_NO_MOVE_SF_STATUS_BETWEEN');
1355: x_errMessage := fnd_message.get;
1356: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1357: if (l_logLevel <= wip_constants.trace_logging) then
1358: wip_logger.exitPoint(p_procName => 'wma_move.validate',
1359: p_procReturnStatus => x_returnStatus,
1505: return true;
1506:
1507: EXCEPTION
1508: when others then
1509: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
1510: fnd_message.set_token ('FUNCTION', 'wma_move.put');
1511: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
1512: errMessage := fnd_message.get;
1513: return false;
1506:
1507: EXCEPTION
1508: when others then
1509: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
1510: fnd_message.set_token ('FUNCTION', 'wma_move.put');
1511: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
1512: errMessage := fnd_message.get;
1513: return false;
1514: END put;
1507: EXCEPTION
1508: when others then
1509: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
1510: fnd_message.set_token ('FUNCTION', 'wma_move.put');
1511: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
1512: errMessage := fnd_message.get;
1513: return false;
1514: END put;
1515:
1508: when others then
1509: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
1510: fnd_message.set_token ('FUNCTION', 'wma_move.put');
1511: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
1512: errMessage := fnd_message.get;
1513: return false;
1514: END put;
1515:
1516: /**
1563: return true;
1564:
1565: EXCEPTION
1566: when others then
1567: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
1568: fnd_message.set_token ('FUNCTION', 'wma_move.insertSerial');
1569: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
1570: errMessage := fnd_message.get;
1571: return false;
1564:
1565: EXCEPTION
1566: when others then
1567: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
1568: fnd_message.set_token ('FUNCTION', 'wma_move.insertSerial');
1569: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
1570: errMessage := fnd_message.get;
1571: return false;
1572: END insertSerial;
1565: EXCEPTION
1566: when others then
1567: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
1568: fnd_message.set_token ('FUNCTION', 'wma_move.insertSerial');
1569: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
1570: errMessage := fnd_message.get;
1571: return false;
1572: END insertSerial;
1573: END wma_move;
1566: when others then
1567: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
1568: fnd_message.set_token ('FUNCTION', 'wma_move.insertSerial');
1569: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
1570: errMessage := fnd_message.get;
1571: return false;
1572: END insertSerial;
1573: END wma_move;