DBA Data[Home] [Help]

APPS.WIP_AUTOLOTPROC_PRIV dependencies on FND_MSG_PUB

Line 147: fnd_msg_pub.initialize;

143: x_returnStatus => x_returnStatus);
144: end if;
145:
146: if(fnd_api.to_boolean(p_initMsgList)) then
147: fnd_msg_pub.initialize;
148: end if;
149:
150: select backflush_lot_entry_type
151: into l_entryType

Line 242: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_autoLotProc_priv',

238: p_procReturnStatus => x_returnStatus,
239: p_msg => 'unexpected error:' || SQLERRM,
240: x_returnStatus => l_returnStatus); --discard logging return status
241: end if;
242: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_autoLotProc_priv',
243: p_procedure_name => 'deriveLots',
244: p_error_text => SQLERRM);
245: if(fnd_api.to_boolean(p_endDebug)) then
246: wip_logger.cleanup(x_returnStatus => l_returnStatus);

Line 374: fnd_msg_pub.initialize;

370: x_returnStatus => x_returnStatus);
371: end if;
372:
373: if(fnd_api.to_boolean(p_initMsgList)) then
374: fnd_msg_pub.initialize;
375: end if;
376:
377: if(p_cplTxnID is not null) then
378: open c_cplItems;

Line 599: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_autoLotProc_priv',

595: end if;
596: when others then
597: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
598: rollback to wiplotpb_10;
599: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_autoLotProc_priv',
600: p_procedure_name => 'deriveLotsFromMMTT',
601: p_error_text => SQLERRM);
602: if (l_logLevel <= wip_constants.trace_logging) then
603: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.deriveLotsFromMMTT',

Line 799: fnd_msg_pub.initialize;

795: x_returnStatus => x_returnStatus);
796: end if;
797:
798: if(fnd_api.to_boolean(p_initMsgList)) then
799: fnd_msg_pub.initialize;
800: end if;
801:
802: l_compObj := system.wip_lot_serial_obj_t(null,null,null,null,null,null);
803: l_compObj.initialize;

Line 1042: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_autoLotProc_priv',

1038: end if;
1039: when others then
1040: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1041: rollback to wiplotpb_10;
1042: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_autoLotProc_priv',
1043: p_procedure_name => 'deriveLotsFromMTI',
1044: p_error_text => SQLERRM);
1045: if (l_logLevel <= wip_constants.trace_logging) then
1046: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.deriveLotsFromMTI',

Line 1248: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_autoLotProc_priv',

1244: close c_retTxnBasedLots;
1245: elsif(c_retTxnBasedLots%ISOPEN) then
1246: close c_negRetTxnBasedLots;
1247: end if;
1248: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_autoLotProc_priv',
1249: p_procedure_name => 'deriveTxnLots',
1250: p_error_text => SQLERRM);
1251: if (l_logLevel <= wip_constants.trace_logging) then
1252: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.deriveTxnLots',

Line 1728: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_autoLotProc_priv',

1724: close c_receiptOrderedLots;
1725: elsif(c_expDateOrderedLots%ISOPEN) then
1726: close c_expDateOrderedLots;
1727: end if;
1728: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_autoLotProc_priv',
1729: p_procedure_name => 'deriveIssueLots',
1730: p_error_text => SQLERRM);
1731: if (l_logLevel <= wip_constants.trace_logging) then
1732: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.deriveIssueLots',

Line 1891: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_autoLotProc_priv',

1887: end if;
1888: rollback to wipbflpb40;
1889: when others then
1890: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1891: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_autoLotProc_priv',
1892: p_procedure_name => 'deriveSingleItem',
1893: p_error_text => SQLERRM);
1894: if (l_logLevel <= wip_constants.trace_logging) then
1895: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.deriveSingleItem',

Line 1960: fnd_msg_pub.add;

1956: if(p_qty <> round(p_qty)) then --serial requirements must be whole numbers
1957: l_errMsg := 'serial requirement not a whole #';
1958: fnd_message.set_name('WIP', 'COMP_INVALID_SER_QTY');
1959: fnd_message.set_token('ITEM', p_itemName);
1960: fnd_msg_pub.add;
1961: raise fnd_api.g_exc_unexpected_error;
1962: end if;
1963:
1964: l_txnTypeID := getTxnType(p_txnActionID);

Line 2047: fnd_msg_pub.add;

2043: end if;
2044: if(l_serCount < p_qty) then
2045: fnd_message.set_name('WIP', 'NO_COMP_SERIAL_NUMBERS');
2046: fnd_message.set_token('ITEM', p_itemName);
2047: fnd_msg_pub.add;
2048: l_errMsg := 'error: not enough serials available';
2049: raise fnd_api.g_exc_unexpected_error;
2050: else
2051: x_returnStatus := fnd_api.g_ret_sts_success;

Line 2069: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_autoLotProc_priv',

2065: p_msg => l_errMsg,
2066: x_returnStatus => l_returnStatus);
2067: end if;
2068: when others then
2069: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_autoLotProc_priv',
2070: p_procedure_name => 'checkSerialQuantity',
2071: p_error_text => SQLERRM);
2072: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
2073: if (l_logLevel <= wip_constants.trace_logging) then

Line 2239: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_autoLotProc_priv',

2235: close c_tmpSerials;
2236: elsif(c_intSerials%ISOPEN) then
2237: close c_intSerials;
2238: end if;
2239: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_autoLotProc_priv',
2240: p_procedure_name => 'checkSerial',
2241: p_error_text => SQLERRM);
2242: if (l_logLevel <= wip_constants.trace_logging) then
2243: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.checkSerial',

Line 2459: fnd_msg_pub.add;

2455: END IF;
2456:
2457: fnd_message.set_name('WIP', 'WIP_RET_QTY_MISSMATCH');
2458: fnd_message.set_token('ENTITY1', p_item.item_name);
2459: fnd_msg_pub.add;
2460:
2461: WHEN others THEN
2462: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
2463: IF (l_logLevel <= wip_constants.trace_logging) THEN

Line 2596: fnd_msg_pub.initialize;

2592:
2593: SAVEPOINT s_deriveLotsFromMOG;
2594:
2595: IF(fnd_api.to_boolean(p_initMsgList)) THEN
2596: fnd_msg_pub.initialize;
2597: END IF;
2598:
2599: x_compLots.reset;
2600: --assume we will be able to derive everything