DBA Data[Home] [Help]

APPS.WMA_COMPLETION dependencies on FND_MESSAGE

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

55:
56: -- derive and validate all necessary fields for insertion
57: if (derive(cmpRecord, l_overCplRec, parameters, l_txnMode, error) = FALSE) then
58: -- process error
59: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
60: fnd_message.set_token('MESSAGE', error);
61: fnd_msg_pub.add;
62: if (l_logLevel <= wip_constants.full_logging) then
63: wip_logger.log('error from derive', errCode);

Line 60: fnd_message.set_token('MESSAGE', error);

56: -- derive and validate all necessary fields for insertion
57: if (derive(cmpRecord, l_overCplRec, parameters, l_txnMode, error) = FALSE) then
58: -- process error
59: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
60: fnd_message.set_token('MESSAGE', error);
61: fnd_msg_pub.add;
62: if (l_logLevel <= wip_constants.full_logging) then
63: wip_logger.log('error from derive', errCode);
64: end if;

Line 96: fnd_message.set_name(application => 'CST',

92: err_num => errNum,
93: err_code => errMessage,
94: err_msg => errMessage);
95: if(retValue <> 1) then
96: fnd_message.set_name(application => 'CST',
97: name => 'CST_SNAPSHOT_FAILED');
98: fnd_msg_pub.add;
99: if (l_logLevel <= wip_constants.full_logging) then
100: wip_logger.log('error from cst', errMessage);

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

256: wip_logger.cleanUp(dummy);
257: end if;
258: rollback to wma_cmp_proc10;
259: returnStatus := fnd_api.g_ret_sts_unexp_error;
260: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
261: fnd_message.set_token ('FUNCTION', 'wma_completion.process');
262: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
263: errMessage := fnd_message.get;
264: END process;

Line 261: fnd_message.set_token ('FUNCTION', 'wma_completion.process');

257: end if;
258: rollback to wma_cmp_proc10;
259: returnStatus := fnd_api.g_ret_sts_unexp_error;
260: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
261: fnd_message.set_token ('FUNCTION', 'wma_completion.process');
262: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
263: errMessage := fnd_message.get;
264: END process;
265:

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

258: rollback to wma_cmp_proc10;
259: returnStatus := fnd_api.g_ret_sts_unexp_error;
260: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
261: fnd_message.set_token ('FUNCTION', 'wma_completion.process');
262: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
263: errMessage := fnd_message.get;
264: END process;
265:
266: FUNCTION putIntoMMTT(lpnCmpRecord IN LpnCmpTxnRec,

Line 263: errMessage := fnd_message.get;

259: returnStatus := fnd_api.g_ret_sts_unexp_error;
260: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
261: fnd_message.set_token ('FUNCTION', 'wma_completion.process');
262: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
263: errMessage := fnd_message.get;
264: END process;
265:
266: FUNCTION putIntoMMTT(lpnCmpRecord IN LpnCmpTxnRec,
267: txnTmpID OUT NOCOPY NUMBER,

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

437: EXCEPTION
438: when others then
439: rollback to wmapcmpb_proc1000;
440: status := -1;
441: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
442: fnd_message.set_token ('FUNCTION', 'wma_completion.process');
443: fnd_message.set_token ('ERROR', SQLERRM);
444: errMessage := fnd_message.get;
445:

Line 442: fnd_message.set_token ('FUNCTION', 'wma_completion.process');

438: when others then
439: rollback to wmapcmpb_proc1000;
440: status := -1;
441: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
442: fnd_message.set_token ('FUNCTION', 'wma_completion.process');
443: fnd_message.set_token ('ERROR', SQLERRM);
444: errMessage := fnd_message.get;
445:
446: END process;

Line 443: fnd_message.set_token ('ERROR', SQLERRM);

439: rollback to wmapcmpb_proc1000;
440: status := -1;
441: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
442: fnd_message.set_token ('FUNCTION', 'wma_completion.process');
443: fnd_message.set_token ('ERROR', SQLERRM);
444: errMessage := fnd_message.get;
445:
446: END process;
447:

Line 444: errMessage := fnd_message.get;

440: status := -1;
441: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
442: fnd_message.set_token ('FUNCTION', 'wma_completion.process');
443: fnd_message.set_token ('ERROR', SQLERRM);
444: errMessage := fnd_message.get;
445:
446: END process;
447:
448: /**

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

485:
486: -- get the job info
487: job := wma_derive.getJob(parameters.wipEntityID);
488: if (job.wipEntityID is null) then
489: fnd_message.set_name ('WIP', 'WIP_JOB_DOES_NOT_EXIST');
490: fnd_message.set_token('INTERFACE', 'wma_completion.derive', TRUE);
491: errMessage := fnd_message.get;
492: return false;
493: end if;

Line 490: fnd_message.set_token('INTERFACE', 'wma_completion.derive', TRUE);

486: -- get the job info
487: job := wma_derive.getJob(parameters.wipEntityID);
488: if (job.wipEntityID is null) then
489: fnd_message.set_name ('WIP', 'WIP_JOB_DOES_NOT_EXIST');
490: fnd_message.set_token('INTERFACE', 'wma_completion.derive', TRUE);
491: errMessage := fnd_message.get;
492: return false;
493: end if;
494:

Line 491: errMessage := fnd_message.get;

487: job := wma_derive.getJob(parameters.wipEntityID);
488: if (job.wipEntityID is null) then
489: fnd_message.set_name ('WIP', 'WIP_JOB_DOES_NOT_EXIST');
490: fnd_message.set_token('INTERFACE', 'wma_completion.derive', TRUE);
491: errMessage := fnd_message.get;
492: return false;
493: end if;
494:
495: select primary_cost_method

Line 545: errMessage := fnd_message.get;

541: 'SPECIFIC',
542: 'N',
543: job.projectID,
544: job.taskID) = false) then
545: errMessage := fnd_message.get;
546: if (l_logLevel <= wip_constants.full_logging) then
547: wip_logger.log('wmapcmpb.derive: pjm_project_locator returns false', l_dummy);
548: end if;
549: return false;

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

557: item := wma_derive.getItem(parameters.itemID,
558: parameters.environment.orgID,
559: parameters.locatorID);
560: if (item.invItemID is null) then
561: fnd_message.set_name ('WIP', 'WIP_ITEM_DOES_NOT_EXIST');
562: errMessage := fnd_message.get;
563: if (l_logLevel <= wip_constants.full_logging) then
564: wip_logger.log('wmapcmpb.derive: wma_derive.getItem returns false', l_dummy);
565: end if;

Line 562: errMessage := fnd_message.get;

558: parameters.environment.orgID,
559: parameters.locatorID);
560: if (item.invItemID is null) then
561: fnd_message.set_name ('WIP', 'WIP_ITEM_DOES_NOT_EXIST');
562: errMessage := fnd_message.get;
563: if (l_logLevel <= wip_constants.full_logging) then
564: wip_logger.log('wmapcmpb.derive: wma_derive.getItem returns false', l_dummy);
565: end if;
566: return false;

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

578: wipEntityID => parameters.wipEntityID,
579: orgID => parameters.environment.orgID,
580: itemID => parameters.itemID,
581: revision => cmpRecord.revision)) then
582: errMessage := substr(fnd_message.get,1,241);
583: if (l_logLevel <= wip_constants.full_logging) then
584: wip_logger.log('wmapcmpb.derive: wma_completion.getRevision returns false', l_dummy);
585: end if;
586: return false;

Line 602: fnd_message.set_name(

598: period_id => periodID,
599: open_past_period => openPastPeriod);
600:
601: if (periodID = -1 or periodID = 0) then
602: fnd_message.set_name(
603: application => 'INV',
604: name => 'INV_NO_OPEN_PERIOD');
605: errMessage := fnd_message.get;
606: if (l_logLevel <= wip_constants.full_logging) then

Line 605: errMessage := fnd_message.get;

601: if (periodID = -1 or periodID = 0) then
602: fnd_message.set_name(
603: application => 'INV',
604: name => 'INV_NO_OPEN_PERIOD');
605: errMessage := fnd_message.get;
606: if (l_logLevel <= wip_constants.full_logging) then
607: wip_logger.log('wmapcmpb.derive: tdatechk returns false', l_dummy);
608: end if;
609: return false;

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

755: return true;
756:
757: EXCEPTION
758: when others then
759: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
760: fnd_message.set_token ('FUNCTION', 'wma_completion.derive');
761: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
762: errMessage := fnd_message.get;
763: return false;

Line 760: fnd_message.set_token ('FUNCTION', 'wma_completion.derive');

756:
757: EXCEPTION
758: when others then
759: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
760: fnd_message.set_token ('FUNCTION', 'wma_completion.derive');
761: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
762: errMessage := fnd_message.get;
763: return false;
764: END derive;

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

757: EXCEPTION
758: when others then
759: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
760: fnd_message.set_token ('FUNCTION', 'wma_completion.derive');
761: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
762: errMessage := fnd_message.get;
763: return false;
764: END derive;
765:

Line 762: errMessage := fnd_message.get;

758: when others then
759: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
760: fnd_message.set_token ('FUNCTION', 'wma_completion.derive');
761: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
762: errMessage := fnd_message.get;
763: return false;
764: END derive;
765:
766:

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

778:
779: -- get the job info
780: job := wma_derive.getJob(parameters.wipEntityID);
781: if (job.wipEntityID is null) then
782: fnd_message.set_name ('WIP', 'WIP_JOB_DOES_NOT_EXIST');
783: fnd_message.set_token('INTERFACE', 'wma_completion.derive', TRUE);
784: errMessage := fnd_message.get;
785: return false;
786: end if;

Line 783: fnd_message.set_token('INTERFACE', 'wma_completion.derive', TRUE);

779: -- get the job info
780: job := wma_derive.getJob(parameters.wipEntityID);
781: if (job.wipEntityID is null) then
782: fnd_message.set_name ('WIP', 'WIP_JOB_DOES_NOT_EXIST');
783: fnd_message.set_token('INTERFACE', 'wma_completion.derive', TRUE);
784: errMessage := fnd_message.get;
785: return false;
786: end if;
787:

Line 784: errMessage := fnd_message.get;

780: job := wma_derive.getJob(parameters.wipEntityID);
781: if (job.wipEntityID is null) then
782: fnd_message.set_name ('WIP', 'WIP_JOB_DOES_NOT_EXIST');
783: fnd_message.set_token('INTERFACE', 'wma_completion.derive', TRUE);
784: errMessage := fnd_message.get;
785: return false;
786: end if;
787:
788: -- take the quantity check off. The quantity has been checked before calling

Line 811: errMessage := fnd_message.get;

807: 'SPECIFIC',
808: 'N',
809: job.projectID,
810: job.taskID) = false) then
811: errMessage := fnd_message.get;
812: return false;
813: end if;
814:
815: -- get the item info

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

816: item := wma_derive.getItem(parameters.itemID,
817: parameters.environment.orgID,
818: parameters.locatorID);
819: if (item.invItemID is null) then
820: fnd_message.set_name ('WIP', 'WIP_ITEM_DOES_NOT_EXIST');
821: errMessage := fnd_message.get;
822: return false;
823: end if;
824: -- get the item revision

Line 821: errMessage := fnd_message.get;

817: parameters.environment.orgID,
818: parameters.locatorID);
819: if (item.invItemID is null) then
820: fnd_message.set_name ('WIP', 'WIP_ITEM_DOES_NOT_EXIST');
821: errMessage := fnd_message.get;
822: return false;
823: end if;
824: -- get the item revision
825: LpnCmpRecord.row.bom_revision := null;

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

828: wipEntityID => parameters.wipEntityID,
829: orgID => parameters.environment.orgID,
830: itemID => parameters.itemID,
831: revision => lpnCmpRecord.row.bom_revision)) then
832: errMessage := substr(fnd_message.get, 1, 241);
833: return false;
834: end if; -- getRevision
835: end if; -- revQtyControlCode = WIP_CONSTANTS.REVISION_CONTROLLED
836:

Line 845: fnd_message.set_name(

841: period_id => periodID,
842: open_past_period => openPastPeriod);
843:
844: if (periodID = -1 or periodID = 0) then
845: fnd_message.set_name(
846: application => 'INV',
847: name => 'INV_NO_OPEN_PERIOD');
848: errMessage := fnd_message.get;
849: return false;

Line 848: errMessage := fnd_message.get;

844: if (periodID = -1 or periodID = 0) then
845: fnd_message.set_name(
846: application => 'INV',
847: name => 'INV_NO_OPEN_PERIOD');
848: errMessage := fnd_message.get;
849: return false;
850: end if;
851:
852: -- get the last operation sequence

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

917: return true;
918:
919: EXCEPTION
920: when others then
921: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
922: fnd_message.set_token ('FUNCTION', 'wma_completion.derive');
923: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
924: errMessage := fnd_message.get;
925: return false;

Line 922: fnd_message.set_token ('FUNCTION', 'wma_completion.derive');

918:
919: EXCEPTION
920: when others then
921: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
922: fnd_message.set_token ('FUNCTION', 'wma_completion.derive');
923: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
924: errMessage := fnd_message.get;
925: return false;
926: END derive;

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

919: EXCEPTION
920: when others then
921: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
922: fnd_message.set_token ('FUNCTION', 'wma_completion.derive');
923: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
924: errMessage := fnd_message.get;
925: return false;
926: END derive;
927:

Line 924: errMessage := fnd_message.get;

920: when others then
921: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
922: fnd_message.set_token ('FUNCTION', 'wma_completion.derive');
923: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
924: errMessage := fnd_message.get;
925: return false;
926: END derive;
927:
928: /**

Line 1018: fnd_message.set_name ('INV', 'INV_GREATER_THAN_ZERO');

1014: x_returnStatus => l_returnStatus);
1015: end if;
1016:
1017: if (transactionQty <= 0) then
1018: fnd_message.set_name ('INV', 'INV_GREATER_THAN_ZERO');
1019: errMessage := fnd_message.get;
1020: if (l_logLevel <= wip_constants.trace_logging) then
1021: wip_logger.exitPoint(p_procName => 'wma_completion.checkQuantity',
1022: p_procReturnStatus => -1,

Line 1019: errMessage := fnd_message.get;

1015: end if;
1016:
1017: if (transactionQty <= 0) then
1018: fnd_message.set_name ('INV', 'INV_GREATER_THAN_ZERO');
1019: errMessage := fnd_message.get;
1020: if (l_logLevel <= wip_constants.trace_logging) then
1021: wip_logger.exitPoint(p_procName => 'wma_completion.checkQuantity',
1022: p_procReturnStatus => -1,
1023: p_msg => errMessage,

Line 1031: fnd_message.set_name ('WIP', 'WIP_GREATER_THAN');

1027: end if;
1028: if (overcomplete = true) then
1029: -- validate overcompletion quantity
1030: if (transactionQty <= availableQty) then
1031: fnd_message.set_name ('WIP', 'WIP_GREATER_THAN');
1032: fnd_message.set_token('ENTITY1', 'TRANSACTION QUANTITY-CAP', TRUE);
1033: fnd_message.set_token('ENTITY2', 'QTY AVAIL TO COMPLETE', TRUE);
1034: errMessage := fnd_message.get;
1035: if (l_logLevel <= wip_constants.trace_logging) then

Line 1032: fnd_message.set_token('ENTITY1', 'TRANSACTION QUANTITY-CAP', TRUE);

1028: if (overcomplete = true) then
1029: -- validate overcompletion quantity
1030: if (transactionQty <= availableQty) then
1031: fnd_message.set_name ('WIP', 'WIP_GREATER_THAN');
1032: fnd_message.set_token('ENTITY1', 'TRANSACTION QUANTITY-CAP', TRUE);
1033: fnd_message.set_token('ENTITY2', 'QTY AVAIL TO COMPLETE', TRUE);
1034: errMessage := fnd_message.get;
1035: if (l_logLevel <= wip_constants.trace_logging) then
1036: wip_logger.exitPoint(p_procName => 'wma_completion.checkQuantity',

Line 1033: fnd_message.set_token('ENTITY2', 'QTY AVAIL TO COMPLETE', TRUE);

1029: -- validate overcompletion quantity
1030: if (transactionQty <= availableQty) then
1031: fnd_message.set_name ('WIP', 'WIP_GREATER_THAN');
1032: fnd_message.set_token('ENTITY1', 'TRANSACTION QUANTITY-CAP', TRUE);
1033: fnd_message.set_token('ENTITY2', 'QTY AVAIL TO COMPLETE', TRUE);
1034: errMessage := fnd_message.get;
1035: if (l_logLevel <= wip_constants.trace_logging) then
1036: wip_logger.exitPoint(p_procName => 'wma_completion.checkQuantity',
1037: p_procReturnStatus => -1,

Line 1034: errMessage := fnd_message.get;

1030: if (transactionQty <= availableQty) then
1031: fnd_message.set_name ('WIP', 'WIP_GREATER_THAN');
1032: fnd_message.set_token('ENTITY1', 'TRANSACTION QUANTITY-CAP', TRUE);
1033: fnd_message.set_token('ENTITY2', 'QTY AVAIL TO COMPLETE', TRUE);
1034: errMessage := fnd_message.get;
1035: if (l_logLevel <= wip_constants.trace_logging) then
1036: wip_logger.exitPoint(p_procName => 'wma_completion.checkQuantity',
1037: p_procReturnStatus => -1,
1038: p_msg => errMessage,

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

1051: p_wip_entity_id => wipEntityID,
1052: p_primary_quantity => ocQtyToCheck,
1053: p_result => result);
1054: if (result = wip_constants.no) then -- quantity exceeds tolerance
1055: fnd_message.set_name ('WIP', 'WIP_OC_TOLERANCE_FAIL');
1056: errMessage := fnd_message.get;
1057: if (l_logLevel <= wip_constants.trace_logging) then
1058: wip_logger.exitPoint(p_procName => 'wma_completion.checkQuantity',
1059: p_procReturnStatus => -1,

Line 1056: errMessage := fnd_message.get;

1052: p_primary_quantity => ocQtyToCheck,
1053: p_result => result);
1054: if (result = wip_constants.no) then -- quantity exceeds tolerance
1055: fnd_message.set_name ('WIP', 'WIP_OC_TOLERANCE_FAIL');
1056: errMessage := fnd_message.get;
1057: if (l_logLevel <= wip_constants.trace_logging) then
1058: wip_logger.exitPoint(p_procName => 'wma_completion.checkQuantity',
1059: p_procReturnStatus => -1,
1060: p_msg => errMessage,

Line 1072: fnd_message.set_name ('INV', 'INV_QTY_LESS_OR_EQUAL');

1068: being made only for completion transaction. Removed the if-condition. Now,
1069: this will be checked for both completion and return. Changed message to be more
1070: suitable for both completion and return */
1071: if (transactionQty > availableQty) then
1072: fnd_message.set_name ('INV', 'INV_QTY_LESS_OR_EQUAL');
1073: errMessage := fnd_message.get;
1074: if (l_logLevel <= wip_constants.trace_logging) then
1075: wip_logger.exitPoint(p_procName => 'wma_completion.checkQuantity',
1076: p_procReturnStatus => -1,

Line 1073: errMessage := fnd_message.get;

1069: this will be checked for both completion and return. Changed message to be more
1070: suitable for both completion and return */
1071: if (transactionQty > availableQty) then
1072: fnd_message.set_name ('INV', 'INV_QTY_LESS_OR_EQUAL');
1073: errMessage := fnd_message.get;
1074: if (l_logLevel <= wip_constants.trace_logging) then
1075: wip_logger.exitPoint(p_procName => 'wma_completion.checkQuantity',
1076: p_procReturnStatus => -1,
1077: p_msg => errMessage,

Line 1096: fnd_message.set_name ('WIP', 'WIP_LESS_OR_EQUAL');

1092: -- validate return quantity
1093: /* Fixed bug 3693148. We should allow overreturn for non-standard job*/
1094: if (l_job_type = WIP_CONSTANTS.STANDARD AND
1095: transactionQty > completedQty) then
1096: fnd_message.set_name ('WIP', 'WIP_LESS_OR_EQUAL');
1097: fnd_message.set_token('ENTITY1', 'TOTAL TXN QTY-CAP', TRUE);
1098: fnd_message.set_token('ENTITY2', 'JOB COMPLETE QUANTITY', TRUE);
1099: errMessage := fnd_message.get;
1100: if (l_logLevel <= wip_constants.trace_logging) then

Line 1097: fnd_message.set_token('ENTITY1', 'TOTAL TXN QTY-CAP', TRUE);

1093: /* Fixed bug 3693148. We should allow overreturn for non-standard job*/
1094: if (l_job_type = WIP_CONSTANTS.STANDARD AND
1095: transactionQty > completedQty) then
1096: fnd_message.set_name ('WIP', 'WIP_LESS_OR_EQUAL');
1097: fnd_message.set_token('ENTITY1', 'TOTAL TXN QTY-CAP', TRUE);
1098: fnd_message.set_token('ENTITY2', 'JOB COMPLETE QUANTITY', TRUE);
1099: errMessage := fnd_message.get;
1100: if (l_logLevel <= wip_constants.trace_logging) then
1101: wip_logger.exitPoint(p_procName => 'wma_completion.checkQuantity',

Line 1098: fnd_message.set_token('ENTITY2', 'JOB COMPLETE QUANTITY', TRUE);

1094: if (l_job_type = WIP_CONSTANTS.STANDARD AND
1095: transactionQty > completedQty) then
1096: fnd_message.set_name ('WIP', 'WIP_LESS_OR_EQUAL');
1097: fnd_message.set_token('ENTITY1', 'TOTAL TXN QTY-CAP', TRUE);
1098: fnd_message.set_token('ENTITY2', 'JOB COMPLETE QUANTITY', TRUE);
1099: errMessage := fnd_message.get;
1100: if (l_logLevel <= wip_constants.trace_logging) then
1101: wip_logger.exitPoint(p_procName => 'wma_completion.checkQuantity',
1102: p_procReturnStatus => -1,

Line 1099: errMessage := fnd_message.get;

1095: transactionQty > completedQty) then
1096: fnd_message.set_name ('WIP', 'WIP_LESS_OR_EQUAL');
1097: fnd_message.set_token('ENTITY1', 'TOTAL TXN QTY-CAP', TRUE);
1098: fnd_message.set_token('ENTITY2', 'JOB COMPLETE QUANTITY', TRUE);
1099: errMessage := fnd_message.get;
1100: if (l_logLevel <= wip_constants.trace_logging) then
1101: wip_logger.exitPoint(p_procName => 'wma_completion.checkQuantity',
1102: p_procReturnStatus => -1,
1103: p_msg => errMessage,

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

1150: p_result => result);
1151:
1152: if (result = WIP_CONSTANTS.NO) then
1153: -- exceed tolerance, set error message
1154: fnd_message.set_name ('WIP', 'WIP_OC_TOLERANCE_FAIL');
1155: x_errMessage := fnd_message.get;
1156: x_returnStatus := fnd_api.g_ret_sts_error;
1157: end if;
1158: end if;

Line 1155: x_errMessage := fnd_message.get;

1151:
1152: if (result = WIP_CONSTANTS.NO) then
1153: -- exceed tolerance, set error message
1154: fnd_message.set_name ('WIP', 'WIP_OC_TOLERANCE_FAIL');
1155: x_errMessage := fnd_message.get;
1156: x_returnStatus := fnd_api.g_ret_sts_error;
1157: end if;
1158: end if;
1159:

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

1414: when others then
1415: if (l_logLevel <= wip_constants.full_logging) then
1416: wip_logger.log('put failed: ' || SQLERRM, l_dummy);
1417: end if;
1418: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
1419: fnd_message.set_token ('FUNCTION', 'wma_completion.put');
1420: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
1421: errMessage := fnd_message.get;
1422: return false;

Line 1419: fnd_message.set_token ('FUNCTION', 'wma_completion.put');

1415: if (l_logLevel <= wip_constants.full_logging) then
1416: wip_logger.log('put failed: ' || SQLERRM, l_dummy);
1417: end if;
1418: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
1419: fnd_message.set_token ('FUNCTION', 'wma_completion.put');
1420: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
1421: errMessage := fnd_message.get;
1422: return false;
1423: END put;

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

1416: wip_logger.log('put failed: ' || SQLERRM, l_dummy);
1417: end if;
1418: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
1419: fnd_message.set_token ('FUNCTION', 'wma_completion.put');
1420: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
1421: errMessage := fnd_message.get;
1422: return false;
1423: END put;
1424:

Line 1421: errMessage := fnd_message.get;

1417: end if;
1418: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
1419: fnd_message.set_token ('FUNCTION', 'wma_completion.put');
1420: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
1421: errMessage := fnd_message.get;
1422: return false;
1423: END put;
1424:
1425:

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

1489: return true;
1490:
1491: EXCEPTION
1492: when others then
1493: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
1494: fnd_message.set_token ('FUNCTION', 'wma_completion.put');
1495: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
1496: errMessage := fnd_message.get;
1497: return false;

Line 1494: fnd_message.set_token ('FUNCTION', 'wma_completion.put');

1490:
1491: EXCEPTION
1492: when others then
1493: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
1494: fnd_message.set_token ('FUNCTION', 'wma_completion.put');
1495: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
1496: errMessage := fnd_message.get;
1497: return false;
1498: END put;

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

1491: EXCEPTION
1492: when others then
1493: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
1494: fnd_message.set_token ('FUNCTION', 'wma_completion.put');
1495: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
1496: errMessage := fnd_message.get;
1497: return false;
1498: END put;
1499:

Line 1496: errMessage := fnd_message.get;

1492: when others then
1493: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
1494: fnd_message.set_token ('FUNCTION', 'wma_completion.put');
1495: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
1496: errMessage := fnd_message.get;
1497: return false;
1498: END put;
1499:
1500: procedure backflush(p_jobID IN NUMBER,

Line 1621: fnd_message.set_name('WIP', 'WIP_NO_LS_COMP_IN_BKGND');

1617: --note that we are ignoring the serialization derivation below b/c
1618: --serialized pages are only online...
1619: if(x_returnStatus = fnd_api.g_ret_sts_error and
1620: l_txnMode = wip_constants.background) then
1621: fnd_message.set_name('WIP', 'WIP_NO_LS_COMP_IN_BKGND');
1622: fnd_msg_pub.add;
1623: raise fnd_api.g_exc_unexpected_error;
1624: end if;
1625:

Line 1729: fnd_message.set_name('WIP', 'WIP_BOM_ITEM_REVISION');

1725: )));
1726: return true;
1727: EXCEPTION
1728: WHEN others THEN
1729: fnd_message.set_name('WIP', 'WIP_BOM_ITEM_REVISION');
1730: return false;
1731: END getRevision;
1732: end wma_completion;