APPS.CSE_FAC_INSERVICE_PKG dependencies on CSI_TXN_ERRORS

Line 258: FROM csi_txn_errors

254:
255: BEGIN
256: SELECT transaction_error_id
257: INTO l_txn_error_id
258: FROM csi_txn_errors
259: WHERE transaction_id = inservice_txn_rec.transaction_id
260: AND source_type = 'CSENIISEI'
261: AND rownum = 1;
262:

Line 263: UPDATE csi_txn_errors

259: WHERE transaction_id = inservice_txn_rec.transaction_id
260: AND source_type = 'CSENIISEI'
261: AND rownum = 1;
262:
263: UPDATE csi_txn_errors
264: SET error_text = l_error_message,
265: last_update_date = sysdate,
266: last_updated_by = fnd_global.user_id,
267: last_update_login = fnd_global.login_id

Line 306: FROM csi_txn_errors

302:
303: BEGIN
304: SELECT transaction_error_id
305: INTO l_txn_error_id
306: FROM csi_txn_errors
307: WHERE transaction_id = inservice_txn_rec.transaction_id
308: AND source_type = 'CSENIISEI'
309: AND rownum = 1;
310:

Line 311: UPDATE csi_txn_errors

307: WHERE transaction_id = inservice_txn_rec.transaction_id
308: AND source_type = 'CSENIISEI'
309: AND rownum = 1;
310:
311: UPDATE csi_txn_errors
312: SET error_text = l_error_message,
313: last_update_date = sysdate,
314: last_updated_by = fnd_global.user_id,
315: last_update_login = fnd_global.login_id

Line 1109: FROM csi_txn_errors

1105: CURSOR txn_cur IS
1106: SELECT transaction_error_id,
1107: transaction_type_id,
1108: message_string
1109: FROM csi_txn_errors
1110: WHERE processed_flag = 'B'
1111: AND error_stage = 'FA_UPDATE'
1112: AND source_type = 'FA_UNIT_ADJUSTMENT_NORMAL';
1113:

Line 1258: UPDATE csi_txn_errors

1254: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1255: RAISE fnd_api.g_exc_error;
1256: END IF;
1257:
1258: UPDATE csi_txn_errors
1259: SET processed_flag = 'S',
1260: source_group_ref_id = fnd_global.conc_request_id,
1261: last_update_date = sysdate,
1262: last_updated_by = fnd_global.user_id

Line 1272: UPDATE csi_txn_errors

1268: WHEN fnd_api.g_exc_error THEN
1269:
1270: rollback to eachtxn;
1271:
1272: UPDATE csi_txn_errors
1273: SET error_text = x_error_message,
1274: source_group_ref_id = fnd_global.conc_request_id,
1275: last_update_date = sysdate,
1276: last_updated_by = fnd_global.user_id