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 2087: FROM mtl_transactions_interface

2083: , WIP_ENTITY_TYPE -- Pawan 11th july added
2084: /* Bug:5392366. Added the following two columns.*/
2085: , completion_transaction_id
2086: , move_transaction_id
2087: FROM mtl_transactions_interface
2088: WHERE transaction_header_id = p_header_id AND process_flag = 1
2089: ORDER BY transaction_batch_id
2090: , transaction_batch_seq
2091: , organization_id

Line 2617: / Table = 1 - MTL_TRANSACTIONS_INTERFACE /

2613: END IF;
2614: END LOOP;
2615: ELSE
2616:
2617: /** Table = 1 - MTL_TRANSACTIONS_INTERFACE **/
2618: /** Table = 1 - MTL_TRANSACTIONS_INTERFACE **/
2619: /*Patchset J:Trip Stop Interface Enhancements:setting the
2620: /*transaction batch id for Shipping transactions depending
2621: /*on the profile INV:Batch Size*/

Line 2618: / Table = 1 - MTL_TRANSACTIONS_INTERFACE /

2614: END LOOP;
2615: ELSE
2616:
2617: /** Table = 1 - MTL_TRANSACTIONS_INTERFACE **/
2618: /** Table = 1 - MTL_TRANSACTIONS_INTERFACE **/
2619: /*Patchset J:Trip Stop Interface Enhancements:setting the
2620: /*transaction batch id for Shipping transactions depending
2621: /*on the profile INV:Batch Size*/
2622: /*Bug 3947667, enabling it irrespective of patchset */

Line 2647: UPDATE mtl_transactions_interface

2643: );
2644: END IF;
2645:
2646: --Bug 13097146, limiting this batch_id update only for 2,16 only
2647: UPDATE mtl_transactions_interface
2648: SET last_update_date = SYSDATE
2649: , transaction_interface_id =
2650: NVL (transaction_interface_id
2651: , mtl_material_transactions_s.NEXTVAL

Line 2678: FROM mtl_transactions_interface

2674: WHERE process_flag = 1 AND transaction_header_id = l_header_id;
2675:
2676: SELECT max(transaction_batch_id)
2677: INTO l_max_batch_id
2678: FROM mtl_transactions_interface
2679: WHERE process_flag = 1 AND transaction_header_id = l_header_id;
2680:
2681: -- Bug 13097146, stamping batch_id separately for ISO shipments
2682: UPDATE mtl_transactions_interface

Line 2682: UPDATE mtl_transactions_interface

2678: FROM mtl_transactions_interface
2679: WHERE process_flag = 1 AND transaction_header_id = l_header_id;
2680:
2681: -- Bug 13097146, stamping batch_id separately for ISO shipments
2682: UPDATE mtl_transactions_interface
2683: SET last_update_date = SYSDATE
2684: , transaction_interface_id =
2685: NVL (transaction_interface_id
2686: , mtl_material_transactions_s.NEXTVAL

Line 2709: UPDATE MTL_TRANSACTIONS_INTERFACE

2705: WHERE process_flag = 1 AND transaction_header_id = l_header_id;
2706:
2707: /* ELSE
2708:
2709: UPDATE MTL_TRANSACTIONS_INTERFACE
2710: SET LAST_UPDATE_DATE = SYSDATE,
2711: TRANSACTION_INTERFACE_ID = NVL(TRANSACTION_INTERFACE_ID,
2712: mtl_material_transactions_s.nextval),
2713: LAST_UPDATED_BY = l_userid,

Line 2763: FROM mtl_transactions_interface mti, mtl_transaction_types mtt

2759: SELECT NVL (validation_required, 1)
2760: , mtt.transaction_source_type_id, mti.wip_entity_type
2761: INTO l_valreq
2762: , l_srctypeid, l_wip_entity_type
2763: FROM mtl_transactions_interface mti, mtl_transaction_types mtt
2764: WHERE transaction_header_id = l_header_id
2765: AND mtt.transaction_type_id = mti.transaction_type_id
2766: AND ROWNUM < 2;
2767:

Line 2777: FROM mtl_transactions_interface

2773: THEN
2774: BEGIN
2775: SELECT DECODE (UPPER (flow_schedule), 'Y', 1, 0)
2776: INTO inv_txn_manager_grp.gi_flow_schedule
2777: FROM mtl_transactions_interface
2778: WHERE transaction_header_id = l_header_id
2779: AND transaction_source_type_id = 5
2780: AND transaction_action_id IN
2781: (30, 31, 32) --CFM Scrap Transactions

Line 2822: FROM MTL_TRANSACTIONS_INTERFACE

2818:
2819: --check if all records have been failed by the wip API.
2820: BEGIN
2821: SELECT transaction_source_type_id INTO l_source_type_id
2822: FROM MTL_TRANSACTIONS_INTERFACE
2823: WHERE TRANSACTION_HEADER_ID = l_header_id
2824: AND PROCESS_FLAG = 1
2825: AND ROWNUM < 2;
2826: EXCEPTION

Line 2863: FROM mtl_transactions_interface

2859: --check if all records have been failed by the wip API.
2860: BEGIN
2861: SELECT transaction_source_type_id
2862: INTO l_source_type_id
2863: FROM mtl_transactions_interface
2864: WHERE transaction_header_id = l_header_id
2865: AND process_flag = 1
2866: AND ROWNUM < 2;
2867: EXCEPTION

Line 2988: FROM mtl_transactions_interface

2984: l_batch_count := 0;
2985:
2986: SELECT COUNT (1)
2987: INTO l_batch_count
2988: FROM mtl_transactions_interface
2989: WHERE parent_id = l_line_rec_type.parent_id
2990: AND transaction_batch_id IS NULL;
2991:
2992: IF (l_batch_count > 0)

Line 2998: UPDATE mtl_transactions_interface

2994: loaderrmsg ('INV_INVALID_BATCH'
2995: , 'INV_INVALID_BATCH_NUMBER'
2996: );
2997:
2998: UPDATE mtl_transactions_interface
2999: SET last_update_date = SYSDATE
3000: , last_updated_by = l_userid
3001: , last_update_login = l_loginid
3002: , program_update_date = SYSDATE

Line 3055: UPDATE mtl_transactions_interface

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

Line 3100: UPDATE mtl_transactions_interface

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

Line 3147: UPDATE mtl_transactions_interface

3143: );
3144: END IF;
3145: END LOOP;
3146:
3147: UPDATE mtl_transactions_interface
3148: SET last_update_date = SYSDATE
3149: , last_updated_by = l_userid
3150: , last_update_login = l_loginid
3151: , program_update_date = SYSDATE

Line 3187: UPDATE mtl_transactions_interface

3183: fnd_message.set_name ('INV', 'INV_LOT_TRANSLATE_VALIDATIONS');
3184: l_error_code := fnd_message.get;
3185: END IF;
3186:
3187: UPDATE mtl_transactions_interface
3188: SET last_update_date = SYSDATE
3189: , last_updated_by = l_userid
3190: , last_update_login = l_loginid
3191: , program_update_date = SYSDATE

Line 3216: FROM mtl_transactions_interface

3212: IF (l_line_rec_type.distribution_account_id IS NULL)
3213: THEN
3214: SELECT distribution_account_id
3215: INTO l_dist_acct_id
3216: FROM mtl_transactions_interface
3217: WHERE ROWID = l_line_rec_type.ROWID;
3218:
3219: l_line_rec_type.distribution_account_id := l_dist_acct_id;
3220: END IF;

Line 3269: from mtl_transactions_interface

3265:
3266: --bug#13527319 to skip validation for phantom component which has op_seq_num negative and wip_supply_type = 6
3267: select nvl(operation_seq_num,1 ),nvl(wip_supply_type,1)
3268: into l_operation_seq_num, l_wip_supply_type
3269: from mtl_transactions_interface
3270: where ROWID = l_line_rec_type.ROWID;
3271: IF (l_debug = 1) THEN
3272: inv_log_util.trace('operation_seq_num '||l_operation_seq_num||' l_wip_supply_type '||l_wip_supply_type, 'INV_TXN_MANAGER_PUB', 9);
3273: END IF;

Line 3320: UPDATE MTL_TRANSACTIONS_INTERFACE

3316: END IF;
3317: FND_MESSAGE.set_name('INV', 'INV_NO_CONVERSION_ERR');
3318: l_error_code:= fnd_message.get;
3319:
3320: UPDATE MTL_TRANSACTIONS_INTERFACE
3321: SET LAST_UPDATE_DATE = SYSDATE,
3322: LAST_UPDATED_BY = l_userid,
3323: LAST_UPDATE_LOGIN = l_loginid,
3324: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3335: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3331:
3332: --check for batch error
3333: loaderrmsg('INV_GROUP_ERROR','INV_GROUP_ERROR');
3334:
3335: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3336: SET LAST_UPDATE_DATE = SYSDATE,
3337: LAST_UPDATED_BY = l_userid,
3338: LAST_UPDATE_LOGIN = l_loginid,
3339: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3420: FROM mtl_transactions_interface

3416: IF ( NOT l_current_batch_failed) THEN --350
3417: BEGIN
3418: SELECT demand_source_header_id , demand_source_line
3419: INTO l_dem_hdr_id,l_dem_line_id
3420: FROM mtl_transactions_interface
3421: WHERE
3422: ROWID = l_temp_rowid ;
3423: EXCEPTION
3424: WHEN OTHERS THEN

Line 3432: UPDATE MTL_TRANSACTIONS_INTERFACE

3428: END IF;
3429: l_error_code := 'Error in getting Demand Info';
3430: l_error_exp := 'Error in getting Demand Info';
3431:
3432: UPDATE MTL_TRANSACTIONS_INTERFACE
3433: SET LAST_UPDATE_DATE = SYSDATE,
3434: LAST_UPDATED_BY = l_userid,
3435: LAST_UPDATE_LOGIN = l_loginid,
3436: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3446: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3442: AND PROCESS_FLAG = 1;
3443: --check for batch error
3444: loaderrmsg('INV_GROUP_ERROR','INV_GROUP_ERROR');
3445:
3446: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3447: SET LAST_UPDATE_DATE = SYSDATE,
3448: LAST_UPDATED_BY = l_userid,
3449: LAST_UPDATE_LOGIN = l_loginid,
3450: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3535: UPDATE MTL_TRANSACTIONS_INTERFACE

3531: FND_MESSAGE.set_token('ROUTINE','UE:AVAIL_TO_TRX');
3532: l_error_code := FND_MESSAGE.get;
3533: l_error_exp := l_msg_data;
3534: x_msg_data := l_msg_data;
3535: UPDATE MTL_TRANSACTIONS_INTERFACE
3536: SET LAST_UPDATE_DATE = SYSDATE,
3537: LAST_UPDATED_BY = l_userid,
3538: LAST_UPDATE_LOGIN = l_loginid,
3539: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3550: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3546:
3547: --check for batch error
3548: loaderrmsg('INV_GROUP_ERROR','INV_GROUP_ERROR');
3549:
3550: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3551: SET LAST_UPDATE_DATE = SYSDATE,
3552: LAST_UPDATED_BY = l_userid,
3553: LAST_UPDATE_LOGIN = l_loginid,
3554: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3601: UPDATE MTL_TRANSACTIONS_INTERFACE

3597: FND_MESSAGE.set_token('token1','XACT_QTY1');
3598: l_error_code := FND_MESSAGE.get;
3599: l_error_exp := l_msg_data;
3600: x_msg_data := l_msg_data;
3601: UPDATE MTL_TRANSACTIONS_INTERFACE
3602: SET LAST_UPDATE_DATE = SYSDATE,
3603: LAST_UPDATED_BY = l_userid,
3604: LAST_UPDATE_LOGIN = l_loginid,
3605: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3615: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3611: AND PROCESS_FLAG = 1;
3612: --check for batch error
3613: loaderrmsg('INV_GROUP_ERROR','INV_GROUP_ERROR');
3614:
3615: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3616: SET LAST_UPDATE_DATE = SYSDATE,
3617: LAST_UPDATED_BY = l_userid,
3618: LAST_UPDATE_LOGIN = l_loginid,
3619: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3642: UPDATE MTL_TRANSACTIONS_INTERFACE

3638: FND_MESSAGE.set_token('token1','XACT_QTY1');
3639: l_error_code := FND_MESSAGE.get;
3640: l_error_exp := l_msg_data;
3641: x_msg_data := l_msg_data;
3642: UPDATE MTL_TRANSACTIONS_INTERFACE
3643: SET LAST_UPDATE_DATE = SYSDATE,
3644: LAST_UPDATED_BY = l_userid,
3645: LAST_UPDATE_LOGIN = l_loginid,
3646: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3656: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3652: AND PROCESS_FLAG = 1;
3653: --check for batch error
3654: loaderrmsg('INV_GROUP_ERROR','INV_GROUP_ERROR');
3655:
3656: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3657: SET LAST_UPDATE_DATE = SYSDATE,
3658: LAST_UPDATED_BY = l_userid,
3659: LAST_UPDATE_LOGIN = l_loginid,
3660: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3736: UPDATE MTL_TRANSACTIONS_INTERFACE

3732: l_error_code := FND_MESSAGE.get;
3733: FND_MESSAGE.set_name('INV','INV_QTY_LESS_OR_EQUAL');
3734: l_error_exp := FND_MESSAGE.get;
3735: x_msg_data := l_error_exp;
3736: UPDATE MTL_TRANSACTIONS_INTERFACE
3737: SET LAST_UPDATE_DATE = SYSDATE,
3738: LAST_UPDATED_BY = l_userid,
3739: LAST_UPDATE_LOGIN = l_loginid,
3740: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3750: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3746: AND PROCESS_FLAG = 1;
3747: --check for batch error
3748: loaderrmsg('INV_GROUP_ERROR','INV_GROUP_ERROR');
3749:
3750: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3751: SET LAST_UPDATE_DATE = SYSDATE,
3752: LAST_UPDATED_BY = l_userid,
3753: LAST_UPDATE_LOGIN = l_loginid,
3754: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3798: UPDATE MTL_TRANSACTIONS_INTERFACE

3794: FND_MESSAGE.set_token('token1','XACT_QTY1');
3795: l_error_code := FND_MESSAGE.get;
3796: l_error_exp := l_msg_data;
3797: x_msg_data := l_msg_data;
3798: UPDATE MTL_TRANSACTIONS_INTERFACE
3799: SET LAST_UPDATE_DATE = SYSDATE,
3800: LAST_UPDATED_BY = l_userid,
3801: LAST_UPDATE_LOGIN = l_loginid,
3802: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3812: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3808: AND PROCESS_FLAG = 1;
3809: --check for batch error
3810: loaderrmsg('INV_GROUP_ERROR','INV_GROUP_ERROR');
3811:
3812: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3813: SET LAST_UPDATE_DATE = SYSDATE,
3814: LAST_UPDATED_BY = l_userid,
3815: LAST_UPDATE_LOGIN = l_loginid,
3816: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3838: UPDATE MTL_TRANSACTIONS_INTERFACE

3834: FND_MESSAGE.set_token('token1','XACT_QTY1');
3835: l_error_code := FND_MESSAGE.get;
3836: l_error_exp := l_msg_data;
3837: x_msg_data := l_msg_data;
3838: UPDATE MTL_TRANSACTIONS_INTERFACE
3839: SET LAST_UPDATE_DATE = SYSDATE,
3840: LAST_UPDATED_BY = l_userid,
3841: LAST_UPDATE_LOGIN = l_loginid,
3842: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3852: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3848: AND PROCESS_FLAG = 1;
3849: --check for batch error
3850: loaderrmsg('INV_GROUP_ERROR','INV_GROUP_ERROR');
3851:
3852: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3853: SET LAST_UPDATE_DATE = SYSDATE,
3854: LAST_UPDATED_BY = l_userid,
3855: LAST_UPDATE_LOGIN = l_loginid,
3856: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3893: UPDATE MTL_TRANSACTIONS_INTERFACE

3889: FND_MESSAGE.set_name('INV','INV_ORG_QUANTITY');
3890: l_error_exp := FND_MESSAGE.get;
3891: FND_MESSAGE.set_name('INV','INV_INTERNAL_ERROR');
3892: x_msg_data := l_error_exp;
3893: UPDATE MTL_TRANSACTIONS_INTERFACE
3894: SET LAST_UPDATE_DATE = SYSDATE,
3895: LAST_UPDATED_BY = l_userid,
3896: LAST_UPDATE_LOGIN = l_loginid,
3897: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3907: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

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

Line 3938: UPDATE MTL_TRANSACTIONS_INTERFACE

3934: FND_MESSAGE.set_token('ENTITY1','INV_QUANTITY',l_translate);
3935: FND_MESSAGE.set_token('ENTITY2','AVAIL_TO_TRANSACT',l_translate);
3936: l_error_exp := FND_MESSAGE.get;
3937: x_msg_data := l_error_exp;
3938: UPDATE MTL_TRANSACTIONS_INTERFACE
3939: SET LAST_UPDATE_DATE = SYSDATE,
3940: LAST_UPDATED_BY = l_userid,
3941: LAST_UPDATE_LOGIN = l_loginid,
3942: PROGRAM_UPDATE_DATE = SYSDATE,

Line 3952: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

3948: AND PROCESS_FLAG = 1;
3949: --check for batch error
3950: loaderrmsg('INV_GROUP_ERROR','INV_GROUP_ERROR');
3951:
3952: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3953: SET LAST_UPDATE_DATE = SYSDATE,
3954: LAST_UPDATED_BY = l_userid,
3955: LAST_UPDATE_LOGIN = l_loginid,
3956: PROGRAM_UPDATE_DATE = SYSDATE,

Line 4009: UPDATE MTL_TRANSACTIONS_INTERFACE

4005: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.UPDATE_QUANTITIES');
4006: l_error_code:= fnd_message.get;
4007: l_error_exp :=l_msg_data;
4008: x_msg_data := l_msg_data;
4009: UPDATE MTL_TRANSACTIONS_INTERFACE
4010: SET LAST_UPDATE_DATE = SYSDATE,
4011: LAST_UPDATED_BY = l_userid,
4012: LAST_UPDATE_LOGIN = l_loginid,
4013: PROGRAM_UPDATE_DATE = SYSDATE,

Line 4023: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

4019: AND PROCESS_FLAG = 1;
4020: --check for batch error
4021: loaderrmsg('INV_GROUP_ERROR','INV_GROUP_ERROR');
4022:
4023: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
4024: SET LAST_UPDATE_DATE = SYSDATE,
4025: LAST_UPDATED_BY = l_userid,
4026: LAST_UPDATE_LOGIN = l_loginid,
4027: PROGRAM_UPDATE_DATE = SYSDATE,

Line 4078: UPDATE MTL_TRANSACTIONS_INTERFACE

4074: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.UPDATE_QUANTITIES');
4075: l_error_code:= fnd_message.get;
4076: l_error_exp :=l_msg_data;
4077: x_msg_data := l_msg_data;
4078: UPDATE MTL_TRANSACTIONS_INTERFACE
4079: SET LAST_UPDATE_DATE = SYSDATE,
4080: LAST_UPDATED_BY = l_userid,
4081: LAST_UPDATE_LOGIN = l_loginid,
4082: PROGRAM_UPDATE_DATE = SYSDATE,

Line 4092: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

4088: AND PROCESS_FLAG = 1;
4089: --check for batch error
4090: loaderrmsg('INV_GROUP_ERROR','INV_GROUP_ERROR');
4091:
4092: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
4093: SET LAST_UPDATE_DATE = SYSDATE,
4094: LAST_UPDATED_BY = l_userid,
4095: LAST_UPDATE_LOGIN = l_loginid,
4096: PROGRAM_UPDATE_DATE = SYSDATE,

Line 4147: UPDATE MTL_TRANSACTIONS_INTERFACE

4143:
4144: FND_MESSAGE.SET_NAME('INV','INV_LOCATION_MANDATORY');
4145: l_error_code := FND_MESSAGE.GET;
4146:
4147: UPDATE MTL_TRANSACTIONS_INTERFACE
4148: SET LAST_UPDATE_DATE = SYSDATE,
4149: LAST_UPDATED_BY = l_userid,
4150: LAST_UPDATE_LOGIN = l_loginid,
4151: PROGRAM_UPDATE_DATE = SYSDATE,

Line 4209: UPDATE mtl_transactions_interface

4205: fnd_message.set_name ('INV', 'INV_INT_TMPXFRCODE');
4206: l_error_code := fnd_message.get;
4207: ROLLBACK TO line_validation_svpt;
4208:
4209: UPDATE mtl_transactions_interface
4210: SET last_update_date = SYSDATE
4211: , last_updated_by = l_userid
4212: , last_update_login = l_loginid
4213: , program_update_date = SYSDATE

Line 4282: UPDATE mtl_transactions_interface mti

4278:
4279: --check for batch error at line validation
4280: loaderrmsg ('INV_GROUP_ERROR', 'INV_GROUP_ERROR');
4281:
4282: UPDATE mtl_transactions_interface mti
4283: SET last_update_date = SYSDATE
4284: , last_updated_by = l_userid
4285: , last_update_login = l_loginid
4286: , program_update_date = SYSDATE

Line 4294: FROM mtl_transactions_interface mti2

4290: WHERE transaction_header_id = l_header_id
4291: AND process_flag = 1
4292: AND EXISTS
4293: (SELECT 'Y'
4294: FROM mtl_transactions_interface mti2
4295: WHERE mti2.transaction_header_id = l_header_id
4296: AND mti2.process_flag = 3
4297: AND mti2.error_code IS NOT NULL
4298: AND mti2.transaction_batch_id = mti.transaction_batch_id);

Line 4303: FROM mtl_transactions_interface mti2

4299:
4300: /* Commented following and added EXISTS clause above for bug 8444982
4301: AND transaction_batch_id IN (
4302: SELECT DISTINCT mti2.transaction_batch_id
4303: FROM mtl_transactions_interface mti2
4304: WHERE mti2.transaction_header_id = l_header_id
4305: AND mti2.process_flag = 3
4306: AND mti2.ERROR_CODE IS NOT NULL);
4307: */

Line 4318: FROM mtl_transactions_interface

4314: --check if all records have been failed by the Line Validation
4315: BEGIN
4316: SELECT transaction_source_type_id
4317: INTO l_source_type_id
4318: FROM mtl_transactions_interface
4319: WHERE transaction_header_id = l_header_id
4320: AND process_flag = 1
4321: AND ROWNUM < 2;
4322: EXCEPTION

Line 4365: UPDATE mtl_transactions_interface mti

4361: --bug 3727791
4362: --check for batch error at line validation
4363: loaderrmsg ('INV_GROUP_ERROR', 'INV_GROUP_ERROR');
4364:
4365: UPDATE mtl_transactions_interface mti
4366: SET last_update_date = SYSDATE
4367: , last_updated_by = l_userid
4368: , last_update_login = l_loginid
4369: , program_update_date = SYSDATE

Line 4377: FROM mtl_transactions_interface mti2

4373: WHERE transaction_header_id = l_header_id
4374: AND process_flag = 1
4375: AND EXISTS
4376: (SELECT 'Y'
4377: FROM mtl_transactions_interface mti2
4378: WHERE mti2.transaction_header_id = l_header_id
4379: AND mti2.process_flag = 3
4380: AND mti2.error_code IS NOT NULL
4381: AND mti2.transaction_batch_id = mti.transaction_batch_id);

Line 4386: FROM mtl_transactions_interface mti2

4382:
4383: /* Commented following and added EXISTS clause above for bug 8444982
4384: AND transaction_batch_id IN (
4385: SELECT DISTINCT mti2.transaction_batch_id
4386: FROM mtl_transactions_interface mti2
4387: WHERE mti2.transaction_header_id = l_header_id
4388: AND mti2.process_flag = 3
4389: AND mti2.ERROR_CODE IS NOT NULL);
4390: */

Line 4401: FROM mtl_transactions_interface

4397: --check if all records have been failed by the wip API.
4398: BEGIN
4399: SELECT transaction_source_type_id
4400: INTO l_source_type_id
4401: FROM mtl_transactions_interface
4402: WHERE transaction_header_id = l_header_id
4403: AND process_flag = 1
4404: AND ROWNUM < 2;
4405: EXCEPTION

Line 4910: UPDATE mtl_transactions_interface

4906: ELSE
4907: ROLLBACK WORK;
4908: END IF;
4909:
4910: UPDATE mtl_transactions_interface
4911: SET last_update_date = SYSDATE
4912: , last_updated_by = l_userid
4913: , last_update_login = l_loginid
4914: , program_update_date = SYSDATE

Line 5254: l_src_code mtl_transactions_interface.transaction_source_name%TYPE;

5250: l_sub_code VARCHAR2 (11);
5251: l_lotnum VARCHAR2 (80); -- changed lot_number to 80, inconv
5252: --Bug #5086940
5253: --Changed the length to correspond to transaction_source_name
5254: l_src_code mtl_transactions_interface.transaction_source_name%TYPE;
5255: l_xfrsub VARCHAR2 (11);
5256: l_rev VARCHAR2 (4);
5257: l_srclineid VARCHAR2 (40);
5258: l_trxdate DATE;

Line 5856: l_src_code mtl_transactions_interface.transaction_source_name%TYPE;

5852: l_srctypeid NUMBER;
5853: l_srcid NUMBER;
5854: --Bug #5086940
5855: --Changed the length to correspond to transaction_source_name
5856: l_src_code mtl_transactions_interface.transaction_source_name%TYPE;
5857: l_srclineid VARCHAR2 (40);
5858: l_deliveryid NUMBER;
5859: l_trx_qty NUMBER;
5860: l_trxdate DATE;

Line 6406: UPDATE mtl_transactions_interface

6402: THEN
6403:
6404: l_error_code := fnd_message.get;
6405:
6406: UPDATE mtl_transactions_interface
6407: SET last_update_date = SYSDATE
6408: , last_updated_by = l_userid
6409: , last_update_login = l_loginid
6410: , program_update_date = SYSDATE

Line 6422: UPDATE mtl_transactions_interface

6418: AND organization_id = l_org_id
6419: AND inventory_item_id = l_item_id
6420: AND NVL (subinventory_code, '@@@@') = NVL (l_sub_code, '@@@@');
6421:
6422: UPDATE mtl_transactions_interface
6423: SET last_update_date = SYSDATE
6424: , last_updated_by = l_userid
6425: , last_update_login = l_loginid
6426: , program_update_date = SYSDATE