DBA Data[Home] [Help]

APPS.WMA_MOVE dependencies on FND_MESSAGE

Line 241: fnd_message.set_name ('WIP', 'GENERIC_ERROR');

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

Line 242: fnd_message.set_token ('FUNCTION', 'wma_move.process');

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',

Line 243: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);

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,

Line 244: errMessage := fnd_message.get;

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,

Line 390: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

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;

Line 391: fnd_message.set_token('MESSAGE', x_errMessage);

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:

Line 449: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

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;

Line 450: fnd_message.set_token('MESSAGE', x_errMessage);

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:

Line 513: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

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;

Line 514: fnd_message.set_token('MESSAGE', x_errMessage);

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:

Line 572: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

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;

Line 573: fnd_message.set_token('MESSAGE', x_errMessage);

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:

Line 735: fnd_message.set_name ('WIP', 'WIP_JOB_DOES_NOT_EXIST');

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;

Line 736: fnd_message.set_token('INTERFACE', 'wma_move.derive', TRUE);

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:

Line 737: errMessage := fnd_message.get;

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

Line 753: fnd_message.set_name ('WIP', 'WIP_ITEM_DOES_NOT_EXIST');

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:

Line 754: errMessage := fnd_message.get;

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

Line 765: errMessage := substr(fnd_message.get,1,241);

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

Line 779: fnd_message.set_name(

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;

Line 782: errMessage := fnd_message.get;

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)

Line 884: fnd_message.set_name ('WIP', 'GENERIC_ERROR');

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;

Line 885: fnd_message.set_token ('FUNCTION', 'wma_move.derive');

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;

Line 886: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);

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:

Line 887: errMessage := fnd_message.get;

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: /**

Line 1301: fnd_message.set_name ('WIP', 'WIP_OC_TOLERANCE_FAIL');

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',

Line 1302: x_errMessage := fnd_message.get;

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,

Line 1330: fnd_message.set_name ('WIP', 'WIP_STATUS_NO_TXN1');

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',

Line 1331: x_errMessage := fnd_message.get;

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,

Line 1354: fnd_message.set_name ('WIP', 'WIP_NO_MOVE_SF_STATUS_BETWEEN');

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',

Line 1355: x_errMessage := fnd_message.get;

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,

Line 1509: fnd_message.set_name ('WIP', 'GENERIC_ERROR');

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;

Line 1510: fnd_message.set_token ('FUNCTION', 'wma_move.put');

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;

Line 1511: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);

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:

Line 1512: errMessage := fnd_message.get;

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: /**

Line 1567: fnd_message.set_name ('WIP', 'GENERIC_ERROR');

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;

Line 1568: fnd_message.set_token ('FUNCTION', 'wma_move.insertSerial');

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;

Line 1569: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);

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;

Line 1570: errMessage := fnd_message.get;

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;