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.INV_TXN_MANAGER_GRP dependencies on MTL_TRANSACTIONS_INTERFACE

Line 436: FROM MTL_TRANSACTIONS_INTERFACE MTI,

432: mti.transaction_batch_id,
433: mti.transaction_batch_seq,
434: mti.kanban_card_id,
435: mti.transaction_mode --J-dev
436: FROM MTL_TRANSACTIONS_INTERFACE MTI,
437: MTL_TRANSACTION_LOTS_INTERFACE MTLI,
438: MTL_SYSTEM_ITEMS_B MSI
439: WHERE mti.transaction_interface_id = p_interface_id
440: AND MTI.transaction_interface_id = mtli.transaction_interface_id

Line 454: FROM mtl_transactions_interface

450: BEGIN
451:
452: SELECT count(parent_id)
453: INTO l_count
454: FROM mtl_transactions_interface
455: WHERE parent_id = p_parent_id;
456:
457: SELECT abs(primary_quantity)
458: INTO l_split_qty

Line 459: FROM mtl_transactions_interface

455: WHERE parent_id = p_parent_id;
456:
457: SELECT abs(primary_quantity)
458: INTO l_split_qty
459: FROM mtl_transactions_interface
460: WHERE transaction_interface_id = p_parent_id;
461:
462: SELECT sum(abs(primary_quantity))
463: INTO l_partial_total_qty

Line 464: FROM mtl_transactions_interface

460: WHERE transaction_interface_id = p_parent_id;
461:
462: SELECT sum(abs(primary_quantity))
463: INTO l_partial_total_qty
464: FROM mtl_transactions_interface
465: WHERE parent_id = p_parent_id
466: AND transaction_interface_id <> p_parent_id;
467:
468: l_remaining_qty := l_split_qty - l_partial_total_qty;

Line 479: INSERT INTO mtl_transactions_interface

475: IF (l_debug = 1) THEN
476: inv_log_util.trace('insert into mmti is ' || l_mti_csr.transaction_interface_id, 'INV_TXN_MANAGER_GRP', 9);
477: END IF;
478:
479: INSERT INTO mtl_transactions_interface
480: ( transaction_header_id ,
481: transaction_interface_id ,
482: transaction_mode ,
483: lock_flag ,

Line 906: FROM MTL_TRANSACTIONS_INTERFACE

902: tmp_seg_arr(22).colvalue, tmp_seg_arr(23).colvalue, tmp_seg_arr(24).colvalue,
903: tmp_seg_arr(25).colvalue, tmp_seg_arr(26).colvalue, tmp_seg_arr(27).colvalue,
904: tmp_seg_arr(28).colvalue, tmp_seg_arr(29).colvalue, tmp_seg_arr(30).colvalue,
905: l_trxdate/*Bug#5176266*/
906: FROM MTL_TRANSACTIONS_INTERFACE
907: WHERE ROWID = p_rowid;
908:
909: l_popul := FALSE;
910: i := 0;

Line 1071: FROM mtl_transactions_interface mti

1067: l_segs1(17),
1068: l_segs1(18),
1069: l_segs1(19),
1070: l_segs1(20)
1071: FROM mtl_transactions_interface mti
1072: WHERE mti.rowid = p_rowid;
1073:
1074: -- find flex field type
1075: l_fftype := fnd_flex_key_api.find_flexfield('INV', 'MSTK');

Line 1170: FROM MTL_TRANSACTIONS_INTERFACE

1166: tmp_seg_arr(19).colvalue, tmp_seg_arr(20).colvalue, tmp_seg_arr(21).colvalue,
1167: tmp_seg_arr(22).colvalue, tmp_seg_arr(23).colvalue, tmp_seg_arr(24).colvalue,
1168: tmp_seg_arr(25).colvalue, tmp_seg_arr(26).colvalue, tmp_seg_arr(27).colvalue,
1169: tmp_seg_arr(28).colvalue, tmp_seg_arr(29).colvalue, tmp_seg_arr(30).colvalue
1170: FROM MTL_TRANSACTIONS_INTERFACE
1171: WHERE ROWID = p_rowid;
1172:
1173: SELECT CHART_OF_ACCOUNTS_ID
1174: INTO l_chart

Line 1312: UPDATE MTL_TRANSACTIONS_INTERFACE

1308: ERROR_CODE = substrb(l_error_code,1,240)
1309: WHERE ROWID = lot_rowid;
1310: END IF;
1311: IF (p_rowid IS NOT NULL) THEN
1312: UPDATE MTL_TRANSACTIONS_INTERFACE
1313: SET ERROR_CODE = substrb(l_error_code,1,240),
1314: ERROR_EXPLANATION = substrb(l_error_exp,1,240),
1315: LAST_UPDATE_DATE = sysdate,
1316: LAST_UPDATED_BY = l_userid,

Line 1351: FROM MTL_TRANSACTIONS_INTERFACE

1347: transaction_source_type_id,
1348: transaction_source_id,
1349: transaction_date, --Bug#5176266.
1350: rowid
1351: FROM MTL_TRANSACTIONS_INTERFACE
1352: WHERE transaction_header_id = p_header_id
1353: AND process_flag = 1
1354: AND (inventory_item_id is NULL OR distribution_account_id is NULL
1355: OR

Line 1358: l_itemid MTL_TRANSACTIONS_INTERFACE.INVENTORY_ITEM_ID%TYPE;

1354: AND (inventory_item_id is NULL OR distribution_account_id is NULL
1355: OR
1356: (transaction_source_id is NULL AND transaction_source_type_id in (2,3,6,8))); --Bug 2971400
1357:
1358: l_itemid MTL_TRANSACTIONS_INTERFACE.INVENTORY_ITEM_ID%TYPE;
1359: l_acctid MTL_TRANSACTIONS_INTERFACE.DISTRIBUTION_ACCOUNT_ID%TYPE;
1360: l_srctype MTL_TRANSACTIONS_INTERFACE.TRANSACTION_SOURCE_TYPE_ID%TYPE;
1361: l_trxsrc MTL_TRANSACTIONS_INTERFACE.TRANSACTION_SOURCE_ID%TYPE;
1362: l_trxdate MTL_TRANSACTIONS_INTERFACE.TRANSACTION_DATE%TYPE; --Bug#5176266.

Line 1359: l_acctid MTL_TRANSACTIONS_INTERFACE.DISTRIBUTION_ACCOUNT_ID%TYPE;

1355: OR
1356: (transaction_source_id is NULL AND transaction_source_type_id in (2,3,6,8))); --Bug 2971400
1357:
1358: l_itemid MTL_TRANSACTIONS_INTERFACE.INVENTORY_ITEM_ID%TYPE;
1359: l_acctid MTL_TRANSACTIONS_INTERFACE.DISTRIBUTION_ACCOUNT_ID%TYPE;
1360: l_srctype MTL_TRANSACTIONS_INTERFACE.TRANSACTION_SOURCE_TYPE_ID%TYPE;
1361: l_trxsrc MTL_TRANSACTIONS_INTERFACE.TRANSACTION_SOURCE_ID%TYPE;
1362: l_trxdate MTL_TRANSACTIONS_INTERFACE.TRANSACTION_DATE%TYPE; --Bug#5176266.
1363: BEGIN

Line 1360: l_srctype MTL_TRANSACTIONS_INTERFACE.TRANSACTION_SOURCE_TYPE_ID%TYPE;

1356: (transaction_source_id is NULL AND transaction_source_type_id in (2,3,6,8))); --Bug 2971400
1357:
1358: l_itemid MTL_TRANSACTIONS_INTERFACE.INVENTORY_ITEM_ID%TYPE;
1359: l_acctid MTL_TRANSACTIONS_INTERFACE.DISTRIBUTION_ACCOUNT_ID%TYPE;
1360: l_srctype MTL_TRANSACTIONS_INTERFACE.TRANSACTION_SOURCE_TYPE_ID%TYPE;
1361: l_trxsrc MTL_TRANSACTIONS_INTERFACE.TRANSACTION_SOURCE_ID%TYPE;
1362: l_trxdate MTL_TRANSACTIONS_INTERFACE.TRANSACTION_DATE%TYPE; --Bug#5176266.
1363: BEGIN
1364:

Line 1361: l_trxsrc MTL_TRANSACTIONS_INTERFACE.TRANSACTION_SOURCE_ID%TYPE;

1357:
1358: l_itemid MTL_TRANSACTIONS_INTERFACE.INVENTORY_ITEM_ID%TYPE;
1359: l_acctid MTL_TRANSACTIONS_INTERFACE.DISTRIBUTION_ACCOUNT_ID%TYPE;
1360: l_srctype MTL_TRANSACTIONS_INTERFACE.TRANSACTION_SOURCE_TYPE_ID%TYPE;
1361: l_trxsrc MTL_TRANSACTIONS_INTERFACE.TRANSACTION_SOURCE_ID%TYPE;
1362: l_trxdate MTL_TRANSACTIONS_INTERFACE.TRANSACTION_DATE%TYPE; --Bug#5176266.
1363: BEGIN
1364:
1365: FOR c_mti_row in c_mti LOOP

Line 1362: l_trxdate MTL_TRANSACTIONS_INTERFACE.TRANSACTION_DATE%TYPE; --Bug#5176266.

1358: l_itemid MTL_TRANSACTIONS_INTERFACE.INVENTORY_ITEM_ID%TYPE;
1359: l_acctid MTL_TRANSACTIONS_INTERFACE.DISTRIBUTION_ACCOUNT_ID%TYPE;
1360: l_srctype MTL_TRANSACTIONS_INTERFACE.TRANSACTION_SOURCE_TYPE_ID%TYPE;
1361: l_trxsrc MTL_TRANSACTIONS_INTERFACE.TRANSACTION_SOURCE_ID%TYPE;
1362: l_trxdate MTL_TRANSACTIONS_INTERFACE.TRANSACTION_DATE%TYPE; --Bug#5176266.
1363: BEGIN
1364:
1365: FOR c_mti_row in c_mti LOOP
1366: l_acctid := c_mti_row.distribution_account_id;

Line 1450: UPDATE MTL_TRANSACTIONS_INTERFACE

1446: END IF;
1447:
1448: END IF; */
1449:
1450: UPDATE MTL_TRANSACTIONS_INTERFACE
1451: SET inventory_item_id = l_itemid,
1452: distribution_account_id = l_acctid,
1453: transaction_source_id = l_trxsrc
1454: WHERE rowid = c_mti_row.rowid;

Line 1839: FROM MTL_TRANSACTIONS_INTERFACE

1835: TRANSACTION_QUANTITY,
1836: TRANSACTION_UOM,
1837: SECONDARY_TRANSACTION_QUANTITY,
1838: SECONDARY_UOM_CODE
1839: FROM MTL_TRANSACTIONS_INTERFACE
1840: WHERE TRANSACTION_HEADER_ID = p_header_id
1841: AND PROCESS_FLAG = 1
1842: ORDER BY ORGANIZATION_ID,INVENTORY_ITEM_ID,REVISION,
1843: SUBINVENTORY_CODE,LOCATOR_ID;

Line 1888: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

1884: | Derive transaction_action_id and transaction_source_
1885: | type_id
1886: +---------------------------------------------------------*/
1887:
1888: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
1889: SET LAST_UPDATE_DATE = SYSDATE,
1890: LAST_UPDATED_BY = p_userid,
1891: LAST_UPDATE_LOGIN = p_loginid,
1892: PROGRAM_UPDATE_DATE = SYSDATE,

Line 1914: UPDATE mtl_transactions_interface mti

1910: +-----------------------------------------------------------------+*/
1911:
1912: loaderrmsg('INV_TXN_NOT_SUPPORTED_CODE', 'INV_TXN_NOT_SUPPORTED_CODE_EXP');
1913:
1914: UPDATE mtl_transactions_interface mti
1915: SET last_update_date = SYSDATE,
1916: last_updated_by = p_userid,
1917: last_update_login = p_loginid,
1918: program_update_date = SYSDATE,

Line 1945: FROM MTL_TRANSACTIONS_INTERFACE

1941: SELECT TRANSACTION_SOURCE_TYPE_ID,
1942: DECODE(UPPER(NVL(FLOW_SCHEDULE,'N')), 'Y',1,0),
1943: NVL(SCHEDULED_FLAG,0)
1944: INTO srctypeid, tvu_flow_schedule, tev_scheduled_flag
1945: FROM MTL_TRANSACTIONS_INTERFACE
1946: WHERE TRANSACTION_HEADER_ID = p_header_id
1947: AND PROCESS_FLAG = 1
1948: AND ROWNUM < 2;
1949: EXCEPTION

Line 1983: FROM MTL_TRANSACTIONS_INTERFACE

1979: BEGIN
1980: SELECT
1981: DECODE(UPPER(NVL(FLOW_SCHEDULE,'N')), 'Y',1,0)
1982: INTO flow_schedule_children
1983: FROM MTL_TRANSACTIONS_INTERFACE
1984: WHERE TRANSACTION_HEADER_ID = p_header_id
1985: AND TRANSACTION_ACTION_ID IN (1, 27, 33, 34)
1986: AND PROCESS_FLAG = 1
1987: AND ROWNUM < 2;

Line 2018: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

2014: -- that are populated directly to the interface table
2015: --------------------------------------------------------
2016:
2017: --J-dev for Drop Ship
2018: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
2019: SET LAST_UPDATE_DATE = SYSDATE,
2020: LAST_UPDATED_BY = p_userid,
2021: LAST_UPDATE_LOGIN = p_loginid,
2022: PROGRAM_UPDATE_DATE = SYSDATE,

Line 2066: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

2062: -- but are still inserted into MTI. We should not validate them
2063: -- but will have to move them to MMTT and it will be deleted from the
2064: -- table before pushed to MMT. So, if the source type is 5 (WIP) and
2065: -- wip_supply_type is 6, we do not validate them
2066: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
2067: SET LAST_UPDATE_DATE = SYSDATE,
2068: LAST_UPDATED_BY = p_userid,
2069: LAST_UPDATE_LOGIN = p_loginid,
2070: PROGRAM_UPDATE_DATE = SYSDATE,

Line 2099: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

2095: +----------------------------------------------------*/
2096: loaderrmsg('INV_INT_ITMCODE','INV_INT_ITMEXP');
2097:
2098:
2099: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
2100: SET LAST_UPDATE_DATE = SYSDATE,
2101: LAST_UPDATED_BY = p_userid,
2102: LAST_UPDATE_LOGIN = p_loginid,
2103: PROGRAM_UPDATE_DATE = SYSDATE,

Line 2132: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

2128: | The items are validated seperately for average cost update
2129: | transactions as done in the form
2130: +----------------------------------------------------------------*/
2131:
2132: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
2133: SET LAST_UPDATE_DATE = SYSDATE,
2134: LAST_UPDATED_BY = p_userid,
2135: LAST_UPDATE_LOGIN = p_loginid,
2136: PROGRAM_UPDATE_DATE = SYSDATE,

Line 2165: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

2161: +----------------------------------------------------------------*/
2162:
2163: IF (l_validate_full) THEN--J-dev
2164: loaderrmsg('INV_POS_QTY_LAYER','INV_POS_QTY_LAYER');
2165: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
2166: SET LAST_UPDATE_DATE = SYSDATE,
2167: LAST_UPDATED_BY = p_userid,
2168: LAST_UPDATE_LOGIN = p_loginid,
2169: PROGRAM_UPDATE_DATE = SYSDATE,

Line 2197: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

2193:
2194: IF (l_validate_full) THEN--J-dev
2195: loaderrmsg('INV_INT_ITMCTRL','INV_INT_ITMECTRL');
2196:
2197: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
2198: SET LAST_UPDATE_DATE = SYSDATE,
2199: LAST_UPDATED_BY = p_userid,
2200: LAST_UPDATE_LOGIN = p_loginid,
2201: PROGRAM_UPDATE_DATE = SYSDATE,

Line 2239: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

2235:
2236: IF (l_validate_full) THEN --J-dev
2237: loaderrmsg('INV_INT_ITEMCODE','INV_INT_XFRITMEXP');
2238:
2239: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
2240: SET LAST_UPDATE_DATE = SYSDATE,
2241: LAST_UPDATED_BY = p_userid,
2242: LAST_UPDATE_LOGIN = p_loginid,
2243: PROGRAM_UPDATE_DATE = SYSDATE,

Line 2273: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

2269: +-----------------------------------------------*/
2270: loaderrmsg('INV_INT_SUBCODE','INV_INT_SUBEXP');
2271:
2272:
2273: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
2274: SET LAST_UPDATE_DATE = SYSDATE,
2275: LAST_UPDATED_BY = p_userid,
2276: LAST_UPDATE_LOGIN = p_loginid,
2277: PROGRAM_UPDATE_DATE = SYSDATE,

Line 2317: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

2313:
2314: loaderrmsg('INV_INT_XSUBCODE','INV_INT_XSUBEXP');
2315:
2316:
2317: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
2318: SET LAST_UPDATE_DATE = SYSDATE,
2319: LAST_UPDATED_BY = p_userid,
2320: LAST_UPDATE_LOGIN = p_loginid,
2321: PROGRAM_UPDATE_DATE = SYSDATE,

Line 2366: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

2362: | Validating restricted subinventories
2363: +-----------------------------------------------------------*/
2364: loaderrmsg('INV_INT_SUBCODE','INV_INT_RESUBEXP');
2365:
2366: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
2367: SET LAST_UPDATE_DATE = SYSDATE,
2368: LAST_UPDATED_BY = p_userid,
2369: LAST_UPDATE_LOGIN = p_loginid,
2370: PROGRAM_UPDATE_DATE = SYSDATE,

Line 2413: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

2409:
2410: loaderrmsg('INV_INT_XSUBCODE','INV_INT_RESXFRSUBEXP');
2411:
2412:
2413: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
2414: SET LAST_UPDATE_DATE = SYSDATE,
2415: LAST_UPDATED_BY = p_userid,
2416: LAST_UPDATE_LOGIN = p_loginid,
2417: PROGRAM_UPDATE_DATE = SYSDATE,

Line 2488: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

2484: IF exp_to_ast_allowed = 1 THEN
2485:
2486: loaderrmsg('INV_INT_SUBCODE','INV_INT_SUBTYPEXP');
2487:
2488: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
2489: SET LAST_UPDATE_DATE = SYSDATE,
2490: LAST_UPDATED_BY = p_userid,
2491: LAST_UPDATE_LOGIN = p_loginid,
2492: PROGRAM_UPDATE_DATE = SYSDATE,

Line 2522: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

2518:
2519: l_count := SQL%ROWCOUNT;
2520:
2521:
2522: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
2523: SET LAST_UPDATE_DATE = SYSDATE,
2524: LAST_UPDATED_BY = p_userid,
2525: LAST_UPDATE_LOGIN = p_loginid,
2526: PROGRAM_UPDATE_DATE = SYSDATE,

Line 2557: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

2553: AND MSI.ASSET_INVENTORY = 1);
2554:
2555: l_count := l_count + SQL%ROWCOUNT;
2556:
2557: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
2558: SET LAST_UPDATE_DATE = SYSDATE,
2559: LAST_UPDATED_BY = p_userid,
2560: LAST_UPDATE_LOGIN = p_loginid,
2561: PROGRAM_UPDATE_DATE = SYSDATE,

Line 2594: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

2590: ELSE
2591:
2592: loaderrmsg('INV_INT_SUBCODE','INV_INT_SUBTYPEXP');
2593:
2594: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
2595: SET LAST_UPDATE_DATE = SYSDATE,
2596: LAST_UPDATED_BY = p_userid,
2597: LAST_UPDATE_LOGIN = p_loginid,
2598: PROGRAM_UPDATE_DATE = SYSDATE,

Line 2633: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

2629:
2630: loaderrmsg('INV_INT_SRCCODE','INV_INT_SALEXP');
2631:
2632:
2633: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
2634: SET LAST_UPDATE_DATE = SYSDATE,
2635: LAST_UPDATED_BY = p_userid,
2636: LAST_UPDATE_LOGIN = p_loginid,
2637: PROGRAM_UPDATE_DATE = SYSDATE,

Line 2659: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

2655:
2656: /*Bug#5176266. Made changes to the below UPDATE statement
2657: to validate the Account effective date against transactions
2658: date( not sysdate)*/
2659: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
2660: SET LAST_UPDATE_DATE = SYSDATE,
2661: LAST_UPDATED_BY = p_userid,
2662: LAST_UPDATE_LOGIN = p_loginid,
2663: PROGRAM_UPDATE_DATE = SYSDATE,

Line 2689: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

2685: /* Bug# 3249130/ 3249131, Port change of Bug# 3238160. Changing the DML statement that populates the
2686: error code in MTI when the Account alias is inactive. The query now checks for the
2687: EFFECTIVE_DATE and DISABLE_DATE rather than START_DATE_ACTIVE and END_DATE_ACTIVE*/
2688:
2689: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
2690: SET LAST_UPDATE_DATE = SYSDATE,
2691: LAST_UPDATED_BY = p_userid,
2692: LAST_UPDATE_LOGIN = p_loginid,
2693: PROGRAM_UPDATE_DATE = SYSDATE,

Line 2725: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

2721: | Validating transaction type
2722: +----------------------------------------------------*/
2723: loaderrmsg('INV_INT_TRXTYPCODE','INV_INT_TYPEXP');
2724:
2725: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
2726: SET LAST_UPDATE_DATE = SYSDATE,
2727: LAST_UPDATED_BY = p_userid,
2728: LAST_UPDATE_LOGIN = p_loginid,
2729: PROGRAM_UPDATE_DATE = SYSDATE,

Line 2753: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

2749: | Validating transaction actions
2750: +-------------------------------------------------------*/
2751: loaderrmsg('INV_INT_TRXACTCODE','INV_INT_TRXACTEXP');
2752:
2753: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
2754: SET LAST_UPDATE_DATE = SYSDATE,
2755: LAST_UPDATED_BY = p_userid,
2756: LAST_UPDATE_LOGIN = p_loginid,
2757: PROGRAM_UPDATE_DATE = SYSDATE,

Line 2780: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

2776:
2777: loaderrmsg('INV_INT_ORGCODE','INV_INT_ORGEXP');
2778:
2779:
2780: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
2781: SET LAST_UPDATE_DATE = SYSDATE,
2782: LAST_UPDATED_BY = p_userid,
2783: LAST_UPDATE_LOGIN = p_loginid,
2784: PROGRAM_UPDATE_DATE = SYSDATE,

Line 2812: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

2808:
2809: loaderrmsg('INV_INT_XORGCODE','INV_INT_XORGEXP');
2810:
2811:
2812: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
2813: SET LAST_UPDATE_DATE = SYSDATE,
2814: LAST_UPDATED_BY = p_userid,
2815: LAST_UPDATE_LOGIN = p_loginid,
2816: PROGRAM_UPDATE_DATE = SYSDATE,

Line 2847: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

2843: | Validating item revisions
2844: +--------------------------------------------------*/
2845: loaderrmsg('INV_INT_REVCODE','INV_INT_REVEXP');
2846:
2847: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
2848: SET LAST_UPDATE_DATE = SYSDATE,
2849: LAST_UPDATED_BY = p_userid,
2850: LAST_UPDATE_LOGIN = p_loginid,
2851: PROGRAM_UPDATE_DATE = SYSDATE,

Line 2887: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

2883:
2884: loaderrmsg('INV_INT_REVCODE','INV_INT_REVXFREXP');
2885:
2886:
2887: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
2888: SET LAST_UPDATE_DATE = SYSDATE,
2889: LAST_UPDATED_BY = p_userid,
2890: LAST_UPDATE_LOGIN = p_loginid,
2891: PROGRAM_UPDATE_DATE = SYSDATE,

Line 2933: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

2929: | Validating transaction reasons
2930: +------------------------------------------------------*/
2931: loaderrmsg('INV_INT_REACODE','INV_INT_REAEXP');
2932:
2933: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
2934: SET LAST_UPDATE_DATE = SYSDATE,
2935: LAST_UPDATED_BY = p_userid,
2936: LAST_UPDATE_LOGIN = p_loginid,
2937: PROGRAM_UPDATE_DATE = SYSDATE,

Line 2965: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

2961:
2962: loaderrmsg('INV_INT_UOMCODE','INV_INT_UOMEXP');
2963:
2964:
2965: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
2966: SET LAST_UPDATE_DATE = SYSDATE,
2967: LAST_UPDATED_BY = p_userid,
2968: LAST_UPDATE_LOGIN = p_loginid,
2969: PROGRAM_UPDATE_DATE = SYSDATE,

Line 2995: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

2991: +------------------------------------------------------*/
2992:
2993: loaderrmsg('INV_INT_QTYCODE','INV_INT_QTYSGNEXP');
2994:
2995: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
2996: SET LAST_UPDATE_DATE = SYSDATE,
2997: LAST_UPDATED_BY = p_userid,
2998: LAST_UPDATE_LOGIN = p_loginid,
2999: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3011: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3007: AND TRANSACTION_ACTION_ID IN (1,21,32,34);
3008:
3009: l_count := SQL%ROWCOUNT;
3010:
3011: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3012: SET LAST_UPDATE_DATE = SYSDATE,
3013: LAST_UPDATED_BY = p_userid,
3014: LAST_UPDATE_LOGIN = p_loginid,
3015: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3092: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3088: IF (l_debug = 1) THEN
3089: inv_log_util.trace('validate_quantities IN (validate_group) - PASSED ' , 'INV_TXN_MANAGER_GRP', 9);
3090: END IF;
3091:
3092: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3093: SET TRANSACTION_QUANTITY = l_transaction_quantity,
3094: SECONDARY_TRANSACTION_QUANTITY = l_secondary_quantity,
3095: SECONDARY_UOM_CODE = l_secondary_uom_code
3096: WHERE ROWID = l_rowid;

Line 3120: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3116: errupdate(l_rowid, NULL);
3117: END IF;
3118: --Set the default UOM2 if missing
3119: IF (l_secondary_uom_code IS NULL) THEN
3120: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3121: SET SECONDARY_UOM_CODE = l_item_secondary_uom_code
3122: WHERE ROWID = l_rowid;
3123: END IF;
3124: END IF;--} -- Lot ctl check

Line 3127: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3123: END IF;
3124: END IF;--} -- Lot ctl check
3125: ELSE
3126: --tracking is primary. no need for sec uom/qty
3127: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3128: SET SECONDARY_TRANSACTION_QUANTITY = NULL,
3129: SECONDARY_UOM_CODE = NULL
3130: WHERE ROWID = l_rowid;
3131: END IF;--}

Line 3154: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3150: FND_MESSAGE.set_name('INV', 'INV_GREATER_THAN');
3151: l_error_code := FND_MESSAGE.get;
3152:
3153:
3154: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3155: SET LAST_UPDATE_DATE = SYSDATE,
3156: LAST_UPDATED_BY = p_userid,
3157: LAST_UPDATE_LOGIN = p_loginid,
3158: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3180: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3176: l_error_code := FND_MESSAGE.get;
3177:
3178:
3179:
3180: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3181: SET LAST_UPDATE_DATE = SYSDATE,
3182: LAST_UPDATED_BY = p_userid,
3183: LAST_UPDATE_LOGIN = p_loginid,
3184: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3212: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3208: /*Bug#5176266. Made changes to the below UPDATE statement
3209: to validate the Account effective date against transactions
3210: date( not sysdate)*/
3211:
3212: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3213: SET LAST_UPDATE_DATE = SYSDATE,
3214: LAST_UPDATED_BY = p_userid,
3215: LAST_UPDATE_LOGIN = p_loginid,
3216: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3239: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3235:
3236: l_count := SQL%ROWCOUNT;
3237:
3238:
3239: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3240: SET LAST_UPDATE_DATE = SYSDATE,
3241: LAST_UPDATED_BY = p_userid,
3242: LAST_UPDATE_LOGIN = p_loginid,
3243: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3288: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3284:
3285: loaderrmsg('INV_INT_FRTCODE','INV_INT_FRTEXP');
3286:
3287:
3288: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3289: SET LAST_UPDATE_DATE = SYSDATE,
3290: LAST_UPDATED_BY = p_userid,
3291: LAST_UPDATE_LOGIN = p_loginid,
3292: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3312: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3308: l_count := SQL%ROWCOUNT;
3309: loaderrmsg('INV_INT_FRTACTCODE','INV_INT_FRTACTEXP');
3310:
3311:
3312: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3313: SET LAST_UPDATE_DATE = SYSDATE,
3314: LAST_UPDATED_BY = p_userid,
3315: LAST_UPDATE_LOGIN = p_loginid,
3316: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3352: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3348:
3349:
3350: IF srctypeid = 5 THEN
3351:
3352: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3353: SET LAST_UPDATE_DATE = SYSDATE,
3354: LAST_UPDATED_BY = p_userid,
3355: LAST_UPDATE_LOGIN = p_loginid,
3356: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3391: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3387:
3388: IF (srctypeid = 5 AND wip_constants.dmf_patchset_level< wip_constants.DMF_PATCHSET_J_VALUE) THEN --J-dev
3389: loaderrmsg('INV_INT_SRCCODE','INV_INT_SRCCFMEXP');
3390: IF srctypeid = 5 THEN
3391: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3392: SET LAST_UPDATE_DATE = SYSDATE,
3393: LAST_UPDATED_BY = p_userid,
3394: LAST_UPDATE_LOGIN = p_loginid,
3395: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3427: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3423: IF (l_validate_full) THEN --J-dev
3424:
3425: loaderrmsg('INV_PROJCON_ERR','INV_PROJCON_ERR');
3426:
3427: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3428: SET LAST_UPDATE_DATE = SYSDATE,
3429: LAST_UPDATED_BY = p_userid,
3430: LAST_UPDATE_LOGIN = p_loginid,
3431: PROCESS_FLAG = 3,

Line 3454: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3450: /* validate source task id */
3451: loaderrmsg('INV_TASK_ERR','INV_TASK_ERR');
3452:
3453:
3454: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3455: SET LAST_UPDATE_DATE = SYSDATE,
3456: LAST_UPDATED_BY = p_userid,
3457: LAST_UPDATE_LOGIN = p_loginid,
3458: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3509: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3505:
3506: loaderrmsg('INV_ETYPE_ERR','INV_ETYPE_ERR');
3507: IF exp_type_required = 2 THEN
3508:
3509: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3510: SET LAST_UPDATE_DATE = SYSDATE,
3511: LAST_UPDATED_BY = p_userid,
3512: LAST_UPDATE_LOGIN = p_loginid,
3513: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3543: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3539:
3540: l_count := l_count + SQL%ROWCOUNT;
3541:
3542: ELSE
3543: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3544: SET LAST_UPDATE_DATE = SYSDATE,
3545: LAST_UPDATED_BY = p_userid,
3546: LAST_UPDATE_LOGIN = p_loginid,
3547: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3576: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3572: | enabled in terms of date |
3573: +--------------------------------------------------------------+*/
3574: loaderrmsg('INV_INT_CSTGRP','INV_INT_CSTEXP');
3575:
3576: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3577: SET LAST_UPDATE_DATE = SYSDATE,
3578: LAST_UPDATED_BY = p_userid,
3579: LAST_UPDATE_LOGIN = p_loginid,
3580: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3612: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3608: | enabled in terms of date |
3609: +-----------------------------------------------------------------------+*/
3610: loaderrmsg('INV_INT_XCSTGRP','INV_INT_XCSTEXP');
3611:
3612: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3613: SET LAST_UPDATE_DATE = SYSDATE,
3614: LAST_UPDATED_BY = p_userid,
3615: LAST_UPDATE_LOGIN = p_loginid,
3616: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3651: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3647: 'using_organization_code' is set to -1 in the table, 'po_asl_attributes' if
3648: the global flag is set to 'Yes' in the ASL for an (item, supplier)
3649: combination*/
3650:
3651: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3652: SET LAST_UPDATE_DATE = SYSDATE,
3653: LAST_UPDATED_BY = p_userid,
3654: LAST_UPDATE_LOGIN = p_loginid,
3655: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3681: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3677:
3678: --if the planning _org is a inventory org it should be in
3679: --mtl_parameters.
3680:
3681: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3682: SET LAST_UPDATE_DATE = SYSDATE,
3683: LAST_UPDATED_BY = p_userid,
3684: LAST_UPDATE_LOGIN = p_loginid,
3685: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3715: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3711:
3712: loaderrmsg('INV_INT_LPN','INV_INT_LPN');
3713:
3714:
3715: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3716: SET LAST_UPDATE_DATE = SYSDATE,
3717: LAST_UPDATED_BY = p_userid,
3718: LAST_UPDATE_LOGIN = p_loginid,
3719: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3741: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3737: END IF;
3738:
3739: --Validate Xfr LPN
3740:
3741: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3742: SET LAST_UPDATE_DATE = SYSDATE,
3743: LAST_UPDATED_BY = p_userid,
3744: LAST_UPDATE_LOGIN = p_loginid,
3745: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3768: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3764:
3765:
3766: --Validate Content LPN
3767:
3768: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3769: SET LAST_UPDATE_DATE = SYSDATE,
3770: LAST_UPDATED_BY = p_userid,
3771: LAST_UPDATE_LOGIN = p_loginid,
3772: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3803: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3799:
3800: IF (srctypeid = INV_GLOBALS.G_SourceType_SalesOrder OR
3801: srctypeid = INV_GLOBALS.G_SourceType_IntOrder OR
3802: srctypeid = INV_GLOBALS.G_SourceType_PrjContracts) THEN
3803: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3804: SET LAST_UPDATE_DATE = SYSDATE,
3805: LAST_UPDATED_BY = p_userid,
3806: LAST_UPDATE_LOGIN = p_loginid,
3807: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3831: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3827:
3828: IF (srctypeid = 5 AND wip_constants.dmf_patchset_level< wip_constants.DMF_PATCHSET_J_VALUE) THEN --J-dev
3829:
3830: IF (srctypeid = 5) THEN
3831: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3832: SET LAST_UPDATE_DATE = SYSDATE,
3833: LAST_UPDATED_BY = p_userid,
3834: LAST_UPDATE_LOGIN = p_loginid,
3835: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3856: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3852: /*-------------------------------------------------------------+
3853: | Update MTI with right op seq num for non-CFMs
3854: +--------------------------------------------------------------*/
3855:
3856: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3857: SET LAST_UPDATE_DATE = SYSDATE,
3858: LAST_UPDATED_BY = p_userid,
3859: LAST_UPDATE_LOGIN = p_loginid,
3860: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3881: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3877: +--------------------------------------------------------------*/
3878:
3879: loaderrmsg('INV_GROUP_ERROR','INV_GROUP_ERROR');
3880:
3881: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3882: SET LAST_UPDATE_DATE = SYSDATE,
3883: LAST_UPDATED_BY = p_userid,
3884: LAST_UPDATE_LOGIN = p_loginid,
3885: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3893: FROM MTL_TRANSACTIONS_INTERFACE MTI2

3889: WHERE TRANSACTION_HEADER_ID = p_header_id
3890: AND PROCESS_FLAG = 1
3891: AND TRANSACTION_BATCH_ID IN
3892: (SELECT DISTINCT MTI2.TRANSACTION_BATCH_ID
3893: FROM MTL_TRANSACTIONS_INTERFACE MTI2
3894: WHERE MTI2.TRANSACTION_HEADER_ID = p_header_id
3895: AND MTI2.PROCESS_FLAG = 3
3896: AND MTI2.ERROR_CODE IS NOT NULL);
3897:

Line 3914: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3910:
3911: /* Bug# 5264549 : made changes to the REBUILD_ITEM_ID query to
3912: update EAM validations from Transaction Manager */
3913:
3914: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3915: SET LAST_UPDATE_DATE = SYSDATE,
3916: LAST_UPDATED_BY = p_userid,
3917: LAST_UPDATE_LOGIN = p_loginid,
3918: PROGRAM_UPDATE_DATE = SYSDATE,

Line 4067: FROM MTL_TRANSACTIONS_INTERFACE

4063:
4064: -- nsinghi bug 5209065. Added the cursor.
4065: CURSOR cur_get_interface_id IS
4066: SELECT transaction_interface_id
4067: FROM MTL_TRANSACTIONS_INTERFACE
4068: WHERE ROWID = p_rowid;
4069:
4070: l_item_copy_lot_attribute_flag VARCHAR2(1);
4071: l_org_copy_lot_attribute_flag VARCHAR2(1);

Line 4156: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

4152: --WHENEVER NOT FOUND CONTINUE;
4153:
4154: loaderrmsg('INV_INT_LOTCODE','INV_INT_LOTEXP');
4155:
4156: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
4157: SET LAST_UPDATE_DATE = SYSDATE,
4158: LAST_UPDATED_BY = l_userid,
4159: LAST_UPDATE_LOGIN = l_loginid,
4160: PROGRAM_UPDATE_DATE = SYSDATE,

Line 4199: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

4195: IF SQL%FOUND THEN
4196: FND_MESSAGE.set_name('INV','INV_INT_LOTUNIQEXP');
4197: l_error_exp := FND_MESSAGE.get;
4198:
4199: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
4200: SET LAST_UPDATE_DATE = SYSDATE,
4201: LAST_UPDATED_BY = l_userid,
4202: LAST_UPDATE_LOGIN = l_loginid,
4203: PROGRAM_UPDATE_DATE = SYSDATE,

Line 4494: UPDATE MTL_TRANSACTIONS_INTERFACE

4490: REQUEST_ID = l_reqstid,
4491: ERROR_CODE = substrb(l_error_code,1,240)
4492: WHERE ROWID = l_lotrowid;
4493:
4494: UPDATE MTL_TRANSACTIONS_INTERFACE
4495: SET ERROR_CODE = substrb(l_error_code,1,240),
4496: ERROR_EXPLANATION = substrb(l_error_exp,1,240),
4497: LAST_UPDATE_DATE = sysdate,
4498: LAST_UPDATED_BY = l_userid,

Line 4545: UPDATE MTL_TRANSACTIONS_INTERFACE

4541: REQUEST_ID = l_reqstid,
4542: ERROR_CODE = substrb(l_error_code,1,240)
4543: WHERE ROWID = l_lotrowid;
4544:
4545: UPDATE MTL_TRANSACTIONS_INTERFACE
4546: SET ERROR_CODE = substrb(l_error_code,1,240),
4547: ERROR_EXPLANATION = substrb(l_error_exp,1,240),
4548: LAST_UPDATE_DATE = sysdate,
4549: LAST_UPDATED_BY = l_userid,

Line 4598: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

4594: REQUEST_ID = l_reqstid,
4595: ERROR_CODE = substrb(l_error_code,1,240)
4596: WHERE ROWID = l_lotrowid;
4597:
4598: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
4599: SET LAST_UPDATE_DATE = SYSDATE,
4600: LAST_UPDATED_BY = l_userid,
4601: LAST_UPDATE_LOGIN = l_loginid,
4602: PROGRAM_UPDATE_DATE = SYSDATE,

Line 4643: UPDATE MTL_TRANSACTIONS_INTERFACE

4639: WHEN OTHERS THEN
4640: FND_MESSAGE.set_name('INV','INV_INT_UOMCONVCODE');
4641:
4642: --WHENEVER SQL ERROR CONTINUE;
4643: UPDATE MTL_TRANSACTIONS_INTERFACE
4644: SET LAST_UPDATE_DATE = SYSDATE,
4645: LAST_UPDATED_BY = l_userid,
4646: LAST_UPDATE_LOGIN = l_loginid,
4647: PROGRAM_UPDATE_DATE = SYSDATE,

Line 4889: FROM mtl_transactions_interface mti

4885: l_segs1(17),
4886: l_segs1(18),
4887: l_segs1(19),
4888: l_segs1(20)
4889: FROM mtl_transactions_interface mti
4890: WHERE mti.rowid = p_rowid;
4891:
4892: return getloc(x_locid, p_org_id, p_locctrl, l_segs1);
4893:

Line 4967: FROM mtl_transactions_interface mti

4963: l_segs1(17),
4964: l_segs1(18),
4965: l_segs1(19),
4966: l_segs1(20)
4967: FROM mtl_transactions_interface mti
4968: WHERE mti.rowid = p_rowid;
4969:
4970: return getloc(x_locid, p_org_id, p_locctrl, l_segs1);
4971:

Line 5049: FROM mtl_transactions_interface mti

5045: l_segs1(20)
5046:
5047:
5048:
5049: FROM mtl_transactions_interface mti
5050: WHERE mti.rowid = p_rowid;
5051:
5052: return getloc(x_locid, p_org_id, p_locctrl, l_segs1);
5053:

Line 5132: FROM mtl_transactions_interface mti

5128: l_segs1(19),
5129: l_segs1(20)
5130:
5131:
5132: FROM mtl_transactions_interface mti
5133: WHERE mti.rowid = p_rowid;
5134:
5135: return getloc(x_locid, p_org_id, p_locctrl, l_segs1);
5136:

Line 5339: RETURN mtl_transactions_interface.cost_group_id%TYPE IS

5335: * Added for Bug 6356567
5336: ******************************************************************/
5337:
5338: FUNCTION get_costgrpid(p_org_id in NUMBER, p_subinv in VARCHAR2, p_locatorid in NUMBER)
5339: RETURN mtl_transactions_interface.cost_group_id%TYPE IS
5340: l_cost_group_id number;
5341: l_org_cost_group_id number;
5342: l_primary_cost_method mtl_parameters.primary_cost_method%TYPE;
5343: l_project_enabled NUMBER;

Line 6078: FROM MTL_TRANSACTIONS_INTERFACE

6074: ,wip_entity_type -- Pawan 11th july added
6075: /*Bug:5392366. Added the following two columns. */
6076: ,completion_transaction_id
6077: ,move_transaction_id
6078: FROM MTL_TRANSACTIONS_INTERFACE
6079: WHERE TRANSACTION_HEADER_ID = p_header_id
6080: AND PROCESS_FLAG = 1
6081: ORDER BY ORGANIZATION_ID,INVENTORY_ITEM_ID,REVISION,
6082: SUBINVENTORY_CODE,LOCATOR_ID;

Line 6132: * Validate one transaction record in MTL_TRANSACTIONS_INTERFACE

6128:
6129: /******************************************************************
6130: *
6131: * validate_lines()
6132: * Validate one transaction record in MTL_TRANSACTIONS_INTERFACE
6133: *
6134: ******************************************************************/
6135: PROCEDURE validate_lines(p_line_Rec_Type inv_txn_manager_pub.line_rec_type,
6136: p_commit VARCHAR2 := fnd_api.g_false ,

Line 6408: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

6404: inv_log_util.trace('#$l_rowid '||l_rowid, 'INV_TXN_MANAGER_GRP', 9);
6405: END IF;
6406:
6407:
6408: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
6409: SET LAST_UPDATE_DATE = SYSDATE,
6410: LAST_UPDATED_BY = p_userid,
6411: LAST_UPDATE_LOGIN = p_loginid,
6412: PROGRAM_UPDATE_DATE = SYSDATE,

Line 6465: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

6461: /* validate expenditure org id */
6462:
6463: loaderrmsg('INV_PAORG_ERR','INV_PAORG_ERR');
6464:
6465: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
6466: SET LAST_UPDATE_DATE = SYSDATE,
6467: LAST_UPDATED_BY = p_userid,
6468: LAST_UPDATE_LOGIN = p_loginid,
6469: PROGRAM_UPDATE_DATE = SYSDATE,

Line 6737: FROM MTL_TRANSACTIONS_INTERFACE

6733: IF l_srctype = 5 THEN
6734: BEGIN
6735: SELECT DECODE(UPPER(NVL(FLOW_SCHEDULE,'N')), 'Y', 1, 0), NVL(SCHEDULED_FLAG, 0)
6736: INTO tev_flow_schedule, tev_scheduled_flag
6737: FROM MTL_TRANSACTIONS_INTERFACE
6738: WHERE ROWID = l_rowid;
6739: EXCEPTION
6740: WHEN NO_DATA_FOUND THEN
6741: tev_flow_schedule := 0;

Line 7166: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

7162: fnd_message.set_name('INV', 'INV_INT_ACCEXP');
7163: fnd_message.set_token('ACCOUNT',l_account);
7164: l_error_exp := fnd_message.get;
7165:
7166: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
7167: SET LAST_UPDATE_DATE = SYSDATE,
7168: LAST_UPDATED_BY = p_userid,
7169: LAST_UPDATE_LOGIN = p_loginid,
7170: PROGRAM_UPDATE_DATE = SYSDATE,

Line 7214: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

7210: fnd_message.set_name('INV', 'INV_INT_ACCEXP');
7211: fnd_message.set_token('ACCOUNT',l_account);
7212: l_error_exp := fnd_message.get;
7213:
7214: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
7215: SET LAST_UPDATE_DATE = SYSDATE,
7216: LAST_UPDATED_BY = p_userid,
7217: LAST_UPDATE_LOGIN = p_loginid,
7218: PROGRAM_UPDATE_DATE = SYSDATE,

Line 7261: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

7257: fnd_message.set_name('INV', 'INV_INT_ACCEXP');
7258: fnd_message.set_token('ACCOUNT',l_account);
7259: l_error_exp := fnd_message.get;
7260:
7261: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
7262: SET LAST_UPDATE_DATE = SYSDATE,
7263: LAST_UPDATED_BY = p_userid,
7264: LAST_UPDATE_LOGIN = p_loginid,
7265: PROGRAM_UPDATE_DATE = SYSDATE,

Line 7308: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

7304: fnd_message.set_name('INV', 'INV_INT_ACCEXP');
7305: fnd_message.set_token('ACCOUNT',l_account);
7306: l_error_exp := fnd_message.get;
7307:
7308: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
7309: SET LAST_UPDATE_DATE = SYSDATE,
7310: LAST_UPDATED_BY = p_userid,
7311: LAST_UPDATE_LOGIN = p_loginid,
7312: PROGRAM_UPDATE_DATE = SYSDATE,

Line 7355: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

7351: fnd_message.set_name('INV', 'INV_INT_ACCEXP');
7352: fnd_message.set_token('ACCOUNT',l_account);
7353: l_error_exp := fnd_message.get;
7354:
7355: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
7356: SET LAST_UPDATE_DATE = SYSDATE,
7357: LAST_UPDATED_BY = p_userid,
7358: LAST_UPDATE_LOGIN = p_loginid,
7359: PROGRAM_UPDATE_DATE = SYSDATE,

Line 7419: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

7415: fnd_message.set_name('INV', 'INV_INT_ACCEXP');
7416: fnd_message.set_token('ACCOUNT',l_account);
7417: l_error_exp := fnd_message.get;
7418:
7419: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
7420: SET LAST_UPDATE_DATE = SYSDATE,
7421: LAST_UPDATED_BY = p_userid,
7422: LAST_UPDATE_LOGIN = p_loginid,
7423: PROGRAM_UPDATE_DATE = SYSDATE,

Line 7454: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

7450: loaderrmsg('INV_GREATER_THAN_ZERO','INV_GREATER_THAN_ZERO');
7451:
7452: /* We need to check if the quantity passed is zero when a Material Expense account is passed - LCM changes */
7453: IF (l_validate_full) THEN --J-dev
7454: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
7455: SET LAST_UPDATE_DATE = SYSDATE,
7456: LAST_UPDATED_BY = p_userid,
7457: LAST_UPDATE_LOGIN = p_loginid,
7458: PROGRAM_UPDATE_DATE = SYSDATE,

Line 7931: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

7927: l_count := l_count + 1;
7928: END;
7929: END IF;
7930:
7931: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
7932: SET LAST_UPDATE_DATE = SYSDATE,
7933: LAST_UPDATED_BY = p_userid,
7934: LAST_UPDATE_LOGIN = p_loginid,
7935: PROGRAM_UPDATE_DATE = SYSDATE,

Line 7965: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

7961: | Validating locators
7962: +-------------------------------------------------------------*/
7963: loaderrmsg('INV_INT_LOCCODE','INV_INT_LOCEXP');
7964:
7965: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
7966: SET LAST_UPDATE_DATE = SYSDATE,
7967: LAST_UPDATED_BY = p_userid,
7968: LAST_UPDATE_LOGIN = p_loginid,
7969: PROGRAM_UPDATE_DATE = SYSDATE,

Line 7989: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

7985:
7986:
7987: loaderrmsg('INV_INT_LOCCODE','INV_INT_RESLOCEXP');
7988:
7989: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
7990: SET LAST_UPDATE_DATE = SYSDATE,
7991: LAST_UPDATED_BY = p_userid,
7992: LAST_UPDATE_LOGIN = p_loginid,
7993: PROGRAM_UPDATE_DATE = SYSDATE,

Line 8032: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

8028: +-----------------------------------------------------------*/
8029:
8030: loaderrmsg('INV_INT_XLOCCODE','INV_INT_XFRLOCEXP');
8031:
8032: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
8033: SET LAST_UPDATE_DATE = SYSDATE,
8034: LAST_UPDATED_BY = p_userid,
8035: LAST_UPDATE_LOGIN = p_loginid,
8036: PROGRAM_UPDATE_DATE = SYSDATE,

Line 8062: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

8058: | Validating transfer locators for restricted list
8059: +------------------------------------------------------*/
8060: loaderrmsg('INV_INT_XLOCCODE','INV_INT_RESXFRLOCEXP');
8061:
8062: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
8063: SET LAST_UPDATE_DATE = SYSDATE,
8064: LAST_UPDATED_BY = p_userid,
8065: LAST_UPDATE_LOGIN = p_loginid,
8066: PROGRAM_UPDATE_DATE = SYSDATE,

Line 8263: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

8259: IF (l_debug = 1) THEN
8260: inv_log_util.trace('Updating MTI with transfer price: ' || l_transfer_price_priuom, 'INV_TXN_MANAGER_GRP','1');
8261: END IF;
8262:
8263: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
8264: SET LAST_UPDATE_DATE = SYSDATE,
8265: LAST_UPDATED_BY = p_userid,
8266: LAST_UPDATE_LOGIN = p_loginid,
8267: transfer_price = l_transfer_price_priuom

Line 8303: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

8299: IF (l_lotctrl=2 AND p_line_Rec_Type.secondary_uom_code IS NOT NULL) THEN
8300: IF (l_debug = 1) THEN
8301: inv_log_util.trace('update secondary quantity on line as sum of lot level secondary quantities', 'INV_TXN_MANAGER_GRP', 9);
8302: END IF;
8303: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
8304: SET secondary_transaction_quantity = (SELECT SUM(SECONDARY_TRANSACTION_QUANTITY)
8305: FROM MTL_TRANSACTION_LOTS_INTERFACE MTLI
8306: WHERE MTLI.TRANSACTION_INTERFACE_ID = p_line_Rec_Type.TRANSACTION_INTERFACE_ID)
8307: WHERE ROWID = l_rowid;

Line 8317: FROM MTL_TRANSACTIONS_INTERFACE

8313: +--------------------------------------------------------------*/
8314:
8315: SELECT cost_group_id, transfer_cost_group_id
8316: INTO l_cost_group_id, l_xfer_cost_group_id
8317: FROM MTL_TRANSACTIONS_INTERFACE
8318: WHERE ROWID = l_rowid
8319: AND PROCESS_FLAG = 1;
8320:
8321: IF l_cost_group_id is not null and l_acttype not in (5,6,24,30,50,51,52) THEN -- Modified 7025628

Line 8325: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

8321: IF l_cost_group_id is not null and l_acttype not in (5,6,24,30,50,51,52) THEN -- Modified 7025628
8322: l_temp_cost_group_id := get_costgrpid(l_orgid, l_subinv, l_locid);
8323: loaderrmsg('INV_INT_CSTGRP','INV_INT_CSTEXP');
8324:
8325: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
8326: SET LAST_UPDATE_DATE = SYSDATE,
8327: LAST_UPDATED_BY = p_userid,
8328: LAST_UPDATE_LOGIN = p_loginid,
8329: PROGRAM_UPDATE_DATE = SYSDATE,

Line 8359: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

8355:
8356: l_temp_xfer_cost_group_id := get_costgrpid(l_cg_org, l_xsubinv, l_xlocid);
8357: loaderrmsg('INV_INT_XCSTGRP','INV_INT_XCSTEXP');
8358:
8359: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
8360: SET LAST_UPDATE_DATE = SYSDATE,
8361: LAST_UPDATED_BY = p_userid,
8362: LAST_UPDATE_LOGIN = p_loginid,
8363: PROGRAM_UPDATE_DATE = SYSDATE,

Line 8397: UPDATE MTL_TRANSACTIONS_INTERFACE

8393: inv_log_util.trace('Error in validate_line : ' || l_error_exp, 'INV_TXN_MANAGER_GRP','1');
8394: inv_log_util.trace('Error:'||substr(sqlerrm,1,250),'INV_TXN_MANAGER_GRP',1);
8395: END IF;
8396:
8397: UPDATE MTL_TRANSACTIONS_INTERFACE
8398: SET LAST_UPDATE_DATE = SYSDATE,
8399: LAST_UPDATED_BY = p_userid,
8400: LAST_UPDATE_LOGIN = p_loginid,
8401: PROGRAM_UPDATE_DATE = SYSDATE,

Line 8533: FROM mtl_transactions_interface

8529: SELECT 1
8530: INTO l_count
8531: FROM DUAL
8532: WHERE EXISTS (SELECT transaction_interface_id
8533: FROM mtl_transactions_interface
8534: WHERE transaction_header_id = p_header_id
8535: AND process_flag = 1
8536: AND transaction_type_id NOT IN
8537: (inv_globals.g_type_inv_lot_split

Line 8895: FROM MTL_TRANSACTIONS_INTERFACE

8891: SECONDARY_UOM_CODE, -- INVCONV fabdi end
8892: RELIEVE_RESERVATIONS_FLAG, /*** {{ R12 Enhanced reservations code changes ***/
8893: RELIEVE_HIGH_LEVEL_RSV_FLAG, /*** {{ R12 Enhanced reservations code changes ***/
8894: TRANSFER_PRICE -- INVCONV umoogala For Process-Discrete Transfer Enh.
8895: FROM MTL_TRANSACTIONS_INTERFACE
8896: --WHERE ROWID = p_rowid--J-dev
8897: WHERE transaction_header_id = p_header_id
8898: AND PROCESS_FLAG = 1
8899: AND transaction_type_id NOT IN /*OSFM Support for Lot Serialized Items*/

Line 9241: FROM MTL_TRANSACTIONS_INTERFACE MTI,

9237: mti.SECONDARY_UOM_CODE, -- INVCONV fabdi
9238: mti.RELIEVE_RESERVATIONS_FLAG, /*** {{ R12 Enhanced reservations code changes ***/
9239: mti.RELIEVE_HIGH_LEVEL_RSV_FLAG, /*** {{ R12 Enhanced reservations code changes ***/
9240: mti.TRANSFER_PRICE -- INVCONV umoogala For Process-Discrete Transfer Enh.
9241: FROM MTL_TRANSACTIONS_INTERFACE MTI,
9242: BOM_BILL_OF_MATERIALS BOM,
9243: BOM_OPERATIONAL_ROUTINGS BOR
9244: WHERE TRANSACTION_HEADER_ID = p_header_id
9245: /*WHERE MTI.ROWID = p_rowid*/--J-dev

Line 9595: FROM MTL_TRANSACTIONS_INTERFACE MTI

9591: mti.SECONDARY_UOM_CODE, -- INVCONV fabdi end
9592: mti.RELIEVE_RESERVATIONS_FLAG, /*** {{ R12 Enhanced reservations code changes ***/
9593: mti.RELIEVE_HIGH_LEVEL_RSV_FLAG, /*** {{ R12 Enhanced reservations code changes ***/
9594: mti.TRANSFER_PRICE -- INVCONV umoogala For Process-Discrete Transfer Enh.
9595: FROM MTL_TRANSACTIONS_INTERFACE MTI
9596: WHERE MTI.TRANSACTION_HEADER_ID = p_header_id
9597: and MTI.PROCESS_FLAG = 1
9598: and MTI.TRANSACTION_ACTION_ID IN (1, 27, 33, 34) ;
9599:

Line 9919: FROM MTL_TRANSACTIONS_INTERFACE MTI,

9915: mti.SECONDARY_UOM_CODE, -- INVCONV fabdi end
9916: mti.RELIEVE_RESERVATIONS_FLAG, /*** {{ R12 Enhanced reservations code changes ***/
9917: mti.RELIEVE_HIGH_LEVEL_RSV_FLAG, /*** {{ R12 Enhanced reservations code changes ***/
9918: mti.TRANSFER_PRICE -- INVCONV umoogala For Process-Discrete Transfer Enh.
9919: FROM MTL_TRANSACTIONS_INTERFACE MTI,
9920: MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
9921: WHERE MTI.TRANSACTION_HEADER_ID = p_header_id
9922: /* WHERE MTI.ROWID = p_rowid J-dev*/
9923: and MTI.PROCESS_FLAG = 1

Line 10171: FROM MTL_TRANSACTIONS_INTERFACE MTI

10167: parent_object_number2 --R12 Genealogy enhancements
10168: FROM MTL_TRANSACTION_LOTS_INTERFACE
10169: WHERE TRANSACTION_INTERFACE_ID IN (
10170: SELECT TRANSACTION_INTERFACE_ID
10171: FROM MTL_TRANSACTIONS_INTERFACE MTI
10172: WHERE mti.TRANSACTION_HEADER_ID = p_header_id
10173: /*WHERE MTI.ROWID = p_rowid J-dev*/
10174: AND mti.TRANSACTION_INTERFACE_ID IS NOT NULL
10175: AND mti.PROCESS_FLAG = 1

Line 10351: FROM MTL_TRANSACTIONS_INTERFACE MTI

10347: parent_object_number2 --R12 Genealogy enhancements
10348: FROM MTL_SERIAL_NUMBERS_INTERFACE
10349: WHERE (TRANSACTION_INTERFACE_ID IN (
10350: SELECT TRANSACTION_INTERFACE_ID
10351: FROM MTL_TRANSACTIONS_INTERFACE MTI
10352: WHERE TRANSACTION_HEADER_ID = p_header_id
10353: /*WHERE MTI.ROWID = p_rowid*/--J-dev
10354: AND TRANSACTION_INTERFACE_ID IS NOT NULL
10355: AND PROCESS_FLAG = 1

Line 10366: FROM MTL_TRANSACTIONS_INTERFACE

10362: SELECT SERIAL_TRANSACTION_TEMP_ID
10363: FROM MTL_TRANSACTION_LOTS_INTERFACE
10364: WHERE TRANSACTION_INTERFACE_ID IN (
10365: SELECT TRANSACTION_INTERFACE_ID
10366: FROM MTL_TRANSACTIONS_INTERFACE
10367: WHERE TRANSACTION_HEADER_ID = p_header_id
10368: /*WHERE rowid = p_rowid J-dev*/
10369: AND TRANSACTION_INTERFACE_ID IS NOT NULL
10370: AND PROCESS_FLAG = 1

Line 10761: || ' mtl_transactions_interface mti'

10757: l_select_stmt
10758: || ' from mtl_serial_numbers_interface msni,'
10759: || ' mtl_serial_numbers msn,'
10760: || ' mtl_transaction_lots_interface mtli,'
10761: || ' mtl_transactions_interface mti'
10762: || ' where mti.parent_id = :b_parent_id'
10763: || ' and mti.transaction_interface_id <> mti.parent_id'
10764: || ' and mtli.transaction_interface_id = mti.transaction_interface_id'
10765: || ' and msni.transaction_interface_id = mtli.serial_transaction_temp_id'

Line 11087: FROM mtl_transactions_interface mti

11083: , mti.secondary_transaction_quantity
11084: , mti.secondary_uom_code
11085: , mti.relieve_reservations_flag /*** {{ R12 Enhanced reservations code changes ***/
11086: , mti.relieve_high_level_rsv_flag /*** {{ R12 Enhanced reservations code changes ***/
11087: FROM mtl_transactions_interface mti
11088: WHERE mti.transaction_header_id = l_header_id
11089: AND mti.transaction_action_id IN
11090: (inv_globals.g_action_inv_lot_split
11091: , inv_globals.g_action_inv_lot_merge

Line 11518: FROM mtl_transactions_interface mti

11514: , mtli.serial_transaction_temp_id
11515: FROM mtl_transaction_lots_interface mtli
11516: WHERE mtli.transaction_interface_id =
11517: (SELECT mti.transaction_interface_id
11518: FROM mtl_transactions_interface mti
11519: WHERE mti.parent_id = l_transaction_interface_id
11520: AND mti.transaction_interface_id <> mti.parent_id);
11521:
11522: l_parent_id NUMBER;

Line 12914: FROM mtl_transactions_interface mti

12910: ,l_old_lot_num
12911: ,l_old_sub_code
12912: ,l_old_locator_id
12913: ,l_old_lpn_id
12914: FROM mtl_transactions_interface mti
12915: ,mtl_transaction_lots_interface mtli
12916: WHERE mti.transaction_interface_id = mtli.transaction_interface_id
12917: AND mti.transaction_interface_id = mti.parent_id
12918: AND mti.transaction_interface_id = l_mti_csr.parent_id;

Line 13573: FROM MTL_TRANSACTIONS_INTERFACE

13569: ,WIP_ENTITY_TYPE -- Pawan 11th july added for subinventory issue
13570: /*Bug:5392366. Added following two columns. */
13571: ,COMPLETION_TRANSACTION_ID
13572: ,MOVE_TRANSACTION_ID
13573: FROM MTL_TRANSACTIONS_INTERFACE
13574: WHERE TRANSACTION_HEADER_ID = p_header_id
13575: AND PROCESS_FLAG = 1
13576: /* added for bug 4634810 */
13577: AND NOT( transaction_source_type_id = 5 AND

Line 13722: FROM MTL_TRANSACTIONS_INTERFACE

13718: +--------------------------------------------------------------+ */
13719: BEGIN
13720: SELECT DECODE(UPPER(FLOW_SCHEDULE),'Y', 1, 0)
13721: INTO gi_flow_schedule
13722: FROM MTL_TRANSACTIONS_INTERFACE
13723: WHERE TRANSACTION_HEADER_ID = l_header_id
13724: AND TRANSACTION_SOURCE_TYPE_ID = 5
13725: AND TRANSACTION_ACTION_ID IN (30,31, 32) --CFM Scrap Transactions
13726: AND PROCESS_FLAG = 1

Line 13804: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

13800:
13801: --check for batch error at line validation
13802: loaderrmsg('INV_GROUP_ERROR','INV_GROUP_ERROR');
13803:
13804: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
13805: SET LAST_UPDATE_DATE = SYSDATE,
13806: LAST_UPDATED_BY = l_userid,
13807: LAST_UPDATE_LOGIN = l_loginid,
13808: PROGRAM_UPDATE_DATE = SYSDATE,

Line 13816: FROM MTL_TRANSACTIONS_INTERFACE MTI2

13812: WHERE TRANSACTION_HEADER_ID = l_header_id
13813: AND PROCESS_FLAG = 1
13814: AND TRANSACTION_BATCH_ID IN
13815: (SELECT DISTINCT MTI2.TRANSACTION_BATCH_ID
13816: FROM MTL_TRANSACTIONS_INTERFACE MTI2
13817: WHERE MTI2.TRANSACTION_HEADER_ID = l_header_id
13818: AND MTI2.PROCESS_FLAG = 3
13819: AND MTI2.ERROR_CODE IS NOT NULL);
13820: -- group error changes.

Line 13898: FROM mtl_transactions_interface

13894: IF ( NOT l_current_batch_failed) THEN --350
13895: BEGIN
13896: SELECT demand_source_header_id , demand_source_line
13897: INTO l_dem_hdr_id,l_dem_line_id
13898: FROM mtl_transactions_interface
13899: WHERE
13900: ROWID = l_temp_rowid ;
13901: EXCEPTION
13902: WHEN OTHERS THEN

Line 13910: UPDATE MTL_TRANSACTIONS_INTERFACE

13906: END IF;
13907: l_error_code := 'Error in getting Demand Info';
13908: l_error_exp := 'Error in getting Demand Info';
13909:
13910: UPDATE MTL_TRANSACTIONS_INTERFACE
13911: SET LAST_UPDATE_DATE = SYSDATE,
13912: LAST_UPDATED_BY = l_userid,
13913: LAST_UPDATE_LOGIN = l_loginid,
13914: PROGRAM_UPDATE_DATE = SYSDATE,

Line 13925: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

13921:
13922: --check for batch error
13923: loaderrmsg('INV_GROUP_ERROR','INV_GROUP_ERROR');
13924:
13925: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
13926: SET LAST_UPDATE_DATE = SYSDATE,
13927: LAST_UPDATED_BY = l_userid,
13928: LAST_UPDATE_LOGIN = l_loginid,
13929: PROGRAM_UPDATE_DATE = SYSDATE,

Line 14013: UPDATE MTL_TRANSACTIONS_INTERFACE

14009: FND_MESSAGE.set_token('ROUTINE','UE:AVAIL_TO_TRX');
14010: l_error_code := FND_MESSAGE.get;
14011: l_error_exp := l_msg_data;
14012: x_msg_data := l_msg_data;
14013: UPDATE MTL_TRANSACTIONS_INTERFACE
14014: SET LAST_UPDATE_DATE = SYSDATE,
14015: LAST_UPDATED_BY = l_userid,
14016: LAST_UPDATE_LOGIN = l_loginid,
14017: PROGRAM_UPDATE_DATE = SYSDATE,

Line 14028: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

14024:
14025: --check for batch error
14026: loaderrmsg('INV_GROUP_ERROR','INV_GROUP_ERROR');
14027:
14028: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
14029: SET LAST_UPDATE_DATE = SYSDATE,
14030: LAST_UPDATED_BY = l_userid,
14031: LAST_UPDATE_LOGIN = l_loginid,
14032: PROGRAM_UPDATE_DATE = SYSDATE,

Line 14080: UPDATE MTL_TRANSACTIONS_INTERFACE

14076: FND_MESSAGE.set_token('token1','XACT_QTY1');
14077: l_error_code := FND_MESSAGE.get;
14078: l_error_exp := l_msg_data;
14079: x_msg_data := l_msg_data;
14080: UPDATE MTL_TRANSACTIONS_INTERFACE
14081: SET LAST_UPDATE_DATE = SYSDATE,
14082: LAST_UPDATED_BY = l_userid,
14083: LAST_UPDATE_LOGIN = l_loginid,
14084: PROGRAM_UPDATE_DATE = SYSDATE,

Line 14094: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

14090: AND PROCESS_FLAG = 1;
14091: --check for batch error
14092: loaderrmsg('INV_GROUP_ERROR','INV_GROUP_ERROR');
14093:
14094: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
14095: SET LAST_UPDATE_DATE = SYSDATE,
14096: LAST_UPDATED_BY = l_userid,
14097: LAST_UPDATE_LOGIN = l_loginid,
14098: PROGRAM_UPDATE_DATE = SYSDATE,

Line 14121: UPDATE MTL_TRANSACTIONS_INTERFACE

14117: FND_MESSAGE.set_token('token1','XACT_QTY1');
14118: l_error_code := FND_MESSAGE.get;
14119: l_error_exp := l_msg_data;
14120: x_msg_data := l_msg_data;
14121: UPDATE MTL_TRANSACTIONS_INTERFACE
14122: SET LAST_UPDATE_DATE = SYSDATE,
14123: LAST_UPDATED_BY = l_userid,
14124: LAST_UPDATE_LOGIN = l_loginid,
14125: PROGRAM_UPDATE_DATE = SYSDATE,

Line 14135: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

14131: AND PROCESS_FLAG = 1;
14132: --check for batch error
14133: loaderrmsg('INV_GROUP_ERROR','INV_GROUP_ERROR');
14134:
14135: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
14136: SET LAST_UPDATE_DATE = SYSDATE,
14137: LAST_UPDATED_BY = l_userid,
14138: LAST_UPDATE_LOGIN = l_loginid,
14139: PROGRAM_UPDATE_DATE = SYSDATE,

Line 14219: UPDATE MTL_TRANSACTIONS_INTERFACE

14215: l_error_code := FND_MESSAGE.get;
14216: FND_MESSAGE.set_name('INV','INV_QTY_LESS_OR_EQUAL');
14217: l_error_exp := FND_MESSAGE.get;
14218: x_msg_data := l_error_exp;
14219: UPDATE MTL_TRANSACTIONS_INTERFACE
14220: SET LAST_UPDATE_DATE = SYSDATE,
14221: LAST_UPDATED_BY = l_userid,
14222: LAST_UPDATE_LOGIN = l_loginid,
14223: PROGRAM_UPDATE_DATE = SYSDATE,

Line 14233: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

14229: AND PROCESS_FLAG = 1;
14230: --check for batch error
14231: loaderrmsg('INV_GROUP_ERROR','INV_GROUP_ERROR');
14232:
14233: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
14234: SET LAST_UPDATE_DATE = SYSDATE,
14235: LAST_UPDATED_BY = l_userid,
14236: LAST_UPDATE_LOGIN = l_loginid,
14237: PROGRAM_UPDATE_DATE = SYSDATE,

Line 14281: UPDATE MTL_TRANSACTIONS_INTERFACE

14277: FND_MESSAGE.set_token('token1','XACT_QTY1');
14278: l_error_code := FND_MESSAGE.get;
14279: l_error_exp := l_msg_data;
14280: x_msg_data := l_msg_data;
14281: UPDATE MTL_TRANSACTIONS_INTERFACE
14282: SET LAST_UPDATE_DATE = SYSDATE,
14283: LAST_UPDATED_BY = l_userid,
14284: LAST_UPDATE_LOGIN = l_loginid,
14285: PROGRAM_UPDATE_DATE = SYSDATE,

Line 14295: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

14291: AND PROCESS_FLAG = 1;
14292: --check for batch error
14293: loaderrmsg('INV_GROUP_ERROR','INV_GROUP_ERROR');
14294:
14295: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
14296: SET LAST_UPDATE_DATE = SYSDATE,
14297: LAST_UPDATED_BY = l_userid,
14298: LAST_UPDATE_LOGIN = l_loginid,
14299: PROGRAM_UPDATE_DATE = SYSDATE,

Line 14321: UPDATE MTL_TRANSACTIONS_INTERFACE

14317: FND_MESSAGE.set_token('token1','XACT_QTY1');
14318: l_error_code := FND_MESSAGE.get;
14319: l_error_exp := l_msg_data;
14320: x_msg_data := l_msg_data;
14321: UPDATE MTL_TRANSACTIONS_INTERFACE
14322: SET LAST_UPDATE_DATE = SYSDATE,
14323: LAST_UPDATED_BY = l_userid,
14324: LAST_UPDATE_LOGIN = l_loginid,
14325: PROGRAM_UPDATE_DATE = SYSDATE,

Line 14335: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

14331: AND PROCESS_FLAG = 1;
14332: --check for batch error
14333: loaderrmsg('INV_GROUP_ERROR','INV_GROUP_ERROR');
14334:
14335: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
14336: SET LAST_UPDATE_DATE = SYSDATE,
14337: LAST_UPDATED_BY = l_userid,
14338: LAST_UPDATE_LOGIN = l_loginid,
14339: PROGRAM_UPDATE_DATE = SYSDATE,

Line 14375: UPDATE MTL_TRANSACTIONS_INTERFACE

14371: FND_MESSAGE.set_name('INV','INV_ORG_QUANTITY');
14372: l_error_exp := FND_MESSAGE.get;
14373: FND_MESSAGE.set_name('INV','INV_INTERNAL_ERROR');
14374: x_msg_data := l_error_exp;
14375: UPDATE MTL_TRANSACTIONS_INTERFACE
14376: SET LAST_UPDATE_DATE = SYSDATE,
14377: LAST_UPDATED_BY = l_userid,
14378: LAST_UPDATE_LOGIN = l_loginid,
14379: PROGRAM_UPDATE_DATE = SYSDATE,

Line 14389: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

14385: AND PROCESS_FLAG = 1;
14386: --check for batch error
14387: loaderrmsg('INV_GROUP_ERROR','INV_GROUP_ERROR');
14388:
14389: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
14390: SET LAST_UPDATE_DATE = SYSDATE,
14391: LAST_UPDATED_BY = l_userid,
14392: LAST_UPDATE_LOGIN = l_loginid,
14393: PROGRAM_UPDATE_DATE = SYSDATE,

Line 14419: UPDATE MTL_TRANSACTIONS_INTERFACE

14415: FND_MESSAGE.set_token('ENTITY1','INV_QUANTITY',l_translate);
14416: FND_MESSAGE.set_token('ENTITY2','AVAIL_TO_TRANSACT',l_translate);
14417: l_error_exp := FND_MESSAGE.get;
14418: x_msg_data := l_error_exp;
14419: UPDATE MTL_TRANSACTIONS_INTERFACE
14420: SET LAST_UPDATE_DATE = SYSDATE,
14421: LAST_UPDATED_BY = l_userid,
14422: LAST_UPDATE_LOGIN = l_loginid,
14423: PROGRAM_UPDATE_DATE = SYSDATE,

Line 14433: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

14429: AND PROCESS_FLAG = 1;
14430: --check for batch error
14431: loaderrmsg('INV_GROUP_ERROR','INV_GROUP_ERROR');
14432:
14433: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
14434: SET LAST_UPDATE_DATE = SYSDATE,
14435: LAST_UPDATED_BY = l_userid,
14436: LAST_UPDATE_LOGIN = l_loginid,
14437: PROGRAM_UPDATE_DATE = SYSDATE,

Line 14492: UPDATE MTL_TRANSACTIONS_INTERFACE

14488: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.UPDATE_QUANTITIES');
14489: l_error_code:= fnd_message.get;
14490: l_error_exp :=l_msg_data;
14491: x_msg_data := l_msg_data;
14492: UPDATE MTL_TRANSACTIONS_INTERFACE
14493: SET LAST_UPDATE_DATE = SYSDATE,
14494: LAST_UPDATED_BY = l_userid,
14495: LAST_UPDATE_LOGIN = l_loginid,
14496: PROGRAM_UPDATE_DATE = SYSDATE,

Line 14506: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

14502: AND PROCESS_FLAG = 1;
14503: --check for batch error
14504: loaderrmsg('INV_GROUP_ERROR','INV_GROUP_ERROR');
14505:
14506: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
14507: SET LAST_UPDATE_DATE = SYSDATE,
14508: LAST_UPDATED_BY = l_userid,
14509: LAST_UPDATE_LOGIN = l_loginid,
14510: PROGRAM_UPDATE_DATE = SYSDATE,

Line 14561: UPDATE MTL_TRANSACTIONS_INTERFACE

14557: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.UPDATE_QUANTITIES');
14558: l_error_code:= fnd_message.get;
14559: l_error_exp :=l_msg_data;
14560: x_msg_data := l_msg_data;
14561: UPDATE MTL_TRANSACTIONS_INTERFACE
14562: SET LAST_UPDATE_DATE = SYSDATE,
14563: LAST_UPDATED_BY = l_userid,
14564: LAST_UPDATE_LOGIN = l_loginid,
14565: PROGRAM_UPDATE_DATE = SYSDATE,

Line 14575: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

14571: AND PROCESS_FLAG = 1;
14572: --check for batch error
14573: loaderrmsg('INV_GROUP_ERROR','INV_GROUP_ERROR');
14574:
14575: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
14576: SET LAST_UPDATE_DATE = SYSDATE,
14577: LAST_UPDATED_BY = l_userid,
14578: LAST_UPDATE_LOGIN = l_loginid,
14579: PROGRAM_UPDATE_DATE = SYSDATE,

Line 14632: FROM mtl_transactions_interface

14628: END IF;
14629:
14630: SELECT COUNT(*)
14631: INTO l_count_success
14632: FROM mtl_transactions_interface
14633: WHERE transaction_header_id = l_header_id
14634: AND process_flag = 1;
14635:
14636: IF (l_count_success = 0) THEN

Line 14652: UPDATE MTL_TRANSACTIONS_INTERFACE

14648: END IF;
14649: FND_MESSAGE.set_name('INV','INV_INT_TMPXFRCODE');
14650: l_error_code := FND_MESSAGE.get;
14651: x_msg_data := l_error_exp;
14652: UPDATE MTL_TRANSACTIONS_INTERFACE
14653: SET LAST_UPDATE_DATE = SYSDATE,
14654: LAST_UPDATED_BY = l_userid,
14655: LAST_UPDATE_LOGIN = l_loginid,
14656: PROGRAM_UPDATE_DATE = SYSDATE,

Line 14672: FROM MTL_TRANSACTIONS_INTERFACE

14668: DELETE FROM MTL_SERIAL_NUMBERS_INTERFACE
14669: WHERE TRANSACTION_INTERFACE_ID
14670: IN(
14671: SELECT TRANSACTION_INTERFACE_ID
14672: FROM MTL_TRANSACTIONS_INTERFACE
14673: WHERE TRANSACTION_HEADER_ID =l_header_id
14674: AND PROCESS_FLAG <> 3
14675: union all
14676: SELECT SERIAL_TRANSACTION_TEMP_ID

Line 14681: FROM MTL_TRANSACTIONS_INTERFACE

14677: FROM MTL_TRANSACTION_LOTS_INTERFACE
14678: WHERE TRANSACTION_INTERFACE_ID
14679: IN (
14680: SELECT TRANSACTION_INTERFACE_ID
14681: FROM MTL_TRANSACTIONS_INTERFACE
14682: WHERE TRANSACTION_HEADER_ID = l_header_id
14683: AND PROCESS_FLAG <> 3 )) ;
14684: DELETE FROM MTL_TRANSACTION_LOTS_INTERFACE
14685: WHERE TRANSACTION_INTERFACE_ID IN

Line 14687: FROM MTL_TRANSACTIONS_INTERFACE

14683: AND PROCESS_FLAG <> 3 )) ;
14684: DELETE FROM MTL_TRANSACTION_LOTS_INTERFACE
14685: WHERE TRANSACTION_INTERFACE_ID IN
14686: (SELECT TRANSACTION_INTERFACE_ID
14687: FROM MTL_TRANSACTIONS_INTERFACE
14688: WHERE TRANSACTION_HEADER_ID =l_header_id
14689: AND PROCESS_FLAG <> 3);
14690: DELETE FROM MTL_TRANSACTIONS_INTERFACE
14691: WHERE TRANSACTION_HEADER_ID = l_header_id

Line 14690: DELETE FROM MTL_TRANSACTIONS_INTERFACE

14686: (SELECT TRANSACTION_INTERFACE_ID
14687: FROM MTL_TRANSACTIONS_INTERFACE
14688: WHERE TRANSACTION_HEADER_ID =l_header_id
14689: AND PROCESS_FLAG <> 3);
14690: DELETE FROM MTL_TRANSACTIONS_INTERFACE
14691: WHERE TRANSACTION_HEADER_ID = l_header_id
14692: AND PROCESS_FLAG <> 3;
14693: IF (l_debug = 1) THEN
14694: inv_log_util.trace('*** Del recs mti valid trx', 'INV_TXN_MANAGER_GRP',9);

Line 14710: UPDATE MTL_TRANSACTIONS_INTERFACE

14706:
14707: FND_MESSAGE.set_name('INV','INV_INT_SQLCODE');
14708: l_error_code := FND_MESSAGE.get;
14709:
14710: UPDATE MTL_TRANSACTIONS_INTERFACE
14711: SET LAST_UPDATE_DATE = SYSDATE,
14712: LAST_UPDATED_BY = l_userid,
14713: LAST_UPDATE_LOGIN = l_loginid,
14714: PROGRAM_UPDATE_DATE = SYSDATE,