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 1610: WIP_CONSTANTS.FULL_SN, fnd_api.g_true,

1606: wmti.organization_id org_id,
1607: wmti.primary_item_id item_id,
1608: wmti.primary_quantity primary_qty,
1609: DECODE(msik.serial_number_control_code,
1610: WIP_CONSTANTS.FULL_SN, fnd_api.g_true,
1611: WIP_CONSTANTS.DYN_RCV_SN, fnd_api.g_true,
1612: fnd_api.g_false) is_ser_ctrl,
1613: DECODE(msik.lot_control_code,
1614: WIP_CONSTANTS.LOT, fnd_api.g_true,

Line 1611: WIP_CONSTANTS.DYN_RCV_SN, fnd_api.g_true,

1607: wmti.primary_item_id item_id,
1608: wmti.primary_quantity primary_qty,
1609: DECODE(msik.serial_number_control_code,
1610: WIP_CONSTANTS.FULL_SN, fnd_api.g_true,
1611: WIP_CONSTANTS.DYN_RCV_SN, fnd_api.g_true,
1612: fnd_api.g_false) is_ser_ctrl,
1613: DECODE(msik.lot_control_code,
1614: WIP_CONSTANTS.LOT, fnd_api.g_true,
1615: fnd_api.g_false) is_lot_ctrl,

Line 1612: fnd_api.g_false) is_ser_ctrl,

1608: wmti.primary_quantity primary_qty,
1609: DECODE(msik.serial_number_control_code,
1610: WIP_CONSTANTS.FULL_SN, fnd_api.g_true,
1611: WIP_CONSTANTS.DYN_RCV_SN, fnd_api.g_true,
1612: fnd_api.g_false) is_ser_ctrl,
1613: DECODE(msik.lot_control_code,
1614: WIP_CONSTANTS.LOT, fnd_api.g_true,
1615: fnd_api.g_false) is_lot_ctrl,
1616: DECODE(msik.revision_qty_control_code,

Line 1614: WIP_CONSTANTS.LOT, fnd_api.g_true,

1610: WIP_CONSTANTS.FULL_SN, fnd_api.g_true,
1611: WIP_CONSTANTS.DYN_RCV_SN, fnd_api.g_true,
1612: fnd_api.g_false) is_ser_ctrl,
1613: DECODE(msik.lot_control_code,
1614: WIP_CONSTANTS.LOT, fnd_api.g_true,
1615: fnd_api.g_false) is_lot_ctrl,
1616: DECODE(msik.revision_qty_control_code,
1617: WIP_CONSTANTS.REV, fnd_api.g_true,
1618: fnd_api.g_false) is_rev_ctrl,

Line 1615: fnd_api.g_false) is_lot_ctrl,

1611: WIP_CONSTANTS.DYN_RCV_SN, fnd_api.g_true,
1612: fnd_api.g_false) is_ser_ctrl,
1613: DECODE(msik.lot_control_code,
1614: WIP_CONSTANTS.LOT, fnd_api.g_true,
1615: fnd_api.g_false) is_lot_ctrl,
1616: DECODE(msik.revision_qty_control_code,
1617: WIP_CONSTANTS.REV, fnd_api.g_true,
1618: fnd_api.g_false) is_rev_ctrl,
1619: DECODE(msik.revision_qty_control_code, -- revision

Line 1617: WIP_CONSTANTS.REV, fnd_api.g_true,

1613: DECODE(msik.lot_control_code,
1614: WIP_CONSTANTS.LOT, fnd_api.g_true,
1615: fnd_api.g_false) is_lot_ctrl,
1616: DECODE(msik.revision_qty_control_code,
1617: WIP_CONSTANTS.REV, fnd_api.g_true,
1618: fnd_api.g_false) is_rev_ctrl,
1619: DECODE(msik.revision_qty_control_code, -- revision
1620: WIP_CONSTANTS.REV, NVL(wdj.bom_revision,
1621: bom_revisions.get_item_revision_fn

Line 1618: fnd_api.g_false) is_rev_ctrl,

1614: WIP_CONSTANTS.LOT, fnd_api.g_true,
1615: fnd_api.g_false) is_lot_ctrl,
1616: DECODE(msik.revision_qty_control_code,
1617: WIP_CONSTANTS.REV, fnd_api.g_true,
1618: fnd_api.g_false) is_rev_ctrl,
1619: DECODE(msik.revision_qty_control_code, -- revision
1620: WIP_CONSTANTS.REV, NVL(wdj.bom_revision,
1621: bom_revisions.get_item_revision_fn
1622: ('EXCLUDE_OPEN_HOLD', -- eco_status

Line 1657: WIP_CONSTANTS.FULL_SN, fnd_api.g_true,

1653: wmti.organization_id org_id,
1654: wmti.primary_item_id item_id,
1655: wmti.primary_quantity primary_qty,
1656: DECODE(msik.serial_number_control_code,
1657: WIP_CONSTANTS.FULL_SN, fnd_api.g_true,
1658: WIP_CONSTANTS.DYN_RCV_SN, fnd_api.g_true,
1659: fnd_api.g_false) is_ser_ctrl,
1660: DECODE(msik.lot_control_code,
1661: WIP_CONSTANTS.LOT, fnd_api.g_true,

Line 1658: WIP_CONSTANTS.DYN_RCV_SN, fnd_api.g_true,

1654: wmti.primary_item_id item_id,
1655: wmti.primary_quantity primary_qty,
1656: DECODE(msik.serial_number_control_code,
1657: WIP_CONSTANTS.FULL_SN, fnd_api.g_true,
1658: WIP_CONSTANTS.DYN_RCV_SN, fnd_api.g_true,
1659: fnd_api.g_false) is_ser_ctrl,
1660: DECODE(msik.lot_control_code,
1661: WIP_CONSTANTS.LOT, fnd_api.g_true,
1662: fnd_api.g_false) is_lot_ctrl,

Line 1659: fnd_api.g_false) is_ser_ctrl,

1655: wmti.primary_quantity primary_qty,
1656: DECODE(msik.serial_number_control_code,
1657: WIP_CONSTANTS.FULL_SN, fnd_api.g_true,
1658: WIP_CONSTANTS.DYN_RCV_SN, fnd_api.g_true,
1659: fnd_api.g_false) is_ser_ctrl,
1660: DECODE(msik.lot_control_code,
1661: WIP_CONSTANTS.LOT, fnd_api.g_true,
1662: fnd_api.g_false) is_lot_ctrl,
1663: DECODE(msik.revision_qty_control_code,

Line 1661: WIP_CONSTANTS.LOT, fnd_api.g_true,

1657: WIP_CONSTANTS.FULL_SN, fnd_api.g_true,
1658: WIP_CONSTANTS.DYN_RCV_SN, fnd_api.g_true,
1659: fnd_api.g_false) is_ser_ctrl,
1660: DECODE(msik.lot_control_code,
1661: WIP_CONSTANTS.LOT, fnd_api.g_true,
1662: fnd_api.g_false) is_lot_ctrl,
1663: DECODE(msik.revision_qty_control_code,
1664: WIP_CONSTANTS.REV, fnd_api.g_true,
1665: fnd_api.g_false) is_rev_ctrl,

Line 1662: fnd_api.g_false) is_lot_ctrl,

1658: WIP_CONSTANTS.DYN_RCV_SN, fnd_api.g_true,
1659: fnd_api.g_false) is_ser_ctrl,
1660: DECODE(msik.lot_control_code,
1661: WIP_CONSTANTS.LOT, fnd_api.g_true,
1662: fnd_api.g_false) is_lot_ctrl,
1663: DECODE(msik.revision_qty_control_code,
1664: WIP_CONSTANTS.REV, fnd_api.g_true,
1665: fnd_api.g_false) is_rev_ctrl,
1666: DECODE(msik.revision_qty_control_code, -- revision

Line 1664: WIP_CONSTANTS.REV, fnd_api.g_true,

1660: DECODE(msik.lot_control_code,
1661: WIP_CONSTANTS.LOT, fnd_api.g_true,
1662: fnd_api.g_false) is_lot_ctrl,
1663: DECODE(msik.revision_qty_control_code,
1664: WIP_CONSTANTS.REV, fnd_api.g_true,
1665: fnd_api.g_false) is_rev_ctrl,
1666: DECODE(msik.revision_qty_control_code, -- revision
1667: WIP_CONSTANTS.REV, NVL(wrs.bom_revision,
1668: bom_revisions.get_item_revision_fn

Line 1665: fnd_api.g_false) is_rev_ctrl,

1661: WIP_CONSTANTS.LOT, fnd_api.g_true,
1662: fnd_api.g_false) is_lot_ctrl,
1663: DECODE(msik.revision_qty_control_code,
1664: WIP_CONSTANTS.REV, fnd_api.g_true,
1665: fnd_api.g_false) is_rev_ctrl,
1666: DECODE(msik.revision_qty_control_code, -- revision
1667: WIP_CONSTANTS.REV, NVL(wrs.bom_revision,
1668: bom_revisions.get_item_revision_fn
1669: ('EXCLUDE_OPEN_HOLD', -- eco_status

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

1896: p_onhand_source => inv_quantity_tree_pvt.g_all_subs,
1897: p_organization_id => l_availQty.org_id,
1898: p_inventory_item_id => l_availQty.item_id,
1899: p_tree_mode => inv_quantity_tree_pvt.g_loose_only_mode,
1900: p_is_revision_control => fnd_api.to_boolean(l_availQty.is_rev_ctrl),
1901: p_is_lot_control => fnd_api.to_boolean(l_availQty.is_lot_ctrl),
1902: p_is_serial_control => fnd_api.to_boolean(l_availQty.is_ser_ctrl),
1903: p_demand_source_type_id => 5, -- WIP
1904: p_revision => l_availQty.revision,

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

1897: p_organization_id => l_availQty.org_id,
1898: p_inventory_item_id => l_availQty.item_id,
1899: p_tree_mode => inv_quantity_tree_pvt.g_loose_only_mode,
1900: p_is_revision_control => fnd_api.to_boolean(l_availQty.is_rev_ctrl),
1901: p_is_lot_control => fnd_api.to_boolean(l_availQty.is_lot_ctrl),
1902: p_is_serial_control => fnd_api.to_boolean(l_availQty.is_ser_ctrl),
1903: p_demand_source_type_id => 5, -- WIP
1904: p_revision => l_availQty.revision,
1905: p_lot_number => l_availQty.lot,

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

1898: p_inventory_item_id => l_availQty.item_id,
1899: p_tree_mode => inv_quantity_tree_pvt.g_loose_only_mode,
1900: p_is_revision_control => fnd_api.to_boolean(l_availQty.is_rev_ctrl),
1901: p_is_lot_control => fnd_api.to_boolean(l_availQty.is_lot_ctrl),
1902: p_is_serial_control => fnd_api.to_boolean(l_availQty.is_ser_ctrl),
1903: p_demand_source_type_id => 5, -- WIP
1904: p_revision => l_availQty.revision,
1905: p_lot_number => l_availQty.lot,
1906: p_lot_expiration_date => l_availQty.txn_date,

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

1940: p_onhand_source => inv_quantity_tree_pvt.g_all_subs,
1941: p_organization_id => l_repAvailQty.org_id,
1942: p_inventory_item_id => l_repAvailQty.item_id,
1943: p_tree_mode => inv_quantity_tree_pvt.g_loose_only_mode,
1944: p_is_revision_control => fnd_api.to_boolean(l_repAvailQty.is_rev_ctrl),
1945: p_is_lot_control => fnd_api.to_boolean(l_repAvailQty.is_lot_ctrl),
1946: p_is_serial_control => fnd_api.to_boolean(l_repAvailQty.is_ser_ctrl),
1947: p_demand_source_type_id => 5, -- WIP
1948: p_revision => l_repAvailQty.revision,

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

1941: p_organization_id => l_repAvailQty.org_id,
1942: p_inventory_item_id => l_repAvailQty.item_id,
1943: p_tree_mode => inv_quantity_tree_pvt.g_loose_only_mode,
1944: p_is_revision_control => fnd_api.to_boolean(l_repAvailQty.is_rev_ctrl),
1945: p_is_lot_control => fnd_api.to_boolean(l_repAvailQty.is_lot_ctrl),
1946: p_is_serial_control => fnd_api.to_boolean(l_repAvailQty.is_ser_ctrl),
1947: p_demand_source_type_id => 5, -- WIP
1948: p_revision => l_repAvailQty.revision,
1949: p_lot_number => l_repAvailQty.lot,

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

1942: p_inventory_item_id => l_repAvailQty.item_id,
1943: p_tree_mode => inv_quantity_tree_pvt.g_loose_only_mode,
1944: p_is_revision_control => fnd_api.to_boolean(l_repAvailQty.is_rev_ctrl),
1945: p_is_lot_control => fnd_api.to_boolean(l_repAvailQty.is_lot_ctrl),
1946: p_is_serial_control => fnd_api.to_boolean(l_repAvailQty.is_ser_ctrl),
1947: p_demand_source_type_id => 5, -- WIP
1948: p_revision => l_repAvailQty.revision,
1949: p_lot_number => l_repAvailQty.lot,
1950: p_lot_expiration_date => l_repAvailQty.txn_date,

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

2971: l_logLevel NUMBER ;
2972:
2973: BEGIN
2974: l_logLevel := fnd_log.g_current_runtime_level;
2975: IF(fnd_api.to_boolean(p_initMsgList)) THEN
2976: fnd_msg_pub.initialize;
2977: END IF;
2978:
2979: -- write parameter value to log file

Line 3053: p_procReturnStatus => fnd_api.g_ret_sts_success,

3049: derive;
3050: -- write to the log file
3051: if (l_logLevel <= wip_constants.trace_logging) then
3052: wip_logger.exitPoint(p_procName => 'wip_move_validator.validate',
3053: p_procReturnStatus => fnd_api.g_ret_sts_success,
3054: p_msg => 'procedure complete',
3055: x_returnStatus => l_returnStatus);
3056: end if;
3057: EXCEPTION

Line 3061: p_procReturnStatus => fnd_api.g_ret_sts_unexp_error,

3057: EXCEPTION
3058: WHEN others THEN
3059: if (l_logLevel <= wip_constants.trace_logging) then
3060: wip_logger.exitPoint(p_procName => 'wip_move_validator.validate',
3061: p_procReturnStatus => fnd_api.g_ret_sts_unexp_error,
3062: p_msg => 'Unexpected Errors: ' || SQLERRM,
3063: x_returnStatus => l_returnStatus);
3064: end if;
3065:

Line 3385: p_procReturnStatus => fnd_api.g_ret_sts_success,

3381:
3382: -- write to the log file
3383: if (l_logLevel <= wip_constants.trace_logging) then
3384: wip_logger.exitPoint(p_procName => 'wip_move_validator.validateOATxn',
3385: p_procReturnStatus => fnd_api.g_ret_sts_success,
3386: p_msg => 'procedure complete',
3387: x_returnStatus => l_returnStatus);
3388: end if;
3389: EXCEPTION

Line 3393: p_procReturnStatus => fnd_api.g_ret_sts_unexp_error,

3389: EXCEPTION
3390: WHEN others THEN
3391: if (l_logLevel <= wip_constants.trace_logging) then
3392: wip_logger.exitPoint(p_procName => 'wip_move_validator.validateOATxn',
3393: p_procReturnStatus => fnd_api.g_ret_sts_unexp_error,
3394: p_msg => 'Unexpected Errors: ' || SQLERRM,
3395: x_returnStatus => l_returnStatus);
3396: end if;
3397: