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_MOVE_VALIDATOR dependencies on FND_API

Line 1542: WIP_CONSTANTS.FULL_SN, fnd_api.g_true,

1538: wmti.organization_id org_id,
1539: wmti.primary_item_id item_id,
1540: wmti.primary_quantity primary_qty,
1541: DECODE(msik.serial_number_control_code,
1542: WIP_CONSTANTS.FULL_SN, fnd_api.g_true,
1543: WIP_CONSTANTS.DYN_RCV_SN, fnd_api.g_true,
1544: fnd_api.g_false) is_ser_ctrl,
1545: DECODE(msik.lot_control_code,
1546: WIP_CONSTANTS.LOT, fnd_api.g_true,

Line 1543: WIP_CONSTANTS.DYN_RCV_SN, fnd_api.g_true,

1539: wmti.primary_item_id item_id,
1540: wmti.primary_quantity primary_qty,
1541: DECODE(msik.serial_number_control_code,
1542: WIP_CONSTANTS.FULL_SN, fnd_api.g_true,
1543: WIP_CONSTANTS.DYN_RCV_SN, fnd_api.g_true,
1544: fnd_api.g_false) is_ser_ctrl,
1545: DECODE(msik.lot_control_code,
1546: WIP_CONSTANTS.LOT, fnd_api.g_true,
1547: fnd_api.g_false) is_lot_ctrl,

Line 1544: fnd_api.g_false) is_ser_ctrl,

1540: wmti.primary_quantity primary_qty,
1541: DECODE(msik.serial_number_control_code,
1542: WIP_CONSTANTS.FULL_SN, fnd_api.g_true,
1543: WIP_CONSTANTS.DYN_RCV_SN, fnd_api.g_true,
1544: fnd_api.g_false) is_ser_ctrl,
1545: DECODE(msik.lot_control_code,
1546: WIP_CONSTANTS.LOT, fnd_api.g_true,
1547: fnd_api.g_false) is_lot_ctrl,
1548: DECODE(msik.revision_qty_control_code,

Line 1546: WIP_CONSTANTS.LOT, fnd_api.g_true,

1542: WIP_CONSTANTS.FULL_SN, fnd_api.g_true,
1543: WIP_CONSTANTS.DYN_RCV_SN, fnd_api.g_true,
1544: fnd_api.g_false) is_ser_ctrl,
1545: DECODE(msik.lot_control_code,
1546: WIP_CONSTANTS.LOT, fnd_api.g_true,
1547: fnd_api.g_false) is_lot_ctrl,
1548: DECODE(msik.revision_qty_control_code,
1549: WIP_CONSTANTS.REV, fnd_api.g_true,
1550: fnd_api.g_false) is_rev_ctrl,

Line 1547: fnd_api.g_false) is_lot_ctrl,

1543: WIP_CONSTANTS.DYN_RCV_SN, fnd_api.g_true,
1544: fnd_api.g_false) is_ser_ctrl,
1545: DECODE(msik.lot_control_code,
1546: WIP_CONSTANTS.LOT, fnd_api.g_true,
1547: fnd_api.g_false) is_lot_ctrl,
1548: DECODE(msik.revision_qty_control_code,
1549: WIP_CONSTANTS.REV, fnd_api.g_true,
1550: fnd_api.g_false) is_rev_ctrl,
1551: DECODE(msik.revision_qty_control_code, -- revision

Line 1549: WIP_CONSTANTS.REV, fnd_api.g_true,

1545: DECODE(msik.lot_control_code,
1546: WIP_CONSTANTS.LOT, fnd_api.g_true,
1547: fnd_api.g_false) is_lot_ctrl,
1548: DECODE(msik.revision_qty_control_code,
1549: WIP_CONSTANTS.REV, fnd_api.g_true,
1550: fnd_api.g_false) is_rev_ctrl,
1551: DECODE(msik.revision_qty_control_code, -- revision
1552: WIP_CONSTANTS.REV, NVL(wdj.bom_revision,
1553: bom_revisions.get_item_revision_fn

Line 1550: fnd_api.g_false) is_rev_ctrl,

1546: WIP_CONSTANTS.LOT, fnd_api.g_true,
1547: fnd_api.g_false) is_lot_ctrl,
1548: DECODE(msik.revision_qty_control_code,
1549: WIP_CONSTANTS.REV, fnd_api.g_true,
1550: fnd_api.g_false) is_rev_ctrl,
1551: DECODE(msik.revision_qty_control_code, -- revision
1552: WIP_CONSTANTS.REV, NVL(wdj.bom_revision,
1553: bom_revisions.get_item_revision_fn
1554: ('EXCLUDE_OPEN_HOLD', -- eco_status

Line 1589: WIP_CONSTANTS.FULL_SN, fnd_api.g_true,

1585: wmti.organization_id org_id,
1586: wmti.primary_item_id item_id,
1587: wmti.primary_quantity primary_qty,
1588: DECODE(msik.serial_number_control_code,
1589: WIP_CONSTANTS.FULL_SN, fnd_api.g_true,
1590: WIP_CONSTANTS.DYN_RCV_SN, fnd_api.g_true,
1591: fnd_api.g_false) is_ser_ctrl,
1592: DECODE(msik.lot_control_code,
1593: WIP_CONSTANTS.LOT, fnd_api.g_true,

Line 1590: WIP_CONSTANTS.DYN_RCV_SN, fnd_api.g_true,

1586: wmti.primary_item_id item_id,
1587: wmti.primary_quantity primary_qty,
1588: DECODE(msik.serial_number_control_code,
1589: WIP_CONSTANTS.FULL_SN, fnd_api.g_true,
1590: WIP_CONSTANTS.DYN_RCV_SN, fnd_api.g_true,
1591: fnd_api.g_false) is_ser_ctrl,
1592: DECODE(msik.lot_control_code,
1593: WIP_CONSTANTS.LOT, fnd_api.g_true,
1594: fnd_api.g_false) is_lot_ctrl,

Line 1591: fnd_api.g_false) is_ser_ctrl,

1587: wmti.primary_quantity primary_qty,
1588: DECODE(msik.serial_number_control_code,
1589: WIP_CONSTANTS.FULL_SN, fnd_api.g_true,
1590: WIP_CONSTANTS.DYN_RCV_SN, fnd_api.g_true,
1591: fnd_api.g_false) is_ser_ctrl,
1592: DECODE(msik.lot_control_code,
1593: WIP_CONSTANTS.LOT, fnd_api.g_true,
1594: fnd_api.g_false) is_lot_ctrl,
1595: DECODE(msik.revision_qty_control_code,

Line 1593: WIP_CONSTANTS.LOT, fnd_api.g_true,

1589: WIP_CONSTANTS.FULL_SN, fnd_api.g_true,
1590: WIP_CONSTANTS.DYN_RCV_SN, fnd_api.g_true,
1591: fnd_api.g_false) is_ser_ctrl,
1592: DECODE(msik.lot_control_code,
1593: WIP_CONSTANTS.LOT, fnd_api.g_true,
1594: fnd_api.g_false) is_lot_ctrl,
1595: DECODE(msik.revision_qty_control_code,
1596: WIP_CONSTANTS.REV, fnd_api.g_true,
1597: fnd_api.g_false) is_rev_ctrl,

Line 1594: fnd_api.g_false) is_lot_ctrl,

1590: WIP_CONSTANTS.DYN_RCV_SN, fnd_api.g_true,
1591: fnd_api.g_false) is_ser_ctrl,
1592: DECODE(msik.lot_control_code,
1593: WIP_CONSTANTS.LOT, fnd_api.g_true,
1594: fnd_api.g_false) is_lot_ctrl,
1595: DECODE(msik.revision_qty_control_code,
1596: WIP_CONSTANTS.REV, fnd_api.g_true,
1597: fnd_api.g_false) is_rev_ctrl,
1598: DECODE(msik.revision_qty_control_code, -- revision

Line 1596: WIP_CONSTANTS.REV, fnd_api.g_true,

1592: DECODE(msik.lot_control_code,
1593: WIP_CONSTANTS.LOT, fnd_api.g_true,
1594: fnd_api.g_false) is_lot_ctrl,
1595: DECODE(msik.revision_qty_control_code,
1596: WIP_CONSTANTS.REV, fnd_api.g_true,
1597: fnd_api.g_false) is_rev_ctrl,
1598: DECODE(msik.revision_qty_control_code, -- revision
1599: WIP_CONSTANTS.REV, NVL(wrs.bom_revision,
1600: bom_revisions.get_item_revision_fn

Line 1597: fnd_api.g_false) is_rev_ctrl,

1593: WIP_CONSTANTS.LOT, fnd_api.g_true,
1594: fnd_api.g_false) is_lot_ctrl,
1595: DECODE(msik.revision_qty_control_code,
1596: WIP_CONSTANTS.REV, fnd_api.g_true,
1597: fnd_api.g_false) is_rev_ctrl,
1598: DECODE(msik.revision_qty_control_code, -- revision
1599: WIP_CONSTANTS.REV, NVL(wrs.bom_revision,
1600: bom_revisions.get_item_revision_fn
1601: ('EXCLUDE_OPEN_HOLD', -- eco_status

Line 1832: p_is_revision_control => fnd_api.to_boolean(l_availQty.is_rev_ctrl),

1828: p_onhand_source => inv_quantity_tree_pvt.g_all_subs,
1829: p_organization_id => l_availQty.org_id,
1830: p_inventory_item_id => l_availQty.item_id,
1831: p_tree_mode => inv_quantity_tree_pvt.g_loose_only_mode,
1832: p_is_revision_control => fnd_api.to_boolean(l_availQty.is_rev_ctrl),
1833: p_is_lot_control => fnd_api.to_boolean(l_availQty.is_lot_ctrl),
1834: p_is_serial_control => fnd_api.to_boolean(l_availQty.is_ser_ctrl),
1835: p_demand_source_type_id => 5, -- WIP
1836: p_revision => l_availQty.revision,

Line 1833: p_is_lot_control => fnd_api.to_boolean(l_availQty.is_lot_ctrl),

1829: p_organization_id => l_availQty.org_id,
1830: p_inventory_item_id => l_availQty.item_id,
1831: p_tree_mode => inv_quantity_tree_pvt.g_loose_only_mode,
1832: p_is_revision_control => fnd_api.to_boolean(l_availQty.is_rev_ctrl),
1833: p_is_lot_control => fnd_api.to_boolean(l_availQty.is_lot_ctrl),
1834: p_is_serial_control => fnd_api.to_boolean(l_availQty.is_ser_ctrl),
1835: p_demand_source_type_id => 5, -- WIP
1836: p_revision => l_availQty.revision,
1837: p_lot_number => l_availQty.lot,

Line 1834: p_is_serial_control => fnd_api.to_boolean(l_availQty.is_ser_ctrl),

1830: p_inventory_item_id => l_availQty.item_id,
1831: p_tree_mode => inv_quantity_tree_pvt.g_loose_only_mode,
1832: p_is_revision_control => fnd_api.to_boolean(l_availQty.is_rev_ctrl),
1833: p_is_lot_control => fnd_api.to_boolean(l_availQty.is_lot_ctrl),
1834: p_is_serial_control => fnd_api.to_boolean(l_availQty.is_ser_ctrl),
1835: p_demand_source_type_id => 5, -- WIP
1836: p_revision => l_availQty.revision,
1837: p_lot_number => l_availQty.lot,
1838: p_lot_expiration_date => l_availQty.txn_date,

Line 1876: p_is_revision_control => fnd_api.to_boolean(l_repAvailQty.is_rev_ctrl),

1872: p_onhand_source => inv_quantity_tree_pvt.g_all_subs,
1873: p_organization_id => l_repAvailQty.org_id,
1874: p_inventory_item_id => l_repAvailQty.item_id,
1875: p_tree_mode => inv_quantity_tree_pvt.g_loose_only_mode,
1876: p_is_revision_control => fnd_api.to_boolean(l_repAvailQty.is_rev_ctrl),
1877: p_is_lot_control => fnd_api.to_boolean(l_repAvailQty.is_lot_ctrl),
1878: p_is_serial_control => fnd_api.to_boolean(l_repAvailQty.is_ser_ctrl),
1879: p_demand_source_type_id => 5, -- WIP
1880: p_revision => l_repAvailQty.revision,

Line 1877: p_is_lot_control => fnd_api.to_boolean(l_repAvailQty.is_lot_ctrl),

1873: p_organization_id => l_repAvailQty.org_id,
1874: p_inventory_item_id => l_repAvailQty.item_id,
1875: p_tree_mode => inv_quantity_tree_pvt.g_loose_only_mode,
1876: p_is_revision_control => fnd_api.to_boolean(l_repAvailQty.is_rev_ctrl),
1877: p_is_lot_control => fnd_api.to_boolean(l_repAvailQty.is_lot_ctrl),
1878: p_is_serial_control => fnd_api.to_boolean(l_repAvailQty.is_ser_ctrl),
1879: p_demand_source_type_id => 5, -- WIP
1880: p_revision => l_repAvailQty.revision,
1881: p_lot_number => l_repAvailQty.lot,

Line 1878: p_is_serial_control => fnd_api.to_boolean(l_repAvailQty.is_ser_ctrl),

1874: p_inventory_item_id => l_repAvailQty.item_id,
1875: p_tree_mode => inv_quantity_tree_pvt.g_loose_only_mode,
1876: p_is_revision_control => fnd_api.to_boolean(l_repAvailQty.is_rev_ctrl),
1877: p_is_lot_control => fnd_api.to_boolean(l_repAvailQty.is_lot_ctrl),
1878: p_is_serial_control => fnd_api.to_boolean(l_repAvailQty.is_ser_ctrl),
1879: p_demand_source_type_id => 5, -- WIP
1880: p_revision => l_repAvailQty.revision,
1881: p_lot_number => l_repAvailQty.lot,
1882: p_lot_expiration_date => l_repAvailQty.txn_date,

Line 2907: IF(fnd_api.to_boolean(p_initMsgList)) THEN

2903: l_logLevel NUMBER ;
2904:
2905: BEGIN
2906: l_logLevel := fnd_log.g_current_runtime_level;
2907: IF(fnd_api.to_boolean(p_initMsgList)) THEN
2908: fnd_msg_pub.initialize;
2909: END IF;
2910:
2911: -- write parameter value to log file

Line 2985: p_procReturnStatus => fnd_api.g_ret_sts_success,

2981: derive;
2982: -- write to the log file
2983: if (l_logLevel <= wip_constants.trace_logging) then
2984: wip_logger.exitPoint(p_procName => 'wip_move_validator.validate',
2985: p_procReturnStatus => fnd_api.g_ret_sts_success,
2986: p_msg => 'procedure complete',
2987: x_returnStatus => l_returnStatus);
2988: end if;
2989: EXCEPTION

Line 2993: p_procReturnStatus => fnd_api.g_ret_sts_unexp_error,

2989: EXCEPTION
2990: WHEN others THEN
2991: if (l_logLevel <= wip_constants.trace_logging) then
2992: wip_logger.exitPoint(p_procName => 'wip_move_validator.validate',
2993: p_procReturnStatus => fnd_api.g_ret_sts_unexp_error,
2994: p_msg => 'Unexpected Errors: ' || SQLERRM,
2995: x_returnStatus => l_returnStatus);
2996: end if;
2997:

Line 3251: p_procReturnStatus => fnd_api.g_ret_sts_success,

3247:
3248: -- write to the log file
3249: if (l_logLevel <= wip_constants.trace_logging) then
3250: wip_logger.exitPoint(p_procName => 'wip_move_validator.validateOATxn',
3251: p_procReturnStatus => fnd_api.g_ret_sts_success,
3252: p_msg => 'procedure complete',
3253: x_returnStatus => l_returnStatus);
3254: end if;
3255: EXCEPTION

Line 3259: p_procReturnStatus => fnd_api.g_ret_sts_unexp_error,

3255: EXCEPTION
3256: WHEN others THEN
3257: if (l_logLevel <= wip_constants.trace_logging) then
3258: wip_logger.exitPoint(p_procName => 'wip_move_validator.validateOATxn',
3259: p_procReturnStatus => fnd_api.g_ret_sts_unexp_error,
3260: p_msg => 'Unexpected Errors: ' || SQLERRM,
3261: x_returnStatus => l_returnStatus);
3262: end if;
3263: