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 798: fnd_msg_pub.initialize;

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

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

1032: end if;
1033: when others then
1034: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1035: rollback to wiplotpb_10;
1036: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_autoLotProc_priv',
1037: p_procedure_name => 'deriveLotsFromMTI',
1038: p_error_text => SQLERRM);
1039: if (l_logLevel <= wip_constants.trace_logging) then
1040: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.deriveLotsFromMTI',

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

1238: close c_retTxnBasedLots;
1239: elsif(c_retTxnBasedLots%ISOPEN) then
1240: close c_negRetTxnBasedLots;
1241: end if;
1242: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_autoLotProc_priv',
1243: p_procedure_name => 'deriveTxnLots',
1244: p_error_text => SQLERRM);
1245: if (l_logLevel <= wip_constants.trace_logging) then
1246: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.deriveTxnLots',

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

1662: close c_receiptOrderedLots;
1663: elsif(c_expDateOrderedLots%ISOPEN) then
1664: close c_expDateOrderedLots;
1665: end if;
1666: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_autoLotProc_priv',
1667: p_procedure_name => 'deriveIssueLots',
1668: p_error_text => SQLERRM);
1669: if (l_logLevel <= wip_constants.trace_logging) then
1670: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.deriveIssueLots',

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

1816: end if;
1817: rollback to wipbflpb40;
1818: when others then
1819: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1820: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_autoLotProc_priv',
1821: p_procedure_name => 'deriveSingleItem',
1822: p_error_text => SQLERRM);
1823: if (l_logLevel <= wip_constants.trace_logging) then
1824: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.deriveSingleItem',

Line 1889: fnd_msg_pub.add;

1885: if(p_qty <> round(p_qty)) then --serial requirements must be whole numbers
1886: l_errMsg := 'serial requirement not a whole #';
1887: fnd_message.set_name('WIP', 'COMP_INVALID_SER_QTY');
1888: fnd_message.set_token('ITEM', p_itemName);
1889: fnd_msg_pub.add;
1890: raise fnd_api.g_exc_unexpected_error;
1891: end if;
1892:
1893: l_txnTypeID := getTxnType(p_txnActionID);

Line 1976: fnd_msg_pub.add;

1972: end if;
1973: if(l_serCount < p_qty) then
1974: fnd_message.set_name('WIP', 'NO_COMP_SERIAL_NUMBERS');
1975: fnd_message.set_token('ITEM', p_itemName);
1976: fnd_msg_pub.add;
1977: l_errMsg := 'error: not enough serials available';
1978: raise fnd_api.g_exc_unexpected_error;
1979: else
1980: x_returnStatus := fnd_api.g_ret_sts_success;

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

1994: p_msg => l_errMsg,
1995: x_returnStatus => l_returnStatus);
1996: end if;
1997: when others then
1998: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_autoLotProc_priv',
1999: p_procedure_name => 'checkSerialQuantity',
2000: p_error_text => SQLERRM);
2001: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
2002: if (l_logLevel <= wip_constants.trace_logging) then

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

2164: close c_tmpSerials;
2165: elsif(c_intSerials%ISOPEN) then
2166: close c_intSerials;
2167: end if;
2168: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_autoLotProc_priv',
2169: p_procedure_name => 'checkSerial',
2170: p_error_text => SQLERRM);
2171: if (l_logLevel <= wip_constants.trace_logging) then
2172: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.checkSerial',

Line 2388: fnd_msg_pub.add;

2384: END IF;
2385:
2386: fnd_message.set_name('WIP', 'WIP_RET_QTY_MISSMATCH');
2387: fnd_message.set_token('ENTITY1', p_item.item_name);
2388: fnd_msg_pub.add;
2389:
2390: WHEN others THEN
2391: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
2392: IF (l_logLevel <= wip_constants.trace_logging) THEN

Line 2525: fnd_msg_pub.initialize;

2521:
2522: SAVEPOINT s_deriveLotsFromMOG;
2523:
2524: IF(fnd_api.to_boolean(p_initMsgList)) THEN
2525: fnd_msg_pub.initialize;
2526: END IF;
2527:
2528: x_compLots.reset;
2529: --assume we will be able to derive everything