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_PUB dependencies on MTL_TRANSACTIONS_INTERFACE

Line 259: FROM mtl_transactions_interface mti

255: , mti.transaction_batch_id
256: , mti.transaction_batch_seq
257: , mti.kanban_card_id
258: , mti.transaction_mode --J-dev
259: FROM mtl_transactions_interface mti
260: , mtl_transaction_lots_interface mtli
261: , mtl_system_items_b msi
262: WHERE mti.transaction_interface_id = p_interface_id
263: AND mti.transaction_interface_id = mtli.transaction_interface_id

Line 389: FROM mtl_transactions_interface mti

385: SELECT serial_transaction_temp_id
386: FROM mtl_transaction_lots_interface mtli
387: WHERE mtli.transaction_interface_id IN (
388: SELECT transaction_interface_id
389: FROM mtl_transactions_interface mti
390: WHERE mti.parent_id = p_parent_id
391: AND mti.transaction_interface_id <> mti.parent_id));
392:
393: l_msni_rs_serials_csr msni_rs_serials_csr%ROWTYPE;

Line 406: FROM mtl_transactions_interface mti

402: (SELECT serial_transaction_temp_id
403: FROM mtl_transaction_lots_interface mtli
404: WHERE mtli.transaction_interface_id =
405: (SELECT transaction_interface_id
406: FROM mtl_transactions_interface mti
407: WHERE mti.parent_id = p_parent_id
408: AND mti.transaction_interface_id = mti.parent_id));
409:
410: l_msni_st_serials_csr msni_st_serials_csr%ROWTYPE;

Line 437: FROM mtl_transactions_interface

433: END IF;
434: l_sysdate := SYSDATE;
435: SELECT COUNT (parent_id)
436: INTO l_count
437: FROM mtl_transactions_interface
438: WHERE parent_id = p_parent_id;
439:
440: SELECT ABS (primary_quantity)
441: INTO l_split_qty

Line 442: FROM mtl_transactions_interface

438: WHERE parent_id = p_parent_id;
439:
440: SELECT ABS (primary_quantity)
441: INTO l_split_qty
442: FROM mtl_transactions_interface
443: WHERE transaction_interface_id = p_parent_id;
444:
445: SELECT SUM (ABS (primary_quantity))
446: INTO l_partial_total_qty

Line 447: FROM mtl_transactions_interface

443: WHERE transaction_interface_id = p_parent_id;
444:
445: SELECT SUM (ABS (primary_quantity))
446: INTO l_partial_total_qty
447: FROM mtl_transactions_interface
448: WHERE parent_id = p_parent_id AND transaction_interface_id <> p_parent_id;
449:
450: l_remaining_qty := l_split_qty - l_partial_total_qty;
451:

Line 480: INSERT INTO mtl_transactions_interface

476: THEN
477: inv_log_util.TRACE ('l_breadcrumb 30', 'INV_TXN_MANAGER_PUB', '9');
478: END IF;
479:
480: INSERT INTO mtl_transactions_interface
481: (transaction_header_id
482: , transaction_interface_id
483: , transaction_mode
484: , lock_flag

Line 1346: UPDATE mtl_transactions_interface

1342: l_progid NUMBER := -1; -- = prg_info.progid;
1343: l_loginid NUMBER := -1; --= prg_info.loginid;
1344: BEGIN
1345: -- WHENEVER NOT FOUND CONTINUE;
1346: UPDATE mtl_transactions_interface
1347: SET ERROR_CODE = SUBSTRB (l_error_code, 1, 240)
1348: , error_explanation = SUBSTRB (l_error_exp, 1, 240)
1349: , last_update_date = SYSDATE
1350: , last_updated_by = l_userid

Line 1594: FROM mtl_transactions_interface

1590: , WIP_ENTITY_TYPE -- Pawan 11th july
1591: /* Bug:5392366. Added the following two columns.*/
1592: , completion_transaction_id
1593: , move_transaction_id
1594: FROM mtl_transactions_interface
1595: WHERE transaction_header_id = p_header_id AND process_flag = 1
1596: ORDER BY organization_id
1597: , inventory_item_id
1598: , revision

Line 1659: * Validate one transaction record in MTL_TRANSACTIONS_INTERFACE

1655:
1656: /******************************************************************
1657: *
1658: * validate_lines()
1659: * Validate one transaction record in MTL_TRANSACTIONS_INTERFACE
1660: *
1661: ******************************************************************/
1662: PROCEDURE validate_lines (
1663: p_line_rec_type line_rec_type

Line 2077: FROM mtl_transactions_interface

2073: , WIP_ENTITY_TYPE -- Pawan 11th july added
2074: /* Bug:5392366. Added the following two columns.*/
2075: , completion_transaction_id
2076: , move_transaction_id
2077: FROM mtl_transactions_interface
2078: WHERE transaction_header_id = p_header_id AND process_flag = 1
2079: ORDER BY transaction_batch_id
2080: , transaction_batch_seq
2081: , organization_id

Line 2601: / Table = 1 - MTL_TRANSACTIONS_INTERFACE /

2597: END IF;
2598: END LOOP;
2599: ELSE
2600:
2601: /** Table = 1 - MTL_TRANSACTIONS_INTERFACE **/
2602: /** Table = 1 - MTL_TRANSACTIONS_INTERFACE **/
2603: /*Patchset J:Trip Stop Interface Enhancements:setting the
2604: /*transaction batch id for Shipping transactions depending
2605: /*on the profile INV:Batch Size*/

Line 2602: / Table = 1 - MTL_TRANSACTIONS_INTERFACE /

2598: END LOOP;
2599: ELSE
2600:
2601: /** Table = 1 - MTL_TRANSACTIONS_INTERFACE **/
2602: /** Table = 1 - MTL_TRANSACTIONS_INTERFACE **/
2603: /*Patchset J:Trip Stop Interface Enhancements:setting the
2604: /*transaction batch id for Shipping transactions depending
2605: /*on the profile INV:Batch Size*/
2606: /*Bug 3947667, enabling it irrespective of patchset */

Line 2630: UPDATE mtl_transactions_interface

2626: , 9
2627: );
2628: END IF;
2629:
2630: UPDATE mtl_transactions_interface
2631: SET last_update_date = SYSDATE
2632: , transaction_interface_id =
2633: NVL (transaction_interface_id
2634: , mtl_material_transactions_s.NEXTVAL

Line 2665: UPDATE MTL_TRANSACTIONS_INTERFACE

2661: WHERE process_flag = 1 AND transaction_header_id = l_header_id;
2662:
2663: /* ELSE
2664:
2665: UPDATE MTL_TRANSACTIONS_INTERFACE
2666: SET LAST_UPDATE_DATE = SYSDATE,
2667: TRANSACTION_INTERFACE_ID = NVL(TRANSACTION_INTERFACE_ID,
2668: mtl_material_transactions_s.nextval),
2669: LAST_UPDATED_BY = l_userid,

Line 2719: FROM mtl_transactions_interface mti, mtl_transaction_types mtt

2715: SELECT NVL (validation_required, 1)
2716: , mtt.transaction_source_type_id, mti.wip_entity_type
2717: INTO l_valreq
2718: , l_srctypeid, l_wip_entity_type
2719: FROM mtl_transactions_interface mti, mtl_transaction_types mtt
2720: WHERE transaction_header_id = l_header_id
2721: AND mtt.transaction_type_id = mti.transaction_type_id
2722: AND ROWNUM < 2;
2723:

Line 2733: FROM mtl_transactions_interface

2729: THEN
2730: BEGIN
2731: SELECT DECODE (UPPER (flow_schedule), 'Y', 1, 0)
2732: INTO inv_txn_manager_grp.gi_flow_schedule
2733: FROM mtl_transactions_interface
2734: WHERE transaction_header_id = l_header_id
2735: AND transaction_source_type_id = 5
2736: AND transaction_action_id IN
2737: (30, 31, 32) --CFM Scrap Transactions

Line 2778: FROM MTL_TRANSACTIONS_INTERFACE

2774:
2775: --check if all records have been failed by the wip API.
2776: BEGIN
2777: SELECT transaction_source_type_id INTO l_source_type_id
2778: FROM MTL_TRANSACTIONS_INTERFACE
2779: WHERE TRANSACTION_HEADER_ID = l_header_id
2780: AND PROCESS_FLAG = 1
2781: AND ROWNUM < 2;
2782: EXCEPTION

Line 2819: FROM mtl_transactions_interface

2815: --check if all records have been failed by the wip API.
2816: BEGIN
2817: SELECT transaction_source_type_id
2818: INTO l_source_type_id
2819: FROM mtl_transactions_interface
2820: WHERE transaction_header_id = l_header_id
2821: AND process_flag = 1
2822: AND ROWNUM < 2;
2823: EXCEPTION

Line 2944: FROM mtl_transactions_interface

2940: l_batch_count := 0;
2941:
2942: SELECT COUNT (1)
2943: INTO l_batch_count
2944: FROM mtl_transactions_interface
2945: WHERE parent_id = l_line_rec_type.parent_id
2946: AND transaction_batch_id IS NULL;
2947:
2948: IF (l_batch_count > 0)

Line 2954: UPDATE mtl_transactions_interface

2950: loaderrmsg ('INV_INVALID_BATCH'
2951: , 'INV_INVALID_BATCH_NUMBER'
2952: );
2953:
2954: UPDATE mtl_transactions_interface
2955: SET last_update_date = SYSDATE
2956: , last_updated_by = l_userid
2957: , last_update_login = l_loginid
2958: , program_update_date = SYSDATE

Line 3011: UPDATE mtl_transactions_interface

3007: );
3008: END IF;
3009: END LOOP;
3010:
3011: UPDATE mtl_transactions_interface
3012: SET last_update_date = SYSDATE
3013: , last_updated_by = l_userid
3014: , last_update_login = l_loginid
3015: , program_update_date = SYSDATE

Line 3056: UPDATE mtl_transactions_interface

3052: );
3053: END IF;
3054: END LOOP;
3055:
3056: UPDATE mtl_transactions_interface
3057: SET last_update_date = SYSDATE
3058: , last_updated_by = l_userid
3059: , last_update_login = l_loginid
3060: , program_update_date = SYSDATE

Line 3103: UPDATE mtl_transactions_interface

3099: );
3100: END IF;
3101: END LOOP;
3102:
3103: UPDATE mtl_transactions_interface
3104: SET last_update_date = SYSDATE
3105: , last_updated_by = l_userid
3106: , last_update_login = l_loginid
3107: , program_update_date = SYSDATE

Line 3143: UPDATE mtl_transactions_interface

3139: fnd_message.set_name ('INV', 'INV_LOT_TRANSLATE_VALIDATIONS');
3140: l_error_code := fnd_message.get;
3141: END IF;
3142:
3143: UPDATE mtl_transactions_interface
3144: SET last_update_date = SYSDATE
3145: , last_updated_by = l_userid
3146: , last_update_login = l_loginid
3147: , program_update_date = SYSDATE

Line 3172: FROM mtl_transactions_interface

3168: IF (l_line_rec_type.distribution_account_id IS NULL)
3169: THEN
3170: SELECT distribution_account_id
3171: INTO l_dist_acct_id
3172: FROM mtl_transactions_interface
3173: WHERE ROWID = l_line_rec_type.ROWID;
3174:
3175: l_line_rec_type.distribution_account_id := l_dist_acct_id;
3176: END IF;

Line 3301: FROM mtl_transactions_interface

3297: IF ( NOT l_current_batch_failed) THEN --350
3298: BEGIN
3299: SELECT demand_source_header_id , demand_source_line
3300: INTO l_dem_hdr_id,l_dem_line_id
3301: FROM mtl_transactions_interface
3302: WHERE
3303: ROWID = l_temp_rowid ;
3304: EXCEPTION
3305: WHEN OTHERS THEN

Line 3313: UPDATE MTL_TRANSACTIONS_INTERFACE

3309: END IF;
3310: l_error_code := 'Error in getting Demand Info';
3311: l_error_exp := 'Error in getting Demand Info';
3312:
3313: UPDATE MTL_TRANSACTIONS_INTERFACE
3314: SET LAST_UPDATE_DATE = SYSDATE,
3315: LAST_UPDATED_BY = l_userid,
3316: LAST_UPDATE_LOGIN = l_loginid,
3317: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3327: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3323: AND PROCESS_FLAG = 1;
3324: --check for batch error
3325: loaderrmsg('INV_GROUP_ERROR','INV_GROUP_ERROR');
3326:
3327: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3328: SET LAST_UPDATE_DATE = SYSDATE,
3329: LAST_UPDATED_BY = l_userid,
3330: LAST_UPDATE_LOGIN = l_loginid,
3331: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3416: UPDATE MTL_TRANSACTIONS_INTERFACE

3412: FND_MESSAGE.set_token('ROUTINE','UE:AVAIL_TO_TRX');
3413: l_error_code := FND_MESSAGE.get;
3414: l_error_exp := l_msg_data;
3415: x_msg_data := l_msg_data;
3416: UPDATE MTL_TRANSACTIONS_INTERFACE
3417: SET LAST_UPDATE_DATE = SYSDATE,
3418: LAST_UPDATED_BY = l_userid,
3419: LAST_UPDATE_LOGIN = l_loginid,
3420: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3431: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3427:
3428: --check for batch error
3429: loaderrmsg('INV_GROUP_ERROR','INV_GROUP_ERROR');
3430:
3431: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3432: SET LAST_UPDATE_DATE = SYSDATE,
3433: LAST_UPDATED_BY = l_userid,
3434: LAST_UPDATE_LOGIN = l_loginid,
3435: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3482: UPDATE MTL_TRANSACTIONS_INTERFACE

3478: FND_MESSAGE.set_token('token1','XACT_QTY1');
3479: l_error_code := FND_MESSAGE.get;
3480: l_error_exp := l_msg_data;
3481: x_msg_data := l_msg_data;
3482: UPDATE MTL_TRANSACTIONS_INTERFACE
3483: SET LAST_UPDATE_DATE = SYSDATE,
3484: LAST_UPDATED_BY = l_userid,
3485: LAST_UPDATE_LOGIN = l_loginid,
3486: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3496: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3492: AND PROCESS_FLAG = 1;
3493: --check for batch error
3494: loaderrmsg('INV_GROUP_ERROR','INV_GROUP_ERROR');
3495:
3496: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3497: SET LAST_UPDATE_DATE = SYSDATE,
3498: LAST_UPDATED_BY = l_userid,
3499: LAST_UPDATE_LOGIN = l_loginid,
3500: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3523: UPDATE MTL_TRANSACTIONS_INTERFACE

3519: FND_MESSAGE.set_token('token1','XACT_QTY1');
3520: l_error_code := FND_MESSAGE.get;
3521: l_error_exp := l_msg_data;
3522: x_msg_data := l_msg_data;
3523: UPDATE MTL_TRANSACTIONS_INTERFACE
3524: SET LAST_UPDATE_DATE = SYSDATE,
3525: LAST_UPDATED_BY = l_userid,
3526: LAST_UPDATE_LOGIN = l_loginid,
3527: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3537: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3533: AND PROCESS_FLAG = 1;
3534: --check for batch error
3535: loaderrmsg('INV_GROUP_ERROR','INV_GROUP_ERROR');
3536:
3537: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3538: SET LAST_UPDATE_DATE = SYSDATE,
3539: LAST_UPDATED_BY = l_userid,
3540: LAST_UPDATE_LOGIN = l_loginid,
3541: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3617: UPDATE MTL_TRANSACTIONS_INTERFACE

3613: l_error_code := FND_MESSAGE.get;
3614: FND_MESSAGE.set_name('INV','INV_QTY_LESS_OR_EQUAL');
3615: l_error_exp := FND_MESSAGE.get;
3616: x_msg_data := l_error_exp;
3617: UPDATE MTL_TRANSACTIONS_INTERFACE
3618: SET LAST_UPDATE_DATE = SYSDATE,
3619: LAST_UPDATED_BY = l_userid,
3620: LAST_UPDATE_LOGIN = l_loginid,
3621: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3631: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3627: AND PROCESS_FLAG = 1;
3628: --check for batch error
3629: loaderrmsg('INV_GROUP_ERROR','INV_GROUP_ERROR');
3630:
3631: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3632: SET LAST_UPDATE_DATE = SYSDATE,
3633: LAST_UPDATED_BY = l_userid,
3634: LAST_UPDATE_LOGIN = l_loginid,
3635: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3679: UPDATE MTL_TRANSACTIONS_INTERFACE

3675: FND_MESSAGE.set_token('token1','XACT_QTY1');
3676: l_error_code := FND_MESSAGE.get;
3677: l_error_exp := l_msg_data;
3678: x_msg_data := l_msg_data;
3679: UPDATE MTL_TRANSACTIONS_INTERFACE
3680: SET LAST_UPDATE_DATE = SYSDATE,
3681: LAST_UPDATED_BY = l_userid,
3682: LAST_UPDATE_LOGIN = l_loginid,
3683: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3693: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3689: AND PROCESS_FLAG = 1;
3690: --check for batch error
3691: loaderrmsg('INV_GROUP_ERROR','INV_GROUP_ERROR');
3692:
3693: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3694: SET LAST_UPDATE_DATE = SYSDATE,
3695: LAST_UPDATED_BY = l_userid,
3696: LAST_UPDATE_LOGIN = l_loginid,
3697: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3719: UPDATE MTL_TRANSACTIONS_INTERFACE

3715: FND_MESSAGE.set_token('token1','XACT_QTY1');
3716: l_error_code := FND_MESSAGE.get;
3717: l_error_exp := l_msg_data;
3718: x_msg_data := l_msg_data;
3719: UPDATE MTL_TRANSACTIONS_INTERFACE
3720: SET LAST_UPDATE_DATE = SYSDATE,
3721: LAST_UPDATED_BY = l_userid,
3722: LAST_UPDATE_LOGIN = l_loginid,
3723: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3733: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3729: AND PROCESS_FLAG = 1;
3730: --check for batch error
3731: loaderrmsg('INV_GROUP_ERROR','INV_GROUP_ERROR');
3732:
3733: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3734: SET LAST_UPDATE_DATE = SYSDATE,
3735: LAST_UPDATED_BY = l_userid,
3736: LAST_UPDATE_LOGIN = l_loginid,
3737: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3774: UPDATE MTL_TRANSACTIONS_INTERFACE

3770: FND_MESSAGE.set_name('INV','INV_ORG_QUANTITY');
3771: l_error_exp := FND_MESSAGE.get;
3772: FND_MESSAGE.set_name('INV','INV_INTERNAL_ERROR');
3773: x_msg_data := l_error_exp;
3774: UPDATE MTL_TRANSACTIONS_INTERFACE
3775: SET LAST_UPDATE_DATE = SYSDATE,
3776: LAST_UPDATED_BY = l_userid,
3777: LAST_UPDATE_LOGIN = l_loginid,
3778: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3788: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3784: AND PROCESS_FLAG = 1;
3785: --check for batch error
3786: loaderrmsg('INV_GROUP_ERROR','INV_GROUP_ERROR');
3787:
3788: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3789: SET LAST_UPDATE_DATE = SYSDATE,
3790: LAST_UPDATED_BY = l_userid,
3791: LAST_UPDATE_LOGIN = l_loginid,
3792: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3819: UPDATE MTL_TRANSACTIONS_INTERFACE

3815: FND_MESSAGE.set_token('ENTITY1','INV_QUANTITY',l_translate);
3816: FND_MESSAGE.set_token('ENTITY2','AVAIL_TO_TRANSACT',l_translate);
3817: l_error_exp := FND_MESSAGE.get;
3818: x_msg_data := l_error_exp;
3819: UPDATE MTL_TRANSACTIONS_INTERFACE
3820: SET LAST_UPDATE_DATE = SYSDATE,
3821: LAST_UPDATED_BY = l_userid,
3822: LAST_UPDATE_LOGIN = l_loginid,
3823: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3833: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3829: AND PROCESS_FLAG = 1;
3830: --check for batch error
3831: loaderrmsg('INV_GROUP_ERROR','INV_GROUP_ERROR');
3832:
3833: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3834: SET LAST_UPDATE_DATE = SYSDATE,
3835: LAST_UPDATED_BY = l_userid,
3836: LAST_UPDATE_LOGIN = l_loginid,
3837: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3890: UPDATE MTL_TRANSACTIONS_INTERFACE

3886: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.UPDATE_QUANTITIES');
3887: l_error_code:= fnd_message.get;
3888: l_error_exp :=l_msg_data;
3889: x_msg_data := l_msg_data;
3890: UPDATE MTL_TRANSACTIONS_INTERFACE
3891: SET LAST_UPDATE_DATE = SYSDATE,
3892: LAST_UPDATED_BY = l_userid,
3893: LAST_UPDATE_LOGIN = l_loginid,
3894: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3904: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3900: AND PROCESS_FLAG = 1;
3901: --check for batch error
3902: loaderrmsg('INV_GROUP_ERROR','INV_GROUP_ERROR');
3903:
3904: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3905: SET LAST_UPDATE_DATE = SYSDATE,
3906: LAST_UPDATED_BY = l_userid,
3907: LAST_UPDATE_LOGIN = l_loginid,
3908: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3959: UPDATE MTL_TRANSACTIONS_INTERFACE

3955: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.UPDATE_QUANTITIES');
3956: l_error_code:= fnd_message.get;
3957: l_error_exp :=l_msg_data;
3958: x_msg_data := l_msg_data;
3959: UPDATE MTL_TRANSACTIONS_INTERFACE
3960: SET LAST_UPDATE_DATE = SYSDATE,
3961: LAST_UPDATED_BY = l_userid,
3962: LAST_UPDATE_LOGIN = l_loginid,
3963: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3973: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3969: AND PROCESS_FLAG = 1;
3970: --check for batch error
3971: loaderrmsg('INV_GROUP_ERROR','INV_GROUP_ERROR');
3972:
3973: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3974: SET LAST_UPDATE_DATE = SYSDATE,
3975: LAST_UPDATED_BY = l_userid,
3976: LAST_UPDATE_LOGIN = l_loginid,
3977: PROGRAM_UPDATE_DATE = SYSDATE,

Line 4025: UPDATE MTL_TRANSACTIONS_INTERFACE

4021:
4022: FND_MESSAGE.SET_NAME('INV','INV_LOCATION_MANDATORY');
4023: l_error_code := FND_MESSAGE.GET;
4024:
4025: UPDATE MTL_TRANSACTIONS_INTERFACE
4026: SET LAST_UPDATE_DATE = SYSDATE,
4027: LAST_UPDATED_BY = l_userid,
4028: LAST_UPDATE_LOGIN = l_loginid,
4029: PROGRAM_UPDATE_DATE = SYSDATE,

Line 4087: UPDATE mtl_transactions_interface

4083: fnd_message.set_name ('INV', 'INV_INT_TMPXFRCODE');
4084: l_error_code := fnd_message.get;
4085: ROLLBACK TO line_validation_svpt;
4086:
4087: UPDATE mtl_transactions_interface
4088: SET last_update_date = SYSDATE
4089: , last_updated_by = l_userid
4090: , last_update_login = l_loginid
4091: , program_update_date = SYSDATE

Line 4160: UPDATE mtl_transactions_interface mti

4156:
4157: --check for batch error at line validation
4158: loaderrmsg ('INV_GROUP_ERROR', 'INV_GROUP_ERROR');
4159:
4160: UPDATE mtl_transactions_interface mti
4161: SET last_update_date = SYSDATE
4162: , last_updated_by = l_userid
4163: , last_update_login = l_loginid
4164: , program_update_date = SYSDATE

Line 4172: FROM mtl_transactions_interface mti2

4168: WHERE transaction_header_id = l_header_id
4169: AND process_flag = 1
4170: AND transaction_batch_id IN (
4171: SELECT DISTINCT mti2.transaction_batch_id
4172: FROM mtl_transactions_interface mti2
4173: WHERE mti2.transaction_header_id = l_header_id
4174: AND mti2.process_flag = 3
4175: AND mti2.ERROR_CODE IS NOT NULL);
4176:

Line 4187: FROM mtl_transactions_interface

4183: --check if all records have been failed by the Line Validation
4184: BEGIN
4185: SELECT transaction_source_type_id
4186: INTO l_source_type_id
4187: FROM mtl_transactions_interface
4188: WHERE transaction_header_id = l_header_id
4189: AND process_flag = 1
4190: AND ROWNUM < 2;
4191: EXCEPTION

Line 4233: UPDATE mtl_transactions_interface mti

4229: --bug 3727791
4230: --check for batch error at line validation
4231: loaderrmsg ('INV_GROUP_ERROR', 'INV_GROUP_ERROR');
4232:
4233: UPDATE mtl_transactions_interface mti
4234: SET last_update_date = SYSDATE
4235: , last_updated_by = l_userid
4236: , last_update_login = l_loginid
4237: , program_update_date = SYSDATE

Line 4245: FROM mtl_transactions_interface mti2

4241: WHERE transaction_header_id = l_header_id
4242: AND process_flag = 1
4243: AND transaction_batch_id IN (
4244: SELECT DISTINCT mti2.transaction_batch_id
4245: FROM mtl_transactions_interface mti2
4246: WHERE mti2.transaction_header_id = l_header_id
4247: AND mti2.process_flag = 3
4248: AND mti2.ERROR_CODE IS NOT NULL);
4249:

Line 4260: FROM mtl_transactions_interface

4256: --check if all records have been failed by the wip API.
4257: BEGIN
4258: SELECT transaction_source_type_id
4259: INTO l_source_type_id
4260: FROM mtl_transactions_interface
4261: WHERE transaction_header_id = l_header_id
4262: AND process_flag = 1
4263: AND ROWNUM < 2;
4264: EXCEPTION

Line 4769: UPDATE mtl_transactions_interface

4765: ELSE
4766: ROLLBACK WORK;
4767: END IF;
4768:
4769: UPDATE mtl_transactions_interface
4770: SET last_update_date = SYSDATE
4771: , last_updated_by = l_userid
4772: , last_update_login = l_loginid
4773: , program_update_date = SYSDATE

Line 5113: l_src_code mtl_transactions_interface.transaction_source_name%TYPE;

5109: l_sub_code VARCHAR2 (11);
5110: l_lotnum VARCHAR2 (80); -- changed lot_number to 80, inconv
5111: --Bug #5086940
5112: --Changed the length to correspond to transaction_source_name
5113: l_src_code mtl_transactions_interface.transaction_source_name%TYPE;
5114: l_xfrsub VARCHAR2 (11);
5115: l_rev VARCHAR2 (4);
5116: l_srclineid VARCHAR2 (40);
5117: l_trxdate DATE;

Line 5660: l_src_code mtl_transactions_interface.transaction_source_name%TYPE;

5656: l_srctypeid NUMBER;
5657: l_srcid NUMBER;
5658: --Bug #5086940
5659: --Changed the length to correspond to transaction_source_name
5660: l_src_code mtl_transactions_interface.transaction_source_name%TYPE;
5661: l_srclineid VARCHAR2 (40);
5662: l_deliveryid NUMBER;
5663: l_trx_qty NUMBER;
5664: l_trxdate DATE;

Line 6210: UPDATE mtl_transactions_interface

6206: THEN
6207:
6208: l_error_code := fnd_message.get;
6209:
6210: UPDATE mtl_transactions_interface
6211: SET last_update_date = SYSDATE
6212: , last_updated_by = l_userid
6213: , last_update_login = l_loginid
6214: , program_update_date = SYSDATE

Line 6226: UPDATE mtl_transactions_interface

6222: AND organization_id = l_org_id
6223: AND inventory_item_id = l_item_id
6224: AND NVL (subinventory_code, '@@@@') = NVL (l_sub_code, '@@@@');
6225:
6226: UPDATE mtl_transactions_interface
6227: SET last_update_date = SYSDATE
6228: , last_updated_by = l_userid
6229: , last_update_login = l_loginid
6230: , program_update_date = SYSDATE