APPS.CSE_ASSET_MOVE_PKG dependencies on CSI_TXN_ERRORS

Line 1196: FROM csi_txn_errors

1192: cii.serial_number IS NULL) ;
1193:
1194: CURSOR csi_txn_error_cur (c_transaction_id IN NUMBER) IS
1195: SELECT transaction_error_id
1196: FROM csi_txn_errors
1197: WHERE transaction_id = c_transaction_id
1198: AND source_type = 'ASSET_MOVE' ;
1199:
1200: l_txn_qty NUMBER ;

Line 1384: UPDATE csi_txn_errors

1380: l_msg_count,
1381: l_msg_data,
1382: l_txn_error_id);
1383: ELSE
1384: UPDATE csi_txn_errors
1385: SET error_text = l_trx_error_rec.error_text ,
1386: source_group_ref_id = p_conc_request_id,
1387: last_update_date = sysdate
1388: WHERE transaction_error_id = l_txn_error_id ;

Line 1419: UPDATE csi_txn_errors

1415: l_trx_error_rec, l_return_status, l_msg_count,l_msg_data,
1416: l_txn_error_id);
1417: ELSE
1418: SELECT sysdate INTO l_sysdate FROM DUAL ;
1419: UPDATE csi_txn_errors
1420: SET error_text = l_trx_error_rec.error_text ,
1421: source_group_ref_id = p_conc_request_id,
1422: last_update_date = l_sysdate
1423: WHERE transaction_error_id = l_txn_error_id ;

Line 2742: FROM csi_txn_errors

2738:
2739: CURSOR csi_txn_error_cur (c_transaction_id IN NUMBER)
2740: IS
2741: SELECT transaction_error_id
2742: FROM csi_txn_errors
2743: WHERE transaction_id = c_transaction_id
2744: AND source_type = 'ASSET_MOVE' ;
2745:
2746: BEGIN

Line 3115: UPDATE csi_txn_errors

3111: (l_api_version, l_init_msg_list, l_commit, l_validation_level,
3112: l_trx_error_rec, l_return_status, l_msg_count,l_msg_data,
3113: l_txn_error_id);
3114: ELSE
3115: UPDATE csi_txn_errors
3116: SET error_text = l_trx_error_rec.error_text ,
3117: source_group_ref_id = p_conc_request_id,
3118: last_update_date = l_sysdate
3119: WHERE transaction_error_id = l_txn_error_id ;

Line 3156: UPDATE csi_txn_errors

3152: (l_api_version, l_init_msg_list, l_commit, l_validation_level,
3153: l_trx_error_rec, l_return_status, l_msg_count,l_msg_data,
3154: l_txn_error_id);
3155: ELSE
3156: UPDATE csi_txn_errors
3157: SET error_text = l_trx_error_rec.error_text ,
3158: source_group_ref_id = p_conc_request_id,
3159: last_update_date = l_sysdate
3160: WHERE transaction_error_id = l_txn_error_id ;

Line 3469: FROM csi_txn_errors

3465:
3466: CURSOR csi_txn_error_cur (c_transaction_id IN NUMBER)
3467: IS
3468: SELECT transaction_error_id
3469: FROM csi_txn_errors
3470: WHERE transaction_id = c_transaction_id
3471: AND source_type = 'ASSET_MOVE' ;
3472:
3473: BEGIN

Line 3679: UPDATE csi_txn_errors

3675: (1.0, fnd_api.g_true, fnd_api.g_false, fnd_api.g_valid_level_full,
3676: l_trx_error_rec, l_return_status, l_msg_count,l_msg_data,
3677: l_txn_error_id);
3678: ELSE
3679: UPDATE csi_txn_errors
3680: SET error_text = l_trx_error_rec.error_text ,
3681: source_group_ref_id = p_conc_request_id,
3682: last_update_date = l_sysdate
3683: WHERE transaction_error_id = l_txn_error_id ;

Line 3717: UPDATE csi_txn_errors

3713: (1.0, fnd_api.g_true, fnd_api.g_false, fnd_api.g_valid_level_full,
3714: l_trx_error_rec, l_return_status, l_msg_count,l_msg_data,
3715: l_txn_error_id);
3716: ELSE
3717: UPDATE csi_txn_errors
3718: SET error_text = l_trx_error_rec.error_text ,
3719: source_group_ref_id = p_conc_request_id,
3720: last_update_date = l_sysdate
3721: WHERE transaction_error_id = l_txn_error_id ;

Line 4407: FROM csi_txn_errors

4403: BEGIN
4404:
4405: SELECT transaction_error_id
4406: INTO l_error_id
4407: FROM csi_txn_errors
4408: WHERE source_type = 'CSEFAMOV'
4409: AND source_id = l_error_rec.source_id
4410: AND rownum < 2;
4411:

Line 4412: UPDATE csi_txn_errors

4408: WHERE source_type = 'CSEFAMOV'
4409: AND source_id = l_error_rec.source_id
4410: AND rownum < 2;
4411:
4412: UPDATE csi_txn_errors
4413: SET error_text = l_error_rec.error_text,
4414: last_updated_by = fnd_global.user_id,
4415: last_update_login = fnd_global.login_id,
4416: last_update_date = sysdate