APPS.CSE_ASSET_MOVE_PKG dependencies on CSI_TXN_ERRORS

Line 1181: FROM csi_txn_errors

1177: cii.serial_number IS NULL) ;
1178:
1179: CURSOR csi_txn_error_cur (c_transaction_id IN NUMBER) IS
1180: SELECT transaction_error_id
1181: FROM csi_txn_errors
1182: WHERE transaction_id = c_transaction_id
1183: AND source_type = 'ASSET_MOVE' ;
1184:
1185: l_txn_qty NUMBER ;

Line 1369: UPDATE csi_txn_errors

1365: l_msg_count,
1366: l_msg_data,
1367: l_txn_error_id);
1368: ELSE
1369: UPDATE csi_txn_errors
1370: SET error_text = l_trx_error_rec.error_text ,
1371: source_group_ref_id = p_conc_request_id,
1372: last_update_date = sysdate
1373: WHERE transaction_error_id = l_txn_error_id ;

Line 1404: UPDATE csi_txn_errors

1400: l_trx_error_rec, l_return_status, l_msg_count,l_msg_data,
1401: l_txn_error_id);
1402: ELSE
1403: SELECT sysdate INTO l_sysdate FROM DUAL ;
1404: UPDATE csi_txn_errors
1405: SET error_text = l_trx_error_rec.error_text ,
1406: source_group_ref_id = p_conc_request_id,
1407: last_update_date = l_sysdate
1408: WHERE transaction_error_id = l_txn_error_id ;

Line 2663: FROM csi_txn_errors

2659:
2660: CURSOR csi_txn_error_cur (c_transaction_id IN NUMBER)
2661: IS
2662: SELECT transaction_error_id
2663: FROM csi_txn_errors
2664: WHERE transaction_id = c_transaction_id
2665: AND source_type = 'ASSET_MOVE' ;
2666:
2667: BEGIN

Line 3036: UPDATE csi_txn_errors

3032: (l_api_version, l_init_msg_list, l_commit, l_validation_level,
3033: l_trx_error_rec, l_return_status, l_msg_count,l_msg_data,
3034: l_txn_error_id);
3035: ELSE
3036: UPDATE csi_txn_errors
3037: SET error_text = l_trx_error_rec.error_text ,
3038: source_group_ref_id = p_conc_request_id,
3039: last_update_date = l_sysdate
3040: WHERE transaction_error_id = l_txn_error_id ;

Line 3077: UPDATE csi_txn_errors

3073: (l_api_version, l_init_msg_list, l_commit, l_validation_level,
3074: l_trx_error_rec, l_return_status, l_msg_count,l_msg_data,
3075: l_txn_error_id);
3076: ELSE
3077: UPDATE csi_txn_errors
3078: SET error_text = l_trx_error_rec.error_text ,
3079: source_group_ref_id = p_conc_request_id,
3080: last_update_date = l_sysdate
3081: WHERE transaction_error_id = l_txn_error_id ;

Line 3390: FROM csi_txn_errors

3386:
3387: CURSOR csi_txn_error_cur (c_transaction_id IN NUMBER)
3388: IS
3389: SELECT transaction_error_id
3390: FROM csi_txn_errors
3391: WHERE transaction_id = c_transaction_id
3392: AND source_type = 'ASSET_MOVE' ;
3393:
3394: BEGIN

Line 3600: UPDATE csi_txn_errors

3596: (1.0, fnd_api.g_true, fnd_api.g_false, fnd_api.g_valid_level_full,
3597: l_trx_error_rec, l_return_status, l_msg_count,l_msg_data,
3598: l_txn_error_id);
3599: ELSE
3600: UPDATE csi_txn_errors
3601: SET error_text = l_trx_error_rec.error_text ,
3602: source_group_ref_id = p_conc_request_id,
3603: last_update_date = l_sysdate
3604: WHERE transaction_error_id = l_txn_error_id ;

Line 3638: UPDATE csi_txn_errors

3634: (1.0, fnd_api.g_true, fnd_api.g_false, fnd_api.g_valid_level_full,
3635: l_trx_error_rec, l_return_status, l_msg_count,l_msg_data,
3636: l_txn_error_id);
3637: ELSE
3638: UPDATE csi_txn_errors
3639: SET error_text = l_trx_error_rec.error_text ,
3640: source_group_ref_id = p_conc_request_id,
3641: last_update_date = l_sysdate
3642: WHERE transaction_error_id = l_txn_error_id ;

Line 4183: FROM csi_txn_errors

4179: BEGIN
4180:
4181: SELECT transaction_error_id
4182: INTO l_error_id
4183: FROM csi_txn_errors
4184: WHERE source_type = 'CSEFAMOV'
4185: AND source_id = l_error_rec.source_id
4186: AND rownum < 2;
4187:

Line 4188: UPDATE csi_txn_errors

4184: WHERE source_type = 'CSEFAMOV'
4185: AND source_id = l_error_rec.source_id
4186: AND rownum < 2;
4187:
4188: UPDATE csi_txn_errors
4189: SET error_text = l_error_rec.error_text,
4190: last_updated_by = fnd_global.user_id,
4191: last_update_login = fnd_global.login_id,
4192: last_update_date = sysdate