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 WIP_TXN_INTERFACE_ERRORS

Line 56: INSERT INTO wip_txn_interface_errors(

52: n_errors := current_errors.count;
53:
54: WHILE (error_no <= n_errors) LOOP
55:
56: INSERT INTO wip_txn_interface_errors(
57: transaction_id,
58: error_message,
59: error_column,
60: last_update_date,

Line 1489: INSERT INTO wip_txn_interface_errors(

1485: fnd_message.set_name('WIP', 'WIP_NOT_VALID');
1486: fnd_message.set_token('ENTITY', 'TRANSACTION_ID');
1487: l_errMsg := substrb(fnd_message.get, 1, 240);
1488:
1489: INSERT INTO wip_txn_interface_errors(
1490: transaction_id,
1491: error_message,
1492: error_column,
1493: last_update_date,

Line 1677: -- Insert error record into WIP_TXN_INTERFACE_ERRORS. Do not update

1673: fnd_message.set_token('ENTITY2', 'zero');
1674: l_errMsg := substrb(fnd_message.get, 1, 240);
1675:
1676: -- Error out if PRIMARY_QUANTITY is zero
1677: -- Insert error record into WIP_TXN_INTERFACE_ERRORS. Do not update
1678: -- WMTI.PROCESS_STATUS to Error because it is a minor issue. We will
1679: -- continue validating other values.
1680: INSERT INTO wip_txn_interface_errors(
1681: transaction_id,

Line 1680: INSERT INTO wip_txn_interface_errors(

1676: -- Error out if PRIMARY_QUANTITY is zero
1677: -- Insert error record into WIP_TXN_INTERFACE_ERRORS. Do not update
1678: -- WMTI.PROCESS_STATUS to Error because it is a minor issue. We will
1679: -- continue validating other values.
1680: INSERT INTO wip_txn_interface_errors(
1681: transaction_id,
1682: error_message,
1683: error_column,
1684: last_update_date,

Line 1719: -- Insert error record into WIP_TXN_INTERFACE_ERRORS. Do not update

1715: fnd_message.set_token('ENTITY2', 'TRANSACTION_QUANTITY');
1716: l_errMsg := substrb(fnd_message.get, 1, 240);
1717:
1718: -- Error out if PRIMARY_QUANTITY is not consistent with TRANSACTION_QUANTITY
1719: -- Insert error record into WIP_TXN_INTERFACE_ERRORS. Do not update
1720: -- WMTI.PROCESS_STATUS to Error because it is a minor issue. We will
1721: -- continue validating other values.
1722: INSERT INTO wip_txn_interface_errors(
1723: transaction_id,

Line 1722: INSERT INTO wip_txn_interface_errors(

1718: -- Error out if PRIMARY_QUANTITY is not consistent with TRANSACTION_QUANTITY
1719: -- Insert error record into WIP_TXN_INTERFACE_ERRORS. Do not update
1720: -- WMTI.PROCESS_STATUS to Error because it is a minor issue. We will
1721: -- continue validating other values.
1722: INSERT INTO wip_txn_interface_errors(
1723: transaction_id,
1724: error_message,
1725: error_column,
1726: last_update_date,

Line 1773: INSERT INTO wip_txn_interface_errors(

1769: l_errMsg := substrb(fnd_message.get, 1, 240);
1770:
1771: -- Error out if PRIMARY_QUANTITY less than MININUM_TRANSFER_QUANTITY
1772: -- defined at FM_OPERATION_SEQ_NUM and transactions are not Scrap/Reject
1773: INSERT INTO wip_txn_interface_errors(
1774: transaction_id,
1775: error_message,
1776: error_column,
1777: last_update_date,

Line 1934: INSERT INTO wip_txn_interface_errors(

1930: l_errMsg := substrb(fnd_message.get, 1, 240);
1931:
1932: -- If caller provide PRIMARY_UOM, it must be consistent with
1933: -- primary_item_id provided
1934: INSERT INTO wip_txn_interface_errors(
1935: transaction_id,
1936: error_message,
1937: error_column,
1938: last_update_date,

Line 2006: -- Insert error record into WIP_TXN_INTERFACE_ERRORS. Do not update

2002: fnd_message.set_token('ENTITY2', 'zero');
2003: l_errMsg := substrb(fnd_message.get, 1, 240);
2004:
2005: -- Error out if OVERCOMPLETION_PRIMARY_QTY is zero
2006: -- Insert error record into WIP_TXN_INTERFACE_ERRORS. Do not update
2007: -- WMTI.PROCESS_STATUS to Error because it is a minor issue. We will
2008: -- continue validating other values.
2009: INSERT INTO wip_txn_interface_errors(
2010: transaction_id,

Line 2009: INSERT INTO wip_txn_interface_errors(

2005: -- Error out if OVERCOMPLETION_PRIMARY_QTY is zero
2006: -- Insert error record into WIP_TXN_INTERFACE_ERRORS. Do not update
2007: -- WMTI.PROCESS_STATUS to Error because it is a minor issue. We will
2008: -- continue validating other values.
2009: INSERT INTO wip_txn_interface_errors(
2010: transaction_id,
2011: error_message,
2012: error_column,
2013: last_update_date,

Line 2049: INSERT INTO wip_txn_interface_errors(

2045: l_errMsg := substrb(fnd_message.get, 1, 240);
2046:
2047: -- If caller provide this info, it must be consistent with
2048: -- overcompletion_transaction_qty provided
2049: INSERT INTO wip_txn_interface_errors(
2050: transaction_id,
2051: error_message,
2052: error_column,
2053: last_update_date,

Line 2104: INSERT INTO wip_txn_interface_errors(

2100: l_errMsg := substrb(fnd_message.get, 1, 240);
2101:
2102: -- This value must be null because New Move Processor will be the one
2103: -- who insert child record and populate this value
2104: INSERT INTO wip_txn_interface_errors(
2105: transaction_id,
2106: error_message,
2107: error_column,
2108: last_update_date,

Line 2166: INSERT INTO wip_txn_interface_errors(

2162: l_errMsg := substrb(fnd_message.get, 1, 240);
2163:
2164: -- If caller provide REASON_ID, it must be consistent with
2165: -- REASON_NAME provided
2166: INSERT INTO wip_txn_interface_errors(
2167: transaction_id,
2168: error_message,
2169: error_column,
2170: last_update_date,

Line 2219: INSERT INTO wip_txn_interface_errors(

2215: fnd_message.set_name('WIP', 'WIP_NOT_VALID');
2216: fnd_message.set_token('ENTITY', 'SCRAP_ACCOUNT_ID');
2217: l_errMsg := substrb(fnd_message.get, 1, 240);
2218:
2219: INSERT INTO wip_txn_interface_errors(
2220: transaction_id,
2221: error_message,
2222: error_column,
2223: last_update_date,

Line 2313: INSERT INTO wip_txn_interface_errors(

2309: fnd_message.set_token('ENTITY2', 'LAST_UPDATED_BY_NAME');
2310: l_errMsg := substrb(fnd_message.get, 1, 240);
2311:
2312: -- Error out if LAST_UPDATED_BY is not consistent with LAST_UPDATED_BY_NAME
2313: INSERT INTO wip_txn_interface_errors(
2314: transaction_id,
2315: error_message,
2316: error_column,
2317: last_update_date,

Line 2375: INSERT INTO wip_txn_interface_errors(

2371: fnd_message.set_token('ENTITY2', 'CREATED_BY_NAME');
2372: l_errMsg := substrb(fnd_message.get, 1, 240);
2373:
2374: -- Error out if CREATED_BY is not consistent with CREATED_BY_NAME
2375: INSERT INTO wip_txn_interface_errors(
2376: transaction_id,
2377: error_message,
2378: error_column,
2379: last_update_date,

Line 2435: INSERT INTO wip_txn_interface_errors(

2431: -- department associated to that operation does not have a location
2432: -- for PO_RECEIVE. For PO_MOVE the department associated with
2433: -- the next operation after to_op must have location. If to_op is the last op
2434: -- the department associated to that operation must have location.
2435: INSERT INTO wip_txn_interface_errors(
2436: transaction_id,
2437: error_message,
2438: error_column,
2439: last_update_date,

Line 2515: INSERT INTO wip_txn_interface_errors(

2511: fnd_message.set_name('WIP', 'WIP_VALID_EMPLOYEE');
2512: l_errMsg := substrb(fnd_message.get, 1, 240);
2513:
2514: -- Error out if the user who try to do OSP transaction is not an employee
2515: INSERT INTO wip_txn_interface_errors(
2516: transaction_id,
2517: error_message,
2518: error_column,
2519: last_update_date,

Line 2787: -- into WIP_TXN_INTERFACE_ERRORS

2783: END serial_validation;
2784:
2785: -- If there are some errors occur, this routine will set
2786: -- PROCESS_STATUS to WIP_CONSTANTS.ERROR. Then it will insert all the errors
2787: -- into WIP_TXN_INTERFACE_ERRORS
2788: PROCEDURE update_interface_tbl IS
2789: BEGIN
2790: -- there are some errors occur, so set the process_status to error so that
2791: -- move processor will not pick up this record

Line 2799: FROM wip_txn_interface_errors wtie

2795: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
2796: AND wmti.process_status = WIP_CONSTANTS.RUNNING
2797: AND EXISTS
2798: (SELECT 'X'
2799: FROM wip_txn_interface_errors wtie
2800: WHERE wtie.transaction_id = wmti.transaction_id);
2801:
2802: -- insert error message to WIP_TXN_INTERFACE_ERRORS, and clear error table
2803: load_errors;

Line 2802: -- insert error message to WIP_TXN_INTERFACE_ERRORS, and clear error table

2798: (SELECT 'X'
2799: FROM wip_txn_interface_errors wtie
2800: WHERE wtie.transaction_id = wmti.transaction_id);
2801:
2802: -- insert error message to WIP_TXN_INTERFACE_ERRORS, and clear error table
2803: load_errors;
2804: END update_interface_tbl;
2805:
2806: /* Fixed bug 5056289. Added more validation for assembly to prevent the whole

Line 2925: -- into WIP_TXN_INTERFACE_ERRORS

2921: g_group_id := p_group_id;
2922: enums.delete;
2923: -- Call last_updatd_by and created_by first even if it is a low priority
2924: -- validation because we want to insert last_updated_by and created_by
2925: -- into WIP_TXN_INTERFACE_ERRORS
2926: last_updated_by;
2927: created_by;
2928: /*****************************
2929: * Start critical validation *

Line 2978: -- validation and insert error message into WIP_TXN_INTERFACE_ERRORS

2974: /*******************************
2975: * End low priority validation *
2976: *******************************/
2977: -- set WMTI.PROCESS_STATUS to error if there is an error from any
2978: -- validation and insert error message into WIP_TXN_INTERFACE_ERRORS
2979: update_interface_tbl;
2980: -- derive the rest nessary info
2981: derive;
2982: -- write to the log file

Line 3237: -- validation and insert error message into WIP_TXN_INTERFACE_ERRORS

3233: -- Do OSP related validation.
3234: osp_validation;
3235:
3236: -- Set WMTI.PROCESS_STATUS to error if there is an error from any
3237: -- validation and insert error message into WIP_TXN_INTERFACE_ERRORS
3238: update_interface_tbl;
3239:
3240: -- Set WMTI.PROCESS_PHASE to WIP_CONSTANTS.MOVE_PROC so that move processing
3241: -- code can process these records.