193: END IF;
194: RAISE FND_API.G_EXC_ERROR;
195: END IF;
196: select count(*) into l_exists
197: FROM wsh_transactions_history
198: WHERE document_number = p_delivery_rec.document_number
199: AND document_type = 'SA'
200: AND document_direction = 'I';
201:
1103: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1104: RAISE FND_API.G_EXC_ERROR;
1105: END IF;
1106:
1107: INSERT INTO wsh_transactions_history (
1108: TRANSACTION_ID,
1109: DOCUMENT_TYPE,
1110: DOCUMENT_NUMBER,
1111: DOCUMENT_DIRECTION,