eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WIP_AUTOLOTPROC_PRIV dependencies on WIP_AUTOLOTPROC_PRIV

Line 1: package body wip_autoLotProc_priv as

1: package body wip_autoLotProc_priv as
2: /* $Header: wiplotpb.pls 120.3 2007/09/17 21:14:49 kboonyap ship $ */
3:
4:
5: -----------------------

Line 141: wip_logger.entryPoint(p_procName => 'wip_autoLotProc_priv.deriveLots',

137: l_params(1).paramName := 'p_orgID';
138: l_params(1).paramValue := p_orgID;
139: l_params(2).paramName := 'p_wipEntityID';
140: l_params(2).paramValue := p_wipEntityID;
141: wip_logger.entryPoint(p_procName => 'wip_autoLotProc_priv.deriveLots',
142: p_params => l_params,
143: x_returnStatus => x_returnStatus);
144: end if;
145:

Line 214: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.deriveLots',

210: l_treeID := null;
211: end if;
212:
213: if (l_logLevel <= wip_constants.trace_logging) then
214: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.deriveLots',
215: p_procReturnStatus => x_returnStatus,
216: p_msg => 'procedure success',
217: x_returnStatus => l_returnStatus); --discard logging return status
218: end if;

Line 226: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.deriveLots',

222: exception
223: when fnd_api.g_exc_unexpected_error then
224: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
225: if (l_logLevel <= wip_constants.trace_logging) then
226: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.deriveLots',
227: p_procReturnStatus => x_returnStatus,
228: p_msg => l_errMsg,
229: x_returnStatus => l_returnStatus); --discard logging return status
230: end if;

Line 237: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.deriveLots',

233: end if;
234: when others then
235: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
236: if (l_logLevel <= wip_constants.trace_logging) then
237: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.deriveLots',
238: p_procReturnStatus => x_returnStatus,
239: p_msg => 'unexpected error:' || SQLERRM,
240: x_returnStatus => l_returnStatus); --discard logging return status
241: end if;

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 368: wip_logger.entryPoint(p_procName => 'wip_autoLotProc_priv.deriveLotsFromMMTT',

364: l_params(3).paramName := 'p_orgID';
365: l_params(3).paramValue := p_orgID;
366: l_params(4).paramName := 'p_wipEntityID';
367: l_params(4).paramValue := p_wipEntityID;
368: wip_logger.entryPoint(p_procName => 'wip_autoLotProc_priv.deriveLotsFromMMTT',
369: p_params => l_params,
370: x_returnStatus => x_returnStatus);
371: end if;
372:

Line 575: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.deriveLotsFromMMTT',

571: end if;
572:
573: --return status has already been set at this point
574: if (l_logLevel <= wip_constants.trace_logging) then
575: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.deriveLotsFromMMTT',
576: p_procReturnStatus => x_returnStatus,
577: p_msg => 'procedure success',
578: x_returnStatus => l_returnStatus); --discard logging return status
579: end if;

Line 588: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.deriveLotsFromMMTT',

584: when fnd_api.g_exc_unexpected_error then
585: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
586: rollback to wiplotpb_10;
587: if (l_logLevel <= wip_constants.trace_logging) then
588: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.deriveLotsFromMMTT',
589: p_procReturnStatus => x_returnStatus,
590: p_msg => l_errMsg,
591: x_returnStatus => l_returnStatus); --discard logging return status
592: end if;

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 603: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.deriveLotsFromMMTT',

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',
604: p_procReturnStatus => x_returnStatus,
605: p_msg => 'unexpected error:' || SQLERRM,
606: x_returnStatus => l_returnStatus); --discard logging return status
607: end if;

Line 792: wip_logger.entryPoint(p_procName => 'wip_autoLotProc_priv.deriveLotsFromMTI',

788: l_params(4).paramName := 'p_orgID';
789: l_params(4).paramValue := p_orgID;
790: l_params(5).paramName := 'p_wipEntityID';
791: l_params(5).paramValue := p_wipEntityID;
792: wip_logger.entryPoint(p_procName => 'wip_autoLotProc_priv.deriveLotsFromMTI',
793: p_params => l_params,
794: x_returnStatus => x_returnStatus);
795: end if;
796:

Line 1012: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.deriveLotsFromMTI',

1008: end loop;
1009:
1010: --return status has already been set at this point
1011: if (l_logLevel <= wip_constants.trace_logging) then
1012: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.deriveLotsFromMTI',
1013: p_procReturnStatus => x_returnStatus,
1014: p_msg => 'procedure success',
1015: x_returnStatus => l_returnStatus); --discard logging return status
1016: end if;

Line 1025: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.deriveLotsFromMTI',

1021: when fnd_api.g_exc_unexpected_error then
1022: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1023: rollback to wiplotpb_10;
1024: if (l_logLevel <= wip_constants.trace_logging) then
1025: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.deriveLotsFromMTI',
1026: p_procReturnStatus => x_returnStatus,
1027: p_msg => l_errMsg,
1028: x_returnStatus => l_returnStatus); --discard logging return status
1029: end if;

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 1040: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.deriveLotsFromMTI',

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',
1041: p_procReturnStatus => x_returnStatus,
1042: p_msg => 'unexpected error:' || SQLERRM,
1043: x_returnStatus => l_returnStatus); --discard logging return status
1044: end if;

Line 1140: wip_logger.entryPoint(p_procName => 'wip_autoLotProc_priv.deriveTxnLots',

1136: l_params(7).paramValue := l_item.revision;
1137: l_params(8).paramName := 'x_compLot(cur_item).primary_quantity';
1138: l_params(8).paramValue := l_item.primary_quantity;
1139: end if;
1140: wip_logger.entryPoint(p_procName => 'wip_autoLotProc_priv.deriveTxnLots',
1141: p_params => l_params,
1142: x_returnStatus => x_returnStatus);
1143: end if;
1144:

Line 1212: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.deriveTxnLots',

1208: raise fnd_api.g_exc_error;
1209: end if;
1210:
1211: if (l_logLevel <= wip_constants.trace_logging) then
1212: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.deriveTxnLots',
1213: p_procReturnStatus => x_returnStatus,
1214: p_msg => 'procedure success',
1215: x_returnStatus => l_returnStatus); --discard logging return status
1216: end if;

Line 1222: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.deriveTxnLots',

1218: exception
1219: when fnd_api.g_exc_error then
1220: x_returnStatus:= fnd_api.g_ret_sts_error; --let caller know item was not fully derived
1221: if (l_logLevel <= wip_constants.trace_logging) then
1222: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.deriveTxnLots',
1223: p_procReturnStatus => x_returnStatus,
1224: p_msg => l_errMsg,
1225: x_returnStatus => l_returnStatus); --discard logging return status
1226: end if;

Line 1230: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.deriveTxnLots',

1226: end if;
1227: when fnd_api.g_exc_unexpected_error then
1228: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1229: if (l_logLevel <= wip_constants.trace_logging) then
1230: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.deriveTxnLots',
1231: p_procReturnStatus => x_returnStatus,
1232: p_msg => 'error: ' || l_errMsg,
1233: x_returnStatus => l_returnStatus); --discard logging return status
1234: end if;

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 1246: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.deriveTxnLots',

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',
1247: p_procReturnStatus => x_returnStatus,
1248: p_msg => 'error: ' || SQLERRM,
1249: x_returnStatus => l_returnStatus); --discard logging return status
1250: end if;

Line 1391: wip_logger.entryPoint(p_procName => 'wip_autoLotProc_priv.deriveIssueLots',

1387: l_params(7).paramValue := l_item.revision;
1388: l_params(8).paramName := 'x_compLot(cur_item).primary_quantity';
1389: l_params(8).paramValue := l_item.primary_quantity;
1390: end if;
1391: wip_logger.entryPoint(p_procName => 'wip_autoLotProc_priv.deriveIssueLots',
1392: p_params => l_params,
1393: x_returnStatus => x_returnStatus);
1394: end if;
1395:

Line 1631: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.deriveIssueLots',

1627: raise fnd_api.g_exc_error;
1628: end if;
1629:
1630: if (l_logLevel <= wip_constants.trace_logging) then
1631: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.deriveIssueLots',
1632: p_procReturnStatus => x_returnStatus,
1633: p_msg => 'procedure success',
1634: x_returnStatus => l_returnStatus); --discard logging return status
1635: end if;

Line 1641: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.deriveIssueLots',

1637: exception
1638: when fnd_api.g_exc_error then
1639: x_returnStatus:= fnd_api.g_ret_sts_error; --let caller know item was not fully derived
1640: if (l_logLevel <= wip_constants.trace_logging) then
1641: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.deriveIssueLots',
1642: p_procReturnStatus => x_returnStatus,
1643: p_msg => l_errMsg,
1644: x_returnStatus => l_returnStatus); --discard logging return status
1645: end if;

Line 1654: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.deriveIssueLots',

1650: elsif(c_expDateOrderedLots%ISOPEN) then
1651: close c_expDateOrderedLots;
1652: end if;
1653: if (l_logLevel <= wip_constants.trace_logging) then
1654: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.deriveIssueLots',
1655: p_procReturnStatus => x_returnStatus,
1656: p_msg => 'error: ' || l_errMsg,
1657: x_returnStatus => l_returnStatus); --discard logging return status
1658: end if;

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 1670: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.deriveIssueLots',

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',
1671: p_procReturnStatus => x_returnStatus,
1672: p_msg => 'error: ' || SQLERRM,
1673: x_returnStatus => l_returnStatus); --discard logging return status
1674: end if;

Line 1708: wip_logger.entryPoint(p_procName => 'wip_autoLotProc_priv.deriveSingleItem',

1704: l_params(4).paramValue := p_treeSrcName;
1705: l_params(5).paramName := 'x_treeID';
1706: l_params(5).paramValue := x_treeID;
1707:
1708: wip_logger.entryPoint(p_procName => 'wip_autoLotProc_priv.deriveSingleItem',
1709: p_params => l_params,
1710: x_returnStatus => x_returnStatus);
1711: end if;
1712:

Line 1748: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.deriveSingleItem',

1744: --if uncontrolled, return success (no derivation necessary)
1745: if(l_lotControlCode = wip_constants.no_lot) then
1746: x_returnStatus := fnd_api.g_ret_sts_success;
1747: if (l_logLevel <= wip_constants.trace_logging) then
1748: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.deriveSingleItem',
1749: p_procReturnStatus => x_returnStatus,
1750: p_msg => 'procedure success (no derivation necessary)',
1751: x_returnStatus => l_returnStatus); --discard logging return status
1752: end if;

Line 1793: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.deriveSingleItem',

1789: raise fnd_api.g_exc_unexpected_error;
1790: end if;
1791:
1792: if (l_logLevel <= wip_constants.trace_logging) then
1793: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.deriveSingleItem',
1794: p_procReturnStatus => x_returnStatus,
1795: p_msg => 'procedure success',
1796: x_returnStatus => l_returnStatus); --discard logging return status
1797: end if;

Line 1803: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.deriveSingleItem',

1799: exception
1800: when fnd_api.g_exc_error then
1801: x_returnStatus := fnd_api.g_ret_sts_error;
1802: if (l_logLevel <= wip_constants.trace_logging) then
1803: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.deriveSingleItem',
1804: p_procReturnStatus => x_returnStatus,
1805: p_msg => 'error' || l_errMsg,
1806: x_returnStatus => l_returnStatus); --discard logging return status
1807: end if;

Line 1812: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.deriveSingleItem',

1808: rollback to wipbflpb40;
1809: when fnd_api.g_exc_unexpected_error then
1810: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1811: if (l_logLevel <= wip_constants.trace_logging) then
1812: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.deriveSingleItem',
1813: p_procReturnStatus => x_returnStatus,
1814: p_msg => 'unexp error raised:',
1815: x_returnStatus => l_returnStatus); --discard logging return status
1816: end if;

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 1824: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.deriveSingleItem',

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',
1825: p_procReturnStatus => x_returnStatus,
1826: p_msg => 'unexp error:' || SQLERRM,
1827: x_returnStatus => l_returnStatus); --discard logging return status
1828: end if;

Line 1876: wip_logger.entryPoint(p_procName => 'wip_autoLotProc_priv.checkSerialQuantity',

1872: l_params(3).paramName := 'p_qty';
1873: l_params(3).paramValue := p_qty;
1874: l_params(4).paramName := 'p_txnActionID';
1875: l_params(4).paramValue := p_txnActionID;
1876: wip_logger.entryPoint(p_procName => 'wip_autoLotProc_priv.checkSerialQuantity',
1877: p_params => l_params,
1878: x_returnStatus => x_returnStatus);
1879: end if;
1880:

Line 1942: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.checkSerialQuantity',

1938: elsif(p_txnActionID = wip_constants.issnegc_action) then
1939: if(p_serControlCode = wip_constants.dyn_rcv_sn) then
1940: x_returnStatus := fnd_api.g_ret_sts_success;
1941: if (l_logLevel <= wip_constants.trace_logging) then
1942: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.checkSerialQuantity',
1943: p_procReturnStatus => x_returnStatus,
1944: p_msg => 'procedure success (neg issue and serial is dyn at recpt)',
1945: x_returnStatus => l_returnStatus);
1946: end if;

Line 1983: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.checkSerialQuantity',

1979: else
1980: x_returnStatus := fnd_api.g_ret_sts_success;
1981: end if;
1982: if (l_logLevel <= wip_constants.trace_logging) then
1983: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.checkSerialQuantity',
1984: p_procReturnStatus => x_returnStatus,
1985: p_msg => 'procedure success',
1986: x_returnStatus => l_returnStatus);
1987: end if;

Line 1992: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.checkSerialQuantity',

1988: exception
1989: when fnd_api.g_exc_unexpected_error then
1990: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1991: if (l_logLevel <= wip_constants.trace_logging) then
1992: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.checkSerialQuantity',
1993: p_procReturnStatus => x_returnStatus,
1994: p_msg => l_errMsg,
1995: x_returnStatus => l_returnStatus);
1996: end if;

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 2003: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.checkSerialQuantity',

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
2003: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.checkSerialQuantity',
2004: p_procReturnStatus => x_returnStatus,
2005: p_msg => 'unexp error ' || SQLERRM,
2006: x_returnStatus => l_returnStatus);
2007: end if;

Line 2072: wip_logger.entryPoint(p_procName => 'wip_autoLotProc_priv.checkSerial',

2068: l_params(10).paramName := 'p_txnActionID';
2069: l_params(10).paramValue := p_txnActionID;
2070: l_params(11).paramName := 'p_serControlCode';
2071: l_params(11).paramValue := p_serControlCode;
2072: wip_logger.entryPoint(p_procName => 'wip_autoLotProc_priv.checkSerial',
2073: p_params => l_params,
2074: x_returnStatus => x_returnStatus);
2075: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
2076: raise fnd_api.g_exc_unexpected_error;

Line 2131: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.checkSerial',

2127:
2128: end if;
2129:
2130: if (l_logLevel <= wip_constants.trace_logging) then
2131: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.checkSerial',
2132: p_procReturnStatus => x_returnStatus,
2133: p_msg => 'procedure success',
2134: x_returnStatus => l_returnStatus);
2135: end if;

Line 2141: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.checkSerial',

2137: when fnd_api.g_exc_error then
2138: x_serialReturnStatus := fnd_api.g_ret_sts_error;
2139: x_returnStatus := fnd_api.g_ret_sts_success;
2140: if (l_logLevel <= wip_constants.trace_logging) then
2141: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.checkSerial',
2142: p_procReturnStatus => x_returnStatus,
2143: p_msg => 'insufficient serial qty. only found ' || l_totalQty,
2144: x_returnStatus => l_returnStatus);
2145: end if;

Line 2155: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.checkSerial',

2151: elsif(c_intSerials%ISOPEN) then
2152: close c_intSerials;
2153: end if;
2154: if (l_logLevel <= wip_constants.trace_logging) then
2155: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.checkSerial',
2156: p_procReturnStatus => x_returnStatus,
2157: p_msg => l_errMsg,
2158: x_returnStatus => l_returnStatus);
2159: end if;

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 2172: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.checkSerial',

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',
2173: p_procReturnStatus => x_returnStatus,
2174: p_msg => 'unexp error ' || SQLERRM,
2175: x_returnStatus => l_returnStatus);
2176: end if;

Line 2238: wip_logger.entryPoint(p_procName => 'wip_autoLotProc_priv.lot_selected',

2234: l_params(4).paramValue := p_locator_id;
2235: l_params(5).paramName := 'p_lot_number';
2236: l_params(5).paramValue := p_lot_number;
2237:
2238: wip_logger.entryPoint(p_procName => 'wip_autoLotProc_priv.lot_selected',
2239: p_params => l_params,
2240: x_returnStatus => x_returnStatus);
2241: end if ;
2242:

Line 2268: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.lot_selected',

2264:
2265: wip_logger.log( 'Lot Qty Selected ' || p_lot_qty_selected || ' for Lot ' || p_lot_number, l_returnStatus) ;
2266:
2267: if (l_logLevel <= wip_constants.trace_logging) then
2268: wip_logger.exitPoint(p_procName => 'wip_autoLotProc_priv.lot_selected',
2269: p_procReturnStatus => x_returnStatus,
2270: p_msg => 'procedure success',
2271: x_returnStatus => l_returnStatus); --discard logging return status
2272: end if;

Line 2337: p_procName => 'wip_autoLotProc_priv.deriveSingleItemFromMOG',

2333: l_params(8).paramValue := p_item.primary_quantity;
2334: l_params(9).paramName := 'p_item.transaction_action_id';
2335: l_params(9).paramValue := p_item.transaction_action_id;
2336: wip_logger.entryPoint(
2337: p_procName => 'wip_autoLotProc_priv.deriveSingleItemFromMOG',
2338: p_params => l_params,
2339: x_returnStatus => x_returnStatus);
2340: END IF;
2341: -- Under lot control only

Line 2369: p_procName => 'wip_autoLotProc_priv.deriveSingleItemFromMOG',

2365: END IF;
2366:
2367: IF (l_logLevel <= wip_constants.trace_logging) THEN
2368: wip_logger.exitPoint(
2369: p_procName => 'wip_autoLotProc_priv.deriveSingleItemFromMOG',
2370: p_procReturnStatus => x_returnStatus,
2371: p_msg => 'procedure success',
2372: x_returnStatus => l_returnStatus); --discard return status
2373: END IF;

Line 2380: p_procName => 'wip_autoLotProc_priv.deriveSingleItemFromMOG',

2376: WHEN fnd_api.g_exc_unexpected_error THEN
2377: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
2378: IF (l_logLevel <= wip_constants.trace_logging) THEN
2379: wip_logger.exitPoint(
2380: p_procName => 'wip_autoLotProc_priv.deriveSingleItemFromMOG',
2381: p_procReturnStatus => x_returnStatus,
2382: p_msg => l_errMsg,
2383: x_returnStatus => l_returnStatus); --discard return status
2384: END IF;

Line 2394: p_procName => 'wip_autoLotProc_priv.deriveSingleItemFromMOG',

2390: WHEN others THEN
2391: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
2392: IF (l_logLevel <= wip_constants.trace_logging) THEN
2393: wip_logger.exitPoint(
2394: p_procName => 'wip_autoLotProc_priv.deriveSingleItemFromMOG',
2395: p_procReturnStatus => x_returnStatus,
2396: p_msg => 'unexp error:' || SQLERRM,
2397: x_returnStatus => l_returnStatus); --discard return status
2398: END IF;

Line 2457: p_procName => 'wip_autoLotProc_priv.setItemRevision',

2453: l_params(8).paramValue := p_item.primary_quantity;
2454: l_params(9).paramName := 'p_item.transaction_action_id';
2455: l_params(9).paramValue := p_item.transaction_action_id;
2456: wip_logger.entryPoint(
2457: p_procName => 'wip_autoLotProc_priv.setItemRevision',
2458: p_params => l_params,
2459: x_returnStatus => x_returnStatus);
2460: END IF;
2461:

Line 2474: p_procName => 'wip_autoLotProc_priv.setItemRevision',

2470: END IF;
2471:
2472: IF (l_logLevel <= wip_constants.trace_logging) THEN
2473: wip_logger.exitPoint(
2474: p_procName => 'wip_autoLotProc_priv.setItemRevision',
2475: p_procReturnStatus => x_returnStatus,
2476: p_msg => 'procedure success',
2477: x_returnStatus => l_returnStatus); --discard return status
2478: END IF;

Line 2489: p_procName => 'wip_autoLotProc_priv.setItemRevision',

2485:
2486: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
2487: IF (l_logLevel <= wip_constants.trace_logging) THEN
2488: wip_logger.exitPoint(
2489: p_procName => 'wip_autoLotProc_priv.setItemRevision',
2490: p_procReturnStatus => x_returnStatus,
2491: p_msg => 'unexp error:' || SQLERRM,
2492: x_returnStatus => l_returnStatus); --discard return status
2493: END IF;

Line 2517: p_procName => 'wip_autoLotProc_priv.deriveLotsFromMOG',

2513: l_params(2).paramName := 'p_objectID';
2514: l_params(2).paramValue := p_objectID;
2515:
2516: wip_logger.entryPoint(
2517: p_procName => 'wip_autoLotProc_priv.deriveLotsFromMOG',
2518: p_params => l_params,
2519: x_returnStatus => x_returnStatus);
2520: END IF;
2521:

Line 2580: p_procName => 'wip_autoLotProc_priv.deriveLotsFromMOG',

2576: END LOOP;
2577:
2578: IF (l_logLevel <= wip_constants.trace_logging) THEN
2579: wip_logger.exitPoint(
2580: p_procName => 'wip_autoLotProc_priv.deriveLotsFromMOG',
2581: p_procReturnStatus => x_returnStatus,
2582: p_msg => 'procedure success',
2583: x_returnStatus => l_returnStatus);
2584: END IF;

Line 2591: p_procName => 'wip_autoLotProc_priv.deriveLotsFromMOG',

2587: WHEN fnd_api.g_exc_unexpected_error THEN
2588: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
2589: IF (l_logLevel <= wip_constants.trace_logging) THEN
2590: wip_logger.exitPoint(
2591: p_procName => 'wip_autoLotProc_priv.deriveLotsFromMOG',
2592: p_procReturnStatus => x_returnStatus,
2593: p_msg => l_errMsg,
2594: x_returnStatus => l_returnStatus); --discard return status
2595: END IF;

Line 2602: p_procName => 'wip_autoLotProc_priv.deriveLotsFromMOG',

2598: WHEN others THEN
2599: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
2600: IF (l_logLevel <= wip_constants.trace_logging) THEN
2601: wip_logger.exitPoint(
2602: p_procName => 'wip_autoLotProc_priv.deriveLotsFromMOG',
2603: p_procReturnStatus => x_returnStatus,
2604: p_msg => 'unexpected error:' || SQLERRM,
2605: x_returnStatus => l_returnStatus); --discard return status
2606: END IF;

Line 2611: end wip_autoLotProc_priv;

2607: ROLLBACK TO s_deriveLotsFromMOG;
2608:
2609: END deriveLotsFromMOG;
2610:
2611: end wip_autoLotProc_priv;