APPS.CSE_FAC_INSERVICE_PKG dependencies on CSI_TXN_ERRORS

Line 271: FROM csi_txn_errors

267:
268: BEGIN
269: SELECT transaction_error_id
270: INTO l_txn_error_id
271: FROM csi_txn_errors
272: WHERE transaction_id = inservice_txn_rec.transaction_id
273: AND source_type = 'CSENIISEI'
274: AND rownum = 1;
275:

Line 276: UPDATE csi_txn_errors

272: WHERE transaction_id = inservice_txn_rec.transaction_id
273: AND source_type = 'CSENIISEI'
274: AND rownum = 1;
275:
276: UPDATE csi_txn_errors
277: SET error_text = l_error_message,
278: last_update_date = sysdate,
279: last_updated_by = fnd_global.user_id,
280: last_update_login = fnd_global.login_id

Line 319: FROM csi_txn_errors

315:
316: BEGIN
317: SELECT transaction_error_id
318: INTO l_txn_error_id
319: FROM csi_txn_errors
320: WHERE transaction_id = inservice_txn_rec.transaction_id
321: AND source_type = 'CSENIISEI'
322: AND rownum = 1;
323:

Line 324: UPDATE csi_txn_errors

320: WHERE transaction_id = inservice_txn_rec.transaction_id
321: AND source_type = 'CSENIISEI'
322: AND rownum = 1;
323:
324: UPDATE csi_txn_errors
325: SET error_text = l_error_message,
326: last_update_date = sysdate,
327: last_updated_by = fnd_global.user_id,
328: last_update_login = fnd_global.login_id

Line 1144: FROM csi_txn_errors

1140: CURSOR txn_cur IS
1141: SELECT transaction_error_id,
1142: transaction_type_id,
1143: message_string
1144: FROM csi_txn_errors
1145: WHERE processed_flag = 'B'
1146: AND error_stage = 'FA_UPDATE'
1147: AND source_type = 'FA_UNIT_ADJUSTMENT_NORMAL';
1148:

Line 1293: UPDATE csi_txn_errors

1289: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1290: RAISE fnd_api.g_exc_error;
1291: END IF;
1292:
1293: UPDATE csi_txn_errors
1294: SET processed_flag = 'S',
1295: source_group_ref_id = fnd_global.conc_request_id,
1296: last_update_date = sysdate,
1297: last_updated_by = fnd_global.user_id

Line 1307: UPDATE csi_txn_errors

1303: WHEN fnd_api.g_exc_error THEN
1304:
1305: rollback to eachtxn;
1306:
1307: UPDATE csi_txn_errors
1308: SET error_text = x_error_message,
1309: source_group_ref_id = fnd_global.conc_request_id,
1310: last_update_date = sysdate,
1311: last_updated_by = fnd_global.user_id