241: raise validate_delivery_failed;
242: END IF;
243: END IF; */
244:
245: UPDATE wsh_transactions_history
246: SET transaction_status = 'ER'
247: WHERE entity_type = 'DLVY_INT'
248: AND entity_number = to_char(p_delivery_interface_id)
249: AND document_type = 'SA';
438: ELSE
439: -- Return status success
440: -- 1. Need to update the txn. history record to success
441: -- Because all data(dlvy, details, trip, stop) have been successfully moved to base tables
442: UPDATE wsh_transactions_history
443: SET transaction_status = 'SC',
444: entity_number = l_delivery_name,
445: entity_type = 'DLVY'
446: WHERE entity_type = 'DLVY_INT'