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 1557: INSERT INTO wip_txn_interface_errors(

1553: fnd_message.set_name('WIP', 'WIP_NOT_VALID');
1554: fnd_message.set_token('ENTITY', 'TRANSACTION_ID');
1555: l_errMsg := substrb(fnd_message.get, 1, 240);
1556:
1557: INSERT INTO wip_txn_interface_errors(
1558: transaction_id,
1559: error_message,
1560: error_column,
1561: last_update_date,

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

1741: fnd_message.set_token('ENTITY2', 'zero');
1742: l_errMsg := substrb(fnd_message.get, 1, 240);
1743:
1744: -- Error out if PRIMARY_QUANTITY is zero
1745: -- Insert error record into WIP_TXN_INTERFACE_ERRORS. Do not update
1746: -- WMTI.PROCESS_STATUS to Error because it is a minor issue. We will
1747: -- continue validating other values.
1748: INSERT INTO wip_txn_interface_errors(
1749: transaction_id,

Line 1748: INSERT INTO wip_txn_interface_errors(

1744: -- Error out if PRIMARY_QUANTITY is zero
1745: -- Insert error record into WIP_TXN_INTERFACE_ERRORS. Do not update
1746: -- WMTI.PROCESS_STATUS to Error because it is a minor issue. We will
1747: -- continue validating other values.
1748: INSERT INTO wip_txn_interface_errors(
1749: transaction_id,
1750: error_message,
1751: error_column,
1752: last_update_date,

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

1783: fnd_message.set_token('ENTITY2', 'TRANSACTION_QUANTITY');
1784: l_errMsg := substrb(fnd_message.get, 1, 240);
1785:
1786: -- Error out if PRIMARY_QUANTITY is not consistent with TRANSACTION_QUANTITY
1787: -- Insert error record into WIP_TXN_INTERFACE_ERRORS. Do not update
1788: -- WMTI.PROCESS_STATUS to Error because it is a minor issue. We will
1789: -- continue validating other values.
1790: INSERT INTO wip_txn_interface_errors(
1791: transaction_id,

Line 1790: INSERT INTO wip_txn_interface_errors(

1786: -- Error out if PRIMARY_QUANTITY is not consistent with TRANSACTION_QUANTITY
1787: -- Insert error record into WIP_TXN_INTERFACE_ERRORS. Do not update
1788: -- WMTI.PROCESS_STATUS to Error because it is a minor issue. We will
1789: -- continue validating other values.
1790: INSERT INTO wip_txn_interface_errors(
1791: transaction_id,
1792: error_message,
1793: error_column,
1794: last_update_date,

Line 1841: INSERT INTO wip_txn_interface_errors(

1837: l_errMsg := substrb(fnd_message.get, 1, 240);
1838:
1839: -- Error out if PRIMARY_QUANTITY less than MININUM_TRANSFER_QUANTITY
1840: -- defined at FM_OPERATION_SEQ_NUM and transactions are not Scrap/Reject
1841: INSERT INTO wip_txn_interface_errors(
1842: transaction_id,
1843: error_message,
1844: error_column,
1845: last_update_date,

Line 2002: INSERT INTO wip_txn_interface_errors(

1998: l_errMsg := substrb(fnd_message.get, 1, 240);
1999:
2000: -- If caller provide PRIMARY_UOM, it must be consistent with
2001: -- primary_item_id provided
2002: INSERT INTO wip_txn_interface_errors(
2003: transaction_id,
2004: error_message,
2005: error_column,
2006: last_update_date,

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

2070: fnd_message.set_token('ENTITY2', 'zero');
2071: l_errMsg := substrb(fnd_message.get, 1, 240);
2072:
2073: -- Error out if OVERCOMPLETION_PRIMARY_QTY is zero
2074: -- Insert error record into WIP_TXN_INTERFACE_ERRORS. Do not update
2075: -- WMTI.PROCESS_STATUS to Error because it is a minor issue. We will
2076: -- continue validating other values.
2077: INSERT INTO wip_txn_interface_errors(
2078: transaction_id,

Line 2077: INSERT INTO wip_txn_interface_errors(

2073: -- Error out if OVERCOMPLETION_PRIMARY_QTY is zero
2074: -- Insert error record into WIP_TXN_INTERFACE_ERRORS. Do not update
2075: -- WMTI.PROCESS_STATUS to Error because it is a minor issue. We will
2076: -- continue validating other values.
2077: INSERT INTO wip_txn_interface_errors(
2078: transaction_id,
2079: error_message,
2080: error_column,
2081: last_update_date,

Line 2117: INSERT INTO wip_txn_interface_errors(

2113: l_errMsg := substrb(fnd_message.get, 1, 240);
2114:
2115: -- If caller provide this info, it must be consistent with
2116: -- overcompletion_transaction_qty provided
2117: INSERT INTO wip_txn_interface_errors(
2118: transaction_id,
2119: error_message,
2120: error_column,
2121: last_update_date,

Line 2172: INSERT INTO wip_txn_interface_errors(

2168: l_errMsg := substrb(fnd_message.get, 1, 240);
2169:
2170: -- This value must be null because New Move Processor will be the one
2171: -- who insert child record and populate this value
2172: INSERT INTO wip_txn_interface_errors(
2173: transaction_id,
2174: error_message,
2175: error_column,
2176: last_update_date,

Line 2234: INSERT INTO wip_txn_interface_errors(

2230: l_errMsg := substrb(fnd_message.get, 1, 240);
2231:
2232: -- If caller provide REASON_ID, it must be consistent with
2233: -- REASON_NAME provided
2234: INSERT INTO wip_txn_interface_errors(
2235: transaction_id,
2236: error_message,
2237: error_column,
2238: last_update_date,

Line 2287: INSERT INTO wip_txn_interface_errors(

2283: fnd_message.set_name('WIP', 'WIP_NOT_VALID');
2284: fnd_message.set_token('ENTITY', 'SCRAP_ACCOUNT_ID');
2285: l_errMsg := substrb(fnd_message.get, 1, 240);
2286:
2287: INSERT INTO wip_txn_interface_errors(
2288: transaction_id,
2289: error_message,
2290: error_column,
2291: last_update_date,

Line 2381: INSERT INTO wip_txn_interface_errors(

2377: fnd_message.set_token('ENTITY2', 'LAST_UPDATED_BY_NAME');
2378: l_errMsg := substrb(fnd_message.get, 1, 240);
2379:
2380: -- Error out if LAST_UPDATED_BY is not consistent with LAST_UPDATED_BY_NAME
2381: INSERT INTO wip_txn_interface_errors(
2382: transaction_id,
2383: error_message,
2384: error_column,
2385: last_update_date,

Line 2443: INSERT INTO wip_txn_interface_errors(

2439: fnd_message.set_token('ENTITY2', 'CREATED_BY_NAME');
2440: l_errMsg := substrb(fnd_message.get, 1, 240);
2441:
2442: -- Error out if CREATED_BY is not consistent with CREATED_BY_NAME
2443: INSERT INTO wip_txn_interface_errors(
2444: transaction_id,
2445: error_message,
2446: error_column,
2447: last_update_date,

Line 2503: INSERT INTO wip_txn_interface_errors(

2499: -- department associated to that operation does not have a location
2500: -- for PO_RECEIVE. For PO_MOVE the department associated with
2501: -- the next operation after to_op must have location. If to_op is the last op
2502: -- the department associated to that operation must have location.
2503: INSERT INTO wip_txn_interface_errors(
2504: transaction_id,
2505: error_message,
2506: error_column,
2507: last_update_date,

Line 2583: INSERT INTO wip_txn_interface_errors(

2579: fnd_message.set_name('WIP', 'WIP_VALID_EMPLOYEE');
2580: l_errMsg := substrb(fnd_message.get, 1, 240);
2581:
2582: -- Error out if the user who try to do OSP transaction is not an employee
2583: INSERT INTO wip_txn_interface_errors(
2584: transaction_id,
2585: error_message,
2586: error_column,
2587: last_update_date,

Line 2855: -- into WIP_TXN_INTERFACE_ERRORS

2851: END serial_validation;
2852:
2853: -- If there are some errors occur, this routine will set
2854: -- PROCESS_STATUS to WIP_CONSTANTS.ERROR. Then it will insert all the errors
2855: -- into WIP_TXN_INTERFACE_ERRORS
2856: PROCEDURE update_interface_tbl IS
2857: BEGIN
2858: -- there are some errors occur, so set the process_status to error so that
2859: -- move processor will not pick up this record

Line 2867: FROM wip_txn_interface_errors wtie

2863: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
2864: AND wmti.process_status = WIP_CONSTANTS.RUNNING
2865: AND EXISTS
2866: (SELECT 'X'
2867: FROM wip_txn_interface_errors wtie
2868: WHERE wtie.transaction_id = wmti.transaction_id);
2869:
2870: -- insert error message to WIP_TXN_INTERFACE_ERRORS, and clear error table
2871: load_errors;

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

2866: (SELECT 'X'
2867: FROM wip_txn_interface_errors wtie
2868: WHERE wtie.transaction_id = wmti.transaction_id);
2869:
2870: -- insert error message to WIP_TXN_INTERFACE_ERRORS, and clear error table
2871: load_errors;
2872: END update_interface_tbl;
2873:
2874: /* Fixed bug 5056289. Added more validation for assembly to prevent the whole

Line 2993: -- into WIP_TXN_INTERFACE_ERRORS

2989: g_group_id := p_group_id;
2990: enums.delete;
2991: -- Call last_updatd_by and created_by first even if it is a low priority
2992: -- validation because we want to insert last_updated_by and created_by
2993: -- into WIP_TXN_INTERFACE_ERRORS
2994: last_updated_by;
2995: created_by;
2996: /*****************************
2997: * Start critical validation *

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

3042: /*******************************
3043: * End low priority validation *
3044: *******************************/
3045: -- set WMTI.PROCESS_STATUS to error if there is an error from any
3046: -- validation and insert error message into WIP_TXN_INTERFACE_ERRORS
3047: update_interface_tbl;
3048: -- derive the rest nessary info
3049: derive;
3050: -- write to the log file

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

3367: -- Do OSP related validation.
3368: osp_validation;
3369:
3370: -- Set WMTI.PROCESS_STATUS to error if there is an error from any
3371: -- validation and insert error message into WIP_TXN_INTERFACE_ERRORS
3372: update_interface_tbl;
3373:
3374: -- Set WMTI.PROCESS_PHASE to WIP_CONSTANTS.MOVE_PROC so that move processing
3375: -- code can process these records.