DBA Data[Home] [Help]

APPS.WIP_CPLPROC_PRIV dependencies on FND_MESSAGE

Line 224: fnd_message.set_name('WIP', 'INVALID_MMTT_TEMP_ID');

220: end if;
221: if(fnd_api.to_boolean(p_endDebug)) then
222: wip_logger.cleanUp(x_returnStatus => l_returnStatus); --discard logging return status
223: end if;
224: fnd_message.set_name('WIP', 'INVALID_MMTT_TEMP_ID');
225: fnd_msg_pub.add;
226: if (l_logLevel <= wip_constants.full_logging) then
227: wip_logger.log(SQLERRM, l_returnStatus);
228: end if;

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

392: -- Fixed bug 3678776. We should allow user to overreturn assembly back
393: -- to non-standard job.
394: if(abs(p_cplRec.priQty) > l_qtyCompleted AND
395: l_jobType = WIP_CONSTANTS.STANDARD) then
396: fnd_message.set_name('WIP', 'WIP_LESS_OR_EQUAL');
397: fnd_message.set_token('ENTITY1', 'total txn qty-cap', true);
398: fnd_message.set_token('ENTITY2', 'job complete quantity', true);
399: fnd_msg_pub.add;
400: l_errMsg := 'not enough quantity to return';

Line 397: fnd_message.set_token('ENTITY1', 'total txn qty-cap', true);

393: -- to non-standard job.
394: if(abs(p_cplRec.priQty) > l_qtyCompleted AND
395: l_jobType = WIP_CONSTANTS.STANDARD) then
396: fnd_message.set_name('WIP', 'WIP_LESS_OR_EQUAL');
397: fnd_message.set_token('ENTITY1', 'total txn qty-cap', true);
398: fnd_message.set_token('ENTITY2', 'job complete quantity', true);
399: fnd_msg_pub.add;
400: l_errMsg := 'not enough quantity to return';
401: raise fnd_api.g_exc_unexpected_error;

Line 398: fnd_message.set_token('ENTITY2', 'job complete quantity', true);

394: if(abs(p_cplRec.priQty) > l_qtyCompleted AND
395: l_jobType = WIP_CONSTANTS.STANDARD) then
396: fnd_message.set_name('WIP', 'WIP_LESS_OR_EQUAL');
397: fnd_message.set_token('ENTITY1', 'total txn qty-cap', true);
398: fnd_message.set_token('ENTITY2', 'job complete quantity', true);
399: fnd_msg_pub.add;
400: l_errMsg := 'not enough quantity to return';
401: raise fnd_api.g_exc_unexpected_error;
402: end if;

Line 443: fnd_message.set_name('WIP', 'WIP_LESS_QTY');

439: and operation_seq_num = p_cplRec.lastOpSeq
440: for update of quantity_waiting_to_move nowait;
441:
442: if(l_toMoveQty - p_cplRec.priQty < 0) then
443: fnd_message.set_name('WIP', 'WIP_LESS_QTY');
444: fnd_msg_pub.add;
445: l_errMsg := 'not enough qty in to move of last op';
446: raise fnd_api.g_exc_unexpected_error;
447: end if;

Line 467: fnd_message.set_name('WIP', 'WIP_LESS_QTY');

463: else
464: oc_primary_qty := p_cplRec.overCplPriQty;
465: end if;
466: if p_cplRec.priQty - abs(l_qtyAvailToComplete) - oc_primary_qty > 0 then
467: fnd_message.set_name('WIP', 'WIP_LESS_QTY');
468: fnd_msg_pub.add;
469: l_errMsg := 'Quantity required to complete this transaction no longer available';
470: raise fnd_api.g_exc_unexpected_error;
471:

Line 501: fnd_message.set_name('WIP', 'WIP_WORK_ORDER_LOCKED');

497: p_msg => 'records were locked',
498: x_returnStatus => l_returnStatus); --discard logging return status
499: end if;
500: select WIP_ENTITY_NAME into l_job_name from wip_entities where WIP_ENTITY_ID = p_cplRec.wipEntityID;
501: fnd_message.set_name('WIP', 'WIP_WORK_ORDER_LOCKED');
502: fnd_message.set_token('JOBNAME', l_job_name);
503: fnd_msg_pub.add;
504: when others then
505: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

Line 502: fnd_message.set_token('JOBNAME', l_job_name);

498: x_returnStatus => l_returnStatus); --discard logging return status
499: end if;
500: select WIP_ENTITY_NAME into l_job_name from wip_entities where WIP_ENTITY_ID = p_cplRec.wipEntityID;
501: fnd_message.set_name('WIP', 'WIP_WORK_ORDER_LOCKED');
502: fnd_message.set_token('JOBNAME', l_job_name);
503: fnd_msg_pub.add;
504: when others then
505: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
506: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_cplProc_priv',

Line 651: fnd_message.set_name('WIP', 'WIP_LESS_QTY');

647: returning quantity_waiting_to_move into l_newSchedQty;
648:
649: if(l_newSchedQty < 0) then
650: --add check for pending txns here
651: fnd_message.set_name('WIP', 'WIP_LESS_QTY');
652: fnd_msg_pub.add;
653: l_errMsg := 'not enough qty in to move of last op';
654: raise fnd_api.g_exc_unexpected_error;
655: end if;

Line 822: fnd_msg_pub.add; --assume prev fn used the fnd_message pkg

818: x_first_sched_id => l_firstSchedID,
819: x_last_sched_id => l_lastSchedID,
820: x_error_mesg => l_errMsg);
821: if(l_errMsg <> null) then
822: fnd_msg_pub.add; --assume prev fn used the fnd_message pkg
823: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
824: l_errMsg := 'wip_repetitive_utilities.get_first_last_sched: ' || l_errMsg;
825: raise fnd_api.g_exc_unexpected_error;
826: end if;

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

834:
835:
836: if(x_returnStatus = wip_constants.no) then
837: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
838: fnd_message.set_name('WIP', 'WIP_OC_TOLERANCE_FAIL');
839: fnd_msg_pub.add;
840: l_errMsg := 'cpl exceeded tolerances';
841: raise fnd_api.g_exc_unexpected_error;
842: else

Line 1200: fnd_message.set_name('WIP', 'WIP_SCHED_MULTIPLE_BILL_REV');

1196:
1197: --if the revisions don't match...
1198: if(l_schedRecTbl.bomRev(j) <> l_txnRecTbl.revision(i) and
1199: (l_schedRecTbl.bomRev(j) is not null or l_txnRecTbl.revision(i) is not null)) then
1200: fnd_message.set_name('WIP', 'WIP_SCHED_MULTIPLE_BILL_REV');
1201: fnd_msg_pub.add;
1202: l_errMsg := 'Schedules have different bill revisions.'; --set message in case it fails
1203: raise fnd_api.g_exc_unexpected_error;
1204: end if;

Line 1256: fnd_message.set_name('WIP', 'WIP_INT_ERROR_NO_SCHED');

1252: end loop;
1253: if(l_remainingQty <> 0) then -- over-completion/return
1254: if(l_lastSchedID is null) then
1255: /* Fix for bug 5373061: Passed missing token */
1256: fnd_message.set_name('WIP', 'WIP_INT_ERROR_NO_SCHED');
1257: fnd_message.set_token('ROUTINE', 'wip_cplProc_priv.preAllocateSchedules');
1258: fnd_msg_pub.add;
1259: l_errMsg := 'did not find any schedules.';
1260: raise fnd_api.g_exc_unexpected_error; -- couldn't find any open schedules

Line 1257: fnd_message.set_token('ROUTINE', 'wip_cplProc_priv.preAllocateSchedules');

1253: if(l_remainingQty <> 0) then -- over-completion/return
1254: if(l_lastSchedID is null) then
1255: /* Fix for bug 5373061: Passed missing token */
1256: fnd_message.set_name('WIP', 'WIP_INT_ERROR_NO_SCHED');
1257: fnd_message.set_token('ROUTINE', 'wip_cplProc_priv.preAllocateSchedules');
1258: fnd_msg_pub.add;
1259: l_errMsg := 'did not find any schedules.';
1260: raise fnd_api.g_exc_unexpected_error; -- couldn't find any open schedules
1261: end if;

Line 1287: fnd_message.set_name('WIP', 'WIP_INT_ERROR_NO_SCHED');

1283:
1284: /* Fix for Bug#6018877 - FP of bug#6004763. Added the if condition check not to consider Return txn */
1285: if(p_txnActionID <> wip_constants.retassy_action) then
1286: if(l_txnRecTbl.overCplQty(i) IS NULL) then
1287: fnd_message.set_name('WIP', 'WIP_INT_ERROR_NO_SCHED');
1288: fnd_message.set_token('ROUTINE', 'wip_cplProc_priv.preAllocateSchedules');
1289: fnd_msg_pub.add;
1290: l_errMsg := 'did not find any schedules.';
1291: raise fnd_api.g_exc_unexpected_error; -- couldn't find any open schedules

Line 1288: fnd_message.set_token('ROUTINE', 'wip_cplProc_priv.preAllocateSchedules');

1284: /* Fix for Bug#6018877 - FP of bug#6004763. Added the if condition check not to consider Return txn */
1285: if(p_txnActionID <> wip_constants.retassy_action) then
1286: if(l_txnRecTbl.overCplQty(i) IS NULL) then
1287: fnd_message.set_name('WIP', 'WIP_INT_ERROR_NO_SCHED');
1288: fnd_message.set_token('ROUTINE', 'wip_cplProc_priv.preAllocateSchedules');
1289: fnd_msg_pub.add;
1290: l_errMsg := 'did not find any schedules.';
1291: raise fnd_api.g_exc_unexpected_error; -- couldn't find any open schedules
1292: end if;

Line 1797: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');

1793: AND mtli.lot_expiration_date is null;
1794:
1795: -- IF debug message level = 2, write statement below to log file
1796: IF (l_log_level <= wip_constants.full_logging) THEN
1797: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
1798: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
1799: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTION_LOTS_INTERFACE');
1800: l_msg := fnd_message.get;
1801: wip_logger.log(p_msg => l_msg,

Line 1798: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);

1794:
1795: -- IF debug message level = 2, write statement below to log file
1796: IF (l_log_level <= wip_constants.full_logging) THEN
1797: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
1798: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
1799: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTION_LOTS_INTERFACE');
1800: l_msg := fnd_message.get;
1801: wip_logger.log(p_msg => l_msg,
1802: x_returnStatus => l_return_status);

Line 1799: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTION_LOTS_INTERFACE');

1795: -- IF debug message level = 2, write statement below to log file
1796: IF (l_log_level <= wip_constants.full_logging) THEN
1797: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
1798: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
1799: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTION_LOTS_INTERFACE');
1800: l_msg := fnd_message.get;
1801: wip_logger.log(p_msg => l_msg,
1802: x_returnStatus => l_return_status);
1803: END IF;

Line 1800: l_msg := fnd_message.get;

1796: IF (l_log_level <= wip_constants.full_logging) THEN
1797: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
1798: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
1799: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTION_LOTS_INTERFACE');
1800: l_msg := fnd_message.get;
1801: wip_logger.log(p_msg => l_msg,
1802: x_returnStatus => l_return_status);
1803: END IF;
1804:

Line 1841: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');

1837: AND msi.lot_control_code = WIP_CONSTANTS.LOT);
1838:
1839: -- IF debug message level = 2, write statement below to log file
1840: IF (l_log_level <= wip_constants.full_logging) THEN
1841: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
1842: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
1843: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTION_LOTS_INTERFACE');
1844: l_msg := fnd_message.get;
1845: wip_logger.log(p_msg => l_msg,

Line 1842: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);

1838:
1839: -- IF debug message level = 2, write statement below to log file
1840: IF (l_log_level <= wip_constants.full_logging) THEN
1841: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
1842: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
1843: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTION_LOTS_INTERFACE');
1844: l_msg := fnd_message.get;
1845: wip_logger.log(p_msg => l_msg,
1846: x_returnStatus => l_return_status);

Line 1843: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTION_LOTS_INTERFACE');

1839: -- IF debug message level = 2, write statement below to log file
1840: IF (l_log_level <= wip_constants.full_logging) THEN
1841: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
1842: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
1843: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTION_LOTS_INTERFACE');
1844: l_msg := fnd_message.get;
1845: wip_logger.log(p_msg => l_msg,
1846: x_returnStatus => l_return_status);
1847: END IF;

Line 1844: l_msg := fnd_message.get;

1840: IF (l_log_level <= wip_constants.full_logging) THEN
1841: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
1842: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
1843: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTION_LOTS_INTERFACE');
1844: l_msg := fnd_message.get;
1845: wip_logger.log(p_msg => l_msg,
1846: x_returnStatus => l_return_status);
1847: END IF;
1848:

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

1873: err_num => l_err_num,
1874: err_code => l_error_msg,
1875: err_msg => l_error_msg);
1876: IF(l_ret_value <> 1) THEN
1877: fnd_message.set_name(application => 'CST',
1878: name => 'CST_SNAPSHOT_FAILED');
1879: fnd_msg_pub.add;
1880: raise fnd_api.g_exc_unexpected_error;
1881: END IF;

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

1953: x_returnStatus => x_returnStatus,
1954: x_errorMsg => l_error_msg);
1955:
1956: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
1957: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1958: fnd_message.set_token('MESSAGE', l_error_msg);
1959: fnd_msg_pub.add;
1960: raise fnd_api.g_exc_unexpected_error;
1961: END IF;

Line 1958: fnd_message.set_token('MESSAGE', l_error_msg);

1954: x_errorMsg => l_error_msg);
1955:
1956: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
1957: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1958: fnd_message.set_token('MESSAGE', l_error_msg);
1959: fnd_msg_pub.add;
1960: raise fnd_api.g_exc_unexpected_error;
1961: END IF;
1962:

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

2031: x_returnStatus := fnd_api.g_ret_sts_error;
2032: l_error_msg := ' unexpected error: ' || SQLERRM || 'SQLCODE = ' ||
2033: SQLCODE;
2034:
2035: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
2036: fnd_message.set_token('MESSAGE', l_error_msg);
2037: fnd_msg_pub.add;
2038:
2039: IF (l_log_level <= wip_constants.trace_logging) THEN

Line 2036: fnd_message.set_token('MESSAGE', l_error_msg);

2032: l_error_msg := ' unexpected error: ' || SQLERRM || 'SQLCODE = ' ||
2033: SQLCODE;
2034:
2035: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
2036: fnd_message.set_token('MESSAGE', l_error_msg);
2037: fnd_msg_pub.add;
2038:
2039: IF (l_log_level <= wip_constants.trace_logging) THEN
2040: wip_logger.exitPoint(p_procName => 'wip_cplProc_priv.processOATxn',